Finally, after playing several scenarios whilst in the process of authoring a few, I turned my attention to the Battle Calculation Sheet to develop a tool whereby players may account for political consequences, in particular where dominant forces engage non-peer adversaries.
The Excel worksheet is self explanatory. I have protected Columns C, D, and K as these cells contain formulas. The other cells are open to insert data.
The political results are coded from suggestions from this thread as follows:
GA Global Acclaim
PG Prestige Gain
AP Apathy
CD Citizen Dissension
WC World Condemnation
The Data tab houses the settings for the political and military outcomes.