Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vacation accrual Spreadsheet
I am working on a spread sheet for my Company. I have looked at many examples
but I am still not finding what I need with the specific perimeters involved. the facts: PDO accrual rate increases every employee anniversary. PDO accrues every weekly pay period worked. PDO accrues after 90 days of employment. PDO max accrual is 120 hours. PDO incremental rate accrual as follows: 1st year----2.0 hrs per pay period after first year-----2.15 after second yr----2.3 after third year----2.46 after fourth year--2.61 after fifth year-----2.76 after sixth year----2.92 after seventh yr---3.07 after eigth yr------3.23 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vacation accrual Spreadsheet
=IF(TODAY()-D5<90,0,MIN(120,DATEDIF(D5,TODAY(),"M")*CHOOSE(SUM PRODUCT(--(DATEDIF(D5,TODAY(),"M"){0;1;2;3}*12)),2,2.15,2.3 ,2.46,2.61,2.76,2.92,3.07,3.23)))
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "TimBeau" wrote in message ... I am working on a spread sheet for my Company. I have looked at many examples but I am still not finding what I need with the specific perimeters involved. the facts: PDO accrual rate increases every employee anniversary. PDO accrues every weekly pay period worked. PDO accrues after 90 days of employment. PDO max accrual is 120 hours. PDO incremental rate accrual as follows: 1st year----2.0 hrs per pay period after first year-----2.15 after second yr----2.3 after third year----2.46 after fourth year--2.61 after fifth year-----2.76 after sixth year----2.92 after seventh yr---3.07 after eigth yr------3.23 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vacation accrual Spreadsheet
Bob,
Thanks for the formula. I copied it into a spreadsheet but im not sure how the cells should be set up to read to get the result. if I could impose upon you good nature....thanks "Bob Phillips" wrote: =IF(TODAY()-D5<90,0,MIN(120,DATEDIF(D5,TODAY(),"M")*CHOOSE(SUM PRODUCT(--(DATEDIF(D5,TODAY(),"M"){0;1;2;3}*12)),2,2.15,2.3 ,2.46,2.61,2.76,2.92,3.07,3.23))) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "TimBeau" wrote in message ... I am working on a spread sheet for my Company. I have looked at many examples but I am still not finding what I need with the specific perimeters involved. the facts: PDO accrual rate increases every employee anniversary. PDO accrues every weekly pay period worked. PDO accrues after 90 days of employment. PDO max accrual is 120 hours. PDO incremental rate accrual as follows: 1st year----2.0 hrs per pay period after first year-----2.15 after second yr----2.3 after third year----2.46 after fourth year--2.61 after fifth year-----2.76 after sixth year----2.92 after seventh yr---3.07 after eigth yr------3.23 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vacation accrual Spreadsheet
Tim,
In my tests, I just set the employee's start date in D5, and then plugged in that formula. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "TimBeau" wrote in message ... Bob, Thanks for the formula. I copied it into a spreadsheet but im not sure how the cells should be set up to read to get the result. if I could impose upon you good nature....thanks "Bob Phillips" wrote: =IF(TODAY()-D5<90,0,MIN(120,DATEDIF(D5,TODAY(),"M")*CHOOSE(SUM PRODUCT(--(DATEDIF(D5,TODAY(),"M"){0;1;2;3}*12)),2,2.15,2.3 ,2.46,2.61,2.76,2.92,3.07,3.23))) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "TimBeau" wrote in message ... I am working on a spread sheet for my Company. I have looked at many examples but I am still not finding what I need with the specific perimeters involved. the facts: PDO accrual rate increases every employee anniversary. PDO accrues every weekly pay period worked. PDO accrues after 90 days of employment. PDO max accrual is 120 hours. PDO incremental rate accrual as follows: 1st year----2.0 hrs per pay period after first year-----2.15 after second yr----2.3 after third year----2.46 after fourth year--2.61 after fifth year-----2.76 after sixth year----2.92 after seventh yr---3.07 after eigth yr------3.23 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vacation accrual Spreadsheet
http://spreadsheets.google.com/a/wir...NA&output=html
Here is a link to see the shet in google docs. I inserted your formula it doenst work in google. And in Excel it shows 120 instead of how many days or hours are accumulated through a certain date. "Bob Phillips" wrote: Tim, In my tests, I just set the employee's start date in D5, and then plugged in that formula. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "TimBeau" wrote in message ... Bob, Thanks for the formula. I copied it into a spreadsheet but im not sure how the cells should be set up to read to get the result. if I could impose upon you good nature....thanks "Bob Phillips" wrote: =IF(TODAY()-D5<90,0,MIN(120,DATEDIF(D5,TODAY(),"M")*CHOOSE(SUM PRODUCT(--(DATEDIF(D5,TODAY(),"M"){0;1;2;3}*12)),2,2.15,2.3 ,2.46,2.61,2.76,2.92,3.07,3.23))) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "TimBeau" wrote in message ... I am working on a spread sheet for my Company. I have looked at many examples but I am still not finding what I need with the specific perimeters involved. the facts: PDO accrual rate increases every employee anniversary. PDO accrues every weekly pay period worked. PDO accrues after 90 days of employment. PDO max accrual is 120 hours. PDO incremental rate accrual as follows: 1st year----2.0 hrs per pay period after first year-----2.15 after second yr----2.3 after third year----2.46 after fourth year--2.61 after fifth year-----2.76 after sixth year----2.92 after seventh yr---3.07 after eigth yr------3.23 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vacation accrual Spreadsheet
It needs a login, and I don't have one.
Perhaps the 120 is because they have been there long enough to accrue the max, 120. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "TimBeau" wrote in message ... http://spreadsheets.google.com/a/wir...NA&output=html Here is a link to see the shet in google docs. I inserted your formula it doenst work in google. And in Excel it shows 120 instead of how many days or hours are accumulated through a certain date. "Bob Phillips" wrote: Tim, In my tests, I just set the employee's start date in D5, and then plugged in that formula. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "TimBeau" wrote in message ... Bob, Thanks for the formula. I copied it into a spreadsheet but im not sure how the cells should be set up to read to get the result. if I could impose upon you good nature....thanks "Bob Phillips" wrote: =IF(TODAY()-D5<90,0,MIN(120,DATEDIF(D5,TODAY(),"M")*CHOOSE(SUM PRODUCT(--(DATEDIF(D5,TODAY(),"M"){0;1;2;3}*12)),2,2.15,2.3 ,2.46,2.61,2.76,2.92,3.07,3.23))) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "TimBeau" wrote in message ... I am working on a spread sheet for my Company. I have looked at many examples but I am still not finding what I need with the specific perimeters involved. the facts: PDO accrual rate increases every employee anniversary. PDO accrues every weekly pay period worked. PDO accrues after 90 days of employment. PDO max accrual is 120 hours. PDO incremental rate accrual as follows: 1st year----2.0 hrs per pay period after first year-----2.15 after second yr----2.3 after third year----2.46 after fourth year--2.61 after fifth year-----2.76 after sixth year----2.92 after seventh yr---3.07 after eigth yr------3.23 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vacation accrual Spreadsheet
Thanks, but I may not have been clear. I am having a difficult time getting
this issue solved "Bob Phillips" wrote: It needs a login, and I don't have one. Perhaps the 120 is because they have been there long enough to accrue the max, 120. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "TimBeau" wrote in message ... http://spreadsheets.google.com/a/wir...NA&output=html Here is a link to see the shet in google docs. I inserted your formula it doenst work in google. And in Excel it shows 120 instead of how many days or hours are accumulated through a certain date. "Bob Phillips" wrote: Tim, In my tests, I just set the employee's start date in D5, and then plugged in that formula. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "TimBeau" wrote in message ... Bob, Thanks for the formula. I copied it into a spreadsheet but im not sure how the cells should be set up to read to get the result. if I could impose upon you good nature....thanks "Bob Phillips" wrote: =IF(TODAY()-D5<90,0,MIN(120,DATEDIF(D5,TODAY(),"M")*CHOOSE(SUM PRODUCT(--(DATEDIF(D5,TODAY(),"M"){0;1;2;3}*12)),2,2.15,2.3 ,2.46,2.61,2.76,2.92,3.07,3.23))) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "TimBeau" wrote in message ... I am working on a spread sheet for my Company. I have looked at many examples but I am still not finding what I need with the specific perimeters involved. the facts: PDO accrual rate increases every employee anniversary. PDO accrues every weekly pay period worked. PDO accrues after 90 days of employment. PDO max accrual is 120 hours. PDO incremental rate accrual as follows: 1st year----2.0 hrs per pay period after first year-----2.15 after second yr----2.3 after third year----2.46 after fourth year--2.61 after fifth year-----2.76 after sixth year----2.92 after seventh yr---3.07 after eigth yr------3.23 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I calculation vacation accrual? | Excel Worksheet Functions | |||
Vacation Accrual Formula Need Help Please! | Excel Worksheet Functions | |||
Vacation Accrual formula | Excel Worksheet Functions | |||
Please help!! Vacation Accrual Formula | Excel Worksheet Functions | |||
Vacation Accrual Formula | Excel Worksheet Functions |