trying to get it set it as a geodatabase. the base map doesn't seem to talk to the data I have set up properly, so I have sidetracked it for a bit and was doing it manually with paint, and Excel. managed to progress things a few turns very differently than I am sure you had planned out.
I have the data fields for systems, X, Y, Enclaves, Garrison, production (A, B, C, D, J, R, W). Faction by Date
Forces, name, code, type, Exp, Loy, Tech, Faction, Warship class, assigned T, Merc contract date.... location by date, CUR by date.
Need it to be able to draw the maps by date, showing locations of forces (code), Production #'s, Faction ownership... draw the borders etc.
Transactions are battle results, repair, transport changes, movement orders, ownership changes
Battles are formula based on planet ownership check, STR/CUR totals, random damage done, resulting in end state CUR for each unit, retreating units flagged as routed.
right now I have the base data from the original game, and worked out a couple extra months of action, but without maps it gets very hard to continue after a few months in.