{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["HVAC Replacement","Tables"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":1,"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":"HVAC Replacement","index":0,"n_rows":56,"n_cols":14,"rows_kept":56,"cut":false,"hidden":false,"merged":[[1,0,1,13],[3,0,3,3],[3,4,3,13],[4,0,4,13],[5,0,5,13],[31,0,31,13],[32,0,33,0],[32,1,33,4],[32,5,33,5],[32,10,33,10],[32,11,33,12],[29,0,29,6],[25,13,26,13],[25,0,26,0],[23,3,23,4],[15,1,15,2],[16,1,16,2],[13,1,13,2],[14,1,14,2],[11,1,11,2],[12,1,12,2],[11,5,11,12],[12,5,12,12],[13,5,13,12],[14,5,14,12],[15,5,15,12],[16,5,16,12],[17,3,17,4],[18,3,18,4],[19,3,19,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,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],[0,0,0,13],[32,13,33,13],[34,0,35,0],[34,1,35,4],[34,5,35,5],[34,6,35,9],[34,10,35,10],[34,11,35,12],[34,13,35,13],[32,6,33,9],[36,13,37,13],[38,0,39,0],[38,1,39,4],[38,5,39,5],[38,6,39,9],[38,10,39,10],[38,11,39,12],[38,13,39,13],[36,6,37,9],[36,0,37,0],[36,1,37,4],[36,5,37,5],[36,10,37,10],[36,11,37,12],[40,13,41,13],[42,0,43,0],[42,1,43,4],[42,5,43,5],[42,6,42,9],[42,10,43,10],[42,11,43,12],[42,13,43,13],[43,6,43,9],[40,6,40,9],[40,0,41,0],[40,1,41,4],[40,5,41,5],[40,10,41,10],[40,11,41,12],[41,6,41,9],[16,3,16,4],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[17,5,17,12],[18,5,18,12],[19,5,19,12],[20,5,20,12],[21,5,21,12],[22,5,22,12],[20,3,20,4],[21,3,21,4],[22,3,22,4],[24,1,24,2],[27,1,27,2],[25,1,26,2],[25,3,26,4],[26,5,26,12],[27,5,27,12],[23,5,23,12],[24,5,24,12],[25,5,25,12],[24,3,24,4],[27,3,27,4],[44,13,45,13],[45,6,45,9],[46,0,47,0],[46,1,47,4],[46,5,47,5],[46,6,47,9],[46,10,47,10],[46,11,47,12],[46,13,47,13],[44,0,45,0],[44,1,45,4],[44,5,45,5],[44,6,44,9],[44,10,45,10],[44,11,45,12],[48,13,49,13],[50,0,51,0],[50,1,51,4],[50,5,51,5],[50,6,51,9],[50,10,51,10],[50,11,51,12],[50,13,51,13],[48,6,49,9],[48,0,49,0],[48,1,49,4],[48,5,49,5],[48,10,49,10],[48,11,49,12],[52,13,53,13],[54,0,55,0],[54,1,55,4],[54,5,55,5],[54,6,54,9],[54,10,55,10],[54,11,55,12],[54,13,55,13],[55,6,55,9],[52,0,53,0],[52,1,53,4],[52,5,53,5],[52,6,53,9],[52,10,53,10],[52,11,53,12]]}
["Replacement of Low Efficiency HVAC Units"]
["(Converting from Electric Cooling and Gas Heating to Heat Pumps)"]
[]
["Description of UCRM:",null,null,null,"(Data needed:  use of space, age of units)"]
[]
[]
[]
[]
[]
["Data needed for calculations",null,null,null,null,"Description",null,null,null,null,null,null,null,"Resource"]
["A)",null,null,"Tons",null,"Cooling Tonnage to be Replaced"]
["B)",null,null,"Btu/hr",null,"Natural Gas Heating to be Replaced"]
["C)",null,null,"hrs/yr",null,"Cooling Equivalent Full Load Operating Hours",null,null,null,null,null,null,null,"Table 15"]
["D)",null,null,"hrs/yr",null,"Heating Equivalent Full Load Operating Hours",null,null,null,null,null,null,null,"Table 16"]
["E)",null,null,"mo/yr",null,"Number of Cooling Months"]
["F)",null,null,"mo/yr",null,"Number of Heating Months"]
["G)",null,null,"kW/Ton",null,"Performance of Existing Cooling Unit",null,null,null,null,null,null,null,"Table 1"]
["H)",null,null,"kW/Ton",null,"Performance of Proposed Cooling Unit",null,null,null,null,null,null,null,"Table 1"]
["I)",null,null,"%",null,"Heating Efficiency of Existing Gas Heater",null,null,null,null,null,null,null,"Table 3"]
["J)",null,null,"COP",null,"Heating Efficiency (COP) of Proposed Unit1"]
["K)",null,null,"$/kWh",null,"Electrical Energy Rate - Summer"]
["L)",null,null,"$/kWh",null,"Electrical Energy Rate - Winter"]
["M)",null,null,"$/Mcf",null,"Cost of Natural Gas"]
["N)",null,null,"$/kW-mo",null,"Electrical Demand Rate - Summer"]
["O)",null,null,"$/kW-mo",null,"Electrical Demand Rate - Winter"]
["P)",null,null,null,null,"Estimate of Demand Diversity in Heating Mode "]
[null,null,null,null,null,"(range 0 to 1 with 0.6 as default) "]
["Q)",null,null,"$",null,"Installed Cost of Unit(s)"]
[]
["1Adjust for resistance heat below 30°F"]
[]
["Calculations"]
["R)","Cooling Demand Reduction",null,null,null,"=","A * (G - H)",null,null,null,"=",{"$f":"B11*(B17-B18)","v":0},null,"kW"]
[]
["S)","Annual Cooling Energy Savings",null,null,null,"=","R * C",null,null,null,"=",{"$f":"L33*B13","v":0},null,"kWh/yr"]
[]
["T)","Cooling Demand Savings",null,null,null,"=","R * E",null,null,null,"=",{"$f":"L33*B15","v":0},null,"kW/mo-yr"]
[]
["U)","Annual Cooling Cost Savings",null,null,null,"=","S * K + T * N",null,null,null,"=",{"$f":"L35*B21+L37*B24","v":0},null,"$/yr"]
[]
["V)","Original Natural Gas Consumption",null,null,null,"=","B * D",null,null,null,"=",{"$f":"(B12*B14)/1030000","v":0},null,"Mcf/yr"]
[null,null,null,null,null,null,"1,030,000 Btu/Mcf"]
["W)","Heat Pump Consumption",null,null,null,"=","B * D * I",null,null,null,"=",{"$f":"(B12*B14*(B19/100))/(B20*3413)","v":{"$error":"#DIV/0!"}},null,"kWh/yr"]
[null,null,null,null,null,null,"J * 3,413 Btu/kWh"]
["X)","Heating Electrical Demand",null,null,null,"=","W",null,null,null,"=",{"$f":"L43/(B14*B26)","v":{"$error":"#DIV/0!"}},null,"kW"]
[null,null,null,null,null,null,"D * P"]
["Y)","Cost for Natural Gas Heating",null,null,null,"=","V * M",null,null,null,"=",{"$f":"L41*B23","v":0},null,"$/yr"]
[]
["Z)","Cost for Heat Pump Heating",null,null,null,"=","W * L + X * O * F",null,null,null,"=",{"$f":"L43*B22+L45*B25*B16","v":{"$error":"#DIV/0!"}},null,"$/yr"]
[]
["AA)","Total Heating Savings",null,null,null,"=","Y - Z",null,null,null,"=",{"$f":"L47-L49","v":{"$error":"#DIV/0!"}},null,"$/yr"]
[]
["BB)","Total Savings",null,null,null,"=","U + AA",null,null,null,"=",{"$f":"L39+L51","v":{"$error":"#DIV/0!"}},null,"$/yr"]
[]
["CC)","Simple Payback",null,null,null,"=","Q",null,null,null,"=",{"$f":"B28/L53","v":{"$error":"#DIV/0!"}},null,"yrs"]
[null,null,null,null,null,null,"BB"]

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