Excel – Two Types Of Transpose

In Excel – Sorted With AppleScript I mentioned I might have a go at transposing rows and columns in an Excel spreadsheet with AppleScript. I said there were two things I could try – each with a different use case: Transposing Rows And Columns In A Spreadsheet Transposing Rows And Columns In A Graph IContinue reading “Excel – Two Types Of Transpose”

Excel – Sorted With AppleScript

They say necessity is the mother of invention. But so, I’d say, are impatience and frustration. I find the sorting dialog in Excel on Mac a source of both of these. So I wrote some AppleScript to remove some of the friction. I’m sharing this because, yet again, I found nothing on the Web toContinue reading “Excel – Sorted With AppleScript”

More AppleScript And Excel

In Automating Microsoft Excel I wrote about some basic manipulation of graphs in Excel for Mac OS, using AppleScript. I’m writing about it again because of the paucity of examples on the web. Here is an example that shows how to do a number of things in that vein. tell application "Microsoft Excel" set cContinue reading “More AppleScript And Excel”

Mainframe Performance Topics Podcast Episode 34 “Homeward Bound”

We started planning this one quite a while ago. Thankfully our topics tend to be evergreen – in that they’re still topical for quite a while. In that vein I know we are gaining new listeners and they aren’t all starting with the latest episode. Anyway, our schedules have been their usual hectic selves –Continue reading “Mainframe Performance Topics Podcast Episode 34 “Homeward Bound””

Reduced To A Single Tap

(This is not a post about plumbing.) 😀 It’s been a while since I last wrote about personal automation. And in Stickiness I talked about what makes automations stick for me. This post is about experiments with RFID detection and automation. These actually turned into something I use daily when I’m at home. Hobbyist DigitalContinue reading “Reduced To A Single Tap”

Mainframe Performance Topics Podcast Episode 33 “These Boots Were Made”

I hope you can tell that Marna and I had a lot of fun making this episode. I can’t recall which of us came up with the cultural reference. But it sort of developed – until the aftershow was sort of inevitable. Anyhow here are the show notes for Episode 33. The podcast series isContinue reading “Mainframe Performance Topics Podcast Episode 33 “These Boots Were Made””

Mainframe Performance Topics Podcast Episode 32 “Scott Free”

Episode 32 was, as always a slow train coming. I think it’s a fun one – as well as being informative. It was really good to have Scott back, and we recorded in the Poughkeepsie studio, just after SHARE Atlanta, March 2023. Talking of which, the aftershow relates to SHARE. It’s a classic example ofContinue reading “Mainframe Performance Topics Podcast Episode 32 “Scott Free””

Mainframe Performance Topics Podcast Episode 31 “Take It To The Macs”

This is the first blog post I’ve written on my new work MacBook Pro. While it’s been a lot of work moving over it’s a better place as it’s an Apple Silicon M1 Max machine with lots of memory and disk space. That’s nice, but what’s the relevance to podcasting? Well, it’s very warm hereContinue reading “Mainframe Performance Topics Podcast Episode 31 “Take It To The Macs””

Mainframe Performance Topics Podcast Episode 30 “Choices Choices”

It’s been a mighty long time since Marna and I got a podcast episode out – and actually we started planning this episode long ago. It’s finding good times to record that does it to us, as planning can be a bit more asynchronous. Hopefully this delay has enabled some of you to catch upContinue reading “Mainframe Performance Topics Podcast Episode 30 “Choices Choices””