Subject:
|
Re: Easiest way to get an inventory
|
Newsgroups:
|
lugnet.db.inv
|
Date:
|
Sun, 29 Jul 2001 21:10:51 GMT
|
Viewed:
|
733 times
|
| |
|
|
On Sun, Jul 29, 2001 at 07:09:31PM +0000, David Arnon wrote:
> I've received a MISB <set:8865> and I noticed it didn't have a piece count on
> LUGNET's set reference.
> I thought about counting the # of pieces, and then I thought that (if it's not
> too much extra effort) I might as well get a complete inventory.
> So, what's the fastest way to write an inventory in the correct format?
> I have access to a computer running win95 (+excel) and to one running linux
> (I'd prefer working with linux if there's a reasonable way).
Well, the way we format our inventories is a tab delimited text file,
with the following columns:
Quantity, Ldraw #, Bag number (if applicable), Color, Description, Notes.
To do that efficiently, we use a couple of excel sheets that will do part
name/number lookups for you. I've been working on a linux perl script
that will help writing invs, but it's still in beta... And I haven't
been working on it recently. :/ If you want that, I have no problem
email it to you. If you want the excel sheets, I'll put them up on
peeron:
http://peeron.com/tmp/blank.xls <--- this is a blank inventory template
http://peeron.com/tmp/parts.xls <--- this is the parts list
To use these, you should copy them both to the same directory, open the
parts.xls first, and then the blank.xls. It'll probably complain about
circular references, but you can safely ignore that. Then, just type in
the part number in the number column, and it'll fill out the part
description. Or, type in the part description (e.g. the LDraw name),
and it'll fill out the part number.
We should really write up a page about it, but for now, I hope this will
help.
HTH, :)
--
Dan Boger
dan@peeron.com
|
|
Message has 1 Reply:
Message is in Reply To:
 | | Easiest way to get an inventory
|
| Hi, I've received a MISB <set:8865> and I noticed it didn't have a piece count on LUGNET's set reference. I thought about counting the # of pieces, and then I thought that (if it's not too much extra effort) I might as well get a complete inventory. (...) (23 years ago, 29-Jul-01, to lugnet.db.inv)
|
6 Messages in This Thread:
  
- Entire Thread on One Page:
- Nested:
All | Brief | Compact | Dots
Linear:
All | Brief | Compact
This Message and its Replies on One Page:
- Nested:
All | Brief | Compact | Dots
Linear:
All | Brief | Compact
|
|
|
|
