I have a small query that you maybe able to help me with.
It involves scheduling resource usage similar to my post:
https://chandoo.org/wp/2010/11/18/scheduling-variable-sources/
I use a similar technique shown in the attached file:
I have a list of resources (left) which are to be used in order top to bottom
They are to be used as per the production profile at the top Row 6 (Red) (left to right)
I want to calculate the weighted average grade (%Fe) Row 36 (Yellow)
I currently use a large block of helper cells to schedule the tonnages
and then use a sumproduct formula to derive the (Scheduled Tonnages x Grade) / Schedule Tonnages (Row 36)
I am after a formula which will do the grade directly from the Required schedule without the use of the helper cells (The large block of 0's and stepped data in the middle)
ie:

Sample file attached
Look forward to any and all assistance
It involves scheduling resource usage similar to my post:
https://chandoo.org/wp/2010/11/18/scheduling-variable-sources/
I use a similar technique shown in the attached file:
I have a list of resources (left) which are to be used in order top to bottom
They are to be used as per the production profile at the top Row 6 (Red) (left to right)
I want to calculate the weighted average grade (%Fe) Row 36 (Yellow)
I currently use a large block of helper cells to schedule the tonnages
and then use a sumproduct formula to derive the (Scheduled Tonnages x Grade) / Schedule Tonnages (Row 36)
I am after a formula which will do the grade directly from the Required schedule without the use of the helper cells (The large block of 0's and stepped data in the middle)
ie:

Sample file attached
Look forward to any and all assistance
Attachments
Last edited: