UNISOFT CELLS QUICK START MANUAL

Thank you for installing the Unisoft CELLS MES Product Tracking software. Below you will find instructions for configuring CELLS and the "How to use CELLS" tutorial. We have supplied a sample database for our tutorial.  The database contains 200 serialized units contained in one work order and 10 subassemblies in another workorder and the units are in the process of being assembled.  The sample database supplied is particular to an Electronic Manufacturer. The Electronics industry has complex manufacturing processes and demonstrates the depth of the CELLS software.  CELLS can track product for any industry, please contact Unisoft for sample databases that represent other industries. To get started now please skip to the “CONFIGURATION” section below.
 

CELLS PRODUCT TRACKING software (www.unisoft-cim.com/cells.html) has a track record of success since 1996. We are available at any time to help you become comfortable with its ease of use and powerful features for automating and integrating shop floors in a paperless environment. CELLS is a fully integrated Manufacturing Execution System (MES) that provides Process Control and Traceability with - Tracking (product, inventory, and quality), Workflow/Routing, Data Collection, and Document Delivery. CELLS is fully Internet enabled.
 

Let’s get started: In the CONFIGURATION section below you will: 1) Setup the type of database you wish CELLS to be connected to.  In the STARTING THE SOFTWARE section below you will get a good idea of how CELLS works by moving product forward in a process routing (next step) provided.   The product chosen for assembly in the sample database are PC Boards that an electronics manufacturer would build. CELLS is also ideal for application in the Medical Device, Semiconductor, Aerospace, Chemicals, Pharmaceuticals, Foods, or any General Manufacturing industries.

It is our pleasure to assist you and make sure the software is up and running quickly.  Please feel free to contact us. Also a CELLS tutorial movie is available for later review. The movie icon “CELLS Product Tracking Tutorial Movie” is located in the Start/Programs Menu under the "Unisoft CELLS Product Tracking Software" folder.

Sincerely, 

Customer Support
cellssupport@unisoft-cim.com
(203) 913-0782 or (888) 486-4246

REQUIREMENTS:

COMPUTER -  PC running Windows 95 or newer.  Approx. 100 megabytes of hard drive space is required. 

DATABASE -  Microsoft Access will serve as our database for demonstrations and smaller license site applications. For larger sites SQL or Oracle databases are most commonly used.

CONFIGURATION:

CONNECTING THE ODBC DRIVER TO THE DATABASE:

Connect the ODBC driver to the sample database.  For this demonstration the sample database we will be using is Microsoft Access. CELLS complies with Microsoft’s ODBC database standard and therefore can be used with any ODBC compliant database such as Oracle, Microsoft SQL Server, etc.

To setup the ODBC link to the sample database: 

1)     From WINDOWS click START, SETTING and CONTROL PANEL.

2)     In the CONTROL PANEL folder click ODBC DATA SOURCES (Note: If you do not see the ODBC DATA SOURCES icon then click ADMINISTRATIVE TOOLS then click DATA SOURCES ODBC).

3)     Then click the SYSTEM DSN tab, click ADD, then select MICROSOFT ACCESS DRIVER (*.MDB), then click FINISH and a new window will open. 

4)     In the DATA SOURCE NAME field type CELLS in the DESCRIPTION field type CELLS then click the SELECT button and point to C:\PROGRAM FILES\CELLS\CELLS32.MDB, click OK and close out the open Windows.

STARTING THE SOFTWARE:
 

In this procedure we will:

- create a new workorder in CELLS

- log onto CELLS

- open a unit

- add sub-assemblies

- move a unit to the next operation step

- view the history of units
         - generate reports on Work Order status

- how to reset the sample database

- creating a routing in CELLS for one of your own products

Creating a New Workorder:

Using the Cells Administrator to create a new Workorder:

NOTE:  Actions required by you are in BOLD. We recommend printing this document out and following along.

1.       Open the Cells Administrator by double clicking on the Cells Administrator icon located in the Start/Programs Menu under the "Unisoft CELLS Product Tracking Software" folder. Once the Administrator window is open select open workorder from the File>Open> Workorder.  Click workorder wo000021 then click OK.  We’ll use this as a template.

2.       Once open you’ll notice the next highest buttons on the right…Click on the work order next highest which will scan the database for the next unique workorder which will be wo000025.  Enter 100 for the quantity, and then click on the next highest button located next to the starting serial number field.  The ending serial number is automatically entered.  On the Assembly ID field select browse….You’ll see the available assemblies to choose from…for this example we’ll select assy0001.  The sales order field is an open text field to associate data such as purchase orders.  You can leave this blank.  Select browse next to the Process Id and select proc0001 commercial product.  The revision field is also an open text field to identify revision.

3.       Once completed select save and a verification that a new record was added will pop up, click OK.  This signifies that the workorder can now be accessed.  Click CLOSE and File > Exit from the Administrator.

Logging onto CELLS:

To log on to the CELLS system:

1.       Start CELLS by clicking the CELLS Product Tracking icon located in the Start/Programs Menu under the "Unisoft CELLS Product Tracking Software" folder.   The Please Log In dialog box opens.  Note the status in the upper left corner is “Please Log On”

       In the Station box, type or select your station    –     Choose “Inspection – In-coming Station #1”

Note: The first time you log on to your station, you will have to enter your station number. Going forward you will not have to enter the station number unless you share a station.

2.       In the User Id box, type your Id.  Enter MARY.

3.       In the Password box, type your password.  Enter 4117 . 

4.       Click OK.   Note the status in the upper left is “User=’Mary’ .  Please open next unit” .
5.    The default display is set for General Manufacturing.  For this demo set the display to the Electronics industry.  Click VIEW from the main menu then click TOOLBARS then click ELECTRONICS MANUFACTURING.  The CELLS display is now set for Electronics Manufacturing.

 

Opening Units:

CELLS offers several flexible ways to open units and find available work. You can open units by one of the following methods:

·   Open From List - Open from a list of available units in a selected operation. This method can find work available anywhere on the production floor.

·   By Serial Number – Opens a specific unit via serial number.

·   By Work Order and Quantity – Opens the work order and shows total units. User picks units and quantity to work on.

·   By Event ID – If a unique Event ID number was assigned in an earlier operation then that unit can be opened by that Event ID number.  An Event ID number maybe assigned for example when a unit fails and the part that is bad is removed and saved with the Event ID number. Anytime later the bad part can be traced back to the original unit via the Event ID number.

Open From List - Opening a unit from a list of available units

This method of locating an assembly from a particular operation helps to expose the inventory available.

1.       On the File menu, click Select Operation. The Select an operation dialog box opens.   (Note: in some areas of the production floor you may wish to limit or simplify the actions of the User.  For example you could remove the keyboard completely and the User can then only scan in actions from a sheet of paper or if you have the correct hardware the User can scan the actions directly from the screen display to keep the environment totally paperless.).
 

2.       Select PROC0001 ININ Incoming Inspection, click OK.

3.       It might seem that nothing has happened but by looking at the very top in the Blue bar of the Cells window you’ll notice that the op=inin has appeared.  This flags the Cells environment to pull all available workorders for this operation.  

4.       Reopen the file menu and select Open From List. A window opens telling you the current work order/Units at this particular operation (In this example Incoming Inspection).    Select workorder WO000025 and double click to activate your selection.  In the quantity window type 5 units, click OK.  This is the workorder that was just created.

5.     A Task List box should open and the assembly will appear in the background.  Note that CELLS has opened the relevant main document on the display for this operation. Also for this operation the task of data collection has been invoked and date code & part lot code data will be collected.  Also if you click VIEW from the main menu you will see available views and documents allowed at this operation that the operator has access to. Feel free to explore them. CELLS is fully Internet enabled. Any view, document, movie etc. that you can see on a typical website you can display in CELLS and more.  Create documents with CELLS or with any popular program (for example use MS Word or MS FrontPage to create a “intranet” series of linked HTML documents just as you would to create a website except they will be displayed via CELLS).  Use any internet plug-in for MS WORD, Adobe PDF, etc, without limit. 

6.     The “Tasks to do at this operation” box is displayed.  CELLS has been told to collect lot and pn date codes at this operation.  Click to select the first item in the list then click edit and type 0403 for a date then click OK and repeat this for the other Task items in the box.  Click OK and note the status indicator in the upper left.  The data collected is now stored in the history table.   Note: Once your work-in-progress, failure/quality or other data is in the CELLS database, you can report against it with CELLS or any report writer or analysis tool that supports ODBC (Crystal Reports, Access, SAS, Excel, etc.). You can even publish the reports to your CELLS intranet, or provide dynamic report generation through CELLS or any web browser. Also standard reports are available from the main menu by clicking REPORTS.

7.     We will now move the unit forward to the next operation.  Click FILE from the main menu then click NEXT STEP (you can also click the third icon from the left on the main menu).   We will choose the default “PASS” which moves the unit to “GOTO Board Prep”, click OK.  These 5 units have been passed forward and the status in the upper left for Mary is “Please open next unit”.  Note that other outcomes options are ELECTRICAL FAILURE and MECHANICAL FAILURE.  When creating a new routing in CELLS the Next Step and Outcome options are unlimited.

Open By Serial Number

After the serial number is entered, the system then goes through a series of checks.

®      Checks to see if you are authorized to access the system.

®      Checks to see what is the next step.

®      Finds an assembly Id.

®      Finds associated information topics and documents.

®      Finds drawings and overlays associated with the serial number.

®        Finds the history for the serial number.

1.       On the File menu, click By Serial Number. The Enter Serial Number dialog box opens. Note the first icon “S/N” on the left of the top main menu is another way to enter a serial number.
 

2.       In the Serial Number box, type the serial number.  Type SN000104 (normally a barcode scanner would enter the serial number).

3.     Click OK. A window opens telling you the current operation and asking you if you want to perform that operation.    The current operation is “This Serial Number is supposed to go to Chip Shooter Topside”.  Note: The last page of this document “OVERVIEW OF SAMPLE DATABASE” displays the step in the routing for active serial numbers in this work order.

4.     Click Yes.  Click VIEW from the top menu and click ZOOM TO FIT.  Note that CELLS has opened the relevant main document on the display for this operation.  Also if you click VIEW from the main menu you will see available views and documents allowed at this operation that the operator has access to.   The programmed views and documents are numbered 1 through 10 at the bottom.  Feel free to explore them. Any view, document, movie, etc. can be display in CELLS (HTML, PDF, WORD, WMF, AVI, etc). Please make sure to set the view to #2 “electrical view” before proceeding to the next step.

5.     Lets view the Defect Analysis report under the view menu item #7.  Click VIEW and select “7 – Summary of Defects”.  This is a realtime bar graph representing failures related to reference designators and also a chart representing the defects by operation (note:  through the use of custom developed queries graphical representations of any type can be created from any of the tables within the CELLS database.).  Click the X in the upper right of the box to close this screen and lets log a defect under the file menu.  Lets assume Mary found an open pin on component CR501.1 .  Click FILE and click “Log a Defect” and the Enter History Item box appears, click the drop down selection next to Defect Code and select Electrical Open and then next to Component 1 choose CR501 from the drop down menu and type in 1 in the pin# text box then in the Remark box type “Etch Open Next to Pin” and click SAVE AND CLOSE.  Lets view the defect analysis report again to see that it has been updated in real time.  Click VIEW and select “7 – Summary of Defects” and you’ll see that there is a new entry of CR501.1 under Electrical Open.  To close click the X in the upper right of the box.

6.     We will now move the unit forward to the next operation.  Click FILE from the main menu then click NEXT STEP (you can also click the third icon from the left on the main menu).   We will choose the default “PASS” which moves the unit to “GOTO Top side dip”,  (Note that other outcomes options are ELECTRICAL FAILURE and MECHANICAL FAILURE),  click OK.  The unit has been passed forward and the status in the upper left for Mary is “Please open next unit”.  When creating a new routing in CELLS the Next Step and Outcome options are unlimited.

7.     Let’s have Mary open the same unit serial # sn000104 again and perform the next operation required.  Click the “S/N” icon, it is the first icon on the left of the main menu. Type sn000104 in the serial number field then click OK .  Click YES to perform the “Top side dip” operation.  Note that CELLS has opened the relevant main document on the display for this operation.  Also if you click VIEW from the main menu you will see additional available views and documents allowed at this operation that the operator has access to.  Click VIEW and select  “8 – Dip Setup Procedure” this is an example of a setup process online available for the operator,  click the X in the upper right of the box.

8.      Let’s assume the operation as been performed and click the NEXT STEP icon, it is the third from the left on the main menu. Click OK to use the default PASS to move the unit to the next operation “Odd Form Insert”.  

9.     In the steps above we have basically shown how a unit is routed in CELLS.  CELLS collects all relevant data such as date and time stamps, serial numbers, work order and lot numbers, operator ID of the person performing the operation, operation and tasks perform, defect codes, etc. all stored in the history database table.

Adding Sub-assemblies:

You can add or remove a subassy as follows. For this example a sub-assembly will be removed and a new one added:

Note:  The sub-assembly to pick from should be completed (i.e.: in the $done operation)

1.     Click the “S/N” icon, it is the first icon on the left of the main menu. Type sn000106 in the serial number field then click OK .  Displayed on the screen will be “This Serial Number is supposed to go to Functional Test”, click YES.

2.     From the file menu select add/remove subassy

3.     The popup will show that a subassy is installed in J1 but normally a subassy would not be installed. So here we are demonstrating the Remove Subassembly feature.

4.     Highlight the subassy to remove and then click on the remove button.  This location will now be free to install a new subassy.

5.     Click on the ADD button.

6.     A prompt will ask for a “Subassembly to Install”.  In this example sn000401 to sn000410 have been generated as a valid subassy pool to pick from.

7.     In the Serial Number field type sn000402.  A pop up box will ask if it’s ok to serialize this unit, select yes and click CLOSE.

8.     In summary, the subassy feature will track units based on a parent child relationship.  The history can also be viewed by double clicking the event under the view history option.  For example, from the main menu click VIEW then select This Unit History.  You’ll see in the EVENT column ADD SUBASSY.  Double-click this line item and the history of the subassy will be brought up. This parent child relationship can also be permutated as deeply as needed (i.e.: like peeling away the surface of an onion to expose more information underneath).  To close the box click the X in the upper right of the box.  Let’s assume the operation as been performed and click the NEXT STEP icon, it is the third from the left on the main menu. Click OK to use the default PASS to move the unit to “Packaging”.

Viewing History of Units :

You may wish to view the history of any unit to see where it’s been, what’s been done to it, or the defects that have occurred. CELLS provides you an easy way to find that information.

VIEW HISTORY

1. Click VIEW from the main menu and select Specific Unit History.
2. In the serial number field type sn000103 and click OK (do not enter any workorder data).
3. A history screen will appear for the module.  Double click on any item to view details.

Once you’re done, click on the close button in the upper right hand corner.

 

Reports – Report of Work Order status:

CELLS provides many reports. For example the simple quick report below is available from the Report menu and displays a Work Order Summary with one line per work order. It is viewable by current unfinished WIP, date range, etc.  

Click REPORTS from the main menu then select “Incomplete Work Orders” and click OK.  Displays similar to the ones below are shown.
 

Double click WO000021 on a work order line and a second drill-down report is displayed showing detailed status for each operation step in the work order.  For example the drill-down report for work order WO000021 in the figure below is reporting 183 units of the 200 total are at Incoming Inspection. 

How to reset the sample database: 

If you wish to reset to the original sample database do the following:   

1)     Copy the file  \program files\CELLS\images\cells32.mdb   to 
\program files\CELLS\   and replace the file already there.

Summary:  

CELLS is a fully integrated Manufacturing Execution System (MES) that provides Process Control and Traceability with - Tracking (product, inventory, and quality), Workflow/Routing, Data Collection, and Document Delivery.  

CELLS can be configured in an endless variety of ways to suit your manufacturing environment from Electronics to Medical Devices, Semiconductors, Aerospace, Chemicals, Pharmaceuticals, Foods, and General Manufacturing applications.  

It is our pleasure to assist you and make sure the software, workflow/routings, and tracking is up and running quickly.  Please feel free to contact us anytime. 

Note: Manuals 5 and 6 are the systems administer manuals and detail advanced information on setting up routings, etc. for new product. The file names are below and icons to each are located in the Start/Programs Menu under the "Unisoft CELLS Product Tracking Software" folder.

"C:\Program Files\CELLS\manuals\5-CELLS sysadmin.doc"

"C:\Program Files\CELLS\manuals\6-CELLS appendix1.doc"

For assistance of any kind please feel free to call 203-913-0782 or
cellssupport@unisoft-cim.com.

MISCELLANEOUS:  

-  MANUALS: 

1) CELLS MANUALS FOR ALL INDUSTRIES - Manual 4 below is the USER manual. Manual 5-6 are the SYSTEM ADMINISTER manuals.  Manual 1 is a basic Windows operation manual for personnel on the production floor that might be unfamiliar with basic Windows functions.  The file names are below and icons to each are located in the Start/Programs Menu under the "Unisoft CELLS Product Tracking Software" folder. 

"C:\Program Files\CELLS\manuals\4-CELLS operators.doc"

"C:\Program Files\CELLS\manuals\5-CELLS sysadmin.doc"

"C:\Program Files\CELLS\manuals\6-CELLS appendix1.doc"

"C:\Program Files\CELLS\manuals\1-windows usage guide.doc"

2) CELLS MANUALS FOR ELECTRONICS MANUFACTURING INDUSTRY ONLY – The VIEW and MARKUP manuals below outline how to view a detailed active PC Board assembly display within the CELLS environment.  The file names are below and icons to each are located in the Start/Programs Menu under the "Unisoft CELLS Product Tracking Software" folder. 

"C:\Program Files\CELLS\manuals\2-View.doc"

“C:\Program Files\CELLS\manuals\3-Markup.doc"

Overview of the sample database supplied:

The sample database (cells32.mdb) is supplied to simulate product being routed and tracked.  The database contains an active work order WO000021 in which there are 200 boards with serial numbers sn000101 through sn000300.  These boards are associated with the assembly number ASSY0001 and are being routed according to the process number PROC0001.  Subassy WO000023 has a total of 10 subassy sn000401-sn000410 with the assembly number as MOD1. The subassy workorder uses process number PROC0003. 

Six of the boards in this sample database are active Work In Process (WIP).  By active we mean that they have enter at least the first step of the assembly process PROC0001. The steps below define the sample process PROC0001 from start to finish and where these active units are in the process.  

NOTE: Any of the serial numbers sn000101-sn000300 that are not active can be started by entering its serial number.

Below on the right are the Process Routing (Next Step) for PROC0001 in the sample database.  The center column indicates the possible outcomes for next step in the routing. The right side column shows where the 6 active serial numbered units are currently in the process.

PROCESS STEP                                                                 POSSIBLE OUTCOMES                                SERIAL #’s

START