Author Topic: SWOS 96/97 database - excel format  (Read 15712 times)

0 Members and 1 Guest are viewing this topic.

Offline xflea

  • Mr. Friendly League
  • SWOS Legend
  • *****
  • Posts: 1722
  • Gender: Male
  • hard rockin' amigo
SWOS 96/97 database - excel format
« 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.

Offline Schulle

  • "devil's right swos hand"
  • SWOS Legend
  • *****
  • Posts: 2573
  • Voll in's Netz!!!
    • ISSF - InternationalSensible Soccer Foundation ESSA
Re: SWOS 96/97 database - excel format
« Reply #1 on: 12 October 2008, 16:32:22 »
great work!!!
I spent a lot of money on booze, birds and fast cars. The rest I just squandered.
[GEORGE BEST]

Offline Playaveli

  • 'Sherlock'
  • Administrator
  • SWOS Legend
  • *****
  • Posts: 8595
  • Gender: Male
  • "SWOS - A way of life" (J.R.)
    • Visit me on Facebook
Re: SWOS 96/97 database - excel format
« Reply #2 on: 12 October 2008, 16:48:40 »
Indeed great work.
It looks fantastic. And very handy for some online competitions.

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

Offline NovaD40

  • TRIAL
  • Posts: 3
Re: SWOS 96/97 database - excel format
« Reply #3 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.

Offline xflea

  • Mr. Friendly League
  • SWOS Legend
  • *****
  • Posts: 1722
  • Gender: Male
  • hard rockin' amigo
Re: SWOS 96/97 database - excel format
« Reply #4 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

Offline NovaD40

  • TRIAL
  • Posts: 3
Re: SWOS 96/97 database - excel format
« Reply #5 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.

Offline xflea

  • Mr. Friendly League
  • SWOS Legend
  • *****
  • Posts: 1722
  • Gender: Male
  • hard rockin' amigo
Re: SWOS 96/97 database - excel format
« Reply #6 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...

Offline NovaD40

  • TRIAL
  • Posts: 3
Re: SWOS 96/97 database - excel format
« Reply #7 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?

Offline Playaveli

  • 'Sherlock'
  • Administrator
  • SWOS Legend
  • *****
  • Posts: 8595
  • Gender: Male
  • "SWOS - A way of life" (J.R.)
    • Visit me on Facebook
Re: SWOS 96/97 database - excel format
« Reply #8 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

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

Offline xflea

  • Mr. Friendly League
  • SWOS Legend
  • *****
  • Posts: 1722
  • Gender: Male
  • hard rockin' amigo
Re: SWOS 96/97 database - excel format
« Reply #9 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)...

Offline djowger

  • Goalscoring superstar hero!
  • Management
  • SWOS Legend
  • *****
  • Posts: 1321
  • Gender: Male
  • SWOS - The gameplay that never gets old.
Re: SWOS 96/97 database - excel format
« Reply #10 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...

Offline atchoo

  • Pupo
  • PRO
  • **
  • Posts: 136
  • Gender: Male
Re: SWOS 96/97 database - excel format
« Reply #11 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.

Offline Retrieving

  • センシボル ワールド オフ サッカー
  • Superstar
  • ****
  • Posts: 868
  • Gender: Male
  • 2015 Offline Italian Champion
    • SWOSIt!
Re: SWOS 96/97 database - excel format
« Reply #12 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?
« Last Edit: 16 March 2013, 20:05:00 by Retrieving | Searain »

Offline djowger

  • Goalscoring superstar hero!
  • Management
  • SWOS Legend
  • *****
  • Posts: 1321
  • Gender: Male
  • SWOS - The gameplay that never gets old.
Re: SWOS 96/97 database - excel format
« Reply #13 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?

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.

Offline atchoo

  • Pupo
  • PRO
  • **
  • Posts: 136
  • Gender: Male
Re: SWOS 96/97 database - excel format
« Reply #14 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!