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.

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

First off, you're welcome, glad you like my little projects.

I pondered adding the minifigs from both the pens and the keychains, but decided against it. Both the pens and keychains are on the main inventory, and since the only thing about them that makes them SW is the minifigs, I figured one entry for them was enough.

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

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

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.

In the sheet that contains the System Sets, simply enter the quantity of each set you have in the set's Qty column, then hit Enter. Automatically, the spreadsheet will update the pc count for that set, cost, total pcs for all your sets, total cost for all your sets and any related minifig counts on the Minifig Sheet.

If you have any additional minifigs, go to the Minifig Sheet, and enter the the quantity in the Extra column for the particular minfig. This will automatically update the total qty for that minfig, plus all the grand totals for your minfigs.

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.

I'm still on the fence with the magnet sets... pondered adding them, then not... still thinking about it. Though you can always customize your copy however you like, as many members have... darn modders :D ::D:_________________Dyslexics of the world.... UNTIE!
Vote for Whiplash: www.rockerie.com/eriemusicawards
Check out my bands' site: www.myspace.com/whiplashbandpa

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.

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.