Any question answered...

Got an 11-32 cassette.

Going to run it 1x11.

Any recommendations for what size chainring I should look for? Mainly commuting and the odd foray into the woods.

42 i'd say

I commute to hilly south with 42t and 11-36

Perfect. cheers.

Funnily enough I have a set of WI ENO cranks running a 42. Any ideas if they'll work with 11speed, or should I just stick to road cranks and a NW ring?

@HoKe @edscoble @Howard

Thanks. Burls reckon it's probably okay, and so do I. Will keep riding it and just keep an eye on it. Hopefully it wont just spontaneously combust and if it does fail it would be with some forewarning.

Gutted though.

Where can I buy a Whiskey RD+ fork?

Is there a boot-mounted bike rack that I'd get on here?

1 Attachment

This looks like it would probably do it. Anyone have any experience with it?

https://www.saris.com/product/solo

Had a bones on a Fiat 500. Very vertical glass and it worked ok.

no idea about that, last time I ran those cranks 1x was with 9 speed. Cheap road cranks and a superstar NW would be more appropriate.

Figured as much.

The cranks are too nice to be lying about. Will chuck them on the 29er

@Dammit is your man for any Volvo estate x bike combinations

I'd always advocate fitting a tow-hitch and then a tow-hitch mounted carrier, Soul was selling a very nice one recently. They're a lot, lot better than attaching to the boot itself, as (amongst other things) you can still open the boot with all the bikes loaded when you have a tow-hitch mounted carrier.

I have made a route in RWGPS - I want to upload the GPX or the TCX into another app to check the elevation as I'm not sure it is correct. What allows me to do this?

I tried garmin connect but it failed when i tried to upload either file.

Strava? MapMyRide? Fix the file and try Connect again?

gpsvisualizer.com has a good range of tools.

Some insurance companies will lower your insurance premium if you've added a tow hitch too

Strava also returns an error. It needs time data.

Mapmyride works though!

My partner and I would like to have a shared debit card account with two cards, that we can pay our monthly bills from (pref by DD - but that isn't a deal breaker). Are there any Monzo/Revolut style pre-pay services out there that would fit our need?

To be clear, I'm trying to avoid having another bank account and all the crap that comes with that.

So I'm trying to create a sheet in Google which scores and ranks some software I'm testing.

Each software brand is a row. There are 9 brands to trial.
Each column is a function. There are 8 functions to review.

I want to score each column out of 10 (1 = low, 10 = high)

I want to add different values to each column. (i.e. some columns are 'worth' more than others).

How can I create a function or formula that offers a percentage score based on weighted column scores?

After all the gumpf the first row of software is '6' and the column attributes start at Column D which is weighted 8 out of 10.

Other column weights:

D=8
E=9
F=9
G=10
H=5
I=5
J=5
K=5

Never used Google Sheets so can't see any obvious solutions in the list of functions. Any takers that can explain it to me?

You total weights are 56, so the maximum score is 560. Just multiply the score by the weight for each cell, sum the products and divide by 5.6 to get a percentage. In the cell representing the eventual percentage for row 6, you want

=((8*D6)+(9*E6)+(9*F6)+(10*G6)+(5*H6)+(5*I6)+(5*J6)+(5*K6))/(56/10)

I've got a similar sheet which weights various columns differently, and I put the weights in a row above the data so that I can adjust them easily, if you do that you need to change the weighting numbers to absolute references to the cells containing the weights, and you need to change "56" to a reference to the cell containing the sum of the weights

Thank you for this - trying to get my head around it.

I found something similar online which had the function:

=if(sum(D6:K6), SUMPRODUCT(D6:K6,D6:K6,$D$5:$K$5)/(10*sumproduct($D$5:$K$5,$D$5:$K$5)),"")

I found something similar online which had the function:

That's just a tarty version, having the weighting factors in row 5 and returning an empty string if you haven't entered values in the row 6 scoring cells.

Obviously due to thickery I'm getting a formula parse error on your version when I paste the function from post #81953 into cell C6.

This is how my table looks:

1 Attachment

Obviously due to thickery

Mine, not yours, in all probability. I use OpenOffice, not Excel or Google, so your syntax might be different from mine.