Page 1 of 2 12 LastLast
Results 1 to 20 of 23

Thread: I did some calculations in excel...

  1. #1
    Hardcore Biker Warrenpridgeon's Avatar
    Join Date
    Jan 2008
    Location
    Bryanston/Vereeniging
    Bike
    RIP - 2003 Suzuki SV650S :( ... Sold - 2006 GSXR 750 :-( .2015 Harley Street 750. 2011 Daytona 675!
    Region
    Gauteng
    Posts
    5,189

    Comment I did some calculations in excel...

    So... I've got one of them there analytical brains.

    I broke my 90km commute up into 5 segments roughly showing the speeds per segment on an average day.
    It can vary depending on traffic etc.

    leg distance in km speed in km/h Time in min 20% faster Time in min 40% faster Time in min 60% faster Time in min
    1 5 40 7,5 48 6,25 56 5,35714 60 5
    2 10 60 10 72 8,33333 84 7,14286 90 6,66667
    3 10 80 7,5 96 6,25 112 5,35714 120 5
    4 60 120 30 144 25 168 21,4286 180 20
    5 5 50 6 60 5 70 4,28571 75 4
    Total 90 61 50,8333 43,5714 40,6667


    So... If I stick to the first "speed" column it takes me roughly an hour to do the trip.
    Pushing the speed up by 20% only shaves 10mins off the journey.

    I included a couple of segments of "slow" highway traffic from like william nicol down the N1 South.

    In segment 2 I might be lanesplitting as the cars maybe do 40 there... So if I'm doing 50 - 60 I'm reasonably safe... but pushing it up to 72... that will be almost double the speed the cars are doing. In that segment I would save only like a minute or MAYBE two by increasing my speed.

    In segment 3 I will probably be in the lane acting like a car because the traffic is generally doing 80km/h there. I would have to lane split at 96km/h to be going 20% faster. Again it would only gain me roughly a minute or two.

    So... While commuting I am often thinking "how much will I really gain from going a little faster here?", and it seems the answer is "not much".
    UNLESS
    Unless I am going to go a LOT faster.
    But even then, even at 60% faster over the whole journey I only gain 20mins.

    YMMV

    This is just how I am currently approaching my commute. Use it, don't use it.
    Learn from other peoples mistakes....You can't live long enough to make them all yourself...

  2. #2
    Mommy's sweet, little boy Biker mom's son's Avatar
    Join Date
    Nov 2011
    Location
    Roodepoort
    Bike
    KTM 1290SuperDuke R
    Region
    Gauteng
    Posts
    1,311

    Default

    When could harleys reach 120? Hehe

    Just joking, please don't kill me.

  3. #3
    Hardcore Biker Warrenpridgeon's Avatar
    Join Date
    Jan 2008
    Location
    Bryanston/Vereeniging
    Bike
    RIP - 2003 Suzuki SV650S :( ... Sold - 2006 GSXR 750 :-( .2015 Harley Street 750. 2011 Daytona 675!
    Region
    Gauteng
    Posts
    5,189

    Default

    Quote Originally Posted by Biker mom's son View Post
    When could harleys reach 120? Hehe

    Just joking, please don't kill me.
    Lol... when they fall down a mineshaft :-P.
    I cruise pretty comfortably on mine at 120km/h pretty easily too.
    Learn from other peoples mistakes....You can't live long enough to make them all yourself...

  4. #4
    Mommy's sweet, little boy Biker mom's son's Avatar
    Join Date
    Nov 2011
    Location
    Roodepoort
    Bike
    KTM 1290SuperDuke R
    Region
    Gauteng
    Posts
    1,311

    Default

    Quote Originally Posted by Warrenpridgeon View Post
    Lol... when they fall down a mineshaft :-P.
    I cruise pretty comfortably on mine at 120km/h pretty easily too.
    I like the 750, i read that it's chassis is quite good and makes the bike stable.

  5. #5
    Cheeky!
    Cubby's Avatar
    Join Date
    May 2013
    Location
    Lyndhurst
    Bike
    Kawazaki Er6n
    Region
    Gauteng
    Posts
    1,448

    Default

    That is the point, however fast you ride you seldom make a significant saving of time and the saving of time doesn't merit the increased risk of not making it to your destination.

    I commute from Edenvale to kya sands and the difference between using the car and bike, under similar conditions, is about 5 mins, obviously the difference is significant when trafic is backed up and you spend most of the trip splitting.

  6. #6
    Adventure Biker
    Join Date
    Jul 2014
    Bike
    Yamaha
    Region
    Western Cape
    Posts
    2,468

    Default

    Quote Originally Posted by Warrenpridgeon View Post
    So... I've got one of them there analytical brains.

    I broke my 90km commute up into 5 segments roughly showing the speeds per segment on an average day.
    It can vary depending on traffic etc.

    leg distance in km speed in km/h Time in min 20% faster Time in min 40% faster Time in min 60% faster Time in min
    1 5 40 7,5 48 6,25 56 5,35714 60 5
    2 10 60 10 72 8,33333 84 7,14286 90 6,66667
    3 10 80 7,5 96 6,25 112 5,35714 120 5
    4 60 120 30 144 25 168 21,4286 180 20
    5 5 50 6 60 5 70 4,28571 75 4
    Total 90 61 50,8333 43,5714 40,6667


    So... If I stick to the first "speed" column it takes me roughly an hour to do the trip.
    Pushing the speed up by 20% only shaves 10mins off the journey.

    I included a couple of segments of "slow" highway traffic from like william nicol down the N1 South.

    In segment 2 I might be lanesplitting as the cars maybe do 40 there... So if I'm doing 50 - 60 I'm reasonably safe... but pushing it up to 72... that will be almost double the speed the cars are doing. In that segment I would save only like a minute or MAYBE two by increasing my speed.

    In segment 3 I will probably be in the lane acting like a car because the traffic is generally doing 80km/h there. I would have to lane split at 96km/h to be going 20% faster. Again it would only gain me roughly a minute or two.

    So... While commuting I am often thinking "how much will I really gain from going a little faster here?", and it seems the answer is "not much".
    UNLESS
    Unless I am going to go a LOT faster.
    But even then, even at 60% faster over the whole journey I only gain 20mins.

    YMMV

    This is just how I am currently approaching my commute. Use it, don't use it.
    Very interesting reading. What should be interesting to add is fuel consumption on regular, 20% to 60 % faster each measured obvious over a period of a week (Mon to Fry). I would also like to see how the current statistics would balance out should each scenario be calculated over a 5 day period.

    On the trucks did very much the same to calculate the best driving time versus fuel consumption and found maintaining 76 km/h on the GPS, avoiding peak traffic, Driving the opti-cruise on and gearshift selected to automatic, the truck performed at its best giving a pleasant 2.4 km/l average (56 Tonnes total) and the least stress on wearable components such as the clutch and the sentinel took the least amount of oil over a 18 000 km period.

    Very nice seeing someone interested in gathering statistics on a bike commute. Thanks for the effort! Well done!

  7. #7
    Herman the German THE MOOSE's Avatar
    Join Date
    Jul 2008
    Location
    Randpark Ridge
    Bike
    R80GS PD
    Region
    Gauteng
    Posts
    3,201

    Default

    Interesting spreadsheet. One column missing, how much more does the fuel cost you when going faster? Are the potential savings that important?

    More important to me, comparing to my daily commute: what difference does 5 minutes make for you in reaching your office faster? Probably none, or if it is that crucial, who stops you from leaving 5 minutes earlier?

    I have compared the time difference between using the suicide lane and lane splitting on my stretch between Beyers Naude and Rivonia. If the guys/gals using the suicide lane make 5 minutes on me, that is a lot. To me, it is not worth changing that. Particularly considering the much more dangerous situations you do create by going faster, irrespective of the lane you choose.

    At least I can say we do have a lot of guys/gals on bikes, who qualify as fear factor participants.
    You don't ride in the rain, you don't ride!

  8. #8
    Lightship Captain
    WBro's Avatar
    Join Date
    Oct 2008
    Location
    Howick / Kyalami
    Bike
    Big BMW & Small Yamaha
    Region
    KwaZulu-Natal
    Posts
    6,969

    Default

    Quote Originally Posted by THE MOOSE View Post
    Interesting spreadsheet. One column missing, how much more does the fuel cost you when going faster? Are the potential savings that important?

    More important to me, comparing to my daily commute: what difference does 5 minutes make for you in reaching your office faster? Probably none, or if it is that crucial, who stops you from leaving 5 minutes earlier?

    I have compared the time difference between using the suicide lane and lane splitting on my stretch between Beyers Naude and Rivonia. If the guys/gals using the suicide lane make 5 minutes on me, that is a lot. To me, it is not worth changing that. Particularly considering the much more dangerous situations you do create by going faster, irrespective of the lane you choose.

    At least I can say we do have a lot of guys/gals on bikes, who qualify as fear factor participants.
    So true.

    Many I am sure are unaware of the possible outcomes of their actions in the SL or splitting at higher speeds. Reality faces you straight on when impacted...

  9. #9
    Hooligan Biker Arktic's Avatar
    Join Date
    Jul 2013
    Location
    Cape Town
    Bike
    '13 Aprilia Tuono V4R
    Region
    Western Cape
    Posts
    405

    Default

    Thanks for the very informative data!

    It just reassures why reason for riding. I ride because I love it, not to get there any quicker than any one else.

    Yes I do save petrol over using my car even on my not so efficient GSR but that's besides the point for me.

  10. #10
    Nuon Fangirl

    Join Date
    Mar 2008
    Bike
    BMW R1200GS
    Region
    Gauteng
    Posts
    39,012

    Default

    Quote Originally Posted by Arktic View Post

    It just reassures why reason for riding. I ride because I love it, not to get there any quicker than any one else.

    .
    +1000!

  11. #11
    GoogleBoy Pyro's Avatar
    Join Date
    Dec 2009
    Location
    Roodepoort
    Bike
    Honda CBR600F
    Region
    Gauteng
    Posts
    4,675

    Default

    Traffic light synchornisation can also become important in the urban sections, often going slightly faster means you'll just hit the next light on red.

    You'll have to go significantly faster than the indicated speed limit in synchronised sections to catch the next light green. The flipside is if traffic is averaging lower speeds and going faster would actually help you stay synced.
    Four wheels move the Body; Two wheels move the Soul
    Fuelly: CBR600F Ninja 250R

  12. #12
    Brighty Lighty

    Join Date
    Mar 2009
    Location
    Northriding
    Bike
    BMW 1200 GSA, KTM450, PGO 125, Can Am Spyder RT
    Region
    Gauteng
    Posts
    1,964

    Default

    Bikes are meant to be used for enjoyment and relaxation.....why do you have to calculate and analyse the crap out them.........just ride and enjoy....EISH..!!!

  13. #13
    Hardcore Biker Warrenpridgeon's Avatar
    Join Date
    Jan 2008
    Location
    Bryanston/Vereeniging
    Bike
    RIP - 2003 Suzuki SV650S :( ... Sold - 2006 GSXR 750 :-( .2015 Harley Street 750. 2011 Daytona 675!
    Region
    Gauteng
    Posts
    5,189

    Default

    Quote Originally Posted by Trevelle View Post
    Bikes are meant to be used for enjoyment and relaxation.....why do you have to calculate and analyse the crap out them.........just ride and enjoy....EISH..!!!
    To see if it's worth increasing the risk.
    It's not.
    It was also a thought that popped into my head while I was riding, so I wanted to see if my thinking was right.
    It was.
    Perhaps someone who does push a bit too hard through the traffic could see this and decide to dial it back a bit?
    Learn from other peoples mistakes....You can't live long enough to make them all yourself...

  14. #14
    Herman the German THE MOOSE's Avatar
    Join Date
    Jul 2008
    Location
    Randpark Ridge
    Bike
    R80GS PD
    Region
    Gauteng
    Posts
    3,201

    Default

    Trevelle, you have a point. But so does Warrenpridgeon. Commuting is not necessarily a form of enjoyment and relaxation and I believe it is a valid point to discuss the safety aspect of the daily ride.

    As much as I enjoy riding anywhere any time, the morning commute on the highway, splitting, texting drivers and all, is not pure enjoyment and relaxation is relevant when you have to be on top of the game all the time to stay safe.

    Going faster does not allow you to relax and increases the risk/danger a hell of a lot.
    You don't ride in the rain, you don't ride!

  15. #15
    N.O.B. CycleJunkie's Avatar
    Join Date
    Aug 2010
    Location
    4 Ways, Gauteng
    Bike
    Triumph Tiger 800XC; Siouxsie Suzuki DR650; Honda CR125; Specialised Peloton; Tommasini; Momsen 29'e
    Region
    Gauteng
    Posts
    743

    Default

    I have not done any comparisons of speed differences except between car and bike. 10 minutes by bike often translates into 30 - 40 minutes by car. I ride bike as often as possible.
    Hoo Haa

  16. #16
    GoogleBoy Pyro's Avatar
    Join Date
    Dec 2009
    Location
    Roodepoort
    Bike
    Honda CBR600F
    Region
    Gauteng
    Posts
    4,675

    Default

    Quote Originally Posted by CycleJunkie View Post
    I have not done any comparisons of speed differences except between car and bike. 10 minutes by bike often translates into 30 - 40 minutes by car. I ride bike as often as possible.
    On a good day the car is faster. No ATGATT juggle. On a bad day the bike is faster.
    Four wheels move the Body; Two wheels move the Soul
    Fuelly: CBR600F Ninja 250R

  17. #17
    "The Coach"

    Coachman's Avatar
    Join Date
    May 2011
    Location
    Fairlands, Johannesburg
    Bike
    BMW R1200GS LC
    Region
    Gauteng
    Posts
    2,246

    Default

    Excellent article Warren, thanks for the effort and for sharing!
    I commute daily and on a bad traffic day the bike is better and on a good traffic day the bike is even better lol
    In short what you have deduced is so correct - you have to go a heck of a lot faster to make an appreciable time saving on an average trip of say an hour or less.

    Sent from my SM-G920F using Tapatalk
    "There are Old Bikers and there are Bold Bikers, but not a hell of a lot of Old Bold Bikers"
    Coachman

  18. #18
    Hardcore Biker Warrenpridgeon's Avatar
    Join Date
    Jan 2008
    Location
    Bryanston/Vereeniging
    Bike
    RIP - 2003 Suzuki SV650S :( ... Sold - 2006 GSXR 750 :-( .2015 Harley Street 750. 2011 Daytona 675!
    Region
    Gauteng
    Posts
    5,189

    Default

    Quote Originally Posted by Pyro View Post
    On a good day the car is faster. No ATGATT juggle. On a bad day the bike is faster.
    My ATGATT juggle is a lot quicker than it used to be. Hehehe.
    With my journey (100km+-) I make up the 5 to 10 mins ATTGAT juggle time if the traffic stalls even once.
    Plus...I am much more relaxed by the time I get to work if I use the bike.
    I get WAAAAAY more worked up driving a car than riding a bike.
    Go figure...
    Plus the bike is much more fun.
    Learn from other peoples mistakes....You can't live long enough to make them all yourself...

  19. #19
    Hardcore Biker Warrenpridgeon's Avatar
    Join Date
    Jan 2008
    Location
    Bryanston/Vereeniging
    Bike
    RIP - 2003 Suzuki SV650S :( ... Sold - 2006 GSXR 750 :-( .2015 Harley Street 750. 2011 Daytona 675!
    Region
    Gauteng
    Posts
    5,189

    Default

    Quote Originally Posted by Coachman View Post
    Excellent article Warren, thanks for the effort and for sharing!
    I commute daily and on a bad traffic day the bike is better and on a good traffic day the bike is even better lol
    In short what you have deduced is so correct - you have to go a heck of a lot faster to make an appreciable time saving on an average trip of say an hour or less.

    Sent from my SM-G920F using Tapatalk
    People roll their eyes at me when I say stuff about slow down because it increases risk factors a lot for not much gain.
    Learn from other peoples mistakes....You can't live long enough to make them all yourself...

  20. #20
    GoogleBoy Pyro's Avatar
    Join Date
    Dec 2009
    Location
    Roodepoort
    Bike
    Honda CBR600F
    Region
    Gauteng
    Posts
    4,675

    Default

    Quote Originally Posted by Warrenpridgeon View Post
    My ATGATT juggle is a lot quicker than it used to be. Hehehe.
    With my journey (100km+-) I make up the 5 to 10 mins ATTGAT juggle time if the traffic stalls even once.
    Plus...I am much more relaxed by the time I get to work if I use the bike.
    I get WAAAAAY more worked up driving a car than riding a bike.
    Go figure...
    Plus the bike is much more fun.
    For long trips it's almost always worth it.

    My commute is under 25km, and 5-10 minutes is hard to make up if the traffic delay is only 5-10 minutes on good days.

    The main gain is consistency and the 'relaxed' bit.
    Really bad days are maybe 10 minutes longer on the bike and an hour longer with the car.
    It's surprising how frustrating standing traffic can be, even if it's only for a few minutes.
    Just staying mobile reduces that frustration, but I must admit I've grown used to having my headset for company on the bike.
    Four wheels move the Body; Two wheels move the Soul
    Fuelly: CBR600F Ninja 250R

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •