RomRaider Logo


Open Source ECU Tools
 FAQ •  Register •  Login 





It is currently Fri Jan 19, 2018 9:01 am

All times are UTC - 5 hours [ DST ]

Post new topic Reply to topic  [ 428 posts ]  Go to page Previous  1 ... 25, 26, 27, 28, 29
Author Message
 Post subject: Re: SPREADSHEET: import and graph log files
PostPosted: Sat Oct 17, 2015 6:17 pm 

Joined: Fri Jul 27, 2007 2:27 pm
Posts: 8
I am having trouble opening the ver5p5a_public file on my windows7 with excel 2010

Its giving us the error "This workbook has lost its VBA project, activeX controls and any other programmability related features."

We enabled all macros in excel settings, but still cannot get it to work.

QghjfWE.jpg [ 291.3 KiB | Viewed 1131 times ]
 Post subject: Re: SPREADSHEET: import and graph log files
PostPosted: Sun Oct 18, 2015 1:44 pm 

Joined: Fri Jul 27, 2007 2:27 pm
Posts: 8
Here is my fix for the above post. Apparently you get the above message when VBA is not installed.

Anybody that gets that message try the link i provided, it worked for me.

 Post subject: Re: SPREADSHEET: import and graph log files
PostPosted: Fri Jan 15, 2016 9:19 am 

Joined: Wed Nov 12, 2014 7:03 am
Posts: 52
Hi guys Im having the following error, its happening with excel 2016 and 2010 on the same machine. This happens as soon as I open the spreadsheat.

Debug.png [ 117.33 KiB | Viewed 1056 times ]
Error 13.png
Error 13.png [ 5.3 KiB | Viewed 1056 times ]
 Post subject: Re: SPREADSHEET: import and graph log files
PostPosted: Mon Jan 18, 2016 12:14 am 
RomRaider Donator

Joined: Wed Aug 02, 2006 9:40 pm
Posts: 1064
Location: Calgary
Change the "Macro Security" setting to "disable with notification" and then open the file. It should ask to enable the content and then run in "Compatibility Mode".

I have a laptop with Windows 10 and trying out Office 2016. I can open the file and run the macros. It is rather slow in "Compatibility Mode" but not much I can do about that. It appears that since Excel 2007, MS has been moving away from using VBA macros and a lot of the functionality is gone, hence the need for them to run in "Compatibility Mode"

Excel 2007 in Compatibility Mode still runs the spreadsheet quickly enough.

 Post subject: Re: SPREADSHEET: import and graph log files
PostPosted: Mon Jan 18, 2016 1:47 am 

Joined: Wed Nov 12, 2014 7:03 am
Posts: 52
Thanks for the response bud but still no luck, Iv tried compatibility mode now and tried "disable macros with notifications" and also "enable all macros". Iv tried saving the document afterwords and re-opening it. Even rebooting my machine, still get the same error.

 Post subject: Re: SPREADSHEET: import and graph log files
PostPosted: Fri Apr 22, 2016 8:39 pm 
User avatar

Joined: Sat Jan 12, 2013 3:58 pm
Posts: 126
How would you guys rate the accuracy of the "Auto" mode that works for 5EAT and 4EAT cars using vehicle speed?

 Post subject: Re: SPREADSHEET: import and graph log files
PostPosted: Mon May 02, 2016 5:16 am 

Joined: Sun Feb 15, 2015 10:10 pm
Posts: 16
It may be a retarded question but I downloaded the latest version of Romraider and the definitions etc... there seems to be differences in the headings used for the spreadheet, ie. knock sum and some other minor changes as well as added buttons that aren't relevant to me.
Am I just looking in the wrong place?

 Post subject: Re: SPREADSHEET: import and graph log files
PostPosted: Sun Dec 03, 2017 1:49 pm 

Joined: Fri Feb 12, 2016 6:55 pm
Posts: 2
8) 8) 8) 8) thank you vvm !
Airboy wrote:
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]
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)


[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



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

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

- 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 :oops:
Get the replacement "Log file interpolation v2p2a" 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

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

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 428 posts ]  Go to page Previous  1 ... 25, 26, 27, 28, 29

All times are UTC - 5 hours [ DST ]

Who is online

Users browsing this forum: No registered users and 1 guest

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