ON BAR MANAGEMENT
  • Home
  • Posts
  • Resources
  • Contact

The only batching spreadsheet you'll ever need

11/15/2020

1 Comment

 
Picture

The batching spreadsheet Download

Picture
This sheet eliminates all of the headaches that come with batching. You're going to save so much time and make fewer mistakes compared to doing your calculation by hand.  This sheet can be extremely useful to bars that feature batching in their cocktail programs regularly, or for bars that are batching cocktails for the first time as part of their togo drinks program. . It currently supports drinks with 2-8 ingredients. 
There are 3 built in calculators on this sheet with unique functions.
  • The first calculator is for when you know the final number of bottled cocktails you'd like to make but are unsure how much batch you need for that.
  • The second calculator is for situations that come up when you have a set amount of one product (lets say 500ml) and you want to know how much of every other ingredient you need to add.
  • The last calculator will tell you the batch recipe based on a final ending volume. All are extremely useful in different scenarios and come up all of the time during batching. 
To use:
  1. Copy cells from the "Template" Tab, to the "Your Drinks" tab.
  2. Replace the sample data with the single serve cocktail recipe.
  3. Determine which of the 3 calculators you want to use and plug in your data.

Note: Only edit the yellow cells. Once you are on the google sheets page, you'll need to select File> Make a copy in order to edit the file.
1 Comment
Sofia
6/25/2022 08:42:37 am

…

Reply



Leave a Reply.

      ​MAILING LIST

    Join!

    Categories

    All
    Batching
    Carbonation
    Consulting
    Earnings
    For Staff
    Glassware
    Home Bartenders
    How-To
    Inventory
    Juice
    Prep
    Spreadsheets
    Technique

    DON'T MISS OUT!

Subscribe to Newsletter

​© COPYRIGHT 2022. ALL RIGHTS RESERVED.
  • Home
  • Posts
  • Resources
  • Contact