Mars colony projections

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ
1			Ships				1.005	Crew		Guests			Cargo		0.020	1000.00	0.030	0.020	0.030	Cargo composition									Sales						Habitats
2	month	note	at Earth	to Mars	at Mars	to Earth	rate	to Mars	at Mars	to Mars	at Mars	to Earth	to Mars	to Earth	spares	prop on hand	ISRU	prod	habs	Total	ISRU	spares	prod	science	food	habs	free	guest-months	spares	propellant	ISRU	prod	habs	samples	max	needed

3	1	synod 1	0.00	2	0	0	0.1667	6	0	6	0	0	100	0		0.00
4	2	12	0.17	2	0	0	0.1675	6	0	6	0	0	100	0		0.00
5	3		0.33	2	0	0	0.1683	6	0	6	0	0	100	0		0.00
6	4		0.50	2	0	0	0.1692	6	0	6	0	0	100	0		0.00
7	5		0.67	0	2	0	0.1700	0	6	0	6	0	0	0	39.00	0.00	180.00	30.00	0	300	180	39	30	21	30	0	0	6						0	24	12
8	6		0.84	0	2	0	0.1709	0	6	0	6	0	0	0	37.62	138.46	180.00	30.00	0									12
9	7		1.01	0	2	0	0.1717	0	6	0	6	0	0	0	36.23	276.92	180.00	30.00	0									18
10	8		1.18	0	2	0	0.1726	0	6	0	6	0	0	0	34.85	415.38	180.00	30.00	0									24
11	9		1.36	0	2	0	0.1735	0	6	0	6	0	0	0	33.46	553.85	180.00	30.00	0									30
12	10		1.53	0	2	0	0.1743	0	6	0	6	0	0	0	32.08	692.31	180.00	30.00	0									36
13	11		1.70	0	2	0	0.1752	0	6	0	6	0	0	0	30.69	830.77	180.00	30.00	0									42
14	12		1.88	0	2	0	0.1761	0	6	0	6	0	0	0	29.31	969.23	180.00	30.00	0									48
15	13		2.06	0	2	0	0.1769	0	6	0	6	0	0	0	27.92	1107.69	180.00	30.00	0									54
16	14		2.23	0	2	0	0.1778	0	6	0	6	0	0	0	26.54	1246.15	180.00	30.00	0									60
17	15		2.41	0	2	0	0.1787	0	6	0	6	0	0	0	25.15	1384.62	180.00	30.00	0									66
18	16		2.59	0	2	0	0.1796	0	6	0	6	0	0	0	23.77	1523.08	180.00	30.00	0									72
19	17		2.77	0	2	0	0.1805	0	6	0	6	0	0	0	22.38	1661.54	180.00	30.00	0									78
20	18		2.95	0	2	0	0.1814	0	6	0	6	0	0	0	21.00	1800.00	180.00	30.00	0									84
21	19		3.13	0	2	0	0.1823	0	6	0	6	0	0	0	19.62	1938.46	180.00	30.00	0									90
22	20		3.31	0	2	0	0.1832	0	6	0	6	0	0	0	18.23	2076.92	180.00	30.00	0									96
23	21		3.50	0	2	0	0.1841	0	6	0	6	0	0	0	16.85	2215.38	180.00	30.00	0									102
24	22		3.68	0	2	0	0.1851	0	6	0	6	0	0	0	15.46	2353.85	180.00	30.00	0									108
25	23		3.87	0	2	0	0.1860	0	6	0	6	0	0	0	14.08	2492.31	180.00	30.00	0									114
26	24		4.05	0	2	0	0.1869	0	6	0	6	0	0	0	12.69	2630.77	180.00	30.00	0									120
27	25		4.24	0	2	0	0.1879	0	6	0	6	0	0	0	11.31	2769.23	180.00	30.00	0									126
28	26		4.43	0	2	0	0.1888	0	6	0	6	0	0	0	9.92	2907.69	180.00	30.00	0									132
29	27	synod 2	0.62	4	2	0	0.1897	6	6	6	6	0	300	0	8.54	3046.15	180.00	30.00	0									138
30	28	12	0.81	4	2	0	0.1907	6	6	6	6	0	300	0	7.15	3184.62	180.00	30.00	0									144
31	29		1.00	4	2	0	0.1916	6	6	6	6	0	300	0	5.77	3323.08	180.00	30.00	0									150
32	30		1.19	4	2	0	0.1926	6	6	6	6	0	300	0	4.38	3461.54	180.00	30.00	0									156
33	31		1.38	0	3	3	0.1936	0	12	0	6	6	0	69	62.22	600.00	280.90	80.00	0	300	100	60	50	21	69		0	162						69	36	18
34	32		1.57	0	3	3	0.1945	0	12	0	6	6	0	69	60.04	834.08	283.30	80.00	0									168
35	33		1.77	0	3	3	0.1955	0	12	0	6	6	0	69	57.85	1070.17	285.70	80.00	0									174
36	34		1.96	0	3	3	0.1965	0	12	0	6	6	0	69	55.63	1308.25	288.10	80.00	0									180
37	35		2.16	0	3	3	0.1975	0	12	0	6	6	0	69	53.40	1548.33	290.50	80.00	0									186
38	36		2.36	0	3	3	0.1985	0	12	0	6	0	0	69	51.14	1790.42	292.90	80.00	0									192
39	37		5.56	0	3	0	0.1994	0	12	0	6	0	0	0	48.87	2034.50	295.30	80.00	0									198
40	38		5.76	0	3	0	0.2004	0	12	0	6	0	0	0	46.58	2280.58	297.70	80.00	0									204
41	39		5.96	0	3	0	0.2014	0	12	0	6	0	0	0	44.27	2528.67	300.10	80.00	0									210
42	40		6.16	0	3	0	0.2025	0	12	0	6	0	0	0	41.95	2778.75	302.50	80.00	0									216
43	41		6.36	0	3	0	0.2035	0	12	0	6	0	0	0	39.60	3030.83	304.90	80.00	0									222
44	42		6.56	0	3	0	0.2045	0	12	0	6	0	0	0	37.24	3284.92	307.30	80.00	0									228
45	43		6.77	0	3	0	0.2055	0	12	0	6	0	0	0	34.85	3541.00	309.70	80.00	0									234
46	44		6.97	0	3	0	0.2065	0	12	0	6	0	0	0	32.45	3799.08	312.10	80.00	0									240
47	45		7.18	0	3	0	0.2076	0	12	0	6	0	0	0	30.03	4059.17	314.50	80.00	0									246
48	46		7.39	0	3	0	0.2086	0	12	0	6	0	0	0	27.60	4321.25	316.90	80.00	0									252
49	47		7.60	0	3	0	0.2096	0	12	0	6	0	0	0	25.14	4585.33	319.30	80.00	0									258
50	48		7.81	0	3	0	0.2107	0	12	0	6	0	0	0	22.67	4851.42	321.70	80.00	0									264
51	49		8.02	0	3	0	0.2117	0	12	0	6	0	0	0	20.17	5119.50	324.10	80.00	0									270
52	50		8.23	0	3	0	0.2128	0	12	0	6	0	0	0	17.66	5389.58	326.50	80.00	0									276
53	51		8.44	0	3	0	0.2139	0	12	0	6	0	0	0	15.13	5661.67	328.90	80.00	0									282
54	52		8.65	0	3	0	0.2149	0	12	0	6	0	0	0	12.58	5935.75	331.30	80.00	0									288
55	53	synod 3	0.87	8	3	0	0.2160	24	12	24	6	0	600	0	10.02	6211.83	333.70	80.00	0									294
56	54	24	1.09	8	3	0	0.2171	24	12	24	6	0	600	0	7.43	6489.92	336.10	80.00	0									300
57	55		1.30	8	3	0	0.2182	24	12	24	6	0	600	0	4.83	6770.00	338.50	80.00	0									306
58	56	160	1.52	8	3	0	0.2193	24	12	24	6	0	600	0	2.20	7052.08	340.90	80.00	0									312
59	57	17	1.74	0	4	7	0.2204	0	36	0	24	6	0	169	54.35	314.31	453.30	328.00	120	600	110	50	248	20	52	120	0	336						169	132	60
60	58	60	1.96	0	4	7	0.2215	0	36	0	24	6	0	169	56.56	692.06	463.14	334.56	120									360
61	59	-117	2.18	0	4	7	0.2226	0	36	0	24	6	0	169	58.82	1078.01	473.18	341.25	120									384
62	60	5 years	2.40	0	4	7	0.2237	0	36	0	24	6	0	169	61.14	1472.33	483.41	348.08	120									408
63	61		2.63	0	4	7	0.2248	0	36	0	24	6	0	169	63.52	1875.17	493.86	355.04	120									432
64	62		2.85	0	4	7	0.2259	0	36	0	24	6	0	169	65.96	2286.72	504.51	362.14	120									456
65	63		10.08	0	4	0	0.2271	0	36	0	24	0	0	0	68.46	2707.14	515.37	369.38	120									480
66	64		10.31	0	4	0	0.2282	0	36	0	24	0	0	0	71.02	3136.62	526.45	376.77	120									504
67	65		10.53	0	4	0	0.2293	0	36	0	24	0	0	0	73.65	3575.33	537.76	384.30	120									528
68	66		10.76	0	4	0	0.2305	0	36	0	24	0	0	0	76.34	4023.46	549.29	391.99	120									552
69	67		10.99	0	4	0	0.2316	0	36	0	24	0	0	0	79.10	4481.20	561.05	399.83	120									576
70	68		11.23	0	4	0	0.2328	0	36	0	24	0	0	0	81.92	4948.74	573.04	407.83	120									600
71	69		11.46	0	4	0	0.2340	0	36	0	24	0	0	0	84.82	5426.27	585.27	415.98	120									624
72	70		11.69	0	4	0	0.2351	0	36	0	24	0	0	0	87.78	5914.00	597.75	424.30	120									648
73	71		11.93	0	4	0	0.2363	0	36	0	24	0	0	0	90.82	6412.13	610.48	432.79	120									672
74	72		12.16	0	4	0	0.2375	0	36	0	24	0	0	0	93.93	6920.87	623.47	441.44	120									696
75	73		12.40	0	4	0	0.2387	0	36	0	24	0	0	0	97.11	7440.42	636.71	450.27	120									720
76	74		12.64	0	4	0	0.2399	0	36	0	24	0	0	0	100.38	7971.01	650.22	459.28	120									744
77	75		12.88	0	4	0	0.2411	0	36	0	24	0	0	0	103.71	8512.86	664.00	468.46	120									768
78	76		13.12	0	4	0	0.2423	0	36	0	24	0	0	0	107.13	9066.19	678.05	477.83	120									792
79	77		13.36	0	4	0	0.2435	0	36	0	24	0	0	0	110.63	9631.24	692.39	487.39	120									816
80	78		13.61	0	4	0	0.2447	0	36	0	24	0	0	0	114.21	10208.22	707.01	497.14	120									840
81	79	synod 4	0.85	13	4	0	0.2459	48	36	48	24	0	1100	0	117.88	10797.40	721.92	507.08	120									864
82	80	48	1.10	13	4	0	0.2472	48	36	48	24	0	1100	0	121.63	11399.00	737.13	517.22	120									888
83	81		1.34	13	4	0	0.2484	48	36	48	24	0	1100	0	125.47	12013.28	752.65	527.57	120									912
84	82	200	1.59	13	4	0	0.2496	48	36	48	24	0	1100	0	129.39	12640.49	768.48	538.12	120									936
85	83	35	1.84	0	5	12	0.2509	0	84	0	48	24	0	276	108.49	1231.62	1044.62	948.88	240	1100	360	70	500	50		120	0	984	100		100	100		276	312	132
86	84	132	2.09	0	5	12	0.2521	0	84	0	48	24	0	276	117.53	2102.14	1073.09	967.86	268.47									1032
87	85	-103	2.35	0	5	12	0.2534	0	84	0	48	24	0	276	126.51	2996.38	1102.12	987.22	297.50									1080
88	86		2.60	0	5	12	0.2547	0	84	0	48	24	0	276	135.42	3914.82	1131.74	1006.96	327.12									1128
89	87		2.85	0	5	12	0.2559	0	84	0	48	24	0	276	144.28	4857.94	1161.95	1027.10	357.33									1176
90	88		3.11	0	5	12	0.2572	0	84	0	48	24	0	276	153.07	5826.23	1192.76	1047.64	388.14									1224
91	89		15.37	0	5	0	0.2585	0	84	0	48	0	0	0	161.80	6820.20	1224.19	1068.59	419.57									1272
92	90		15.63	0	5	0	0.2598	0	84	0	48	0	0	0	170.46	7840.35	1256.25	1089.97	451.63									1320
93	91		15.89	0	5	0	0.2611	0	84	0	48	0	0	0	179.05	8887.23	1288.95	1111.77	484.33									1368
94	92		16.15	0	5	0	0.2624	0	84	0	48	0	0	0	187.58	9961.35	1322.30	1134.00	517.68									1416
95	93		16.41	0	5	0	0.2637	0	84	0	48	0	0	0	196.04	11063.27	1356.32	1156.68	551.70									1464
96	94		16.67	0	5	0	0.2650	0	84	0	48	0	0	0	204.42	12193.54	1391.02	1179.81	586.40									1512
97	95		16.94	0	5	0	0.2664	0	84	0	48	0	0	0	212.74	13352.72	1426.42	1203.41	621.79									1560
98	96		17.20	0	5	0	0.2677	0	84	0	48	0	0	0	220.97	14541.40	1462.52	1227.48	657.90									1608
99	97		17.47	0	5	0	0.2690	0	84	0	48	0	0	0	229.14	15760.17	1499.34	1252.03	694.72									1656
100	98		17.74	0	5	0	0.2704	0	84	0	48	0	0	0	237.22	17009.62	1536.90	1277.07	732.28									1704