Data Table Practice!

Damn! another bug! auction # 2220923911

The following table yadda, yadda, yadda....
 
                     Max                        Current Winning
 #    BIDDER         Bid      Day & Time         Bid  &  Bidder
                    (US $)
  1   falerno1      180.00   25-Jan  22:15:09     1.00   falerno1 
  2   nathier       201.00   26-Jan  01:53:48   182.50   nathier 
  3   delabouteill  186.00   26-Jan  02:06:16   188.50   nathier 
  4   nathier       233.00   26-Jan  02:48:02   203.50   nathier 
  5   klc411        191.51   29-Jan  17:06:36   194.01   nathier 
  6   klc411        200.00   29-Jan  17:06:54   202.50   nathier 
  7   catnipmercer  225.00   29-Jan  20:56:09   227.50   nathier 
  8   catnipmercer  250.00   29-Jan  20:56:24   235.50   catnipmercer 
  9   aimpc         238.00   30-Jan  16:35:24   240.50   catnipmercer 
 10   penn_pal      265.00   30-Jan  17:18:21   255.00   penn_pal 
 11   catnipmercer  750.00   01-Feb  20:59:14   270.00   catnipmercer 
 12   penn_pal      304.00   01-Feb  20:59:39   309.00   catnipmercer 
 13   terukajc     *760.00   01-Feb  20:59:47   760.00   terukajc 

Did your sheet not correctly handle the same bidder bidding against self separated by one or more other bidders? The version in the topic looks correct -- was that after the fix?

This sheet will soon be bullet proof! Of course, then eBay will change something to make it totally obsolete! Then you'll know first hand how the AS programmers feel!

Jabbergah                                                    

your tables are nice. one suggestion in the form of a challenge. Instead of or in addition to time/date column it would be useful to see a 'TBAE: (time before auction end)' analysis colum. i.e. on date and time bid placed, TBAE column has '23 seconds'. The gaunlet is cast. May the best AS geek win!

happy sniping

Jabber:

majipoor: Sorry, have to pass for now. I'd like to keep the keying data to a minimum, and that would be more data to enter by hand. The less 'personal' data entered, the better it should work.... maybe in rev 3?

...is already known! It's Puppy!

Don't know what Puppy will think, but I don't think there's enough room for both columns, and I think they would provide redundant info anyway.

Also, by using the actual date/time data from the bid histories, it might better help people to learn how to analyze their auction bid histories on their own. After all, we can't expect Puppy to be around 24/7!

However, replacing the date/time column with a time-to-auction-end (TTAE) WOULD be an interesting exercise, even if we decide the way it currently works is best! Before you try it, Puppy, make sure you SAVE the current version!

Actually, maybe just an additional column that would display the TTAE for just the LAST 5 - 10 minutes. Maybe by limiting the column to 9.99 minutes (7 characters wide?) it will fit?

Jabbergah                                                    

The following table has been reorganized and sorted into date order.  First
bid placed is line #1.  That should make it easier to follow the auction.
Two additional columns have been added.  They are the current bid and high
bidder, as displayed on eBay after each bid is placed.              v2.1.01
* = Winning bid. (may be less than actual maximum entered.)
 
                    Max                        Current Winning
 #    BIDDER        Bid      Day & Time         Bid  &  Bidder
                   (US $)
  1   falerno1     180.00   25-Jan  22:15:09   179.50   falerno1 
  2   nathier      201.00   26-Jan  01:53:48   182.50   nathier 
  3   delabouteil  186.00   26-Jan  02:06:16   188.50   nathier 
  4   nathier      233.00   26-Jan  02:48:02   188.50   nathier 
  5   klc411       191.51   29-Jan  17:06:36   194.01   nathier 
  6   klc411       200.00   29-Jan  17:06:54   202.50   nathier 
  7   catnipmerce  225.00   29-Jan  20:56:09   227.50   nathier 
  8   catnipmerce  250.00   29-Jan  20:56:24   235.50   catnipmerce 
  9   aimpc        238.00   30-Jan  16:35:24   240.50   catnipmerce 
 10   penn_pal     265.00   30-Jan  17:18:21   255.00   penn_pal 
 11   catnipmerce  750.00   01-Feb  20:59:14   270.00   catnipmerce 
 12   penn_pal     304.00   01-Feb  20:59:39   309.00   catnipmerce 
 13   terukajc    *760.00   01-Feb  20:59:47   760.00   terukajc 

Now the question... Did my 'fix' break something else!

Time till end... Might be an interesting exercise, but will have to wait till I get all the kinks worked out of this one.

Also not really necessary to understand the auction. We don't even NEED the day and time displayed, but think it adds to the clarity and reinforces that the bids are in Day/Time order, and not bid amount order.

Keying data? Thought you were copying and pasting. Geez, talk about side stepping a challenge, .

In your last table example where the last line reads: "13 terukajc *760.00 01-Feb 20:59:47 760.00 terukajc", you dont say when the end time was. Was this bid placed in the last 13 seconds? Maybe sniped? See my point? OK OK, maybe R3.

happy sniping

I do copy and paste the bid history.
I have to manually add opening bid amount.

As I said, it would be interesting, and maybe nice, to see time till end of auction, but the real purpose of the project was to explain how an auction went, and help someone understand why a bid was or was not accepted. All that's needed is that the bids be in time order.

Didn't mean to give you the impression I was dismissing your idea with no thought, but (to me) there is such a thing as to much information.

Besides, I'm still trying to get all the kinks worked out of what I presently have. (see top of this page)

I think you've said somewhere before, but I cant find it. So, tell again how you place data in your spreadsheet (Im using Excel also). I tried the bidder history listing, what a pain! All data is text in a single string. No wonder you passed on further refinement, I take it all back.

Too much data? Never! (see, top of page) Ok, Im made of wood tonight, whats wrong with it? LOL, youre answering before I finish my edits! (edit snipes)

happy sniping

[This message was edited by majipoor on February 03, 2004 at 08:34 PM.]

[This message was edited by majipoor on February 03, 2004 at 08:36 PM.]

Jabber tried using excel. I'm using lotus and macros.

I paste the strings, take them apart and convert to numbers, do my calcs, and then convert them back into strings before a paste to the forum.

quote:

---

whats wrong with it?

---

bid # 4 current price is wrong. the fourth bidder raised his own already high bid, so the price should not have gone up.

quote:

---

(edit snipes)

---

(your free edit snipes are used up, you'll have to pay for them from now on)

majipoor, this is for you and Jabber.
Still don't like the idea of 'Time till end' for each bid, but I DO think THIS is better... Example auction.

The following table has been reorganized and sorted into date order.  First
bid placed is line #1.  That should make it easier to follow the auction.
Two additional columns have been calculated and added.  They are the current 
bid and high bidder, as displayed on eBay after each bid is placed.        v2.1.07
* = Winning bid. 
 
                   Max                        Current Winning
 #    BIDDER       Bid      Day & Time         Bid  &  Bidder
                  (US $)
  1   mthalpern    81.01   05-Feb  18:39:06    75.00   mthalpern  
  2   tmladen77    80.00   05-Feb  21:15:47    81.00   mthalpern  
  3   tmladen77    82.00   05-Feb  21:16:31    82.00   tmladen77  
  4   asnkiis      83.00   05-Feb  21:54:55    83.00   asnkiis    
  5   pboombatz    90.00   05-Feb  23:10:18    84.00   pboombatz  
  6   love-candl   86.00   06-Feb  03:05:38    87.00   pboombatz  
  7   love-candl   90.00   06-Feb  03:07:59    90.00   pboombatz  
  8   love-candl  100.00   06-Feb  03:09:54    91.00   love-candl 
  9   love-candl  103.00   06-Feb  03:10:55    91.00   love-candl 
 10   love-candl *105.00   06-Feb  03:12:41    91.00   love-candl 
 11   francruz     95.11   06-Feb  05:40:02    96.11   love-candl 
 12   todnich     100.00   06-Feb  05:40:29   102.50   love-candl 
 13   todnich     105.00   06-Feb  05:40:55   105.00   love-candl 
        End                06-Feb  05:41:23