How to copy the data in a excel file after simulation in simevents?

I am running a simulation of a production system. I want to change the dispatching rule and for each of this I want to save in a excel file (or something similar) the cycle time value of the entities to evaluate the performance.

I have both the problem how to seve the data and how to calculate the cycle time.

thank you

Answer 1

[Mo Zhao]

Hi Paolo,

Is the cycle time value an attribute that you defined in the entity? If so, you can use the MATLAB event action to access the entity attribute and output to the MATLAB workspace. For example, you can connect the entity output to an Entity Server, and in the Entry event action, and write "Cycle = entity.cycle;" (where "cycle" is assumed to be the entity attribute you defined), and then you will have the variable Cycle in your MATLAB workspace. You can then write a MATLAB loop to simulate the model and output Cycle to a excel file in each iteration. Another way is to use the SimEvents Design Pattern "Extract attributes of entities as signals" and connect the output to a ToWorkspace block.

You can find the event action documentation in

https://www.mathworks.com/help/simevents/ug/events-and-event-actions.html