Hey, would you mind if I make an extra section at the bottom of your page about either my edited version of your spreadsheet or the manual upgrade procedure that I had made from your version an "Advanced" edition of your spreadsheet, that I've been maintaining for some time? I also have added notes on my page here about most of the changes I've made.

I combed through the spreadsheet and hopefully fixed most of the bugs. The cps for the buildings needed a lot of work. I was unsure if multiplying the “next time” for the buildings by 1.5 was intentional but I took it out anyway. I also calculated a new formula for determining the best item to buy next. It should somewhat follow the original order except this one won’t tell you to buy something that takes 3 days to save up for just because its cps is very high. So overall it’s more time efficient.

You can use the attached spreadsheet however you want; I don’t need any recognition. If you have any questions my email is:

Wow, I really overthought that new formula. Basically I just took your formula witch calculates the time it takes for an item to pay for itself (c/cps) and added the time it takes to save up for it (c/x).

Oops, I thought I updated it before I uploaded it. MIN(c * (1 + x / cps)) will produce the same result as MIN(c * (1 / x + 1 / cps)). x is constan for all the numbers in the list so you can divide by it and it won't change the minimum.

Think 2<4<6 and (2/x)<(4/x)<(6/x).

I settled on this formula because the number produced is much more resonable, and it is easier to logically understand why the formula works. Its just the total time in seconds it takes for an item to start tuning a profit.

Just figure out that we can divide MIN c*(1+x/cps) by x, since x is positive and invariant for all items, then we can get objective as MIN c(1/x + 1/cps) = MIN c/x + c/cps.

Which lead to this intepretation:

c/x is the next time of item. (How long it requires to buy item from 0 cookies with current x)

c/cps is the return time of item. (How long it requires to get back to the same amount of cookie before buying the item, with the cps increase from item)

So it becomes a simple objective: best buying = minimal (next time + return time) among all items.