Formula Grid Columns Reference

You can configure which columns of information are visible in the formula grid.

See Also
Formula Grid Overview
Adding, Moving, and Deleting Columns
Resizing Columns
Aligning Column Text and Renaming Columns
Special Column Types
Adding, Moving, and Deleting Rows
Expanding and Collapsing All Rows
Undoing and Redoing Actions in the Formula Grid

Below are listed all the columns that you can select to include in the formula grid. Some columns are editable. Other columns' values are calculated, or derived from external sources, and therefore non-editable in Formulation Design. For more information, see "Adding, Deleting, and Moving Columns."

Column Name

Description

7th Amendment Combined % In Formula (Dry)

The combined percentage in the formula, after processing of the ingredient from all bases and composites. The field, used for identifying a 7th Amendment allergen, should be on or off label.

7th Amendment Combined % In Formula (Wet)

The combined percentage in the formula, before processing of this ingredient from all bases and composites. The field, used for identifying a 7th Amendment allergen, should be on or off label.

Activity

The percentage of the active or target material in a composition. For composites, the Activity value is calculated from the percentage of the target material in the composition. You can edit this value to change the level of the target materials. You can only change the Activity for a composite material if it has at least one ingredient identified as a target. Activity calculations are based on on-label ingredients. Off-label ingredients are ignored.

CAS Number

The Chemical Abstract Service (CAS) identification number of the ingredient's material.

Chemical Name

The ingredient's name under the IUPAC naming system.

Color Index

The Color Index (CI) Number of the ingredient. CI numbers identify materials recognized as colorants. They are used in the compilation of Master Lists of Ingredients (MLI).

Compendial Name

An industry-recognized standard name for the ingredient.

Cost/kg

The cost charged by the supplier for one kilogram of the ingredient.

Cost in Formula

The cost contribution of the ingredient to the total cost of the batch.

Cost per Piece

The cost contribution of the ingredient to the total cost of one sales unit of the batch.

Combined % In Formula (Dry)

The total dry percentage of the ingredient, combined from all phases, and from within composites. Useful for regulatory calculations.

Combined % In Formula (Wet)

The total wet percent of the ingredient, combined from all phases, and from within composites. Useful for regulatory calculations.

Dry %

The percentage of the ingredient that the formulator wants the batch to contain after processing losses are taken into consideration.

Dry % (active)

The percentage of the ingredient, on an active basis, that the formulator wants the batch to contain after processing losses are taken into consideration.

Dry % (v/v active)

Dry % (v/v)

Dry % (v/w active)

Dry % (v/w)

Dry % (w/v active)

Dry % (w/v)

Dry % (w/w active)

Dry % (w/w)

v/v, v/w, w/v, and w/w ratios. These are ratios comparing an ingredient's unit of measure with those of the total batch.

The Dry % v/v is the ratio of the volume of the ingredient to the volume of the batch after processing losses are taken into consideration.

The Dry % v/w is the ratio of the volume of the ingredient to the weight of the batch after processing losses are taken into consideration.

The Dry % w/v is the ratio of the weight of the ingredient to the volume of the batch after processing losses are taken into consideration..

The Dy % w/w is the ratio of the weight of the ingredient to the weight of the batch after processing losses are taken into consideration.

Ratios listed as "active" are for the active portion of the ingredient.

Dry Activity

The activity of the ingredient after processing losses are taken into consideration. See Activity.

Dry Wt

The weight of the ingredient that the formulator wants the batch to contain after processing losses are taken into consideration.

Dry Wt (active)

The weight of the active ingredient that the formulator wants the batch to contain after processing losses are taken into consideration.

INCI Name

The name by which the ingredient is recognized in Europe under the International Nomenclature for Cosmetic Ingredients (INCI).

IU’s per gram

The International Unit measuring vitamin potency of the ingredient per gram.

IU’s per piece

The International Unit measuring vitamin potency of the ingredient per formula sale or use unit size.

Linked Formula #

The ID of the formula from which the formulated material was created.

Material ID

The ID of the material in the materials database

Material ID (Display)

The ID of the material for display. For formulated materials, this is the Formula # of the material's formula. For other materials, it is the same as the Material ID.

Material Name

The name of the material from which the ingredient derives.

Material Type

The type of the material from which the ingredient derives: Sourced, Formulated, or Unified.

Max Wt

The maximum percentage of the ingredient that regulatory constraints allow to be used in a production formula.

Max Level

The maximum amount of the material that regulatory constraints allow to be used in a product without a warning.

Max % (w/w)

The upper limit of tolerance from the wet % (w/w) for a substance.

Min % (w/w)

The lower limit of tolerance from the wet % (w/w) for a substance.

Min Wt

The lowest amount of the ingredient that can be added to the formula without tripping the “Weight out of range” alert used in batching.

Molecular Weight

The mass of one molecule of the ingredient.

Moles

The amount of the ingredient based on Avogadro’s number (6.022x1023).

Off Label % (Dry)

The percentage of the ingredient that you want batches to contain, after processing losses are taken into consideration, that will not appear on the product label.

Off Label % (Wet)

The percentage of the ingredient that you want batches to contain, before processing losses are taken into consideration, that will not appear on the product label.

Off Label Per Piece Dry Wt

The amount of the ingredient that you want to be in a single sales unit of the product that does not appear on the label. Calculate the amount based on the piece size, on the assumption that off-label materials have a no processing loss. For example, if there is arsenic in the product, you cannot include a processing loss, because of regulatory considerations. In such an instance, the per-piece calculation is therefore straightforward.

Off Label Per Piece Wet Wt

The amount of the ingredient that you want to be in a single sales unit of the product that does not appear on the label, before processing losses are taken into consideration.

Off Label Wt (Dry)

The amount of the ingredient that you want the formula to contain, after processing losses are taken into consideration, that does not appear on the label.

Off Label Wt (Wet)

The amount of the ingredient that the formula contains, before processing losses are taken into account, that does not appear on the label.

Ordering %

The percentage of the ingredient that you intend to procure.

Ordering % Cost in Formula

The percentage contribution of the ingredient towards the total ordering cost of the formula. This is based on the Ordering Cost in Formula.

Ordering Cost in Formula

The percentage cost contribution of the ingredient to the cost of the total procured amount of the batch.

Ordering Cost per Piece

The cost contribution of the procured amount of the ingredient to the total cost of the batch.

Ordering Wt

The total weight of the ingredient that you intend to procure. Formulation Design calculates this by adding the overage to the weight weight. You can edit this value from the calculated value.

Ordering Wt in Formula

The net procured amount of the ingredient that is delivered in the formula.

Overage %

The percentage excess of the ingredient that the formula includes to compensate for processing losses (for example, due to some of the ingredient remaining stuck to the sides of the container or mixer blades).

Overall %

The percentage of the ingredient that the formula includes when off-label ingredients are taken into consideration. If the ingredient is a QS ingredient, and the formula includes off-label ingredients, the value in this column is less than the Wet %, because it accounts for the off-label ingredients.

Overall % (Dry)

The percentage of the ingredient the formula includes when processing losses and off-label ingredients are taken into consideration. If the ingredient is a QS ingredient, and the formula includes off-label ingredients, the value in this column is less than the Dry %, because it accounts for the off-label ingredients.

Overall % in Formula

The percentage of the ingredient or constituents that the formula includes when off-label ingredients are taken into consideration.

Overall % in Formula (Dry)

The percentage of the ingredient or constituents that the formula includes when processing losses and off-label ingredients are taken into consideration.

Per Piece Dry %

The normalized percentage of the ingredient in one sales unit of the formula, after processing losses are taken into consideration. This value is formula-specific, and is not in the materials database.

Per Piece Dry % (active)

The normalized active amount of the ingredient in one sales unit of the formula, after calculating processing losses are taken into consideration. This value is formula-specific, and is not in the materials database.

Per Piece Dry Wt

The amount of the ingredient in one sales unit of the formula, after calculating processing losses are taken into consideration. This value is formula-specific, and is not in the materials database.

Per Piece Dry Wt (Active)

The active amount of the ingredient added to one sales unit of the formula, after processing losses are taken into consideration.

Per Piece Ordering Weight

The amount of the ingredient to order from stock for one sales unit of the formula. This value is formula-specific, and is not in the materials database.

Per Piece Wet %

The normalized percentage of the ingredient added to one sales unit of the formula, before processing losses are taken into consideration. This value is formula-specific, and is not in the materials database.

Per Piece Wet Wt

The amount of the ingredient added to one sales unit of the formula, after processing losses are taken into consideration. This value is formula-specific, and is not in the materials database.

Percent Cost in Formula

The percentage cost contribution of the ingredient to the total cost of this batch.

Preferred Name

A name specified by the customer to describe an ingredient.

Processing Loss

The amount of the ingredient that is lost during processing; for example, through steam or evaporation during boiling or baking. This value represents the difference between the Wet % and the Dry % values. The loss is recorded in this column, so that the final amount is known. After you enter a processing loss, Formulation Design recalculates the other ingredients to compensate for the loss.

Ratio

The ratio comparing an ingredient's unit of measure to those of the total batch (v/v, w/w, and so on).

Restrictions

Regulatory or other types of limitations on how an ingredient can be used in a product. This information is pulled from the material database and is entered by the material administrator.

Selected Function

The intended purpose of this ingredient in the formula. The value is chosen from the values available in the materials database.

Specific Gravity

The ratio of the mass of the ingredient compared to that of water at standard temperature and pressure (STP).

State

The maturity of the ingredient in terms of its readiness for approval for production usage.

Supplier Name

The name of the preferred vendor for the ingredient.

Supplier UID

The unique number assigned to the ingredient by the supplier.

Target % Added

The percentage of an ingredient or constituent in the formula. For constituents, this is different from the Wet %, which is their percentage in the parent ingredient.

Target % Added (Dry)

The percentage of an ingredient or constituent in the formula after processing losses are taken into consideration. For constituents, this is different from the Dry %, which is their percentage in the parent ingredient.

Target Conc.

The total wet percentage of the target constituents in a composite ingredient, relative to the ingredient's entire composition.

Target Percent

The sum of the percentage added to the formula of all target constituents in a composite ingredient.

Target Weight Added

The weight of an ingredient or constituent that is delivered to the formula.

Target Weight Added (Dry)

The weight of an ingredient or constituent that is delivered to the formula after processing losses are taken into consideration.

Trade Name

The name used as the brand for an ingredient by a supplier, vendor, or distributor.

Trivial Name

A general name for the ingredient that is not recognized according to the rules of any formal system.

USAN

United States Adopted Name. Used for nonproprietary names of drugs adopted by a committee of medical professionals and drug manufacturers in the USA.

Units

The weight or volume units, selected by the formulator, in which to display the ingredient quantity.

Wet %

The percentage of the ingredient that the formulator intends to add to the batch.

Wet % (active)

The active percentage of the ingredient that the formulator intends to add to the batch.

Wet % (v/v active)

The active percentage of the ingredient that the formulator intends to add to the batch, with both the ingredient amount (the numerator) and the formula batch amount (the denominator) measured as volume.

Wet % (v/v)

The percentage of the ingredient that the formulator intends to add to the batch, with both the ingredient amount (the numerator) and the formula batch amount (the denominator) measured as volume.

Wet % (v/w active)

The active percentage of the ingredient that the formulator intends to add to the batch, with the ingredient amount (the numerator) measured as volume, and the formula batch amount (the denominator) measured as weight.

Wet % (v/w)

The percentage of the ingredient that the formulator intends to add to the batch, with the ingredient amount (the numerator) measured as volume, and the formula batch amount (the denominator) measured as weight.

Wet % (w/v active)

The active percentage of the ingredient that the formulator intends to add to the batch, with the ingredient amount (the numerator) measured as weight, and the formula batch amount (the denominator) measured as volume.

Wet % (w/v)

The percentage of the ingredient that the formulator intends to add to the batch, with the ingredient amount (the numerator) measured as weight, and the formula batch amount (the denominator) measured as volume.

Wet % (w/w active)

The active percentage of the ingredient that the formulator intends to add to the batch, with both the ingredient amount (the numerator) and the formula batch amount (the denominator) measured as weight.

Wet % (w/w)

The percentage of the ingredient that the formulator intends to add to the batch, with both the ingredient amount (the numerator) and the formula batch amount (the denominator) measured as weight.

Wet Wt

The weight of the ingredient that the formulator intends to add to the batch.

Wet Wt (active)

The weight of the active ingredient that the formulator intends to add to the batch.