deod

A very simple approach to do something like select distinct in SQL to return number of distinct entries. For ex. in the following table i want to find how many kitchens are currently being used for Marinara. I was able to extend the pandas example for the new python feature to search through the table and return number of kitchens being used for Marinara. 'PandasSelectDistinct' step lets users define the columns to filter and conditions for filtering. Users also need to define 'GroupList' , column to group by and 'DistinctList' column to count distinct entries. For ex. in this scenario table is filtered on Processed==false and KitchenAssigned == true. Group by ItemName and distinct by Kitchen. Entity triggering the process is 'Marinara' step will return 2. This method can be extended to return actual kitchens being used as well. To define filter conditions use 'Column Name1' == 'Value', 'Column Name2'=='Value'.....etc. I am using model/script from Pands Date Frame from Table on git hub.SelectDistinctFromTable.spfx I have not tested the model extensively. Just a starting point for something I wanted to do for a long time.

You can define custom state on entity and use it to name entities. You can use state assignments on source to assign. Every time a new entity is created, increment a model state variable and assign it to custom state on entity.

I am not sure if you can transfer explicit row reference. what you could do though is search through a table, get the row reference you need and save it as a state on entity/token. You can use the state reference later.

You can run the model with 'Trace' turned on. This will trace everything happening in the model, including changes to state variables etc. Turning Trace on also generates a CSV file that you can use to debug. You can also use watch window to debug.

Hello, You can go to the process tab in the model. Once in the process tab you can click on create process to create add on processes at the model level.

Updated version with prime on infeed. Filler won't start until you have enough entities on the infeed conveyor. IndexingPlate - V4.spfx

Rotary filler head object that represents animation of bottles rotating around a cylinder as they get filled. You can use a regular server if animation is not required. This object lets you define the number of filling heads, direction of rotation and rate (Bottles Per Minute), pitch of fillers heads (in degrees) and ReleaseType (Release type represents where the bottle will be released at 180 Degree from the start point or 270 degree). As seen in the picture above, Arrow represents the starting point. Users can also specify if they need fine control over the rotation of the filler heads. If fine control is set to True filler head will pitch by 1 degree. This provides smoother animation.Users will have to make sure the pitch is set correctly in relation to the release type if Fine Movements are set to False. With FineMovements set to False filler heads movement is equal to pitch defined. Users can also specify failure rate in similar way to server or other standard Simio objects. This object has not been extensively tested and it can be further customized to requirements. IndexingPlate - V4.spfx

Updated version where slug conveyor can be used as a standalone slug build conveyor. Set the Merge property on the conveyor to False to use as standalone conveyor. Ending node for slug section should be a slug node. Make sure that the initial traveler capacity of the slug node should be 0. ConveyorLibrary _V2.spfx

ConveyorLibrary.spfx Simple conveyor library with a merge controller, slug conveyor, Slug Node and a Photo Eye. Library has two example models. A MergeControllerModel and a PE_ExampleModel. Merge controller,Slug Conveyor and Slug Node are used together to develop a slug merge. ConveyorLibrary.spfx On the slug conveyor you can specify the size of the slug. Slug node controls when the next slug is to be released. As soon as last entity in slug crosses the slug node it will send a signal to merge controller to release the next slug. Ending node of the slug conveyor has to be a slug node. Conveyors before and after slug conveyor are regular conveyors. These objects have not be extensively tested. These can be used to develop other conveyor related objects.

A basic photo eye object that can be used with conveyor belts. Photo eye is based on a transfer node object. It collects statistics on time in blocked state, cleared state and throughput. Transfer nodes on entered and on exited add on processes can be used as on blocking and on clearing add on processes. Photo eye has properties to define the delays for on blocked and on cleared. Photo eye will wait to complete on blocked delay to execute on blocked add on process. Similarly, photo eye will wait to complete on cleared delay to execute on cleared add on process. PE_Library.spfx