Quantcast

Maximum PC

It is currently Fri Nov 28, 2014 3:26 am

All times are UTC - 8 hours




Post new topic Reply to topic  [ 5 posts ] 
Author Message
 Post subject: Route Scheduling
PostPosted: Fri Apr 02, 2010 2:46 pm 
Sharptooth
Sharptooth
User avatar

Joined: Wed Jul 13, 2005 8:55 am
Posts: 402
My company currently has about 200 drivers that dispatch on routes each day. They are using Excel sheets set up and copy/paste drivers's names, route numbers, times, ect into the appropiate block.

Are there any programs out there currently that would support this sort of setup and make it much more user friendly? Or would something like this have to be programmed?


Top
  Profile  
 
 Post subject:
PostPosted: Fri Apr 02, 2010 3:09 pm 
Team Member [Top 500]*
Team Member [Top 500]*
User avatar

Joined: Thu Jun 24, 2004 2:22 pm
Posts: 8721
Location: Cleveland, Ohio
If I read you correctly I would be thinking more along the lines of creating a database. From a software standpoint I would be looking at My SQL or for something small and simple Microsoft Access. Based on what you posted I don't see Excel as the best tool for what they are doing.

Ron


Top
  Profile  
 
 Post subject:
PostPosted: Sat Apr 03, 2010 2:12 pm 
SON OF A GUN
SON OF A GUN
User avatar

Joined: Mon Nov 01, 2004 5:41 am
Posts: 11605
There are lots of vendors providing software for this. You'll have to be more specific.


Top
  Profile  
 
 Post subject: Re: Route Scheduling
PostPosted: Mon Apr 05, 2010 6:51 pm 
Bitchin' Fast 3D Z8000*
Bitchin' Fast 3D Z8000*
User avatar

Joined: Tue Jun 29, 2004 11:32 pm
Posts: 2555
Location: Somewhere between compilation and linking
RW wrote:
My company currently has about 200 drivers that dispatch on routes each day. They are using Excel sheets set up and copy/paste drivers's names, route numbers, times, ect into the appropiate block.

It always amazes me when I hear about companies running important operations using bubble gum based computing systems... =\

RW wrote:
Are there any programs out there currently that would support this sort of setup and make it much more user friendly? Or would something like this have to be programmed?

As CrashTech mentioned, we would need more information in order to give you a concise answer. It isn't clear what you're trying to accomplish. I suspect that you have been vague because you're not familiar with the lingo...

Logistic problems like this fall under the large (and very complicated) umbrella of planning problems. This is one of the more difficult problem in computer science / AI. If your company is using fixed routes that were created by hand, it is missing an opportunity to save a lot of money. During Operation Desert Storm, the US military used a planning tool called DART that saved more money than the cost of ALL AI research funded by the government (an incredible ROI... you would think they'd be more willing to fund additional research). HTHs.


Top
  Profile  
 
 Post subject:
PostPosted: Tue Apr 06, 2010 3:32 am 
Sharptooth
Sharptooth
User avatar

Joined: Wed Jul 13, 2005 8:55 am
Posts: 402
The actually routing of the drivers is taken care of by another departing using actual routing programs.

I guess what I'm looking for is a program or way to keep track of the information about the routes. Drivers names, driver employee numbers, route numbers, number of stops on the route, ect. Currently, if we removed a driver from a route (sickness, vacation, ect), we have to manually cut his name out of the schedule, copy it into the "vacation" schedule, and then cut/paste a backup driver and all his information into the route.

It just seems very time wasteful to me the way they are going about it.


Top
  Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 posts ] 

All times are UTC - 8 hours


Who is online

Users browsing this forum: No registered users and 4 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group

© 2014 Future US, Inc. All rights reserved.