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””
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”
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.
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”
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.
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”
“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. Continue reading ““Cryptid Command” Bigfoot/Nessie/UFO Embroidered Patch Set on Kickstarter”
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”
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”
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”