Not logged in [
Login
-
Register
]
You Are Not Registered Or Not Logged In
Corsa Sport
»
Message Board
»
Off Day
»
Geek Day
»
Excel Delivery Diary?
» Post Reply
Post Reply
Who Can Post?
All users can post new topics and all users can reply.
Icon:
Formatting Mode:
Normal
Advanced
Help
Andale Mono
Arial
Arial Black
Book Antiqua
Century Gothic
Comic Sans MS
Courier New
Georgia
Impact
Tahoma
Times New Roman
Trebuchet MS
Script MT Bold
Stencil
Verdana
Lucida Console
-2
-1
1
2
3
4
5
6
White
Black
Red
Yellow
Pink
Green
Orange
Purple
Blue
Beige
Brown
Teal
Navy
Maroon
LimeGreen
Message:
HTML is Off
Smilies are On
BB Code is On
[img] Code is On
[quote][i]Originally posted by evilrob[/i] Had a spare moment this evening so whipped this up: https://www.youtube.com/watch?v=tH7hjPgsjuY In the video I am manually doing things in Google Maps alongside the spreadsheet only to verify/demonstrate it is working. In this example I have 4 deliveries that need to be made and I want to find out which two I can do in a day. There is a parameters worksheet where you can specify the 'slow lorry factor', maximum number of minutes a driver can do in a day, the depot postcode, and set criteria for when breaks should be taken and for how long. To find out the round trip for one delivery (i.e. depot -> delivery address -> return to depot), you set column G to TRUE for the appropriate row. Column J will return the miles from Google Maps, Column K will return an adjusted number of minutes including 'slow lorry factor' and any required breaks. If you want to see the miles / minutes for a second delivery on the round, you put the delivery ID of the second delivery in column H. Column M will return TRUE or FALSE depending on whether the total minutes required to do the round is less than the maximum number of minutes a driver can do as set in the Parameters worksheet. :thumbs: edit: edited due to incorrect column specified above. [Edited on 21-02-2013 by evilrob] [/quote]
Post Options:
Disable smileys?
Turn BBCode off?
Receive email notification of new replies?
This is a long topic, click
here
to review it.