+ Reply to Thread
Results 1 to 6 of 6

Golf League - problem in calculating values

  1. #1
    Registered User
    Join Date
    08-18-2015
    Location
    England
    MS-Off Ver
    Office 365 - Mac Business Premium
    Posts
    6

    Question Golf League - problem in calculating values

    Hi,

    This forum was really helpful last year when i set up the golf league and the automated calculations of number of players and best top 5 scores has saved me countless hours of work.

    I'm hoping someone can help with an issue I now have?

    In the attached you will see I have a spreadsheet that records the number of birdies scored by each player in each round. I would like to do two things:

    1. IF a score is entered in any week (columns), this means the player has played that week. I would like the Birdies Sheet to automatically assign a '0' value only against each player that has played that week (i.e. automatically assume no birdies have been scored by each player). I then manually enter the actual birdies for each player who has scored any that week. You will see that I have an auto calculation for the payouts for each player, depending on how many birdies they scored (10 pence payout per birdie). I have manually entered zeroes for those that played but didn't score birdies in the first week, but want this automated for all the following weeks
    2. I would like the Earnings worksheet to take the 'Birdies' sheet values and multiply the number of birdies for each player each week by the payout/earnings calculation for each week. For example, on 29th October, Player 9, shot 3 birdies and received a net payout of 6.60 (cell B93)

    I can then total the season winnings/losses per player

    Really appreciate anyones' help with this.

    Thanks
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    08-06-2013
    Location
    Detroit, Michigan
    MS-Off Ver
    Excel 2013
    Posts
    668

    Re: Golf League - problem in calculating values

    Try these formulas (made for Extra 1 Oct-9)
    Birdies!B73:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Earnings!B73:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    1. Include a sample workbook with an example of the result you want
    2. Use [CODE] and [FORMULA] wrappers for your VBA code or excel formulas
    3. If your question has been answered, mark the thread as SOLVED and click on the "Add Rep" star to thank whoever helped you.

  3. #3
    Registered User
    Join Date
    08-18-2015
    Location
    England
    MS-Off Ver
    Office 365 - Mac Business Premium
    Posts
    6

    Re: Golf League - problem in calculating values

    Thanks so much for this. WRT the earnings calculation, how would I modify the formula to only calculate a result if the player actually played that week (i.e. posted a score in the Golf Winter league Sheet)?

  4. #4
    Valued Forum Contributor
    Join Date
    08-06-2013
    Location
    Detroit, Michigan
    MS-Off Ver
    Excel 2013
    Posts
    668

    Re: Golf League - problem in calculating values

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    08-18-2015
    Location
    England
    MS-Off Ver
    Office 365 - Mac Business Premium
    Posts
    6

    Re: Golf League - problem in calculating values

    Quote Originally Posted by k64 View Post
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    That's just brilliant, thanks again!!

  6. #6
    Valued Forum Contributor
    Join Date
    08-06-2013
    Location
    Detroit, Michigan
    MS-Off Ver
    Excel 2013
    Posts
    668

    Re: Golf League - problem in calculating values

    No problem. Thanks for the +Rep. Glad I could help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Golf Eclectic League - help with Worksheet
    By Nobbie in forum Excel General
    Replies: 4
    Last Post: 08-25-2015, 06:40 AM
  2. Golf League Scheduling Analysis
    By matt.erney in forum Excel General
    Replies: 1
    Last Post: 06-19-2015, 02:44 PM
  3. Golf league average score
    By michaelt721 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-10-2015, 12:00 AM
  4. Golf League Handicaps
    By JRHOG in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-25-2014, 01:34 PM
  5. Spreadsheet for my golf League
    By DuncanP in forum Excel General
    Replies: 4
    Last Post: 03-30-2012, 10:39 AM
  6. Golf League Help
    By peterbarone in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-13-2005, 12:26 PM
  7. Golf League Schedule
    By Golf League Schedule in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-20-2005, 11:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1