RomRaider Logo

RomRaider

Open Source ECU Tools
 FAQ •  Register •  Login 

RomRaider

Documentation

Community

Developers

It is currently Tue Dec 23, 2025 2:15 pm

All times are UTC - 5 hours [ DST ]





Post new topic Reply to topic  [ 430 posts ]  Go to page Previous  1 ... 19, 20, 21, 22, 23, 24, 25 ... 29  Next
Author Message
 Post subject: Re: SPREADSHEET: import and graph log files
PostPosted: Wed Feb 17, 2010 2:59 pm 
Offline
RomRaider Donator

Joined: Wed Feb 06, 2008 4:10 pm
Posts: 367
Airboy wrote:
Lance Lucas wrote:
dschultz wrote:
Just for giggles I tried your data in the RR Logger Road Dyno I created. Here's what I got:
Has anyone tried any of the road dyno options for logs taken during chassis dyno pulls? I'll take a couple logs using RR in a Subaru on our Mustang Dyno and see what happens :D


Don't think you could use the data from the chassis dyno runs because the resistance is provided by the dyno rollers and brakes so the acceleration data (rpm vs time) is controlled by the dyno computer. This is really apparent for dynos that uses linear ramp rates (dyna pak, dyno dynamics), the "acceleration" is fixed regardless of the power output of the engine.


Mustangs do indeed use a non-linear load...it's an exponential curve based on roller speed IIRC. There are also a number of testing modes -- most of the world is familiar with the "Power Curve" test, which tests the car in a single gear through a set RPM range. There are also vehicle simulation modes.

_________________
2004 WRX Wagon and 2013 STI Sedan


Top
 Profile  
 
 Post subject: Re: SPREADSHEET: import and graph log files
PostPosted: Fri Apr 23, 2010 6:02 am 
Offline
Newbie

Joined: Wed May 07, 2008 8:01 pm
Posts: 36
One Question.

Is it Wheel Horse Power or at Crankshaft?

Cause: my logs with my 2004 EDM STi are good, all seems to be right,
light tuning an the spreadsheet says 230 HP.
So if its WHP its ok i think.
BUT, when i log my 1999 Impreza Turbo (original 218PS at crankshaft),
the spreadheet says 211 HP. Thats really to much if this are wheel horse power.
So where is the problem?? All data are ok, i have the right weight, wheel diameters,
drag coefficient and so on.

Both cars feel normal, so there is no problem that the STi are too slow or the
1999er too fast or so.

Can anyone explain me these numbers?

Sorry for my bad english


Top
 Profile  
 
 Post subject: Re: SPREADSHEET: import and graph log files
PostPosted: Fri Apr 23, 2010 8:24 pm 
Offline
RomRaider Donator
User avatar

Joined: Wed Feb 06, 2008 3:49 am
Posts: 1054
Location: Australia
it is estimated WHP. Check to ensure the weight and gear ratios are correct for your 1999 model, otherwise the WHP will be very skewed (incorrect).

Leslie

_________________

Current Car: 2002 ADM WRX STi
Current Engine: EJ207
Current Mods: X-Force 3" TBE Exhaust, GCG "bolt-on" GT3076R, APS 3" Hard Turbo Inlet, Short Ram Pod, RomRaider/ECUFlash Tune
Current Power: 248kw@wheels (332whp)


Top
 Profile  
 
 Post subject: Re: SPREADSHEET: import and graph log files
PostPosted: Tue May 18, 2010 12:02 pm 
Offline
Newbie

Joined: Mon Sep 25, 2006 6:40 pm
Posts: 25
Soo... I've been fooling around with the spreadsheet and figured out how to extract data from a rom file and populate the tables for Base Timing. Populating the other tables is just a matter of writing the code and cleaning things up.

I'm still trying to figure out how to get the hex addresses and calculations from the XML definition file in an automated fashion. Currently, I have a worksheet with a manually created table that lists some various roms and their timing map specifications. Excel grabs the ROM ID, looks it up on the definition worksheet, then populates the tables. It seems to be working pretty well and has potential.

Is there any want/need for this?


Top
 Profile  
 
 Post subject: Re: SPREADSHEET: import and graph log files
PostPosted: Tue May 18, 2010 6:24 pm 
Offline
RomRaider Donator

Joined: Wed Aug 02, 2006 9:40 pm
Posts: 1067
Location: Calgary
bluescoobywagon wrote:
Soo... I've been fooling around with the spreadsheet and figured out how to extract data from a rom file and populate the tables for Base Timing. Populating the other tables is just a matter of writing the code and cleaning things up.

I'm still trying to figure out how to get the hex addresses and calculations from the XML definition file in an automated fashion. Currently, I have a worksheet with a manually created table that lists some various roms and their timing map specifications. Excel grabs the ROM ID, looks it up on the definition worksheet, then populates the tables. It seems to be working pretty well and has potential.

Is there any want/need for this?


The ability to have the spreadsheet transfer tables directly from the ROM would be awesome. I wanted to but lacked the macro knowledge. Are you doing this via ActiveX controls?

Can you share your spreadsheet? I would love to take a look.


Top
 Profile  
 
 Post subject: Re: SPREADSHEET: import and graph log files
PostPosted: Tue Jun 29, 2010 6:29 pm 
Offline
Newbie

Joined: Fri Mar 26, 2010 10:44 am
Posts: 2
Can't seem to get it to plot right.
2009 wrx sedan premium
TP Stage 1
75* about 55% humidity


Attachments:
romraiderlog_20100620_074502 dyno log.csv [1.43 KiB]
Downloaded 378 times
Top
 Profile  
 
 Post subject: Re: SPREADSHEET: import and graph log files
PostPosted: Tue Jun 29, 2010 8:35 pm 
Offline
Newbie

Joined: Sun Jan 04, 2009 8:41 pm
Posts: 46
bluescoobywagon wrote:
Soo... I've been fooling around with the spreadsheet and figured out how to extract data from a rom file and populate the tables for Base Timing. Populating the other tables is just a matter of writing the code and cleaning things up.

I'm still trying to figure out how to get the hex addresses and calculations from the XML definition file in an automated fashion. Currently, I have a worksheet with a manually created table that lists some various roms and their timing map specifications. Excel grabs the ROM ID, looks it up on the definition worksheet, then populates the tables. It seems to be working pretty well and has potential.

Is there any want/need for this?


This would save a lot of stuffing around if you could get it to work. It would also be great if someone could port this spreadsheet to excel 2007/2010 as it doesn't work 100% using excel's own conversion.

Cheers,
Matt.


Top
 Profile  
 
 Post subject: Re: SPREADSHEET: import and graph log files
PostPosted: Tue Jul 06, 2010 5:48 pm 
Offline
Experienced
User avatar

Joined: Mon Apr 30, 2007 8:02 pm
Posts: 521
Is there a later edition of this?

It would be nice to get accurate info in the drag co-eff, and the frontal area of our cars. Right now it looks like ver#4 just has the exact same numbers for all cars, which is not correct.

_________________
05 LGT (ST and OS tuning) AVO380/TMIC/header/TBE/alky/AEM CAI


Top
 Profile  
 
 Post subject: Re: SPREADSHEET: import and graph log files
PostPosted: Thu Sep 02, 2010 5:54 am 
Offline
Experienced
User avatar

Joined: Tue Nov 17, 2009 8:38 pm
Posts: 185
Location: Vancouver WA, USA
hey guys for some reason when I import the csv file and look at the dyno plot it reads very low, something like 178 whp and 188wtq, car is an 06wrx with vf39. can't figure out if i'm doing anything wrong.


Top
 Profile  
 
 Post subject: Re: SPREADSHEET: import and graph log files
PostPosted: Sat Oct 16, 2010 9:47 am 
Offline
Experienced

Joined: Tue Apr 15, 2008 11:11 am
Posts: 162
is there a cure to mate ecuedit log files with this tool?
I keep getting 1004 error upon applying accel calculations, and I did rename the log file so it has a short name with no brackets

'The factor 45.54865424430 converts mph/milliseconds to Gs.
'conversion factors
' 5280 ft = 1 mile
' 1 hr = 3600 seconds
' 1000 ms = 1 second
' 1 G = 32.2 ft/second^2
' cell N9 is the conversion from mph to rpm
Cells(row, 5).Value = "=SLOPE(D" & (row) & ":D" & (row + 1) & ",A" & (row) & ":A" & (row + 1) & ")" & " * " & 45.5486542443 & "/" & Time_multiply

_________________
powered by vodka


Top
 Profile  
 
 Post subject: Re: SPREADSHEET: import and graph log files
PostPosted: Sun Oct 17, 2010 1:15 pm 
Offline
RomRaider Donator

Joined: Wed Aug 02, 2006 9:40 pm
Posts: 1067
Location: Calgary
rac wrote:
is there a cure to mate ecuedit log files with this tool?
I keep getting 1004 error upon applying accel calculations, and I did rename the log file so it has a short name with no brackets

'The factor 45.54865424430 converts mph/milliseconds to Gs.
'conversion factors
' 5280 ft = 1 mile
' 1 hr = 3600 seconds
' 1000 ms = 1 second
' 1 G = 32.2 ft/second^2
' cell N9 is the conversion from mph to rpm
Cells(row, 5).Value = "=SLOPE(D" & (row) & ":D" & (row + 1) & ",A" & (row) & ":A" & (row + 1) & ")" & " * " & 45.5486542443 & "/" & Time_multiply


ecuedit has a road dyno built in, doesn't it?

The first column in the log file has to be time stamps. Would be helpful if you attach a sample log as well.


Top
 Profile  
 
 Post subject: Re: SPREADSHEET: import and graph log files
PostPosted: Sun Oct 17, 2010 4:47 pm 
Offline
Experienced

Joined: Tue Apr 15, 2008 11:11 am
Posts: 162
yeah it does
I am actually curious to compare it

here's a sample log


Attachments:
log.csv [6.69 KiB]
Downloaded 359 times

_________________
powered by vodka
Top
 Profile  
 
 Post subject: Re: SPREADSHEET: import and graph log files
PostPosted: Tue Oct 19, 2010 11:31 pm 
Offline
RomRaider Donator

Joined: Wed Aug 02, 2006 9:40 pm
Posts: 1067
Location: Calgary
The file ran fine through the spreadsheet.

Are you using MS Excel?


Top
 Profile  
 
 Post subject: Re: SPREADSHEET: import and graph log files
PostPosted: Wed Oct 20, 2010 5:59 am 
Offline
Experienced

Joined: Tue Apr 15, 2008 11:11 am
Posts: 162
yep, 2007 office

hmm... I might have an idea,
I am located in EDM zone with local windows settings, it might interpret some values wrong thus I am not able to use the dyno?
however everything else shows up ok

_________________
powered by vodka


Top
 Profile  
 
 Post subject: Re: SPREADSHEET: import and graph log files
PostPosted: Thu Oct 21, 2010 11:24 pm 
Offline
RomRaider Donator

Joined: Wed Aug 02, 2006 9:40 pm
Posts: 1067
Location: Calgary
run the macro and get a screenshot of the error message, then hit the "debug" button and see which line of code it highlights


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 430 posts ]  Go to page Previous  1 ... 19, 20, 21, 22, 23, 24, 25 ... 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