RomRaider Logo

RomRaider

Open Source ECU Tools
 FAQ •  Register •  Login 

RomRaider

Documentation

Community

Developers

It is currently Thu Dec 14, 2017 1:11 pm

All times are UTC - 5 hours [ DST ]





Post new topic Reply to topic  [ 52 posts ]  Go to page 1, 2, 3, 4  Next
Author Message
 Post subject: Spreadsheet to generate fuel trim pivot table (RPM v. MRP)
PostPosted: Fri Nov 06, 2009 12:58 am 
Offline
RomRaider Donator

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

Click the "Back" button
Image

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


Attachments:
Engine Load Comp MRP R5.zip [208.55 KiB]
Downloaded 803 times
File comment: latest version
Engine Load Comp MRP R3.zip [286.86 KiB]
Downloaded 1574 times


Last edited by Airboy on Sun Oct 28, 2012 2:13 pm, edited 3 times in total.
Top
 Profile  
 
 Post subject: Re: Spreadsheet to generate fuel trim pivot table (RPM v. MRP)
PostPosted: Fri Nov 06, 2009 4:45 pm 
Offline
Experienced
User avatar

Joined: Wed Nov 29, 2006 12:22 am
Posts: 378
Location: Gilbert, AZ
Works with Excel 2007 and XP.

_________________
Tau Performance- RomRaider tuner and Amsoil dealer


Top
 Profile  
 
 Post subject: Re: Spreadsheet to generate fuel trim pivot table (RPM v. MRP)
PostPosted: Fri Nov 06, 2009 5:51 pm 
Offline
RomRaider Developer

Joined: Wed May 20, 2009 9:49 pm
Posts: 5659
Location: Canada eh!
Hi:
I get an error running the Filter.
I have Excel 2002 SP3 on XP SP3.

Dale


Attachments:
Engine Load Comp MRP R1-broke.zip [509.99 KiB]
Downloaded 344 times
Top
 Profile  
 
 Post subject: Re: Spreadsheet to generate fuel trim pivot table (RPM v. MRP)
PostPosted: Wed Nov 11, 2009 1:29 am 
Offline
RomRaider Donator

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


Top
 Profile  
 
 Post subject: Re: Spreadsheet to generate fuel trim pivot table (RPM v. MRP)
PostPosted: Wed Nov 11, 2009 7:24 pm 
Offline
RomRaider Developer

Joined: Wed May 20, 2009 9:49 pm
Posts: 5659
Location: Canada eh!
Thanks, that worked.


Top
 Profile  
 
 Post subject: Re: Spreadsheet to generate fuel trim pivot table (RPM v. MRP)
PostPosted: Sun Nov 15, 2009 6:16 pm 
Offline
Experienced
User avatar

Joined: Tue Feb 19, 2008 11:02 pm
Posts: 243
Location: Broomfield, Colorado
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. :D

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.

_________________
-Eric Minehart
2009 WRX Dom 3 on e85
2002 WRX VF30 on E85(SOLD)
eminehart@yahoo.com
www.torquedperformance.com


Top
 Profile  
 
 Post subject: Re: Spreadsheet to generate fuel trim pivot table (RPM v. MRP)
PostPosted: Sun Nov 15, 2009 6:46 pm 
Offline
RomRaider Donator

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

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.


Top
 Profile  
 
 Post subject: Re: Spreadsheet to generate fuel trim pivot table (RPM v. MRP)
PostPosted: Tue Nov 17, 2009 12:07 pm 
Offline
Experienced
User avatar

Joined: Sat Dec 16, 2006 1:59 pm
Posts: 197
Very nice, thanks Sonny for putting this together!!

_________________
aka:

-Nate


Top
 Profile  
 
 Post subject: Re: Spreadsheet to generate fuel trim pivot table (RPM v. MRP)
PostPosted: Mon Nov 23, 2009 3:30 am 
Offline
Experienced

Joined: Wed Jun 18, 2008 7:46 am
Posts: 106
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


Attachments:
File comment: My current RPM vs MRP fuel trim
Noname.jpg
Noname.jpg [ 33.41 KiB | Viewed 13129 times ]
Top
 Profile  
 
 Post subject: Re: Spreadsheet to generate fuel trim pivot table (RPM v. MRP)
PostPosted: Wed Nov 25, 2009 3:31 pm 
Offline
Experienced
User avatar

Joined: Tue Feb 19, 2008 11:02 pm
Posts: 243
Location: Broomfield, Colorado
Airboy wrote:
eminehart wrote:
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. :D

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.


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.

_________________
-Eric Minehart
2009 WRX Dom 3 on e85
2002 WRX VF30 on E85(SOLD)
eminehart@yahoo.com
www.torquedperformance.com


Top
 Profile  
 
 Post subject: Re: Spreadsheet to generate fuel trim pivot table (RPM v. MRP)
PostPosted: Wed Nov 25, 2009 10:20 pm 
Offline
RomRaider Donator

Joined: Wed Aug 02, 2006 9:40 pm
Posts: 1063
Location: Calgary
sega wrote:
Hi,
1. Why can I only plot out the data during 2000~3600RPM?
How can I make the other range available?

Check the 2nd post above yours.
sega wrote:
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?


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


Top
 Profile  
 
 Post subject: Re: Spreadsheet to generate fuel trim pivot table (RPM v. MRP)
PostPosted: Thu Dec 03, 2009 10:21 pm 
Offline
Experienced

Joined: Mon Mar 24, 2008 5:54 pm
Posts: 111
What do you guys think about:

Image


Top
 Profile  
 
 Post subject: Re: Spreadsheet to generate fuel trim pivot table (RPM v. MRP)
PostPosted: Wed Dec 09, 2009 4:31 am 
Offline
Experienced

Joined: Wed May 14, 2008 10:26 am
Posts: 194
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


Attachments:
Engine Load vs MP - Canbus ecu.JPG
Engine Load vs MP - Canbus ecu.JPG [ 86.88 KiB | Viewed 13137 times ]
Top
 Profile  
 
 Post subject: Re: Spreadsheet to generate fuel trim pivot table (RPM v. MRP)
PostPosted: Fri Dec 11, 2009 12:22 am 
Offline
RomRaider Donator

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


Top
 Profile  
 
 Post subject: Re: Spreadsheet to generate fuel trim pivot table (RPM v. MRP)
PostPosted: Fri Dec 11, 2009 12:24 am 
Offline
RomRaider Donator

Joined: Wed Aug 02, 2006 9:40 pm
Posts: 1063
Location: Calgary
First post updated with new version with added graphs for the raw data.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 52 posts ]  Go to page 1, 2, 3, 4  Next

All times are UTC - 5 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 2 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

Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
Style based on FI Subsilver by phpBBservice.nl