Skip to content

macOS

How to copy non-visible formula results from Excel

I use Excel for a ton of stuff, both personal and work. As an example, on the work side I use an Excel workbook to track our apps' hidden prefs—which are set using a long ugly Terminal command1Something like this: defaults write com.manytricks.Moom "PMWindowFadingDuration" -float 0.

These hidden prefs can be used to invoke features we're testing, or to revert a behavior we've changed at some point, etc. For example, Moom has hidden prefs to use the full screen grid without clicking in the big box and to disable the fade in/out of the keyboard controller.

We don't publish all of these, as we're not necessarily ready for them to be put to use by everyone (otherwise, they'd be visible prefs). But there are cases when a user has a specific need for a setting, or when troubleshooting, that these hidden prefs can be very useful. As such, I often have to send someone a defaults write command.

Read on to see how I use Excel's formatting features—plus the ever-valuable Keyboard Maestro—to disguise some of this workbook's formula results, yet still easily copy them for sending to a user.

[continue reading…]



How to auto-crop huge images with ImageMagick

In my recent post A new set of Hubble deep space iMac retina desktops, I included a set of auto-cropped 5120x2880 desktops. In that post, I wrote:

These images were automatically cropped from the master image (after I cropped that; more detail on what I did is coming in a follow-up post), via ImageMagick.

So this would be that post: How to auto-crop huge images using ImageMagick. If you're not familiar with it, ImageMagick is a set of command-line tools to manipulate images. There are a number of ways to install ImageMagick, but I used Homebrew (brew install imagemagick).

[continue reading…]



Number of days until fifth update for macOS releases

  • macOS

Updated for the fifth release of macOS Mojave (10.14), which came out on January 22, 2019

When the third release of macOS High Sierra came out, I charted the pace of its updates compared to all prior Mac OS X/macOS releases. I said I planned to keep that chart current, but decided that I'd use the fifth release (typically around six months from the OS release date) as the baseline.

Here's the latest update for Mojave's fifth update—a bit late, as that update (10.14.3) came out back in January. (Note that 10.0 is not shown, as it had only four releases.)

Click the above image for an in-window larger version, or just view the full-size version directly. (Dates are pulled from my long-running A useless analysis of macOS (OS X) release dates post.)

macOS 10.13 is clearly the outlier of the bunch, taking just 120 days to reach its fifth update, but macOS 10.14 is the only other release to hit its fifth update in under 200 days.

It certainly appears that Apple started pushing more updates more quickly when macOS 10.13 was released, but it's hard to say just why: Is it a new strategy to push updates more quickly, is it buggier macOS releases, or are they catching bugs due to better reporting, the public betas, etc.? I don't have a clue, but it's clear that "more and faster" is a good summary of the last two macOS versions' update releases.



2019 iMac vs Late 2014 iMac—Ripping addendum

In Part 1 of my 2014 vs 2019 iMac comparison articles, I provided an overview and a number of comparison benchmark results. In Part 2, I looked at changes in gaming performance between the two machines.

But there was one more thing I wanted to do: Compare Blu-ray ripping speeds. At the time, though, I didn't have any new movies to rip, and I really didn't want to spend the time re-ripping an existing movie. Now, though, I do have a few new movies to rip, as I'm trying to finish our collection of all the films in the first three phases (now called the Infinity Saga) of the Marvel Cinematic Universe.

That meant buying the films I'd liked the least—The Incredible Hulk and the first two Thor movies. With that came the chance to compare the Blu-ray ripping speed of the two iMacs. I use the method described in my article Revisiting ripping Blu-ray discs, which is this:

  1. Use MakeMKV to create an MKV file on the hard drive that contains the video and audio tracks.
  2. Use Don Melton's Video Transcoding tools to create the final movie from the MKV file.

Using The Incredible Hulk, I timed how long it took to create the MKV file and how long it took to create the finished movie. Without further ado, the results (times are in hh:mm:ss format)…

[continue reading…]



Using command-line Quick Look as a memory aid

I recently reviewed my new third-party mouse, the Logitech MX Master 2s ($70 at Amazon). I love all the customizable buttons on this mouse, and in particular, the ability to create gestures (which are simply a directional drag while holding down a button).

I've used two buttons to create a total of 10 gesture actions on my mouse:

I created the above image from the Logitech Options app, so I can refer to it if I forget which action I've assigned to which gesture. But it's a pain to find the folder on the disk and open it just to see the image. Then I remembered I had an unused button on my mouse1The upper button of the two near the side scroll wheel…

Note: While the following is specific to my Logitech mouse in terms of implementation, read on if you're curious about how to access QuickLook previews from Terminal and/or via a simple AppleScript.

[continue reading…]



Feeling the (Mail) squeeze in Mojave

My new iMac runs Mojave; my old iMac never moved off High Sierra, which I felt was a fine version of macOS. Now that I have no choice but to use Mojave full time (I have it on my laptop for work purposes), I'm finding some annoying changes. Amongst those annoyances, this one is—by far—the most annoying…

That's a set of messages in Mail, as viewed in Classic View mode (using San Francisco Display at 15pt on both Macs).

Somewhere in Apple, someone thought it'd be a great idea to reduce the line spacing in Mail—only when using Classic View, which is my forever-preferred view. Maybe they're doing this to force us to upgrade to the modern view?

[continue reading…]



Force multiple tracks to play as one in iTunes

There are some musical tracks that—even though they're distinct on the CD (or sold as separate tracks online)—are meant to be played together. As examples, there are a number of such Pink Floyd tracks, Queen's We Will Rock You and We are the Champions, and Jackson Browne's The Load Out and Stay.

I thought I remembered that iTunes used to be able to merge such tracks, and said as much on Twitter:

From the responses, I learned that my memory was wrong: You could only merge tracks during a CD import, which you can still do today:

But for online purchases or other non-CD music, the only solution appeared to be exporting the tracks, merging them together, then reimporting as one. (Doug Adams' $5 Join Together, for example, makes the process about as simple as possible.)

I only had a few such tracks I wanted to combine, so duplicating song data and using an external tool seemed like overkill, but it seemed like the only way. Then Chris Jennings came up with a solution that works for me (with some caveats…).

[continue reading…]



2019 iMac vs Late 2014 iMac—Part Two

Update: After I posted this, Brad Oliver contacted me on Twitter about the frame rates for DiRT Rally—he commented that the fact that they were clustered around 60fps made him think I'd left vertical sync (Vsync) on…and he was right. I've updated that section with the modified results, as well as one additional comparison I forgot to include the first time.

Oh, and in case you don't know Brad…he was directly involved in porting DiRT Rally to the Mac for Feral, so he knows his stuff! Thanks Brad!

In part one of the comparison between my old and new iMacs, I provided a brief overview of the new machine, tech specs for both, and a number of benchmarks. (I also tested the video card against a Windows GeForce GTX 1080, and posted a slide-over image that demonstrates the wider color gamut on the new Mac.)

In today's second (and final) part, I'll take a look at video processing performance (via iMovie), how well the new iMac handles gaming, and then wrap up the whole series.

[continue reading…]



Two year old crushes the new (video card) kid on the block…

My 2019 iMac has the new AMD Pro Vega 48 video card, the fastest video card Apple has offered in a (non-Pro) iMac. But just how fast is it? I'll have more to say about it in an upcoming "games shootout" with my 2014 iMac, but I was also curious as to how (badly) it might compare to the video card—an NVIDIA GeForce GTX 1080—in my 2017 Frankenmac.

While I'd love to be able to compare the performance under macOS on Frankenmac, that's not possible as I uninstalled it a while back—I'd been unable to update to Mojave due to a lack of NVIDIA drivers for Mojave. (Which is related to all of this, in that you cannot use an NVIDIA card—with acceleration—in Mojave, even in an external GPU box, because it seems Apple and NVIDIA aren't on speaking terms right now.)

However, because a number of the benchmark apps I used in my 2019 iMac vs 2014 iMac—Part One comparison test also run on Windows, I was able to do some head-to-head testing, even if the difference in the OS adds a layer of unknown to the results.

Going in, I was pretty sure I knew what the results would show: The Windows PC was going to crush the iMac in anything graphically related, but lose in the CPU tests. While the AMD card is a big step up from previous-generation iMacs, it's nowhere near bleeding edge—it's more like "minor scrape" edge—in the Windows world.

Anyway, I ran a bunch of tests, and the results were pretty much as I expected…

[continue reading…]



2019 iMac vs Late 2014 iMac—Part One

When I replaced two aging laptops with a new MacBook Air, I posted a detailed analysis on the performance differences between the three machines. When Apple released the new iMac with a ninth-generation Intel processor and a higher-end AMD video card, I felt the time had come to replace my similary-aged 2014 iMac…and with that replacement, the opportunity to do the same sort of "old vs. new" comparison for others who may be at or over the five year mark with their desktop Macs.

As with the prior comparison, this is not a review of the 2019 iMac—I'll leave that detailed work to others who do it much better than I. I'm mainly interested in comparing this machine's performance to my current iMac—and for the Geekbench 4 tests, with the 10-core iMac Pro.

Note: If you read the first write-up, some of the following explanatory language will seem quite familiar (as in identical)—where it made sense, I simply pasted the same test explanations I used in the prior article.

Overview

Externally (at least from the front) I can't tell the two iMacs apart—if there have been any user-facing changes in the last five years, they're not visible to my eye. From the back, of course, things are a bit different, as Thunderbolt 2 has made way for USB-C/Thunderbolt 3. For me, this means I need a couple of adapters—my RAID is Thunderbolt 2, and I connect a second HDMI display via the other Thunderbolt port. I haven't yet installed/tested these, though I'm hopeful they'll work.

After logging into both machines, though, it's apparent that something's different with the new iMac's screen. For example, here's a screen from the GpuTest app. (I had to grab the frame from an animating scene, which is why they're not identical shapes.)

As screenshots probably wouldn't reveal these differences, I used the iPhone to take photos, then fixed any skewing and cropped them (but didn't adjust color, brightness, etc.) in Acorn.

Both iMacs were set to the default color profile (iMac), and had identical brightness settings.

[continue reading…]