Welcome to the blog

What nextThinking about what to work on next for the Excel Ramblings site, I wondered how I could pull together ...
Read More
Completing the JSON deserializer/serializerI was missing being able to deal with arrays and could only deal with strings in the ...
Read More
Roadmap Project RecapSome time ago I started to play around with a method to make Roadmaps from Excel data. Since ...
Read More
I've been looking at how to use cookies to pass data between excel sessions and of course outside Excel. Having ...
Read More
Ive been using Google Docs as well as Excel for a while now, and certainly Excel is more comfortable a ...
Read More
Google GadgetsThis is the standard way to do charts in Google Docs, as well as being easily embedabble in web ...
Read More
Roadmapper updateI finally got round to implementing the roadmapper as a google visualization gadget. All the source code and gadget ...
Read More
Using google code to host projectsI moved the gadget and associated code to googlecode.com hoping to host it there. If ...
Read More
Google GroupsSince I get a lot of correspondence from people who have downloaded stuff, I thought it might be useful ...
Read More
What you needIt took me a while to find out how to do this, but it's really simple.Implementing this means ...
Read More
A generic analytics gadget.Following on from my last post on adding Google Analytics Codes to track usage of your gadget, ...
Read More
Analytics with no Javascript anyone?My last post covered how to inject Google Analytics into pages where it was not really ...
Read More
I came across a problem today, where I wanted to create a Google Intensity Map based on a selection of ...
Read More
Diminishing returns for more effortYou will be very familiar with the law of diminishing returns, where you get a lot ...
Read More
Classes for Excel Data AbstractionIn a number of articles and topics on my website i have referred to a collection of ...
Read More
Yesterday I posted an update to the data abstraction classes for Excel.I realized that there is also a method to ...
Read More
In various posts I have covered ways to get data in and out of Excel and other PC based systems ...
Read More
Sometimes you have a range of dates and you need to come up with a scale that makes sense for ...
Read More
Following previous developments on hiding data in excel objects, Excel jSon conversion and dynamic forms I figured it was time ...
Read More
Looking at Google Analytics Data for my site, I notice that there are 2 distinct populations. Those that look and ...
Read More
Mapping visualization layers from ExcelThe Google Maps API is a wonderful thing, allowing you to convert an unstructured and incomplete ...
Read More
Excel Data Manipulation Classes I notice from Google Analytics the the cDataSet pages are by far the most popular on ...
Read More
There is a simple API to retrieve google books data. There was an interesting question on our forum yesterday asking ...
Read More
In a previous post I covered how you could use the Google Maps Api to complete and parse addresses for ...
Read More
I have already looked at geocoding with Bing Maps -vs- Google Maps and Google Maps is a clear winner. Yahoo ...
Read More
Excel and Google Maps.Following my previous posts comparing the geoCoding capabilities of Yahoo, Bing and Google Maps I have now implemented ...
Read More
Geocoding ExcelWhile looking at how to connect Excel to Google Maps,  I implemented a capability in vba for each of ...
Read More
Creating Data Driven Mapping applicationsIn a previous post I looked at the the various mapping packages and how they compared ...
Read More
Google Visualizations on Google Map infoWindows and Google Earth BalloonsA few weeks ago I wrote about generating data driven mapping ...
Read More
Changing the markers on Google Earth to something in your dataYesterday I introduced the capability to generate google maps and ...
Read More
Another VizMap generated appplication - the British Royal Family and their homesIn the Excel ramblings site, I cover how to ...
Read More
Flying around Google Earth MarkersIn last weeks blog entry, I showed how to generate a Google Earth or Google Maps ...
Read More
Ramblings web site has a new lookJust spent a little bit of time on Google Sites cleaning up the ramblings ...
Read More
Excel-jSon-Excel in one line of codeOn the ramblings site, I set myself the challenge to write some classes that could ...
Read More
Twitter, Google Visualizations, Google Maps, Google Earth, Excel - all together.In various posts such as Flying around with Google Earth and The ...
Read More
What are generated VizMap applicationsThese are mapping applications integrating Google Maps, Google Earth, Google Visualizations and Twitter.Here is an example ...
Read More
Eliminating repetitive coding of Excel web service integrationI find myself writing more and more web service to Excel integrations. Here ...
Read More
Rest - jSon - Excel in one line of codeMy recent post on how to Excel-jSon-Excel in one line of code, ...
Read More
Following the post earlier on rest-jSon-Excel in one line of code , I found that you can do the research and ...
Read More
Sorting chapter/bullets numbersQuite often you need to sort data that has some kind of chapter numbering, such as1.11.1.22.1.12.12.2A specialized form ...
Read More
Managing stock portfolio in ExcelIn a previous entry, I described how to add new entries to the rest-Excel library. Up ...
Read More
Excel Roadmapper from simple table dataSome time ago, I showed how to develop a VBA roadmapper on the ramblings website. I've ...
Read More
What's trending on twitter to ExcelIn a previous entry, I described how to add new entries to the rest-Excel library. Here's another ...
Read More
Interpreting sentiment from phrases.I came across http://tweetsentiments.com/ the other day, which is a service that tries to analyze the sentiment expressed in ...
Read More
Abstracting an Excel data source.In almost of all of the downloadable examples on the ramblings web site, I use a ...
Read More
Today's post is about how to create a palette to use for a heatmap, and how to apply it to ...
Read More
Combining multiple rest queries in a single WorksheetIn previous posts, I covered how to get tweetsentiments into excel and how to ...
Read More
The tagCloud classToday's post will demonstrate how to generate tagClouds from various sources in Excel. As an example we will ...
Read More
tagCloud in OutlookIn a previous example, I showed how to create a tagCloud of various Excel data sources, with a downloadable ...
Read More
Color RampsIn a previous post, I showed how to automate the creation of a heatmap in Excel.  It occurred to ...
Read More
You are ready to move to the cloud, but what about all those legacy vba apps? Are they really going ...
Read More
Lets say you have an Excel workbook consisting of tabs, all in the same format, that various people completed. You ...
Read More
It's well known that reading all the values at once from a Google Spreadsheet is much more efficient than doing ...
Read More
In a previous post, I introduced the concept of local caching of Google Docs Spreadsheet Values to be able to ...
Read More
Conversion effort A few weeks ago I wrote about starting my effort to convert a complex VBA project to Google ...
Read More
On the ramblings site, you will find lots of downloadable examples and explanations dealing with connecting Excel to Google Maps ...
Read More
Back to the theme of 'do it in one line' today.Thinking about some the jSon - Excel capabilities on the ...
Read More
Today's post is about how to use the jSon to treeView capability in a previous post, and apply it to ...
Read More
For those of you that have been following VBA to Google Apps Script, here is another one. This time, it's ...
Read More
There are many Google Mapping Examples in the Excel and Maps Integration section of the Ramblings site. So much so ...
Read More
I got this idea from Tony Hirst's great blog. The OpenCorporates API gives rich information many companies. Using Google Refine ...
Read More
If you are working with Google Apps Script, one of your priorities is definitely going to be a simple timer ...
Read More
Thanks to Tony Hirst blog, where he demonstrates the Ergast API  I have another entry to make in the Rest-Excel ...
Read More
Yesterday, I showed how to get all the f1 circuit names and locations using the Ergast API along with the ...
Read More
Those of you that read this blog, and the ramblings site, will know that the topic content is about equally ...
Read More
In a post the other day i covered how to use the scriptcontrol to call javaScript directly from VBA. Considering ...
Read More
If you open an Office Document, you might occassionally find your self with an error that tells you that your ...
Read More
In a previous post I covered how to navigate REST responses using a simple treeview control as well as how ...
Read More
I only recently became aware of Google Moderator. It's a very simple tool to get sentiments on topics, ask questions, ...
Read More
I had some questions about authentication from users of the Excel Rest library. Typically Rest queries are authorized through the ...
Read More
In javaScript, everything is an object. Classes don't really exist  because they don't have to. To create an class like ...
Read More
Passing arguments in VBA can be a pain. Considerfoo(a,,,,b,,,,c,e)Of course in some cases you can use named arguments, but the ...
Read More
In previous posts I covered a couple of conversions of Excel VBA projects to Google Apps Script, with particular emphasis ...
Read More
As part of creating a framework for dual maintenance of Google Apps Script and VBA versions of the same application, ...
Read More
First of all thanks to Tony Hirst for blogging about this in the first place to put me on the track, ...
Read More
On the ramblings site you can see how to create Google Maps straight from Excel, including adding circle overlays. By default, ...
Read More
At last we can now create a library of useful stuff in GAS and access it (or share it) from ...
Read More
Last week I posted how to create Sankey (flow) diagrams straight out of Excel. Let's continue on that d3.js theme ...
Read More
Mashing up capabilitiesI set myself a little challenge of pulling together a few different things I've been working on.From a ...
Read More
I've posted a few examples of d3.js lately, such as mapping tweet sentiments on a force diagram,  d3.js tree diagrams, ...
Read More
I noticed this morning that Huffington post released a REST API exposing all their polling results. I've added that to ...
Read More
I've written about d3.js force diagrams, mapping tweet sentiments, , d3.js trees, Sankey diagrams and various other stuff on the ramblings site all of ...
Read More
I've recently started to use scoop.it to pull together updates from this blog and the related site, along with anything else ...
Read More
I'm taking a break from d3.js and playing around with the new Apps Script DB. Those of you who read these ...
Read More
What no server?That's right - you can serve up data from your Google Apps Script directly. In my post the ...
Read More
In a previous post I covered how to use the Google Apps Script ScriptDB as a database from which to serve ...
Read More
I just added a couple of things to cDataSet.xlsm and noticed that I had done this over 100 times.During the ...
Read More
I haven't posted anything on new entries to the rest-excel-gas library for a while. As I mentioned in this post the library itself is ...
Read More
Going back to the theme of 'doing complicated things in one line of code', here's a mash up of cDataSet, ...
Read More
In various posts such as this one, I've covered new entries to the REST library but it's been kind of haphazard ...
Read More
Today's API is  "FAA airport status"  - a dataSet query API, populating rows in a spreadsheet using the Airport IATA code ...
Read More
Data from CrunchBase API directly into an Excel or Google SpreadsheetToday's API is  from "crunchbase" which is a free database ...
Read More
Data from CrunchBase API directly into an Excel or Google SpreadsheetToday's API is another query type from "crunchbase" which is ...
Read More
In passing arguments in VBA using jSON I covered how you could use javaScript Object syntax to pass complex arguments to ...
Read More
Geocode with Yahoo API directly into an Excel or Google SpreadsheetStrictly speaking today's API doesn't really qualify as 'API of ...
Read More
Shorten URL API directly into an Excel or Google SpreadsheetToday's API is from "ttb.li" which is a url shortening service ...
Read More
You have probably read that jSon works well with javaScript because 'it is javaScript syntax'.Consider this javaScript (actually Google Apps ...
Read More
I came across ifttt.com (if THIS then THAT) the other day. Essentially it's a simple way creating a trigger based ...
Read More
In Starter implementation of R-melt for Excel I introduced a one liner in Excel/VBA to transform thisinto thisYou could consider this to ...
Read More
On this blog, and on the ramblings site there is a growing number of code samples, but of course as things ...
Read More
Geocode and get administrative details and geoHash link  from a UK postcode directly into an Excel or Google SpreadsheetFollowing on ...
Read More
Random Neil deGrasse Tyson quotesThere's probably no practical use to today's API of the day, except that I am always ...
Read More
Unlike Google Apps Script, which has a fine cloud based library capability, sharing and keeping code current for non-professional developers ...
Read More
Get rxNorm drug data into Excel and Google Apps ScriptAside from being a little specialized, today's API is another quite ...
Read More
Geo code from ip and host namesToday's API is a straightforward query per row, meaning that data is retrieved from ...
Read More
Google currency APILately for this spot I've been selecting APIs that are out of the ordinary, and which allow me ...
Read More
In messing around with scriptDB, I covered some usages of scriptDB when it first came out, along with a method ...
Read More
ScraperWiki APII've been taking a look at scraperWiki lately. In case you haven't come across it, it's a framework to allow you ...
Read More
In this post about using the scraperwiki API I covered how to get a list of publicly available scraperWiki data straight into ...
Read More
In various posts and articles I've been exploring uses of the Google Apps scriptDB datastore. One of the things I've been mulling over ...
Read More
oAuth  arghhh..When I was looking around for a way to easily implement oAuth, and be able to use it from ...
Read More
In scraping the scraper I showed how to get scraperwiki data into both Excel and Google Apps Script. More interestingly though, ...
Read More
All of you who run a web site or a blog will probably be able to relate to this. The ...
Read More
Today's entry is pretty cool. I came across the urbarama site, which describes itself as "a collaborative world atlas of ...
Read More
Today I'm going completely off topic. I was fascinated by a G+ plus by John Walkenbach where he referred to this ...
Read More
Lately I've been posting about the Google Apps Script Content Service and how to use it as a 'serverless' Rest API ...
Read More
Creating d3.js tree diagrams directly from Excel, shows how to take a simple list of Excel data and create d3.js ...
Read More
Continuing the theme of using Google Apps Script Content service and scriptDB for lots of things, today's post cover a ...
Read More
I've been messing around with the google Drive API lately, and haven't really found out how to use it to ...
Read More
Roberto Mensa share this post today on G+, reminding me about the Google instant graph capability, and of course I wondered ...
Read More
In plotting functions in Excel I showed how to create plots from equations without needing to create a data table. Using ...
Read More
Enterprise Architects often like to refer to Winchester Mystery House as an example of what you get if you build something with ...
Read More
In using Google Apps Script as a jSONP proxy, I covered how you could use GAS to get over javaScript ...
Read More
In Google Caching and faking jsonP, i showed how to use google cache to avoid multiple calls to the same ...
Read More
I came across a great site, builtwith.com, that shows the technology being used in a given web site. You can ...
Read More
In the builtwith.com api rest library entry for Excel I covered how to get data about a given web site using ...
Read More
I don't know about you, but I have trouble keeping all my various Google Apps Script shortcuts and keys (links ...
Read More
Excel liberation is all about being able to step outside Excel, whether it's getting public data, integrating with other platforms ...
Read More
GAS just keeps getting better. I was thinking the other day about how I might be able to embed sample ...
Read More
In a previous post I showed how Google Apps Script could return the contents of a script as Json so ...
Read More
Usually on this blog and the associated site I cover topics to do with getting data in an out of Excel ...
Read More
When working with spreadsheet data, I always use sheet caching - a class in the mcpher library. This gives great ...
Read More
The other day, I showed how to prettify Google Apps Script snippets and scriptDB contents, include them in web sites, ...
Read More
In publishing gists and publishing Google Apps Scripts I showed how to prettify and embed  snippets in web sites, blogs and so ...
Read More
I posted how to include and prettify snippets from GAS, Gist, and scriptDB the other day, adding the ability to ...
Read More
It's been a while since I played around with d3.js. Previously I've covered Sankey diagrams, trees, force diagrams and a ...
Read More
If you've been following the various posts about publishing source code from gists, google apps script, scriptdb and so on, ...
Read More
I'm finding this ability to embed prettified source code a google site gadget or iframe really useful. The other day ...
Read More
Real Angry BirdsIn the toy store yesterday, I came across something odd. Physical games based on virtual ones. We all ...
Read More
I've been looking at the Mozilla Open Badges initiative lately, as a way to improve engagement with a particular site or ...
Read More
I'm finally awarding  Mozilla Open Badges through a  complete badge environment that handles questions, marking, badge assertion, persona authentication and Mozilla ...
Read More
In Color Ramps for Google Apps Script I covered how to created heatmaps and other color ramps.Picking a good contrast font ...
Read More
I guess it's time to look at what's been going on with the website and blog for 2012, after Martin ...
Read More
You may have used the doughnut chart in Excel in order to produce a chart like thisThis is fine, but ...
Read More
I've done a series of posts lately about Mozilla open badges, in particular, showing how to implement a badge issuing ...
Read More
I saw a great blog post on Reshaping Horse Import/Export Data to Fit a Sankey Diagram from Tony Hirst a ...
Read More
A while ago, I posted something about interesting scraperwiki data, that's to say public web scrapings that people had created ...
Read More
Figuring out how to serialize native VBA classes to jSon is something I've been working on in the background for ...
Read More
Someone asked in our forum yesterday about Facebook Query Language - FQL. Could we get data straight into Excel from ...
Read More
I find myself doing a fair bit of VBA at the moment, It was a little adjustment coming back, but ...
Read More
We had a question on our forum the other day about whether it would be possible to inherit the cell ...
Read More
Here's a little bit more on the subject of VBA string manipulation. I showed in a post the other day ...
Read More
In a previous post I covered a way of automatically including and inserting VBA code in Excel from gists. You ...
Read More
I'm going back to Google Apps Script for today's post.I've been on a little diversion playing around with color  in VBA, ...
Read More
In playing around with color in VBA I introduced a bunch of functions to manipulate various color spaces from VBA. Digging ...
Read More
jSon /VBA functions have always been the most popular topic on the Excel Liberation site and forum. The interesting part about ...
Read More
In documenting VBA procedures automatically I showed how to create web pages that documented your VBA projects. I've updated that now ...
Read More
In Google Apps Script Color functions I introduced a bunch of functions to manipulate various color spaces from GAS. This was ...
Read More
Just how slow is Google Apps Script ?I'm a big fan of Google Apps Script, but I'm really fed up ...
Read More
As you know the language of Google Apps Script is javaScript. So you probably have a lot of useful code ...
Read More
A little while ago, I published an item on GAS performance, showing that a complex calculation test would take about ...
Read More
API for comparing colorsI continue to find the topic of comparing colors a fascinating one. As an experiment to see ...
Read More
Lately I've been doing a lot of posts to do with messing around with color. I'm using a selection of ...
Read More
Color scheme UII posted about a color scheme explorer app the other day. Given a specific color, it will find ...
Read More
I just saw a great post by Tony Hirst on his oUseful blog where he nicely laid out how to ...
Read More
Yesterday I showed how to do some data wrangling in VBA and Google Apps Script that Tony Hirst on his oUseful ...
Read More
Today's post pulls together a number of concepts I've been playing around with lately. As usual my source data and ...
Read More
The other day I was looking around for an example of how to do digest authentication in Google Apps Script ...
Read More
Today's post is a quick function for creating biased randoms from a list of items and weights. You might need ...
Read More
When we explore a web site, the usual view is that of a tree structure of pages. I wondered if ...
Read More
With Tableau, you can do loads of visualizations very simply and publish them on "tableau public". I never tried Tableau ...
Read More
When using services like Google Fusion API, sometimes you get errors because of over quota attempts - too many requests ...
Read More
In Flight Data from Fusion I introduced integration between Google Fusion and D3.js. This next version fixes up a few issues to ...
Read More
Here's the daily visits to the Excel Liberation site over the past couple of years. But what's that over the past ...
Read More
Being able to create Sankey Diagrams in D3 directly from Excel continues to be one of the most popular topics ...
Read More
I recently posted about a way to navigate sites and blogs by topic using a d3.js force diagram. Following that ...
Read More
A long time back now, I showed how to publish and prettify source code and scriptdb contents using Google Apps ...
Read More
I've been playing around with creating a promise based framework for VBA for a while now, mainly just to see ...
Read More
It turns out there is a kind of API - suggestqueries.google.com - that you can use to programatically get what Google ...
Read More
I've never been shy of writing up something I don't know much about, and today's post is no different. A ...
Read More
When the scriptable data validation feature in Google Apps Script came out recently, I started thinking about how we don't ...
Read More
In Google Apps Script lists and validation I showed how to use custom functions from Google Spreadsheets to perform common spreadsheet ...
Read More
In REST access to Google Apps Script list management functions we looked at accessing the Google Apps ScriptDB and some custom functions ...
Read More
If you are familiar with this blog and the Excel Liberation site, you'll know that there is a pretty significant ...
Read More
In Rest-Excel library, I have examples of a large number of REST APIs which get data from a wide range ...
Read More
Last week, I posted how to instrument Excel workbooks so that usage of them could be tracked using Google Analytics ...
Read More
Encryption/decryption library for Google Apps Script.Amit Agarwal recently showed how to encrypt/decrypt Email messages using a Google Apps Script application in ...
Read More
If you take data from outside Excel - especially using REST APIS, there's a good chance that you'll have to ...
Read More
I figured it would be pretty nice to be able use one of the cloud based noSQL databases directly from ...
Read More
If you are reading this there is a 90% probability that it's close to the beginning of 2014. I know ...
Read More
If you use blogger.com you may want to get some data about your posts into a spreadsheet for analysis. For ...
Read More
Doing cross domain requests for JSON data from client jQuery apps are hard work. In the past, you would have ...
Read More
In December, Google released new Sheets, saying they are faster and better than the old - including working offline. I've made ...
Read More
If you are a regular on this blog or on the Excel Liberation site you'll know that I'm a great fan ...
Read More
Last year, I started to experiment with Google Universal Analytics to measure usage of Excel Apps that people download from ...
Read More
I learned last week that I had been bestowed the honor of membership of the Google Developer Experts (GDE) program.It's ...
Read More
A few months ago, I posted something about instrumenting desktop apps with Google Universal Analytics to track usage, just like ...
Read More
I couldn't let a Eurovision weekend pass without doing some kind of visualization. I've always been fascinated by how the ...
Read More
As you will know by now, ScriptDB is now deprecated. A year or so ago, I published some articles on ...
Read More
In Analytics and GAS libraries I described how I had started to use Google Universal Analytics to track what usage was ...
Read More
There was a question on the Google Apps Script Community the other day. It went something like this.When a script ...
Read More
You are probably familiar with the Google Apps Script Lock Service, which is a way of preventing concurrent access to ...
Read More
2014 has been an eventful year for Google Apps Script with some great new capabilities arriving (add-ons), as well some ...
Read More
I posted the other day in A year in apps script and my bucket list my take on what happened in the ...
Read More
I've just completed my first Polymer app and have mixed feeling about the experience. Regulars to this blog and the ...
Read More
      Since we have a lot of operations going through the database abstraction libraries nowadays (over 3 million since ...
Read More
If you develop shared code for VBA, you've probably got some massive workbooks that contain multiple projects that you wish ...
Read More
I've been dong a lot of writing over on Desktop Liberation looking at techniques to run Apps Script/JavaScript code directly from ...
Read More
It's a common pattern in JavaScript to do this to assign a default value to a variable : var theThing ...
Read More
I've more or less stopped using blogger this year - looking back I've only made 6 posts since my end ...
Read More
Google Apps Script is the script language for Google Apps. If you are an Office user, think VBA, but in ...
Read More
So this just happened. BigQuery integration with Sheets!. This is great; now you can use a spreadsheet as a federated ...
Read More
The Apps Script Script service is deprecating the getProjectKey() method. At this time it's not clear when or why, but ...
Read More
I wasn't completely satisfied with the distribution method for the assets associated with my first Apps Script book and subsequent video ...
Read More
What is App Maker App Maker provides a 'low code' way to create professional looking G Suite custom apps without ...
Read More
2016 The real world of 2016 has been full of madness, badness and sadness. It's impossible to reflect on its ...
Read More
I've been using a Chromebook for a few years now, and find myself going for long stretches without needing to ...
Read More
Apps Script runs on Google Servers, probably the Rhino JavaScript engine running on Google App Engine. Rhino is written in ...
Read More
For some years now I've been writing this annual summary around Christmas time, on how my year in Apps Script ...
Read More
Welcome to WordPress. This is your first post. Edit or delete it, then start blogging! ...
Read More

Author: admin

Leave a Reply

Your email address will not be published. Required fields are marked *