|
|
Post by sjaugen on Nov 4, 2015 8:45:16 GMT
As I mentioned earlier, I asked Balders if he could share some tools on how to keep track of the tournament My aim was to get something I could edit for us, our competitors etc Balders came through  and he also posted it on FFS: docs.google.com/spreadsheets/d/1L2Xdx_1O_dx8lPkrh7PfffKSbWzY4xtiFxICcMf4usw/edit?usp=sharingIf you want to have a play around go to "File" -> "Make a copy...". This will make your own copy in your google drive that you can then edit. It's very template. I've never really worked with google sheets or importxlm, but I'm going to give it a try. If anyone of you think this is fun/have some skills; be my guest and try your own thing with this file. My aim is to build an overview in google sheets for the current GW. Starting with us, then scaling to the rest of the tourney members. Automate what I did to check how our status was vs Spain, Sunday morning, for instance. Make sure to give Balders some props when you see him. Just don't give him any money - I don't trust the Swiss |
|
|
|
Post by daas on Nov 4, 2015 11:33:20 GMT
Cheers Sjaugen
|
|
|
|
Post by Avishek_Zombie on Nov 4, 2015 19:16:26 GMT
As I mentioned earlier, I asked Balders if he could share some tools on how to keep track of the tournament My aim was to get something I could edit for us, our competitors etc Balders came through and he also posted it on FFS: docs.google.com/spreadsheets/d/1L2Xdx_1O_dx8lPkrh7PfffKSbWzY4xtiFxICcMf4usw/edit?usp=sharingIf you want to have a play around go to "File" -> "Make a copy...". This will make your own copy in your google drive that you can then edit. It's very template. I've never really worked with google sheets or importxlm, but I'm going to give it a try. If anyone of you think this is fun/have some skills; be my guest and try your own thing with this file. My aim is to build an overview in google sheets for the current GW. Starting with us, then scaling to the rest of the tourney members. Automate what I did to check how our status was vs Spain, Sunday morning, for instance. Make sure to give Balders some props when you see him. Just don't give him any money - I don't trust the Swiss That file is a work of art..Balders did a great job. I can't change what he did in the other sheets but I have played around with it and have created a summary sheet. There are 24 sheets hidden - 2 for each player. You can open them but only if you need to go into deep details for each manager So what we can do in the summary sheet I have created - docs.google.com/spreadsheets/d/1IlBorwRjDiLzR0xuGDEBBuN7puz8-gDU-h4dAxX-GJk/edit#gid=1033319503Whenever our match up is fixed, we just need to change two things - FPL IDs of all of our opponents (mandatory), GW (mandatory) & their names (optional) See if this is helpful and let me know if you would like to include some other information from Balders' sheets (that's all I can do - I can't get any new information unfortunately) Cheers! |
|
|
|
Post by daas on Nov 4, 2015 19:22:10 GMT
I need permission  |
|
|
|
Post by Avishek_Zombie on Nov 4, 2015 19:24:43 GMT
I need permission Oops. What about now? |
|
|
|
Post by sjaugen on Nov 4, 2015 19:24:56 GMT
|
|
|
|
Post by daas on Nov 4, 2015 19:25:12 GMT
Access denied.
|
|
|
|
Post by Avishek_Zombie on Nov 4, 2015 19:26:27 GMT
I need permission as well  Please make it public for anyone with the link |
|
|
|
Post by daas on Nov 4, 2015 19:30:48 GMT
12th amigo can't access it either.
On that note, Zombie the 12th amigo can't access our forum, can you do anything to help him out?
|
|
|
|
Post by sjaugen on Nov 4, 2015 19:33:41 GMT
I need permission as well Please make it public for anyone with the link Shared for people with the link. I've never used google spreadsheets before. I think I'm gonna fetch all data on FIFFSA, and worry about formatting and output/dashboards laters |
|
|
|
Post by Avishek_Zombie on Nov 4, 2015 19:36:24 GMT
12th amigo can't access it either. On that note, Zombie the 12th amigo can't access our forum, can you do anything to help him out? I have made my file public so you should be able to view it. To be able to edit them, two ways - you guys can create a copy or give me your email ID (which you will use to access Google Docs and I will add those emails in the permission granted list) About 12th Amigo's not being able to access the forum - Do you know what's the error he is getting? Is it blocked or something else? |
|
|
|
Post by daas on Nov 4, 2015 19:37:08 GMT
He emailed us, just said the site is blocked for him.
|
|
|
|
Post by Avishek_Zombie on Nov 4, 2015 19:38:19 GMT
I need permission as well Please make it public for anyone with the link Shared for people with the link. I've never used google spreadsheets before. I think I'm gonna fetch all data on FIFFSA, and worry about formatting and output/dashboards laters Seems great mate. Are you working with the XML codes? If yes, can you please somehow fetch the "captain" as well? I don't know how to work with XML codes so can't change anything in Balders' part |
|
|
|
Post by sjaugen on Nov 4, 2015 19:49:57 GMT
I'm working with the XML codes. I just discovered it now. I'm learning how to fetch select parts from the tables. Fetching the captain shouldn't be harder than to FIND the names one cell to the left, using the FPL IDs I got in the FIFFSA Summary sheet
|
|
|
|
Post by 12thamigo on Nov 5, 2015 8:04:49 GMT
Good work. This will make it easy to follow.
I will try and Save it onto my PC tonight.
|
|
and he also posted it on FFS:
