Data Table Practice!

....playing with spreadsheets! Puppy will soon get out that dead horse award for me!

Latest version:

 BID	=================		==BID===	=======================	WINNING	WINNING
=#=	=====BIDDER======		=AMOUNT=	=====BID DATE&TIME=====	==BID==	=BIDDER
9	paddockwray( 21)		191	Jan-11-04 13:28:29 PST	196	stefan
8	stefan0n( 4 )	*	196	Jan-11-04 13:28:20 PST	181	stefan
7	paddockwray( 21)		176	Jan-08-04 15:01:19 PST	122	paddoc
6	paddockwray( 21)		131	Jan-08-04 10:11:19 PST	122	paddoc
5	paddockwray( 21)		101	Jan-08-04 10:11:05 PST	102	tixure
4	paddockwray( 21)		91	Jan-08-04 10:10:50 PST	92	tixure
3	dgmottram( 3 )		50	Jan-08-04 09:52:51 PST	51	tixure
2	tixure_usa( 1 )		120	Jan-07-04 09:46:15 PST	1.2	tixure
1	devisu( 57)		1	Jan-07-04 09:16:47 PST	1	devisu
						
		*	WINNING BID - Actual MAX bid unknown.			
 

Jabbergah                                                    

Changing my numeric fields to text with right just. did not fix the left justifying.

Jabbergah                                                    

I'm going to see what I can do with Lotus.

Be outa touch.

Might the analysis understanding be improved if the data was presented this way?:

 
BID	=================		==BID===	=======================	WINNING	WINNING
=#=	=====BIDDER======		=AMOUNT=	=====BID DATE&TIME=====	==BID==	=BIDDER
1	devisu( 57)		1.00	Jan-07-04 09:16:47 PST	1.00	devisu
2	tixure_usa( 1 )		120.00	Jan-07-04 09:46:15 PST	1.20	tixure
3	dgmottram( 3 )		50.00	Jan-08-04 09:52:51 PST	51.00	tixure
4	paddockwray( 21)		91.00	Jan-08-04 10:10:50 PST	92.00	tixure
5	paddockwray( 21)		101.00	Jan-08-04 10:11:05 PST	102.00	tixure
6	paddockwray( 21)		131.00	Jan-08-04 10:11:19 PST	122.00	paddoc
7	paddockwray( 21)		176.00	Jan-08-04 15:01:19 PST	122.00	paddoc
8	stefan0n( 4 )	*	196.00	Jan-11-04 13:28:20 PST	181.00	stefan
9	paddockwray( 21)		191.00	Jan-11-04 13:28:29 PST	196.00	stefan
						
		*	WINNING BID - Actual MAX bid unknown.			
 

Jabbergah                                                    

Found these on a really neat German site. ( sorry to interrupt your thread,jabber, but I wanted you to see the cannon!)



[This message was edited by Mrs.M on January 12, 2004 at 04:59 PM.]

[This message was edited by Mrs.M on January 12, 2004 at 05:00 PM.]

And thanks for the Dog !

Can anyone point me to the bid increments for EUO?

Harder to find things on eBay when you don't speak the language !

Morinig Jabber

I've made some REAL progress with Lotus and macros. I've still got some tweeking to do for really strange bidding patterns, but its ready for a test.

Give me an auction, and check my math.
(limit for now is 24 bids)

Hi Puppy!

You could pull in the stefan auction we've been playing with. Or you could wait until the next "why did I lose this auction" post.

Maybe I'll go rummage around in my closed watched auctions and see if there is anything interesting.

Jabbergah                                                    

How would your spreadsheet handle THIS auction: 2452163349? It's a PRIVATE auction! I've never analyzed one of them!

Jabbergah                                                    

Puppy,

This auction is interesting. It only has about 12 bids, but about half of those happened in the last minute!

3069658898

Sorry, no live link -- cut & paste.

Jabbergah                                                    

Jabber !
That last auction was a bugger (as in debugging)

It had a bidder raise his own high bid and also had a tie at one point. (hadn't thought of that). Think I got all the kinks work out. Someone check my results. Here's what I got. All automated. >> Here << is the bidding on eBay.

 
bid                                            current winning
 #    Bidder          Bid      Day & Time      price & Bidder
    
 1   hitek598        30.00   05-Jan  03:58:32   29.99   hitek598
 2   speedybear516   31.00   10-Jan  20:13:14   31.00   speedybear516
 3   siberian        35.00   11-Jan  13:12:00   32.00   siberian
 4   siberian        40.00   11-Jan  13:14:22   32.00   siberian
 5   wonvakyn        33.00   11-Jan  15:57:59   34.00   siberian
 6   wonvakyn        35.00   11-Jan  15:58:22   36.00   siberian
 7   tin926          38.00   11-Jan  15:58:50   39.00   siberian
 8   tin926          40.00   11-Jan  15:59:03   40.00   siberian
 9   jsunell         46.50   11-Jan  15:59:20   41.00   jsunell
10   tin926          42.00   11-Jan  15:59:26   43.00   jsunell
11   tin926          45.00   11-Jan  15:59:34   46.00   jsunell
12   tin926          47.50   11-Jan  15:59:46   47.50   tin926
 

Puppy,

First my congratulations on a VERY NICE bid analysis presentation! Looks much nicer than my final version.

Second, I'm glad I lucked into giving you such a good auction to shake out your macro! It was an auction I was watching anyway, and when I looked at all the bids that occurred in the last 3 minutes, it looked like a good candidate for you!

Things I like:
-"Reverse" listing i.e. first bid is at the TOP of the list instead of the bottom, like ebay bid histories. It is much more intuitive, I think. The only possible downside I can think of someone may not realize it right away and would be confused, but then that's why the chronological bid order number on the left!

-ID abbrev. -- how do you get your spreadsheet program to abbrev. so nice? I was just truncating the ID at an arbitrary character length (like 6 or 7). Very neatly done!

Picking nits!
I notice on this version, unlike your past versions, you didn't "*" the winning bid with a note that says the true MAX bid is unknown. (In this auction, my guess is tin's max bid is $48 based on tin's bidding pattern in this auction.) Just for another twist, does your program KNOW when the MAX bid IS known? -- when the winning bid ends up NOT being a full bid increment higher? (In which case your program SHOULD NOT "*" the winning bid w/*-note.

All in all -- MAJOR KUDOS TO PUPPY! NICE JOB!

Jabbergah                                                    

...I DID print out the bid history and slog thru it. You math & presentation appear to be correct.

Jabbergah                                                    

quote:

---

how do you get your spreadsheet program to abbrev. so nice?

---

That's something I'm still working on. It was the math that was the hard part.

Currently I search the string for a '(' and then back up one. I did have to manually do SOME things with the names. '@' and '_' have to be removed manually, and names longer than 15 chars have to be shortened by hand, but that should not be to much of a problem to fix.

quote:

---

I notice on this version, unlike your past versions, you didn't "*" the winning bid
Just for another twist, does your program KNOW when the MAX bid IS known?

---

That is a feature comming in the next release !

Puppy posted:

quote:

---

Currently I search the string for a '(' and then back up one. I did have to manually do SOME things with the names. '@' and '_' have to be removed manually, and names longer than 15 chars have to be shortened by hand, but that should not be to much of a problem to fix.

---

If-then-else?
If string length>15, truncate at 15
If string contain "@" or "_" characters, truncate including those characters, else truncate at "(" including that character.

"It's always better to kill hours & days figuring out how to program a task rather than taking the few moments it requires to do the task manually!" I think it's Geek Law #18, or something...

quote:

---

That is a feature comming in the next release !

---

"No matter how good your program works, you can always make it better, or do more!" Geek Law #89.

What bugs me is that I haven't figured out how to do in Excel, what you've done in Lotus!
"Applications will always work better when written in a different software." Geek Law #33

Jabbergah                                                    

quote:

---

Currently I search the string for a '(' and then back up one.

---

I mis-stated that. I search for ')' and include it!

quote:

---

If-then-else?
If string length>15, truncate at 15

---

I'm using Lotus, really REALLY different than Excel.

@LEFT(+B60,@FIND("(",+B60,0))&@REPEAT(" ",15-@LENGTH(@LEFT(+B60,@FIND("(",+B60,0))))

that takes the name out of the string and pads short names with spaces to make all short names 15 characters long. B60 is the original string.

Clear as mud ?



[This message was edited by Puppy Raiser on January 15, 2004 at 08:08 AM.]

Now if I stick another @left in there somewhere,
that should do it for names that are to long !

Puppy posted:

quote:

---

I'm using Lotus, really REALLY different than Excel.

---

I used to do stuff on Lotus, too -- but LONG ago!
I've forgotten much, and don't have it on my machine. Last time I used Lotus -- it was a DOS version!

quote:

---

that takes the name out of the string and pads short names with spaces to make all short names 15 characters long. B60 is the original string.

---

Do you need to pad with spaces so the columns work out in the forum when you cut & paste? D60?!? Thought you said you only handle 24 bids! How'd you get down to line 60? Work area?

OMG! I think there has been an outbreak of geekiness in this thread! The others will probably quarentine us!

Jabbergah                                                    

quote:

---

Now if I stick another @left in there somewhere

---

Isn't there some left substring function that you could do initially to truncate at a specific length?

Jabbergah                                                    

quote:

---

Do you need to pad with spaces so the columns work out in the forum

---

Yes

quote:

---

How'd you get down to line 60? Work area?

---

Yes again.

quote:

---

Isn't there some left substring function that you could do initially to truncate at a specific length?

---

Yes, it's the @left I mentioned!

quote:

---

The others will probably quarentine us!

---

Maybe we should go private....No....Probably to late for that.