Hunting maps with Excel

[TFtuning]

Maybe this my post is useless to most.
In my presentation I mentioned above, you used Excel to identify and analyze the maps of the ecu of my MG TF, not having the drivers.
Open the two files ori and mod with Winols (Demo), converted from Hex to decimal, slide the mouse across the table I copied and pasted on to Excel (the column address is not a copy, but it is easy to reconstruct with a couple of formulas and function Dec.Hex), so I placed the two tables side-by-side.
It is relatively easy to locate maps “potential”, looking for pairs of numbers that indicate the dimensions X*Y, and then the BP, as well as locate the maps changed (e.g., adding up all the numbers in a table and comparing the result of the two sums).
Where is the utility to use Excell ? You copy the maps and put them back in the order, the BP arranged as cartesian axes, and then the values, after that using the copy function special you can transpose the axes X and Y, that es to divide all the numbers in the table for 100, or 1000, or in the case of the lambda, which is presented as percentage values compared to 14.7, calculate the real values (the zeros corresponded to 14.7, the value of 30 corresponded to 97% of 14.7, and so on).
You can easily make graphs/maps in 3D, taking advantage of its specific function, rotate them. More complex, but feasible to create graphs in 2D.
And’ possible to insert other BP and calculate the intermediate values, a simple linear interpolation.
It would seem that with Excel it is possible to calculate the checksum of a table, but I'll need your help soon.

[sergiot]

congratulations , definitely interesting.
consider which of these features that you discovered are the same ones that are implemented in the main processing programs.
only that they came to us first because they started much earlier and have developed and preset the mode of calculation targeted for the specific use with the maps.
but there is nothing better than to realize the functions of the person.

[lsdlsd88]

honestly at first reading it seems to me you can do everything that you say even with winols, but if you are good with excel, you definitely don't lack the creativity and ingenuity
Congratulations and thanks for sharing ^^

[TFtuning]

You are perfectly right, these calculation functions are present in Winols, in fact, the idea came to me while studying a couple of tutorials Winols where they explained how to manage the properties of the maps THAT the program has identified the map with their name on it. Without the damos Winols or the drivers ECM for ecu Rover MEMS3 wouldn't come off. In the case of the AFR I don't think that with winols it is possible to apply a simple formula, but with more operations (e.g. the value in the map) 80 => 80/10 = 8 (100-8)*14,7/100 = 92% 14.7 = 13,5).
On Excel you can color the cells that detect the size of the map, you can highlight the colors of the BP, it will be a matter of habit with excel (in the past I used to design the geometry of steering suspensions parallelogram, with a lot of animation with graphs in the cloud).
On the web you can find hints of the checksum calculation with Excel.
Thanks for the compliments, maybe give me a hand verifying addresses, maps, view more back