Re: Synchronated Updates

More
8 years 1 week ago #114027 by Synchronated
Sure I'll post a link in here when I've filled most of the gaps.

Please Log in or Create an account to join the conversation.

More
8 years 5 days ago - 8 years 4 days ago #114134 by Synchronated
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
Attachments:

Please Log in or Create an account to join the conversation.

More
8 years 5 days ago - 8 years 3 days ago #114135 by Synchronated
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

Please Log in or Create an account to join the conversation.

More
8 years 4 days ago #114138 by FIncad
Replied by FIncad on topic Re: Synchronated Updates
Hi!
Great work. Hopefully you will get the whole database updated soon too..

Cheers

Fincad

Please Log in or Create an account to join the conversation.

More
8 years 4 days ago #114139 by Mozg
Replied by Mozg on topic Re: Synchronated Updates
If it'll be possible for you in the future to share also a full database version (including players nationalities (even for those with "OTH") and transfermarkt values)? Last year you gave me such a version, however I don't know if you going to make such a thing this year or you've changed way of creating update... Thanks anyway! :)

Please Log in or Create an account to join the conversation.

More
8 years 4 days ago #114142 by Synchronated
I'll PM you later (when I'm home from work), Mozg

Please Log in or Create an account to join the conversation.

  • YoungIreland
  • YoungIreland's Avatar
  • Visitor
  • Visitor
8 years 4 days ago #114146 by YoungIreland
Replied by YoungIreland on topic Re: Synchronated Updates
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.  8)

Please Log in or Create an account to join the conversation.

More
8 years 4 days ago - 8 years 4 days ago #114148 by Synchronated
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)

Please Log in or Create an account to join the conversation.

More
8 years 4 days ago - 8 years 3 days ago #114169 by Synchronated
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)
Attachments:

Please Log in or Create an account to join the conversation.

More
8 years 3 days ago #114175 by ZICOZICO
Replied by ZICOZICO on topic Re: Synchronated Updates
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
Attachments:

Please Log in or Create an account to join the conversation.

Time to create page: 0.226 seconds
Powered by Kunena Forum