Home

          

CELLS WORKFLOW NEXT-STEP BUILDER

 

The CELLS Next-Step Builder provides a natural way to populate the Administrator tables by using a spreadsheet.  The Administrator tables such as NEXT_STEP, DEFECTS, DOCUMENT, etc.. contain the instructions that the CELLS WORKFLOW software uses for the setup of process routing, linked documents, defects, users, etc.   Using the CELLS Next-Step-Builder you can enter data according to the flow of the process being described rather than entering data directly into the Administrator tables. 


Easily create your production routings that specify the steps that are used to manufacture your product.  The CELLS Next-Step Builder is a straight forward Excel route builder and creates new production process routings
in minutes.  You can create new process routings from scratch or import an existing process routing from CELLS Workflow then modify it and export it out as your new process routing.

cells mes product job tracking software

 

 

The Microsoft Excel file  “CELLS-Next-Step-Builder.xlsm”  is the  CELLS NEXT-STEP BUILDER  that will aid in creating your routing quickly.  This Excel file is located in the the directory that the CELLS Workflow software is installed to which is by default    c:\program files\cells    OR    c:\program files(x86)\cells . 

The CELLS NEXT-STEP BUILDER is meant to simplify creating process routings for CELLS WORKFLOW using a simple Excel spreadsheet interface. Process flows created in the CELLS NEXT-STEP BUILDER can be exported to the CELLS WORKFLOW database or Process flows in CELLS WORKFLOW can be imported from CELLS WORKFLOW to the CELLS NEXT-STEP BUILDER.

 

NOTE: It is very important to backup any CELLS database before it is used with the CELLS NEXT-STEP BUILDER.

 

 

TO INSTALL:  Simply use the Microsoft Excel file  "CELLS-Next-Step-Builder.xlsm" . The latest version of this Excel file is located in the the directory that the CELLS Workflow software is installed to which is by default    c:\program files\cells    OR    c:\program files(x86)\cells . 

 


TO USE: 
Instructions for use are available by clicking the "Instructions" button in the upper right of the "CELLS Next-Step Builder". For your convenience below I have copied those same instructions (see "INSTRUCTIONS").


ALSO NOTE: To show the detail on the Operation, right-click anywhere in a row in the spreadsheet.  On the dropdown menu that displays, click on the last item, which should be “Show Principal Operation Detail.”.

                                                                                                                                                next-step-builder-operation-detail-2


                                                                              
A new Excel spreadsheet will open with more detail on the Operation.

                                                                                                cells-next-step-builder-operation-detail


------------------------------------

 

 

INSTRUCTIONS:

 

 

INTRODUCTION

 

The CELLS Next-Step Builder provides a natural way to populate the NEXT_STEP table by using a spreadsheet.  You can enter data according to the flow
of the process being described rather than entering data directly into the NEXT_STEP table in a fragmented, out-of-order manner.

 

 

TABLES

 

To use the Builder, you first must have some understanding of four tables in the CELLS database:

 

    -  The OPERATIONS table describes the universe of actions or steps that can be applied to manufacturing units.  Examples are BAKE or SOLDER.  While
       some actions are built-in, most are defined by the user.

    -  The CONDITIONS table describes the outcomes of a step.  An examples is $PASS.  Again, some conditions are built-in, but the majority are defined
        by the user.

    -  The PROCESSES table names the sets of steps which produce particular manufactured goods.

    -  The NEXT_STEP table combines entries in the PROCESSES, OPERATIONS, and CONDITIONS tables to describe the sequence of steps a unit undergoes
        as it is manufactured.

 

 

CHANGING AN EXISTING DESCRIPTION OF A PROCESS IN THE NEXT_STEP TABLE

 

You can use the Builder to change the description in the NEXT_STEP table of a process or you can create a description of a new process.  Follow these steps for changing the NEXT_STEP table for a process:

 

    1.  Select the Flow sheet.

    2.  Click the Read from Database button.

    3.  Click the dropdown arrow in the cell under Process and select a process.

    4.  Click the Read from Database button again.  You should see the relevant steps for the process displayed.

    5.  You can now change the flow.  For the most part, you can treat the spreadsheet as you would any spreadsheet.  Specifically, you can repeatedly do the following:

        a.  Change an operation or a condition in a cell.  There are three ways:

            i.  Click the cell, click the dropdown arrow for the cell, and select an operation/condition.

            ii. Double-click the cell and type an existing operation/condition.

            iii.Double-click the cell and type a new operation/condition.  The Builder will prompt you for information that describes the new operation/condition.

        b.  Delete operations or conditions in one or more cells by selecting a range of cells and clicking the delete key.

        c.  Delete one or more entire rows.

        d.  Insert rows.

        e.  Cut and paste ranges and rows.

    6.  You have the option of changing data in the other sheets in the workbook, namely CONDITIONS, NEXT_STEP, OPERATIONS, and PROCESSES. 
         Any changes you make to these sheets will be reflected in the Flow sheet.

    7.  When you are satisfied with the state of the description of the steps in the process, click the Write to Database button to save the data.  Changes to data in
         any of the sheets will be written to the database.

 

 

ADD A NEW DESCRIPTION OF A PROCESS IN THE NEXT_STEP TABLE

 

Follow these steps for adding a new process description to the NEXT_STEP table:

 

    1.  Select the Flow sheet.

    2.  Click the Read from Database button.

    3.  Double-click the cell under Process and enter the name of a new process.  The Builder will prompt you for information about the process.

    4.  The Builder does not change any data on the spreadsheet after you enter a process name.  In this way, you can use data from a previously displayed

         process, for example, as a starting point in describing the new process.

    5.  You can now create the flow.  For the most part, you can treat the spreadsheet as you would any spreadsheet.  Specifically, you can repeatedly do
          the following:

        a.  Add or change an operation or a condition in a cell.  There are three ways:

            i.  Click the cell, click the dropdown arrow for the cell, and select an operation/condition.

            ii. Double-click the cell and type an existing operation/condition.

            iii.Double-click the cell and type a new operation/condition.  The Builder will prompt you for information that describes the new operation/condition.

        b.  Delete operations or conditions in one or more cells by selecting a range of cells and clicking the delete key.

        c.  Delete one or more entire rows.

        d.  Insert rows.

        e.  Cut and paste ranges and rows.

    6.  You have the option of changing data in the other sheets in the workbook, namely CONDITIONS, NEXT_STEP, OPERATIONS, and PROCESSES. 
         Any changes you make to these sheets will be reflected in the Flow sheet.

    7.  You have the option of changing data in the other sheets in the workbook, namely CONDITIONS, NEXT_STEP, OPERATIONS, and PROCESSES. 
         Any changes you make to these sheets will be reflected in the Flow sheet.