Sign In
BP-16 Models and Datasets
Power Models and Datasets
  • Public Rate Impacts
  • Rate Analysis Model for BP-16
  • 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
  • Transmission Rates Study Documentation
Please note that the customer forecasts shared for generation input products (OR, RFR, VERBS, and DERBS) are scaled to match the forecasts agreed upon for use in the Gen Inputs settlement. 
  • Transmission Segmentation Study Documentation
  • Transmission Risk Analysis Model (TRAM)
      • TRAM is a Microsoft Excel® spreadsheet with the @RISK® add-in from Palisade Corporation (www.palisade.com).  TRAM can be run or interpreted only on computers with licensed copies of @RISK installed.  To run TRAM, open TRAM 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 can  be viewed in the ‘Output Tables’ tab.