RomRaider

Airboy, I've modified your spreadsheet to include SD interpolation and SD target for us guys using the Group N ROM. You can download it directly from HERE for perusal - hopefully you will include the tabs in future releases (and save me from having to add them :p).

Leslie

Airboy...

For some reason the overlay / Interpolation function isn't working for me...???
I need this to work, so that I can determine targeted AFR's...
Is it an issue with the spreadsheet, or perhaps something to do with me...
Can someone please test the interpolate function, and see if an overlay is shown...

This is what I'm getting...see attached...

Post your log file.

I actually managed to come right...
For some reason, if I select the calculated load button, in the data tab, after importing a csv file...then I have issues interpolating data...hmmm...weird...what you think Airboy...???

If I don't select 'Calculate Load'...then it works fine!

The "Calculate Load" button is only needed if you didn't log Engine Load and only MAF(g/s). You probably logged both MAF(g/s) and MAF(v). The list box under the Calculate Load button shows which data column it is using to calculate Engine Load. It is likely highlighting the MAF(v) data, which is not the correct item.

Aaaaah...makes sense now Airboy...

Thanks bud!

I have been trying to use the dyno function with my AEM Standalone logs to no avail Any help Airboy et al? I'd really like to know the trick if someone is able to make it successfully work.

Here's the relevant info I think:
2004 WRX Wagon
2006 STi 6MT
Pulls done in 4th Gear
Tire Size: 225/45/17
Extra weight = 275 lbs

Thanks!!

The problem is that the resolution is too high.

If you move the charts around, you can see the equations in the cells. Take a look at the equations in column E. The rough acceleration is calculated first. It is calculated based upon just two rows of data. Since your resolution is super high, the difference between the two rows is too small to calculate a decent slope.

What I did was filter your data and only grabbed every tenth data point and I also multiplied the time by 1000 to convert to milliseconds.

What we really need to do is to rewrite the internal EXCEL slope function.

Thank you Mickey, much appreciated!

I ran the data through and it worked "ok" with the max filter value of 10. You have to extend the graph range from ~200 rows to 600 rows to cover all of your data. Don't forget to filter the WOT data on the first page.


Looks like AEM spits out data at 20ms intervals but the actual data doesn't have that time resolution (repeated values).

You can increase the filter value by:
-click on the cell for Smoothing Factor
-go to the menu bar under Data, select "Validation..."
-in the window that pops up, there should be a box for "Source" that lists 3,4,5,6,7,8,9,10
-add one or more values to the end (e.g. 16, 20)

Now you should be able to select smoothing factor or 16 or 20. Re-run the macro and it should look like this:


The above instructions are for Excel 2003, the menus are likely different in Excel 2007 but if you search for "validation" it should show you where it is hiding.

Added those as well at 24, which seems to work well. Thank you guys very much for all of the help!

Just for giggles I tried your data in the RR Logger Road Dyno I created. Here's what I got:
For Export 000.txt I assumed '04 WRX WGN 6MT, 4th gear.

For Export 001.txt I assumed '06 STi 6MT, 4th gear.

What do you think?
Dale

Missed the development of the road dyno function in the logger...good job . I just read the posts in the road dyno thread. I'll ask my questions there.

Cool! I still do plenty of reflash-based tuning and this should be very helpful...it's always nice to reduce the number of programs/tools necessary to get the job done.

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.