Spreadsheet: 881776d1729944006-combine-the-results-of-multiple-rows-in-one-row-and-the-total-answer-in-the-next-coloumn-excel-help-forum-file-1
Sheet: DAILY OFC CUT DETAIL

DAILY OFC CABLE CUT REPORT FOM 01- SEPTEMBER -2024 TO 30-SEPTEMBER- 2024
No. | TT/ID | Section | FMC | Name of Exchange | count | expected result | expected result | Start Date | Start time | End Date
50 | IM19935396 | 8078-AIT (2/0/4) to MSAG-30 Jehanzeb Block | SMD | AIT | 1 | AIT | 1 | 21st September, 2024 | 18:33:00 | 21st September, 2024
4 | IM19599719 | 8061-ARZ (1/0/4) to Edenabad 2.5G MSAG | JTN | ARZ | 4 | ARZ | 4 | 02nd September, 2024 | 11:20:00 | 02nd September, 2024
25 | IM19717199 | 8061-ARZ (12/0/4) to [NAME] | JTN | ARZ | 4 | BTN | 3 | 08th September, 2024 | 22:27:00 | 09th September, 2024
32 | IM19782156 | 8061-ARZ (1/0/4) to Edenabad 2.5G ZTE | JTN | ARZ | 4 | FRPR |  | 12th September, 2024 | 15:10:00 | 12th September, 2024
63 | IM20013545 | 8061-ARZ to 7120-Ufone | JTN | ARZ | 4 | FTN |  | 26th September, 2024 | 11:36:00 | 26th September, 2024
34 | IM19792199 | BTN: OLT-1 to Leads Club Defence Road | JTN | BTN | 3 | GLB |  | 13th September, 2024 | 06:10:00 | 13th September, 2024
65 | ZTE 10G | BTN: Overseas B-Block to MSAG-10 Sukhchan Garden & MSAG-2 Jamia [NAME] | JTN | BTN | 3 | GLRV |  | 27th September, 2024 | 18:15:00 | 28th September, 2024
66 | IM20044434 | 8060-BTN to 8061-ARZ | JTN | BTN | 3 | [NAME] |  | 27th September, 2024 | 23:43:00 | 28th September, 2024
29 | IM19767525 | 8057-FRPR to 7301-Ufone | TNSP | FRPR | 5 | JTN |  | 11th September, 2024 | 18:18:00 | 11th September, 2024
45 | IM19910946 | 8057-FRPR to 3056 X-Block Bajwa Chowk Ufone | TNSP | FRPR | 5 | Kahna |  | 20th September, 2024 | 08:48:00 | 20th September, 2024
47 | IM19919157 | 8057-FRPR to 7301-Ufone | TNSP | FRPR | 5 | [NAME] |  | 20th September, 2024 | 19:25:00 | 20th September, 2024
51 | IM19936856 | FRPR: MSAG-58 near Advance Fashion to OLT-1 & MSAG-44 Babar Chowk PTI Dera | TNSP | FRPR | 5 | MLRD |  | 21st September, 2024 | 20:43:00 | 21st September, 2024
59 | IM19977181 | 8057-FRPR to 7301-Ufone | TNSP | FRPR | 5 | MSTN |  | 24th September, 2024 | 10:35:00 | 24th September, 2024
17 | IM19662587 | 8067-FTN to 7123-Ufone | [NAME] | FTN | 4 | SMD |  | 05th September, 2024 | 20:05:00 | 05th September, 2024
28 | IM19766685 | 8067-FTN to 7123-Ufone | [NAME] | FTN | 4 | TNB |  | 11th September, 2024 | 17:29:00 | 11th September, 2024
39 | IM19828817 | FTN: [NAME] to Wafaqi Colony | [NAME] | FTN | 4 | TNSP |  | 15th September, 2024 | 12:55:00 | 15th September, 2024
70 | IM20084013 | 8067-FTN (2/0/4) to [NAME] | [NAME] | FTN | 4 | WTN |  | 30th September, 2024 | 03:54:00 | 30th September, 2024
2 | IM19586746 | GLB: B-14 3A Main Blvd to B-21 26-B & B-4 Empire Center | [NAME] | GLB | 4 |  |  | 01st September, 2024 | 16:01:00 | 01st September, 2024
6 | IM19619774 | GLB: B-17 249-A-III to B-11 3-B-III & B-18 16-A-III | [NAME] | GLB | 4 |  |  | 03rd September, 2024 | 09:57:00 | 03rd September, 2024
7 | IM19619833 | 8052-GLB to [NAME] | [NAME] | GLB | 4 |  |  | 03rd September, 2024 | 10:02:00 | 03rd September, 2024
53 | M19941120 | GLB: OLT-3 to Khawaja Bihari Darbar | [NAME] | GLB | 4 |  |  | 22nd September, 2024 | 04:30:00 | 22nd September, 2024
3 | IM19592692 | 8071-GLRV (2/0/3) to [NAME] near Waqar Plastic | SMD | GLRV | 4 |  |  | 01st September, 2024 | 23:17:00 | 02nd September, 2024
41 | IM19863956 | 8071-GLRV (3/0/4) to C-21 60-Feet Road | SMD | GLRV | 4 |  |  | 17th September, 2024 | 17:43:00 | 17th September, 2024
55 | IM19956500 | GLRV: C-19 Jafferia Colony to B-4 Chaburji Park & C-21 60-Feet Road | SMD | GLRV | 4 |  |  | 23rd September, 2024 | 04:27:00 | 23rd September, 2024
56 | IM19968141 | GLRV: MSAG-10 WASA [NAME] to MSAG-11 Dawat-e-Islami & MSAG-09 518-E Block | SMD | GLRV | 4 |  |  | 23rd September, 2024 | 19:35:00 | 24th September, 2024
30 | IM19767966 | [NAME]: [NAME]. 845-Q Block near Govt. Girls High School Model Town to DC-26 Jinnah Islamia College Peco Road & Zainab Tower Link Road Model Town | [NAME] | [NAME] | 8 |  |  | 11th September, 2024 | 18:47:00 | 11th September, 2024
37 | IM19819683 | GTN: Peco More to 8041-GTN & DC-58 Malik Mobile | [NAME] | [NAME] | 8 |  |  | 14th September, 2024 | 20:57:00 | 14th September, 2024
48 | IM19920304 | [NAME] to 3042-Children Hospital Ufone | [NAME] | [NAME] | 8 |  |  | 20th September, 2024 | 20:59:00 | 21st September, 2024
49 | IM19934567 | GTN: DC-24 Q-Block Model Town to DC-25B Bhatti Colony WASA Office | [NAME] | [NAME] | 8 |  |  | 21st September, 2024 | 17:38:00 | 21st September, 2024
62 | IM20012148 | 8041-GTN to [NAME] | [NAME] | [NAME] | 8 |  |  | 26th September, 2024 | 09:58:00 | 26th September, 2024
64 | IM20036426 | WTN to [NAME] | TNSP | [NAME] | 8 |  |  | 27th September, 2024 | 14:53:00 | 27th September, 2024
67 | ZTE 10G | [NAME]: OLT-1 to DC-64 Salar Road | [NAME] | [NAME] | 8 |  |  | 28th September, 2024 | 06:36:00 | 28th September, 2024
68 | IM20051095 | 8041-GTN to [NAME] | [NAME] | [NAME] | 8 |  |  | 28th September, 2024 | 08:46:00 | 28th September, 2024
10 | IM19625798 | 8055-JTN to 7211-Ufone | JTN | JTN | 4 |  |  | 03rd September, 2024 | 16:51:00 | 03rd September, 2024
21 | IM19690606 | 8464-JTN (New) to [NAME] Commercial | JTN | JTN | 4 |  |  | 07th September, 2024 | 12:12:00 | 07th September, 2024
54 | IM19956494 | JTN: MSAG-13 Sundar Industrial Estate to MSAG-14 Sundar Industrial Estate | JTN | JTN | 4 |  |  | 23rd September, 2024 | 04:26:00 | 23rd September, 2024
57 | IM19973409 | JTN: MSAG-13 Sundar Industrial Estate to MSAG-14 Sundar Industrial Estate | JTN | JTN | 4 |  |  | 24th September, 2024 | 04:46:00 | 24th September, 2024
8 | IM19620125 | Kahna: ROB-IV OLT to Green Cap Society | TNSP | Kahna | 7 |  |  | 03rd September, 2024 | 10:26:00 | 03rd September, 2024
11 | IM19637188 | Kahna: ROB-IV OLT to Padwana (Inside Graveyard) | TNSP | Kahna | 7 |  |  | 04th September, 2024 | 10:27:00 | 04th September, 2024
15 | IM19648814 | 8069-Kahna (11/0/6) to DC-7K Rohi Nala | TNSP | Kahna | 7 |  |  | 05th September, 2024 | 02:08:00 | 05th September, 2024
36 | IM19796013 | Kahna: ROB-IV OLT to [NAME] | TNSP | Kahna | 7 |  |  | 13th September, 2024 | 11:27:00 | 13th September, 2024
43 | IM19891160 | 8069-Kahna (2/0/2) to C-10K Royal Residencia | TNSP | Kahna | 7 |  |  | 19th September, 2024 | 09:04:00 | 19th September, 2024
60 | IM19977539 | [NAME]: Padwana to [NAME] | TNSP | Kahna | 7 |  |  | 24th September, 2024 | 11:02:00 | 24th September, 2024
61 | IM19983490 | Kahna: [NAME] to Inside PEL Factory | TNSP | Kahna | 7 |  |  | 24th September, 2024 | 17:53:00 | 24th September, 2024
33 | IM19786534 | 1375-Mal to 1376-Maraka | JTN | [NAME] | 1 |  |  | 12th September, 2024 | 19:52:00 | 13th September, 2024
16 | IM19657759 | MLRD: OLT-1 to C-47 Masjid Bilal | SMD | MLRD | 2 |  |  | 05th September, 2024 | 14:52:00 | 05th September, 2024
18 | ZTE 10G | MLRD: OLT-1 to C-39 Hanjarwal | SMD | MLRD | 2 |  |  | 06th September, 2024 | 03:52:00 | 06th September, 2024
27 | IM19742548 | MSTN: OLT-1 to C-43 Canal View | [NAME] | MSTN | 2 |  |  | 10th September, 2024 | 11:41:00 | 10th September, 2024
38 | IM19827341 | MSTN: C-43 Canal View to C-25 PCSIR Canal Park | [NAME] | MSTN | 2 |  |  | 15th September, 2024 | 10:47:00 | 15th September, 2024
1 | IM19578501 | SMD: OLT-2 to [NAME]. HBL | SMD | SMD | 6 |  |  | 01st September, 2024 | 03:30:00 | 01st September, 2024
12 | IM19639450 | SMD: [NAME] to B-25 Cricket House | SMD | SMD | 6 |  |  | 04th September, 2024 | 13:23:00 | 04th September, 2024
19 | IM19679873 | 3071-Islamia Park Ufone to 3075-Clifton Colony Ufone | SMD | SMD | 6 |  |  | 06th September, 2024 | 21:32:00 | 06th September, 2024
22 | IM19695531 | 3071-Islamia Park Ufone to 3075-Clifton Colony Ufone | SMD | SMD | 6 |  |  | 07th September, 2024 | 17:48:00 | 07th September, 2024
23 | IM19700647 | SMD: OLT-2 to [NAME]. HBL | SMD | SMD | 6 |  |  | 08th September, 2024 | 00:27:00 | 08th September, 2024
44 | IM19903405 | SMD: OLT-3 to [NAME] | SMD | SMD | 6 |  |  | 19th September, 2024 | 21:21:00 | 20th September, 2024
13 | IM19639765 | TNB: C-5 Park View Society to C-15 Jubli Town | JTN | TNB | 4 |  |  | 04th September, 2024 | 13:53:00 | 04th September, 2024
14 | IM19644731 | TNB-R6-107 to MLRD-R6-108 | JTN | TNB | 4 |  |  | 04th September, 2024 | 19:35:00 | 05th September, 2024
40 | IM19830426 | TNB: OLT-2 to C-7 Suparco | JTN | TNB | 4 |  |  | 15th September, 2024 | 15:12:00 | 15th September, 2024
42 | IM19870805 | TNB: [NAME] to [NAME] n Carry | JTN | TNB | 4 |  |  | 18th September, 2024 | 06:33:00 | 18th September, 2024
5 | IM19606276 | TNSP: OLT-1 to B-2 110-3 | TNSP | TNSP | 9 |  |  | 02nd September, 2024 | 16:00:00 | 03rd September, 2024
20 | IM19682666 | TNSP: OLT-2 to C-23 4-D2 | TNSP | TNSP | 9 |  |  | 07th September, 2024 | 01:51:00 | 07th September, 2024
26 | IM19730115 | TNSP: C-21 28-10-B1 to C-16 714-A1 | TNSP | TNSP | 9 |  |  | 09th September, 2024 | 16:41:00 | 09th September, 2024
31 | IM19771234 | TNSP: 79-M Hamdard Chowk to OLT-1 & 103-M Hamdard Chowk | TNSP | TNSP | 9 |  |  | 11th September, 2024 | 23:18:00 | 12th September, 2024
35 | IM19795223 | TNSP: OLT-1 to C-3 Jannat Marriage Hall | TNSP | TNSP | 9 |  |  | 13th September, 2024 | 10:39:00 | 13th September, 2024
46 | IM19917181 | TNSP: C-8 Hamdard 79-M to OLT-1 & C-8 Hamdard 103-M | TNSP | TNSP | 9 |  |  | 20th September, 2024 | 17:08:00 | 20th September, 2024
58 | IM19973478 | TNSP: OLT-1 to B-2 110-3 | TNSP | TNSP | 9 |  |  | 24th September, 2024 | 04:59:00 | 24th September, 2024
69 | IM20055440 | TNSP: OLT-2 to C-17 191-C2 | TNSP | TNSP | 9 |  |  | 28th September, 2024 | 13:30:00 | 28th September, 2024
71 | IM20093937 | TNSP: OLT-2 to C-17 191-C2 | TNSP | TNSP | 9 |  |  | 30th September, 2024 | 16:19:00 | 30th September, 2024
9 | IM19621417 | 8062-WTN (11/0/5) to [NAME] | TNSP | WTN | 3 |  |  | 03rd September, 2024 | 11:56:00 | 03rd September, 2024
24 | IM19715897 | 8062-WTN to 7038-Ufone | TNSP | WTN | 3 |  |  | 08th September, 2024 | 20:47:00 | 09th September, 2024
52 | IM19937152 | 8062-WTN to 3014-Ufone | TNSP | WTN | 3 |  |  | 21st September, 2024 | 21:09:00 | 22nd September, 2024