Spreadsheet: 674620d1587955078-how-to-copy-a-row-based-an-input-into-a-specific-cell-and-paste-to-another-sheet-test-log-book
Sheet: All Data

Date | NUMBER | NAME | Age | DOB | M/F | Diag | Side | Procedure | MBS | Complication | HOSPITAL | Column1 | Column2 | Column3 | Column4 | Column5
2019-01-08 00:00:00 |  |  | 61 |  | F | Meniscus tear | R | Arthroscopy
2019-01-08 00:00:00 |  |  | 60 |  | M | Carpal Tunnel syndrom | R | Release
2019-01-08 00:00:00 |  |  | 69 |  | F | OA Knee | L | [NAME] |  |  |  | F4 | T3 | I9 | P29
2019-06-08 00:00:00 |  |  | 66 |  | F | OA Shoulder | R | TSR Reverse |  |  |  | small R | 40 GS | Short body | med liner
2019-06-08 00:00:00 |  |  | 68 |  | M | failed TSR | R | TSR Reverse |  | revision |  |  | 44 GS | Short body | med liner
2019-08-08 00:00:00 |  |  | 57 |  | M | Dupuytrens contracture | L | Fasciectomy
2019-08-08 00:00:00 |  |  | 83 |  | F | Ganglion | L | Excision |  |  |  | volar wrist
2019-08-08 00:00:00 |  |  | 59 |  | F | Dupuytrens contracture | R | Fasciectomy
2019-08-08 00:00:00 |  |  | 61 |  | M | Meniscus tear | L | Arthroscopy |  |  |  | MM tear
2019-09-08 00:00:00 |  |  | 70 |  | M | OA Knee | L | [NAME] |  |  |  | F5 | T5 | I9 | P32
2019-09-08 00:00:00 |  |  | 52 |  | M | OA Hip | L | THR |  |  |  | 52 cup | N7 127 | -5 cer hd | no sb
2019-09-08 00:00:00 |  |  | 71 |  | F | OA Hip | L | THR |  |  |  | 50 cup | 44 N1 | -2.5 cer | no sb
13/8/2019 |  |  | 58 |  | F | OA Hip | R | THR |  |  |  | 50 cup | N3 127 | +2.5 | no sb
13/8/2019 |  |  | 71 |  | F | OA Knee | L | [NAME] |  |  |  | F2 | T2 | I9 | P29
13/8/2019 |  |  | 74 |  | M | Stiff TKR | R | MUA
13/8/2019 |  |  | 61 |  | M | OA Ankle | R |  | fusion
14/8/2019 |  |  | 65 |  | F | Dupuytrens contracture | R | Fasciectomy
14/8/2019 |  |  | 68 |  | M | Hallux valgus | R |  | fusion
14/8/2019 |  |  | 85 |  | F | OA Hip | L | THR |  |  |  | 48 cup | 37.5 N1 | -5 | no sb
15/8/2019 |  |  | 68 |  | F | Carpal Tunnel syndrom | R | Release
15/8/2019 |  |  | 78 |  | M | OA Knee | L | [NAME] |  |  |  | F7 | T6 | I9 | [NAME]
16/8/2019 |  |  | 55 |  | F | Meniscus tear | R | Arthroscopy |  |  |  | MM tear
16/8/2019 |  |  | 55 |  | M | Cuff tear | R | Cuff repair
16/8/2019 |  |  | 70 |  | F | Cuff tear | R | Cuff repair
23/8/2019 |  |  | 74 |  | M | OA Hip | L | THR | Robotic |  |  | 54 cup | N3 127 | +2.5 | no sb
23/8/2019 |  |  | 64 |  | F | OA Knee | R | [NAME] | Robotic |  |  | F3 | T3 | I9 | P29
23/8/2019 |  |  | 74 |  | M | OA Shoulder | L | TSR Reverse |  |  |  | [NAME] bp | 40 GS | 19 stem | longliner
26/8/2019 |  |  | 71 |  | M | Dupuytrens contracture | L | Fasciectomy
26/8/2019 |  |  | 76 |  | M | Carpal Tunnel syndrom | L | Release
26/8/2019 |  |  | 37 |  | M | cyst finger | L | Excision
26/8/2019 |  |  | 35 |  | F | Carpal Tunnel syndrom | L | Release
26/8/2019 |  |  | 41 |  | F | [NAME] | R | Release | thumb
29/8/2019 |  |  | 39 |  | M | Hallux valgus | R |  | fusion
29/8/2019 |  |  | 65 |  | F | OA Knee | R | [NAME] |  |  |  | F5 | T6 | I9 | P32
29/8/2019 |  |  | 59 |  | F | OA Hip | R | THR |  |  |  | 50 cup | N3 127 | -2.5 | no sb
30/8/2019 |  |  | 74 |  | F | OA Hip | R | THR |  |  |  | 48 cup | 37.5 | -5 | no sb
30/8/2019 |  |  | 58 |  | M | OA Hip | L | THR |  |  |  | 54 cup | 50 N1 | -2.5 | no sb
30/8/2019 |  |  | 77 |  | F | OA Knee | L | [NAME] |  |  |  | F2 | T2 | I9 | P29
2019-03-09 00:00:00 |  |  | 72 |  | F | OA Knee | L | [NAME] |  |  |  | F5 | T4 | I9 | P35
2019-03-09 00:00:00 |  |  | 66 |  | M | OA Hip | R | THR |  |  |  | 64 cup | 50 N1 | [NAME] | no sb
2019-05-09 00:00:00 |  |  | 58 |  | M | Carpal tunnel syndrome | R | Release
2019-05-09 00:00:00 |  |  | 76 |  | F | [NAME] finger | L | Release
2019-05-09 00:00:00 |  |  | 73 |  | F | OA CMC joint | L | Trapeziectomy
2019-05-09 00:00:00 |  |  | 34 |  | F | Meniscus tear | R | Arthroscopy
2019-05-09 00:00:00 |  |  | 75 |  | M | Carpal tunnel syndrome | L | Release
2019-06-09 00:00:00 |  |  | 63 |  | M | Cuff tear | L | Cuff repair
2019-06-09 00:00:00 |  |  | 68 |  | M | OA Hip | L | THR |  |  |  | 56 cup | N7 127 | -5 | no sb
2019-06-09 00:00:00 |  |  | 48 |  | M | OA Hip | L | THR |  |  |  | 54 cup | N8 132 | std cer hd | no sb
10/9/2019 |  |  | 50 |  | M | Cuff tear | L | Cuff repair
10/9/2019 |  |  | 51 |  | F | Olecranon bursa | R | Excision
10/9/2019 |  |  | 70 |  | M | OA Knee | R | [NAME] |  |  |  | F6 | T5 | I9 | P38
2019-11-09 00:00:00 |  |  | 56 |  | M | Dupuytrens contracture | R | Fasciectomy
2019-11-09 00:00:00 |  |  | 70 |  | M | OA Shoulder | R | TSR Reverse |  |  |  | small [NAME] | 40 GS | 17 stem | short liner
2019-11-09 00:00:00 |  |  | 98 |  | F | Fr femur | R | Nail
2019-11-09 00:00:00 |  |  | 73 |  | M | OA Shoulder | L | TSR Reverse |  |  |  | small [NAME] | 40 GS | 18  stem | short liner
2019-12-09 00:00:00 |  |  | 70 |  | F | [NAME] | L | Arthroscopy
2019-12-09 00:00:00 |  |  | 61 |  | M | OA Knee | R | [NAME] |  |  |  | F5 | T5 | I9 | P32
2019-12-09 00:00:00 |  |  | 71 |  | F | OA Knee | R | [NAME] |  |  |  | F2 | T1 | I9 | P29
13/9/2019 |  |  | 19 |  | M | Bankart lesion | R | Bankart repair
13/9/2019 |  |  | 71 |  | F | OA Knee | R | [NAME] |  |  |  | F5 | T5 | I9 | P32
13/9/2019 |  |  | 90 |  | M | OA Knee | R | [NAME] |  |  |  | F3 | T3 | I11 | P29
17/9/2019 |  |  | 45 |  | M | Cuff tear | L | Cuff repair
17/9/2019 |  |  | 59 |  | F | OA Knee | R | [NAME] |  |  |  | F4 | T4 | I9 | P32
17/9/2019 |  |  | 64 |  | M | OA Knee | L | [NAME] |  |  |  | F6 | T7 | I9 | P35
20/9/2019 |  |  | 56 |  | M | Dupuytrens contracture | R | Fasciectomy
20/9/2019 |  |  | 74 |  | F | OA Knee | L | [NAME] |  |  |  | F4 | T4 | I9 | P29
20/9/2019 |  |  | 57 |  | M | Meniscus tear | R | Arthroscopy |  |  |  | [NAME]
20/9/2019 |  |  | 31 |  | M | Meniscus tear | R | Arthroscopy |  |  |  | [NAME] MM
20/9/2019 |  |  | 44 |  | F | AC jt OA | R | SAD, Acjt resection
23/9/2019 |  |  | 65 |  | M | Cuff tear | L | Cuff repair
23/9/2019 |  |  | 69 |  | M | Dupuytrens contracture | L | Fasciectomy
23/9/2019 |  |  | 61 |  | M | Carpal tunnel syndrome | R | Release
23/9/2019 |  |  | 53 |  | F | Carpal tunnel syndrome | R | Release
26/9/2019 |  |  | 64 |  | F | OA Hip | L | THR |  |  |  | 50 cup | N3 127 | -5 cer | no sb
26/9/2019 |  |  | 79 |  | F | OA Shoulder | L | TSR Reverse |  |  |  | small [NAME] | 40 GS | 17 stem | medliner
30/9/2019 |  |  | 67 |  | M | Cuff tear | L | Graft |  |  |  | augment
30/9/2019 |  |  | 59 |  | M | OA Knee | L | [NAME] |  |  |  | F8 | T8 | I9 | P38 | PRESSFIT
2019-01-10 00:00:00 |  |  | 57 |  | F | OA Knee | R | [NAME] |  |  |  | F3 | T3 | I9 | P29
2019-01-10 00:00:00 |  |  | 60 |  | F | OA Knee | L | [NAME] |  |  |  | F4 | T4 | 1 11 | P29
2019-03-10 00:00:00 |  |  | 85 |  | M | OA Hip | R | THR |  |  |  | 58 cup | 44 N1 | -2.5 cer | NoSB
2019-03-10 00:00:00 |  |  | 61 |  | F | OA Knee | R | [NAME] |  |  |  | F4 | T4 | I9 | P29 | PRESSFIT
2019-03-10 00:00:00 |  |  | 59 |  | M | OA Knee | R | [NAME] |  |  |  | F7 | T7 | I9 | P38 | PRESSFIT
2019-04-10 00:00:00 |  |  | 65 |  | F | OA Knee | L | [NAME] |  |  |  | F3 | T3 | I9 | P29
2019-04-10 00:00:00 |  |  | 62 |  | M | OA Knee | L | [NAME] |  |  |  | F7 | T7 | I9 | P35 | PRESSFIT
2019-04-10 00:00:00 |  |  | 62 |  | M | OA Knee | R | [NAME] |  |  |  | F7 | T7 | I9 | P35 | PRESSFIT
2019-10-10 00:00:00 |  |  | 70 |  | M | Stiff TKR | R | MUA
2019-10-10 00:00:00 |  |  | 71 |  | F | OA Knee | R | [NAME] |  |  |  | F3 | T4 | I9 | P29
2019-10-10 00:00:00 |  |  | 68 |  | F | [NAME] tendn repair | L
2019-10-10 00:00:00 |  |  | 68 |  | M | OA Knee | R | [NAME]
2019-10-10 00:00:00 |  |  | 73 |  | F | OA Hip | R | THR |  |  |  | 50 cup | N3 127 | [NAME] | NoSB
2019-11-10 00:00:00 |  |  | 83 |  | F | OA Knee | L | [NAME] |  |  |  | F3 | T4 | I 11 | P29
2019-11-10 00:00:00 |  |  | 16 |  | M | Plate in situ clavicle | L
2019-11-10 00:00:00 |  |  | 63 |  | M | OA Knee | L | [NAME] |  |  |  | F4 | T5 | I9 | P35
2019-11-10 00:00:00 |  |  | 74 |  | F | OA Knee | R | [NAME] |  |  |  | F4 | T3 | I9 | P29
18/10/2019 |  |  | 68 |  | F | OA Hip | R | THR |  |  |  | 52 hemi | N4 127 | -5 | NoSB | ROBOTIC
18/10/2019 |  |  | 62 |  | M | OA Knee | L | [NAME] |  |  |  | F6 | T7 | I9 | P35 | ROBOTIC
18/10/2019 |  |  | 64 |  | F | Cuff tear | L | Cuff repair
19/10/2019 |  |  | 82 |  | M | OA Hip | R | THR |  |  |  | 56 cup | 44 0 stem | std metal hd | NoSB | ROBOTIC
[NAME] |  |  | 72 |  | M | Ulnar neuritis | L | Transposition
[NAME] |  |  | 66 |  | M | OA CMC jt | L | Trapeziectomy
[NAME] |  |  | 72 |  | M | DeQuervain's | L | Release
[NAME] |  |  | 80 |  | F | Carpal tunnel syndrome | L | Release
[NAME] |  |  | 45 |  | M | Carpal tunnel syndrome | R | Release
24/10/2019 |  |  | 60 |  | F | Carpal tunnel syndrome | L | Release
24/10/2019 |  |  | 54 |  | M | Dupuytrens contracture | L | Fasciectomy
24/10/2019 |  |  | 48 |  | M | OA Hip | R | THR |  |  |  | 54 cup | N4 127 | std cer hd | NoSB
24/10/2019 |  |  | 58 |  | M | OA Hip | L | THR |  |  |  | 54 cup | N4 127 | -5 cer | NoSB
24/10/2019 |  |  | 68 |  | F | [NAME] | L | Arthroscopy
31/10/2019 |  |  | 66 |  | F | OA CMC jt | L | Trapeziectomy
31/10/2019 |  |  | 71 |  | M | Dupuytrens contracture | R | Fasciectomy
31/10/2019 |  |  | 31 |  | F | Ganglion | L | Excision |  |  |  | dorsal wrist
31/10/2019 |  |  | 44 |  | F | Carpal tunnel syndrome | L | Release