World Details Spreadsheet

[esampson]

https://docs.google.com/spreadsheet/ccc?key=0AvFOsTm2vhO_dGhOUW5McTdTOUY3eldJU1kwSTFmaEE&usp=sharing

This is written for T⁵ so some terms might be slightly off (mostly orbits) for other versions of Traveller. I'm also unsure what other editions use as 'size' for gas giants (T⁵ uses L-N for SGGs and P-X for LGGs). Other than those minor details I think it should work for most versions of Traveller.

Stellar data is based upon http://www.uni.edu/morgans/astro/course/Notes/section2/spectraltemps.html. Because the charts were incomplete I used some math to fill them out. Yes, this does mean you can get stellar data for a O2 II star which probably can't exist, but I didn't want to just throw out errors because someone wants to build a system we don't have data for.

Because it would be painful to protect just certain areas and not others and since two people trying to use the sheet at the same time would cause problems it is set as read only. You should still be able to save a copy to your own Google account and then edit that. If that doesn't work the way I'm thinking it should let me know.

 

[Midgardsormr]

I successfully made a copy into my own Google Drive, and it seems to work just fine. Thanks!

 

[esampson]

Glad to hear you can copy it. I was worried because I tried sharing something else like this with someone at one point and they had trouble accessing it.

It turns out that the data from the site that I was using was not terribly accurate. It looks like there was an error of some kind in their conversion from absolute magnitude to luminosity. Additionally I was doing a lot of guesswork with type II and IV stars and I was missing some other star groups, so I rebuilt the data using http://crab0.astr.nthu.edu.tw/~hchang/ga1/f1903-LumClassHR1.JPG.

 

[Drakon]

Spreadsheet

I broke it, I tried making a size T gas giant, but it refuses to allow a density of 0.24

Planet Density, Line 17

I downloaded a copy and using it locally on my local machine with Microsoft Excel 2007 and Win 8 (which I hate)

 

[esampson]

I broke it, I tried making a size T gas giant, but it refuses to allow a density of 0.24

Planet Density, Line 17

I downloaded a copy and using it locally on my local machine with Microsoft Excel 2007 and Win 8 (which I hate)

What does it do? My guess is that it isn't the spreadsheet that's broken but something in the conversion that broke.

 

[Drakon]

It tells me to enter a number greater than one. But if Earth's density is 1, then Jupiter is 0.24. Try entering 0.24, it tells me that is not allowed

 

[esampson]

Yeah. That's an error on the part of the conversion. On the Google doc the data validation is that the value must be greater than 0. If you alter the data validation on the Excel doc (sorry, but I can't tell you how to do that off hand) it should work fine.

 

[Drakon]

Data/data tools/data validation/settings to turn it off, thank you