Hi Wes,
I'm SHIRAKAWA Akira, you've probably never heard of me.
I'm writing to this group because I've recently found out that in
these years I wrote a spreadsheet file which almost does the same
things as yours without having ever seen it before!
However my approach has been different. Basically:
- It's less user friendly because it wasn't initially intended for
public use
- Has been made for OpenOffice's Calc spreadsheet application
- It doesn't (at least not yet) make use of macros
- It only has a very basic simulation of car acceleration
- Its main purpose is to make wheel power/torque charts from gps, obd
or videocamera data of rpm over time (filtered for clarity) and to use
them to plot a chart with optimal shift points, top speed calculation,
gradient calculation basing on user-imputed data, all in one
My main source of inspiration has been the old CarTest 4.5 for DOS but
at glance it could seem a blatant case of plagiarism from your
spreadsheet. I assure you it's not, even if I can't prove myself.
http://www.shirakawaakira.net/foto/calcolmarc01.jpg
http://www.shirakawaakira.net/foto/calcolmarc02.jpg
http://www.shirakawaakira.net/foto/calcolmarc03.jpg
http://www.shirakawaakira.net/foto/calcolmarc04.jpg
http://www.shirakawaakira.net/foto/calcolmarc05.jpg
Torque/power chart calculated from digital tachometer video:
http://www.shirakawaakira.net/img/10proveconinterpolazione.png
http://www.shirakawaakira.net/img/10provecurveaccregimiottimali.png
Torque/power chart calculated from OBD data:
http://www.shirakawaakira.net/img/bmw120d_nicco_03_good.png
http://www.shirakawaakira.net/img/bmw120d_nicco_04.png
The problem is that now that I have seen your spreadsheet file I came
up with new ideas to improve mine ^_^'