Interesting case study for WordPress/ACF.
What you described can definitely be done.
You can create a Custom Post Type perhaps (or just add Custom Fields to the standard Post), and… during the “Save” process, you can intervene using the acf/save_post filter to do your calculations.
If you would rather the Users not have to login, you can use front end forms as you mentioned. The guide to create Front End Forms with ACF is here.
In addition, all the filtering desires you mentioned (top 3 scores, by-the-week, etc) can be accomplished with custom queries. See this doc here.
If this is helpful, please mark as resolved, and then revisit if you run into anything each step of the way. Perhaps we could have separate threads for each topic as we help you out. Best of luck with your project! Props to giving us older folks a bonus 4k 😉
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users
Helping others is a great way to earn karma, gain badges and help ACF development!
© 2023 Advanced Custom Fields.