Mat's VE Tools (Spreadsheets Inside!)
Thread Starter
TECH Addict
Joined: Feb 2004
Posts: 2,826
Likes: 0
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.
Thread Starter
TECH Addict
Joined: Feb 2004
Posts: 2,826
Likes: 0
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.
[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
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
LS1 Tech Stories
The Best V8 Stories One Small Block at Time
6 Common C5 Corvette Failures and What's Involved In Repairing Them
Pouria Savadkouei
Retro Modern Bandit Pontiac Trans AM Comes With Burt Reynolds' Autograph
Verdad Gallardo
Top 10 Greatest Cadillac V Series Performance Models Ever, Ranked
Pouria Savadkouei
Top 10 Most Powerful Chevy Trucks Ever Made!
Hennessey's New Supercharged Silverado ZR2 Has 700 HP
Verdad Gallardo
Coachbuilt N2A Anteros Is an LS2-Powered C6 Corvette In Italian Clothes
Verdad Gallardo
Awesome K5 Blazer Restomod Comes With C7 Corvette Power
Verdad Gallardo
10 Camaros You Should Never Buy
10 LS Engine Myths That Refuse to Die
Verdad Gallardo Thread Starter
TECH Addict
Joined: Feb 2004
Posts: 2,826
Likes: 0
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.
