No Picture
No category

Getting physical again

Real Angry Birds In the toy store yesterday, I came across something odd. Physical games based on virtual ones. We all know  how to play Angry Birds on our smartphones, Ipads etc – but here […]

No Picture
Microsoft Office & VBA

Batman plot in Excel

In plotting functions in Excel I showed how to create plots from equations without needing to create a data table. Using the same template, here is the Excel version of the well known Batman Plot. Using […]

No Picture
Microsoft Office & VBA

Plotting equations in Excel

Roberto Mensa share this post today on G+, reminding me about the Google instant graph capability, and of course I wondered if the same thing could be achieved in Excel. Excel doesn’t really know how to […]

No Picture
Daily REST library

FAA airport status API: The Daily REST library entry for Excel and GAScript

Today’s API is  “FAA airport status”  – a dataSet query API, populating rows in a spreadsheet using the Airport IATA code as a key Here’s the Excel code (included in cDataSet.xlsm downloadable from the ramblings site)

[…]

No Picture
Microsoft Office & VBA

Over 100 versions of cDataSet

I just added a couple of things to cDataSet.xlsm and noticed that I had done this over 100 times. During the same time period, visits to https://ramblings.mcpher.com/ where this is hosted have gone like this The top […]

No Picture
Visualization

Shopping with scoop.it

I’ve recently started to use scoop.it to pull together updates from this blog and the related site, along with anything else I find interesting or useful. It really is a nice way to curate things to […]

No Picture
Integrating Excel with Maps and Earth

The size of circles on Google Maps

On the ramblings site you can see how to create Google Maps straight from Excel, including adding circle overlays. By default, the code generated to plot these circles looks like this.

  Where sz and […]

No Picture
From VBA to Google Apps Script

Rest Library for Google Apps Script

In previous posts I covered a couple of conversions of Excel VBA projects to Google Apps Script, with particular emphasis on maintaining compatibility between the solutions to allow for dual maintenance. Previous conversions have been a GAS […]

No Picture
From VBA to Google Apps Script

How to create javaScript like objects in VBA

In javaScript, everything is an object. Classes don’t really exist  because they don’t have to. To create an class like structure, you just do something like this

  Then you can access employee.id etc […]

No Picture
Javascript

Using JScript inside VBA

Those of you that read this blog, and the ramblings site, will know that the topic content is about equally split between VBA and javaScript. Until today, I had no idea that there was a […]

No Picture
Apps Script & Java Script

Google Apps javascript timer

If you are working with Google Apps Script, one of your priorities is definitely going to be a simple timer. Everything takes longer than you are used to, and you have to be very careful […]

No Picture
Microsoft Office & VBA

OpenCorporate data Excel REST query

I got this idea from Tony Hirst’s great blog. The OpenCorporates API gives rich information many companies. Using Google Refine to reconcile, it cleans up many sources of data to a queryable datasource. So here […]

No Picture
Apps Script & Java Script

Google Apps Script Color Ramp

For those of you that have been following VBA to Google Apps Script, here is another one. This time, it’s a conversion of the Excel color ramp library. You can download the code for and […]