| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | |||||||||||||||
2 | Single Drink Recipe | Instructions: | |||||||||||||
3 | 2 Ingredient Batch | Ingredient: | ml | % of Batch | 1. Copy needed Cells onto "Your Drinks" Tab | ||||||||||
4 | Vodka | 45 | 50.00% | 2. Replace Single Drink Recipe Data | |||||||||||
5 | Coffee Liqueur | 45 | 50.00% | 3. Use Calculator 1,2,or 3. | |||||||||||
6 | Total: | 90 | 100.00% | Explanation of Calculators | |||||||||||
7 | Calculator 1 | ||||||||||||||
8 | Allows you to make a set number of bottles of | ||||||||||||||
9 | Calculator 1: Creating # of Batch Bottles | Calculator 2: Batching with limited ingredient quantity | Calculator 3: Batching for desired volume | cocktail batch. You must provide the number of | |||||||||||
10 | Batch Bottles Wanted | 10 | Volume (mls) | of Ingredient: | Desired batch volume (mls) | 900 | bottles you want, as well as their size. | ||||||||
11 | Bottle Size: | 250 | 100 | Vodka | Bottle Size: | 240 | Calculator 2 | ||||||||
12 | Batch Size | 2500 | 50.00% | Percent of Batch | Number of Bottles: | 3.75 | Calculates the maximum size batch you can make | ||||||||
13 | Ingredient: | Volume (ml) | Total Batch will be ____ mls: | 200.00 | Ingredient: | Volume (ml) | with a set volume of a single ingredient. | ||||||||
14 | Vodka | 1250.00 | Bottle Size: | 250 | Vodka | 450.00 | NOTE: You must type your ingredient name into the cell | ||||||||
15 | Coffee Liqueur | 1250.00 | Number of Bottles: | 0.80 | Coffee Liqueur | 450.00 | below "of Ingredient". If it doesn't match one of the | ||||||||
16 | Total: | 2500.00 | Ingredient: | Volume (ml) | Total: | 900.00 | ingredients you provided in "Single Drink Recipe" | ||||||||
17 | Vodka | 100 | it will return an error. | ||||||||||||
18 | Coffee Liqueur | 100 | Calculator 3 | ||||||||||||
19 | Total: | 200 | Gives you the batch recipe based off a desired ending | ||||||||||||
20 | volume of batch. | ||||||||||||||
21 | For entire spreadsheet: Only Edit Yellow Cells | ||||||||||||||
22 | Single Drink Recipe | ||||||||||||||
23 | 3 Ingredient Batch | Ingredient | ml | % of Batch | |||||||||||
24 | Gin | 1 | 33.33% | ||||||||||||
25 | Campari | 1 | 33.33% | ||||||||||||
26 | Sweet Vermouth | 1 | 33.33% | ||||||||||||
27 | Total: | 3 | 100.00% | ||||||||||||
28 | |||||||||||||||
29 | Calculator 1: Creating # of Batch Bottles | Calculator 2: Batching with limited ingredient quantity | Calculator 3: Batching for desired volume | ||||||||||||
30 | Batch Bottles Wanted | 10 | Volume (mls) | of Ingredient: | Desired Batch Volume (mls) | 1500 | |||||||||
31 | Bottle Size in mls: | 750 | 600 | Gin | Bottle Size: | 750 | |||||||||
32 | Batch Size | 7500 | 33.33% | Percent of Batch | Number of Bottles Made: | 2 | |||||||||
33 | Ingredient: | Volume (ml) | Final Batch Size | 1800.00 | Ingredient: | Volume (ml) | |||||||||
34 | Gin | 2500.00 | Bottle Size: | 750 | Gin | 500.00 | |||||||||
35 | Campari | 2500.00 | Number of Bottles Made: | 2.40 | Campari | 500.00 | |||||||||
36 | Sweet Vermouth | 2500.00 | Ingredient: | Volume (ml) | Sweet Vermouth | 500.00 | |||||||||
37 | Total: | 7500.00 | Gin | 600 | Total: | 1500.00 | |||||||||
38 | Campari | 600 | |||||||||||||
39 | Sweet Vermouth | 600 | |||||||||||||
40 | Total: | 1800 | |||||||||||||
41 | |||||||||||||||
42 | |||||||||||||||
43 | Single Drink Recipe | ||||||||||||||
44 | 4 Ingredient Batch | Ingredient | ml | % of Batch | |||||||||||
45 | Gin | 60 | 59.99% | ||||||||||||
46 | Dry Vermouth | 15 | 15.00% | ||||||||||||
47 | Orange Bitters | 0.01 | 0.01% | ||||||||||||
48 | Water | 25 | 25.00% | ||||||||||||
49 | Total: | 100.01 | 100.00% | ||||||||||||
50 | Calculator 1: Creating # of Batch Bottles | Calculator 2: Batching with limited ingredient quantity | Calculator 3: Batching for desired volume | ||||||||||||
51 | Batch Bottles Wanted | 10 | Volume (mls) | of Ingredient: | Desired Batch Volume (mls) | 96000 | |||||||||
52 | Bottle Size: | 240 | 750 | Gin | Bottle Size: | 240 | |||||||||
53 | Batch Size | 2400 | 59.99% | Percent of Batch | Number of Bottles Made: | 400 | |||||||||
54 | Ingredient: | Volume (ml) | Total Batch will be ____ mls: | 1250.13 | Ingredient: | Volume (ml) | |||||||||
55 | Gin | 1439.86 | Bottle Size | 240 | Gin | 57594.24 | |||||||||
56 | Dry Vermouth | 359.96 | Number of Bottles Made: | 5.21 | Dry Vermouth | 14398.56 | |||||||||
57 | Orange Bitters | 0.24 | Ingredient: | Volume (ml) | Orange Bitters | 9.60 | |||||||||
58 | Water | 599.94 | Gin | 750 | Water | 23997.60 | |||||||||
59 | Total: | 2400.00 | Dry Vermouth | 187.5 | Total: | 96000.00 | |||||||||
60 | Orange Bitters | 0.125 | |||||||||||||
61 | Water | 312.5 | |||||||||||||
62 | Total: | 1250 | |||||||||||||
63 | |||||||||||||||
64 | |||||||||||||||
65 | Single Drink Recipe | ||||||||||||||
66 | 5 Ingredient Batch | Ingredient | ml | % of Batch | |||||||||||
67 | One | 1 | 20.00% | ||||||||||||
68 | Two | 1 | 20.00% | ||||||||||||
69 | Three | 1 | 20.00% | ||||||||||||
70 | Four | 1 | 20.00% | ||||||||||||
71 | Five | 1 | 20.00% | ||||||||||||
72 | Total: | 5 | 100.00% | ||||||||||||
73 | Calculator 1: Creating # of Batch Bottles | Calculator 2: Batching with limited ingredient quantity | Calculator 3: Batching for desired volume | ||||||||||||
74 | Batch Bottles Wanted | 400 | Volume (mls) | of Ingredient: | Desired Batch Volume (mls) | 5 | |||||||||
75 | Bottle Size: | 240 | 30 | One | Bottle Size: | 240 | |||||||||
76 | Batch Size | 96000 | 20.00% | Percent of Batch | Number of Bottles Made: | 0.02083333333 | |||||||||
77 | Ingredient: | Volume (ml) | Total Batch will be ____ mls: | 150.00 | Ingredient: | Volume (ml) | |||||||||
78 | One | 80 | Bottle Size | 240 | One | 1.00 | |||||||||
79 | Two | 80 | Number of Bottles Made: | 0.63 | Two | 1.00 | |||||||||
80 | Three | 80 | Ingredient: | Volume (ml) | Three | 1.00 | |||||||||
81 | Four | 80 | One | 30 | Four | 1.00 | |||||||||
82 | Five | 80 | Two | 30 | Five | 1.00 | |||||||||
83 | Total: | 400 | Three | 30 | Total: | 5.00 | |||||||||
84 | Four | 30 | |||||||||||||
85 | Five | 30 | |||||||||||||
86 | Total: | 150 | |||||||||||||
87 | |||||||||||||||
88 | |||||||||||||||
89 | Single Drink Recipe | ||||||||||||||
90 | 6 Ingredient Batch | Ingredient | ml | % of Batch | |||||||||||
91 | One | 1 | 16.67% | ||||||||||||
92 | Two | 1 | 16.67% | ||||||||||||
93 | Three | 1 | 16.67% | ||||||||||||
94 | Four | 1 | 16.67% | ||||||||||||
95 | Five | 1 | 16.67% | ||||||||||||
96 | Six | 1 | 16.67% | ||||||||||||
97 | Total: | 6 | 100.00% | ||||||||||||
98 | Calculator 1: Creating # of Batch Bottles | Calculator 2: Batching with limited ingredient quantity | Calculator 3: Batching for desired volume | ||||||||||||
99 | Batch Bottles Wanted | 1 | Volume (mls) | of Ingredient: | Desired Batch Volume (mls) | 96000 | |||||||||
100 | Bottle Size: | 750 | 30 | One | Bottle Size: | 240 | |||||||||