Lambretta Gearbox Visualiser UPDATED: NEW VERSION

[Avantone]

I hosted a gearbox calculator recently for Monty. Shortly afterwards I knocked this up taking the idea a stage further in Excel and thought I'd share it.

I've tried to get a graphical visualisation of the overlap between ratios that changes as you adjust the variables (gear ratios, sprockets, tyres etc).

It needs macros to run, so you would have to "enable macros" when you open it, and I've tested it in Office 2003 on XP, and OfficeX on Mac OSX 10.5.6 and 10.4.11.


Download Zip file here

Let me know what you think, issues, functionality or improvements (I'm not a programmer but I'll do my best)

[Ian Hepworth]

That is excellent, lovely bit of work.

It's only when you look at it that way that you really see the drop from 2nd to 3rd on a rallymaster. :0

Only thought, is there something you can do for 3 speed engines then it opens it up for the J and lui folk, I suppose you could just put made up figures in the 4th gear section.

[Avantone]

That is excellent, lovely bit of work.

It's only when you look at it that way that you really see the drop from 2nd to 3rd on a rallymaster. :0

Only thought, is there something you can do for 3 speed engines then it opens it up for the J and lui folk, I suppose you could just put made up figures in the 4th gear section.

Thanks Ian

If anyone can give me some detail on the available box ratios and sprockets for 3-speeders, I'll write something similar.

Also if I've missed anything on this one (DJ CR Boxes, Omega 5-speed etc) I'll add them in later too.

[RinB]

Nice one Tony

All compact and in one sheet
The one I use which I did years ago I had to flip between sheets

Brill

Smiffy

[MarkH]

Wow - this is easily the best gearing calculator I've seen.

Any chance you could make it compatible with Office 2008 (Mac/PC)? I can't get some of the macros to run on my Intel Mac - OSX - Office2008

[davidblythe]

excellant very useful

[J1MS]

I Dont know how you did it, but very good and user friendly...

[sean brady scooters]

nice work Avantone............

[cryogenic]

It works well done mate

[paulmgreen]

Brilliant work mate.......

If i see you at a race meeting... I'll buy you a beer!