Custom speed using excel

Question

question

mattias asked Mar 18, '24 mattias commented Mar 27, '24

Custom speed using excel

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.

Software Version:

FlexSim 24.1.0

excel agvcontrol agvspeed

· 2

Joerg Vogel commented · Mar 18 at 04:04 PM

@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.

0 ·

mattias Joerg Vogel commented · Mar 19 at 07:29 AM

@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 :)

0 ·

Answer 1 · 2024-03-19T08:05:18Z

Felix Möhlmann answered Mar 19, '24 mattias commented Mar 19, '24

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.

agv-path-by-excel-coordinates-1.fsm (29.1 KiB)

· 1

mattias commented · Mar 19 at 08:25 AM

Thank you very much, it works as intended!

Have a good day :)

0 ·

Answer 2 · 2024-03-26T16:50:58Z

mattias answered Mar 26, '24 mattias commented Mar 27, '24

@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?

· 2

Felix Möhlmann commented · Mar 27 at 06:59 AM

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

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

1 ·

agv-path-by-excel-coordinates-2.fsm (29.5 KiB)

mattias Felix Möhlmann commented · Mar 27 at 08:20 AM

Ahh, thank you very much!

0 ·

question