|
Quote: |
|
|
|
|
Originally Posted by JHedges2 |
|
|
|
|
|
|
|
|
Has anyone created a good spreadsheet they wouldn't mind sharing (google docs?) that is set up to log stats?
I'm sure someone has something.....
|
|
|
|
|
|
Here is what something I've been working on for a few years of FIFA now and think is pretty useful if you want to track your career. This one is for my Portsmouth career in 16 which I've just finished my fifth season of (I sim more than play, but it's pretty much all I do in the game)
https://docs.google.com/spreadsheets...it?usp=sharing
Here's some tips/info on how I set things up
Rules
- Just some parameters I give myself to make the game a little more realistic/challenging, so you can use these however you want or not at all or make your own
Top 5 Prospects
- I take the top 5 guys under 21 from my team and rank them with their age and overall as of August 1 of each year
Transfers
- I mark down just about every transfer I make (except extremely minor like 50K sales or youth players being released)
- For transfers where you send a player along with a fee, I roughly add up the player's value to the fee as the incoming player's price and use the player's value as the selling price
Loans
- I'll mark what team a player goes to, for how long, and his age and overall when sent out on loan. At the end of the loan (generally June 27 when your review is scheduled for full season guys) I will mark how much his overall has increased
Midseason Update
- I will go through the squad report whenever half of the league games have been played and mark my current standing and points total
- I outline a general starting XI whether those guys actually start the most or not and update their categories as shown (all apps not just league)
- For bench players I generally add anyone who's going to have 10 or more apps by the end of the season, but you can do what you want with that
- I mark the change in overall for players either by what they were at the end of last season or if they transferred in by what they were rated then
- The player highlighted in blue is captain
- All the categories add up or average out at the bottom automatically
- I list any more transfers or loans that happen in January, which for me usually isn't much
End of Season
- You can simply copy and paste the midseason player information and then update stats and wages/value as needed
- I like having the homegrown rules on there, but that is extremely optional and for non- English leagues wouldn't apply or
- I generally just look at Wikipedia one time to see where those players were from 18-21 and see if they will be eligible for the HG rule or not
- All players 21 and under don't count for the roster tally
- I like to bold the highest numbers for most of the categories to see who's oldest, best at this or that, earns the most, etc.
- After updating my squad the last few things I do is go through fixtures and mark how I did in each tournament, see if any players were in the top 10 of league G/A, and then update the league table
Season History
- I generally only update this every couple of seasons, but basically these are some areas of info that can be nice to look at and compare year to year
- All of the information should exist within your spreadsheet already if you have been updating it properly
Records
- This is something I won't even bother with until about year 4 or 5, but basically I will mark the Top 10 of a few categories
- For the top 10 individual seasons for G/A/apps and transfers, you simply go back through and look at who had the most of what or was bought/sold for the most
- The career records you can calculate by adding up the sum of a player's G/A/apps in the previous seasons' records
- The formula is in there for a few guys already, but for example basically you just do =sum(CLICK BOX OF FIRST SEASON'S GOAL TALLY+NEXT SEASON'S GOAL TALLY+NEXT+NEXT...etc.)
Updating everything probably takes 1-1.5 hours per season once you get the hang of it and for me makes the experience much richer if you love having a long career with one team. If some or all of this seems stupid or pointless or whatever, that's fine by me this is just a helpful tool there if you want it. If you've got any questions/comments about any of this and want to use my template, shoot me a response.