RomRaider

Open Source ECU Tools
 FAQ •  Register •  Login 

RomRaider

Documentation

Community

Developers

It is currently Sun Dec 21, 2014 11:46 am

All times are UTC - 5 hours [ DST ]





Post new topic Reply to topic  [ 414 posts ]  Go to page 1, 2, 3, 4, 5 ... 28  Next
Author Message
 Post subject: SPREADSHEET: import and graph log files
PostPosted: Fri Dec 01, 2006 9:07 pm 
Offline
RomRaider Donator

Joined: Wed Aug 02, 2006 9:40 pm
Posts: 1036
Location: Calgary
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.
Image

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.
Image

VE (Volumetric Efficiency) tab added.
Image

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.
Image


[Update Oct 17, 2011]
ver4p0z4 public

extend graphing range to 600 data points (you can change it by clicking on the trace)

[Update Oct 17, 2011]
ver4p0z2 public

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]
ver4p0z1 public

-minor clean up and add workarounds for (hopefully) better compatibility with Excel2007

[Update Apr 6, 09]
ver4p0w8 public

-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)

Image
Image

[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 Excel
ver4p0w4 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 :D
"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
Image

Image

Image

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
Image

Image Image

[Update Feb 06, 08] Note: the spreadsheet is only compatible with MS Excel
"ver3p7c Jan08"
- 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 Image 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.
Image

- 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
Image


[Update Feb 3, 07]
note: ver 2p2 has broken "Color Map" buttons on a couple of pages :oops:
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 page
new
-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.
Image


Attachments:
File comment: Latest file
ver5p5a_public.zip [921.23 KiB]
Downloaded 2956 times


Last edited by Airboy on Tue Mar 26, 2013 7:10 pm, edited 31 times in total.
Top
 Profile  
 
 Post subject:
PostPosted: Sat Dec 02, 2006 2:32 am 
Offline
Newbie
User avatar

Joined: Wed Nov 15, 2006 5:15 pm
Posts: 67
Location: Gothenburg, Sweden
Thank you :)
Very useful tool.
I will try this right away!


Top
 Profile  
 
 Post subject:
PostPosted: Sat Dec 02, 2006 7:33 am 
Offline
Experienced

Joined: Tue Apr 04, 2006 2:24 am
Posts: 117
Opps! you did it again :D


Top
 Profile  
 
 Post subject:
PostPosted: Sat Dec 02, 2006 9:11 am 
Offline
Newbie

Joined: Fri Feb 24, 2006 11:27 am
Posts: 70
Location: Australia
Another big thanks!

It just gets better and better...


Top
 Profile  
 
 Post subject:
PostPosted: Sun Dec 03, 2006 11:09 am 
Offline
Experienced
User avatar

Joined: Thu Jun 29, 2006 5:41 pm
Posts: 273
Thank you :D

_________________
Stefano
05 WRX (AJ880)
Caracas, Venezuela


Top
 Profile  
 
 Post subject:
PostPosted: Sun Dec 03, 2006 12:41 pm 
Offline
RomRaider Donator

Joined: Wed Aug 02, 2006 9:40 pm
Posts: 1036
Location: Calgary
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.


Top
 Profile  
 
 Post subject:
PostPosted: Sat Dec 09, 2006 6:07 pm 
Offline
RomRaider Donator

Joined: Wed Aug 02, 2006 9:40 pm
Posts: 1036
Location: Calgary
File has been updated to include Timing and AFR interpolation functionality from earlier spreadsheets.


Top
 Profile  
 
 Post subject:
PostPosted: Sat Dec 09, 2006 7:51 pm 
Offline
Experienced
User avatar

Joined: Mon Jun 05, 2006 2:01 pm
Posts: 280
Location: minnesota
Methinks we need to deem you the title of Excel Master.

:p


Top
 Profile  
 
 Post subject:
PostPosted: Wed Dec 13, 2006 11:31 pm 
Offline
Experienced
User avatar

Joined: Mon Sep 04, 2006 10:43 am
Posts: 260
Location: Georgia
im sure it works but my knowledge of excel is limited so i dont even know where or how to start


Top
 Profile  
 
 Post subject:
PostPosted: Wed Dec 13, 2006 11:39 pm 
Offline
RomRaider Donator

Joined: Wed Aug 02, 2006 9:40 pm
Posts: 1036
Location: Calgary
goixiz wrote:
im sure it works but my knowledge of excel is limited so i dont even know where or how to start

The first page (should be the default page when you open up the file) of the spreadsheet has some information on what the buttons do.


Top
 Profile  
 
 Post subject:
PostPosted: Wed Dec 13, 2006 11:55 pm 
Offline
Experienced

Joined: Fri Feb 10, 2006 4:41 pm
Posts: 483
Location: toggle switch envy, PA
I can't wait to get my car back and use this.

all my logs aren't very recent.


Top
 Profile  
 
 Post subject:
PostPosted: Thu Dec 14, 2006 2:47 pm 
Offline
RomRaider Donator

Joined: Wed Aug 02, 2006 9:40 pm
Posts: 1036
Location: Calgary
bump for updated file (ver 1p1)


Top
 Profile  
 
 Post subject:
PostPosted: Fri Dec 15, 2006 12:42 pm 
Offline
Experienced
User avatar

Joined: Thu Oct 19, 2006 11:34 am
Posts: 838
Location: Putnam, CT
buttons dont work for me...something about not being signed by the author... booo

_________________
93 Mustang LX 32 valve swap
95 Mustang GTS 347 kenne bell
04 Ram twin turbo 6 speed
94 Grand Cherokee locked and lifted
99 Civic HX sweet commuter car


Top
 Profile  
 
 Post subject:
PostPosted: Fri Dec 15, 2006 1:17 pm 
Offline
RomRaider Donator

Joined: Wed Aug 02, 2006 9:40 pm
Posts: 1036
Location: Calgary
Turbo_Mike wrote:
buttons dont work for me...something about not being signed by the author... booo


Looks like you have macros security setting at "high" where it requires "signed" macros (I don't even know what that means). Go to Tools--Options--Security--Macro Security and change it to "Medium". Now Excel will ask for permission to open files with macros, signed or not.

Give that a try.


Top
 Profile  
 
 Post subject:
PostPosted: Fri Dec 15, 2006 2:27 pm 
Offline
Experienced
User avatar

Joined: Thu Oct 19, 2006 11:34 am
Posts: 838
Location: Putnam, CT
sweet... works now

wow do WRX's hate running at 12.0 lol

03WRX
Mods:
UP/DOWN/TBE... thats it
Tune notes:
16 psi
Stock timing base and KC
Target 12.0:1 A/F richest

And how the crap am I getting over 5.0 load in 3rd gear!?
4082 3.57
4204 3.79
4328 4.31
4475 4.8
4699 5.05
4851 4.63
4954 4.5
5047 4.59
5270 4.63
5396 4.66
5522 4.58
5703 4.49
5809 4.52
5891 4.4
6014 4.3
6073 4.33
6239 4.22
6260 4.13
6383 4.12
6533 4.03
6643 3.99
6684 3.9


Attachments:
knock.JPG
knock.JPG [ 29.33 KiB | Viewed 62604 times ]

_________________
93 Mustang LX 32 valve swap
95 Mustang GTS 347 kenne bell
04 Ram twin turbo 6 speed
94 Grand Cherokee locked and lifted
99 Civic HX sweet commuter car
Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 414 posts ]  Go to page 1, 2, 3, 4, 5 ... 28  Next

All times are UTC - 5 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
Style based on FI Subsilver by phpBBservice.nl