I had a debate with my wife, whether it makes more sense, to use excess photovoltaic enegery for solo mining Bitcoin or to sell the energy to market and invest it in playing "Lotto" (the Germany state lottery). Let's calculate!
According to Google (I have no clue about Lotto), chances to win 300.000€ are 1:5.000.000 if you buy one Bayernlos for 2€.
We assume the following parameters
Assuming one unit, we have a chance of winning 3.123BTC = 287.000€ of 13:707.000.000.000. This equals 1:54.000.000. So, with a 10 Minute blocktime, we get 6 chances an hour if we spent 1,3kWh. So 1:9.000.000.
But our energy budget is 2€. As we get 0,07€ for every kWh of energy fed in into the grid, we can mine for 2€/0,07€kWh = 28.57kWh. Assuming the 1300W of hour Antminer S9 that will enable us to mine for 22h.
This brings down our chances to win to lottery to 1:409.000.
It makes 5.000.000/409.000 = 12 times more sense to solo mine Bitcoin!