[Daniel12]

Hi, i want to put my round in street order but i dont know the round as i dont clean all of it any ideas. i have about 1000 custs so foundd aa route planner was quite difficult.

[Daniel12]

anyone got an idea

[LWC]

www.streetmap.co.uk

If thats what your after?

[Dave Anderson]

Break in down into small area's poss postcodes? or give these area's a nickname.

For me I broke it all down into days i.e wk1d1 (week 1 day 1) >> wk7d8 (week7 day ..

Only you will know the real mechanics of your business and it's needs...is this what you were looking for?

Cheers
Dave.

[Blue Frog Systems]

Thats alot of working out to do but possible.

What is it that you are trying to achieve ?

- you want to build up a map so you know where customers are
- to try to organise your round better
- something else

 I've done this in the past to re-organize my round, but 1/3 of the scale you are trying to.

[Daniel12]

i want to put each customer in geographical so it can be cleaned from top of the page to the bottom in order

[Tom White]

I use a spreadsheet and on the Master Spreadsheet everything is put there in alphabetical order, so I can quickly find any street/area.

But each account is given a column with a code for example "NW Chepstow 1", and all the accounts I clean in this area have this code in that column.

To organise my work, I copy the Master Spreadsheet to a "Working Spreadsheet" file, and using the excell spreadsheet's 'Sort Function', I can quickly and easily sort my alphabetical spreadsheet into one by area.  (I can also quickly 'sort' to find out who owes me too; or phone numbers; etc).

I then highlight the area I wish to clean and print it off.

Every week I e-mail the spreadsheet to myself, just in case the computer goes pear-shaped; 'cos I don't want to lose my customer database.

I have a bit of a background in administration, so maybe this is a little complex?