Suggest an offline booking system, no wait... Suggest a one-click WAMP solution, no wait... Flash and flat files mebbe?
Scroll right down to skip the rambling details and answer the short version
of this question.
I have 25 computers each handed out for up to an hour twice per am and twice per pm.
I have 500 users competing for these resources on a first come first served basis.
I am required to know who was using what computer when for legal purposes.
At present the doors open and people come and queue for a "ticket", we hand them the ticket for their computer and then choose their name from a dropdown in this excel file(screendump)
This was fine when there was 50 of them, but the list is getting a little nuts now, and we sometimes get a ticket back in less than an hour and so pass it out again, so there is a lot of farting around in the file basically. The only actual problem with this system (apart from it being insane!) is that it takes too much time.
We are looking at various long-term solutions, but in the meantime I need a better short-term one than the one we patched together above. I like the aspect of the physical tickets as people don't forget they have booked, and also it gives me a physical notification that they are done at their machine when they hand it back (I am not, nor want to be, deskbound). Giving each person a user-id and password is probably what the long-term solution will be, and installing some sort of internet-café/library software, but that's outside my perogative. I also like the aspect of having the userlist as I learn each persons name, and I also would like to use that to tie to some other aspects of the users account, for example "needs help" or whatever.
What I ideally want is to have a user-database with a few fields, and then drop it into a similar setup as we have, but where I can just start typing their name to get the list (as opposed to having to click in excel), and where I can see a clear visual representation of the entire fleet of puters and their status. I rekon I can do this myself easily as a web-based solution, but I absolutly cannot have this online, the userbase is confidential, and yet myself and my colleauge both need to be able to access it from our own computers at work. We have a common folder on the server where the excel file presently sits. Is that something I can do with xampp or easyphp or wamp5 or what? WITSuite looks like the smallest all-in-one solution, but is it safe to run like this and can it be run in the way I am describing?
I am also open to the thought of doing it in Flash as a standalone, and am also happy for suggestions of actual software to deal with this in a simple way, I don't want the bells and whistles that I have seen on some cafe/library/resourse management progs.
EXTREMELY SHORT VERSION
What is the smallest, best, lightest, oneclickiest version of a local WAMP solution that I can keep offline and run from a shared folder on our server for a simple ajax based site. Xampp, easyphp, WITSuite?