Proposed Reference System Plan

ALJ Ruling

Modeling Results Files and RESOLVE Model, 9/19/2017

Attachment A: Proposed Reference System Plan (pdf)

Attachment B: RESOLVE Inputs and Assumptions (pdf) 

RESOLVE Inputs and Assumptions with redlines (pdf)

Attachment C: Summary of Model Inputs and Outputs (xlsx)

Attachment D: Summary of Sensitivity Analyses Conducted by Staff in Response to Party Comments (pdf)

Attachment E: Production Cost Modeling Process to Review Integrated Resource Plan Portfolios: Staff Proposal (pdf)

RESOLVE User Manual (pdf)

RESOLVE Excel-based User Interface (xlsx) This file is also included in the .zip file below but is linked here for the convenience of those who do not want to download the entire model package.

RESOLVE Post-Processing Air Pollution and DAC Analysis (xlsx)

RESOLVE Model and Results Package (zip)
Warning: This is a very large file (about 2.5 GB) and may take several hours to download and/or decompress. If you have trouble downloading the file, please try using a different browser. The file decompresses to about 26+ GB and contains these components:
• RESOLVE Python code
• Excel-based User Interface
• Excel-based Results Viewer
• Excel-based Dispatch Viewer
• Raw inputs data files
• Raw results data files
• Text files to facilitate porting data to production cost models
IMPORTANT: When decompressing this file, the user must retain the exact folder hierarchy reflected in the .zip file - otherwise the Python code and Excel macros will not be able to locate files.

Disclaimer: The core of the RESOLVE model is written in the Python scripting language. This model was created by E3 and was adapted for use in the CPUC’s Integrated Resource Planning proceeding under the administration of CPUC’s Energy Division. The E3 RESOLVE Model is free software under the terms of the GNU Affero General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.

The CPUC is distributing the RESOLVE Model in the hope that it will be useful, however:
No warranty of any kind, implied, expressed, or statutory, including but not limited to the warranties of non-infringement of third party rights, title, merchantability, fitness for a particular purpose, and freedom from computer virus, is given with respect to the RESOLVE software including its Python scripts, the web page hosting the resolve software or hyperlinks to other Internet resources

References or links in the web site hosting the RESOLVE model to any specific commercial products, processes, or services, or the use of any trade, firm, or corporation name are for the information and convenience of the public, and do not constitute endorsement, recommendation, or favoring by the CPUC, or its employees or agents. E3 and the CPUC bear no responsibility for the consequences of any modifications to the model, including its Python scripts, whether intentional or unintentional.

The Python scripts of the RESOLVE model, as distributed by the CPUC, are uniquely identified by the following hashes (checksums). Please consult with your information technology professional for information regarding how to help assure the provenance of your code using the data below.


 RESOLVE Model Python Script

 Hash (Checksum) using SHA256








Any errors or omissions should be reported for investigation to CPUC Energy Division staff Patrick Young at



Immigration Guide