Emissions Analysis in Excel

Process emissions can be output as an Excel workbook in such a way that several analysis views are provided through six different worksheets.  A description of each worksheet is provided here. 

Worksheet is broken into three parts.  The top part includes basic information from the Title Page including the Product, Process Name, Process Cycle Time, File Date, File Name, and Comments. 

The second section consist of a table with rows for each compound that was featured in the process.  For each compound, the number of process activities that the compound was featured, the uncontrolled emissions, the controlled emissions, and the percent control removal are shown. 

The third section consist of a table with rows for each compound that is featured in the process.  For each compound, the process cycle average emission rate, the compound emission cycle time, the compound emission rate average, and the maximum one hour average emission rate are shown.  Whereas the process cycle average emission rate is defined as the total emissions for a given compound divided by the overall process cycle time, the compound emission cycle time is defined as the total emissions for a compound divided by the amount to time that the compound was actually present in the process.  The maximum hourly emission rate is determined by scanning through the process at 15 minute intervals and identifying the single 60 minute period with the greatest emission level for each compound.  It is highly possible that the maximum one hour emission rate for one compound might occur at a different time in the process as another compound. 

Worksheet is broken into two tables.  The top table consist of compounds that are grouped by how they are classified in the Emission Master database.  For example, all compounds that are classified as VOC, HAP, and other classifications are group and listed separately.  Compounds that are not classified in the Emission Master database are listed immediately under All Emissions. 

The lower table list the process cycle average emission  rate, the emission hours, the emission average rate, and the maximum hourly emission rate.  Only entire categories are presented. 

In Emission Master, process equipment is featured in each activity.  Equipment used in the process might include vessels, reactors, centrifuges, and other equipment items.  As each equipment item is used in the process, it is vented through one or more devices in the vent path.  Vent devices might include condensers, scrubbers, thermal oxidizers, and other devices.  The Equipment & Control Devices worksheet list all of the process equipment vent path configurations that were featured in the Emission Master process.  For example, if RE-100 is connected to condenser CN-100 during part of the process and to scrubber SC-100 during other parts of the process then the Equipment & Controls Device worksheet would list both configurations for RE-100.  Vent ID's are also listed for each vent path. 

Uncontrolled compound emissions are placed in table where the amount of each compound emitted form the process has it's own column.  Process activity number is listed in Column B and the vessel tag name is listed in Column C.  Uncontrolled emissions are defined as the emissions that occur from the process vessel or last process device in the vent path. 

Final or controlled compound emissions are placed in table where the amount of each compound emitted form the process has it's own column.  Process activity number is listed in Column B and the vessel tag name is listed in Column C.  Controlled emissions are defined as the emissions that are finally released to the atmosphere. 

Each process activity is listed by activity number, type of operation, and activity title in a table.