So, i figured i would toss together an "offline" version of the gearing command mph/gearing/tire combo calculator...
Secondarily, i decided to add a shift point approximation aspect...
I think its pretty straight forward to use, but here are some BASIC directions...
Things are color coded but NOT locked, so you can booger it up if you try
The salmon color cells are the ones you should be inputing information into...
Gray with orange type are all calculated values, you should NOT be entering info in there (unless your excel savy, then feel free to mess about)
Step 1:
Start on page 1, where you input your basic gearing information... A lot of it doesnt need changed for the average user... The big ones for the average joe will be tire size, and sprocket changes...
In case you need to know stock specs(gearing or tire size), those are on sheet 3 (to the best of my knowledge) for the gen 1 & 2 busa, as well as the bking...
On this page Enter in your Front Sprocket size, rear sprocket size, and tire size... That is all you need, unless you have for some reason changed internals on the tranny...
If you changed the tranny, the internal gearing as well as input shaft gearing are avail to adjust as well...
This will populate the MPH table, and plot each gear on the Chart next to it..
YAY... you now have MPH for each gear from 100 rpm to 12,500 rpm... (in an ideal world, with ideal tires, etc)
Step 2....
So you want to figure out the (ballpark) optimal shift point... The next pages are all about plotting a delivered torque value... Now these are HUGE estimates, so dont go quoting ANYTHING about them... it merely is trying to show the mechanical advantage of the gear as a torque multiplier through gearing... So no internet dyno's!
For this part you will need at the VERY LEAST a paper dyno sheet, however IDEALY we want a digital dynojet file that you can get from your dyno operator... These are for use in the WINPEP 7 software that dynojet has to offer...
The best sheet will display your dyno run from ~2000/2500 rpm to 10500-11,000rpm (depending on rev limts etc)... because of the nature of motorcycle torque curves (ie flat as hell) the information your looking for will almost always be right near your rev limiter...
IN EITHER CASE, the point is we are going to input the torque values for various RPM into the chart... the more values, the better the information you can get out of it... and NO CHEATING... cheating will just hurt ya, conservative is actually better, as shifting takes time, so your more prone to over shoot a shift, than undershoot it...
So, either go to the "plug n chug" version if you have a paper dyno.. you're going to want a ruler for this method, and a good eye...
For the manual method, mark off vertical lines every 500 rpm, until you reach the top of the rev limiter.... Now, use your ruler to determine the Torque for each value.... and enter that information into the various RPM values...
I have set the sheet up for every 500 rpm, but more certainly doesnt hurt, and requires just minor adjustments on your part to the sheet...
After this is entered, you will now have a chart to the right, with your delivered torque plotted for each gear....
For the WINPEP version... you are going to want to open your dyno run, making sure your torque curve is shown, with RPM NOT MPH... on the bottom..
Then go FILE, EXPORT DATA, COMMA DELIMITER
UNCHECK: FORMAT FOR PRITING, DISPLAY PAGE HEADER,RUN INFORMATION, CONDTIONS.
STEP SIZE: .100
CLICK EXPORT...
save this file where you can find it someplace handy...
Now, open the excel file, click on the 5th sheet "import area"... I left data there to give you an idea of what you want your final image to look like... Once you think you got it... hit ctrl-a then DELETE...
Now, depending on your version of office, this part may vary... but what you want to do is import the data into excel from the text file you made...
In my version it goes as such..
DATA TAB, FROM TEXT, NAVIGATE TO FILE, CLICK FILE, CLICK IMPORT
CLICK RADIO BUTTON FOR DELIMITED
CHECK THE BOX FOR COMMA, UNCHECK TAB,CLICK NEXT, THEN FINISH..
A BOX WILL POP UP ASKING WHERE TO PUT THE DATA, IT SHOULD DEFAULT AS $A$1 IF NOT, CLICK IN THE TOP LEFT CELL, THEN CLICK OK...
now, the data we need is the torque column...
First verify that the starting torque and ending torque values you imported, match with that of the plotting on the sheet called DELIVERED TORQUE WINPEP
If it does, go to your imported data, hilight the torque starting from top to bottom, copy it all (ctrl c) switch to your DELIVERED TORQUE WINPEP page..
click in the first rpm- torque cell (2900 is the default rpm) and paste (ctrl-v)
assuming all has gone ok, the chart to the right will replot the new data, and display delivered torque for each gear....
Continued in next post...
Secondarily, i decided to add a shift point approximation aspect...
I think its pretty straight forward to use, but here are some BASIC directions...
Things are color coded but NOT locked, so you can booger it up if you try
The salmon color cells are the ones you should be inputing information into...
Gray with orange type are all calculated values, you should NOT be entering info in there (unless your excel savy, then feel free to mess about)
Step 1:
Start on page 1, where you input your basic gearing information... A lot of it doesnt need changed for the average user... The big ones for the average joe will be tire size, and sprocket changes...
In case you need to know stock specs(gearing or tire size), those are on sheet 3 (to the best of my knowledge) for the gen 1 & 2 busa, as well as the bking...
On this page Enter in your Front Sprocket size, rear sprocket size, and tire size... That is all you need, unless you have for some reason changed internals on the tranny...
If you changed the tranny, the internal gearing as well as input shaft gearing are avail to adjust as well...
This will populate the MPH table, and plot each gear on the Chart next to it..
YAY... you now have MPH for each gear from 100 rpm to 12,500 rpm... (in an ideal world, with ideal tires, etc)
Step 2....
So you want to figure out the (ballpark) optimal shift point... The next pages are all about plotting a delivered torque value... Now these are HUGE estimates, so dont go quoting ANYTHING about them... it merely is trying to show the mechanical advantage of the gear as a torque multiplier through gearing... So no internet dyno's!
For this part you will need at the VERY LEAST a paper dyno sheet, however IDEALY we want a digital dynojet file that you can get from your dyno operator... These are for use in the WINPEP 7 software that dynojet has to offer...
The best sheet will display your dyno run from ~2000/2500 rpm to 10500-11,000rpm (depending on rev limts etc)... because of the nature of motorcycle torque curves (ie flat as hell) the information your looking for will almost always be right near your rev limiter...
IN EITHER CASE, the point is we are going to input the torque values for various RPM into the chart... the more values, the better the information you can get out of it... and NO CHEATING... cheating will just hurt ya, conservative is actually better, as shifting takes time, so your more prone to over shoot a shift, than undershoot it...
So, either go to the "plug n chug" version if you have a paper dyno.. you're going to want a ruler for this method, and a good eye...
For the manual method, mark off vertical lines every 500 rpm, until you reach the top of the rev limiter.... Now, use your ruler to determine the Torque for each value.... and enter that information into the various RPM values...
I have set the sheet up for every 500 rpm, but more certainly doesnt hurt, and requires just minor adjustments on your part to the sheet...
After this is entered, you will now have a chart to the right, with your delivered torque plotted for each gear....
For the WINPEP version... you are going to want to open your dyno run, making sure your torque curve is shown, with RPM NOT MPH... on the bottom..
Then go FILE, EXPORT DATA, COMMA DELIMITER
UNCHECK: FORMAT FOR PRITING, DISPLAY PAGE HEADER,RUN INFORMATION, CONDTIONS.
STEP SIZE: .100
CLICK EXPORT...
save this file where you can find it someplace handy...
Now, open the excel file, click on the 5th sheet "import area"... I left data there to give you an idea of what you want your final image to look like... Once you think you got it... hit ctrl-a then DELETE...
Now, depending on your version of office, this part may vary... but what you want to do is import the data into excel from the text file you made...
In my version it goes as such..
DATA TAB, FROM TEXT, NAVIGATE TO FILE, CLICK FILE, CLICK IMPORT
CLICK RADIO BUTTON FOR DELIMITED
CHECK THE BOX FOR COMMA, UNCHECK TAB,CLICK NEXT, THEN FINISH..
A BOX WILL POP UP ASKING WHERE TO PUT THE DATA, IT SHOULD DEFAULT AS $A$1 IF NOT, CLICK IN THE TOP LEFT CELL, THEN CLICK OK...
now, the data we need is the torque column...
First verify that the starting torque and ending torque values you imported, match with that of the plotting on the sheet called DELIVERED TORQUE WINPEP
If it does, go to your imported data, hilight the torque starting from top to bottom, copy it all (ctrl c) switch to your DELIVERED TORQUE WINPEP page..
click in the first rpm- torque cell (2900 is the default rpm) and paste (ctrl-v)
assuming all has gone ok, the chart to the right will replot the new data, and display delivered torque for each gear....
Continued in next post...