Jump to content

Alcohol Blending Software


Recommended Posts

One year after its launch, the ABS Alcohol Blending Software suite is in use by dozens of distilleries throughout the United States. Version 3.3 has just been released. The program performs every Gauging Manual lookup and calculation for the user. Over 60 different functions are included.

Created by Payton Fireman, a licensed distiller, with over 10 years experience in blending, rectifying and compounding alcohol to ATF standards. This program provides increased reliability in blending operations and allows for exact control of ingredients and components used. For more information and a read only version of the program see the West Virginia Distilling Company site: mountainmoonshine.com. Or contact the author at pfireman@frontier.com.

A list of Functions performed by the program follows:

1 Alcohol Properties - Find True Proof @ 60°F and other properties of One Alcohol using Expanded Table 5 and 6

2 Alcohol Properties from TTB Tables Only

3 Batch Plan Plain - Simple way to plan the size of a bottling run

4 Blend One Alcohol to Target Proof by Volume using Table 4 then adding components by weight or volume

5 Blend One Alcohol to Target Proof by Weight of Alcohol and weight of Water using Table 4

6 Batch Plan for 1 Alcohol Blend by Volume Using Table 4 linked to blending sheet and bottling log

7 Blend Two Alcohols by Volume using Table 4 then add components by weight or volume

8 Blend Two Alcohols in a Ratio to each other by Volume using Table 4 then add components by weight or volume

9 Blend Two Alcohols by Weight using Table 4 then add components by weight or volume

10 Plan Batch & Blend Two Alcohols by Volume Using Table 4 Linked to a Bottling Log for that batch

11 Blend one alcohol using specific gravity and volume with Table 4

12 Blend one alcohol using specific gravity and weight with Table 4

13 Using Specific Gravity readings - Find True Proof @ 60°F and other properties of 1 Alcohol in Air

14 Gauging Drums of Alcohol

15 Withdrawing Proof Gallons Using Number of Proof Gallons

16 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

17 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.

18 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.

19 Using Weight and Proof To Find Proof Gallons and Wine Gallons using Table 4.

20 Using Wine Gallons to find Weight via Table 5 to whole & 1/10th Proof values.

21 Using Proof Gallons To Find Weight & Volume Using Table 5 Whole Proof Rounding & Table 4 1/10th Proof accuracy too

22 Fill a Container using Weight, Temperature and Apparent Proof

23 Volume Correction from Present Volume and True Proof to 60° F. Volume

24 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.

25 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.

26 Translate Present Volume to Volume at any Temperature

27 Volume Correction to find Capacity of Container - Present Volume Correction

28 Volume Correction from present volume & apparent proof find 60° F. Volume & True Proof & Proof Gallons

29 Volume Correction from True Proof & 60° Volume to Present Volume

30 Volume Correction from Blended target proof and 60° F. Volume to present volume Geared towards Bottling Volume Correction

31 Correct the Volume of Blending Water Used in Batch when adding water by Volume

32 Bottling Log Alcohol with Volume Correction + Processing Report and Storage Report Calcs.

33 Production and Withdrawl of Alcohol Monthly & Quarterly Excise Tax and Revenue Reconciliation

34 Costs Per Bottle

35 Proof Gallon order for blending and Bottling

36 Batch Flavor Additions to Volume That Reduce the Volume of Water Required in a Batch

37 Flavor Additions 2 Change Brix of Alcohol and track volume change by addition of Sugar and Other Solids

38 TTB public domain sheet for calculating Flavor Additions

39 Tax on Adding Flavors & Wine as a component of blending operations

40 Increase Proof of any Alcoholic Mixture - Make Port with Wine

41 Obscured Alcohol - Using Weight to find correct number of proof gallons in obscured alcohol.

42 Predict Obscuration of Proof by addition of solids to Weight of Alcohol

43 Predict Obscuration of Proof by addition of solids to Volume of Alcohol

44 Use Weight to Blend One Obscured Alcohol to a Target Proof using Table 4

45 Use Volume to Blend One Obscured Alcohol to a Target Proof using Table 4

46 Adjust for Hydrometers Calibrated at Temperatures other than 60°/60° (15.56°/15.56°) then Blend using specific gravity and weight

47 Constants Used in Operations

48 Temperature and Mass Converters

49 Calculate how Long Reverse Osmosis system must operate to process batch blending water.

50 Storage Report

51 Hydrometer Thermal Correction 1

52 Hydrometer Thermal Correction 2 With Diagnostic & Comparison Tools

53 Hydrometer Calibration Temperature Offset Calculations and Blend by Weight and proof

54 Hydrometer Calibration Temperature Offset Calculations and Blend by SG & Weight

55 Hydrometer Calibration Temperature Offset Calculations and Blend by SG & Volume

56 Find how much time is required to Heat or Cool a mixture based on Btu's available.

57 Finding effect of .1 Proof change and .1 temperature change on proof gallons in a batch -Observe Table Accuracy

58 Using Weight and True Proof S.G. Equivalent to Find Proof Gallons and Wine Gallons Using Table 6

59 Table 6 1/10th Proof Volume Blending Linked to Table 4 Blending to show Difference in methods and rounding errors

60 Table 6 Whole Proof Volume Blending Linked to Table 4 Blending to show Difference in methods and rounding errors

61 Showing Proof Gallons of Rounding Error if §186.61 Method of Table 1 use is applied incorrectly by comparing to §186.23 Procedures

62 Adjust Weight of Water to Add to a Batch Based on Dissolved Solids in Water Being Used.

62 Finding True Proof From Table 1 in the special case were Alcohol is at whole temperature and whole proof

61 Pearson's Square Used to Increase Proof of Mixture. Does Not Account for Shrinkage in Blending

62 Algebraic Blending Formulas. These Formulas do not account for shrinkage in Blending but can be useful

63 Thermal Correction Table for Hydrometer and overall correction to 60° F. Broad Spectrum Table

64 Blending Water - Time to Make using Reverse Osmosis System

Version 3.3 has just been released containing these upgrades.

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 proof gallon obscuration with temperature change.

5. Finding Present Volume from Apparent Proof and Weight.

6. Making Table 4 Quotient values consistent as the operand for Weight or Volume Calculations by reducing the use of Table 5 values for such calculations.

7. Hydrometer Thermal Expansion or Contraction correction.

8. Adding calculated wine and proof gallons per case and bottle values to most blending sheets.

9. Demonstrating calculations with intermediate steps in each worksheet.

10. Volume correction to destination volume other than present volume or 60° F. Volume.

11. Ability to use hydrometers calibrated for temperatures other than 60° F.

12. Blending by specific gravity with hydrometers calibrated for temperatures other than 60° F.

Link to comment
Share on other sites

  • 2 months later...

I wanted to take minute to comment on this software. I have been using it since February and I cannot imagine going back to what life was like without it. There is a worksheet for just about any calculation you could ever have to perform in your distillery. I am sure I am still discovering the tip of the iceberg in terms of what this program can do, and I can't wait to fully explore its capabilities. The time and aggravation saved by not having to constantly look up tedious information from the gauging tables is priceless. Great product!

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
×
×
  • Create New...