Quote:
Originally Posted by cavebutter
This one's tricky because I have not been able to find ratings history in any of the dump files. The only way I can think to do this from the dump files would be to create a new ratings history table and set a trigger to update it with new rows for each player every time you import them. The problem is that there's no date or year associated with the ratings. I suppose you could hard code a date along with it.
What kind of vis would you want to see with this? There's already something similar in 19. Either way, I will add this to my backlog as I haven't played around with triggers yet and sounds like fun.
|
So what I've been doing is going to the player list screen at the same time every year, telling the game to dump a set of ratings I've chosen, copy/pasting the long list it dumps into my browser, opening Excel to paste that info in, and adding a column for "Year" into which I type the year of the report.
The one I'd like to see would be like the one in FM. I'll find it again.
Well, I can't seem the find the one I grabbed, but here's another:
So you could click on a player, then click on a list of the attributes, and then a graph shows you how that player has improved (or really: how your scout thinks he has improved or declined) over the years/months.
My pivot tables are a disaster, though. There are these damned numbers on my columns that I can't figure out why they're there. (See attached picture). I was having the same problem with Excel. I just want the damn thing to list the number in the damn column, and NOT try to add it or average it or anything else. Grah. I get so frustrated with these programs, borne out of my ignorance and raised on a diet of constant failure and headache.
It looks much closer to what I want to see if, rather than "Columns," I list the attributes as "Values," but then the stupid thing will insist on making it the "SUM" of the listed values, or some other such function, and I can't figure out what the command is to "DO NOTHING" or "JUST LIST THE NUMBERS, CHUMP"