Notices
ECU Flash

2d KPA->Load and RPMVE in Excel

Old Jan 3, 2015, 06:02 PM
  #1  
Evolving Member
Thread Starter
 
jeffbeagley's Avatar
 
Join Date: May 2011
Location: Springfield, MO
Posts: 363
Likes: 0
Received 3 Likes on 2 Posts
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 10:06 PM.
Old Jan 3, 2015, 06:14 PM
  #2  
Evolved Member
iTrader: (17)
 
05VIII's Avatar
 
Join Date: Jun 2005
Location: Dallas
Posts: 862
Likes: 0
Received 1 Like on 1 Post
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, 07:28 PM
  #3  
Evolving Member
Thread Starter
 
jeffbeagley's Avatar
 
Join Date: May 2011
Location: Springfield, MO
Posts: 363
Likes: 0
Received 3 Likes on 2 Posts
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, 10:05 PM
  #4  
Evolving Member
Thread Starter
 
jeffbeagley's Avatar
 
Join Date: May 2011
Location: Springfield, MO
Posts: 363
Likes: 0
Received 3 Likes on 2 Posts
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, 04:56 PM
  #5  
Evolved Member
iTrader: (8)
 
03whitegsr's Avatar
 
Join Date: Nov 2006
Location: Utah
Posts: 4,001
Received 14 Likes on 12 Posts
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, 12:58 PM
  #6  
Evolved Member
iTrader: (2)
 
wreckleford's Avatar
 
Join Date: Jun 2003
Location: Jamaica
Posts: 1,171
Received 11 Likes on 9 Posts
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, 06:26 PM
  #7  
Evolving Member
Thread Starter
 
jeffbeagley's Avatar
 
Join Date: May 2011
Location: Springfield, MO
Posts: 363
Likes: 0
Received 3 Likes on 2 Posts
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, 04:33 AM
  #8  
Evolved Member
iTrader: (2)
 
wreckleford's Avatar
 
Join Date: Jun 2003
Location: Jamaica
Posts: 1,171
Received 11 Likes on 9 Posts
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 04:20 PM.
Old Jan 12, 2015, 08:35 AM
  #9  
Evolved Member
iTrader: (8)
 
03whitegsr's Avatar
 
Join Date: Nov 2006
Location: Utah
Posts: 4,001
Received 14 Likes on 12 Posts
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, 04:19 PM
  #10  
Evolved Member
iTrader: (2)
 
wreckleford's Avatar
 
Join Date: Jun 2003
Location: Jamaica
Posts: 1,171
Received 11 Likes on 9 Posts
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, 06:38 PM
  #11  
Evolving Member
Thread Starter
 
jeffbeagley's Avatar
 
Join Date: May 2011
Location: Springfield, MO
Posts: 363
Likes: 0
Received 3 Likes on 2 Posts
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 01:27 AM
BenM
Evo General
20
Feb 19, 2004 07:34 AM
evo8power
Evo Engine / Turbo / Drivetrain
1
Feb 9, 2004 06:30 PM
Shahul X
Evo Engine / Turbo / Drivetrain
6
May 13, 2003 05:55 PM


Thread Tools
Search this Thread
Quick Reply: 2d KPA->Load and RPMVE in Excel



All times are GMT -7. The time now is 11:58 AM.