PDA

View Full Version : Tool to help tune A6 shift points



T2000
March 28th, 2013, 12:17 PM
Hey guys, I spend heaps of time on here reading and learning...
Time to give a little back ;)
This spreadsheet was inspired by another tool/post: http://forum.efilive.com/showthread.php?5876-Tool-to-help-tune-A4-shift-points
So credit to SSpdDmon for the original idea and share.

I created this in OpenOffice but have saved it in Excel format - should work just fine but let me know if there are any problems or if you want a copy in the OpenOffice document format.

I havent quite finished all of the planned features and I have not thoroughly checked the tool.
So all reports of errors, suggestions and feedback welcome.
Happy to add more to this if required.

Cheers and Happy Easter,

Chris

ScarabEpic22
March 28th, 2013, 03:08 PM
Thanks Chris, downloaded and checked it out for a sec!

Ive seen another 6spd trans tuning spreadsheet floating around the "other" site, no idea how it compares to this.

Appreciate the work though, thanks for giving back! :cool:

joecar
March 29th, 2013, 03:04 AM
Hi Chris, thanks for sharing :cheers:

T2000
March 31st, 2013, 07:24 PM
Hi guys, thanks for checking it out.
Here is an updated version that pretty much includes all of the planned features.
Now you can include & calculate tyre data and shift points by speed and rpm.

Hard to describe everything it does... feedback would be good.

Cheers, Chris

T2000
April 9th, 2013, 05:51 PM
21 Downloads and Zero replies / comments / suggestions.

I guess I wasted my time :unsure: pity :doh2:

ScarabEpic22
April 9th, 2013, 06:15 PM
I like it Chris, unfortunately I have one tuned a few A6s as most of my tunes are for A4s. I just downloaded your updated version, the effective gear calc is pretty cool! I like how all of the data is used throughout the different areas, I happened to adjust the tires size and switch to the GearCALC page...it was updated which I didnt see the first time! I like how the gear changes are graphed as well, I know this didnt just take an hour in Excel.

joecar
April 10th, 2013, 05:40 AM
I have been looking thru it (it shows 22 views)...

My comments:
- TCC 3rd Gear graph: include 2->3, 4->3.
- TCC 4th Gear graph: include 3->4, 5->4.
- TCC 5th Gear graph: include 4->5, 6->5.

Dieselman
April 12th, 2013, 10:17 PM
Thanks for your time on this Chris. Finally got around to looking at it today. Works perfect :)

T2000
April 22nd, 2013, 09:49 PM
Thanks for your time on this Chris. Finally got around to looking at it today. Works perfect :)
Good to hear mate. Glad it worked for you.


I have been looking thru it (it shows 22 views)...

My comments:
- TCC 3rd Gear graph: include 2->3, 4->3.
- TCC 4th Gear graph: include 3->4, 5->4.
- TCC 5th Gear graph: include 4->5, 6->5.

Ok... I'll update it and upload a new version

TBMSport
June 20th, 2013, 07:33 PM
Awesome chart Chris...I made a some changes to make it US standard friendly and it helped me transform my truck's shifting and drivability as if it were a whole new truck! Thanks for sharing.

T2000
June 21st, 2013, 06:53 PM
Awesome chart Chris...I made a some changes to make it US standard friendly and it helped me transform my truck's shifting and drivability as if it were a whole new truck! Thanks for sharing.


Hey mate,

Glad it helped!
It was probably an oversight on my behalf not to have an option on the first sheet to select imperial or metric units ;)
I still havent added the charts that Joecar suggested either :ermm:
I need to revisit this soon to try to tune drone out of my car - lol
Damn exhaust has a shocking "drone-zone" 1700-1850 rpm so I think I'll just use the tool to stop the converter locking until engine speed will be 1950+ ;)

If you made any other changes other than the imperial speeds then send them through and I'll include it in the next version.

Cheers and thanks for your comments :)

hotrod
November 17th, 2013, 01:47 PM
Finish your latest version yet? :D

T2000
November 18th, 2013, 09:27 PM
Finish your latest version yet? :D

Hi mate,

Kind of dropped the ball on this one at about 98% finished...

Cant remember what else needed doing at this point.
BUT this has significantly more data and charting of shiftpoints than the last version.

There is now a separate Tab for each gear

Let me know what else needs doing?

Cheers, Chris

Naf
December 2nd, 2013, 06:15 PM
T2000, i have to say thank you so much, with your xls sheet i was able to properly setup my shift points and tcc...

Very useful tool, but if i may suggest why not have it where on the chart pg i am able to edit the parameters so i dont have to keep accessin the first tab to make my edits...

Again AWESOME idea you brought to life...

T2000
December 3rd, 2013, 08:49 AM
T2000, i have to say thank you so much, with your xls sheet i was able to properly setup my shift points and tcc...

Very useful tool, but if i may suggest why not have it where on the chart pg i am able to edit the parameters so i dont have to keep accessin the first tab to make my edits...

Again AWESOME idea you brought to life...

Hi Naf,

Thanks for your comments, nice to know the tool helps.

I know what you mean about being able to edit next to the chart, I will have a look at this and see what I can come up with.
I suspect it will come down to writing macros though... so that any changes on the "Data from CAL" sheet and on any Gear sheet remain synchronised. At the moment it is simple with the Gear sheets/charts simply looking up the data that is in the "Data from CAL" sheet. The complexity of a 2-way update versus a 1-way lookup... I will give it some thought though.

Cheers, Chris

samh_08
January 2nd, 2014, 04:11 PM
Awesome tool and work! Is it just me or is it password protected? Im getting odd errors to do with protected cells, I just want to make sure Im not calculating errors.

Is there a reason for the password? I would also like to convert to English units.

Thanks for your hard work!!

joecar
January 2nd, 2014, 07:22 PM
+1

( I'm using LibreOffice and I need to increase the cell height to avoid truncated cell display, but it won't let me due to protected cells )

T2000
February 22nd, 2014, 09:06 PM
Awesome tool and work! Is it just me or is it password protected? Im getting odd errors to do with protected cells, I just want to make sure Im not calculating errors.

Is there a reason for the password? I would also like to convert to English units.

Thanks for your hard work!!




+1

( I'm using LibreOffice and I need to increase the cell height to avoid truncated cell display, but it won't let me due to protected cells )

Hi Joecar and Sam,

Sorry for the late reply,

Created in OpenOffice 4 and saved in excel format so should work with just about anything (I hope)

Protected sheets / cells are enabled to make sure the end user doesnt inadvertently "break" the calculations which are embedded in the sheets. Changing any cell other than the "copy/paste" (tune cells) will result in failed calculations... and there are hundreds of links running between the sheets to do all the necessary calcs.

Attached is an updated version,

In this version I have added a 2nd GearCalc tab, so now gearing/speed will be calculated for both KPH and MPH simultaneously. Just work from the Tab that provides the units that you use in your tune.

It shouldnt be necessary to change units anywhere else in the spreadsheet as they are irrelevant as far as the calcs are concerned (values + units are just imported from the tune).

I have also added some detail to the WOT sheet, it now has colour coding and some charts. Pretty messy and low res charting but it is designed more to highlight errors rather than provide a high res tuning solution.

Rather than trying to make individual changes or enhancements please just leave your requests or comments and I will try to fix it in the base document.

Anyways, enjoy the new version, I'm glad a few people are finding it useful.

Cheers, Chris

joecar
February 24th, 2014, 09:59 AM
I post a screenshot later of what happens... (all the cells have the top 33% of their values lopped off... I'm not sure how to increase the cell height).

joecar
February 24th, 2014, 09:59 AM
For reference:



PT shift table relationships:

basic relationships:
1->2 curve should be above 2->1 curve;
2->3 curve should be above 3->2 curve;
3->4 curve should be above 4->3 curve;
4->5 curve should be above 5->4 curve;
5->6 curve should be above 6->5 curve;

additional relationships:
3->2 curve should be above 1->2 curve;
4->3 curve should be above 2->3 curve;
5->4 curve should be above 3->4 curve;
6->5 curve should be above 4->5 curve;

this can be summarized as: the curves cannot cross anywhere;

if they cross anywhere, then you will not be able to predict what gear the TCM selects when the operating point hits the cross.

55chevdelray
April 21st, 2014, 04:57 PM
Thanks for the spreadsheet. Works great for determining the shift points. Something I had been looking for.