# Explanation of postings:

There are nine documents posted. One is an Excel 2007 document (.xlsx
extension) and has over 175,000 rows so cannot be viewed in its entirety
with older versions of Excel. The rest were saved backward compatible
with Excel 2003. The Excel 2007 document simply combines the calculated
numbers from each of the individual month documents, so the data is
still available to older versions of Excel, it will just take more
downloading to get it.

## Documents

The four documents named '\[month\] data final.xls' and '\[month\] data
final no formulas.xls' contain the respective month's data. The
timestamp denotes the period in which the data was downloaded. On Sheet
1 of each of those documents is the one-minute average BPA Area Load
data for each of the years from 2006 through 2010. The load was
increased by 1.5% each year (our standard estimate). The wind was
increased to 1700 for 2007, 2700 for 2008, 4200 for 2009 and 6300 for
2010. These numbers denote the amount of wind that is estimated to be
installed by the end of each year, so when working on the 2009 rate
case, we are using the numbers from the 2008 columns.

The columns labeled wind + load are not correctly labeled; it should
read Load -- wind. Those columns equal the area load for that row minus
the total wind for that row using their respective years.

This is the extent of the data in the files with 'no formulas' in the
name. We did this in order to have smaller files for downloading, these
are between 12 and 15 megabytes versus 63 to 70 megabytes for the ones
with formulas.

Sheet 2 of the four spreadsheets with formulas contains the hourly
average of the load and load minus wind. Following those columns are the
calculations for regulation with just load, regulation with load minus
wind, then load following with just load and load following with load
minus wind. A percentile distribution of those columns follows.

## Increase in Wind

The wind was increased using as much of the 3Tier mesoscale model of the
Klondike/Arlington area as possible. The new wind was added using the
delays in the model then applying a multiplier equaling new wind farm
capacity over the installed wind farm capacity, the capacity of the
installed wind farm used as the starting point for the delay. Here are
the numbers used, all names of wind farms have been removed:

Wind Farm 1: 100 Mw, 10 minutes before Wind Farm A

Wind Farm 2: 100 MW, 20 minutes before Wind Farm A

Wind Farm 3: 125 MW, 50 minutes before Wind Farm A

Wind Farm 4: 125 MW, 40 minutes before Wind Farm A

Wind Farm 5: 32 MW, same time as Wind Farm B

Wind Farm 6: 225 MW, 20 minutes after Wind Farm C

Wind Farm 7: 150 MW, 30 minutes before Wind Farm A

Wind Farm 8: 126 MW, 10 minutes before Wind Farm D

END OF 2007

Wind Farm 9: 100 MW, same time as Wind Farm D

Wind Farm 10: 150 MW, 10 minutes before Wind Farm D

Wind Farm 11: 75 MW, 20 minutes after Wind Farm C

Wind Farm 12: 200 MW, 10 minutes before Wind Farm D

Wind Farm 13: 70 MW, 120 minutes before Wind Farm C

Wind Farm 14: 200 MW, 20 minutes after Wind Farm C

Wind Farm 15: 100 MW, 20 minutes after Wind Farm A

Wind Farm 16: 50 MW, same time as Wind Farm A

END OF 2008

Wind Farm 17: 120 MW, 10 minutes before Wind Farm D

Wind Farm 18: 63 MW, same time as Wind Farm E

Wind Farm 19: 198 MW, 120 minutes before Wind Farm F

Wind Farm 20: 75 MW, 100 minutes before Wind Farm F

Wind Farm 21: 100 MW, 20 minutes before Wind Farm D

Wind Farm 22: 250 MW, 20 minutes after Wind Farm D

Wind Farm 23: 250 MW, 60 minutes before Wind Farm A

Wind Farm 24: 100 MW, 10 minutes after Wind Farm A

Wind Farm 25: 200 MW, 10 minutes after Wind Farm D

Wind Farm 26: 200 MW, same time as Wind Farm D

END OF 2009

Wind Farm 27: 110 MW, 120 minutes after Wind Farm G

Wind Farm 28: 159 MW, 100 minutes before Wind Farm F

Wind Farm 29: 300 MW, 40 minutes before Wind Farm A

Wind Farm 30: 200 MW, 20 minutes after Wind Farm D

Wind Farm 31: 200 MW, 50 minutes after Wind Farm D

Wind Farm 32: 500 MW, 20 minutes after Wind Farm D

Wind Farm 33: 300 MW, 20 minutes after Wind Farm A

Wind Farm 34: 300 MW, 20 minutes after Wind Farm C

END OF 2010