Reward calculator in Excel

[holda29]

Hello everyone,

I am trying to create reward calculator in Excel, as many altcoins are not included in calculators. The formula should look like [seconds] * [block reward] * [hash rate] / (difficulty * 4295032833) = coins per [seconds]. But it only works for certain algos, I assume it is because of that constant, that is specific to every algo right?
Is there a way to calculate it also for algos like Equihash, X17, Tribus, Skunk, Skein, Nist5, Lyra2v2, Keccak, Blake2s, X16r, Phi, Xevan? Or at least how to claculate the difficulty factor?

Thank you.

[dominuspro]

Usually You need to calculate the total hashrate = 2³² * diff
then divide by Your hashrate to get the number of blocks per second

It should work for regular POW coins

[beigai]

I  am a newbie who has just been exposed to mining.
Now I am confused and have no idea how these algorithms are calculated too,
so I hope that some friends will be able to share the excel like above.
Thanks in advance.

[FTrader]

Hello everyone,

I am trying to create reward calculator in Excel, as many altcoins are not included in calculators. The formula should look like [seconds] * [block reward] * [hash rate] / (difficulty * 4295032833) = coins per [seconds]. But it only works for certain algos, I assume it is because of that constant, that is specific to every algo right?
Is there a way to calculate it also for algos like Equihash, X17, Tribus, Skunk, Skein, Nist5, Lyra2v2, Keccak, Blake2s, X16r, Phi, Xevan? Or at least how to claculate the difficulty factor?

Thank you.

maybe this thread could help you:
https://bitcointalk.org/index.php?topic=396078.0

[brummer]

be careful when choosing the sources for the difficulty. sometimes they are super different across different sites.