{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Score Sheet","Energy Calculations"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"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":"Score Sheet","index":0,"n_rows":192,"n_cols":10,"rows_kept":192,"cut":false,"hidden":false,"merged":[[127,0,128,3],[192,0,192,4],[182,0,182,5],[161,0,161,4],[136,0,136,5],[156,0,156,3],[157,0,157,3],[157,4,159,4],[158,0,158,3],[159,0,159,3],[155,0,155,4],[188,0,188,3],[149,0,149,4],[145,0,145,3],[145,4,147,4],[146,0,146,3],[147,0,147,3],[187,0,187,3],[185,4,190,4],[153,0,153,4],[184,0,184,3],[185,0,185,3],[186,0,186,3],[190,0,190,3],[175,0,175,4],[183,0,183,4],[21,0,21,5],[96,0,96,4],[104,0,104,5],[122,0,122,4],[109,4,111,4],[115,0,115,5],[119,4,120,4],[83,2,84,2],[135,0,135,4],[133,0,133,5],[113,0,113,4],[81,0,81,4],[72,0,72,4],[70,3,71,3],[106,0,106,4],[89,0,89,4],[90,0,90,4],[87,0,87,3],[87,4,88,4],[86,0,86,3],[116,0,116,4],[124,0,124,5],[23,0,23,3],[30,0,30,5],[94,4,95,4],[85,0,85,4],[88,0,88,3],[25,0,25,3],[28,0,28,4],[105,0,105,4],[26,0,26,3],[34,0,34,4],[52,4,53,4],[48,0,50,3],[39,0,40,3],[55,0,55,4],[39,4,40,4],[57,0,57,4],[24,0,24,3],[44,0,44,4],[82,0,82,4],[97,0,97,4],[98,0,98,4],[59,0,59,3],[60,0,60,3],[61,0,61,3],[62,0,62,3],[63,0,63,4],[64,0,64,4],[43,0,43,4],[24,4,26,4],[70,2,71,2],[38,0,38,3],[54,0,54,4],[33,0,33,4],[51,0,51,3],[35,0,35,4],[49,4,51,4],[41,4,42,4],[67,0,67,4],[65,0,65,4],[66,0,66,4],[58,0,58,4],[60,4,62,4],[2,0,2,4],[3,0,3,4],[20,0,20,4],[6,1,6,3],[4,0,4,4],[7,1,7,3],[8,1,8,3],[6,4,11,5],[5,4,5,5],[9,2,9,3],[14,1,15,1],[14,2,15,2],[14,3,15,3],[10,2,10,3],[14,4,15,4],[189,0,189,3],[141,1,142,1],[139,1,140,1],[139,0,140,0],[141,0,142,0],[79,0,79,4],[77,0,77,3],[83,3,84,3],[143,0,143,4],[180,0,180,4],[120,0,120,3],[127,4,128,4],[126,0,126,3],[138,0,138,4],[139,4,142,4],[78,0,78,4],[75,4,77,4],[76,0,76,3],[92,0,92,4],[93,0,94,3],[95,0,95,3],[144,0,144,3],[109,0,109,3],[130,0,130,4],[177,4,178,4],[118,0,118,3],[173,0,173,5],[119,0,119,3],[68,0,68,4],[108,0,108,3],[69,0,69,4],[74,0,74,3],[75,0,75,3],[103,0,103,4],[125,0,125,4],[117,0,117,4],[167,0,167,3],[168,0,168,3],[169,0,169,3],[170,0,170,3],[171,0,171,4],[167,4,170,4],[100,4,101,4],[102,0,102,4],[164,0,164,4],[172,0,172,4],[111,0,111,3],[174,0,174,4]]}
[null,null,null,null,"7 C.F.R. 4280-B & 5001"]
["Revised 12/21/20"]
["Rural Energy for America Program "]
["Renewable Energy Systems, Energy Efficiency Improvements, Energy Efficient Equipment"]
["Evaluation Criteria Scoring Guide"]
[null,null,null,null,"Post Review by:"]
["Name of Applicant: "]
["Name of Reviewer:"]
["Type of Technology:"]
["Grant Request:           $"]
["Loan Request:            $"]
["Total Project Cost:      $",null,"Eligible Project Cost:  $   "]
[]
[null,"Base Priority Score ","Administrative Points","Total Grant/ComboScore","Total Loan Only Score"]
[null,{"$f":"IF(B10=0,IF(AND(B38>0,D71>150%),(E95+E25+E110+E128+E120+E146+E42),\"\"),IF(B10>0,IF(AND(B38>0,D71>150%),(E40+E95+E25+E110+E128+E178+E120+E146),\"\")))","v":""},{"$f":"IF(AND(D71>150%,B38>0),E186,\"\")","v":""},{"$f":"IF(AND(B38>0,D71>150%,B10>0),B15+C15,\"\")","v":""},{"$f":"IF(B10=0,(IF(AND(B38>0,D71>150%,B11>0),E42+E95+E25+E110+E128+E120+E146+C15,\"\")),\"\")","v":""}]
["RES Generation"]
["RES Direct Use/Replacement",{"$f":"IF(AND(B10<>\"\",D71>0%,D71<=150%),(E40+E76+E25+E110+E128+E178+E120+E146),IF(AND(B10=\"\",D71>0%,D71<=150%),(E42+E76+E25+E110+E128+E120+E146),\"\"))","v":""},{"$f":"IF(AND(D71>0%,D71<=150%),E186,\"\")","v":""},{"$f":"IF(B10>0,(IF(AND(D71>0,D71<=150%),B17+C17,\"\")),\"\")","v":""},{"$f":"IF(B10=0,(IF(AND(B38>0,D71<=150%,B11>0),E42+E76+E25+E110+E120+E128+E146+E186,\"\")),\"\")","v":""}," "]
["Energy Efficiency Improvements (EEI)",{"$f":"IF(B48>0,IF(AND(D53>0,B10=0),(E53+E88+E25+E110+E120+E158+E128),(E50+E88+E25+E110+E178+E120+E158+E128)),\"\")","v":""},{"$f":"IF(B48>0,E186,\"\")","v":""},{"$f":"IF(B10>0,IF(B48>0,B18+C18,\"\"),\"\")","v":""},{"$f":"IF(B10=0,(IF(AND(B48>0),E53+E88+E25+E110+E128+E120+E158+C18,\"\")),\"\")","v":""}]
["Energy Efficient Equipment (EEE)",{"$f":"IF(E61>0,E25+E61+E101+E110+E120+E128+E168,\"\")","v":""},{"$f":"IF(E61>0,E186,\"\")","v":""},null,{"$f":"IF(AND(B10=\"\",E61>0),B19+C19,\"\")","v":""}]
[]
["Complete using TAB key the yellow highlighted text boxes or insert the maximum points the applicant is eligible for under each of the following categories, the individual scores are automatically summed and placed in the \"Total Score\" columns above. Provide comments to justify score. Combination grant/loan applications are scored as grants using grant dollars requested in applicable calculations. Energy efficient equipment applies only to guaranteed loans. "]
["(1) Environmental benefits"]
["A maximum of 5 points will be awarded for criterion 1. "]
["Points are awarded based on whether the Applicant has indicated in the application that the proposed project will have a positive effect on any of the three impact areas:  resource conservation (e.g., water, soil, forest), public health (e.g., potable water, air quality), and the environment (e.g., compliance with EPA’s renewable fuel standard(s), greenhouse gases, emissions, particulate matter).  Points will be awarded as follows:\n\n\n",null,null,null,"Points",{"$f":"IF(E24=\"\",\"ERROR\",\"\")","v":""}]
["(i)  If the proposed project has a positive impact on any one of the three impact areas, Award 1 point.\n\n\n"]
["\n(ii)  If the proposed project has a positive impact on any two of the three impact areas, Award 3 points."]
["(iii)  If the proposed project has a positive impact on all three impact areas, Award 5 points"]
["Provide comments if additional specific measures applicable to project were provided as part of the application.  "]
[]
[]
["(2) Quantity of Energy Generated, Replaced, Saved or Percent Efficiency "]
["A maximum of 25 points will be awarded for Criterion 2. Complete sub-criteria i and ii below. "]
[]
["                      Sub-Criteria i: Quantity of Energy Generated or Saved per REAP RES/EEI Grant or Loan Dollar Requested, or Percent Efficiency of EEE project (10 points max.)                                      "]
["For RES and EEI projects, points will be awarded for either the amount of energy generated per grant or loan dollar requested, which includes those projects that are replacing energy usage with a renewable source, or the actual annual average energy savings over the most recent 12, 24, 36, 48, or 60 consecutive months of operation per grant or loan dollar requested; For EEE projects, points will be awarded for the increased percent of energy efficiency; points will not be awarded for more than one category. "]
["Residential energy use should NOT be included."]
["(A) Renewable Energy Systems"]
["Projected Annual Energy Generated (EG) in BTU's:                ",null,"   EG/Grant Dollar (G or Combo):              (Auto-Calculates)",{"$f":"IF(B10>0,B38/(B10),\"\")","v":""}]
[null,null,null,null,"Points"]
["(1) Less than 50,000 BTU per Grant or Loan Dollar                         Auto Calculates (EG/$) / 50,000 x 10 points                            (2) Greater than 50,000 BTU per Grant or Loan Dollar = 10 points       Auto Calculates:  (EG/$)>50,000 = 10 points",null,"                 Auto Calculates (EG/$) / 50,000 x 10 points  ",null,{"$f":"IF(B10>0,IF(D38<50000,D38/50000*10,10),0)","v":0}]
[]
[null,null,"EG/Loan Dollar",{"$f":"IF(B10<>\"\",\"\",B38/B11)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(B10=\"\",B11>0,D42<50000),(D42/50000*10),IF(AND(B10=\"\",B11>0,D42>=50000),10,\"\"))","v":{"$error":"#DIV/0!"}},null,null,null,null," "]
[null,null,"(Auto-Calculates)"]
["Provide additional documentation (if applicable) to substantiate the score for this category below.  "]
[]
["OR"]
["(B) Energy Efficiency Improvement (EEI)"]
["Projected Average Annual Energy Saved (ES) in BTU's ",null,"      ES/Grant Dollar (G or Combo):              (Auto-Calculates)",{"$f":"IF(B10=0,\"\",B48/(B10))","v":""}]
["(1) Less than 50,000 BTU per Grant or Loan Dollar                           Auto Calculates: (ES/$) / 50,000 x 10 points                          (2) Greater than 50,000 BTU per Grant or Loan Dollar = 10 points           Auto Calculates:  (ES/$)>50,000 = 10 points",null,null,null,"Points"]
[null,null,null,null,{"$f":"IF(B10>0,IF(D48<50000,D48/50000*10,10),\"\")","v":""}]
[]
[null,null,null,null,null,null,null," "]
[null,null,"ES/Loan Dollar",{"$f":"IF(B10<>\"\",\"\",B48/B11)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(B10=\"\",D53<50000),(D53/50000*10),IF(AND(B10=\"\",D53>=50000),10,\"\"))","v":{"$error":"#DIV/0!"}}]
[null,null,"(Auto-Calculates)"]
["Provide additional documentation (if applicable) to substantiate the score for this category below.  "]
[]
["OR"]
["(C) Energy Efficient Equipment & Systems (EEE)  (LOAN ONLY)"]
[" If the increased energy efficiency of the proposed equipment and systems is: "]
["   75 percent or greater, award 10 points;",null,null,null,"Points"]
["   Less than 75 percent but equal to or greater than 50 percent, award 5 points;"]
["   Less than 50 percent but equal to or greater than 25 percent, award 2.5 points; or "]
["   Less than 25 percent, award 0 points."]
["Provide additional documentation (if applicable) to substantiate the score for this category below.  "]
[]
["Sub-Criteria ii: Quantity of Energy Replaced, Generated, or Saved, or Percentage of Energy Efficiency  (15 points max)"]
["Points may only be awarded for energy replacement, energy generation, or energy savings, or percentage of energy effiiciency.   Points will not be awarded for more than one category."]
["(A)  Energy replacement"]
["For a project to qualify as an energy replacement it must provide at least 12 months of historical utility bills in the name of the applicant entity or documentation must be provided regarding historical energy expense incurred by the applicant entity. If not provided, score as generation.  For new construction the project may classify as energy replacement only if the applicant can document previous energy use from a facility of approximately the same size (+/- 10%)."]
["Determine energy replacement by dividing the estimated quantity of renewable energy to be generated over a 12-month period by the estimated quantity of energy consumed over the same 12-month period during the previous year by the applicable energy application:"]
["Projected Annual Energy Generated (EG) in BTU's:        ",null,"Percent Energy                         Replacement                                               (Auto-Calculates)",{"$f":"IF(B71>0,(B71/B72),\"0\")","v":"0"}]
["Historical Annual Energy Consumption (EC) in BTU's:"]
["If the proposed renewable energy system is intended primarily for self use by the agricultural producer or rural small business, and will provide energy replacement of:"]
[]
["(1) Greater than 0 but equal to or less than 25%, award 5 points.",null,null,null,"Points"]
["(2) Greater than 25%, but equal to or less than 50%, award 10 points.",null,null,null,{"$f":"IF(AND(D71>50%,D71<=150%),\"15\",IF(AND(D71>0%,D71<=25%),\"5\",IF(AND(D71>25%,D71<=50%),\"10\",IF(D71>150%,\"0\",IF(D71=0,\"0\")))))","v":"0"}]
["(3) Greater than 50%, award 15 points."]
["      (4) Greater than 150% , Score as Energy Generation"]
["Provide additional documentation (if applicable) to substantiate the score for this category below.  "]
[]
["OR"]
["(B) Energy Savings "]
["Energy savings will be determined by the projections in an energy assessment or audit, supported by at least 12 months of historical utility bills. Proposed additional energy consumption should not be considered."]
["Historical Annual Energy Consumption (HEC) in BTU's:",null,"  Energy Savings                                                        (Auto-Calculates)",{"$f":"IF(B84>0,(B84-B85)/B84,0)","v":0}]
["Projected Annual Energy Consumption (PEC) in BTU's: "]
["If the estimated energy expected to be saved by the installation of the energy efficiency improvements will be from:"]
["(1) 20% up to but not including 35%, award 5 points.",null,null,null,"Points"]
["(2) 35% up to but not including 50%, award 10 points.",null,null,null,{"$f":"IF(AND(D84>0,D84<20%),\"0\",IF(AND(D84>=20%,D84<35%),\"5\",IF(AND(D84>=35%,D84<50%),\"10\",IF(D84>=50%,\"15\",IF(D84<=0,\"0\")))))","v":"0"}]
["(3) 50% or greater, award 15 points."]
["Provide additional documentation (if applicable) to substantiate the score for this category below.  "]
[]
["OR"]
["(C) Energy generation "]
["(1) If the proposed renewable energy system is intended primarily for production of energy, Award 10 points. This includes RES retrofits that increase the amount of energy generated by the existing RES system, off-grid RES applications, and direct use energy in new buildings without historical energy consumption.",null,null,null,"Points"]
[null,null,null,null,{"$f":"IF(AND(D71>150%,B38>0),\"10\",\"0\")","v":"0"}]
["Provide additional documentation (if applicable) to substantiate the score for this category below.  "]
[]
["(D) Energy Efficiency (EEE)"]
["If the percentage of energy efficiency is: "]
["    (1)  Greater than 50 pecent,. Award 15  points.",null,null,null,"Points"]
["    (2)  Greater than 5 percent, but equal to or less than 50 percent, award 10 points: ",null,null,null,0]
["    (3)  Equal to or less than 25 percent, award 5 points; "]
["Provide additional documentation (if applicable) to substantiate the score for this category below.  "]
[]
["(3)  Commitment of Funds"]
["A maximum of 15 points will be awarded for criterion 3. "]
["If the applicant has written commitments, received by the Agency as part of the complete application, from the source(s) confirming commitment of: "]
["Commitment Needed",{"$f":"D12-B10-B11","v":0},"Commitment Provided"]
["(i) 50% or less, award 0 points.",null,null,null,"Points"]
["(ii) Over 50% but not including 100% of the commitment needed, calculate the points as:",null,null,null,{"$f":"IF(B111<=0.5,\"0\",IF(AND(B111>0.5,B111<1),D111,IF(B111>=1,\"15\",0)))","v":"0"}]
["Percentage of Commited Funds Provided  (Auto-Calculates)",{"$f":"IF(D108,D108/B108,0)","v":0},"(PM-50% / 50% x 15 points)         Auto-Calculates Points",{"$f":"(B111-0.5)/0.5*20","v":-20}]
["(iii) 100%, award 15 points. "]
["Provide documentation to substantiate the score for this category below.  "]
[]
[]
["(4)  Previous Grantees and Borrowers"]
["A maximum of 15 points will be awarded for criterion 4. "]
["Receiving a grant or loan means funds were disbursed or a loan note guarantee was issued by the Agency to the same applicant entity, based upon the tax identification number.  Base the calculation on the fiscal year in which the obligation was made. "]
["(i) If the Applicant has never received a grant and/or guaranteed loan under this subpart, Award 15 points",null,null,null,"Points "]
["(ii) If the Applicant has not received a grant and/or guaranteed loan under this subpart within the 2 previous Federal Fiscal Years, Award 5 points"]
["(iii) If the Applicant has received a grant and/or guaranteed loan under this subpart within the 2 previous Federal Fiscal Years, Award 0 points."]
["Provide documentation to substantiate the score for this category below.  "]
[]
[]
["(5)  Existing Business"]
["A maximum of 5 points will be awarded for criterion 5. "]
["Points will be awarded for an existing agricultural producer business or rural small business that meets the definition of existing business:",null,null,null,"Points "]
["                 A business that has been in operation for at least one full year.Organization of the entity alone, e.g. filing of legal business documents, does not constitute being in operation. As long as there is no significant change in operations, mergers by an existing business with a new or existing business, a change in the business name, or a new business and an existing business applying as co-borrowers, will be treated as an existing business."]
[]
["Provide documentation to substantiate the score for this category below.  "]
[]
[]
[]
["(6) Simple payback "]
["A maximum of 15 points will be awarded for criterion 6."]
["Points will be awarded for renewable energy systems, energy efficiency improvements, or energy efficient equipment; points will not be awarded for more than one category.  "]
["(i)  Renewable energy systems "]
[]
["Renewable Energy Systems Simple Payback = Total project costs / Dollar value of energy units replaced, credited, sold, or used and fair market value of byproducts as applicable in a typical year.  Historical use must be based on average actual energy consumed by the applicant entity over at least the most recent 12 month period. Only energy charges directly reduced by the unit of energy being replaced should be included in the actual average price of energy for replacement projects. Documentation should be provided to justify the quantity and price per unit of energy and byproducts (e.g. compost from a digester or distillers grain from ethanol plant).  Documentation of price per unit of a conventional fuel source may be provided to calculate payback when renewable energy will be used in a new facility or off grid application. Residential energy consumption is excluded. Do not include proposed additional energy consumption. Does not include tax credits, carbon credits, RECs and construction or investment related benefits which are not received for the entire life of the system.  "]
["Total Project Costs                     (Auto Calculates):",{"$f":"B12","v":0},"$ Replaced",null,{"$f":"B140/B142","v":{"$error":"#DIV/0!"}}]
[null,null,"$ Sold or Credited"]
["Total Income: ",{"$f":"SUM(D140+D141+D142+D143)","v":0},"$ Used "]
[null,null,"$ By Products"]
["If the simple payback of the proposed project is: "]
["(1) Less than 10 years, award 15 points.",null,null,null,"Points "]
["(2) 10 years up to but not including 15 years, award 10 points.",null,null,null,{"$f":"IF(AND(E140>=10,E140<15),\"10\",IF(AND(E140>=15,E140<=25),\"5\",IF(E140<10,\"15\",IF(E140>25,\"0\",\"\"))))","v":{"$error":"#DIV/0!"}}]
["(3) 15 years up to and including 25 years, award 5 points."]
["(4) Longer than 25 years, award 0 points."]
["Provide documentation to substantiate the score for this category below.  "]
[]
["OR"]
["(ii)  Energy efficiency improvements "]
[]
["EEI projects Simple Payback = (Total Project Costs)/Dollar Value of Energy Saved. Dollar value of energy saved incorporates the following: Energy Savings using a constant value or price of energy; historical energy use of building or equipment must be based on actual average annual BTU used over the most recent 12-60 consecutive month period, supported by utility bills. Does not include proposed additional energy consumption and savings. Value or price of energy must be actual average price paid over same period as above, using only energy charges directly reduced by the unit of energy being replaced or saved..  EEI improvements cannot monetize benefits other than the dollar amount of energy savings realized as a result of the improvement. "]
["Total Project Costs                      (Auto Calculates):",{"$f":"B12","v":0},"Dollar Value of Energy Saved:",null,{"$f":"IF(D84>0,B155/D155,\"\")","v":""}]
["If the simple payback of the proposed project is: "]
["(A) Less than 4 years, award 15 points.",null,null,null,"Points "]
["(B) 4 years up to but not including 8 years, award 10 points.",null,null,null,{"$f":"IF(AND(E155>=4,E155<8),\"10\",IF(AND(E155>=8,E155<=12),\"5\",IF(E155<4,\"15\",IF(E155>12,\"0\"))))","v":"0"}]
["(C) 8 years up to and including 12 years, award 5 points."]
["(D) Longer than 12 years, award 0 points."]
["Provide documentation to substantiate the score for this category below.  "]
[]
["OR"]
["(iii)  Energy Efficient Equipment "]
["EEE projects Simple Payback = (Total Project Costs)/Dollar Value of Efficiency Savings. Efficiency savings will be determined by subtracting the annual value of energy to be consumed by the proposed energy efficient equipment from the annual value of energy that a conventional equipment alternative would have consumed. Adequate documentation must be provided for all consumption estimates and values utilized in the calculation. "]
["Eligible Project Costs              (Auto Calculates from page 1)",{"$f":"D12","v":0},"Dollar Value of Efficiency Savings:",null,{"$f":"IF(E101>0,B166/D166,\"\")","v":""}]
["If the simple payback of the project is: ",null,null,null,"Points "]
["(A) Less than 4 years, award 15 points.",null,null,null,{"$f":"IF(AND(E166>=4,E166<8),\"10\",IF(AND(E166>=8,E166<=12),\"5\",IF(E166<4,\"15\",IF(E166>12,\"0\"))))","v":"0"}]
["(B) 4 years up to but not including 8 years, award 10 points."]
["(C) 8 years up to and including 12 years, award 5 points."]
["(D) Longer than 12 years, award 0 points."]
["Provide documentation to substantiate the score for this category below."]
[]
["(7)  Size of REAP Funding Request   (N/A to loan only requests) "]
["A maximum of 10 points will be awarded for criterion 7. "]
["Grant requests of $250,000 or less for RES or $125,000 or less for EEI are eligible for an additional 10 points. This section applies to grant and combination grant/loan applications only: "]
["REAP Grant Request",{"$f":"B10","v":0},null,null,"Points"]
[null,null,null,{"$f":"IF(B179=\"EEI\",IF(B177>125000,0,10),IF(B179=\"RES\",IF(B177>250000,0,10)))","v":10},{"$f":"IF(B177=0,\"\",IF(B179=\"EEI\",IF(B177>125000,0,10),IF(B179=\"RES\",IF(B177>250000,0,10))))","v":""}]
["Project Type",{"$f":"IF(B38>0,\"RES\",\"EEI\")","v":"EEI"},null,{"$f":"IF(B179=\"EEI\",IF(B178>125000,0,10),IF(B179=\"RES\",IF(B178>250000,0,10)))","v":10}]
["Provide additional documentation below (if applicable) to substantiate the score for this category.  "]
[]
[]
["(8) State Director and Administrator priorities and points"]
["A maximum of 10 points will be awarded for criterion 8. "]
["A State Director, for its State allocation under this subpart, or the Administrator, for making awards from the National Office reserve, may award up to 10 points to an application if the application is for: ",null,null,null,"Points "]
["     i.) An under-represented technology;"]
["     ii.) If selecting the application would help achieve geographic diversity (may include points for size of funding request);"]
["     iii.) The applicant is a member of an unserved or under-served population; veteran/socially-disadvantaged group;"]
["     iv.) Selecting the application helps further a Presidential Initiative or a Secretary of Agriculture priority;"]
["     v.) The proposed project is located in a Federally declared disaster area (declaration within last 2 calendar yrs.);"]
["     vi.) The proposed project is located in a persistent poverty area, underserved community(ies) or has experienced long-term population decline, or loss of employment."]
["Provide documentation to substantiate the score for this category below.  "]

{"sheet":"Energy Calculations","index":1,"n_rows":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,8],[10,0,10,8],[22,0,22,8],[34,0,34,8]]}
["1A. Energy Calculations - Efficiency"]
["Current System","Energy Used","BTU Value","$ Value Current","Proposed System","Energy Planned","BTU Value","$ Value per Unit Proposed","$ Value Proposed"]
["Electricity (3,412btu/kwh)",null,{"$f":"B3*3412","v":0},null,"Electricity",null,{"$f":"F3*3412","v":0},{"$f":"I3/F3","v":{"$error":"#DIV/0!"}}]
["Diesel (139,000btu/gal)",null,{"$f":"B4*139000","v":0},0,"Diesel",null,{"$f":"F4*139000","v":0},{"$f":"I4/F4","v":{"$error":"#DIV/0!"}}]
["Propane (91,502btu/gal)",null,{"$f":"B5*91502","v":0},null,"Propane",null,{"$f":"F5*91502","v":0},{"$error":"#DIV/0!"}]
["Nat Gas (100,000btu/therm)",null,{"$f":"B6*100000","v":0},null,"Natural Gas",null,{"$f":"F6*100000","v":0},{"$error":"#DIV/0!"}]
["Other",null,null,null,"Other",null,null,{"$error":"#DIV/0!"}]
[]
["Total",{"$f":"SUM(B3:B7)","v":0},{"$f":"SUM(C3:C8)","v":0},{"$f":"SUM(D3:D8)","v":0},"Total",{"$f":"SUM(F3:F7)","v":0},{"$f":"SUM(G3:G8)","v":0},null,{"$f":"SUM(I3:I8)","v":0}]
[null,null,null,null,null,"Energy Savings",{"$f":"C9-G9","v":0},"% Saved",{"$f":"G10/C9","v":{"$error":"#DIV/0!"}},"$ Saved",{"$f":"D9-I9","v":0}]
["1B. Energy Generation"]
["Proposed System","Amount of Energy Proposed to be Generated",null,null,"BTU Value","$ Value of Energy per Unit","Gross Income from Energy Sale"]
["Solar",null,"kwh",null,{"$f":"B13*3412","v":0},null,{"$f":"B13*F13","v":0}]
["Wind",null,"kwh",null,{"$f":"B14*3412","v":0},null,0]
["Geothermal",null,"kwh",null,0,null,0]
["Biomass",null,"kwh",null,0,null,0]
["Hydrogen",null,"kwh",null,0,null,0]
["Hydro-electric",null,"kwh",null,0,null,0]
["Ocean",null,"kwh",null,0,null,0]
["Ethanol",null,"gal",null,{"$f":"B20*76330","v":0},null,0]
["Biodiesel",null,"gal",null,{"$f":"B21*119550","v":0},null,0]
["Total",{"$f":"SUM(B13:B21)","v":0},null,null,{"$f":"SUM(E13:E21)","v":0},null,{"$f":"SUM(G13:G21)","v":0}]
["1C.  Energy Replacement"]
["Current System","Energy Used","BTU Value","$ Value Current","Proposed System","Amount of Energy Proposed to be Generated","BTU Value","$ Value of Energy per Unit","Value of Energy Replaced"]
["Electricity",null,{"$f":"B25*3412","v":0},null,"Solar",null,{"$f":"F25*3412","v":0}]
["Diesel",null,{"$f":"B26*139000","v":0},null,"Wind",null,0]
["Propane",null,{"$f":"B27*91502","v":0},null,"Geothermal",null,0]
["Nat Gas",null,{"$f":"B28*100000","v":0},null,"Biomass",null,0]
["Other",null,null,null,"Hydrogen",null,0]
[null,null,null,null,"Hydro-electric",null,0]
[null,null,null,null,"Ocean",null,0]
[null,null,null,null,"Ethanol",null,{"$f":"F32*76330","v":0}]
[null,null,null,null,"Biodiesel",null,{"$f":"F33*119550","v":0}]
["Total Current",{"$f":"SUM(B25:B33)","v":0},null,{"$f":"SUM(D25:D33)","v":0},"Total Proposed",{"$f":"SUM(F25:F33)","v":0},null,null,{"$f":"SUM(I25:I33)","v":0}]
["6.  Simple Payback"]
[]
["Total Project Costs",null,{"$f":"'Score Sheet'!B12","v":0}]
[]
["Dollar Value of Energy Saved (EEI)",null,{"$f":"D9-I9","v":0}]
[]
["Dollar Value of Energy Replaced",null,{"$f":"I34","v":0}]
[]
["Dollar Value of Energy Sold",null,{"$f":"G22","v":0}]