Spreadsheet: chris_stokley__3848__1100 EES_PGES_403_042501ds
Sheet: Total

Draft Load Deviation for EES/PGES 11/1/00-11/30/00
 |  | EPMI Charges To Customers
Trans Type | (CAISO C)
 |  |  |  |  | Data
Customer | MrktDt | ID | Desc. | SchedType | Expense | Revenue | Total | Volume
EES | 2000-11-01 00:00:00 | 403 | Load Deviation | Deviation | -94898.82644499997 | 101077.6785733334 | 6178.852128333419 | 250.1109999999999
 | 2000-11-02 00:00:00 | 403 | Load Deviation | Deviation | -107138.9256116666 | 108768.3852500001 | 1629.459638333417 | -85.8840000000007
 | 2000-11-03 00:00:00 | 403 | Load Deviation | Deviation | -60688.26110166665 | 126063.7360000001 | 65375.47489833347 | -326.5540000000015
 | 2000-11-04 00:00:00 | 403 | Load Deviation | Deviation | -8589.08428 | 63885.34723333338 | 55296.26295333337 | -522.5580000000004
 | 2000-11-05 00:00:00 | 403 | Load Deviation | Deviation | -67211.01129333331 | 50739.02253000005 | -16471.98876333327 | 199.5309999999999
 | 2000-11-06 00:00:00 | 403 | Load Deviation | Deviation | -101669.8371283333 | 81734.36642000006 | -19935.47070833327 | 138.8299999999994
 | 2000-11-07 00:00:00 | 403 | Load Deviation | Deviation | -86489.64388333335 | 110366.2535 | 23876.60961666668 | -104.7239999999996
 | 2000-11-08 00:00:00 | 403 | Load Deviation | Deviation | -43709.2032883333 | 77656.70409166676 | 33947.50080333346 | -118.0970000000005
 | 2000-11-09 00:00:00 | 403 | Load Deviation | Deviation | -95927.85919333332 | 67419.67851500007 | -28508.18067833325 | 218.7439999999991
 | 2000-11-10 00:00:00 | 403 | Load Deviation | Deviation | -93335.79717499996 | 72051.3266533334 | -21284.47052166656 | 511.2429999999997
 | 2000-11-11 00:00:00 | 403 | Load Deviation | Deviation | -151207.9480916666 | 41860.37723666668 | -109347.5708549999 | 1084.870999999999
 | 2000-11-12 00:00:00 | 403 | Load Deviation | Deviation | -79080.62657333337 | 185335.3950533333 | 106254.7684799999 | 18.97799999999978
 | 2000-11-13 00:00:00 | 403 | Load Deviation | Deviation | -178029.9551366667 | 78571.86550333339 | -99458.08963333331 | 549.1769999999999
 | 2000-11-14 00:00:00 | 403 | Load Deviation | Deviation | -138365.936695 | 81776.46309500007 | -56589.4735999999 | 360.9969999999994
 | 2000-11-15 00:00:00 | 403 | Load Deviation | Deviation | -151663.502695 | 101630.1017533334 | -50033.40094166667 | 566.9330000000004
 | 2000-11-16 00:00:00 | 403 | Load Deviation | Deviation | -219147.7186349999 | 109553.1499366667 | -109594.5686983332 | 565.6679999999998
 | 2000-11-17 00:00:00 | 403 | Load Deviation | Deviation | -118150.6957616667 | 114022.9583233334 | -4127.737438333326 | 159.505
 | 2000-11-18 00:00:00 | 403 | Load Deviation | Deviation | -170897.0106916666 | 97863.01402666673 | -73033.99666499981 | 402.4959999999992
 | 2000-11-19 00:00:00 | 403 | Load Deviation | Deviation | -146335.8028183333 | 76925.86335666665 | -69409.9394616666 | 408.5279999999997
 | 2000-11-20 00:00:00 | 403 | Load Deviation | Deviation | -155408.88415 | 71453.19109833335 | -83955.69305166657 | 415.565
 | 2000-11-21 00:00:00 | 403 | Load Deviation | Deviation | -130434.3979333333 | 66633.47032500002 | -63800.92760833322 | 358.9089999999997
 | 2000-11-22 00:00:00 | 403 | Load Deviation | Deviation | -301313.1261566667 | 34236.69333166669 | -267076.4328249999 | 1477.648
 | 2000-11-23 00:00:00 | 403 | Load Deviation | Deviation | -330583.8471833333 | 24538.67751500001 | -306045.1696683333 | 1810.67
 | 2000-11-24 00:00:00 | 403 | Load Deviation | Deviation | -297487.515865 | 52753.38718166669 | -244734.1286833333 | 1166.166999999999
 | 2000-11-25 00:00:00 | 403 | Load Deviation | Deviation | -283868.5587816666 | 76329.39675000004 | -207539.1620316666 | 868.6489999999997
 | 2000-11-26 00:00:00 | 403 | Load Deviation | Deviation | -190117.2727666666 | 93403.86737833337 | -96713.40538833325 | 496.8869999999995
 | 2000-11-27 00:00:00 | 403 | Load Deviation | Deviation | -541101.4725366667 | 60678.93099333337 | -480422.5415433333 | 2493.310999999998
 | 2000-11-28 00:00:00 | 403 | Load Deviation | Deviation | -91551.05151666667 | 158561.7181133334 | 67010.66659666676 | -308.4540000000005
 | 2000-11-29 00:00:00 | 403 | Load Deviation | Deviation | -55886.70791666664 | 223601.9762250001 | 167715.2683083334 | -1129.03
 | 2000-11-30 00:00:00 | 403 | Load Deviation | Deviation | -56148.03372999998 | 266326.0553500001 | 210178.0216200001 | -1164.29
EES Total |  |  |  |  | -4546438.515035 | 2875819.051313335 | -1670619.463721665 | 10763.82699999999
PGES | 2000-11-01 00:00:00 | 403 | Load Deviation | Deviation | -165531.4104333334 | 3277.874283333338 | -162253.53615 | 1458.2
 | 2000-11-02 00:00:00 | 403 | Load Deviation | Deviation | -209995.3543 | 1062.3182 | -208933.0361 | 1705.34
 | 2000-11-03 00:00:00 | 403 | Load Deviation | Deviation | -122326.7860833334 | 3773.206733333333 | -118553.57935 | 1331.68
 | 2000-11-04 00:00:00 | 403 | Load Deviation | Deviation | -49934.51696666668 | 2048.971600000004 | -47885.54536666667 | 1386.28
 | 2000-11-05 00:00:00 | 403 | Load Deviation | Deviation | -117179.5735166667 | 10591.40553333333 | -106588.1679833333 | 1323.64
 | 2000-11-06 00:00:00 | 403 | Load Deviation | Deviation | -212232.3822666667 | 2609.875183333338 | -209622.5070833334 | 1512.7
 | 2000-11-07 00:00:00 | 403 | Load Deviation | Deviation | -170587.5096 | 4078.233149999995 | -166509.27645 | 1485.66
 | 2000-11-08 00:00:00 | 403 | Load Deviation | Deviation | -131751.6556 | 2008.421599999999 | -129743.234 | 1389.59
 | 2000-11-09 00:00:00 | 403 | Load Deviation | Deviation | -189672.5858833333 | 2114.496850000003 | -187558.0890333334 | 1473.16
 | 2000-11-10 00:00:00 | 403 | Load Deviation | Deviation | -162301.3714666667 | 12817.2498 | -149484.1216666667 | 1411.56
 | 2000-11-11 00:00:00 | 403 | Load Deviation | Deviation | -160041.7082833333 | 62795.02340000005 | -97246.68488333322 | 1298.17
 | 2000-11-12 00:00:00 | 403 | Load Deviation | Deviation | -76256.99420000002 | 80115.16596666661 | 3858.171766666608 | 1029.36
 | 2000-11-13 00:00:00 | 403 | Load Deviation | Deviation | -248133.0088833334 | 11654.83315 | -236478.1757333334 | 1413.07
 | 2000-11-14 00:00:00 | 403 | Load Deviation | Deviation | -295586.7408666667 | 12314.065 | -283272.6758666667 | 1545.55
 | 2000-11-15 00:00:00 | 403 | Load Deviation | Deviation | -211003.1688333334 | 18732.60988333334 | -192270.55895 | 1441.19
 | 2000-11-16 00:00:00 | 403 | Load Deviation | Deviation | -231734.05225 | 17302.12935000002 | -214431.9229 | 1409.28
 | 2000-11-17 00:00:00 | 403 | Load Deviation | Deviation | -126777.3654833333 | 46599.06566666664 | -80178.29981666667 | 1142.43
 | 2000-11-18 00:00:00 | 403 | Load Deviation | Deviation | -533351.9032166668 | 16477.65913333334 | -516874.2440833335 | 2981.57
 | 2000-11-19 00:00:00 | 403 | Load Deviation | Deviation | -234086.6922166667 | 20232.59216666664 | -213854.10005 | 1423.77
 | 2000-11-20 00:00:00 | 403 | Load Deviation | Deviation | -319076.0941833333 | 6582.009166666654 | -312494.0850166667 | 1765.75
 | 2000-11-21 00:00:00 | 403 | Load Deviation | Deviation | -268768.3278500001 | 5813.3 | -262955.0278500001 | 1897.94
 | 2000-11-22 00:00:00 | 403 | Load Deviation | Deviation | -245879.4718833333 | 1757.150000000005 | -244122.3218833333 | 1923.08
 | 2000-11-23 00:00:00 | 403 | Load Deviation | Deviation | -96283.06433333336 | 7579.930599999992 | -88703.13373333336 | 1145.29
 | 2000-11-24 00:00:00 | 403 | Load Deviation | Deviation | -166325.4500833334 | 55852.19328333334 | -110473.2568 | 733.45
 | 2000-11-25 00:00:00 | 403 | Load Deviation | Deviation | -227346.6345833333 | 22935.09273333331 | -204411.54185 | 1618.2
 | 2000-11-26 00:00:00 | 403 | Load Deviation | Deviation | -215852.4372666667 | 27019.20151666666 | -188833.2357500001 | 1608.99
 | 2000-11-27 00:00:00 | 403 | Load Deviation | Deviation | -319278.4285 | 2558.305999999997 | -316720.1225 | 1938.69
 | 2000-11-28 00:00:00 | 403 | Load Deviation | Deviation | -240239.3861333332 | 13819.82453333333 | -226419.5616 | 1655.3
 | 2000-11-29 00:00:00 | 403 | Load Deviation | Deviation | -293327.4368333335 | 21037.20573333333 | -272290.2311000001 | 1980.53
 | 2000-11-30 00:00:00 | 403 | Load Deviation | Deviation | -291375.5184166667 | 5465.000000000012 | -285910.5184166667 | 1753.24
PGES Total |  |  |  |  | -6332237.030416668 | 501024.4102166666 | -5831212.620199999 | 46182.66
Grand Total |  |  |  |  | -10878675.54545167 | 3376843.461530002 | -7501832.083921665 | 56946.48699999998