I built my own under-counter kegerator for the home bar. I plan to build a keezer for the garage this summer. I’ll probably get a bit fancier than this though. I’ll also build it into my work bench to save space in the garage.
I buy a lot of supplies from Northern Brewer. They’re good.
The BreweryDB.com site has received a big update, along with the API. This looks really good. Perhaps the best company name yet: Pint Labs.
It looks beautiful and could rival BeerAdvocate.com for beer nerds. Especially since it has an API for apps.
Last week I attended a special lecture by the owner of Dogfish Head brewing, Sam Calagione. The talk was titled “Man and Microbe: Exotic Ales Since the Birth of Civilization.”
The lecture was more entertaining than it was scientific, but it was still an hour well spent. One of the most insightful things he said, I think applies to anyone that is a great leader. When asked about how an English major became a successful businessman in a moderately scientific industry he responded1
“A Business plan is the biggest work of fiction man has ever created. Our job as a business person is to get people mobilized around that fiction. “
Much of the lecture focused on breaking the definition of “beer” as defined by the German purity law Reinheitsgebot. It was an inspired discussion of how letting someone else define us kills innovation are stops progress. Sam is a passionate and unapologetic experimentalist. He is willing to put literally anything in a beer for the sake of pushing the boundaries of his passion and never listens to conventional wisdom. As user of Apple products, that sounds very familiar.
I’m paraphrasing since I didn’t record the talk ↩
While I usually stick to Mac stuff around here, sometimes I slip in little nuggets that I just find interesting. One of my hobbies is home brewing beer. Perhaps it’s my background as a chemist. Whatever the reason, I enjoy researching, brewing and drinking beer. So, if anyone has an interest in the science of brewing or the history of beer, I’ve got some good reads for you.[1]
Bock (Classic Beer Style Series, vol. 9) or just about any volume in the series
Ambitious Brew: History of Beer in America
Brewing Up a Business: Adventures in Entrepreneurship from the Founder of Dogfish Head Craft Brewery
These are better than their titles would imply. Particularly Ambitious Brew which clarified for me why American beer strayed so far from it’s German roots.
Oh, and I’m drinking a Peeper Ale from Maine Beer Company right now. It’s good.
Not affiliate links, because I’m just too lazy. ↩
My previous look at a beer inventory system focused on Bento. In this overview, I’ll explain my experiences while using Apple’s Numbers for the same purpose.
Numbers already stands out as the best general spreadsheet application on any platform. But this is not a Numbers review. How does it work as an inventory application?
Not surprisingly, it works like a spreadsheet. That’s not necessarily bad. The Numbers interface is nice. Entering data is easy and getting it back out is as simple as can be. Importantly, exporting to a CSV file means the data is completely portable.
Unfortunately, images don’t work so well. If I want to include pictures of the bottle, then I can not export from Numbers to CSV. Exporting removes all all images (as expected). If I were to rely on Numbers for my inventory, I would be sure to leave out images.
I’ve delayed this post waiting for an iWork update from Apple. I was waiting for iCloud to come to the Mac in some meaningful way. That has not happened which means iWork has no automatic sync between the Mac and iOS. Data is transferred in the awkward yet traditional way of export and email.
Exporting is straight forward. In fact, if you have a OmniOutliner on the Mac there is even a trick to export from Numbers into OmniOutliner. Simply copy your numbers table and paste it as plain text into an editor like BBEdit. Save as a “.txt” file. You can now drag that file onto OmniOutliner to get a rough version of your spreadsheet except as an outline.
Beyond that, Numbers provides several other options for exporting. On the iPad you can email as a Numbers, PDF or Excel file. But Numbers brings some super-powers to the game if you want to share your content with someone else. Simply share a document via iWork.com (remember that?) and the app automatically generates an email to send to anyone that you want to share with. This is a special email though, because it also registers the recipient as a viewer of the content. That means, even though the content is on the web, it’s not publicly available. Only specified recipients can view it.
The content looks great on iWork.com too. Here’s a screenshot of the web page. Just perfect.
Sort and search is great in Numbers. Searching is fast and highlights the hit term with a visual queue. There’s also a list of all hits so that I can scroll through hits easily.
Beyond standard sorting (sorting by column headings) Numbers provides a couple of other options for categorizing. The categories can be combined with filtering to create a lean and condensed version focusing on a few items while also providing some context. For example in this screen shot I’m looking at all stouts with grouping by breweries.
Another nice feature in Numbers is the wide range of column data types. The options are comparable to Bento. It’s flexible and easy to setup.
It’s also easy to setup a custom view into a data table with logical formatting. For example, highlight cells with a value above or below a specific number or date. I use this to identify entries that are missing data or that have a rating above 3. It’s a nice visual queue and very easy to setup. It’s also a feature that really sets a spreadsheet apart from most other options.
The iPad version of Numbers is very approachable. There’s little setup and the app is full featured. I did not experience any issues when transferring a Mac version of the inventory to the iPad. Equations seem to work but some formatting was lost. It wasn’t an exact duplicate of the Mac version but it was good.
The iPad version provides several options for sharing, including email and upload to iWork. I held off on this post, waiting for iCloud sync to be announced, but sadly there still is not a seamless mechanism for working in Numbers across multiple platforms. In this regard, Bento still wins with WiFi syncing.
Numbers on iPad excel in one huge way over Numbers for the Mac: The input form. Any iPad spreadsheet can be accessed through a simple and attractive form. It makes data access far easier than tapping on small spreadsheet cells. The form view is how Numbers should be used. I only use the spreadsheet view for setup and to get a 30,000 foot view of the data. All data entry and browsing happens through the form view.
Forget trying to use Numbers as a spreadsheet alternative on an iPhone. Unless you only have a single column in your spreadsheet it will frustrate you to the point that you would rather use a ledger book.
However, the form view on the iPhone is great. It feels natural and it’s easy to add records. Unfortunately search only works in the spreadsheet mode which is minuscule.
I have not used iWork.com much but I have to say, this is where Numbers succeeds. I can share a private link with anyone through email. That gives them the ability to view my entire inventory in a web browser. I can also make the list public. It’s not great for group editing, but it’s still nice. Sure Google Docs could do this too but it does not come with an elegant iOS app. iWork does give the recipient the ability to download and use the list for themselves.
Bento still wins for easy entry and data access on iOS. The lack of support to take a snapshot and add it to an entry makes Numbers less than ideal for me. I really like to capture the label of an interesting beer so I can show it to a supplier. It makes it easier to find in my collection too. Images are also stripped out
Next up in this series is OmniOutliner. Believe it or not OmniOutliner can be used for more than an outline.
One of the things I love about the Micro- and Nano- breweries is that they have a tendency to be enthusiastically generous. Around Denver, breweries are known to share ingredients with “competitors” in need and many share what would seem to be precious recipes.
For example, Stone Brewing is sharing their recipe for their latest Vertical Epic with Anaheim Chiles and Cinnamon. It’s way better than it sounds. I don’t know of many more industries that are that generous while also making innovative things. Wait, yes I do.
My previous look at a beer inventory system focused on Bento (see this link for the introduction). In this overview, I’ll explain my experiences while using Apple’s Numbers for the same purpose.
Numbers already stands out as the best general spreadsheet application on any platform. But this is not a Numbers review. How does it work as an inventory application?
Not surprisingly, it works like a spreadsheet. That’s not necessarily bad. The Numbers interface is nice. Entering data is easy and getting it back out is as simple as can be. Importantly, exporting to a CSV file means the data is completely portable.
Unfortunately, images don’t work so well. If I want to include pictures of the bottle, then I can not export from Numbers to CSV. Exporting removes all all images (as expected). If I were to rely on Numbers for my inventory, I would be sure to leave out images.
Exporting is straight forward. In fact, if you have a OmniOutliner on the Mac there is even a trick to export from Numbers into OmniOutliner. Simply copy your numbers table and paste it as plain text into an editor like BBEdit. Save as a “.txt” file. You can now drag that file onto OmniOutliner to get a rough version of your spreadsheet except as an outline.
Beyond that, Numbers provides several other options for exporting. On the iPad you can email as a Numbers, PDF or Excel file. But Numbers brings some super-powers to the game if you want to share your content with someone else. Simply share a document via iWork.com (remember that?) and the app automatically generates an email to send to anyone that you want to share with. This is a special email though, because it also registers the recipient as a viewer of the content. That means, even though the content is on the web, it’s not publicly available. Only specified recipients can view it.
The content looks great on iWork.com too. Here’s a screenshot of the web page. Just perfect.
Sort and search is great in Numbers. Searching is fast and highlights the hit term with a visual queue. There’s also a list of all hits so that I can scroll through hits easily.
Beyond standard sorting (sorting by column headings) Numbers provides a couple of other options for categorizing. The categories can be combined with filtering to create a lean and condensed version focusing on a few items while also providing some context. For example in this screen shot I’m looking at all stouts with grouping by breweries.
Another nice feature in Numbers is the wide range of column data types. The options are comparable to Bento. It’s flexible and easy to setup.
It’s also easy to setup a custom view into a data table with logical formatting. For example, highlight cells with a value above or below a specific number or date. I use this to identify entries that are missing data or that have a rating above 3. It’s a nice visual queue and very easy to setup. It’s also a feature that really sets a spreadsheet apart from most other options.
The iPad version of Numbers is very approachable. There’s little setup and the app is full featured. I did not experience any issues when transferring a Mac version of the inventory to the iPad. Equations seem to work but some formatting was lost. It wasn’t a exact duplicate of the Mac version but it was good.
The iPad version provides several options for sharing, including email and upload to iWork. I held off on this post, waiting for iCloud sync to be announced, but sadly there still is not a seamless mechanism for working in Numbers across multiple platforms. In this regard, Bento still wins with WiFi syncing.
Numbers on iPad excel in one huge way over Numbers for the Mac: The input form. Any iPad spreadsheet can be accessed through a simple and attractive form. It makes data access far easier than tapping on small spreadsheet cells. The form view is how Numbers should be used. I only use the spreadsheet view for setup and to get a 30,000 foot view of the data. All data entry and browsing happens through the form view.
Forget trying to use Numbers as a spreadsheet alternative on an iPhone. Unless you only have a single column in your spreadsheet it will frustrate you to the point that you would rather use a ledger book. However, the form view on the iPhone is great. It feels natural and it’s easy to add records. Unfortunately search only works in the spreadsheet mode.
I have not used iWork.com much but I have to say, this is where Numbers succeeds. I can share a private link with anyone through email. That gives them the ability to view my entire inventory in a web browser. I can also make the list public. It’s not great for group editing, but it’s still nice. Sure Google Docs could do this too but it does not come with an elegant iOS app. It does give the recipient the ability to download and use the list for themselves.
Bento still wins for easy entry and data access. The lack of support to take a snapshot and add it to an entry makes Numbers less than ideal for me. I really like to capture the label of an interesting beer. It makes it easier to find in my collection. Images are also good when talking with a supplier. I can show them the label and generally they will know what I’m looking for.
Next up in this series is OmniOutliner. Believe it or not OmniOutliner can be used for more than an outline.
