Category: Excel, Power BI & Google Sheets

Macro Tools Following on from Macro productivity tools using AlternativeTo I came across: SikuliX automates anything you see on the screen of your desktop computer running Windows, Mac or some Linux/Unix. It uses image recognition powered by OpenCV to identify and control GUI components. This is handy in cases when there is no easy access to

While at Wellington City Council working on Strategic Assets, one of the exercises of the Building Asset Team Leader, Tane Dunne,  was to work out what the top major cost items were for the assets over a period of time, in this case 50 years. The assets were captured by the SPM  survey team of

It’s not often one comes across a tool that looks really really interesting where you think you can get some great leverage, but from what I have seen so far Coda.io looks really useful. I’m even starting this post off with a Part 1 as I expect to be doing quite a lot of exploration

Capturing auditoria, theatres etc for AM/FM and for ongoing use of the model for seating planning can be useful. With numbered seating you can allocate different prices for different seating, you can also change pricing for different event configurations for multi-purpose arrangements. I have done seating on a number of buildings in Wellington when working

Web Scraper I was looking at Firefox addins and came across a couple of web scraping add ins. Data scrapper and web scraper. The first one I couldn’t get working and the 2nd one I had to watch a video before I could get the settings sorted. Recently, about 4 months ago, I added a

Following on from the previous post  I want to try and be able to update a Google Sheet from a web page via the link. I will be following this video: Unfortunately there is not a link to code for this addition, unlike videos 1 & 2 so I’ll need to write it from looking

I like it when I find some useful code and it works straight away. When it doesn’t I end up spending an awful lot of time trying to figure out what is happening. turning the programmers dark magic into something comprehensible. Continuing on from the previous post I started to look at the output and

Getting data from the web and being able to manipulate it and display it on your own website. Using Google sheets to refresh the data at specified intervals allows you to get live feed from sites that do not have an API for drawing the data down. At the end of the last post I

My son in law, Karl Reece is playing in the Canoe Polo 2018 World Championships Welland Canada for team USA. I am very impressed with his accomplishments. Come on USA & NZ. Games played, won/lost based on Groups in table below at the end of 4/8/2018 at Canoe Polo 2018 World Championships Welland Canada.  I

The last few posts have been looking at data from the Web into Excel or using API’s. Then doing some graphics with the data. Excel is a bit static. You have captured the data from the web and you have to send someone your workbook to view. They may not update the data, so it