Caffeine level easy comparison in Excel
How to compare caffeine levels in coffee, tea, soda and other drinks from an Excel spreadsheet.
The Guardian’s Datablog has interesting analysis of caffeine levels in different foods.
Sounds boring until you read that:
- reduced sugar colas have almost double the caffeine of a regular, sugared, cola.
- 1 cup of coffee can have as much caffeine as 2 cups of tea (depending on the brew time)
- a single Red Bull can has less caffeine
They’ve published the original US FDA data in a Google Docs spreadsheet which can be exported to Excel (File | Download | Microsoft Excel)
In Excel you can format and chart the data as you’d like:
So grab a cup of coffee and Excel your heart out!
Quick stock price analysis and charts with Excel StockHistory()
Google Sheets gets 10 million cells, not enough to beat Excel
Fancy gridlines to make Excel look great or at least different.
Putting Health Data into Excel