Here is a VE calculator I have been using to fine tune, see what you all think, I'd appreciatte some feedback. It's worked for me, and while I'm not an excel genius, the table has done wonders for my VE table.
http://www.tditechnology.com/VE-Calculator.xls

 

Looks good!

 

I'll give it a shot and let you know.

edit:
now that I've downloaded it, it looks very similar to the spread sheet I used a while back. Nice work! your's is much more a finished product than mine

 

looks nice... similar to something i started to make and never got around to finishing... good job.



now i just have to get excel on the tuning laptops.. lol

 

I like it. I was manually doing it, this will help. Thanks!

 

try these two, they're useful too:
http://www.savefile.com/filehost/pro...php?pid=447277

 

Cool, let me know how this works out for you guys.

 

The spreadsheets are great, We should collect them all at one place.

 

They did that on HP tuners, I would think there are even more here, since there are more people here. What about it Horist? You could even put them on your site.

 

me and pimpmaro are putting together a tuning wiki, so in the end it will be a major knowledge base of all things tuning, whether it's howtos or files or configs, or dynos, etc... coming soon, to a website near you

 

My spreadsheet isn't perfect, but you are more than welcome to use it if you like.

 

Quick question on some of your formulas on the worksheet. I'm brand new to tuning so there's a good chance I'm looking at this incorrectly.

1. On the Calculation Sheet: The formula you're using is LTFT - STFT / 2 to get the %
change on the VE Table. Don't you want LTFT + STFT / 2 ?

2. On the New VE Table Sheet: The formula you're using is Current VE Value - Calculation Sheet Value. Again, don't you want Current VE Value + Calculation Sheet Value?

The problem I've noticed is if you have negative fuel trims. Let me show an example:
Say you have a LTFT value of -10, a STFT value of -5, and a Current VE of 50

Calculation Sheet: LTFT - STFT = % VE Change, (-10) - (-5) = -5
New VE Table Sheet: Current VE - Calc Sheet Value = New VE, (50) - (-5) = 55

The problem I see is that if the car is pulling fuel you want to lower the VE and these calulations end up raising it.

Same values using the 2nd formulas:
Calculation Sheet: LTFT + STFT = % VE Change, (-10) + (-5) = -15
New VE Table Sheet: Current VE + Calc Sheet Value = New VE, (50) + (-15) = 35

Obviously I just pulled these values out of the air, but the calculations are valid (I think). Sorry this is hard to follow, but let me know if I'm on the right track or totally wrong. Thanks!

 

Here's a copy of 99FormulaWS6's spreadsheet with the formulas adjusted how I'm thinking they might need to be. Let me know what you guys think. He really did a great job on this spreadsheet. Makes things much simpler.

 

Will it work for LS1edit? I have gotten lots of tuning info from the guys here on the board but I can't seem to find the same things in edit.

 

Lowell, I'm not sure why it would or wouldn't work i'll have to try your copy, and see what it does. Mine worked for me, so OrangeWs6 it won't work in Edit, because you need a Data logger with the histogram function.

 

Lowell...see if this makes sense. Lowering the VE tables, will lean out the car in that area. Its telling the PCM there is less air there, so there will be less fuel introduced. So in your example if your at a (-) LTFT, then you go from 50 to 55 in the VE you should come less (-) or closer to 0 from your previous reading, which is the goal, or slightly negative. Does this answer your question or help you in anyway? I hope so, cause now I am confused

 

I was under the impression if you have a negative LTFT lowering the VE table is the direction you want to go. Incorrect?

 

if you have a negative trim, you want to lower the respective cell in the VE table.

 

Will this spreedsheet also work on a 98 C5? I am in the process on tuning the STFT first, is that the right way to do it? I was told by doing the STFT first, the LTFT should fall in line?

Thanks,
Jason

 

Blown, Your STFT's with time will zero out, reset your Fuel trims and watch your STFTs in your histogram they will gradually fall. Get your STFT's within +(-)5 then use the sheet, and yes it will work for your car.