{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Lighting Savings Check SG 9.3","lookup"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"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":"Lighting Savings Check SG 9.3","index":0,"n_rows":55,"n_cols":29,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,4,0,12],[6,2,6,7],[7,2,7,7],[6,8,6,13],[7,8,7,13],[2,1,2,13],[5,1,5,13],[4,1,4,13],[3,1,3,13],[11,16,11,26],[11,2,11,15],[8,2,8,7],[9,2,9,7],[8,8,8,13],[9,8,9,13]]}
[null,null,null,null,"Lighting Tool \nSimulation Guidelines Section 9.3 Check\nAugust 2021"]
[null,"Instructions"]
[null,"Please use this tool to report proposed lighting information as compared to existing conditions, and to confirm Section 9.3 of the Simulation Guidelines has been followed regarding watt reduction allowances based on fixture type. Consider submitting this tool with SAV-IT submissions to expedite lighting comments in the review."]
[null,"Step 1: Please copy and paste the SAV-IT existing lighting information into the blue cells of the table below. \n             NOTE: the orange cells in the Lamp Type column must be manually input."]
[null,"Step 2: Please input proposed lighting information in the yellow cells."]
[null,"Step 3: If Column AC shows a red flag, please either:\n1. Update the proposed watts used in the model to comply with Section 9.3 of the Simulation Guidelines minimum proposed watt allowances based on fixture types. The allowed minimum watt in the proposed is shown in column AB. \nOR\n2. Comply with one of the three options in the reference table below for demonstrating appropriate light levels will still be found in the post-retrofit condition. "]
[null,null,"For the Existing Fixture   ",null,null,null,null,null,"For the Proposed Fixture"]
[null,"Option 1","Submit existing light output and how measured, existing wattage and how measured, make and model of existing fixture, lamp and ballast.",null,null,null,null,null,"Submit cut sheet including the model number, wattage, and mean lumen output."]
[null,"Option 2","Submit photos of light meter readings confirming space foot-candles.",null,null,null,null,null,"Submit foot-candle calculations for the space, confirming the proposed design provides lumens per square foot that are greater than or equal to the existing measured light levels."]
[null,"Option 3","N/A",null,null,null,null,null,"Submit foot-candle calculations to confirm foot-candles meet or exceed recommendations in the current edition of the Illumination Engineering Society (IESNA) Lighting Handbook based on space type."]
[]
[null,null,"Existing Building Lighting",null,null,null,null,null,null,null,null,null,null,null,null,null,"Proposed Building Lighting"]
[null,"Space","Lamp Watts","Lamps per Fixture","Watts per Fixture","Number of Fixtures","Floor Area (SF)","Lighting Power Density (LPD) (Divide total watts by floor area - w/SF)","Control","Hours per Year","Lamp Type","Ballast Type","Condition","Age (Years)","Back-up Battery?","Total Watt","Lamp Watts","Lamps per Fixture","Watts per Fixture","Number of Fixtures","Total Watt","Floor Area (SF)","Lighting Power Density (LPD)","Control","Hours per Year","Lamp Type","Ballast Type","Allowed Proposed Watts (Total)"]
[null,"Common Area"]
[null,"Example:  Corridor",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F15*E15","v":0},null,null,{"$f":"Q15*R15","v":0},null,{"$f":"S15*T15","v":0},null,{"$f":"U15/V15","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"IFERROR(ROUNDDOWN(IF(AND(K15=\"Incandescent\",Z15=\"LED\"),P15/4.5,IF(AND(K15=\"Incandescent\",Z15=\"Fluorescent\"),P15/3.4,IF(AND(K15=\"Incandescent\",Z15=\"CFL\"),P15/3.4,IF(AND(K15=\"Fluorescent\",Z15=\"LED\"),P15*2/3,IF(AND(OR(K15=\"HID\",K15=\"CFL\"),Z15=\"LED\"),P15*2/3,\"-\"))))),1),\"-\")","v":"-"},{"$f":"IF(U15=0,\"\",IF(AB15>U15,\"The proposed watts reported do not comply with Simulation Guideline 9.3. Please follow directions at the top of this tab.\",\"-\"))","v":""}]
[null,"Basement Stairs",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,{"$f":"IFERROR(ROUNDDOWN(IF(AND(K16=\"Incandescent\",Z16=\"LED\"),P16/4.5,IF(AND(K16=\"Incandescent\",Z16=\"Fluorescent\"),P16/3.4,IF(AND(K16=\"Incandescent\",Z16=\"CFL\"),P16/3.4,IF(AND(K16=\"Fluorescent\",Z16=\"LED\"),P16*2/3,IF(AND(OR(K16=\"HID\",K16=\"CFL\"),Z16=\"LED\"),P16*2/3,\"-\"))))),1),\"-\")","v":"-"},{"$f":"IF(U16=0,\"\",IF(AB16>U16,\"The proposed watts reported do not comply with Simulation Guideline 9.3. Please follow directions at the top of this tab.\",\"-\"))","v":""}]
[null,"Basement ",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,"-",""]
[null,"Basement ",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,"-",""]
[null,"Basement Supers Office",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,"-",""]
[null,"Basement Boiler Room",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,"-",""]
[null,"Basement Bath",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,"-",""]
[null,"1st Flr Entry Vest",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,"-",""]
[null,"Ist Flr Lobby Hall",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,"-",""]
[null,"2nd Floor Hall",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,"-",""]
[null,"3rd Floor Hall",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,"-",""]
[null,"4th Floor Hall",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,"-",""]
[null,"Exterior ",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,"-",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,"-",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,"-",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F30*E30","v":0},null,null,{"$f":"Q30*R30","v":0},null,{"$f":"S30*T30","v":0},null,{"$f":"U30/V30","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"IFERROR(ROUNDDOWN(IF(AND(K30=\"Incandescent\",Z30=\"LED\"),P30/4.5,IF(AND(K30=\"Incandescent\",Z30=\"Fluorescent\"),P30/3.4,IF(AND(K30=\"Incandescent\",Z30=\"CFL\"),P30/3.4,IF(AND(K30=\"Fluorescent\",Z30=\"LED\"),P30*2/3,IF(AND(OR(K30=\"HID\",K30=\"CFL\"),Z30=\"LED\"),P30*2/3,\"-\"))))),1),\"-\")","v":"-"},{"$f":"IF(U30=0,\"\",IF(AB30>U30,\"The proposed watts reported do not comply with Simulation Guideline 9.3. Please follow directions at the top of this tab.\",\"-\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,"-",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F32*E32","v":0},null,null,{"$f":"Q32*R32","v":0},null,{"$f":"S32*T32","v":0},null,{"$f":"U32/V32","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"IFERROR(ROUNDDOWN(IF(AND(K32=\"Incandescent\",Z32=\"LED\"),P32/4.5,IF(AND(K32=\"Incandescent\",Z32=\"Fluorescent\"),P32/3.4,IF(AND(K32=\"Incandescent\",Z32=\"CFL\"),P32/3.4,IF(AND(K32=\"Fluorescent\",Z32=\"LED\"),P32*2/3,IF(AND(OR(K32=\"HID\",K32=\"CFL\"),Z32=\"LED\"),P32*2/3,\"-\"))))),1),\"-\")","v":"-"},{"$f":"IF(U32=0,\"\",IF(AB32>U32,\"The proposed watts reported do not comply with Simulation Guideline 9.3. Please follow directions at the top of this tab.\",\"-\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,"-",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,"-",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,"-",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,"-",""]
[null,"Apartments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"Example:  Apt5l Kitchen",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F38*E38","v":0},null,null,{"$f":"Q38*R38","v":0},null,{"$f":"S38*T38","v":0},null,{"$f":"U38/V38","v":{"$error":"#DIV/0!"}},null,null,null,null,"-",""]
[null,"Lighting: Apartments",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,"-",""]
[null,"Lighting: Apartments",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,"-",""]
[null,"Lighting: Apartments",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,"-",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F42*E42","v":0},null,null,{"$f":"Q42*R42","v":0},null,{"$f":"S42*T42","v":0},null,{"$f":"U42/V42","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"IFERROR(ROUNDDOWN(IF(AND(K42=\"Incandescent\",Z42=\"LED\"),P42/4.5,IF(AND(K42=\"Incandescent\",Z42=\"Fluorescent\"),P42/3.4,IF(AND(K42=\"Incandescent\",Z42=\"CFL\"),P42/3.4,IF(AND(K42=\"Fluorescent\",Z42=\"LED\"),P42*2/3,IF(AND(OR(K42=\"HID\",K42=\"CFL\"),Z42=\"LED\"),P42*2/3,\"-\"))))),1),\"-\")","v":"-"},{"$f":"IF(U42=0,\"\",IF(AB42>U42,\"The proposed watts reported do not comply with Simulation Guideline 9.3. Please follow directions at the top of this tab.\",\"-\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,"-",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,"-",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,"-",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,"-",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,"-",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,"-",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,"-",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F50*E50","v":0},null,null,{"$f":"Q50*R50","v":0},null,{"$f":"S50*T50","v":0},null,{"$f":"U50/V50","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"IFERROR(ROUNDDOWN(IF(AND(K50=\"Incandescent\",Z50=\"LED\"),P50/4.5,IF(AND(K50=\"Incandescent\",Z50=\"Fluorescent\"),P50/3.4,IF(AND(K50=\"Incandescent\",Z50=\"CFL\"),P50/3.4,IF(AND(K50=\"Fluorescent\",Z50=\"LED\"),P50*2/3,IF(AND(OR(K50=\"HID\",K50=\"CFL\"),Z50=\"LED\"),P50*2/3,\"-\"))))),1),\"-\")","v":"-"},{"$f":"IF(U50=0,\"\",IF(AB50>U50,\"The proposed watts reported do not comply with Simulation Guideline 9.3. Please follow directions at the top of this tab.\",\"-\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F51*E51","v":0},null,null,{"$f":"Q51*R51","v":0},null,{"$f":"S51*T51","v":0},null,{"$f":"U51/V51","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"IFERROR(ROUNDDOWN(IF(AND(K51=\"Incandescent\",Z51=\"LED\"),P51/4.5,IF(AND(K51=\"Incandescent\",Z51=\"Fluorescent\"),P51/3.4,IF(AND(K51=\"Incandescent\",Z51=\"CFL\"),P51/3.4,IF(AND(K51=\"Fluorescent\",Z51=\"LED\"),P51*2/3,IF(AND(OR(K51=\"HID\",K51=\"CFL\"),Z51=\"LED\"),P51*2/3,\"-\"))))),1),\"-\")","v":"-"},{"$f":"IF(U51=0,\"\",IF(AB51>U51,\"The proposed watts reported do not comply with Simulation Guideline 9.3. Please follow directions at the top of this tab.\",\"-\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,"-",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,"-",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,"-",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,null,0,null,{"$error":"#DIV/0!"},null,null,null,null,"-",""]

{"sheet":"lookup","index":1,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
["In-Unit Room Type","In-Unit Average Lighting hrs/day",null,"Fixture Type"]
["Kitchen/ Dining",3.5,null,"CFL"]
["Living Room",3.5,null,"Fluorescent"]
["Hall",2.5,null,"HID"]
["In-Unit laundry/utility room",2.5,null,"Incandescent"]
["Bedroom",2,null,"LED"]
["Bathroom",2,null,"Other"]