Skip to content

Formulation worksheet

Magnesium Ingredient Blend Assay Calculator

Enter the mass and elemental magnesium assay of each component in a mineral premix for beverages, or in any other magnesium-containing blend, and the stated mass of the blend. The worksheet returns the mass-weighted elemental magnesium content of the components you enter and the elemental magnesium in that blend mass. Leave both fields empty to skip a row; filling only one field returns an error. The calculator does not judge compatibility, solubility or shelf life.

The blend quantity whose elemental magnesium you want. It can be the sum of the rows or a larger batch with exactly the same composition, not additional unentered material.

A magnesium-containing component, or another component with its elemental magnesium assay. Mass of this component in the blend you are averaging. The initial values are illustrative values for the arithmetic example only.

Elemental magnesium mass percentage, not compound percentage, on the same basis in every row, for example as-is. Use lot assay for actual batch calculations; specification values may be used for estimates. Enter its mass and an assay of 0 if this component contributes no magnesium.

Optional. Leave both fields in this row empty if unused. Mass of this component in the blend you are averaging. The initial values are illustrative values for the arithmetic example only.

Elemental magnesium mass percentage, not compound percentage, on the same basis in every row, for example as-is. Use lot assay for actual batch calculations; specification values may be used for estimates. Enter its mass and an assay of 0 if this component contributes no magnesium.

Optional. Leave both fields in this row empty if unused. Mass of this component in the blend you are averaging. The initial values are illustrative values for the arithmetic example only.

Elemental magnesium mass percentage, not compound percentage, on the same basis in every row, for example as-is. Use lot assay for actual batch calculations; specification values may be used for estimates. Enter its mass and an assay of 0 if this component contributes no magnesium.

Optional. Leave both fields in this row empty if unused. Mass of this component in the blend you are averaging. The initial values are illustrative values for the arithmetic example only.

Elemental magnesium mass percentage, not compound percentage, on the same basis in every row, for example as-is. Use lot assay for actual batch calculations; specification values may be used for estimates. Enter its mass and an assay of 0 if this component contributes no magnesium.

Calculated result

Enter the values above to calculate. Results appear here.

Arithmetic on the values you enter. Use the same assay basis in every row. This is a mass-weighted content figure, not a lot assay and not a compatibility, solubility or shelf-life result.

How the blend assay is calculated

Blend assay = sum(massi × assayi) / sum(massi). With the initial example, 80 g at 8% and 20 g at 12% give (80 × 8 + 20 × 12) / (80 + 20) = (640 + 240) / 100 = 8.8%. Elemental magnesium in a stated blend mass = stated blend mass × blend assay ÷ 100, so 250 g of that blend contains 22 g, or 22,000 mg, of elemental magnesium. The stated blend mass can be the sum of the rows or a larger batch with exactly the same composition, not additional unentered material.

Use the same assay basis in every row, for example as-is. Mixing as-is with dry-basis values, or elemental with compound percentages, makes the result invalid. Each entered mass must be above 0. A theoretical percentage from a formula is not a lot assay. Use the lot assay for actual batch input calculations; a specification value may be used for development estimates, but is not the same as a lot result. For a component with no magnesium, enter both its mass and an assay of 0 so that it is included in the total mass.

What the number leaves out

The result is only a mass-weighted content figure from the numbers you typed. It does not mean the components are compatible, that the blend is uniform, or that the magnesium will stay dissolved or stable in a drink. Confirm the blend by analysis of a representative sample when a lot assay is needed.

Related technical guides