[Space] GURPS Handbook of the Planets

[Pomphis]

Originally Posted by Brett

Has anyone put a copy up for download on a GURPS website that people are going to be able to find?

Not me. But IMNSHO this would be a really good addition for

http://www.sjgames.com/gurps/resources.html

[Dragondog]

Originally Posted by Brett

Is anyone still using my spreadsheet?

Has anyone made a proper computer instance of the GURPS 4e star system generation sequence yet?

I'm taking a class in Java programming right now and one of the things I am going to do afterwards is moving all my little rpg tools there. This will include a dice roller and the star system generation system from Space and whatever else I have or can be persuaded to add. As time permits.

[Celti]

I still use it quite happily, although simple mass generation of systems still eludes me. I've taken a stab or two at re-writing it as a real program but given up in despair each time (I am not a skilled programmer).

[ericthered]

I have a variation on the 4e planet generation system.

Its wrong somewhere, but it mostly works. Generating orbits to fill is a fairly hard task for binary stars.

[nondescript handle]

Originally Posted by Brett

Is anyone still using my spreadsheet? [...]

Yes. Mostly with an OpenOffice makro that searches a couple hundred systems and prints out those over a certain Hab score.

Originally Posted by Brett

[...] Has anyone made a proper computer instance of the GURPS 4e star system generation sequence yet?

Off and on I write a bit on my console garden world generator, but so far I haven't found a good and simple algorithm for the "fiddle around with the orbits to fit the pre-generated world's orbit in" part of step 22.

[Celti]

Originally Posted by nondescript handle

Mostly with an OpenOffice makro that searches a couple hundred systems and prints out those over a certain Hab score.

I don't suppose you could share this macro? I've been trying to write something similar myself.

[nondescript handle]

Originally Posted by Celti

I don't suppose you could share this macro? I've been trying to write something similar myself.

Sure. The first caveat is the usual "The software is provided "as is", without warranty of any kind, express or implied, including but not limited to...." spiel. It's only a OO macro, but don't use this on a machine controlling the nuclear reactor Homer Simpson.

Second caveat is that I suck at user interfaces. The paths and the parameters User# and boundaries of the system# are all hard coded.

Usage:
1) Change "H:\RPG_kram\GURPS\BHoP\" in line 30 and 58 into the paths you're actually using.
2) Change the parameters in lines 8, 10, 12 and 14 to your liking.
3) Save and run. I would first make a test run with 50 or so to see how long your computer needs for that.

sub Evil_search_001
Dim UserNum as Integer
Dim MinSys as Integer
Dim MaxSys as Integer
Dim MinHab as Integer

' **** change parameters here ****
UserNum = 1
' User or Universe number, a constant
MinSys = 1
' the lower bound of the rage of system numbers
MaxSys = 50
' the upper bound of the range of system numbers
MinHab = 7
' the minimum habitability score a system must have to be saved

Dim Sheet, Cell

dim args2(1) as new com.sun.star.beans.PropertyValue
dim Arg(0) as new com.sun.star.beans.PropertyValue

Arg(0).Name = "Selection"
Arg(0).Value = CellRange

args2(0).Name = "FilterName"
args2(0).Value = "calc_pdf_Export"
args2(1).Name = "FilterData"
args2(1).Value = Arg()

iURL = converttourl("H:\RPG_kram\GURPS\BHoP\GURPSssgeneratorbeta.ods")
dim myFileProp() as new com.sun.star.beans.PropertyValue
oDocument = StarDesktop.loadComponentFromURL(iURL, "_blank", 0, myFileProp() )

Dim c as Integer, r as Integer

Sheet = thisComponent.Sheets(1)
Cell = Sheet.getCellRangeByName("C4")
Cell.Value = UserNum

for r = MinSys to MaxSys

Sheet = thisComponent.Sheets(2)
Cell = Sheet.getCellRangeByName("F4")

Cell.Value = r

Cell = Sheet.getCellRangeByName("R4")

c = Cell.Value

if c >= MinHab then

Doc   = ThisComponent
Controller = Doc.CurrentController
Sheet = thisComponent.Sheets(2)
CellRange = Sheet.getCellRangeByName("$A$1:$R$50")
Controller.select(CellRange)
sURL = ConvertToURL("H:\RPG_kram\GURPS\BHoP\"& UserNum & "_" & r &".pdf")
Doc.storeToURL(sURL,args2())

endif

next r

End Sub

[Celti]

Thanks for this! Now that I've had a chance to play with it it works great! Going to make it much easier to generate liveable star systems when my group rolls back to a space opera game.

[Nakawaros]

I've been working on it, but it's currently bogged down by 3 things

1. Having it safely pick out orbitals is a pain. I may have to deviate from the rules (by having it place the pregenerated Gas Giant AFTER the orbitals.)

2. Moons? Yeah, not liking that either

3. Rewriting the objects so I can more easily troubleshoot things.

That said, I plan to have it out.. soon. I think. :/

(I will also probably release it online after I add a "force rule purism" option, since I implement a few house rules.)


ETA: Side note, I actually have to admit I have no clue what forumlae to use for tides. I do note they still keep generating too high values for my tastes, but any variation I do on that will be a "not default" option.

[sjard]

I'd probably use it more if I didn't have to special order a4 paper to print it on.