Count Occurance

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ab3d4u - 12 Sep 2007 16:02 GMT

I have 5 departments each with at least 35 employees. Some of th
employees are listed in more than one dept based on % of their time.
have an annual salary spreadsheet with all their names. A task is give
to me where I have to identify a) employees listed in multiple dept b
total compensation for these employees listed more than one. The ide
behind this is to stream line payroll. Depts pay scale is different. I
a survey where they would prefere to work all chose based on high pay
Any help on this is very much appreciated

--
ab3d4u

Reply to this Message

Bob Phillips - 12 Sep 2007 18:19 GMT

Can you layout some sample data to help resolve this?

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> I have 5 departments each with at least 35 employees. Some of the
> employees are listed in more than one dept based on % of their time. I
[quoted text clipped - 4 lines]
> a survey where they would prefere to work all chose based on high pay.
> Any help on this is very much appreciated.

Reply to this Message

ab3d4u - 12 Sep 2007 21:27 GMT

Bob Phillips;2364269 Wrote:

> Can you layout some sample data to help resolve this?
>
[quoted text clipped - 11 lines]
> pay.
> Any help on this is very much appreciated.

Bob - here is the scoop. The company has about 200 employees.About 20
are in managerial positions. The rest are in 5 depts. There are a lot
of employees listed in more than one dept because they work in
different departments within the 8 working hours. Example: The
custodial staff doubles as security and driver, the admin secretary
works several hours in a two week period as payroll assistant. I see a
lot FTE (full time equvalent) of .50,.80 and .90 etc The driver and the
PR asst jobs pay more. So in one spreadsheet I see the same name in
different places. Mgmt wants to offer a reasonable pay and job not as
the employee wants. I just need to know how to do this for the future.
For now I've done it the old way.

Signature

ab3d4u

Reply to this Message