PDA

View Full Version : [SOLVED] Optimize Production



stapuff
01-18-2005, 10:45 AM
I have posted the following link on Ozgrid.


http://www.ozgrid.com/forum/showthread.php?t=28508


An example spreadsheet has been attached on Ozgrid.


Any help would be greatly appreciated.


Thanks,


Kurt

mdmackillop
01-18-2005, 03:59 PM
Hi Kurt,
Try the attached for a non-VBA solution
MD :creator:

stapuff
01-18-2005, 07:45 PM
MD -

Thanks for your post back. In the sample I only gave 5 or 6 rows worth of info. My data is actually several hundred rows D3:D200. For this application I think code will be the only way to go. I have tried formula's to try to get the desired results with no luck. If you look at the original data - the quantity falls on a Friday with nothing from Monday - Thursday. My data goes out like that until the end of May. That is why the macro finds the first 0 then counts down until a value >0 is found. This breaks the main quantity down to a somewhat managable size yet I would be over producing by 33% or so.

Thanks,


Kurt

Jacob Hilderbrand
01-21-2005, 01:51 AM
Solved @ OzGrid