columbus1845
New Member
- Joined
- Mar 25, 2010
- Messages
- 22
- Office Version
- 2019
- Platform
- Windows
Updateing my previous learning from this forum using Excel 2010...
I was able to use this forum's fantastic experts help a year or so ago and have been using that learning for a year now but found a need to automate the Skins Portion of my sheets..!
The way I run the skins is - we allow X $'s (e.g. - $40) for skins on any given day (May change by day - value always shown on the sheet called "Try Payouts")...
I keep a sheet for each days play (Try Setups) with the players names and scores, etc.
I also keep a daily sheet for each player to show how much $'s he has won (Try Payouts) for various catagories such as; closest to the pin, who won best points for front nine play, who won best points for back nine play and who won skins money for the day, plus total $'s won for each day.
PROBLEM:
I need to look hole-by-hole for all players daily scores and determine if a skin was won and by whom.
Next, knowing how many skins were won that day, divide that number into the value of the daily skins payout $'s.
Next, I need to go to my other sheet, find each winners name and enter his winnings into the cell for skins won... A player can win more than one skin per 18 holes played.
My spreadsheets are available at Box.net (If another way is available that is better - let me know)
File 1 - Description * = Eagle Office Tour Try Setups
http://www.box.net/files#/files/0/f/80600184/1/f_755970512
File 2 - Description * = Eagle Office Tour Try Payouts
http://www.box.net/files#/files/0/f/80600184/1/f_755970338
* = names may be reversed
If you look the sheets I created there may be tons of ways of doing things better but being a newbie to excel this is what I ended up with.!
Any help to update this problem would be appreciated...
Thanks in advance...
Brian from Windsor, On, Canada
I was able to use this forum's fantastic experts help a year or so ago and have been using that learning for a year now but found a need to automate the Skins Portion of my sheets..!
The way I run the skins is - we allow X $'s (e.g. - $40) for skins on any given day (May change by day - value always shown on the sheet called "Try Payouts")...
I keep a sheet for each days play (Try Setups) with the players names and scores, etc.
I also keep a daily sheet for each player to show how much $'s he has won (Try Payouts) for various catagories such as; closest to the pin, who won best points for front nine play, who won best points for back nine play and who won skins money for the day, plus total $'s won for each day.
PROBLEM:
I need to look hole-by-hole for all players daily scores and determine if a skin was won and by whom.
Next, knowing how many skins were won that day, divide that number into the value of the daily skins payout $'s.
Next, I need to go to my other sheet, find each winners name and enter his winnings into the cell for skins won... A player can win more than one skin per 18 holes played.
My spreadsheets are available at Box.net (If another way is available that is better - let me know)
File 1 - Description * = Eagle Office Tour Try Setups
http://www.box.net/files#/files/0/f/80600184/1/f_755970512
File 2 - Description * = Eagle Office Tour Try Payouts
http://www.box.net/files#/files/0/f/80600184/1/f_755970338
* = names may be reversed
If you look the sheets I created there may be tons of ways of doing things better but being a newbie to excel this is what I ended up with.!
Any help to update this problem would be appreciated...
Thanks in advance...
Brian from Windsor, On, Canada
Last edited:
