EditGrid: Really Useful Web-Based Spreadsheets

Parse error: syntax error, unexpected T_STRING in /home/auxblood/mikeindustries.com/wp/wp-content/plugins/exec-php/includes/runtime.php(42) : eval()’d code on line 22

Like this entry? You can follow me on Twitter here, subscribe via email here, or get the RSS feed if that's how you roll.

9 Responses:

  1. alvin says:

    but… but… having used both, Google is actually much simpler (3 clicks and your data is out there) and offer more data output option. And since you are using curl you can just do exactly the same thing :)

    here’s a screenshot of the UI http://alvinwoon.com/dev/screenshot/2008-09-09_0917.png

    and here’s a public data of my movie listing – http://spreadsheets.google.com/pub?key=p-CI3CQthxMupDZqHm3gCFQ&output=txt (I use tab delimited instead of xml but you can use any type of output that suits you :) )

  2. Mike D. says:

    alvin: Thanks for the tip. I’m sure Google’s implementation is plenty easy… it just didn’t look like it from the API. As for outputting to HTML, XML, and other formats with one click, EditGrid does that too I believe, but the trick for me was not so much outputting the entire spreadsheet, but outputting it in a format such that I could just use particular rows of it depending on what was in the blog entry. Nice, clean, semantic XML seemed like the best way to do this, although comma or tab delimited would of course work as well.

  3. Mike D. says:

    Actually, I misspoke. EditGrid outputs to those formats with zero clicks. You just add the appropriate extension:

    http://www.editgrid.com/user/mikeindustries/House_Expenses.html

    http://www.editgrid.com/user/mikeindustries/House_Expenses.xml

    http://www.editgrid.com/user/mikeindustries/House_Expenses.pdf

    etc etc etc

  4. This is fantastic! Thanks for the heads up on this one.

  5. Jason says:

    Is there a story behind the “cost” and “actual outflow” amounts for “survey”? :)

  6. Mike D. says:

    Jason: Yeah, the “actual outflow” column is not actually related to specific line items but rather the “amount of cash which has left my wallet as of the date of the blog entry”. So for instance, where it starts to diverge is the architecture fee. I’m signed up for $49k or so but all I’ve paid so far is my first payment of $9600.

  7. Jeff says:

    Good stuff – thanks for the tutorial

  8. Thank you so much – I am going to use this in my business development by getting everyone in our company to use it for my benefit.
    Thanks for the tutorial – although my girlfriend won’t as I’ll be playing around with Editgrid all weekend!

  9. Britta says:

    Thank you, very useful informations for me to manage my editgrid data.

Leave a Reply:

Shared
Solitude and Leadership:

Multitasking, in short, is not only not thinking, it impairs your ability to think.Thinking means concentrating on one thing long enough to develop an idea about it. Not learning other people’s ideas, or memorizing a body of information…

Takes a little while to get going, but overall a great article about the virtues of seeking solitude from distractions in order to develop your own original thoughts.

“I think you’ve got a pretty good imagination, despicability-wise!”

“Look Around You - Computer Games”

Can’t believe I hadn’t heard of this BBC series before. Brilliant. Make sure to watch them all. (via daringfireball)

10 New Year’s resolutions for designers:

Do you think Chelsea Clinton asks herself if her mom would understand something complex? No. Because her mom is a badass.

How Doctors Die:

If there is a state of the art of end-of-life care, it is this: death with dignity.

This is the most concise, easily understood article on the perils of end-of-like care in the United States I’ve ever read. It is a must-read, and frankly, a must-heed, in my opinion. (via kottke)

Lost Type Co-op | Browse Fonts:

A nice collection of pay-what-you-will typefaces from Tyler Galpin and Riley Cran.
How to interview a designer with the perfect design exercise:

These sorts of tests are common for engineering hires, but it’s nice to see an example of a good design-oriented one.

Jessica Hische's Lovely Blog:

Embarrassed I had never seen this until today. Lovely work all around. (via drawar)

This recently unearthed video of Steve Jobs at work during the early days of NeXT is a remarkable look inside how he ran meetings, how he created culture at his startups, and how others — like Joanna Hoffman around the 11 minute mark — called B.S. on his reality distortion field. It’s also remarkable in that it reveals Jobs to be a man who picks carrots in pressed work shirts.

The Republican Clown College by WMxdesign. These are so great. Make sure to check out the whole set.

BuiltWith: Web Technology Usage Statistics:

Sometimes when you are deciding on technologies to use on a new site (e.g. jQuery vs. YUI or MS SQL vs. MySQL) it’s instructive to examine what everyone else is doing. BuiltWith has an incredible amount of trending data to help you out in that regard. Very, very cool.

A Brief Rant on the Future of Interaction Design:

Lots of good thinking here. No solutions, but a nice reminder that two-dimensional touch interfaces are transitional, not permanent.

Stephen Colbert loses it on-air. Rivals another one of my all-time favorite Colbert on air crack-ups.