{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Scenarios","Chart - First Cost","Chart - Energy Cost","Chart - PV of Costs","HeaterData","StatesTable","ListCost","NPVTable","Figure 1"],"not_rendered":{"charts":6,"images":2,"macros":1,"external_links":1,"defined_names":33,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Chart - First Cost","index":1,"reason":"not_a_worksheet"},{"sheet":"Chart - Energy Cost","index":2,"reason":"not_a_worksheet"},{"sheet":"Chart - PV of Costs","index":3,"reason":"not_a_worksheet"}],"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":"Scenarios","index":0,"n_rows":87,"n_cols":17,"rows_kept":87,"cut":false,"hidden":false,"merged":[[86,12,88,16],[86,9,88,11],[15,9,15,11],[1,9,1,11],[2,9,2,11],[14,9,14,11],[13,9,13,11],[8,9,8,11]]}
[]
[null,null,null,null,null,null,null,null,null,"Select your State from drop down menu below to use typical values for your state",null,null,null,null,"Questions or Feedback?"]
[null,null,null,null,null,null,null,null,null,"Default Rates",null,null,null,null,"Please contact Dan Howett at"]
[null,null,null,null,null,null,null,null,null,"U.S. State selected",{"$f":"VLOOKUP(Selected_State,StatesDataTable,1,)","v":"Default Rates"},null,null,null,"Oak Ridge National Lab."]
[null,null,null,null,null,null,null,null,null,"commercial cost of electricity",{"$f":"VLOOKUP(Selected_State,StatesDataTable,4,)/100","v":0.1},"/kWh",null,null,"E-mail:  HowettDH@ORNL.gov"]
[null,null,null,null,null,null,null,null,null,"commercial cost of natural gas",{"$f":"VLOOKUP(Selected_State,StatesDataTable,2,)/10","v":1},"/Therm",null,null,"Phone:  865-253-0567"]
[null,null,null,null,null,null,null,null,null,"cost of steam @85% efficiency",{"$f":"NaturalGasRate/0.85","v":1.1764705882352942},"/100 lbs"]
[null,null,null,null,null,null,null,null,null,"average ground water temperature",{"$f":"VLOOKUP(Selected_State,StatesDataTable,5,)","v":40},"oF"]
[null,null,null,null,null,null,null,null,null,"Life Cycle Cost Analysis Assumptions"]
[null,null,null,null,null,null,null,null,null,"Water Heater Life",{"$f":"HeaterData!B43","v":12},"years"]
[null,null,null,null,null,null,null,null,null,"Real Discount Rate",{"$f":"HeaterData!B44","v":0.03},"%/year"]
[null,null,null,null,null,null,null,null,null,"Real Energy Escalation Rate",{"$f":"HeaterData!B45","v":0.03},"%/year"]
[null,null,null,null,null,null,null,null,null,"Real O&M Escalation Rate",{"$f":"HeaterData!B46","v":0.03},"%/year"]
[null,null,null,null,null,null,null,null,null,"Select the Building type from drop down menu below"]
[null,"Description","Office","Military Barracks","Nursing Home","Grill / Snack Shop","Restaurant","do not delete",null,"Grill / Snack Shop"]
[null,null," ",null," "," ",null,{"$f":"ROW(H16)-ROW($H$15)+1","v":2}]
[null,{"$f":"J17","v":"CALCULATION OF REQUIRED HEATER SIZE"},null,null,null,null,null,{"$f":"ROW(H17)-ROW($H$15)+1","v":3},null,"CALCULATION OF REQUIRED HEATER SIZE"]
[null,{"$f":"J18","v":"# of persons, meals served, etc."},1000,72,100,100,300,4,null,"# of persons, meals served, etc.",{"$f":"HLOOKUP($J$15,TestData,H18,)","v":100}]
[null,{"$f":"J19","v":"Unit of occupancy"},"Persons","Persons","Patient Beds","Meals per hr","Meals Served",5,null,"Unit of occupancy","Meals per hr"]
[null,"Number of Occupied Days per Week",5,7,7,7,7,6,null,"Number of Occupied Days per Week",7]
[null,"Maximum GPH per person",0.4,{"$f":"$D$34","v":23.75},4.5,0.7,1.5,7,null,"Maximum GPH per person",0.7]
[null,"Storage Tank Sizing, gallons per occupant",0.42,12.5,2,4,7,8,null,"Storage Tank Sizing, gallons per occupant",4]
[null,"Avg gallons per day per occupant, meal served, etc.",1,{"$f":"$D$34","v":23.75},18.399999999999999,0.7,2.4,9,null,"Avg gallons per day per occupant, meal served, etc.",0.7]
[null,"Percent occupancy or diversity",1,1,1,1,1,10,null,"Percent occupancy or diversity",1]
[null,"Tank cold water entering temperature, F",{"$f":"VLOOKUP(Selected_State,StatesDataTable,5,)","v":40},{"$f":"VLOOKUP(Selected_State,StatesDataTable,5,)","v":40},{"$f":"VLOOKUP(Selected_State,StatesDataTable,5,)","v":40},{"$f":"VLOOKUP(Selected_State,StatesDataTable,5,)","v":40},{"$f":"VLOOKUP(Selected_State,StatesDataTable,5,)","v":40},11,null,"Tank cold water entering temperature, F",40]
[null,"Water service temperature (at fixture), F",105,105,105,140,140,12,null,"Water service temperature (at fixture), F",140]
[null,"Tank storage temperature, F",140,140,140,140,140,13,null,"Tank storage temperature, F",140]
[null,null,null,null,null,null,null,null,null,"Temperature rise, F (Ttank-Tcold)",{"$f":"K27-K25","v":100}]
[null,null,null,null,null,null,null,null,null,""]
[null,null,"Military Barracks Assumptions",null,null,null,null,null,null,"HEATER SIZING RESULTS"]
[null,null,"occupants/fixture",2,null,null,null,null,null,{"$f":"\"Peak Demand, GPH @\"&K26&\" F\"","v":"Peak Demand, GPH @140 F"},{"$f":"K18*K21*K24","v":70}]
[null,null,"fixture, gpm",2.5,null,null,null,null,null,"Percent Mixed Water",{"$f":"(K26-K25)/(K27-K25)","v":1}]
[null,null,"usage, min/occupant",9.5,null,null,null,null,null,{"$f":"\"Peak Demand, GPH @\"&K27&\" F\"","v":"Peak Demand, GPH @140 F"},{"$f":"K31*K32","v":70}]
[null,null,"peak flow gal/occ/hr",{"$f":"D32*D33","v":23.75},null,null,null,null,null,"Tank Storage, gallons",{"$f":"K22*K18","v":400}]
[null,null,"fixture duration, seconds",{"$f":"D33*D31*60","v":1140},null,null,null,null,null,"Usable Tank Storage, gallons",{"$f":"Tank_Size__gallons*Pct_Usable_Storage","v":300}]
[null,null,null,"w/storage","w/o storage",null,null,null,null,"Recovery GPH",{"$f":"IF(J15=\"Military Barracks\",D39,Demand-Pct_Usable_Storage*Tank_Size__gallons)","v":-230}]
[null,null,"demand gallons",{"$f":"$D$32*$D$33*$D$18*(($D$26-$D$25)/($D$27-$D$25))","v":1111.5},{"$f":"$D$32*$D$33*$D$18*(($D$26-$D$25)/($D$27-$D$25))","v":1111.5}]
[null,null,"storage gallons",{"$f":"D22*D18","v":900},0,null,null,null,null,"Btu/Hr Output",{"$f":"K31*DensityWater*(K26-K25)","v":58310}]
[null,null,"recovery GPH",{"$f":"((D37-Pct_Usable_Storage*D38)/$D$35)*3600","v":1378.421052631579},{"$f":"((E37-Pct_Usable_Storage*E38)/$D$35)*3600","v":3510},null,null,null,null,"kW Output",{"$f":"K38/BTUperkWh","v":17.089683470105509}]
[]
[null,null,null,null,null,null,null,null,null,"ANNUAL ENERGY USAGE AND COSTS"]
[]
[null,null,null,null,null,null,null,null,null,"Gallons per day",{"$f":"K23*K18","v":70}]
[null,null,null,null,null,null,null,null,null,"Occupied days per year",{"$f":"ROUND(365*(K20/7),0)","v":365}]
[null,null,null,null,null,null,null,null,null,"Gallons per year",{"$f":"K43*K44","v":25550}]
[null,null,null,null,null,null,null,null,null,"Annual Btu/yr @100% efficiency",{"$f":"K45*DensityWater*(K26-K25)","v":21283150}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Electric","Nat. Gas","Nat. Gas","Nat. Gas","Steam","Electric","Nat. Gas"]
[null,null,null,null,null,null,null,null,null,null,"Standard","Standard","Condensing","CWH","Indirect HX","Tankless","Tankless"]
[null,null,null,null,null,null,null,null,null,null,"Tank","Tank","Tank","No Storage","Tank"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K50&\" \"&K51&\" \"&K52","v":"Electric Standard Tank"},{"$f":"L50&\" \"&L51&\" \"&L52","v":"Nat. Gas Standard Tank"},{"$f":"M50&\" \"&M51&\" \"&M52","v":"Nat. Gas Condensing Tank"},{"$f":"N50&\" \"&N51&\" \"&N52","v":"Nat. Gas CWH No Storage"},{"$f":"O50&\" \"&O51&\" \"&O52","v":"Steam Indirect HX Tank"},{"$f":"P50&\" \"&P51","v":"Electric Tankless"},{"$f":"Q50&\" \"&Q51","v":"Nat. Gas Tankless"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*","**"]
[null,null,null,null,null,null,null,null,null,"Annual Btu/yr @100% efficiency",{"$f":"$K$46","v":21283150},21283150,21283150,21283150,{"$f":"IF(OR($J$15=\"Military Barracks\",$J$15=\"Restaurant\"), $K$46,\"N/A\")","v":"N/A"},21283150,21283150]
[null,null,null,null,null,null,null,null,null,"Thermal Efficiency",{"$f":"VLOOKUP(K54,WaterHeaterTable,4,)","v":0.98},0.85,0.95,0.95,0.85,0.99,0.93]
[null,null,null,null,null,null," ",null,null,"Total Fuel Input, Btu/yr.",{"$f":"(K56/K57)","v":21717500},{"$f":"(L56/L57)","v":25039000},22403315.789473686,22403315.789473686,{"$f":"IF(OR($J$15=\"Military Barracks\",$J$15=\"Restaurant\"), (O56/O57),\"N/A\")","v":"N/A"},21498131.313131314,22885107.526881721]
[]
[null,null,null,null,null,null,null,null,null,"Annual Fuel Usage (kWh/yr)",{"$f":"IF(K50=\"Electric\",K58/BTUperkWh,K58/100000)","v":6365.0351699882767},250.39,224.03315789473686,224.03315789473686,{"$error":"#VALUE!"},6300.7418854429407,228.8510752688172]
[null,null,null,null,null,null,null,null,null,"Energy Rate ",{"$f":"VLOOKUP(K$54,WaterHeaterTable,29,)","v":0.1},{"$f":"VLOOKUP(L$54,WaterHeaterTable,29,)","v":1},1,1,1.1764705882352942,0.1,1]
[null,null,null,null,null,null,null,null,null,"Annual Energy Cost, $/yr",{"$f":"K60*K61","v":636.50351699882776},250.39,224.03315789473686,224.03315789473686,{"$f":"IF(OR($J$15=\"Military Barracks\",$J$15=\"Restaurant\"), O60*O61,\"N/A\")","v":"N/A"},630.07418854429409,228.8510752688172]
[]
[null,null,null,null,null,null,null,null,null,"Number of Heaters",{"$f":"VLOOKUP(K$54,WaterHeaterTable,25,)","v":1},{"$f":"VLOOKUP(L$54,WaterHeaterTable,25,)","v":1},{"$f":"VLOOKUP(M$54,WaterHeaterTable,25,)","v":1},{"$f":"VLOOKUP(N$54,WaterHeaterTable,25,)","v":1},{"$f":"IF(OR($J$15=\"Military Barracks\",$J$15=\"Restaurant\"), 1,\"N/A\")","v":"N/A"},{"$f":"VLOOKUP(P$54,WaterHeaterTable,25,)","v":1},{"$f":"VLOOKUP(Q$54,WaterHeaterTable,25,)","v":1}]
[null,null,null,null,null,null,null,null,null,"Heater Storage gallons",{"$f":"VLOOKUP(K$54,WaterHeaterTable,27,)","v":119},71,50,50,{"$f":"IF(OR($J$15=\"Military Barracks\",$J$15=\"Restaurant\"), 0,\"N/A\")","v":"N/A"},0,0]
[null,null,null,null,null,null,null,null,null,"External Usable storage, gallons",{"$f":"IF(K65>=$K$35,0,$K$35-K65)","v":181},{"$f":"IF(L65>=$K$35,0,$K$35-L65)","v":229},{"$f":"IF(M65>=$K$35,0,$K$35-M65)","v":250},{"$f":"IF(N65>=$K$35,0,$K$35-N65)","v":250},{"$f":"IF(OR($J$15=\"Military Barracks\",$J$15=\"Restaurant\"), Tank_Size__gallons,\"N/A\")","v":"N/A"},0,0]
[]
[null,null,null,null,null,null,null,null,null,"Water Heater Cost",{"$f":"VLOOKUP(K$54,WaterHeaterTable,26,)","v":8829},{"$f":"VLOOKUP(L$54,WaterHeaterTable,26,)","v":6187.23},{"$f":"VLOOKUP(M$54,WaterHeaterTable,26,)","v":3268.3},{"$f":"VLOOKUP(N$54,WaterHeaterTable,26,)","v":3268.3},{"$f":"IF(OR($J$15=\"Military Barracks\",$J$15=\"Restaurant\"), 0,\"N/A\")","v":"N/A"},{"$f":"VLOOKUP(P$54,WaterHeaterTable,26,)","v":729},{"$f":"VLOOKUP(Q$54,WaterHeaterTable,26,)","v":637.75}]
[null,null,null,null,null,null,null,null,null,"Additional Storage Cost",{"$f":"IF(OR($J$15=\"Military Barracks\",$J$15=\"Restaurant\"),HeaterData!$J$20+HeaterData!$K$20*Tank_Size__gallons,0)","v":0},{"$f":"IF(OR($J$15=\"Military Barracks\",$J$15=\"Restaurant\"),HeaterData!$J$20+HeaterData!$K$20*L66/Pct_Usable_Storage,0)","v":0},{"$f":"IF(OR($J$15=\"Military Barracks\",$J$15=\"Restaurant\"),HeaterData!$J$20+HeaterData!$K$20*M66/Pct_Usable_Storage,0)","v":0},0,{"$f":"IF(OR($J$15=\"Military Barracks\",$J$15=\"Restaurant\"),HeaterData!$J$20+HeaterData!$K$20*O66/Pct_Usable_Storage,\"N/A\")","v":"N/A"},0,0]
[null,null,null,null,null,null,null,null,null,"Installation Cost",{"$f":"VLOOKUP(K$54,WaterHeaterTable,13,)*K64","v":800},{"$f":"VLOOKUP(L$54,WaterHeaterTable,13,)*L64","v":1000},{"$f":"VLOOKUP(M$54,WaterHeaterTable,13,)*M64","v":2000},{"$f":"VLOOKUP(N$54,WaterHeaterTable,13,)*N64","v":1000},{"$f":"IF(OR($J$15=\"Military Barracks\",$J$15=\"Restaurant\"), VLOOKUP(O$54,WaterHeaterTable,13,),\"N/A\")","v":"N/A"},{"$f":"VLOOKUP(P$54,WaterHeaterTable,13,)*P64","v":800},{"$f":"VLOOKUP(Q$54,WaterHeaterTable,13,)*Q64","v":1000}]
[null,null,null,null,null,null,null,null,null,"Total First Cost",{"$f":"K68+K69+K70","v":9629},7187.23,5268.3,4268.3,{"$f":"IF(OR($J$15=\"Military Barracks\",$J$15=\"Restaurant\"), O68+O69+O70,\"N/A\")","v":"N/A"},1529,1637.75]
[]
[null,null,null,null,null,null,null,null,null,"1st Year Energy Cost",{"$f":"K62","v":636.50351699882776},250.39,224.03315789473686,224.03315789473686,"N/A",630.07418854429409,228.8510752688172]
[null,null,null,null,null,null,null,null,null,"Discounted UPV Factor Energy",{"$f":"Discounted_UPV_Factor_Energy","v":12},12,12,12,12,12,12]
[null,null,null,null,null,null,null,null,null,"NPV Energy Cost",{"$f":"K73*K74","v":7638.0422039859332},3004.68,2688.3978947368423,2688.3978947368423,{"$error":"#VALUE!"},7560.8902625315295,2746.2129032258063]
[]
[null,null,null,null,null,null,null,null,null,"Yearly O&M Cost",{"$f":"VLOOKUP(K$54,WaterHeaterTable,14,)","v":200},{"$f":"VLOOKUP(L$54,WaterHeaterTable,14,)*L64","v":200},{"$f":"VLOOKUP(M$54,WaterHeaterTable,14,)*M64","v":200},{"$f":"VLOOKUP(N$54,WaterHeaterTable,14,)*N64","v":200},{"$f":"IF(OR($J$15=\"Military Barracks\",$J$15=\"Restaurant\"), VLOOKUP(O$54,WaterHeaterTable,14,),\"N/A\")","v":"N/A"},{"$f":"VLOOKUP(P$54,WaterHeaterTable,14,)","v":50},{"$f":"VLOOKUP(Q$54,WaterHeaterTable,14,)","v":50}]
[null,null,null,null,null,null,null,null,null,"Discounted UPV Factor Non Fuel",{"$f":"Discounted_UPV_Factor_Non_Fuel","v":12},12,12,12,12,12,12]
[null,null,null,null,null,null,null,null,null,"NPV O&M Cost",{"$f":"K77*K78","v":2400},2400,2400,2400,{"$error":"#VALUE!"},600,600]
[]
[null,null,null,null,null,null,null,null,null,"First Cost",{"$f":"K68+K70","v":9629},{"$f":"L68+L70","v":7187.23},{"$f":"M71","v":5268.3},{"$f":"N71","v":4268.3},{"$f":"IF(OR($J$15=\"Military Barracks\",$J$15=\"Restaurant\"), O69+O70,\"N/A\")","v":"N/A"},{"$f":"P68+P70","v":1529},{"$f":"Q68+Q70","v":1637.75}]
[null,null,null,null,null,null,null,null,null,"Present Value of Energy Cost",{"$f":"K75","v":7638.0422039859332},{"$f":"L75","v":3004.68},2688.3978947368423,2688.3978947368423,{"$f":"IF(OR($J$15=\"Military Barracks\",$J$15=\"Restaurant\"), O75,\"N/A\")","v":"N/A"},7560.8902625315295,2746.2129032258063]
[null,null,null,null,null,null,null,null,null,"Present Value of O&M Cost",{"$f":"K79","v":2400},{"$f":"L79","v":2400},2400,2400,{"$f":"IF(OR($J$15=\"Military Barracks\",$J$15=\"Restaurant\"), O79,\"N/A\")","v":"N/A"},600,600]
[null,null,null,null,null,null,null,null,null,"TOTAL Present Value",{"$f":"K81+K82+K83","v":19667.042203985933},12591.91,10356.697894736842,9356.6978947368425,{"$f":"IF(OR($J$15=\"Military Barracks\",$J$15=\"Restaurant\"), O81+O82+O83, \"N/A\")","v":"N/A"},9689.8902625315295,4983.9629032258063]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($J$15=\"Military Barracks\",$J$15=\"Restaurant\"), \"\",\"* NOTE: Steam Indirect HX Systems are not applicable to Office, Nursing Home or Grill/Snack Shop\")","v":"* NOTE: Steam Indirect HX Systems are not applicable to Office, Nursing Home or Grill/Snack Shop"},null,null,"** NOTE: When using the electric tankless option, addtitional electrical service will probably need to be installed. This can be an expensive addtiona to the initial cost"]

{"sheet":"HeaterData","index":4,"n_rows":46,"n_cols":35,"rows_kept":46,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Chart Titles"]
["Chart 1",{"$f":"\"Annual Energy Cost for \"&Scenarios!K18&\" \"&Scenarios!J15&\" \"&Scenarios!K19","v":"Annual Energy Cost for 100 Grill / Snack Shop Meals per hr"}]
["Chart 2",{"$f":"\"Water Heater First Cost for \"&Scenarios!K18&\" \"&Scenarios!J15&\" \"&Scenarios!K19","v":"Water Heater First Cost for 100 Grill / Snack Shop Meals per hr"}]
["Chart 3",{"$f":"\"Present Value of Costs Associated with Water Heating System that Serves \"&Scenarios!K18&\" \"&Scenarios!J15&\" \"&Scenarios!K19","v":"Present Value of Costs Associated with Water Heating System that Serves 100 Grill / Snack Shop Meals per hr"}]
[]
["Field1","Field2","Field3","Field4","Field5","Field6","Field7","Field8","Field9","Field10","Field11","Field12","Field13","Field14","Field15","Field16","Field17","Field18","Field19","Field20","Field21","Field22","Field23","Field24","Field25","Field26","Field27","Field28","Field29","Field30","Field31","Field32","Field33","Field34","Field35"]
["Water Heater Technology","Energy Type","Minimum Size Comment","Thermal Efficiency","Minimum Technology Demand",null,"Cost Comment","Cost Reference","Model Reference","Cost Regression Coefficient\n for Intercept","Cost Regression Coefficient for Gallons","Cost Regression Coefficient for BTUH","Installation Cost","O&M Cost","Energy Conversion By Fuel Type",null,"Annual Energy Cost","Chart X Axis",{"$f":"Q8","v":"Annual Energy Cost"},{"$f":"R8","v":"Chart X Axis"},"First Cost","NPV Energy Cost","NPV O&M",null,"Number of Heaters","Equpment Cost LookUp","Total Heater Storage Gallons",null,"Selected Energy Rates","Energy Units","Btu per Unit of Energy","Field26","Field27","Field28","Field29"]
["Electric Standard Tank","Electric","\"This scenario's demand is \"&Demand Recovery&\" and appears to be a poor fit for this water heater technology\"",0.98,null,null,null,"Lochinvar","Standard Hi-Power Electric Water Heaters","reg. not used","reg. not used","reg. not used",800,200,{"$f":"DensityWater/BTUperkWh","v":2.4413833528722159E-3},null,{"$f":"Scenarios!K73","v":636.50351699882776},{"$f":"A9","v":"Electric Standard Tank"},636.50351699882776,"Electric Standard Tank",{"$f":"Scenarios!K71","v":9629},{"$f":"S9*Discounted_UPV_Factor_Energy","v":7638.0422039859332},{"$f":"Scenarios!K79","v":2400},null,{"$f":"SUM(ListCost!R60:R78)","v":1},{"$f":"SUM(ListCost!S60:S78)","v":8829},{"$f":"SUM(ListCost!T60:T78)","v":119},null,{"$f":"Scenarios!K5","v":0.1},"kWh",{"$f":"BTUperkWh","v":3412}]
["Nat. Gas Standard Tank","Natural Gas",null,0.85,null,null,null,"A. O. Smith",null,"reg. not used","reg. not used","reg. not used",1000,200,{"$f":"DensityWater/BTUperTherm","v":8.3300000000000005E-5},null,{"$f":"Scenarios!L73","v":250.39},"Nat. Gas Standard Tank",250.39,"Nat. Gas Standard Tank",{"$f":"Scenarios!L71","v":7187.23},3004.68,{"$f":"Scenarios!L79","v":2400},null,{"$f":"SUM(ListCost!R33:R49)","v":1},{"$f":"SUM(ListCost!S33:S49)","v":6187.23},{"$f":"SUM(ListCost!T33:T49)","v":71},null,{"$f":"NaturalGasRate","v":1},"Therms",{"$f":"BTUperTherm","v":100000}]
["Nat. Gas Condensing Tank","Natural Gas",null,0.95,null,null,null,"A. O. Smith",null,"reg. not used","reg. not used","reg. not used",2000,200,{"$f":"DensityWater/BTUperkWh","v":2.4413833528722159E-3},null,{"$f":"Scenarios!M73","v":224.03315789473686},"Nat. Gas Condensing Tank",224.03315789473686,"Nat. Gas Condensing Tank",{"$f":"Scenarios!M71","v":5268.3},2688.3978947368423,{"$f":"Scenarios!M79","v":2400},null,{"$f":"SUM(ListCost!R10:R26)","v":1},{"$f":"SUM(ListCost!S10:S26)","v":3268.3},{"$f":"SUM(ListCost!T10:T26)","v":50},null,{"$f":"NaturalGasRate","v":1},"Therms",{"$f":"BTUperTherm","v":100000}]
["Nat. Gas CWH No Storage","Natural Gas",null,0.95,null,null,null,"A. O. Smith",null,"reg. not used","reg. not used","reg. not used",1000,200,{"$f":"DensityWater/BTUperkWh","v":2.4413833528722159E-3},null,{"$f":"Scenarios!N73","v":224.03315789473686},{"$f":"A12","v":"Nat. Gas CWH No Storage"},{"$f":"Q12","v":224.03315789473686},{"$f":"R12","v":"Nat. Gas CWH No Storage"},{"$f":"Scenarios!N71","v":4268.3},{"$f":"S12*Discounted_UPV_Factor_Energy","v":2688.3978947368423},{"$f":"Scenarios!N79","v":2400},null,{"$f":"SUM(ListCost!R10:R26)","v":1},{"$f":"SUM(ListCost!S10:S26)","v":3268.3},{"$f":"SUM(ListCost!T10:T26)","v":50},null,{"$f":"NaturalGasRate","v":1},"Therms",{"$f":"BTUperTherm","v":100000}]
["Steam Indirect HX Tank","Steam",null,0.85,null,null,null,"Lochinvar","Glass lined tank + double walled tube  bundle",{"$f":"J21","v":10468.88739655929},{"$f":"K21","v":23.622449294319178},{"$f":"L21","v":5.6394188008879126E-3},2000,200,{"$f":"DensityWater/BTUperkWh","v":2.4413833528722159E-3},null,{"$f":"Scenarios!O73","v":"N/A"},"Steam Indirect HX Tank","N/A","Steam Indirect HX Tank",{"$f":"Scenarios!O71","v":"N/A"},{"$f":"IF(OR($S$13=\"N/A\"), \"N/A\",S13*Discounted_UPV_Factor_Energy)","v":"N/A"},{"$f":"Scenarios!O79","v":{"$error":"#VALUE!"}},null,1,{"$f":"Scenarios!O69","v":"N/A"},{"$f":"Scenarios!#REF!","v":{"$error":"#REF!"}},null,{"$f":"SteamRate","v":1.1764705882352942},"100 lbs",100000]
["Electric Tankless","Electric",null,0.99,null,null,null,"Stielbel Eltron 36 Plus Electric 3gpm@82deltaT","Tempra 36 Plus Electric 3gpm@82deltaT","reg. not used","reg. not used","reg. not used",800,50,{"$f":"DensityWater/BTUperkWh","v":2.4413833528722159E-3},null,{"$f":"Scenarios!P73","v":630.07418854429409},"Electric Tankless",630.07418854429409,"Electric Tankless",{"$f":"Scenarios!P71","v":1529},7560.8902625315295,{"$f":"Scenarios!P79","v":600},null,{"$f":"SUM(ListCost!R86:R99)","v":1},{"$f":"SUM(ListCost!S86:S99)","v":729},{"$f":"SUM(ListCost!T86:T99)","v":0},null,{"$f":"ElectricRate","v":0.1},"kWh",{"$f":"BTUperkWh","v":3412}]
["Nat. Gas Tankless","Natural Gas",null,0.93,null,null,null,"Noritz","CWHeater  199,000 but/hr Model NCC199 SV NG","reg. not used","reg. not used","reg. not used",1000,50,{"$f":"DensityWater/BTUperkWh","v":2.4413833528722159E-3},null,{"$f":"Scenarios!Q73","v":228.8510752688172},"Nat. Gas Tankless",228.8510752688172,"Nat. Gas Tankless",{"$f":"Scenarios!Q71","v":1637.75},2746.2129032258063,{"$f":"Scenarios!Q79","v":600},null,{"$f":"SUM(ListCost!R107:R118)","v":1},{"$f":"SUM(ListCost!S107:S118)","v":637.75},{"$f":"SUM(ListCost!T107:T118)","v":0},null,{"$f":"NaturalGasRate","v":1},"Therms",{"$f":"BTUperTherm","v":100000}]
[]
[null,null,null,null,null,null,null,null,null,"see note for steam",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"steam heater is one unit because it is calculated via a regression"]
[null,null,null,null,null,null,null,null,null,"Cost Regression Coefficient\n for Intercept","Cost Regression Coefficient for Gallons","Cost Regression Coefficient for BTUH"]
[null,null,null,null,null,null,null,null,"Steam Regression data - tube bundle only",5338.1107702937443,null,5.6394188008879126E-3]
["Water Heater Life",{"$f":"Scenarios!K10","v":12},"years",null,null,null,null,null,"Steam Regression data - tank only",5130.7766262655459,23.622449294319178]
["Real Discount Rate",{"$f":"Scenarios!K11","v":0.03},"%/year",null,null,null,null,null,"Total",{"$f":"J20+J19","v":10468.88739655929},{"$f":"K20+K19","v":23.622449294319178},{"$f":"L20+L19","v":5.6394188008879126E-3}]
["Real Energy Escalation Rate",{"$f":"Scenarios!K12","v":0.03},"%/year"]
["Real OM Escalation Rate",{"$f":"Scenarios!K13","v":0.03},"%/year",null,null,null,null,null,null,4.5474735088646412E-13,6.7146858743497382E-3]
[]
["Selected State from Scenario Page",{"$f":"Selected_State","v":"Default Rates"}]
["Electric",{"$f":"Scenarios!K5","v":0.1},"$/kWh"]
["Natural Gas",{"$f":"Scenarios!K6","v":1},"$/Therm"]
["Steam @85%eff",{"$f":"NaturalGasRate/0.85","v":1.1764705882352942},"$/100 lbs"]
[]
[]
["Density Water",8.33,"lbs/gallon"]
[]
["Btu/kWh",3412]
["Btu/Therm",100000]
["Btu/100 lbs of 5 psi steam",{"$f":"960*100","v":96000}]
[]
["Pct Water Heater Usable Storage",0.75]
[]
[]
[]
[]
[]
["Water Heater Life",12,"years"]
["Real Discount Rate",0.03,"%/year"]
["Real Energy Escalation Rate",0.03,"%/year"]
["Real OM Escalation Rate",0.03,"%/year"]

{"sheet":"StatesTable","index":5,"n_rows":59,"n_cols":5,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
["Gas prices by State",null,null,"http://www.eia.gov/cneaf/electricity/esr/esr_sum.html"]
["http://www.eia.gov/dnav/ng/ng_pri_sum_a_EPG0_PCS_DMcf_a.htm",null,null,"Table 4. Average Retail Price for Bundled and Unbundled"]
[null,null,null,"              Consumers by Sector, Census Division, and State, 2009"]
[null,"$/cf","$/cf","cents/kWh","Ground water F"]
["Field1","Field2","Field3","Field4","Field5"]
["State",2009,2010,2009]
["Default Rates",10,null,10,40]
["U.S. Average",10.06,9.15,10.17,54]
["Alabama",14.93,13.39,10.050000000000001,62]
["Alaska",9.51,8.69,14.46,34]
["Arizona",12.15,10.71,9.35,57]
["Arkansas",10.71,8.8800000000000008,7.56,62]
["California",7.75,"NA",13.42,52]
["Colorado",7.56,"NA",8.15,42]
["Connecticut",9.92,9.5500000000000007,16.86,50]
["Delaware",15.87,{"$f":"B16","v":15.87},11.98,57]
["District of Columbia",12.99,"NA",12.96,55]
["Florida",11.09,10.59,10.77,70]
["Georgia",11.7,10.82,8.94,62]
["Hawaii",30,36.74,21.86,74]
["Idaho",9.77,8.31,6.49,47]
["Illinois",8.65,8.74,8.99,52]
["Indiana",9.18,7.44,8.32,52]
["Iowa",7.88,"NA",7.55,47]
["Kansas",10.01,9.81,7.87,54]
["Kentucky",10.89,8.42,7.63,57]
["Louisiana",10.46,9.93,7.69,67]
["Maine",13.94,"NA",12.55,39]
["Maryland",10.87,9.93,11.97,52]
["Massachusetts",12.85,"NA",15.37,45]
["Michigan",9.3800000000000008,8.7899999999999991,9.24,42]
["Minnesota",7.96,7.56,7.92,37]
["Mississippi",9.48,"NA",9.5,62]
["Missouri",10.8,"NA",6.96,54]
["Montana",9.41,8.56,8.32,42]
["Nebraska",7.44,7.04,7.33,50]
["Nevada",10.92,9.74,10.64,52]
["New Hampshire",14.37,"NA",14.55,44]
["New Jersey",10.199999999999999,10.11,13.83,52]
["New Mexico",7.52,7.55,8.4,52]
["New York",10.72,10.029999999999999,15.51,44]
["North Carolina",11.63,"NA",7.98,57]
["North Dakota",7.41,7.03,6.81,39]
["Ohio",10.41,9.23,9.65,52]
["Oklahoma",10.6,"NA",6.76,57]
["Oregon",11.86,10.3,7.49,52]
["Pennsylvania",11.83,10.53,9.5399999999999991,49]
["Rhode Island",15.14,"NA",13.67,52]
["South Carolina",11.16,10.33,8.74,62]
["South Dakota",7.42,7.16,7.14,43]
["Tennessee",10.67,8.9600000000000009,9.61,57]
["Texas",8.16,8.0299999999999994,9.66,60]
["Utah",7.57,6.82,6.96,52]
["Vermont",12.96,11.82,12.93,44]
["Virginia",10.31,"NA",8.06,52]
["Washington",12.26,10.51,6.96,47]
["West Virginia",14.24,10.31,6.77,52]
["Wisconsin",8.9499999999999993,8.5399999999999991,9.57,41]
["Wyoming",8.01,6.91,7.28,42]

{"sheet":"ListCost","index":6,"n_rows":142,"n_cols":20,"rows_kept":142,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,"Scenario Data for:",null,{"$f":"Scenarios!J15","v":"Grill / Snack Shop"}]
[]
["Recovery GPH",{"$f":"Demand","v":70}]
[]
[]
[]
["NATURAL GAS CONDENSING WATER HEATER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Logic for Equipment Cost Determination"]
["Field1","Field2","Field3","Field4","Field5","Field6","Field7","Field8","Field9","Field10","Field11","Field12","Field13","Field14","Field15","Field16","Field17","Field18","Field19","Field20"]
["Recovery GPH","Manufacturer","Heater Model","Thermal Efficiency","Tank Size Gallons","Btu/hr Input Each","Number of Units","GPH @100F Rise",{"$f":"\"GPH @\"&T_rise_F&\"F rise\"","v":"GPH @100F rise"},"Total Tank Gallons","Total Btu/hr Input","Total Usable Storage Gallons","Budget Price Each","Not Used","Not Used","Demand Ratio","Field3",{"$f":"G9","v":"Number of Units"},"Total Installed Cost","Total Heater Storage Gallons"]
[{"$f":"H10","v":41.05642256902761},"A.O.Smith","BTX-80",0.9,50,{"$f":"76000/2","v":38000},1,{"$f":"(G10*F10*D10)/(DensityWater*100)","v":41.05642256902761},{"$f":"(G10*F10*D10)/(DensityWater*T_rise_F)","v":41.05642256902761},{"$f":"E10*G10","v":50},{"$f":"G10*F10","v":38000},{"$f":"E10*G10*Pct_Usable_Storage","v":37.5},3268.3,null,null,{"$f":"A10/Demand","v":0.58652032241468011},{"$f":"IF(P10>=1,P9<1)","v":false},{"$f":"$G10*Q10","v":0},{"$f":"R10*M10","v":0},{"$f":"R10*E10","v":0}]
[{"$f":"H11","v":82.112845138055221},"A.O.Smith","BTX-80",0.9,50,76000,1,{"$f":"(G11*F11*D11)/(DensityWater*100)","v":82.112845138055221},{"$f":"(G11*F11*D11)/(DensityWater*T_rise_F)","v":82.112845138055221},{"$f":"E11*G11","v":50},{"$f":"G11*F11","v":76000},{"$f":"E11*G11*Pct_Usable_Storage","v":37.5},3268.3,null,null,1.1730406448293602,true,1,3268.3,{"$f":"R11*E11","v":50}]
[115.24609843937576,"A.O.Smith","BTX-100",0.96,50,100000,1,115.24609843937576,{"$f":"(G12*F12*D12)/(DensityWater*T_rise_F)","v":115.24609843937576},{"$f":"E12*G12","v":50},{"$f":"G12*F12","v":100000},{"$f":"E12*G12*Pct_Usable_Storage","v":37.5},4875,null,null,1.6463728348482252,false,0,0,0]
[138.29531812725091,"A.O.Smith","BTH-120",0.96,100,120000,1,138.29531812725091,{"$f":"(G13*F13*D13)/(DensityWater*T_rise_F)","v":138.29531812725091},{"$f":"E13*G13","v":100},{"$f":"G13*F13","v":120000},{"$f":"E13*G13*Pct_Usable_Storage","v":75},7150.5,null,null,1.97564740181787,false,0,0,0]
[172.86914765906363,"A.O.Smith","BTH-150",0.96,100,150000,1,172.86914765906363,{"$f":"(G14*F14*D14)/(DensityWater*T_rise_F)","v":172.86914765906363},{"$f":"E14*G14","v":100},{"$f":"G14*F14","v":150000},{"$f":"E14*G14*Pct_Usable_Storage","v":75},9531.48,null,null,2.4695592522723375,false,0,0,0]
[229.33973589435774,"A.O.Smith","BTH-199",0.96,100,199000,1,229.33973589435774,{"$f":"(G15*F15*D15)/(DensityWater*T_rise_F)","v":229.33973589435774},100,199000,{"$f":"E15*G15*Pct_Usable_Storage","v":75},9763.74,null,null,3.2762819413479676,false,0,0,0]
[288.1152460984394,"A.O.Smith","BTH-250",0.96,100,250000,1,288.1152460984394,288.1152460984394,100,250000,75,11048.52,null,null,4.1159320871205631,false,0,0,0]
[345.73829531812726,"A.O.Smith","BTH-300",0.96,100,300000,1,345.73829531812726,345.73829531812726,100,300000,75,11048.52,null,null,4.939118504544675,false,0,0,0]
[460.86914765906363,"A.O.Smith","BTH-400A",0.96,130,399900,1,460.86914765906363,460.86914765906363,130,399900,97.5,16563.96,null,null,6.5838449665580514,false,0,0,0]
[570.11404561824725,"A.O.Smith","BTH-500A",0.95,130,499900,1,570.11404561824725,570.11404561824725,130,499900,97.5,19446.63,null,null,8.1444863659749611,false,0,0,0]
[921.73829531812726,"A.O.Smith","BTH-400A",0.96,130,399900,2,921.73829531812726,921.73829531812726,260,799800,195,16563.96,null,null,13.167689933116103,false,0,0,0]
[1382.6074429771909,"A.O.Smith","BTH-400A",0.96,130,399900,3,1382.6074429771909,1382.6074429771909,390,1199700,292.5,16563.96,null,null,19.751534899674155,false,0,0,0]
[1843.4765906362545,"A.O.Smith","BTH-400A",0.96,130,399900,4,1843.4765906362545,1843.4765906362545,520,1599600,390,16563.96,null,null,26.335379866232206,false,0,0,0]
[2304.3457382953179,"A.O.Smith","BTH-400A",0.96,130,399900,5,2304.3457382953179,2304.3457382953179,650,1999500,487.5,16563.96,null,null,32.919224832790256,false,0,0,0]
[2765.2148859543818,"A.O.Smith","BTH-400A",0.96,130,399900,6,2765.2148859543818,2765.2148859543818,780,2399400,585,16563.96,null,null,39.50306979934831,false,0,0,0]
[3226.0840336134452,"A.O.Smith","BTH-400A",0.96,130,399900,7,3226.0840336134452,3226.0840336134452,910,2799300,682.5,16563.96,null,null,46.086914765906357,false,0,0,0]
[3686.953181272509,"A.O.Smith","BTH-400A",0.96,130,399900,8,3686.953181272509,3686.953181272509,1040,3199200,780,16563.96,null,null,52.670759732464411,{"$f":"IF(P26>=1,P25<1)","v":false},{"$f":"$G26*Q26","v":0},{"$f":"R26*M26","v":0},0]
[9999,"End of data"]
[]
[]
[]
["NATURAL GAS STANDARD WATER HEATER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Logic for Equipment Cost Determination"]
["Recovery GPH","Manufacturer","Heater Model","Thermal Efficiency","Tank Size Gallons","Btu/hr Input Each","Number of Units","GPH @100F Rise",{"$f":"\"GPH @\"&T_rise_F&\"F rise\"","v":"GPH @100F rise"},"Total Tank Gallons","Total Btu/hr Input","Total Usable Storage Gallons","Budget Price Each","Total Budget Price",null,"Demand Ratio","Field3",{"$f":"G32","v":"Number of Units"},"Total Installed Cost","Total Heater Storage Gallons"]
[{"$f":"H33","v":23.409363745498201},"A.O.Smith","GCV-40",0.78,40,{"$f":"50000/2","v":25000},1,{"$f":"(G33*F33*D33)/(DensityWater*100)","v":23.409363745498201},{"$f":"(G33*F33*D33)/(DensityWater*T_rise_F)","v":23.409363745498201},{"$f":"E33*G33","v":40},{"$f":"G33*F33","v":25000},{"$f":"E33*G33*Pct_Usable_Storage","v":30},1095,null,null,{"$f":"A33/Demand","v":0.33441948207854572},{"$f":"IF(P33>=1,P32<1)","v":false},{"$f":"$G33*Q33","v":0},{"$f":"R33*M33","v":0},{"$f":"R33*E33","v":0}]
[{"$f":"H34","v":46.818727490996402},"A.O.Smith","GCV-40",0.78,40,50000,1,{"$f":"(G34*F34*D34)/(DensityWater*100)","v":46.818727490996402},{"$f":"(G34*F34*D34)/(DensityWater*T_rise_F)","v":46.818727490996402},{"$f":"E34*G34","v":40},{"$f":"G34*F34","v":50000},{"$f":"E34*G34*Pct_Usable_Storage","v":30},1095,null,null,0.66883896415709143,false,0,0,{"$f":"R34*E34","v":0}]
[{"$f":"I35","v":46.818727490996402},"A.O.Smith","GCV-50",0.78,48,50000,1,{"$f":"(G35*F35*D35)/(DensityWater*100)","v":46.818727490996402},46.818727490996402,48,50000,36,1167,null,null,0.66883896415709143,false,0,0,0]
[115.24609843937576,"A.O.Smith","BTR-120",0.8,71,120000,1,116,{"$f":"(G36*F36*D36)/(DensityWater*T_rise_F)","v":115.24609843937576},{"$f":"E36*G36","v":71},{"$f":"G36*F36","v":120000},{"$f":"E36*G36*Pct_Usable_Storage","v":53.25},6187.23,null,null,1.6463728348482252,true,1,6187.23,71]
[147.89915966386553,"A.O.Smith","BTR-154",0.8,81,154000,1,149,147.89915966386553,81,154000,60.75,7861.56,null,null,2.112845138055222,false,0,0,0]
[191.11644657863144,"A.O.Smith","BTR-199",0.8,100,199000,1,193,191.11644657863144,100,199000,75,8334.9,null,null,2.7302349511233062,false,0,0,0]
[240.09603841536614,"A.O.Smith","BTR-250",0.8,100,250000,1,242,240.09603841536614,100,250000,75,9247.77,null,null,3.4299434059338019,false,0,0,0]
[384.05762304921967,"A.O.Smith","BTR-305",0.8,65,399900,1,296,384.05762304921967,65,399900,48.75,9716.7000000000007,null,null,5.4865374721317099,false,0,0,0]
[{"$f":"I41","v":374.54981992797121},"A.O.Smith","BTR-400",0.8,100,390000,1,378,374.54981992797121,100,390000,75,13623.96,null,null,5.3507117132567314,false,0,0,0]
[{"$f":"I42","v":480.19207683073228},"A.O.Smith","BTR-500",0.8,85,500000,1,485,480.19207683073228,85,500000,63.75,15348.27,null,null,6.8598868118676037,false,0,0,0]
[749.09963985594243,"A.O.Smith","BTR-400",{"$f":"D41","v":0.8},{"$f":"$E$41","v":100},{"$f":"$F$41","v":390000},2,{"$f":"G43*$H$41","v":756},749.09963985594243,200,780000,150,{"$f":"$M$41","v":13623.96},null,null,10.701423426513463,false,0,0,0]
[1123.6494597839135,"A.O.Smith","BTR-400",{"$f":"D42","v":0.8},{"$f":"$E$41","v":100},{"$f":"$F$41","v":390000},3,{"$f":"G44*$H$41","v":1134},1123.6494597839135,300,1170000,225,{"$f":"$M$41","v":13623.96},null,null,16.052135139770193,false,0,0,0]
[1498.1992797118849,"A.O.Smith","BTR-400",0.8,100,390000,4,1512,1498.1992797118849,400,1560000,300,13623.96,null,null,21.402846853026926,false,0,0,0]
[1872.749099639856,"A.O.Smith","BTR-400",0.8,100,390000,5,1890,1872.749099639856,500,1950000,375,13623.96,null,null,26.753558566283658,false,0,0,0]
[2247.2989195678269,"A.O.Smith","BTR-400",0.8,100,390000,6,2268,2247.2989195678269,600,2340000,450,13623.96,null,null,32.104270279540387,false,0,0,0]
[2621.8487394957983,"A.O.Smith","BTR-400",0.8,100,390000,7,2646,2621.8487394957983,700,2730000,525,13623.96,null,null,37.454981992797116,false,0,0,0]
[2996.3985594237697,"A.O.Smith","BTR-400",0.8,100,390000,8,3024,2996.3985594237697,800,3120000,600,13623.96,null,null,42.805693706053852,false,{"$f":"$G49*Q49","v":0},{"$f":"R49*M49","v":0},0]
[9999,"End of data"]
[]
[]
[]
["ELECTRIC WATER HEATER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Logic for Equipment Cost Determination"]
["Recovery GPH","Manufacturer","kW","Thermal Efficiency","Tank Size Gallons","Btu/hr Input Each","Number of Units","GPH @100F Rise",{"$f":"\"GPH @\"&T_rise_F&\"F rise\"","v":"GPH @100F rise"},"Total Tank Gallons","Total Btu/hr Input","Total Usable Storage Gallons","Budget Price Each","Total Budget Price",null,"Demand Ratio","Field3",{"$f":"G55","v":"Number of Units"},"Total Installed Cost","Total Heater Storage Gallons"]
[{"$f":"I56","v":18.247851140456181},"A. O. Smith",12,0.99,40,{"$f":"4500*BTUperkWh/1000","v":15354},1,{"$f":"(G56*F56*D56)/(DensityWater*100)","v":18.247851140456181},{"$f":"(G56*F56*D56)/(DensityWater*T_rise_F)","v":18.247851140456181},{"$f":"E56*G56","v":40},{"$f":"G56*F56","v":15354},{"$f":"E56*G56*Pct_Usable_Storage","v":30},2214,null,null,{"$f":"A56/Demand","v":0.26068358772080258},{"$f":"IF(P56>=1,#REF!<1)","v":false},{"$f":"$G56*Q56","v":0},{"$f":"R56*M56","v":0},{"$f":"R56*E56","v":0}]
[18.247851140456181,"A. O. Smith",12,0.99,50,{"$f":"4500*BTUperkWh/1000","v":15354},1,18.247851140456181,18.247851140456181,50,15354,37.5,2476.5,null,null,0.26068358772080258,{"$f":"IF(P57>=1,P56<1)","v":false},0,0,0]
[18.247851140456181,"A. O. Smith",12,0.99,66,{"$f":"4500*BTUperkWh/1000","v":15354},1,18.247851140456181,18.247851140456181,66,15354,49.5,2815.5,null,null,0.26068358772080258,false,0,0,0]
[18.247851140456181,"A. O. Smith",12,0.99,80,{"$f":"4500*BTUperkWh/1000","v":15354},1,18.247851140456181,18.247851140456181,80,15354,60,3129,null,null,0.26068358772080258,false,0,0,0]
[{"$f":"I60","v":36.495702280912361},"Lochinvar",9,0.99,119,{"$f":"C60*BTUperkWh","v":30708},1,{"$f":"(F60*D60)/(100*DensityWater)","v":36.495702280912361},{"$f":"(G60*F60*D60)/(DensityWater*T_rise_F)","v":36.495702280912361},{"$f":"E60*G60","v":119},{"$f":"G60*F60","v":30708},{"$f":"E60*G60*Pct_Usable_Storage","v":89.25},7973,null,null,0.52136717544160516,false,0,0,0]
[48.66093637454982,"Lochinvar",12,0.99,119,40944,1,48.66093637454982,48.66093637454982,119,40944,89.25,8301,null,null,0.69515623392214032,false,0,0,0]
[60.826170468187271,"Lochinvar",15,0.99,119,51180,1,60.826170468187271,60.826170468187271,119,51180,89.25,8679,null,null,0.86894529240267526,false,0,0,0]
[72.991404561824723,"Lochinvar",18,0.99,119,61416,1,72.991404561824723,72.991404561824723,119,61416,89.25,8829,null,null,1.0427343508832103,true,1,8829,119]
[97.32187274909964,"Lochinvar",24,0.99,119,81888,1,97.32187274909964,97.32187274909964,119,81888,89.25,9816,null,null,1.3903124678442806,false,0,0,0]
[109.48710684273709,"Lochinvar",27,0.99,119,92124,1,109.48710684273709,109.48710684273709,119,92124,89.25,10203,null,null,1.5641015263248157,false,0,0,0]
[121.65234093637454,"Lochinvar",30,0.99,119,102360,1,121.65234093637454,121.65234093637454,119,102360,89.25,10437,null,null,1.7378905848053505,false,0,0,0]
[145.98280912364945,"Lochinvar",36,0.99,119,122832,1,145.98280912364945,145.98280912364945,119,122832,89.25,10628,null,null,2.0854687017664206,false,0,0,0]
[182.47851140456183,"Lochinvar",45,0.99,119,153540,1,182.47851140456183,182.47851140456183,119,153540,89.25,12762,null,null,2.606835877208026,false,0,0,0]
[218.97421368547418,"Lochinvar",54,0.99,119,184248,1,218.97421368547418,218.97421368547418,119,184248,89.25,13103,null,null,3.1282030526496314,false,0,0,0]
[437.94842737094837,"Lochinvar",{"$f":"C69","v":54},{"$f":"D69","v":0.99},{"$f":"E69","v":119},184248,2,{"$f":"$H$69*G70","v":437.94842737094837},437.94842737094837,238,368496,178.5,{"$f":"M69","v":13103},null,null,6.2564061052992628,false,0,0,0]
[656.92264105642255,"Lochinvar",{"$f":"C70","v":54},{"$f":"D70","v":0.99},{"$f":"E70","v":119},184248,3,{"$f":"$H$69*G71","v":656.92264105642255},656.92264105642255,357,552744,267.75,{"$f":"M70","v":13103},null,null,9.3846091579488942,false,0,0,0]
[875.89685474189673,"Lochinvar",54,0.99,119,184248,4,875.89685474189673,875.89685474189673,476,736992,357,13103,null,null,12.512812210598526,false,0,0,0]
[1094.871068427371,"Lochinvar",54,0.99,119,184248,5,1094.871068427371,1094.871068427371,595,921240,446.25,13103,null,null,15.641015263248157,false,0,0,0]
[1313.8452821128451,"Lochinvar",54,0.99,119,184248,6,1313.8452821128451,1313.8452821128451,714,1105488,535.5,13103,null,null,18.769218315897788,false,0,0,0]
[1532.8194957983192,"Lochinvar",54,0.99,119,184248,7,1532.8194957983192,1532.8194957983192,833,1289736,624.75,13103,null,null,21.897421368547416,false,0,0,0]
[1751.7937094837935,"Lochinvar",54,0.99,119,184248,8,1751.7937094837935,1751.7937094837935,952,1473984,714,13103,null,null,25.025624421197051,false,0,0,0]
[1970.7679231692675,"Lochinvar",54,0.99,119,184248,9,1970.7679231692678,1970.7679231692675,1071,1658232,803.25,13103,null,null,28.153827473846679,false,0,0,0]
[2189.7421368547421,"Lochinvar",54,0.99,119,184248,10,2189.7421368547421,2189.7421368547421,1190,1842480,892.5,13103,null,null,31.282030526496314,{"$f":"IF(P78>=1,P77<1)","v":false},{"$f":"$G78*Q78","v":0},{"$f":"R78*M78","v":0},0]
[9999]
[]
[]
[]
[]
["ELECTRIC TANKLESS WATER HEATER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Logic for Equipment Cost Determination"]
["Recovery GPH","Product Line","kW",null,"Gallon Capacity","Btu/hr Input","Number of Units","GPH @100F Rise",{"$f":"\"GPH @\"&T_rise_F&\"F rise\"","v":"GPH @100F rise"},"Total Tank Gallons","Total Btu/hr Input","Total Usable Storage Gallons","Budget Price Each","Larger Service","Not Used","Demand Ratio","Field3",{"$f":"G85","v":"Number of Units"},"Total Installed Cost","Total Heater Storage Gallons"]
[{"$f":"I86","v":58.948379351740698},"Steibel Tempra 20 Plus",{"$f":"K86/BTUperkWh","v":14.3915592028136},1,0,49104,1,{"$f":"(G86*F86*D86)/(DensityWater*100)","v":58.948379351740698},{"$f":"(G86*F86*D86)/(DensityWater*T_rise_F)","v":58.948379351740698},{"$f":"E86*G86","v":0},{"$f":"G86*F86","v":49104},{"$f":"E86*G86*Pct_Usable_Storage","v":0},729,0,null,{"$f":"A86/Demand","v":0.8421197050248671},{"$f":"IF(P86>=1,P85<1)","v":false},{"$f":"$G86*Q86","v":0},{"$f":"R86*M86","v":0},{"$f":"R86*E86","v":0}]
[78.597839135654269,"Steibel Tempra 20 Plus",19.188745603751464,1,0,65472,1,78.597839135654269,78.597839135654269,0,65472,0,729,null,null,1.1228262733664895,true,1,729,0]
[98.247298919567825,"Steibel Tempra 26 Plus",23.985932004689332,1,0,81840,1,98.247298919567825,98.247298919567825,0,81840,0,765,null,null,1.4035328417081119,false,0,0,0]
[117.8967587034814,"Steibel Tempra 29 Plus",28.783118405627199,1,0,98208,1,117.8967587034814,117.8967587034814,0,98208,0,799,null,null,1.6842394100497342,false,0,0,0]
[{"$f":"I90","v":150},"Stiebel Eltron Tempra 36 Plus (Electric Tankless)",36.620750293083233,1,0,124950,1,{"$f":"(F90*D90)/(100*DensityWater)","v":150},{"$f":"(G90*F90*D90)/(DensityWater*T_rise_F)","v":150},{"$f":"E90*G90","v":0},{"$f":"G90*F90","v":124950},{"$f":"E90*G90*Pct_Usable_Storage","v":0},839,null,null,2.1428571428571428,false,0,0,0]
[{"$f":"I91","v":300},null,73.241500586166467,1,0,{"$f":"$F$90","v":124950},2,{"$f":"$H$90*G91","v":300},300,0,249900,0,839,null,null,4.2857142857142856,false,0,0,0]
[450,null,109.8622508792497,1,0,{"$f":"$F$90","v":124950},3,{"$f":"$H$90*G92","v":450},450,0,374850,0,839,null,null,6.4285714285714288,false,0,0,0]
[600,null,146.48300117233293,1,0,124950,4,600,600,0,499800,0,839,null,null,8.5714285714285712,false,0,0,0]
[750,null,183.10375146541617,1,0,124950,5,750,750,0,624750,0,839,null,null,10.714285714285714,false,0,0,0]
[900,null,219.7245017584994,1,0,124950,6,900,900,0,749700,0,839,null,null,12.857142857142858,false,0,0,0]
[1050,null,256.34525205158263,1,0,124950,7,1050,1050,0,874650,0,839,null,null,15,false,0,0,0]
[1200,null,292.96600234466587,1,0,124950,8,1200,1200,0,999600,0,839,null,null,17.142857142857142,false,0,0,0]
[1350,null,329.5867526377491,1,0,124950,9,1350,1350,0,1124550,0,839,null,null,19.285714285714285,false,0,0,0]
[1500,null,366.20750293083233,1,0,124950,10,1500,1500,0,1249500,0,839,null,null,21.428571428571427,{"$f":"IF(P99>=1,P98<1)","v":false},{"$f":"$G99*Q99","v":0},{"$f":"R99*M99","v":0},0]
[9999]
[]
[]
[]
[]
["NATURAL GAS TANKLESS WATER HEATER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Logic for Equipment Cost Determination"]
["Recovery GPH","Product Line","Heater Model",null,"Gallon Capacity","Btu/hr Input","Number of Units","GPH @100F Rise",{"$f":"\"GPH @\"&T_rise_F&\"F rise\"","v":"GPH @100F rise"},"Total Tank Gallons","Total Btu/hr Input","Total Usable Storage Gallons","Budget Price Each","Not Used","Not Used","Demand Ratio","Field3",{"$f":"G106","v":"Number of Units"},"Total Installed Cost","Total Heater Storage Gallons"]
[{"$f":"I107","v":19.19567827130852},"A. O. Smith","ATO-110-N",0.82,0,19500,1,{"$f":"(F107*D107)/(100*DensityWater)","v":19.19567827130852},{"$f":"(G107*F107*D107)/(DensityWater*T_rise_F)","v":19.19567827130852},{"$f":"E107*G107","v":0},{"$f":"G107*F107","v":19500},{"$f":"E107*G107*Pct_Usable_Storage","v":0},637.75,null,null,{"$f":"A107/Demand","v":0.2742239753044074},{"$f":"IF(P107>=1,P106<1)","v":false},{"$f":"$G107*Q107","v":0},{"$f":"R107*M107","v":0},{"$f":"R107*E107","v":0}]
[{"$f":"I108","v":137.81512605042016},null,"ATO-110-N",0.82,0,140000,1,{"$f":"(F108*D108)/(100*DensityWater)","v":137.81512605042016},{"$f":"(G108*F108*D108)/(DensityWater*T_rise_F)","v":137.81512605042016},{"$f":"E108*G108","v":0},{"$f":"G108*F108","v":140000},{"$f":"E108*G108*Pct_Usable_Storage","v":0},637.75,null,null,1.9687875150060024,true,1,637.75,0]
[{"$f":"I109","v":222.17286914765907},"Noritz Natural Gas Tankless Heaters",null,0.93,0,199000,1,{"$f":"(F109*D109)/(100*DensityWater)","v":222.17286914765907},222.17286914765907,{"$f":"E109*G109","v":0},{"$f":"G109*F109","v":199000},0,2400,null,null,3.1738981306808438,false,0,0,0]
[{"$f":"I110","v":444.34573829531814},null,null,0.93,0,199000,2,{"$f":"$H$109*G110","v":444.34573829531814},444.34573829531814,{"$f":"E110*G110","v":0},{"$f":"G110*F110","v":398000},0,2400,null,null,6.3477962613616876,false,0,0,0]
[666.51860744297721,null,null,0.93,0,199000,3,{"$f":"$H$109*G111","v":666.51860744297721},666.51860744297721,0,597000,0,2400,null,null,9.5216943920425319,false,0,0,0]
[888.69147659063628,null,null,0.93,0,199000,4,888.69147659063628,888.69147659063628,0,796000,0,2400,null,null,12.695592522723375,false,0,0,0]
[1110.8643457382952,null,null,0.93,0,199000,5,1110.8643457382955,1110.8643457382952,0,995000,0,2400,null,null,15.869490653404219,false,0,0,0]
[1333.0372148859544,null,null,0.93,0,199000,6,1333.0372148859544,1333.0372148859544,0,1194000,0,2400,null,null,19.043388784085064,false,0,0,0]
[1555.2100840336134,null,null,0.93,0,199000,7,1555.2100840336134,1555.2100840336134,0,1393000,0,2400,null,null,22.217286914765907,false,0,0,0]
[1777.3829531812726,null,null,0.93,0,199000,8,1777.3829531812726,1777.3829531812726,0,1592000,0,2400,null,null,25.39118504544675,false,0,0,0]
[1999.5558223289315,null,null,0.93,0,199000,9,1999.5558223289318,1999.5558223289315,0,1791000,0,2400,null,null,28.565083176127594,false,0,0,0]
[2221.7286914765905,null,null,0.93,0,199000,10,2221.7286914765909,2221.7286914765905,0,1990000,0,2400,null,null,31.738981306808437,{"$f":"IF(P118>=1,P117<1)","v":false},{"$f":"$G118*Q118","v":0},{"$f":"R118*M118","v":0},0]
[9999]
[]
[]
[]
[]
["STEAM HEATER + EXTERNAL STORAGE"]
["Gallon Capacity","Glass Lined 125 psi Tank"]
[200,9222]
[257,10564]
[318,13831]
[432,15519]
[504,17053]
[650,20870]
[752,22646]
[940,27083]
[]
[]
["Description","6 inch diameter tube bundle - double wall insulated",null,"gph \n40-120F water","pph of 5psi steam","Btu/hr to heat water","Btu/hr of 5psi steam @960Btu/lb latent","List Price for Double Wall"]
["6in diam.tube bundle - 18 in. long",618,null,342,236,{"$f":"D137*DensityWater*80","v":227908.80000000002},{"$f":"E137*960","v":226560},6656]
[null,624,null,437,302,291216.8,289920,6993]
[null,630,null,538,372,358523.2,357120,7333]
[null,636,null,627,433,417832.8,415680,7669]
[null,648,null,830,573,553112,550080,8315]
[null,660,null,1027,709,684392.8,680640,9274]

{"sheet":"NPVTable","index":7,"n_rows":48,"n_cols":11,"rows_kept":48,"cut":false,"hidden":true,"merged":[]}
[null,"Note: Electricity, natural gas, and steam are assumed to escalate at the same rate"]
[null,null,null,null,null,null,"Uniform Present Value (UPV) Factor Energy","Uniform Present Value (UPV) Factor Non Fuel",null,"Discounted UPV Factor Energy","Discounted UPV Factor Non Fuel"]
["Total",{"$f":"SUM(B8:B48)","v":1},14.617790448385477,{"$f":"SUM(D8:D48)","v":14.617790448385477},10.954003993567566,1,12,12,null,{"$f":"SUM(J8:J48)","v":12},{"$f":"SUM(K8:K48)","v":12}]
[]
["Year","Investment","Real","Real","PV","NPV ","NPV","NPV",null,"Discounted","Discounted "]
["No.","Cost, $","Energy Cost","O&M Cost","Factor","Investment","Energy","O&M",null,"Energy Cost","O&M Cost"]
[{"$f":"LifeYears&\" yrs\"","v":"12 yrs"},null,{"$f":"\"@ \"&Real_Energy_Escalation_Rate&\"/yr\"","v":"@ 0.03/yr"},{"$f":"\"@ \"&Real_OM_Escalation_Rate&\"/yr\"","v":"@ 0.03/yr"},{"$f":"\"@ \"&Real_Discount_Rate&\"/yr\"","v":"@ 0.03/yr"},null,null,null,null,{"$f":"Real_Energy_Escalation_Rate*Real_Discount_Rate&\"/yr\"","v":"0.0009/yr"},{"$f":"Real_OM_Escalation_Rate*Real_Discount_Rate&\"/yr\"","v":"0.0009/yr"}]
[0,1,null,null,{"$f":"IF(A8>LifeYears,\"\",(1+Real_Discount_Rate)^-A8)","v":1},{"$f":"IF(A8>LifeYears,\"\",B8*E8)","v":1},{"$f":"IF($A8>LifeYears,\"\",$E8*C8)","v":0},{"$f":"IF($A8>LifeYears,\"\",$E8*D8)","v":0}]
[{"$f":"IF(ROW(A8)-ROW($A$8)<LifeYears,A8+1,\"\")","v":1},null,{"$f":"IF($A9>LifeYears,\"\",(1+Real_Energy_Escalation_Rate)^$A9)","v":1.03},{"$f":"IF($A9>LifeYears,\"\",(1+Real_OM_Escalation_Rate)^$A9)","v":1.03},0.970873786407767,0,1,1,null,{"$f":"IF($A9>LifeYears,\"\",((1+Real_Energy_Escalation_Rate)^$A9)*((1+Real_Discount_Rate)^-A9))","v":1},{"$f":"IF($A9>LifeYears,\"\",((1+Real_OM_Escalation_Rate)^$A9)*((1+Real_Discount_Rate)^-A9))","v":1}]
[2,null,1.0609,1.0609,0.94259590913375435,0,1,1,null,1,1]
[3,null,1.092727,1.092727,0.91514165935315961,0,1,1,null,1,1]
[4,null,1.1255088099999999,1.1255088099999999,0.888487047915689,0,1,1,null,1,1]
[5,null,1.1592740742999998,1.1592740742999998,0.86260878438416411,0,1,1,null,1,1]
[6,null,1.1940522965289999,1.1940522965289999,0.83748425668365445,0,1,1,null,1,1]
[7,null,1.22987386542487,1.22987386542487,0.81309151134335378,0,1,1,null,1,1]
[8,null,1.2667700813876159,1.2667700813876159,0.78940923431393573,0,0.99999999999999989,0.99999999999999989,null,0.99999999999999989,0.99999999999999989]
[9,null,1.3047731838292445,1.3047731838292445,0.76641673234362695,0,1,1,null,1,1]
[10,null,1.3439163793441218,1.3439163793441218,0.74409391489672516,0,1,1,null,1,1]
[11,null,1.3842338707244455,1.3842338707244455,0.72242127659876232,0,1,1,null,1,1]
[12,null,1.4257608868461786,1.4257608868461786,0.70137988019297326,0,1,1,null,1,1]
["",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,"",""]

{"sheet":"Figure 1","index":8,"n_rows":17,"n_cols":1,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Groundwater Temperature Impact on Tankless Water Heater Size"]
["http://homerepair.about.com/od/plumbingrepair/ss/tankless_hwh_5.htm"]