Spreadsheet to generate fuel trim pivot table (RPM v. MRP)

GRawSTi · **Joined:** Mon Jan 30, 2012 10:18 pm **Posts:** 22

Well, I was previously able to use this spreadsheet to help adjust my SD VE table, based on my fuel trims... However, now when it filters through the data, it lists almost ALL of my data as "1" under the applicable column? I've taken 20-30 minute logs with normal driving, slow throttle inputs, etc... Attached is a copy of my log and how the spreadsheet looks after I filter the data...

Any help is greatly appreciated!

Airboy · **Posted:** Thu Oct 18, 2012 6:07 pm

GRawSTi wrote:

Well, I was previously able to use this spreadsheet to help adjust my SD VE table, based on my fuel trims... However, now when it filters through the data, it lists almost ALL of my data as "1" under the applicable column? I've taken 20-30 minute logs with normal driving, slow throttle inputs, etc... Attached is a copy of my log and how the spreadsheet looks after I filter the data...

Any help is greatly appreciated!

A few months late but, your AFR data was out of range (14.2-15 is the window) and most of your data is in the 13's

Airboy · **Posted:** Thu Oct 18, 2012 6:08 pm

New version added to first post.

icycold · **Joined:** Wed Nov 12, 2008 3:07 am **Posts:** 8

How do you make the tables for engine load compensation for cruise and non-cruise ?

Do I log .. cruising and non-cruise style driving ?

stephen · **Joined:** Mon Mar 17, 2014 9:22 pm **Posts:** 4

I'm having issues with the spread sheet and Windows 10. When selecting "Clear & Get Data" the entire sheet (minus floating boxes) goes blank. With windows 7, the header would be kept. Any info or updates would be greatly appreciated.

Stephen

Kim · **Joined:** Wed Jun 06, 2012 10:11 pm **Posts:** 25

hebs wrote:

(in excel 2k7) I only see "pivot table options" when I right click, not pivot table "wizard". In pivot table options, I dont see where I can increase the range. Any input is greatly appreciated.

If you select the Pivot Table, and then under Pivot Table Tools (menu at the very top above Home/Insert/Page Layout/Formulas/etc...) - click "Change Data Source". My data source was 'EL Comp'!$A$1:$G$10000 - so I just bumped it up to 'EL Comp'!$A$1:$G$15000 which was enough for my needs.

Also if you have increased your RPMs to more than 14 values (I'm going from 800rpm to 3200rpm which is what my ROM's table is) - you'll need to change the Data source for the chart as well. To do this, clic on the chart (the one on "EL Comp") and under "Chart Tools" click "Select Data". Then click "Edit" under the "Legend Entries" and change the two fields that look like ='EL Comp'!$J$4:$J$14 to something like ='EL Comp'!$J$4:$J$16 (that was all I needed to do).

Big thanks to Airboy for this Spreadsheet... would have been a lot of work!!!

Kim · **Joined:** Wed Jun 06, 2012 10:11 pm **Posts:** 25

Question about the vs MAFv and vsRPM worksheets...

Is there a way to display the average fuel correction for each MAFv amount? (this could be useful tweaking the MAF scaling). At the moment I'm using RomRaider to do this. Or even if we could paste in our current MAF scaling table, and the spreadsheet could calculate a more ideal MAF scale based on the MAFv fuel trims...

I know there are other speadsheets that do this, but I've not had much success getting those to work...

RomRaider

Forum rules

Spreadsheet to generate fuel trim pivot table (RPM v. MRP)

Who is online