Thursday, 5 September 2024

Analysing Cairnes brewing records

The Cairnes records are ones where I'm glad that I have a long set. Both in terms of records spanning a long period and lots of photos for each year.

An unusual feature of the records is that there are pre-printed headers for specific ingredients. Which was probably really handy when the records were first used. Only problem is, that they had multiple books printed up and, due to the horizontal format, each book lasted for many years. Sometimes more than ten years. And, inevitably, the ingredients used changed over time. Making some of the header irrelevant. With the columns used for different ingredients.

Now, sometimes, the printed header was crossed out and the correct ingredient pencilled in. But only occasionally. Which is why it's handy to have lots of photos. Worst is the column headed "Pat. Malt". It's still there on the forms in the 1940s: several decades after they switched to roast barley.

There's only really one way to tell which ingredients were being used. That's by looking at the monthly totals. Which indicate how much of each ingredient was used in the previous month and the year to date. That's the way I know Cairnes were definitely using roast barley and not patent malt.

Also pre-printed are the headings for the type of beer. Which also ended up being incorrect through time. And where, again, they would sometimes (but not always) cross out a beer type and scribble in another.

"X" crossed out and "2d" pencilled in.

It's so much fun.

6 comments:

Anonymous said...

2 d, 2 pence ale?
Oscar

Anonymous said...

This is a wonderful example of how some seemingly minor, sensible decisions about formatting data can come back to haunt people. A lot of database designers would be smart to understand this, but of course they're in a rush to define the specs for a projects, meet a delivery date target, and move on. Meanwhile the clients who will be using the database for a decade or more don't understand the issues and don't think to object.

Ron Pattinson said...

Oscar,

yes, 2 old pence.

Anonymous said...

Thanks assume 2 pence a pint so two pints are 4 pence.
Oscar

Rob Sterowski said...

Interesting that they had both E. I. and I.P. What was the difference?

Ron Pattinson said...

The strength. EI was 1053, IP was 1063. In 1898, that was. IP was dropped soon after.