Reactor Examples inJChemforExcelUsage Reactor

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)

images/jchem-for-office-docs.chemaxon.com/jchem4excel/userguide/functions.reactor.3.zoom78.png
Functions.Reactor.3

Insert the "JCReactProductStructure" function with the following parameters:

  • Reaction=$A$1

  • Reactant1=$A2

  • Reactant2=B$1

into the B2 cell.

images/jchem-for-office-docs.chemaxon.com/jchem4excel/userguide/functions.reactor.2.png
Functions.Reactor.2

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.

images/jchem-for-office-docs.chemaxon.com/jchem4excel/userguide/functions.reactor.1.zoom63.png
Functions.Reactor.1

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)

images/jchem-for-office-docs.chemaxon.com/jchem4excel/userguide/functions.reactor.6.png
Functions.Reactor.6

Insert the "JCReactProductStructure" function with the following parameters:

Reaction=$A$1

Reactant1=$B$2

ProductListNumber=A3

into the B3 cell.

images/jchem-for-office-docs.chemaxon.com/jchem4excel/userguide/functions.reactor.5.png
Functions.Reactor.5

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.

images/jchem-for-office-docs.chemaxon.com/jchem4excel/userguide/functions.reactor.4.png
Functions.Reactor.4

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)

images/jchem-for-office-docs.chemaxon.com/jchem4excel/userguide/functions.reactor.3.zoom78.png

Insert the "JCReactReactionStructure" function with the following parameters:

Reaction=$A$1

Reactant1=$A2

Reactant2=B$1

into the B2 cell.

images/jchem-for-office-docs.chemaxon.com/jchem4excel/userguide/functions.reactor.7.png
Functions.Reactor.7

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.

images/jchem-for-office-docs.chemaxon.com/jchem4excel/userguide/functions.reactor.8.zoom66.png
Functions.Reactor.8

Constructed reactions are displayed in the cells of the B2-G7 range.