Author Topic: SWOS 16/17 - Scout Excel Sheet  (Read 4493 times)

0 Members and 1 Guest are viewing this topic.

Offline scaleh

  • TRIAL
  • Posts: 8
  • Gender: Male
SWOS 16/17 - Scout Excel Sheet
« on: 16 March 2017, 22:56:15 »
*edit:  http://swos.gazchap.com (incl. 96/97 & 16/17 databases)

Hi all,

I have compiled an Excel Sheet of all of the players from the new update.

The Excel Sheets shows the following: -

- Player Name
- Player Team
- Player Value
- Country where team is based
- Passing Attribute
- Velocity Attribute
- Heading Attribute
- Tackling Attribute
- Control Attribute
- Speed Attribute
- Finishing Attribute

Due to the attachment restriction, I have had to delete all players with a Speed Attribute of 4 and less. I have also deleted all GK with a Value below £1m.

The only downsides to the Excel Sheet is the following: -

- some of the players are 'non-league' and cannot be bought while searching for the player in the transfer window (e.g. Buy Other Domestic/Foreign Player)
- Excel sheet doesn't show the players and team league

Apologies in advance if I have posted this in the incorrect forum.

Please let me know if you spot any errors or require another Excel Sheet (e.g. Finishing Attribute of 4 and less)

All the best

Scaleh


« Last Edit: 18 June 2017, 20:14:21 by Playaveli »

Offline Playaveli

  • 'Sherlock'
  • Administrator
  • SWOS Legend
  • *****
  • Posts: 8685
  • Gender: Male
  • "SWOS - A way of life" (J.R.)
    • Visit me on Facebook
Re: SWOS 16/17 - Scout Excel Sheet
« Reply #1 on: 17 March 2017, 12:43:26 »
Great work. Please send me the file with all players (full size) on my email: playaveli@sensiblesoccer.de
I will upload it then.

Thanks!! :)

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

Offline scaleh

  • TRIAL
  • Posts: 8
  • Gender: Male
Re: SWOS 16/17 - Scout Excel Sheet
« Reply #2 on: 17 March 2017, 17:11:57 »
Hi Playaveli,

No problem at all. I will send you the full sized Excel file in the next 10 mins.

Let me know if you need anything else.

Scaleh

Offline Playaveli

  • 'Sherlock'
  • Administrator
  • SWOS Legend
  • *****
  • Posts: 8685
  • Gender: Male
  • "SWOS - A way of life" (J.R.)
    • Visit me on Facebook
Re: SWOS 16/17 - Scout Excel Sheet
« Reply #3 on: 17 March 2017, 20:25:08 »
Great!

Yes, need more info in excel if possible:
- nationality of player

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

Offline scaleh

  • TRIAL
  • Posts: 8
  • Gender: Male
Re: SWOS 16/17 - Scout Excel Sheet
« Reply #4 on: 17 March 2017, 21:02:20 »
 :)

Cheers mate. I can work on that over the weekend.

Scaleh

Offline xflea

  • Mr. Friendly League
  • Special Moderator
  • SWOS Legend
  • *****
  • Posts: 1729
  • Gender: Male
  • hard rockin' amigo
Re: SWOS 16/17 - Scout Excel Sheet
« Reply #5 on: 17 March 2017, 21:03:55 »
yes indeed, that would come very handy

I could update my excel database ;)

http://www.sensiblesoccer.de/forum/index.php?topic=8598.0

Offline xflea

  • Mr. Friendly League
  • Special Moderator
  • SWOS Legend
  • *****
  • Posts: 1729
  • Gender: Male
  • hard rockin' amigo
Re: SWOS 16/17 - Scout Excel Sheet
« Reply #6 on: 17 March 2017, 21:04:55 »
BTW Scaleh, what software do you use to extract data from SWOS files?

Offline xflea

  • Mr. Friendly League
  • Special Moderator
  • SWOS Legend
  • *****
  • Posts: 1729
  • Gender: Male
  • hard rockin' amigo
Re: SWOS 16/17 - Scout Excel Sheet
« Reply #7 on: 17 March 2017, 21:41:47 »
meanwhile a complete database came from Emmeti :)

great!

Offline scaleh

  • TRIAL
  • Posts: 8
  • Gender: Male
Re: SWOS 16/17 - Scout Excel Sheet
« Reply #8 on: 18 March 2017, 15:54:32 »
Hi xflea,

I used an Hex Editor called HexEdit to read the database files which are stored in the DATA folder for SWOS (PC Version).

Then I copied all of that data and placed that into Excel.

The Excel sheet that I created converted the Hex Data into Decimal Data and for the player, team names I converted the Hex data into a Character. Then after that this data was placed into a table as described in my first post.

Due to the file size (9mb) I can send you the Excel file via email. So that you can have a look and then you can make any modifications. :)

If you could, please advise on any improvement/errors and that would be great. :)

Saying that if any one else wants a copy of the Excel file, please let me know your email address and I can send it.

All the best,

Scaleh

Offline scaleh

  • TRIAL
  • Posts: 8
  • Gender: Male
Re: SWOS 16/17 - Scout Excel Sheet
« Reply #9 on: 18 March 2017, 15:57:18 »
BTW xflea.

Your database is very impressive :)

Let me know if you need any help updating it :)

Offline xflea

  • Mr. Friendly League
  • Special Moderator
  • SWOS Legend
  • *****
  • Posts: 1729
  • Gender: Male
  • hard rockin' amigo
Re: SWOS 16/17 - Scout Excel Sheet
« Reply #10 on: 18 March 2017, 17:26:52 »
heh, this old database was created in 2008...

we are working now on some update because after I got the 16/17 database extracted from Emmeti I found some errors in players.

after all the errors are corrected I will be preparing the new version of excel database.

thanks for your contribution Scaleh!

Offline scaleh

  • TRIAL
  • Posts: 8
  • Gender: Male
Re: SWOS 16/17 - Scout Excel Sheet
« Reply #11 on: 18 March 2017, 17:46:17 »
No problem at all :)

If I can help in any way, please let me know.

ps Changing the subject slightly, please could you advise on any tactics, as my players are losing their value in career mode!  ;D

Offline Playaveli

  • 'Sherlock'
  • Administrator
  • SWOS Legend
  • *****
  • Posts: 8685
  • Gender: Male
  • "SWOS - A way of life" (J.R.)
    • Visit me on Facebook
Re: SWOS 16/17 - Scout Excel Sheet
« Reply #12 on: 18 March 2017, 17:52:05 »
ps Changing the subject slightly, please could you advise on any tactics, as my players are losing their value in career mode!  ;D

http://files.swos.eu/tactic/FORMA.TAC

This will help! Put it in folder "GAME" (if you play PC DOS version).

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

Offline scaleh

  • TRIAL
  • Posts: 8
  • Gender: Male
Re: SWOS 16/17 - Scout Excel Sheet
« Reply #13 on: 18 March 2017, 17:58:20 »
Thank you kindly Playaveli.

Also did you get my email the other day with the Excel file.

Offline Playaveli

  • 'Sherlock'
  • Administrator
  • SWOS Legend
  • *****
  • Posts: 8685
  • Gender: Male
  • "SWOS - A way of life" (J.R.)
    • Visit me on Facebook
Re: SWOS 16/17 - Scout Excel Sheet
« Reply #14 on: 18 March 2017, 18:46:28 »
Thank you kindly Playaveli.

Also did you get my email the other day with the Excel file.

Yep, got it! Thanks!

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