{"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","Fixt 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":5,"comments":2,"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":73,"n_cols":35,"rows_kept":73,"cut":false,"hidden":false,"merged":[[32,13,32,17],[20,13,20,17],[23,18,24,18],[26,18,27,18],[28,18,29,18],[25,13,25,17],[26,13,27,17],[28,13,29,17],[30,13,30,17],[31,13,31,17],[23,13,24,17],[56,34,56,38],[54,34,54,38],[55,29,55,30],[55,34,55,38],[54,29,54,30],[65,30,69,30],[53,29,53,30],[21,9,21,10],[18,1,18,2],[18,3,18,11],[38,1,39,1],[25,9,25,10],[26,9,26,10],[27,9,27,10],[22,9,22,10],[29,2,29,11],[23,9,23,10],[24,9,24,10],[22,6,22,7],[56,29,56,30],[22,13,22,17],[8,13,8,14],[28,9,28,11],[16,3,16,11],[20,9,20,11],[21,13,21,17],[15,3,15,5],[15,10,15,11],[12,1,12,11],[23,6,24,7],[25,6,27,7],[8,2,8,10],[9,3,9,11],[1,1,1,11],[17,3,17,11],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[15,7,15,8],[13,3,13,11],[14,3,14,11],[5,3,5,11],[7,3,7,11],[2,1,2,11],[3,1,3,2],[4,1,4,10],[6,2,6,10]]}
[]
[null,"\nNew Construction Interior Lighting Power Density (LPD)\nSupplemental 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 from 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 signed by a credentialed lighting designer? ",null,null,null,null,null,null,null,null,null,"Select Yes or No"]
[null,null,null,{"$f":"IF(L5=\"Yes\",\"Select 'COMcheck' from the 'I'm providing the required info via:' drop-down below and proceed\",IF(L5=\"No\",\"Continue to next question\",IF(L5=\"Select Yes or No\",\" \")))","v":" "}]
[null,null,"Was the project overseen by a credentialed lighting designer (see list above)?",null,null,null,null,null,null,null,null,"Select Yes or No"]
[null,null,null,{"$f":"IF(L7=\"Yes\",\"Select 'Individual Files' from the 'I'm providing the required info via:' drop-down below and proceed\",IF(L7=\"No\",\"Continue to next question\",IF(L7=\"Select Yes or No\",\" \")))","v":" "}]
[null,null,"Are ALL fixtures installed either DLC or ENERGY STAR listed?",null,null,null,null,null,null,null,null,"Select Yes or No",null,"SPECTRUM entry:"]
[null,null,null,{"$f":"IF(L9=\"Yes\",\"Select 'Individual Files' from the 'I'm providing the required info via:' drop-down below and proceed\",IF(L9=\"No\",\"Project does not qualify, do not proceed\",IF(L9=\"Select Yes or No\",\" \")))","v":" "},null,null,null,null,null,null,null,null,null,"Unit of Measure Answer",{"$f":"W47","v":0},"net KWh reduced all areas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Units",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Measure Cost",{"$f":"Y47","v":0},"=1.30 * sq. ft or Tech Review override (manual entry)"]
[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,"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":"S47","v":0},"net savings all areas",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,"kW Savings (1st Yr)",{"$f":"W47","v":0},"net savings all areas",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,"kW Savings (Lifecycle)",{"$f":"X47","v":0},"net savings all areas",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,"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":"L37","v":0},"net incentive all areas",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,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,{"$f":"IF(E21=\"Individual Files\",\"Corresponding Tabs:\",IF(E21=\"COMcheck\",\"Corresponding Tabs:\",\"\"))","v":""},null,null,null,null,null,null,"Default Facility Type",null,"HOU","CF","If other than Default HOU, note source"]
[null,null,{"$f":"IF(E21=\"Individual Files\",\"Sq. Ft. Area, Fixt List, Wattage & Invoices\",IF(E21=\"COMcheck\",\"As-Built COMcheck & Invoices\",\"\"))","v":""},null,null,null,"Describe Hours of Use: ",null,null,"Commercial",null,3730,0.77,"COMcheck is 2015 IECC"]
[null,null,null,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,null,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,"Multifamily - Common Area",null,5950,0.77,"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,"Multifamily - In-unit",null,840,5.5E-2]
[null,null,null,null,null,null,null,null,null,"Enter Hours of Use in Column (B) below",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$21=\"COMCheck\",'As-Built COMcheck'!D9,IF($E$21=\"Individual Files\",'Sq. Ft. Area Individual Files'!C11,0))","v":0},null,{"$f":"IF($E$21=\"COMCheck\",'As-Built COMcheck'!D10,IF($E$21=\"Individual Files\",'Fixt List Individual Files'!E11,0))","v":0},null,{"$f":"IF($E$21=\"COMCheck\",'As-Built COMcheck'!D12,IF($E$21=\"Individual Files\",'Fixt List Individual Files'!E50,0))","v":0},{"$f":"IFERROR(ROUND(G32/C32,2),\"\")","v":""},{"$f":"IFERROR(ROUND(E32-H32,2),\"-\")","v":"-"},{"$f":"IFERROR(ROUND(C32*D32*I32/1000,0),\"\")","v":""},0.04,{"$f":"IFERROR(J32*K32,\"\")","v":""},null,"If assumed higher qty installed (due to discrepency) it's been noted"]
[null,{"$f":"IF(C33>1,\"Area 2\",IF(C33,\"\",\"\"))","v":""},{"$f":"IF($E$21=\"COMCheck\",'As-Built COMcheck'!D16,IF($E$21=\"Individual Files\",'Sq. Ft. Area Individual Files'!C15,0))","v":0},null,{"$f":"IF($E$21=\"COMCheck\",'As-Built COMcheck'!D17,IF($E$21=\"Individual Files\",'Fixt List Individual Files'!E53,0))","v":0},null,{"$f":"IF($E$21=\"COMCheck\",'As-Built COMcheck'!D19,IF($E$21=\"Individual Files\",'Fixt List Individual Files'!E92,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 possible, sum measure cost and note \"actual measure cost\""]
[null,{"$f":"IF(C34>1,\"Area 3\",IF(C34,\"\",\"\"))","v":""},{"$f":"IF($E$21=\"COMCheck\",'As-Built COMcheck'!D21,IF($E$21=\"Individual Files\",'Sq. Ft. Area Individual Files'!C19,0))","v":0},null,{"$f":"IF($E$21=\"COMCheck\",'As-Built COMcheck'!D22,IF($E$21=\"Individual Files\",'Fixt List Individual Files'!E95,0))","v":0},null,{"$f":"IF($E$21=\"COMCheck\",'As-Built COMcheck'!D24,IF($E$21=\"Individual Files\",'Fixt List Individual Files'!E134,0))","v":0},"",{"$f":"IFERROR(ROUND(E34-H34,2),\"-\")","v":"-"},"",0.04,""]
[null,{"$f":"IF(C35>1,\"Area 4\",IF(C35,\"\",\"\"))","v":""},{"$f":"IF($E$21=\"COMCheck\",'As-Built COMcheck'!D26,IF($E$21=\"Individual Files\",'Sq. Ft. Area Individual Files'!C23,0))","v":0},null,{"$f":"IF($E$21=\"COMCheck\",'As-Built COMcheck'!D27,IF($E$21=\"Individual Files\",'Fixt List Individual Files'!E137,0))","v":0},null,{"$f":"IF($E$21=\"COMCheck\",'As-Built COMcheck'!D29,IF($E$21=\"Individual Files\",'Fixt List Individual Files'!E176,0))","v":0},"","-","",0.04,""]
[null,{"$f":"IF(C36>1,\"Area 5\",IF(C36,\"\",\"\"))","v":""},{"$f":"IF($E$21=\"COMCheck\",'As-Built COMcheck'!D31,IF($E$21=\"Individual Files\",'Sq. Ft. Area Individual Files'!C27,0))","v":0},null,{"$f":"IF($E$21=\"COMCheck\",'As-Built COMcheck'!D32,IF($E$21=\"Individual Files\",'Fixt List Individual Files'!E179,0))","v":0},null,{"$f":"IF($E$21=\"COMCheck\",'As-Built COMcheck'!D34,IF($E$21=\"Individual Files\",'Fixt List Individual Files'!E218,0))","v":0},"","-","",0.04,""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L32:L36)","v":0},null,"CF",{"$f":"IF(OR(D32=8760,D33=8760,D34=8760,D35=8760,D36=8760),1,_xlfn.IFS(D32=L23,VLOOKUP(D32,L23:M28,2,FALSE),D32=L24,VLOOKUP(D32,L23:M28,2,FALSE),D32=L25,VLOOKUP(D32,L23:M28,2,FALSE),D32=L26,VLOOKUP(D32,L23:M28,2,FALSE),D32=L27,VLOOKUP(D32,L23:M28,2,FALSE),D32=L28,VLOOKUP(D32,L23:M28,2,FALSE),D32=8760,1, D33=L23,VLOOKUP(D33,L23:M28,2,FALSE),D33=L24,VLOOKUP(D33,L23:M28,2,FALSE),D33=L25,VLOOKUP(D33,L23:M28,2,FALSE),D33=L26,VLOOKUP(D33,L23:M28,2,FALSE),D33=L27,VLOOKUP(D33,L23:M28,2,FALSE),D33=L28,VLOOKUP(D33,L23:M28,2,FALSE), D33=8760,1,D34=L23,VLOOKUP(D34,L23:M28,2,FALSE),D34=L24,VLOOKUP(D34,L23:M28,2,FALSE),D34=L25,VLOOKUP(D34,L23:M28,2,FALSE),D34=L26,VLOOKUP(D34,L23:M28,2,FALSE),D34=L27,VLOOKUP(D34,L23:M28,2,FALSE),D34=L28,VLOOKUP(D34,L23:M28,2,FALSE),D34=8760,1, D35=L23,VLOOKUP(D35,L23:M28,2,FALSE),D35=L24,VLOOKUP(D35,L23:M28,2,FALSE),D35=L25,VLOOKUP(D35,L23:M28,2,FALSE),D35=L26,VLOOKUP(D35,L23:M28,2,FALSE),D35=L27,VLOOKUP(D35,L23:M28,2,FALSE),D35=L28,VLOOKUP(D35,L23:M28,2,FALSE), D35=8760,1, D36=L23,VLOOKUP(D36,L23:M28,2,FALSE),D36=L24,VLOOKUP(D36,L23:M28,2,FALSE),D36=L25,VLOOKUP(D36,L23:M28,2,FALSE),D36=L26,VLOOKUP(D36,L23:M28,2,FALSE),D36=L27,VLOOKUP(D36,L23:M28,2,FALSE),D36=L28,VLOOKUP(D36,L23:M28,2,FALSE),D36=8760,1,TRUE,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L37>24999.99,\"Post Inspection Required. Focus on Energy will contact to schedule.\",IF(L37<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(O38)=TRUE,O37,O38)","v":""}]
[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":"E32","v":0},{"$f":"D32","v":0},{"$f":"C32","v":0},{"$f":"IFERROR(ROUND(O42*Q42,0),\"\")","v":0},{"$f":"IFERROR(IF(OR(O42=\"\",O42=\"Error\",G32=\"\"),\"\",ROUND(V42*C32/1000*$O$39,4)),\"\")","v":""},{"$f":"G32","v":0},{"$f":"IFERROR(ROUND(T42/Q42,2),0)","v":0},{"$f":"IFERROR(ROUND(O42-U42,2),\"\")","v":0},{"$f":"IFERROR(ROUND(P42*Q42*V42/1000,0),\"\")","v":0},{"$f":"IFERROR(W42*$AE$66,\"\")","v":0},{"$f":"ROUND(Q42*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":"E33","v":0},{"$f":"D33","v":0},{"$f":"C33","v":0},{"$f":"IFERROR(ROUND(O43*Q43,0),\"\")","v":0},{"$f":"IFERROR(IF(OR(O43=\"\",O43=\"Error\",G33=\"\"),\"\",ROUND(V43*C33/1000*$O$39,4)),\"\")","v":""},{"$f":"G33","v":0},{"$f":"IFERROR(ROUND(T43/Q43,2),0)","v":0},{"$f":"IFERROR(ROUND(O43-U43,2),\"\")","v":0},{"$f":"IFERROR(ROUND(P43*Q43*V43/1000,0),\"\")","v":0},{"$f":"IFERROR(W43*$AE$66,\"\")","v":0},{"$f":"ROUND(Q43*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":"2021-05-17"},null,"Area 3",{"$f":"E34","v":0},{"$f":"D34","v":0},{"$f":"C34","v":0},0,{"$f":"IFERROR(IF(OR(O44=\"\",O44=\"Error\",G34=\"\"),\"\",ROUND(V44*C34/1000*$O$39,4)),\"\")","v":""},{"$f":"G34","v":0},{"$f":"IFERROR(ROUND(T44/Q44,2),0)","v":0},{"$f":"IFERROR(ROUND(O44-U44,2),\"\")","v":0},{"$f":"IFERROR(ROUND(P44*Q44*V44/1000,0),\"\")","v":0},0,{"$f":"ROUND(Q44*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":"E35","v":0},{"$f":"D35","v":0},{"$f":"C35","v":0},0,{"$f":"IFERROR(IF(OR(O45=\"\",O45=\"Error\",G35=\"\"),\"\",ROUND(V45*C35/1000*$O$39,4)),\"\")","v":""},{"$f":"G35","v":0},{"$f":"IFERROR(ROUND(T45/Q45,2),0)","v":0},{"$f":"IFERROR(ROUND(O45-U45,2),\"\")","v":0},{"$f":"IFERROR(ROUND(P45*Q45*V45/1000,0),\"\")","v":0},0,{"$f":"ROUND(Q45*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":"E36","v":0},{"$f":"D36","v":0},{"$f":"C36","v":0},0,{"$f":"IFERROR(IF(OR(O46=\"\",O46=\"Error\",G36=\"\"),\"\",ROUND(V46*C36/1000*$O$39,4)),\"\")","v":""},{"$f":"G36","v":0},{"$f":"IFERROR(ROUND(T46/Q46,2),0)","v":0},{"$f":"IFERROR(ROUND(O46-U46,2),\"\")","v":0},{"$f":"IFERROR(ROUND(P46*Q46*V46/1000,0),\"\")","v":0},0,{"$f":"ROUND(Q46*1.3,2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Project",{"$f":"SUM(R42:R46)","v":0},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(AH55:AH57)","v":15},{"$f":"C52","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":76,"n_cols":25,"rows_kept":76,"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],[37,0,71,10],[0,0,5,10],[35,13,36,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",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":32,"n_cols":11,"rows_kept":32,"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"]
[]
[]
[]
[]
["Insert pdf(s) here:"]

{"sheet":"Fixt List Individual Files","index":6,"n_rows":218,"n_cols":11,"rows_kept":218,"cut":false,"hidden":true,"merged":[[179,2,179,3],[9,0,9,4],[10,6,10,10],[0,0,7,10],[23,6,24,12],[11,2,11,3],[25,6,30,11],[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]]}
["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\n    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"]
[]
[]
[]
[]
[]
[]
[]
[]
["Area 1"]
["Type:","Choose from Drop-down",null,null,{"$f":"IFERROR(VLOOKUP(B11,Admin_Lists!$A$9:$B$49,2,FALSE),\"\")","v":0},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,"Type:","Warehouse",null,null,0.66]
["Fixture Mark","Fixture\nName","Fixture\nCount","Fixture Watts","Total\nWatts \n(Fixt Count \nx Fixt Watts)",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,"HB","Lithonia High Bay IBG 240000 LM SEF AFL",4,150,{"$f":"I14*J14","v":600}]
[null,null,null,null,0,null,"SC","Lithonia CLX L96 6000LM SEF RDL ",10,49,490]
[null,null,null,null,0,null,"LS4.64","Lithonia Surface Mounted",251,55,13805]
[null,null,null,null,0,null,"LS4.47","Lithonia Surface Mounted",359,43,15437]
[null,null,null,null,0,null,"LS4.5","Lithonia Surface Mounted",1,43,43]
[null,null,null,null,0,null,"LSW4","GE Wall Mounted",2,48,96]
[null,null,null,null,{"$f":"D20*C20","v":0}]
[null,null,null,null,0,null,null,"Total System Wattage",null,null,{"$f":"SUM(K14:K20)","v":30471}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0,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,null,null,null,0]
[null,null,null,null,0,null,"1. Choose Area Type(s) best describing the use of that space in the facility\n     If \"Other-Identify\" is chosen, note on Start Here! Tab in Project Notes\n         The LPD calculation/incentive will be calculated upon review\n2. Include fixtures installed in each Area Type"]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E14:E49)","v":0}]
[]
["Area 2"]
["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)"]
[null,null,null,null,{"$f":"C56*D56","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,{"$f":"D62*C62","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,{"$f":"D91*C91","v":0}]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E56:E91)","v":0}]
[]
["Area 3"]
["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)"]
[null,null,null,null,{"$f":"C98*D98","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,{"$f":"D104*C104","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,{"$f":"D133*C133","v":0}]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E98:E133)","v":0}]
[]
["Area 4"]
["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)"]
[null,null,null,null,{"$f":"C140*D140","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,{"$f":"D146*C146","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,{"$f":"D175*C175","v":0}]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E140:E175)","v":0}]
[]
["Area 5"]
["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)"]
[null,null,null,null,{"$f":"C182*D182","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,{"$f":"D188*C188","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,{"$f":"D217*C217","v":0}]
[null,"Total System Wattage This Area",null,null,{"$f":"SUM(E182:E217)","v":0}]

{"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":14,"n_cols":4,"rows_kept":14,"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","added additional credentialed lighting professionals to list on Start Here tab, and updated the pictures of catalog pg. on the Requirements tabs (Ind. Files + COMcheck)","Trish"]

{"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!'!G26","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]
[null,null,null,null,null,null,null,"Lobby - locker room",null,null,null,null,0.75]
[null,null,null,null,null,null,null,"Lobby - otherwise",null,null,null,null,0.9]
[null,null,null,null,null,null,null,"Lounge/breakroom - in a healthcare facility",null,null,null,null,0.92]
[null,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,null,null,null,null,null,null,"Manufacturing facility - in an equipment room",null,null,null,null,0.74]
[null,null,null,null,null,null,null,"Manufacturing facility - in an extra high bay area ( > 50' floor-to-ceiling height)",null,null,null,null,1.05]
[null,null,null,null,null,null,null,"Museum - in a general exhibition area",null,null,null,null,1.05]
[null,null,null,null,null,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]
[null,null,null,null,null,null,null,"Parking area, interior",null,null,null,null,0.19]
[null,null,null,null,null,null,null,"Performance arts theatre - dressing room",null,null,null,null,0.61]
[null,null,null,null,null,null,null,"Pharmacy area",null,null,null,null,1.68]
[null,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]
[null,null,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]
[null,null,null,null,null,null,null,"Sales area",null,null,null,null,1.59]
[null,null,null,null,null,null,null,"Seating area, general",null,null,null,null,0.54]
[null,null,null,null,null,null,null,"Sports area - for a Class I facility",null,null,null,null,3.68]
[null,null,null,null,null,null,null,"Sports area - for a Class II facility ",null,null,null,null,2.4]
[null,null,null,null,null,null,null,"Sports area - for a Class III facility",null,null,null,null,1.8]
[null,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]