Re: Synchronated Updates

Sure I ll post a link in here when I ve filled most of the gaps.

Hi guys
Here s the first version of the English league file (all divisions, PC version).
There might be the odd error as I haven t done the normal data quality checks on this yet.
Let me know if there are any corrections etc. to theoretical lineups.
I will now get on with doing the other leagues.
Cheers
Sync

edit: fixed error in Exeter formation

Here s an extract of the data as it stands. Remember plenty of stuff will get changed a bit as I import the data, in order to fit SWOS team structure, and that includes some corrections, but this is the info right now. Nationality codes are done as FIFA codes, replacing SWOS codes (like the 11-12 update)

www.mediafire.com/?l5m2a407q53s2l8

edit: replaced with new link

Hi!
Great work. Hopefully you will get the whole database updated soon too..

Cheers

Fincad

I ll PM you later (when I m home from work), Mozg

Hi Synchronated well done on the database it looks impressive!

I was just wondering how did you convert the 0-100 parameter for the player attributes to the swos format?
Thanks.

I have a calculation sheet which, for each player, takes the target total number of skill points (which because of how SWOS skills work is determined by player s market value, with a small age modifier) and distributes them among the swos attributes using the ratio of those individual 0-100 values, in a way that is optimised for SWOS. The source attributes don t have to be 0-100, any linear scale would work without having to change the method, as they are all just relative to each other and to the total number of points (rather than being absolute values) and the total target sum comes from the market value.

The method has been tweaked slightly (actually, substantially overhauled) since the last update and so attributes should be distributed a bit better than last year.

(There are many stages to the calculation (dozens of cells per player), in order to ensure it hits the correct target in the correct way, meaning Excel cannot calculate all the players at once, so each team is calculated on its own before importing into SWOS. That s why I can t include the actual SWOS values on a data extract at this stage... only when they ve all been imported)

Italian league (both divisions plus SWOS non-league teams)
English file (now with a formation error in Exeter City fixed and Lascelles in Forest squad)

Hi Sync,

here s the swosscan tool that you requested.

General Usage:

swosscan [print options] [filters] teamfilename  ... print one file only

swosscan [print options] [filters] all           ... print all files



Print Options:

csv                      ... csv output format

csvno                    ... csv output format no header

club                     ... print clubs only

hex                      ... hex dump of complete file contents



Filters:

Pn Vn Hn Tn Cn Sn Fn     ... list players with at least  n  for these skills

G LB RB D M LW RW A      ... list players with given position only

+value                   ... list players at least as expensive as  value

-value                   ... list players cheaper than or equal to  value



Examples:

swosscan S5 TEAM.025     ... list players from one file with speed  =5

swosscan RW LW P6 F4 all ... list all wingers with passing  =6 finishing  =4

swosscan +80k A H2 all   ... list all attackers  =80k, heading  =2

swosscan -2m G all       ... list all goalies of 2m or less

swosscan csv all  db.csv ... dump all players in csv database  db.csv

Regards,
Zicozico