Results 1 to 8 of 8

Thread: 2017+ 10R80 transmission OSS to RPM Excel sheet converter

  1. #1

    2017+ 10R80 transmission OSS to RPM Excel sheet converter

    First of all, I would like to thank TOYOGURU for his submission in this thread https://www.hptuners.com/forum/showt...ift-map-tuning

    I do not want to take the credit for this as he started it and his sheet has helped me previously in tuning my 6R80 truck before.

    Now, the sheet attached is for the newer 10 speed transmission aka 10R80. I have adjusted it to have what it needs to convert the OSS to Actual RPM with various tabs within.
    The base concept is to have it suite my 2017 Raptor. I do believe the rest of the 10R80 (Ford Based) can accommodate this too.

    There are 6 tabs to choose from :
    • Up Shift
    • Down Shift
    • Traction Control Up Shift in lb.ft
    • Traction Control Up Shift in Nm
    • TCC Slip
    • TCC UnLock


    How to use it:
    1. Copy the OSS values from the chosen tab from your tune
    2. Paste in the OSS area within the sheet
    3. Adjust the OSS values to your liking (Increasing or Decreasing)
    4. Initial values and later adjustments will show the actual RPM within the table at the right
    5. When with adjustments, Copy the values from the OSS table within the excel sheet
    6. Paste the values in the designated table within the tune file



    10R80 rpm and TCC Converter.xlsx

    Please, feel free to let me know of any adjustments needed. I have tested this and have had the results needed.

  2. #2
    Tuner
    Join Date
    Jun 2006
    Location
    Rham, NC
    Posts
    154
    The spreadsheet looks really good..haven't had a chance to do a compare vs what the new ecoboost tables are yet but believe Ill be using this in the near future for the mustang.

    You get all of the credit, my spreadsheet merely gave you an idea, you did all the work on this one and expanded on it, looks really nice!
    Current - 2018 Mustang Ecoboost (mainly to learn tuning aspects for the ecoboost platform)...all stock for now

    To many previous vehicles to list

  3. #3
    Quote Originally Posted by toyoguru View Post
    The spreadsheet looks really good..haven't had a chance to do a compare vs what the new ecoboost tables are yet but believe Ill be using this in the near future for the mustang.

    You get all of the credit, my spreadsheet merely gave you an idea, you did all the work on this one and expanded on it, looks really nice!
    Thank You Sir

  4. #4
    Advanced Tuner veeefour's Avatar
    Join Date
    Oct 2016
    Location
    Poland
    Posts
    575
    Great work but there are some bugs in your sheet, L27 for example changes both AE27 but also Z27. I used your sheet to tune a 2018 and noticed this right away.

  5. #5
    Quote Originally Posted by veeefour View Post
    Great work but there are some bugs in your sheet, L27 for example changes both AE27 but also Z27. I used your sheet to tune a 2018 and noticed this right away.
    Corrected

    10R80 rpm and TCC Converter.xlsx

    Please let me know of anything else.

  6. #6
    Tuner in Training brandong007's Avatar
    Join Date
    Nov 2012
    Location
    North Mississippi
    Posts
    16

    Lightbulb 10R80 transmission RPM to OSS reverse calculation Excel sheet converter

    Very nice...I updated the spreadsheet a bit and added inverse calculations of OSS->RPM. The new tabs allow you to input what RPM you want shift to be at and then the OSS is calculated from that rather than playing with the OSS numbers to get the expected outcome for RPM. Whatcha think?


    10R80 rpm and TCC Converter (reverse rpm calc).xlsx
    2007 NNBS Silverado LTZ Crew Cab Z71 VortecMAX (L76) / Stock Everything / Airaid M.I.T using stock box / 93 octane tuned by me 22*-25* timing / 0-60 mph 6.8 sec - Coming Soon: Longtubes, exaust, vette servo

    2004 GMC Canyon Crew Cab Z71 4WD / swapped 5.3 / Beefed up 4L60e / 2800 stall / dual 2.5" exhaust / 24" Magnaflow / 93 Octane tuned by me /w Wideband 25*-28* timing - SOLD!

  7. #7
    Quote Originally Posted by brandong007 View Post
    Very nice...I updated the spreadsheet a bit and added inverse calculations of OSS->RPM. The new tabs allow you to input what RPM you want shift to be at and then the OSS is calculated from that rather than playing with the OSS numbers to get the expected outcome for RPM. Whatcha think?


    10R80 rpm and TCC Converter (reverse rpm calc).xlsx
    I think its much better and easier your way. It should help others too.
    Thanks for the update

  8. #8
    any one have sheet like this for 6R80 (same spread sheet) not only shift point rpm