Hi, I am trying to create a FCC calculator for a formula that calculates the volumes of two (different proof) alcohols that would be needed to achieve a particular ABV. For example, say I have a 75.5% Everclear and 40% brandy and want a final ABV of 60% and a total of 16 ounces of liquid. The formula should calculate the amount of Everclear and brandy needed to create 16 ounces of 60% alcohol.
The formula looks like this:
(ABV1 – goalABV) * volume1
—————————————— = volume2
goalABV – ABV2
In the CFF plugin, the formula is input like this:
((fieldname2-fieldname8)*fieldname12)/(fieldname8-fieldname7)
The formula works on its own, but the complication is that there are nested calculations here.
Meaning the above calculation relies on the answer to a second calculation to determine volume1:
(goalvolume – volume2) = volume1
And, of course, volume2 is the solution to the first calculation.
So the form is set up to collect the known variables: goalABV, ABV1, ABV2 and goalvolume, followed by two calculation fields for volume1 and volume2.
In practice, though, this is not working. I imagine this is because of the nested calculations – each one relies on a value calculated by the other.
Is this even possible? Is there a way to do this in a single work flow?
-
This topic was modified 1 hour, 40 minutes ago by
. -
This topic was modified 1 hour, 40 minutes ago by .
The page I need help with: [log in to see the link]