Spreadsheet: 864709d1711802268-pass-array-of-data-to-the-excel-formula-workbook
Sheet: FTR

Team | MONTH | WEEK | DAY | ACKN OUTLIER | TICKET OUTLIER | VIEW | ALARM ACKN? | SURVEILLANCE OR AUTOMATION? | UNACK GENERIC CLEAR? | UNACK MANUAL CLEAR? | TICKETED BY RESOLVE | TICKETED BY SURVEILLANCE | TICKETED INVALID RESP CODE | TICKETS CORRELATED | TICKETED WITH A DISPATCH | CLEARED INTERVAL BAND NAME | DATE (FIRST OCCURRENCE PADDED) | SESSION LABEL | TECHNOLOGY | GENERIC SHIFT BAND EST | ORIGINAL SEVERITY | ORIG SEV LABEL | SERVER SERIAL | ALARMS PRESENTED | PRESENTED TIME | ACKNOWLEDGED | ACKNOWLEDGE AVERAGE TIME | # MET ACK SLA | UNACK GEN CLEAR | COUNT RESPONSE CODE OVER | UNACK GEN CLEAR DURING SUPPRESSION | M5 TICKET NUMBER | M5 TICKET CREATE TIME | M5 TICKET CREATE | M5 TICKET CREATE INTERVAL | M5 TICKET CREATE INTERVAL (MIN) | M5 TICKET SLA | AVG UNACK GEN CLEAR TIME | ACKNOWLEDGED BY | ACKNOWLEDGED TIME | [NAME] (MINS) | ACKNOWLEDGE_INTERVAL_PADDED | ACKNOWLEDGE INTERVAL BAND NAME | ADDRESS | ACTION TYPE | AGENT | AID | ALERT GROUP | ALERT KEY | [NAME] | CIRCUIT ID | CLASS | CLASS NAME | CLEARED BY | CLEARED INTERVAL | CLEARED [NAME] (MINS) | CLEARED [NAME] BAND NAME2 | CLEARED STATUS | CLLI | DELETED AT | DEVICE TYPE | EQUIP TYPE | EVENT GROUP | EVENT ID | EVENT VISIBILITY | EXPIRE TIME | FILTER NAME | FIRST OCCURRENCE | IDENTIFIER | IF ALIAS | IF [NAME] | IMPACT FLAG 1 | IMPACT FLAG 2 | ITMEVENTDATA | LAST OCCURRENCE | [NAME] | [NAME] | LOCATION STATE | MANAGER | MARKET (GROUPED) | NETWORK AFFECTED | NMOS CAUSE TYPE | NMOS DOMAIN NAME | NOC ASSIGMENT | NOC SOURCE PROFILE | NOC TROUBLE TYPE | NODE | NODE ALIAS | ORIGINAL NODE | OWNER USER ID | PRODUCT AFFECTED | [NAME] | RESPONSE CODE | RESPONSE CODE DESC | SERVICE GROUP | SEVERITY | SUMMARY | SUPPRESS ESCL | TALLY | ZONE FULL NAME | [NAME] TICKET NUMBER | SERVER NAME
XYZ | Mar | 12 | 3-22 | NO | NO | PRESENTED | YES | SURVEILLANCE | NO |  | 0 | 0 |  | 1 | 0 | CLEAR < 1 MIN AFTER PRESENTED | 2024-03-22 00:00:00 | DATA Session 2 (OA3 and 4) | DATA | 1 | 5 | 1 | 1 | 1 | 1 | 1 | 15 minutes 18 seconds | 0 | 0 | 1 | 0 | 2484470 | 1969-12-31 18:59:59.999000 | 0 |  |  | 0 |  | Prasanth B | 2024-03-22 00:17:21 | 15.3 | 15 minutes 18 seconds | CLEAR < 16 MIN AFTER PRESENTED | 16451 USHWY 301 S  WIMAUMA, FL 33598 | 0 | ALU5520 - Probe: 5529_ctf |  | Alarm | WIMMFLXA |  |  | 4951 | 1 |  |  |  | NO BAND | N | 1 | 1 | 1 |  | 0 |  | 0 | 0 | CR0 | 2024-03-22 00:00:50 | 1 |  |  | 1 | 0 |  | 2024-03-22 00:02:10 | 1 | FL | FL | 1 | DATA/H-S-I |  | 0 |  | ALLEN |  |  | 1 | 1 | 1 | 1417 |  | 0 | 40 | CT:Correlated Ticket |  | 5 | 1 | 0 | 2 | Z3_TIER1_DATA |  | 1
XYZ | Mar | 12 | 3-22 | NO | NO | PRESENTED | YES | SURVEILLANCE | NO |  | 0 | 0 |  | 1 | 0 | CLEAR < 1 MIN AFTER PRESENTED | 2024-03-22 00:00:00 | TRANSPORT Session 1 (OA1 and 2) | TRANSPORT | 2 | 1 | 2 | 2 | 2 | 2 | 1 | 54 seconds | 0 | 0 | 1 | 0 | 2483570 | 1969-12-31 18:59:59.999000 | 0 |  |  | 0 |  | [NAME] | 2024-03-22 00:04:16.999000 | 0.9 | 54 seconds | CLEAR < 1 MIN AFTER PRESENTED | 111 TRUMBULL ST  HARTFORD, CT 06103 | 0 |  |  | ScopeIDParent |  |  |  | 99990 | 2 |  |  |  | NO BAND | N | 2 | 2 | 2 |  | 0 |  | 0 | 0 |  | 2024-03-21 23:58:05 | 2 |  |  | 1 | 0 |  | 2024-03-22 00:03:17.999000 | 2 | CT | CT | 2 | TRANSPORT |  | 0 |  | ALLEN |  |  | 2 | 2 | 2 | 1043 |  | 0 | 40 | CT:Correlated Ticket |  | 3 | 2 | 0 | 1 | Z1_TIER1_TRANSPORT |  | 2
XYZ | Mar | 12 | 3-22 | NO | NO | SUPPRESED | YES | SURVEILLANCE | NO |  | 0 | 0 |  | 0 | 0 | CLEAR < 31 MIN AFTER PRESENTED | 2024-03-22 00:00:00 | DATA Session 2 (OA3 and 4) | DATA | 3 | 5 | 3 | 3 | 3 | 3 | 1 | 15 minutes 37 seconds | 0 | 0 | 0 | 0 |  | 1969-12-31 18:59:59.999000 | 0 |  |  | 0 |  | Nobody | 2024-03-22 00:19:59.999000 | 15.616666666666 | 15 minutes 37 seconds | CLEAR < 16 MIN AFTER PRESENTED | 350 E CERMAK ROAD  CHICAGO, IL 60616 | 0 | Generic-IETF-SNMPv2-MIB | 0-0-0 | Generic Link Status | ifEntry.[PHONE] |  |  | 40094 | 3 | generic_clear | 26 minutes | 26 | CLEAR < 31 MIN AFTER PRESENTED | Y | 3 | 3 | 3 |  | 0 | SNMPTRAP-linkDown | 0 | 0 | CR2 | 2024-03-21 23:41:43 | 3 |  |  | 1 | 0 |  | 2024-03-22 00:29:45 | 3 | IL | IL | 3 | DATA/H-S-I |  | 2 | ITNM02_P | ALLEN |  |  | 3 | 3 | 3 | 65534 |  | 0 | 0 | NOT SET |  | 0 | 3 | 7 | 84 | Z3_TIER1_DATA |  | 3
XYZ | Mar | 12 | 3-22 | NO | NO | PRESENTED | YES | SURVEILLANCE | NO |  | 0 | 0 |  | 0 | 0 | CLEAR < 31 MIN AFTER PRESENTED | 2024-03-22 00:00:00 | DATA Session 1 (OA1 and 2) | DATA | 4 | 5 | 4 | 4 | 4 | 4 | 1 | 19 minutes 7 seconds | 0 | 0 | 1 | 0 |  | 1969-12-31 18:59:59.999000 | 0 |  |  | 0 |  | Prasanth B | 2024-03-22 00:23:30 | 19.116666666666 | 19 minutes 7 seconds | CLEAR < 21 MIN AFTER PRESENTED | 100 LAKE ST  DALLAS, PA 18612 | 0 | Generic-IETF-SNMPv2-MIB |  | Generic Link Status | ifEntry.514 |  |  | 40200 | 4 | generic_clear | 25 minutes 30 seconds | 25.5 | CLEAR < 31 MIN AFTER PRESENTED | Y | 4 | 4 | 4 |  | 0 | SNMPTRAP-linkDown | 0 | 0 | CR2 | 2024-03-21 23:30:19 | 4 |  |  | 1 | 0 |  | 2024-03-22 00:29:45 | 4 | PA | PA | 4 | DATA/H-S-I |  | 0 | ITNM02_P | ALLEN |  |  | 4 | 4 | 4 | 1417 |  | 0 | 3 | IT:Investigating Trouble |  | 0 | 4 | 0 | 112 | [NAME] |  | 4
XYZ | Mar | 12 | 3-22 | NO | NO | PRESENTED | NO | SURVEILLANCE | YES |  | 0 | 0 |  | 0 | 0 | CLEAR < 31 MIN AFTER PRESENTED | 2024-03-22 00:00:00 | DATA Session 1 (OA1 and 2) | DATA | 5 | 5 | 5 | 5 | 5 | 5 | 0 |  | 0 | 1 | 0 | 0 |  | 1969-12-31 18:59:59.999000 | 0 |  |  | 0 | 25 minutes 30 seconds |  | 1969-12-31 18:59:59.999000 |  |  | NO BAND | 100 LAKE ST  DALLAS, PA 18612 | 0 | Generic-IETF-SNMPv2-MIB | 0-0-0 | Generic Link Status | ifEntry.676 |  |  | 300 | 5 | generic_clear | 25 minutes 30 seconds | 25.5 | CLEAR < 31 MIN AFTER PRESENTED | Y | 5 | 5 | 5 |  | 0 | SNMPTRAP-linkDown | 0 | 0 | CR2 | 2024-03-21 23:41:43 | 5 |  |  | 1 | 0 |  | 2024-03-22 00:29:45 | 5 | PA | PA | 5 | DATA/H-S-I |  | 0 | ITNM02_P | ALLEN |  |  | 5 | 5 | 5 | 65534 |  | 0 | 0 | NOT SET |  | 0 | 5 | 0 | 174 | [NAME] |  | 5
XYZ | Mar | 12 | 3-22 | NO | NO | PRESENTED | NO | SURVEILLANCE | YES |  | 0 | 0 |  | 0 | 0 | CLEAR < 21 MIN AFTER PRESENTED | 2024-03-22 00:00:00 | DATA Session 1 (OA1 and 2) | DATA | 6 | 5 | 6 | 6 | 6 | 6 | 0 |  | 0 | 1 | 0 | 0 |  | 1969-12-31 18:59:59.999000 | 0 |  |  | 0 | 20 minutes 30 seconds |  | 1969-12-31 18:59:59.999000 |  |  | NO BAND | 100 LAKE ST  DALLAS, PA 18612 | 0 | Generic-IETF-SNMPv2-MIB | 0-0-0 | Generic Link Status | ifEntry.675 |  |  | 300 | 6 | generic_clear | 20 minutes 30 seconds | 20.5 | CLEAR < 21 MIN AFTER PRESENTED | Y | 6 | 6 | 6 |  | 0 | SNMPTRAP-linkDown | 0 | 0 | CR2 | 2024-03-21 23:35:31.999000 | 6 |  |  | 1 | 0 |  | 2024-03-22 00:27:25 | 6 | PA | PA | 6 | DATA/H-S-I |  | 0 | ITNM02_P | ALLEN |  |  | 6 | 6 | 6 | 65534 |  | 0 | 0 | NOT SET |  | 0 | 6 | 0 | 34 | [NAME] |  | 6
XYZ | Mar | 12 | 3-22 | NO | NO | SUPPRESED | YES | SURVEILLANCE | NO |  | 0 | 0 |  | 0 | 0 | CLEAR < 21 MIN AFTER PRESENTED | 2024-03-22 00:00:00 | DATA Session 2 (OA3 and 4) | DATA | 7 | 5 | 7 | 7 | 7 | 7 | 1 | 18 minutes | 0 | 0 | 0 | 0 |  | 1969-12-31 18:59:59.999000 | 0 |  |  | 0 |  | Nobody | 2024-03-22 00:25:23 | 18 | 18 minutes | CLEAR < 21 MIN AFTER PRESENTED | 350 E CERMAK ROAD  CHICAGO, IL 60616 | 0 | Generic-IETF-SNMPv2-MIB | 0-0-0 | Generic Link Status | ifEntry.[PHONE] |  |  | 40094 | 7 | generic_clear | 20 minutes 30 seconds | 20.5 | CLEAR < 21 MIN AFTER PRESENTED | Y | 7 | 7 | 7 |  | 0 | SNMPTRAP-linkDown | 0 | 0 | CR2 | 2024-03-21 23:35:31.999000 | 7 |  |  | 1 | 0 |  | 2024-03-22 00:27:25 | 7 | IL | IL | 7 | DATA/H-S-I |  | 0 | ITNM02_P | ALLEN |  |  | 7 | 7 | 7 | 65534 |  | 0 | 0 | NOT SET |  | 0 | 7 | 7 | 31 | Z3_TIER1_DATA |  | 7
XYZ | Mar | 12 | 3-22 | NO | NO | PRESENTED | YES | SURVEILLANCE | NO |  | 0 | 0 |  | 1 | 0 | CLEAR < 1 MIN AFTER PRESENTED | 2024-03-22 00:00:00 | DATA Session 2 (OA3 and 4) | DATA | 8 | 1 | 8 | 8 | 8 | 8 | 1 | 3 minutes 18 seconds | 0 | 0 | 1 | 0 | 2484470 | 1969-12-31 18:59:59.999000 | 0 |  |  | 0 |  | Prasanth B | 2024-03-22 00:17:21 | 3.3 | 3 minutes 18 seconds | CLEAR < 6 MIN AFTER PRESENTED | 16451 USHWY 301 S  WIMAUMA, FL 33598 | 0 |  |  | ScopeIDParent |  |  |  | 99990 | 8 |  |  |  | NO BAND | N | 8 | 8 | 8 |  | 0 |  | 0 | 0 |  | 2024-03-22 00:09:00 | 8 |  |  | 1 | 0 |  | 2024-03-22 00:54:42 | 8 | FL | FL | 8 | DATA/H-S-I |  | 0 |  | ALLEN |  |  | 8 | 8 | 8 | 1417 |  | 0 | 40 | CT:Correlated Ticket |  | 5 | 8 | 0 | 1 | Z3_TIER1_DATA |  | 8
XYZ | Mar | 12 | 3-22 | NO | NO | PRESENTED | YES | SURVEILLANCE | NO |  | 0 | 0 |  | 0 | 0 | CLEAR < 11 MIN AFTER PRESENTED | 2024-03-22 00:00:00 | DATA Session 2 (OA3 and 4) | DATA | 9 | 4 | 9 | 9 | 9 | 9 | 1 | 2 minutes 18 seconds | 1 | 0 | 1 | 0 |  | 1969-12-31 18:59:59.999000 | 0 |  |  | 0 |  | Prasanth B | 2024-03-22 00:17:21 | 2.3 | 2 minutes 18 seconds | CLEAR < 6 MIN AFTER PRESENTED | 18549 IPAVA AVE  LAKEVILLE, MN 55044 | 0 | ALU5520 - Probe: 5529_ctf |  | Alarm | AMS:887923944 |  |  | 4951 | 9 | generic_clear | 9 minutes 50 seconds | 9.833333333333 | CLEAR < 11 MIN AFTER PRESENTED | Y | 9 | 9 | 9 |  | 0 | ALCATEL5529-ResourceIsolation | 0 | 0 | MJ1 | 2024-03-21 23:44:50.999000 | 9 |  |  | 1 | 0 |  | 2024-03-21 23:44:50.999000 | 9 | MN | MN | 9 | DATA/H-S-I |  | 0 |  | ALLEN |  |  | 9 | 9 | 9 | 1417 |  | 0 | 3 | IT:Investigating Trouble |  | 0 | 9 | 0 | 1 | Z4_TIER1_DATA |  | 9