Spreadsheet: 49679d1249017390-vlookup-401-ded-worksheet-upload-mod-2
Sheet: 401k

401K WEEKLY REPORT:  PAY DATE 07/17/2009
 |  | Total EMP DEDS |  | $$$ Contributors | 10 | Company Match Rate |  |  | Total Match | Total Payment
 |  | 1235.33 |  | %  Contributors | 10 | 0.04 |  |  | 688.328 | 1923.658
 |  |  |  |  |  | Base Wage Only (Regular Hours)
File# | Name | EMP DEDS | DEPT | SSN | Contribution Type | Contribution | S or H | Base Wage | Company Match | Total Payment
1 | Doe, [NAME] | 40 | R-F | 231548649 | Percent | 4% | Hourly | 1000 | 40 | 80
2 | [NAME], [NAME] | 100 | GA-F | 456898794 | Fixed | $100.00 | Hourly | 1600 | 64 | 164
4 | [NAME], [NAME] | 40 | NASH-F | 907599084 | Percent | 2% | Hourly | 2000 | 40 | 80
6 | Thompson, Jake | 40 | NASH-O | 135829934 | Percent | 4% | Hourly | 1000 | 40 | 80
7 | Garner, [NAME] | 80 | M-F | 158364959 | Fixed | $80.00 | Hourly | 800 | 32 | 112
8 | Holland, Maria | 90 | M-F | 180899664 | Fixed | $90.00 | Hourly | 800 | 32 | 122
9 | Graft, Scott | 110 | M-F | 203449809 | Fixed | $110.00 | Hourly | 600 | 24 | 134
10 | Topper, [NAME] | 0 | SD-F | 225999954 | No Contribution | $0.00 | Hourly | 0 | 0 | 0
11 | [NAME], [NAME] | 40 | LOUIS-F | 248550099 | Percent | 20% | Hourly | 200 | 8 | 48
12 | Trully, [NAME] | 120 | CORP | 271040244 | Fixed | $120.00 | Hourly | 800 | 32 | 152
13 | Fanta, [NAME] | 40 | D-O | 293750389 | Percent | 7% | Hourly | 600 | 24 | 64
14 | Shelton, [NAME] | 40 | UDS | 311100534 | Percent | 4% | Hourly | 1000 | 40 | 80
15 | Edwards, [NAME] | 32 | R-O | 336450679 | Percent | 4% | Hourly | 800 | 32 | 64
16 | Earhardt, Dale | 75 | M-F | 361800824 | Fixed | $75.00 | Hourly | 800 | 32 | 107
17 | [NAME], [NAME] | 55 | M-F | 383750969 | Fixed | $55.00 | Hourly | 800 | 32 | 87
18 | Frontal, [NAME] | 32 | M-F | 406201114 | Percent | 7% | Hourly | 480 | 19.2 | 51.2
19 | Edon, [NAME] | 65 | AL-O | 428781259 | Fixed | $65.00 | Hourly | 320 | 12.8 | 77.8
20 | [NAME], [NAME] | 100 | CORP | 451301404 | Fixed | $100.00 | Hourly | 1200 | 48 | 148
21 | Bing, [NAME] | 45 | CORP | 473821549 | Fixed | $45.00 | Salary | 1280 | 45 | 90
22 | [NAME], [NAME] | 76.93 | CORP | 496341694 | Percent | 4% | Salary | 1923.2 | 76.928 | 153.858
23 | [NAME], [NAME] | 14.4 | CORP | 518861839 | Percent | 2% | Salary | 600 | 14.4 | 28.8
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0
 |  | 0 | 0 | 0 | No Employee |  |  | 0 | 0 | 0