Chia farming TCO big vs small drives.xlsx

	A	C	E	F	H	I	J	L	M
1	Drive Attributes				Rack and System Attributes	New Big	Used
2	Drive Name	18TB disti	used 4TB	used 8TB	Data center cost / rack space (per month)	$ 100	$ 100	Plotting Power
3	Capacity (GB)	18000	4000	8000	Rack cost (one time)	$ -	$ -	per server (TiB/day)	20
4	Power Active (W)	6.5	7	8.8	Server cost	$ 5,000	$ 2,000	total	40
5	Power Idle (W)	5.6	5.9	7.4	JBOD cost	$ 2,000	$ 500	days to fill	226.3113856
6	AFR %	0.44%	4.00%	4.00%	Switch cost	$ 1,500	$ 1,500
7	ASP ($/GB)	$0.022	$0.010	$0.010	Server Power (W)	500	350	Plotting Power
8	ASP ($)	$396.00	$40.00	$80.00	JBOD Power (W)	200	100	per server (TiB/day)	7
9					Switch Power (W)	100	100	total	42
10					Server RU	1	1	days to fill	63.8621194
11	Workload				JBOD RU	4	4
12	Deployment Term (years)	5	5	5	Switch RU	1	1
13	Error encoding / replication	1	1	1	Drives per server	0	0
14	Performance multiplier	1	1	1	Drives per JBOD	90	45
15	Capacity utilization	100%	100%	100%	Servers per rack	2	6
16	Duty Cycle (active vs idle)	2%	2%	2%	JBODs per rack	6	8
17	Data Reduction Ratio (Compression)	100%	100%	100%	Utility server per rack (no storage)	0	0
18					Totals
19	CapEx				Cost, CapEx per Rack	$ 29,500	$ 23,500
20	Capacity Per Rack (TB)	9720	1440	2880	Power, W per Rack	2300	3000
21	CapEx Storage (Per Rack)	$213,840	$14,400	$28,800	Size, RU per Rack	27	39
22	CapEx Rack	$29,500	$23,500	$23,500
23	CapEx Total (Per Rack)	$243,340	$37,900	$52,300	Fixed
24	CapEx Total per TB raw	$25	$26	$18	Electricity Cost per kWhr	$ 0.05	$ 0.05
25	CapEx Total per TBe (effective)	$25.03	$26.32	$18.16	Data Center PUE	1.1	1.1
26	CapEx per TBe per month of deployment	$0.42	$0.44	$0.30	drive replacement cost	$ 50.00	$90.00
27
28	OpEx
29	Power Storage (Active/Idle/Duty Cycle, W)	3033.72	2131.92	2674.08
30	Power Max (Rack Limit, W)	5810	5520	6168
31	OpEx Storage ($ deployment term)	$7,308	$5,136	$6,442
32	OpEx Rack ($ deplyment term)	$5,541	$7,227	$7,227
33	OpEx Drive Failures / Replacement	$594	$6,480	$6,480
34	OpEx Total per Rack	$13,443	$18,843	$20,149
35	OpEx / TB raw at rack level	$1.38	$13.09	$7.00
36	OpEx / TBe (effective) at rack level	$1.38	$13.09	$7.00
37	OpEx / TBe (effective) per month	$0.02	$0.22	$0.12
38
39	Total Cost of Ownership
40	TCO (OpEx + CapEx) per TBe	$26.42	$39.40	$25.16
41	TCO per TBe per month of deployment	$0.44	$0.66	$0.42
42	Capacity per rack (PB)	9.7	1.4	2.9
43	Effective Capacity per rack (PBe)	9.7	1.4	2.9
44
45	CapEx Storage	$22	$10	$10
46	CapEx Compute + Rack	$3	$16	$8
47	OpEx Storage	$0.75	$3.57	$2.24
48	OpEx Compute + Rack	$0.57	$5.02	$2.51
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