Merge Multiple Seasons of Football Manager Moneyball Data with FMDataLab

Summary

In this video, the host introduces the new multi Moneyball upload feature, allowing users to upload up to five Moneyball HTML files at once. The process is simple, with the ability to drag and drop or select files manually. The feature supports merging player data across multiple seasons, comparing shortlists, and managing large data sets beyond the 10,000 player limit. The host explains the importance of correct data exports, consistency in settings, and the technical aspects of merging data. This update brings more flexibility, enabling better player comparisons and data aggregation for Football Manager enthusiasts.

Takeaways

• 😀 Multi Moneyball upload feature allows users to upload up to 5 Moneyball HTML files at once.
• 😀 Users can drag and drop or manually select files for upload, with a maximum of 10k players per file and 32 MB file size limit.
• 😀 The order of files can be adjusted to prioritize data from specific files, ensuring correct merging.
• 😀 Always export files using the correct Moneyball views from Football Manager to avoid errors in data merging.
• 😀 Consistent settings across files (language, currency, decimal symbols, etc.) are crucial to prevent formatting issues.
• 😀 The multi-upload feature helps combine player data from multiple seasons, making it easier to track player performance over time.
• 😀 Users can now compare multiple shortlists side by side without reorganizing data in Football Manager itself.
• 😀 The 10k player limit per file remains, but users can analyze up to 50,000 unique players by splitting data into multiple files.
• 😀 When comparing data from multiple files, using per 90 or percentage stats ensures reliability by normalizing the data.
• 😀 Player data is merged by matching their UID value across files, ensuring correct alignment of stats.
• 😀 The new 'entries' column shows how many separate files a player appears in, helping users track where the data comes from.
• 😀 Benchmark lines for top 5% in top 5 leagues are hidden when comparing players across multiple seasons to avoid unfair comparisons.

Q & A

What is the new feature added to the Moneyball tool?

The new feature is called 'multi Moneyball upload,' which allows users to upload up to five Moneyball HTML files at once.

How can users start using the multi Moneyball upload feature?

Users can start by going to the usual Moneyball upload page and clicking the new 'multi-moneyball upload' button. From there, they can either drag and drop files or manually select up to five HTML files.

Are there any file size or player limits when using multi Moneyball upload?

Yes, each file is limited to 10,000 players, and each file must be under the 32 MB file size cap.

What happens if users upload files with incorrect views or settings?

Uploading files with incorrect views or inconsistent settings, such as mismatched language, currency, or decimal symbols, can cause errors and incorrect formatting, leading to unreliable data.

What are the benefits of using the multi Moneyball upload feature?

It allows users to combine data from multiple seasons, compare different shortlists side by side, and handle large datasets exceeding the 10,000-player limit by splitting the data into smaller files.

How does the system handle data from multiple files when players appear in more than one?

The system merges player data by matching each player using their unique UID value, ensuring consistency even if a player appears in multiple files.

What is the maximum number of players that can be analyzed using the multi Moneyball upload?

With the multi Moneyball upload, users can analyze up to 50,000 unique players by uploading five files, each containing up to 10,000 players.

What happens if a player appears in multiple files? How is this handled in the comparison?

If a player appears in multiple files, their data will be combined based on the number of files they appear in, and the system will recalculate stats like goals per 90 minutes to ensure accurate comparisons.

Can users compare players' stats across multiple seasons? If so, how?

Yes, users can compare players' stats across multiple seasons by uploading files with data from different seasons. The multi upload feature combines them into one aggregated view.

What should users do to ensure fair comparisons when using the multi upload feature?

To ensure fair comparisons, users should filter out players who don't appear in all uploaded files and compare players who appear in the same number of files. This prevents skewed results due to differences in data sources.