I am trying to get ideas to revamp a dashboard representing a series of resources in a large (html) table. My problem: I have very limited "screen estate" to represent the resources and need to cram as much information as possible without making things too cluttered.
In order to give a concrete example, imagine a table where each row is a hotel (let's say you have on average 50 rows) and the columns are days of the month (so max 31).
Each Hotel/Date cell must represent how "full" a given hotel is - with the following extra problems:
I cannot write inside the cell (each cell already has a short text code such as "AC" or "K3b" that indicates if there is a specific event for which special booking conditions apply... i.e. assuming I have opened my dashboard on San Francisco data, during Apple World Developer Conference at Moscone Center, maybe 20 to 40 of the cells would be marked with "AWD".
Currently the we are using colours (Green=more or less empty, Yellow: some room types are sold out or close to sold out, Red: most room types are sold out or close to sold out, Gray: hotel unavailable due to renovation or something similar).
The real problem is that the colours (apart from gray an green) aren't very helpful, unless a cell it is green or gray we don't really know what chances are for someone to find a place - any hotel may have 7-8 different types of room (e.g. singles, doubles, suites, single - smoking allowed, and so on) with an uneven distribution: most hotels have 50%+ double rooms (which can also be sold as singles) maybe 25% doubles which can accomodate a 3rd bed or a small child, and suites and mini-suites are usually <10% of the number of rooms.
So if I have a small hotel with 100 rooms, of which 4 are suites, the fact that I have sold 4 doubles means it should be green (i.e. you have 100% chances to find an accomodation, no matter the type of room you need) while if the I have sold all the suites it should be... something else, because while the hotel is still basically empty, you don't have one of room types available anymore.
Any suggestions about either fiddling the algorithm (at the moment it is not very smart and you basically see "green" until over 50% of the room types are below 20% capacity) or being able to find some other kind of visual hint, so that the dashboard is actually useful and does not force you to visit all the hotel cells to see the actual situation? (clicking on the cell opens a popup with extra information).
The cells are quite small (the whole dashboard is just part of the main dynamic html screen so we don't have the full screen area) so I don't think we can add icons or graphical elements in there (I am still interested in ideas about that, too, if I find something worth fighting for I will propose a complete redesign).