Author Topic: Calculation of ABV  (Read 35522 times)

Offline TheCronx

  • BeerSmith Apprentice Brewer
  • **
  • Posts: 5
  • The Cronx Brewery
    • The Cronx
Calculation of ABV
« on: April 13, 2012, 03:28:38 AM »
Hi all!

We have been test brewing for a while with the help of Beersmith and will very soon be investing in a 12BBL setup in London and hope to continue using Beersmith.

One thing we have found however, is that the formula used in the program for ABV calculation is not the same as the one used by HM Revenue and Customs to calculate the amount of duty we have to pay on each brew.

Is there any chance we could introduce an option to have it calculated in this way please? I have detailed the method they have for calculating the ABV below (As with anything with HMRC, it isn't easy!!)  ;D

Quote
When you have taken your readings, calculate the alcoholic strength using the formula:
(OG – PG) x f = a% ABV
Where:

OG is the original gravity of the beer

PG is the present gravity of the beer

a is the beer's alcoholic strength, and

f is the factor connecting the change in gravity to alcoholic strength. The value of 'f' is not constant because the yield of alcohol is not constant for all fermentations. In lower strength beers, more of the 'sugars' available for fermentation are consumed in yeast reproduction than in producing alcohol. The table at 30.3, produced by the Laboratory of the Government Chemist, shows the changing value of ‘f’ depending on the alcoholic strength of the beer.


Quote

30.3 Value of factor 'f' for various alcoholic strengths
(OG - PG)                     % ABV                    Factor
Up to 6.9                    Up to 0.8                 0.125
7.0 – 10.4                   0.8 – 1.3                 0.126
10.5 – 17.2                 1.3 – 2.1                 0.127
17.3 – 26.1                 2.2 – 3.3                 0.128
26.2 – 36.0                 3.3 – 4.6                 0.129
36.1 – 46.5                 4.6 – 6.0                 0.130
46.6 – 57.1                 6.0 – 7.5                 0.131
57.2 – 67.9                 7.5 – 9.0                 0.132
68.0 – 78.8                 9.0 – 10.5               0.133
78.9 – 89.7               10.5 – 12.0               0.134
89.8 – 100.7             12.0 – 13.6               0.135

Also for calculating ABV changes when adding priming sugar for bottling

Quote

31. Calculation of ABV when priming sugar is added to beer
(Referred to in section 12)
If you add priming sugar at the maturation stage to promote a secondary fermentation and use the calculation method to ascertain the ABV of the finished beer, you will need to make calculations based on the steps outlined below.
A barrel contains 163.6 litres which comprises 161.6 litres of beer which had an OG of 1040 and 2 litres of added priming sugar with an OG of 1110. The final gravity of the mixture after secondary fermentation is 1010.

1.
Calculate the ABV of the fermented beer using the formula:
(OG – PG) x f = a% ABV
where:
OG is the original gravity of the beer

PG is the present gravity of the beer (that is, final gravity after all fermentation has ceased)

a is the alcoholic strength, and

f is the factor connecting the change of gravity to alcoholic strength(1040 –1010) x 0.129 = 3.8

2.
Calculate the ABV of the priming sugar using the same formula:
(1110 – 1010) x 0.135 = 13.5

3.
Calculate the ABV of the contents of the container using the formula:
((Vb x Sb) + (Vp x Sp))/VM = Sm


Where:

Vb = volume of beer in the container

Sb = ABV of the beer in the container

Vp = volume of priming’s in the container

Sp = ABV of priming’s in the container

Sm = ABV of the container contents, and

Vm = volume of container contents.

((161.6 x 3.8) + (2.0 x 13.5)) / 63.6 = 3.9

Sorry for the long first post!

All info from http://customs.hmrc.gov.uk/channelsPortalWebApp/downloadFile?contentID=HMCE_CL_000232

Cheers
Facebook: www.facebook.com/TheCronxBrewery
Twitter: @TheCronxBrewery

Offline DemonBrew

  • BeerSmith New Brewer
  • *
  • Posts: 2
  • DemonBrew
    • DemonBrew
Re: Calculation of ABV
« Reply #1 on: May 06, 2012, 07:23:33 AM »
Hi Cronx,

Have been wanting that option too!
What I do is double check with Beer Engine (practicalbrewing.co.uk) which does use HMRC equations and/or do it manually. BeerSmith could be perfect for pro brewers in the UK with this option.

Have a 5BBL near Edinburgh.

I posted on one of the forum's about this last year but got no response.

Cheers,
DemonBrew

Offline TheCronx

  • BeerSmith Apprentice Brewer
  • **
  • Posts: 5
  • The Cronx Brewery
    • The Cronx
Re: Calculation of ABV
« Reply #2 on: October 03, 2012, 03:39:53 AM »
Any chance of this happening? It is a bit of a pain switching between BeerSmith and Beer Engine (As DemonBrew suggested) when planning recipes, especially as we use it so often and need to constantly do ABV calculations for HMRC...
Facebook: www.facebook.com/TheCronxBrewery
Twitter: @TheCronxBrewery

Offline dwhyte14

  • BeerSmith Brewer
  • ***
  • Posts: 26
Re: Calculation of ABV
« Reply #3 on: January 09, 2013, 09:34:59 AM »
Yeah, need this v soon Brad  ;)

Keep posting Cronx, we might get it!


Offline TheCronx

  • BeerSmith Apprentice Brewer
  • **
  • Posts: 5
  • The Cronx Brewery
    • The Cronx
Re: Calculation of ABV
« Reply #4 on: January 17, 2013, 03:18:14 AM »
Yeah, need this v soon Brad  ;)

Keep posting Cronx, we might get it!

We can hope!

Been up and running for 6 months now, this would still be very handy for us! About to start bottling too so a priming ABV calculator would be much appreciated.
Facebook: www.facebook.com/TheCronxBrewery
Twitter: @TheCronxBrewery

Offline dwhyte14

  • BeerSmith Brewer
  • ***
  • Posts: 26
Re: Calculation of ABV
« Reply #5 on: January 21, 2013, 03:36:17 AM »
Have reposted in the suggestions part of forum. Will see what happens!

I've just bottled a few casks and just waiting for labels.

Bottling by hand?

Offline 3SB

  • BeerSmith New Brewer
  • *
  • Posts: 1
  • BeerSmith 2 Rocks!
Re: Calculation of ABV
« Reply #6 on: February 16, 2015, 11:20:17 AM »
Awesome thanks for the help.