Spreadsheet: 112908d1308860529-sum-product-issue-sample_sumprodct_issue
Sheet: Sheet1

 |  |  |  | Month end date |  |  |  |  |  | weeks |  |  |  |  |  |  |  |  |  |  |  | 0 | 4 | 7 | 10 | 13
 |  |  |  | 2011-01-30 00:00:00 | 2011-02-27 00:00:00 | 2011-03-27 00:00:00 | 2011-05-01 00:00:00 | 2011-05-29 00:00:00 |  | 4 | 4 | 4 | 5 | 4 |  |  |  |  |  |  |  | 3 | 6 | 9 | 12 | 24 | 24
 |  |  |  | Tenure (months) |  |  |  |  |  | Sales |  |  |  |  |  | Sales / Week |  |  |  |  |  | Sales per week per Bucket
 |  | Name | Hire Date | P1 | P2 | P3 | P4 | P5 |  | P1 | P2 | P3 | P4 | P5 |  | P1 | P2 | P3 | P4 | P5 |  | 0-3 | 4-6 | 7-9 | 10-12 | 13-24 | 24 |  | YTD NAR | YTD Weeks | AVG YTD NAR
 |  | [NAME] | 2010-08-30 00:00:00 | 5.043956043956598 | 5.967032967033623 | 6.890109890110647 | 8.043956043956928 | 8.967032967033953 |  | 216 | 95 | 50 | 83 | 0 |  | 54 | 23.75 | 12.5 | 16.6 | 0 | 0 | #N/A | 38.875 | 10.23076923076923 | #N/A | #N/A | #N/A |  | 444 | 21 | 21.14285714285714
 |  | [NAME] | 2011-01-04 00:00:00 | 0.8571428571429514 | 1.780219780219976 | 2.703296703297001 | 3.857142857143281 | 4.780219780220306 |  | 1995 | 584 | 322 | 724 | 701 |  | 498.75 | 146 | 80.5 | 144.8 | 175.25 |  | 241.75 | 158.3333333333333 | #N/A | #N/A | #N/A | #N/A
 |  | [NAME] | 2010-12-27 00:00:00 | 1.120879120879244 | 2.043956043956269 | 2.967032967033293 | 4.120879120879573 | 5.043956043956598 |  | 420 | 320 | 460 | 450 | 587.5 |  | 105 | 80 | 115 | 90 | 146.875 |  | 0
 |  | [NAME] | 2010-12-06 00:00:00 | 1.813186813187012 | 2.736263736264037 | 3.659340659341062 | 4.813186813187342 | 5.736263736264367 |  | 872.5 | 460 | 384 | 1672.5 | 416 |  | 218.125 | 115 | 96 | 334.5 | 104
 |  | [NAME] | 2010-03-03 00:00:00 | 10.97802197802318 | 11.90109890110021 | 12.82417582417723 | 13.97802197802351 | 14.90109890110054 |  | 1068 | 590 | 1546 | 912.4 | 1836 |  | 267 | 147.5 | 386.5 | 182.48 | 459
 |  | [NAME] | 2010-10-19 00:00:00 | 3.395604395604769 | 4.318681318681794 | 5.241758241758818 | 6.395604395605099 | 7.318681318682123 |  | 673 | 652 | 480 | 1619 | 340 |  | 168.25 | 163 | 120 | 323.8 | 85
 |  | [NAME] | 2010-04-05 00:00:00 | 9.890109890110978 | 10.813186813188 | 11.73626373626503 | 12.89010989011131 | 13.81318681318833 |  | 425 | 535 | 170 | 272.5 | 43 |  | 106.25 | 133.75 | 42.5 | 54.5 | 10.75
 |  | [NAME] | 2009-09-28 00:00:00 | 16.12087912088089 | 17.04395604395792 | 17.96703296703494 | 19.12087912088122 | 20.04395604395825 |  | 500 | 742 | 250 | 704 | 799 |  | 125 | 185.5 | 62.5 | 140.8 | 199.75
 |  | [NAME] | 2008-09-02 00:00:00 | 29.0109890109922 | 29.93406593406922 | 30.85714285714625 | 32.01098901099253 | 32.93406593406955 |  | 105 | 115 | 0 | 112 | 0 |  | 26.25 | 28.75 | 0 | 22.4 | 0
 |  | [NAME] | 2008-09-15 00:00:00 | 28.58241758242072 | 29.50549450549775 | 30.42857142857477 | 31.58241758242105 | 32.50549450549808 |  | 80 | 140 | 1236 | 1635 | 2415 |  | 20 | 35 | 309 | 327 | 603.75
 |  | [NAME] | 2007-07-09 00:00:00 | 42.8901098901146 | 43.81318681319163 | 44.73626373626865 | 45.89010989011494 | 46.81318681319195 |  | 140 | 716 | 585 | 491 | 470 |  | 35 | 179 | 146.25 | 98.2 | 117.5
 |  | [NAME] | 2010-06-21 00:00:00 | 7.35164835164916 | 8.274725274726183 | 9.197802197803208 | 10.35164835164949 | 11.27472527472651 |  | 947 | 1390 | 820 | 1652 | 1087 |  | 236.75 | 347.5 | 205 | 330.4 | 271.75
 |  | [NAME] | 2003-03-03 00:00:00 | 95.27472527473574 | 96.19780219781276 | 97.1208791208898 | 98.27472527473607 | 99.1978021978131 |  | 353 | 414 | 590 | 711 | 295 |  | 88.25 | 103.5 | 147.5 | 142.2 | 73.75
 |  | [NAME] | 2009-05-25 00:00:00 | 20.2747252747275 | 21.19780219780453 | 22.12087912088155 | 23.27472527472783 | 24.19780219780486 |  | 25 | 270 | 90 | 271 | 140 |  | 6.25 | 67.5 | 22.5 | 54.2 | 35
 |  | Justin Chacko | 2011-01-17 00:00:00 | 0.4285714285714757 | 1.3516483516485 | 2.274725274725525 | 3.428571428571805 | 4.35164835164883 |  | 757 | 481 | 395 | 319 | 275 |  | 189.25 | 120.25 | 98.75 | 63.8 | 68.75
 |  | [NAME] | 2007-09-18 00:00:00 | 40.549450549455 | 41.47252747253203 | 42.39560439560906 | 43.54945054945534 | 44.47252747253236 |  | 147 | 191 | 90 | 110.5 | 182.5 |  | 36.75 | 47.75 | 22.5 | 22.1 | 45.625
 |  | [NAME] | 2010-08-30 00:00:00 | 5.043956043956598 | 5.967032967033623 | 6.890109890110647 | 8.043956043956928 | 8.967032967033953 |  | 347.8 | 1242 | 734 | 593.7 | 1100 |  | 86.95 | 310.5 | 183.5 | 118.74 | 275
 |  | [NAME] | 2006-01-16 00:00:00 | 60.65934065934733 | 61.58241758242435 | 62.50549450550137 | 63.65934065934766 | 64.58241758242468 |  | 1075 | 988 | 931.5 | 1785 | 397 |  | 268.75 | 247 | 232.875 | 357 | 99.25
 |  | [NAME] | 2006-04-11 00:00:00 | 57.85714285714921 | 58.78021978022624 | 59.70329670330327 | 60.85714285714955 | 61.78021978022657 |  | 1190 | 1480 | 640 | 797.5 | 460 |  | 297.5 | 370 | 160 | 159.5 | 115