{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["HVAC Replacement","Tables"],"not_rendered":{"charts":0,"images":3,"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":"HVAC Replacement","index":0,"n_rows":47,"n_cols":14,"rows_kept":47,"cut":false,"hidden":false,"merged":[[43,13,44,13],[45,0,46,0],[45,1,46,4],[45,5,46,5],[45,6,45,9],[45,10,46,10],[45,11,46,12],[45,13,46,13],[46,6,46,9],[43,0,44,0],[43,1,44,4],[43,5,44,5],[43,6,44,9],[43,10,44,10],[43,11,44,12],[39,13,40,13],[41,0,42,0],[41,1,42,4],[41,5,42,5],[41,6,42,9],[41,10,42,10],[41,11,42,12],[41,13,42,13],[39,6,40,9],[39,0,40,0],[39,1,40,4],[39,5,40,5],[39,10,40,10],[39,11,40,12],[35,13,36,13],[37,0,38,0],[37,1,38,4],[37,5,38,5],[37,6,38,9],[37,10,38,10],[37,11,38,12],[37,13,38,13],[35,0,36,0],[35,1,36,4],[35,5,36,5],[35,6,36,9],[35,10,36,10],[35,11,36,12],[31,13,32,13],[33,0,34,0],[33,1,34,4],[33,5,34,5],[33,6,34,9],[33,10,34,10],[33,11,34,12],[33,13,34,13],[31,0,32,0],[31,1,32,4],[31,5,32,5],[31,6,32,9],[31,10,32,10],[31,11,32,12],[27,13,28,13],[29,0,30,0],[29,1,30,4],[29,5,30,5],[29,6,30,9],[29,10,30,10],[29,11,30,12],[29,13,30,13],[24,1,24,2],[24,3,24,4],[24,5,24,12],[26,0,26,13],[27,0,28,0],[27,1,28,4],[27,5,28,5],[27,6,28,9],[27,10,28,10],[27,11,28,12],[22,1,22,2],[22,3,22,4],[22,5,22,12],[23,1,23,2],[23,3,23,4],[23,5,23,12],[20,1,20,2],[20,3,20,4],[20,5,20,12],[21,1,21,2],[21,3,21,4],[21,5,21,12],[18,1,18,2],[18,3,18,4],[18,5,18,12],[19,1,19,2],[19,3,19,4],[19,5,19,12],[16,1,16,2],[16,3,16,4],[16,5,16,12],[17,1,17,2],[17,3,17,4],[17,5,17,12],[14,1,14,2],[14,3,14,4],[14,5,14,12],[15,1,15,2],[15,3,15,4],[15,5,15,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],[11,1,11,2],[11,3,11,4],[11,5,11,12],[6,0,6,13],[8,0,8,4],[8,5,8,12],[9,1,9,2],[9,3,9,4],[9,5,9,12],[0,0,0,13],[1,0,1,13],[3,0,3,3],[3,4,3,13],[4,0,4,13],[5,0,5,13],[10,1,10,2],[10,3,10,4],[10,5,10,12]]}
["Replacement of Low Efficiency HVAC Units"]
["(Converting from Electric Cooling and 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,"kW",null,"Resistance 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,"COP",null,"Heating Efficiency of Existing Unit (assume 1 for resistance heat) "]
["J)",null,null,"COP",null,"Htg Eff. of Proposed Unit (adj. for resistance heat below 30ºF)"]
["K)",null,null,"$/kWh",null,"Electrical Energy Rate - Summer"]
["L)",null,null,"$/kWh",null,"Electrical Energy Rate - Winter"]
["M)",null,null,"$/kW-mo",null,"Electrical Demand Rate - Summer"]
["N)",null,null,"$/kW-mo",null,"Electrical Demand Rate - Winter"]
["O)",null,null,null,null,"Est. of Demand Diversity in Htg Mode (0 to 1 w/ 0.6 as default)"]
["P)",null,null,"$",null,"Installed Cost of Unit(s)"]
[]
["Calculations"]
["Q)","Cooling Demand Reduction",null,null,null,"=","A * (G - H)",null,null,null,"=",{"$f":"B10*(B16-B17)","v":0},null,"kW"]
[]
["R)","Annual Cooling Energy Savings",null,null,null,"=","Q * C",null,null,null,"=",{"$f":"L28*B12","v":0},null,"kWh/yr"]
[]
["S)","Cooling Demand Savings",null,null,null,"=","Q * E",null,null,null,"=",{"$f":"L28*B14","v":0},null,"kW-mo/yr"]
[]
["T)","Annual Cooling Cost Savings",null,null,null,"=","R * K + S * M",null,null,null,"=",{"$f":"L30*B20+L32*B22","v":0},null,"$/yr"]
[]
["U)","Heating Demand Reduction",null,null,null,"=","B * (1 / I - 1 / J)",null,null,null,"=",{"$f":"B11*(1/B18-1/B19)","v":{"$error":"#DIV/0!"}},null,"kW"]
[]
["V)","Heating Energy Savings",null,null,null,"=","U * D",null,null,null,"=",{"$f":"L36*B13","v":{"$error":"#DIV/0!"}},null,"kWh/yr"]
[]
["W)","Heating Demand Savings",null,null,null,"=","U * F * O",null,null,null,"=",{"$f":"L36*B15*B24","v":{"$error":"#DIV/0!"}},null,"kW-mo/yr"]
[]
["X)","Annual Heating Cost Savings",null,null,null,"=","V * L + W * N",null,null,null,"=",{"$f":"L38*B21+L40*B23","v":{"$error":"#DIV/0!"}},null,"$/yr"]
[]
["Y)","Annual Cost Savings",null,null,null,"=","T + X",null,null,null,"=",{"$f":"L34+L42","v":{"$error":"#DIV/0!"}},null,"$/yr"]
[]
["Z)","Simple Payback",null,null,null,"=","P",null,null,null,"=",{"$f":"B25/L44","v":{"$error":"#DIV/0!"}},null,"yrs"]
[null,null,null,null,null,null,"Y"]

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