Floorplan - Multiple people to room

[LisaB]

Hi,
I am a fairly new user of Visio. I have created a floorplan that shows employee room assignments.  The issue I am facing is that I have some rooms that can house anywhere from 1 to 10+ employees at any given time.  I need to place the name of each employee into the room.  I currently have a call-out for each employee.  When I originally created the floorplan, I had used an Excel spreadsheet that had a .1, .2, .3, etc on the duplicate room # (ex. 500.1, 500.2, 500.3) that was attached to the employee record of each employee occupying the single room.  The idea was that the spreadsheet could be updated and Visio would then auto-update the floorplan with any changes to the spreadsheet. This worked fine until the data began to be pulled from a new Employee database which produces a report with only the room # (500) showing and no additional extension.

I am using the Room # as the unique identifier. Is there another way, within Visio, to accomplish what I am trying to do? I am not skilled enough to alter the query producing the report to add the .1, 2., etc.  And the idea is for the update to be automated so no one has to make manual changes to the report before Visio gets ahold of it.

Thank you for any help you can provide to this Visio and coding newbie.

Lisa

[wapperdude]

Can you make the unique identifier to be the room number AND something else, e.g., employee name or payroll number?  Or just the room number.  May take some code, you could set up some nested loops to sort the employee list by room number 1st, and the then by name (or perhaps, it's sufficient to let Excel sort the list?).  Now, just grab each name and add it to next available call-out for each room. 

HTH
Wapperdude

[LisaB]

Can you make the unique identifier to be the room number AND something else, e.g., employee name or payroll number?  Or just the room number.  May take some code, you could set up some nested loops to sort the employee list by room number 1st, and the then by name (or perhaps, it's sufficient to let Excel sort the list?).  Now, just grab each name and add it to next available call-out for each room. 

HTH
Wapperdude

Thank you for the response, Wapperdude.  Unfortunately, I cannot use the employee name because, if I understand correctly, when a new employee is assigned to a room, it would then not update the room with that new employee because the employee names would not match.