No Picture
Visualization

How to use the Excel Roadmapper

Excel Roadmapper from simple table data Some time ago, I showed how to develop a VBA roadmapper on the ramblings website. I’ve noticed that most of my visitors to that topic simply download the finished workbook […]

No Picture
REST API

rest library for Excel

Eliminating repetitive coding of Excel web service integration I find myself writing more and more web service to Excel integrations. Here are just a few examples of webservice-Excel integrations from the excel ramblings site. I […]

No Picture
VBA

How to use cDataSet

Excel Data Manipulation Classes I notice from Google Analytics the the cDataSet pages are by far the most popular on the site. These classes are used throughout all the projects on the site, and are […]

No Picture
Integrating Excel with Maps and Earth

Getting data from Google Maps to Excel

Mapping visualization layers from Excel The Google Maps API is a wonderful thing, allowing you to convert an unstructured and incomplete address and get back a whole bunch of structured and mapping data. Google is […]

No Picture
No category

Getting Started Series

Looking at Google Analytics Data for my site, I notice that there are 2 distinct populations. Those that look and read through a project article (5-10 minutes) and those that stay a few seconds on […]

No Picture
Json

Dynamic forms and jSon

Following previous developments on hiding data in excel objects, Excel jSon conversion and dynamic forms I figured it was time to combine all these threads, and have implemented all that as an integrated solution as […]

No Picture
Microsoft Office & VBA

Abstracting Excel Data

Classes for Excel Data Abstraction In a number of articles and topics on my website i have referred to a collection of classes that I generally use to abstract Excel physical location from the data contents. […]

No Picture
From VBA to Google Apps Script

Migrating to Google Docs

Ive been using Google Docs as well as Excel for a while now, and certainly Excel is more comfortable a user experience. However it’s clear that Google Docs offer a great opportunity to offer services […]

No Picture
Json

JSON deserializer

Completing the JSON deserializer/serializer I was missing being able to deal with arrays and could only deal with strings in the first version of this, but have finally figured out how to deal with this. […]

No Picture
No category

Topics under consideration

What next Thinking about what to work on next for the Excel Ramblings site, I wondered how I could pull together the work on JSON along with google visualization serialization to open up access to […]