View previous topic :: View next topic |
Author |
Message |
supersub15
Joined: 21 Sep 2006 Posts: 81
|
Posted: Tue Aug 07, 2007 10:03 am Post subject: Is there a formula to qualify players? |
|
|
I am building a personal database and was sorting players for different categories, and I ran into this issue: If I sort for example for 3-pt shooting, I get players like Dajuan Wagner, Elton Brand, etc. at the top with 100%, but only 1 attempt. I need to weed out all the non-qualified players when sorting. So far, my field query looks like this:
3FG%: [3P]/IIf(Nz([3PA],0)=0,1,[3PA])
What is the formula to qualify players for a certain category? |
|
Back to top |
|
|
Eli W
Joined: 01 Feb 2005 Posts: 286
|
|
Back to top |
|
|
supersub15
Joined: 21 Sep 2006 Posts: 81
|
Posted: Tue Aug 07, 2007 10:41 am Post subject: |
|
|
Thanks for the link, but something is not right. For example, at game 41 of the season, a player needs to have a minimum of 400 rebounds to be listed among the league leader. That's an average of around 10 rebounds per game!!! That list will look mighty tiny.
Am I missing something? |
|
Back to top |
|
|
kjb
Joined: 03 Jan 2005 Posts: 665 Location: Washington, DC
|
Posted: Tue Aug 07, 2007 11:06 am Post subject: |
|
|
supersub15 wrote: |
Thanks for the link, but something is not right. For example, at game 41 of the season, a player needs to have a minimum of 400 rebounds to be listed among the league leader. That's an average of around 10 rebounds per game!!! That list will look mighty tiny.
Am I missing something? |
You're missing the word "or." To qualify for league leaders 41 games into the season, the player must have appeared in 35 games OR have collected 400 total rebounds. _________________ My blog |
|
Back to top |
|
|
jkubatko
Joined: 05 Jan 2005 Posts: 508 Location: Columbus, OH
|
Posted: Tue Aug 07, 2007 11:07 am Post subject: |
|
|
supersub15 wrote: |
Thanks for the link, but something is not right. For example, at game 41 of the season, a player needs to have a minimum of 400 rebounds to be listed among the league leader. That's an average of around 10 rebounds per game!!! That list will look mighty tiny.
Am I missing something? |
Most of the per game leader minimums are either/or cases. For example, to qualify for the rebounds per game leader board a player needs to have played in at least 70 games *or* grabbed at least 800 rebounds. Using your example above, at game 41 of the season a player would need at least 35 games played or 400 rebounds to qualify for the leader board. _________________ Regards,
Justin Kubatko
Basketball Stats! |
|
Back to top |
|
|
DLew
Joined: 13 Nov 2006 Posts: 57
|
Posted: Tue Aug 07, 2007 11:13 am Post subject: |
|
|
With three point shooting I like to treat anyone who took less than .5 threes per 40 as having a 3% of 0. This is unscientific, but it weeds out the guys who shoot 3s from those who don't. |
|
Back to top |
|
|
gabefarkas
Joined: 31 Dec 2004 Posts: 879 Location: Durham, NC
|
Posted: Tue Aug 07, 2007 2:03 pm Post subject: |
|
|
supersub15 wrote: |
Thanks for the link, but something is not right. For example, at game 41 of the season, a player needs to have a minimum of 400 rebounds to be listed among the league leader. That's an average of around 10 rebounds per game!!! That list will look mighty tiny.
Am I missing something? |
Possibly, yes. I think you're underrating how many players achieve that milestone. At the end of the year, the leaderboard for total rebounds looked like:
Dwight Howard 1008
Kevin Garnett 975
Tyson Chandler 904
Carlos Boozer 867
Tim Duncan 845
Ben Wallace 821
Marcus Camby 816
Amare Stoudemire 786
Shawn Marion 785
Andris Biedrins 762
Assuming you need 800 rebounds (total) to qualify, a healthy 7 players are in the running. Garnett actually won, averaging 12.8 rebounds per game. That makes sense to me. Otherwise, a guy could average (hypothetically) 14 per game for 55 games, for a total of 770 rebounds and be eligible to win the rebounding crown, despite only playing two-thirds of the season. |
|
Back to top |
|
|
|