Hi guys & girls I have updated my excel spreadsheet/build calculator to a Version2. What it does is pre-calculate your Stats based on the variety of buildings you keyed in, your true strength based on your Allies' stats and also the Permanent Item Percentage Bonuses. This excel is Great if you have yet to BC. (Thanks to them Tier4 buildings, I believe most of us have yet to ) The link is here: http://www.tinyurl.com/DreamKingdom Changes includes: * Tier4 Buildings * Permanent Item Bonus * (Fixed) Static Ally Stats * Unit Cap display * Gauge How much you Should Cost based on your Stats * Tier1 Attack Buildings not included. (Don't see a point in adding them) Link to my old thread is here, FORETELL Your Desired Kingdom I'm looking forward to your comments and input. I apologize in advance if there are any errors but do tell me about it so it can be fixed. ** This is an excel application, so it is best viewed using Microsoft Excel. You can use Google Docs but it will not 'look' correct You can also use iPhone App DocsToGo. (it's not free tho) ** This excel is the creation of THE great guys in NEMESIS. In particular; AntiHero, DarthJago, WakluJBond & Sultan_Firauuun ** Credit goes to Zarrow, StoneFord & Toasted-Donkey for their excellent informations on the new Tier4 buildings. Peace
I like your spreadsheet. Thanks for the credit. I am still unclear on the bonus to allies numbers and their source. I see differing numbers. I am confident about the strength. I am working on version 2.1 which fixes some errors.
You forgot the plunder cap.... DD: or did they not release that info yet? also, I'd just like to point out that the stats that are displayed are not the real stats but rather .02 of the real stats. And also, the stat bonuses from allies adds directly to your real stats and stays the same even if you lose troops. For example, if you have 518k attack (full subs) you're real stats would be that x50= around 25.90m attack. An ally that has 518k attack adds directly to that 25.9m and stays as 518k. It is also true that you're basic stats from your troops decreases as your troops decreases but your ally stats stays the same. Basically you mixed up the calculation for the real stats and put it on ally stats. (the key your ally stat bonuses here and your actually ally stat bonus boxes) (thank you tmh for all these info in his guide xD) I'd like to see a the second issue more rather than the first one since it's easier to understand your bonuses to allies than your real stats. And ppl basically see the bonuses to allies rather than the real stats. but it would be good to make a change in the first one 2. I would like to help but unfortunately, I am not at the level of creating an advanced excel spreadsheet yet. x.x Good day
Hi SNOWGENIUS Thanks for ur input and statistics that you provide is absolutely true. But I have my reasons as to why i did the spreadsheet as it is. Lemme try to explain them based on your queries. -1- I did not include the plunder cap on purpose. Too much varieties to factor in. ie. It varies when different number of pots are used by the opponent, or/and when attacking different levels of opponents. If an official list does come out, i might include them. -2- As to the real stats that you mentioned, instead of scaling my "Bonus to Allies" stat UP to match the "Bonus From Allies", I scaled the "Bonus From Allies" DOWN... Vice-Versa will still show your strength. But i opt to standardize all stat to match the "Bonus to Allies" stat simply because it is using smaller numbers (easier to remember... Imagine all those stats in millions. I'll have a headache), and also, you can have an easier comparison with other opponents when you view their profiles because what you see in their profiles are "Bonus to Allies" stats. -3- Also to note that the downscaled "Bonus from Allies" stat is STATIC. Meaning It stays the same and does not decrease when your troops decrease. (as per what you suggested bro.) Try keying in, say, 1,000,000 in the Ally Stat Bonus column and do not key in any Building quantity. You will then see on the top right where "Your Strength based on Troops Quantity" is, that the amount corresponding to that 1mil you keyed in will show 20,000 throughout. Meaning to say, its constant/static/same. Hopefully i clarify your queries, and explain why i did what i did.... and im sorry readers for being long-windered. Its a habit of mine.
Snow here ah ok that make sense. So instead of multiplying up the personal stats, you divided the ally bonus down ok I get it now lulul. Same difference then. Aite thx bro on the reply.
Found a problem, but first good work! I use something similair I built ( but I calculate on the actual stregths not the bonus to allies) and I also include pot selection in an additional tab. However my attack building def isn't being calculated right on your spreadsheet: my bonus to allies 669,209 atk 607,094 def according to your sheet 660,206 atk 563,894 def build: Troop buildings only spies look ok Cursed foundries 3xL2 1xL3 titains lair 1xL3 circle of elements 5xL2 1xL3 either the devs or you are wrong, I unlocked your workbook (there's a commonly available macro for doing that) and audited your formulas and everything looked ok ( I'm analyst irl) so I'm wondering if it's the devs or if there is an unmentioned added bonus to Titans's lair level three, because until I added that building just now your sheet was dead on I beleive. Just a heads up, again I'm not criticising, excellent job! Just pointing out an onconsistancy I noticed!
Edit: type-oh your sheet calculated my attack bonus to allies as 669,206 correctly I just typed it wrong sorry for any confusion.
The def bonus to allies is still wrong though and i still camd find anything wrong with your spreadsheet!!!!!!!!