Excel speed chart
Moderator: Moderator
- Trafficjamz
- CBR1000RR
- Posts: 5353
- Joined: Tue Jul 14, 2009 7:53 pm
- Location: Eastlake, MI
- Contact:
Excel speed chart
Just something I whipped up in excel this after noon
This chart is loosely based on a 90/90 tire.
It shows what speeds you can expect with different gears and rpm's.
Maybe it will help someone out.
This chart is loosely based on a 90/90 tire.
It shows what speeds you can expect with different gears and rpm's.
Maybe it will help someone out.
new best 1/8th mile time 9.647 seconds @67.155 mph 310lbs total weight
Re: Excel speed chart
Looks really handy
2001 Honda Elite
1995 Yamaha Jog
1994 Yamaha Axis
I can't believe
that cop put me
in the backseat
when I clearly
called shotgun.
1995 Yamaha Jog
1994 Yamaha Axis
I can't believe
that cop put me
in the backseat
when I clearly
called shotgun.
- Trafficjamz
- CBR1000RR
- Posts: 5353
- Joined: Tue Jul 14, 2009 7:53 pm
- Location: Eastlake, MI
- Contact:
Re: Excel speed chart
Photo bucket keeps resizing it too small to read
new best 1/8th mile time 9.647 seconds @67.155 mph 310lbs total weight
Re: Excel speed chart
I saved it and up-sized it using Microsoft office picture manager. It made it just big enough to read before it got blurry.
2001 Honda Elite
1995 Yamaha Jog
1994 Yamaha Axis
I can't believe
that cop put me
in the backseat
when I clearly
called shotgun.
1995 Yamaha Jog
1994 Yamaha Axis
I can't believe
that cop put me
in the backseat
when I clearly
called shotgun.
- Trafficjamz
- CBR1000RR
- Posts: 5353
- Joined: Tue Jul 14, 2009 7:53 pm
- Location: Eastlake, MI
- Contact:
Re: Excel speed chart
bigger font
500 rpm scale
new best 1/8th mile time 9.647 seconds @67.155 mph 310lbs total weight
-
- Veteran OG
- Posts: 3639
- Joined: Tue May 22, 2007 8:10 pm
- Location: North of Seattle, WA
Re: Excel speed chart
Nice:
We've been working on similar info - I made a chart along with the table, but had not posted yet. Was going to measure other tires and make a family of tables and graphs.
Anyhow, for the tables and graphs we can put them into the 'wiki, rather than a photo. Will read nice and clear from there.
--- Edit: 01/25/2011 ---
Original graph has been replaced.
Reason: 90/90 tire dia was incorrect. Now using 16.36in
Note: Fixes problem noted later in this thread.
We've been working on similar info - I made a chart along with the table, but had not posted yet. Was going to measure other tires and make a family of tables and graphs.
Anyhow, for the tables and graphs we can put them into the 'wiki, rather than a photo. Will read nice and clear from there.
--- Edit: 01/25/2011 ---
Original graph has been replaced.
Reason: 90/90 tire dia was incorrect. Now using 16.36in
Note: Fixes problem noted later in this thread.
- Trafficjamz
- CBR1000RR
- Posts: 5353
- Joined: Tue Jul 14, 2009 7:53 pm
- Location: Eastlake, MI
- Contact:
Re: Excel speed chart
That's Better
new best 1/8th mile time 9.647 seconds @67.155 mph 310lbs total weight
-
- Veteran OG
- Posts: 3639
- Joined: Tue May 22, 2007 8:10 pm
- Location: North of Seattle, WA
Re: Excel speed chart
1st class
--
A quick check shows our calculations are within about 0.3%. Probably just tire circumference assumption.
Our tables and graphs differ in choice of dependent (y) vs independent (x) axis. IMHO both layouts have merits.
--- Edit: 01/25/2011 ---
Original chart has been replaced.
Reason: 90/90 tire dia was incorrect. Now using 16.36in
Note: Fixes problem noted later in this thread.
--
A quick check shows our calculations are within about 0.3%. Probably just tire circumference assumption.
Our tables and graphs differ in choice of dependent (y) vs independent (x) axis. IMHO both layouts have merits.
--- Edit: 01/25/2011 ---
Original chart has been replaced.
Reason: 90/90 tire dia was incorrect. Now using 16.36in
Note: Fixes problem noted later in this thread.
- Trafficjamz
- CBR1000RR
- Posts: 5353
- Joined: Tue Jul 14, 2009 7:53 pm
- Location: Eastlake, MI
- Contact:
Re: Excel speed chart
My chart assumes a tire circumference of 49.455 inches.
new best 1/8th mile time 9.647 seconds @67.155 mph 310lbs total weight
-
- Veteran OG
- Posts: 3639
- Joined: Tue May 22, 2007 8:10 pm
- Location: North of Seattle, WA
Re: Excel speed chart
I used 49.23 inches. Pretty much covers it. I'd meant to say "A quick check shows our calculations are within about 0.3%. Probably just tire circumference assumption." Can't hardly expect to be that closeMy chart assumes a tire circumference of 49.455 inches.
- Wheelman-111
- Moderator
- Posts: 11319
- Joined: Wed Oct 22, 2008 5:09 pm
- Location: Deepinnaharta, Texas
Spreadsheet Speculation
Greetings:
This is great, Dawgs! Some Empiric observations:
The 90/90 has a nominal height of 3.18". Multiply by 2 and add the 10" rim and you get 16.36. Times pi and you're right at 51" inches circumference, give or take. The 3.50s calculate to 53" circumference.
I actually measured one - can't recall which - with a drop of paint and got 52", so maybe 49" is close for 3.00s but too pessimistic for the bigger skins?
With 7.97:1s and a Giant 97mm Drive Face, Flash 3.2 went 66.3 MPH turning a bit over 10K - again, not sure due to failiing Wheel-sight and gale-force tears in the goggles. I suspect there's a good percentage of belt slip and tire grip loss. The faster you go, the more the slip/slop factor as the wind drag pressure increases.
This is great, Dawgs! Some Empiric observations:
The 90/90 has a nominal height of 3.18". Multiply by 2 and add the 10" rim and you get 16.36. Times pi and you're right at 51" inches circumference, give or take. The 3.50s calculate to 53" circumference.
I actually measured one - can't recall which - with a drop of paint and got 52", so maybe 49" is close for 3.00s but too pessimistic for the bigger skins?
With 7.97:1s and a Giant 97mm Drive Face, Flash 3.2 went 66.3 MPH turning a bit over 10K - again, not sure due to failiing Wheel-sight and gale-force tears in the goggles. I suspect there's a good percentage of belt slip and tire grip loss. The faster you go, the more the slip/slop factor as the wind drag pressure increases.
Wheelman-111
Most of my money is spent on scooterparts. The rest is just wasted.
"ISO": '03 Vespa ET4 Malossi187 74MPH
Flash 9: 2001 Elite SR Contesta 72 ZX Tran, 9:1 Gears, Stock Airbox/Carb/Pipe 58.8 MPH
Punkin: 2010 Vespa/Malossi S78, 61MPH
Most of my money is spent on scooterparts. The rest is just wasted.
"ISO": '03 Vespa ET4 Malossi187 74MPH
Flash 9: 2001 Elite SR Contesta 72 ZX Tran, 9:1 Gears, Stock Airbox/Carb/Pipe 58.8 MPH
Punkin: 2010 Vespa/Malossi S78, 61MPH
-
- Veteran OG
- Posts: 3639
- Joined: Tue May 22, 2007 8:10 pm
- Location: North of Seattle, WA
Re: Excel speed chart
Great catch Wheelman - thanks for checking!
Yeah, circumference is off. Will fix once at home. Also - good input on Flash, belt slippage and other factors causing RPM to not track the charts.
Yeah, circumference is off. Will fix once at home. Also - good input on Flash, belt slippage and other factors causing RPM to not track the charts.
-
- CBR1000RR
- Posts: 4219
- Joined: Thu Mar 05, 2009 9:02 pm
- Location: Iowa, USA
Re: Excel speed chart
It would be great to develop some sort of a camera to mount inside the belt cover so we could see where the belt is riding on the pulley at the moment of top speed.
motormike wrote:Errands become adventures.
Re: Excel speed chart
I did that. Only it wasn't in the cover, i had the rear half of the af16 cover off.
2001 Honda Elite
1995 Yamaha Jog
1994 Yamaha Axis
I can't believe
that cop put me
in the backseat
when I clearly
called shotgun.
1995 Yamaha Jog
1994 Yamaha Axis
I can't believe
that cop put me
in the backseat
when I clearly
called shotgun.
- Petrock's 1984 Spree
- Elite
- Posts: 768
- Joined: Wed Dec 01, 2010 10:20 pm
- Location: Iowa
Re: Excel speed chart
I remember seeing somewhere on youtube that some guys actually put a high speed camera in the jug of a 4 stroke engine. Then they ran it and you could see the different strokes and the valves move, combustion, etc. It was really cool. Ovbiously it wouldnt be that extreme but same concept
Complete NOOB, sorry dudes
1984 Iowa Spreedio aka "Hammy"
-72cc Polini Corsa
-V8 Typhoon Exhaust
-21mm OKO & CT Mani
-ZX Trans 1k Contra
-8.44:1 Gears
-Polini 2 Shoe Clutch
-Koso Vented Clutch Bell
-Polini Ruckus Vari w/ 6.9g weights
-669x18x30 Belt
1984 Iowa Spreedio aka "Hammy"
-72cc Polini Corsa
-V8 Typhoon Exhaust
-21mm OKO & CT Mani
-ZX Trans 1k Contra
-8.44:1 Gears
-Polini 2 Shoe Clutch
-Koso Vented Clutch Bell
-Polini Ruckus Vari w/ 6.9g weights
-669x18x30 Belt