imperialipa
Well-Known Member
Any excel buffs out there?
There is a formula I would like to plug into excel which will have different X variables.
I am dialing in my wort volume and Preboil gravity for my system but until I nail it I have had cases where my efficency was too high or too low. I use beersmith but dont see anything that specifically addresses DME effect on wort (if you under gravity) and water dilution on wort (if your over gravity)
Example Had 7 gallons @ 1.082 and was supposed to have 1.065 pre boil. How much water to add to get it down to 1.065
C1V1 = C2V2
C concentration (points of gravity)
V is volume
C1=82
V1=7
C2=65
V2=x
82x7=65xX
574=65x
574/65= 8.83 gallons total
I would then do my normal boil and just end up with more wort than the anticipated 5.5 Gallons but at the correct gravity.
I believe this formula can be used to adjust your IBU's also.
There is a formula I would like to plug into excel which will have different X variables.
I am dialing in my wort volume and Preboil gravity for my system but until I nail it I have had cases where my efficency was too high or too low. I use beersmith but dont see anything that specifically addresses DME effect on wort (if you under gravity) and water dilution on wort (if your over gravity)
Example Had 7 gallons @ 1.082 and was supposed to have 1.065 pre boil. How much water to add to get it down to 1.065
C1V1 = C2V2
C concentration (points of gravity)
V is volume
C1=82
V1=7
C2=65
V2=x
82x7=65xX
574=65x
574/65= 8.83 gallons total
I would then do my normal boil and just end up with more wort than the anticipated 5.5 Gallons but at the correct gravity.
I believe this formula can be used to adjust your IBU's also.