Spreadsheet: 835586d1688666649-sum-product-with-right-formula-sumproduct-with-right-dummy-data_jc
Sheet: Data_Recruitment Act

 |  |  |  | Actuals - Recruitment Data
 |  |  |  | 4. Input actuals regarding the recruitment process in columns E to J |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5. Select the number of periods a trend should be created for to apply to the 'Assumptions' tab
 |  |  |  |  |  | Recruitment Team |  | Adecco Stats |  | Total SCL |  |  |  |  |  |  |  |  |  |  |  |  |  | Adecco Stats |  |  |  | Moving average period >>> | 3
[NAME] | Year | Period | Week | Week Ending | Caspar | No of Applications | Interviews Booked | No of Applications | Interviews Booked | Successful | Starters in Period | Notes |  | [NAME] | Period | No of Applications | Interviews Booked | % to interview | Successful | % to medical | Starters | % of starters |  | Week Ending | No of Applications | Interviews Booked |  |  |  |  |  | P6
 | 2223 | P6 End | P6 W1 | 2022-09-23 00:00:00 | [NAME] | 66 | 55 |  |  | 18 |  |  |  | 2223P1 End | P1 |  |  | 0 |  | 0 |  | 0 |  |  | 20 | 7 |  |  |  |  |  | P7
 | 2223 | P6 End | P6 [NAME] |  | [NAME] | 84 | 48 |  |  | 18 |  |  |  | 2223P2 End | P2 |  |  | 0 |  | 0 |  | 0 |  |  | 30 | 10 |  |  |  |  |  | P8
 | 2223 | P6 End | P6 W3 |  | [NAME] | 58 | 54 |  |  | 13 |  |  |  | 2223P3 End | P3 |  |  | 0 |  | 0 |  | 0 |  |  | 54 | 16 |  |  |  |  |  | P9
 | 2223 | P6 End | P6 W4 |  | [NAME] | 79 | 64 |  |  | 15 | 52 |  |  | 2223P4 End | P4 |  |  | 0 |  | 0 |  | 0 |  |  | 58 | 23 |  |  |  |  |  | P10
 | 2223 | P7 End | P7 W1 |  | [NAME] | 88 | 64 |  |  | 16 |  |  |  | 2223P5 End | P5 |  |  | 0 |  | 0 |  | 0 |  |  | 32 | 20 |  |  |  |  |  | P11
 | 2223 | P7 End | P7 W2 |  | [NAME] | 54 | 47 |  |  | 12 |  |  |  | 2223P6 End | P6 |  |  |  |  |  |  |  |  |  | 65 | 21 |  |  |  |  |  | P12
 | 2223 | P7 End | P7 W3 |  | 1.5 days of Caspar | 80 | 62 |  |  | 17 |  |  |  | 2223P7 End | P7 |  |  |  |  |  |  |  |  |  | 63 | 34 |  |  |  |  |  | P13
 | 2223 | P7 End | P7 W4 |  | Post Caspar | 208 | 79 |  |  | 24 | 40 |  |  | 2223P8 End | P8 |  |  |  |  |  |  |  |  |  | 76 | 28 |  |  |  |  |  | P1
 | 2223 | P8 End | P8 W1 |  | Post Caspar | 287 | 83 |  |  | 23 |  |  |  | 2223P9 End | P9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P2
 | 2223 | P8 End | [NAME] |  | Post Caspar | 190 | 83 |  |  | 23 |  |  |  | 2223P10 End | P10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P3
 | 2223 | P8 End | [NAME] |  | Post Caspar | 176 | 113 |  |  | 35 |  |  |  | 2223P11 End | P11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P4
 | 2223 | P8 End | P8 W4 |  | Post Caspar | 214 | 99 |  |  | 22 | 45 |  |  | 2223P12 End | P12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P5
 | 2223 | P9 End | P9 W1 |  | Post Caspar | 206 | 154 |  |  | 32 |  | inc Sat Recruitment Day |  | 2223P13 End | P13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P6
 | 2223 | P9 End | [NAME] |  | Post Caspar | 179 | 78 |  |  | 21 |  |  |  | 2324P1 End | P1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P7
 | 2223 | P9 End | P9 W3 |  | Post Caspar | 134 | 23 |  |  | 3 |  | [NAME] week |  | 2324P2 End | P2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P8
 | 2223 | P9 End | P9 W4 |  | Post Caspar | 280 | 70 |  |  | 20 | 27 |  |  | 2324P3 End | P3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P9
 | 2223 | P10 End | P10 W1 |  | Post Caspar | 206 | 84 |  |  | 25 |  |  |  | 2324P4 End | P4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P10
 | 2223 | P10 End | P10 W2 |  | Post Caspar | 273 | 117 |  |  | 30 |  | inc Sat 14/1/23 |  | 2324P5 End | P5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P11
 | 2223 | P10 End | P10 W3 |  | Post Caspar | 240 | 114 |  |  | 42 |  |  |  | 2324P6 End | P6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P12
 | 2223 | P10 End | P10 W4 |  | Post Caspar | 284 | 99 |  |  | 27 | 68 |  |  | 2324P7 End | P7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P13
 | 2223 | P11 End | P11 W1 |  |  | 266 | 98 |  |  | 30 |  |  |  | 2324P8 End | P8
 | 2223 | P11 End | P11 W2 |  |  | 261 | 113 |  |  | 35 |  |  |  | 2324P9 End | P9
 | 2223 | P11 End | P11 W3 |  |  | 274 | 143 |  |  | 40 |  |  |  | 2324P10 End | P10
 | 2223 | P11 End | P11 W4 |  |  | 275 | 151 |  |  | 46 | 85 |  |  | 2324P11 End | P11
 | 2223 | P12 End | P12 W1 |  |  | 308 | 156 |  |  | 43 |  |  |  | 2324P12 End | P12
 | 2223 | P12 End | [NAME] |  |  | 285 | 118 |  |  | 30 |  |  |  | 2324P13 End | P13
 | 2223 | P12 End | P12 W3 |  |  | 298 | 140 |  |  | 53
 | 2223 | P12 End | P12 W4 |  |  | 421 | 147 |  |  | 42 | 77
 | 2223 | P13 End | P13 W1 |  |  | 280 | 125 |  |  | 33
 | 2223 | P13 End | [NAME] |  |  | 320 | 129 |  |  | 25
 | 2223 | P13 End | P13 W3 |  |  | 342 | 175 |  |  | 49
 | 2223 | P13 End | [NAME] |  |  | 314 | 202 |  |  | 51 | 72
 | 2324 | P1 End | P1 W1 |  |  | 355 | 114 | 20 | 7 | 36
 | 2324 | P1 End | [NAME] |  |  | 354 | 176 | 30 | 10 | 45 |  | inc Sat 13/5/23
 | 2324 | P1 End | P1 W3 |  |  | 293 | 182 | 54 | 16 | 54
 | 2324 | P1 End | P1 W4 |  |  | 243 | 166 | 58 | 23 | 43 | 73
 | 2324 | [NAME] | [NAME] |  |  | 347 | 128 | 32 | 20 | 31
 | 2324 | [NAME] | [NAME] |  |  | 370 | 181 | 65 | 21 | 51
 | 2324 | [NAME] | [NAME] |  |  | 375 | 172 | 63 | 34 | 43
 | 2324 | [NAME] | [NAME] |  |  | 370 | 202 | 76 | 28 | 66 | 90
 | 2324 | [NAME] | [NAME] |  |  | 417 | 150 |  |  | 36
 | 2324 | [NAME] | [NAME]
 | 2324 | [NAME] | [NAME]
 | 2324 | [NAME] | [NAME]
 | 2324 | P4 End | P4 W1
 | 2324 | P4 End | P4 [NAME]
 | 2324 | P4 End | P4 W3
 | 2324 | P4 End | P4 W4
 | 2324 | P5 End | P5 W1
 | 2324 | P5 End | P5 [NAME]
 | 2324 | P5 End | P5 W3
 | 2324 | P5 End | P5 W4
 | 2324 | P6 End | P6 W1
 | 2324 | P6 End | P6 [NAME]
 | 2324 | P6 End | P6 W3
 | 2324 | P6 End | P6 W4
 | 2324 | P7 End | P7 W1
 | 2324 | P7 End | P7 W2
 | 2324 | P7 End | P7 W3
 | 2324 | P7 End | P7 W4
 | 2324 | P8 End | P8 W1
 | 2324 | P8 End | [NAME]
 | 2324 | P8 End | [NAME]
 | 2324 | P8 End | P8 W4
 | 2324 | P9 End | P9 W1
 | 2324 | P9 End | [NAME]
 | 2324 | P9 End | P9 W3
 | 2324 | P9 End | P9 W4
 | 2324 | P10 End | P10 W1
 | 2324 | P10 End | P10 W2
 | 2324 | P10 End | P10 W3
 | 2324 | P10 End | P10 W4
 | 2324 | P11 End | P11 W1
 | 2324 | P11 End | P11 W2
 | 2324 | P11 End | P11 W3
 | 2324 | P11 End | P11 W4
 | 2324 | P12 End | P12 W1
 | 2324 | P12 End | [NAME]
 | 2324 | P12 End | P12 W3
 | 2324 | P12 End | P12 W4
 | 2324 | P13 End | P13 W1
 | 2324 | P13 End | [NAME]
 | 2324 | P13 End | P13 W3
 | 2324 | P13 End | [NAME]