Spreadsheet: 330214d1404625329-negative-return-on-slope-intercept-when-trending-downwards-pivot-chart-with-trend-line
Sheet: Data

Site | Date | Vol | Projection
Site A | 2014-04-01 00:00:00 | 25
Site A | 2014-04-02 00:00:00 | 20
Site A | 2014-04-03 00:00:00 | 38
Site A | 2014-04-04 00:00:00 | 28 |  |  | Site | Site B
Site A | 2014-04-07 00:00:00 | 41
Site A | 2014-04-08 00:00:00 | 29 |  |  | Row Labels | Sum of Vol
Site A | 2014-04-09 00:00:00 | 23 |  |  | 2014-04-01 00:00:00 | 18
Site A | 2014-04-10 00:00:00 | 20 |  |  | 2014-04-02 00:00:00 | 32
Site A | 2014-04-11 00:00:00 | 26 |  |  | 2014-04-03 00:00:00 | 31
Site A | 2014-04-14 00:00:00 | 24 |  |  | 2014-04-04 00:00:00 | 26
Site A | 2014-04-15 00:00:00 | 30 |  |  | 2014-04-07 00:00:00 | 50
Site A | 2014-04-16 00:00:00 | 16 |  |  | 2014-04-08 00:00:00 | 36
Site A | 2014-04-17 00:00:00 | 39 |  |  | 2014-04-09 00:00:00 | 27
Site A | 2014-04-22 00:00:00 | 20 |  |  | 2014-04-10 00:00:00 | 30
Site A | 2014-04-23 00:00:00 | 18 |  |  | 2014-04-11 00:00:00 | 36
Site A | 2014-04-24 00:00:00 | 16 |  |  | 2014-04-14 00:00:00 | 35
Site A | 2014-04-28 00:00:00 | 67 |  |  | 2014-04-15 00:00:00 | 36
Site A | 2014-04-29 00:00:00 | 23 |  |  | 2014-04-16 00:00:00 | 36
Site A | 2014-04-30 00:00:00 | 25 |  |  | 2014-04-17 00:00:00 | 18
Site A | 2014-05-01 00:00:00 | 24 |  |  | 2014-04-22 00:00:00 | 44
Site A | 2014-05-02 00:00:00 | 28 |  |  | 2014-04-23 00:00:00 | 20
Site A | 2014-05-05 00:00:00 | 43 |  |  | 2014-04-24 00:00:00 | 41
Site A | 2014-05-06 00:00:00 | 41 |  |  | 2014-04-28 00:00:00 | 41
Site A | 2014-05-07 00:00:00 | 21 |  |  | 2014-04-29 00:00:00 | 37
Site A | 2014-05-08 00:00:00 | 23 |  |  | 2014-04-30 00:00:00 | 29
Site A | 2014-05-09 00:00:00 | 25 |  |  | 2014-05-01 00:00:00 | 33
Site A | 2014-05-12 00:00:00 | 54 |  |  | 2014-05-02 00:00:00 | 32
Site A | 2014-05-13 00:00:00 | 28 |  |  | 2014-05-05 00:00:00 | 43
Site A | 2014-05-14 00:00:00 | 19 |  |  | 2014-05-06 00:00:00 | 30
Site A | 2014-05-15 00:00:00 | 29 |  |  | 2014-05-07 00:00:00 | 35
Site A | 2014-05-16 00:00:00 | 36 |  |  | 2014-05-08 00:00:00 | 15
Site A | 2014-05-19 00:00:00 | 41 |  |  | 2014-05-09 00:00:00 | 16
Site A | 2014-05-20 00:00:00 | 35 |  |  | 2014-05-12 00:00:00 | 37
Site A | 2014-05-21 00:00:00 | 21 |  |  | 2014-05-13 00:00:00 | 18
Site A | 2014-05-22 00:00:00 | 42 |  |  | 2014-05-14 00:00:00 | 26
Site A | 2014-05-23 00:00:00 | 26 |  |  | 2014-05-15 00:00:00 | 24
Site A | 2014-05-26 00:00:00 | 44 |  |  | 2014-05-16 00:00:00 | 21
Site A | 2014-05-27 00:00:00 | 27 |  |  | 2014-05-19 00:00:00 | 51
Site A | 2014-05-28 00:00:00 | 31 |  |  | 2014-05-20 00:00:00 | 31
Site A | 2014-05-29 00:00:00 | 38 |  |  | 2014-05-21 00:00:00 | 30
Site A | 2014-05-30 00:00:00 | 31 |  |  | 2014-05-22 00:00:00 | 28
Site A | 2014-06-02 00:00:00 | 63 |  |  | 2014-05-23 00:00:00 | 21
Site A | 2014-06-03 00:00:00 | 36 |  |  | 2014-05-26 00:00:00 | 50
Site A | 2014-06-05 00:00:00 | 23 |  |  | 2014-05-27 00:00:00 | 28
Site A | 2014-06-06 00:00:00 | 22 |  |  | 2014-05-28 00:00:00 | 29
Site A | 2014-06-10 00:00:00 | 36 |  |  | 2014-05-29 00:00:00 | 24
Site A | 2014-06-11 00:00:00 | 42 |  |  | 2014-05-30 00:00:00 | 28
Site A | 2014-06-12 00:00:00 | 26 |  |  | 2014-06-02 00:00:00 | 45
Site A | 2014-06-13 00:00:00 | 25 |  |  | 2014-06-03 00:00:00 | 29
Site A | 2014-06-16 00:00:00 | 34 |  |  | 2014-06-04 00:00:00 | 31
Site A | 2014-06-17 00:00:00 | 29 |  |  | 2014-06-05 00:00:00 | 30
Site A | 2014-06-18 00:00:00 | 16 |  |  | 2014-06-06 00:00:00 | 22
Site A | 2014-06-19 00:00:00 | 24 |  |  | 2014-06-10 00:00:00 | 32
Site A | 2014-06-20 00:00:00 | 27 |  |  | 2014-06-11 00:00:00 | 35
Site A | 2014-06-23 00:00:00 | 47 |  |  | 2014-06-12 00:00:00 | 18
Site A | 2014-06-24 00:00:00 | 28 |  |  | 2014-06-13 00:00:00 | 35
Site A | 2014-06-25 00:00:00 | 20 |  |  | 2014-06-16 00:00:00 | 42
Site A | 2014-06-26 00:00:00 | 18 |  |  | 2014-06-17 00:00:00 | 19
Site A | 2014-06-27 00:00:00 | 28 |  |  | 2014-06-18 00:00:00 | 25
Site A | 2014-06-30 00:00:00 | 55 |  |  | 2014-06-19 00:00:00 | 25
Site B | 2014-04-01 00:00:00 | 18 |  |  | 2014-06-20 00:00:00 | 27
Site B | 2014-04-02 00:00:00 | 32 |  |  | 2014-06-23 00:00:00 | 40
Site B | 2014-04-03 00:00:00 | 31 |  |  | 2014-06-24 00:00:00 | 18
Site B | 2014-04-04 00:00:00 | 26 |  |  | 2014-06-25 00:00:00 | 29
Site B | 2014-04-07 00:00:00 | 50 |  |  | 2014-06-26 00:00:00 | 29
Site B | 2014-04-08 00:00:00 | 36 |  |  | 2014-06-27 00:00:00 | 25
Site B | 2014-04-09 00:00:00 | 27 |  |  | 2014-06-30 00:00:00 | 41
Site B | 2014-04-10 00:00:00 | 30 |  |  | Grand Total | 1870
Site B | 2014-04-11 00:00:00 | 36
Site B | 2014-04-14 00:00:00 | 35
Site B | 2014-04-15 00:00:00 | 36
Site B | 2014-04-16 00:00:00 | 36
Site B | 2014-04-17 00:00:00 | 18
Site B | 2014-04-22 00:00:00 | 44
Site B | 2014-04-23 00:00:00 | 20
Site B | 2014-04-24 00:00:00 | 41
Site B | 2014-04-28 00:00:00 | 41
Site B | 2014-04-29 00:00:00 | 37
Site B | 2014-04-30 00:00:00 | 29
Site B | 2014-05-01 00:00:00 | 33
Site B | 2014-05-02 00:00:00 | 32
Site B | 2014-05-05 00:00:00 | 43
Site B | 2014-05-06 00:00:00 | 30
Site B | 2014-05-07 00:00:00 | 35
Site B | 2014-05-08 00:00:00 | 15
Site B | 2014-05-09 00:00:00 | 16
Site B | 2014-05-12 00:00:00 | 37
Site B | 2014-05-13 00:00:00 | 18
Site B | 2014-05-14 00:00:00 | 26
Site B | 2014-05-15 00:00:00 | 24
Site B | 2014-05-16 00:00:00 | 21
Site B | 2014-05-19 00:00:00 | 51
Site B | 2014-05-20 00:00:00 | 31
Site B | 2014-05-21 00:00:00 | 30
Site B | 2014-05-22 00:00:00 | 28
Site B | 2014-05-23 00:00:00 | 21
Site B | 2014-05-26 00:00:00 | 50
Site B | 2014-05-27 00:00:00 | 28
Site B | 2014-05-28 00:00:00 | 29
Site B | 2014-05-29 00:00:00 | 24
Site B | 2014-05-30 00:00:00 | 28
Site B | 2014-06-02 00:00:00 | 45
Site B | 2014-06-03 00:00:00 | 29
Site B | 2014-06-04 00:00:00 | 31
Site B | 2014-06-05 00:00:00 | 30
Site B | 2014-06-06 00:00:00 | 22
Site B | 2014-06-10 00:00:00 | 32
Site B | 2014-06-11 00:00:00 | 35
Site B | 2014-06-12 00:00:00 | 18
Site B | 2014-06-13 00:00:00 | 35
Site B | 2014-06-16 00:00:00 | 42
Site B | 2014-06-17 00:00:00 | 19
Site B | 2014-06-18 00:00:00 | 25
Site B | 2014-06-19 00:00:00 | 25
Site B | 2014-06-20 00:00:00 | 27
Site B | 2014-06-23 00:00:00 | 40
Site B | 2014-06-24 00:00:00 | 18
Site B | 2014-06-25 00:00:00 | 29
Site B | 2014-06-26 00:00:00 | 29
Site B | 2014-06-27 00:00:00 | 25
Site B | 2014-06-30 00:00:00 | 41