Spreadsheet: 112909d1308861149-sum-product-issue-sumproduct_daddy
Sheet: Sheet1

 |  |  |  | Month end date |  |  |  |  |  | weeks |  |  |  |  |  |  |  |  |  |  |  | 0 | 4 | 7 | 10 | 13 | 25
 |  |  |  | 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 | 1000
 |  |  |  | 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 | 6 | 7 | 8 | 9 |  | 216 | 95 | 50 | 83 | 0 |  | 54 | 23.75 | 12.5 | 16.6 | 0 | 0 | 0 | 38.875 | 10.23076923076923 | 0 | 0 | 0 |  | 444 | 21 | 21.14285714285714
 |  | [NAME] | 2011-01-04 00:00:00 | 1 | 2 | 3 | 4 | 5 |  | 1995 | 584 | 322 | 724 | 701 |  | 498.75 | 146 | 80.5 | 144.8 | 175.25 |  | 241.75 | 158.3333333333333 | 0 | 0 | 0 | 0
 |  | [NAME] | 2010-12-27 00:00:00 | 1 | 2 | 3 | 4 | 5 |  | 420 | 320 | 460 | 450 | 587.5 |  | 105 | 80 | 115 | 90 | 146.875
 |  | [NAME] | 2010-12-06 00:00:00 | 2 | 3 | 4 | 5 | 6 |  | 872.5 | 460 | 384 | 1672.5 | 416 |  | 218.125 | 115 | 96 | 334.5 | 104
 |  | [NAME] | 2010-03-03 00:00:00 | 11 | 12 | 13 | 14 | 15 |  | 1068 | 590 | 1546 | 912.4 | 1836 |  | 267 | 147.5 | 386.5 | 182.48 | 459
 |  | [NAME] | 2010-10-19 00:00:00 | 3 | 4 | 5 | 6 | 7 |  | 673 | 652 | 480 | 1619 | 340 |  | 168.25 | 163 | 120 | 323.8 | 85
 |  | [NAME] | 2010-04-05 00:00:00 | 10 | 11 | 12 | 13 | 14 |  | 425 | 535 | 170 | 272.5 | 43 |  | 106.25 | 133.75 | 42.5 | 54.5 | 10.75
 |  | [NAME] | 2009-09-28 00:00:00 | 16 | 17 | 18 | 19 | 20 |  | 500 | 742 | 250 | 704 | 799 |  | 125 | 185.5 | 62.5 | 140.8 | 199.75
 |  | [NAME] | 2008-09-02 00:00:00 | 29 | 30 | 31 | 32 | 33 |  | 105 | 115 | 0 | 112 | 0 |  | 26.25 | 28.75 | 0 | 22.4 | 0
 |  | [NAME] | 2008-09-15 00:00:00 | 29 | 30 | 30 | 32 | 33 |  | 80 | 140 | 1236 | 1635 | 2415 |  | 20 | 35 | 309 | 327 | 603.75
 |  | [NAME] | 2007-07-09 00:00:00 | 43 | 44 | 45 | 46 | 47 |  | 140 | 716 | 585 | 491 | 470 |  | 35 | 179 | 146.25 | 98.2 | 117.5
 |  | [NAME] | 2010-06-21 00:00:00 | 7 | 8 | 9 | 10 | 11 |  | 947 | 1390 | 820 | 1652 | 1087 |  | 236.75 | 347.5 | 205 | 330.4 | 271.75
 |  | [NAME] | 2003-03-03 00:00:00 | 95 | 96 | 97 | 98 | 99 |  | 353 | 414 | 590 | 711 | 295 |  | 88.25 | 103.5 | 147.5 | 142.2 | 73.75
 |  | [NAME] | 2009-05-25 00:00:00 | 20 | 21 | 22 | 23 | 24 |  | 25 | 270 | 90 | 271 | 140 |  | 6.25 | 67.5 | 22.5 | 54.2 | 35
 |  | Justin Chacko | 2011-01-17 00:00:00 | 0 | 1 | 2 | 3 | 4 |  | 757 | 481 | 395 | 319 | 275 |  | 189.25 | 120.25 | 98.75 | 63.8 | 68.75
 |  | [NAME] | 2007-09-18 00:00:00 | 41 | 41 | 42 | 44 | 44 |  | 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 | 6 | 7 | 8 | 9 |  | 347.8 | 1242 | 734 | 593.7 | 1100 |  | 86.95 | 310.5 | 183.5 | 118.74 | 275
 |  | [NAME] | 2006-01-16 00:00:00 | 61 | 62 | 63 | 64 | 65 |  | 1075 | 988 | 931.5 | 1785 | 397 |  | 268.75 | 247 | 232.875 | 357 | 99.25
 |  | [NAME] | 2006-04-11 00:00:00 | 58 | 59 | 60 | 61 | 62 |  | 1190 | 1480 | 640 | 797.5 | 460 |  | 297.5 | 370 | 160 | 159.5 | 115