Home |
Search |
Today's Posts |
#10
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
no homework assignment - its part of the order entry system i'm working on to
determine packaging costs. and this would be the least number of boxes - balanced with the lowest cost. these containers will be used to ship frozen product overnight - so the fewer the better and the most product packed in the least number of boxes is my goal. its been a while since i've been in class and my programming hasn't been used in quite a long time. thanks for the help! J "Jim Cone" wrote: Gixxer_J, Do you actually mean the least number of boxes or the least cost? Using the large box would always give you the least number of boxes. Jim Cone San Francisco, USA "Gixxer_J_97" wrote in message ... i have 2 size shipping containers that are available the large can hold up to 36 bags of product and the small up to 6 bags how would i go about creating an algorithm that would calculate how many (the least number) small and large boxes i would need to use? I've gotten this far: Bags Small Large 1-6 1 0 7-12 2 0 13-18 3 0 19-24 0 1 25-30 0 1 31-36 0 1 37-42 1 1 43-48 2 1 49-54 3 1 55-60 0 2 61-66 0 2 67-72 0 2 73-78 1 2 79-84 2 2 85-90 3 2 91-96 0 3 97-102 0 3 103-108 0 3 109-114 1 3 115-120 2 3 121-126 3 3 127-132 0 4 133-138 0 4 139-144 0 4 etc etc and now i'm a bit stuck - any help is greatly appreciated thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
looking for my perfect algorithm | Excel Discussion (Misc queries) | |||
Algorithm Challenge | Excel Worksheet Functions | |||
Trendline Linear Algorithm | Excel Programming | |||
help with algorithm | Excel Programming | |||
Need help with algorithm | Excel Programming |