{"text_format":"1","workbook":"xlsx","n_sheets":24,"sheets":["Mainsheet","Completed","Calc","Areaofobs","Vessel_type","Deficiency_type","VIQrefno","Equipment_list","PSC_MOU","Inspection_type","Deficiency_Cause","Observer_code","Status_code","PSC_ref_no","Risk_value_of_obs","Year","Month","Date_","Sheet1","Ship_information","External_Deficiency_type","External_Inspection_type","External_Observer_code","Sheet Version"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":12,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Mainsheet","index":0,"n_rows":29,"n_cols":28,"rows_kept":29,"cut":false,"hidden":false,"merged":[[10,8,10,9],[10,12,10,13],[12,6,12,27],[8,6,8,27]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Defect - Damage Monitoring Sheet"]
[]
[null,null,null,null,null,null,null,"Date of Report","16-Apr-2023",null,null,"Ship Name","CAPE PHOENIX (21-11-2022)"]
[]
[null,null,null,null,null,null,"VERSION : 2.0"]
[]
[]
[]
[null,null,null,"ID","SHIPSIDE UNIQUEID","UNIQUE ID","Date Recorded","Type of Deficiency","Observer code","Type of Inspection","Description of Deficiency","Equipment Categories","Area of Observation","Deficiency Cause","VIQ Ref Number","Risk Value of Obs","PSC Ref Number","PSC MOU ID","Action Taken or Required","Target Date","PO Ref No.","Status Code","Date Completed","Drydock","Info Sharing","Critical Item","Audit Type","Superintendent Remarks"]
[null,null,null,null,94013,"129_Wed May 18 2022 11:45:09 GMT+0800","2022-05-04T08:00:00","Observation","Ship Staff","Ship Staff Insp.","OBSERVED SPOT HOLE ABOUT 15MM IN DIAMETER IN THE ELBOW PIPE OF DECK SCUPPER PIPE PASSING THROUGH THE STBD DIRTY WATER TANK.\nALMOST IN WATERLINE WHEN THE VESSEL IS AT LOADED CONDITION","Hull & Tanks","Structural Condn. / WT integrity ","Equipment Related","","","","","TEMPORARILY COVERED-UP WITH DEVCON, WRAPPED WITH HATCH COVER SEALING TAPE AND SECURED WITH METAL STRAP- COLD WORK.\nNO WELDING COULD BE DONE AS ITS IS ADJACENT TO FO TANK ABOUT 50 CM & and no any flange connection available, same is a throughout welded pipes, vsl will be monitoring the temporary repairs on regular basis until DD.// Job Transferred to DD specs as per office Instructions.","2024-02-05T08:00:00","","Deferred to D D","2022-05-29T08:00:00","Yes","No","No","Internal","to  put in docking spec. consider temporary repair completed due to hot work is not available now. close from DDRL"]
[null,null,null,null,68910,"129_Tue Mar 21 2023 09:23:06 GMT+0800","2023-01-25T08:00:00","Non Conformity","Ship Staff","Ship Staff Insp.","Fireman outfits are in very poor condition. pants and jackets are torn. helmet not covering entire neck.","LSA / FFA","Safety / LSA / FFA","Industry Issue","","","","","REQN No-CPHO230044, AWAITING SUPPLY. Previously Reqn raised and supplied but only Received Firemans Jackets in Bayuquan China. Reqn not supplied in Last Port call Singapore.","2023-03-08T08:00:00","","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,11918,"129_Tue Mar 21 2023 09:32:40 GMT+0800","2023-02-24T08:00:00","Non Conformity","Ship Staff","Ship Staff Insp.","BA COMPRESSOR AIR QUALITY SAMPLING  DUE 0N 08TH MAR-2023. ","LSA / FFA","Emgcy. Systems","Human Error","","","","","THOUGH REQN WAS RAISED NOT CARRIED OUT IN LAST PORT CALL SINGAPORE. NOW ITS OVERDUE AND REQUIRE POSTPONEMENT","2023-03-08T08:00:00","","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,11234,"129_Tue Mar 21 2023 09:39:07 GMT+0800","2023-02-28T08:00:00","Defect","Ship Staff","Ship Staff Insp.","RUBBER WASHERS OF QUICK ACTING CLEATS OF HATCH COVERS ARE IN POOR CONDITION AND HAVE LOST ELASTICITY. REQUIRE TO BE RENEWED.","Hull & Tanks","Structural Condn. / WT integrity ","Inappropriate Procedure","","","","","REQN RAISED-CPHO230056- AWAITING SUPPLY, detailed report sent to owners for supply of rubber packing.Owners have already have spares in their Ware house.","2023-04-15T08:00:00","","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,53180,"129_Wed Mar 29 2023 00:28:31 GMT+0800","2023-03-08T08:00:00","Observation","Ship Staff","Ship Staff Insp.","Drafts marks on Fwd bow Port and stbd side from 8m to 12m have been faded and drafts are not readable.","Hull & Tanks","Cargo / Ballast Systems","External Factors","","","","","Ship Staff cannot do the painting work of the draft marks due to curvature at Fwd bow area.  require Shore Assistance to paint.","2023-04-30T08:00:00","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,14423,"129_Wed Mar 29 2023 11:51:16 GMT+0800","2023-02-12T08:00:00","Non Conformity","Ship Staff","Cargo Audit","Loadicator test conditions are not endorsed by class during last annual class survey. Last Class survey held in Dec-2022.  As per Rightship -Required loadicator test conditions to be verified by class Annually and same to be endorsed by Class.","Documentation","Cert. & Docu.","Knowledge Based,Human Error","","","","","Loadicator Test conditions to be endorsed by class whenever it is possible at earliest at convenient time and place. Pls advise Target date for the same.",null,"","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,29700,"129_Wed Mar 29 2023 15:50:56 GMT+0800","2023-03-09T08:00:00","Observation","Ship Staff","Ship Staff Insp.","Cross Deck btw HC 2 and 3 require extensive derusting and painting. Derusting of Booby hatches and manholes cover also to be carried out on Cross deck btw #2 and 3.","Hull & Tanks","General Appearance","External Factors","","","","","Work in Progress","2023-04-15T08:00:00","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,21706,"129_Wed Mar 29 2023 15:52:40 GMT+0800","2023-03-08T08:00:00","Observation","Ship Staff","Ship Staff Insp.","Main deck Port side Abreast HC No.2, main deck abreast cross deck HC No.1&2 and 2&3 is rusted and require derusting and painting.","Hull & Tanks","General Appearance","External Factors","","","","","Work in Progress","2023-04-15T08:00:00","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,29893,"129_Thu Mar 30 2023 10:54:37 GMT+0800","2023-02-10T08:00:00","Defect","Ship Staff","Ship Staff Insp.","Wire mesh of all gooseneck ventilators to be renewed. present wire mesh condition is broken or rusted.","Accommodation","Safety / LSA / FFA","External Factors,Human Error","","","","","Awaiting Reqn-CPHO230041, cleaning/buffing is in progress.","2023-03-31T08:00:00","","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,29931,"129_Thu Mar 30 2023 10:57:08 GMT+0800","2023-02-28T08:00:00","Defect,Observation","Ship Staff","Ship Staff Insp.","All goose neck ventilators on accommodation block require derusting and painting.","Accommodation","General Appearance","Human Error,External Factors,Industry Issue","","","","","Work in Progress. Completed Derusting from Upper deck to B deck Vents.","2023-04-15T08:00:00","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,67514,"129_Wed Apr 05 2023 23:06:41 GMT+0800","2022-11-18T08:00:00","Critical Equipment,Non Conformity,Defect","Ship Staff","Nav Audit / Verification","Doppler log showing erratic readings on screen. No STW available for Collision avoidance.","Navigation - Echo Sounder / Speed Log","Navigation","Equipment Related","","","","","Office notified, various troubleshooting carried out as advised but all in vain. Required Shore assistance.","2023-03-31T08:00:00","","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,83536,"129_Wed Apr 05 2023 23:15:57 GMT+0800","2022-12-01T08:00:00","Defect","Ship Staff","Nav Audit / Verification","ECDIS JRC-901B - 1 set zoom out button is defective. If pressed once, continuous zooming in Occurs. Require to renew the button. No damages to the button.","Navigation - ECDIS","Navigation","Equipment Related","","","","","Office notified and require shore assistance for spare and replacement by technician.","2023-03-08T08:00:00","","Waiting spare",null,"No","No","No","Internal"]

{"sheet":"Completed","index":1,"n_rows":71,"n_cols":28,"rows_kept":71,"cut":false,"hidden":false,"merged":[[10,8,10,9],[10,12,10,13],[12,6,12,27],[8,6,8,27]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Defect - Damage Monitoring Sheet"]
[]
[null,null,null,null,null,null,null,"Date of Report","16-Apr-2023",null,null,"Ship Name","CAPE PHOENIX (21-11-2022)"]
[]
[null,null,null,null,null,null,"VERSION : 2.0"]
[]
[]
[]
[null,null,null,"ID","SHIPSIDE UNIQUEID","UNIQUE ID","Date Recorded","Type of Deficiency","Observer code","Type of Inspection","Description of Deficiency","Equipment Categories","Area of Observation","Deficiency Cause","VIQ Ref Number","Risk Value of Obs","PSC Ref Number","PSC MOU ID","Action Taken or Required","Target Date","PO Ref No.","Status Code","Date Completed","Drydock","Info Sharing","Critical Item","Audit Type","Superintendent Remarks"]
[null,null,null,24684,null,"129_23/3/2022 4:18:40 pm","2021-11-12T23:59:35","Defect","Ship Staff","Ship Staff Insp.","CONTROL AIR DRYER NOT WORKING\t","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","","","","","NEED TO BE REPLACE WITH NEW PART","2022-03-26T23:59:35","CPHO210028","Completed","2022-03-17T23:59:35","No","No","No","Internal"]
[null,null,null,24686,null,"129_23/3/2022 5:03:16 pm","2021-11-12T23:59:35","Observation","Ship Staff","Ship Staff Insp.","PRESS REGULATING VALVE NOT WORKING","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","F.O PRESSURE REGULATING VALVE REPLACED WITH NEW .","2022-03-26T23:59:35","CPHO210046","Completed","2022-04-26T23:59:35","No","No","No","Internal","to check spare received or not.  or cancelled your have to raise RO for 2022."]
[null,null,null,24687,null,"129_23/3/2022 5:41:42 pm","2021-11-12T23:59:35","Observation","Ship Staff","Ship Staff Insp.","AE 1&2 LO BACKWASH FILTER DIFF INDICATOR VALVES ARE LEAKING","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related","","","","","valves renewed.","2022-03-26T23:59:35","CPHO210023","Completed","2022-03-24T23:59:35","No","No","No","Internal","to check spare received or not. or cancelled your have to raise RO for 2022."]
[null,null,null,24688,null,"129_23/3/2022 5:44:59 pm","2021-11-12T23:59:35","Observation","Ship Staff","Ship Staff Insp.","ME CYL LO FLOWMETER DAMAGED AT HINGED","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","flowmeter is made working.","2022-08-25T23:59:35","CPHO220125","Completed","2022-08-18T23:59:35","No","No","No","Internal","Spare ready on 8 July 2022.  will supply in next convenient port."]
[null,null,null,24689,null,"129_23/3/2022 5:47:35 pm","2021-11-12T23:59:35","Observation","Ship Staff","Ship Staff Insp.","BOILER FO PR SWITCH LEAKING FROM THE DIAPHARAM","E/R - Boiler","Eng. / Strg. Comp.","Equipment Related","","","","","pr.switch renewed with spare.","2022-03-26T23:59:35","CPHO210027","Completed","2022-03-19T23:59:35","No","No","No","Internal","spare should be delivered on board. please update"]
[null,null,null,24690,null,"129_2/4/2022 5:02:50 pm","2022-01-27T23:59:35","Observation","Ship Staff","Ship Staff Insp.","INCINERATOR SLUDGE PUMP LEAKING","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related","","","","","leakage through seal arrested.","2022-04-26T23:59:35","","Completed","2022-04-06T23:59:35","No","No","No","Internal","to overhaul the pump, change the seal. if spare required please raise RO."]
[null,null,null,24691,null,"129_2/4/2022 5:06:55 pm","2022-01-28T23:59:35","Observation","Ship Staff","Ship Staff Insp.","BREAST FWD, SPRING FWD & AFT SPRING MOORING WINCH MOTOR BODY DAMAGED","Deck - Mooring Machinery","Eng. / Strg. Comp.","Equipment Related","","","","","Temporary repairs carried out as per Office Instructions , New Sapre Motor Received for Windlass and Mooring Winches- In Emergency same can be used upon Office approval- Defect Closed. ","2022-06-10T23:59:35","CPHO220015","Completed","2022-05-22T23:59:35","No","No","No","Internal","it has been repaired. to monitor the condition.  not require to change with new motor. spare will supply in next convenient port.  to close the defect if spare motor receive"]
[null,null,null,24693,null,"129_2/4/2022 4:56:55 pm","2022-03-22T23:59:35","Observation","Ship Staff","Suptd. Insp.","AE FO LINE PR REGULATING VALVE MALFUNCTIONING","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related","","","","","Valve is operating satisfactorily","2022-10-27T23:59:35","CPHO220107 RAISED FOR SERVICE KIT.","Completed","2022-08-29T23:59:35","No","No","No","Internal","to overhaul the valve first,  RO for spare waiting readiness will supply next convenient port"]
[null,null,null,24952,37025,"129_Tue Apr 19 2022 15:22:46 GMT+0800","2022-04-02T23:59:35","Observation","Ship Staff","Ship Staff Insp.","ALL ROLLER FAIRLEAD- TO DISMANTLE AND DERUST","Deck - Mooring Machinery","Mooring","Equipment Related","","","","","All 58 fairlead rollers removed from shaft, hydroblasted, cleaned, derusted and painted. Derusting and painting of shaft and base carried out. Greasing carried out. Grease nipple inspected, cleaned and mounted back. All rollers mounted back in position with covers. All fairlead rollers now in good working condition.\nFinal Cosmetic painting and marking in progress.","2022-07-02T23:59:35","","Completed","2022-05-26T23:59:35","No","No","No","Internal","to carry out and complete before target date"]
[null,null,null,25230,57571,"129_Fri Apr 29 2022 01:34:17 GMT+0800","2022-04-02T23:59:35","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","AREAS IN ENGINE CASING TO CLEAN AND PAINT, CHECK ALL LIGHTS.","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","","","","","CLEANING AND PAINTING  OF ENGINE ROOM CASING AREA CARRIED OUT AND ALL BUSTED LAMPS RENEWED.","2022-06-02T23:59:35","","Completed","2022-05-02T23:59:35","No","No","No","Internal","to carry out and complete before target date"]
[null,null,null,25232,95662,"129_Fri Apr 29 2022 01:25:43 GMT+0800","2022-04-02T23:59:35","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","\tSHIP SIDE\tSHIP SIDE STRUCTURE NEAR MAIN ENGINE L.O AUTOBACKWASH FILTER TO DERUST AND PAINT\t\t\t","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","","","","","SHIP SIDE DERUSTED AND APPLIED WHITE PAINT.","2022-05-02T23:59:35","","Completed","2022-04-15T23:59:35","No","No","No","Internal"]
[null,null,null,25233,41057,"129_Fri Apr 29 2022 01:28:16 GMT+0800","2022-04-02T23:59:35","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","CENTRAL COOLER SW INLET PIPE LEAKAGE TO RECTIFY.","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","PIPE REPLACED WITH SPARE SACRIFICIAL PIPE.","2022-04-22T23:59:35","","Completed","2022-04-23T23:59:35","No","No","No","Internal"]
[null,null,null,25234,77543,"129_Fri Apr 29 2022 01:30:55 GMT+0800","2022-04-02T23:59:35","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","FRESH HYD TANK DISCHARGE VALVE LEAKING CAUSE PUMP REVERSE ROTATION WHEN STOP PERIODE","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","VALVE REPLACED WITH OVERHAULED ONE , PUMP DOES NOT ROTATE ON STOP CONDITION.","2022-04-17T23:59:35","","Completed","2022-04-15T23:59:35","No","No","No","Internal"]
[null,null,null,25235,34832,"129_Fri Apr 29 2022 01:36:33 GMT+0800","2022-04-02T23:59:35","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","FWG CONDENSOR S.W PIPE LEAK TO RECTIFY AND PAINT THE NEW FABRICATED PIPE.","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","NEW PIPE FABRICATED ,FITTED AND PAINT APPLIED.","2022-04-17T23:59:35","","Completed","2022-04-06T23:59:35","No","No","No","Internal"]
[null,null,null,25236,95792,"129_Fri Apr 29 2022 01:39:03 GMT+0800","2022-04-02T23:59:35","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","A/E JACKET COOLER SAVE ALL TO CLEAN AND PAINT","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","","","","","SAVE ALL CHIPPED AND DERUSTED , PAINTING CARRIED OUT.","2022-04-22T23:59:35","","Completed","2022-04-20T23:59:35","No","No","No","Internal"]
[null,null,null,25222,81387,"129_Wed Apr 27 2022 00:28:42 GMT+0800","2022-04-03T23:59:35","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","HATCH COVER HEAVY BOLT TO CARRY OUT MAINTENANCE","Cargo Mach.","Structural Condn. / WT integrity ","Equipment Related","","","","","DERUSTING AND LUBRICATION","2022-06-02T23:59:35","","Completed","2022-05-11T23:59:35","No","No","No","Internal","to carry out as per plan and keep update"]
[null,null,null,25223,92969,"129_Wed Apr 27 2022 00:31:17 GMT+0800","2022-04-03T23:59:35","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","HATCH COVER GAS SAMPLING POINT FROZEN IN SOME PLACES","Cargo Mach.","Structural Condn. / WT integrity ","Equipment Related","","","","","TO DERUST AND LUBRICATE THREAD/ Threads are worn out and beyond repair, De-rusting and Lubrication done and completed;// spares-CPHO220140 received and job in progress, Job completed on 24th June 2022. DEFECT CLOSED.","2022-07-03T23:59:35","CPHO220140","Completed","2022-06-19T23:59:35","No","No","No","Internal","RO has been supplied.  job to be carry out as necessary. only damaged one required to change."]
[null,null,null,25224,64325,"129_Wed Apr 27 2022 00:36:07 GMT+0800","2022-04-03T23:59:35","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","HATCH COVER CENTER STOPPER-MAINTENANCE","Cargo Mach.","Structural Condn. / WT integrity ","Equipment Related","","","","","TO DE RUST, CHECK AND PAINT// JOB COMPLETED- DEFECT CLOSED","2022-07-02T23:59:35","","Completed","2022-07-01T23:59:35","No","No","No","Internal","to carry out and complete before target date"]
[null,null,null,25225,69172,"129_Wed Apr 27 2022 00:33:12 GMT+0800","2022-04-03T23:59:35","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","STBD SIDE ENTRANCE PLATFORM STEP- OBSERVED TO BE WEAK","Deck - Pipe / Fittings","Structural Condn. / WT integrity ","Equipment Related","","","","","Reinforced the Step by additional Bracket installed","2022-06-02T23:59:35","","Completed","2022-05-25T23:59:35","No","No","No","Internal","to carry out and complete asap"]
[null,null,null,25226,12193,"129_Wed Apr 27 2022 00:38:12 GMT+0800","2022-04-05T23:59:35","Non Conformity","Ship Staff","Ship Staff Insp.","RESCUE BOAT DECK SAFETY RAILINGS- FOR ADDITIONAL 1 DETTACHABLE RAILING","LSA / FFA","Safety / LSA / FFA","Equipment Related","","","","","TO RAISE RO AND INSTALL // New Chain installed - Defect Closed","2022-07-05T23:59:35","CPHO220110","Completed","2022-05-26T23:59:35","No","No","No","Internal","to raise Ro as required, will supply at next convenient port"]
[null,null,null,25227,72222,"129_Wed Apr 27 2022 00:42:18 GMT+0800","2022-04-05T23:59:35","Observation","Ship Staff","Ship Staff Insp.","MF/HF ANTENNA- DETERIORATED SAFETY CHAIN GUARD","Navigation - GMDSS & Communication","Structural Condn. / WT integrity ","External Factors","","","","","TO RENEW// Renewed all 3 Chains with New SS chains- Defect closed","2022-07-05T23:59:35","CPHO220110","Completed","2022-05-26T23:59:35","No","No","No","Internal","RO will supply next convenient port"]
[null,null,null,25228,74485,"129_Wed Apr 27 2022 00:44:15 GMT+0800","2022-04-05T23:59:35","Observation","Ship Staff","Ship Staff Insp.","GANGWAY UPPER PLATFORM-SUBJECT FOR THOROUGH INSPECTION","Deck - Machinery","Structural Condn. / WT integrity ","Equipment Related","","","","","TO DISMANTLE, DERUST AND INSPECT// STBD Gangway maintenance completed in May 20th 2022 // completed inspection and maintenance of Port Accommodation ladder on 07th July 2022.","2022-07-05T23:59:35","CPHO220141","Completed","2022-07-02T23:59:35","No","No","No","Internal","spare has been confirmed and  will supply next convenient port."]
[null,null,null,25231,82551,"129_Fri Apr 29 2022 01:21:02 GMT+0800","2022-04-06T23:59:35","Observation","Ship Staff","Ship Staff Insp.","BALLAST PUMP #2 WORKING STAND CORRODED ,HOLED.","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","","","","","NEW PLATE FOR STAND TO FABRICATE AND FIX.","2022-04-25T23:59:35","","Completed","2022-04-10T23:59:35","No","No","No","Internal"]
[null,null,null,25237,25102,"129_Fri Apr 29 2022 01:41:44 GMT+0800","2022-04-06T23:59:35","Defect","Ship Staff","Ship Staff Insp.","AUX.ENGINE L.T COOLER S.W INLET PIPE LEAKING.","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","LEAKING PIPE REPLACED WITH NEW ONE.","2022-04-25T23:59:35","","Completed","2022-04-22T23:59:35","No","No","No","Internal"]
[null,null,null,25238,53563,"129_Fri Apr 29 2022 01:44:16 GMT+0800","2022-04-07T23:59:35","Defect","Ship Staff","Ship Staff Insp.","MAIN ENGINE L.O COOLER S.W INLET PIPE HAVE SOFT PATCH/ LEAKING.","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","SYSTEM ISOLATED AT ANCHORAGE , PIPE REMOVED AND WELD REPAIRS CARRIED OUT IN WORKSHOP AND FITTED BACK./ JOB COMPLETED AT SALDANHA BAY ANCHORAGE.","2022-04-25T23:59:35","","Completed","2022-04-23T23:59:35","No","No","No","Internal"]
[null,null,null,25288,14754,"129_Sat May 07 2022 17:32:15 GMT+0800","2022-04-29T23:59:35","Defect,Observation","Ship Staff","Ship Staff Insp.","AUX.ENGINE #1 AIR COOLER COOLING WATER OUTLET PIPE LEAKING.","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related","","","","","PIPE LINE REMOVED 0 RINGS RENEWED AND LEAK RECTIFIED.","2022-06-04T23:59:35","","Completed","2022-05-04T23:59:35","No","No","No","Internal","if the job complete your can insert the completion date to close the defect"]
[null,null,null,25229,71821,"129_Wed Apr 27 2022 00:45:35 GMT+0800","2022-05-05T23:59:35","Observation","Ship Staff","Ship Staff Insp.","HATCH COVER VENT AND HOLD ACCESS RUBBER PACKING","Cargo Mach.","Structural Condn. / WT integrity ","Equipment Related","","","","","SUBJECT FOR REPLACEMENT// HATCH COVER VENT AND HOLD ACCESS RUBBER PACKING RENEWED_ DEFECT CLOSED","2022-08-05T23:59:35","CPHO220110","Completed","2022-08-07T23:59:35","No","No","No","Internal","RO has been supplied on board. please carry out as required"]
[null,null,null,25467,71509,"129_Thu May 19 2022 10:50:29 GMT+0800","2022-05-11T23:59:35","Defect","Ship Staff","Ship Staff Insp.","Deck Main Fire Line and branch fire line in deteriorated condition and leaking","Deck - Pipe / Fittings,LSA / FFA","Safety / LSA / FFA","Equipment Related","","","","","Through inspection of the entire Fire line carried out, found Four Nos of leaking areas in the Main fire line and Soft patches at various Locations, Need renewal of Fire Line approx. 160 Mtrs in Length including Branch fire line and Dresser Couplings, 9 Sections of 6 Mts main fire line Renewal completed on 29th May 2022.// Branch fire line 65A completed on 5th June 2022// Painting and derusting of Branch fire line 65A in progress will be completed on 21st June 2022.// Fire line renewal Job completed on 07th July 2022- Defect CLOSED.","2022-07-17T23:59:35","CPHO220142","Completed","2022-07-02T23:59:35","No","No","No","Internal","to update office status till the job complete"]
[null,null,null,25468,91202,"129_Mon May 30 2022 09:46:11 GMT+0800","2022-05-15T23:59:35","Defect","Ship Staff","Ship Staff Insp.","WBT - TST -2 STBD, Transverse Frame NO 259 found dent and deformed about 60 cm , TST frame deformed area is just above the summer Load line and the area found heavily rusted, No any cracks found on the Frame and the adjacent frames","Hull & Tanks","Structural Condn. / WT integrity ","External Factors","","","","","Through inspection to be done by Class NKK and appropriate action to be taken during the next DD as per Class advise// Ship staff de-rusted the rusted area and applied 2 coat of paint.//  job to shifted to DD spec. closed the job for DDRL ","2024-01-25T23:59:35","","Completed","2022-06-02T23:59:35","No","No","No","Internal","Noted. job to shift to DD spec. close the job for DDRL once painting job complete"]
[null,null,null,25469,30434,"129_Mon May 30 2022 14:03:03 GMT+0800","2022-05-15T23:59:35","Defect","Ship Staff","Ship Staff Insp.","operating water solenoid assembly for main  L.O purifier ,manual opertion switch is broken and hence valve is stuck in open position  making the l.o purifier non operational.","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","","","","","spares received and solenoid valve assembly fitted , purifier tried out satisfactory.","2022-08-25T23:59:35","CPHO220147 raised.","Completed","2022-08-18T23:59:35","No","No","No","Internal","Spare confirmed and waiting for readiness. will supply once collect."]
[null,null,null,25470,83534,"129_Mon May 30 2022 14:05:46 GMT+0800","2022-05-20T23:59:35","Observation","Ship Staff","Ship Staff Insp.","galley air con cooling sea water inlet pipe is corroded and leaking.","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","condensor end cover threads coroded hence pipe is welded with end cover and leak rectified.","2022-08-20T23:59:35","","Completed","2022-06-09T23:59:35","No","No","No","Internal","to complete before due date"]
[null,null,null,25629,47334,"129_Sun Jun 12 2022 14:41:12 GMT+0800","2022-05-28T23:59:35","Observation","Ship Staff","Ship Staff Insp.","steam leak from flange of the excess steam control valve.","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","main steam stop valve to shut, steam to isolate & leak to rectify.\nsteam isolated and leak rectified.","2022-06-10T23:59:35","","Completed","2022-06-07T23:59:35","No","No","No","Internal"]
[null,null,null,25923,38456,"129_Sat Jun 25 2022 10:03:23 GMT+0800","2022-06-16T23:59:35","Defect","Ship Staff","Ship Staff Insp.","Erratic readings -midship port and stbd draft level gauges","Hull & Tanks","Cargo / Ballast Systems","Equipment Related","","","","","•\tOn dismantling the sensors it is observed that the electric terminals are grounded and the sensor was filled up with hard deposits of salt indicating sea water passing through the seals to the electric terminals.\n•\tPort side sensor was observed damaged with hard deposits on electrical terminals , same after cleaning the resistance value was found to be 4 Mohms\n•\tStbd  sensor cleaned up the deposits and sealing rings were renewed from 0 ring kit, resistance check carried out and found value to be 15 Mohms.\n•        As per the checks suspecting the sensors are defective and need replacement.\n\n•        Have raised requisition (CPHO220156: pressure electric type draft sensor) for the sensors\n spares received on 14/07/2022, job  will complete job by 20th July 2022// Flag dispensation taken on 24th June 2022 till 30th Sep 2022// New sensors install, all working in good order. Defect closed on 20th July 2022.","2022-09-25T23:59:35","CPHO220156","Completed","2022-07-15T23:59:35","No","No","No","Internal","spare already on board. please carry out and update"]
[null,null,null,26156,25376,"129_Wed Jul 13 2022 14:20:45 GMT+0800","2022-06-27T23:59:35","Observation","Ship Staff","Ship Staff Insp.","main engine l.o cooler s.w outlet pipe line is corroded and holed.","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","s.w leak is arrested with help of clamp, pipe line to renew at next port./\npipe line replaced with new one .","2022-07-11T23:59:35","","Completed","2022-07-09T23:59:35","No","No","No","Internal"]
[null,null,null,27607,22122,"129_Tue Oct 04 2022 17:36:14 GMT+0800","2022-10-01T23:59:35","Observation","Ship Staff","Ship Staff Insp.","#4 MOORING WINCH LEAKING OIL FROM REDUCTION GEAR SIDE.","Deck - Mooring Machinery","Mooring","Equipment Related","","","","","OIL SEAL FOUND TO BE DAMAGED. SAME RENEWED",null,"CPHO220224","Completed","2022-12-04T23:59:35","No","No","No","Internal","Spare could be supplied to vessel. to updated status"]
[null,null,null,null,94253,"129_Fri Feb 17 2023 04:51:31 GMT+0800","2023-02-06T08:00:00","Non Conformity","Ship Staff","Ship Staff Insp.","Carried out light /chalk test of weathertight doors, A deck Port side upper and A deck, stbd side A deck and Aft provision store weathertight door failed Test. Retaining channel rubber to renew and dogged handle to be dismantle and repair for proper closure","Accommodation","Structural Condn. / WT integrity ","Knowledge Based","","","","","Retaining channel derusted and painted. Rubber packing renewed of all leaking doors. Dogged handles dismantled and greased and fitted back.","2023-02-20T08:00:00","","Completed","2023-02-10T08:00:00","No","No","No","Internal"]
[null,null,null,24692,null,"129_2/4/2022 4:53:10 pm","2022-10-12T08:00:00","Observation","Ship Staff","Ship Staff Insp.","LS FO SETT TANK LEVEL GAUGE DAMAGED","Hull & Tanks","Eng. / Strg. Comp.","Equipment Related","","","","","Job completed gauge is working in order.","2023-02-28T08:00:00","CPHO220094","Completed","2023-02-17T08:00:00","No","No","No","Internal","spare confirmed and will supply in next convenient port"]
[null,null,null,24685,null,"129_23/3/2022 4:14:33 pm","2022-10-12T08:00:00","Observation","Ship Staff","Ship Staff Insp.","STEERING GEAR 1&2 LEAKING FROM SERVO CONTROLLER UNITS AND RAMS","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","","","","","Ram leakages rectefied. No.1 S/G servo motor leak rectefied.","2023-02-28T08:00:00","CPHO 220020","Completed","2023-02-18T08:00:00","No","No","No","Internal","spare already on board. to rectify at the first opportunity. this job to carry out by ship staff."]
[null,null,null,null,66009,"129_Sun Feb 26 2023 18:45:12 GMT+0800","2023-02-02T08:00:00","Defect","Ship Staff","Ship Staff Insp.","Catwalk grating between HC No.1 and 2 found wasted.","Deck - Pipe / Fittings","Structural Condn. / WT integrity ","External Factors","","","","","Renewed Gratings and frame of Catwalk between HC No.1 and 2.","2023-02-28T08:00:00","","Completed","2023-02-23T08:00:00","No","No","No","Internal"]
[null,null,null,null,61570,"129_Mon Feb 27 2023 08:49:33 GMT+0800","2023-02-27T08:00:00","Defect","Ship Staff","Ship Staff Insp.","SW cooling discharge pipe ruptured due to material failure","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","Defective pipe removed repairs carried out and fitted back, tested and found in order.New pipe fabrication completed and kept as spare.","2023-03-27T08:00:00","","Completed","2023-03-07T08:00:00","No","No","No","Internal"]
[null,null,null,null,19464,"129_Tue Mar 21 2023 09:26:08 GMT+0800","2023-01-25T08:00:00","Non Conformity","Ship Staff","Ship Staff Insp.","Lifebuoys are painted  which is a fire hazard and Prevent any damages/crack to the buoys on Inspection. ","LSA / FFA","Safety / LSA / FFA","Human Error","","","","","Lifebuoys received in Bayuquan China and all lifebuoys replaced which were painted including MOB lifebuoys of 4.5 Kgs.","2023-02-08T08:00:00","","Completed","2023-02-12T08:00:00","No","No","No","Internal"]
[null,null,null,null,51214,"129_Tue Mar 21 2023 09:29:22 GMT+0800","2023-01-31T08:00:00","Defect","Ship Staff","Ship Staff Insp.","Port and stbd pilot access ladder's Nut and bolt which is joining the Upper platform and the ladder is thinned down and wasted.","Deck - Machinery","Safety / LSA / FFA","Equipment Related","","","","","Renewed the Nut and bolt for both the Pilot Access Ladder.","2023-03-08T08:00:00","","Completed","2023-03-20T08:00:00","No","No","No","Internal"]
[null,null,null,null,21195,"129_Tue Mar 21 2023 09:35:21 GMT+0800","2023-02-16T08:00:00","Defect","Ship Staff","Ship Staff Insp.","GANGWAY PORT AND STBD ROLLER FOUND DAMAGED. ","Hull & Tanks","Structural Condn. / WT integrity ","Knowledge Based","","","","","BOTH PORT AND STBD GANGWAY ROLLERS RENEWED.","2023-03-25T08:00:00","","Completed","2023-03-21T08:00:00","No","No","No","Internal"]
[null,null,null,null,25285,"129_Tue Mar 21 2023 09:41:33 GMT+0800","2023-02-09T08:00:00","Defect","Ship Staff","Ship Staff Insp.","Catwalk grating between HC No.3 and 4 found wasted.","Deck - Pipe / Fittings","Structural Condn. / WT integrity ","Industry Issue","","","","","RENEWED FRAME AND GRATINGS ON CROSS DECK BETWEEN HC No.3 AND 4.","2023-03-31T08:00:00","","Completed","2023-03-21T08:00:00","No","No","No","Internal"]
[null,null,null,null,90587,"129_Wed Mar 22 2023 02:28:30 GMT+0800","2023-03-22T08:00:00","Observation","Ship Staff","Ship Staff Insp.","#7 MOORING WINCH REDUCTION GEAR SIDE SEAL TO RENEW ","Deck - Mooring Machinery","Mooring","Equipment Related","","","","","seal renewed and system tried out.Operation found in order.","2023-03-31T08:00:00","","Completed","2023-03-23T08:00:00","No","No","No","Internal"]
[null,null,null,null,84459,"129_Tue Mar 21 2023 09:44:50 GMT+0800","2023-02-07T08:00:00","Defect","Ship Staff","Ship Staff Insp.","VALVE 001VPW IS NOT OPERABLE FROM SHIP'S OFFICE CONSOLE AND REQUIRED TO BE OPEN MANUALLY FROM ENGINE ROOM","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","","","","","Defect rectefied.Valve operation checked from console.Working in order.","2023-03-30T08:00:00","","Completed","2023-03-21T08:00:00","No","No","No","Internal"]
[null,null,null,null,77807,"129_Fri Mar 24 2023 11:18:57 GMT+0800","2023-03-21T08:00:00","Observation","Ship Staff","Ship Staff Insp.","# 6 mooring winch reduction gear side seal to be renewed","Deck - Mooring Machinery","","Equipment Related","","","","","Seal renewed and system tried out.Operation in order","2023-03-31T08:00:00","","Completed","2023-03-24T08:00:00","No","No","No","Internal"]
[null,null,null,null,51061,"129_Fri Mar 24 2023 12:25:21 GMT+0800","2023-03-21T08:00:00","Observation","Ship Staff","Ship Staff Insp.","# 8 Mooring winch reduction gear side seal to renew","Deck - Mooring Machinery","","Equipment Related","","","","","reduction gear side seal renewed. System tried out. Operation in order.","2023-03-31T08:00:00","","Completed","2023-03-28T08:00:00","No","No","No","Internal"]
[null,null,null,null,66931,"129_Wed Mar 29 2023 00:31:45 GMT+0800","2023-01-25T08:00:00","Observation","Ship Staff","Ship Staff Insp.","Main Deck Abreast Port side HC No.1 rusted 35-40%. Require derusting and painting.","","General Appearance","External Factors","","","","","Completed derusting and painting main deck port side abreast No.1 HC. Now in good condition.","2023-03-31T08:00:00","","Completed","2023-03-18T08:00:00","No","No","No","Internal"]
[null,null,null,null,13692,"129_Wed Mar 29 2023 00:38:11 GMT+0800","2023-01-31T08:00:00","Observation","Ship Staff","Ship Staff Insp.","Hatch cover quick actings cleats are rusted and require derusting.  Cleats are also found in frozen condition.","Hull & Tanks","Structural Condn. / WT integrity ","External Factors","","","","","Completed All hatch cover quick acting cleats dismantling, freeing and Derusting/painting. Now in Good condition.","2023-03-31T08:00:00","","Completed","2023-03-28T08:00:00","No","No","No","Internal"]
[null,null,null,null,96649,"129_Wed Mar 29 2023 11:56:32 GMT+0800","2023-02-08T08:00:00","Defect","Ship Staff","Ship Staff Insp.","Securing arrangement for chains on main deck have thinned down and some have been wasted. ","Deck - Pipe / Fittings","Safety / LSA / FFA","Inappropriate Procedure,Human Error","","","","","All Securing arrangement of chains inspected and whichever were thinned down or wasted renewed.","2023-03-31T08:00:00","","Completed","2023-03-27T08:00:00","No","No","No","Internal"]
[null,null,null,null,70665,"129_Wed Mar 29 2023 12:36:43 GMT+0800","2023-02-02T08:00:00","Observation","Ship Staff","Ship Staff Insp.","Inclinometer found fabricated onboard and presently angle indicator frozen on Port and stbd gangway. ","Deck - Pipe / Fittings","Safety / LSA / FFA","Human Error,Inappropriate Procedure,Knowledge Based","","","","","Renewed Inclinometer for port and stbd gangway.","2023-02-28T08:00:00","","Completed","2023-03-08T08:00:00","No","No","No","Internal"]
[null,null,null,null,50517,"129_Wed Mar 29 2023 12:38:59 GMT+0800","2023-02-02T08:00:00","Non Conformity","Ship Staff","Ship Staff Insp.","Inclinometer found missing from Port and stbd Pilot access ladders.","Deck - Pipe / Fittings","Safety / LSA / FFA","External Factors,Human Error,Inappropriate Procedure,Knowledge Based","","","","","Frame fabricated and New angle inclinometer installed on Port and stbd Pilot access ladder.","2023-02-28T08:00:00","","Completed","2023-02-08T08:00:00","No","No","No","Internal"]
[null,null,null,null,58007,"129_Wed Apr 12 2023 14:02:33 GMT+0800","2023-04-07T08:00:00","Observation","Ship Staff","Ship Staff Insp.","# 1 Mooring winch reduction gear side seal to renew","Deck - Mooring Machinery","","Equipment Related","","","","","reduction gear side seal renewed. System tried out. Operation found in order.","2023-04-30T08:00:00","","Completed","2023-04-12T08:00:00","No","No","No","Internal"]

{"sheet":"Calc","index":2,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["Def_type","Def_cause","Equipments","VIQrefno","Observer_code"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Dim itemSele As Long"]
[null,null,null,null,null,null,null,null,null,null,null,"   dim startRow as integer"]
[null,null,null,null,null,null,null,null,null,null,null,"   startRow=1"]
[null,null,null,null,null,null,null,null,null,null,null,"        For itemSele = 0 To ListBox1.ListCount - 1"]
[null,null,null,null,null,null,null,null,null,null,null,"        If ListBox1.Selected(itemSele) = True Then"]
[null,null,null,null,null,null,null,null,null,null,null,"        Worksheets(\"WorksheetName\").Range(\"A\" & startRow).Value = ListBox1.List(itemSele)"]
[null,null,null,null,null,null,null,null,null,null,null,"        startRow = startRow + 1"]
[null,null,null,null,null,null,null,null,null,null,null,"        End If"]
[null,null,null,null,null,null,null,null,null,null,null,"        Next"]
[null,null,null,null,null,null,null,null,null,null,null,"Dim LastRowA As String"]
[null,null,null,null,null,null,null,null,null,null,null,"        Dim itemSele As Long"]
[null,null,null,null,null,null,null,null,null,null,null,"       Dim startRow as integer"]
[null,null,null,null,null,null,null,null,null,null,null,"        LastRowA = ActiveSheet.Cells(Rows.count, \"A\").End(xlUp).row"]
[null,null,null,null,null,null,null,null,null,null,null,"        startQue = 0"]
[null,null,null,null,null,null,null,null,null,null,null,"        For itemSele = 0 To ListBox1.ListCount - 1"]
[null,null,null,null,null,null,null,null,null,null,null,"        For startRow = 1 To LastRowA"]
[null,null,null,null,null,null,null,null,null,null,null,"        If Worksheets(\"WorksheetName\").Range(\"A\" & startRow).Value = ListBox1.List(itemSele) Then"]
[null,null,null,null,null,null,null,null,null,null,null,"        ListBox1.Selected(itemSele) = True"]
[null,null,null,null,null,null,null,null,null,null,null,"        Exit For"]
[null,null,null,null,null,null,null,null,null,null,null,"        End If"]
[null,null,null,null,null,null,null,null,null,null,null,"        Next j"]
[null,null,null,null,null,null,null,null,null,null,null,"        Next"]
[null,null,null,null,null,null,null,null,null,null,null,"        End If"]

{"sheet":"Areaofobs","index":3,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["TITLE","ID"]
["Cargo / Ballast Systems",11]
["Cert. & Docu.",2]
["Communication",6]
["Crew Management",3]
["Emgcy. Systems",13]
["Eng. / Strg. Comp.",14]
["General Appearance",15]
["Ice Opns.",17]
["ISM Related",7]
["ISPS Related",10]
["MARPOL Related",9]
["MLC Related",4]
["Mooring",12]
["Navigation",5]
["Safety / LSA / FFA",8]
["Structural Condn. / WT integrity ",16]

{"sheet":"Vessel_type","index":4,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Vessel_type","ID"]

{"sheet":"Deficiency_type","index":5,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["TITLE","Type of deficiency_description","ID"]
["Breakdown",null,6]
["Critical Equipment",null,4]
["Defect",null,1]
["Guarantee Claim",null,8]
["Non Conformity",null,2]
["Observation",null,3]
["Other",null,7]

{"sheet":"VIQrefno","index":6,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["VIQ_ref_no","Risk Value of observation","ID"]

{"sheet":"Equipment_list","index":7,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["TITLE","Equipment_list_description","ID"]
["Accommodation",null,12]
["Cargo Mach.",null,13]
["Critical Equip.",null,16]
["Deck - Machinery",null,18]
["Deck - Mooring Machinery",null,15]
["Deck - Pipe / Fittings",null,20]
["Documentation",null,21]
["E/R - Air Comp.",null,8]
["E/R - Aux. Engine",null,4]
["E/R - Aux. Mach.",null,7]
["E/R - Boiler",null,5]
["E/R - Main Engine",null,3]
["E/R - Pipes/ valves & fittings",null,9]
["E/R - Pumps",null,32]
["E/R - Purifier",null,6]
["Elect. Mach. & Equip.",null,10]
["Hull & Tanks",null,19]
["Inert Gas",null,14]
["LSA / FFA",null,17]
["Miscellaneous",null,22]
["Navigation - DGPS / EPFS / AIS",null,28]
["Navigation - ECDIS",null,25]
["Navigation - Echo Sounder / Speed Log",null,26]
["Navigation - GMDSS & Communication",null,23]
["Navigation - Others",null,11]
["Navigation - RADAR",null,24]
["Navigation - VDR / BNWAS",null,30]

{"sheet":"PSC_MOU","index":8,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["TITLE","PSC_MOU_description","ID"]
["Asia and the Pacific",null,2]
["Caribbean",null,4]
["Europe and the North Atlantic",null,1]
["Latin America",null,3]
["The Black Sea region",null,6]
["The Indian Ocean",null,8]
["The Mediterranean",null,7]
["The Riyadh MoU",null,9]
["USCG",null,10]
["West and Central Africa",null,5]

{"sheet":"Inspection_type","index":9,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["TITLE","ID"]
["Bunkering Audit",14]
["Cargo Audit",17]
["Engineering Audit",16]
["ISM Audit",2]
["ISPS Audit",3]
["IT Audit",10]
["MLC Audit",1]
["Mooring Audit",9]
["Nav Audit / Verification",8]
["Onboard Training",18]
["Ship Staff Insp.",15]
["Suptd. Insp.",13]

{"sheet":"Deficiency_Cause","index":10,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["TITLE","Deficiency_Cause_description","ID"]
["Behaviour Based",null,1]
["Equipment Related",null,4]
["External Factors",null,5]
["Human Error",null,7]
["Inappropriate Procedure",null,8]
["Industry Issue",null,6]
["Knowledge Based",null,3]

{"sheet":"Observer_code","index":11,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["TITLE","Observer_code_description","ID"]
["Owner / Marine / Tech. Suptd.",null,3]
["Ship Staff",null,2]

{"sheet":"Status_code","index":12,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["TITLE","Status_code_description","ID"]
["Completed",null,6]
["Deferred to D D",null,5]
["In progress",null,3]
["Not Started",null,2]
["Waiting spare",null,4]

{"sheet":"PSC_ref_no","index":13,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["TITLE","ID"]
["Alarms",9]
["Cargo operations including equipment",7]
["Certificates & Documentation",2]
["Dangerous Goods",13]
["Emergency Systems",5]
["Fire safety",8]
["ISM",16]
["ISPS",17]
["Life saving appliances",12]
["MLC, 2006",18]
["Other",19]
["Pollution Prevention",15]
["Propulsion and auxiliary machinery",14]
["Radio communication",6]
["Safety of Navigation",11]
["Structural condition",3]
["Water/Weathertight condition",4]
["Working and Living Conditions",10]

{"sheet":"Risk_value_of_obs","index":14,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Risk Value of observation","ID"]

{"sheet":"Year","index":15,"n_rows":18,"n_cols":1,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["Year"]
[2014]
[2015]
[2016]
[2017]
[2018]
[2019]
[2020]
[2021]
[2022]
[2023]
[2024]
[2025]
[2026]
[2027]
[2028]
[2029]
[2030]

{"sheet":"Month","index":16,"n_rows":13,"n_cols":1,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Month"]
["Jan"]
["Feb"]
["Mar"]
["Apr"]
["May"]
["Jun"]
["Jul"]
["Aug"]
["Sep"]
["Oct"]
["Nov"]
["Dec"]

{"sheet":"Date_","index":17,"n_rows":32,"n_cols":1,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["Date"]
["01"]
["02"]
["03"]
["04"]
["05"]
["06"]
["07"]
["08"]
["09"]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]

{"sheet":"Sheet1","index":18,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
[]
[null,"ID","E",null,"Date Recorded",1]
[null,"UNIQUE ID","F",null,"Type of Deficiency",2]
[1,"Date Recorded","G",null,"Observer code",3]
["ignore","Vessel Type","H",null,"Type of Inspection",4]
[null,"Internal / External","I",null,"Description of Deficiency",5]
[null,"Drydock","J",null,"Equipment Categories",6]
[null,"Information Sharing","K",null,"Area of Observation",7]
[null,"Critical_item","L",null,"Deficiency Cause",8]
[null,"Deficiency Type","M",null,"VIQ Ref Number",9]
[null,"Deficiency Cause","N",null,"Risk Value of Obs",10]
[null,"Inspection Type","O",null,"PSC Ref Number",11]
[null,"Equipments","P",null,"PSC MOU ID",12]
[null,"VIQ Reference Number","Q",null,"Action Taken or Required",13]
[null,"Risk Value of the observation","R",null,"Target Date",14]
[null,"PSC Reference Number","S",null,"PO Ref No.",15]
[null,"PSC MOU","T",null,"Status Code",16]
[null,"Observer Code","U",null,"Date Completed",17]
[null,"Target Date","V",null,"Drydock",18]
[null,"Status Code","W",null,"Info Sharing",19]
[null,"Description of Deficiency","X",null,"Critical Item Flag",20]
[null,"Action taken / required","Y",null,"Audit Type",21]
[null,"PO ref no","Z"]
[null,"Date completed","AA"]

{"sheet":"Ship_information","index":19,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Ship_ID","Ship_Name","FILE_NAME"]
["129","CAPE PHOENIX (21-11-2022)","129_1671429315175.xlsm"]

{"sheet":"External_Deficiency_type","index":20,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["TITLE","Type of deficiency_description","ID"]
["Condn of Class / Memo",null,5]
["Defect",null,1]
["Non Conformity",null,2]
["Observation",null,3]

{"sheet":"External_Inspection_type","index":21,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["TITLE","ID"]
["Cargo Audit",17]
["Flag State Insp.",5]
["ISM Audit",2]
["ISPS Audit",3]
["MLC Audit",1]
["Nav Audit / Verification",8]
["OM Insp. (Eg. SIRE / CDI etc.)",6]
["Others (Eg. Insurance etc.)",12]
["PSC Inspection",4]
["Terminal Insp.",11]

{"sheet":"External_Observer_code","index":22,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["TITLE","Observer_code_description","ID"]
["Class Surveyor",null,4]
["FSC Inspector",null,5]
["Others (Eg. Insurance etc.)",null,9]
["PSC Insp.",null,6]
["SIRE / CDI Insp.",null,8]
["Terminal Insp.",null,7]

{"sheet":"Sheet Version","index":23,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Version","Title"]
["2.0","Version 2.0"]