Finding out Multiple scenarios and options based on set requirements and combinations of data set

[mnty89]

Example data below to explain a little further-

Basically what I need to do is figure out a macro or a formula column which will calculate out the possible outcomes based on the data set that will find the consolidated versions possible.

Maximum weight for this example is 20,000
Maximum volume will be 100
Maximum spaces would be 10

I need to use the data below to find out all of the possibilities based on these requirements that I could combine the "Loads" to make sure they fall under the maximum or meet it. I just added the remaining based on the original column, but if that's not needed that's fine as well.

Any ideas or has anyone done this in a similar way for another application?

I'm hoping for something I can apply to a real life scenario on a broader scale for something currently being done manually.

Load	Weight	Volume	Spaces	Remaining Weight (Max 20000)	Remaining Volume (Max 100)	Remaining Spaces (Max 10)
1	10000	50	5	10000	50	5
2	5000	15	3	15000	85	7
3	11000	60	6	9000	40	4
4	9000	40	4	11000	60	6
5	3000	30	1	17000	70	9
6	500	6	1	19500	94	9
7	6000	25	2	14000	75	8
8	8000	35	4	12000	65	6
9	700	8	8	19300	92	2
10	900	7	5	19100	93	5

<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>