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.

Can you explain what exactly I would do to calculate my ve table using your spreadsheet? thanks!

Well one, all you need is to add MAP, IAT, MAF, and RPM, and it calculates your VE at the specific point in your log. The spreadsheet then converts all the inputs to the proper measurement to use in NoGo's equation, and comes up with the Edit VE. Then the edit VE is converted to HPTuner VE.

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.

thanks for sharing

How is the edit ve converted to tuners ve. The formula used by noGo should allready be in Tuner's format 0-100% IIRC.

Nope. It comes out in Edit. As far as I could make sense of anyways.

[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

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

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.

Be careful about using that formula for low rpms because the maf is not accurate at low massflows. My maf read 4 g/s with the engine off.