Power Models and Datasets
Forecast Rate Impact by Customer
Results are consistent with the Forecast TRM Billing Determinants Model for BP-14 (TRMbd_BP2014). These results do not include impacts due to Refund Amounts or RSS, or GTA low voltage. Therefore, these results will vary from individual customer rate impacts provided to customers through their Account Executive from BPA's official Rate Impact Model.
Generation and Reserves Dispatch (GARD) Model for the BP-14 Initial Proposal
Rate Analysis Model for BP-14
RSS Model results using BP-14 cost inputs and BP-12 example resource information.
The folder contains the Risk Measures Report, Net Revenue Report, the Model (RevSim) and the Access Database. The Model retrieves inputs to run the calculations iteration by iteration.
RevSim is an Excel 2010 based model. Much of the logic is VBA code (Visual Basic for Applications); the user does not need to know VBA to run the model. The user should save the RevSim Model and the Access Database in the same directory folders. To run the model, the user first clicks on open database button in the UI tab of the model. A dialog window opens to the directory where the model is saved and the user clicks on the "Access Database" to open it. When the dialog window closes, the user clicks on the "Run All Iterations" buttons and the model will run through the 3200 iterations saving the results in the StudyResults table in the Access Database.
The model used to produce BP-14 Initial proposal Tier 2 information. This model contains the same information published in the Chapter 3 tables.
The ToolKit is written in Microsoft Excel 2003. Much of the logic is in VBA code (Visual Basic for Applications); some knowledge of VBA would be helpful for someone trying to understand how the ToolKit works. Before running the ToolKit to recalculate TPP, open the two accompanying input files (“NORM …” and “RM…”).
TRM Billing Determinants Model