Cost & Time Calculator - Know the costs & times left regarding your TH level

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:

• Latest version: Please look at the last message of this topic.
• v1.61: 09/07/2013 - http://xls.lu/93C3
• v1.60: 08/07/2013 - http://xls.lu/XK71
• v1.50: 02/07/2013 - http://xls.lu/bqbD
• v1.41 - FR: 02/07/2013 - http://xls.lu/4uOz
• v1.41: 27/06/2013 - http://xls.lu/87Eu
• v1.40: 27/06/2013 - http://xls.lu/QaJG
• v1.31: 26/06/2013 - http://xls.lu/4BA4
• v1.30: 25/06/2013 - http://xls.lu/06nH
• v1.23: 25/06/2013 - http://xls.lu/gLPF
• v1.22: 24/06/2013 - http://xls.lu/3JkD
• v1.21: 21/06/2013 - http://xls.lu/bo4r
• v1.20: 20/06/2013 - http://xls.lu/5Lhv
• v1.10: 19/06/2013 - http://xls.lu/83sU
• v1.01: 18/06/2013 - http://xls.lu/BrXD
• v1.00: 18/06/2013 - http://xls.lu/p32Z

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:
  
  • Town Home level (Cell: AV2)
  • Amount of workers (Cell: AW2)
  • Buildings amounts and levels (Cells: B6:W45)
  • Spells levels (Cells: Y6:AC45)
  • Normals Troops levels (Cells: AD6:AM45)
  • Dark Troops levels (Cells: AN6:AQ45)
  • Heroes levels (Cells: AS6:AT45)
  
  
• Provide the information required in the "Raiding - Loots" tab for the feature that lets you know the potential gains and losses in online battle:
  
  • Attack or Defense (Cell: B2)
  • Opponent Town Home level (Cell: C2)
  • Trophies amount (Cells: E2)
  • Ressources amount into Storages (Cells: B7:D13)
  • Ressources amount into Gold Mines / Extractors / Drills (Cells: E7:G13)
  
  
• 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:
  
  • Spells creations choices and amount (Cells: G5:G9)
  • Barracks levels (Cells: O2:R2)
  • Troops training choices and amount (Cells: O5:R14)
  • Dark Barracks levels (Cells: AA2:AB2)
  • Dark Troops training choices and amount (Cells: AA5:AB8)
  
  
• 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:
  
  • Time Desplay (Cell: B2)
  • Period (Cell: B2)

Screenshots:
So, for me, currently Town Home level 7, it looks like this:

• TO DO - Summary :
  http://www.hostingpics.net/thumbs/41..._41372676A.png
  
  
• TO DO - Details :
  http://www.hostingpics.net/thumbs/20..._20353454A.png
  
  
• Production :
  http://www.hostingpics.net/thumbs/43..._43388461A.png
  
  
• Raiding - Loots :
  http://www.hostingpics.net/thumbs/71..._71082625A.png
  
  
• Troops Training :
  http://www.hostingpics.net/thumbs/83..._83850539A.png
  
  
• Parameters :
  http://www.hostingpics.net/thumbs/59..._59651951A.png

Thanks for posting this.

In the To Do summary view, it is easier to understand using days/hours rather than just hours.

Good idea. Doesn't look great on my iphone (small screen), but I think it will look much better on my laptop. I will download it when I get home. Also is that website in French?

Before i download it does it do this?
Calculate for a th9 a cannon going from 9 to 11?
Aka 9 days and 4.8 million? Or is it just 9-10? aka 4 days 1.6 mil


Edit: I downloaded it. I have no idea what to do..

Edit of an Edit: Put in all my totals. have 505 days for one builder. I know its 101 days but how do i actually get it to show that?

I love the wiki always does me good!

Alright i fixed the builder thing when its suppose to be divided by 5. But now its stuck at 101 days even though my total time for one is 428 not 505..

Quote:

---

Originally Posted by yesup

Thanks for posting this.

In the To Do summary view, it is easier to understand using days/hours rather than just hours.

---

Yes you are right :)
I edited my file.


Here is a new version: http://xls.lu/n6g1



It looks like this now :
http://img4.hostingpics.net/pics/66270211A.png

Quote:

---

Originally Posted by Dualsabers04

Good idea. Doesn't look great on my iphone (small screen), but I think it will look much better on my laptop. I will download it when I get home. Also is that website in French?

---

Which website ?
I'm french so the Excel formulas are written in french but I supposed thre is no problem to read the file.

Quote:

---

Originally Posted by Aprixius

Before i download it does it do this?
Calculate for a th9 a cannon going from 9 to 11?
Aka 9 days and 4.8 million? Or is it just 9-10? aka 4 days 1.6 mil

---

Yes it does.
If you are TH level 9, so you can have 5 cannons max and the lvl max is 11.
If your cannons are only lvl 9, the Excel file will tell you that you need to upgrade 5x cannons to +10 and 5x cannons +10 to +11

It will be like this :
http://img4.hostingpics.net/pics/38045043A.png

Quote:

---

Originally Posted by Aprixius

Edit: I downloaded it. I have no idea what to do..

---

I edited the file so now people can only edit cells which have to be edit, maybe it will be easiest to understand.
The cells that must be edited have a GREY FONT

• On the "TO DO" tab : You have tu put the amount of your buildings/upgrades (NB - Columns B & M).
• On the "Parameters" tab : You have to indicate which TH level you are and also how many builders do you have.

Quote:

---

Originally Posted by Aprixius

Edit of an Edit: Put in all my totals. have 505 days for one builder. I know its 101 days but how do i actually get it to show that?

---

Quote:

---

Originally Posted by Aprixius

Alright i fixed the builder thing when its suppose to be divided by 5. But now its stuck at 101 days even though my total time for one is 428 not 505..

---

I dont understand your problem. Maybe you can upload your configuration here so I can help you.

nice work

i think the elixir storage price is wrong

Yes you are right.
Same for the gold storage.

I've fixed it.

http://xls.lu/uqsV


Thanks you ;)

Nicely done!!! Very useful indeed. Thanks for sharing this!

Your costs on Gold and Elixir storages are wrong by the way. ;)

I'll wait for the final changes then I'll download :P looking forward to it!

Thanks you.
It's already fixed on this version ;)


http://xls.lu/uqsV

Quote:

---

Originally Posted by sednanref

Yes you are right.
Same for the gold storage.

I've fixed it.

http://xls.lu/uqsV


Thanks you ;)

---

Looking good, maybe run a few things through an English spell checker. Nothing major, just cosmetic. ;)

Troups = Troops
Ressources = Resources
Neccessary = Necessary

A few other suggestions:
Offensives Buildings = Army Buildings
Defensives Buildings = Defenses
Ressources Buildings = Resource Buildings

Im on an iOS device and for some reason it is in Spanish. Any idea why? How to change it?

http://is.gd/F1BA0J


Initial Reaction:

http://3.bp.blogspot.com/-nU8O8xLuSv...0/s320/112.jpg

http://is.gd/F1BA0J


My initial Reaction:

http://fc07.deviantart.net/fs71/i/20...on-d4b83tw.png

I love this file! Thank you so much!

Quote:

---

Originally Posted by Conte

I love this file! Thank you so much!

---

Thanks you :o




Here is the latest update :cool:

Latest version: COC - Cost & Time Calcultator v1.7.xlsx => http://xls.lu/34ir

http://img15.hostingpics.net/pics/87415670A.png



The "Parameters" tab looks like this now:
http://img15.hostingpics.net/pics/13371891A.png

Quote:

---

Originally Posted by sednanref

Thanks you :o




Here is the latest update :cool:

Latest version: COC - Cost & Time Calcultator v1.7.xlsx => http://xls.lu/34ir

http://img15.hostingpics.net/pics/87415670A.png



The "Parameters" tab looks like this now:
http://img15.hostingpics.net/pics/13371891A.png

---

Nicely done, this is much better!!!! Good job. ;)

A great work will use it. Thank you

Thanks ;)


Following the maintenance, 1 more Gold Mine and Elixir Collector at TH level 10.

Latest version : COC - Cost & Time Calcultator v1.8.xlsx => http://xls.lu/D7nP

http://img15.hostingpics.net/pics/70915918A.png

Excuse my blatant noobiness - how do I edit it??

Quote:

---

Originally Posted by TheSwordwalker

Excuse my blatant noobiness - how do I edit it??

---

I dont understand your problem ? :S
Just follow the instructions in the "Parameters" tab.



Anyway,

Here is the last version

Latest version : COC - Cost & Time Calcultator v1.9.xlsx => http://xls.lu/aBod

http://img15.hostingpics.net/pics/90814265A.png



You can change the display time on the "TO DO - Summary" tab, here :
http://img15.hostingpics.net/pics/92265067A.png

http://s16.postimg.org/66mwv5fs5/screenshot_32.png
Golem parameter not working. Tried with level 1 and 2 golems.

http://s16.postimg.org/vqp71l15x/screenshot_33.png
Total Gold and Elixir is a bit confusing, I suggest using comma in between and omit the space at the end. E.g 117,136,000

The Jump Spell shows as available at TH8, which it's not.

You might want to provide some instructions to "import" data from previous spreadsheets, i.e. copy and paste? Having to redo the spreadsheet every time a new version is released will annoy people.

Quote:

---

Originally Posted by Brlala

http://s16.postimg.org/66mwv5fs5/screenshot_32.png
Golem parameter not working. Tried with level 1 and 2 golems.

---

Thanks you, indeed there was a mistake. I've fixed it.

Quote:

---

Originally Posted by Brlala

http://s16.postimg.org/vqp71l15x/screenshot_33.png
Total Gold and Elixir is a bit confusing, I suggest using comma in between and omit the space at the end. E.g 117,136,000

---

Uhh yeah I can see that :S I didn't know how it looks for english users.
It's because I'm french and I use the french format. This should be displayed like that : 1 000 000 000
I tried to change it on the new version. Can you tell me if it looks better ?

Thanks.


Latest version : COC - Cost & Time Calcultator v2.0.xlsx => http://xls.lu/XBYM

http://img4.hostingpics.net/pics/30769842A.png

Quote:

---

Originally Posted by rynoster

The Jump Spell shows as available at TH8, which it's not.

---

Yes I understand what you mean because when you use the file, if you indicate that you are TH level 8, the cells are not red for Jump Spell.
But you can see that if you try to put 1 on the Cell, the column become orange (because actually, it's not possible to create it).

I just took the data from the wiki and when I did it I saw this "mistake".
Indeed, this just show that the upgrade is available, even if the creation is not possible.

If you look at the wiki, you will see that :
- you need spell factory level 4 (so TH 9) to create a Jump Spell.
- you just need the laboratory level 6 (so TH 8) to upgrade Jump Spell to +2...

http://img4.hostingpics.net/pics/92676139A.png

Maybe it's a mistake from SuperCell, Laboratory level 7 (TH level 9) required would have been more understanding.

Quote:

---

Originally Posted by rynoster

You might want to provide some instructions to "import" data from previous spreadsheets, i.e. copy and paste? Having to redo the spreadsheet every time a new version is released will annoy people.

---

This is very simple now since the version 1.7
You just have to copy the cells from B5 to AT40 from you old file and put them in the same place on the new one.

Quote:

---

Originally Posted by sednanref

If you look at the wiki, you will see that :
- you need spell factory level 4 (so TH 9) to create a Jump Spell.
- you just need the laboratory level 6 (so TH 8) to upgrade Jump Spell to +2...

http://img4.hostingpics.net/pics/92676139A.png

Maybe it's a mistake from SuperCell, Laboratory level 7 (TH level 9) required would have been more understanding.

---

I think it's a mistake on the wiki to be honest. You cannot research something you have not yet unlocked. I do not have the option to research jump spell at TH8, spell factory and laboratory maxed out.

http://i.imgur.com/DQK4OmA.jpg

Quote:

---

Originally Posted by sednanref

This is very simple now since the version 1.7
You just have to copy the cells from B5 to AT40 from you old file and put them in the same place on the new one.

---

This I know, other users might not be Excel guru's like you though. Just an observation from my side.

I made some changes and add features since the last release.
Also, I renamed the file and the version.


Latest version : COC - Calcultator v1.6.xlsx => http://xls.lu/XK71


http://img4.hostingpics.net/pics/28341677A.png

Quote:

---

Originally Posted by sednanref

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:

• Latest version: Please look at the last message of this topic.
• v1.61: 09/07/2013 - http://xls.lu/93C3
• v1.60: 08/07/2013 - http://xls.lu/XK71
• v1.50: 02/07/2013 - http://xls.lu/bqbD
• v1.41 - FR: 02/07/2013 - http://xls.lu/4uOz
• v1.41: 27/06/2013 - http://xls.lu/87Eu
• v1.40: 27/06/2013 - http://xls.lu/QaJG
• v1.31: 26/06/2013 - http://xls.lu/4BA4
• v1.30: 25/06/2013 - http://xls.lu/06nH
• v1.23: 25/06/2013 - http://xls.lu/gLPF
• v1.22: 24/06/2013 - http://xls.lu/3JkD
• v1.21: 21/06/2013 - http://xls.lu/bo4r
• v1.20: 20/06/2013 - http://xls.lu/5Lhv
• v1.10: 19/06/2013 - http://xls.lu/83sU
• v1.01: 18/06/2013 - http://xls.lu/BrXD
• v1.00: 18/06/2013 - http://xls.lu/p32Z

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:
  
  • Town Home level (Cell: AV2)
  • Amount of workers (Cell: AW2)
  • Buildings amounts and levels (Cells: B6:W45)
  • Spells levels (Cells: Y6:AC45)
  • Normals Troops levels (Cells: AD6:AM45)
  • Dark Troops levels (Cells: AN6:AQ45)
  • Heroes levels (Cells: AS6:AT45)
  
  
• Provide the information required in the "Raiding - Loots" tab for the feature that lets you know the potential gains and losses in online battle:
  
  • Attack or Defense (Cell: B2)
  • Opponent Town Home level (Cell: C2)
  • Trophies amount (Cells: E2)
  • Ressources amount into Storages (Cells: B7:D13)
  • Ressources amount into Gold Mines / Extractors / Drills (Cells: E7:G13)
  
  
• 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:
  
  • Spells creations choices and amount (Cells: G5:G9)
  • Barracks levels (Cells: O2:R2)
  • Troops training choices and amount (Cells: O5:R14)
  • Dark Barracks levels (Cells: AA2:AB2)
  • Dark Troops training choices and amount (Cells: AA5:AB8)
  
  
• 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:
  
  • Time Desplay (Cell: B2)
  • Period (Cell: B2)
  
  

Screenshots:
So, for me, currently Town Home level 7, it looks like this:

• TO DO - Summary :
  http://www.hostingpics.net/thumbs/41..._41372676A.png
• TO DO - Details :
  http://www.hostingpics.net/thumbs/20..._20353454A.png
• Production :
  http://www.hostingpics.net/thumbs/43..._43388461A.png
• Raiding - Loots :
  http://www.hostingpics.net/thumbs/71..._71082625A.png
• Troops Training :
  http://www.hostingpics.net/thumbs/83..._83850539A.png
• Parameters :
  http://www.hostingpics.net/thumbs/59..._59651951A.png

---

I've updated the first message of the topic.
It explains how to use the file and give an overview.


Otherwise, latest version:
v1.61 : 09/07/2013 - http://xls.lu/93C3

I'm a bit of an excel nerd so I created some of these things on my own in excel but your file is much more detailed. Thanks for sharing it!

Quote:

---

Originally Posted by AfroNinja06

I'm a bit of an excel nerd so I created some of these things on my own in excel but your file is much more detailed. Thanks for sharing it!

---

Thanks you :)
Feel free to improve it and share it back ;)

I'm also a math nerd, bothering my clanmates with calculations but really mate, how can i say it fast ?

YOU ARE A GENIUS !

Really thanks for sharing this job with us.

Dzy.

Here is the latest version.

It's a major release because I finally added the feature I wanted to do. The Planning.

How does it works?

• You have to complete the "Parameters" tab first. After, you can go to the "Planning" tab and you just click "Create Planning"
• Now you wait a little (maybe few minutes ^^) because nop, I'm not an Excel God and my code sux.
• Once the program has finished to run, it generates un small planning with all constructions/upgrades left with the cost/time related.
• After you just have to select the dates you want for your constructions/upgrades.

It is possible to edit:

• the start date
• the step (usefull for the constructions/upgrades which can be count on an entire day (e.g. the Barbarian King),
• the highlight period (it display the selected period on the planning and calculate the required ressources for the next 4 days.

Latest version : COC - Calcultator v1.80.xlsm => http://xls.lu/4xK8


http://img11.hostingpics.net/pics/62099861A.png


The planning looks like this :
http://img11.hostingpics.net/pics/72355874A.png


Enjoy ;)

Under Parameter you wrote Town Home instead of Townhall. Confused me a little bit.

Quote:

---

Originally Posted by Pixova

Under Parameter you wrote Town Home instead of Townhall. Confused me a little bit.

---

Yes you're right.

Corrected : http://xls.lu/EXZ3

:)

Another small thing. It's Barracks, not Barrack, same with Dark Barracks.

Thanks, corrected too.


Also.... The planning feature should works now...
My code was wrong :

I put the wrong file name

Code:

---

Set WB_COC = Workbooks("COC - Calculator v1.81.xlsm")

---

Now it is :

Code:

---

Set WB_COC = Workbooks("coc-calcultator-v1-81.xlsm")

---

It should works fine now ^^


Latest version : COC - Calcultator v1.81.xlsm => http://xls.lu/F9Ob


Planning looks like this. You can create your own one just by pressing "Create Planning"
http://img15.hostingpics.net/pics/32546461A.png

Nice work. Although I'm a bit confused whether I should be using v1.81 or v2.0.

I found a bug on sheet 'TODO - Details' in both v1.81 and v2.0. Cell C108 is missing a formula, so it is not able to sum a total cost for Level 9 Walls. If I copy C107 to C108 and C109 then it is happy. Unfortunately I'm not looking forward to raising 250,000,000 and then 750,000,000 gold for walls. :(

Oh thanks you ! Well seen. I missed that formulas.

It's corrected now ;)


And you should use the latest version which is now 1.82.

coc-calcultator-v1-82.xlsm : http://xls.lu/5qpz

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

the links dont work for downloading.....any other links?

It appears xls.lu is entirely down. It just hangs for a minute and then returns that it's unavailable. This is a problem with the site. From Safari I'm getting a 502 bad gateway error.

Can someone please fix the links? They don't work.

THIS. I need!!! Need to plan my TH8!!

Fixed the link since the OP it's not doing it. You are welcome.

https://docs.google.com/file/d/0B1eL...it?usp=sharing

Although your excel skills are massively evident. I will not download the sheet for fear of falling into a major depression after learning the sheer hours it will take to make it to th10 fully upgraded

Quote:

---

Originally Posted by Shadowof16

Although your excel skills are massively evident. I will not download the sheet for fear of falling into a major depression after learning the sheer hours it will take to make it to th10 fully upgraded

---

Spoiler, to upgrade all buildings to TH10 from the very beginning takes at least two years if you are perfectly optimal and spend gems on nothing.

Heyyy sorry guys, I was on vacation :o

So here is the latest version with the last Supercell upadte (with Witch).
I changed the host for MEGA since the previous links are dead :(


Latest version : COC - Calcultator v1.90.xlsm
=> MEGA link
(Dont forget to change the language on "Parameters" tab to English)


PS: Thanks SirRudolf for reuploading the previous version btw ;)

Very helpful mate. Thanks for sharing.

Downloaded it but I guess I'm not smart enough to figure it out. Any thoughts on maybe doing a youtube tutorial?

Oh and for some reason the first tab "planning" only stays on lvl 8?

Thanks for your help!

Blide, the second to last tab in Excel sheet says Parametres, that is the Parameters tab that you go to and in the upper right hand side there is a Box that you can change the language into English instead of French. Then just follow his instructions on the first page of this thread to fill everything out. There are pictures if it is confusing.

I do not think the Town Hall level on Planning Tab or Raiding-Loots tab is connected to the Parameter's Tab when you change Town Halls. Is there any way you can add a stored in storages section in Parameters so that we can see how much we still need to raid/collect in TO DO Summary and Details? Thanks.

By the way, really appreciate the spreadsheet and can't wait to see how many millions of resources it will take to max out TH lvl 8!

I've downloaded it and set language to English in parameters tab, but it gives me an error and I cant switch.

Quote:

---

Originally Posted by blide

Oh and for some reason the first tab "planning" only stays on lvl 8?

---

Thanks. That's a small mistake. Will be fixed on the next version.

Quote:

---

Originally Posted by BillChang

Is there any way you can add a stored in storages section in Parameters so that we can see how much we still need to raid/collect in TO DO Summary and Details? Thanks.

---

Yes I can do that on the next version if you want ;)

Quote:

---

Originally Posted by Jellidonutz

I've downloaded it and set language to English in parameters tab, but it gives me an error and I cant switch.

---

Can you tell me what was the error or do a printscreen?
By the way, can you check if the filename is correct? It should be : "COC - Calcultator v1.90.xlsm". Otherwise the program wont works.

yes I downloaded the correct version, it says "Run-time error '9': subscript out of range"

not sure if its a problem on my end or the excel file.

If you click on "Debug".

Do you see this ?

http://img4.hostingpics.net/pics/395123Sanstitre.png

Quote:

---

Originally Posted by sednanref

If you click on "Debug".

Do you see this ?

http://img4.hostingpics.net/pics/395123Sanstitre.png

---

Yes I do, here is what it shows:

Option Explicit
Public WB_COC As Workbook
Public WS, WS_Plan, WS_Todo_Rep, WS_Todo_Det, WS_Prod, WS_Comb, WS_Form, WS_Bati, WS_Amel, WS_Hero, WS_Cout_Ame, WS_Gain, WS_Trop, WS_Cout_For, WS_Cale, WS_Trad, WS_Para_Admin, WS_Para, WS_Jour As Worksheet
Public Plage, c, Remplacement As Range
Public msg As String
Public NumLigne, FinLigne, DernLigne, NumColonne, FinColonne, x, y, z, Ligne As Integer
Public Var1, Var_Or, Var_Elixir, Var_Elixir_Noir, NB As Long
Public Var, Upg As Variant
Sub D閏laration_Onglets()
Set WB_COC = Workbooks("COC - Calcultator v1.90.xlsm")


On Error GoTo English


Set WS_Plan = Worksheets("Planning")
Set WS_Todo_Rep = Worksheets("?Faire - R閏apitulatif")
Set WS_Todo_Det = Worksheets("?Faire - D閠ails")
Set WS_Prod = Worksheets("Production")
Set WS_Comb = Worksheets("Combats - Loots")
Set WS_Form = Worksheets("Formation de Troupes")


Set WS_Bati = Worksheets("B鈚iments")
Set WS_Amel = Worksheets("Am閘iorations - Sorts & Troupes")
Set WS_Hero = Worksheets("H閞os")
Set WS_Cout_Ame = Worksheets("Co鹴s des Am閘iorations")
Set WS_Gain = Worksheets("Gains et Stockage")
Set WS_Trop = Worksheets("Troph閑s")
Set WS_Cout_For = Worksheets("Co鹴s de Formation")
Set WS_Cale = Worksheets("Calendrier")
Set WS_Trad = Worksheets("Traduction")


Set WS_Para_Admin = Worksheets("Param鑤res - Admin")
Set WS_Para = Worksheets("Param鑤res")


Set WS_Jour = Worksheets("Journal des Modifications")
Exit Sub


English:
Set WS_Plan = Worksheets("Planning")
Set WS_Todo_Rep = Worksheets("TO DO - Summary")
Set WS_Todo_Det = Worksheets("TO DO - Details")
Set WS_Prod = Worksheets("Production")
Set WS_Comb = Worksheets("Raidings - Loots")
Set WS_Form = Worksheets("Troops Training")


Set WS_Bati = Worksheets("Buildings")
Set WS_Amel = Worksheets("Upgrades - Spells & Troops")
Set WS_Hero = Worksheets("Heroes")
Set WS_Cout_Ame = Worksheets("Upgrades Costs")
Set WS_Gain = Worksheets("Earnings & Storage")
Set WS_Trop = Worksheets("Trophies")
Set WS_Cout_For = Worksheets("Training Costs")
Set WS_Cale = Worksheets("Calendar")
Set WS_Trad = Worksheets("Translation")


Set WS_Para_Admin = Worksheets("Parameters - Admin")
Set WS_Para = Worksheets("Parameters")


Set WS_Jour = Worksheets("ChangeLog")
End Sub

I mean... which line is highlighted ?

the same line as you have posted

So, like it said before....

Quote:

---

Originally Posted by sednanref

By the way, can you check if the filename is correct? It should be : "COC - Calcultator v1.90.xlsm". Otherwise the program wont works.

---

that means that the name of the file is not exactly : "COC - Calcultator v1.90.xlsm"

On the next version, I would not make a verification on the filename so you have the problem anymore but meanwhile, you have to rename your file.

I changed the filename, but now I get a new error:

English:
Set WS_Plan = Worksheets("Planning")
Set WS_Todo_Rep = Worksheets("TO DO - Summary")
Set WS_Todo_Det = Worksheets("TO DO - Details")
Set WS_Prod = Worksheets("Production")
Set WS_Comb = Worksheets("Raidings - Loots")
Set WS_Form = Worksheets("Troops Training")

where the bold underline is now highlighted in yellow

I don't know what's happening with you :S

Here is the new version :

Latest version : COC - Calcultator v1.91.xlsm
=> MEGA link

Maybe it's better :rolleyes:

haha I dont know either...

the updated version gives me the same error :confused:

Great job, the only bug I have found, with lvl 5 DE barracks under to-do summary and to-do details it says they need to be built.

Also, just a suggestion, under troop training could we get a total count of each troop, I.e. 30 total archers, 40 total barbs

COC - Calcultator v1.91.xlsm is a great tool, thank you very much!

There might be an error in sheet "TO DO - Summary" as it seems like the Barracks are not included in Army Buildings calculations. I guess the formulas in cell I12, J12 and K12 should be changed from =SUM(K8:K11) to =SUM(K7:K11).

Thank you sednanref!

I love your tool! The TO DO sections is very handy! However, in my experience, the planning tab is difficult to use.

Keep doing what you are doing :) The regular updates always have some cool new features ::rolleyes:

First let me say the calculator looks great. The problem is I can't open the file. When I click on a download it takes me to a share trading site. Would you please send the current link again?

Gengis

how can I change it to english?

Many online simulators like this that are much better

There is a problem in the TO DO summary. In the category Army Buildings, the sum is incorrect. The cost and time from the barracks is ignored in the totals. I hope you see what i mean

The logic on level 6 healing spell is wrong. I can upgrade to healing level 6 with a laboratory level 7 at TH9, I don't need to upgrade to lab level 8 or TH10. The COC wiki confirms this.

I know it's weird because for level 6 lightning you have to be at TH10.

Quote:

---

Originally Posted by Jellidonutz

haha I dont know either...

the updated version gives me the same error :confused:

---

I dont know what to do for you :S
Maybe you can try an another computer ?

Quote:

---

Originally Posted by Ratt

Great job, the only bug I have found, with lvl 5 DE barracks under to-do summary and to-do details it says they need to be built.

Also, just a suggestion, under troop training could we get a total count of each troop, I.e. 30 total archers, 40 total barbs

---

Thanks for the bug report, will be fixed ;)
And for the suggestion, will be added ;)

Quote:

---

Originally Posted by DoubleIron

COC - Calcultator v1.91.xlsm is a great tool, thank you very much!

There might be an error in sheet "TO DO - Summary" as it seems like the Barracks are not included in Army Buildings calculations. I guess the formulas in cell I12, J12 and K12 should be changed from =SUM(K8:K11) to =SUM(K7:K11).

---

Thanks you for this report. I will fix this on the next version ;)

Quote:

---

Originally Posted by DenEmilio

Thank you sednanref!

I love your tool! The TO DO sections is very handy! However, in my experience, the planning tab is difficult to use.

Keep doing what you are doing :) The regular updates always have some cool new features ::rolleyes:

---

Thanks you :)
Unfortunalety, I can't spend more time at this moment to add new features :S

Quote:

---

Originally Posted by Gengis

First let me say the calculator looks great. The problem is I can't open the file. When I click on a download it takes me to a share trading site. Would you please send the current link again?

Gengis

---

I don't know why you have this problem.
Can you try with the latest version (v2.0 - link below) and tell me if this happen again ?

Quote:

---

Originally Posted by camroy14

how can I change it to english?

---

In "Paramètres" tab, go to cell AY2 and change "Français" to "English".

Quote:

---

Originally Posted by ClasherOfClans

Many online simulators like this that are much better

---

For training troops yes but I could'nt find anything to calculate the time left and the needs of Gold/Elixir/Dark Elixir.
Did you even download the file ? :confused:

Quote:

---

Originally Posted by DenEmilio

There is a problem in the TO DO summary. In the category Army Buildings, the sum is incorrect. The cost and time from the barracks is ignored in the totals. I hope you see what i mean

---

Yes thanks you, DoubleIron have already reported it before. It's fixed on the new version.

Quote:

---

Originally Posted by deviladv

The logic on level 6 healing spell is wrong. I can upgrade to healing level 6 with a laboratory level 7 at TH9, I don't need to upgrade to lab level 8 or TH10. The COC wiki confirms this.

I know it's weird because for level 6 lightning you have to be at TH10.

---

Thanks you, it's fixed on the new version.

Thanks you for your support.
I'm glad the file is usefull for some people ;)


Here is the latest version with the updates and some fixes.

Latest version : COC - Calcultator v2.00.xlsm
=> MEGA link


http://img11.hostingpics.net/pics/36056240A.png

Only I write to be grateful for your great work, always I am attentive to the updates. Thank you,

Great work, thank you.

Does it works with OpenOffice?
I can't change language to English..

Quote:

---

Originally Posted by iEryX

Does it works with OpenOffice?
I can't change language to English..

---

No sorry, you need Microsoft Office.

Thanks for the calculator, by far one of the best ones ive seen :D

I've been using this for a while now and I have to say that so far it's been working extremely well! Great work, keep it up!

Why is it in French? Is there a way to make it English?

following along.

Quote:

---

Originally Posted by sednanref

Thanks you for your support.
I'm glad the file is usefull for some people ;)


Here is the latest version with the updates and some fixes.

Latest version : COC - Calcultator v2.00.xlsm
=> MEGA link


http://img11.hostingpics.net/pics/36056240A.png

---

Thank you for your great work. Merci
But how can i open a .xlsm file?

Quote:

---

Originally Posted by Vesylum

Why is it in French? Is there a way to make it English?

---

You can change your game to French then you can use it.

Quote:

---

Originally Posted by iEryX

Does it works with OpenOffice?
I can't change language to English..

---

I don't have Office either. Can someone calculate for me please? I have TH 9, 5 workers
Xbow: LV2 and LV3;
mortar: LV7x3;
Archer tower: LV10x6;
Cannon: LV10x5;
HiddenTesla: LV6x4;
Air defense: LV5x3, LV4x1;
Wizard Tower:LV7x4;
Walls: LV3x5, LV6x96, LV7x87, LV8x62
Other buildings are maximized at TH 9 level

Archer/Barbarian/Giant LV6;
WB/Balloon/Goblin/Wizard LV5
Healer/Dragon/Minion: LV3
Pekka: LV2
Hog/Valkyrie/Golem/Witch: LV1

Lightning/Healing: LV5
Rage: LV4
Jump: LV1

King: LV8, Queen: LV 7

Thank you

I don't have Office either. Can someone calculate for me please? I have TH 9, 5 workers
Xbow: LV2 and LV3;
mortar: LV7x3;
Archer tower: LV10x6;
Cannon: LV10x5;
HiddenTesla: LV6x4;
Air defense: LV5x3, LV4x1;
Wizard Tower:LV7x4;
Walls: LV3x5, LV6x96, LV7x87, LV8x62
Other buildings are maximized at TH 9 level

Archer/Barbarian/Giant LV6;
WB/Balloon/Goblin/Wizard LV5
Healer/Dragon/Minion: LV3
Pekka: LV2
Hog/Valkyrie/Golem/Witch: LV1

Lightning/Healing: LV5
Rage: LV4
Jump: LV1

King: LV8, Queen: LV 7

Thank you[/QUOTE]

http://i40.tinypic.com/2e4cinn.jpg

Quote:

---

Originally Posted by Ratt;961061

[IMG

http://i40.tinypic.com/2e4cinn.jpg[/IMG]

---

thank you Ratt! 229 days to go!

Quote:

---

Originally Posted by badKARMA

thank you Ratt! 229 days to go!

---

145 days with 5 builders

everyones screen shots are in english and i cant get mine out of french
help?

For those of you who need it to be in english, go to the parameters tab and look for the language setting, it's next to TH LVL and workers. Set it to English.

Also if you have openoffice or some non microsoft office product it won't work. The spreadsheet is heavy with macros and it just won't work without a full copy of office. I tried to find several free tools with my ipad and could not find one and the author has already stated it won't work with openoffice.

Bupm! .

There seems to be an issue with you v2.00-1 Calculator when using the planning tab and the parameters. It seems when you enter the information to the TO DO section It doesn't carry over to the parameters which then doesn't transfer over to the planning section.

Mortar already up to level 8 in the game but the sheet is still not updated for it :confused:

At first I thought it was so messed up until it worked out, and wow! Amazing! :D but... how to make it english?

Is it only me or does the "Create planning" ends with "Run-time error 1004: AutoFill method of Range class failed" when you switch to TH10 in Preferences? (Worked fine with TH8/9)

I've also tested 1.80, 1.91 version and it's the same there too.

Updating the file with new Building levels seems to be easy enough, but I am stuck with this now :-(

There was an updated on the game :)

thanks for this excellent calculator!

Please update some new traps.

New wizard tower form 5 to 6 only need 6 days instead of 8. Please fix it.

I dont have Excel on my computer. Will this still work partially on my phone?

I get cannot find file errors and the last message of the topic doesn't say anything.

The latest version does nothing!!! I have entered all my details and there is no option to see the time taken!!!!!!

Quote:

---

Originally Posted by thebronzedestroyer

The latest version does nothing!!! I have entered all my details and there is no option to see the time taken!!!!!!

---

I had the same problem. There are sheets before the Parameters sheet that are hidden. You have to click on a little yellow box to the left of the parameters sheet name.

I have other questions. Is the time left meant for maxing your current TH level or for getting to max TH level?

Also does total time take into account number of builders? I am confused by timer per builder.

For example, I put TH 7 stuff and time left is 407 days but time per builder is 84 days. Does this mean it will take me 84 days to get to TH 8 or to TH 10.

awesome tool. If I'm not mistaken, i think it calculates based on 1 builder at a time. Therefore the total times to complete are considerably Higher. I don't think its gonna be easy to have a formula to calculate for more than one builder at a time given the difficulty in factoring in the time start difference of each builder. That would be even better though.