cairnswk wrote:e_i_pi wrote:....
Did I mention I'm an Excel VBA programmer?
e_i_pi...i've done some excel work also.
I hate the use of the drop downs pick lists that you have to go through with WM's tool, (sorry WM no offense for the great work you've done)
Is it possible to place thij whole continent/territory thing in to a set of formulas that would simply propogate out if you had two columns: first one for continent, next for territory (thrrough the use of concatenation and formulas.
That still will not work Cairns. Some territories belong to multiple continents. The way I set it up was to allow each continent the possibility of having multiple territories. You are simple asking to have both pages into 1 and that would just make them even more HUGE than they are now. Plus each territory borders others right. If you wanted a Territory / continent list, you would still need to make sure that there was a bordering/bombardment list too. Plus if there was a territory that belonged to two continents then you would need to make space for that as well. Plus with override bonuses, you would need to have the excel program automatically understand what those are and auto generate the code. Right now it is all there just waiting to be turned on. Plus, the drop down list allows a person to never need to type after the initial territory is placed in the list. Of course a user can always type everything in as well.
All I know is that it saved me TONS of time with MU USA maps. I think I only had 6 errors (and 4 or them were coordinate based so they don't count) over all 6 maps after the first XML version. I think I spent around 2 hours total (maybe) doing all of the initial XML for all 6 maps.
And no offense taken cairns. Just to let you know this was the 4th version I actually made. The first was actually quite similar to your suggestion (not 100% but similar) and I found that there were issues in layout and it was easier to make it this way.
So feel free to rip it apart and do anything you want. It is not really editable from a layout perspective so any changes might really screw it up.
WM