Hello,
I'm hoping some one can get me started building this excel spreadsheet... I have only a tiny bit of excel experience
I think this spreadsheet should be real simple and only have a few calculations...
I'm thinking the only Data needed will be:
Current Date.
Current Vacation hours.. (I will input this value each time I run the spreadsheet.... I'll get this biweekly updated number from my employer)
Number of Floating Holiday hours... (again I will supply and enter this number with each running of the spreadsheet.
I get an extra 40 hours of vacation once a year on my anniversary date .. I don't want to make this spreadsheet more complicated that it needs to be.. That additional 40 hours will show up paystub in a lump sum.... SO, I need to run the spreadsheet right around the time of my anniversary I can just add in 40 hours to my current total vacation hour balance.
For the last several years I've just been calculating it out (the old fashion way) buy using the long had formula below.
246.5 Vac – 160 = 86.5 ……….86.5 / 11.5 = ~7.52
42.5 Floating Holiday (hrs) ………………42.5/ 11.5 = ~ 3.69
Approx. 6.7 Hours per Month. Remaining Months in 2016 = 4……4 X 6.7 = ~26.8 26.8 / 11.5 = ~ 2.33
Anniversary hours = 40 40/11.5 = 3.5... (already included in Vac hours)
Current days on calendar are: 5…….. 13.5 – 9 = 4.5 Remaining days to take.
*********
**I always start by subtracting 160 hours from my Vac balance. I like to always have at least 160 hours in the GREEN... any hours in excess of 160 I consider to be available for use during the year. I divide each block of hours.. (Vacation or Holiday) by 11.5 since I work 11.5 hours shifts... and each time I take a full day off... it is charged as 11.5 hours = One day off.
I accrue roughly 6.7 hours of Vacation time per month... I use this value to calculate a look ahead of how many hours I will accrue for how ever many months remain in the year.
If anyone can supply any suggestions towards building this ......Your help will be greatly appreciated.
Thank You. Richard.
I'm hoping some one can get me started building this excel spreadsheet... I have only a tiny bit of excel experience
I think this spreadsheet should be real simple and only have a few calculations...
I'm thinking the only Data needed will be:
Current Date.
Current Vacation hours.. (I will input this value each time I run the spreadsheet.... I'll get this biweekly updated number from my employer)
Number of Floating Holiday hours... (again I will supply and enter this number with each running of the spreadsheet.
I get an extra 40 hours of vacation once a year on my anniversary date .. I don't want to make this spreadsheet more complicated that it needs to be.. That additional 40 hours will show up paystub in a lump sum.... SO, I need to run the spreadsheet right around the time of my anniversary I can just add in 40 hours to my current total vacation hour balance.
For the last several years I've just been calculating it out (the old fashion way) buy using the long had formula below.
246.5 Vac – 160 = 86.5 ……….86.5 / 11.5 = ~7.52
42.5 Floating Holiday (hrs) ………………42.5/ 11.5 = ~ 3.69
Approx. 6.7 Hours per Month. Remaining Months in 2016 = 4……4 X 6.7 = ~26.8 26.8 / 11.5 = ~ 2.33
Anniversary hours = 40 40/11.5 = 3.5... (already included in Vac hours)
Current days on calendar are: 5…….. 13.5 – 9 = 4.5 Remaining days to take.
*********
**I always start by subtracting 160 hours from my Vac balance. I like to always have at least 160 hours in the GREEN... any hours in excess of 160 I consider to be available for use during the year. I divide each block of hours.. (Vacation or Holiday) by 11.5 since I work 11.5 hours shifts... and each time I take a full day off... it is charged as 11.5 hours = One day off.
I accrue roughly 6.7 hours of Vacation time per month... I use this value to calculate a look ahead of how many hours I will accrue for how ever many months remain in the year.
If anyone can supply any suggestions towards building this ......Your help will be greatly appreciated.
Thank You. Richard.
