Spreadsheet: 117006d1312389446-sum-weekly-totals-and-add-to-calendar-forum-test-1
Sheet: Pivot

 | Sum of Total Proposed | Sum of Total Actual
00:00:00 | 452.7533333333333 | 53.43
2010-10-20 00:00:00 | 9.78 | 0
2010-11-26 00:00:00 | 113.01 | 102.91
2010-12-17 00:00:00 | 95.9 | 0
2010-12-18 00:00:00 | 80.25 | 0
2010-12-19 00:00:00 | 79.11 | 88.09
2010-12-21 00:00:00 | 384.01 | 173.66
2010-12-22 00:00:00 | 171.19 | 149.09
2010-12-23 00:00:00 | 364.16 | 351.36
2010-12-27 00:00:00 | 356.39 | 109.11
2010-12-29 00:00:00 | 94.33999999999999 | 118.41
2010-12-30 00:00:00 | 137.3 | 137.24
2010-12-31 00:00:00 | 97.05 | 0
2011-01-01 00:00:00 | 54.85 | 54.85
2011-01-03 00:00:00 | 404.15 | 362.13
2011-01-06 00:00:00 | 174.21 | 156.23
2011-01-07 00:00:00 | 164.03 | 32.93
2011-01-11 00:00:00 | 19.06 | 16.78
2011-01-12 00:00:00 | 20.1 | 20.1
2011-01-18 00:00:00 | 130.51 | 0
2011-01-19 00:00:00 | 388 | 368.55
2011-01-20 00:00:00 | 124.18 | 119.92
2011-01-21 00:00:00 | 6 | 6
2011-01-24 00:00:00 | 618.2 | 591.5899999999999
2011-01-25 00:00:00 | 575.98 | 543.7
2011-01-27 00:00:00 | 133.31 | 111.5
2011-01-28 00:00:00 | 106.51 | 94.53999999999999
2011-01-29 00:00:00 | 95.76 | 86.93
2011-01-31 00:00:00 | 130.51 | 124.45
2011-02-01 00:00:00 | 6.05 | 6.05
2011-02-03 00:00:00 | 156.34 | 136.45
2011-02-04 00:00:00 | 65.08 | 67.15
2011-02-07 00:00:00 | 122.01 | 118.36
2011-02-08 00:00:00 | 236.22 | 217.31
2011-02-09 00:00:00 | 0 | 7.52
2011-02-10 00:00:00 | 75 | 70.19
2011-02-11 00:00:00 | 398.14 | 288.94
2011-02-14 00:00:00 | 77.01 | 77.01
2011-02-17 00:00:00 | 190.67 | 193.76
2011-02-21 00:00:00 | 231.81 | 220.74
2011-02-22 00:00:00 | 374.27 | 374.93
2011-02-23 00:00:00 | 258.91 | 240.54
2011-02-25 00:00:00 | 48 | 36.47
2011-03-02 00:00:00 | 30.64 | 47.92
2011-03-07 00:00:00 | 108.99 | 105.13
2011-03-08 00:00:00 | 95.76 | 86.31
2011-03-10 00:00:00 | 10 | 8.79
2011-03-11 00:00:00 | 167.89 | 150.33
2011-03-14 00:00:00 | 30 | 33.13
2011-03-15 00:00:00 | 52.8 | 52.8
2011-03-16 00:00:00 | 269.45 | 242.23
2011-03-17 00:00:00 | 122.01 | 113.38
2011-03-18 00:00:00 | 0 | 4.13
2011-03-22 00:00:00 | 57.4 | 56.64
2011-03-24 00:00:00 | 11 | 10.15
2011-03-25 00:00:00 | 285.84 | 250.89
2011-03-26 00:00:00 | 0 | 0
2011-03-28 00:00:00 | 152.47 | 142.59
2011-03-29 00:00:00 | 236.67 | 223.78
2011-03-30 00:00:00 | 286.99 | 260.46
2011-03-31 00:00:00 | 309.17 | 221.41
2011-04-01 00:00:00 | 268.4 | 252.44
2011-04-04 00:00:00 | 92.91000000000001 | 84.62
2011-04-05 00:00:00 | 569.14 | 502.4299999999999
2011-04-06 00:00:00 | 397.21 | 321.23
2011-04-11 00:00:00 | 156.81 | 141.11
2011-04-12 00:00:00 | 314.77 | 284.45
2011-04-13 00:00:00 | 257.56 | 262.24
2011-04-14 00:00:00 | 215.4 | 197.49
2011-04-15 00:00:00 | 55 | 53.46
2011-04-16 00:00:00 | 286.88 | 268.17
2011-04-18 00:00:00 | 75.7 | 76.19
2011-04-20 00:00:00 | 185.47 | 171.62
2011-04-21 00:00:00 | 166.5 | 158.16
2011-04-26 00:00:00 | 152.32 | 157.83
2011-04-27 00:00:00 | 343 | 346.33
2011-04-28 00:00:00 | 55 | 48.58
2011-04-30 00:00:00 | 70 | 62.79
2011-05-02 00:00:00 | 10.56 | 10.56
2011-05-03 00:00:00 | 14 | 11.07
2011-05-04 00:00:00 | 260.07 | 253.88
2011-05-05 00:00:00 | 94.26 | 86.85
2011-05-06 00:00:00 | 384.1 | 344.91
2011-05-07 00:00:00 | 97.31 | 86.98
2011-05-09 00:00:00 | 122.09 | 105.75
2011-05-10 00:00:00 | 16.5 | 12.75
2011-05-12 00:00:00 | 8.5 | 6.449999999999999
2011-05-13 00:00:00 | 0 | 0
2011-05-16 00:00:00 | 141.5 | 121.23
2011-05-19 00:00:00 | 188.47 | 173.55
2011-05-23 00:00:00 | 251.12 | 226.26
2011-05-24 00:00:00 | 31 | 29.83
2011-05-25 00:00:00 | 68 | 85.66
2011-05-26 00:00:00 | 45 | 44.72
2011-05-27 00:00:00 | 352.69 | 311.14
2011-05-31 00:00:00 | 97.5 | 92.59
2011-06-02 00:00:00 | 174.51 | 172.67
2011-06-03 00:00:00 | 117.47 | 111.99
2011-06-06 00:00:00 | 586.5600000000001 | 543.4499999999999
2011-06-07 00:00:00 | 298.13 | 268.73
2011-06-08 00:00:00 | 502.44 | 438.1900000000001
2011-06-14 00:00:00 | 73 | 64.57000000000001
2011-06-15 00:00:00 | 291.98 | 285.74
2011-06-16 00:00:00 | 149.69 | 133.77
2011-06-20 00:00:00 | 58.48 | 56.26
2011-06-22 00:00:00 | 212.69 | 201.51
2011-06-23 00:00:00 | 110.2 | 99.39
2011-06-24 00:00:00 | 94.26 | 88.19
2011-06-27 00:00:00 | 307.66 | 280.26
2011-06-29 00:00:00 | 188.67 | 179.11
2011-07-05 00:00:00 | 270.85 | 256.6
2011-07-06 00:00:00 | 124.3 | 102.06
2011-07-08 00:00:00 | 166.98 | 142.62
2011-07-09 00:00:00 | 11.76 | 11.1
2011-07-12 00:00:00 | 427.04 | 191.02
2011-07-14 00:00:00 | 9.75 | 9.19
2011-07-15 00:00:00 | 541.17 | 521.96
2011-07-18 00:00:00 | 84 | 74.31
2011-07-19 00:00:00 | 101 | 93.74000000000001
2011-07-21 00:00:00 | 161.47 | 160.83
2011-07-22 00:00:00 | 81.2 | 81.35
2011-07-25 00:00:00 | 116.2 | 110.59
2011-07-26 00:00:00 | 187.59 | 185.17
2011-07-28 00:00:00 | 326.99 | 269.47
2011-07-29 00:00:00 | 116 | 0
2011-08-01 00:00:00 | 353.5 | 319.55
2011-08-04 00:00:00 | 269 | 50.52
2011-08-05 00:00:00 | 81.2 | 0
2011-08-06 00:00:00 | 92.3 | 72.61
2011-08-08 00:00:00 | 441.52 | 0
2011-08-11 00:00:00 | 235.99 | 0
2011-08-15 00:00:00 | 176.65 | 0
2011-08-16 00:00:00 | 237.25 | 0
2011-08-17 00:00:00 | 538.42 | 0
2011-08-18 00:00:00 | 171.45 | 0
2011-08-19 00:00:00 | 555.16 | 0
2011-08-20 00:00:00 | 45 | 0
2011-08-22 00:00:00 | 37 | 0
2011-08-24 00:00:00 | 367.63 | 0
2011-08-25 00:00:00 | 242.15 | 0
2011-08-26 00:00:00 | 249.49 | 0
2011-08-27 00:00:00 | 241.16 | 0
2011-08-29 00:00:00 | 111 | 0
2011-08-30 00:00:00 | 564.3399999999999 | 0
2011-08-31 00:00:00 | 169.43 | 0
2011-09-01 00:00:00 | 160.9 | 0
2011-09-02 00:00:00 | 163.19 | 0
2011-09-06 00:00:00 | 230.06 | 0
2011-09-07 00:00:00 | 481.3 | 0
2011-09-09 00:00:00 | 85.56 | 0
2011-09-13 00:00:00 | 105.15 | 0
2011-09-14 00:00:00 | 0 | 0
2011-09-15 00:00:00 | 391.72 | 0
2011-09-16 00:00:00 | 170.32 | 0
2011-09-19 00:00:00 | 207.4 | 0
2011-09-20 00:00:00 | 194.17 | 0
2011-09-23 00:00:00 | 151.55 | 0
2011-09-26 00:00:00 | 100.63 | 0
2011-09-27 00:00:00 | 150.54 | 0
2011-09-28 00:00:00 | 190.4 | 0
2011-09-30 00:00:00 | 96.71000000000001 | 0
2011-10-01 00:00:00 | 0 | 0
2011-10-03 00:00:00 | 0 | 0
2011-10-04 00:00:00 | 175.52 | 0
2011-10-05 00:00:00 | 191.09 | 0
2011-10-07 00:00:00 | 232.54 | 0
2011-10-10 00:00:00 | 42 | 0
2011-11-01 00:00:00 | 0 | 0
2011-12-10 00:00:00 | 131.47 | 0
Grand Total | 30615.83333333334 | 19008.83