• Welcome to the new forum! We upgraded our forum software with a host of new boards, capabilities and features. It is also more secure.
    Jump in and join the conversation! You can learn more about the upgrade and new features here.

UK Government ABV%

Add UK Duty Tax Calculator into Beesmith 2

  • Yes

    Votes: 1 100.0%
  • No

    Votes: 0 0.0%
  • N/A

    Votes: 0 0.0%

  • Total voters
    1

dwhyte14

Brewer
Joined
Dec 9, 2010
Messages
26
Reaction score
0
Being in the UK, it would be really helpful if BS uses the formula as given by the UK government beer duty notice for ABV calculation.

E.g. OG 1048 ferments down to 1010, this gives an ABV in BS2 as 5%.
However, the UK customs formula would give 4.9%.
Not a lot of difference but when paying duty it can mount up.

I have posted this before so sorry if duplicating but as some of us use BS for professional brewing, this is an issue.

Have sent link to calculations on HMRC website to Brad I think and there is a post by Cronx in the pro brewers section with details.

Thanks
 
I can only re-iterate how useful it would be for us UK brewers if we had a chance to opt-in to the "UK HM Revenue & Customs" way of calculating ABV in BeerSmith2. It is a dead simple algorithm, that only uses OG, FG (they call FG "PG", for Present Gravity, but they mean the same as FG) and a conversion factor from a lookup table.

(OG - FG) × Factor = %ABV (truncated to 1 decimal).

(OG - FG)Factor
Up to 6.9 0.125
7.0 - 10.4 0.126
10.5 - 17.2 0.127
17.3 - 26.1 0.128
26.2 - 36.0 0.129
36.1 - 46.5 0.130
46.6 - 57.1 0.131
57.2 - 67.9 0.132
68.0 - 78.8 0.133
78.9 - 89.7 0.134
89.8 - 100.7 0.135
   
There is no guidance on how to handle values >100.7 but I interpret the last factor as "89.8 and up".

Example:
OG = 1057
FG = 1018

The difference between 1057-1018 is 39.

As 39 is within the 36.1 - 46.5 range in the lookup table, factor 0.130 should be used.

(1057-1018) x 0.130 =
39 x 0.130 = 5.07
5.07 is truncated to 5.0 (Not rounded using common rounding which would give 5.1)

Hence the ABV calculated in the UK Revenue & Customs suggested way results in 5.0%. The BeerSmith2 default algorithm would calculate the Est ABV to 5.1%. If this UK HM Revenue & Customs algorithm could be implemented as an opt-in setting (Advanced Settings) it would make it much easier for us in the UK who need to calculate ABV the HMRC way.

Thanks in advance on behalf of UK professional brewers!
/anders
 
OneGlobe said:
I can only re-iterate how useful it would be for us UK brewers if we had a chance to opt-in to the "UK HM Revenue & Customs" way of calculating ABV in BeerSmith2. It is a dead simple algorithm, that only uses OG, FG (they call FG "PG", for Present Gravity, but they mean the same as FG) and a conversion factor from a lookup table.

(OG - FG) × Factor = %ABV (truncated to 1 decimal).

(OG - FG)Factor
Up to 6.9 0.125
7.0 - 10.4 0.126
10.5 - 17.2 0.127
17.3 - 26.1 0.128
26.2 - 36.0 0.129
36.1 - 46.5 0.130
46.6 - 57.1 0.131
57.2 - 67.9 0.132
68.0 - 78.8 0.133
78.9 - 89.7 0.134
89.8 - 100.7 0.135
   
There is no guidance on how to handle values >100.7 but I interpret the last factor as "89.8 and up".

Example:
OG = 1057
FG = 1018

The difference between 1057-1018 is 39.

As 39 is within the 36.1 - 46.5 range in the lookup table, factor 0.130 should be used.

(1057-1018) x 0.130 =
39 x 0.130 = 5.07
5.07 is truncated to 5.0 (Not rounded using common rounding which would give 5.1)

Hence the ABV calculated in the UK Revenue & Customs suggested way results in 5.0%. The BeerSmith2 default algorithm would calculate the Est ABV to 5.1%. If this UK HM Revenue & Customs algorithm could be implemented as an opt-in setting (Advanced Settings) it would make it much easier for us in the UK who need to calculate ABV the HMRC way.

Thanks in advance on behalf of UK professional brewers!
/anders

Yep, any word Brad?
 
Back
Top