Notices
ECU Flash

Map Tracing spreadsheet - looking for feedback

Thread Tools
 
Search this Thread
 
Old May 13, 2008 | 09:25 AM
  #1  
ouminan's Avatar
Thread Starter
Newbie
 
Joined: Jun 2006
Posts: 88
Likes: 0
From: Issaquah, WA
Lightbulb Map Tracing spreadsheet - looking for feedback

Hey guys,

Thought I'd try giving back to the community after taking so much from it.

I'm putting together a map tracing spreadsheet that imports log files from evoscan/mitsulogger and cleans them and does a simple map trace.

You'll have to set the cells in yellow first.

1. Change the Default Log Directory to wherever you dump your logs.



2. Import a log using the button and take a look at it in the Log sheet.



3. Find the columns in your log sheet for TPS, RPM, Load, AFR, Timing, Boost, Knock, WGDC and enter them into the appropriate highlighted cells on the MapTrace sheet. If you don't use a field, set it to some blank column out in the blue like "CC"



4. Copy and paste your current maps into the two tables on the right side. Don't forget to adjust your scaling based off of your current table. (I still need to tweak the interpolation of the load/rpm cells). You can also clean the log if you wish. This basically searches for the first block of 95+ TPS, and deletes everything before and after. It will keep about 5 entries before the 95+ TPS block.



5. Play! Trace! Chart! (This was written in Excel 2007... so there might be some VBA incompatibilities with 2003. Let me know if you hit anything).




PLEASE give me suggestions, comments, feedback, call me names whatever.

Thanks!
Attached Files
File Type: zip
MapTracer.zip (44.7 KB, 109 views)
Reply
Old May 13, 2008 | 09:38 AM
  #2  
grenade's Avatar
Evolving Member
iTrader: (4)
 
Joined: Sep 2006
Posts: 247
Likes: 0
From: Here
Damn that looks awesome. Great work. Ill have to look into this and check it out when I get home.

Great job.
Reply
Old May 13, 2008 | 09:40 AM
  #3  
wreckleford's Avatar
Evolved Member
iTrader: (2)
 
Joined: Jun 2003
Posts: 1,171
Likes: 11
From: Jamaica
Looks good. I developed a spreadsheet that takes the AFR logs and compares them to your target a/f ratios and suggests values to put into your fuel maps in order to give you the AFR you want. I haven't tested it much because my wideband keeps acting up. Maybe you would like to incorporate it into this?
Reply
Old May 13, 2008 | 09:41 AM
  #4  
inco9nito99's Avatar
Evolved Member
iTrader: (90)
 
Joined: Jul 2005
Posts: 1,917
Likes: 0
From: Roselle, IL
thanks!
Reply
Old May 13, 2008 | 09:46 AM
  #5  
ouminan's Avatar
Thread Starter
Newbie
 
Joined: Jun 2006
Posts: 88
Likes: 0
From: Issaquah, WA
Thanks guys.

Wreckleford: I'll take a look at that idea. I was playing around with the idea myself (like having some sort of offset table and storing the maps off on a different sheet) but I haven't gotten to it yet.

I need to look more at how I interpolate rpm/load vs the way the ECU does to make sure I'm not highlighting the wrong cells first.
Reply
Old May 13, 2008 | 09:50 AM
  #6  
TeStUdO's Avatar
Evolved Member
iTrader: (6)
 
Joined: Jun 2005
Posts: 1,986
Likes: 41
From: Secret Tweaker Pad
Running a little lean I see
Reply
Old May 13, 2008 | 09:52 AM
  #7  
merkzu's Avatar
Evolving Member
iTrader: (4)
 
Joined: Dec 2006
Posts: 392
Likes: 1
From: Twin Cities, MN
very cool, keep working on this! does it build the chart for you automatically?
Reply
Old May 13, 2008 | 10:08 AM
  #8  
ouminan's Avatar
Thread Starter
Newbie
 
Joined: Jun 2006
Posts: 88
Likes: 0
From: Issaquah, WA
Yes, it builds the chart using the log file... looks better if it's been cleaned

TeStUdO: yeah.. i need to clean up those 12+ AFR's after spool... But that's going to make my fuel map ugly. HEH.
Reply
Old May 13, 2008 | 10:30 AM
  #9  
JustDSM's Avatar
Evolved Member
iTrader: (28)
 
Joined: Jul 2003
Posts: 1,176
Likes: 0
From: Cheyenne, WY
Awesome work! I could see alot of people using this!
Reply
Old May 13, 2008 | 11:19 AM
  #10  
merkzu's Avatar
Evolving Member
iTrader: (4)
 
Joined: Dec 2006
Posts: 392
Likes: 1
From: Twin Cities, MN
Works great except for the chart in 2003, I get run-time error 438 - Object doesn't support this property or method

Also clean log works fine cutting out everything before the run, but leaves in everything after the run

Last edited by merkzu; May 13, 2008 at 11:22 AM.
Reply
Old May 13, 2008 | 11:40 AM
  #11  
ouminan's Avatar
Thread Starter
Newbie
 
Joined: Jun 2006
Posts: 88
Likes: 0
From: Issaquah, WA
blargh... alright i'll fix that in 2003 later... working on averages and map tracing
Reply
Old May 13, 2008 | 12:35 PM
  #12  
4kinboost's Avatar
Evolved Member
iTrader: (10)
 
Joined: May 2005
Posts: 1,055
Likes: 0
From: long island,ny
Great Work!!
Reply
Old May 13, 2008 | 01:40 PM
  #13  
JoeBee's Avatar
Evolving Member
 
Joined: Sep 2006
Posts: 152
Likes: 0
From: Germany
You did not show the neighbore cells (ECU interpolation).
I have done this in my map walker. Ok, very often this looks a little bit confusing with all that marked cells.
https://www.evolutionm.net/forums/sh...d.php?t=251750
But normaly you did not hit a cell exactly.
Reply
Old May 13, 2008 | 02:57 PM
  #14  
ouminan's Avatar
Thread Starter
Newbie
 
Joined: Jun 2006
Posts: 88
Likes: 0
From: Issaquah, WA
Yeah, that's on my work list. Shouldn't be very hard to add, but I'm worried about how busy it's going to look... although looking at the picture of map walker, it's not too bad.
Reply
Old May 13, 2008 | 07:32 PM
  #15  
jid2's Avatar
Evolved Member
iTrader: (62)
 
Joined: Feb 2004
Posts: 3,336
Likes: 6
From: Redmond - Lake Tapps ,WA
Originally Posted by wreckleford
Looks good. I developed a spreadsheet that takes the AFR logs and compares them to your target a/f ratios and suggests values to put into your fuel maps in order to give you the AFR you want. I haven't tested it much because my wideband keeps acting up. Maybe you would like to incorporate it into this?
Did the same thing, here's the stuff below.



I went and logged as many conditions as possible to fill my "logged" map and it made the rest pretty easy. Then I focused on refining the areas in the powerband.



Attached Files
File Type: zip
ROM Translator2.zip (9.0 KB, 50 views)

Last edited by jid2; May 13, 2008 at 07:36 PM.
Reply



All times are GMT -7. The time now is 12:32 AM.