Spreadsheet: 75051d1275573783-conditional-equations-example-9
Sheet: TRIAL SHEET

 |  |  |  |  |  |  |  |  |  |  |  |  |  | RESTRICTIONS
 | customer | CORIN BROOM |  | [NAME] | n/a |  |  |  | Application | Injection |  |  |  | CONEG |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rev 0.1
 | LRN | 03-226 |  | Process Temp.: | 400- 450 F |  |  |  | Date |  |  |  |  | FDA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Intermediate Calculations Sheet |  |  |  |  | 2007-08-02 00:00:00
 | %LDR | AS REQUEST |  | L/D Resin: | Co-PP |  |  |  | Description | Blue |  |  |  | NONE | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Trial LDR (%) | Trial Size (g)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.05 | 300
 |  |  |  |  |  | ER1 |  | ER2 |  | ER3 |  | ER4 |  | ER5 |  | ER6 |  | ER7 |  | ER8 |  | ER9 |  | ER10 |  | ER11 |  | ER12 |  | ER3 |  |  |  |  |  |  |  |  | Intermediate in Formula (g) | Intermediate Loading (%) | Intermediate in Trial (%) | Pigment in Final Formula (%) |  |  | Instructions
 | Raw Material Code | Description | Intermediate Concentration | FCM or HIDM | Intermediate Code | AS REQUEST | T1 | AS REQUEST | T2 | AS REQUEST | T3 | AS REQUEST | T4 | AS REQUEST | T5 | AS REQUEST | T6 | AS REQUEST | T7 | AS REQUEST | T8 | AS REQUEST | T9 | AS REQUEST | T10 | AS REQUEST | T11 | AS REQUEST | T12 | AS REQUEST
 | B500XXX | HDPE BF RESIN | 1 | RESIN | 2RM RESIN |  | 20 |  | 20 |  | 20 |  | 20 |  | 20 |  | 20 |  | 20 |  | 20 |  | 20 |  | 20 |  | 20 |  | 20 |  |  |  |  |  |  |  |  |  |  | 0.005 | #N/A | #N/A |  |  | 1. Enter Trial LDR and [NAME]
 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 0 |  |  |  |  |  |  |  |  |  | 0.01 | #N/A | #N/A
 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 0 |  |  |  |  |  |  |  |  |  | 0.05 | #N/A | #N/A |  |  | 2. Enter grams of intermediate in formula
 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 0.08 | #N/A | #N/A
 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 12 | 0.1 | #N/A | #N/A |  |  | or Enter Pigment Percent in formula
 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 0.15 | #N/A | #N/A
 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 0.2 | #N/A | #N/A
 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 0.25 | #N/A | #N/A
 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 4.5 | 0.5 | #N/A | #N/A |  |  | 3. View Pigment  % in final formula
 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 0.7 | #N/A | #N/A |  |  | or view amount of intermediate required in Trial
 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 0.75 | #N/A | #N/A
 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | B500192 | 20 MI RESIN | 1 | RESIN | B500192 | 68 |  | 100 |  | 76.5 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 54 |  | 76.5 |  |  |  |  |  |  |  |  | Pigment in Formula (%) | Intermediate Loading (%) | Pigment in Trial (%) | Intermediate In Trial (%) | Intermediate Required in Trial (g)
 | B800103 | B900 Antioxidant | 1 | A/O | B800103 | 0 |  |  |  | 0.2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 0.2 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | B800507 | CaCO3 FT | 1 | Filler | B800507 | 0 |  |  |  | 21.8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 |  | 21.8 |  |  |  |  |  |  |  |  |  | 0.005 | #N/A | #N/A | #N/A
 | B800702 | [NAME] | 1 | Zinc Stearate | B800702 | 32 |  |  |  | 1.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 1.5 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 0.005 | #N/A | #N/A | #N/A
 |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 300
 |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 0.005 | #N/A | #N/A | #N/A
 |  |  |  |  | TOTAL = | 100 | 20 | 100 | 20 | 100 | 20 | 100 | 20 | 100 | 20 | 100 | 20 | 100 | 20 | 100 | 20 | 100 | 20 | 100 | 20 | 100 | 20 | 100 | 20 |  |  |  |  |  |  |  |  |  |  | 0.01 | #N/A | #N/A | #N/A
 |  |  | STD OPACITY/OD= |  | TRIAL OPACITY/OD= |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.05 | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.08 | #N/A | #N/A | #N/A
 |  | FINAL FORMULA |  | 300 gram Trial | 1000 gram Trial | Superconcentrate |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13.5 | 0.1 | #N/A | #N/A | #N/A
1 | B500192 | 20 MI RESIN | 76.5 |  |  | Enter Scale Up #= |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.15 | #N/A | #N/A | #N/A
2 | C |  | 0 |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13.5 | 0.2 | #N/A | #N/A | #N/A
3 | C |  | 0 |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.25 | #N/A | #N/A | #N/A
4 | C |  | 0 |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5 | #N/A | #N/A | #N/A
5 | C |  | 0 |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.7 | #N/A | #N/A | #N/A
6 | C |  | 0 |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.75 | #N/A | #N/A | #N/A
7 | C |  | 0 |  |  | #N/A
8 | C |  | 0 |  |  | #N/A
9 | C |  | 0 |  |  | #N/A
10 | C |  | 0 |  |  | #N/A
11 | C |  | 0 |  |  | #N/A
12 | C |  | 0 |  |  | #N/A
13 | B800103 | B900 Antioxidant | 0.2
14 | B800507 | CaCO3 FT | 21.8
15 | B800702 | [NAME] | 1.5
16 | C |  | 0
17 | C |  | 0
18 | C |  | 0
 | %LDR | AS REQUEST