Notices
ECU Flash

2d KPA->Load and RPMVE in Excel

Thread Tools
 
Search this Thread
 
Old Jan 3, 2015 | 07:02 PM
  #1  
jeffbeagley's Avatar
Thread Starter
Evolving Member
 
Joined: May 2011
Posts: 363
Likes: 3
From: Springfield, MO
2d KPA->Load and RPMVE in Excel

EDIT:
Updated one here
http://jeffbeagley.com/random/VE%20Calculator%202.xlsx

Would be nice to have it interpolated to a large graph.. but thinking about it I do not believe its truly necessary. This should provide a great starting point for you to setup your SD tables.
I gave it my best shot..

http://jeffbeagley.com/random/VE%20Calculator.xlsx

Is someone on here willing to help me finish this? Would be nice if we could scale the rpm and kpa values appropriately and it work correctly for anyone.




Last edited by jeffbeagley; Jan 3, 2015 at 11:06 PM.
Old Jan 3, 2015 | 07:14 PM
  #2  
05VIII's Avatar
Evolved Member
iTrader: (17)
 
Joined: Jun 2005
Posts: 862
Likes: 1
From: Dallas
subscribed

new to tuning and have been tuning my 2.4 6262 on sd from scratch.
still learning so i dont know much but if this will help dial in the sd tables im in.
Old Jan 3, 2015 | 08:28 PM
  #3  
jeffbeagley's Avatar
Thread Starter
Evolving Member
 
Joined: May 2011
Posts: 363
Likes: 3
From: Springfield, MO
I did just make this real quick without using any Interpolating.

This makes my SD Tables look AWFUL lol! Looks like I'll be going for a drive now.

Old Jan 3, 2015 | 11:05 PM
  #4  
jeffbeagley's Avatar
Thread Starter
Evolving Member
 
Joined: May 2011
Posts: 363
Likes: 3
From: Springfield, MO
Updated one here
http://jeffbeagley.com/random/VE%20Calculator%202.xlsx

Would be nice to have it interpolated to a large graph.. but thinking about it I do not believe its truly necessary. This should provide a great starting point for you to setup your SD tables.
Old Jan 5, 2015 | 05:56 PM
  #5  
03whitegsr's Avatar
Evolved Member
iTrader: (8)
 
Joined: Nov 2006
Posts: 4,001
Likes: 15
From: Utah
I built up a spread sheet that does all the interpolation and deals with the axis conversion. The limitation is that the new axis fall within the bounds of the 2d axis. Catching those out of range values is a decent amount more work. It needs some clean up to be more user friendly.

Had to use the help function to remember how to do array lookups...

Shoot me a pm and I can send it over for comparison.
Old Jan 6, 2015 | 01:58 PM
  #6  
wreckleford's Avatar
Evolved Member
iTrader: (2)
 
Joined: Jun 2003
Posts: 1,171
Likes: 11
From: Jamaica
I thought this would give you the 2d table values when you input values in the 3d table obtained from logging.
Old Jan 6, 2015 | 07:26 PM
  #7  
jeffbeagley's Avatar
Thread Starter
Evolving Member
 
Joined: May 2011
Posts: 363
Likes: 3
From: Springfield, MO
It's more for folks who are tuning Speed Density from scratch... And to see what their current setup is doing. I only found out last week that RPMVE helped calculate Final VE.

Hopefully this helps folks visualize a little better.
Old Jan 9, 2015 | 05:33 AM
  #8  
wreckleford's Avatar
Evolved Member
iTrader: (2)
 
Joined: Jun 2003
Posts: 1,171
Likes: 11
From: Jamaica
This thread got me thinking and I have decided to try to create a spreadsheet that would give you the (2) 2d tables from a 3d table. To test it out I would need some logs that include rpm, load and map from some maf sensor equipped cars. I can dig some up but if anyone can send me some it would help too. You can email to mhay.cac(at)gmail.com.

Last edited by wreckleford; Jan 13, 2015 at 05:20 PM.
Old Jan 12, 2015 | 09:35 AM
  #9  
03whitegsr's Avatar
Evolved Member
iTrader: (8)
 
Joined: Nov 2006
Posts: 4,001
Likes: 15
From: Utah
Going 3D to 2D won't work.

That's the entire point of 3D mapping... You get resolution that you can never get with 2D tables.

Why would you want to go today direction anyway?
Old Jan 13, 2015 | 05:19 PM
  #10  
wreckleford's Avatar
Evolved Member
iTrader: (2)
 
Joined: Jun 2003
Posts: 1,171
Likes: 11
From: Jamaica
Originally Posted by 03whitegsr
Going 3D to 2D won't work.

That's the entire point of 3D mapping... You get resolution that you can never get with 2D tables.

Why would you want to go today direction anyway?
Obviously 3D is better but not everyone is running the 3D SD because some of the ROMS don't seem to work properly. Currently the two 2D tables are adjusted by what amounts to basically trial and error to approximate a 3D table. So if a spreadsheet could spit out two 2D tables that are a close approximation to logged values in a 3D table I think it would save a lot of tuning time.
Old Jan 15, 2015 | 07:38 PM
  #11  
jeffbeagley's Avatar
Thread Starter
Evolving Member
 
Joined: May 2011
Posts: 363
Likes: 3
From: Springfield, MO
This should be kept in mind when playing with these tables.

Originally Posted by JohnBradley
Nice stuff, to the point and I cant see anything left out. It should be pointed out that as we play with the MAPVE and RPMVE the load will change for a given boost level. This can be used to play with the resolution if not on a V7 map.

i.e.- 29psi can be 300 load (depending on how long you take to play with it) to correlate to Kpa

29psi can also be 235 load and have a somewhat funky looking fuel map
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
evilution8
Evo Engine / Turbo / Drivetrain
5
Apr 12, 2004 02:27 AM
BenM
Evo General
20
Feb 19, 2004 08:34 AM
evo8power
Evo Engine / Turbo / Drivetrain
1
Feb 9, 2004 07:30 PM
Shahul X
Evo Engine / Turbo / Drivetrain
6
May 13, 2003 06:55 PM



Quick Reply: 2d KPA->Load and RPMVE in Excel



All times are GMT -7. The time now is 07:50 PM.