Community
2007 HNI 5-Spot League Questions, comments, concerns, and trash-talk about the 2007 5-Spot league go here!

Participants and Handicap Update

Thread Tools
 
Old 01-15-2007, 09:27 PM
  #1  
Nontypical Buck
Thread Starter
 
Rick James's Avatar
 
Join Date: May 2004
Location: Albany, NY
Posts: 4,679
Default Participants and Handicap Update

Here you go. Everyone that turned in 2x scores for me to average and the handicap they will have for the 8 weeks of league.


Rick James is offline  
Old 01-15-2007, 09:35 PM
  #2  
Nontypical Buck
 
Oneshot7's Avatar
 
Join Date: Jan 2006
Location: Wilmington NC
Posts: 4,919
Default RE: Participants and Handicap Update

nice work rick
Oneshot7 is offline  
Old 01-15-2007, 10:58 PM
  #3  
 
Washington Hunter's Avatar
 
Join Date: Feb 2003
Location:
Posts: 6,006
Default RE: Participants and Handicap Update

Nooo, Mobow is ahead of me. [:'(]

Nice job Matt. BTW, I received my targets today, thanks!
Washington Hunter is offline  
Old 01-15-2007, 11:37 PM
  #4  
Nontypical Buck
 
GooseHunter Jr.'s Avatar
 
Join Date: Jun 2004
Location: Colorado
Posts: 1,378
Default RE: Participants and Handicap Update

Very nice tracking spreadsheet you got there.....nice job!
GooseHunter Jr. is offline  
Old 01-16-2007, 06:13 AM
  #5  
Nontypical Buck
 
RIStrutStopper's Avatar
 
Join Date: Apr 2003
Location: RI
Posts: 3,073
Default RE: Participants and Handicap Update

Very nice, Rick. If that's Excel, you can use the ROUND function to round the handicap to the next higher or lower integer depending on ifthe decimal ishigher or lower than .5 if you want to.
RIStrutStopper is offline  
Old 01-16-2007, 06:40 AM
  #6  
Nontypical Buck
 
Join Date: Sep 2005
Location: Indiana
Posts: 1,131
Default RE: Participants and Handicap Update

VERY NICE!! Will the handicaps be updated each week?
Primitive Weapon is offline  
Old 01-16-2007, 07:01 AM
  #7  
Nontypical Buck
 
HuntingEd's Avatar
 
Join Date: Jul 2005
Location: Eastern Shore MD
Posts: 2,487
Default RE: Participants and Handicap Update

is it possible to get a score higher than 300 w/ a handicap?

HuntingEd is offline  
Old 01-16-2007, 07:12 AM
  #8  
Nontypical Buck
Thread Starter
 
Rick James's Avatar
 
Join Date: May 2004
Location: Albany, NY
Posts: 4,679
Default RE: Participants and Handicap Update

ORIGINAL: Primitive Weapon

VERY NICE!! Will the handicaps be updated each week?
I will make a post every week with a screen shot of this spreadsheet and it will be updated with every persons weekly score, weekly X count, total overall score for the league, and total X count for the league.
Rick James is offline  
Old 01-16-2007, 07:13 AM
  #9  
Nontypical Buck
Thread Starter
 
Rick James's Avatar
 
Join Date: May 2004
Location: Albany, NY
Posts: 4,679
Default RE: Participants and Handicap Update

ORIGINAL: HuntingEd

is it possible to get a score higher than 300 w/ a handicap?
No, it is not possible to score higher than 300, 300 is perfect. If anyone happens to tie at 300, it will come down to overall X count to break the tie.
Rick James is offline  
Old 01-16-2007, 07:22 AM
  #10  
Nontypical Buck
 
HuntingEd's Avatar
 
Join Date: Jul 2005
Location: Eastern Shore MD
Posts: 2,487
Default RE: Participants and Handicap Update

I dont know if you've done this already but you can put a formula like this and it will not allow the score to go over 300:

=IF((D6+E6)<300,(D6+E6),300)

*The cells that were added together will change based on your spreadsheet
HuntingEd is offline  


Quick Reply: Participants and Handicap Update


Contact Us - Manage Preferences - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service -

Copyright © 2024 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.