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?

5 comments:

バイト said...

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

林磊 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

Chenzhen 20160303chenzhen said...

kobe shoes 11
coach outlet online
gucci outlet online
kate spade outlet
ugg boots
cheap oakley sunglasses
michael kors outlet
asics running shoes
kate spade outlet
jordan retro 4
air max 95
longchamp le pliage
coach outlet
cheap uggs
ugg outlet
ugg for cheap
cheap basketball shoes
louis vuitton purses
burberry handbags
ray ban sunglasses outlet
pandora charms
canada goose outlet
louis vuitton uk
nike store uk
louis vuitton outlet online
nfl jerseys
true religion outlet store
michael kors outlet
louis vuitton
louboutin femme
ralph lauren
longchamp outlet
coach outlet
beats by dr dre
adidas running shoes
coach outlet online
toms shoes
nike blazers shoes
louis vuitton handbags
coach factory outlet online
20160326chenzhen

rokn elbeet said...

لدينا مميزات في خدمات كشف تسربات التي تقدمها شركة ركن البيت التي تكون متخصصة فيها فتعاملك مع شركة كشف تسربات المياه بالدمام لديها امكانيات جيدة يساعدك علي التخلص من مشاكل التسريب التي توجد لديك بسهولة دون التعرض للخطر حيث نمتلك في شركة كشف تسربات بالدمام الامكانيات والفنين المتميزين الذين يقدمون الخدمة بتميز فاذا كنت فى حيرة من امر التسريب الذي يوجد لديك فعليك ان تعلم ان خدماتنا منتشرة في جميع انحاء المملكة مثل خدمات شركة كشف تسربات المياه بالرياض التي تحل لك المشاكل المتكررة المتعلقة بالتسربات فلا داعى للقلق من الان لانك سوف تملك فني جيد منزلك يحل لك كل مشاكل التسربات و كيفية القيام بهذه الخدمة وتذكر ان الحل الامثل فى شركة كشف تسربات بالرياض ان توفر كل الامكانيات التى تساعدك علي حل مشكلاتك

Fangyaya said...

adidas superstar shoes
louis vuitton outlet
the north face outlet
celine outlet
cheap oakley sunglasses
cheap air jordans
cheap jordans
jordan retro 4
clarisonic
timberlands
christian louboutin outlet
louis vuitton outlet stores
michael kors outlet
canada goose sale
ugg boots
uggs on sale
burberry handbags
nike trainers uk
lebron 13 shoes
polo shirts
coach outlet
ugg sale
ugg boots sale
tory burch flats
cheap uggs
louis vuitton purses
coach outlet store online clearances
true religion jeans
louboutin shoes
ralph lauren outlet
louis vuitton handbags
coach factory outlet
oakley outlet
cheap true religion
hermes bags
ray ban sonnenbrille
uggs sale
seattle seahawks jerseys
toms outlet
louis vuitton paris
20168.17chenjinyan