Any question answered...

Thanks! I'll take all this into account and see if I can source some second hand leather

Slightly random question (possibly with no answer).

I have a string of numbers and would like to return these other numbers. I'd like to do it with maths functions rather than things like vlookups, if statements, etc. I thought I'd be able to wangle something using mod 3 but no luck that I can work out. Any suggestions?

1 Attachment

. (rubbish answer)

Something like this?

mod(3 - mod(Input, 3), 3)

mod(3 - mod(Input, 3), 3)

Outer mod is unnecessary.

=3 - mod(Input, 3)

should do it.

Does this mean images in PMs aren't private if you've got the link? Oh dear...

But then for input 12 (e.g.), you get 3 instead of 0.

Good point!

(Sums up my day, trying to do too much and getting most of it wrong.)

. (new page never mind)

However, I do have the feeling there's an easier solution I'm overlooking.

=MOD(-Input,3)

Although LibreOffice is giving me -0 for an input of 3 so you may need:-

=ABS(MOD(-Input,3))

Ah there we are! I thought something like that should work, but for some reason my mind went in the direction of shifting the input instead of taking it as a negative number.

Cheers, it's a long and narrow road to handlebar heaven.

Does this mean images in PMs aren't private

Nothing you upload to the Internet is private

These ones, just ordered from SJS in the end. Cheers.

Cheers and @SwissChap

I'd found a few solutions giving me 2, 1, 3 but none with 2, 1, 0 and particularly none so simple.

Not if the pictures I've seen are anything to go by

Glad to help, well, until @Greenbank had the better idea anyway :D

Just put a 1*11 group on the misses mountain bike. It's got an old school 135*9mm qr rear end (the bike that is).

Its running a 32 t narrow wide on the inside position of the crank and I've got all the bb spacers on the non drive side.

It's got 46 t rear cassette.

When back pedaling when on the 46 the chain falls down the cassette. It does this from the top (so I think the mech is not the issue).

The chainline looks to be the issue, but I can't do much more to bring the chain ring inboard. Do we think the monster cassette is the problem? Do these big cassettes struggle more if the chain line isn't bang on? I've never had similar issue with other cobbled together builds but I've never used a cassette this big. Perhaps a 42 would be better. Does boost spacing improve chainline for these big cassettes?

Do we think the monster cassette is the problem?

No, back-pedalling is the problem. All bikes with multiple sprockets will tend to do this when the chain is on the big sprockets.

Hmmm, I've not noticed this in the past.

To test, I compared it to my 1x10 mountain bike. It's running a 30t to 42t on a boost rear hub. You can back pedal to your hearts content and it doesn't flinch.

What sort of price would I expect to pay for a rear triangle to be cold set to 130 and possibly straighten a rear dropout? (idk if the NDS is definitely out of line.

Longer stays?

Maybe. It's on a 29er though, so the stays can't be that short.

I get the idea its just a thing that happens. I dont think the big cassette is helping.

Does boost spacing help chain line for the big rear cog? In my head, it would put the cassette further out, but then I think boost chainrings/cranks normally put that out by the same amount too.

In my head, it would put the cassette further out

It does

but then I think boost chainrings/cranks normally put that out by the same amount too

They do*

*...ish. I don't think it's a straight 1:1 compensation.