Need an Excel Function for Exponential Decay
$10-30 USD
Paid on delivery
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.
Project ID: #17029536
About the project
Awarded to:
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
11 freelancers are bidding on average $21 for this job
Hello there! I have reviewed your requirement and using few formulas and VBA codes the desired template can be created. Please reply to my bid for further discussion. Looking forward to hearing from you Thanks Bra More
Hi, i have checked your project details and i am ready to work on your project to add exponential decay (reducing in all three lists of dates with the number of apples. Please give me this opportunity to work on you More
I am a statistician with advanced knowledge of Ms Excel. I can get your job done for you in no time once you send it to me. Let me know what you think
I understand the project. I would like to help you. Thank you. Best regards, Robert Raich. Have a nice day
We provide solutions in the following Domains mainly: Domain & Hosting SMM (Social Media Marketing) Search Engine Optimization Web Designing and Development Point of Sale System ( Bar-code Enabled Sy More
Siap memulai hal baru Relevant Skills and Experience Microsoft excel verifikasi data management