rear suspension linkage spreadsheet

[erik]

I made one, it'll calculate the effective spring force vs suspenion travel and effective spring rate vs travel (and could be modified to calculate other stuff as well). I think it works properly...

Anyway, here it is in case anyone finds it useful. Feel free to copy it or modify it or what ever. It was originally made in OpenOffice. There's an Excel version too, but some of the graph display stuff (like labels and one of the lines) doesn't display quite right, but should be fixable (or work-around-able). And there's a .pdf going over the calculations.

http://cid-b37a983fa606d24a.skydrive.live.com/browse.aspx/Public

[Red01]

These values are for a B4, right?

[erik]

The spreadsheet has 3 sheets for setups/bikes, I've put the measurements for my b4 in one and my 1999 sv650s in the other two. I'm not really sure how accurate the b4 spring rate is or the frame measurements, the easiest way to get them was to take a photo (zoomed in, standing back to reduce perspective effects) and then take measurements from the image in a CAD program.

But it's set up so you can put the measurements from any bike with a similar 4 bar type linkage into it and it'll show you the graph.