Spreadsheet: 767533d1644508680-drag-a-formula-across-365-columns-skipping-1-row-every-3-columns-dragged-original-file-test1-1-
Sheet: TAB3

 |  | January |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | February |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | March |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | April |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | June |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | July |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | August |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | October |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | November |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | December
 | Name | 1st | 1st | 1st | 2nd | 2nd | 2nd | 3rd | 3rd | 3rd |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  | 11 |  |  | 12 |  |  | 13 |  |  | 14 |  |  | 15 |  |  | 16 |  |  | 17 |  |  | 18 |  |  | 19 |  |  | 20 |  |  | 21 |  |  | 22 |  |  | 23 |  |  | 24 |  |  | 25 |  |  | 26 |  |  | 27 |  |  | 28 |  |  | 29 |  |  | 30 |  |  | 31 |  |  |  | 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 |  |  | 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 |  |  | 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 |  |  | 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 |  |  | 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 |  |  | 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 |  |  | 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 |  |  | 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 |  |  | 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 |  |  | 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 |  |  | 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
 |  | hour | day | night | hour | day | night | hour | day | night | hour | day | night | hour | day | night | hour | day | night | hour | day | night | hour | day | night | hour | day | night
 | Employee1 |  | S8 |  | 07:00:00 | 1900-01-08 00:00:00 | 00:00:00 | 00:00:00 | N
 | Employee2 |  | N |  | 00:00:00 | N |  | 00:00:00 | N
 | Employee3 |  | C |  | 00:00:00 | N |  | 00:00:00 | N
 | Employee4 |  | 1900-01-06 02:00:00 | 1900-01-06 02:00:00 | 00:00:00 | N |  | 00:00:00 | N
 | Employee5 |  | N |  | 08:30:00 | 1900-01-06 02:00:00 | 02:00:00 | 00:00:00 | N
 | Employee6 |  | 1900-01-06 02:00:00 | 1900-01-06 02:00:00 | 00:00:00 | N |  | 00:00:00 | N
 | Employee7 |  | O |  | 00:00:00 | N |  | 00:00:00 | N
 | Employee8 |  | S8 |  | 00:00:00 | N |  | 00:00:00 | N
 | Employee9 |  | M |  | 00:00:00 | N |  | 00:00:00 | N
 | Employee10 |  | 00:00:00 | 00:00:00 | 07:00:00 | 1900-01-08 00:00:00 | 00:00:00 | 07:00:00 | 1900-01-08 00:00:00 | 00:00:00
 | Employee11
 | Employee12
 | Employee13
 | Employee14
 | Employee15
 | Employee16
 | Employee17
 | Employee18
 | Employee19
 | Employee20 |  |  |  | 07:00:00 | 8 | 0 | 07:00:00 | 8 | 0
 | Employee21
 | Employee22
 | Employee23
 | Employee24
 | Employee25
 | Employee26
 | Employee27
 | Employee28
 | Employee29