How I think (the blog)
Writing to temporary storage in a Google Cloud Function using Node JS
Here’s a quick example on how to do this. I recently had to store an intermediary response before shipping the data off to another resource (API to BigQuery) and wanted to take advantage of BigQuery’s free loading versus streaming. From the Google docs, “The only writeable part of the filesystem is the /tmp directory, which
Zorgon valley boxfaced fish – Full bio
The zorgon valley boxfaced striped fish also known as the black-faced boxfaced striped fish, is a species of boxfaced striped fish that lives not only in Colombia, but also in Brazil and Bolivia. At two feet (0.6 m) long, they are relatively large among species of fish, and their strong, prehensile tails can be up
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