Spreadsheet: 507452d1489682097-calculating-federal-holidays-gs-timesheet
Sheet: Setup

 |  | Setup Information
 |  | What year do you want to start with? |  |  |  |  |  | 2017
 |  | What month do you want to start with? |  |  |  |  |  | 1 | NOTE: Use 1 for January, 2 for February, and so on.
 |  | Use or [NAME] hours carried over from last year
 |  | User Information
 |  | Name:
 |  | Address:
 |  | City:
 |  | State:
 |  | Zip:
 |  | Phone:
 |  | [NAME]:
 |  | GS Salary Information
 |  | Select your pay grade by putting an "x" in the box to the left of your step or pay level.
 |  | The pay scale shown below is for 2017. An updated pay scale for GS Employees can be found at https://www.federalpay.org/ and clicking on the GS Pay Scale link.
 |  | Then simply copy and paste the new numbers into the table below.
 |  | Grade | Column1 | Step 1 | Column2 | Step 2 | Column3 | Step 3 | Column4 | Step 4 | Column5 | Step 5 | Column6 | Step 6 | Column7 | Step 7 | Column8 | Step 8 | Column9 | Step 9 | Column10 | Step 10 | Column11 | WGI
 |  | GS 1 |  | 21316 |  | 22029 |  | 22738 |  | 23443 |  | 24152 |  | 24566 |  | 25267 |  | 25975 |  | 26002 |  | 26661 |  | VARIES
 |  | GS 2 |  | 23966 |  | 24537 |  | 25330 |  | 26002 |  | 26295 |  | 27068 |  | 27841 |  | 28614 |  | 29387 |  | 30161 |  | VARIES
 |  | GS 3 |  | 26150 |  | 27022 |  | 27894 |  | 28766 |  | 29638 |  | 30510 |  | 31383 |  | 32255 |  | 33127 |  | 33997 |  | 758
 |  | GS 4 |  | 29356 |  | 30334 |  | 31312 |  | 32290 |  | 33268 |  | 34246 |  | 35224 |  | 36202 |  | 37180 |  | 38158 |  | 850
 |  | GS 5 |  | 32844 |  | 33939 |  | 35035 |  | 36130 |  | 37225 |  | 38321 |  | 39416 |  | 40511 |  | 41607 |  | 42702 |  | 952
 |  | GS 6 | x | 36611 |  | 37832 |  | 39053 |  | 40273 |  | 41494 |  | 42715 |  | 43936 |  | 45156 |  | 46377 |  | 47598 |  | 1061
 |  | GS 7 |  | 40684 |  | 42041 |  | 43397 |  | 44754 |  | 46110 |  | 47467 |  | 48823 |  | 50180 |  | 51537 |  | 52893 |  | 1179
 |  | GS 8 |  | 45056 |  | 46558 |  | 48059 |  | 49561 |  | 51062 |  | 52564 |  | 54066 |  | 55567 |  | 57069 |  | 58570 |  | 1305
 |  | GS 9 |  | 49765 |  | 51424 |  | 53083 |  | 54742 |  | 56401 |  | 58060 |  | 59720 |  | 61379 |  | 63038 |  | 64697 |  | 1442
 |  | GS 10 |  | 54803 |  | 56630 |  | 58457 |  | 60285 |  | 62112 |  | 63939 |  | 65766 |  | 67593 |  | 69420 |  | 71247 |  | 1588
 |  | GS 11 |  | 60210 |  | 62216 |  | 64223 |  | 66230 |  | 68236 |  | 70243 |  | 72250 |  | 74256 |  | 76263 |  | 78270 |  | 1744
 |  | GS 12 |  | 72168 |  | 74574 |  | 76980 |  | 79386 |  | 81792 |  | 84197 |  | 86603 |  | 89009 |  | 91415 |  | 93821 |  | 2091
 |  | GS 13 |  | 85816 |  | 88677 |  | 91537 |  | 94398 |  | 97258 |  | 100118 |  | 102979 |  | 105839 |  | 108699 |  | 111560 |  | 2486
 |  | GS 14 |  | 101409 |  | 104790 |  | 108170 |  | 111551 |  | 114931 |  | 118312 |  | 121692 |  | 125073 |  | 128453 |  | 131833 |  | 2938
 |  | GS 15 |  | 119285 |  | 123261 |  | 127238 |  | 131214 |  | 135191 |  | 139167 |  | 143144 |  | 147120 |  | 151097 |  | 155073 |  | 3456
 |  | Payroll Information
 |  | What is your yearly salary? |  |  |  |  |  |  |  | If this is not the correct amount then change it in the list above
 |  | What is your hourly pay rate? |  |  |  |  |  |  |  | This is only calculated for the purposes of functions within this spreadsheet. It is based on a 40 hour work week.
 |  | What is your length of service in years? |  |  |  |  |  | 15
 |  | What is your accrual rate for paid time off?
 |  | What is your tax staus? |  |  |  |  |  | 1 |  | This should be 1 unless you make over $100,000 per year
 |  | What is your Federal witholding allowance? |  |  |  |  |  | 0 |  | Number of dependants your claiming
 |  | What is your state tax percentage rate? |  |  |  |  |  | 0 |  | This varies from state to state and some states have none. This information can be found online.
 |  | What is your Federal Income tax percentage rate? |  |  |  |  |  |  |  | This is based on your Federal Witholding Allowance
 |  | What is your Social Security percentage rate? |  |  |  |  |  | 0.062 |  | This information can be found online.
 |  | What is your Medicare Tax rate? |  |  |  |  |  | 0.0145 |  | This information can be found online.
 |  | What is your insurance deduction?
 |  | Any other deductions?
 |  | Federal Holidays
 |  |  |  | New Years Day
 |  |  |  | [NAME], Jr. Birthday
 |  |  |  | President's Day
 |  |  |  | Memorial Day
 |  |  |  | Independence Day
 |  |  |  | Labor Day
 |  |  |  | Columbus Day
 |  |  |  | Veterans Day
 |  |  |  | Thanksgiving Day
 |  |  |  | Christmas Day