alvin l nunley
Site Supporter
Request your free copy. anunley@austin.rr.com
For Excel 2003 and 2010 users. Also Apache OpenOffice users. (Apache OpenOffice is a free down load.)
Page 1.
Gear ratios with MPH.
Enter you maximum RPM, your engine gear and your axel gear along with the tire circumference and see the gear ratio and the speed at that RPM. On the same page, if you are using a jackshaft, same thing. Enter your primary gears, your secondary gears, your RPM, your tire circumference and see your primary ratio, your secondary ratio, over all ratio and speed.
Page 2
Gear ratios.
Enter a starting axle gear and a starting engine gear and see 20 different ratios with 13 different drivers. Print it out. Prints double sided with printers that have that capability, or just turn the paper over and hit enter again. It?s real handy if you?re changing drivers and want the next best axle gear for the closes match on the ratio. There?s also a gear ratio sheet if you?re using a Jack shaft.
Page 3
Weight percentages.
Enter the kart total weight, with driver, and the percentages you want, (front, left, cross) and it comes up with the weights at each corner, and the percentages at those corners. Also the front to rear weight and percentages. Also, something new, side to side weights and percentages, front and rear.
Something new; after you put in the percentages and total weight, and see what the corners say, you can delete the total weight number and change the input corners to see what different weights in the corners will do to your percentages. There are cells for inputting corners, and for calculated corners from percentage inputs. Instructions (Help) for cells when needed. There is no better ?free? weight percentage program available anywhere. If you?re a dirt karter, it makes it worth your wild to buy Excel. Or down load a free copy of OpenOffice. OpenOffice lacks a few features of Excel, but has no effect on the numbers that nine sheets gives you.
Or, if you only have the corner weights, put them in and you get the percentages. (Total kart & driver, front, left and cross.)
Page 4
Piston travel by degrees of crank rotation.
Put in your rod length, center to center, the stroke and get the piston travel for each degree, (or portion of a degree) of crank rotation. Great for setting timing, ?in the hole?, or for port work on 2 cycles.
Page 5
Jetting; compare jet flow, (area) one to another.
Enter in the first jet size, then the jet you plan on changing to and see the percentage difference in area. It gives you the jet area of both jets and the percentage difference between them. Also a list, by any increment in size you want, of about the next twenty jets, from the one you plan on using, by steps of .0002? (which you can change) and the percentage difference. You might be surprised at how much, percentage wise, the difference is between a .039? jet and a .040? jet.
Page 6
Stagger.
Enter the circumference of the LR tire you?re using, the distance, center to center, of the rear tires, the radius of the turn and get a theoretical size, and resulting stagger, for the rear tires. Following this sheet there is a way to adjust these numbers for track banking.
Page 7
Gear ratios change with tire circumference change.
Enter what you have on the kart now, enter what you going to put on the kart and see what the ratio needs to be with a bigger circumference tire.
Page 8
Same as 7 but with a jackshaft.
Page 9
Jackshaft gear ratios by overall ratio.
Put in the primary gears, the secondary gears and see a list of ratios from a starting gear on the axle. Put in a 53 starting axle gear and see 21 different secondary gears and overall ratios.
Page 10
A day at the track.
Enter your lap times in practice and in the race and see highs and lows. See the averages, the totals, fast lap and slow lap. See the total time on the engine for that day at the track. Space to enter setup information and track totals. Race day or practice day. Date at the track. Date of information entry. Day at the track totals space where you enter the information.
Page 11
Average speed
Enter the track length, enter your time and get an average speed.
Page 12
Track gear and totals
Enter track length, tire circumference, high and low engine RPM, one timed lap and get a lot of information about other things.
Page 13
Speed verses RPM and gear ratio.
Enter gears, tire circumference and starting RPM and get gear ratios, the speed of the next 5000 RPMs in 100 RPM steps.
Page 14
Same as above but with a jack shaft.
Page 15
Rod length to stroke ratio.
Both metric and English. Put in the length of the rod, center to center, and the stroke and get the ratio of the rod length to stroke. If you only have one set of numbers, English or metric, it also converts them from one to the other.
Page 16
Some useful math formulas.
Page 17
Compression ratios.
Enter data, in metric or English, like bore and stroke and get CCs and compression ratios. Not as good as measuring the CCs in the combustion chamber, but works well
Page 18
Track length,
Enter one turn diameter and one straight and get the total track length.
Page 19
Shifter over all gear ratios.
Not all shifters have the same final out put ratio. Put in your 5thh gear ratio, the engine gear and the axle gear and get the overall ratio. Good for comparing ratios on different engines. There?s a lot of difference between makes in output ratios.
Page 20
Calculate the angle of the turns.
Put in the track width and your guess for the angle. See what the top edge of the track would be for that angle. You need to know the height of the outside edge of the turn.
Also includes a really neat trig cheat sheet. Makes calculating angles and side lengths on a right triangle really easy.
Page 21
Tire temps.
Enter the tire temps, R,L,C and get all kinds of averages. Twelve different averages.
Page 22
Small, 5x8, printable gear ratio chart to take to the track. Customizable. Use any starting axle gear and any starting engine gear. Shows the ratios for 20 different axle gears and 10 different engine gears.
Page 23
Dyno Chart
Enter your torque/RPM numbers, the temperature and barometric pressure at the time of the test, and get corrected horsepower numbers along with a dyno chart.
Page 24
A spreadsheet that will calculate your compression ratio. You put in the bore and stroke, Metric or English, and the CC?s in the combustion chamber and it gives you the compression ratio. There is also a section to calculate combustion chamber CC?s. You enter the head CC?s, the gasket thickness, the diameter of the hole in the gasket and how far ? in ? the ? hole the piston is and it calculates your combustion chamber CC?s. Works with Metric or English numbers.
Page 25
Adjusting rear tread widths for tracks with banked turns.
If you want to calculate the stagger needed for a particular track that has banking, it?s a little different from a track that is flat. As banking increases, the horizontal difference in the width, center to center of the rear tires, decreases. Just measure the width of the rear tires, center to center, enter that number and the banking in degrees, then the spreadsheet will give you the number to use for calculating stagger. Imagine two vertical lines whose position is in the center of each rear tire. Now imagine if you picked up one side of the kart, but those two lines stayed vertical. You can see that the higher you raise the side of kart, the shorter the distance between those two vertical lines. And the distance is not constant. The distance changes, from flat to one degree of banking, would hardly be noticeable, but with each increased degree of banking, the change in distance becomes shorter. The need to change the distance between those two vertical lines becomes increasingly more important as the angle increases. Just looking at the spreadsheet you would see what I mean.
Page 26
This spreadsheet tells you how many degrees, or portion of a degree, you advanced/retard the timing, with each .001? you cut the key.
You put in the crankshaft diameter, for instance .750?, it then tells you how many thousands there are in one degree. You put in the thickness of the key, it then tells you how many degrees of rotation that key would represent. You then put in the amount you cut off, in thousands, it then tells you how many degrees the remainder represents, and it tells you the difference between the stock key and the cut key, in degrees.
Page 27 (added 3?9?15)
Calculate the difference in area between 2 holes.
This spreadsheet will allow you to enter the diameter of 2 holes, in metric or English, and see the difference in area between the holes. It also converts metric to English and vice versa.
Page 28 (added 12-1-2016)
Cutting pistons for Piston Port intake timing.
Enter the rod length, the stroke, the piston port opening, (degrees, MM or inch) how many degrees you want to increase the piston port opening and it tells you; in decimal or metric, how much to cut off the piston skirt.
No charge. Free to anybody that wants it.
Email anunley@austin.rr.com request your free copy. Will not work on handhelds
For Excel 2003 and 2010 users. Also Apache OpenOffice users. (Apache OpenOffice is a free down load.)
Page 1.
Gear ratios with MPH.
Enter you maximum RPM, your engine gear and your axel gear along with the tire circumference and see the gear ratio and the speed at that RPM. On the same page, if you are using a jackshaft, same thing. Enter your primary gears, your secondary gears, your RPM, your tire circumference and see your primary ratio, your secondary ratio, over all ratio and speed.
Page 2
Gear ratios.
Enter a starting axle gear and a starting engine gear and see 20 different ratios with 13 different drivers. Print it out. Prints double sided with printers that have that capability, or just turn the paper over and hit enter again. It?s real handy if you?re changing drivers and want the next best axle gear for the closes match on the ratio. There?s also a gear ratio sheet if you?re using a Jack shaft.
Page 3
Weight percentages.
Enter the kart total weight, with driver, and the percentages you want, (front, left, cross) and it comes up with the weights at each corner, and the percentages at those corners. Also the front to rear weight and percentages. Also, something new, side to side weights and percentages, front and rear.
Something new; after you put in the percentages and total weight, and see what the corners say, you can delete the total weight number and change the input corners to see what different weights in the corners will do to your percentages. There are cells for inputting corners, and for calculated corners from percentage inputs. Instructions (Help) for cells when needed. There is no better ?free? weight percentage program available anywhere. If you?re a dirt karter, it makes it worth your wild to buy Excel. Or down load a free copy of OpenOffice. OpenOffice lacks a few features of Excel, but has no effect on the numbers that nine sheets gives you.
Or, if you only have the corner weights, put them in and you get the percentages. (Total kart & driver, front, left and cross.)
Page 4
Piston travel by degrees of crank rotation.
Put in your rod length, center to center, the stroke and get the piston travel for each degree, (or portion of a degree) of crank rotation. Great for setting timing, ?in the hole?, or for port work on 2 cycles.
Page 5
Jetting; compare jet flow, (area) one to another.
Enter in the first jet size, then the jet you plan on changing to and see the percentage difference in area. It gives you the jet area of both jets and the percentage difference between them. Also a list, by any increment in size you want, of about the next twenty jets, from the one you plan on using, by steps of .0002? (which you can change) and the percentage difference. You might be surprised at how much, percentage wise, the difference is between a .039? jet and a .040? jet.
Page 6
Stagger.
Enter the circumference of the LR tire you?re using, the distance, center to center, of the rear tires, the radius of the turn and get a theoretical size, and resulting stagger, for the rear tires. Following this sheet there is a way to adjust these numbers for track banking.
Page 7
Gear ratios change with tire circumference change.
Enter what you have on the kart now, enter what you going to put on the kart and see what the ratio needs to be with a bigger circumference tire.
Page 8
Same as 7 but with a jackshaft.
Page 9
Jackshaft gear ratios by overall ratio.
Put in the primary gears, the secondary gears and see a list of ratios from a starting gear on the axle. Put in a 53 starting axle gear and see 21 different secondary gears and overall ratios.
Page 10
A day at the track.
Enter your lap times in practice and in the race and see highs and lows. See the averages, the totals, fast lap and slow lap. See the total time on the engine for that day at the track. Space to enter setup information and track totals. Race day or practice day. Date at the track. Date of information entry. Day at the track totals space where you enter the information.
Page 11
Average speed
Enter the track length, enter your time and get an average speed.
Page 12
Track gear and totals
Enter track length, tire circumference, high and low engine RPM, one timed lap and get a lot of information about other things.
Page 13
Speed verses RPM and gear ratio.
Enter gears, tire circumference and starting RPM and get gear ratios, the speed of the next 5000 RPMs in 100 RPM steps.
Page 14
Same as above but with a jack shaft.
Page 15
Rod length to stroke ratio.
Both metric and English. Put in the length of the rod, center to center, and the stroke and get the ratio of the rod length to stroke. If you only have one set of numbers, English or metric, it also converts them from one to the other.
Page 16
Some useful math formulas.
Page 17
Compression ratios.
Enter data, in metric or English, like bore and stroke and get CCs and compression ratios. Not as good as measuring the CCs in the combustion chamber, but works well
Page 18
Track length,
Enter one turn diameter and one straight and get the total track length.
Page 19
Shifter over all gear ratios.
Not all shifters have the same final out put ratio. Put in your 5thh gear ratio, the engine gear and the axle gear and get the overall ratio. Good for comparing ratios on different engines. There?s a lot of difference between makes in output ratios.
Page 20
Calculate the angle of the turns.
Put in the track width and your guess for the angle. See what the top edge of the track would be for that angle. You need to know the height of the outside edge of the turn.
Also includes a really neat trig cheat sheet. Makes calculating angles and side lengths on a right triangle really easy.
Page 21
Tire temps.
Enter the tire temps, R,L,C and get all kinds of averages. Twelve different averages.
Page 22
Small, 5x8, printable gear ratio chart to take to the track. Customizable. Use any starting axle gear and any starting engine gear. Shows the ratios for 20 different axle gears and 10 different engine gears.
Page 23
Dyno Chart
Enter your torque/RPM numbers, the temperature and barometric pressure at the time of the test, and get corrected horsepower numbers along with a dyno chart.
Page 24
A spreadsheet that will calculate your compression ratio. You put in the bore and stroke, Metric or English, and the CC?s in the combustion chamber and it gives you the compression ratio. There is also a section to calculate combustion chamber CC?s. You enter the head CC?s, the gasket thickness, the diameter of the hole in the gasket and how far ? in ? the ? hole the piston is and it calculates your combustion chamber CC?s. Works with Metric or English numbers.
Page 25
Adjusting rear tread widths for tracks with banked turns.
If you want to calculate the stagger needed for a particular track that has banking, it?s a little different from a track that is flat. As banking increases, the horizontal difference in the width, center to center of the rear tires, decreases. Just measure the width of the rear tires, center to center, enter that number and the banking in degrees, then the spreadsheet will give you the number to use for calculating stagger. Imagine two vertical lines whose position is in the center of each rear tire. Now imagine if you picked up one side of the kart, but those two lines stayed vertical. You can see that the higher you raise the side of kart, the shorter the distance between those two vertical lines. And the distance is not constant. The distance changes, from flat to one degree of banking, would hardly be noticeable, but with each increased degree of banking, the change in distance becomes shorter. The need to change the distance between those two vertical lines becomes increasingly more important as the angle increases. Just looking at the spreadsheet you would see what I mean.
Page 26
This spreadsheet tells you how many degrees, or portion of a degree, you advanced/retard the timing, with each .001? you cut the key.
You put in the crankshaft diameter, for instance .750?, it then tells you how many thousands there are in one degree. You put in the thickness of the key, it then tells you how many degrees of rotation that key would represent. You then put in the amount you cut off, in thousands, it then tells you how many degrees the remainder represents, and it tells you the difference between the stock key and the cut key, in degrees.
Page 27 (added 3?9?15)
Calculate the difference in area between 2 holes.
This spreadsheet will allow you to enter the diameter of 2 holes, in metric or English, and see the difference in area between the holes. It also converts metric to English and vice versa.
Page 28 (added 12-1-2016)
Cutting pistons for Piston Port intake timing.
Enter the rod length, the stroke, the piston port opening, (degrees, MM or inch) how many degrees you want to increase the piston port opening and it tells you; in decimal or metric, how much to cut off the piston skirt.
No charge. Free to anybody that wants it.
Email anunley@austin.rr.com request your free copy. Will not work on handhelds
