by John_W » Mon 05.06.2006, 21:50
Monty,
I've just seen this thread. Sorry, but I'm not in a position at the mo' to do any data analysis. (We have at last tempted a builder in to perform alterations on our house, so I don't have access to my Mac - it's under several dust sheets - and I'm using a laptop through a crappy wireless link. Mess everywhere)
As Ailwyn says, dumping data to Excel allows you to dig a bit deeper into the results and crossplot various parameters a bit more easily. It also lets you filter out all the incidental garbage and just leave (for instance) only the 100% open throttle data to plot.
I usually use 30-70 full-throttle runs in 3rd gear on a FLAT road to allow nice plots of eg power vs RPM or speed vs time, and to see how the boost develops through the rev range, and can use these for comparison of different setups and cars. Again, you can use Excel to identify where your 100% throttle in 3rd run starts, and use only that part of the dataset. Perform several (say 6 or 7) accleration runs to ensure you allow for statistics/slight gradients a bit (easy to find a clear stretches of road to do this where I live, but I'm not sure about Manchester).
For any given 30-70 acceleration run, I've found it most useful to plot the speed vs time data as pointsets in Excel (rather than as a joined-up-dots continuous line graph), then use a simple linear regression to "best-fit" a straight line through them. (To do this, time=zero has to be the start of the 30 mph acceleration run, so you have to calculate this in Excel.) The gradient of this line is a measure of the rate of change of speed (ie acceleration), and the gradient of the line changes with different setups. eg a car with the Everest chip gives a steeper line gradient than standard car, because it accelerates faster.
Oh dear, I've just re-read that and I didn't explain it very well. It's a lot simpler than my explanation. Basically, if you bung the Elanscan output into Excel, you can play with it to compare different cars or before/after a new exhaust.
John