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 Previous  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
Zombiekid24
Undead!


Joined: 10 Apr 2006

PostPosted: Mon Jun 12, 2006 4:17 pm    Post subject: Reply with quote

That's a great tool. Thanks for the hardwork involved.

Now it makes me want to go through my extra minifigs so I have an exact count.
Back to top
View user's profile Send private message
stubek



Joined: 08 Jun 2006

PostPosted: Thu Jun 29, 2006 1:10 pm    Post subject: Reply with quote

What about adding something on the Mini Fig sheet to subtract figs...i.e. you bought a set on ebay that is missing figures?
Back to top
View user's profile Send private message
ZombieAndi
Destroyed!


Joined: 08 Feb 2005
Location: near my laptop

PostPosted: Thu Jun 29, 2006 1:13 pm    Post subject: Reply with quote

stubek wrote:
What about adding something on the Mini Fig sheet to subtract figs...i.e. you bought a set on ebay that is missing figures?


You can do this with just adding negative numbers into the 'Extra'-field.
For example: you have two sets where Luke is included, but the one is without Minifig. So you enter:
Name from Set Extra total
Luke 2 -1 1
_________________
~Andi

FlickrBrickshelf
Back to top
View user's profile Send private message Send e-mail Yahoo Messenger
Hair Jedi
Fuzzball Rocker


Joined: 04 Feb 2005
Location: Somewhere around here

PostPosted: Thu Jun 29, 2006 2:09 pm    Post subject: Reply with quote

Andi wrote:
stubek wrote:
What about adding something on the Mini Fig sheet to subtract figs...i.e. you bought a set on ebay that is missing figures?


You can do this with just adding negative numbers into the 'Extra'-field.
For example: you have two sets where Luke is included, but the one is without Minifig. So you enter:
Name from Set Extra total
Luke 2 -1 1


Thanx for providing that answer Andi Smile

I pondered adding a "Less" column in the minifig sheet, but I figured that if someone needed to subtract any from their count, they could use the method that Andi suggested. Perhaps I need to make an instruction sheet for everything.....
_________________
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
Wat Tambor



Joined: 18 Mar 2006
Location: N. Ireland

PostPosted: Thu Jun 29, 2006 2:21 pm    Post subject: Reply with quote

Sorry to sound stupid but how do you open the file?
_________________
I'm an atheist! And I've never been happier!
Back to top
View user's profile Send private message MSN Messenger
Hair Jedi
Fuzzball Rocker


Joined: 04 Feb 2005
Location: Somewhere around here

PostPosted: Thu Jun 29, 2006 2:22 pm    Post subject: Reply with quote

Wat Tambor wrote:
Sorry to sound stupid but how do you open the file?


The file was made with Microsft Excel 2003, you need Excel to open the file
_________________
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
Wat Tambor



Joined: 18 Mar 2006
Location: N. Ireland

PostPosted: Thu Jun 29, 2006 2:25 pm    Post subject: Reply with quote

Thank you Hair Jedi! Very Happy
_________________
I'm an atheist! And I've never been happier!
Back to top
View user's profile Send private message MSN Messenger
Hair Jedi
Fuzzball Rocker


Joined: 04 Feb 2005
Location: Somewhere around here

PostPosted: Thu Jun 29, 2006 2:29 pm    Post subject: Reply with quote

Wat Tambor wrote:
Thank you Hair Jedi! Very Happy


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
ZombieAndi
Destroyed!


Joined: 08 Feb 2005
Location: near my laptop

PostPosted: Thu Jun 29, 2006 2:51 pm    Post subject: Reply with quote

hair jedi wrote:


Thanx for providing that answer Andi Smile

I pondered adding a "Less" column in the minifig sheet, but I figured that if someone needed to subtract any from their count, they could use the method that Andi suggested.


you're welcome. It's the easiest way to 'fool' excel's addition function.

Quote:
Perhaps I need to make an instruction sheet for everything.....


If you want, I can do it for you.
_________________
~Andi

FlickrBrickshelf
Back to top
View user's profile Send private message Send e-mail Yahoo Messenger
stubek



Joined: 08 Jun 2006

PostPosted: Thu Jun 29, 2006 4:58 pm    Post subject: Reply with quote

haha, simple answer and it is perfect. Thank you, and thank you for this list as I was working on one formyself.
Back to top
View user's profile Send private message
Hair Jedi
Fuzzball Rocker


Joined: 04 Feb 2005
Location: Somewhere around here

PostPosted: Thu Jun 29, 2006 11:04 pm    Post subject: Reply with quote

Andi wrote:
hair jedi wrote:


Thanx for providing that answer Andi Smile

I pondered adding a "Less" column in the minifig sheet, but I figured that if someone needed to subtract any from their count, they could use the method that Andi suggested.


you're welcome. It's the easiest way to 'fool' excel's addition function.

Quote:
Perhaps I need to make an instruction sheet for everything.....


If you want, I can do it for you.


Andi... I would love you forever if you could spare the time to do so... I just can't at the moment 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
ZombieAndi
Destroyed!


Joined: 08 Feb 2005
Location: near my laptop

PostPosted: Fri Jun 30, 2006 2:49 am    Post subject: Reply with quote

hair jedi wrote:
Andi wrote:


If you want, I can do it for you.


Andi... I would love you forever if you could spare the time to do so... I just can't at the moment Smile


okay Smile I'll do it.
_________________
~Andi

FlickrBrickshelf
Back to top
View user's profile Send private message Send e-mail Yahoo Messenger
ZombieAndi
Destroyed!


Joined: 08 Feb 2005
Location: near my laptop

PostPosted: Fri Jun 30, 2006 11:11 am    Post subject: Reply with quote

Hair Jedi, I sent you the instruction per Email. Please let me know what you think.
_________________
~Andi

FlickrBrickshelf
Back to top
View user's profile Send private message Send e-mail Yahoo Messenger
Hair Jedi
Fuzzball Rocker


Joined: 04 Feb 2005
Location: Somewhere around here

PostPosted: Fri Jun 30, 2006 2:23 pm    Post subject: Reply with quote

Andi wrote:
Hair Jedi, I sent you the instruction per Email. Please let me know what you think.


Thank you thank you thank you thank you Very Happy

You went above and beyond the call of duty Andi. The instructions look fantastic!!

The link to the instructions is now in the first post of the thread.

Consider yourself loved forever by me for it Smile

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
Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger
stubek



Joined: 08 Jun 2006

PostPosted: Fri Jun 30, 2006 2:35 pm    Post subject: Reply with quote

ahhh, but the new link says not working Sad its ok, i know how to use the spreadsheets.

Shocked
Back to top
View user's profile Send private message
ZombieAndi
Destroyed!


Joined: 08 Feb 2005
Location: near my laptop

PostPosted: Fri Jun 30, 2006 2:48 pm    Post subject: Reply with quote

hair jedi wrote:
Andi wrote:
Hair Jedi, I sent you the instruction per Email. Please let me know what you think.


Thank you thank you thank you thank you Very Happy

You went above and beyond the call of duty Andi. The instructions look fantastic!!

The link to the instructions is now in the first post of the thread.

Consider yourself loved forever by me for it Smile

Cheers,
Michael - Hair Jedi


You are very welcome Smile It was fun doing it
But the link is not working...
_________________
~Andi

FlickrBrickshelf
Back to top
View user's profile Send private message Send e-mail Yahoo Messenger
Hair Jedi
Fuzzball Rocker


Joined: 04 Feb 2005
Location: Somewhere around here

PostPosted: Fri Jun 30, 2006 7:10 pm    Post subject: Reply with quote

Small typo on my part on the file name Embarassed ... it should be working now
_________________
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
stubek



Joined: 08 Jun 2006

PostPosted: Fri Jun 30, 2006 11:21 pm    Post subject: Reply with quote

hair jedi,
I found a misprint while using your sheet tonight.

On the systems page, line number 142 under 2005, you have the droid tri-fighter listed as 7152, but i believe it is actually 7252.

Something for the next update.

but thanks for the great list.
Back to top
View user's profile Send private message
sho



Joined: 08 Aug 2006

PostPosted: Sun Aug 20, 2006 7:19 am    Post subject: Reply with quote

New Keychains bought at Billund:

4270900 / 851463 Clone Pilot
4294201 / 851659 Boba Fett
4270902 / 851464 Chewbacca

This one is already in there
4224469 / 850352 Snowtrooper

(which partno should be used?)

Also Stormtrooper keychain partno is 3948
According to:
http://cargobay.starwars.com/webapps/cargobay/item-detail/15510
Back to top
View user's profile Send private message
Clanure



Joined: 20 Jul 2006
Location: Clinton, UT

PostPosted: Fri Aug 25, 2006 4:49 pm    Post subject: Reply with quote

Thanks for the great tracking tool. I've noticed a few errors however:

1. Bib Fortuna is calc'd as coming with Jabba's Palace, but it should be Jabba's Message.

2. For SW114, you have 1 being added for the new ISD, but you also have the ISD adding to SW154. There's only one of this figure with the ISD, so which one should it really add to? I think SW154.

And updates:

1. There's no non-LUL Mace.

2. When will the new 6212 X-Wing be added? Are you going to wait until the 2007 sets?

Great tool by the way. I thought of doing something like this myself, but then found yours.

Thanks again,

Clanure
Back to top
View user's profile Send private message Yahoo Messenger MSN Messenger
Hair Jedi
Fuzzball Rocker


Joined: 04 Feb 2005
Location: Somewhere around here

PostPosted: Fri Aug 25, 2006 9:26 pm    Post subject: Reply with quote

I really need to find more time to troubleshoot this hing before I put a new version up... blah

I have a new version in the works, with the 2007 sets added, also the new X -Wing and the UCS TIE Advanced are added as well.

As far as the minifig counts go, there's a lot of stuff there to tally up, and I figured I had a few errors, I do thank everyone for helping me find boo boo's in the sheet(s) and will fix the errors for the new version.

To address sho's note on the new keychains, the new ones will be added to the new version as well.

Stubek - thanx for finding the typo, it's fixed in the new version

Once again I'm glad so many of you dig my little creation, I'm working on some new lovliness for the new version which will be revealed when it's released in the near future.

Thanx again all!!

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
Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger
CallawayCadTech



Joined: 24 Aug 2006
Location: FLORIDA

PostPosted: Tue Aug 29, 2006 8:50 am    Post subject: Reply with quote

Thanks for all of your hard work and inadvertantly reminding the rest of us what we still dont have Very Happy
_________________
LEGOS, THEY ARENT JUST FOR KIDS ANYMORE

OH, WAIT, I AM JUST NOT A KID ANYMORE. GOTTA HATE GROWING UP
Back to top
View user's profile Send private message
moogly



Joined: 01 Aug 2006
Location: Canada

PostPosted: Wed Oct 11, 2006 12:36 pm    Post subject: Reply with quote

Thank you for this I was just searching for something that listed all the sets this is even better !!!
Back to top
View user's profile Send private message
Hair Jedi
Fuzzball Rocker


Joined: 04 Feb 2005
Location: Somewhere around here

PostPosted: Tue Oct 24, 2006 5:13 pm    Post subject: Reply with quote

I swear an update is coming... we're STILL unpacking from the move a few weeks ago... have faith my friends

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
Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger
sho



Joined: 08 Aug 2006

PostPosted: Sat Nov 04, 2006 5:23 pm    Post subject: Reply with quote

To see more SW keychains, go to S@H and select keychains.
http://shop.lego.com/ByTheme/Department.aspx?d=228
Then go to different coutnries, since they have different key chains available (US, UK, DK, DE etc.)
Back to top
View user's profile Send private message
Kojian



Joined: 12 Oct 2006

PostPosted: Tue Nov 07, 2006 11:35 am    Post subject: Reply with quote

Hi , I am new, iam from austria and i`m 14 years old
_________________
I am a real fan of Obi-Wan
I am from austria
Back to top
View user's profile Send private message
Hair Jedi
Fuzzball Rocker


Joined: 04 Feb 2005
Location: Somewhere around here

PostPosted: Sat Dec 02, 2006 4:29 pm    Post subject: Reply with quote

no more sticky Sad
_________________
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
Old Republic
Master Jedi [VET]


Joined: 05 Feb 2005
Location: Calgary Alberta Canada

PostPosted: Sat Dec 02, 2006 4:38 pm    Post subject: Reply with quote

Sure it is.Very Happy Just not in the traditional way.
http://www.fbtbforums.net/viewtopic.php?t=17006
_________________
BRICKSHELF
FBTB flickr
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: Sun Dec 03, 2006 11:25 am    Post subject: Reply with quote

Ahhhh... I see... well then... carry on 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
Clanure



Joined: 20 Jul 2006
Location: Clinton, UT

PostPosted: Fri Jan 12, 2007 3:39 pm    Post subject: Reply with quote

Hair,

Any idea as to when we can expect an update? There are new sets to add. I don't want to step on any toes, but I'd be willing to update it if you don't have time.

Thanks,

Clanure
Back to top
View user's profile Send private message Yahoo Messenger MSN Messenger
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 Previous  1, 2, 3, 4, 5  Next
Page 3 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