Bass Junky Posted July 18, 2006 Share Posted July 18, 2006 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 Link to comment https://www.sau.com.au/forums/topic/126563-power-figures-dyno-chart/ Share on other sites More sharing options...
Ronin 09 Posted July 18, 2006 Share Posted July 18, 2006 won't open... Link to comment https://www.sau.com.au/forums/topic/126563-power-figures-dyno-chart/#findComment-2336565 Share on other sites More sharing options...
Quinny Posted July 18, 2006 Share Posted July 18, 2006 I have updated mine, it is pretty rough given the difference in scale, but it is close enough. Power_Curve_XL_Sheet.zip Link to comment https://www.sau.com.au/forums/topic/126563-power-figures-dyno-chart/#findComment-2336662 Share on other sites More sharing options...
paulr33 Posted July 18, 2006 Share Posted July 18, 2006 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 Link to comment https://www.sau.com.au/forums/topic/126563-power-figures-dyno-chart/#findComment-2336823 Share on other sites More sharing options...
Bass Junky Posted July 18, 2006 Author Share Posted July 18, 2006 Then some smart person needs to do that for me, cos I have no idea how to do it. BASS OUT Link to comment https://www.sau.com.au/forums/topic/126563-power-figures-dyno-chart/#findComment-2336826 Share on other sites More sharing options...
paulr33 Posted July 18, 2006 Share Posted July 18, 2006 ill see what i can do, i think i can guess my way through it Link to comment https://www.sau.com.au/forums/topic/126563-power-figures-dyno-chart/#findComment-2336839 Share on other sites More sharing options...
Quinny Posted July 18, 2006 Share Posted July 18, 2006 I am pretty handy with Excel, I will try to put something together. Link to comment https://www.sau.com.au/forums/topic/126563-power-figures-dyno-chart/#findComment-2336846 Share on other sites More sharing options...
Quinny Posted July 18, 2006 Share Posted July 18, 2006 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 Link to comment https://www.sau.com.au/forums/topic/126563-power-figures-dyno-chart/#findComment-2337189 Share on other sites More sharing options...
Sydneykid Posted July 18, 2006 Share Posted July 18, 2006 Needs to be RPM based not KPH. Otheriwse it is useless for autos and guys with 180 kph speed limiters still functioning. cheers Link to comment https://www.sau.com.au/forums/topic/126563-power-figures-dyno-chart/#findComment-2337287 Share on other sites More sharing options...
Bass Junky Posted July 18, 2006 Author Share Posted July 18, 2006 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. Link to comment https://www.sau.com.au/forums/topic/126563-power-figures-dyno-chart/#findComment-2337344 Share on other sites More sharing options...
mad082 Posted July 18, 2006 Share Posted July 18, 2006 (edited) 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 Link to comment https://www.sau.com.au/forums/topic/126563-power-figures-dyno-chart/#findComment-2337361 Share on other sites More sharing options...
paulr33 Posted July 18, 2006 Share Posted July 18, 2006 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 Link to comment https://www.sau.com.au/forums/topic/126563-power-figures-dyno-chart/#findComment-2337554 Share on other sites More sharing options...
Quinny Posted July 18, 2006 Share Posted July 18, 2006 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 Link to comment https://www.sau.com.au/forums/topic/126563-power-figures-dyno-chart/#findComment-2337618 Share on other sites More sharing options...
Quinny Posted July 18, 2006 Share Posted July 18, 2006 i agree it should be rpm based, more usefulto 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. Link to comment https://www.sau.com.au/forums/topic/126563-power-figures-dyno-chart/#findComment-2337629 Share on other sites More sharing options...
mad082 Posted July 18, 2006 Share Posted July 18, 2006 or divide speed by 0.028 (saves a few button pushes) Link to comment https://www.sau.com.au/forums/topic/126563-power-figures-dyno-chart/#findComment-2337651 Share on other sites More sharing options...
Bass Junky Posted July 18, 2006 Author Share Posted July 18, 2006 quinney please e-mail me the file to [email protected] I can' tdownload it from here Link to comment https://www.sau.com.au/forums/topic/126563-power-figures-dyno-chart/#findComment-2337655 Share on other sites More sharing options...
Quinny Posted July 18, 2006 Share Posted July 18, 2006 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 Link to comment https://www.sau.com.au/forums/topic/126563-power-figures-dyno-chart/#findComment-2337766 Share on other sites More sharing options...
Abo Bob Posted October 24, 2006 Share Posted October 24, 2006 Posting to subscribe. Will add mine soon. Wouldn't it be cool if we could add our boost curves to the sheet too? Link to comment https://www.sau.com.au/forums/topic/126563-power-figures-dyno-chart/#findComment-2612730 Share on other sites More sharing options...
Bass Junky Posted October 24, 2006 Author Share Posted October 24, 2006 Er, Check the second worksheet Link to comment https://www.sau.com.au/forums/topic/126563-power-figures-dyno-chart/#findComment-2612760 Share on other sites More sharing options...
2BNVS Posted October 25, 2006 Share Posted October 25, 2006 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. Link to comment https://www.sau.com.au/forums/topic/126563-power-figures-dyno-chart/#findComment-2614032 Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now