Page 1 of 3 123 LastLast
Results 1 to 20 of 54

Thread: Tuning Spreadsheets

  1. #1
    HP Tuners Owner Keith@HPTuners's Avatar
    Join Date
    Sep 2002
    Location
    Chicago, IL
    Posts
    6,908

    Tuning Spreadsheets

    There have been a lot of various spread sheets posted here on the forum. I'd like to gather a collection of them in one post, this one.

    If you have developed a spreadsheet to help with your tuning and wish to share it with others, please post the link here.

    Please describe how your spread sheet works and what its capabilities are. If you upgrade your spread sheet please modify this post to reflect your new changes for users to read about.

    This post is for spreadsheet creators only with the links to their work. Please do not ask questions about the spreadsheets in this post.

    Thanks for your contributions!
    We got this guy Not Sure, ...

  2. #2
    Advanced Tuner arthansen's Avatar
    Join Date
    Apr 2004
    Location
    Tampa, FL
    Posts
    428

    Re: Tuning Spreadsheets

    I developed an Excel spreadsheet that can be used to estimate HP. First you must log a "Run". This can be at a track or an abandoned airfield (do not try this on the road, that would be illegal ). I do my runs in third gear and go from around 3500 rpms to 6000 rmps, WOT. After the run, export the data to a .csv file. Then edit the .csv file to show only the data you want (delete unwanted rows, only leave 100 TP rows and a few before and after or an entire 1/4 mile run). Now copy that data and past it into this spreadsheet in the “Data” tab, making sure you get the data in the upper left hand cell.

    http://home.cfl.rr.com/akaeh/HPTracking.xls

    If you want the graphs, you will have to name some groups of cells. The instructions for that (as well as everything else) are in the first tab of the spreadsheet. Here is a copy of one that has one of my runs (normally aspirated). It has everything set up. If you have any questions or comments, PM me. Good luck.

    http://home.cfl.rr.com/akaeh/HP080504.xls
    2013 Jeep Wrangler JK
    3.6 V6
    More MODs than Stock

    2018 Ram rebel
    5.7 Hemi V8
    Stock

  3. #3
    Moderator
    Join Date
    Nov 2002
    Location
    Central Florida
    Posts
    2,503

    Re: Tuning Spreadsheets

    Caveat Snarfor - don't hurt yourself now....


    All transmission settings for v1.4.0 copied into Excel
    table with formatting all nice-nice; pretty tweaked up
    for nice A4 shift action, 3.23s, 285/40R17 tires:

    http://home.cfl.rr.com/jimmyblue/PCM_Trans_20040823.xls


    Pretty good 85mm Delphi MAF table:

    http://home.cfl.rr.com/jimmyblue/Del...F_20040715.xls

    A min(Camaro, GTO) line pressure force motor table
    (meaning max pressure between the two):

    http://home.cfl.rr.com/jimmyblue/ForceMotorCurrent.xls

    Lean Cruise settings, never mind that it's crippled....

    http://home.cfl.rr.com/jimmyblue/Lea...ctorvalues.xls

    A torque management 'sheet of some sort

    http://home.cfl.rr.com/jimmyblue/Tor...l_20030401.xls

    An attempt to make shift action more visualizable:

    http://home.cfl.rr.com/jimmyblue/Shi...t_20040413.xls

    Another visualization sandbox:

    http://home.cfl.rr.com/jimmyblue/TCC_Kickdown_4th.xls

    A series of TM torque reduction tables that produce a
    "torque plateau" profile of N lb-ft shaft input torque
    on the transmission (more of a straight torque limit
    function that leaves you alone at part throttle and
    still gives some power through the shifts):

    http://home.cfl.rr.com/jimmyblue/Tor...0_20020730.xls

  4. #4

    Re: Tuning Spreadsheets

    Well, in wanting to give a little something back, I put together this database based on much of the info I have been gathering over the last month. Thanks to many for their input.

    I will be adding a lot more as I go to have one central place to get a lot of great tuning info. I was in the process of adding Scooter70's Gear Calc sheet but didn't have time to finish. It's in their but the formulas are not accurate yet. Maybe tomorrow. I'll update the link as I go.

    I would also like to incorporate other sheets posted (Jimmyblue's and others) here. I will as time allows and as long as no one objects.

    Comments and polite criticism welcome. Any bugs, just let me know. I've been using it and so far the results have been positive. Nothing here is an exact scienc for all cars. Some of it is still trial and error.


    Joe..




    -------------------------------------------------------
    From the online help file - Please Read!


    System Requirements: To fully utilize this application you must first have HPTuners VCM Software Package. You must also have Microsoft Access 2000 and Microsoft Excel installed on your PC or Laptop. Lastly, to tune for Wide Open Throttle (WOT) Power Enrichment (PE), you must have a WideBand o2 Sensor and Logging Software. This application was developed using the LM1 Wideband Sensor from Innovate Motorsports. I have also incorporated the Wideband Commander Log File. However, this application could be modified easily to access other logs.

    1. Copy the program to the folder of your choice and launch it.
    2. Select Configuration and set your file paths and other info
    3. In the configuration form, select your type of WBo2 log next to the WBo2 Folder setting. Currently there is only support for LM1 and Wideband Commander. If someone sends me another log type, I'll incorporate it.
    3. Update the Customer section with your info
    3b. Copy and paste your IFR Table and PE Tables from HPT-Editor (current dump of your PCM) into the LTFT, IFR, and WOT PE Forms). You'll se what I mean when you open it up.
    4. Import your HPT Log
    5. If available, import your WBo2 log
    6. Not much more than that right now but more to come

    Note that the screens are currently designed to work in 1024x768 mode or larger. If anyone needs it in 800x600 let me know. Hopefully 640x480 is not needed.

    Note: Use at your own risk!!! It has not been fully tested. Feedback welcome (under a different topic as per Keiths original post).


    Main Access Database

    http://www.vettetech.com/db/HPTAnalysis-v1.mde

    Excel Sheet to convert LM1 WBo2 Logs from .DIF to .CSV

    http://www.vettetech.com/db/dif_import.xls


    8/25/04 - Updated version with a few fixes including calculated Gear at RPM And Speed.

    8/25/04 - Updated the dif_import.xls to allow the user to configure it (and resave it) and change the input and output folders of the LM1log.CSV File. Just open it, modify the folders, resave it. There are instructions for using it when you open it. I'm going to make one more change as soon as I can to allow the user to select from other file names besides LM1Log.csv.

    Also, below is a file to update the Rrgistry (Windows XP but may work on other versions) to fix the max file locks and allow larger log files to be imported.

    http://www.vettetech.com/db/maxlocksfix.reg
    Joe Santacroce

    98 Black/Black A4 Coupe

    Cam, 3.42's, TPIS Headers,
    Random Tech Cats, Yank 3600 TC,
    FLT Tranny, 150hp NX Shot


    81 - Project FrankenSport

    SRIII Tube Chassis, C4 Suspension,
    QA1 Coilovers, Dana 44 w/3.90's,
    T56 6spd, Corbeaus, Tubbed,
    Blown Z06 Engine, SW Headers/Sidepipes

  5. #5
    Tuner
    Join Date
    Apr 2004
    Location
    warsaw, in
    Posts
    104

    Re: Tuning Spreadsheets

    i need to upload one to someone who can host it, it is great.
    fast as fast can be..... When i hit the nos, youll be sayin... WAIT4ME!!!!!

  6. #6

    Re: Tuning Spreadsheets

    Quote Originally Posted by wait4me
    i need to upload one to someone who can host it, it is great.

    I can host it for you. Send to Joe@vettetech.com
    Joe Santacroce

    98 Black/Black A4 Coupe

    Cam, 3.42's, TPIS Headers,
    Random Tech Cats, Yank 3600 TC,
    FLT Tranny, 150hp NX Shot


    81 - Project FrankenSport

    SRIII Tube Chassis, C4 Suspension,
    QA1 Coilovers, Dana 44 w/3.90's,
    T56 6spd, Corbeaus, Tubbed,
    Blown Z06 Engine, SW Headers/Sidepipes

  7. #7
    Tuner
    Join Date
    Apr 2004
    Location
    warsaw, in
    Posts
    104

    Re: Tuning Spreadsheets

    http://www.vettetech.com/db/ls1tuninganalysis.zip

    just copy and past a cvs on the first tab. with the colums labled, and then hit analized on the next tab. if it dont work with hp stuff, i will set it all up as soon as i get my software for hp.. jes
    fast as fast can be..... When i hit the nos, youll be sayin... WAIT4ME!!!!!

  8. #8

    Re: Tuning Spreadsheets

    Wait4me / Jes - your spreadsheet looks awesome, but it didn't take a HPT formatted .csv. It was not able to work with any data.

    Just an FYI to yourself and others.

    This post can be deleted if/when the spreadsheet is changed.
    \'04 Silverado SS. (6.0L, 10:1, 4.10\'s) Dynatech headers and cats, B&B cat-back, plugs + wires, VHP 210/218 .531/.531 112, VHP 1.89 rockers (.562\").

  9. #9
    Advanced Tuner Screamn03's Avatar
    Join Date
    Feb 2004
    Location
    Vacaville, CA
    Posts
    833

    Re: Tuning Spreadsheets

    I remember seeing this a while ago wait4me. I could never get it to work with HP Tuners though but it looks nicely put together. Would it help if I sent you an HP Tuner CVS file?
    -Michael Rudolph-
    2003 Redfire Cobra
    Eaton Powered to a:
    11.301 @ 129 1.68 60' MT DRs
    11.85 @ 124 1.90 60' street tires

  10. #10
    Tuner
    Join Date
    Sep 2004
    Location
    St. Louis, MO
    Posts
    123

    Re: Tuning Spreadsheets

    TTT do we have an update yet?
    Victor&&99 T/A WS6 &&TEA 5.3 heads, 224, .581 112, Mac Mids, ORY, SLP Loudmouth, SLP Flowpac, ASP pulley, BMR PHB, LCA\'s w/relos., SFC\'s, Vig 3600 w/ 4L65E,deep pan, B&M transpak, Hayden trans cooler

  11. #11
    Tuner
    Join Date
    Apr 2004
    Location
    warsaw, in
    Posts
    104

    Re: Tuning Spreadsheets

    hi guys i got the pro version in the mail today, i will start setting it up for hptuners tonight, i just need to redo alot of code,
    fast as fast can be..... When i hit the nos, youll be sayin... WAIT4ME!!!!!

  12. #12
    Tuner
    Join Date
    Sep 2004
    Location
    St. Louis, MO
    Posts
    123

    Re: Tuning Spreadsheets

    sweet, thanks for all of the hard work
    Victor&&99 T/A WS6 &&TEA 5.3 heads, 224, .581 112, Mac Mids, ORY, SLP Loudmouth, SLP Flowpac, ASP pulley, BMR PHB, LCA\'s w/relos., SFC\'s, Vig 3600 w/ 4L65E,deep pan, B&M transpak, Hayden trans cooler

  13. #13
    Moderator
    Join Date
    Nov 2002
    Location
    Central Florida
    Posts
    2,503

    Re: Tuning Spreadsheets

    My latest trans settings (updated for 3.42s, increasing line
    pressure for better TCC holding power, etc.) I have
    copied into Excel form and hosted at:

    http://home.cfl.rr.com/jimmyblue/PCM_Trans_20041024.xls

  14. #14
    Advanced Tuner
    Join Date
    Oct 2004
    Location
    Orlando FL
    Posts
    715

    Re: Tuning Spreadsheets

    Quote Originally Posted by wait4me
    http://www.vettetech.com/db/ls1tuninganalysis.zip

    just copy and past a cvs on the first tab. with the colums labled, and then hit analized on the next tab. if it dont work with hp stuff, i will set it all up as soon as i get my software for hp.. jes
    That version is outdated. I paid the shareware fee to 'NBM-WS6 Driver' for the registered version but haven't been able to get in touch with him for about the last year. There are some bugs in the VBS but it's a locked spreadsheet.

    The file used to be located here: http://briefcase.yahoo.com/bc/nbm_ws6/

    If someone wants the latest version, someone will need to host it. There are only a few functions which are restricted to registered users. It was released before VE was being discussed, so no support there. I woulds suggest making a backup copy of the original file and only play with copies.
    1998 NBM Camaro Z28
    LS3 motor
    Mod list

  15. #15
    Tuner
    Join Date
    Apr 2004
    Location
    warsaw, in
    Posts
    104

    Re: Tuning Spreadsheets

    i am done mostly with the update for hptuner spreadsheet cvs files. the only thing i havent finished is the time stuff, so when you insert the file on the first tab, dont put in the "time" column or you will get an error, ill fix it when i get time,
    fast as fast can be..... When i hit the nos, youll be sayin... WAIT4ME!!!!!

  16. #16
    Advanced Tuner
    Join Date
    Nov 2004
    Location
    Posts
    301

    Re: Tuning Spreadsheets

    Wait4me's file seems to be asking for pwd ???
    2001 Camaro SS A4

  17. #17
    Advanced Tuner
    Join Date
    Jul 2004
    Location
    La Porte/ Galveston/ Houston..
    Posts
    263

    Re: Tuning Spreadsheets

    Jess did you ever get this thing fixed to work with HPT? I really want to look at the MAF transfer function.

    Matt

  18. #18
    Advanced Tuner
    Join Date
    Oct 2004
    Location
    Orlando FL
    Posts
    715

    Re: Tuning Spreadsheets

    Matt - Check your hotmail account

    Jim
    1998 NBM Camaro Z28
    LS3 motor
    Mod list

  19. #19
    Advanced Tuner 405HP_Z06's Avatar
    Join Date
    Feb 2004
    Location
    Arlington, Texas
    Posts
    270

    Re: Tuning Spreadsheets

    Quote Originally Posted by JimMueller
    Matt - Check your hotmail account

    Jim
    Hey Jim,
    Do you have a HPT version of this spreadsheet? I can only get a few of the knock related outputs to work.
    Aaron

    '03 Z06 Corvette - The Normal Stuff.....
    EFI-101, EFI Advanced, EFILive-101, Variable Camshaft Tuning
    EFI University Evangelist

  20. #20
    Advanced Tuner
    Join Date
    Oct 2004
    Location
    Orlando FL
    Posts
    715

    Re: Tuning Spreadsheets

    I have a version which I modified to recognize the necessary HPT column headers. I haven't yet used it with HPT, however, so I don't know if ther are any issues (like Jess indicated earlier about the time column).
    1998 NBM Camaro Z28
    LS3 motor
    Mod list