DrinkSheet

From Chanticleer Society
Revision as of 16:08, 11 April 2022 by DrinkBoy (talk | contribs)

DrinkSheet is a specially created spreadsheet for Microsoft Excel that provides some useful calculations based on the recipes that you enter.

DrinkSheet provides:

  • Costing Details
  • Recipe Scaling
  • Batching Details
  • ABV Calculation


DrinkSheet Old Fashioned.jpg

Recipe Entry

You easily enter the specifics about your recipe using virtually any type of volumetric measurement you want. If a particular measurement unit isn't available, you can update the spreadsheet easily to use it.

Costing

Handy for commercial bartenders, the spreadsheet allows you to maintain a list of product costs, and if all of the products your recipe uses have been properly recorded, the costing pane will show you the cost of each ingredient, as well as the overall cost of the drink to make. You can also provide a target price, and it will tell you what the percentage of food cost is for the drink (most bars will typically use a 21% food cost which will allow the rest of the cost to account for labor, rent, etc.). You can also provide a target percentage food cost, and it will let you know what to charge for the drink.

Scaling

Handy for home mixologists, once a recipe has been entered, you can scale the recipe up (or down) to suit your needs. You can change the measurement units to any that will work best for you.

Batching

Handy for making the recipe in large batches, you can indicate how much you want to make (such as "4 gallons"), and the recipe will be properly scaled to that volume. It will tell you how many drinks you can make, as well as how much of the "mix" to use per drink. You can not only change the measurement units to anything you want (ie, instead of "ounces", you can use "cups"), but you can also provide a "secondary" measure. This means that instead of "14 5/8 cups", you can split it into "14 cups plus 5 ounces".

ABV Calculator

With more and more attention these days being paid to monitoring the amount of alcohol in a drink, as long as the ABV details for each ingredient have been properly provided, this pane will show you the overall "ABV %" for the drink, but more importantly it will show you the actual amount of pure alcohol the drink contains, as well as what the "DrinkRate" is. The DrinkRate provides an estimate for how many hours it will take the average individual to fully metabolize the alcohol in this drink.