Page 1 of 4
Lambretta Gearbox Visualiser UPDATED: NEW VERSION
Posted: Thu Mar 19, 2009 11:51 am
by 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)
Re: Lambretta Gearbox Visualiser
Posted: Thu Mar 19, 2009 12:27 pm
by 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.
Re: Lambretta Gearbox Visualiser
Posted: Thu Mar 19, 2009 12:41 pm
by Avantone
Ian Hepworth wrote: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.
Re: Lambretta Gearbox Visualiser
Posted: Thu Mar 19, 2009 2:27 pm
by 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
Re: Lambretta Gearbox Visualiser
Posted: Thu Mar 19, 2009 4:26 pm
by 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
Re: Lambretta Gearbox Visualiser
Posted: Thu Mar 19, 2009 6:41 pm
by davidblythe
excellant very useful
Re: Lambretta Gearbox Visualiser
Posted: Thu Mar 19, 2009 8:53 pm
by J1MS
I Dont know how you did it, but very good and user friendly...
Re: Lambretta Gearbox Visualiser
Posted: Thu Mar 19, 2009 9:00 pm
by sean brady scooters
nice work Avantone............
Re: Lambretta Gearbox Visualiser
Posted: Thu Mar 19, 2009 9:22 pm
by cryogenic
It works well done mate
Re: Lambretta Gearbox Visualiser
Posted: Thu Mar 19, 2009 9:40 pm
by paulmgreen
Brilliant work mate.......
If i see you at a race meeting... I'll buy you a beer!