View Single Post
  #1   Report Post  
tod1west
 
Posts: n/a
Default How do I plot Excel data on a floorplan?

I'm trying to find a way to plot data from an Excel worksheet on a floorplan
diagram. The data reflects room assignments for a hospital, so some data
stays the same for days while other data changes on a twice a day basis. I
want to enable someone to be able to enter the data on the worksheet and have
excel output the names, etc in the proper room assignments on the floorplan
automatically. The users could then print this floorplan to locate the
assignments more easily. I can either scan a hardcopy of the floorplan, or I
have access to Visio so I could also quickly construct a digital version of
the floorplan if it would work better that way. This will be used by others
so I'm trying to make it as straightforward as possible.

Thanks!