Excel Spreadsheet - PGA Fedex Cup tracking

I

inborntarmac

New Member
Joined
May 26, 2024
Messages
1
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Hello - I've been asked to create an excel spreadsheet to track our local 'FEDEX' Cup like competition. Our local club "Cup" is a season long points race that mirrors the FedEx Cup on the PGA TOUR! Throughout the season, players will accrue points based on participation and how they place in both net and gross categories in Club-run tournaments throughout the year. If a player finishes in the top in both Net and Gross categories in a tournament, they will be given point value that is the highest, not both. Tournaments that have multiple divisions will have their own point distribution in each division. If there is a tie, points will be averaged and evenly distributed to the tied teams. The top sixteen men and top eight women will compete in a special season ending tournament held the weekend after our Closing Day Tournament. There will be an overall ladies champion and an overall men’s champion. After the grand finale tournament, we will crown our Cedar Point Cup Champions! The current standings will be available on the Club website under the Tournament Results tab. Member Guest/Member Member points for 50% of flight. There needs to be a male and female tracking sheet.

I'm praying there's a worksheet out there that all I have to put in is individual names, event names, whether a person participated and/or placed. Does anyone have any thoughts on this ? I have limited Excel skills, but know my way around a bit and am a quick study.

Thank you in advance !!
Best Regards to all - Mike

1st - there are point values for each event (i.e. Male / Female / Both) along with Individual and Team points
2nd - there are a number of tournaments throughout the year

point values for each event (i.e. Male / Female / Both) along with Individual and Team points
PlaceIndividual PointsTeam Points
1st10080
2nd9070
3rd8060
4th7050
5th6040
6th5030
Participated1010
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
Sort by date Sort by votes
@inborntarmac
Mike, I hope I'm wrong but I very much doubt that your prayers will be answered.
The likelihood is that you will need to be creating something from scratch. Which is unlikely to be a quick and simple process.
How might you go about it will depend upon a variety of considerations.
Sounds like there are a good number of qualifying events of several different types with varying points structure.
I think how you gather / store the data will be key.
Potentially a lot of manual data entry if all participants need to be logged.
I assume that you have an existing scoring system that will be used regardless?
If so, does it have the facility for you to export the result in a form that can be imported to Excel?
Then on some basis or other, separate columns on same sheet per event or even separate sheets per event you could have the appropriate Excel logic to apportion points for that event.
And so on..
Analysing and summarising the data should be easy enough.
I think I would be trying to establish a viable way of data capture / input for a simple event or two and take it from there.
Additional events of varying types can then be added progressively.

HTH
 
Upvote 0
You must log in or register to reply here.

Similar threads

G
  • Question
PGA Tour Excel Spreadsheet with money list and FedEx Cup
Replies
4
Views
5K
GoBraves21
G
E
  • Question
League Stats Workbook
Replies
0
Views
477
eslusk
E

Forum statistics

Threads
1,216,499
Messages
6,131,012
Members
449,613
Latest member
MedDash99

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top