GalantVR4.org The Mitsubishi Galant VR-4 Forum
Galant VR-4 Forums » Galant VR-4 » Technical Discussions » ECMLink global fuel VE adjustment excel workbook
Previous thread Next thread

ECMLink global fuel VE adjustment excel workbook


EfiniX
Member ++
543/1000


Galant VR-4 org Post #: 1219421 posted 10/29/15 10:36 PM     Remind Me!  Send Private Message   Edit Post      
I posted a message about an excel workbook I put together to calculate VE cell changes based on adjustments made to global fuel values. There's been a decent amount of interest. I can't upload the workbook here, but if you send me a PM with your email address, I'll send you the workbook. Basically you copy your VE table and paste it into the first tab of the workbook, put in your current and planned global fuel value in the second tab, then copy the values out of the formula into the 3rd tab. Works quite well.



RIP 543
Ded click
2006 Suzuki SV-650 (for sale)
2011 BMW 335d (~510'lb/tq and 36mpg. hwy. How can you go wrong?)

Posts: 647 | From: portland, or | Member Since: 10/18/12 | IP: (75.164.139.42) | Report this post to a Moderator

tektic
Senior Member


Galant VR-4 org Post #: 1219423 posted 10/30/15 04:53 AM     Remind Me!  Send Private Message   Edit Post      
You can also share it with Google drive, if you so choose.

Posts: 1499 | From: ronkonkoma, ny | Member Since: 12/19/12 | IP: (172.56.34.34) | Report this post to a Moderator

EfiniX
Member ++
543/1000


Galant VR-4 org Post #: 1219444 posted 10/30/15 10:25 AM     Remind Me!  Send Private Message   Edit Post      
If email proves unreliable, I certainly will.



RIP 543
Ded click
2006 Suzuki SV-650 (for sale)
2011 BMW 335d (~510'lb/tq and 36mpg. hwy. How can you go wrong?)

Posts: 647 | From: portland, or | Member Since: 10/18/12 | IP: (209.152.44.116) | Report this post to a Moderator

marvinmadman
Senior Member
136/1000


Galant VR-4 org Post #: 1219453 posted 10/30/15 11:39 AM     Remind Me!  Send Private Message   Edit Post      
Or Dropbox



1982/2000 sold
1263/2000 parts
136/1000 work n progress
08 ZX14
10 Ford Flex TT/AWD
05 Galant GTS

Posts: 2354 | From: Lafayette, Louisiana | Member Since: 11/10/03 | IP: (2600:100d:b10d:7) | Report this post to a Moderator

EfiniX
Member ++
543/1000


Galant VR-4 org Post #: 1219456 posted 10/30/15 12:12 PM     Remind Me!  Send Private Message   Edit Post      
Ok ok, I give!

click



RIP 543
Ded click
2006 Suzuki SV-650 (for sale)
2011 BMW 335d (~510'lb/tq and 36mpg. hwy. How can you go wrong?)

Posts: 647 | From: portland, or | Member Since: 10/18/12 | IP: (209.152.44.218) | Report this post to a Moderator

prove_it
my racist jokes aren't actually funny
715/1000
1284/2000


Galant VR-4 org Post #: 1219463 posted 10/30/15 01:15 PM     Remind Me!  Send Private Message   Edit Post      
Not sure I follow the benefit of doing this. Maybe you can explain a little more?

I'd love an easier way to take the WBfactor from a log and transfer it to the VE table and adjust all cells more simply than one at a time.



#1284/2K NB, Totaled
#715/1K KG, Rebuilding
02 Acura TL daily duty unit

12yr+ Vr4 owner.
Honda/Acura master tech.
Family Guy

Posts: 4201 | From: Sioux Falls, SD | Member Since: 07/04/08 | IP: (96.2.247.27) | Report this post to a Moderator

EfiniX
Member ++
543/1000


Galant VR-4 org Post #: 1219507 posted 10/30/15 09:04 PM     Remind Me!  Send Private Message   Edit Post      
I could absolutely write a formula for what you are describing.

What this workbook does is allow you to calculate VE cell values when making changes to global fuel. Basically you put in your starting global fuel value (let's say -55.5%) and your new global fuel value (for me, I was leaning out, so I went to -53.1%), copy in your current VE table, and it spits out a new VE table adjusted for the new global fuel value.

I'll build one for the WBFactor as well.



RIP 543
Ded click
2006 Suzuki SV-650 (for sale)
2011 BMW 335d (~510'lb/tq and 36mpg. hwy. How can you go wrong?)

Posts: 647 | From: portland, or | Member Since: 10/18/12 | IP: (75.164.139.42) | Report this post to a Moderator

swe_gvr4_1991
Member


Galant VR-4 org Post #: 1219520 posted 10/31/15 05:58 AM     Remind Me!  Send Private Message   Edit Post      
Wow. I always thought this functionality was already in Link...

Auto-calibration has been around for over a year in SwD. I guess it's time to shoot Tom a email and see if he can add it to Link.
The step to full on-road auto calibration is small. That was actually what I did first before making the integration of log based auto-cal into TunerPro.

Nevertheless good job on the Excel sheet. I'm sure many will benefit from it.

Posts: 177 | From: Sweden, Alingsås | Member Since: 07/27/06 | IP: (85.228.2.56) | Report this post to a Moderator

strokin4dr
fighting them with a large needle
1280/2000
1135/2000


Galant VR-4 org Post #: 1219526 posted 10/31/15 09:31 AM     Remind Me!  Send Private Message   Edit Post      
I really wish ecmlink would add an auto tune feature. I used it on megasquirt and it is great. Just drive the car an the VE table corrections are automatically applied. I love ecmlink but it takes forever to to get it set up optimally.
They are half way there with the closed-loop VE suggestions feature. It just leaves a lot to be desired.



1908- sold and missed.
1280- 2.3, FP 35R, E85, etc.
1135- 100% stock (sold)
'93 Mirage hatch- 4g63, AWD, etc (hoarding for build)

Posts: 2767 | From: Savannah, GA | Member Since: 08/30/05 | IP: (73.21.58.201) | Report this post to a Moderator

EfiniX
Member ++
543/1000


Galant VR-4 org Post #: 1219531 posted 10/31/15 10:09 AM     Remind Me!  Send Private Message   Edit Post      
Quoting swe_gvr4_1991:

Wow. I always thought this functionality was already in Link...

Auto-calibration has been around for over a year in SwD. I guess it's time to shoot Tom a email and see if he can add it to Link.
The step to full on-road auto calibration is small. That was actually what I did first before making the integration of log based auto-cal into TunerPro.

Nevertheless good job on the Excel sheet. I'm sure many will benefit from it.




Agreed. I would think it would be easy enough to add a feature that allows for automatic VE cell adjustment when changes are made to global fuel settings.



RIP 543
Ded click
2006 Suzuki SV-650 (for sale)
2011 BMW 335d (~510'lb/tq and 36mpg. hwy. How can you go wrong?)

Posts: 647 | From: portland, or | Member Since: 10/18/12 | IP: (209.152.44.218) | Report this post to a Moderator

swe_gvr4_1991
Member


Galant VR-4 org Post #: 1219539 posted 10/31/15 11:34 AM     Remind Me!  Send Private Message   Edit Post      
This is how I did the passive version of the auto-cal in TunerPro:
click



.. KiM H ..
Galant VR-4 1991. Gulf spec.
Author of Swede Density software - REAL speed density for 1G's and GVR4's - Videos

Posts: 177 | From: Sweden, Alingsås | Member Since: 07/27/06 | IP: (85.228.2.56) | Report this post to a Moderator

EfiniX
Member ++
543/1000


Galant VR-4 org Post #: 1219547 posted 10/31/15 12:55 PM     Remind Me!  Send Private Message   Edit Post      
Trick!



RIP 543
Ded click
2006 Suzuki SV-650 (for sale)
2011 BMW 335d (~510'lb/tq and 36mpg. hwy. How can you go wrong?)

Posts: 647 | From: portland, or | Member Since: 10/18/12 | IP: (209.152.44.218) | Report this post to a Moderator

prove_it
my racist jokes aren't actually funny
715/1000
1284/2000


Galant VR-4 org Post #: 1219615 posted 11/02/15 08:50 AM     Remind Me!  Send Private Message   Edit Post      
Link does support "auto" tune, well kinda. You need to have a MAF installed and there is a function to calculate VE cells based off of the MAF log.



#1284/2K NB, Totaled
#715/1K KG, Rebuilding
02 Acura TL daily duty unit

12yr+ Vr4 owner.
Honda/Acura master tech.
Family Guy

Posts: 4201 | From: Sioux Falls, SD | Member Since: 07/04/08 | IP: (96.2.247.27) | Report this post to a Moderator

swe_gvr4_1991
Member


Galant VR-4 org Post #: 1219655 posted 11/03/15 04:03 AM     Remind Me!  Send Private Message   Edit Post      
Yeah that's a nice feature.
Funny thing is that it's possible to do the same without a MAF, through code. Not on Link tho. That way you can avoid the MAF overrun issue. No official code though.



.. KiM H ..
Galant VR-4 1991. Gulf spec.
Author of Swede Density software - REAL speed density for 1G's and GVR4's - Videos

Posts: 177 | From: Sweden, Alingsås | Member Since: 07/27/06 | IP: (85.228.2.56) | Report this post to a Moderator

EfiniX
Member ++
543/1000


Galant VR-4 org Post #: 1219792 posted 11/05/15 06:53 PM     Remind Me!  Send Private Message   Edit Post      
Oh, and one other thought for anyone that might use this workbook: Don't forget to reset your fuel trims after making adjustments to global fuel values.



RIP 543
Ded click
2006 Suzuki SV-650 (for sale)
2011 BMW 335d (~510'lb/tq and 36mpg. hwy. How can you go wrong?)

Posts: 647 | From: portland, or | Member Since: 10/18/12 | IP: (209.152.44.220) | Report this post to a Moderator

GSXftw
Member
1722/2000


Galant VR-4 org Post #: 1221098 posted 11/30/15 04:11 AM     Remind Me!  Send Private Message   Edit Post      
i believe this has been done, theres a sweet add on called link tools. the tutorial shows all it can do, but the global adjust is what i use it for
click,d.dmo&cad=rja



1722/2000- Burn victim rescue
91 GSX- 11.66 @ 126 donated to save ^
97 TSI AWD - daily
97 GST- 14.7 @ 100 *sold*
82 Supra 7mgte- 12.66 @ 116
77 Camaro- 12.9 @ 107


Edited by GSXftw (11/30/15 04:14 AM)

Posts: 112 | From: medford, OR | Member Since: 12/22/14 | IP: (71.84.139.226) | Report this post to a Moderator

prove_it
my racist jokes aren't actually funny
715/1000
1284/2000


Galant VR-4 org Post #: 1221110 posted 11/30/15 12:37 PM     Remind Me!  Send Private Message   Edit Post      
Last time I looked (6 months ago) Link tools was no longer available to the mass dsm crowd. If you knew the author then you might get a copy.



#1284/2K NB, Totaled
#715/1K KG, Rebuilding
02 Acura TL daily duty unit

12yr+ Vr4 owner.
Honda/Acura master tech.
Family Guy

Posts: 4201 | From: Sioux Falls, SD | Member Since: 07/04/08 | IP: (96.2.247.26) | Report this post to a Moderator

EfiniX
Member ++
543/1000


Galant VR-4 org Post #: 1221112 posted 11/30/15 01:35 PM     Remind Me!  Send Private Message   Edit Post      
I've been told if you ask Calan nicely, you might get a copy. But yes, unsupported and unavailable is the official position.



RIP 543
Ded click
2006 Suzuki SV-650 (for sale)
2011 BMW 335d (~510'lb/tq and 36mpg. hwy. How can you go wrong?)

Posts: 647 | From: portland, or | Member Since: 10/18/12 | IP: (209.152.44.218) | Report this post to a Moderator

GSXftw
Member
1722/2000


Galant VR-4 org Post #: 1221995 posted 12/22/15 02:57 AM     Remind Me!  Send Private Message   Edit Post      
Yeah I got a copy back in the day, and office 2003 solely for using it



1722/2000- Burn victim rescue
91 GSX- 11.66 @ 126 donated to save ^
97 TSI AWD - daily
97 GST- 14.7 @ 100 *sold*
82 Supra 7mgte- 12.66 @ 116
77 Camaro- 12.9 @ 107

Posts: 112 | From: medford, OR | Member Since: 12/22/14 | IP: (71.84.139.226) | Report this post to a Moderator

GSTwithPSI
A hole
820/1000
1837/2000



Galant VR-4 org Post #: 1233570 posted 11/18/16 11:34 AM     Remind Me!  Send Private Message   Edit Post   
Does anybody have the equation to kinda do this in reverse?

Here's the deal, I did a 3rd gear pull, and am lean in some cells. The if I take the WB adjustment factor, and crunch the math to get the fuel needed to get my AFRs to line up, the VE in some of the cells is nearly 120%, meaning I need to make a global fuel adjustment.

So, my question is, what's the equation to take a VE value (in my case ~120%) and translate that to the required global fuel adjustment to richen things up across the board (via global fuel) and bring my VE back down to 100%?

I know most people guess and check, but there's got to be a smart way to do this on paper rather than doing a thousand fucking 3rd gear pulls, pissing off the locals.

Posts: 3436 | From: SoCal | Member Since: 01/02/12 | IP: (24.145.93.250) | Report this post to a Moderator


Pages: 1
Previous thread Next thread

Extra information
0 registered and 23 anonymous users are browsing this forum.

Galant VR4.org Moderator:  curtis, steve, atc250r, jcgalntvr4-244, cheekychimp, jepherz, Rausch, toybreaker, iceman69510, pot, FlyingEagle 

Print Thread

Forum Permissions
      You cannot start new topics
      You cannot reply to topics
      HTML is disabled
      UBBCode is enabled

Rating:
Thread views: 4445

Rate this thread


News & Events: News | Events
Galant VR-4: Newbies | General VR4 Discussions | Technical Discussions | How To and Info Archive
Marketplace: Parts For Sale | Cars For Sale | Good Guys | Bad Guys
Community: Members' Showcase

Contact Us | Privacy statement GalantVR-4.org

Generated in 0.073 seconds in which 0.048 seconds were spent on a total of 14 queries. Turbo powered.


Hertz's Galant VR-4 Page