Duration problem
HI, I have a problem I want to solve. I do not know if I can solve it
in excel with iteration ( or even VBA). I cannot use MS Project. I
have a spreadsheet with task durations. I also have fixed man hours
per day. I would like to determine which tasks get done on which days.
The first task may not be completed in the first day. Sometimes it
will ( the task's duration varies from week to week, but they are
ordered ). One you finish with one task, you start the next and keep
going.
From what I can see, this is a bin packing problem, similar to the one
to back up files to cd's, but in this case, I can split the files.
thanks
Heather Foucault
|