Smart Disorganized

Tag: spreadsheets

  • Spreadsheets are 30!

  • Worth reading “Where’s your data?“ Remember, your Mind Traffic Control data is easily exportable. Just go to : http://mindtrafficcontrol.appspot.com/exports (Via the “Export Data” menu item) and choose whether you want your data exported in CSV format (which you can import into Excel or EditGrid etc.) or OPML (which can be read in the OPML Editor…

  • A couple of great videos via Zbigniew Avi Bryant’s powerful spreadsheet editor that remembers changes that you make by hand and can apply them in bulk to the rest of the lines in your spreadsheet. Note that Avi’s a Smalltalk guy, and a more primitive version of this (repeat last replace) has been in the…

  • A Platform Wars post on spreadsheets.

  • Jocelyn Paine is one of the more interesting thinkers about evolving spreadsheets. Here’s some recent stuff about components in Google Sheet.

  • More playing with online spreadsheets. Here’s a cute example. This is an EditGrid spreadsheet that pulls book data from Amazon (including price in dollars), currency data from Yahoo, and then calculates the price in pounds of the books. It’s a “calculator” meaning that I’ve set up only one field to be editable (the search term…

  • Wow! Manuel Simoni is on fire! with BuckyBase development : – Import into Google Spreadsheet – Google Gadgets Visualization – RDF triples (ah well … if it makes him happy) – and is this a TreeGrid??? This is seriously exciting.

  • What is Flying Logic?

  • Google’s whole Gadget thing is becoming increasingly impressive. Look at the dynamic widgets which can hook up to and pull data out of online spreadsheets. You can also embed Gadgets in online spreadsheets etc. Making your Gadget collaborative is pretty straightforward too.

  • A while ago on Platform Wars I wrote : 99% of the world’s “semi-structured” data is not in Microformats but in tables in spreadsheets. Wildly inaccurate estimate I’m sure. But I’ll bet it dwarfs XML formats including RSS. So where’s the Yahoo Pipes for CSV and spreadsheet data? The mashing, pivot-tabling, cartesian joining of live…