Warhammer combat calculator 2.3.19

[victorvictor136]

Hi all, I use this WCC, is there a newer one or a better one. A link would be great or name.
Thank you.

[CaptainSarathai]

I'm not sure, but they're not hard to program on Excel. I use one for advanced math-hammering, it uses the stats and points of a single model from each unit to determine everything from how many models you will kill in a turn, how many rounds of combat it would take before one unit was wiped out, what the odds are of either unit breaking after each round, to optimized formations according to attacks and base-size. It took hours to set up a sheet that detailed, and it takes up about 3 pages in Excel, but it works better than any app I've seen on the market. It's not hard to establish a rough idea of the "sweet spot" for a unit, because once you're actually on the table, averages and calculations are mostly just useless paperhammer.

[MeraMaggan]

Bump!
Just registered, this topic really caught my attention, geeky as I am.

I have actually been thinking of programming a combat calculator using the Monte Carlo Method (you can look it up on wikipedia if you're interested in what MCM is).
Regrettably I am not familiar with creating Excel macros and not good enough in any "real" programming language, so I will do it in MatLab.
Basically, the idea of the monte carlo method is to run a simulation a ridiculous large number of times to get statistic data for a given problem.
So instead of working with statistic averages the combat would be simulated by rolling every single dice, giving a better indication of your probability of winning or losing a fight.

I guess that by programming default strings i could basically get the program to give a detailed report of single trials and lists of averages of the whole fight.
What kind of data is generally considered interesting here? I can think of winning side, number of turns, average casualties on both sides, is anything else of interest?
Are there even enough people using MatLab to make this project worth doing?

[pilot00]

Why did you have to remind me my data mining thesis MeraMaggan? It is still to early for me...