Spreadsheet: 713695d1610884215-need-formula-to-match-each-weeks-target-to-forward-volumes-restarting-each-week-210117-lead-time-problem-v2
Sheet: LEAD TIMES

[NAME] | Week | SKU ROW 4 | Stock | Inbound | Sales | Unfilled Orders | Weeks to fulfil  Order | SKU ROW 5 | Stock | Inbound | Sales | Unfilled Orders | Weeks to fulfil  Order | SKU ROW 6 | Stock | Inbound | Sales | Unfilled Orders | Weeks to fulfil  Order | SKU ROW 7 | Stock | Inbound | Sales | Unfilled Orders | Weeks to fulfil  Order | SKU ROW 8 | Stock | Inbound | Sales | Unfilled Orders | Weeks to fulfil  Order | SKU ROW 9 | Stock | Inbound | Sales | Unfilled Orders | Weeks to fulfil  Order | SKU ROW 10 | Stock | Inbound | Sales | Unfilled Orders | Weeks to fulfil  Order | SKU ROW 11 | Stock | Inbound | Sales | Unfilled Orders | Weeks to fulfil  Order | SKU ROW 12 | Stock | Inbound | Sales | Unfilled Orders | Weeks to fulfil  Order | SKU ROW 13 | Stock | Inbound | Sales | Unfilled Orders | Weeks to fulfil  Order | SKU ROW 14 | Stock | Inbound | Sales | Unfilled Orders | Weeks to fulfil  Order | SKU ROW 15 | Stock | Inbound | Sales | Unfilled Orders | Weeks to fulfil  Order | SKU ROW 16 | Stock | Inbound | Sales | Unfilled Orders | Weeks to fulfil  Order | SKU ROW 17 | Stock | Inbound | Sales | Unfilled Orders | Weeks to fulfil  Order
 | 20-28 | Code 1 |  |  |  |  |  | Code 2 |  |  |  |  |  | Code 3 |  |  |  |  |  | Code 4 |  |  |  |  |  | Code 5 |  |  |  |  |  | Code 6 |  |  |  |  |  | Code 7 |  |  |  |  |  | Code 8 |  |  |  |  |  | Code 9 |  |  |  |  |  | Code 10 |  |  |  |  |  | Code 11 |  |  |  |  |  | Code 12 |  |  |  |  |  | Code 13 |  |  |  |  |  | Code 14
 | 20-29 | Code 1 |  |  |  |  |  | Code 2 |  |  |  |  |  | Code 3 |  |  |  |  |  | Code 4 |  |  |  |  |  | Code 5 |  |  |  |  |  | Code 6 |  |  |  |  |  | Code 7 |  |  |  |  |  | Code 8 |  |  |  |  |  | Code 9 |  |  |  |  |  | Code 10 |  |  |  |  |  | Code 11 |  |  |  |  |  | Code 12 |  |  |  |  |  | Code 13 |  |  |  |  |  | Code 14
 | 20-30 | Code 1 |  |  |  |  |  | Code 2 |  |  |  |  |  | Code 3 |  |  |  |  |  | Code 4 |  |  |  |  |  | Code 5 |  |  |  |  |  | Code 6 |  |  |  |  |  | Code 7 |  |  |  |  |  | Code 8 |  |  |  |  |  | Code 9 |  |  |  |  |  | Code 10 |  |  |  |  |  | Code 11 |  |  |  |  |  | Code 12 |  |  |  |  |  | Code 13 |  |  |  |  |  | Code 14
 | 20-31 | Code 1 |  |  |  |  |  | Code 2 |  |  |  |  |  | Code 3 |  |  |  |  |  | Code 4 |  |  |  |  |  | Code 5 |  |  |  |  |  | Code 6 |  |  |  |  |  | Code 7 |  |  |  |  |  | Code 8 |  |  |  |  |  | Code 9 |  |  |  |  |  | Code 10 |  |  |  |  |  | Code 11 |  |  |  |  |  | Code 12 |  |  |  |  |  | Code 13 |  |  |  |  |  | Code 14
 | 20-32 | Code 1 |  |  |  |  |  | Code 2 |  |  |  |  |  | Code 3 |  |  |  |  |  | Code 4 |  |  |  |  |  | Code 5 |  |  |  |  |  | Code 6 |  |  |  |  |  | Code 7 |  |  |  |  |  | Code 8 |  |  |  |  |  | Code 9 |  |  |  |  |  | Code 10 |  |  |  |  |  | Code 11 |  |  |  |  |  | Code 12 |  |  |  |  |  | Code 13 |  |  |  |  |  | Code 14
 | 20-33 | Code 1 |  |  |  |  |  | Code 2 |  |  |  |  |  | Code 3 |  |  |  |  |  | Code 4 |  |  |  |  |  | Code 5 |  |  |  |  |  | Code 6 |  |  |  |  |  | Code 7 |  |  |  |  |  | Code 8 |  |  |  |  |  | Code 9 |  |  |  |  |  | Code 10 |  |  |  |  |  | Code 11 |  |  |  |  |  | Code 12 |  |  |  |  |  | Code 13 |  |  |  |  |  | Code 14
 | 20-34 | Code 1 |  |  |  |  |  | Code 2 |  |  |  |  |  | Code 3 |  |  |  |  |  | Code 4 |  |  |  |  |  | Code 5 |  |  |  |  |  | Code 6 |  |  |  |  |  | Code 7 |  |  |  |  |  | Code 8 |  |  |  |  |  | Code 9 |  |  |  |  |  | Code 10 |  |  |  |  |  | Code 11 |  |  |  |  |  | Code 12 |  |  |  |  |  | Code 13 |  |  |  |  |  | Code 14
 | 20-35 | Code 1 |  |  |  |  |  | Code 2 |  |  |  |  |  | Code 3 |  |  |  |  |  | Code 4 |  |  |  |  |  | Code 5 |  |  |  |  |  | Code 6 |  |  |  |  |  | Code 7 |  |  |  |  |  | Code 8 |  |  |  |  |  | Code 9 |  |  |  |  |  | Code 10 |  |  |  |  |  | Code 11 |  |  |  |  |  | Code 12 |  |  |  |  |  | Code 13 |  |  |  |  |  | Code 14
 |  |  |  |  |  |  |  |  |  |  |  |  | S/be PO