question

Lou Keller avatar image
0 Likes"
Lou Keller asked Cliff King answered

How do I assign an entire alternate group to a specific location?

It's not at all uncommon for surgical services to create or employ surgical teams for specific procedures rather than gather random groups of appropriate personnel to do the same task. Whether it's because of a team's specialty or the fact that the members are all from the same independent contract company is immaterial. Assuming I have assembled several such teams in a specific model, what's the simplest way to call an entire team to a required location (e.g. a Specific OR) rather than having to list each member individually. For example, suppose I had three ORs and wanted to call Surgical Team1 to whichever OR a surgical patient is occupying?

FlexSim HC 5.3.2
alternate groupteamassigning resources to locations
5 |100000

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

1 Answer

Cliff King avatar image
0 Likes"
Cliff King answered

One idea would be to list your teams in a global table.

Assuming you have the following table named Teams, and each patient has a label named TeamNum that assigns a team number 1, 2 or 3 to each patient, then you would simply write the four expressions below for the four staff requirements on the surgery activity. This approach would still work if some of the teams consisted of fewer than four people because a blank cell would simply be interpreted as NULL and skipped by the activity logic.

_ Team 1 Team 2 Team 3
Requirement 1 Brown Johnson Murata
Requirement 2 Green Hanson Kudata
Requirement 3 Black Jorgenson Mikata
Requirement 4 White Peterson Takata

gettablevalue(Teams, 1, getlabel(patient,"TeamNum"))

gettablevalue(Teams, 2, getlabel(patient,"TeamNum"))

gettablevalue(Teams, 3, getlabel(patient,"TeamNum"))

gettablevalue(Teams, 4, getlabel(patient,"TeamNum"))

5 |100000

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