Spreadsheet: 756804d1637788228-index-and-match-ron-purpura-index-lookup-forum
Sheet: Solution

MRN | Case Procedures | LoS | Hip-Primary LOS | Hip-Revision LOS | Hip-Anterior LOS | Knee-Primary LOS | Knee-Revision LOS | Knee- Uni LOS | Knee-Bilateral LOS | Ankle - Primary LOS | Bilateral Total Hip LOS | Ankle Arthrodesis LOS | Reverse Shoulder LOS | Total Shoulder Revision LOS | Shoulder LOS | ORIF of Ankle LOS |  | Case Procedures tables | Corresponding General procedure
3814 | ANTERIOR TOTAL HIP ARTHROPLASTY [828] | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ARTHRODESIS ANKLE [3199] | Ankle Arthrodesis
28249 | ORIF ANKLE [3902] | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ARTHRODESIS ANKLE [3199], REMOVAL HARDWARE  LOWER EXTREMITY [4021] | Ankle Arthrodesis
175489 | REMOVAL PROSTHETIC HIP WITH SPACER PLACEMENT [3609] | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SYNDESMOTIC FIXATION ANKLE [3902] | Ankle Arthrodesis
218784 | ARTHRODESIS ANKLE [3199] | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TALONAVICULAR ARTHRODESIS [3199] | Ankle Arthrodesis
266559 | ARTHRODESIS ANKLE TRIPLE [3199] | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TRIPLE ARTHRODESIS [3199], ACHILLES LENGTHENING, DELTOID LIGAMENT REPAIR [3176] | Ankle Arthrodesis
287019 | SHOULDER REVERSE ARTHROPLASTY [27] | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ASR HIP TOTAL ARTHROPLASTY REVISION [3609] | Bilateral Total Hip
304188 | KNEE TOTAL ARTHROPLASTY [3699], REMOVAL HARDWARE LOWER EXTREMITY [4021] | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ANTERIOR HIP TOTAL ARTHROPLASTY [828] | Hip-Anterior
322701 | LEFT HIP TOTAL ARTHROPLASTY CONVERSION [3608] | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ANTERIOR TOTAL HIP ARTHROPLASTY [828] | Hip-Anterior
377879 | TOTAL SHOULDER REVERSE ARTHROPLASTY [27] | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ANTERIOR TOTAL HIP ARTHROPLASTY [828], REMOVAL HARDWARE HIP [989] | Hip-Anterior
509265 | KNEE TOTAL ARTHROPLASTY REVISION - REIMPLANT OF LEFT KNEE PROSTHETIC [3701] | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HIP TOTAL ARTHROPLASTY - CEMENTED [3608] | Hip-Primary
533547 | ORIF HUMERUS PROXIMAL [438], POSSIBLE SHOULDER REVERSE ARTHROPLASTY(psb) [27] | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HIP TOTAL ARTHROPLASTY (POSTERIOR) [3608] | Hip-Primary
5161351 | ORIF RIGHT ANKLE [3902] | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POSTERIOR HIP TOTAL ARTHROPLASTY REVISION [3609] | Hip-Revision
5195466 | RIGHT DISTAL FEMORAL REPLACEMENT [3701] | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REMOVAL PROSTHETIC HIP WITH SPACER PLACEMENT [3609] | Hip-Revision
5725866 | RIGHT KNEE EXPLANT, ANTIBIOTIC SPACER IMPLANT [3701] | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REVISION TOTAL HIP ARTHROPLASTY [3609] | Hip-Revision
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INCISION AND DRAINAGE TIBIA/TALUS [3638], POSSIBLE ORIF TALUS(psb) [3902] | ORIF of Ankle
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ORIF ANKLE [3902] | ORIF of Ankle
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ORIF HUMERUS [3910], POSSIBLE SHOULDER REVERSE ARTHROPLASTY(psb) [27] | Reverse Shoulder
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ORIF HUMERUS PROXIMAL [438], POSSIBLE SHOULDER REVERSE ARTHROPLASTY(psb) [27] | Reverse Shoulder
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ORIF HUMERUS PROXIMAL [438], SHOULDER REVERSE ARTHROPLASTY(psb) [27] | Reverse Shoulder