Unit 14 – Generate Standard HMGP Reports Overview Task 1: Generate Reports from the NEMIS Wide Management Reporting Tool Task 2: Generate Reports from the Mitigation - Admin - Area References for Generating Standard Reports Save a Report in a Different File Type Overview TheNEMIS-MTGenerate Standard HMGP Reports process allows FEMA and Grantee users to monitor HMGP informationone disaster at a time. NOTE: To prepare ad hoc and cross-disaster reports, use the Enterprise Data Warehouse (EDW). Table 14-1 provides an overview of the process. Table 14-1: Generate Standard HMGP Reports Purpose: Produce reports of HMGP information When does it start? Throughout the disaster response Who does it? FEMA and Grantee users How is it done? Execute two tasks: Task 1: Generate Reports from the NEMIS Wide Management Reporting Tool Task 2: Generate Reports from the Mitigation - Admin Area The system provides standard format reports that may be generated at any time. Table 14-2 provides the list of NEMIS-MT processes and the corresponding system reports. Table 14-2: NEMIS-MT Process - System Reports – NEMIS Wide NEMIS-MT PROCESS SYSTEM REPORT Unit 3: Manage Disaster Information Disaster Overview Unit 4: Manage MT Plans Repository Grantee HMGP Administrative Plan, Multihazard Mitigation Plan Unit 5: Manage Funding Estimate Funding Estimate Funding Estimate Budget Planning Funding Estimate Financial Activity Unit 6: Manage Project Applications Application Development Environmental Report Project Cost Line Item Project Non-Federal Share Property Site Inventory State Application Unit 7: Manage Eligibility Determination Federal Eligibility Work Packets Project Eligibility *Project Worksheet Report Unit 8: Manage Amendments Application Development Environmental Report Project Cost Line Item Project Non-Federal Share Property Site Inventory State Application Unit 10: Manage Allocations and Obligations Allocation Request Allocation Request with Signature Fiscal Year Management Report Obligation Obligation with Signatures Unit 11: Manage Project and Program Oversight Tasks Field Survey Full Project History Project Management Project Status Quarterly Report by Project Quarterly Report Tracking Unit 12: Manage Project Closeout Project Closeout Unit 13: Manage Program Closeout Disaster Closeout *The Project Worksheet Report is listed under the Infrastructure Support (IS) folder in the NEMIS Wide Management Reporting Tool. Task 1: Generate Reports from the NEMIS Wide Management Reporting Tool 1. On the NEMIS menu bar, click on NEMIS Wide -Management Reporting-Management Reporting . 2. The NEMIS Wide Management Reporting Tool is displayed. 3. To generate a standard Mitigation report, complete Steps 3a - 3i. a. Double-click the Mitigation (MT) folder. The list of Mitigation Reports is displayed. b. Double-click on a Mitigation report. The Select Disaster window is displayed. c. In the Disaster field, enter the Disaster Number you wish to generate reports for. d. Click the OK button. The MT Report Generator is displayed. e. The top portion of the screen provides the report criteria fields. Enter a selection in each field. HINT: Use the SORT, FILTER, and FIND buttons to refine the report criteria. In the Sort, Filter or Find window, enter the requested information to reorder, select, or locate information. f. Click the RETRIEVE button. The Mitigation report is displayed. g. Use the scroll bars to view the entire report. h. If you need a hard copy of the report, click the PRINT button. i. Click the CLOSE button.The NEMIS Wide Management Reporting Tool is displayed. 4. To generate a standard Infrastructure Support (IS) report, complete Steps 4a - 4g. a. Double-click the Infrastructure Support (IS) folder. The list of Infrastructure Support Reports is displayed. b. Double-click on an Infrastructure Support report. The Report Generator is displayed. c. The top portion of the screen provides the report criteria fields. Enter a selection in each field. d. Click the RETRIEVE button.The Infrastructure Support report is displayed. e. Use the scroll bars to view the entire report. f. If you need a hard copy of the report, click the PRINT button. g. Click the CLOSE button. The NEMIS Wide Management Reporting Tool is displayed. 5. To generate a standard NEMIS-Wide (NW) report, complete Steps 5a - 5g. a. Double-click the Infrastructure (IS) folder. The list of NEMIS-Wide (NW) Reports is displayed . b. Double-click on a NEMISWide report. The Report Generator is displayed. c. The top portion of the screen provides the report criteria fields. Enter a selection in each field. d. Click the RETRIEVE button. The NEMIS-Wide report is displayed. e. Use the scroll bars to view the entire report. f. If you need a hard copy of the report, click the PRINT button. g. Click the CLOSE button. The NEMIS Wide Management Reporting Tool is displayed. Task 2: Generate Reports from the Mitigation -Admin-Area 1. To generate the Financial Reconciliation Report, complete Steps 1a - 1e. a. On theMITIGATION menu, click on Admin-Financial Reconciliation Report. b. The blank Reconciliation Analysis Report is displayed. c. The top portion of the screen provides the report criteria fields. Enter a selection in each field. d. Click the RETRIEVE button. The generated Reconciliation Analysis Report is displayed. e. If you need a hard copy of the report, click the PRINT button. 2. To generate the Benefit Cost Report, complete Steps 2a - 2e. a. On theMITIGATION menu, click on Admin-Benefit Cost Report. b. The blank Benefit Cost Report is displayed. c. The top portion of the screen provides the report criteria fields. Enter a selection in each field. d. Click the RETRIEVE button. The generated Benefit Cost Report is displayed. e. If you need a hard copy of the report, click the PRINT button. References for Generating Standard Reports Save a Report in a Different File Type Reports can be saved in a different file type whenever the SAVE AS button is available. CAUTION: Once a report is saved in a different file type, the report is no longer connected to the system database. If you make a change to the report, it will not update the information in the system database. If there is a change in the system database, the report you saved as a different file will not reflect the latest information. 1. To save a report as an HTML table, complete Steps 1a - 1g. HINT: Not all reports, especially the Property Site Inventory (PSI), will format well as an HTML table. In such cases, try using Excel5 with Headers instead. a. From any generated report screen, click the SAVE AS button. The Save As dialog box is displayed. b. In the Save as type field, click the drop-down list. Select "HTML Table" c. In the Save in field, navigate to the folder where you wish to save the HTML file. d. In the File name field, enter a descriptive file name. e. Click the SAVE button. f. Navigate to the HTML file you just saved. g. Double-click the file name. The report is displayed as a table in an HTML page . 2. To save a report as a Word document, complete Steps 2a - 2j. a. Execute Steps 1a - 1g. b. On the menu bar of the HTML page, click File -Edit with Microsoft Office Word . c. The document opens as a Microsoft Word file. d. On the top left part of the screen, click the Office button. e. Select Save As - Word Document. The Save As dialog box is displayed. f. In the Save in field, navigate to the folder where you wish to save the Microsoft Word file. g. In the File name field, enter a descriptive file name. h. Click the SAVE button. i. Navigate to the Microsoft Word file you just saved. j. Double-click the file name. The report is displayed as a Word document. 3. To save a report as an Excel 5 Document with Headers, complete Steps 3a - 3g. a. From any generated report screen, click the SAVE AS button. The Save As dialog box is displayed. b. In the Save as type field, click the drop-down list. Select "Excel 5 with headers" . c. In the Save in field, navigate to the folder where you wish to save the Excel file. d. In the File name field, enter a descriptive file name. e. Click the SAVE button. f. Navigate to the Excel file you just saved. g. Double-click the file name. The report is displayed as an Excel spreadsheet . NOTE: The system provides many other file formats for saving the report file. Select the one that suits your documentation needs.