99FormulaWs6

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

LS1PWR

iTrader: (2)

Looks good!

TAQuickness

iTrader: (28)

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

MrDude_1

iTrader: (4)

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

Viper

iTrader: (6)

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

RedHardSupra

iTrader: (1)

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

99FormulaWs6

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

Runn

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

99FormulaWs6

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.

RedHardSupra

iTrader: (1)

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

99FormulaWs6

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

LoWeLL216

iTrader: (1)

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!

LoWeLL216

iTrader: (1)

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.

1ORANGEWS6

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.

99FormulaWs6

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.

CAT3

iTrader: (9)

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

LoWeLL216

iTrader: (1)

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

TAQuickness

iTrader: (28)

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

Blown Interceptor

iTrader: (5)

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

99FormulaWs6

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.