Spreadsheet tip: “is not” or “is not equal to”

If you are looking to set up a condition in a spreadsheet function in a situation where you want to include everything but one thing, you need to use the following:


Turns out the “less-than/greater-than” combo sign means “not equal to”, and it applies to text strings in addition to number strings.

I wasn’t sure what terms to search for initially, and relevant results for “is not”, and “is not equal to” were not giving me the answer I needed. Including terms such as “spreadsheet”, “Apple Numbers”, “function” and “formula” didn’t help either.

Continue reading “Spreadsheet tip: “is not” or “is not equal to””


The One-Line-Per-Day, One-Page Plain Text Daily Journal

I discovered the perfect solution to keeping a digital daily journal: one plain text file, with one line per day that sums up the most significant event(s) of that day.

Read on to learn how I use it, and how it fits into my plain-text journaling system.

Continue reading “The One-Line-Per-Day, One-Page Plain Text Daily Journal”

Prepend Text File with Automator & Shell Scripts

As a followup to my earlier post about how to create a macOS Service (or a Text Expander snippet) to quickly append a text file using Hazel, Automator and Shell Scripts, here’s a way to instead prepend text to a text file using the same tools.

prepend text automator screenshot

Why would you want to do this?

My core interest in setting this up is for plain-text journaling. In a way, I am cobbling together the functionality I find extraordinarily useful in the iOS app Drafts for use on macOS.

I like to capture ideas, thoughts, errands, links, apps, articles, tasks and todos quickly, and I use a plain-text document system I’ve put together over the years. These automation setups remove friction in doing so, which make it more likely I will maintain the behavior.

With this setup and the companion append text automation setup, I can hit a keyboard combo, have a small window pop up where I type what I want to capture, hit OK and the automation goes and appends it to the right .txt file, in the right location, behind the scenes.

I will be writing about my plain-text journaling system in a future post. For now, read on to learn how to set this journaling automation up for yourself.

Continue reading “Prepend Text File with Automator & Shell Scripts”

Alphabetical Keyboard Characters in OS X


If you, like me, use the weird symbols on your keyboard to help you sort files in the Finder, then you’ll be happy to find that I went through the trouble of not only naming a folder full of folders with top-row keyboard characters so you can see exactly how they sort, and then naming those folders so you know what key commands will produce them, but I also made it downloadable so you can just use it yourself. I put this folder on my Desktop for quick reference.

See here for a web table for every last keyboard character in alphabetical order.


Yearly Recaps: A Monthly, Contextual, Plain-Text Journaling System

While I regularly maintain a daily journal, and do so in plain text (while also keeping a concurrent journal in the Momento app on my iPhone for the search and tagging features), often I find that I never actually read any of the old entries. Which is fine, as I mostly just like the habit of recording the information. Recently, I developed a system that is proving to be immensely useful.

Yearly Recaps

Most often I’m trying to place my past in context. Did I start biking to the grocery store last summer or the year before? Was that trip to Utah really just last year? Those are the kinds of mental reminiscing tasks I’m often looking to resolve with journaling.

I started a new plain-text file called Yearly Recaps. The format is simple: I list the year, followed by each month, with bulleted lists for the big events that month:




– Kickstarter funding successful

– bad allergies

– Days Of The Dead artist table in Louisville


The entries are intended to be simple, and just cover the things I might was context for in a year. No thoughts, no daily task recording. Just the big chunks. Months are in standard order, years are listed with the most current year at the top.

The Key: Having It All Together, In One Place

This started out as simply an outline for me to gain some context over my past. I just wanted to see it all written out, in order, in one place. As soon as I started building the entries I realized how powerful this was for me, and that it was going to become a core tool in my journaling system.

I used to spend every Sunday evening doing a weekly recap, where I would review my daily entries and summarize them into a weekly recap. I used those to go back and populate the earlier months in my Yearly Recaps file.

The Weekly Recaps were intended to be the readable summaries, but these monthly summaries have proven to be far more useful. In a sense, the Yearly Recaps are just monthly recaps with typically one or two entries per week. But having them collated in one file for easy context is key.

The Structure

Currently I have just one file for all the yearly recaps, but I’m starting to think I may split them up into one text file per year, as it can be tough to navigate to the desired year. I could use the search functionality in my apps but I get lazy and just end up scrolling.

I’ve found this Yearly Recap system to be the most useful journal I’ve kept yet. I refer to it constantly, and really enjoy the mental Zen it brings having my jumbled memories of the past in a coherent order.

I still journal daily (mostly a mundane recording of the day’s events), but I use and refer back to the Yearly Recaps on a far more regular basis. It’s become an essential tool to keep my head together.

The System

And as far as the system I use: I’ve been gradually moving my note-taking, journaling and to-do lists to a plain-text system over the years. I’ve discussed some of my automated journaling techniques in previous posts. These days, I primarily rely on Dropbox, the Drafts app and the 1Writer app on iOS, and nvALT on the Mac.

Drafts is used for appending daily recaps to a plain-text file stored on Dropbox (with all sorts of automation going on with Hazel on the Mac). 1Writer is used for editing on iOS and nvALT for editing on the Mac. The files are all stored and synced via Dropbox.

The Yearly Recaps file is a manually-edited file so I do most of my editing of that in 1Writer.

I should probably do an entire post on my plain-text journaling system, I just realized I’ve only hinted at some of the advanced methods I use to organize things, but not the process of actually recording things. I’ve got it quite streamlined these days.

“Cryptid Command” Bigfoot/Nessie/UFO Embroidered Patch Set on Kickstarter

Cryptid Command Bigfoot Nessie UFO Aliens embroidered patches on Kickstarter

Cryptid Command Bigfoot Nessie UFO Aliens embroidered patches on Kickstarter

Cryptid Command“, my latest embroidered patch set is now live on Kickstarter until October 31, 2015. The patches feature Bigfoot, the Loch Ness Monster and Aliens/UFOs all with a fun military-themed look.

The main funding goal was reached in under 6 hours on launch day, and the campaign has since unlocked the first of many stretch goals, which include additional patches, stickers, magnets, PVC emblems and more.

Campaign pledges are funneled back into the campaign reward merchandise to offer backers more and more merchandise the higher the campaign funding gets. Pledge now and help unlock more stretch goals and get more free items with your reward!

One-Page Printable Yearly Calendar

I like to see the Big Picture. Most calendars suck for that. I also have idiosyncratic wants. Here’s the list of criteria:

  • The weeks starts on Monday. I started experimenting with this a few months ago and love it. Weekends are chunk and belong together visually.
  • The days are continuous. We live an endless stream of days. The calendar should reflect this experience.
  • It fits on one printable page. I want something I can print out on regular paper, and not have to deal with cutting or assembling.

I found this near-perfect solution to my desires, but being near-perfect, I wanted to make it perfect. So I did.

Continue reading “One-Page Printable Yearly Calendar”

“Sasquatch Brigade” on Kickstarter


I’ve been so busy running my “Sasquatch Brigade” campaign on Kickstarter that I nearly forgot to update this blog to let people know. The campaign fully funded in less than 18 hours, was made a Staff Pick on day one, and as we head into the final week, the campaign just surpassed 1000% funding and the $10,000 mark.

That also means that a LOT of stretch goals have been unlocked, some of which will be Kickstarter-exclusive patches. New to this campaign is the option to pick up the patches with Velcro backing, perfect for your tactical/EDC bag, short or hat. Morale patch fans are going to love this. Ten bonus items have been unlocked. You get a ridiculous amount of stuff for backing at the $25 reward level or higher.

I’ve also got a bunch of upcoming campaigns for other embroidered patch and merchandise sets to follow this one up. A ghost-themed kit, a Bigfoot/Nessie/UFO 3-patch set, more hairy ape-men (Ohio’s Grassman, Florida’s Skunk Ape, and Austalia’s Yowie), a Cthulhu/Lovecraft themed kit, and Halloween monsters. Also in the long-term plans is an extensive trading card series based on similar themes to the patches just mentioned.

Head on over to “Sasquatch Brigade” on Kickstarter and pledge now. The campaign ends Friday, June 12th, 2015 at about 3PM.



I was a former “Foodiot” — an idiot when it came to food. I remember back then how daunting it all seemed to try and get started eating more healthily. At least for an overthinker like me. This post will be a primer of sorts on how to get started eating in a more healthy manner. I’ll discuss how to shop for vegetables, how to store them, and what to look out for.

Continue reading “Foodiot”