I'm trying to figure out a way to take a line of data consisting of:
Room number / Name / Time of visit
I want to be able to enter the data (and some additional data) about the people being visited in a line, and have it automatically generate a room schedule with the time on the left and the room number across the top, but have it be complete with all possible times (in 15 minute increments) and all the room numbers across the top, even if there are no scheduled visits.
Anybody know what kind of system would allow me to do this? So far I havn't had much luck with pivot charts, but it could be my general inexperience with them.
These will need to be updated daily, and usually with very short notice, so moving things around on a big schedule would be somewhat inconvenient, and we need to record more data than we could reasonably put on a single schedule anyway. I'm trying to make this as little investment of time as possible to keep the books updated.
Ex. Data Line:
3 / Jon Johnson / 0815 / Visitor Name
Ex Table (Ignore the underscores, I couldn't set the spacing properly without them):
_______1 ________2___________ 3 ____________ 4(etc.)
0800
0815 _____________________ Jon Johnson
0830
(etc.)
Any help would be greatly appreciated, even if it's just pointing me in the direction of the tools that could do this.
Bookmarks