Paging The Wheel Builders...

Discussion in 'Cycling Archive' started by Tosspot, Oct 11, 2015.

  1. Tosspot

    Tosspot Guest

    After about a year I think I have everything you could possibly want
    from an Excel spreadsheet to help build wheels. Including chain length
    calculations (plus warnings!).

    Now, it isn't free. The currency of this work is comments. You email
    me (email addie is correct) I'll send it to you and you will comment on
    it or be eternally shamed here.

    I ain't flogging it, I just want to buff it up before letting it loose
    in the BWW.

    Before commenting, *read* the intro!
     
    Tosspot, Oct 11, 2015
    #1
    1. Advertisements

  2. Tosspot

    Ace Guest

    Sounds good. I acquired a couple of MTB wrecks for 15 chf each two
    weeks ago and have made one really decent ladies bike and canibalised
    the other to update my old Cadex with rigid forks, A-head steering
    head and V brakes (yes, that was all an upgrade!) and am left with a
    steel Specialized frame which is doubling up as a static exercise bike
    as I recover from my major knee surgery.

    Anyway, one of the wheels has a broken spoke, and I've got a couple of
    other spare hubs, so I may be (re-)building up a wheel in the near
    future. I've done it before a couple of times, but not for years, so a
    handy reference would be... handy. send to
    please. Ta.
     
    Ace, Oct 11, 2015
    #2
    1. Advertisements

  3. Tosspot

    Tosspot Guest

    Right Gentlemen, it seems a few of you have more spare time than your
    spouses are aware of, so rather than reply to me personally, share your
    views here!
     
    Tosspot, Oct 11, 2015
    #3
  4. Tosspot

    Clive George Guest

    Ok, you've asked, so you get a copy of what I just sent :)

    Not bad. The first page is very familiar to anybody who's use Damon
    Rinard's, presumably for good reason.

    I like the idea of an electronic version of that bit of card which comes
    with the TM-1 and I always wonder about losing.

    I'm unsure about the "Spoke Tensions" tab - I get the feeling I ought to
    be able to pick eg "DT Champion 2.0/1.8 DB stainless", and it should
    work out the spoke tensions from the data in the "Measured Tensions"
    tab. It doesn't seem to be doing any of that.

    You've got a TM2 where I expect to see TM1 in cell A3 on the "Spokes" sheet.

    Where's your rim/hub database come from? I'm pretty sure some rims I've
    had in there on Damon's sheet (Mavic open sport) aren't on yours. That
    database is what really makes the spreadsheet useful.
     
    Clive George, Oct 11, 2015
    #4
  5. Tosspot

    Tosspot Guest

    Exactly. Damon used macros where there really wasn't a need, and istr
    you had to type stuff in instead of using a dropdown list. Macros are
    at the mercy of MS, note that last time of looking the Park sheet was
    broken because of this.
    That's why it's there. *Everything* in one place!
    What it's doing is taking the points from the TM-? chart, calculating a
    curve for them, then using that curve to turn a TM-? reading into a kgf
    value. You're right however, I set it up, *I* know how to use it,
    that's why *you* are commenting on it! I'll try and make that part clearer.
    So many tensionometers, so little time! I'll check which one I have
    (I'm sure it's the TM-2) and correct it.
    All over the shop, starting of course with Damons, a few from the
    internet at large/manufacturers. I might have even measured a couple
    myself. Feel free to copy it.
     
    Tosspot, Oct 12, 2015
    #5
  6. Tosspot

    Tosspot Guest


    Done. Let me know.
     
    Tosspot, Oct 12, 2015
    #6
  7. Tosspot

    Ace Guest

    Cheers, now my post finally cleared the mods. First impressions are"
    Wow. Thorough. Oh, hang on, what's this TM-1 and TM-2 thing? Oh, I
    see.

    I've never used a tensionmeter, just using musical tones instead, so
    perhaps you could also include that? Some examples at the usual source
    for all things http://sheldonbrown.com/spoke-pitch.html but not in the
    range of sizes you're listing.

    The rim and hub charts seem amazingly comprehensive, but I tend to
    have old stuff and even if it's got a maker's name on it it wouldn't
    always have the exact model, so real-world measuring advice would also
    be great.

    And lastly - dishing. It's great that you list the L/R angles, and the
    ideal L/R tension ratio, but is there any normal way of actually
    measuring these angle so precisely? In the past I've just dished a
    rear wheel as much as it seemed to need to be central between the rear
    stays with not a thought to angles, so this would be interesting, but
    how?

    Anyway, I'll report back if/when I've tried to use it in anger.


    Also would be useful for amateurs rebuilding old stuff to
     
    Ace, Oct 12, 2015
    #7
  8. Tosspot

    Tosspot Guest

    Yesyes, you weren't the only one. Alcohol and spreadsheets...
    I'll add that in, but the great thing with the tensiometer is to get to
    kgf. As a few of the wags put it, you *really* need a reason to go
    above 100kgf, so I aim at 95-100, and I've noticed when I get the wheel
    back a few months of beastings, they have usual lost a few kgf bringing
    them nicely into the 90-95 area.
    Now that is a good point. I'll add a sheet on how to measure the
    various parameters.
    I have a Park and Centrimaster stand and both use this technique, so
    it's a mystery to me as well, but since what I was working from (Damons
    sheet) had it I left it in.
     
    Tosspot, Oct 13, 2015
    #8
  9. I know of no way to measure the angles, but the tension ratio gives a good
    place to start if you are working with a tensiometer (and, given my cloth
    ear, I do).
     
    David Damerell, Oct 13, 2015
    #9
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.