Commonwealth of Pennsylvania

Department of Environmental Protection Bureau of Information Technology Bureau of Air Quality

Spreadsheet Reporting Guide for Natural/Coal Bed Methane Gas Air Emissions Reporting System

1

2

Table of Contents Table of Contents .......................................................................................................................................... 3 Spreadsheet Reporting Guide ....................................................................................................................... 4 Basic Steps .................................................................................................................................................... 4 Workbook Structure ................................................................................................................................. 5 Summary worksheet ............................................................................................................................. 5 Station Inventory worksheet ................................................................................................................ 6 Stationary Engines worksheet .............................................................................................................. 7 Heaters-Reboilers worksheet.............................................................................................................. 11 Tanks/Vessels worksheet .................................................................................................................... 13 Dehys (dehydration) worksheet ......................................................................................................... 16 Pneumatic Devices worksheet ............................................................................................................ 18 Fugitives worksheet ............................................................................................................................ 24 Do’s and Don’ts ....................................................................................................................................... 26

3

Spreadsheet Reporting Guide Using the steps and rules specified in this document, you can report Natural/Coal Bed Methane Gas Emissions by filling out a spreadsheet and emailing the spreadsheet to DEP. To do so, you must use Microsoft Excel 2007 or higher. The Basic Steps section of this document outlines the typical procedure that must be followed to both download your spreadsheet and to email the completed spreadsheet to DEP for validation of data and final report submittal. The Spreadsheet Rules section of this document states the rules used to validate and accept your data, and provides guidelines in the form of Do’s and Don’ts that are essential to understand as you enter your Air Emissions data to the spreadsheet.

Basic Steps 1. Begin by navigating to the following link and download the blank spreadsheet: http://www.dep.state.pa.us/dep/deputate/airwaste/aq/emission/emission_inventory.htm 2. Your browser should present you with a dialog box from which you can save the workbook to the location of your choice on your computer. If your browser allows you to open the workbook directly without saving it to your local computer, do not open it since you would then only be opening a temporary copy. It is also a safe browsing practice to not open such files directly in your web browser. Always save the file to your local computer. 3. Open your local copy of the file using Microsoft Excel 2007 or higher. Other spreadsheet products are not compatible with regards to dropdown lists inside the workbook. 4. Add data to your workbook according to the rules listed here in the section titled Spreadsheet Rules and Tool Tips located at each cell of workbook. Save your workbook file locally on your computer. 5. When ready to email your completed Air Emissions spreadsheet, email to the following address: [email protected]

4

Workbook Structure The workbook that is downloaded consists of nine worksheets on which you must supply data. These worksheets are called Summary, Station Inventory, Stationary Engines, Heaters-Reboilers, Tanks-Vessels, Dehys, Pneumatic Pumps, Venting-Blowdowns, and Fugitives.

Summary worksheet The Summary worksheet is where all comments related to Air Emissions reporting will be entered by the operator. The following fields are present in the Summary worksheet and their meaning is described: Column Name

Description

Client Name

The DEP Client Name as it appears on the air permit application or general permit authorization application must be entered. This entry is required and must be reported.

Client Id

The DEP Client Id may be entered if known. Contact the appropriate Regional Office if not known. This entry is optional and not required to be entered.

AQ Reporting Year

The AQ Reporting Year is pre-loaded at time of download of the Air Emissions workbook and set to the reporting period being submitted. This entry cannot be modified by the user.

Start Date

The Start Date is pre-loaded at time of download and determined by the AQ Reporting Year being submitted. This entry cannot be modified by the user.

End Date

The End Date is pre-loaded at time of download and determined by the AQ Reporting Year being submitted. This entry cannot be modified by the user.

Contact Name

The Name of the person that is responsible for answering any questions DEP may have about the submitted data. Validation: Data Entry Required

Contact Address

The Address of the person that is responsible for answering any questions DEP may have about the submitted data. Validation: Data Entry Required

5

Contact Phone

The Phone number of the person that is responsible for answering any questions DEP may have about the submitted data. Validation: Data Entry Required. Ex. (555) 555-5555

Email Address

The Email Address of the person that is responsible for answering any questions DEP may have about the submitted data. Validation: Data Entry Required

Report Comments

All comments the operator may have on the data submission for any of the worksheets is to be entered here. There is no limit to the length of the comments.

Station Inventory worksheet The Station Inventory worksheet is where operators/owners will enter stations based on their GP-5 or operating permits. The user will be required to enter an Air Permit number, Start Date, and End Date. Optional data for Primary Facility Id, Station Name, Latitiude, and Longitude may also be entered.

Column Name

Description

Air Permit

This is the permit number assigned by DEP’s Air Program. The air permit number(s) must be entered for each station being reported. Submission validations: The permit number(s) must be present in the DEP enterprise database.

Primary Facility Id

This is the Bureau of Air Quality’s Primary Facility Id that the DEP enterprise database has created. Contact the appropriate Regional Office if not known. This entry is optional and not required to be entered. Submission validations: The Primary Facility Id if entered must be present in the DEP enterprise database.

Station Name

This is the name of the station to be reported. This entry is optional and not required to be entered. No validations

6

Column Name

Description

County

This is the County associated with the station. Validation: Data Entry Required

Municipality

This is the Municipality associated with the station. Validation: Data Entry Required

Lat

This is the Latitude associated with the station. Either degree. decimal or degree-minute-second format may be used. This entry is optional and not required to be entered. No validations

Long

This is the Longitude associated with the station. Either degree. decimal or degree-minute-second format may be used. This entry is optional and not required to be entered. No validations

Start Date

This is the reporting start date. This should be 01/01/2013 if the station operated prior to 2013. If not, enter the date the station began operating. Operating is to include shakedown phase. Worksheet validations: Required in format xx/xx/xxxx

End Date

This is the reporting end date. Generally should be 12/31/2013 unless station ceased operation prior to 12/31/2013. Worksheet validations: Required in format xx/xx/xxxx

Stationary Engines worksheet The following columns are present in the Stationary Engines worksheet and their meaning is described: Column Name

Description

Air Permit

This is the permit number assigned by DEP’s Air Program. The air permit number(s) must be entered for each station being reported. Submission validations: The permit number(s) must be present in the DEP enterprise database.

7

Column Name

Description

Start Date

Start Date of the Stationary Engine or if combined then the earliest Stationary Engine start date. This should be 01/01/2013 if the source(s) operated prior to 2013. If not, enter the date the source was installed. Enter dates in mm/dd/yyyy format. Client Validation: Data Entry Required

End Date

End Date of the Stationary Engine or if combined then the latest Stationary Engine end date. Generally should be 12/31/2013 unless source(s) ceased operation prior to 12/31/2013. Enter dates in mm/dd/yyyy format. Client Validation: Data Entry Required

Engine Model

Enter the Model of Engine(s) air emissions are being reported on. Data in format of 1-25 characters Client Validation: Data Entry Required

Engine Type

Select either Rich Burn / Lean Burn / Other from Dropdown Client Validation: Data Selection Required

Number of Engines

Enter a number of similar engines combined. Data in format of 1-99 Client Validation: Data Entry Required

Fuel Type

Select one option from Dropdown Client Validation: Data Selection Required

Total Fuel Quantity

Enter Fuel Quantity number for similar engines combined between .01 and 999,999.99 Client Validation: Data Entry Required

Fuel % Sulfur

Enter percentage between 0 and 99.99 in the following format ##.## Client Validation: Data Entry Required

Total HP

Enter total horsepower for all engines combined between 0 and 999,999.99 Client Validation: Data Entry Required

8

Column Name

Description

Average Load

Enter number for all engines combined between 0.01 and 100.00 Client Validation: Data Entry Required

Total Hours

Enter the total number of hours for all engines combined. Enter as whole number between 1 and (((Days between Start Date and Finish Date) * Number of engines) * 24) Client Validation: Data Entry Required

Emissions Factor Basis

Enter up to 50 characters (Manufacturer Spec./AP-42/Source Test/etc.) Client Validation: Data Entry Required

Type of Control

Optional data entry: Enter up to 50 characters. Client Validation: 50 characters or less

CO

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

NOx

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

PM-10

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

PM-2.5

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

SOx

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

VOCs

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

Benzene

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

9

Column Name

Description

Ethylbenzene

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

Formaldehyde

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

x-Hexane

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

Toluene

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

Xylene

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

2,2,4-Trimethylpentane

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

CO2

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

CH4

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

N2O

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

10

Heaters-Reboilers worksheet The following columns are present in the Heaters-Reboilers worksheet and their meaning is described: Column Name

Description

Air Permit

This is the permit number assigned by DEP’s Air Program. The air permit number(s) must be entered for each station being reported. Submission validations: The permit number(s) must be present in the DEP enterprise database.

Start Date

Start Date of the Heater/Reboiler or if combined then the earliest Heater/Reboiler start date. This should be 01/01/2013 if the source(s) operated prior to 2013. If not, enter the date the source was installed. Enter dates in mm/dd/yyyy format. Client Validation: Data Entry Required

End Date

End Date of the Heater/Reboiler or if combined then the latest Heater/Reboiler end date. Generally should be 12/31/2013 unless source(s) ceased operation prior to 12/31/2013. Enter dates in mm/dd/yyyy format. Client Validation: Data Entry Required

Heater Hours

Enter total hours as whole number between 1 and (days between Start Date and End Date) *24. Client Validation: Data Entry Required

Total MMBTU/hr

Enter number between .001 and 99,999.999 Client Validation: Data Selection Require

Number of Units

Enter number between 1 and 999 Client Validation: Data Selection Require

CO

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

NOx

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

11

Column Name

Description

PM-10

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

PM-2.5

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

SOx

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

VOCs

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

Benzene

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

Ethylbenzene

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

Formaldehyde

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

x-Hexane

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

Toluene

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

Xylene

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

2,2,4-Trimethylpentane

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

CO2

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

12

Column Name

Description

CH4

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

N2O

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

Tanks/Vessels worksheet The following columns are present in the Tanks/Vessels worksheet and their meaning is described: Column Name

Description

Air Permit

This is the permit number assigned by DEP’s Air Program. The air permit number(s) must be entered for each station being reported. Submission validations: The permit number(s) must be present in the DEP enterprise database.

Start Date

Start Date of the Tank/Vessel or if combined then the earliest Tank/Vessel start date. This should be 01/01/2013 if the source(s) operated prior to 2013. If not, enter the date the source was installed. Enter dates in mm/dd/yyyy format. Client Validation: Data Entry Required

End Date

End Date of the Tank/Vessel or if combined then the latest Tank/Vessel end date. Generally should be 12/31/2013 unless source(s) ceased operation prior to 12/31/2013. Enter dates in mm/dd/yyyy format. Client Validation: Data Entry Required

Unit Type

Select either Tank, Impoundment, Pressurized Vessel, or Separator from Dropdown Client Validation: Data Selection Required

Number of Units

Enter number between 1 and 999 Client Validation: Data Entry Required

13

Column Name

Description

Total Hours Operated (hrs)

Enter Hours as whole number between 1 and ((days between Start Date and End Date) * Number Of Units) * 24. Client Validation: Data Selection Required

Controlled

Select either Y or N from Dropdown Client Validation: Data Selection Required

Control Type

If you choose "Y" for Controlled then you must select an option from list of options. Select either VRU / Flare / Other from Dropdown Client Validation: Data Selection Required

Total Hours of Controlled Operations (hrs)

If you choose "Y" for Controlled then enter Hours as whole number between 1 and ((days between Start Date and End Date) * Number of Units) * 24. Client Validation: Data Entry Required

CO

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

NOx

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

PM-10

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

PM-2.5

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

SOx

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

VOCs

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

Benzene

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

14

Column Name

Description

Ethylbenzene

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

Formaldehyde

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

x-Hexane

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

Toluene

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

Xylene

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

2,2,4-Trimethylpentane

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

CO2

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

CH4

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

N2O

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

15

Dehys (dehydration) worksheet The following columns are present in the Dehys worksheet and their meaning is described: Column Name

Description

Air Permit

This is the permit number assigned by DEP’s Air Program. The air permit number(s) must be entered for each station being reported. Submission validations: The permit number(s) must be present in the DEP enterprise database.

Start Date

Start Date of the Dehy or if combined then the earliest Dehy start date. This should be 01/01/2013 if the source(s) operated prior to 2013. If not, enter the date the source was installed. Enter dates in mm/dd/yyyy format. Client Validation: Data Entry Required

End Date

End Date of the Dehy or if combined then the latest Dehy end date. Generally should be 12/31/2013 unless source(s) ceased operation prior to 12/31/2013. Enter dates in mm/dd/yyyy format. Client Validation: Data Entry Required

Gas Processed (mcf)

Enter thousand cubic feet as a whole number between 1 and 99,999,999 Client Validation: Data entry Required

Dehydration Unit design Rating (MMSCFD)

Enter million standard cubic feet per day as a whole number between 1 and 99,999,999 Client Validation: Data Entry Required

Actual Operating Hours (hrs)

Enter Hours as whole number between 1 and (days between Start Date and End Date) * 24. Client Validation: Data Entry Required

Actual Lean Glycol Circulation Rate (gpm)

Enter gallons per minute as a decimal number between 0.01 and 99,999,999.00 Client Validation: Data Entry Required

Controlled

Data Entry Required: Select either Y or N from Dropdown Client Validation: Data Selection Required

16

Column Name

Description

Control Type

If you choose "Y" for Controlled then you must select an option from list of options. Select either VRU / Flare / Other from Dropdown Client Validation: Data Selection Required

Total Hours of Controlled Operations (hrs)

If you choose "Y" for Controlled then enter Hours as whole number between 1 and ((days between Start Date and End Date) * Number of Units) * 24. Client Validation: Data Entry Required

CO

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

NOx

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

PM-10

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

PM-2.5

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

SOx

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

VOCs

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

Benzene

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

Ethylbenzene

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

Formaldehyde

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

17

Column Name

Description

x-Hexane

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

Toluene

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

Xylene

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

2,2,4-Trimethylpentane

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

CO2

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

CH4

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

N2O

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

Pneumatic Devices worksheet The following columns are present in the Pneumatic Devices worksheet and their meaning is described: Column Name

Description

Air Permit

This is the permit number assigned by DEP’s Air Program. The air permit number(s) must be entered for each station being reported. Submission validations: The permit number(s) must be present in the DEP enterprise database.

18

Column Name

Description

Start Date

Start Date of the Pneumatic Device or if combined then the earliest Pneumatic Device start date. This should be 01/01/2013 if the source(s) operated prior to 2013. If not, enter the date the source was installed. Enter dates in mm/dd/yyyy format. Client Validation: Data Entry Required

End Date

End Date of the Pneumatic Device or if combined then the latest Pneumatic Device end date. Generally should be 12/31/2013 unless source(s) ceased operation prior to 12/31/2013. Enter dates in mm/dd/yyyy format. Client Validation: Data Entry Required

Gas Processed (mcf)

Enter thousand cubic feet as a whole number between 1 and 99,999,999 Client Validation: Data entry Required

Condensate Processed (bbls)

Enter barrels as a whole number between 0 and 99,999,999 Client Validation: Data Entry Required

Unit Type

Select either Pumps, Controllers, or Valves from Dropdown Client Validation: Data Selection Required

Number of Devices

Enter the number between 1 and 999 Client Validation: Data Entry Required

Total Operated Hours

Enter Hours as whole number between 1 and ((days between Start Date and End Date)* Number of Devices) * 24. Client Validation: Data Entry Required

Controlled

Select either Y or N from Dropdown Client Validation: Data Selection Required

Control Type

If you choose "Y" for Controlled then you must select an option from list of options. Select either VRU / Flare / Other from Dropdown Client Validation: Data Selection Required

19

Column Name

Description

Total Hours of Controlled Operations (hrs)

If you choose "Y" for Controlled then enter Hours as whole number between 1 and ((days between Start Date and End Date) * Number of Units) * 24. Client Validation: Data Entry Required

CO

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

NOx

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

PM-10

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

PM-2.5

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

SOx

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

VOCs

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

Benzene

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

Ethylbenzene

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

Formaldehyde

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

x-Hexane

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

20

Column Name

Description

Toluene

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

Xylene

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

2,2,4-Trimethylpentane

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

CO2

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

CH4

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

N2O

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

Venting/Blowdowns worksheet The following columns are present in the Venting/Blowdowns worksheet and their meaning is described: Column Name

Description

Air Permit

This is the permit number assigned by DEP’s Air Program. The air permit number(s) must be entered for each station being reported. Submission validations: The permit number(s) must be present in the DEP enterprise database.

Start Date

Start Date of the Venting/Blowdown or if combined then the earliest Venting/Blowdown start date. This should be 01/01/2013 if the source(s) operated prior to 2013. If not, enter the date the source was installed. Enter dates in mm/dd/yyyy format. Client Validation: Data Entry Required

End Date

End Date of the Venting/Blowdown or if combined then the latest Venting/Blowdown end date. Generally should be 12/31/2013 unless

21

Column Name

Description source(s) ceased operation prior to 12/31/2013. Enter dates in mm/dd/yyyy format. Client Validation: Data Entry Required

Number of Blowdowns

Enter the number between 1 and 999 Client Validation: Data entry Required

Average Blowdown rate (scf/hr)

Enter standard cubic feet per hour as a whole number between 1 and 99,999,999 Client Validation: Data Entry Required

Average Blowdown Length (hrs)

Enter Hours as decimal number between 0.01 and (days between Start Date and End Date) * 24. Client Validation: Data Entry Required

Controlled

Select either Y or N from Dropdown Client Validation: Data Selection Required

Control Type

If you choose "Y" for Controlled then you must select an option from list of options. Select either VRU / Flare / Other from Dropdown Client Validation: Data Selection Required

Total Hours of Controlled Operations (hrs)

If you choose "Y" for Controlled then enter Hours as whole number between 1 and ((days between Start Date and End Date) * Number of Units) * 24. Client Validation: Data Entry Required

CO

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

NOx

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

PM-10

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Require

22

Column Name

Description

PM-2.5

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

SOx

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

VOCs

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

Benzene

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

Ethylbenzene

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

Formaldehyde

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

x-Hexane

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

Toluene

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

Xylene

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

2,2,4-Trimethylpentane

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

CO2

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

CH4

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

23

Column Name

Description

N2O

Enter tons per year as a decimal between 0 and 99,999.99999 Client Validation: Data Entry Required

Fugitives worksheet The following columns are present in the Fugitives worksheet and their meaning is described: Column Name

Description

Air Permit

This is the permit number assigned by DEP’s Air Program. The air permit number(s) must be entered for each station being reported. Submission validations: The permit number(s) must be present in the DEP enterprise database.

Start Date

Start Date of the source or if multiple then the earliest source start date. This should be 01/01/2013 if the source(s) operated prior to 2013. If not, enter the date the source was installed. Enter dates in mm/dd/yyyy format. Client Validation: Data Entry Required

End Date

End Date of the source or if combined then the latest source end date. Generally should be 12/31/2013 unless source(s) ceased operation prior to 12/31/2013. Enter dates in mm/dd/yyyy format. Client Validation: Data Entry Required

Component Type

Select a component type from dropdown list Client Validation: Data Selection Required

Product

Select a product from dropdown list Client Validation: Data Selection Required

Component Count

Enter the number of this type of component as a whole number between 1 and 999,999 Client Validation: Data Entry Required

Operating Days per year

Enter days as whole number between 1 and (days between Start Date and End Date). Client Validation: Data Selection Required

24

Column Name

Description

See Emissions Calculations

Follow this link to see how DEP will calculate the emissions for these components. NOTE: If you disagree with these calculations then you must enter your own. If you choose to enter your own values then you must enter values for all of the remaining fields

When user clicks the See Emissions Calculations link within the spreadsheet the following screen is shown with the DEP Calculation results: This page includes

25

Do’s and Don’ts 

Do not add columns or modify column headers in any worksheet.



Do not add data anywhere outside the provided columns. It will be ignored.



Do not expect Microsoft Excel to validate your data when you copy and paste cell values from one worksheet to another. The product does not support data validations on copy/paste operations.



Do not use Microsoft Excel standard copy/paste. If you do so, you will lose all local validations and dropdown list values. Instead, do use copy/paste values. This is represented (in Microsoft Excel 2010) as the paste icon with a simple 123 symbol on a clipboard, as in:

See the Paste

26

Values section:



Do not edit your workbook using multiple versions of Microsoft Excel. If you begin editing using Excel 2010, for instance, do not later try to use it in an earlier version such as Excel 2007. The versions are not compatible.



Do use either Microsoft Excel 2010 for Windows (recommended) or Microsoft Excel 2007 for Windows. Those are the only versions for which the workbook export/import has been tested. Earlier versions will not work. Versions for other operating systems and spreadsheet products other than Microsoft Excel are not supported as they are not compatible with the data validations that have been built into your workbook.

27