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!
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!
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?
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.
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.
Trending Topics
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.

TeStUdO: yeah.. i need to clean up those 12+ AFR's after spool... But that's going to make my fuel map ugly. HEH.
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
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.
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.
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.
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?
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.

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


