Spreadsheet: jonathan_mckay__16940__TETCO Flows vs Price
Sheet: Linden

 | UTILIZED_CAPACITY_QTY | Mkt-3 to HH Spread | HH Price | Mkt-3 Price
2000-10-10 00:00:00 | 640000 | 0.49 | 5.055 | 5.545
2000-10-11 00:00:00 | 627000 | 0.435 | 5.08 | 5.515
2000-10-12 00:00:00 | 500000 | 0.38 | 5.16 | 5.54
2000-10-13 00:00:00 | 406000 | 0.38 | 5.545 | 5.925
2000-10-16 00:00:00 | 527000 | 0.32 | 5.43 | 5.75
2000-10-17 00:00:00 | 586000 | 0.365 | 5.34 | 5.705
2000-10-18 00:00:00 | 522000 | 0.405 | 5.27 | 5.675
2000-10-19 00:00:00 | 537000 | 0.42 | 5.38 | 5.8
2000-10-20 00:00:00 | 461000 | 0.385 | 5.04 | 5.425
2000-10-23 00:00:00 | 519000 | 0.365 | 4.845 | 5.21
2000-10-24 00:00:00 | 492000 | 0.3649999999999993 | 4.815 | 5.18
2000-10-25 00:00:00 | 460000 | 0.34 | 4.845 | 5.185
2000-10-27 00:00:00 | 437000 | 0.3599999999999994 | 4.61 | 4.97
2000-10-30 00:00:00 | 767000 | 0.375 | 4.5 | 4.875
2000-10-31 00:00:00 | 818000 | 0.635 | 4.55 | 5.185
2000-11-01 00:00:00 | 675000 | 0.495 | 4.38 | 4.875
2000-11-02 00:00:00 | 632000 | 0.3400000000000007 | 4.39 | 4.73
2000-11-03 00:00:00 | 530000 | 0.295 | 4.47 | 4.765
2000-11-06 00:00:00 | 695000 | 0.265 | 4.63 | 4.895
2000-11-07 00:00:00 | 612000 | 0.2650000000000006 | 4.6 | 4.865
2000-11-08 00:00:00 | 631000 | 0.25 | 4.675 | 4.925
2000-11-09 00:00:00 | 587000 | 0.27 | 4.92 | 5.19
2000-11-10 00:00:00 | 569000 | 0.3249999999999993 | 5.36 | 5.685
2000-11-13 00:00:00 | 635000 | 0.25 | 5.245 | 5.495
2000-11-14 00:00:00 | 663000 | 0.3 | 5.595 | 5.895
2000-11-15 00:00:00 | 761000 | 0.31 | 5.795 | 6.105
2000-11-16 00:00:00 | 731000 | 0.305 | 5.94 | 6.245
2000-11-17 00:00:00 | 775000 | 0.325 | 5.88 | 6.205
2000-11-21 00:00:00 | 927000 | 0.545 | 6.235 | 6.78
2000-11-26 00:00:00 | 608000 | 0.3699999999999992 | 6.315 | 6.685
2000-11-27 00:00:00 | 555000 | 0.3699999999999992 | 6.315 | 6.685
2000-11-28 00:00:00 | 824000 | 0.43 | 6.245 | 6.675
2000-11-29 00:00:00 | 903000 | 0.425 | 5.925 | 6.35
2000-11-30 00:00:00 | 1075000 | 0.48 | 5.95 | 6.43
2000-12-01 00:00:00 | 836000 | 0.785 | 6.31 | 7.095
2000-12-03 00:00:00 | 937000 | 0.695 | 6.595 | 7.29
2000-12-04 00:00:00 | 801000 | 0.695 | 6.595 | 7.29
2000-12-05 00:00:00 | 860000 | 0.895 | 7.485 | 8.38
2000-12-06 00:00:00 | 991000 | 3.42 | 8.015 | 11.435
2000-12-07 00:00:00 | 995000 | 4.895 | 8.855 | 13.75
2000-12-08 00:00:00 | 915000 | 0.9599999999999991 | 8.615 | 9.575
2000-12-10 00:00:00 | 974000 | 0.7900000000000009 | 8.065 | 8.855
2000-12-11 00:00:00 | 756000 | 0.7900000000000009 | 8.065 | 8.855
2000-12-12 00:00:00 | 808000 | 1.61 | 9.935 | 11.545
2000-12-13 00:00:00 | 925000 | 2 | 8.72 | 10.72
2000-12-14 00:00:00 | 814000 | 1.015 | 7.695 | 8.71
2000-12-15 00:00:00 | 741000 | 0.6900000000000013 | 7.52 | 8.21
2000-12-17 00:00:00 | 582000 | 0.7899999999999991 | 7.83 | 8.62
2000-12-18 00:00:00 | 746000 | 0.7899999999999991 | 7.83 | 8.62
2000-12-19 00:00:00 | 852000 | 1.335 | 9.28 | 10.615
2000-12-20 00:00:00 | 965000 | 1.23 | 9.12 | 10.35
2000-12-21 00:00:00 | 898000 | 1.59 | 9.91 | 11.5
2000-12-22 00:00:00 | 952000 | 2.31 | 10.48 | 12.79
2000-12-25 00:00:00 | 1090000 | 3.97 | 10.495 | 14.465
2000-12-26 00:00:00 | 989000 | 3.97 | 10.495 | 14.465
2000-12-27 00:00:00 | 941000 | 2.84 | 10.12 | 12.96
2000-12-28 00:00:00 | 1010000 | 2.975 | 9.595 | 12.57
2000-12-29 00:00:00 | 923000 | 3.215 | 9.23 | 12.445
2001-01-03 00:00:00 | 854000 | 2.73 | 9.76 | 12.49
2001-01-04 00:00:00 | 869000 | 1.735 | 9.665 | 11.4
2001-01-05 00:00:00 | 810000 | 1.1 | 9.405 | 10.505
2001-01-08 00:00:00 | 790000 | 0.99 | 9.825 | 10.815
2001-01-09 00:00:00 | 1030000 | 1.195 | 10.34 | 11.535
2001-01-10 00:00:00 | 935000 | 0.885 | 9.945 | 10.83
2001-01-11 00:00:00 | 884000 | 0.855 | 9.9 | 10.755
2001-01-12 00:00:00 | 789000 | 1.07 | 8.975 | 10.045
2001-01-16 00:00:00 | 712000 | 0.82 | 8.76 | 9.58
2001-01-17 00:00:00 | 744000 | 0.6550000000000011 | 8.19 | 8.845
2001-01-18 00:00:00 | 700000 | 0.6000000000000005 | 7.86 | 8.46
2001-01-19 00:00:00 | 703000 | 0.64 | 7.065 | 7.705
2001-01-22 00:00:00 | 976000 | 0.7049999999999992 | 7.575 | 8.28
2001-01-23 00:00:00 | 893000 | 1.345 | 7.065 | 8.41
2001-01-24 00:00:00 | 902000 | 0.6099999999999994 | 6.91 | 7.52
2001-01-26 00:00:00 | 744000 | 0.62 | 7.295 | 7.915
2001-01-29 00:00:00 | 665000 | 0.57 | 7.035 | 7.605
2001-01-30 00:00:00 | 726000 | 0.56 | 6.6 | 7.16
2001-01-31 00:00:00 | 567000 | 0.515 | 5.87 | 6.385
2001-02-01 00:00:00 | 585000 | 0.375 | 5.895 | 6.27
2001-02-02 00:00:00 | 732000 | 0.435 | 5.84 | 6.275
2001-02-05 00:00:00 | 822000 | 0.43 | 6.605 | 7.035
2001-02-06 00:00:00 | 614000 | 0.435 | 5.765 | 6.2
2001-02-07 00:00:00 | 618000 | 0.375 | 5.58 | 5.955
2001-02-08 00:00:00 | 588000 | 0.44 | 5.67 | 6.11
2001-02-09 00:00:00 | 468000 | 0.41 | 6.245 | 6.655
2001-02-12 00:00:00 | 927000 | 0.51 | 6.08 | 6.59
2001-02-13 00:00:00 | 656000 | 0.4750000000000005 | 5.63 | 6.105
2001-02-14 00:00:00 | 630000 | 0.455 | 5.61 | 6.065
2001-02-15 00:00:00 | 691000 | 0.5 | 5.875 | 6.375
2001-02-16 00:00:00 | 709000 | 0.4700000000000006 | 5.385 | 5.855
2001-02-20 00:00:00 | 592000 | 0.6400000000000006 | 5.47 | 6.11
2001-02-21 00:00:00 | 989000 | 0.495 | 5.205 | 5.7
2001-02-22 00:00:00 | 1029000 | 0.6899999999999995 | 5.2 | 5.89
2001-02-23 00:00:00 | 926000 | 0.5249999999999995 | 5.11 | 5.635
2001-02-26 00:00:00 | 693000 | 0.495 | 5.045 | 5.54
2001-02-27 00:00:00 | 694000 | 0.5 | 5.06 | 5.56
2001-02-28 00:00:00 | 918000 | 0.56 | 5.095 | 5.655
2001-03-01 00:00:00 | 960000 | 0.625 | 5.165 | 5.79
2001-03-02 00:00:00 | 797000 | 0.545 | 5.085 | 5.63
2001-03-05 00:00:00 | 949000 | 0.48 | 5.09 | 5.57
2001-03-06 00:00:00 | 974000 | 0.6199999999999992 | 5.315 | 5.935
2001-03-07 00:00:00 | 859000 | 0.56 | 5.26 | 5.82
2001-03-08 00:00:00 | 781000 | 0.5550000000000006 | 5.225 | 5.78
2001-03-09 00:00:00 | 710000 | 0.55 | 5.245 | 5.795
2001-03-12 00:00:00 | 545000 | 0.485 | 5.125 | 5.61
2001-03-13 00:00:00 | 508000 | 0.5 | 4.98 | 5.48
2001-03-14 00:00:00 | 525000 | 0.515 | 5.075 | 5.59
2001-03-15 00:00:00 | 477000 | 0.455 | 4.99 | 5.445
2001-03-16 00:00:00 | 529000 | 0.49 | 4.915 | 5.405
2001-03-19 00:00:00 | 519000 | 0.47 | 4.98 | 5.45
2001-03-20 00:00:00 | 559000 | 0.475 | 5.065 | 5.54
2001-03-21 00:00:00 | 542000 | 0.445 | 5.08 | 5.525
2001-03-22 00:00:00 | 616000 | 0.495 | 5.175 | 5.67
2001-03-23 00:00:00 | 534000 | 0.4499999999999993 | 5.025 | 5.475
2001-03-26 00:00:00 | 764000 | 0.565 | 5.21 | 5.775
2001-03-27 00:00:00 | 708000 | 0.58 | 5.205 | 5.785
2001-03-29 00:00:00 | 605000 | 0.595 | 5.59 | 6.185
2001-03-30 00:00:00 | 517000 | 0.59 | 5.33 | 5.92
2001-04-02 00:00:00 | 664000 | 0.5299999999999994 | 5.32 | 5.85
2001-04-03 00:00:00 | 738000 | 0.595 | 5.03 | 5.625
2001-04-04 00:00:00 | 666000 | 0.565 | 5.235 | 5.8
2001-04-05 00:00:00 | 572000 | 0.44 | 5.225 | 5.665
2001-04-06 00:00:00 | 547000 | 0.415 | 5.235 | 5.65
2001-04-09 00:00:00 | 441000 | 0.385 | 5.355 | 5.74
2001-04-10 00:00:00 | 474000 | 0.425 | 5.47 | 5.895
2001-04-12 00:00:00 | 502000 | 0.41 | 5.47 | 5.88
2001-04-16 00:00:00 | 563000 | 0.375 | 5.345 | 5.72
2001-04-17 00:00:00 | 622000 | 0.47 | 5.48 | 5.95
2001-04-18 00:00:00 | 668000 | 0.52 | 5.375 | 5.895
2001-04-19 00:00:00 | 566000 | 0.495 | 5.155 | 5.65
2001-04-20 00:00:00 | 332000 | 0.425 | 5.07 | 5.495
2001-04-23 00:00:00 | 318000 | 0.375 | 5.01 | 5.385
2001-04-24 00:00:00 | 393000 | 0.395 | 5.07 | 5.465
2001-04-25 00:00:00 | 414000 | 0.415 | 5.12 | 5.535
2001-04-26 00:00:00 | 444000 | 0.44 | 4.995 | 5.435
2001-04-27 00:00:00 | 428000 | 0.395 | 4.925 | 5.32
2001-04-30 00:00:00 | 351000 | 0.37 | 4.82 | 5.19
2001-05-01 00:00:00 | 435000 | 0.3999999999999995 | 4.73 | 5.13
2001-05-02 00:00:00 | 491000 | 0.3900000000000006 | 4.55 | 4.94
2001-05-03 00:00:00 | 427000 | 0.42 | 4.53 | 4.95
2001-05-04 00:00:00 | 407000 | 0.3999999999999995 | 4.445 | 4.845
2001-05-07 00:00:00 | 370000 | 0.335 | 4.485 | 4.82
2001-05-08 00:00:00 | 419000 | 0.3699999999999992 | 4.315 | 4.685
2001-05-09 00:00:00 | 455000 | 0.355 | 4.23 | 4.585
2001-05-10 00:00:00 | 498000 | 0.3450000000000006 | 4.145 | 4.49
2001-05-14 00:00:00 | 368000 | 0.345 | 4.25 | 4.595
2001-05-15 00:00:00 | 367000 | 0.34 | 4.275 | 4.615
2001-05-16 00:00:00 | 354000 | 0.38 | 4.455 | 4.835
2001-05-17 00:00:00 | 315000 | 0.36 | 4.47 | 4.83
2001-05-18 00:00:00 | 379000 | 0.37 | 4.18 | 4.55
2001-05-21 00:00:00 | 305000 | 0.335 | 4.15 | 4.485
2001-05-22 00:00:00 | 424000 | 0.35 | 4.15 | 4.5
2001-05-23 00:00:00 | 428000 | 0.35 | 4.035 | 4.385
2001-05-24 00:00:00 | 407000 | 0.34 | 4.095 | 4.435
2001-05-25 00:00:00 | 386000 | 0.33 | 4.125 | 4.455
2001-05-29 00:00:00 | 447000 | 0.34 | 3.84 | 4.18
2001-05-30 00:00:00 | 393000 | 0.315 | 3.86 | 4.175
2001-05-31 00:00:00 | 368000 | 0.32 | 3.67 | 3.99
2001-06-01 00:00:00 | 349000 | 0.295 | 3.73 | 4.025
2001-06-04 00:00:00 | 421000 | 0.315 | 3.705 | 4.02
2001-06-05 00:00:00 | 368000 | 0.305 | 3.945 | 4.25
2001-06-06 00:00:00 | 368000 | 0.31 | 3.985 | 4.295
2001-06-07 00:00:00 | 366000 | 0.29 | 3.75 | 4.04
2001-06-08 00:00:00 | 405000 | 0.29 | 3.68 | 3.97
2001-06-09 00:00:00 | 424000 | 0.28 | 3.625 | 3.905
2001-06-10 00:00:00 | 346000 | 0.28 | 3.625 | 3.905
2001-06-11 00:00:00 | 360000 | 0.28 | 3.625 | 3.905
2001-06-12 00:00:00 | 475000 | 0.34 | 3.86 | 4.2
2001-06-13 00:00:00 | 614000 | 0.455 | 3.995 | 4.45
2001-06-14 00:00:00 | 617000 | 0.395 | 4.135 | 4.53
2001-06-15 00:00:00 | 652000 | 0.39 | 3.94 | 4.33
2001-06-16 00:00:00 | 628000 | 0.345 | 3.87 | 4.215
2001-06-17 00:00:00 | 466000 | 0.345 | 3.87 | 4.215
2001-06-18 00:00:00 | 413000 | 0.345 | 3.87 | 4.215
2001-06-19 00:00:00 | 567000 | 0.415 | 3.895 | 4.31
2001-06-21 00:00:00 | 738000 | 0.515 | 3.685 | 4.2
2001-06-22 00:00:00 | 579000 | 0.345 | 3.685 | 4.03
2001-06-23 00:00:00 | 596000 | 0.315 | 3.685 | 4
2001-06-24 00:00:00 | 530000 | 0.315 | 3.685 | 4
2001-06-25 00:00:00 | 499000 | 0.445 | 3.555 | 4
2001-06-26 00:00:00 | 791000 | 0.535 | 3.445 | 3.98
2001-06-27 00:00:00 | 791000 | 0.565 | 3.385 | 3.95
2001-06-28 00:00:00 | 813000 | 0.645 | 3.215 | 3.86
2001-06-29 00:00:00 | 814000 | 0.355 | 3.215 | 3.57
2001-06-30 00:00:00 | 724000 | 0.575 | 2.995 | 3.57
2001-07-01 00:00:00 | 690000 | 0.28 | 2.995 | 3.275
2001-07-02 00:00:00 | 611000 | 0.345 | 2.93 | 3.275
2001-07-03 00:00:00 | 480000 | 0.18 | 3 | 3.18
2001-07-04 00:00:00 | 356000 | 0.2 | 3 | 3.2
2001-07-05 00:00:00 | 515000 | 0.1 | 3.1 | 3.2
2001-07-06 00:00:00 | 409000 | 0.38 | 2.995 | 3.375
2001-07-07 00:00:00 | 405000 | 0.25 | 2.995 | 3.245
2001-07-08 00:00:00 | 367000 | 0.145 | 3.1 | 3.245
2001-07-10 00:00:00 | 573000 | 0.19 | 3.205 | 3.395
2001-07-11 00:00:00 | 619000 | 0.17 | 3.3 | 3.47
2001-07-12 00:00:00 | 550000 | 0.365 | 3.155 | 3.52
2001-07-13 00:00:00 | 458000 | 0.425 | 3.155 | 3.58
2001-07-14 00:00:00 | 345000 | 0.26 | 3.155 | 3.415
2001-07-15 00:00:00 | 319000 | 0.34 | 3.075 | 3.415
2001-07-16 00:00:00 | 319000 | 0.295 | 3.12 | 3.415
2001-07-17 00:00:00 | 556000 | 0.22 | 3.145 | 3.365
2001-07-18 00:00:00 | 595000 | 0.36 | 3.025 | 3.385
2001-07-19 00:00:00 | 529000 | 0.495 | 2.95 | 3.445
2001-07-20 00:00:00 | 522000 | 0.375 | 2.95 | 3.325
2001-07-21 00:00:00 | 477000 | 0.275 | 2.95 | 3.225
2001-07-22 00:00:00 | 431000 | 0.215 | 3.01 | 3.225
2001-07-23 00:00:00 | 504000 | 0.215 | 3.01 | 3.225
2001-07-24 00:00:00 | 673000 | 0.3 | 3.06 | 3.36
2001-07-25 00:00:00 | 739000 | 0.11 | 3.265 | 3.375
2001-07-26 00:00:00 | 798000 | 0.315 | 3.065 | 3.38
2001-07-27 00:00:00 | 642000 | 0.47 | 3.065 | 3.535
2001-07-28 00:00:00 | 463000 | 0.265 | 3.065 | 3.33
2001-07-29 00:00:00 | 331000 | 0.06000000000000005 | 3.27 | 3.33
2001-07-30 00:00:00 | 329000 | 0.01000000000000023 | 3.32 | 3.33
2001-07-31 00:00:00 | 465000 | 0.275 | 3.26 | 3.535
2001-08-01 00:00:00 | 434000 | 0.46 | 3.15 | 3.61
2001-08-02 00:00:00 | 571000 | 0.515 | 3.055 | 3.57
2001-08-03 00:00:00 | 681000 | 0.415 | 3.055 | 3.47
2001-08-04 00:00:00 | 693000 | 0.275 | 3.055 | 3.33
2001-08-05 00:00:00 | 426000 | 0.275 | 3.055 | 3.33
2001-08-06 00:00:00 | 482000 | 0.195 | 3.135 | 3.33
2001-08-07 00:00:00 | 687000 | 0.385 | 3.09 | 3.475
2001-08-08 00:00:00 | 856000 | 0.5 | 3.09 | 3.59
2001-08-09 00:00:00 | 964000 | 0.545 | 2.98 | 3.525
2001-08-10 00:00:00 | 901000 | 0.49 | 2.98 | 3.47
2001-08-11 00:00:00 | 863000 | 0.25 | 2.98 | 3.23
2001-08-12 00:00:00 | 433000 | 0.235 | 2.995 | 3.23
2001-08-13 00:00:00 | 409000 | 0.2 | 3.03 | 3.23
2001-08-14 00:00:00 | 643000 | 0.125 | 3.145 | 3.27
2001-08-15 00:00:00 | 579000 | -0.145 | 3.44 | 3.295
2001-08-16 00:00:00 | 634000 | 0.195 | 3.23 | 3.425
2001-08-17 00:00:00 | 666000 | 0.515 | 3.23 | 3.745
2001-08-18 00:00:00 | 549000 | 0.245 | 3.23 | 3.475
2001-08-19 00:00:00 | 434000 | 0.315 | 3.16 | 3.475
2001-08-20 00:00:00 | 518000 | 0.31 | 3.165 | 3.475
2001-08-21 00:00:00 | 640000 | 0.25 | 3.19 | 3.44
2001-08-22 00:00:00 | 657000 | 0.615 | 2.86 | 3.475
2001-08-23 00:00:00 | 516000 | 0.72 | 2.77 | 3.49
2001-08-24 00:00:00 | 541000 | 0.37 | 2.77 | 3.14
2001-08-25 00:00:00 | 433000 | 0.235 | 2.77 | 3.005
2001-08-26 00:00:00 | 441000 | 0.415 | 2.59 | 3.005
2001-08-27 00:00:00 | 576000 | 0.45 | 2.555 | 3.005
2001-08-28 00:00:00 | 695000 | 0.435 | 2.445 | 2.88
2001-08-29 00:00:00 | 627000 | 0.355 | 2.46 | 2.815
2001-08-30 00:00:00 | 650000 | 0.575 | 2.15 | 2.725
2001-08-31 00:00:00 | 394000 | 0.565 | 2.15 | 2.715
2001-09-01 00:00:00 | 388000 | 0.18 | 2.15 | 2.33
2001-09-02 00:00:00 | 359000 | 0.18 | 2.15 | 2.33
2001-09-03 00:00:00 | 433000 | 0.13 | 2.2 | 2.33
2001-09-04 00:00:00 | 591000 | -0.004999999999999893 | 2.335 | 2.33
2001-09-05 00:00:00 | 667000 | 0.05500000000000016 | 2.4 | 2.455