Archiel's Governor Helper

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	X	Y	Z	AA	AB	AC
1
2		Current Population Report
3		Use this sheet to pull population reports from FIO and calculate the right amount of infrastructure buildings to support your population. Further down, select which POPI upkeep items are cheapest for your buildings to fulfill the needs to the desired levels. You will be informed when certain needs cause others to be capped, try to avoid this on your planet. On the right, compare the results of Festival 3 and Education 3 projects. Sometimes which one is better is unexpected! At the bottom right, see calculated cost per worker and per tier. This may be helpful in setting taxes, depending on your tax philosophy. Green cells can be edited by users.
4
5															Projected Growth
6
7
8
9															Running Project:		None
10
11		See also: There is an accompanying text guide to using this sheet:				Archiel's Good Governance					For credit and changes, see:		Changelog
12																Project Cost:	$0
13		Planet Name		Straight off the Report												Happiness Bonus
14		RC-040b			Pioneer	Settler	Technician	Engineer	Scientist							Education Bonus
15				Population	3299	6675	22864	20733	23923							Family Bonus
16		Most Recent Report		Change	423	64	407	-33	333		Note that Explorer's Grace adds 50% to all happiness values, and it is not detected or reflected in later parts of the sheet.					People Added
17		232		Open Jobs (last week)	0	0	0	0	0
18				Reported Happy	88.20%	72.59%	72.64%	49.33%	52.46%
19		Selected Report
20		232		Calculated Values
21				Unemployment %	17.94%	16.35%	13.37%	34.03%	23.74%		Sheet Diagnostics:				RC-040b	Pioneer	Settler	Technician	Engineer	Scientist
22		Next Report In		Current Open Jobs	0	0	0	0	0		Infrastructure Loaded Successfully				Current Population	3299	6675	22864	20733	23923
23	4.380337419	4 Dys 9 Hrs 7 Min		True Happy	75.75%	75.66%	75.29%	51.67%	60.37%		Prices Loaded Successfully				Override Happiness
24		-6 UTC		Available workers	592	1091	3056	7055	5679		Base Count as of: 27 Sep 2025			TODO:	Projected True Happy	82.06%	Loading...	Loading...	Loading...	Loading...
25											Stuck at loading? Change the Selected Report to 0 then back				Festival Bonus
26		Base Count														82.06%	Loading...	Loading...	Loading...	Loading...
27		118			Life Support	Safety	Health	Comfort	Culture	Education					Projected Avg Happy	82.06%	Loading...	Loading...	Loading...	Loading...
28		9/27/2025 5:54:52		Reported Fullfillment	100.00%	81.83%	95.50%	81.83%	81.83%	81.83%
29															Final Education Rate		0.048	0.043	0.0355	0.0305
30		Need Calculator
31		This section calculates the amount of each need that must be provided, based on the selected population report.													Education In:		Loading...	Loading...	Loading...	Loading...
32															Education Out	Loading...	Loading...	Loading...	Loading...
33															Migration In:	397.8	Loading...	Loading...
34					Pioneer	Loading...	Loading...	Loading...	Loading...		Total Needs	Max Needs (see below)	Max Needs Percentage		Migration Out	0.0	Loading...	Loading...	Loading...	Loading...
35				Life Support	1781.5						1781.5	118000	100.00%		Immigration Program	0	0	0	0	0
36				Safety	824.8						824.8	18400	100.00%		Change	Loading...	Loading...	Loading...	Loading...	Loading...
37				Health	494.9						494.9	33400	100.00%
38				Comfort	99.0						99.0	36000	100.00%		RC-040b End of Report Projections
39				Culture	66.0						66.0	37000	100.00%		New Available Workers	Loading...	Loading...	Loading...	Loading...	Loading...
40				Education	33.0						33.0	28500	100.00%		New Unemployment %	Loading...	Loading...	Loading...	Loading...	Loading...
41
42		Max Needs Supplied with current infrastructure													COGC Cost
43		Here we calculate the maximum amount of each need that can be provided for the infrastructure on the planet. This helps you decide if you need to make new buildings or not. You can change the active infrastructure level in the green column to simulate building new buildings (or activating buildings that have already been built on the planet)													Governors are generally responsible for filling the COGC each week. The COGC amount seems to be based on the base count (not the site count), and always assume at least 5 bases. The number can be slightly off because the base count can change during the week but the value is calculated once at the beginning of the week
44
45				Override Level	Active Inf. Level	Life Support	Safety	Health	Comfort	Culture	Education
46			Bases		118	118000	5900	5900	0	0	0					Quantity Req	Unit Price	Weekly Sum	30 Day Price	30 Day Qty
47			SST		5	0	12500	0	0	0	0				DW	354	$114.00	$40,356.00	$121,068.00	1062
48			SDP		0	0	0	0	0	0	0				MCG	472	$35.90	$16,944.80	$50,834.40	1416
49			EMC		0	0	0	0	0	0	0				PE	472	$11.50	$5,428.00	$16,284.00	1416
50			INF	7	7	0	0	17500	0	0	0				RAT	236	$165.00	$38,940.00	$116,820.00	708
51			HOS		2	0	0	10000	0	0	0							$101,668.80	$305,006.40
52			WCE		0	0	0	0	0	0	0
53			PAR		10	0	0	0	25000	0	0
54			4DA		2	0	0	0	10000	0	0
55			ACA		1	0	0	0	1000	1000	0				Total Daily Cost
56			ART		6	0	0	0	0	15000	0				The daily cost of your current selections.
57			VRT		4	0	0	0	0	20000	0
58			PBH		1	0	0	0	0	1000	1000				Planetary Project	$0.00
59			LIB		1	0	0	0	0	0	2500				COGC	$14,524.11
60			UNI		5	0	0	0	0	0	25000				POPI	$142,067.33
61
62				Max Needs that can be produced		118000	18400	33400	36000	37000	28500				SUM:	$156,591.45
63				Required Needs by population		1781.5	824.8	494.9	99.0	66.0	33.0
64
65				Infrastructure Deficit:		0	0	0	0	0	0
66
67
68
69		Actual Needs Supplied based on Consumables
70		Calculate which consumables cost the least to supply a need, and estimate the satisfaction percent and projected true happiness for given upkeep levels. Note this assumes the population won't change, so adjust your estimates accordingly. Satisfaction above 100% might be considered wasted consumables, and you can address that by decreasing the supply of upkeep items, or deactivating infrastructure buildings to reduce consumption of upkeep materials already donated. Check the wiki for how happiness influences growth rates. General rule is aim above 70%. You can provide price overrides on the left. Be aware that these checkboxes assume the upkeep item was completely filled for the entire week. If it's filled the last day before the report, you won't have the full benefit.
71
72					Life Support	Safety	Health	Comfort	Culture	Education
73		Planet Reminder:		Supplied:	100.00%	1220.61%	2707.89%	13641.51%	16671.72%	28293.42%
74		RC-040b		Supplied Needs		10067	13400	13501	11000	9334								Pioneer	Settler	Technician	Engineer	Scientist	Planet Reminder:
75				Satisfaction (with caps applied)		1220.61%	2707.89%	1220.61%	1220.61%	1220.61%							Population	3299	6675	22864	20733	23923	RC-040b
76																	Proportion	0.043	0.086	0.295	0.268	0.309
77						Pioneer	Settler	Technician	Engineer	Scientist
78				Projected True Happy:		82.06%	Loading...	Loading...	Loading...	Loading...							For reference, here are the weights per tier
79				(happiness if no unemployment)		Loading...	Loading...	Loading...	Loading...	Loading...								Pioneer	Settler	Technician	Engineer	Scientist
80		CX Price Source:															Life Support	0.54	0.41	0.15	0.10	0.05
81		AI1			Total Consumable Cost Per Day:		$142,067.33										Safety	0.25	0.30	0.20	0.10	0.10	0.49	0.02040816327	0.0612244898	0.1020408163	0.2040816327	0.612244898
82						Per Week	$994,471.33										Health	0.15	0.20	0.30	0.15	0.10
83																	Comfort	0.03	0.03	0.20	0.35	0.20
84		Price Overrides mat	$														Culture	0.02	0.03	0.10	0.20	0.25	Quantity Consumed, per worker
85					Need 1	Need 2	Building	Enabled	Material	Mat Per Day	Cost Per Unit	$ / Satisf	Max Needs Supplied	Cost Per Day	Needs Satisfied		Education	0.01	0.03	0.05	0.10	0.30		Pioneer	Settler	Technician	Engineer	Scientist
86					Safety		5x SST		DW	50.0	$114.00	1.4	4167.00	$5,700	4167.0								Population	3299	6675	22864	20733	23923
87					Safety		5x SST		OFF	50.0	$97.00	1.2	4167.00										Safety	825	2,003	4,573	2,073	2,392
88					Safety		5x SST		SUN	10.0	$600.00	1.4	4167.00				Proportion Consumed, per worker						Health	495	1,335	6,859	3,110	2,392
89					Health		7x INF		OFF	70.0	$97.00	1.2	5833.00	$6,790	5833.0			Pioneer	Settler	Technician	Engineer	Scientist	Comfort	99	200	4,573	7,257	4,785
90					Health		7x INF		TUB	46.7	$177.00	1.4	5833.00				Population	3299	6675	22864	20733	23923	Culture	66	200	2,286	4,147	5,981
91					Health		7x INF		STR	4.7	$2,250.00	1.8	5833.00				Safety	1.0000	0.0000	0.0000	0.0000	0.0000	Education	33	200	1,143	2,073	7,177
92					Health		2x HOS		PK	4.0	$500.00	1.2	1667.00				Health	1.0000	0.0000	0.0000	0.0000	0.0000
93					Health		2x HOS		SEQ	0.8	$17,000.00	8.2	1667.00				Comfort	1.0000	0.0000	0.0000	0.0000	0.0000
94					Health		2x HOS		BND	8.0	$200.00	1.0	1667.00	$1,600	1667.0		Culture	1.0000	0.0000	0.0000	0.0000	0.0000
95					Health		2x HOS		SDR	0.1	$101,000.00	8.1	1667.00				Education	1.0000	0.0000	0.0000	0.0000	0.0000
96					Health		2x HOS		RED	0.1	$70,000.00	5.6	1667.00
97					Health		2x HOS		BSC	0.3	$53,100.00	8.5	1667.00				Costs Per Tier, Per Day:
98					Comfort		10x PAR		DW	100.0	$114.00	2.3	5000.00	$11,400	5000.0			Pioneer	Settler	Technician	Engineer	Scientist
99					Comfort		10x PAR		FOD	60.0	$450.00	5.4	5000.00				Population	3299	6675	22864	20733	23923
100					Comfort		10x PAR		PFE	20.0	$899.00	3.6	5000.00				Safety	$5,700	$0	$0	$0	$0