Færdiggjort

Need an Excel Function for Exponential Decay

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.

Evner: Dataindførsel, Databehandling, Excel, Software Arkitektur, Visual Basic

Se mere: exponential interpolation excel, exponential growth formula excel, exponential decay formula, exponential function in excel, exponential decay excel formula, exponential decay regression, exponential decay fit, negative exponential trendline excel, need excel spreadsheet, need excel spreadsheet written, excel funtion, need excel spreadsheet roster staff free, companies need excel spreadsheets, need excel spreadsheet created, need excel spreadsheet customized

Om arbejdsgiveren:
( 79 bedømmelser ) Fort Worth, United States

Projekt ID: #17029536

Tildelt til:

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 på 1 dag
(0 bedømmelser)
0.0

13 freelancere byder i gennemsnit $21 på dette 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 Flere

$27 USD på 1 dag
(293 bedømmelser)
7.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 på 1 dag
(8 bedømmelser)
3.8
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 Flere

$25 USD på 1 dag
(9 bedømmelser)
3.5
$25 USD på 1 dag
(3 bedømmelser)
3.2
mofajjelbd

Hello, Thank you very much for this Need an Excel Project. I read through the job details extremely carefully and understand your required, for this I am absolutely sure that I can do the project very well. I can comp Flere

$15 USD på 1 dag
(9 bedømmelser)
2.9
robertraich

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

$24 USD på 1 dag
(4 bedømmelser)
2.5
$27 USD på 1 dag
(0 bedømmelser)
0.0
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 Flere

$12 USD in 2 dage
(0 bedømmelser)
0.0
Nonto98

A proposal has not yet been provided

$10 USD in 5 dage
(0 bedømmelser)
0.0
madiopras

A proposal has not yet been provided

$22 USD på 1 dag
(0 bedømmelser)
0.0
zubadillah

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

$25 USD på 1 dag
(0 bedømmelser)
0.0
ali602

[login to view URL] in Microsoft [login to view URL] with my work...

$25 USD på 1 dag
(0 bedømmelser)
0.0