I've uploaded the spreadhseet (in the Discussions OP) for anyone who's interested in using the formulas or template. It could be vastly improved if one was inclined to do so:
By adding options for unique units. For example a drop down box to select the leader/civilization that will automatically swap or add into the table the unique units relative to that civ.
A second addition could be to add a similar option for the top row (defending units) so one could select attacking civ, defending civ, and immediately see all the str differences including unique units.
Using the researched damage formula one could also substitute the d.Str values with actual damage. This might be tricky though since it also depends on unit health, but at least a base assumption that both units are at 100hp is not bad.
Something of this sort might make a cool damage calculator page for the wiki too.
But I probably won't be doing any of the above myself. I don't have much experience designing drop down boxes in Excel or elsewhere.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.