Lego Value Spreadsheet (direct link to MS excel file)
August 15, 2009 10:30 AM   Subscribe

Lego Value Spreadsheet (direct link to MS excel file)
All the more-than-400-piece sets for sale on the Lego website, with each set's price and number of bricks. If you, like me, simply crave a whole LOT of bricks to assemble, this Excel spreadsheet will tell you which sets are the best value for your money. If you want to figure out the value for any sub-400-piece sets, just plug 'em into the spreadsheet. Here's a screenshot. I woulda made this if I had Excel as a child, but hey, never too late to feed one's obsession with legos. (Coupla notes: Any unlabeled but general-purpose sets on the site, I grouped as "Creator". There's also an openoffice version. Watch out for the less-compatible Bionicle sets when you're spending all your LEGO DREAM MONEY, you little lego Rockefeller, you.)
posted by Greg Nog (7 comments total) 3 users marked this as a favorite

This is awesome, if only as an illustration of why it's so awesome to be an adult. You can do WHATEVER YOU WANT! You can spend all weekend BUILDING THINGS FROM LEGOS or MAKING COOKIES! And no one will tell you to go to bed at 8pm!

Excuse me, I'm going to go eat gummi worms until I can't eat any more, now.
posted by ocherdraco at 12:09 PM on August 15, 2009 [2 favorites]

Excellent! I definitely agree on the Bionicle issue. Also the Mindstorms sets came out at the bottom, but I think they may have more value, especially if you are interested in hacking your LEGOs. Also, if you haven't seen it yet: Peeron.
posted by douglaswth at 12:41 AM on August 16, 2009 [1 favorite]


Thanks, douglaswth!
posted by Greg Nog at 9:22 AM on August 17, 2009

Very keen, though it looks like Peeron has both elements of this (sort sets by pieces and price), though they might not be as up-to-date as your list, and it's not directly filtered by sets in production currently.

Personally, I'm fond of buying bulk bins online from people whose kids have "out grown" Legos. More of a game of chance, but a lower cost over-all.
posted by filthy light thief at 1:32 PM on August 17, 2009 [1 favorite]

What you really need in your spreadsheet is a value calculation based on the total volume of the pieces in each set.

I therefore demand that you buy all available sets and submerge them in a giant graduated cylinder.

You can dry them with a tea towel and return them afterwards, of course.
posted by le morte de bea arthur at 6:04 AM on August 18, 2009

This is probably a dumb question, but why not use google spreadsheets? Easier to share online that way.
posted by empath at 4:28 PM on August 28, 2009

I didn't know google had spreadsheets!
posted by Greg Nog at 8:53 AM on August 31, 2009

« Older Operation Find Don...   |   Is There Life After New York?... Newer »

You are not currently logged in. Log in or create a new account to post comments.