Just been looking at the model. I’m going to need more guidance here as it’s very detailed and it would take me a lot of time to understand it all.
Can we really just break down exactly the calculation you need here.
I don’t really know where these come from
Asking Rate for the month =
Plan Quantity + [ [ Plan Quantity - Actual Quantity ] / Completed working days ]
Are these measures or columns?
I’m looking at this page and can’t see them
I understand these are the variance
But then asking rate? I’m not really sure how you get to there from here?
The strategy with things like this is really try to break things down into small parts and then build them back up again.
I always like to start with as clear a page as possible and then work through each element of a more complex formula. That way I can understand each part and know how it works within a table or with any particular context
I really recommend doing this if something is confusing you here.
Step things out as much as possible.