{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["ReadMe","temp","LTG-SUM","LTG-INT-SPACE","LTG-INT-DISPLAY","LTG-INT-BLD","LTG-INT-REF","LTG-EXT","LTG-EXT-REF","LTG-LPA","LTG-CHK"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":52,"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":"ReadMe","index":0,"n_rows":48,"n_cols":2,"rows_kept":48,"cut":false,"hidden":false,"merged":[[1,0,1,1],[5,0,6,0],[9,0,10,0],[13,0,19,0],[47,0,47,1],[28,0,28,1],[39,0,40,0],[41,0,44,0],[45,0,46,0],[36,0,38,0],[33,0,35,0],[30,0,32,0],[21,0,23,0]]}
["Instructions for Electronic Forms, pg 1"]
["2012 Washington State Energy Code Compliance Forms for Commercial Buildings including R2 & R3 over 3 stories and all R1 "]
[null,"Revised Jan 2014"]
[null,"     Commercial Provision Chapters 1 - 5 of the 2012 Washington State Energy Code apply to all commercial occupancies, R-2 and R-3 occupancies greater than 3 stories above grade, and R-1 occupancy (all building heights)."]
["Intro","     This file, LTG12-v3.XLSM, has electronic compliance forms for electrical power and lighting system provisions as defined in Section C405. This includes interior and exterior lighting systems, electric motors, and transformers. There are two companion files: ENV12-v3.XLSM (Sections C101, C303, C402 and Appendix A envelope requirements) and MECH12-v3.XLSM (Section C403 mechanical systems requirements). "]
["Energy Code ","    This form is a compliance aid and is not a substitute for the full energy code text or specific jurisdiction compliance requirements. Users should refer to the code text and contact the local jurisdiction for complete information. The full 2012 WSEC code text is available for download from the NEEC website:"]
[null,"http:/www.neec.net/energy-codes"]
["Training ","Refer to the NEEC website for instruction on how to complete all of the 2012 WSEC Compliance Forms."]
["Start-up","Select this file from the NEEC website to download to your computer. When opening the file be sure to Enable Macros. "]
["Overview ","     This file is an Excel workbook that contains multiple compliance forms and resources in Excel worksheets. Each worksheet is indicated by a tab at the bottom of the screen. You may visit each worksheet by selecting it's tab. "]
[null,"     Most calculations are automated. Cells that display informational text and the results of calculations are write-protected and cannot be edited. "]
["Save Files ","This file is saved in the same manner as any standard Excel file. "]
["Getting Around","     Some forms have two pages. Both pages are available on screen when you select the tab for a form (worksheet). Use the scroll bars to find the second page located below the first page."]
["Input Cells ","     All general project information and the date are entered once on LTG-SUM. This information is automatically replicated on all other LTG forms. The LTG-SUM form accompanies all other LTG forms except LTG-EXT, which is a stand alone form."]
[null,"     Only input cells are accessible. If you try to edit a write-protected cell an error message will appear requesting a password. A password IS NOT required to complete these forms. You may use the TAB key to move to the next input cell. If the TAB doesn't take you where you want to go, use your mouse to move around the form. "]
[null,"     Avoid excessively long text strings when entering information. In some cases, text that extends beyond the available space will not be visible. In most cases the text will wrap within the cell. This may force part of the form onto a new page."]
[null,"     To enter the date, use this format: mm/dd/yyyy. For example, you would enter 7/1/2013 or 12/21/2014."]
[null,"     Check boxes can be checked or unchecked by clicking in the box with your mouse. Radio buttons (circles) allow only one in a set to be selected."]
[null,"     Drop-down lists have an arrow at the right side of the cell. Click on the arrow with your mouse and select the appropriate option. Use the delete button on your computer to clear a drop-down entry."]
[null,"     When a form has a space for notes or explanation, click anywhere in the space to edit. "]
["Personalizing","     You can personalize the forms with your company name, address, phone, or any other information. This is done by editing the header or footer in Excel."]
["Adding And Deleting Lines","     Many tables, such as for listing proposed lighting fixture types, have a certain number of lines available for entering data. You may need more lines to enter all your information. Where this feature is available, you can add additional lines to the table by selecting the \"+\" button on the right hand side of the table with your mouse. "]
[null,"     To remove lines that you have added, select the \"-\" button with your mouse. This will delete the last line of the section. You cannot remove lines that were not added; an error message will appear if you try."]
[null,"     If you add additional lines with this method, the pagination may be affected forcing the forms to carry additional lines over to other pages. Be sure to submit all pages to the plans examiner."]
["Compliance Path","    You must select a Compliance Path on LTG-SUM (line 12)."]
["Interior LTG Power Allowance Method","    You must select a Lighting Power Allowance Method on LTG-SUM (line 14) to activate the required worksheets and automatically calculate interior lighting power allowances."]
["Exterior LTG Zone","    You must select a Lighting Zone on LTG-EXT (line 12) to activate this worksheet to display the applicable base site allowance and automatically calculate the applicable exterior lighting power allowances."]
["Instructions for Electronic Forms, pg 2"]
[{"$f":"A2","v":"2012 Washington State Energy Code Compliance Forms for Commercial Buildings including R2 & R3 over 3 stories and all R1 "}]
[null,{"$f":"B3","v":"Revised Jan 2014"}]
["Interior LTG Building Area Method","     For projects complying via the Building Area Method, provide the total gross interior area for each Building Area Type in the Maximum Allowed Lighting Wattage table using the drop down menu. "]
[null,"     Assign a Building Area using the drop menu for each lighting fixture type defined in the Proposed Lighting Wattage table. The worksheet will total all fixtures assigned to each Building Area."]
[null,"     Each Buidling Area shall comply independently."]
["Interior LTG Space-By-Space Method","     For projects complying via the Space-By-Space Method, provide total gross interior area for each Space Type in the Maximum Allowed Lighting Wattage table using the drop down menu."]
[null,"     For Atriums, provide total gross interior area and ceiling height (above finished floor) in the Maximum Allowed Lighting Wattage table."]
[null,"     All Retail Display lighting shall be entered in the LTG-INT-DISPLAY worksheet. Results from this worksheet automatically transfer to the LTG-INT-SPACE worksheet in the assigned locations under Maximum Allowed Lighting Wattage and Proposed Lighting Wattage tables. "]
["Interior LTG Retail Display","     For projects with Retail Display lighting that is in addition to Retail Sales general area lighting, assign a Retail Display category (per Table C405.5.2(2) Footnote A) to each lighting fixture type defined in the Proposed Display Lighting Wattage table using the drop down menu. "]
[null,"     Provide the total gross interior area for each eligible Retail Display category in the Maximum Allowed Display Lighting Wattage table using the drop down menu. "]
[null,"     The total Retail Display gross interior area entered in the LTG-INT-DISPLAY worksheet may not exceed the total Retail Sales gross interior area entered in the LTG-INT-SPACE worksheet."]
["Exterior LTG ","     Provide square-foot surface area, perimeter linear feet, or number of items for each Surface Type in the Tradable and Non-Tradable Maximum Allowed Lighting Wattage tables using the drop down menus. "]
[null,"     Assign a Surface using the drop menu for each exterior lighting fixture type defined in the Tradable and Non-Tradable Proposed Lighting Wattage tables. "]
["Printing ","     The forms should print on any printer supported by your operating system. You will need to have the following TrueType fonts installed under Windows:  Arial, Times New Roman, Courier New and Wingdings. These are all standard Windows fonts."]
[null,"     If you are losing form details when printing, you may have a shortage of printer memory. Try printing problem pages individually."]
[null,"     By default, only the active worksheet is printed. To print more than one worksheet at a time, open your print set-up menu and select either the page range you wish to print or Entire Workbook."]
[null,"     Forms (worksheets) in a workbook may not be deleted because the file is locked."]
["Blank Forms ","    To print blank forms to fill out by hand, delete all of the heading information at the beginning of LTG-SUM and select the desired Lighting Power Allowance Method."]
[null,"     For each radio button group there is a button labeled \"Clear.\" Clicking this button will clear the other buttons so that they will print as empty circles. The \"Clear\" button will not print."]
["End of Instructions for Electronic Forms"]

{"sheet":"temp","index":1,"n_rows":35,"n_cols":1,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]

{"sheet":"LTG-SUM","index":2,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[[11,0,11,1],[13,0,13,1],[15,2,19,6],[34,2,34,6],[36,2,36,6],[35,0,35,6],[33,0,33,6],[29,2,29,6],[31,2,31,6],[32,2,32,6],[38,2,38,6],[22,0,22,6],[23,0,23,6],[24,0,24,6],[28,0,28,6],[37,0,37,6],[30,0,30,6]]}
["Interior Lighting Summary",null,null,null,null,null,"LTG-SUM"]
[{"$f":"ReadMe!A2","v":"2012 Washington State Energy Code Compliance Forms for Commercial Buildings including R2 & R3 over 3 stories and all R1 "},null,null,null,null,null,{"$f":"ReadMe!B3","v":"Revised Jan 2014"}]
["Project Info","Project Address","Baxter Mini-Storage Bldg.",null,null,"Date","2015-09-07"]
[null,null,"3019 Ocean Beach Rd. Pacific Beach WA 98571",null,null,"For Building Department Use"]
[]
[null,"Applicant Name:","Mark Baxter"]
[null,"Applicant Address:","3019 Ocean Beach Rd. Pacific Beach WA 98571"]
[null,"Applicant Phone:","360-276-4182"]
[]
["Project Description",null,null,null,null,false]
[]
["Lighting Compliance Path"]
[]
["Lighting Power Allowance Method"]
[]
["Interior Lighting System "]
["Description"]
["Briefly describe lighting"]
["system type and features."]
[]
[]
["Additions and Change of Space Use (C101.4.3 & C101.4.4)"]
[]
[]
["Provide Building Area Method (LTG-INT-BLD) or Space-By-Space Method (LTG-INT-SPACE) Compliance Form. Document maximum allowed and proposed (including existing if applicable) lighting wattage of Addition or Change of Use space. Provide applicable lighting controls per C405.2 and commissioning of lighting controls per C405.13."]
[]
["Alterations, Renovations and Repairs (C101.4.3.1)"]
[]
["Provide Building Area Method (LTG-INT-BLD) or Space-By-Space Method (LTG-INT-SPACE) Compliance Form. Document maximum allowed wattage within the lighting retrofit space in Maximum Allowed Wattage table and proposed (including existing) lighting wattage in Proposed Wattage table. Retrofit and non-retrofit spaces shall be documented separately using multiple forms."]
[]
["Provide a separate Space-By-Space Method (LTG-INT-SPACE) Compliance Form for this retrofit area. Document existing total wattage within the lighting retrofit space in cell provided in the Maximum Allowed Wattage table. Document proposed (including existing) lighting wattage in the Proposed Wattage table. "]
[]
[]
["Provide applicable manual lighting controls (C405.2.1), occupancy sensors (C405.2.2.2), daylight zone controls (C405.2.2.3), specific application controls (C405.2.3), and commissioning of lighting controls per C405.13"]
[]
["Provide all applicable lighting controls as noted for New Wiring, automatic time switch controls (C405.2.2.1), and commissioning of lighting controls per C405.13."]
[]
["Provide all applicable lighting controls as noted for New Wiring and commissioning of lighting controls per C405.13."]

{"sheet":"LTG-INT-SPACE","index":3,"n_rows":181,"n_cols":5,"rows_kept":181,"cut":false,"hidden":false,"merged":[[19,0,19,4],[37,9,40,9],[5,0,5,2]]}
["Interior Lighting Summary - Space-By-Space ",null,null,null,"LTG-INT-SPACE"]
[{"$f":"'LTG-SUM'!A2","v":"2012 Washington State Energy Code Compliance Forms for Commercial Buildings including R2 & R3 over 3 stories and all R1 "},null,null,null,{"$f":"'LTG-SUM'!G2","v":"Revised Jan 2014"}]
["Project Address",{"$f":"IF('LTG-SUM'!C3=\"1 - This address line will copy onto other forms\",\"Fill this line out on LGT-SUM\",'LTG-SUM'!C3)","v":"Baxter Mini-Storage Bldg."},null,{"$f":"'LTG-SUM'!F3","v":"Date"},{"$f":"'LTG-SUM'!G3","v":"2015-09-07"}]
["Lighting Alterations, Renovations & Building Additions",null,null,{"$f":"'LTG-SUM'!F4","v":"For Building Department Use"}]
[]
[]
[]
[{"$f":"IF(Path=2,\"Total Building Performance - No lighting calcs required\",IF(RenAltAdd=1,\"Maximum Allowed Lighting Wattage\",IF(Method=3,\"Specify Compliance Method on LGT-SUM\",IF(Method=2,\"Maximum Allowed Lighting Wattage\",\"Building Area Method selected. Use LTG-INT-BLD form.\"))))","v":"Building Area Method selected. Use LTG-INT-BLD form."}]
["Location (plan #,\n room #)","Space Type*","Allowed\nWatts per ft2","Gross Interior \nArea in ft2","Watts Allowed\n(watts/ft2 x area)"]
[null,null,{"$f":"IF(B10=\"\",0,VLOOKUP(B10,$D$93:$E$181,2,FALSE))","v":0},null,{"$f":"IF(RenAltAdd=1,0,C10*D10)","v":0}]
[null,null,{"$f":"IF(B11=\"\",0,VLOOKUP(B11,$D$93:$E$181,2,FALSE))","v":0},null,{"$f":"IF(RenAltAdd=1,0,C11*D11)","v":0}]
[null,null,{"$f":"IF(B12=\"\",0,VLOOKUP(B12,$D$93:$E$181,2,FALSE))","v":0},null,{"$f":"IF(RenAltAdd=1,0,C12*D12)","v":0}]
[null,null,{"$f":"IF(B13=\"\",0,VLOOKUP(B13,$D$93:$E$181,2,FALSE))","v":0},null,{"$f":"IF(RenAltAdd=1,0,C13*D13)","v":0}]
[null,null,{"$f":"IF(ISNUMBER(B14),MIN(B14,40)*0.03+MAX(B14-40,0)*0.02,0)","v":0},null,{"$f":"IF(RenAltAdd=1,0,C14*D14)","v":0}]
[null,null,null,null,{"$f":"IF(RenAltAdd=1,B15,0)","v":0}]
[null," Retail Display Allowance from LTG-INT-DISPLAY",null,null,{"$f":"IF(RenAltAdd=1,0,MIN('LTG-INT-DISPLAY'!F19,'LTG-INT-DISPLAY'!F37))","v":0}]
[null,null,null,"Area","Allowed Watts"]
[null,null,"Total",{"$f":"SUM(D10:D14)","v":0},{"$f":"SUM(E10:E16)","v":0}]
[]
[{"$f":"IF(ISNA(RetailAllowance),\"ERROR: Information on LTG-INT-DISPLAY is incomplete\",IF(RetailAllowance>0,IF(RetailAreas=0,\"ERROR: Retail Display Allowance only allowed when Sales area defined\",IF(RetailAreaSF<'LTG-INT-DISPLAY'!E16,\"ERROR: Retail display area must not be larger than Retail Sales area\",\"\")),\"\"))","v":""}]
[{"$f":"IF(Path=2,\"Total Building Performance - No lighting calcs required\",IF(RenAltAdd=1,\"Proposed Lighting Wattage\",IF(Method=3,\"Specify Compliance Method on LGT-SUM\",IF(Method=2,\"Proposed Lighting Wattage\",\"Building Area Method selected. Use LTG-INT-BLD form.\"))))","v":"Building Area Method selected. Use LTG-INT-BLD form."}]
["Location (plan #,\n room #)","Fixture Description***","Number of \nFixtures","Watts/\nFixture","Watts \nProposed"]
[null,null,null,null,{"$f":"C23*D23","v":0}]
[null,null,null,null,{"$f":"C24*D24","v":0}]
[null,null,null,null,{"$f":"C25*D25","v":0}]
[null,null,null,null,{"$f":"C26*D26","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,"Retail Display Lighting from LTG-INT-DISPLAY",null,null,{"$f":"'LTG-INT-DISPLAY'!F37","v":0}]
[null,null,null,"Total Proposed Watts",{"$f":"SUM(E23:E33)","v":0}]
[]
[]
[]
[]
[]
["Interior Lighting Power Allowance",null,null,null,{"$f":"IF(Method=2,IF(D18=0,\"\",IF(A20=\"\",IF(ROUND(E34,0)>ROUND(E18,0),\"DOES NOT COMPLY\",\"COMPLIES\"),\"RETAIL DISPLAY ALLOWANCE CALCULATION ERROR\")), IF(E34>0,\"Building Area Method Selected. Use LTG-INT-BLD.\",\"\"))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"retail sales Zones"]
[null,null,null,"Count","Area"]
[null,null,null,{"$f":"COUNTIF(B10:B14,\"*Sales area\")","v":0},{"$f":"SUMIF(B10:B14,\"*Sales area\",D10:D14)","v":0}]
[]
[]
[null,null,null,"Space-by-Space areas"]
[null,null,null,"Audience/seating area: auditorium",0.79]
[null,null,null,"Audience/seating area: performing arts theater",2.4300000000000002]
[null,null,null,"Audience/seating area: motion picture theater",1.1399999999999999]
[null,null,null,"Classroom/lecture/training",1.24]
[null,null,null,"Conference/meeting/multipurpose",1.23]
[null,null,null,"Corridor/transition",0.66]
[null,null,null,"Dining area: Bar/lounge/leisure dining",1.31]
[null,null,null,"Dining area: Family dining area",0.89]
[null,null,null,"Dressing/fitting room performing arts theater",0.4]
[null,null,null,"Electrical/mechanical",0.95]
[null,null,null,"Food preparation",0.99]
[null,null,null,"Laboratory for classrooms",1.28]
[null,null,null,"Laboratory for medical/industrial/research",1.81]
[null,null,null,"Lobby",0.9]
[null,null,null,"Lobby for performing arts theater",2]
[null,null,null,"Lobby for motion picture theater",0.52]
[null,null,null,"Locker room",0.75]
[null,null,null,"Lounge recreation",0.73]
[null,null,null,"Office - Enclosed",1.1100000000000001]
[null,null,null,"Office - Open plan",0.98]
[null,null,null,"Restroom",0.98]
[null,null,null,"Sales area",1.68]
[null,null,null,"Stairway",0.69]
[null,null,null,"Storage",0.63]
[null,null,null,"Workshop",1.59]
[null,null,null,"Automotive ‑ Service/repair",0.67]
[null,null,null,"Bank/office ‑ Banking activity area",1.38]
[null,null,null,"Convention center: Exhibit space",1.45]
[null,null,null,"Convention center: Audience/seating area",0.82]
[null,null,null,"Court/police station/penitentiary: Courtroom",1.72]
[null,null,null,"Court/police station/penitentiary: Confinement cells",1.1000000000000001]
[null,null,null,"Court/police station/penitentiary: Judge chambers",1.17]
[null,null,null,"Court/police/penitentiary: Penitentiary audience seating",0.43]
[null,null,null,"Court/police/penitentiary: Penitentiary classroom",1.34]
[null,null,null,"Court/police/penitentiary: Penitentiary dining",1.07]
[null,null,null,"Dormitory living quarters",0.38]
[null,null,null,"Fire stations: Engine rooms",0.56000000000000005]
[null,null,null,"Fire stations: Sleeping quarters",0.25]
[null,null,null,"Gymnasium/fitness center: Fitness area",0.72]
[null,null,null,"Gymnasium/fitness center: Gymnasium audience/seating",0.43]
[null,null,null,"Gymnasium/fitness center: Playing area",1.2]
[null,null,null,"Health care clinic/hospital: Corridors/transition",0.89]
[null,null,null,"Health care clinic/hospital: Emergency",2.2599999999999998]
[null,null,null,"Health care clinic/hospital: Exam/treatment",1.66]
[null,null,null,"Health care clinic/hospital: Medical supplies",1.27]
[null,null,null,"Health care clinic/hospital: Nursery",0.88]
[null,null,null,"Health care clinic/hospital: Nurse station",0.87]
[null,null,null,"Health care clinic/hospital: Operating room",1.89]
[null,null,null,"Health care clinic/hospital: Patient room",0.62]
[null,null,null,"Health care clinic/hospital: Pharmacy",1.1399999999999999]
[null,null,null,"Health care clinic/hospital: Physical therapy",0.91]
[null,null,null,"Health care clinic/hospital: Radiology/imaging",1.32]
[null,null,null,"Health care clinic/hospital: Recovery",1.1499999999999999]
[null,null,null,"Hotel: Dining area",0.82]
[null,null,null,"Hotel: Guest rooms",1.1100000000000001]
[null,null,null,"Hotel: Hotel lobby",1.06]
[null,null,null,"Hotel: Highway lodging dining",0.88]
[null,null,null,"Hotel: Highway lodging guest rooms",0.75]
[null,null,null,"Library: Card file and cataloguing",0.72]
[null,null,null,"Library: Reading area",0.93]
[null,null,null,"Library: Stacks",1.71]
[null,null,null,"Manufacturing: Corridors/transition",0.41]
[null,null,null,"Manufacturing: Detailed manufacturing",1.29]
[null,null,null,"Manufacturing: Equipment room",0.95]
[null,null,null,"Manufacturing: Extra high bay (> 50 ft floor-ceiling ht.)",1.05]
[null,null,null,"Manufacturing: High bay (25 ‑ 50 ft floor-ceiling ht.)",1.23]
[null,null,null,"Manufacturing: Low bay (< 25 ft floor-ceiling ht.)",1.19]
[null,null,null,"Museum: General exhibition",1.05]
[null,null,null,"Museum: Restoration",1.02]
[null,null,null,"Parking garage ‑ Garage areas",0.19]
[null,null,null,"Post office: Sorting area",0.94]
[null,null,null,"Religious building: Audience seating",1.53]
[null,null,null,"Religious building: Fellowship hall",0.64]
[null,null,null,"Religious building: Worship pulpit/choir",1.53]
[null,null,null,"Retail: Dressing/fitting area",0.87]
[null,null,null,"Retail: Mall concourse",1.1000000000000001]
[null,null,null,"Retail: Sales area",1.68]
[null,null,null,"Sports arena: Audience seating",0.43]
[null,null,null,"Sports arena: Court sports area ‑ Class 4",0.72]
[null,null,null,"Sports arena: Court sports area ‑ Class 3",1.2]
[null,null,null,"Sports arena: Court sports area ‑ Class 2",1.92]
[null,null,null,"Sports arena: Court sports area ‑ Class 1",3.01]
[null,null,null,"Sports arena: Ring sports area",2.68]
[null,null,null,"Transportation: Air/train/bus baggage area",0.76]
[null,null,null,"Transportation: Airport concourse",0.36]
[null,null,null,"Transportation: Audience seating",0.54]
[null,null,null,"Transportation: Terminal ‑ Ticket counter",1.08]
[null,null,null,"Warehouse: Fine material storage",0.95]
[null,null,null,"Warehouse: Medium/bulky material",0.57999999999999996]

{"sheet":"LTG-INT-DISPLAY","index":4,"n_rows":112,"n_cols":11,"rows_kept":112,"cut":false,"hidden":false,"merged":[[8,1,8,2],[43,9,45,9],[20,0,20,5],[13,1,13,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2]]}
["Interior Display Lighting - Space-by-Space ",null,null,null,null,"LTG-INT-DISPLAY"]
[{"$f":"'LTG-SUM'!A2","v":"2012 Washington State Energy Code Compliance Forms for Commercial Buildings including R2 & R3 over 3 stories and all R1 "},null,null,null,null,{"$f":"'LTG-SUM'!G2","v":"Revised Jan 2014"}]
[{"$f":"'LTG-SUM'!A3","v":"Project Info"},{"$f":"'LTG-SUM'!B3","v":"Project Address"},{"$f":"IF('LTG-SUM'!C3=\"1 - This address line will copy onto other forms\",\"Fill this line out on LGT-SUM\",'LTG-SUM'!C3)","v":"Baxter Mini-Storage Bldg."},null,{"$f":"'LTG-SUM'!F3","v":"Date"},{"$f":"'LTG-SUM'!G3","v":"2015-09-07"}]
[null,{"$f":"'LTG-SUM'!B4","v":0},{"$f":"IF('LTG-SUM'!C4=\"2 - This address line will copy onto other forms\",\"Fill this line out on LGT-SUM\",'LTG-SUM'!C4)","v":"3019 Ocean Beach Rd. Pacific Beach WA 98571"},null,{"$f":"'LTG-SUM'!F4","v":"For Building Department Use"}]
[null,{"$f":"'LTG-SUM'!B5","v":0},{"$f":"IF('LTG-SUM'!C5=\"3 - This address line will copy onto other forms\",\"Fill this line out on LGT-SUM\",'LTG-SUM'!C5)","v":0}]
[null,{"$f":"'LTG-SUM'!B6","v":"Applicant Name:"},{"$f":"IF('LTG-SUM'!C6=\"4 - This address line will copy onto other forms\",\"Fill this line out on LGT-SUM\",'LTG-SUM'!C6)","v":"Mark Baxter"}]
[]
[{"$f":"IF(Path=2,\"Total Building Performance - No lighting calcs required\",IF(Method=3,\"Specify Compliance Method on LGT-SUM\",IF(Method=2,\"Maximum Allowed Display Lighting Wattage\",\"Building Area Method selected. Use LTG-INT-BLD form.\")))","v":"Building Area Method selected. Use LTG-INT-BLD form."}]
["Location (plan #,\n room #)","Retail Display Area Type*",null,"Allowed\nWatts per ft2 **","Gross Interior \nArea in ft2","Watts Allowed\n(watts/ft2 x area)"]
[null,null,null,{"$f":"IF(B10=\"\",0,VLOOKUP(B10,$E$100:$F$103,2,FALSE))","v":0},null,{"$f":"IF(B10=\"\",\"\",IF(ISNA(IF(VLOOKUP(VLOOKUP(B10,$E$100:$G$103,3,FALSE),$A$23:$F$36,6,0)>0,\"\",NA())),\"No display\",D10*E10))","v":""},{"$f":"IF(ISNA(INDEX(B$10:B$15,MATCH(0,COUNTIF(G$9:$G9,B$10:B$15),0))),\"\",INDEX(B$10:B$15,MATCH(0,COUNTIF(G$9:$G9,B$10:B$15),0)))","v":0}]
[null,null,null,{"$f":"IF(B11=\"\",0,VLOOKUP(B11,$E$100:$F$103,2,FALSE))","v":0},null,{"$f":"IF(B11=\"\",\"\",IF(ISNA(IF(VLOOKUP(VLOOKUP(B11,$E$100:$G$103,3,FALSE),$A$23:$F$36,6,0)>0,\"\",NA())),\"No display\",D11*E11))","v":""},{"$f":"IF(ISNA(INDEX(B$10:B$15,MATCH(0,COUNTIF(G$9:$G10,B$10:B$15),0))),\"\",INDEX(B$10:B$15,MATCH(0,COUNTIF(G$9:$G10,B$10:B$15),0)))","v":""},{"$f":"IF(ISNA(INDEX(G$10:G$15,MATCH(0,COUNTIF(H$9:$H10,G$10:G$15),0))),\"\",INDEX(G$10:G$15,MATCH(0,COUNTIF(H$9:$H10,G$10:G$15),0)))","v":0}]
[null,null,null,{"$f":"IF(B12=\"\",0,VLOOKUP(B12,$E$100:$F$103,2,FALSE))","v":0},null,{"$f":"IF(B12=\"\",\"\",IF(ISNA(IF(VLOOKUP(VLOOKUP(B12,$E$100:$G$103,3,FALSE),$A$23:$F$36,6,0)>0,\"\",NA())),\"No display\",D12*E12))","v":""},{"$f":"IF(ISNA(INDEX(B$10:B$15,MATCH(0,COUNTIF(G$9:$G11,B$10:B$15),0))),\"\",INDEX(B$10:B$15,MATCH(0,COUNTIF(G$9:$G11,B$10:B$15),0)))","v":""},{"$f":"IF(ISNA(INDEX(G$10:G$15,MATCH(0,COUNTIF(H$9:$H11,G$10:G$15),0))),\"\",INDEX(G$10:G$15,MATCH(0,COUNTIF(H$9:$H11,G$10:G$15),0)))","v":""}]
[null,null,null,{"$f":"IF(B13=\"\",0,VLOOKUP(B13,$E$100:$F$103,2,FALSE))","v":0},null,{"$f":"IF(B13=\"\",\"\",IF(ISNA(IF(VLOOKUP(VLOOKUP(B13,$E$100:$G$103,3,FALSE),$A$23:$F$36,6,0)>0,\"\",NA())),\"No display\",D13*E13))","v":""},{"$f":"IF(ISNA(INDEX(B$10:B$15,MATCH(0,COUNTIF(G$9:$G12,B$10:B$15),0))),\"\",INDEX(B$10:B$15,MATCH(0,COUNTIF(G$9:$G12,B$10:B$15),0)))","v":""},{"$f":"IF(ISNA(INDEX(G$10:G$15,MATCH(0,COUNTIF(H$9:$H12,G$10:G$15),0))),\"\",INDEX(G$10:G$15,MATCH(0,COUNTIF(H$9:$H12,G$10:G$15),0)))","v":""}]
[null,null,null,{"$f":"IF(B14=\"\",0,VLOOKUP(B14,$E$100:$F$103,2,FALSE))","v":0},null,{"$f":"IF(B14=\"\",\"\",IF(ISNA(IF(VLOOKUP(VLOOKUP(B14,$E$100:$G$103,3,FALSE),$A$23:$F$36,6,0)>0,\"\",NA())),\"No display\",D14*E14))","v":""},{"$f":"IF(ISNA(INDEX(B$10:B$15,MATCH(0,COUNTIF(G$9:$G13,B$10:B$15),0))),\"\",INDEX(B$10:B$15,MATCH(0,COUNTIF(G$9:$G13,B$10:B$15),0)))","v":""},{"$f":"IF(ISNA(INDEX(G$10:G$15,MATCH(0,COUNTIF(H$9:$H13,G$10:G$15),0))),\"\",INDEX(G$10:G$15,MATCH(0,COUNTIF(H$9:$H13,G$10:G$15),0)))","v":""},null,1]
[null,null,null,null,"Area","Area Watts"]
[null,null,null,"Total",{"$f":"SUM(E10:E15)","v":0},{"$f":"IF(SUM(F10:F15)>0,SUM(F10:F15),0)","v":0}]
[]
[null,null,null,null,"Display Lighting Base Allowance",{"$f":"IF(SUM(F10:F15)>0,500,0)","v":0}]
[null,null,{"$f":"IF(OR(Method=2,RenAltAdd=1),IF(AND(F19>0,F19<F37),\"DISPLAY WATTAGE ALLOWED - AS CALCULATED BY AREA\",\"\"),\"\")","v":""},null,"++ Total Display Allowance",{"$f":"IF(E16=0,0,F16+F18)","v":0}]
[{"$f":"IF(Path=2,\"Total Building Performance - No lighting calcs required\",IF(Method=3,\"Specify Compliance Method on LGT-SUM\",IF(Method=2,\"Proposed Display Lighting Wattage\",\"Building Area Method selected. Use LTG-INT-BLD form\")))","v":"Building Area Method selected. Use LTG-INT-BLD form"}]
["Only separately controlled display fixtures independent of general area lighting per Table C405.5.2(2) footnote A may be entered here."]
["Display Area*","Location (plan #,\n room #)","Fixture Description","Number of \nFixtures","Watts/\nFixture","Watts \nProposed"]
[null,null,null,null,null,{"$f":"IF(AND(A23=\"\",D23=0,E23=0),0,IF(ISNA(IF(VLOOKUP(VLOOKUP($A23,$D$100:$E$103,2,FALSE),$B$10:$F$15,4,FALSE)>0,\"\",NA())),\"Not Defined\",D23*E23))","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,1]
[null,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,1]
[]
[null,null,{"$f":"IF(OR(Method=2,RenAltAdd=1),IF(AND(F37>0,F37<=F19),\"DISPLAY WATTAGE ALLOWED - AS PROPOSED\",\"\"),\"\")","v":""},null,"Total Proposed Watts",{"$f":"IF(COUNTIF(F23:F35,\"Not Defined\")>0,NA(),SUM(F23:F36))","v":0}]
[]
[null,null,"Retail 1","Retail 2","Retail 3","Retail 4"]
[null,null,{"$f":"SUMIF($A23:$A36,\"Retail 1\",$F23:$F36)","v":0},{"$f":"SUMIF($A23:$A36,\"Retail 2\",$F23:$F36)","v":0},{"$f":"SUMIF($A23:$A36,\"Retail 3\",$F23:$F36)","v":0},{"$f":"SUMIF($A23:$A36,\"Retail 4\",$F23:$F36)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Space-by-Space areas"]
[null,null,null,"Retail 1","Retail 1: All unclassified retail display",0.6,{"$f":"D100","v":"Retail 1"}]
[null,null,null,"Retail 2","Retail 2: Vehicles, sporting goods and small electronics",0.6,{"$f":"D101","v":"Retail 2"}]
[null,null,null,"Retail 3","Retail 3: Furniture, clothing, cosmetics, artwork",1.4,{"$f":"D102","v":"Retail 3"}]
[null,null,null,"Retail 4","Retail 4: Jewelry, crystal, china",2.5,{"$f":"D103","v":"Retail 4"}]
[]
[null,null,null,"Used"]
[null,null,null,{"$f":"IF(LEN(G10)>1,VLOOKUP(G10,$E$100:$G$103,3,0),\"\")","v":""}]
[null,null,null,{"$f":"IF(LEN(G11)>1,VLOOKUP(G11,$E$100:$G$103,3,0),\"\")","v":""}]
[null,null,null,{"$f":"IF(LEN(G12)>1,VLOOKUP(G12,$E$100:$G$103,3,0),\"\")","v":""}]
[null,null,null,{"$f":"IF(LEN(G13)>1,VLOOKUP(G13,$E$100:$G$103,3,0),\"\")","v":""}]
[null,null,null,{"$f":"IF(LEN(G14)>1,VLOOKUP(G14,$E$100:$G$103,3,0),\"\")","v":""}]
[null,null,null,{"$f":"IF(LEN(#REF!)>1,VLOOKUP(#REF!,$E$100:$G$103,3,0),\"\")","v":{"$error":"#REF!"}}]
[null,null,null,{"$f":"IF(LEN(G15)>1,VLOOKUP(G15,$E$100:$G$103,3,0),\"\")","v":""}]

{"sheet":"LTG-INT-BLD","index":5,"n_rows":116,"n_cols":10,"rows_kept":116,"cut":false,"hidden":false,"merged":[[34,1,34,2],[16,2,16,5],[35,1,35,2],[36,1,36,2],[3,0,3,3],[4,0,4,3],[5,0,5,3],[32,1,32,2],[33,1,33,2]]}
["Interior Lighting Summary - Building Area Method",null,null,null,null,"LTG-INT-BLD"]
[{"$f":"'LTG-SUM'!A2","v":"2012 Washington State Energy Code Compliance Forms for Commercial Buildings including R2 & R3 over 3 stories and all R1 "},null,null,null,null,{"$f":"'LTG-SUM'!G2","v":"Revised Jan 2014"}]
[{"$f":"'LTG-SUM'!B3","v":"Project Address"},{"$f":"IF('LTG-SUM'!C3=\"1 - This address line will copy onto other forms\",\"Fill this line out on LGT-SUM\",'LTG-SUM'!C3)","v":"Baxter Mini-Storage Bldg."},null,null,{"$f":"'LTG-SUM'!F3","v":"Date"},{"$f":"'LTG-SUM'!G3","v":"2015-09-07"}]
["Lighting Alterations, Renovations & Building Additions",null,null,null,{"$f":"'LTG-SUM'!F4","v":"For Building Department Use"}]
[]
[]
[]
[{"$f":"IF(Path=2,\"Total Building Performance - No lighting calcs required\",IF(RenAltAdd=1,\"Use LTG-INT-SPACE form for less than 60% lighting retrofit.\",IF(Method=3,\"Specify Compliance Method on LGT-SUM\",IF(Method=1,\"Maximum Allowed Lighting Wattage\",\"Space-By-Space method selected. Use LTG-INT-SPACE form.\"))))","v":"Maximum Allowed Lighting Wattage"}]
["Building Area*","Location (plan #,\n room #, or ALL)","Area Description","Allowed\nWatts per ft2","Gross Interior \nArea in ft2","Watts Allowed\n(watts/ft2 x area)"]
["Warehouse","Addendum","Storage units",{"$f":"IF(A10=\"\",0,VLOOKUP(A10,$A$84:$B$116,2,FALSE))","v":0.5},3585,{"$f":"IF(AND(A10=\"\",D10=0,E10=0),0,IF(ISNA(IF(VLOOKUP(A10,$A$20:$F$31,6,FALSE)>0,\"\",NA())),\"Unlit\",D10*E10))","v":1792.5},{"$f":"IF(ISNA(INDEX(A$10:A$15,MATCH(0,COUNTIF(G$9:$G9,A$10:A$15),0))),\"\",INDEX(A$10:A$15,MATCH(0,COUNTIF(G$9:$G9,A$10:A$15),0)))","v":"Warehouse"}]
[null,null,null,{"$f":"IF(A11=\"\",0,VLOOKUP(A11,$A$84:$B$116,2,FALSE))","v":0},null,{"$f":"IF(AND(A11=\"\",D11=0,E11=0),0,IF(ISNA(IF(VLOOKUP(A11,$A$20:$F$31,6,FALSE)>0,\"\",NA())),\"Unlit\",D11*E11))","v":0},{"$f":"IF(ISNA(INDEX(A$10:A$15,MATCH(0,COUNTIF(G$9:$G10,A$10:A$15),0))),\"\",INDEX(A$10:A$15,MATCH(0,COUNTIF(G$9:$G10,A$10:A$15),0)))","v":0}]
[null,null,null,{"$f":"IF(A12=\"\",0,VLOOKUP(A12,$A$84:$B$116,2,FALSE))","v":0},null,{"$f":"IF(AND(A12=\"\",D12=0,E12=0),0,IF(ISNA(IF(VLOOKUP(A12,$A$20:$F$31,6,FALSE)>0,\"\",NA())),\"Unlit\",D12*E12))","v":0},{"$f":"IF(ISNA(INDEX(A$10:A$15,MATCH(0,COUNTIF(G$9:$G11,A$10:A$15),0))),\"\",INDEX(A$10:A$15,MATCH(0,COUNTIF(G$9:$G11,A$10:A$15),0)))","v":""}]
[null,null,null,{"$f":"IF(A13=\"\",0,VLOOKUP(A13,$A$84:$B$116,2,FALSE))","v":0},null,{"$f":"IF(AND(A13=\"\",D13=0,E13=0),0,IF(ISNA(IF(VLOOKUP(A13,$A$20:$F$31,6,FALSE)>0,\"\",NA())),\"Unlit\",D13*E13))","v":0},{"$f":"IF(ISNA(INDEX(A$10:A$15,MATCH(0,COUNTIF(G$9:$G12,A$10:A$15),0))),\"\",INDEX(A$10:A$15,MATCH(0,COUNTIF(G$9:$G12,A$10:A$15),0)))","v":""}]
[null,null,null,{"$f":"IF(A14=\"\",0,VLOOKUP(A14,$A$84:$B$116,2,FALSE))","v":0},null,{"$f":"IF(AND(A14=\"\",D14=0,E14=0),0,IF(ISNA(IF(VLOOKUP(A14,$A$20:$F$31,6,FALSE)>0,\"\",NA())),\"Unlit\",D14*E14))","v":0},{"$f":"IF(ISNA(INDEX(A$10:A$15,MATCH(0,COUNTIF(G$9:$G13,A$10:A$15),0))),\"\",INDEX(A$10:A$15,MATCH(0,COUNTIF(G$9:$G13,A$10:A$15),0)))","v":""},null,null,1]
[null,null,null,null,null,null,null,null,null,1]
[null,null,null,"Total",{"$f":"SUM(E10:E15)","v":3585},null,{"$f":"COUNTIF(G10:G15,\"=\" & \" \")","v":0}]
[]
[{"$f":"IF(Path=2,\"Total Building Performance - No lighting calcs required\",IF(RenAltAdd=1,\"Use LTG-INT-SPACE form for less than 60% lighting retrofit.\",IF(Method=3,\"Specify Compliance Method on LGT-SUM\",IF(Method=1,\"Proposed Lighting Wattage\",\"Space-By-Space method selected. Use LTG-INT-SPACE form.\"))))","v":"Proposed Lighting Wattage"}]
["Building Area*","Location (plan #,\n room #)","Fixture Description**","Number of \nFixtures","Watts/\nFixture","Watts \nProposed"]
["Warehouse","Addendum","1 Lamp, CFL 14 W",22,14,{"$f":"IF(AND(A20=\"\",D20=0,E20=0),0,IF(ISNA(IF(VLOOKUP(A20,$A$10:$F$15,5,FALSE)>0,\"\",NA())),\"Not Defined\",D20*E20))","v":308}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"COUNTIFS(F20:F31,\"Not Defined\",A20:A31,\"\")","v":0}]
["Compliance by Building Area",null,null,null,null,null,{"$f":"COUNTIF(F20:F31,\">0\")","v":1}]
["Building Area","Warnings ",null,"Total Allowed Watts","Total Proposed Watts","Interior Lighting Power Allowance",{"$f":"UniqueAreas","v":1},null,{"$f":"IF(M16=G34-1,runtest(),\"\")","v":""}]
[{"$f":"IF('LTG-INT-REF'!H12=0,\"\",'LTG-INT-REF'!H12)","v":"Warehouse"},{"$f":"IF(AND(A34<>\"\",'LTG-INT-REF'!M12>0),\"Building Area information is incomplete\",IF('LTG-INT-REF'!O12=1,\"Confirm all fixtures are reported under proposed lighting - low watts relative to maximum allowed.\",IF('LTG-INT-REF'!L12=0,\"\",\"Exceeds maximum allowed wattage for this building area\")))","v":"Confirm all fixtures are reported under proposed lighting - low watts relative to maximum allowed."},null,{"$f":"IF(A34=\"\",\"\",SUMIF(AreasInBld,A34,$F$10:$F$15))","v":1792.5},{"$f":"IF('LTG-INT-REF'!H12=0,\"\",'LTG-INT-REF'!J12)","v":308},{"$f":"IF(A34<>\"\",IF('LTG-INT-REF'!N12=0,IF(OR('LTG-INT-REF'!L12=1,'LTG-INT-REF'!M12=1),\"DOES NOT COMPLY\",\"COMPLIES\"),\"UNLIT\"),\"\")","v":"COMPLIES"},{"$f":"ROWS(IntBldCompTablePlus1)","v":5}]
[{"$f":"IF('LTG-INT-REF'!H13=0,\"\",'LTG-INT-REF'!H13)","v":""},{"$f":"IF(AND(A35<>\"\",'LTG-INT-REF'!M13>0),\"Building Area information is incomplete\",IF('LTG-INT-REF'!O13=1,\"Confirm all fixtures are reported under proposed lighting - low watts relative to maximum allowed.\",IF('LTG-INT-REF'!L13=0,\"\",\"Exceeds maximum allowed wattage for this building area\")))","v":""},null,{"$f":"IF(A35=\"\",\"\",SUMIF(AreasInBld,A35,$F$10:$F$15))","v":""},{"$f":"IF('LTG-INT-REF'!H13=0,\"\",'LTG-INT-REF'!J13)","v":""},{"$f":"IF(A35<>\"\",IF('LTG-INT-REF'!N13=0,IF(OR('LTG-INT-REF'!L13=1,'LTG-INT-REF'!M13=1),\"DOES NOT COMPLY\",\"COMPLIES\"),\"UNLIT\"),\"\")","v":""}]
[{"$f":"IF('LTG-INT-REF'!H14=0,\"\",'LTG-INT-REF'!H14)","v":""},{"$f":"IF(AND(A36<>\"\",'LTG-INT-REF'!M14>0),\"Building Area information is incomplete\",IF('LTG-INT-REF'!O14=1,\"Confirm all fixtures are reported under proposed lighting - low watts relative to maximum allowed.\",IF('LTG-INT-REF'!L14=0,\"\",\"Exceeds maximum allowed wattage for this building area\")))","v":""},null,{"$f":"IF(A36=\"\",\"\",SUMIF(AreasInBld,A36,$F$10:$F$15))","v":""},{"$f":"IF('LTG-INT-REF'!H14=0,\"\",'LTG-INT-REF'!J14)","v":""},{"$f":"IF(A36<>\"\",IF('LTG-INT-REF'!N14=0,IF(OR('LTG-INT-REF'!L14=1,'LTG-INT-REF'!M14=1),\"DOES NOT COMPLY\",\"COMPLIES\"),\"UNLIT\"),\"\")","v":""}]
[{"$f":"IF('LTG-INT-REF'!H15=0,\"\",'LTG-INT-REF'!H15)","v":""},{"$f":"IF(AND(A37<>\"\",'LTG-INT-REF'!M15>0),\"Building Area information is incomplete\",IF('LTG-INT-REF'!O15=1,\"Confirm all fixtures are reported under proposed lighting - low watts relative to maximum allowed.\",IF('LTG-INT-REF'!L15=0,\"\",\"Exceeds maximum allowed wattage for this building area\")))","v":""},null,{"$f":"IF(A37=\"\",\"\",SUMIF(AreasInBld,A37,$F$10:$F$15))","v":""},{"$f":"IF('LTG-INT-REF'!H15=0,\"\",'LTG-INT-REF'!J15)","v":""},{"$f":"IF(A37<>\"\",IF('LTG-INT-REF'!N15=0,IF(OR('LTG-INT-REF'!L15=1,'LTG-INT-REF'!M15=1),\"DOES NOT COMPLY\",\"COMPLIES\"),\"UNLIT\"),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(AND(G31>0,G32>0),\"ERROR - Unassigned Proposed Fixture\",\"\")","v":""},null,null,0]
[null,null,"Total",{"$f":"SUM(D34:D38)","v":1792.5},{"$f":"SUM(E34:E38)","v":308}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Building Areas"]
[{"$f":"'LTG-INT-REF'!A15","v":"Automotive facility"},0.82,null,null,{"$f":"A84","v":"Automotive facility"}]
[{"$f":"'LTG-INT-REF'!A16","v":"Convention center"},1.08,null,null,{"$f":"A85","v":"Convention center"}]
[{"$f":"'LTG-INT-REF'!A17","v":"Court house"},1.05]
[{"$f":"'LTG-INT-REF'!A18","v":"Dining:  Bar lounge/leisure"},0.99]
[{"$f":"'LTG-INT-REF'!A19","v":"Dining:  Cafeteria/fast food"},0.9]
[{"$f":"'LTG-INT-REF'!A20","v":"Dining:  Family"},0.89]
[{"$f":"'LTG-INT-REF'!A21","v":"Dormitory"},0.61]
[{"$f":"'LTG-INT-REF'!A22","v":"Exercise center"},0.88]
[{"$f":"'LTG-INT-REF'!A23","v":"Fire station"},0.71]
[{"$f":"'LTG-INT-REF'!A24","v":"Gymnasium"},0.95]
[{"$f":"'LTG-INT-REF'!A25","v":"Health care clinic"},0.87]
[{"$f":"'LTG-INT-REF'!A26","v":"Hospital"},1.2]
[{"$f":"'LTG-INT-REF'!A27","v":"Hotel"},1]
[{"$f":"'LTG-INT-REF'!A28","v":"Library"},1.18]
[{"$f":"'LTG-INT-REF'!A29","v":"Manufacturing facility"},1.1100000000000001]
[{"$f":"'LTG-INT-REF'!A30","v":"Motel"},0.88]
[{"$f":"'LTG-INT-REF'!A31","v":"Motion picture theater"},0.83]
[{"$f":"'LTG-INT-REF'!A32","v":"Multifamily"},0.6]
[{"$f":"'LTG-INT-REF'!A33","v":"Museum"},1]
[{"$f":"'LTG-INT-REF'!A34","v":"Office"},0.9]
[{"$f":"'LTG-INT-REF'!A35","v":"Parking garage"},0.2]
[{"$f":"'LTG-INT-REF'!A36","v":"Penitentiary"},0.9]
[{"$f":"'LTG-INT-REF'!A37","v":"Performing arts theater"},1.25]
[{"$f":"'LTG-INT-REF'!A38","v":"Police station"},0.9]
[{"$f":"'LTG-INT-REF'!A39","v":"Post office"},0.87]
[{"$f":"'LTG-INT-REF'!A40","v":"Religious building"},1.05]
[{"$f":"'LTG-INT-REF'!A41","v":"Retail"},1.33]
[{"$f":"'LTG-INT-REF'!A42","v":"School/university"},0.99]
[{"$f":"'LTG-INT-REF'!A43","v":"Sports arena"},0.78]
[{"$f":"'LTG-INT-REF'!A44","v":"Town hall"},0.92]
[{"$f":"'LTG-INT-REF'!A45","v":"Transportation"},0.77]
[{"$f":"'LTG-INT-REF'!A46","v":"Warehouse"},0.5]
[{"$f":"'LTG-INT-REF'!A47","v":"Workshop"},1.2]

{"sheet":"LTG-INT-REF","index":6,"n_rows":81,"n_cols":17,"rows_kept":81,"cut":false,"hidden":true,"merged":[[9,8,9,11]]}
["Renovation path"]
[5]
["Path"]
[1,"(1=lighting power, 2=Total Building Performance, 3=not specified",null,null,null,null,null,null,null,{"$f":"SUMPRODUCT('LTG-INT-BLD'!D20:D30,'LTG-INT-BLD'!E20:E30)","v":308},"watts entered"]
["Method",null,null,null,null,null,null,null,null,{"$f":"SUM(J12:J32)","v":308},"watts in allowed catagories"]
[1,"(1=building area, 2=space-by-space, 3=not specified",null,null,null,null,null,"Number of Unique Areas"]
["Pass",null,null,null,null,null,null,{"$f":"21-COUNTIF(G12:G32,NA())","v":1}]
[{"$f":"IF(Method=1,SUM(L12:L32)=0,TRUE)","v":true},{"$f":"IF(A8=FALSE,MID(E8,1,LEN(E8)-2),IF(SUM(J12:J47)>0,IF(Method=1,IF(J4=J5,\"ALL AREAS COMPLY\",\"PROPOSED LIGHTING IN UNDEFINED SPACE TYPE\"),\"SPECIFY COMPLIANCE METHOD ON LGT-SUM\"),\"\"))","v":"ALL AREAS COMPLY"},null,null,{"$f":"IF(A8=FALSE,\"The following areas do not comply: \",\"\")","v":""},null,null,null,{"$f":"IF(J8=\"\",,IF(MID(J8,LEN(J8)-1,2)=\", \",MID(J8,1,LEN(J8)-2),J8))","v":0},{"$f":"IF(A8=FALSE,CONCATENATE(P12,P13,P14,P15,P16,P17,P18,P19,P20,P21,P22,P23,P24,P25,P26,P27,P28,P29,P30,P31,P32),\"\")","v":""}]
["Low LPD",null,null,null,null,null,null,"Specified Building Areas"]
[{"$f":"SUM(O12:O32)>0","v":true},{"$f":"IF(A10=TRUE,\"Areas with low LPD's.  Check that all proposed fixtures are entered:\",\"\")","v":"Areas with low LPD's.  Check that all proposed fixtures are entered:"},null,null,{"$f":"IF(A10=TRUE,CONCATENATE(Q12,Q13,Q14,Q15,Q16,Q17,Q18,Q19,Q20,Q21,Q22,Q23,Q24,Q25,Q26,Q27,Q28,Q29,Q30,Q31,Q32),\"\")","v":"Warehouse, "},null,null,null,"Watts",null,null,null,"Area"]
[null,{"$f":"IF(A10=TRUE,MID(E10,1,LEN(E10)-2),\"\")","v":"Warehouse"},null,null,null,null,null,null,"allowed","proposed","Over","Fail","Undefined","No lights","low LPD","watts error","lowLPD error"]
[null,null,null,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$11:$E11,AreasInBld),0))","v":"Warehouse"},{"$f":"IF(ISTEXT(E12),E12,\"\")","v":"Warehouse"},{"$f":"INDEX($F$12:$F$79,MATCH(0,COUNTIF(G$11:$G11,$F$12:$F$79),0))","v":"Warehouse"},{"$f":"IF(ISTEXT(G12),G12,0)","v":"Warehouse"},{"$f":"IF(H12=0,0,SUMIF('LTG-INT-BLD'!$A$10:$A$15,'LTG-INT-REF'!H12,'LTG-INT-BLD'!$F$10:$F$15))","v":1792.5},{"$f":"IF(H12=0,0,SUMIF('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H12,'LTG-INT-BLD'!$F$20:$F$31))","v":308},{"$f":"IF(J12>I12,J12-I12,\"\")","v":""},{"$f":"IF(I12<J12,1,0)","v":0},{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H12,'LTG-INT-BLD'!$F$20:$F$31,\"Not defined\")>0,1,0)","v":0},{"$f":"IF(AND(J12=0,M12=0),1,0)","v":0},{"$f":"IF(OR(H12=0,M12<>0),0,IF(OR(J12<I12*0.6,J12=0),1,0))","v":1},{"$f":"IF(L12=1,CONCATENATE(H12,\"-\",K12,\"W over, \"),\"\")","v":""},{"$f":"IF(O12=1,CONCATENATE(H12,\", \"),\"\")","v":"Warehouse, "}]
[null,"Allowance",null,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$11:$E12,AreasInBld),0))","v":0},{"$f":"IF(ISTEXT(E13),E13,\"\")","v":""},{"$f":"INDEX($F$12:$F$79,MATCH(0,COUNTIF(G$11:$G12,$F$12:$F$79),0))","v":{"$error":"#N/A"}},{"$f":"IF(ISTEXT(G13),G13,0)","v":0},{"$f":"IF(H13=0,0,SUMIF('LTG-INT-BLD'!$A$10:$A$15,'LTG-INT-REF'!H13,'LTG-INT-BLD'!$F$10:$F$15))","v":0},{"$f":"IF(H13=0,0,SUMIF('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H13,'LTG-INT-BLD'!$F$20:$F$31))","v":0},{"$f":"IF(J13>I13,J13-I13,\"\")","v":""},{"$f":"IF(I13<J13,1,0)","v":0},{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H13,'LTG-INT-BLD'!$F$20:$F$31,\"Not defined\")>0,1,0)","v":0},1,{"$f":"IF(OR(H13=0,M13<>0),0,IF(OR(J13<I13*0.6,J13=0),1,0))","v":0},"",""]
["Building Areas","text","W",null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$11:$E13,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$12:$F$79,MATCH(0,COUNTIF(G$11:$G13,$F$12:$F$79),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H14=0,0,SUMIF('LTG-INT-BLD'!$A$10:$A$15,'LTG-INT-REF'!H14,'LTG-INT-BLD'!$F$10:$F$15))","v":0},{"$f":"IF(H14=0,0,SUMIF('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H14,'LTG-INT-BLD'!$F$20:$F$31))","v":0},"",0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H14,'LTG-INT-BLD'!$F$20:$F$31,\"Not defined\")>0,1,0)","v":0},1,0,"",""]
["Automotive facility",{"$f":"CONCATENATE(TEXT(C15,\"0.0#\"),\" W/ft2\")","v":"0.82 W/ft2"},0.82,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$11:$E14,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$12:$F$79,MATCH(0,COUNTIF(G$11:$G14,$F$12:$F$79),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H15=0,0,SUMIF('LTG-INT-BLD'!$A$10:$A$15,'LTG-INT-REF'!H15,'LTG-INT-BLD'!$F$10:$F$15))","v":0},{"$f":"IF(H15=0,0,SUMIF('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H15,'LTG-INT-BLD'!$F$20:$F$31))","v":0},"",0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H15,'LTG-INT-BLD'!$F$20:$F$31,\"Not defined\")>0,1,0)","v":0},1,0,"",""]
["Convention center",{"$f":"CONCATENATE(TEXT(C16,\"0.0#\"),\" W/ft2\")","v":"1.08 W/ft2"},1.08,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$11:$E15,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$12:$F$79,MATCH(0,COUNTIF(G$11:$G15,$F$12:$F$79),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H16=0,0,SUMIF('LTG-INT-BLD'!$A$10:$A$15,'LTG-INT-REF'!H16,'LTG-INT-BLD'!$F$10:$F$15))","v":0},{"$f":"IF(H16=0,0,SUMIF('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H16,'LTG-INT-BLD'!$F$20:$F$31))","v":0},"",0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H16,'LTG-INT-BLD'!$F$20:$F$31,\"Not defined\")>0,1,0)","v":0},1,0,"",""]
["Court house","1.05 W/ft2",1.05,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$11:$E16,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$12:$F$79,MATCH(0,COUNTIF(G$11:$G16,$F$12:$F$79),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H17=0,0,SUMIF('LTG-INT-BLD'!$A$10:$A$15,'LTG-INT-REF'!H17,'LTG-INT-BLD'!$F$10:$F$15))","v":0},{"$f":"IF(H17=0,0,SUMIF('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H17,'LTG-INT-BLD'!$F$20:$F$31))","v":0},"",0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H17,'LTG-INT-BLD'!$F$20:$F$31,\"Not defined\")>0,1,0)","v":0},1,0,"",""]
["Dining:  Bar lounge/leisure","0.99 W/ft2",0.99,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$11:$E17,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$12:$F$79,MATCH(0,COUNTIF(G$11:$G17,$F$12:$F$79),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H18=0,0,SUMIF('LTG-INT-BLD'!$A$10:$A$15,'LTG-INT-REF'!H18,'LTG-INT-BLD'!$F$10:$F$15))","v":0},{"$f":"IF(H18=0,0,SUMIF('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H18,'LTG-INT-BLD'!$F$20:$F$31))","v":0},"",0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H18,'LTG-INT-BLD'!$F$20:$F$31,\"Not defined\")>0,1,0)","v":0},1,0,"",""]
["Dining:  Cafeteria/fast food","0.9 W/ft2",0.9,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$11:$E18,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$12:$F$79,MATCH(0,COUNTIF(G$11:$G18,$F$12:$F$79),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H19=0,0,SUMIF('LTG-INT-BLD'!$A$10:$A$15,'LTG-INT-REF'!H19,'LTG-INT-BLD'!$F$10:$F$15))","v":0},{"$f":"IF(H19=0,0,SUMIF('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H19,'LTG-INT-BLD'!$F$20:$F$31))","v":0},"",0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H19,'LTG-INT-BLD'!$F$20:$F$31,\"Not defined\")>0,1,0)","v":0},1,0,"",""]
["Dining:  Family","0.89 W/ft2",0.89,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$11:$E19,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$12:$F$79,MATCH(0,COUNTIF(G$11:$G19,$F$12:$F$79),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H20=0,0,SUMIF('LTG-INT-BLD'!$A$10:$A$15,'LTG-INT-REF'!H20,'LTG-INT-BLD'!$F$10:$F$15))","v":0},{"$f":"IF(H20=0,0,SUMIF('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H20,'LTG-INT-BLD'!$F$20:$F$31))","v":0},"",0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H20,'LTG-INT-BLD'!$F$20:$F$31,\"Not defined\")>0,1,0)","v":0},1,0,"",""]
["Dormitory","0.61 W/ft2",0.61,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$11:$E20,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$12:$F$79,MATCH(0,COUNTIF(G$11:$G20,$F$12:$F$79),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H21=0,0,SUMIF('LTG-INT-BLD'!$A$10:$A$15,'LTG-INT-REF'!H21,'LTG-INT-BLD'!$F$10:$F$15))","v":0},{"$f":"IF(H21=0,0,SUMIF('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H21,'LTG-INT-BLD'!$F$20:$F$31))","v":0},"",0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H21,'LTG-INT-BLD'!$F$20:$F$31,\"Not defined\")>0,1,0)","v":0},1,0,"",""]
["Exercise center","0.88 W/ft2",0.88,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$11:$E21,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$12:$F$79,MATCH(0,COUNTIF(G$11:$G21,$F$12:$F$79),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H22=0,0,SUMIF('LTG-INT-BLD'!$A$10:$A$15,'LTG-INT-REF'!H22,'LTG-INT-BLD'!$F$10:$F$15))","v":0},{"$f":"IF(H22=0,0,SUMIF('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H22,'LTG-INT-BLD'!$F$20:$F$31))","v":0},"",0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H22,'LTG-INT-BLD'!$F$20:$F$31,\"Not defined\")>0,1,0)","v":0},1,0,"",""]
["Fire station","0.71 W/ft2",0.71,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$11:$E22,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$12:$F$79,MATCH(0,COUNTIF(G$11:$G22,$F$12:$F$79),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H23=0,0,SUMIF('LTG-INT-BLD'!$A$10:$A$15,'LTG-INT-REF'!H23,'LTG-INT-BLD'!$F$10:$F$15))","v":0},{"$f":"IF(H23=0,0,SUMIF('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H23,'LTG-INT-BLD'!$F$20:$F$31))","v":0},"",0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H23,'LTG-INT-BLD'!$F$20:$F$31,\"Not defined\")>0,1,0)","v":0},1,0,"",""]
["Gymnasium","0.95 W/ft2",0.95,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$11:$E23,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$12:$F$79,MATCH(0,COUNTIF(G$11:$G23,$F$12:$F$79),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H24=0,0,SUMIF('LTG-INT-BLD'!$A$10:$A$15,'LTG-INT-REF'!H24,'LTG-INT-BLD'!$F$10:$F$15))","v":0},{"$f":"IF(H24=0,0,SUMIF('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H24,'LTG-INT-BLD'!$F$20:$F$31))","v":0},"",0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H24,'LTG-INT-BLD'!$F$20:$F$31,\"Not defined\")>0,1,0)","v":0},1,0,"",""]
["Health care clinic","0.87 W/ft2",0.87,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$11:$E24,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$12:$F$79,MATCH(0,COUNTIF(G$11:$G24,$F$12:$F$79),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H25=0,0,SUMIF('LTG-INT-BLD'!$A$10:$A$15,'LTG-INT-REF'!H25,'LTG-INT-BLD'!$F$10:$F$15))","v":0},{"$f":"IF(H25=0,0,SUMIF('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H25,'LTG-INT-BLD'!$F$20:$F$31))","v":0},"",0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H25,'LTG-INT-BLD'!$F$20:$F$31,\"Not defined\")>0,1,0)","v":0},1,0,"",""]
["Hospital","1.2 W/ft2",1.2,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$11:$E25,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$12:$F$79,MATCH(0,COUNTIF(G$11:$G25,$F$12:$F$79),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H26=0,0,SUMIF('LTG-INT-BLD'!$A$10:$A$15,'LTG-INT-REF'!H26,'LTG-INT-BLD'!$F$10:$F$15))","v":0},{"$f":"IF(H26=0,0,SUMIF('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H26,'LTG-INT-BLD'!$F$20:$F$31))","v":0},"",0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H26,'LTG-INT-BLD'!$F$20:$F$31,\"Not defined\")>0,1,0)","v":0},1,0,"",""]
["Hotel","1.0 W/ft2",1,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$11:$E26,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$12:$F$79,MATCH(0,COUNTIF(G$11:$G26,$F$12:$F$79),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H27=0,0,SUMIF('LTG-INT-BLD'!$A$10:$A$15,'LTG-INT-REF'!H27,'LTG-INT-BLD'!$F$10:$F$15))","v":0},{"$f":"IF(H27=0,0,SUMIF('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H27,'LTG-INT-BLD'!$F$20:$F$31))","v":0},"",0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H27,'LTG-INT-BLD'!$F$20:$F$31,\"Not defined\")>0,1,0)","v":0},1,0,"",""]
["Library","1.18 W/ft2",1.18,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$11:$E27,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$12:$F$79,MATCH(0,COUNTIF(G$11:$G27,$F$12:$F$79),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H28=0,0,SUMIF('LTG-INT-BLD'!$A$10:$A$15,'LTG-INT-REF'!H28,'LTG-INT-BLD'!$F$10:$F$15))","v":0},{"$f":"IF(H28=0,0,SUMIF('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H28,'LTG-INT-BLD'!$F$20:$F$31))","v":0},"",0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H28,'LTG-INT-BLD'!$F$20:$F$31,\"Not defined\")>0,1,0)","v":0},1,0,"",""]
["Manufacturing facility","1.11 W/ft2",1.1100000000000001,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$11:$E28,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$12:$F$79,MATCH(0,COUNTIF(G$11:$G28,$F$12:$F$79),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H29=0,0,SUMIF('LTG-INT-BLD'!$A$10:$A$15,'LTG-INT-REF'!H29,'LTG-INT-BLD'!$F$10:$F$15))","v":0},{"$f":"IF(H29=0,0,SUMIF('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H29,'LTG-INT-BLD'!$F$20:$F$31))","v":0},"",0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H29,'LTG-INT-BLD'!$F$20:$F$31,\"Not defined\")>0,1,0)","v":0},1,0,"",""]
["Motel","0.88 W/ft2",0.88,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$11:$E29,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$12:$F$79,MATCH(0,COUNTIF(G$11:$G29,$F$12:$F$79),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H30=0,0,SUMIF('LTG-INT-BLD'!$A$10:$A$15,'LTG-INT-REF'!H30,'LTG-INT-BLD'!$F$10:$F$15))","v":0},{"$f":"IF(H30=0,0,SUMIF('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H30,'LTG-INT-BLD'!$F$20:$F$31))","v":0},"",0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H30,'LTG-INT-BLD'!$F$20:$F$31,\"Not defined\")>0,1,0)","v":0},1,0,"",""]
["Motion picture theater","0.83 W/ft2",0.83,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$11:$E30,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$12:$F$79,MATCH(0,COUNTIF(G$11:$G30,$F$12:$F$79),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H31=0,0,SUMIF('LTG-INT-BLD'!$A$10:$A$15,'LTG-INT-REF'!H31,'LTG-INT-BLD'!$F$10:$F$15))","v":0},{"$f":"IF(H31=0,0,SUMIF('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H31,'LTG-INT-BLD'!$F$20:$F$31))","v":0},"",0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H31,'LTG-INT-BLD'!$F$20:$F$31,\"Not defined\")>0,1,0)","v":0},1,0,"",""]
["Multifamily","0.6 W/ft2",0.6,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$11:$E31,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$12:$F$79,MATCH(0,COUNTIF(G$11:$G31,$F$12:$F$79),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H32=0,0,SUMIF('LTG-INT-BLD'!$A$10:$A$15,'LTG-INT-REF'!H32,'LTG-INT-BLD'!$F$10:$F$15))","v":0},{"$f":"IF(H32=0,0,SUMIF('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H32,'LTG-INT-BLD'!$F$20:$F$31))","v":0},"",0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H32,'LTG-INT-BLD'!$F$20:$F$31,\"Not defined\")>0,1,0)","v":0},1,0,"",""]
["Museum","1.0 W/ft2",1,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$11:$E32,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$12:$F$79,MATCH(0,COUNTIF(G$11:$G32,$F$12:$F$79),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H33=0,0,SUMIF('LTG-INT-BLD'!$A$10:$A$15,'LTG-INT-REF'!H33,'LTG-INT-BLD'!$F$10:$F$15))","v":0},{"$f":"IF(H33=0,0,SUMIF('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H33,'LTG-INT-BLD'!$F$20:$F$31))","v":0},"",0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H33,'LTG-INT-BLD'!$F$20:$F$31,\"Not defined\")>0,1,0)","v":0},1,0]
["Office","0.9 W/ft2",0.9,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$11:$E33,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$12:$F$79,MATCH(0,COUNTIF(G$11:$G33,$F$12:$F$79),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H34=0,0,SUMIF('LTG-INT-BLD'!$A$10:$A$15,'LTG-INT-REF'!H34,'LTG-INT-BLD'!$F$10:$F$15))","v":0},{"$f":"IF(H34=0,0,SUMIF('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H34,'LTG-INT-BLD'!$F$20:$F$31))","v":0},"",0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H34,'LTG-INT-BLD'!$F$20:$F$31,\"Not defined\")>0,1,0)","v":0},1,0]
["Parking garage","0.2 W/ft2",0.2,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$11:$E34,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$12:$F$79,MATCH(0,COUNTIF(G$11:$G34,$F$12:$F$79),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H35=0,0,SUMIF('LTG-INT-BLD'!$A$10:$A$15,'LTG-INT-REF'!H35,'LTG-INT-BLD'!$F$10:$F$15))","v":0},{"$f":"IF(H35=0,0,SUMIF('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H35,'LTG-INT-BLD'!$F$20:$F$31))","v":0},"",0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H35,'LTG-INT-BLD'!$F$20:$F$31,\"Not defined\")>0,1,0)","v":0},1,0]
["Penitentiary","0.9 W/ft2",0.9,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$11:$E35,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$12:$F$79,MATCH(0,COUNTIF(G$11:$G35,$F$12:$F$79),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H36=0,0,SUMIF('LTG-INT-BLD'!$A$10:$A$15,'LTG-INT-REF'!H36,'LTG-INT-BLD'!$F$10:$F$15))","v":0},{"$f":"IF(H36=0,0,SUMIF('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H36,'LTG-INT-BLD'!$F$20:$F$31))","v":0},"",0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H36,'LTG-INT-BLD'!$F$20:$F$31,\"Not defined\")>0,1,0)","v":0},1,0]
["Performing arts theater","1.25 W/ft2",1.25,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$11:$E36,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$12:$F$79,MATCH(0,COUNTIF(G$11:$G36,$F$12:$F$79),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H37=0,0,SUMIF('LTG-INT-BLD'!$A$10:$A$15,'LTG-INT-REF'!H37,'LTG-INT-BLD'!$F$10:$F$15))","v":0},{"$f":"IF(H37=0,0,SUMIF('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H37,'LTG-INT-BLD'!$F$20:$F$31))","v":0},"",0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H37,'LTG-INT-BLD'!$F$20:$F$31,\"Not defined\")>0,1,0)","v":0},1,0]
["Police station","0.9 W/ft2",0.9,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$11:$E37,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$12:$F$79,MATCH(0,COUNTIF(G$11:$G37,$F$12:$F$79),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H38=0,0,SUMIF('LTG-INT-BLD'!$A$10:$A$15,'LTG-INT-REF'!H38,'LTG-INT-BLD'!$F$10:$F$15))","v":0},{"$f":"IF(H38=0,0,SUMIF('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H38,'LTG-INT-BLD'!$F$20:$F$31))","v":0},"",0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H38,'LTG-INT-BLD'!$F$20:$F$31,\"Not defined\")>0,1,0)","v":0},1,0]
["Post office","0.87 W/ft2",0.87,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$11:$E38,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$12:$F$79,MATCH(0,COUNTIF(G$11:$G38,$F$12:$F$79),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H39=0,0,SUMIF('LTG-INT-BLD'!$A$10:$A$15,'LTG-INT-REF'!H39,'LTG-INT-BLD'!$F$10:$F$15))","v":0},{"$f":"IF(H39=0,0,SUMIF('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H39,'LTG-INT-BLD'!$F$20:$F$31))","v":0},"",0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H39,'LTG-INT-BLD'!$F$20:$F$31,\"Not defined\")>0,1,0)","v":0},1,0]
["Religious building","1.05 W/ft2",1.05,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$11:$E39,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$12:$F$79,MATCH(0,COUNTIF(G$11:$G39,$F$12:$F$79),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H40=0,0,SUMIF('LTG-INT-BLD'!$A$10:$A$15,'LTG-INT-REF'!H40,'LTG-INT-BLD'!$F$10:$F$15))","v":0},{"$f":"IF(H40=0,0,SUMIF('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H40,'LTG-INT-BLD'!$F$20:$F$31))","v":0},"",0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H40,'LTG-INT-BLD'!$F$20:$F$31,\"Not defined\")>0,1,0)","v":0},1,0]
["Retail","1.33 W/ft2",1.33,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$11:$E40,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$12:$F$79,MATCH(0,COUNTIF(G$11:$G40,$F$12:$F$79),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H41=0,0,SUMIF('LTG-INT-BLD'!$A$10:$A$15,'LTG-INT-REF'!H41,'LTG-INT-BLD'!$F$10:$F$15))","v":0},{"$f":"IF(H41=0,0,SUMIF('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H41,'LTG-INT-BLD'!$F$20:$F$31))","v":0},"",0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H41,'LTG-INT-BLD'!$F$20:$F$31,\"Not defined\")>0,1,0)","v":0},1,0]
["School/university","0.99 W/ft2",0.99,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$11:$E41,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$12:$F$79,MATCH(0,COUNTIF(G$11:$G41,$F$12:$F$79),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H42=0,0,SUMIF('LTG-INT-BLD'!$A$10:$A$15,'LTG-INT-REF'!H42,'LTG-INT-BLD'!$F$10:$F$15))","v":0},{"$f":"IF(H42=0,0,SUMIF('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H42,'LTG-INT-BLD'!$F$20:$F$31))","v":0},"",0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H42,'LTG-INT-BLD'!$F$20:$F$31,\"Not defined\")>0,1,0)","v":0},1,0]
["Sports arena","0.78 W/ft2",0.78,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$11:$E42,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$12:$F$79,MATCH(0,COUNTIF(G$11:$G42,$F$12:$F$79),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H43=0,0,SUMIF('LTG-INT-BLD'!$A$10:$A$15,'LTG-INT-REF'!H43,'LTG-INT-BLD'!$F$10:$F$15))","v":0},{"$f":"IF(H43=0,0,SUMIF('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H43,'LTG-INT-BLD'!$F$20:$F$31))","v":0},"",0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H43,'LTG-INT-BLD'!$F$20:$F$31,\"Not defined\")>0,1,0)","v":0},1,0]
["Town hall","0.92 W/ft2",0.92,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$11:$E43,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$12:$F$79,MATCH(0,COUNTIF(G$11:$G43,$F$12:$F$79),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H44=0,0,SUMIF('LTG-INT-BLD'!$A$10:$A$15,'LTG-INT-REF'!H44,'LTG-INT-BLD'!$F$10:$F$15))","v":0},{"$f":"IF(H44=0,0,SUMIF('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H44,'LTG-INT-BLD'!$F$20:$F$31))","v":0},"",0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H44,'LTG-INT-BLD'!$F$20:$F$31,\"Not defined\")>0,1,0)","v":0},1,0]
["Transportation","0.77 W/ft2",0.77,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$11:$E44,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$12:$F$79,MATCH(0,COUNTIF(G$11:$G44,$F$12:$F$79),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H45=0,0,SUMIF('LTG-INT-BLD'!$A$10:$A$15,'LTG-INT-REF'!H45,'LTG-INT-BLD'!$F$10:$F$15))","v":0},{"$f":"IF(H45=0,0,SUMIF('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H45,'LTG-INT-BLD'!$F$20:$F$31))","v":0},"",0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$20:$A$31,'LTG-INT-REF'!H45,'LTG-INT-BLD'!$F$20:$F$31,\"Not defined\")>0,1,0)","v":0},1,0]
["Warehouse","0.5 W/ft2",0.5,null,"Formula below needs a blank as first cell of function",{"$f":"IF(ISTEXT(E48),E48,\"\")","v":"Warehouse"}]
["Workshop","1.2 W/ft2",1.2,null,null,{"$f":"IF(ISTEXT(E49),E49,\"\")","v":""}]
["None",{"$f":"CONCATENATE(TEXT(C48,\"0.0#\"),\" W/ft2\")","v":"0.0 W/ft2"},0,null,{"$f":"INDEX('LTG-INT-BLD'!$A$20:$A$31,MATCH(0,COUNTIF(E$47:$E47,'LTG-INT-BLD'!$A$20:$A$31),0))","v":"Warehouse"},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$20:$A$31,MATCH(0,COUNTIF(E$47:$E48,'LTG-INT-BLD'!$A$20:$A$31),0))","v":0},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$20:$A$31,MATCH(0,COUNTIF(E$47:$E49,'LTG-INT-BLD'!$A$20:$A$31),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$20:$A$31,MATCH(0,COUNTIF(E$47:$E50,'LTG-INT-BLD'!$A$20:$A$31),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$20:$A$31,MATCH(0,COUNTIF(E$47:$E51,'LTG-INT-BLD'!$A$20:$A$31),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$20:$A$31,MATCH(0,COUNTIF(E$47:$E52,'LTG-INT-BLD'!$A$20:$A$31),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$20:$A$31,MATCH(0,COUNTIF(E$47:$E53,'LTG-INT-BLD'!$A$20:$A$31),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$20:$A$31,MATCH(0,COUNTIF(E$47:$E54,'LTG-INT-BLD'!$A$20:$A$31),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$20:$A$31,MATCH(0,COUNTIF(E$47:$E55,'LTG-INT-BLD'!$A$20:$A$31),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$20:$A$31,MATCH(0,COUNTIF(E$47:$E56,'LTG-INT-BLD'!$A$20:$A$31),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$20:$A$31,MATCH(0,COUNTIF(E$47:$E57,'LTG-INT-BLD'!$A$20:$A$31),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$20:$A$31,MATCH(0,COUNTIF(E$47:$E58,'LTG-INT-BLD'!$A$20:$A$31),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$20:$A$31,MATCH(0,COUNTIF(E$47:$E59,'LTG-INT-BLD'!$A$20:$A$31),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$20:$A$31,MATCH(0,COUNTIF(E$47:$E60,'LTG-INT-BLD'!$A$20:$A$31),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$20:$A$31,MATCH(0,COUNTIF(E$47:$E61,'LTG-INT-BLD'!$A$20:$A$31),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$20:$A$31,MATCH(0,COUNTIF(E$47:$E62,'LTG-INT-BLD'!$A$20:$A$31),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$20:$A$31,MATCH(0,COUNTIF(E$47:$E63,'LTG-INT-BLD'!$A$20:$A$31),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$20:$A$31,MATCH(0,COUNTIF(E$47:$E64,'LTG-INT-BLD'!$A$20:$A$31),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$20:$A$31,MATCH(0,COUNTIF(E$47:$E65,'LTG-INT-BLD'!$A$20:$A$31),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$20:$A$31,MATCH(0,COUNTIF(E$47:$E66,'LTG-INT-BLD'!$A$20:$A$31),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$20:$A$31,MATCH(0,COUNTIF(E$47:$E67,'LTG-INT-BLD'!$A$20:$A$31),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$20:$A$31,MATCH(0,COUNTIF(E$47:$E68,'LTG-INT-BLD'!$A$20:$A$31),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$20:$A$31,MATCH(0,COUNTIF(E$47:$E69,'LTG-INT-BLD'!$A$20:$A$31),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$20:$A$31,MATCH(0,COUNTIF(E$47:$E70,'LTG-INT-BLD'!$A$20:$A$31),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$20:$A$31,MATCH(0,COUNTIF(E$47:$E71,'LTG-INT-BLD'!$A$20:$A$31),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$20:$A$31,MATCH(0,COUNTIF(E$47:$E72,'LTG-INT-BLD'!$A$20:$A$31),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$20:$A$31,MATCH(0,COUNTIF(E$47:$E73,'LTG-INT-BLD'!$A$20:$A$31),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$20:$A$31,MATCH(0,COUNTIF(E$47:$E74,'LTG-INT-BLD'!$A$20:$A$31),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$20:$A$31,MATCH(0,COUNTIF(E$47:$E75,'LTG-INT-BLD'!$A$20:$A$31),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$20:$A$31,MATCH(0,COUNTIF(E$47:$E76,'LTG-INT-BLD'!$A$20:$A$31),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$20:$A$31,MATCH(0,COUNTIF(E$47:$E77,'LTG-INT-BLD'!$A$20:$A$31),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$20:$A$31,MATCH(0,COUNTIF(E$47:$E78,'LTG-INT-BLD'!$A$20:$A$31),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$20:$A$31,MATCH(0,COUNTIF(E$47:$E79,'LTG-INT-BLD'!$A$20:$A$31),0))","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$20:$A$31,MATCH(0,COUNTIF(E$47:$E80,'LTG-INT-BLD'!$A$20:$A$31),0))","v":{"$error":"#N/A"}}]

{"sheet":"LTG-EXT","index":7,"n_rows":169,"n_cols":12,"rows_kept":169,"cut":false,"hidden":false,"merged":[[11,0,11,1],[18,2,18,4],[19,2,19,4],[17,0,19,1]]}
["Exterior Lighting Summary",null,null,null,"LTG-EXT"]
[{"$f":"'LTG-SUM'!A2","v":"2012 Washington State Energy Code Compliance Forms for Commercial Buildings including R2 & R3 over 3 stories and all R1 "},null,null,null,{"$f":"'LTG-SUM'!G2","v":"Revised Jan 2014"}]
[{"$f":"'LTG-SUM'!A3","v":"Project Info"},{"$f":"IF('LTG-SUM'!C3=\"1 - This address line will copy onto other forms\",\"Fill this line out on LGT-SUM\",'LTG-SUM'!C3)","v":"Baxter Mini-Storage Bldg."},null,{"$f":"'LTG-SUM'!F3","v":"Date"},{"$f":"'LTG-SUM'!G3","v":"2015-09-07"}]
[null,{"$f":"IF('LTG-SUM'!C4=\"2 - This address line will copy onto other forms\",\"Fill this line out on LGT-SUM\",'LTG-SUM'!C4)","v":"3019 Ocean Beach Rd. Pacific Beach WA 98571"},null,{"$f":"'LTG-SUM'!F4","v":"For Building Department Use"}]
[null,{"$f":"IF('LTG-SUM'!C5=\"3 - This address line will copy onto other forms\",\"Fill this line out on LGT-SUM\",'LTG-SUM'!C5)","v":0}]
[null,{"$f":"IF('LTG-SUM'!C6=\"4 - This address line will copy onto other forms\",\"Fill this line out on LGT-SUM\",'LTG-SUM'!C6)","v":"Mark Baxter"}]
[null,{"$f":"IF('LTG-SUM'!C7=\"1 - This address line will copy onto other forms\",\"Fill this line out on LGT-SUM\",'LTG-SUM'!C7)","v":"3019 Ocean Beach Rd. Pacific Beach WA 98571"}]
[null,{"$f":"IF('LTG-SUM'!C8=\"1 - This address line will copy onto other forms\",\"Fill this line out on LGT-SUM\",'LTG-SUM'!C8)","v":"360-276-4182"}]
[]
["Project Description"]
["Lighting Zone "]
[]
["Compliance Option"]
[]
["Building Grounds"]
[" Applies to luminaires > 100 Watts"]
[]
["Exterior Lighting Alterations"]
[]
[]
[]
["Tradable Maximum Allowed Lighting Wattage",null,null,"Base Site Allowance:",{"$f":"Site_Allowance","v":600},null,null,null,null,null,null,{"$f":"SUM(L24:L36)","v":1}]
[]
["Tradable Surfaces","\nSurface Description","Allowed Watts\nper ft2 or per lf","Area (ft2), perimeter (lf) or # of items","Allowed Watts \nx ft2 (or x lf)"]
["Grounds Walkways  >10' wide","West Perimeter",{"$f":"IF(A25<>\"\",VLOOKUP(A25,TradableAreas,Text_Col,FALSE),\"\")","v":"0.14 W/ft2"},1254,{"$f":"IF(C25=\"\",0,IF(ISNA(IF(VLOOKUP(A25,$A$33:$E$36,5,0)>0,\"\",NA())),\"Unlit\",D25*VLOOKUP(A25,TradableAreas,Numb_Col,FALSE)))","v":175.56000000000003},{"$f":"IF(ISNA(INDEX(A$25:A$29,MATCH(0,COUNTIF(F$24:$F24,A$25:A$29),0))),\"\",INDEX(A$25:A$29,MATCH(0,COUNTIF(F$24:$F24,A$25:A$29),0)))","v":"Grounds Walkways  >10' wide"}]
["Grounds Walkways  >10' wide","East Perimeter",{"$f":"IF(A26<>\"\",VLOOKUP(A26,TradableAreas,Text_Col,FALSE),\"\")","v":"0.14 W/ft2"},1254,{"$f":"IF(C26=\"\",0,IF(ISNA(IF(VLOOKUP(A26,$A$33:$E$36,5,0)>0,\"\",NA())),\"Unlit\",D26*VLOOKUP(A26,TradableAreas,Numb_Col,FALSE)))","v":175.56000000000003},{"$f":"IF(ISNA(INDEX(A$25:A$29,MATCH(0,COUNTIF(F$24:$F25,A$25:A$29),0))),\"\",INDEX(A$25:A$29,MATCH(0,COUNTIF(F$24:$F25,A$25:A$29),0)))","v":0}]
["Grounds Walkways  >10' wide","North Perimeter",{"$f":"IF(A27<>\"\",VLOOKUP(A27,TradableAreas,Text_Col,FALSE),\"\")","v":"0.14 W/ft2"},643,{"$f":"IF(C27=\"\",0,IF(ISNA(IF(VLOOKUP(A27,$A$33:$E$36,5,0)>0,\"\",NA())),\"Unlit\",D27*VLOOKUP(A27,TradableAreas,Numb_Col,FALSE)))","v":90.02000000000001},{"$f":"IF(ISNA(INDEX(A$25:A$29,MATCH(0,COUNTIF(F$24:$F26,A$25:A$29),0))),\"\",INDEX(A$25:A$29,MATCH(0,COUNTIF(F$24:$F26,A$25:A$29),0)))","v":""},null,null,null,null,null,1]
["Grounds Walkways  >10' wide","South Perimeter",{"$f":"IF(A28<>\"\",VLOOKUP(A28,TradableAreas,Text_Col,FALSE),\"\")","v":"0.14 W/ft2"},643,{"$f":"IF(C28=\"\",0,IF(ISNA(IF(VLOOKUP(A28,$A$33:$E$36,5,0)>0,\"\",NA())),\"Unlit\",D28*VLOOKUP(A28,TradableAreas,Numb_Col,FALSE)))","v":90.02000000000001},{"$f":"IF(ISNA(INDEX(A$25:A$29,MATCH(0,COUNTIF(F$24:$F27,A$25:A$29),0))),\"\",INDEX(A$25:A$29,MATCH(0,COUNTIF(F$24:$F27,A$25:A$29),0)))","v":""},null,null,null,null,1]
[]
[null,null,null,"Total Allowed Tradable Watts:",{"$f":"SUM(E24:E29)","v":531.16000000000008}]
["Tradable Proposed Lighting Wattage (Use mfgr listed maximum input wattage for luminaire.)"]
["Tradable Surface","\nFixture  Description","Number of \nFixtures","Watts/\nFixture","Watts \nProposed"]
["Grounds Walkways  >10' wide","Ext. CFL Security Light",2,42,{"$f":"IF(AND(A33=\"\",C33=0,D33=0),0,IF(ISNA(IF(VLOOKUP(A33,$A$25:$E$29,4,FALSE)>0,\"\",NA())),\"Not Defined\",C33*D33))","v":84}]
["Grounds Walkways  >10' wide","Ext. LED Wall Light",8,10,{"$f":"IF(AND(A34=\"\",C34=0,D34=0),0,IF(ISNA(IF(VLOOKUP(A34,$A$25:$E$29,4,FALSE)>0,\"\",NA())),\"Not Defined\",C34*D34))","v":80}]
[null,null,null,null,{"$f":"IF(AND(A35=\"\",C35=0,D35=0),0,IF(ISNA(IF(VLOOKUP(A35,$A$25:$E$29,4,FALSE)>0,\"\",NA())),\"Not Defined\",C35*D35))","v":0},null,null,null,null,1]
[]
[null,null,null,"Total Proposed Tradable Watts:",{"$f":"SUM(E33:E36)","v":164},{"$f":"COUNTIF(E33:E36,\"Not Defined\")","v":0}]
[]
[]
["Non-Tradable Maximum Allowed Lighting Wattage",null,null,"Base Site Allowance Remaining: ",{"$f":"Site_Remaining","v":600}]
[]
["Non-Tradable Surfaces","\nSurface Description","Allowed Watts\nper ft2 or per lf","Area (ft2), perimeter (lf) or # of items","Allowed Watts \nx ft2 (or x lf)"]
[null,null,{"$f":"IF(A43<>\"\",VLOOKUP(A43,NonTradableAreas,Text_Col,FALSE),\"\")","v":""},null,{"$f":"IF(A43<>\"\",IF(ISNA(IF(VLOOKUP(A43,$A$49:$F$52,5,FALSE)>0,\"\",NA())),\"Unlit\",   IF(A43<>\"Automated Teller\",D43*VLOOKUP(A43,NonTradableAreas,Numb_Col,FALSE),IF(D43>0,270+(D43-1)*90,0))),\"\")","v":""},{"$f":"IF(ISNA(INDEX(A$43:A$46,MATCH(0,COUNTIF(F$42:$F42,A$43:A$46),0))),\"\",INDEX(A$43:A$46,MATCH(0,COUNTIF(F$42:$F42,A$43:A$46),0)))","v":0}]
[null,null,{"$f":"IF(A44<>\"\",VLOOKUP(A44,NonTradableAreas,Text_Col,FALSE),\"\")","v":""},null,{"$f":"IF(A44<>\"\",IF(ISNA(IF(VLOOKUP(A44,$A$49:$F$52,5,FALSE)>0,\"\",NA())),\"Unlit\",   IF(A44<>\"Automated Teller\",D44*VLOOKUP(A44,NonTradableAreas,Numb_Col,FALSE),IF(D44>0,270+(D44-1)*90,0))),\"\")","v":""},{"$f":"IF(ISNA(INDEX(A$43:A$46,MATCH(0,COUNTIF(F$42:$F43,A$43:A$46),0))),\"\",INDEX(A$43:A$46,MATCH(0,COUNTIF(F$42:$F43,A$43:A$46),0)))","v":""}]
[null,null,{"$f":"IF(A45<>\"\",VLOOKUP(A45,NonTradableAreas,Text_Col,FALSE),\"\")","v":""},null,{"$f":"IF(A45<>\"\",IF(ISNA(IF(VLOOKUP(A45,$A$49:$F$52,5,FALSE)>0,\"\",NA())),\"Unlit\",   IF(A45<>\"Automated Teller\",D45*VLOOKUP(A45,NonTradableAreas,Numb_Col,FALSE),IF(D45>0,270+(D45-1)*90,0))),\"\")","v":""},{"$f":"IF(ISNA(INDEX(A$43:A$46,MATCH(0,COUNTIF(F$42:$F44,A$43:A$46),0))),\"\",INDEX(A$43:A$46,MATCH(0,COUNTIF(F$42:$F44,A$43:A$46),0)))","v":""}]
[]
["Non-Tradable Proposed Lighting Wattage "]
["Non-Tradable Surface","\nFixture  Description","Number of \nFixtures","Watts/\nFixture","Watts \nProposed"]
[null,null,null,null,{"$f":"IF(AND(A49=\"\",C49=0,D49=0),0,IF(ISNA(IF(VLOOKUP(A49,$A$43:$E$46,4,FALSE)>0,\"\",NA())),\"Not Defined\",C49*D49))","v":0}]
[null,null,null,null,{"$f":"IF(AND(A50=\"\",C50=0,D50=0),0,IF(ISNA(IF(VLOOKUP(A50,$A$43:$E$46,4,FALSE)>0,\"\",NA())),\"Not Defined\",C50*D50))","v":0}]
[null,null,null,null,{"$f":"IF(AND(A51=\"\",C51=0,D51=0),0,IF(ISNA(IF(VLOOKUP(A51,$A$43:$E$46,4,FALSE)>0,\"\",NA())),\"Not Defined\",C51*D51))","v":0},null,null,null,null,1]
[null,null,null,"Total excess Non-Tradable watts:",{"$f":"IF(Zone<5,Excess_Watts,\"\")","v":0},{"$f":"COUNTIF(E49:E52,\"Not Defined\")","v":0}]
[null,null,null,"Site Allowance Balance:",{"$f":"IF(Zone<5,'LTG-EXT-REF'!P40,\"\")","v":600}]
[]
[{"$f":"CONCATENATE(\"Exterior Lighting \",'LTG-EXT-REF'!X34)","v":"Exterior Lighting "},null,null,null,{"$f":"'LTG-EXT-REF'!X36","v":"COMPLIES WITH SITE ALLOWANCE"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"'LTG-EXT-REF'!A12","v":"Tradable Locations"}]
[{"$f":"'LTG-EXT-REF'!A13","v":"Base Site Allowance"}]
[{"$f":"'LTG-EXT-REF'!A14","v":"Uncovered Parking and drives"}]
[{"$f":"'LTG-EXT-REF'!A15","v":"Grounds Walkways  <10 wide"}]
[{"$f":"'LTG-EXT-REF'!A16","v":"Grounds Walkways  >10' wide"}]
[{"$f":"'LTG-EXT-REF'!A17","v":"Stairways"}]
[{"$f":"'LTG-EXT-REF'!A18","v":"Pedestrian Tunnel"}]
[{"$f":"'LTG-EXT-REF'!A19","v":"Main Entry Door"}]
[{"$f":"'LTG-EXT-REF'!A20","v":"Other Entry Door"}]
[{"$f":"'LTG-EXT-REF'!A21","v":"Entry Canopies"}]
[{"$f":"'LTG-EXT-REF'!A22","v":"Sales Canopies "}]
[{"$f":"'LTG-EXT-REF'!A23","v":"Open Sales"}]
[{"$f":"'LTG-EXT-REF'!A24","v":"Car Sales Street Frontage"}]
[{"$f":"'LTG-EXT-REF'!A25","v":0}]
[]
[{"$f":"'LTG-EXT-REF'!A27","v":0}]
[{"$f":"'LTG-EXT-REF'!A28","v":0}]
[{"$f":"'LTG-EXT-REF'!A29","v":0}]
[{"$f":"'LTG-EXT-REF'!A30","v":"Non-Tradable"}]
[{"$f":"'LTG-EXT-REF'!A31","v":"Base Site Allowance"}]
[{"$f":"'LTG-EXT-REF'!A32","v":"Bldg. Facade (by area)"}]
[{"$f":"'LTG-EXT-REF'!A33","v":"Bldg. Façade (by perim)"}]
[{"$f":"'LTG-EXT-REF'!A34","v":"Automated Teller"}]
[{"$f":"'LTG-EXT-REF'!A35","v":"Gate House"}]
[{"$f":"'LTG-EXT-REF'!A36","v":"Loading Areas - Law & EMS"}]
[{"$f":"'LTG-EXT-REF'!A37","v":"Drive up Windows & Doors"}]
[{"$f":"'LTG-EXT-REF'!A38","v":"Parking Near 24 Hour Entrances"}]
[{"$f":"'LTG-EXT-REF'!A39","v":0}]
[{"$f":"'LTG-EXT-REF'!A40","v":0}]
[{"$f":"'LTG-EXT-REF'!A41","v":0}]
[{"$f":"'LTG-EXT-REF'!A42","v":0}]
[{"$f":"'LTG-EXT-REF'!A43","v":0}]
[{"$f":"'LTG-EXT-REF'!A44","v":0}]
[{"$f":"'LTG-EXT-REF'!A45","v":0}]
[{"$f":"'LTG-EXT-REF'!A46","v":0}]
[{"$f":"'LTG-EXT-REF'!A47","v":0}]
[{"$f":"'LTG-EXT-REF'!A48","v":0}]
[{"$f":"'LTG-EXT-REF'!A49","v":0}]
[{"$f":"'LTG-EXT-REF'!A50","v":0}]

{"sheet":"LTG-EXT-REF","index":8,"n_rows":47,"n_cols":26,"rows_kept":47,"cut":false,"hidden":true,"merged":[[10,10,10,11],[28,8,28,9],[10,8,10,9],[10,1,10,2],[28,3,28,4],[10,3,10,4],[28,5,28,6],[10,5,10,6],[28,1,28,2]]}
[]
[]
[]
[]
["Selected Lighting Zone",2,"Site Allowance",{"$f":"VLOOKUP(\"Base Site Allowance\",TradableAreas,Numb_Col,FALSE)","v":600}]
["Column Index"]
["Text","Number"]
[{"$f":"ROUND(IF(B5>=4,3,2)+(Zone-1)*2,1)","v":4},{"$f":"ROUND(IF(B5>=4,4,3)+(Zone-1)*2,1)","v":5}]
["Exterior Lighting Allowance Lookup Tables"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"If we set up area checking for tradable lighting"]
[null,"Zone 1",null,"Zone 2",null,"Zone 3",null,null,"Zone 4",null,"No Zone Selected",null,null,null,"Error","kind of error"]
["Tradable Locations","text","W/unit","text","W/unit","text","W/unit",null,"text","W/unit",null,null,"allowed","proposed","unlit area","undeclared area"]
["Base Site Allowance","500 W",500,"600 W",600,"750 W",750,null,"1300 W",1300,"Select Zone",0,0,0,0,0]
["Uncovered Parking and drives","0.04 W/ft2",0.04,"0.06 W/ft2",0.06,"0.10 W/ft2",0.1,null,"0.13 W/ft2",0.13,"Select Zone",0,{"$f":"SUMIF('LTG-EXT'!$A$25:$A$29,A14,'LTG-EXT'!$E$25:$E$29)","v":0},{"$f":"SUMIF('LTG-EXT'!$A$33:$A$36,A14,'LTG-EXT'!$E$33:$E$36)","v":0},{"$f":"IF(AND(M14>0,N14=0),1,0)","v":0},{"$f":"IF(AND(N14>0,M14=0),1,0)","v":0}]
["Grounds Walkways  <10 wide","0.7 W/LF",0.7,"0.7 W/LF",0.7,"0.8 W/LF",0.8,null,"1.0 W/LF",1,"Select Zone",0,{"$f":"SUMIF('LTG-EXT'!$A$25:$A$29,A15,'LTG-EXT'!$E$25:$E$29)","v":0},{"$f":"SUMIF('LTG-EXT'!$A$33:$A$36,A15,'LTG-EXT'!$E$33:$E$36)","v":0},{"$f":"IF(AND(M15>0,N15=0),1,0)","v":0},{"$f":"IF(AND(N15>0,M15=0),1,0)","v":0}]
["Grounds Walkways  >10' wide","0.14 W/ft2",0.14000000000000001,"0.14 W/ft2",0.14000000000000001,"0.16 W/ft2",0.16,null,"0.20 W/ft2",0.2,"Select Zone",0,{"$f":"SUMIF('LTG-EXT'!$A$25:$A$29,A16,'LTG-EXT'!$E$25:$E$29)","v":531.16000000000008},{"$f":"SUMIF('LTG-EXT'!$A$33:$A$36,A16,'LTG-EXT'!$E$33:$E$36)","v":164},0,0]
["Stairways","0.75 W/ft2",0.75,"1.0 W/ft2",1,"1.0 W/ft2",1,null,"1.0 W/ft2",1,"Select Zone",0,{"$f":"SUMIF('LTG-EXT'!$A$25:$A$29,A17,'LTG-EXT'!$E$25:$E$29)","v":0},{"$f":"SUMIF('LTG-EXT'!$A$33:$A$36,A17,'LTG-EXT'!$E$33:$E$36)","v":0},0,0]
["Pedestrian Tunnel","0.15 W/ft2",0.15,"0.15 W/ft2",0.15,"0.2 W/ft2",0.2,null,"0.3 W/ft2",0.3,"Select Zone",0,{"$f":"SUMIF('LTG-EXT'!$A$25:$A$29,A18,'LTG-EXT'!$E$25:$E$29)","v":0},{"$f":"SUMIF('LTG-EXT'!$A$33:$A$36,A18,'LTG-EXT'!$E$33:$E$36)","v":0},0,0]
["Main Entry Door","20W/LF door width",20,"20W/LF door width",20,"30W/LF door width",30,null,"30W/LF door width",30,"Select Zone",0,{"$f":"SUMIF('LTG-EXT'!$A$25:$A$29,A19,'LTG-EXT'!$E$25:$E$29)","v":0},{"$f":"SUMIF('LTG-EXT'!$A$33:$A$36,A19,'LTG-EXT'!$E$33:$E$36)","v":0},0,0]
["Other Entry Door","20W/LF door width",20,"20W/LF door width",20,"20W/LF door width",20,null,"20W/LF door width",20,"Select Zone",0,{"$f":"SUMIF('LTG-EXT'!$A$25:$A$29,A20,'LTG-EXT'!$E$25:$E$29)","v":0},{"$f":"SUMIF('LTG-EXT'!$A$33:$A$36,A20,'LTG-EXT'!$E$33:$E$36)","v":0},0,0]
["Entry Canopies","0.25 W/ft2",0.25,"0.25 W/ft2",0.25,"0.4 W/ft2",0.4,null,"0.4 W/ft2",0.4,"Select Zone",0,{"$f":"SUMIF('LTG-EXT'!$A$25:$A$29,A21,'LTG-EXT'!$E$25:$E$29)","v":0},{"$f":"SUMIF('LTG-EXT'!$A$33:$A$36,A21,'LTG-EXT'!$E$33:$E$36)","v":0},0,0]
["Sales Canopies ","0.6 W/ft2",0.6,"0.6 W/ft2",0.6,"0.8 W/ft2",0.8,null,"1.0 W/ft2",1,"Select Zone",0,{"$f":"SUMIF('LTG-EXT'!$A$25:$A$29,A22,'LTG-EXT'!$E$25:$E$29)","v":0},{"$f":"SUMIF('LTG-EXT'!$A$33:$A$36,A22,'LTG-EXT'!$E$33:$E$36)","v":0},0,0]
["Open Sales","0.25 W/ft2",0.25,"0.25 W/ft2",0.25,"0.5 W/ft2",0.5,null,"0.7 W/ft2",0.7,"Select Zone",0,{"$f":"SUMIF('LTG-EXT'!$A$25:$A$29,A23,'LTG-EXT'!$E$25:$E$29)","v":0},{"$f":"SUMIF('LTG-EXT'!$A$33:$A$36,A23,'LTG-EXT'!$E$33:$E$36)","v":0},0,0]
["Car Sales Street Frontage","No Allowance",0,"10 W/LF frontage",10,"10 W/LF frontage",10,null,"30 W/LF frontage",30,"Select Zone",0,{"$f":"SUMIF('LTG-EXT'!$A$25:$A$29,A24,'LTG-EXT'!$E$25:$E$29)","v":0},{"$f":"SUMIF('LTG-EXT'!$A$33:$A$36,A24,'LTG-EXT'!$E$33:$E$36)","v":0},0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ERROR if >0",{"$f":"COUNTIF(O12:O23,\">0\")","v":0},{"$f":"COUNTIF(P12:P23,\">0\")","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Excess Watts","Site Remaining"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O31:O39)","v":0},{"$f":"IF('LTG-EXT'!E30-'LTG-EXT'!E37>0,Site_Allowance,'LTG-EXT'!E30-'LTG-EXT'!E37+Site_Allowance)","v":600}]
[null,"Zone 1",null,"Zone 2",null,"Zone 3",null,null,"Zone 4",null,null,null,null,null,null,null,null,"Fail Flag","No Site Allowance",null,"With Site Allowance",null,null,"Façade Warning",null,"logic"]
["Non-Tradable","text","W/unit","text","W/unit","text","W/unit",null,"text","W/unit",null,null,"allowed","proposed","Excess Watts","Site Allowance","Fail Flag","w/ Site Allowance","fail msg","No Grace","warning","Grace",null,{"$f":"IF( AND(M32>0,M33>0), \"- Façade must be either Area or Perimeter but not both.\",\"\")","v":""},null,"if proposed lighting enter - check compliance else be blank"]
["Base Site Allowance","500 W",500,"600 W",600,"750 W",750,null,"1300 W",1300,"Select Zone",0,0,0,{"$f":"MAX(0,$N31-$M31)","v":0},{"$f":"MAX(0,$P$28)-O31","v":600},{"$f":"IF(ROUND(N31,0)>ROUND(M31,0),1,0)","v":0},{"$f":"IF(AND(Q31=1,P31<0),1,0)","v":0},null,{"$f":"Q31","v":0},null,{"$f":"R31","v":0},null,"Undefined Surface Warning",null,"if non-tradable light entered without cateory throw error. If okay then:"]
["Bldg. Facade (by area)","No Allowance",0,"0.1 W/ft2",0.1,"0.15 W/ft2",0.15,null,"0.2 W/ft2",0.2,"Select Zone",0,{"$f":"SUMIF('LTG-EXT'!$A$43:$A$46,A32,'LTG-EXT'!$E$43:$E$46)","v":0},{"$f":"SUMIF('LTG-EXT'!$A$49:$A$52,A32,'LTG-EXT'!$E$49:$E$52)","v":0},0,{"$f":"$P31-O32","v":600},0,0,{"$f":"IF(Q32=1,IF(T32=1,A32,CONCATENATE(\" & \",A32) ),\"\")","v":""},{"$f":"T31+Q32","v":0},null,{"$f":"V31+R32","v":0},null,{"$f":"IF(N46,IF('LTG-EXT'!F37>0,\"- \"&IF('LTG-EXT'!F52>0,\"Non-Tradable and tradable information are incomplete. \",\"Tradable information is incomplete. \"),IF('LTG-EXT'!F52>0,\"Non-Tradable information is incomplete.\",\"\")),\"\")","v":""}," old formula =IF(N46=1,\"Error: Non-tradable allowed and proposed surfaces do not match.\",\"\")","if no grace and grace =0 then flying colors"]
["Bldg. Façade (by perim)","No Allowance",0,"2.5 W/lf",2.5,"3.75 W/lf",3.75,null,"5.0 W/lf",5,"Select Zone",0,{"$f":"SUMIF('LTG-EXT'!$A$43:$A$46,A33,'LTG-EXT'!$E$43:$E$46)","v":0},{"$f":"SUMIF('LTG-EXT'!$A$49:$A$52,A33,'LTG-EXT'!$E$49:$E$52)","v":0},0,600,0,0,"",0,{"$f":"IF(R33=1,IF(V33=1,A33,CONCATENATE(\" & \",A33) ),\"\")","v":""},0,null,"Error Msg"," new has \" \" so that complies does not show","if NOT(no grace and grace =0) then fail all items"]
["Automated Teller","270W+90W/add.",270,"270W+90W/add.",270,"270W+90W/add.",270,null,"270W+90W/add.",270,"Select Zone",0,{"$f":"SUMIF('LTG-EXT'!$A$43:$A$46,A34,'LTG-EXT'!$E$43:$E$46)","v":0},{"$f":"SUMIF('LTG-EXT'!$A$49:$A$52,A34,'LTG-EXT'!$E$49:$E$52)","v":0},0,600,0,0,"",0,"",0,null,{"$f":"IF(N45>0,IF(X30<>\"\",X30,IF(X32<>\"\",X32,\"\")),\"\")","v":""},null,"if not no grace but grace=0 then xxxxx"]
["Gate House","0.75 W/ft2",0.75,"0.75 W/ft2",0.75,"0.75 W/ft2",0.75,null,"0.75 W/ft2",0.75,"Select Zone",0,{"$f":"SUMIF('LTG-EXT'!$A$43:$A$46,A35,'LTG-EXT'!$E$43:$E$46)","v":0},{"$f":"SUMIF('LTG-EXT'!$A$49:$A$52,A35,'LTG-EXT'!$E$49:$E$52)","v":0},0,600,0,0,"",0,"",0,null,"Fail Msg"]
["Loading Areas - Law & EMS","0.5 W/ft2",0.5,"0.5 W/ft2",0.5,"0.5 W/ft2",0.5,null,"0.5 W/ft2",0.5,"Select Zone",0,{"$f":"SUMIF('LTG-EXT'!$A$43:$A$46,A36,'LTG-EXT'!$E$43:$E$46)","v":0},{"$f":"SUMIF('LTG-EXT'!$A$49:$A$52,A36,'LTG-EXT'!$E$49:$E$52)","v":0},0,600,0,0,"",0,"",0,null,{"$f":"IF(OR(N45>0,'LTG-EXT'!E37>0),IF(OR(X30<>\"\",X32<>\"\"),\"DOES NOT COMPLY\", IF(SUM(R32:R39)=0,IF(P28>=0,\"COMPLIES WITH SITE ALLOWANCE\",\"TRADABLE EXCEEDS ALLOWANCE: DOES NOT COMPLY\"),IF(P28>=0,\"NON-TRADABLE EXCEEDS SITE ALLOWANCE: DOES NOT COMPLY\",\"BOTH SECTIONS EXCEED SITE ALLOWANCE: DOES NOT COMPLY\"))),\"\")","v":"COMPLIES WITH SITE ALLOWANCE"}]
["Drive up Windows & Doors","400W per driveup",400,"400W per driveup",400,"400W per driveup",400,null,"400W per driveup",400,"Select Zone",0,{"$f":"SUMIF('LTG-EXT'!$A$43:$A$46,A37,'LTG-EXT'!$E$43:$E$46)","v":0},{"$f":"SUMIF('LTG-EXT'!$A$49:$A$52,A37,'LTG-EXT'!$E$49:$E$52)","v":0},0,600,0,{"$f":"IF(AND(Q37=1,P37<0),1,0)","v":0},"",0,"",0]
["Parking Near 24 Hour Entrances","800W per Entry",800,"800W per Entry",800,"800W per Entry",800,null,"800W per Entry",800,"Select Zone",0,{"$f":"SUMIF('LTG-EXT'!$A$43:$A$46,A38,'LTG-EXT'!$E$43:$E$46)","v":0},{"$f":"SUMIF('LTG-EXT'!$A$49:$A$52,A38,'LTG-EXT'!$E$49:$E$52)","v":0},0,600,0,{"$f":"IF(AND(Q38=1,P38<0),1,0)","v":0},"",0,"",0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Site_Remaining<0,P38+Site_Remaining,P38)","v":600}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Total in Categories",null,null,{"$f":"SUM(N32:N39)","v":0},"sum of allowed and proposed watts in non-tradable categories"]
[null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUMPRODUCT('LTG-EXT'!$C$49:$C$52,'LTG-EXT'!$D$49:$D$52) + SUMPRODUCT('LTG-EXT'!$C$33:$C$36,'LTG-EXT'!$D$33:$D$36)","v":164},"Sum all entered watts. If diff from category totals then watts entered in undefined category."]
[null,null,null,null,null,null,null,null,null,null,"Error",null,null,{"$f":"OR('LTG-EXT'!F37>0,'LTG-EXT'!F52>0)","v":false},null," 1=Error : watts entered in undefined category"]
[null,null,null,null,null,null,null,null,null,null,"Error Msg",null,null," WAS =IF(N45>N44+0.01,\"PROPOSED WATTS IN UNDEFINED AREA\",\"\")"]

{"sheet":"LTG-LPA","index":9,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":true,"merged":[]}
["Lighting Power Allowance Adjustments",null,null,null,null,"LTG-LPA"]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[" "]
["Adjusted Lighting Power Allowances (Interior)"]
["Location\n(floor plan/room #)","Occupancy Description","Allowed\nWatts per ft2 **","Ceiling Height for this room","Ceiling Height limit for this exception**","Adjusted LPA\nWatts per ft2",null,null,"Not sure this is needed but need some way to enter atriums"]
[null,null,null,null,{"$f":"IF(temp!A1=1,\"9 feet\",IF(temp!A1=2,\"12 feet\",IF(temp!A1=3,\"20 feet\",\"\")))","v":""},{"$f":"IF(AND(D8>I8,I8>8),C8*(1+(0.02*(D8-I8))),C8)","v":0},null,null,{"$f":"LOOKUP(temp!A1,$C$42:$D$45)","v":0}]
[null,null,null,null,{"$f":"IF(temp!A2=1,\"9 feet\",IF(temp!A2=2,\"12 feet\",IF(temp!A2=3,\"20 feet\",\"\")))","v":""},{"$f":"IF(AND(D9>I9,I9>8),C9*(1+(0.02*(D9-I9))),C9)","v":0},null,null,{"$f":"LOOKUP(temp!A2,$C$42:$D$45)","v":0}]
[null,null,null,null,{"$f":"IF(temp!A3=1,\"9 feet\",IF(temp!A3=2,\"12 feet\",IF(temp!A3=3,\"20 feet\",\"\")))","v":""},0,null,null,{"$f":"LOOKUP(temp!A3,$C$42:$D$45)","v":0}]
[null,null,null,null,{"$f":"IF(temp!A4=1,\"9 feet\",IF(temp!A4=2,\"12 feet\",IF(temp!A4=3,\"20 feet\",\"\")))","v":""},0,null,null,{"$f":"LOOKUP(temp!A4,$C$42:$D$45)","v":0}]
[null,null,null,null,{"$f":"IF(temp!A5=1,\"9 feet\",IF(temp!A5=2,\"12 feet\",IF(temp!A5=3,\"20 feet\",\"\")))","v":""},0,null,null,{"$f":"LOOKUP(temp!A5,$C$42:$D$45)","v":0}]
[null,null,null,null,{"$f":"IF(temp!A6=1,\"9 feet\",IF(temp!A6=2,\"12 feet\",IF(temp!A6=3,\"20 feet\",\"\")))","v":""},0,null,null,{"$f":"LOOKUP(temp!A6,$C$42:$D$45)","v":0}]
[null,null,null,null,{"$f":"IF(temp!A7=1,\"9 feet\",IF(temp!A7=2,\"12 feet\",IF(temp!A7=3,\"20 feet\",\"\")))","v":""},0,null,null,{"$f":"LOOKUP(temp!A7,$C$42:$D$45)","v":0}]
[null,null,null,null,{"$f":"IF(temp!A8=1,\"9 feet\",IF(temp!A8=2,\"12 feet\",IF(temp!A8=3,\"20 feet\",\"\")))","v":""},0,null,null,{"$f":"LOOKUP(temp!A8,$C$42:$D$45)","v":0}]
[null,null,null,null,{"$f":"IF(temp!A9=1,\"9 feet\",IF(temp!A9=2,\"12 feet\",IF(temp!A9=3,\"20 feet\",\"\")))","v":""},0,null,null,{"$f":"LOOKUP(temp!A9,$C$42:$D$45)","v":0}]
[null,null,null,null,{"$f":"IF(temp!A10=1,\"9 feet\",IF(temp!A10=2,\"12 feet\",IF(temp!A10=3,\"20 feet\",\"\")))","v":""},0,null,null,{"$f":"LOOKUP(temp!A10,$C$42:$D$45)","v":0}]
[null,null,null,null,{"$f":"IF(temp!A11=1,\"9 feet\",IF(temp!A11=2,\"12 feet\",IF(temp!A11=3,\"20 feet\",\"\")))","v":""},0,null,null,{"$f":"LOOKUP(temp!A11,$C$42:$D$45)","v":0}]
[null,null,null,null,{"$f":"IF(temp!A12=1,\"9 feet\",IF(temp!A12=2,\"12 feet\",IF(temp!A12=3,\"20 feet\",\"\")))","v":""},0,null,null,{"$f":"LOOKUP(temp!A12,$C$42:$D$45)","v":0}]
[null,null,null,null,{"$f":"IF(temp!A13=1,\"9 feet\",IF(temp!A13=2,\"12 feet\",IF(temp!A13=3,\"20 feet\",\"\")))","v":""},0,null,null,{"$f":"LOOKUP(temp!A13,$C$42:$D$45)","v":0}]
[null,null,null,null,{"$f":"IF(temp!A14=1,\"9 feet\",IF(temp!A14=2,\"12 feet\",IF(temp!A14=3,\"20 feet\",\"\")))","v":""},0,null,null,{"$f":"LOOKUP(temp!A14,$C$42:$D$45)","v":0}]
[null,null,null,null,{"$f":"IF(temp!A15=1,\"9 feet\",IF(temp!A15=2,\"12 feet\",IF(temp!A15=3,\"20 feet\",\"\")))","v":""},0,null,null,{"$f":"LOOKUP(temp!A15,$C$42:$D$45)","v":0}]
[null,null,null,null,{"$f":"IF(temp!A16=1,\"9 feet\",IF(temp!A16=2,\"12 feet\",IF(temp!A16=3,\"20 feet\",\"\")))","v":""},0,null,null,{"$f":"LOOKUP(temp!A16,$C$42:$D$45)","v":0}]
[null,null,null,null,{"$f":"IF(temp!A17=1,\"9 feet\",IF(temp!A17=2,\"12 feet\",IF(temp!A17=3,\"20 feet\",\"\")))","v":""},0,null,null,{"$f":"LOOKUP(temp!A17,$C$42:$D$45)","v":0}]
[null,null,null,null,{"$f":"IF(temp!A18=1,\"9 feet\",IF(temp!A18=2,\"12 feet\",IF(temp!A18=3,\"20 feet\",\"\")))","v":""},{"$f":"IF(AND(D25>I25,I25>8),C25*(1+(0.02*(D25-I25))),C25)","v":0},null,null,{"$f":"LOOKUP(temp!A18,$C$42:$D$45)","v":0}]
[null,null,null,null,{"$f":"IF(temp!A19=1,\"9 feet\",IF(temp!A19=2,\"12 feet\",IF(temp!A19=3,\"20 feet\",\"\")))","v":""},0,null,null,{"$f":"LOOKUP(temp!A19,$C$42:$D$45)","v":0}]
[null,null,null,null,{"$f":"IF(temp!A20=1,\"9 feet\",IF(temp!A20=2,\"12 feet\",IF(temp!A20=3,\"20 feet\",\"\")))","v":""},0,null,null,{"$f":"LOOKUP(temp!A20,$C$42:$D$45)","v":0}]
[null,null,null,null,{"$f":"IF(temp!A21=1,\"9 feet\",IF(temp!A21=2,\"12 feet\",IF(temp!A21=3,\"20 feet\",\"\")))","v":""},0,null,null,{"$f":"LOOKUP(temp!A21,$C$42:$D$45)","v":0}]
[null,null,null,null,{"$f":"IF(temp!A22=1,\"9 feet\",IF(temp!A22=2,\"12 feet\",IF(temp!A22=3,\"20 feet\",\"\")))","v":""},0,null,null,{"$f":"LOOKUP(temp!A22,$C$42:$D$45)","v":0}]
[null,null,null,null,{"$f":"IF(temp!A23=1,\"9 feet\",IF(temp!A23=2,\"12 feet\",IF(temp!A23=3,\"20 feet\",\"\")))","v":""},0,null,null,{"$f":"LOOKUP(temp!A23,$C$42:$D$45)","v":0}]
[null,null,null,null,{"$f":"IF(temp!A24=1,\"9 feet\",IF(temp!A24=2,\"12 feet\",IF(temp!A24=3,\"20 feet\",\"\")))","v":""},0,null,null,{"$f":"LOOKUP(temp!A24,$C$42:$D$45)","v":0}]
[null,null,null,null,{"$f":"IF(temp!A25=1,\"9 feet\",IF(temp!A25=2,\"12 feet\",IF(temp!A25=3,\"20 feet\",\"\")))","v":""},0,null,null,{"$f":"LOOKUP(temp!A25,$C$42:$D$45)","v":0}]
[null,null,null,null,{"$f":"IF(temp!A26=1,\"9 feet\",IF(temp!A26=2,\"12 feet\",IF(temp!A26=3,\"20 feet\",\"\")))","v":""},0,null,null,{"$f":"LOOKUP(temp!A26,$C$42:$D$45)","v":0}]
[null,null,null,null,{"$f":"IF(temp!A27=1,\"9 feet\",IF(temp!A27=2,\"12 feet\",IF(temp!A27=3,\"20 feet\",\"\")))","v":""},0,null,null,{"$f":"LOOKUP(temp!A27,$C$42:$D$45)","v":0}]
[null,null,null,null,{"$f":"IF(temp!A28=1,\"9 feet\",IF(temp!A28=2,\"12 feet\",IF(temp!A28=3,\"20 feet\",\"\")))","v":""},0,null,null,{"$f":"LOOKUP(temp!A28,$C$42:$D$45)","v":0}]
[null,null,null,null,{"$f":"IF(temp!A29=1,\"9 feet\",IF(temp!A29=2,\"12 feet\",IF(temp!A29=3,\"20 feet\",\"\")))","v":""},0,null,null,{"$f":"LOOKUP(temp!A29,$C$42:$D$45)","v":0}]
[null,null,null,null,{"$f":"IF(temp!A30=1,\"9 feet\",IF(temp!A30=2,\"12 feet\",IF(temp!A30=3,\"20 feet\",\"\")))","v":""},0,null,null,{"$f":"LOOKUP(temp!A30,$C$42:$D$45)","v":0}]
[null,null,null,null,{"$f":"IF(temp!A31=1,\"9 feet\",IF(temp!A31=2,\"12 feet\",IF(temp!A31=3,\"20 feet\",\"\")))","v":""},0,null,null,{"$f":"LOOKUP(temp!A31,$C$42:$D$45)","v":0}]
[null,null,"** From Table 15-1 based on exceptions listed in footnotes"]
[]
[]
[9,null,1,9]
[12,null,2,12]
[20,null,3,20]
[null,null,4,0]

{"sheet":"LTG-CHK","index":10,"n_rows":94,"n_cols":6,"rows_kept":94,"cut":false,"hidden":false,"merged":[[70,0,70,5],[6,0,7,0],[6,1,7,1],[6,2,7,2],[8,0,10,0],[8,1,10,1],[8,2,10,2],[12,0,13,0],[12,1,13,1],[12,2,13,2],[14,0,15,0],[14,1,15,1],[14,2,15,2],[17,0,18,0],[17,1,18,1],[17,2,18,2],[19,0,20,0],[19,1,20,1],[19,2,20,2],[22,0,23,0],[22,1,23,1],[22,2,23,2],[24,0,25,0],[24,1,25,1],[24,2,25,2],[45,0,47,0],[45,1,47,1],[45,2,47,2],[26,0,27,0],[26,1,27,1],[26,2,27,2],[35,0,38,0],[35,1,38,1],[35,2,38,2],[31,0,33,0],[31,1,33,1],[31,2,33,2]]}
["Lighting, Motor, and Transformer Permit Documents Checklist",null,null,null,null,"LTG-CHK"]
[{"$f":"'LTG-SUM'!A2","v":"2012 Washington State Energy Code Compliance Forms for Commercial Buildings including R2 & R3 over 3 stories and all R1 "},null,null,null,null,{"$f":"'LTG-SUM'!G2","v":"Revised Jan 2014"}]
["Project Address",null,{"$f":"IF('LTG-SUM'!C3=\"1 - This address line will copy onto other forms\",\"Fill this line out on LGT-SUM\",'LTG-SUM'!C3)","v":"Baxter Mini-Storage Bldg."},null,"Date",{"$f":"'LTG-SUM'!G3","v":"2015-09-07"}]
[]
["Applicability (yes,no,na)","Code Section","Component","Compliance information required in permit documents","Location in Documents","Building Department Notes"]
["LIGHTING CONTROLS (Section C405.2)"]
["Yes","C405.2.1.1 C405.2.1.2","Manual interior lighting controls","Indicate on plans the manual control type & locations served;","Addendum"]
[null,null,null,"Indicate of plans the 50% lighting load reduction method provided or identify exception taken "]
["Yes","C405.2.2.1","Automatic time switch controls and override switching","Indicate lighting system automatic shut-off capability - identify lighting zone areas served on plans;"]
[null,null,null,"Indicate locations of override switches on plans and the areas served, include area sq. ft.;"]
[null,null,null,"Indicate locations where automatic shutoff is provided by other methods (occupancy sensor, daylight controls, etc)","Addendum"]
["NA","C405.2.2.2","Occupancy sensors","Indicate on plans the locations served by occupancy sensors"]
["NA","C405.2.2.3","Daylight zones - Vertical fenestration and skylights","Indicate vertical fenestration primary and secondary daylight zone areas on plans, include sq. ft.;"]
[null,null,null,"Indicate skylight daylight zone areas on plans, include sq. ft."]
["NA","C405.2.2.3.2","Daylight zone controls","Indicate on plans the locations served by daylight zone controls;"]
[null,null,null,"Indicate in plans the lighting load reduction (dimming) method - stepped or continuous dimming"]
["Yes","C405.2.3","Specific application lighting controls - General","Indicate on plans the locations served by specific application lighting controls","Addendum"]
["NA","C405.2.3 - Items 1&2","Display and accent lighting","Indicate lighting control method for display and accent lighting, and display case lighting;"]
[null,null,null,"Indicate these fixtures are controlled independently from both general area lighting and other lighting applications within the same space "]
["NA","C405.2.3 - Item 3","Hotel/motel guest rooms","Provide a lighting control device at each guest room entry for all permanently installed fixtures in guest room;"]
[null,null,null,"Indicated whether lighting control is manual or automatic"]
["Yes","C405.2.3 - Item 4","Supplemental task lighting ","Provide automatic shut-off vacancy controls for supplemental task lighting, including under-shelf or under-cabinet lighting","Addendum"]
["NA","C405.2.3 - Item 5","Lighting for non-visual applications","Identify eligible non-visual applications and method of lighting control;"]
[null,null,null,"Indicate these fixtures are controlled independently from both general area lighting and other lighting applications within the same space "]
["NA","C405.2.3 - Item 6","Lighting equipment for sale or demonstration","Indicate lighting control method for lighting equipment for sale or demonstration;"]
[null,null,null,"Indicate these fixtures are controlled independently from both general area lighting and other lighting applications within the same space "]
["Yes","C405.2.3 - Item 7","Means of egress lighting","If egress lighting power density is greater than 0.05W/ft2, indicate method of automatic shut-off  during unoccupied periods;"]
[null,null,null,"Identify on plans the egress fixtures that function as both normal and emergency means of egress illumination"]
["NA","C405.10 C405.11","Cooler and freezer lighting","Provide vacancy device or timer to turn off fixtures within 15 minutes of unoccupancy for cooler and freezer lighting fixtures with lamp efficacy less than 40 lumens per watt"]
["Yes","C405.2.4","Exterior lighting controls ","Indicate on exterior lighting plans the automatic lighting control method and locations served","Addendum"]
["NA","C405.6.1","Exterior building grounds lighting controls","Provide motion sensor controls for building grounds fixtures rated at greater than 100 watts with lamp efficacy less than 60 lumens, or identify exception taken"]
["NA","C408.3","Lighting system functional testing","Identify applicable commissioning documentation requirements per Section C408 or eligibility for exception;"]
[null,null,null,"Provide written procedures for functional testing of all automatic controls and describe the expected system response;"]
[null,null,null,"Identify in construction documents the party responsible for functional testing of automatic lighting controls"]
["INTERIOR LIGHTING POWER & EFFICACY (Sections C405.5, C405.10, C405.11)"]
["Yes","C405.5.1 C405.5.1.1 C405.5.1.2 C405.5.1.3 C405.5.1.4","Total connected interior lighting power","Provide fixture schedule with fixture types, lamps, ballasts, and rated watts per fixture;","Addendum"]
[null,null,null,"Identify spaces eligible for lighting power exemption on plans and in compliance forms;"]
[null,null,null,"Identify lighting equipment eligible for exemption in fixture schedule and in compliance forms;"]
[null,null,null,"Indicate that exempt lighting equipment is in addition to general area lighting and is controlled independently"]
["Yes","C405.4","Exit signs","Provide exit sign types and rated watts per fixture in fixture schedule (maximum 5 watts per fixture)"]
["NA","C405.10 C405.11","Cooler and freezer lighting","For lighting in walk-in coolers and freezers, and refrigerated warehouse coolers and freezers, provide rated lamp efficacy (in lumens per watt) in fixture schedule"]
[null,"Lighting Power Calculation - Indicate compliance path taken"]
["Yes","C405.5.2","Building Area Method","Complete required compliance forms – proposed wattage per building area does not exceed maximum allowed wattage per building area. Identify locations of building areas on plans"]
["NA","C405.5.2","Space-By-Space Method ","Complete required compliance forms – total proposed wattage does not exceed maximum allowed wattage. Identify locations of space types on plans, including retail display areas as applicable"]
["EXTERIOR LIGHTING POWER & EFFICACY (Section C405.6)"]
["Yes","C405.6.2","Total connected exterior lighting power","Provide fixture schedule with fixture types, lamps, ballasts, and rated watts per fixture;","Addendum"]
[null,null,null,"Identify exterior applications eligible for lighting power exemption on plans and in compliance forms;"]
[null,null,null,"Indicate that exempt exterior lighting is controlled independently from non-exempt exterior lighting "]
["Yes","Table C405.6.2(1)","Exterior lighting zone","Indicate building exterior lighting zone as defined by the AHJ"]
["NA"," C405.6.1","Exterior building grounds lighting","For building grounds fixtures rated at greater than 100 watts, provide rated lamp efficacy (in lumens per watt) in fixture schedule"]
["Yes","C405.6.2","Exterior lighting power calculations","Complete required compliance form – proposed wattage for exterior lighting plus base site allowed does not exceed maximum allowed"]
["MOTORS & TRANSFORMERS (Sections C405.8, C405.9)"]
["NA","C405.8","Electric Motors","For motors not part of an HVAC system, provide electric motor schedule on electrical plans with hp, rpm, and rated efficiency"]
["NA","C405.9","Transformers","Provide distribution transformer schedule on electrical plans with transformer size and efficiency"]
["If \"no\" is selected for any question, provide explanation:"]
[]
[]
[]
[]
[]
[]
["  Yes"]
["  No"]
["  N.A."]
[]
[]
[]
[]
[]
[]
["End of Lighting, Motor & Transformer Permit Documents Checklist"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["NA"]
["No"]
["Yes"]