Spreadsheet: robert_badeer__33101__EnergyBillSummary
Sheet: DailyData

 |  | PXDayAheadBill | ExpostBill | AncillaryServiceBill
 | 2000-04-01 00:00:00 | 12.8366966875 | 0.70050690625 | 0.310186760742187
 | 2000-04-02 00:00:00 | 12.3951035312499 | 0.74797550427246 | 0.452879734375
 | 2000-04-03 00:00:00 | 15.76601690625 | 1.08732816137695 | 0.366561844726562
 | 2000-04-04 00:00:00 | 16.12375146875 | 0.567964706481933 | 0.296817345703125
 | 2000-04-05 00:00:00 | 15.9002405625 | 0.0065854706728002 | 0.351407735351562
 | 2000-04-06 00:00:00 | 15.45307503125 | 0.0592030970545677 | 0.382986016601562
 | 2000-04-07 00:00:00 | 18.7504376875 | 0.201289561334961 | 0.391690989257812
 | 2000-04-08 00:00:00 | 12.329924 | 0.66235485571289 | 0.363387698242187
 | 2000-04-09 00:00:00 | 11.6560266875 | 0.143281703839302 | 0.327506153320312
 | 2000-04-10 00:00:00 | 14.0156793749999 | 0.422610392333984 | 0.422004555664062
 | 2000-04-11 00:00:00 | 14.29539296875 | 2.16025816064453 | 0.509873038085937
 | 2000-04-12 00:00:00 | 13.610198625 | 1.11214002175903 | 0.531750237304687
 | 2000-04-13 00:00:00 | 14.052220453125 | 0.556685754394531 | 0.482458425781249
 | 2000-04-14 00:00:00 | 13.8895832812499 | 0.528439939025878 | 0.436431011718749
 | 2000-04-15 00:00:00 | 11.033791265625 | 0.474359841327392 | 0.488158124023437
 | 2000-04-16 00:00:00 | NULL | 1.07817087695312 | 0.422867571289062
 | 2000-04-17 00:00:00 | 13.1700635624999 | 0.657432453347949 | 0.497254494140625
 | 2000-04-18 00:00:00 | 13.63456284375 | 0.73894758985455 | 0.517918543945312
 | 2000-04-19 00:00:00 | 13.70171778125 | 0.552418366815141 | 0.491078247070312
 | 2000-04-20 00:00:00 | 13.6816744375 | 0.680186092792987 | 0.497366883789062
 | 2000-04-21 00:00:00 | 12.13409421875 | 0.00884294993591308 | 0.874528395507812
 | 2000-04-22 00:00:00 | 8.9678174296875 | -0.00500576572227478 | 0.404670245117187
 | 2000-04-23 00:00:00 | 8.9914835546875 | 0.0134257989721298 | 0.516867952148437
 | 2000-04-24 00:00:00 | 11.8795405078125 | 1.00731305108642 | 0.427451526367187
 | 2000-04-25 00:00:00 | 14.5921956171875 | 1.8396930821228 | 0.523721723632812
 | 2000-04-26 00:00:00 | 17.7647143125 | 4.78321391601562 | 0.966140120117187
 | 2000-04-27 00:00:00 | 27.4886106875 | 0.674765283286987 | 1.42155428808593
 | 2000-04-28 00:00:00 | 13.1980988984375 | 0.397322011099023 | 0.679800619140624
 | 2000-04-29 00:00:00 | 11.686435640625 | 1.05907757812499 | 0.93891100390625
 | 2000-04-30 00:00:00 | 20.7142269218749 | 1.56353894384765 | 0.727289802734375
 | 2000-05-01 00:00:00 | 33.4015523125 | 6.17218862451171 | 0.940373457031249
 | 2000-05-02 00:00:00 | 22.974784328125 | 2.60024886039269 | 1.28538866796875
 | 2000-05-03 00:00:00 | 32.07309721875 | 4.60690120982939 | 1.1522725
 | 2000-05-04 00:00:00 | 19.946750046875 | 0.509833375164587 | 0.881224705078125
 | 2000-05-05 00:00:00 | 16.52507115625 | 0.317703139629521 | 0.710596043945312
 | 2000-05-06 00:00:00 | 11.331553171875 | 0.364644983032226 | 0.813240443359374
 | 2000-05-07 00:00:00 | 10.453506421875 | 0.59498025427246 | 0.574317405273437
 | 2000-05-08 00:00:00 | 16.078823140625 | 0.461145619614941 | 0.483717078124999
 | 2000-05-09 00:00:00 | 17.16448759375 | 1.08035392675781 | 0.555461015625
 | 2000-05-10 00:00:00 | 20.6648270624999 | 0.833128277755737 | 0.526058170898437
 | 2000-05-11 00:00:00 | 17.96188146875 | 0.796412448242187 | 0.494197456054687
 | 2000-05-12 00:00:00 | 17.79593575 | 1.67679877978515 | 0.464754245117187
 | 2000-05-13 00:00:00 | 15.3045068125 | 1.44650453187437 | 0.376882169921875
 | 2000-05-14 00:00:00 | 13.705363703125 | 0.262399928199768 | 0.153637958984374
 | 2000-05-15 00:00:00 | 15.08702953125 | 1.98362731640624 | 0.435173596679687
 | 2000-05-16 00:00:00 | 18.1224163125 | 0.582078498168945 | 0.366631153320312
 | 2000-05-17 00:00:00 | 17.96132159375 | 0.651075077392578 | 0.375016599609375
 | 2000-05-18 00:00:00 | 18.42140625 | 1.7505485234375 | 0.342669993164062
 | 2000-05-19 00:00:00 | 19.75183290625 | 2.61514477539062 | 1.37064127001953
 | 2000-05-20 00:00:00 | 17.3373105625 | 3.22049068164062 | 0.702090344726562
 | 2000-05-21 00:00:00 | 19.37824425 | 13.3264477539062 | 3.34476474902343
 | 2000-05-22 00:00:00 | 56.80950871875 | 14.2770108522785 | 15.686703234375
 | 2000-05-23 00:00:00 | 131.839655125 | 3.72357430687535 | 14.95771134375
 | 2000-05-24 00:00:00 | 56.0102838749999 | 1.80387103173828 | 8.07620386523437
 | 2000-05-25 00:00:00 | 27.998534625 | 0.603998532531738 | 1.75911662109375
 | 2000-05-26 00:00:00 | 25.25706371875 | 1.57589972924804 | 1.11140060351562
 | 2000-05-27 00:00:00 | 19.89394734375 | 3.24051359716796 | 0.6963375546875
 | 2000-05-28 00:00:00 | 30.44402053125 | 1.57944883349609 | 0.706096437499999
 | 2000-05-29 00:00:00 | 24.49095328125 | 0.311607964483737 | 0.760758167968749
 | 2000-05-30 00:00:00 | 27.5965915312499 | 1.13098519861102 | 1.31657218164062
 | 2000-05-31 00:00:00 | 26.9305871249999 | 3.47948767675781 | 0.967546458984374
 | 2000-06-01 00:00:00 | 27.05939678125 | 2.30626608105468 | 0.764666859375
 | 2000-06-02 00:00:00 | 34.8643245625 | 0.807685891357421 | 0.918223941406249
 | 2000-06-03 00:00:00 | 36.2712243125 | 0.126401404052734 | 0.954074173828124
 | 2000-06-04 00:00:00 | 33.0287283125 | 0.404711105438232 | 0.763995968749999
 | 2000-06-05 00:00:00 | 32.37317478125 | 0.584009943847656 | 0.9239246484375
 | 2000-06-06 00:00:00 | 31.4349189375 | 3.23306851171874 | 0.751581779296874
 | 2000-06-07 00:00:00 | 32.320523375 | 1.86968159375 | 0.702900951171875
 | 2000-06-08 00:00:00 | 31.97634975 | 0.215150292297363 | 0.75079393359375
 | 2000-06-09 00:00:00 | 27.8247569374999 | 0.443166654464721 | 0.601605112304687
 | 2000-06-10 00:00:00 | 23.167047125 | 1.27469415161132 | 0.718883037109374
 | 2000-06-11 00:00:00 | 20.84808409375 | 1.830612984375 | 0.701240527343749
 | 2000-06-12 00:00:00 | 44.13272725 | 2.21415904739063 | 2.31350258007812
 | 2000-06-13 00:00:00 | 54.0541821874999 | 35.5329311874999 | 56.3980430058593
 | 2000-06-14 00:00:00 | 173.122621 | 54.4860858476562 | 65.5064057617187
 | 2000-06-15 00:00:00 | 215.473627125 | 23.4283911403808 | 59.51872434375
 | 2000-06-16 00:00:00 | 172.081786999999 | 1.55579422363281 | 14.4571652187499
 | 2000-06-17 00:00:00 | 40.5249781874999 | 0.559631441905975 | 1.618962265625
 | 2000-06-18 00:00:00 | 28.3164161875 | 0.233284911087036 | 0.843543566406249
 | 2000-06-19 00:00:00 | 39.949538375 | 2.98769631492614 | 1.04125751562499
 | 2000-06-20 00:00:00 | 33.32566775 | 2.65889526367187 | 1.47469613671875
 | 2000-06-21 00:00:00 | 39.8457351249999 | 3.64027494628906 | 2.72124448632812
 | 2000-06-22 00:00:00 | 64.122222375 | 5.98095071264648 | 11.5555491777343
 | 2000-06-23 00:00:00 | 61.2006778749999 | 0.833771425476074 | 7.740995515625
 | 2000-06-24 00:00:00 | 37.6245509374999 | 1.42755869531249 | 1.50539438867187
 | 2000-06-25 00:00:00 | 29.93457565625 | 2.95580622143554 | 1.1271553203125
 | 2000-06-26 00:00:00 | 82.150298625 | 22.6794094921874 | 21.8370123964843
 | 2000-06-27 00:00:00 | 151.567222937499 | 26.7390417256164 | 40.8438145156249
 | 2000-06-28 00:00:00 | 233.337270625 | 32.7283893222656 | 45.4306950546874
 | 2000-06-29 00:00:00 | 235.04362225 | 18.5728954599609 | 51.3969200390625