Spreadsheet: 836005d1689038521-excel-formula-for-merge-duplicate-data-and-sum-the-value-qmedical-supplies-sherina-
Sheet: Expiry

LIST OF EXPIRY
 |  | MEDICAL ITEMS |  |  |  | Department
 |  | MONTH/YEAR: JULY 2023 |  |  |  | ER/Ward
Stand No. | Item Name | Item Code No. | Quantity (Initial Stock) | [NAME] | Checked On | Quantity (Initial Stock) | [NAME] | Checked On
1 | Crepe Bandage 5cm | 131230010
1 | Crepe Bandage 7.5cm | 131230012
1 | [NAME] | 131230013
1 | [NAME] 15cm | 131230014
2 | [NAME] 7.5cm | 131230060
2 | [NAME] 10cm | 131230062
2 | [NAME] 15cm | 131230064
2 | [NAME] 20cm | 131230066
2 | POP 7.5cm | 131230032
2 | POP 10cm | 131230034
2 | POP 15cm | 131230036
2 | POP 20cm | 131230038
 | [NAME]
 | [NAME]
 | Green Sheet | 129990011
 | Diaper | 129990015
 | Surgical Mask | 128290116
 | Surgicel | 128320288
 | [NAME] | 135230001
 | [NAME] | 135230044
 | Unsterile [NAME] 10x10 | 135230037
 | Sterile [NAME] | 135230027
 | [NAME] | 135230210
 | Antiseptic Dressing | 135230200
 | IV Clear Adult | 135280414
 | IV Clear Pedia | 135280436
 | JMI Plaster | 135240318
 | Transparent Plaster (S) | 135240306
 | Transparent Plaster (L) | 135240308
 | Roll Sheet | 137390112
 | Sani Plast | 135240318
 | [NAME] | 128230285
 | Steri-strips | 135240314
 | Arm Sling | 131230040
 | Silicon Foleys catheter 08
 | Silicon Foleys catheter 10
 | Silicon Foleys catheter 12
 | Silicon Foleys catheter 14 | 129200214
 | Silicon Foleys catheter 16 | 129200216
 | Silicon Foleys catheter 20
 | Latex Rubber Cath |  | 0
 | Latex Rubber Cath |  | 0
 | Latex Rubber Cath |  | 0
 | Latex Rubber Cath |  | 0
 | [NAME]
 | [NAME] 10
 | [NAME]
 | [NAME] 14
 | FaceShield | 128290215 | 0
 | Eye Pad | 135230010 | 0
 | IV Set | 137400112
 | Soluset | 137200310
 | Syringe 1cc | 137210202
 | Syringe 3cc | 137210211
 | Syringe 5cc | 137210204
 | Syringe 10cc | 137210205
 | Syringe 20cc | 137210206
 | Syringe 50cc | 137210207
 | Asepto Syringe | 137210208
 | [NAME] | 137210236
 | Blood Set
 | Blood Vacutainers EDTA
 | Blood Vacutainers Yellow
 | Blood Vacutainers Green
 | Blood Vacutainers Blue
 | Blood Vacutainers Red
 | Blood Vacutainers ESR
 | IV Cannula G 26 | 137200337
 | IV Cannula G 24 | 137200338 | 0
 | IV Cannula G 22 | 137200340
 | IV Cannula G 20 | 990037341
 | IV Cannula G 18 | 137200344
 | IV Cannula G 16
 | Alcohol Swab
 | 3-way Stopcock | 137200322
 | Sealing Cap |  | 0
 | Sterile Water for Injection | 548024480
 | Sterile Gloves 6 | 128220134
 | Sterile Gloves 6.5 | 128220136 | 0
 | Sterile Gloves 7.5 | 128220140
 | Sterile Gloves 8 | 128220142
 | Uro Bag | 129990519
 | [NAME] | 129990524
 | Condom Cath XL | 129990527
 | Narcotic Urine Container
 | Urine Collector Pedia
 | Lidocaine Spray | 551066400
 | [NAME] | 990033120
 | Oxygen Mask Pedia | 990033121
 | [NAME]
 | [NAME]
 | Neb Mask Adult | 137990501 | 0
 | Neb Mask Pedia | 137990503 | 0
 | ET Tube #2.5
 | ET Tube #3 |  | 0
 | ET Tube #3.5 |  | 0
 | ET Tube #4
 | ET Tube #4.5
 | ET Tube #5 |  | 0
 | ET Tube #5.5 |  | 0
 | ET Tube #6
 | ET Tube #6.5 |  | 0
 | ET Tube #7
 | ET Tube #7.5
 | ET Tube #8
 | ETT Tie
 | Oral Airway #0
 | Oral Airway #1
 | Oral Airway #2
 | Oral Airway #4
 | Laryngeal Airway #1
 | Laryngeal Airway #1.5
 | Laryngeal Airway #2
 | Laryngeal Airway #3
 | Laryngeal Airway #5
 | Nasopharyngeal Airway #6.5
 | Nasopharyngeal Airway #7
 | Intubation Stylet
 | Thoracic Cath
 | Thoracic Cath
 | Ryles Tube Fr #8
 | Ryles Tube Fr #10
 | Ryles Tube Fr #12
 | Ryles Tube Fr #14
 | Ryles Tube Fr #16
 | Ryles Tube Fr #18
 | Suction Cath #6
 | Suction Cath #8
 | Suction Cath #10
 | Suction Cath #12
 | Suction Cath #14
 | Suction Cath #16
 | Suction Cath #18
 | Suction Cath #20
 | Yaunker | 123090092
 | [NAME]
 | Skin Traction Pedia
 | Skin Traction Adult
 | Suture Unisilk #0
 | Suture Unisilk #1
 | Suture Unisilk #2 | 136510099
 | Suture Unisilk #3 | 136510085
 | Suture Unisilk #4 | 136510078
 | Suture Unisilk #5
 | Suture Unisilk #6
 | Unichrome #1
 | Unichrome #2
 | Unichrome #3
 | Unichrome #4
 | Uniglantin Absorb #0
 | Uniglantin #2
 | Uniglantin #4
 | Unipro Non Absorb #3
 | Unipro Round Body #3
 | Scalpel #11
 | Scalpel #15
 | Scalpel #21
 | Surgical Clipper Blade
 | [NAME] | 137990213
 | Adult ID band | 130230022
 | Pedia ID band Blue | 130230020
 | Pedia ID band [NAME] | 130230021
 | Amniotic Hook |  | 0
 | Vaginal Speculum |  | 0
 | Tubular Net
 | Demoteck Suture #0
 | Demoteck Suture #2
 | Demoteck Suture #3
 | Hand [NAME]
 | Hand [NAME] Wall
 | Hand Soap- Bottle
 | Hand Soap- Wall
 | N95 Mask 1860
 | Blue Gown
 | Bacteria and Virus Hepa filter
 | [NAME]
 | Umbilical catheter
 | [NAME]
 | ECG Lead Pedia
 | Sonogel
 | Tongue Depressor
 | NSS 500 ml | 548024410
 | NSS 50 ml | 548024412
 | NSS 100 ml | 548024413
 | D5NS 500 ml | 548034570
 | D5 1/2 NS 500 ml | 548034570
 | RL 500 ml | 548024445
 | D 10W  500 ml | 548034590
 | D5W 500 ml | 548034550
 | Inj. Paracetamol 1 gram | 545021105
 | Inj. Metronidazole | 540074900
 | Salbutamol | 549012030
 | Goggles
 | Surgical Gloves Small | 128220161
 | Surgical Gloves Medium | 128220160
 | Surgical Gloves Large | 128220162
Checked By: