Celestial Architect Spreadsheet 1.3

	B	D	E	F	G	I	K	L	M	N	Q
1
2	Celestial Architect Spreadsheet 1.3 You don't need to request access. Select "Make a Copy" from the file menu.
3	Sun(s) & Planetary Orbit
4	Enter your figures in the yellow boxes, the rest is automatically calculated.
5	Blue text indicates rough approximations
6									Aproximate
7		Star A					Star B
8	M Mass of your Star(s)	1.98844E+30	(kg)		1.000		0	(kg)		0.000	(1= Sol's Mass. This chart assumes a main-sequence star)
9
10			Type G star. Yellow
11							Set to “0” if you only want one star
12	Derived stats of your Star(s)
13	Surface Temperature	5,778.0	(K)		1.000		0.0	(K)		0.000	(1= Sol's Surface Temperature)
14	L luminosity	3.85E+026	(W)		1.000		0.00E+000	(W)		0.000	(1= Sol's Luminosity)
15	D diameter	1,391,000	(km)		1.000		0	(km)		0.000	(1= Sol's Diameter)
16											Based on metal content, actual stars may vary 20%-30%
17
18	Apparent size of your Star(s) from your Planet				1.000					0.000	(1= the apparent size of Sol from the Earth, i.e. how big it looks)
19
20							The following calculations unrealistically assume that the second star is in the same place as the first.
21
22	Your Planet's Position
23	R average distance to your Planet	149,597,871	(km)		1.000	(in A.U.s)
24
25
26	Habital Zone Beginning	142,635,973	(km)		0.953	(in A.U.s: 1 = the average distance between the Earth & Sol)
27	Habital Zone End	205,488,479	(km)		1.374	(in A.U.s)
28
29		The habitable zone is a range in which some sort of planet can have liquid water.
30
31
32	Length of Years & Days
33	Length of your Planet's day	23.933	(hours)		1.000	(1= an Earth day)
34
35	T your Planet's orbital period, i.e. “year”	365.256	(days)		365.256	(measured in your Planet's days)
36
37
38	Heat & Light				Star A					Star B
39	I insolation				1.000					0.000
40
41				combined:	1.000	(1= the amount of heat energy the Earth recives from Sol)
42
43					If Insolation isn't pretty close to “1”, liquid water is probably impossible
44					This figure is much less reliable if you've added a second star, due to the complicated orbital relationships, that this chart makes no attempt to model.
45
46	A Albedo				30.0%	(0%=completely non-reflective. ~30%=earth. 100%=perfectly reflective.)
47					Taken from the Albedo Sheet
48
49	Greenhouse Effect				0.128	(the amount of heat retained by the atmosphere. 0= no atmosphere. 0.1= earth-like. Must be less than 1)
50
51					Thicker atmopsheres will tend to have a stronger greenhouse effect
52
53		Kelvin			Celsius	Fahrenheit
54	Your Planet's average temperature	288.03			14.88	58.78
55
56	Earth's mean surface temperature	288			14.85	58.73
57	Boiling point of Water at 1 atm pressure	373.15			100	212
58	Freezing point of Water	273.15			0	32
59
60
61
62	These calculations were mostly taken from this extremely helpful website:
63	http://www.cix.co.uk/~morven/worldkit/index.html
64
65
66
67
68	Any errors are probably mine
69	--J. W. Bjerk
70
71
72
73	To increase readability, and thus accuracy,
74	These variables are used for most of the formulas on this sheet
75
76	AU (km)
77	149597870.7
78
79	Sol's Mass (kg)
80	1.98844E+30
81
82	Sol's Surface Temperature (K)
83	5778
84
85	Sol's Luminosity (W)
86	3.85E+026
87
88	Sol's Radius (km)
89	695500
90
91
92
93
94
95
96
97
98
99
100