Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Calculation Based on Multiple Portal Line Entries


agian510
 Share

Recommended Posts

Hey Guys,

So I am working on my brewing recipe guide and I am trying to create an "IBU" calculation. So here is the formula i am trying to use, working with a 5 gallon batch:

Ounces x Alpha Acid x Percentage Utilization(boil time) divided by 7.25.


Percentage Hop Utilization for a 5 gallon batch of homebrew
31%      over 60 Minutes
30%      51 to 60 Minutes
28.1%   46 to 50 Minutes
26.9%   45 to 41 Minutes
22.8%   40 to 36 Minutes
18.8%   31 to 35 Minutes
15.3%   26 to 30 Minutes
12.1%   21 to 25 Minutes   
10.1%   16 to 20 Minutes
8%        11 to 15 Minutes
6%          6 to 10 Minutes
5%         Up to 5 Minutes

So a few questions:

1. Would I have to create a new table for the Hop Utilization with the percentages tied to the boil time? (eg. 30% at 60 minutes, 15.3% at 30 minutes)

2. How would I be able to create the calculation using multiple line items within the hop ingredient portal? What is the way to get Filemaker to calculate from a portal?

 

Thanks

 

Brew.jpg

Link to comment
Share on other sites

 Share



×
×
  • Create New...

Important Information

Terms of Use