{"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":5,"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":42,"n_cols":28,"rows_kept":42,"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","03-Jan-2020",null,null,"Ship Name","ATHENA (27-12-2019)"]
[]
[null,null,null,null,null,null,"VERSION : 2.0"]
[]
[]
[]
[null,null,null,null,"ID","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,6295,"92_21/11/2019 8:23:12 AM","2019-11-08","Defect","Ship Staff","Ship Staff Insp.","Drinking water unit UV steriliser showing alarm indication while in use. The value is found to be at alarm level.","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Drinking water unit UV steriliser checked, UV control unit & UV meter found defective, requisition raised for same.","2020-02-08",null,"Waiting spare",null,"No","No","No","Internal","It has been approx. 2 months since this defect was reported but to date you still have not checked & trouble shoot the problem. Why? Pls look into this soonest & revert with your findings."]
[null,null,null,null,6307,"92_20/11/2019 3:50:00 PM","2019-11-10","Defect","Ship Staff","Ship Staff Insp.","ESD not tripped cargo compressor and cargo pumps","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","ESD system troubleshooting in progress as during activation signal found across manifold valve and cargo control console panel, remaining circuit tracing for comp. and cargo pumps in progress.","2020-02-12",null,"In progress",null,"No","No","No","Internal","Pls revert with updated status of your checking & fault finding."]
[null,null,null,null,6308,"92_20/11/2019 3:56:57 PM","2019-11-12","Defect","Ship Staff","Ship Staff Insp.","Cargo pump No 1 P ,2 P, 4 S, discharge pressure reading in CCR not operational","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",8.1300000000000008,"High","Not Applicable","Not Applicable","Cargo pump No 1 P ,2 P, 4 S& 4P discharge pressure reading in CCR not operational, circuit traced for same and calibration carried out by injecting current signal for all after removing pressure transmitterfound in working condition, after that pressure transmitter tested for operation, pressure transmitters (1P,2P,4P&4S) found defective, Requisition raised.","2020-02-05",null,"Waiting spare",null,"No","No","No","Internal","When do you plan to carry out the checks? Suggest that you arrange for same at your earliest."]
[null,null,null,null,6309,"92_20/11/2019 4:02:20 PM","2019-11-12","Defect","Ship Staff","Ship Staff Insp.","Ballast valves cannot operate from CCR(Kongsberg).Ballast valves in E/R are operated by manual hand pump.","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","WBT 1,2 & 3 valves can be operated from ccr now and circuit tested for indication, one power supply +5VDC found missing, will check same by adding additional supply.Requisition raised for power supply.","2020-02-23",null,"In progress",null,"No","No","No","Internal","Understand that checks are in progress. Pls revert with updated status for same & amend target date based on your findings."]
[null,null,null,null,6310,"92_20/11/2019 4:11:56 PM","2019-11-12","Defect","Ship Staff","Ship Staff Insp.","Cargo tank level indication on kongsberg for Tank 1 s,2p,3p&s,4p&s not opeartional","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","Level indication signal tracing in progress, checked all level indicators local connection.","2020-02-05",null,"In progress",null,"No","No","No","Internal","Will arrange attendance of Service Engineer from Kongsberg at vessel's next convenient port. Tech. Supt. pls advice arrangement plan."]
[null,null,null,null,6311,"92_20/11/2019 4:26:51 PM","2019-11-12","Defect","Ship Staff","Ship Staff Insp.","Cargo compressor automation for level control not operational","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","","","","","To be checked","2020-01-31","","Not Started",null,"No","No","No","Internal","Pls advice when you plan to carry out the checks to verify the problem."]
[null,null,null,null,6313,"92_20/11/2019 7:16:21 PM","2019-11-05","Defect","Ship Staff","Ship Staff Insp.","ROT indicator at the bridge Overhead Panel is Not Working","Navigation - Others","Navigation","Equipment Related",null,null,"Not Applicable","Not Applicable","ROT wiring checked, found that ROT connected from old gyro control panel, newly installed gyro panel not configured with present ROT. Work in progress.\r\n","2020-02-16",null,"In progress",null,"No","No","No","Internal","Please advice when you plan to commence repairs? \nOverdue target date should be revised a necessary."]
[null,null,null,null,6314,"92_20/11/2019 7:19:30 PM","2019-11-05","Defect","Ship Staff","Ship Staff Insp.","Gyro Digital display ( Ship’s Heading) at the bridge Overhead Panel is Not Working","Navigation - Others","Navigation","Equipment Related",null,null,"Not Applicable","Not Applicable","Gyro digital display wiring checked, found that display connected from old gyro control panel, newly installed gyro panel not configured with present digital display. Work in progress.\r\n.","2020-02-17",null,"In progress",null,"No","No","No","Internal","When do you plan to commence defect rectification / replacement of dispay unit?  If required, pls issue RO for supply of replacement display unit."]
[null,null,null,null,6317,"92_20/11/2019 7:28:37 PM","2019-11-06","Defect","Ship Staff","Ship Staff Insp.","No Printer (Echograph) is connected to Echosounder.","Navigation - Echo Sounder / Speed Log","Navigation","Equipment Related",null,null,"Not Applicable","Not Applicable","Echograph printer to be fitted.","2020-02-16",null,"Not Started",null,"No","No","No","Internal","Kamlesh, please advice plans for fitting of printer for echo sounder."]
[null,null,null,null,6318,"92_20/11/2019 7:30:57 PM","2019-11-08","Defect","Ship Staff","Ship Staff Insp.","Vessel has only one Aneroid Barometer which shows erratic reading.","Navigation - Others","Navigation","Equipment Related",null,null,"Not Applicable","Not Applicable","Aneroid Barometer to be calibrated or replaced","2020-02-11",null,"Not Started",null,"No","No","No","Internal","Tech. Supt to advice plans for calibration / replacement  of unit."]
[null,null,null,null,6320,"92_20/11/2019 8:56:20 PM","2019-11-03","Breakdown","Owner / Marine / Tech. Suptd.","Suptd. Insp.","No.1 Aux. Engine is out of order","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","To be replaced/repaired","2020-02-12",null,"Not Started",null,"No","No","No","Internal","Replacement unit being organised from this office. Will update once same is available."]
[null,null,null,null,6321,"92_20/11/2019 9:06:06 PM","2019-11-03","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","No.2 & 3 Aux. Engine unable to take load more than 75%","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","To be investigated","2020-02-22",null,"Not Started",null,"No","No","No","Internal","Although status code indicate \"Not Started\", pls advice if investigation has been carried out verify reason for units not able to take load >75%.  If yes, pls revert with findings."]
[null,null,null,null,6322,"92_20/11/2019 9:10:25 PM","2019-11-03","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Engine bilges were found very dirty","Miscellaneous","Eng. / Strg. Comp.","Inappropriate Procedure",null,null,"Not Applicable","Not Applicable","Cleaning & painting in progress. Derusting, chipping of the complete bilges including the bilge wells already completed. Port & stbd bilge wells cleaning,painting also completed.","2020-02-25",null,"In progress",null,"No","No","No","Internal","Please revert with update on progress status of cleaning & painting the bilges, in percentage basis. How much area has been completed? Pls amend target date base on job progress."]
[null,null,null,null,6329,"92_21/11/2019 2:25:54 AM","2019-11-03","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Atleast two expansion valves for the cargo re-liquefication plant are not working","Hull & Tanks","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","Shall carry out necessary checks at the next opportunity when compressors are in stop condition.","2020-02-08",null,"In progress",null,"No","No","No","Internal","When do you plan to check the expansion valves, since target date is already overdue?"]
[null,null,null,null,6330,"92_21/11/2019 2:34:21 AM","2019-11-03","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","No.5 ME FO PUMP HAS BEEN REPORTED TO HAVE MARKS","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related","","","","","Need to examine or changed","2020-06-06","","Not Started",null,"No","No","No","Internal","Pls keep this office updated on plans to carry out same."]
[null,null,null,null,6332,"92_21/11/2019 2:41:49 AM","2019-11-03","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Main deck area from compressor room to the forecastle deck is spot rusted","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","Need to cleaning/ painting","2020-02-25",null,"Not Started",null,"No","No","No","Internal","When do you plan to commence with cleaning & painting?"]
[null,null,null,null,6333,"92_21/11/2019 2:44:32 AM","2019-11-03","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","The accommodation front is rusted","Accommodation","General Appearance","Inappropriate Procedure",null,null,"Not Applicable","Not Applicable","Need to clening & painting","2020-02-28",null,"Not Started",null,"No","No","No","Internal","When do you plan to commence cleaning & painting of affected areas?"]
[null,null,null,null,6334,"92_21/11/2019 2:59:33 AM","2019-11-03","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Provision cranes are rusted. presently only port side provision crane is being used","Deck - Machinery","General Appearance","Inappropriate Procedure",null,null,"Not Applicable","Not Applicable","Need to check & rectify","2020-02-25",null,"Not Started",null,"No","No","No","Internal","When do you plan to commence checking & rectification process?\nWhat is the situation with the other provision crane?  Is it operational or defective?"]
[null,null,null,null,6336,"92_21/11/2019 3:19:09 AM","2019-11-03","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Ship elevator is not operational.","Accommodation","General Appearance","Equipment Related",null,null,"Not Applicable","Not Applicable","Technician attended the issue last call Singapore & work in progress.\r\n","2020-02-08",null,"In progress",null,"No","No","No","Internal","Understand that checking is in progress. Pls revert with your findings and repairs requirement."]
[null,null,null,null,6340,"92_21/11/2019 3:38:03 AM","2019-11-08","Defect","Ship Staff","Ship Staff Insp.","No.2 main air bottle pressure local gauge found not showing correct reading.","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Need to replace with spare","2020-02-08",null,"Not Started",null,"No","No","No","Internal","Presume spare pressure gauge is available on board since no request for supply has been created. When do you plan to replace same since the target date is already overdue."]
[null,null,null,null,6341,"92_21/11/2019 3:41:51 AM","2019-11-08","Defect","Ship Staff","Ship Staff Insp.","Main engine viscometer found in inoperational condition.","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Viscosity controller and heater controller valve tested for operation, now need to check visco therm during of main engine stopping.","2020-02-08",null,"In progress",null,"No","No","No","Internal","Noted that status code still indicating as \"Not Started\". When do you plan to carry out checks, calibration & rectification?"]
[null,null,null,null,6343,"92_21/11/2019 3:48:55 AM","2019-11-09","Defect","Owner / Marine / Tech. Suptd.","Ship Staff Insp.","Main engine 2nd stage back wash filter found in inoperational condition.","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Need to check for operation and rectify same","2020-02-17",null,"Not Started",null,"No","No","No","Internal","When do you plan to carry out the checks? The indicated target date is already over due."]
[null,null,null,null,6345,"92_Thu Nov 21 2019 07:59:01 GMT+0000","2019-11-03","","Owner / Marine / Tech. Suptd.","","AE 4 Crankshaft crankpins worn out. AE Out of order.","","","Equipment Related","","","","","",null,"","",null,"No","No","No","Internal","Technical Superintendent pls advice plan / action to be taken."]
[null,null,null,null,9332,"92_27/12/2019 9:05:08 AM","2019-11-04","Defect","Class Surveyor","ISM Audit","Understand that Thai Marine Dept does not issue CRAs,however the application for COEs for officers onboard has been submitted by the registered owner.it is recommended that atleast an acknowledgement or endorsement of application is obtained from the flag,to avoid any issue with PSC (clause 1.2.3)","Documentation","ISM Related","Industry Issue",null,null,"Not Applicable","Not Applicable","Awaiting  acknowledgement from Thai flag for COE applications.","2020-02-28",null,"In progress",null,"No","No","No","External","Have requested Fleet Personnel Dept. to check & advice if acknowledgement from Thai Flag has been issued (via email)."]
[null,null,null,null,9333,"92_27/12/2019 9:14:10 AM","2019-11-04","Defect","Class Surveyor","ISM Audit","Noted that ship was just taken over however Master & Chief Eng to pay attention to :-Traces of water on the E/R tank top,water collection found in the emergency fire pump room tank top and leakge noted at the fwd hydraulic line on the foscle deck.(Clause 10)","Deck - Pipe / Fittings,Miscellaneous","ISM Related","External Factors",null,null,"Not Applicable","Not Applicable","E/R tank top area to be cleaned and leakage to be rectified.","2020-02-26",null,"In progress",null,"No","No","No","External","Pls revert with update on progress status of retification. Once completed, pls take photographs of the affected areas in case same requested by Class Surveyor for verification."]

{"sheet":"Completed","index":1,"n_rows":70,"n_cols":28,"rows_kept":70,"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","3-0-2020",null,null,"Ship Name","ATHENA (27-12-2019)"]
[]
[null,null,null,null,null,null,"VERSION : 2.0"]
[]
[]
[]
[null,null,null,null,"ID","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,6288,"92_21/11/2019 4:08:27 AM","2019-11-11","Defect","Ship Staff","Ship Staff Insp.","Main air compressor no.1& 2 unable to cut in in Auto mode.","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","","","","","Checked all wiring for auto operation, found one pressure switch defective & replaced with old one.","2019-12-10","","Completed","2019-12-15","No","No","No","Internal"]
[null,null,null,null,6297,"92_20/11/2019 4:34:57 PM","2019-11-03","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","All starboard side cargo pumps have been overhauled but the pumps have not been tried out yet. ","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","","","","","All cargo pumps tried out,found satisfactory","2019-11-09","","Completed","2019-11-10","No","No","No","External"]
[null,null,null,null,6298,"92_20/11/2019 9:20:06 PM","2019-11-03","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Some laggings on the Main Engine were found soaked in oil","E/R - Main Engine","Eng. / Strg. Comp.","Inappropriate Procedure","","","","","Leaks rectified to stop source of ingress & area cleaned.","2019-11-25","","Completed","2019-11-20","No","No","No","Internal"]
[null,null,null,null,6299,"92_21/11/2019 2:48:54 AM","2019-11-03","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","All starboard side cargo pumps have been overhauled but not tried out yet","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","","","","","Need to check during discharging.","2019-11-25","","Completed","2019-11-12","No","No","No","Internal"]
[null,null,null,null,6300,"92_21/11/2019 3:22:26 AM","2019-11-03","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","One hot plate unit in the galley is not operational.","Elect. Mach. & Equip.","General Appearance","Equipment Related","","","","","Need to check for operation & rectify same","2019-11-25","","Completed","2019-11-17","No","No","No","Internal"]
[null,null,null,null,6301,"92_21/11/2019 3:58:24 AM","2019-11-07","Defect","Ship Staff","Ship Staff Insp.","Cargo dep well pump no.1 (p) and tank no.2 (p&s) were showing less than 1 mega ohms insulation resistance.","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","","","","","Same tested found ingress of water in motor terminal box, rectified same.","2019-11-11","","Completed","2019-11-10","No","No","No","Internal"]
[null,null,null,null,6302,"92_21/11/2019 4:03:01 AM","2019-11-15","Defect","Ship Staff","Ship Staff Insp.","AFT ICCP Panel was showing no reading.","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","","","","","Tested, found one rectifier circuit in defective condition, rectify and tested for operation, found in working condition.","2019-11-18","","Completed","2019-11-17","No","No","No","Internal"]
[null,null,null,null,6305,"92_20/11/2019 2:48:47 PM","2019-11-10","Defect","Ship Staff","Ship Staff Insp.","Cargo tank No 1 stbd level gauge reading in CCR not operational","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","","","","","To be checked by ETO / shore technician ,Checked by ETO,to be confirmed during loading operation","2019-12-31","","Completed","2019-12-13","No","No","No","Internal"]
[null,null,null,null,6306,"92_20/11/2019 2:53:03 PM","2019-11-10","Defect","Ship Staff","Ship Staff Insp.","Cargo tank No 3 & 4 pressure reading in CCR not operational","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","","","","","Calibrated all pressure transmitters, checked all zener barrier & replaced defective zener barrier. ","2019-12-31","","Completed","2019-12-02","No","No","No","Internal"]
[null,null,null,null,6312,"92_20/11/2019 4:32:14 PM","2019-11-12","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Deck equipments found to be not properly greased","Deck - Machinery","Mooring","Equipment Related",null,null,"Not Applicable","Not Applicable","Greasing carried out for all mooring winches,windlass,gangway & pilot ladder reel","2019-12-31",null,"Completed","2019-11-29","No","No","No","External","When do you plan to carry out said job? Pls keep this office updated accordingly."]
[null,null,null,null,6319,"92_20/11/2019 7:33:45 PM","2019-11-08","Defect","Ship Staff","Ship Staff Insp.","No automatic GPS feed to MF station.","Navigation - GMDSS & Communication","Navigation","Equipment Related","","","","","GPS feed to be given to the MF station.","2019-12-31","","Completed","2019-12-16","No","No","No","Internal"]
[null,null,null,null,6324,"92_20/11/2019 10:32:47 PM","2019-11-03","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Very dirty engine casing. Exhuast pipes & laggings in poor condition. No illumination in top part.","Miscellaneous","Eng. / Strg. Comp.","Inappropriate Procedure","","","","","Cleaning of the casing, exhaust trunking & lagging carried out. Futher paiting done of the complete area including exhaust piping, lagging, economiser.","2019-12-24","","Completed","2019-12-15","No","No","No","Internal"]
[null,null,null,null,6325,"92_20/11/2019 10:41:40 PM","2019-11-03","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Emergency fire pump room dirty. Platform filled with water.","Miscellaneous","General Appearance","Inappropriate Procedure","","","","","Cleaning carried out & source of water ingress found from priming unit pipeline sheared off at one point, same was renewed.","2019-11-30","","Completed","2019-11-15","No","No","No","Internal"]
[null,null,null,null,6326,"92_20/11/2019 10:48:04 PM","2019-11-03","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Protection glass on controllers missing","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","","","","","New glass fabricated using acrylic sheet & fitted in all missing. ","2019-12-15","","Completed","2019-12-14","No","No","No","Internal"]
[null,null,null,null,6327,"92_20/11/2019 11:17:00 PM","2019-11-03","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Kongsberg unit remote not displaying pressure readings of No.3 & 4 cargo tanks.  ","Elect. Mach. & Equip.","Cargo / Ballast Systems","Equipment Related","","","","","Calibrated all pressure transmitter, checked all zener barrier & replaced defective zener barrier.","2019-12-15","","Completed","2019-12-02","No","No","No","Internal"]
[null,null,null,null,6328,"92_21/11/2019 2:21:05 AM","2019-11-03","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","New service air compressor is installed but still to be commissioned.","Miscellaneous","Eng. / Strg. Comp.","Inappropriate Procedure","","","","","Service air compressor put into service after carrying out all necessary checks including pipelines, valves condition etc. Presently fabricated section for giving service air, control air from service air compressor.","2019-12-31","","Completed","2019-12-03","No","No","No","Internal"]
[null,null,null,null,6335,"92_21/11/2019 3:02:59 AM","2019-11-03","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Deck equipments did not appear to be properly greased.","Deck - Pipe / Fittings","General Appearance","Inappropriate Procedure","","","","","Greasing to be done as per schedule.All mooring winches,windlass,gangway & pilot ladder reel greased","2019-12-30","","Completed","2019-11-25","No","No","No","Internal"]
[null,null,null,null,8172,"92_15/12/2019 7:01:28 PM","2019-12-15","Defect","Ship Staff","Ship Staff Insp.","Water spary isolation valve for compressor room found seized in open position","LSA / FFA","LSA / FFA Appliances","Equipment Related","","","","","To be made free for movement","2019-12-17","","Completed","2019-12-16","No","No","No","Internal"]
[null,null,null,null,8173,"92_25/11/2019 2:54:15 PM","2019-11-05","Defect","Ship Staff","Ship Staff Insp.","Port side gangway is not moving out from stowed position to deck level & not moving in from deck level to stowed position without extra force.","Deck - Machinery","General Appearance","Equipment Related","","","","","Proper greasing to be done & all rollers to be made free.","2019-11-30","","Completed","2019-11-25","No","No","No","Internal"]
[null,null,null,null,8174,"92_Sat Jan 12 2019 22:44:04 GMT+0000 (Coordinated Universal Time)","2019-11-30","Breakdown","Ship Staff","Ship Staff Insp.","2nd stage piston keys of No 4 cargo compressor gave way .","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","","","","","Piston keys changed","2019-11-30","","Completed","2019-11-30","No","No","No","Internal"]
[null,null,null,null,8175,"92_15/12/2019 8:48:12 PM","2019-12-02","Defect","Ship Staff","Ship Staff Insp.","During starter routine of both lifeboat davit it was noted that all limit switches isolated by shorting.","LSA / FFA","LSA / FFA Appliances","Equipment Related","","","","","All limit switches tested for operation & connected in both starter according to drawing, tested for operation, found in working condition.","2019-12-15","","Completed","2019-12-07","No","No","No","Internal"]
[null,null,null,null,9334,"92_27/12/2019 9:30:29 AM","2019-11-04","Defect","Class Surveyor","MLC Audit","The ship was just taken over,from the Ex mangement.However the following areas are to be addressed: Housekeeping in galley,cabinets,out side of provision stores to be carried out.Dishwasher currently used as storage.To be repaired or removed.Cockroach sighted in the galley,messrooms,provision stores.Company to take measures to eliminate.Noted cockroach traps were put inplace by ex-mangement periously.Fridge in the galley & chiller in the crew mess not cold.Water cooler in crew mess,cold water faucet for the galley hand wash basin,officers somkeroom fridge-not working","Accommodation","MLC Related","Industry Issue","","","","","Fumigation carried out twice.Galley,provision stores, alleyways and other stores were cleaned and painted.Officers smoke room & galley fridge renewed.New water cooler & faucet installed.","2020-01-30","","Completed","2019-12-26","No","No","No","External"]
[null,null,null,null,9335,"92_27/12/2019 9:38:27 AM","2019-11-04","Defect","Class Surveyor","MLC Audit","Authorization for PT Tenaga Baru Nuansa Perdana to sign the SEA with (Indoesian) seafarers on behalf of the shipowner to be placed onboard.","Documentation","Cert. & Docu.","External Factors","","","","","Authorization received","2020-01-30","","Completed","2019-11-07","No","No","No","External"]
[null,null,null,null,null,"92_6/1/2020 10:33:24 AM","2019-11-03","Observation","Owner / Marine / Tech. Suptd.","Nav Audit / Verification","The dimmer switch for Anemometer repeater was found not working.","Navigation - Others","Navigation","Equipment Related",null,null,"Not Applicable","Not Applicable","To be rectified","2019-11-10",null,"Completed","2019-11-04","No",null,null,"Internal"]
[null,null,null,null,null,"92_6/1/2020 10:45:17 AM","2019-11-03","Observation","Owner / Marine / Tech. Suptd.","Nav Audit / Verification","The bollard pull for the tugs was not filled in the Master/Pilot Exchange card for the Port.","Documentation","Cert. & Docu.","Human Error",null,null,"Not Applicable","Not Applicable","To be doccumented for all ports","2019-11-10",null,"Completed","2019-11-03","No",null,null,"Internal"]
[null,null,null,null,null,"92_6/1/2020 10:47:17 AM","2019-11-03","Observation","Owner / Marine / Tech. Suptd.","Nav Audit / Verification","The AIS information had not been updated after arrival at Port.","Navigation - DGPS / EPFS / AIS","Navigation","Human Error",null,null,"Not Applicable","Not Applicable","To be updated at all times","2019-11-10",null,"Completed","2019-11-03","No",null,null,"Internal"]
[null,null,null,null,null,"92_21/11/2019 2:38:33 AM","2019-11-03","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Brake linings for the windlass appear to have thinned down.","Deck - Mooring Machinery","Mooring","Equipment Related",null,null,"Not Applicable","Not Applicable","Brake linings for the windlass are new,replaced in last DD.","2020-01-01",null,"Completed","2020-01-01","No",null,null,"Internal"]
[null,null,null,null,null,"92_6/1/2020 4:44:14 PM","2020-01-06","Defect","Ship Staff","Ship Staff Insp.","Emergency generator room water tight door rubber packing found damage","Deck - Pipe / Fittings","Structural Condn. / WT integrity ","Equipment Related",11.6,"Medium","Not Applicable","Not Applicable","Packing to be renewed.Rubber packing renewed.","2020-01-10",null,"Completed","2020-01-06","No",null,null,"Internal"]
[null,null,null,null,null,"92_20/11/2019 2:38:25 PM","2019-11-10","Defect","Ship Staff","Ship Staff Insp.","Cargo compressor temperature gauges not operational (Total :7 nos)","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",8.1300000000000008,"High","Not Applicable","Not Applicable","Requisition raised.Defective thermomters changed","2020-01-15","SATH190027","Completed","2020-01-14","No",null,null,"Internal"]
[null,null,null,null,null,"92_15/12/2019 6:59:30 PM","2019-11-02","Defect","Ship Staff","Ship Staff Insp.","Port side windlass brake lever found fully down","Deck - Mooring Machinery","Mooring","Equipment Related",9.1999999999999993,"Medium","Not Applicable","Not Applicable","Brake lever to be adjusted.Brake lever adjusted.","2020-01-15",null,"Completed","2020-01-15","No",null,null,"Internal"]
[null,null,null,null,null,"92_15/1/2020 4:29:57 PM","2020-01-09","Defect","Ship Staff","Ship Staff Insp.","Gas sampling point valves found stuck","Deck - Pipe / Fittings","Cargo / Ballast Systems","Equipment Related",5.21,"Medium","Not Applicable","Not Applicable","To be overhauled. Valves overhauled","2020-01-31",null,"Completed","2020-01-14","No",null,null,"Internal"]
[null,null,null,null,null,"92_15/1/2020 4:55:05 PM","2020-01-10","Defect","Ship Staff","Ship Staff Insp.","3 Deck Air valves handle found broken.","Deck - Pipe / Fittings","General Appearance","Equipment Related",null,null,"Not Applicable","Not Applicable","To be changed.All 3 deck air valves handle changed.","2020-01-31",null,"Completed","2020-01-15","No",null,null,"Internal"]
[null,null,null,null,null,"92_20/11/2019 2:29:25 PM","2019-11-10","Defect","Ship Staff","Ship Staff Insp.","Cargo compressor pressure gauges not operational (Total No 21)","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",8.1300000000000008,"High","Not Applicable","Not Applicable","Requisition raised.All defective gauges renewed","2020-01-15","SATH190027","Completed","2020-01-15","No",null,null,"Internal"]
[null,null,null,null,null,"92_21/11/2019 8:07:58 AM","2019-11-06","Defect","Ship Staff","Ship Staff Insp.","Sludge pump remote emergency stop on deck inoperational both port & stbd side","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Sludge pump remote emergency stop tested for operation, controlling card of starter found defective, same rectified & tried out, remote emergency stop on deck both port & stbd side found operational condition.","2019-12-31",null,"Completed","2020-01-05","No",null,null,"Internal"]
[null,null,null,null,null,"92_21/11/2019 8:05:39 AM","2019-11-06","Defect","Ship Staff","Ship Staff Insp.","Boiler water level controller found to be inoperational.","E/R - Boiler","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","DP transmitter checked & found to responding according to drum level, controller put in service, adjusted the opening & closing setting of the water controller, found to be responding accordingly. Operational.\r\n","2019-12-31",null,"Completed","2019-12-31","No",null,null,"Internal"]
[null,null,null,null,null,"92_21/11/2019 8:12:55 AM","2019-11-05","Defect","Ship Staff","Ship Staff Insp.","Boiler dump conroller for excess steam dumping to hot well inoperational.","E/R - Boiler","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Boiler dump conroller for excess steam dumping checked for operation, for same nozzel/flapper cleaned and calibration carried out by applying pressure from pressure calibrator, same put in use found in working condition.","2019-12-31",null,"Completed","2020-01-05","No",null,null,"Internal"]
[null,null,null,null,null,"92_21/11/2019 8:20:00 AM","2019-11-07","Defect","Ship Staff","Ship Staff Insp.","Steering gear no.1 runnig indication not displaying in the ECR panel even after replacing the bulb inside.","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Both steering gear lamps found inoperational, during testing it was found that new system fitted on board was not configured with these indication lamps, traced wire and both connected by laying additional wire, both found in working condition.","2019-12-31",null,"Completed","2020-01-15","No",null,null,"Internal"]
[null,null,null,null,null,"92_20/11/2019 7:21:47 PM","2019-11-05","Defect","Ship Staff","Ship Staff Insp.","Engine Telegraph Printer not working","Navigation - Others","Navigation","Equipment Related",null,null,"Not Applicable","Not Applicable","Opened the printer & checked the moving mechanism, found one belt defective & same rectified. Operational.\r\n","2019-12-31",null,"Completed","2019-12-20","No",null,null,"Internal"]
[null,null,null,null,null,"92_21/11/2019 3:28:21 AM","2019-11-06","Defect","Ship Staff","Ship Staff Insp.","Main engine jacket water controller found in inoperational condition.","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Checked the functioning, cleaned the nozzle & flapper & pneumatic chamber, calibrated using temperature calibrator. ALso valve spindle positioner block was drained of emulsified water in air & supply pressure adjusted.Funtional.\r\n","2019-12-31",null,"Completed","2019-12-30","No",null,null,"Internal"]
[null,null,null,null,null,"92_21/11/2019 3:54:29 AM","2019-11-13","Defect","Ship Staff","Ship Staff Insp.","Bilge pump found in inoperational condition","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Found the stator to have been worn out. The rotor was also found to have worn out at places near the end & also having cut marks on the surface, found operational.","2020-01-17",null,"Completed","2020-01-11","No",null,null,"Internal"]
[null,null,null,null,null,"92_20/11/2019 9:13:45 PM","2019-11-03","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Purifier room found very dirty","Miscellaneous","Eng. / Strg. Comp.","Inappropriate Procedure",null,null,"Not Applicable","Not Applicable","Chipping of the floor area being carried out for removal of excess paint. Cleaning & painting of the area carried out after completing the derusting & chipping.","2019-12-30",null,"Completed","2019-12-18","No",null,null,"Internal"]
[null,null,null,null,null,"92_21/11/2019 3:52:07 AM","2019-11-14","Defect","Ship Staff","Ship Staff Insp.","Sludge pump found unable to develop required pressure & flow rate is less.","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Sludge pump overhauled, replaced the guide shoes & the guide plates. Tried out. FOund functional. Put into use.","2019-12-31",null,"Completed","2019-12-29","No",null,null,"Internal"]
[null,null,null,null,null,"92_21/11/2019 8:26:06 AM","2019-11-09","Defect","Ship Staff","Ship Staff Insp.","FOund filters in the suction side of the Sludge pump, Incinerator pump, IG Deck seal pump to be missing & not in place after taking over.","E/R - Pipes/ valves & fittings,","Eng. / Strg. Comp.","Inappropriate Procedure",null,null,"Not Applicable","Not Applicable","Fabrication of the same being carried out & already replaced all the same. ","2020-01-15",null,"Completed","2020-01-07","No",null,null,"Internal"]
[null,null,null,null,null,"92_15/1/2020 11:06:17 PM","2019-11-25","Observation","Ship Staff","Nav Audit / Verification","SAT C NO 2 Showing an error of No Transceiver Connected  ","Navigation - GMDSS & Communication","Communication","Equipment Related",null,null,"Not Applicable","Not Applicable","Transceiver connection checked and fixed properly and verified same by Transceiver status on SAT c","2020-01-31",null,"Completed","2019-11-30","No",null,null,"Internal"]
[null,null,null,null,null,"92_15/1/2020 11:09:58 PM","2019-11-25","Observation","Ship Staff","Nav Audit / Verification","Off course alarm on Auto pilot found to be set on 15 degree","Navigation - Others","Navigation","Human Error",null,null,"Not Applicable","Not Applicable","Alarm value set to 3 degrees","2019-11-26",null,"Completed","2019-11-25","No",null,null,"Internal"]
[null,null,null,null,null,"92_15/1/2020 11:15:10 PM","2019-11-25","Observation","Ship Staff","Nav Audit / Verification","The USB cap for both ECDIS system found missing","Navigation - ECDIS","Navigation","Human Error",null,null,"Not Applicable","Not Applicable","USB cap inserted on ECDIS system","2019-11-30",null,"Completed","2019-11-25","No",null,null,"Internal"]
[null,null,null,null,null,"92_21/11/2019 8:10:23 AM","2019-11-06","Defect","Ship Staff","Ship Staff Insp.","M/E Unit no.3 JCW outlet temperature sensor inoperational showing flase reading.","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","   For same senor analouge unit disconnected but still it was showing same reading, changed defective channel card 3 of SAU 8810-7 from channel no.1 of SAU 8810-9, and tested for operation, found in working condition.","2020-01-28",null,"Completed","2020-01-25","No",null,null,"Internal"]
[null,null,null,null,null,"92_21/11/2019 8:16:42 AM","2019-11-06","Defect","Ship Staff","Ship Staff Insp.","A/E no.2 CFW outlet temperature sensor inoperational, showing faulty reading.","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable"," For same senor analouge unit disconnected but still it was showing same reading, changed defective channel card 9 of SAU 8810-9 from channel no.2 of SAU 8810-9, and tested for operation, found in working condition.","2020-02-04",null,"Completed","2020-01-24","No",null,null,"Internal"]
[null,null,null,null,null,"92_20/11/2019 7:23:55 PM","2019-11-06","Defect","Ship Staff","Ship Staff Insp.","No back up power for both X and S band Radars","Navigation - RADAR","Navigation","Equipment Related",null,null,"Not Applicable","Not Applicable","Both radar connected from emergency switchboard, so no need back-up power.","2020-01-26",null,"Completed","2020-01-24","No",null,null,"Internal"]
[null,null,null,null,null,"92_21/11/2019 3:31:45 AM","2019-11-06","Defect","Ship Staff","Ship Staff Insp.","No.2 main engine LO Purifier stm heater controller found in inoperational condition","E/R - Purifier","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Controller was not giving signal according to applied temperature, for same opened pneumatic chamber checked nozzel/flaper condition and cleaned. After that tested for operation found in working condition.","2020-01-24",null,"Completed","2020-01-21","No",null,null,"Internal"]
[null,null,null,null,null,"92_21/11/2019 3:34:25 AM","2019-11-08","Defect","Ship Staff","Ship Staff Insp.","No.1& 2 HFO Purifier steam heater controller found in inoperational condition.","E/R - Purifier","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Both HFO purifier heater controller calibration carried out by putting sensing bulb in temperature calibrator, found responding according sensing bulb signal, this controller taking signal from control panel.","2020-01-27",null,"Completed","2020-01-25","No",null,null,"Internal"]
[null,null,null,null,null,"92_21/11/2019 3:45:13 AM","2019-11-09","Defect","Ship Staff","Ship Staff Insp.","Main engine FO heater steam controller found in inoperational condition.","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","M/E FO heater controller valve tested for operation by applying small signal, found responding according applied signal, this valve taking signal from viscosity controller.","2020-01-31",null,"Completed","2020-01-24","No",null,null,"Internal"]
[null,null,null,null,null,"92_1/2/2020 11:40:22 AM","2020-01-23","Defect","Ship Staff","Ship Staff Insp.","Stbd side bunker hose handling davit slewing gear box found stuck.","Deck - Machinery","General Appearance","Equipment Related",8.5,null,"Not Applicable","Not Applicable","To be overhauled, Gear box overhauled and made free.","2020-02-15",null,"Completed","2020-01-30","No",null,null,"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]
["LSA / FFA Appliances",8]
["MARPOL Related",9]
["MLC Related",4]
["Mooring",12]
["Navigation",5]
["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":379,"n_cols":3,"rows_kept":379,"cut":false,"hidden":true,"merged":[]}
["VIQ_ref_no","Risk Value of observation","ID"]
["1.1","Low",10160]
["1.10","Low",10169]
["1.11","Low",10170]
["1.12","Low",10171]
["1.13","Low",10172]
["1.14","Low",10173]
["1.15","Low",10174]
["1.16","Low",10176]
["1.17","Low",10177]
["1.18","Low",10178]
["1.19","Low",10179]
["1.2","Low",10161]
["1.20","Low",10180]
["1.21","",10181]
["1.22","Low",10183]
["1.23","Low",10184]
["1.24","Low",10185]
["1.25","Low",10186]
["1.26","Low",10187]
["1.3","Low",10162]
["1.4","Low",10163]
["1.5","Low",10164]
["1.6","Low",10165]
["1.7","Low",10166]
["1.8","Low",10167]
["1.9","Low",10168]
["1.99","High",16296]
["10.1","Medium",10354]
["10.10","High",10363]
["10.11","Medium",10364]
["10.12","Very High",10365]
["10.13","Very High",10366]
["10.14","Medium",10367]
["10.15","Low",10368]
["10.16","Very High",10369]
["10.17","Very High",10370]
["10.18","High",10371]
["10.19","Very High",10372]
["10.2","Low",10355]
["10.20","High",10373]
["10.21","Medium",10374]
["10.22","Low",10375]
["10.23","Medium",10376]
["10.24","Low",10377]
["10.25","Very High",10378]
["10.26","High",10379]
["10.27","Medium",10380]
["10.28","Low",10381]
["10.29","Medium",10382]
["10.3","Medium",10356]
["10.30","High",10383]
["10.31","Very High",10384]
["10.32","Very High",10385]
["10.33","High",10386]
["10.34","High",10387]
["10.35","Very High",10388]
["10.36","Very High",10389]
["10.37","Medium",10390]
["10.38","Medium",10391]
["10.39","High",10392]
["10.4","High",10357]
["10.40","Medium",10393]
["10.41","Medium",10394]
["10.42","Medium",10395]
["10.43","Medium",10396]
["10.44","Medium",10397]
["10.45","Very High",10398]
["10.46","High",10399]
["10.47","Medium",10400]
["10.48","High",10401]
["10.49","Medium",10402]
["10.5","Low",10358]
["10.50","High",10403]
["10.51","Low",10404]
["10.52","Medium",10405]
["10.53","Medium",10406]
["10.54","High",10407]
["10.55","Low",10408]
["10.6","Very High",10359]
["10.7","Medium",10360]
["10.8","Medium",10361]
["10.9","Medium",10362]
["10.99","High",10409]
["11.1","High",10313]
["11.10","Medium",10322]
["11.11","Very High",10323]
["11.12","Low",10324]
["11.13","Low",10325]
["11.14","Medium",10326]
["11.15","Low",10327]
["11.16","Low",10328]
["11.17","Low",10329]
["11.2","Medium",10314]
["11.3","Medium",10315]
["11.4","Very High",10316]
["11.5","Medium",10317]
["11.6","Medium",10318]
["11.7","High",10319]
["11.8","Low",10320]
["11.9","Low",10321]
["11.99","High",10330]
["12.1","High",10331]
["12.10","High",10341]
["12.11","High",10342]
["12.12","High",10343]
["12.13","High",10344]
["12.14","High",10345]
["12.15","High",10346]
["12.16","High",10347]
["12.17","High",10348]
["12.18","High",10349]
["12.19","High",10350]
["12.2","High",10332]
["12.20","High",10351]
["12.21","High",10352]
["12.3","High",10334]
["12.4","High",10335]
["12.5","High",10336]
["12.6","High",10337]
["12.7","High",10338]
["12.8","High",10339]
["12.9","High",10340]
["12.99","High",10353]
["2.1","Very High",10190]
["2.1.9","Very High",16297]
["2.10","Medium",10198]
["2.11","Medium",10199]
["2.12","Low",10200]
["2.13","Low",10201]
["2.14","Low",10202]
["2.15","Low",10203]
["2.16","Medium",10204]
["2.2","Medium",10191]
["2.3","High",10189]
["2.4","Medium",10192]
["2.5","Medium",10193]
["2.6","Low",10194]
["2.7","High",10195]
["2.8","High",10196]
["2.9","Medium",10197]
["2.99","High",10205]
["3.1","High",10206]
["3.2","Very High",10207]
["3.3","High",10208]
["3.4","Low",10188]
["3.5","Medium",10209]
["3.6","High",10210]
["3.7","Very High",10211]
["3.8","Very High",10212]
["3.99","High",10213]
["4.1","High",10214]
["4.10","High",10223]
["4.11","Medium",10224]
["4.12","Very High",10225]
["4.13","Very High",10226]
["4.14","Very High",10227]
["4.15","Very High",10228]
["4.16","Very High",10229]
["4.17","Very High",10230]
["4.18","Very High",10231]
["4.19","Low",10232]
["4.2","Medium",10215]
["4.20","Very High",10233]
["4.21","High",10234]
["4.22","Low",10235]
["4.23","High",10236]
["4.24","High",10237]
["4.25","Low",10238]
["4.26","Low",10239]
["4.27","High",10240]
["4.3","Medium",10216]
["4.4","High",10217]
["4.5","Very High",10218]
["4.6","Medium",10219]
["4.7","High",10220]
["4.8","Medium",10221]
["4.9","Medium",10222]
["4.99","High",10241]
["5.1","Very High",10410]
["5.10","High",10419]
["5.11","Low",10420]
["5.12","Medium",10421]
["5.13","High",10422]
["5.14","Very High",10423]
["5.15","Medium",10424]
["5.16","Medium",10425]
["5.17","Very High",10426]
["5.18","High",10427]
["5.19","Medium",10428]
["5.2","Very High",10411]
["5.20","Medium",10429]
["5.21","Medium",10430]
["5.22","High",10432]
["5.23","Very High",10433]
["5.24","Very High",10434]
["5.25","Medium",10435]
["5.26","Medium",10436]
["5.27","Medium",10437]
["5.28","Very High",10438]
["5.29","High",10439]
["5.3","Low",10412]
["5.30","High",10440]
["5.31","High",10441]
["5.32","High",10442]
["5.33","High",10443]
["5.34","Low",10444]
["5.35","Medium",10445]
["5.36","Low",10446]
["5.37","Low",10447]
["5.38","High",10448]
["5.39","Very High",10449]
["5.4","High",10413]
["5.40","Very High",10450]
["5.41","Very High",10451]
["5.42","Medium",10452]
["5.43","High",10453]
["5.44","High",10454]
["5.45","Medium",10457]
["5.46","Medium",10458]
["5.47","Low",10459]
["5.48","Medium",10460]
["5.5","Low",10414]
["5.6","Low",10415]
["5.7","Medium",10416]
["5.8","Medium",10417]
["5.9","Very High",10418]
["5.99","High",10461]
["6.1","Medium",10242]
["6.10","Low",10251]
["6.11","High",10252]
["6.12","Medium",10253]
["6.13","Low",10254]
["6.14","High",10255]
["6.15","High",10256]
["6.16","Very High",10257]
["6.17","Very High",10258]
["6.18","Medium",10259]
["6.19","Low",10260]
["6.2","High",10243]
["6.20","Medium",10261]
["6.21","High",10262]
["6.22","Medium",10263]
["6.3","Low",10244]
["6.4","High",10245]
["6.5","Low",10246]
["6.6","Medium",10247]
["6.7","High",10248]
["6.8","High",10249]
["6.9","Low",10250]
["6.99","High",10264]
["7.1","High",10265]
["7.10","High",10274]
["7.11","High",10275]
["7.12","High",10276]
["7.13","Medium",10277]
["7.14","Medium",10278]
["7.15","High",10279]
["7.16","High",10280]
["7.17","High",10281]
["7.2","High",10266]
["7.3","Low",10267]
["7.4","Low",10268]
["7.5","Low",10269]
["7.6","Medium",10270]
["7.7","Low",10271]
["7.8","High",10272]
["7.9","High",10273]
["7.99","High",10282]
["8.1","Very High",10462]
["8.10","Very High",10471]
["8.11","Very High",10472]
["8.12","Medium",10473]
["8.13","High",10474]
["8.14","Very High",10475]
["8.15","Medium",10476]
["8.16","Medium",10477]
["8.17","Very High",10478]
["8.18","High",10479]
["8.19","Very High",10480]
["8.2","Medium",10463]
["8.20","Very High",10481]
["8.21","Very High",10482]
["8.22","High",10483]
["8.23","Medium",10484]
["8.24","High",10485]
["8.25","High",10486]
["8.26","Medium",10487]
["8.27","Medium",10488]
["8.28","High",10489]
["8.29","Medium",10491]
["8.3","Medium",10464]
["8.30","Very High",10492]
["8.31","Very High",10493]
["8.32","High",10494]
["8.33","High",10495]
["8.34","Very High",10496]
["8.35","Very High",10497]
["8.36","Very High",10498]
["8.37","Very High",10500]
["8.38","Very High",10501]
["8.39","Very High",10502]
["8.4","Medium",10465]
["8.40","Very High",10503]
["8.41","Very High",10504]
["8.42","Very High",10505]
["8.43","Very High",10506]
["8.44","Medium",10508]
["8.45","High",10509]
["8.46","High",10510]
["8.47","Medium",10511]
["8.48","Very High",10512]
["8.49","Medium",10513]
["8.5","Medium",10466]
["8.50","High",10514]
["8.51","Very High",10515]
["8.52","Very High",10516]
["8.53","Very High",10517]
["8.54","High",10518]
["8.55","High",16222]
["8.56","Very High",16223]
["8.57","Very High",16224]
["8.58","Very High",16225]
["8.59","Medium",16226]
["8.6","Very High",10467]
["8.60","Medium",16227]
["8.61","Medium",16228]
["8.62","Very High",16229]
["8.63","Very High",16230]
["8.64","High",16231]
["8.65","Very High",16232]
["8.66","Medium",16233]
["8.67","Medium",16234]
["8.68","Medium",16235]
["8.69","Very High",16236]
["8.7","High",10468]
["8.70","Very High",16237]
["8.71","Medium",16238]
["8.72","Very High",16239]
["8.73","Medium",16240]
["8.74","High",16241]
["8.75","High",16242]
["8.76","Medium",16243]
["8.77","Medium",16244]
["8.78","Medium",16245]
["8.79","Very High",16246]
["8.8","High",10469]
["8.9","Very High",10470]
["8.99","High",16266]
["9.1","Low",10283]
["9.10","Medium",10292]
["9.11","Medium",10293]
["9.12","Medium",10294]
["9.13","Low",10295]
["9.14","Medium",10296]
["9.15","Medium",10297]
["9.16","High",10298]
["9.17","High",10299]
["9.18","Low",10300]
["9.19","Low",10301]
["9.2","Very High",10284]
["9.20","Medium",10302]
["9.21","Medium",10303]
["9.22","Low",10304]
["9.23","Low",10305]
["9.24","Medium",10306]
["9.25","Low",10307]
["9.26","Low",10308]
["9.27","Low",10309]
["9.28","Medium",10310]
["9.29","Low",10311]
["9.3","Very High",10285]
["9.4","High",10286]
["9.5","High",10287]
["9.6","Low",10288]
["9.7","Medium",10289]
["9.8","Medium",10290]
["9.9","Medium",10291]
["9.99","High",10312]

{"sheet":"Equipment_list","index":7,"n_rows":27,"n_cols":3,"rows_kept":27,"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 - 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":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["TITLE","ID"]
["Bunkering Audit",14]
["Engineering Audit",16]
["ISM Audit",2]
["ISPS Audit",3]
["IT Audit",10]
["MLC Audit",1]
["Mooring Audit",9]
["Nav Audit / Verification",8]
["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"]
["92","ATHENA (27-12-2019)","92_1578048569620.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":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["TITLE","ID"]
["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"]