READI (Remote Ex-Ante Database Interface)

Overview of READI

READI (the Remote Ex-Ante Database Interface) is a program that allows users to examine the CPUC's databases of ex ante measure information. With the READI program you can:

  • Browse and examine the ex-ante data tables.
  • Find existing DEER and non-DEER measure definitions.
  • Find and examine the Technologies that are used in the measure definitions.
  • Examine the deemed energy impacts associated with measures in tables and graphs.
  • Download data tables to your computer as workbook or CSV files.
  • Create and Save new measures based on existing Scaled measure definitions.

READI provides access to the current official ex ante database as well as the latest data being reviewed by the ex ante review team. The official ex ante database includes DEER data (starting with DEER2011) as well as non-DEER data available for claims. The best practices database includes proposed changes and additions to the official ex ante database. For more information on the best practices database see the best practices web page. View the "About" screen in the READI help section for notes on program and database updates (or click here).

Program Installation
Download the latest version of READI and save the ZIP file to your computer. Open the ZIP file and extract or copy the three files inside to any directory on your computer. If your computer is not behind a corporate firewall and you are not required to use an SSL connection, the only file you need is the READI executable file. Double-click on the READI executable file to start the program.

If you would rather not deal with the ZIP file and are allowed to download executable files to your computer (many ISPs and IT departments do not allow this), you can download the executable archive of READI. Once downloaded, double-click on the file and the self-extracting archive will prompt you for a location to extract the program files to. Remember where you had the files extracted and double-click on the READI executable file to start the program.

To remove READI from your computer, merely delete the downloaded archive file and any copies you made. READI does not write to your computer's registry and does not require an uninstall procedure.

Technical Information
The READI program requires an internet connection to work. Some users, especially those behind a firewall at work, need to ask their IT department to allow READI to access the internet. Here are some technical details that the IT department may need to allow READI to work:

  • READI connects to an Amazon RDS (relational database server) over port 5432; the host URL is pointed to by DEEResources.org.
    • the host address is cpucexante.ckf6g5zciihg.us-east-1.rds.amazonaws.com;
    • the IP address currently resolves to 52.70.42.254 which can change if Amazon switches to a back-up server (should be a rare occurrence).
    • READI versions 2.3 and earlier connected to a different server located at 23.21.178.114;.corporate firewall rules that allowed connections to the earlier IP address may need to be updated to allow connections to the new IP address.
  • READI creates a directory in the users AppData\Roaming directory called "READI_2.4". READI stores the users connection information and preferences in this directory.
  • READI does not employ any "cookie" technology to track users.
  • An SSL (Secure Sockets Layer) connection is optional and by default is not used. To turn on SSL follow these steps:
    • If presented with the log-in dialog box because READI could not connect, check the “require SSL connection” checkbox.
    • If already connected to the database, double-click on the bottom status bar to bring up the log-in dialog box and then check the “require SSL connection” checkbox.
    • Once specified, READI will use the selected SSL option for future connections.
    • If not already included in your Windows version, the two DLL files included with the READI installation ZIP file will need to be in the same directory as the READI program

Users who are authorized to add comments to select tables must log-in with their credentials by double-clicking on the status bar on the bottom of the program screen.

Archive Version of DEER2011 and DEER2014

DEER2011 and DEER2014 data are included in the current ex ante database. As of 1-June-2016 access to the original DEER2011 and DEER2014 databases is no longer available.


Questions about DEER database and READI: This email address is being protected from spambots. You need JavaScript enabled to view it.