Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have been looking everywhere for a few weeks now but can't seem to find anything so I come here to ask for assistance. Right now I am doing everything via a very simple Google Docs spreadsheet.

I need either a Linux-based program, LAMP-based script, or something that might work in google docs or excel. I plan on running it in a virtual machine.

Here are the details:

  1. There are 6 employees
  2. The work week is 24 hours a day, 7 days a week.
  3. Schedule will change like every 3 months, so don't really need anything complex.
  4. Only one person works at a time so there will never be more than 1 person on any shift.
  5. There is no standard shift length, like there is no 9-5... its just rotates around everyone's availability.

I need to be able to:

  1. List which days an employee can't work.
  2. List Min-Max amount of hours an employee can have per week and/or per day.
  3. Randomly assign employee shifts based on above requirements.

I don't need anything complex like don't need to keep track of days off, don't need to keep track of vacations, employees don't need to log into the system, I really don't need anything about the employee in the system except for their name and the information above needed to assign their shift. However if any of that is included with the software or script then it is no biggie. I can deal with something bloated as long as I am able to do the above lol.

share|improve this question
Sounds like google docs and/or excel can do exactly what you want. If you decide to change your mind about using one of those programs, be sure to update the question and I'm sure you'll get at least 1 good function answer. – Raystafarian Feb 27 '12 at 12:34
I am open to that, a google doc may be preferable and I tried coding one via javascript in it but unfortunately I am not that advanced lol. If you know of a way to assign employees to shifts based on their availability and only one employee per shift then I am all ears. :) – Damainman Mar 1 '12 at 8:43
up vote 1 down vote accepted

Have you checked orange HRM? This may have what you are looking for. You should be able to run it in linux.

Or try empscheduler

share|improve this answer
I looked at your first link a few weeks ago but it didn't seem to have exactly what I was looking for, but I may have over looked something. I will install it and double check instead of relying on their demo. For the second link, same but I avoided it due to the last time it was updated because it was a long time ago and the demo link was broken. However I will just go ahead and install that one too just in case. Thank you for the links though. I will definitely update this question if I find a suitable solution. – Damainman Feb 27 '12 at 9:32
I installed Employee Scheduler and tested it. I can do 1 & 2 but could not find a way to do #3 in your list. Take a look at this snapshot:… another one showing how you can handle overlapping schedule: – KKToronto Mar 4 '12 at 6:22
Sorry wrong link got posted here is the first link: – KKToronto Mar 4 '12 at 6:31
KKToronto, it is crazy you went through all the trouble to provide someone you don't know with possible solutions and even screenshots. Much appreciated!! I am saddened that Empscheduler didn't leave beta, it looks like it would've been exactly what I needed if it was fully coded since there are some areas of functionality which do not function. I will need to discuss with my partners to see if we can proceed with this. – Damainman Mar 4 '12 at 9:01
Thanks. I wanted to learn this myself. I have a Xenserver running in my home so it was just one more package to try out and see what it has to offer. You may directly contact with the owner for codes, he/she may share the code in return that you contribute it back to the community. – KKToronto Mar 13 '12 at 7:20

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .