Show us your.......newbie progress!

[Supersuperleeds]

Right, done the Eddington Number in Kilometres - 117.

This is the formula in excel that I use to give me the number of days that I have done a certain mileage
=COUNTIF($H:$H,">="&K6) H is the column all the daily totals are in and K6 is the day number. I then have the days going across row 6 and copy the formula across with the formula being in row 7. In row 8 I then have the following formula =IF(K7>=K6,K6,0)

The Eddington number is then returned with the following formula =MAX(K8:BN8)

All thanks to @SatNavSaysStraightOn for the Countif formula

 

[Nigelnaturist]

Heres mine in Access


Shows how many, above the next level, with a count in the bottom, in this case 48 rides over 50 miles with two to do, all I do when the next level is achieved is change it in the query.

 

[Torvi]

so hmm guys dont know if it should be like this but my front inner cog is getting rust already o0 ive got this bike since 3 months it might be because ive ridden it in any weather, at work it was often left outside so all the rain is pouring on it and it wont be better during winter... how to keep the rust away from bike?

 

[Nigelnaturist]

so hmm guys dont know if it should be like this but my front inner cog is getting rust already o0 ive got this bike since 3 months it might be because ive ridden it in any weather, at work it was often left outside so all the rain is pouring on it and it wont be better during winter... how to keep the rust away from bike?

Oil and keeping it cleaned, especially after every wet ride, the rust is likely to be from the chain, even the rings on my prowheel didn't themselves rust (mind you that could have been me keeping it clean), but more likely the chain, on the odd occasion I didn't clean after a wet ride there was the odd touch of rust, so maybe a better chain might help.

 

[Trevor_P]

Only done 41 rides in total - ever. Eddington number is 20. Have to work out a realistic target for next year I suppose

 

[Torvi]

Oil and keeping it cleaned, especially after every wet ride, the rust is likely to be from the chain, even the rings on my prowheel didn't themselves rust (mind you that could have been me keeping it clean), but more likely the chain, on the odd occasion I didn't clean after a wet ride there was the odd touch of rust, so maybe a better chain might help.

thanks for infos in the end aside just cleaning ill probably swap whole crankset and chain ive got the feeling like my carrera is downgraded by default, when changing front gears i have to jump from 1 to 3 to get on the outer gear, does it mean that it can have 3 cogs on front?

consider the question non existent i just so facepalmed myself and so facepalmed at halfords... you know what they did? im having a setup 1/3 which means i have 1st gear cog and third gear cog ive just inspected my crankset and there are holes for 2nd gear fit... think ill get myself some 44/48t 2nd cog just for sprinting ablity and third cog will be for downhills only then...

 

[Nigelnaturist]

thanks for infos in the end aside just cleaning ill probably swap whole crankset and chain ive got the feeling like my carrera is downgraded by default, when changing front gears i have to jump from 1 to 3 to get on the outer gear, does it mean that it can have 3 cogs on front?

consider the question non existent i just so facepalmed myself and so facepalmed at halfords... you know what they did? im having a setup 1/3 which means i have 1st gear cog and third gear cog ive just inspected my crankset and there are holes for 2nd gear fit... think ill get myself some 44/48t 2nd cog just for sprinting ablity and third cog will be for downhills only then...

So your saying its a triple, post a pic if you can, I a bit busy right now.

 

[Torvi]

It should be triple but they fit there a duo crankset logic pls and i was wondering why there are no infos on halfords bikes about amount of teeth on cogs etc, not even in owners handbook

Im now wondering if id go to them with this would they have to fit me a proper crankset with no charge or not, seriously how can you equip a bike with 3gear shifter, put there 2cog crankset and put it on market? I call for a scam.

 

[Nigelnaturist]

if the are Sora 3400 shifters they are designed for two/three on the front, chain rings look a bit worn, but the chain is quite clean, it actually looks more like a rivet hole than chain bolt hole, maybe @Big_Dave can say.

 

[Torvi]

ofc it's worn, im not giving my bike an easy life haha im going to get a carbon in a year anyway but im going to keep my carrera then still

question: if id get myself fsa tripple crankset, it will most probably fit there wont it?

 

[SatNavSaysStraightOn]

Right, done the Eddington Number in Kilometres - 117.

This is the formula in excel that I use to give me the number of days that I have done a certain mileage
=COUNTIF($H:$H,">="&K6) H is the column all the daily totals are in and K6 is the day number. I then have the days going across row 6 and copy the formula across with the formula being in row 7. In row 8 I then have the following formula =IF(K7>=K6,K6,0)

The Eddington number is then returned with the following formula =MAX(K8:BN8)

All thanks to @SatNavSaysStraightOn for the Countif formula

I have then used a 2nd formula =VLOOKUP(MATCH(0,G3:G167,-1),E3:G167,1, TRUE) (where column G is number of rides minus the Eddington number to find the value closest but not below zero) to find the Eddington number and the number of rides with that Eddington number =VLOOKUP(MATCH(0,G3:G167,-1),E3:G167,2, TRUE)
the next row down gives me the next one (=VLOOKUP((MATCH(0,G3:G167,-1)+1),E3:G167,1, TRUE)) and then a simple subtraction gives how many more rides are needed....(=M4-N4&" Ride(s)") the & simply adds on a text entry to the answer so it reads "8 Ride(s)"

oh and I just used the =CONVERT(B2,"km","mi") to convert between km's and miles. just switch km and mi in the formulae to go from miles to kms...

 

[Nigelnaturist]

ofc it's worn, im not giving my bike an easy life haha im going to get a carbon in a year anyway but im going to keep my carrera then still

question: if id get myself fsa tripple crankset, it will most probably fit there wont it?

You need to be sure the front left shifter will do a triple to be sure, see if you can get a modal number usually stamped on the reverse side of the brake handle if memory serves me well, and then you need to change the FD to a triple and make sure the bottom bracket is compatible

 

[Nigelnaturist]

I have then used a 2nd formula =VLOOKUP(MATCH(0,G3:G167,-1),E3:G167,1, TRUE) (where column G is number of rides minus the Eddington number to find the value closest but not below zero) to find the Eddington number and the number of rides with that Eddington number =VLOOKUP(MATCH(0,G3:G167,-1),E3:G167,2, TRUE)
the next row down gives me the next one (=VLOOKUP((MATCH(0,G3:G167,-1)+1),E3:G167,1, TRUE)) and then a simple subtraction gives how many more rides are needed....(=M4-N4&" Ride(s)") the & simply adds on a text entry to the answer so it reads "8 Ride(s)"

oh and I just used the =CONVERT(B2,"km","mi") to convert between km's and miles. just switch km and mi in the formulae to go from miles to kms...

Gee you don't half make it complex Emma.

 

[SatNavSaysStraightOn]

Gee you don't half make it complex Emma.

it as the only way I could get it to work the way I had set it up originally!...

 

[Torvi]

@Nigelnaturist
there is something on the rear of handle
MB
L8
34