On Jun 27, 3:51 pm, wrote:
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

In Sheet1
Have a cell named "MHPD" for man-hours-per-day, and put your value in
it (=8?)

In Sheet2
Place task durations in column A, a count of hours required for each
task
Enter formula =if($A1=0,"",if($A1MHPD,$A1-MHPD,"DONE")) into B1, copy
it down for each task. This will show time remaining (or DONE) for
each task at the end of Day1.

Copy B1 to C1, and then copy it down for each task. This will show
time remaining (or DONE) for each task at the end of Day2.

Continue copying as desired.

Heather,
If this doesn't help, I hope it gets you thinking along a helpful
line...

Brian Herbert Withun