Skip to content

Apple Universe

Top-level category for all Apple, Mac, and OS X related topics.

Living the bifurcated life in macOS Catalina

If you're a macOS Catalina user, and a user of Terminal for various tasks, you might be surprised at how some things work—or rather, don't work, in Catalina. As a first example, consider the Utilities folder…on the left is how it appears in Finder, and on the right, the contents of that same folder listed in Terminal:

While Finder shows a full Utilities folder, Terminal shows it as empty. Why? If you're somewhat familiar with the technical side of macOS Catalina, you probably know the answer: Apple has separated much of the OS and placed it on a read-only volume.

Apple's "About the read-only system volume in macOS Catalina" page explains things fairly well—basically, what you see as one Utilities folder in Finder is really two things: A read-only Utilities folder, and a user-writable Utilities folder. (If my machine had any user-installed apps in the Utilities folder, they would have shown up in the Terminal output above.)

[continue reading…]



An unfair fight? New iPad Air versus 2016 iPad Pro

At the end of March 2016, I purchased one of the newly-introduced 9.7" iPad Pros—a Gray 128GB Wi-Fi only version, to be exact. And until Friday, that was the last full-size iPad I bought for my personal use. (I did buy an iPad mini at the end of 2017, mainly as a test device for new iOS releases.)

However, early last week I decided it was time to upgrade, and after comparing a few models, I chose the iPad Air—Space Gray, 256GB, WiFi only for $649. I didn't really need 256GB of storage, but Apple, of course, only offers the Air in 64GB or 256GB capacities—and as I had about 110GB of stuff on my old iPad, I had to get the 256GB model.

Physically, they two iPads are nearly identical—despite the iPad Air's much larger display area, it's only 0.4" taller and 0.2" wider than the old Pro (they're both .24" thick), and it weighs but 0.6 ounces more.

As I had a Pro before, why didn't I buy a Pro this time, too?

I mainly use my iPad for games, watching movies or listening to music, using the internet, reading books, and sending the occasional email. As an iPad will never be my primary work machine, I didn't feel it necessary to pay the extra $2502An iPad Pro 11" with 256GB and WiFi is $899 for an iPad Pro. (And by choosing the Air, I still don't own an Apple device with Face ID.)

[continue reading…]



How to securely hide worksheet(s) in an Excel workbook

Important note: Please see the comments—the method I discuss here is secure from casual users. However, the Excel files are just zipped XML files, so it's possible to unzip them and open them with a text editor. When I tested with my dummy salary worksheet, I could see individual salary values, but no actual text—so there wasn't any way to associate a salary with a person. Still, the following should be considered as only a semi-safe solution.

My wife wants to create a budget spreadsheet for the various departments in her company to use. Each department would have their own tab, showing their planned yearly budget by month for the coming year. A super-simplified and unrealistic input worksheet might look like this:

The green areas are the portions that the users would fill out—probably not the department heads, but just someone in the department. Which leads to the problem: There's a worksheet called Salary Info that's used to populate the Salaries line in the workbook. (In my silly example, I just divided the total salary into four equal quarters.)

The problem is that the Salary Info worksheet contains salary information for the entire organization, and this isn't information that should be shared with everyone.The Salary Info sheet might reveal, for instance, that a coworker is leaving in three months—the coworker has told management, but the employee isn't ready to tell the entire company just yet.

So how can you distribute the workbook to all the departments, with the salary info intact, but without revealing that data to everyone?

[continue reading…]



See exactly when an app launched

Update: I guess I should have searched here before I posted this—I wrote up another solution a few years ago, and that one includes a Keyboard Maestro implementation. Whoops! As this one's another method, though, I'll leave it up.

I was working on some stuff for our upcoming Usher 2 release, and needed to know how long Usher had been running. A quick web search found this post, where one of the comments had an answer that works well in macOS:

ps -p pid -o lstart=

Replace pid with the process ID (PID) from ps -ax for the app or process in question, and you're done. But it's possible to make it even easier to use by automating the task of getting the process ID. Here's what I came up with:

ps -p `ps ax | grep [U]sher$ | cut -c 1-5` -o lstart=

The bit between the backticks gets the matching process line from ps, then uses cut to keep just the first five columns, which contain the PID.1When the shell encounters backticks, it processes the commands within those backticks before processing the rest of the command—in this case, the backticked command returns the PID.

[continue reading…]



The 2020 edition of my Excel run tracking workbook

At the end of 2016, I first posted about my run tracking Excel workbook. That first version was crude, but functional, and I used it to track every mile of my "2,016 miles in 2016" running goal. I posted a minor revision for 2017, then made some major updates for 2018. When 2019 rolled around, I made a few more changes, which I released by way of a note added to the 2018 post.

Now that 2020 is here—I know, it's a bit past January, sorry!—I've made yet more changes, and have decided it's time to replace both of the previous posts with one new all-in-one post. Here you'll find a link to the latest version of the workbook, as well as full instructions on how to use it.

[continue reading…]



Quickly create a nested folder structure via Terminal

Have you ever needed to create an empty folder structure with many levels of repetitively-named folders? This doesn't happen a lot, obviously, but if you try using Finder for this task, you'll quickly discover it's really tedious. But a quick trip to Terminal makes the task very fast, and it's not overly complicated.

Let's say you need a folder structure to handle reports that you'll be receiving weekly, but need to keep track of over both quarters and years. One way to handle that would be with a folder structure like this:

(Hopefully obviously, the same structure repeats within each separate year's folder.) Creating that many multi-leveled folders in Finder would be time consuming and tedious. But in Terminal, you can create the entire structure with just one command:

mkdir -p 202{0..5}/qtr{1..4}/week{1..13}

That command takes under a second on my iMac to create the entire directory structure (over 330 folders). Zoom! So how does this work?

[continue reading…]



Add metadata to ripped movies and TV shows

Somewhat regularly, I write about ripping DVDs and Blu-Rays. I tend to prefer physical media and sometimes—especially when buying an older TV series or classic movie—the disc won't include a digital copy. So I rip the disc—this way for Blu-Rays, or just via HandBrake for DVDs—to create my own digital copy.

Once ripped, the problem is that I have a video file that will play, but that has no useful information about what the video is—no metadata about the cast, production year, or (for TV series) season and episode. If I try to add the movie to the TV app (or iTunes, as on my iMac), it will require some hand editing to wind up in the right category, and it still won't have any show information.

Enter Subler, a free app to help you "tag" (add metadata to) movies and TV shows. There are probably other apps out there that do this, but Subler works quite well for me, especially for TV shows.

When I rip a TV series, I'll give the files a filename based on its title and (for TV series) season and episode, like Wings S01E01, or Sports Night S02E04. I then drag and drop the ripped file onto Subler's dock icon, and it opens a window, showing all the metadata associated with the file; here's how the window looked after I ripped the first episode of Sports Night:

[continue reading…]



How to fix Split View in macOS Mojave and Catalina

macOS has had (since 10.14) a built-in Split View mode that lets you use your full screen to display two apps side by side, each in a quasi "full screen" mode. Personally, I never use this feature—why limit yourself to just two windows?—but I know many people do.

In macOS Catalina, you activate Split View via a green button hover, which then shows this pop-up menu:

The activation method is somewhat different in 10.14, but the end result is the same—a window taking up half your display. Except when it doesn't…

As you can see, the full screen menu item works, but the two Split View entries do nothing at all—no error message, but nothing happens other than the menu vanishes.

[continue reading…]



A performance-centric look at the 16″ MacBook Pro

Despite my hatred for the Touch Bar, I recently purchased a new 16" Touch Bar-equipped MacBook Pro (and promptly did my best to minimize the Touch Bar's annoyances). Why buy a machine with an interface I dislike? There are a number of reasons…

First and foremost, I've decided it's not really worth the effort to maintain two laptops—my old 2013 MacBook Pro is used for beta versions of macOS, so that I can test Many Tricks' apps, and my 2018 Air is my travel and "around the house" machine.

With the new APFS filesystem, though, creating additional volumes (basically equivalent to a partition in the old world) is really simple, and with ultra-fast solid state drives, rebooting is relatively quick.

So it's my intent to replace both machines with the new MacBook Pro. Yes, it'll be more of a pain when I travel (heavier and bigger), but I don't travel a ton, and even when I do, I do most of my work in hotel rooms, not in airplanes. And I'll appreciate the larger screen and improved performance, in exchange for lugging a bit more weight around.

What follows is a look at my new portable Mac, comparing its performance with both the 2013 MacBook Pro and the 2018 MacBook Air—similar to what I've done for that same MacBook Air and my 2019 iMac (Part One, Part Two, and Addendum).

[continue reading…]



De-distractionate the Touch Bar

Shocking even myself, I'm now the owner of a Touch Bar equipped MacBook Pro—I purchased the entry-level 16" model last weekend. Why? I'll save the detailed explanation for an upcoming look at the machine and its performance, but the main goal was to replace two laptops with one.

But just because I now have a Touch Bar-equipped Mac doesn't mean I suddenly like the Touch Bar. In fact, my feelings about it haven't changed since I wrote about it two years ago:

The Touch Bar, despite its name, is actually an Eye Bar: It forces your eyes off the screen, down to the Touch Bar, back up to the screen, repeat ad infinitum.

After some hours working with my new MBP, this is definitely a problem—and it's a problem even when I'm not using the Touch Bar, which is pretty much all the time: I've found that the changing images and colors on the Touch Bar grab my eye every time I switch apps…

The camera was focused on the Touch Bar, but when I'm looking at the screen, I see all that activity just below the screen, and it's really distracting. Thankfully, there's an easy fix, and one I'd not heard of prior to buying this machine…

[continue reading…]