RomRaider

Open Source ECU Tools
 FAQ •  Register •  Login 

RomRaider

Documentation

Community

Developers

It is currently Tue Sep 30, 2014 7:46 am

All times are UTC - 5 hours [ DST ]





Post new topic Reply to topic  [ 33 posts ]  Go to page 1, 2, 3  Next
Author Message
 Post subject: SPREADSHEET: OL / CL MAF Scaling Tools
PostPosted: Sat May 30, 2009 11:12 pm 
Offline
RomRaider Donator

Joined: Thu Jan 29, 2009 11:16 am
Posts: 458
These are two spreadsheets I use to help me scale my MAF. The original was created by Bad Noodle and posted on NASIOC. I've modified his OL MAF tool to better suit my needs (small formula change) and also created a version to help with CL MAF scaling.

The OL MAF Tool uses the AFR correction data from airboy's "Log file interpretation" spreadsheet and the CL MAF Tool uses AFR correction data from mickeyd2005's "Closed Loop MAF Table and Injectors" spreadsheet.

edit: permission was given by Bad Noodle to post these. Original NASIOC post http://forums.nasioc.com/forums/showthread.php?t=1714223

SEE POST BELOW (#7) FOR AN UPDATED OL MAF TOOL FROM BAD NOODLE!!!


Attachments:
CLMAFTool_v1.xls [66.5 KiB]
Downloaded 1679 times
OLMAFTool_v1.xls [77.5 KiB]
Downloaded 1561 times

_________________
Mods: http://www.romraider.com/forum/viewtopic.php?f=7&t=6789&start=5


Last edited by bcheck555 on Sat Dec 12, 2009 11:11 am, edited 2 times in total.
Top
 Profile  
 
 Post subject: Re: OL / CL MAF Scaling Tools
PostPosted: Sun May 31, 2009 3:46 am 
Offline
Experienced

Joined: Sun Mar 08, 2009 4:48 am
Posts: 265
excellent tool, great in combination with mickeyd2005 spreedsheet! I do have a question as i am not an excel wizz, how do i make the tool read up to 5V maf and scale, as i see 4.8v quite often and the tool only goes to 4.69v

cheers phil


Top
 Profile  
 
 Post subject: Re: OL / CL MAF Scaling Tools
PostPosted: Fri Nov 06, 2009 11:18 pm 
Offline
Newbie

Joined: Tue Apr 28, 2009 10:08 pm
Posts: 6
ptharris wrote:
excellent tool, great in combination with mickeyd2005 spreedsheet! I do have a question as i am not an excel wizz, how do i make the tool read up to 5V maf and scale, as i see 4.8v quite often and the tool only goes to 4.69v

cheers phil

I ran into this as well. Its an easy fix though.

Open the spreadsheet click tools> Macros> Macros
From there click on Afr_Mults and then click Edit
A new window should open showing VB commands
Go down to line 46 and look for the command "For i = 1 To 48" (the quotations are not part of the command!!!!!)
Change the 48 to 54, so it should look like "For i = 1 To 54"
Do the same on line 90 on the command "For j = 1 To 48"

This will make it calculate all the way across the Maf scaling.

Modify the spreadsheet at your own risk, i take no responsibility. This modification was not approved by the OP or by bad noodle


Top
 Profile  
 
 Post subject: Re: SPREADSHEET: OL / CL MAF Scaling Tools
PostPosted: Wed Nov 11, 2009 1:08 pm 
Offline
Newbie

Joined: Sat Mar 08, 2008 10:06 pm
Posts: 7
Has anyone had problems pasting the scaling into the maf table in romraider, its not letting me do it.


Top
 Profile  
 
 Post subject: Re: SPREADSHEET: OL / CL MAF Scaling Tools
PostPosted: Wed Nov 11, 2009 3:48 pm 
Offline
Newbie

Joined: Sun May 11, 2008 11:02 pm
Posts: 33
Make sure your user level is set to "highest" or "debug"


Top
 Profile  
 
 Post subject: Re: SPREADSHEET: OL / CL MAF Scaling Tools
PostPosted: Sat Nov 21, 2009 4:45 pm 
Offline
Newbie

Joined: Sat Mar 08, 2008 10:06 pm
Posts: 7
User level was and is always on debug... what an annoying problem.


Top
 Profile  
 
 Post subject: Re: SPREADSHEET: OL / CL MAF Scaling Tools
PostPosted: Sat Nov 21, 2009 5:49 pm 
Offline
RomRaider Donator

Joined: Wed Aug 02, 2006 9:40 pm
Posts: 1035
Location: Calgary
project_skyline wrote:
Has anyone had problems pasting the scaling into the maf table in romraider, its not letting me do it.

To copy/paste back into Romraider, the MAF table header has to be offset by 1 cell and have [Table2D] added, like this:
Image


Top
 Profile  
 
 Post subject: Re: SPREADSHEET: OL / CL MAF Scaling Tools
PostPosted: Thu Dec 03, 2009 8:49 am 
Offline
Experienced

Joined: Mon Mar 24, 2008 5:54 pm
Posts: 111
I've been working with OL scaling V1 and found it lacking in some aspects so I wrote V2.

The major advantage is that is that is lets you smooth the maf curve manually. In my case, I like the results much better and find the worksheet much more useful.


Attachments:
OL Maf Scaling V2.xls [121.5 KiB]
Downloaded 672 times
Top
 Profile  
 
 Post subject: Re: SPREADSHEET: OL / CL MAF Scaling Tools
PostPosted: Sun Dec 06, 2009 7:37 pm 
Offline
Experienced

Joined: Mon Mar 24, 2008 5:54 pm
Posts: 111
Another update: version 2.1

I included better smoothing functions as well as a curve moving tool. It's been really helpful. Much more so than the other ones


Attachments:
OL Maf Tool 2.1.xls [135.5 KiB]
Downloaded 725 times
Top
 Profile  
 
 Post subject: Re: SPREADSHEET: OL / CL MAF Scaling Tools
PostPosted: Sun Dec 06, 2009 8:10 pm 
Offline
RomRaider Donator
User avatar

Joined: Wed Feb 06, 2008 3:49 am
Posts: 1054
Location: Australia
Badnoodle, can you make another change to the OL MAF spreadsheet so that the "Data" tab has more "Run" columns - 9 would be great :p

I find 3 doesn't offer enough resolution (especially if you are limited to lower gear logs), and as such you need to do 3 runs, flash the changes, do another 3 runs, flash the changes and so on - whereas 9 runs will cut this down substantially.

Obviously it won't be useful for those who are just starting to tune OL MAF, but for those who have it at <3% and are trying to fine tune OL MAF to get it to <1%, the ability to use more "Run" data will be very beneficial.

If you can do this, it would be greatly appreciated.

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: OL / CL MAF Scaling Tools
PostPosted: Mon Dec 07, 2009 1:08 am 
Offline
RomRaider Donator

Joined: Thu Jan 29, 2009 11:16 am
Posts: 458
wrxsti-l wrote:
Badnoodle, can you make another change to the OL MAF spreadsheet so that the "Data" tab has more "Run" columns - 9 would be great :p

I find 3 doesn't offer enough resolution (especially if you are limited to lower gear logs), and as such you need to do 3 runs, flash the changes, do another 3 runs, flash the changes and so on - whereas 9 runs will cut this down substantially.

Obviously it won't be useful for those who are just starting to tune OL MAF, but for those who have it at <3% and are trying to fine tune OL MAF to get it to <1%, the ability to use more "Run" data will be very beneficial.

If you can do this, it would be greatly appreciated.

Leslie


You give up on the Grp N ROM Leslie?

_________________
Mods: http://www.romraider.com/forum/viewtopic.php?f=7&t=6789&start=5


Top
 Profile  
 
 Post subject: Re: SPREADSHEET: OL / CL MAF Scaling Tools
PostPosted: Mon Dec 07, 2009 8:27 am 
Offline
Experienced

Joined: Mon Mar 24, 2008 5:54 pm
Posts: 111
wrxsti-l wrote:
Badnoodle, can you make another change to the OL MAF spreadsheet so that the "Data" tab has more "Run" columns - 9 would be great :p

I find 3 doesn't offer enough resolution (especially if you are limited to lower gear logs), and as such you need to do 3 runs, flash the changes, do another 3 runs, flash the changes and so on - whereas 9 runs will cut this down substantially.

Obviously it won't be useful for those who are just starting to tune OL MAF, but for those who have it at <3% and are trying to fine tune OL MAF to get it to <1%, the ability to use more "Run" data will be very beneficial.

If you can do this, it would be greatly appreciated.

Leslie


Sure can, while I work on that you can just tack on the extra runs to the bottom of your first 3 runs. Just take out the headers and extra spaces so it's one continuous data stream.

so it would look like:
run 1 run 2 run 3
1 2 3
4 5 6

then when you add extra data from runs 7, 8, 9 it would look like:
run 1 run 2 run 3
1 2 3
4 5 6
7 8 9
10 11 12


I agree that the more data you have the better the scaling ends up.


Top
 Profile  
 
 Post subject: Re: SPREADSHEET: OL / CL MAF Scaling Tools
PostPosted: Tue Dec 08, 2009 1:20 am 
Offline
RomRaider Donator
User avatar

Joined: Wed Feb 06, 2008 3:49 am
Posts: 1054
Location: Australia
bcheck555 wrote:
You give up on the Grp N ROM Leslie?

I had a few weird problems I couldn't correct which I think are related to IAT, so switched back to my last stable MAF tune until I get a separate IAT sensor mounted in my inlet manifold.

Bad Noodle wrote:
Sure can, while I work on that you can just tack on the extra runs to the bottom of your first 3 runs. Just take out the headers and extra spaces so it's one continuous data stream.

cool beans mate - tbh I didn't even think of just adding the data at the end of the first runs.

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: OL / CL MAF Scaling Tools
PostPosted: Tue Dec 08, 2009 2:03 pm 
Offline
RomRaider Donator

Joined: Thu Jan 29, 2009 11:16 am
Posts: 458
wrxsti-l wrote:
bcheck555 wrote:
You give up on the Grp N ROM Leslie?

I had a few weird problems I couldn't correct which I think are related to IAT, so switched back to my last stable MAF tune until I get a separate IAT sensor mounted in my inlet manifold.

Leslie


Gotcha, tapping my manifold tonight and putting her back together, been sitting in the driveway for about 2 months now...

_________________
Mods: http://www.romraider.com/forum/viewtopic.php?f=7&t=6789&start=5


Top
 Profile  
 
 Post subject: Re: SPREADSHEET: OL / CL MAF Scaling Tools
PostPosted: Tue Dec 08, 2009 8:31 pm 
Offline
RomRaider Donator
User avatar

Joined: Wed Feb 06, 2008 3:49 am
Posts: 1054
Location: Australia
cool beans - did you end up using the grp n temp sensor or one from another model?

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  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 33 posts ]  Go to page 1, 2, 3  Next

All times are UTC - 5 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


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