I'm trying to find either an Excel function or some other calculator that will tell me the number of possible complete combinations/sets of an item given amounts of components.
I'm a high school chemistry teacher, and we're about to cover limiting reagents. This can be introduced through almost any manner of analogies: recipes, molecule kits, flower bouquets... I'm using S'mores (2 graham squares + 1 marshmallow + 6 chocolate pieces -> 1 S'more). While I can certainly find the "limiting reagent" on paper, I'd like to find a more computational approach so that I can more easily run multiple combinations.
I've found batch size calculators based on percents/weights and stoichiometry calculators that run actual chemical equations, but nothing that will do what I'm wanting--customize my own "reactions". The problem may be that I just don't know the correct terms to search for.
3 variants of the same question:
- What should I be searching for?
- What's an alternative to what I'm trying to find?
- How do I create what I want?