Thanks again Leo, i did not see your e-mail address, you indicated
could e-mail you. Sorry aboout forgetting my name, it is Jim. Let m
try to answer your questions in the order you asked them.
E:26 J:30 will actualy come from a different linked spreadsheet. Th
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 b
performed while working on a given shift. This number can, and usuall
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 break
about two hours into a shift then 2 hours later Lunch, and one mor
break two hours after that. The code asssigns them and then shuffle
them to try and keep as many people working as possible at any give
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. S
in D26, 25 hours of time are needed to perform this task. So in th
range above we would need to see 100 15minute blocks populated wit
"Mail" to reach the requirement. (There are over 200 employees)
There are 24 hour shifts, the model I provided is a condensed versio
af a very large spread sheet that is used. You are looking at
miniature version of all of the ranges
I could zip you a version of what the actual file looks like. I'm jus
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 (Betwee
Col B (Shift Start) and C (Shift End)). The employee must also b
trained to perform that task Range AK3:AP19 and "x" indicates th
person is trained in this task. So the code has to assign tasks base
on the number of hours needed and the number of employees that can d
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 shoul
just move on to the next task, those will be entered manually.
Please forward anymore questions, I'm curious to get your opinion o
the whole model, maybe you have a better suggestion?
Thanks so much,
Ji
--
Message posted from
http://www.ExcelForum.com