Spreadsheet: chris_stokley__3836__ISO to SCL Comparison Pivots
Sheet: Energy ISO to SCL Comparison

 |  | Data |  |  |  |  |  | Data
dtTradingDate | iTradingHour | ISO Energy Volume | Avg of ISO Rate | [NAME] |  | Date | Hour | SCL Energy Volume | [NAME] for SCL | SCL Amount |  | Vol Diff | Rate Diff | Amount Diff
2000-09-06 00:00:00 | 7 | 49.98 | 250.0006 | -12499.98 |  | 2001-09-06 00:00:00 | 7 | 50 | 249.76987 | -12488.4935
 | 8 | 19.99 | 241.845325 | -4844.06 |  |  | 8 | 35 | 226.76959 | -7936.935649999999
 | 9 | 41.68 | 243.3338316666667 | -10183.39 |  |  | 9 | 43 | 245.09659 | -10539.15337
 | 10 | 49.98 | 249.5002 | -12474.96 |  |  | 10 | 50 | 249.48671 | -12474.3355
 | 11 | 39.18 | 249.1007666666667 | -9756.48 |  |  | 11 | 40 | 249.09755 | -9963.902
 | 12 | 49.98 | 245.0265833333333 | -12251.28 |  |  | 12 | 50 | 245.31136 | -12265.568
 | 16 | 7.84 | 225.15896 | -1763.76 |  |  | 16 | 16 | 190.33804 | -3045.40864
 | 17 | 49.98 | 243.9899766666666 | -12199.45 |  |  | 17 | 50 | 243.99857 | -12199.9285
 | 18 | 30.85 | 206.84969 | -6377.9 |  |  | 18 | 37 | 206.50401 | -7640.64837
 | 20 | 9.99 | 249.7014966666667 | -2496.99 |  |  | 19 | 27 | 239.60408 | -6469.31016
 | 21 | 11.49 | 250.0013 | -2874.99 |  |  | 20 | 20 | 216.9675 | -4339.35
 | 22 | 14.68 | 249.10137 | -3653.52 |  |  | 21 | 23 | 236.25131 | -5433.78013
9/6/00 Total |  | 375.62 | 242.3850387931033 | -91376.76000000005 |  |  | 22 | 22 | 237.61626 | -5227.557720000001
2000-09-07 00:00:00 | 9 | 8.01 | 249.00064 | -1992.03 |  | 6-Sep Total |  | 463 | 233.60088 | -110024.37154
 | 11 | 33.32 | 245.000195 | -8213.32 |  | 2001-09-07 00:00:00 | 7 | 41 | 232.40474 | -9528.59434
 | 12 | 34.98 | 250.0009083333333 | -8749.98 |  |  | 9 | 16 | 244.09737 | -3905.55792
 | 19 | 49.98 | 212.0000466666667 | -10599.96 |  |  | 11 | 38 | 245.67381 | -9335.60478
 | 22 | 49.98 | 249.7006 | -12484.98 |  |  | 12 | 38 | 249.75877 | -9490.83326
9/7/00 Total |  | 176.27 | 240.2671266666667 | -42040.27 |  |  | 19 | 50 | 211.67844 | -10583.922
2000-09-08 00:00:00 | 13 | 49.98 | 239.00016 | -11949.96 |  |  | 22 | 50 | 249.07057 | -12453.5285
 | 15 | 31.65 | 223.428864 | -7075.21 |  | 7-Sep Total |  | 233 | 238.7806166666667 | -55298.0408
 | 16 | 2 | 200.1 | -400.2 |  | 2001-09-08 00:00:00 | 13 | 50 | 237.36877 | -11868.4385
 | 19 | 24.68 | 200 | -4933.36 |  |  | 15 | 38 | 218.93742 | -8319.62196
9/8/00 Total |  | 108.31 | 220.6673694117647 | -24358.73 |  |  | 16 | 6 | 200.46483 | -1202.78898
2000-09-11 00:00:00 | 22 | 4.5 | 250.00238 | -1125.01 |  |  | 19 | 37 | 180.40787 | -6675.09119
9/11/00 Total |  | 4.5 | 250.00238 | -1125.01 |  | 8-Sep Total |  | 131 | 209.2947225 | -28065.94063
2000-09-12 00:00:00 | 10 | 1.5 | 231.6666666666667 | -347.5 |  | 2001-09-11 00:00:00 | 22 | 17 | 243.33846 | -4136.75382
 | 11 | 3.91 | 244.0024 | -955.66 |  | 11-Sep Total |  | 17 | 243.33846 | -4136.75382
 | 12 | 10.82 | 247.0857833333334 | -2677.91 |  | 2001-09-12 00:00:00 | 10 | 3 | 205.40353 | -616.2105899999999
 | 13 | 25.02 | 249.00041 | -6225.06 |  |  | 11 | 8 | 219.35381 | -1754.83048
 | 14 | 25.02 | 249.2340083333333 | -6230.9 |  |  | 12 | 11 | 247.3829 | -2721.2119
 | 15 | 25.02 | 250.0012 | -6250.08 |  |  | 13 | 25 | 248.99095 | -6224.77375
 | 16 | 25.02 | 250.0012 | -6250.08 |  |  | 14 | 25 | 249.26091 | -6231.52275
 | 17 | 25.02 | 250.0012 | -6250.08 |  |  | 15 | 25 | 249.99995 | -6249.998750000001
 | 18 | 21.27 | 250.003 | -5312.58 |  |  | 16 | 25 | 250.00002 | -6250.0005
 | 19 | 25.02 | 250.0012 | -6250.08 |  |  | 17 | 25 | 249.99998 | -6249.9995
 | 20 | 20 | 249.8666666666667 | -4998 |  |  | 18 | 19 | 249.99998 | -4749.99962
9/12/00 Total |  | 207.62 | 248.3029201666668 | -51747.93 |  |  | 19 | 25 | 249.99998 | -6249.9995
2000-09-13 00:00:00 | 13 | 49.98 | 250.0006 | -12499.98 |  |  | 20 | 21 | 249.91972 | -5248.31412
 | 14 | 23.16 | 249.2500975 | -5772.65 |  | 12-Sep Total |  | 212 | 242.7556118181818 | -52546.86146000001
 | 15 | 25.02 | 250.0012 | -6250.08 |  | 2001-09-13 00:00:00 | 12 | 15 | 249 | -3735
 | 16 | 25.02 | 250.0012 | -6250.08 |  |  | 13 | 50 | 250.00003 | -12500.0015
 | 17 | 25.02 | 250.0012 | -6250.08 |  |  | 14 | 38 | 249.53394 | -9482.28972
 | 19 | 49.98 | 250.0006 | -12499.98 |  |  | 15 | 50 | 249.99997 | -12499.9985
 | 20 | 3.66 | 250.00273 | -916.66 |  |  | 16 | 50 | 250 | -12500
 | 21 | 11.49 | 249.6673866666667 | -2871.15 |  |  | 17 | 50 | 249.99998 | -12499.999
9/13/00 Total |  | 213.33 | 249.8983797435897 | -53310.66 |  |  | 18 | 50 | 249.96545 | -12498.2725
2000-09-14 00:00:00 | 16 | 25.02 | 250.0012 | -6250.08 |  |  | 19 | 50 | 249.99997 | -12499.9985
 | 17 | 25.02 | 250.0012 | -6250.08 |  |  | 20 | 11 | 249.1362 | -2740.4982
 | 18 | 25.02 | 250.0012 | -6250.08 |  |  | 21 | 23 | 249.20786 | -5731.78078
 | 19 | 49.98 | 250.0006 | -12499.98 |  |  | 22 | 40 | 249 | -9960
 | 20 | 40.98 | 250.00073 | -10249.98 |  | 13-Sep Total |  | 427 | 249.7205866666667 | -106647.8387
 | 21 | 2.66 | 250.00375 | -666.66 |  | 2001-09-14 00:00:00 | 16 | 50 | 250 | -12500
 | 22 | 2.66 | 248.99872 | -663.98 |  |  | 17 | 25 | 250.00002 | -6250.0005
9/14/00 Total |  | 171.34 | 249.9421917647059 | -42830.84 |  |  | 18 | 50 | 250.00002 | -12500.001
2000-09-15 00:00:00 | 14 | 45 | 250 | -11250 |  |  | 19 | 50 | 250.00002 | -12500.001
 | 15 | 45 | 250 | -11250 |  |  | 20 | 41 | 249.99997 | -10249.99877
9/15/00 Total |  | 90 | 250 | -22500 |  |  | 21 | 8 | 249 | -1992
2000-09-16 00:00:00 | 13 | 18.35 | 250.00136 | -4583.4 |  |  | 22 | 8 | 249 | -1992
 | 14 | 21 | 250 | -5250 |  | 14-Sep Total |  | 232 | 249.7777833333333 | -57984.00127
 | 15 | 30 | 250 | -7500 |  | 2001-09-15 00:00:00 | 14 | 45 | 248.8698 | -11199.141
 | 16 | 30 | 250 | -7500 |  |  | 15 | 45 | 250 | -11250
 | 17 | 30 | 250 | -7500 |  | 15-Sep Total |  | 90 | 249.4349 | -22449.141
 | 20 | 30 | 250 | -7500 |  | 2001-09-16 00:00:00 | 13 | 22 | 249.56305 | -5490.3871
 | 22 | 23.67 | 250.0006 | -5916.68 |  |  | 14 | 21 | 249.99998 | -5249.99958
9/16/00 Total |  | 183.02 | 250.000245 | -45750.08 |  |  | 15 | 30 | 250.00002 | -7500.0006
2000-09-17 00:00:00 | 11 | 21.64 | 248.9996466666667 | -5384.68 |  |  | 16 | 30 | 249.99997 | -7499.9991
 | 14 | 7.16 | 249.5458425 | -1788.47 |  |  | 17 | 30 | 250.00002 | -7500.0006
 | 15 | 20.43 | 249.83433 | -5102.14 |  |  | 20 | 30 | 250 | -7500
 | 16 | 25.02 | 250.0012 | -6250.08 |  |  | 22 | 33 | 248.20718 | -8190.83694
 | 17 | 25.02 | 250.0012 | -6250.08 |  | 16-Sep Total |  | 196 | 249.68146 | -48931.22392
 | 18 | 25.02 | 250.0012 | -6250.08 |  | 2001-09-17 00:00:00 | 11 | 25 | 248.32808 | -6208.202
 | 20 | 25.02 | 249.9912 | -6249.83 |  |  | 14 | 11 | 244.53647 | -2689.90117
 | 21 | 49.98 | 249.3898 | -12469.44 |  |  | 15 | 22 | 249.87788 | -5497.31336
9/17/00 Total |  | 199.29 | 249.7281484782608 | -49744.8 |  |  | 16 | 25 | 250 | -6250
2000-09-19 00:00:00 | 9 | 39.17 | 250.0002 | -9791.68 |  |  | 17 | 25 | 250.00003 | -6250.00075
 | 11 | 37.08 | 250.0002181818182 | -9270.83 |  |  | 18 | 25 | 250 | -6250
 | 15 | 25.02 | 250.0012 | -6250.08 |  |  | 20 | 25 | 249.27077 | -6231.76925
 | 16 | 17.5 | 250 | -4375 |  |  | 21 | 50 | 249.52237 | -12476.1185
 | 17 | 25.02 | 250.0012 | -6250.08 |  | 17-Sep Total |  | 208 | 248.94195 | -51853.30503
 | 18 | 43.77 | 250.0006 | -10937.58 |  | 2001-09-19 00:00:00 | 9 | 42 | 247.2843 | -10385.9406
 | 19 | 50.04 | 250.0012 | -12500.16 |  |  | 11 | 42 | 249.99997 | -10499.99874
 | 20 | 50.04 | 250.0012 | -12500.16 |  |  | 14 | 25 | 250.00002 | -6250.0005
 | 21 | 50.04 | 250.0012 | -12500.16 |  |  | 15 | 25 | 250.00005 | -6250.001249999999
 | 22 | 13.4 | 250.0015125 | -3350.02 |  |  | 16 | 21 | 249.99998 | -5249.99958
9/19/00 Total |  | 351.08 | 250.0008656976743 | -87725.74999999987 |  |  | 17 | 25 | 249.99997 | -6249.99925
2000-09-20 00:00:00 | 8 | 40 | 250 | -10000 |  |  | 18 | 46 | 250 | -11500
 | 15 | 50.04 | 250.0012 | -12500.16 |  |  | 19 | 50 | 249.99998 | -12499.999
 | 20 | 45.02 | 250.0006666666667 | -11250.08 |  |  | 20 | 50 | 249.99997 | -12499.9985
 | 21 | 46.65 | 250.0005333333333 | -11666.65 |  |  | 21 | 50 | 249.99998 | -12499.999
 | 22 | 18.66 | 250.0010725 | -4666.67 |  |  | 22 | 22 | 248.34363 | -5463.559859999999
9/20/00 Total |  | 200.37 | 250.0007614705883 | -50083.56 |  | 19-Sep Total |  | 398 | 249.726734375 | -99349.49627999999
Grand Total |  | 2280.75 | 247.0917499340653 | -562594.39 |  | 2001-09-20 00:00:00 | 8 | 42 | 250.00002 | -10500.00084
 |  |  |  |  |  |  | 15 | 50 | 250 | -12500
 |  |  |  |  |  |  | 20 | 46 | 249.65295 | -11484.0357
 | Paid in Import Deviation |  |  |  |  |  | 21 | 47 | 250.00002 | -11750.00094
 | Paid in Future Month (disputed) pay now since we have money |  |  |  |  |  | 22 | 29 | 248.86 | -7216.94
 | Not a valid schedule; estimate sheet was wrong |  |  |  |  | 20-Sep Total |  | 214 | 249.752165 | -53450.97748
 | Disputed/denied - no payment received |  |  |  |  | Grand Total |  | 2821 | 244.3515247959184 | -690737.95193
 | Half paid in future month (dispute); other half paid in Import Deviation