EXCEL Based 2D10 CRT Calculator.

[lucliu]

Thank you for sharing, Ronnie.

[Joseignacio]

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.

[Joseignacio]

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.

[Courtenay]

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.

[Joseignacio]

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.

[paulderynck]

Never attack at lower than +13.

[Centuur]

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...

[Joseignacio]

Never attack at lower than +13.

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

[Courtenay]

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.

[paulderynck]

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.