Energy Economy By Unit Sheet and old BO Calc

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	V	W	X	Y	Z	AA	AB	AE
1	Commander build	300
2	Wind speed	11.9
3	Mex value	1.8																Storage
4
5	Worker Stats	3453	110	1600	7																					Set Mexs Here to see real example
6																							Valuable Stats to Know					Factory Repeat Avg BO Calc
7	Unit	Total MC	Total EC	Total BC	BuildTime Per Builder	M/S/Builder	E/S/Builder	Build %	Eff M/S/CT	Eff E/S/CT	BOCALC	Name Repeat	Energy/Metal	Mex per Worker	Energies per Worker	Energies per Mex	# of Workers	# of ESource		Name Repeat	Build Time for units	$% build Time	M for # units	Energy for # units
8	Commander
9	Metal extractor	50	500	1800	20	2.5	25	90	2.25	22.5	1	Metal extractor	10	1.3	1.1	1.2	2.31	2.54		Metal extractor	20	0.07	0.1575	1.575
10	Solar Collector	155	0	2800	31.11111111	4.982142857	0	90	4.48	0	1	Solar Collector	0	2.5	0	0	1.2	0		Solar Collector	31.11111111	0.11	0.4928	0
11	Wind Turbine	37	175	1603	17.81111111	2.077354959	9.825327511	90	1.87	8.84		Wind Turbine	4.7	1	0.4	2.5	3	1.2		Wind Turbine	0	0	0	0
12	Tick	15	340	800	8.888888889	1.6875	38.25	90	1.52	34.43		Tick	22.7	0.8	1.7	0.5	3.75	6.38		Tick	0	0	0	0
13	Pawn	48	960	1420	15.77777778	3.042253521	60.84507042	90	2.74	54.76		Pawn	20	1.5	2.7	0.6	2	5.4		Pawn	0	0	0	0
14	Mace	130	1300	2210	24.55555556	5.294117647	52.94117647	90	4.76	47.65		Mace	10	2.6	2.4	1.1	1.15	2.76		Mace	0	0	0	0
15	Centurion	270	3100	4210	46.77777778	5.771971496	66.27078385	90	5.19	59.64	0	Centurion	11.5	2.9	3	1	1.03	3.09		Centurion	0	0	0	0
16	Stout	225	2000	2904	32.26666667	6.973140496	61.98347107	90	6.28	55.79		Stout	8.9	3.5	2.8	1.3	0.86	2.41		Stout	0	0	0	0
17	Blitz	109	911	1963	21.81111111	4.997452878	41.7677025	90	4.5	37.59	7	Blitz	8.4	2.5	1.9	1.3	1.2	2.28		Blitz	152.6777778	0.52	2.34	19.5468
18	Rover	31	370	950	10.55555556	2.936842105	35.05263158	90	2.64	31.55		Rover	12	1.5	1.6	0.9	2	3.2		Rover	0	0	0	0
19	Construction Bot	110	1600	3453	38.36666667	2.867072111	41.70286707	90	2.58	37.53	0	Construction Bot	14.5	1.4	1.9	0.7	2.14	4.07		Construction Bot	0	0	0	0
20	Construction Vehicle	135	1950	4066	45.17777778	2.988194786	43.16281358	90	2.69	38.85	2	Construction Vehicle	14.4	1.5	1.9	0.8	2	3.8		Construction Vehicle	90.35555556	0.31	0.8339	12.0435
21	Grunt	36	880	1279	14.21111111	2.533229085	61.92337764	90	2.28	55.73		Grunt	24.4	1.3	2.8	0.5	2.31	6.47		Grunt	0	0	0	0
22	Construction Bot	120	1750	3551	39.45555556	3.04139679	44.35370318	90	2.74	39.92		Construction Bot	14.6	1.5	2	0.8	2	4		Construction Bot	0	0	0	0
23	Grunt	36	880	1279	14.21111111	2.533229085	61.92337764	90	2.28	55.73		Grunt	24.4	1.3	2.8	0.5	2.31	6.47		Grunt	0	0	0	0
24	Grunt	36	880	1279	14.21111111	2.533229085	61.92337764	90	2.28	55.73		Grunt	24.4	1.3	2.8	0.5	2.31	6.47		Grunt	0	0	0	0
25	Grunt	36	880	1279	14.21111111	2.533229085	61.92337764	90	2.28	55.73		Grunt	24.4	1.3	2.8	0.5	2.31	6.47		Grunt	0	0	0	0
26	Grunt	36	880	1279	14.21111111	2.533229085	61.92337764	90	2.28	55.73		Grunt	24.4	1.3	2.8	0.5	2.31	6.47		Grunt	0	0	0	0
27									3.8242	33.1653	SUM	AVG BO	8.7	2.1	1.7	1.2	1.43	2.43		AVG BO	294.1444444	Avg Res/sec	3.8242	33.1653
28																					# of Mexs		3	4	5	6	7
29																					# of Expanding Cons		1	1	1	1	1
30																Solar	20	155	0	2800	Desired E source / Mex Ratio		1.7	1.7	1.7	1.7	1.7
31																Wind	11.9	37	175	1603
32																					Con Build Time		20	20	20	20	20
33																					Con Walk Time		10	30	30	30	30
34															Using Worker Value for this ->	Build Power	90	Mex Value	1.8		# of mexs per set		1	1	1	1	1
35															Energies Talk about this ->	Solar	20	155	0	2800	EnergyConv/ms		0	0	0	0	0
36
37																					Seconds per set		30	50	50	50	50
38																					Metal/Sec		5.4	7.2	9	10.8	12.6
39																					Time for Worker to Produce E Source		31.11	31.11	31.11	31.11	31.11
40																					Home Cons to produce E to pace Expansion mex		1	0.6	0.6	0.6	0.6
41																					Expanding Cons Per Home Cons		1	1.67	1.67	1.67	1.67
42																					Expansion metal/min		100	60	60	60	60
43																					Energy metal/balance		298.9	179.4	179.4	179.4	179.4
44																					Eco Metal/MIN		398.9	239.4	239.4	239.4	239.4
45																					Eco % By metal/second		123	55	44	37	32
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100