I need an excel function to accomplish the following:
I have 3 lists of dates in a spreadsheet (attached to this project).
Each list has an amount of apples listed at the top that need to be distributed to each of the dates in its respective list. All apples must be distributed over the time period.
The rate of distribution should have an exponential rate of decay. Whereas, the most recent date was given the most apples and the last date was given the least.
The function should take into account the following:
The first date in the series should be assigned a number between 25% and 75%. Then, the rest of the apples should be distributed on each day in an exponential decaying fashion, until all apples are distributed.
What I need here is the excel function to accomplish this.
Thank you for your assistance. Please include a brief description in your PM along with your bid so I can tell that you actually read the project description instead of using an auto-bidder to bid on the project. Just a sentence or two will do.
Your Project has a very easy solution so I suggest doing it for the minimum amount and I can promote my job (win-win situation) I will be pleased of chatting about this project and anything you want to know about me