TIL that you can't change the CSV delimiter or enclosure characters on Excel for Mac or Apple Numbers. You have to use Open Office.
TIL how to build JSON strings in Excel with concatenate.
I never remember the keyboard shortcut for Fill Down in Excel on macOS, so I'm posting it here where I'll have it. Control + D.
I'm catching up on my book notes. Today I posted three more: Show Your Work, Shoe Dog, and E-Myth Revisited.
I'm catching up on my book notes. There are a lot of books I read this past year that I neglected to post notes for, so I'm getting caught up on that. I posted five new books to my Book Notes section today: Kindred, Stories of Your Life and Others, A Burglar's Guide to the City, Boon Island, and The Story of Sushi.
Today I upgraded from Homestead 4.0.0 to 5.0.1 so I could test my sites in PHP 7. That was a major upgrade and a number of things changed, so I decided that I needed to back up my databases before I did the upgrade. I'd only ever dumped specific databases before, but TIL how to dump them all at once. Here is how to do that in Laravel Homestead.
A Praxis participant emailed me last week asking for recommendations on free embeddable charting tools for an article he is writing. I thought that the information would be useful for everyone, so I wrote an article with examples!
Earlier this week I did a major revamp of cagrimmett.com. It started with redesigning my page templates to include a sidebar, then it morphed into making a long-standing goal of mine reality: Reviving the posts from my old 2008-2012 WordPress blog and getting them into Jekyll while preserving old links. Here's how I did it.
TIL how to use the viewbox attribute on an SVG to make it responsive and preserve the aspect ratio.
This month I'm spending some time researching altcoins. I'm posting my notes on Yours.org. First up: Sia.
TIL that you can save changes you make with Chrome Dev Tools directly to your disk.
TIL a ton about the WordPress template hierarchy and the conditionals that select them.
TIL about Genesis hooks and filters.
Derek Magill's 100 Things That Made My Year post inspired me to write one, too. Here are my 100 highlights of 2017: