SPREADSHEET: import and graph log files

menbolduc001 · **Joined:** Wed Apr 25, 2012 8:01 pm **Posts:** 29

and this is my log in excel

Airboy · **Posted:** Wed Apr 25, 2012 11:12 pm

menbolduc001 wrote:

Why do i have this problem is there any option i have to change in the logger?

This is the data page in excel spreadsheet

Thanks

Chris

You have to change the regional setting in Windows to use North American notation for the decimal point instead of the comma.

menbolduc001 · **Joined:** Wed Apr 25, 2012 8:01 pm **Posts:** 29

I've alreadt did it but i'll have to make another log saved with this setup?

Thanks

Chris

dschultz · **Posted:** Thu Apr 26, 2012 9:29 am

You should be using the same regional settings for all applications. If in FR then both RR Logger and Excel should use , for . and ; as field separator automatically.
Or do a search and replace, change , to . and then ; to , for US format.

menbolduc001 · **Joined:** Wed Apr 25, 2012 8:01 pm **Posts:** 29

YEAH!!! right on thank you guys :mrgreen:

rammer · **Posted:** Sat Aug 25, 2012 3:59 pm

I seem to be getting an erroneous dyno plot that reads way too high when I do an RPM only (with knock sum and TPA) log.
Using the exact same Airboy dyno sheet input parameters (not logger parameters) from a log taken a couple minutes before, but logging many more parameters, I get a realistic dyno plot.

Using snapshot 86b338 of Romraider for logging
4p0z4 Airboy spreadsheet

Three parameter log attached that is giving the bad dyno plot that shows my torque is way too high. I'm wondering if the time base is being calculated or logged accurately?

Screenshot of the Airboy sheet, the reference plot is from a log taken minutes before calculated with smoothing at 10, I was logging 17 parameters in that log (fast polling is cool) it seems to give realistic plot.

Attachment:

Capture.JPG [ 86.32 KiB | Viewed 6905 times ]

I've been encountering strange locking up issues with the logger on the new snapshot version but I've also recently installed a PLX wideband and started logging that at the same time. The wideband data itself will sometimes lockup independent of the other parameters. Sometimes all the parameters will freeze up, after a few seconds they'll come back. No sign of that happening in these logs though.

Airboy · **Posted:** Sat Aug 25, 2012 11:45 pm

Your elapsed times 50-80mph and 3k-6krpm is way lower than they should, for 270whp. In other words, something is wrong with the data log.

Airboy · **Posted:** Tue Mar 26, 2013 2:05 am

First post updated with new version of spreadsheet.

Airboy · **Posted:** Tue Mar 26, 2013 6:54 pm

D'oh, attached the wrong file last night. Proper file uploaded.

MFB · **Posted:** Wed Mar 27, 2013 10:25 pm

Can the spreadsheet have an update on per cylinder timing compensation as its currently 2d only? Helpful too to have per gear timing :-)

wrxkid2003 · **Posted:** Sat Apr 06, 2013 10:08 am

I tried using the new vr5p5a on my friends new laptop with Windows 8 using Office XP pro that he had. It come up with a run-time error '1004' when i try to load csv log file. I found a older spreadsheet ver4p0z4 on my computer, i put it on his computer to see if it works and it works fine with the loading the log files. Would you know why this happens?
Thanks.

Airboy · **Posted:** Sat Apr 06, 2013 11:35 am

wrxkid2003 wrote:

I tried using the new vr5p5a on my friends new laptop with Windows 8 using Office XP pro that he had. It come up with a run-time error '1004' when i try to load csv log file. I found a older spreadsheet ver4p0z4 on my computer, i put it on his computer to see if it works and it works fine with the loading the log files. Would you know why this happens?
Thanks.

If you hit the "debug" button when the error comes up, where does it take you? Maybe take a screenshot and post here.

The Spig · **Joined:** Sat Jan 21, 2012 1:04 am **Posts:** 2

Hey would it be possible to get a macro to filter out all lines with less than 16.5:1? Similar to filter WOT function, i havent had much luck trying to write one myself.

idipskoalmint · **Joined:** Sun Jan 18, 2009 2:15 pm **Posts:** 4

williaty wrote:

When I try to load this spreadsheet, after several minutes of dialogs popping on and off the screen talking about converting something, I get a error box saying

Quote:

Run-time error '57121':

Can't exit design mode because Control 'CommandButton_color_cells' can not be created.

I get the choice of End or Debug. End results in the spreadsheet not functioning. Debug fills the screen with layer upon layer of windows that might as well be in Greek.

Any idea what I need to do? All I want is to graph a few different variables against RPM!

I'm getting this same error.

When I run the debugger, it tells me:
"Sheets("Boost Target").Activate 'need to activate sheet or the Select function in the Listbox macro won't work"

None of the buttons work...

Screenshot:
http://i43.tinypic.com/2v0hp21.png

Win7 x64
Excel 2013 (macros enabled in Trust Center)
.NET Frameworks all installed / up-to-date

If more information is needed, please let me know. Any insight would be greatly appreciated...

Airboy · **Posted:** Wed May 22, 2013 1:51 am

Looks like MS has changed VBA in the newer versions of Excel. I don't have access to any machines running Excel 2013 so can't really do anything on this end. Is there a "compatibility" mode that you can open the spreadsheet in?

RomRaider

Forum rules

SPREADSHEET: import and graph log files

Who is online