Spreadsheet: kim_ward__20818__Calif Spreads vs Transport
Sheet: Prices

 |  | PRICES
 |  | NYMEX | Kern |  |  | Transwestern |  | El Paso |  |  | PGT
 |  | 1
 |  | NYMEX | OPAL | SoCal | PG&E | Permian | SoCal | Permian | San Juan | SoCal | AECO | Malin | PG&E
 |  | NYMEX | IF KERN WYOMING | NGI (Kern) SOCAL BORDER | PG&E Daily Avg. (Kern) | IF TW PERMIAN | NGW TW SOCAL BORDER | NGW EPNG PERMIAN | NGW EPNG SAN JUAN | NGW EPNG SOCAL BORDER | AECO (PGT) | NGW PGT MALIN | PG&E Daily Avg. (PGT)
 | 1 | 1
1997-01-01 00:00:00 |  | 3.998 | 4.25 | 4.27 |  | 4.1 | 4.06 | 4.24 | 4.18 | 4.21 | 2.835806451612902 | 4.08
 |  | 2.986 | 2.53 | 2.65 |  | 2.5 | 2.59 | 2.61 | 2.61 | 2.6 | 1.889642857142857 | 2.5
 |  | 1.78 | 1.39 | 1.61 |  | 1.52 | 1.57 | 1.61 | 1.46 | 1.54 | 1.479032258064516 | 1.33
 |  | 1.807 | 1.44 | 1.74 |  | 1.61 | 1.75 | 1.63 | 1.57 | 1.74 | 1.776833333333333 | 1.47 |  |  |  |  |  |  |  |  |  |  | 1
 |  | 2.122 | 1.64 | 2.05 |  | 1.89 | 2.02 | 1.92 | 1.84 | 2.02 | 1.717741935483871 | 1.76 |  |  |  |  |  |  |  |  |  |  |  | IF KERN WYOMING
 |  | 2.346 | 1.47 | 2.2 |  | 2.05 | 2.21 | 2.06 | 2.03 | 2.26 | 1.552333333333333 | 1.72 |  |  |  |  |  |  |  |  |  |  |  | NGI (Kern) SOCAL BORDER
 |  | 2.145 | 1.43 | 2.19 |  | 1.99 | 2.15 | 2.02 | 1.98 | 2.17 | 1.507258064516129 | 1.56 |  |  |  |  |  |  |  |  |  |  |  | PG&E Daily Avg. (Kern)
 |  | 2.161 | 1.37 | 2.22 |  | 2.05 | 2.23 | 2.07 | 2 | 2.23 | 1.496935483870968 | 1.51 |  |  |  |  |  |  |  |  |  |  |  | IF TW PERMIAN
 |  | 2.515 | 1.48 | 2.5 |  | 2.35 | 2.45 | 2.39 | 2.28 | 2.45 | 1.464833333333333 | 1.73 |  |  |  |  |  |  |  |  |  |  |  | NGW TW SOCAL BORDER
 |  | 3.346 | 2.09 | 3.08 |  | 2.84 | 3.09 | 2.94 | 2.8 | 3.12 | 1.734354838709677 | 2.29 |  |  |  |  |  |  |  |  |  |  |  | NGW EPNG PERMIAN
 |  | 3.266 | 3 | 3.34 |  | 3.06 | 3.37 | 3.14 | 3.07 | 3.37 | 1.678833333333333 | 3.01 |  |  |  |  |  |  |  |  |  |  |  | NGW EPNG SAN JUAN
 |  | 2.577 | 1.93 | 2.36 |  | 2.2 | 2.29 | 2.18 | 2.11 | 2.31 | 1.339193548387096 | 1.91 |  |  |  |  |  |  |  |  |  |  |  | NGW EPNG SOCAL BORDER
 |  | 2.309 | 2.04 | 2.28 |  | 2.09 | 2.24 | 2.07 | 2.08 | 2.28 | 1.458064516129032 | 2.06 |  |  |  |  |  |  |  |  |  |  |  | AECO (PGT)
 |  | 2.001 | 1.69 | 2.11 |  | 1.87 | 2.09 | 1.85 | 1.81 | 2.1 | 1.637857142857143 | 1.77 |  |  |  |  |  |  |  |  |  |  |  | NGW PGT MALIN
 |  | 2.286 | 1.88 | 2.34 |  | 2.07 | 2.33 | 2.05 | 2.03 | 2.34 | 1.753870967741935 | 1.91 |  |  |  |  |  |  |  |  |  |  |  | PG&E Daily Avg. (PGT)
 |  | 2.3 | 1.9 | 2.37 |  | 2.15 | 2.39 | 2.11 | 2.08 | 2.39 | 2.216333333333333 | 1.97 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 2.262 | 1.97 | 2.34 | 2.255 | 2.12 | 2.37 | 2.12 | 2.06 | 2.34 | 1.760483870967742 | 2.18 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 2.017 | 1.65 | 2.07 | 2.075333333333333 | 1.89 | 2.11 | 1.86 | 1.74 | 2.11 | 1.807333333333334 | 1.68 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 2.358 | 1.62 | 2.22 | 2.437166666666667 | 2.17 | 2.24 | 2.18 | 1.87 | 2.24 | 1.974193548387096 | 1.81 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 1.942 | 1.73 | 2.3 | 2.398225806451612 | 1.94 | 2.28 | 1.93 | 1.83 | 2.28 | 1.762258064516128 | 2.04 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 1.672 | 1.59 | 2.02 | 2.304137931034481 | 1.59 | 2 | 1.61 | 1.54 | 2.01 | 2.007 | 1.78 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 2.031 | 1.64 | 2.03 | 2.384677419354839 | 2.09 | 2.02 | 1.82 | 1.63 | 2.04 | 2.353548387096774 | 1.8 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 1.972 | 2.01 | 2.33 | 2.598392857142858 | 1.99 | 2.33 | 1.93 | 1.87 | 2.33 | 2.524833333333333 | 2.24 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 2.149 | 2 | 2.29 | 2.551896551724138 | 1.99 | 2.28 | 2 | 1.98 | 2.28 | 2.222258064516129 | 2.16
 |  | 1.765 | 1.8 | 2.04 | 2.075 | 1.74 | 2.02 | 1.72 | 1.72 | 2.02 | 2.312903225806452 | 2.11
 |  | 1.81 | 1.64 | 1.83 | 1.947142857142858 | 1.67 | 1.82 | 1.67 | 1.63 | 1.82 | 2.24375 | 1.75
 |  | 1.666 | 1.51 | 1.71 | 1.92 | 1.57 | 1.73 | 1.51 | 1.42 | 1.73 | 2.20258064516129 | 1.62
 |  | 1.852 | 1.54 | 1.78 | 2.2775 | 1.66 | 1.79 | 1.68 | 1.58 | 1.79 | 2.526 | 1.65
 |  | 2.348 | 1.99 | 2.22 | 2.410967741935483 | 2.16 | 2.23 | 2.17 | 2.02 | 2.2 | 2.699354838709678 | 2.12
 |  | 2.226 | 1.94 | 2.22 | 2.458666666666667 | 2.08 | 2.22 | 2.08 | 1.97 | 2.22 | 2.792 | 2.1
 |  | 2.262 | 2 | 2.38 | 2.477096774193548 | 2.17 | 2.38 | 2.21 | 2.05 | 2.38 | 2.781290322580645 | 2.21
 |  | 2.601 | 2.18 | 2.58 | 2.743870967741935 | 2.45 | 2.59 | 2.51 | 2.27 | 2.59 | 3.250322580645161 | 2.28
 |  | 2.912 | 2.56 | 2.93 | 2.7885 | 2.77 | 2.93 | 2.78 | 2.64 | 2.93 | 3.115 | 2.64
 |  | 2.559 | 2.39 | 2.71 | 3.156290322580645 | 2.47 | 2.7 | 2.51 | 2.38 | 2.69 | 3.578064516129032 | 2.55
 |  | 3.092000007629395 | 2.86 | 3.07 | 2.666666666666666 | 2.88 | 3.06 | 2.87 | 2.84 | 3.06 | 2.894500000000001 | 3.01
 |  | 2.12 | 2.1 | 2.37 | 2.509838709677419 | 2.09 | 2.41 | 2.13 | 2.08 | 2.41 | 2.790322580645161 | 2.31
 |  | 2.344 | 2.19 | 2.38 | 2.478709677419355 | 2.18 | 2.38 | 2.19 | 2.17 | 2.38 | 2.827096774193548 | 2.32
 |  | 2.61 | 2.38 | 2.55 | 2.696034482758622 | 2.43 | 2.55 | 2.37 | 2.37 | 2.55 | 3.101896551724139 | 2.49
 |  | 2.603 | 2.35 | 2.59 | 2.965 | 2.41 | 2.58 | 2.39 | 2.35 | 2.58 | 3.521290322580644 | 2.44
 |  | 2.9 | 2.7 | 3.02 | 3.085 | 2.79 | 3.04 | 2.82 | 2.77 | 3.04 | 3.770833333333333 | 2.9
 |  | 3.089 | 2.74 | 3.03 | 3.677741935483871 | 2.89 | 3.04 | 2.87 | 2.76 | 3.04 | 4.343064516129034 | 2.94
 |  | 4.406 | 3.61 | 4.33 | 4.665999999999999 | 4.12 | 4.31 | 3.89 | 3.71 | 4.31 | 5.107666666666666 | 3.88
 |  | 4.36899995803833 | 3.95 | 4.91 | 4.395161290322581 | 4.36 | 4.9 | 4.46 | 4.14 | 4.9 | 4.535967741935484 | 4.5
 |  | 3.82 | 3.12 | 4.49 | 4.864032258064515 | 3.8 | 4.56 | 3.72 | 3.48 | 4.56 | 4.504354838709679 | 3.99
 |  | 4.618 | 3.47 | 6.31 | 5.916333333333335 | 4.51 | 7 | 4.55 | 3.5 | 7 | 6.201333333333335 | 5.91
 |  | 5.312 | 4.31 | 5.57 | 5.593225806451613 | 5.17 | 5.57 | 5.16 | 4.52 | 5.57 | 6.444193548387096 | 5.31
 |  | 4.541 | 4.37 | 5.18 | 9.766833333333333 | 4.46 | 5.2 | 4.6 | 4.41 | 5.2 | 7.161499999999999 | 5.06
 |  | 6.016 | 6.07 | 14.08 | 20.99483870967742 | 6.31 | 13.81 | 6.39 | 6 | 13.82 | 11.71741935483871 | 13.53
 |  | 9.979 | 8.77 | 16.32 | 10.73887096774193 | 9.95 | 16.13 | 9.78 | 8.72 | 15.92 | 10.72790322580645 | 14.17
 |  | 6.293 | 6.41 | 12.63 | 11.22545454545454 | 6.9 | 12.57 | 6.73 | 6.1 | 12.57 | 8.00181818181818 | 9.77