10mm Quatre Bras solo game using Blucher

[Shutuphippie]

I would definitely be interested in a SS to have a look at thank you

Reference MO - I used a system that I had seen online (Storm of Stell Wargamming's Youtube video where he has refrought Quatre Bras and Waterloo)

Before rolling MO I would
1. Decide roughly what I wanted each unit to do and the priority that I wanted them to move before rolling the MO dice
2. Rolled MO dice  (3 dice for each side)
3. Started moving and activating units
4. After each activation I pulled a counter out of a bag (the counters were numbered 3-18 - i literally hand wrote the numbers with a sharpie on some pennies)
5. If the counter number pulled from the bag was lower that the MO used to activate the units up till that point the turn was over

The system worked really well and on a number of occasions  I was unable to complete all the movements I wanted or required

Cheers

Andy 

[Last Hussar]

Email me on gmail (last.hussar - You can work out the rest!)

Its pretty simple.
Box for number of dice.
Boxes for MO.
Button for macro.
Macro clears mo count,
Sets mo to 0
I = 1 to dice
Mo = mo + int(rnd(1,6))+1
Next i

It then puts mo into a hidden  cell. This is because I lock off so I don't type to wrong boxes, the hidden cell is unlocked to allow macro to put the mo in.

Another cell is +A1 (the unlocked cell) and white text.
Enter the mo used in list, use SUM to total it
When sum >= MO make the text black using conditional formatting, and an if statement to print text saying MO used.

As storm of steel notes, the counters do t take account of bell curve.

[Organistus]

I haven't played it solo - a spreadsheet to track Momentum is an excellent plan!

I'd be interested in a copy, Last Hussar!

I am interested too

[Last Hussar]

Email me