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] As I see it you have the following variables: DP = Depot Postcode D1P = Delivery 1 Postcode D2P = Delivery 2 Postcode LF = Lorry factor (e.g. 150% - i.e. you're making the assumption it will take 50% longer again than a regular car journey) RTMIL = Round trip miles RTMIN = Round trip minutes MMIL = Maximum number of miles a driver can travel before they are required to take a break BRMIL = Break required when maximum miles reached (e.g. 30 minutes) MMIN = Maximum number of minutes a driver can drive for before they are required to take a break BRMIN = Break required when maximum minutes reached (e.g. 15 minutes) From this you would calculate your round trip of DP -> D1P -> D2P -> DP by generating a Google Maps URL and parsing the returned XML. e.g. RTMIL = 120 miles, RTMIN = 240 minutes However, let's say MMIL = 50, so we would calculate how many whole MMIL's go into RTMIL; in this case it would be two, so we would add 2 x BRMIL = 60 minutes And MMIN = 100, so we need to apply 2 x BRMIN as well = 30 minutes So your total estimated time would be: RTMIN * LF + (ROUND(RTMIL/MMIL,0) x BRMIL) + (ROUND(RTMIN/MMIN,0) x BRMIN) 240 * 1.5 + 60 + 30 = 450 minutes If you're happy with that logic, I can upload something in about half an hour. [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.