ABS Alcohol Blending Software - Version 3.3 Blending alcohol is an integral part of distilling operations.To assist in this process ABS Alcohol Blending Software has been developed to perform the calculations necessary to accurately and reliably blend alcohol in a distilled spirits plant.
Based on 10 years of experience in operating a licensed distilled spirits plant. This suite of functions has been developed using the prescribed tables and algorithms currently in effect in the United States.In addition, the results obtained by looking up values in the Government tables have been expanded to convey more information about alcohol processing operations by making explicit the results which a simple manual lookup will not convey without further mathematical operations.By allowing the worksheets to do the lookups for the user one can obtain all the information available about the alcohol being processed each and every time the function is performed.System Requirements. All programSpreadsheets are compatible with Excel 1997-2003. To learn more about the software download the following PDF and scroll through the functions. Turn on page scrolling in the Adobe Reader and just stop at the pages with data on them.
New: Version 3.3
What is most noticeable about version 3.3 is that many of the underlying calculations are visible so you can see how the results are derived. Also, more of the worksheets can be copied and pasted into new workbooks so users can modify them to suit their purposes. These are mostly the, batch planning, accounting, component cost and inventory worksheets.
The the text of the user’s manual is vastly improved and the entire manual now runs to over 125 pages of examples and text. A list of the more important improvements included in version 3.3 follows: 1.Ability to blend to a target proof accuracy of 1/10th Proof or (5/10,000) in all worksheets. 2.Ability to set individual blending tolerance values in each worksheet. 3.A method for demonstrating Water Volume change and Alcohol Volume Change with temperature . 4. Finding Present Volume from Apparent Proof and Weight. 5.Hydrometer Thermal Expansion or Contraction correction. 6.Adding calculated wine and proof gallons per case and bottle values to most blending sheets. 7.Demonstrating calculations with intermediate steps in each worksheet. 8.Volume correction to destination volume other than present volume or 60° F. Volume. 9.Ability to use hydrometers calibrated for temperatures other than 60° F. 10.Blending by specific gravity with hydrometers calibrated for temperatures other than 60° F.
I hope these changes are useful and helps make blending and accounting for alcohol easier.
This is a read only version of the program. This will allow you to see how the functions are set up and what the results of various inputs will be. For a brief overview the following list of functions is provided.
The single best reason to use ABS Alcohol Blending Software is to make the § 30.23 calculations which are outlined in the Gauging Manual in §186.23 for you each and every time you look up a value for alcohol.
Distillers must keep in mind that Table 1 can only be used directly to correct the temperature and Apparent Proof of Alcohol blends to 60°F ONLY in the special case where both temperature and Apparent Proof are whole number values. Since this almost never happens when actual measurements are taken of spirits this table is truly a Special Case table only. To find true corrected proof to 60° for intermediate temperatures and intermediate proofs one must us the § 30.23 procedures which are outlined in the Gauging Manual in §186.23. One must look up the next higher and lower temps and higher and lower proofs in Table 1; then measure the differences then add and subtract them in the righ order in order to arrive at an properly corrected proof. This extended and math/lookup intensive procedure is run by ABS Alcohol Blending Software each time a calculation is made as required by the regulations.
The software consists of 60 plus functions which, in addition to blending operations, perform functions in the following areas:
Alcohol Properties - Find True Proof @ 60°F and other properties of One Alcohol using Expanded Table 5 and 6
Alcohol Properties from TTB Tables Only
Batch Plan Plain -Simple way to plan the size of a bottling run
Blend One Alcohol to Target Proof by Volume using Table 4 then adding components by weight or volume
Blend One Alcohol to Target Proof by Weight of Alcohol and weight of Water using Table 4
Batch Plan for 1 Alcohol Blend by Volume Using Table 4 linked to blending sheet and bottling log
Blend Two Alcohols by Volume using Table 4 then add components by weight or volume
Blend Two Alcohols in a Ratio to each otherby Volume using Table 4 then add components by weight or volume
Blend Two Alcohols by Weight using Table 4 then add components by weight or volume
Plan Batch & Blend Two Alcohols by Volume Using Table 4 Linked to a Bottling Log for that batch
Blend one alcohol using specific gravity and volume with Table 4
Blend one alcohol using specific gravity and weight with Table 4
Using Specific Gravity readings - Find True Proof @ 60°F and other properties of 1 Alcohol in Air
Gauging Drums of Alcohol
Withdrawing Proof Gallons Using Number of Proof Gallons
Blend & Sum using Volume Find Unknown Destination Proof to 1/10 Proof and Reduction in Volume due to Blending.Also, Using Volume to Determine Weight and Proof Gallons of Two containers of Alcohol.Also calculate % alcohol by volume and weight
Blend & Sum using Weight Find Unknown Destination Proof to 1/10 Proof and Reduction in Volume due to Blending. Also, Using Weight to Determine Weight and Proof Gallons of Two containers of Alcohol. Also calculate % alcohol by volume and weight.
Weight & Apparent Proof to true Proof & 60° F. volume & P.G.Then find Present Volume.Apparent Proof to Present Volume. Proof Gallons Obscured, % of expansion of alcohol and water.
Using Weight and Proof To Find Proof Gallons and Wine Gallons using Table 4.
Using Wine Gallons to find Weight via Table 5 to whole & 1/10th Proof values.
Using Proof Gallons To Find Weight & Volume Using Table 5 Whole Proof Rounding & Table 4 1/10th Proof accuracy too
Fill a Container using Weight, Temperature and Apparent Proof
Volume Correction from Present Volume and True Proof to 60° F. Volume
Sight Glass or known volume.Present Temp and Present Volume to 60° Volume Using Known True Proof.Find 60° F. Proof gallons and Wine gallons.
Sight Glass or Known Volume.Present Temp and Present Volume to 60° Volume Using Apparent Proof.Find 60° F. True Proof as well as Proof Gallons and Wine gallons.
Translate Present Volume to Volume at any Temperature
Volume Correction to find Capacity of Container - Present Volume Correction
Volume Correction from present volume & apparent proof find 60° F. Volume & True Proof & Proof Gallons
Volume Correction from True Proof & 60° Volume to Present Volume
Volume Correction from Blended target proof and 60° F. Volume to present volume Geared towards Bottling Volume Correction
Correct the Volume of Blending Water Used in Batch when adding water by Volume
Bottling LogAlcohol with Volume Correction + Processing Report and Storage Report Calcs.
Production and Withdrawl of Alcohol Monthly & Quarterly Excise Tax and Revenue Reconciliation
Costs Per Bottle
Proof Gallon order for blending and bottling
Batch Flavor Additions to Volume That Reduce the Volume of Water Required in a Batch
Flavor Additions 2Change Brix of Alcohol and track volume change by addition of Sugar and Other Solids
TTB public domain sheet for calculating Flavor Additions
Tax on Adding Flavors & Wine as a component of blending operations
Increase Proof of any Alcoholic Mixture -Make Port with Wine
Obscured Alcohol - Using Weight to find correct number of proof gallons in obscured alcohol.
Predict Obscuration of Proof by addition of solids to Weight of Alcohol
Predict Obscuration of Proof by addition of solids to Volume of Alcohol
Use Weight to Blend One Obscured Alcohol to a Target Proof using Table 4
Use Volume to Blend One Obscured Alcohol to a Target Proof using Table 4
Adjust for Hydrometers Calibrated at Temperatures other than 60°/60° (15.56°/15.56°) then Blend using specific gravity and weight
Constants Used in Operations
Temperature and Mass Converters
Calculate how Long Reverse Osmosis system must operate to process batch blending water.
