Spreadsheet: phillip_platter__31372__ca0912epmib
Sheet: MCP

California PX  PRICES
 |  |  | DO NOT DELETE FORMULAS
Hour | UMCPDA | Volume | POST CONGESTION ZONAL PRICES |  |  |  |  |  |  |  |  | INTERIM | FINAL | INTERIM | FINAL | INTERIM | FINAL | INTERIM | FINAL | INTERIM | FINAL | INTERIM | FINAL | INTERIM | FINAL |  |  | 30 | 112 | 177 |  |  |  | 240
 |  |  | NP15 | SP15 | ZP26 | AZ3 | AZ2 | LC1 | NW1 | NW3 |  | NP/ZPsp/np | NP/ZPsp/np | path 26 | path 26 | nob | nob | MEAD | MEAD | COB | COB | SYLMAR | SYLMAR | CASCADE | CASCADE |  |  | mon | tues | wed | PATH15 _BG |  | PATH26 _BG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 304 | 893.89 | 845.33 | 1795.03 |  | 1147.03 |  | 856
1 |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  | 249.92003 |  | 0.00982 |  |  |  |  |  |  |  |  |  |  |  | 386.97 | 896.38 | 1004.34 | 1880.03 |  | 1147.03 |  | 856
2 |  |  |  |  |  |  |  |  |  |  | 2 | 0 |  | 249.92003 |  | 0.00982 |  |  |  |  |  |  |  |  |  |  |  | 660.39 | 896.81 | 1154.03 | 1880.03 |  | 1146.03 |  | 856
3 |  |  |  |  |  |  |  |  |  |  | 3 | 0 |  | 249.92003 |  | 0.00982 |  |  |  |  |  |  |  |  |  |  |  | 683.09 | 996.45 | 1153.03 | 1880.03 |  | 1146.03 |  | 856
4 |  |  |  |  |  |  |  |  |  |  | 4 | 0 |  | 249.92003 |  | 0.00982 |  |  |  |  |  |  |  |  |  |  |  | 689.14 | 1081.39 | 1154.03 | 1870.03 |  | 1146.03 |  | 856
5 |  |  |  |  |  |  |  |  |  |  | 5 | 30 |  | 219.92003 |  | 0.00982 |  |  |  |  |  |  |  |  |  |  |  | 368.89 | 925.56 | 818.63 | 1850.03 |  | 1091.03 |  | 856
6 |  |  |  |  |  |  |  |  |  |  | 6 | 0 |  | 249.92003 |  | 0.00982 |  |  |  |  |  |  |  |  |  |  |  | -134.77 | -306.75 | -636.56 | 717.04 |  | -183.34 |  | 856
7 |  |  |  |  |  |  |  |  |  |  | 7 | 0 |  | 249.91026 |  | 0 |  |  |  |  |  |  |  |  |  |  |  | -192.59 | -257.13 | -933.03 | 228 |  | -671.88 |  | 856
8 |  |  |  |  |  |  |  |  |  |  | 8 | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  | -216.76 | -342.15 | -1015.88 | 454.54 |  | -644.91 |  | 856
9 |  |  |  |  |  |  |  |  |  |  | 9 | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  | -216.44 | -340.39 | -1015.52 | 574.72 |  | -647.47 |  | 856
10 |  |  |  |  |  |  |  |  |  |  | 10 | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  | -457.38 | -504.67 | -877.6 | 601.63 |  | -589.62 |  | 856
11 |  |  |  |  |  |  |  |  |  |  | 11 | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  | -379.56 | -426.58 | -1403.75 | -46.37 |  | -1223.69 |  | 856
12 |  |  |  |  |  |  |  |  |  |  | 12 | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  | -682.14 | -730.01 | -1404.38 | -75.87 |  | -1235.18 |  | 856
13 |  |  |  |  |  |  |  |  |  |  | 13 | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  | -683.28 | -733.13 | -1406.46 | -89.74 |  | -1231.24 |  | 856
14 |  |  |  |  |  |  |  |  |  |  | 14 | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  | -683.98 | -733.62 | -1406.69 | -101.27 |  | -1231.86 |  | 856
15 |  |  |  |  |  |  |  |  |  |  | 15 | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  | -685.15 | -731.45 | -1405.76 | -102.72 |  | -1250.27 |  | 856
16 |  |  |  |  |  |  |  |  |  |  | 16 | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  | -383.51 | -430.78 | -1407.25 | -112.77 |  | -1252.7 |  | 856
17 |  |  |  |  |  |  |  |  |  |  | 17 | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  | -384.44 | -432.57 | -1408.37 | 52.92 |  | -1120.71 |  | 856
18 |  |  |  |  |  |  |  |  |  |  | 18 | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  | -202.87 | -251.33 | -1427.99 | 263.59 |  | -911.16 |  | 856
19 |  |  |  |  |  |  |  |  |  |  | 19 | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  | -186.56 | -234.25 | -909.91 | 492.99 |  | -707.71 |  | 856
20 |  |  |  |  |  |  |  |  |  |  | 20 | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  | -313.78 | -370.66 | -1046.04 | 270.98 |  | -862.25 |  | 856
21 |  |  |  |  |  |  |  |  |  |  | 21 | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  | -375.18 | -438.5 | -1151.9 | 108.71 |  | -869.96 |  | 856
22 |  |  |  |  |  |  |  |  |  |  | 22 | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 335.36 | 758.68 | 789.41 | 1622.03 |  | 1177.24 |  | 856
23 |  |  |  |  |  |  |  |  |  |  | 23 | 0 |  | 249.91026 |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 483.48 | 863.16 | 854.34 | 1735.03 |  | 1146.03 |  | 856
24 |  |  |  |  |  |  |  |  |  |  | 24 | 0 |  | 249.91026 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | N/ |  | N/A |  |  |  | -3000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PATH26 _BG |  |  |  | -2295
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1147.03 |  |  |  | -3000
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1147.03 |  |  |  | -2295
Peak |  |  |  |  |  |  |  |  |  |  | PEAK |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PEAK |  |  |  |  | 1146.03 |  |  |  | -3000
Off-Peak |  |  |  |  |  |  |  |  |  |  | OFF-PEAK |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OFF-PEAK |  |  |  |  | 1146.03 |  |  |  | -2295
Flat |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1146.03 |  |  |  | -3000.00
Sum |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1091.03 |  |  |  | -2295.00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -183.34 |  |  |  | -3000.00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -671.88 |  |  |  | -2295.00
ZP26 | SR3 | SR2 | SP15 | SF | NW3 | NW2 | NW1 | NV4 | NV3 | NP15 | MX | LC3 | LC2 | LC1 | LA4 | LA3 | LA2 | LA1 | II2 | II1 | HUMB | AZ5 | AZ3 | AZ2 |  |  |  |  |  |  | -644.91 |  |  |  | -3000.00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -647.47 |  |  |  | -2295.00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | -589.62 | 0 | 0 | 0 | -3000.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | -1223.69 | 0 | 0 | 0 | -2295.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | -1235.18 | 0 | 0 | 0 | -3000.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | -1231.24 | 0 | 0 | 0 | -2295.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | -1231.86 | 0 | 0 | 0 | -3000.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | -1250.27 | 0 | 0 | 0 | -1945.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | -1252.7 | 0 | 0 | 0 | -3000.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | -1120.71 | 0 | 0 | 0 | -1595.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | -911.16 | 0 | 0 | 0 | -3000.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | -707.71 | 0 | 0 | 0 | -1195.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | -862.25 | 0 | 0 | 0 | -3000.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | -869.96 | 0 | 0 | 0 | -856.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 1177.24 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 1146.03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 572.8425 | 572.8425 |  | 572.8425 | 609.1758 | 573.2792 |  | 640.1375 |  |  | 609.1758 |  |  | 572.8425 | 572.8425 | 572.8425