Alcohol you later

Standings page
Tester's profile

Inspiration

As we all know, Zitec parties and also the team buildings outings are one of the memorable activities, so why not build something fun and useful for this kind of needs? Alcohol You Later allows you to measure in a fun way your breathing alcohol percentage, then provides you with standings and suggestions based on your current... condition.

What it does

Using the alcohol sensor mounted at the end of a blowing tube (vuvuzela), the alcohol data is measured, saved into the database and output into each tester's profile.

Based on the recorded data, various challenges are suggested, like:

you seem fine, have another beer
better start drinking some water
might try eating some food
why not stop drinking and go to sleep

How we built it

The alcohol sensor is connected to a raspberry PI module, using a digital-analog convertor. The measured data is transformed from digital to analog signal, then using a Python script, the MySQL database is populated with the measured values.

The web application (built with PHP, HTML, CSS, Js) takes the values from the DB and outputs various information:

personal tester stats
challenges the tester should undergo, based on the measured values
all testers standings
general stats dashboard

Challenges we ran into

Logistics

one of the sensors we wanted to use was not delivered in time.
digital-analog convertor missing, #kudos to https://chinamag.eu/ for the support on buying it in record time