DrinkSheet - Revision history

DrinkBoy: /* ABV Calculator */

2022-04-26T19:53:26Z

ABV Calculator

← Older revision		Revision as of 11:53, 26 April 2022
Line 29:		Line 29:
	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.		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.

	Note: The ABV calculation doesn't take into account the water that will be added to the drink by the ice which is either used to make the drink or added to the glass to keep it cool. This means that the true ABV of the drink will be slightly less then what is listed.		Note: The ABV calculation doesn't take into account the water that will be added to the drink by the ice which is either used to make the drink or added to the glass to keep it cool. This means that the true ABV of the drink will be slightly less then what is listed. If you need an ABV that includes the water from dilution, then you will need to determine how much water will be released into the drink, and then include that as an "ingredient".

	===Recipe Details===		===Recipe Details===

DrinkBoy: /* Scaling */

2022-04-26T19:50:25Z

Scaling

← Older revision		Revision as of 11:50, 26 April 2022
Line 21:		Line 21:

	===Scaling===		===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. Not only will this make it easier to scale down a "for six people" recipe down to a single serving (or vice versa), but you can also use it to convert a recipe in ounces, to one that uses ml instead (just set the ~~scaling~~ to "1", and change the measurement units to "ml")		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. Not only will this make it easier to scale down a "for six people" recipe down to a single serving (or vice versa), but you can also use it to convert a recipe in ounces, to one that uses ml instead (just set the "serves" to "1", and change the measurement units to "ml")

	===Batching===		===Batching===

DrinkBoy: /* Scaling */

2022-04-26T19:49:51Z

Scaling

← Older revision		Revision as of 11:49, 26 April 2022
Line 21:		Line 21:

	===Scaling===		===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.		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. Not only will this make it easier to scale down a "for six people" recipe down to a single serving (or vice versa), but you can also use it to convert a recipe in ounces, to one that uses ml instead (just set the scaling to "1", and change the measurement units to "ml")

	===Batching===		===Batching===

DrinkBoy at 23:37, 25 April 2022

2022-04-25T23:37:25Z

← Older revision		Revision as of 15:37, 25 April 2022
Line 1:		Line 1:
	Current Version is "Beta 1.0" (~~April~~, 2022)		Current Version is "Beta 1.0" (May, 2022)

	DrinkSheet is a downloadable spreadsheet for Microsoft Excel that is intended to provide some useful calculations based on the recipes that you enter. It is being provided by the Chanticleer Society along with its author (Robert Hess), to help not only cocktail enthusiasts, but also professional bars and bartenders.		DrinkSheet is a downloadable spreadsheet for Microsoft Excel that is intended to provide some useful calculations based on the recipes that you enter. It is being provided by the Chanticleer Society along with its author (Robert Hess), to help not only cocktail enthusiasts, but also professional bars and bartenders.

DrinkBoy at 23:35, 25 April 2022

2022-04-25T23:35:47Z

← Older revision		Revision as of 15:35, 25 April 2022
Line 1:		Line 1:
	Current Version is "Beta 1.0" (April, 2022)		Current Version is "Beta 1.0" (April, 2022)

	DrinkSheet is a downloadable spreadsheet for Microsoft Excel that is intended to provide some useful calculations based on the recipes that you enter. It is being provided by the Chanticleer Society along with its author (Robert ~~"DrinkBoy"~~ Hess), to help not only cocktail enthusiasts, but also professional bars and bartenders.		DrinkSheet is a downloadable spreadsheet for Microsoft Excel that is intended to provide some useful calculations based on the recipes that you enter. It is being provided by the Chanticleer Society along with its author (Robert Hess), to help not only cocktail enthusiasts, but also professional bars and bartenders.

	[[File:DrinkSheet_Old_Fashioned.jpg\|900px\|center]]		[[File:DrinkSheet_Old_Fashioned.jpg\|900px\|center]]

DrinkBoy: /* Costing */

2022-04-25T23:34:36Z

Costing

← Older revision		Revision as of 15:34, 25 April 2022
Line 18:		Line 18:

	===Costing===		===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.		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 20% to 25% '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===		===Scaling===

DrinkBoy: /* Recipe Entry */

2022-04-22T17:06:17Z

Recipe Entry

← Older revision		Revision as of 09:06, 22 April 2022
Line 15:		Line 15:

	===Recipe Entry===		===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.		After creating a new sheet (by making a copy of the prepared "Recipe Template" sheet) 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===		===Costing===

DrinkBoy: /* Overview */

2022-04-22T17:04:40Z

Overview

← Older revision		Revision as of 09:04, 22 April 2022
Line 8:		Line 8:

	The spreadsheet consists of several different sheets:		The spreadsheet consists of several different sheets:
	* Instructions: brief details on how to use this spreadsheet. Excel isn't a "document" focused tool, so the instructions are focused on being a "one pager" on how to use the app. This page on the Chanticleer Society wiki should be considered the definitive documentation for the spreadsheet.		* '''Instructions''': brief details on how to use this spreadsheet. Excel isn't a "document" focused tool, so the instructions are focused on being a "one pager" on how to use the app. This page on the Chanticleer Society wiki should be considered the definitive documentation for the spreadsheet.
	* Volumes: a sheet that provides details on the different "volume" measurements you can use.		* '''Volumes''': a sheet that provides details on the different "volume" measurements you can use.
	* Products: a sheet that provides details on the "ingredients" that can be used in your recipes. This list can, and should, be expanded to reflect not only the ingredients you may want to use, but the details about those ingredients as well (specifically cost and abv).		* '''Products''': a sheet that provides details on the "ingredients" that can be used in your recipes. This list can, and should, be expanded to reflect not only the ingredients you may want to use, but the details about those ingredients as well (specifically cost and abv).
	* Recipe Template: A "template" recipe form that you copy to a new sheet in order to enter new recipes.		* '''Recipe Template''': A "template" recipe form that you copy to a new sheet in order to enter new recipes.
	* ...plus several prepopulated recipes you can use for examples		* ...plus several prepopulated recipes you can use for examples

DrinkBoy at 17:03, 22 April 2022

2022-04-22T17:03:56Z

← Older revision		Revision as of 09:03, 22 April 2022
Line 1:		Line 1:
	Current Version is "Beta 1.0" (April, 2022)		Current Version is "Beta 1.0" (April, 2022)

	DrinkSheet is a downloadable spreadsheet for Microsoft Excel that ~~provides~~ some useful calculations based on the recipes that you enter. It is being provided by the Chanticleer Society along with its author (Robert "DrinkBoy" Hess), to help not only cocktail enthusiasts, but also professional bars and bartenders~~. Hopefully you will find it useful~~.		DrinkSheet is a downloadable spreadsheet for Microsoft Excel that is intended to provide some useful calculations based on the recipes that you enter. It is being provided by the Chanticleer Society along with its author (Robert "DrinkBoy" Hess), to help not only cocktail enthusiasts, but also professional bars and bartenders.

	[[File:DrinkSheet_Old_Fashioned.jpg\|900px\|center]]		[[File:DrinkSheet_Old_Fashioned.jpg\|900px\|center]]
Line 8:		Line 8:

	The spreadsheet consists of several different sheets:		The spreadsheet consists of several different sheets:
			* Instructions: brief details on how to use this spreadsheet. Excel isn't a "document" focused tool, so the instructions are focused on being a "one pager" on how to use the app. This page on the Chanticleer Society wiki should be considered the definitive documentation for the spreadsheet.
	* Volumes: a sheet that provides details on the different "volume" measurements you can use.		* Volumes: a sheet that provides details on the different "volume" measurements you can use.
	* Products: a sheet that provides details on the "ingredients" that can be used in your recipes. This list can, and should, be expanded to reflect not only the ingredients you may want to use, but the details about those ingredients as well (specifically cost and abv).		* Products: a sheet that provides details on the "ingredients" that can be used in your recipes. This list can, and should, be expanded to reflect not only the ingredients you may want to use, but the details about those ingredients as well (specifically cost and abv).

DrinkBoy at 16:59, 22 April 2022

2022-04-22T16:59:39Z

← Older revision		Revision as of 08:59, 22 April 2022
Line 1:		Line 1:
	:Current Version is "Beta 1.0" (April, 2022)		Current Version is "Beta 1.0" (April, 2022)

	DrinkSheet is a downloadable spreadsheet for Microsoft Excel that provides some useful calculations based on the recipes that you enter. It is being provided by the Chanticleer Society along with its author (Robert "DrinkBoy" Hess), to help not only cocktail enthusiasts, but also professional bars and bartenders. Hopefully you will find it useful.		DrinkSheet is a downloadable spreadsheet for Microsoft Excel that provides some useful calculations based on the recipes that you enter. It is being provided by the Chanticleer Society along with its author (Robert "DrinkBoy" Hess), to help not only cocktail enthusiasts, but also professional bars and bartenders. Hopefully you will find it useful.