Can I set the rank of an object by importing a excel spreadsheet?

Question

question

Rich G6 asked Nov 17, '21 Ryan Clark commented Nov 19, '21

Can I set the rank of an object by importing a excel spreadsheet?

If I have a simple model that contains a Source1 (Rank 3), Queue1 (Rank 4), Processor1 (Rank 5) and a Sink1 (Rank 6), how can I change the rank of the objects in my model using an excel spreadsheet?

For example, using an excel spreadsheet that contains 2 columns (1 for the Name of objects, 1 for the Rank of objects) and 5 rows (1 for the heading, 4 for the number of objects in the model). Using the User Commands custom code option, what code can I create so that I can import an excel spreadsheet to change the rank of the objects?

Original ranks ----> New ranks

Source1 3 ---> 6

Queue1 4 ---> 5

Processor1 5 ---> 4

Sink1 6 ---> 3

Software Version:

FlexSim 21.1.5

name and rank

Answer 1 · 2021-11-18T09:12:29Z

Felix Möhlmann answered Nov 18, '21 Felix Möhlmann edited Nov 18, '21

You can use the "Post Import Code" option to adjust the ranks of the objects based on the imported table. The attached file assumes the table in the excel file has the following format:

This gets imported to a global table called "TreeRanks". The post import code sorts this table by rank and sets the ranks of the objects accordingly.

ChangeRanksWithImport.fsm

1637226515930.png (2.0 KiB)

1637226735796.png (20.8 KiB)

changerankswithimport.fsm (56.4 KiB)

· 4

Rich G6 commented · Nov 18, 2021 at 06:21 PM

Thank you Felix for you response. I was able to follow your instructions. However, once I imported my excel file into a global table, the object's rank in the model remained unchanged.

I placed a check mark on both "Import table on Model Reset" and "Execute Post Import Code" clicked on the "Post Import Code" and clicked on "Apply" and "OK" on that as well. How can I ensure the rank of each object is updated based on the excel file? Thanks again.

0 ·

Felix Möhlmann Rich G6 commented · Nov 18, 2021 at 06:34 PM

Have you checked if you copied the import code from my model correctly (maybe your table has a different name)? Do you get any error messages?

It'd be easier to help if you could upload your model or post screenshots of the relevant sections (import code, import window, table, tree).

1 ·

Rich G6 Felix Möhlmann commented · Nov 18, 2021 at 06:57 PM

I was unable to open your model because you are using a newer version of FlexSim. I am missing the code. Can you please paste the code in the comments? Thank you in advance. If that doesn't work, I will definitely upload my model file next.

0 ·

Show more comments

Answer 2 · 2021-11-19T15:44:31Z

Rich G6 answered Nov 19, '21 Ryan Clark commented Nov 19, '21

Thank you Felix! Your code worked perfectly. I really appreciate your help.

· 1

Ryan Clark commented · Nov 19, 2021 at 08:09 PM

Hi @Rich G6,

I'm glad that @Felix Möhlmann was able to help you resolve your issue!

In the future, when you reply to answers to your questions, please don't post those comments as additional answers. Instead, you can click "Comment" or "Reply" to respond in a thread rather than adding a new answer each time.

The same thing applies when adding clarifications to your question. In that case, use the "Comment" button directly below the bottom of your original post.

Following these procedures helps to keep the post organized. For more information, please see Best practices for using this Answers site - FlexSim Community.

Thanks!

0 ·

question