{"text_format":"3","workbook":"xlsx","n_sheets":13,"sheets":["Start Here!"," Requirements COMcheck","As-Built COMcheck","Invoices COMcheck"," Requirements Individual Files","Sq. Ft. Area Individual Files","Fixture List Individual Files","Wattage Individual Files","Invoices Individual Files","Helpful Tips Individual Files","RevisionHistory","Helpful Tips COMcheck","Admin_Lists"],"not_rendered":{"images":12,"macros":1,"defined_names":24,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Start Here!","index":0,"n_rows":114,"n_cols":35,"rows_kept":114,"merged":[[1,1,1,11],[3,1,3,11],[4,1,4,2],[5,1,5,10],[6,3,6,11],[7,2,7,10],[8,3,8,11],[9,2,9,10],[9,13,9,14],[9,16,9,17],[10,3,10,11],[11,2,11,10],[12,3,12,11],[13,1,13,11],[14,1,14,2],[14,3,14,11],[15,1,15,2],[15,3,15,11],[16,1,16,2],[16,3,16,5],[16,7,16,8],[16,10,16,11],[17,1,17,2],[17,3,17,11],[18,1,18,2],[18,3,18,11],[19,1,19,2],[19,3,19,11],[21,9,21,11],[21,13,21,17],[22,9,22,10],[22,13,22,17],[23,6,23,7],[23,9,23,10],[23,13,23,17],[24,6,25,7],[24,9,24,10],[24,13,25,17],[24,18,25,18],[25,9,25,10],[26,6,28,7],[26,9,26,10],[26,13,26,17],[27,9,27,11],[27,13,28,17],[27,18,28,18],[29,13,30,17],[29,18,30,18],[30,2,30,11],[31,13,31,17],[32,13,32,17],[33,13,33,17],[59,1,60,1],[94,29,94,30],[95,29,95,30],[95,34,95,38],[96,29,96,30],[96,34,96,38],[97,29,97,30],[97,34,97,38],[106,30,110,30]]}
[]
[null,"\nNew Construction Interior Lighting Supplemental Workbook"]
[]
[null,"Required documentation (COMcheck, floorplan and/or lighting layout) must be signed by a lighting professional with one or more of the following credentials:\n • Lighting Certification (LC) designation from National Council on Qualifications for the Lighting Professions (NCQLP)\n • Certified Lighting Efficiency Professional (CLEP) from the Association of Energy Engineers (AEE)\n • Certified Lighting Management Consultant (CLMC)\n • State of Wisconsin Professional Engineer (PE) License\n • Member of International Association of Lighting Designers (IALD)\n • Lighting Specialist II certification from National Association of Innovative Lighting Distributors (NAILD)\n • Commercial and Industrial Lighting Certificate form the Illuminating Engineering Society of America (IES)\n • Registered designer of electrical engineering systems in the state of Wisconsin\n • Member of the Institute of Electrical and Electronics Engineers (IEEE)\n • Other credential approved by Focus on Energy"]
[null,"Qualify the Project:"]
[null,"Do you have a completed As-built COMcheck using 2015 IECC or AHRAE 90.1-2013 signed by a credentialed lighting designer? ",{"$nulls":9},"Select Yes or No"]
[{"$nulls":3},{"$f":"IF(L6=\"Yes\",\"Select 'COMcheck' from the 'I'm providing the required info via:' drop-down below and proceed\",IF(L6=\"No\",\"Continue to next question\",IF(L6=\"Select Yes or No\",\" \")))","v":" "}]
[null,null,{"$f":"IF(L6=\"No\",\"Was the project overseen by a credentialed lighting designer (see list above)?\",IF(L6=\"Yes\", \"\",\"\"))","v":""},{"$nulls":8},"Select Yes or No"]
[{"$nulls":3},{"$f":"IF(L8=\"Yes\",\"Select 'Individual Files' from the 'I'm providing the required info via:' drop-down below and proceed\",IF(L8=\"No\",\"Continue to next question\",IF(L8=\"Select Yes or No\",\" \")))","v":" "}]
[null,null,{"$f":"IF(L8=\"No\",\"Are ALL fixtures installed either DLC or ENERGY® STAR listed?\",\"\")","v":""},{"$nulls":8},"Select Yes or No",null,"SPECTRUM entry:",null,null,"SPECTRUM entry (NLC Savings):"]
[{"$nulls":3},{"$f":"IF(L10=\"Yes\",\"Select 'Individual Files' from the 'I'm providing the required info via:' drop-down below and proceed\",IF(L10=\"No\",\"Project does not qualify, do not proceed\",IF(L10=\"Select Yes or No\",\" \")))","v":" "},{"$nulls":9},"Unit of Measure Answer",{"$f":"W88","v":0},"net KWh reduced all areas","Unit of Measure Answer",{"$f":"'Fixture List Individual Files'!N1065","v":0},"net KWh reduced all areas"]
[null,null,"Do any of the fixtures have NLC controls on them?",{"$nulls":8},"Select Yes or No",null,"Units",1,null,"Units",1]
[{"$nulls":3},{"$f":"IF(AND(L12=\"Yes\"),\"Focus on Energy will contact you for more information.\",IF(AND(L6=\"Yes\",L12=\"Yes\"),\"Proceed with LPD  sections\",IF(AND(L10=\"No\",L12=\"Yes\"),\"Project does not qualify, do not proceed\",IF(AND(L12=\"No\",L10=\"No\"),\"Project does not qualify, do not proceed\",IF(AND(L12=\"No\"),\"\",IF(L12=\"Select Yes or No\",\"\"))))))","v":""},{"$nulls":9},"Measure Cost",{"$f":"Y88","v":0},"=1.30 * sq. ft or Tech Review override (manual entry)","Measure Cost",{"$f":"0.57*SUM(C33:C57)*'Fixture List Individual Files'!M1067","v":0},"=Measure cost for just NLC based on NLC area factor"]
[null,"Complete all fields below along with corresponding tabs. The incentive will be populated once all required information has been provided.",{"$nulls":22},"Provide\nAS BUILT:","Possible ways to provide it:"]
[null,"Customer:",{"$nulls":11},"kW Savings (Peak)",{"$f":"S88","v":{"v":0,"d":"0.0000"}},"net savings all areas","kW Savings (Peak)",{"$f":"'Fixture List Individual Files'!M1065","v":{"v":0,"d":"0.0000"}},"net savings all areas",{"$nulls":5},"Sq Ft","COMcheck","Layout","Schedule","Submittal","Email","QPL snip"]
[null,"Trade Ally/Installer:",{"$nulls":11},"kWh Savings (1st Yr)",{"$f":"W88","v":0},"net savings all areas","kWh Savings (1st Yr)",{"$f":"'Fixture List Individual Files'!N1065","v":0},"net savings all areas",{"$nulls":5},"Wattage ","COMcheck","Layout","Schedule","Submittal","Email","QPL snip"]
[null,"Best Contact for LPD Questions:",{"$nulls":4},"Email:",null,null,"Phone:",{"$nulls":3},"kWh Savings (Lifecycle)",{"$f":"X88","v":0},"net savings all areas","kWh Savings (Lifecycle)",{"$f":"'Fixture List Individual Files'!O1065","v":0},"net savings all areas",{"$nulls":5},"Fixture list","COMcheck","Layout","Schedule","Submittal","Email","QPL snip"]
[null,"Project Description:",{"$nulls":22},"Pro Sign-off","COMcheck","Layout","Schedule","Submittal","Email","QPL snip"]
[null,"Project Completion Date:",{"$nulls":11},"Total Incentive",{"$f":"L58","v":0},"net incentive all areas","Total Incentive",{"$f":"'Fixture List Individual Files'!P1065","v":0},"net incentive all areas",{"$nulls":5},"Invoice","COMcheck","Layout","Schedule","Submittal","Email","QPL snip"]
[null,"Project Notes:",{"$nulls":23},"COMcheck","Layout","Schedule","Submittal","Email","QPL snip"]
[]
[{"$nulls":3},"I'm providing the required info via:  ","Choose from Drop-down",null,"Facility type: ","Choose from Drop-down",null,"Facility's Hours of Use (HOU)\nHours of use are used in LPD calculation. \nEnter Default Hours value from list below, \nor facility's actual hours. ",{"$nulls":3},"CESA Check-list:",{"$nulls":4},"Completed by:","Notes:"]
[{"$nulls":9},"Default Facility Type",null,"HOU","CF","If other than Default HOU, note source"]
[{"$nulls":3},"Project Size:","Small (5 rows)",null,"Describe Hours of Use: ",null,null,"Commercial",null,{"v":3730,"d":"3,730"},0.77,"COMcheck is 2015 IECC"]
[null,null,{"$f":"IF(E22=\"Individual Files\",\"Corresponding Tabs:\",IF(E22=\"COMcheck\",\"Corresponding Tabs:\",\"\"))","v":""},{"$nulls":3},"Ex.: Store M-F 9am-6pm, Office M-F 7am-5pm, Warehouse M-F 5am-9pm",null,null,"Industrial",null,{"v":4745,"d":"4,745"},0.77,"Signed off by a Credentialed Professional  (COMcheck, Floorplan and/or Lighting Layout) -or- QPLs provided for ALL fixtures installed"]
[null,null,{"$f":"IF(E22=\"Individual Files\",\"Sq. Ft. Area, Fixt List, Wattage & Invoices\",IF(E22=\"COMcheck\",\"As-Built COMcheck & Invoices\",\"\"))","v":""},{"$nulls":6},"Agricultural",null,{"v":4698,"d":"4,698"},0.67]
[{"$nulls":9},"Schools & Government",null,{"v":3239,"d":"3,239"},0.64,"Confirm/Call-out/Note Source of Square Footage"]
[{"$nulls":9},"Enter Hours of Use in Column (B) below",{"$nulls":3},"Spot check top 3 qty of fixtures to ensure quantity alignment. \n\"COMcheck v. Invoice / Fixt List v. Invoice\""]
[]
[{"$nulls":13},"Spot check top 3 'total wattage of fixtures' (Col. E) to ensure Wattage alignment. \"COMcheck v. Specs / Fixt List v. Specs\""]
[null,null,"LPD Measure Summary"]
[null,null,"(A)\nSquare Footage","(B)\nAnnual\nHours of Use","(C)\nBaseline\nWatts/Ft2",null,"(D)\nNew System \nInstalled Wattage","(E)\nNew System \nInstalled Watts/Ft2\n(D/A)","(F)\nWatts/Ft2\nReduced\n(C - E)","(G)\nKWh\nReduced\n([AxBxF]/\n1,000)","(H)\nIncentive Rate\n(kWh/Ft2 Reduced)","(I)\nRequested Incentive\n(G x H)",null,"Confirm no Instant Retailer invoices/receipts"]
[null,{"$f":"IF(C34>1,\"Area 1\",IF(C34,\"\",\"\"))","v":""},{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D9,IF($E$22=\"Individual Files\",'Sq. Ft. Area Individual Files'!C11,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D10,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E11,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D12,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E50,0))","v":0},{"$f":"IFERROR(ROUND(G33/C33,2),\"\")","v":""},{"$f":"IFERROR(ROUND(E33-H33,2),\"-\")","v":"-"},{"$f":"IFERROR(ROUND(C33*D33*I33/1000,0),\"\")","v":""},{"v":0.04,"d":"$0.04"},{"$f":"IFERROR(J33*K33,\"\")","v":""},null,"If assumed higher qty installed (due to discrepency) it's been noted"]
[null,{"$f":"IF(C34>1,\"Area 2\",IF(C34,\"\",\"\"))","v":""},{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D16,IF($E$22=\"Individual Files\",'Sq. Ft. Area Individual Files'!C15,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D17,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E53,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D19,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E92,0))","v":0},{"$f":"IFERROR(ROUND(G34/C34,2),\"\")","v":""},{"$f":"IFERROR(ROUND(E34-H34,2),\"-\")","v":"-"},{"$f":"IFERROR(ROUND(C34*D34*I34/1000,0),\"\")","v":""},{"v":0.04,"d":"$0.04"},{"$f":"IFERROR(J34*K34,\"\")","v":""},null,"If possible, sum measure cost and note \"actual measure cost\""]
[null,{"$f":"IF(C35>1,\"Area 3\",IF(C35,\"\",\"\"))","v":""},{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D21,IF($E$22=\"Individual Files\",'Sq. Ft. Area Individual Files'!C19,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D22,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E95,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D24,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E134,0))","v":0},"",{"$f":"IFERROR(ROUND(E35-H35,2),\"-\")","v":"-"},"",{"v":0.04,"d":"$0.04"},""]
[null,{"$f":"IF(C36>1,\"Area 4\",IF(C36,\"\",\"\"))","v":""},{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D26,IF($E$22=\"Individual Files\",'Sq. Ft. Area Individual Files'!C23,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D27,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E137,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D29,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E176,0))","v":0},"","-","",{"v":0.04,"d":"$0.04"},""]
[null,null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D13,IF($E$22=\"Individual Files\",'Sq. Ft. Area Individual Files'!C27,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D32,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E179,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D34,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E218,0))","v":0},"","-","",{"v":0.04,"d":"$0.04"},""]
[null,null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D20,IF($E$22=\"Individual Files\",'Sq. Ft. Area Individual Files'!C31,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D37,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E221,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D39,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E260,0))","v":0},{"$f":"IFERROR(ROUND(G38/C38,2),\"\")","v":""},"-",{"$f":"IFERROR(ROUND(C38*D38*I38/1000,0),\"\")","v":""},{"v":0.04,"d":"$0.04"},{"$f":"IFERROR(J38*K38,\"\")","v":""}]
[null,null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D25,IF($E$22=\"Individual Files\",'Sq. Ft. Area Individual Files'!C35,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D42,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E263,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D44,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E302,0))","v":0},"",{"$f":"IFERROR(ROUND(E39-H39,2),\"-\")","v":"-"},"",{"v":0.04,"d":"$0.04"},""]
[null,null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D30,IF($E$22=\"Individual Files\",'Sq. Ft. Area Individual Files'!C39,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D47,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E305,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D49,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E344,0))","v":0},"","-","",{"v":0.04,"d":"$0.04"},""]
[null,null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D17,IF($E$22=\"Individual Files\",'Sq. Ft. Area Individual Files'!C43,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D52,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E347,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D54,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E386,0))","v":0},"","-","",{"v":0.04,"d":"$0.04"},""]
[null,null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D24,IF($E$22=\"Individual Files\",'Sq. Ft. Area Individual Files'!C47,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D57,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E389,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D59,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E428,0))","v":0},"","-","",{"v":0.04,"d":"$0.04"},""]
[null,null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D29,IF($E$22=\"Individual Files\",'Sq. Ft. Area Individual Files'!C51,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D62,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E431,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D64,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E470,0))","v":0},"","-","",{"v":0.04,"d":"$0.04"},""]
[null,null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D34,IF($E$22=\"Individual Files\",'Sq. Ft. Area Individual Files'!C55,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D67,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E473,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D69,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E512,0))","v":0},"","-","",{"v":0.04,"d":"$0.04"},""]
[null,null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D21,IF($E$22=\"Individual Files\",'Sq. Ft. Area Individual Files'!C59,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D72,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E515,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D74,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E554,0))","v":0},"","-","",{"v":0.04,"d":"$0.04"},""]
[null,null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D28,IF($E$22=\"Individual Files\",'Sq. Ft. Area Individual Files'!C63,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D77,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E557,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D79,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E596,0))","v":0},"","-","",{"v":0.04,"d":"$0.04"},""]
[null,null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D33,IF($E$22=\"Individual Files\",'Sq. Ft. Area Individual Files'!C67,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D82,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E599,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D84,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E638,0))","v":0},"","-","",{"v":0.04,"d":"$0.04"},""]
[null,null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D138,IF($E$22=\"Individual Files\",'Sq. Ft. Area Individual Files'!C71,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D87,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E641,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D89,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E680,0))","v":0},"","-","",{"v":0.04,"d":"$0.04"},""]
[null,null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D25,IF($E$22=\"Individual Files\",'Sq. Ft. Area Individual Files'!C75,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D92,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E683,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D94,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E722,0))","v":0},"","-","",{"v":0.04,"d":"$0.04"},""]
[null,null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D32,IF($E$22=\"Individual Files\",'Sq. Ft. Area Individual Files'!C79,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D97,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E725,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D99,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E764,0))","v":0},"","-","",{"v":0.04,"d":"$0.04"},""]
[null,null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D137,IF($E$22=\"Individual Files\",'Sq. Ft. Area Individual Files'!C83,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D102,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E767,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D104,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E806,0))","v":0},"","-","",{"v":0.04,"d":"$0.04"},""]
[null,null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D142,IF($E$22=\"Individual Files\",'Sq. Ft. Area Individual Files'!C87,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D107,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E809,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D109,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E848,0))","v":0},"","-","",{"v":0.04,"d":"$0.04"},""]
[null,null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D29,IF($E$22=\"Individual Files\",'Sq. Ft. Area Individual Files'!C91,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D112,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E851,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D114,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E890,0))","v":0},"","-","",{"v":0.04,"d":"$0.04"},""]
[null,null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D136,IF($E$22=\"Individual Files\",'Sq. Ft. Area Individual Files'!C95,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D117,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E893,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D119,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E932,0))","v":0},"","-","",{"v":0.04,"d":"$0.04"},""]
[null,null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D141,IF($E$22=\"Individual Files\",'Sq. Ft. Area Individual Files'!C99,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D122,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E935,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D124,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E974,0))","v":0},"","-","",{"v":0.04,"d":"$0.04"},""]
[null,null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D146,IF($E$22=\"Individual Files\",'Sq. Ft. Area Individual Files'!C103,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D127,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E977,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D129,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E1016,0))","v":0},"","-","",{"v":0.04,"d":"$0.04"},""]
[null,{"$f":"IF(C57>1,\"Area 5\",IF(C57,\"\",\"\"))","v":""},{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D31,IF($E$22=\"Individual Files\",'Sq. Ft. Area Individual Files'!C107,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D132,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E1019,0))","v":0},null,{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D134,IF($E$22=\"Individual Files\",'Fixture List Individual Files'!E1058,0))","v":0},"","-","",{"v":0.04,"d":"$0.04"},""]
[{"$nulls":11},{"$f":"SUBTOTAL(9,(L33:L57))","v":0},null,"CF",0]
[{"$nulls":11},{"$f":"IF(L58>24999.99,\"Post Inspection Required. Focus on Energy will contact to schedule.\",IF(L58<25000,\"\"))","v":""},null,"CF Override"]
[null,"Important \nNotes: ","The above calculation is an estimated incentive and is subject to review.  If discrepancies are discovered, Focus on Energy reserves the right to adjust the incentive.",{"$nulls":11},{"$f":"IF(ISBLANK(O59)=TRUE,O58,O59)","v":0}]
[null,null,"The Incentive application and LPD workbook must be submitted within 60 days of project completion.  Both are required for incentive processing.",{"$nulls":10},"Analysis"]
[null,null,"Project Completion is considered occupancy date or final equipment installation date, whichever occurs later.",{"$nulls":11},"LPD Code\n(W/ft2)","HOU","sq ft","Allowed Watts","Peak kW\nSavings","Installed System Wattage","LPD Design W/ft^2","W/ft^2 Reduced","kWh Reduced","Lifecycle\nkWh Savings","Measure Cost - $1.30*sq. ft. or actual "]
[null,null,"Contact Focus on Energy at business@focusonenergy.com or 800.762.7077.",{"$nulls":10},"Area 1",{"$f":"E33","v":{"v":0,"d":"0.00"}},{"$f":"D33","v":0},{"$f":"C33","v":0},{"$f":"IFERROR(ROUND(O63*Q63,0),\"\")","v":0},{"$f":"IFERROR(IF(OR(O63=\"\",O63=\"Error\",G33=\"\"),\"\",ROUND(V63*C33/1000*$O$60,4)),\"\")","v":{"v":0,"d":"0.0000"}},{"$f":"G33","v":0},{"$f":"IFERROR(ROUND(T63/Q63,2),0)","v":0},{"$f":"IFERROR(ROUND(O63-U63,2),\"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(ROUND(P63*Q63*V63/1000,0),\"\")","v":0},{"$f":"IFERROR(W63*$AE$107,\"\")","v":0},{"$f":"ROUND(Q63*1.3,2)","v":0},null,null,"Sector","$/kWh","$/therm"]
[null,null,"Link to Focus on Energy Catalogs",{"$nulls":10},"Area 2",{"$f":"E34","v":{"v":0,"d":"0.00"}},{"$f":"D34","v":0},{"$f":"C34","v":0},{"$f":"IFERROR(ROUND(O64*Q64,0),\"\")","v":0},{"$f":"IFERROR(IF(OR(O64=\"\",O64=\"Error\",G34=\"\"),\"\",ROUND(V64*C34/1000*$O$60,4)),\"\")","v":{"v":0,"d":"0.0000"}},{"$f":"G34","v":0},{"$f":"IFERROR(ROUND(T64/Q64,2),0)","v":0},{"$f":"IFERROR(ROUND(O64-U64,2),\"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(ROUND(P64*Q64*V64/1000,0),\"\")","v":0},{"$f":"IFERROR(W64*$AE$107,\"\")","v":0},{"$f":"ROUND(Q64*1.3,2)","v":0},null,null,"Commercial",{"v":0.1102,"d":"$0.1102"},{"v":0.616,"d":"$0.6160"}]
[{"$nulls":10},"Last Revised:",{"$f":"MAX(RevisionHistory!B5:B41)","v":"2022-02-17"},null,"Area 3",{"$f":"E35","v":{"v":0,"d":"0.00"}},{"$f":"D35","v":0},{"$f":"C35","v":0},0,{"$f":"IFERROR(IF(OR(O65=\"\",O65=\"Error\",G35=\"\"),\"\",ROUND(V65*C35/1000*$O$60,4)),\"\")","v":{"v":0,"d":"0.0000"}},{"$f":"G35","v":0},{"$f":"IFERROR(ROUND(T65/Q65,2),0)","v":0},{"$f":"IFERROR(ROUND(O65-U65,2),\"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(ROUND(P65*Q65*V65/1000,0),\"\")","v":0},{"$f":"IFERROR(W65*$AE$107,\"\")","v":0},{"$f":"ROUND(Q65*1.3,2)","v":0},null,null,"Industrial",{"v":0.0772,"d":"$0.0772"},{"v":0.516,"d":"$0.5160"}]
[{"$nulls":13},"Area 4",{"$f":"E36","v":{"v":0,"d":"0.00"}},{"$f":"D36","v":0},{"$f":"C36","v":0},0,{"$f":"IFERROR(IF(OR(O66=\"\",O66=\"Error\",G36=\"\"),\"\",ROUND(V66*C36/1000*$O$60,4)),\"\")","v":{"v":0,"d":"0.0000"}},{"$f":"G36","v":0},{"$f":"IFERROR(ROUND(T66/Q66,2),0)","v":0},{"$f":"IFERROR(ROUND(O66-U66,2),\"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(ROUND(P66*Q66*V66/1000,0),\"\")","v":0},{"$f":"IFERROR(W66*$AE$107,\"\")","v":0},{"$f":"ROUND(Q66*1.3,2)","v":0},null,null,"Residential",{"v":0.1462,"d":"$0.1462"},{"v":0.769,"d":"$0.7690"}]
[{"$nulls":13},"Area 5",{"$f":"E37","v":{"v":0,"d":"0.00"}},{"$f":"D37","v":0},{"$f":"C37","v":0},0,{"$f":"IFERROR(IF(OR(O67=\"\",O67=\"Error\",G37=\"\"),\"\",ROUND(V67*C37/1000*$O$60,4)),\"\")","v":{"v":0,"d":"0.0000"}},{"$f":"G37","v":0},{"$f":"IFERROR(ROUND(T67/Q67,2),0)","v":0},{"$f":"IFERROR(ROUND(O67-U67,2),\"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(ROUND(P67*Q67*V67/1000,0),\"\")","v":0},{"$f":"IFERROR(W67*$AE$107,\"\")","v":0},{"$f":"ROUND(Q67*1.3,2)","v":0}]
[{"$nulls":13},"Area 6",{"v":0,"d":"0.00"},0,0,0,{"v":0,"d":"0.0000"},0,0,{"v":0,"d":"0.00"},0,0,0]
[{"$nulls":13},"Area 7",{"v":0,"d":"0.00"},0,0,0,{"v":0,"d":"0.0000"},0,0,{"v":0,"d":"0.00"},0,0,0]
[{"$nulls":13},"Area 8",{"v":0,"d":"0.00"},0,0,0,{"v":0,"d":"0.0000"},0,0,{"v":0,"d":"0.00"},0,0,0]
[{"$nulls":13},"Area 9",{"v":0,"d":"0.00"},0,0,0,{"v":0,"d":"0.0000"},0,0,{"v":0,"d":"0.00"},0,0,0]
[{"$nulls":13},"Area 10",{"v":0,"d":"0.00"},0,0,0,{"v":0,"d":"0.0000"},0,0,{"v":0,"d":"0.00"},0,0,0]
[{"$nulls":13},"Area 11",{"v":0,"d":"0.00"},0,0,0,{"v":0,"d":"0.0000"},0,0,{"v":0,"d":"0.00"},0,0,0]
[{"$nulls":13},"Area 12",{"v":0,"d":"0.00"},0,0,0,{"v":0,"d":"0.0000"},0,0,{"v":0,"d":"0.00"},0,0,0]
[{"$nulls":13},"Area 13",{"v":0,"d":"0.00"},0,0,0,{"v":0,"d":"0.0000"},0,0,{"v":0,"d":"0.00"},0,0,0]
[{"$nulls":13},"Area 14",{"v":0,"d":"0.00"},0,0,0,{"v":0,"d":"0.0000"},0,0,{"v":0,"d":"0.00"},0,0,0]
[{"$nulls":13},"Area 15",{"v":0,"d":"0.00"},0,0,0,{"v":0,"d":"0.0000"},0,0,{"v":0,"d":"0.00"},0,0,0]
[{"$nulls":13},"Area 16",{"v":0,"d":"0.00"},0,0,0,{"v":0,"d":"0.0000"},0,0,{"v":0,"d":"0.00"},0,0,0]
[{"$nulls":13},"Area 17",{"v":0,"d":"0.00"},0,0,0,{"v":0,"d":"0.0000"},0,0,{"v":0,"d":"0.00"},0,0,0]
[{"$nulls":13},"Area 18",{"v":0,"d":"0.00"},0,0,0,{"v":0,"d":"0.0000"},0,0,{"v":0,"d":"0.00"},0,0,0]
[{"$nulls":13},"Area 19",{"v":0,"d":"0.00"},0,0,0,{"v":0,"d":"0.0000"},0,0,{"v":0,"d":"0.00"},0,0,0]
[{"$nulls":13},"Area 20",{"v":0,"d":"0.00"},0,0,0,{"v":0,"d":"0.0000"},0,0,{"v":0,"d":"0.00"},0,0,0]
[{"$nulls":13},"Area 21",{"v":0,"d":"0.00"},0,0,0,{"v":0,"d":"0.0000"},0,0,{"v":0,"d":"0.00"},0,0,0]
[{"$nulls":13},"Area 22",{"v":0,"d":"0.00"},0,0,0,{"v":0,"d":"0.0000"},0,0,{"v":0,"d":"0.00"},0,0,0]
[{"$nulls":13},"Area 23",{"v":0,"d":"0.00"},0,0,0,{"v":0,"d":"0.0000"},0,0,{"v":0,"d":"0.00"},0,0,0]
[{"$nulls":13},"Area 24",{"v":0,"d":"0.00"},0,0,0,{"v":0,"d":"0.0000"},0,0,{"v":0,"d":"0.00"},0,0,0]
[{"$nulls":13},"Area 25",{"v":0,"d":"0.00"},0,0,0,{"v":0,"d":"0.0000"},0,0,{"v":0,"d":"0.00"},0,0,0]
[{"$nulls":16},"Total Project",{"$f":"SUBTOTAL(9,(R63:R87))","v":0},{"v":0,"d":"0.0000"},0,{"v":0,"d":"0.00000"},{"v":0,"d":"0.00"},0,0,0,null,null,"EIA 2019 Annual Rates"]
[]
[]
[]
[]
[]
[{"$nulls":27},"EUL Source:","2019 Wisconsin TRM (Released January 2019)"]
[{"$nulls":27},"Measure Master ID","Measure Master Name","Measure Type",null,"Category","Group","Final Approved EUL","Source"]
[{"$nulls":27},4336,"LPD ≥20% below code requirements","Hybrid",null,"Light Emitting Diode (LED)","Lighting",15,"Efficiency Vermont TRM March 16, 2015"]
[{"$nulls":27},4337,"LPD ≥30% below code requirements","Hybrid",null,"Light Emitting Diode (LED)","Lighting",15,"Efficiency Vermont TRM March 16, 2015"]
[{"$nulls":27},4338,"LPD ≥40% below code requirements","Hybrid",null,"Light Emitting Diode (LED)","Lighting",15,"Efficiency Vermont TRM March 16, 2015"]
[]
[]
[{"$nulls":28},"Incentive Rate ($/ft2)"]
[{"$nulls":28},0.04]
[{"$nulls":28},0.04]
[{"$nulls":27},"Agriculture",4698,0.67]
[]
[{"$nulls":27},"Sector","HOU","CF","EUL","HOU This Project"]
[{"$nulls":27},"Commercial",3730,0.77,{"$f":"AVERAGE(AH96:AH98)","v":15},{"$f":"C93","v":0}]
[{"$nulls":27},"Industrial",4745,0.77]
[{"$nulls":27},"Agriculture",4698,0.67]
[{"$nulls":27},"Schools & Gov",3239,0.64]
[{"$nulls":27},"Multifamily - Common Area",5950,0.77]
[{"$nulls":27},"Multifamily - In Unit",840,0.055]
[]
[{"$nulls":27},"Default Utility Rates"]

{"sheet":" Requirements COMcheck","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}

{"sheet":"As-Built COMcheck","index":2,"n_rows":176,"n_cols":25,"rows_kept":176,"hidden":true,"merged":[[0,0,5,10],[0,12,0,21],[5,12,7,23],[8,12,9,23],[10,12,11,23],[11,4,12,9],[13,12,17,23],[25,24,25,25],[27,24,27,25],[135,13,136,19],[137,0,171,10]]}
["For data provided via COMcheck report\n - Provide the As-Built COMcheck report signed by a credentialed lighting professional\n       See Requirements tab for list of accepted credentials\n       If the COMcheck is not signed, go to Start Here tab and choose \"Individual Files\" from drop-down\n - If COMcheck lists more than 5 Area Types, contact Focus on Energy for assistance (business@focusonenergy.com)\n - See Helpful Tips tab for directions on inserting files",{"$nulls":11},"Important Reminders for COMcheck Reports"]
[{"$nulls":12},"Must use Energy Code \"2015 IECC\""]
[]
[]
[]
[{"$nulls":12},"Must report As-Built conditions\nIf the installed scope of work differs from the initial COMcheck report, a revised COMcheck is required.  If discrepancies are found in review (ex.: COMcheck report, invoicing, in-person inspection), assumptions of higher value installed will be made."]
[]
[]
["Area 1:",null,"Total Sq. Ft:",null,"Found on COMcheck as \"Floor Area (ft2)\"",{"$nulls":7},"Signature is required\nSignature on COMcheck report must include the lighting professional's credentials "]
[null,null,"Allowed Watts/ft2:",null,"Found on COMcheck as \"Allowed Watts / ft2\""]
[null,null,"Total Allowed Watts:",{"$f":"IFERROR(ROUND(D9*D10,0),\"\")","v":0},"This will calculate"]
[null,null,"New System Installed Watts:",null,"For Single Area Facility find on COMcheck as Total Proposed\nWatts - For multi-area add all wattage installed in Area 1 "]
[]
["Lines 15-33 used if multiple area types are listed on COMcheck, as indicated under \"Area Category\"",{"$nulls":11},"For Projects with Multiple Area Types listed on COMcheck\n1. Follow example showing how to enter values\n2. If COMcheck lists more than 5 Area Types, contact Focus on Energy for assistance (business@focusonenergy.com)"]
[]
["Area 2:",null,"Total Sq. Ft:",null,"Found on COMcheck as \"Floor Area (ft2)\" "]
[null,null,"Allowed Watts/ft2:",null,"Found on COMcheck as \"Allowed Watts / ft2\""]
[null,null,"Total Allowed Watts:",{"$f":"IFERROR(ROUND(D16*D17,0),\"\")","v":0},"This will calculate"]
[null,null,"New System Installed Watts:",null,"On COMcheck add all wattage installed in Area 2",{"$nulls":8},"Example: "]
[]
["Area 3:",null,"Total Sq. Ft:",null,"Found on COMcheck as \"Floor Area (ft2)\". "]
[null,null,"Allowed Watts/ft2:",null,"Found on COMcheck as \"Allowed Watts / ft2\""]
[null,null,"Total Allowed Watts:",{"$f":"IFERROR(ROUND(D21*D22,0),\"\")","v":0},"This will calculate"]
[null,null,"New System Installed Watts:",null,"On COMcheck add all wattage installed in Area 3"]
[]
["Area 4:",null,"Total Sq. Ft:",null,"Found on COMcheck as \"Floor Area (ft2)\". ",{"$nulls":19},"Sum: 18,654 + 584 = 19,148"]
[null,null,"Allowed Watts/ft2:",null,"Found on COMcheck as \"Allowed Watts / ft2\""]
[null,null,"Total Allowed Watts:",{"$f":"IFERROR(ROUND(D26*D27,0),\"\")","v":0},"This will calculate",{"$nulls":19},"Sum: 6,194 + 60 = 6,254"]
[null,null,"New System Installed Watts:",null,"On COMcheck add all wattage installed in Area 4"]
[]
["Area 5:",null,"Total Sq. Ft:",null,"Found on COMcheck as \"Floor Area (ft2)\". "]
[null,null,"Allowed Watts/ft2:",null,"Found on COMcheck as \"Allowed Watts / ft2\""]
[null,null,"Total Allowed Watts:",{"$f":"IFERROR(ROUND(D31*D32,0),\"\")","v":0},"This will calculate"]
[null,null,"New System Installed Watts:",null,"On COMcheck add all wattage installed in Area 5"]
[]
["Area 6:",null,"Total Sq. Ft:",null,"Found on COMcheck as \"Floor Area (ft2)\". "]
[null,null,"Allowed Watts/ft2:",null,"Found on COMcheck as \"Allowed Watts / ft2\""]
[null,null,"Total Allowed Watts:",{"$f":"IFERROR(ROUND(D36*D37,0),\"\")","v":0},"This will calculate"]
[null,null,"New System Installed Watts:",null,"On COMcheck add all wattage installed in Area 5"]
[]
["Area 7:",null,"Total Sq. Ft:",null,"Found on COMcheck as \"Floor Area (ft2)\". "]
[null,null,"Allowed Watts/ft2:",null,"Found on COMcheck as \"Allowed Watts / ft2\""]
[null,null,"Total Allowed Watts:",{"$f":"IFERROR(ROUND(D41*D42,0),\"\")","v":0},"This will calculate"]
[null,null,"New System Installed Watts:",null,"On COMcheck add all wattage installed in Area 5"]
[]
["Area 8:",null,"Total Sq. Ft:",null,"Found on COMcheck as \"Floor Area (ft2)\". "]
[null,null,"Allowed Watts/ft2:",null,"Found on COMcheck as \"Allowed Watts / ft2\""]
[null,null,"Total Allowed Watts:",{"$f":"IFERROR(ROUND(D46*D47,0),\"\")","v":0},"This will calculate"]
[null,null,"New System Installed Watts:",null,"On COMcheck add all wattage installed in Area 5"]
[]
["Area 9:",null,"Total Sq. Ft:",null,"Found on COMcheck as \"Floor Area (ft2)\". "]
[null,null,"Allowed Watts/ft2:",null,"Found on COMcheck as \"Allowed Watts / ft2\""]
[null,null,"Total Allowed Watts:",{"$f":"IFERROR(ROUND(D51*D52,0),\"\")","v":0},"This will calculate"]
[null,null,"New System Installed Watts:",null,"On COMcheck add all wattage installed in Area 5"]
[]
["Area 10:",null,"Total Sq. Ft:",null,"Found on COMcheck as \"Floor Area (ft2)\". "]
[null,null,"Allowed Watts/ft2:",null,"Found on COMcheck as \"Allowed Watts / ft2\""]
[null,null,"Total Allowed Watts:",{"$f":"IFERROR(ROUND(D56*D57,0),\"\")","v":0},"This will calculate"]
[null,null,"New System Installed Watts:",null,"On COMcheck add all wattage installed in Area 5"]
[]
["Area 11:",null,"Total Sq. Ft:",null,"Found on COMcheck as \"Floor Area (ft2)\". "]
[null,null,"Allowed Watts/ft2:",null,"Found on COMcheck as \"Allowed Watts / ft2\""]
[null,null,"Total Allowed Watts:",{"$f":"IFERROR(ROUND(D61*D62,0),\"\")","v":0},"This will calculate"]
[null,null,"New System Installed Watts:",null,"On COMcheck add all wattage installed in Area 5"]
[]
["Area 12:",null,"Total Sq. Ft:",null,"Found on COMcheck as \"Floor Area (ft2)\". "]
[null,null,"Allowed Watts/ft2:",null,"Found on COMcheck as \"Allowed Watts / ft2\""]
[null,null,"Total Allowed Watts:",{"$f":"IFERROR(ROUND(D66*D67,0),\"\")","v":0},"This will calculate"]
[null,null,"New System Installed Watts:",null,"On COMcheck add all wattage installed in Area 5"]
[]
["Area 13:",null,"Total Sq. Ft:",null,"Found on COMcheck as \"Floor Area (ft2)\". "]
[null,null,"Allowed Watts/ft2:",null,"Found on COMcheck as \"Allowed Watts / ft2\""]
[null,null,"Total Allowed Watts:",{"$f":"IFERROR(ROUND(D71*D72,0),\"\")","v":0},"This will calculate"]
[null,null,"New System Installed Watts:",null,"On COMcheck add all wattage installed in Area 5"]
[]
["Area 14:",null,"Total Sq. Ft:",null,"Found on COMcheck as \"Floor Area (ft2)\". "]
[null,null,"Allowed Watts/ft2:",null,"Found on COMcheck as \"Allowed Watts / ft2\""]
[null,null,"Total Allowed Watts:",{"$f":"IFERROR(ROUND(D76*D77,0),\"\")","v":0},"This will calculate"]
[null,null,"New System Installed Watts:",null,"On COMcheck add all wattage installed in Area 5"]
[]
["Area 15:",null,"Total Sq. Ft:",null,"Found on COMcheck as \"Floor Area (ft2)\". "]
[null,null,"Allowed Watts/ft2:",null,"Found on COMcheck as \"Allowed Watts / ft2\""]
[null,null,"Total Allowed Watts:",{"$f":"IFERROR(ROUND(D81*D82,0),\"\")","v":0},"This will calculate"]
[null,null,"New System Installed Watts:",null,"On COMcheck add all wattage installed in Area 5"]
[]
["Area 16:",null,"Total Sq. Ft:",null,"Found on COMcheck as \"Floor Area (ft2)\". "]
[null,null,"Allowed Watts/ft2:",null,"Found on COMcheck as \"Allowed Watts / ft2\""]
[null,null,"Total Allowed Watts:",{"$f":"IFERROR(ROUND(D86*D87,0),\"\")","v":0},"This will calculate"]
[null,null,"New System Installed Watts:",null,"On COMcheck add all wattage installed in Area 5"]
[]
["Area 17:",null,"Total Sq. Ft:",null,"Found on COMcheck as \"Floor Area (ft2)\". "]
[null,null,"Allowed Watts/ft2:",null,"Found on COMcheck as \"Allowed Watts / ft2\""]
[null,null,"Total Allowed Watts:",{"$f":"IFERROR(ROUND(D91*D92,0),\"\")","v":0},"This will calculate"]
[null,null,"New System Installed Watts:",null,"On COMcheck add all wattage installed in Area 5"]
[]
["Area 18:",null,"Total Sq. Ft:",null,"Found on COMcheck as \"Floor Area (ft2)\". "]
[null,null,"Allowed Watts/ft2:",null,"Found on COMcheck as \"Allowed Watts / ft2\""]
[null,null,"Total Allowed Watts:",{"$f":"IFERROR(ROUND(D96*D97,0),\"\")","v":0},"This will calculate"]
[null,null,"New System Installed Watts:",null,"On COMcheck add all wattage installed in Area 5"]
[]
["Area 19:",null,"Total Sq. Ft:",null,"Found on COMcheck as \"Floor Area (ft2)\". "]
[null,null,"Allowed Watts/ft2:",null,"Found on COMcheck as \"Allowed Watts / ft2\""]
[null,null,"Total Allowed Watts:",{"$f":"IFERROR(ROUND(D101*D102,0),\"\")","v":0},"This will calculate"]
[null,null,"New System Installed Watts:",null,"On COMcheck add all wattage installed in Area 5"]
[]
["Area 20:",null,"Total Sq. Ft:",null,"Found on COMcheck as \"Floor Area (ft2)\". "]
[null,null,"Allowed Watts/ft2:",null,"Found on COMcheck as \"Allowed Watts / ft2\""]
[null,null,"Total Allowed Watts:",{"$f":"IFERROR(ROUND(D106*D107,0),\"\")","v":0},"This will calculate"]
[null,null,"New System Installed Watts:",null,"On COMcheck add all wattage installed in Area 5"]
[]
["Area 21:",null,"Total Sq. Ft:",null,"Found on COMcheck as \"Floor Area (ft2)\". "]
[null,null,"Allowed Watts/ft2:",null,"Found on COMcheck as \"Allowed Watts / ft2\""]
[null,null,"Total Allowed Watts:",{"$f":"IFERROR(ROUND(D111*D112,0),\"\")","v":0},"This will calculate"]
[null,null,"New System Installed Watts:",null,"On COMcheck add all wattage installed in Area 5"]
[]
["Area 22:",null,"Total Sq. Ft:",null,"Found on COMcheck as \"Floor Area (ft2)\". "]
[null,null,"Allowed Watts/ft2:",null,"Found on COMcheck as \"Allowed Watts / ft2\""]
[null,null,"Total Allowed Watts:",{"$f":"IFERROR(ROUND(D116*D117,0),\"\")","v":0},"This will calculate"]
[null,null,"New System Installed Watts:",null,"On COMcheck add all wattage installed in Area 5"]
[]
["Area 23:",null,"Total Sq. Ft:",null,"Found on COMcheck as \"Floor Area (ft2)\". "]
[null,null,"Allowed Watts/ft2:",null,"Found on COMcheck as \"Allowed Watts / ft2\""]
[null,null,"Total Allowed Watts:",{"$f":"IFERROR(ROUND(D121*D122,0),\"\")","v":0},"This will calculate"]
[null,null,"New System Installed Watts:",null,"On COMcheck add all wattage installed in Area 5"]
[]
["Area 24:",null,"Total Sq. Ft:",null,"Found on COMcheck as \"Floor Area (ft2)\". "]
[null,null,"Allowed Watts/ft2:",null,"Found on COMcheck as \"Allowed Watts / ft2\""]
[null,null,"Total Allowed Watts:",{"$f":"IFERROR(ROUND(D126*D127,0),\"\")","v":0},"This will calculate"]
[null,null,"New System Installed Watts:",null,"On COMcheck add all wattage installed in Area 5"]
[]
["Area 25:",null,"Total Sq. Ft:",null,"Found on COMcheck as \"Floor Area (ft2)\". "]
[null,null,"Allowed Watts/ft2:",null,"Found on COMcheck as \"Allowed Watts / ft2\""]
[null,null,"Total Allowed Watts:",{"$f":"IFERROR(ROUND(D131*D132,0),\"\")","v":0},"This will calculate"]
[null,null,"New System Installed Watts:",null,"On COMcheck add all wattage installed in Area 5"]
[{"$nulls":12},"2015 IECC Lighting Power Density (LPD) Reference Table:"]
[{"$nulls":13},"LIGHTING POWER DENSITY (AREA METHOD) - 2015 IECC"]
["Insert pdf of As-Built COMcheck here:"]
[{"$nulls":13},"Automotive Facility",{"$nulls":5},0.8]
[{"$nulls":13},"Convention Center",{"$nulls":5},1.01]
[{"$nulls":13},"Court House",{"$nulls":5},1.01]
[{"$nulls":13},"Dining: Bar Lounge/Leisure",{"$nulls":5},1.01]
[{"$nulls":13},"Dining: Cafeteria/Fast Food",{"$nulls":5},0.9]
[{"$nulls":13},"Dining: Family",{"$nulls":5},0.95]
[{"$nulls":13},"Dormitory",{"$nulls":5},0.57]
[{"$nulls":13},"Exercise Center",{"$nulls":5},0.84]
[{"$nulls":13},"Fire Station",{"$nulls":5},0.67]
[{"$nulls":13},"Free Stall",{"$nulls":5},0.5]
[{"$nulls":13},"General Animal Care Area, Utility Room",{"$nulls":5},0.5]
[{"$nulls":13},"Gymnasium",{"$nulls":5},0.94]
[{"$nulls":13},"Healthcare Clinic",{"$nulls":5},0.9]
[{"$nulls":13},"Hospital",{"$nulls":5},1.05]
[{"$nulls":13},"Hotel/Motel",{"$nulls":5},0.87]
[{"$nulls":13},"Library",{"$nulls":5},1.19]
[{"$nulls":13},"Loading and Storage Area, Restroom",{"$nulls":5},0.5]
[{"$nulls":13},"Manual Wash Sink, Treatment or Surgery Area",{"$nulls":5},1.19]
[{"$nulls":13},"Manufacturing Facility",{"$nulls":5},1.17]
[{"$nulls":13},"Motion Picture Theater",{"$nulls":5},0.76]
[{"$nulls":13},"Multifamily",{"$nulls":5},0.51]
[{"$nulls":13},"Museum",{"$nulls":5},1.02]
[{"$nulls":13},"Non-Dairy Livestock Housing, Holding Area, Machine Storage",{"$nulls":5},0.21]
[{"$nulls":13},"Office",{"$nulls":5},0.82]
[{"$nulls":13},"Operator's Pit, Office Area at Desk Top, Farm Shop/Repair Area ",{"$nulls":5},0.82]
[{"$nulls":13},"Parking Garage",{"$nulls":5},0.21]
[{"$nulls":13},"Penitentiary",{"$nulls":5},0.81]
[{"$nulls":13},"Performing Arts Theater",{"$nulls":5},1.39]
[{"$nulls":13},"Police Station",{"$nulls":5},0.87]
[{"$nulls":13},"Post Office",{"$nulls":5},0.87]
[{"$nulls":13},"Religious Building",{"$nulls":5},1]
[{"$nulls":13},"Retail",{"$nulls":5},1.26]
[{"$nulls":13},"School/University",{"$nulls":5},0.87]
[{"$nulls":13},"Sports Arena",{"$nulls":5},0.91]
[{"$nulls":13},"Tie Stall Feeding Alley, Milking Parlor, Milk Room",{"$nulls":5},0.5]
[{"$nulls":13},"Town Hall",{"$nulls":5},0.89]
[{"$nulls":13},"Transportation",{"$nulls":5},0.7]
[{"$nulls":13},"Warehouse",{"$nulls":5},0.66]
[{"$nulls":13},"Workshop",{"$nulls":5},1.19]

{"sheet":"Invoices COMcheck","index":3,"n_rows":10,"n_cols":1,"rows_kept":10,"hidden":true,"merged":[[0,0,6,12],[10,0,44,10]]}
["Invoices to support COMcheck report data\n - Include invoices for all interior fixtures installed (indicate any items on invoice that are not part of the LPD offering)\n - Provide itemized invoices showing quantity and make/model number whenever possible, however a summary type invoice\n    is acceptable when submitted with COMcheck report\n - Include multiple files if appropriate\n - Supply as separate document attachment(s) if file size is prohibitive\n - See Helpful Tips tab for help inserting files"]
{"$rows_empty":8}
["Insert invoice(s) here:"]

{"sheet":" Requirements Individual Files","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}

{"sheet":"Sq. Ft. Area Individual Files","index":5,"n_rows":155,"n_cols":11,"rows_kept":155,"hidden":true,"merged":[[0,0,6,6],[9,6,11,11],[12,6,16,10]]}
["Documentation Showing As-Built Square Footage\n - Building Plans must be signed by credentialed lighting professional \n      See Requirements tab for list of accepted credentials\n - Floorplan layout must include dimensions\n - Include multiple files if appropriate\n - Supply as separate document attachment(s) if file size is prohibitive\n - See Helpful Tips tab for help inserting files"]
{"$rows_empty":7}
["Area 1:"]
[null,null,"Describe Area (ex.: Warehouse, Offices, etc.):",{"$nulls":3},"For Projects with Multiple Area Use Types\n   Ex.: Warehouse (Area 1), Showroom (Area 2) and Offices (Area 3) within same facility\n"]
[null,{"$f":"IF(C15>1,\"Area 1 Sq. Ft.:\",IF(C15,\"\",\"Input Sq. Ft.:\"))","v":"Input Sq. Ft.:"},null,"The value entered will be verified on the floorplan layout"]
[]
["Area 2:",{"$nulls":5},"1. Enter description of each Area\n2. Combine all of facility's common Use Type Areas within one area calculation\n       Example: Office spaces on Floor 1 (956 sq. ft.) + Floor 2 (5,110 sq. ft.) + Floor 3 \n       (554 sq. ft.) = 6,620 sq. ft. for the \"office\" area type \n3. Be sure all area types are clearly marked on building layout pdf "]
[null,null,"Describe Area:"]
[null,"Area 2 Sq. Ft.:",null,"The value entered will be verified on the floorplan layout"]
[]
["Area 3:"]
[null,null,"Describe Area:",{"$nulls":3},"Example:"]
[null,"Area 3 Sq. Ft.:",null,"The value entered will be verified on the floorplan layout",{"$nulls":3},"Area 1:"]
[{"$nulls":8},"Area 1 Sq. Ft.:",{"v":42412,"d":"42,412"},"The value entered will be verified on the pdf layout"]
["Area 4:",{"$nulls":8},"Describe Area (ex.: Warehouse, Offices, etc.):","Manufacturing"]
[null,null,"Describe Area:",{"$nulls":4},"Area 2:"]
[null,"Area 4 Sq. Ft.:",null,"The value entered will be verified on the floorplan layout",{"$nulls":5},"Describe Area:","Offices on Floors 1, 2 & 3"]
[{"$nulls":8},"Area 2 Sq. Ft.:",{"v":6620,"d":"6,620"},"The value entered will be verified on the pdf layout"]
["Area 5:",{"$nulls":6},"Area 3:"]
[null,null,"Describe Area:",{"$nulls":6},"Describe Area:","Showroom"]
[null,"Area 5 Sq. Ft.:",null,"The value entered will be verified on the floorplan layout",{"$nulls":4},"Area 3 Sq. Ft.:",{"v":5625,"d":"5,625"},"The value entered will be verified on the pdf layout"]
[]
["Area 6:"]
[null,null,"Describe Area:"]
[null,"Area 6 Sq. Ft.:",null,"The value entered will be verified on the floorplan layout"]
[]
["Area 7:"]
[null,null,"Describe Area:"]
[null,"Area 7 Sq. Ft.:",null,"The value entered will be verified on the floorplan layout"]
[]
["Area 8:"]
[null,null,"Describe Area:"]
[null,"Area 8 Sq. Ft.:",null,"The value entered will be verified on the floorplan layout"]
[]
["Area 9:"]
[null,null,"Describe Area:"]
[null,"Area 9 Sq. Ft.:",null,"The value entered will be verified on the floorplan layout"]
[]
["Area 10:"]
[null,null,"Describe Area:"]
[null,"Area 10 Sq. Ft.:",null,"The value entered will be verified on the floorplan layout"]
[]
["Area 11:"]
[null,null,"Describe Area:"]
[null,"Area 11 Sq. Ft.:",null,"The value entered will be verified on the floorplan layout"]
[]
["Area 12:"]
[null,null,"Describe Area:"]
[null,"Area 12 Sq. Ft.:",null,"The value entered will be verified on the floorplan layout"]
[]
["Area 13:"]
[null,null,"Describe Area:"]
[null,"Area 13 Sq. Ft.:",null,"The value entered will be verified on the floorplan layout"]
[]
["Area 14:"]
[null,null,"Describe Area:"]
[null,"Area 14 Sq. Ft.:",null,"The value entered will be verified on the floorplan layout"]
[]
["Area 15:"]
[null,null,"Describe Area:"]
[null,"Area 15 Sq. Ft.:",null,"The value entered will be verified on the floorplan layout"]
[]
["Area 16:"]
[null,null,"Describe Area:"]
[null,"Area 16 Sq. Ft.:",null,"The value entered will be verified on the floorplan layout"]
[]
["Area 17:"]
[null,null,"Describe Area:"]
[null,"Area 17 Sq. Ft.:",null,"The value entered will be verified on the floorplan layout"]
[]
["Area 18:"]
[null,null,"Describe Area:"]
[null,"Area 18 Sq. Ft.:",null,"The value entered will be verified on the floorplan layout"]
[]
["Area 19:"]
[null,null,"Describe Area:"]
[null,"Area 19 Sq. Ft.:",null,"The value entered will be verified on the floorplan layout"]
[]
["Area 20:"]
[null,null,"Describe Area:"]
[null,"Area 20 Sq. Ft.:",null,"The value entered will be verified on the floorplan layout"]
[]
["Area 21:"]
[null,null,"Describe Area:"]
[null,"Area 21 Sq. Ft.:",null,"The value entered will be verified on the floorplan layout"]
[]
["Area 22:"]
[null,null,"Describe Area:"]
[null,"Area 22 Sq. Ft.:",null,"The value entered will be verified on the floorplan layout"]
[]
["Area 23:"]
[null,null,"Describe Area:"]
[null,"Area 23 Sq. Ft.:",null,"The value entered will be verified on the floorplan layout"]
[]
["Area 24:"]
[null,null,"Describe Area:"]
[null,"Area 24 Sq. Ft.:",null,"The value entered will be verified on the floorplan layout"]
[]
["Area 25:"]
[null,null,"Describe Area:"]
[null,"Area 25 Sq. Ft.:",null,"The value entered will be verified on the floorplan layout"]
{"$rows_empty":47}
["Insert pdf(s) here:"]

{"sheet":"Fixture List Individual Files","index":6,"n_rows":1067,"n_cols":19,"rows_kept":1067,"hidden":true,"merged":[[0,0,7,9],[9,0,9,4],[10,14,10,18],[11,2,11,3],[51,0,51,4],[53,2,53,3],[93,0,93,4],[95,2,95,3],[135,0,135,4],[137,2,137,3],[177,0,177,4],[179,2,179,3],[219,0,219,4],[221,2,221,3],[261,0,261,4],[263,2,263,3],[303,0,303,4],[305,2,305,3],[345,0,345,4],[347,2,347,3],[387,0,387,4],[389,2,389,3],[429,0,429,4],[431,2,431,3],[471,0,471,4],[473,2,473,3],[513,0,513,4],[515,2,515,3],[555,0,555,4],[557,2,557,3],[597,0,597,4],[599,2,599,3],[639,0,639,4],[641,2,641,3],[681,0,681,4],[683,2,683,3],[723,0,723,4],[725,2,725,3],[765,0,765,4],[767,2,767,3],[807,0,807,4],[809,2,809,3],[849,0,849,4],[851,2,851,3],[891,0,891,4],[893,2,893,3],[933,0,933,4],[935,2,935,3],[975,0,975,4],[977,2,977,3],[1017,0,1017,4],[1019,2,1019,3],[1062,12,1062,15]]}
["List of ALL Interior fixtures installed (including quantity & wattage)\n - Do not include Exterior fixtures \n - If the project was NOT developed and overseen by a credentialed lighting professional (see Requirements tab for accepted credentials), then ALL lighting fixtures must be ENERGY STAR® or DLC SSL QPL listed (TRT V5.0 or higher). *Note* If even one fixture is not ENERGY STAR or DLC listed, the entire LPD measure is disqualified\n - Must report As-Built conditions. If discrepancies are found in review (ex.: fixtures listed, invoicing, in-person inspection), assumptions of higher value installed will be made\n - Installed lamps purchased at participating instant discount retailers disqualify the LPD measure\n - Choose Area Type(s) best describing the use of space\n - If \"Other-Identify\" is chosen, note on Start Here! Tab in \"Project Notes\"- The LPD calculation/incentive will be calculated upon review\n- For NLC - Industrial, School and Goverment customer installing NLC in high bay spaces and/or spaces requiring daylighting controls are not eligible for NLC incentives (N-L5233; NLC installed in other spaces are still eligible."]
{"$rows_empty":8}
["Area 1",{"$nulls":4},"NLC area factor"]
["Type:",{"$nulls":3},{"$f":"IFERROR(VLOOKUP(B11,Admin_Lists!$A$9:$B$49,2,FALSE),\"\")","v":""},{"$nulls":9},"Example"]
[null,"Description & Sq. Ft. listed in Sq. Ft. Area Tab (Area 1):",{"$f":"'Sq. Ft. Area Individual Files'!D10","v":0},null,{"$f":"'Sq. Ft. Area Individual Files'!C11","v":0},{"$nulls":9},"Type:","Warehouse",null,null,0.66]
["Fixture Mark","Fixture\nName","Fixture\nCount","Fixture Watts","Total\nWatts \n(Fixt Count \nx Fixt Watts)","NLC Controls (Yes/No)","Space type","Peak kW Savings","Annual kWh Savings","LC kWh Savings",{"$nulls":4},"Fixture Mark","Fixture\nName","Fixture\nCount","Fixture Watts","Total\nWatts \n(Fixt Count \nx Fixt Watts)"]
[{"$nulls":4},{"$f":"C14*D14","v":0},null,null,{"$f":"IF(AND(F14=\"Yes\",Facility_Type=\"Commercial\"),(E14/1000*0.14),IF(AND(F14=\"Yes\",Facility_Type=\"Industrial\",G14=\"Non-High Bay\"),(E14/1000*0.18),IF(AND(F14=\"Yes\",Facility_Type=\"Schools & Government\",G14=\"Non-High Bay\"),(E14/1000*0.14),\"\")))","v":""},{"$f":"IF(AND(F14=\"Yes\",Facility_Type=\"Commercial\"),((1-SFBASE_Commercial)-(1-SFE_Commercial))*E14/1000*Hrs_Commercial,IF(AND(F14=\"Yes\",Facility_Type=\"Industrial\",G14=\"Non-High Bay\"),((1-SFBASE_Industrial)-(1-SFE_Industrial))*E14/1000*Hrs_Industrial,IF(AND(F14=\"Yes\",Facility_Type=\"Schools & Government\",G14=\"Non-High Bay\"),(((1-SFBASE_SG)-(1-SFE_SG))*E14/1000*Hrs_SG),\"\")))","v":""},{"$f":"IFERROR(I14*EUL,\"\")","v":""},{"$nulls":4},"HB","Lithonia High Bay IBG 240000 LM SEF AFL",4,150,{"$f":"Q14*R14","v":600}]
[{"$nulls":4},0,null,null,"","","",{"$nulls":4},"SC","Lithonia CLX L96 6000LM SEF RDL ",10,49,490]
[{"$nulls":4},0,null,null,"","","",{"$nulls":4},"LS4.64","Lithonia Surface Mounted",251,55,13805]
[{"$nulls":4},0,null,null,"","","",{"$nulls":4},"LS4.47","Lithonia Surface Mounted",359,43,15437]
[{"$nulls":4},0,null,null,"","","",{"$nulls":4},"LS4.5","Lithonia Surface Mounted",1,43,43]
[{"$nulls":4},0,null,null,"","","",{"$nulls":4},"LSW4","GE Wall Mounted",2,48,96]
[{"$nulls":4},{"$f":"C20*D20","v":0},null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},{"$f":"C36*D36","v":0},null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},{"$f":"D47*C47","v":0},null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E14:E49)","v":0},null,null,{"$f":"SUM(H14:H49)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I14:I49)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[]
["Area 2",{"$nulls":4},"NLC area factor"]
["Type:","Choose from Drop-down",null,null,{"$f":"IFERROR(VLOOKUP(B53,Admin_Lists!$A$9:$B$49,2,FALSE),\"\")","v":0}]
[null,"Description & Sq. Ft. listed in Sq. Ft. Area Tab (Area 2):",{"$f":"'Sq. Ft. Area Individual Files'!D14","v":0},null,{"$f":"'Sq. Ft. Area Individual Files'!C15","v":0}]
["Fixture Mark","Fixture\nName","Fixture\nCount","Fixture Watts","Total\nWatts \n(Fixt Count \nx Fixt Watts)","NLC Controls (Yes/No)","Space type","Peak kW Savings","Annual kWh Savings","LC kWh Savings"]
[{"$nulls":4},{"$f":"C56*D56","v":0},null,null,{"$f":"IF(AND(F56=\"Yes\",Facility_Type=\"Commercial\"),(E56/1000*0.14),IF(AND(F56=\"Yes\",Facility_Type=\"Industrial\",G56=\"Non-High Bay\"),(E56/1000*0.18),IF(AND(F56=\"Yes\",Facility_Type=\"Schools & Government\",G56=\"Non-High Bay\"),(E56/1000*0.14),\"\")))","v":""},{"$f":"IF(AND(F56=\"Yes\",Facility_Type=\"Commercial\"),((1-SFBASE_Commercial)-(1-SFE_Commercial))*E56/1000*Hrs_Commercial,IF(AND(F56=\"Yes\",Facility_Type=\"Industrial\",G56=\"Non-High Bay\"),((1-SFBASE_Industrial)-(1-SFE_Industrial))*E56/1000*Hrs_Industrial,IF(AND(F56=\"Yes\",Facility_Type=\"Schools & Government\",G56=\"Non-High Bay\"),(((1-SFBASE_SG)-(1-SFE_SG))*E56/1000*Hrs_SG),\"\")))","v":""},{"$f":"IFERROR(I56*EUL,\"\")","v":""}]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},{"$f":"D62*C62","v":0},null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},{"$f":"D91*C91","v":0},null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E56:E91)","v":0},null,null,{"$f":"SUM(H56:H91)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I56:I91)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J56:J91)","v":{"v":0,"d":"0.00"}}]
[]
["Area 3",{"$nulls":4},"NLC area factor"]
["Type:","Choose from Drop-down",null,null,{"$f":"IFERROR(VLOOKUP(B95,Admin_Lists!$A$9:$B$49,2,FALSE),\"\")","v":0}]
[null,"Description & Sq. Ft. listed in Sq. Ft. Area Tab  (Area 3):",{"$f":"'Sq. Ft. Area Individual Files'!D18","v":0},null,{"$f":"'Sq. Ft. Area Individual Files'!C19","v":0}]
["Fixture Mark","Fixture\nName","Fixture\nCount","Fixture Watts","Total\nWatts \n(Fixt Count \nx Fixt Watts)","NLC Controls (Yes/No)","Space type","Peak kW Savings","Annual kWh Savings","LC kWh Savings"]
[{"$nulls":4},{"$f":"C98*D98","v":0},null,null,{"$f":"IF(AND(F98=\"Yes\",Facility_Type=\"Commercial\"),(E98/1000*0.14),IF(AND(F98=\"Yes\",Facility_Type=\"Industrial\",G98=\"Non-High Bay\"),(E98/1000*0.18),IF(AND(F98=\"Yes\",Facility_Type=\"Schools & Government\",G98=\"Non-High Bay\"),(E98/1000*0.14),\"\")))","v":""},{"$f":"IF(AND(F98=\"Yes\",Facility_Type=\"Commercial\"),((1-SFBASE_Commercial)-(1-SFE_Commercial))*E98/1000*Hrs_Commercial,IF(AND(F98=\"Yes\",Facility_Type=\"Industrial\",G98=\"Non-High Bay\"),((1-SFBASE_Industrial)-(1-SFE_Industrial))*E98/1000*Hrs_Industrial,IF(AND(F98=\"Yes\",Facility_Type=\"Schools & Government\",G98=\"Non-High Bay\"),(((1-SFBASE_SG)-(1-SFE_SG))*E98/1000*Hrs_SG),\"\")))","v":""},{"$f":"IFERROR(I98*EUL,\"\")","v":""}]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},{"$f":"D104*C104","v":0},null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},{"$f":"D133*C133","v":0},null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E98:E133)","v":0},null,null,{"$f":"SUM(H98:H133)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I98:I133)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J98:J133)","v":{"v":0,"d":"0.00"}}]
[]
["Area 4",{"$nulls":4},"NLC area factor"]
["Type:","Choose from Drop-down",null,null,{"$f":"IFERROR(VLOOKUP(B137,Admin_Lists!$A$9:$B$49,2,FALSE),\"\")","v":0}]
[null,"Description & Sq. Ft. listed in Sq. Ft. Area Tab  (Area 4):",{"$f":"'Sq. Ft. Area Individual Files'!D22","v":0},null,{"$f":"'Sq. Ft. Area Individual Files'!C23","v":0}]
["Fixture Mark","Fixture\nName","Fixture\nCount","Fixture Watts","Total\nWatts \n(Fixt Count \nx Fixt Watts)","NLC Controls (Yes/No)","Space type","Peak kW Savings","Annual kWh Savings","LC kWh Savings"]
[{"$nulls":4},{"$f":"C140*D140","v":0},null,null,{"$f":"IF(AND(F140=\"Yes\",Facility_Type=\"Commercial\"),(E140/1000*0.14),IF(AND(F140=\"Yes\",Facility_Type=\"Industrial\",G140=\"Non-High Bay\"),(E140/1000*0.18),IF(AND(F140=\"Yes\",Facility_Type=\"Schools & Government\",G140=\"Non-High Bay\"),(E140/1000*0.14),\"\")))","v":""},{"$f":"IF(AND(F140=\"Yes\",Facility_Type=\"Commercial\"),((1-SFBASE_Commercial)-(1-SFE_Commercial))*E140/1000*Hrs_Commercial,IF(AND(F140=\"Yes\",Facility_Type=\"Industrial\",G140=\"Non-High Bay\"),((1-SFBASE_Industrial)-(1-SFE_Industrial))*E140/1000*Hrs_Industrial,IF(AND(F140=\"Yes\",Facility_Type=\"Schools & Government\",G140=\"Non-High Bay\"),(((1-SFBASE_SG)-(1-SFE_SG))*E140/1000*Hrs_SG),\"\")))","v":""},{"$f":"IFERROR(I140*EUL,\"\")","v":""}]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},{"$f":"D146*C146","v":0},null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},{"$f":"D175*C175","v":0},null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E140:E175)","v":0},null,null,{"$f":"SUM(H140:H175)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I140:I175)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J140:J175)","v":{"v":0,"d":"0.00"}}]
[]
["Area 5",{"$nulls":4},"NLC area factor"]
["Type:","Choose from Drop-down",null,null,{"$f":"IFERROR(VLOOKUP(B179,Admin_Lists!$A$9:$B$49,2,FALSE),\"\")","v":0}]
[null,"Description & Sq. Ft. listed in Sq. Ft. Area Tab (Area 5):",{"$f":"'Sq. Ft. Area Individual Files'!D26","v":0},null,{"$f":"'Sq. Ft. Area Individual Files'!C27","v":0}]
["Fixture Mark","Fixture\nName","Fixture\nCount","Fixture Watts","Total\nWatts \n(Fixt Count \nx Fixt Watts)","NLC Controls (Yes/No)","Space type","Peak kW Savings","Annual kWh Savings","LC kWh Savings"]
[{"$nulls":4},{"$f":"C182*D182","v":0},null,null,{"$f":"IF(AND(F182=\"Yes\",Facility_Type=\"Commercial\"),(E182/1000*0.14),IF(AND(F182=\"Yes\",Facility_Type=\"Industrial\",G182=\"Non-High Bay\"),(E182/1000*0.18),IF(AND(F182=\"Yes\",Facility_Type=\"Schools & Government\",G182=\"Non-High Bay\"),(E182/1000*0.14),\"\")))","v":""},{"$f":"IF(AND(F182=\"Yes\",Facility_Type=\"Commercial\"),((1-SFBASE_Commercial)-(1-SFE_Commercial))*E182/1000*Hrs_Commercial,IF(AND(F182=\"Yes\",Facility_Type=\"Industrial\",G182=\"Non-High Bay\"),((1-SFBASE_Industrial)-(1-SFE_Industrial))*E182/1000*Hrs_Industrial,IF(AND(F182=\"Yes\",Facility_Type=\"Schools & Government\",G182=\"Non-High Bay\"),(((1-SFBASE_SG)-(1-SFE_SG))*E182/1000*Hrs_SG),\"\")))","v":""},{"$f":"IFERROR(I182*EUL,\"\")","v":""}]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},{"$f":"D188*C188","v":0},null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},{"$f":"D217*C217","v":0},null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E182:E217)","v":0},null,null,{"$f":"SUM(H182:H217)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I182:I217)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J182:J217)","v":{"v":0,"d":"0.00"}}]
[]
["Area 6",{"$nulls":4},"NLC area factor"]
["Type:","Choose from Drop-down",null,null,{"$f":"IFERROR(VLOOKUP(B221,Admin_Lists!$A$9:$B$49,2,FALSE),\"\")","v":0}]
[null,"Description & Sq. Ft. listed in Sq. Ft. Area Tab (Area 1):",{"$f":"'Sq. Ft. Area Individual Files'!D343","v":0},null,{"$f":"'Sq. Ft. Area Individual Files'!C344","v":0}]
["Fixture Mark","Fixture\nName","Fixture\nCount","Fixture Watts","Total\nWatts \n(Fixt Count \nx Fixt Watts)","NLC Controls (Yes/No)","Space type","Peak kW Savings","Annual kWh Savings","LC kWh Savings"]
[{"$nulls":4},{"$f":"C224*D224","v":0},null,null,{"$f":"IF(AND(F224=\"Yes\",Facility_Type=\"Commercial\"),(E224/1000*0.14),IF(AND(F224=\"Yes\",Facility_Type=\"Industrial\",G224=\"Non-High Bay\"),(E224/1000*0.18),IF(AND(F224=\"Yes\",Facility_Type=\"Schools & Government\",G224=\"Non-High Bay\"),(E224/1000*0.14),\"\")))","v":""},{"$f":"IF(AND(F224=\"Yes\",Facility_Type=\"Commercial\"),((1-SFBASE_Commercial)-(1-SFE_Commercial))*E224/1000*Hrs_Commercial,IF(AND(F224=\"Yes\",Facility_Type=\"Industrial\",G224=\"Non-High Bay\"),((1-SFBASE_Industrial)-(1-SFE_Industrial))*E224/1000*Hrs_Industrial,IF(AND(F224=\"Yes\",Facility_Type=\"Schools & Government\",G224=\"Non-High Bay\"),(((1-SFBASE_SG)-(1-SFE_SG))*E224/1000*Hrs_SG),\"\")))","v":""},{"$f":"IFERROR(I224*EUL,\"\")","v":""}]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},{"$f":"D257*C257","v":0},null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E224:E259)","v":0},null,null,{"$f":"SUM(H224:H259)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I224:I259)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J224:J259)","v":{"v":0,"d":"0.00"}}]
[]
["Area 7",{"$nulls":4},"NLC area factor"]
["Type:","Choose from Drop-down",null,null,{"$f":"IFERROR(VLOOKUP(B263,Admin_Lists!$A$9:$B$49,2,FALSE),\"\")","v":0}]
[null,"Description & Sq. Ft. listed in Sq. Ft. Area Tab (Area 2):",{"$f":"'Sq. Ft. Area Individual Files'!D347","v":0},null,{"$f":"'Sq. Ft. Area Individual Files'!C348","v":0}]
["Fixture Mark","Fixture\nName","Fixture\nCount","Fixture Watts","Total\nWatts \n(Fixt Count \nx Fixt Watts)","NLC Controls (Yes/No)","Space type","Peak kW Savings","Annual kWh Savings","LC kWh Savings"]
[{"$nulls":4},{"$f":"C266*D266","v":0},null,null,{"$f":"IF(AND(F266=\"Yes\",Facility_Type=\"Commercial\"),(E266/1000*0.14),IF(AND(F266=\"Yes\",Facility_Type=\"Industrial\",G266=\"Non-High Bay\"),(E266/1000*0.18),IF(AND(F266=\"Yes\",Facility_Type=\"Schools & Government\",G266=\"Non-High Bay\"),(E266/1000*0.14),\"\")))","v":""},{"$f":"IF(AND(F266=\"Yes\",Facility_Type=\"Commercial\"),((1-SFBASE_Commercial)-(1-SFE_Commercial))*E266/1000*Hrs_Commercial,IF(AND(F266=\"Yes\",Facility_Type=\"Industrial\",G266=\"Non-High Bay\"),((1-SFBASE_Industrial)-(1-SFE_Industrial))*E266/1000*Hrs_Industrial,IF(AND(F266=\"Yes\",Facility_Type=\"Schools & Government\",G266=\"Non-High Bay\"),(((1-SFBASE_SG)-(1-SFE_SG))*E266/1000*Hrs_SG),\"\")))","v":""},{"$f":"IFERROR(I266*EUL,\"\")","v":""}]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},{"$f":"D272*C272","v":0},null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E266:E301)","v":0},null,null,{"$f":"SUM(H266:H301)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I266:I301)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J266:J301)","v":{"v":0,"d":"0.00"}}]
[]
["Area 8",{"$nulls":4},"NLC area factor"]
["Type:","Choose from Drop-down",null,null,{"$f":"IFERROR(VLOOKUP(B305,Admin_Lists!$A$9:$B$49,2,FALSE),\"\")","v":0}]
[null,"Description & Sq. Ft. listed in Sq. Ft. Area Tab  (Area 3):",{"$f":"'Sq. Ft. Area Individual Files'!D351","v":0},null,{"$f":"'Sq. Ft. Area Individual Files'!C352","v":0}]
["Fixture Mark","Fixture\nName","Fixture\nCount","Fixture Watts","Total\nWatts \n(Fixt Count \nx Fixt Watts)","NLC Controls (Yes/No)","Space type","Peak kW Savings","Annual kWh Savings","LC kWh Savings"]
[{"$nulls":4},{"$f":"C308*D308","v":0},null,null,{"$f":"IF(AND(F308=\"Yes\",Facility_Type=\"Commercial\"),(E308/1000*0.14),IF(AND(F308=\"Yes\",Facility_Type=\"Industrial\",G308=\"Non-High Bay\"),(E308/1000*0.18),IF(AND(F308=\"Yes\",Facility_Type=\"Schools & Government\",G308=\"Non-High Bay\"),(E308/1000*0.14),\"\")))","v":""},{"$f":"IF(AND(F308=\"Yes\",Facility_Type=\"Commercial\"),((1-SFBASE_Commercial)-(1-SFE_Commercial))*E308/1000*Hrs_Commercial,IF(AND(F308=\"Yes\",Facility_Type=\"Industrial\",G308=\"Non-High Bay\"),((1-SFBASE_Industrial)-(1-SFE_Industrial))*E308/1000*Hrs_Industrial,IF(AND(F308=\"Yes\",Facility_Type=\"Schools & Government\",G308=\"Non-High Bay\"),(((1-SFBASE_SG)-(1-SFE_SG))*E308/1000*Hrs_SG),\"\")))","v":""},{"$f":"IFERROR(I308*EUL,\"\")","v":""}]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},{"$f":"D314*C314","v":0},null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E308:E343)","v":0},null,null,{"$f":"SUM(H308:H343)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I308:I343)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J308:J343)","v":{"v":0,"d":"0.00"}}]
[]
["Area 9",{"$nulls":4},"NLC area factor"]
["Type:","Choose from Drop-down",null,null,{"$f":"IFERROR(VLOOKUP(B347,Admin_Lists!$A$9:$B$49,2,FALSE),\"\")","v":0}]
[null,"Description & Sq. Ft. listed in Sq. Ft. Area Tab  (Area 4):",{"$f":"'Sq. Ft. Area Individual Files'!D355","v":0},null,{"$f":"'Sq. Ft. Area Individual Files'!C356","v":0}]
["Fixture Mark","Fixture\nName","Fixture\nCount","Fixture Watts","Total\nWatts \n(Fixt Count \nx Fixt Watts)","NLC Controls (Yes/No)","Space type","Peak kW Savings","Annual kWh Savings","LC kWh Savings"]
[{"$nulls":4},{"$f":"C350*D350","v":0},null,null,{"$f":"IF(AND(F350=\"Yes\",Facility_Type=\"Commercial\"),(E350/1000*0.14),IF(AND(F350=\"Yes\",Facility_Type=\"Industrial\",G350=\"Non-High Bay\"),(E350/1000*0.18),IF(AND(F350=\"Yes\",Facility_Type=\"Schools & Government\",G350=\"Non-High Bay\"),(E350/1000*0.14),\"\")))","v":""},{"$f":"IF(AND(F350=\"Yes\",Facility_Type=\"Commercial\"),((1-SFBASE_Commercial)-(1-SFE_Commercial))*E350/1000*Hrs_Commercial,IF(AND(F350=\"Yes\",Facility_Type=\"Industrial\",G350=\"Non-High Bay\"),((1-SFBASE_Industrial)-(1-SFE_Industrial))*E350/1000*Hrs_Industrial,IF(AND(F350=\"Yes\",Facility_Type=\"Schools & Government\",G350=\"Non-High Bay\"),(((1-SFBASE_SG)-(1-SFE_SG))*E350/1000*Hrs_SG),\"\")))","v":""},{"$f":"IFERROR(I350*EUL,\"\")","v":""}]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},{"$f":"D356*C356","v":0},null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E350:E385)","v":0},null,null,{"$f":"SUM(H350:H385)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I350:I385)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J350:J385)","v":{"v":0,"d":"0.00"}}]
[]
["Area 10",{"$nulls":4},"NLC area factor"]
["Type:","Choose from Drop-down",null,null,{"$f":"IFERROR(VLOOKUP(B389,Admin_Lists!$A$9:$B$49,2,FALSE),\"\")","v":0}]
[null,"Description & Sq. Ft. listed in Sq. Ft. Area Tab (Area 5):",{"$f":"'Sq. Ft. Area Individual Files'!D359","v":0},null,{"$f":"'Sq. Ft. Area Individual Files'!C360","v":0}]
["Fixture Mark","Fixture\nName","Fixture\nCount","Fixture Watts","Total\nWatts \n(Fixt Count \nx Fixt Watts)","NLC Controls (Yes/No)","Space type","Peak kW Savings","Annual kWh Savings","LC kWh Savings"]
[{"$nulls":4},{"$f":"C392*D392","v":0},null,null,{"$f":"IF(AND(F392=\"Yes\",Facility_Type=\"Commercial\"),(E392/1000*0.14),IF(AND(F392=\"Yes\",Facility_Type=\"Industrial\",G392=\"Non-High Bay\"),(E392/1000*0.18),IF(AND(F392=\"Yes\",Facility_Type=\"Schools & Government\",G392=\"Non-High Bay\"),(E392/1000*0.14),\"\")))","v":""},{"$f":"IF(AND(F392=\"Yes\",Facility_Type=\"Commercial\"),((1-SFBASE_Commercial)-(1-SFE_Commercial))*E392/1000*Hrs_Commercial,IF(AND(F392=\"Yes\",Facility_Type=\"Industrial\",G392=\"Non-High Bay\"),((1-SFBASE_Industrial)-(1-SFE_Industrial))*E392/1000*Hrs_Industrial,IF(AND(F392=\"Yes\",Facility_Type=\"Schools & Government\",G392=\"Non-High Bay\"),(((1-SFBASE_SG)-(1-SFE_SG))*E392/1000*Hrs_SG),\"\")))","v":""},{"$f":"IFERROR(I392*EUL,\"\")","v":""}]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},{"$f":"D398*C398","v":0},null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E392:E427)","v":0},null,null,{"$f":"SUM(H392:H427)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I392:I427)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J392:J427)","v":{"v":0,"d":"0.00"}}]
[]
["Area 11",{"$nulls":4},"NLC area factor"]
["Type:","Choose from Drop-down",null,null,{"$f":"IFERROR(VLOOKUP(B431,Admin_Lists!$A$9:$B$49,2,FALSE),\"\")","v":0}]
[null,"Description & Sq. Ft. listed in Sq. Ft. Area Tab (Area 1):",{"$f":"'Sq. Ft. Area Individual Files'!D553","v":0},null,{"$f":"'Sq. Ft. Area Individual Files'!C554","v":0}]
["Fixture Mark","Fixture\nName","Fixture\nCount","Fixture Watts","Total\nWatts \n(Fixt Count \nx Fixt Watts)","NLC Controls (Yes/No)","Space type","Peak kW Savings","Annual kWh Savings","LC kWh Savings"]
[{"$nulls":4},{"$f":"C434*D434","v":0},null,null,{"$f":"IF(AND(F434=\"Yes\",Facility_Type=\"Commercial\"),(E434/1000*0.14),IF(AND(F434=\"Yes\",Facility_Type=\"Industrial\",G434=\"Non-High Bay\"),(E434/1000*0.18),IF(AND(F434=\"Yes\",Facility_Type=\"Schools & Government\",G434=\"Non-High Bay\"),(E434/1000*0.14),\"\")))","v":""},{"$f":"IF(AND(F434=\"Yes\",Facility_Type=\"Commercial\"),((1-SFBASE_Commercial)-(1-SFE_Commercial))*E434/1000*Hrs_Commercial,IF(AND(F434=\"Yes\",Facility_Type=\"Industrial\",G434=\"Non-High Bay\"),((1-SFBASE_Industrial)-(1-SFE_Industrial))*E434/1000*Hrs_Industrial,IF(AND(F434=\"Yes\",Facility_Type=\"Schools & Government\",G434=\"Non-High Bay\"),(((1-SFBASE_SG)-(1-SFE_SG))*E434/1000*Hrs_SG),\"\")))","v":""},{"$f":"IFERROR(I434*EUL,\"\")","v":""}]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},{"$f":"D467*C467","v":0},null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E434:E469)","v":0},null,null,{"$f":"SUM(H434:H469)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I434:I469)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J434:J469)","v":{"v":0,"d":"0.00"}}]
[]
["Area 12",{"$nulls":4},"NLC area factor"]
["Type:","Choose from Drop-down",null,null,{"$f":"IFERROR(VLOOKUP(B473,Admin_Lists!$A$9:$B$49,2,FALSE),\"\")","v":0}]
[null,"Description & Sq. Ft. listed in Sq. Ft. Area Tab (Area 2):",{"$f":"'Sq. Ft. Area Individual Files'!D557","v":0},null,{"$f":"'Sq. Ft. Area Individual Files'!C558","v":0}]
["Fixture Mark","Fixture\nName","Fixture\nCount","Fixture Watts","Total\nWatts \n(Fixt Count \nx Fixt Watts)","NLC Controls (Yes/No)","Space type","Peak kW Savings","Annual kWh Savings","LC kWh Savings"]
[{"$nulls":4},{"$f":"C476*D476","v":0},null,null,{"$f":"IF(AND(F476=\"Yes\",Facility_Type=\"Commercial\"),(E476/1000*0.14),IF(AND(F476=\"Yes\",Facility_Type=\"Industrial\",G476=\"Non-High Bay\"),(E476/1000*0.18),IF(AND(F476=\"Yes\",Facility_Type=\"Schools & Government\",G476=\"Non-High Bay\"),(E476/1000*0.14),\"\")))","v":""},{"$f":"IF(AND(F476=\"Yes\",Facility_Type=\"Commercial\"),((1-SFBASE_Commercial)-(1-SFE_Commercial))*E476/1000*Hrs_Commercial,IF(AND(F476=\"Yes\",Facility_Type=\"Industrial\",G476=\"Non-High Bay\"),((1-SFBASE_Industrial)-(1-SFE_Industrial))*E476/1000*Hrs_Industrial,IF(AND(F476=\"Yes\",Facility_Type=\"Schools & Government\",G476=\"Non-High Bay\"),(((1-SFBASE_SG)-(1-SFE_SG))*E476/1000*Hrs_SG),\"\")))","v":""},{"$f":"IFERROR(I476*EUL,\"\")","v":""}]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},{"$f":"D482*C482","v":0},null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E476:E511)","v":0},null,null,{"$f":"SUM(H476:H511)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I476:I511)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J476:J511)","v":{"v":0,"d":"0.00"}}]
[]
["Area 13",{"$nulls":4},"NLC area factor"]
["Type:","Choose from Drop-down",null,null,{"$f":"IFERROR(VLOOKUP(B515,Admin_Lists!$A$9:$B$49,2,FALSE),\"\")","v":0}]
[null,"Description & Sq. Ft. listed in Sq. Ft. Area Tab  (Area 3):",{"$f":"'Sq. Ft. Area Individual Files'!D561","v":0},null,{"$f":"'Sq. Ft. Area Individual Files'!C562","v":0}]
["Fixture Mark","Fixture\nName","Fixture\nCount","Fixture Watts","Total\nWatts \n(Fixt Count \nx Fixt Watts)","NLC Controls (Yes/No)","Space type","Peak kW Savings","Annual kWh Savings","LC kWh Savings"]
[{"$nulls":4},{"$f":"C518*D518","v":0},null,null,{"$f":"IF(AND(F518=\"Yes\",Facility_Type=\"Commercial\"),(E518/1000*0.14),IF(AND(F518=\"Yes\",Facility_Type=\"Industrial\",G518=\"Non-High Bay\"),(E518/1000*0.18),IF(AND(F518=\"Yes\",Facility_Type=\"Schools & Government\",G518=\"Non-High Bay\"),(E518/1000*0.14),\"\")))","v":""},{"$f":"IF(AND(F518=\"Yes\",Facility_Type=\"Commercial\"),((1-SFBASE_Commercial)-(1-SFE_Commercial))*E518/1000*Hrs_Commercial,IF(AND(F518=\"Yes\",Facility_Type=\"Industrial\",G518=\"Non-High Bay\"),((1-SFBASE_Industrial)-(1-SFE_Industrial))*E518/1000*Hrs_Industrial,IF(AND(F518=\"Yes\",Facility_Type=\"Schools & Government\",G518=\"Non-High Bay\"),(((1-SFBASE_SG)-(1-SFE_SG))*E518/1000*Hrs_SG),\"\")))","v":""},{"$f":"IFERROR(I518*EUL,\"\")","v":""}]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},{"$f":"D524*C524","v":0},null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E518:E553)","v":0},null,null,{"$f":"SUM(H518:H553)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I518:I553)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J518:J553)","v":{"v":0,"d":"0.00"}}]
[]
["Area 14",{"$nulls":4},"NLC area factor"]
["Type:","Choose from Drop-down",null,null,{"$f":"IFERROR(VLOOKUP(B557,Admin_Lists!$A$9:$B$49,2,FALSE),\"\")","v":0}]
[null,"Description & Sq. Ft. listed in Sq. Ft. Area Tab  (Area 4):",{"$f":"'Sq. Ft. Area Individual Files'!D565","v":0},null,{"$f":"'Sq. Ft. Area Individual Files'!C566","v":0}]
["Fixture Mark","Fixture\nName","Fixture\nCount","Fixture Watts","Total\nWatts \n(Fixt Count \nx Fixt Watts)","NLC Controls (Yes/No)","Space type","Peak kW Savings","Annual kWh Savings","LC kWh Savings"]
[{"$nulls":4},{"$f":"C560*D560","v":0},null,null,{"$f":"IF(AND(F560=\"Yes\",Facility_Type=\"Commercial\"),(E560/1000*0.14),IF(AND(F560=\"Yes\",Facility_Type=\"Industrial\",G560=\"Non-High Bay\"),(E560/1000*0.18),IF(AND(F560=\"Yes\",Facility_Type=\"Schools & Government\",G560=\"Non-High Bay\"),(E560/1000*0.14),\"\")))","v":""},{"$f":"IF(AND(F560=\"Yes\",Facility_Type=\"Commercial\"),((1-SFBASE_Commercial)-(1-SFE_Commercial))*E560/1000*Hrs_Commercial,IF(AND(F560=\"Yes\",Facility_Type=\"Industrial\",G560=\"Non-High Bay\"),((1-SFBASE_Industrial)-(1-SFE_Industrial))*E560/1000*Hrs_Industrial,IF(AND(F560=\"Yes\",Facility_Type=\"Schools & Government\",G560=\"Non-High Bay\"),(((1-SFBASE_SG)-(1-SFE_SG))*E560/1000*Hrs_SG),\"\")))","v":""},{"$f":"IFERROR(I560*EUL,\"\")","v":""}]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},{"$f":"D566*C566","v":0},null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E560:E595)","v":0},null,null,{"$f":"SUM(H560:H595)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I560:I595)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J560:J595)","v":{"v":0,"d":"0.00"}}]
[]
["Area 15",{"$nulls":4},"NLC area factor"]
["Type:","Choose from Drop-down",null,null,{"$f":"IFERROR(VLOOKUP(B599,Admin_Lists!$A$9:$B$49,2,FALSE),\"\")","v":0}]
[null,"Description & Sq. Ft. listed in Sq. Ft. Area Tab (Area 5):",{"$f":"'Sq. Ft. Area Individual Files'!D569","v":0},null,{"$f":"'Sq. Ft. Area Individual Files'!C570","v":0}]
["Fixture Mark","Fixture\nName","Fixture\nCount","Fixture Watts","Total\nWatts \n(Fixt Count \nx Fixt Watts)","NLC Controls (Yes/No)","Space type","Peak kW Savings","Annual kWh Savings","LC kWh Savings"]
[{"$nulls":4},{"$f":"C602*D602","v":0},null,null,{"$f":"IF(AND(F602=\"Yes\",Facility_Type=\"Commercial\"),(E602/1000*0.14),IF(AND(F602=\"Yes\",Facility_Type=\"Industrial\",G602=\"Non-High Bay\"),(E602/1000*0.18),IF(AND(F602=\"Yes\",Facility_Type=\"Schools & Government\",G602=\"Non-High Bay\"),(E602/1000*0.14),\"\")))","v":""},{"$f":"IF(AND(F602=\"Yes\",Facility_Type=\"Commercial\"),((1-SFBASE_Commercial)-(1-SFE_Commercial))*E602/1000*Hrs_Commercial,IF(AND(F602=\"Yes\",Facility_Type=\"Industrial\",G602=\"Non-High Bay\"),((1-SFBASE_Industrial)-(1-SFE_Industrial))*E602/1000*Hrs_Industrial,IF(AND(F602=\"Yes\",Facility_Type=\"Schools & Government\",G602=\"Non-High Bay\"),(((1-SFBASE_SG)-(1-SFE_SG))*E602/1000*Hrs_SG),\"\")))","v":""},{"$f":"IFERROR(I602*EUL,\"\")","v":""}]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},{"$f":"D608*C608","v":0},null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E602:E637)","v":0},null,null,{"$f":"SUM(H602:H637)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I602:I637)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J602:J637)","v":{"v":0,"d":"0.00"}}]
[]
["Area 16",{"$nulls":4},"NLC area factor"]
["Type:","Choose from Drop-down",null,null,{"$f":"IFERROR(VLOOKUP(B641,Admin_Lists!$A$9:$B$49,2,FALSE),\"\")","v":0}]
[null,"Description & Sq. Ft. listed in Sq. Ft. Area Tab (Area 1):",{"$f":"'Sq. Ft. Area Individual Files'!D763","v":0},null,{"$f":"'Sq. Ft. Area Individual Files'!C764","v":0}]
["Fixture Mark","Fixture\nName","Fixture\nCount","Fixture Watts","Total\nWatts \n(Fixt Count \nx Fixt Watts)","NLC Controls (Yes/No)","Space type","Peak kW Savings","Annual kWh Savings","LC kWh Savings"]
[{"$nulls":4},{"$f":"C644*D644","v":0},null,null,{"$f":"IF(AND(F644=\"Yes\",Facility_Type=\"Commercial\"),(E644/1000*0.14),IF(AND(F644=\"Yes\",Facility_Type=\"Industrial\",G644=\"Non-High Bay\"),(E644/1000*0.18),IF(AND(F644=\"Yes\",Facility_Type=\"Schools & Government\",G644=\"Non-High Bay\"),(E644/1000*0.14),\"\")))","v":""},{"$f":"IF(AND(F644=\"Yes\",Facility_Type=\"Commercial\"),((1-SFBASE_Commercial)-(1-SFE_Commercial))*E644/1000*Hrs_Commercial,IF(AND(F644=\"Yes\",Facility_Type=\"Industrial\",G644=\"Non-High Bay\"),((1-SFBASE_Industrial)-(1-SFE_Industrial))*E644/1000*Hrs_Industrial,IF(AND(F644=\"Yes\",Facility_Type=\"Schools & Government\",G644=\"Non-High Bay\"),(((1-SFBASE_SG)-(1-SFE_SG))*E644/1000*Hrs_SG),\"\")))","v":""},{"$f":"IFERROR(I644*EUL,\"\")","v":""}]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},{"$f":"D677*C677","v":0},null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E644:E679)","v":0},null,null,{"$f":"SUM(H644:H679)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I644:I679)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J644:J679)","v":{"v":0,"d":"0.00"}}]
[]
["Area 17",{"$nulls":4},"NLC area factor"]
["Type:","Choose from Drop-down",null,null,{"$f":"IFERROR(VLOOKUP(B683,Admin_Lists!$A$9:$B$49,2,FALSE),\"\")","v":0}]
[null,"Description & Sq. Ft. listed in Sq. Ft. Area Tab (Area 2):",{"$f":"'Sq. Ft. Area Individual Files'!D767","v":0},null,{"$f":"'Sq. Ft. Area Individual Files'!C768","v":0}]
["Fixture Mark","Fixture\nName","Fixture\nCount","Fixture Watts","Total\nWatts \n(Fixt Count \nx Fixt Watts)","NLC Controls (Yes/No)","Space type","Peak kW Savings","Annual kWh Savings","LC kWh Savings"]
[{"$nulls":4},{"$f":"C686*D686","v":0},null,null,{"$f":"IF(AND(F686=\"Yes\",Facility_Type=\"Commercial\"),(E686/1000*0.14),IF(AND(F686=\"Yes\",Facility_Type=\"Industrial\",G686=\"Non-High Bay\"),(E686/1000*0.18),IF(AND(F686=\"Yes\",Facility_Type=\"Schools & Government\",G686=\"Non-High Bay\"),(E686/1000*0.14),\"\")))","v":""},{"$f":"IF(AND(F686=\"Yes\",Facility_Type=\"Commercial\"),((1-SFBASE_Commercial)-(1-SFE_Commercial))*E686/1000*Hrs_Commercial,IF(AND(F686=\"Yes\",Facility_Type=\"Industrial\",G686=\"Non-High Bay\"),((1-SFBASE_Industrial)-(1-SFE_Industrial))*E686/1000*Hrs_Industrial,IF(AND(F686=\"Yes\",Facility_Type=\"Schools & Government\",G686=\"Non-High Bay\"),(((1-SFBASE_SG)-(1-SFE_SG))*E686/1000*Hrs_SG),\"\")))","v":""},{"$f":"IFERROR(I686*EUL,\"\")","v":""}]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},{"$f":"D692*C692","v":0},null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E686:E721)","v":0},null,null,{"$f":"SUM(H686:H721)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I686:I721)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J686:J721)","v":{"v":0,"d":"0.00"}}]
[]
["Area 18",{"$nulls":4},"NLC area factor"]
["Type:","Choose from Drop-down",null,null,{"$f":"IFERROR(VLOOKUP(B725,Admin_Lists!$A$9:$B$49,2,FALSE),\"\")","v":0}]
[null,"Description & Sq. Ft. listed in Sq. Ft. Area Tab  (Area 3):",{"$f":"'Sq. Ft. Area Individual Files'!D771","v":0},null,{"$f":"'Sq. Ft. Area Individual Files'!C772","v":0}]
["Fixture Mark","Fixture\nName","Fixture\nCount","Fixture Watts","Total\nWatts \n(Fixt Count \nx Fixt Watts)","NLC Controls (Yes/No)","Space type","Peak kW Savings","Annual kWh Savings","LC kWh Savings"]
[{"$nulls":4},{"$f":"C728*D728","v":0},null,null,{"$f":"IF(AND(F728=\"Yes\",Facility_Type=\"Commercial\"),(E728/1000*0.14),IF(AND(F728=\"Yes\",Facility_Type=\"Industrial\",G728=\"Non-High Bay\"),(E728/1000*0.18),IF(AND(F728=\"Yes\",Facility_Type=\"Schools & Government\",G728=\"Non-High Bay\"),(E728/1000*0.14),\"\")))","v":""},{"$f":"IF(AND(F728=\"Yes\",Facility_Type=\"Commercial\"),((1-SFBASE_Commercial)-(1-SFE_Commercial))*E728/1000*Hrs_Commercial,IF(AND(F728=\"Yes\",Facility_Type=\"Industrial\",G728=\"Non-High Bay\"),((1-SFBASE_Industrial)-(1-SFE_Industrial))*E728/1000*Hrs_Industrial,IF(AND(F728=\"Yes\",Facility_Type=\"Schools & Government\",G728=\"Non-High Bay\"),(((1-SFBASE_SG)-(1-SFE_SG))*E728/1000*Hrs_SG),\"\")))","v":""},{"$f":"IFERROR(I728*EUL,\"\")","v":""}]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},{"$f":"D734*C734","v":0},null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E728:E763)","v":0},null,null,{"$f":"SUM(H728:H763)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I728:I763)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J728:J763)","v":{"v":0,"d":"0.00"}}]
[]
["Area 19",{"$nulls":4},"NLC area factor"]
["Type:","Choose from Drop-down",null,null,{"$f":"IFERROR(VLOOKUP(B767,Admin_Lists!$A$9:$B$49,2,FALSE),\"\")","v":0}]
[null,"Description & Sq. Ft. listed in Sq. Ft. Area Tab  (Area 4):",{"$f":"'Sq. Ft. Area Individual Files'!D775","v":0},null,{"$f":"'Sq. Ft. Area Individual Files'!C776","v":0}]
["Fixture Mark","Fixture\nName","Fixture\nCount","Fixture Watts","Total\nWatts \n(Fixt Count \nx Fixt Watts)","NLC Controls (Yes/No)","Space type","Peak kW Savings","Annual kWh Savings","LC kWh Savings"]
[{"$nulls":4},{"$f":"C770*D770","v":0},null,null,{"$f":"IF(AND(F770=\"Yes\",Facility_Type=\"Commercial\"),(E770/1000*0.14),IF(AND(F770=\"Yes\",Facility_Type=\"Industrial\",G770=\"Non-High Bay\"),(E770/1000*0.18),IF(AND(F770=\"Yes\",Facility_Type=\"Schools & Government\",G770=\"Non-High Bay\"),(E770/1000*0.14),\"\")))","v":""},{"$f":"IF(AND(F770=\"Yes\",Facility_Type=\"Commercial\"),((1-SFBASE_Commercial)-(1-SFE_Commercial))*E770/1000*Hrs_Commercial,IF(AND(F770=\"Yes\",Facility_Type=\"Industrial\",G770=\"Non-High Bay\"),((1-SFBASE_Industrial)-(1-SFE_Industrial))*E770/1000*Hrs_Industrial,IF(AND(F770=\"Yes\",Facility_Type=\"Schools & Government\",G770=\"Non-High Bay\"),(((1-SFBASE_SG)-(1-SFE_SG))*E770/1000*Hrs_SG),\"\")))","v":""},{"$f":"IFERROR(I770*EUL,\"\")","v":""}]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},{"$f":"D776*C776","v":0},null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E770:E805)","v":0},null,null,{"$f":"SUM(H770:H805)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I770:I805)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J770:J805)","v":{"v":0,"d":"0.00"}}]
[]
["Area 20",{"$nulls":4},"NLC area factor"]
["Type:","Choose from Drop-down",null,null,{"$f":"IFERROR(VLOOKUP(B809,Admin_Lists!$A$9:$B$49,2,FALSE),\"\")","v":0}]
[null,"Description & Sq. Ft. listed in Sq. Ft. Area Tab (Area 5):",{"$f":"'Sq. Ft. Area Individual Files'!D779","v":0},null,{"$f":"'Sq. Ft. Area Individual Files'!C780","v":0}]
["Fixture Mark","Fixture\nName","Fixture\nCount","Fixture Watts","Total\nWatts \n(Fixt Count \nx Fixt Watts)","NLC Controls (Yes/No)","Space type","Peak kW Savings","Annual kWh Savings","LC kWh Savings"]
[{"$nulls":4},{"$f":"C812*D812","v":0},null,null,{"$f":"IF(AND(F812=\"Yes\",Facility_Type=\"Commercial\"),(E812/1000*0.14),IF(AND(F812=\"Yes\",Facility_Type=\"Industrial\",G812=\"Non-High Bay\"),(E812/1000*0.18),IF(AND(F812=\"Yes\",Facility_Type=\"Schools & Government\",G812=\"Non-High Bay\"),(E812/1000*0.14),\"\")))","v":""},{"$f":"IF(AND(F812=\"Yes\",Facility_Type=\"Commercial\"),((1-SFBASE_Commercial)-(1-SFE_Commercial))*E812/1000*Hrs_Commercial,IF(AND(F812=\"Yes\",Facility_Type=\"Industrial\",G812=\"Non-High Bay\"),((1-SFBASE_Industrial)-(1-SFE_Industrial))*E812/1000*Hrs_Industrial,IF(AND(F812=\"Yes\",Facility_Type=\"Schools & Government\",G812=\"Non-High Bay\"),(((1-SFBASE_SG)-(1-SFE_SG))*E812/1000*Hrs_SG),\"\")))","v":""},{"$f":"IFERROR(I812*EUL,\"\")","v":""}]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},{"$f":"D818*C818","v":0},null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E812:E847)","v":0},null,null,{"$f":"SUM(H812:H847)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I812:I847)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J812:J847)","v":{"v":0,"d":"0.00"}}]
[]
["Area 21",{"$nulls":4},"NLC area factor"]
["Type:","Choose from Drop-down",null,null,{"$f":"IFERROR(VLOOKUP(B851,Admin_Lists!$A$9:$B$49,2,FALSE),\"\")","v":0}]
[null,"Description & Sq. Ft. listed in Sq. Ft. Area Tab (Area 1):",{"$f":"'Sq. Ft. Area Individual Files'!D973","v":0},null,{"$f":"'Sq. Ft. Area Individual Files'!C974","v":0}]
["Fixture Mark","Fixture\nName","Fixture\nCount","Fixture Watts","Total\nWatts \n(Fixt Count \nx Fixt Watts)","NLC Controls (Yes/No)","Space type","Peak kW Savings","Annual kWh Savings","LC kWh Savings"]
[{"$nulls":4},{"$f":"C854*D854","v":0},null,null,{"$f":"IF(AND(F854=\"Yes\",Facility_Type=\"Commercial\"),(E854/1000*0.14),IF(AND(F854=\"Yes\",Facility_Type=\"Industrial\",G854=\"Non-High Bay\"),(E854/1000*0.18),IF(AND(F854=\"Yes\",Facility_Type=\"Schools & Government\",G854=\"Non-High Bay\"),(E854/1000*0.14),\"\")))","v":""},{"$f":"IF(AND(F854=\"Yes\",Facility_Type=\"Commercial\"),((1-SFBASE_Commercial)-(1-SFE_Commercial))*E854/1000*Hrs_Commercial,IF(AND(F854=\"Yes\",Facility_Type=\"Industrial\",G854=\"Non-High Bay\"),((1-SFBASE_Industrial)-(1-SFE_Industrial))*E854/1000*Hrs_Industrial,IF(AND(F854=\"Yes\",Facility_Type=\"Schools & Government\",G854=\"Non-High Bay\"),(((1-SFBASE_SG)-(1-SFE_SG))*E854/1000*Hrs_SG),\"\")))","v":""},{"$f":"IFERROR(I854*EUL,\"\")","v":""}]
[{"$nulls":4},0,null,null,"","",{"$f":"IFERROR(I855*EUL,\"\")","v":""}]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},{"$f":"D887*C887","v":0},null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E854:E889)","v":0},null,null,{"$f":"SUM(H854:H889)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I854:I889)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J854:J889)","v":{"v":0,"d":"0.00"}}]
[]
["Area 22",{"$nulls":4},"NLC area factor"]
["Type:","Choose from Drop-down",null,null,{"$f":"IFERROR(VLOOKUP(B893,Admin_Lists!$A$9:$B$49,2,FALSE),\"\")","v":0}]
[null,"Description & Sq. Ft. listed in Sq. Ft. Area Tab (Area 2):",{"$f":"'Sq. Ft. Area Individual Files'!D977","v":0},null,{"$f":"'Sq. Ft. Area Individual Files'!C978","v":0}]
["Fixture Mark","Fixture\nName","Fixture\nCount","Fixture Watts","Total\nWatts \n(Fixt Count \nx Fixt Watts)","NLC Controls (Yes/No)","Space type","Peak kW Savings","Annual kWh Savings","LC kWh Savings"]
[{"$nulls":4},{"$f":"C896*D896","v":0},null,null,{"$f":"IF(AND(F896=\"Yes\",Facility_Type=\"Commercial\"),(E896/1000*0.14),IF(AND(F896=\"Yes\",Facility_Type=\"Industrial\",G896=\"Non-High Bay\"),(E896/1000*0.18),IF(AND(F896=\"Yes\",Facility_Type=\"Schools & Government\",G896=\"Non-High Bay\"),(E896/1000*0.14),\"\")))","v":""},{"$f":"IF(AND(F896=\"Yes\",Facility_Type=\"Commercial\"),((1-SFBASE_Commercial)-(1-SFE_Commercial))*E896/1000*Hrs_Commercial,IF(AND(F896=\"Yes\",Facility_Type=\"Industrial\",G896=\"Non-High Bay\"),((1-SFBASE_Industrial)-(1-SFE_Industrial))*E896/1000*Hrs_Industrial,IF(AND(F896=\"Yes\",Facility_Type=\"Schools & Government\",G896=\"Non-High Bay\"),(((1-SFBASE_SG)-(1-SFE_SG))*E896/1000*Hrs_SG),\"\")))","v":""},{"$f":"IFERROR(I896*EUL,\"\")","v":""}]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},{"$f":"D902*C902","v":0},null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E896:E931)","v":0},null,null,{"$f":"SUM(H896:H931)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I896:I931)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J896:J931)","v":{"v":0,"d":"0.00"}}]
[]
["Area 23",{"$nulls":4},"NLC area factor"]
["Type:","Choose from Drop-down",null,null,{"$f":"IFERROR(VLOOKUP(B935,Admin_Lists!$A$9:$B$49,2,FALSE),\"\")","v":0}]
[null,"Description & Sq. Ft. listed in Sq. Ft. Area Tab  (Area 3):",{"$f":"'Sq. Ft. Area Individual Files'!D981","v":0},null,{"$f":"'Sq. Ft. Area Individual Files'!C982","v":0}]
["Fixture Mark","Fixture\nName","Fixture\nCount","Fixture Watts","Total\nWatts \n(Fixt Count \nx Fixt Watts)","NLC Controls (Yes/No)","Space type","Peak kW Savings","Annual kWh Savings","LC kWh Savings"]
[{"$nulls":4},{"$f":"C938*D938","v":0},null,null,{"$f":"IF(AND(F938=\"Yes\",Facility_Type=\"Commercial\"),(E938/1000*0.14),IF(AND(F938=\"Yes\",Facility_Type=\"Industrial\",G938=\"Non-High Bay\"),(E938/1000*0.18),IF(AND(F938=\"Yes\",Facility_Type=\"Schools & Government\",G938=\"Non-High Bay\"),(E938/1000*0.14),\"\")))","v":""},{"$f":"IF(AND(F938=\"Yes\",Facility_Type=\"Commercial\"),((1-SFBASE_Commercial)-(1-SFE_Commercial))*E938/1000*Hrs_Commercial,IF(AND(F938=\"Yes\",Facility_Type=\"Industrial\",G938=\"Non-High Bay\"),((1-SFBASE_Industrial)-(1-SFE_Industrial))*E938/1000*Hrs_Industrial,IF(AND(F938=\"Yes\",Facility_Type=\"Schools & Government\",G938=\"Non-High Bay\"),(((1-SFBASE_SG)-(1-SFE_SG))*E938/1000*Hrs_SG),\"\")))","v":""},{"$f":"IFERROR(I938*EUL,\"\")","v":""}]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},{"$f":"D944*C944","v":0},null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E938:E973)","v":0},null,null,{"$f":"SUM(H938:H973)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I938:I973)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J938:J973)","v":{"v":0,"d":"0.00"}}]
[]
["Area 24",{"$nulls":4},"NLC area factor"]
["Type:","Choose from Drop-down",null,null,{"$f":"IFERROR(VLOOKUP(B977,Admin_Lists!$A$9:$B$49,2,FALSE),\"\")","v":0}]
[null,"Description & Sq. Ft. listed in Sq. Ft. Area Tab  (Area 4):",{"$f":"'Sq. Ft. Area Individual Files'!D985","v":0},null,{"$f":"'Sq. Ft. Area Individual Files'!C986","v":0}]
["Fixture Mark","Fixture\nName","Fixture\nCount","Fixture Watts","Total\nWatts \n(Fixt Count \nx Fixt Watts)","NLC Controls (Yes/No)","Space type","Peak kW Savings","Annual kWh Savings","LC kWh Savings"]
[{"$nulls":4},{"$f":"C980*D980","v":0},null,null,{"$f":"IF(AND(F980=\"Yes\",Facility_Type=\"Commercial\"),(E980/1000*0.14),IF(AND(F980=\"Yes\",Facility_Type=\"Industrial\",G980=\"Non-High Bay\"),(E980/1000*0.18),IF(AND(F980=\"Yes\",Facility_Type=\"Schools & Government\",G980=\"Non-High Bay\"),(E980/1000*0.14),\"\")))","v":""},{"$f":"IF(AND(F980=\"Yes\",Facility_Type=\"Commercial\"),((1-SFBASE_Commercial)-(1-SFE_Commercial))*E980/1000*Hrs_Commercial,IF(AND(F980=\"Yes\",Facility_Type=\"Industrial\",G980=\"Non-High Bay\"),((1-SFBASE_Industrial)-(1-SFE_Industrial))*E980/1000*Hrs_Industrial,IF(AND(F980=\"Yes\",Facility_Type=\"Schools & Government\",G980=\"Non-High Bay\"),(((1-SFBASE_SG)-(1-SFE_SG))*E980/1000*Hrs_SG),\"\")))","v":""},{"$f":"IFERROR(I980*EUL,\"\")","v":""}]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},{"$f":"D986*C986","v":0},null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E980:E1015)","v":0},null,null,{"$f":"SUM(H980:H1015)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I980:I1015)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J980:J1015)","v":{"v":0,"d":"0.00"}}]
[]
["Area 25",{"$nulls":4},"NLC area factor"]
["Type:","Choose from Drop-down",null,null,{"$f":"IFERROR(VLOOKUP(B1019,Admin_Lists!$A$9:$B$49,2,FALSE),\"\")","v":0}]
[null,"Description & Sq. Ft. listed in Sq. Ft. Area Tab (Area 5):",{"$f":"'Sq. Ft. Area Individual Files'!D989","v":0},null,{"$f":"'Sq. Ft. Area Individual Files'!C990","v":0}]
["Fixture Mark","Fixture\nName","Fixture\nCount","Fixture Watts","Total\nWatts \n(Fixt Count \nx Fixt Watts)","NLC Controls (Yes/No)","Space type","Peak kW Savings","Annual kWh Savings","LC kWh Savings"]
[{"$nulls":4},{"$f":"C1022*D1022","v":0},null,null,{"$f":"IF(AND(F1022=\"Yes\",Facility_Type=\"Commercial\"),(E1022/1000*0.14),IF(AND(F1022=\"Yes\",Facility_Type=\"Industrial\",G1022=\"Non-High Bay\"),(E1022/1000*0.18),IF(AND(F1022=\"Yes\",Facility_Type=\"Schools & Government\",G1022=\"Non-High Bay\"),(E1022/1000*0.14),\"\")))","v":""},{"$f":"IF(AND(F1022=\"Yes\",Facility_Type=\"Commercial\"),((1-SFBASE_Commercial)-(1-SFE_Commercial))*E1022/1000*Hrs_Commercial,IF(AND(F1022=\"Yes\",Facility_Type=\"Industrial\",G1022=\"Non-High Bay\"),((1-SFBASE_Industrial)-(1-SFE_Industrial))*E1022/1000*Hrs_Industrial,IF(AND(F1022=\"Yes\",Facility_Type=\"Schools & Government\",G1022=\"Non-High Bay\"),(((1-SFBASE_SG)-(1-SFE_SG))*E1022/1000*Hrs_SG),\"\")))","v":""},{"$f":"IFERROR(I1022*EUL,\"\")","v":""}]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},{"$f":"D1028*C1028","v":0},null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[{"$nulls":4},0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E1022:E1057)","v":0},null,null,{"$f":"SUM(H1022:H1057)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I1022:I1057)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J1022:J1057)","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
[]
[{"$nulls":12},"Savings"]
[{"$nulls":12},"Peak kW","kWh","Lifecycle","Incentive"]
[{"$nulls":12},{"$f":"SUM(H50+H92+H134+H176+H218+H260+H302+H344+H386+H428+H470+H512+H554+H596+H638+H680+H722+H764+H806+H848+H890+H932+H974+H1016+H1058)","v":{"v":0,"d":"0.0000"}},{"$f":"SUM(I50+I92+I134+I176+I218+I260+I302+I344+I386+I428+I470+I512+I554+I596+I638+I680+I722+I764+I806+I848+I890+I932+I974+I1016+I1058)","v":0},{"$f":"SUM(J50+J92+J134+J176+J218+J260+J302+J344+J386+J428+J470+J512+J554+J596+J638+J680+J722+J764+J806+J848+J890+J932+J974+J1016+J1058)","v":0},{"$f":"N1065*0.04","v":{"v":0,"d":"$0.00"}}]
[]
[{"$nulls":11},"Overall NLC area factor",{"$f":"IF(G10=\"\",1,G10)*IF(G52=\"\",1,G52)*IF(G94=\"\",1,G94)*IF(G136=\"\",1,G136)*IF(G178=\"\",1,G178)*IF(G220=\"\",1,G220)*IF(G262=\"\",1,G262)*IF(G304=\"\",1,G304)*IF(G346=\"\",1,G346)*IF(G388=\"\",1,G388)*IF(G430=\"\",1,G430)*IF(G472=\"\",1,G472)*IF(G514=\"\",1,G514)*IF(G556=\"\",1,G556)*IF(G598=\"\",1,G598)*IF(G640=\"\",1,G640)*IF(G682=\"\",1,G682)*IF(G724=\"\",1,G724)*IF(G766=\"\",1,G766)*IF(G808=\"\",1,G808)*IF(G850=\"\",1,G850)*IF(G892=\"\",1,G892)*IF(G934=\"\",1,G934)*IF(G976=\"\",1,G976)*IF(G1018=\"\",1,G1018)","v":{"v":1,"d":"100%"}}]

{"sheet":"Wattage Individual Files","index":7,"n_rows":11,"n_cols":1,"rows_kept":11,"hidden":true,"merged":[[0,0,8,10],[11,0,45,10]]}
["Documentation of Installed Fixture Wattage\n - Acceptable forms of wattage documentation: ENERGY STAR or DLC SSL QPL listings and/or Manufacturer's specs\n - If the project was not developed and overseen by a credentialed lighting professional (see Requirements tab for list of credentials),\n   then ALL lighting fixtures must be ENERGY STAR or DLC SSL QPL listed (TRT V5.0 or higher) *Note* If even one fixture is not ENERGY\n   STAR or DLC listed, the entire LPD measure is disqualified\n - Include multiple files if appropriate\n - Supply as separate document attachment(s) if file size is prohibitive\n - See Helpful Tips tab for help inserting files"]
{"$rows_empty":9}
["Insert file(s) here:"]

{"sheet":"Invoices Individual Files","index":8,"n_rows":10,"n_cols":1,"rows_kept":10,"hidden":true,"merged":[[0,0,6,10],[10,0,44,10]]}
["Invoices to Support Fixtures Installed\n - Include invoices for all interior fixtures installed (indicate any items on invoice that are not part of the LPD offering)\n - Provide itemized invoices showing quantity and make/model number\n - Include multiple files if appropriate\n - Supply as separate document attachment(s) if file size is prohibitive\n - Installed lamps purchased at participating instant discount retailers disqualify the LPD measure\n - See Helpful Tips tab for help inserting files"]
{"$rows_empty":8}
["Insert invoice(s) here:"]

{"sheet":"Helpful Tips Individual Files","index":9,"n_rows":35,"n_cols":11,"rows_kept":35,"hidden":true}
["Helpful Tips"]
[]
["How to Embed (insert) a PDF File in an Excel Worksheet",{"$nulls":9},"1)"]
["1. Go to Insert tab and click on the Object icon in the Text group. ..."]
["2. In the Object dialog box, select the 'Create New' tab and the select 'Adobe Acrobat Document' from the list. ..."]
["3. Check the option – 'Display as icon'."]
["4. If desired, select \"Change Icon\" to modify the file name displayed (ex: Installation invoice, COMcheckv1, etc.).  "]
["5. Click OK."]
["6. Select the PDF file to embed and click on Open."]
[]
["How to Unhide rows in an Excel Worksheet"]
["1. Select the row above, and row below the hidden rows"]
[]
[]
[]
[]
[]
["2. Right click mouse button",{"$nulls":9},"2-4)"]
["3. Select Unhide from menu"]
{"$rows_empty":12}
["How to quickly capture a screen shot/snip"]
["1. On a Windows PC press & hold WINDOWS Key + Shift + S",{"$nulls":9},"5)"]
["2. Screen will dim, then drag mouse to marquee around area you want captured"]
["3. Click on workbook, then Ctrl + V to Paste image"]

{"sheet":"RevisionHistory","index":10,"n_rows":19,"n_cols":4,"rows_kept":19,"hidden":true}
[]
[]
["Version History"]
["Program Year","Date of Revision","Description of Changes","Updated By:"]
[2021,"2021-01-01","Initial version"]
[2021,"2021-02-27","Added Tech Review calc, SPECTRUM entry, checklist. Fixed rounding errors. Added \"area description\" on individual files tab. Fixed protection to allow inserting pages","Trish"]
[2021,"2021-03-02","Corrected rounding issues on Start Here! Tab in columns J and H and R thru Y in savings table","Melissa"]
[2021,"2021-03-18","Changed algorithms in cells S4-S47 to reference only one cell for CF lookup. Also, removed colon (\":\") at the end of the facility type names (cells J14-J19) to aide proper lookup for CF","Zishan"]
[2021,"2021-03-25","Removed ROUNDDOWN function and added ROUND to cells H23-H27, J23-J27, R42-R47 and W42-W47 in \"Start Here!\" tab. Also added ROUND function to round allowed watts in \"As-Built COMcheck\" tab","Zishan"]
[2021,"2021-03-26","Added algorithm to correctly pull CF in O38"]
[2021,"2021-03-26","Conditional format HOU on Start Here tab. Add LPD reference table on As-Built COMcheck tab. Add note about more than 5 area types on As-Built COMcheck tab. Formatted Indiv. Files Sq Ft by area to be reflected on Fixt List tab.","Trish"]
[2021,"2021-04-07","Added 'qualify the project' section to Start here tab","Trish"]
[2021,"2021-04-12","Added \"Annual\" to Hours of use in sds table. Revised formatting of lines on COMcheck tab, and added consistent verbiage to \"more than 5 areas topic\" on COMcheck tab. Updated the utility $/therm, #/kWh to 2019","Trish"]
[2021,"2021-05-17","Corrected units for kWh (annual and lifecycle) on Start Here! tab summary table ","Todd"]
[2021,"2021-07-19","Updated list of credentials for lighting designers","Melissa"]
[2021,null,"Added lines back in that were inadvertently deleted from Fixt List Individual Files tab. Not considering this a revision","Trish"]
[2021,"2021-12-21","Changed the workbook to make it compatible for NLC-NC","Zishan"]
[2022,"2022-01-10","Updated requirements from 2022 Lighting Catalog","Melissa"]
[2022,"2022-02-17","Made changes to accurately calculate the NLC measure cost based on NLC area factor.","Zishan"]

{"sheet":"Helpful Tips COMcheck","index":11,"n_rows":33,"n_cols":11,"rows_kept":33,"hidden":true}
["Helpful Tips"]
[]
["How to Embed a PDF File in an Excel Worksheet",{"$nulls":9},"1)"]
["1. Go to Insert tab and click on the Object icon in the Text group. ..."]
["2. In the Object dialog box, select the 'Create New' tab and the select 'Adobe Acrobat Document' from the list. ..."]
["3. Check the option – 'Display as icon'."]
["4. If desired, select \"Change Icon\" to modify the file name displayed (ex: Installation invoice, COMcheckv1, etc.).  "]
["5. Click OK."]
["6. Select the PDF file to embed and click on Open."]
[]
["How to Unhide rows in an Excel Worksheet"]
["1. Select the row above, and row below the hidden rows"]
[]
[]
[]
[]
[]
["2. Right click mouse button",{"$nulls":9},"2-4)"]
["3. Select Unhide from menu"]
{"$rows_empty":13}
[{"$nulls":10},"5)"]

{"sheet":"Admin_Lists","index":12,"n_rows":107,"n_cols":15,"rows_kept":107,"hidden":true,"merged":[[6,0,7,1],[8,14,9,15],[51,0,52,0]]}
[]
[null,"Type"]
[null,"Choose from Drop-down",null,"<==The items in this list are named ComCheck"]
[null,"COMcheck",null,"To name the data cells, select them, click in the Name Box"]
[null,"Individual Files",null,"Add more words to the list, and the list will expand to include them"]
[]
["LIGHTING POWER DENSITY\n(AREA METHOD)",{"$nulls":6},"Space by Space Reference for Tech Review, not part of drop-down options"]
[{"$nulls":7},"Common & Specific Space Types",{"$nulls":4},"(W/ft2)"]
["Choose from Drop-down",0,{"$nulls":5},"Atrium - greater than 40 ft. in height",{"$nulls":4},{"v":0.4,"d":"0.40"}," 0.40+.02/ft in total height","Ceiling Height\n(If Applicable)  "]
["Automotive Facility",0.8,{"$nulls":5},"Atrium - less than 40 ft. in height",{"$nulls":4},0.03,"0.03/ft in total height"]
["Convention Center",1.01,{"$nulls":5},"Audience Seating Area - in a convention center",{"$nulls":4},0.82]
["Court House",1.01,{"$nulls":5},"Audience Seating Area - in a gymnasium",{"$nulls":4},0.65]
["Dining: Bar Lounge/Leisure",1.01,{"$nulls":5},"Audience Seating Area - in a motion picture theatre",{"$nulls":4},1.14]
["Dining: Cafeteria/Fast Food",0.9,{"$nulls":5},"Audience Seating Area - in a penitentiary",{"$nulls":4},0.28]
["Dining: Family",0.95,{"$nulls":5},"Audience Seating Area - in a performing arts theatre",{"$nulls":4},2.43]
["Dormitory",0.57,{"$nulls":5},"Audience Seating Area - in a religious building ",{"$nulls":4},1.53]
["Exercise Center",0.84,{"$nulls":5},"Audience Seating Area - in a sports arena",{"$nulls":4},0.43]
["Fire Station",0.67,{"$nulls":5},"Audience Seating Area - in an auditorium",{"$nulls":4},0.63]
["Free Stall",0.5,{"$nulls":5},"Audience Seating Area - otherwise",{"$nulls":4},0.43]
["General Animal Care Area, Utility Room",0.5,{"$nulls":5},"Automotive (see Vehicular Maintenance Area above)",{"$nulls":4},0.67]
["Gymnasium",0.94,{"$nulls":5},"Banking Activity Area",{"$nulls":4},1.01]
["Healthcare Clinic",0.9,{"$nulls":5},"Classroom/lecture hall/training room - in a penitentary",{"$nulls":4},1.34]
["Hospital",1.05,{"$nulls":5},"Classroom/lecture hall/training room -otherwise",{"$nulls":4},1.24]
["Hotel/Motel",0.87,{"$nulls":5},"Computer Room",{"$nulls":4},1.71]
["Library",1.19,{"$nulls":5},"Conference/meeting/multipurpose room",{"$nulls":4},1.23]
["Loading and Storage Area, Restroom",0.5,{"$nulls":5},"Convention Center (exhibit space)",{"$nulls":4},1.45]
["Manual Wash Sink, Treatment or Surgery Area",1.19,{"$nulls":5},"Copy/print room",{"$nulls":4},0.72]
["Manufacturing Facility",1.17,{"$nulls":5},"Corridor - in a facility for the impaired",{"$nulls":4},0.92]
["Motion Picture Theater",0.76,{"$nulls":5},"Corridor - in a hospital",{"$nulls":4},0.79]
["Multifamily",0.51,{"$nulls":5},"Corridor - in a manufacturing facility",{"$nulls":4},0.41]
["Museum",1.02,{"$nulls":5},"Corridor - otherwise",{"$nulls":4},0.66]
["Non-Dairy Livestock Housing, Holding Area, Machine Storage",0.21,{"$nulls":5},"Courtroom",{"$nulls":4},1.72]
["Office",0.82,{"$nulls":5},"Dining Area - in a facility for the visually impaired",{"$nulls":4},{"v":1.9,"d":"1.90"}]
["Operator's Pit, Office Area at Desk Top, Farm Shop/Repair Area ",0.82,{"$nulls":5},"Dining Area - in a penitentiary",{"$nulls":4},0.96]
["Other- Identify",{"$nulls":6},"Dining Area - in bar/lounge or leisure dining",{"$nulls":4},1.07]
["Parking Garage",0.21,{"$nulls":5},"Dining Area - in cafeteria or fast food dining",{"$nulls":4},0.65]
["Penitentiary",0.81,{"$nulls":5},"Dining Area - in family dining",{"$nulls":4},0.89]
["Performing Arts Theater",1.39,{"$nulls":5},"Dining Area - otherwise",{"$nulls":4},0.65]
["Police Station",0.87,{"$nulls":5},"Dormitory - living quarters",{"$nulls":4},0.38]
["Post Office",0.87,{"$nulls":5},"Electrical/mechanical room",{"$nulls":4},0.95]
["Religious Building",1,{"$nulls":5},"Emergency vehicle garage",{"$nulls":4},0.56]
["Retail",1.26,{"$nulls":5},"Facility for the visually impaired - in a chapel",{"$nulls":4},2.21]
["School/University",0.87,{"$nulls":5},"Facility for the visually impaired - in a recreation room",{"$nulls":4},2.41]
["Sports Arena",0.91,{"$nulls":5},"Fire Station - sleeping quarters",{"$nulls":4},0.22]
["Tie Stall Feeding Alley, Milking Parlor, Milk Room",0.5,{"$nulls":5},"Food preparation area",{"$nulls":4},1.21]
["Town Hall",0.89,{"$nulls":5},"Guest room",{"$nulls":4},0.47]
["Transportation",0.7,{"$nulls":5},"Gymnasium/fitness center - in a playing area",{"$nulls":4},{"v":1.2,"d":"1.20"}]
["Warehouse",0.66,{"$nulls":5},"Gymnasium/fitness center - in an exercise area",{"$nulls":4},0.72]
["Workshop",1.19,{"$nulls":5},"Healthcare facility - in a medical supply room",{"$nulls":4},0.74]
[{"$nulls":7},"Healthcare facility - in a nursery",{"$nulls":4},0.88]
[{"$nulls":7},"Healthcare facility - in a nurse's station",{"$nulls":4},0.71]
["Hours of Use",{"$nulls":6},"Healthcare facility - in a patient room",{"$nulls":4},0.62]
[{"$nulls":7},"Healthcare facility - in a physical therapy room",{"$nulls":4},0.91]
["Use Commercial Default 3,730",{"v":3730,"d":"3,730"},{"$nulls":5},"Healthcare facility - in a recovery room",{"$nulls":4},1.15]
["Use Industrial Default 4,745",{"v":4745,"d":"4,745"},{"$nulls":5},"Healthcare facility - in an exam/treatment room",{"$nulls":4},1.66]
["Use Agricultural Default 4,698",{"v":4698,"d":"4,698"},{"$nulls":5},"Healthcare facility - in an imaging room",{"$nulls":4},1.51]
["Use Schools & Government Default 3,239",{"v":3239,"d":"3,239"},{"$nulls":5},"Healthcare facility - in an operating room",{"$nulls":4},2.48]
["Use Multifamily - Common Area Default 5,950",{"v":5950,"d":"5,950"},{"$nulls":5},"Laboratory - in or as a classroom",{"$nulls":4},1.43]
["Use Multifamily - In-unit Default 840",840,{"$nulls":5},"Laboratory - otherwise",{"$nulls":4},1.81]
["n/a (Manual Entry)",{"$f":"'Start Here!'!G27","v":0},{"$nulls":5},"Laundry/washing area",{"$nulls":4},{"v":0.6,"d":"0.60"}]
[{"$nulls":7},"Library - in a reading area",{"$nulls":4},1.06]
["Choose from Drop-down",{"$nulls":6},"Library - in the stacks",{"$nulls":4},1.71]
["Commercial",{"v":3730,"d":"3,730"},{"$nulls":5},"Loading dock, interior",{"$nulls":4},0.47]
["Industrial",{"v":4745,"d":"4,745"},{"$nulls":5},"Lobby - for an elevator",{"$nulls":4},0.64]
["Agricultural",{"v":4698,"d":"4,698"},{"$nulls":5},"Lobby - in a facility for the visually impaired",{"$nulls":4},{"v":1.8,"d":"1.80"}]
["Schools & Government",{"v":3239,"d":"3,239"},{"$nulls":5},"Lobby - in a hotel",{"$nulls":4},1.06]
["Multifamily",{"$nulls":6},"Lobby - in a motion picture theatre",{"$nulls":4},0.59]
[{"$nulls":7},"Lobby - in a performing arts theatre",{"$nulls":4},2]
["Row Size",{"$nulls":6},"Lobby - locker room",{"$nulls":4},0.75]
["Choose from Drop-down",{"$nulls":6},"Lobby - otherwise",{"$nulls":4},{"v":0.9,"d":"0.90"}]
["Small (5 rows)",{"$nulls":6},"Lounge/breakroom - in a healthcare facility",{"$nulls":4},0.92]
["Large (25 rows)",{"$nulls":6},"Lounge/breakroom - otherwise",{"$nulls":4},0.73]
[{"$nulls":7},"Manufacturing facility - in a detailed manufacturing area",{"$nulls":4},1.29]
[{"$nulls":7},"Manufacturing facility - in a high bay area (25-50' floor-to-ceiling height)",{"$nulls":4},1.23]
[{"$nulls":7},"Manufacturing facility - in a low bay area ( < 25' floor-to-ceiling height)",{"$nulls":4},1.19]
[null,"SFBASE","SFEE","HOU","kWhSAVED",null,null,"Manufacturing facility - in an equipment room",{"$nulls":4},0.74]
["Commercial",0.34,0.51,3730,0.6340999999999998,null,null,"Manufacturing facility - in an extra high bay area ( > 50' floor-to-ceiling height)",{"$nulls":4},1.05]
["Industrial",0.24,0.43,4745,0.9015499999999997,null,null,"Museum - in a general exhibition area",{"$nulls":4},1.05]
["Schools & Government",0.24,0.28,3239,0.12956000000000012,null,null,"Museum - in a restoration room",{"$nulls":4},1.02]
[{"$nulls":7},"Office - enclosed",{"$nulls":4},1.11]
[{"$nulls":7},"Office - open plan",{"$nulls":4},0.98]
["Choose from Drop-down",{"$nulls":6},"Parking area, interior",{"$nulls":4},0.19]
["High Bay",{"$nulls":6},"Performance arts theatre - dressing room",{"$nulls":4},0.61]
["Spaces with Daylighting",{"$nulls":6},"Pharmacy area",{"$nulls":4},1.68]
["Non-High Bay",{"$nulls":6},"Post Office - Sorting Area",{"$nulls":4},0.94]
[{"$nulls":7},"Religious buildings - in a fellowship hall",{"$nulls":4},0.64]
[{"$nulls":7},"Religious buildings - in a workship/pulpit/choir area",{"$nulls":4},1.53]
["EUL",18,{"$nulls":5},"Restroom - in a facility for the visually impaired",{"$nulls":4},1.21]
[{"$nulls":7},"Restroom - otherwise",{"$nulls":4},0.98]
[{"$nulls":7},"Retail facilities - in a dressing/fitting room",{"$nulls":4},0.71]
[{"$nulls":7},"Retail facilities - in a mall concourse",{"$nulls":4},{"v":1.1,"d":"1.10"}]
["Default Utility Rates",{"$nulls":6},"Sales area",{"$nulls":4},1.59]
["Sector","$/kWh","$/therm",{"$nulls":4},"Seating area, general",{"$nulls":4},0.54]
["Commercial / Schools & Government",0.1105,0.5663472496706192,{"$nulls":4},"Sports area - for a Class I facility",{"$nulls":4},3.68]
["Industrial",0.0771,0.438,{"$nulls":4},"Sports area - for a Class II facility ",{"$nulls":4},{"v":2.4,"d":"2.40"}]
["Residential",0.148,0.752,{"$nulls":4},"Sports area - for a Class III facility",{"$nulls":4},{"v":1.8,"d":"1.80"}]
["EIA 2020 Annual Rates",{"$nulls":6},"Sports area - for a Class IV facility",{"$nulls":4},{"v":1.2,"d":"1.20"}]
[{"$nulls":7},"Stairway (see space containing stairway)",{"$nulls":4},"N/A"]
[{"$nulls":7},"Stairwell",{"$nulls":4},0.69]
[{"$nulls":7},"Storage room",{"$nulls":4},0.63]
[{"$nulls":7},"Transportation facility - at a terminal ticket counter",{"$nulls":4},{"v":0.8,"d":"0.80"}]
[{"$nulls":7},"Transportation facility - in a baggage/carousel area",{"$nulls":4},0.53]
[{"$nulls":7},"Transportation facility - in an airport concourse",{"$nulls":4},0.36]
[{"$nulls":7},"Vehicular maintenance area",{"$nulls":4},0.67]
[{"$nulls":7},"Warehouse storage area - for medium to bulky, palletized items",{"$nulls":4},0.58]
[{"$nulls":7},"Warehouse storage area - for smaller, hand-carried items",{"$nulls":4},0.95]
[{"$nulls":7},"Workshop",{"$nulls":4},1.59]