Your help please, I have a spreadsheet that is updated weekly which basically counts the requisitions in our dept & age. What I am trying to do is count how many are processed each week. This is not a simple calculation of 1 weeks total minus the previous weeks total.
Spreadsheet as follows
I will try to explain more
if you look at the data, MRP 1 shows 25 (new requisitions – under 1 week) etc
if this 25 requisitions were not actioned in week 1, they would move to ‘1-2 WEEKS column’ on ‘MRP RUN 2’, as 25 were actioned this is shown as ‘0’
If you look at the data, MRP 3 shows 55 new requisitions
IfColumn C shows 1, 66 were actioned that week.
I Need help with a calculation which shows how many were actioned.
Can this be done, as its difficult to explain!!
Spreadsheet as follows
Book1 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | MRPRUN | >1WEEK | 1-2WEEKS | 2-4WEEKS | 4+ | ||
2 | 1 | 25 | 6 | 13 | 305 | ||
3 | 2 | 67 | 0 | 2 | 319 | ||
4 | 3 | 55 | 1 | 10 | 306 | ||
5 | 4 | 24 | 47 | 8 | 311 | ||
Sheet1 |
I will try to explain more
if you look at the data, MRP 1 shows 25 (new requisitions – under 1 week) etc
if this 25 requisitions were not actioned in week 1, they would move to ‘1-2 WEEKS column’ on ‘MRP RUN 2’, as 25 were actioned this is shown as ‘0’
If you look at the data, MRP 3 shows 55 new requisitions
IfColumn C shows 1, 66 were actioned that week.
I Need help with a calculation which shows how many were actioned.
Can this be done, as its difficult to explain!!