The actual title of “The World’s Drunkest Programmer” may never be given out in any official capacity, but thanks to the Arduino prototyping platform, the availability of cheap kegerators and the wanton need for frosty refreshment buried deep within the programmer psyche, any team with about US$1,000 can figure out who is the drunkest programmer in the office. The title, of course, can be given out through data analysis.

When Felix Sargent and Chris Gilmer, software engineers at Rackspace, were informed by human resources that the company was moving its San Francisco offices into the trendy district south of Market Street, the pair decided they needed to build something special for the forthcoming office opening party.

That something special was a homebrew Kegbot. The term comes from, where this open-source project’s creator, Mike Wakerly, has stationed the project’s information. Its specifications and software can be used to turn an ordinary kegerator (basically, a mini-fridge with a tap coming out of the top) into a tablet-driven, RFID-using, beer-dispensing open-source project.

But while Sargent and Gilmer were inspired by Kegbot, they ended up building their entire project from scratch. Under normal circumstances, such a whole-hog rewrite would seem nonsensical, but the pair had a very good reason for trying it on their own: They could get everyone involved.

Kegbot“We wrote it all. We decided to get everybody to chip in,” said Gilmer. “A couple of people worked on the Arduino code, and I wrote the Python code to talk to the Arduino. We have great developers and front-end designers, and they wrote the interface for the computer. We did a computer connected via USB to the Arduino. The Arduino was polling the machine, and we took updates from the machine and saved them in a database. You could log in and see what was going on.”

Just what was going on? The software allowed users to view the keg’s temperature, pressure and fullness level based on the amount consumed. But most importantly, it could track who drank what.

“We issued everyone an RFID card,” said Gilmer. “We bought several hundred—and some subsection of those we hand-painted—one for every employee in the office.” In theory, each user’s exact consumption, to the liter, would be measured and recorded.
Kegerator mishaps
But, of course, there was beer involved, and the project encountered a major snag. “Someone at the party must have gotten drunk and left their card there,” said Gilmer. “The RFID had the property of making the kegerator light up, so at that point the flow meters were broken anyway, so we decided every swipe was a glass of beer. So this one poor person, a guest, looked like they had 20 liters of beer.”

And in that statement, he hints at another major problem the team ran into: The flow meters, essentially a small propeller in a piece of tubing, with magnets in each propeller end and a sensor coming out of the top of the tube, were a constant problem for the team.