I have always wished that beer bottles displayed pertinent information to the drinker: What's the ABV? What's the bitterness? OG/FG? It annoys me that commercial bottlers don't do that routinely.
So I started thinking about ways to show "back of the bottle" information. I like visual data. So I put together an Excel spreadsheet, and here's what I came up with. It's still a work in progress.
In addition to the name, style, and bottling date, it shows five taste parameters: OG, FG, bitterness ratio (BU/OG), ABV, and color, from typical "low" to typical "high." (For example, for OG, the range of OG across the top is 1.028 to 1.130) As an added bonus, it shows the expected range (the green bars) for the style. The color gradient comes off of an SRM chart, with 1 on the bottom (pale yellow) and 40 on the top (black).
I like that it shows the beer compared with both its intended style and in comparison to other beers in general.
Here's my label for a robust porter I just bottled: OG and FG are nominal for a robust porter, ABV on the low end, and bitterness below the band for a robust porter (just the way I like it ) It's designed to fit and Avery 5440 1.5" x 3" label.
So I started thinking about ways to show "back of the bottle" information. I like visual data. So I put together an Excel spreadsheet, and here's what I came up with. It's still a work in progress.
In addition to the name, style, and bottling date, it shows five taste parameters: OG, FG, bitterness ratio (BU/OG), ABV, and color, from typical "low" to typical "high." (For example, for OG, the range of OG across the top is 1.028 to 1.130) As an added bonus, it shows the expected range (the green bars) for the style. The color gradient comes off of an SRM chart, with 1 on the bottom (pale yellow) and 40 on the top (black).
I like that it shows the beer compared with both its intended style and in comparison to other beers in general.
Here's my label for a robust porter I just bottled: OG and FG are nominal for a robust porter, ABV on the low end, and bitterness below the band for a robust porter (just the way I like it ) It's designed to fit and Avery 5440 1.5" x 3" label.
Last edited: