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 a phrase. The are using a technique called Support Vector machines. You can read […]
What’s trending on twitter to Excel In a previous entry, I described how to add new entries to the rest-Excel library. Here’s another new library entry. WhatTheTrend provide an API for twitter watching. You can use this […]
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 […]
Managing stock portfolio in Excel In a previous entry, I described how to add new entries to the rest-Excel library. Up till now we’ve just looked at populating static data in a worksheet with data […]
Sorting chapter/bullets numbers Quite often you need to sort data that has some kind of chapter numbering, such as 1.1 1.1.2 2.1.1 2.12.2 A specialized form of this would be ipnumbers, for example 192.1.3.2 172.12.180.1 […]
Following the post earlier on rest-jSon-Excel in one line of code , I found that you can do the research and add a new library entry in about 10 minutes. Here is a query to populate […]
Rest – jSon – Excel in one line of code My recent post on how to Excel-jSon-Excel in one line of code, seems to have generated a lot of pageviews, so clearly there are a lot […]
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 […]
What are generated VizMap applications These are mapping applications integrating Google Maps, Google Earth, Google Visualizations and Twitter. Here is an example screenshot. They are data driven in the sense that the applications are generated […]
Twitter, Google Visualizations, Google Maps, Google Earth, Excel – all together. In various posts such as Flying around with Google Earth and The Royal Family and their homes as well as on the ramblings site I showed how to […]
Excel-jSon-Excel in one line of code On the ramblings site, I set myself the challenge to write some classes that could be invoked to convert an entire Worksheet to jSon, or alternatively, to consume a […]
Ramblings web site has a new look Just spent a little bit of time on Google Sites cleaning up the ramblings web site. I think navigation should be a little cleaner.
In last weeks blog entry, I showed how to generate a Google Earth or Google Maps based application out of Excel. These applications now have the capability to fly around each marked entry in Google […]
Another VizMap generated appplication – the British Royal Family and their homes In the Excel ramblings site, I cover how to generate Google Earth and Google Maps Application straight out of Excel, without needing to […]
Changing the markers on Google Earth to something in your data Yesterday I introduced the capability to generate google maps and google earth applications straight from Excel. Linkin Park Marker on Red Square from Google […]
Google Visualizations on Google Map infoWindows and Google Earth Balloons A few weeks ago I wrote about generating data driven mapping applications straight out of Excel, with no javaScript required (by you anyway). It has […]
Creating Data Driven Mapping applications In a previous post I looked at the the various mapping packages and how they compared. Having concluded that Google Maps was the winner, I started to work on an […]
Geocoding Excel While looking at how to connect Excel to Google Maps, I implemented a capability in vba for each of the main Apis for geoCoding capability through a simple http: request. You can read […]
Excel and Google Maps. Following my previous posts comparing the geoCoding capabilities of Yahoo, Bing and Google Maps I have now implemented Adding markers to google Maps straight from an Excel Table. As usual this is […]
I have already looked at geocoding with Bing Maps -vs- Google Maps and Google Maps is a clear winner. Yahoo Placemaker is pretty good at first glance even though it claims not to be a […]
In a previous post I covered how you could use the Google Maps Api to complete and parse addresses for subsequent mapping directly from Excel. In the name of fairness, I implemented the same thing […]
There is a simple API to retrieve google books data. There was an interesting question on our forum yesterday asking about how to quickly populate a spreadsheet with book data based on the ISBN number […]
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 […]
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 […]
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 […]
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 […]
Sometimes you have a range of dates and you need to come up with a scale that makes sense for the dates you are trying to represent in a timeline. For example if your dates […]
In various posts I have covered ways to get data in and out of Excel and other PC based systems. The latest capability I have looked at is being able to get data live into […]
Yesterday I posted an update to the data abstraction classes for Excel. I realized that there is also a method to convert that data into a JSON string. The following code would convert a worksheet […]
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. […]
Diminishing returns for more effort You will be very familiar with the law of diminishing returns, where you get a lot of payback for your initial efforts (sometimes called ‘low hanging fruit’), then you have […]
I came across a problem today, where I wanted to create a Google Intensity Map based on a selection of people in my Outlook Global Address List. I thought it would be kind of easy, […]
Analytics with no Javascript anyone? My last post covered how to inject Google Analytics into pages where it was not really possible to introduce javascript. by using a gadget. But what about the case where […]
A generic analytics gadget. Following on from my last post on adding Google Analytics Codes to track usage of your gadget, it occurred to me that you could create a gadget whose sole purpose in […]
What you need It took me a while to find out how to do this, but it’s really simple.Implementing this means that you can track usage of your gadget, whether embedded in a web page, […]
Google Groups Since I get a lot of correspondence from people who have downloaded stuff, I thought it might be useful to create a group with this tagline. ‘This group is for those with Excel or […]
Using google code to host projects I moved the gadget and associated code to googlecode.com hoping to host it there. If you have never done this, it is somewhat complex. It can be found here. […]
Roadmapper update I finally got round to implementing the roadmapper as a google visualization gadget. All the source code and gadget package is available here along with the write up, so I wont repeat it […]
Google Gadgets This is the standard way to do charts in Google Docs, as well as being easily embedabble in web pages. In a previous post I started thinking about the migration path 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 […]
I’ve been looking at how to use cookies to pass data between excel sessions and of course outside Excel. Having implemented a method of hiding data inside cells and Excel shapes, I figured this would […]
Roadmap Project Recap Some time ago I started to play around with a method to make Roadmaps from Excel data. Since working through the development of it on my Excel Ramblings site and in this article […]
Can we use cookies inside Excel This is a follow on from my thoughts around using JSON both to store data inside Excel shapes and cells, and also to pick up data from external sources. […]
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. […]
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 […]
bruce mcpherson is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. Based on a work at http://www.mcpher.com. Permissions beyond the scope of this license may be available at code use guidelines