Skip to main content

113 replies

Data Table Practice!

J jabbergahMember
Didn't want to keep junking up the other topic! Frown

Tried something else...

 
.       .       .       .       WINNING WINNING
BIDDER  .       BID     DATE/TIME BID PLACED    BID     BIDDER
================= ============ ======================= ======= ========
paddockwray( 21)        GBP     191.00  Jan-11-04 13:28:29 PST  196.00  stefan
stefan0n( 4 )   GBP      *196.00        Jan-11-04 13:28:20 PST  181.00  stefan
paddockwray( 21)        GBP      176.00 Jan-08-04 15:01:19 PST  122.00  paddock
paddockwray( 21)        GBP      131.00 Jan-08-04 10:11:19 PST  122.00  paddock
paddockwray( 21)        GBP     101.00  Jan-08-04 10:11:05 PST  103.00  tixure
addockwray( 21) GBP     91.00   Jan-08-04 10:10:50 PST  92.00   tixure
dgmottram( 3 )  GBP     50.00   Jan-08-04 09:52:51 PST  51.00   tixure
tixure_usa( 1 ) GBP     120.00  Jan-07-04 09:46:15 PST  1.20    tixure  
devisu( 57)     GBP      1.00   Jan-07-04 09:16:47 PST  1.00    devisu

        * Winning bid = MAX bid MAY be HIGHER.


Jabbergah                                                    
Original Post

Replies sorted oldest to newest

J jabbergahMember
Another try:

 
.	.	.	.	.	.	.	.	WINNING	WINNING
BIDDER	.	.	BID		DATE/TIME BID PLACED	BID	BIDDER
================= 	============ 	===================== ======= ========
paddockwray( 21)	GBP 191.00	Jan-11-04 13:28:29 PST	196.00	stefan
stefan0n( 4 )		GBP *196.00	Jan-11-04 13:28:20 PST	181.00	stefan
paddockwray( 21)	GBP 176.00	Jan-08-04 15:01:19 PST	122.00	paddock
paddockwray( 21)	GBP 131.00	Jan-08-04 10:11:19 PST	122.00	paddock
paddockwray( 21)	GBP 101.00	Jan-08-04 10:11:05 PST	103.00	tixure
addockwray( 21)	GBP  91.00	Jan-08-04 10:10:50 PST	92.00	tixure
dgmottram( 3 )		GBP  50.00	Jan-08-04 09:52:51 PST	51.00	tixure
tixure_usa( 1 )	GBP 120.00	Jan-07-04 09:46:15 PST	1.20	tixure	
devisu( 57)		GBP   1.00	Jan-07-04 09:16:47 PST	1.00	devisu

	* Winning bid = MAX bid MAY be HIGHER.


Jabbergah                                                    
J jabbergahMember
...approach. Pasting EXCEL data into USB CODE:

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


Jabbergah                                                    
J jabbergahMember
================= ============ ======================= WINNING WINNING
=====BIDDER====== ====BID===== =====BID DATE/TIME===== ===BID== ===BID==
paddockwray( 21) GBP 191.00 Jan-11-04 13:28:29 PST 196.00 stefan
stefan0n( 4 ) GBP*196.00 Jan-11-04 13:28:20 PST 181.00 stefan
paddockwray( 21) GBP 176.00 Jan-08-04 15:01:19 PST 122.00 paddock
paddockwray( 21) GBP 131.00 Jan-08-04 10:11:19 PST 122.00 paddock
paddockwray( 21) GBP 101.00 Jan-08-04 10:11:05 PST 102.00 tixure
paddockwray( 21) GBP 91.00 Jan-08-04 10:10:50 PST 92.00 tixure
dgmottram( 3 ) GBP 50.00 Jan-08-04 09:52:51 PST 51.00 tixure
tixure_usa( 1 ) GBP 120.00 Jan-07-04 09:46:15 PST 1.20 tixure
devisu( 57) GBP 1.00 Jan-07-04 09:16:47 PST 1.00 devisu

*WINNING BID - Actual MAX bid unknown.

Jabbergah                                                    
J jabbergahMember
That last one doesn't count! Roll Eyes Forgot to use the CODE USB...

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


Jabbergah                                                    
J jabbergahMember
....but there is more space between columns than what I'm pasting in???.....

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


Jabbergah                                                    
J jabbergahMember
"Proxy bid" I think could lead to confusion. In my mind, it would seem "MAX" = "PROXY" bid. "Winning bid" seems a little more obvious?

Trying another version:

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


Jabbergah                                                    
J jabbergahMember
...PLAYING! Roll Eyes

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


Jabbergah                                                    
J jabbergahMember
...why I get spaces between "UNT" & "=AMOUNT" and also "DATE/TIME" & "WINNING BID"? There isn't that much space on my spreadsheet.

The Excel sheet could really allow quick bid analysis. Just copy & paste the bid history off ebay into the sheet, clean up the data fields, sort data on bid date/time, figure out the winning bids at each step, and repost to forum.
Ummm...now that I type out the steps, it really doesn't LOOK that quick, huh? Wink

Another try:

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


Jabbergah                                                    
J jabbergahMember
....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                                                    
J jabbergahMember
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                                                    
puppyraiserpuppyraiserMember
Jabber !
That last auction was a bugger (as in debugging) Smile

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


Last edited {1}
J jabbergahMember
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                                                    
puppyraiserpuppyraiserMember
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 !

J jabbergahMember
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!" Wink I think it's Geek Law #18, or something... Wink

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. Wink

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

Jabbergah                                                    
puppyraiserpuppyraiserMember
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 ? Big Grin



[This message was edited by Puppy Raiser on January 15, 2004 at 08:08 AM.]
Last edited {1}
J jabbergahMember
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! Eek

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? Confused Work area?

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

Jabbergah                                                    
puppyraiserpuppyraiserMember
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. Smile

Last edited {1}
Next

Add Reply

Post

Membership Required

We're sorry. You must be signed in to continue. Sign In or Register
×
Are you sure you want to remove from your Block List?
×
Loading...
×
When you block a person, they can no longer invite you to a private message or post to your profile wall. Replies and comments they make will be collapsed/hidden by default. Finally, you'll never receive email notifications about content they create or likes they designate for your content.
Note: if you proceed, you will no longer be following .
×
Link copied to your clipboard.
×