Google Sheets is a great tool to interactively work with an assortment of APIs to work as an intermediary database for experiments or small scale data processing. Here we’re going to look at how we can query our Quickbooks data and display it in a sheet to then merge with any other data set like Read More
Bitcoin Arbitrage Visualization with Google Sheets
If you have access to international bitcoin exchanges, you might be able to take advantage of bitcoin arbitrage opportunities. Google Sheets has a great Scripts features that allows you to program requests to APIs in Javascript and I will show you how to store all of that data in Google Sheets and even receive email Read More
The Most Common Myth About Cross Device Tracking
It’s a common problem, we open our Google Analytics dashboard and click on the acquisitions tab and look at the reported numbers for facebook and it’s a lot lower than what facebook reports. My initial response was to distrust numbers from facebook since they have a history of manipulating their users but it seems like they’ve Read More
Using Google Analytics to Track Your Customer’s Journey
This is Part 1 of a series on how to capture more relevant data from your visitors and using existing tools like Google Analytics to gain more insight into attribution. The Attribution Problem Attribution is a difficult problem to solve. We’re not often certain which marketing channels are driving conversions to our businesses and that makes it Read More
Adding a WordPress Blog to Your Rails App
If you’re running a rails application with a blog like I was, you we’re probably using something that utilized jekyl. There are some good blogging platforms out there and when I decided to add a blog to my site, I decided to use toto. At the time I thought adding all the html tags myself Read More
Using Node.js and OpenCV to Count Colonies on a Petri Dish
If you’re looking for a relatively simple way to automate routine tasks that involve extracting information from images, using computer vision libraries like OpenCV might be a great tool to accomplish your goals. As an example, we’ll take a look at a routine task that most scientists do that isn’t a good use of their Read More
How to Turn Your Product Idea into a Reality
If you have an idea for a product but don’t have any idea how to go about getting it made, this post is for you. Maybe you’re a business owner and you can’t seem to find software that suits your needs. Or maybe you’re an average Joe but you’d like to see if your idea Read More
Google Sheets Formulas
Some google sheeets formulas to manipulate data in the cloud. Items will be added as I make use of new formulas. Index Split cell at a specific character or set of characters
|
1 2 3 |
//1. Split cell at a specific character or set of characters // where B2 contains multiple words to be split at a comman and a space which will split into C2 and D2 =SPLIT(B2,", ") |
Working and Living in South East Asia
I haven’t updated my blog consistently for the past few years and I wanted to give an update on what I’ve been up to. About the time my blog posts have whittled down in consistency is when I made the decision to start traveling (sorry I’ve been busy). It was also right around the time Read More
Notes on Computer Vision by Richard Szeliski
Introduction A little over a year ago I embarked on a project that involved computer vision. Not having much experience in the field, I read as many books as I could find on the subject and the most useful book I discovered was Richard Szeliski’s book: Computer Vision (2010) which is free to download. Below Read More