Introduction

The TechWizard Online™ Calculator contains a variety of tools to aid in converting units, calculating density, calculating total solids of a dairy ingredient, calculating serving size, and calculating serving size after moisture loss, calculating values related to Alcohol content, and calculating volumes of shapes. The calculator also has Pearson’s square for calculating a simple blend.

Viewing the TechWizard Online™ Calculator

The TechWizard Online™ Calculator can be viewed from the Formula Development section, the Labeling section, or the Mix Properties section. Instructions on how to view it in each section follows.

Viewing the TechWizard Online™ Calculator from the Formula Development Section
The user should be in the Formula Development section.

Click the View button and select TWz Calculator.

Viewing the TechWizard Online™ Calculator from the Labeling Section
The user should be in the Labeling section.

Click the View button and select TWz Calculator.

Viewing the TechWizard Online™ Calculator from the Mix Properties Section
The user should be in the Mix Properties section.

Click the View button and select TWz Calculator.

Modifying the Batch Size in the Formula Development Section

The user should be in the Formula Development section. The TWz Calculator allows the user to maintain the same size batch but changing the units of measure.

View the TWz Calculator by clicking the View button and select TWz Calculator.

The TWz Calculator window appears.

Make sure the Unit Conversion tab (A) is selected.

Click the Get Batch Size button (B). When prompted to retrieve density, answer yes.

Select the units in which you wish to display the batch size (C).

Click the Calculate button (D). The new amount is displayed next to the units you selected (C).

Click the Update Batch Size button (E) to use the new amount and units. Close the window when finished.

Unit Conversion

This component of the TechWizard Online™ Calculator is used for simple unit conversion.

If you are not sure how to view the TechWizard Online™ Calculator refer to Viewing the TechWizard Online™ Calculator.

Select the Unit Conversion tab in the Calculator window (A in figure above).

Under Input, enter amount and select a unit.

Select output units (C in figure above).

Press the Calculate button (D in figure above).

Close the window when finished.

Density Calculator

This component of the TechWizard Online™ Calculator calculates a density based on percent total fat and total solids.

If you are not sure how to view the TechWizard Online™ Calculator refer to Viewing the TechWizard Online™ Calculator.

Select the Density Calculator tab in the Calculator window.

Enter desired total fat and total solids in the spaces provided.

Press the Calculate button.
Note density. Densities are calculated using both the USDA equation (dairy liquids) and Mix equation (liquid containing sugar, fat, etc).

Close window when finished.

Calculate the Composition of Milk

This component of the TechWizard Online™ Calculator calculates the percent milk fat, milk solids nonfat, and total solids of milk based on 9% skim milk solids of a dairy liquid (milk, cream, etc.).

If you are not sure how to view the TechWizard Online™ Calculator refer to Viewing the TechWizard Online™ Calculator.

Select the Calc. Total Solids Based on Milk Fat tab in the Calculator window.

Enter the desired percent Milk Fat in the space provided.

Press the Calculate button. Note the estimated composition.

Close window when finished.

The following is an example using this feature:
Estimate the composition of 3.25% Milk Fat.
Enter 3.25 in the space provided for Milk Fat (%).
Press the Calculate button.
The following calculated values are displayed:
Milk Fat (%): 3.25
MSNF (%): 8.708
Total Solids (%): 11.958

Pearson’s Square

This component of the TechWizard Online™ Calculator calculates the amount of two ingredients to blend to obtain a desired composition. One of the ingredients must have a concentration higher than the desired amount and the other a lower composition than the desired amount.

If you are not sure how to view the TechWizard Online™ Calculator refer to Viewing the TechWizard Online™ Calculator.

Select the Pearson’s Square tab in the Calculator window.

Enter a desired percent in the space provided.

Enter a high composition value greater than the desired percentage in the space provided.

Enter a low composition value less than the desired percent in the space provided.

Press the Calculate button and note the percent of each ingredient needed.

Close the window when finished.

The following is an example using this feature:
We wish to blend cream (40% fat) and skim milk (0.05% fat) to make 5% fat milk.
Enter 5 in the space provided for the desired value.
Enter the fat content of the cream, 40 in the space provided for the High Composition Value.
Enter the fat content of skim milk, 0.05 is the space provide for the Low Composition Value.
Press the Calculate button.
The calculated percent of each ingredient is displayed.
Calculated Percent of Each Ingredient to Make 5% Fat Milk:
Ingredient of High Composition: 12.39 % Cream
Ingredient of Low Composition: 87.61 % Skim Milk

Serving Size Calculator

This component of the TechWizard Online™ Calculator calculates the grams of a product at a percent total solids that is equivalent to a given amount in grams of the same product at a different total solids content. The feature is useful when needing to determine the amount equivalent to the serving size prior to gaining or losing moisture for either Nutrition Labeling or Reverse Engineering. If you are not sure how to view the TechWizard Online™ Calculator refer to Viewing the TechWizard Online™ Calculator.

Select the Serving Size Calc. tab in the Calculator window.

In this example we have a cookie dough formula in the labeling section. After baking the cookie is 97% total solids (A) and the serving size on the Nutrition Facts panel is 30 g (B). TechWizard calculated the total solids of the cookie dough formula to be 88.357% (C). After entering these values, press the Calculate button (D). This provides us with the serving size of dough that is equivalent to 30 g of bake cookies (E). To use this value in the Labeling section, uncheck the box shown on the left and enter the amount in the blue cell.

Serving Size after Moisture Loss Calculator

This component of the TechWizard Online™ Calculator calculates the grams of a product at a percent total solids that is equivalent to a given amount in grams of the same product at a different total solids content. It allows the nutrition facts to be calculated using the composition of ingredients prior to losing or gaining moisture. It is very similar to the feature described in the previous section. This feature is different in that it can update values in the Nutrition Labeling section.

Click the Show Loss Calc. button to open the TechWizard Online™ Calculator with the Serving Size – Loss tab selected.

In this example we have a cookie dough formula in the labeling section. We entered the following information into the Moisture Loss Calculator. Our baked cookie has a serving size of 30g (A). TechWizard calculated the total solids of the cookie dough formula to be 88.357% (B). Next, we weighed 100 g (C) of cookie dough and baked it. After baking and cooling, we measured the remaining weight of the cookies which was 91.09 g (D). Pressing Calculate button (E) provides us with the amount of cookie dough (32.93 g) that is equivalent to 30 g of bake cookies (F). Finally, we press the Update button (G) to set this as the amount used to calculate the composition in the spreadsheet.

Notice that the Amount used to calculate composition has been set to 32.93 g and the Use Equivalent Metric Quantity to Calculate Composition is unchecked.

This allows us to create a Nutrition Facts panel for the finished cookie using the cookie dough recipe.