{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Lighting Controls","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":"Lighting Controls","index":0,"n_rows":31,"n_cols":14,"rows_kept":31,"cut":false,"hidden":false,"merged":[[19,3,19,4],[19,5,19,12],[20,5,20,12],[14,6,14,12],[16,6,16,12],[15,13,16,13],[13,13,14,13],[18,5,18,12],[13,0,14,0],[15,3,16,4],[15,1,16,2],[15,0,16,0],[13,5,13,12],[15,5,15,12],[17,5,17,12],[13,1,14,2],[13,3,14,4],[29,13,30,13],[25,13,26,13],[27,11,28,12],[27,13,28,13],[25,11,26,12],[29,0,30,0],[29,1,30,4],[29,5,30,5],[29,10,30,10],[29,11,30,12],[29,6,29,9],[30,6,30,9],[27,0,28,0],[27,1,28,4],[27,5,28,5],[27,6,28,9],[27,10,28,10],[25,0,26,0],[25,1,26,4],[25,5,26,5],[25,6,26,9],[25,10,26,10],[23,6,23,9],[24,6,24,9],[19,1,19,2],[20,1,20,2],[17,1,17,2],[18,1,18,2],[17,3,17,4],[18,3,18,4],[22,0,22,13],[23,0,24,0],[23,1,24,4],[23,5,24,5],[23,10,24,10],[23,11,24,12],[23,13,24,13],[20,3,20,4],[11,1,11,2],[12,1,12,2],[6,0,6,13],[7,0,7,13],[8,0,8,13],[10,0,10,4],[10,5,10,12],[11,3,11,4],[12,3,12,4],[11,5,11,12],[12,5,12,12],[5,0,5,13],[0,0,0,13],[1,0,1,13],[3,0,3,3],[3,4,3,13],[4,0,4,13]]}
["Exterior Lighting Controls"]
[]
[]
["Description of UCRM:",null,null,null,"(Data needed:  use of lighted area, type of lamps)"]
[]
[]
[]
[]
[]
[]
["Data needed for calculations",null,null,null,null,"Description",null,null,null,null,null,null,null,"Resource"]
["A)",null,null,"Watts",null,"Wattage of Lamps (+ Ballasts) per Luminaire Controlled",null,null,null,null,null,null,null,"Table 12"]
["B)",null,null,"Luminaires",null,"Total Number of Luminaires Controlled"]
["C)",null,null,"hrs/summer",null,"Reduction in Summer Operating Hours Due to Controls"]
[null,null,null,null,null,"=","hrs/day * days/yr"]
["D)",null,null,"hrs/winter",null,"Reduction in Winter Operating Hours Due to Controls"]
[null,null,null,null,null,"=","hrs/day * days/yr"]
["E)",null,null,"$/kWh",null,"Electrical Energy Rate - Summer"]
["F)",null,null,"$/kWh",null,"Electrical Energy Rate - Winter"]
["G)",null,null,"$/Controller",null,"Installed Cost per Lighting Controller"]
["H)",null,null,"Controllers",null,"Number of Lighting Controllers Required"]
[]
["Calculations"]
["I)","Annual Electrical Energy Savings",null,null,null,"=","A * B * (C + D)",null,null,null,"=",{"$f":"(B12*B13*(B14+B16))/1000","v":0},null,"kWh/yr"]
[null,null,null,null,null,null,1000]
["J)","Annual Cost Savings",null,null,null,"=","I * (E + F)/2 ",null,null,null,"=",{"$f":"L24*(B18+B19)/2","v":0},null,"$/yr"]
[]
["K)","Implementation Cost",null,null,null,"=","G * H",null,null,null,"=",{"$f":"B20*B21","v":0},null,"$"]
[]
["L)","Simple Payback",null,null,null,"=","K",null,null,null,"=",{"$f":"L28/L26","v":{"$error":"#DIV/0!"}},null,"yrs"]
[null,null,null,null,null,null,"J"]

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