Sept 15, 2004 Using the NONROAD Post-Processing Tools These are MS-Access utilities that read in one or more NONROAD .OUT files from a single directory, allow you to select specific horsepower ranges and equipment types, and calculate emissions for the equipment of interest. One possible use of these tools is to allow direct comparisons of county/SCC aggregated emissions from the NONROAD raw output (.OUT) files with the Reporting Utility NIF outputs to see if the NIF output error shows up for any SCC in any county. For more information about this NIF output error see the description following the Post-Processor instructions below. There are four similar tools that each process (aggregate) the data in the .OUT files from NONROAD model runs. Access 97 versions: - NONRDany.mdb processes the .OUT files from Draft NONROAD2002a and earlier. - NR753any.mdb processes the .OUT files from Draft NONROAD2004. (This handles the new 75 and 1200 Hp bins and the use of the field name SO2 instead of SOx.) Access 2000 versions: - NONRDany-2k.mdb processes the .OUT files from Draft NONROAD2002a and earlier. - NR753any-2k.mdb processes the .OUT files from Draft NONROAD2004. (This handles the new 75 and 1200 Hp bins and the use of the field name SO2 instead of SOx.) CAUTION #1: Before running either tool, PLEASE copy the original MDB file to some name of your choice, so you always leave a clean original MDB file for yourself or others to work from. E.g., copy NONRDany.mdb to MI02base.MDB or whatever name makes sense for your current use. CAUTION #2: These tools import ALL .OUT files in whatever folder you choose that match the four character file spec (step 2 below) that you enter. So if you only want to import one or a few of those files, you need to either (a) move/copy the desired .OUT files to some other folder or (b) temporarily rename the unwanted .OUT files to some other extension, such as .OUx. Instructions: 1) Open the Access .MDB file for version of NONROAD .OUT files you have, and type a brief scenario description into the "Study" field. You should ignore the "Scenario" fields. Then hit Tab to get to the next step. 2) When you hit the Tab key, you are first asked if you want to add the study. Click Yes. In the "Location of output files" box, type in or use the Browse button to locate the folder where your desired .OUT file(s) are. Then fill in the Scenario ID box with the first four characters of the desired OPT filenames. The "?" wildcard is acceptable. So if you want to import all .OUT files in the chosen folder, you would type "????" (without the quotes) into the Scenario ID box. Or you can specify some or all of the four characters, such as "WI??" or "TX02". If you're curious, the reason only four characters are specified here is that these tools are modified versions of a tool that was originally designed to find the 4-digit year in the second half of the filename (last four characters before the dot, such as "MISI2002.OPT." NOTE: If you get an error message when attempting to specify/locate the directory from which to import the output files, please refer to the section below on Troubleshooting. 3) Click the [Import] button. You should see a counter start going, counting up all the records that are being imported. These go into a table called T_emissions. 4) When the importing is done, you can get some simple totals using the [Emissions by Year] or possibly the [Crosstab Report] buttons. To get more detailed results see Step 5. NOTE: We do not support the [Excel] export button. If you wish to put your query results into a spreadsheet, you can simply Select All (Ctl-A), then Copy (Ctl-C), and then go to Excel and Paste the results into a spreadsheet. 5) Getting more detailed results, such as emissions by County and SCC, can be done as follows: a) Close Access. b) Open Access, and Choose File: Open..., find the mdb file you created above, but HOLD DOWN the SHIFT KEY while you double-click the filename or while you click on [OK]. This gives you access to all the tables and queries in the database, and allows you to create new queries. c) To get emissions by County & SCC, go to the Queries tab and Open the pre-made query called "qCtySCC". d) If you wish to create additional queries for other purposes if you are familiar with MS-Access. If not familiar with Access queries, you still might be able to create them simply by looking at the Design of the qCtySCC query and modifying it. But first you should make a copy of that query -- while looking at the list of queries in the Queries tab, select qCtySCC, copy it (Ctl-C), and then paste it (Ctl-V) giving it a different name when prompted to do so. Troubleshooting It is possible that a necessary file is missing from the System registry. After exiting from all failed programs, ensure that a file named MSCOMCTL.OCX exists in the C:\Windows\System directory. If not, this file is available from EPA. To get it into the system registry: From the start menu, choose Run and in the dialog box type (without the quotes) "regsvr32 c:\windows\system\mscomctl.ocx" --------------------------------------------------------------------- Questions/Problems: nonroad@epa.gov U.S. Environmental Protection Agency Assessment and Standards Division Air Quality and Modeling Center 2000 Traverwood Drive Ann Arbor, MI 48105 ===================================================================== Cautionary Note regarding NIF Output from Draft NONROAD2002a and Draft NONROAD2004 NOTE: These issues do not affect inventories generated with NMIM, since NMIM does not use the NONROAD Reporting Utility. The following issues apply to both the NIF 3 export function in version 3.0 of the NONROAD Reporting Utility and the NIF 2 export function in version 2.4a of the Reporting Utility (as well as the earlier version 2.2a of the Reporting Utility that was included with Draft NONROAD2002a). These have been distributed as part of the Draft NONROAD2004 model at http://www.epa.gov/otaq/nonrdmdl.htm (and earlier as part of Draft NONROAD2002a). 1) The NIF export function of the Reporting Utility does not export EM records for evaporative emissions that were less than 0.0001.  This results in very small or insignificant changes in the inventories. In the NIF 2 export function in version 2.4a of the Reporting Utility the same issue also applies to exhaust emissions. 2) For some as yet undetermined reason the NIF export function sometimes multiplies the HC output by 100 for one or a few equipment types (SCCs). The SCCs affected are not consistent. Thus we recommend at least spot checking the NIF HC outputs by comparing the NIF HC totals to the HC totals from the main reporting utility reports or to the raw model outputs contained in the *.OUT files generated by the core model. Additionally, if these totals indicate any significant difference, then the inventory values can be compared at the SCC level to determine where specifically the error occurred. EPA is making available on the NONROAD model web site a postprocessing tool to help make direct comparisons of county/SCC aggregated emissions from the NONROAD raw output (.OUT) files with the Reporting Utility NIF outputs. =====================================================================