mahmed1
Wellknown Member
 Joined
 Mar 28, 2009
 Messages
 2,245
 Office Version

 365
 2016
 Platform

 Windows
Hi All,
I hope you are well
I have a dataset that looks at what I require and how much I have available.
The % Of Total Requirement is the interval value over the total requirement for the day (Formula copied down =(F22/F$55)*100
The % Of % Of Total Available is the interval value over the total available for the day =(I22/I$55)*100
I then have a variance to see how far I am away from requirement =(AB22AA22)/AA22
What I want to be able to do is set a target of either 20% or 20%. I want the variance to see how far I am away from requirement to be within that target spread across the day by changing the Availability
E.g I want to be able to spread out the availability across the day to get the % variance away from the target to be within my target (The aim is to evenly spread out the intervals within the target)
So a bit like the goal seek to change every value but spread out equally if that makes sense
It might be complexed formula or VBA approach
Hopefully someone can help me give a best fit scenario  Thank You So Much
I hope you are well
I have a dataset that looks at what I require and how much I have available.
The % Of Total Requirement is the interval value over the total requirement for the day (Formula copied down =(F22/F$55)*100
The % Of % Of Total Available is the interval value over the total available for the day =(I22/I$55)*100
I then have a variance to see how far I am away from requirement =(AB22AA22)/AA22
What I want to be able to do is set a target of either 20% or 20%. I want the variance to see how far I am away from requirement to be within that target spread across the day by changing the Availability
E.g I want to be able to spread out the availability across the day to get the % variance away from the target to be within my target (The aim is to evenly spread out the intervals within the target)
So a bit like the goal seek to change every value but spread out equally if that makes sense
It might be complexed formula or VBA approach
Hopefully someone can help me give a best fit scenario  Thank You So Much