I want to hear how everyone else uses Excel to filter or sort through their data?

I am trying to figure out how to display for example

1200 RPMs and all the data that comes with it, BLM, Speed etc..

So what I want is to be able to sort the data out into 4 columns with KPA, BLM, RPM ,Knock counts.

I am sure someone out there has a better way, so how do you do it??

Michael

 

When I'm tuning the VE table, I do a sort by:

1.) RPM
2.) KPA
3.) BLM

Since the VE table is organized by RPM vs. KPA coordinates, this puts everything together in nice neat bundles.

 

Kevinc,

That is exactly what I wanted to do just tried it out and this is going to make it much easier to tune the VE table.

Thanks,
Michael

 

When trying to tune my VE tables, what increments should I use on RPM and Kpa? Should I split the difference between the table values for RPM and Kpa or just use the exact table value? In other words, when I sort RPM's should I only use the table values(400,600,800,1000,1200.....) or, for example, when I tune for the 800RPM data, should I use from700 to 900 RPM? Same question for Kpa's, do I use only the table values or use a range between the given table values?

Thanks for any input!

Tedd
Tedd319@swbell.net

 

What I have read and heard is to try KPA and RPM values as close as possible to the table.

If you are tunning say the 1000RPM and 40KPA values

Then sorting data from 975 to 1025 is good.

With KPA using values between 39 and 41 is okay too.

 

You may want to try my VEPhD program. It's not real intuitive, but it's open-sourced (of course), and it lets you compile your BLM data or whatever pretty efficiently and reduce a massive dataset into something that can just about be pasted into TunerCat...

Well, that's if you can figure it out... www.moates.net

 

If you are using the $8D, Tuner Cat & Data master you can use the VE Master program & have it do it all for you.

BW

http://home.attbi.com/~jgeorger/vemaster/

 

Thanks Bobalos

Actually I,m using $OD with tunercat and datamaster( '95 4WD Suburban ) but from what I have gathered the $OD and $8D are the closest systems as far as F-body efi systems go. One main difference in my case is that I tune for max. torque and seldom see rpms above 3000 (shift point is 4200 rpm), cruising rpm range is 1800-2200. Do you think VE Master program will still work for me? I'm still pretty new to this tuning method, and have made quite a bit of progress, but I'm still a little new to all this. So far I have adjusted my injector constant to correct an overall lean condition and bumped up the timing table by adding a constanmt to the entire table. I still don't quite understand the relationship between adjusting the VE tables and timing, nor have I adjusted the PE down for upper VE table tuning. I've learned alot from this great discussion board, but still have alot to learn. Where do I get VE Master program?


Thanks again
Tedd

 

You can get the VE Master from the link that I put on my last post. I am guessing that it will not really work for your application. the reason is that he is taking the BLM values, MAP values & RPM values from the data stream & calculating if the VE value needs to be changed to get your BLM's to 128.

These values come from the ECM serially through the ALDL cable & then he has to "decode" or "extract" out of that what he is looking for. My bet is that the $8D is not the same as the $0D. this means that if you try to plug it into the VE Master that it will be using something like Purge canister, or TCC lockup or something bogus to make chagnes to your VE's. that obviously could be pretty bad.

There are a number of great resources that explain how this works (to some amount of detail). all the stickies @ the top of the DIY page have a lot of infomramation, if you have not read them I would suggest it. if you want another perspective, I have written something here http://www.r71camaro.homestead.com/T...fPromming.html I did it one friday night after a few R&C's, so it is not very polished, forgive the obvious roughness.

I have not approached Timing yet, in regards to serious thought & maybe some technical information. In short, you want to run the LEAST amount of timing that you need to get the BEST Volumetic Efficiency (when cruising, & BEST HP when WOT, there is a distinct difference). search on Grumpy & you will find a post that he did that shows results of some testing that he did with his GN & timing, It was pretty enlightening to me.

a few things you want to keep straight is the VE table & what it does, PE & What it does & Timing & how it affect both VE & PE. they (VE & PE) are both separate & connected, in as much as the VE table is where everything starts & PE is on top of that, & timing affects both in a similar method.

HTH's.
BW

 

Look at VEPhD.

It is designed for someone who wants to compile a *.csv file into nicely blocked BLM's grouped according to the VE/RPM tables. However, with just a LITTLE manipulation of the external parameter file, it can be made to do most anything in terms of data reduction and compilation...

It's really not that complicated...

 

Where do I find VEPhD? I did a search on this site and on a search engine and had no luck.

Tedd

 

Whoops, I see its on your site Craig


THANKS!
Tedd

 

Which site is the VEPhd program on? I looked at Moates.net Maybe I overlooked it.

 

Hmm, I looked for it on the site & couldn't find it. I put it up, look under the Software sub-page, it should be there now...

 

I'd like to use VE master, but I don't have tunercat.

I'm trying to figure out how to use the VEPHD program. I searched the DIY Prom site and found this post and that is it. If there is a link to instuctions for this don't waste your time answering my questions and I will gladly read it, just post the link for me.

Here's what I've done so far:
I use Craig's ECM852 to record data from the car. After getting the .csv file from the recording, I can use the Vephd.exe program to compile the data into tables.

When using the Vephd.exe program, what do I put in for the blmdamp and intdamp values? What does this mean?

After I get the file compiled correctly it should make a new "out" file. I should be able to paste this data and data from my current bin into VEPHD VE Calculator.xls. I'm not completly sure how to do that yet, but I'll cross that bridge when I come to it.

Austin

 

Hey Austin,

I have the same questions as you. After I export the data from Datamaster I'm not sure what to do. I've opened the Vephd.exe program and didn't know what values for blm amd int, i used 3 and 0 but that was just a guess. I've been busy lately but would like to learn this process, I'm about ready to start tuning my timing tables.

Tedd

 

If you look at the opening text of the program you will see what equation is being applied to correct the VE tables. It includes BLM, INT, and those damping factors for each. Essentially, if you want to weight the BLM more, put a value of zero for blmdamp. If you want to weaken the effect of the INT values on the VE table corrections, put a larger value in for the intdamp function. If you want to wipe out the INT influence altogether, plug in a large number like 100 or so.

Just take a look at that equation it gives you, and do some sample calculations to see what happens. If you use the default values, you'll probably be in pretty good shape, but you might want to raise the intdamp and go just with BLM corrections.

Also, take a close look at the 'vephddat.csv' file, and you'll see that you can customize this to almost anything. Also, you'll see the format that the exported file must have.

Hope this helps!

 

Thanks Craig

But I'm still having trouble geting any output

File not found in module VEPHD at address 0727:0D7C


????? I Guess I've had easy computers for to long. How do I open a csv file with VEPHD.exe? I've tried everything I can think of, it's been 20 years since I last saw a DOS screen

I have been tuning my VE tables using a max and min BLM of 128 and then calculating with S-term counts, will this arrangement work with VEPHD.exe? Or will I have to set BLM min and max values at 108/160, then do a data run, to use the application?

Thanks again for all the help, I,m very pleased with the moates adapter I got from you and I,m determined to get this motor tuned the way it should be done. Can you recommend any articles on how to calibrate my timing tables. I think I've about figured out how to tune my VE tables but I'm not quite sure where to start with the timing table process.

Have a happy NEW YEAR!!!!!



Tedd

 

I too have a Question. How do your copy the VE table from tunercat???
I tried the usual right click and cntl-c cntrl-V

Criag,
Just glancing anf the proggy it looks great. Like you mentioned. It seem we have to play around to fully see all the action.

Tedd,
Not sure what scan program you are using. But I think if you are using Diacom. You save your file as a DBF instead of the GDF. Excel will recognize this file now. Then you can save as a .CSV file.
I have not actually tried out the proggy fully yet. Just giving a thought.

Dennis

 

I,m using $OD with tunercat and datamaster( '95 4WD Suburban ) so I export a file from Datamaster as a .CSV and open the with TunerCat, modify, open with Pocket ProgrammerII, burn a prom and repeat.... I'd like to use VEPHD to assimilate the Datamaster file.

Tedd

 

Tedd, I think you have to use Craig's software to use the VEPHD program because it puts the data in a specific location/order/format so that the VEPHD program can compile it into tables. I don't think that it will work with anything else unless you mimic the moates file, which would take forever.

For those that are trying to get the the VEPHD program to work, here's what I did.

1. Aquired data from car using the Moates ECM852 software

2. Use VEPHD.exe to compile the data file. Make sure that the .csv file that you are looking at is in the same folder as VEPHD.exe. Make sure the "out" file name ends in .cvs and is no longer than 8 characters long. I used the default values for blmdamp and intdamp(0 and 3 if I remember correctly).

3. Open the new "out" file and and copy all the data from it and paste it into the the "VEPHDOUT template (paste here)" tab in the VEPHD calculator.xls.

4. The values from the current VE table from the bin needs to be placed into the "previous ve table" tab. I had to cut and paste the upper and lower data table from tunnercat into a spreadsheet and interpolate all the rows/columns that were missing because the they didn't match the format in the VEPHD calculator (I WAS able to cut and paste using ctrl c Dennis ). After doing that I had to divide each cell by 100 to get it as a percentage, then I was able to paste it into the previous ve table. This was the most time consuming item.


I attached my VEPHD file from my stock cam'd roc and wanted craig to take a look at it and maybe tell me what he sees from this(any mistakes etc, how do you use this to tune?). Anyone that is having trouble may be able to crib mine to get theres to work. I used the stock ARAP VE table from tunnercat after interpolating.

There appears to be a sharp ridge from 2400 to 5000 rpm in the "previous VE table" (which I assume is just the profile of the stock ARAP chip). I think this just "appears" sharp because the rpm scale in the VEPHD program changes to much larger gaps as the RPM's increase, but in actuality it is not. You'll understand what I am talking about if you open the file.

In the "updated VE table" the basic plot is the same as the "previous" but this one has more little peaks and valleys which must be where I need to make corrections. I think the points that are unchanged must be points that i don't have any vehicle data from. The "correction table" looks pretty scary. I think I need to get more data from different RPM/MAP points to use this program more effectively.

Craig, did I pretty much get all this right? Thanks for everything. Happy new year:rockon:

 

I'm going to try to post that file again. Hopefully it works this time.

 

Craig,

A related question. What do you do in terms of calculating the #2 Fuel Table? How do you consider its affect on the #1 Table? Does it have damping effects? When I have tried to play with it, the effect doesn't appear to be linear but rather is dependent on the rpm level. Comments or clarifications? Thanks

 

please disregard this reply

 

Did I say ARAP bin? I meant AUJP, not ARAP

 

I tried several times to get the VEPhd to compile my logged csv. file with no luck. I choose my looged csv. file as input. I make a name for the output file wth csv. extension and use default options after that. It goes through the motions and when I open my new output file it is all 128 or 0 or 1 in all the tables or something like that. There is no variation of data throughout the tables. I did notice I was using the ECM851 version instead of ECM852 to log with. Could that be the problem

 

I was following your step by step proceedure for the VEPhd but where it says to paste your current VE table from your bin into the "previous ve table" tab, I have a tab that says "Plot-previous ve table" I dont know how to enter my previous ve table data. Any Ideas?