I created an Excel campain thing a couple of months ago. These were some of the features I included
1) A 100 by 100 square grid map that was auto generated by some VBA code. This included squares with a "Hill" factor "Woods" factor and "town/rural" factor. They even had set up zones for both players armies.
2) The number of turns for the campain could be set and an option for using a calculation of total terrain occupied in the victory calculation could be set
3) The user created up to 10 "Army Groups" of upto 5000 points in Value (The total points value could be set in the main game settings before the map was generated). Certain types of "Army Group" were restricted i.e. you could only have 2 Armour groups and 2 mech infantry groups. The army groups could move at different speeds(i.e. Armour groups could move 5 squares, diagonal movement is a bitch on a square grid map) and different spotting abilities.
4) Movement was controlled by some swanky VBA forms. If you attacked into an adjacent square you got an assault, two squares a attack ect ect.
After you completed your moves the application would tell player 1 what types of battles to set up. After the battle both players would have to enter their losses into another VBA form, the idea being that 1 tank loss would equal a certain amount of points lost ect ect, and that the type of victory would add collateral damage i.e a total victory would result in the opponents "Army group" being totally wiped out and their points would be added back into their starting pool for re-allocation to the remaining "Army Groups".
The whole thing worked (Barring play balance), but I canned the whole thing because the program relied on each user to be honest when inputing the results of the battles and selecting their units, I did try a system that required each user to enter the same kills loses which would then be compaired, and would not be excepted until they were identical. But it seemed unworkable for all but the most dedicated of players.
I wish that the game just produced a simple text file saying the following when a battle finished
Germans lost : 1000
Allies lost: 500
A similar notfication of points strength when the battle started would be useful too.
Anyone intrested in my reworking this idea for CMBB?
[ September 13, 2002, 08:40 PM: Message edited by: Makes The Jelly Judder ]