Power Figures Dyno Chart

[Bass Junky]

Hey ppls.

For a little while now, I have been populating an XL Spreadsheet of Dyno Figures to compare my tunes and modifications.

I got the idea off Cubes, so I can't take credit for the idea itself.

BUT.

I'm going to open up my little spreadsheet to everyone to play with and add their numbers too.

Maybe we could even prepare a HUGE one to compate all sorts of fun and wonderful things.

Anywhoo.

Attached is my spreadsheet with graphing, and you could perhaps add to it, or cut and paste it, or add your own numbers too and have play.

BASS OUT

Power_Curve_XL_Sheet.zip

[Ronin 09]

won't open...

[Quinny]

I have updated mine, it is pretty rough given the difference in scale, but it is close enough.

Power_Curve_XL_Sheet.zip

[paulr33]

top work bass but i think it should be plotted into mysql with a php site so it can be customised and comparison at the click of a button. that excel sheet will suck when 5 other people add their results. like the v8 one you found, that was tops. we need that

[Bass Junky]

Then some smart person needs to do that for me, cos I have no idea how to do it.

BASS OUT

[paulr33]

ill see what i can do, i think i can guess my way through it

[Quinny]

I am pretty handy with Excel, I will try to put something together.

[Quinny]

I have done a remake of the sheet. It will require the re-entering of the figures unfortunately, but I have made a couple of changes.

I have changed the speed scale from 3's to 2's.

More notably, I have set up the graph to display only 5 figures at a time. I have added a Rank function (row 2) so you just enter in the numbers 1 to 5 above the figures you want the graph to display, then press the "Sort by Rank" button. The figures will be sorted and the graph will display the results you wanted.

Or you can sort by Max power, I have added a Max Power row at the bottom of the table, you can sort to show the 5 most powerful cars on the graph.

Hopefully this will be a little more user-friendly and a bit easier to read. I can always change the graph to read more than 5 if need be, but having the graph limited to a specific number of records, rather than all of them being shown at once will keep things a bit tidier.

I hope this helps.

Power_Comparison.zip

[Sydneykid]

Needs to be RPM based not KPH.

Otheriwse it is useless for autos and guys with 180 kph speed limiters still functioning.

cheers

[Bass Junky]

Maybe this could become part of the Turbo Upgrade Thread.

When you enter your dyno chart, you enter the number at each 100 rpm or so.

Could be interesting.

[mad082]

Needs to be RPM based not KPH

will be more accurate as kph, not rpm, as most people will only be guesstimating rpm. not many dyno sheets have rpm up the side to base it of, and if i go out on the road and say that i get 100kmh at 2850 rpm, that doesn't take into account both my speedo and tacho being out.

Edited July 18, 2006 by mad082

[paulr33]

i agree it should be rpm based, more useful

to get rpm from speed assuming 1:1 diff ratio then devide speed by 28 * 1000

[Quinny]

To save the hassle of re-entering all the figures, I made the changes to the original sheet.

The graph is now on a separate tab, and will display only the first 5 records. Enter the number 1 to 5 of the records you want to see, and press Sort by Rank to have those 5 appear on the graph. I added a Max power field, and a sort macro to sort by max power so show the top 5 most powerful cars.

Power_Curve_XL_Sheet.zip

[Quinny]

i agree it should be rpm based, more useful

to get rpm from speed assuming 1:1 diff ratio then devide speed by 28 * 1000

I can set this up as a formula on the sheet if you would rather see RPM than speed.

[mad082]

or divide speed by 0.028 (saves a few button pushes)

[Bass Junky]

quinney

please e-mail me the file to

bassjunkysbits@gmail.com

I can' tdownload it from here

[Quinny]

Added RPM to the graph instead of speed. I used the formula to work out the RPM for the speeds we were using, rather than reworking the speed for a given RPM because that would require re-entering all the power figures.

Power_Curve_XL_Sheet.zip

[Abo Bob]

Posting to subscribe. Will add mine soon.

Wouldn't it be cool if we could add our boost curves to the sheet too?

[Bass Junky]

Er,

Check the second worksheet

[2BNVS]

just curious, on the graph 102km/h is lined up with 3643rpm...on my dyno graph the rpm's dont line up with the graph 102km/h=3849rpm

what can be possible answers to this...as far as i know ratios are stock ( i havent changed them) would it be my rims? 19s?

just makin sure ay

cheers...ben.