How do we create a pointer for a staff member in Excel ?

Question

question

Céline Y2 asked Aug 16, '20 Ben Wilson edited Sep 1, '20

How do we create a pointer for a staff member in Excel ?

Hi!

I am working on a healthcare structure simulation. I want to point a staff member in Excel who will be associated to a patient. For example, the surgeon1 will operate the first patient. How can I do that in Excel ?

Thanks for you help !

Software Version:

FlexSim 20.1.2

excel import pointer label

· 1

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Ben Wilson ♦♦ commented · Aug 27, 2020 at 03:18 PM

Hi @celine.y2, was jordan.johnson's answer helpful? If so, please click the red "Accept" button on their answer. Or if you still have questions, add a comment and we'll continue the conversation.

0 ·

Answer 1 · 2020-08-21T20:17:57Z

Jordan Johnson answered Aug 21, '20 Ben Wilson edited Sep 1, '20

An Excel Spreadsheet cell can only contain a number or text. However, you can put the name of a FlexSim operator in the excel spreadsheet. Then, you can import the table. Once the table is in FlexSim, you can write code that converts the text of the name to a pointer. Here is an example of code that could do that:

Table table = Table("TableWithNameColumn"); for (int i = 1; i <= table.numRows; i++) { table[i]["ColWithName"] = Model.find(table[i]["ColWithName"]; }

Note that this won't work if you import the excel data into a bundle table.

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

question