Importing Combustion Records from Excel

Top  Previous  Next

Importing Combustion Records from Excel

 

 

Combustion and other factor operations may be entered automatically from an Excel file.  Any number of combustion records can be specified in the Excel file where each row corresponds to a different combustion model.  The Excel file contains a header row with labels for the data rows that are to follow.  An explanation of each data field is as follows: 

 

EA Folder:  The name of the group folder in Emissions Accountant were the emission record will be stored.  If the folder name provided in the field can not be located the Emissions Accountant will offer to create the folder.

 

EA Process:  The process record in Emissions Accountant where the batch record will be entered.  If the process record can not be located then the software will offer to create new process record with the name that has been provided. 

 

Batch Name:  Actual emission records that are entered into Emissions Accountant are tagged with a batch number or name. 

 

Activity Title:  When the emission model defined by the row is calculated then this text is used for the Activity Title of the model.

 

Equipment:  The boiler, thermal oxidizer, generator, or other equipment where the fuel was consumed.

 

Start Date:  The beginning calendar date to be used for the emission record.

 

End Date:  The ending calendar date to be used for the emission record.

 

Fuel:  The fuel that is consumed by the combustion operation needs to be present in the chemical database.  When the combustion model is calculated then the quantity of fuel that is consumed is summed for all of the models for reporting purposes. 

 

Consumption:  The numerical portion of the quantity of fuel that has been consumed. 

 

Units:  The measurement portion of the quantity of fuel that has been consumed (gal, lb, kg, MCF, MMCF, etc). 

 

Factor Name:  This string refers to the predefined emission factor record contained in the Emission Factor Database. 

 

Vent ID:  [Optional] If a Vent ID is to be entered for the emission model then this field should be completed.  If the same Vent ID and equipment combination can be located in the Vent Path Database then Emissions Accountant will automatically enter the list of control devices that are contained in the vent path record for modeling purposes.  If a corresponding record can not be located in the Vent Path Database then only the Vent ID will be specified in the model.