I’m kind of a numbers guy with my background in fiber optic infrastructure so apologize in advance but I always evaluate performance vs profit/loss. I put a Numbers sheet (excel for you Microsoft folks) that I use to track energy cost vs. profit. The #1 driving un-controllable factor that changes the profit number is based on BTC Daily Price.
So I thought I’d share if anyone was interested in how to build one:
BTC Daily Price - Script that calls current price of BTC.
Total BTC - the sum of all rows covering the month. (not shown in image)
Per Unit - Not really needed.
USD Amount - BTC Daily Price x Total BTC
Total Watts - Total number of watts being used by all miners
Daily KwH Usage - Total Watts / 1000 x 24 (24 hrs day)
Day KwH Usage - Daily KwH Usage x 31 ( days in the month)
Energy Cost - Daily KwH Usage X (what you pay per KwH in your area)
Profit/Loss - USD Amount - Energy Cost
You can use something like DuckDuckGo’s ChatGpt04 integration to write the script formula for the Daily BTC Price column/row that way every time you open the sheet the BTC price is current.
*The snippet image above shows my energy consummations/cost per month for 15Th/s (4 units).