




已阅读5页,还剩38页未读, 继续免费阅读
版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领
文档简介
DraftVersion 2aSept 14 2005Cost Effectiveness Evaluation “Calculator” Tool v. .3b3c2 Quick Guide and Equation Reference (v.3b23c)This document provides a brief guide to the user inputs and outputs. This is followed by a detailed presentation of the equations used by the Calculator Tool. The last section presents a discussion of the data management issues and steps taken in developing the inputs for the tool.Table of ContentsCost Effectiveness Evaluation “Calculator” Tool v. 3c21Quick Guide and Equation Reference (v.3c2)1Summary of Revisions3Inputs Summary3Output8Notes on the Tests and Outputs8Outputs9Output by Measure17Batch Processing19Processing Choice19Input File Rows20Control Tab21Equations22Net July-Sept Peak (CP_kW_N_TOTSmr)22Net Dec-Feb Peak (CP_kW_N_TOTWtr)23Noncoincident Peak (Net NCP)24Noncoincident Peak by Year (NNCPt)24CEC Peak (Net CEC)25Annual Net kWh (Annual_kWh)25Lifecycle Net kWh (Lifecycle_kWh)25Annual Net Therms (Annual_Therms)25Lifecycle Net Therms (Lifecycle_Therms)25Cost Effectiveness (Lifecycle Present Value Dollars)26Cost26TRC Cost (TOTCOSTTRC)26PAC Cost (TotCostPAC)27RIM Cost (TotCostRIM)27Lifecycle Benefit28Electric TRC Benefits (NetPVBenTOTE)28Gas TRC Benefits (NetPVBenTOTG)30Levelized Cost and Benefit32Discounted Electric Reductions (kWhDN)32Discounted Gas Reductions (ThDN)33Levelized Cost33Levelized Benefits34Levelized Benefit Cost34Emissions Reductions36Electric Reductions: CO2 tons per year (EmissionECO2)36Gas Reductions: CO2 tons per year (EmissionGCO2)36Monthly Impacts (IMP_MOX, IMP_MOTh)37Sector and End Use Shape Combinations38Cost Effectiveness Evaluation “Calculator” Tool1Quick Guide and Equation Reference for Version 31Inputs Summary2Output7Notes on the Tests and Outputs7Outputs7Output by Measure14Batch Processing16Processing Choice16Input File Rows17Control Tab18Equations19Net July-Sept Peak (CP_kW_N_TOTSmr)19Net Dec-Feb Peak (CP_kW_N_TOTWtr)20Noncoincident Peak (Net NCP)21Noncoincident Peak by Year (NNCPt)21CEC Peak (Net CEC)22Annual Net kWh (Annual_kWh)22Lifecycle Net kWh (Lifecycle_kWh)22Annual Net Therms (Annual_Therms)22Lifecycle Net Therms (Lifecycle_Therms)23Cost Effectiveness (Lifecycle Present Value Dollars)23Cost23TRC Cost (TOTCOSTTRC)23PAC Cost (TotCostPAC)24RIM Cost (TotCostRIM)24Lifecycle Benefit25Electric TRC Benefits (NetPVBenTOTE)25Gas TRC Benefits (NetPVBenTOTG)27Levelized Cost and Benefit28Discounted Electric Reductions (kWhDN)28Discounted Gas Reductions (ThDN)29Levelized Cost29Levelized Benefits30Levelized Benefit Cost30Emissions Reductions32Electric Reductions: CO2 tons per year (EmissionECO2)32Gas Reductions: CO2 tons per year (EmissionGCO2)32Monthly Impacts (IMP_MOX, IMP_MOTh)33Sector and End Use Shape Combinations3443Summary of RevisionsVersion 3cRebate entries modified to be more explicit between transfer payments and administrative costs.Net to gross ratios can now be entered directly in Column I. Previously the user needed to select a Program Type and the Calculator would use NTG values that were preloaded in a lookup table.Output descriptions updated to reflect measures installed in the year, rather than measures in place during a specific quarter of the year.Inputs SummaryItemLocationCommentProposer NameCell D4Text fieldProgram NameCell D5Text fieldFirst Year of Program ImplementationCell D7Integer (2006-2008). For program year 2006, leave as “2006.”Contact InformationD9:D13Text fieldsMarket SectorsE14:E15Text fields. Only used for PG&E reporting. Do not affect calculations.Program BudgetAdministrative Costs: Overhead and G&AG3Total cost over the program implementation cycle. Entered in nominal dollarsAdministrative Costs: Other Admin CostsG4Total cost over the program implementation cycle. Entered in nominal dollarsMarket/OutreachG5Total cost over the program implementation cycle. Entered in nominal dollarsDirect Implementation:ActivityInstallationHardware & materialsRebate processing and inspectionG7 to G10Total cost over the program implementation cycle. Entered in nominal dollars. These cell entries are for non-incentive related costs. Incentive and rebate information is entered on a per-measure basis or in cell I4.Total Incentives and RebatesG11Not a user entry. Sum of values in Cells I4 to I8EM&VG12Entered in nominal dollars.Costs recovered from other sources.I12Entered in nominal dollars. User Input IncentiveI4Entered in nominal dollars. Use this cell for incentives and rebates that are not calculated on a per unit installed basis. Users should be careful to avoid double counting incentives. If this cell is used, only enter incentive values in columns K M through M P for measures that are not included in this incentive calculation. Note that costs entered in this cell are treated as admin costs (not transfer payments) and are not reduced by the NTG ratio for the TRC calculations.Direct Install RebateI5 to J5Not a user entry. Rebate to end use customer or its assignee. Treated as a transfer payment in the TRC calculations. Nominal and present value totals based on rebates per unit entered in column KM. Note that the value shown in column I is in nominal dollars, and column J is a present value (to reflect the expected timing of the payments). Nominal values are used for program budget reporting and PV is used for the cost effectiveness and levelized cost calculations. Direct Install LaborI6 to J6Not a user entry. Nominal and present value totals based on rebates per unit entered in column KO. See above for further discussion of nominal and PV dollars.Direct Install MaterialsI7 to J7Not a user entry. Nominal and present value totals based on rebates per unit entered in column KP. See above for further discussion of nominal and PV dollars.Upstream PaymentsI8 to J8Not a user entry. Nominal and present value totals based on rebates per unit entered in column N. See above for further discussion of nominal and PV dollars.Program Inputs (Inputs begin in Row 17)Program NameCol ANot a user entry. Hidden text field used in reporting information to the Energy Division.Measure NameCol BText fieldDEER RunIDCol CNumeric filed corresponding to DEER database.Climate zoneCol DSelect from drop-down list. Cannot be left blank. Used to determine the impacts and costs for the measure. System applies the generation and T&D avoided costs from the climate zone with the lowest average generation and transmission avoided capacity cost over 25 years. Note that Climate zone 3 has been subdivided into two subzones. Climate zone 3A is for San Francisco and the Peninsula. Climate Zone 3B is for the East Bay. See the attachment for a complete listing of Cities and Climate Zones.Target SectorCol ESelect from the Drop Down list. This entry is used to determine whether to use a residential or non-residential TOU correction factor where applicable. For the PG&E, SCE and SoCalGas tools, this entry is also used to limit the measure end use shapes listed in the drop down entries in Column F. This entry is not used to constrain measure end use shapes in the SDG&E model, although it is used for reporting purposes.Measure End Use ShapeCol FSelect from the drop-down list. Note that the list of measures can vary depending upon the Target Sector selected in Column E. For PG&E, SCE, and SoCal Gas, this entry will determine if a measure could receive a TOU correction factor adjustment. Having one of the following end use shapes is a necessary, but not sufficient, condition to qualify for the TOU correction adder. In order to receive a TOU correction factor adjustment, a measure must also have a positive entry in column Z % Eligible for TOU AC Adjustment.PG&E: 26 = Res. Central Air Conditioning22 = Res. Ht. Pump Cooling29 = Res. New Const. Cooling33 = Res. Insul. Cen. A/C35 = Res. Ceil. Insul. HP Cooling37 = Res. Wall Insul. HP Cooling39 = Res. Flr. Insul. HP Cooling45 = Res. Dir. Assist. Evap. Cooler3 = Commercial HVAC SCE: AC-NCNew_AC-Ret; AC_Cooling-RCHeatPump_ThroughWall-RCPackage_AC-NC65K_AC_Split-NC135K_Air_AC-NC135K_Wtr_AC-NC135K_Air_AC135K_Wtr_ACNew_ACNew_HtPmpReduce_Cooling_LoadCZ, Sector, Measure combination found?Col GNot a user input. If FALSE, then recheck the measure end use shape drop down list to verify that you have selected a valid measure. Typically, the FALSE warning will appear when the user selects a measure based on a certain Sector, but then changes the Sector without updating the measure choice.Note: This column is not used in PG&Es residential tool or in SDG&Es tool.Measure TypeCol HSelect from drop-down list. This entry is used to determine the Measure Life, based on values in the Program Manual. Users may also specify a life using the “Generic Life” entries at the bottom of the drop down list.Program TypeCol ISelect from drop-down list. This entry is used to determine the Net-to-Gross ratio, based on values in the Program Manual. Version 3c modification: users can now directly enter numeric values in this column.Unit DefinitionCol JNot used by the spreadsheet. For informational purposes only.Program TypeCol KCurrently not used. Intent is to indicate if a measure is used in a new construction (NEW), replace-on-burnout (ROB), or early replacement (retrofit (RET) application to refine cost-effectiveness analyses in the future.Gross Measure CostCol LFor NEW and RET applications, this is the cost of the efficient equipment less the cost of the standard efficiency equipment. Use value in DEER as applicable. Include initial capital costs, including sales tax, ongoing O&M costs including fuel, removal costs less salvage value, and value of customers time in arranging for installation (if significant). For RET applications, this if the full cost of the efficient equipment plus installation costs.For direct install programs, enter the sum of Direct Install Labor and Direct Install Materials (Col O + Col P)Financial Incentive: Rebate to end use customer or its assigneeCol KMPer unit dollar rebates paid to the participant or its assignee by the sponsoring agency. This cost is treated as a transfer payment in the TRC test.Incentives to entities other than the end use customer or its assigneeCol NPer unit incentives. Also referred to as upstream incentives.Financial Incentive: Direct Install LaborCol LOPer unit labor provided to the participant by the proposed Program. Financial Incentive: Direct Install MaterialsCol MPPer unit materials provided to the participant by the proposed Program. Gross Participant Cost (not reduced for transfer payment)Col QNot a user entry. Equals the Gross measure cost less the incentives in columns N, O, and P. Note that the participant cost is NOT reduced for the Rebate entered in Col M. This treatment corrects the application of the net-to-gross ratio to conform to the ALJ ruling.Gross Incremental Measure CostCCol NCost of the efficient equipment less the cost of the standard efficiency equipment. Use value in DEER as applicable. Include initial capital costs, including sales tax, ongoing O&M costs including fuel, removal costs less salvage value, and value of customers time in arranging for installation (if significant). For direct install programs, enter the sum of Direct Install Labor and Direct Intall Materials (Col L + Col M)Note that if the sum of the three Financial Incentives columns exceeds the Gross Incremental Measure Cost, those entries will be flagged with red cell shading. This is for informational purposes only. Calculations are not affectedGross Unit Annual Electricity SavingsCol ORAnnual net kWh reduction attributable to the installation of one unit of the measure.Electric Rate ScheduleCol PSSelect from drop-down list. Used to determine revenue loss for RIM test.Demand Scale FactorCol QTNot a user input. Indicates “kWh” if capacity savings are calculated using annual kWh reductions, or “kW” if capacity savings are calculated using summer peak kW reductions.Summer Peak kW Savings per unitUser entered kW savings per unitCol RUSummer peak period kW reduction attributable to installation one unit of the measure. Used for reporting kW reductions. Only requiredAlso used for cost effectiveness calculations if Col Q T indicates “kW.” Otherwise, the cell is grayed out, indicating no input is neededthat the value is not used for the cost-effectiveness calculations (except for SDG&E). SDG&E reports “DEER kW” which uses the values entered in Col R, regardless of whether the cell is grayed out. For SDG&E, enter kW impact estimates from DEER even if the cell is grayed out.)Gross Unit Annual Gas SavingsCol SVAnnual net therms reduction attributable to the installation of one unit of the measure.Gas SectorCol TWSelect from the drop-down list. Used to determine the gas avoided costs to apply to the measure.Note: This column is not a user input in PG&Es residential tool.Gas Rate ScheduleCol UXSelect from drop-down list. Used to determine revenue loss for RIM test. Note: This column is not a user input in PG&Es residential tool.Gas Savings ProfileCol VYSelect from the drop-down list. Used to determine the gas avoided costs to apply to the measure. 1. Summer Only: All gas savings occur in April through September.2. Winter Only: All gas savings occur in October through March3. Annual: Gas savings occur uniformly throughout the year.Placeholders, not currently usedCol Z to ACCurrently not used. Intent is to combine this information with indications if a measure is used in a new construction (NEW), replace-on-burnout (ROB), or early replacement (retrofit (RET) application to refine cost-effectiveness analyses in the future.Combustion TypeCol WADDetermines the rate of emission savings per MMBTU of reduced natural gas usage from gas conservation. (lbs of CO2, NOX, and PM-10). Not a user input for PG&E. Not used for SCE. Select from a drop down list for SDG&E and SoCalGas. Res Furnace is used as a default if there is no user selection. Effective Useful LifeCol XAEDetermined For PG&E and SCE, determined by the spreadsheet, based on Measure Type. For SDG&E and SoCal Gas, the numeric value is entered directly in this column.Net to-Gross RatioCol YAFDetermined by the spreadsheet, based on Program Type or the numeric user entry in column I.% Eligible for TOU AC AdjustmentCol ZAGUser input between 0 and 100%, with 100% for those cases where the entire measure receives the AC TOU correction factor. Note that the measure will not receive a correction factor adjustment for PG&E, SCE, or SoCalGas if the measure end use shape does not qualify (see discussion for Col F above).Installation ScheduleInstallations by YearCol AA AH to Col AGANUsed by SCE, SDG&E and SoCalGas. The annual installations are assumed to occur uniformly over the 4 quarters in each year.Installations by QuarterCol AI AP to Col BJBQ.User input for PG&E only, SDG&E, and SoCal gas. All others areSCE allocated allocates units based on the annual installations in the prior columns. Number of incremental units installed by the end of the quarter. For simplicity, and end of quarter (rather than mid-quarter) convention is used. For example, Q1 2006 would have all units installed at midnight on 3/31/2006. Q2 2006 would have all units installed on 6/30/2006. This convention of “units installed at the end of the quarter” results in slightly conservative estimates of benefits, as programs could be installed up to three months prior to recognition of their savings. Compared to a “middle of the quarter” convention, this approach results in present values that are 1.5% lower. As the same convention applies to both costs and benefits, the impact on net benefits or benefit cost ratios is likely negligible.Total Number of UnitsCol BKBRNot a user entry.CommentsCol BLBSFor informational purposes only. Not used in the calculations.Output Notes on the Tests and OutputsTotal Resource Cost Test (With externalities)ItemCommentTax Credits (TC)No explicit input for tax credits. Levelized benefits per kWh Uses Net discounted kWh to correspond to Net benefits (NTG ratio adjusted)OutputsItemLocationCommentTotal Program BudgetD4 to E4Total of all program budget items, including rebates and incentives. D4 is total nominal dollars, E4 is the NPV. Note that only the per unit costs are present valued. The lump sum admin costs are not adjusted unless a value less than 1.0 is entered in cell J1 of the INPUT tab.Incentives and Rebates ($nominalTransfers)D5 to E5Nominal total incentives and rebates. Total rebates to end users or their assignees. These are already included in the Total Program Budget in D4 or E4, as well as the Net participant cost (not reduced for rebates) shown in Cells D6 and E6. The Rebate costsy are shown separately so that they can be removed from the TRC test to prevent double counting. Column D is nominal, column E is present value.Incentives and Rebates ($PV)E5Present value of total incentives and rebates.Net Incremental MeasureParticipant CostD6 to E6Present value of participant
温馨提示
- 1. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
- 2. 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
- 3. 本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
- 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
- 5. 人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
- 6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
- 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
最新文档
- 2025房产买卖居间合同
- 2025新版独家代理合同书范本
- (高清版)DB13∕T 2935-2019 扬尘在线监测系统建设及运行技术规范
- 生物高中必修第四章第二节 基因对性状的控制 教学设计
- 2023-2024学年山东省济宁市泗水县统编版一年级下册期末考试语文试卷
- 第15课《驿路梨花》第二课时(教学设计)-七年级语文下册同步备课系列(部编版)
- 农户间农业生产互助合作合同
- 《高二年级历史古代政治制度演变教学方案》
- 乡村环保与土地整治承包协议
- 《古诗文经典诵读:古代诗词赏析教学计划》
- 河南省2022-2023学年七年级下学期语文期末试卷(含答案)
- 雾化吸入团体标准解读
- MOOC 质量工程技术基础-北京航空航天大学 中国大学慕课答案
- 【数字人民币对货币政策的影响及政策探究12000字(论文)】
- 江苏省盐城市大丰区2023-2024学年八年级上学期期中数学试题(解析版)
- 卫生监督协管培训课件
- 2.3.5 重力坝扬压力计算示例讲解
- 医学高级职称-肾内科学(医学高级)笔试(2018-2023年)真题摘选含答案
- 高校资助育人系列活动方案
- 商铺租赁意向书范本
- 青岛版四年级下册-三 快乐农场-运算律【市一等奖】
评论
0/150
提交评论