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
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!!
87 4Runner, 15" spring lift, 3" body, chevy vortec 355, 5.29 gears, 38.5x15.5x15" Boggers, 280hr, 16168625 running $0D
93 S10, 36x12.5x15 TSL's, custom turbo headers, 266HR cam, p&p vortec heads, $0D Marine MPFI with 8psi boost.
05 Silverado, 2' lift, 4" exhaust, Bully Dog programmer,
that was the missing piece I needed. now to automate it...
thanks again!
87 4Runner, 15" spring lift, 3" body, chevy vortec 355, 5.29 gears, 38.5x15.5x15" Boggers, 280hr, 16168625 running $0D
93 S10, 36x12.5x15 TSL's, custom turbo headers, 266HR cam, p&p vortec heads, $0D Marine MPFI with 8psi boost.
05 Silverado, 2' lift, 4" exhaust, Bully Dog programmer,
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.
87 4Runner, 15" spring lift, 3" body, chevy vortec 355, 5.29 gears, 38.5x15.5x15" Boggers, 280hr, 16168625 running $0D
93 S10, 36x12.5x15 TSL's, custom turbo headers, 266HR cam, p&p vortec heads, $0D Marine MPFI with 8psi boost.
05 Silverado, 2' lift, 4" exhaust, Bully Dog programmer,
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.
87 4Runner, 15" spring lift, 3" body, chevy vortec 355, 5.29 gears, 38.5x15.5x15" Boggers, 280hr, 16168625 running $0D
93 S10, 36x12.5x15 TSL's, custom turbo headers, 266HR cam, p&p vortec heads, $0D Marine MPFI with 8psi boost.
05 Silverado, 2' lift, 4" exhaust, Bully Dog programmer,
Dam! I could have taken courses on those years ago for free, but thought they were useless to a GearHead!
1990 Chevy Suburban 5.7L Auto ECM 1227747 $42!
1998 Chevy Silverado 5.7L Vortec 0411 Swap to RoadRunner!
-= =-
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.
87 4Runner, 15" spring lift, 3" body, chevy vortec 355, 5.29 gears, 38.5x15.5x15" Boggers, 280hr, 16168625 running $0D
93 S10, 36x12.5x15 TSL's, custom turbo headers, 266HR cam, p&p vortec heads, $0D Marine MPFI with 8psi boost.
05 Silverado, 2' lift, 4" exhaust, Bully Dog programmer,
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.
87 4Runner, 15" spring lift, 3" body, chevy vortec 355, 5.29 gears, 38.5x15.5x15" Boggers, 280hr, 16168625 running $0D
93 S10, 36x12.5x15 TSL's, custom turbo headers, 266HR cam, p&p vortec heads, $0D Marine MPFI with 8psi boost.
05 Silverado, 2' lift, 4" exhaust, Bully Dog programmer,
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.
1990 Chevy Suburban 5.7L Auto ECM 1227747 $42!
1998 Chevy Silverado 5.7L Vortec 0411 Swap to RoadRunner!
-= =-
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.
87 4Runner, 15" spring lift, 3" body, chevy vortec 355, 5.29 gears, 38.5x15.5x15" Boggers, 280hr, 16168625 running $0D
93 S10, 36x12.5x15 TSL's, custom turbo headers, 266HR cam, p&p vortec heads, $0D Marine MPFI with 8psi boost.
05 Silverado, 2' lift, 4" exhaust, Bully Dog programmer,
Bookmarks