How can I make an automated leave-tracking system? (w/o a dedicated server)

Question

I work in an education reform office in a thrid-world country. My IT skills aren't the best, but they're the best around and I get asked to do a lot of things I don't really have the knowledge to manage.

I'm trying to set up an automated system for requesting, approving, and recording leave (like, vacation time from work). I've had a few ideas, but none of them seem good enough. I'll run them by you. THE CATCH IS THAT WE DO NOT HAVE (and cannot get) A SERVER. More generally, we can't pay for anything.

1) A buttload of gmail filters on a new account. Not too hard to set up, but very difficult to tabulate leave. Is there any good way to go through a bunch of emails and extract data from them? (I.E. create a list of how many leave days each worker has remaining.) I was thinking of using a mail client (thunderbird with IMAP)... but then... can I get data out easily?

2) An open-source tracking program. I was thinking something like http://www.orangehrm.com/ . Problem? Can't host this sucker. At least, I think I can't. I really don't know anything. If we have a website, could I host it? Would it be enough to have a computer running some of the time to provide occasional access?

3) A wiki. This seems like a pretty sweet idea, actually. The idea being that I could create a whole bunch of pages with different permissions. Unfortunately, my limited google skills can only find hosted wikis WITHOUT free custom security (e.g. pbwiki). Bummer. Do you know anything better?

What do you say? Can you fix any of these or suggest a better idea?

Answer 1

You could set up Google Docs Form for collecting requests and then in the spreadsheet have a column not on the form for recording whether they are approved or not.

Alternatively, you could use a spreadsheet like this and give everyone access to it.

Answer 2

Out of curiosity, have you considered getting a cheap, VPS-type server? Slices are available from Slicehost and similar vendors for as little as $10/month.

Answer 3

How about a shared calendar on Google calendar? I admit that it's not really tailored to your task, but it's free, quick to set up, and it should get the job done.

Answer 4

I was going to suggest WhosOff.com which does exactly what you are asking for, however I just noticed on their web site that they have withdrawn the free edition, so this is no longer an option. There are various other online staff holiday planning tools but they don't have free versions either.

The one I did find and which might do the job for you is Onyaka.com. This is a very simple online staff planner and is completely free. I'm afraid I haven't used it myself so can't give you much information about the functionality.

Another idea, not sure if this would work for you: You could just have a simple spreadsheet where everyone fills in their leave. Use an online document (like Google Documents) then everyone has access to it from everywhere. It's quite basic but should work to track leave time, remaining holiday etc.

---

Edit: I just stumbled across the following: HR.net lite. This is free for up to 15 employees (not sure how many you have?), includes holday and absence tracking as well as lots of other useful human resources tools. It requires a web server, however if you don't have one then it will install a free open source one. So all you need is a computer (any computer) connected to your network which can be accessed by your employees. As long you don't have more than 15 staff this would be a good and free solution.