Spreadsheet: 49725d1249046134-vlookup-401-ded-worksheet-upload
Sheet: 401k

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