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:

"<>EXCLUDED_TERM"

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

mac-os-x-finder-keyboard-character-file-name-sorting

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.

Enjoy.

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. Continue reading “Yearly Recaps: A Monthly, Contextual, Plain-Text Journaling System”

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

Sasquatch-Brigade-Kickstarter-header-image-v06-staff-pick

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. Continue reading ““Sasquatch Brigade” on Kickstarter”

Foodiot

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”