╨╧рб▒с>■  a■   ■   `                                                                                                                                                                                                                                                                                                                                                                                                                                                  ═╔└с░┴т\p Marc Pfeiffer B░a└= Ьп╝=x[;№!8 @Н"╖┌1╚ Р╦Arial1╚ Р╦Arial1╚ Р╦Arial1╚ Р╦Arial1╚ ╝╦Arial1а Р╦Arial1 Р╦Arial1Ё ╝╦Arial1Ё ╝╦Arial1╚ Р╦Arial1╚$Р╦Arial1╚ Р╦Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)д0.0 е0.0% ж"$"#,##0 з0.0000_) и0.00_)й"Yes";"Yes";"No"к"True";"True";"False"л"On";"On";"Off"]м,[$м -2]\ #,##0.00_);[Red]\([$м -2]\ #,##0.00\)рї  └ рї  Ї└ рї  Ї└ рї  Ї└ рї  Ї└ рї  Ї└ рї  Ї└ рї  Ї└ рї  Ї└ рї  Ї└ рї  Ї└ рї  Ї└ рї  Ї└ рї  Ї└ рї  Ї└ р └ р+ї  °└ р)ї  °└ р,ї  °└ р*ї  °└ р Ї Ї└ р Ї Ї└ р ї  °└ р └ р└ р └ р └ р └ р @└ р"t!@ @  р $ └ р#0@└ р!0@└ р"4 └ р#p@└ рж"t!@ @  р"t └ р  @ └ р l!@ @ + р l!!@ @ + р  (@└ р  ( @ └ р  l └ р  l └ р  l └ р"t!@ @  р*x@@ р*x  @ р*x@@ р*x  @ рP р └ рP ре"t!!@ @  р(└ р└ р└ р  └ р )└ р (└ УА УА УА УА УА  УА УА УА `Е( InstructionsЕ&▐3EE Contracts if Entity InvestsЕ'@EE Contract if NO Entity InvestЕ▌G RE ContractЕ╡O CalculationsМо┴┴"╛№╬УcBEnergy Efficiency Contracts (If the Public Entity Invests Capital)TotalTax Credits Per Unit ($)Incentives Paid Per Unit ($)Participant Costs (Per Unit)Yearly Incremental Costs Discount RateBaseline Usage (MMBtu) Efficiency Measure Usage (MMBtu)Number of Measures InstalledRetail Electricity Rate ($/kWh)!Retail Natural Gas Rate ($/MMBtu)Total Incentives Recieved ($)InputsOutputsLifetime of MeasuresParticipant BenefitsElectricity Cost SavingsNatural Gas Cost SavingsParticipant CostsNatural Gas SavingsYear Avg. PriceMMBTU Conserved Present ValueYearly Natural Gas SavingsYearly Electricity Savings kWh SavedBaseline Usage (kWh)Efficiency Measure Usage (kWh)Yearly Participant Benefits Tax CreditsIncentives ReceivedCapital Incremental CostsCapital Incremental Costs ($)Yearly Participant CostsParticipant Cost TestBenefit-Cost RatioKEnergy Efficiency Contracts (If the Public Entity Does Not Invests Capital)%Power Purchase Agreement Rate ($/kWh)<Electricity Purchased Through Power Purchase Agreement (kWh)*Length of Power Purchase Agreement (Years)Energy Cost SavingsRenewable Energy Contracts Retail RatePPA RateMeasure Description: Results1Total Electricity Saved by Program per year (kWh)'Electricity Savings per year (Per Unit)2Total Natural Gas Savings Program per year (MMBtu)'Natural Gas Savings per year (Per Unit)Notes:$Yearly Incremental Costs/Savings ($)$1.) Green cells require user input.W3.) If Yearly Incremental Savings are achieved, insert the value as a negavite number.(2.) Red cells should be left unaltered.ESC Yearly Elec BoughtPPA Yearly Elec. BoughtдThe following spreadsheet tabs include calcualtions to determine the energy cost savings and cost effectiveness of energy efficiency and renewable energy contracts.hInstructions below walk the Program Administrator through the tabs of the Workbook to determine savings.ЕEnergy efficiency contracts where the public entity invests capital are projects that are completely financed by the public entity. PBelow are instructions for the information needed in each cell of the worksheet:\2. Lifetime of Measures: The amount of time, in years, that the measure will be in service.43. Estimated Electricity Savings per year (Per Unit)$4. Estimated Total Electricity Saved by Program per Year (kWh): The total amount of electricity that will be saved by the program per year. The total amount of electricity saved is the difference between the baseline and efficiency measure usage per unit, multiplied by the number of units.^5. Retail Electricity Rate ($/kWh): The rate at which the public entity pays for electricity.46. Estimated Natural Gas Savings per year (Per Unit)cBaseline Usage (kWh): The amount of yearly natural gas that is used by the measure being replaced.xEfficiency Measure Usage (kWh): The amount of yearly natural gas that is used by the efficient measure being installed.7. Estimated Total Natural Gas Saved by Program (MMBtu): The total amount of natural gas that will be saved by the program per year. The total amount of natural gas saved is the difference between the baseline and efficiency measure usage per unit, multiplied by the number of units.`8. Retail Natural Gas Rate ($/MMBtu): The rate at which the public entity pays for natural gas.w9. Tax Credits Per Unit ($): The total amount of tax credits received by the public entity for each measure installed.m10. Total Incentives Received ($): The total amount of rebates and incentives received by the public entity.А11. Incentives Received Per Unit ($): The amount of rebates and incentives received by the public entity per measure installed.*12. Estimated Participant Costs (Per Unit)?13. Discount Rate: A nominal discount rate of 8% will be used.ц1. Number of Measures Installed: The total number of measures that are being installed in the facility. For example, if it is a lighting project and there are 30 lighting units being installed, the number of measures will be 30. '1.) 'EE Contracts if Entity Invest' Tab5Energy efficiency contracts where the public entity does not invest capital are projects that are financed by a third party and the public entity negotiates a energy savings contract where they agree to purchase a specific amount of energy at a reduced rate while using specified energy efficiency measures. p1. Length of Energy Savings Contract (Years): The total amount of time that the power purchase agreement spans.^2. Retail Electricity Rate ($/kWh): The rate at which the public entity pays for electricity.Т3. Energy Savings Contract Rate ($/kWh): The rate at which the public entity agrees to pays for electricity through the power purchase agreement.Ц4. Electricity Purchased Through Energy Savings Contract (kWh): The amount of electricity purchased through the power purchase agreement power year.>5. Discount Rate: A nominal discount rate of 8% will be used.Renewable energy contracts are projects that are financed by a third party and the public entity negotiates a power purchase agreement where they agree to purchase a specific amount of energy at a reduced rate while using specified renewable energy measures. y1. Length of Power Purchase Agreement (Years): This is the total amount of time that the power purchase agreement spans.f2. Retail Electricity Rate ($/kWh): This is the rate at which the public entity pays for electricity.Ы3. Power Purchase Agreement Rate ($/kWh): This is the rate at which the public entity agrees to pays for electricity through the power purchase agreement.Ю4. Electricity Purchased Through Power Purchase Agreement (kWh): This is the amount of electricity purchased through the power purchase agreement power year.>5. Discount Rate: a nominal discount rate of 8% will be used.*2.) 'EE Contracts if NO Entity Invest' Tab3.) 'RE Contract' Tab4.) 'Calculations' Tab`This tab calculates the savings and cost-effectiveness of the progams and should not be altered.И b.) Efficiency Measure Usage (kWh): The amount of yearly electricity that is used by the efficient measure being installed.t a.) Baseline Usage (kWh): The amount of yearly electricity that is used by the measure being replaced. a.) Capital Incremental Costs ($): The total additional upfront cost of purchasing the efficiency measures. For example, if a standard light bulb costs $1 and an efficient light bulb costs $5, the incremental cost for the efficient light bulb is $4.░ b.)Yearly Incremental Costs ($): The total additional yearly cost, or savings, of operating and maintaining the efficiency measures. For example, an efficient HVAC system requires additional maintenance time compared to a standard system, which must be accounted for and monetized. Also, efficient lighting may require less cleaning than regular lighting, so this must be accounted for and entered as a negative cost. j╛ и Ўz ╚e╤с/╝ *x╘" .| UгД!╥P$Юcc  ═╔└ 7-┴0y3  d№йё╥MbP?_*+ВА% Б┴ &CDRAFTГДM*HP LaserJet 1200 Series PCL▄LCяАъ odXXLetter    DINU"LJ4ХSMTJHP LaserJet 1200 Series PCLInputBinFORMSOURCERESDLLUniresDLLPaperSizeLETTEROrientationPORTRAITOptimizeForPLAINResolutionOption1HalftoneHT_PATSIZE_AUTOEconomodeOption1б"CXXр?р?U} t7  h   ■        ¤    ¤     ■№ h¤ ¤ ;¤ <¤ N¤ 9=¤ >¤ :M¤ :?¤ :@¤ :`¤ :_¤ :A¤ :B¤ :C¤ :D¤ :E¤ :F¤ :G¤ :H¤ :I¤ :J¤ :K¤ :a¤ :b¤ :L¤ [¤ ;O;╫:Т  ! " # $■%■& )h*¤+ , - . / 0■1■2 5h6 ¤ ;>!;¤ ":P¤ #:Q¤ $:R¤ %:S¤ &:T¤ )\¤ *;U+;¤ ,;>-;¤ .:V¤ /:W¤ 0:X¤ 1:Y¤ 2:Z¤ 5]¤ 6^╫*zh   >╢@я7  ═╔└ "╓8ъ>p?  d№йё╥MbP?_*+ВА% Б┴ &CDRAFTГДM*HP LaserJet 1200 Series PCL▄LCяАъ odXXLetter    DINU"LJ4ХSMTJHP LaserJet 1200 Series PCLInputBinFORMSOURCERESDLLUniresDLLPaperSizeLETTEROrientationPORTRAITOptimizeForPLAINResolutionOption1HalftoneHT_PATSIZE_AUTOEconomodeOption1б"dXXр?р?U} 7} Т} ╢"h                            ;;J   ¤ ¤ .¤ . /¤ ./¤  ¤ &■Z:¤ ¤ & Z¤ 0¤ & Z3¤ 1¤ %' ZT¤  ¤  ¤  -¤ 2 ¤ 3 !¤ "¤ ¤  -¤ #¤  ¤ #¤ $¤ "#¤ 5#¤ %~ 5 @¤ 0/1¤ ($.*д{¤DDDD¤ )%.,+Мо   DDDD¤ 4¤ 6╫>╠00GGGG@@  ! ¤ 8¤ !7╫D┬0 7  > S >╢@хя7  ═╔└ ∙D\G  d№йё╥MbP?_*+ВА% Б┴ &CDRAFTГДM*HP LaserJet 1200 Series PCL▄LCяАъ odXXLetter    DINU"LJ4ХSMTJHP LaserJet 1200 Series PCLInputBinFORMSOURCERESDLLUniresDLLPaperSizeLETTEROrientationPORTRAITOptimizeForPLAINResolutionOption1HalftoneHT_PATSIZE_AUTOEconomodeOption1б"dXXр?р?U} m7} Т h          ; J    ¤ &¤ . /¤  )¤  -¤ '-¤ (#¤ %~ 5 @¤ 0/ 1¤ )* +{№Z ¤ 4¤ 6¤ 8╫ +/┬   8>╢@х я7  ═╔└ ╤L4O  d№йё╥MbP?_*+ВА% Б┴ &CDRAFTГДM*HP LaserJet 1200 Series PCL▄LCяАъ odXXLetter    DINU"LJ4ХSMTJHP LaserJet 1200 Series PCLInputBinFORMSOURCERESDLLUniresDLLPaperSizeLETTEROrientationPORTRAITOptimizeForPLAINResolutionOption1HalftoneHT_PATSIZE_AUTOEconomodeOption1б"dXXр?р?U} $7} Т h          ; J    ¤ +¤ . /¤  )¤  -¤ '-¤ (#¤ %~ 5 @¤ 0/ 1¤ )* + {№Z¤ 4¤ 6¤ 8╫ +/┬   8>╢@х я7  ═╔└ UyP,ВьТ╧Э  d№йё╥MbP?_*+ВА% Б┴ГДб"  р?р?U} m } ╢ } Т} I }  U┐└6 ¤                            ■   ¤ 7╛ 888¤ 7&╛8888 ¤ 7+╛ 8888¤ 2╛ 333¤ 2*╛2222 ¤  2*╛ 2222¤ ¤ ¤ ¤ ¤ ¤ ,¤ -¤ 9¤  ¤  ¤  ,¤  -¤ :¤ ~ dЯ@ Z . Z Z Z? )Z D└D└ B~ dЯ@ Z Z ZB   ,Z  =(G4-H4)*I4 B~  dЯ@   Z  Z  ZF  0Z D └D └D└ B~ hЯ@% D└'1мZЁ?. Z Z Z? )Z D└D└ B~ hЯ@% D└'1мZЁ? Z ZB   ,Z  =(G4-H4)*I4 B~  hЯ@%   D └'1мZЁ?  Z  ZF 0Z D └D └D└ B~ lЯ@ ╝L  └'1мZЁ?. Z Z Z? )Z D└D└ B~ lЯ@ ╝L  └'1мZЁ? Z ZB   ,Z  =(G4-H4)*I4 B~  lЯ@    ╝ L  └'1мZЁ?  Z  ZF 0Z D └D └D└ B~ pЯ@ . Z Z Z? )Z D└D└ B~ pЯ@  Z ZB   ,Z  =(G4-H4)*I4 B~  pЯ@      Z  ZF 0Z D └D └D└ B~ tЯ@ . Z Z Z? )Z D└D└ B~ tЯ@  Z ZB   ,Z  =(G4-H4)*I4 B~  tЯ@      Z  ZF 0Z D └D └D└ B~ xЯ@  . Z Z Z? )Z D└D└ B~ xЯ@   Z  ZB   ,Z  =(G4-H4)*I4 B~  xЯ@      Z  ZF 0Z D └D └D└ B~ |Я@   .   Z Z Z?  )Z D └D └ B~ |Я@      Z   ZB   ,Z  =(G4-H4)*I4 B~ |Я@       Z   ZF  0Z D └D └D └ B~ АЯ@   .   Z Z Z?   )Z D └D └ B~ АЯ@      Z   ZB   ,Z  =(G4-H4)*I4 B~ АЯ@       Z   ZF   0Z D └D └D └ B~ ДЯ@   .   Z Z Z?   )Z D └D └ B~ ДЯ@      Z   ZB   ,Z  =(G4-H4)*I4 B~ ДЯ@       Z   ZF   0Z D └D └D └ B~ ИЯ@   .   Z Z Z?   )Z D └D └ B~ ИЯ@      Z   ZB   ,Z  =(G4-H4)*I4 B~ ИЯ@       Z   ZF   0Z D └D └D └ B~ МЯ@  .   Z Z Z?   )Z D └D └ B~ МЯ@     Z  ZB   ,Z  =(G4-H4)*I4 B~ МЯ@       Z   ZF   0Z D └D └D └ B~ РЯ@ . Z Z Z?  )Z D└D└ B~ РЯ@  Z ZB   ,Z  =(G4-H4)*I4 B~  РЯ@      Z  ZF  0Z D └D └D└ B~ ФЯ@ . Z Z Z? )Z D└D└ B~ ФЯ@  Z ZB   ,Z  =(G4-H4)*I4 B~  ФЯ@      Z  ZF 0Z D └D └D└ B~ ШЯ@ . Z Z Z? )Z D└D└ B~ ШЯ@  Z ZB   ,Z  =(G4-H4)*I4 B~  ШЯ@      Z  ZF 0Z D └D └D└ B~ ЬЯ@ . Z Z Z? )Z D└D└ B~ ЬЯ@  Z ZB   ,Z  =(G4-H4)*I4 B~  ЬЯ@      Z  ZF 0Z D └D └D└ B~ аЯ@ . Z Z Z? )Z D└D└ B~ аЯ@  Z ZB   ,Z  =(G4-H4)*I4 B~  аЯ@      Z  ZF 0Z D └D └D└ B~ дЯ@ . Z Z Z? )Z D└D└ B~ дЯ@  Z ZB   ,Z  =(G4-H4)*I4 B~  дЯ@      Z  ZF 0Z D └D └D└ B~ иЯ@ . Z Z Z? )Z D└D└ B~ иЯ@  Z ZB   ,Z  =(G4-H4)*I4 B~  иЯ@      Z  ZF 0Z D └D └D└ B~ мЯ@ . Z Z Z? )Z D└D└ B~ мЯ@  Z ZB   ,Z  =(G4-H4)*I4 B~  мЯ@      Z  ZF 0Z D └D └D└ B~ ░Я@ . Z Z Z? )Z D└D└ B~ ░Я@  Z  ZB   ,Z  =(G4-H4)*I4 B~  ░Я@      Z ZF 0Z D └D └D└ B¤ #2  %└└n¤ # 7  % └ └n¤  #  %└└n¤ * Z%└└B ¤ *   Z% └ └B ¤  * Z%└└B ¤ 2╛ 333¤ ¤ ¤ ¤ ~ dЯ@ Z. ZZZ? )Z D└D└ B~ hЯ@% D└№йё╥MbЁ?. ZZZ? )Z D└D└ B~ lЯ@  ╝0L  └№йё╥MbЁ?. ZZZ? )Z D└D└ B╫@K1D^^─.gЯ┤8дм  ! " # $ % & ' ( ) * + , - . / 0 1 2 3 5 6■7 8 9 : < =¤> ? ~ pЯ@ ! .   ZZZ?  )Z D └D └ B~ !tЯ@!" .!! ZZZ?!  )Z D!└D!└ B~ "xЯ@"# ."" ZZZ?"! )Z D"└D"└ B~ #|Я@#$ .## ZZZ?#" )Z D#└D#└ B~ $АЯ@$% .$$ ZZZ?$# )Z D$└D$└ B~ %ДЯ@%& .%% ZZZ?%$ )Z D%└D%└ B~ &ИЯ@&' .&& ZZZ?&% )Z D&└D&└ B~ 'МЯ@'( .'' ZZZ?'& )Z D'└D'└ B~ (РЯ@() .(( ZZZ?(' )Z D(└D(└ B~ )ФЯ@)* .)) ZZZ?)( )Z D)└D)└ B~ *ШЯ@*+ .** ZZZ?*) )Z D*└D*└ B~ +ЬЯ@+, .++ ZZZ?+* )Z D+└D+└ B~ ,аЯ@,- .,, ZZZ?,+ )Z D,└D,└ B~ -дЯ@-. .-- ZZZ?-, )Z D-└D-└ B~ .иЯ@./ ... ZZZ?.- )Z D.└D.└ B~ /мЯ@/0 .// ZZZ?/. )Z D/└D/└ B~ 0░Я@03 .00 ZZZ?0/ )Z D0└D0└ B1¤ 2#2-{¤ %0└└n¤ 3*3> Z%0└└B ¤ 52╛ 5333¤ 6¤ 6¤ 6 ¤ 6~ 7dЯ@%77 ZZ%7: ZZ?70 )Z D7└D7└ B8¤ 9#9  %77└└n¤ :*: Z%77└└B ¤ <4╛ <444¤ =¤ =¤ =!¤ =#~ >dЯ@%>> ZZ%>? ZZ?>7 )Z D>└D>└ B~ ?hЯ@%?@ ZZ??> )Z D?└D?└ B╫@|Dввввввввввввввввв 5<8г 5<8г@ A B C D E F G H I J K L M N O P Q S T ~ @lЯ@%@A ZZ?@? )Z D@└D@└ B~ ApЯ@%AB ZZ?A@ )Z DA└DA└ B~ BtЯ@%BC ZZ?BA )Z DB└DB└ B~ CxЯ@%CD ZZ?CB )Z DC└DC└ B~ D|Я@%DE ZZ?DC )Z DD└DD└ B~ EАЯ@%EF ZZ?ED )Z DE└DE└ B~ FДЯ@%FG ZZ?FE )Z DF└DF└ B~ GИЯ@%GH ZZ?GF )Z DG└DG└ B~ HМЯ@%HI ZZ?HG )Z DH└DH└ B~ IРЯ@%IJ ZZ?IH )Z DI└DI└ B~ JФЯ@%JK ZZ?JI )Z DJ└DJ└ B~ KШЯ@%KL ZZ?KJ )Z DK└DK└ B~ LЬЯ@%LM ZZ?LK )Z DL└DL└ B~ MаЯ@%MN ZZ?ML )Z DM└DM└ B~ NдЯ@%NO ZZ?NM )Z DN└DN└ B~ OиЯ@%OP ZZ?ON )Z DO└DO└ B~ PмЯ@%PQ ZZ?PO )Z DP└DP└ B~ Q░Я@%QT ZZ?QP■)Z DQ└DQ└ B¤ S#S9  %>Q└└nT¤ T*TS Z%>Q└└B ╫,Я |zzzzzzzzzzzzzzzzzz5┬H       %>3 DQ: T B>╢@)))хJ    55<<я7bb ■ рЕЯЄ∙OhлС+'│┘0╝HPdx Р Ь и┤ф cottrela cottrelaMicrosoft Excel@АЖh*у┴╔@3╘RЧ╔@J2,у┴╔■ ╒═╒Ь.УЧ+,∙о04 PXh pxАИ Р фRutgers'  InstructionsEE Contracts if Entity Invests EE Contract if NO Entity Invest RE Contract Calculations  Worksheets  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNO■   QRSTUVW■   YZ[\]^_■   ¤   ■                                                                                                                           Root Entry         └F└Aз─О▌╔■   Workbook            шЮSummaryInformation(    PDocumentSummaryInformation8            X