Solved

Daily Dynamic Target Calculation-2

Posted on 2014-03-05
7
108 Views
Last Modified: 2014-07-25
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
0
Comment
Question by:sunil1982
  • 4
  • 3
7 Comments
 

Author Comment

by:sunil1982
ID: 39907592
It should pick the average of the filled values for days which has data  and compare with target.
0
 
LVL 29

Accepted Solution

by:
gowflow earned 300 total points
ID: 39909184
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
 
LVL 29

Expert Comment

by:gowflow
ID: 39909231
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:sunil1982
ID: 39913684
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
 
LVL 29

Expert Comment

by:gowflow
ID: 39917538
still waiting ...  ur soon ... still not showing up !!!
gowflow
0
 

Author Comment

by:sunil1982
ID: 40113701
My solution haven't worked well...I am still in search of a solution...
0
 

Author Closing Comment

by:sunil1982
ID: 40219463
Thank you
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question