{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Inflitration Reduction","Tables"],"not_rendered":{"charts":0,"images":6,"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":"Inflitration Reduction","index":0,"n_rows":62,"n_cols":14,"rows_kept":62,"cut":false,"hidden":false,"merged":[[42,6,43,9],[46,6,47,9],[52,6,53,9],[50,6,51,9],[56,6,57,9],[58,6,59,9],[48,11,49,12],[50,11,51,12],[52,11,53,12],[54,11,55,12],[56,11,57,12],[58,11,59,12],[44,11,45,12],[44,6,44,9],[45,6,45,9],[60,13,61,13],[48,13,49,13],[54,13,55,13],[50,13,51,13],[52,13,53,13],[56,13,57,13],[58,13,59,13],[54,6,54,9],[55,6,55,9],[58,10,59,10],[60,10,61,10],[60,6,60,9],[61,6,61,9],[48,6,48,9],[49,6,49,9],[60,11,61,12],[52,0,53,0],[54,0,55,0],[56,0,57,0],[58,0,59,0],[60,0,61,0],[48,1,49,4],[50,1,51,4],[52,1,53,4],[54,1,55,4],[56,1,57,4],[60,1,61,4],[54,5,55,5],[56,5,57,5],[58,5,59,5],[60,5,61,5],[48,10,49,10],[50,10,51,10],[52,10,53,10],[54,10,55,10],[56,10,57,10],[41,0,41,13],[42,0,43,0],[42,1,43,4],[42,5,43,5],[42,10,43,10],[42,11,43,12],[42,13,43,13],[58,1,59,4],[48,0,49,0],[50,0,51,0],[48,5,49,5],[50,5,51,5],[44,13,45,13],[46,0,47,0],[46,1,47,4],[46,5,47,5],[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,10,45,10],[52,5,53,5],[37,5,37,12],[38,5,38,12],[39,5,39,12],[10,3,10,4],[10,5,10,6],[10,7,10,8],[10,9,10,11],[11,3,11,4],[12,3,12,4],[37,3,37,4],[38,3,38,4],[24,3,24,4],[25,3,25,4],[16,5,16,6],[17,7,17,8],[17,9,17,11],[18,0,18,11],[11,5,11,6],[12,5,12,6],[13,5,13,6],[14,5,14,6],[15,5,15,6],[11,7,11,8],[12,7,12,8],[38,1,38,2],[39,1,39,2],[29,5,29,12],[30,5,30,12],[31,5,31,12],[32,5,32,12],[33,5,33,12],[34,5,34,12],[35,5,35,12],[36,5,36,12],[39,3,39,4],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[33,3,33,4],[34,3,34,4],[35,3,35,4],[36,3,36,4],[30,3,30,4],[31,3,31,4],[32,3,32,4],[28,1,28,2],[28,3,28,4],[28,5,28,12],[26,1,26,2],[26,3,26,4],[26,5,26,12],[27,1,27,2],[27,3,27,4],[27,5,27,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],[24,1,24,2],[25,1,25,2],[29,3,29,4],[24,5,24,12],[25,5,25,12],[21,1,21,2],[21,3,21,4],[21,5,21,12],[10,0,10,2],[11,0,11,2],[12,0,12,2],[13,0,13,2],[14,0,14,2],[15,0,15,2],[16,0,16,2],[15,9,15,11],[16,9,16,11],[13,7,13,8],[14,7,14,8],[15,7,15,8],[16,7,16,8],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[11,9,11,11],[12,9,12,11],[13,9,13,11],[14,9,14,11],[0,0,0,13],[1,0,1,13],[3,0,3,3],[3,4,3,13],[4,0,4,13],[5,0,5,13],[6,0,6,13],[7,0,7,13],[20,0,20,4],[20,5,20,12],[9,0,9,11]]}
["Inflitration Reduction"]
["(Electric Cooling and Gas Heating)"]
[]
["Description of UCRM:",null,null,null,"(Data needed:  use of space, schedule, inside temperature during cooling season,"]
["inside temperature during heating season)"]
[]
[]
[]
[]
["Table AF Area Factors"]
["Location Type",null,null,"Length (ft)",null,"Old Width (in)",null,"New Width (in)",null,"Adjusted Area1"]
[null,null,null,null,null,null,null,null,null,{"$f":"D12*(F12-H12)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"D13*(F13-H13)","v":0}]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,"TOTAL:",null,{"$f":"SUM(J12:L17)","v":0}]
[" 1Adjusted Area  =  Crack Length (ft)  *  Δ  Crack Width (inches)"]
[]
["Data needed for calculations",null,null,null,null,"Description",null,null,null,null,null,null,null,"Resource"]
["A)",{"$f":"J18","v":0},null,"Δ in-ft",null,"Adjusted Area Factor (from Table AF above)"]
["B)",null,null,"°F",null,"Avg Inside Temp (DB/WB°F, Cooling Season)",null,null,null,null,null,null,null,"Table 5"]
["C)",null,null,"°F",null,"Avg Outside Temp (DB/WB°F, Cooling Season)",null,null,null,null,null,null,null,"Table 5"]
["D)",null,null,"°F",null,"Avg Inside Temperature (Heating Season)",null,null,null,null,null,null,null,"Table 5"]
["E)",null,null,"°F",null,"Avg Outside Temperature (Heating Season)",null,null,null,null,null,null,null,"Table 5"]
["F)",null,null,"hrs/yr",null,"Annual Cooling System Operating Hours",null,null,null,null,null,null,null,"Table 15"]
["G)",null,null,"hrs/yr",null,"Annual Heating System Operating Hours",null,null,null,null,null,null,null,"Table 16"]
["H)",null,null,"mph",null,"Avg. Wind Velocity (9 - 12 mph, default 10 mph)"]
["I)",null,null,"kW/Ton",null,"Performance of Cooling System",null,null,null,null,null,null,null,"Table 1"]
["J)",null,null,"%",null,"Efficiency of Heating System",null,null,null,null,null,null,null,"Table 3"]
["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,"$/Mcf",null,"Natural Gas Rate"]
["P)",null,null,"mo/yr",null,"Number of Cooling Months (for demand)"]
["Q)",null,null,"$",null,"Cost of Project, Including Design"]
["R)",null,null,"Btu/lbm",null,"Enthalpy Outside (From Psychrometric Chart Using C)",null,null,null,null,null,null,null,"P. Chart"]
["S)",null,null,"Btu/lbm",null,"Enthalpy Inside (From Psychrometric Chart Using B)",null,null,null,null,null,null,null,"P. Chart"]
[]
["Calculations"]
["T)","Adjusted Infiltration Rate",null,null,null,"=","1.65 * A * H",null,null,null,"=",{"$f":"1.65*B22*B29","v":0},null,"cfm"]
[]
["U)","Cooling Energy Savings",null,null,null,"=","4.5 * T * (R - S) * F",null,null,null,"=",{"$f":"(4.5*L43*(B39-B40)*B27)/12000","v":0},null,"Ton-hrs/yr"]
[null,null,null,null,null,null,"12,000 Btu/Ton-hr"]
["V)","Annual Cooling Electrical Energy Savings",null,null,null,"=","U * I",null,null,null,"=",{"$f":"L45*B30","v":0},null,"kWh/yr"]
[]
["W)","Cooling Electrical Demand Savings",null,null,null,"=","V",null,null,null,"=",{"$f":"L47/B27","v":{"$error":"#DIV/0!"}},null,"kW"]
[null,null,null,null,null,null,"F"]
["X)","Annual Cooling Cost Savings",null,null,null,"=","V * (K + L)/2 + W * (M + N)/2 * P",null,null,null,"=",{"$f":"L47*(B32+B33)/2+L49*(B34+B35)/2*B37","v":{"$error":"#DIV/0!"}},null,"$/yr"]
[]
["Y)","Heating Energy Savings",null,null,null,"=","1.085 * T * (D - E) * G",null,null,null,"=",{"$f":"1.085*L43*(B25-B26)*B28","v":0},null,"Btu/yr"]
[]
["Z)","Annual Natural Gas Savings",null,null,null,"=","Y / J",null,null,null,"=",{"$f":"(L53/(B31/100))/1030000","v":{"$error":"#DIV/0!"}},null,"Mcf/yr"]
[null,null,null,null,null,null,"1,030,000 Btu/Mcf"]
["AA)","Annual Heating Cost Savings",null,null,null,"=","Z * O",null,null,null,"=",{"$f":"L55*B36","v":{"$error":"#DIV/0!"}},null,"$/yr"]
[]
["BB)","Annual Cost Savings",null,null,null,"=","X + AA",null,null,null,"=",{"$f":"L51+L57","v":{"$error":"#DIV/0!"}},null,"$/yr"]
[]
["CC)","Simple Payback",null,null,null,"=","Q",null,null,null,"=",{"$f":"B38/L59","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":[]}