Generate Filterable Soccer League Table
Budget: £10 – £350 GBP
I need help creating a fully functional soccer league table generator using historical soccer results stored in a MySQL database. The table should include filtering options by country, league, year, and team, enabling precise data segmentation. Additionally, the filtered data must be exportable to Excel with implemented VBA code for easy usage.
The table will need several key calculations and metrics, such as Win/Loss/Draw counts for each team, goal difference calculations, points calculation based on match results, goals for and goals against, rankings, average points per team, and predicted points. These metrics are vital to making the table highly informative and practical for further analysis.
It’s essential that the exported Excel file retains all the custom formulas and tables integrated in a way that allows seamless interaction and further analysis down the line. If you're experienced with MySQL, Excel VBA, and data handling, please assist with developing this solution.
The table will need several key calculations and metrics, such as Win/Loss/Draw counts for each team, goal difference calculations, points calculation based on match results, goals for and goals against, rankings, average points per team, and predicted points. These metrics are vital to making the table highly informative and practical for further analysis.
It’s essential that the exported Excel file retains all the custom formulas and tables integrated in a way that allows seamless interaction and further analysis down the line. If you're experienced with MySQL, Excel VBA, and data handling, please assist with developing this solution.