Copying a style from one Word document to another

This content is 2 years old. I don't routinely update old blog posts as they are only intended to represent a view at a particular point in time. Please be warned that the information here may be out of date.

My work involves a lot of writing. And document editing. Mostly in Microsoft Word. I’m a heavy user of our corporate template and, over the years, I’ve worked with colleagues to iron out issues in the built in styles.

If you’re not familiar with styles, they are a method to apply standardised formatting to a block of text. Instead of selecting the font, size, colour, indentation, bold, italic, etc. just select a style. The style groups together all of the associated formatting so you can pick Normal text, Heading 1, Heading 2, Bullets 1, Bullets 2, Subtitle, Quote, Emphasis, etc.

if you’ve ever created a website using HTML and CSS, you’ll be familiar with separating the content from the presentation. This is a similar concept.

There’s more information about customising and creating styles in this Microsoft support article.

I sometimes find that the styles in a Word document get corrupted when I’m working collaboratively. Common things I’ve learned to spot are that indentation is wrong on bulleted text, or that headings lose their numbering. I haven’t found the cause but I suspect it’s text copied from incorrectly-formatted documents with similar style names. I did find a fix though!

Faced with a stubborn Heading style that had lost its numbering a few weeks ago, I stumbled on a Microsoft Answers post that told me how to copy a style from one document to another.

The process involves finding an obscure Organizer dialogue:

  1. Open the document you want to copy the correct style from.
  2. In the Styles ribbon group, click the breakout arrow in the bottom-right corner to open the full set of Styles options.
  1. Click on the “A with a tick”, which opens the Manage Styles dialogue.
  1. From here click Import/Export… and it will open the Organizer.
  1. Close the file on the right hand side (we don’t want to use the default Normal.dotm).
  1. Open the file that you want to copy the style to – you may need to change the filter from Word Templates to All Word Documents.
  1. Select the style to copy, click Copy -> and then Close.

Your “problem” document should now be able to use the style you copied across from the “known good” document.

A little taster of what professional cycling life could be like

This content is 2 years old. I don't routinely update old blog posts as they are only intended to represent a view at a particular point in time. Please be warned that the information here may be out of date.

As a parent, I should never live my dreams through my children, but I will do everything within my power to let my children live their dreams.

It’s no secret (on this blog and elsewhere on social media) that I have two sporty teenagers. My youngest loves his team sports. He runs and cycles too, but he lives for his football and hockey. My eldest is a cyclist. No question of that. His bio says it all: “Matt Wilson. 17. Cyclist.”. Discovering cycling has changed him. Not just the self-taught bike maintenance or his athletic performance, but his social life and his general confidence too.

Self-development

Matt came to the sport quite late (he was about 13 when I took him to a Team MK Youth Coaching session) but quickly took to racing cyclo-cross. He missed out on British Cycling Regional Schools of Racing (RSRs) because of Covid-19 restrictions, but he took advantage of the extra training time whilst school was home-based. He worked hard. He started to win some races.

Last summer he tried his hand at cross country mountain bike (MTB XC) racing. This summer he has focused on the road. He gained his 2nd category race licence after early season success at Deux Jours de Cyclopark (2nd on the podium). He raced some more road races to get experience of riding in the bunch. He rode E12 mid-week crit races at our local circuit (Milton Keynes Bowl). And he “nearly” scored a national point at the Bath Road Club Junior Road Race (came in 23rd, but needed top 20). The culmination of his final season as a Junior rider was to be the Junior Tour of Wales.

Why Wales? Well, there are only two multi-day stage races for Juniors in the UK: the Tours of Mendips and Wales. We were on holiday when the Mendips took place. And Wales is our spiritual home (my father was and my wife’s father is Welsh), even if we were unable to click the “Welsh Rider” box on the entry form because Matt was born in Milton Keynes.

The SD Sealants Junior Tour of Wales

Back to its full format for 2022, the SD Sealants Junior Tour of Wales (@juniortourwales) is a four-day, five-race road cycling event which features time trial, road and criterium stages. Run mostly on public roads, it has the full experience of a major multi-stage event. That means the rolling road blocks, race convoy, medical backup – the full works. Basically as close to the pro peloton as a Junior rider can get. I’ve also seen it referred to as “the hardest Junior race in the UK”. Regardless, I can now say that it’s an awesome experience for around a hundred 16-18 year-olds each year. (Because of the way British Cycling age groups work, this year’s “Juniors” were those born in 2004 and 2005.)

SD Sealants Junior Tour of Wales 2022, Stage 5, Abergavenny, Wales
“Let Stage 5 begin” [image © David Partridge 2022, embedded from the British Cycling Photographers‘ Flickr Photostream]

Initially, it didn’t look like Matt had got in, and then, a few days before the race, I got a call from Richard Hopkins, the race organiser. Matt was on the reserve list, there had been some cancellations – did he want a place? Yes please!!! Even as he was resting, recovering from a stomach bug, there was no question – he would be on that start line on Friday!

Preparation

Bike preparation started. More spare parts were purchased. Two cyclo-cross bikes were set up for road, with another spare set of wheels taken from my road bike, just in case.

For those wondering about why he was using cyclocross bikes – that’s all Matt has, apart from his mountain bike. As it happens, 40×11 is perfect gearing for junior restrictions. Next year those restrictions are going away so 53×11 will be the norm and race speeds will go up.

I already mentioned that Matt does his own bike maintenance. It’s not that I can’t – it’s just that he’s faster than me and it’s good experience. My role for this race was to be Driver (to/from the race start/finish) and Soigneur.

I’d already booked hotels “just in case”, so my attention turned to what we would eat. Carbs. Lots of them. We quickly increased our supplies of Matt’s preferred in-race nutrition (McVitie’s Hobnob’s snack bars, Clif Bloks and Torq gels). Pre/post race there’s also High 5 Zero Electrolyte tablets and an SIS Rego Rapid Recovery drink that he decided to try. Then there was the supermarket visit: Weetabix; fresh pasta; malt loaf; scones; hot-cross buns; Eccles cakes; milk; and fruit. We would be eating from a cool box in my car for a few days (with a frozen home-made Bolognaise slowly defrosting) and we had plenty to keep us stocked. I also bought some spare water bottles because they always get lost on races.

Of course, there was a minor hiccup with the bike prep. The night before we left, Matt test rode his preferred bike, with a new chain. And then we found we needed a new cassette too (that’s not unusual but it wasn’t long since we’d changed the small cogs). Luckily a local independent bike shop had one and would be open for us to collect on our way to Wales the next morning. Competitive cycling is not an inexpensive hobby.

4 days as a Soigneur

I always over-prepare. There was no way I would allow Late Summer Bank Holiday weekend traffic on the drive to Wales make us miss the event. So we were there hours early. No bother. Plenty of time to recce the route, check into the hotel, and head over to race HQ to sign on.

And then it hit me. Most of the riders were on teams. Matt was one of the individual riders. I’d seen that in the race manual the night before but that meant most riders had support cars with Team Managers (Directeurs Sportif), mechanics, spare bikes and wheels. We needed to find the neutral service car and – because Matt’s on 40×11 gearing – make sure they had a wheel for him because a Junior (14 tooth) cassette would be a major handicap!

In addition, I would need to stay at the start of each race stage until the last possible moment and then drive to the feed zone, be ready to pass a bottle or provide technical support, and then drive to the finish.

Not only was Matt getting a taste of life in the peloton, but I was getting a taste of life as a Soigneur. With the added stress of being a parent thrown in!

The racing community

Of course, I’m wasn’t alone as a parent of an individual rider. 98 riders started this year’s Junior Tour of Wales. Even if they were on a team, most had parents/guardians/family friends to help them. Over the years, I’ve got to know many of those people too – it’s always good to say hello as we’re waiting for our children to race past. Some have kindly provided Matt with technical support at times too.

And then there’s the race organisation. The team running the event were, without exception, friendly and helpful at all times. Rich Hopkins responded to emails in record time when we needed to know if Matt had made the cut-off after the disastrous stage 4. And there’s a huge team behind Rich too: Commissaires; Drivers; Motorcycle Safety Officers (from the National Escort Group Wales); Timekeepers; Judges; Race Director; Neutral Service; Safety Officer; Marshalls; Route Managers; Stage Preparation; First Aid/Ambulance; HQ Management; Gear Check; Registration Team and – my favourite job title – the Director of Things. The SD Sealants Junior Tour of Wales is a pretty big undertaking! There were also four official photographers and I highly recommend checking out David Partridge’s stunning event photos (a couple of which I’ve embedded in this post from the British Cycling Photographers Flickr Photostream).

So, how did it go?

Well, let’s use Matt’s own words for this:

“A great experience for my last race as a Junior and if it hadn’t been for one shocking stage a Top 40 would have been possible. Instead, [I] came away with the Lanterne Rouge

Matt Wilson

He’s right in everything he says there, but I’ll throw in some more details. This blog post is mostly about this marvellous event for young cyclists – some of whom will go on to ride in the pro peloton. But it’s also, like everything else on this blog, an aide memoire for me to remember the highs and lows. Because, for me, Matt’s 2022 Junior Tour of Wales was an emotional rollercoaster.

Stage 1: Brynmawr-The Tumble (Individual Time Trial)

Results
Matt’s verdict: “My first ever time trial. When I saw the result thought I’d messed it up but no – I rode my best ever 15 min power and just was completely outclassed.”

Lesson learned: believe in yourself. A good chunk of the competition were on TT bikes. Matt was on a cyclo-cross bike with road wheels and clip-on TT bars. [Don’t subject Dad to a mardy teenager all evening until you look at your power numbers on Strava/Garmin Connect.]

General Classification (GC): 57/97 (+1’52”)
Stage 2: Abergavenny-The Black Mountain (Road Race)

Results
Matt’s verdict: “Hit the mountains, felt comfortable in the group all race but hadn’t taken on enough salts and cramped badly on the last climb but held on all be it in the saddle up the Black Mountain”.

Lesson learned: take the electrolyte drink on hot/hilly races!

GC: 61/95 (+5’48”)
Stage 3: Pembrey National Closed Road Circuit (Criterium)

Results
Matt’s verdict: “Crit race. Back to what I’m used to. Extremely sketchy but came away with 26th.”

Lesson learned: cyclo-cross skills can help when avoiding crashes!

GC: 56/93 (+6’54”)
Stage 4: Pembrey-Nantgaredig (rolling-flat Road Race)

Results
Matt’s verdict: “Eventful stage. Caught in a early crash then chased hard. Then the race was neutralised and when we went off it was so fast and spat me out the back. Finished but lost 30 mins”

Matt’s being very matter-of-fact about this but the stage was a disaster (for his overall results). Despite getting caught up in the crash shortly after the race was de-neutralised, he wasn’t badly hurt but he did lose his water (sadly at least one rider ended up in hospital and several had major mechanical issues, including at least one broken frame). He rode hard to catch the race only to learn that it had been neutralised. Later, when the race was stopped, another rider spotted that Matt had worn his tyre down to the beading (when skidding into the crash) so he switched wheels, and then had problems with skipping gears. Next day, we learned that was due to chain damage in the crash. Once Matt had lost the bunch and dropped out of the race convoy he was caught up in normal traffic/road conditions and was losing time. He showed tremendous mental fortitude and made it across the line with seconds to spare before he would have been lapped by the winners!

Luckily, the race jury extended the cut-off time (he was only just outside) but this stage effectively finished any chances of a good place on the GC.

GC: 80/82 (+35’26”)
Stage 5: Brynmawr-The Tumble (Road Race)

Results
Matt’s verdict: “All I can say is the Tumble wasn’t that bad – the earlier climbs however were pain!”

I was worried about how this race was going to go with tired legs, a warm-up interrupted by the need to change a chain, and then an exploding inner tube on the rollers (after last night’s tyre swap). Matt was concerned that the fast roll down the A465 dual carriageway could easily end up in a crash. Luckily, neither of our fears were realised.

Actually, he looked pretty comfortable at the feed zone, and I think he paced this race well. He also got a buzz from managing to keep pace with some of the faster and more experienced riders.

Finishing 39th and only 3’39” down on Josh Tarling, was a pretty impressive result after the previous day. Yes, the Lanterne Rouge was disappointing, but completing the Tour was an incredible achievement.

GC: 71/71 (+37’56”)
SD Sealants Junior Tour of Wales 2022, Stage 2, Abergavenny, Wales
“Snaking” [image © David Partridge 2022, embedded from the British Cycling Photographers‘ Flickr Photostream]

Postscript about “the socials”

There are a lot of posts on my Twitter (and Instagram) feeds about this year’s Junior Tour of Wales #JToW #JTW22, including one where I post how proud I am about Matt’s performance to even finish the race, regardless of position. It may seem a bit narcissistic, but it’s not meant to be – it really is my way of sharing my excitement, sorrow, joy, pride and host of other emotions. A place to ride this year’s tour meant a huge amount to us both and to be given that chance as an individual rider on a reserve list place was really special. It’s great to see other parents of some really successful riders liking my posts because we’ve all had a shared experience too. (Even if their kids are at another level and winning stages, and even landing pro contracts!)

Special mention here to Kate Cole (@KKPreserves) who saw me at the feed zone on stage 5 and said “are you the #CyclistsDad?”. It’s nice to hear that someone likes my posts to hear what’s going on!

And, if you’re reading this and you’re the chap who came up to Matt by my car at Race HQ after stage 5 and said “That was an incredible ride today – especially after yesterday” – thank you. I don’t know who you were (It would be good to know!) but that comment was lovely to hear. I really appreciated it (as did Matt). Actually, it made my day.

So I’m afraid I’ll keep on posting pictures and unofficial commentary, until he says “Dad, stop it, you’re embarrassing me”.

Fear Of Missing Out

The water was swirling in front of me… I wanted to jump in but I couldn’t. “Come on”, said a little lad as he leapt off the cliff with no fear at all. But fifty years of experience told me not to. I really, really wanted to do this. My teenagers had done it a couple of days’ previously and this was my last chance. It had to be at high tide and tomorrow I wouldn’t be in the village at the right time; then the day after we’d be driving home…

It took me 30 minutes of standing there and repeated attempts walking or running to the edge and then stopping. My eldest son was giving his “support” (“come on Dad, you’re over thinking this – you can do it!”) and my youngest was waiting in the water to assist me after the jump. But, however grown up our teenagers are, they are still children. They don’t have responsibilities (yet). Or fear.

I had fear. Fear Of Missing Out (FOMO). But also fear of that water. I’ve never been happy swimming at sea. Ever since a wave knocked me over as a small child. Even at school, I learned to swim two years after the others. I was seven and learning to swim a width, then a length, with the five year-olds. Later, as a teenager, I was strong enough in races but in a pool. Taking my dive mask off at the bottom of Sydney Harbour for my PADI certificate was terrifying. And that was over twenty years ago.

We’d started out by swimming to the base of the point, but the waves and the depth (the same depth that made it safe for me to jump from above) scared me. I swam back to shore and walked out to the headland. And all the support from my family (who, let’s be honest, were probably quite tired of waiting whilst I repeatedly failed to jump) was not quite enough. In the end it was my sister-in-law’s quiet words from behind me (I wish I could remember what they were) that flipped a switch and I finally made that leap.

Done. Ticked off the list. Easily the most frightening thing I’ve ever done. And all for FOMO.

The symbiotic relationship between engineering and architecture

This content is 2 years old. I don't routinely update old blog posts as they are only intended to represent a view at a particular point in time. Please be warned that the information here may be out of date.

I’m entering a new phase of life as my children are growing up. My eldest son has passed his driving test, and now we’re touring university open days. He’s looking to become an engineer (as was I, before I failed my A levels and fell into computing, but that’s another story).

Last weekend, we visited the University of Bath, to learn about their Structural and Architectural Engineering course. In his introductory presentation, Senior Lecturer Dr Chris Blenkinsopp was talking about the relationship between engineers and architects, and it really struck a chord with me.

Dr Blenkinsopp was speaking about engineers as “born problem solvers”. Engineers focus on design – following guidelines and using their problem-solving skills. The architect does the big picture “drawing”, the engineer makes it work. Whilst a computer might be able to solve the maths, the engineer needs an ability to use a range of skills in an imaginative way.

Successful projects need collaboration between engineers and a variety of stakeholders. Critically, it’s vital that architects and engineers work together closely. And, for that reason, the University of Bath’s Design Projects involve both engineers and architects – collaborating at university as they will in their professional careers.

Whilst Dr Blenkinsopp was talking about civil/structural engineers and architects who work in the built environment, there are strong parallels with my world of information technology (IT).

Architects and IT architects

I have to be careful here, because I’ve been called out previously for calling myself an architect, which is a protected title:

“The title ‘architect’ is protected by law in the UK, under Section 20 of the Architects Act 1997. It can only be used in business or practice by someone who has had the education, training and experience needed to join the Architects Register and become an architect.”

[Architects Registration Board]

But all of that relates to architects who work in the built environment. In IT, architect is a broadly used term – and is recognised in the Skills Framework for the Information Age (SFIA). It’s also part of the job title in my employment contract!

The relationship between IT engineers and IT architects

Unfortunately, in IT, the term “architect” is also abused. It’s become common as a term to imply some seniority in the technical space. As a result, it’s lost some of its meaning. Even so, my role as an architect is less and less about technology and more and more about solving business challenges. In the course of that work, I work with lots of subject matter experts – the engineers of the IT world – who solve the problems that I give to them. My role is to draw the big pictures and join everything together. [Often, my tools are some whiteboard pens…]

Where I work, at risual, we run Consulting Skills Workshops, to help our subject matter experts develop the soft skills that are required to be a successful consultant. In reality, our consultants are on the first step towards IT architecture (whether they know it or not). Consulting is an engagement model and a set of soft skills. In terms of career progression, our consultants are no longer engineers – they are often required to work as technical architects.

But there is absolutely nothing wrong with being an IT engineer. We need those problem solvers – the people who know how to bring technology together and use it in imaginative ways. Just as much as we need the people who can take those technology building blocks and use them to solve business challenges.

Conclusion

As a result of taking my son to Bath and sitting in Dr Blenkinsopp’s presentation, my mission has changed. The work I’m doing at risual to develop and grow our Architecture practice needs to be tweaked. I need a slightly different focus. I still need to create great architects. But I also need to up the emphasis on constant collaboration with great engineers.

Because, to take a quote from Dr Blenkinsopp’s talk:

“The best […] engineering solutions require engineers and architects to work together from the outset.”

Professor Ted Happold

Additional Reading

What is IT Architecture? (part 1 of a series I wrote last year)

Developing IT Architecture Skills (part 2)

So, you want to be an Infrastructure Architect? (very old, but contains some useful diagrams)

Featured image: author’s own.

The paperless office

This content is 2 years old. I don't routinely update old blog posts as they are only intended to represent a view at a particular point in time. Please be warned that the information here may be out of date.

For decades, the paperless office has been a panacea, sought out by businesses far and wide. Ever since computers became a part of our daily work, there have been those who have prophesised on how we will no longer need to use paper.

And yet, I still receive so much of the stuff. Sure, I can receive most of my invoices and statements electronically – and we all know how print newspapers and magazines are in a state of decline – but paper is still used extensively. Some people just prefer to interact with analogue media – my wife likes a paper book, for example, and never got on with a Kindle. And some business models rely on shoving pieces of paper through the letter box (try opting out of Royal Mail’s “junk mail” deliveries and you’ll find it’s a lot harder than it should be).

Digitising my life

Several years ago, I started to scan important documents at home. The theory was that everything gets scanned, and only the really important papers got filed in paper form – generally those that related to the house (mortgage, building works) or to me as a person (passport, certificates, medical, etc.).

The trouble was, that I got behind on my scanning. Years behind. Boxes of “to be scanned” and boxes of “might have been scanned – who knows”. And my old Canon scanner was not up to the task – too slow and with an unreliable document feeder. It was also connected to an old (slow) PC, and needed two powered USB ports to drive it (which was a problem on any of the newer devices that I had access to). Added to which, there’s still all the pre-scanning regime files that were stored in the loft until we converted that to living space (4 years ago…).

So, whilst I took a few days off over half term, I bought a new scanner. A 35 pages a minute super-duper Wi-Fi connected paper-eating monster from Brother… and I reworked my document scanning workflow. I’m now scanning through the backlog and thousands of pages of paper are being shredded and recycled each week. So much that I keep overheating the shredder!

What’s the point?

All of this is good – it’s making me feel good about the progress I’m making and my family will be pleased to have fewer boxes of paper in the spare room.

But then my friend Matt Ballantine (@Ballantine70) remarked that he didn’t understand – what did I need to scan? The only paper he gets in junk! And I started to wonder if I’m somehow unusual?

Matt has a point. Years of “business transformation” and “digital transformation” has meant that most of the companies I deal with offer options for electronic bill and statements. But not all:

  • Not all of my tax paperwork is digital. Increasingly it is, but not all.
  • I keep a copy of the latest Council Tax bill, and at least one set of recent bank statements for identity purposes. (Some organisations still won’t accept digital versions!)
  • DBS certificates, vehicle “log book” (V5), etc. are all paper documents (and odd sizes too).
  • Add to that the letters relating to investments, pensions, banking, etc. that don’t arrive digitally.

It’s still quite a lot.

Then there’s the backlog. Maybe I should have a big bonfire and be done with it. Except that my mental makeup won’t allow that. I need to sort through it and find *the important bits* and scan it all *just in case*. (I know. It’s just the way I am. Try living with me!). And, anyway, paper doesn’t burn very well, as I found a few years ago when I got rid of 20+ years’ worth of work notebooks that were a potential GDPR nightmare and just gathering dust.

A digital dilemma…

So, now my “paperless office” is getting closer. And I almost never print anything at work. But I create lots. Lots of documents that I write. Lots of photos that I create. Lots of digital files I download (instead of receiving printed copies) or scan (see above).

The trick is to make sure I don’t replace boxes and boxes of paper files with digital mayhem. A digital mess that’s spread across a variety of online services from Microsoft, Amazon, Dropbox, Google and Apple!

Advice and guidance is welcomed… comments are open below!

Featured image: author’s own.

Sorting a Word table of names, in Excel

This content is 2 years old. I don't routinely update old blog posts as they are only intended to represent a view at a particular point in time. Please be warned that the information here may be out of date.

I’m going to share a secret with you all, dear readers. I really like Microsoft Excel.

There, I’ve said it. Excel may not be the perfect tool in some scenarios (take my example last year, which should almost certainly have used Power BI) but it is the “Swiss Army Knife” of the IT world. End users and IT admins alike have taken the humble spreadsheet programme and twisted it to suit their purposes. I can do so many things with it.

The problem – a table of names in Word

Like a few weeks ago, when I was reviewing a document. The document contained a table with a list of stakeholders. So as not to offend (in a very hierarchical organisation), it had been decided that the names should be in alphabetical order. Except the author had done that by first (given) name, not by last (family/surname) name. Rather than going back and asking them to fix it, I decided I would do so – as it should only take a few minutes.

Word tables are not always that easy to work with, but copying the data into a spreadsheet would let me mangle it, and then paste it back again. Incidentally, Visual Studio Code is also a fantastic text editor and I often use it for complex search and replace operations.

Moving the data to Excel for processing

In this case, I took the two columns from Word (Name, Job Title) and pasted them into Excel. That gives me something like this (massively simplified for the purposes of this blog post – I wouldn’t really go to this much effort for a three-line table! I also made up the names for this example…):

Mark WilsonPrincipal Architect
Brendan ClarkeDirector
Roger QuinnManager

Splitting first and last names

Next, I added a column to the right of Name, and split the Name column, using Excel’s Text to Column wizard and a space as a delimiter. That gave me separate columns for First Name and Last Name.

MarkWilsonPrincipal Architect
BrendanClarkeDirector
RogerQuinnManager

Sorting the data

I then sorted the data on Last Names:

BrendanClarkeDirector
RogerQuinnManager
MarkWilsonPrincipal Architect

Combining first and last names

Next, I used Excel’s Concatenate function to merge the sorted names back into a single field, for example:

=CONCATENATE(A1," ",B1)

The result is something like this:

BrendanClarkeBrendan ClarkeDirector
RogerQuinnRoger QuinnManager
MarkWilsonMark WilsonPrincipal Architect

Moving the processed data back to Word

Finally, I took the processed data and copied/pasted the combined Name and Job Title text back to Word.

NameJob Role
Brendan ClarkeDirector
Roger QuinnManager
Mark WilsonPrincipal Architect

Featured image by PublicDomainPictures from Pixabay.

A cyclo-cross racer’s equipment list

This content is 2 years old. I don't routinely update old blog posts as they are only intended to represent a view at a particular point in time. Please be warned that the information here may be out of date.

After last weekend’s UCI Cyclo-Cross World Championship races (with excellent results for Britain’s Nathan Smith, Zoe Backstedt and a lesson in how to ride a course with no mud from Tom Pidcock), the 2021/22 cyclo-cross season is drawing to a close.

Those who follow me on Twitter or Instagram will know that my eldest teenager is a keen cyclo-cross racer and this year has seen me supporting him at all six National Trophy rounds and the British National Championships as well as a few league races. February means I get some weekends back in a temporary lull before road and MTB Cross Country (XC) take over.

Whilst I’d love to travel to races in a van, or even a motorhome, my budget means that transport is an estate car (currently a Volvo V60 D4) and accomodation is often a Premier Inn. So what does an aspiring cyclocross racer need their support team to take?

A few years ago, I wrote a post about the tools in my box. Since then, I’ve added the following:

Then there are the cyclo-cross specifics (although many of these come in handy for other race disciplines too):

  • Water (10 litre AdBlue containers are a good size for transport – I take 4 to a race, inside a 64 litre Really Useful Box to avoid spillages – a lesson learned from experience).
  • A battery powered pressure washer (and spare battery). I use a 20V model from Worx (and newer models are more powerful). There are people who will tell you that a battery washer is no good and that a high-pressure petrol washer is a necessity. Whilst a petrol washer will undoubtably get a bike clean more quickly and I’m always happy to use one if I’m with a team-mate: a) they are unreliable (the battery one is a good backup); b) they are dreadful for the environment (both petrol fumes and volume of water used); c) the better race organisers are now providing decent wash equipment (e.g. the Clanfield Cross event that was sponsored by Kärcher, or the new Hope setup featured at Round 6 of the 2021 National Cyclocross Trophy).
  • A selection of brushes (I use this Muc Off set) and rags.
  • An inverter (to charge stuff using the car’s 12V power supply) – mine is a fairly low power model (150W) as higher wattage inverters need to connect to the car battery, rather than the 12V socket.
  • (Solar powered) battery pack (and Shimano Di2 charger, for those using electronic gears).
  • Spare bike… cyclo-cross is a muddy business and bike changes mid-race are expected, especially later in the season.
  • Spare wheels (with different tyres/tread patterns).
  • A collapsible trolley. Make sure you get a decent one… I bought cheap and bought twice – the first one only lasted a few weeks of being dragged across muddy fields before it became “permanently collapsed”. The replacement was this model, which seems to have got through two seasons now.
  • Rollers (Elite or Tacx – there are plenty second hand on eBay, though you’ll probably have to collect them as they are awkward to post).
  • Luggage (modular sports bags from Kit Brix are really good, though the zips can be cumbersome).

All in all, a pretty full boot…

Estate car filled with cycling equipment

Featured image by Owen Lake/Monument Cycling.

Recruitment

This content is 2 years old. I don't routinely update old blog posts as they are only intended to represent a view at a particular point in time. Please be warned that the information here may be out of date.

The last quarter of 2021 was manic. I’d already “lost” one of my team, who was working his notice period before joining a competitor, when another team member told me he’d decided to follow opportunities outside the company. All of a sudden, my delayed decision to recruit (over concerns about keeping the team busy) became an urgent need to recruit two experienced Solution/Enterprise Architects, just as our workload hit a spike.

With a lack of internal candidates coming forward (often the good technical Consultants want to stay close to tech), I discussed the issue with my senior management team and we advertised externally for two Enterprise Architects.

Finding the right candidates

I’ve recruited before, but this was the first time I’d been a Hiring Manager at risual. In my experience, every company has a different approach to recruitment and practices change over time too. I was fortunate to be working with a fantastic HR Advisor, who helped me specify the role (having an up to date Job Description helped too). Over the next few weeks, adverts went out on Indeed, on LinkedIn, and through various recruitment partners. Slowly, but surely, the CVs came rolling in.

Whilst we all put a lot of effort into creating CVs, they really are just the “foot in the door”. The first sift happened before they even got to me. Of those I saw, I rejected some because they didn’t seem to relate to the role as advertised. Maybe those candidates had the experience, but it wasn’t clear from their CV. I was recruiting for two senior roles and some people seemed to take an opportunistic approach. Other CVs were too long, listing everything the candidate had ever done over an extended period. There’s a fine balance between not enough detail and too much. Just remember that, although you put hours into writing that CV, it may only get a 30 second skim – or perhaps a bit longer if you manage to grab the reviewer’s attention.

I also saw CVs with typos. And I wanted to meet a candidate who looked fantastic but had neglected to include contact details. And, sadly, I saw well-formatted CVs that had been butchered by the recruitment agency’s topping and tailing.

In the end, I decided to meet with around half the candidates whose CVs I’d reviewed. Actually, it was slightly more than that but we had problems contacting at least one candidate (as mentioned above) and others had already accepted roles elsewhere (including one who only told us when we contacted him a couple of hours before his planned interview). This is a fast-moving market and, right now, it’s definitely favouring those looking for a new job over those looking to hire.

With CVs sifted, the remaining process would be an interview with myself and my manager (as the hiring team), some personality and numeric/verbal reasoning tests, and finally an interview with the Chairman and the CEO. The aim was to move quickly – from first interview to offer in around a week.

Interview criteria

I remember the first time I ever took part in an interview (from the hiring side). My then-Manager, a wise Managing Consultant by the name of Mark Locke, told me that it’s quite simple:

  1. Does this person know what they are talking about?
  2. Can I work with them?

This advice still holds true today. It’s pretty obvious, pretty soon, when an interview is going badly. The good ones are pleasurable.

Looking back, I can call out some really enjoyable discussions at interviews that went on to be great hires. One in particular (back in my days at Fujitsu – and before Microsoft Teams) was unavailable when I called his mobile phone (he’d been driving for work and struggling to get a signal at the appointed time) but, after we rescheduled and finally got to speak, my initial impressions were overturned by someone who turned out to be an extremely talented Project Manager with a passion for technology. We went on to work together before his career went from strength to strength. These days he’s a Senior Program Manager at Microsoft and he’ll know who I’m writing about if he still reads this blog.

As a candidate, I’ve written previously about some shocking experiences but my risual interview was different. I was a bit put off when Alun Rogers told me he reads my blog (back in the days when I used to post more!) but it felt like it had gone well as I drove home later. It really did feel like “just a chat” and I enjoyed meeting Al and Rich (Proud). Similarly, when David Smith had interviewed me a few years earlier to join his Office of the CITO at Fujitsu, I just had a feeling that things had gone well.

For my recent hires, I had formal criteria to assess against but my Manager and I had also worked out a set of standard questions to structure our conversations with the candidates. Each hour-long interview had at least that long spent writing up and reviewing the notes, as well as prep time. And all of that had to fit around my management and delivery roles – so November and December 2021 were intense!

What did I learn?

The whole experience taught me a lot. That’s why I’m sitting here, in the gap between Christmas and New Year, writing about it (whilst it’s still reasonably fresh in my mind).

First of all, I realised that the same question can elicit very different responses to the one that was first expected. And, just because someone has a different view to me, doesn’t make them wrong. A gut feel about being able to work with someone is good but, if you only look for people who think like you, it won’t do much for the diversity of the team.

Having said that, for the candidates who looked me up on LinkedIn (and there were some – good interview preparation, I’d say), you don’t have to go far back on my blog to see a post about what I expect to see in an IT Architect

I also (re-)learned that interviewing is hard. Not only is it demanding from a cognitive perspective but there is a lot of work to do both before and after the interview. And not doing that is not giving the candidate the respect that they deserve – I will always put in the effort.

Interviewing is enjoyable too. No-one wants to see anyone struggle and, as I wrote earlier, I genuinely enjoyed some of the discussions I’ve had in the past and the same can be said for the ones in recent weeks (though I’m not going into specifics here for reasons of confidentiality).

I learned some other things too – things that I can’t write about here because they relate to specific details of individual hires but which were nevertheless valuable in me learning to trust my own judgement (e.g. after having to interview alone, instead of as part of a team).

And I learned that not all the advice given by recruitment partners is correct. Again, I won’t go into details but the right candidates are out there.

I was also intrigued by the personality tests. So much so that I asked if I could do them myself. I completed them before I left for the Christmas break and I’m looking forward to seeing how I compare to the candidates we’ve recruited when I get the reports. Again – I’m not looking for people who think like me… but I am looking how the tests assess me and how that relates to the way I think. It might also be useful to see how middle-aged me compares to younger me.

Looking forward and rebuilding the team

Now, as we go into 2022, I’m really excited to have two new starters joining my existing team, to help shape our future and support the company’s growth plans. As for the guys who moved (or are moving) on – I genuinely do wish them well. I know one is having a great time in his new role and the other has an exciting opportunity lined up. I’d rather we were all working together (new hires and “the old team” together), but I’m also a realist and sometimes the best thing to do is to support people in taking their next steps.

As one former Managing Director used to say when signing off his communications… Onwards!

Featured image by VIN JD from Pixabay.

Step back from the problem and think about what “good” looks like

This content is 2 years old. I don't routinely update old blog posts as they are only intended to represent a view at a particular point in time. Please be warned that the information here may be out of date.

A few weeks ago, I sat down with a Chief Information Officer (CIO) who has a problem. He’s in the middle of a messy “divorce” (professionally, not personally). He is transitioning services from a shared services agreement with another public sector body to a new managed service. His own organisation’s IT maturity is low. There’s an expectation that the new managed services partner will take on everything (except it’s not in a state that is ready to take on). And the shared service provider is both making transition difficult (preserving its revenue stream) whilst ramping up the price to carry on providing services. The divorce metaphor is very apt. 

I was brought in (alongside a colleague with relevant sector experience) to help smooth the pain. I needed to understand what’s holding up the process – why is it so difficult to provide basic information for the managed services provider to take on the service? What are the gaps? How quickly can they be filled? And what is needed to move to the next stage? 

It’s not my usual role, but I’ve been around this industry long enough to be able to take a step back, look at the problem, and try to work out what “good” looks like. 

The challenges

The CIO presented me with two challenges: 

  1. Visibility – of what’s happening. What will be done by when and how far off the target is the transition?
  2. Passiveness – don’t just sit and wait. Bang down some doors and ask for information. If it’s not forthcoming, then flag it. There is no time for delays. 

Searching for a solution

The next day, I was mulling over the issues and I bumped into a friend (on the market in the town where we both live). We went for a coffee, and I told him about my problem (without compromising any confidentiality). My friend has a military background, followed by IT Service Operations and, more recently, security (he’s a Chief Information Security Officer – CISO) so I shouldn’t have been surprised by the advice he gave me. The way he saw it was that there are a bunch of service transition “packages” but the business as usual (BAU) service isn’t complete. Meanwhile the CIO has no visibility and would like to see where things are and the plan for where they will be.

After our conversation my mind was clear. I needed a way to track progress. I wanted a dashboard to tell me the state of each service component or process. Then, the applications, servers and other infrastructure could fall in beneath – but I needed to know there is a service to transition them into. 

There are many problems with dashboards (though the etymology of the word is about protecting riders on carriages from what might be thrown at them from below… so maybe that’s quite appropriate after all). Red/Amber/Green (RAG) statuses can be problematic too (both for cultural reasons and because of accessibility, although that can be overcome with appropriate design). But I didn’t want perfect – I needed functional. At least for the first iteration.

The chosen approach

The Microsoft-focused Solution Architect in me was thinking Power BI but I lacked the skills, time and access to licenses. I needed something that could be developed quickly and updated easily. My initial PowerPoint deck with, “this is what we said we would do”, “This is where we are today” and lots of red, turning amber then green was quickly pushed aside by a colleague in favour of Excel. In fairness, the world runs on Excel – and that’s not necessarily a bad thing. With the addition of a few formulae, some data validation and some conditionally formatted cells, we soon had a dynamic report. It highlights missing information. It highlights support status. It highlights key dates (and missed dates – because I’m also realistic).

Answering the exam question

The summary sheet should answer the CIO’s visibility issue (once it’s securely shared) and constantly pushing for the detail should strike out any perceived inactivity or a lack of initiative.

It’s not innovative, but it is elegant. And it works. 

So I have the tech in place – now for the difficult bit (the part that involves people) – dragging out the missing information to turn cells from red to amber to green. And the good thing is that, based on a meeting yesterday, it feels like there are a bunch of people in the managed services organisation that can see the value and are invested in the solution (they are even adding sheets for extra information – like tracking risks, issues and dependencies). That’s half the battle. “All” I need now is to get the various projects that hold the information on the various applications, servers, etc. to join in.

I may return to this subject with an updated post when everything goes live. Or I may not, for commercial reasons, but here goes… wish me luck! 

Featured image: author’s own.

Not-so-helpful social media “help”

This content is 3 years old. I don't routinely update old blog posts as they are only intended to represent a view at a particular point in time. Please be warned that the information here may be out of date.

Social media is big business. And almost every major business to consumer (B2C) organisation has at least one account on each of the major social media platforms (at the time of writing, that’s Twitter, Facebook and Instagram but I’m sure it will change over time). 

Unfortunately, there’s a concerning trend starting to emerge – one where the “conversation” is moved to control the brand image. Many brands have set up <brandname>Help accounts for their customer service so that the main brand account is “clean” – pure marketing, untarnished by customers expressing concern about the products and services. Meanwhile, the “Help” account may be operated by a communications agency, simply offering a face and redirecting customers to other channels. 

And that’s where the problem lies. If you want to offer omnichannel support, then you need to meet your customers where they contact you. It’s no good offering “help” on Twitter when all you’re really doing is advising customers to phone your contact centre. That does not help. That’s obfuscation. It’s a blatant attempt to preserve the online image of the brand, whilst offering shoddy customer service. 

So, here’s my plea to brand managers across the UK. If you offer a <brandname>Help account, then make sure it provides real assistance and is not just signposting to another channel. 

I’ll provide an example here, from @KwikFitCS (who responded to my tweet for the main KwikFit account… more on that in a moment), but they are not alone…

Then there’s the issue of the information that <brandname>Help accounts ask for to verify you before they will provide help…

In the example above, @BootsHelp replied to a tweet sent to @BootsUK. And the issue I was reporting was a website problem that was not specific to a single account – the web team could investigate without my personal details. Maybe I should be the one looking for the verification here… not them? That may sound a bit extreme but what’s to stop anyone from setting up a spoof <brandname>Help account and harvesting information from disgruntled customers? (In fairness, the @BootsHelp account has been verified by Twitter, but the @KwikFitCS example earlier was not).

And Boots is not alone – here’s another example from @Morrisons, the UK supermarket chain:

The request went on to a second tweet:

So, come on B2C Twitter. You can do better than this. How about providing some real help from your social media channels? Preferably without requiring a long list of personal details.

Featured image by Biljana Jovanovic from Pixabay.