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

Excel Spreadsheet for Calculating Nassaus, Skins and other Games


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

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

    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 78 - 2026-03-10 Backswing work at the net with foam balls, a few real ball swings.
    • Day 525 - 2026-03-10 Got some work in before lessons today (was going to play after but it decided to POUR). Then like three minutes in later on.
    • Day 2 (10 Mar 26) - Worked on weight shift feel using slap stick drill (hands about 6” apart - coming back weight on trail foot - down - thru weight on lead foot….moved it to hitting chips w/9i playing what I call “leap frog” - hit 1st about 10yds, the next a couple past the 1st, for about 6 balls total.  Love it as the lies change, the distances vary making each swing slightly different. 
    • The first post is here:   Do you have an overly long backswing that ruins sequencing and leads to poor shots? In nearly 20 years of teaching, I've found 5 common faults. You don't have to swing like Jon Rahm, but a shorter swing will probably help you #PlayBetter golf. Which is your fatal flaw? #1 - Trail Elbow Bend Average golfers ♥️ bending their trail elbows. It can feel powerful! Tour players bend their trail elbows MUCH less. A wider trail elbow creates a longer hand path and preserves structure. It also forces more chest turn; not everything longer is bad! Overly bending your trail elbow can wreak havoc on your swing. It pulls your arms across/beside your body. It requires more time to get the elbow bend "out," ruining your sequencing. The lead arm often bends and low point control is destroyed. The misconception is that it will create more speed, but that's often the opposite of what happens. Golfers often feel they swing "easier" but FASTER with wider trail elbows. Want to play better golf with a shorter backswing? Don't bend your elbow so much. #2 - Hip (Pelvis) Turn I see this all the time: a golfer's hips are only 5-10° open at impact, but he turns them back 60°+ in the backswing. Unless your father is The Flash, your hips are probably not getting 40° open at impact from there! That's more rotation than Rory! Golfers who over-rotate their pelvis often over-turn everything - trail thigh/knee, chest/shoulders, etc. They have more work to do in the same ~0.3 seconds as a Tour player who turns back ~40° and turns through to impact 40° or so. Want to shorten the pelvis turn a bit? Learn to internally rotate into the trail hip, externally rotate away from the lead hip, and do "less" with your knees (extending and flexing) in the backswing. Learn some separation between chest and pelvis. #3 - Rolled Inside and Lifted Up Amateurs love to send the club (and their arms) around them. You see the red golfer here all the time at your local range. The problem? Your arms mostly take the club UP, not around. Going around creates no height until you have to hoist the club up in the air because you're halfway through your backswing and the club is waist high and three feet behind your butt! 😄  Learn to use your arms properly. Arms = up/down, body = around. Most golfers learn how little their arms really have to do in the backswing. The picture here is all you've gotta do (but maybe with a properly sized club!). #4 - Wide Takeaway Width is good, no? Yes, if you're wide at the right time and in the right spots. Golfers seeking width often don't hinge the club much early in the backswing… forcing them to hinge it late. Hinging the club late puts a lot of momentum into the club, wrists, and elbow just before we need to make a hairpin turn in transition and go the other direction at the start of the downswing. When you're driving into a hairpin curve, you go into it slowly and accelerate out of it. Waiting to hinge is like coasting down the straightaway and accelerating into the hairpin. Your car ends up off the road, and your golf ball off the course. Give hinging at a faster rate (earlier) then coasting to the top a try. You'll be able to accelerate out of the hairpin without the momentum of the arms and club pulling in the wrong direction.   #5 - Sway and Tilt Some sway is good but sometimes I see a golfer who just… keeps… swaying… Their chest leans forward a bit for balance, resulting in a whole lotta lean. The green line below is the GEARS "virtual spine." Pros sway a bit, but stay ~90°. This sway often combines with the extra pelvis turn because this golfer is not putting ANY limits on what the "middle of them" (their pelvis) is doing in the backswing. These golfers spend a lot of energy just to get back to neutral! The best players begin pushing forward EARLY in the backswing. Often before the club gets much past their trail foot! Pushing forward (softly) first stops your backward sway and then begins to get your body moving toward the target. Push softly, but early!  
    • I  no longer spend the time and effort trying to sell something I no longer need. Instead, if the clubs are in good condition, I go to my local golf shop or even Dicks Sporting Goods. Trade the clubs in for store credit and pick up something I need, like a hat. Cause you always need another golf hat!
×
×
  • 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.