Revamp League Table Generators
Budget: £10 – £150 GBP
I need to streamline my existing soccer-league engine, which currently runs on a mix of Excel VBA and MySQL. Everything is already well documented, but several legacy ranking columns have become redundant. Here is what I want done:
• Strip out every trace—data, formulas, and references—of the columns “Rank Pts”, “Rank GD”, “Rank GA”, and “Total Rank” from both league_table and league_table_hmp in the workbook and in their mirrored MySQL tables. These fields were originally used for team ranking by points, yet they are no longer required.
• Replace the old ranking logic with the new counting formula that lives in Main Tab (2) cell AJ33, replicating its behaviour in both the Excel VBA routines and the MySQL views or stored procedures so the two stay perfectly in sync.
• Cross-check the MySQL layer against the updated VBA code so that any query I run directly on the database instantly reflects the latest business rules.
• Keep an eye on the table size: after the changes, resize the output tables so they match the exact length of the underlying data—no dangling blank rows.
All the intermediate calculations, helper ranges, and stage notes are already detailed inside Main Tab (2), so you will never be guessing. I work exclusively in Excel VBA, so please keep your VBA edits compatible with that environment while ensuring the corresponding SQL alters and routines are rolled out cleanly.
Deliverables are the revised workbook, updated VBA modules, and an SQL script (or equivalent migration file) that handles the database side. Once it’s done, I should be able to hit the macro button in Excel or run a SELECT in MySQL and see identical, trimmed-to-size league tables calculated with the new ranking logic—no obsolete columns left behind.
• Strip out every trace—data, formulas, and references—of the columns “Rank Pts”, “Rank GD”, “Rank GA”, and “Total Rank” from both league_table and league_table_hmp in the workbook and in their mirrored MySQL tables. These fields were originally used for team ranking by points, yet they are no longer required.
• Replace the old ranking logic with the new counting formula that lives in Main Tab (2) cell AJ33, replicating its behaviour in both the Excel VBA routines and the MySQL views or stored procedures so the two stay perfectly in sync.
• Cross-check the MySQL layer against the updated VBA code so that any query I run directly on the database instantly reflects the latest business rules.
• Keep an eye on the table size: after the changes, resize the output tables so they match the exact length of the underlying data—no dangling blank rows.
All the intermediate calculations, helper ranges, and stage notes are already detailed inside Main Tab (2), so you will never be guessing. I work exclusively in Excel VBA, so please keep your VBA edits compatible with that environment while ensuring the corresponding SQL alters and routines are rolled out cleanly.
Deliverables are the revised workbook, updated VBA modules, and an SQL script (or equivalent migration file) that handles the database side. Once it’s done, I should be able to hit the macro button in Excel or run a SELECT in MySQL and see identical, trimmed-to-size league tables calculated with the new ranking logic—no obsolete columns left behind.