I've improved this little bit of software to help evaluate whether a Lambretta gearbox setup is suitable for it’s application, find a solution to gearing issues, or help design a setup to suit specific engine output characteristics.
This new version now gives a side by side comparative view so that you can enter your current setup in the left hand pane, and then have a play with ratios, sprockets and tyres dynamically in the right hand pane to see the difference.
There is also data on 5-Speed boxes, “dealer†close ratio boxes, extended tyre data including Dunlop TT92GP and SAVA MC20 for the racers. Special thanks to Ian Hepworth who provided data on Lambro and Lambretta small frame boxes.
It should be relatively intuitive, but feel free to use this thread for help or to highlight bugs.
To run this you need Excel or an equivalent (Openoffice is very good and is free).
It's all FREE so help yourself, I'd just ask people NOT to host it themselves on their own sites, but to link to mine so I can track usage.
Download here http://www.tonycassidy.com
NEW AND IMPROVED GEARBOX VISUALISER!
-
- registered user
- Posts: 298
- Joined: Wed Jan 07, 2009 7:19 pm
- Location: Cheam, Surrey
- Contact:
sweet work
-
- registered user
- Posts: 221
- Joined: Thu Jan 29, 2009 1:45 pm
- Location: Norwich
- Contact:
Good work mate
Je fettle - Tu fettle - Il fettle - Nous fettleons - Vous fettlez - Ils fettlent
"Broadsword calling Danny boy ,Broadsword calling Danny boy ,over "
"Broadsword calling Danny boy ,Broadsword calling Danny boy ,over "
- jonny snatchsniffer
- registered user
- Posts: 277
- Joined: Mon Jan 12, 2009 11:53 am
- Location: camberley, surrey
- Contact:
thats good stuff, can you do one for vespa smaalframes as the one on scooter help doesnt have all the available variations
- soulsurfer
- registered user
- Posts: 2539
- Joined: Thu Jan 08, 2009 2:43 pm
- Location: The Garden Of England
- Contact:
Great spreadsheet while using my computer at home, but doesn't work with Google Docs, parts missing etc. Can this be fixed Tony?
Turn On, Tune In, Cop out!
-
- registered user
- Posts: 297
- Joined: Wed Jan 07, 2009 7:41 am
- Main scooter: Lambretta GP
- Location: Bromley, Kent
- Contact:
A response to a question on LCGB that maybe useful if you haven't got a dyno sheet.
Failing that, you can use an "arse-dyno". For instance assuming you've got a reasonable accurate speedo (stop laughing), pull away and get it straight into 3rd gear. Hold the throttle wide open and note the speed at which the engine starts to get hold of the gear. If you then feed your setup into the visualiser, adjust the "minimum" value until the bottom of the green bar in 3rd gear equals the speed you noted on the road - this will approximately be your minimum usable RPM.
Using the same methodology, your "maximum" RPM will equate to the speed in 3rd gear when your arse says it's no longer really accelerating hard, but just making lots of noise and will be the speed at which you'd naturaly feel was right to change up (I say use 3rd because 2nd is too low to feel what your after, and if you're over geared, 4th may be too high to actually hit the maximum.
Again using the same methodology, the red line is simply that. The maximum speed you can hit in 3rd beyond the point where you'd naturally want to change up.
Not particularly accurate, but you'll get an approximation.
It's at this point I suppose I should say be careful, and keep your eyes on the road
Hope this is (sort of) helpful............
Ideally you'd have a dyno sheet and would enter the RPM where the power/torque really starts to pick up.bootros wrote:I've played around with the previous version quite a bit, very interesting thanks. How would you define the minimum usable revs?
Failing that, you can use an "arse-dyno". For instance assuming you've got a reasonable accurate speedo (stop laughing), pull away and get it straight into 3rd gear. Hold the throttle wide open and note the speed at which the engine starts to get hold of the gear. If you then feed your setup into the visualiser, adjust the "minimum" value until the bottom of the green bar in 3rd gear equals the speed you noted on the road - this will approximately be your minimum usable RPM.
Using the same methodology, your "maximum" RPM will equate to the speed in 3rd gear when your arse says it's no longer really accelerating hard, but just making lots of noise and will be the speed at which you'd naturaly feel was right to change up (I say use 3rd because 2nd is too low to feel what your after, and if you're over geared, 4th may be too high to actually hit the maximum.
Again using the same methodology, the red line is simply that. The maximum speed you can hit in 3rd beyond the point where you'd naturally want to change up.
Not particularly accurate, but you'll get an approximation.
It's at this point I suppose I should say be careful, and keep your eyes on the road
Hope this is (sort of) helpful............
-
- registered user
- Posts: 297
- Joined: Wed Jan 07, 2009 7:41 am
- Main scooter: Lambretta GP
- Location: Bromley, Kent
- Contact:
It's all just data so there's no reason why notjonny snatchsniffer wrote:thats good stuff, can you do one for vespa smaalframes as the one on scooter help doesnt have all the available variations
If someone can point me to the data, I'll build it...............
I'll take a look and find out why........soulsurfer wrote:Great spreadsheet while using my computer at home, but doesn't work with Google Docs, parts missing etc. Can this be fixed Tony?
Thanks
Your previous version really helped me with my choice of Gearbox.
Your previous version really helped me with my choice of Gearbox.