To see less ads Register or Login ----- Daily Fantasy Sports games 18+

Player list

A Fantasy Football forum for news on fantasy football games run by The Sun newspaper.
Post Reply
User avatar
Chrisharry12345
Dumbledore
Posts: 7600
Joined: 07 Feb 2007, 22:39

Player list

Post by Chrisharry12345 »

Does anyone have the full player list in a format I can paste to excel?

Cheers

User avatar
jpk
Dumbledore
Posts: 5216
Joined: 13 Oct 2005, 18:42
Contact:

Re: Player list

Post by jpk »

1001 Berisha, Etrit 1 ALB G
1002 Almer, Robert 2 AUT G
1003 Courtois, Thibaut 4 BEL G
1004 Subasic, Danijel 3 CRO G
1005 Cech, Petr 3.5 CZE G
1006 Hart, Joe 4 ENG G
1007 Lloris, Hugo 4.5 FRA G
1008 Neuer, Manuel 5 GER G
1009 Kiraly, Gabor 1.5 HUN G
1010 Halldorsson, Hannes 1.5 ICE G
1011 Buffon, Gianluigi 4 ITA G
1012 McGovern, Michael 1 NIR G
1013 Fabianski, Lukasz 3 POL G
1014 Szczesny, Wojciech 3 POL G
1015 Patricio, Rui 3.5 POT G
1016 Randolph, Darren 2 IRL G
1017 Pantilimon, Costel 2 RMN G
1018 Tatarusanu, Ciprian 1.5 RMN G
1019 Akinfeev, Igor 2.5 RUS G
1020 Kozacik, Matus 1.5 SVK G
1021 Casillas, Iker 4 ESP G
1022 de Gea, David 4.5 ESP G
1023 Isaksson, Andreas 2.5 SWE G
1024 Sommer, Yann 2.5 SUI G
1025 Babacan, Volkan 2 TUR G
1026 Pyatov, Andriy 2 UKR G
1027 Hennessey, Wayne 2 WAL G
2001 Cana, Lorik 1.5 ALB D
2002 Fuchs, Christian 2.5 AUT D
2003 Prodl, Sebastian 2 AUT D
2004 Wimmer, Kevin 2.5 AUT D
2005 Dragovic, Aleksandar 2 AUT D
2006 Vermaelen, Thomas 3.5 BEL D
2007 Lombaerts, Nicolas 3.5 BEL D
2008 Alderweireld, Toby 5 BEL D
2009 Vertonghen, Jan 4.5 BEL D
2011 Corluka, Vedran 2 CRO D
2012 Srna, Darijo 2.5 CRO D
2013 Vida, Domagoj 2 CRO D
2015 Kadlec, Michal 2 CZE D
2016 Clyne, Nathaniel 3 ENG D
2017 Walker, Kyle 3 ENG D
2018 Rose, Danny 2.5 ENG D
2020 Smalling, Chris 3 ENG D
2021 Stones, John 3 ENG D
2022 Cahill, Gary 3 ENG D
2024 Evra, Patrice 3.5 FRA D
2027 Sagna, Bacary 3.5 FRA D
2028 Koscielny, Laurent 4.5 FRA D
2029 Hummels, Mats 5.5 GER D
2030 Boateng, Jerome 6 GER D
2031 Hector, Jonas 3 GER D
2033 Kadar, Tamas 1 HUN D
2034 Bonucci, Leonardo 3.5 ITA D
2035 Darmian, Matteo 3 ITA D
2036 Barzagli, Andrea 4.5 ITA D
2037 Chiellini, Giorgio 4 ITA D
2038 De Sciglio, Mattia 3 ITA D
2039 McAuley, Gareth 1.5 NIR D
2040 Evans, Jonny 2 NIR D
2041 Cathcart, Craig 1.5 NIR D
2042 Baird, Chris 1 NIR D
2043 Piszczek, Lukasz 2.5 POL D
2044 Glik, Kamil 2 POL D
2045 Alves, Bruno 3.5 POT D
2046 Pepe 4.5 POT D
2047 Fonte, Jose 2.5 POT D
2048 Soares, Cedric 2 POT D
2049 Carvalho, Ricardo 2.5 POT D
2051 O'Shea, John 2 IRL D
2052 Coleman, Seamus 2.5 IRL D
2053 Keogh, Richard 1 IRL D
2054 Chiriches, Vlad 2 RMN D
2055 Rat, Razvan 1.5 RMN D
2057 Skrtel, Martin 2.5 SVK D
2058 Ramos, Sergio 6 ESP D
2059 Pique, Gerard 6 ESP D
2060 Alba, Jordi 5 ESP D
2061 Juanfran 4 ESP D
2062 Azpilicueta, Cesar 4 ESP D
2063 Bartra, Marc 3 ESP D
2064 Olsson, Martin 2 SWE D
2065 Lichtsteiner, Stephan 3 SUI D
2066 Rodriguez, Ricardo 2.5 SUI D
2068 Djourou, Johan 1.5 SUI D
2069 Erkin, Caner 2 TUR D
2070 Williams, Ashley 2.5 WAL D
2071 Taylor, Neil 1.5 WAL D
2072 Davies, Ben 2 WAL D
2073 Chester, James 1.5 WAL D
2074 Collins, James 1.5 WAL D
2075 Gunter, Chris 1 WAL D
2076 Mangala, Eliaquim 3.5 FRA D
2078 Guerreiro, Raphael 2.5 POT D
2079 Bertrand, Ryan 2.5 ENG D
2080 Carvajal, Daniel 3.5 ESP D
2081 Boyata, Dedryck 2 BEL D
2082 Lukaku, Jordan 1.5 BEL D
2083 Digne, Lucas 3 FRA D
2084 Howedes, Benedikt 3 GER D
2085 Lustig, Mikael 2 SWE D
2086 Vieirinha 3 POT D
2087 Eliseu 2.5 POT D
2088 Rami, Adil 3 FRA D
2089 McNair, Paddy 1.5 NIR D
2090 Senderos, Philippe 1.5 SUI D
2091 Bellerin, Hector 3.5 ESP D
2092 Ogbonna, Angelo 2.5 ITA D
2093 Pudil, Daniel 1.5 CZE D
2094 Wawrzyniak, Jakub 1.5 POL D
2095 Juhasz, Roland 1 HUN D
2096 Denayer, Jason 2.5 BEL D
2097 Kaderabek, Pavel 1.5 CZE D
2098 Schar, Fabian 2 SUI D
3001 Xhaka, Taulant 1 ALB M
3002 Alaba, David 3.5 AUT M
3003 Arnautovic, Marko 3.5 AUT M
3004 Fellaini, Marouane 3.5 BEL M
3005 Witsel, Axel 4.5 BEL M
3006 Dembele, Mousa 3 BEL M
3007 Mertens, Dries 4 BEL M
3009 Hazard, Eden 6 BEL M
3010 de Bruyne, Kevin 6 BEL M
3011 Ferreira Carrasco, Yannic 3 BEL M
3013 Modric, Luka 5 CRO M
3014 Rakitic, Ivan 5 CRO M
3015 Perisic, Ivan 3.5 CRO M
3016 Kovacic, Mateo 3.5 CRO M
3017 Rosicky, Tomas 1.5 CZE M
3018 Milner, James 3 ENG M
3019 Alli, Dele 3.5 ENG M
3020 Lallana, Adam 3 ENG M
3021 Henderson, Jordan 3 ENG M
3022 Barkley, Ross 3 ENG M
3023 Cabaye, Yohan 4 FRA M
3024 Diarra, Lassana 2.5 FRA M
3025 Kante, N'Golo 3.5 FRA M
3026 Matuidi, Blaise 4 FRA M
3027 Sissoko, Moussa 2.5 FRA M
3028 Pogba, Paul 6.5 FRA M
3029 Payet, Dimitri 4.5 FRA M
3030 Coman, Kingsley 4 FRA M
3031 Ozil, Mesut 6 GER M
3032 Schurrle, Andre 4.5 GER M
3033 Reus, Marco 6.5 GER M
3034 Kroos, Toni 5.5 GER M
3035 Draxler, Julian 3.5 GER M
3036 Gotze, Mario 5 GER M
3037 Schweinsteiger, Bastian 3.5 GER M
3039 Khedira, Sami 4 GER M
3040 Bellarabi, Karim 3 GER M
3041 Gera, Zoltan 1.5 HUN M
3042 Sigurdsson, Gylfi 2.5 ICE M
3043 Gunnarsson, Aron 1 ICE M
3044 Candreva, Antonio 3 ITA M
3045 Motta, Thiago 2.5 ITA M
3047 De Rossi, Daniele 3.5 ITA M
3050 Davis, Steven 2 NIR M
3051 Norwood, Oliver 1 NIR M
3052 Blaszczykowski, Jakub 3.5 POL M
3053 Nani 4 POT M
3056 Quaresma, Ricardo 3 POT M
3057 Carvalho, William 3.5 POT M
3058 Moutinho, Joao 4.5 POT M
3060 McCarthy, James 2.5 IRL M
3061 Hoolahan, Wes 2 IRL M
3062 Brady, Robbie 2 IRL M
3063 Whelan, Glenn 1 IRL M
3064 Torje, Gabriel 1 RMN M
3065 Shatov, Oleg 2.5 RUS M
3066 Hamsik, Marek 2.5 SVK M
3067 Weiss, Vladimir 1.5 SVK M
3068 Fabregas, Cesc 5.5 ESP M
3069 Silva, David 5.5 ESP M
3071 Isco 4 ESP M
3072 Alcantara, Thiago 4.5 ESP M
3073 Busquets, Sergio 4 ESP M
3074 Iniesta, Andres 6.5 ESP M
3075 Larsson, Sebastian 2 SWE M
3076 Kallstrom, Kim 1.5 SWE M
3077 Behrami, Valon 1.5 SUI M
3078 Shaqiri, Xherdan 4 SUI M
3080 Fernandes, Gelson 1.5 SUI M
3081 Xhaka, Granit 2.5 SUI M
3082 Turan, Arda 3.5 TUR M
3083 Calhanoglu, Hakan 3 TUR M
3084 Konoplyanka, Yevhen 2 UKR M
3085 Yarmolenko, Andriy 4 UKR M
3086 Tymoshchuk, Anatoliy 2 UKR M
3087 Ledley, Joe 1.5 WAL M
3088 Allen, Joe 2.5 WAL M
3089 Ramsey, Aaron 4 WAL M
3091 Dier, Eric 2.5 ENG M
3092 Can, Emre 3.5 GER M
3094 Wilshere, Jack 3.5 ENG M
3095 Sterling, Raheem 4 ENG M
3096 Gudjohnsen, Eidur 1 ICE M
3097 Sanches, Renato 2.5 POT M
3099 Koke 4 ESP M
3100 Nainggolan, Radja 3.5 BEL M
3101 Niguez, Saul 3.5 ESP M
3102 Sane, Leroy 3 GER M
3103 Brandt, Julian 3 GER M
3104 Drinkwater, Daniel 2 ENG M
3105 Townsend, Andros 2.5 ENG M
3106 Dzsudzsak, Balazs 1.5 HUN M
3107 Durmaz, Jimmy 2 SWE M
3108 King, Andy 2 WAL M
3109 Mario, Joao 3.5 POT M
3110 Gomes, Andre 2.5 POT M
3111 Silva, Rafa 2.5 POT M
3112 Florenzi, Alessandro 2.5 ITA M
3113 Giaccherini, Emanuele 2.5 ITA M
3114 Montolivo, Riccardo 3 ITA M
3115 Ferguson, Shane 1 NIR M
3116 Topal, Mehmet 2 TUR M
3117 Tore, Gokhan 2.5 TUR M
3118 Sahin, Nuri 2.5 TUR M
3119 Ozyakup, Oguzhan 2 TUR M
3120 McGeady, Aiden 1.5 IRL M
3121 McClean, James 1.5 IRL M
3122 Schneiderlin, Morgan 3 FRA M
3123 Krychowiak, Gregorz 2 POL M
3124 Dockal, Borek 1.5 CZE M
3125 Krejci, Ladislav 1.5 CZE M
3126 Grosicki, Kamil 2 POL M
4001 Sadiku, Armando 1 ALB F
4002 Cikalleshi, Sokol 1 ALB F
4003 Harnik, Martin 1.5 AUT F
4004 Janko, Marc 2 AUT F
4006 Benteke, Christian 4.5 BEL F
4007 Origi, Divock 4 BEL F
4008 Lukaku, Romelu 5.5 BEL F
4009 Mandzukic, Mario 5 CRO F
4010 Kalinic, Nikola 3 CRO F
4012 Necid, Tomas 2 CZE F
4013 Rooney, Wayne 6 ENG F
4014 Kane, Harry 6 ENG F
4015 Sturridge, Daniel 5.5 ENG F
4016 Vardy, Jamie 4.5 ENG F
4018 Giroud, Olivier 5 FRA F
4019 Griezmann, Antoine 6 FRA F
4020 Martial, Anthony 5.5 FRA F
4021 Gignac, Andre-Pierre 4 FRA F
4022 Muller, Thomas 7 GER F
4023 Gomez, Mario 5 GER F
4024 Priskin, Tamas 1.5 HUN F
4025 Szalai, Adam 1 HUN F
4026 Sigthorsson, Kolbeinn 2 ICE F
4027 Pelle, Graziano 4 ITA F
4028 El Shaarawy, Stephan 3.5 ITA F
4029 Eder 3.5 ITA F
4030 Lafferty, Kyle 1.5 NIR F
4032 Washington, Conor 1 NIR F
4033 Lewandowski, Robert 6.5 POL F
4034 Milik, Arkadiusz 3.5 POL F
4035 Ronaldo, Cristiano 7.5 POT F
4036 Walters, Jon 1.5 IRL F
4037 Long, Shane 2.5 IRL F
4038 Keane, Robbie 2 IRL F
4039 Stancu, Bogdan 1.5 RMN F
4041 Kokorin, Aleksandr 2.5 RUS F
4042 Dzyuba, Artem 3 RUS F
4044 Duris, Michal 1.5 SVK F
4046 Pedro 4.5 ESP F
4048 Morata, Alvaro 5 ESP F
4049 Ibrahimovic, Zlatan 6.5 SWE F
4050 Berg, Marcus 1.5 SWE F
4052 Mehmedi, Admir 1.5 SUI F
4053 Embolo, Breel 1.5 SUI F
4055 Yilmaz, Burak 2 TUR F
4056 Zozulya, Roman 2 UKR F
4057 Robson-Kanu, Hal 1.5 WAL F
4058 Guidetti, John 1.5 SWE F
4060 Batshuayi, Michy 3.5 BEL F
4062 Insigne, Lorenzo 3.5 ITA F
4063 Vazquez, Lucas 3.5 ESP F
4064 Kramaric, Andrej 2.5 CRO F
4065 Rashford, Marcus 2.5 ENG F
4066 Podolski, Lukas 4 GER F
4067 Vokes, Sam 2 WAL F
4068 Aduriz, Aritz 3 ESP F
4069 Nolito 3.5 ESP F
4070 Eder 2.5 POT F
4071 Bale, Gareth 6 WAL F
4072 Grigg, Will 1.5 NIR F
4073 Murphy, Daryl 1.5 IRL F

User avatar
Chrisharry12345
Dumbledore
Posts: 7600
Joined: 07 Feb 2007, 22:39

Re: Player list

Post by Chrisharry12345 »

Great thanks

How did you do it? Would love to learn things like that

User avatar
jpk
Dumbledore
Posts: 5216
Joined: 13 Oct 2005, 18:42
Contact:

Re: Player list

Post by jpk »

I used a macro with a JSON decoder (well you did ask)

but there's a number of simpler manual ways e.g. copy and paste the stats page into excel and build some formulas to transpose the results

when you paste you get a list like this...

Code: Select all

Ronaldo, Cristiano

STR

POT

£7.5m

0

Muller, Thomas

STR

GER

£7.0m

117
you could use the =OFFSET function to get a formatted table
stats.png
2nd column would be =OFFSET($A$1,(D1*10)+2,0)
3rd = OFFSET($A$1,(D1*10)+4,0)
4th = OFFSET($A$1,(D1*10)+6,0)
You do not have the required permissions to view the files attached to this post.

User avatar
Chrisharry12345
Dumbledore
Posts: 7600
Joined: 07 Feb 2007, 22:39

Re: Player list

Post by Chrisharry12345 »

The manual way looks more my level :)

Yes I was getting that strange format whichever why I tried importing it in or a even stranger one if I saved it in notepad and tried it there. Many thanks

User avatar
Nightowl
Grumpy Old Man
Posts: 2679
Joined: 19 Jul 2016, 19:52
FS Record: fiso cheap as chips champion 17/18

Re: Player list

Post by Nightowl »

Bump, just so we can all see how the euros were priced,not sure it will help but

plevna1963
Grumpy Old Man
Posts: 2136
Joined: 13 Aug 2013, 08:52
FS Record: John Morrison Elite League 14/15 22nd 15/16 8th Europa League 15/16 8th Sundreamteam 2015/16 Weekly Winner Top 100 / Fiso Euro 2016 (Fra) 2nd. Xmas League (2) 2016/2017
John Morrison Elite League March Monthly Winner 2016/17

Re: Player list

Post by plevna1963 »

Nightowl wrote: 22 May 2018, 16:47 Bump, just so we can all see how the euros were priced,not sure it will help but
Have a break-Have a Kit Kat

View Latest: 1 Day View Your posts
Post Reply

Return to “The Sun Dream Team FF Games”