How to create your own spare ratings spreadsheet

[Fletch74]

How do you download the stats?

1) Go to Stats Centre on the Team Overview page
2) Download Squad Details
3) Youth/Senior in text format (numbered skills)
4) Save file
5) Go to excel. Open file in text format.
6) Press, Next, Next, then Finish
7) Add Column after Fielding
8) Use formula =G2-(SUM(H2:N2)*1000) if overall ratings is in column G
9) Save file in Excel format

I use it to compare as to how much my players have improved each week as well.

[MajorLazer]

ok Thanks Fletch. :)

[valkorum]

cheers for that val. just tested it to see if i could work it and i can. good job

Cheers cookie

[DazBurg]

would that work fletch or Val doing it in microsoft spreadsheet?
might make it easier on me rather then working them out manually all the time

[valkorum]

You mean microsoft excel - yes mine is designed to work in excel (not open office calc)

[DazBurg]

i dunno is excel spreadsheet the same?
i got the whole microsoft works with the calender and the database and the spreadsheet and all that crap got open office too but i know u said not in that

[valkorum]

i dunno is excel spreadsheet the same?
i got the whole microsoft works with the calender and the database and the spreadsheet and all that crap got open office too but i know u said not in that

Yes - the microsoft spreadheet will work for what I wrote.

[DazBurg]

well i downloaded the stats just not sure how to get the formula working i got all the numbers but how do i get it to add upi put like feltch said it justs pastes that instead of working anything out

(yeah i'm good with computers just don't really use works ever)

[valkorum]

well i downloaded the stats just not sure how to get the formula working i got all the numbers but how do i get it to add upi put like feltch said it justs pastes that instead of working anything out

(yeah i'm good with computers just don't really use works ever)

Fletch gave the instructions already :)

1) Go to Stats Centre on the Team Overview page
2) Download Squad Details
3) Youth/Senior in text format (numbered skills)
4) Save file
5) Go to excel. Open file in text format.
6) Press, Next, Next, then Finish
7) Add Column after Fielding
8) Use formula =G2-(SUM(H2:N2)*1000) if overall ratings is in column G
9) Save file in Excel format

[DazBurg]

when i go to easy calc for the formula it has add, subtract and so on

[valkorum]

just type the below in the cell

=G2-(SUM(H2:N2)*1000)

[DazBurg]

ahhhh i dunno pasted it into the cell and doesn't seem to do anything or it does and says there's errors
will have to just keep doing it manually