2010 Interactive Federal Leave Chart
Feburary, 2012
2012 Chart Update: (With 2012 Tax Rates)
Download: 2012 Leave and Payroll.xls
Download: 2012 Leave and Payroll - Signed.xls
(You will need to install one of the CA2 Root Cert to use enable color coding on the signed version)
November, 2010
2011 Chart Update: (Still awaiting Federal Tax Changes)
Download: 2011 Leave and Payroll.xls
Thursday, January 29, 2010
I am finished!!! Sure, it could use some minor adjustments and cleaning up a bit, but I'm done
Download: 2010 Leave and Payroll.xls
Thursday, January 07, 2010
View Public Spreadsheet on Google Docs 2010 Leave and Payroll.xls
I had some free time so I have edited the attached Leave Chart (Original came from GEICO, I found on govexec it here ) to add functionality for additional calculations and automatic formatting. Excel will prompt for the use of macros. If "Disable Macros" is selected all calculations will continue to function, automatic formatting will not.
Download: 2010 LEAVE OT.xls
Very Basic Version (no VBA Code or automatic formating
Download: 2010 Leave Tracker Basic.xls
Figuring out the automatic formatting took some time. I normaly would have used conditional formatting, but Excel 2003 only allows Contitional Formatting for up to 3 different Styles, This has 7. For those that may be interested, the code inserted in the VBA editor onto the Sheet can be found here
Screenshot of Comments on the tracker, and Examples:
