Spreadsheet: chris_stokley__3844__1000 EES_PGES_403_042701ds
Sheet: Total

EES_PGES DRAFT LOAD DEVIATION OCTOBER 2000
 |  | EPMI Charges To Customers
Trans Type | (CAISO C)
 |  |  |  |  | Data
Customer | MrktDt | ID | Desc. | SchedType | Expense | Revenue | Total | Volume
EES | 2000-10-01 00:00:00 | 403 | Load Deviation | Deviation | -111177.8110127183 | 93404.4530132467 | -17773.35799947162 | 374.2349999999993
 | 2000-10-02 00:00:00 | 403 | Load Deviation | Deviation | -209856.0952829884 | 64893.86272276002 | -144962.2325602284 | 1066.225999999999
 | 2000-10-03 00:00:00 | 403 | Load Deviation | Deviation | -133690.0364075699 | 46141.59167361837 | -87548.4447339516 | 876.19
 | 2000-10-04 00:00:00 | 403 | Load Deviation | Deviation | -125759.958340225 | 22955.37688248004 | -102804.581457745 | 1667.972
 | 2000-10-05 00:00:00 | 403 | Load Deviation | Deviation | -165884.5936691983 | 32427.46013061004 | -133457.1335385883 | 1365.261
 | 2000-10-06 00:00:00 | 403 | Load Deviation | Deviation | -134288.6196700083 | 19343.89071313335 | -114944.728956875 | 1595.959000000001
 | 2000-10-07 00:00:00 | 403 | Load Deviation | Deviation | -108291.37176 | 21796.42072500002 | -86494.95103500003 | 1302.539
 | 2000-10-08 00:00:00 | 403 | Load Deviation | Deviation | -230156.1569238766 | 20731.7408779 | -209424.4160459766 | 1846.111999999999
 | 2000-10-09 00:00:00 | 403 | Load Deviation | Deviation | -266201.8574812067 | 25167.68718106335 | -241034.1703001433 | 1737.492
 | 2000-10-10 00:00:00 | 403 | Load Deviation | Deviation | -81413.47125906002 | 30656.27786064502 | -50757.19339841499 | 1525.663
 | 2000-10-11 00:00:00 | 403 | Load Deviation | Deviation | -108378.586451175 | 28457.60454000004 | -79920.98191117498 | 1554.421
 | 2000-10-12 00:00:00 | 403 | Load Deviation | Deviation | -87845.36993092333 | 84386.99803187836 | -3458.371899044967 | 904.685
 | 2000-10-13 00:00:00 | 403 | Load Deviation | Deviation | -145628.8606094533 | 36422.50798507171 | -109206.3526243816 | 739.7729999999988
 | 2000-10-14 00:00:00 | 403 | Load Deviation | Deviation | -121077.8301791634 | 67942.75752833334 | -53135.07265083 | 1133.86
 | 2000-10-15 00:00:00 | 403 | Load Deviation | Deviation | -143577.4147329267 | 38961.1978111967 | -104616.21692173 | 1485.982
 | 2000-10-16 00:00:00 | 403 | Load Deviation | Deviation | -192670.8641163933 | 94193.07708717838 | -98477.78702921493 | 1048.975
 | 2000-10-17 00:00:00 | 403 | Load Deviation | Deviation | -156013.9471087767 | 83707.04663859672 | -72306.90047017993 | 951.7869999999994
 | 2000-10-18 00:00:00 | 403 | Load Deviation | Deviation | -87857.32152214 | 77936.56802278005 | -9920.753499359966 | 773.3779999999992
 | 2000-10-19 00:00:00 | 403 | Load Deviation | Deviation | -139976.8900616667 | 75444.44584000006 | -64532.44422166664 | 703.566
 | 2000-10-20 00:00:00 | 403 | Load Deviation | Deviation | -107285.8404941733 | 70756.12230131675 | -36529.71819285659 | 1008.337
 | 2000-10-21 00:00:00 | 403 | Load Deviation | Deviation | -100223.47643 | 49265.63122000001 | -50957.84520999997 | 1157.416
 | 2000-10-22 00:00:00 | 403 | Load Deviation | Deviation | -108715.7295905334 | 50958.79732493337 | -57756.93226559998 | 1399.242
 | 2000-10-23 00:00:00 | 403 | Load Deviation | Deviation | -148886.8567184 | 77189.80962737674 | -71697.04709102327 | 793.8329999999996
 | 2000-10-24 00:00:00 | 403 | Load Deviation | Deviation | -154939.9297279867 | 58732.26301651507 | -96207.66671147163 | 1106.476
 | 2000-10-25 00:00:00 | 403 | Load Deviation | Deviation | -141677.6753733333 | 36129.21202666666 | -105548.4633466667 | 1167.657
 | 2000-10-26 00:00:00 | 403 | Load Deviation | Deviation | -93776.50256166667 | 69421.39454666672 | -24355.10801499996 | 876.6429999999992
 | 2000-10-27 00:00:00 | 403 | Load Deviation | Deviation | -74390.96334833336 | 34392.47501500003 | -39998.48833333331 | 964.5079999999998
 | 2000-10-28 00:00:00 | 403 | Load Deviation | Deviation | -163841.3629933334 | 36429.81925500001 | -127411.5437383334 | 1349.908
 | 2000-10-29 00:00:00 | 403 | Load Deviation | Deviation | -142732.800105 | 16482.35798166668 | -126250.4421233333 | 1670.196999999999
 | 2000-10-30 00:00:00 | 403 | Load Deviation | Deviation | -107421.1898783333 | 57237.81724666671 | -50183.3726316666 | 741.7859999999985
 | 2000-10-31 00:00:00 | 403 | Load Deviation | Deviation | -70730.61706333337 | 25102.29937833336 | -45628.31768500001 | 801.507000000001
EES Total |  |  |  |  | -4164370.000803896 | 1547068.964205634 | -2617301.036598263 | 35691.58599999999
PGES | 2000-10-01 00:00:00 | 403 | Load Deviation | Deviation | -609946.3680155168 | 23278.16220004999 | -586668.2058154667 | 5142.43
 | 2000-10-02 00:00:00 | 403 | Load Deviation | Deviation | -268105.2676873334 | 40381.3669948 | -227723.9006925334 | 1664.89
 | 2000-10-03 00:00:00 | 403 | Load Deviation | Deviation | -206266.6415608167 | 45504.82046546668 | -160761.82109535 | 1755.74
 | 2000-10-04 00:00:00 | 403 | Load Deviation | Deviation | -197922.5951472833 | 27934.56666666666 | -169988.0284806167 | 2000.23
 | 2000-10-05 00:00:00 | 403 | Load Deviation | Deviation | -233991.6564014 | 34748.06283699998 | -199243.5935644 | 1898.93
 | 2000-10-06 00:00:00 | 403 | Load Deviation | Deviation | -104339.9758924834 | 43684.8861438 | -60655.08974868335 | 2007.09
 | 2000-10-07 00:00:00 | 403 | Load Deviation | Deviation | -73024.83258333334 | 24613.65689999999 | -48411.17568333336 | 1569.32
 | 2000-10-08 00:00:00 | 403 | Load Deviation | Deviation | -136854.5550541334 | 4057.629819483332 | -132796.92523465 | 1540.9
 | 2000-10-09 00:00:00 | 403 | Load Deviation | Deviation | -242020.3915496834 | 35132.76438333333 | -206887.62716635 | 1902.9
 | 2000-10-10 00:00:00 | 403 | Load Deviation | Deviation | -122197.6317948167 | 28475.26086946667 | -93722.37092535006 | 2122.26
 | 2000-10-11 00:00:00 | 403 | Load Deviation | Deviation | -139597.5318464666 | 31355.79646666667 | -108241.7353798 | 1968.08
 | 2000-10-12 00:00:00 | 403 | Load Deviation | Deviation | -147172.6941785834 | 51397.54640836664 | -95775.14777021672 | 1821.06
 | 2000-10-13 00:00:00 | 403 | Load Deviation | Deviation | -136566.4823029833 | 53262.19027758333 | -83304.29202540002 | 1731.46
 | 2000-10-14 00:00:00 | 403 | Load Deviation | Deviation | -113590.0568841667 | 51246.66323333333 | -62343.39365083337 | 1419.74
 | 2000-10-15 00:00:00 | 403 | Load Deviation | Deviation | -83200.83218761667 | 4462.886916666658 | -78737.94527095002 | 1468.86
 | 2000-10-16 00:00:00 | 403 | Load Deviation | Deviation | -200619.0813438334 | 40258.35686616668 | -160360.7244776667 | 1535.94
 | 2000-10-17 00:00:00 | 403 | Load Deviation | Deviation | -176353.5126663667 | 33219.67933 | -143133.8333363667 | 1778.75
 | 2000-10-18 00:00:00 | 403 | Load Deviation | Deviation | -147968.3560493334 | 37569.2048058 | -110399.1512435334 | 2169.71
 | 2000-10-19 00:00:00 | 403 | Load Deviation | Deviation | -171547.0552166667 | 27691.88333333333 | -143855.1718833334 | 1944.62
 | 2000-10-20 00:00:00 | 403 | Load Deviation | Deviation | -155434.7186982 | 16007.77458333335 | -139426.9441148667 | 1917.51
 | 2000-10-21 00:00:00 | 403 | Load Deviation | Deviation | -114598.7583666667 | 21384.93388333334 | -93213.8244833333 | 1671.93
 | 2000-10-22 00:00:00 | 403 | Load Deviation | Deviation | -93321.18846133335 | 1855.133000000003 | -91466.05546133335 | 1782.91
 | 2000-10-23 00:00:00 | 403 | Load Deviation | Deviation | -170718.6299215333 | 29698.64653333334 | -141019.9833882 | 1804.87
 | 2000-10-24 00:00:00 | 403 | Load Deviation | Deviation | -154709.9222639833 | 33830.14666666666 | -120879.7755973167 | 1876.5
 | 2000-10-25 00:00:00 | 403 | Load Deviation | Deviation | -214829.4500333334 | 24132.6 | -190696.8500333334 | 2268.96
 | 2000-10-26 00:00:00 | 403 | Load Deviation | Deviation | -199471.1016833334 | 31334.55333333333 | -168136.5483500001 | 2394.89
 | 2000-10-27 00:00:00 | 403 | Load Deviation | Deviation | -132841.6759666667 | 20909.09311666666 | -111932.58285 | 2033.8
 | 2000-10-28 00:00:00 | 403 | Load Deviation | Deviation | -114991.5517333334 | 39313.80108333332 | -75677.75065000005 | 1810.51
 | 2000-10-29 00:00:00 | 403 | Load Deviation | Deviation | -128859.58045 | 3526.68466666667 | -125332.8957833334 | 1969.43
 | 2000-10-30 00:00:00 | 403 | Load Deviation | Deviation | -119628.73895 | 18089.95150000001 | -101538.78745 | 2080.69
 | 2000-10-31 00:00:00 | 403 | Load Deviation | Deviation | -86392.70830000003 | 1765.011150000001 | -84627.69715000002 | 2234.41
PGES Total |  |  |  |  | -5197083.543191201 | 880123.7144346498 | -4316959.828756551 | 61289.32
Grand Total |  |  |  |  | -9361453.543995097 | 2427192.678640284 | -6934260.865354814 | 96980.90599999999