Would anyone out there who owns a MAP system car, be interested in a spreadsheet that calculates your VE tables for you?? I am currently making one, and this is how it works:

You drive around, for a good long time at crusing, idling, high way, up and down hills, etc.. Just so long as you stay out of PE mode. Gather as much data as you can. Then export the data to a csv file. Now open it up, and copy the RPM, MAP, Left BLM, and Right BLM columns, and paste them into my spreadsheet. A few seconds later (or minutes, depending on how much data you collected) you get two tables- 1 of the RPM vs MAP vs Average BLM from the data, and a second that has RPM vs. MAP vs. VE Correction Factor. Just multiply each correction factor by its corresponding VE value, and you should be able to zero in on a good VE table. It is currently very rough looking, but if you are interested, let me know!

-Mark

 

Some suggestions since I have done that before.

Don't just use average. The median functionm will also help out a lot--especially since cell blocks can jump rapidly and impede upon RPM boundaries.

Setting up a macro or three will keep file size down so it can be easily sent to others. My first shot at it that could use up to 3000 data points had a file size of 42 MB. Yeah, a bunch of floppys. Using macros, I was able to bring it down to about 300KB.

If you know how to use Visual Basic, the macros can do a lot more cool stuff.

Most importantly, each time you make a revision, make a lot of notes on it. I have about 6 different progs and I can't tell which copies are working copies and which ones are upgrades that have errors.

Also, graphing using the same style that your BIN editor uses will let you see the changes in Excel or another spreadsheet program and save you some time.

Most of all, keep it simple. I had a really good one but I let "feature creep" take over. You tend to lose track of your own program after a while! Like I started adding a duty cycle calculator. As soon as I did that, the Macro executed too many cell block statements and then she kept locking up on me :( So before you start off, find out the max rowXcolumns you can use in your spreadsheet program.

Edit-You don't even need to necessarily stay out of PE mode. What you do need to do though is have data validation so that only closed loop, learn-control enabled data is used. Good luck, -Matt-


[Modified by HighHopes85, 6:07 PM 9/5/2002]

 

Many programs in windows will support DDE , OLE, ODBC and others for retreiving data from other programs. Using some of the connectivity properties of the other programs, you could run a visual basic program and capture this data while driving and build a very large file with time stamps and other process data that could really be useful. This is the kind of stuff I do at work alot and to me its fun. Let me know if you may want to try charting an hour or so worth of driving.

 

I would definately be up for charting out an hour or so worth of driving.. I already have a 1/2 hour run from the other night.

-Mark