E3: Energy+Environmental Economics
Contact
Projects   |   E3 Energy Planning Tools

Energy Efficiency Calculator
Following E3's development of an avoided cost calculation methodology in R.04-04-025, E3 developed the "Calculator", used by all California investor-owned utilities to compute the cost-effectiveness of energy efficiency programs.

2013-2014 E3 Calculator Files (updated)
Southern California Gas [SoCal 2013 v1c5.xlsm] (3/24/2015)
Southern California Edison [SCE 2013 v1c6.xlsm] (3/24/2015)

Draft 2013-2014 Avoided Cost Updates
Draft Avoided Cost Calculator files with New Methodology [2011 Avoided Cost Update.zip] (9/20/11)
PG&E pre-processing files [PG&E Pre-processing.zip]- (9/13/2011)
SCE pre-processing files [SCE Pre-processing.zip]- (9/13/2011)
SDG&E pre-processing files [SDG&E Pre-processing.zip]- (9/13/2011)
SoCal pre-processing files [SoCal Pre-processing.zip]- (9/13/2011)
Description of avoided cost and pre-processing files [2011 Update File Descriptions.xlsm]- (9/20/2011)

Draft 2013-2014 E3 Calculator Files
Southern California Gas [SoCal 2013 v1c4-Draft.xlsm]- (6/22/2012)
San Diego Gas and Electric [SDG&E 2013 v1c4-Draft.xlsm]- (6/22/2012)
Southern California Edison [SCE 2013 v1c4-Draft.xlsm]- (6/22/2012)
Pacific Gas and Electric [PG&E 2013 v1c6-Draft.xlsm]- (9/13/2012)
E3 Calculator TechMemo 6d.docx- (11/14/2012)

2010-2012 E3 Calculators with Dual Baselines and Updated April 2010 Avoided Costs
PG&E 10-12 Dual v1g.xlsm- (11/12/2012)
SCE 10-12 Dual v1g.xlsm- (11/12/2012)
SDG&E 10-12 Dual v1g.xlsm- (11/12/2012)
SoCal 10-12 Dual v1g.xlsm- (11/12/2012)
E3 Calculator TechMemo 2010-2012 Dual v1g.docx- (11/12/2012)

2010-2012 E3 Calculators with Updated April 2010 Avoided Costs
Southern California Gas (SoCal 10-12 4g4.zip)- (7/5/2011)
San Diego Gas and Electric (SDG&E_10-12 4g3)- (6/11/2010)
Southern California Edison (SCE_10-12 4g2)- (6/11/2010)
Pacific Gas and Electric (PG&E_10-12 4g5) - (8/17/2010)
E3 Calculator TechMemo 5d.doc (4/7/2011)

2009-2011 E3 Calculators with Updated April 2010 Avoided Costs
Southern California Gas (SoCalGas_09-11 4g2)- (5/6/2010)
San Diego Gas and Electric (SDG&E_09-11 4g3)- (5/21/2010)
Southern California Edison (SCE_09-11 4g2)- (5/6/2010)
Pacific Gas and Electric (PG&E_09-11 4g3) - (8/17/2010)

April 2010 Update.  Avoided cost spreadsheets and pre-processing examples
E3 Calculator 2010 update v2 -(8/17/2010)
DEER2008-NLS-PGE-v3 - (8/13/2010)
Gas Model 9_5-5-10 - (8/13/2010)
PG&E Hourly Costs -(8/13/2010)
PG&E ComCalc TOU_5-4-10 - (8/13/2010)
PG&EResCalc TOU_5-4-10 - (8/13/2010)
PG&E Gas_5-5-10 - (8/13/2010)
Gas update 5-4-10 - (8/13/2010)
PG&E PreProc_8-16-10 -(8/17/2010)
cpucAvoided26-1_update MPR 2009 eac_5-3-10 -(8/13/2010)

E3 Energy Efficiency Calculators - Utility Planning Versions for 2010-2012
Southern California Gas (SoCalGas_2010-12 v.1h) (3MB ZIP) - (11/10/2009)
San Diego Gas and Electric (SDG&E_2010-12 v. 1i) (7MB ZIP) - (11/13/2009)
Southern California Edison (SCE_2010-12 v. 1) (13MB ZIP) - (10/22/2009)
Pacific Gas and Electric (PG&E_2010-12 v. 1) (8MB ZIP) - (10/22/2009)
Release 1g Notes - (11/13/2009)

E3 Calculators - Utility Planning Versions for 2009-2011 – (1/7/09)
Pacific Gas and Electric (PG&E_Plannertou 1f) (7.0MB ZIP)
San Diego Gas and Electric (SDG&E_Plannertou(800) 1d2) (6.75MB ZIP)
Southern California Edison (SCE_Plannertou(1000) 1e2) (13.0MB ZIP)
Southern California Gas (SoCal_Plannertou 1d2) (3.0MB ZIP)

E3 Calculators - Utility Planning Versions for 2009-2011
Updated 8/12/08
Pacific Gas and Electric (PG&E_Plannertou 1c4) (7.2MB ZIP)
San Diego Gas and Electric (SDG&E_Plannertou(800) 1c2) (6.5MB ZIP)
Southern California Edison (SCE_Plannertou(1000) 1b2) (12.9MB ZIP)
Southern California Gas (SoCal_Plannertou 1b2) (2.7MB ZIP)
Avoided cost and discount rates changes (doc)

Draft 2009-2011 Planning Tools
Updated 5/13/08
Pacific Gas and Electric (PG&E Planner 1a) (2.4MB ZIP)
Southern California Edison (SCE Planner 1a) (2.3MB ZIP)
Southern California Gas (SoCal Gas Planner 1a) (2.3MB ZIP)
San Diego Gas and Electric (SDG&E Planner 1a) (2.2MB ZIP)

Draft E3 Calculators for 2009-2011 Program Planning
Updated 4/9/08
Note that the values contained in the draft E3 calculators do not incorporate the ongoing DEER updates or M&V work. The eventual updates may change measure benefits significantly.

Pacific Gas and Electric (PG&E Tool 5c) (9.3MB ZIP)
Southern California Edison (SCE Tool 5d (1000)) (9MB ZIP)
Southern California Edison (SCE Tool 5d (2000)) (14.8MB ZIP)
San Diego Gas and Electric (SDG&E Tool 5c (800)) (5.6MB ZIP)
Southern California Gas (SoCal Tool 5c) (2MB ZIP)
Version 5 Technical Memo (DOC)

E3 Calculators For 2006-2008 ERT-Versions Corrected to extend gas benefits past 2024 (1/22/2010)
Pacific Gas and Electric (PG&E Tool 4d) (9.30MB ZIP)
Southern California Edison (SCE Tool 4d2 (1000))(8.97MB ZIP)
Southern California Gas (SoCal Tool 4d (800))(14.9MB ZIP)
San Diego Gas and Electric (SDG&E Tool 4d2(800)) (3.6MB ZIP)

E3 Calculators in Compliance with Decision 07-09-043.
Updated 9/22/08
Pacific Gas and Electric (PG&E Tool 4c) (9.30MB ZIP)
Southern California Edison (SCE Tool 4a (1000))(9MB ZIP)
Southern California Edison (SCE Tool 4b (1000))(8.97MB ZIP)
Southern California Edison (SCE Tool 4b (2000))(14.9MB ZIP)
San Diego Gas and Electric (SDG&E Tool 4c) (3.6MB ZIP)
San Diego Gas and Electric (SDG&E Tool 4c (800)) (5.3MB ZIP)
Southern California Gas (SoCal Tool 4c) (2.10MB ZIP)
Southern California Gas (SoCal Tool 4c (800)) (5.0MB ZIP)
06-08 Revision Notes (DOC)
Summary of version 4 changes (DOC)
E3 Calculator Technical Memo 4a (DOC)

Updated 10-1-07
San Diego Gas and Electric (SDG&E Tool 3c7) (3.60MB ZIP)
Southern California Gas (SoCal Tool 3c6) (2.10MB ZIP)

Updated 7-10-07
Pacific Gas and Electric (PG&E Tool 3c3) (9MB ZIP)
Southern California Edison (SCE Tool 3c3) (15MB ZIP)
E3 Calculator Tech Memo (.6MB DOC)

QA/QC Workshop Presentation (11-16-06)
E3 review of Calculator inputs and DEER database values (0.11MB PPT)

Recently Updated Calculators (2006)
Pacific Gas and Electric (PG&E Tool 3b5. Updated 9/6/06) (5.99MB ZIP)
Southern California Edison (SCE Tool 3b4) (8.80MB ZIP)

Documents to comply with Ordering Paragraph 17
Updated Technical Memo describing the E3 Calculator inputs, outputs, and calculations (version 3b2) (543kB DOC)
Summary of E3 Calculator changes (26kB DOC)
E3 Calculator update comments and IOU update changes (Revision 1, updated 9/15/06) (49kB DOC)
SDG&E workshop and meeting notes

Avoided Cost Update Report - April 10, 2006
Supplement to 2006 Update Report (per 4/03/06 Ruling)
(140kB DOC)

E3 Update Report (897kB DOC)
Attachment 1 (148kB PPT)
Attachment 2 (64kB PDF)
Attachment 3 (27kB PDF)

Workshop Materials and Presentation - March 14 & 15, 2006
Purpose and Scope of 2006 Update (per 12/27/2005 ALJ ruling)
(28kB DOC)

March 14th and 15th Presentations (153kB PPT)

Updated PG&E 'E3 Calculator' - January 26, 2006
PG&E Tool 2d3 (36MB XLS)

January 23rd, 2006 Presentation
Issues Summary (524kB PPT)

October 3rd and 4th Agenda and Presentations

Workshop Materials
Agenda (96kB DOC)
EE Avoided Cost Review (687kB PPT)
Oct 3rd Afternoon (183kB PPT)
Oct 4th Materials (50kB PPT)
Oct. 4th DR Avoided Cost Presentation (147kB PPT)

Load Shape Information
UPDATED Load Shape Information available by utility (Oct. 25th). Note that PG&E Non-residential information did not change.
SCE Residential (85kB XLS)
SCE Non-Residential (439kB XLS)
SDG&E (113kB XLS)
PG&E Residential Viewer (5MB XLS)
PG&E Non-Residential Viewer - Same file as in previous non-residential viewer. (26MB ZIP)

Load Shape Information available by utility. No longer current.
SCE Residential (76kB XLS)
SCE Non-Residential (253kB XLS)
SDG&E (255kB XLS)
PG&E Viewer Tools (28MB ZIP)

Draft Cost-effectiveness and Evaluation Calculator. These are NOT current copies.

Draft cost-effectiveness evaluation tools that incorporate the hourly avoided costs by climate zone are now available (below).

The tools allow users to calculate the Total Resource Cost and Program Administrator Cost results for programs implemented in PG&E's service territory. (PG&E funded the tools, hence their current focus on PG&E's service territory). There are separate calculator tools for residential and non-residential measures. Each tool is designed to minimize the computational burden for users. The tools come pre-loaded with avoided cost benefits and load impacts for energy efficiency measures by climate zones. Users need only to select the measure and climate zone (or users may select "system"), input some program details and measure per unit costs, and supply an implementation schedule.

The tools are posted in draft form and are non-binding. PG&E and E3 retain all rights to the tools and documentation. Both PG&E and E3 reserve the right to modify the tools in the future. These tools are being provided only for informational purposes to aid the April 18, 2005 workshop discussions. Any other use or modification of the tools or tool documentation, is prohibited. Downloading the files indicates acceptance of these conditions.

Walkthrough Presentation - from 4-18-2005. (57kB PPT)
Workshop Topic: Hourly vs TOU Avoided Costs - from 4-18-2005. (326kB PPT)
Residential cost-effectiveness tool documentation. (261kB DOC)
Non-residential cost-effectiveness tool documentation. (200kB DOC)
Residential cost-effectiveness tool with PG&E measure impact data. (6.6MB XLS)
Non-residential cost-effectiveness tool with PG&E measure impact data. (8.6MB XLS)
Climate zone mapping documentation. (492kB DOC)

Document Archive +

Avoided Cost Update Report - April 10, 2006
Supplement to 2006 Update Report (per 4/03/06 Ruling) (140kB DOC)
E3 Update Report (897kB DOC)
Attachment 1 (148kB PPT)
Attachment 2 (64kB PDF)
Attachment 3 (27kB PDF)
Workshop Materials and Presentation - March 14 & 15, 2006

Purpose and Scope of 2006 Update (per 12/27/2005 ALJ ruling) (28kB DOC)

March 14th and 15th Presentations (153kB PPT)

Updated PG&E 'E3 Calculator' - January 26, 2006
PG&E Tool 2d3 (36MB XLS)

January 23rd, 2006 Presentation
Issues Summary (524kB PPT)

October 3rd and 4th Agenda and Presentations

Workshop Materials
Agenda (96kB DOC)
EE Avoided Cost Review (687kB PPT)
Oct 3rd Afternoon (183kB PPT)
Oct 4th Materials (50kB PPT)
Oct. 4th DR Avoided Cost Presentation (147kB PPT)

Load Shape Information

UPDATED Load Shape Information available by utility (Oct. 25th). Note that PG&E Non-residential information did not change.

SCE Residential (85kB XLS)
SCE Non-Residential (439kB XLS)
SDG&E (113kB XLS)
PG&E Residential Viewer (5MB XLS)
PG&E Non-Residential Viewer - Same file as in previous non-residential viewer. (26MB ZIP)

Load Shape Information available by utility. No longer current.
SCE Residential (76kB XLS)
SCE Non-Residential (253kB XLS)
SDG&E (255kB XLS)
PG&E Viewer Tools (28MB ZIP)

Draft Cost-effectiveness and Evaluation Calculator. These are NOT current copies.

Draft cost-effectiveness evaluation tools that incorporate the hourly avoided costs by climate zone are now available (below).

The tools allow users to calculate the Total Resource Cost and Program Administrator Cost results for programs implemented in PG&E's service territory. (PG&E funded the tools, hence their current focus on PG&E's service territory). There are separate calculator tools for residential and non-residential measures. Each tool is designed to minimize the computational burden for users. The tools come pre-loaded with avoided cost benefits and load impacts for energy efficiency measures by climate zones. Users need only to select the measure and climate zone (or users may select "system"), input some program details and measure per unit costs, and supply an implementation schedule.

The tools are posted in draft form and are non-binding. PG&E and E3 retain all rights to the tools and documentation. Both PG&E and E3 reserve the right to modify the tools in the future. These tools are being provided only for informational purposes to aid the April 18, 2005 workshop discussions. Any other use or modification of the tools or tool documentation, is prohibited. Downloading the files indicates acceptance of these conditions.

Walkthrough Presentation - from 4-18-2005. (57kB PPT)
Workshop Topic: Hourly vs TOU Avoided Costs - from 4-18-2005. (326kB PPT)
Residential cost-effectiveness tool documentation. (261kB DOC)
Non-residential cost-effectiveness tool documentation. (200kB DOC)
Residential cost-effectiveness tool with PG&E measure impact data.(6.6MB XLS)
Non-residential cost-effectiveness tool with PG&E measure impact data. (8.6MB XLS)
Climate zone mapping documentation. (492kB DOC)