Hi,
I have tried to get ChatGPT to solve this for me, but alas
I have items in column A, which are sorted in what I presume to be chronological order.
In column B, I have an estimated maximum date for when each entry was performed.
In column C, I have an estimated minimum date for when each entry was performed.
Together, column B and C gives a probable date range for when each entry was performed.
I need a formula in column D, which estimates a specific datetime of entry for each item in column A.
This formula needs to make the estimate in such a way that each estimated datetime falls within the specified date range estimation for each item,
and in such a way that each estimate is as far away from the estimates of the other items as possible, with as many days/hours between each estimate as possible.
In other words; maximize the entropy.
I have attached a workbook containing example data. The colored presentation shows how I envision the distribution.
Does anybody have a suggestion?
Regards,
Marbleking
Bookmarks