Jump to content
IGNORED

Excel Spreadsheet for Calculating Nassaus, Skins and other Games


Eagle480
Note: This thread is 1155 days old. We appreciate that you found this thread instead of starting a new one, but if you plan to post here please make sure it's still relevant. If not, please start a new topic. Thank you!

Recommended Posts

I'm a programmer with too much time on my hands. :) What exactly are you looking for, something you can enter each holes score on and it will calculate how much money is owed by who?

I apologize for having a spam URL in my signature and will not do it again.

Link to comment
Share on other sites


That would be excellent but even if it gave results without who owes who would be good. For example in a Nassau game if a row or colum showed player 1 was +2/-1/+1 we could figure out who owes who very easily. Would be even better if we could include auto 2 downs. Or in a skins game player 1 won 3 skins, player 2 6 skins, player 3 7 skins and player 4 2 skins it would be easy to figure out who owes what. We play carry-overs and validations. Let me know what you think. Thanks, Troy.
Link to comment
Share on other sites


@Eagle480

I have several with various games.

Send me a pm, I'll discuss them with you.

Club Rat

Johnny Rocket - Let's Rock and Roll and play some golf !!!

Link to comment
Share on other sites

Awards, Achievements, and Accolades

  • 4 weeks later...
  • 8 months later...

Eagle480, did you ever find a spreadsheet or app?  I'm after the same thing.  I've tried some apps that now claim to calculate a nassau bet, but they are way too complicated.  I am searching for something simple where you enter the player/team net score vs. another player/team net score.  We play multiple balls usually on the team nassau and it takes a while to call a $2/$2/$2 bet.  Plus, after a couple of beers, we're not always trustworthy of the callers nassau calculation skills.  A simple app would help a bunch.

Link to comment
Share on other sites


  • 3 years later...

My brother and I have developed a few spreadsheets (excel) for some games at our club.

1.  You enter the golfer, their handicap, and their gross scores.  It calculates their total score per nine holes, per 18 holes, peterson points quota, skins (net skins, but a net cannot beat a gross skin (if an 18 handicap gets a 4 net 3 and a 5 handicap gets a gross 3, the gross three holds)).  It uses the number of golfers and a set amount per person (each person pays 25 matchsticks and it is split between the two pots).  It uses formulas to determine the person's handicap and where their strokes fall.  It ranges from a +4 handicap to a 18 handicap for skins and 22 handicap for peterson points quotas.

2.  You enter the golfer, their handicap, and their gross scores.  Then, it calculates 1/2 peterson points quota on the front nine, 1/2 peterson points quota on the back nine, and total peterson points quota for the entire round.  It also calculates gross and net skins (both get paid).  It uses a table on a different page to calculate the the total number of players and how many places paid (if you have 10 players, it pays three places; 16 players, pays four places; 25 players, pays 5 places, etc.  At 50 players, it pays out eight places) and figures for ties and equal splits of the pot.

3.  You enter the golfer, their handicap, and their gross scores.  If you have three or four man teams, they will be listed by alphabet and number in the far left column.  The worksheets calculate the net lowest score for the team on each hole (either counts two of the best or three of the best).  It can also be changed to count lowest gross ball too.  It calculates net skins, but a net cannot beat a gross skin.  

Each sheet has a normal match call bet application at the bottom.  You put the number next to the golfer's name in one block and their opponent's number next to their name in the second block and it tells you who wins and by how many (match bet) and closes the bet when there is no chance for the other person to catch (3 up with 2 to play).  

We are working on Nassau bets and Nassau bets with two down automatics. 

 

Link to comment
Share on other sites


  • 1 year later...

If there is a spreadsheet guru I would love a quick and dirty spreadsheet.    We play Golden Tee and have a wagering system.

 

3 total bets.  Total score against your handicap,  Then by blind draw you are put on a 2 man team or a team with the Wheel.  The final bet is a Great Shot points (player with the most collects all)https://docs.google.com/spreadsheets/d/e/2PACX-1vRC1MAefNcG_RAd1OdKWH5A2tEB3UMSnWxCa2OT23SNPMsF3Q_2LiZ5DPyrK5I7hK6auaL_uagmfhz2/pub?gid=0&single=true&output=csv

Link to comment
Share on other sites


Note: This thread is 1155 days old. We appreciate that you found this thread instead of starting a new one, but if you plan to post here please make sure it's still relevant. If not, please start a new topic. Thank you!

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


  • Want to join this community?

    We'd love to have you!

    Sign Up
  • TST Partners

    TourStriker PlaneMate
    Golfer's Journal
    ShotScope
    The Stack System
    FlightScope Mevo
    Direct: Mevo, Mevo+, and Pro Package.

    Coupon Codes (save 10-15%): "IACAS" for Mevo/Stack, "IACASPLUS" for Mevo+/Pro Package, and "THESANDTRAP" for ShotScope.
  • Popular Now

  • Posts

    • Day 85 - Played 9. Driver was solid, approach shots were pushed, chipping/pitching was better, putting was rough. 
    • Day 514, March 28, 2024 Quick ten minutes while waiting for the wife to come home for our trip.
    • Day 262: did a stack session. Worked on rehearsal swings during rest breaks. 
    • It's been a little more than a year since I can last remember hitting golf balls and today I just got my second cortisone injection in 11 months. I thought maybe shortly after the first injection I was going to be able to start playing again with therapy but the pain while doing my backswing past halfway just didn't subside like just lifting my hands up in the air did. So today the Orthopedic surgeon put more in the backside of the shoulder than before to address the tendon more. I'm going to try therapy for another 3 months and if I  can't swing the club without pain then I think surgery is going to be my next option.
    • I was just down visiting family in southern California and we played a couple rounds of golf. I hit my ball into the deep rough near some tree's and my cousin's husband offered me his Sim 2 Rescue Hybrid to try out. And I felt the same way, wow! I loved it, it also had a Pure DTX grip on it which I loved. As soon as I got back home, I ended up buying two used Calloway Rogue X hybrids, 3 and 5. So far I've only tested them out at the range, but I love them. They're much more forgiving than irons for me.
×
×
  • Create New...

Important Information

Welcome to TST! Signing up is free, and you'll see fewer ads and can talk with fellow golf enthusiasts! By using TST, you agree to our Terms of Use, our Privacy Policy, and our Guidelines.

The popup will be closed in 10 seconds...