Spreadsheet: 39452d1237607710-if-vlookup-payroll-3
Sheet: Pay Stubs

 |  | [Company Name] |  |  |  |  |  |  |  |  | Pay Categories
 |  | Period: | 2009-01-01 00:00:00 | 2009-01-14 00:00:00 | Employee Name | [NAME] | Employee ID | 12345 |  | Key | Position | Category | [NAME] | Overtime Rate | Double Time Rate
 |  |  |  |  |  |  |  |  |  | General-A | General | A | 7.5 | 11.25 | 15
 |  | Tax Status |  |  | Position | General | Hours Worked | 61 |  | General-B | General | B | 8 | 12 | 16
 |  | Federal Allowance (From W-4) |  |  | Category | C | Overtime Hours | 16 |  | General-C | General | C | 8.5 | 12.75 | 17
 |  | Social Security Tax | 0.023 |  | [NAME] | 8.5 | Double Time Hours | 16 |  | General-D | General | D | 9 | 13.5 | 18
 |  | Medicare Tax | 0.28 |  | Overtime Rate | 12.75 | Sick Hours | 21 |  | Tech-A | Tech | A | 10 | 15 | 20
 |  | Federal Income Tax | 4 |  | Double Time Rate | 17 | Vacations Hours | 16 |  | Tech-B | Tech | B | 11 | 16.5 | 22
 |  | State Tax | 1 |  | Insurance Premium |  | Gross Pay | 722.5 |  | Tech-C | Tech | C | 12 | 18 | 24
 |  |  |  |  |  |  | Net Pay |  |  | Tech-D | Tech | D | 13 | 19.5 | 26
 |  |  |  |  |  |  |  |  |  | A Manager-A | A Manager | A | 12.5 | 18.75 | 25
 |  |  |  |  |  |  |  |  |  | A Manager-B | A Manager | B | 14 | 21 | 28
 |  | [Company Name] |  |  |  |  |  |  |  | A Manager-C | A Manager | C | 15.5 | 23.25 | 31
 |  | Period: | 2009-01-01 00:00:00 | 2009-01-14 00:00:00 | Employee Name | [NAME] | Employee ID | 22222 |  | A Manager-D | A Manager | D | 17 | 25.5 | 34
 |  |  |  |  |  |  |  |  |  | Manager-A | Manager | A | 15 | 22.5 | 30
 |  | Tax Status |  |  | Position | General | Hours Worked | 191 |  | Manager-B | Manager | B | 17 | 25.5 | 34
 |  | Federal Allowance (From W-4) |  |  | Category | B | Overtime Hours | 104 |  | Manager-C | Manager | C | 19 | 28.5 | 38
 |  | Social Security Tax | 0.023 |  | [NAME] | 8 | Double Time Pay | 51 |  | Manager-D | Manager | D | 21 | 31.5 | 42
 |  | Medicare Tax | 0.28 |  | Overtime Rate | 12 | Sick Hours | 36
 |  | Federal Income Tax | 4 |  | Double Time Rate | 16 | Vacations Hours
 |  | State Tax | 1 |  | Insurance Premium |  | Gross Pay | 2352
 |  |  |  |  |  |  | Net Pay
 |  | [Company Name]
 |  | Period: | 2009-01-01 00:00:00 | 2009-01-14 00:00:00 | Employee Name | [NAME] | Employee ID | 33333
 |  | Tax Status |  |  | Position | General | Hours Worked | 191
 |  | Federal Allowance (From W-4) |  |  | Category | A | Overtime Hours | 104
 |  | Social Security Tax | 0.023 |  | [NAME] | 7.5 | Double Time Pay | 51
 |  | Medicare Tax | 0.28 |  | Overtime Rate | 11.25 | Sick Hours | 36
 |  | Federal Income Tax | 4 |  | Double Time Rate | 15 | Vacations Hours
 |  | State Tax | 1 |  | Insurance Premium |  | Gross Pay | 2205
 |  |  |  |  |  |  | Net Pay
 |  | [Company Name]
 |  | Period: | 2009-01-01 00:00:00 | 2009-01-14 00:00:00 | Employee Name | [NAME] | Employee ID | 44444
 |  | Tax Status |  |  | Position | Tech | Hours Worked | 191
 |  | Federal Allowance (From W-4) |  |  | Category | B | Overtime Hours | 104
 |  | Social Security Tax | 0.023 |  | [NAME] | 11 | Double Time Pay | 51
 |  | Medicare Tax | 0.28 |  | Overtime Rate | 16.5 | Sick Hours | 36
 |  | Federal Income Tax | 4 |  | Double Time Rate | 22 | Vacations Hours
 |  | State Tax | 1 |  | Insurance Premium |  | Gross Pay | 3234
 |  |  |  |  |  |  | Net Pay
 |  | [Company Name]
 |  | Period: | 2009-01-01 00:00:00 | 2009-01-14 00:00:00 | Employee Name | [NAME] | Employee ID | 55555
 |  | Tax Status |  |  | Position | Tech | Hours Worked | 191
 |  | Federal Allowance (From W-4) |  |  | Category | A | Overtime Hours | 104
 |  | Social Security Tax | 0.023 |  | [NAME] | 10 | Double Time Pay | 51
 |  | Medicare Tax | 0.28 |  | Overtime Rate | 15 | Sick Hours | 36
 |  | Federal Income Tax | 4 |  | Double Time Rate | 20 | Vacations Hours
 |  | State Tax | 1 |  | Insurance Premium |  | Gross Pay | 2940
 |  |  |  |  |  |  | Net Pay
 |  | [Company Name]
 |  | Period: | 2009-01-01 00:00:00 | 2009-01-14 00:00:00 | Employee Name | [NAME] 6 | Employee ID | 66666
 |  | Tax Status |  |  | Position | Manager | Hours Worked | 191
 |  | Federal Allowance (From W-4) |  |  | Category | C | Overtime Hours | 104
 |  | Social Security Tax | 0.023 |  | [NAME] | 19 | Double Time Pay | 51
 |  | Medicare Tax | 0.28 |  | Overtime Rate | 28.5 | Sick Hours | 36
 |  | Federal Income Tax | 4 |  | Double Time Rate | 38 | Vacations Hours
 |  | State Tax | 1 |  | Insurance Premium |  | Gross Pay | 5586
 |  |  |  |  |  |  | Net Pay
 |  | [Company Name]
 |  | Period: | 2009-01-01 00:00:00 | 2009-01-14 00:00:00 | Employee Name | [NAME] 33 | Employee ID | 77777
 |  | Tax Status |  |  | Position | Tech | Hours Worked | 191
 |  | Federal Allowance (From W-4) |  |  | Category | B | Overtime Hours | 104
 |  | Social Security Tax | 0.023 |  | [NAME] | 11 | Double Time Pay | 51
 |  | Medicare Tax | 0.28 |  | Overtime Rate | 16.5 | Sick Hours | 36
 |  | Federal Income Tax | 4 |  | Double Time Rate | 22 | Vacations Hours
 |  | State Tax | 1 |  | Insurance Premium |  | Gross Pay | 3234
 |  |  |  |  |  |  | Net Pay
 |  | [Company Name]
 |  | Period: | 2009-01-01 00:00:00 | 2009-01-14 00:00:00 | Employee Name | [NAME] | Employee ID | 88888
 |  | Tax Status |  |  | Position | General | Hours Worked | 191
 |  | Federal Allowance (From W-4) |  |  | Category | A | Overtime Hours | 104
 |  | Social Security Tax | 0.023 |  | [NAME] | 7.5 | Double Time Pay | 51
 |  | Medicare Tax | 0.28 |  | Overtime Rate | 11.25 | Sick Hours | 36
 |  | Federal Income Tax | 4 |  | Double Time Rate | 15 | Vacations Hours
 |  | State Tax | 1 |  | Insurance Premium |  | Gross Pay | 2205
 |  |  |  |  |  |  | Net Pay