It’s just a phone :)

Nuts, no flippin way!

Hey, unfortunately I’m local to Biggleswade :( Some nice routes along the green sand ridge if you want to give chicksands a miss.

You’ve got to go out and have a knock, declaring overnight just sends out the wrong message. KP to go and send the message home to the aussie bowlers, and then go in with a day and a half to bowl them out.

Snukpak Softie, that’s all.

‘A day beyond expectation!’

The alcohol free Kopperberg Pear Cider tastes essentially the same.

What’s going on here then?

Yep, there ok. Quite thick though so you may need a longer rear skewer depending on the thickness of your dropouts.

Hey,

I think I have got it sorted :)

Thank you so much for all your help!!!

Cheers, Ben

If I had the start date in F2 and the end date in G2 could I simply change the formula to:

=TEXT(VLOOKUP(F2,A:B,1),”YY”)&”/”&TEXT(VLOOKUP(F2,A:B,2),”YY”

Or would I need to have this?

=TEXT(VLOOKUP(F2,F:G,1),”YY”)&”/”&TEXT(VLOOKUP(F2,F:G,2),”YY”

Thanks

Basically I have records for areas covered which have unique record numbers. They have a start date, and an end date as to how long they took to cover. I am entering to data for 75 unique record going back ten years. I need a column which will show the academic year based on the start date for each individual record. I am using pivot tables to analyse the data once it has all been entered.

Thanks again :)

This seems to work: =IF(AND(F2>=$A$1,F2<=$B$1),$C$1,IF(AND(F2>=$A$2,F2<=$B$2),$C$2,IF(AND(F2>=$A$3,F2<=$B$3),$C$3,IF(AND(F2>=$A$4,F2<=$B$4),$C$4,IF(AND(F2>=$A$5,F2<=$B$5),$C$5,IF(AND(F2>=$A$6,F2<=$B$6),$C$6,IF(AND(F2>=$A$7,F2<=$B$7),$C$7,IF(AND(F2>=$A$8,F2<=$B$8),$C$8,IF(AND(F2>=$A$9,F2<=$B$9),$C$9,IF(AND(F2>=$A$10,F2<=$B$10),$C$10,IF(AND(F2>=$A$11,F2<=$B$11),$C$11,””)))))))))))

But I think that this may be easier:

=TEXT(VLOOKUP(C1,A:B,1),”YY”)&”/”&TEXT(VLOOKUP(C1,A:B,2),”YY”)

Start Dates in Col A
End Dates in Col B

Cell C1 contains the date you want to get the academic year from.

Cell D1 contains the above formula.
Enter a date in C1 and D1 will find the relevant date range in Col A/B and extract the academic yy/yy.

Thank you all very much for your patience :)

This works:

=IF(AND(F11>=$A$1,F11<=$B$1),$C$1,IF(AND(F11>=$A$2,F11<=$B$2),$C$2,IF(AND(F11>=$A$3,F11<=$B$3),$C$3,IF(AND(F11>=$A$4,F11<=$B$4),$C$4,IF(AND(F11>=$A$5,F11<=$B$5),$C$5,IF(AND(F11>=$A$6,F11<=$B$6),$C$6,IF(AND(F11>=$A$7,F11<=$B$7),$C$7,””)))))))

But can you only nest up to seven?

Would this be easier if I could change the crossover month to August/September:

=IF(MONTH(A2)<8,YEAR(A2)-1&”-“&RIGHT(YEAR(A2),2),YEAR(A2)&”-“&RIGHT(YEAR(A2)+1,2))

I think I was repeating the default text…

Would this do it?

=IF(MONTH(A2)<4,YEAR(A2)-1&”-“&RIGHT(YEAR(A2),2),YEAR(A2)&”-“&RIGHT(YEAR(A2)+1,2))

Or:

=IF(AND(D1 >=A1,D1 <B1), C1, “”), IF(AND(D2 >=A2,D2 <=B2), C2, “”), IF(AND(D3 >=A3,D3 <=B3), C3, “”), IF(AND(D4 >=A4,D4 <=B4), C4, “”), IF(AND(D5 >=A5,D5 <=B5), C5, “”), IF(AND(D6 >=A6,D6 <=B6), C6, “”), IF(AND(D7 >=A7,D7 <=B7), C7, “”)))))))

So nesting?

This is what I’ve got:

=IF(AND(F2 >= $A$1,F2 <= $B$1), $C$1, “”),IF(AND(F2 >= $A$2,F2 <= $B$2), $C$2, “”),IF(AND(F2 >= $A$3,F2 <= $B$3), $C$3, “”),IF(AND(F2 >= $A$4,F2 <= $B$4), $C$4, “”),IF(AND(F2 >= $A$5,F2 <= $B$5), $C$5, “”),IF(AND(F2 >= $A$6,F2 <= $B$6), $C$6, “”),IF(AND(F2 >= $A$7,F2 <= $B$7), $C$7, “”)))))))

Showing FALSE, any ideas?

Do you not just need to close the AND argument with a bracket.

=IF(AND(R6 >= B1,R6 <= B2), R6, “”)

Thanks, it works!!!

That’s good if it’s a fixed value. The data entered will be a date which will fall between a start and end date for an academic year.

I have this which will calculate what it would be today:

=IF(MONTH(TODAY())<9,YEAR(TODAY())-1&”/”&RIGHT(YEAR(TODAY()),2),YEAR(TODAY())&”/”&RIGHT(YEAR(TODAY())+1,2))

But I am also having to enter the data retrospectively and don’t want to have to calculate the academic year manually.

I’m after having both the start date and end date in separate columns with the academic year in a separate column.

What about this?

=IF(AND(F2 >= B2,F2 <= C2, D2, “0”)

B2 C2 D2 E2 F2
01/09/2000 31/08/2001 00/01 12/12/2000

It’s not that I’m not happy with what I have got, more that it seems increasingly difficult to get everything right, and especially long term. Maybe it’s just me who has a black cloud over my head !?! :-)

Why not a cluster bomb?

Time is also a factor as well as branding. For example 10 years ago XT kit was beyond my price range, however today it is not. Before I made do with whatever I could get hold of and was perfectly happy. Now I have XT and seem to have had real difficulty in getting my drive train to work. It seems that the more high end products have greater intolerances to subtle differences. Chains; HG93 link pins as a case in point…

I think you have an element of it in individual ability. Still the principle applies to many things. Whilst I am very happy with my current bike, it seems to be a challenge to get it set up and running without any foibles. A bit like buying a TVR, great fun but bring some superglue!

Gotta be French stick with butter…

Call the new’s agencies, then when they come to film you, get your 4wd stuck in a small snow drift on the street and tell them how terrible it is you can’t get little Oliver to his tantric playgroup and you don’t know what he’ll do. Show them some soggy cucumber and ask how you are meant to make sandwiches with it and then tell them “you have never seen it this bad”.

Genius! :lol:

I think it’s this one: M772 http://www.chainreactioncycles.com/Models.aspx?ModelID=20700

This one: M771 http://www.chainreactioncycles.com/Models.aspx?ModelID=20698

Or this one: M773 http://www.chainreactioncycles.com/Models.aspx?ModelID=52299 (9 speed though)

How do they work then?

A short cage mech won’t be able to cope with the full range of gears you have there with triple front rings. I can only think that this might be an issue somehow, especially in terms of shifters/mechs working one day and then not the next.

The cassette is a 11/32 and the chainring is a 22/32/44. The XT mech is supposed to handle the range but with the chain long enough for big/big it is too loose for small/small. So I think that a longer cage mech may be the answer, oh and sealed cables!

I see another chap has posted that his cables froze today, can’t help thinking this may have been part of the problem.

Changing up from middle to outer and due to the friction the chain did not change up smoothly and dropped between!

Is that why my mechs weren’t working, cost me a chain!!!

Well I couldn’t comment on being overly heavy or not. What would cause a chain to jam between rings when shifting from the middle to the outer?

I guess I’m just fed up with the ongoing cost and uncertainty as to whether it’s set up right. Have a look and see if there’s anything obvious.
[/url] PA050031[/url] by sastrugi1977[/url], on Flickr[/img]

Because of the short cage mech the chain length restricts the available range. I tend to use mainly the middle for the bottom to middle on the cassette, and the top of the cassette in the big ring. Like I said this is not idea and I’m likely to change the mech for a longer cage thus allowing for longer chain with less lateral pressure in changing. However I clean and lube the chain once a week, if anything I would say their was too much lube on it. I just can’t figure out the shifters, I cleaned them on Sunday afternoon and they were fine. Bikes stored in the shed and I do wonder if the GT85 froze??? Getting to be an expensive hobby this!!!

Both the Shimano and KMC were new. In the case of the Shimano teh correct link pin was not used, in teh KMC it got stuck between the large and middle chainrings.

Nore have I before this current setup which kinda makes me think something is wrong.

Santa Cruz Chameleon (Small)
XT Shifters, Chainring, Front/Rear Mech and Cassette, KMC chain.

It is the short cage mech which does restrict the available range. I used GT85 to shift any water on moving parts at the weekend after a ride out, would this freeze inside the shifters?

What about the setup, any advice? Shifters and Mechs fine on Sunday afternoon, today not working at all…

What do you suggest? Singlespeed and leaving it in the garage?