part throttle VE tuning with WBo2

[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.