Re: Calculating vacation accrual

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: JulieD (JulieD_at_hctsReMoVeThIs.net.au)
Date: 08/26/04 

Date: Thu, 26 Aug 2004 22:30:35 +0800

Hi Teri

I've split it up into different columns ... i'm guessing it could be
combined into less but let's make sure the formula works in all situations
first:

place the person's name in column A
place the day that the person started in column B
place the month that the person started in column C
place the year that the person started in column D
place the evaluation day in column E
place the evaluation month in column F
place the evaluation year in column G

so for Mr A
A Mr A
B 22
C 9
D 2001
E 1
 F 9
G 2004

and in column H type the following formula
=ROUND(IF(G2-D2>7,IF(B2<=10,F2,F2-1)*1.25,IF(B2<=10,F2,F2-1)),0)

test for all your people.

Please let me know how you go.

Cheers
JulieD

"Teri" <Teri@discussions.microsoft.com> wrote in message
news:B9054CA5-6480-48FD-9D8B-431BFAB036BB@microsoft.com...
> Hi Julie,
>
> For someone with less than 7 years of service as of January 1 of the year,
> they will accrue 1 day for 10 months starting January 1. (That's a total
of
> 2 weeks).
>
> If they have more than 7 years of service, they get 3 weeks (1.25 days per
> month for 12 months).
>
> Since Mr. A started 13 years ago, he automatically accrues 1.25 days per
> month for 12 months (thru August: 8 x 1.25 = 10).
>
> Doess this help to clarify?
>
>
> "JulieD" wrote:
>
> > Hi Teri
> >
> > few things don't make sense to me:
> >
> > > > Mr. A has 3 years of service. After one year, our company gives 10
days
> > of
> > > > vacation. His hire day is 9/22. As of 9/1/04 of this year, he will
> > have
> > > > accrued 8 days of vacation.
> > > >
> > > > Mr. B has 13 years of service. After one year, our company gives 15
> > days of
> > > > vacation. His hire day is also 9/22. As of 9/1/04 of this year, he
> > will
> > > > have accrued 10 days of vacation.
> > > >
> >
> > if the only difference between these two is the year that they were
hired in
> > then as far as i understand your next paragraph Mr B should have 12 not
10
> > days of vacation. - being 1.5 days per month rather than 1 day per
month.
> > Additionally in your other post you said that someone with 7+ years of
> > service gets 15 days of vacation per year - here you state 12 ... what
am i
> > missing?
> >
> > > > If someone was hired on or before the 10th of January, they start
> > accruing
> > > > 1-1/2 days for each month up to 12 (with 7+ years of service). If
they
> > were
> > > > hired after the 10th, they will start accruing in February.
> > >
> >
> > Could you please clarify.
> >
> > Cheers
> > JulieD
> >
> >
> >
> >

Relevant Pages

  • Re: i = 10; result = ++i - --i; How result become ZERO
    ... Please clarify this ........ ... I think it is undefined in ANSI C. ... evaluation, then that would be 'unspecified behaviour'. ... "Between the previous and next sequence point an object ...
    (comp.lang.c)
  • Evaluation from Right to Left
    ... evaluation will take place from right to left. ... Can you pls clarify me regd the output that i got? ... void main ...
    (comp.lang.c)
  • Re: Code
    ... the user object and the $row array at the time of evaluation in the ... 'if'...i'm guessing the values aren't what you're expecting and the ...
    (alt.php)
  • Re: Lazy evaluation in an impure language?
    ... if an expression contains a call to an impure function, ... the programmer has option of using call-by-name via a keyword (maybe ... evaluation is done at every use of the name, ... the risk of people guessing the meaning and guessing wrong. ...
    (comp.lang.functional)