{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["ReadMe","LTG-SUM","LTG-INT-SPACE","LTG-INT-DISPLAY","LTG-INT-BLD","LTG-INT-REF","LTG-EXT","LTG-EXT-REF","LTG-CHK"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":73,"comments":1,"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"]
["2015 Washington State Energy Code Compliance Forms for Commercial Buildings including R2, R3, R4 over 3 stories and all R1 "]
[null,"Revised August 2016"]
[null,"     Commercial Provision Chapters 1 - 5 of the 2015 Washington State Energy Code apply to all commercial occupancies, R-2, R-3 and R-4 occupancies greater than 3 stories above grade, and R-1 occupancy (all building heights)."]
["Intro","     This file, LTG15-v1.XLSM, has electronic compliance forms for electrical power and lighting system provisions as defined in Section C405 and Chapter 5. This includes interior and exterior lighting systems, electric motors, and transformers. There are two companion files: ENV15-v1.XLSM (Sections C303, C402, Chapter 5, and Appendix A envelope requirements) and MECH15-v1.XLSM (Section C403 and Chapter 5 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 2015 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 2015 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 and if applicable Enable Content. "]
["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 multiple pages. All pages are available on screen when you select the tab for a form (worksheet). Use the scroll bars or page down key to find additional pages 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."]
["Calculation Area","    You must select a Calculation Area on LTG-INT-SPACE or LTG-INT-BLD to enable the calculations in these forms."]
["LPA Calculation Type","    You must select a LPA Calculation Type on LTG-INT-SPACE or LTG-INT-BLD to enable the calculations in these forms."]
["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.B54"]
["Instructions for Electronic Forms, pg 2"]
[{"$f":"A2","v":"2015 Washington State Energy Code Compliance Forms for Commercial Buildings including R2, R3, R4 over 3 stories and all R1 "}]
[null,{"$f":"B3","v":"Revised August 2016"}]
["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 and any space utilizing the additional lighting wattage allowance based on ceiling height per Footnotes d thru f, provide total gross interior area and ceiling height (above finished floor) in the Maximum Allowed Lighting Wattage table."]
[null,"     All 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 Retail Display Allowance, Lobby Art/Exhibit Allowance and Proposed Retail Display Lighting cells. "]
["Interior LTG Retail Display","     For projects with eligible Retail Sales display lighting that is in addition to Retail Sales general area lighting, select the Retail Display category per Section C405.4.2.2.1 from the drop down menu provided, and enter the total gross interior area of the footprint illuminated by display lighting in the Maximum Allowed Retail Display Lighting Wattage table. Assign a corresponding Retail Display category to each lighting fixture type defined in the Proposed Retail Display Lighting Wattage table using the drop down menu. "]
[null,"     For projects with eligible Lobby Art/Exhibit display lighting that is in addition to Lobby general area lighting, enter a unique name for each Lobby that this allowance will be applied to, and enter the total gross interior area of the Lobby in the Maximum Allowed Lobby Art/Exhibit Display Lighting Wattage table. Assign a corresponding Lobby to each lighting fixture type defined in the Proposed Lobby Art/Exhibit Display Lighting Wattage table. "]
[null,"     The total Retail Display and Lobby Art/Exhibit Display gross interior areas entered in the LTG-INT-DISPLAY worksheet may not exceed the total Retail Sales and Lobby Art/Exhibit Display gross interior areas 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, delete all of the heading information at the beginning of LTG-SUM.  For less than 50% alterations, select the Calculation area in the LTG-INT-SPACE form before printing. "]
[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":"LTG-SUM","index":1,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":false,"merged":[[23,2,23,3],[17,2,17,3],[19,2,19,3],[18,2,18,3],[21,2,21,3],[22,2,22,3],[37,0,37,1],[31,2,35,6],[41,0,41,1],[43,0,43,1],[2,2,2,4],[3,2,3,4],[4,2,4,4],[5,2,5,4],[6,2,6,4],[12,2,12,4],[13,2,13,4],[14,2,14,4],[7,2,7,4],[8,2,8,4],[24,2,24,3],[16,2,16,3]]}
["Lighting Summary",null,null,null,null,null,"LGT-SUM"]
[{"$f":"ReadMe!A2","v":"2015 Washington State Energy Code Compliance Forms for Commercial Buildings including R2, R3, R4 over 3 stories and all R1 "},null,null,null,null,null,{"$f":"ReadMe!B3","v":"Revised August 2016"}]
["Project Info","Project Title:","1 - This title will copy onto other forms",null,null,"Date","2016-07-01"]
[null,null,null,null,null,"For Building Department Use"]
[null,"Company Name:"]
[null,"Company Address:"]
[null,"Applicant Name:"]
[null,"Applicant Phone:"]
[null,"Applicant Email:"]
[]
["Project Description",null,null,null,null,false]
[]
["Building Additions",null,"Compliance Method",null,null,"Interior lighting","Exterior lighting"]
[]
[]
[]
["Interior and Exterior",null,"Lighting Power",null,"Interior lighting","Parking garage","Exterior lighting"]
["Lighting Alterations"]
[]
[]
[]
[null,null,"Lighting Controls",null,"Interior lighting","Parking garage","Exterior lighting"]
[]
[]
[]
[]
["Change of Space Use"]
[]
["Lighting Summary, cont.",null,null,null,null,null,"LGT-SUM"]
[{"$f":"A2","v":"2015 Washington State Energy Code Compliance Forms for Commercial Buildings including R2, R3, R4 over 3 stories and all R1 "},null,null,null,null,null,{"$f":"G2","v":"Revised August 2016"}]
["Project Title:",{"$f":"IF('LTG-SUM'!C3=\"1 - This title will copy onto other forms\",\"Fill this line out at top of LGT-SUM\",'LTG-SUM'!C3)","v":"Fill this line out at top of LGT-SUM"},null,null,null,"Date",{"$f":"G3","v":"2016-07-01"}]
["Interior Lighting System "]
["Description"]
[]
[]
[]
[]
["Interior Lighting Power Allowance Method"]
[]
["Interior Lighting Controls",null,null,null,null,false]
[]
["Dwelling Unit Interior Lighting"]
[]
["Exterior Lighting System Description"]

{"sheet":"LTG-INT-SPACE","index":2,"n_rows":178,"n_cols":11,"rows_kept":178,"cut":false,"hidden":false,"merged":[[44,10,46,10],[3,0,4,0],[22,0,23,5]]}
["Interior Lighting - Space-By-Space Method",null,null,null,null,"LTG-INT-SPACE"]
[{"$f":"'LTG-SUM'!A2","v":"2015 Washington State Energy Code Compliance Forms for Commercial Buildings including R2, R3, R4 over 3 stories and all R1 "},null,null,null,null,{"$f":"'LTG-SUM'!G2","v":"Revised August 2016"}]
["Project Title:",{"$f":"IF('LTG-SUM'!C3=\"1 - This title will copy onto other forms\",\"Fill this line out on LGT-SUM\",'LTG-SUM'!C3)","v":"Fill this line out on LGT-SUM"},null,null,{"$f":"'LTG-SUM'!F3","v":"Date"},{"$f":"'LTG-SUM'!G3","v":"2016-07-01"}]
["Calculation Area NOTE 9",null,null,null,{"$f":"'LTG-SUM'!F4","v":"For Building Department Use"}]
[]
[]
[]
["LPA Calculation Type"]
[]
["Maximum Allowed Lighting Wattage NOTE 1"]
["Location (plan #,\n room #)","Space Type","Ceiling \nHeight NOTE 2","Gross Interior \nArea in ft2","Allowed\nWatts per ft2","Watts Allowed\n(watts/ft2 x area)"]
[null,null,null,null,{"$f":"IF(B12=\"\",0,IF(B12=\"Atrium\",IF(ISNUMBER(C12),MIN(C12,40)*0.02+MAX(C12-40,0)*0.02+IF(C12>40,0.03,0),0),VLOOKUP(B12,$B$67:$C$165,2,FALSE)*IF(ISNUMBER(C12),MAX(1,1+0.02*(C12-VLOOKUP(B12,$B$67:$D$165,3,FALSE))),1)))","v":0},{"$f":"IF(IntCalculationScopeSBS=1,0,E12*D12)","v":0}]
[null,null,null,null,{"$f":"IF(B13=\"\",0,IF(B13=\"Atrium\",IF(ISNUMBER(C13),MIN(C13,40)*0.02+MAX(C13-40,0)*0.02+IF(C13>40,0.03,0),0),VLOOKUP(B13,$B$67:$C$165,2,FALSE)*IF(ISNUMBER(C13),MAX(1,1+0.02*(C13-VLOOKUP(B13,$B$67:$D$165,3,FALSE))),1)))","v":0},0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0,null,null,null,null,1]
[]
[null,null,"Total Area",{"$f":"SUM(D12:D18)","v":0}]
[null,null,null,null,"Retail Display Allowance from LTG-INT-DISPLAY",{"$f":"IF(IntAlt_LT50pctSBS,0,'LTG-INT-DISPLAY'!F35)","v":0}]
[null,null,null,null,{"$f":"IF(IntAlt_LT50pctSBS,\"Enter Total Existing Lighting Watts (prior to Alteration)\",\"\")","v":""}]
[null,"Lobby Art/Exhibit Display Allowance from LTG-INT-DISPLAY NOTE 8",{"$f":"'LTG-INT-DISPLAY'!F64","v":0},null,"Allowed Watts",{"$f":"IF(IntAlt_LT50pctSBS,F21,ROUNDUP(SUM(F12:F21),0))","v":0}]
[{"$f":"IF(OR(ISNA(RetailAllowance),ISNA(F39)),\n      \"ERROR - Retail display data on LTG-INT-DISPLAY is incomplete\",\n       IF(ISNA(LobbyArtAllowance),\n              \"ERROR - Lobby art/exhibit lighting data on LTG-INT-DISPLAY is incomplete\",\n               IF(NOT(ISERROR(FIND(\"DOES NOT COMP\",'LTG-INT-DISPLAY'!F84))),\n                       \"ERROR - Lobby art/exhibit lighting does not comply\",\n                        IF(OR(F22>0,F41>0),\n                             IF(intCalcScopeSBSset,\n                                    IF(CalcTypeSBSset,\n                                        \"\",\n                                       \"ERROR - LPA Calculation Type Not Set. \"),\n                               \"ERROR - Calculation Area Not Set. \"), \"\"))))","v":""}]
[]
[]
["Proposed Lighting Wattage NOTE 3"]
["Location (plan #,\n room #)","Fixture Description NOTE 4, 5, 6","Number of \nFixtures","Watts/\nFixture NOTE 7",null,"Watts \nProposed"]
[null,null,null,null,null,{"$f":"C28*D28","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,{"$f":"C38*D38","v":0},null,null,null,null,1]
[null,null,null,null,"Proposed Retail Display Lighting from LTG-INT-DISPLAY",{"$f":"'LTG-INT-DISPLAY'!F33","v":0}]
[]
[null,null,null,null,"Total Proposed Watts",{"$f":"ROUND(SUM(F28:F39),0)","v":0}]
[]
["Interior Lighting Power Allowance",null,null,null,null,{"$f":"IF(ISERROR(FIND(\"ERROR\",A23)),\n             IF(AND(F22=0,F41=0),\"\",\n                  IF(ROUND(F41,0)>ROUND(F22,0),\n                          \"DOES NOT COMPLY\",\n                           IF(CalcTypeSBS<>2,\n                               \"COMPLIES\",\n                                IF(ROUND(F41,0)>ROUND(F22*0.75,0),\n                                       \"DOES NOT COMPLY WITH C406.3\",\n                                         \"COMPLIES WITH C406.3\")))),\n            \"CALCULATION ERROR\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Count","Area"]
["retail sales Zones",{"$f":"COUNTIF(B12:B20,\"*Sales area\")","v":0},{"$f":"SUMIF(B12:B20,\"*Sales area\",D12:D20)","v":0}]
["lobby",{"$f":"COUNTIF(B12:B20,\"Lobby*\")","v":0},{"$f":"SUMIF(B12:B20,\"Lobby*\",D12:D20)","v":0}]
[]
["2012 Space-by-Space areas","2015 Space-by-Space areas","maxlpd","ceilinghgt"]
["Atrium","Atrium"]
["Audience/seating area: auditorium","Audience/seating area (permanent): auditorium",0.5,20]
["Convention center: Audience/seating area","Audience/seating area (permanent): convention center",0.66,20]
["Gymnasium/fitness center: Gymnasium audience/seating","Audience/seating area (permanent): gymnasium",0.34,20]
["Audience/seating area: motion picture theater","Audience/seating area (permanent): motion picture theater",0.91,20]
["Court/police/penitentiary: Penitentiary audience seating","Audience/seating area (permanent): penitentiary",0.22,20]
["Audience/seating area: performing arts theater","Audience/seating area (permanent): performing arts theater",1.94,20]
["Religious building: Audience seating","Audience/seating area (permanent): religious building",1.22,20]
["Sports arena: Audience seating","Audience/seating area (permanent): sports arena",0.34,20]
[null,"Audience/seating area (permanent): other",0.34,20]
["Bank/office ‑ Banking activity area","Banking activity area",0.81,20]
[null,"Breakroom (see Lounge/breakroom)",0,20]
["Classroom/lecture/training","Classroom/lecture/training",1,20]
["Court/police/penitentiary: Penitentiary classroom","Classroom/lecture/training: penitentiary",1.07,20]
["Conference/meeting/multipurpose","Conference/meeting/multipurpose",0.98,20]
[null,"Copy/print room",0.57999999999999996,20]
[null,"Corridor: facility for the visually impaired",0.74,20]
["Health care clinic/hospital: Corridors/transition","Corridor: hospital",0.63,20]
["Manufacturing: Corridors/transition","Corridor: manufacturing",0.33,20]
["Corridor/transition","Corridor: all other",0.53,20]
["Court/police station/penitentiary: Courtroom","Courtroom",1.38,20]
[null,"Computer room",1.37,20]
["Court/police/penitentiary: Penitentiary dining","Dining area: penitentiary",0.77,20]
[null,"Dining area: facility for the visually impaired",1.52,20]
["Dining area: Bar/lounge/leisure dining","Dining area: Bar/lounge/leisure dining",0.86,20]
["Dining area: Family dining area","Dining area: Family dining area",0.71,20]
[null,"Dining area: all other",0.52,20]
["Electrical/mechanical","Electrical/mechanical",0.76,20]
[null,"Emergency vehicle garage",0.45,20]
["Food preparation","Food preparation",0.79,20]
[null,"Guest room",0.38,20]
["Laboratory for classrooms","Laboratory for classrooms",1.02,20]
["Laboratory for medical/industrial/research","Laboratory for medical/industrial/research",1.45,20]
[null,"Laundry/washing area",0.48,20]
[null,"Loading dock, interior",0.38,20]
[null,"Lobby: facility for the visually impaired",1.44,20]
[null,"Lobby: elevator",0.51,20]
["Hotel: Hotel lobby","Lobby: hotel",0.85,20]
["Lobby for motion picture theater","Lobby: motion picture theater",0.42,20]
["Lobby for performing arts theater","Lobby: performing arts theater",1.6,20]
["Lobby","Lobby: all other",0.72,20]
["Locker room","Locker room",0.6,20]
["Lounge recreation","Lounge/breakroom: health care facility",0.74,20]
["Lounge recreation","Lounge/breakroom: all other",0.57999999999999996,20]
["Office - Enclosed","Office: Enclosed",0.89,9]
["Office - Open plan","Office: Open plan",0.78,9]
["Parking garage ‑ Garage areas","Parking area, interior",0.15,20]
["Health care clinic/hospital: Pharmacy","Pharmacy area",0.91,20]
[null,"Restroom: facility for the visually impaired",0.97,20]
["Restroom","Restroom: all other",0.78,20]
["Sales area","Sales area",1.27,20]
[null,"Seating area, general",0.43,20]
[null,"Stairway (see space containing stairway)",0,20]
["Stairway","Stairwell",0.55000000000000004,20]
["Storage","Storage room",0.5,20]
["Automotive ‑ Service/repair","Vehicular maintenance",0.54,20]
["Workshop","Workshop",1.27,20]
[null,"Automotive - See Vehicular maintenance)",0,20]
["Convention center: Exhibit space","Convention center: Exhibit space",1.1599999999999999,20]
["Dormitory living quarters","Dormitory living quarters",0.3,20]
[null,"Facility for the visually impaired: Chapel",1.77,20]
[null,"Facility for the visually impaired: Recreation room",1.93,20]
["Fire stations: Engine rooms","Fire stations: Engine rooms",0.45,20]
["Fire stations: Sleeping quarters","Fire stations: Sleeping quarters",0.18,20]
["Gymnasium/fitness center: Fitness area","Gymnasium/fitness center: Exercise area",0.57999999999999996,20]
["Gymnasium/fitness center: Playing area","Gymnasium/fitness center: Playing area",0.96,20]
["Health care clinic/hospital: Exam/treatment","Health care facility: Exam/treatment",1.33,20]
["Health care clinic/hospital: Radiology/imaging","Health care facility: Imaging room",1.06,20]
["Health care clinic/hospital: Medical supplies","Health care facility: Medical supplies",0.59,20]
["Health care clinic/hospital: Nursery","Health care facility: Nursery",0.7,20]
["Health care clinic/hospital: Nurse station","Health care facility: Nurse station",0.56999999999999995,20]
["Health care clinic/hospital: Operating room","Health care facility: Operating room",1.51,20]
["Health care clinic/hospital: Patient room","Health care facility: Patient room",0.5,20]
["Health care clinic/hospital: Physical therapy","Health care facility: Physical therapy",0.73,20]
["Health care clinic/hospital: Recovery","Health care facility: Recovery",0.92,20]
["Library: Reading area","Library: Reading area",0.74,9]
["Library: Stacks","Library: Stacks",1.37,9]
["Manufacturing: Detailed manufacturing","Manufacturing: Detailed manufacturing",1.03,20]
["Manufacturing: Equipment room","Manufacturing: Equipment room",0.59,20]
["Manufacturing: Extra high bay (> 50 ft floor-ceiling ht.)","Manufacturing: Extra high bay (> 50 ft floor-ceiling ht.)",0.84,20]
["Manufacturing: High bay (25 ‑ 50 ft floor-ceiling ht.)","Manufacturing: High bay (25 ‑ 50 ft floor-ceiling ht.)",0.98,20]
["Manufacturing: Low bay (< 25 ft floor-ceiling ht.)","Manufacturing: Low bay (< 25 ft floor-ceiling ht.)",0.95,20]
["Museum: General exhibition","Museum: General exhibition",0.84,20]
["Museum: Restoration","Museum: Restoration",0.82,20]
["Dressing/fitting room performing arts theater","Performing arts theater: Dressing/fitting room ",0.32,20]
["Post office: Sorting area","Post office: Sorting area",0.75,20]
["Religious building: Fellowship hall","Religious building: Fellowship hall",0.51,20]
["Religious building: Worship pulpit/choir","Religious building: Worship pulpit/choir",1.22,20]
["Retail: Dressing/fitting area","Retail: Dressing/fitting area",0.56999999999999995,20]
["Retail: Mall concourse","Retail: Mall concourse",0.88,20]
["Sports arena: Court sports area ‑ Class 1","Sports arena: Court sports area ‑ Class 1",2.41,20]
["Sports arena: Court sports area ‑ Class 2","Sports arena: Court sports area ‑ Class 2",1.54,20]
["Sports arena: Court sports area ‑ Class 3","Sports arena: Court sports area ‑ Class 3",0.96,20]
["Sports arena: Court sports area ‑ Class 4","Sports arena: Court sports area ‑ Class 4",0.57999999999999996,20]
["Transportation: Air/train/bus baggage area","Transportation: Baggage/carousel area",0.42,20]
["Transportation: Airport concourse","Transportation: Airport concourse",0.28999999999999998,20]
["Transportation: Terminal ‑ Ticket counter","Transportation: Terminal ‑ Ticket counter",0.64,20]
["Warehouse: Fine material storage","Warehouse: Medium/bulky palletized items",0.46,20]
["Warehouse: Medium/bulky material","Warehouse: Smaller, hand carried items",0.76,20]
[]
[]
[]
[]
["2012 categories not used in 2015"]
["Transportation: Audience seating","now either audience/seating (permanent): all other or Seating area, general"]
["Hotel: Guest rooms","now just single Guest rooms"]
["Hotel: Highway lodging guest rooms","now just single Guest rooms"]
["Hotel: Dining area","now Dining: All other"]
["Health care clinic/hospital: Emergency","now done like other spaces with exam room, nurses station and such"]
["Library: Card file and cataloguing","not sure"]
["Court/police station/penitentiary: Confinement cells"]
["Court/police station/penitentiary: Judge chambers"]

{"sheet":"LTG-INT-DISPLAY","index":3,"n_rows":102,"n_cols":9,"rows_kept":102,"cut":false,"hidden":false,"merged":[[55,1,55,2],[56,1,56,2],[57,1,57,2],[58,1,58,2],[59,1,59,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2]]}
["Interior Display Lighting - Space-by-Space",null,null,null,null,"LTG-INT-DISPLAY"]
[{"$f":"'LTG-SUM'!A2","v":"2015 Washington State Energy Code Compliance Forms for Commercial Buildings including R2, R3, R4 over 3 stories and all R1 "},null,null,null,null,{"$f":"'LTG-SUM'!G2","v":"Revised August 2016"}]
[{"$f":"'LTG-SUM'!B3","v":"Project Title:"},{"$f":"IF('LTG-SUM'!C3=\"1 - This title will copy onto other forms\",\"Fill this line out on LGT-SUM\",'LTG-SUM'!C3)","v":"Fill this line out on LGT-SUM"},null,null,{"$f":"'LTG-SUM'!F3","v":"Date"},{"$f":"'LTG-SUM'!G3","v":"2016-07-01"}]
[null,null,null,null,{"$f":"'LTG-SUM'!F4","v":"For Building Department Use"}]
[]
["Maximum Allowed Retail Display Lighting Wattage"]
["Location (plan #,\n room #)","Retail Sales Area Type NOTE 1",null,"Gross Interior \nArea in ft2","Allowed Watts\n per ft2  NOTE 2","Watts Allowed\n(watts/ft2 x area)"]
[null,null,null,null,{"$f":"IF(B8=\"\",0,VLOOKUP(B8,$E$91:$F$94,2,FALSE))","v":0},{"$f":"IF(B8=\"\",\"\",IF(ISNA(IF(VLOOKUP(VLOOKUP(B8,$E$91:$G$94,3,FALSE),$D$97:$E$100,2,0)>0,\"\",NA())),\"No display\",E8*D8))","v":""},{"$f":"IF(ISNA(INDEX(B$8:B$12,MATCH(0,COUNTIF(G$7:$G7,B$8:B$12),0))),\"\",INDEX(B$8:B$12,MATCH(0,COUNTIF(G$7:$G7,B$8:B$12),0)))","v":0},{"$f":"D8*E8","v":0}]
[null,null,null,null,{"$f":"IF(B9=\"\",0,VLOOKUP(B9,$E$91:$F$94,2,FALSE))","v":0},{"$f":"IF(B9=\"\",\"\",IF(ISNA(IF(VLOOKUP(VLOOKUP(B9,$E$91:$G$94,3,FALSE),$D$97:$E$100,2,0)>0,\"\",NA())),\"No display\",E9*D9))","v":""},{"$f":"IF(ISNA(INDEX(B$8:B$12,MATCH(0,COUNTIF(G$7:$G8,B$8:B$12),0))),\"\",INDEX(B$8:B$12,MATCH(0,COUNTIF(G$7:$G8,B$8:B$12),0)))","v":""},{"$f":"D9*E9","v":0},{"$f":"IF(ISNA(INDEX(G$8:G$12,MATCH(0,COUNTIF(I$7:$I8,G$8:G$12),0))),\"\",INDEX(G$8:G$12,MATCH(0,COUNTIF(I$7:$I8,G$8:G$12),0)))","v":0}]
[null,null,null,null,{"$f":"IF(B10=\"\",0,VLOOKUP(B10,$E$91:$F$94,2,FALSE))","v":0},{"$f":"IF(B10=\"\",\"\",IF(ISNA(IF(VLOOKUP(VLOOKUP(B10,$E$91:$G$94,3,FALSE),$D$97:$E$100,2,0)>0,\"\",NA())),\"No display\",E10*D10))","v":""},{"$f":"IF(ISNA(INDEX(B$8:B$12,MATCH(0,COUNTIF(G$7:$G9,B$8:B$12),0))),\"\",INDEX(B$8:B$12,MATCH(0,COUNTIF(G$7:$G9,B$8:B$12),0)))","v":""},{"$f":"D10*E10","v":0},{"$f":"IF(ISNA(INDEX(G$8:G$12,MATCH(0,COUNTIF(I$7:$I9,G$8:G$12),0))),\"\",INDEX(G$8:G$12,MATCH(0,COUNTIF(I$7:$I9,G$8:G$12),0)))","v":""}]
[null,null,null,null,{"$f":"IF(B11=\"\",0,VLOOKUP(B11,$E$91:$F$94,2,FALSE))","v":0},{"$f":"IF(B11=\"\",\"\",IF(ISNA(IF(VLOOKUP(VLOOKUP(B11,$E$91:$G$94,3,FALSE),$D$97:$E$100,2,0)>0,\"\",NA())),\"No display\",E11*D11))","v":""},{"$f":"IF(ISNA(INDEX(B$8:B$12,MATCH(0,COUNTIF(G$7:$G10,B$8:B$12),0))),\"\",INDEX(B$8:B$12,MATCH(0,COUNTIF(G$7:$G10,B$8:B$12),0)))","v":""},{"$f":"D11*E11","v":0},{"$f":"IF(ISNA(INDEX(G$8:G$12,MATCH(0,COUNTIF(I$7:$I10,G$8:G$12),0))),\"\",INDEX(G$8:G$12,MATCH(0,COUNTIF(I$7:$I10,G$8:G$12),0)))","v":""}]
[]
[null,null,"Total Retail With Display Area",{"$f":"SUM(D8:D12)","v":0},"Total Watts",{"$f":"IF(SUM(F8:F12)>0,SUM(F8:F12),0)","v":0}]
[]
[null,null,null,null,"Retail Display Lighting Base Allowance",{"$f":"IF(SUM(F8:F12)>0,500,0)","v":0}]
[]
[null,null,null,null,"Maximum Retail Display Allowance NOTE 3",{"$f":"IF(D13=0,0,IF(NOT(ISERROR(FIND(\"ERROR\",B18))),NA(),F13+F15))","v":0}]
[null,{"$f":"IF(D13>0, IF(RetailAreas=0,\"ERROR - Sales area required in LTG-INT-SPACE for Retail Sales Display Allowance\",IF(RetailAreaSF<'LTG-INT-DISPLAY'!D13,\"ERROR - Retail sales display area exceeds total Sales area entered  in LTG-INT-SPACE\",\"\")),\"\")","v":""}]
["Proposed Retail Display Lighting Wattage NOTE 4"]
["Retail Area","Location (plan #,\n room #)","Fixture Description NOTE 5","Number of \nFixtures","Watts per\nFixture NOTE 6","Watts \nProposed"]
[null,null,null,null,null,{"$f":"IF(AND(A21=\"\",D21=0,E21=0),0,IF(ISNA(IF(VLOOKUP(VLOOKUP($A21,$D$91:$E$94,2,FALSE),$B$8:$F$12,3,FALSE)>0,\"\",NA())),\"Not Defined\",D21*E21))","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,"Total Retail Proposed Display Watts NOTE 7",{"$f":"IF(COUNTIF(F21:F31,\"Not Defined\")>0,NA(),SUM(F21:F32))","v":0}]
[]
[{"$f":"IF(F33>0,IF(F33<=F17,\"RETAIL DISPLAY WATTAGE ALLOWANCE - AS PROPOSED\",\"RETAIL DISPLAY WATTAGE ALLOWANCE - PER LPA\"),\"\")","v":""},null,null,null,"Retail Display Power Allowance NOTE 8",{"$f":"MIN(F33,F17)","v":0}]
[]
[null,null,null,"Retail 2","Retail 3","Retail 4"]
[null,null,{"$f":"SUMIF($A21:$A32,\"Retail 1\",$F21:$F32)","v":0},{"$f":"SUMIF($A21:$A32,\"Retail 2\",$F21:$F32)","v":0},{"$f":"SUMIF($A21:$A32,\"Retail 3\",$F21:$F32)","v":0},{"$f":"SUMIF($A21:$A32,\"Retail 4\",$F21:$F32)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Interior Display Lighting - Space-by-Space",null,null,null,null,"LTG-INT-DISPLAY"]
[{"$f":"A2","v":"2015 Washington State Energy Code Compliance Forms for Commercial Buildings including R2, R3, R4 over 3 stories and all R1 "},null,null,null,null,"Revised July 2016"]
[{"$f":"A3","v":"Project Title:"},{"$f":"B3","v":"Fill this line out on LGT-SUM"},null,null,"Date",{"$f":"F3","v":"2016-07-01"}]
[null,null,null,null,"For Building Department Use"]
[]
[]
[{"$f":"IF(A6=\"Maximum Allowed Retail Display Lighting Wattage\",\"Maximum Allowed Lobby Art/Exhibit Display Lighting Wattage\",A6)","v":"Maximum Allowed Lobby Art/Exhibit Display Lighting Wattage"}]
["Lobby Area NOTE 9","Lobby Description including  (plan # & room #)",null,"Gross Interior \nArea in ft2","Maximum Display Watts Allowed\nPer Area NOTE 10","Proposed Display Lighting Total \nPer Area NOTE 11",null,"Allowance \nmin (max, display)"]
[null,null,null,null,{"$f":"IF(A57=\"\",0,ROUNDUP(0.5*D57,0))","v":0},{"$f":"IF(A56=\"\",0,ROUND(SUMIF($A$68:$A$81,A57,$F$68:$F$81),0))","v":0},{"$f":"IF(ISNA(INDEX(A$57:A$61,MATCH(0,COUNTIF(G$56:$G56,A$57:A$61),0))),\"\",INDEX(A$57:A$61,MATCH(0,COUNTIF(G$56:$G56,A$57:A$61),0)))","v":0},{"$f":"MIN(E57,F57)","v":0},0]
[null,null,null,null,{"$f":"IF(A58=\"\",0,ROUNDUP(0.5*D58,0))","v":0},{"$f":"IF(A57=\"\",0,ROUND(SUMIF($A$68:$A$81,A58,$F$68:$F$81),0))","v":0},{"$f":"IF(ISNA(INDEX(A$57:A$61,MATCH(0,COUNTIF(G$56:$G57,A$57:A$61),0))),\"\",INDEX(A$57:A$61,MATCH(0,COUNTIF(G$56:$G57,A$57:A$61),0)))","v":""},{"$f":"MIN(E58,F58)","v":0}]
[null,null,null,null,0,0,{"$f":"IF(ISNA(INDEX(A$57:A$61,MATCH(0,COUNTIF(G$56:$G58,A$57:A$61),0))),\"\",INDEX(A$57:A$61,MATCH(0,COUNTIF(G$56:$G58,A$57:A$61),0)))","v":""},{"$f":"MIN(E59,F59)","v":0}]
[null,null,null,0,0,0,{"$f":"IF(ISNA(INDEX(A$57:A$61,MATCH(0,COUNTIF(G$56:$G59,A$57:A$61),0))),\"\",INDEX(A$57:A$61,MATCH(0,COUNTIF(G$56:$G59,A$57:A$61),0)))","v":""},{"$f":"MIN(E60,F60)","v":0}]
[]
[null,null,"Total Lobby with Display Area",{"$f":"SUM(D57:D61)","v":0}]
[]
[null,null,null,null,"Total Lobby Art/Exhibit Display Allowance NOTE 13",{"$f":"IF(OR(COUNTIF(F68:F81,\"Not Defined\")>0,NOT(ISERROR(FIND(\"ERROR\",B65)))),NA(),SUM(H57:H61))","v":0}]
[null,{"$f":"IF(D62>0, IF(LobbyAreas=0,\"ERROR - Lobby area required in LTG-INT-SPACE for Art/Exhibit Display Allowance\",IF(LobbyAreaSF<'LTG-INT-DISPLAY'!D62,\"ERROR - Lobby display area exceeds total Lobby area entered  in LTG-INT-SPACE\",\"\")),\"\")","v":""}]
["Proposed Lobby Art/Exhibit Display Lighting Wattage NOTE 12"]
["Lobby Area","Location (plan #,\n room #)","Fixture Description NOTE 5","Number of \nFixtures","Watts per\nFixture NOTE 6","Watts \nProposed"]
[null,null,null,null,null,{"$f":"IF(AND(A68=\"\",D68=0,E68=0),0,IF(ISNA(VLOOKUP(A68,$A$57:$F$61,1,FALSE)),\"Not Defined\",IF(VLOOKUP(A68,$A$57:$F$61,4,FALSE)>0,D68*E68,\"Not Defined\")))","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,null,0]
[null,null,null,null,null,0]
[]
[null,null,null,null,"Total Lobby Art/Exhibit Proposed Display Watts",{"$f":"IF(COUNTIF(F68:F81,\"Not Defined\")>0,NA(),SUM(F68:F81))","v":0}]
[]
["Interior Lighting Power Allowance",null,null,null,null,{"$f":"IF(ISNA(F82),NA(),IF(AND(F82=0,F64=0), \"\",IF(F64<F82,\"DOES NOT COMPLY: \"&sardines(H57:H61),\"COMPLIES\")))","v":""}]
[]
[]
[null,null,null,null,null,{"$f":"COUNTIF(E57:E61,\"\"<F57)","v":0}]
[]
[]
[null,null,null,null,"Space-by-Space areas"]
[null,null,null,"Retail 1","Retail 1: All unclassified retail display",0.6,{"$f":"D91","v":"Retail 1"}]
[null,null,null,"Retail 2","Retail 2: Vehicles, sporting goods and small electronics",0.6,{"$f":"D92","v":"Retail 2"}]
[null,null,null,"Retail 3","Retail 3: Furniture, clothing, cosmetics, artwork",1.4,{"$f":"D93","v":"Retail 3"}]
[null,null,null,"Retail 4","Retail 4: Jewelry, crystal, china",2.5,{"$f":"D94","v":"Retail 4"}]
[]
[null,null,null,"Area Used","Installed Watts"]
[null,null,null,{"$f":"IF(LEN(G8)>1,VLOOKUP(G8,$E$91:$G$94,3,0),\"\")","v":""},{"$f":"IF(D97=\"\",\"\",SUMIF(DisplayProposed,D97,$F$21:$F$32))","v":""}]
[null,null,null,"",{"$f":"IF(D98=\"\",\"\",SUMIF(DisplayProposed,D98,$F$21:$F$32))","v":""}]
[null,null,null,"",{"$f":"IF(D99=\"\",\"\",SUMIF(DisplayProposed,D99,$F$21:$F$32))","v":""}]
[null,null,null,"",{"$f":"IF(D100=\"\",\"\",SUMIF(DisplayProposed,D100,$F$21:$F$32))","v":""}]
[null,null,null,""]
[null,null,null,""]

{"sheet":"LTG-INT-BLD","index":4,"n_rows":94,"n_cols":11,"rows_kept":94,"cut":false,"hidden":false,"merged":[[3,0,4,0],[36,1,36,2],[37,1,37,2],[34,1,34,2],[35,1,35,2]]}
["Interior Lighting - Building Area Method",null,null,null,null,"LTG-INT-BLD"]
[{"$f":"'LTG-SUM'!A2","v":"2015 Washington State Energy Code Compliance Forms for Commercial Buildings including R2, R3, R4 over 3 stories and all R1 "},null,null,null,null,{"$f":"'LTG-SUM'!G2","v":"Revised August 2016"}]
[{"$f":"'LTG-SUM'!B3","v":"Project Title:"},{"$f":"IF('LTG-SUM'!C3=\"1 - This title will copy onto other forms\",\"Fill this line out on LGT-SUM\",'LTG-SUM'!C3)","v":"Fill this line out on LGT-SUM"},null,null,{"$f":"'LTG-SUM'!F3","v":"Date"},{"$f":"'LTG-SUM'!G3","v":"2016-07-01"}]
["Calculation Area NOTE 8",null,null,null,{"$f":"'LTG-SUM'!F4","v":"For Building Department Use"}]
[]
[]
["LPA Calculation Type"]
[]
[{"$f":"IF(IntAlt_LT50pctBA,\"Use Space-by-space for less than 50% lighting retrofit\",\"Maximum Allowed Lighting Wattage\")","v":"Maximum Allowed Lighting Wattage"}]
["Building Area","Location (plan #,\n room #, or ALL)","Area Description","Gross Interior \nArea in ft2","Allowed\nWatts per ft2","Watts Allowed\n(watts/ft2 x area)"]
[null,null,null,null,{"$f":"IF(A11=\"\",0,VLOOKUP(A11,$A$63:$B$94,2,FALSE))","v":0},{"$f":"IF(AND(A11=\"\",E11=0,D11=0),0,IF(ISNA(IF(VLOOKUP(A11,$A$22:$F$33,6,FALSE)>0,\"\",NA())),\"Unlit\",ROUNDUP(E11*D11,0)))","v":0},{"$f":"IF(ISNA(INDEX(A$11:A$18,MATCH(0,COUNTIF(G$10:$G10,A$11:A$18),0))),\"\",INDEX(A$11:A$18,MATCH(0,COUNTIF(G$10:$G10,A$11:A$18),0)))","v":0}]
[null,null,null,null,0,{"$f":"IF(AND(A12=\"\",E12=0,D12=0),0,IF(ISNA(IF(VLOOKUP(A12,$A$22:$F$33,6,FALSE)>0,\"\",NA())),\"Unlit\",ROUNDUP(E12*D12,0)))","v":0},{"$f":"IF(ISNA(INDEX(A$11:A$18,MATCH(0,COUNTIF(G$10:$G11,A$11:A$18),0))),\"\",INDEX(A$11:A$18,MATCH(0,COUNTIF(G$10:$G11,A$11:A$18),0)))","v":""}]
[null,null,null,null,0,0,{"$f":"IF(ISNA(INDEX(A$11:A$18,MATCH(0,COUNTIF(G$10:$G12,A$11:A$18),0))),\"\",INDEX(A$11:A$18,MATCH(0,COUNTIF(G$10:$G12,A$11:A$18),0)))","v":""}]
[null,null,null,null,0,0,{"$f":"IF(ISNA(INDEX(A$11:A$18,MATCH(0,COUNTIF(G$10:$G13,A$11:A$18),0))),\"\",INDEX(A$11:A$18,MATCH(0,COUNTIF(G$10:$G13,A$11:A$18),0)))","v":""},null,null,null,1]
[null,null,null,null,0,0,{"$f":"IF(ISNA(INDEX(A$11:A$18,MATCH(0,COUNTIF(G$10:$G14,A$11:A$18),0))),\"\",INDEX(A$11:A$18,MATCH(0,COUNTIF(G$10:$G14,A$11:A$18),0)))","v":""},null,null,null,1]
[null,null,null,null,0,0,{"$f":"IF(ISNA(INDEX(A$11:A$18,MATCH(0,COUNTIF(G$10:$G15,A$11:A$18),0))),\"\",INDEX(A$11:A$18,MATCH(0,COUNTIF(G$10:$G15,A$11:A$18),0)))","v":""},null,null,null,1]
[null,null,null,null,{"$f":"IF(A17=\"\",0,VLOOKUP(A17,$A$63:$B$94,2,FALSE))","v":0},0,{"$f":"IF(ISNA(INDEX(A$11:A$18,MATCH(0,COUNTIF(G$10:$G16,A$11:A$18),0))),\"\",INDEX(A$11:A$18,MATCH(0,COUNTIF(G$10:$G16,A$11:A$18),0)))","v":""},null,null,null,1]
[]
[null,null,"Total",{"$f":"SUM(D11:D18)","v":0}]
["Proposed Lighting Wattage"]
["Building Area","Location (plan #,\n room #)","Fixture Description NOTE 2, 3, 4, 5","Number of Fixtures","Watts per\nFixture NOTE 6","Watts Proposed"]
[null,null,null,null,null,{"$f":"IF(AND(A22=\"\",D22=0,E22=0),0,IF(ISNA(IF(VLOOKUP(A22,$A$11:$F$18,4,FALSE)>0,\"\",NA())),txt_Area_Not_Defined,ROUND(D22*E22,0)))","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,null,null,{"$f":"COUNTIFS(F22:F33,\"Not Defined\",A22:A33,\"\")","v":0}]
["Compliance by Building Area NOTE 7",null,null,null,null,null,{"$f":"COUNTIF(F22:F33,\">0\")","v":0}]
["Building Area","Warnings ",null,"Total Allowed Watts","Total Proposed Watts","Interior Lighting Power Allowance",{"$f":"UniqueAreas","v":0}]
[{"$f":"IF('LTG-INT-REF'!H16=0,\"\",'LTG-INT-REF'!H16)","v":""},{"$f":"IF(AND(A36<>\"\",'LTG-INT-REF'!N16>0),\"Building Area information is incomplete\",IF('LTG-INT-REF'!P16=1,\"Confirm all fixtures are reported under proposed lighting - low watts relative to maximum allowed.\",IF('LTG-INT-REF'!L16=0,\"\",\"Exceeds maximum allowed wattage for this building area\")))","v":""},null,{"$f":"IF(A36=\"\",\"\",SUMIF(AreasInBld,A36,$F$11:$F$18))","v":""},{"$f":"IF('LTG-INT-REF'!H16=0,\"\",'LTG-INT-REF'!J16)","v":""},{"$f":"IF(A36<>\"\",IF('LTG-INT-REF'!O16=0,IF(intCalcScopeBAset,IF(CalcTypeBAset,IF(OR('LTG-INT-REF'!L16=1,'LTG-INT-REF'!N16=1),\"DOES NOT COMPLY\",IF(CalcTypeBA=2, IF('LTG-INT-REF'!M16=1,\"DOES NOT COMPLY C406.3\",\"COMPLIES C406.3\"), \"COMPLIES\")),\"Set LPA Calculation Type\"),\"Set Calculation Area\"),\"UNLIT\"),\"\")","v":""},{"$f":"ROWS(IntBldCompTablePlus1)","v":4}]
[{"$f":"IF('LTG-INT-REF'!H17=0,\"\",'LTG-INT-REF'!H17)","v":""},{"$f":"IF(AND(A37<>\"\",'LTG-INT-REF'!N17>0),\"Building Area information is incomplete\",IF('LTG-INT-REF'!P17=1,\"Confirm all fixtures are reported under proposed lighting - low watts relative to maximum allowed.\",IF('LTG-INT-REF'!L17=0,\"\",\"Exceeds maximum allowed wattage for this building area\")))","v":""},null,{"$f":"IF(A37=\"\",\"\",SUMIF(AreasInBld,A37,$F$11:$F$18))","v":""},{"$f":"IF('LTG-INT-REF'!H17=0,\"\",'LTG-INT-REF'!J17)","v":""},{"$f":"IF(A37<>\"\",IF('LTG-INT-REF'!O17=0,IF(intCalcScopeBAset,IF(CalcTypeBAset,IF(OR('LTG-INT-REF'!L17=1,'LTG-INT-REF'!N17=1),\"DOES NOT COMPLY\",IF(CalcTypeBA=2, IF('LTG-INT-REF'!M17=1,\"DOES NOT COMPLY C406.3\",\"COMPLIES C406.3\"), \"COMPLIES\")),\"Set LPA Calculation Type\"),\"Set Calculation Area\"),\"UNLIT\"),\"\")","v":""}]
[{"$f":"IF('LTG-INT-REF'!H18=0,\"\",'LTG-INT-REF'!H18)","v":""},{"$f":"IF(AND(A38<>\"\",'LTG-INT-REF'!N18>0),\"Building Area information is incomplete\",IF('LTG-INT-REF'!P18=1,\"Confirm all fixtures are reported under proposed lighting - low watts relative to maximum allowed.\",IF('LTG-INT-REF'!L18=0,\"\",\"Exceeds maximum allowed wattage for this building area\")))","v":""},null,{"$f":"IF(A38=\"\",\"\",SUMIF(AreasInBld,A38,$F$11:$F$18))","v":""},{"$f":"IF('LTG-INT-REF'!H18=0,\"\",'LTG-INT-REF'!J18)","v":""},{"$f":"IF(A38<>\"\",IF('LTG-INT-REF'!O18=0,IF(intCalcScopeBAset,IF(CalcTypeBAset,IF(OR('LTG-INT-REF'!L18=1,'LTG-INT-REF'!N18=1),\"DOES NOT COMPLY\",IF(CalcTypeBA=2, IF('LTG-INT-REF'!M18=1,\"DOES NOT COMPLY C406.3\",\"COMPLIES C406.3\"), \"COMPLIES\")),\"Set LPA Calculation Type\"),\"Set Calculation Area\"),\"UNLIT\"),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(AND(G33>0,G34>0),\"ERROR - Unassigned Proposed Fixture\",\"\")","v":""},null,null,null,0]
[null,null,"Totals",{"$f":"SUM(D36:D39)","v":0},{"$f":"SUM(E36:E39)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Building Areas"]
[{"$f":"'LTG-INT-REF'!A19","v":"Automotive facility"},{"$f":"'LTG-INT-REF'!C19","v":0.64}]
[{"$f":"'LTG-INT-REF'!A20","v":"Convention center"},{"$f":"'LTG-INT-REF'!C20","v":0.81}]
[{"$f":"'LTG-INT-REF'!A21","v":"Court house"},{"$f":"'LTG-INT-REF'!C21","v":0.81}]
[{"$f":"'LTG-INT-REF'!A22","v":"Dining:  Bar lounge/leisure"},{"$f":"'LTG-INT-REF'!C22","v":0.79}]
[{"$f":"'LTG-INT-REF'!A23","v":"Dining:  Cafeteria/fast food"},{"$f":"'LTG-INT-REF'!C23","v":0.72}]
[{"$f":"'LTG-INT-REF'!A24","v":"Dining:  Family"},{"$f":"'LTG-INT-REF'!C24","v":0.71}]
[{"$f":"'LTG-INT-REF'!A25","v":"Dormitory"},{"$f":"'LTG-INT-REF'!C25","v":0.46}]
[{"$f":"'LTG-INT-REF'!A26","v":"Exercise center"},{"$f":"'LTG-INT-REF'!C26","v":0.67}]
[{"$f":"'LTG-INT-REF'!A27","v":"Fire station"},{"$f":"'LTG-INT-REF'!C27","v":0.54}]
[{"$f":"'LTG-INT-REF'!A28","v":"Gymnasium"},{"$f":"'LTG-INT-REF'!C28","v":0.75}]
[{"$f":"'LTG-INT-REF'!A29","v":"Health care clinic"},{"$f":"'LTG-INT-REF'!C29","v":0.7}]
[{"$f":"'LTG-INT-REF'!A30","v":"Hospital"},{"$f":"'LTG-INT-REF'!C30","v":0.84}]
["Hotel",{"$f":"'LTG-INT-REF'!C31","v":0.7}]
[{"$f":"'LTG-INT-REF'!A32","v":"Library"},{"$f":"'LTG-INT-REF'!C32","v":0.94}]
[{"$f":"'LTG-INT-REF'!A33","v":"Manufacturing facility"},{"$f":"'LTG-INT-REF'!C33","v":0.89}]
[{"$f":"'LTG-INT-REF'!A34","v":"Motion picture theater"},{"$f":"'LTG-INT-REF'!C34","v":0.61}]
[{"$f":"'LTG-INT-REF'!A35","v":"Multifamily"},{"$f":"'LTG-INT-REF'!C35","v":0.41}]
[{"$f":"'LTG-INT-REF'!A36","v":"Museum"},{"$f":"'LTG-INT-REF'!C36","v":0.8}]
[{"$f":"'LTG-INT-REF'!A37","v":"Office"},{"$f":"'LTG-INT-REF'!C37","v":0.66}]
[{"$f":"'LTG-INT-REF'!A38","v":"Parking garage"},{"$f":"'LTG-INT-REF'!C38","v":0.16}]
[{"$f":"'LTG-INT-REF'!A39","v":"Penitentiary"},{"$f":"'LTG-INT-REF'!C39","v":0.65}]
[{"$f":"'LTG-INT-REF'!A40","v":"Performing arts theater"},{"$f":"'LTG-INT-REF'!C40","v":1}]
[{"$f":"'LTG-INT-REF'!A41","v":"Police station"},{"$f":"'LTG-INT-REF'!C41","v":0.7}]
[{"$f":"'LTG-INT-REF'!A42","v":"Post office"},{"$f":"'LTG-INT-REF'!C42","v":0.7}]
[{"$f":"'LTG-INT-REF'!A43","v":"Religious building"},{"$f":"'LTG-INT-REF'!C43","v":0.8}]
[{"$f":"'LTG-INT-REF'!A44","v":"Retail"},{"$f":"'LTG-INT-REF'!C44","v":1.01}]
[{"$f":"'LTG-INT-REF'!A45","v":"School/university"},{"$f":"'LTG-INT-REF'!C45","v":0.7}]
[{"$f":"'LTG-INT-REF'!A46","v":"Sports arena"},{"$f":"'LTG-INT-REF'!C46","v":0.62}]
[{"$f":"'LTG-INT-REF'!A47","v":"Town hall"},{"$f":"'LTG-INT-REF'!C47","v":0.71}]
[{"$f":"'LTG-INT-REF'!A48","v":"Transportation"},{"$f":"'LTG-INT-REF'!C48","v":0.56000000000000005}]
[{"$f":"'LTG-INT-REF'!A49","v":"Warehouse"},{"$f":"'LTG-INT-REF'!C49","v":0.4}]
[{"$f":"'LTG-INT-REF'!A50","v":"Workshop"},{"$f":"'LTG-INT-REF'!C50","v":0.95}]

{"sheet":"LTG-INT-REF","index":5,"n_rows":84,"n_cols":18,"rows_kept":84,"cut":false,"hidden":true,"merged":[[13,8,13,11]]}
["Method"]
[2,"NO Longer used 2015 (1=building area, 2=space-by-space, 3=not specified"]
["Calculation Scope (area calculation is for)",null,"intCalcScopeSet"]
[0,{"$f":"IF(IntCalculationScopeSBS=1,TRUE,FALSE)","v":false},{"$f":"IntCalculationScopeSBS<>5","v":true}]
[5,{"$f":"IF(intCalculationScopeBA=1,TRUE,FALSE)","v":false},{"$f":"intCalculationScopeBA<>5","v":false}]
["Calculation Type",null,"CalcTypeSet"]
[3,"C406.4 Reduced Lighting Power=2",{"$f":"CalcTypeSBS<>3","v":false}]
[3,"C406.4 Reduced Lighting Power=2",{"$f":"CalcTypeBA<>3","v":false},null,null,null,null,null,null,{"$f":"SUMPRODUCT('LTG-INT-BLD'!D22:D32,'LTG-INT-BLD'!E22:E32)","v":0},"watts entered"]
["Dwelling Method",null,null,null,null,null,null,null,null,{"$f":"SUM(J16:J35)","v":0},"watts in allowed catagories"]
[4,"Not used in calculations  6/2016",null,null,null,null,null,"Number of Unique Areas"]
["Pass",null,null,null,null,null,null,{"$f":"21-COUNTIF(G16:G35,NA())-1","v":0},null,null,null,null,null,"Text denoting areas not defined (used here and on LTG-INT-BLD"]
[{"$f":"SUM(L16:L35)=0","v":true},{"$f":"IF(A12=FALSE,MID(E12,1,LEN(E12)-2),IF(SUM(J16:J50)>0,IF(J8=J9,\"ALL AREAS COMPLY\",\"PROPOSED LIGHTING IN UNDEFINED SPACE TYPE\"),\"\"))","v":""},null,null,{"$f":"IF(A12=FALSE,\"The following areas do not comply: \",\"\")","v":""},null,null,null,{"$f":"IF(J12=\"\",,IF(MID(J12,LEN(J12)-1,2)=\", \",MID(J12,1,LEN(J12)-2),J12))","v":0},{"$f":"IF(A12=FALSE,CONCATENATE(Q16,Q17,Q18,Q19,Q20,Q21,Q22,Q23,Q24,Q25,Q26,Q27,Q28,Q29,Q30,Q31,Q32,Q33,#REF!,Q34,Q35),\"\")","v":""},null,null,null,"Not Defined"]
["Low LPD",null,null,null,null,null,null,"Specified Building Areas"]
[{"$f":"SUM(P16:P35)>0","v":false},{"$f":"IF(A14=TRUE,\"Areas with low LPD's.  Check that all proposed fixtures are entered:\",\"\")","v":""},null,null,{"$f":"IF(A14=TRUE,CONCATENATE(R16,R17,R18,R19,R20,R21,R22,R23,R24,R25,R26,R27,R28,R29,R30,R31,R32,R33,R34,R35),\"\")","v":""},null,null,null,"Watts",null,null,null,null,"Area"]
[null,{"$f":"IF(A14=TRUE,MID(E14,1,LEN(E14)-2),\"\")","v":""},null,null,null,null,null,null,"allowed","proposed","Over","Fail","Fail C406.4","Undefined","No lights","low LPD","watts error","lowLPD error"]
[null,null,null,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$15:$E15,AreasInBld),0))","v":0},{"$f":"IF(ISTEXT(E16),E16,\"\")","v":""},{"$f":"INDEX($F$16:$F$82,MATCH(0,COUNTIF(G$15:$G15,$F$16:$F$82),0))","v":{"$error":"#N/A"}},{"$f":"IF(ISTEXT(G16),G16,0)","v":0},{"$f":"IF(H16=0,0,SUMIF('LTG-INT-BLD'!$A$11:$A$18,'LTG-INT-REF'!H16,'LTG-INT-BLD'!$F$11:$F$18))","v":0},{"$f":"IF(H16=0,0,SUMIF('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H16,'LTG-INT-BLD'!$F$22:$F$33))","v":0},{"$f":"IF(J16>I16,J16-I16,\"\")","v":""},{"$f":"IF(I16<J16,1,0)","v":0},{"$f":"IF(I16*0.75<J16,1,0)","v":0},{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H16,'LTG-INT-BLD'!$F$22:$F$33,txt_Area_Not_Defined)>0,1,0)","v":0},{"$f":"IF(AND(J16=0,N16=0),1,0)","v":1},{"$f":"IF(OR(H16=0,N16<>0),0,IF(OR(J16<I16*0.6,J16=0),1,0))","v":0},{"$f":"IF(L16=1,CONCATENATE(H16,\"-\",K16,\"W over, \"),\"\")","v":""},{"$f":"IF(P16=1,CONCATENATE(H16,\", \"),\"\")","v":""}]
[null,"Allowance",null,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$15:$E16,AreasInBld),0))","v":{"$error":"#N/A"}},{"$f":"IF(ISTEXT(E17),E17,\"\")","v":""},{"$f":"INDEX($F$16:$F$82,MATCH(0,COUNTIF(G$15:$G16,$F$16:$F$82),0))","v":{"$error":"#N/A"}},{"$f":"IF(ISTEXT(G17),G17,0)","v":0},{"$f":"IF(H17=0,0,SUMIF('LTG-INT-BLD'!$A$11:$A$18,'LTG-INT-REF'!H17,'LTG-INT-BLD'!$F$11:$F$18))","v":0},{"$f":"IF(H17=0,0,SUMIF('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H17,'LTG-INT-BLD'!$F$22:$F$33))","v":0},{"$f":"IF(J17>I17,J17-I17,\"\")","v":""},{"$f":"IF(I17<J17,1,0)","v":0},{"$f":"IF(I17*0.75<J17,1,0)","v":0},{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H17,'LTG-INT-BLD'!$F$22:$F$33,txt_Area_Not_Defined)>0,1,0)","v":0},1,{"$f":"IF(OR(H17=0,N17<>0),0,IF(OR(J17<I17*0.6,J17=0),1,0))","v":0},"",""]
["Building Areas","text","W",null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$15:$E17,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$16:$F$82,MATCH(0,COUNTIF(G$15:$G17,$F$16:$F$82),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H18=0,0,SUMIF('LTG-INT-BLD'!$A$11:$A$18,'LTG-INT-REF'!H18,'LTG-INT-BLD'!$F$11:$F$18))","v":0},{"$f":"IF(H18=0,0,SUMIF('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H18,'LTG-INT-BLD'!$F$22:$F$33))","v":0},"",0,0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H18,'LTG-INT-BLD'!$F$22:$F$33,txt_Area_Not_Defined)>0,1,0)","v":0},1,0,"",""]
["Automotive facility",{"$f":"CONCATENATE(TEXT(C19,\"0.0#\"),\" W/ft2\")","v":"0.64 W/ft2"},0.64,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$15:$E18,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$16:$F$82,MATCH(0,COUNTIF(G$15:$G18,$F$16:$F$82),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H19=0,0,SUMIF('LTG-INT-BLD'!$A$11:$A$18,'LTG-INT-REF'!H19,'LTG-INT-BLD'!$F$11:$F$18))","v":0},{"$f":"IF(H19=0,0,SUMIF('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H19,'LTG-INT-BLD'!$F$22:$F$33))","v":0},"",0,0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H19,'LTG-INT-BLD'!$F$22:$F$33,txt_Area_Not_Defined)>0,1,0)","v":0},1,0,"",""]
["Convention center",{"$f":"CONCATENATE(TEXT(C20,\"0.0#\"),\" W/ft2\")","v":"0.81 W/ft2"},0.81,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$15:$E19,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$16:$F$82,MATCH(0,COUNTIF(G$15:$G19,$F$16:$F$82),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H20=0,0,SUMIF('LTG-INT-BLD'!$A$11:$A$18,'LTG-INT-REF'!H20,'LTG-INT-BLD'!$F$11:$F$18))","v":0},{"$f":"IF(H20=0,0,SUMIF('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H20,'LTG-INT-BLD'!$F$22:$F$33))","v":0},"",0,0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H20,'LTG-INT-BLD'!$F$22:$F$33,txt_Area_Not_Defined)>0,1,0)","v":0},1,0,"",""]
["Court house","0.81 W/ft2",0.81,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$15:$E20,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$16:$F$82,MATCH(0,COUNTIF(G$15:$G20,$F$16:$F$82),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H21=0,0,SUMIF('LTG-INT-BLD'!$A$11:$A$18,'LTG-INT-REF'!H21,'LTG-INT-BLD'!$F$11:$F$18))","v":0},{"$f":"IF(H21=0,0,SUMIF('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H21,'LTG-INT-BLD'!$F$22:$F$33))","v":0},"",0,0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H21,'LTG-INT-BLD'!$F$22:$F$33,txt_Area_Not_Defined)>0,1,0)","v":0},1,0,"",""]
["Dining:  Bar lounge/leisure","0.79 W/ft2",0.79,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$15:$E21,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$16:$F$82,MATCH(0,COUNTIF(G$15:$G21,$F$16:$F$82),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H22=0,0,SUMIF('LTG-INT-BLD'!$A$11:$A$18,'LTG-INT-REF'!H22,'LTG-INT-BLD'!$F$11:$F$18))","v":0},{"$f":"IF(H22=0,0,SUMIF('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H22,'LTG-INT-BLD'!$F$22:$F$33))","v":0},"",0,0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H22,'LTG-INT-BLD'!$F$22:$F$33,txt_Area_Not_Defined)>0,1,0)","v":0},1,0,"",""]
["Dining:  Cafeteria/fast food","0.72 W/ft2",0.72,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$15:$E22,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$16:$F$82,MATCH(0,COUNTIF(G$15:$G22,$F$16:$F$82),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H23=0,0,SUMIF('LTG-INT-BLD'!$A$11:$A$18,'LTG-INT-REF'!H23,'LTG-INT-BLD'!$F$11:$F$18))","v":0},{"$f":"IF(H23=0,0,SUMIF('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H23,'LTG-INT-BLD'!$F$22:$F$33))","v":0},"",0,0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H23,'LTG-INT-BLD'!$F$22:$F$33,txt_Area_Not_Defined)>0,1,0)","v":0},1,0,"",""]
["Dining:  Family","0.71 W/ft2",0.71,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$15:$E23,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$16:$F$82,MATCH(0,COUNTIF(G$15:$G23,$F$16:$F$82),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H24=0,0,SUMIF('LTG-INT-BLD'!$A$11:$A$18,'LTG-INT-REF'!H24,'LTG-INT-BLD'!$F$11:$F$18))","v":0},{"$f":"IF(H24=0,0,SUMIF('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H24,'LTG-INT-BLD'!$F$22:$F$33))","v":0},"",0,0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H24,'LTG-INT-BLD'!$F$22:$F$33,txt_Area_Not_Defined)>0,1,0)","v":0},1,0,"",""]
["Dormitory","0.46 W/ft2",0.46,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$15:$E24,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$16:$F$82,MATCH(0,COUNTIF(G$15:$G24,$F$16:$F$82),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H25=0,0,SUMIF('LTG-INT-BLD'!$A$11:$A$18,'LTG-INT-REF'!H25,'LTG-INT-BLD'!$F$11:$F$18))","v":0},{"$f":"IF(H25=0,0,SUMIF('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H25,'LTG-INT-BLD'!$F$22:$F$33))","v":0},"",0,0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H25,'LTG-INT-BLD'!$F$22:$F$33,txt_Area_Not_Defined)>0,1,0)","v":0},1,0,"",""]
["Exercise center","0.67 W/ft2",0.67,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$15:$E25,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$16:$F$82,MATCH(0,COUNTIF(G$15:$G25,$F$16:$F$82),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H26=0,0,SUMIF('LTG-INT-BLD'!$A$11:$A$18,'LTG-INT-REF'!H26,'LTG-INT-BLD'!$F$11:$F$18))","v":0},{"$f":"IF(H26=0,0,SUMIF('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H26,'LTG-INT-BLD'!$F$22:$F$33))","v":0},"",0,0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H26,'LTG-INT-BLD'!$F$22:$F$33,txt_Area_Not_Defined)>0,1,0)","v":0},1,0,"",""]
["Fire station","0.54 W/ft2",0.54,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$15:$E26,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$16:$F$82,MATCH(0,COUNTIF(G$15:$G26,$F$16:$F$82),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H27=0,0,SUMIF('LTG-INT-BLD'!$A$11:$A$18,'LTG-INT-REF'!H27,'LTG-INT-BLD'!$F$11:$F$18))","v":0},{"$f":"IF(H27=0,0,SUMIF('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H27,'LTG-INT-BLD'!$F$22:$F$33))","v":0},"",0,0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H27,'LTG-INT-BLD'!$F$22:$F$33,txt_Area_Not_Defined)>0,1,0)","v":0},1,0,"",""]
["Gymnasium","0.75 W/ft2",0.75,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$15:$E27,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$16:$F$82,MATCH(0,COUNTIF(G$15:$G27,$F$16:$F$82),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H28=0,0,SUMIF('LTG-INT-BLD'!$A$11:$A$18,'LTG-INT-REF'!H28,'LTG-INT-BLD'!$F$11:$F$18))","v":0},{"$f":"IF(H28=0,0,SUMIF('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H28,'LTG-INT-BLD'!$F$22:$F$33))","v":0},"",0,0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H28,'LTG-INT-BLD'!$F$22:$F$33,txt_Area_Not_Defined)>0,1,0)","v":0},1,0,"",""]
["Health care clinic","0.7 W/ft2",0.7,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$15:$E28,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$16:$F$82,MATCH(0,COUNTIF(G$15:$G28,$F$16:$F$82),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H29=0,0,SUMIF('LTG-INT-BLD'!$A$11:$A$18,'LTG-INT-REF'!H29,'LTG-INT-BLD'!$F$11:$F$18))","v":0},{"$f":"IF(H29=0,0,SUMIF('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H29,'LTG-INT-BLD'!$F$22:$F$33))","v":0},"",0,0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H29,'LTG-INT-BLD'!$F$22:$F$33,txt_Area_Not_Defined)>0,1,0)","v":0},1,0,"",""]
["Hospital","0.84 W/ft2",0.84,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$15:$E29,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$16:$F$82,MATCH(0,COUNTIF(G$15:$G29,$F$16:$F$82),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H30=0,0,SUMIF('LTG-INT-BLD'!$A$11:$A$18,'LTG-INT-REF'!H30,'LTG-INT-BLD'!$F$11:$F$18))","v":0},{"$f":"IF(H30=0,0,SUMIF('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H30,'LTG-INT-BLD'!$F$22:$F$33))","v":0},"",0,0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H30,'LTG-INT-BLD'!$F$22:$F$33,txt_Area_Not_Defined)>0,1,0)","v":0},1,0,"",""]
["Hotel","0.7 W/ft2",0.7,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$15:$E30,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$16:$F$82,MATCH(0,COUNTIF(G$15:$G30,$F$16:$F$82),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H31=0,0,SUMIF('LTG-INT-BLD'!$A$11:$A$18,'LTG-INT-REF'!H31,'LTG-INT-BLD'!$F$11:$F$18))","v":0},{"$f":"IF(H31=0,0,SUMIF('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H31,'LTG-INT-BLD'!$F$22:$F$33))","v":0},"",0,0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H31,'LTG-INT-BLD'!$F$22:$F$33,txt_Area_Not_Defined)>0,1,0)","v":0},1,0,"",""]
["Library","0.94 W/ft2",0.94,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$15:$E31,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$16:$F$82,MATCH(0,COUNTIF(G$15:$G31,$F$16:$F$82),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H32=0,0,SUMIF('LTG-INT-BLD'!$A$11:$A$18,'LTG-INT-REF'!H32,'LTG-INT-BLD'!$F$11:$F$18))","v":0},{"$f":"IF(H32=0,0,SUMIF('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H32,'LTG-INT-BLD'!$F$22:$F$33))","v":0},"",0,0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H32,'LTG-INT-BLD'!$F$22:$F$33,txt_Area_Not_Defined)>0,1,0)","v":0},1,0,"",""]
["Manufacturing facility","0.89 W/ft2",0.89,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$15:$E32,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$16:$F$82,MATCH(0,COUNTIF(G$15:$G32,$F$16:$F$82),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H33=0,0,SUMIF('LTG-INT-BLD'!$A$11:$A$18,'LTG-INT-REF'!H33,'LTG-INT-BLD'!$F$11:$F$18))","v":0},{"$f":"IF(H33=0,0,SUMIF('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H33,'LTG-INT-BLD'!$F$22:$F$33))","v":0},"",0,0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H33,'LTG-INT-BLD'!$F$22:$F$33,txt_Area_Not_Defined)>0,1,0)","v":0},1,0,"",""]
["Motion picture theater","0.61 W/ft2",0.61,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$15:$E33,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$16:$F$82,MATCH(0,COUNTIF(G$15:$G33,$F$16:$F$82),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H34=0,0,SUMIF('LTG-INT-BLD'!$A$11:$A$18,'LTG-INT-REF'!H34,'LTG-INT-BLD'!$F$11:$F$18))","v":0},{"$f":"IF(H34=0,0,SUMIF('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H34,'LTG-INT-BLD'!$F$22:$F$33))","v":0},"",0,0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H34,'LTG-INT-BLD'!$F$22:$F$33,txt_Area_Not_Defined)>0,1,0)","v":0},1,0,"",""]
["Multifamily","0.41 W/ft2",0.41,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$15:$E34,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$16:$F$82,MATCH(0,COUNTIF(G$15:$G34,$F$16:$F$82),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H35=0,0,SUMIF('LTG-INT-BLD'!$A$11:$A$18,'LTG-INT-REF'!H35,'LTG-INT-BLD'!$F$11:$F$18))","v":0},{"$f":"IF(H35=0,0,SUMIF('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H35,'LTG-INT-BLD'!$F$22:$F$33))","v":0},"",0,0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H35,'LTG-INT-BLD'!$F$22:$F$33,txt_Area_Not_Defined)>0,1,0)","v":0},1,0,"",""]
["Museum","0.8 W/ft2",0.8,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$15:$E35,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$16:$F$82,MATCH(0,COUNTIF(G$15:$G35,$F$16:$F$82),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H36=0,0,SUMIF('LTG-INT-BLD'!$A$11:$A$18,'LTG-INT-REF'!H36,'LTG-INT-BLD'!$F$11:$F$18))","v":0},{"$f":"IF(H36=0,0,SUMIF('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H36,'LTG-INT-BLD'!$F$22:$F$33))","v":0},"",0,0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H36,'LTG-INT-BLD'!$F$22:$F$33,txt_Area_Not_Defined)>0,1,0)","v":0},1,0]
["Office","0.66 W/ft2",0.66,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$15:$E36,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$16:$F$82,MATCH(0,COUNTIF(G$15:$G36,$F$16:$F$82),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H37=0,0,SUMIF('LTG-INT-BLD'!$A$11:$A$18,'LTG-INT-REF'!H37,'LTG-INT-BLD'!$F$11:$F$18))","v":0},{"$f":"IF(H37=0,0,SUMIF('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H37,'LTG-INT-BLD'!$F$22:$F$33))","v":0},"",0,0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H37,'LTG-INT-BLD'!$F$22:$F$33,txt_Area_Not_Defined)>0,1,0)","v":0},1,0]
["Parking garage","0.16 W/ft2",0.16,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$15:$E37,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$16:$F$82,MATCH(0,COUNTIF(G$15:$G37,$F$16:$F$82),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H38=0,0,SUMIF('LTG-INT-BLD'!$A$11:$A$18,'LTG-INT-REF'!H38,'LTG-INT-BLD'!$F$11:$F$18))","v":0},{"$f":"IF(H38=0,0,SUMIF('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H38,'LTG-INT-BLD'!$F$22:$F$33))","v":0},"",0,0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H38,'LTG-INT-BLD'!$F$22:$F$33,txt_Area_Not_Defined)>0,1,0)","v":0},1,0]
["Penitentiary","0.65 W/ft2",0.65,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$15:$E38,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$16:$F$82,MATCH(0,COUNTIF(G$15:$G38,$F$16:$F$82),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H39=0,0,SUMIF('LTG-INT-BLD'!$A$11:$A$18,'LTG-INT-REF'!H39,'LTG-INT-BLD'!$F$11:$F$18))","v":0},{"$f":"IF(H39=0,0,SUMIF('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H39,'LTG-INT-BLD'!$F$22:$F$33))","v":0},"",0,0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H39,'LTG-INT-BLD'!$F$22:$F$33,txt_Area_Not_Defined)>0,1,0)","v":0},1,0]
["Performing arts theater","1.0 W/ft2",1,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$15:$E39,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$16:$F$82,MATCH(0,COUNTIF(G$15:$G39,$F$16:$F$82),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H40=0,0,SUMIF('LTG-INT-BLD'!$A$11:$A$18,'LTG-INT-REF'!H40,'LTG-INT-BLD'!$F$11:$F$18))","v":0},{"$f":"IF(H40=0,0,SUMIF('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H40,'LTG-INT-BLD'!$F$22:$F$33))","v":0},"",0,0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H40,'LTG-INT-BLD'!$F$22:$F$33,txt_Area_Not_Defined)>0,1,0)","v":0},1,0]
["Police station","0.7 W/ft2",0.7,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$15:$E40,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$16:$F$82,MATCH(0,COUNTIF(G$15:$G40,$F$16:$F$82),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H41=0,0,SUMIF('LTG-INT-BLD'!$A$11:$A$18,'LTG-INT-REF'!H41,'LTG-INT-BLD'!$F$11:$F$18))","v":0},{"$f":"IF(H41=0,0,SUMIF('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H41,'LTG-INT-BLD'!$F$22:$F$33))","v":0},"",0,0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H41,'LTG-INT-BLD'!$F$22:$F$33,txt_Area_Not_Defined)>0,1,0)","v":0},1,0]
["Post office","0.7 W/ft2",0.7,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$15:$E41,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$16:$F$82,MATCH(0,COUNTIF(G$15:$G41,$F$16:$F$82),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H42=0,0,SUMIF('LTG-INT-BLD'!$A$11:$A$18,'LTG-INT-REF'!H42,'LTG-INT-BLD'!$F$11:$F$18))","v":0},{"$f":"IF(H42=0,0,SUMIF('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H42,'LTG-INT-BLD'!$F$22:$F$33))","v":0},"",0,0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H42,'LTG-INT-BLD'!$F$22:$F$33,txt_Area_Not_Defined)>0,1,0)","v":0},1,0]
["Religious building","0.8 W/ft2",0.8,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$15:$E42,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$16:$F$82,MATCH(0,COUNTIF(G$15:$G42,$F$16:$F$82),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H43=0,0,SUMIF('LTG-INT-BLD'!$A$11:$A$18,'LTG-INT-REF'!H43,'LTG-INT-BLD'!$F$11:$F$18))","v":0},{"$f":"IF(H43=0,0,SUMIF('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H43,'LTG-INT-BLD'!$F$22:$F$33))","v":0},"",0,0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H43,'LTG-INT-BLD'!$F$22:$F$33,txt_Area_Not_Defined)>0,1,0)","v":0},1,0]
["Retail","1.01 W/ft2",1.01,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$15:$E43,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$16:$F$82,MATCH(0,COUNTIF(G$15:$G43,$F$16:$F$82),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H44=0,0,SUMIF('LTG-INT-BLD'!$A$11:$A$18,'LTG-INT-REF'!H44,'LTG-INT-BLD'!$F$11:$F$18))","v":0},{"$f":"IF(H44=0,0,SUMIF('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H44,'LTG-INT-BLD'!$F$22:$F$33))","v":0},"",0,0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H44,'LTG-INT-BLD'!$F$22:$F$33,txt_Area_Not_Defined)>0,1,0)","v":0},1,0]
["School/university","0.7 W/ft2",0.7,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$15:$E44,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$16:$F$82,MATCH(0,COUNTIF(G$15:$G44,$F$16:$F$82),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H45=0,0,SUMIF('LTG-INT-BLD'!$A$11:$A$18,'LTG-INT-REF'!H45,'LTG-INT-BLD'!$F$11:$F$18))","v":0},{"$f":"IF(H45=0,0,SUMIF('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H45,'LTG-INT-BLD'!$F$22:$F$33))","v":0},"",0,0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H45,'LTG-INT-BLD'!$F$22:$F$33,txt_Area_Not_Defined)>0,1,0)","v":0},1,0]
["Sports arena","0.62 W/ft2",0.62,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$15:$E45,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$16:$F$82,MATCH(0,COUNTIF(G$15:$G45,$F$16:$F$82),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H46=0,0,SUMIF('LTG-INT-BLD'!$A$11:$A$18,'LTG-INT-REF'!H46,'LTG-INT-BLD'!$F$11:$F$18))","v":0},{"$f":"IF(H46=0,0,SUMIF('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H46,'LTG-INT-BLD'!$F$22:$F$33))","v":0},"",0,0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H46,'LTG-INT-BLD'!$F$22:$F$33,txt_Area_Not_Defined)>0,1,0)","v":0},1,0]
["Town hall","0.71 W/ft2",0.71,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$15:$E46,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$16:$F$82,MATCH(0,COUNTIF(G$15:$G46,$F$16:$F$82),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H47=0,0,SUMIF('LTG-INT-BLD'!$A$11:$A$18,'LTG-INT-REF'!H47,'LTG-INT-BLD'!$F$11:$F$18))","v":0},{"$f":"IF(H47=0,0,SUMIF('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H47,'LTG-INT-BLD'!$F$22:$F$33))","v":0},"",0,0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H47,'LTG-INT-BLD'!$F$22:$F$33,txt_Area_Not_Defined)>0,1,0)","v":0},1,0]
["Transportation","0.56 W/ft2",0.56000000000000005,null,{"$f":"INDEX(AreasInBld,MATCH(0,COUNTIF(E$15:$E47,AreasInBld),0))","v":{"$error":"#N/A"}},"",{"$f":"INDEX($F$16:$F$82,MATCH(0,COUNTIF(G$15:$G47,$F$16:$F$82),0))","v":{"$error":"#N/A"}},0,{"$f":"IF(H48=0,0,SUMIF('LTG-INT-BLD'!$A$11:$A$18,'LTG-INT-REF'!H48,'LTG-INT-BLD'!$F$11:$F$18))","v":0},{"$f":"IF(H48=0,0,SUMIF('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H48,'LTG-INT-BLD'!$F$22:$F$33))","v":0},"",0,0,{"$f":"IF(COUNTIFS('LTG-INT-BLD'!$A$22:$A$33,'LTG-INT-REF'!H48,'LTG-INT-BLD'!$F$22:$F$33,txt_Area_Not_Defined)>0,1,0)","v":0},1,0]
["Warehouse","0.4 W/ft2",0.4,null,"Formula below needs a blank as first cell of function",{"$f":"IF(ISTEXT(E51),E51,\"\")","v":""}]
["Workshop","0.95 W/ft2",0.95,null,null,{"$f":"IF(ISTEXT(E52),E52,\"\")","v":""}]
["None",{"$f":"CONCATENATE(TEXT(C51,\"0.0#\"),\" W/ft2\")","v":"0.0 W/ft2"},0,null,{"$f":"INDEX('LTG-INT-BLD'!$A$22:$A$33,MATCH(0,COUNTIF(E$50:$E50,'LTG-INT-BLD'!$A$22:$A$33),0))","v":0},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$22:$A$33,MATCH(0,COUNTIF(E$50:$E51,'LTG-INT-BLD'!$A$22:$A$33),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$22:$A$33,MATCH(0,COUNTIF(E$50:$E52,'LTG-INT-BLD'!$A$22:$A$33),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$22:$A$33,MATCH(0,COUNTIF(E$50:$E53,'LTG-INT-BLD'!$A$22:$A$33),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$22:$A$33,MATCH(0,COUNTIF(E$50:$E54,'LTG-INT-BLD'!$A$22:$A$33),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$22:$A$33,MATCH(0,COUNTIF(E$50:$E55,'LTG-INT-BLD'!$A$22:$A$33),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$22:$A$33,MATCH(0,COUNTIF(E$50:$E56,'LTG-INT-BLD'!$A$22:$A$33),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$22:$A$33,MATCH(0,COUNTIF(E$50:$E57,'LTG-INT-BLD'!$A$22:$A$33),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$22:$A$33,MATCH(0,COUNTIF(E$50:$E58,'LTG-INT-BLD'!$A$22:$A$33),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$22:$A$33,MATCH(0,COUNTIF(E$50:$E59,'LTG-INT-BLD'!$A$22:$A$33),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$22:$A$33,MATCH(0,COUNTIF(E$50:$E60,'LTG-INT-BLD'!$A$22:$A$33),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$22:$A$33,MATCH(0,COUNTIF(E$50:$E61,'LTG-INT-BLD'!$A$22:$A$33),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$22:$A$33,MATCH(0,COUNTIF(E$50:$E62,'LTG-INT-BLD'!$A$22:$A$33),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$22:$A$33,MATCH(0,COUNTIF(E$50:$E63,'LTG-INT-BLD'!$A$22:$A$33),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$22:$A$33,MATCH(0,COUNTIF(E$50:$E64,'LTG-INT-BLD'!$A$22:$A$33),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$22:$A$33,MATCH(0,COUNTIF(E$50:$E65,'LTG-INT-BLD'!$A$22:$A$33),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$22:$A$33,MATCH(0,COUNTIF(E$50:$E66,'LTG-INT-BLD'!$A$22:$A$33),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$22:$A$33,MATCH(0,COUNTIF(E$50:$E67,'LTG-INT-BLD'!$A$22:$A$33),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$22:$A$33,MATCH(0,COUNTIF(E$50:$E68,'LTG-INT-BLD'!$A$22:$A$33),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$22:$A$33,MATCH(0,COUNTIF(E$50:$E69,'LTG-INT-BLD'!$A$22:$A$33),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$22:$A$33,MATCH(0,COUNTIF(E$50:$E70,'LTG-INT-BLD'!$A$22:$A$33),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$22:$A$33,MATCH(0,COUNTIF(E$50:$E71,'LTG-INT-BLD'!$A$22:$A$33),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$22:$A$33,MATCH(0,COUNTIF(E$50:$E72,'LTG-INT-BLD'!$A$22:$A$33),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$22:$A$33,MATCH(0,COUNTIF(E$50:$E73,'LTG-INT-BLD'!$A$22:$A$33),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$22:$A$33,MATCH(0,COUNTIF(E$50:$E74,'LTG-INT-BLD'!$A$22:$A$33),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$22:$A$33,MATCH(0,COUNTIF(E$50:$E75,'LTG-INT-BLD'!$A$22:$A$33),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$22:$A$33,MATCH(0,COUNTIF(E$50:$E76,'LTG-INT-BLD'!$A$22:$A$33),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$22:$A$33,MATCH(0,COUNTIF(E$50:$E77,'LTG-INT-BLD'!$A$22:$A$33),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$22:$A$33,MATCH(0,COUNTIF(E$50:$E78,'LTG-INT-BLD'!$A$22:$A$33),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$22:$A$33,MATCH(0,COUNTIF(E$50:$E79,'LTG-INT-BLD'!$A$22:$A$33),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$22:$A$33,MATCH(0,COUNTIF(E$50:$E80,'LTG-INT-BLD'!$A$22:$A$33),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$22:$A$33,MATCH(0,COUNTIF(E$50:$E81,'LTG-INT-BLD'!$A$22:$A$33),0))","v":{"$error":"#N/A"}},""]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$22:$A$33,MATCH(0,COUNTIF(E$50:$E82,'LTG-INT-BLD'!$A$22:$A$33),0))","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"INDEX('LTG-INT-BLD'!$A$22:$A$33,MATCH(0,COUNTIF(E$50:$E83,'LTG-INT-BLD'!$A$22:$A$33),0))","v":{"$error":"#N/A"}}]

{"sheet":"LTG-EXT","index":6,"n_rows":89,"n_cols":11,"rows_kept":89,"cut":false,"hidden":false,"merged":[[6,0,7,0],[3,0,4,0]]}
["Exterior Lighting",null,null,null,"LTG-EXT"]
[{"$f":"'LTG-SUM'!A2","v":"2015 Washington State Energy Code Compliance Forms for Commercial Buildings including R2, R3, R4 over 3 stories and all R1 "},null,null,null,{"$f":"'LTG-SUM'!G2","v":"Revised August 2016"}]
["Project Title:",{"$f":"IF('LTG-SUM'!C3=\"1 - This title will copy onto other forms\",\"Fill this line out on LGT-SUM\",'LTG-SUM'!C3)","v":"Fill this line out on LGT-SUM"},null,{"$f":"'LTG-SUM'!F3","v":"Date"},{"$f":"'LTG-SUM'!G3","v":"2016-07-01"}]
["Exterior Lighting Zone ",null,null,{"$f":"'LTG-SUM'!F4","v":"For Building Department Use"}]
[]
[]
["Calculation Area",null,null,null,{"$f":"'LTG-SUM'!F7","v":0}]
[]
[]
["Building Grounds"]
[]
[]
["Tradable Maximum Allowed Lighting Wattage NOTE 1",null,null,"Base Site Allowance:",{"$f":"Base_Site_Allowance","v":0}]
[]
["Tradable Surfaces","\nSurface Description","Area (ft2), perimeter (lf) or # of items","Allowed Watts\nper ft2 or per lf","Allowed Watts \nx ft2 (or x lf)",null,null,null," "]
[null,null,null,{"$f":"IF(A16<>\"\",VLOOKUP(A16,TradableAreas,Text_Col,FALSE),\"\")","v":""},{"$f":"IF(OR(ExtAlt_LT50pct,D16=\"\"),0,IF(ISNA(IF(VLOOKUP(A16,$A$24:$E$27,5,0)>0,\"\",NA())),\"Unlit\",C16*VLOOKUP(A16,TradableAreas,Numb_Col,FALSE)))","v":0},{"$f":"IF(ISNA(INDEX(A$16:A$20,MATCH(0,COUNTIF(F$15:$F15,A$16:A$20),0))),\"\",INDEX(A$16:A$20,MATCH(0,COUNTIF(F$15:$F15,A$16:A$20),0)))","v":0}]
[null,null,null,{"$f":"IF(A17<>\"\",VLOOKUP(A17,TradableAreas,Text_Col,FALSE),\"\")","v":""},{"$f":"IF(OR(ExtAlt_LT50pct,D17=\"\"),0,IF(ISNA(IF(VLOOKUP(A17,$A$24:$E$27,5,0)>0,\"\",NA())),\"Unlit\",C17*VLOOKUP(A17,TradableAreas,Numb_Col,FALSE)))","v":0},{"$f":"IF(ISNA(INDEX(A$16:A$20,MATCH(0,COUNTIF(F$15:$F16,A$16:A$20),0))),\"\",INDEX(A$16:A$20,MATCH(0,COUNTIF(F$15:$F16,A$16:A$20),0)))","v":""}]
[null,null,null,{"$f":"IF(A18<>\"\",VLOOKUP(A18,TradableAreas,Text_Col,FALSE),\"\")","v":""},{"$f":"IF(OR(ExtAlt_LT50pct,D18=\"\"),0,IF(ISNA(IF(VLOOKUP(A18,$A$24:$E$27,5,0)>0,\"\",NA())),\"Unlit\",C18*VLOOKUP(A18,TradableAreas,Numb_Col,FALSE)))","v":0},{"$f":"IF(ISNA(INDEX(A$16:A$20,MATCH(0,COUNTIF(F$15:$F17,A$16:A$20),0))),\"\",INDEX(A$16:A$20,MATCH(0,COUNTIF(F$15:$F17,A$16:A$20),0)))","v":""}]
[{"$f":"IF(ExtAlt_LT50pct,\"Existing Undefined Area\",\"\")","v":""},null,null,{"$f":"IF(ExtAlt_LT50pct,\"Enter Total Existing Wattage in Tradable Categories (prior to alteration):\",\"\")","v":""},null,{"$f":"IF(ISNA(INDEX(A$16:A$20,MATCH(0,COUNTIF(F$15:$F18,A$16:A$20),0))),\"\",INDEX(A$16:A$20,MATCH(0,COUNTIF(F$15:$F18,A$16:A$20),0)))","v":""}]
[]
[null,null,null,"Total Allowed Tradable + Site Allowance Watts:",{"$f":"IF(ExtAlt_LT50pct,E19,ROUNDUP(SUM(E13:E20),0))","v":0}]
["Tradable Proposed Lighting Wattage NOTE 2"]
["Tradable Surface","\nFixture  Description NOTE 3, 4","Number of \nFixtures","Watts per\nFixture NOTE 5","Watts \nProposed"]
[null,null,null,null,{"$f":"IF(AND(A24=\"\",C24=0,D24=0),0,IF(ExtAlt_LT50pct,    IF(ISNA(IF(VLOOKUP(A24,extAllowedTradableAreasLT50,1,FALSE)>0,\"\",NA())),\"Not Defined\",C24*D24),  IF(ISNA(IF(VLOOKUP(A24,$A$16:$E$20,3,FALSE)>0,\"\",NA())),\"Not Defined\",C24*D24)))","v":0}]
[null,null,null,null,{"$f":"IF(AND(A25=\"\",C25=0,D25=0),0,IF(ExtAlt_LT50pct,    IF(ISNA(IF(VLOOKUP(A25,extAllowedTradableAreasLT50,1,FALSE)>0,\"\",NA())),\"Not Defined\",C25*D25),  IF(ISNA(IF(VLOOKUP(A25,$A$16:$E$20,3,FALSE)>0,\"\",NA())),\"Not Defined\",C25*D25)))","v":0}]
[null,null,null,null,{"$f":"IF(AND(A26=\"\",C26=0,D26=0),0,IF(ExtAlt_LT50pct,    IF(ISNA(IF(VLOOKUP(A26,extAllowedTradableAreasLT50,1,FALSE)>0,\"\",NA())),\"Not Defined\",C26*D26),  IF(ISNA(IF(VLOOKUP(A26,$A$16:$E$20,3,FALSE)>0,\"\",NA())),\"Not Defined\",C26*D26)))","v":0},null,null,null,null,null,1]
[]
[null,null,null,"Total Proposed Tradable Watts:",{"$f":"ROUND(SUM(E24:E27),0)","v":0},null,{"$f":"COUNTIF(E24:E27,\"Not Defined\")","v":0}]
[]
[]
["Non-Tradable Maximum Allowed Lighting Wattage NOTE 1",null,null,"Site Allowance Remaining: ",{"$f":"site_available_nonTradable","v":0}]
[]
["Non-Tradable Surfaces","\nSurface Description","Area (ft2), perimeter (lf) or # of items","Allowed Watts\nper ft2 or per lf","Allowed Watts \nx ft2 (or x lf)"]
[null,null,null,{"$f":"IF(A34<>\"\",VLOOKUP(A34,NonTradableAreas,Text_Col,FALSE),\"\")","v":""},{"$f":"IF(AND(A34<>\"\",NOT(ExtAlt_LT50pct)),IF(ISNA(IF(VLOOKUP(A34,$A$41:$F$44,5,FALSE)>0,\"\",NA())),\"Unlit\",   ROUNDUP(IF(A34<>\"Automated Teller\",C34*VLOOKUP(A34,NonTradableAreas,Numb_Col,FALSE),IF(C34>0,270+(C34-1)*90,0)),0)),\"\")","v":""},{"$f":"IF(ISNA(INDEX(A$34:A$38,MATCH(0,COUNTIF(F$33:$F33,A$34:A$38),0))),\"\",INDEX(A$34:A$38,MATCH(0,COUNTIF(F$33:$F33,A$34:A$38),0)))","v":0}]
[null,null,null,"",{"$f":"IF(AND(A35<>\"\",NOT(ExtAlt_LT50pct)),IF(ISNA(IF(VLOOKUP(A35,$A$41:$F$44,5,FALSE)>0,\"\",NA())),\"Unlit\",   ROUNDUP(IF(A35<>\"Automated Teller\",C35*VLOOKUP(A35,NonTradableAreas,Numb_Col,FALSE),IF(C35>0,270+(C35-1)*90,0)),0)),\"\")","v":""},{"$f":"IF(ISNA(INDEX(A$34:A$38,MATCH(0,COUNTIF(F$33:$F34,A$34:A$38),0))),\"\",INDEX(A$34:A$38,MATCH(0,COUNTIF(F$33:$F34,A$34:A$38),0)))","v":""}]
[null,null,null,"",{"$f":"IF(AND(A36<>\"\",NOT(ExtAlt_LT50pct)),IF(ISNA(IF(VLOOKUP(A36,$A$41:$F$44,5,FALSE)>0,\"\",NA())),\"Unlit\",   ROUNDUP(IF(A36<>\"Automated Teller\",C36*VLOOKUP(A36,NonTradableAreas,Numb_Col,FALSE),IF(C36>0,270+(C36-1)*90,0)),0)),\"\")","v":""},{"$f":"IF(ISNA(INDEX(A$34:A$38,MATCH(0,COUNTIF(F$33:$F35,A$34:A$38),0))),\"\",INDEX(A$34:A$38,MATCH(0,COUNTIF(F$33:$F35,A$34:A$38),0)))","v":""}]
[null,null,null,"",{"$f":"IF(AND(A37<>\"\",NOT(ExtAlt_LT50pct)),IF(ISNA(IF(VLOOKUP(A37,$A$41:$F$44,5,FALSE)>0,\"\",NA())),\"Unlit\",   ROUNDUP(IF(A37<>\"Automated Teller\",C37*VLOOKUP(A37,NonTradableAreas,Numb_Col,FALSE),IF(C37>0,270+(C37-1)*90,0)),0)),\"\")","v":""},{"$f":"IF(ISNA(INDEX(A$34:A$38,MATCH(0,COUNTIF(F$33:$F36,A$34:A$38),0))),\"\",INDEX(A$34:A$38,MATCH(0,COUNTIF(F$33:$F36,A$34:A$38),0)))","v":""}]
[{"$f":"IF(ExtAlt_LT50pct,\"Existing Undefined Area\",\"\")","v":""},null,null,{"$f":"IF(ExtAlt_LT50pct,\"Enter Total Existing Wattage in Non-Tradable Categories (prior to alteration):\",\"\")","v":""},null,{"$f":"IF(ISNA(INDEX(A$34:A$38,MATCH(0,COUNTIF(F$33:$F37,A$34:A$38),0))),\"\",INDEX(A$34:A$38,MATCH(0,COUNTIF(F$33:$F37,A$34:A$38),0)))","v":""}]
["Non-Tradable Proposed Lighting Wattage NOTE 2"]
["Non-Tradable Surface","\nFixture  Description NOTE 3, 4","Number of \nFixtures","Watts per\nFixture NOTE 5","Watts \nProposed"]
[null,null,null,null,{"$f":"IF(AND(A41=\"\",C41=0,D41=0),0,IF(ExtAlt_LT50pct,    IF(ISNA(IF(VLOOKUP(A41,extAllowedNonTradableAreasLT50,1,FALSE)>0,\"\",NA())),\"Not Defined\",C41*D41), IF(ISNA(IF(VLOOKUP(A41,$A$34:$E$38,3,FALSE)>0,\"\",NA())),\"Not Defined\",ROUNDUP(C41*D41,0))))","v":0}]
[null,null,null,null,{"$f":"IF(AND(A42=\"\",C42=0,D42=0),0,IF(ExtAlt_LT50pct,    IF(ISNA(IF(VLOOKUP(A42,extAllowedNonTradableAreasLT50,1,FALSE)>0,\"\",NA())),\"Not Defined\",C42*D42), IF(ISNA(IF(VLOOKUP(A42,$A$34:$E$38,3,FALSE)>0,\"\",NA())),\"Not Defined\",ROUNDUP(C42*D42,0))))","v":0}]
[null,null,null,null,{"$f":"IF(AND(A43=\"\",C43=0,D43=0),0,IF(ExtAlt_LT50pct,    IF(ISNA(IF(VLOOKUP(A43,extAllowedNonTradableAreasLT50,1,FALSE)>0,\"\",NA())),\"Not Defined\",C43*D43), IF(ISNA(IF(VLOOKUP(A43,$A$34:$E$38,3,FALSE)>0,\"\",NA())),\"Not Defined\",ROUNDUP(C43*D43,0))))","v":0},null,null,null,null,null,1]
[null,null,null,"Non-Tradable Watts Exceeding LPA:",{"$f":"IF(Zone<5,Excess_Watts,\"\")","v":""},null,{"$f":"COUNTIF(E41:E44,\"Not Defined\")","v":0}]
[null,null,null,"Remaining Site Allowance:",{"$f":"IF(Zone<5,Site_Allowance_Balance,\"\")","v":""}]
[]
["Exterior Lighting",null,null,null,{"$f":"'LTG-EXT-REF'!N58","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Validation Range to Use"]
[null,null,"Tradable",{"$f":"IF(ExtAlt_LT50pct,\"extAllowedTradableAreasLT50\",\"extAllowedTradableAreas\")","v":"extAllowedTradableAreas"}]
[null,null,"NonTradable",{"$f":"IF(ExtAlt_LT50pct,\"extAllowedNonTradableAreasLT50\",\"extAllowedNonTradableAreas\")","v":"extAllowedNonTradableAreas"}]
[]
["Lists with space an end so user can select blank if they can't figure out to use delete key",null,"List for < 50% cas"]
[]
[{"$f":"'LTG-EXT-REF'!A12","v":"Tradable Locations"},null,{"$f":"'LTG-EXT-REF'!A12","v":"Tradable Locations"}]
[{"$f":"'LTG-EXT-REF'!A13","v":"Base Site Allowance"},null,{"$f":"'LTG-EXT-REF'!A13","v":"Base Site Allowance"}]
[{"$f":"'LTG-EXT-REF'!A14","v":"Uncovered Parking and drives"},null,{"$f":"'LTG-EXT-REF'!A14","v":"Uncovered Parking and drives"}]
[{"$f":"'LTG-EXT-REF'!A15","v":"Grounds Walkways  <10 wide"},null,{"$f":"'LTG-EXT-REF'!A15","v":"Grounds Walkways  <10 wide"}]
[{"$f":"'LTG-EXT-REF'!A16","v":"Grounds Walkways  >10' wide"},null,{"$f":"'LTG-EXT-REF'!A16","v":"Grounds Walkways  >10' wide"}]
[{"$f":"'LTG-EXT-REF'!A17","v":"Stairways"},null,{"$f":"'LTG-EXT-REF'!A17","v":"Stairways"}]
[{"$f":"'LTG-EXT-REF'!A18","v":"Pedestrian Tunnel"},null,{"$f":"'LTG-EXT-REF'!A18","v":"Pedestrian Tunnel"}]
[{"$f":"'LTG-EXT-REF'!A19","v":"Main Entry Door"},null,{"$f":"'LTG-EXT-REF'!A19","v":"Main Entry Door"}]
[{"$f":"'LTG-EXT-REF'!A20","v":"Other Entry Door"},null,{"$f":"'LTG-EXT-REF'!A20","v":"Other Entry Door"}]
[{"$f":"'LTG-EXT-REF'!A21","v":"Entry Canopies"},null,{"$f":"'LTG-EXT-REF'!A21","v":"Entry Canopies"}]
[{"$f":"'LTG-EXT-REF'!A22","v":"Sales Canopies "},null,{"$f":"'LTG-EXT-REF'!A22","v":"Sales Canopies "}]
[{"$f":"'LTG-EXT-REF'!A23","v":"Open Area Sales"},null,{"$f":"'LTG-EXT-REF'!A23","v":"Open Area Sales"}]
[{"$f":"'LTG-EXT-REF'!A24","v":"Vehicle Sales Street Frontage"},null,{"$f":"'LTG-EXT-REF'!A24","v":"Vehicle Sales Street Frontage"}]
[null,null,{"$f":"'LTG-EXT-REF'!A25","v":"Existing Undefined Area"}]
[null,null,{"$f":"'LTG-EXT-REF'!A26","v":0}]
[null,null,{"$f":"'LTG-EXT-REF'!A27","v":0}]
[{"$f":"'LTG-EXT-REF'!A29","v":0},null,{"$f":"'LTG-EXT-REF'!A28","v":0}]
[null,null,{"$f":"'LTG-EXT-REF'!A29","v":0}]
[{"$f":"'LTG-EXT-REF'!A30","v":0},null,{"$f":"'LTG-EXT-REF'!A30","v":0}]
[{"$f":"'LTG-EXT-REF'!A31","v":"Non-Tradable"},null,{"$f":"'LTG-EXT-REF'!A31","v":"Non-Tradable"}]
[{"$f":"'LTG-EXT-REF'!A32","v":"Base Site Allowance"},null,{"$f":"'LTG-EXT-REF'!A32","v":"Base Site Allowance"}]
[{"$f":"'LTG-EXT-REF'!A33","v":"Bldg. Façade"},null,{"$f":"'LTG-EXT-REF'!A33","v":"Bldg. Façade"}]
[{"$f":"'LTG-EXT-REF'!A34","v":"Automated Teller"},null,{"$f":"'LTG-EXT-REF'!A34","v":"Automated Teller"}]
[{"$f":"'LTG-EXT-REF'!A35","v":"Gate House"},null,{"$f":"'LTG-EXT-REF'!A35","v":"Gate House"}]
[{"$f":"'LTG-EXT-REF'!A36","v":"Loading Areas - Law & EMS"},null,{"$f":"'LTG-EXT-REF'!A36","v":"Loading Areas - Law & EMS"}]
[{"$f":"'LTG-EXT-REF'!A37","v":"Drive up Windows & Doors"},null,{"$f":"'LTG-EXT-REF'!A37","v":"Drive up Windows & Doors"}]
[{"$f":"'LTG-EXT-REF'!A38","v":"24 Hour Retail Entrance Parking"},null,{"$f":"'LTG-EXT-REF'!A38","v":"24 Hour Retail Entrance Parking"}]
[null,null,{"$f":"'LTG-EXT-REF'!A39","v":"Existing Undefined Area"}]

{"sheet":"LTG-EXT-REF","index":7,"n_rows":59,"n_cols":22,"rows_kept":59,"cut":false,"hidden":true,"merged":[[10,10,10,11],[29,8,29,9],[10,8,10,9],[10,1,10,2],[29,3,29,4],[10,3,10,4],[29,5,29,6],[10,5,10,6],[29,1,29,2]]}
["Calculation Scope","ExtAlt_LT50pct"]
[5,{"$f":"ExtCalculationScope=1","v":false}]
[]
[]
["Selected Lighting Zone",5,"Site Allowance",{"$f":"IF(ExtAlt_LT50pct,0,VLOOKUP(\"Base Site Allowance\",TradableAreas,Numb_Col,FALSE))","v":0}]
["Column Index"]
["Text","Number"]
[{"$f":"ROUND(IF(B5>=4,3,2)+(Zone-1)*2,1)","v":11},{"$f":"ROUND(IF(B5>=4,4,3)+(Zone-1)*2,1)","v":12}]
["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.08 W/ft2",0.08,null,"0.10 W/ft2",0.1,"Select Zone",0,{"$f":"SUMIF('LTG-EXT'!$A$16:$A$20,A14,'LTG-EXT'!$E$16:$E$20)","v":0},{"$f":"SUMIF('LTG-EXT'!$A$24:$A$27,A14,'LTG-EXT'!$E$24:$E$27)","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$16:$A$20,A15,'LTG-EXT'!$E$16:$E$20)","v":0},{"$f":"SUMIF('LTG-EXT'!$A$24:$A$27,A15,'LTG-EXT'!$E$24:$E$27)","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$16:$A$20,A16,'LTG-EXT'!$E$16:$E$20)","v":0},{"$f":"SUMIF('LTG-EXT'!$A$24:$A$27,A16,'LTG-EXT'!$E$24:$E$27)","v":0},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$16:$A$20,A17,'LTG-EXT'!$E$16:$E$20)","v":0},{"$f":"SUMIF('LTG-EXT'!$A$24:$A$27,A17,'LTG-EXT'!$E$24:$E$27)","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$16:$A$20,A18,'LTG-EXT'!$E$16:$E$20)","v":0},{"$f":"SUMIF('LTG-EXT'!$A$24:$A$27,A18,'LTG-EXT'!$E$24:$E$27)","v":0},0,0]
["Main Entry Door","20W/LF door",20,"20W/LF door",20,"30W/LF door",30,null,"30W/LF door",30,"Select Zone",0,{"$f":"SUMIF('LTG-EXT'!$A$16:$A$20,A19,'LTG-EXT'!$E$16:$E$20)","v":0},{"$f":"SUMIF('LTG-EXT'!$A$24:$A$27,A19,'LTG-EXT'!$E$24:$E$27)","v":0},0,0]
["Other Entry Door","20W/LF door",20,"20W/LF door",20,"20W/LF door",20,null,"20W/LF door",20,"Select Zone",0,{"$f":"SUMIF('LTG-EXT'!$A$16:$A$20,A20,'LTG-EXT'!$E$16:$E$20)","v":0},{"$f":"SUMIF('LTG-EXT'!$A$24:$A$27,A20,'LTG-EXT'!$E$24:$E$27)","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$16:$A$20,A21,'LTG-EXT'!$E$16:$E$20)","v":0},{"$f":"SUMIF('LTG-EXT'!$A$24:$A$27,A21,'LTG-EXT'!$E$24:$E$27)","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$16:$A$20,A22,'LTG-EXT'!$E$16:$E$20)","v":0},{"$f":"SUMIF('LTG-EXT'!$A$24:$A$27,A22,'LTG-EXT'!$E$24:$E$27)","v":0},0,0]
["Open Area 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$16:$A$20,A23,'LTG-EXT'!$E$16:$E$20)","v":0},{"$f":"SUMIF('LTG-EXT'!$A$24:$A$27,A23,'LTG-EXT'!$E$24:$E$27)","v":0},0,0]
["Vehicle 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$16:$A$20,A24,'LTG-EXT'!$E$16:$E$20)","v":0},{"$f":"SUMIF('LTG-EXT'!$A$24:$A$27,A24,'LTG-EXT'!$E$24:$E$27)","v":0},{"$f":"IF(AND(M24>0,N24=0),1,0)","v":0},{"$f":"IF(AND(N24>0,M24=0),1,0)","v":0}]
["Existing Undefined Area",null,0,null,0,null,0,null,null,0,"Select Zone",0,{"$f":"SUMIF('LTG-EXT'!$A$16:$A$20,A25,'LTG-EXT'!$E$16:$E$20)","v":0},{"$f":"SUMIF('LTG-EXT'!$A$24:$A$27,A25,'LTG-EXT'!$E$24:$E$27)","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,null,"Site Remaining After Tradable"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('LTG-EXT'!E21-'LTG-EXT'!E28>0,Base_Site_Allowance,'LTG-EXT'!E21-'LTG-EXT'!E28+Base_Site_Allowance)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Site Available for NonTradeable",null,null,"Not USED"]
[null,"Zone 1",null,"Zone 2",null,"Zone 3",null,null,"Zone 4",null,null,null,null,null,null,{"$f":"IF(ExtAlt_LT50pct,0,MAX(0,Site_Remaining))","v":0},null,"Fail Flag","No Site Allowance",null,"With Site Allowance"]
["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"]
["Base Site Allowance","500 W",500,"600 W",600,"750 W",750,null,"1300 W",1300,"Select Zone",0,0,0,{"$f":"IF(ExtAlt_LT50pct,0,MAX(0,$N32-$M32))","v":0},{"$f":"MAX(0,site_available_nonTradable)-O32","v":0},{"$f":"IF(ROUND(N32,0)>ROUND(M32,0),1,0)","v":0},{"$f":"IF(AND(Q32=1,P32<0),1,0)","v":0},null,{"$f":"Q32","v":0},null,{"$f":"R32","v":0}]
["Bldg. Façade","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$34:$A$38,A33,'LTG-EXT'!$E$34:$E$38)","v":0},{"$f":"SUMIF('LTG-EXT'!$A$41:$A$44,A33,'LTG-EXT'!$E$41:$E$44)","v":0},0,{"$f":"$P32-O33","v":0},0,0,{"$f":"IF(Q33=1,IF(T33=1,A33,CONCATENATE(\" & \",A33) ),\"\")","v":""},{"$f":"T32+Q33","v":0},null,{"$f":"V32+R33","v":0}]
["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$34:$A$38,A34,'LTG-EXT'!$E$34:$E$38)","v":0},{"$f":"SUMIF('LTG-EXT'!$A$41:$A$44,A34,'LTG-EXT'!$E$41:$E$44)","v":0},0,0,0,0,"",0,{"$f":"IF(R34=1,IF(V34=1,A34,CONCATENATE(\" & \",A34) ),\"\")","v":""},0]
["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$34:$A$38,A35,'LTG-EXT'!$E$34:$E$38)","v":0},{"$f":"SUMIF('LTG-EXT'!$A$41:$A$44,A35,'LTG-EXT'!$E$41:$E$44)","v":0},0,0,0,0,"",0,"",0]
["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$34:$A$38,A36,'LTG-EXT'!$E$34:$E$38)","v":0},{"$f":"SUMIF('LTG-EXT'!$A$41:$A$44,A36,'LTG-EXT'!$E$41:$E$44)","v":0},0,0,0,0,"",0,"",0]
["Drive up Windows & Doors","400W/driveup",400,"400W/driveup",400,"400W/driveup",400,null,"400W/driveup",400,"Select Zone",0,{"$f":"SUMIF('LTG-EXT'!$A$34:$A$38,A37,'LTG-EXT'!$E$34:$E$38)","v":0},{"$f":"SUMIF('LTG-EXT'!$A$41:$A$44,A37,'LTG-EXT'!$E$41:$E$44)","v":0},0,0,0,{"$f":"IF(AND(Q37=1,P37<0),1,0)","v":0},"",0,"",0]
["24 Hour Retail Entrance Parking","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$34:$A$38,A38,'LTG-EXT'!$E$34:$E$38)","v":0},{"$f":"SUMIF('LTG-EXT'!$A$41:$A$44,A38,'LTG-EXT'!$E$41:$E$44)","v":0},0,0,{"$f":"IF(ROUND(N38,0)>ROUND(M38,0),1,0)","v":0},{"$f":"IF(AND(Q38=1,P38<0),1,0)","v":0},{"$f":"IF(Q38=1,IF(T38=1,A38,CONCATENATE(\" & \",A38) ),\"\")","v":""},0,{"$f":"IF(R38=1,IF(V38=1,A38,CONCATENATE(\" & \",A38) ),\"\")","v":""},0]
["Existing Undefined Area",null,0,null,0,null,0,null,null,0,"Select Zone",0,{"$f":"SUMIF('LTG-EXT'!$A$34:$A$38,A39,'LTG-EXT'!$E$34:$E$38)","v":0},{"$f":"SUMIF('LTG-EXT'!$A$41:$A$44,A39,'LTG-EXT'!$E$41:$E$44)+SUM(N32:N38)","v":0},{"$f":"IF(ExtAlt_LT50pct,MAX(0,$N39-$M39),0)","v":0},0,0,{"$f":"IF(AND(Q39=1,P39<0),1,0)","v":0},"",0,"",0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Excess Watts","Site Allowance Balance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O32:O40)","v":0},{"$f":"IF(Site_Remaining<0,P39+Site_Remaining,P39)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Total in Categories",null,null,{"$f":"SUM(N33:N40)","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$41:$C$44,'LTG-EXT'!$D$41:$D$44) + SUMPRODUCT('LTG-EXT'!$C$24:$C$27,'LTG-EXT'!$D$24:$D$27)","v":0},"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'!G28>0,'LTG-EXT'!G44>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," NOT USED - WAS =IF(N45>N44+0.01,\"PROPOSED WATTS IN UNDEFINED AREA\",\"\")"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Façade Warning",null,"logic"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WSEC 2015 if proposed lighting enter - check compliance else be blank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Undefined Surface Warning",null,"if non-tradable light entered without cateory throw error. If okay then:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N47,IF('LTG-EXT'!G28>0,\"- \"&IF('LTG-EXT'!G44>0,\"Non-Tradable and tradable information are incomplete. \",\"Tradable information is incomplete. \"),IF('LTG-EXT'!G44>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"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Error Msg for LTG-EXT!A51"," new has \" \" so that complies does not show","if NOT(no grace and grace =0) then fail all items"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N46>0,IF(N52<>\"\",N52,IF(N54<>\"\",N54,\"\")),\"\")","v":""},null,"if not no grace but grace=0 then xxxxx"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Fail Msg"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N46>0,'LTG-EXT'!E28>0),IF(Zone=5,\"LIGHTING ZONE IS NOT SPECIFIED\",IF(ExtCalculationScope=5,\"CALCULATION SCOPE IS NOT SPECIFIED\",IF(OR(N52<>\"\",N54<>\"\"),\"DOES NOT COMPLY - DATA INCOMPLETE\", IF(SUM(R33:R40)=0,IF(Site_Remaining>=0,\"COMPLIES WITH \" & N59,\"TRADABLE EXCEEDS \" &N59 &\": DOES NOT COMPLY\"),IF(Site_Remaining>=0,\"NON-TRADABLE EXCEEDS \" &N59&\": DOES NOT COMPLY\",\"BOTH SECTIONS EXCEED \" &N59&\": DOES NOT COMPLY\"))))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ExtAlt_LT50pct,\"MAX. ALLOWANCE\",\"MAX. ALLOWANCE\")","v":"MAX. ALLOWANCE"},"was: =IF(ExtAlt_LT50pct,\"ALTERATION ALLOWANCE\",\"SITE ALLOWANCE\")"]

{"sheet":"LTG-CHK","index":8,"n_rows":118,"n_cols":6,"rows_kept":118,"cut":false,"hidden":false,"merged":[[61,0,64,0],[61,1,64,1],[61,2,64,2],[52,1,54,1],[52,2,54,2],[52,0,54,0],[50,0,51,0],[50,1,51,1],[50,2,51,2],[111,0,111,5],[18,0,20,0],[18,1,20,1],[18,2,20,2],[26,0,27,0],[26,1,27,1],[26,2,27,2],[21,0,24,0],[21,1,24,1],[48,0,49,0],[48,1,49,1],[48,2,49,2],[35,0,37,0],[35,1,37,1],[35,2,37,2],[44,0,46,0],[44,1,46,1],[44,2,46,2],[38,0,39,0],[38,1,39,1],[38,2,39,2],[40,0,43,0],[40,1,43,1],[40,2,43,2],[93,0,94,0],[93,1,94,1],[93,2,94,2],[73,0,75,0],[73,1,75,1],[73,2,75,2],[88,0,90,0],[88,1,90,1],[88,2,90,2],[21,2,24,2],[13,0,14,0],[13,1,14,1],[13,2,14,2],[11,0,12,0],[11,1,12,1],[11,2,12,2]]}
["Lighting, Motor, and Electrical Permit Checklist, Pg. 1",null,null,null,null,"LTG-CHK"]
[{"$f":"'LTG-SUM'!A2","v":"2015 Washington State Energy Code Compliance Forms for Commercial Buildings including R2, R3, R4 over 3 stories and all R1 "},null,null,null,null,{"$f":"'LTG-SUM'!G2","v":"Revised August 2016"}]
["Project Title: ",null,{"$f":"IF('LTG-SUM'!C3=\"1 - This title will copy onto other forms\",\"Fill this line out on LGT-SUM\",'LTG-SUM'!C3)","v":"Fill this line out on LGT-SUM"},null,"Date",{"$f":"'LTG-SUM'!G3","v":"2016-07-01"}]
[]
["Applicability (yes,no,na)","Code Section","Component","Compliance information required in permit documents","Location in Documents","Building Department Notes"]
["LIGHTING CONTROLS"]
[null,"C405.2","Lighting controls, general","For all lighting fixtures, indicate lighting control method on plans for spaces and lighting zone(s) served, or exception taken"]
[null,"C405.2","Luminaire level lighting controls (LLLC)","Indicate on plans all fixtures provided with LLLC in lieu of C405.2 lighting controls; provide description of control capabilities and performance parameters"]
[null,"C405.1","Lighting in dwelling units","For permanently installed lighting fixtures in dwelling units, indicate  lighting control method on plans for spaces and lighting zone(s) served, or demonstrate compliance with high efficacy exception"]
[null,"C405.2.3 C405.2.1.1\nC405.2.2.2 C405.2.4 C405.2.5","Manual controls","Indicate on plans the method of manual lighting control (whether combined with occupancy sensor, automatic light reduction,  daylight responsive or specific application controls), location of manual control device and area or specifice application it serves"]
[null,"C405.2.2.1\nC405.2.2.2\nC405.2.3","Manual interior lighting controls","Indicate on plans which method of manual 50% lighting load reduction is provided, or whether lighting load is reduced via occupancy sensors or daylight responsive controls"]
[null,"C405.2.2","Method of automatic shut-off control","Indicate on plans the method of automatic shut-off control during unoccupied periods (occupancy sensor or time switch) for all lighting zones;"]
[null,null,null,"Indicate locations where automatic shutoff is provided by other methods (occupancy sensor or digital timer switch) or which time switch control exception applies"]
[null,"C405.2.1\nC405.2.1.1","Occupancy sensor controls","Indicate on plans the spaces served by occupancy sensors;"]
[null,null,null,"Indicate whether occupancy sensor controls are configured to be manual-on, automatic 50%-on, or serve a space eligible for automatic 100%-on per exception"]
[null,"C405.2.1.2","Occupancy sensor controls - warehouses","Indicate aisleways and open areas in warehouse spaces provided with occupancy sensor controls that reduce lighting power by 50% "]
[null,"C405.2.6","Digital timer switch","Indicate required digital timer switch control function when control is used"]
[null,"C405.2.2.1","Automatic time switch controls","Indicate locations of override switches on plans and the lighting zone(s) served, include area sq. ft."]
[null,"C405.2.4.2\nC405.2.4.3","Daylight zones - Sidelight and toplight","Indicate primary and secondary sidelight daylight zone areas on plans, include sq. ft.;"]
[null,null,null,"Indicate toplight daylight zone areas on plans, include sq. ft.;"]
[null,null,null,"For small vertical fenestration assemblies (rough opening less than 10 percent of primary daylight zone) where daylight responsive controls are not required, provide fenestration area to daylight zone calculation(s) "]
[null,"C405.2.4","Daylight responsive controls","Indicate on plans lighting zone(s) served by daylight responsive controls;"]
[null,null,null,"Identify sidelight and toplight daylight zones that are not provided with daylight sensing controls and the exception(s) that apply;"]
[null,null,null,"Indicate on plans the lighting load reduction method - continuous dimming, or stepped dimming that provides at least two even steps between 0%-100% of rated power;"]
[null,null,null,"Indicate that daylight sensing controls are configured to completely shut off all controlled lights in the lighting zone"]
[null,"C405.2.5","Additional controls - Specific application lighting controls ","Identify spaces and lighting fixtures on plans that require specific application lighting controls per this section"]
[null,"C405.2.5 - Items 1&2","Display and accent lighting","Indicate on plans that display and accent lighting, and display case lighting are controlled independently from both general area lighting and other lighting applications within the same space; "]
[null,null,null,"Indicate manual and automatic lighting control method "]
["Lighting, Motor, and Electrical Permit Checklist, Pg. 2",null,null,null,null,"LTG-CHK"]
[{"$f":"A$2","v":"2015 Washington State Energy Code Compliance Forms for Commercial Buildings including R2, R3, R4 over 3 stories and all R1 "},null,null,null,null,{"$f":"$F$2","v":"Revised August 2016"}]
["Project Title: ",null,{"$f":"$C$3","v":"Fill this line out on LGT-SUM"},null,"Date",{"$f":"$F$3","v":"2016-07-01"}]
[]
["Applicability (yes,no,na)","Code Section","Component","Compliance information required in permit documents","Location in Documents","Building Department Notes"]
[null,"C405.2.5 - Item 3","Hotel/motel guest rooms","Indicate method of automatic control - vacancy or captive key control of all installed luminaires and switched receptacles in guest room"]
[null,"C405.2.5 - Item 4","Supplemental task lighting ","Indicate method and location of automatic shut-off vacancy control for supplemental task lighting, including under-shelf or under-cabinet lighting"]
[null,"C405.2.5 - Item 5","Lighting for non-visual applications","Indicate on plans eligible non-visual lighting applications, include sq. ft. area of each lighting control zone;"]
[null,null,null,"Indicate on plans that non-visual lighting are controlled independently from both general area lighting and other lighting applications within the same space; "]
[null,null,null,"Indicate method of manual lighting control and applicable automatic lighting control"]
[null,"C405.2.5 - Item 6","Lighting equipment for sale or demonstration","Indicate on plans that lighting equipment for sale or demonstration  are controlled independently from both general area lighting and other lighting applications within the same space; "]
[null,null,null,"Indicate method of manual lighting control and applicable automatic lighting control"]
[null,"C405.2.5 - Item 7","Means of egress lighting","Identify on plans egress fixtures that function as both normal and emergency means of egress illumination;"]
[null,null,null,"Provide calculation of lighting power density of total egress lighting; "]
[null,null,null,"If total egress lighting power density is greater than 0.02 W/sq. ft., indicate on plans egress fixtures requiring automatic shut-off  during unoccupied periods;"]
[null,null,null,"Indicate method of automatic shut-off control"]
[null,"C405.2.7","Exterior lighting controls ","Indicate on exterior lighting plans and fixture schedules the automatic lighting control method, control sequence, and locations served;"]
[null,null,null,"For building façade and landscape lighting, indicate automatic controls shut off lighting as a function of dawn/dusk and fixed  opening/closing time;"]
[null,null,null,"For all other exierior lighting, indicate automatic controls shut off lighting as a function of available daylight; include control sequence that also reduces lighting power by at least 30% between 12am-6am, or from 1 hour after closing to 1 hour before opening, or based upon motion sensor"]
[null,"C405.5.1","Exterior building grounds lighting controls","For building grounds fixtures greater than 100 watts, indicate on plans whether fixtures have efficacy greater than 80 lumens or; are controlled by motion sensor, or are exempt lighting per C405.5.2 "]
[null,"C405.2.5","Area controls - Master control switches and circuit power limit","Indicate location(s) of master control switch(es) intended to control multiple independent switches; circuit breaker may not be used as a master control switch;"]
[null,null,null,"Verify that no 20 amp circuit controlled by a single switch or automatic control is loaded beyond 80%"]
[null,"C406.4","Enhanced digital lighting controls","To comply with additional efficiency package option, indicate on plans all interior lighting fixtures that are individually addressed and provided with continuous dimming, or exception taken;"]
[null,null,null,"Include calculation of percent total installed interior lighting power that is configured with required enhanced lighting control functions (min 90% to comply with additional efficiency package option)"]
[null,"C405.13\nC408.3","Lighting system functional testing","If claiming lighting system commissioning exemption provide supporting calculation;"]
[null,null,null,"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"]
["Lighting, Motor, and Electrical Permit Checklist, Pg. 3",null,null,null,null,"LTG-CHK"]
[{"$f":"A$2","v":"2015 Washington State Energy Code Compliance Forms for Commercial Buildings including R2, R3, R4 over 3 stories and all R1 "},null,null,null,null,{"$f":"$F$2","v":"Revised August 2016"}]
["Project Title: ",null,{"$f":"$C$3","v":"Fill this line out on LGT-SUM"},null,"Date",{"$f":"$F$3","v":"2016-07-01"}]
[]
["Applicability (yes,no,na)","Code Section","Component","Compliance information required in permit documents","Location in Documents","Building Department Notes"]
["INTERIOR LIGHTING POWER & EFFICACY "]
[null,"C405.4.1 C405.4.1 C405.4.2 ","Total connected interior lighting power","Include all luminaires in lighting fixture schedule; indicate fixture types, lamps, ballasts, and manufacturer's rated watts per fixture;"]
[null,null,null,"Identify spaces eligible for lighting power exemption on plans and in compliance forms; indicate the exception applied;"]
[null,null,null,"Identify lighting equipment eligible for lighting power exemption in fixture schedule and in compliance forms; indicate the exception applied;"]
[null,null,null,"Indicate that exempt lighting equipment is in addition to general area lighting and is controlled independently"]
[null,"C405.3","Exit signs","Indicate location of exit signs on plans and rated watts per fixture in lighting fixture schedule (maximum 5 watts per fixture)"]
[null,"C405.1","Lighting in dwelling units - lamp efficacy","If high efficacy exception is applied to permanently installed lighting fixtures in dwelling units, indicate in lighting fixture schedule if lamps in fixtures are high efficacy per R404.1. Calculate percentage of fixtures with high efficacy lamps in project (min 75% to comply with exception)."]
[null,"C406.3","Reduced lighting power density - dwelling unit lamp efficacy","For project with dwelling units, to comply with additional efficiency package option indicate in lighting fixture schedule if lamps in fixtures have efficacy rating of 60 lumens per watt or more. Calculate percentage of fixtures with lamps that have this efficacy rating (min 95% to comply with option)."]
[null,"Lighting Power Calculation - Indicate compliance path taken"]
[null,"C405.4.2.1","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"]
[null,"C405.4.2.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, lobby art & exhibit display areas, and ceiling heights as applicable"]
[null,"C406.3","Reduced lighting power density","To comply with additional efficiency package option, demonstrate in compliance forms that total connected interior lighting wattage is 75% less than the total maximum allowed lighting wattage via Building Area Method or Space-By-Space Method"]
["EXTERIOR LIGHTING POWER & EFFICACY"]
[null,"C405.5.2","Total connected exterior lighting power","Include all luminaires in lighting fixture schedule; indicate fixture types, lamps, ballasts, and manufacturer's rated watts per fixture;"]
[null,null,null,"Identify exterior applications eligible for lighting power exemption on plans and in compliance forms; indicate exception applied;"]
[null,null,null,"Indicate that exempt exterior lighting is controlled independently from non-exempt exterior lighting; include exception claimed for each fixture or group of fixtures under exception category"]
[null,"Table C405.5.2(1)","Exterior lighting zone","Indicate building exterior lighting zone as defined by the AHJ"]
[null," C405.5.1","Exterior building grounds lighting","For building grounds fixtures rated at greater than 100 watts that are complying based on efficacy, indicate rated lamp efficacy (in lumens per watt) in fixture schedule"]
[null,"C405.5.2","Exterior lighting power calculations","Complete required compliance form – proposed wattage for exterior lighting plus base site allowed does not exceed maximum allowed"]
["Lighting, Motor, and Electrical Permit Checklist, Pg. 4",null,null,null,null,"LTG-CHK"]
[{"$f":"A$2","v":"2015 Washington State Energy Code Compliance Forms for Commercial Buildings including R2, R3, R4 over 3 stories and all R1 "},null,null,null,null,{"$f":"$F$2","v":"Revised August 2016"}]
["Project Title: ",null,{"$f":"$C$3","v":"Fill this line out on LGT-SUM"},null,"Date",{"$f":"$F$3","v":"2016-07-01"}]
[]
["Applicability (yes,no,na)","Code Section","Component","Compliance information required in permit documents","Location in Documents","Building Department Notes"]
["MOTORS & TRANSFORMERS"]
[null,"C405.6","Electrical tranformers","Include electrical transformer schedule on electrical plans; indicate  transformer size, efficiency, or exception taken"]
[null,"C405.7","Dwelling unit electrical energy consumption","Indicate on electrical plans that each dwelling unit in Group R-2 has a separate electrical energy meter"]
[null,"C405.8","Electric motor efficiency","Include all motors, including fractional hp motors, in electric motor schedule on electrical plans; indicate hp, rpm, rated efficiency, or exception applied"]
[null,"C405.9.1","Elevator cabs","For luminaires in each elevator cab, provide calculated average efficacy of combined fixtures that indicates efficacy is not less than 35 lumens per watt; "]
[null,null,null,"Indicate rated watts per cfm for elevator cab ventilation fans do not exceed 0.33 watts per cfm;"]
[null,null,null,"Indicate automatic controls that de-energize lighting and ventilation fans when elevator is stopped and unoocupied for a period of 15 minutes or more"]
[null,"C405.9.2","Escalators and moving walks","Indicate escalators comply with ASME A17.1/CSA B44; automatic controls are configured to reduce operational speed to the minimum permitted when not in use"]
[null,"C405.9.3","Regenerative drive","Indicate all one-way down or reversible escalators are provided with a variable frequency regenerative drive"]
[null,"C405.10","Controlled receptacles","Identify all controlled and uncontrolled receptables on electrical plans in each space in which they are required; include receptacle configuration such as spacing between controlled and uncontrolled, duplex devices, etc;"]
[null,null,null,"Indicate on plans whether the method of automatic control for each controlled receptable zone is by occupant sensor or programmable time-of-day control"]
["If \"no\" is selected for any question, provide explanation:"]
[]
[]
[]
[]
[]
[]
["  Yes"]
["  No"]
["  N.A."]
[]
[]
[]
[]
[]
[]
["End of Lighting, Motor & Transformer Permit Documents Checklist"]
[]
[]
[]
["NA"]
["No"]
["Yes"]