Excellent work on this.
Excellent work on this.
can this work is the person you are fighting has less then all 10 techs?
I'm an age I player, and I know that war horns are multiplicative on age I. Are you sure you can just add 20 attack for war horns in age 2?
... I love you
+rep!
I shall come to you like a bear whose cubs have been ravished,
Like a lion I will devour your children and tear out their entrails,
And set upon you a ferocious beast who will consume you and your flocks,
And turn your fields into death. All will fear me!
+rep me if you like my suggestions/help
Spawn- AgeII Na13 - Massacre Founder
Every one of your enemies has a weakness, you only have to find it, Unless you find your self facing me, were it shall be your weakness that leads to your demise - Spawn.
The spreadsheet said I was totally overkilling the capture of Pyongyang today and it was right... all warrs were dead already when the mech wave arrived lol, but my testing with pikes was a great success and confirmed by the spreadsheet as well... phracts here I come :-)
fantastic !
DeVerm.
I'm staroffice user. Spending moneys for 10 msoffice suites in this game before do not let me to upgrade to a new version of Excel.
I will be happy if someone will copy/paste just the entire combat formula even with M120 or what cells are, no matter for me. Thanks.
I think it's a great job.
Some reports with results posted here for confirmation may be good also.
I never played age 1 so im not sure about the differencs in combat mechanics... someone else will have to take this one
The only tech it allows for alteration at the moment is Iron Working, Medicine, and Military Tradition. The rest of it is currently hard coded to level 10 techs.
It could be re-written but will be a few days before i can get to it. I have been doing this at work and got behind on my work, so now i gotta put in some hours to catch up
Try to Find Microsoft Office Starter... its free and is office 2010 (with limited features)
Also, thanks to all for the feedback, i will look into the issues you are having, but most sound like they may be poor conversion to older excel or user error, as i cannot recreate the errors you are getting
Last edited by AeroAgg06; 09-10-2010 at 12:07 AM.
Was just comparing to an actual battle and needed to do a few things.
For warhorn, I added 20%, not 20. I used 140% for attackers IW to account for corslet. Then multiplied the defending hero's attack by his leadership over the size of his archer stack (ie 75/133 for level 75 and 133k archer stack).
The attacker's still did a little more damage than the model predicted, but it is getting close.
Bookmarks