{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Main","Calculations","EIA Electricity Prices","Dropdowns","Assumptions"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":9,"comments":0,"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":"Main","index":0,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[7,0,8,8],[11,0,12,8],[15,0,15,4],[38,1,38,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[34,3,34,4],[35,3,35,4],[36,3,36,4],[37,3,37,4],[38,3,38,4],[40,1,41,6],[26,1,26,5],[16,1,16,5],[34,5,34,6],[35,5,35,6],[36,5,36,6],[37,5,37,6],[38,5,38,6]]}
["Energy Savings Calculator for"]
["Advanced Technology Specification:"]
["Heat Pump Water Heaters"]
[]
[]
[]
["Summary"]
["This calculator is intended to illustrate the potential energy savings from the implementation of a heat pump water heater meeting the requirements of the Commercial Building Energy Alliance heat pump water heater specification, as compared to a typical electric storage water heater."]
[]
[]
["Instructions"]
["In order to accurately estimate the energy savings from a heat pump water heater, some user inputs are required.  Below, please select the appropriate representative building.  Based on the building type selected, suggested operating characteristics will be provided in dropdowns in each of the BLUE boxes.  If you select \"Other\" in any of the dropdowns, you may enter your own value in the \"Other\" column.   "]
[]
[]
[]
["User Inputs:",null,null,null,null,null,"Value","Value if \"Other\"","Units"]
["a. ","Select the reference building type that most closely represents your commercial building:",null,null,null,null,"<Select Building Type>"]
[]
["b.","Days of operation for your building:",null,null,null,null,"<Select Annual Operating Days>",null,"days/year"]
[]
["c.","Building daily hot water consumption:",null,null,null,null,"<Select Hot Water Consumption>",null,"gallons/day"]
[]
["d.","Water heater water inlet temperature:",null,null,null,null,"<Select Inlet Temperature>",null,"°F"]
[]
["e.","Water heater water outlet temperature:",null,null,null,null,"<Select Outlet Temperature>",null,"°F"]
[]
["f.","Select the electricity region* that most closely reflects the location of your commercial building, or change your local electricity cost below:",null,null,null,null,"<Select Electricity Region>"]
[null,"* Electricity cost represents the average for each region, per December 2011"]
["g.","Local electricity cost:",null,null,null,null,"-",null,"cents/kWh"]
[]
[]
[]
["Results"]
[]
[null,null,null,"Electric Storage Water Heater (Baseline)",null,"CBEA Heat Pump Water Heater"]
[null,"Annual Energy Consumption (kWh):",-2.237201002025336E+182,{"$f":"IFERROR(Dropdowns!D21, \"\")","v":""},null,{"$f":"IFERROR(Dropdowns!D24, \"\")","v":""}]
[null,"Annual Energy Cost ($/yr):",-335544.32000000001,{"$f":"IFERROR(Dropdowns!D21*G29/100,\"\")","v":""},null,{"$f":"IFERROR(Dropdowns!D24*G29/100,\"\")","v":""}]
[null,"Annual Savings over Baseline (kWh):",null,"-",null,{"$f":"IFERROR(D36-F36,\"\")","v":""}]
[null,"Annual Savings over Baseline ($):",null,"-",null,{"$f":"IFERROR(D37-F37,\"\")","v":""}]
[]
[null,"To learn more about how to start saving, please visit the CBEA Technology Specification Website"]

{"sheet":"Calculations","index":1,"n_rows":170,"n_cols":27,"rows_kept":170,"cut":false,"hidden":true,"merged":[[68,4,68,5],[68,6,68,7],[68,8,68,11],[85,21,85,23],[163,1,163,4],[163,6,163,11],[123,3,123,5],[85,15,85,17],[85,18,85,20]]}
["1. Determine annual water heating load"]
[null,"<Select Building Type>","Quick Service Chain","Small Box Coffee"]
[null,"Days of Operation",365,365,null,null,"User defined"]
[null,"Hot Water Consumption (gallons/day)",500,200,null,null,"Constant"]
[null,"Water Inlet Temperature (°F)",60,60,null,null,"Calculation"]
[null,"Hot Water Outlet Temperature (°F)",140,135]
[null,"Specific Weight of Water @ 110°F (lb/US gallon)",8.27,8.27]
[null,"Specific Heat of Water @ 110°F (Btu/lb-°F)",0.999,0.999]
[]
[null,"Annual Water Heating Load (Btu/yr)",{"$f":"C3*C4*(C6-C5)*C7*C8","v":120621258},{"$f":"D3*D4*(D6-D5)*D7*D8","v":45232971.75}]
[]
[]
["2. Determine annual energy consumption"]
[null,"Thermal Efficiency",1,1]
[null,"Annual Energy Consumption (Btu/yr)",{"$f":"C10/C14","v":120621258},{"$f":"D10/D14","v":45232971.75}]
[]
[]
["3. Convert Btu/yr to kWh/yr"]
[null,"Converter Constant",3412,3412]
[null,"Annual Energy Consumption (kWh/yr)",{"$f":"C15/C19","v":35352.068581477142},{"$f":"D15/D19","v":13257.025718053927}]
[]
[]
["4. Determine annual energy cost"]
[null,"<Select Electricity Region>","East Coast (PADD 1)","Midwest (PADD 2)","Gulf Coast (PADD 3)","Rocky Mountain (PADD 4)","West Coast (PADD 5)","U.S. Average"]
[null,"2010 Electricity Price, per EIA (cents/kWh)",{"$f":"AVERAGE('EIA Electricity Prices'!E8:E25)","v":11.795555555555554},{"$f":"AVERAGE('EIA Electricity Prices'!E26:E40)","v":8.4133333333333322},{"$f":"AVERAGE('EIA Electricity Prices'!E41:E46)","v":8.8450000000000006},{"$f":"AVERAGE('EIA Electricity Prices'!E47:E51)","v":7.7780000000000005},{"$f":"AVERAGE('EIA Electricity Prices'!E52:E58)","v":12.455714285714285},{"$f":"'EIA Electricity Prices'!E69","v":10.19}]
[null,"Annual energy cost, Quick Service Chain",{"$f":"$C$20*C25/100","v":4169.9728895662365},{"$f":"$C$20*D25/100","v":2974.2873699882766},3126.8904660316534,2749.6838942672925,4403.3526565985594,3602.3757884525203]
[null,"Annual energy cost, Small Box Coffee",{"$f":"$D$20*C25/100","v":1563.7398335873386},{"$f":"$D$20*D25/100","v":1115.3577637456035},1172.5839247618699,1031.1314603502344,1651.2572462244598,1350.8909206696951]
[]
[]
[]
["5. Determine HPWH annual energy consumption"]
[null,"COP of existing water heater",1,1]
[null,"COP of HPWH",4.2,4.2]
[null,"HWPH Energy Savings over ESWH",0.7,0.7]
[null,"Annual Energy Consumption (Btu/yr)",{"$f":"(1-C34)*C10","v":36186377.400000006},{"$f":"(1-D34)*D10","v":13569891.525000002}]
[null,"Annual Energy Consumption (kWh/yr)",{"$f":"C35/C19","v":10605.620574443145},{"$f":"D35/D19","v":3977.107715416179}]
[]
[]
["6. Determine HPWH annual energy cost",null,"East Coast (PADD 1)","Midwest (PADD 2)","Gulf Coast (PADD 3)","Rocky Mountain (PADD 4)","West Coast (PADD 5)","U.S. Average"]
[null,"Annual energy cost, Quick Service Chain",{"$f":"$C$36*C25/100","v":1250.991866869871},{"$f":"$C$36*D25/100","v":892.28621099648308},938.0671398094961,824.90516828018781,1321.0057969795682,1080.7127365357564]
[null,"Annual energy cost, Small Box Coffee",{"$f":"$D$36*C25/100","v":469.1219500762017},{"$f":"$D$36*D25/100","v":334.6073291236811},{"$f":"$D$36*E25/100","v":351.77517742856105},309.33943810507043,495.377173867338,405.26727620090861]
[]
[]
["7. Determine energy and cost savings"]
[]
[null,"Annual Energy Savings (kWh/yr)",{"$f":"C20-C36","v":24746.448007034},{"$f":"D20-D36","v":9279.9180026377471}]
[null,null,"East Coast (PADD 1)","Midwest (PADD 2)","Gulf Coast (PADD 3)","Rocky Mountain (PADD 4)","West Coast (PADD 5)","U.S. Average"]
[null,"Annual Cost Savings, Quick Service Chain",{"$f":"C26-C40","v":2918.9810226963655},{"$f":"D26-D40","v":2082.0011589917935},2188.8233262221574,1924.7787259871047,3082.3468596189914,2521.6630519167638]
[null,"Annual Cost Savings, Small Box Coffee",{"$f":"C27-C41","v":1094.6178835111368},780.75043462192241,820.80874733330882,721.79202224516393,1155.8800723571217,945.62364446878655]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2. Using load profile, calculate % Times.  Then calculate Actual Times (per year)"]
[null,"Hours per Year (constant):",null,null,{"$f":"24*365","v":8760}]
[null,"Hours per Week (constant):",null,null,{"$f":"24*7","v":168}]
[]
[null,"See Load Profiles tab for % time and Actual Time calculations"]
[]
[]
["3. Need Reference Building EUI and SF (or Total Energy Use and SF)"]
[]
[null,"Building Type","Location","Vintage","EUI",null,"Reference SF",null,"Annual Energy Use"]
[null,{"$f":"Main!$G$17","v":"<Select Building Type>"},{"$f":"Main!G27","v":"<Select Electricity Region>"},{"$f":"Main!G29","v":"-"},{"$f":"INDEX(#REF!, MATCH(Calculations!D70,#REF!, 0)+MATCH(Calculations!$B$70,#REF!, 0), MATCH(Calculations!$C$70,#REF!, 0))","v":{"$error":"#REF!"}},"kBtu/ft2/yr",{"$f":"VLOOKUP($B$70,#REF!, 19, FALSE)","v":{"$error":"#REF!"}},"SF",{"$f":"E70*G70","v":{"$error":"#REF!"}},"kBtu/yr",{"$f":"I70/$C$75","v":{"$error":"#REF!"}},"kWh"]
["From:","Main tab","Main tab","Main tab","EUI tab",null,"EUI tab",null,"Calculation",null,"Conversion"]
[]
[]
["4. Convert kBtu/ft2/yr to kWh/SF"]
[null,"Btu/Wh:",3.4121416330000001,"Hard-coded constant"]
[]
[]
["5. Calculate Annual Energy Use in kBtu, convert to kWh"]
[null,"See 3. above (Annual Energy Use)"]
[]
[]
["6. Determine Capacity and Calculated Annual Energy Use through Goal Seek"]
[null,"Note:  This will be dependent on the load profile selected"]
[null,null,null,null,null,null,null,null,"Sample Load Profile Selected"]
[null,"Calculated Annual Energy Use:",null,null,{"$f":"$C$86*(K88*L88+K89*L89)","v":{"$error":"#REF!"}},"kWh",null,null,"Name:",{"$f":"VLOOKUP($B$70, $J$5:$K$58, 2, FALSE)","v":{"$error":"#N/A"}}]
[null,"Capacity:",386.49990017042558,"kW",null,null,null,null,"Annual Energy Use (kWh):",null,{"$f":"$K$70","v":{"$error":"#REF!"}},null,"Square Feet:",{"$f":"$G$70","v":{"$error":"#REF!"}},null,"Efficiencies",null,null,"Building Energy Use",null,null,"Transformer Energy Use"]
[null,null,null,null,null,null,null,null,"Load Profile:",null,"% Loading","Actual Time","Power Draw (kVA)","Power Draw/SF (kVA/SF)","User Power Draw (kVA)","BL Eff","T2 Eff","T2NLL Eff","Baseline","T2","T2NLL","Baseline","T2","T2NLL",null,"User % Loading"]
[null,null,{"$f":"E85/K86","v":{"$error":"#REF!"}},null,null,null,null,null,null,1,{"$f":"IF(INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J88,#REF!,0),2)=0,\"\",INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J88,#REF!,0),2))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J88,#REF!,0),7)=0,\"\",INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J88,#REF!,0),7))","v":{"$error":"#REF!"}},{"$f":"IF(L88=\"\",\"\",K88*$C$86)","v":{"$error":"#REF!"}},{"$f":"IF(M88=\"\", \"\", M88/$N$86)","v":{"$error":"#REF!"}},{"$f":"IF(N88=\"\", \"\", N88*$D$116)","v":{"$error":"#REF!"}},{"$f":"IF(O88=\"\", \"\", VLOOKUP($O88, $C$126:$F$146, 2))","v":{"$error":"#REF!"}},{"$f":"IF(P88=\"\", \"\", VLOOKUP($O88, $C$126:$F$146, 3))","v":{"$error":"#REF!"}},{"$f":"IF(Q88=\"\", \"\", VLOOKUP($O88, $C$126:$F$146, 4))","v":{"$error":"#REF!"}},{"$f":"IF(R88=\"\", \"\", $O88*$L88/P88)","v":{"$error":"#REF!"}},{"$f":"IF(S88=\"\", \"\", $O88*$L88/Q88)","v":{"$error":"#REF!"}},{"$f":"IF(T88=\"\", \"\", $O88*$L88/R88)","v":{"$error":"#REF!"}},{"$f":"IF(P88=\"\", \"\", $O88*$L88/P88-($O88*$L88))","v":{"$error":"#REF!"}},{"$f":"IF(Q88=\"\", \"\", $O88*$L88/Q88-($O88*$L88))","v":{"$error":"#REF!"}},{"$f":"IF(R88=\"\", \"\", $O88*$L88/R88-($O88*$L88))","v":{"$error":"#REF!"}},null,{"$f":"IF(U88=\"\", \"\", O88/$D$122)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,2,{"$f":"IF(INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J89,#REF!,0),2)=0,\"\",INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J89,#REF!,0),2))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J89,#REF!,0),7)=0,\"\",INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J89,#REF!,0),7))","v":{"$error":"#REF!"}},{"$f":"IF(L89=\"\",\"\",K89*$C$86)","v":{"$error":"#REF!"}},{"$f":"IF(M89=\"\", \"\", M89/$N$86)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(R89=\"\", \"\", $O89*$L89/P89)","v":{"$error":"#REF!"}},{"$f":"IF(S89=\"\", \"\", $O89*$L89/Q89)","v":{"$error":"#REF!"}},{"$f":"IF(T89=\"\", \"\", $O89*$L89/R89)","v":{"$error":"#REF!"}},{"$f":"IF(P89=\"\", \"\", $O89*$L89/P89-($O89*$L89))","v":{"$error":"#REF!"}},{"$f":"IF(Q89=\"\", \"\", $O89*$L89/Q89-($O89*$L89))","v":{"$error":"#REF!"}},{"$f":"IF(R89=\"\", \"\", $O89*$L89/R89-($O89*$L89))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,"Note:  The Goal Seek macro seeks the Annual Energy Use to the Load Profile AEU by changing the Capacity",null,null,null,null,null,null,null,3,{"$f":"IF(INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J90,#REF!,0),2)=0,\"\",INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J90,#REF!,0),2))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J90,#REF!,0),7)=0,\"\",INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J90,#REF!,0),7))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,4,{"$f":"IF(INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J91,#REF!,0),2)=0,\"\",INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J91,#REF!,0),2))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J91,#REF!,0),7)=0,\"\",INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J91,#REF!,0),7))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,5,{"$f":"IF(INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J92,#REF!,0),2)=0,\"\",INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J92,#REF!,0),2))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J92,#REF!,0),7)=0,\"\",INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J92,#REF!,0),7))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,6,{"$f":"IF(INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J93,#REF!,0),2)=0,\"\",INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J93,#REF!,0),2))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J93,#REF!,0),7)=0,\"\",INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J93,#REF!,0),7))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,7,{"$f":"IF(INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J94,#REF!,0),2)=0,\"\",INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J94,#REF!,0),2))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J94,#REF!,0),7)=0,\"\",INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J94,#REF!,0),7))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,8,{"$f":"IF(INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J95,#REF!,0),2)=0,\"\",INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J95,#REF!,0),2))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J95,#REF!,0),7)=0,\"\",INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J95,#REF!,0),7))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,9,{"$f":"IF(INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J96,#REF!,0),2)=0,\"\",INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J96,#REF!,0),2))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J96,#REF!,0),7)=0,\"\",INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J96,#REF!,0),7))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,10,{"$f":"IF(INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J97,#REF!,0),2)=0,\"\",INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J97,#REF!,0),2))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J97,#REF!,0),7)=0,\"\",INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J97,#REF!,0),7))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,11,{"$f":"IF(INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J98,#REF!,0),2)=0,\"\",INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J98,#REF!,0),2))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J98,#REF!,0),7)=0,\"\",INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J98,#REF!,0),7))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,12,{"$f":"IF(INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J99,#REF!,0),2)=0,\"\",INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J99,#REF!,0),2))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J99,#REF!,0),7)=0,\"\",INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J99,#REF!,0),7))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,13,{"$f":"IF(INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J100,#REF!,0),2)=0,\"\",INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J100,#REF!,0),2))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J100,#REF!,0),7)=0,\"\",INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J100,#REF!,0),7))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,14,{"$f":"IF(INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J101,#REF!,0),2)=0,\"\",INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J101,#REF!,0),2))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J101,#REF!,0),7)=0,\"\",INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J101,#REF!,0),7))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,15,{"$f":"IF(INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J102,#REF!,0),2)=0,\"\",INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J102,#REF!,0),2))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J102,#REF!,0),7)=0,\"\",INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J102,#REF!,0),7))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,16,{"$f":"IF(INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J103,#REF!,0),2)=0,\"\",INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J103,#REF!,0),2))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J103,#REF!,0),7)=0,\"\",INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J103,#REF!,0),7))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,17,{"$f":"IF(INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J104,#REF!,0),2)=0,\"\",INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J104,#REF!,0),2))","v":{"$error":"#REF!"}},{"$f":"IF(INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J104,#REF!,0),7)=0,\"\",INDEX(#REF!,MATCH(Calculations!$J$85,#REF!,0)+MATCH($J104,#REF!,0),7))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(S88:S104)","v":{"$error":"#REF!"}},{"$f":"SUM(T88:T104)","v":{"$error":"#REF!"}},{"$f":"SUM(U88:U104)","v":{"$error":"#REF!"}},{"$f":"SUM(V88:V104)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},"kWh",{"$f":"SUMPRODUCT($Z$88:$Z$104, $L$88:$L$104)/SUM($L$88:$L$104)","v":{"$error":"#REF!"}},"=Weighted Avg Capacity"]
[]
[]
["7. For the building in question, determine Power Draw/% Time table"]
[null,"See 6. above (Power Draw)"]
[]
[null,"Calculate Power Draw/SF"]
[null,"See 6. above (Power Draw/SF)"]
[]
[]
["8. Pd/SF x SFuser = Pd @ each schedule interval"]
[null,"User Input SF:",null,{"$f":"Main!$G$19","v":"<Select Annual Operating Days>"},"SF","Feed in from input page"]
[]
[null,"See 6. above (User Power Draw)"]
[]
[]
["9. Create efficiencies table, using User Capacity"]
[null,"User Input Capacity:",null,{"$f":"Capacity","v":{"$error":"#NAME?"}},"kVA","Feed in from input page"]
[]
[null,null,null,"Efficiencies"]
[null,"Loading","Power Draw","Baseline","Tier2","Tier2 NLL"]
[0.01,0,{"$f":"B126*$D$122","v":{"$error":"#NAME?"}},{"$f":"($A126*$D$122*1000)/(($A126*$D$122*1000)+NLL_BL+($A126^2*LL_BL*T))","v":{"$error":"#NAME?"}},{"$f":"($A126*$D$122*1000)/(($A126*$D$122*1000)+NLL_Tier2+($A126^2*LL_Tier2*T))","v":{"$error":"#NAME?"}},{"$f":"($A126*$D$122*1000)/(($A126*$D$122*1000)+NLL_Tier2NLL+($A126^2*LL_Tier2NLL*T))","v":{"$error":"#NAME?"}}]
[null,0.05,{"$f":"B127*$D$122","v":{"$error":"#NAME?"}},{"$f":"($B127*$D$122*1000)/(($B127*$D$122*1000)+NLL_BL+($B127^2*LL_BL*T))","v":{"$error":"#NAME?"}},{"$f":"($B127*$D$122*1000)/(($B127*$D$122*1000)+NLL_Tier2+($B127^2*LL_Tier2*T))","v":{"$error":"#NAME?"}},{"$f":"($B127*$D$122*1000)/(($B127*$D$122*1000)+NLL_Tier2NLL+($B127^2*LL_Tier2NLL*T))","v":{"$error":"#NAME?"}}]
[null,0.1,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,0.15,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,0.2,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,0.25,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,0.3,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,0.35,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,0.4,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,0.45,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,0.5,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,0.55000000000000004,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,0.6,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,0.65,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,0.7,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,0.75,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,0.8,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,0.85,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,0.9,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,0.95,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,1,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[]
[]
["10. Vlookup efficiencies using Power Draws"]
[null,"See 6. above (Efficiencies)"]
[]
[]
["11. Calculate Building Energy Use of BL, Tier 2, Tier 2 + NLL"]
[null,"Summation, for all N :  [(PowerDrawN x ActualTimeN)/EfficiencyN]"]
[]
[null,"See 6. above (Building Energy Use)"]
[]
["12. Calculate Transformer Energy Use of BL, Tier 2, Tier 2 + NLL models"]
[null,"Summation, for all N: [(PowerDrawN x ActualTimeN)/EfficiencyN]-(PowerDrawN x ActualTimeN)"]
[]
[null,"See 6. above (Transformer Energy Use)"]
[]
["12. Calculate Energy Savings & $"]
[null,"BUILDING ENERGY USE",null,null,null,null,"TRANSFORMER ENERGY USE"]
[null,null,"BL","T2","T2NLL",null,null,null,null,"BL","T2","T2NLL"]
[null,"Building Energy Consump (kWh)",{"$f":"S105","v":{"$error":"#REF!"}},{"$f":"T105","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,null,"Transformer Energy Consump (kWh)",{"$f":"$V$105","v":{"$error":"#REF!"}},{"$f":"$W$105","v":{"$error":"#REF!"}},{"$f":"$X$105","v":{"$error":"#REF!"}}]
[null,"Building Energy Cost ($)",{"$f":"C166*ElecCost","v":{"$error":"#REF!"}},{"$f":"D166*ElecCost","v":{"$error":"#REF!"}},{"$f":"E166*ElecCost","v":{"$error":"#REF!"}},null,null,null,"Transformer Energy Cost ($)",{"$f":"J166*ElecCost","v":{"$error":"#REF!"}},{"$f":"K166*ElecCost","v":{"$error":"#REF!"}},{"$f":"L166*ElecCost","v":{"$error":"#REF!"}}]
[null,"Savings over BL (kWh)","-",{"$f":"$C166-D166","v":{"$error":"#REF!"}},{"$f":"$C166-E166","v":{"$error":"#REF!"}},null,null,null,"Savings over BL (kWh)","-",{"$f":"$J166-K166","v":{"$error":"#REF!"}},{"$f":"$J166-L166","v":{"$error":"#REF!"}}]
[null,"Savings over BL ($)","-",{"$f":"$C167-D167","v":{"$error":"#REF!"}},{"$f":"$C167-E167","v":{"$error":"#REF!"}},null,null,null,"Savings over BL ($)","-",{"$f":"$J167-K167","v":{"$error":"#REF!"}},{"$f":"$J167-L167","v":{"$error":"#REF!"}}]
[null,"Savings over BL (%)","-",{"$f":"($C166-D166)/$C166","v":{"$error":"#REF!"}},{"$f":"($C166-E166)/$C166","v":{"$error":"#REF!"}},null,null,null,"Savings over BL (%)","-",{"$f":"($J166-K166)/$J166","v":{"$error":"#REF!"}},{"$f":"($J166-L166)/$J166","v":{"$error":"#REF!"}}]

{"sheet":"EIA Electricity Prices","index":2,"n_rows":69,"n_cols":13,"rows_kept":69,"cut":false,"hidden":true,"merged":[[3,1,5,2],[3,3,5,4],[3,5,5,6],[3,7,5,8],[3,9,5,10]]}
["EIA Table 5.6.B.  Average Retail Price of Electricity to Ultimate Customers by End-Use Sector, by State, Year-to-Date through December 2011 and 2010"]
["(Cents per Kilowatthour)"]
[]
[null,"Residential",null,"Commercial1",null,"Industrial1",null,"Transportation[1]",null,"All Sectors"]
["Census Division"]
["and State"]
[null,2011,2010,2011,2010,2011,2010,2011,2010,2011,2010,"Region","Original Order"]
["Connecticut",18.11,19.25,15.48,16.45,13.37,14.5,10.33,11.46,16.329999999999998,17.39,"PADD1",2]
["Maine",15.41,15.71,12.27,12.51,8.9,9.17,"--","--",12.58,12.84,"PADD1",3]
["Massachusetts",14.82,14.59,14.45,14.53,13.55,13.71,6.14,6.46,14.26,14.26,"PADD1",4]
["New Hampshire",16.54,16.32,14.02,14.26,12.32,12.75,"--","--",14.75,14.84,"PADD1",5]
["Rhode Island",14.45,15.92,12.49,13.11,11.31,11.82,15.42,13.86,13.15,14.08,"PADD1",6]
["Vermont",16.28,15.57,13.95,13.44,9.86,9.5299999999999994,"--","--",13.79,13.24,"PADD1",7]
["New Jersey",16.239999999999998,16.57,13.48,13.89,11.5,11.81,10.71,11.91,14.32,14.68,"PADD1",9]
["New York",18.3,18.739999999999998,15.83,16.309999999999999,7.8,8.7799999999999994,13.82,13.74,15.94,16.41,"PADD1",10]
["Pennsylvania",13.38,12.7,10.039999999999999,10.1,7.74,7.66,8.93,7.92,10.49,10.31,"PADD1",11]
["Delaware",13.74,13.8,10.62,11.36,9.0500000000000007,9.57,"--","--",11.53,11.97,"PADD1",27]
["District of Columbia",13.4,14.01,12.92,13.42,6.86,7.78,10.220000000000001,11.04,12.82,13.35,"PADD1",28]
["Florida",11.67,11.44,9.99,9.76,8.85,8.85,8.82,8.58,10.77,10.58,"PADD1",29]
["Georgia",11.07,10.07,9.92,9.06,6.64,6.22,7.94,7.46,9.65,8.8699999999999992,"PADD1",30]
["Maryland",13.44,14.32,11.34,11.75,8.81,9.57,8.89,9.7799999999999994,12.02,12.7,"PADD1",31]
["North Carolina",10.29,10.119999999999999,8.18,8.16,6.06,6.17,7.04,7.09,8.6999999999999993,8.67,"PADD1",32]
["South Carolina",11.13,10.5,9.35,8.9,5.96,5.74,"--","--",8.86,8.49,"PADD1",33]
["Virginia",10.68,10.45,7.93,7.65,6.61,6.66,8.24,7.7,8.8699999999999992,8.69,"PADD1",34]
["West Virginia",9.4,8.7899999999999991,8.14,7.66,6.18,5.86,8.6,8.33,7.88,7.45,"PADD1",35]
["Illinois",11.81,11.52,8.64,8.8800000000000008,6.46,6.82,6.81,6.71,9.01,9.1300000000000008,"PADD2",13]
["Indiana",10.06,9.56,8.74,8.3800000000000008,6.25,5.87,9.74,9.2100000000000009,8.0399999999999991,7.67,"PADD2",14]
["Michigan",13.12,12.46,10.32,9.81,7.36,7.08,8.9,10.65,10.37,9.8800000000000008,"PADD2",15]
["Ohio",11.44,11.32,9.6,9.73,6.21,6.4,6.65,8.6199999999999992,9.0500000000000007,9.14,"PADD2",16]
["Wisconsin",13.06,12.65,10.43,9.98,7.34,6.85,"--","--",10.23,9.7799999999999994,"PADD2",17]
["Iowa",10.5,10.42,7.9,7.91,5.21,5.36,"--","--",7.59,7.66,"PADD2",19]
["Kansas",10.63,10.029999999999999,8.7899999999999991,8.25,6.73,6.23,"--","--",8.89,8.35,"PADD2",20]
["Minnesota",10.97,10.59,8.58,8.3800000000000008,6.51,6.29,8.5399999999999991,7.77,8.68,8.41,"PADD2",21]
["Missouri",9.7799999999999994,9.08,8.0399999999999991,7.5,5.95,5.5,6.9,6.14,8.35,7.78,"PADD2",22]
["Nebraska",9.3000000000000007,8.94,8.0399999999999991,7.63,6.26,6,"--","--",7.84,7.52,"PADD2",23]
["North Dakota",8.56,8.1300000000000008,7.58,7.21,6.25,5.81,"--","--",7.49,7.11,"PADD2",24]
["South Dakota",9.34,8.9700000000000006,7.77,7.55,6.3,6.07,"--","--",8.09,7.82,"PADD2",25]
["Kentucky",9.09,8.57,8.41,7.88,5.31,5.05,"--","--",7.11,6.73,"PADD2",38]
["Tennessee",9.83,9.23,10.119999999999999,9.66,7.12,6.58,12.07,11.09,9.14,8.61,"PADD2",40]
["Oklahoma",9.51,9.14,7.63,7.45,5.51,5.35,"--","--",7.83,7.59,"PADD2",44]
["Alabama",11.3,10.67,10.47,10.18,6.33,6.01,"--","--",9.2100000000000009,8.89,"PADD3",37]
["Mississippi",10.14,9.8699999999999992,9.48,9.32,6.57,6.32,"--","--",8.7799999999999994,8.59,"PADD3",39]
["Arkansas",9.0500000000000007,8.86,7.55,7.31,5.65,5.44,11.86,11.33,7.46,7.28,"PADD3",42]
["Louisiana",9.06,8.98,8.4700000000000006,8.5,5.71,5.84,8.33,9.4600000000000009,7.74,7.8,"PADD3",43]
["Texas",11.27,11.6,8.9600000000000009,9.19,6.34,6.44,10.08,9.82,9.18,9.34,"PADD3",45]
["New Mexico",11.04,10.52,8.93,8.57,6.11,6.01,"--","--",8.7100000000000009,8.4,"PADD3",52]
["Colorado",11.26,11.04,9.42,9.1300000000000008,7.12,6.9,9.8000000000000007,9.34,9.39,9.15,"PADD4",48]
["Idaho",7.9,7.99,6.41,6.64,5.16,5.15,"--","--",6.48,6.54,"PADD4",49]
["Montana",9.77,9.16,9.1300000000000008,8.5500000000000007,5.25,5.49,"--","--",8.23,7.88,"PADD4",50]
["Utah",8.9700000000000006,8.7100000000000009,7.35,7.15,5.1100000000000003,4.93,9.24,8.69,7.13,6.94,"PADD4",53]
["Wyoming",9.14,8.77,7.72,7.42,5.4,4.9800000000000004,"--","--",6.58,6.2,"PADD4",54]
["Arizona",11.07,10.97,9.5,9.4700000000000006,6.58,6.63,"--","--",9.73,9.69,"PADD5",47]
["Nevada",11.61,12.36,9,9.7799999999999994,6.66,7.37,8.33,9.4,8.9600000000000009,9.73,"PADD5",51]
["California",15.24,14.75,13.81,13.1,11.01,9.8000000000000007,8.24,8.27,13.79,13.01,"PADD5",56]
["Oregon",9.6,8.8699999999999992,8.19,7.59,5.5,5.41,7.87,6.99,8.08,7.56,"PADD5",57]
["Washington",8.33,8.0399999999999991,7.54,7.37,3.97,4.07,8.5399999999999991,7.42,6.78,6.66,"PADD5",58]
["Alaska",17.57,16.260000000000002,14.94,13.95,15.53,14.14,"--","--",15.96,14.76,"PADD5",60]
["Hawaii",34.68,28.1,32.380000000000003,25.93,28.4,21.94,"--","--",31.59,25.12,"PADD5",61]
["New England",15.98,16.239999999999998,14.33,14.72,12.68,12.98,7.94,8.4499999999999993,14.57,14.89,"Subdivision",1]
["Middle Atlantic",15.86,15.81,13.66,13.93,8.17,8.4,12.56,12.35,13.41,13.6,"Subdivision",8]
["East North Central",11.78,11.41,9.48,9.36,6.59,6.53,6.93,6.93,9.24,9.08,"Subdivision",12]
["West North Central",10.130000000000001,9.64,8.23,7.87,6.09,5.86,7.64,6.95,8.2799999999999994,7.93,"Subdivision",18]
["South Atlantic",11.27,10.96,9.52,9.2899999999999991,6.75,6.66,8.98,9.3800000000000008,9.81,9.61,"Subdivision",26]
["East South Central",10.11,9.58,9.73,9.34,6.18,5.83,12.07,11.09,8.5500000000000007,8.16,"Subdivision",36]
["West South Central",10.55,10.67,8.66,8.7799999999999994,6.06,6.12,9.85,9.7799999999999994,8.67,8.74,"Subdivision",41]
["Mountain",10.57,10.49,8.83,8.75,6.11,6.13,9.4700000000000006,9.1,8.6300000000000008,8.59,"Subdivision",46]
["Pacific Contiguous",12.74,12.31,12.14,11.58,7.92,7.47,8.23,8.23,11.44,10.92,"Subdivision",55]
["Pacific Noncontiguous",27.48,23.22,24.4,20.45,24.99,19.88,"--","--",25.54,21.14,"Subdivision",59]
["U.S. Total",11.8,11.54,10.32,10.19,6.89,6.77,10.58,10.57,9.99,9.83,"Nation",62]

{"sheet":"Dropdowns","index":3,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
[]
["Value",null,{"$f":"IF(Main!G17<>\"Other\",Main!G17,Main!H17)","v":"<Select Building Type>"},{"$f":"IF(Main!G27<>\"Other\",Main!G27,Main!H27)","v":"<Select Electricity Region>"},{"$f":"IF(Main!G29<>\"Other\",Main!G29,Main!H29)","v":"-"},{"$f":"IF(Main!G19<>\"Other\",Main!G19,Main!H19)","v":"<Select Annual Operating Days>"},{"$f":"IF(Main!G21<>\"Other\",Main!G21,Main!H21)","v":"<Select Hot Water Consumption>"},{"$f":"IF(Main!G23<>\"Other\",Main!G23,Main!H23)","v":"<Select Inlet Temperature>"},{"$f":"IF(Main!G25<>\"Other\",Main!G25,Main!H25)","v":"<Select Outlet Temperature>"},{"$f":"Calculations!C14","v":1},{"$f":"Calculations!C34","v":0.7}]
["Dropdown Name",null,"Building_Type","Electricity_Region","Electricity_Costs","Days_Operating","HW_Consumption","Inlet_Temp","Outlet_Temp","HP_Efficiency","Savings"]
["Entries",null,"<Select Building Type>","<Select Electricity Region>",{"$f":"IF(Main!G27=Calculations!C24,Calculations!C25,IF(Main!G27=Calculations!D24,Calculations!D25,IF(Main!G27=Calculations!E24,Calculations!E25,IF(Main!G27=Calculations!F24,Calculations!F25,IF(Main!G27=Calculations!G24,Calculations!G25,IF(Main!G27=Calculations!H24,Calculations!H25,\"-\"))))))","v":"-"},"<Select Annual Operating Days>","<Select Hot Water Consumption>","<Select Inlet Temperature>","<Select Outlet Temperature>"]
[null,null,"Quick Service Chain","East Coast (PADD 1)","Other",{"$f":"IF(Main!G17=Calculations!C2, Calculations!C3,IF(Main!G17=Calculations!D2,Calculations!D3,\"-\"))","v":"-"},{"$f":"IF(Main!G17=Calculations!C2, Calculations!C4,IF(Main!G17=Calculations!D2,Calculations!D4,\"-\"))","v":"-"},{"$f":"IF(Main!G17=Calculations!C2,Calculations!C5,IF(Main!G17=Calculations!D2,Calculations!D5,\"-\"))","v":"-"},{"$f":"IF(Main!G17=Calculations!C2,Calculations!C6,IF(Main!G17=Calculations!D2,Calculations!D6,\"-\"))","v":"-"}]
[null,null,"Small Box Coffee","Midwest (PADD 2)",null,"Other","Other","Other","Other"]
[null,null,"Other","Gulf Coast (PADD 3)"]
[null,null,null,"Rocky Mountain (PADD 4)"]
[null,null,null,"West Coast (PADD 5)"]
[null,null,null,"U.S. Average"]
[]
[]
[]
[]
[]
["Calculations for Table"]
[]
[null,null,"Metric","Value"]
[null,null,"Annual water heating load ",{"$f":"F2*G2*(I2-H2)*Calculations!C7*Calculations!C8","v":{"$error":"#VALUE!"}}]
[null,null,"Annual energy consumption (kWh)",{"$f":"D19/J2","v":{"$error":"#VALUE!"}}]
[null,null,"Annual energy consumption (kWh)",{"$f":"D20/Calculations!C19","v":{"$error":"#VALUE!"}}]
[]
[null,null,"HPWH annual energy consumption ",{"$f":"(1-K2)*D19","v":{"$error":"#VALUE!"}}]
[null,null,"HPWH annual energy consumption (kWh)",{"$f":"D23/Calculations!C19","v":{"$error":"#VALUE!"}}]

{"sheet":"Assumptions","index":4,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Heat Pump Efficiency ",null,null,null,null,"Source"]
[1,null,null,null,null,"Zogg et al., “Energy Savings Potential and RD&D Opportunities for Commercial Building Appliances ” (Navigant Consulting, Inc., 2009)."]
[]
["Heat pump savings over electric storage water heater"]
[0.7,null,null,null,null,"Zogg et al., “Energy Savings Potential and RD&D Opportunities for Commercial Building Appliances ” (Navigant Consulting, Inc., 2009)."]