Usage
Example 1: JCReactProductStructure function constructs a possible product for each reactant pair.
-
A1 cell contains the reaction scheme (Reaction)
-
A2-A7 cells contain nucleophile reactants (Reactant1)
-
B1-G1 cells contain isocyanate reactants (Reactant2)
Insert the "JCReactProductStructure" function with the following parameters:
-
Reaction=$A$1
-
Reactant1=$A2
-
Reactant2=B$1
into the B2 cell.
B2=JCReactProductStructure($A$1;$A2;B$1)
Copy the function from the B2 cell to the other cells of the B2-G7 range by dragging.
Constructed products are displayed in the cells of the B2-G7 range.
Example 2: JCReactProductStructure function constructs multiple products.
• |
A1 cell contains the reaction scheme (Reaction) |
• |
B2 cell contains the reactant (Reactant1) |
• |
A3-A10 cells contain product list numbers (ProductListNumber) |
Insert the "JCReactProductStructure" function with the following parameters:
• |
Reaction=$A$1 |
• |
Reactant1=$B$2 |
• |
ProductListNumber=A3 |
into the B3 cell.
B3=JCReactProductStructure($A$1;$B$2;;;A3)
Copy the function from the B3 cell to the other cells of the B3-B10 range by dragging.
Constructed products are displayed in the cells of the B3-B9 range. There is no product list for number 8 - it means that there are 7 possible products.
Example 3: JCReactReactionStructure function constructs a possible reaction for each reactant pair.
• |
A1 cell contains the reaction scheme (Reaction) |
• |
A2-A7 cells contain nucleophile reactants (Reactant1) |
• |
B1-G1 cells contain isocyanate reactants (Reactant2) |
Insert the "JCReactReactionStructure" function with the following parameters:
• |
Reaction=$A$1 |
• |
Reactant1=$A2 |
• |
Reactant2=B$1 |
into the B2 cell.
B2=JCReactReactionStructure($A$1;$A2;B$1)
Copy the function from the B2 cell to the other cells of the B2-G7 range by dragging.
Constructed reactions are displayed in the cells of the B2-G7 range.