P
ppp ppp
I have this huge file with employment data. I want to make sure i have
enough employees at the time when we have lots of customers, now when
the vacations coming up.
I have made a pivot table of the names and the work times of the
employees every day, to the right of it i made a graphical
presentation of their work times ciontaining formulas and custom
formatting so i easily see where i need more people, i don't always
have the same number of employees at work. I would like for my model
to sum up the employees to though (as shown red text in the yellow
field in the pic). The dates are fixed position since they are a part
of the pivot table.
I could probably solve it with sumproduct, but it require so much
computing capacity, and the number of cells containing the formula
would be too much for my huge file.
a screendump of my problem
https://docs.google.com/present/edit?id=0AU0RVel2JP2zZGdmM3o2OHJfMGZubjJwZGQy&hl=en
any help is appriciated!
enough employees at the time when we have lots of customers, now when
the vacations coming up.
I have made a pivot table of the names and the work times of the
employees every day, to the right of it i made a graphical
presentation of their work times ciontaining formulas and custom
formatting so i easily see where i need more people, i don't always
have the same number of employees at work. I would like for my model
to sum up the employees to though (as shown red text in the yellow
field in the pic). The dates are fixed position since they are a part
of the pivot table.
I could probably solve it with sumproduct, but it require so much
computing capacity, and the number of cells containing the formula
would be too much for my huge file.
a screendump of my problem
https://docs.google.com/present/edit?id=0AU0RVel2JP2zZGdmM3o2OHJfMGZubjJwZGQy&hl=en
any help is appriciated!