Category: Excel, Power BI & Google Sheets

Location Tracker with App Inventor 2 using phone sensor to Google Sheets and then link to GlideApps

I lke GlideApps, they are cool. You can make some great apps with them. But you cannot access youtr phone’s sensors. So I thought, use App inventor to grab data from phone sensors, send it to google Sheets and then use GlideAppps to access the same google Sheets with that data to make a richer

How to import JSON data into Google Sheets to create a live COVID-19 chart

This is in fact an article How to import JSON data into Google Sheets to create a live COVID-19 chart that I came across on my RSS feed from Datawrapper. I want to follow this as it sort of comes full circle. I’d started my covid data exploration with Google Sheets and importXML() and now,

Covid by region NZ -map representation- Part 5

The Ministry of Health(MoH) have posted the original dataset on a different web page of each case and which District Health Board (DHB) they are under. The data can be found here. Instead of by region, its mapped to the District Health Board Regions. So the original map I was using in this post is

Covid by region Globally -Data visualisation- Part 3

At the end of the last post I’d found that the original NZ regional dataset had changed. I was also finding it slow working in Google Sheets as the interwongle seems to be slow with so much demand. So I decided that I’d start working locally. My current process is to get the data, manipulate

Google Sheets Google Analytics add-in to create dashboards

I was looking at the GlideApps showcase and the Bogdan Popa created a News App. In it he uses IMPORTXML in Google Sheets to pull in web data that he filters to different tables. A nice app. I started thinking about what other import formulas does Google Sheets have, I know it has GOOGLEFINANCE for