Background work

I finally bit the bullet yesterday. Adding an extra column to my main beer gravity spreadsheet. 

I'd been planning on doing it for a couple of years. And had started using a new format table for any gravities I harvest. But it was getting out of hand. It was over 2,000 lines. And when I wanted to look up beers from a specific brewery, I had to search in both tables. Time to merge the two.

It itself, that wasn't particularly difficult. Just add the column to the main table and tack the entries from the temporary table on the end. Except, most of the entries now had a blank column. Which I'll have to add. Quite a palaver, in a table of 25,000 entries.

I started the work yesterday. And have completed maybe 25%. It's dull, tedious work. But it will be worth it, when I'm done. In case you're wondering, the column is the town where the brewery is located.

This work doesn't create any direct product. It does, however, extremely fucking handy when I am writing stuff. So is well worth it, in the long run.

While I was fiddling with the tables, I noticed that I had some analyses of Venezuelan beers. Courtesy of Heineken. Enjoy.

Venezuelan beers in 1950
Brewer	town	Beer	package	OG	FG	ABV	App. Atten-uation	colour
Cerveceria de Caracas	Caracas	Pilsener	bottled	1049.7	1005.9	5.71	88.07%	0.32
Cerveceria de Caracas	Caracas	Pilsener	can	1047.9	1012.5	4.56	74.01%	0.28
Cerveceria de Marquetia		Pilsener	bottled	1052.2	1011.2	5.13	78.56%	0.52
Cerveceria Regional Maracaibo	Maracaibo	Pilsener	draught	1032.0	1008.2	2.99	74.45%	0.32
Cervecerias Unidos		Pilsener	draught	1047.2	1014.5	4.20	69.36%	0.52
Cerveza Union		Pilsener	can	1046.0	1011.6	4.45	74.88%	0.52
Polar		Pilsener	bottled	1053.0	1010.6	5.45	80.05%	0.42
Source:
Rapporten van laboratoriumonderzoeken naar producten van Heinekenbrouwerijen in binnen- en buitenland en naar producten van andere brouwerijen held at the Amsterdamse Stadsarchief, document number 834 - 1794.