Steve Jackson Games - Site Navigation
Home General Info Follow Us Search Illuminator Store Forums What's New Other Games Ogre GURPS Munchkin Our Games: Home

Go Back   Steve Jackson Games Forums > Roleplaying > GURPS

Reply
 
Thread Tools Display Modes
Old 02-04-2011, 10:01 PM   #41
ericbsmith
 
ericbsmith's Avatar
 
Join Date: Aug 2004
Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.
Default Re: [Space] GURPS Handbook of the Planets

Quote:
Originally Posted by Brett View Post
The interface is a bit clunky, requiring the user to type accurately input that would be better selected from menus.
I haven't done very much with your sheet beyond a quick look-see, but this is actually a really easy fix, with a little bit of time invested (I do lots of menu's in my GURPS Spaceships Design Spreadsheet).

In Excel 2000: Data (menu) -> Validation
In Excel 2007/10: Data (tab) -> Validation
In OpenOffice: Data (menu) -> Validity

In all of them, in the Validation window, you can select List for the type of Validation. In the list entry box you can create a comma separated list in Excel; in OpenOffice you put each entry for the list on it's own line. In either you can also set the list to be a Cell Range instead, so you can create dynamically changing lists by changing the target cell values (or, in the case of Excel, so you can create list entries which include a comma - the list is comma deliminated in Excel, so values with comma's are not allowed in the simple list, but are within a Cell Range).

Other Validation options can be useful to restrict cell values to decimals, integers, as well as numbers above, below, or between given values, and a few other options. Validation is really useful for this kind of sheet.
__________________
Eric B. Smith GURPS Data File Coordinator
GURPSLand
The future keeps telling us what the past was about. You make the past mean different things by what you do with the time that comes after.

Last edited by ericbsmith; 02-04-2011 at 10:11 PM.
ericbsmith is offline   Reply With Quote
Old 02-04-2011, 11:21 PM   #42
Agemegos
 
Agemegos's Avatar
 
Join Date: May 2005
Location: Oz
Default Re: [Space] GURPS Handbook of the Planets

Quote:
Originally Posted by ericbsmith View Post
I haven't done very much with your sheet beyond a quick look-see, but this is actually a really easy fix, with a little bit of time invested (I do lots of menu's in my GURPS Spaceships Design Spreadsheet).

In Excel 2000: Data (menu) -> Validation
In Excel 2007/10: Data (tab) -> Validation
In OpenOffice: Data (menu) -> Validity

In all of them, in the Validation window, you can select List for the type of Validation. In the list entry box you can create a comma separated list in Excel; in OpenOffice you put each entry for the list on it's own line. In either you can also set the list to be a Cell Range instead, so you can create dynamically changing lists by changing the target cell values (or, in the case of Excel, so you can create list entries which include a comma - the list is comma deliminated in Excel, so values with comma's are not allowed in the simple list, but are within a Cell Range).

Other Validation options can be useful to restrict cell values to decimals, integers, as well as numbers above, below, or between given values, and a few other options. Validation is really useful for this kind of sheet.
I ought to look into it.

Things would have been rather easier if I had boned up on that bit of Excel first. Would have saved me a lot of trouble on input filtering and error messages. Which were not exactly easy the way I did them (though by no means as tricky as some of the other things I did in that monster of a workbook).
__________________

© copyright Brett Evill
Discussion of FLAT BLACK

Last edited by Agemegos; 02-05-2011 at 12:52 AM.
Agemegos is offline   Reply With Quote
Old 02-14-2011, 10:57 AM   #43
Mercator
 
Mercator's Avatar
 
Join Date: Mar 2006
Location: Ljubljana, Slovenia
Default Re: [Space] GURPS Handbook of the Planets

Quote:
Originally Posted by Brett View Post
Do you have a good set of data for the nearby stars in a convenient form?
Brett, have you checked out Tycho-2? I think it supersedes all the catalogs I've seen in this thread. It has a much larger scope than you need, but many entries are better-reduced data from Hipparcos, so you might find it useful. I think it's the best catalog so far until we get GAIA in 8-9 years.

M.
__________________
Behind the Aegis - My dark fantasy setting in Classical Greece (discuss it here!).
Conversion of the supernatural skills in the Basic Set to Powers.
Mercator is offline   Reply With Quote
Old 02-14-2011, 03:17 PM   #44
Agemegos
 
Agemegos's Avatar
 
Join Date: May 2005
Location: Oz
Default Re: [Space] GURPS Handbook of the Planets

Quote:
Originally Posted by Mercator View Post
Brett, have you checked out Tycho-2? I think it supersedes all the catalogs I've seen in this thread. It has a much larger scope than you need, but many entries are better-reduced data from Hipparcos, so you might find it useful. I think it's the best catalog so far until we get GAIA in 8-9 years.
It doesn't seem to have parallax, which is a pest.
__________________

© copyright Brett Evill
Discussion of FLAT BLACK
Agemegos is offline   Reply With Quote
Old 02-15-2011, 04:41 PM   #45
Celti
 
Celti's Avatar
 
Join Date: Jun 2007
Location: USA, Arizona, Phoenix
Default Re: [Space] GURPS Handbook of the Planets

Quote:
Originally Posted by Brett View Post
What I do with this beast is to add a sheet into which I put a data table that feeds ten thousand consecutive numbers into the "system number" or "universe number", and then treats selected cells (spectral class, maximum habitability, gravity of the world with highest habitability, number of worlds with habitability 4+) as output. On my Mac this will update in about twenty minutes (or a list of only a thousand systems in two minutes). Then I can pick anything interesting out of the list and re-generate it. Or attach colour-coded system numbers to points on maps or names in lists. If necessary, I can fine-tune the search by using the control panel.
I don't suppose anyone could give me a few hints on how to do something like this in OpenOffice? Paging through systems manually is tedious
__________________
In civilizations without boats, dreams dry up, espionage takes the place of adventure, and the police take the place of pirates.
—Michel Foucault, Of Other Spaces
Celti is offline   Reply With Quote
Old 02-12-2013, 01:01 AM   #46
Agemegos
 
Agemegos's Avatar
 
Join Date: May 2005
Location: Oz
Default Re: [Space] GURPS Handbook of the Planets

Is anyone still using my spreadsheet?

Has anyone made a proper computer instance of the GURPS 4e star system generation sequence yet?
Agemegos is offline   Reply With Quote
Old 02-12-2013, 01:08 AM   #47
Flyndaran
Untagged
 
Join Date: Oct 2004
Location: Forest Grove, Beaverton, Oregon
Default Re: [Space] GURPS Handbook of the Planets

I still, and will always, love it to bits.

Sadly, I have little computer ability to tweek or create programs.
__________________
Beware, poor communication skills. No offense intended. If offended, it just means that I failed my writing skill check.
Flyndaran is offline   Reply With Quote
Old 02-12-2013, 02:39 AM   #48
Agemegos
 
Agemegos's Avatar
 
Join Date: May 2005
Location: Oz
Default Re: [Space] GURPS Handbook of the Planets

Has anyone put a copy up for download on a GURPS website that people are going to be able to find?
Agemegos is offline   Reply With Quote
Old 02-12-2013, 03:22 AM   #49
zorg
Experimental Subject
 
zorg's Avatar
 
Join Date: Jan 2005
Location: saarbrücken, germany
Default Re: [Space] GURPS Handbook of the Planets

Quote:
Originally Posted by Brett View Post
Is anyone still using my spreadsheet?

Has anyone made a proper computer instance of the GURPS 4e star system generation sequence yet?
I'm using it from time to time. Haven't uploaded or improved on it, though.
__________________
Like a mail order mogwai...but nerdier - Nymdok
understanding is a three-edged sword
zorg is offline   Reply With Quote
Old 02-12-2013, 03:52 AM   #50
Pomphis
 
Join Date: Oct 2004
Default Re: [Space] GURPS Handbook of the Planets

Quote:
Originally Posted by Brett View Post
Is anyone still using my spreadsheet?
Yes. Quite happily, and with ongoing gratitude.

Quote:
Originally Posted by Brett View Post
Has anyone made a proper computer instance of the GURPS 4e star system generation sequence yet?
Not me.
Pomphis is offline   Reply With Quote
Reply

Tags
planets, space, star system generator, system generation, world generation

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Fnords are Off
[IMG] code is Off
HTML code is Off

Forum Jump


All times are GMT -6. The time now is 09:06 PM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2021, vBulletin Solutions, Inc.