The macro isn't anything special really. I just started at the create creature screen, hit ctrl+r to start recording, then hit enter to create the first soldier, move the cursor to the next cell, hit c+enter to create the next soldier, etc. It took less than five minutes to finish recording that, and it has been very helpful. A similar macro to give a soldier a full set of iron armor instantly is also useful. Counting of win/loss ratios is done by examining the units screen to see which soldiers are still alive afterwards.
For unarmored unskilled combatants, picks and battle axes seem about even. Iron picks can get through iron armor, but it is difficult and mostly breaks bones. Given that battle axes can't get through armor of the same tier at all, this is a slight advantage to picks, but an actual blunt weapon would be much more effective for anti-armor capabilities. High skill miners would still make a decent "reserve force", but try to have actual soldiers do the fighting if possible. Also, steel picks.
Another tidbit: the AI always goes for headshots if an enemy is unconscious, so if the target is wearing a helmet that the attacker's weapon cannot penetrate, this can cause the AI to flail uselessly despite the enemy being totally helpless. Great for training weapon skill, though.