part throttle VE tuning with WBo2

[dave w]

DaveW,
do you have excel doing the calculations/filtering for you or creating a piviot table like the tunerpro histogram? Mind sharing if you do? This is what I tried to do with mine but I am having a hard time figuring out how to put it in a format that coinsides with my VE tables. I can filter all the stuff I don't want to look at out, and tried create a pivot table but don't really know what to do from there. I have a spreadsheet that I copy my off idle ve table to and the tunerpro histogram and it will do the calulations for me but its not filtered. I would love to be able to export a log filter the data and then reimport it, but it doesn't look like TP supports that. do you know a way? I've attached the excel sheet I made to do my calculations. I saved it to 2003 format since the forum will not accept office 2007 file extensions, so hopefully all the formulas still work.

I posted some information in this thread, http://www.gearhead-efi.com/Fuel-Inj...-or-so../page4 about page 4 for sorting the excel file into cells like the VE table. The ROUNDING formulas are my method.

If you have questions, please ask.

dave w

[PJG1173]

that is what I've been searching for thanks!!

[PJG1173]

that was the missing piece I needed. now to automate it...
thanks again!

[dave w]

that was the missing piece I needed. now to automate it...
thanks again!

Nice work on the Excel Filter. Automate the "IF < > Kpa vs RPM = Average WBo2?

dave w

[PJG1173]

actually I was thinking of maybe using MS access so I could import the logs into a table and set up a query to make a cross tab that I could paste back into tunerpro.

[dave w]

actually I was thinking of maybe using MS access so I could import the logs into a table and set up a query to make a cross tab that I could paste back into tunerpro.

I had not thought about trying MS Access. Basically I was thinking of automating the MS Excel steps show in the screen shot below. The pic below is for NB BLM, but the same process applies for WBo2 as well.

dave w

[PJG1173]

I think I amost have this working in MS Access. the round function works similar to excel. with access you don't have copy paste the formula around. so far I have a query that runs the round function against a table linked to the tunerpro export that feeds a cross tab query. the cross tab outputs a table in the same format as the ve table. I'll post a copy of it when I get more of it done.

[dave w]

I think I amost have this working in MS Access. the round function works similar to excel. with access you don't have copy paste the formula around. so far I have a query that runs the round function against a table linked to the tunerpro export that feeds a cross tab query. the cross tab outputs a table in the same format as the ve table. I'll post a copy of it when I get more of it done.

Very interesting! I am almost illerate with MS Access compared to what I know an do with MS Excel. I would greatly appreciate a copy of the MS Access file you firgure out!

dave w

[EagleMark]

Dam! I could have taken courses on those years ago for free, but thought they were useless to a GearHead!

[PJG1173]

davew this may help with some of the manual sorting of MAP in your excel sheet =IF(E6>40,10*ROUND(E6/10,0),5*ROUND(E6/5,0)) this will round any map over 40 by 10 and anything less by 5.

[dave w]

davew this may help with some of the manual sorting of MAP in your excel sheet =IF(E6>40,10*ROUND(E6/10,0),5*ROUND(E6/5,0)) this will round any map over 40 by 10 and anything less by 5.

Thanks! I'll give the "IF" test a try.

dave w

[PJG1173]

here is what I have so far. there are instructions in the zip file. I'm still working some bugs out and not sure if I am going to keep linking the tunerpro logfile or just do an import. it seems like when you refresh the linked table it balloons the db file. There is still alot I want to do with this, like having it generate a new vetable based off the old one. also if you have a slow computer this may hog some resources when it is doing its calculations on a big logfile.

[EagleMark]

Thanks for sharing your work with us! It's great to have new guys jump in with their skills!

Can't wait to try it out and learn some new programs (excel-access) you guys are way ahead on the learning curve there.

You are aware you can export the data log from TunerPro with just selected parameters? Acquisition, Export Log, then click selective and choose what you want.

[PJG1173]

yes, but it only allows you to select the item logged not values in that item matching a certain criteria. the SQL query that is in the database will do that. currently I have it filtering out AE (active), PE (active), anything less than 2% tps, idle ve flag (on), Dcel enlenment flag, DFCO, and idle spark flag. it leaves just the records that were recorded with no other adders active at the time.

[dave w]

yes, but it only allows you to select the item logged not values in that item matching a certain criteria. the SQL query that is in the database will do that. currently I have it filtering out AE (active), PE (active), anything less than 2% tps, idle ve flag (on), Dcel enlenment flag, DFCO, and idle spark flag. it leaves just the records that were recorded with no other adders active at the time.

That's how I "Sort" the data log with Excel. The tune is greatly improved when filtering AE / PE and the other parameters listed above.