Emissions sources spreadsheet

This spreadsheet lets you update and create emissions sources.

Benefits of spreadsheets

Spreadsheets save time and let you create multiple items at one time.

  • The menu displays spreadsheets matching your permissions.
  • Always download a new spreadsheet before you begin adding data because the spreadsheet is populated with information from your database.

Format rules

  • Enter all information as text or dates.
  • You can add sheets to the notebook, only the sheet named DataEntry is processed.
  • Do not rename, remove, or rearrange columns.

Maximum length for codes and names

The column header lists the maximum length for each attribute. When entering data, a red cell indicates the name or code exceeding the specified length. If you upload the spreadsheet without fixing the cell, the row fails to process and an error spreadsheet is created.

Create new emissions sources

  1. In the Emissions Sources module, click All Emissions Sources and then click Import.
  2. Download the spreadsheet template. The name format of the file is yyyymmdd-CREATE_EmissionSources.xlsx.
  3. Add your information and save the file.
  4. Select your file to upload.
  5. Use Import to upload your spreadsheet.
  6. If your file import results in errors you are redirected to the Setup Spreadsheets Log.

Edit emissions sources

  1. In the Emissions Sources module, set the quick filters at the top of the All Emissions Sources table to limit the content in your spreadsheet. Many of these attributes can be overridden for individual records that are associated with this emissions source.
  2. Use Download to download the update sheet. The name format of the file is yyyymmdd_UPDATE_EmissionSources.xlsx.
  3. Edit your information and save the file.
  4. Select your file for upload.
  5. Use Import in the dialog to upload your spreadsheet.
  6. If your file import results in errors you are redirected to the Setup Spreadsheets Log. 

Best practices when creating emissions sources

Review Creating a new emissions source for a detailed description of fields associated with emissions sources.

Follow the steps in yellow to help narrow your list of GHG factors in column K.

  1. Select the region.
  2. Select the category.
  3. Select the GHG Factor. 

Spreadsheet columns

Column  Rules
Success / Error Read-only column.
Hash Read-only column.
Emissions Source ID Read-only column. You can find the ID in the URL while viewing an emissions source. 
Emissions Source Name Enter the name for the emissions source.
Emissions Source Code Enter a unique code.
Type (commodity) Select from the drop-down list.
Parent Collection Code Select a parent for this emissions source. This defaults to NO_PARENT if blank.
Use Defaults? Use the default scope category and factor for the selected type (commodity) or choose your own. When you select Use defaults none of the scope category or factor cells in that row are active.
Default Scope: Category Select from the list.
Factor Step 1: Region This helps narrow your list of choices for Step 3.
Factor Step 2: Category This helps narrow your list of choices for Step 3.
Factor Step 3: GHG Factor Select from the list.
Notes Add information for this emissions source. You can view the notes when you view the details of an emissions source details or view all notes in the update spreadsheet.
Address Street 1  
Address Street 2  
Address Street 3  
City You can enter the zip code and this information is automatically populated when you import the file.
State/Province/Region You can enter the zip code and this information is automatically populated when you import the file.
Postal Code

Enter the postal code.

 

Adding location is suggested for any emissions source using the electric type (commodity). If location is applied, the appropriate eGrid factors are automatically selected for your electric emissions source.
 
Country  
Latitude  
Longitude