I am not sure this is in the right forum, but I was curious if anyone here had experience with the battle resolution.xls file in the downloads section. Basically, I have been playing with the file to get a feel for using it as a mass combat system. However, I noted what I think might be a mistake in the calculations. In the defender column, all "special units" are multiplied by a cell that does not exist giving the units a score of 1. The same units for the attacker column are multiplied by a cell that does exist giving the units their proper score. As such I was curious if anyone was able to explain that formula difference. Was it done on purpose or is it an error? In addition the file is protected by a password so I can't even modify the formula to correct the change in formulas.

Any thoughts?