Update March 25, 2013
"ver5p5a_public" Tested on my Windows 7 machine running Office 2003
Added page to "match up" names from data logs to those used by the spreadsheet. This is done to accommodate the different names given to the same items (Ignition Total Timing (degrees), Ignition Timing, Ignition Timing (Â°), etc). Once the names are matched up, the list-boxes should auto select the needed items to save some mouse clicks.
If you have tried to import data logs exported from the Cobb Accessport, you'll have encountered the "Import Wizard". This version should bypass this step as well.
VE (Volumetric Efficiency) tab added.
One last thing that is added is a page to keep track of MAF table changes. No fancy smoothing or anything, just a place to put stock values, current table values and modify it for a new table.[Update Oct 17, 2011]
extend graphing range to 600 data points (you can change it by clicking on the trace)[Update Oct 17, 2011]
Small change to Accel macro to deal with higher sampling rate from the "fast poll" option in the latest RomRaider logger[Update Sept 14, 09]
-minor clean up and add workarounds for (hopefully) better compatibility with Excel2007[Update Apr 6, 09]
-bug fix for WGDC interpolation for 16bit ecu (header location for compensation tables)
-Accel macro auto detects ms, sec, and absolute as time units
-Accel macro has option to use Vehicle Speed as input (should only be used for the 5EAT Legacy GT)
-Option to use Markers instead of Lines in main graph. Useful for non-sequential data (e.g. fuel trim vs MAF)[Update Mar 27, 09]ver4p0w5 public
bug fix involving 3D comp table for Boost Target[Update Mar 27, 09]Note: the spreadsheet is only compatible with MS Excelver4p0w4 public
-Corrected some vehicle data errors in Accel page
-Updated Accel macro to keep a few more data points at the end of the file
-Extended table size for Timing, Boost and WGDC to accommodate the huge tables in 08 JDM STi
-Added Average Vertical/Horizontal to AFR Target page[Update Mar 8, 09]
Final Drive entry for 08USDM STi on the Accel page is incorrect. Should be 3.9
Minor update for issues with graphing (some versions of Excel does not keep the chart type in the sheet "Plots")
"Log file interpolation ver4p0w2 public"[Update Feb 26, 09]Note: the spreadsheet is only compatible with MS Excel
It has been a few months...time for another update
"Log file interpolation ver4p0w public"
-Total Timing table can now be adjusted and new Base timing table can be calculated from "Total - Adv"
-Total timing headers now evenly spaced, with max values taken from Base and Adv (higher of the two). Min Load is taken from Base Timing
-Color scale for timing plots set to be similar to the cell colors
-Accel page has additional "metrics" added, namely 50-80mph, 60-80mph elapsed time
-Accel page can now handle data logs with Seconds as time units (eg AP2 logs)
-Throttle map interpolated results uses evenly spaced accelerator pedal angle values
-FLKC grid can be toggled on/off
-workaround for MS Excel bug involving list-boxes and MS mouse scroll wheels. As a consequence, slider in the list-box is no longer functional; have to use the up/down arrows
Contour plot can be changed to 3D view by right-clicking on chart and change 3D view options
Possible uses of the Base Timing Recalculation function:Scenario 1
-Generate Total Timing table
-Adjust Total Timing table to where you want it
-Go to Advance page and modify Advance table (smooth it out or put in constant values above certain g/rev range, or leave it alone)
-Go to Base Timing page and re-calculate Base Timing Table.Scenario 2
-Generate Total Timing table
-Go to Base Timing page and change the load header values (spacing and/or range)
-Re-calculate new Base Timing table, accounting for the load header changes[Update Oct 18, 08]Note: the spreadsheet is only compatible with MS Excel
"Log file interpolation ver4p0j public"
-workaround for Excel bug in the graphing macro: will crash if Y1 has 1 trace and Y2 has more than 1.
-auto select "Throttle Opening Angle" as Throttle data in Boost and WG interpolation page (for compatibility)[Update Oct 17, 08]Note: the spreadsheet is only compatible with MS Excel
"Log file interpolation ver4p0i public"
- Import File macro will default to look for *.csv files
- added compatibility with newer ECUs that use Requested Torque for Boost and WGDC tables
- added IAT compensation for Timing Calculations
- re-did the Graphing function to allow selection of items for different Y axes
- added Throttle map page to calculate the "Pedal to Throttle" map
- added Timing Total page to display the sum of Base and Advance tables
- added table rescaler page from mickeyd2005
- Accel page auto-calculates the 3~6k rpm elapsed time
- Accel page allows storing/comparing two Averaged runs (still need to add support for Auto Tranny)
- misc clean up [Update Feb 06, 08] Note: the spreadsheet is only compatible with MS Excel
- Added function to simplify transferring tables from RomRaider into the spreadsheet. It takes care of the offset in the first row headers. Now, all you have to do is "Copy Table" in RomRaider, go to the appropriate spreadsheet page, select a cell in an empty area, "Ctrl-V" to paste the table. Click the
button and the macro will clear the old table and replace it with the new one. You can fill the entire spreadsheet with tables from a new ROM in about a minute.
- Added ability to store traces from one log file so you can compare the results with a second log file.
- Added Road Dyno functionality to estimate WHP from RPM vs time data. Two runs can be averaged.
- cleaned up the code a bit to make things run quicker without screen flickering.[Update Apr 18, 07]
"v2p8 public Apr 18"
Added buttons to adjust cells in "Advance" and "AFR Target" pages[Update Apr 16, 07]
"v2p7 public Apr 16"
Added buttons to to adjust cells values in Base Timing map
Added alternate method to marking cells used in Timing Interpolation.
Screenshot is here: viewtopic.php?t=1592
Added some (more) comments on first page. [Update Feb 17, 07]
"v2p5 public" is the latest version
- Fixed Boost Target compensation (atmospheric) calculation error (needed to apply compensation to target table in absolute pressure form)
- Added "proper" Boost Target Compensation (atmospheric) for 32bit ECU ('06 WRX and '05 STi) based on newly ID'd parameters. You can thank Merchgod for that
For Atmospheric compensation of Boost Target, you just select the car model in the "Boost Target" page. The table is filled out automatically and ready for use by the interpolate function in the "Boost and WG interpolate" page[Update Feb 3, 07]note
: ver 2p2 has broken "Color Map" buttons on a couple of pages
Get the replacement "Log file interpolation v2p2a public.zip" instead.
-added WGDC and Boost target calculation page
-added textbox on Data page to show name of imported log file
The WGDC addition should be fairly self-explanatory but you can pm me if have questions.
One thing that the WGDC and boost interpolation page can be used for is to check boost and WGDC in part throttle operation to see if you have too little WG in part throttle, etc. You would need to manually plot the calculated results against logged data using "Time" as the x-axis.[Update Dec 14]
-added Engine Load calculation from MAF(g/s) and RPM
-"pre-select" data items in list boxes for log files generated by Engiunuity or ecuExplorer. This should make it even faster/easier to graph what you want
-general clean up of list box filling/clearing[Update]
I combined the function of the older worksheets (Timing, AFR, data plotting) into one file and moved the interpolation calculations from the cells to inside the VB Macros so now it should be a little cleaner and handle some common errors when using maps from different ECUs.
Let me know if you run into any problems using the spreadsheet.
Wrote (more like hacked and slashed) the macros because I got tired of always loading, editing, graphing the results from log files.
The macros in this spreadsheet will:
-Import the data file
-Remove non-WOT data (if you want to)
-Graph selected parameter(s) on second pagenew
-allow user to select timing and/or AFR data and plot against map values
You'll still have to format the graph to your liking though.
Hope the macros work in different versions of MS Excel as I had problems with one or two "Methods" on Office 97.
[EDIT] I noticed that the spreadsheet (well, Excel in general) has problems with the file names that ecuExplorer generates. Think it is the length and symbols used. Renaming the log file should rid the error during import operation.