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

Question

question

Lou Keller asked Oct 27, '17 Cliff King answered Oct 30, '17

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?

Software Version:

FlexSim HC 5.3.2

alternate group team assigning resources to locations

Answer 1 · 2017-10-30T17:01:24Z

Cliff King answered Oct 30, '17

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"))

question