The Robservatory

Robservations on everything…

 

An even more improved run-tracking Excel workbook

2019 update: I’ve uploaded new files (in one zip archive this time) with a few changes and fixes. These files are also set up as “master” files: The idea is you duplicate one, rename it for the current year, then use it. When the next year rolls around, repeat the process. This way, you don’t have to use the macro-enabled version to delete data at each new year. Download the new files.

About two years ago, I created a basic-but-functional run tracking workbook (created in Excel). It worked well, and helped me through my 2,016 mile year in 2016. I didn’t run nearly as much in 2017 (on purpose), but 2018 is upon us, and I’m going to up my mileage this year—probably not to 2,018, though!

In preparing this year’s version of the workbook, I addressed a few things that bugged me about the first one: It was ugly, changing years was difficult, and it was ugly. It was also really ugly. Did I mention it was ugly? Anyway, here’s what I’ve changed with the new version:

  • Years are now easily handled; just input the year you wish to track, and the workbook does the rest, including leap years.
  • All run data can be deleted with one button click—and yes, there’s a confirmation first. (Requires macro version of workbook.)
  • The pace calculator is no longer a separate worksheet; it’s integrated into the Overall worksheet.
  • It’s not nearly as ugly as it was before—layout is improved, gridlines are gone, tables are cleaned up, etc.

As noted, there are two versions of the workbook—one contains a macro that can erase the run data from each monthly worksheet, the other does not contain that macro. This is something you’ll only do once a year, but it’s much easier with the macro version.

(more…)

Monkey Bread recipe—the non-dessert variety

Growing up, around the holidays my mom would bake something we called Monkey Bread. If you search the net for Monkey Bread recipes, what you’ll find is a number of dessert-like breads, covered in a sticky brown sugar (or other sweet) coating. Those are not the Monkey Bread my mother made—hers was more of a “regular” bread (containing just 1/4 cup of sugar) that you can eat with your meal.

What makes the bread unique—and fun to eat—is that it’s assembled from small pieces, which you then tear off and eat.

Although I bake Christmas cookies and occasional other stuff, I’d never tried her Monkey Bread recipe. But for this year’s New Year’s Eve party/potluck, I thought I’d give it a shot…and after a couple false starts, I managed to get one done…

As noted, that was not my first attempt. I left the egg out of my first batch (whoops), and missed a whole cup of flour (whoops again) on my second try. But in the end, it came out great, and was well liked at the party.

(more…)

A useless analysis of macOS (OS X) release dates

Updated and republished for macOS 10.14.2; skip it unless you really really care about all the macOS releases. Originally published on November 14th, 2005.

Below the break is a table showing all major releases of macOS (previously Mac OS X) from the public beta through the latest public version, which is macOS 10.14.2, as of December 5th, 2018—the 119th release in total.

Note: Click the ⓘ symbol to read Apple’s release notes for a given update.

(more…)

Updated: Find Keyboard Maestro macros by shortcut

Note: Revised on December 4, 2018 with a much better implementation of the pop-up palette, and some changes in timing and mouse movement.

One of the “problems” with Keyboard Maestro is that it’s so useful I use it a lot, leading to a large collection of macros. Due to the number of macros, sometimes when I want to add a new shortcut, I can’t remember if I’ve used that shortcut before or not. Today’s tip comes in two flavors to address that problem: Simple and Complex.

The Simple solution

Short of just trying the shortcut, there’s a way to check from within Keyboard Maestro itself: Type the macro’s activation keys into the search box, as seen in the box at right.

You can’t do this by pressing the actual shortcut keys—you have to type their character representations. You can do this with the “Show Emoji & Symbols” option under the flag icon in the menu bar, if you’ve enabled it in the Keyboard System Preferences panel. But finding those few special keys (if you even know how to search for them) is a pain.

Technically, you could also use the pop-up character palette macro I wrote, except there’s an issue: When the palette activates, it deactivates the search box, so the characters don’t make it there. It’s also overkill for this task, because there are characters that wouldn’t be part of keyboard shortcuts, and you’d never need the HTML codes, just the characters.

So I wrote what wound up being a set of new macros that make searching for assigned keyboard shortcuts much easier.

(more…)

Use SQL to show MySQL tables in decreasing size order

Earlier today, I noticed that the robservatory database was massive—over 1GB in size, which it shouldn’t be anywhere near (it’s usually around 100MB). This is over the database size limit at my host, so I couldn’t add any new content (nor could visitors comment, create accounts, etc.)

My host offers phpmyadmin acccess, so I connected to the database to try to figure out what was going on. Using phpmyadmin, you can browse tables, perform SQL commands, and export and import data—it’s a must-have tool for managing remote databases.

The first challenge was to figure out which table was causing the problem. To help with that, I wanted to see which WordPress tables were the largest, as that should be a good hint. A web search found lots of possible solutions, but I liked this one the best. Within that thread, I slightly modified one of the queries to do what I wanted:

(more…)

Kitchen upgrade: Sliding shelves

Over the years we’ve had our home, we’ve added some pull-out shelves to some of our lower kitchen cabinets. These work great in the narrower cabinets, making it easy to get to stuff in the way back. However, in wider cabinets, if you use two of the sideouts side-by-side, you give up a fair bit of space due to the width of the slider hardware and baskets. And we seem to need every inch of storage space we can muster.

So I went looking for a full-width solution for our wider cabinets, expecting to have to pay a small fortune for a custom piece. After a lot of time visiting various sites, I decided to try Shelves That Slide, and we’re very happy with the results…and we didn’t have to spend a fortune, either.

(more…)

2018 MacBook Air versus some of its aged predecessors

I recently purchased a new 2018 13″ MacBook Air—my first new Mac laptop in over five years. My hope is that this machine can replace two aging laptops: A 2013 13″ Retina MacBook Pro (I use this when I want more “power” or screen resolution) and a 2012 11″ MacBook Air (I use this when I want portability).

Reviews of this machine are all over the net, so I’m not even going to attempt a full review. If you want an in-depth review of the machine, go read Six Colors’ review, or The Verge’s review or Wired’s review…or just start with Macrumors’ round-up of reviews and go from there.

Instead of a full review, I’ll provide some brief thoughts on the machine, then move on to my main focus: The performance changes in Apple’s smallest laptops from 2012 to today, based on comparisons between my three machines. I was interested in how this would turn out, as the two older Macs are both Core i7 CPUs, versus the Core i5 in the new Air. There’s lots out there to read about how the 2018 Air compares to other current machines, or semi-new machines…but I thought it might be interesting to see how performance has changed in five-plus years.

But first, my thoughts on the new Air…

(more…)

A quick-toggle solution for macOS’ translucency feature

Note: This was originally published in 2015; I’ve updated it with a minor change required for Mojave, and clarified a bit of the text.

macOS includes—and enables by default—translucency, which gives you ‘wonderful’ effects such as this in Calculator:

This is just one example; lots of other apps (Mail and Messages, to name two) contain panes that become grossly distorted by background color bleed-through. I’m not sure who at Apple (Marketing?) thinks this feature is good for productivity , but I find it completely distracting.

As a result, I turn off translucency on every Mac I own. You can do so yourself in System Preferences > Universal Access > Display. Just check the Reduce transparency* box, and you won’t get any more bleed-through. (You’ll also get a solid Dock, and perhaps the world’s ugliest Command-Tab task switcher. Such is the cost of usability.)

* It’s ridiculous that Apple calls this transparency, which is defined as “the condition of being transparent,” and being transparent means being see-through, clear, invisible, etc. This is clearly translucency, or “allowing light, but not detailed images, to pass through.” But I digress…

However, when writing for Many Tricks or Macworld, I often need to take screenshots. And because most users won’t disable translucency, I prefer to take those screenshots with translucency enabled, so that they’re closer to what most users might see. That means a trip through System Preferences to toggle the checkbox, which gets annoying after the second or third time you’ve done it.

There had to be an easier way—and after some missteps, I eventually found it.

(more…)

How to add fixed headers to a variable-width table

I’ve been updating my A useless analysis of macOS (OS X) release dates post for nearly 13 years now (OMG). Over the years, the one thing that’s bugged me was that I couldn’t find a good way to have fixed column headings on that post’s incredibly long scrolling table.

I’d search occasionally, and find various solutions—some using two tables, some using JavaScript, some using pages of CSS, etc. But either I couldn’t get them working, or they didn’t work with variable-width tables, or they didn’t seem worth the effort it looked like it would require to make them work.

But now…

Hooray for fixed headers! Read on if you’d like to use this trick yourself…

(more…)

So you say you want to buy a boat…

About eight years ago, we had the same thought, though we knew almost nothing of boating and ownership, other than we had fun when we went out on some friends’ boats. With some friends of ours (a family of four with similarly-aged children), we went looking for a family boat that would handle at least 10 people, have plenty of space for everyone to relax, and be capable of towing various water toys for the kids.

Our plan was to buy the boat together, and split the expenses 50-50. After much searching, this is what we wound up with…

That’s a 2002 Maxum 2400SD, a 24-foot-long (more like 27 with the swim platform) family cruiser of a boat. Although old in calendar years, the boat had a brand new engine, and appeared to be in good shape. (Maxum was a Brunswick brand; they also own Sea Ray. Brunswick discontinued the Maxum line in 2009.)

One of the things we had trouble finding before we bought our boat was information on actual real-world costs: Just how much money will you spend not just to buy, but to use and maintain a power boat? To help others who may have similar questions, I’m going to share our actual costs from seven years with our boat. If you’re thinking of getting into boating, perhaps some of this cost information may be useful.

(more…)

The Robservatory © 2018 • Privacy Policy Built from the Frontier theme