Excel Spreadsheet for Calculating Nassaus, Skins and other Games

[Eagle480]

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!

[danL]

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?

[Eagle480]

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.

[Club Rat]

@Eagle480

I have several with various games.

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

Club Rat

[cgellasch]

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

[jdhowe77]

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.

[No Mulligans]

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.

 

[Mike Vigh]

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. 

 

[TheGreatPrich]

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