Beta This is a new website — your feedback will help us improve it.

Frequently Asked Questions

What are single and dual baseline measures?

A baseline is the reference point that efficient technologies are compared against to determine the amount of savings they produce.

When a new, more efficient measure is installed to replace an existing measure that has reached the end of its life, the savings from the new efficient measure are calculated using an established code or other standard as the baseline for the entirety of the life of the new measure. That is considered a single baseline measure.

When a new, more efficient measure replaces an existing measure that was not yet at the end of its life, the new measure is considered to cause early retirement of the existing measure. For the remaining useful lifetime of the measure that was retired early, the new, more efficient measure savings are calculated using the existing measure as the baseline. That is the first baseline of a dual baseline measure. After the expected lifetime of the measure that was retired ends, the savings from the new, more efficient measure is calculated using an established code or other standard. That is the second baseline of a dual baseline measure.

What is the CET?

CET stands for the Cost Effectiveness Tool. It is a public database created by the California Public Utility Commission (CPUC) that calculates cost effectiveness metrics including Total Resource Cost (TRC) that the CPUC uses to evaluate the cost effectiveness of programs. The CPUC provides an online user interface to run data through the CET and receive results back as part of the CPUC CEDARS web application .

The CET accepts input data that detail how and where measures are installed, including unit energy savings, quanities, and costs. The CET runs those inputs through calculation scripts including pulling in transmission and distribution rates and other factors to output cost effectiveness metrics, savings, and CO2, NOx, and PM10 emission reduction for the described activities.

What is DEER?

DEER stands for the Database of Energy Efficiency Resources. It is a public database created by the California Public Utility Commission (CPUC) that provides estimated energy savings for efficiency measures.

DEER includes many value lists that the CPUC requires when submitting data to the CPUC Cost Effectiveness Tool (CET). Please visit the CPUC DEER website for more information about DEER.

What file types can I upload to My Data Chameleon?

My Data Chameleon can read files in the following formats:

Why couldn't My Data Chameleon process my worksheet?

There two common reasons this might happen are:

If the worksheet does contain measure or program cost data, you can help My Data Chameleon recognize it by:

What columns headings should I include for measure uploads?

Column Heading Description Alternative Column Headings
Record ID A unique identifier for the measure.
  • CEInputID
Program ID The program identifier.
  • PrgID
Quarter The year and quarter when the measure is expected to be claimed in the format 2021Q2.
  • ClaimYearQuarter
Sector The setting where the measure will be installed.
Delivery type How the program will deliver this measure to the customer. This field combines answers to questions: Is the measure delivered upstream or downstream of the customer? Is the measure custom or deemed? Will the measure be directly installed? Those answers inform which option to select.
Building type The type of building where the measure will be added. For forecast data, the value Any may be used.
  • BldgType
Climate zone The climate zone for the location where the measure will be installed.
  • E3ClimateZone
Gas savings profile Whether gas savings occur across the year or only in the summer.
  • E3GasSavProfile
Gas sector Whether the gas savings will occur in a residential or commercial setting. For small and medium business customers choose Core; other commercial customers should use Commercial.
  • E3GasSector
End use The electricity consumption profile for the measure across a year.
  • E3MeaElecEndUseShape
Target sector The area where the electricity will be consumed. This field is more detailed than the other measure sector fields; for example, instead of a general commercial sector you would specify that the measure is being used in a restaurant or grocery store.
  • E3TargetSector
Application type How the measure is applied. Most common is NR (Normal Replacement). Metered measures are not allowed to use new construction. Only accelerated replacement measures can have dual baseline data.
  • MeasAppType
Measure code A short name for the measure.
  • MeasCode
Measure description A more verbose and detailed description of the measure.
  • MeasDescription
Measure impact type The measure impact type answers a suite of characterizations about the measure. Is it a fuel substitution measure? Is the measure custom or deemed? If deemed, is the measure from DEER or a workpaper? If custom, is it a normalized metered energy consumption (NMEC) measure? If so, is it population level or site level NMEC? If not, is the custom measure generic (i.e. site specific), a randomized control trial (RCT), or strategic energy management (SEM)?
  • MeasImpactType
Measure ID For workpaper measures concatenate together the Program administrator, Workpaper, Measure code, Climate zone, Building type, Building Vintage, Measure Application type, and Delivery type. This allows the measure to be reconciled with the workpaper it references. For non-workpaper measures leave this field blank.
  • MeasureID
Technology group A general category for the measure technology.
  • TechGroup
Technology type A specific category for the measure technology.
  • TechType
Use category A general category for how the measure is used.
Use subcategory A specific category for how the measure is used.
Preexisting measure description A description of the pre-existing measure that was replaced.
  • PreDesc
  • Preexisting Measure
Standard measure description A description of the standard measure as defined by building codes.
  • StdDesc
  • Standard Measure
Workpaper The workpaper ID for the measure, if applicable. Non-workpaper measures leave blank.
  • SourceDesc
Savings type For deemed measures, whether the measure comes from DEER or a workpaper (aka ExAnte) and the year of the source. Other measures should leave this field blank.
  • Version
Units The unit described by the quantity.
  • NormUnit
Quantity The quantity of measures installed.
  • NumUnits
Unit savings (first baseline) (kW) The first baseline kW unit savings.
  • Unit savings 1B kW
  • UnitkW1stBaseline
Unit savings (first baseline) (kWh) The first baseline kWh unit savings.
  • Unit savings 1B kWh
  • UnitkWh1stBaseline
Unit savings (first baseline) (therm) The first baseline gas (therm) unit savings.
  • Unit savings 1B therm
  • UnitTherm1stBaseline
Unit savings (second baseline) (kW) The second baseline kW unit savings. Application type must be AR for second baseline data to be specified.
  • Unit savings 2B kW
  • UnitkW2ndBaseline
Unit savings (second baseline) (kWh) The second baseline kWh unit savings. Application type must be AR for second baseline data to be specified.
  • Unit savings 2B kWh
  • UnitkWh2ndBaseline
Unit savings (second baseline) (therm) The second baseline gas (therm) unit savings. Application type must be AR for second baseline data to be specified.
  • Unit savings 2B therm
  • UnitTherm2ndBaseline
Unit cost—measure (first baseline) The first baseline unit measure cost.
  • Unit cost 1B
  • UnitMeaCost1stBaseline
Unit cost—measure (second baseline) The second baseline kWh unit savings. Application type must be AR for second baseline data to be specified.
  • Unit cost 2B
  • UnitMeaCost2ndBaseline
Unit cost—installation labor Only used when delivery type is direct install; otherwise should be zero. For direct install measures this should be the unit incentive for labor.
  • UnitDirectInstallLab
Unit cost—installation materials Only used when delivery type is direct install; otherwise should be zero. For direct install measures this should be the unit incentive for materials.
  • UnitDirectInstallMat
Unit cost—user rebate Only used for downstream delivery types; otherwise should be zero. For downstream measures this should be the unit rebate to the customer.
  • UnitEndUserRebate
Unit cost—other incentive Only used for midstream and upstream delivery types; otherwise should be zero. For midstream and upstream measures this should be the unit rebate to the retailer, distributor, dealer, or manufacturer.
  • UnitIncentiveToOthers
Net to gross ID The ID for the net to gross ratio.
  • NTG_ID
Net to gross (kW) The net to gross ratio for the kW savings.
  • NTGRkW
  • NTG kW
Net to gross (kWh) The net to gross ratio for the kWh savings.
  • NTGRkWh
  • NTG kWh
Net to gross (therm) The net to gross ratio for the gas (therm) savings.
  • NTGRTherm
  • NTG therm
Net to gross cost The net to gross ratio for the cost.
  • NTGRCost
  • NTG Cost
Estimated useful life ID The ID for the estimated useful life selected for the measure.
  • EUL_ID
Estimated useful life years The estimated useful life in years for the measure.
  • EUL_Yrs
Remaining useful life ID The ID for the estimated useful life selected as the remaining useful life for the measure. This field is not required. Application type must be AR for RUL data to be specified.
  • RUL_ID
Remaining useful life years The remaining useful life in years of the measure that was retired early. Must be less than the EUL; is expected to be not more than EUL divided by 2.75. Application type must be AR for RUL data to be specified.
  • RUL_Yrs
Gross savings installation adjustment ID The ExAnte savings and installation adjustment ID. This field is not required.
  • GSIA_ID
Realization rate (kW) The fraction of kW savings expected; this number multiplied against the unitized kW savings and quantity to calculate total savings. Realization rates are only used for custom measures; for deemed measures this should be one.
  • RealizationRatekW
Realization rate (kWh) The fraction of kWh savings expected; this number multiplied against the unitized kW savings and quantity to calculate total savings. Realization rates are only used for custom measures; for deemed measures this should be one.
  • RealizationRatekWh
Realization rate (therm) The fraction of gas (therm) savings expected; this number multiplied against the unitized kW savings and quantity to calculate total savings. Realization rates are only used for custom measures; for deemed measures this should be one.
  • RealizationRateTherm
Installation rate (kW) The fraction of kW savings expected; this number multiplied against the unitized kW savings and quantity to calculate total savings. Installation rates are only used for deemed measures; for custom measures this should be one.
  • InstallationRatekW
Installation rate (kWh) The fraction of kWh savings expected; this number multiplied against the unitized kW savings and quantity to calculate total savings. Installation rates are only used for deemed measures; for custom measures this should be one.
  • InstallationRatekWh
Installation rate (therm) The fraction of gas (therm) savings expected; this number multiplied against the unitized kW savings and quantity to calculate total savings. Installation rates are only used for deemed measures; for custom measures this should be one.
  • InstallationRateTherm
Residential True if the measure is installed in a residential setting; otherwise false.
  • Residential_Flag
  • Is residential
Upstream True if the measure is delivered upstream of the customer; otherwise false.
  • Upstream_Flag
  • Is upstream
Program administrator The code for the program administrator.
  • PA
Market effects (benefits) CET field to specify measure-level market effects benefits, overrides CET default
  • MarketEffectsBenefits
Market effects (costs) CET field to specify measure-level market effects costs, overrides CET default
  • MarketEffectsCosts
Rate schedule (electric) This field is used for claim reporting; for forecast data it should be left blank.
  • RateScheduleElec
Rate schedule (gas) This field is used for claim reporting; for forecast data it should be left blank.
  • RateScheduleGas
Combustion type This field is used for claim reporting; for forecast data it should be left blank.
  • CombustionType
Measure inflation This field is used for claim reporting; for forecast data it should be left blank.
  • MeasInflation
Comments Any comments related to the measure record. For workpaper based records, any deviance from the approved workpaper values should be explained and justified here.

What columns headings should I include for program cost uploads?

Column Heading Description Alternative Column Headings
Program ID The program identifier.
  • PrgID
Year The year when the measure record is expected to be claimed.
  • PrgYear
General Administrative Costs and Overhead Program-level Administration costs, overhead, and general administration (E3 field, see E3 manual for complete definition)
  • AdminCostsOverheadAndGA
Other administrative costs Program-level Other administration costs (E3 field, see E3 manual for complete definition)
  • AdminCostsOther
Marketing and Outreach Program-level Marketing outreach costs (E3 field, see E3 manual for complete definition)
  • MarketingOutreach
Direct implementation activity Direct implementation activity costs (E3 field, see E3 manual for complete definition)
  • DIActivity
Direct implementation installation Direct implementation installation costs (E3 field, see E3 manual for complete definition)
  • DIInstallation
Direct Implementation Hardware and materials Direct implementation hardware and materials costs (E3 field, see E3 manual for complete definition)
  • DIHardwareAndMaterials
Direct Implementation Rebate and Inspection Direct implementation rebate and inspection costs (E3 field, see E3 manual for complete definition)
  • DIRebateAndInspection
Evaluation Measurement and Verification Evaluation, measurement, and verification costs (E3 field, see E3 manual for complete definition)
  • EMV
User input incentive Program-level incentive rebates (E3 field, see E3 manual for complete definition)
  • UserInputIncentive
On bill financing Program-level On-bill financing (E3 field, see E3 manual for complete definition)
Costs recovered from other sources Program-level Costs recovered from other sources (E3 field, see E3 manual for complete definition)
Program administrator The Program administrator code
  • PA