Google Sheets – Page 13

Using the Viralheat Sentiment API and a Google Spreadsheet of conference tweets to find out how that keynote went down

September 28, 2011

Did you tune into into Donald Clark’s “Don’t Lecture Me!” keynote at ALT-C 2010 or were you at Joe Dale’s FOTE10 presentation? These presentations have two things in common, both Donald and Joe posted their reflections of a ‘hostile’ twitter backchannel (see Tweckled at ALT! and Facing the backchannel at FOTE10) and I provided a […]

14 Comments

The art of discovery: Looking at how UK Web Focus, OUseful.info and MASHe interconnect using Google Spreadsheets and NodeXL

September 7, 2011

Moving away from social networks I wanted to discover how Brian Kelly’s UK Web Focus, Tony Hirst’s OUseful.info and my MASHe are linked together. I chose Brian’s and Tony’s blogs for this because they have highlighted my work in the past so I know I’ll get some data. The main reason for this exercise was […]

One Comment

Using Google Spreadsheet/Apps Script and Google Social Graph to get Twitter edges for visualizing in NodeXL and Gephi

September 5, 2011

One of the things I really liked about the network analysis and visualisation tool NodeXL which I wrote about last week was the built-in tools for grabbing data from Twitter. I said: The advantage of NodeXL, particularly for graphing Twitter communities, is it has built-in features for grabbing the data for you. Not only that […]

3 Comments

And the most engaging OUseful.info post is…

August 18, 2011

This one Data Scraping Wikipedia with Google Spreadsheets … If you want to know how I arrived at this conclusion it’s mostly the same process as And the most engaging JISC Project is…, but as well as getting social bookmark/share counts I’m also counting the number of post comments (an important part of engagement). Here’s […]

And the most engaging JISC Project is…

August 15, 2011

[flickr]4814995807[/flickr] Recently I posted a Google Spreadsheet of all the live JISC funded project websites from the last 3 years. Not too long before that I also posted Google Spreadsheets as a lean mean social bookmark/share counting machine, which used Google Apps Script to query different social network providers for share/like counts for a specified […]

2 Comments

Open data equals open scrutiny but doesn’t always equal all of the answer

August 10, 2011

[flickr]64284665[/flickr] Last week I got frustrated at not being able to find some JISC funded project outputs, which was a little annoying. This led to a small exploration around JISC’s Programme Information Management System (PIMS). The system was originally only available to JISC executive staff but made available to all sometime last year and used […]

4 Comments

Exporting more friends or followers from Twitter to a Google Spreadsheet

August 2, 2011

Back in March 2011 I published Export Twitter Followers and Friends using a Google Spreadsheet. One of the problems with this solution is if you were trying to import a lot of friends or followers users would get the error message “Exceeded absolute-time timeout in milliseconds”. This is because there is a limitation to the […]

21 Comments

Social media wars: Measuring the battle lines

July 13, 2011

As previously posted I was at the UKOLN Metrics and Social Web Services: Quantitative Evidence for their Use and Impact event on Monday. Before attending this event I thought I had a reasonably understanding of social media metrics but I left realising there was a lot I didn’t know, but with new ideas to help […]

3 Comments

Introduction to Google Apps Script with: Split my form entries to individual sheets by username

July 6, 2011

Just as Vincent van Gogh knocked out a few sunflower painting in his time my current muse is Google Apps Script. At the danger of boring you with yet more sunflowers here’s a recording of a webinar session I did with Dave Foord at A6 Training and Patrick Lander from Loughborough College. This session came […]

One Comment