Author Topic: SWOS 96/97 - complete database (incl. player skills)  (Read 42126 times)

0 Members and 1 Guest are viewing this topic.

Offline Oli O.

  • Dirty juggler
  • Superstar
  • ****
  • Posts: 713
  • Gender: Male
  • Mr. Bling Bling
Re: SWOS 96/97 - complete database (incl. player skills)
« Reply #45 on: 19 October 2007, 16:06:18 »
crazy

Offline Playaveli

  • 'Sherlock'
  • Administrator
  • SWOS Legend
  • *****
  • Posts: 8422
  • Gender: Male
  • "SWOS - A way of life" (J.R.)
    • Visit me on Facebook
Re: SWOS 96/97 - complete database (incl. player skills)
« Reply #46 on: 19 October 2007, 19:31:43 »
whiteulver - great work mate! your online database is simply brilliant

I always wanted to have the whole SWOS database in excel format and now it was a trivial thing to do - I just displayed ALL the players in the search mode (you were right - needs a lot of memory and good connection) and imported into excel

here it is:

http://xflea.republika.pl/swos/swos-database.zip
about 1MB .zip, 5MB .xls

I have made a few additions/changes:
1. I erased all CUSTOM teams
2. I made 2 spreadsheets: 1st for PLAYERS statistics (25.264 players altogether) and 2nd for TEAMS statistics (1.579 teams altogether)
3. I calculated the total number of points for each player/team
4. I changed the names of teams that are same in different leagues (eg. BARCELONA in Spain and BARCELONA in Ecuador are now BARCELONA (ESP) and BARCELONA (ECU) respectively)
5. I divided teams into 2 types: LEAGUE and NATIONAL

Some remarks:
1. there are no formulas in this excel file - I saved it all AS VALUES - it works MUCH faster...:)
2. many thanks to "Blind Playaveli" for beta-testing...:P
3. columns are:
in "players" spreadsheet:
No [number]
Name
Pos [position]
Nat [nationality]
PA [passing]
VE [velocity]
HE [heading]
TA [tackling]
CO [control]
SP [speed]
FI [finishing]
TOT [total number of skill points]
Value
Team
League
Type [LEAGUE or NATIONAL]
in "teams" spreadsheet:
Team
League
Type [LEAGUE or NATIONAL]
PA [passing]
VE [velocity]
HE [heading]
TA [tackling]
CO [control]
SP [speed]
FI [finishing]
TOT [total number of skill points]
Value
here are numbers summarized for each team...

enjoy! :D

That is an awesome piece of work! Thanks a lot.

And I was happy to be the "blind Playaveli".

For those about to SWOS - We salute you
http://www.facebook.com/playaveli.swos

Offline daimaou

  • The King of the Banana Shots
  • SWOS Legend
  • *****
  • Posts: 1414
  • Gender: Male
Re: SWOS 96/97 - complete database (incl. player skills)
« Reply #47 on: 19 October 2007, 21:18:38 »
 :o Whoaaaa great work mate!
me thinks this will be really helpful for the next FLOT   ;)

Offline SKID

  • RES
  • *
  • Posts: 90
  • Gender: Male
Re: SWOS 96/97 - complete database (incl. player skills)
« Reply #48 on: 20 October 2007, 14:45:24 »
Great work, xflea! This is a thing about i asked earlier...and only you, xflea, made my dream come true!


P.S. Blind Playa, blind Whiteulver...
Possibly I am the only ONE Russian guy on this forum :)

Offline pcarmalt

  • TRIAL
  • Posts: 1
Re: SWOS 96/97 - complete database (incl. player skills)
« Reply #49 on: 31 December 2007, 15:44:08 »
Hi all,

I have made a slightly updated version of xflea's excel sheet using values 0-7 instead of 0-15. This makes finding a player using filters much easier (see below example). Also, it now makes sense to add up the individual skill scores to produce a TOTAL, whereas this was meaningless when using both 0-7 and 8-15 values.

I have noticed that,  apart from goalkeepers, the value is defined by the sum of the skill scores:
Total = 0 or 1, Value = 25,000
Total = 2, Value = 30,000
T = 3, V = 40,000
T = 4, V = 50,000
T = 5, V = 65,000
...
etc, up to
...
T = 47, V = 12,000,000
T = 48 or 49, V = 15,000,000

This means that there are no "bargain" players as such, because a cheaper player will always have a worse overall skill set, however you may consider a player a bargain when you consider certain skills as having priority. In this case, you are looking for players which have good scores in the skills you do desire and zero in the skills you do not desire.

E.g. searching for Pos=A, SP>3, FI>3, VE>3, Value<400,000 gives the following options:
FERNANDO DI CARLO: PA=1,VE=4,HE=3,TA=0,CO=0,SP=4,FI=4,TOT=16,VALUE=300,000
GANIYU OWOLABI: PA=0,VE=5,HE=0,TA=1,CO=1,SP=5,FI=4,TOT=16,VALUE=300,000
CARL VEART: PA=1,VE=5,HE=0,TA=1,CO=1,SP=5,FI=4,TOT=17,VALUE=350,000
TOMMY MOONEY: PA=0,VE=4,HE=0,TA=0,CO=0,SP=4,FI=6,TOT=14,VALUE=200,000
ANDY HUNT: PA=2,VE=4,HE=0,TA=1,CO=1,SP=5,FI=4,TOT=17,VALUE=350,000
DENNIS KRIJGSMAN: PA=0,VE=4,HE=1,TA=2,CO=2,SP=4,FI=4,TOT=17,VALUE=350,000
CARMINE GAUTIERI: PA=0,VE=5,HE=1,TA=0,CO=1,SP=6,FI=4,TOT=17,VALUE=350,000

If you were only interested in SP, FI and VE then the best bargain is MOONEY as he does not waste any skill points on the other skills, which is why his VALUE is lower.

If someone is able to host the updated Excel file please let me know and I can email it to them.

Cheers
Phil

Offline whiteulver

  • PRO
  • **
  • Posts: 172
  • Gender: Male
    • Sensible World Of Editor Soccer
Re: SWOS 96/97 - complete database (incl. player skills)
« Reply #50 on: 02 February 2008, 18:28:26 »
Some updates to swos database site ...

- Kits  preview  in every team.
- Leagues are seperated to their divisions.
- Improved search (more fields)

Offline xflea

  • Mr. Friendly League
  • SWOS Legend
  • *****
  • Posts: 1672
  • Gender: Male
  • hard rockin' amigo
Re: SWOS 96/97 - complete database (incl. player skills)
« Reply #51 on: 03 February 2008, 17:16:12 »
great adjustment to a great project mate :)

you only miss those national teams of Oceania in your database...

Offline whiteulver

  • PRO
  • **
  • Posts: 172
  • Gender: Male
    • Sensible World Of Editor Soccer
Re: SWOS 96/97 - complete database (incl. player skills)
« Reply #52 on: 04 February 2008, 19:56:15 »
Thanks for your notice,

I have correct it ;)

Offline Playaveli

  • 'Sherlock'
  • Administrator
  • SWOS Legend
  • *****
  • Posts: 8422
  • Gender: Male
  • "SWOS - A way of life" (J.R.)
    • Visit me on Facebook
Re: SWOS 96/97 - complete database (incl. player skills)
« Reply #53 on: 04 February 2008, 20:10:19 »
Hey, Whiteulver, did you see that: http://swos.gazchap.com/ ??

For those about to SWOS - We salute you
http://www.facebook.com/playaveli.swos

Offline whiteulver

  • PRO
  • **
  • Posts: 172
  • Gender: Male
    • Sensible World Of Editor Soccer
Re: SWOS 96/97 - complete database (incl. player skills)
« Reply #54 on: 04 February 2008, 20:25:18 »
Yep i saw it...

it is very good site...

This guy has very good php/mysql knowledge!

This enforce me to  add some small changes to my database  :P

Anyway, 2 things are always better than one dont you think?




Offline xflea

  • Mr. Friendly League
  • SWOS Legend
  • *****
  • Posts: 1672
  • Gender: Male
  • hard rockin' amigo
Re: SWOS 96/97 - complete database (incl. player skills)
« Reply #55 on: 30 July 2018, 23:58:03 »
hey guys,

after all those years I found some errors in the database

funny enough it went unnoticed, so I copied them from Whiteulver database and then Gazchap from my file :)

have a look at Greek club teams - there are differences from actual in-game database 96/97


those teams do not exist in in-game 96/97 database:
KASTORIA
VERIA

those teams should be non-league:
KAVALA

those teams should be in league:
ETHNIKOS
LARISSA
PANIONIOS

those teams exist in in-game 96/97 database, but not in ours:
KORINTHOS
PIERIKOS



I came across those errors by pure chance... I got a file with an extract of 96/97 data from Emmeti and doublechecked the sum of all players values and it differed from my excel file... at first we thought there is some problem with Emmeti's extraction tool, but it worked perfect for 16/17 database so I started to look in my file and found the problem were the teams on Greece league. Several teams are different, as well as their players. My guess is Whiteulver had Greece teams somehow altered on his game data before extracting the database.

Offline Playaveli

  • 'Sherlock'
  • Administrator
  • SWOS Legend
  • *****
  • Posts: 8422
  • Gender: Male
  • "SWOS - A way of life" (J.R.)
    • Visit me on Facebook
Re: SWOS 96/97 - complete database (incl. player skills)
« Reply #56 on: 31 July 2018, 01:42:42 »
Nice research! How did you stumble over this?
Somehow, it makes sense... whiteulver is a Greek guy! ;)

For those about to SWOS - We salute you
http://www.facebook.com/playaveli.swos

Offline Fuzzified

  • TRIAL
  • Posts: 6
Re: SWOS 96/97 - complete database (incl. player skills)
« Reply #57 on: 18 November 2018, 08:51:58 »
I notice that tackling (T) and heading (H) in general show up in place of one another either on the game or on the databases.

For example Yuri Shelepnitsky in Altay, Turkey show up to have 3 tackling and 1 heading on gazchap, but the 3 best attributes are SHC in the game,

or Hung Myung-Bo of South Korea, Asia, show up to have 6 tackling and 2 heading, but the 3 best attributes are HPS in the game.

Does anybody have an idea what the true values must be in such cases ?

Edit: Corrected the places of heading and tackling
« Last Edit: 18 November 2018, 14:15:39 by Fuzzified »

Offline xflea

  • Mr. Friendly League
  • SWOS Legend
  • *****
  • Posts: 1672
  • Gender: Male
  • hard rockin' amigo
Re: SWOS 96/97 - complete database (incl. player skills)
« Reply #58 on: 18 November 2018, 12:26:21 »
hmm

you meant heading 1 and tackling 3 for Yuri Shelepnitsky and heading 2 and tackling 6 for Hung Myung-Bo?

but in general you're right - about those best skills shown in the game

interesting... I have also checked with Whiteulver's editor and shows the same - that Korean defender has mismatch in his "MAJOR" (best skills) and actual skills

Offline Fuzzified

  • TRIAL
  • Posts: 6
Re: SWOS 96/97 - complete database (incl. player skills)
« Reply #59 on: 18 November 2018, 14:24:37 »
Yes. The reverse is also true for central defenders seeming to have higher heading than tackling, they also have T in place of H in the 3 attributes in the game. I'm not sure but maybe it's only about central defenders.

Could it be that the game database has this irregularity placing tackling and heading in place of one another for central defenders ?