Instead of postng a new spreadsheet, I'll tell you what to do, then see if you can tidy it up and post it:

For example, this is what you need to do to get the max tq and HP from the comparison run (run #2) to appear on the graph sheet (3rd gear HP_TQ)

1. On the comparison tab, copy column F. Go to column M and select 'Paste Special...', select 'Values' and click OK.
2. Go to the 3rd gear HP/TQ sheet (where the dyno graph is) and select a cell somewhere under the graph....I chose D37 (will be used later in the steps)
3. Paste in the following:
and hit Ctrl+Shift+Enter
This is your max torque. The Ctrl+Shift+Enter makes Excel put brackets around your formula and this is needed for the formula to work correctly.
4. Now go one cell to the right and use the following formula to lookup the corresponding RPM:
5. Go to cell D38. Paste in this:
and click Ctrl+Shift+enter
6. Go one cell to the right and paste in this:
If you did everything correctly, you should now have four cells showing:
for the comparison run. Follow the same logic to do for the first run as well.


Eric

 

The HP and TQ numbers are working out correctly...but for some reason the RPMs are not. I am still looking at it.

 

Make sure you do step #1. The VLookup requires the RPM numbers to be pasted after the TQ and HP numbers, since it looks up a value in the leftmost column and return a value from the matching row in the column you choose after that. So, step #1 is pasting the RPM column to the right of the HP and TQ as a new column.

Then, make sure you use the same cells on the dyno sheet (D37, etc).

 

Gotcha...but "K" is not the RPM Column. I Pasted "B" over to "M" and everything works fine. Thanks

 

Oops...typo. I meant column F, not K. I will update the first post. Glad it's working for you.

 

If someone added l2r99gst's info into the excel file I just posted, care to upload it?? I'm glad everyone is liking it so far. I tried doing the "MAX" formula to get max hp and torque but didn't know how to get it to ignore the cells that weren't being used with the "#DIV/0!" values. I'm not savvy with excel at all, this was my first real attempt. Props to MrFred for giving me a great base to work off of ;-)

Oh, I had my car dyno'd at Buschurs and at turbotrix while logging and thats what I used as my comparison figures to get some ballpark dyno correction values. I always record the air temp and barometric pressures the dyno is using too. And I make sure I know which type of weather correction format they use.

 

Here ya go!! In a very basic format. I did it so It displays only the EvoScan Data Max numbers. It can be easily modified to show both the comparison and Evoscan Data.

 

In open office I cant seem to get the formula to work and add the brackets correctly :-/

 

Anyone wanna PM me an activation serial number for Miscrosoft Excel???? *wink wink*

 

I would but its a company copy. Have you looked in BT?

 

I started playing w/ this newer excell file tonight, and got both logs (evoscan/comparison) to calculate tq/hp #'s w/ the rpm, and thought I would share...
Big thanks to mrfred, JOT, l2r99gst! Nice work I just followed l2r99gst directions and voila.

cheers

 

Nice work, I like this one much better

 

Thanks wors great but i still think its off by more than 15 whp/TQ.

the rpm/mph used i think is the problem, this is for the IX speed right?

 

The rpm/mph value for 3rd gear is nearly the same for all the 8s and 9s. What JOT has in his Excel file should work fine.

 

i am getting more accurate readings from changing it to around 86/87 mph. i am guessing this value is where u 3rd gear ends? that is apporximately 140km/h in my car.