Results 1 to 6 of 6

Thread: Transmissions and differentials ratios calculator

  1. #1
    Dzień Dobry M104's Avatar
    Join Date
    May 2014
    Location
    Poland
    Posts
    28

    Transmissions and differentials ratios calculator

    Hello

    Some time ago, i created spreadsheet in MS Excel, which can help to see, how changing diff or trans ratio, or tires/wheels size affect to vmax and rmp's in particular trans gears.

    How it work:

    -In first sheet called "factory", in yellow fields you write your tires data. next, transmission ratios and factory diff ratio.
    -In second sheet called "after", write tires data, if you want to calculate only changes after diff/trans ratio change, rewrite unchanged, like in first sheet. In next field write trans and diff ratio after change. Easier - if you want calculate only diff change, rewrite unchanged all data except diff ratio. All fields all filled by sample data - it calculate differences beetween w124 e320 with 5-speed 722.5 trans and 4-speed 722.3 trans. 722.5 has extra 5-gear and changed diff ratio.
    -next, in "factory speeds" you can see, what speed you can obtain in specified gear and engine rpms. All is generated from data given in "factory" sheet.
    -in "after speeds" you can see data calculated with changed diif/trans ratios obtained from "after" sheet.
    -next sheets is graphs, also with imposed data before/after.

    I tested this spreadsheet many times and all datas are coincide with reality. One important thing - generated speeds are real car speeds - if we comapre it with speedometer, they may arise very small differences. Also, with automatic transmissions some little differences with rmp's are normal thing - this is due to the construction of torque converter without lock-up mechanism.

    Currently, i working on adding possibility to calculate speedometer K index. Function work propertly with mechanical speedos scaled by kmh and mph, but i have problem with electrical speedos used in .034 and .036.

    If anyone finds any errors, or have questions - please write

    File in attachment. I must zip it, because forum don't allow .xls files.

    kalkulatorprzelozen_en.zip

  2. The Following 3 Users Say Thank You to M104 For This Useful Post:

    500AMM (02-11-2016), BigWillieStyle (05-19-2016), gsxr (01-29-2016)

  3. #2
    Senior Member
    Join Date
    Dec 2014
    Posts
    255

    Re: Transmissions and differentials ratios calculator

    I can't open it.
    1993 400E on EVO2's

  4. #3
    .036 Hoonigan™
    E500E Boffin
    gsxr's Avatar
    Join Date
    Dec 2008
    Location
    Boise, ID, USA
    Posts
    18,850

    Re: Transmissions and differentials ratios calculator

    Quote Originally Posted by Raffaelli View Post
    I can't open it.
    After downloading the Zip file, you need to extract the .xls file inside... then, you need Microsoft Excel installed on your computer to open the file.

    Dave M.
    1997 E420 (Bugeyes)
    1994 E420 (Blondie)
    1994 E500 (Q-ship)
    1992 500E (Mach 5)
    1987 300D (Sportline Stage 2)
    Click here for my website
    Click here for my YouTube channel

  5. #4
    Dzień Dobry M104's Avatar
    Join Date
    May 2014
    Location
    Poland
    Posts
    28

    Re: Transmissions and differentials ratios calculator

    Gsxr, do you tested it? Any feedback/opinion?

  6. #5
    .036 Hoonigan™
    E500E Boffin
    gsxr's Avatar
    Join Date
    Dec 2008
    Location
    Boise, ID, USA
    Posts
    18,850

    Re: Transmissions and differentials ratios calculator

    No, I haven't played with it yet - may have time later to check it out! Sounds cool though.


  7. #6
    Site Honcho
    Klugscheisser
    Ich bekenne mich
    nicht schuldig.
    gerryvz's Avatar
    Join Date
    Nov 2008
    Location
    Annapolis, Maryland, USA
    Posts
    15,515

    Re: Transmissions and differentials ratios calculator

    The file is downloadable directly as an XLS file (not zipped) at this URL: https://www.500eboard.com/kalkulatorprzelozen_EN.xls

    Enjoy !

  8. The Following User Says Thank You to gerryvz For This Useful Post:

    gsxr (02-07-2016)

Similar Threads

  1. 500e replacement transmissions
    By Stevester 500E in forum Transmission and Driveline
    Replies: 4
    Last Post: 07-06-2016, 11:17 AM
  2. group buy - Wavetrac differentials for w124
    By Jackasic in forum High-Performance Modifications
    Replies: 200
    Last Post: 12-20-2015, 08:53 PM
  3. Are different stall torque converters available for our transmissions?
    By samiam44 in forum High-Performance Modifications
    Replies: 20
    Last Post: 02-28-2015, 01:25 AM
  4. 126 LSD Diff Ratios
    By Ron500E in forum C126 Coupes
    Replies: 5
    Last Post: 01-08-2015, 12:29 AM
  5. Difference between 722.365 and 722.370 transmissions?
    By Aston Martin in forum Transmission and Driveline
    Replies: 2
    Last Post: 03-04-2013, 03:47 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •