Spreadsheet: 826150d1681828016-combine-if-with-offset-dynamic-lookup-dummy-data_adativs
Sheet: Assumptions

 |  |  | 22/23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23/24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22/23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23/24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22/23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23/24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22/23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23/24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22/23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23/24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22/23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23/24
 |  | Period | P1 W1 | [NAME] | P1 W3 | P1 W4 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | P4 W1 | P4 [NAME] | P4 W3 | P4 W4 | P5 W1 | P5 [NAME] | P5 W3 | P5 W4 | P6 W1 | P6 [NAME] | P6 W3 | P6 W4 | P7 W1 | P7 W2 | P7 W3 | P7 W4 | P8 W1 | [NAME] | [NAME] | P8 W4 | P9 W1 | [NAME] | P9 W3 | P9 W4 | P10 W1 | P10 W2 | P10 W3 | P10 W4 | P11 W1 | P11 W2 | P11 W3 | P11 W4 | P12 W1 | [NAME] | P12 W3 | P12 W4 | P13 W1 | [NAME] | P13 W3 | [NAME] | P1 W1 | [NAME] | P1 W3 | P1 W4 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | P4 W1 | P4 [NAME] | P4 W3 | P4 W4 | P5 W1 | P5 [NAME] | P5 W3 | P5 W4 | P6 W1 | P6 [NAME] | P6 W3 | P6 W4 | P7 W1 | P7 W2 | P7 W3 | P7 W4 | P8 W1 | [NAME] | [NAME] | P8 W4 | P9 W1 | [NAME] | P9 W3 | P9 W4 | P10 W1 | P10 W2 | P10 W3 | P10 W4 | P11 W1 | P11 W2 | P11 W3 | P11 W4 | P12 W1 | [NAME] | P12 W3 | P12 W4 | P13 W1 | [NAME] | P13 W3 | [NAME] | P1 W1 | [NAME] | P1 W3 | P1 W4 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | P4 W1 | P4 [NAME] | P4 W3 | P4 W4 | P5 W1 | P5 [NAME] | P5 W3 | P5 W4 | P6 W1 | P6 [NAME] | P6 W3 | P6 W4 | P7 W1 | P7 W2 | P7 W3 | P7 W4 | P8 W1 | [NAME] | [NAME] | P8 W4 | P9 W1 | [NAME] | P9 W3 | P9 W4 | P10 W1 | P10 W2 | P10 W3 | P10 W4 | P11 W1 | P11 W2 | P11 W3 | P11 W4 | P12 W1 | [NAME] | P12 W3 | P12 W4 | P13 W1 | [NAME] | P13 W3 | [NAME] | P1 W1 | [NAME] | P1 W3 | P1 W4 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | P4 W1 | P4 [NAME] | P4 W3 | P4 W4 | P5 W1 | P5 [NAME] | P5 W3 | P5 W4 | P6 W1 | P6 [NAME] | P6 W3 | P6 W4 | P7 W1 | P7 W2 | P7 W3 | P7 W4 | P8 W1 | [NAME] | [NAME] | P8 W4 | P9 W1 | [NAME] | P9 W3 | P9 W4 | P10 W1 | P10 W2 | P10 W3 | P10 W4 | P11 W1 | P11 W2 | P11 W3 | P11 W4 | P12 W1 | [NAME] | P12 W3 | P12 W4 | P13 W1 | [NAME] | P13 W3 | [NAME] | P1 W1 | [NAME] | P1 W3 | P1 W4 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | P4 W1 | P4 [NAME] | P4 W3 | P4 W4 | P5 W1 | P5 [NAME] | P5 W3 | P5 W4 | P6 W1 | P6 [NAME] | P6 W3 | P6 W4 | P7 W1 | P7 W2 | P7 W3 | P7 W4 | P8 W1 | [NAME] | [NAME] | P8 W4 | P9 W1 | [NAME] | P9 W3 | P9 W4 | P10 W1 | P10 W2 | P10 W3 | P10 W4 | P11 W1 | P11 W2 | P11 W3 | P11 W4 | P12 W1 | [NAME] | P12 W3 | P12 W4 | P13 W1 | [NAME] | P13 W3 | [NAME] | P1 W1 | [NAME] | P1 W3 | P1 W4 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | P4 W1 | P4 [NAME] | P4 W3 | P4 W4 | P5 W1 | P5 [NAME] | P5 W3 | P5 W4 | P6 W1 | P6 [NAME] | P6 W3 | P6 W4 | P7 W1 | P7 W2 | P7 W3 | P7 W4 | P8 W1 | [NAME] | [NAME] | P8 W4 | P9 W1 | [NAME] | P9 W3 | P9 W4 | P10 W1 | P10 W2 | P10 W3 | P10 W4 | P11 W1 | P11 W2 | P11 W3 | P11 W4 | P12 W1 | [NAME] | P12 W3 | P12 W4 | P13 W1 | [NAME] | P13 W3 | [NAME] | P1 W1 | [NAME] | P1 W3 | P1 W4 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | P4 W1 | P4 [NAME] | P4 W3 | P4 W4 | P5 W1 | P5 [NAME] | P5 W3 | P5 W4 | P6 W1 | P6 [NAME] | P6 W3 | P6 W4 | P7 W1 | P7 W2 | P7 W3 | P7 W4 | P8 W1 | [NAME] | [NAME] | P8 W4 | P9 W1 | [NAME] | P9 W3 | P9 W4 | P10 W1 | P10 W2 | P10 W3 | P10 W4 | P11 W1 | P11 W2 | P11 W3 | P11 W4 | P12 W1 | [NAME] | P12 W3 | P12 W4 | P13 W1 | [NAME] | P13 W3 | [NAME] | P1 W1 | [NAME] | P1 W3 | P1 W4 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | P4 W1 | P4 [NAME] | P4 W3 | P4 W4 | P5 W1 | P5 [NAME] | P5 W3 | P5 W4 | P6 W1 | P6 [NAME] | P6 W3 | P6 W4 | P7 W1 | P7 W2 | P7 W3 | P7 W4 | P8 W1 | [NAME] | [NAME] | P8 W4 | P9 W1 | [NAME] | P9 W3 | P9 W4 | P10 W1 | P10 W2 | P10 W3 | P10 W4 | P11 W1 | P11 W2 | P11 W3 | P11 W4 | P12 W1 | [NAME] | P12 W3 | P12 W4 | P13 W1 | [NAME] | P13 W3 | [NAME] | P1 W1 | [NAME] | P1 W3 | P1 W4 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | P4 W1 | P4 [NAME] | P4 W3 | P4 W4 | P5 W1 | P5 [NAME] | P5 W3 | P5 W4 | P6 W1 | P6 [NAME] | P6 W3 | P6 W4 | P7 W1 | P7 W2 | P7 W3 | P7 W4 | P8 W1 | [NAME] | [NAME] | P8 W4 | P9 W1 | [NAME] | P9 W3 | P9 W4 | P10 W1 | P10 W2 | P10 W3 | P10 W4 | P11 W1 | P11 W2 | P11 W3 | P11 W4 | P12 W1 | [NAME] | P12 W3 | P12 W4 | P13 W1 | [NAME] | P13 W3 | [NAME] | P1 W1 | [NAME] | P1 W3 | P1 W4 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | P4 W1 | P4 [NAME] | P4 W3 | P4 W4 | P5 W1 | P5 [NAME] | P5 W3 | P5 W4 | P6 W1 | P6 [NAME] | P6 W3 | P6 W4 | P7 W1 | P7 W2 | P7 W3 | P7 W4 | P8 W1 | [NAME] | [NAME] | P8 W4 | P9 W1 | [NAME] | P9 W3 | P9 W4 | P10 W1 | P10 W2 | P10 W3 | P10 W4 | P11 W1 | P11 W2 | P11 W3 | P11 W4 | P12 W1 | [NAME] | P12 W3 | P12 W4 | P13 W1 | [NAME] | P13 W3 | [NAME] | P1 W1 | [NAME] | P1 W3 | P1 W4 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | P4 W1 | P4 [NAME] | P4 W3 | P4 W4 | P5 W1 | P5 [NAME] | P5 W3 | P5 W4 | P6 W1 | P6 [NAME] | P6 W3 | P6 W4 | P7 W1 | P7 W2 | P7 W3 | P7 W4 | P8 W1 | [NAME] | [NAME] | P8 W4 | P9 W1 | [NAME] | P9 W3 | P9 W4 | P10 W1 | P10 W2 | P10 W3 | P10 W4 | P11 W1 | P11 W2 | P11 W3 | P11 W4 | P12 W1 | [NAME] | P12 W3 | P12 W4 | P13 W1 | [NAME] | P13 W3 | [NAME] | P1 W1 | [NAME] | P1 W3 | P1 W4 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | P4 W1 | P4 [NAME] | P4 W3 | P4 W4 | P5 W1 | P5 [NAME] | P5 W3 | P5 W4 | P6 W1 | P6 [NAME] | P6 W3 | P6 W4 | P7 W1 | P7 W2 | P7 W3 | P7 W4 | P8 W1 | [NAME] | [NAME] | P8 W4 | P9 W1 | [NAME] | P9 W3 | P9 W4 | P10 W1 | P10 W2 | P10 W3 | P10 W4 | P11 W1 | P11 W2 | P11 W3 | P11 W4 | P12 W1 | [NAME] | P12 W3 | P12 W4 | P13 W1 | [NAME] | P13 W3 | [NAME]
 | Staff on books (FTE)
 | Leavers by geographic location |  | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Attrition rate % | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | Internal Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | TUPE Transfers | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Loss of Route | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations | Change to contract variations
 | Depot
 | London
 | Paris
 | Helsinki
 | Geneva
 | Stockport
 | Edinburgh
 | Birmingham
 | [NAME]
 | Liverpool
 | Marseille
 | Madrid
 | Barcelona
 | Zurich
 | Average
Stage | Starters |  | I want a formula that is dynamic here. So at the moment, if you go to rows 58 to 68 you have assumption cells which you can put your own numbers into e.g. 1 week or 5 weeks or 5% success rate or 85% success rate. So I want formula that when the cell below is changed e.g. from 1 week to 2 weeks,or the % rates it's going to apply to the apps to the previous stage (row)
0 | Applications
1 | Apps to interviews
2 | Successful at medicals
3 | Successful medicals to training school
4 | Successful trainees at training school
 | KPIs
 | Avg no. of applications p/period
 | % of apps into interviews
 | % of succesful interviews for training school
 | % successful at training school
 | Trainee % per depot | Average
 | London
 | Paris
 | Helsinki
 | Geneva
 | Stockport
 | Edinburgh
 | Birmingham
 | [NAME]
 | Liverpool
 | Marseille
 | Madrid
 | Barcelona
 | Zurich
 | Total
 | Lead time: | 5. Input assumptions below
1 | Apps to interviews | 1 | week |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | can I use this and incorprate it into rows 32 - 34 so you can update lead times and see the impact
2 | Interview to Medical | 1 | week
3 | Medical to Training School | 1 | week
4 | Training school completion | 6 | weeks
 | Total lead time |  | weeks
 | Success rates from previous stage:
1 | Apps to interview | 0.77
2 | Interview to Medical | 0.27
3 | Medical to Training School | 0.54
4 | Training school completion | 0.71