{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Energy Intensity Instructions","Example","Energy Intensity Spreadsheet","BTU Converter"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":4,"comments":3,"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":"Energy Intensity Instructions","index":0,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[[20,1,20,10],[1,1,1,10],[2,1,2,10],[4,1,4,10],[6,1,6,10],[19,1,19,10],[27,1,27,10],[28,3,28,10],[29,3,29,10],[21,3,21,10],[22,3,22,10],[23,3,23,10],[24,3,24,10],[25,3,25,10],[26,3,26,10]]}
[]
[null,"Energy Intensity Tracking Spreadsheet Instructions"]
[]
[null,"Introduction: "]
[null,"This calculator is designed to track progress made in reducing energy intensity in industrial plants.  It can be used for multiple plants or production lines with one or more types of products that use varying amounts of energy per unit production."]
[]
[null,"The following table gives detailed definitions for each cell or row of the calculator."]
[]
[null,"User Information"]
[null,"Cell or Row"]
[null,"D3","Company Name","Give company name "]
[null,"D4","Plant ","Identify plant using its location (usually city name).  For example, a plant may be known as: \"Nampa Plant\""]
[null,"D5","Contact Name","Name of the person responsible for completing and/or maintaining the worksheet "]
[null,"D6","Address","Address for the contact person.  Please provide building number, street, city, state, and zip code"]
[null,"D7","Comments ","Provide information that is pertinent to the data or any other issues"]
[null,"H4","Location","Provide specific locations of participating plant(s)"]
[null,"H5","E-mail","E-mail address for the contact person"]
[null,"H6","Phone ","Phone number for the contact person"]
[]
[null,"Energy Intensity Tracking Spreadsheet"]
[null,"Detail instructions for use of the calculator  "]
[null,"B13 to B22","Product or Plant","Enter name of each individual product or participating plants; enter one in each cell from B13 to B22"]
[null,"C13 to C22","Production Line","Enter an identifying number or code for each product produced (not required)"]
[null,"D13 to D22","Production Units Description","Enter the appropriate production units for each product (e.g. number, tons, gallons)"]
[null,"J13 to J22","Energy Used","Enter value of Primary Energy Consumed in million BTU's (MMBTU) for each participating product line or plant. Energy use units may be changed if required but units should be consistent throughout the spreadsheet.  "]
[null,"K13 to K22","Production Quantity","Enter value of number of units produced for each product line or plant participant"]
[null,"L13 to L22","Energy Intensity","Energy Intensity is the ratio between the Primary Energy Consumed and the Number of Production Units. This is automatically calculated."]
[null,"Note: The above instructions should also be used for corresponding cells in later columns for each year."]
[null,"Row 23","Total Primary Energy Consumed","All other cells in the row show the Primary Energy Use in the Current Year."]
[null,"Row 24","Total Improvement in Energy Intensity","Cells in this row represent the Total Improvement in Energy Intensity for the Current Year compared to the previous year."]

{"sheet":"Example","index":1,"n_rows":57,"n_cols":16,"rows_kept":57,"cut":false,"hidden":false,"merged":[[1,9,1,15],[8,9,8,15],[1,1,1,8],[2,1,2,2],[2,3,2,8],[3,1,3,2],[3,3,3,5],[3,7,3,8],[9,10,9,11],[9,13,9,15],[10,9,10,11],[10,12,10,15],[4,1,4,2],[4,3,4,5],[4,7,4,8],[5,1,5,2],[5,3,5,5],[5,7,5,8],[16,3,16,8],[6,1,7,2],[6,3,7,8],[8,1,8,8],[9,1,10,8],[11,3,11,8],[12,3,12,8],[13,3,13,8],[14,3,14,8],[15,3,15,8],[22,9,22,11],[22,12,22,15],[23,1,23,11],[23,12,23,15],[17,3,17,8],[18,3,18,8],[19,3,19,8],[20,3,20,8],[21,3,21,8],[22,1,22,8]]}
[]
[null,"Energy Intensity Tracking Spreadsheet"]
[null,"Company Name",null,"ABC Corporation"]
[null,"Plant",null,"Manufacturing ",null,null,"Location","Boise"]
[null,"Contact Name",null,"John Doe",null,null,"E-mail","cschults@abc.com"]
[null,"Address",null,"1234 Main Street, Boise, ID 83706",null,null,"Phone","208-123-4567"]
[null,"Comments ",null,"EXAMPLE"]
[]
[null,"Worksheet for Energy Intensity Calculations ",null,null,null,null,null,null,null,"EXAMPLE"]
[null,"Baseline Data",null,null,null,null,null,null,null,1,2015,null,{"$f":"J10+1","v":2},{"$f":"K10+1","v":2016}]
[null,null,null,null,null,null,null,null,null,"First Year ",null,null,"Second Year"]
[null,"Product ","Production Line","Production Units Description",null,null,null,null,null,"Energy used (MMBTU) for all production line","Production Qty","Energy intensity MMBTU/unit","Energy used (MMBTU) for all production line","Production Qty","Energy intensity MMBTU/unit","Improvement in energy intensity"]
[null,"Type 1 Vehicles",1,"Number produced",null,null,null,null,null,500000,40000,{"$f":"IF(K13>0,J13/K13,\"\")","v":12.5},400000,35000,{"$f":"IF(N13>0,M13/N13,\"\")","v":11.428571428571429},{"$f":"IFERROR((L13-O13)/L13,\"\")","v":8.5714285714285687E-2}]
[null,"Type 2 Vehicles",2,"Number produced",null,null,null,null,null,1000000,100000,10,900000,90000,10,{"$f":"IFERROR((L14-O14)/L14,\"\")","v":0}]
[null,"Type 3 Vehicles",3,"Number produced",null,null,null,null,null,200000,10000,20,350000,20000,17.5,0.125]
[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,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,null,null,null,null,null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",""]
[null,"Total Primary Energy Consumed, MMBTU/yr",null,null,null,null,null,null,null,{"$f":"+SUM(J13:J22)","v":1700000},null,null,{"$f":"+SUM(M13:M22)","v":1650000}]
[null,"Total Improvement in Energy Intensity, %",null,null,null,null,null,null,null,null,null,null,{"$f":"1-M23/SUMPRODUCT(N13:N22,$L$13:$L$22)","v":5.0359712230215847E-2},{"$f":"-(1-N18/SUMPRODUCT(O8:O17,$I$13:$I$22))","v":{"$error":"#DIV/0!"}},{"$f":"-(1-O18/SUMPRODUCT(P8:P17,$I$13:$I$22))","v":{"$error":"#VALUE!"}},{"$f":"-(1-P18/SUMPRODUCT(#REF!,$I$13:$I$22))","v":{"$error":"#VALUE!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Production Line Additions"]
[null,null,"Baseline year(s)",null,null,null,null,null,"Total Baseline","First Year","Second Year","Third Year","Sixth Year","Seventh Year","Eighth Year","Ninth Year"]
[null,"Years",{"$f":"MIN(E13:E22)","v":0},{"$f":"IF((MIN($E13:$E22)+1)<$K$10,MIN($E13:$E22)+1,\"\")","v":1},{"$f":"IF((MIN($E13:$E22)+2)<$K$10,MIN($E13:$E22)+2,\"\")","v":2},{"$f":"IF((MIN($E13:$E22)+3)<$K$10,MIN($E13:$E22)+3,\"\")","v":3},{"$f":"IF((MIN($E13:$E22)+4)<$K$10,MIN($E13:$E22)+4,\"\")","v":4},{"$f":"IF((MIN($E13:$E22)+5)<$K$10,MIN($E13:$E22)+5,\"\")","v":5},null,{"$f":"K10","v":2015},{"$f":"N10","v":2016},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Total for given year",{"$f":"SUMIF($E$13:$E$22,C50,$G$13:$G$22)","v":0},0,0,0,0,0,{"$f":"SUM(C51:H51)","v":0},{"$f":"SUMIF($E$13:$E$22,J50,$G$13:$G$22)","v":0},0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,"Cumulative",{"$f":"J51","v":0},{"$f":"K51+J52","v":0},0,{"$f":"M51+#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,"Production Line Subtractions"]
[null,null,null,null,null,null,null,null,null,{"$f":"J50","v":2015},2016,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,"Total for given year",{"$f":"SUMIF($F$13:$F$22,J54,$G$13:$G$22)","v":0},0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,"Cumulative",{"$f":"J55","v":0},{"$f":"J56+K55","v":0},0,{"$f":"#REF!+M55","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,"Adjustment = Additions - Subtractions",{"$f":"J52-J56","v":0},0,0,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]

{"sheet":"Energy Intensity Spreadsheet","index":2,"n_rows":57,"n_cols":16,"rows_kept":57,"cut":false,"hidden":false,"merged":[[1,1,1,8],[2,1,2,2],[2,3,2,8],[3,1,3,2],[3,3,3,5],[3,7,3,8],[9,10,9,11],[9,13,9,15],[10,9,10,11],[10,12,10,15],[4,1,4,2],[4,3,4,5],[4,7,4,8],[5,1,5,2],[5,3,5,5],[5,7,5,8],[16,3,16,8],[6,1,7,2],[6,3,7,8],[8,1,8,8],[9,1,10,8],[11,3,11,8],[12,3,12,8],[13,3,13,8],[14,3,14,8],[15,3,15,8],[22,9,22,11],[22,12,22,15],[23,1,23,11],[23,12,23,15],[17,3,17,8],[18,3,18,8],[19,3,19,8],[20,3,20,8],[21,3,21,8],[22,1,22,8]]}
[]
[null,"Energy Intensity Tracking Spreadsheet"]
[null,"Company Name"]
[null,"Plant",null,null,null,null,"Location"]
[null,"Contact Name",null,null,null,null,"E-mail"]
[null,"Address",null,null,null,null,"Phone"]
[null,"Comments "]
[]
[null,"Worksheet for Energy Intensity Calculations"]
[null,"Baseline Data",null,null,null,null,null,null,null,1,2015,null,{"$f":"J10+1","v":2},2016]
[null,null,null,null,null,null,null,null,null,"First Year ",null,null,"Second Year"]
[null,"Product ","Production Line","Production Units Description",null,null,null,null,null,"Energy used (MMBTU) for all production line","Production Qty","Energy intensity MMBTU/unit","Energy used (MMBTU) for all production line","Production Qty","Energy intensity MMBTU/unit","Improvement in energy intensity"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K13>0,J13/K13,\"\")","v":""},null,null,{"$f":"IF(N13>0,M13/N13,\"\")","v":""},{"$f":"IFERROR((L13-O13)/L13,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",{"$f":"IFERROR((L14-O14)/L14,\"\")","v":""}]
[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,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,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,"",{"$f":"IFERROR((L22-O22)/L22,\"\")","v":""}]
[null,"Total Primary Energy Consumed, MMBTU/yr",null,null,null,null,null,null,null,{"$f":"+SUM(J13:J22)","v":0},null,null,{"$f":"+SUM(M13:M22)","v":0}]
[null,"Total Improvement in Energy Intensity, %",null,null,null,null,null,null,null,null,null,null,{"$f":"1-M23/SUMPRODUCT(N13:N22,$L$13:$L$22)","v":{"$error":"#DIV/0!"}},{"$f":"-(1-N18/SUMPRODUCT(O8:O17,$I$13:$I$22))","v":{"$error":"#DIV/0!"}},{"$f":"-(1-O18/SUMPRODUCT(P8:P17,$I$13:$I$22))","v":{"$error":"#VALUE!"}},{"$f":"-(1-P18/SUMPRODUCT(#REF!,$I$13:$I$22))","v":{"$error":"#VALUE!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Production Line Additions"]
[null,null,"Baseline year(s)",null,null,null,null,null,"Total Baseline","First Year","Second Year","Third Year","Sixth Year","Seventh Year","Eighth Year","Ninth Year"]
[null,"Years",{"$f":"MIN(E13:E22)","v":0},{"$f":"IF((MIN($E13:$E22)+1)<$K$10,MIN($E13:$E22)+1,\"\")","v":1},{"$f":"IF((MIN($E13:$E22)+2)<$K$10,MIN($E13:$E22)+2,\"\")","v":2},{"$f":"IF((MIN($E13:$E22)+3)<$K$10,MIN($E13:$E22)+3,\"\")","v":3},{"$f":"IF((MIN($E13:$E22)+4)<$K$10,MIN($E13:$E22)+4,\"\")","v":4},{"$f":"IF((MIN($E13:$E22)+5)<$K$10,MIN($E13:$E22)+5,\"\")","v":5},null,{"$f":"K10","v":2015},{"$f":"N10","v":2016},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Total for given year",{"$f":"SUMIF($E$13:$E$22,C50,$G$13:$G$22)","v":0},0,0,0,0,0,{"$f":"SUM(C51:H51)","v":0},{"$f":"SUMIF($E$13:$E$22,J50,$G$13:$G$22)","v":0},0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,"Cumulative",{"$f":"J51","v":0},{"$f":"K51+J52","v":0},0,{"$f":"M51+#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,"Production Line Subtractions"]
[null,null,null,null,null,null,null,null,null,{"$f":"J50","v":2015},2016,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,"Total for given year",{"$f":"SUMIF($F$13:$F$22,J54,$G$13:$G$22)","v":0},0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,"Cumulative",{"$f":"J55","v":0},{"$f":"J56+K55","v":0},0,{"$f":"#REF!+M55","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,"Adjustment = Additions - Subtractions",{"$f":"J52-J56","v":0},0,0,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]

{"sheet":"BTU Converter","index":3,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,4,34,5],[6,7,6,8],[6,9,6,10],[8,1,9,1],[8,2,9,2],[8,3,9,3],[8,4,8,6]]}
[]
[null,"Quick Converter"]
[null,"Convert common energy units to Source BTUs"]
[]
[null,"1. Enter the annual fuel use of your plant in the Amount column below. "]
[null,"2. The tool converts all energy units to BTUs. "]
[]
[]
[null,"Fuel /Unit","Amount","Conversion factor","On-Site Energy"]
[null,null,null,null,"BTU","KBTU","MMBTU"]
[null,"Electric  (Purchased) - kWh",0,3412,{"$f":"C11*D11","v":0},{"$f":"E11*0.001","v":0},{"$f":"E11*0.000001","v":0}]
[null,"Electric (Purchased) - MWh",0,3412141.5,{"$f":"C12*D12","v":0},{"$f":"E12*0.001","v":0},{"$f":"E12*0.000001","v":0}]
[null,"Electric  (On Site Renewable) - kWh",0,3412,{"$f":"C13*D13","v":0},0,0]
[null,"Natural Gas  - Therms",0,100000,0,0,0]
[null,"Natural Gas - SCF",0,1029,0,0,0]
[null,"Natural Gas - HCF /CCF",0,102900,0,0,0]
[null,"Natural Gas - MCF",0,1029000,0,0,0]
[null,"Propane - Gallons",0,91647.6,0,0,0]
[null,"LPG - Gallons",0,91647.6,0,0,0]
[null,"Distillate Fuel Oil - Gallons",0,138690,0,0,0]
[null,"Residual Fuel Oil - Gallons",0,149690,0,0,0]
[null,"Heating Oil - Gallons",0,138690,0,0,0]
[null,"Diesel Fuel -Gallons",0,138690,0,0,0]
[null,"Motor Gasoline - Gallons",0,124238,0,0,0]
[null,"Kerosene - Gallons",0,135000,0,0,0]
[null,"Crude Oil - Barrels",0,5800000,0,0,0]
[null,"Coal (anthracite) - Tons",0,25090000,{"$f":"C27*D27","v":0},0,0]
[null,"Coal - (bituminous) - Tons",0,24930000,0,0,0]
[null,"District Steam (150 psig) - Pounds",0,1194,0,0,0]
[null,"District Chilled Water - Ton Hours",0,12000,0,0,0]
[null,"District Hot Water - Therms",0,100000,{"$f":"C31*D31","v":0},0,{"$f":"E31*0.000001","v":0}]
[null,"Wood - Tons",0,15380000,0,0,0]
[null,"Biodiesel (100%) - Gallons",0,127000,{"$f":"C33*D33","v":0},0,0]
[null,"Ethanol (100%) - Gallons",0,84262,{"$f":"C34*D34","v":0},0,0]
[null,null,null,null,"Total MMBTU",null,{"$f":"SUM(G11:G34)","v":0}]