N
Nietz
Hey all, short time lurker first time poster. 
i have been asked to create a quick spreadsheet that calculates the
required mixing weight of two ingredients based on moisture content(%).
Knowns:
Total Finished Weight (kgs - assuming no loss)
Total moisture content (% - again assuming no loss)
Ingredient 1 moisture content (%)
Ingredient 2 moisture content (%)
Unknowns:
Weight of ingredient 1 (kgs)
Weight of ingredient 2 (kgs)
Formula assumptions:
Total Finished Weight = sum of ingredient weights
Total Moisture = (ingredient 1 weight * Ingredient 1 moisture) +
(ingredient 2 weight * Ingredient 2 moisture)
Everytime i come up with a viable equation it ends up either
referencing itself or the unknown weight of the other ingredient.
Anyhelp with the equation or on getting excel to calculate in a
circular fashion would be greatly appreciated.
Nietz
i have been asked to create a quick spreadsheet that calculates the
required mixing weight of two ingredients based on moisture content(%).
Knowns:
Total Finished Weight (kgs - assuming no loss)
Total moisture content (% - again assuming no loss)
Ingredient 1 moisture content (%)
Ingredient 2 moisture content (%)
Unknowns:
Weight of ingredient 1 (kgs)
Weight of ingredient 2 (kgs)
Formula assumptions:
Total Finished Weight = sum of ingredient weights
Total Moisture = (ingredient 1 weight * Ingredient 1 moisture) +
(ingredient 2 weight * Ingredient 2 moisture)
Everytime i come up with a viable equation it ends up either
referencing itself or the unknown weight of the other ingredient.
Anyhelp with the equation or on getting excel to calculate in a
circular fashion would be greatly appreciated.
Nietz