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

Question

Paolo Favero 2017-4-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/334166-how-to-copy-the-data-in-a-excel-file-after-simulation-in-simevents

编辑： Mo Zhao 2017-4-17

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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Mo Zhao 2017-4-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/334166-how-to-copy-the-data-in-a-excel-file-after-simulation-in-simevents#answer_263277

编辑：Mo Zhao 2017-4-17

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