FBTBForums.net Forum Index FBTBForums.net

...has been nuked!

 
 ChatChat    FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Hair Jedi's LSW Inventory Spreadsheets! UPDATED 3/25/07!!
Goto page 1, 2, 3, 4, 5  Next
 
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    FBTBForums.net Forum Index -> LEGO Star Wars
View previous topic :: View next topic  
Author Message
Hair Jedi
Fuzzball Rocker


Joined: 04 Feb 2005
Location: Somewhere around here

PostPosted: Tue May 31, 2005 9:39 pm    Post subject: Hair Jedi's LSW Inventory Spreadsheets! UPDATED 3/25/07!! Reply with quote

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


Last edited by Hair Jedi on Sun Mar 25, 2007 11:20 am; edited 16 times in total
Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger
markz



Joined: 01 Jun 2005

PostPosted: Wed Jun 01, 2005 10:11 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Hair Jedi
Fuzzball Rocker


Joined: 04 Feb 2005
Location: Somewhere around here

PostPosted: Thu Jun 02, 2005 12:59 pm    Post subject: Reply with quote

My pleasure Smile
_________________
Dyslexics of the world.... UNTIE!
Vote for Whiplash: www.rockerie.com/eriemusicawards
Check out my bands' site: www.myspace.com/whiplashbandpa
Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger
mike block



Joined: 03 Jun 2005

PostPosted: Fri Jun 03, 2005 6:46 am    Post subject: BMP of Sandcrawler Reply with quote

A pure bitmap of the new model is avail at:

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

cheers
Back to top
View user's profile Send private message
Jargon



Joined: 01 Jun 2005
Location: Possessing the body of Jake_Snicket

PostPosted: Mon Jun 06, 2005 10:26 pm    Post subject: Reply with quote

These are very cool as well as very useful. Thank you!
Have you considered adding the minifigs from the LEGO SW Pens?
- JS
Back to top
View user's profile Send private message Send e-mail Visit poster's website MSN Messenger
Hair Jedi
Fuzzball Rocker


Joined: 04 Feb 2005
Location: Somewhere around here

PostPosted: Tue Jun 07, 2005 11:06 am    Post subject: Reply with quote

Jake_Snicket wrote:
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. Smile

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.

Cheers,
Hair Jedi
_________________
Dyslexics of the world.... UNTIE!
Vote for Whiplash: www.rockerie.com/eriemusicawards
Check out my bands' site: www.myspace.com/whiplashbandpa
Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger
Grolim



Joined: 28 Jun 2005
Location: New Zealand

PostPosted: Tue Jun 28, 2005 6:15 pm    Post subject: Reply with quote

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 Sad
Back to top
View user's profile Send private message Visit poster's website
alfredjr



Joined: 04 Feb 2005

PostPosted: Tue Jul 05, 2005 9:43 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
General C



Joined: 22 Jun 2005
Location: Lost in Lego Bliss

PostPosted: Sat Jul 09, 2005 4:49 pm    Post subject: Reply with quote

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 Very Happy
Back to top
View user's profile Send private message
HoodedKubaz



Joined: 21 Jul 2005
Location: Charleston, SC

PostPosted: Sat Jul 30, 2005 1:21 pm    Post subject: Reply with quote

ty Razz
_________________
I deduct your pay!
pm me to join the GDIS
(Gonk Droid Independence System)
Back to top
View user's profile Send private message AIM Address
Zombie Fetty
Undead!


Joined: 03 Aug 2005
Location: I'm really not sure

PostPosted: Mon Sep 05, 2005 7:46 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Hair Jedi
Fuzzball Rocker


Joined: 04 Feb 2005
Location: Somewhere around here

PostPosted: Mon Sep 05, 2005 8:28 am    Post subject: Reply with quote

Master Fetty wrote:
Could somebody explain how to use it? I don't ghet it.


It's very simple Master Fetty...

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.

Hope this explains things for you...

Cheers,
Hair Jedi
_________________
Dyslexics of the world.... UNTIE!
Vote for Whiplash: www.rockerie.com/eriemusicawards
Check out my bands' site: www.myspace.com/whiplashbandpa
Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger
sid



Joined: 04 Jun 2005
Location: Vancouver, BC

PostPosted: Mon Sep 05, 2005 11:35 am    Post subject: Reply with quote

The Obi-Wan keychain is missing, the part number on mine is 4270895. And more importantly thanks for all the work on this.
Back to top
View user's profile Send private message
Hair Jedi
Fuzzball Rocker


Joined: 04 Feb 2005
Location: Somewhere around here

PostPosted: Mon Sep 05, 2005 11:40 pm    Post subject: Reply with quote

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


You're quite welcome sid, and thanx for the heads-up on the missing keychain... wasn't even aware of an Obi-Wan one... but it's now added to the list.

The sheets have been updated and some minor bugs (forgotten formulas Embarassed ) fixed, the new version is posted for download.

Cheers,
Hair Jedi
_________________
Dyslexics of the world.... UNTIE!
Vote for Whiplash: www.rockerie.com/eriemusicawards
Check out my bands' site: www.myspace.com/whiplashbandpa
Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger
Zombie Fetty
Undead!


Joined: 03 Aug 2005
Location: I'm really not sure

PostPosted: Tue Sep 06, 2005 10:37 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
sid



Joined: 04 Jun 2005
Location: Vancouver, BC

PostPosted: Tue Sep 06, 2005 11:14 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Hair Jedi
Fuzzball Rocker


Joined: 04 Feb 2005
Location: Somewhere around here

PostPosted: Tue Sep 06, 2005 11:56 am    Post subject: Reply with quote

sid wrote:
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
Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger
Zombie Fetty
Undead!


Joined: 03 Aug 2005
Location: I'm really not sure

PostPosted: Tue Sep 06, 2005 12:59 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Hair Jedi
Fuzzball Rocker


Joined: 04 Feb 2005
Location: Somewhere around here

PostPosted: Tue Sep 06, 2005 1:54 pm    Post subject: Reply with quote

Master Fetty wrote:
Is there any way how you can get the pictures in the right place after copying?


If you're just downloading the file, the pix should all be in their correct place
_________________
Dyslexics of the world.... UNTIE!
Vote for Whiplash: www.rockerie.com/eriemusicawards
Check out my bands' site: www.myspace.com/whiplashbandpa
Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger
Zombie Fetty
Undead!


Joined: 03 Aug 2005
Location: I'm really not sure

PostPosted: Tue Sep 06, 2005 2:30 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Hair Jedi
Fuzzball Rocker


Joined: 04 Feb 2005
Location: Somewhere around here

PostPosted: Tue Sep 06, 2005 3:07 pm    Post subject: Reply with quote

Master Fetty wrote:
Strange, the cells are too small for the pictures on mine.


If need be, you can resize the height of the cells to fit the pix
_________________
Dyslexics of the world.... UNTIE!
Vote for Whiplash: www.rockerie.com/eriemusicawards
Check out my bands' site: www.myspace.com/whiplashbandpa
Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger
jedi-chaz



Joined: 21 Aug 2005

PostPosted: Tue Sep 06, 2005 3:16 pm    Post subject: Reply with quote

Thanks for the list it's great!!
Back to top
View user's profile Send private message Send e-mail
Hair Jedi
Fuzzball Rocker


Joined: 04 Feb 2005
Location: Somewhere around here

PostPosted: Tue Sep 06, 2005 3:36 pm    Post subject: Reply with quote

jedi-chaz wrote:
Thanks for the list it's great!!


you're quite welcome Smile
_________________
Dyslexics of the world.... UNTIE!
Vote for Whiplash: www.rockerie.com/eriemusicawards
Check out my bands' site: www.myspace.com/whiplashbandpa
Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger
Zombie Fetty
Undead!


Joined: 03 Aug 2005
Location: I'm really not sure

PostPosted: Wed Sep 07, 2005 6:55 am    Post subject: Reply with quote

hair jedi wrote:
Master Fetty wrote:
Strange, the cells are too small for the pictures on mine.


If need be, you can resize the height of the cells to fit the pix


I suppose, but it will take about an hour to do them all to the right size.
Back to top
View user's profile Send private message Send e-mail
Darth's Zombie
Destroyed!


Joined: 07 Sep 2005
Location: Columbus, OH

PostPosted: Wed Sep 07, 2005 4:32 pm    Post subject: Error for Aldar Beedo Reply with quote

Hey this is a great spreadsheet! Thanks for taking the time to put this out!
As an old excel ace Wink , 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
_________________


Last edited by Darth's Zombie on Tue Jan 24, 2006 2:20 pm; edited 1 time in total
Back to top
View user's profile Send private message
Hair Jedi
Fuzzball Rocker


Joined: 04 Feb 2005
Location: Somewhere around here

PostPosted: Wed Sep 07, 2005 6:45 pm    Post subject: Re: Error for Aldar Beedo Reply with quote

Darth's Daddy wrote:
Hey this is a great spreadsheet! Thanks for taking the time to put this out!
As an old excel ace Wink , 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.

105 sets, 227 minifigs, 26,964 pieces @ a little less than $0.11/piece


Thanx for the compliments, from one Excel nut to another, I'm glad you like my little creation.

Fixed the Aldar Beedo error, thanx for the heads-up... I'm so embarassed Embarassed

Cheers,
Hair Jedi
_________________
Dyslexics of the world.... UNTIE!
Vote for Whiplash: www.rockerie.com/eriemusicawards
Check out my bands' site: www.myspace.com/whiplashbandpa
Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger
Zombie Fetty
Undead!


Joined: 03 Aug 2005
Location: I'm really not sure

PostPosted: Thu Sep 08, 2005 6:54 am    Post subject: Reply with quote

Got it to work, thanks Hair Jedi.

I owe you one, this has helped me sort out which sets came out in which years.
Back to top
View user's profile Send private message Send e-mail
Hair Jedi
Fuzzball Rocker


Joined: 04 Feb 2005
Location: Somewhere around here

PostPosted: Thu Sep 08, 2005 8:19 am    Post subject: Reply with quote

Master Fetty wrote:
Got it to work, thanks Hair Jedi.

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


No problem, buy me an ISD and we'll call it even... ::D:
_________________
Dyslexics of the world.... UNTIE!
Vote for Whiplash: www.rockerie.com/eriemusicawards
Check out my bands' site: www.myspace.com/whiplashbandpa
Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger
Zombie Fetty
Undead!


Joined: 03 Aug 2005
Location: I'm really not sure

PostPosted: Thu Sep 08, 2005 11:41 am    Post subject: Reply with quote

hair jedi wrote:
Master Fetty wrote:
Got it to work, thanks Hair Jedi.

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


No problem, buy me an ISD and we'll call it even... ::D:


Ha, ha. ::D:
Back to top
View user's profile Send private message Send e-mail
bradyhoak



Joined: 01 Aug 2005

PostPosted: Mon Sep 12, 2005 9:38 am    Post subject: Some more minifig keychains Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    FBTBForums.net Forum Index -> LEGO Star Wars All times are GMT - 5 Hours
Goto page 1, 2, 3, 4, 5  Next
Page 1 of 5
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group