Hi Jim

I believe, I understand most of the model by now. At least
I understand enough to see, that this isn't just a case of
"try this or try that". IMHO it's a job for a consultant, so even
if it looks intriguing, I gracefully decline :-)
It will be too time consuming. Sorry!

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"hotherps " skrev i en meddelelse
...
Thanks again Leo, i did not see your e-mail address, you indicated I
could e-mail you. Sorry aboout forgetting my name, it is Jim. Let me
try to answer your questions in the order you asked them.

E:26 J:30 will actualy come from a different linked spreadsheet. The
values are the number of hours required in each task per time period,
for that day.

PPI, Pack etc. are abbreviations of different tasks that can be
performed while working on a given shift. This number can, and usually
does change by day. and sometimes might not be needed at all.

Brk or Lun, are actually Break and Lunch, I like to try and set breaks
about two hours into a shift then 2 hours later Lunch, and one more
break two hours after that. The code asssigns them and then shuffles
them to try and keep as many people working as possible at any given
time. That code is basic but it seems to work OK.

The times in D25:D30 indicate what time of day the task is required. So
in D26, 25 hours of time are needed to perform this task. So in the
range above we would need to see 100 15minute blocks populated with
"Mail" to reach the requirement. (There are over 200 employees)

There are 24 hour shifts, the model I provided is a condensed version
af a very large spread sheet that is used. You are looking at a
miniature version of all of the ranges

I could zip you a version of what the actual file looks like. I'm just
trying to get the functionality working before applying it to the file,
it is rather large.

The logic goes like this:
The workload is driven by hours required per task, per day, per hour.
Then the task has to get matched to an employee who is working (Between
Col B (Shift Start) and C (Shift End)). The employee must also be
trained to perform that task Range AK3:AP19 and "x" indicates the
person is trained in this task. So the code has to assign tasks based
on the number of hours needed and the number of employees that can do
the task and are working at that time.
I hope that makes sense to you.
If the code fails i.e. not enough employees to do the task, it should
just move on to the next task, those will be entered manually.

Please forward anymore questions, I'm curious to get your opinion on
the whole model, maybe you have a better suggestion?

Thanks so much,
Jim


---
Message posted from http://www.ExcelForum.com/