Need an Excel Function for Exponential Decay
$10-30 USD
货到付款
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.
项目ID: #17029536
关于项目
授予:
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名威客正在参与此工作的竞标,均价$21/小时
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 更多
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 更多
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 更多
Siap memulai hal baru Relevant Skills and Experience Microsoft excel verifikasi data management