Enbridge Load Balancing

Concept:

Deliver the MDV (Mean Daily Volume) for each pool on a daily basis. These numbers are provided to us by the utilities. A flat delivery profile with varying consumption results in imbalances. The idea here is to optimize those imbalances by using whichever balancing options result in the most positive/least negative financial impact.

Monthly Documents & Meetings:

1. Load Balancing Strategy – Data available on the 9th of each month
2. Load Balancing Strategy Meeting
3. Load Balancing Summary – Check with finance for deadlines
4. Load Balancing SharePoint Update

Models: RPMLoad BalancingModels
LB Data
Enbridge Economics
ETT Cost Optimization

Data Gathering:

Note: Data needs to be gathered for each Master Source Agreement The following process will need to be completed for each MSA. 1. Log into Entrac.
2. Click on BGA Reporting on the left side of the screen.
3. In the drop down menu next to Pool Status, choose Active then hit search.
4. The search result will show a line for each Pool. Next to each Pool Name, select the radio button along with the Report Month and Year (at the bottom of the screen), then click Download. Do this for every pool.
5. Repeat step 3, with Pool Status Finalized. Repeat step 4.
6. Repeat step 3, with Pool Status Expired. Repeat Step 4.
7. Be sure to save Active and Expired files into a newly created BGA folder, and Finalized into another. Zip files and send to forecasting

Data Processing:

Actual Imbalance

Now that the BGA files are in their respective folders, open the most recent version of “LB_Data_MM-DD-YY.xls” which is usually found in last month’s LB folder. Save a copy into this month’s folder. The objective is to organize the data in a way that balancing decisions can be made. Below is how to organize the Enbridge Data.

1. Run the ClearData macro – this will clear out all of last month’s data.
2. On the Manual Inputs tab, fill in all inputs.
3. On the BGA Active tab, hit the green Start button. This will prompt you to open a file – go to the folder where you saved the Active BGA files and select one. The macro will take the information from each file in the folder and summarize it in this model.
4. Repeat step 3 with the Finalized files.
5. Copy data from columns A-V, rows 2 and below. Paste into “Data” tab. In Column W of Data tab, label these rows “Active”.
6. Repeat step 5 with Finalized data. Label rows “Finalized”.
7. On “Pivot” tab, adjust Data Source to ensure data from “Data” tab is reflected correctly.
8. Pivot data by Pool Expiry > Pool Name > MDV > FCBGA Days > FCBGA
(Steps 1-8 are for Enbridge)
9. Get most recent LBB/LBS info from Forecasting, ensure it is profiled by Pool Expiry rather than Delivery Month, and paste into the appropriate location on the Strategy Tab (do this for both Enbridge and Union).
10. Log into Unionline, go to DP Status Summary, and manually punch in both forecasted and actual imbalances by expiry month.
11. Download the report then copy and paste it into the union tab. Manually update the strategy box with these figures.
12. It is important to note that South positions must be dealt with prior to expiry or a penalty will be assigned by Unionline. North positions you have the option of balancing.

Repeat steps 1-12 for whichever business unit you didn’t already do).

The objective is to organize the data in a way that balancing decisions can be made. Below is how to organize the Union Data.

Forecasted Imbalance

Gathering data for the forecasted BGA balances is the next step. We make our LB decisions based on this information.

1. Log into Entrac using the Firefox browser. Needs to be done for all 3 BGA’s
2. Click on Load Balancing on the left hand side of the screen.
3. Select Active and search. Copy and Paste special text into the LB file under LB input data tab.
4. Repeat step 3 for Finalized and Expired
5. Filter the data by pool ID and copy and paste Data into the orange cells of the Working Pivot tab.
6. Pivot this data and move it over to the Strategy tab.
7. Once data is organized paste it into the left box of the strategy tab
8. Ensure all dates, positions, prices are accurate on the Strategy tab. Write commentary describing what you believe is the optimal route to balancing for the month (based on your analysis).
9. Save as PDF. This document will be the basis of the monthly Strategy meetings with DER and DEB.

Enbridge Balancing Framework:

There are a variety of balancing options, each with associated costs (see Enbridge Rate Handbook):

1. Title Transfer
2. Enhanced Title Transfer
3. Suspension
4. Makeup
5. Settle with Enbridge

Interpreting the Data

1. Look for large long or short active pools nearing expiry. Refer to matrix for different actions to take.
2. Once a pool is finalized you have 180 days before you have to sell to Enbridge. Make sure to deal with imbalances 150 days after, or one will not be able to suspend or makeup gas.
3. Try to match up suspension/makeup volume with LBS’s and LBB’s.
4. Pull in the Enbridge prices, market prices for the analysis. Use these prices to help optimize the decision making process for both Empress and CDA.

Reporting:

1. Under the Models folder one can find the Enbridge economics file. Open and refresh the query. Fill in the highlighted spaces. Enbridge sell prices can be found on the Enbridge portal website.
2. In the DEB tab and DER tab add what actions were taken in the month. The prices are pulled from the Economics tab.
3. Breakout balancing by required and discretionary.
4. Update pie charts and include these in the email.