SWOS - United

SUPPORT & DOWNLOADS => TUTORIALS => Topic started by: xflea on 24 August 2008, 18:56:37

Title: SWOS 96/97 database - excel format
Post by: xflea on 24 August 2008, 18:56:37
hi mates,

I have developed a new version of the database in excel format.

http://xflea.republika.pl/swos/swos-database.zip

enjoy!

all suggestions are welcome.
Title: Re: SWOS 96/97 database - excel format
Post by: Schulle on 12 October 2008, 16:32:22
great work!!!
Title: Re: SWOS 96/97 database - excel format
Post by: Playaveli on 12 October 2008, 16:48:40
Indeed great work.
It looks fantastic. And very handy for some online competitions.
Title: Re: SWOS 96/97 database - excel format
Post by: NovaD40 on 11 March 2013, 03:35:13
Great excel, thank you.  But 1 question, why recalculate player skills into 0-7?  Won't the total be misleading doing it this way?  I'm new to SWOS.  Thank you.
Title: Re: SWOS 96/97 database - excel format
Post by: xflea on 11 March 2013, 23:34:09
Hi NovaD40.

It's recalculated into 0-7 scale because:
1. there is no evidence of any difference between 0-7 and 8-15.
2. it's possible to browse, sort, filter, etc. the database when it's all recalculated into one scale (0-7).

cheers
Title: Re: SWOS 96/97 database - excel format
Post by: NovaD40 on 15 March 2013, 21:36:53
Hi xflea,

The 0-7 scale throws the #s off a bit.  For example:

- using 0-7 scale (from excel)
Everton: 486
Chelsea: 474

- using 0-15 scale (I manually calculated)
Everton: 812
Chelsea: 850

The #s are total values for the teams.  Chelsea is higher when using 0-15.  For your #2 comment, isn't Excel able to sort/filter any # from 0-15?  Thank you.
Title: Re: SWOS 96/97 database - excel format
Post by: xflea on 15 March 2013, 22:17:33
In fact, 0-7 doesn't throw off numbers, but shows the real values...

Have a look at attached screens and try to calculate stars for both Chelsea and Everton :) which team's total is higher?

The real value is that Everton is stronger (in players skills total) than Chelsea in SWOS.

That is beacuse (in SWOS):
0=8
1=9
2=10
3=11
4=12
5=13
6=14
7=15

So, there is no difference if a skill is represented by 7 or 15 - in any case it's the "top" value.

Imagine two players with all skills at top, one of them with only 7s and second with only 15s. They're both exactly the same top players, however the first total skill points sum up to 49, and the second to 105...
Title: Re: SWOS 96/97 database - excel format
Post by: NovaD40 on 15 March 2013, 22:48:16
Wow, you're correct.  Counting the stars in your attachments, Everton is a bit higher than Chelsea.  In this case, why does SWOS represent
0=8
1=9
...?
Why doesn't it just use 0-7?
Does this mean if I use an editor and I make a player's skills all 13s (player1) and another player all 7s (player2), in SWOS this actually means player2 is better, even though the # totals don't reflect this?
Title: Re: SWOS 96/97 database - excel format
Post by: Playaveli on 16 March 2013, 11:57:46
Check this, which was posted in another context but is still relevant:

Im gonna do a guide soon, but the skills system in swos is quite easy to understand. All players have a number from 0-15 in 7 different categories (speed, passsing, finishing, tackling, shot power, ball control, heading). The confusing part is that numbers 0-15 are divided in 2, why i dont know (heard a rumor about player wages, but im not sure). The lowest is 0 which is equal to 8. The best is 15 which is equal to 7. This means the following:

Worst       ----------------->     Best
 0   1    2     3    4     5    6    7
 8   9   10   11  12   13  14  15

Player example:

Roberto Mussi (Parma)
 
 P   V  H   T    C   S    F
15  4   3  15   4  15   2

This would be equal to:

 P   V   H    T   C    S   F
 7  12  11   7  12   7   10

P = Passing
V = Shot Power
H = Heading
T = Tackling
C = Ball Control
S = Speed
F = Finishing

Roberto Mussi is RB, but i think he is perfect for a defensive midfielder. He has maximum in categories Speed, Tackling, and passing. Some people often get confused when i set an attacker in defence, but i know the skills of the player. And like playaveli said, you could easily have george weah in defence cause he has max in every skill. His stats are here together with a few others:

George Weah (AC Milan)
 P    V   H   T   C    S     F
15  15  15  7  15   15  15

Hristo Stoichkov (Barcelona)
 P    V   H   T   C    S     F
15  14   2   3  15   14  15

Claudio Lopez (Valencia)
 P    V   H    T   C   S    F
 2   14  14   3   3  15  14
Title: Re: SWOS 96/97 database - excel format
Post by: xflea on 16 March 2013, 16:13:37
I'm not sure about switching positions for players...

Try to play with Italy and put Maldini in attack. He is a maximum value player, so should be perfect in speed, ball control, shooting, finishing, etc. But somehow his strikes are not so "powerful" as those of "nominal" attackers (like Zola or Ravanelli)...
Title: Re: SWOS 96/97 database - excel format
Post by: djowger on 16 March 2013, 17:14:40
I'm not sure about switching positions for players...

Try to play with Italy and put Maldini in attack. He is a maximum value player, so should be perfect in speed, ball control, shooting, finishing, etc. But somehow his strikes are not so "powerful" as those of "nominal" attackers (like Zola or Ravanelli)...

I agree.. This is quoted from along time ago...
Title: Re: SWOS 96/97 database - excel format
Post by: atchoo on 16 March 2013, 19:17:20
Maldini isn't so strong as a LB, too!
In 442 he isn't fast like you should expect.
Title: Re: SWOS 96/97 database - excel format
Post by: Retrieving on 16 March 2013, 19:50:04
Check this, which was posted in another context but is still relevant:

Im gonna do a guide soon, but the skills system in swos is quite easy to understand. All players have a number from 0-15 in 7 different categories (speed, passsing, finishing, tackling, shot power, ball control, heading). The confusing part is that numbers 0-15 are divided in 2, why i dont know (heard a rumor about player wages, but im not sure). The lowest is 0 which is equal to 8. The best is 15 which is equal to 7. This means the following:

Worst       ----------------->     Best
 0   1    2     3    4     5    6    7
 8   9   10   11  12   13  14  15

Player example:

Roberto Mussi (Parma)
 
 P   V  H   T    C   S    F
15  4   3  15   4  15   2

This would be equal to:

 P   V   H    T   C    S   F
 7  12  11   7  12   7   10

P = Passing
V = Shot Power
H = Heading
T = Tackling
C = Ball Control
S = Speed
F = Finishing

Roberto Mussi is RB, but i think he is perfect for a defensive midfielder. He has maximum in categories Speed, Tackling, and passing. Some people often get confused when i set an attacker in defence, but i know the skills of the player. And like playaveli said, you could easily have george weah in defence cause he has max in every skill. His stats are here together with a few others:

George Weah (AC Milan)
 P    V   H   T   C    S     F
15  15  15  7  15   15  15

Hristo Stoichkov (Barcelona)
 P    V   H   T   C    S     F
15  14   2   3  15   14  15

Claudio Lopez (Valencia)
 P    V   H    T   C   S    F
 2   14  14   3   3  15  14

all 7's doesn't mean that the player will express his full potential regardless of where he's placed on the field, role matters as does affinity between certain skills and a given area of the pitch.

None of this is fixed though and seems like the same player will perform differently depending on the area of the pitch he's running above, which means that the system is working in real time, too, so if you push ahead on the wings a defender through passing alone he might play like shit (as in lose speed, lose BC or TA, etc.) even though he's gotten all 7's, as long as he's kept there.

As a matter of fact, an A will underperform (to the point of losing SP while being in the last and second to last tiles of the pitch near the corners and on the sides near the halfway line) as attacking wings (I mean, the forwards playing on the sides) in the 5-2-3 formation compared to an RW/LW with the same exact skills.

Have you guys not read my interview with Jon Hare from last year (http://www.sensiblesoccer.de/forum/index.php?topic=24921.0)?
Title: Re: SWOS 96/97 database - excel format
Post by: djowger on 16 March 2013, 21:07:53
all 7's doesn't mean that the player will express his full potential regardless of where he's placed on the field, role matters as does affinity between certain skills and a given area of the pitch.

None of this is fixed though and seems like the same player will perform differently depending on the area of the pitch he's running above, which means that the system is working in real time, too, so if you push ahead on the wings a defender through passing alone he might play like shit (as in lose speed, lose BC or TA, etc.) even though he's gotten all 7's, as long as he's kept there.

As a matter of fact, an A will underperform (to the point of losing SP while being in the last and second to last tiles of the pitch near the corners and on the sides near the halfway line) as attacking wings (I mean, the forwards playing on the sides) in the 5-2-3 formation compared to an RW/LW with the same exact skills.

Have you guys not read my interview with Jon Hare from last year (http://www.sensiblesoccer.de/forum/index.php?topic=24921.0)?

I have read it for sure. Interesting read. But like i wrote before this was quoted from along time ago, before your interview. People here had many ideas regarding player perfomances, ticks and crosses.

Never the less, in SWOS you are left with a lot of compromises setting up your team, if you want the best "solution" between playerskills and player positions. This means of course to put players in wrong positions mostly because the speed skill is desired, but yes the player is often weakened by his ball control etc.

If you want find out which positions fits each formation the best "in general", you can do this by using a team editor to give all players max in skills. Next, go to the game and change positions from bench to a certain position on the starting 11. When you cant find a better player for this position getting ticks, you've found the best player for this position. I hope this makes sense, but I'll share my experience trying this out with 442/sweep, 532, and 523.

442/sweep is pretty straight forward. An attacker as offensive midfielder is the most desired, even players starting in attack want this position better than normal attack.
A Defender is better for Def. midfielder than M, and also wants this position better than normal defence. Unfortunately in SWOS, there are no real good players with D position that is good in passing too.
 
RB D D LB
RW D A LW
A A

352/532 is almost the same as 442/sweep. Desired team is
RB D LB
RW D D A LW
A A

Obviously no team in swos has 3 D's with max in speed, but brazil is close. This looks almost like Playavelis setup for 532, only he has juninho in center defence in lack of a better choice. Sampaio is too slow.

As I play 523 myself I found this "optimal" setup quite weird. And of course no team in swos has double wingers, so you are left with compromises, were as A or LB/RB or even M as best alternatives for off. wingers.
RB D D D LB
RW LW
RW A LW

Worst thing from this is that Midfielders (M) are not desired as a prefered player in any position above other on the pitch. You can test all this yourself if you want with other standard formations like 343, defend, 451 etc.

Just thought I would share this with you guys. Again compromises are made to fit your style of play, not a must.
Title: Re: SWOS 96/97 database - excel format
Post by: atchoo on 16 March 2013, 21:17:30
Worst thing from this is that Midfielders (M) are not desired as a prefered player in any position above other on the pitch.
So true!
Title: Re: SWOS 96/97 database - excel format
Post by: Playaveli on 17 March 2013, 10:22:52
Exception: Redondo!
Title: Re: SWOS 96/97 database - excel format
Post by: atchoo on 17 March 2013, 11:33:01
Redondo is great, but Real's Ds can't compete with him. Hierro is 55 CoSp, Alkorta only 33 CoSp. Lasa, a LB, is 77 CoSp, but also 3 in Pa.
If only Redondo was a D...
Title: Re: SWOS 96/97 database - excel format
Post by: Sokratees9 on 07 November 2013, 02:55:06
Any chance someone has an excel file of all the 2013-14 data?  I wish I could simply copy it out of the SWOS DB Finder.  That's one feature it lacks.
Title: Re: SWOS 96/97 database - excel format
Post by: Sokratees9 on 07 November 2013, 03:33:48
Actually, it was quite easy.  I found the following program to read the mdb files that come with SWOS DB Finder:

http://www.alexnolan.net/software/mdb_viewer_plus.htm

And then just exported in CSV format and imported it into Excel.  If anyone wants it, let me know and I'll post it on here (or somewhere reachable anyway).
Title: Re: SWOS 96/97 database - excel format
Post by: Hungry Horace on 09 November 2016, 21:12:26
Jesus it's been a long time since i've visited here!!

Question.... did anyone solve the mystery of 0-7 ranges vs. 8-15 ranges?

I get that they have the same effect. THis is unsurprising. Going by my previous experience of hacking up other amiga games (including SWOS many years ago, and Mega Lo Mania more recenty) , i would expect that what should be happening is that the skill is set in bits 0-2 of the data (if you clear bit 3, then values 8-15 will transpose directly to 0-7)

It seems likely then that you need to simply look at what bit 3, which is going to end up as TRUE/FALSE only is doing. Probably this should be how the data is looked at in any editor (i also have no idea what editor people are using these days)

Cheers


p.s. can't believe it's been 18 years since SWOS WorldCup '98, lol
Title: Re: SWOS 96/97 database - excel format
Post by: higgipoker on 10 November 2016, 05:18:52
Interesting theory!

Maybe bit 3 is indeed a true/false value which indicates if the skill is one of the players listed top skills? Eg "TSP" for Maldini.
Title: Re: SWOS 96/97 database - excel format
Post by: Sokratees9 on 07 December 2018, 17:18:43
Anyone got a copy of the 96/97 DB in excel format?  Surely it should get its own thread in the Downloads section
Title: Re: SWOS 96/97 database - excel format
Post by: xflea on 07 December 2018, 20:27:18
Playaveli was so kind to upload my database files to ss.de FTP

NOTICE: I will be fixing 9697 database some time soon - it has a tiny error with Greece league rosters
Title: Re: SWOS 96/97 database - excel format
Post by: Playaveli on 07 December 2018, 20:29:48
Download it here: http://files.swos.eu/xls-database/swos-database-9697.zip

Or direct online view:
https://docs.google.com/spreadsheets/d/1Kmg3dXya5w3ksBJY1Uwo3s70JZoPVuG4GnrsczC7XHc/edit?usp=sharing