ABCDEFGH
1
2
Clash of Clans War Weight Calculator - Single User Version
3
Version 7.2aLanguage: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 - SINGLE USER VERSION - is designed to track the weight of up to three bases. Extremely easy to use, it’s designed to automatically calculate everything for you.
9
10
Chief Tabs
11
*As you enter in information, edits will display to ensure your buildings and troops are valid for your townhall level.
12
*The number of spaces open for entry for each building will change based on the townhall level.
13
*When you gear up an item, enter it as 'LevelG'. For example, enter a level 3 geared up cannon as 3G
14
*When an item, troop, or spell reaches the max level for the townhall, it will be highlighted green.
15
*A notes section is included to help you document your plans: what to upgrade next, timeline, costs, etc.
16
*Groups are color-coded to show your heaviest defenses and troops (green=lightest, red=heaviest).
17
*Base Ratios
18
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.
19
*Th10 Tier Information
20
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.
21
Language Translations
22
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!
23
24
Tips and Tricks
25
*Double-click on a Chief’s tab to rename it to the Chief’s name. This will make it easier to identify each tab.
26
*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!
27
28
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
29
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!
30
31
Version Updates
32
1.1 - 2/26/17 - Corrected AD counts for Th6 and Th7
33
1.1a - 2/26/17 - Created a single-user version
34
1.3a - 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.
35
1.4a - 3/1/17 - Added calculation for weighting penalty imposed on engineered bases.
36
1.5a - 3/2/17 - Bug fix to allow for 300 walls in one level at Th11
37
1.6a - 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.
38
1.6a.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)
39
2.0a - 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.
40
3.0a - 7/3/17 - Weight and level changes for June 2017 update. Added ability to gear up multiple items per level. Added Builder Base information.
41
3.1a - 7/18/17 - Corrected error check on weights on home base heroes, troops, and spells.
42
4.0a - 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 page -- so the calc is now more up-to-date than Wiki!
43
4.1a - 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.
44
4.2a - 09/18/17 - Added the Clock Tower and weights to the Builder Base. 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.
45
5.0a - 10/16/17 - Going global! Spreadsheet can now be translated into different languages. Language contributors listed below - thanks! Also added the new Builder Base troop, upgraded items on the Townhall and Builder Base for the recent SuperCell update (ex. valk, night witch, more walls at Th11, etc), modified Flag3 per new rules, and added the CWL Tier 10 calculator.
46
6.0a - 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.
47
6.1a - 1/1/18 - Quick fix for Flag 2, discovered by pusmma - Thanks, bro! ;-)
48
6.2a - 2/13/18 - All code and references to flags have been removed, since this was received from an unverified source.
49
6.3a - 2/20/18 - Fixed the Army Camp calculation
50
6.4a - 3/30/18 - Added Builder Hall 8 and recent PEKKA and trap upgrades on the Home Village
51
7.1a - 6/21/18 - Added Townhall 12 and all the new fun toys that came with it.
52
7.2a - 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.
53
54
LanguageTranslated by
55
DeutschRuckzuck
56
FrenchArbMotal
57
HindiSamOnsp
58
ItalianMr. Orange
59
PortuguesePedro
60
SpanishKilgh
61