Background
Imagine a standard Diplomacy map. All neutral supply centres have a unit in them. All great powers are awarded Influence Points per supply centre under their control.
Allocating Influence Points
Great Powers can allocate influence points to the neutral centres. Having the most points allocated to a territory gives the Great Power control over the unit located therein for a game year.
HOWEVER, influence points can be allocated to:
1. Increase your relations with the neutral country
2. Decrease another Great Power's relations with the neutral country.
Example
England France Germany
Belgium +10 +5 0
-3 (France)
-3 (Germany)
TOTAL: 4 5
Let's say that England allocated 10 influence points to Beligum. France allocated 5 to Beligum.
Germany deducted 3 points from England's total and France deducted 3 points as well.
Thus, the total allocation of points: France stands at 5 while England at 4. So France gets to command the unit in Belgium.
Now, how would I set up an Excel Spreadsheet which presents this information in a neat fashion?
Imagine a standard Diplomacy map. All neutral supply centres have a unit in them. All great powers are awarded Influence Points per supply centre under their control.
Allocating Influence Points
Great Powers can allocate influence points to the neutral centres. Having the most points allocated to a territory gives the Great Power control over the unit located therein for a game year.
HOWEVER, influence points can be allocated to:
1. Increase your relations with the neutral country
2. Decrease another Great Power's relations with the neutral country.
Example
England France Germany
Belgium +10 +5 0
-3 (France)
-3 (Germany)
TOTAL: 4 5
Let's say that England allocated 10 influence points to Beligum. France allocated 5 to Beligum.
Germany deducted 3 points from England's total and France deducted 3 points as well.
Thus, the total allocation of points: France stands at 5 while England at 4. So France gets to command the unit in Belgium.
Now, how would I set up an Excel Spreadsheet which presents this information in a neat fashion?