Giving Back - Torque Spec Spreadsheet - BMW Luxury Touring Community
 
LinkBack Thread Tools Display Modes
post #1 of 18 Old Apr 13th, 2009, 12:42 pm Thread Starter
Senior Member
 
tonygret's Avatar
 
Join Date: May 2008
Location: Thousand Oaks, California, USA
Posts: 407
Giving Back - Torque Spec Spreadsheet

I have received so much valuable information here that I felt I had to give back in some way. I searched for a comprehensive torque sheet for basic services and couldnít find one. (Keep in mind I canít find a spoon in my silverware drawer either).

Attached to this post is an Excel spreadsheet with the most common 32 torque specs for the LT. You can add up to 400 in total on your own. The sheet will automatically convert any NM entries to Ft-Lbís and also has a separate calculator for going both ways.

If you do not have MS Office, simply point your web browser to www.openoffice.org and download Open Office. Itís absolutely free and will open any MS Office document.

If you find any errors please let me know and I will correct them and repost.

Thank you all for your help and enjoy.
Attached Files
File Type: xls Torque Specks.xls (44.0 KB, 306 views)
tonygret is offline  
Sponsored Links
Advertisement
 
post #2 of 18 Old Apr 13th, 2009, 12:54 pm
Senior Member
 
cfell's Avatar
 
Join Date: Apr 2004
Location: Round Rock, TX, USA
Posts: 7,794
Re: Giving Back - Torque Spec Spreadsheet

Kewl... can we get this in the HOW?
cfell is offline  
post #3 of 18 Old Apr 13th, 2009, 2:31 pm
Senior Member
 
JATownsend's Avatar
 
Join Date: Oct 2003
Location: Bloomfield Hills, MI, USA
Posts: 1,134
Re: Giving Back - Torque Spec Spreadsheet

Thanks Tony!!
I'm going to glue it to the inside front cover of my Clymer LT Service Manual

J. Averill Townsend
Bloomfield Hills, MI


IBA# 24374

2002 K1200LTC - Silver
1978 R100/7 - Very, very Black
2004 Bushtec Quantum - Silver, of course...(SOLD)

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
JATownsend is offline  
 
post #4 of 18 Old Apr 13th, 2009, 2:35 pm
Senior Member
 
hallzee's Avatar
 
Join Date: Mar 2006
Location: Gold Country, CA, USA
Posts: 2,571
Thumbs up Re: Giving Back - Torque Spec Spreadsheet

Nicely done! Thanks Tony!

Brian
CCR: 2008, Midway; 2011, Boise; 2012, Duluth; 2014, Chattanooga. MOA: Billings, 2015; SLC, 2017
CCR-R: 2018, Russellville
'13 K1600 GTL-P - "Eva"
Sold but "beloved" ride: K12 LT - "Pepe"
IBA #31242 (SSx2, BB, BBG)
MOA #136148

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
-
hallzee is offline  
post #5 of 18 Old Apr 13th, 2009, 3:46 pm
Senior Member
 
BigGeo's Avatar
 
Join Date: Oct 2008
Location: Princeton, MA, USA
Posts: 360
Re: Giving Back - Torque Spec Spreadsheet

Thanks Tony. My abacus was getting worn out doing the conversions.
BigGeo is offline  
post #6 of 18 Old Apr 13th, 2009, 3:57 pm
Senior Member
 
haughty's Avatar
 
Join Date: Jun 2008
Location: Spring, Tx, USA
Posts: 910
Re: Giving Back - Torque Spec Spreadsheet

Your so Kewl!

OK for the answer to the "where are the spoons",
You left them in the garage with the ice cream containers whilst your mad dash across the abacus discs.. Your welcome!

Really, thanks again.. This is the kewlist site for information. Ve haf eet now!

Don't be afraid to say what you feel, as those that matter DOnt mind and those that mind Dont matter.
Dr.Suess-
-


1980 YAMAHA XJ650 MAXIM (RIP)
1982 YAMAHA 750 VIRAGO (SHES GONE)
1982 SUZUKI GS1000 (GONE)
2001 BMW K1200LT
2004 BMW R 1150 RT Sold.....
2007 BMW R 1200 GS
1986 BMW K100RT WITH A FLEXIT SIDECAR
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

1985 BMW K100 RT ( parts bike, but its too nice to do that, so it runs)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
haughty is offline  
post #7 of 18 Old Apr 13th, 2009, 6:54 pm
Senior Member
 
Toolman's Avatar
 
Join Date: Sep 2005
Location: Katy, TX - USA
Posts: 507
Thumbs up Re: Giving Back - Torque Spec Spreadsheet

Nice work. Funny, I just made one of these today too. Couple of quick suggestions;

1) Technically speaking, the units should be represented as lb-ft, not ft-lb. I know most people say "foot pounds", but technically, this is not correct. It's lbs per foot, not the other way around.
2) Consider adding another column for lb-in. For the lower values, my lb-ft wrench doesn't go that low, so I have to use my smaller torque wrench that only has lb-in's.
3) Unlock the protected cells so folks can save a local copy and edit as they see fit.

Regards,
Toolman

I wish I could think of clever things to say in my signature.
Toolman is offline  
post #8 of 18 Old Apr 13th, 2009, 7:42 pm
Senior Member
 
Florian's Avatar
 
Join Date: Jun 2006
Location: North Coast, OH , USA
Posts: 1,165
Re: Giving Back - Torque Spec Spreadsheet

Thanks, Tony!


F

BMWMOA
12 GTL
Florian is offline  
post #9 of 18 Old Apr 13th, 2009, 7:53 pm
Old Slow Guy in A Fast Car
 
katnapinn's Avatar
 
Join Date: Apr 2006
Location: Kyle, Texas, USA
Posts: 8,597
Re: Giving Back - Torque Spec Spreadsheet

Very nice, thanks Tony.

Stevie Shreeve
katnapinn is offline  
post #10 of 18 Old Apr 13th, 2009, 9:40 pm Thread Starter
Senior Member
 
tonygret's Avatar
 
Join Date: May 2008
Location: Thousand Oaks, California, USA
Posts: 407
Re: Giving Back - Torque Spec Spreadsheet

After some input I have updated the file. The new attached file now includes Lb-In auto conversion as well as calculators for NM to Lb-In and Lb-Ft to Lb-In. I have also corrected the nomenclature. Apparently it is Pounds per foot (Lb-Ft) and not Foot per Pound (Ft-Lb).

As far as the suggestion for turning off protection, I have decided to leave it on by default. I am an IT guy and have found most users will mess these things up if given the chance. I have included instructions right on the spread sheet on how to remove the protection. Plus when you click on any protected cell, it tells you exactly how to unprotect it. There is no password and just a couple of clicks. If someone canít figure out how to remove the protection, than they probably canít figure out how to customize it anyway, so itís kind of moot.

If anyone can tell me how to replace the file in my original post I would appreciate it. The ďeditĒ option is no longer there.
.
Attached Files
File Type: xls Torque_Specs.xls (57.0 KB, 90 views)
tonygret is offline  
post #11 of 18 Old Apr 13th, 2009, 11:26 pm
Junior Member
 
captron4601's Avatar
 
Join Date: Sep 2006
Location: Liberty Hill, Texas, USA
Posts: 26
Re: Giving Back - Torque Spec Spreadsheet

Thanks, Tony. This will be very handy and I need all the help I can get.


Ron
captron4601 is offline  
post #12 of 18 Old Apr 14th, 2009, 12:09 am
Senior Member
 
jwd98056's Avatar
 
Join Date: Jul 2005
Location: Renton, WA, USA
Posts: 710
Re: Giving Back - Torque Spec Spreadsheet

I can't remember if I created this or found it on the forum somewhere. I have had it for quite a few years. It has a little more comprehensive torque info and is organized as it is shown in the service manual. Sharing is a good thing .
Attached Files
File Type: xls K1200LT Torque Table.xls (66.5 KB, 81 views)


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
#32756 -
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
#122647
'12
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
FLTRU Ember Red Sunglo (
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
)
'05
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
R1200GS Desert Yellow (
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
)
'00
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
K1200LTC Canyon Red (
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
) - Retired 10/2012
----------------------------------------------
'02
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
FLSTC Custom (
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
)
For bike shows, parades, Taco Thursdays and local rides on sunny days only.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.



To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
jwd98056 is offline  
post #13 of 18 Old Apr 14th, 2009, 9:43 am Thread Starter
Senior Member
 
tonygret's Avatar
 
Join Date: May 2008
Location: Thousand Oaks, California, USA
Posts: 407
Re: Giving Back - Torque Spec Spreadsheet

Quote:
Originally Posted by jwd98056
I can't remember if I created this or found it on the forum somewhere. I have had it for quite a few years. It has a little more comprehensive torque info and is organized as it is shown in the service manual. Sharing is a good thing .
I like this one too. I actually started out this way but decided to have only the specs I needed for the service and then let anyone put whatever else they frequently used on their own. Between the two of them there should be all anyone needs to torque anything on an LT. Thanks for this!

The attached file is the final update 4/14/09. About the only difference is I show the manual calculation methods.
Attached Files
File Type: xls Torque_Specs.xls (57.5 KB, 52 views)

Last edited by tonygret; Apr 14th, 2009 at 9:53 am.
tonygret is offline  
post #14 of 18 Old Apr 14th, 2009, 12:37 pm
Senior Member
 
RiderRay's Avatar
 
Join Date: Feb 2006
Location: Brewster, NY, USA
Posts: 747
Re: Giving Back - Torque Spec Spreadsheet

Hey Tony, thanks a lot!!!

Ray Rau
Brewster, NY
'99 LT - Champagne
RiderRay is offline  
post #15 of 18 Old Apr 14th, 2009, 1:51 pm
Lifetime Supporter
 
powwow's Avatar
 
Join Date: Jan 2007
Location: Bend, OR, United States
Posts: 1,423
Re: Giving Back - Torque Spec Spreadsheet

Finally, I don't have to work off of the scraps of paper I've collected with the various specs. Thanks, Tony!

Life happens...you control your reaction.

2018 Honda CRF250L Rally (fun in the woods)
2015 R1200 RT (holy cowÖwhat a bike)
2007 K1200 LT (sold)
2005 DR 650 (sold)
2002 Harley Ultra (sold)
1999 Harley Road King (sold)
1996 K1100 LT (sold)
1990 Honda Shadow (sold)
1978-1993 Raising Kids; Paying Mortgages
1975 Honda CB550 (sold but wish I still had)
Homemade Motor Bike (mounted a 3.5 HP Briggs & Stratton on my bicycle at age 12)
powwow is online now  
post #16 of 18 Old Apr 14th, 2009, 1:58 pm
Senior Member
 
Toolman's Avatar
 
Join Date: Sep 2005
Location: Katy, TX - USA
Posts: 507
Re: Giving Back - Torque Spec Spreadsheet

Excellent...thanks

I wish I could think of clever things to say in my signature.
Toolman is offline  
post #17 of 18 Old Apr 30th, 2018, 11:09 am
Junior Member
 
Join Date: Apr 2018
Posts: 1
Help - Would be great to have this excel spreadsheet but attachments all say broken image so not available
post #18 of 18 Old Apr 30th, 2018, 11:23 am
Wrencher Extraordinaire
 
jzeiler's Avatar
 
Join Date: May 2004
Location: Hazel Green, AL, USA
Posts: 13,212
Re: Giving Back - Torque Spec Spreadsheet

Quote:
Originally Posted by [email protected] View Post
Help - Would be great to have this excel spreadsheet but attachments all say broken image so not available
This one is better. It is an excel spread sheet.
Attached Files
File Type: xls K1200LT Torque schedule.xls (69.5 KB, 45 views)

John
2009 K1300GT Red Rocket
2009 R1200GS (Gone)
2005 K1200LT Ocean Blue Blue Wizard 110 K and counting...
2006 Bushtec Turbo+2 Spell
2004 330 Ci Convertable
K4AN

Have ridden a Motorcycle in all 48
But lack DE, MA, RI and CT with the 2005 LT

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
jzeiler is online now  
Reply

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the BMW Luxury Touring Community forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:
OR

Log-in











Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page
Display Modes
Linear Mode Linear Mode



Similar Threads
Thread Thread Starter Forum Replies Last Post
Back Protectors meese Rider's Gear & Luggage 21 Oct 10th, 2017 2:48 am
Austin To Albuquerque And Back katnapinn South Central 3 Oct 23rd, 2006 9:33 am
The story of buying my LT (Really REALLY long...) bmwjason Ride Tales 0 Jan 6th, 2006 11:09 pm
Triple BBG-Ride Report murray Ride Tales 8 Nov 20th, 2005 6:34 pm

Posting Rules  
You may post new threads
You may 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 On
Pingbacks are On
Refbacks are On

 
For the best viewing experience please update your browser to Google Chrome