Golf Group Tracking Bet Wins w/ Running totals by Golfer

[Rhall6310]

I manage a golf group of 35 people. We play 2 times a week and have several "Standard Bets" involved with each round we play.
I have been manually recording the bets each round played and updating the winnings for each golfer individually by the particular bet they won that day.

I am trying to create a workbook that has a "standard input work sheet" that would be used for each round (the bet category and amount of bet won) that I can print as a report that will also post the bet type and the amount won to the specific golfer that winning the bet that day.

That part in pretty part is pretty straight forward -where I'm lost is how to have that information post to the particular golfer and maintains a running total for the season.

In my mind I see this like a weekly sales report showing who sold what that week and then having that information post to the specific salesperson with running totals by product and dollars sold that could be used as an annual report.

I have a basic level of Excel experience and have looked at different ways to accomplish but linking the information to a specific golfer and keeping a running total by golfer far exceeds my knowledge level.

I have attached the foundation workbook to provide a better understanding of what I'm trying to accomplish.

Any direction would be greatly appreciated.

[AliGW]

You will need VBA to do what you want. Shall I move the thread for you?

[torachan]

@Rhall6310, bare bones framework, the attached file addresses the data entry and cumulative records.
I do not understand the purpose of the first two columns so have not at this point recorded them.
More detail of report format required before proceeding any further.

[Rhall6310]

Thank you for looking this over... yes it is a bare bones approach as I'm just trying to get the easiest least complicated foundation to work from. But figuring this out is complicated beyond my level.
It a better way is best to capture the information I'm open to anything.

I'm assuming you are questioning the 1st 2 columns on the Golfer Totals worksheet:
Scott Lake Rounds Other Course Rounds
(number of rounds played) (number of rounds played)

Our Home Course is Scott Lake but we play other courses as well.
I was manually entering the number of times a golfer played at home course or an away course. Just add 1 to where ever number was there. Total manual input.
I am thinking that the number of times a group member play at home and away - as it part of the INPUT SHEET information.
Thinking at some point I could see totals for both home and away (together) and home and away winnings separately as well..

I'm not sure the text box information showed up on the worksheet so I add below if you missed it.
Appreciate your consideration, Bob

All of the information that was posted to this Input Form for the round dated would be linked to the Golfer Totals worksheet.

INPUT SHEET - Winning bet golfers would be posted by the Bet Type of the bet $$ they won that day. (this could be printed as a single golf day results)

The GOLFERS TOTALS would provide cumulative running totals of the type of win and the total amount won.

After each days Bets and Amounts are posted to the Golfers Total Worksheet - this input sheet could be cleared and ready for the next round of golf reporting

[Rhall6310]

Thank you - As explained in previous note, the group likes to keep track of how many rounds they individually play at Scott Lake and other courses. The fist 2 columns you questioned.

Maybe this is best accomplished by supporting a separate worksheet that would be populated from the input form. I have attached an example of "Wins By Category" that is now manually input by one of the other members.

Is it possible to also capture and keep a running total of the category wins that would be a product of the INPUT FORM information for each round?

So appreciated - Bob

[Rhall6310]

torachan,
Not sure I am replying directly to you or making a general reply - please forgive me if this is redundant information.

Thank you - As explained in previous note, the group likes to keep track of how many rounds they individually play at Scott Lake and other courses. The fist 2 columns you questioned.

Maybe this is best accomplished by supporting a separate worksheet that would be populated from the input form. I have attached an example of "Wins By Category" that is now manually input by one of the other members.

Is it possible to also capture and keep a running total of the category wins that would be a product of the INPUT FORM information for each round?

So appreciated - Bob

[torachan]

Hi, I will try to look at this over the next day or two, busy time of year for a pensioner, recovering from too much indulgence.

[Rhall6310]

So appreciate your time and effort to help.
I live in Michigan so we are a few months from beginning our next golf season 😟.
No rush! Thanks Bob

[torachan]

the output goes to the three sheets - running total of bets ($) - day total of bets ($) - separate sheet with quantity of bets and courses/rounds played by individuals.
the listbox is multi-select - select course then all the players this should record quantity and courses played.
Any queries/alterations get back to me.

[Rhall6310]

Thank you for your work helping me with this.
Run Time Error Message Coming Up - Appreciate if you could take a look.

I have received and tested the expanded workbook you submitted - this is the information we are trying to collect however I am getting a Runtime Error and some bet information is not posting to the cumulative wins worksheet.
Win data is not posted to the Skins, Blind Draw and 1st & 2nd Team columns. The portion of the Input Form for the Course Played and golfers that played works fine.

Sequence leading to the error:
Input Form - 1. Complete all the bets out for the day and select the individual winning golfers - 2. Complete the Course Played Scott Lake or Other and the golfers that participated that day.
3. Select Transfer to Sheet of the Course Played, and it goes blank posting the information correctly. 4. Select Transfer To Sheet on the Bets Section - if all of the bets out does not completely fill the form - I get the Message Data Missing, Continue, select Yes.

This is when the Microsoft Visual Basic Message Appears - Run Time Error "13": Type Mismatch (End Debug Help)
If I select End and check the worksheet I see the data for the day did not populate the worksheet in the Skins, Blind Draw, and Team 1st & 2nd columns.

[torachan]

i will have a look tomorrow if time permits ( read as wife has no alternative plans for me)

[Rhall6310]

Thanks - feel like this is more effort than I should have asked for you help with.

Question - my friend that helps me track this information has a MAC w/ Apple Numbers - I have a windows PC w/ Excel. We both keep track.
Will your efforts here work on the MAC Numbers as well as the Excel?

Thx BOb

[Rhall6310]

Another Question - Is there a master listing of golfers (I cant see) that is used to generate the golfers listed in the "Input Form" Drop Down List and then added or deleted to the three reporting worksheets?
We will on occasion "add" a person to the group or someone may drop out during the season. Having the ability to manage the Golfer List for adds and drops is pretty important.

[torachan]

Should record O.K. now.
I can not say about MAC/Apple Numbers as I have no experience, however it should work on a MAC with Excel.
The names 'master list' is Table1 on Sheet("BetTotalsCumulativeCash") just add extra names to all three lists.

[Rhall6310]

Torachan,
Many thanks for your work on the Golf Bets - this is really coming together nicely. I have been doing some format updates and testing the accuracy of the data input / output and the three information worksheets.

Only Little Glitch I have encountered:

In the Bet Category's where a golfer could possibly win 2 or more of the bets (Closest to Pin & Skins) the Worksheet “Bet Totals Daily Cash” will only record and post the 1st instance of a win in that category.
Example Bob Hall wins the 1st and 3rd Closest to Pin for $10 each – the "Bet Totals Daily Cash" worksheet only shows a $10 win for the day. The 2nd $10 win is not recorded or totaled in if its the same golfer wining two or more times in that category.

It is not possible for a golfer to win more than once per round in Blind Draw, 1st Place, 2nd Place Teams, categories.
The "Bet Totals Cumulative Cash" and "Round and the Bet Totals" - Appear to be recording cumulative information properly.

I have attached the my formatted workbook for your review and formula correction in the worksheet “Bet Totals Daily Cash”.

Its a busy time of the year - when you find time. Thanks & Happy Holidays, Bob Hall

[torachan]

give the attached a trial

[Rhall6310]

torachan
I cant thank you enough!
I have this formatted and it works just as I had imagined providing the exact information I was seeking.
I have to still figure out a process for backups between rounds so as to not loose any data due to screw up or technical issues.

I am still looking for assistance to export this worksheet into a MAC Numbers format so our group secretary can use on his MAC. That I will post here under general excel question and see where that leads me. I cant be the first guy trying to convert Excel to Numbers.

I have been able to get the file exported and functioning on the MAC but the "INPUT FORM" does not show or work to feed the 3 worksheets, thus not functioning. What is the Excel Function Name for this Input Form?
I would like to be able to explain what function I'm having trouble with in the export and conversion.

But on the overall its good to go for the spring golf season working on a Windows and Excel format!
Again - so appreciated and thank you for working with me!!
Rhall6310 (Bob)

[torachan]

I am afraid I am totally ignorant of VBA functioning on a MAC - The form uses the Excel default name 'UserForm1'

[Rhall6310]

torachan,
This is Bob Hall in the US - You assisted me with the Golf Bets Worksheet last winter and I used it successfully during the 2022 Golf Season here in Michigan.
You probably help a lot of people but maybe don't get any feedback. I thought you might be interested in seeing the results of your effort and assistance.

The backup issue was simple and easy to maintain as I would just save the latest worksheet entry under the date that was played and then enter the next rounds Daily Winnings and save under the new date. The Cumulative $$ and Rounds played continued to calculate. WE played our last round on November 10 and closed out play for the year. Our group of 36 played 738 rounds of golf at Scott Lake and 179 at other courses, with total bets payouts of $7837.56 over the course of the season. I was able to track all this information using the worksheet.

Just wanted to drop you a thank you and appreciate your help. Bob

[torachan]

Hi Bob, many thanks for the feedback, glad the app stood the test of time - leave one at the nineteenth hole I will savour it if ever in your neighbourhood.

[Rhall6310]

Torachan,
I hesitate to impose but in review of last season winning bet totals and some confusion on my part with accurately recording Skins Payouts.

Is it possible to request your help once again to assist with modifying the Input Form:
1. Increase the Skins Payout positions to the "10th position" vs ending at 5 - found we typically have more than 5 skins out per round.

No hurry as we are dealing with 30" of snow on the ground and wont be needing the worksheet for a while yet!

I have attached my latest version of the Workbook. Appreciate any help if you are able to take the time.
Thx Bob

[torachan]

Hi Bob, just spotted your post, I will look at it over the next day or two, check back at the end of the week, after I have re-familiarised myself with it, at my advanced years I can remember what I did seventy years ago, remember what I did seven minutes ago is more of a challenge.
Keep warm.

[torachan]

Hope I have translated your requirement correctly.

[Rhall6310]

Torachan,
Many thanks. Ran a few tests and all appears to be working properly.
With the 10 Skin positions it will now allow me a single input session to record winning skin bets without having to double my input effort to maintain proper cumulative totals. Excellent!

Golfer Listing
I am not sure if there is an easier way to maintain the Golfers Listing. I have been looking alphabetically and "inserting a line" to add in new golfers or "deleting a line" for golfers that have dropped from the group.
I do this manually across all three reports and it appears to work properly albeit somewhat prone to mistakes and redundancy.

Do you think there is an easier way to maintain and manage the Golfers Listing?

Just a thought - if you find some extra time or just enjoy the challenge a input method for adding and deleting golfers would be the cherry on the sundae!

If I have outlived my welcome that's perfectly okay! :-) I have appreciated your efforts and expertise. I would never have figured this out myself.
Thanks Again, Bob

[torachan]

give the attached file a trial.

[Rhall6310]

Torachan,
Excellent! So much easier adding and deleting players while minimizing the possibility of making a mistake that could impact the cumulative worksheets going forward.
Again - Thanks a Ton! You have been an outstanding and patient contributor to the Excel Forum - I so appreciate!

[torachan]

Thanks for the feedback and added rep point - glad to have helped.