Scheduling problem

[Oslopelle]

I have two work-sheets.
On the first are the employees work percentages

from 01.01.01 to 02.01.06 100% (39 h/week) Patrik
from 03.01.06 to 01.01.07 80% (31,2 h/week) Patrik
from 01.01.07 to the future 90%

On the second is the whole data list with times, worked hours, dates
and percentages.

date in time out time hours Name %
01.02.02 08:00 17:00 9 Patrik 100
01.02.06 08:00 17:00 9 Patrik 80

How do i make the % change automaticly, in the period in question when
Patrik has changed his work time percentage?

In addition the list has over 25000 rows so the formula has to be
efficient and not take up to much space)

I'm going nuts!

 

[Guest]

Hi Per:

Please can you expain a little more on the data links between the firstand
second sheet.

That is the relationship on the dates?

What is the period in question?

You could try sumproduct or match/index.

But is the summary a summation of the data sheet or single entries?

How do you calculate the weekly average time (% X 39?)?

 

[tristan.huxley]

Hi Oslopelle,

I tend to do alot of work around scheduling, but considering that
myself and Martin can't see what you are working on, can you please
provide some more detail to this so that we can assist you with the
problem...

(Based on what I can see, it looks like a couple of SUMIF() formula's
or a {SUMPRODUCT()} array

If you want to send me a sample of your workbook, say 50 lines with
more information, feel free to