Alcohol Blending Software 3 - Mountain Moonshine

661 Pages·2011·2.95 MB·English

Alcohol Blending Software Version 3.4 Date: 1/14/11 Laws & Regulations of Distilled Spirits
http://www.mountainmoonshine.com/ Functions Link to Gauging Manual Regulations
Alcohol Properties - Find True Proof @ 60°F and other
Alcohol Properties Expanded to 1/10
1 properties of One Alcohol using Expanded Table 5 and § 30.23 §186.23 - §30.23 Procedures
Proof
6
2 Alcohol Properties from TTB Tables Only Alcohol Properties from TTB Tables Only § 30.23 §186.23 - §30.23 Procedures
Batch Plan Plain - Simple way to plan the size of a
3 Batch Plan
bottling run
Blend One Alcohol to Target Proof by Volume using Blend One Alcohol by Volume Using
4
Table 4 then adding components by weight or volume Table 4
Blend One Alcohol to Target Proof by Weight of Blend One Alcohol by Weight Using
5 § 30.64 §186.64 - §30.64 Procedures
Alcohol and weight of Water using Table 4 Table 4
Batch Plan for 1 Alcohol Blend by Volume Using Table Plan & Blend 1 Alcohol by Volume T4 Bottling Log 1
6
4 linked to blending sheet and bottling log Linked to Bottling Log Alcohol Linked
Blend Two Alcohols by Volume using Table 4 then add Blend Two Alcohols by Volume Using
7
components by weight or volume Table 4
Blend Two Alcohols in a Ratio to each other by
Blend Two Alcohols by Volume in a
8 Volume using Table 4 then add components by weight
Ratio Using Table 4
or volume
Blend Two Alcohols by Weight using Table 4 then add Blend Two Alcohols by Weight Using
9
components by weight or volume Table 4
Plan Batch & Blend Two Alcohols by Volume Using Plan & Blend 2 Alcohols in by Volume T4 Bottling Log 2
10
Table 4 Linked to a Bottling Log for that batch Linked to Bottling Log Alcohols Linked
Blend one alcohol using specific gravity and volume Blend 1 Alcohol using Specific Gravity &
11
with Table 4 Volume
Blend one alcohol using specific gravity and weight Blend 1 Alcohol using Specific Gravity &
12
with Table 4 Weight
Using Specific Gravity readings - Find True Proof @ Specific Gravity Alcohol Properties in Air
13
60°F and other properties of 1 Alcohol in Air or Vacuum
14 Gauging Drums of Alcohol Gauging Drums of Alcohol
Withdrawing Proof Gallons Using Number of Proof
15 Withdrawing Proof Gallons
Gallons
Blend & Sum using Volume Find Unknown Destination
Proof to 1/10 Proof and Reduction in Volume due to
Blend or Sum Two Alcohols by Volume -
16 Blending. Also, Using Volume to Determine Weight
Find High Proof Blend
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
Blend or Sum Two Alcohols by Weight -
17 Blending. Also, Using Weight to Determine Weight
Find High Proof Blend
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 Weight & Apparent Proof to P.G. &
18 § 30.64 §186.64 - §30.64 Example 1 § 30.63 §186.63 - §30.63 Proc
Proof to Present Volume. Proof Gallons Obscured, % W.G.
of expansion of alcohol and water.
Using Weight and Proof To Find Proof Gallons and
19 Weight & True Proof to P.G. & W.G. § 30.64 §186.64 - §30.64 Example 1 § 30.63 §186.63 - §30.63 Proc
Wine Gallons using Table 4.
Using Wine Gallons to find Weight via Table 5 to
20 Wine Gallons to Weight & Proof Gallons § 30.65 §186.65 - §30.65 Example 1
whole & 1/10th Proof values.
Using Proof Gallons To Find Weight & Volume Using
21 Table 5 Whole Proof Rounding & Table 4 1/10th Proof Proof Gallons to Weight & Volume § 30.65 §186.65 - §30.65 Example 2
accuracy too
Fill a Container using Weight, Temperature and
22 Fill by Weight § 30.44 §186.44 - §30.44 Example 1
Apparent Proof
Volume Correction from Present Volume and True
23 Vol Cor Simple 1 § 30.67
Proof to 60° F. Volume §186.67 - §30.67 Examples 1,2,3,4,5,6
Sight Glass or known volume. Present Temp and
24 Present Volume to 60° Volume Using Known True Vol. to P.G. T7 Sight Glass 1 § 30.51 §186.51 - §30.51 Procedures
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.
25 Vol. to P.G. T7 Sight Glass 2 § 30.51 §186.51 - §30.51 Procedures
Find 60° F. True Proof as well as Proof Gallons and
Wine gallons.
Translate Present Volume to Volume at any
26 Vol. to P.G. T7 Sight Glass 3
Temperature
Volume Correction to find Capacity of Container -
27 Capacity of Container - T7 § 30.67 §186.67 - §30.67 Examples 2,
Present Volume Correction
Volume Correction from present volume & apparent Volume from Present Volume &
28
proof find 60° F. Volume & True Proof & Proof Gallons Apparent Proof to 60° Vol & True Proof
Volume Correction from True Proof & 60° Volume to Volume Correction from True Proof &
29
Present Volume 60° Volume to Present Volume
Volume Correction from Blended target proof and 60°
Volume Correction from 60° F. to
30 F. Volume to present volume Geared towards Bottling
Present Volume
Volume Correction
Correct the Volume of Blending Water Used in Batch
31 Volume Correction of Blend Water
when adding water by Volume
Bottling Log Alcohol with Volume Correction +
32 Bottling Log & Processing Report User Modifiable by copy and Paste to New Sheet
Processing Report and Storage Report Calcs.
Production and Withdrawl of Alcohol Monthly &
33 Excise Tax and Revenue User Modifiable by copy and Paste to New Sheet
Quarterly Excise Tax and Revenue Reconciliation
34 Costs Per Bottle Costs Per Bottle User Modifiable by copy and Paste to New Sheet
35 Proof Gallon order for blending and Bottling Proof Gallon Ordering User Modifiable by copy and Paste to New Sheet
Batch Flavor Additions to Volume That Reduce the Flavor Additions that reduce volume of
36
Volume of Water Required in a Batch water required
Flavor Additions 2 Change Brix of Alcohol and track
37 Flavor Add 2 Change Brix
volume change by addition of Sugar and Other Solids
TTB public domain sheet for calculating Flavor
38 Flavor Additions 3 TTB Public Sheet
Additions
Tax on Adding Flavors & Wine as a component of
39 Tax on Adding Flavors & Wine §19.34 §19.34 Procedures, computation of effective tax rate.
blending operations
Increase Proof of any Alcoholic Mixture - Make Port
40 Increase Proof
with Wine
Obscured Alcohol - Using Weight to find correct Obscured Alcohol Proof Gallons & Wine
41 § 30.64 § 30.64-186.64 Example 1 & 3§ 30.62 §30.62 - §186.62 -Exa
number of proof gallons in obscured alcohol. Gallons from Weight
Predict Obscuration of Proof by addition of solids to Adding Solids to Weight of Alcohol &
42 § 30.62 §186.62 - §30.62 Procedures§ 30.32 § 30.32 Determinatio
Weight of Alcohol Predicting Obscuration of Proof
Predict Obscuration of Proof by addition of solids to Adding Solids to Volume of Alcohol &
43 § 30.62 §186.62 - §30.62 Procedures§ 30.32 § 30.32 Determinatio
Volume of Alcohol Predicting Obscuration of Proof
Use Weight to Blend One Obscured Alcohol to a
44 Blend One Obscured Alcohol by Weight § 30.62 §186.62 - §30.62 Example 2 § 30.64 § 30.64 - 186.64 Exam
Target Proof using Table 4
Use Volume to Blend One Obscured Alcohol to a
45 Blend One Obscured Alcohol by Volume § 30.62 §186.62 - §30.62 Example 2 § 30.64 § 30.64 - 186.64 Exam
Target Proof using Table 4
Adjust for Hydrometers Calibrated at Temperatures
Blend 1 Alcohol using Specific Gravity &
46 other than 60°/60° (15.56°/15.56°) then Blend using
Weight 2
specific gravity and weight
47 Constants Used in Operations Constants User Modifiable by copy and Paste to New Sheet
48 Temperature and Mass Converters Converters User Modifiable by copy and Paste to New Sheet
Calculate how Long Reverse Osmosis system must
49 Blending Water Time to Process User Modifiable by copy and Paste to New Sheet
operate to process batch blending water.
50 Storage Report Storage Report User Modifiable by copy and Paste to New Sheet
51 Hydrometer Thermal Correction 1 Hydrometer Thermal Correction 1
Hydrometer Thermal Correction 2 With Diagnostic &
52 Hydrometer Thermal Correction 2
Comparison Tools
Hydrometer Calibration Temperature Offset Hydrometer Calibration Temp
53
Calculations and Blend by Weight and proof Differential in Proof + Blend
Hydrometer Calibration Temperature Offset Hydrometer Calibration Temp
54
Calculations and Blend by SG & Weight Differential in SG + Blend by Wt.
Hydrometer Calibration Temperature Offset Hydrometer Calibration Temp
55
Calculations and Blend by SG & Volume Differential in SG + Blend by Vol.
Find how much time is required to Heat or Cool a Btu's Required to Heat or Cool a
56
mixture based on Btu's available. Mixture
Finding effect of .1 Proof change and .1 temperature
Weight & Apparent to P.G. & W.G.
57 change on proof gallons in a batch -Observe Table
Compare Values
Accuracy
Using Weight and True Proof S.G. Equivalent to Find Weight to Proof Gallons & Wine Gallons
58 § 30.64 §186.64 - §30.64 Example 1 § 30.63 §186.63 - §30.63 Proc
Proof Gallons and Wine Gallons Using Table 6 - T6
Table 6 1/10th Proof Volume Blending Linked to
Blend 1 Alcohol Using T6 @ 1/10 Proof
59 Table 4 Blending to show Difference in methods and § 30.66 §186.66 - §30.66 Procedures
& showingTable 4 Results
rounding errors
Table 6 Whole Proof Volume Blending Linked to Table
Blend 1 Alcohol Using T6 Whole Proof &
60 4 Blending to show Difference in methods and § 30.66 §186.66 - §30.66 Procedures
showing Table 4 Results
rounding errors
Showing Proof Gallons of Rounding Error if §186.61
61 Method of Table 1 use is applied incorrectly by Rounding Errors of Table 1
comparing to §186.23 Procedures
Adjust Weight of Water to Add to a Batch Based on Water Adjustment Based on Dissolved
Dissolved Solids in Water Being Used. Solids in Water
62
Finding True Proof From Table 1 in the special case
62 were Alcohol is at whole temperature and whole Table 1 Lookup of True Proof § 30.61 §30.61 Example 1 §186.61 procedures 1,2,3
proof
Pearson's Square Used to Increase Proof of Mixture.
61 Pearson's Square User Modifiable by copy and Paste to New Sheet
Does Not Account for Shrinkage in Blending
Algebraic Blending Formulas. These Formulas do not
62 Algebraic Formulas User Modifiable by copy and Paste to New Sheet
account for shrinkage in Blending but can be useful
Thermal Correction Table for Hydrometer and overall
63 Thermal Correction Table
correction to 60° F. Broad Spectrum Table
Blending Water - Time to Make using Reverse Osmosis
64 Blending Water Time to Process
System
License Agreement License Agreement
Copyright 2011 by Payton Fireman
cedure
cedures
amples 1 & 2
on of proof obscuration.
on of proof obscuration.
mple 3
mple 3
cedure
Find True Proof @ 60° F. Using §186.23 & §30.23 Method of Apparent Proof and Temperature Correction Main Function Page Link
§ 30.23 §186.23 - §30.23 Procedures Example 1
Temperature of Alcohol 70.00 0.000 Thermometer Correction Factor
Apparent Proof of Alcohol 163.00 0.000 Hydrometer Correction Factor
True Proof Rounded to Nearest 1/100 proof 159.70
True Proof Rounded to 1/10 Proof 159.70
True Proof Rounded to Nearest Whole Number 160.00
True Proof @ 60° F. Using §186.23 & §30.23 Method of Apparent Proof and Temperature Correction & ABS Expanded Table data
Table Values Expanded so all tables read to 1/10 proof accuracy
Properties of Alcohol Corrected to 60° F. True Proof Rounded Pounds Per Specific Specific
to 1/10 Proof Proof Gallons per Wine Gallons per Pounds Per Wine Proof Gal. Parts Alcohol Parts Water Total Parts Gravity in Air Gravity in
Lb. Table 4 Lb. Table 4 Gal Table 5 PF Table 5 PF T6AW T6AW T6AW TSG Vacuum TSG
159.7 0.22192 0.13896 7.19606 4.50604 79.85 23.03 102.88 0.86406 0.86421
Quotient Values Using 1/Table 4 Results 7.19632 4.50613
Outut values from TTB tables only. Some values available only @ whole proofs
Specific
Properties of Alcohol Corrected to 60° F. True Proof Rounded Pounds Per Specific Gravity in
to 1/10 Proof Proof Gallons per Wine Gallons per Pounds Per Wine Proof Gal. Parts Alcohol Parts Water Gravity in Air Vacuum Table
Lb. Table 4 Lb. Table 4 Gal Table 5 Table 5 Table 6 Table 6 Total Parts Table 6 6
159.7 0.22192 0.13896 #N/A #N/A #N/A #N/A #N/A #N/A #N/A
Quotient Values Using 1/Table 4 Results 7.19632 4.50613
Outut values from TTB tables showing values at nearest rounded whole proof. ABS Values match TTB @ all Whole Proofs
Specific
Properties of Alcohol Corrected to 60° F True Proof & Pounds Per Specific Gravity in
Rounded to Nearest Whole Proof Proof Gallons per Wine Gallons per Pounds Per Wine Proof Gal. Parts Alcohol Parts Water Gravity in Air Vacuum Table
Lb. Table 4 Lb. Table 4 Gal Table 5 Table 5 Table 6 Table 6 Total Parts Table 6 6
160.0 0.22245 0.13903 7.19259 4.49537 80.00 22.87 102.87 0.86364 0.86380
Alcohol Temperature Results
Corrected Temperature Rounded to 1/10th °F 70.0
Corrected Temperature Rounded to whole °F 70.0
Find True Proof @ 60° F. Using §186.23 & §30.23 Method of Apparent Proof and Temperature Correction with bracketed Table 1 lookups
Hydrometer Reading of Apparent Proof 163.00
Correction Factor for This Hydrometer 0.000
Add Correction (+ or - value) to Aparent Reading = 163.00 Corrected Hydrometer Reading Simple addi
Find Fractional Proof Value of Corrected Reading 0.00
Proof of Lookup Temp. of Lookup
Round Corrected Reading down to 1 Whole Proof Lower. 163.00 70.00 159.70 Lookup Table 1 Value for Whole Proof Lower
Add 1 to obtain 1 proof higher 164.00 70.00 160.70 Lookup Table 1 Value for Whole Proof Higher
Subtract Lower Proof Value from Higher proof Value 1.00 Hydrometer Based Table 1 Proof Difference
Apparent Temperature Reading 70.00
Correction Factor for This Thermometer 0.00
Add Correction (+ or - value) to Aparent Reading = 70.00 Corrected Temperature
Corrected Temperature Rounded to 1/10 ° F. 70.0
Corrected Temperature Rounded to Nearest Whole ° F. 70.0
Find Fractional Degree F. of Corrected Reading 0.00
Temp of Lookup Proof of Lookup
Round Corrected Reading down to 1 Whole ° F. Lower. 70.00 163.00 159.70 Lookup Table 1 Value for Whole Proof Lower
Add 1 to obtain 1 ° F. higher 71.00 163.00 159.40 Lookup Table 1 Value for Whole Proof Higher
Subtract Higher Temp Table 1 Proof Value from Lower Temp Table 1 Proof Value. 0.30 Thermometer Based Proof Difference
Hydrometer Based Table 1 Proof Difference Restated 1.00
Fractional Degree of Hydrometer Reading Restated 0.00
Proof Dif. * Fractional Degree of Hydrom. Reading = 0.000 Result (T)
Thermometer Based Proof Difference Restated 0.30
Times Fractional Degree of Thermometer Reading 0.00
Temp Dif. * Fractional Degree to Temp. Reading 0.00 Result (B)
Finding Hydrometer Corrected Proof from Sample Temperature to 60° F
Rounded Lower Whole Proof Table 1 Look up Restated 159.70
Result (T) Restated 0.000
Lower Whole Proof + Result (T) = 159.700 Result
Result (B) Restated 0.000
Lower Whole Proof - Result (B) + Result (T) = 159.700 True Proof @ 60° F.
True Proof Rounded to Nearest 1/100 proof 159.70
True Proof @ 60° F. Rounded to 1/10th proof 159.7
True Proof Rounded to Nearest Whole Proof 160.0 For Table 3,5,6 & 7
Alcohol 2 Inputs
Temperature of Alcohol 73.40 0.000 Thermometer Correction Factor
Apparent Proof of Alcohol 163.50 0.000 Hydrometer Correction Factor
True Proof Rounded to Nearest 1/100 proof 159.08
True Proof Rounded to 1/10 Proof 159.10
True Proof Rounded to Nearest Whole Number 159.00
True Proof @ 60° F. Using §186.23 & §30.23 Method of Apparent Proof and Temperature Correction & ABS Expanded Table data
Table Values Expanded so all tables read to 1/10 proof accuracy
Pounds Per Specific Specific
Properties of Alcohol Corrected to 60° F. True Proof Rounded
Proof Gallons per Wine Gallons per Pounds Per Wine Proof Gal. Parts Alcohol Parts Water Total Parts Gravity in Air Gravity in
to 1/10 Proof
Lb. Table 4 Lb. Table 4 Gal Table 5 PF Table 5 PF T6AW T6AW T6AW TSG Vacuum TSG
159.1 0.22088 0.13883 7.20301 4.52737 79.55 23.35 102.90 0.86489 0.86504
Quotient Values Using 1/Table 4 Results 7.20305 4.52735
Outut values from TTB tables only. Some values available only @ whole proofs
Specific
Properties of Alcohol Corrected to 60° F. True Proof Rounded Pounds Per Specific Gravity in
to 1/10 Proof Proof Gallons per Wine Gallons per Pounds Per Wine Proof Gal. Parts Alcohol Parts Water Gravity in Air Vacuum Table
Lb. Table 4 Lb. Table 4 Gal Table 5 Table 5 Table 6 Table 6 Total Parts Table 6 6
159.1 0.22088 0.13883 #N/A #N/A #N/A #N/A #N/A #N/A #N/A
Quotient Values Using 1/Table 4 Results 7.20305 4.52735
Outut values from TTB tables showing values at nearest rounded whole proof. ABS Values match TTB @ all Whole Proofs
Specific
Properties of Alcohol Corrected to 60° F True Proof & Pounds Per Specific Gravity in
Rounded to Nearest Whole Proof Proof Gallons per Wine Gallons per Pounds Per Wine Proof Gal. Parts Alcohol Parts Water Gravity in Air Vacuum Table
Lb. Table 4 Lb. Table 4 Gal Table 5 Table 5 Table 6 Table 6 Total Parts Table 6 6
159.0 0.22071 0.13881 7.20417 4.53092 79.50 23.40 102.90 0.86503 0.86518
Alcohol Temperature Results
Corrected Temperature Rounded to 1/10th °F 73.4
Corrected Temperature Rounded to whole °F 73.0
Find True Proof @ 60° F. Using §186.23 & §30.23 Method of Apparent Proof and Temperature Correction with bracketed Table 1 lookups
Hydrometer Reading of Apparent Proof 163.50
Correction Factor for This Hydrometer 0.000
Add Correction (+ or - value) to Aparent Reading = 163.50 Corrected Hydrometer Reading Simple addition will always obtain correct value
Find Fractional Proof Value of Corrected Reading 0.50
Proof of Lookup Temp. of Lookup
Round Corrected Reading down to 1 Whole Proof Lower. 163.00 73.00 158.70 Lookup Table 1 Value for Whole Proof Lower
Add 1 to obtain 1 proof higher 164.00 73.00 159.70 Lookup Table 1 Value for Whole Proof Higher
Subtract Lower Proof Value from Higher proof Value 1.00 Hydrometer Based Table 1 Proof Difference
Apparent Temperature Reading 73.40
Correction Factor for This Thermometer 0.00
Add Correction (+ or - value) to Aparent Reading = 73.40 Corrected Temperature
Corrected Temperature Rounded to 1/10 ° F. 73.4
Corrected Temperature Rounded to Nearest Whole ° F. 73.0
Find Fractional Degree F. of Corrected Reading 0.40
Temp of Lookup Proof of Lookup
Round Corrected Reading down to 1 Whole ° F. Lower. 73.00 163.00 158.70 Lookup Table 1 Value for Whole Proof Lower
Add 1 to obtain 1 ° F. higher 74.00 163.00 158.40 Lookup Table 1 Value for Whole Proof Higher
Subtract Higher Temp Table 1 Proof Value from Lower Temp Table 1 Proof Value. 0.30 Thermometer Based Proof Difference
Hydrometer Based Table 1 Proof Difference Restated 1.00
Fractional Degree of Hydrometer Reading Restated 0.50
Proof Dif. * Fractional Degree of Hydrom. Reading = 0.500 Result (T)
Thermometer Based Proof Difference Restated 0.30
Times Fractional Degree of Thermometer Reading 0.40
Temp Dif. * Fractional Degree to Temp. Reading 0.12 Result (B)
Finding Hydrometer Corrected Proof from Sample Temperature to 60° F
Rounded Lower Whole Proof Table 1 Look up Restated 158.70
Result (T) Restated 0.500
Lower Whole Proof + Result (T) = 159.200 Result
Result (B) Restated 0.120
Subtract Result (B) from Lower Whole Proof + Result (T) = 159.080 True Proof @ 60° F.
True Proof Rounded to Nearest 1/100 proof 159.08
True Proof @ 60° F. Rounded to 1/10th proof 159.1
True Proof Rounded to Nearest Whole Proof 159.0 For Table 3,5,6 & 7