Results 1 to 8 of 8

Thread: CWL Planning - Sheet to manage members in CWL

  1. #1

    Cool [CWL Planning] Sheet to manage members in CWL

    Hey there,


    I've just prepared an Excel sheet to help organizing clan wars during CWL. If you are interested you can grab the file here:




    Remark: You can use the Sakat's CoC Script to easily get all your clan members stats to copy paste them in this sheet. See below for the links.



    How to use it:


    (Tutorial to learn how to use the sheet with SCS)

    The sheet has five tabs.

    1) Informations: Some informations about the sheet there. You don't need to do anything there.
    2) Data: Used to simplify some calculs, this is where you can enter the CWL Season #, your clan name, the deadline for your members to register, your opponents info and the wartags.
    3) Planning: Where the useful things happens (see below)
    4) Clan Stats: Here you just need to enter the stars done by the 8 clans and the stats will refresh automatically
    5) Members Stats: Here you just need to enter the stars and % of destruction done by your clan members and the rest will be automatically refreshed.


    In Planning you can enter the nickname of the members available for the CWL season, if they have Discord and their TH level. For the TH level you can indicate if a TH is low or has just been updated by adding "-" (for ex. 11-) or, if he is almost maxed with a "+" (for ex. 10+). Adding "+" or "-" is purely optional and has no influence on the stats. It is just a simple way to indicate to everyone how advanced a member is in his current TH.

    Then you just need to enter "X" to the clanwar when the member is available in each "CW" colums. If a player is available to fill the CC it's the same; just add "X" in the "CC" columns. Once you have decide which clanmate available will participated to which clan wars, you can indicate it with the column "SELECT.". Finally if there is any comment about some members, you can precise it in "REMARK(S)". That's all!

    By the way, the column "% SELECT." on the right is the ratio between the clan wars where a player is available and the ones where he is actually selected. This is more for clan leaders to directly see if a player that is a lot available has actually not been selected for many clan wars. Ideally this should be as high as possible for everyone!


    Hosting the sheet on Google Spreadsheets allows clan members to enter their own informations. But if you do so, you might want to lock all the cells except the one your clan members should to edit. For example, in our clan we restrict the sheets and only allow members to enter their nickname, TH level, to which clan wars they are available and if they can fill up the clan castle troops (defensive one). Then it's up to the co-leaders to enter who are the 15/30 players selected for every single clan wars.


    I hope you will find it useful. Don't hesitate if you have any feedback or idea to improve it!



    Sakat (#QRLJ0GLJ)
    Clan Valais (#9PJYL)



    ====> Check our other projects <====

    - CGLeech.tk, a tool to keep the history of your clan and members activity in Clan Games:

    - Sakat's CoC Script, a tool to download the data of your clan as well as your members attacks and defenses stats during a CWL season.
    Last edited by Sakat; January 8th, 2020 at 09:41 AM.
    Wanna see your clan performances during CWL? Easily grab stats with SCS !
    ===>More info on the official thread <===



  2. #2
    Update (08.01.2020):
    - Added support for TH13
    - Two versions available (15vs15 and 30vs30)
    - Some adjustments
    - Video tutorial added


    Update (22.02.2019):
    - New version with more fields available (wartags, ...)
    - Better way to enter total clan stats
    - Improved some formulation
    - Fixed some bugs
    - Added two tabs for clan and members stats
    Last edited by Sakat; January 8th, 2020 at 09:48 AM.
    Wanna see your clan performances during CWL? Easily grab stats with SCS !
    ===>More info on the official thread <===



  3. #3
    This space is reserved for future content.
    Wanna see your clan performances during CWL? Easily grab stats with SCS !
    ===>More info on the official thread <===



  4. #4
    Senior Member
    Join Date
    May 2017
    Location
    Canada
    Posts
    292
    thanks, will be trying this out

    Krakurskull Clan Tag - 2PV8LV0J
    Forum - https://forum.supercell.com/showthre...vel-8-War-Clan



  5. #5
    Quote Originally Posted by THEONLYN View Post
    thanks, will be trying this out
    Let me know if you have any comment about it to improve it! I'm currently working on it to add more functionnalities
    Wanna see your clan performances during CWL? Easily grab stats with SCS !
    ===>More info on the official thread <===



  6. #6
    I updated the sheet. More stats now available!
    Wanna see your clan performances during CWL? Easily grab stats with SCS !
    ===>More info on the official thread <===



  7. #7
    I've just updated the sheet:

    - New version with more fields available (wartags, ...)
    - Better way to enter total clan stats


    The sheet is compatible with the Sakat's CoC Script that will be release soon!
    Wanna see your clan performances during CWL? Easily grab stats with SCS !
    ===>More info on the official thread <===



  8. #8
    Update (08.01.2020):
    - Added support for TH13
    - Two versions available (15vs15 and 30vs30)
    - Some adjustments
    Wanna see your clan performances during CWL? Easily grab stats with SCS !
    ===>More info on the official thread <===



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •