I pulled the text in through Excel and parsed it apart using formulas. I
do stuff like this often so it only takes about 30 min to do a new page.
The table was done via an Excel Pivot table. Right now, I like it, but
you're right, its mostly empty. When I get more data, I'll do one with
more analysis.
The slots for non-existent lens/aperture combinations was one thing I
didn't think of, but I was striving for ease of production, so this way is
easier right now.
You have to be careful pulling prices too soon after auction endings, Ebay
doesn't update immediately after auction completion. Also, some manual
work is required to filter out the auctions that didn't meet reserve and
those that don't include "Zuiko" in the auction description.
Skip
>Is this done by a program, or are you gleaning these
>items out by hand?
>
>>Enjoy. Suggestions are welcome.
>
>I don't think the table works too well -- it's mostly empty! I'd rather see
>each lens as a separate line. (Do you think there will ever be an 85-250mm
>f1.2 lens? :-)
>
>Also, it doesn't make sense right now with the limited data you have now,
>but it might be nice to see high, low, average, and perhaps even standard
>deviation.
>
>Have fun, and if there's anything I can do to help, let me know! In
>particular, if you're doing much of this by hand, I was going to
>automagically fetch and parse the data programmatically, probably on a
>daily basis.
>
>: Jan Steinman <mailto:jans@xxxxxxxxxxx>
>: 19280 Rydman Court, West Linn, OR 97068-1331 USA
>: +1.503.635.3229
-----------------------------------------------
Skip Williams - skipwilliams@xxxxxxxxx
-----------------------------------------------
< This message was delivered via the Olympus Mailing List >
< For questions, mailto:owner-olympus@xxxxxxxxxxxxxxx >
< Web Page: http://Zuiko.sls.bc.ca/swright/olympuslist.html >
|