Daily Dynamic Target Calculation-2

Hi byundt,

When the actual values filled for only few days of the month, the target still calculates for the remaining days too.

But it considers '0' for the days where there is no input, So the dynamic target for the dates where the input is not put. Is there is anyway to optimize this.
DynamicTargetCalculations-v3.0.xlsx
sunil1982Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

sunil1982Author Commented:
It should pick the average of the filled values for days which has data  and compare with target.
0
gowflowCommented:
Is this what you want ?

I made it in a way that if there is no value in row 3 it will not calculate.
Let me know if it is correct.

gowflow
DynamicTargetCalculations-v4.0.xlsx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
gowflowCommented:
I read your post again and looked further on the data and noticed that maybe I was mistaken.

You meant to say if Row 2 has limited amounts not covering the whole month you need ... ?? what ??

If my assumption correct then could you please advise for Col
K and L that have no values on row2 what do you expect the result of the formula on row 4 and 5 for these 2 columns K and L

gowflow
0
Introduction to R

R is considered the predominant language for data scientist and statisticians. Learn how to use R for your own data science projects.

sunil1982Author Commented:
In the mean time,

What I did  is

1. Averaged the reported values ( Examples for 10 Days).
2. Subtracted it from the target...
3, Then divided that with number of NON-Reported days
4. Added that value to each days target..

I will post the excel here soon...
0
gowflowCommented:
still waiting ...  ur soon ... still not showing up !!!
gowflow
0
sunil1982Author Commented:
My solution haven't worked well...I am still in search of a solution...
0
sunil1982Author Commented:
Thank you
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.