BPA Power Services
Link to BPA Home Page Skip Primary Navigation
Power Services Home Page


Models Used for the 2002 Final Power Rate Proposal

Rate Analysis Model (RAM)

(web page posted on June 8 , 2000)

Summary: The RAM consists of five linked spreadsheet models (RAM_Prog_c.xls, RAM_7b2_c.xls, ResexRAM02_c.xls, EAF01_05_c.xls, and input_c.xls) that perform the calculations necessary to develop BPA's wholesale power rates.

Contact Person: Bill Doubleday, BPA Power Business Line, (503) 230-7570, wjdoubleday@bpa.gov

Electronic Files Currently Available: [ Notes: The 7 files below have a combined size of approximately 4.7 MB. You can download all of these files in a single compressed (self-extracting) file (.EXE file, 1.4 MB). After this file has been downloaded to a folder on a local drive, it can be decompressed by double-clicking on the file. If your web browser is configured to open PDF and/or Excel files within the browser, you can view each individual file below by clicking on the linked file name with your left mouse button. To download an individual file to a local drive, click on the linked file name with your right mouse button and select "Save Target As..."]

  1. Description of RAM Models
    RAM_Description_c.pdf (7 kb, posted June 8, 2000)

  2. Steps for Running RAM
    Running_RAM_c.pdf (8 kb, posted June 8, 2000)

  3. RAM Program Case
    RAM_Prog_c.xls (Excel 97, 1147 kb, posted June 8, 2000)

  4. RAM 7b2 Case
    RAM-7b2_c.xls (Excel 97, 591 kb, posted June 8, 2000)

  5. Residential Exchange RAM
    ResexRAM02_c.xls (Excel 97, 1479 kb, posted June 8, 2000)

  6. Energy Allocation Factor Model
    EAF01_05_c.xls (Excel 97, 627 kb, posted June 8, 2000)

  7. Input for RAM
    Input_c.xls (Excel 97, 476 kb, posted June 8, 2000)

Archive of content originally posted or last updated on:  June 8, 2000.
Content originally provided by:  Greg Gustafson, BPA Power Business Line.
Content provided by:  Greg Gustafson, 503-230-5820, gcgustafson@bpa.gov.
Page maintained by:  BPA Web Team.
Skip to start of content.  Access Key = C
Skip to short cut links below
Skip to start of content.  Access Key = C If you believe information on this site is missing or in error, please Submit that comment here.
NOTICE: This server is owned and operated by the Bonneville Power Administration, United States Department of Energy. Use of this system is monitored by system and Security personnel. Anyone using this system consents to MONITORING of this use by system or security personnel.