Spreadsheet: 836050d1689068597-filterxml-na-if-no-date-value-book3_updated
Sheet: Sheet1

The purpose of the formula is to extract 3 values from A2 and post it in 3 coloumns (B2, C2, D2) only if there is 3 lines of timestamp which will always start with Timestamp (xxxx): next line is blank, 3rd line will start with "alm.".  First condition is when timestamp data contains;  Alm. Time (mins.): 7/7/2023 12:15 AM Ack. Time (mins.): 7/7/2023 12:20 AM Res. Time (mins.): 7/7/2023 12:48 AM These 3 lines will be 3 field values after ":" will be populated in B2, C2 & D2 accordingly, i.e, only date/time.  2nd Condition is when timestamp data contains only 2 lines or 3rd line contains No timestamp it should be posted as "Open";  Alm. Time (mins.): 7/7/2023 12:15 AM Ack. Time (mins.): 7/7/2023 12:20 AM These 2 lines will be 2 field values after ":" will be populated in B2, C2 and [NAME] will value should be "Open" accordingly, i.e, only date/time & Open  3rd Condition is when timestamp data doesn't contain timestamp values So, if Technician Notes doens't contain Timestamp info, it should posted as "NA" on all 3 fields B2, C2, D2.
Technician Notes | Alm. Time (mins.) | Ack. Time (mins.) | Res. Time (mins.) | Alm-Ack Time | Alm-Res Time | Alm-Ack Time (KPI) | Alm-Res Time (KPI) | Year | Registered Month/Year | Comments | Intended Result
Timestamp (EDT):  Alm. Time (mins.): 7/7/2023 12:15 AM Ack. Time (mins.): 7/7/2023 12:20 AM Res. Time (mins.): 7/7/2023 12:48 AM |  |  |  | 5.000000005820766 | 33.00000000279397 | <= 05 [NAME]. | <= 45 Mins. | 2023 | 07-2023 | Correct data in column A4; [NAME] formula is able to post B4, C4 & D4 date time info | No changes is needed, since formula in B2, C2 & D2 is populated correctly.
Timestamp (EDT):  Alm. Time (mins.): 7/7/2023 00:42 Ack. Time (mins.): 7/7/2023 00:53 Res. Time (mins.): |  |  |  | 11.00000000442378 | 59.99999999650754 | <= 15 [NAME]. | <= 60 Mins. | 2023 | 07-2023 | Correct data in column A5; [NAME] formula is able to post B5, C5 & D5 date time info | No changes is needed, since formula in B2, C2 & D2 is populated correctly
Timestamp (PDT):  Alm. Time (mins.): 7/7/2023 12:45 AM Ack. Time (mins.): 7/7/2023 12:48 AM |  |  |  | 2.999999999301508 | 20.00000000232831 | <= 05 [NAME]. | <= 30 [NAME]. | 2023 | 07-2023 | Correct data in column A6; [NAME] formula is able to post B6, C6 & D6 date time info | No changes is needed, since formula in B2, C2 & D2 is populated correctly
Timestamp (EDT):  Alm. Time (mins.): 7/7/2023 12:15 AM Ack. Time (mins.): [NAME]. Time (mins.): 7/7/2023 12:48 AM |  |  |  | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | 2023 | 05-2023 | Incorrect data in coloumn A7, so data is not getting populated | NA, posted on all 3 fields B7, C7 & D7
What was found. Initial situation  [NAME] found disable with different fault codes such as f108 and f85  What actions were taken  Checked igbts,fuses and fibers. Found fibers pushed back inside fiber connecters at the central board. I crimped on new fiber connecters and assured fibers were flush. |  |  |  | #[NAME]! | NA | #[NAME]! | NA | 2023 | 06-2023 | Incorrect data in coloumn A7 | NA, posted on all 3 fields B8, C8 & D8
What was found. Initial situation  If the control cabinet door was moved, the inverter would stop. What actions were taken  The dc e-stop was pushed in and out several times. The wires to the dc e-stop were traced to the connector. The control cabinet connector was pushed in. The du board was power cycled. The connector pins to the control cabinet door were sprayed with contact cleaner.  What conditions unit was left in  Running with all modules.  Any Future work required if any. Additional information  Continue to monitor the inverter. |  |  |  | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | 2023 | 06-2023 | Incorrect data in coloumn A9 | NA, posted on all 3 fields B9, C9 & D9
What was found. Initial situation  The inverter was running but the communications for plant management was intermittent.  What actions were taken  The laptop was connected to the U8 port to test the Ethernet cable that goes to the central board. The U8 port was removed and inspected. The Ethernet port on the central board was inspected. The sd card was inspected. Contact cleaner was used on the central board' and sd card slot. The old sd card was removed and a new sd card was used.  What conditions unit was left in  Running with all modules and consistent comms.  Any Future work required if any. Additional information  Continue to monitor the inverter. |  |  |  | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | 2023 | 06-2023 | Incorrect data in coloumn A10 | NA, posted on all 3 fields B10, C10 & D10
What was found. Initial situation Inverter not running. What actions were taken Tested AC/DC fuses for both modules and were found bad, IGBT'S for module 5 and 6 tested bad. Replaced module 5 and 6 with new ones, replaced all AC/DC fuses with new ones for both modules. Upto- date software version was uploaded on both modules. What conditions unit was left in Inverter running on all modules. Any Future work required if any. Additional information Continue monitoring. |  |  |  | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | 2023 | 06-2023 | Incorrect data in coloumn A11 | NA, posted on all 3 fields B11, C11 & D11
What was found. Initial situation Inverter running on 4 modules What actions were taken Tested all AC/DC fuses for module 5 and 6 and passed, tested IGBT'S on both modules and passed. Tested fans on module 6 and failed, no output voltage to fans was present. Tested FPGA board on module 6 and was bad. Replaced module (6) FPGA board with one from a bad module. After solving the no voltage issue, 2 fans were not working. What conditions unit was left in Inverter running on 4 modules. Any Future work required if any. Additional information Replaced bad fans for module 6. |  |  |  | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | 2023 | 06-2023 | Incorrect data in coloumn A12 | NA, posted on all 3 fields B12, C12 & D12
What was found. Initial situation Inverter running on 4 modules. What actions were taken Applied LOTO protocol and verified were no voltage present. Took off breaker frame and replaced bad interlock device with a new one. What conditions unit was left in Inverter running on all modules. Any Future work required if any. Additional information Continue monitoring. |  |  |  | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | 2023 | 06-2023 | Incorrect data in coloumn A13 | NA, posted on all 3 fields B13, C13 & D13
What was found. Initial situation Inverter stopped What actions were taken [NAME] card and download parameter, I send to analysis. What conditions unit was left in Stopped Any Future work required if any. Additional information Analyze information to determine to start inverter |  |  |  | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | 2023 | 06-2023 | Incorrect data in coloumn A14 | NA, posted on all 3 fields B14, C14 & D14
What was found. Initial situation Inverter running with 5 modules, M3 F108 What actions were taken Tested IGBT's found not issues. Reseted FPGA,I found Balance board ground loose, I tight. Reseted inverter What conditions unit was left in Inverter running with 6 modules Any Future work required if any. Additional information None |  |  |  | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | 2023 | 06-2023 | Incorrect data in coloumn A15 | NA, posted on all 3 fields B15, C15 & D15
What was found. Initial situation Inverter stopped, F 191 critical low voltage in batteries What actions were taken Tested IGBT'S to the 6 modules, found not issues. verified Vdc input to inverter found voltage good, Reseted inverter , What conditions unit was left in Inverter running with 6 modules Any Future work required if any. Additional information None |  |  |  | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | 2023 | 06-2023 | Incorrect data in coloumn A16 | NA, posted on all 3 fields B16, C16 & D16
What was found. Initial situation Inverter stopped. F191 Critical low Voltage in Batteries What actions were taken Tested IGBT'S to the 6 modules, found not issues. verified Vdc input to inverter found voltage good, Reseted inverter , What conditions unit was left in Inverter running with 6 modules Any Future work required if any. Additional information None. |  |  |  | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | 2023 | 06-2023 | Incorrect data in coloumn A17 | NA, posted on all 3 fields B17, C17 & D17
What was found. Initial situation The modules and DSP firmware needed to be updated. What actions were taken Each module had the updated firmware installed manually. The dsp was attempted to be programmed manually with the dongle but this process failed. The DSP was then programmed via Remote upgrade. The reports were worked on. What conditions unit was left in Running with all modules. Any Future work required if any. Additional information Continue to monitor the inverter. |  |  |  | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | 2023 | 06-2023 | Incorrect data in coloumn A18 | NA, posted on all 3 fields B18, C18 & D18
What was found. Initial situation Buss 3 was showing no voltage when closing in batteries What actions were taken I checked dc measurement board and found led light lit up but not reading voltage. I replaced board and buss 3 was now showing correct bess voltage What conditions unit was left in Running Any Future work required if any. Additional information |  |  |  | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | 2023 | 06-2023 | Incorrect data in coloumn A19 | NA, posted on all 3 fields B19, C19 & D19
What was found. Initial situation Inverter had f45 What actions were taken I was unable to connect to inverter with my computer until IT resolved forticlient issue. Once I connected I noticed IMIs had no sw i uploaded sw remotely. What conditions unit was left in Running Any Future work required if any. Additional information None |  |  |  | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | 2023 | 06-2023 | Incorrect data in coloumn A20 | NA, posted on all 3 fields B20, C20 & D20