Mat's VE Tools (Spreadsheets Inside!)
#1
Mat's VE Tools (Spreadsheets Inside!)
I have attached two spreadsheets that I have made while I have been trying to calculate VE tables. They are pretty sweet. Let me know what you guys think. It includes VE conversions for HPTuners and Edit.
#3
Originally Posted by luv2spd
Can you explain what exactly I would do to calculate my ve table using your spreadsheet? thanks!
The other spreadsheet allows you to input your current VE table, view a 3d version of it, input your new VE table and see a 3d version of it, and then see the difference below. And beneath that you can see what the percent difference is. The reason I added that at the bottom is if you do not want to build a new table from scratch you can see what percent change is occuring in different areas of your VE table and just multiply areas of your VE table by the percent you come up with. I haven't decided if I will try that yet or not. If you have any more questions let me know.
#7
LS1TECH Sponsor
iTrader: (7)
Join Date: Jan 2002
Location: Houston, TX
Posts: 628
Likes: 0
Received 0 Likes
on
0 Posts
[QUOTE=Another_User]I have attached two spreadsheets that I have made while I have been trying to calculate VE tables. They are pretty sweet. Let me know what you guys think. It includes VE conversions for HPTuners and Edit.[/QUO
Nice thanks for the spreadsheet I was too lazy to do this.
Eric
Nice thanks for the spreadsheet I was too lazy to do this.
Eric
Trending Topics
#8
FormerVendor
iTrader: (1)
Join Date: Feb 2002
Location: Waldorf, MD
Posts: 3,059
Likes: 0
Received 0 Likes
on
0 Posts
Originally Posted by Another_User
Nope. It comes out in Edit. As far as I could make sense of anyways.
Which formula is that?
VE%=SAE.MAF.gps}*({SAE.IAT.C}+273.15)/(346*{SAE.RPM}*{SAE.MAP.kPa})*212544"
VEpcm={SAE.MAF.gps}*({SAE.IAT.C}+273.15)/(346*{SAE.RPM}*{SAE.MAP.kPa})*6155274.2"
EditVE=SAE.MAF.gps}*({SAE.IAT.C}+273.15)/(346*{SAE.RPM}*{SAE.MAP.kPa})*212544 *30
if it is the one that is multiplied by 30 at the end all you need to do is remove it and you will get 0-100 ve values. If it is the one multiplied by 6155274.2 then you need to use 212544 in place of it
#9
Formulas are:
VE=(MAF*IAT)/(MAP*RPM*Displacement)
MAF=grams/sec
IAT=Degrees Kelvin
MAP=Bar
RPM=(As NoGo put it... "Duh!")
This calculates VE in Edit Format. To convert to HPTuners:
HPTuners VE=(EDIT_VE*5.12)/178.33
These aren't my formulas, just the results of the VE sticky at the top. They appear to be completely accurate from what I have been seeing so far.
I am going to say this though (knowing it could start another VE discussion), I was looking at this book in the book store called "Auto Math Handbook", and there are some "official" calculations. I was too cheap to buy the book though...I bought one about modifying engine PCMs. They were saying something about:
VE=Theoretical VE/Physical VE
The Physical VE was the actual VE that you calculate based on displacement, and they had some way to measure theoretical VE based on airflow or something like that. For $20 I just wanetd a book that had more than 75 pages (it was probably more than that, but it was a really small book). I should have just bought it and tried it out.
VE=(MAF*IAT)/(MAP*RPM*Displacement)
MAF=grams/sec
IAT=Degrees Kelvin
MAP=Bar
RPM=(As NoGo put it... "Duh!")
This calculates VE in Edit Format. To convert to HPTuners:
HPTuners VE=(EDIT_VE*5.12)/178.33
These aren't my formulas, just the results of the VE sticky at the top. They appear to be completely accurate from what I have been seeing so far.
I am going to say this though (knowing it could start another VE discussion), I was looking at this book in the book store called "Auto Math Handbook", and there are some "official" calculations. I was too cheap to buy the book though...I bought one about modifying engine PCMs. They were saying something about:
VE=Theoretical VE/Physical VE
The Physical VE was the actual VE that you calculate based on displacement, and they had some way to measure theoretical VE based on airflow or something like that. For $20 I just wanetd a book that had more than 75 pages (it was probably more than that, but it was a really small book). I should have just bought it and tried it out.