{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["0. Introduction","1. Utility Data","2. Utility Charts","3. Summary Tab","A. Emission Factor Reference","B.  Global Warming Potential","C. Conversion Factors Reference"],"not_rendered":{"charts":5,"images":3,"macros":1,"external_links":0,"defined_names":0,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"0. Introduction","index":0,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Brewers Association Facility Data Collection Workbook \n& Greenhouse Gas Emissions Inventory Tool "]
["Introduction and Completion Instructions"]
[]
[]
["Overview:","This workbook is intended to capture the data necessary to calculate an estimate of greenhouse gas (GHG)  emissions and organize energy data. This tool will capture large scope 1 and scope 2 GHG sources. Process emissions, refrigerants, and other scope 3 emissions are beyond the scope of this worksheet."]
[]
["Contents:","The workbook contains the following input, output and reference sheets:"]
[]
[null,"FACILITY INPUT SHEETS"]
[]
[null,"1.  Utility Data:  Facilities to input monthly usage data from fuel purchasing records or direct meter readings."]
[]
[null,"OUTPUT AND REFERENCE SHEETS"]
[]
[null,"2.  Utility Charts:  A locked sheet showing bar graphs for each source by year. The tool will automatically generate these charts based on information entered in the \"utility data\" tab."]
[null,"3.  Summary Tab:  A locked sheet showing calculated GHG emissions. The tool will automatically calculate site-specific and corporate-wide GHG emissions on this tab."]
[null,"A. Emissions Factor Reference: A locked sheet showing fuel emission factors used in this tool and the national electricity CO2e emission factor for the United States"]
[null,"B. Global Warming Reference: A locked sheet showing the global warming potential of various compounds."]
[null,"C. Conversion Factor Reference: A locked sheet showing guidance on applicable conversion factors"]
[]
["Instructions:","Please work through each of the spreadsheet sections as completely as possible.  Specific instructions are listed within each tab.\n\nTo begin, click on the 1. Utility Data tab and review the data fields required. Contact individual sites to collect required data for insertion into the tool. Ensure that your units of measure match what the tool requires - guidance on applicable conversion factors is available on the C. Conversion Factors Reference tab.  "]
[null,"Note: Enter \"0\" or leave the cell blank when the information Is not applicable"]

{"sheet":"1. Utility Data","index":1,"n_rows":61,"n_cols":19,"rows_kept":61,"cut":false,"hidden":false,"merged":[[9,17,9,18],[16,18,17,18],[1,1,3,15],[5,0,5,15],[0,0,0,15],[7,0,8,0],[7,1,7,3],[7,4,7,6],[7,7,7,9],[7,10,7,12],[7,13,7,15]]}
[]
[null,"Utility Data Collection Worksheet"]
[]
[]
[]
["Fuel use and electricity data must be entered for each month in order to produce annual results. The operator should enter the total values for each of the months listed below. Note: only enter data for the corresponding months (light grey cells), the totals column will generate automatically (dark grey cells). When applicable provide the monthly data for: Purchased Electricity, Propane, Natural Gas, Gasoline, Diesel.    If there is no information for a source you may leave the cell blank or enter \"0\". The results of this information will populate in  the \"2. Utility Charts\" & \"3. Summary Tab\"."]
[]
["Date","Electricity",null,null,"Propane",null,null,"Natural Gas",null,null,"Gasoline",null,null,"Diesel"]
[null,"Qty (kWh)","Cost (USD$)","Cost Per Unit","Qty (gal)","Cost (USD$)","Cost Per Unit","Qty (kWh)","Cost (USD$)","Cost Per Unit","Qty (gal)","Cost (USD$)","Cost Per Unit","Qty (gal)","Cost (USD$)","Cost Per Unit"]
["2012-01-01",null,null,{"$f":"IF(B10=\"\",\"-\",C10/B10)","v":"-"},null,null,{"$f":"IF(E10=\"\",\"-\",F10/E10)","v":"-"},null,null,{"$f":"IF(H10=\"\",\"-\",I10/H10)","v":"-"},null,null,{"$f":"IF(K10=\"\",\"-\",L10/K10)","v":"-"},null,null,{"$f":"IF(N10=\"\",\"-\",O10/N10)","v":"-"},null,"Map Key"]
["2012-02-01",null,null,{"$f":"IF(B11=\"\",\"-\",C11/B11)","v":"-"},null,null,{"$f":"IF(E11=\"\",\"-\",F11/E11)","v":"-"},null,null,{"$f":"IF(H11=\"\",\"-\",I11/H11)","v":"-"},null,null,{"$f":"IF(K11=\"\",\"-\",L11/K11)","v":"-"},null,null,{"$f":"IF(N11=\"\",\"-\",O11/N11)","v":"-"},null,"-","Category Description"]
["2012-03-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,"-","Operator Input / Drop Down Cells"]
["2012-04-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,"-","Calculated Value Cells"]
["2012-05-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,"-","Automatically Filled Cell"]
["2012-06-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2012-07-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2012-08-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2012-09-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2012-10-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2012-11-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2012-12-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2012 Totals",{"$f":"SUM(B10:B21)","v":0},{"$f":"SUM(C10:C21)","v":0},{"$f":"IF(B22=0,\"-\",C22/B22)","v":"-"},{"$f":"SUM(E10:E21)","v":0},{"$f":"SUM(F10:F21)","v":0},{"$f":"IF(E22=0,\"-\",F22/E22)","v":"-"},{"$f":"SUM(H10:H21)","v":0},{"$f":"SUM(I10:I21)","v":0},{"$f":"IF(H22=0,\"-\",I22/H22)","v":"-"},{"$f":"SUM(K10:K21)","v":0},{"$f":"SUM(L10:L21)","v":0},{"$f":"IF(K22=0,\"-\",L22/K22)","v":"-"},{"$f":"SUM(N10:N21)","v":0},{"$f":"SUM(O10:O21)","v":0},{"$f":"IF(N22=0,\"-\",O22/N22)","v":"-"}]
["2013-01-01",null,null,{"$f":"IF(B23=\"\",\"-\",C23/B23)","v":"-"},null,null,{"$f":"IF(E23=\"\",\"-\",F23/E23)","v":"-"},null,null,{"$f":"IF(H23=\"\",\"-\",I23/H23)","v":"-"},null,null,{"$f":"IF(K23=\"\",\"-\",L23/K23)","v":"-"},null,null,{"$f":"IF(N23=\"\",\"-\",O23/N23)","v":"-"}]
["2013-02-01",null,null,{"$f":"IF(B24=\"\",\"-\",C24/B24)","v":"-"},null,null,{"$f":"IF(E24=\"\",\"-\",F24/E24)","v":"-"},null,null,{"$f":"IF(H24=\"\",\"-\",I24/H24)","v":"-"},null,null,{"$f":"IF(K24=\"\",\"-\",L24/K24)","v":"-"},null,null,{"$f":"IF(N24=\"\",\"-\",O24/N24)","v":"-"}]
["2013-03-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2013-04-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2013-05-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2013-06-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2013-07-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2013-08-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2013-09-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2013-10-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2013-11-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2013-12-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2013 Totals",{"$f":"SUM(B23:B34)","v":0},{"$f":"SUM(C23:C34)","v":0},{"$f":"IF(B35=0,\"-\",C35/B35)","v":"-"},{"$f":"SUM(E23:E34)","v":0},{"$f":"SUM(F23:F34)","v":0},{"$f":"IF(E35=0,\"-\",F35/E35)","v":"-"},{"$f":"SUM(H23:H34)","v":0},{"$f":"SUM(I23:I34)","v":0},{"$f":"IF(H35=0,\"-\",I35/H35)","v":"-"},{"$f":"SUM(K23:K34)","v":0},{"$f":"SUM(L23:L34)","v":0},{"$f":"IF(K35=0,\"-\",L35/K35)","v":"-"},{"$f":"SUM(N23:N34)","v":0},{"$f":"SUM(O23:O34)","v":0},{"$f":"IF(N35=0,\"-\",O35/N35)","v":"-"}]
["2014-01-01",null,null,{"$f":"IF(B36=\"\",\"-\",C36/B36)","v":"-"},null,null,{"$f":"IF(E36=\"\",\"-\",F36/E36)","v":"-"},null,null,{"$f":"IF(H36=\"\",\"-\",I36/H36)","v":"-"},null,null,{"$f":"IF(K36=\"\",\"-\",L36/K36)","v":"-"},null,null,{"$f":"IF(N36=\"\",\"-\",O36/N36)","v":"-"}]
["2014-02-01",null,null,{"$f":"IF(B37=\"\",\"-\",C37/B37)","v":"-"},null,null,{"$f":"IF(E37=\"\",\"-\",F37/E37)","v":"-"},null,null,{"$f":"IF(H37=\"\",\"-\",I37/H37)","v":"-"},null,null,{"$f":"IF(K37=\"\",\"-\",L37/K37)","v":"-"},null,null,{"$f":"IF(N37=\"\",\"-\",O37/N37)","v":"-"}]
["2014-03-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2014-04-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2014-05-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2014-06-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2014-07-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2014-08-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2014-09-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2014-10-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2014-11-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2014-12-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2014 Totals",{"$f":"SUM(B36:B47)","v":0},{"$f":"SUM(C36:C47)","v":0},{"$f":"IF(B48=0,\"-\",C48/B48)","v":"-"},{"$f":"SUM(E36:E47)","v":0},{"$f":"SUM(F36:F47)","v":0},{"$f":"IF(E48=0,\"-\",F48/E48)","v":"-"},{"$f":"SUM(H36:H47)","v":0},{"$f":"SUM(I36:I47)","v":0},{"$f":"IF(H48=0,\"-\",I48/H48)","v":"-"},{"$f":"SUM(K36:K47)","v":0},{"$f":"SUM(L36:L47)","v":0},{"$f":"IF(K48=0,\"-\",L48/K48)","v":"-"},{"$f":"SUM(N36:N47)","v":0},{"$f":"SUM(O36:O47)","v":0},{"$f":"IF(N48=0,\"-\",O48/N48)","v":"-"}]
["2015-01-01",null,null,"-",null,null,{"$f":"IF(E49=\"\",\"-\",F49/E49)","v":"-"},null,null,{"$f":"IF(H49=\"\",\"-\",I49/H49)","v":"-"},null,null,{"$f":"IF(K49=\"\",\"-\",L49/K49)","v":"-"},null,null,{"$f":"IF(N49=\"\",\"-\",O49/N49)","v":"-"}]
["2015-02-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2015-03-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2015-04-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2015-05-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2015-06-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2015-07-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2015-08-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2015-09-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2015-10-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2015-11-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2015-12-01",null,null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
["2015 Totals",{"$f":"SUM(B49:B60)","v":0},{"$f":"SUM(C49:C60)","v":0},{"$f":"IF(B61=0,\"-\",C61/B61)","v":"-"},{"$f":"SUM(E49:E60)","v":0},{"$f":"SUM(F49:F60)","v":0},{"$f":"IF(E61=0,\"-\",F61/E61)","v":"-"},{"$f":"SUM(H49:H60)","v":0},{"$f":"SUM(I49:I60)","v":0},{"$f":"IF(H61=0,\"-\",I61/H61)","v":"-"},{"$f":"SUM(K49:K60)","v":0},{"$f":"SUM(L49:L60)","v":0},{"$f":"IF(K61=0,\"-\",L61/K61)","v":"-"},{"$f":"SUM(N49:N60)","v":0},{"$f":"SUM(O49:O60)","v":0},{"$f":"IF(N61=0,\"-\",O61/N61)","v":"-"}]

{"sheet":"2. Utility Charts","index":2,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,2,3,19]]}
[]
[null,null,"Utility Data Charts Yearly Totals by Source"]

{"sheet":"3. Summary Tab","index":3,"n_rows":61,"n_cols":39,"rows_kept":61,"cut":false,"hidden":false,"merged":[[1,2,3,9],[5,2,5,9],[5,16,5,32],[21,2,21,9],[60,2,60,9],[33,2,35,9],[18,2,20,9],[61,2,63,9],[17,2,17,9],[47,2,49,9],[32,2,32,9],[29,2,29,9],[43,2,43,9],[46,2,46,9],[57,2,57,9]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select Unit","Select Unit","Select Unit","Select Renewable Energy Type"]
[null,null,"Summary Results ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TJ","gal","kWh","Biomass"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh","liter","MJ","Biogas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MJ","mile",null,"Landfill Gas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"gal","km",null,"Solar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"liters",null,null,"Wind"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m3",null,null,"Other: Enter Source"]
[null,"Summary Results",null,null,null,null,null,null,null,null,null,"Map Key"]
[null,null,"Note: The amount of barrels produced must be entered in order to populate all corresponding results.  ",null,null,null,null,null,null,null,null,"-","Category Description"]
[null,null,null,"Unit",null,2012,2013,2014,2015,"Total",null,"-","Operator Input / Drop Down Cells"]
[null,null,"Barrels","#",null,null,null,null,null,{"$f":"SUM(F11:I11)","v":0},null,"-","Calculated Value Cells"]
[null,null,"Cost Per Year","$",null,{"$f":"SUM(F41:F43,F45:F46)","v":0},{"$f":"SUM(G41:G43,G45:G46)","v":0},0,0,{"$f":"SUM(F12:I12)","v":0},null,"-","Automatically Filled Cell"]
[null,null,"kWh per year","kWh",null,{"$f":"SUM(F27:F29)","v":0},{"$f":"SUM(G27:G29)","v":0},0,0,0]
[null,null,"mtCO2e per Year","mtCO2e",null,{"$f":"SUM(F55:F57,F59:F60)","v":0},{"$f":"SUM(G55:G57,G59:G60)","v":0},0,0,0]
[null,null,"Cost Per Barrel","$/Barrel",null,{"$f":"IF(F11=\"\",\"-\",F12/F11)","v":"-"},{"$f":"IF(G11=\"\",\"-\",G12/G11)","v":"-"},{"$f":"IF(H11=\"\",\"-\",H12/H11)","v":"-"},"-",0]
[null,null,"kWh/Barrel","kWh/Barrel",null,{"$f":"IF(F11=\"\",\"-\",F13/F11)","v":"-"},{"$f":"IF(G11=\"\",\"-\",G13/G11)","v":"-"},"-","-",0]
[null,null,"GHG Per Barrel","MtCO2e/Barrel",null,{"$f":"IF(F11=\"\",\"-\",F14/F11)","v":"-"},{"$f":"IF(G11=\"\",\"-\",G14/G11)","v":"-"},"-","-",0]
[null,null,"Estimation Notes or Other Comments:"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kg"]
[]
[null,"Quantity by Source"]
[]
[null,null,null,"Unit",null,2012,2013,2014,2015,"Total"]
[null,null,"Total Purchased Electricity","kWh",null,{"$f":"'1. Utility Data'!B22","v":0},{"$f":"'1. Utility Data'!B35","v":0},{"$f":"'1. Utility Data'!B48","v":0},{"$f":"'1. Utility Data'!B61","v":0},{"$f":"SUM(F27:I27)","v":0}]
[null,null,"Propane","kWh",null,{"$f":"'1. Utility Data'!E22*26.81","v":0},{"$f":"'1. Utility Data'!E35*26.81","v":0},{"$f":"'1. Utility Data'!E48*26.81","v":0},{"$f":"'1. Utility Data'!E61*26.81","v":0},{"$f":"SUM(F28:I28)","v":0}]
[null,null,"Natural Gas","kWh",null,{"$f":"'1. Utility Data'!H22","v":0},{"$f":"'1. Utility Data'!H35","v":0},{"$f":"'1. Utility Data'!H48","v":0},{"$f":"'1. Utility Data'!H61","v":0},{"$f":"SUM(F29:I29)","v":0}]
[null,null,"Transportation"]
[null,null,"Gasoline","gal",null,{"$f":"'1. Utility Data'!K22","v":0},{"$f":"'1. Utility Data'!K35","v":0},{"$f":"'1. Utility Data'!K48","v":0},{"$f":"'1. Utility Data'!K61","v":0},{"$f":"SUM(F31:I31)","v":0}]
[null,null,"Diesel","gal",null,{"$f":"'1. Utility Data'!N22","v":0},{"$f":"'1. Utility Data'!N35","v":0},{"$f":"'1. Utility Data'!N48","v":0},{"$f":"'1. Utility Data'!N61","v":0},{"$f":"SUM(F32:I32)","v":0}]
[null,null,"Estimation Notes or Other Comments:"]
[]
[]
[]
[]
[null,"Cost per Source"]
[]
[null,null,null,"Unit",null,2012,2013,2014,2015,"Total"]
[null,null,"Total Purchased Electricity","$",null,{"$f":"'1. Utility Data'!C22","v":0},{"$f":"'1. Utility Data'!C35","v":0},{"$f":"'1. Utility Data'!C48","v":0},{"$f":"'1. Utility Data'!C61","v":0},{"$f":"SUM(F41:I41)","v":0}]
[null,null,"Propane","$",null,{"$f":"'1. Utility Data'!F22","v":0},{"$f":"'1. Utility Data'!F35","v":0},{"$f":"'1. Utility Data'!F48","v":0},{"$f":"'1. Utility Data'!F61","v":0},{"$f":"SUM(F42:I42)","v":0}]
[null,null,"Natural Gas","$",null,{"$f":"'1. Utility Data'!I22","v":0},{"$f":"'1. Utility Data'!I35","v":0},{"$f":"'1. Utility Data'!I48","v":0},{"$f":"'1. Utility Data'!I61","v":0},{"$f":"SUM(F43:I43)","v":0}]
[null,null,"Transportation"]
[null,null,"Gasoline","$",null,{"$f":"'1. Utility Data'!L22","v":0},{"$f":"'1. Utility Data'!L35","v":0},{"$f":"'1. Utility Data'!L48","v":0},{"$f":"'1. Utility Data'!L61","v":0},{"$f":"SUM(F45:I45)","v":0}]
[null,null,"Diesel","$",null,{"$f":"'1. Utility Data'!O22","v":0},{"$f":"'1. Utility Data'!O35","v":0},{"$f":"'1. Utility Data'!O48","v":0},{"$f":"'1. Utility Data'!O61","v":0},{"$f":"SUM(F46:I46)","v":0}]
[null,null,"Estimation Notes or Other Comments:"]
[]
[]
[]
[]
[null,"GHG emissions by Source"]
[]
[null,null,null,"Unit","Emission Factor\n(kg CO2e)",2012,2013,2014,2015,"Total"]
[null,null,"Total Purchased Electricity","mtCO2e",{"$f":"561.3*10^-3","v":0.56130000000000002},{"$f":"($E$55*F27)*10^-3","v":0},{"$f":"($E$55*G27)*10^-3","v":0},{"$f":"($E$55*H27)*10^-3","v":0},{"$f":"($E$55*I27)*10^-3","v":0},{"$f":"SUM(F55:I55)","v":0}]
[null,null,"Propane","mtCO2e",0.22733909287257001,{"$f":"($E$56*F28)*10^-3","v":0},{"$f":"($E$56*G28)*10^-3","v":0},{"$f":"($E$56*H28)*10^-3","v":0},{"$f":"($E$56*I28)*10^-3","v":0},{"$f":"SUM(F56:I56)","v":0}]
[null,null,"Natural Gas","mtCO2e",0.20250107991360691,{"$f":"($E$57*F29)*10^-3","v":0},{"$f":"($E$57*G29)*10^-3","v":0},{"$f":"($E$57*H29)*10^-3","v":0},{"$f":"($E$57*I29)*10^-3","v":0},{"$f":"SUM(F57:I57)","v":0}]
[null,null,"Transportation"]
[null,null,"Gasoline","mtCO2e",9.2629999999999999,{"$f":"($E$59*F31)*10^-3","v":0},{"$f":"($E$59*G31)*10^-3","v":0},{"$f":"($E$59*H31)*10^-3","v":0},{"$f":"($E$59*I31)*10^-3","v":0},{"$f":"SUM(F59:I59)","v":0}]
[null,null,"Diesel","mtCO2e",10.47,{"$f":"($E$60*F32)*10^-3","v":0},{"$f":"($E$60*G32)*10^-3","v":0},{"$f":"($E$60*H32)*10^-3","v":0},{"$f":"($E$60*I32)*10^-3","v":0},{"$f":"SUM(F60:I60)","v":0}]
[null,null,"Estimation Notes or Other Comments:"]

{"sheet":"A. Emission Factor Reference","index":4,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[[10,1,10,2],[8,1,8,2],[10,4,10,5],[8,7,8,8],[8,4,8,5],[4,1,5,5],[4,7,5,8],[7,1,7,2],[7,4,7,5],[7,7,7,8]]}
[null,"A. Emissions Factor Reference"]
[null,"Emissions factors utilized in your calculation are provided below for reference."]
[null," All units are measured in kgCO2e"]
[]
[null,"Scope 1",null,null,null,null,null,"Scope 2"]
[]
[]
[null,"Stationary Sources",null,null,"Mobile Sources",null,null,"Purchased Electricity "]
[null,"Natural Gas",null,null,"Diesel-transportation",null,null,"Electric "]
[null,"kWh",0.20250107991360691,null,"gal",10.47,null,"kWh",0.56130000000000002]
[null,"Propane ",null,null,"Gasoline"]
[null,"kWh",0.22733909287257001,null,"gal",9.2629999999999999]
[]
[]
[]
[]
[]
[null,"WRI Mobile Combustion CO2 Emissions Calculation Tool, Version 1.2 (June 2003)"]
[null,"http://www.eia.gov/oiaf/1605/coefficients.html"]
[null,"EPA- Egrid"]
[null,"http://www.iea.org/stats/index.asp"]
[null,"1Intergovernmental Panel on Climate Change, National Greenhouse Gas Inventory Programs, Emissions Factor Database."]
[null,"International Energy Agency Data Services. 2009. \"CO2 Emissions from Fuel Combustion (2011 Edition)\". "]

{"sheet":"B.  Global Warming Potential","index":5,"n_rows":36,"n_cols":3,"rows_kept":36,"cut":false,"hidden":false,"merged":[[35,1,35,4]]}
[]
[null,"B.  Global Warming Potentials"]
[null,"Global Warming Potentials utilized in your calculation are provided below for reference."]
[]
[null,"Gas","Global Warming Potential"]
[null,"Select Processed Emission",0]
[null,"CO2",1]
[null,"CH4",25]
[null,"N2O",298]
[null,"Select Refrigerant",0]
[null,"HFC-23 (CHF3) ",14800]
[null,"HFC-32 (CH2F2)",675]
[null,"HFC-41 (CH3F)"]
[null,"HFC-43-10mee (C5H2F10)",1640]
[null,"HFC-125 (C2HF5)",3500]
[null,"HFC-134 (C2H2F4)"]
[null,"HFC-134a (CH2FCF3)",1430]
[null,"HFC-143 (C2H3F3)"]
[null,"HFC-143a (C2H3F3)",4470]
[null,"HFC-152a (C2H4F2)",124]
[null,"HFC-227ea (C3HF7)",3220]
[null,"HFC-236fa (C3H2F6)",9810]
[null,"HFC-236ea (C3H2F6)"]
[null,"HFC-245ca (C3H3F5)"]
[null,"HFC-245fa (C3H3F5)",1030]
[null,"HFC-365mfc (C4H5F5)",794]
[null,"Perfluoromethane (CF4)",7390]
[null,"Perfluoroethane (C2F6)",12200]
[null,"Perfluoropropane (C3F8)",8830]
[null,"Perfluorobutane (C4F10)",8860]
[null,"Perfluorocyclobutane (c-C4F8)",10300]
[null,"Perfluoropentane (C5F12)",9160]
[null,"Perfluorohexane (C6F14)",9300]
[null,"Amonia",0]
[]
[null,"Source:  IPCC, 2007: Climate Change 2007: The Physical Science Basis. Contribution of Working Group I to the Fourth Assessment.  \nReport of the Intergovernmental Panel on Climate Change.  Table 2.14.  \n<http://ipcc-wg1.ucar.edu/wg1/Report/AR4WG1_Print_Ch02.pdf>"]

{"sheet":"C. Conversion Factors Reference","index":6,"n_rows":34,"n_cols":2,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,"C.  Conversion Factor Reference"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"*2008 GHG Fast Facts- www.EPA.gov"]