
If you need additional help, please This email address is being protected from spambots. Since the transition to the eTRM is under way in 2021, we are trying to avoid updating READI © since it would cause considerable confusion.

Since READI © is hard-coded to only show DEER2020 as the latest available update, it will be necessary for READI © users to populate the “Period ends:” field to encompass measures available beyond the default of (as shown), to or beyond. It, along with more details, is available here:Īlternatively, direct access can be achieved using the following login information and a PostgreSQL-driver database tool such as DBeaver: There is an application available to view the contents of both DEER databases-Preliminary Ex Ante Review (PEAR) and ExAnte (EA)-named Remote Ex-Ante Database Interface (READI © ). the PEAR database, which is short for Preliminary Ex Ante Review)įor information on the Avoided Cost Calculator calendar approach, which includes multiple future years, please visit the CPUC website at Cost Effectiveness (ca.gov). Tables: ImpactProfileElec_2022 and ImpactProfileGas_2022.Host Address. Public Username: sptviewer Public Password: deereddev
DBEAVER REVIEW DRIVER
The parameters for these are also uploaded to the PEAR database and viewable using a database viewer such as DBeaver with a PostgreSQL driver and using the following login information: The generalized load shape (GLS) format, posted to the DEER website (), is calendar agnostic and includes older and newer shapes from multiple DEER versions and EM&V studies.
DBEAVER REVIEW ZIP
Most of the historical loadshapes can be found on E3’s website in the preprocessing zip files and also down at the bottom of the page under Load Shape Information: This is all of the lighting usage information currently contained in the PEAR database.

DBEAVER REVIEW UPDATE
For instance, the most recent update was for a T8 linear fluorescent ballast measure for January 1, 2018.

Measure costs in the PEAR and ExAnte databases are no longer maintained. Policy and non-technical questions can be answered here: įAQ Login for Searching DEER website Costs of Measures Data Dictionary DBeaver connection to databases Lighting HOUs Loadshapes READI© Access to DEER databaseĪlthough it appears that a user-specific ID/password combination is needed to log into, all use DEER/2008 for access.
