DPChallenge: A Digital Photography Contest You are not logged in. (log in or register
 

DPChallenge Forums >> The DPL >> Query into DPL team scoring
Pages:  
Showing posts 26 - 38 of 38, (reverse)
AuthorThread
05/30/2007 12:44:34 AM · #26
I just did a quick check and our team score is correct.
6.4888
05/30/2007 12:45:44 AM · #27
Originally posted by langdon:

Fixes pending. A checked a small handful of team's scores earlier today with the calculation method and they were OK, but clearly a few are off.

We don't call it beta for nothin'!

Thanks for the quick response.
05/30/2007 12:46:01 AM · #28
Originally posted by TechnoShroom:

Originally posted by lesgainous:

Not to be picky, but you never know, 0.0001 could make a difference between winning and losing...

Our team's average comes to 6.32715. The official scoreboard shows 6.3271. Shouldn't it be rounded up to 6.3272?


Was it 6.32715 even or 6.32714xxxxx?

I put all our scores into Excel and the top 4 scores' average came to exactly 6.32715, so I'm thinking the DPC rounding algorithm needs to be tweaked.

.

Message edited by author 2007-05-30 00:46:21.
05/30/2007 12:48:57 AM · #29
It looks like it is taking the top 4 scores, regardless or not if 2 of the scores are from the same person because our team is correct, but our top 4 came from different people.
05/30/2007 12:50:37 AM · #30
Originally posted by kellyrc01:

It looks like it is taking the top 4 scores, regardless or not if 2 of the scores are from the same person because our team is correct, but our top 4 came from different people.


Some teams the average is higher than the top score.
05/30/2007 12:51:46 AM · #31
Ah, there goes my theory :)
05/30/2007 12:55:02 AM · #32
Originally posted by swhiddon:

I just did a quick check and our team score is correct.
6.4888

Did a quick check of team Dodge&Burn (whom we played.) They're score is close. It just did not round off to 4 decimal places.
DPL shows 6.3271 but they have a score of 6.32715 = 6.3272. Off by .0001

Message edited by author 2007-05-30 00:56:08.
05/30/2007 01:02:33 AM · #33
Resolved, yes?

It was a silly bug where I was including players that were actually removed teams during sign-ups. Click Click Boom was benefiting from someone's 7.0 :).
05/30/2007 01:12:03 AM · #34
Thanks langdon for the quick bug fix.

Is the rounding a bug or anomoly? Should it be resolved?

.

05/30/2007 01:13:40 AM · #35
Originally posted by langdon:

Resolved, yes?

It was a silly bug where I was including players that were actually removed teams during sign-ups. Click Click Boom was benefiting from someone's 7.0 :).

Thanks Langdon for the quick resolution. We too must have benefitted from someones score...
Regardless to say; Yes! UnevenOdds Rule
05/30/2007 01:17:28 AM · #36
PHEW! That was a close one. Great job Langdon on the super fast fix! You know we're all retarded excited here about the league. Just wanna know we won, ya know?
05/30/2007 01:20:32 AM · #37
Originally posted by lesgainous:

Thanks langdon for the quick bug fix.

Is the rounding a bug or anomoly? Should it be resolved?


It could be a bug, what's the general feeling? I'm currently relying on MySQL's AVG() function, which I gather is rounding "0.15" down to "0.10" -- Edit, yea: "The behavior of ROUND() when the argument is halfway between two integers depends on the C library implementation. Different implementations round to the nearest even number, always up, always down, or always toward zero."

Originally posted by Rooster:

PHEW! That was a close one. Great job Langdon on the super fast fix! You know we're all retarded excited here about the league. Just wanna know we won, ya know?


Haha, congrats, ETH lost. =[

Message edited by author 2007-05-30 01:29:56.
05/30/2007 01:29:24 AM · #38
Originally posted by langdon:

Originally posted by lesgainous:

Thanks langdon for the quick bug fix.

Is the rounding a bug or anomoly? Should it be resolved?


It could be a bug, what's the general feeling? I'm currently relying on MySQL's AVG() function, which I gather is rounding "0.15" down to "0.10". Edit: maybe it's trimming instead of rounding. ;)


Check out this definition of rounding on Wikipedia. Specifically, look at the algorithm for the "Round-to-even" method, also known as "Banker's Rounding"...

1- Decide which is the last digit to keep.

2- Increase it by 1 if the next digit is 6 or more, or a 5 followed by one or more non-zero digits.

3- Leave it the same if the next digit is 4 or less

4- Otherwise, all that follows the last digit is a 5 and possibly trailing zeroes; then change the last digit to the nearest even digit. That is, increase the rounded digit if it is currently odd; leave it if it is already even.

.

Message edited by author 2007-05-30 01:34:34.
Pages:  
Current Server Time: 08/17/2025 02:16:28 PM

Please log in or register to post to the forums.


Home - Challenges - Community - League - Photos - Cameras - Lenses - Learn - Help - Terms of Use - Privacy - Top ^
DPChallenge, and website content and design, Copyright © 2001-2025 Challenging Technologies, LLC.
All digital photo copyrights belong to the photographers and may not be used without permission.
Current Server Time: 08/17/2025 02:16:28 PM EDT.