Poll

Add UK Duty Tax Calculator into Beesmith 2

Yes
1 (100%)
No
0 (0%)
N/A
0 (0%)

Total Members Voted: 1

Author Topic: UK Government ABV%  (Read 4534 times)

Offline dwhyte14

  • BeerSmith Brewer
  • ***
  • Posts: 26
UK Government ABV%
« on: January 21, 2013, 03:34:24 AM »
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

Offline OneGlobe

  • BeerSmith New Brewer
  • *
  • Posts: 1
  • BeerSmith 2 Rocks!
Re: UK Government ABV%
« Reply #1 on: September 12, 2016, 04:12:35 AM »
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

Offline dwhyte14

  • BeerSmith Brewer
  • ***
  • Posts: 26
Re: UK Government ABV%
« Reply #2 on: February 28, 2017, 02:44:06 PM »
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?