{"text_format":"1","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":{"charts":0,"images":12,"macros":1,"external_links":0,"defined_names":24,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Start Here!","index":0,"n_rows":114,"n_cols":35,"rows_kept":114,"cut":false,"hidden":false,"merged":[[31,13,31,17],[32,13,32,17],[24,13,25,17],[24,18,25,18],[27,18,28,18],[29,18,30,18],[26,13,26,17],[27,13,28,17],[29,13,30,17],[97,34,97,38],[95,34,95,38],[96,29,96,30],[96,34,96,38],[95,29,95,30],[106,30,110,30],[94,29,94,30],[22,9,22,10],[19,1,19,2],[19,3,19,11],[59,1,60,1],[26,9,26,10],[23,9,23,10],[30,2,30,11],[24,9,24,10],[25,9,25,10],[23,6,23,7],[97,29,97,30],[23,13,23,17],[33,13,33,17],[21,13,21,17],[9,13,9,14],[27,9,27,11],[17,3,17,11],[21,9,21,11],[22,13,22,17],[16,3,16,5],[16,10,16,11],[13,1,13,11],[24,6,25,7],[26,6,28,7],[9,2,9,10],[10,3,10,11],[9,16,9,17],[12,3,12,11],[11,2,11,10],[1,1,1,11],[18,3,18,11],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[16,7,16,8],[14,3,14,11],[15,3,15,11],[6,3,6,11],[8,3,8,11],[3,1,3,11],[4,1,4,2],[5,1,5,10],[7,2,7,10]]}
[]
[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? ",null,null,null,null,null,null,null,null,null,"Select Yes or No"]
[null,null,null,{"$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":""},null,null,null,null,null,null,null,null,"Select Yes or No"]
[null,null,null,{"$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":""},null,null,null,null,null,null,null,null,"Select Yes or No",null,"SPECTRUM entry:",null,null,"SPECTRUM entry (NLC Savings):"]
[null,null,null,{"$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":" "},null,null,null,null,null,null,null,null,null,"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?",null,null,null,null,null,null,null,null,"Select Yes or No",null,"Units",1,null,"Units",1]
[null,null,null,{"$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":""},null,null,null,null,null,null,null,null,null,"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.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Provide\nAS BUILT:","Possible ways to provide it:"]
[null,"Customer:",null,null,null,null,null,null,null,null,null,null,null,"kW Savings (Peak)",{"$f":"S88","v":0},"net savings all areas","kW Savings (Peak)",{"$f":"'Fixture List Individual Files'!M1065","v":0},"net savings all areas",null,null,null,null,null,"Sq Ft","COMcheck","Layout","Schedule","Submittal","Email","QPL snip"]
[null,"Trade Ally/Installer:",null,null,null,null,null,null,null,null,null,null,null,"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",null,null,null,null,null,"Wattage ","COMcheck","Layout","Schedule","Submittal","Email","QPL snip"]
[null,"Best Contact for LPD Questions:",null,null,null,null,"Email:",null,null,"Phone:",null,null,null,"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",null,null,null,null,null,"Fixture list","COMcheck","Layout","Schedule","Submittal","Email","QPL snip"]
[null,"Project Description:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pro Sign-off","COMcheck","Layout","Schedule","Submittal","Email","QPL snip"]
[null,"Project Completion Date:",null,null,null,null,null,null,null,null,null,null,null,"Total Incentive",{"$f":"L58","v":0},"net incentive all areas","Total Incentive",{"$f":"'Fixture List Individual Files'!P1065","v":0},"net incentive all areas",null,null,null,null,null,"Invoice","COMcheck","Layout","Schedule","Submittal","Email","QPL snip"]
[null,"Project Notes:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O13<O19,\"Total Incentive may not exceed Measure Cost!\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"COMcheck","Layout","Schedule","Submittal","Email","QPL snip"]
[]
[null,null,null,"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. ",null,null,null,"CESA Check-list:",null,null,null,null,"Completed by:","Notes:"]
[null,null,null,null,null,null,null,null,null,"Default Facility Type",null,"HOU","CF","If other than Default HOU, note source"]
[null,null,null,"Project Size:","Small (5 rows)",null,"Describe Hours of Use: ",null,null,"Commercial",null,3730,0.77,"COMcheck is 2015 IECC"]
[null,null,{"$f":"IF(E22=\"Individual Files\",\"Corresponding Tabs:\",IF(E22=\"COMcheck\",\"Corresponding Tabs:\",\"\"))","v":""},null,null,null,"Ex.: Store M-F 9am-6pm, Office M-F 7am-5pm, Warehouse M-F 5am-9pm",null,null,"Industrial",null,4745,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":""},null,null,null,null,null,null,"Agricultural",null,4698,0.67]
[null,null,null,null,null,null,null,null,null,"Schools & Government",null,3239,0.64,"Confirm/Call-out/Note Source of Square Footage"]
[null,null,null,null,null,null,null,null,null,"Enter Hours of Use in Column (B) below",null,null,null,"Spot check top 3 qty of fixtures to ensure quantity alignment. \n\"COMcheck v. Invoice / Fixt List v. Invoice\""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"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(C33>1,\"Area 1\",IF(C33,\"\",\"\"))","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":""},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(E34-H34,2),\"-\")","v":"-"},{"$f":"IFERROR(ROUND(C34*D34*I34/1000,0),\"\")","v":""},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":"-"},"",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},"","-","",0.04,""]
[null,{"$f":"IF(C37>1,\"Area 5\",IF(C37,\"\",\"\"))","v":""},{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D31,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},"","-","",0.04,""]
[null,{"$f":"IF(C38>1,\"Area 6\",IF(C38,\"\",\"\"))","v":""},{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D36,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":""},0.04,{"$f":"IFERROR(J38*K38,\"\")","v":""}]
[null,{"$f":"IF(C39>1,\"Area 7\",IF(C39,\"\",\"\"))","v":""},{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D41,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":"-"},"",0.04,""]
[null,{"$f":"IF(C40>1,\"Area 8\",IF(C40,\"\",\"\"))","v":""},{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D46,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},"","-","",0.04,""]
[null,{"$f":"IF(C41>1,\"Area 9\",IF(C41,\"\",\"\"))","v":""},{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D51,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},"","-","",0.04,""]
[null,{"$f":"IF(C42>1,\"Area 10\",IF(C42,\"\",\"\"))","v":""},{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D56,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},"","-","",0.04,""]
[null,{"$f":"IF(C43>1,\"Area 11\",IF(C43,\"\",\"\"))","v":""},{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D61,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},"","-","",0.04,""]
[null,{"$f":"IF(C44>1,\"Area 12\",IF(C44,\"\",\"\"))","v":""},{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D66,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},"","-","",0.04,""]
[null,{"$f":"IF(C45>1,\"Area 13\",IF(C45,\"\",\"\"))","v":""},{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D71,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},"","-","",0.04,""]
[null,{"$f":"IF(C46>1,\"Area 14\",IF(C46,\"\",\"\"))","v":""},{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D76,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},"","-","",0.04,""]
[null,{"$f":"IF(C47>1,\"Area 15\",IF(C47,\"\",\"\"))","v":""},{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D81,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},"","-","",0.04,""]
[null,{"$f":"IF(C48>1,\"Area 16\",IF(C48,\"\",\"\"))","v":""},{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D86,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},"","-","",0.04,""]
[null,{"$f":"IF(C49>1,\"Area 17\",IF(C49,\"\",\"\"))","v":""},{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D91,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},"","-","",0.04,""]
[null,{"$f":"IF(C50>1,\"Area 18\",IF(C50,\"\",\"\"))","v":""},{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D96,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},"","-","",0.04,""]
[null,{"$f":"IF(C51>1,\"Area 19\",IF(C51,\"\",\"\"))","v":""},{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D101,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},"","-","",0.04,""]
[null,{"$f":"IF(C52>1,\"Area 20\",IF(C52,\"\",\"\"))","v":""},{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D106,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},"","-","",0.04,""]
[null,{"$f":"IF(C53>1,\"Area 21\",IF(C53,\"\",\"\"))","v":""},{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D111,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},"","-","",0.04,""]
[null,{"$f":"IF(C54>1,\"Area 22\",IF(C54,\"\",\"\"))","v":""},{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D116,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},"","-","",0.04,""]
[null,{"$f":"IF(C55>1,\"Area 23\",IF(C55,\"\",\"\"))","v":""},{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D121,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},"","-","",0.04,""]
[null,{"$f":"IF(C56>1,\"Area 24\",IF(C56,\"\",\"\"))","v":""},{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D126,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},"","-","",0.04,""]
[null,{"$f":"IF(C57>1,\"Area 25\",IF(C57,\"\",\"\"))","v":""},{"$f":"IF($E$22=\"COMCheck\",'As-Built COMcheck'!D131,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},"","-","",0.04,""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,(L33:L57))","v":0},null,"CF",{"$f":"VLOOKUP(D33,L24:M27,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$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.",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(O59)=TRUE,O58,O59)","v":{"$error":"#N/A"}}]
[null,null,"The Incentive application and LPD workbook must be submitted within 60 days of project completion.  Both are required for incentive processing.",null,null,null,null,null,null,null,null,null,null,"Analysis"]
[null,null,"Project Completion is considered occupancy date or final equipment installation date, whichever occurs later.",null,null,null,null,null,null,null,null,null,null,null,"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.",null,null,null,null,null,null,null,null,null,null,"Area 1",{"$f":"E33","v":0},{"$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":""},{"$f":"G33","v":0},{"$f":"IFERROR(ROUND(T63/Q63,2),0)","v":0},{"$f":"IFERROR(ROUND(O63-U63,2),\"\")","v":0},{"$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",null,null,null,null,null,null,null,null,null,null,"Area 2",{"$f":"E34","v":0},{"$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":""},{"$f":"G34","v":0},{"$f":"IFERROR(ROUND(T64/Q64,2),0)","v":0},{"$f":"IFERROR(ROUND(O64-U64,2),\"\")","v":0},{"$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",0.11020000000000001,0.61599999999999999]
[null,null,null,null,null,null,null,null,null,null,"Last Revised:",{"$f":"MAX(RevisionHistory!B5:B41)","v":"2022-07-19"},null,"Area 3",{"$f":"E35","v":0},{"$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":""},{"$f":"G35","v":0},{"$f":"IFERROR(ROUND(T65/Q65,2),0)","v":0},{"$f":"IFERROR(ROUND(O65-U65,2),\"\")","v":0},{"$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",7.7200000000000005E-2,0.51600000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Area 4",{"$f":"E36","v":0},{"$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":""},{"$f":"G36","v":0},{"$f":"IFERROR(ROUND(T66/Q66,2),0)","v":0},{"$f":"IFERROR(ROUND(O66-U66,2),\"\")","v":0},{"$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",0.1462,0.76900000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Area 5",{"$f":"E37","v":0},{"$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":""},{"$f":"G37","v":0},{"$f":"IFERROR(ROUND(T67/Q67,2),0)","v":0},{"$f":"IFERROR(ROUND(O67-U67,2),\"\")","v":0},{"$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}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Area 6",0,0,0,0,"",0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Area 7",0,0,0,0,"",0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Area 8",0,0,0,0,"",0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Area 9",0,0,0,0,"",0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Area 10",0,0,0,0,"",0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Area 11",0,0,0,0,"",0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Area 12",0,0,0,0,"",0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Area 13",0,0,0,0,"",0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Area 14",0,0,0,0,"",0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Area 15",0,0,0,0,"",0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Area 16",0,0,0,0,"",0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Area 17",0,0,0,0,"",0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Area 18",0,0,0,0,"",0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Area 19",0,0,0,0,"",0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Area 20",0,0,0,0,"",0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Area 21",0,0,0,0,"",0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Area 22",0,0,0,0,"",0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Area 23",0,0,0,0,"",0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Area 24",0,0,0,0,"",0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Area 25",0,0,0,0,"",0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Project",{"$f":"SUBTOTAL(9,(R63:R87))","v":0},{"$f":"SUBTOTAL(9,(S63:S87))","v":0},0,0,0,0,0,0,null,null,"EIA 2019 Annual Rates"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUL Source:","2019 Wisconsin TRM (Released January 2019)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Measure Master ID","Measure Master Name","Measure Type",null,"Category","Group","Final Approved EUL","Source"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4336,"LPD ≥20% below code requirements","Hybrid",null,"Light Emitting Diode (LED)","Lighting",15,"Efficiency Vermont TRM March 16, 2015"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4337,"LPD ≥30% below code requirements","Hybrid",null,"Light Emitting Diode (LED)","Lighting",15,"Efficiency Vermont TRM March 16, 2015"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4338,"LPD ≥40% below code requirements","Hybrid",null,"Light Emitting Diode (LED)","Lighting",15,"Efficiency Vermont TRM March 16, 2015"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incentive Rate ($/ft2)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Agriculture",4698,0.67]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sector","HOU","CF","EUL","HOU This Project"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Commercial",3730,0.77,{"$f":"AVERAGE(AH96:AH98)","v":15},{"$f":"C93","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Industrial",4745,0.77]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Agriculture",4698,0.67]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schools & Gov",3239,0.64]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Multifamily - Common Area",5950,0.77]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Multifamily - In Unit",840,5.5E-2]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Default Utility Rates"]

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

{"sheet":"As-Built COMcheck","index":2,"n_rows":176,"n_cols":25,"rows_kept":176,"cut":false,"hidden":true,"merged":[[25,24,25,25],[27,24,27,25],[5,12,7,23],[8,12,9,23],[13,12,17,23],[0,12,0,21],[10,12,11,23],[11,4,12,9],[137,0,171,10],[0,0,5,10],[135,13,136,19]]}
["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",null,null,null,null,null,null,null,null,null,null,null,"Important Reminders for COMcheck Reports"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Must use Energy Code \"2015 IECC\""]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"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)\"",null,null,null,null,null,null,null,"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\"",null,null,null,null,null,null,null,null,null,null,null,"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",null,null,null,null,null,null,null,null,"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)\". ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2015 IECC Lighting Power Density (LPD) Reference Table:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"LIGHTING POWER DENSITY (AREA METHOD) - 2015 IECC"]
["Insert pdf of As-Built COMcheck here:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Automotive Facility",null,null,null,null,null,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Convention Center",null,null,null,null,null,1.01]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Court House",null,null,null,null,null,1.01]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Dining: Bar Lounge/Leisure",null,null,null,null,null,1.01]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Dining: Cafeteria/Fast Food",null,null,null,null,null,0.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Dining: Family",null,null,null,null,null,0.95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Dormitory",null,null,null,null,null,0.56999999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Exercise Center",null,null,null,null,null,0.84]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Fire Station",null,null,null,null,null,0.67]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Free Stall",null,null,null,null,null,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"General Animal Care Area, Utility Room",null,null,null,null,null,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Gymnasium",null,null,null,null,null,0.94]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Healthcare Clinic",null,null,null,null,null,0.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Hospital",null,null,null,null,null,1.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Hotel/Motel",null,null,null,null,null,0.87]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Library",null,null,null,null,null,1.19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Loading and Storage Area, Restroom",null,null,null,null,null,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Manual Wash Sink, Treatment or Surgery Area",null,null,null,null,null,1.19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Manufacturing Facility",null,null,null,null,null,1.17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Motion Picture Theater",null,null,null,null,null,0.76]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Multifamily",null,null,null,null,null,0.51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Museum",null,null,null,null,null,1.02]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Non-Dairy Livestock Housing, Holding Area, Machine Storage",null,null,null,null,null,0.21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Office",null,null,null,null,null,0.82]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Operator's Pit, Office Area at Desk Top, Farm Shop/Repair Area ",null,null,null,null,null,0.82]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Parking Garage",null,null,null,null,null,0.21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Penitentiary",null,null,null,null,null,0.81]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Performing Arts Theater",null,null,null,null,null,1.39]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Police Station",null,null,null,null,null,0.87]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Post Office",null,null,null,null,null,0.87]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Religious Building",null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Retail",null,null,null,null,null,1.26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"School/University",null,null,null,null,null,0.87]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sports Arena",null,null,null,null,null,0.91]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tie Stall Feeding Alley, Milking Parlor, Milk Room",null,null,null,null,null,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Town Hall",null,null,null,null,null,0.89]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Transportation",null,null,null,null,null,0.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Warehouse",null,null,null,null,null,0.66]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Workshop",null,null,null,null,null,1.19]

{"sheet":"Invoices COMcheck","index":3,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"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"]
[]
[]
[]
[]
[]
[]
[]
[]
["Insert invoice(s) here:"]

{"sheet":" Requirements Individual Files","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sq. Ft. Area Individual Files","index":5,"n_rows":155,"n_cols":11,"rows_kept":155,"cut":false,"hidden":true,"merged":[[9,6,11,11],[12,6,16,10],[0,0,6,6]]}
["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"]
[]
[]
[]
[]
[]
[]
[]
["Area 1:"]
[null,null,"Describe Area (ex.: Warehouse, Offices, etc.):",null,null,null,"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:",null,null,null,null,null,"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:",null,null,null,"Example:"]
[null,"Area 3 Sq. Ft.:",null,"The value entered will be verified on the floorplan layout",null,null,null,"Area 1:"]
[null,null,null,null,null,null,null,null,"Area 1 Sq. Ft.:",42412,"The value entered will be verified on the pdf layout"]
["Area 4:",null,null,null,null,null,null,null,null,"Describe Area (ex.: Warehouse, Offices, etc.):","Manufacturing"]
[null,null,"Describe Area:",null,null,null,null,"Area 2:"]
[null,"Area 4 Sq. Ft.:",null,"The value entered will be verified on the floorplan layout",null,null,null,null,null,"Describe Area:","Offices on Floors 1, 2 & 3"]
[null,null,null,null,null,null,null,null,"Area 2 Sq. Ft.:",6620,"The value entered will be verified on the pdf layout"]
["Area 5:",null,null,null,null,null,null,"Area 3:"]
[null,null,"Describe Area:",null,null,null,null,null,null,"Describe Area:","Showroom"]
[null,"Area 5 Sq. Ft.:",null,"The value entered will be verified on the floorplan layout",null,null,null,null,"Area 3 Sq. Ft.:",5625,"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"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Insert pdf(s) here:"]

{"sheet":"Fixture List Individual Files","index":6,"n_rows":1067,"n_cols":19,"rows_kept":1067,"cut":false,"hidden":true,"merged":[[1062,12,1062,15],[179,2,179,3],[9,0,9,4],[10,14,10,18],[0,0,7,9],[11,2,11,3],[177,0,177,4],[51,0,51,4],[93,0,93,4],[135,0,135,4],[53,2,53,3],[95,2,95,3],[137,2,137,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],[1017,0,1017,4],[1019,2,1019,3],[893,2,893,3],[933,0,933,4],[935,2,935,3],[975,0,975,4],[977,2,977,3]]}
["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."]
[]
[]
[]
[]
[]
[]
[]
[]
["Area 1",null,null,null,null,"NLC area factor"]
["Type:",null,null,null,{"$f":"IFERROR(VLOOKUP(B11,Admin_Lists!$A$9:$B$49,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,null,"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},null,null,null,null,null,null,null,null,null,"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",null,null,null,null,"Fixture Mark","Fixture\nName","Fixture\nCount","Fixture Watts","Total\nWatts \n(Fixt Count \nx Fixt Watts)"]
[null,null,null,null,{"$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":""},null,null,null,null,"HB","Lithonia High Bay IBG 240000 LM SEF AFL",4,150,{"$f":"Q14*R14","v":600}]
[null,null,null,null,0,null,null,"","","",null,null,null,null,"SC","Lithonia CLX L96 6000LM SEF RDL ",10,49,490]
[null,null,null,null,0,null,null,"","","",null,null,null,null,"LS4.64","Lithonia Surface Mounted",251,55,13805]
[null,null,null,null,0,null,null,"","","",null,null,null,null,"LS4.47","Lithonia Surface Mounted",359,43,15437]
[null,null,null,null,0,null,null,"","","",null,null,null,null,"LS4.5","Lithonia Surface Mounted",1,43,43]
[null,null,null,null,0,null,null,"","","",null,null,null,null,"LSW4","GE Wall Mounted",2,48,96]
[null,null,null,null,{"$f":"C20*D20","v":0},null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,{"$f":"C36*D36","v":0},null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,{"$f":"D47*C47","v":0},null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E14:E49)","v":0},null,null,{"$f":"SUM(H14:H49)","v":0},{"$f":"SUM(I14:I49)","v":0},0]
[]
["Area 2",null,null,null,null,"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"]
[null,null,null,null,{"$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":""}]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,{"$f":"D62*C62","v":0},null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,{"$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":0},{"$f":"SUM(I56:I91)","v":0},{"$f":"SUM(J56:J91)","v":0}]
[]
["Area 3",null,null,null,null,"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"]
[null,null,null,null,{"$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":""}]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,{"$f":"D104*C104","v":0},null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,{"$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":0},{"$f":"SUM(I98:I133)","v":0},{"$f":"SUM(J98:J133)","v":0}]
[]
["Area 4",null,null,null,null,"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"]
[null,null,null,null,{"$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":""}]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,{"$f":"D146*C146","v":0},null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,{"$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":0},{"$f":"SUM(I140:I175)","v":0},{"$f":"SUM(J140:J175)","v":0}]
[]
["Area 5",null,null,null,null,"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"]
[null,null,null,null,{"$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":""}]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,{"$f":"D188*C188","v":0},null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,{"$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":0},{"$f":"SUM(I182:I217)","v":0},{"$f":"SUM(J182:J217)","v":0}]
[]
["Area 6",null,null,null,null,"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"]
[null,null,null,null,{"$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":""}]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,{"$f":"D257*C257","v":0},null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E224:E259)","v":0},null,null,{"$f":"SUM(H224:H259)","v":0},{"$f":"SUM(I224:I259)","v":0},{"$f":"SUM(J224:J259)","v":0}]
[]
["Area 7",null,null,null,null,"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"]
[null,null,null,null,{"$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":""}]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,{"$f":"D272*C272","v":0},null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E266:E301)","v":0},null,null,{"$f":"SUM(H266:H301)","v":0},{"$f":"SUM(I266:I301)","v":0},{"$f":"SUM(J266:J301)","v":0}]
[]
["Area 8",null,null,null,null,"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"]
[null,null,null,null,{"$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":""}]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,{"$f":"D314*C314","v":0},null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E308:E343)","v":0},null,null,{"$f":"SUM(H308:H343)","v":0},{"$f":"SUM(I308:I343)","v":0},{"$f":"SUM(J308:J343)","v":0}]
[]
["Area 9",null,null,null,null,"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"]
[null,null,null,null,{"$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":""}]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,{"$f":"D356*C356","v":0},null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E350:E385)","v":0},null,null,{"$f":"SUM(H350:H385)","v":0},{"$f":"SUM(I350:I385)","v":0},{"$f":"SUM(J350:J385)","v":0}]
[]
["Area 10",null,null,null,null,"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"]
[null,null,null,null,{"$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":""}]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,{"$f":"D398*C398","v":0},null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E392:E427)","v":0},null,null,{"$f":"SUM(H392:H427)","v":0},{"$f":"SUM(I392:I427)","v":0},{"$f":"SUM(J392:J427)","v":0}]
[]
["Area 11",null,null,null,null,"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"]
[null,null,null,null,{"$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":""}]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,{"$f":"D467*C467","v":0},null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E434:E469)","v":0},null,null,{"$f":"SUM(H434:H469)","v":0},{"$f":"SUM(I434:I469)","v":0},{"$f":"SUM(J434:J469)","v":0}]
[]
["Area 12",null,null,null,null,"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"]
[null,null,null,null,{"$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":""}]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,{"$f":"D482*C482","v":0},null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E476:E511)","v":0},null,null,{"$f":"SUM(H476:H511)","v":0},{"$f":"SUM(I476:I511)","v":0},{"$f":"SUM(J476:J511)","v":0}]
[]
["Area 13",null,null,null,null,"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"]
[null,null,null,null,{"$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":""}]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,{"$f":"D524*C524","v":0},null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E518:E553)","v":0},null,null,{"$f":"SUM(H518:H553)","v":0},{"$f":"SUM(I518:I553)","v":0},{"$f":"SUM(J518:J553)","v":0}]
[]
["Area 14",null,null,null,null,"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"]
[null,null,null,null,{"$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":""}]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,{"$f":"D566*C566","v":0},null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E560:E595)","v":0},null,null,{"$f":"SUM(H560:H595)","v":0},{"$f":"SUM(I560:I595)","v":0},{"$f":"SUM(J560:J595)","v":0}]
[]
["Area 15",null,null,null,null,"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"]
[null,null,null,null,{"$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":""}]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,{"$f":"D608*C608","v":0},null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E602:E637)","v":0},null,null,{"$f":"SUM(H602:H637)","v":0},{"$f":"SUM(I602:I637)","v":0},{"$f":"SUM(J602:J637)","v":0}]
[]
["Area 16",null,null,null,null,"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"]
[null,null,null,null,{"$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":""}]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,{"$f":"D677*C677","v":0},null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E644:E679)","v":0},null,null,{"$f":"SUM(H644:H679)","v":0},{"$f":"SUM(I644:I679)","v":0},{"$f":"SUM(J644:J679)","v":0}]
[]
["Area 17",null,null,null,null,"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"]
[null,null,null,null,{"$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":""}]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,{"$f":"D692*C692","v":0},null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E686:E721)","v":0},null,null,{"$f":"SUM(H686:H721)","v":0},{"$f":"SUM(I686:I721)","v":0},{"$f":"SUM(J686:J721)","v":0}]
[]
["Area 18",null,null,null,null,"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"]
[null,null,null,null,{"$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":""}]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,{"$f":"D734*C734","v":0},null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E728:E763)","v":0},null,null,{"$f":"SUM(H728:H763)","v":0},{"$f":"SUM(I728:I763)","v":0},{"$f":"SUM(J728:J763)","v":0}]
[]
["Area 19",null,null,null,null,"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"]
[null,null,null,null,{"$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":""}]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,{"$f":"D776*C776","v":0},null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E770:E805)","v":0},null,null,{"$f":"SUM(H770:H805)","v":0},{"$f":"SUM(I770:I805)","v":0},{"$f":"SUM(J770:J805)","v":0}]
[]
["Area 20",null,null,null,null,"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"]
[null,null,null,null,{"$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":""}]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,{"$f":"D818*C818","v":0},null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E812:E847)","v":0},null,null,{"$f":"SUM(H812:H847)","v":0},{"$f":"SUM(I812:I847)","v":0},{"$f":"SUM(J812:J847)","v":0}]
[]
["Area 21",null,null,null,null,"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"]
[null,null,null,null,{"$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":""}]
[null,null,null,null,0,null,null,"","",{"$f":"IFERROR(I855*EUL,\"\")","v":""}]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,{"$f":"D887*C887","v":0},null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E854:E889)","v":0},null,null,{"$f":"SUM(H854:H889)","v":0},{"$f":"SUM(I854:I889)","v":0},{"$f":"SUM(J854:J889)","v":0}]
[]
["Area 22",null,null,null,null,"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"]
[null,null,null,null,{"$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":""}]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,{"$f":"D902*C902","v":0},null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E896:E931)","v":0},null,null,{"$f":"SUM(H896:H931)","v":0},{"$f":"SUM(I896:I931)","v":0},{"$f":"SUM(J896:J931)","v":0}]
[]
["Area 23",null,null,null,null,"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"]
[null,null,null,null,{"$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":""}]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,{"$f":"D944*C944","v":0},null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E938:E973)","v":0},null,null,{"$f":"SUM(H938:H973)","v":0},{"$f":"SUM(I938:I973)","v":0},{"$f":"SUM(J938:J973)","v":0}]
[]
["Area 24",null,null,null,null,"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"]
[null,null,null,null,{"$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":""}]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,{"$f":"D986*C986","v":0},null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E980:E1015)","v":0},null,null,{"$f":"SUM(H980:H1015)","v":0},{"$f":"SUM(I980:I1015)","v":0},{"$f":"SUM(J980:J1015)","v":0}]
[]
["Area 25",null,null,null,null,"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"]
[null,null,null,null,{"$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":""}]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,{"$f":"D1028*C1028","v":0},null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,null,null,null,0,null,null,"","",""]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E1022:E1057)","v":0},null,null,{"$f":"SUM(H1022:H1057)","v":0},{"$f":"SUM(I1022:I1057)","v":0},{"$f":"SUM(J1022:J1057)","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Savings"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Peak kW","kWh","Lifecycle","Incentive"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$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":0},{"$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":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"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":1}]

{"sheet":"Wattage Individual Files","index":7,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"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"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Insert file(s) here:"]

{"sheet":"Invoices Individual Files","index":8,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"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"]
[]
[]
[]
[]
[]
[]
[]
[]
["Insert invoice(s) here:"]

{"sheet":"Helpful Tips Individual Files","index":9,"n_rows":35,"n_cols":11,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["Helpful Tips"]
[]
["How to Embed (insert) a PDF File in an Excel Worksheet",null,null,null,null,null,null,null,null,null,"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",null,null,null,null,null,null,null,null,null,"2-4)"]
["3. Select Unhide from menu"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["How to quickly capture a screen shot/snip"]
["1. On a Windows PC press & hold WINDOWS Key + Shift + S",null,null,null,null,null,null,null,null,null,"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":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
[]
[]
["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"]
[2022,"2022-05-20","Removed the 'Get CF button' on the Start Here! tab and added a look up formula for populating the CF for kW savings","Melissa"]
[2022,"2022-05-24","Added conditional formatting to kW savings cell to be 'Red' if value = '0'. This will indicate that a CF Override value needs to be added","Melissa"]
[2022,"2022-06-09","Added error message if total incentive is greater than measure cost","Melissa"]
[2022,"2022-06-28","fixed G33 of Start Here tab, wasn't pulling correct cell","Trish"]
[2022,"2022-07-19","Corrected formula errors on Start Here tab for C37-C57","Melissa"]

{"sheet":"Helpful Tips COMcheck","index":11,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
["Helpful Tips"]
[]
["How to Embed a PDF File in an Excel Worksheet",null,null,null,null,null,null,null,null,null,"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",null,null,null,null,null,null,null,null,null,"2-4)"]
["3. Select Unhide from menu"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"5)"]

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