Spreadsheet: 147965d1333049286-month-to-date-calculation-driving-me-crazy-example
Sheet: Sheet1

Product | Date | Raw | Unq | Raw Ratio | Unq Ratio | Join Hits | Submits | Joins | Join Income | [NAME] | Rebills | Rebill Income | Per-Min Income | Total Income | Refunds | Loss | Reversals | Reversal Income | Affiliate Payout | Additional Payout | Fees | Total Cost | Total Profit/Loss | Monthly Projected Income
Blah Inc Club | 2012-03-01 00:00:00 | 203594 | 107267 | 0.5979166666666667 | 0.3347222222222222 | 173832 | 79331 | 254 | 5521.37 | 0 | 658 | 17946.88 | 0 | 23488.2 | 26 | -1060 | 1 | 19.95 | -1518.63 | 0 | -195.67 | -2774.3 | 20713.9 | (20,713.90 x 31) |  | Y column  =average of product for that day * number of days for that month
TV | 2012-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 212213
Blah Inc Club | 2012-03-02 00:00:00 | 196586 | 101151 | 0.6194444444444445 | 0.3388888888888889 | 163828 | 76596 | 236 | 4977.39 | 0 | 666 | 17637.21 | 0 | 22614.6 | 29 | -1648.74 | 0 | 0 | -1551.2 | 0 | -398.32 | -3598.26 | 19016.34
TV | 2012-03-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 121521
Blah Inc Club | 2012-03-03 00:00:00 | 197404 | 105654 | 0.5812499999999999 | 0.3298611111111111 | 169896 | 77084 | 254 | 6668.2 | 0 | 814 | 21952.6 | 0 | 28620.8 | 40 | -1915.28 | 0 | 0 | -1768.91 | -100 | -270.59 | -4054.78 | 24566.02
TV | 2012-03-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 121512
Blah Inc Club | 2012-03-04 00:00:00 | 201119 | 110576 | 0.5368055555555555 | 0.3138888888888889 | 172381 | 74885 | 282 | 6068.48 | 0 | 1452 | 33454.15 | 0 | 39522.63 | 20 | -1014.89 | 0 | 0 | -2183.06 | 0 | -185.91 | -3383.86 | 36138.77
TV | 2012-03-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 121451
Blah Inc Club | 2012-03-05 00:00:00 | 183969 | 101750 | 0.7430555555555555 | 0.4298611111111111 | 155632 | 69308 | 182 | 4860.27 | 0 | 673 | 18380.53 | 0 | 23240.8 | 30 | -1539.69 | 0 | 0 | -1355.96 | 0 | -294.03 | -3189.68 | 20051.12
TV | 2012-03-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1545112
Blah Inc Club | 2012-03-06 00:00:00 | 223308 | 121540 | 0.6402777777777778 | 0.3673611111111111 | 196519 | 79386 | 259 | 6469.07 | 0 | 698 | 19247.27 | 0 | 25716.34 | 32 | -1432 | 0 | 0 | -1909.03 | 0 | -254.14 | -3595.17 | 22121.17
TV | 2012-03-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4541122
Blah Inc Club | 2012-03-07 00:00:00 | 223961 | 113796 | 0.7000000000000001 | 0.3763888888888889 | 204328 | 83731 | 236 | 4850.97 | 0 | 688 | 17425.96 | 0 | 22276.93 | 43 | -1886.93 | 0 | 0 | -1813.68 | 0 | -207.84 | -3908.45 | 18368.48
TV | 2012-03-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45121
Blah Inc Club | 2012-03-08 00:00:00 | 196761 | 102307 | 0.6458333333333334 | 0.3555555555555556 | 171525 | 76316 | 226 | 5413.74 | 0 | 653 | 17114.07 | 0 | 22527.81 | 26 | -1261.25 | 0 | 0 | -1975.06 | 0 | -258.25 | -3494.56 | 321456
TV | 2012-03-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 465123
Blah Inc Club | 2012-03-09 00:00:00 | 240479 | 134971 | 0.6715277777777778 | 0.3951388888888889 | 195468 | 84632 | 265 | 6456.96 | 0 | 422 | 14964.56 | 0 | 21421.52 | 42 | -1892.27 | 0 | 0 | -2024.06 | 0 | -243.07 | -4159.4 | 58891225
TV | 2012-03-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15664
Blah Inc Club | 2012-03-10 00:00:00 | 259522 | 144135 | 0.6458333333333334 | 0.3770833333333334 | 214135 | 92347 | 298 | 6266.06 | 0 | 454 | 16114.11 | 0 | 22380.17 | 26 | -1645.6 | 0 | 0 | -1871.08 | 0 | -239.64 | -3756.32 | 18623.85
TV | 2012-03-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1465456
Blah Inc Club | 2012-03-11 00:00:00 | 205269 | 110636 | 0.5694444444444444 | 0.3256944444444445 | 170239 | 75249 | 270 | 6535.61 | 0 | 420 | 14588.99 | 0 | 21124.6 | 12 | -698.64 | 0 | 0 | -2082.09 | 0 | -229.74 | -3010.47 | 18114.13
TV | 2012-03-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4654
Blah Inc Club | 2012-03-12 00:00:00 | 200953 | 107836 | 0.69375 | 0.3909722222222222 | 166254 | 76227 | 214 | 4406.8 | 0 | 426 | 14539.58 | 0 | 18946.38 | 20 | -866.79 | 0 | 0 | -1697.18 | 0 | -200 | -2763.97 | 16182.41
TV | 2012-03-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12324
Blah Inc Club | 2012-03-13 00:00:00 | 219241 | 118374 | 0.6291666666666667 | 0.3590277777777778 | 179716 | 77574 | 259 | 6046.45 | 0 | 455 | 16020.26 | 0 | 22066.71 | 39 | -2079.45 | 0 | 0 | -2501.76 | 0 | -277.8 | -4859.01 | 17207.7
TV | 2012-03-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1312312
Blah Inc Club | 2012-03-14 00:00:00 | 227789 | 119755 | 0.7319444444444444 | 0.4041666666666666 | 185407 | 78761 | 229 | 5651.54 | 0 | 360 | 12710.48 | 0 | 18362.02 | 12 | -536.45 | 0 | 0 | -1815.58 | -100 | -18.51 | -2470.54 | 15891.48
TV | 2012-03-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 645645
Blah Inc Club | 2012-03-15 00:00:00 | 201717 | 105934 | 0.68125 | 0.3770833333333334 | 167359 | 75233 | 219 | 4913.76 | 0 | 387 | 13620.21 | 0 | 18533.97 | 29 | -1346.83 | 0 | 0 | -1621.63 | 0 | -20.24 | -2988.7 | 15545.27
TV | 2012-03-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 313312312
Blah Inc Club | 2012-03-16 00:00:00 | 226460 | 116898 | 0.6173611111111111 | 0.3388888888888889 | 194024 | 75327 | 273 | 6851.93 | 0 | 459 | 16284.47 | 0 | 23136.4 | 25 | -1096.41 | 0 | 0 | -1741.7 | 0 | -45.94 | -2884.05 | 20252.35
TV | 2012-03-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 123
Blah Inc Club | 2012-03-17 00:00:00 | 205959 | 104888 | 0.6020833333333333 | 0.3270833333333333 | 168915 | 74870 | 255 | 5691.94 | 0 | 395 | 13778.4 | 0 | 19470.34 | 28 | -1417.6 | 0 | 0 | -1183.6 | 0 | -44.57 | -2645.77 | 16824.57
TV | 2012-03-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3213