This article provides a list of calculators included in the Excel Book “MustCalc1624” and a brief explanation on how to use them.
This version of the Microsoft Excel Book “MustCalc1624” contains five spread sheets: “MustCalc”, “Yeast Table”, “Malolactic Fermentation Feasibility Table”, “ML Bacteria Table”, and “Renaissance Yeast Table”. The version of “MustCalc” sheet is now compatible with “LibreOffice Calc”.
Its use: Data is entered into the green shaded cells, the calculated results are then displayed in a blue font.
Grape varieties, yeast strains and input parameters for the C—MAX calculator are selected in “List Boxes”. List Boxes are limited to eight rows of text.
To activate a List Box click on the cell and then the triangle on the right side of the box. If there are more rows of text these are accessed by pulling down or up on the scroll bar on the right side of the List Box.
Equations are protected from accidental editing. Protected may be turned off by selecting the “Review” tab and then the “Unprotect Sheet” tab. Protection is returned by selecting the “Protect Sheet” tab on the Review tab. The supporting data can be found within the Grouped (hidden) columns M to AQ after protection has been turned off. Click on the + or – symbol above column AR to open or close the columns.
It is possible to print on a single double–sided page to create a work sheet and record.
- The “MustCalc” spread sheet contains the following 22 calculators:
- • Volume measurement in 6 US gallon pails.
- • Weight (pail tares).
- • Grape Juice Volume Estimate.
- • Lallzyme C—MAX (Considering: pH, Temperature, Pectin, Pressing and Harvesting).
- • Must Chaptalization.
- • Must Re–hydration.
- • Yeast Nutrient requirements for various strains of yeast.
- • Nutrient Distribution Table.
- • Sulphite (accounting for alcohol, temperature, molecular SO2, loss due to binding).
- • Hydrometer Temperature Correction.
- • Malic and Tartaric Acid modelling.
- • Bench Trials.
- • Conversion Table: °C/°F; L/US Gallons; SG/°Brix; g/L vs Lbs./1000 US Gal.; Kilograms/Lbs.
- • Refractometer Correction for Alcohol.
- • Wine Freezing Temperature.
- • Pearson Square Table.
- • Alcohol Measurement in Finished Wine.
- • Residual Sugar Estimates in Red and White Wine.
- • Potential Alcohol Estimate by Hydrometer.
- • Alcohol SG and Water Blending.
- • Potential Alcohol Estimate by Refractometer and Hydrometer.
- • Potassium Sorbate.
Download the calculator to your computer HERE