Slashdot Mirror

← Back to Stories (view on slashdot.org)

Web-Based Employee Scheduling?

Posted by Cliff on from the time-tracking dept.

irksome asks: "I am looking to write an application to replace a legacy system of having people choose their own schedules. The current system involves a large board, with all the available shifts in blocks, and sticky notes with people's names on them. After everyone puts their stickies on the board, some poor soul has to go through manually and type it all into a spreadsheet. I'm wondering if anyone has any sugesstions for replacing this system. The ideal system would have a Web-interface, and it should also be able to generate a printable spreadsheet. Any ideas on how to implement this?"

5 comments

  1. Ummm, database? by Wavicle · · Score: 1

    Have the web CGI/ASP/JSP application store the information in a database. Then use something like MS Access & Excel or another similar tool to pull the data out (via ODBC or whatever) when producing the spreadsheet.

    --
    Education is a better safeguard of liberty than a standing army.
    Edward Everett (1794 - 1865)
    1. Re:Ummm, database? by StandardDeviant · · Score: 2

      The unix corollary would be CGI/PHP/JSP and a databse (for something simple like a timesheet a perl cgi system or PHP is probably the least pain, combine with free RDBMS like postgresql or mysql and yer done, with $0 software cost). Both perl and PHP have interfaces to PDF for printing out the final schedule (or just make a web page that views a table in the DB for sched, presumably your cow-orkers are smart enough to use a web browser instead of looking at a printed sheet).

      I think the spreadsheet thing comes from the fact most office drones automatically reach for Excel when they're looking at tabular data, regardless if the data requires calculation. :) Of course if you _do_ need calculation (like salary byb hours worked or something), that's just a few more rows or maybe a new table and some simple programming logic to calc and then a bit more formatting to put the result on the output.


      --
      Fuck Censorship.
      --

      News for Geeks in Austin, TX
  2. Re:I've seen this by Someone_U_Dontknow · · Score: 1

    Smooth little program I will admit... but how the hell are you supposed to download it? I could use something like that...

    --
    Embracing insanity - one twitch at a time
  3. I've seen this by SanLouBlues · · Score: 2

    Growth Sector did this a while ago. They have the demo up still. It's under the exhibition link. Pretty neat stuff.

  4. re: scheduler design by jblack1348 · · Score: 2

    I had thought about this for a class a couple of years ago. Because of other, more pressing demands, I never got around to finishing it. http://www.csee.usf.edu/~black/designs/scheduler.h tml