Thursday 1 March 2007

Scheduling our handymen efficiently

We've put quite a bit of effort over the last few weeks into tweaking our scheduling practices to try and reduce the time spent travelling between jobs (even our London handymen, on motorbikes, still can't actually teleport between appointments, so there is some downtime).

One of our longest serving handymen, Don, said to me at our Christmas party that he didn't think that his average travel distance between jobs had reduced at all in the four years or so he had worked for us. This surprised me, as we now have about three times as many handymen in London as we did when Don first joined, so we should be able to keep each handyman in a tighter area.

At the time, I briefly considered actually measuring the average actual distance between every job we had ever done, but quickly dismissed this as computationally too complex.

Then I had a flash of inspiration late yesterday afternoon and figured out a way we could get the right data out of our system to do a full analysis of inter-job distance. So I built this monster spreadsheet, incorporating (for the first time since I did GCSE maths) Pythagoras' theorem.

Spreadsheet turned out to be such a monster that, for first time since working as a financial analyst at OC&C, I had to switch Excel to manual recalc (only really hardcore spreadsheet nerds like me ever need to do that). And then when I hit F9 to calculate everything, my PC sat whirring away for 2 full hours before telling me:

Our average inter-job distance has dropped by 9% since 2004 (first year we have good quality data available), from 4.6km to 4.2km.

I think it could be much lower: there are some handymen, in some months, for whom we have managed to keep inter-job distance below 3.0km, a further 30% below our recent average.

Anyway, now we have the tool in place to monitor this we can work on keeping that distance down further (and it only needed 2hours to churn through every job since mid-2004, some tens of thousands of data points; manages to figure out the distances for a few days at a time in just a few seconds).

Holy Grail is to keep every handyman on the same street all day (happens sometimes!). I have heard that there is a chap in Chelsea who washes cars on Tregunter Road, and makes his entire living out of that one street. Everyone uses him, and by the time he has worked his way to the end of the street, it is time to start again at the beginning. Not sure if this is true, perhaps any readers who are fortunate enough to live on Tregunter Road could confirm / refute?

10 comments:

バイト said...

凄い人気の学生 高収入パート募集を楽しんでね。本物のかけ持ち 高単価チャットレディ募集がイイよ、すごい自宅で稼げる携帯メールレディーに移動、口コミで大人気の40代女性に人気 高収入自宅仕事はすごく良かった、→アダルト無し 稼ぎやすいチャットレディー を参考に優良サイト高時給携帯メールレディー募集情報はいい情報がありました◎★時給4000円以上稼げる チャットレディーが参考になりました♪凄い人気の女性に人気 高収入バイトを参考にしてみてね★優良モバイルサイト通勤不要☆稼げる携帯ライブチャットレディーで幸せになれた○某掲示板でも評判の夜だけでも稼げる携帯メールレディーは楽しいね。素敵な月60万以上稼げる メールレディーが1番良かったです!!役に立つ主婦 高収入チャットレディー募集が参考になりました♪★女性 高収入在宅バイト求人で幸せな生活を取り戻しました。お勧め自由な時間に稼げるチャットレディーを参考にしてみてね★おすすめ優良子持ち主婦 高収入在宅バイト募集で貴重なサイトを知れて良かったです!役に立つ女性に人気の高収入チャットレディーを参考にしてみてね★役立つ短期間で稼げる携帯メールレディーが1番良かったです!!優良情報満載専業主婦 高収入メールレディーを見てみてね~♪くちこみで評判の自由な時間に稼げる携帯メールレディで貴重なサイトを知れて良かったです!

Unknown said...

2016-3-2 leilei
true religion
michael kors outlet
ture religion outlet
hollister co
ray ban sunglasses
kate spade outlet
toms outlet
jordan 6s
kate spade handbags
canada goose jackets
nike sb janoski
nike huarache
ugg australia
longchamp outlet
louis vuitton outlet
burberry outlet online
michael kors bags
christian louboutin shoes
longchamp soldes
michael kors outlet
toms shoes
michael kors outlet
true religion
jordan 3s
jordan retro 13
michael kors handbags
gucci outlet online
montblanc pens
ugg boots australia
jordan 3 retro
michael kors outlet
nike shoes
michael kors handbags
nike blazers uk
canada goose jackets
louis vuitton outlet
louis vuitton outlet stores
jordan shoes
michael kors outlet
michael kors handbags

raybanoutlet001 said...

michael kors outlet
ecco shoes outlet
michael kors handbags
michael kors handbags
cheap nike shoes
nhl jerseys
ray ban sunglasses
seahawks jersey
ray ban sunglasses
air max 90

jeje said...

ed hardy clothing
polo ralph lauren
bears jerseys
skechers shoes
ray ban sunglasses
nike shoes
superdry clothing
adidas yeezy
san diego chargers jerseys
0416jeje

miki said...

0815jejeUne expérience adidas zx flux adv verve solide, lourde, de métal vous permet déjà de connaître ce point en ne chaussures nike cortez pas cher brisant pas, et bon, si d'une manière ou d'une air jordan 11 blanche et bleu autre il fait - c'est vraiment confirmé pour l'existence, air jordan 11 columbia prix aucune pensée n'a demandé! Allez-y, courez ce point à asics gel lyte 3 femme bleu clair travers ses cours, vous aurez rarement besoin d'un chaussure nike roshe run femme rose briquet différent. Le Nike Air Max Classic BW est essentiellement basket nike roshe run courir le premier Nike Air Max LTD hommes, renommé air jordan 1 retro high femme seulement. La tentation est difficile à résister, et vous pourriez tomber asics veste equipe de france full zip m amoureux d'une robe qui pourrait largement dépasser votre gamme de prix.

amany said...

شركة مكافحة صراصير بالمدينة المنورة
شركة مكافحة الصراصير بالاحساء شركة مكافحة الصراصير بالاحساء
شركة مكافحة الصراصير بالدمام شركة مكافحة الصراصير بالدمام

jerry said...

Thanks for this great post, i find it very interesting and very well thought out and put together. I look forward to reading your work in the future.

do you think its necessary to cover airline chairs

jerry said...

Thank you for another great article. Where else could anyone get that kind of information in such a perfect way of writing? I have a presentation next week, and I am on the look for such information.
buy driving license online

Donut Recipes said...

Grreat share

buy Hydrocodone Online australia said...


thank you for a really fascinating read, i hope you would do a follow up article considering i can never go through enough on this topic
kamagra 100 mg australia