COC - Calculator - Calculations tool for Clash of Clans
Hello everyone,
Here is an Excel file titled "COC - Calculator" which helps to calculate several things about the game Clash of Clans.
At first I wanted to know how long I still have to wait and how many resources I need to reach my Town Home maximum level.
So I created this Excel file because I didn't found anything like that. Then, I added features over time.
This file is useful to me, especially to realize what I still have to create / upgrade, and perhaps it may be helpful for you too :confused:
To create my file, I used data from the Wiki (http://clashofclans.wikia.com) but there may be mistakes so do not hesitate to report them ;)
Criticism, suggestions or ideas for improvement are also welcome :cool:
Downloads:
File composition:
- Calculations:
- TO DO - Summary: An overview that allows you to see what remains to be done according to the Town Home level and what has already been done. Total costs and remaining time by Building category and Troops / Spells / Heroes
- TO DO - Details: A detailed view of what needs to be done according to the Town Hall level and what has already been done. All costs and time remaining for each building and Troops / Spells / Heroes
- Production: A view that shows the gains in resources based on the number and Gold Mines / Extractors / Drills levels and production time
- Raiding - Loots: A tool to calculate the potential gains and losses in online battle depending on stock quantities / Town Home levels / number of Trophies
- Troops Training: A tool that allows to know the cost and time of training troops depending on what we want to train and develop its training according to what we can do (Laboratory / Barracks / Dark Barracks levels)
- Data: (hidden tabs)
- Building: Buildngs creations / upgrades possible regarding the Town Hall level
- Upgrades - Spells & Troops: Spells / Troops upgrades possible regarding the Town Hall level
- Heroes: Spells upgrades possible regarding the Town Hall level
- Upgrades Costs: Costs and creations / upgrades costs of Buildings / Spells / Troops / Heroes
- Earnings & Storages: Gains and possible capacities depending on the Storages and Gold Mines / Extractors / Drills levels
- Trophy: Bonus and multiplier coefficient for raids regarding the Trophies amount
- Training Costs: Cost and time of training Troops + Laboratory / Barracks / Dark Barracks / Army Camps capacities
- Parameters: Main fields to fill in to use the file (Town Home level, amount of workers, Builinds / Spells / Troops / Heroes amounts and levels)
- Changelog: This view show the file evolution with all modifications which have been done regarding the previous versions
File utilization:
- Provide the information required in the "Parameters" tab for general calculations:
- Provide the information required in the "Raiding - Loots" tab for the feature that lets you know the potential gains and losses in online battle:
- Provide the information required in the "Troops Training" for the feature that allows to know the cost and time of training troops depending on what we want to train and develop their training:
- Finally, it is possible to choose the time display in "TO DO - Summary" and "Troops Training" tabs or the production period in the "Production" tab:
Screenshots:
So, for me, currently Town Home level 7, it looks like this:
Other option for downloading?
Hi are you able to post a link to another site I can download this from? For some reason probably something odd with my ISP but I am not able to download from the site you have the file on. Connection just continuously times out.
I would appreciate if anyone can help out or rehost.
Regards.
BB