I've set up a zipcode map where I show total number of customers from each zipcode. I used filtered portals to pull up totals (from summary fields in the portal's table) for user specifiable date ranges.
A similar set of one row portals with conditional formatting to show your colors should work for your floor map.
So I would basically build a container for each floor position, and can either modify it directly or add the person and set the modification options from there?
No container fields would be needed--unless you want to insert the graphic image of your floor plan into one to use as the layout background. (The image can also be inserted directly onto the layout.)
You'd then need to examine the design of your data to figure out how best to assign people to specific locations on your floor map. Let's say each cubicle is given a number. Then, if you have a table of employees, a field can be added to that table and a drop down list of cubicle numbers can be used to assign each employee to a cubicle. Then you can set up a relationship from the table used as the basis for your floorMap layout and the employee table that matches to all employees or perhaps all office staff, or.... Finally, you place one row portals on top of your floor map image and set each up with a portal filter that filters for a specific cubicle number and you position that portal so that it is on top of the location marked on your map for that cubicle.
Cool, that helps alot. Thank you very much.