Subject:
|
Re: auczilla XII: got yours yet?
|
Newsgroups:
|
lugnet.market.theory
|
Date:
|
Wed, 28 Jun 2000 22:17:09 GMT
|
Viewed:
|
973 times
|
| |
|
|
In lugnet.market.theory, Steve Bliss writes:
> So did you manage things by opening the sets, sorting all the bricks into
> containers, then picking the pieces for each lot from the containers?
> Or was it more like you opened each set, sorted the parts directly to the
> lots?
> Or something else?
My parts auction had variable lot sizes so I couldn't pre-sort into lots. My
software did a lot of the work for me. Here's how it went:
I counted each piece type and color and entered it into my software so that it
ended up in an access database. After I counted an example of each set, I
took inventory, counting the total number of each set. So if a particular set
has 3 2x2 red bricks, and I have 10 of those sets, then I must have 30 of
those pieces, right? even if I'm drawing that type of piece from five
different set numbers, I still know what I have. So I serialized each set. I
had four pharoah's forbidden ruins, and they were numbers 12,13,14, and 15 for
example. The algorithm created a new table containing all of the different
types of pieces with a link back to the source set serial number. Then the
auction ran. People placed bids on varying numbers of each type of piece. At
the end, I had another algorithm that produced a pick list. Lynn would get
the pick list for a person, then go down the list. It would say, go to set
#14 and remove 3 of these and 1 of those and 5 of those other things, and so
on. When she was done with the pick list, they were packed and shipped.
Having all the data in an access database meant that I could run some
astonishing sql queries on the data. For instance, I knew what the break even
dollar amount that I needed was. So the software would check the e-mail every
few minutes, then run this sql query that reported the total value of the
auction up to that instant. I could determine which sets had the best (or
worst) return on investment. Don't ever put a mud masher in your parts
auction. :-D Obviously, I could determine which pieces were the most
valuable. Interestingly some sets provided a good investment while still not
selling a lot of their pieces. Others would sell a lot of pieces, but not
make much money. All in all, I had 33,000 pieces, I think and had 6000 left
over afterwards which were quickly snapped up by my children. It was easily
cost-effective.
> Been there.
This is actually #4 (and hopefully the last)
> Great! We'll check back in about 10 years.
Actually, it may be a lot sooner than that. We're building a house with a
sizable basement which should be done by halloween. If the baby is talking by
then (he should be) we should be able to start things up again.
> > Let's
> > just hope [Todd] doesn't have children any time soon, or at least until bulk
> > ordering is well under way. :-)
>
> Amen!
brian
|
|
Message is in Reply To:
 | | Re: auczilla XII: got yours yet?
|
| (...) So did you manage things by opening the sets, sorting all the bricks into containers, then picking the pieces for each lot from the containers? Or was it more like you opened each set, sorted the parts directly to the lots? Or something else? (...) (24 years ago, 28-Jun-00, to lugnet.market.theory)
|
18 Messages in This Thread:
 
 
- Entire Thread on One Page:
- Nested:
All | Brief | Compact | Dots
Linear:
All | Brief | Compact
|
|
|
|
