Personal computing discussed

Moderators: SecretSquirrel, just brew it!

 
DrkSide
Gerbil
Topic Author
Posts: 82
Joined: Thu Sep 16, 2010 9:08 pm
Contact:

Program for Scheduling

Fri Feb 10, 2012 5:14 pm

The company I work for is currently trying to take the scheduling from a piece of paper like it has been for years and move it to a digital scheduling system.

We are an autobody shop and we need to schedule cars in and track how many units (relates to labor hours) that are scheduled. These do not need to even be distributed over different days but need to be tracked so we can tell if we are under or over our goals.

The simplest way is obviously an excel sheet but I run into the problem of multiple people being in the file and overwriting changes that others have made.

I am looking for the easiest and most cost effective way to do this. It doesn't matter if it is a pre made program that we can tailor to our needs or something simple that I can learn to program. The key is that the boss doesn't want to go out of the office for labor if we don't have too. Since I already manage all of the computers and website I was the chosen one for the job.

Any help would be appreciated.
 
Captain Ned
Gold subscriber
Global Moderator
Posts: 23848
Joined: Wed Jan 16, 2002 7:00 pm
Location: Vermont, USA

Re: Program for Scheduling

Fri Feb 10, 2012 5:17 pm

DrkSide wrote:
The company I work for is currently trying to take the scheduling from a piece of paper like it has been for years and move it to a digital scheduling system.

Your boss won't like to hear this but if the paper-based system works and, most importantly, it's not creating otherwise-billable down time, the first cent spent on changing the system will be lost.
Build a man a fire and he's warm for the night. Set a man on fire and he's warm for the rest of his life.
 
druidcent
Minister of Gerbil Affairs
Posts: 2213
Joined: Wed Aug 07, 2002 7:55 pm
Location: Earth, Sol, Milky Way
Contact:

Re: Program for Scheduling

Fri Feb 10, 2012 5:28 pm

You may be able to use Google Docs (the spreadsheet program, I forget it's name), and set it up for online collaboration. This should let everyone modify it without overwriting other user's input.
 
DrkSide
Gerbil
Topic Author
Posts: 82
Joined: Thu Sep 16, 2010 9:08 pm
Contact:

Re: Program for Scheduling

Fri Feb 10, 2012 5:59 pm

Captain Ned wrote:
Your boss won't like to hear this but if the paper-based system works and, most importantly, it's not creating otherwise-billable down time, the first cent spent on changing the system will be lost.


Currently it is not creating down time except for multiple people trying to schedule at once and crowding around the front desk. What he wants is for anyone to be able to schedule from any computer. This is preliminary to be able to have at least one on the road estimator and a satellite office for estimates and scheduling.

So currently the money will be lost it will be gained once we open the second location and hire an on-site estimator.
 
DrkSide
Gerbil
Topic Author
Posts: 82
Joined: Thu Sep 16, 2010 9:08 pm
Contact:

Re: Program for Scheduling

Tue Feb 14, 2012 10:54 am

Anyone at least have any tips on where to start with this? I can learn what I need to however I need at least a good direction to go in before I start.
 
thegleek
Gold subscriber
Darth Gerbil
Posts: 7406
Joined: Tue Jun 10, 2003 11:06 am
Location: Detroit, MI
Contact:

Re: Program for Scheduling

Sun Feb 19, 2012 1:18 am

DrkSide wrote:
Anyone at least have any tips on where to start with this? I can learn what I need to however I need at least a good direction to go in before I start.

Something of this sort sounds like ERP to me or custom development.
 
kitsura
Gerbil Team Leader
Posts: 200
Joined: Sat Nov 09, 2002 11:39 pm
Location: In front of my computer, Duh...

Re: Program for Scheduling

Sun Feb 19, 2012 1:26 am

What is your budget like? I know a guy who used to work in a company selling scheduling software.
Intel i7 2700K @ 4.7GHz 1.35v | Megahalems Rev.C + 2x Gentle Typhoon AP15 | ASUS M4E-Z | Corsair Vengeance 16GB @ 1600MHz | MSI R6950 Twin Frozr III | OCZ Vertex 3 Max IOPS 120GB SSD | PCP&C Silencer Mk II 750W | Windows 7 Ultimate 64bit

Who is online

Users browsing this forum: No registered users and 2 guests