ZCash Calculator

	A	B	C	D	E	G	H	J	K
1	Leroy627's ZCash Mining Profitability Calculator					Usage Instructions
2	Your Hashrate	Fill	Sol/s			Click file, then make a copy.
3	Pool Hashrate(Same as yours if solo)	In	Sol/s			Once you have done so, just fill
4	Pool+Miner Dev Fee	0.00%	(0 if solo)			in the data(Green Cells) on your copy of the sheet
5	Electricity Usage	The	KW/h
6	Electricity Price	Data	USD/KW
7	Hardware Costs	Here	USD
8						RnG, Updates the imported data every minute		For updates to work, head to Tools> Script Editor
9	Network Hashrate	#ERROR!	Sol/s			0.7725		and do	http://prntscr.com/d15o51
10	Blocktime	#ERROR!	Seconds			Last Updated		Without the above, data will only update
11	Block # (Chain Height)	#ERROR!				13/10/2025 22:47:02		when you open or edit the sheet
12	Miner Share	#ERROR!
13	1 ZEC =	#ERROR!	USD			Zcash Forum Topic
14	1 ZEC =	#ERROR!	BTC			https://forum.z.cash/t/google-spreadsheet-zcash-mining-calculator/4922			<<Contact me here, this google acc isn't my main
15	1 BTC =	#ERROR!	USD
16	#ERROR!	#ERROR!	USD
17						Donations
18	Reward Per Block (For Miners)	#ERROR!	ZEC			ZEC	t1KQ8EXoriXKXC7kvg2Ng5DY5K9cvdFRj6g
19	(Pool)Time to Find 1 Block	#ERROR!	Hours			BTC	1DUpysqbF16Sc5XBk34gG3KXfed5p7fcE2
20	(Pool)Blocks Per Hour (Estimated)	#ERROR!	Blocks
21	Revenue Per Hour	#VALUE!	USD			Credits
22	Profit Per Hour	#VALUE!	USD	#VALUE!	ZEC	Myself for taking the time to make this, about 1.5 hours spent in total
23	Profit Per Day	#VALUE!	USD	#VALUE!	ZEC	Cryptocompare.com for the price data
24	Profit Per Week	#VALUE!	USD	#VALUE!	ZEC	lustro for the ZCash Blockchain API
25	Profit Per Month (30 Days)	#VALUE!	USD	#VALUE!	ZEC	Google also receives some credit for the scripts I used, and this sheet
26	Break Even Time (ROI)	#VALUE!	Days
27
28
29
30
31
32
33	Todo (Maybe in 28 years)					Last Updated By Me
34	Update B18 so that it works until the end of ZCash Mining					15/1/2017
35	Currently will work until(Not including) Block #5050001, the sixth					Updates Notes
36	block reward halving(That makes block reward ~0.2 ZEC)					14/11/2016- Changed abit of text, since devfees exist now. Hmm, I just bypass them anyway, but I guess most of you don't know how to :)
37	At that point, 99.6% of all ZEC will be mined.					15/1/2017 - Updated B18 so it works for 28 years
38
39
40
41
42
43
44
45
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