Fantasy Cricket is back! Give Feedback Here

[Greninja]

I need the three letter abbreviation for the fantasy cricket system - putting in the whole team name means I need to edit it back to the abbreviation before putting it in the database.

Well MattW Can you tell me how to search for yahoo id of players

 

[MattW]

Well MattW Can you tell me how to search for yahoo id of players

It's explained on the first sheet - find the player via the yahoo cricket site, and then get the id number from the end of the url for the webpage.

Template - Players for FC - Google Sheets


Thanks for everyone's work on it so far.

 

[Greninja]

It's explained on the first sheet - find the player via the yahoo cricket site, and then get the id number from the end of the url for the webpage.

Template - Players for FC - Google Sheets


Thanks for everyone's work on it so far.

Yes I understood!! I added the player Ajinkya Rahane like this
Ajinkya Rahane | ind | 3991 | 0 | 1 | 0 | 0 |

 

[MattW]

Yes I understood!! I added the player Ajinkya Rahane like this
Ajinkya Rahane | ind | 3991 | 0 | 1 | 0 | 0 |

Yep, that's right.

 

[Greninja]

Yep, that's right.

But why my created one player is removed??

 

[AliB]

Hey Matt, I have question of sorting. If you can keep on sorting in alphaberical order in organized in order of countries in Alphabetical or batting order.

 

[AliB]

All players are sorted based on their nationality.

 

[AliB]

All players are sorted based on their nationality.

Updated in alphabetical order too

 

[Greninja]

All players are sorted based on their nationality.

Well i had added nearly all the players of india and some countries is it necessary to add only wc players or we can add any players

 

[themusketeer]

Hey Matt, I have question of sorting. If you can keep on sorting in alphaberical order in organized in order of countries in Alphabetical or batting order.

Just Fill out the Form as Mentioned and leave everything to Matt

Why complicate things .

 

[Abhas]

Great work with the data so far! Don't worry about the sorting or the beautification of the data, we can do that easily. If you want to sort the list before you start entering your players in case they're already there, you should ideally sort by the nationality > yahoo id.
This way, when you're entering the data, you'll know you're not duplicating anything. But, even if you do, don't worry too much, it can be handled easily.

Cheers

 

[themusketeer]

AFG,UAE & SCO (only World Cup Squad Done ).

Ireland Next

 

[MattW]

Just to add to what Abhas said, the absolute main thing that's necessary is the thing you can't just grab from a machine - deciding if a player is an all-rounder or just a batsman/bowler, whether they keep wicket enough to put down as a wicketkeeper.

The machine doesn't care what order it all is in or how it looks - that's all handled by the interface I've been developing.

 

[Abhas]

Some players had the same Yahoo ID. Looks like someone dragged the ID down or something, anyway, I've deleted those, you'll need to find the IDs of those players again.

 

[AliB]

Half list have been sorted, half to go!

Hey Matt, how you're going to implement this sheet in the FC system, will you make a MySQL db or simply connect google Sheet?