Need an Excel Function for Exponential Decay

Completed Posted 5 years ago Paid on delivery
Completed 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.

Data Entry Data Processing Excel Software Architecture Visual Basic

Project ID: #17029536

About the project

11 proposals Remote project Active 5 years ago

Awarded to:

JorgeBece

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

$10 USD in 1 day
(11 Reviews)
2.8

11 freelancers are bidding on average $21 for this job

Dhruvika111

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

$27 USD in 1 day
(475 Reviews)
8.0
TechnoGuruu

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

$25 USD in 1 day
(103 Reviews)
6.5
Ayo25

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

$25 USD in 1 day
(17 Reviews)
6.2
robertraich

I understand the project. I would like to help you. Thank you. Best regards, Robert Raich. Have a nice day

$24 USD in 1 day
(4 Reviews)
2.5
hotmail011

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

$12 USD in 2 days
(0 Reviews)
0.0
Nonto98

A proposal has not yet been provided

$10 USD in 5 days
(0 Reviews)
0.0
madiopras

A proposal has not yet been provided

$22 USD in 1 day
(0 Reviews)
0.0
zubadillah

Siap memulai hal baru Relevant Skills and Experience Microsoft excel verifikasi data management

$25 USD in 1 day
(0 Reviews)
0.0