Mainframe Performance Topics Podcast Episode 37 “Watts Up?”

A very slow train coming, due to Marna’s and my commitments. But, again, I’d rather prepare well for when we do record. I think this one – as usual – says exactly what we mean to say. I’m hoping you’ll listen to the aftershow; It’s more of a bonus topic really. This one is aboutContinue reading “Mainframe Performance Topics Podcast Episode 37 “Watts Up?””

md2pptx 6 Is Another Big Step Forward

If the purpose of Version 5 was to add the ability to use Python in the context of md2pptx the purpose of version 6 is to extend md2pptx’s automation capabilities still further. This time instead of Python it’s AppleScript. The context is different too: With Version 5 the Python support runs the user-supplied code asContinue reading “md2pptx 6 Is Another Big Step Forward”

md2pptx 5 Is A Big Step Forward

A while back I experimented with executing user-provided Python. It seemed a small step at the time, but I had a hunch it would turn out to be a much bigger thing. Coding it was straightforward but two things delayed releasing it: Documentation is tricky. The python-pptx API is (necessarily) not for the faint ofContinue reading “md2pptx 5 Is A Big Step Forward”

Mainframe Performance Topics Podcast Episode 36 “Telum Like It Is”

We were especially keen to get a podcast episode out on the day z17 was announced, having both worked on the launch project in various capacities. So, for once there was a deadline – which we actually made. It was a pleasure to record this, with almost every piece of it related to z17. SoContinue reading “Mainframe Performance Topics Podcast Episode 36 “Telum Like It Is””

Mainframe Performance Topics Podcast Episode 35 “In Search Of EXCELence?”

As usual it’s taken us longer than we would like. The usual problem of finding planning and recording slots we can both make applies. But I think the episode turned out well. It was certainly fun to make. So here are the show notes. Episode 35 “In Search Of EXCELence?” long show notes This episodeContinue reading “Mainframe Performance Topics Podcast Episode 35 “In Search Of EXCELence?””

Setting Axis Font Sizes In Excel With AppleScript

Just a short post to add another AppleScript snippet some might find useful. (There will be performance-related posts along shortly; I have some in the works.) As you know from previous posts under the tag topics, I’m automating as much of my Excel use as possible. So here’s a short snippet of AppleScript to setContinue reading “Setting Axis Font Sizes In Excel With AppleScript”

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”