Category: Excel, Power BI & Google Sheets

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 Globally -Rates of change visualisation- Part 4

        I suppose I could use PowerBI but I’ll srick with Excel for the moment. PowerBI has the dashboard but I did find it slow, its speed may have improved but that is for testing another day. I’m using the John Hopkins Github repository of Data which is updated daily and what they use for their

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

Interactive web tables, Jexcel

        I found a post that had an article about an Excel type spreadsheet that you have in your web page with the benefits listed below, so I thought I’d have a play with it. jExcel is a lightweight vanilla javascript plugin to create amazing web-based interactive tables and spreadsheets compatible with Excel or any other

Mirrors of confusion – Check Out/In app fail so far

        I saw this great YouTube video about QR Attendance Using Google Drive with QR Codes Generator Add-ons: I thought it was a great workflow and also an elegant solution. The autoresponse from scanning the QR code to fill out the form. How easy is that? Then I got to thinking how I’d use it. I

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

Free GlideApp for Project Defect list moving COMPLETED ITEMS to another sheet

        Following on from the 2 previous videos relating to this app, after a task has been completed, an email can be sent to the project manager, and others via the app to advise of its completion. So we need to take this item off the TO DO list and move it to another list, and

Free Glide app for Honey product sales at market stall, YouTube thumbnails & Glide email notifications

        Developing and exploring the GlideApp into different areas has been fun and interesting. This particular app was for someone i worked with who also sells honey with a group of people, and one location is at an outdoor market stall. I thought it would be handy for people who were not prepared to buy immediately