Spreadsheet: chris_stokley__3847__1200 EES_PGES_403_042501ds
Sheet: Total

Draft Load Deviation for EES_PGES 12/01/2000 - 12/31/2000
 |  | EPMI Charges To Customers
Trans Type | (CAISO C)
 |  |  |  |  | Data
Customer | MrktDt | ID | Desc. | SchedType | Expense | Revenue | Total | Volume
EES | 2000-12-01 00:00:00 | 403 | Load Deviation | Deviation | -52999.39257833325 | 264782.7118400002 | 211783.3192616669 | -1157.693000000001
 | 2000-12-02 00:00:00 | 403 | Load Deviation | Deviation | -58609.40468000004 | 272371.4619433334 | 213762.0572633334 | -1470.976000000001
 | 2000-12-03 00:00:00 | 403 | Load Deviation | Deviation | -38129.1250516666 | 276058.5275716666 | 237929.4025200001 | -1302.858000000001
 | 2000-12-04 00:00:00 | 403 | Load Deviation | Deviation | -74260.48447666662 | 397139.9146433335 | 322879.4301666669 | -1439.222000000002
 | 2000-12-05 00:00:00 | 403 | Load Deviation | Deviation | -60485.20681166663 | 362865.2770550001 | 302380.0702433334 | -1562.857000000001
 | 2000-12-06 00:00:00 | 403 | Load Deviation | Deviation | -80630.11548166661 | 383869.1846533335 | 303239.0691716669 | -1220.513
 | 2000-12-07 00:00:00 | 403 | Load Deviation | Deviation | -92621.49999999994 | 153786.3303150001 | 61164.83031500015 | -272.1140000000005
 | 2000-12-08 00:00:00 | 403 | Load Deviation | Deviation | -46019.99930666658 | 110552.9982833334 | 64532.99897666681 | -249.8390000000006
 | 2000-12-09 00:00:00 | 403 | Load Deviation | Deviation | -30446 | 169781.1526900002 | 139335.1526900001 | -560.8950000000006
 | 2000-12-10 00:00:00 | 403 | Load Deviation | Deviation | -85280.22210999993 | 112895.8232150001 | 27615.60110500013 | -88.87100000000046
 | 2000-12-11 00:00:00 | 403 | Load Deviation | Deviation | -99645.5 | 128098.75 | 28453.25000000011 | -110.9040000000007
 | 2000-12-12 00:00:00 | 403 | Load Deviation | Deviation | -55822.5833333333 | 174064.3248066668 | 118241.7414733335 | -568.5580000000007
 | 2000-12-13 00:00:00 | 403 | Load Deviation | Deviation | -58996.85066666664 | 215480.1160000001 | 156483.2653333335 | -663.3220000000003
 | 2000-12-14 00:00:00 | 403 | Load Deviation | Deviation | -52310.23898666661 | 377708.70608 | 325398.4670933334 | -1309.621000000001
 | 2000-12-15 00:00:00 | 403 | Load Deviation | Deviation | -45677.95621499997 | 364890.882436667 | 319212.926221667 | -1307.466000000001
 | 2000-12-16 00:00:00 | 403 | Load Deviation | Deviation | -31473.80599333332 | 326560.2420033335 | 295086.4360100002 | -1369.357
 | 2000-12-17 00:00:00 | 403 | Load Deviation | Deviation | -26121.79777999999 | 296770.3178400001 | 270648.5200600001 | -1266.904
 | 2000-12-18 00:00:00 | 403 | Load Deviation | Deviation | -35051.01410666667 | 330761.5183983333 | 295710.5042916667 | -1324.963000000001
 | 2000-12-19 00:00:00 | 403 | Load Deviation | Deviation | -44003.17233333332 | 349250.2919583337 | 305247.1196250004 | -1222.214000000001
 | 2000-12-20 00:00:00 | 403 | Load Deviation | Deviation | -74982.27248666667 | 112353.4403133334 | 37371.16782666682 | -155.5360000000002
 | 2000-12-21 00:00:00 | 403 | Load Deviation | Deviation | -169836.4252199999 | 52239.44473666669 | -117596.9804833333 | 494.2559999999997
 | 2000-12-22 00:00:00 | 403 | Load Deviation | Deviation | -277209.1916266666 | 37909.89211333336 | -239299.2995133332 | 1031.938999999999
 | 2000-12-23 00:00:00 | 403 | Load Deviation | Deviation | -296962.4602199999 | 46333.96634000001 | -250628.4938799999 | 1071.927
 | 2000-12-24 00:00:00 | 403 | Load Deviation | Deviation | -293104.0257533333 | 45244.11045000003 | -247859.9153033333 | 1113.641
 | 2000-12-25 00:00:00 | 403 | Load Deviation | Deviation | -342613.4501316667 | 44000.172945 | -298613.2771866667 | 1260.178
 | 2000-12-26 00:00:00 | 403 | Load Deviation | Deviation | -548929.4326933332 | 26753.86068166668 | -522175.5720116665 | 2633.687999999999
 | 2000-12-27 00:00:00 | 403 | Load Deviation | Deviation | -537006.8407333334 | 38590.14816666667 | -498416.6925666668 | 2104.857
 | 2000-12-28 00:00:00 | 403 | Load Deviation | Deviation | -508616.5131066665 | 36704.67666000001 | -471911.8364466665 | 2021.626999999999
 | 2000-12-29 00:00:00 | 403 | Load Deviation | Deviation | -427292.0372416666 | 30677.18339500002 | -396614.8538466666 | 1682.161
 | 2000-12-30 00:00:00 | 403 | Load Deviation | Deviation | -171124.878775 | 27337.97238333334 | -143786.9063916666 | 995.547
 | 2000-12-31 00:00:00 | 403 | Load Deviation | Deviation | -193432.1056316666 | 33626.04676333335 | -159806.0588683333 | 841.4179999999999
EES Total |  |  |  |  | -4909694.003531666 | 5599459.446681671 | 689765.4431500038 | -3373.444000000016
PGES | 2000-12-01 00:00:00 | 403 | Load Deviation | Deviation | -233729.6560166667 | 14902.27343333336 | -218827.3825833334 | 1250.3
 | 2000-12-02 00:00:00 | 403 | Load Deviation | Deviation | -319999.0889 | 159823.45125 | -160175.63765 | 679.05
 | 2000-12-03 00:00:00 | 403 | Load Deviation | Deviation | -318464.8381333334 | 1242.19173333334 | -317222.6464000001 | 1593.83
 | 2000-12-04 00:00:00 | 403 | Load Deviation | Deviation | -392488.5759500003 | 104030.1841666666 | -288458.3917833336 | 1222.58
 | 2000-12-05 00:00:00 | 403 | Load Deviation | Deviation | -410737.0170999999 | 415 | -410322.0170999999 | 1849.61
 | 2000-12-06 00:00:00 | 403 | Load Deviation | Deviation | -481075.5376666668 | 253.9799999999958 | -480821.5576666668 | 1925.78
 | 2000-12-07 00:00:00 | 403 | Load Deviation | Deviation | -405810 | 4757.053333333333 | -401052.9466666667 | 1602.87
 | 2000-12-08 00:00:00 | 403 | Load Deviation | Deviation | -287532.9213000002 | 27480.462 | -260052.4593000002 | 1139.82
 | 2000-12-09 00:00:00 | 403 | Load Deviation | Deviation | -348810 | 11015 | -337795 | 1351.18
 | 2000-12-10 00:00:00 | 403 | Load Deviation | Deviation | -263720.3957833333 | 18122.5 | -245597.8957833333 | 1192.02
 | 2000-12-11 00:00:00 | 403 | Load Deviation | Deviation | -306020 | 8072.5 | -297947.5 | 1328.51
 | 2000-12-12 00:00:00 | 403 | Load Deviation | Deviation | -328085 | 6262.5 | -321822.5 | 1407.59
 | 2000-12-13 00:00:00 | 403 | Load Deviation | Deviation | -331592.8866666666 | 10275 | -321317.8866666666 | 1406.7
 | 2000-12-14 00:00:00 | 403 | Load Deviation | Deviation | -406609.3603333334 | 3364.999999999989 | -403244.3603333334 | 1615.14
 | 2000-12-15 00:00:00 | 403 | Load Deviation | Deviation | -329884.3406333334 | 12040 | -317844.3406333334 | 1292.84
 | 2000-12-16 00:00:00 | 403 | Load Deviation | Deviation | -367649.2709333333 | 4605.024716666669 | -363044.2462166667 | 1559.54
 | 2000-12-17 00:00:00 | 403 | Load Deviation | Deviation | -325461.5363333335 | 545.000000000009 | -324916.5363333335 | 1600.79
 | 2000-12-18 00:00:00 | 403 | Load Deviation | Deviation | -409886.2183333335 | 2912.5 | -406973.7183333335 | 1818.83
 | 2000-12-19 00:00:00 | 403 | Load Deviation | Deviation | -498667.1933333334 | 2312.500000000012 | -496354.6933333334 | 1985.49
 | 2000-12-20 00:00:00 | 403 | Load Deviation | Deviation | -412352.8960333333 | 1017.499999999991 | -411335.3960333333 | 1724.26
 | 2000-12-21 00:00:00 | 403 | Load Deviation | Deviation | -438357.7905999999 | 670.0000000000015 | -437687.7905999999 | 1801.57
 | 2000-12-22 00:00:00 | 403 | Load Deviation | Deviation | -291583.7312833333 | 31549.33333333332 | -260034.39795 | 1133.17
 | 2000-12-23 00:00:00 | 403 | Load Deviation | Deviation | -279848.7004333334 | 4937.4851 | -274911.2153333334 | 1179.18
 | 2000-12-24 00:00:00 | 403 | Load Deviation | Deviation | -274950.4928500001 | 10741 | -264209.49285 | 1178.02
 | 2000-12-25 00:00:00 | 403 | Load Deviation | Deviation | -539786.5235833334 | 0 | -539786.5235833334 | 2289.11
 | 2000-12-26 00:00:00 | 403 | Load Deviation | Deviation | -385483.4958499999 | 0 | -385483.4958499999 | 2027.24
 | 2000-12-27 00:00:00 | 403 | Load Deviation | Deviation | -396967.6434166667 | 102.4449999999918 | -396865.1984166667 | 1707.03
 | 2000-12-28 00:00:00 | 403 | Load Deviation | Deviation | -359963.8608999999 | 1722.663333333324 | -358241.1975666666 | 1559.28
 | 2000-12-29 00:00:00 | 403 | Load Deviation | Deviation | -274288.4848666667 | 7030.611516666678 | -267257.87335 | 1159.32
 | 2000-12-30 00:00:00 | 403 | Load Deviation | Deviation | -175696.00115 | 28.00000000000038 | -175668.00115 | 1259.39
 | 2000-12-31 00:00:00 | 403 | Load Deviation | Deviation | -241582.3406000001 | 723.053316666666 | -240859.2872833334 | 1315.29
PGES Total |  |  |  |  | -10837085.79898334 | 450954.2122333333 | -10386131.58675 | 46155.33
Grand Total |  |  |  |  | -15746779.802515 | 6050413.658915006 | -9696366.143599998 | 42781.88599999998