Speed in gears excel sheet

dingy · May 7, 2011

I updated the speed calculation sheet I had posted a while back. I can't find the thread so I started a new one.

I added a feature to be able to display speeds in Kilometers/Hour.

Also modified the tire size inputs a little. I got a new rear tire and found it was easier to measure circumference accurately than it was to measure diameter.

Just modified this sheet to add a wheel slippage factor.

The password to unlock the sheet is dingy if you are an excel guru and want to play with it. Only locked it as it is easier for user if only cells that need input are editable.

Gary

dingy · May 7, 2011

Just modified the spreadsheet in the first post to include a wheel slippage correction factor for each gear.

Gary

RaWarrior · May 7, 2011

Wow, nice work. That's definitely a keeper...should submit it to vmaxoutlaw, way more useful than their "speed in gears" chart. Especially since it applies to 4 different bikes, and both the vmax/venture pumpkins.

WIKDMAX · May 8, 2011

OK I know I can be a tard sometimes but I'm having a rough time reading this. And if I understand it correctly in 5th gear at 5000 RPM's my Gen 1 should be traveling at 93.6 MPH? I'm doing about 75 by the speedo. So am I reading the graph wrong or do I need to start looking for a problem with the bike?

Maxine · May 8, 2011

WIKDMAX said:
OK I know I can be a tard sometimes but I'm having a rough time reading this. And if I understand it correctly in 5th gear at 5000 RPM's my Gen 1 should be traveling at 93.6 MPH? I'm doing about 75 by the speedo. So am I reading the graph wrong or do I need to start looking for a problem with the bike?

The spreadsheet as you opened it is set for first gen Venture with Venture final drive. Change the bike model to #4 and the final drive to #2 if yours is a stock Vmax setup. Also input your correct tire size in the pink boxes as well.

OP. Very nice spreadsheet by the way

Thanks for your effort and contribution.

Regards,
R

Rusty McNeil · May 8, 2011

Gary,

you got skills man

unk:

unk:.....Wish I could use Excel like that, the best I can do is copy someone elses templates and try not to screw 'em up.....:ummm:

WIKDMAX · May 8, 2011

Maxine said:
The spreadsheet as you opened it is set for first gen Venture with Venture final drive. Change the bike model to #4 and the final drive to #2 if yours is a stock Vmax setup. Also input your correct tire size in the pink boxes as well.

OP. Very nice spreadsheet by the way Thanks for your effort and contribution.

Regards,
R

Thanks, now I understand it all.

dingy · May 8, 2011

I tweaked spreadsheet a little more.

At top left of sheet I put a heading in red as to what sheet is set for.

Example: 1st Gen Venture Transmission with a 1st Gen VMax Final Drive

Also added pull down boxes to most of the user input fields to limit data selection

I did submit this to the VMax Outlaw sight.

Gary

gamorg02 · May 9, 2011

i tried to move this to the drivetrain section to sticky it but it got moved to the 2nd gen technical, and i don't have access to move it to gen1 drivetrain, can someone do that for me and sticky it?

Speed in gears excel sheet

Help Support VMAX Forum:

dingy

Well-Known Member

Attachments

dingy

Well-Known Member

RaWarrior

Well-Known Member

WIKDMAX

Well-Known Member

Maxine

Well-Known Member

Rusty McNeil

Well-Known Member

WIKDMAX

Well-Known Member

dingy

Well-Known Member

gamorg02

Well-Known Member

Similar threads

Latest posts

Speed in gears excel sheet

Help Support VMAX Forum:

Well-Known Member

Attachments

Well-Known Member

Well-Known Member

Well-Known Member

Well-Known Member

Well-Known Member

Well-Known Member

Well-Known Member

Well-Known Member

Similar threads

Join the conversation!

Join today and get all the highlights of this community direct to your inbox. It's FREE!