Plenty of Fist
There’s a Dr Freud on the phone for you.

I do enjoy a good Freudian slit

Now onto 3 chicken breasts.

Don’t want them all, but BBF date is today and I can’t take them with me. Good job I like a bit o’ protein…

You’ll feel low for a bit but just move on I’ve never regretted ending relationships.

Split with the woman I’d lived with for 6 years some months back, felt v. sad for 5 days. All of the next week I was very happy. Bits of up and down over the next few weeks and, although it was a though thing to do, it was the right thing.

Plenty of Fist has been a recent source of entertainment and appears to have delivered me a rather cute MTB riding chika! There’s a life to lead after the one you’ve currently got…

run for the hills

I was gonna say there’s life after death, but resisted – now I just can’t help myself \m/

I also like the feeling of security being attached to my pedals when I get any kind of air.

Danger Will Robinson!

After years of riding everything clipped in I trained myself to use flats in < 3 weeks. Now it’s clipped in for XC and flats for play-time. I apply technique much better on jumps & drops on flats, but am tempted to go back to clips for DH – there are hardly any corners you *need* to stick your foot out for*, even if it is fun to do 🙂

*Unless it’s muddy with twistiness.

get my foot down in berms more.

They’re berms, you don’t need to do this at all.

flats without shin guards

Not been a problem for me

What’s the Latin for “get the **** out of my courtroom”?

Why butter? Surely makes the bread less absorbent?

Tin of cream of tomato and a bag of chip

This sounds quite good! I’m partial to a chip korma 🙂 Tray of korma sauce from curry-house, next door for bag o’ fried delight from chippie and I’m a happy boy

Fully iDave compliant ham salad – might even have some lentils later – woooooo!!

cats only meow at humans

Bollox.

I’ve had a couple of moggies that started getting very noisy in their dotage – apparently due to dementia. A 2 years old, though? To the vets…

I can’t BH either – it doesn’t concern me. I could do it if my shoulder wasn’t ruined – some how it doesn’t stop me mountain biking…

No worries, HTH

For larger amounts of data I’d probly try cramming it all into an array and then splatting it all on to the second worksheet at once to speed it up*, but here it shouldn’t matter.

*Not that this always works…

Excel is a dangerous tool I think!

Not as dangerous as some of the tools who use it

The below prevents unnecessary re-calculation and, most importantly no rendering to screen – which *should* speed things significantly.

It’s annoying how the indentation will be lost here…

Option Explicit
Sub Test()
Dim i As Integer, NPV As Integer, AMP6 As Integer, AMP7 As Integer, AMP8 As Integer

With Application
.ScreenUpdating = False
Calc_Man

For i = 2 To 5000
‘Select the data from the calculation sheet
With Sheets(“Catchment solution”)
.Calculate
NPV = .Range(“c154”).Value
AMP6 = .Range(“c155”).Value
AMP7 = .Range(“c156”).Value
AMP8 = .Range(“c157”).Value
End With

‘Paste the data for use in the percentile calculation
With Sheets(“Monte Carlo Model”)
.Cells(i, 1).Value = NPV
.Cells(i, 2).Value = AMP6
.Cells(i, 3).Value = AMP7
.Cells(i, 4).Value = AMP8
End With
Next i

Calc_Auto
.ScreenUpdating = True
End With
End Sub
Sub Calc_Man()
‘Turns on manual calculation’
With Application
.Calculation = xlManual
.MaxChange = 0.001
End With
ActiveWorkbook.PrecisionAsDisplayed = False
End Sub
Sub Calc_Auto()
‘Turns on auto calculation’
With Application
.Calculation = xlAutomatic
.MaxChange = 0.001
End With
ActiveWorkbook.PrecisionAsDisplayed = False
End Sub

^ That’s kinda what I was thinking. Often do something other than the requestor asks for to get the desired result…

Missing end cap?

Which cranks do you have?

Email the workbook with the calculations to me if you like.

I’m pretty sure they make one huge tube and squeeze that into all the little tubes?

You. The. Man.

!

http://www.ebay.co.uk/itm/Shimano-spin-bike-pedals-/111279145750?pt=UK_sportsleisure_cycling_bikeparts_SR&hash=item19e8c10316

What sort of place has an endless stream of buses so that one is always available at the exact moment any one of dozens of people hit the bottom?

Pearce Cycles – they do it right. It can get like a caucus race. I’ve managed 23 runs in a day at Hopton cos there was always a trailer being loaded when I got to the bottom.

At Cwmcarn & Revolution you get enough time to grab a drink in between runs, but no queuing cos they don’t overbook and do dumb things like get single ticket bikes on board and off again when day ticket holders show up.

Mate, can’t be much worse than BPW on Sat – the afternoon was horrendous.

Cwmcarn uplift was fine – very windy at the top at times and you’d have to be insane to try the jumps at the bottom, but otherwise just a couple of touches of rain and all was good.

Kinda dreading going this Saturday…

It’ll still be fun though 🙂

queue for the minibus

Queuing? **** that! I’d rather go somewhere well organised!

You could have emailed – come to think of it I’ve changed email address though… 🙂

Didn’t understand your question – mail me (have updated).

Julian A is clearly a very motivated person! I’m self taught, but have only learnt what I have by seeing the use of it in whatever job I’ve been doing at the time.

As a career contractor I experienced this:

Had some really, really shite times while the economy was in the doldrums.

Once you start making money make sure you save plenty!

Hi rob, where is the code module behind the input sheet?

If you still want to know then:

With Excel open 🙂 press Alt+F11 (opens scripting environment), on left double click on the sheet name the code is to run on, paste code from up there ^ into the main window.

Alt+q returns you to Excel. Save workbook. Will run from now on.

Cheers guys.

Probly should have mentioned 26″. I am a bit of a skinny dweeb 🙂 What are Manitou like these days? Is there a reason they’re cheap?

With no real world experience the training courses aren’t worth much.

Most people with half a clue about PCs and what they’re for can get a job as an information analyst in the NHS – most people who do it are drones who don’t understand how to make a computer work for them.

So why would you want to do that? Exposure to a variety of software SQL/Bus Objects/Qlikview etc. Sidestep into IT in the NHS maybe?

And they pay for your training 🙂

The other frame I would have gone for would have been a Spesh SX, but as they’re rocking horse poo I didn’t have that option – at the time. Saw one (modern design, maybe 2011?) on ebay about 6 months ago that went for about £400. Was tempted, but it would have been silliness to have 2 of pretty much the same thing.

Banshee Rampant owner here – after up reading up on loads of these kind of bikes it was the only one that ticked all the boxes (aside from price – parting with a grand for a frame was a tough thing to do!). Most have a concentric BB which, apparently don’t pedal too well.

Can’t say it’s a great climber as it’s tiny and with a 50mm stem can be an effort – also can’t fit a front mech, meaning technical climbing is very hard. It does work well as an all rounder as it’s light and strong, descends well and is great for jumps and drops.

Not sure it’s what you’re looking for though?

In x 3

http://m.pinkbike.com/news/Schwalbe-Double-Chamber-System-first-ride.html

See also:
http://nuetech.com/tubliss/#performance

Excel is almost always the wrong tool for the job. 😉

Pen & paper would probly do it.

JulianA – Member
Dim Old_B1_Value, New_B1_Value As Integer
Doesn’t this make the first variable a Variant value type and the second an integer?

Sure does – good spot. Not done any of this for a few years and got confused with declarations in something else.

RobHilton’s solution will work but I confess I don’t like what you are doing

I just do what I’m asked without questioning the wisdom 🙂

Not tried SLXs – have Zees and have had a bit of a time with them 🙁

Great breaks, have 2 sets – on a DH bike a 4X bike. Make sense on the DH, but overkill on the 4X – very powerful!

However… have had 4 levers and 1 caliper replaced due to leakiness, few days ago had them bled at a reputable LBS, the right lever reservoir is now leaking.

Maybe just bad luck, but it’s beginning to piss me off.

Edit: I’d still rather have them than Avids

http://www.happydonkey.co.uk/iberital-mc2-grinders/

Cold war style casing (and the fact the go button fell off mine the first time I pressed it) aside… damn good grinder. Apparently has the same internals as much more expensive models.

And then it occurred to me – there’s a couple of unnecessary lines in there – use this instead:

Option Explicit
Public i As Integer
Private Sub Worksheet_Change(ByVal Target As Range)
Dim Old_B1_Value, New_B1_Value As Integer

If i = 1 Then Exit Sub

Old_B1_Value = Range(“B1”)

New_B1_Value = Old_B1_Value + Range(“A1”)

i = i + 1

Range(“B1”) = New_B1_Value
End Sub

Unusual request – Rob likes as fiddly challenge

Stick this in the code module behind the input sheet (only works once – e.g. enter number, close workbook, open workbook to re-set):

Option Explicit
Public i As Integer
Private Sub Worksheet_Change(ByVal Target As Range)
Dim Old_B1_Value, New_B1_Value As Integer

If i = 1 Then Exit Sub
With Sheet1
Old_B1_Value = Range(“B1”)
New_B1_Value = Old_B1_Value + Range(“A1”)
End With

i = i + 1

Range(“B1”) = New_B1_Value
End Sub

HTH

Edit: And, of course, format and annotate it properly 😉

Roadkill

Lynch by far.

Lynch thinks Dune is such a failure

He’s right – it’s utter shit. The most wooden acting by everyone involved and what appears to be a reliance on special effects of big wiggly worms and a “floating fat man” to carry a weak effort. Of course the film of a book is rarely as good as the book, but it’s like nobody could be bothered to try.