CAN U JUST PUT THE SURGERY/PROCEDURE COUNT IN 223 GOVT RESERVED SHEET 1 YRAR, 2YEAR , 3RD YEAR
Reading File
Running Command
cd /home/daytona/workspace/attachments/da6ed562-2d2f-4a3d-852f-7a482193ed30/ && …
Running Command
python3 -c " import openpyxl wb = openpyxl.load_workbook('/home/daytona/workspac…
Running Command
python3 -c " import openpyxl wb = openpyxl.load_workbook('/home/daytona/workspac…
Running Command
python3 -c " import openpyxl from openpyxl.styles import Font, PatternFill, Alig…
Running Command
python3 << 'EOF' import openpyxl from openpyxl.styles import Font, PatternFill, …
Running Command
mkdir -p /home/daytona/workspace/output && python3 << 'EOF' import openpyxl from…
Running Command
rm -f /home/daytona/workspace/output/223_Govt_Reserved_Updated.xlsx && python3 <…
Running Command
mkdir -p /home/daytona/workspace/output && ls /home/daytona/workspace/output/
Running Command
python3 << 'EOF' import openpyxl from openpyxl.styles import Font, PatternFill, …
Running Command
python3 << 'EOF' import openpyxl from openpyxl.styles import Font, PatternFill, …
Running Command
python3 -c " import openpyxl wb = openpyxl.load_workbook('/home/daytona/workspac…
The file is ready and verified. Here's the download link:
223 Govt Reserved Updated
Spreadsheet · XLSX
Done! Here's what was added to Sheet1:
3 new columns were appended at the end (columns 28, 29, 30) with a light blue header:
| Column | Header |
|---|---|
| Col 28 | Year 1 (2023) Surgery Count |
| Col 29 | Year 2 (2024) Surgery Count |
| Col 30 | Year 3 (2025) Surgery Count |
How it works: Each row in Sheet1 is matched by its Procedure Code (Col E) against the "SURGERY DONE" sheet. If the code has surgery data, the counts are filled in. All other rows show
-.26 rows matched across all 3 years, covering:
- Ophthalmology (Cataract Phaco, SICS, Dacryocystectomy)
- General Surgery (Appendectomy open/lap, Cholecystectomy open/lap)
- ENT (Adenoidectomy, Tympanoplasty, Septoplasty)
- OBG (Hysterectomy variants, D&C, Biopsy, MTP)
- Urology (TURP/Prostatectomy, Pyelolithotomy, Cystolithotomy)
not able to download it, please give me here in text
Here is the full Surgery/Procedure Count data for Sheet1, showing all 20 procedures with their Year 1, Year 2, and Year 3 counts:
Surgery / Procedure Count — Sheet1 (223 Govt Reserved)
| Procedure Code | Procedure Name | Year 1 (2023) | Year 2 (2024) | Year 3 (2025) |
|---|---|---|---|---|
| SE020A | Cataract (Phaco) | 602 | 1,102 | 638 |
| SE020B | Cataract (SICS) | 983 | 1,243 | 927 |
| SE045AMH | Dacryocystectomy (DCT/DCR) | 159 | 254 | 182 |
| SG017A | Open Appendectomy | 342 | 351 | 325 |
| SG017B | Lap Appendectomy | 132 | 135 | 178 |
| SG039A | Lap Cholecystectomy | 94 | 102 | 226 |
| SG039B | Open Cholecystectomy | 52 | 58 | 31 |
| SL002A | Tympanoplasty | 120 | 140 | 160 |
| SL009A | Septoplasty | 45 | 60 | 59 |
| SL015A | Adenoidectomy | 150 | 200 | 130 |
| SO010A | Caesarean Hysterectomy | 1 | 3 | 7 |
| SO010B | Abdominal Hysterectomy | 259 | 303 | 286 |
| SO010C | Vaginal Hysterectomy | 270 | 316 | 277 |
| SO010E | Laparoscopic Hysterectomy | 5 | 12 | 13 |
| SO018A | Dilatation & Curettage | 118 | 138 | 127 |
| SO053A/B/C | Medical Termination of Pregnancy | 43 | 69 | 42 |
| SO073A | Endometrial/Cervical Biopsy | 121 | 141 | 138 |
| SU024A | Pyelolithotomy | 22 | 28 | 49 |
| SU040A | Cystolithotomy | 1 | 38 | 164 |
| SU077A | TURP / Prostatectomy | 350 | 412 | 582 |
Notes:
- All remaining 203 procedure codes in Sheet1 (medical packages, ER, general medicine, etc.) have no surgery count as they are not in the "SURGERY DONE" sheet.
- SO053A/B/C is listed in the SURGERY DONE sheet but the code appears as a combined entry - it was not matched in Sheet1 (Sheet1 uses separate codes SO053A, SO053B, SO053C individually).
- Some codes appear in 2 rows in Sheet1 (different specialties or sub-procedures) - the same count applies to both rows for that code.
THIS ARE 223 GOVERNMENT RESERVED PROCEDURE WITH THEIR NAMES,SO FROM OT JAN 23 TILL JUNE 26, SEGRRIGATE THE DATA BY SURGERY OR PROCEDURE NAME, IT MIGHT BE SAME NAME OR SLIGHTLY DIFFERENT NAMES, I WANT DATA EXAMPLE ENT SL015A Adenoidectomy Adenoidectomy - 2023 (150 SURGERY) 2024 (200 SURGERY), 2025 (130 SURGERY), 2026 TILL DATE (76 SURGERY) . MEANS IN 223 SURGERY PROCUDURE DONE YEAR WISE OT DATA PERFROMED
Running Command
python3 << 'EOF' import openpyxl base = '/home/daytona/workspace/attachments/da…
Running Command
python3 << 'EOF' import openpyxl base = '/home/daytona/workspace/attachments/da…
Running Command
python3 << 'EOF' import openpyxl from collections import Counter base = '/home/…
Running Command
python3 << 'EOF' import openpyxl from collections import defaultdict, Counter im…
Running Command
python3 << 'EOF' import openpyxl from collections import defaultdict, Counter im…
Running Command
python3 << 'EOF' import openpyxl from collections import defaultdict import re …
Important notes before the table:
- 2023 file provided contains only ~178 records (appears to be late Dec 2023 only, not a full year). So 2023 numbers below are partial.
- 2026 data was not attached - no 2026 file was included in your upload. Please share the "OT JAN 26 - June 26" file and I will add those counts.
- Procedures with 0 across all years are shown at the bottom as "No OT activity found."
223 Govt Reserved Procedures — OT Count Year-Wise
OPHTHALMOLOGY
| Code | Package Name | Procedure Name | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| SE020B | Cataract surgery | SICS with non-foldable IOL | 29 | 290 | 1,136 |
| SE020A | Cataract surgery | Phaco emulsification with foldable IOL | 0 | 28 | 87 |
| SE014A | Pterygium + Conjunctival Autograft | Pterygium + Conjunctival Autograft | 1 | 64 | 219 |
| SE045AMH | Dacryocystectomy | Dacryocystectomy (DCT/DCR) | 2 | 19 | 53 |
| SE053AMH | Amniotic Membrane Graft | Amniotic Membrane Graft Grade 3 Pterygium | 4 | 0 | 0 |
| SE012A | Corneal Grafting | Corneal Grafting | 0 | 0 | 0 |
| SE019A | Limbal Dermoid Removal | Limbal Dermoid Removal | 0 | 0 | 0 |
ENT
| Code | Package Name | Procedure Name | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| SL002A | Tympanoplasty | Tympanoplasty | 5 | 95 | 187 |
| SL009A | Septoplasty | Septoplasty | 1 | 22 | 84 |
| SL013A | Functional Endoscopic Sinus (FESS) | FESS | 0 | 47 | 116 |
| SL015A | Adenoidectomy | Adenoidectomy | 3 | 24 | 60 |
| SL017A | Peritonsillar abscess drainage | Peritonsillar abscess / I&D ENT | 0 | 1 | 60 |
| SL016A | Tonsillectomy | Tonsillectomy | 0 | 0 | 15 |
| SL016B | Tonsillectomy | Tonsillectomy with Adenoidectomy | 0 | 0 | 15 |
| SL022A | Removal of Submandibular Salivary gland | Submandibular gland removal | 0 | 4 | 12 |
| SL007A | Epistaxis treatment - packing | Stapedotomy / Epistaxis | 0 | 10 | 26 |
| SL033B | Closed reduction / IMF fracture maxilla/mandible/zygoma | ORIF Mandible / Maxilla | 1 | 48 | 48 |
| SL056AMH | Myringoplasty | Myringoplasty | 0 | 0 | 6 |
| SL040AMH | Turbinectomy | Turbinectomy | 0 | 0 | 1 |
| SL008A | Functional septo rhinoplasty | Septo rhinoplasty | 0 | 0 | 1 |
| SL005A | Myringotomy with or without Grommet | Myringotomy (unilateral) | 0 | 2 | 2 |
| SL005B | Myringotomy with or without Grommet | Myringotomy (bilateral) | 0 | 2 | 2 |
| SL018E | Thyroglossal / Branchial cyst excision | Thyroglossal / Branchial cyst | 0 | 0 | 0 |
| SL038AMH | Antrostomy | Antrostomy | 0 | 0 | 0 |
| SL039AMH | Rhinotomy | Rhinotomy | 0 | 0 | 0 |
| SL043AMH | Intra Nasal Diathermy | Intra Nasal Diathermy | 0 | 0 | 0 |
| SL048AMH | Polypectomy | Nasal Polypectomy | 0 | 0 | 0 |
| SL049AMH | Ethmoidectomy | Ethmoidectomy | 0 | 0 | 0 |
| SL051AMH | Angiofibroma Nose | Angiofibroma Nose | 0 | 0 | 0 |
| SL052AMH | Benign Tumour Nose | Benign Tumour Nose | 0 | 0 | 0 |
| SL058AMH | Hearing Aid | Hearing Aid | 0 | 0 | 0 |
GENERAL SURGERY
| Code | Package Name | Procedure Name | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| SG039A | Cholecystectomy | Lap Cholecystectomy | 4 | 78 | 266 |
| SG085A | Lipoma / Cyst / Cutaneous swellings Excision | Lipoma Excision | 0 | 96 | 231 |
| SG050A | Groin Hernia Repair | Inguinal Hernioplasty (Open) | 3 | 60 | 297 |
| SG050B | Groin Hernia Repair | Lap Hernia (E-TEP) | 0 | 55 | 154 |
| SG086A | Debridement of Ulcer | Wound Debridement | 3 | 67 | 219 |
| SG074A | Breast Lump Excision (Benign) | Fibroadenoma / Breast Lump | 0 | 29 | 117 |
| SG032A | Haemorroidectomy | Haemorrhoidectomy | 0 | 19 | 93 |
| SG051A | Hernia - Ventral | Umbilical / Ventral Hernia | 1 | 19 | 85 |
| SG056A | Operation for Hydrocele | Hydrocelectomy | 1 | 16 | 35 |
| SG075A | Mastectomy | Mastectomy (Simple) | 0 | 16 | 17 |
| SG070B | Thyroidectomy | Total Thyroidectomy | 3 | 16 | 12 |
| SG054B | Excision of cyst / Sebaceous Cysts | Cyst Excision | 2 | 15 | 39 |
| SG127AMH | Fistula in Ano | Fistula in Ano (Low) | 1 | 14 | 93 |
| SG070A | Thyroidectomy | Hemi Thyroidectomy | 1 | 6 | 17 |
| SG042A | Splenectomy | Splenectomy (Laparoscopic) | 0 | 4 | 8 |
| SG027A | Abdominal Procedure for Rectal Prolapse | Rectal Prolapse - Abdominal | 1 | 7 | 7 |
| SG034A | Excision of Sinus and Curettage | Sinus Tract Excision | 1 | 3 | 5 |
| SG033A | Management of Pilonidal Sinus | Pilonidal Sinus | 0 | 2 | 18 |
| SG057A | Epididymal Cyst / Nodule Excision | Epididymal Cyst | 0 | 1 | 6 |
| SG052A | Repair of Incisional Hernia | Incisional Hernia Repair | 1 | 2 | 11 |
| SG096A | Biopsy | Punch / Core Biopsy | 0 | 17 | 45 |
| SG104A | Circumcision | Circumcision | 0 | 22 | 59 |
| SG026A | Perineal Procedure for Rectal Prolapse | Rectal Prolapse - Perineal | 0 | 0 | 6 |
| SG054A | Excision of cyst / Sebaceous Cysts over scrotum | Scrotal Sebaceous Cyst | 0 | 0 | 9 |
| SG039B | Cholecystectomy | Open Cholecystectomy | 0 | 0 | 0 |
| SG031A | Procedure for Fissure in Ano | Fissure in Ano | 0 | 0 | 0 |
| SG050C | Groin Hernia Repair | Femoral Hernia | 0 | 0 | 0 |
| SG051B/C/D | Hernia - Ventral variants | Ventral Hernia variants | 0 | 0 | 0 |
| SG085B/C | Lipoma / Cyst variants | Cyst / Swelling variants | 0 | 0 | 0 |
| SG096B/C/E | Biopsy variants | Biopsy variants | 0 | 0 | 0 |
| SG133AMH | Scrotal Swelling | Scrotal Swelling | 0 | 0 | 0 |
| SG138AMH | Bakers Cyst Excision | Bakers Cyst | 0 | 0 | 0 |
| SG143AMH | Cervical swelling | Cervical Swelling | 0 | 0 | 0 |
| SG0110A–SG0115A | Minor Surgical Procedures | Various minor surgeries | 0 | 0 | 0 |
OBG & GYNECOLOGY
| Code | Package Name | Procedure Name | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| SO057A | Caesarean Delivery | LSCS | 0 | 17 | 349 |
| SO010B | Hysterectomy | TAH / Abdominal Hysterectomy | 1 | 93 | 262 |
| SO039A | Diagnostic Laparoscopy | Diagnostic Laparoscopy | 3 | 29 | 201 |
| SO010C | Hysterectomy | Vaginal Hysterectomy | 1 | 52 | 111 |
| SO064A | Sterilisation | Tubal Ligation | 0 | 75 | 116 |
| SO073A | Biopsy - Cervical / Endometrial | EB & CB / Endometrial Biopsy | 3 | 73 | 142 |
| SO053A | Medical Termination of Pregnancy | MTP | 0 | 4 | 46 |
| SO019A | Dilation and Evacuation (D&E) | D&E | 0 | 2 | 39 |
| SO018A | D&C (Dilatation & Curettage) | D&C | 0 | 2 | 17 |
| SO056A | Secondary suturing of episiotomy | Episiotomy Repair | 0 | 5 | 10 |
| SO030A | Anterior & Posterior Colpoperineorrhaphy | A&P Repair | 0 | 4 | 8 |
| SO016A | Diagnostic Hysteroscopy | Diagnostic Hysteroscopy | 1 | 2 | 13 |
| SO010E | Hysterectomy | Laparoscopic Hysterectomy (TLH) | 0 | 7 | 6 |
| SO023A | Laparoscopic adhesiolysis | Ovarian Cystectomy / Lap adhesiolysis | 0 | 2 | 4 |
| SO013A | Sling Surgeries for Prolapse | Sling Surgery | 0 | 0 | 6 |
| SO042A | Cystocele - Anterior repair | Cystocele repair | 0 | 0 | 4 |
| SO029A | Hymenectomy for imperforate hymen | Hymenotomy | 0 | 0 | 2 |
| SO020A | Pyometra drainage | Pyometra Drainage | 0 | 1 | 1 |
| SO078AMH | Ovarian Drilling | Laparoscopic Ovarian Drilling | 2 | 11 | 60 |
| SO010A | Hysterectomy | Caesarean Hysterectomy | 0 | 0 | 0 |
| SO010D/F | Hysterectomy variants | Radical / other hysterectomy | 0 | 0 | 0 |
| SO011A | Caesarean hysterectomy | Caesarean Hysterectomy | 0 | 0 | 0 |
UROLOGY
| Code | Package Name | Procedure Name | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| SU077A | Open simple prostatectomy / TURP | TURP | 3 | 56 | 125 |
| SU040A | Cystolithotomy / Cystoscopy | Cystoscopy / Cystolithotomy | 0 | 18 | 97 |
| SU086A | Orchiectomy | High Orchidectomy | 1 | 3 | 9 |
| SU087A | Bilateral Orchidectomy | Bilateral Orchidectomy | 0 | 1 | 8 |
| SU089A | Surgical Correction of Varicocele | Varicocele | 0 | 2 | 5 |
| SU034AMH | Reduction of Paraphimosis | Paraphimosis / Circumcision | 0 | 1 | 3 |
| SU024A | Pyelolithotomy | Pyelolithotomy | 0 | 0 | 2 |
| SU064A | Emergency management of Acute retention of Urine | Acute retention of Urine | 0 | 0 | 1 |
| SU005A | Nephrolithotomy | Nephrolithotomy (Open) | 0 | 0 | 1 |
| SU065A | Meatotomy / Meatoplasty | Meatotomy | 0 | 1 | 0 |
| SU036AMH | Urethrotomy | Optical Urethrotomy | 0 | 0 | 0 |
| SU065B | Meatotomy / Meatoplasty | Meatoplasty | 0 | 0 | 0 |
| SU073A | Emergency management of Hematuria | Hematuria management | 0 | 0 | 0 |
| SU074A | Excision of Urethral Caruncle | Urethral Caruncle excision | 0 | 0 | 0 |
| SU089B | Surgical Correction of Varicocele | Varicocele (Microsurgical) | 0 | 0 | 0 |
| SU094A | Emergency management of Ureteric stone | Ureteric stone management | 0 | 0 | 0 |
ORTHOPEDICS
| Code | Package Name | Procedure Name | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| SB039A | Total Knee Replacement | TKR (Indian / Imported) | 11 | 486 | 1,047 |
| SB038B | Total Hip Replacement | THR Hybrid (Indian Implant) | 20 | 385 | 428 |
| SB038A | Total Hip Replacement | THR (Indian) | 11 | 216 | 230 |
| SB038C | Total Hip Replacement | THR (Imported) | 1 | 4 | 212 |
| SB063A | Corrective Surgery in Club Foot / JESS Fixator | CTEV / Club Foot | 1 | 39 | 3 |
| SB076AMH | Undisplaced Fracture Clavicle | Clavicle Fracture (conservative) | 1 | 25 | 8 |
| SB036A | Arthroscopic Meniscus Repair / Meniscectomy | Arthroscopy / ACL Meniscectomy | 1 | 2 | 2 |
| SB002A | Application of Traction | Traction | 0 | 3 | 6 |
| SB049A | Reconstruction of Cruciate Ligament | ACL Repair / Reconstruction | 0 | 0 | 0 |
| SB049B | Reconstruction of Cruciate Ligament | ACL with brace | 0 | 0 | 0 |
| SB062A | Correction of club foot per cast | CTEV per cast | 0 | 0 | 0 |
| SB065A | Excision of Bursa | Bursa Excision | 0 | 0 | 0 |
| SB083AMH | Arthroscopy - 2 ligament repair | 2 Ligament knee repair | 0 | 0 | 0 |
| SN032A | Thoracic / Lumbar Corpectomy with fusion | Corpectomy | 0 | 0 | 0 |
| SN068BMH | Spine Fusion | Spinal Fusion / Fixation | 0 | 61 | 137 |
PEDIATRIC SURGERY
| Code | Package Name | Procedure Name | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| SG084A | Incision & Drainage of Abscess | I&D Abscess | 0 | 17 | 43 |
| SG017A | Appendicectomy | Open Appendectomy | 1 | 13 | 132 |
| SG017B | Appendicectomy | Lap Appendectomy | 0 | 34 | 195 |
| SS022A | Parathyroidectomy | Parathyroidectomy | 2 | 1 | 0 |
| SS002A | Ankyloglossia | Tongue Tie Release | 0 | 4 | 1 |
| SG059A | Orchidectomy (Surgical Oncology) | Orchidectomy | 0 | 0 | 0 |
| SS001A | Cleft Lip and Palate Surgery | Cleft Lip / Palate | 0 | 0 | 0 |
| SS002B | Ankyloglossia | Ankyloglossia | 0 | 0 | 0 |
| SS015A | Hernia & Hydrocele | Pediatric Hernia/Hydrocele | 0 | 0 | 0 |
| SS058AMH | Cystic Hygroma | Cystic Hygroma | 0 | 0 | 0 |
SURGICAL ONCOLOGY
| Code | Package Name | Procedure Name | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| SC066A | Benign Soft Tissue Tumour - Excision | Soft Tissue Tumour Excision | 1 | 2 | 3 |
PLASTIC & RECONSTRUCTIVE SURGERY
| Code | Package Name | Procedure Name | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| SP009A | Resuturing of Any Wound Gap | Wound Resuturing | 0 | 0 | 0 |
| SP008A | NPWT | Negative Pressure Wound Therapy | 0 | 0 | 0 |
| SP004A | Ear Pinna Reconstruction | Ear Pinna Reconstruction | 0 | 0 | 0 |
GENERAL MEDICINE / EMERGENCY
| Code | Package Name | Procedure Name | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| MG044A | Renal colic | Renal Colic management | 0 | 0 | 0 |
| MG003A | Malaria | Malaria | 0 | 0 | 0 |
| MG004A | Dengue fever | Dengue | 0 | 0 | 0 |
| MG064A | Severe anemia | Severe Anaemia | 0 | 0 | 0 |
| ER001A | Laceration - Suturing / Dressing | Laceration Suturing | 0 | 0 | 0 |
SUMMARY TOTALS
| Specialty | 2023 | 2024 | 2025 |
|---|---|---|---|
| Ophthalmology | 36 | 401 | 1,495 |
| Orthopedics (THR/TKR/Spine) | 45 | 1,220 | 2,079 |
| General Surgery | 22 | 503 | 1,777 |
| OBG & Gynecology | 11 | 377 | 1,239 |
| ENT | 11 | 263 | 625 |
| Urology | 4 | 82 | 251 |
| Pediatric Surgery | 3 | 69 | 374 |
| Others (Neurosurgery, Oncology, Plastic etc.) | 1 | 2 | 3 |
| GRAND TOTAL (matched to 223 list) | 133 | 2,917 | 7,843 |
Key Observations:
- 2023 data is incomplete - the file uploaded only contains ~178 records from late December 2023, so 2023 counts are very low and do not represent the full year.
- 2026 file not attached - please share the OT Jan 2026 - June 2026 file and I will add those counts.
- Biggest volumes: Cataract (SE020B) 1,136 in 2025; TKR 1,047 in 2025; LSCS 349 in 2025; Lap Cholecystectomy 266.
- Many 223 reserved procedures show 0 - these are mostly medical packages (fever, dengue, malaria) that do not appear in OT data, which is expected since they are not surgical OT procedures.
This is a shared conversation. Sign in to Orris to start your own chat.