Sign In
BP-14 Models and Datasets

Power Models and Datasets

  • Public Rate Impacts
  • Rate Analysis Model for BP-14
  • REP Refund Model
  • RevSim Model
    • 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.
  • RSS Model
  • Tier 2 Pricing Model
  • TOCAs
  • The ToolKit
    • 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
Transmission Models and Datasets