PDA

View Full Version : SOWS 17 Riverfront Results

JPSnuffy
January 24th, 2013, 05:59 PM
Sorry for the delay in posting these (I know some of you are getting a bit impatient :waaah:) but I was working on the formula for finding and adding only the Top 5 scores for each player on the Overall Standings spreadsheet. Who would have imagined that it would be so difficult to figure out...Well I know now.:yay:

- Overall Standings (https://skydrive.live.com/redir?page=view&resid=1C785754E82AF6A5!451&authkey=!ABHWEsRcCRQcpB4)

- Open Pro Men (https://skydrive.live.com/redir?page=view&resid=1C785754E82AF6A5!449&authkey=!AJuzW2DeGktkHIs)

- Pro Women (https://skydrive.live.com/redir?page=view&resid=1C785754E82AF6A5!457&authkey=!ABa_GOGGfdUc13E)

- Pro Masters (https://skydrive.live.com/redir?page=view&resid=1C785754E82AF6A5!455&authkey=!ADWrhfOJZUKQ8vA)

- Pro Grand Masters (https://skydrive.live.com/redir?page=view&resid=1C785754E82AF6A5!452&authkey=!ABFAe-RBfTewfJw)

- Adv. Men (https://skydrive.live.com/redir?page=view&resid=1C785754E82AF6A5!459&authkey=!AGw9S82PH4NrQSs)

- Adv. Women (https://skydrive.live.com/redir?page=view&resid=1C785754E82AF6A5!441&authkey=!AMOPqx2M-SY4RQ4)

- Am. Grand Masters (https://skydrive.live.com/redir?page=view&resid=1C785754E82AF6A5!443&authkey=!AEhApCFQyVxp2kI)

- Am. Men (https://skydrive.live.com/redir?page=view&resid=1C785754E82AF6A5!445&authkey=!AK78Ts7ToMkGMPw)

- Am. Women (https://skydrive.live.com/redir?page=view&resid=1C785754E82AF6A5!446&authkey=!AMqidUIfglnQm3M)

Enjoy!
Huk-DMC
January 25th, 2013, 12:29 AM
your awesome glenn!! I know how much work these can be. much props to you. I think the impatient one wasn't seeing the ones from last tourney either :o

I couldn't ever figure out a way to do a formula that would grab top 5 scores. just had to tell it each cell to add together (ie. D1, D3, D4, D7, D8). that took up sooooo much time for the last couple tourneys for all the people that qualify.
Im curious to know how you did it. so I can know for the future :)
JPSnuffy
January 25th, 2013, 04:18 PM
your awesome glenn!! I know how much work these can be. much props to you. I think the impatient one wasn't seeing the ones from last tourney either :o

I couldn't ever figure out a way to do a formula that would grab top 5 scores. just had to tell it each cell to add together (ie. D1, D3, D4, D7, D8). that took up sooooo much time for the last couple tourneys for all the people that qualify.
Im curious to know how you did it. so I can know for the future :)

Thanks Devon, your support is very much appreciated. I think I will be bringing my laptop to the next ADV/AM day to make things go smoother at the end of the day. If I had a volunteer from the PRO/Masters day they could do those scores and posting would go quicker, but I dont know if anyone as crazy as me would want to volunteer.:jumpspin:
southpaw
January 25th, 2013, 08:10 PM
Mad props to you both of you for the last two seasons .... Without people like you two behind the scenes with a love for the game and for friendly competition our winter series would be nothing .... And with that said , devon I'm bringin my A game to Tom pearce :) :)
scottycb1
January 25th, 2013, 10:21 PM
Devin, southpaw is coming for you, too bad im first in line, TP is the one course i have not won a sows event at, and I want it!
Huk-DMC
January 27th, 2013, 11:14 PM
I've got one at TP :) :trophy:
I will not be missing 20 footers :puke:
If I don't take it southpaw can.... represent WINCHESTER!
but seriously Discatchers and teepads, lets do it!