These are some very interesting metrics. Where did you get these numbers?
I wonder if it's even possible to come up with exact numbers, since, as soon as new ASIC hardware hits, the older ones get devalued either comepletely (not profitable anymore with the increase of difficulty and energy expenses) or to some extent.
You never know exactly when and which new hardware will come out, so calculating the exact costs to mine 1.0 BTC seems impossible to me. You can estimate and ofc calculate for past periods of mining.
yes new asics come out.. but not every week.
the average lifetime of asics is ~2 years
and also it takes time for the big efficient industrial grade mining farms to upgrade all of their asics
EG a farm of 100,000 asics buys them in batches over multiple months once the lifecycles are up (its a slow transitionary period from advertised price on asic sales page. to actually being the most efficient asic operating/actively running in majority on the network), which means the cost-base is a slow adjustment
also they dont buy electric by the day either they buy electric contracts of MW/GW yields on contracts that last 6 months-2 years
and so the progressions of change of the metrics move at a slower pace than the market price that moves within the metrics
EG the top metric moved from 75k in 2021 90k in 2022 and is settling in to be $110k for q1 of 2023 and by more by year end
in short in 2021 there was literally no chance of a $100k bitcoin no matter how much people dreamed it
however a $100k bitcoin is POSSIBLE but we cannot guarantee it. but we know it is a possibility for 2023.. but dont expect a (random number)$300k btc this year(sorry)
anyway back to your question
the movements of electric, asic price variety, hashrate of said asic and mining rate of entire network. is not something that is calculated as a daily number. its a spread of 6month-2 years average which progressively scales
because the extremes are locked into upto 2 year electric contracts and lifecycles of hardware
thus they do accounting at that stretch based on total coins earned in that period