RomRaider Logo

RomRaider

Open Source ECU Tools
 FAQ •  Register •  Login 

RomRaider

Documentation

Community

Developers

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

All times are UTC - 5 hours [ DST ]





Post new topic Reply to topic  [ 52 posts ]  Go to page Previous  1, 2, 3, 4  Next
Author Message
 Post subject: Re: Spreadsheet to generate fuel trim pivot table (RPM v. MRP)
PostPosted: Fri Dec 11, 2009 2:25 am 
Offline
Experienced

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


Ok, I understand that...
But how do I go about adjusting the Pivot Table range in the El Comp Tab...??? :?


Top
 Profile  
 
 Post subject: Re: Spreadsheet to generate fuel trim pivot table (RPM v. MRP)
PostPosted: Fri Dec 11, 2009 3:14 am 
Offline
Newbie

Joined: Sun Jan 04, 2009 8:41 pm
Posts: 46
Hi Airboy,
Firstly thanks for the putting together this spreadsheet. :D
I had a few questions about applying this to the mrp comp table.
1. Am I best to zero out the table and start from scratch then drive around to get
valid data then run it through the spreadsheet?
2. If I start with the base map settings do I need to apply the delta between the top pivot table (avg tot corrections) to my base table to get the right figures?
3. Can you extend the pivot table range to greater that 9371 rows in the base line? With the SD card logging I am getting way past this number which screws up the pivot rpm ranges.

All these spreadsheet are great for new people like me but one of the problems I'm having is how to apply these back into RR.

I would rather ask seemingly stupid questions than blow up my car due to ignorance.

Thanks,
Matt.


Top
 Profile  
 
 Post subject: Re: Spreadsheet to generate fuel trim pivot table (RPM v. MRP)
PostPosted: Fri Dec 11, 2009 4:38 pm 
Offline
Experienced
User avatar

Joined: Mon Apr 30, 2007 8:02 pm
Posts: 521
Anyway to make this thing work if CL is disabled, running everything at 14.5:1 or richer?

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


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

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


Ok, I understand that...
But how do I go about adjusting the Pivot Table range in the El Comp Tab...??? :?


You don't make any changes to the pivot table range in the EL Comp tab. The headers are taken from the ROM page and you'll only see the rows that contains data. If your log doesn't have any valid data around 3600rpm, there won't be a row for 3600RPM.


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

Joined: Wed Aug 02, 2006 9:40 pm
Posts: 1063
Location: Calgary
mdedwar wrote:

1. Am I best to zero out the table and start from scratch then drive around to get
valid data then run it through the spreadsheet?

up to you, really. Works either way.
Quote:
2. If I start with the base map settings do I need to apply the delta between the top pivot table (avg tot corrections) to my base table to get the right figures?

yes. If the pivot table has -8 in a particular cell, then subtract 8 from the matching cell in your ROM table. Keep in mind that the lighter color cells doesn't have much data in them.
Quote:
3. Can you extend the pivot table range to greater that 9371 rows in the base line? With the SD card logging I am getting way past this number which screws up the pivot rpm ranges.

Right-click on the pivot table
Select Pivot Table Wizard
Click the "Back" button
Change the range to a higher number


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

Joined: Wed Aug 02, 2006 9:40 pm
Posts: 1063
Location: Calgary
LittleBlueGT wrote:
Anyway to make this thing work if CL is disabled, running everything at 14.5:1 or richer?


Why?


Top
 Profile  
 
 Post subject: Re: Spreadsheet to generate fuel trim pivot table (RPM v. MRP)
PostPosted: Fri Dec 11, 2009 11:06 pm 
Offline
Experienced
User avatar

Joined: Mon Apr 30, 2007 8:02 pm
Posts: 521
Airboy wrote:
LittleBlueGT wrote:
Anyway to make this thing work if CL is disabled, running everything at 14.5:1 or richer?


Why?


My front O2 is in the DP, and I am having some oscillations in AFR, I fell if I disable CL, then I can get a more accurate picture of AFR over different rpm/map spots.

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


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

Joined: Wed Aug 02, 2006 9:40 pm
Posts: 1063
Location: Calgary
LittleBlueGT wrote:
Airboy wrote:
LittleBlueGT wrote:
Anyway to make this thing work if CL is disabled, running everything at 14.5:1 or richer?


Why?


My front O2 is in the DP, and I am having some oscillations in AFR, I fell if I disable CL, then I can get a more accurate picture of AFR over different rpm/map spots.


I suppose the macros can be modified to generate AFR error (measured AFR - some constant used in the fuel map) and then a pivot table of these errors against RPM and MRP


Top
 Profile  
 
 Post subject: Re: Spreadsheet to generate fuel trim pivot table (RPM v. MRP)
PostPosted: Wed Jan 13, 2010 7:18 am 
Offline
RomRaider Donator
User avatar

Joined: Wed Feb 06, 2008 3:49 am
Posts: 1054
Location: Australia
Can someone explain the steps required for this spreadsheet to list more rpm values. When I first added data from a couple logs, it had values all the way to 4000rpm, but after adding another 3 logs of data, it now only has values upto 3000rpm.

How can I make the spreadsheet display values upto 5000rpm?

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 to generate fuel trim pivot table (RPM v. MRP)
PostPosted: Wed Jan 13, 2010 10:23 am 
Offline
RomRaider Developer

Joined: Wed May 20, 2009 9:49 pm
Posts: 5659
Location: Canada eh!
I believe your answer is in the 4th post of this thread where I previously had a similar problem.


Top
 Profile  
 
 Post subject: Re: Spreadsheet to generate fuel trim pivot table (RPM v. MRP)
PostPosted: Wed Jan 13, 2010 10:16 pm 
Offline
RomRaider Donator
User avatar

Joined: Wed Feb 06, 2008 3:49 am
Posts: 1054
Location: Australia
I need the steps for how to make the changes that were suggested in that post - what did you do exactly to fix it for you?

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 to generate fuel trim pivot table (RPM v. MRP)
PostPosted: Wed Jan 13, 2010 10:57 pm 
Offline
RomRaider Donator

Joined: Wed Aug 02, 2006 9:40 pm
Posts: 1063
Location: Calgary
The pivot table currently has ~9000 lines. You can change that by right-click on the pivot table and call up the Pivot Table Wizard. On the next window that pops up, click the "Back" button and change the data range.


Top
 Profile  
 
 Post subject: Re: Spreadsheet to generate fuel trim pivot table (RPM v. MR
PostPosted: Sun Apr 25, 2010 6:23 pm 
Offline
RomRaider Donator
User avatar

Joined: Mon Dec 15, 2008 3:12 am
Posts: 667
Location: Brgy. Horseshoe, The Philippines
The ones on the average pivot is the one that goes directly to the MP table right? Just asking to be sure, haha I did an initial revision and it seems spot on. I only got results for 1200 to 2600 though, need to get info on the lower range as well. How do you guys drive to get it, 1st gear? 3rd for 3600 close loop or 2nd gear?

Does it matter what temperature you log for this or it should be the warmest when you get leaner afr?


Top
 Profile  
 
 Post subject: Re: Spreadsheet to generate fuel trim pivot table (RPM v. MR
PostPosted: Thu Jul 15, 2010 1:11 pm 
Offline
Experienced

Joined: Sat May 31, 2008 10:14 pm
Posts: 125
Location: Quebec
Is it an ITERATIVE process? if yes, how much pass should be done approximately?

thanx

Mart


Top
 Profile  
 
 Post subject: Re: Spreadsheet to generate fuel trim pivot table (RPM v. MR
PostPosted: Sat Sep 25, 2010 12:25 am 
Offline
Newbie

Joined: Fri Sep 03, 2010 3:50 pm
Posts: 37
Location: atx
I've implemented a utility similar to this spreadsheet, but in Matlab, to get around the 65535 Excel row limit.

Here it is.

Note that the function data_load_1, loads data in a particular format and will have to be edited depending on the format of your log files.


Attachments:
File comment: WinRAR archive
EL Comp Matlab.rar [3.82 KiB]
Downloaded 220 times
Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 52 posts ]  Go to page Previous  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