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””

Advertisements

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”

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:

 

2016

Aug:

– 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”

Secure Input & Photoshop’s Hand Tool Spacebar Shortcut

If you are a fellow Photoshop user, and have experienced an unexplained loss of accessing the Hand tool using the spacebar keyboard shortcut, this  may have been caused if you are running password manager software 1Password and have used the “Hide” menu option.

I would have never found this had it not been for the warning on TextExpander‘s menubar icon, and the resulting blog post they published regarding TextExpander and Secure Input.

Quitting 1Password and relaunching it fixed the issue for me, so I can only assume it was indeed the culprit.

Continue reading “Secure Input & Photoshop’s Hand Tool Spacebar Shortcut”