What if I told you that the energy required to mine a bitcoin could be calculated with a simple Excel formula?
I have good news: It’s possible.
Before you ask, the answer is no. Microsoft hasn’t introduced any library of bitcoin-related functions in Excel. Instead, Microsoft has introduced LAMBDAs.
With LAMBDAs, you can create your own custom functions using Excel formulas, just as you do with SUM() or IF().
I’ve created a LAMBDA that calculates the energy required to mine one bitcoin using the following inputs:
- Network hash rate
- Mining reward
- Mining equipment hash rate
- Mining equipment power consumption
Check out the video below.
If you want to receive the LAMBDA function used in this video enter your email in the form below.