{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Interior Relamping","Tables"],"not_rendered":{"charts":0,"images":4,"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":"Interior Relamping","index":0,"n_rows":29,"n_cols":28,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,13],[1,0,1,13],[3,0,3,3],[3,4,3,13],[4,0,4,13],[5,0,5,13],[15,1,15,2],[16,1,16,2],[13,1,13,2],[14,1,14,2],[6,0,6,13],[8,0,8,13],[9,0,9,13],[10,0,10,8],[12,0,12,4],[12,5,12,12],[7,0,7,13],[17,3,17,4],[18,3,18,4],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[25,1,25,2],[28,1,28,2],[24,1,24,2],[27,1,27,2],[26,1,26,2],[22,1,22,2],[23,1,23,2],[17,19,18,19],[17,20,18,23],[17,24,18,24],[17,25,18,26],[25,3,25,4],[26,3,26,4],[27,3,27,4],[28,3,28,4],[13,5,13,12],[14,5,14,12],[15,5,15,12],[16,5,16,12],[17,5,17,12],[18,5,18,12],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[25,14,25,26],[24,14,24,26],[25,5,25,12],[26,5,26,12],[27,5,27,12],[28,5,28,12],[19,5,19,12],[20,5,20,12],[21,5,21,12],[22,5,22,12],[23,5,23,12],[24,5,24,12],[1,27,2,27],[3,14,4,14],[3,15,4,18],[3,19,4,19],[3,20,4,23],[3,24,4,24],[3,25,4,26],[3,27,4,27],[0,14,0,27],[1,14,2,14],[1,15,2,18],[1,19,2,19],[1,24,2,24],[1,25,2,26],[5,27,6,27],[7,14,8,14],[7,15,8,18],[7,19,8,19],[7,24,8,24],[7,25,8,26],[7,27,8,27],[5,14,6,14],[5,15,6,18],[5,19,6,19],[5,24,6,24],[5,25,6,26],[9,27,10,27],[11,14,12,14],[11,15,12,18],[11,19,12,19],[11,20,12,23],[11,24,12,24],[11,25,12,26],[11,27,12,27],[9,14,10,14],[9,15,10,18],[9,19,10,19],[9,20,10,23],[9,24,10,24],[9,25,10,26],[13,27,14,27],[15,14,16,14],[15,15,16,18],[15,19,16,19],[15,24,16,24],[15,25,16,26],[15,27,16,27],[13,14,14,14],[13,15,14,18],[13,19,14,19],[13,20,14,23],[13,24,14,24],[13,25,14,26],[21,27,22,27],[22,20,22,23],[1,20,1,23],[2,20,2,23],[5,20,5,23],[6,20,6,23],[7,20,8,23],[15,20,16,23],[21,14,22,14],[21,15,22,18],[21,19,22,19],[21,20,21,23],[21,24,22,24],[21,25,22,26],[17,27,18,27],[19,14,20,14],[19,15,20,18],[19,19,20,19],[19,20,20,23],[19,24,20,24],[19,25,20,26],[19,27,20,27],[17,14,18,14],[17,15,18,18]]}
["Interior Fixture Relamping/Replacing",null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculations"]
["(Electric Cooling and Heating)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Q)","Lighting Electrical Demand Reduction",null,null,null,"=","(C * E) - (D * F)",null,null,null,"=",{"$f":"((B16*B18)-(B17*B19))/1000","v":0},null,"kW/mo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000]
["Description of UCRM:",null,null,null,"(Data needed: area of building, use, typical existing light level at table height, type of",null,null,null,null,null,null,null,null,null,"R)","Lighting Electrical Energy Savings",null,null,null,"=","Q * (A + B)",null,null,null,"=",{"$f":"Z2*(B14+B15)","v":0},null,"kWh/yr"]
["existing lamp and ballast, type of replacement lamp and ballast, estimated light level after conversion1, and"]
["recommended light level)",null,null,null,null,null,null,null,null,null,null,null,null,null,"S)","Cooling Electrical Energy Savings",null,null,null,"=","R * 3,413 Btu/kWh * N * 0.801",null,null,null,"=",{"$f":"(Z4*3413*B27*0.8)/(B20*1000)","v":{"$error":"#DIV/0!"}},null,"kWh/yr"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G * 1000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T)","Annual Electrical Energy Savings",null,null,null,"=","R + S",null,null,null,"=",{"$f":"Z4+Z6","v":{"$error":"#DIV/0!"}},null,"kWh/yr"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"U)","Annual Electrical Cost Savings",null,null,null,"=","T * (H + I)/2 +12 * Q * (J + K)/2",null,null,null,"=",{"$f":"Z8*(B21+B22)/2+12*Z2*(B23+B24)/2","v":{"$error":"#DIV/0!"}},null,"$/yr"]
["1Assume that lumens before/lumens after = fc before/fc after"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V)","Electrical Heating Energy Cost Penalty",null,null,null,"=","0.801 * (R * M / L) * (H + I)/2",null,null,null,"=",{"$f":"0.8*(Z4*B26/(B25/100))*(B21+B22)/2","v":{"$error":"#DIV/0!"}},null,"$/yr"]
["Data needed for calculations",null,null,null,null,"Description",null,null,null,null,null,null,null,"Resource"]
["A)",null,null,"hrs/yr",null,"Summer Operating Hours",null,null,null,null,null,null,null,null,"W)","Annual Cost Savings",null,null,null,"=","U - V",null,null,null,"=",{"$f":"Z10-Z12","v":{"$error":"#DIV/0!"}},null,"$/yr"]
["B)",null,null,"hrs/yr",null,"Winter Operating Hours"]
["C)",null,null,"Lamps",null,"Total Number of Lamps - Old",null,null,null,null,null,null,null,null,"X)","Lamp Cost",null,null,null,"=","O * D",null,null,null,"=",{"$f":"B28*B17","v":0},null,"$"]
["D)",null,null,"Lamps",null,"Total Number of Lamps - New"]
["E)",null,null,"Watts/Fixture",null,"Old Lamp and Ballast Wattage",null,null,null,null,null,null,null,"Table 12","Y)","Labor Cost",null,null,null,"=","P * D",null,null,null,"=",{"$f":"B29*B17","v":0},null,"$"]
["F)",null,null,"Watts/Fixture",null,"New Lamp and Ballast Wattage",null,null,null,null,null,null,null,"Table 12"]
["G)",null,null,"Btuh/Watt",null,"Performance of Cooling System",null,null,null,null,null,null,null,"Table 1","Z)","Implementation Cost",null,null,null,"=","X + Y",null,null,null,"=",{"$f":"Z16+Z18","v":0},null,"$"]
["H)",null,null,"$/kWh",null,"Electrical Energy Rate - Summer"]
["I)",null,null,"$/kWh",null,"Electrical Energy Rate - Winter",null,null,null,null,null,null,null,null,"AA","Simple Payback",null,null,null,"=","Z",null,null,null,"=",{"$f":"Z20/Z14","v":{"$error":"#DIV/0!"}},null,"yrs"]
["J)",null,null,"$/kW",null,"Electrical Demand Rate - Summer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W"]
["K)",null,null,"$/kW",null,"Electrical Demand Rate - Winter"]
["L)",null,null,"%",null,"Efficiency of Heating System",null,null,null,null,null,null,null,"Table 3","1Lighting cooling/heating load factor for 10-hour office use derived from data in  Table 17B,"]
["M)",null,null,null,null,"Seasonal Heating Factor",null,null,null,null,null,null,null,"Table 4","pg. 26.23, 1981 ASHRAE Handbook of Fundamentals"]
["N)",null,null,null,null,"Seasonal Cooling Factor",null,null,null,null,null,null,null,"Table 4"]
["O)",null,null,"$/Lamp",null,"New Lamp Cost"]
["P)",null,null,"$/Lamp",null,"Labor Cost for Lamp Replacement"]

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