Spreadsheet to calculate (to within a few pennies, ideally!) the complete and accurate paycheck of any FAA air traffic controller, given such factors as base annual salary, overtime and other non-standard hours worked, CIP/COLA/affordability differential, W-4 entries, TSP and other deductions, etc.
The file provided includes calculations for Colorado state tax withholding. The calculation for any other state is left as an exercise to the reader.
Uses: better knowledge of your pay and differentials, making sure payroll got your hours entered properly, seeing what would change with an upgrade/downgrade/move, seeing what effect losing your medical and dropping to straight 80 would have...
Attached file is an Excel document; the "More information" option below is direct Dropbox download for a Numbers document.
The file provided includes calculations for Colorado state tax withholding. The calculation for any other state is left as an exercise to the reader.
Uses: better knowledge of your pay and differentials, making sure payroll got your hours entered properly, seeing what would change with an upgrade/downgrade/move, seeing what effect losing your medical and dropping to straight 80 would have...
Attached file is an Excel document; the "More information" option below is direct Dropbox download for a Numbers document.
