Excel speed chart

Does your Spree/Elite already run great, and you're trying to make it quicker/faster? Need a monster motor swap? Discuss your ideas here.

Moderator: Moderator

User avatar
Trafficjamz
CBR1000RR
CBR1000RR
Posts: 5353
Joined: Tue Jul 14, 2009 7:53 pm
Location: Eastlake, MI
Contact:

Excel speed chart

Post by Trafficjamz »

Just something I whipped up in excel this after noon :thumbwink:

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.

Image
new best 1/8th mile time 9.647 seconds @67.155 mph 310lbs total weight
User avatar
evilone
Board Supporter
Board Supporter
Posts: 3205
Joined: Sun May 18, 2008 7:26 pm
Location: Portage Michigan

Re: Excel speed chart

Post by evilone »

Looks really handy Image
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.
User avatar
Trafficjamz
CBR1000RR
CBR1000RR
Posts: 5353
Joined: Tue Jul 14, 2009 7:53 pm
Location: Eastlake, MI
Contact:

Re: Excel speed chart

Post by Trafficjamz »

Photo bucket keeps resizing it too small to read :x
new best 1/8th mile time 9.647 seconds @67.155 mph 310lbs total weight
User avatar
evilone
Board Supporter
Board Supporter
Posts: 3205
Joined: Sun May 18, 2008 7:26 pm
Location: Portage Michigan

Re: Excel speed chart

Post by evilone »

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.
User avatar
Trafficjamz
CBR1000RR
CBR1000RR
Posts: 5353
Joined: Tue Jul 14, 2009 7:53 pm
Location: Eastlake, MI
Contact:

Re: Excel speed chart

Post by Trafficjamz »

Image

bigger font

500 rpm scale
new best 1/8th mile time 9.647 seconds @67.155 mph 310lbs total weight
mousewheels
Veteran OG
Veteran OG
Posts: 3639
Joined: Tue May 22, 2007 8:10 pm
Location: North of Seattle, WA

Re: Excel speed chart

Post by mousewheels »

Nice: :thumbwink: :thumbwink:

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.
Wheel_RPM_Graph.jpg
Wheel_RPM_Graph.jpg (201.84 KiB) Viewed 7561 times
User avatar
Trafficjamz
CBR1000RR
CBR1000RR
Posts: 5353
Joined: Tue Jul 14, 2009 7:53 pm
Location: Eastlake, MI
Contact:

Re: Excel speed chart

Post by Trafficjamz »

Image

That's Better :2thumbs:
new best 1/8th mile time 9.647 seconds @67.155 mph 310lbs total weight
mousewheels
Veteran OG
Veteran OG
Posts: 3639
Joined: Tue May 22, 2007 8:10 pm
Location: North of Seattle, WA

Re: Excel speed chart

Post by mousewheels »

1st class :hi:

--
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.
Wheel_RPM_Calculation_4.jpg
Wheel_RPM_Calculation_4.jpg (287.67 KiB) Viewed 7561 times
User avatar
Trafficjamz
CBR1000RR
CBR1000RR
Posts: 5353
Joined: Tue Jul 14, 2009 7:53 pm
Location: Eastlake, MI
Contact:

Re: Excel speed chart

Post by Trafficjamz »

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
mousewheels
Veteran OG
Veteran OG
Posts: 3639
Joined: Tue May 22, 2007 8:10 pm
Location: North of Seattle, WA

Re: Excel speed chart

Post by mousewheels »

My chart assumes a tire circumference of 49.455 inches.
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 close
User avatar
Wheelman-111
Moderator
Moderator
Posts: 11319
Joined: Wed Oct 22, 2008 5:09 pm
Location: Deepinnaharta, Texas

Spreadsheet Speculation

Post by Wheelman-111 »

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.
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
mousewheels
Veteran OG
Veteran OG
Posts: 3639
Joined: Tue May 22, 2007 8:10 pm
Location: North of Seattle, WA

Re: Excel speed chart

Post by mousewheels »

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.
eliteguy50
CBR1000RR
CBR1000RR
Posts: 4219
Joined: Thu Mar 05, 2009 9:02 pm
Location: Iowa, USA

Re: Excel speed chart

Post by eliteguy50 »

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.
User avatar
evilone
Board Supporter
Board Supporter
Posts: 3205
Joined: Sun May 18, 2008 7:26 pm
Location: Portage Michigan

Re: Excel speed chart

Post by evilone »

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.
User avatar
Petrock's 1984 Spree
Elite
Elite
Posts: 768
Joined: Wed Dec 01, 2010 10:20 pm
Location: Iowa

Re: Excel speed chart

Post by Petrock's 1984 Spree »

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
Post Reply