Sustainability & Risk / Green Building / Carbon Footprint - Background Data

Adding New Energy Grid Versions and Data

If you are tracking emissions from electricity consumption, either in the US using the EPA's eGRID data, or outside the US using the IEA (International Energy Agency) Statistics Manual, you might want to import this data into Archibus whenever the EPA or IEA publish new emissions data. Typically, these organizations publish new data every few years. Archibus provides Excel spreadsheets as templates that the System Administrator or Business Process Owner can use to load eGRID subregions and Zip Codes, or IEA subregions.

Going forward, the EPA and IEA may deviate in the format they use, but the format they have provided was consistent from 2007 to 2010.

To produce an import template and perform an import, you will go to the following URLs that are referenced in the below instructions:

where localhost is the name of the server from which you are running Web Central.

To edit and save a template, you must first select “Review / Unprotect Sheet” in Excel 2007. For other Excel versions, search ‘Unprotect Sheet’ in Help for instructions on locating this option.

Adding New eGRID Subregion Data

To add new EPA eGRID subregions data:

  1. Create a new Energy Grid Version entry using the Carbon Footprint - Background Data / Energy Grid Emissions task. This version is for the new eGRID data.
  2. Create an Excel template for importing data by opening the view

    http://localhost:8080/archibus/ab-gb...grid-xfer.axvw,

    clicking the DATA button, and using the data transfer tool to export to .xls. See Exporting Data Using Data Transfer.

    Note: To access this view you must enter its address directly into the web browser’s address bar.

    Note : The export contains one row of existing data for illustration purposes. Either delete this row from the spreadsheet before importing new data, or take care not to alter the data in this row.

  3. From the EPA eGRID spreadsheet, copy and paste the subregion codes to the subregion_code column and the subregion names to the subregion_name column of the Archibus data transfer .xls.
  4. Copy and paste carbon dioxide, methane, and nitrous oxide emissions per unit energy values into the appropriate columns (co2_entry, ch4_entry, n2o_entry) in the Archibus xls.
  5. Insert two temporary columns (or append data to the right of the Archibus data).
  6. Fill the temporary columns with the conversion factor for eGRID units (one for CO 2 , another for CH 4 / N 2 O). The conversion factor is the factor necessary to convert eGRID units to kg/MWh for CO 2 and kg/GWh for CH 4 / N 2 O. Conversion factors for the most commonly used eGRID units:
    eGRID units Conversion Factor
    CO2: lb/MWh 0.4535924
    CO2: lb/GWh 0.0004535924
    CH4/N2O: lb/MWh 453.5924
    CH4/N2O: lb/GWh 0.4535924
  7. In a new temporary column, create converted CO 2 values by multiplying the eGRID-supplied CO 2 emissions by the CO 2 conversion factor you created.
  8. In another new temporary column, create converted CH 4 and N 2 O values by multiplying the eGRID-supplied CH 4 and N 2 O emissions by the CH 4 / N 2 O conversion factor you created.
  9. Copy the resulting values and paste special (values only) into the database units columns (co2, ch4, n2o) of the Archibus export/import xls.
  10. Remove the temporary columns.
  11. In the .xls file created by the data transfer tool, fill the version_name column with the version name you created in step 1, by entering this Version Name on the first row, copy to second row, highlight both rows, then double click the right bottom corner of the selection to fill all rows with the value.
  12. Similarly, fill all rows of the following columns:
    1. version_type column with the exact value: gb_fp_egrid_subregions.
    2. co2_units_type column with the exact value: EGRID CO2 EMISSIONS
    3. ch4_n2o_units_type column with the exact value: EGRID CH4-N2O EMISSIONS
    4. co2_units column with the name of the units that the eGRID CO2 values (co2_entry) are in, example: lb/MWh. Fill all rows of the ch4_n2o_units column with the name of the units that the eGRID CH4/ N2O values (ch4_entry and n2o_entry) are in, example: lb/GWh. The units name must exist in the Green Building Units table: Carbon Footprint - Background Data / Define Units.
  13. Save the .xls file.
  14. Return to the data transfer view and follow the steps to import the data. See Importing Data Using Data Transfer.

    Note: The new data will not appear on the import/export view. To confirm successful import, either review the comparison log from the import tool or return to the Energy Grid Emissions task in the Carbon Footprint – Background Data process.

Updating eGRID Zip Codes

Note : This data load may take an hour or longer to complete.

To upgrade the Zip Codes used by eGRID:

  1. Create an Excel template for importing data by opening the view

    http://localhost:8080/archibus/ab-gb...d-pc-xfer.axvw,

    clicking the DATA button, and using the data transfer tool to export to .xls. See Exporting Data Using Data Transfer.

    Note: To access this view, you must enter its address directly into the web browser’s address bar.

    Note : The export contains one row of existing data for illustration purposes. Either delete this row from the spreadsheet before importing new data, or take care not to alter the data in this row.

  2. To make cut-and-paste from the eGRID spreadsheet easier, change the column order in the exported .xls file so the columns are in the following order:
    1. gb_fp_egrid_zip.version_type
    2. gb_fp_egrid_zip.version_name
    3. gb_fp_egrid_zip.zip
    4. gb_fp_egrid_zip.state_id
    5. gb_fp_egrid_zip.subregion_code
    6. gb_fp_egrid_zip.city_id
  3. In the EPA Power_Profiler_Zipcode_Tool spreadsheet, go to the Zip-subregion tab, delete ZIP (numeric) column B.
  4. Place cursor on first zip (Ctrl+Home), and highlight columns A-C (ZIP, state, and primary subregion), then press Shift+Ctrl+DownArrow to select all rows. Press Ctrl-C to copy selection.
  5. In the .xls file created by the data transfer tool, place cursor on cell C3 and press Ctrl-V to paste selection into the zip, state_id, and subregion_code columns.
  6. Go back to the zipcode tool, press ESC to clear selection, and press Ctrl-Home.
  7. Select and Delete column C.
  8. Open the filter on Secondary Subregion (Column C) and deselect “blanks”.
  9. Repeat steps 4 and 5, except in step 5, instead of placing cursor on C3, place cursor in column C and the row below the last row with data (press Ctrl-End to see last row).
  10. Repeat steps 6, 7, and 8 (for Tertiary eGRID), and step 9.
  11. In the .xls file created by the data transfer tool, fill the version_name column with the version name you created in Green Building for the new eGRID data, by entering this Version Name on the first row (B3), copy to B4, highlight B3 and B4, then double click the right bottom corner of the selection to fill all rows with the value.
  12. Similarly, fill all rows of gb_fp_egrid_zip.version_type with the value: gb_fp_egrid_subregions.
  13. Return to the data transfer view and follow the steps to import the data. See Importing Data Using Data Transfer.

    Note: The new data will not appear in the import/export view. To confirm successful import, either review the comparison log from the import tool or return to the Energy Grid Emissions task in the Carbon Footprint – Background Data process.

Adding New IEA Subregion Data

To add new IEA Energy Grid subregions data:

  1. Create a new Energy Grid Version entry using the Carbon Footprint - Background Data / Energy Grid Emissions task. This version is for the new IEA data.
  2. Create an Excel template for importing data by opening the view

    http://localhost:8080/archibus/ab-gb...grid-xfer.axvw,

    clicking the DATA button, and using the data transfer tool to export to .xls. See Exporting Data Using Data Transfer.

    Note: To access this view, you must enter its address directly into the web browser’s address bar.

    Note : The export contains one row of existing data for illustration purposes. Either delete this row from the spreadsheet before importing new data, or take care not to alter the data in this row.

  3. Copy and paste Country and CO2 emissions data columns from an IEA PDF or XLS file into the xls import template. The country names are pasted into the subregion_code column. Remove the gb_fp_egrid_subregions.ch4 and gb_fp_egrid_subregions.n2o columns from the import template. Paste CO 2 emissions values into the co2_entry field. Follow the instructions in “Adding New eGRID Subregion Data” steps 5-10 to fill in the gb_fp_egrid_zip.co2 column, but ignore ch4 and n2o instructions.
  4. In the .xls file created by the data transfer tool, fill the version_name column with the version name you created in step 1, by entering this Version Name on the first row, copy to second row, highlight both rows, then double click the right bottom corner of the selection to fill all rows with the value.
  5. Similarly, fill all rows of the following columns:
    1. version_type column with the exact value: gb_fp_egrid_subregions.
    2. co2_units_type column with the exact value: EGRID CO2 EMISSIONS
    3. ch4_n2o_units_type column with the exact value: EGRID CH4-N2O EMISSIONS
    4. ch4_entry and n2o_entry columns with zero (0).
    5. co2_units and ch4_n2o_units columns with the name of the units that the IEA CO2 values (co2_entry) are in, example: lb/MWh. The units name must exist in the Green Building Units table: Carbon Footprint - Background Data / Define Units.
  6. Save the template .xls.
  7. Return to the data transfer view and follow the steps to import the data. See Importing Data Using Data Transfer.

    Note: The new data will not appear in the import/export view. To confirm successful import, either review the comparison log from the import tool or return to the Energy Grid Emissions task in the Carbon Footprint – Background Data process.