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
- TOCAs (updated 04/28/2021)
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.
