When Will You Need This?
When you need to provide for a setup when changing from one entity type (Name, Color, Style, Size, etc.) to another. Provide a method for reading the setup data from a Excel sheet concurrent with the arrivals.
The following Model Object will be used to import healthcare arrivals and other data into ProcessModel; Setup \ Setup.
Ease of Use: Easy
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
1. Locate the model object Setup and select the insert button.
2. Move the cursor to the point of insertion and left mouse-click. The upper left corner of the model object will be inserted at the location of the mouse-click.
3. Connect to Your Model
1. Connect the percentage route leaving Activity1 to the rest of your model.
4. Update Objects
1. Change the names of the attributes and variables to match your scenario.
2. Change the name of Activity1 to match your scenario.
5. 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.
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 prompted
6. 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 route from the active model and create new tabs for each entity. In our case we only have one entity called Part.
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).
7. Enter Raw Data
1. Copy your attribute names from ProcessModel into the Excel file, from cell C6 onwards. Overwrite the sample data 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. Overwrite the sample data included.
Have UK dates and time? Use the UK Dates Converter
The attribute names must match to what you have in ProcessModel
8. Import Data from the Spreadsheet to ProcessModel
Before clicking the 2. Update button you may select one of the following 3 options in order instruct ProcessModel what it needs to do.
1. Import Data: Selecting this option will import the data into ProcessModel after crunching the numbers and updating the exported Data file from ProcessModel. The Excel file will automatically export data from your model.
2. Simulate Model: Selecting this option will simulate the model after completing all the actions mentioned in Import Data. Simulation animation will be off.
3. Animation On: Selecting this option will simulate the model with animation on after completing all the actions mentioned in Import Data.
The model object is now integrated into your model, you should now be able to save and then simulate the model.
Attributes, Variables, Scenario Parameters and Scenarios usage
1. a_Style: Do not change. This attributes is used to distinguish what is required to cause a setup. The name could be changed to Color, Size, Name, or anything needed. Different attributes could be used for each activity. This allows a setup at one activity for color and by size at another activity.
2. a_StyleSetupTime: Do not change. The time needed to perform the setup.
1. v_PreviousStyle1: Do not change. Maintains the value of the previous setup attribute to see if the current entity is different and will require a setup. If the value is the same as the previous, no setup is required.).
After clicking the 2. Update button wait for a few seconds until you receive a relevant prompt via Excel or are moved to ProcessModel for model simulation. Once you are back in ProcessModel, you can look at the following location to make sure that the import was successful:
1. Click on the arrival route and from the Properties Dialog click Define Schedule, open the Action Logic and review the import values.
Review the first line of data that was imported
The data imported into ProcessModel is reflecting the same values.