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
Printable View
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
that is what I've been searching for thanks!!
that was the missing piece I needed. now to automate it...
thanks again!
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 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.
Dam! I could have taken courses on those years ago for free, but thought they were useless to a GearHead! :mad1:
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.
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.
Thanks for sharing your work with us! :thumbsup: 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.
http://www.gearhead-efi.com/Fuel-Inj...1&d=1328045564
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.