Spreadsheet: 722746d1615390815-formula-fails-to-copy-correctly-example
Sheet: Staff

Name | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight | Weeks Hrs | Rate | £ ph | Overnight
 | 2021-01-01 00:00:00
a | 10 | 1 |  | 1
b | 12 | 3 |  | 2
c | 40 | 5
d | 12 | 2 |  | 3
e | 11 | 6 |  | 1
f | 36 | 7
g | 27 | 7 |  | 1
h | 2 | 2 |  | 1
i | 19 | 3
j | 17 | 5 |  | 2
k | 10 | 4 |  | 1