Use 1Password to fill and save on your iPhone and iPad
Source
Author: Steve Morton
Adding memory foam to AirPods Pro
Interesting hack from Viticci: How I Modded the Silicone Tips of AirPods Pro with a Memory Foam Layer – MacStories
Star Wars Mandalorian ornament
The launch of the Disney+ streaming service was heralded by their Star Wars show, The Mandalorian. Since my social media of choice is Twitter, I immediately muted mentions of the show. Still, my friend Jonathan sent me instructions for an ornament of The Child.
Hope you enjoy making this, and may the Force be with you, especially on Life Day!
Counting Visible cells in Excel
Today, I created yet another report in Excel. As usual, I had used the Format as a Table command and then filtered out some data. The next step was to count the number of rows that were still visible. I used the formula =SUBTOTAL(3,A2:A144) and had the required information. This website has a good explanation of the process, along with how to count rows that have been manually hidden (instead of filtered).
Moving passwords from Google Chrome to 1Password
Helpful article from the developer of 1Password on how to move your saved passwords from Google Chrone to 1Password. Saving passwords in web browsers has been exploited and is not recommended.
Creating a Mac app from a script
This GitHub project, Appify, is a script that creates an .app file from a bash script.
This fork of the project includes how to embed a graphic during the encapsulation.
Creating Icon files with Preview
In macOS, the Preview app is a little-known powerhouse. In this article, the author details how to create (app/website/etc/) icons from other graphics.
When a Mac cannot get online
Per support, there is an IPv6 issue with some networks (apparently Cisco networks are most commonly affected).
Apple has a KB article on disabling IPv6 in macOS.
macOS installer commands
High Sierra
sudo /Applications/Install\ macOS\ High\ Sierra.app/Contents/Resources/createinstallmedia --volume /Volumes/HighSierra
Mojave
sudo /Applications/Install\ macOS\ Mojave.app/Contents/Resources/createinstallmedia --volume /Volumes/Mojave
Vocal warmup
This is intended to be spoken slowly and deliberately:
“Eleven benevolent elephants met Lilly and Lucy in Philadelphia. They went to see Camelot in Unique New York, with guns and drums and drums and guns which they kept in the bodega bodega bodega. They soon came across Brilliant Italian William from Topeka, who merely murmured, ”lilly lally lilly lally.“ Then around the rugged rock the ragged rascal ran, to live among Culligans and Callalillies and let his tone drift off as easily as a sigh.”