I've written an Excel spreadsheet that calculates the probability of an attacker winning a battle. I know it's been done before (at least one program was written by Mark Wagner), but I needed to brush up on my VBA for work, and this was my idea of fun.

Hopefully, a screenshot accompanies this post. If not, could someone explain how to upload c:\games\mps\oddscalc\scrndump.gif (76k) from my hard disk?

The algorithm is a direct unmodified transposition from Marquis de Sodaq's writeup in the Apolyton GL found here: http://www.apolyton.net/forums/Forum.../001944.html?6 .

From the posts, the algorithm seemed fairly sophisticated and did pretty well in predicting combat results with a variety of units.

The interface for the Excel 2000 workbook is a dialog asking for pertinent information. Besides the standard input for Af, Df, Hp, Fp, and terrain modifiers, it also has toggles for things such as vet status, entrenchment, coastal fortresses, pikeman special, fighter scramble, sneak attack, etc.

If you're interested, here's where I could use some help.

1) Where and how can I post this xls file? I could use some testing/feedback.

2) Is the algorithm by Buenos, Eggman, & Marquis de Sodaq, et al. generally accepted as accurate? I know it doesn't handle 0 Df situations, but it seems pretty good otherwise.

3) If I've overlooked a more thorough program written by someone else that does the same thing, let me know (gently).

Thanks

Hopefully, a screenshot accompanies this post. If not, could someone explain how to upload c:\games\mps\oddscalc\scrndump.gif (76k) from my hard disk?

The algorithm is a direct unmodified transposition from Marquis de Sodaq's writeup in the Apolyton GL found here: http://www.apolyton.net/forums/Forum.../001944.html?6 .

From the posts, the algorithm seemed fairly sophisticated and did pretty well in predicting combat results with a variety of units.

The interface for the Excel 2000 workbook is a dialog asking for pertinent information. Besides the standard input for Af, Df, Hp, Fp, and terrain modifiers, it also has toggles for things such as vet status, entrenchment, coastal fortresses, pikeman special, fighter scramble, sneak attack, etc.

If you're interested, here's where I could use some help.

1) Where and how can I post this xls file? I could use some testing/feedback.

2) Is the algorithm by Buenos, Eggman, & Marquis de Sodaq, et al. generally accepted as accurate? I know it doesn't handle 0 Df situations, but it seems pretty good otherwise.

3) If I've overlooked a more thorough program written by someone else that does the same thing, let me know (gently).

Thanks

## Comment