Spreadsheet: 218899d1362602410-selecting-an-entire-date-range-to-be-looked-up-based-on-start-and-end-dates-tester
Sheet: TesterCase

Date | Avg DC | B/C |  | Tmax | Tmean | Tmin | kW | Actual Peak DM | Actual [NAME] | Peak Baseline | Recent DM | Recent Baseline
2012-08-02 00:00:00 | 100 |  |  | 93 | 85 | 77 | 183.361
2012-08-03 00:00:00 | 100 |  |  | 91 | 84 | 76 | 189.148
2012-08-04 00:00:00 | 100 |  |  | 90 | 84 | 77 | 182.308
2012-08-05 00:00:00 | 100 |  |  | 91 | 85 | 79 | 187.474
2012-08-06 00:00:00 | 100 |  |  | 91 | 84 | 76 | 173.17
2012-08-07 00:00:00 | 100 |  |  | 90 | 84 | 78 | 185.173
2012-08-08 00:00:00 | 100 |  |  | 88 | 83 | 78 | 170.892
2012-08-09 00:00:00 | 100 |  |  | 90 | 84 | 77 | 181.807
2012-08-10 00:00:00 | 100 |  |  | 92 | 85 | 78 | 196.185
2012-08-11 00:00:00 | 100 |  |  | 93 | 86 | 79 | 193.101
2012-08-12 00:00:00 | 100 |  |  | 92 | 85 | 77 | 179.284
2012-08-13 00:00:00 | 100 |  |  | 92 | 85 | 78 | 186.433
2012-08-14 00:00:00 | 100 |  |  | 91 | 85 | 78 | 173.439
2012-08-15 00:00:00 | 100 |  |  | 89 | 83 | 76 | 178.263
2012-08-16 00:00:00 | 100 |  |  | 91 | 84 | 76 | 189.502
2012-08-17 00:00:00 | 100 |  |  | 91 | 85 | 78 | 182.544
2012-08-18 00:00:00 | 100 |  |  | 92 | 86 | 80 | 192.777
2012-08-19 00:00:00 | 100 |  |  | 92 | 86 | 80 | 182.771
2012-08-20 00:00:00 | 100 |  |  | 92 | 84 | 76 | 182.356
2012-08-21 00:00:00 | 100 |  |  | 90 | 83 | 76 | 159.411
2012-08-22 00:00:00 | 100 |  |  | 90 | 85 | 79 | 180.157
2012-08-23 00:00:00 | 75 |  |  | 85 | 80 | 75 | 171.956
2012-08-24 00:00:00 | 100 |  |  | 87 | 80 | 72 | 162.088
2012-08-25 00:00:00 | 75 |  |  | 86 | 82 | 77 | 162.418
2012-08-26 00:00:00 | 100 |  |  | 86 | 81 | 76 | 161.195
2012-08-27 00:00:00 | 75 |  |  | 83 | 79 | 75 | 163.291
2012-08-28 00:00:00 | 100 |  |  | 89 | 83 | 77 | 171.384
2012-08-29 00:00:00 | 76 |  |  | 88 | 83 | 77 | 172.885
2012-08-30 00:00:00 | 75 |  |  | 88 | 82 | 75 | 171.331
2012-08-31 00:00:00 | 75 |  |  | 89 | 82 | 75 | 168.214
2012-09-01 00:00:00 | 100 |  |  | 89 | 81 | 73 | 188.359
2012-09-02 00:00:00 | 75 |  |  | 89 | 82 | 74 | 183.047
2012-09-03 00:00:00 | 100 |  |  | 87 | 82 | 76 | 175.505
2012-09-04 00:00:00 | 75 |  |  | 88 | 82 | 75 | 178.145 |  |  |  |  |  |  |  |  |  | Highest DM peak(kw) |  |  |  |  |  |  |  |  |  | Beginning date: | 2012-09-01 00:00:00
2012-09-05 00:00:00 | 100 |  |  | 88 | 82 | 75 | 182.54 |  |  |  |  |  |  |  |  |  | High Temperature of the day (F) |  |  |  |  |  |  |  |  |  | Ending Date: | 2012-09-30 00:00:00
2012-09-06 00:00:00 | 75 |  |  | 88 | 81 | 74 | 172.058 |  |  |  |  |  |  |  | Slope | Intercept | High Temperature of the day (F) | Theoretical Peak Baseline | Actual Peak DM | Reduction | Percentage
2012-09-07 00:00:00 | 100 |  |  | 89 | 82 | 74 | 187.818
2012-09-08 00:00:00 | 75 |  |  | 88 | 82 | 75 | 185.174 |  |  |  |  |  |  |  |  |  | Date of Peak
2012-09-09 00:00:00 | 100 |  |  | 89 | 82 | 75 | 186.263 |  |  |  |  |  |  |  |  |  | Days on C
2012-09-10 00:00:00 | 75 |  |  | 91 | 83 | 75 | 177.45 |  |  |  |  |  |  |  |  |  | Days on B
2012-09-11 00:00:00 | 100 |  |  | 90 | 83 | 76 | 181.949
2012-09-12 00:00:00 | 75 |  |  | 90 | 83 | 75 | 174.873
2012-09-13 00:00:00 | 100 |  |  | 90 | 84 | 77 | 181.417
2012-09-14 00:00:00 | 75 |  |  | 90 | 83 | 76 | 174.284
2012-09-15 00:00:00 | 100 |  |  | 89 | 83 | 77 | 186.589
2012-09-16 00:00:00 | 75 |  |  | 92 | 84 | 75 | 171.138
2012-09-17 00:00:00 | 100 |  |  | 91 | 84 | 77 | 180.871
2012-09-18 00:00:00 | 75 |  |  | 84 | 80 | 75 | 159.067
2012-09-19 00:00:00 | 61 |  |  | 89 | 84 | 78 | 162.225
2012-09-20 00:00:00 | 100 |  |  | 86 | 82 | 77 | 164.739
2012-09-21 00:00:00 | 61 |  |  | 88 | 81 | 74 | 169.372
2012-09-22 00:00:00 | 61 |  |  | 89 | 83 | 76 | 177.624
2012-09-23 00:00:00 | 61 |  |  | 90 | 84 | 77 | 172.25
2012-09-24 00:00:00 | 61 |  |  | 88 | 81 | 74 | 168.855
2012-09-25 00:00:00 | 61 |  |  | 88 | 82 | 76 | 169.428
2012-09-26 00:00:00 | 61 |  |  | 87 | 82 | 76 | 165.303
2012-09-27 00:00:00 | 61 |  |  | 87 | 81 | 75 | 164.537
2012-09-28 00:00:00 | 61 |  |  | 87 | 81 | 74 | 166.58
2012-09-29 00:00:00 | 61 |  |  | 88 | 82 | 76 | 179.26
2012-09-30 00:00:00 | 61 |  |  | 88 | 83 | 78 | 172.635
2012-10-01 00:00:00 | 61 |  |  | 88 | 82 | 76 | 172.744
2012-10-02 00:00:00 | 61 |  |  | 89 | 83 | 76 | 166.887
2012-10-03 00:00:00 | 61 |  |  | 89 | 84 | 78 | 170.955
2012-10-04 00:00:00 | 68 |  |  | 87 | 83 | 79 | 175.509
2012-10-05 00:00:00 | 68 |  |  | 89 | 82 | 74 | 170.538
2012-10-06 00:00:00 | 68 |  |  | 86 | 80 | 73 | 171.398
2012-10-07 00:00:00 | 68 |  |  | 88 | 81 | 74 | 174.834
2012-10-08 00:00:00 | 68 |  |  | 88 | 83 | 77 | 174.856
2012-10-09 00:00:00 | 68 |  |  | 89 | 83 | 76 | 172.101
2012-10-10 00:00:00 | 68 |  |  | 89 | 83 | 77 | 171.496
2012-10-11 00:00:00 | 68 |  |  | 89 | 84 | 78 | 173.337
2012-10-12 00:00:00 | 68 |  |  | 89 | 83 | 76 | 177.396
2012-10-13 00:00:00 | 80 |  |  | 86 | 82 | 77 | 175.261
2012-10-14 00:00:00 | 80 |  |  | 88 | 83 | 77 | 177.181
2012-10-15 00:00:00 | 80 |  |  | 88 | 84 | 80 | 179.088
2012-10-16 00:00:00 | 80 |  |  | 88 | 82 | 75 | 176.277
2012-10-17 00:00:00 | 80 |  |  | 88 | 83 | 77 | 173.747
2012-10-18 00:00:00 | 79 |  |  | 89 | 83 | 77 | 170.597
2012-10-19 00:00:00 | 80 |  |  | 85 | 80 | 74 | 154.186
2012-10-20 00:00:00 | 80 |  |  | 89 | 83 | 76 | 179.62
2012-10-21 00:00:00 | 80 |  |  | 89 | 83 | 76 | 179.669
2012-10-22 00:00:00 | 80 |  |  | 88 | 82 | 75 | 171.407
2012-10-23 00:00:00 | 79 |  |  | 89 | 82 | 75 | 173.927
2012-10-24 00:00:00 | 80 |  |  | 89 | 84 | 78 | 169.614
2012-10-25 00:00:00 | 80 |  |  | 85 | 81 | 76 | 170.08
2012-10-26 00:00:00 | 79 |  |  | 85 | 82 | 77 | 168.586
2012-10-27 00:00:00 | 79 |  |  | 86 | 82 | 77 | 187.118
2012-10-28 00:00:00 | 80 |  |  | 86 | 82 | 77 | 183.936
2012-10-29 00:00:00 | 79 |  |  | 84 | 79 | 77 | 176.917
2012-10-30 00:00:00 | 79 |  |  | 83 | 77 | 77 | 185.4
2012-10-31 00:00:00 | 79 |  |  | 83 | 75 | 75 | 186.432
2012-11-01 00:00:00 | 80 |  |  | 90 | 83 | 76 | 181.311
2012-11-02 00:00:00 | 80 |  |  | 89 | 82 | 74 | 183.896
2012-11-03 00:00:00 | 80 |  |  | 89 | 82 | 75 | 178.459
2012-11-04 00:00:00 | 80 |  |  | 90 | 82 | 73 | 181.016
2012-11-05 00:00:00 | 80 |  |  | 88 | 81 | 74 | 179.242
2012-11-06 00:00:00 | 80 |  |  | 89 | 83 | 76 | 187.277
2012-11-07 00:00:00 | 80 |  |  | 88 | 82 | 75 | 196.172
2012-11-08 00:00:00 | 100 |  |  | 89 | 82 | 75 | 191.207
2012-11-09 00:00:00 | 100 |  |  | 89 | 82 | 75 | 185.173
2012-11-10 00:00:00 | 100 |  |  | 90 | 82 | 74 | 190.24
2012-11-11 00:00:00 | 100 |  |  | 89 | 82 | 74 | 185.669
2012-11-12 00:00:00 | 100 |  |  | 87 | 81 | 75 | 168.081
2012-11-13 00:00:00 | 100 |  |  | 87 | 81 | 75 | 181.429
2012-11-14 00:00:00 | 100 |  |  | 89 | 83 | 76 | 180.037
2012-11-15 00:00:00 | 100 |  |  | 89 | 83 | 76 | 186.638
2012-11-16 00:00:00 | 100 |  |  | 88 | 81 | 73 | 189.426
2012-11-17 00:00:00 | 68 |  |  | 88 | 82 | 75 | 185.134
2012-11-18 00:00:00 | 68 |  |  | 88 | 82 | 76 | 184.721
2012-11-19 00:00:00 | 68 |  |  | 88 | 82 | 75 | 178.897
2012-11-20 00:00:00 | 68 |  |  | 87 | 81 | 75 | 177.366
2012-11-21 00:00:00 | 68 |  |  | 84 | 81 | 77 | 177.737
2012-11-22 00:00:00 | 68 |  |  | 86 | 81 | 76 | 185.052
2012-11-23 00:00:00 | 68 |  |  | 86 | 80 | 74 | 186.189
2012-11-24 00:00:00 | 68 |  |  | 86 | 81 | 75 | 184.991
2012-11-25 00:00:00 | 68 |  |  | 88 | 82 | 75 | 183.541
2012-11-26 00:00:00 | 68 |  |  | 87 | 82 | 76 | 181.34
2012-11-27 00:00:00 | 68 |  |  | 88 | 81 | 73 | 185.651
2012-11-28 00:00:00 | 68 |  |  | 88 | 82 | 75 | 177.565
2012-11-29 00:00:00 | 68 |  |  | 87 | 79 | 71 | 173.291
2012-11-30 00:00:00 | 68 |  |  | 86 | 77 | 68 | 161.036
2012-12-01 00:00:00 | 68 |  |  | 86 | 80 | 74 | 167.111
2012-12-02 00:00:00 | 68 |  |  | 83 | 78 | 72 | 168.334
2012-12-03 00:00:00 | 68 |  |  | 84 | 79 | 73 | 164.724
2012-12-04 00:00:00 | 68 |  |  | 85 | 79 | 73 | 169.907
2012-12-05 00:00:00 | 68 |  |  | 87 | 82 | 76 | 168.925
2012-12-06 00:00:00 | 68 |  |  | 86 | 81 | 76 | 169.551
2012-12-07 00:00:00 | 68 |  |  | 86 | 81 | 75 | 159.832
2012-12-08 00:00:00 | 65 |  |  | 88 | 83 | 77 | 170.478
2012-12-09 00:00:00 | 65 |  |  | 88 | 81 | 74 | 170.751
2012-12-10 00:00:00 | 65 |  |  | 86 | 81 | 76 | 161.955
2012-12-11 00:00:00 | 65 |  |  | 84 | 80 | 75 | 158.803
2012-12-12 00:00:00 | 65 |  |  | 88 | 82 | 76 | 171.796
2012-12-13 00:00:00 | 66 |  |  | 85 | 80 | 74 | 167.822
2012-12-14 00:00:00 | 65 |  |  | 86 | 78 | 70 | 175.208
2012-12-15 00:00:00 | 65 |  |  | 85 | 75 | 65 | 153.561
2012-12-16 00:00:00 | 66 |  |  | 86 | 77 | 67 | 156.552
2012-12-17 00:00:00 | 65 |  |  | 86 | 78 | 69 | 160.914
2012-12-18 00:00:00 | 66 |  |  | 80 | 76 | 72 | 152.018
2012-12-19 00:00:00 | 66 |  |  | 85 | 78 | 70 | 181.616
2012-12-20 00:00:00 | 65 |  |  | 86 | 77 | 68 | 173.689
2012-12-21 00:00:00 | 66 |  |  | 85 | 78 | 71 | 160.702
2012-12-22 00:00:00 | 66 |  |  | 83 | 78 | 72 | 170.713
2012-12-23 00:00:00 | 66 |  |  | 83 | 77 | 71 | 154.892
2012-12-24 00:00:00 | 66 |  |  | 86 | 81 | 75 | 172.891
2012-12-25 00:00:00 | 67 |  |  | 86 | 79 | 72 | 37.657
2012-12-26 00:00:00 | 66 |  |  | 86 | 79 | 71 | 167.804
2012-12-27 00:00:00 | 66 |  |  | 86 | 80 | 74 | 173.15
2012-12-28 00:00:00 | 65 |  |  | 86 | 80 | 74 | 167.852
2012-12-29 00:00:00 | 65 |  |  | 85 | 79 | 72 | 161.736
2012-12-30 00:00:00 | 66 |  |  | 85 | 78 | 70 | 166.44
2012-12-31 00:00:00 | 65 |  |  | 84 | 77 | 70 | 157.799
2013-01-01 00:00:00 | 65 |  |  | 85 | 79 | 73 | 57.903
2013-01-02 00:00:00 | 66 |  |  | 84 | 78 | 71 | 159.875
2013-01-03 00:00:00 | 68 |  |  | 84 | 78 | 72 | 167.96
2013-01-04 00:00:00 | 68 |  |  | 86 | 80 | 73 | 182.52
2013-01-05 00:00:00 | 67 |  |  | 83 | 79 | 74 | 171.895
2013-01-06 00:00:00 | 67 |  |  | 87 | 81 | 75 | 163.737
2013-01-07 00:00:00 | 67 |  |  | 86 | 80 | 73 | 178.146
2013-01-08 00:00:00 | 67 |  |  | 85 | 79 | 73 | 166.595
2013-01-09 00:00:00 | 67 |  |  | 84 | 79 | 74 | 162.836
2013-01-10 00:00:00 | 67 |  |  | 82 | 76 | 70 | 164.901
2013-01-11 00:00:00 | 67 |  |  | 83 | 77 | 70 | 160.309
2013-01-12 00:00:00 | 67 |  |  | 83 | 77 | 71 | 162.106
2013-01-13 00:00:00 | 67 |  |  | 82 | 76 | 69 | 159.826
2013-01-14 00:00:00 | 67 |  |  | 81 | 73 | 64 | 152.081
2013-01-15 00:00:00 | 66 |  |  | 83 | 76 | 68 | 152.779
2013-01-16 00:00:00 | 67 |  |  | 84 | 74 | 63 | 151.085
2013-01-17 00:00:00 | 67 |  |  | 85 | 78 | 71 | 167.688
2013-01-18 00:00:00 | 67 |  |  | 84 | 79 | 73 | 168.573
2013-01-19 00:00:00 | 67 |  |  | 83 | 77 | 71 | 164.076
2013-01-20 00:00:00 | 67 |  |  | 84 | 78 | 71 | 164.566
2013-01-21 00:00:00 | 67 |  |  | 83 | 75 | 67 | 181.219
2013-01-22 00:00:00 | 67 |  |  | 84 | 77 | 70 | 181.737
2013-01-23 00:00:00 | 67 |  |  | 84 | 79 | 74 | 180.254
2013-01-24 00:00:00 | 67 |  |  | 84 | 77 | 70 | 172.623
2013-01-25 00:00:00 | 67 |  |  | 85 | 79 | 73 | 171.684
2013-01-26 00:00:00 | 67 |  |  | 85 | 80 | 74 | 175.721
2013-01-27 00:00:00 | 67 |  |  | 85 | 79 | 72 | 175.811
2013-01-28 00:00:00 | 66 |  |  | 84 | 78 | 72 | 163.587
2013-01-29 00:00:00 | 67 |  |  | 84 | 78 | 72 | 151.945
2013-01-30 00:00:00 | 65 |  |  | 83 | 77 | 71 | 159.15
2013-01-31 00:00:00 | 67 |  |  | 84 | 78 | 71 | 166.146
2013-02-01 00:00:00 | 67 |  |  | 82 | 76 | 69 | 155.348
2013-02-02 00:00:00 | 67 |  |  | 83 | 74 | 65 | 158.511
2013-02-03 00:00:00 | 67 |  |  | 83 | 76 | 68 | 160.281
2013-02-04 00:00:00 | 67 |  |  | 84 | 75 | 65 | 151.028
2013-02-05 00:00:00 | 67 |  |  | 83 | 75 | 67 | 161.76
2013-02-06 00:00:00 | 70 |  |  | 85 | 78 | 70 | 166.801
2013-02-07 00:00:00 | 70 |  |  | 85 | 76 | 67 | 171.786
2013-02-08 00:00:00 | 68 |  |  | 84 | 78 | 71 | 185.286
2013-02-09 00:00:00 | 68 |  |  | 84 | 78 | 71 | 179.872
2013-02-10 00:00:00 | 68 |  |  | 85 | 77 | 68 | 163.465
2013-02-11 00:00:00 | 68 |  |  | 85 | 79 | 73 | 171.697
2013-02-12 00:00:00 | 68 |  |  | 83 | 77 | 70 | 158.851
2013-02-13 00:00:00 | 68 |  |  | 84 | 78 | 72 | 156.985
2013-02-14 00:00:00 | 68 |  |  | 84 | 78 | 72 | 176.814
2013-02-15 00:00:00 | 68 |  |  | 85 | 79 | 72 | 173.947
2013-02-16 00:00:00 | 68 |  |  | 84 | 78 | 72 | 170.044
2013-02-17 00:00:00 | 68 |  |  | 84 | 78 | 71 | 159.82
2013-02-18 00:00:00 | 67 |  |  | 85 | 80 | 74 | 161.996
2013-02-19 00:00:00 | 67 |  |  | 86 | 80 | 73 | 159.059
2013-02-20 00:00:00 | 66 |  |  | 85 | 79 | 73 | 182.113
2013-02-21 00:00:00 | 68 |  |  | 85 | 79 | 73 | 167.073
2013-02-22 00:00:00 | 75 |  |  | 84 | 77 | 69 | 165.594
2013-02-23 00:00:00 | 66 |  |  | 84 | 79 | 73 | 169.76
2013-02-24 00:00:00 | 68 |  |  | 85 | 78 | 71 | 173.317
2013-02-25 00:00:00 | 68 |  |  | 84 | 77 | 70 | 160.936
2013-02-26 00:00:00 | 68 |  |  | 85 | 79 | 72 | 166.756
2013-02-27 00:00:00 | 68 |  |  | 85 | 79 | 73 | 170.779
2013-02-28 00:00:00 | 68 |  |  | 83 | 77 | 70 | 165.661