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.