Skip to content

macOS Apps

Articles about OS X applications.

A spreadsheet to track full-year running miles

2020 update: Everything here is out of date now, and has been replaced with my post on the 2020 version of the worksheet. In there you'll find a download link and full instructions. I'm leaving this article up only because it may be linked to from other places.

 
Update: I've created a much nicer run tracking workbook. Please use that version, as this one is out of date and is no longer maintained. I'm leaving it here because some of the "how to" bits are still applicable to the new version (and it's linked from that post), but I've removed the download link.

To help with my 2,016 miles in 2016 running project, I created an Excel workbook to track my progress. A couple people have asked for the workbook, so here it is…with some caveats and instructions.

First off, this was written for Excel 365, though it should work fine in recent versions of Excel. There is no Numbers version, there is no Google Sheets version…this is it. Start by downloading the worksheet and opening it in Excel.

The first thing you'll notice is that this is a really ugly workbook. The only thing I spent any time "prettifying" at all was the actual vs. goal chart, as that's the thing I tended to look at most often. The second thing you'll notice, depending on when you open the workbook, is that it appears nothing is working. The formulas will not work properly until January 1st, 2017.

[continue reading…]



Remap non-modifiable keyboard shortcuts in any app

Ever run into a program that has some pre-defined keyboard shortcuts you don't like? In most cases, they're associated with a menu item, which means you can use macOS' built-in keyboard shortcuts function to fix them. (In System Preferences > Keyboard > Shortcuts > App Shortcuts.)

But what if the shortcut isn't associated with any menu item? Such is the case in Excel 365, which replaced a couple easy-to-type shortcuts (⌃I and ⌃K for inserting and deleting rows and columns) with much harder to type versions: ⇧⌃= and ⌃-. If there's no corresponding entry in the app's menus, it seems impossible to remap the shortcuts—unless the app itself offers that feature, which Excel did in prior versions.

The good news is that it is possible to remap any keyboard shortcut in any app, as long as you're willing to add one more program to the mix: Some sort of macro app. My example uses Keyboard Maestro, but any app that can send a key sequence in response to another key sequence will do the trick.

[continue reading…]



Apple Mail: Classic or modern layout?

To me, the modern view in Apple's Mail app is basically useless: I keep my Mail window at 1,020 pixels in width, because really, there's no need for it to take up more space than that. But at that width, the modern view's message preview is so tiny as to be basically worthless:

Obviously, that's classic view on the left and modern view on the right. With the classic view, I can read each email as soon as I select it in the list; with modern, I have to double-click a message to open in a new window, which is a waste of time and screen space. Modern only gets truly usable if I'm willing to make the window roughly 1,500 pixels in width.

So which layout do you use? Vote in the Twitter poll for the next day (well, 23 hours and counting).



Revisiting ripping Blu-ray discs

A couple years back, I explained how I rip Blu-ray discs. A lot of time has passed, and I now use a slightly different procedure that results in much faster rips—with the caveat that the resulting file will be larger than the "slow" method, and is technically of slightly lower quality, though I can't visually distinguish the two.

The new method uses Don Melton's amazing video transcoding tools, a set of Unix programs that optimize video conversion in ways you cannot do (or easily do) in the Handbrake GUI. If you're new to Unix, but would still like to try these tools, I wrote a detailed set of instructions that should help get you up and running.

Using these Unix programs, you can rip a disc with various parameters, including one to optimize for speed (with good image quality) and another that tries to minimize the file size.

Here's a quick comparison of all three methods, as tested with the three-hour Hamlet Blu-ray. The 'Handbrake GUI' rip was done using, well, the Handbrake GUI as described in my original article. The second and third rows use Don's tools set to quick and veryquick modes, and the final row uses Don's tools set to optimize the file size.

MethodData CopiedConvert (hrs:mins)File Size
Handbrake GUI47.5GB3:526.8GB
transcode - quick40.1GB2:209.2GB
transcode - small40.1GB3:126.5GB

Tested on a late 2014 27" iMac with a 4GHz Core i7 and 24GB of RAM.

Using Don's tools in "quick" mode, you save time two ways: 7GB (15%) less data is copied to the hard drive, and the conversion process is over 90 minutes (38%) faster. The downside is that the final file size is 2.4GB (35%) larger. And that's what they call a tradeoff.

Using the "small" mode in Don's tools, you still save the 7GB (15%) of data copy, and still save 40 minutes (17%) over the original method. In addition, the file size is smaller than the Handbrake GUI version.

To summarize, regardless of whether you care more about file size or ripping speed, Don's tools provide an advantage over the Handbrake GUI: Either method is notably faster, and the small option generates smaller (or probably at worst, very similar) file sizes. (There's also a "big" option, if you don't mind somewhat larger files at a higher quality level.)

Keep reading to see some examples of the image quality of each method, and information on how to install and use Don's video transcoding tools.

[continue reading…]



Presenting the Apple TV (4th Generation) Password Tester

Earlier, I sent out this hopefully-humorous tweet about the difficulty involved in clicking one's passwords into the new Apple TV password input screen:

Presenting LIMNOPHILE, a 10-character yet easy-to-type Apple TV password.

The chart is just an Excel file, with absolutely no logic—I just colored the squares and counted to fill in the data. But then I got this reply…

So I thought "Why not?," and created an actual spreadsheet that will "click check" any all-letter password you feed it. Here's what it looks like in action:

Just replace RIDICULOUSLYLONGWORD with whatever you like, and see how it'll "click out" on your Apple TV. Obviously, this tool is totally tongue-in-cheek!. Any password built with this tool will be weak as heck. It's just for fun, so don't take it seriously.

Feel free to share and modify, but I'd appreciate a credit back if you do so.

Download Apple TV Password Tester (44KB)

Please note that this is an Excel file, and it relies on conditional formatting, so it may not work in Numbers.



On the vagaries of saving from Mail

As I suspect is true of many of you, I buy a fair bit of stuff from Apple, whether in a physical Apple Store or in the various online stores. I receive electronic receipts for all these purchases, which look something like this (but with all the personal info filled in, obviously):

Until yesterday, I have just filed all these receipts in their own folder in Mail (in the On My Mac section, so they're stored locally). But in the process of going paperless, I wanted to move them directly to my hard drive, so I could store them in a more-organized manner, and keep them alongside my other receipts. That meant saving the messages from Mail to the disk.

I had only two objectives when saving:

  1. Maintain the formatting and images in the original receipt
  2. Have the message content indexed by Spotlight

You'd think this would be a simple proposition, but you'd think wrong…the above two criteria are basically mutually exclusive with Mail's Save As feature. Read on for the details, and my eventually-discovered workaround (and labor-saving shortcut).

[continue reading…]



Folderizing Office 2016

In case you missed it, Microsoft just released Office 2016 for Mac. Well, released if you're an Office 365 customer. I am, so I downloaded the release version today. I'd been playing with the betas, and one thing bugged me: the installer wouldn't let you pick an install folder.

Sadly, the same holds true for the release version; after installation, my Applications folder was the mess as shown in the image at right. Ugh.

My Applications folder resides on my boot SSD, and I like to keep it tiny and tidy. Tiny in the sense that only my most-used apps reside here; others are on my RAID. Tidy in the sense that I don't like looking at long lists of apps that all start with the same word, e.g. Microsoft. So things like Office go into a folder, helping at least the tidy side.

Eric Schwiebert of Microsoft tweeted an explanation for this user-unfriendly behavior:

While I understand the rationale, I don't agree with it. Office isn't yet in the App Store, and even if it were, that's not where I got it from. So why are you affecting my options for a version that neither exists nor that I even have? In any event, I wanted Office 2016 in a folder, so I set out to find a way to do that.

[continue reading…]



For want of a Play All button in Apple Music

As has probably most everyone else, I've started my three-month Apple Music trial. I listened to about an hour's worth of Beats 1 Radio on the first day, and found it basically forgettable. (All the "Beats 1 worldwide!" voiceovers during songs certainly didn't help—but I figure they're doing that to prevent people from recording the high quality stream.)

Anyway, I was most interested in the For You feature, as I wanted to discover music similar to what I liked, but that I may not have heard before. Using my iPhone, I went through the "tell us about your tastes" feature in Apple Music, then switched back to my Mac to look at the For You section in iTunes. There I found an assortment of playlists:

Some I wouldn't like, some I would, and (most interesting to me), there were some that had stuff I hadn't heard before. Unfortunately, this is where Apple lost me…

What I wanted to do, as I looked at this wide assortment of music, was just hit the Play button, and let iTunes navigate the entire selection. But I couldn't, because iTunes' playback buttons are all grayed out. Argh!

The only way to listen to these selections is one playlist at a time. But that's not how I listen to music. I enjoy a broad selection of music across many genres, and very rarely do I listen solely to one artist, one album, or even one genre. Why? Because when I do, I wind up getting burned out on that artist, album, or genre, such that I don't want to hear it again for a while.

Instead, I just play music, paying no attention to genre, artist, or album. And once I start iTunes playing, it's typically playing all day without any interaction from me. But if I want to use Apple Music's For Me, I'll have to return to iTunes to pick new selections as each selection finishes. Honestly, for something that's background as I work, that's too much effort.

In the end, as much as I'd like to use the For Me feature in Apple Music, I just can't see myself doing it unless Apple adds a Play All (random, of course) button. Please?



Use Intel’s Power Gadget to keep an eye on your CPU

If you're the type who likes to keep an eye on your system, you may be familiar with tools such as Activity Montior's CPU meters, or iStat Menus, which displays a ton of system info via its menubar icon. Neither of these tools, however, really show you what the CPU itself is up to—and that's where an Intel-provided tool enters the scene.

The Intel® Power Gadget shows you exactly what your CPU is up to: how much power it's using, what speed it's running at, and its temperature. As seen in the image at right (click for larger), it graphs these three values over time.

The data you're seeing there is from my 4GHz Retina iMac, and the screenshot was grabbed while it wasn't doing much in particular. What really stands out to me is how often my 4GHz CPU is running at something closer to 3GHz; if the CPU isn't being called on for its full power, I'm assuming it slows itself down to reduce power usage.

But as soon as you do something that demands the CPU's full power, the napping stops. Here's a brief movie I created showing the CPU tracking when I started ripping a Blu-Ray:

The machine is basically idle at first, then I start the rip after 15 seconds or so. As soon as the hard work starts, the power and temperature charts shoot upwards, and over time, the CPU speed pegs right around 4GHz; the naps are gone.

I'm not sure how much real-world use this tool has, but from a geeky perspective, it's pretty cool being able to see exactly what your CPU is up to at any point in time. (You can even send the data to a log file, in case you really want to study power, speed, and temperature over an extended time period.)



Fix Messages’ image pasting by killing its engine

Kirk McElhearn explains how Messages in Yosemite has trouble sending pasted images. These problems typically only occur between people who use AIM accounts in Messages; sending pasted messages when using iMessages' accounts seems to work fine. (I use an AIM account to keep iMessage traffic off my main Mac, and for its great screen sharing.)

Kirk's article details the fix, which is to kill the imagent process, which is what controls Messages. He uses Activity Monitor to do so, which works fine. But I have to kill the stupid imagent many times a day, so I wrote the World's Easiest AppleScript™ to do the work for me.

[continue reading…]