Scooterotica

That’s brilliant work mate, excellent work. This has got to be the best gear box spreadsheet to date.

Now we all need to get into the work shop and build a database of all the different tyre circumferences.

DMC wrote:That’s brilliant work mate, excellent work. This has got to be the best gear box spreadsheet to date.

Now we all need to get into the work shop and build a database of all the different tyre circumferences.

Here's all the 10" Schwalbe stuff

Weatherman

http://www.mbdevelopments.co.uk/schwalb ... h_tyre.php

Raceman

http://www.mbdevelopments.co.uk/schwalb ... h_tyre.php

Paceman

http://www.mbdevelopments.co.uk/schwalb ... h_tyre.php

Powertrack

http://www.mbdevelopments.co.uk/schwalb ... h_tyre.php

Classic

http://www.mbdevelopments.co.uk/schwalb ... h_tyre.php

Ian Hepworth wrote:

DMC wrote:That’s brilliant work mate, excellent work. This has got to be the best gear box spreadsheet to date.

Now we all need to get into the work shop and build a database of all the different tyre circumferences.

Here's all the 10" Schwalbe stuff

Weatherman

http://www.mbdevelopments.co.uk/schwalb ... h_tyre.php

Raceman

http://www.mbdevelopments.co.uk/schwalb ... h_tyre.php

Paceman

http://www.mbdevelopments.co.uk/schwalb ... h_tyre.php

Powertrack

http://www.mbdevelopments.co.uk/schwalb ... h_tyre.php

Classic

http://www.mbdevelopments.co.uk/schwalb ... h_tyre.php

I can build all of those options into the spreadsheet fairly easily - I'll get an updated version out soon.........

I've made some improvements to the Visualiser:

I've dropped the Macros in favour drop-downs (Tidier interface, less threat of virus and quicker to update/maintain)
I've added tyre circumference for the whole Schwalbe range of tyres (I've contacted Michelin, Bridgestone and Dunlop for any technical data they can give on their tyres.
Added the details for the DGT Pacemaker box currently being tested
Still got some issues running it in OfficeX on MacOSX
But works great on XP and Openoffice on OSX

If you like it you can also subscribe, and I'll send you new versions.

Lambretta Gearbox Visualiser

Thanks for the feedback so far - I'll try to build as much into future versions

I've got all the J, Lui and lambro gearboxes in a few excels somewhere, will send them to you in the next few days.

As you said, now works in OpenOffice. Brilliant. Thanks

Well Tony it just gets better

Spot on

Smiffy

Ian Hepworth wrote:I've got all the J, Lui and lambro gearboxes in a few excels somewhere, will send them to you in the next few days.

Found this on the LCGB forum:

J/Luna Technical Details


Vega

Cluster 9, 13, 16, 20

Loose gears

1st = 49 teeth
2nd = 36 teeth
3rd = 42 teeth
4th = 39 teeth

Primary Ratio 46/13

Stroke = 44mm

ConRod length =

Bore = 46.4mm


J125 four speed

Cluster 11, 14, 16, 19

Loose gears

1st = 48 teeth - 98.70mm dia
2nd = 44 teeth - 91.50mm dia
3rd = 37 teeth - 83.85mm dia
4th = 34 teeth - 79mm dia

Primary Ratio 45/14


Stroke = 48mm

ConRod length =

Bore = 57mm


J125 3 speed

Cluster 11,16,21.

Loose gears

1st = 48 teeth - 98.70mm dia
2nd = 42 teeth - 89.10mm dia
3rd = 37 teeth - 79.20mm dia

Primary Ratio 45/14


Stroke = 48mm

ConRod length =

Bore = 57mm


Cento

Cluster 10,15,21

Loose gears

1st = 48
2nd = 43
3rd = 39

Primary Ratio 45/14

Stroke = 48mm

ConRod length =

Bore = 51.0 mm



Lui\J50 Deluxe

Cluster 9,15,20

Loose gears

1st = 58
2nd = 53
3rd = 46

Primary Ratio

Stroke = 34mm

ConRod length =

Bore = 38mm

Early J50

Cluster 10,16,22

1st = 67
2nd = 64
3rd = 56

Primary Ratio 45/14



Late J50

Cluster 9,14,19

1st = 58
2nd = 54
3rd = 47

Primary Ratio 46/13

I can't choose tires from the drop down menu or alter the tire circumference. It wants a password to unlock the page.

GP Kevo wrote:I can't choose tires from the drop down menu or alter the tire circumference. It wants a password to unlock the page.

PM sent......