Clean It Up

UK Window Cleaning Forum => Window Cleaning Forum => Topic started by: Daniel12 on May 07, 2011, 11:14:07 am

Title: organizing round
Post by: Daniel12 on May 07, 2011, 11:14:07 am

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.

Title: Re: organizing round
Post by: Daniel12 on May 07, 2011, 05:09:35 pm

anyone got an idea

Title: Re: organizing round
Post by: LWC on May 07, 2011, 05:14:49 pm

www.streetmap.co.uk

If thats what your after?

Title: Re: organizing round
Post by: Dave Anderson on May 07, 2011, 05:15:58 pm

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 8)..

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

Cheers
Dave.

Title: Re: organizing round
Post by: Blue Frog Systems on May 07, 2011, 05:18:18 pm

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.

Title: Re: organizing round
Post by: Daniel12 on May 07, 2011, 05:51:23 pm

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

Title: Re: organizing round
Post by: Tom White on May 07, 2011, 06:28:20 pm

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?