FBTBForums.net

[Hair Jedi]

Once again, Andi has gone above and beyond the call of duty in regards to her continuing the upkeep of the spreadsheet.

What Andi has done is added the SET images to their respective listing, just as I did with the minfig images on the minifig sheet. It's something to see for sure!

You can get this new version here:
http://www.dmkicks.com/StarWarsLegoCompletewithSETPictures.xls
Current file size: 1808KB

The most current version of the original sheet is still abailable at:
http://www.dmkicks.com/StarWarsLegoComplete.xls
Current file size: 854KB

Note: You need Microsoft Excel in order to open/use these files.

And the instructions, for those who need them:
http://www.dmkicks.com/StarWarsLegoInstructions.doc
Current file size: 119KB

Note: You need Microsoft Word (or a word processing program that will accept the .doc extension) in order to open/use this file.

All sets and minifigs are up to date as of 3/17/07

All thanks and praise to Andi for doing me this favor while I try to make order of the mess I've made of my life. Either myself or Andi will keep everyone up to date on the spreadhseet's progress.

Once again, I thank all of you who've used my little creation, and I especially thank those of you who have sent me PMs on my marital woes, your kind words and shows of support have helped me more than you could know.

Cheers,
Michael - Hair Jedi
_________________
Dyslexics of the world.... UNTIE!
Vote for Whiplash: www.rockerie.com/eriemusicawards
Check out my bands' site: www.myspace.com/whiplashbandpa

[markz]

Thank you so much for your hard work!

I am new to this board and to collecting Star Wars Legos. These two spreadsheets will help me stay organized from the very beginning!

Mark

[Hair Jedi]

My pleasure
_________________
Dyslexics of the world.... UNTIE!
Vote for Whiplash: www.rockerie.com/eriemusicawards
Check out my bands' site: www.myspace.com/whiplashbandpa

[mike block]

A pure bitmap of the new model is avail at:

http://www.brickset.com/search.aspx?Set=10144-1

cheers

[Jargon]

These are very cool as well as very useful. Thank you!
Have you considered adding the minifigs from the LEGO SW Pens?
- JS

[Hair Jedi]

[Grolim]

Nice work Hair Jedi. For someone who is new to collecting SW Lego like me this is very useful. Much better than the ad hoc spreadsheet I'd created myself. Have added a column to record how much I've actually paid for each set so I can compare how much extra I've had to spend due to being late in the game

[alfredjr]

Hey this is neat. I have been keeping a spreadsheet since the beginning, mostly to track what I still need to buy!

I like the minifig sheet for having all the minifigs, but here's a suggestion:
Link it to the other sheet, and have it automatically generate the fig numbers. You can get the fig numbers from Bricklink if you need 'em:
e.g. http://www.bricklink.com/catalogItemInv.asp?S=7140-1

Just a suggestion!

-Alfred

P.S. Here are my stats:
Total Sets 253
Total Pieces 49,533
Total Prices $5,654.45
Avg Per Piece $0.11

From my sheet:
My price $3,853.47
My ave pc price $0.08

[General C]

Thank you for your time and work into this. Very handy and helped me realize how much SWL I have. I just need to make sure my wife doesn't see this sheet because she might just tell me that I have enough.

But... you can never have too many

[HoodedKubaz]

ty
_________________
I deduct your pay!
pm me to join the GDIS
(Gonk Droid Independence System)

[Zombie Fetty]

Could somebody explain how to use it? I don't ghet it.
_________________

Things are getting strange, I'm starting to worry,
This could be a case for Mulder and Scully

[Hair Jedi]

[sid]

The Obi-Wan keychain is missing, the part number on mine is 4270895. And more importantly thanks for all the work on this.

[Hair Jedi]

[Zombie Fetty]

Thanks.
All my Excel training went out the window just before.
_________________

Things are getting strange, I'm starting to worry,
This could be a case for Mulder and Scully

[sid]

Also just noticed it doesn't have the two magnet sets.
Yoda Set-4269244 (9.95)
Chewbacca Set-4269242 (9.95)

Wish I had noticed that before.

[Hair Jedi]

[Zombie Fetty]

Is there any way how you can get the pictures in the right place after copying?
_________________

Things are getting strange, I'm starting to worry,
This could be a case for Mulder and Scully

[Hair Jedi]

[Zombie Fetty]

Strange, the cells are too small for the pictures on mine.
_________________

Things are getting strange, I'm starting to worry,
This could be a case for Mulder and Scully

[Hair Jedi]

[jedi-chaz]

Thanks for the list it's great!!

[Hair Jedi]

[Zombie Fetty]

[Darth's Zombie]

Hey this is a great spreadsheet! Thanks for taking the time to put this out!
As an old excel ace , I have been keeping track of my own sets on excel.
However, since yours was much better, I pitched mine out and used yours. I was going to suggest you combine the two sheets, but you beat me to it (plus I didn't have an account until now - I'm just lazy I guess).

BTW - You have an error on the Minifig sheet. The count for Aldar Beedo (non junkyard version) refers to another minifig count instead of the appropriate set on the previous sheet. This gives a false total. I fixed it on mine, but it's still there with the latest version linked at the top.

(updated 1/24/06) 131 sets, 295 minifigs, 38,462 pieces @ $0.106/piece
_________________

[Hair Jedi]

[Zombie Fetty]

Got it to work, thanks Hair Jedi.

I owe you one, this has helped me sort out which sets came out in which years.

[Hair Jedi]

[Zombie Fetty]

[bradyhoak]

Great job on the sheet - Just wanted to point out that you are also missing the new clone trooper minifig and the new chewbacca minfig.