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.

luv2spd

iTrader: (1)

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

Another_User

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.

ataylors

iTrader: (2)

thanks for sharing

HumpinSS

iTrader: (1)

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

Another_User

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

ESR

iTrader: (7)

[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

HumpinSS

iTrader: (1)

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

Another_User

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.

P Mack

iTrader: (6)

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.