Help Required: Stock lists - Calculating combinations of products

[MaD2ko0l]

Hi,

I am after a bit of help.

Here is what i have so far: stock.xlsx

Basically, i have 2x base products but we can interchange the parts between the sets so we have 1 variant per base product.

But what i want to calculate is how many sets i can make out of the available units that are in stock.

Any ideas?

Regards,

Martin