Nice to see the news spam is gone with the cartel hexes added and the empire economies spaced out.
Oops, in removing the planets, (50%, twice) I changed hexes with the planets removed to economy of 10 but forgot the adjust the DV, so there wil be some high DV hexes out there with nothng in them.
Excel macro used to remove 50% of planets from text version of map:
Sub halfplanets()
Dim i As Integer
Dim oddstoremove As Integer
For i = 158 To 21749 Step 9
If Range(Cells(i, 1), Cells(i, 1)).Value <> "Planet=0" Then
oddstoremove = Int((2 * Rnd) + 1)
If oddstoremove = 2 Then
Range(Cells(i, 1), Cells(i, 1)).Value = "Planet=0"
Range(Cells(i - 6, 1), Cells(i - 6, 1)).Value = "Economic=10"
End If
End If
Next i
End Sub
I should have added another line to edit the DV as well:
Range(Cells(i - 4, 1), Cells(i - 4, 1)).Value = "Strength=10"
Now I have to adjust the DV's thus:
Sub adjustDV()
Dim i As Integer
For i = 158 To 21749 Step 9
If Range(Cells(i, 1), Cells(i, 1)).Value = "Planet=0" _
And Range(Cells(i + 1, 1), Cells(i + 1, 1)).Value = "Base=0" _
And Range(Cells(i - 6, 1), Cells(i - 6, 1)).Value = "Economic=10" Then
Range(Cells(i - 4, 1), Cells(i - 4, 1)).Value = "Strength=10"
End If
Next i
End Sub
Sorry folks, I'll fix this now, last testing reset for a while, I'll leave it be for a bit after this for some more feedback before making it final.
I partly wanted to post this to demonstrate map editing with excel macros, which is too cool, only hitch is that excel adds a bunch of extra quotation marks in the definitions in the beginning of the text map when you save the file, which must be removed in wordpad before loading it in Artifex for conversion to binary. (thinking hard about a new map editor... started the groundwork...)