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

Attrition rates
2. Copy and paste period data from 'Turnover figures' spreadsheet into respective period to obtain latest attrition rates
3. Input leavers due to transfers/contract variations into the green section
 | 22/23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23/24
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 99 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 112 | 113 | 114 | 115 | 116 | 117 | 118 | 119 | 120 | 121 | 122 | 123 | 124 | 125 | 126 | 127 | 128 | 129 | 130 | 131 | 132 | 133 | 134 | 135 | 136 | 137 | 138 | 139 | 140 | 141 | 142 | 143 | 144 | 145 | 146 | 147 | 148 | 149 | 150 | 151 | 152 | 153 | 154 | 155 | 156 | 157 | 158 | 159 | 160 | 161 | 162 | 163 | 164 | 165 | 166 | 167 | 168 | 169 | 170 | 171 | 172 | 173 | 174 | 175 | 176 | 177 | 178 | 179 | 180 | 181 | 182
Period | P1 | P1 | P1 | P1 | P1 | P1 | P1 | P2 | P2 | P2 | P2 | P2 | P2 | P2 | P3 | P3 | P3 | P3 | P3 | P3 | P3 | P4 | P4 | P4 | P4 | P4 | P4 | P4 | P5 | P5 | P5 | P5 | P5 | P5 | P5 | P6 | P6 | P6 | P6 | P6 | P6 | P6 | P7 | P7 | P7 | P7 | P7 | P7 | P7 | P8 | P8 | P8 | P8 | P8 | P8 | P8 | P9 | P9 | P9 | P9 | P9 | P9 | P9 | P10 | P10 | P10 | P10 | P10 | P10 | P10 | P11 | P11 | P11 | P11 | P11 | P11 | P11 | P12 | P12 | P12 | P12 | P12 | P12 | P12 | P13 | P13 | P13 | P13 | P13 | P13 | P13 | P1 | P1 | P1 | P1 | P1 | P1 | P1 | P2 | P2 | P2 | P2 | P2 | P2 | P2 | P3 | P3 | P3 | P3 | P3 | P3 | P3 | P4 | P4 | P4 | P4 | P4 | P4 | P4 | P5 | P5 | P5 | P5 | P5 | P5 | P5 | P6 | P6 | P6 | P6 | P6 | P6 | P6 | P7 | P7 | P7 | P7 | P7 | P7 | P7 | P8 | P8 | P8 | P8 | P8 | P8 | P8 | P9 | P9 | P9 | P9 | P9 | P9 | P9 | P10 | P10 | P10 | P10 | P10 | P10 | P10 | P11 | P11 | P11 | P11 | P11 | P11 | P11 | P12 | P12 | P12 | P12 | P12 | P12 | P12 | P13 | P13 | P13 | P13 | P13 | P13 | P13
Depot | Total No of employed drivers | Total No  of leavers | Period Attrition Rate % | Internal transfers | TUPE transfers | Loss of route | Change to contract variations | Total No of employed drivers | Total No  of leavers | Period Attrition Rate % | Internal transfers | TUPE transfers | Loss of route | Change to contract variations | Total No of employed drivers | Total No  of leavers | Period Attrition Rate % | Internal transfers | TUPE transfers | Loss of route | Change to contract variations | Total No of employed drivers | Total No  of leavers | Period Attrition Rate % | Internal transfers | TUPE transfers | Loss of route | Change to contract variations | Total No of employed drivers | Total No  of leavers | Period Attrition Rate % | Internal transfers | TUPE transfers | Loss of route | Change to contract variations | Total No of employed drivers | Total No  of leavers | Period Attrition Rate % | Internal transfers | TUPE transfers | Loss of route | Change to contract variations | Total No of employed drivers | Total No  of leavers | Period Attrition Rate % | Internal transfers | TUPE transfers | Loss of route | Change to contract variations | Total No of employed drivers | Total No  of leavers | Period Attrition Rate % | Internal transfers | TUPE transfers | Loss of route | Change to contract variations | Total No of employed drivers | Total No  of leavers | Period Attrition Rate % | Internal transfers | TUPE transfers | Loss of route | Change to contract variations | Total No of employed drivers | Total No  of leavers | Period Attrition Rate % | Internal transfers | TUPE transfers | Loss of route | Change to contract variations | Total No of employed drivers | Total No  of leavers | Period Attrition Rate % | Internal transfers | TUPE transfers | Loss of route | Change to contract variations | Total No of employed drivers | Total No  of leavers | Period Attrition Rate % | Internal transfers | TUPE transfers | Loss of route | Change to contract variations | Total No of employed drivers | Total No of leavers | Period Attrition Rate % | Internal transfers | TUPE transfers | Loss of route | Change to contract variations | Total No of employed drivers | Total No  of leavers | Period Attrition Rate % | Internal transfers | TUPE transfers | Loss of route | Change to contract variations | Total No of employed drivers | Total No  of leavers | Period Attrition Rate % | Internal transfers | TUPE transfers | Loss of route | Change to contract variations | Total No of employed drivers | Total No  of leavers | Period Attrition Rate % | Internal transfers | TUPE transfers | Loss of route | Change to contract variations | Total No of employed drivers | Total No  of leavers | Period Attrition Rate % | Internal transfers | TUPE transfers | Loss of route | Change to contract variations | Total No of employed drivers | Total No  of leavers | Period Attrition Rate % | Internal transfers | TUPE transfers | Loss of route | Change to contract variations | Total No of employed drivers | Total No  of leavers | Period Attrition Rate % | Internal transfers | TUPE transfers | Loss of route | Change to contract variations | Total No of employed drivers | Total No  of leavers | Period Attrition Rate % | Internal transfers | TUPE transfers | Loss of route | Change to contract variations | Total No of employed drivers | Total No  of leavers | Period Attrition Rate % | Internal transfers | TUPE transfers | Loss of route | Change to contract variations | Total No of employed drivers | Total No  of leavers | Period Attrition Rate % | Internal transfers | TUPE transfers | Loss of route | Change to contract variations | Total No of employed drivers | Total No  of leavers | Period Attrition Rate % | Internal transfers | TUPE transfers | Loss of route | Change to contract variations | Total No of employed drivers | Total No  of leavers | Period Attrition Rate % | Internal transfers | TUPE transfers | Loss of route | Change to contract variations | Total No of employed drivers | Total No  of leavers | Period Attrition Rate % | Internal transfers | TUPE transfers | Loss of route | Change to contract variations | Total No of employed drivers | Total No of leavers | Period Attrition Rate % | Internal transfers | TUPE transfers | Loss of route | Change to contract variations
London | 356.5 | 2.5 | 0.007012622720897616 |  |  |  |  | 357.5 | 3.5 | 0.009790209790209791 |  |  |  |  | 356 | 6 | 0.01685393258426966 |  |  |  |  | 352.5 | 4.5 | 0.01276595744680851 |  |  |  |  | 349.5 | 5.5 | 0.01573676680972818 |  |  |  |  | 346.5 | 8.5 | 0.02453102453102453 |  |  |  |  | 343 | 6 | 0.01749271137026239 |  |  |  |  | 341.5 | 5 | 0.01464128843338214 |  |  |  |  | 341.5 | 4 | 0.01171303074670571 |  |  |  |  | 339.5 | 2.5 | 0.007363770250368188 |  |  |  |  | 340 | 1.5 | 0.004411764705882353
Paris | 381 | 3 | 0.007874015748031496 |  |  |  |  | 380 | 4 | 0.01052631578947368 |  |  |  |  | 376 | 6.5 | 0.01728723404255319 |  |  |  |  | 375 | 7.5 | 0.02 |  |  |  |  | 371.5 | 4.5 | 0.01211305518169583 |  |  |  |  | 363 | 11.5 | 0.03168044077134986 |  |  |  |  | 364 | 1 | 0.002747252747252747 |  |  |  |  | 362 | 2 | 0.005524861878453038 |  |  |  |  | 364 | 2.5 | 0.006868131868131868 |  |  |  |  | 363.5 | 7.5 | 0.02063273727647868 |  |  |  |  | 358 | 5 | 0.01396648044692737
Helsinki | 289 | 2 | 0.006920415224913495 |  |  |  |  | 286.5 | 7 | 0.02443280977312391 |  |  |  |  | 285 | 2 | 0.007017543859649123 |  |  |  |  | 285 | 2 | 0.007017543859649123 |  |  |  |  | 284 | 7.5 | 0.02640845070422535 |  |  |  |  | 282.5 | 5 | 0.01769911504424779 |  |  |  |  | 282 | 1 | 0.003546099290780142 |  |  |  |  | 288 | 1 | 0.003472222222222222 |  |  |  |  | 287 | 3 | 0.01045296167247387 |  |  |  |  | 284.5 | 1 | 0.00351493848857645 |  |  |  |  | 284.5 | 3.5 | 0.01230228471001757
Geneva | 306 | 2 | 0.006535947712418301 |  |  |  |  | 301.5 | 6 | 0.01990049751243781 |  |  |  |  | 296 | 5 | 0.01689189189189189 |  |  |  |  | 296.5 | 2.5 | 0.008431703204047217 |  |  |  |  | 302.5 | 0.5 | 0.001652892561983471 |  |  |  |  | 299.5 | 5 | 0.01669449081803005 |  |  |  |  | 300 | 2 | 0.006666666666666667 |  |  |  |  | 302 | 1 | 0.003311258278145695 |  |  |  |  | 306.5 | 2.5 | 0.008156606851549755 |  |  |  |  | 303.5 | 8.5 | 0.02800658978583196 |  |  |  |  | 307 | 1 | 0.003257328990228013
Stockport | 327.5 | 2.5 | 0.007633587786259542 |  |  |  |  | 322 | 6 | 0.01863354037267081 |  |  |  |  | 322.5 | 5 | 0.01550387596899225 |  |  |  |  | 320 | 7 | 0.021875 |  |  |  |  | 321 | 7.5 | 0.02336448598130841 |  |  |  |  | 322.5 | 6 | 0.0186046511627907 |  |  |  |  | 325 | 4 | 0.01230769230769231 |  |  |  |  | 325.5 | 3 | 0.009216589861751152 |  |  |  |  | 325 | 4.5 | 0.01384615384615385 |  |  |  |  | 323.5 | 4 | 0.01236476043276661 |  |  |  |  | 314 | 4.5 | 0.0143312101910828
Edinburgh | 309 | 14 | 0.0453074433656958 |  |  |  |  | 309 | 4 | 0.01294498381877023 |  |  |  |  | 306.5 | 7.5 | 0.02446982055464927 |  |  |  |  | 299.5 | 10 | 0.0333889816360601 |  |  |  |  | 282.5 | 14 | 0.0495575221238938 |  |  |  |  | 270.5 | 8 | 0.02957486136783734 |  |  |  |  | 270 | 2 | 0.007407407407407408 |  |  |  |  | 261 | 4 | 0.01532567049808429 |  |  |  |  | 264 | 3 | 0.01136363636363636 |  |  |  |  | 253 | 5 | 0.01976284584980237 |  |  |  |  | 256.5 | 3 | 0.01169590643274854
Birmingham | 190.5 | 2.5 | 0.01312335958005249 |  |  |  |  | 191 | 2.5 | 0.01308900523560209 |  |  |  |  | 194 | 2 | 0.01030927835051546 |  |  |  |  | 192.5 | 3 | 0.01558441558441558 |  |  |  |  | 192.5 | 1 | 0.005194805194805195 |  |  |  |  | 192 | 1 | 0.005208333333333333 |  |  |  |  | 194 | 0 | 0 |  |  |  |  | 201 | 1 | 0.004975124378109453 |  |  |  |  | 199.5 | 3.5 | 0.01754385964912281 |  |  |  |  | 201.5 | 2 | 0.009925558312655087 |  |  |  |  | 200.5 | 2 | 0.00997506234413965
[NAME] | 100 | 0 | 0 |  |  |  |  | 97.5 | 2 | 0.02051282051282051 |  |  |  |  | 98.5 | 0 | 0 |  |  |  |  | 98 | 1 | 0.01020408163265306 |  |  |  |  | 97 | 2 | 0.02061855670103093 |  |  |  |  | 97.5 | 2 | 0.02051282051282051 |  |  |  |  | 96.5 | 1 | 0.01036269430051814 |  |  |  |  | 93.5 | 2 | 0.0213903743315508 |  |  |  |  | 96.5 | 0 | 0 |  |  |  |  | 96 | 1 | 0.01041666666666667 |  |  |  |  | 96.5 | 1 | 0.01036269430051814
Liverpool | 433 | 9 | 0.0207852193995381 |  |  |  |  | 423 | 10.5 | 0.02482269503546099 |  |  |  |  | 419.5 | 5 | 0.01191895113230036 |  |  |  |  | 414.5 | 6 | 0.01447527141133896 |  |  |  |  | 414.5 | 11 | 0.02653799758745477 |  |  |  |  | 412.5 | 5.5 | 0.01333333333333333 |  |  |  |  | 413.5 | 2.5 | 0.006045949214026602 |  |  |  |  | 415 | 2 | 0.004819277108433735 |  |  |  |  | 409.5 | 6.5 | 0.01587301587301587 |  |  |  |  | 407.5 | 8 | 0.0196319018404908 |  |  |  |  | 404.5 | 4.5 | 0.01112484548825711
Marseille | 486.5 | 12 | 0.02466598150051387 |  |  |  |  | 483 | 6.5 | 0.01345755693581781 |  |  |  |  | 481.5 | 7 | 0.01453790238836968 |  |  |  |  | 482.5 | 3 | 0.006217616580310881 |  |  |  |  | 476.5 | 9 | 0.01888772298006296 |  |  |  |  | 475.5 | 9.5 | 0.01997896950578339 |  |  |  |  | 459.5 | 15.5 | 0.03373231773667029 |  |  |  |  | 454.5 | 7 | 0.0154015401540154 |  |  |  |  | 452.5 | 3 | 0.006629834254143646 |  |  |  |  | 441.5 | 10.5 | 0.02378255945639864 |  |  |  |  | 435.5 | 7 | 0.01607347876004592
Madrid | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 |  |  |  |  | 393 | 4 | 0.01017811704834606 |  |  |  |  | 386 | 8 | 0.02072538860103627 |  |  |  |  | 381 | 8 | 0.02099737532808399 |  |  |  |  | 380 | 1 | 0.002631578947368421 |  |  |  |  | 376 | 5 | 0.01329787234042553 |  |  |  |  | 376 | 2 | 0.005319148936170213 |  |  |  |  | 371 | 4 | 0.01078167115902965 |  |  |  |  | 365 | 6 | 0.01643835616438356 |  |  |  |  | 359.5 | 6 | 0.01668984700973574
Barcelona | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 |  |  |  |  | 247 | 1 | 0.004048582995951417 |  |  |  |  | 245 | 3 | 0.01224489795918367 |  |  |  |  | 240 | 2 | 0.008333333333333333 |  |  |  |  | 240 | 0 | 0 |  |  |  |  | 239 | 3 | 0.01255230125523013 |  |  |  |  | 240 | 0 | 0 |  |  |  |  | 235 | 4 | 0.01702127659574468
Zurich | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 |  |  |  |  | 164.5 | 1 | 0.0060790273556231 |  |  |  |  | 157.5 | 8 | 0.05079365079365079 |  |  |  |  | 158 | 2 | 0.01265822784810127 |  |  |  |  | 160 | 0 | 0 |  |  |  |  | 160 | 0 | 0 |  |  |  |  | 159 | 4 | 0.02515723270440252 |  |  |  |  | 162 | 0 | 0
Total