View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] h_wiley39@hotmail.com is offline
external usenet poster
 
Posts: 2
Default 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