SWOS 16/17 - Scout Excel Sheet
von scaleh · 16.03.2017 22:56 · 15 Antworten · 33 Aufrufe
|
16.03.2017 22:56
#1
|
|
|---|---|
|
S
scaleh
Themenstarter
8 Beiträge
aus dem alten Forum
|
S
scaleh Themenstarter
8 Beiträge
*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 |
|
17.03.2017 12:43
#2
|
|
|---|---|
|
P
Playaveli
9.694 Beiträge
aus dem alten Forum
|
P
Playaveli
9694 Beiträge
Great work. Please send me the file with all players (full size) on my email: playaveli@sensiblesoccer.de
I will upload it then. Thanks!! 🙂 |
|
17.03.2017 17:11
#3
|
|
|---|---|
|
S
scaleh
Themenstarter
8 Beiträge
aus dem alten Forum
|
S
scaleh Themenstarter
8 Beiträge
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 |
|
17.03.2017 20:25
#4
|
|
|---|---|
|
P
Playaveli
9.694 Beiträge
aus dem alten Forum
|
P
Playaveli
9694 Beiträge
Great!
Yes, need more info in excel if possible: - nationality of player |
|
17.03.2017 21:02
#5
|
|
|---|---|
|
S
scaleh
Themenstarter
8 Beiträge
aus dem alten Forum
|
S
scaleh Themenstarter
8 Beiträge
🙂
Cheers mate. I can work on that over the weekend. Scaleh |
|
17.03.2017 21:03
#6
|
|
|---|---|
|
X
xflea
1.925 Beiträge
aus dem alten Forum
|
X
xflea
1925 Beiträge
yes indeed, that would come very handy
I could update my excel database 😉 http://www.sensiblesoccer.de/forum/index.php?topic=8598.0 |
|
17.03.2017 21:04
#7
|
|
|---|---|
|
X
xflea
1.925 Beiträge
aus dem alten Forum
|
X
xflea
1925 Beiträge
BTW Scaleh, what software do you use to extract data from SWOS files?
|
|
17.03.2017 21:41
#8
|
|
|---|---|
|
X
xflea
1.925 Beiträge
aus dem alten Forum
|
X
xflea
1925 Beiträge
meanwhile a complete database came from Emmeti 🙂
great! |
|
18.03.2017 15:54
#9
|
|
|---|---|
|
S
scaleh
Themenstarter
8 Beiträge
aus dem alten Forum
|
S
scaleh Themenstarter
8 Beiträge
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 |
|
18.03.2017 15:57
#10
|
|
|---|---|
|
S
scaleh
Themenstarter
8 Beiträge
aus dem alten Forum
|
S
scaleh Themenstarter
8 Beiträge
BTW xflea.
Your database is very impressive 🙂 Let me know if you need any help updating it 🙂 |
|
18.03.2017 17:26
#11
|
|
|---|---|
|
X
xflea
1.925 Beiträge
aus dem alten Forum
|
X
xflea
1925 Beiträge
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! |
|
18.03.2017 17:46
#12
|
|
|---|---|
|
S
scaleh
Themenstarter
8 Beiträge
aus dem alten Forum
|
S
scaleh Themenstarter
8 Beiträge
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! 😁 |
|
18.03.2017 17:52
#13
|
|
|---|---|
|
P
Playaveli
9.694 Beiträge
aus dem alten Forum
|
P
Playaveli
9694 Beiträge
|
|
18.03.2017 17:58
#14
|
|
|---|---|
|
S
scaleh
Themenstarter
8 Beiträge
aus dem alten Forum
|
S
scaleh Themenstarter
8 Beiträge
Thank you kindly Playaveli.
Also did you get my email the other day with the Excel file. |
|
18.03.2017 18:46
#15
|
|
|---|---|
|
P
Playaveli
9.694 Beiträge
aus dem alten Forum
|
P
Playaveli
9694 Beiträge
|
|
18.03.2017 19:50
#16
|
|
|---|---|
|
S
scaleh
Themenstarter
8 Beiträge
aus dem alten Forum
|
S
scaleh Themenstarter
8 Beiträge
No problem 🙂
Like I said, let me know if you need me to do anything 🙂 |