Matrix Games Forums

Thank you for sharing, Ronnie.

juntoalmar wrote: Sun Jan 08, 2017 6:20 am Thanks again.

I'm kind of surprised that there are not many more comments here, as this spreadsheet is fantastic!

Well, for those of us who are good at maths and have been playing 20+ years it does not improve our gaming in a relevant way, maybe it just refines it a bit. It may be of help for others though.

And I thank again Ronny because of his drive to work for the group, and you as well for the remaks.

hazmaxed wrote: Thu Jan 04, 2018 5:25 pm I have not yet tried the spreadsheet, but I plan to. I've been "shooting from the hip" in my solitaire games, and have been somewhat perturbed by those "attacker takes an extra loss" results.

One question for you, rkr. In the screenshots of the validation checks in Post #11, I see the note that "Att. must be a whole number between 1 and 32." Why an upper limit of 32? Isn't the maximum number of units that can attack a single hex 21? (3 in each of the 6 adjacent hexes plus 3 paradropped units in the attacked hex?)

Let me know if I'm missing something so I can start repeating Courtenay's signature line 100 times.

I hate that extra loss, I really believe it shouldnt be in the table, and even though it is in WIF, there it is an optional rule. Alas, in MWIF you cannot deselect it.

Huh? The extra loss is an intrinsic part of the 2d10 table in WiF, 7th edition. If you use the 2d10 table, you have the extra loss. It is NOT an optional rule. You don't have it if you use the 1d10 table.

I checked it and you seem to be right, I was told so by a friend who is pretty savvy about WIF so I didnt check it, but he is not known for being very clear or understandable in his explanations, so maybe he was speaking on the 2d10 which is an optional after all.

But I got it wrong all the same. Pity it isnt an optional, anyway. The roll 14 is simply absurd.

Never attack at lower than +13.

paulderynck wrote: Sun Jan 14, 2024 4:40 am Never attack at lower than +13.

Always remember the golden rule of WiF: Don't attack if you can't stand the maximum losses you might get...

paulderynck wrote: Sun Jan 14, 2024 4:40 am Never attack at lower than +13.

Then, almost never attack in China, unless your enemy is totally incompetent or you use O chit

You are in a position on a front where, if you do nothing, your opponent will keep expanding and eventually wreck you. You can make an attack that is by no means assured, but if it works, will stabilize the front. If it fails and leaves your troops flipped, things will fall apart even quicker. What chance of success would you need to make that attack?

There is at least one AAR on this site where the French were coming apart in '40, and made an attack I would not have made. They rolled high, and because of that success, France held at least three more turns. So it can work. When I do that, I don't roll high, so I don't do that.

Joseignacio wrote: Sun Jan 14, 2024 2:40 pm

paulderynck wrote: Sun Jan 14, 2024 4:40 am Never attack at lower than +13.

Then, almost never attack in China, unless your enemy is totally incompetent or you use O chit

For China I switch to a 20-sided die and reroll '1's.

thanks a lot for this great tool!

thek3mu wrote: Mon Dec 08, 2025 8:33 am thanks a lot for this great tool!

You're welcome!

(1) Here's my latest version (v12).
(2) This version includes the options to calculate expected number of units kill & lost (1st example below) or expected number of BP kill or lost (2nd example).
(3) For expected number of units enter "1's" in the Unit Loss matrix (to the right) for all DEF & OFF entries.
(4) Make sure that # is in the cell to the right of the Unit Loss cell.
(5) FYI, this is the default setup for the attached spreadsheet below.
(6) Note that labels Ex[# Kill] & Ex[# Lost] is automatically generated.
(7) If you want to calculate the Ex BP kill & lost then change # to BP (again the labels Ex[BP Kill] & Ex[BP Lost] are automatically generated).
(8) In the Unit Loss matrix you then need to enter the BP cost of units in the order in which they would be taken as losses for both the defender (DEF) & attacker (OFF).
(9) However; if you don't want to mess with all that then leave the Unit Loss matrix with all "1s" and "#"; the playing aid will continue to calculate expected # of units killed & lost.

Version 12. Ex[# Units] lost (Example). Ex[# BPs] lost (Example).

dear Ronnie, you're truly a treasure!

thank you very much.