Excel Transmission Calculator

An Article by Bob Hokanson
August, 2001

Preface: Bob Hokanson has prepared a Microsoft Excel Speadsheet for comparing your performance using your selection of gear boxes, transmission gears, rear axle drive gears, and tire diameters. This spread sheet, providing you have the Excel spread sheet program, will allow you to select your potential choices, and actually increase engine speed, and shift gears. It will show you the road speed you will achieve, horsepower permitting.

It is operated by typing in the rear axle gear desired to be evalutated, and the tire diameter to be used. The RPM can be changed, with the arrow keys, to your desired value, and the road speed read out with 4 speed Tiger Mk I Close Ratio, and Mk II Wide Ratio, and four of the five T-5 five speed transmissions. Further information on these transmissions is available in the Dan Walters Performance Tips article.

The "Shft" control can change gears in either direction, and will show you the speed at the selected rpm. Realistically, one should reduce the rpm, from the preveious gears shift point, to match the road speed previously achieved, then the drop in rpm will be indicated, as well as the reaction on increasing speed.

The 4 speed and 5 speed boxes, and rear end choices are independent, and can be evaluated seperately. The tire size effects both.

To down-load this spread sheet to your computer, just click on the link "Transmission Calculator.xls" shown below. ( NOTE: On PC computers use mouse "right-click")


Click on Image ,
( NOTE: On PC computers use mouse "right-click")
or here to Download Transmission Calculator.xls

Click HERE To Download a free copy of Microsoft's Excel Reader

End Article

  + The Roots of Rootes
  + History of the Tiger
  + Tiger Model Overview
  + Tiger Production
  + People & Pioneers
  + Workshop Manual
  + Factory Race Equipment
  + Literature: Books
  + Articles & Videos
  + Advertising

  + See Rootes Resources

  + History of the Tiger
  + Sunbeam Tiger 2005
  + Early Race History
  + Ken Miles, an appreciation
  + The "Beastie" explained
  + The Playboy Pink Tiger
  + Casting a Light on Lucas
  + LeMans at Goodwood 2002
  + Monterey Historics 2003
  + My Life With Cars

  + See Articles & Humor

  + High Perf. Exhaust
  + Tiger Dash Restoration
  + 350 Lunati Tiger
  + Installing a T5
  + Sound Advice
  + Installing New Carpet
  + The Ackerman Angle
  + "Cool It Buddy"
  + 3 Point Belts
  + Tiger Rotisserie Plans

  + Tiger E-Mail List Archives

  + See Technical Tips

  + Tiger Club Information
  + Events Calendar
  + Service Directory
  + Owner's Gallery
  + Buyer's Guides
  + Contributing Editors
  + Team Tiger Updates
  + Photo Gallery

  + See Online Resources

Anyone who would like to contribute to this effort should contact us at Editor E-Mail. Thank you.

Volunteers wishing to join our team are welcome. Take a look at our Contributing Editors
This site has been designed to pool the collective resources of the many great regional and national Sunbeam Tiger clubs. Membership to the these clubs is strongly recommended. Use our Clubs and Organizations Directory to find the organization nearest you and get involved.