# Presentation: 043353

## Database Transfer Process

- 7

## Facilitates Regional Planning for FERC, WGA, Members; Fits with Reg. Plan. Proc.
Coordinated & Consistent Data for Regional & Sub-Regional Studies
Consistent with WECC, Regulatory Data, IRPs etc.
Studies compare apples to apples
Argue over assumptions and results, not data
Data Ownership by All Stakeholders
Partnership with WECC & CREPC, Coordinated
Development & validation efforts equitably shared
Portable: Usable on various models
Visible:  Typical data, not confidential, encumbered, or proprietary, publicly available
Transparent:  No “Black Boxes”, expansion info available to all
Data Improvements during use Reciprocal
Advancements returned to SSG-WI as condition of use
Advancements centralized, not fragmented..Community
Periodic Updates and Maintenance

**Coordinated & Consistent Data for Regional & Sub-Regional Studies**
- Consistent with WECC, Regulatory Data, IRPs etc.
- Studies compare apples to apples
- Argue over assumptions and results, not data
**Data Ownership by All Stakeholders**
- Partnership with WECC & CREPC, Coordinated
- Development & validation efforts equitably shared
- Portable: Usable on various models
- Visible:  Typical data, not confidential, encumbered, or proprietary, publicly available
- Transparent:  No “Black Boxes”, expansion info available to all
**Data Improvements during use Reciprocal**
- Advancements returned to SSG-WI as condition of use
- Advancements centralized, not fragmented..Community
**Periodic Updates and Maintenance**

- Goal is a Regional Planning Database

- 1

## Sources of Typical, Non- Proprietary Data

- 2

## Data & Model Improvements

**Granularity**
**Hydro shaping and hourly model**
**Zone Changes**
**Ownership and Schedules **
**Load Diversity**
**Pricing Pancakes**
**Operational Characteristics**
**Storage Issues**
**Hydro**
**Emission Allowances**
**Fuel Delivery**
**Wind Variability**
**Bidding Behavior**
**Forced Outages**
**Losses**

- 7

## Data Process is Like Baking a Cake

- Understand What’s Needed
- Research for Data Sources
- Collect Raw Data
- Geographic Data
- Calculate Yearly Ave to Hourly Shapes
- Calculate Aggregated to Geographic
- Locate new Load and Generation
- Populate Data Base
- De-Bug Data
- Define Scenarios to Run
- Run Model
- Analysis of Output
- Review and Validation of Results
- Refine Data and Rerun Model
- Develop Conclusions
- Prepare Presentation and Reports
- Review and Approve

- Find & Read Recipe
- Call Grocery Stores
- Buy Ingredients
- Measure Ingredients and mix
- Pour into Pan
- Decide Bake Time
- Set Oven & Bake
- Taste
- Redo if Burned
- Put on Frosting
- Cut & Serve
- Eat

- 3

## Original Data Development Plan

- Understand What’s Needed
- Research for Data Sources
- Collect Raw Data
- Geographic Data
- Calculate Yearly Ave to Hourly Shapes
- Calculate Aggregated to Geographic
- Locate new Load and Generation
- Populate Data Base
- De-Bug Data
- Define Scenarios to Run
- Run Model
- Analysis of Output
- Review and Validation of Results
- Refine Data and Rerun Model
- Develop Conclusions
- Prepare Presentation and Reports
- Review and Approve

- PWG
- PWG
- PWG
- WECC
- PWG
- PWG
- PWG
- PWG & **PAC**
- PWG
- PWG
**PAC (est. 8 per-wks)**
- PWG
- PWG
- PAC
- PWG
- PWG
- PWG

- 4

## Actual ProcessPAC Data Effort 47 per-wks

- Understand What’s Needed
- Research for Data Sources
- Collect Raw Data
- Geographic Data
- Calculate Yearly Ave to Hourly Shapes
- Calculate Aggregated to Geographic
- Locate new Load and Generation
- Populate Data Base
- De-Bug Data
- Define Scenarios to Run
- Run Model
- Analysis of Output
- Review and Validation of Results
- Refine Data and Rerun Model
- Develop Conclusions
- Prepare Presentation and Reports
- Review and Approve

**PAC**
**PAC**
**PAC**
- WECC
**PAC**
**PAC**
**PAC**
**PAC**
**PAC**
- PWG
**PAC** & CaISO
**PAC**
- PWG
**PAC**
- PWG
- PWG
- PWG

- 5

## Need for DatabaseTransfer Now

**Plan was **
**SSG-WI to carry forward process**
**to package and transfer data at end of study and after SSG-WI process set up**
**Receiving time critical requests now**
**WestConnect**
**CERA**
**NCPA**
**Need to avoid proliferation of conflicting/competing data bases**
**Need to avoid duplication of effort**
**Need to quickly fill vacuum and form regional, transparent, public information database to facilitate expansion, planning, and analysis**
**The clock is ticking, fences are being built**

- 7

## Agreement

**SSG-WI will agree that it’s their responsibility to perform Economic Regional Planning Studies and coordinate with Sub Regional Planning Groups. **
**SSG-WI will establish a Data Development & Management Process to “Carry Forward” & Steward a Regional Planning Data Base (as described in previous slides).**
- SSG-WI will develop budgets, distribution policies, support organization, and procedures.
- SSG-WI will recommend to and obtain Emerging RTO approvals
**Upon entering satisfactory agreement to perform above, PAC will transfer present Data Base to SSG-WI.****	**
**Implementation of Data Process by March 2004**
**SSG-WI to steward data process for at least three years**

- 6

## Transfer Process Paperwork

_**Concept Paper and Options Paper**_
**Info for SSG-WI Reps for ASAP decision**
**Options Paper to screen & bracket forward cost exposure. Not necessary now to pick one.**
_**Transfer Agreement**_** - ****Agreement between PAC and SSG-WI to transfer data:**
**Agree to be responsible for economic planning**
**Agree to pick an option of SSG-WI’s choice and implement by 3/31/ 2004**
**Agree to perform for 3 years with remedy for non-performance**
**Agree on conditions for license to third parties**
_**License Agreement**_**  - ****Agreement template for SSG-WI to use with third parties for use of data:**
**Advancements or improvements returned to SSG-WI as condition of use**
**If for public use and disclosure to others**
**SSG-WI to determine any reasonable charges  **

- 7

## 1. Consulting Firm hired annually to perform entire study
2. WECC:  SSG-WI to employ WECC to provide either database, database management, or full database and studies annually
3. SSG-WI to hire full or part time staff to facilitate database management and process
4. Missionary Approach: Emerging RTO organizations and Members voluntary donate and perform  

_**2. WECC**_:  SSG-WI to employ WECC to provide either database, database management, or full database and studies annually
_**3.**__ __**SSG-WI**_ to hire full or part time staff to facilitate database management and process
_**4.**__ __**Missionary Approach**_: Emerging RTO organizations and Members voluntary donate and perform

- Database Management Options

- 8

## Local Stakeholder Involvement and Review
Representative rep at Regional Level
Localized and “Micro” Visibility of Costs and Benefits for facilitation of Financing and Implementation
Closer to Jurisdictional, LSE, and Consortium Organization
Sub Regional Projects Identified and Fit with Regional Projects, Schedules, and Markets

- Representative rep at Regional Level
- Localized and “Micro” Visibility of Costs and Benefits for facilitation of Financing and Implementation
- Closer to Jurisdictional, LSE, and Consortium Organization
- Sub Regional Projects Identified and Fit with Regional Projects, Schedules, and Markets

- Sub Regional Planning

- 8

## SSG-WI

- Rocky Mtn

- NW RTO

- CaISO

- W.Connect

- 9

## SSG-WI

- NTEP

- STEP

- ITEP

- RTEP??