Power Models and Datasets
Public Rate Impacts
Rate Analysis Model for BP-20
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.
Tier 2 Pricing Model
TRM Billing Determinants Model
Power Revenue Requirement Model