Re: SWOS skill generator

The last update v9.3 with 16/17 database name teams

www.dropbox.com/s/sppssmqjppi6v6u/Skill%...%29%20v9.3.xlsm?dl=0

---

actually only work with the webs

www.transfermarkt.es
www.transfermarkt.de
www.transfermarkt.co.uk

---

Firefox and Chrome

Internet explorer no work

---

CSV for Higgis web and SWOES v.1.3 and v.2

---

Tutorial

@atila

try with the last update

where you can read type

www.dropbox.com/s/cvm8yxe8lqzlpxh/Captur...%2015.07.26.png?dl=0

only need to choose one for the main players,
and chanege manually the others with 1 for Brown, 2 for black, 3 for blonde, look the photo of player when do the paste

Skill Generator (transfermarkt)


How does It work

1º Go Sheet TEAM

2º click CLEAR/NEW TEAM if have a problem

www.dropbox.com/s/eckvety8rocrs7e/Real1.jpg?dl=0

3º copy from the web TEAM NAME and paste in the cell of TEAM ( ? ? ? ? )

4º copy from the web PLAYERS, NAC, VAULE and paste in the cell (Here Paste team)

www.dropbox.com/s/hkgw627bz9zs884/Real2.jpg?dl=0
www.dropbox.com/s/gahjcwclex28exq/Real3.jpg?dl=0

5º select the main color of skin or hair , write with 1,2,3 the others players that photo are diferents (looking photos pasted)

www.dropbox.com/s/sch1slhkjegw17t/Real4.jpg?dl=0

6º click CREATE TEAM, and Yes to all

www.dropbox.com/s/zxz5ccu7misqvk4/Real5.jpg?dl=0

7º select tactic and click button Swos Team

www.dropbox.com/s/zkmam5ez51t8jbq/Real6.jpg?dl=0

www.dropbox.com/s/sun1wkxovrpn2f7/final.png?dl=0

www.dropbox.com/s/ortqev6hlp6ygij/archiv...erado%20csv.png?dl=0

the file csv

www.dropbox.com/s/t5a0g3odf7wcu6t/csv.png?dl=0

my excel last for generate csv


ID Nat Num Name Pos Skin P V H T C S F Value Team TeamNat TeamNr TeamTactic Coach

id= counter
nat = nationality
num = number player
name= name of player
pos= Role
Skin= skin
P V H T C S F = numer in each skill
Value = swos value
Team = team name
TeamNat = 35 is Spain
TeamNr = number of team in the league
TeamTacti= tactic
Coach =coach

like SWSGN

next stop try to update TEAM.XXX

thanks higgipoker for help with this

TEST of B36 Torshavn, Faroese champions

Skill Generator (transfermarkt) v 3.4

HÖGNI EYSTUROY was change Role to LB (original role RB) because we need all roles , and minimum number of them according the tactic selected

I have Brockie as a LB in the updated file with a 3-5-2 tactic.
I ll post the full update later this evening (one non-league team left ).
Have you just changed the tactic for test purposes?
Just curious...looks good .