Spreadsheet: michelle_lokay__26817__USGT
Sheet: USGT

USGT #27161 Contract Analysis
 | GD PB [NAME] | GD PB TW | East flow volumes | 1.31% fuel | CSM |  | [NAME] So Cal | So [NAME] volumes | 5.0% fuel | [NAME] | PG&E volumes | 5.0% fuel | [NAME] avg [NAME] | West flow volumes | CSM
2000-04-01 00:00:00 | 2.78 | 2.69 |  |  |  |  | 2.975 |  |  | 2.975
2000-04-02 00:00:00 | 2.78 | 2.69 |  |  |  |  | 2.975 |  |  | 2.975
2000-04-03 00:00:00 | 2.78 | 2.69 |  |  |  |  | 2.975 |  |  | 2.975
2000-04-04 00:00:00 | 2.845 | 2.78 |  |  |  |  | 3.045 |  |  | 3.025
2000-04-05 00:00:00 | 2.785 | 2.73 |  |  |  |  | 2.995 |  |  | 2.97
2000-04-06 00:00:00 | 2.795 | 2.73 |  |  |  |  | 2.98 |  |  | 2.975
2000-04-07 00:00:00 | 2.815 | 2.76 |  |  |  |  | 2.995 |  |  | 2.985
2000-04-08 00:00:00 | 2.845 | 2.765 |  |  |  |  | 3.005 |  |  | 2.975
2000-04-09 00:00:00 | 2.845 | 2.765 |  |  |  |  | 3.005 |  |  | 2.975
2000-04-10 00:00:00 | 2.845 | 2.765 |  |  |  |  | 3.005 |  |  | 2.975
2000-04-11 00:00:00 | 2.865 | 2.795 |  |  |  |  | 3.025 |  |  | 2.995
2000-04-12 00:00:00 | 2.87 | 2.805 |  |  |  |  | 3.01 |  |  | 3.005
2000-04-13 00:00:00 | 2.875 | 2.8 |  |  |  |  | 3.015 |  |  | 2.995
2000-04-14 00:00:00 | 2.935 | 2.88 |  |  |  |  | 3.045 |  |  | 3.035
2000-04-15 00:00:00 | 2.91 | 2.835 |  |  |  |  | 2.985 |  |  | 2.985
2000-04-16 00:00:00 | 2.91 | 2.835 |  |  |  |  | 2.985 |  |  | 2.985
2000-04-17 00:00:00 | 2.91 | 2.835 |  |  |  |  | 2.985 |  |  | 2.985
2000-04-18 00:00:00 | 3.01 | 2.925 |  |  |  |  | 3.055 |  |  | 3.025
2000-04-19 00:00:00 | 3.025 | 2.96 |  |  |  |  | 3.075 |  |  | 3.07
2000-04-20 00:00:00 | 3.025 | 2.95 |  |  |  |  | 3.065 |  |  | 3.055
2000-04-21 00:00:00 | 2.96 | 2.875 |  |  |  |  | 2.985 |  |  | 2.95
2000-04-22 00:00:00 | 2.96 | 2.875 |  |  |  |  | 2.985 |  |  | 2.95
2000-04-23 00:00:00 | 2.96 | 2.875 |  |  |  |  | 2.985 |  |  | 2.95
2000-04-24 00:00:00 | 2.96 | 2.875 |  |  |  |  | 2.985 |  |  | 2.95
2000-04-25 00:00:00 | 3 | 2.925 |  |  |  |  | 3.055 |  |  | 3.045
2000-04-26 00:00:00 | 2.985 | 2.895 |  |  |  |  | 3.075 |  |  | 3.05
2000-04-27 00:00:00 | 2.97 | 2.88 |  |  |  |  | 3.085 |  |  | 3.065
2000-04-28 00:00:00 | 2.9 | 2.835 |  |  |  |  | 3.06 |  |  | 3.065
2000-04-29 00:00:00 | 2.895 | 2.83 |  |  |  |  | 2.985 |  |  | 2.99
2000-04-30 00:00:00 | 2.895 | 2.83 |  |  |  |  | 2.985 |  |  | 2.99
April 2000 |  |  |  |  |  |  |  | 662243 |  |  | 30000
2000-05-01 00:00:00 | 2.92 | 2.84 |  |  |  |  | 3.04 |  |  | 3.03
2000-05-02 00:00:00 | 3 | 2.955 |  |  |  |  | 3.145 |  |  | 3.12
2000-05-03 00:00:00 | 3.025 | 2.97 |  |  |  |  | 3.21 |  |  | 3.165
2000-05-04 00:00:00 | 3 | 2.95 |  |  |  |  | 3.175 |  |  | 3.15
2000-05-05 00:00:00 | 2.965 | 2.895 |  |  |  |  | 3.155 |  |  | 3.05
2000-05-06 00:00:00 | 2.945 | 2.88 |  |  |  |  | 3.055 |  |  | 3.05
2000-05-07 00:00:00 | 2.945 | 2.88 |  |  |  |  | 3.055 |  |  | 3.05
2000-05-08 00:00:00 | 2.945 | 2.88 |  |  |  |  | 3.055 |  |  | 3.05
2000-05-09 00:00:00 | 2.995 | 2.95 |  |  |  |  | 3.12 |  |  | 3.075
2000-05-10 00:00:00 | 3.09 | 3.04 |  |  |  |  | 3.195 |  |  | 3.165
2000-05-11 00:00:00 | 3.055 | 3.01 |  |  |  |  | 3.165 |  |  | 3.145
2000-05-12 00:00:00 | 3.205 | 3.125 |  |  |  |  | 3.265 |  |  | 3.25
2000-05-13 00:00:00 | 3.155 | 3.08 |  |  |  |  | 3.22 |  |  | 3.185
2000-05-14 00:00:00 | 3.155 | 3.08 |  |  |  |  | 3.22 |  |  | 3.185
2000-05-15 00:00:00 | 3.155 | 3.08 |  |  |  |  | 3.22 |  |  | 3.185
2000-05-16 00:00:00 | 3.205 | 3.15 |  |  |  |  | 3.29 |  |  | 3.265
2000-05-17 00:00:00 | 3.32 | 3.245 |  |  |  |  | 3.425 |  |  | 3.41
2000-05-18 00:00:00 | 3.37 | 3.31 |  |  |  |  | 3.495 |  |  | 3.475
2000-05-19 00:00:00 | 3.64 | 3.59 |  |  |  |  | 3.825 |  |  | 3.755
2000-05-20 00:00:00 | 3.625 | 3.6 |  |  |  |  | 3.945 |  |  | 3.91
2000-05-21 00:00:00 | 3.625 | 3.6 |  |  |  |  | 3.945 |  |  | 3.91
2000-05-22 00:00:00 | 3.625 | 3.6 |  |  |  |  | 3.945 |  |  | 3.91
2000-05-23 00:00:00 | 3.98 | 3.985 |  |  |  |  | 4.865 |  |  | 4.625
2000-05-24 00:00:00 | 3.8 | 3.745 |  |  |  |  | 4.215 |  |  | 4.19
2000-05-25 00:00:00 | 3.85 | 3.8 |  |  |  |  | 4.15 |  |  | 4.085
2000-05-26 00:00:00 | 4.07 | 4.015 |  |  |  |  | 4.3 |  |  | 4.245
2000-05-27 00:00:00 | 4.105 | 3.99 |  |  |  |  | 4.225 |  |  | 4.16
2000-05-28 00:00:00 | 4.105 | 3.99 |  |  |  |  | 4.225 |  |  | 4.16
2000-05-29 00:00:00 | 4.105 | 3.99 |  |  |  |  | 4.225 |  |  | 4.16
2000-05-30 00:00:00 | 4.105 | 3.99 |  |  |  |  | 4.225 |  |  | 4.16
2000-05-31 00:00:00 | 4.29 | 4.28 |  |  |  |  | 4.76 |  |  | 4.7
May 2000 |  |  |  |  |  |  |  | 241764
2000-06-01 00:00:00 | 4.445 | 4.395 |  |  |  |  | 4.825 |  |  | 4.775
2000-06-02 00:00:00 | 4.325 | 4.265 |  |  |  |  | 4.72 |  |  | 4.665
2000-06-03 00:00:00 | 4.095 | 3.985 |  |  |  |  | 4.22 |  |  | 4.2
2000-06-04 00:00:00 | 4.095 | 3.985 |  |  |  |  | 4.22 |  |  | 4.2
2000-06-05 00:00:00 | 4.095 | 3.985 |  |  |  |  | 4.22 |  |  | 4.2
2000-06-06 00:00:00 | 4.075 | 4.08 |  |  |  |  | 4.455 |  |  | 4.385
2000-06-07 00:00:00 | 4.38 | 4.335 |  |  |  |  | 4.67 |  |  | 4.62
2000-06-08 00:00:00 | 4.085 | 4.05 |  |  |  |  | 4.45 |  |  | 4.42
2000-06-09 00:00:00 | 3.85 | 3.8 |  |  |  |  | 4.365 |  |  | 4.265
2000-06-10 00:00:00 | 4.07 | 4.025 |  |  |  |  | 4.43 |  |  | 4.355
2000-06-11 00:00:00 | 4.07 | 4.025 |  |  |  |  | 4.43 |  |  | 4.355
2000-06-12 00:00:00 | 4.07 | 4.025 |  |  |  |  | 4.43 |  |  | 4.355
2000-06-13 00:00:00 | 4.135 | 4.095 |  |  |  |  | 4.83 |  |  | 4.65
2000-06-14 00:00:00 | 4.21 | 4.18 |  |  |  |  | 4.805 |  |  | 4.555
2000-06-15 00:00:00 | 4.1 | 4.01 |  |  |  |  | 4.685 |  |  | 4.425
2000-06-16 00:00:00 | 4.25 | 4.185 |  |  |  |  | 4.775 |  |  | 4.495
2000-06-17 00:00:00 | 4.255 | 4.14 |  |  |  |  | 4.67 |  |  | 4.46
2000-06-18 00:00:00 | 4.255 | 4.14 |  |  |  |  | 4.67 |  |  | 4.46
2000-06-19 00:00:00 | 4.255 | 4.14 |  |  |  |  | 4.67 |  |  | 4.46
2000-06-20 00:00:00 | 4.26 | 4.225 |  |  |  |  | 4.72 |  |  | 4.43
2000-06-21 00:00:00 | 3.96 | 3.875 |  |  |  |  | 4.41 |  |  | 4.165
2000-06-22 00:00:00 | 4.085 | 4.055 |  |  |  |  | 4.47 |  |  | 4.355
2000-06-23 00:00:00 | 4.38 | 4.355 |  |  |  |  | 4.875 |  |  | 4.61
2000-06-24 00:00:00 | 4.26 | 4.19 |  |  |  |  | 4.685 |  |  | 4.485
2000-06-25 00:00:00 | 4.26 | 4.19 |  |  |  |  | 4.685 |  |  | 4.485
2000-06-26 00:00:00 | 4.26 | 4.19 |  |  |  |  | 4.685 |  |  | 4.485
2000-06-27 00:00:00 | 4.315 | 4.28 |  |  |  |  | 4.83 |  |  | 4.58
2000-06-28 00:00:00 | 4.52 | 4.505 |  |  |  |  | 5.09 |  |  | 4.775
2000-06-29 00:00:00 | 4.455 | 4.42 |  |  |  |  | 5.105 |  |  | 4.815
2000-06-30 00:00:00 | 4.245 | 4.155 |  |  |  |  | 4.825 |  |  | 4.68
June 2000 |  |  |  |  |  |  |  | 113921 |  |  | 1102737
2000-07-01 00:00:00 | 4.29 | 4.2 |  |  |  |  | 4.73 |  |  | 4.455
2000-07-02 00:00:00 | 4.29 | 4.2 |  |  |  |  | 4.73 |  |  | 4.455
2000-07-03 00:00:00 | 4.29 | 4.2 |  |  |  |  | 4.73 |  |  | 4.455
2000-07-04 00:00:00 | 4.29 | 4.2 |  |  |  |  | 4.73 |  |  | 4.455
2000-07-05 00:00:00 | 4.29 | 4.2 |  |  |  |  | 4.73 |  |  | 4.455
2000-07-06 00:00:00 | 4.2 | 4.13 |  |  |  |  | 4.84 |  |  | 4.295
2000-07-07 00:00:00 | 3.97 | 3.9 |  |  |  |  | 4.555 |  |  | 4.295
2000-07-08 00:00:00 | 3.85 | 3.74 |  |  |  |  | 4.135 |  |  | 3.59
2000-07-09 00:00:00 | 3.85 | 3.74 |  |  |  |  | 4.135 |  |  | 3.59
2000-07-10 00:00:00 | 3.85 | 3.74 |  |  |  |  | 4.135 |  |  | 3.59
2000-07-11 00:00:00 | 4.16 | 4.105 |  |  |  |  | 4.74 |  |  | 4.325
2000-07-12 00:00:00 | 4.185 | 4.085 |  |  |  |  | 4.69 |  |  | 4.215
2000-07-13 00:00:00 | 4.31 | 4.26 |  |  |  |  | 4.805 |  |  | 4.415
2000-07-14 00:00:00 | 4.095 | 4.05 |  |  |  |  | 4.72 |  |  | 4.3
2000-07-15 00:00:00 | 4.155 | 4.06 |  |  |  |  | 4.655 |  |  | 4.045
2000-07-16 00:00:00 | 4.155 | 4.06 |  |  |  |  | 4.655 |  |  | 4.045
2000-07-17 00:00:00 | 4.155 | 4.06 |  |  |  |  | 4.655 |  |  | 4.045
2000-07-18 00:00:00 | 4.14 | 4.055 |  |  |  |  | 4.705 |  |  | 4.345
2000-07-19 00:00:00 | 3.98 | 3.905 |  |  |  |  | 4.675 |  |  | 4.225
2000-07-20 00:00:00 | 4.075 | 3.995 |  |  |  |  | 4.76 |  |  | 4.32
2000-07-21 00:00:00 | 3.95 | 3.89 |  |  |  |  | 4.625 |  |  | 4.3
2000-07-22 00:00:00 | 3.97 | 3.915 |  |  |  |  | 4.62 |  |  | 4.235
2000-07-23 00:00:00 | 3.97 | 3.915 |  |  |  |  | 4.62 |  |  | 4.235
2000-07-24 00:00:00 | 3.97 | 3.915 |  |  |  |  | 4.62 |  |  | 4.235
2000-07-25 00:00:00 | 3.8 | 3.84 |  |  |  |  | 4.625 |  |  | 4.325
2000-07-26 00:00:00 | 3.705 | 3.58 |  |  |  |  | 4.53 |  |  | 4.155
2000-07-27 00:00:00 | 3.695 | 3.55 |  |  |  |  | 4.53 |  |  | 4.08
2000-07-28 00:00:00 | 3.86 | 3.81 |  |  |  |  | 4.62 |  |  | 4.14
2000-07-29 00:00:00 | 3.89 | 3.82 |  |  |  |  | 4.605 |  |  | 4.155
2000-07-30 00:00:00 | 3.89 | 3.82 |  |  |  |  | 4.605 |  |  | 4.155
2000-07-31 00:00:00 | 3.89 | 3.82 |  |  |  |  | 4.605 |  |  | 4.155
July 2000 |  |  |  |  |  |  |  | 137405 |  |  | 374456
2000-08-01 00:00:00 | 3.76 | 3.72 |  |  |  |  | 4.615 |  |  | 4.215
2000-08-02 00:00:00 | 3.78 | 3.77 |  |  |  |  | 4.535 |  |  | 4.13
2000-08-03 00:00:00 | 4.055 | 4.03 |  |  |  |  | 4.645 |  |  | 4.29
2000-08-04 00:00:00 | 4.19 | 4.125 |  |  |  |  | 4.755 |  |  | 4.34
2000-08-05 00:00:00 | 4.225 | 4.155 |  |  |  |  | 4.75 |  |  | 4.36
2000-08-06 00:00:00 | 4.225 | 4.155 |  |  |  |  | 4.75 |  |  | 4.36
2000-08-07 00:00:00 | 4.225 | 4.155 |  |  |  |  | 4.75 |  |  | 4.36
2000-08-08 00:00:00 | 4.385 | 4.265 |  |  |  |  | 4.87 |  |  | 4.285
2000-08-09 00:00:00 | 4.445 | 4.345 |  |  |  |  | 4.875 |  |  | 4.39
2000-08-10 00:00:00 | 4.46 | 4.36 |  |  |  |  | 4.77 |  |  | 4.365
2000-08-11 00:00:00 | 4.41 | 4.335 |  |  |  |  | 4.765 |  |  | 4.36
2000-08-12 00:00:00 | 4.41 | 4.35 |  |  |  |  | 4.74 |  |  | 4.36
2000-08-13 00:00:00 | 4.41 | 4.35 |  |  |  |  | 4.74 |  |  | 4.36
2000-08-14 00:00:00 | 4.41 | 4.35 |  |  |  |  | 4.74 |  |  | 4.36
2000-08-15 00:00:00 | 4.405 | 4.33 |  |  |  |  | 4.765 |  |  | 4.37
2000-08-16 00:00:00 | 4.23 | 4.16 |  |  |  |  | 4.68 |  |  | 4.21
2000-08-17 00:00:00 | 4.245 | 4.18 |  |  |  |  | 4.73 |  |  | 4.175
2000-08-18 00:00:00 | 4.375 | 4.26 |  |  |  |  | 4.925 |  |  | 4.315
2000-08-19 00:00:00 | 4.38 | 4.31 |  |  |  |  | 4.925 |  |  | 4.345
2000-08-20 00:00:00 | 4.38 | 4.31 |  |  |  |  | 4.925 |  |  | 4.345
2000-08-21 00:00:00 | 4.38 | 4.31 |  |  |  |  | 4.925 |  |  | 4.345
2000-08-22 00:00:00 | 4.66 | 4.575 |  |  |  |  | 5.29 |  |  | 4.695
2000-08-23 00:00:00 | 4.805 | 4.755 |  |  |  |  | 5.775 |  |  | 5.29
2000-08-24 00:00:00 | 4.67 | 4.62 |  |  |  |  | 5.76 |  |  | 5.285
2000-08-25 00:00:00 | 4.445 | 4.37 |  |  |  |  | 5.75 |  |  | 5.025
2000-08-26 00:00:00 | 4.535 | 4.425 |  |  |  |  | 6.475 |  |  | 5.23
2000-08-27 00:00:00 | 4.535 | 4.425 |  |  |  |  | 6.475 |  |  | 5.23
2000-08-28 00:00:00 | 4.535 | 4.425 |  |  |  |  | 6.475 |  |  | 5.23
2000-08-29 00:00:00 | 4.625 | 4.505 |  |  |  |  | 6.925 |  |  | 5.665
2000-08-30 00:00:00 | 4.665 | 4.525 |  |  |  |  | 7.285 |  |  | 6.63
2000-08-31 00:00:00 | 4.61 | 4.6 |  |  |  |  | 6.13 |  |  | 5.35
August 2000 |  |  |  |  |  |  |  | 180488
2000-09-01 00:00:00 | 4.785 | 4.7 |  |  |  |  | 6.18 |  |  | 5.155
2000-09-02 00:00:00 | 4.75 | 4.615 |  |  |  |  | 5.875 |  |  | 5.245
2000-09-03 00:00:00 | 4.75 | 4.615 |  |  |  |  | 5.875 |  |  | 5.245
2000-09-04 00:00:00 | 4.75 | 4.615 |  |  |  |  | 5.875 |  |  | 5.245
2000-09-05 00:00:00 | 4.75 | 4.615 |  |  |  |  | 5.875 |  |  | 5.245
2000-09-06 00:00:00 | 4.88 | 4.785 |  |  |  |  | 6.205 |  |  | 5.71
2000-09-07 00:00:00 | 4.94 | 4.825 |  |  |  |  | 6.34 |  |  | 5.925
2000-09-08 00:00:00 | 4.895 | 4.74 |  |  |  |  | 6.225 |  |  | 5.865
2000-09-09 00:00:00 | 4.78 | 4.675 |  |  |  |  | 6.15 |  |  | 5.78
2000-09-10 00:00:00 | 4.78 | 4.675 |  |  |  |  | 6.15 |  |  | 5.78
2000-09-11 00:00:00 | 4.78 | 4.675 |  |  |  |  | 6.15 |  |  | 5.78
2000-09-12 00:00:00 | 4.975 | 4.805 |  |  |  |  | 6.325 |  |  | 5.98
2000-09-13 00:00:00 | 5.045 | 4.915 |  |  |  |  | 6.36 |  |  | 6.04
2000-09-14 00:00:00 | 5.075 | 4.915 |  |  |  |  | 6.39 |  |  | 6
2000-09-15 00:00:00 | 5.09 | 5.03 |  |  |  |  | 6.37 |  |  | 6.005
2000-09-16 00:00:00 | 5.185 | 5.04 |  |  |  |  | 6.395 |  |  | 6.05
2000-09-17 00:00:00 | 5.185 | 5.04 |  |  |  |  | 6.395 |  |  | 6.05
2000-09-18 00:00:00 | 5.185 | 5.04 |  |  |  |  | 6.395 |  |  | 6.05
2000-09-19 00:00:00 | 5 | 4.9 |  |  |  |  | 6.31 |  |  | 5.98
2000-09-20 00:00:00 | 5.12 | 5.005 |  |  |  |  | 6.25 |  |  | 5.89
2000-09-21 00:00:00 | 5.18 | 5.05 |  |  |  |  | 6.075 |  |  | 5.765
Sept 2000 (9/21) |  |  |  |  |  |  |  | 143525
Sum | 684.345 | 671.045 |  |  |  |  | 777.455 |  |  | 730.225
Average | 3.933 | 3.8566 |  |  |  |  | 4.4681 |  |  | 4.1967
Average (+) | 3.933 | 3.8566 |  |  |  |  | 4.4681 |  |  | 4.1967
Average (-) | NaN | NaN |  |  |  |  | NaN |  |  | NaN
Percent (+) | 100 | 100 |  |  |  |  | 100 |  |  | 100
Percent (-) | 0 | 0 |  |  |  |  | 0 |  |  | 0
Maximum | 5.185 | 5.05 |  |  |  |  | 7.285 |  |  | 6.63
Minimum | 2.78 | 2.69 |  |  |  |  | 2.975 |  |  | 2.95
Std Deviation | 0.6828 | 0.6728 |  |  |  |  | 1.0728 |  |  | 0.8911
Zstat | 5.7599 | 5.7324 |  |  |  |  | 4.1648 |  |  | 4.7094
[NAME] | 0.4662 | 0.4526 |  |  |  |  | 1.151 |  |  | 0.7941
Last | 5.18 | 5.05 |  |  |  |  | 6.075 |  |  | 5.765