{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Application","Calculations","Lighting Layouts","QPL_Spec Sheets","Proposal_Optional","Savings and Incentives","Revision History"],"not_rendered":{"images":7,"macros":1,"external_links":3,"defined_names":40,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Application","index":0,"n_rows":64,"n_cols":13,"rows_kept":64,"merged":[[0,0,3,8],[0,9,3,13],[5,0,8,7],[10,0,10,2],[10,8,10,10],[12,0,12,3],[12,8,12,12],[13,0,15,6],[14,8,14,9],[14,10,14,12],[16,0,16,3],[16,4,16,6],[16,8,16,12],[17,4,17,6],[18,8,18,12],[20,8,20,10],[23,8,23,10],[24,1,24,5],[26,0,26,5],[28,0,28,5],[30,0,30,5],[30,11,30,12],[32,0,32,3],[32,9,32,10],[33,9,33,10],[33,11,33,12],[34,0,34,5],[34,8,34,12],[36,4,36,5],[36,8,36,12],[37,0,37,2],[38,8,38,10],[40,0,40,5],[40,8,40,12],[42,0,42,3],[42,4,42,5],[42,8,42,10],[44,0,44,3],[44,4,44,5],[45,8,45,10],[46,8,48,12],[49,0,49,5],[50,8,50,12],[51,0,51,3],[52,8,52,10],[54,0,54,2],[54,8,54,9],[54,11,54,12],[55,11,55,12],[56,0,56,5],[56,11,56,12],[57,9,57,11],[58,0,58,1],[58,2,58,5],[58,8,58,9],[59,8,59,9],[59,10,59,12]]}
["HORTICULTURAL LIGHTING SOLUTION APPLICATION                                                                                                        FOR PROJECTS COMPLETED BY 12/31/2026",{"$nulls":8},"Note: this workbook needs to be used in the full version of Excel. Some features won't work in Excel Online."]
[]
[]
[]
[]
["COMPLETE ALL SECTIONS. INCOMPLETE APPLICATIONS CANNOT BE PROCESSED AND WILL DELAY PAYMENT OF INCENTIVES. APPLICATIONS MUST BE SUBMITTED WITHIN 60 DAYS OF COMPLETED PROJECT INSTALLATION, NO LATER THAN JANUARY 31, 2027. FOR ADDITIONAL COPIES OF THIS FORM, VISIT FOCUSONENERGY.COM/CATALOGS."]
[]
[]
[]
[]
["section 1",{"$nulls":7},"section 4"]
["ACCOUNT AND CUSTOMER INFORMATION",{"$nulls":7},"TRADE ALLY INFORMATION"]
["TAX IDENTIFICATION NUMBER (Check one.) ",{"$nulls":3},"       FEIN     or","           SSN"]
["IF YOU USE A SOCIAL SECURITY NUMBER (SSN) AS YOUR TAX IDENTIFICATION NUMBER, DO NOT PROVIDE IT BELOW. YOU WILL BE CONTACTED BY THE PROGRAM VIA E-MAIL TO PROVIDE A COPY OF YOUR W-9 USING A SECURE ONLINE PORTAL, IF IT IS NOT ALREADY ON FILE. YOU MUST LIST",{"$nulls":7},"TRADE ALLY CONTACT NAME"]
[]
[{"$nulls":8},"PRIMARY PHONE #",null,"E-MAIL ADDRESS"]
["AN E-MAIL ADDRESS IN SECTION 3. "]
[{"$nulls":4},"FEIN",{"$nulls":3},"TRADE ALLY COMPANY NAME"]
["TAX CLASSIFICATION OF CUSTOMER"]
["(Check one. Required for all businesses, including non-profits.)",{"$nulls":7},"ADDRESS"]
["Sole Proprietorship",null,"Individual",null,"Single Member - LLC"]
["C Corporation",null,"S Corporation",null,"Partnership",{"$nulls":3},"CITY",null,null,"STATE","ZIP"]
["Limited Liability Company - C Corp",{"$nulls":3},"Limited Liability Company - S Corp"]
["Limited Liability Company - Partnership",{"$nulls":7},"section 5"]
["Other:",{"$nulls":7},"BUSINESS PAYMENT INFORMATION"]
[{"$nulls":8},"Payee is responsible for any associated tax consequences."]
[{"$nulls":8},"Make incentive check payable to:"]
["OWNER NAME (REQUIRED IF SSN IS USED AS TAX IDENTIFICATION NUMBER)",{"$nulls":7},"        Customer","              Trade Ally","Other Payee"]
[{"$nulls":8},"If Other Payee is selected, the relationship to the utility account holder"]
["COMPANY NAME",{"$nulls":7},"must be identified below:"]
[{"$nulls":8},"        Tenant","       Building Owner","  Other (specify)"]
["LEGAL ADDRESS (AS SHOWN ON COMPANY W-9)",{"$nulls":7},"For All Payees this Seciton MUST be Filled Out"]
[{"$nulls":8},"Mail check to:","          Customer Legal Address",null,"Job Site Address"]
["CITY",{"$nulls":3},"STATE","ZIP",{"$nulls":3},"           Trade Ally Address",null,"Alternate Address"]
[]
["WHO DID YOU WORK WITH FROM FOCUS ON ENERGY? (CONTACT NAME)",{"$nulls":7},"COMPANY NAME"]
[]
["section 2",{"$nulls":7},"LEGAL ADDRESS (AS SHOWN ON COMPANY W-9)"]
["JOB SITE INFORMATION"]
["(Refer to your utility bills for account numbers below.)",{"$nulls":7},"CITY",null,null,"STATE","ZIP"]
[]
["JOB SITE BUSINESS NAME",{"$nulls":7},"ATTENTION TO (OPTIONAL)"]
[{"$nulls":8},"For Trade Ally and Other Payees"]
["ELECTRIC UTILITY AT JOB SITE",{"$nulls":3},"ELECTRIC ACCOUNT #",{"$nulls":3},"Trade Allies must be registered with the Program to receive payment."]
["N/A",{"$nulls":3},"N/A",{"$nulls":3},"All other payees must have a current W-9 on file to receive payment."]
["GAS UTILITY AT JOB SITE",{"$nulls":3},"GAS ACCOUNT #",{"$nulls":3},"TAX IDENTIFICATION NUMBER   (Check one.) ",null,null,"  FEIN        or","       SSN"]
["Job Site Address is same as Legal Address",{"$nulls":7},"If you use a Social Security Number (SSN) as your TAX Identification Number, do not provide it below. You will be contacted by the Program via email to provide a copy of your W-9 using a secure online portal, if it is not already on file. You must list an email address below."]
["Job Site Address is different (complete below.)"]
[]
[]
["JOB SITE ADDRESS"]
[{"$nulls":8},"FEIN"]
["CITY",{"$nulls":3},"STATE","ZIP",null,null,"Tax Classification of Payee"]
[{"$nulls":8},"(Check one. Required for all businesses, including non-profits.)"]
["section 3",{"$nulls":7},"         Sole Proprietorship",null,"   Individual","          Single-Member LLC"]
["CUSTOMER CONTACT INFORMATION",{"$nulls":7},"          C Corporation",null,"   S Corporation","               Partnership"]
[{"$nulls":8},"  LLC - C Corp",null,"   LLC - S Corp","               LLC - Partnership"]
["JOB SITE CUSTOMER CONTACT NAME",{"$nulls":7},"         Other"]
[{"$nulls":8},"Payee Contact Information"]
["PRIMARY PHONE #",null,"E-MAIL ADDRESS"]
[{"$nulls":8},"NAME",null,"EMAIL ADDRESS"]
["Preferred method of contact:",null,"Call","           E-mail","        Text"]
["If Focus on Energy has a question about this application, we should contact:"]
["         Customer","         Trade Ally","Other"]

{"sheet":"Calculations","index":1,"n_rows":89,"n_cols":7,"rows_kept":89,"merged":[[9,0,9,2],[9,4,9,6],[10,0,15,2],[10,4,15,6],[17,0,17,2],[17,4,17,6],[57,0,57,1],[72,4,72,5],[73,0,73,3],[88,2,88,3]]}
["Insert/Embed both Baseline and Energy Efficient LED Energy Usage Calculations if template below is not used."]
[]
[null,"Notes and requirements for calculations:"]
[null,"• All savings calculations are treated as confidential and will not be shared outside of Focus on Energy"]
[null,"• Formulas used in savings calculations need to be viewable to Focus on Energy review team"]
[null,"• Calculations must show or describe how the hours of use are derived for both baseline and energy efficient designs"]
[null,"• Baseline design must be practical and a viable option to the customer that uses the same Photosynthetic Photon Flux Density (PPFD) as the energy efficient LED design"]
[null,"• Calculations will need to output the Annual Electrical Usage (kWh), Electrical Demand (kW), and Cost for both the baseline and the energy efficient design. These are input on the \"Savings and Incentives\" tab."]
[]
["Summer Peak kW and Coincidence Factor Definition:",{"$nulls":3},"Winter Peak kW and Coincidence Factor Definition:"]
["Summer peak kW is determined by the average kW load occuring between 2 pm and 6 pm on weekdays during June, July, August, and September. To calculate the summer peak kW, determine the percentage of the hours during the peak timeframe the lights will be in use. If we use 4 months and an average of 21 days/month and 4 hours/day, there are a total possible 336 summer peak hours. If lights are on during the entire 2pm - 6pm range, the total hours on would = 336, and 336 / 336 = 1.0 which would be the summer coincidence factor.",{"$nulls":3},"Winter peak kW is determined by the average kW load occuring between 8 am - Noon and 5 pm - 9 pm during non-holiday weekdays in the months of December, January, and February. To calculate the winter peak kW, determine the percentage of the hours during the peak timeframe the lights will be in use. If we use 3 months and an average of 21 days/month and 8 hours/day, there are a total possible 504 winter peak hours. If lights are only on during the 8 am - Noon hours within that range, the total hours on would = 252, and 252 / 504 = 0.5 which woudl be the winter coincidence factor."]
[]
[]
[]
[]
[]
[]
["Supplemented Greenhouse - AG5033",{"$nulls":3},"Single Tier Indoor Farm - AG5032"]
[null,"Baseline Example","Baseline ",null,null,"Baseline Example","Baseline"]
["Description","Double Ended 1000W High Pressure Sodium",null,null,"Description","Double Ended 1000W High Pressure Sodium"]
["# of Fixtures",242,null,null,"# of Fixtures",242]
["Fixture Wattage",{"v":1079,"d":"1,079"},null,null,"Fixture Wattage",{"v":1079,"d":"1,079"}]
["Annual Operating Hours",{"v":3641,"d":"3,641"},null,null,"Annual Operating Hours",{"v":3641,"d":"3,641"}]
["kW Usage",{"$f":"ROUND(B21*B22/1000,4)","v":{"v":261.118,"d":"261.12"}},{"$f":"ROUND(C21*C22/1000,4)","v":{"v":0,"d":"0.00"}},null,"kW Usage",{"$f":"ROUND(F21*F22/1000,4)","v":{"v":261.118,"d":"261.12"}},{"$f":"ROUND(G21*G22/1000,4)","v":{"v":0,"d":"0.00"}}]
["Coincidence Factor: Summer kW",{"v":0,"d":"0.00"},null,null,"Coincidence Factor: Summer kW",{"v":1,"d":"1.00"}]
["Summer kW Demand",{"$f":"B24*B25","v":{"v":0,"d":"0.00"}},{"$f":"C24*C25","v":{"v":0,"d":"0.00"}},null,"Summer kW Demand",{"$f":"F24*F25","v":{"v":261.118,"d":"261.12"}},{"$f":"G24*G25","v":{"v":0,"d":"0.00"}}]
["Coincidence Factor: Winter kW",0.25,null,null,"Coincidence Factor: Winter kW",{"v":0.5,"d":"0.50"}]
["Winter kW Demand",{"$f":"B24*B27","v":{"v":65.2795,"d":"65.28"}},{"$f":"C24*C27","v":{"v":0,"d":"0.00"}},null," Winter kW Demand",{"$f":"F24*F27","v":{"v":130.559,"d":"130.56"}},{"$f":"G24*G27","v":{"v":0,"d":"0.00"}}]
["Annual kWh Usage",{"$f":"ROUND(B24*B23,0)","v":{"v":950731,"d":"950,731"}},{"$f":"ROUND(C24*C23,0)","v":0},null,"Annual kWh Usage",{"$f":"ROUND(F24*F23,0)","v":{"v":950731,"d":"950,731"}},{"$f":"ROUND(G24*G23,0)","v":0}]
["Customer blended $/kWh Rate",{"v":0.1287,"d":"$0.13"},{"v":0.1287,"d":"$0.13"},null,"Customer blended $/kWh Rate",{"v":0.1287,"d":"$0.13"},{"v":0.1287,"d":"$0.13"}]
["Project Cost",{"v":154250,"d":"$154,250.00"},null,null,"Project Cost",{"v":154250,"d":"$154,250.00"}]
[]
[null,"Proposed Energy Efficient LED Example","Proposed Energy Efficient LED",null,null,"Proposed Energy Efficient LED Example","Proposed Energy Efficient LED"]
["Description","List Make and Model of the LED fixtures",null,null,"Description","List Make and Model of the LED fixtures"]
["# of Fixtures",220,null,null,"# of Fixtures",220]
["Fixture Wattage",654,null,null,"Fixture Wattage",654]
["Proposed Annual Electrical Usage Without Controls (kWh)",{"$f":"((B35*B36)/1000)*B23","v":{"v":523867.07999999996,"d":"523,867"}},{"$f":"((C35*C36)/1000)*C23","v":0},null,"Proposed Annual Electrical Usage Without Controls (kWh)",{"$f":"((F35*F36)/1000)*F23","v":{"v":523867.07999999996,"d":"523,867"}},{"$f":"((G35*G36)/1000)*G23","v":0}]
["Use of Controls?","Yes",null,null,"Use of Controls?","Yes"]
["Control Type","Dimming",null,null,"Control Type","Dimming"]
["Lighting Control Savings Factor",{"v":0.15,"d":"15%"},null,null,"Lighting Control Savings Factor",{"v":0.15,"d":"15%"}]
["Annual Operating Hours",{"$f":"IFERROR(IF(B38=\"no\",B23,B23*(1-B40)),\"\")","v":{"v":3094.85,"d":"3,095"}},{"$f":"IFERROR(IF(C38=\"no\",C23,C23*(1-C40)),\"\")","v":0},null,"Annual Operating Hours",{"$f":"IFERROR(IF(F38=\"no\",F23,F23*(1-F40)),\"\")","v":{"v":3094.85,"d":"3,095"}},{"$f":"IFERROR(IF(G38=\"no\",G23,G23*(1-G40)),\"\")","v":0}]
["Proposed kW Usage",{"$f":"ROUND(B35*B36/1000,2)","v":143.88},{"$f":"ROUND(C35*C36/1000,2)","v":{"v":0,"d":"0.00"}},null,"Proposed kW Usage",{"$f":"ROUND(F35*F36/1000,2)","v":143.88},{"$f":"ROUND(G35*G36/1000,2)","v":{"v":0,"d":"0.00"}}]
["Coincidence Factor: Summer kW",{"v":0,"d":"0.00"},null,null,"Coincidence Factor: Summer kW",{"v":1,"d":"1.00"}]
["Proposed Summer kW Demand",{"$f":"B42*B43","v":{"v":0,"d":"0.00"}},{"$f":"C42*C43","v":{"v":0,"d":"0.00"}},null,"Proposed Summer kW Demand",{"$f":"F42*F43","v":143.88},{"$f":"G42*G43","v":{"v":0,"d":"0.00"}}]
["Coincidence Factor: Winter kW",0.25,null,null,"Coincidence Factor: Winter kW",{"v":0.5,"d":"0.50"}]
["Proposed Winter kW Demand",{"$f":"B42*B45","v":35.97},{"$f":"C42*C45","v":{"v":0,"d":"0.00"}},null,"Proposed Winter kW Demand",{"$f":"F42*F45","v":71.94},{"$f":"G42*G45","v":{"v":0,"d":"0.00"}}]
["Proposed Annual Electrical Usage Without Controls",{"$f":"B35*(B36/1000)*B23","v":{"v":523867.07999999996,"d":"523,867"}},{"$f":"C35*(C36/1000)*C23","v":0},null,"Proposed Annual Electrical Usage Without Controls",{"$f":"F35*(F36/1000)*F23","v":{"v":523867.07999999996,"d":"523,867"}},{"$f":"G35*(G36/1000)*G23","v":0}]
["Proposed Annual Electrical Usage With Controls",{"$f":"B35*(B36/1000)*B41","v":{"v":445287.018,"d":"445,287"}},{"$f":"C35*(C36/1000)*C41","v":0},null,"Proposed Annual Electrical Usage With Controls",{"$f":"F35*(F36/1000)*F41","v":{"v":445287.018,"d":"445,287"}},{"$f":"G35*(G36/1000)*G41","v":0}]
["Project Cost",{"v":324150,"d":"$324,150.00"},null,null,"Project Cost",{"v":324150,"d":"$324,150.00"}]
[]
["ESTIMATED SAVINGS","Example","Actual Savings",null,"ESTIMATED SAVINGS","Example","Actual Savings"]
["Summer Peak kW Saved","NA for Greenhouses",{"$f":"C26-C44","v":{"v":0,"d":"0.00"}},null,"Summer Peak kW Saved",{"$f":"F24-F44","v":{"v":117.238,"d":"117.24"}},{"$f":"G26-G44","v":{"v":0,"d":"0.00"}}]
["Winter Peak kW Saved",{"$f":"B28-B46","v":{"v":29.3095,"d":"29.31"}},{"$f":"C28-C46","v":{"v":0,"d":"0.00"}},null,"Winter Peak kW Saved",{"$f":"F24-F46","v":{"v":189.178,"d":"189.18"}},{"$f":"G28-G46","v":{"v":0,"d":"0.00"}}]
["Annual Electrical Usage Without Controls",{"$f":"B29-B47","v":{"v":426863.92000000004,"d":"426,864"}},{"$f":"C29-C47","v":0},null,"Annual Electrical Usage Without Controls",{"$f":"F29-F47","v":{"v":426863.92000000004,"d":"426,864"}},{"$f":"G29-G47","v":0}]
["Annual Electrical Savings With Controls",{"$f":"B29-B48","v":{"v":505443.982,"d":"505,444"}},{"$f":"C29-C48","v":0},null,"Annual Electrical Savings With Controls",{"$f":"F29-F48","v":{"v":505443.982,"d":"505,444"}},{"$f":"G29-G48","v":0}]
[]
["These are examples only, the number of lighting hours will need to be calculated for each project individually."]
["Estimated Supplemented Greenhouse  Lighting Hours - SAMPLE CALC"]
["Month","Avg.Daily Direct Solar Radiation","% cloud cover","Supplemental Light Est. Hours","Days","Total Hrs. Grow Lights On"]
["January",12.3,{"v":0.46,"d":"46%"},{"v":18,"d":"18.0"},31,{"$f":"D60*E60","v":558}]
["February",15,{"v":0.56,"d":"56%"},{"v":16,"d":"16.0"},28,448]
["March",16.1,{"v":0.67,"d":"67%"},{"v":12,"d":"12.0"},31,372]
["April",17,{"v":0.71,"d":"71%"},{"v":10,"d":"10.0"},30,300]
["May",18.5,{"v":0.73,"d":"73%"},7.5,31,{"v":232.5,"d":"233"}]
["June",20.7,{"v":0.74,"d":"74%"},{"v":5,"d":"5.0"},30,150]
["July",21.7,{"v":0.72,"d":"72%"},{"v":3,"d":"3.0"},31,93]
["August",19.3,{"v":0.62,"d":"62%"},{"v":0,"d":"0.0"},31,0]
["September",17.5,{"v":0.53,"d":"53%"},{"v":0,"d":"0.0"},30,0]
["October",14.2,{"v":0.52,"d":"52%"},{"v":14,"d":"14.0"},31,434]
["November",10.8,{"v":0.44,"d":"44%"},16.5,30,495]
["December",11,{"v":0.43,"d":"43%"},{"v":18,"d":"18.0"},31,558]
[null,16.2,{"$nulls":3},{"$f":"SUM(F60:F71)","v":{"v":3640.5,"d":"3,641"}}]
[{"$nulls":4},"Default value for Supplemented Greenhouse is 2,120 hours"]
["Estimated Single Tier - Indoor Farm Lighting Hours - SAMPLE CALC"]
["Month","Est. Lighting Hours","Days","Total Hrs. Grow Lights On"]
["January",{"v":0,"d":"0.0"},0,{"$f":"B76*C76","v":0}]
["February",{"v":0,"d":"0.0"},0,0]
["March",{"v":16,"d":"16.0"},25,400]
["April",{"v":16,"d":"16.0"},30,480]
["May",{"v":16,"d":"16.0"},31,496]
["June",{"v":16,"d":"16.0"},30,480]
["July",{"v":16,"d":"16.0"},31,496]
["August",{"v":16,"d":"16.0"},31,496]
["September",{"v":16,"d":"16.0"},30,480]
["October",{"v":13.05,"d":"13.1"},24,{"v":313.20000000000005,"d":"313"}]
["November",{"v":0,"d":"0.0"},0,0]
["December",{"v":0,"d":"0.0"},0,0]
[{"$nulls":3},{"$f":"SUM(D76:D87)","v":{"v":3641.2,"d":"3,641"}}]
[null,null,"Default value for Indoor is 5,475 hours"]

{"sheet":"Lighting Layouts","index":2,"n_rows":26,"n_cols":18,"rows_kept":26,"merged":[[3,1,8,2],[3,4,8,5],[9,1,10,2],[9,4,10,5]]}
["Insert/Embed both Baseline and Energy Efficient LED Layout Designs"]
[{"$nulls":8},"How to Embed a PDF File in an Excel Worksheet"]
[{"$nulls":8},"1. Go to Insert tab and click on the Object icon in the Text group. ..."]
[{"$nulls":8},"2. In the Object dialog box, select the 'Create New' tab and the select 'Adobe Acrobat Document' from the list. ..."]
[{"$nulls":8},"3. Check the option – 'Display as icon'."]
[{"$nulls":8},"4. If desired, select \"Change Icon\" to modify the file name displayed (ex: Baseline Design, EE Design, etc.).  "]
[{"$nulls":8},"5. Click OK."]
[{"$nulls":8},"6. Select the PDF file to embed and click on Open."]
[]
[null,"Baseline Design     Layout",null,null,"Energy Efficient Design Layout",{"$nulls":3},"1)",{"$nulls":8},"2 - 5)"]
{"$rows_empty":15}
[{"$nulls":17},"6)"]

{"sheet":"QPL_Spec Sheets","index":3,"n_rows":26,"n_cols":26,"rows_kept":26}
["Insert/Embed Energy Efficient LED DLC QPL or Spec Sheets"]
[{"$nulls":16},"How to Embed a PDF File in an Excel Worksheet"]
[null,"New fixtures must be DLC listed in the Horticultural Lighting category or meet the following requirements:",{"$nulls":14},"1. Go to Insert tab and click on the Object icon in the Text group. ..."]
[null,"• Photosynthetic Photon Efficacy (PPE) ≥ 2.3 µmol/J.",{"$nulls":14},"2. In the Object dialog box, select the 'Create New' tab and the select 'Adobe Acrobat Document' from the list. ..."]
[null,"• Minimum warranty of five years.",{"$nulls":14},"3. Check the option – 'Display as icon'."]
[null,"• Appropriate horticultural lighting designation by OSHA Nationally Recognized Testing Laboratories or Safety Compliance and Consulting Corporation.",{"$nulls":14},"4. If desired, select \"Change Icon\" to modify the file name displayed (ex: Model XYZ QPL, Model ABC QPL, etc.).  "]
[{"$nulls":16},"5. Click OK."]
[{"$nulls":16},"6. Select the PDF file to embed and click on Open."]
[]
[{"$nulls":16},"1)",{"$nulls":8},"2 - 5)"]
{"$rows_empty":15}
[{"$nulls":25},"6)"]

{"sheet":"Proposal_Optional","index":4,"n_rows":26,"n_cols":16,"rows_kept":26}
["Insert/Embed Proposal **Optional**"]
[{"$nulls":6},"How to Embed a PDF File in an Excel Worksheet"]
[{"$nulls":6},"1. Go to Insert tab and click on the Object icon in the Text group. ..."]
[{"$nulls":6},"2. In the Object dialog box, select the 'Create New' tab and the select 'Adobe Acrobat Document' from the list. ..."]
[{"$nulls":6},"3. Check the option – 'Display as icon'."]
[{"$nulls":6},"4. If desired, select \"Change Icon\" to modify the file name displayed (ex: Proposal [Month] [Year], etc.).  "]
[{"$nulls":6},"5. Click OK."]
[{"$nulls":6},"6. Select the PDF file to embed and click on Open."]
[]
[{"$nulls":6},"1)",{"$nulls":8},"2 - 5)"]
{"$rows_empty":15}
[{"$nulls":15},"6)"]

{"sheet":"Savings and Incentives","index":5,"n_rows":47,"n_cols":11,"rows_kept":47,"merged":[[3,2,3,3],[4,2,4,3],[5,2,5,3],[6,2,6,3],[8,2,8,3],[8,6,9,6],[9,2,9,3]]}
[{"$nulls":5},"Last Updated:",{"$f":"MAX('Revision History'!A4:A32)","v":"2026-01-09"},{"$nulls":3},"Measure"]
[null,"Additional Information:",{"$nulls":8},"AG5032 - Grow Light System - Single Tier Indoor Farm"]
[{"$nulls":10},"AG5033 - Grow Light System - Supplemented Greenhouse"]
[]
[null,null,"SOLUTION (Choose from dropdown)"]
[]
[null,null,"BUILDING TYPE (Choose from dropdown)",{"$nulls":7},"Existing Building"]
[{"$nulls":10},"New Construction"]
[]
[null,null,"ESTIMATED COMPLETION DATE"]
[]
[null,"Energy Savings  (paste or link values from Calculations tab)"]
[{"$nulls":4},"EXAMPLE","Fill in the yellow cells only if not auto-populated from Calculations tab"]
[{"$nulls":3},"Baseline Annual Electrical Usage (kWh)",{"$f":"Calculations!B29","v":{"v":950731,"d":"950,731 "}},{"$f":"IF(Calculations!C21=\"\",Calculations!G29,Calculations!C29)","v":{"v":0,"d":"0 "}}]
[{"$nulls":3},"Proposed Annual Electrical Usage Without Automated Controls (kWh)",{"$f":"Calculations!B47","v":{"v":523867.07999999996,"d":"523,867 "}},{"$f":"IF(Calculations!C21=\"\",Calculations!G47,Calculations!C47)","v":{"v":0,"d":"0 "}},"Not a required field"]
[{"$nulls":3},"Proposed Annual Usage With Automated Controls (kWh)",{"$f":"Calculations!B48","v":{"v":445287.018,"d":"445,287 "}},{"$f":"IF(Calculations!C21=\"\",Calculations!G48,Calculations!C48)","v":{"v":0,"d":"0 "}},"If controls are not installed, re-enter proposed usage without controls from cell E15"]
[{"$nulls":3},"Annual Energy Savings (kWh)",{"$f":"ROUND(E14-E16,0)","v":{"v":505444,"d":"505,444 "}},{"$f":"ROUND(F14-F16,0)","v":{"v":0,"d":"0 "}}]
["Grow Light System, Supplemented greenhouse",null,null,"Lifecycle Energy Savings (kWh)",{"$f":"IF(C4=\"\",\"\",IF(C4=\"AG5032 - Grow Light System - Single Tier Indoor Farm\",E17*10,E17*20))","v":""},{"$f":"IF(C4=\"\",\"\",IF(C4=\"AG5032 - Grow Light System - Single Tier Indoor Farm\",F17*10,F17*20))","v":""}]
[]
[0.3,null,null,"Energy Reduction (%)",{"$f":"IFERROR(1-(E16/E14),\"\")","v":{"v":0.5316372159948504,"d":"53%"}},{"$f":"IFERROR(1-(F16/F14),\"\")","v":""},{"$f":"IF(F20=\"\",\"\",IF(F20<29.99%,\"Does not meet % Energy Reduction Requirement - May qualify for Custom Incentive\",\"Does meet % Energy Reduction Requirement\"))","v":""}]
[{"$nulls":3},"Equivalent Photosynthetic Photon Flux Density (PPFD)","verified",null,null,"Verified"]
[{"$nulls":7},"Not Verified"]
[29.99,null,null,"Baseline Summer Electrical Demand (kW)",{"$f":"Calculations!B26","v":0},{"$f":"IF(Calculations!C21=\"\",Calculations!G26,Calculations!C26)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"Proposed Summer Electrical Demand (kW)",{"$f":"Calculations!B44","v":0},{"$f":"IF(Calculations!C21=\"\",Calculations!G44,Calculations!C44)","v":{"v":0,"d":"0.00"}}]
["Grow Light System, Supplemented greenhouse",null,null,"Baseline Winter Electrical Demand (kW)",{"$f":"Calculations!B28","v":{"v":65.2795,"d":"65.28"}},{"$f":"IF(Calculations!C21=\"\",Calculations!G28,Calculations!C28)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"Proposed Winter Electrical Demand (kW)",{"$f":"Calculations!B46","v":35.97},{"$f":"IF(Calculations!C21=\"\",Calculations!G46,Calculations!C46)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"Summer Demand Savings (kW)",{"$f":"E23-E24","v":{"v":0,"d":"0.00"}},{"$f":"F23-F24","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"Winter Demand Savings (kW)",{"$f":"ROUND(E25-E26,2)","v":29.31},{"$f":"F25-F26","v":{"v":0,"d":"0.00"}}]
[]
[]
[null,"Estimated Incentive Amount",{"$nulls":4},"Note: Blended electrical cost"]
[]
[{"$nulls":3},"Cost of Electricity ($/kWh)",{"v":0.1287,"d":"$0.1287"},{"v":0.1287,"d":"$0.1287"},"Manually overwrite if needed. Default value of $0.1287 is EIA Monthly Rates 11/2024 to 10/2025"]
[{"$nulls":3},"Project Cost for Baseline Design",{"$f":"Calculations!B31","v":{"v":154250,"d":"$154,250.00"}},{"$f":"IF(Calculations!C31=\"\",Calculations!G31,Calculations!C31)","v":0}]
[{"$nulls":3},"Project Cost for Energy Efficient Design",{"$f":"Calculations!B49","v":{"v":324150,"d":"$324,150.00"}},{"$f":"IF(Calculations!C49=\"\",Calculations!G49,Calculations!C49)","v":0}]
[{"$nulls":3},"Incremental Project Cost",{"$f":"IFERROR(E35-E34,\"\")","v":{"v":169900,"d":"$169,900.00"}},{"$f":"IFERROR(F35-F34,\"\")","v":0},{"$f":"(IF(F36<0,\"Does Not Qualify - Negative Incremental Project Cost\",\"\"))","v":""}]
[{"$nulls":3},"Incentive Rate ($/kWh Saved)",{"v":0.15,"d":"$0.15"},{"v":0.15,"d":"$0.15"}]
[]
[{"$nulls":3},"Annual Energy Cost Savings",{"$f":"E17*E33","v":{"v":65050.6428,"d":"$65,050.64"}},{"$f":"F17*F33","v":0}]
[]
[{"$nulls":3},"Total Incentive",{"$f":"E37*E17","v":{"v":75816.59999999999,"d":"$75,816.60"}},{"$f":"F37*F17","v":0}]
[]
[{"$nulls":3},"Incentive Limits"]
[{"$nulls":3},"Incentive Capped at 50% Efficient Project Cost",{"$f":"(ROUND(E35*0.5,2))","v":{"v":162075,"d":"$162,075.00"}},{"$f":"(ROUND(F35*0.5,2))","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},"Incentive Capped at $300,000",{"$f":"MIN(E41,300000)","v":{"v":75816.59999999999,"d":"$75,816.60"}},{"$f":"MIN(F41,300000)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},"Incentive Based on Energy Savings",{"$f":"E41","v":{"v":75816.59999999999,"d":"$75,816.60"}},{"$f":"F41","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},"Final Incentive",{"$f":"MIN(E44:E46)","v":{"v":75816.59999999999,"d":"$75,816.60"}},{"$f":"MIN(F44:F46)","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Revision History","index":6,"n_rows":16,"n_cols":3,"rows_kept":16,"hidden":true}
["Revision History"]
[]
["Date","Describe the revision that was made","Name"]
["2020-07-16","Added revision history tab","TB"]
["2021-01-04","Updated Application tab, removed Hort Lighting Sell Sheet since measures are in 2021 Ag Catalog, updated password to 'focus2021'","Melissa "]
["2021-01-22","Corrected incentive cap error in formula on Savings & Incentives tab","Melissa "]
["2021-02-05","Added 'Equivalent PPFD) check on Savings & Incentives Tab","Melissa "]
["2022-01-04","Updated Application tab to have text align with check boxes and dates and section 1. Updated logo as well.","Jeremiah"]
["2022-01-06","Added how to embed instructions on several tabs. Reformatted requirement text to bullets, renamed Invoice tab to Proposal","Melissa "]
["2022-12-22","Updated Application tab to reflect changes in the 2023 catalog; updated logo on Savings and Incentives tab.","Jeremiah"]
["2023-04-27","Added MMIDs to the name of the two measures so it is easier to enter in SPECTRUM","Melissa "]
["2023-12-15","Updated workbook to reflect changes in the 2024 catalog; updated default elec. rate and password","Melissa "]
["2024-01-25","Updated incentive cap from 50% of incremental cost to 50% of efficient project cost","Melissa "]
["2024-02-23","Formatted Peak Demand (kW) Savings field on Savings and Incentives tab to display 'No Demand Savings' when supplemented greenhouse measure is selected","Melissa "]
["2024-12-27","Updated workbook to reflect changes in the 2025 catalog; updated default elec. rate and password, added winter peak kW","Melissa "]
["2026-01-09","Updated workbook to reflect changes in the 2026 catalog; Updated incentive rate to .15, elec. Rate, and password. ","Evan"]