Jump to content
Check out the Spin Axis Podcast! ×
IGNORED

Excel Spreadsheet for Calculating Nassaus, Skins and other Games


Note: This thread is 1952 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

Posted
Does anyone know if such a spreadsheet is out there? I am sure someone has created one. I'd be happy to pay for it if it is generally what I'm looking for. Thanks!

Posted
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.


Posted
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.

Posted

@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 !!!

Awards, Achievements, and Accolades

  • 4 weeks later...
Posted

@Eagle480

I have several with various games.

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

Club Rat

I tried to pm you but it said I failed.  I'm sure because I am new.  can you pm me?


  • 8 months later...
Posted

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.


Posted

This looks cool.  Only skins and stroke play for the free version.  Otherwise $15/year for the other games and other features.  That's pricey for an app.

 

Awards, Achievements, and Accolades

  • 3 years later...
Posted

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. 

 


  • 1 year later...
Posted

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


Note: This thread is 1952 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

    Carl's Place
    PlayBetter
    Golfer's Journal
    ShotScope
    The Stack System
    FitForGolf
    FlightScope Mevo

    Coupon Codes (save 10-20%): "IACAS" for Mevo/Stack/FitForGolf, "IACASPLUS" for Mevo+/Pro Package, and "THESANDTRAP" for ShotScope. 15% off TourStriker (no code).
  • Posts

    • Day 610 - 2026-06-03 Got some work in between lessons today. Rare late day, teaching until 7:30pm.
    • Let's continue on… Cool. The thing is, nobody's claiming par is "reliable" and par's inclusion piggy-backs in the course rating, which is awfully close to par and, thus, brings par in to make it make sense. Once again, for those in the back… (CR - Par) just makes it really easy to know what kind of score you need to shoot to best, match, or play worse than your handicap index. Yes, when par is different, the players from the higher par tees get an extra stroke (72 vs. 71, the 72s get an extra stroke. That makes sense and is a small complication (more info at https://www.usga.org/content/usga/home-page/handicapping/roh/Content/rules/Committee%20Content/USGA/LG_R6d.htm). However, most of the time, this adjustment will not be needed, as many courses play to the same par for the same genders from all sets of tees. And, the rare times it is needed, par (measured in whole numbers, integers) and strokes (also whole numbers/integers) map easily and the idea is easily grasped. Dean seems to be unaware of the fact that most every golfer carries something orders of magnitude more powerful than the highest end desktop computers available the last time he consulted with the USGA in their pockets. While it is quaint that his club puts printouts by the first tee… get with the times, Dean. Look up your handicap index and course handicap in the GHIN app and get on with it. It's a better system than the one that didn't account — at all — for a difference in the playing conditions (via an algorithm, not a judgment). Dean's assertions about the "less precise system because of par" continues to make absolutely zero sense. Right, it still changed tee to tee. Now it just changes differently… and in a way that more accurately reflects the score you need to shoot to play to your handicap. Previously, a 1.1 index would get 1 stroke on a 66.7/122 par-72 course. Now they give four strokes back to the course and must shoot 68 to play to their handicap. This makes way more sense. The 18-shot difference is a pretty extreme example. Maybe a long course that also offers a par-three set of tees could play that long, but… man, that's not going to be super common. Sensationalistic much, Dean? Also, once those unhappy (complete assumption) golfers realize a) what the change shows them (playing to net par = playing to your index) and b) realizes that their differential is going to be the same… I think they'll get over their initial questions. No. And yet… if he shoots the same scores, he'll get the same handicap index he has now. But he'll know on each course what score he needs to shoot to "play to his handicap." Sheesh, Dean. This stuff isn't that hard to figure out. Enough with the sensationalistic stuff. I don't find it "unacceptable" at all. Then again, I'm not nearly 80 and seemingly incapable of doing basic math these days. No. This literally makes no sense, as that part of the differential calculation and the course handicap calculation remains identical. Good! No. Categorically wrong. They should have been adjusting their handicaps all along. Previously it was by subtracting the course ratings. Which… is still basically what's done, with the addition of the course rating being "baked in" to the course handicap calculation. Dean is wrong here, or doing some math heretofore unknown by the world. When par is the same, what determines the difference in handicaps? The course rating, which Dean loves! Sheesh! You had to things when players were in situations like this before, too. This is getting exhausting. He keeps using words like "less precise" and "unfair" but does not seem to understand what they mean. This is like the Princess Bride meme: "you keep using that word. I do not think it means what you think it means." The caps reduce upward movement. Committees have reign to reduce a player's handicap, and there's still an automatic Exceptional Score Reduction. I'm going through these more quickly now because… well, it's silly how badly Dean misses the mark with this blog post. Dean is literally confusing the upward movement (with the soft and hard caps) here with the exceptional score reduction which is used when lowering handicaps due to an exceptionally good score. The creators of the WHS are handicap experts. They know more about the current state of handicaps/handicapping than the Pope Emeritus. It's been shown to have almost no effect across all handicaps. Yes, some 36s under the old system are now 35s under the new system. Yawn. He should have stopped there. It's easier to apply and makes more sense. This makes no sense. It's "not complex" but players will have to guess? And, for men or women, the stroke index of each hole doesn't change because they play a different set of tees. They get a different number of strokes, but it's always been true that when you get 14 strokes you apply a stroke to stroke index holes 1-14, and when you get 11, to just holes with a SI of 1-11. Objection, your honor. Assumes facts not in evidence. Dean's just out here continuing to make shit up about "the inaccuracy of par" and ignoring that with Par (an integer) came the Course Rating, which he agrees is precise and accurate. No. No, this is inaccurate. Also, as noted, you can randomly assign stroke indexes, and so long as all the low numbers or all the high numbers are not clumped together at the beginning or ends of the 18 holes, matches generally work out the same. This is inaccurate. It is an algorithm that looks at scores. That's it. Also, this is better than a system like the prior one where no such thing existed at all. Wildly inaccurate and off-base. Did they do actual testing? No need. They have millions and millions of rounds and ran many, many, many simulations. That's testing. Dean seems to continue to be unaware of the fact that computers are more powerful now than they were in 2002. But, he's nearly 80, so we can understand if not going so far as to give him a pass on how much he gets wrong. Cool. Noted. For the most part that was because many countries haven't been able to rate enough of their courses. :sigh:
    • Day 3 (3 Jun 26) - More work on keeping arms connected today - hard foam balls with 7i and 5w…..
    • Day 274 6-3 flow drill getting chest through, arms in front. Arms get a little pinned to the side, not as much in front as I want them when I add speed. 
    • Shot 48 yesterday.  For me bogey golf is good.  I was 10 over through 7 and figured with a Par 3 and 4 coming on all I needed was birdie / par to get my 45. I had a great tee shot on #8 and sunk  a 5 footer for birdie, game was coming together, now just needed par on #9. Had a great tee drive and the green was within range for a hoped GIR or nGIR.  But I pulled the shot left into tall weeds and needed to take a drop.  So much for par, but a bogey for 46 is still good for me. I hit my lob wedge to get over a small tree and saw the ball riding nicely  on line to the pin when my club hit the ball a 2nd time on my follow through causing the ball to change directions and ended up @ pin high but along the same tall weeds I just took an unplayable out of.  had no room for a backswing, Just hacked at it and it shot across the green to the rough on the far side.  Needed a chip & 1 putt got a triple bogey. you can see the hole fall apart in the screenshot below.  
×
×
  • 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.