Tabellab
Kitchen & Food at Home Advanced

Coffee & Tea Brewing Math: Brew Ratios, Extraction, Water Recipes & Cost per Cup

Dial in coffee and tea with brew ratios, extraction yield, espresso logs, dilution and water chemistry, and know what each cup really costs, with every cell checked as you go.

8 lessons 8 labs 2.1 h Certificate

One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.

About this course

This course follows a fictional home-coffee enthusiast through his brew bar in eight spreadsheet labs. You turn brew ratios into brew water and beverage weights and size a dose for any mug, calculate extraction yield from TDS readings and flag brews against a target box, and dial in espresso with ratios, flow rates and averages per grind setting. You dilute cold-brew concentrate and iced coffee with C1V1 = C2V2, mix brewing water from fictional mineral concentrates, plan tea leaf, steep times and water temperature, track roast dates and stock, and compare home and café cost per cup with a payback chart. Every cell is checked as you go.

Lessons

  1. Brew Ratios: Dose, Brew Water, Beverage Weight and Any Mug SizeLab14 min Pro
  2. Strength and Extraction Yield: TDS, the Target Box and Diluting a Strong BrewLab16 min Pro
  3. Espresso Dial-in: Brew Ratio, Flow Rate and Averages per Grind SettingLab16 min Pro
  4. Cold Brew and Iced Coffee: Concentrate Strength and Dilution with C₁V₁ = C₂V₂Lab15 min Pro
  5. Water Recipes: Mineral Concentrates, Hardness, Alkalinity and Blending to a TargetLab17 min Pro
  6. Tea Brewing: Leaf Ratios, Steep Times, Multiple Infusions and Mixing to TemperatureLab16 min Pro
  7. Bean Freshness and Stock: Roast Dates, Rest Windows and Bags to OrderLab16 min Pro
  8. Home vs Café: Cost per Cup, Machine Wear and Payback MonthsLab18 min Pro