How I think (the blog)
From Excel to Jupyter Notebooks (part 1: installation)
You probably ended up here because you just had Excel crash, again, and you’re sick of it. You’ve probably also heard about R, Python, Jupyter Notebooks and probably have decided on starting your new data analysis journey into Jupyter. Get Jupyter or die tryin’ -absolutely no one said this. After about a week of absolutely
MozCon Follow Up – Automation
Thanks for watching my MozCon presentation! Even though it was only 30 minutes, it took me years for me to get to this point. I’m really excited to share concepts that should help you cut out boring tasks and focus on more important things. Before you start reading, I want to say that programming is
Moment JS in Google Sheets (Apps script) – The easy/lazy way
Date/time handling in JavaScript is a bit of a pain, thankfully there are libraries like Moment JS to save the day. If you want to integrate better time/date handling from Moment JS in Google sheets (the lazy way), this is how you do it: Make a copy of this sheet Your formula is simply =momentjs()
Did it update? Playing with Google’s new Indexing API and getting pages crawled immediately
Google’s new Indexing API support page say “it can only be used to crawl pages with either job posting or livestream structured data”, but of course I was curious and it turns out that we can get regular pages crawled as well, and damn fast. Google’s indexing API for livestream and job postings (posted Dec
Google Docs Formula Test – Can you finish this quiz?
I was training a friend on Google docs and decided to make a little quiz out of it. Most of the formulas translate into Excel as well, but some are specific to Google docs – so, if you’re taking this on, ensure you’re including “Google docs …” while Googling. Make a copy of the spreadsheet
FIX – Windows NPM Node-gyp error for various NPM modules
If you’ve ever tried to install an NPM module like Xml2Js and received these pretty little errors followed by a failure to install Xml2Js (or any NPM module that requires node-gyp), there’s no need to go nuts and install all the dependencies yourself or configure system variables. Just for reference, here’s what your node-gyp errors
How to check if value is in range of cells – Solution – Google Sheets
One of the most useful formulas for me was being able to find if a cell contained a value from a list of items, this excellent Excel formula https://exceljet.net/formula/cell-contains-one-of-many-things was exactly what I needed. The formula: =SUMPRODUCT(–ISNUMBER(SEARCH(things,A1)))>0 also works in Google docs, provided that you created a named range. Here is the spreadsheet for you to look
How to download all attachments from a gmail thread
You may have several attachments within a Gmail email thread, but it’s too time consuming to download one attachment at a time. There’s a Forward All option in the top nav menu that allows you to forward the thread back to yourself, thus allowing you to conveniently download all attachments in a gmail thread. See
How to get Google’s cached copy of a page and text version with parameters
If you can’t get the cached version the good old fashioned way by typing cache:www.example.com into Google search for some reason (other than the page not being indexed or having the noarchive tag), use this URL: https://webcache.googleusercontent.com/search?q=cache:https://www.example.com If you want the text version of the cache, add &strip=1 to the end like so: https://webcache.googleusercontent.com/search?q=cache:https://www.example.com&strip=1