Skip to main content

Posts

Showing posts from November 17, 2010

Importing twitter feed in google spreadsheet

Often I wanted to store my twitter feed or any other online feed into my google spreadsheets. Here is how to do it.

USING GOOGLE DOCS SPREADSHEET Create a new blank spreadsheet. In the column A2 enter  
=ImportFeed(“http://twitter.com/statuses/user_timeline/princemishra1.rss”,”items title”,false,20). 
Replace "princemishra1" with your twitter username. 20 is the maximum number of updates you can see at any one time. The updates are cached by the google server, so you may see some delays. You can view the spreadsheet I created at https://spreadsheets1.google.com/ccc?key=td3mefj69f71XSlbRiREuhA&hl=en#gid=0

USING EXCEL
Create a blank spreadsheet. Select Data -> From Web
This should open the New Web Query Window. In the address field enter
http://twitter.com/statuses/user_timeline/princemishra1.rss (Replace princemishra1 with your twitter username) and press Go. Excel will now fetch all your twitter updates. After the fetching has finished click on Import.
Now, you shoul…

A* Algorithm notes

The A* (pronounced A-star) algorithm can be complicated for beginners. While there are many articles on the web that explain A*, most are written for people who understand the basics already. This article is for the true beginner.
This article does not try to be the definitive work on the subject. Instead it describes the fundamentals and prepares you to go out and read all of those other materials and understand what they are talking about. Links to some of the best are provided at the end of this article, under Further Reading.
Finally, this article is not program-specific. You should be able to adapt what's here to any computer language. As you might expect, however, I have included a link to a sample program at the end of this article. The sample package contains two versions: one in C++ and one in Blitz Basic. It also contains executables if you just want to see A* in action. 
But we are getting ahead of ourselves. Let's start at the beginning ...
Introduction: The Search Are…