desktop liberation
Follow
Find
17.4K views | +0 today
desktop liberation
Your new post is loading...
Your new post is loading...
Scooped by brucemcpherson
Scoop.it!

Free Geo IP API: Excel and Google Apps Script. The Daily REST library entry

Free Geo IP API: Excel and Google Apps Script. The Daily REST library entry | desktop liberation | Scoop.it

Geo code from ip and host names

Today's API is a straightforward query per row, meaning that data is retrieved from the API using the contents of a column as the query. In this case the host column provides the query data. The freegeoip API will take a host name and ip address and provide geolocation data for it. Here's how to do it in bulk directly from Excel or Google Apps Script.

 

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Which VBA references you are using - Excel Liberation

Which VBA references you are using - Excel Liberation | desktop liberation | Scoop.it
VBA references

Quite often you need to add some reference to be able to get some code to compile. This is because the code is referencing some external object that the Excel VBA does not know about. Normally you would add these references through a dialogue, but here is how to find out programatically

more...
Mohsen Qaysi's curator insight, May 29, 2013 11:55 AM

Great place to find source code in ....

Scooped by brucemcpherson
Scoop.it!

How to update modules automatically in VBA - Excel Liberation

How to update modules automatically in VBA - Excel Liberation | desktop liberation | Scoop.it

Here's a way to share and automatically update public VBA code using Gist and github. Modules and classes required for a capability are described in a manifest. Required VBA code is inserted in your project from github repositories, and is updated on demand to latest versions.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

UK postcode geocoding API: The Daily REST library entry for Excel and GAScript

UK postcode geocoding API: The Daily REST library entry for Excel and GAScript | desktop liberation | Scoop.it

Geocode and get administrative details and geoHash link from a UK postcode directly into an Excel or Google Spreadsheet
Following on from the Yahoo GeoCode entry here's another geoCoder - this time using UK post code as input, and providing various UK specific administrative district information. As usual it is implemented as a rest-library member. This a data query API, populating columns in a row in a spreadsheet based on a variable column in the data. You just name the columns to match any data you want to retrieve and go. Here's an example geocoding various random postcodes

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

How to Embed gist code samples in Blogger

How to Embed gist code samples in Blogger | desktop liberation | Scoop.it

On this blog, and on the ramblings site there is a growing number of code samples, but of course as things evolve, they get out of date. I started to write something to embed Gist samples in Blogger, but I came across a great post from Moski Doski, who had already solved the problem. Take a look at his post for how to do it. It's just a couple of steps

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

if this then that... for vampires

if this then that... for vampires | desktop liberation | Scoop.it

I came across ifttt.com (if THIS then THAT) the other day. Essentially it's a simple way creating a trigger based on some event such as tweet mentioning you, or a facebook upload (THIS) and so on which will then cause some action to be taken (send an sms, tweet something etc.) (THAT)

It is ridiculously simple to use. You go through a dialogue selecting the THIS and the THAT from a selection of Icons and it happens.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

url shortening API: The Daily REST library entry for Excel and GAScript

url shortening API: The Daily REST library entry for Excel and GAScript | desktop liberation | Scoop.it

Today's API is from "ttb.li" which is a url shortening service. This is a query by row API, populating columns in a spreadsheet row using a value in a given column. Here's an example - you supply a list of long urls. It will give you back shortened versions.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Yahoo Geocoding API: The Daily REST library entry for Excel and GAScript

Yahoo Geocoding API: The Daily REST library entry for Excel and GAScript | desktop liberation | Scoop.it

Geocode with Yahoo API directly into an Excel or Google Spreadsheet

 

Strictly speaking today's API doesn't really qualify as 'API of the day', since I've written about this before comparing a few geoCoding APIs. I've been using Google for geocoding , but recently I am seeing a lot more quota refusals now when not using a developer key, so I'd thought I may as well resurrect Yahoo implemented as a rest-library member.

 

This a data query API, populating columns in a row in a spreadsheet based on a variable column in the data. As usual, you just name the columns to match any data you want to retrieve and go. Here's an example geocoding some of the queen's family's homes.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

CrunchBase 'who works where' API: The Daily REST library entry for Excel and GAScript

CrunchBase 'who works where' API: The Daily REST library entry for Excel and GAScript | desktop liberation | Scoop.it

Today's API is another query type from "crunchbase" which is a free database of corporations, people and investors. Yesterday I showed you how to get data about people. Today I'm showing how to get a list of people who work for a given company - this a single query API, populating multiple rows in a spreadsheet from a given name. This is executed in a single line of code in either VBA or Google apps script.  The example shows a few lines of the response to a query on "google"

 

For more like this visit ramblings.mcpher.com

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Excel Liberation. http://ramblings.mcpher.com: CrunchBase relationships API: The Daily REST library entry for Excel and GAScript

Excel Liberation. http://ramblings.mcpher.com: CrunchBase relationships API: The Daily REST library entry for Excel and GAScript | desktop liberation | Scoop.it

Data from CrunchBase API directly into an Excel or Google Spreadsheet.

 

Today's API is from "crunchbase" which is a free database of corporations, people and investors. There are a number of types of query available in this API - our first one will be about relationships - companies that business leaders have worked for - this a single query API, populating multiple rows in a spreadsheet from a given name. Here's the response to a query on "jeff-bezos"

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

duckduckgo disambiguation API: The Daily REST library entry for Excel and GAScript

duckduckgo disambiguation API: The Daily REST library entry for Excel and GAScript | desktop liberation | Scoop.it

In various posts such as this one, I've covered new entries to the REST library but it's been kind of haphazard. Since I'm adding these regularly I figured I'd make a quick post like this for every new one.

Today's API is "duckduckgo disambiguation" - a straightforward single query API

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Thematic maps and other shape coloring in one line of code

Thematic maps and other shape coloring in one line of code | desktop liberation | Scoop.it

Going back to the theme of 'doing complicated things in one line of code', here's a mash up of cDataSet, Color Ramps, Mapping and various other things.

Lets say we want to create a thematic map in Excel from a simple set of data, in this example, the population of each country in the world, and apply a heatmap coloring. Here's how.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Persistence of data for userforms - Excel Liberation

Persistence of data for userforms - Excel Liberation | desktop liberation | Scoop.it

Here's a way to make data persist between UserForm uses in Excel so you can have meaningful default values.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

How to add references by guid - Excel Liberation

In Which VBA references you are using we looked at how to get details about references active in a project. Let's look at how to add those references to a project using code. This approach is needed in How to update modules automatically in VBA since references are dependencies that can be automatically updated in the same way as code.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

rxNorm Drug API: The Daily REST library entry for Excel and GAScript

rxNorm Drug API: The Daily REST library entry for Excel and GAScript | desktop liberation | Scoop.it

Aside from being a little specialized, today's API is another quite unusual one. Normally apis allow you select the format of the output through a URI parameter, but the rxNorm pharma database needs you specify it in the GET headers of your request. More about that later. This a single query API, populating multiple rows in a spreadsheet based on a query you provide. You just name the columns to match any data you want to retrieve and go. Here's the results of query on the drug Amoxil.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Excel Liberation. http://ramblings.mcpher.com: Neil deGrasse Tyson quotes API: The Daily REST library entry for Excel and GAScript

Excel Liberation. http://ramblings.mcpher.com: Neil deGrasse Tyson quotes API: The Daily REST library entry for Excel and GAScript | desktop liberation | Scoop.it

There's probably no practical use to today's API of the day, except that I am always amused by what he has to say. The other thing I wanted to look at was a slightly more complex usage of the restQuery capability, but at the same time to talk a little more about how this exposed interface could benefit from using jSon arguments rather than the traditional list imposed on us by VBA syntax.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

1 in 5 APIs Say “Bye XML”

1 in 5 APIs Say “Bye XML” | desktop liberation | Scoop.it

You can see from the article that more and more APIs are not even bothering with XML versions. See ramblings.mcpher.com for comprehensive jSon/VBA integration to meet the need for more jSon everywhere - but in Excel

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Excel Liberation. http://ramblings.mcpher.com: R melt for Google Apps Script and Excel/VBA: reshaping/unpivoting data

Excel Liberation. http://ramblings.mcpher.com: R melt for Google Apps Script and Excel/VBA: reshaping/unpivoting data | desktop liberation | Scoop.it

You could consider this to be a kind of unpivot - exploding tabulated data back into transactional rows as described by Hadley Wickhams in his implementation of reshape/melt for R. Here is both an Excel/VBA and a Google App script version.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

jSon parsing: single and double quotes and messing around with Google Apps Script and VBA

Dealing with double and single quotes in javaScript and jSon.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Simple implementation of R- melt in VBA and GAS - Excel Liberation

Simple implementation of R- melt  in VBA and GAS - Excel Liberation | desktop liberation | Scoop.it

Hadley Wickham has added some data management capabilities to R which are pretty useful for getting data ready for tabulation or visualization. One of these is melt(). Melt can do lots of things, but one that caught my eye in particular was the ability to turn a tabular data representation in to a transactional one - a kind of unpivot.

 

thanks to Tony Hirst http://blog.ouseful.info/2012/08/08/olympic-medals-visualising-ots-using-an-r-treemap/ for the idea.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Passing complex arguments with default values in VBA - like jQuery $.extend()

Passing complex arguments with default values in VBA - like jQuery $.extend() | desktop liberation | Scoop.it

In passing arguments in VBA using jSON I covered how you could use javaScript Object syntax to pass complex arguments to VBA procedures. Today I'll cover how to pass complex arguments where there are optional values.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

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

FAA airport status API: The Daily REST library entry for Excel and GAScript | desktop liberation | Scoop.it

Today's API is "FAA airport status" - a dataSet query API, populating rows in a spreadsheet using the Airport IATA code as a key

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Timely Portfolio: Hi R and Axys, I’m d3.js “Nice to Meet You” (On the Iphone)

Timely Portfolio: Hi R and Axys, I’m d3.js “Nice to Meet You” (On the Iphone) | desktop liberation | Scoop.it

Nice start on a mashup of R, D3.js , Axys and Excel from Kenton Russell

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

O2 starts building free London WiFi network

O2 starts building free London WiFi network | desktop liberation | Scoop.it
Mobile network O2 has announced a plan to install free WiFi access across the London boroughs of Kensington, Chelsea and Westminster in time for the Olympics in July.
more...
No comment yet.