Author Topic: SWOS skill generator  (Read 11354 times)

0 Members and 1 Guest are viewing this topic.

Offline armandojimene22

  • Management
  • PRO
  • *****
  • Posts: 103
  • play with me
SWOS skill generator
« on: 06 May 2016, 12:26:28 »
The last update  v9.3 with 16/17 database name teams

https://www.dropbox.com/s/sppssmqjppi6v6u/Skill%20Generator%20%28transfermarkt%29%20v9.3.xlsm?dl=0
---------------------------------------------------------------

actually only work with the webs

http://www.transfermarkt.es
http://www.transfermarkt.de
http://www.transfermarkt.co.uk

------------------------

Firefox and Chrome

Internet explorer no work
------------------------------------

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

--------------------------------------------------------------
Tutorial

https://www.youtube.com/watch?v=XyDrr9w1_R8

« Last Edit: 14 January 2018, 14:22:36 by armandojimene22 »

Offline atilla

  • RES
  • *
  • Posts: 54
Re: SWOS skill generator
« Reply #1 on: 06 May 2016, 18:12:01 »
@armando,
just testing your sheet.

Following the steps, and after clicking on "create Team" got this: http://prntscr.com/b10iqs

after clicked on YES - got this: http://prntscr.com/b10jc7

the "final" sheet looks like this: http://prntscr.com/b10jv6


Offline armandojimene22

  • Management
  • PRO
  • *****
  • Posts: 103
  • play with me
Re: SWOS skill generator
« Reply #2 on: 06 May 2016, 18:45:59 »
@atila

try with the last update
« Last Edit: 13 May 2016, 01:51:28 by armandojimene22 »

Offline atilla

  • RES
  • *
  • Posts: 54
Re: SWOS skill generator
« Reply #3 on: 06 May 2016, 18:56:30 »
how do you get these gray cells?
http://prntscr.com/b1135a

Offline armandojimene22

  • Management
  • PRO
  • *****
  • Posts: 103
  • play with me
Re: SWOS skill generator
« Reply #4 on: 07 May 2016, 15:13:08 »
where you can read type

https://www.dropbox.com/s/cvm8yxe8lqzlpxh/Captura%20de%20pantalla%202016-05-07%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 ;)

:)
« Last Edit: 13 May 2016, 01:51:01 by armandojimene22 »

Offline armandojimene22

  • Management
  • PRO
  • *****
  • Posts: 103
  • play with me
Re: SWOS skill generator
« Reply #5 on: 09 May 2016, 23:27:33 »
Skill Generator (transfermarkt)


How does It work

1º Go Sheet TEAM

2º click  CLEAR/NEW TEAM if have a problem

https://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)

https://www.dropbox.com/s/hkgw627bz9zs884/Real2.jpg?dl=0
https://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)

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

6º click CREATE TEAM, and Yes to all

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

7º select tactic and click button 'Swos Team'

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

« Last Edit: 13 May 2016, 16:18:19 by armandojimene22 »

Offline armandojimene22

  • Management
  • PRO
  • *****
  • Posts: 103
  • play with me
Re: SWOS skill generator
« Reply #6 on: 11 May 2016, 21:44:47 »
https://www.dropbox.com/s/sun1wkxovrpn2f7/final.png?dl=0

https://www.dropbox.com/s/ortqev6hlp6ygij/archivo%20generado%20csv.png?dl=0

the file csv

https://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
« Last Edit: 19 July 2016, 13:22:04 by armandojimene22 »

Offline armandojimene22

  • Management
  • PRO
  • *****
  • Posts: 103
  • play with me
Re: SWOS skill generator
« Reply #7 on: 13 May 2016, 16:24:22 »
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
« Last Edit: 13 May 2016, 16:30:14 by armandojimene22 »

Offline Rock and Roll

  • Euroleague Enthousiast & Sensi Days 2016 Organizer
  • Management
  • SWOS Legend
  • *****
  • Posts: 2454
  • Gender: Male
Re: SWOS skill generator
« Reply #8 on: 13 May 2016, 20:58:59 »
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 :).
If you smell what the Rock is cooking....

Sensible Days 2016 (Almelo): XBLA SWOS Bronze Medallist

Offline Gorzo

  • PRO
  • **
  • Posts: 136
  • Gender: Male
Re: SWOS skill generator
« Reply #9 on: 13 May 2016, 21:32:56 »
Armando! I`ve got a question. Your skill generator doesn`t work maybe because I`m using OpenOffice. Can you save your skill generator as ods file? :)

Offline armandojimene22

  • Management
  • PRO
  • *****
  • Posts: 103
  • play with me
Re: SWOS skill generator
« Reply #10 on: 13 May 2016, 22:42:33 »
Armando! I`ve got a question. Your skill generator doesn`t work maybe because I`m using OpenOffice. Can you save your skill generator as ods file? :)

The skill generator is a excel with macros, i dont know if work using Openoffice

i think cant work...

:)

Offline armandojimene22

  • Management
  • PRO
  • *****
  • Posts: 103
  • play with me
Re: SWOS skill generator
« Reply #11 on: 13 May 2016, 23:52:12 »
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 :).

this is generate with:

Brockie as a LB in the updated file with a 3-5-2 tactic
https://www.dropbox.com/s/vjcyqq30v0f6jaq/b36%202.png?dl=0

csv file
https://www.dropbox.com/s/yl2pl850v5zvi8l/B36%20csv.png?dl=0

« Last Edit: 02 June 2016, 01:42:12 by armandojimene22 »

Offline Gorzo

  • PRO
  • **
  • Posts: 136
  • Gender: Male
Re: SWOS skill generator
« Reply #12 on: 14 May 2016, 13:42:59 »
I`ve got a problem! Why Shiotani has got higher value than on transfermarkt? :) btw. Mizu and Chiba have lower :)
« Last Edit: 14 May 2016, 13:45:37 by Gorzo »

Offline armandojimene22

  • Management
  • PRO
  • *****
  • Posts: 103
  • play with me
Re: SWOS skill generator
« Reply #13 on: 14 May 2016, 16:07:39 »
I`ve got a problem! Why Shiotani has got higher value than on transfermarkt? :) btw. Mizu and Chiba have lower :)

hello

You can generate now

i fix the roles problem that cant read the excel

and i change role manually in Sheet FINAL, for the tactic:
D  33     TSUKASA SHIOTANI to RB
D  5   KAZUHIKO CHIBA to LB

i used tactic 4-5-1 , looking The last line-up of the web
finally add LW 16 KOHEI SHIMIZU to substitute for  M 37   KAZUYA MIYAHARAthat go to reserves

i cant find Team name Sanfrecce Hiroshima then i used the name of swos96-96 = SON HIROSHIMA, searching by REGION,LEAGUE

this is the team generate



« Last Edit: 21 May 2016, 10:41:55 by armandojimene22 »

Offline atilla

  • RES
  • *
  • Posts: 54
Re: SWOS skill generator
« Reply #14 on: 14 May 2016, 17:51:44 »
@armando,
just testing your sheet.

Following the steps, and after clicking on "create Team" got this: http://prntscr.com/b10iqs

after clicked on YES - got this: http://prntscr.com/b10jc7

the "final" sheet looks like this: http://prntscr.com/b10jv6

Armando, still having that problem as in the quoted text!

Don't do anything else, just paste the data from transfermarkt, fill everything needed and the same errors appears!