Handy Bonneville Spreadsheets - Triumph Forum: Triumph Rat Motorcycle Forums
» Main Menu

Discussion Forums
 » Twins
 » Tiger
 » General
 » RAT

Features
 » Blogs

Motorcycle.com Links

Contribute
 » Photo

Motorcycle Forums
» Insurance
» Sponsors

Twins Technical Talk Technical Talk for Hinckley Triumph Twins: Bonneville, T100, Speedmaster, America, Thruxton, and Scrambler.

Reply
 
LinkBack Thread Tools Display Modes
Old 11-16-2008, 02:45 PM   #1 (permalink)
Senior Member
Formula Extreme
Favourite Bike: '05 T100
 
Join Date: Jul 2007
Location: Imperial Missouri
Posts: 491
Handy Bonneville Spreadsheets

The file attached requires some sort of Winzip application to open it. The files within the ZIP file require Excel to work. (maybe Open Office will work, I have not tried it.)
Anyway, Speed&RPM.XLS will allow you to see what your RPMs will be for a given speed in any given gear with any size tire you choose. Tire outside diameter can be derived from plugging the numbers from your tire into the cels on the right side.
If you want to see the effect of RPM changes for your engine by changing tire sizes or want to see the effect of sprocket changes you can do that by simply changing numbers around. I recommend you check the gear ratios given in your own owners handbook against those I've included here as your's may be different.
In the lower part of that sheet, for fun, I've put in some calculations for pounds of force generated by objects at speed. (How many know that a 3200 lb car hitting something at 60 MPH has generated almost 400,000 lbs of force? A reminder for wearing protective gear)
The other file "Shim.XLS" allows you to calculate required valve shim thickness easily. I'm too used to the English system to change but the MM info is calculated there too. Just use your feeler gauge to measure your clearances and plug the info into the "measured in" cells. Then take out your shims and measure them and plug that info into the "Current In" cells. I measured in English and the calculation to MM is in the cells below. If you measure in MM, just put your info into the cells on the "MM" and "Current MM" lines. The info next to HI> and Low> on the right are the requires specs taken from the Haynes manual for the T100. Check the specs for your model to be sure. The numbers which get calculated on the "Required IN" and "Req. MM" lines are aimed at getting your clearances right in the middle of the specs.

Enjoy!
Attached Files
File Type: zip BonnevilleSheet.zip (9.1 KB, 353 views)

Last edited by Geimer; 11-17-2008 at 11:12 PM. Reason: More user friendly spreadsheets
Geimer is offline   Reply With Quote
Sponsored Links
Advertisement
 
Old 11-16-2008, 05:40 PM   #2 (permalink)
Lifetime Premium
Site Supporter
SuperSport
Favourite Bike: 2010 white tiger
 
cafecruzin's Avatar
 
Join Date: Feb 2007
Location: land of sweeping plains,drought n flooding rain
Posts: 1,015
open office, winzip or winrar will open them
this is very good as well
http://www.gearingcommander.com/
__________________
Only Irish coffee provides in a single glass all four essential food groups:
alcohol, caffeine, sugar and fat..
Alex Levine
Of all the tyrannies that affect mankind, tyranny of religion is the worst.
"Thomas Paine"
cafecruzin is offline   Reply With Quote
Old 11-16-2008, 08:05 PM   #3 (permalink)
Senior Member
Team Owner
Favourite Bike: 2005 Bonneville Blue 790
 
Join Date: Sep 2006
Location: Central Maryland, USA
Posts: 5,897
Other Motorcycle: 1973 CB450, long gone
Windows Explorer will open .zip files.
__________________
Marty
2005 Bonneville Blue 790cc, AI removed, Staintunes RC, Unifilter, no snorkel, 118/40/Thrux needle/1 shim/3 turns, tachometer, Ikon 7610s in back, Ricor Intiminators in front, Pirelli Sport Demons, D9 gauge panel.
Baltobonneville is offline   Reply With Quote
Old 11-18-2008, 12:52 PM   #4 (permalink)
Senior Member
Formula Extreme
Favourite Bike: '05 T100
 
Join Date: Jul 2007
Location: Imperial Missouri
Posts: 491
Hey Cafe,
And after all that work too http://www.gearingcommander.com/ is easy to use too. I did not know it was there but it did confirm that the spreadsheet is accurate at least. There is probably a 'shim-commander' out there someplace too.

Thanks
Geimer is offline   Reply With Quote
Old 04-25-2011, 12:32 PM   #5 (permalink)
Member
Grand Prix 125
Favourite Bike: '73 Norton 850 Commando
 
Reckless73's Avatar
 
Join Date: Sep 2010
Location: Burlington, NC
Posts: 30
Other Motorcycle: '07 Bonneville T100
Extra Motorcycle: Yamaha SRX600, BMW R75/7
Yes, in the first post to this thread.. my problem is that I Has s stroke rrecnely & my pscrambled brarain isn't working well with tech spec. I wa hoping o find a chart tht says if you measure .229mmclearanc on the intake use a XXXX size shim.
__________________
The object of life is to attain wisdom through experience. The trick is to survive the experience.

AI & Airbox removed, K&N filters, TORS, NewBonneville battery tray, MCResources grab rail & saddle bag brackets, Avon Roadriders
Reckless73 is offline   Reply With Quote
Old 04-25-2011, 06:20 PM   #6 (permalink)
Lifetime Premium
Site Supporter
Powerbike
Favourite Bike: 09 Bonnie A-1 Black
 
Sparky's Avatar
 
Join Date: Aug 2009
Location: Antelope Valley, CA
Posts: 392
Other Motorcycle: '84 H/D FXRP
Quote:
Originally Posted by Reckless73 View Post
Yes, in the first post to this thread.. my problem is that I Has s stroke rrecnely & my pscrambled brarain isn't working well with tech spec. I wa hoping o find a chart tht says if you measure .229mmclearanc on the intake use a XXXX size shim.
The issue here, Reckless (sorry to hear about your stroke) is that in order to know what size shim to replace with, you need to know what's already in there. The good news is that you only need to do this the first time. I use an Excel spreadsheet to keep track of what size shims are in there currently, and I also use an Excel shim calculator (I'm sure like the one referenced here (but haven't looked at it)).
I keep track of everything I'm doing on a notepad while adjusting my valves (I haven't had a stroke, but my brain ain't what it used to be). Take your time, be patient and plodding and I'm sure you'll do fine.
I presume you've read about the troubles others have had removing the cam cap bolts. I've an '09 Bonnie and had no problems at all removing the bolts!

Good luck!
-Sparky
__________________
Predators, Riccor Intimanators, Ikons, AI gone, Chainguard gone, Scottoiler, Clocks4Bikes clock, Tank pads, 42,000 on the clock.

I don't always ride a motorcycle, but when I do I prefer TriuMPH. -Ruger
Sparky is offline   Reply With Quote
Old 05-01-2011, 08:03 PM   #7 (permalink)
Member
Grand Prix 125
Favourite Bike: '73 Norton 850 Commando
 
Reckless73's Avatar
 
Join Date: Sep 2010
Location: Burlington, NC
Posts: 30
Other Motorcycle: '07 Bonneville T100
Extra Motorcycle: Yamaha SRX600, BMW R75/7
thanks Sparky,
I measured all the shims that were in there & they all mic'd !.114mmthe only trouble I had with the cam cap bolts was that I initially thought they were Allen heads so I sheared the Torx pattern in one before I realized my error but got it out without much ado, the rest were easy with a 1/4" drive.
__________________
The object of life is to attain wisdom through experience. The trick is to survive the experience.

AI & Airbox removed, K&N filters, TORS, NewBonneville battery tray, MCResources grab rail & saddle bag brackets, Avon Roadriders
Reckless73 is offline   Reply With Quote
Sponsored Links
Advertisement
 
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
A very handy site...... KuzzinKenny Tiger Chat 7 06-04-2007 12:28 PM
Might come in Handy Avi8or Speed Triple Forum 5 11-16-2006 04:32 PM
Guardrails do come in handy! 6485 Speed Triple Forum 28 10-02-2006 04:52 PM
handy tool sweatmachine Twins Talk 4 05-10-2006 09:04 AM

Powered by vBadvanced CMPS v3.2.2

All times are GMT -4. The time now is 03:38 AM.



Motorcycle News, Videos and Reviews
Kawasaki Forum Ducati Forum Harley Davidson Yamaha R1 BMW S1000RR Forum
Vulcan Forums Ducati Monster V-Rod Forum Yamaha R6 Kawasaki Z1000
Kawasaki ZX Forum Honda 600RR Harley Forum YZF-R6 Forum Sportbike Forum
Kawasaki ZX-10R Honda 1000RR Suzuki SV Yamaha FZ8 Can Am Spyder
Kawasaki KLR 650 Honda RC51 Suzuki V-Strom Star Motorcycles Aprilia Forum
Kawasaki Versys Honda Fury Suzuki GSXR Triumph Forum KTM Forum
Kawasaki EX-500 Honda Goldwing GSX-R Forum Triumph 675 Victory Forums

Garage Plus vBulletin Plugins by Drive Thru Online, Inc.

Search Engine Optimization by vBSEO 3.3.2