|
RomRaider
Documentation
Community
Developers
|
| Author |
Message |
|
Lance Lucas
|
Post subject: Re: SPREADSHEET: import and graph log files Posted: Wed Feb 17, 2010 2:59 pm |
|
 |
| 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  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 |
|
 |
|
drischnie
|
Post subject: Re: SPREADSHEET: import and graph log files Posted: Fri Apr 23, 2010 6:02 am |
|
 |
| 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 |
|
 |
|
wrxsti-l
|
Post subject: Re: SPREADSHEET: import and graph log files Posted: Fri Apr 23, 2010 8:24 pm |
|
 |
| RomRaider Donator |
 |
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 |
|
 |
|
bluescoobywagon
|
Post subject: Re: SPREADSHEET: import and graph log files Posted: Tue May 18, 2010 12:02 pm |
|
 |
| 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 |
|
 |
|
Airboy
|
Post subject: Re: SPREADSHEET: import and graph log files Posted: Tue May 18, 2010 6:24 pm |
|
 |
| 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 |
|
 |
|
powells85
|
Post subject: Re: SPREADSHEET: import and graph log files Posted: Tue Jun 29, 2010 6:29 pm |
|
 |
| 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
|
|
| Top |
|
 |
|
mdedwar
|
Post subject: Re: SPREADSHEET: import and graph log files Posted: Tue Jun 29, 2010 8:35 pm |
|
 |
| 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 |
|
 |
|
LittleBlueGT
|
Post subject: Re: SPREADSHEET: import and graph log files Posted: Tue Jul 06, 2010 5:48 pm |
|
 |
| Experienced |
 |
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 |
|
 |
|
Alexmartynyuk
|
Post subject: Re: SPREADSHEET: import and graph log files Posted: Thu Sep 02, 2010 5:54 am |
|
 |
| Experienced |
 |
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 |
|
 |
|
rac
|
Post subject: Re: SPREADSHEET: import and graph log files Posted: Sat Oct 16, 2010 9:47 am |
|
 |
| 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 |
|
 |
|
Airboy
|
Post subject: Re: SPREADSHEET: import and graph log files Posted: Sun Oct 17, 2010 1:15 pm |
|
 |
| 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 |
|
 |
|
rac
|
Post subject: Re: SPREADSHEET: import and graph log files Posted: Sun Oct 17, 2010 4:47 pm |
|
 |
| 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 |
|
 |
|
Airboy
|
Post subject: Re: SPREADSHEET: import and graph log files Posted: Tue Oct 19, 2010 11:31 pm |
|
 |
| 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 |
|
 |
|
rac
|
Post subject: Re: SPREADSHEET: import and graph log files Posted: Wed Oct 20, 2010 5:59 am |
|
 |
| 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 |
|
 |
|
Airboy
|
Post subject: Re: SPREADSHEET: import and graph log files Posted: Thu Oct 21, 2010 11:24 pm |
|
 |
| 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 |
|
 |
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
|
|