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.
Lego Inventory/Spreadsheets
Moderator: VLC Directors
- KenmoreThompson
- MOC Poster
- Posts: 126
- Joined: Fri Apr 21, 2017 2:55 am
Re: Lego Inventory/Spreadsheets
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 Ambassador to TLG & VLC Director
My avatar is Ninjago's Pythor P Chumsworth. YAY! I finally have him! Thank you.
VLC Ambassador to TLG & VLC Director
My avatar is Ninjago's Pythor P Chumsworth. YAY! I finally have him! Thank you.
Re: Lego Inventory/Spreadsheets
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
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
- Kyler
- Brick Deity
- Posts: 1861
- Joined: Mon Apr 20, 2015 10:38 am
- Location: North Vancouver, BC
- Contact:
Re: Lego Inventory/Spreadsheets
Jason and Sarah are the King and Queen of inventory, and they use Rebricable I believe.
Kyler Storm - (not the Gladiator)
- KenmoreThompson
- MOC Poster
- Posts: 126
- Joined: Fri Apr 21, 2017 2:55 am
Re: Lego Inventory/Spreadsheets
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.
- TheRebricker
- Master Poster
- Posts: 789
- Joined: Fri Oct 03, 2014 7:29 pm
- Location: North Vancouver
- Blogged: http://VLC.ca/forums/viewtopic.php?f=8&t=4559
Re: Lego Inventory/Spreadsheets
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