{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["DHW Htr Conversion","Tables"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"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":"DHW Htr Conversion","index":0,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[[24,13,25,13],[25,6,25,9],[26,0,27,0],[22,1,23,4],[22,5,23,5],[22,10,23,10],[22,11,23,12],[22,13,23,13],[22,6,23,9],[26,1,27,4],[26,5,27,5],[26,10,27,10],[26,11,27,12],[26,13,27,13],[27,6,27,9],[26,6,26,9],[32,13,33,13],[34,0,35,0],[34,1,35,4],[34,5,35,5],[34,10,35,10],[34,11,35,12],[34,13,35,13],[34,6,34,9],[35,6,35,9],[32,0,33,0],[32,1,33,4],[32,5,33,5],[32,6,33,9],[32,10,33,10],[32,11,33,12],[28,13,29,13],[30,0,31,0],[30,1,31,4],[30,5,31,5],[30,6,31,9],[30,10,31,10],[30,11,31,12],[30,13,31,13],[28,6,29,9],[28,0,29,0],[28,1,29,4],[28,5,29,5],[28,10,29,10],[28,11,29,12],[24,0,25,0],[24,1,25,4],[24,5,25,5],[24,6,24,9],[24,10,25,10],[24,11,25,12],[17,1,17,2],[18,1,18,2],[15,1,15,2],[17,3,17,4],[17,5,17,12],[16,1,16,2],[16,3,16,4],[15,5,15,12],[15,3,15,4],[18,3,18,4],[19,3,19,4],[18,5,18,12],[19,5,19,12],[21,0,21,13],[22,0,23,0],[19,1,19,2],[11,1,11,2],[11,3,11,4],[11,5,11,12],[12,1,12,2],[12,3,12,4],[12,5,12,12],[13,1,13,2],[13,3,13,4],[13,5,13,12],[14,1,14,2],[16,5,16,12],[14,5,14,12],[14,3,14,4],[6,0,6,13],[7,0,7,13],[9,0,9,4],[9,5,9,12],[10,1,10,2],[10,3,10,4],[10,5,10,12],[5,0,5,13],[0,0,0,13],[1,0,1,13],[3,0,3,3],[3,4,3,13],[4,0,4,13]]}
["DHW Heater Conversion"]
["(Electric to Gas)"]
[]
["Description of UCRM:",null,null,null,"(Data needed:  use of space, age of water heater)"]
[]
[]
[]
[]
[]
["Data needed for calculations",null,null,null,null,"Description",null,null,null,null,null,null,null,"Resource"]
["A)",null,null,"gals/person-day",null,"Daily Hot Water Consumption per Capita",null,null,null,null,null,null,null,"Table 11"]
["B)",null,null,"People",null,"Number of People in Facility"]
["C)",null,null,"days/yr",null,"Day per Year of Occupancy"]
["D)",null,null,"°F",null,"Hot Water Temperature"]
["E)",null,null,"Btu/yr",null,"Existing Electric DHW Heater Standby Loss",null,null,null,null,null,null,null,"Table 14"]
["F)",null,null,"Btu/yr",null,"Replacement Gas DHW Heater Standby Loss",null,null,null,null,null,null,null,"Table 14"]
["G)",null,null,"$/kWh",null,"Electrical Energy Rate - Summer"]
["H)",null,null,"$/kWh",null,"Electrical Energy Rate - Winter"]
["I)",null,null,"$/Mcf",null,"Natural Gas Rate"]
["J)",null,null,"$",null,"Installed Cost per Gas Water Heater"]
[]
["Calculations"]
["K)","Annual BTUs for Hot Water",null,null,null,"=","(8.33Btu/gal°F)*A*B*C*(D-70°F)",null,null,null,"=",{"$f":"8.33*B11*B12*B13*(B14-70)","v":0},null,"Btu/yr"]
[]
["L)","Annual kWh to Heat Water Electrically",null,null,null,"=","K + E",null,null,null,"=",{"$f":"(L23+B15)/3413","v":0},null,"kWh/yr"]
[null,null,null,null,null,null,"3,413 Btu/kWh"]
["M)","Annual MCF to Heat Water with Gas",null,null,null,"=","K + F",null,null,null,"=",{"$f":"(L23+B16)/(0.8*1030000)","v":0},null,"Mcf/yr"]
[null,null,null,null,null,null,"0.8 * 1,030,000 Btu/Mcf"]
["N)","Annual Electric Cost for Water Heating",null,null,null,"=","L * (G + H)/2",null,null,null,"=",{"$f":"L25*(B17+B18)/2","v":0},null,"$/yr"]
[]
["O)","Annual Gas Cost for Water Heating",null,null,null,"=","M * I",null,null,null,"=",{"$f":"L27*B19","v":0},null,"$/yr"]
[]
["P)","Annual Cost Savings with Gas",null,null,null,"=","N - O",null,null,null,"=",{"$f":"L29-L31","v":0},null,"$/yr"]
[]
["Q)","Simple Payback",null,null,null,"=","J",null,null,null,"=",{"$f":"B20/L33","v":{"$error":"#DIV/0!"}},null,"yrs"]
[null,null,null,null,null,null,"P"]

{"sheet":"Tables","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}