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 probably shouldn't follow me on Twitter here. I recommend the RSS feed instead.

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

Video of 14 year old Jimmy Page in 1957: I watched “It Might Get Loud” last night and part of it featured this 53 year old video clip. Don’t miss the interview a couple minutes in where Jimmy says he wants to do biological research when he grows up. As for the movie, it was pretty good, if you’re a fan of the three guitarists. I personally didn’t think The Edge added much, but I’m not a huge U2 fan either. Jack White and Page, however, were great.

How to Swear in English, if You’re Korean: “Little children and pregnant women should not watch, because it will be bad for their education.” Gets funnier every time I watch it.

Saturday Night Live: China Cold Open — I don’t watch SNL much anymore but this week’s (repeat) opening skit on U.S./China relations was hilarious. I love the translator.

TrentWalton.com:

Trent’s site is really nice. The single-blog-post index is an interesting touch. Make sure to click “Prev” to peruse some of Trent’s other posts.

How to make a Lost Cat poster if you’re a graphic designer and you don’t like doing free work for people. (via jimray)

“Apple of My Eye”: A short movie, filmed and edited entirely on an iPhone. Beautiful stuff. (via gruber)

PilotHandwriting:

Write some letters on a piece of paper, upload it via webcam, and this site will turn it into a font. Very slick. If I didn’t have deplorable handwriting, I would try it. (via Cameron)

How the Big 12 came back to life:

This is one of the best investigative sports articles I’ve ever read. Really, really fascinating. If you care at all about college football, you must read it. Two really interesting things I learned: Colorado really screwed themselves, and ESPN pretty much screwed the Pac-10.

We just launched msnbc.com’s new photoblog today. It’s pretty hot and it’s not even full featured yet. Peep it.

iPhone App Development: The Missing Manual:

If I ever decide to write an iPhone app, this will be the first book I buy. (via gruber)

The Battery Flashlight: Pretty cool. I can’t think of another example of a product where the battery is actually part of the user interface.

“What is the level of technology that is required to make a foam stick?” — Wham-O Moves to America (The Daily Show)

How Much Do Music Artists Earn Online? A great infographic showing how the digital distribution of music has sucked artists’ royalties almost completely dry. People have argued they were never healthy to begin with, but the difference here is major. The same is going to happen to every meatspace product that transitions to digital. The iPad isn’t going to save content royalties.

Dude with ridiculous business-card throwing skills. It’s good to know business cards still have a use. (via tan.gy)

If ever anyone had a look that screamed “potential air guitar champion”, it is Rob Weychert. Watch him tear it up in the 2010 Air Guitar World Championships. I am proud to say this man has slept on my couch.