2017+ 10R80 transmission OSS to RPM Excel sheet converter

Printable View

09-12-2017
mrshanab

1 Attachment(s)

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
Attachment 99404

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

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!
07-07-2018
mrshanab

Quote:

Originally Posted by toyoguru

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 :cool:
07-08-2018
veeefour

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.
07-21-2018
mrshanab

1 Attachment(s)

Quote:

Originally Posted by veeefour

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

Attachment 81898

Please let me know of anything else.
10-26-2018
brandong007

1 Attachment(s)

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?

Attachment 84429
10-31-2018
mrshanab

Quote:

Originally Posted by brandong007

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?

Attachment 84429

I think its much better and easier your way. It should help others too.
Thanks for the update
05-11-2019
small tuner

any one have sheet like this for 6R80 (same spread sheet) not only shift point rpm
10-15-2019
PG Bullitt

Interesting

Quote:

Originally Posted by mrshanab

I think its much better and easier your way. It should help others too.
Thanks for the update

I have a 2018 mustang GT with a10R80 that I had Modified with SCT tune. I have been getting DTC P061A and P061B (Torque Mis match) during full throttle (or close) acceleration. The vehicle goes into limp mode and can be reset with the programmer. At first the acceleration is ok but then there seems to be a hard shift or two and then goes into limp mode.

I?m wondering if with the performance tue there is an unexpected change in torque that results in a mismatch from the transmission. Do you have any thoughts on if a tune for the TX is necessary in addition?
05-13-2020
Eduardoc22

tried using this but im getting ### symbols and no numbers is this locked in a way or am I doing something wrong. thanks let me know
05-13-2020
mrshanab

Quote:

Originally Posted by Eduardoc22

tried using this but im getting ### symbols and no numbers is this locked in a way or am I doing something wrong. thanks let me know

Try now please

attachment has been updated
05-13-2020
Eduardoc22

Quote:

Originally Posted by mrshanab

Try now please

attachment has been updated

Still getting same result
05-14-2020
mrshanab

Quote:

Originally Posted by Eduardoc22

Still getting same result

Can you send a screen shut?
05-14-2020
Eduardoc22

not letting me
05-14-2020
mJolnir

Quote:

Originally Posted by Eduardoc22

tried using this but im getting ### symbols and no numbers is this locked in a way or am I doing something wrong. thanks let me know

That just means the number does not fit in the cell space, go into the column where that happens and double click on the edges
06-06-2020
Nitmer

I?m having this very same issue with my 10r80, not wanting to come out of gear and up-shift to the next gear. Then limp mode for a second.
Any help please?
06-07-2020
Nitmer

Quote:

Originally Posted by PG Bullitt

I have a 2018 mustang GT with a10R80 that I had Modified with SCT tune. I have been getting DTC P061A and P061B (Torque Mis match) during full throttle (or close) acceleration. The vehicle goes into limp mode and can be reset with the programmer. At first the acceleration is ok but then there seems to be a hard shift or two and then goes into limp mode.

I?m wondering if with the performance tue there is an unexpected change in torque that results in a mismatch from the transmission. Do you have any thoughts on if a tune for the TX is necessary in addition?

Have you found a answer to your question?
11-24-2022
PSYKOSTEVO

Quote:

Originally Posted by Nitmer

I?m having this very same issue with my 10r80, not wanting to come out of gear and up-shift to the next gear. Then limp mode for a second.
Any help please?

Is your shiftpoint set higher than your max RPM? You typically want to set your max rpm HIGHER than the actual rpm you want to shift at.
02-02-2023
GreenMachine04

1 Attachment(s)

Hi All, I updated the Excel file with a conversion to MPH. I am used to tuning GM vehicles so it is easier for me to see MPH with dealing with the shift mapping/TCC/etc. Hope it helps others as well.Attachment 128009
10-24-2023
elerico

do we need to have the tire circ mm target or not ?

i ran a 27.6 tire on a daily basis, but 28 or 26 at drag strip

thanks !