Workcell Arrivals 1 Piece Flow

When you need to establish a method of reading in the daily production schedule for a workcell or to create an outside entry form for all production information in a workcell or to start counting time when the first part of a new order is touched in the first workcell.

 This model is a template for reading in workcell schedules, order size, production times and routing. All of the attributes are provided to run a 12 station workcell.

Workcell Arrivals 1 Piece Flow model image

Where to Find the Model Object

The following model object will be used to create workcell arrivals 1 piece flow to import data into ProcessModel:

  • Workcell \ Workcell Arrivals 1 Piece Flow – LR / RL

Difficulty Level

  • Ease of Use: Moderate
  • Ease of Modification: Moderate

How to Use the Model Object

  1. Open Your Model: Open your model or create a new blank model.
  2. Insert the Model Object into Your Model: Locate the appropriate location in your model where you would like to place the model object, move the view to the location and then insert the model object.
  3. Connect to Your Model: Connect the InQ Station a1 to the rest of your model.

    connect Workcell Arrivals 1 Piece Flow to the rest of the model

  4. Open the Excel File: Right click on the Scheduled ArrivalsInput Sheet Excel icon and click on the third option from the bottom to open the Scheduled ArrivalsInput vx-x Excel file, where x-x represents the version number of the Excel file.opening Scheduled ArrivalsInput in Flexible Workcell Arrivals
    Before using this Excel file for the first time, or after changing your model name, make sure that a manual export of data is done via ProcessModel. From your model, click Tools \ Export Data, click ‘Yes’ to all prompts until the data export file opens, close the data file and then use this Excel file.

    Click Enable Content if promptedEnable Macro

  5. Setup the Excel File: Once the Scheduled ArrivalsInput vx-x Excel file opens click the 1. Setup button. This will instruct the Excel file to ping ProcessModel and fetch the name of all entities that have a Scheduled arrival from the active model and create new tabs for each entity. In our case we only have one entity called Part.

    tab created by entity name in Flexible Workcell Arrivals
    If you have multiple entities with a Scheduled route and only want to update one or more of the entities schedule you can delete the tabs of other entities. Make sure that you keep the tab with the buttons, change the name of the tab to reflect the name of another entity if the current entity name on the tab with buttons is not what you want to update, make sure that you keep the naming format: Ent (Entity-Name).

  6. Enter Raw Data:
    1. Copy your attribute names into the Excel file, from cell C7 onwards. Sample data is included.
    2. Copy your raw data into the Excel file, from cell A7 onwards. Make sure that you add all the attributes needed in your model and provide relevant values for them. Sample data is included.

      Have UK dates and time? Use the UK Dates Converter

      The attribute names must match to what you have in ProcessModel