Skip to content

Thoughts on many things Posts

Excel: Combine two columns

While analysing an Excel sheet the other day, I needed to combine two columns so that I could get names in the format firstname lastname (the list had been provided as lastname,firstname). As it happens, doing so is relatively easy. You do it on a cell by cell basis, by using basic excel commands.

Leave a Comment

Ethics: Intention versus consequence

When getting caught with their hands in the cookie jar, public officials tend to offer their good intentions as a defense. I don’t understand why we keep accepting such defenses. Who cares that your intention was to ensure proper tax planning? You still lied about whether or not you were domiciled somewhere else. I don’t see a valid argument that your so-called “good intentions” – an appeal to the ethics of your intentions, rather than the ethics of your actions – is relevant at all. It is certainly not a mitigating circumstance.

Leave a Comment

Ensure redundancy for critical systems

As I’m sure you noticed, Facebook suffered massive downtime to several services last week, including Messenger, Instagram and so on. Such events often serve to highlight what services we have rely on. While I’ve been (at least attempting to) phase out Facebook for some time, there are still some things that I actually need it for.

Leave a Comment

Reviewed: SmartHalo 2

This is part one of a two-part series on my experiences with the SmartHalo 2 bike computer. It’s no secret that I’ve backed a few Kickstarter projects over the years. Some have entirely failed to deliver, some have delivered products so atrocious that it doesn’t bear thinking about, and some have delivered a product that delivers (and sometimes well and truly overdelivers) on the pitch.

Leave a Comment

Start a new Google Doc/Sheet/Slide deck straight from the address bar

I recently learned of a nifty little trick for users of Google’s Workspace services (i,e. Docs, Sheets, Slides, Forms etc.): You can start a new document, spreadsheet, slide deck and so on from the address bar of your web browser. Simply enter the appropriate command (below) into the address bar, hit return, and watch as it unfolds:

Leave a Comment

Deleting site-specific cookies in Chrome

On occasion, the single sign-on authentication for a few of the systems I work with stops working due to an issue with the cookies stored in my web browser. The solution is simple enough; delete the cookies, and Bob’s your uncle. I don’t, however, want to delete all cookies, as that would mean that all of my logged-in sessions stop working. Instead, I want to delete the cookies for the site or sites affected by the issue. Here’s how:

Leave a Comment