Sign In
​Models and Datasets

Power Models and Datasets

Public Rate Impacts

Rate Analysis Model for BP-20

RevSim Model

The RevSim model collection contains the NSR Model (separated by fiscal year), the 4h10c Calculator, the Transmission Expense Model, and the Risk Measures Report (an output summary file).
 
RevSim is an R based model for which BPA maintains a parallel Microsoft Excel® 2016 version. This Excel RevSim version (named NSR_Model_FY20 and NSR_Model_FY21) performs identical calculations as the R version, and is provided here due to the wide accessibility of the Microsoft Office Suite of products. The workbook is completely self-contained and allows access to every RevSim calculation and input that BPA uses in the calculation of forecast Net Secondary Revenue.
 
The 4h10c Calculator (4h10c_Calculator_BP20FP) is a Microsoft Excel® 2016 workbook that forecasts BPA’s 4h10c credit for fish mitigation activities. The model is self-contained and encompasses all data and calculations necessary to arrive at BPA’s forecast 4h10c credit.
 
The Transmission Expense Model (TxExpModel_BP20FP) is a Microsoft Excel® 2016 workbook model that utilizes distributions of data to forecast BPA’s transmission expenses under various conditions. The model is self-contained and encompasses all data and calculations necessary to arrive at BPA’s forecast of transmission expenses.

RSS Model

Tier 2 Pricing Model

TOCAs

TRM Billing Determinants Model

Power Revenue Requirement Model

Transmission Models and Datasets

Customer Impact Model

Transmission Revenue Requirement Model

​Joint Power and Transmission Models and Datasets

The ToolKit

The ToolKit is written in the open-source statistical programming language R (http://www.r-project.org/). This model is used to assess the effect of risks and risk mitigation tools on Power and Transmission Reserves for Risk.

P-NORM is a Microsoft Excel® spreadsheet with the @RISK® add-in from Palisade Corporation (www.palisade.com).  P-NORM can be run or interpreted only on computers with licensed copies of @RISK installed.  To run P-NORM, open P-NORM in excel and open @Risk. An @Risk tab should appear in the Excel® menu bar. Click the @Risk tab, set ‘Iterations’ to 3200, ‘Simulations’ to 1 and click ‘Start Simulation’. Results of a simulation used as input for the Toolkit model can be viewed in the ‘Output’ tab. 

T-NORM is a Microsoft Excel® spreadsheet with the @RISK® add-in from Palisade Corporation (www.palisade.com). T-NORM can be run or interpreted only on computers with licensed copies of @RISK installed. To run T-NORM, open T-NORM in excel and open @Risk. An @Risk tab should appear in the Excel® menu bar. Click the @Risk tab, set ‘Iterations’ to 3200, ‘Simulations’ to 1 and click ‘Start Simulation’. Results of a simulation used as input for the Toolkit model can be viewed in the ‘output’ tab.