Spreadsheet: 882091d1730366367-need-formula-sheet-2-to-take-the-data-from-the-sheet-1-unorganized-excel-data-sheet-1-
Sheet: Sheet 1 

 | Sr No. |  | Transaction Id | Site Id |  | Doctor [NAME] |  |  | Transaction Date | Qty | UOM |  |  |  | Base Qty | Base Unit | Price |  | Medical |  | Non Medical | Total Price
 | 1 |  | CT-1671 | Equip Maint |  | General- |  |  | 18/05/2023 | 1.00 |  |  |  |  |  |  |  |  | 0.00 |  | 400.00 | 400.00
 |  |  | Non Medical -567 | Labor Visit Charges |  |  |  |  |  | 1.00 | SERVICES |  |  |  | 1.00 | Svc | 400.00 |  |  |  | 400.00 | 400.00
 | 2 |  | CT-2133 | Equip Maint |  | General- |  |  | 26/07/2023 | 5.00 |  |  |  |  |  |  |  |  | 300.00 |  | 660.00 | 960.00
 |  |  | Non Medical -607 | New Oxygen Cylinder 05 Liter |  |  |  |  |  | 2.00 | Piece |  |  |  | 2.00 | PCS | 250.00 |  |  |  | 500 | 500.00
 |  |  | Non medical -608 | Gas [NAME] |  |  |  |  |  | 1.00 | Piece |  |  |  | 1.00 | PCS | 160.00 |  |  |  | 160 | 160.00
 |  |  | 89006015 | Medical [NAME] regulator with flowmeter and humidifier Jaban |  |  |  |  |  | 2.00 | Piece |  |  |  | 2.00 | PCS | 150.00 |  | 300.00 |  |  | 300.00
 | 3 |  | CT-2296 | Equip Maint |  | General- |  |  | 14/08/2023 | 18.00 |  |  |  |  |  |  |  |  | 5550.00 |  | 0.00 | 5550.00
 |  |  | 89006312 | HVAC Big Filter |  |  |  |  |  | 12.00 | Piece |  |  |  | 12.00 | PCS | 345.00 |  | 4140.00 |  |  | 4140.00
 |  |  | 89006313 | HVAC Small Filter |  |  |  |  |  | 6.00 | Piece |  |  |  | 6.00 | PCS | 235.00 |  | 1410.00 |  |  | 1410.00
 | 4 |  | CT-2337 | Equip Maint |  | General- |  |  | 16/08/2023 | 1.00 |  |  |  |  |  |  |  |  | 0.00 |  | 9740.00 | 9740.00
 |  |  | Non Medical -610 | General AC Parts |  |  |  |  |  | 1.00 | Piece |  |  |  | 1.00 | PCS | 9740.00 |  |  |  | 9740.00 | 9740.00
 | 5 |  | CT-2338 | Equip Maint |  | General- |  |  | 17/08/2023 | 1.00 |  |  |  |  |  |  |  |  | 0.00 |  | 1070.00 | 1070.00
 |  |  | 890050177 | Retrofit Kit Penlon [NAME] (APL VALVA) |  |  |  |  |  | 1.00 | Piece |  |  |  | 1.00 | PCS | 1070.00 |  |  |  | 1070.00 | 1070.00
 | 6 |  | CT-2339 | Equip Maint |  | General- |  |  | 17/08/2023 | 1.00 |  |  |  |  |  |  |  |  | 0.00 |  | 8887.50 | 8887.50
 |  |  | Non Medical -633 | Vaser Power Supply Board S/N 000V38 |  |  |  |  |  | 1.00 | Piece |  |  |  | 1.00 | PCS | 8887.50 |  |  |  | 8887.50 | 8887.50
 | 7 |  | CT-2340 | Equip Maint |  | General- |  |  | 17/08/2023 | 1.00 |  |  |  |  |  |  |  |  | 0.00 |  | 6000.00 | 6000.00
 |  |  | Non Medical -611 | Inlet Filter Vaser |  |  |  |  |  | 1.00 | Piece |  |  |  | 1.00 | PCS | 6000.00 |  |  |  | 6000.00 | 6000.00
 | 8 |  | CT-2395 | Equip Maint |  | General- |  |  | 28/08/2023 | 4.00 |  |  |  |  |  |  |  |  | 0.00 |  | 5359.00 | 5359.00
 |  |  | Non Medical -566 | A/C Compressor Model ZR72KCE-TF7-522 |  |  |  |  |  | 1.00 | Piece |  |  |  | 1.00 | PCS | 2730.00 |  |  |  | 2730.00 | 2730.00
 |  |  | Non Medical -629 | Ex. Valve 7.5TR Danfoss |  |  |  |  |  | 1.00 | Piece |  |  |  | 1.00 | PCS | 1286.00 |  |  |  | 1286.00 | 1286.00
 |  |  | Non Medical -630 | Brazing |  |  |  |  |  | 1.00 | Piece |  |  |  | 1.00 | PCS | 149.00 |  |  |  | 149.00 | 149.00
 |  |  | Non Medical -592 | Labor Charges |  |  |  |  |  | 1.00 | Piece |  |  |  | 1.00 | PCS | 1194.00 |  |  |  | 1194.00 | 1194.00
 | 9 |  | CT-2419 | Equip Maint |  | General- |  |  | 30/08/2023 | 14.00 |  |  |  |  |  |  |  |  | 0.00 |  | 7839.00 | 7839.00
 |  |  | Non Medical -587 | Copeland Compressor ZR72KCE-TF7-522 |  |  |  |  |  | 1.00 | Piece |  |  |  | 1.00 | PCS | 2486.97 |  |  |  | 2486.97 | 2486.97
 |  |  | Non Medical -592 | Labor Charges |  |  |  |  |  | 1.00 | Piece |  |  |  | 1.00 | PCS | 2137.08 |  |  |  | 2137.08 | 2137.08
 |  |  | Non Medical -594 | [NAME] |  |  |  |  |  | 2.00 | Piece |  |  |  | 2.00 | PCS | 102.04 |  |  |  | 204.08 | 204.08
 |  |  | Non Medical -596 | Thermostatic Ex. Valve |  |  |  |  |  | 1.00 | Piece |  |  |  | 1.00 | PCS | 1193.41 |  |  |  | 1193.41 | 1193.41
 |  |  | Non Medical -593 | Contactor |  |  |  |  |  | 2.00 | Piece |  |  |  | 2.00 | PCS | 84.73 |  |  |  | 169.46 | 169.46
 |  |  | Non Medical -595 | HP Switch |  |  |  |  |  | 2.00 | Piece |  |  |  | 2.00 | PCS | 115.70 |  |  |  | 231.40 | 231.40
 |  |  | Non Medical -597 | Freon R141 |  |  |  |  |  | 1.00 | Piece |  |  |  | 1.00 | PCS | 337.07 |  |  |  | 337.07 | 337.07
 |  |  | Non Medical -588 | Freon R407C |  |  |  |  |  | 1.00 | Piece |  |  |  | 1.00 | PCS | 728.80 |  |  |  | 728.80 | 728.80
 |  |  | Non Medical -591 | [NAME] |  |  |  |  |  | 1.00 | Piece |  |  |  | 1.00 | PCS | 140.29 |  |  |  | 140.29 | 140.29
 |  |  | Non Medical -589 | Filter Drier |  |  |  |  |  | 1.00 | Piece |  |  |  | 1.00 | PCS | 70.15 |  |  |  | 70.15 | 70.15
 |  |  | Non Medical -590 | Welding set |  |  |  |  |  | 1.00 | Piece |  |  |  | 1.00 | PCS | 140.29 |  |  |  | 140.29 | 140.29
 | 10 |  | CT-2491 | Equip Maint |  | General- |  |  | 13/09/2023 | 1.00 |  |  |  |  |  |  |  |  | 0.00 |  | 980.00 | 980.00
 |  |  | Non Medical -631 | Eco Drain 31 Service Unit |  |  |  |  |  | 1.00 | Piece |  |  |  | 1.00 | PCS | 980.00 |  |  |  | 980.00 | 980.00
 | 11 |  | CT-2512 | Equip Maint |  | General- |  |  | 20/09/2023 | 12.00 |  |  |  |  |  |  |  |  | 0.00 |  | 809.88 | 809.88
 |  |  | Non Medical -645 | ThermoPro TP50 Digital Hygrometer Indoor Thermometer Room Thermometer and Humidity Gauge with Temperature Monitor |  |  |  |  |  | 12.00 | Piece |  |  |  | 12.00 | PCS | 67.49 |  |  |  | 809.88 | 809.88
 | 12 |  | CT-2629 | Equip Maint |  | General- |  |  | 01/10/2023 | 1.00 |  |  |  |  |  |  |  |  | 0.00 |  | 300.68 | 300.68
 |  |  | Non Medical -654 | Pack Self-Adhesive Sound Proof Foam Panels, 1.5"X12"X12" Pyramid Designed Acoustic Foam |  |  |  |  |  | 1.00 | Piece |  |  |  | 1.00 | PCS | 300.68 |  |  |  | 300.68 | 300.68
 | 13 |  | CT-2748 | Equip Maint |  | General- |  |  | 18/10/2023 | 3.00 |  |  |  |  |  |  |  |  | 0.00 |  | 10000.00 | 10000.00
 |  |  | Non Medical -661 | MS SURFACE 3 TABLETET QS |  |  |  |  |  | 1.00 | Piece |  |  |  | 1.00 | PCS | 7500.00 |  |  |  | 7500.00 | 7500.00
 |  |  | Non Medical -662 | TABLET DUCK SURFACE 3 FOUCUS QS |  |  |  |  |  | 1.00 | Piece |  |  |  | 1.00 | PCS | 0.00 |  |  |  | 0.00 | 0.00
 |  |  | Non Medical -663 | ENGINEERING SERVICE CHARGES |  |  |  |  |  | 1.00 | Piece |  |  |  | 1.00 | PCS | 2500.00 |  |  |  | 2500.00 | 2500.00
 |  |  |  |  |  |  |  |  | Total | 63.00 |  |  |  |  |  |  |  |  | 5850.00 |  | 52046.06 | 57896.06