# Automated League winners and payout **URL:** \ **Category:** Leagues\ **Tags:** udisc-pro, new-feature, scorecard\ **Created:** [September 30, 2024, 7:07pm UTC](https://forum.udisc.com/t/automated-league-winners-and-payout/441778 "2024-09-30T19:07:23Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![jaxrhyno](https://sea2.discourse-cdn.com/flex024/user_avatar/forum.udisc.com/jaxrhyno/32/112711_2.png) [@jaxrhyno](https://forum.udisc.com/u/jaxrhyno)\ **Post date:** [September 30, 2024, 7:07pm UTC](https://forum.udisc.com/t/automated-league-winners-and-payout/441778/1 "2024-09-30T19:07:24Z")
I’ve created an Excel Workbook for maintaining league handicap, scoring, bag tags and finances. I have 95% of this workbook automated. The last piece I need to automate is the exporting of scores after the round. I can manually hover over the link for the scheduled event that day and get the identifier however, I would like to do this programmatically as to avoid any unnecessary human mistakes. Has anyone tried to screen scrape the Event page to get this data? ---
**Author:** ![jenn](https://sea2.discourse-cdn.com/flex024/user_avatar/forum.udisc.com/jenn/32/23_2.png) [@jenn](https://forum.udisc.com/u/jenn)\ **Post date:** [October 1, 2024, 1:50am UTC](https://forum.udisc.com/t/automated-league-winners-and-payout/441778/2 "2024-10-01T01:50:21Z")
Hey @jaxrhyno, Thanks for posting here. I can’t offer any advice for scraping this data as this isn’t something we support currently 🙂 But, I would love to know what aspects you currently have automated that you’d like to see in UDisc instead? We do currently have the ability to add payouts, set starting scores/adjusted scores, and assign bag tag numbers after an event is completed. I know you’re likely looking for more automated bag tag, handicap, and payment systems so would love know what exactly you’d like to see in the future. ---
**Author:** ![jaxrhyno](https://sea2.discourse-cdn.com/flex024/user_avatar/forum.udisc.com/jaxrhyno/32/112711_2.png) [@jaxrhyno](https://forum.udisc.com/u/jaxrhyno)\ **Post date:** [October 1, 2024, 10:33am UTC](https://forum.udisc.com/t/automated-league-winners-and-payout/441778/3 "2024-10-01T10:33:04Z")
Good morning Jenn. Let me provide a little background on our league and what I’ve currently automated. The league is a division-based handicap league, Advanced, Intermediate, Recreational, and Establishing (it takes 3 rounds to establish) As for automation, I have an Excel workbook that maintains the last 10 rounds for each player. I use either 9 or 10 of those rounds to determine handicap. The reason for 9 or 10 is due to having a bagger rule which states if one round is more than 5 strokes worse than the average it is not included. Every Sunday, with a click of a button on the workbook, a new check-in sheet is created. The data (name, division, and current handicap) is copied from the main handicap sheet to the weekly check-in sheet. Once check in is complete, another button is clicked which removes all of the rows of those not participating in the weekly event. After the round is completed, I verify all scorecards have been completed on Udisc I manually export the data from Udisc, and then copy and paste it into a sheet in the workbook. After the data has been pasted, another button is clicked. This macro, verifies all players have a Udisc score, reformats the data, calculates the best of 5, and then copies the scores and best of 5 data into the weekly check-in sheet. Once this is complete, I click another button which calculates payout for each division and adds the data to the payout sheet. The macro also adds the best of 5 winner or winners, and the Best Score winner or winners to the payout sheet. I’m at the point where I want to remove as much manual intervention as possible. What I’m looking for now is the ability to get the event ID programmatically from the schedule on UDisc. Right now I have code that will programmatically export the data and add it to the workbook but I have to enter the Event ID manually in a message box. I want to avoid this step. Once I can get the event ID programmatically, I will combine the button clicks to only 1 which will start with the screen scraping to get the Event ID. Thank you for reaching out, I apologize for the lengthy response. Jack ---
**Author:** ![jenn](https://sea2.discourse-cdn.com/flex024/user_avatar/forum.udisc.com/jenn/32/23_2.png) [@jenn](https://forum.udisc.com/u/jenn)\ **Post date:** [October 2, 2024, 8:27pm UTC](https://forum.udisc.com/t/automated-league-winners-and-payout/441778/4 "2024-10-02T20:27:12Z")
Hey Jack, Really appreciate you detailing your process - not lengthy at all and all super helpful! We’ll consider this for future updates. Thanks for all the time and efforts you put in to running a league!