Special Column Types | ||
| ||
Static Columns
The three columns on the left of the formula grid are static (you cannot move or delete them), and have special purposes:
The first column has a grab pad
for each row, with which you can move the
row up and down the grid. It also has a selection box 
, that you can click to view properties for
the row.- The second column shows icons for each row that indicate properties of the row, such as the functionality of ingredients, and whether the row is for a phase.
- The third column shows the indices of ingredients and processing instructions in the formula. Ingredients are numbered starting from 1, and processing instructions are numbered Pn, where n is the index of the processing instruction, starting from 1.
Calculated Value Columns
With a calculated column value, the calculation is performed on the wet weight values. For example, consider the following formula grid, shown schematically:
|
# |
Material ID |
Material Name |
Wet Wt |
Processing Loss |
Dry Wt |
Wet % |
Dry % |
Units |
||
|---|---|---|---|---|---|---|---|---|---|---|
 |
P1 |
|||||||||
 |
 |
New Phase |
700.0000 |
20.0000% |
560.0000 |
70.0000% |
67.46988% |
g |
||
 |
1 |
RMP-0760 |
Supplier Material A |
700.0000 |
20.0000% |
560.0000 |
70.0000% |
67.46988% |
g |
|
|
|
New Phase 2 |
300.0000 |
10.0000% |
270.0000 |
30.0000% |
32.53012% |
g |
||
|
2 |
RMP-8835 |
Supplier Material B |
300.0000 |
10.0000% |
270.0000 |
30.0000% |
32.53012% |
g |
|
 |
 |
TOTALS: |
1000.0000 |
17.0000% |
830.0000 |
100.0000% |
100.0000% |
g |
The ingredient Supplier Material A has a Wet Wt in the formula of 700 g. The chemist determines that Supplier Material A undergoes a processing loss of 20%. Therefore, Formulation Design calculates the Dry Wt of Supplier Material A to be 560 g — that is, 80% of 700 g.
The Wet % value of 70 is the percentage of Supplier Material A in the formula before processing, based on the ingredient's wet weight.
The Dry % value of 67.46988 represents the percentage of Supplier Raw Material A contributing to the formula total after processing loss. The Dry % is not calculated directly from the Dry Wt. This is because different ingredients can undergo different processing losses, and therefore their relative percentage contributions can change during processing. Instead, the Dry % is calculated from the total dry weight of the formula — that is, the sum of the dry weight of all ingredients in the formula..
Informational and Description Columns
Some columns contain non-editable text that is supplied from the material and subtance properties in Materials Management and Materials Registration. For example, in the following formula grid, the Chemical Name is defined in the material properties. You cannot edit this value in Formulation Design. The Processing Note text is defined in the properties of the material.
|
# |
Material ID |
Material Name |
Wet Wt |
Chemical Name |
Processing Note |
Units |
||
|---|---|---|---|---|---|---|---|---|
|
P1 |
|||||||
|
|
New Phase |
700.0000 |
New Phase |
g |
|||
|
 |
1 |
RMP-0760 |
Supplier Material A |
700.0000 |
Sodium Laurel Sulfate |
Boil until reduced by 20% |
g |
|
|
New Phase 2 |
300.0000 |
New Phase 2 |
g |
|||
|
2 |
RMP-8835 |
Supplier Material B |
300.0000 |
g |
|||
|
|
TOTALS: |
1000.0000 |
TOTALS: |
g |