Hi all,
This is my first post on this forum. I've been using Excel 2003 for the past few years and I have been stumped on this problem for the past couple of years.
I have a spreadsheet I made for a vehicle application -- you enter dynamometer measurement information in RPM and torque, then the gear ratios, vehicle weight, tire size, etc and it will generate a series of scatter plots showing the full-throttle acceleration available through the vehicle speed range (basically translates the RPM domain to the MPH domain) as well as a few other things. I've spent a lot of time making it complete and nice looking.
The end result is a graph like the one titled "erics" that I attached. The one titled "c160" is another graph generated that compares two different motors with different transmission ratios.
The wheel torque (proportional to acceleration) is plotted in one line for each gear ratio.
I want to make a one-line plot of just the PEAK values -- in other words, I want it to plot 1st gear until the 1st gear line crosses the 2nd gear line (indicating that 2nd gear now produces more torque than first because the engine's power is dropping off) and then I want it to plot the 2nd gear line until that crosses the third gear line, etc.
I've been trying to figure out ways to do this literally for years. The problem as far as I can tell is that the X-axis indices are not constant -- the MPH values associated with each torque or acceleration value are not the same from gear to gear.
In college they never taught us Excel (we were taught Matlab, but I wanted this sheet to be usable by anyone) so i don't know much about macros and VBA and what not. If anyone can suggest something, please do -- even if you just know the proper tool to solve the problem, just let me know what it is and I'll take it from there. Any help is appreciated! Thanks!!
-Ben
PS: Sure is a hassle taking pictures out of Excel graphs, I end up saving it as an html document and stealing the linked gif images that are generated.
Bookmarks