Custom Grouped Crosstab Report

Purpose: Calculate the Uncontrolled, Controlled, and % Removal for each compound that was emitted from all production in the report folder. The report takes into account all processes that are present in the current report folder and all sub-folders. The point source emissions for each process are calculated based upon the maximum number of batches that can be made in a single year. The estimated number of batches for each process is displayed on a second worksheet in the report.

Description: All production records are grouped based on a customizable list of fields (Activity Type, Batch Name, Vent ID, …) and totaled. The final results are reported in accordance to the selected Classification Set. For each compound the Uncontrolled, Controlled, and % Removal is listed. Output from the analysis is written to Excel and in the form of a cross tab matrix. Selective data field groupings are available to be configured by the user including (Vessel Name, and EM File Name, Activity Type, Batch Name, EM File Path, Equipment Unit, Process Name, Product Name, Recipe Step, and Vent ID).

Additional Requirements: A Report Classification Set must be selected from the list of existing Classification Sets. Grouping fields are optionally selected and ordered by the user. All settings are saved with the report document ready to run the next time.

Application: This report displays emissions from (1) Point Sources as they exist in basic Emission Master process (filling, heating, …), (2) Storage Tank, (3) Combustion, and (4) Fugitive operations.