I have seen a few spreadsheets in the Map Making Tools topic which calculate bonus values for zones (or continents) using a formula which accounts for the number of defending regions (or territories), the number of attacking regions and the number of neighbour zones. I noticed that two of them use essentially the same formula and the third (oaktown's) seems to have dropped off the net. Does anyone know how this formula was derived? These values are often quoted in the Gameplay Workshop, but as often as not, an adjustment is suggested. Are there other parameters which commonly figure into these corrections? Does this formula need an extension or perhaps an overhaul?
I am wondering because I am thinking of creating a tool which would do these calculations directly from the XML, thus eliminating hand-counting regions and borders, and the chance for human error that goes with that. The first part of such a tool would be an XML analyzer that would count regions, borders and what-not. Those results could then be fed into one of the existing spreadsheets, or processed in a similar way within the tool itself. Ultimately, such calculations would be a nice addition to the XML Wizard, don't you think?