RomRaider Logo

RomRaider

Open Source ECU Tools
 FAQ •  Register •  Login 

RomRaider

Documentation

Community

Developers

It is currently Tue Jun 28, 2022 8:21 am

All times are UTC - 5 hours [ DST ]





Post new topic Reply to topic  [ 429 posts ]  Go to page Previous  1 ... 24, 25, 26, 27, 28, 29  Next
Author Message
 Post subject: Re: SPREADSHEET: import and graph log files
PostPosted: Wed Apr 25, 2012 8:48 pm 
Offline
RomRaider Donator

Joined: Wed Apr 25, 2012 8:01 pm
Posts: 29
and this is my log in excel


Attachments:
romraiderlog_20120421_112529.csv [10.35 KiB]
Downloaded 537 times
Top
 Profile  
 
 Post subject: Re: SPREADSHEET: import and graph log files
PostPosted: Wed Apr 25, 2012 11:12 pm 
Offline
RomRaider Donator

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


Top
 Profile  
 
 Post subject: Re: SPREADSHEET: import and graph log files
PostPosted: Thu Apr 26, 2012 5:54 am 
Offline
RomRaider Donator

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


Top
 Profile  
 
 Post subject: Re: SPREADSHEET: import and graph log files
PostPosted: Thu Apr 26, 2012 9:29 am 
Offline
RomRaider Developer

Joined: Wed May 20, 2009 9:49 pm
Posts: 6991
Location: Canada eh!
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.


Top
 Profile  
 
 Post subject: Re: SPREADSHEET: import and graph log files
PostPosted: Sun Apr 29, 2012 3:49 pm 
Offline
RomRaider Donator

Joined: Wed Apr 25, 2012 8:01 pm
Posts: 29
YEAH!!! right on thank you guys :mrgreen:


Top
 Profile  
 
 Post subject: Re: SPREADSHEET: import and graph log files
PostPosted: Sat Aug 25, 2012 3:59 pm 
Offline
Newbie

Joined: Sat Aug 01, 2009 12:32 am
Posts: 96
Location: Central Coast, CA
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
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.


Attachments:
romraiderlog_20120824_214333-3rd rpm only.csv [32.32 KiB]
Downloaded 528 times
Top
 Profile  
 
 Post subject: Re: SPREADSHEET: import and graph log files
PostPosted: Sat Aug 25, 2012 11:45 pm 
Offline
RomRaider Donator

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


Top
 Profile  
 
 Post subject: Re: SPREADSHEET: import and graph log files
PostPosted: Tue Mar 26, 2013 2:05 am 
Offline
RomRaider Donator

Joined: Wed Aug 02, 2006 9:40 pm
Posts: 1067
Location: Calgary
First post updated with new version of spreadsheet.


Top
 Profile  
 
 Post subject: Re: SPREADSHEET: import and graph log files
PostPosted: Tue Mar 26, 2013 6:54 pm 
Offline
RomRaider Donator

Joined: Wed Aug 02, 2006 9:40 pm
Posts: 1067
Location: Calgary
D'oh, attached the wrong file last night. Proper file uploaded.


Top
 Profile  
 
 Post subject: Re: SPREADSHEET: import and graph log files
PostPosted: Wed Mar 27, 2013 10:25 pm 
Offline
RomRaider Donator
User avatar

Joined: Mon Dec 15, 2008 3:12 am
Posts: 672
Location: The Philippines
Can the spreadsheet have an update on per cylinder timing compensation as its currently 2d only? Helpful too to have per gear timing :-)


Top
 Profile  
 
 Post subject: Re: SPREADSHEET: import and graph log files
PostPosted: Sat Apr 06, 2013 10:08 am 
Offline
Newbie
User avatar

Joined: Tue Jan 13, 2009 4:06 pm
Posts: 37
Location: Wisconsin
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.

_________________

-2003 WRX
-LGT gears
-BW s256sx


Top
 Profile  
 
 Post subject: Re: SPREADSHEET: import and graph log files
PostPosted: Sat Apr 06, 2013 11:35 am 
Offline
RomRaider Donator

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


Top
 Profile  
 
 Post subject: Re: SPREADSHEET: import and graph log files
PostPosted: Sat Apr 27, 2013 8:36 am 
Offline
Newbie

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.

_________________
2001 WRX, ID1000, 340LPH fuel pump, Grimmspeed 3 port BCS, Xforce TBE,
Corn fed


Top
 Profile  
 
 Post subject: Re:
PostPosted: Tue May 21, 2013 6:26 pm 
Offline
Newbie

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


Top
 Profile  
 
 Post subject: Re: SPREADSHEET: import and graph log files
PostPosted: Wed May 22, 2013 1:51 am 
Offline
RomRaider Donator

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


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

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