Download linkVERSION 0.7
Put in two units' stat lines in the Setup tab, hit the big orange-red SIMULATE COMBAT button, wait a while, and check out the results! Obviously you will need to enable macros for this to work.
Everything is run as Javelins + Pilas first, then all melee combat. You can add more than 1 javelin or pila shot (just put a higher number in the box). A couple attacks may be +1/+0 more than it should be due to range, but that's probably not a huge deal.
Please note this can take a while to run, especially if you put in some excessive # of trials. # of trials should not exceed 65,000 for Excel 2003 due to the chance of overflowing the rows.
If you need to stop the macro while it's running (maybe because you put too high a number under Trials), hold down the Escape key. Please note you may have to re-enable automatic calculation in the Summary Results tab.
If you want to see what's going on in each fight up to the point where a unit routs or dies, put a 1 under the Debug box next to the Trials box. You'll probably want to set a low number of Trials if you do this. You don't want the data to overflow on the sheet, and plus you probably won't need more than a few to get the idea of what's going on (you're probably not going to look at 200 combats).
There are some columns grouped/hidden to the far right side for some new factions. Those are obviously not final.
Some quick documentation.
Setup Tab:Dice, Skill, Power, Evade, Tough, Courage: Put the unit's attack and defense profiles here. If you are trying to simulate an ongoing condition, you should probably also include that here. Similarly, add the +1 skill for spears vs. cavalry here.
Green, Yellow, Red: These are the unit's health boxes.
Charge Bonuses: Be sure to fill this section out! These are the bonuses the unit gets during the charge turn. Most units should have 1 C-Power (+0/+1 on the charge turn). Most spears should have -1 under C-Dice. Most Cavalry should have 1 under C-Impacts. Similarly, holding spearmen vs. Cavalry should have 0 under C-Dice and 2 under C-Power.
Vs. Range: Put a unit's defensive bonus against ranged attacks here. R-Dice is the positive number of how much dice is reduced: for example, Numidian Cavalry should put a
positive 2 under R-Dice. R-Evade is the bonus to evade against range attacks; most Cavalry should have a 1 here.
Min Dmg: The minimum damage a unit does with its melee attack. Colossal units should have a 1 here.
Javelin and Pila: Put the number of javelin and pila shots you want before the engagement. Usually only 1 for javelin and pila units, but maybe you want to see what happens with a second shot. Please note the simulator does not recalculate health or roll rout checks between javelin and pila shots; the first health status (green vs. yellow vs. red) update is after javelins and pilas, and the first rout check is after the first round of melee combat.
Reach, Fearsome, and Terrifying: Put a 1 here only if your unit has the ability AND it will affect the other unit. Otherwise the simulator will have the units affect each other!
Nets: Put a 1 here if the unit has the Ravenwood Elves ability, and otherwise put a 0 here. Basically it makes an additional hit roll for every 1 rolled to hit.
Blood Frenzy: Put a 1 here if the unit has the Lizardmen ability, and otherwise put a 0 here.
