RomRaider

I have tested this with Excel 2003 but not Excel 2007. Post here if you come across anything strange.
UPDATE Oct 2012
R5
-pivot table is now RPM vs. Manifold Absolute Pressure or Injector Pulse Width

R3 should be used if you want to use "Manifold Pressure (psi relative sea level)" as the pivot table category.

UPDATE
R3
-Modified macro to clean up the headers in the Pivot tables (thanks to Hurricane123) so it should only use the current header values in the "ROM" page.
-Added pages to plot the filtered data against MAFv or RPM. Essentially the raw data without the MRP information.

The pivot table is set to use up to ~9000 lines of data. If you want to increase the limit, these steps should do it (I use Excel2003).
Right-click on the pivot table to bring up the pivot table menu and select "Pivot Table Wizard"


Click the "Back" button


Change the limit. Excel2003 has limit of ~65000 lines.

Works with Excel 2007 and XP.

Hi:
I get an error running the Filter.
I have Excel 2002 SP3 on XP SP3.

Dale

In the ROM page, add a column to the end and put 4 or some number that is larger than the highest MRP in your log. You may want to extend the RPM rows to cover values beyond 2000 as well.

Thanks, that worked.

Thank you so much for making this spreadsheet. I have been doing this manually for weeks by pulling data Filtered from Mickey D's Closed Loop Fueling Spreadsheet and manually graphing the data. So with this spreadsheet you have freed an hour of my life each time I do this.

I was wondering if it was possible to change the RPM and MRP values. I have often changed these values from stock and many roms have different values from the ones in the spreadsheet. I am often having to change values above 4000 RPM as well.

Glad I can help . Most of the work in that spreadsheet was done by mickeyd2005 for the MAF/injector spreadsheet.

You can change the RPM/load headers values as well as the number of rows (I have the limit set to 28 rows I think)
Anyways, the pivot tables are a bit strange (that or I just don't know my way around them) that if I go to the ROM page and change the RPM/load headers and then run the macro again, the headers that are no longer in the ROM page still appears in the pivot table. A sort of workaround would be to go to the pivot table "Field Settings" and uncheck the option to "display items with no data". Downside to this is you have to be careful that there aren't any missing rows/columns afterward. Another way is to uncheck the now unused rows from the drop down list for the pivot table row/columns.

Very nice, thanks Sonny for putting this together!!

Hi,
This is a convenient macro tool and help tune MRP related fuel trim compensation very much.
But I have few question about it :
1. Why can I only plot out the data during 2000~3600RPM?
How can I make the other range available?
2. I feel my 1st/2nd gear startup is not very smooth in slight throttle. Is it possible due to RPM vs MRP fuel trim not correct?

Attached my current result for reference below.

Tuned car data :
2006 EDM WRX 4D
IHI VF36 floating twinscroll turbo
AVO TMIC
HKS BOV
Stock STI cat
HKS R-suction high flow filter
Fujitsubo catback

That worked. I load the rom info and manually checked the rpm ranges I wanted and it worked. I tell you what, These tables are key to tuning a intake. especially Big MAF.

Check the 2nd post above yours.


Can't say. Your plot looks OK though as the corrections are only a few percent off.

What do you guys think about:

Airboy...

Can you please prep another similar spreadsheet to accommodate the 2008 Hatch STI's (Canbus ecu)...
And can you please allow for the attached rpm and MP range, as per the attached image...???

PLEASE DUDE!!!

Thanks.
Phoenix

You can use the spreadsheet for any ROM that uses the MAF compensation MRP table. Just change the header values in the "ROM" page. It was originally made because the '08+ STi had strange response in this area.

First post updated with new version with added graphs for the raw data.