Re: SWOS skill generator

More
4 years 5 months ago #133402 by armandojimenez

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...

:)

Please Log in or Create an account to join the conversation.

More
4 years 5 months ago - 4 years 4 months ago #133405 by armandojimenez

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
www.dropbox.com/s/vjcyqq30v0f6jaq/b36%202.png?dl=0

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

Please Log in or Create an account to join the conversation.

More
4 years 5 months ago - 4 years 5 months ago #133424 by Gorzo
Replied by Gorzo on topic Re: SWOS skill generator
I`ve got a problem! Why Shiotani has got higher value than on transfermarkt? :) btw. Mizu and Chiba have lower :)
Attachments:

Please Log in or Create an account to join the conversation.

More
4 years 5 months ago - 4 years 5 months ago #133425 by armandojimenez

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



Attachments:

Please Log in or Create an account to join the conversation.

More
4 years 5 months ago #133434 by atilla
Replied by atilla on topic Re: SWOS skill generator

@armando,
just testing your sheet.

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

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

the "final" sheet looks like this: 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!

Please Log in or Create an account to join the conversation.

More
4 years 5 months ago - 4 years 5 months ago #133439 by armandojimenez

@armando,
just testing your sheet.

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

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

the "final" sheet looks like this: 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!



Hi, say me Team and web (.de, .UK, .de)

usually test with www.transfermarkt.es
other webs can have error that i am fixing


try with the last version



1ºcopy-paste name team
2ºcopy must be all players and value(if you paste and copy other thing,don't work)

when some windows ask you something push enter, all time enter





Please Log in or Create an account to join the conversation.

More
4 years 5 months ago - 4 years 5 months ago #133440 by Gorzo
Replied by Gorzo on topic Re: SWOS skill generator

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 try with my last V.38

www.dropbox.com/s/b7byx8hpo4btzfy/Skill%...%29%20v3.8.xlsm?dl=0

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


Unfortunately, still unchanged :( Shiotani in real has got 1,6M, but in excel has got 2M and still the same problem with Chiba or Mizu :( maybe this is some bug? If anyone have the same problem with prices? :) I`m using editor and attributes I set manually but I use excel generator to determine price :)
Yes this is a Sanfrecce Hiroshima and they always play 3-4-2-1 so in editor i give 3-5-2 line-up :)

Please Log in or Create an account to join the conversation.

More
4 years 5 months ago - 4 years 4 months ago #133441 by armandojimenez

I`ve got a problem! Why Shiotani has got higher value than on transfermarkt? :) btw. Mizu and Chiba have lower :)


hello


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


Unfortunately, still unchanged :( Shiotani in real has got 1,6M, but in excel has got 2M and still the same problem with Chiba or Mizu :( maybe this is some bug? If anyone have the same problem with prices? :) I`m using editor and attributes I set manually but I use excel generator to determine price :)
Yes this is a Sanfrecce Hiroshima and they always play 3-4-2-1 so in editor i give 3-5-2 line-up :)


The value depends of the table , I will check , other thing is the web , are you transfermark .de , .es or .uk?
In uk must be conver to € from £ maybe not conver to Good :-)

In the sheet FINAL you can Change the value directly and generate click blue button where the name of the player

Please Log in or Create an account to join the conversation.

More
4 years 5 months ago #133442 by Gorzo
Replied by Gorzo on topic Re: SWOS skill generator

The value depends of the table , I will check , other thing is the web , are you transfermark .de , .es or .uk?
In uk must be conver to € from £

I`m using .de :)

Please Log in or Create an account to join the conversation.

More
4 years 5 months ago - 4 years 5 months ago #133448 by armandojimenez

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


Unfortunately, still unchanged :( Shiotani in real has got 1,6M, but in excel has got 2M and still the same problem with Chiba or Mizu :( maybe this is some bug? If anyone have the same problem with prices? :) I`m using editor and attributes I set manually but I use excel generator to determine price :)
Yes this is a Sanfrecce Hiroshima and they always play 3-4-2-1 so in editor i give 3-5-2 line-up :)


The value depends of the table , I will check , other thing is the web , are you transfermark .de , .es or .uk?
In uk must be conver to € from £ maybe not conver to Good :-)

In the sheet FINAL you can Change the value directly and generate click blue button where the name of the player



fix the problem of values


D  33   TSUKASA SHIOTANI to RB
D  5 KAZUHIKO CHIBA to LB

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

Attachments:

Please Log in or Create an account to join the conversation.

Time to create page: 0.281 seconds
Powered by Kunena Forum