Car Settings Spreadsheet Available

Discussion in 'GT6 Tuning' started by Flying Kiwi, Dec 26, 2013.

  1. Flying Kiwi

    Flying Kiwi

    Messages:
    187
    Location:
    New Zealand
    Here is a spreadsheet I developed - quite happy to share...

    You need MS Excel or Open Office to run it - Apache Open Office is a free download if you do not have Excel.

    The main aim is to give it the feel and order as presented in GT6 and have it all on one printable sheet A4 size.
    The settings have some multi-choice selections taking away the pain of typing it all out.
    Copy and paste the final setup to share with GT friends online

    Intentions are to improve it (as time permits) so feedback would be appreciated

    Download file at bottom of this post

    Revision 3 Sheet example:
    [​IMG]
     

    Attached Files:

    Last edited: May 12, 2014
  2. PsychoZombie

    PsychoZombie

    Messages:
    8
    Location:
    United States
    I was getting on here to post my Shelby GT350 that is my first, just for kicks GT6 car. So finding this was perfect timing for me, thanks again btw.

    As I have already utilized it there are only two issues I found, your parameter for Nitrous Power Boost Percentange kicks you back up into Nitrous Oxide selection so you cant actually input and your bottom right "notes section" runs out side its cell when you type in it.



    And actually there was a 3rd almost forgot - not all cars have center differentials, as its more for 4WD vehicles. 0% needs to be an option under REAR instead of forced number % there besides that worked like achamp. Triple thumbs ups!
     
    Flying Kiwi likes this.
  3. Flying Kiwi

    Flying Kiwi

    Messages:
    187
    Location:
    New Zealand
    Thanks Psycho, appreciate the feedback.
    I will be posting an upgraded file soon.
    I will be trying your tune to tame my beast also...


    ...... File has now been updated and replaced on post #1
     
    Last edited: Dec 27, 2013
    PsychoZombie likes this.
  4. Wobrak

    Wobrak

    Messages:
    12
    Excellent product, nicely done.

    The worksheet is 100% compatible with Open Office v4.0.1. The only issue is you can't save as .xlsx, but it retains all original formatting as .ods or .xls file.
     
    Flying Kiwi likes this.
  5. Muxlee

    Muxlee

    Messages:
    56
    Location:
    Kyrgyzstan
    Nice thanks a lot
     
    Flying Kiwi likes this.
  6. Latin Avenger

    Latin Avenger

    Messages:
    118
    Very cool.
     
    Flying Kiwi likes this.
  7. Carfan772

    Carfan772

    Messages:
    16
    Location:
    Puerto Rico
    Nice program , try to develop it as a .exe file for the people who doesn't have Excel .
     
    Flying Kiwi likes this.
  8. Flying Kiwi

    Flying Kiwi

    Messages:
    187
    Location:
    New Zealand
    I have made a .exe file, but this site does not allow it to be uploaded....
     
  9. RampageRacing

    RampageRacing

    Messages:
    134
    Thanks for that. I do not have excel but I do have OpenOffice. I just changed the extension when I saved it and it works great.
     
  10. Mercury1

    Mercury1 Premium

    Messages:
    307
    Location:
    Australia
    Wow! Very generous and thoughtful of you my friend. I will wait until this one has been 'beta' tested :) and certainly utilise the new one when you are happy with it. Just what the doctor ordered! :cheers:
     
  11. sportz

    sportz

    Messages:
    3
    Nice job there. If you don't mind, I've made a small change by adding a list of the cars and adding categories for each cell. I then added a "vlookup" formula to the sheet so the car list can hold the settings and all you have to do is enter them there instead of creating sheets for each car. Give it a look and let me know what you think.

    I put some values in under the Chevrolet 2010 Jeff Gordon #24 DuPont CHEVROLET IMPALA entry as an example.
     

    Attached Files:

    NeuroPhage and Flying Kiwi like this.
  12. Flying Kiwi

    Flying Kiwi

    Messages:
    187
    Location:
    New Zealand
    Nicely done sportz!!:tup:
    If others can test this new version out as well , I would like to submit this as an update
     
  13. FishHunters

    FishHunters

    Messages:
    1,973
    Location:
    United States
    Thank you Sir!
     
  14. RampageRacing

    RampageRacing

    Messages:
    134
    I am using the sheet with the revision. It works great. The only change I made to it was to the spring rate cells. They rounded everything to whole numbers on the revisied sheet I downloaded and I wanted the ability to show two decimals. Everything else was perfect for recording my tunes.
     
    Flying Kiwi likes this.
  15. Flying Kiwi

    Flying Kiwi

    Messages:
    187
    Location:
    New Zealand
  16. Thorin Cain

    Thorin Cain Premium

    Messages:
    2,262
    Location:
    Scotland
    Very nice, been looking for something just like this to use when I open up my new Tuning Garage. I don't have any sort of computer skills as such and this could be just the thing to keep everything looking neat and tidy. Many thanks for sharing this Flying Kiwi.
     
    Flying Kiwi likes this.
  17. Mercury1

    Mercury1 Premium

    Messages:
    307
    Location:
    Australia
    Thanks mate! Terrific job and very generous and community spirited of you. :tup::cheers:
     
    Flying Kiwi likes this.
  18. praiano63

    praiano63 Premium

    Messages:
    8,847
    Location:
    Brazil
    This is a very nice tuning sheet. Just need a place for the inicial final gear that you need to enter first .
    Congrats.
     
    Flying Kiwi likes this.
  19. Flying Kiwi

    Flying Kiwi

    Messages:
    187
    Location:
    New Zealand
    Cheers Praiano, your feedback is much appreciated.
    I will have a look at the gear set up and revise where necessary.
     
  20. shaunm80

    shaunm80

    Messages:
    6,645
    Location:
    England
  21. Flying Kiwi

    Flying Kiwi

    Messages:
    187
    Location:
    New Zealand
    Revised Tuning Sheet is now available, download HERE or at 1st post of this thread.

    Some of the modifications are;
    - New Drop-down GT6 car list
    - Transmission section updated
    - Differential section updated

    Feel free to download, use and share
     
  22. Flying Kiwi

    Flying Kiwi

    Messages:
    187
    Location:
    New Zealand
    Sorry shaunm80, I do not know how to do this
     
  23. shaunm80

    shaunm80

    Messages:
    6,645
    Location:
    England
    No worries, thanks for letting me know.

    Edit - Actually, because its not an .exe file and its in .xls format, I can access it okay now.
     
    Flying Kiwi and DaBomm4 like this.
  24. Patto

    Patto

    Messages:
    3
    Hi Kiwi
    IS there any chance you could email me this as an unprotected file.
    I actually want to use it for sailing but its got the basics of what I'm looking for
    Cheers Patto
     
  25. bjl23

    bjl23 Premium

    Messages:
    2,812
    Location:
    Australia
    Did you try pressing the attached file at the bottom of the first post? Because I just tried it and it worked.
     
    fordlaser likes this.
  26. Patto

    Patto

    Messages:
    3
    yes I've downloaded the file but I cant change any of the cells. Thats Why I want an unprotected file so I can Change it
     
  27. bjl23

    bjl23 Premium

    Messages:
    2,812
    Location:
    Australia
    That's odd, I opened it in excel and it works just fine.

    Kiwi hasn't logged on since 2015 so I don't think he's going to get your message.
     
  28. Patto

    Patto

    Messages:
    3
    Yeah just was hoping.
    I want to change things like the cars in the drop down list but can change any of them. Can you?
     
  29. bjl23

    bjl23 Premium

    Messages:
    2,812
    Location:
    Australia
    I can change everything.
    Screenshot_20200718-083946.png