Label locations by encounter status

A reserved Bed 4A is labeled Reserved location, not read as where the patient is.

What you'll make

In Excel: reserved, Bed 4A becomes Reserved location: Bed 4A.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8Reads the location status for this row."reserved"
2"planned", … "reserved", …Planned or reserved: labels it as not yet in use."Reserved location: "
3"active", … "completed", …Active or completed: labels it as in use or past.Not used for row 8
4SWITCH( … )Picks the label that matches the status."Reserved location: "
5&B8Adds the location after the label."Reserved … Bed 4A"

Read it left to right. Any other status gets the label Review location state.

=SWITCH(A8,"planned","Planned location: ","reserved","Reserved location: ","active","Active source location: ","completed","Completed location: ","Review location state: ")&B8

How to use it

Yellow bar at the top? Click Enable Editing.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. Use your own locations. Paste each location's status (planned, reserved, active or completed) and the location into the green columns of the Template tab. The labels fill in by themselves.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Use the status of this location on this visit, not the status of the visit or the room overall.

Microsoft's help: SWITCH function