Need brains to develop algorithm

SKV

Active Member
Joined
Jan 7, 2009
Messages
255
I am doing some study in which I want to group records on certain parameters say weight, volume, Date of Mfg.

I want to pack the materials in boxes with above details with following constraints.

1. Total weight in the container should <= X
2. Total Volume in the Container should <=Y
3. Can not have more than 3 different manufacturing dates
4. Gap in the manufacturing dates should not be more than 5 days.
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Watch MrExcel Video

Forum statistics

Threads
1,118,876
Messages
5,574,765
Members
412,617
Latest member
mlharris
Top