I think my spreadsheet is somewhat similar to VAs, though no fancy schmancy conditional formatting. I have a tab for each sector, and then all possible locations in that sector. I did not bother with positive/negative numbers in each sector because I’m lazy and wanted to just copy/paste the tabs, so all numbers show up as positive and I just have a big text block that says which ones are “negative” in each sector. After each turn I manually fill in new information (scan results / ship locations / base locations) with simple color coding (black square = no base, purple square = my base, orange square = my ship, green/blue ship/base somewhere in that area).
Here’s an example of an unexplored chunk of a sector since pictures are better than words.
I used a “reverse” order for the vertical direction. That way “negative” always mean “left” or “down” when processing the mod’s results.
Also, the conditional formatting of “range” can help with identifying “next moves” . . . especially if the object of desire happens to be in a different quadrant.
I don’t think soy was talking about setting up the entire grid-system so much as the process to identify the region a scan covers.
And the latter isn’t as “symmetrical” as one might think with the given 2D set up. My sheet shows quite a bit of “triangles” and not much in the way of symmetry when the center isn’t the middle of the sector (or basic grid square).
Right, but Say I start in the upper left grid. The row below it is just the top row shifted left 1, the row below that shifts one 10x10 over again etc.
Moves aren’t even due yet. (I know, time permitting, you would evaluate and post when all have been submitted, but players don’t even know if everyone has submitted. At least spectators / hecklers don’t.)
Can the two methods be combined? For the example above, could you submit (1,1,1,1), (1,1,1,1), (1,0,1,0) if you want each stage of the move executed with x then y then z then t?
