No Picture
Uncategorized

Use a spreadsheet as a database in 5 minutes

This tutorial will get you started with Database abstraction with google apps script and show you how to write a small app that uses a sheet as a database. https://docs.google.com/presentation/d/10rEyXjHxo42YV3wRW46o-CgrAZxFqUxyftHPkjLtbt8/embed?authuser=1&hl=en&size=l   Open do something in 5 with gas-1-use […]

No Picture
Uncategorized

Null should mean something

It’s a common pattern in JavaScript to do this to assign a default value to a variable : var theThing = someThing || defaultThing; In other words, if someThing has a ‘falsey’ value (false, null […]

No Picture
Uncategorized

GitHub and VBA integration

If you develop shared code for VBA, you’ve probably got some massive workbooks that contain multiple projects that you wish you could separate, but it’s too complicated because they are sharing classes and functions. The […]

No Picture
Deprecated

First shot at Polymer

I’ve just completed my first Polymer app and have mixed feeling about the experience. Regulars to this blog and the associated site know that I’m a great fan of Google stuff and like to try out […]

No Picture
Uncategorized

Playing around with Tableau Public

With Tableau, you can do loads of visualizations very simply and publish them on “tableau public”. I never tried Tableau before, so I downloaded the tableau public software to play around with. The other day, […]

No Picture
Uncategorized

parse.com and d3.js mashup

Today’s post pulls together a number of concepts I’ve been playing around with lately. As usual my source data and post theme is based on data associated with color schemes – pantone, paint colors etc […]

No Picture
Uncategorized

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
Uncategorized

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
Uncategorized

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
Uncategorized

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 http://ramblings.mcpher.com/ where this is hosted have gone like this The top […]

No Picture
Uncategorized

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 […]