forteh

Wait, you have a bike?

Not angry as such... This morning whilst retaping my front tubeless wheel on the intense, Persephone was playing with the upturned bike, spinning and the cranks and the back wheel as she has done since she could walk (16 months ago now ). She managed to catch the tip of her little finger on her left hand in the rear disk and took a slice of skin off. A bit of bleeding, quite a lot of whimpering, a plaster applied and she's all good. Minus daddy points for not catching her in time, plus adult points for doing first aid This evening, whilst fettling some thing on the front wheel I spun it to check clearance on the forks. Typically the tip of my left index finger was in the disk. Sliced 3mm off the side of the nail and finger, much blood and a hefty bandage courtesy of the wife. Extra minus adult points for being a retard

Absolutely, complications do arise and can rarely be predicted I must admit that my judgment is largely based on Charlotte's experiences as a mother over the last 11 years. Her first was in hospital age 18, she was left in a corridor on a trolley, labour started and she had to walk to the nearest midwife and tell her that she was in labour; at which point she was told that her baby couldn't possibly coming already and to get back into bed. Lily was born a few hours later and they were effectively held prisoner in the hospital for the next day or so when nothing was wrong. Reuben was planned water birth at the new local birthing centre and it was a much better exerience. In the morning Charlotte had told the midwives that she would be giving birth that night and she was told again that it would be a couple of days, low and behold he was born that night. As said apart from the 12/20 week scans, Persephone was hospital free; that said there were grave errors made on the part of the midwifery team, they initially recorded Charlottes height 4" too short which put her BMI into the red. From then on despite phoning multiple times to get her notes corrected she still got harassed by the consultant saying that they "couldn't promise her a live baby if we home birthed" (they can't promise a live baby in hospital!), that she was going to be prescribed blood thinners (when she already has a blood clotting disorder and would have subsequently bled out) and got called "one of those women and to come back when she's seen some sense". Additional to that the consultant was under the impression that this was Charlotte's first birth, not third. Charlotte eventually went through her notes, corrected everything with red pen and hand delivered them to the maternity unit requesting them to update their notes accordingly. The midwives were great, the consultant was atrocious. The midwives arrived 2 hours into labour, couldn't get the gas and air to work (duff regulator on the bottle) so the whole process was done with nothing more than 37°C water and a darkened room Call it mothers intuition or just the wife is always right but I trust Charlotte implicitly on such matters and she was absolutely correct. Sorry for the rant, there is a lot of stigma about home birth and since the 50's people have been co-erced into believing that hospitals are the only place you can safely have a baby... Happy 10 weeks to Eleanor, many more to come - enjoy it, fatherhood's awesome

Of course, midwives are normally on hand (although they only arrived 15 minutes before Persephone) to help keep things under control and blue lights are always available if needed (or just drive there as it's likely quicker!). Granted, home birth isn't for everyone but at least you can control the environment, no bright lights, no urgency to clear the bed for the next, the oxytocin flows freely and a bacon sandwich 20 minutes after the event I was 100% involved, the midwives just stood by and signed the paperwork at the end having done their checks. It was Charlottes third birth though so she does know what she's doing and when things aren't right. Still a toss up between birthing and getting married as life pinnacles

I never had to bring Persephone home, in fact the only time she's been to hospital was for 12 and 20 week scans and then the weight / toe count check after birth. Home birth is the way forward, hospitals are nasty places for a new born

Just run a full length outer cable

Persephone is two today, best 24 months ever! Couldn't want for a nicer child or experience; from birth to washing hundreds of nappies, it's all been amazing Currently snoring her little head off having crashed on the sofa!

The world is definitely round, it's also completely flat as well!

Where's the ™?

Post stripped, bottom bush ok, top bush buggered. Seals replaced, top bush removed from seal head, new delrin bush machined to fit the seal head and inner tube exactly. Reassembled, ifp bled, air spring sprung - works perfectly, pretty simple to service as it goes, glad I don't have to pay out the 85 quid a go now

Stripped my reverb seatpost last night with the aim to completely service it. Found that the top seal head DU bush had partially delaminated but fortunately not scored the inner shaft. Unfortunately you cannot just replace the DU bush and rockshox want you to replace the whole sealhead assembly at the cost of 30-40 quid Booked a half day off work this morning, talked nicely to the workshop foreman and have now machined myself a replacement bush (with a spare to go as well) from delrin so should never fail, only took an hour or so to machine so I'm going to go turn up the components I need for my rebound damper modifications edit: got the seatpost assembled last night, took a couple of attempts to get the ifp bleed good but think I've mostly got it now. Service is nice and straight forward, if a little messy! The new bush fits perfectly with zero rock at the seat, slides really freely as well and should never wear out like the DU bush. Got a spare bush that I might stick in my mates reverb if his is bad

If the cat fixing holes are open ended slots then a decent thickness washer will hold it just fine assuming that it's done up with sufficient torque. If the nuts are still slackening themselves then look at a spring washer between the thick washer and the nut Could it also be any gasket material in the joint has shifted and allowed the bolts some slack?

Finally got round to changing the oil and filters on the Ford bus, only a thousand miles over the recommended but I've been busy! Must congratulate ford on using a paper oil filter in a cartridge housing that can be easily accessed from the top of the engine, so much nicer to change than a screw on. Now I've got decent oil and filter in there I ought to do an Italian tune up. I gave it a mile or two at 70 in 3rd gear and clouds of smoke billowing later it seems to have cleared the exhaust somewhat. Should I give it another longer thrash or should that be sufficient?

Picked up a husqvarna petrol strimmer to whizz round the allotment for the princely sum of a fiver, broken guard that I can get remade at work but it turns over freely and makes the right blubblubbblub noise on the pull start so looks to be good for compression. Time to strip, clean, lubricate and find some 2stroke oil

The initial code was looking for the text "ASSEMBLY" in the description field and running from there: - Code: Sub AssemblyValue() Dim r As Range Dim AssemblyValue As Double Application.ScreenUpdating = False For Each r In Range("D3", Cells(Rows.Count, 4).End(xlUp)) If InStr(UCase(r.Offset(, -2)), "ASSEMBLY") > 0 Then AssemblyValue = r Else r.Offset(, 1) = r * AssemblyValue End If Next r Application.ScreenUpdating = True End Sub I suggested that identifying the assemblies by the blank material and finish reference fields was a more robust method and he changed it to this: - Code: Sub AssemblyValue() Dim r As Range Dim AssemblyValue As Double Application.ScreenUpdating = False For Each r In Range("D3", Cells(Rows.Count, 4).End(xlUp)) If r.Offset(, 4) = "" And r.Offset(, 5) = "" Then AssemblyValue = r Else r.Offset(, 1) = r * AssemblyValue End If Next r Application.ScreenUpdating = True End Sub I've not had chance to test the modified code yet but I don't see why it shouldn't work He also recommended and pointed me in the direction of this...

Asked the same question on the mrexcel forums and a kind user from Indiana a small chunk of code that worked perfectly for my example file. However it didn't work quite properly on a live file due to the way he'd identified the assemblies, a minor code change and it's all good. 10 lines of code to do what I've been trying to achieve for months with standard excel functions!

Be sweet if you could have a look to work out if I can do what I want to do I've attached a test sample bill of materials as exported directly from solidworks. The problem I have is that the solidworks BoM does not total up the quantities of component parts within a subassembly which is a massive failing if you ask me. I want to export the BoM to excel and use macros to format the file and automatically calculate the correct total quantities. Eventially I want to achieve the following: - Highlight the rows containing assemblies (rows 1, 8 & 19) to form an Assembly Header - I can already do this via conditional formatting. For each subsequent cell after an Assembly Header I want to multiply the quantity by the value listed on the Assembly Header itself. I want to carry out the same routine throughout the sheet. Using the attached sheet as an example I essentially want all the component qty cells [D9:D18] within TEST ASSEMBLY 3 to be multiplied by the assembly qty cell [D8]. Any sub-assemblies should be likewise calculated through. Additional columns/rows can be created if need be (they can be hidden/deleted at a later time for the final document), likewise the PT column can be hacked around with as it will eventually be hidden and is only used for reference. Test Assembly.xlsx

Anyone here any good at VBA coding in excel? I'm trying to get a spreadsheet to search up and down a column until it recognises a specific trigger above and below it (by conditional formatting or a specific cell value) and then multiplying a set of cells within the range by the top most cell. Really badly explained I know but can supply sample spreadsheets if anyone fancies playing with it. I don't think it's possible to do it with standard excel functions hence the need for VBA, however if it can be done all the better. Loaf of stale bread and a chocolate hobnob to anyone that can help TL: DR I don't know how to code VBA and want someone to help!

I came here through Google back in 2003/4 ish, registered after lurking lurking for a while, posted a bunch and now I don't have the time to ride the trials bike I lurk again. I still visit daily to catch up on a great group of people I've had the pleasure to meet on here (and those that I haven't!). As I rapidly near my 40s I have to accept that riding the trials bike is something that I'll never be able to do with the same fervour that I did 10 years ago but to me the community of forum friends is still very much alive, perhaps a little tacit but still there

Elgars Cello Concerto Which also happens to be sampled by this... I chose the first movement of the concerto for one of the introduction pieces for our wedding, love both pieces equally

Buy a tig welder and teach yourself My mate did a bit of project work on his saab 93 aero, whilst being mechanically competent he had never welded. Got the kit, played with it, made his own tubular manifold and poked 430 ponies from the 2 litre turbo. Not the prettiest welding but it worked quite nicely and he learned a handy new skill. Do it, learn new stuff, tig is pretty easy and oh so calming and peaceful

To get rid of fibreglass, have a shower as absolutely hot as you can stand, lather and rinse before turning the water cold. The fibres get in your pores, the heat opens them, soap washes out and the cold closes them again before you inadvertantly introduce more fibres from the water. Having a grp sister company has its benefits

Tis mostly fine

?

A well set up pdm vault, ssds and well modelled models (zero undefined sketches, minimal mates and sensible CDI approach) and it works lovely. Can still take an age to open some drawings but that's just a limitation of single threaded software. I've set up and implemented every single facet of our SW environment so I know it inside out, I've tweaked and polished everything I can to make it work faster and on the whole it's great