Small Tool: Offline Map Walker
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.
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.
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 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.
Well you don't need a full spreadsheet -- just a table. Virtually every widget provides one of those.

d
Trending Topics
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.
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
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
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.
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.

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.
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.







