DeletedUser7719
For the past month or so, I decided to get back to calculating damages on units. I already knew it was just ratios and whatnot, but it seems that the spots between each change were not really easy numbers that I could simply say or give hence:
How it works:
Hopefully, this is pretty straightforward, but I guess I'll make this more of a guide.
First off, the only numbers you can edit are the ones without the diagonal stripes on it. If you want to get rid of these diagonal bars, go to "View" and uncheck protected ranges (they still will be un-editable, but it does make it look more smooth
).
Description for each cell:
You cannot add the base and other bonus together with a GB boost. The Other Bonuses are NEVER affected by the boost. Note that hovering over a unit on the bottom bar will give you the defense with the GB boost, so I would just put that value and set the GB bonus to zero (you still need to add the other unit/terrain bonuses ). Chivalry and Call of Duty is also automatically added to the defense stat at the bottom bar.
If you don't already have basic Excel experience, you can make a cell add values for you by first putting an equal sign "=" then put in the equation you want (ex: you can put "=26+25" for the unit/terrain defense of a Rapid Fire Cannon with a dugout bonus against a heavy unit)
Example:
Let's say I started this battle:
I already know that most of my (unboosted) units can get hurt from a full-powered longbow, but I want to test how much damage a battle tank will take from it just in case, so I enter this data:
*longbow's attack known from hovering over it at the bottom bar
You'll see that there is still a chance at it putting a dent in the tank (0-2 damage). Now, let's see how much it'll take to make longbow useless against that tank, so I put 1 under Damage Dealt and going up one-by-one until I notice that at 8, the message will change to "Not a Scratch!" (or 0-0 damage).
What doesn't work... yet:
- Since these ratios are not obvious, I do not have the exact spots where 0-1 changes to 0-2 or on any changes in the intervals, so there are a few times where you might get "0-1 or 0-2". I'm still checking almost everyday to see if I can lower the gap between these unknowns. (Get ready to see me and my lower age units surrendering on almost all battles neighbors :p)
-The Howitzers blast does NOT increase by 10 attack every space closer to a target (maybe you can try 6 or 7), and the Howitzer's attack in general will not work very well on scaled maps.
EDIT: Thank you devs for finally fixing that (it's 6 space for every space closer)
- A Stone Thrower's attack will technically hit 0 by the way I calculate Damage Dealt even though I'm pretty sure that it never does. Just put the attack at 1 (and 0 Damage Dealt), and use whatever gives you the highest damage.
- Rogues always take one hit to transform. Even the game makes this mistake that it can possibly retaliate if you don't see a one hit kill.
- I don't think a unit should have 0 attack under any circumstance, but I just put those as "Not a Scratch!"; if you put defense as 0, it will give you "One Hit Kill"; putting 10 or more under damage dealt will result in a dead unit; and if you put both as 0, I don't know what's suppose to happen, so you get a nice: "You tell me"
-This link brings you to a shareable document, so two people cannot use it at the exact same time. I do have 5 separate links, and may put them all up there if I see complaints about this issue here. *Even if it says that one user is online, it does not mean he/she is using it, so you can try to use it until you notice another value change or something.
Footnotes:
A big THANKS to Surge for being my only other tester and Hippocratica for helping me find how to keep the other cells protected (and my formulas hidden) with Google Docs
The Damage Calculator
(https://docs.google.com/spreadsheet...RDd3cWQ0aDZNY1dLY3V5UnVoVEE&usp=sharing#gid=0)
(https://docs.google.com/spreadsheet...RDd3cWQ0aDZNY1dLY3V5UnVoVEE&usp=sharing#gid=0)
How it works:
Hopefully, this is pretty straightforward, but I guess I'll make this more of a guide.
First off, the only numbers you can edit are the ones without the diagonal stripes on it. If you want to get rid of these diagonal bars, go to "View" and uncheck protected ranges (they still will be un-editable, but it does make it look more smooth
).Description for each cell:
| (That's me) | Defense stats of the unit | Attack stats of the opposing unit |
| Base stat (without any GB boost) | The basic "Defense" stat | The basic "Attack" stat |
| Bonuses not affected by GB boosts (from Units, Terrain, Dugout, Chivalry, etc.) | Defense Bonuses (like trees, bushes, and unit bonus) | Attack Bonuses (like rocks, hills, and unit bonus) |
| GB Bonus | Just put the defense GB bonus you see at the bottom bar | Just put the attack GB bonus you see at the bottom bar |
| (nothing here) | Damage Dealt | Put how much damage the attacking unit has taken. If you put 1, the unit has 9/10 HP |
| (nothing here) | How much Damage will you take? | Starts with "Not a Scratch!" (which is 0-0 Damage) then goes to 0-1 Damage, 0-2, 1-2, ..., and finally "One Hit Kill " (or 10-10 Damage) |
). Chivalry and Call of Duty is also automatically added to the defense stat at the bottom bar.If you don't already have basic Excel experience, you can make a cell add values for you by first putting an equal sign "=" then put in the equation you want (ex: you can put "=26+25" for the unit/terrain defense of a Rapid Fire Cannon with a dugout bonus against a heavy unit)
Example:
Let's say I started this battle:
| Defense of your unit | Attack of opponent's unit | ||
| 65 | 24 | ||
| Unit/Terrain Bonus | 55 | 7 | |
| GB Bonus | 0% | 0% | |
| Damage Dealt: | 0 | HP | |
| How much damage will you take? | (0-2 Damage should appear here) |
*longbow's attack known from hovering over it at the bottom bar
You'll see that there is still a chance at it putting a dent in the tank (0-2 damage). Now, let's see how much it'll take to make longbow useless against that tank, so I put 1 under Damage Dealt and going up one-by-one until I notice that at 8, the message will change to "Not a Scratch!" (or 0-0 damage).
What doesn't work... yet:
- Since these ratios are not obvious, I do not have the exact spots where 0-1 changes to 0-2 or on any changes in the intervals, so there are a few times where you might get "0-1 or 0-2". I'm still checking almost everyday to see if I can lower the gap between these unknowns. (Get ready to see me and my lower age units surrendering on almost all battles neighbors :p)
-
EDIT: Thank you devs for finally fixing that (it's 6 space for every space closer)
- A Stone Thrower's attack will technically hit 0 by the way I calculate Damage Dealt even though I'm pretty sure that it never does. Just put the attack at 1 (and 0 Damage Dealt), and use whatever gives you the highest damage.
- Rogues always take one hit to transform. Even the game makes this mistake that it can possibly retaliate if you don't see a one hit kill.
- I don't think a unit should have 0 attack under any circumstance, but I just put those as "Not a Scratch!"; if you put defense as 0, it will give you "One Hit Kill
"; putting 10 or more under damage dealt will result in a dead unit; and if you put both as 0, I don't know what's suppose to happen, so you get a nice: "You tell me"-This link brings you to a shareable document, so two people cannot use it at the exact same time. I do have 5 separate links, and may put them all up there if I see complaints about this issue here. *Even if it says that one user is online, it does not mean he/she is using it, so you can try to use it until you notice another value change or something.
Footnotes:
A big THANKS to Surge for being my only other tester and Hippocratica for helping me find how to keep the other cells protected (and my formulas hidden) with Google Docs
Last edited by a moderator:
