Notices
ECU Flash

Small Tool: Offline Map Walker

Thread Tools
 
Search this Thread
 
Old Feb 16, 2007 | 06:31 AM
  #1  
JoeBee's Avatar
Thread Starter
Evolving Member
 
Joined: Sep 2006
Posts: 152
Likes: 0
From: Germany
Small Tool: Offline Map Walker

I have programmed a small Excel tool for an offline map walk.
Simply paste your map in the cells. Maybe change your load scale.

Then paste RPM and Load from your log to somewhere in the sheet. (See gif 1)
Mark all the rows you want to be seen in the map. You must mark two columns. First must be RPM, and second must be load without the heading line. Press "Mark" (See gif 2)
The map will be marked with colors, and the Column right of the mark will be overwritten with the interpolated map value, that was calculated from the 4 map cells.
If you hit a cell, row or column directly, this calc will not be done (the value was wrong with the way I calculate it ). But this rare case will not be happen in reality so I didn’t program this.

With "Unmark" you can delete the color marks in the map and with "Unmark2" you can delete values and colors in the Area you have marked. (See gif 3)

No warranty at all. Early alpha. Source can be changed.

By the way, did the ECU make this interpolation? If not, this tool is something for the trash.
Attached Thumbnails Small Tool: Offline Map Walker-mapwalker1.gif   Small Tool: Offline Map Walker-mapwalker2.gif   Small Tool: Offline Map Walker-mapwalker3.gif  
Attached Files
File Type: zip
MapWalker.zip (85.4 KB, 56 views)
Reply
Old Feb 16, 2007 | 06:37 AM
  #2  
jcsbanks's Avatar
Evolved Member
 
Joined: May 2006
Posts: 2,399
Likes: 6
From: UK
Sweet!

Can Excel be integrated with the logger tools in any way to do this within a logger?
Reply
Old Feb 16, 2007 | 06:41 AM
  #3  
MalibuJack's Avatar
EvoM Guru
20 Year Member
iTrader: (5)
 
Joined: Feb 2003
Posts: 10,572
Likes: 14
From: Royse City, TX
No, but this is similar to what would be done in a logger with a grid control..
Reply
Old Feb 16, 2007 | 07:56 AM
  #4  
donour's Avatar
Evolved Member
iTrader: (6)
 
Joined: May 2004
Posts: 2,502
Likes: 1
From: Tennessee, USA
Originally Posted by MalibuJack
No, but this is similar to what would be done in a logger with a grid control..
Well actually you probably could do this if you really wanted too. I know that OpenOffice has scripting support for it's spreadsheet. I'd bet that excel provides some external interface as well.

I've been thinking about coding up something similiar myself for a while. Although, my idea was to have the app actually make changes to the map based on some parameters and instaneous power value.

d
Reply
Old Feb 16, 2007 | 08:03 AM
  #5  
MalibuJack's Avatar
EvoM Guru
20 Year Member
iTrader: (5)
 
Joined: Feb 2003
Posts: 10,572
Likes: 14
From: Royse City, TX
Yes it does have scripting support.. Unfortunately it creates yet another dependency on an application many people don't have, and when they do have it, versions vary very significantly.
Reply
Old Feb 16, 2007 | 08:16 AM
  #6  
donour's Avatar
Evolved Member
iTrader: (6)
 
Joined: May 2004
Posts: 2,502
Likes: 1
From: Tennessee, USA
Originally Posted by MalibuJack
Yes it does have scripting support.. Unfortunately it creates yet another dependency on an application many people don't have, and when they do have it, versions vary very significantly.
Oh I see what you're saying?

Well you don't need a full spreadsheet -- just a table. Virtually every widget provides one of those.

d
Reply
Old Feb 16, 2007 | 08:25 AM
  #7  
MalibuJack's Avatar
EvoM Guru
20 Year Member
iTrader: (5)
 
Joined: Feb 2003
Posts: 10,572
Likes: 14
From: Royse City, TX
But assuming the spreadsheet works right, I think its a good tool for offline viewing because you can select the data you want it to "Gridify" hehe..
Reply
Old Feb 16, 2007 | 09:00 AM
  #8  
nj1266's Avatar
Evolved Member
iTrader: (6)
 
Joined: Nov 2004
Posts: 3,254
Likes: 13
From: USA
Good job, but if you have Logworks, then you already have something similar that will allow you to have infinite number of logs inserted into two dimentional charts with Load and RPM as the axes.
Reply
Old Feb 16, 2007 | 09:00 AM
  #9  
Ralph's Avatar
Evolved Member
iTrader: (19)
 
Joined: Jun 2005
Posts: 756
Likes: 0
From: N/A
Nice.

How about one for timing? And one that allows us to modify the # of columns/rows for those of us with more than the standard rom
Reply
Old Feb 16, 2007 | 09:11 PM
  #10  
codgi's Avatar
Evolved Member
20 Year Member
Photogenic
Liked
Loved
Community Favorite
iTrader: (22)
 
Joined: Aug 2004
Posts: 2,493
Likes: 41
From: Seattle, WA
Originally Posted by donour
Well actually you probably could do this if you really wanted too. I know that OpenOffice has scripting support for it's spreadsheet. I'd bet that excel provides some external interface as well.

I've been thinking about coding up something similiar myself for a while. Although, my idea was to have the app actually make changes to the map based on some parameters and instaneous power value.

d

Yes this is correct. You can actually host Excel, Word and PowerPoint (these off my head...but pretty much all of the Office suite) in other applications using the interop dlls or the any other redistributable stuff (need some license for this I think). We did this for Holodeck when I worked with Security Innovation.

So even if they didn't have the suite...if you included the redistributables it would work...just as I said not sure on licensing. Of course (as noted above) this is way too much overhead just to show a table. Can easily use a grid control and a parser to achieve the same effect for much less work .
Reply
Old Feb 17, 2007 | 03:12 PM
  #11  
SophieSleeps's Avatar
Evolved Member
iTrader: (19)
 
Joined: Sep 2005
Posts: 834
Likes: 0
From: Butthole, MA
Originally Posted by JoeBee
I have programmed a small Excel tool for an offline map walk.
Simply paste your map in the cells. Maybe change your load scale.

Then paste RPM and Load from your log to somewhere in the sheet. (See gif 1)
Mark all the rows you want to be seen in the map. You must mark two columns. First must be RPM, and second must be load without the heading line. Press "Mark" (See gif 2)
The map will be marked with colors, and the Column right of the mark will be overwritten with the interpolated map value, that was calculated from the 4 map cells.
If you hit a cell, row or column directly, this calc will not be done (the value was wrong with the way I calculate it ). But this rare case will not be happen in reality so I didn’t program this.

With "Unmark" you can delete the color marks in the map and with "Unmark2" you can delete values and colors in the Area you have marked. (See gif 3)

No warranty at all. Early alpha. Source can be changed.

By the way, did the ECU make this interpolation? If not, this tool is something for the trash.
very cool.

So excuse my ignorance, but what does this allow you to do?
Does it simply allow you to see interpolated map value of your fuel map at any given point?

Also, how would you go about adjusting the scale? My map goes to 300 load.
Reply
Old Feb 17, 2007 | 07:16 PM
  #12  
honda-guy's Avatar
Evolved Member
iTrader: (55)
 
Joined: May 2005
Posts: 3,589
Likes: 37
From: Central PA
nice, thanks for sharing.
Reply
Old Feb 18, 2007 | 01:42 AM
  #13  
JoeBee's Avatar
Thread Starter
Evolving Member
 
Joined: Sep 2006
Posts: 152
Likes: 0
From: Germany
Does it simply allow you to see interpolated map value of your fuel map at any given point?
Yes, and mark these points in the map table.

Also, how would you go about adjusting the scale? My map goes to 300 load.
You can simply change the numbers in the load row.
Reply
Old Feb 18, 2007 | 06:10 AM
  #14  
SophieSleeps's Avatar
Evolved Member
iTrader: (19)
 
Joined: Sep 2005
Posts: 834
Likes: 0
From: Butthole, MA
Originally Posted by JoeBee
Yes, and mark these points in the map table.

You can simply change the numbers in the load row.
I have two additional rows...Just wanted to make sure it didn't affect a formula by simply adding 2 rows.
Reply
Old Feb 18, 2007 | 06:36 AM
  #15  
JoeBee's Avatar
Thread Starter
Evolving Member
 
Joined: Sep 2006
Posts: 152
Likes: 0
From: Germany
You have additional rows? Did this work in the ECU?
My tool can only use the fix counts of rows/columns.
But it is very simple to change this in the code.
Reply



All times are GMT -7. The time now is 06:32 PM.