{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Gas Heating","Tables"],"not_rendered":{"charts":0,"images":1,"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":"Gas Heating","index":0,"n_rows":31,"n_cols":14,"rows_kept":31,"cut":false,"hidden":false,"merged":[[5,0,5,13],[0,0,0,13],[1,0,1,13],[3,0,3,3],[3,4,3,13],[4,0,4,13],[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],[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],[14,3,14,4],[14,5,14,12],[15,1,15,2],[15,3,15,4],[15,5,15,12],[16,1,16,2],[16,3,16,4],[16,5,16,12],[18,0,18,13],[19,0,20,0],[19,1,20,4],[19,5,20,5],[19,10,20,10],[19,11,20,12],[19,13,20,13],[19,6,19,9],[20,6,20,9],[21,0,22,0],[21,1,22,4],[21,5,22,5],[21,10,22,10],[21,11,22,12],[21,6,22,9],[21,13,22,13],[23,13,24,13],[24,6,24,9],[25,0,26,0],[25,1,26,4],[25,5,26,5],[25,6,26,9],[25,10,26,10],[25,11,26,12],[25,13,26,13],[23,0,24,0],[23,1,24,4],[23,5,24,5],[23,6,23,9],[23,10,24,10],[23,11,24,12],[27,13,28,13],[29,0,30,0],[29,1,30,4],[29,5,30,5],[29,10,30,10],[29,11,30,12],[29,13,30,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],[29,6,29,9],[30,6,30,9]]}
["Replacement of Low Efficiency Gas Heating"]
["(Gas to Gas)"]
[]
["Description of UCRM:",null,null,null,"(Data needed: area served, condition/performance of unit)"]
[]
[]
[]
[]
[]
["Data needed for calculations",null,null,null,null,"Description",null,null,null,null,null,null,null,"Resource"]
["A)",null,null,"Btu/hr",null,"Heating Unit Capacity"]
["B)",null,null,"hrs/yr",null,"Annual Use"]
["C)",null,null,"%",null,"Load Factor (Utilization Factor)"]
["D)",null,null,"%",null,"Efficiency on Old Unit",null,null,null,null,null,null,null,"Table 3"]
["E)",null,null,"%",null,"Efficiency on Proposed Unit",null,null,null,null,null,null,null,"Table 3"]
["F)",null,null,"$/Mcf",null,"Natural Gas Rate"]
["G)",null,null,"$",null,"Cost of Unit(s), including Installation and Design"]
[]
["Calculations"]
["H)","Present Fuel Use",null,null,null,"=","A * B * C",null,null,null,"=",{"$f":"(B11*B12*(B13/100))/1030000","v":0},null,"Mcf/yr"]
[null,null,null,null,null,null,"1,030,000 Btu/Mcf"]
["I)","Heating Effect Delivered",null,null,null,"=","H * D * 1,030,000 Btu/Mcf",null,null,null,"=",{"$f":"L20*(B14/100)*1030000","v":0},null,"Btu/yr"]
[]
["J)","Equivalent Fuel in New Heater",null,null,null,"=","(I / E)",null,null,null,"=",{"$f":"(L22/(B15/100))/1030000","v":{"$error":"#DIV/0!"}},null,"Mcf/yr"]
[null,null,null,null,null,null,"1,030,000 Btu/Mcf"]
["K)","Fuel Saved",null,null,null,"=","H - J",null,null,null,"=",{"$f":"L20-L24","v":{"$error":"#DIV/0!"}},null,"Mcf/yr"]
[]
["L)","Operational Savings",null,null,null,"=","K * F",null,null,null,"=",{"$f":"L26*B16","v":{"$error":"#DIV/0!"}},null,"$/yr"]
[]
["M)","Simple Payback",null,null,null,"=","G",null,null,null,"=",{"$f":"B17/L28","v":{"$error":"#DIV/0!"}},null,"yrs"]
[null,null,null,null,null,null,"L"]

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