topic Re: Custom speed using excel in FlexSim Forum

Custom speed using excel

mapo19 — Mon, 18 Mar 2024 15:53:52 GMT

[ FlexSim 24.1.0 ]

Hello!

How do I use an Excel data sheet to set different speeds on an AGV between several XYZ locations?

For reference, I have created a model that uses the same principles from Eric M's answer to the original question. Eric M's model is called "agv path by excel coordinates.fsm" and can be found here: https://answers.flexsim.com/questions/106810/agv-excel.html

The linked model above reads the XYZ locations from an Excel sheet via a process flow and makes the AGV drive to said location before going to the next one.

Re: Custom speed using excel

joerg_vogel_HsH — Mon, 18 Mar 2024 16:04:45 GMT

@Mattias, do you build a free moving agent or do you have a railway bound system? You can parse in a tasktype of Travel to Location a parameter 4 as an end speed.

Re: Custom speed using excel

mapo19 — Tue, 19 Mar 2024 07:29:56 GMT

@Joerg Vogel Hello! I am using a free moving agent (no added paths). I am guessing that a railway bound system is using paths (I am quite new to FlexSim). I am currently not using any coding but I am going to try the thing you have linked. If you do not mind me asking, where do I add this code to manipulate the AGV?

Thank you for answering, have a good day 🙂

Re: Custom speed using excel

moehlmann_fe — Tue, 19 Mar 2024 08:05:18 GMT

Based on the original answer of Eric, you can simply update the maximum speed of the task executer before every travel task.

agv-path-by-excel-coordinates_1.fsm

In more recent versions of FlexSim you'd use ".setProperty("MaxSpeed", value)" instead of the ".setVariable("maxspeed", value)" I use in the attached model.

Re: Custom speed using excel

mapo19 — Tue, 19 Mar 2024 08:25:07 GMT

Thank you very much, it works as intended!

Have a good day 🙂

Re: Custom speed using excel

mapo19 — Tue, 26 Mar 2024 16:50:58 GMT

@Felix Möhlmann In your accepted answer, is it possible to add another TaskExecuter to follow the same path with the same speed but it drives away after a couple of seconds?

Re: Custom speed using excel

moehlmann_fe — Wed, 27 Mar 2024 06:59:29 GMT

You can simply create a second token and assign each token a different task executer.

agv-path-by-excel-coordinates-2.fsm

Re: Custom speed using excel

mapo19 — Wed, 27 Mar 2024 08:20:56 GMT

Ahh, thank you very much!