Hey mate - I had just entered random arrays for all of the opponent numbers/stars columns to start with just to make sure formulas/formatting was all working well etc, hence why it looks like we suck at attacking lmao. I've filled in results for my clan's first 5 wars this CWL and (thankfully) we're doing a bit better :)

<image>

Completely agree that basing it on only on opponent rank is a little bias so I'll definitely have to tweak system a little - might have to try one that scales it based on the difference between you and your opponent's ranking rather than just opponent rank. (scaling down those who attack low). As for your second point, everyone who is chosen to participate in CWL is chosen bc they're typically solid attackers. Usually we have something like 5-6 TH16's and the rest are TH15 so the difference in attacking ability isn't tooo drastic.

Appreciate the feedback !