[Moderator David@stives]

We have got a couple of hundred jobs due this week and my head is in bits, I have tried to map them in google the best way I can but it has taken me 2 days nearly.

Apart from George and WCPro is there an easier way, I know Service CEO is supposed to plot them by postcode for you, but I dont want to pay £2k to see if its any good.

Is there an easier way ?

[tacky]

i spect u know already .that rac n aa .etc do this stuff for members .but mayb for extra payment they may sort u out .no harm in trying if u havnt already . good luck anyway

[Nathanael Jones]

Can't you get a free demo of service CEO?
Or maybe as Kev Red if you can have a peek at his,...

[ok cleaning]

How did you do them before ? do the same planning

[bobby p]

bang em into your satnav ?

[Lee Pryor]

these must be regulars dave? werent they already in order.

been doing all mine in an exel spreadsheet, put them in the best possible order once and let the sat nav do the rest.

[Moderator David@stives]

lee

We have weeklys, monthlys, fornightlys, outs, in and outs, covering every town in Cornwall every week, Added to that we have just picked up loads of shops, even if i print a list, i need to put them into job order for the staff, If they were just on estates it would be easy.

It is a case of drive 3 miles do 2 jobs, drive 5 miles do 4 jobs etc, I have to sort that for 3 vans making sure nothing gets missed, every week the routes need changing to make the most efficient use of the vans.

Dave

[Tosh]

Dave,

My weeks work is planned, just about.

This youtube clip may help you in a round-about sort of way:

http://www.youtube.com/watch?v=Eg9wMXRt5ck

[Moderator David@stives]

Ken

Your'e right, job centre tommorrow for a manager and secratery.

Sorted, thanks, just needed reminding

Dave

[Tosh]

But a more helpful approach could be this:

I have a big excell spreadsheet and in the first column I assign a code that equals a given area.

So, for example, in Llangym (a rural villaige) I do about 10 properties and the code in that column is '5'.  I'll copy the document to a working file and I highlight the whole spreadsheet (Ctrl A) and do a sort on the first column and everything will change from alaphabetical order to area order.  

I just delete everything I don't want and print off what I do want.  It takes a minute.

You could add another column showing frequency and do another sort on that.  Does WCP not sort by area?

[Lee Pryor]

i hear you dave

we also run 3 vans with similar frequencies to those you mentioned. because we offer a 12 week choice we have 12 separate sheets for each round that run as a continuas list. if something is weekly they simply apear in every week list for that team. those lists are put in the best possible order and we just work through them start to finish and so on.

[Moderator David@stives]

Yes it sorts by area, the trouble is if i plan a route from say penzance to st austell and i want to take a slightly different route to take in some monthlys etc, it throws the program order out if you know what i mean, if it had drag and drop on the main round screen and i knew where the jobs were then it might be different.

Some of my jobs, i havent got a clue where they are, so i cant visualise them in my head, maybe some kind of pinboard might be useful.

Lee 

Added to my woes is some banks i have picked up, they have to be done in specified weeks, which are sent to me at the beginning of each month.

I would love to come and see how other people do it

[Tosh]

Dave, computers are great at manipulating information and displaying it in a format you want it.

I'm no whizz at Excell Spreadsheets, but I reckon that would do what you require.

[dai]

Dave, If you have 3 vans, can't you split the round into 3 areas and letting the staff sort out their own work. As long as they have the frequency rate they should be able to manage this, even if they only have 3 days work in their own section, you could pull them all together for the bigger jobs on the remaining 2 days. Just a thought Dai

[Lee Pryor]

dave i think you need to have a custom programme written to suite your business, i did just that and it was great untill i fell out with the programmer, still lessons learnt, i plan to have another desiged later.

[abilol]

dave i do loads of shops witch covers the northwest area i find the best way was to get your map book out ring all the areas just to get basic idea where they r all and then you  r not going backwards  and forwards  cheers laurie

[Nathanael Jones]

http://www.whatsatnav.co.uk/systems/garmin_quest2.html

http://thefastway.net/

[richywilts]

lee roughly how much do these computer programmers charge to build a software program?? i could do with one building for my new business rof coating??? i understand it will probly depend on how you want ur programme designed

[Lee Pryor]

 i paid £3000 for mine and i have also been quoted around that for the new one.

[Frankybadboy]

dave if the driver know the custmors well.

then just put then in town order ie hayle-newquay-lands end then let the driver sort out which is best way todo them when he gets to the town.
doing by post codes dont mean to say they be in order either so what for that one,
trust the driver abit if hes the regular man.he know best