ABCDEFGH
1
2
Clash of Clans War Weight Calculator
3
Version 7.2Language:English◄ Select the dropdown box on each tab to change the language
4
June 23, 2018
5
6
NOTE: You will need to download the file before you can make updates
7
8
This Clash of Clans War Weight Calculator is designed to track the weight of multiple bases – up to 50 of them! – so it can be used to calculate a clan’s total war weight! Extremely easy to use, it’s designed to automatically calculate everything for you.
9
10
Chief Tabs
11
There are three main sections of this calculator. At the individual level, each clan member’s base can be maintained very easily.
12
*As you enter in information, edits will display to ensure your buildings and troops are valid for your townhall level.
13
*The number of spaces open for entry for each building will change based on the townhall level.
14
*When you gear up an item, enter it as 'LevelG'. For example, enter a level 3 geared up cannon as 3G
15
*When an item, troop, or spell reaches the max level for the townhall, it will be highlighted green.
16
*A notes section is included to help you document your plans: what to upgrade next, timeline, costs, etc.
17
*Groups are color-coded to show your heaviest defenses and troops (green=lightest, red=heaviest).
18
*Base Ratios
19
Using the levels of the buildings, troops, spells, and heroes, determine how much you have completed at a particular townhall level, and how much you have left to go. Additionally, you can also compare your offensive vs. defensive progress, which will help you see just how balanced your base is.
20
*Th10 Tier Information
21
The CWL (Champions War League) created a multi-level tier system to help clans better match each other in wars, and this system has been adopted by other leagues as well. Rather than use the gold weights to determine the defensive strength of a TH10 base, it will be determined by the level of selected defenses. If a base is a Th10 base, the Tier Levels will be calculated on the Chief tab.
22
23
Clan Tab
24
Another main section of the calculator is the Clan tab, and it’s the ultimate tool to help you and your Clan keep track of just how much War Weight you carry. Some of the highlights on this page:
25
*See the weight of everyone in your clan at a glance, and what your total clan weight is.
26
*Everyone's base ratios and combined heroes are listed, which help in war planning
27
*Sort by Base Weight to see the war lineup. Note that this is very close approximation of the lineup, but not exact.
28
*The list is color coded so that the lightest and heaviest bases can be quickly identified.
29
*When it’s time to figure out who will be in the next war lineup, make your selections and see what your war weight will be before you even go to war!
30
*An Error flag will be shown on a Chief’s line when there’s an error on that base, such as too many cannons selected for their townhall level. This will indicate that the weight calculation is not accurate.
31
32
Language Translations
33
Each tab can now be translated into a number of languages provided. Simply select the dropbown Language box and scroll up and down to see the languages available. As more translations are added in the future, you need not update the entire calculator - just load in the new translations tab and you'll be up to date!
34
Tips and Tricks
35
*Upload this spreadsheet to OneDrive or GoogleSheets. That way a couple of people – or even everyone in your clan! – can maintain the bases rather than one person have to shoulder the whole burden.
36
*Double-click on a Chief’s tab to rename it to the Chief’s name. This will make it easier to find someone’s tab, especially if there are many bases loaded.
37
*On the Clan tab, use the filter on the listing to sort by name, townhall level, or even weight.
38
*VERY IMPORTANT! On both the Clan and Chief tabs, be sure to only type in cells that are white, otherwise you may inadvertently type over a formula or edit and remove it!
39
40
This content is not affiliated with, endorsed, sponsored, or specifically approved by Supercell and Supercell is not responsible for it. For more information, please see Supercell's Fan Content Policy: www.supercell.com/fan-content-policy
41
This spreadsheet was designed by Axys (axys4coc@gmail.com, Twitter: @Axys4Coc) with weights and algorithms provided by Doc at Clash Kings 2. Raptor217's sheet was used as the initial concept, however all calculations have been moved to the Chief tabs to enable multiple users in one file, in addition to many, Many, MANY other bells and whistles that have been added. This calc is free to the public. Donations are appreciated but not expected at www.paypal.me/Axys4CoC. Thank you for your support. Clash on!
42
43
Version Updates
44
1.1 - 2/26/17 - Corrected AD counts for Th6 and Th7
45
1.2 - 2/27/17 - On the clan tab formatted the notes fields as text so that phones can enter alpha characters
46
1.3 - 3/1/17 - Added info box of max weighted base per townhall level on both the clan and chief tabs so you can see how close you are to the max or, for engineered bases, which townhall you are actually closest to.
47
1.4 - 3/1/17 - Added calculation for weighting penalty imposed on engineered bases.
48
1.5 - 3/2/17 - Bug fix to allow for 300 walls in one level at Th11
49
1.6 - 3/9/17 - Incorporated in recent update to Clash of Clans; modified view of chief sheets based on townhall level; squashed a few bugs. A shoutout to dahlt for an enhancement suggestion he sent in, which was incorporated into this version.
50
1.6.1 - 3/11/17 - Conditional views are now compatible in GoogleSheets (i.e. highlight if maxed at that level and darken if you can't get an item at that level)
51
2.0 - 6/2/17 - Added Townhall ratios, options to remove the weighting penalty, and conditional formatting for max walls, in addition to the modifications necessary for the May 2017 update (weighting changes and GearUp). Shoutouts to Judhead and Mark's Dad, who helped out with suggestions and testing.
52
2.1 - 6/11/17 - Fixed the error flag on the last eight chief lines
53
3.0 - 7/3/17 - Weight and level changes for June 2017 update. Added ability to gear up multiple items per level. Added Builder Base information. Also added highlight on the clan page of all those selected in war - Thanks, Oggie, for the suggestion!
54
4.0 - 8/25/17 - Modified calculator to match the new war matchmaking algorithm installed by SuperCell in August of 2017, which includes the removal of all weight penalties. Additionally, a shoutout goes to mevron, who helped correct the base ratio displays so they can properly display in Russia and other eastern European countries, and to Shadowpain and TJ, who both caught errors in Builder Base item counts, which were obtained from the Wiki pages -- so the calc is now more up-to-date than Wiki!
55
4.1 - 8/30/17 - Corrected the previous townhall level max verification on flag 2, and separated out the engineered base designation to individual flags that are used in the matchmaking process.
56
4.2 - 09/18/17 - Added the Matchmaking Summary tab. Also added the Clock Tower and weights to the Builder Base. Shoutout to GeorgeMa for catching the sort order bug on the Clan tab. Many found the bug on Flag 2 for the walls, however SuperDave was the first to point it out, so kudos goes to him! Finally, streamlined the code to prepare for multiple language translations in an upcoming release.
57
5.0 - 10/16/17 - Going global! Spreadsheet can now be translated into different languages. Language contributors listed below - thanks! Also added the new Builder Hall troop and the CWL Tier 10 calculator.
58
6.0 - 12/30/17 - Updated to the most recent Supercell release. Added two new translations, courtesy of Ruckzuck and Pedro. Added the Flag Lite Switches for your viewing pleasure. Updated Th10 Tier information to the current calculations. Corrected the Flag 2 formula for the walls -- thanks to Amar for finding the problem -- and the Builder Hall offense ratio -- thank you L.Dori for helping to squash that bug. A few other minor tweaks here and there.
59
6.1 - 1/1/18 - Quick fix for Flag 2, discovered by pusmma - Thanks, bro! ;-)
60
6.2 - 2/13/18 - All code and references to flags have been removed, since this was received from an unverified source.
61
6.3 - 2/20/18 - Fixed the Army Camp calculation
62
6.4 - 3/30/18 - Added Builder Hall 8 and recent PEKKA and trap upgrades on the Home Village
63
7.1 - 6/21/18 - Added Townhall 12 and all the new fun toys that came with it.
64
7.2 - 6/23/18 - Corrected Archer and Barbarian levels at Th11, Builder Base wall pieces to 32 for BB8, and increased number of Giant Bombs to 6 for Th12
65
66
LanguageTranslated by
67
DeutschRuckzuck
68
FrenchArbMotal
69
HindiSamOnsp
70
ItalianMr. Orange
71
PortuguesePedro
72
SpanishKilgh