Of course we have a couple of changing variables, namely the amount of your disposable income and the expected change in the BTC price, and so I consider that I put a somewhat base case, and of course the table could be more granular such as twice a year or quarterly or even monthly, and surely there can be value in each of the cases, and you can get some general ideas where you might be if your investment timeline might be 10 years but you can see if you are still on track after 2 years, 5 years, 8 years etc... .. so you have the amount that you put in and you have the uncertainties of how much BTC it is going to get you, too.
So if I put mmore of base case, then you could have scenarios that are worse or way worse in terms of the BTC price, or higher or way higher in terms of BTC price, and your results are going to be different under each of the scenarios, and so surely once you create one table, then future tables become easier, and you could also create tables in which you link back to another field so that you change one or two things and then the whole table result change based on your one or two changes.
As time goes by I have almost reached 2 years or only need one more Quartel to be exactly 2 years that I have been through with bitcoin accumulation with DCA. Apart from that, it is true as you said that the price problem is getting high and getting higher in this two-year period. Since it dropped to $15k, that's when I started investing in Bitcoin with DCA. To sort the table, it might take me a day to compile the average entry per year that I have passed.
The adjustment of entry price certainly varies because DCA does not looking a price when the purchase period is due. but that's not a problem because I still follow up on it until I am satisfied with my btc ownership. So far there has been no increase that I have made, meaning to increase the purchase budget in the second year, as in the table you have shared. Especially in my principle, where I still like to maintain a more stable purchase cash flow standard because in terms of income there is no increase.
So, the important point that I take from the table you shared is of course our consistency in buying bitcoin. Starting from $71 to $152 for the next 8 years is something that might be quite good to implement if only we were supported by increasing income every year.