Lego Inventory/Spreadsheets

A place for people at large to discuss items of interest with other people and members of the VLC.

Moderator: VLC Directors

User avatar
KenmoreThompson
Experienced Poster
Posts: 90
Joined: Fri Apr 21, 2017 2:55 am

Lego Inventory/Spreadsheets

Postby KenmoreThompson » Fri Jul 28, 2017 7:13 pm

I remember at BrickCan showing up to the collaborative build session and there was some brief discussion about inventory tracking and whatnot. Does anyone use Excel for this? (I think that's what was said in the session) Does anyone use a different inventory system that works better? If someone does use Excel, could I possibly get a copy of your template? Or maybe just a screen-grab that I can reverse-engineer?

I'm 40% done planning my first large build (a SHIP-sized Auquanaut submarine) and I'm thinking it might be useful to toss everything into a spreadsheet to keep track of my ordering, and keep costs reasonable.
User avatar
chump
Vice President
Posts: 6437
Joined: Tue Oct 12, 2004 9:57 am

Re: Lego Inventory/Spreadsheets

Postby chump » Fri Jul 28, 2017 8:45 pm

I used to use a basic spreadsheet but almost all of that can be done on Brickset and then imported into Rebrickable. At least that's how I've done it.
Pierre
VLC Vice President & VLC Ambassador to TLG

My avatar is Ninjago's Pythor P Chumsworth. YAY! I finally have him! Thank you.
User avatar
Hamslice
Element King
Posts: 2010
Joined: Mon Feb 20, 2012 2:59 pm
Location: Squamish

Re: Lego Inventory/Spreadsheets

Postby Hamslice » Sat Jul 29, 2017 8:53 am

Allan and I were the ones who gave that presentation.

We mainly use google doc, as it can be easliy shared with others. If your just trying to mantain parts ordered and parts needed to be ordered, Bricklink has a "want list". Add your parts to it, you can specify color quanity and price you want to pay. Hit the order button and it will scrub all stores to find you the best prices and the stores that have the most inventory of what you need to cut down on shipping costs.

Hope this helps

Keith
User avatar
Kyler
Membership Director
Posts: 1545
Joined: Mon Apr 20, 2015 10:38 am
Location: North Vancouver, BC
Contact:

Re: Lego Inventory/Spreadsheets

Postby Kyler » Sat Jul 29, 2017 11:02 pm

Jason and Sarah are the King and Queen of inventory, and they use Rebricable I believe.
Kyler Storm
VLC Membership Director
User avatar
KenmoreThompson
Experienced Poster
Posts: 90
Joined: Fri Apr 21, 2017 2:55 am

Re: Lego Inventory/Spreadsheets

Postby KenmoreThompson » Tue Aug 01, 2017 11:58 am

Thanks, guys. I'll look into using Google Docs, I think. I've been using Bricklink's Want List, but I don't find it terribly useful as an inventory management, as much as an ordering management tool. I'll have a look at Rebrickable, too.
User avatar
TheRebricker
Master Poster
Posts: 782
Joined: Fri Oct 03, 2014 7:29 pm
Location: North Vancouver

Re: Lego Inventory/Spreadsheets

Postby TheRebricker » Thu Feb 22, 2018 8:44 pm

I highly recommend Rebrickable.com as it offers many ways to inventory and then based on what it knows you have, can suggest what you can build.
- Jason

Return to “General Discussions”

Who is online

Users browsing this forum: No registered users and 2 guests