working with wage tables based on years worked

set up table that would feed column "current wage". Table would consist of
years worked and associated wage. example:

name years worked current wage

TABLE
Years Wage
0 10.00
1 12.00
2 12.50
etc for about 20 years

Hi Ann

So what is your question? Looks like plain data input to me! No
calculations or anything like that required here. I would however enter the
wages in columns, rather than rows. In that way you use one row per
employee, so headings would be:

Name | Year1 | Year 2| and so on

Maybe an additional column just after name,to calculate the number of years
already worked?

--
[email protected]ve_2nd_at. Randburg, Gauteng, South Africa


"AnnC" wrote:

> set up table that would feed column "current wage". Table would consist of
> years worked and associated wage. example:
>
> name years worked current wage
>
> TABLE
> Years Wage
> 0 10.00
> 1 12.00
> 2 12.50
> etc for about 20 years

Hi Kassie,

I did not give enough info. I have about 200 union people on the payroll.
The union contract specifies the wage based on number of years worked. for
example for years 0-1 the starting wage is $12.00, after 1 year it is 12.50
per hour, after 3 years 13.00, etc.etc. up to and capped at after 13 years.

In one column I have employees start date, in the next column I'm
calculating the number of years worked. The next column would be the current
rate based on the above criteria. It would be neat if I could set up the
little table that would automatically enter the wage rate.

Thanks for your help
Ann

"Kassie" wrote:

> Hi Ann
>
> So what is your question? Looks like plain data input to me! No
> calculations or anything like that required here. I would however enter the
> wages in columns, rather than rows. In that way you use one row per
> employee, so headings would be:
>
> Name | Year1 | Year 2| and so on
>
> Maybe an additional column just after name,to calculate the number of years
> already worked?
>
> --
> [email protected]ve_2nd_at. Randburg, Gauteng, South Africa
>
>
> "AnnC" wrote:
>
> > set up table that would feed column "current wage". Table would consist of
> > years worked and associated wage. example:
> >
> > name years worked current wage
> >
> > TABLE
> > Years Wage
> > 0 10.00
> > 1 12.00
> > 2 12.50
> > etc for about 20 years

List your years and pay rates and then try something like:

=VLOOKUP(MIN(DATEDIF(A1,TODAY(),"y"),13),F1:G14,2)

--
HTH

Sandy
[email protected]
Replace@mailinator with @tiscali.co.uk


"AnnC" <[email protected]> wrote in message
news:[email protected]...
> Hi Kassie,
>
> I did not give enough info. I have about 200 union people on the payroll.
> The union contract specifies the wage based on number of years worked.
> for
> example for years 0-1 the starting wage is $12.00, after 1 year it is
> 12.50
> per hour, after 3 years 13.00, etc.etc. up to and capped at after 13
> years.
>
> In one column I have employees start date, in the next column I'm
> calculating the number of years worked. The next column would be the
> current
> rate based on the above criteria. It would be neat if I could set up the
> little table that would automatically enter the wage rate.
>
> Thanks for your help
> Ann
>
> "Kassie" wrote:
>
>> Hi Ann
>>
>> So what is your question? Looks like plain data input to me! No
>> calculations or anything like that required here. I would however enter
>> the
>> wages in columns, rather than rows. In that way you use one row per
>> employee, so headings would be:
>>
>> Name | Year1 | Year 2| and so on
>>
>> Maybe an additional column just after name,to calculate the number of
>> years
>> already worked?
>>
>> --
>> [email protected]ve_2nd_at. Randburg, Gauteng, South Africa
>>
>>
>> "AnnC" wrote:
>>
>> > set up table that would feed column "current wage". Table would
>> > consist of
>> > years worked and associated wage. example:
>> >
>> > name years worked current wage
>> >
>> > TABLE
>> > Years Wage
>> > 0 10.00
>> > 1 12.00
>> > 2 12.50
>> > etc for about 20 years