{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Legend","AnnualReport","ReportingTemplates","NonTemplateData","PhotoVideoFiles","ValidValues","ErrorChecker","Sheet1","Hide"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":15,"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":"Legend","index":0,"n_rows":71,"n_cols":7,"rows_kept":71,"cut":false,"hidden":false,"merged":[]}
["Legend of Metadata Template Fields"]
[]
["Worksheet","Field","Data Type","Definition","Valid Value Field","Required Field","Maximum Length of Entry"]
["AnnualReport","Contract ID","text","Contract ID data was collected under","Yes","Yes",15]
["AnnualReport","Contractual Year","text","The calendar year that the Annual Report is due. ",null,"Yes",4]
["AnnualReport","Annual Report Title","text","Descriptive title of the file submitted","","Yes","255"]
["AnnualReport","Abstract","text","Detailed description of the file submitted",null,"Yes",4000]
["AnnualReport","Report Date","date/time","Date of publication (only relevant for reports/documents).  ",null,"Yes","--"]
["AnnualReport","Zip File Name","text","Name of the zip file submitted. ",null,"Yes",120]
["AnnualReport","Report Contact Name","text","Name of contact for the file submitted.","","Yes",100]
["AnnualReport","Contact Organization","text","Organization affiliation for the contact for the file submitted.","","Yes",150]
["AnnualReport","Contact Telephone","text","Phone number of contact for the file submitted.","","Yes",25]
["AnnualReport","Contact Email","text","Email address of contact for the file submitted.",null,"Yes",100]
["AnnualReport","Language (Metadata)","text","Language used in the Metadata Template file.","Yes","Yes",15]
["AnnualReport","Language (Report)","text","Language used in the published Annual Report file. ","Yes","Yes",15]
["AnnualReport","Remarks","text","Other relevant information","",null,255]
["ReportingTemplates","Contract ID","text","Contract ID data was collected under","Yes","Yes",15]
["ReportingTemplates","Contractual Year","text","The calendar year that the Annual Report is due. ",null,"Yes",10]
["ReportingTemplates","Zip File Name","text","Name of the zip file submitted. ",null,"Yes",120]
["ReportingTemplates","Template Type","text","Indicates the Reporting Templates submitted;  if multiple Template Types are included in the zip file, include as a comma-delimited list.","Yes","Yes",100]
["ReportingTemplates","Template Contact Name","text","Name of contact for the file submitted.",null,"Yes",100]
["ReportingTemplates","Contact Organization","text","Organization affiliation for the contact for the file submitted.",null,"Yes",150]
["ReportingTemplates","Contact Telephone","text","Phone number of contact for the file submitted.",null,"Yes",25]
["ReportingTemplates","Contact Email","text","Email address of contact for the file submitted.",null,"Yes",100]
["ReportingTemplates","Language (Metadata)","text","Language used in the Metadata Template file.","Yes","Yes",10]
["ReportingTemplates","Remarks","text","Other relevant information",null,null,255]
["ReportingTemplates","Submited","date/time","Date File was submitted to Authority (dd-Mmm-yyyy)",null,"Yes",255]
[]
[]
[]
[]
[]
["ReportingTemplates","DOI","text","Digital Object Identifier of Record",null,null,255]
["NonTemplateData","Contract ID","text","Contract ID data was collected under","Yes","Yes",15]
["NonTemplateData","Contractual Year","text","The calendar year that the Annual Report is due. ",null,"Yes",10]
["NonTemplateData","Short Title of Dataset","text","Descriptive title of the file submitted","","Yes","255"]
["NonTemplateData","Description of Dataset","text","Detailed description of the file submitted",null,"Yes",4000]
["NonTemplateData","Theme","text","Standardized list of data types to be submitted by Contractors.","Yes","Yes",30]
["NonTemplateData","Zip File Name","text","Name of the zip file submitted. ",null,"Yes",120]
["NonTemplateData","Spatial Format","text","The format of spatial data submitted","Yes","Yes",15]
["NonTemplateData","Contact Name","text","Name of contact for the file submitted.",null,"Yes",100]
["NonTemplateData","Contact Organization","text","Organization affiliation for the contact for the file submitted.",null,"Yes",150]
["NonTemplateData","Contact Telephone","text","Phone number of contact for the file submitted.",null,"Yes",25]
["NonTemplateData","Contact Email","text","Email address of contact for the file submitted.",null,"Yes",100]
["NonTemplateData","Language (Metadata)","text","Language used in the Metadata Template file.","Yes","Yes",15]
["NonTemplateData","Remarks","text","Other relevant information",null,null,255]
["PhotoVideoFiles","Zip File Name","text","Name of the zip file submitted. ",null,"Yes",120]
["PhotoVideoFiles","VP File Name","text","Name of the individual photo/video file",null,"Yes",120]
["PhotoVideoFiles","Photo or Video","text","Indicate if the associated file is a photo or a video","Yes","Yes",10]
["PhotoVideoFiles","Short Title for Photo or Video File","text","Descriptive title of the photo/video file submitted","",null,250]
["PhotoVideoFiles","Description of Photo or Video","text","Detailed description of the photo/video file submitted",null,null,4000]
["PhotoVideoFiles","Associated Result","text","Indicates the table that includes the VPFileName (relevant for photos and videos only). ","Yes","Yes",25]
["PhotoVideoFiles","Station ID","text","StationID that the photo is associated with",null,null,"25"]
["PhotoVideoFiles","Tow ID","text","Trawl ID that video is associated with",null,null,"25"]
["PhotoVideoFiles","Sample ID","text","SampleID that photo is associated with",null,null,"25"]
["PhotoVideoFiles","OrgNum","numeric","Taxa ID that video is associated with",null,null,5]
["PhotoVideoFiles","Image Number","numeric","Arbitrary number assigned to differentiate samples/results with multiple associated images.",null,null,5]
["PhotoVideoFiles","Frame Code","text","Frame code that image is associated with",null,null,10]
["PhotoVideoFiles","Area of Image","numeric","Area of image taken with video/photo, in m2",null,null,50]
["PhotoVideoFiles","Height above Seafloor","text","Height above seafloor the image was taken, in meters ",null,null,25]
["PhotoVideoFiles","Camera Specs","text","Technical specifications of camera equipment (equipment used, resolution of image)",null,null,150]
["PhotoVideoFiles","Video/Photo Date/Time Stamp","date/time","Date/time stamp on video/photo as yyyy-mm-dd & hh:mm:ss.  For videos, enter the date/time of the start time.",null,null,"--"]
["PhotoVideoFiles","Confidential Status","text","Indicates if the file is confidential or available for public viewing. ","Yes","Yes",15]
["PhotoVideoFiles","Confidentiality Duration","text","In years",null,"Yes",15]
["PhotoVideoFiles","Remarks","text","Other relevant information",null,null,255]
["All Sheets","DOI","text","Digital Object Identifier or your internal unique identifier",null,null,150]
["All Sheets","DOI URL Resolver","text","e.g., https://doi.org/XXXXXX",null,null,255]
["All Sheets","Identifier type","text","DOI, Handle, UUID, ARK, ISA-ID, etc.",null,null,50]
["All Sheets","Identifier creation date","date/time","Date the DOI was created",null,null,50]
["All Sheets","Identifier status","text","Current status of the DOI (active, reserved, deprecated)",null,null,"--"]
[null,null,null,null,null,null,50]

{"sheet":"AnnualReport","index":1,"n_rows":3,"n_cols":18,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Contract ID","Contractual Year","Annual Report Title","Abstract","Report Date","Zip File Name","Report Contact Name","Contact Organization","Contact Telephone","Contact Email","Language (Metadata)","Language (Report)","Remarks","DOI","DOI URL Resolver","Identifier type","Identifier creation date","Identifier status"]
["See ValidValues",null,"",null,null,null,"","","",null,"See ValidValues","See ValidValues",""]
["Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required"]

{"sheet":"ReportingTemplates","index":2,"n_rows":3,"n_cols":16,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Contract ID","Contractual Year","Zip File Name","Template Type","Template Contact Name","Contact Organization","Contact Telephone","Contact Email","Language (Metadata)","Remarks","Submitted","DOI","DOI URL Resolver","Identifier type","Identifier creation date","Identifier status"]
["See ValidValues",null,null,"See ValidValues",null,null,null,null,"See ValidValues"]
["Required","Required","Required","Required","Required","Required","Required","Required","Required"]

{"sheet":"NonTemplateData","index":3,"n_rows":3,"n_cols":18,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Contract ID","Contractual Year","Short Title of Dataset","Description of Dataset","Theme","Zip File Name","Spatial Format","Contact Name","Contact Organization","Contact Telephone","Contact Email","Language (Metadata)","Remarks","DOI","DOI URL Resolver","Identifier type","Identifier creation date","Identifier status"]
["See ValidValues",null,"",null,"See ValidValues",null,"See ValidValues",null,null,null,null,"See ValidValues"]
["Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required"]

{"sheet":"PhotoVideoFiles","index":4,"n_rows":3,"n_cols":24,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Zip File Name","VP File Name","Photo or Video","Short Title for Photo or Video File","Description of Photo or Video","Associated Result","Station ID","Tow ID","Sample ID","OrgNum","Image Number","Frame Code","Area of Image","Height above Seafloor","Camera Specs","Video/Photo Date/Time Stamp","Confidential Status","Confidentiality Duration","Remarks","DOI","DOI URL Resolver","Identifier type","Identifier creation date","Identifier status"]
[null,null,"See ValidValues","",null,"See ValidValues",null,null,null,null,null,null,null,null,null,null,"See ValidValues"]
["Required","Required","Required",null,null,"Required",null,null,null,null,null,null,null,null,null,null,"Required","Required"]

{"sheet":"ValidValues","index":5,"n_rows":86,"n_cols":4,"rows_kept":86,"cut":false,"hidden":false,"merged":[]}
["Valid Values for Metadata Template columns with constrained entries"]
[]
["TemplateWorksheet","TemplateField","Value","Description"]
["Annual Report","Language (Report)","Arabic"]
["Annual Report","Language (Report)","Chinese"]
["Annual Report","Language (Report)","English"]
["Annual Report","Language (Report)","French"]
["Annual Report","Language (Report)","NA","Not applicable (language for data files not captured for files other than reports)"]
["Annual Report","Language (Report)","Russian"]
["Annual Report","Language (Report)","Spanish"]
["Multiple","Contract ID","BGRPMN1","Federal Institute for Geosciences and Natural Resources of Germany - PMN"]
["Multiple","Contract ID","BGRPMS1","Federal Institute for Geosciences and Natural Resources of Germany - PMS"]
["Multiple","Contract ID","BPHDCPMN1","Beijing Pioneer Hi-Tech Development Corporation - PMN"]
["Multiple","Contract ID","BRAZILCRFC1","Companhia de Pesquisa de Recursos Minerais S.A. - CRFC"]
["Multiple","Contract ID","CIICPMN1","Cook Islands Investment Corporation - PMN"]
["Multiple","Contract ID","CMMPMN1","China Minmetals Corporation - PMN"]
["Multiple","Contract ID","COMRACRFC1","China Ocean Mineral Resources Research and Development Association - CRFC"]
["Multiple","Contract ID","COMRAPMN1","China Ocean Mineral Resources Research and Development Association - PMN"]
["Multiple","Contract ID","COMRAPMS1","China Ocean Mineral Resources Research and Development Association - PMS"]
["Multiple","Contract ID","DORDPMN1","Deep Ocean Resources Development Co. Ltd. - PMN"]
["Multiple","Contract ID","GSRPMN1","Global Sea Mineral Resources NV - PMN"]
["Multiple","Contract ID","IFREMERPMN1","Institut français de recherche pour l'exploitation de la mer - PMN"]
["Multiple","Contract ID","IFREMERPMS1","Institut français de recherche pour l'exploitation de la mer - PMS"]
["Multiple","Contract ID","INDIAPMN1","Government of India - PMN"]
["Multiple","Contract ID","INDIAPMS1","Government of India - PMS"]
["Multiple","Contract ID","IOMPMN1","Interoceanmetal Joint Organization - PMN"]
["Multiple","Contract ID","JOGMECCRFC1","Japan Oil, Gas and Metals National Corporation - CRFC"]
["Multiple","Contract ID","KOREACRFC1","Government of the Republic of Korea - CRFC"]
["Multiple","Contract ID","KOREAPMN1","Government of the Republic of Korea - PMN"]
["Multiple","Contract ID","KOREAPMS1","Government of the Republic of Korea - PMS"]
["Multiple","Contract ID","MARAWAPMN1","Marawa Research and Exploration Ltd. - PMN"]
["Multiple","Contract ID","NORIPMN1","Nauru Ocean Resources Inc. - PMN"]
["Multiple","Contract ID","OMSPMN1","Ocean Mineral Singapore Pte. Ltd. - PMN"]
["Multiple","Contract ID","POLPMS1","Government of the Republic of Poland - PMS"]
["Multiple","Contract ID","RUSFEDPMS1","Government of the Russian Federation - PMS"]
["Multiple","Contract ID","RUSMNRCRFC1","Ministry of Natural resources and environment of the russian federation - CRFC"]
["Multiple","Contract ID","TOMLPMN1","Tonga Offshore Mining Limited - PMN"]
["Multiple","Contract ID","UKSRLPMN1","UK Seabed Resources Ltd. - I - PMN"]
["Multiple","Contract ID","UKSRLPMN2","UK Seabed Resources Ltd. - II - PMN"]
["Multiple","Contract ID","YUZHPMN1","Yuzhmorgeologiya - PMN"]
["Multiple","Language (Metadata)","Arabic"]
["Multiple","Language (Metadata)","Chinese"]
["Multiple","Language (Metadata)","English"]
["Multiple","Language (Metadata)","French"]
["Multiple","Language (Metadata)","Russian"]
["Multiple","Language (Metadata)","Spanish"]
["NonTemplateData","Spatial Format","NA","Not applicable"]
["NonTemplateData","Spatial Format","Raster","Image/Grid"]
["NonTemplateData","Spatial Format","Vector","Point/Line/Polygon"]
["NonTemplateData","Theme","Annual Reports","Annual reports (PDF, DOC, etc).  Enter in 'AnnualReport' worksheet of Metadata Template."]
["NonTemplateData","Theme","Application","Application for Exploration Contract. "]
["NonTemplateData","Theme","Application Extension Documents","Application for a contract extension and associated documents (e.g., approvals).  "]
["NonTemplateData","Theme","Bathymetry/Confidential","Confidential, processed bathymetric data as digital xyz files in the ASCII format or a common GIS format. The processing sequence must be fully described.  Enter in 'NonTemplateData' worksheet of Metadata Template."]
["NonTemplateData","Theme","Bathymetry/Public","Publicly-available, processed bathymetric data as digital xyz files in the ASCII format or a common GIS format. The processing sequence must be fully described.  Enter in 'NonTemplateData' worksheet of Metadata Template."]
["NonTemplateData","Theme","Contingency Plan","Contingency plan that details changes to the plan of work specified in the contract. "]
["NonTemplateData","Theme","Contract","Exploration Contract documents.   "]
["NonTemplateData","Theme","Correspondence","Any letters, memos and other written communication designated as confidential.  "]
["NonTemplateData","Theme","Current Meter","Flow measurements by mechanical (rotor current meter), tilt (Tilt Current Meter), acoustical (ADCP) or electrical means. Not required.  Enter in 'NonTemplateData' worksheet of Metadata Template."]
["NonTemplateData","Theme","Document/Non-Confidential","Non-confidential reports and documents (PDF, DOC, etc) that are not Annual Reports.  Enter in 'NonTemplateData' worksheet of Metadata Template."]
["NonTemplateData","Theme","Electric self-potential","Digital grids in a common GIS format.  Enter in 'NonTemplateData' worksheet of Metadata Template."]
["NonTemplateData","Theme","Electromagnetic","Digital grids in a common GIS format.  Enter in 'NonTemplateData' worksheet of Metadata Template."]
["NonTemplateData","Theme","Environmental Impact Statement","Reports and other documents associated with Environmental Impact Statements."]
["NonTemplateData","Theme","Financial Statements","Financial statements. "]
["NonTemplateData","Theme","Moored Sensor Data","In-situ data collected by moored sensor equipment (e.g., sediment traps, ADCP)."]
["NonTemplateData","Theme","Navigation","Electronic files with the coordinates of each of the following items: (i) Station locations; (ii) Multibeam, sonar and seismic track lines; (iii) Ship track.  Enter in 'NonTemplateData' worksheet of Metadata Template."]
["NonTemplateData","Theme","Noise","Ocean acoustic monitoring data. "]
["NonTemplateData","Theme","Photo_Video","High-resolution representative images (e.g., JPG, PDF, TIFF, etc.).  Enter in 'PhotoVideoFiles' worksheet of Metadata Template."]
["NonTemplateData","Theme","Programme of Activities","Programme of activities under the plan of work for exploration on the marine environment.  "]
["NonTemplateData","Theme","Raw data/Confidential","Uncategorized confidential raw data files."]
["NonTemplateData","Theme","Raw data/Public","Uncategorized public raw data files."]
["NonTemplateData","Theme","Reporting Template/Confidential","Unprocessed GEO template"]
["NonTemplateData","Theme","Reporting Template/Public","Unprocessed ENV template"]
["NonTemplateData","Theme","Sidescan_Seismic","Digital files (SEG-Y or XTF) and/or as high-resolution images (e.g., JPG, PDF, TIFF, etc.).  Enter in 'NonTemplateData' worksheet of Metadata Template."]
["NonTemplateData","Theme","Training Programme","Reports and other documents associated with the Contractor training programme."]
["PhotoVideoFiles","Photo or Video","Photo","Associated file is a photo"]
["PhotoVideoFiles","Photo or Video","Video","Associated file is a video"]
["PhotoVideoFiles","Associated Result","Individual - point","Photo of an organism taken from a point sample (e.g., grab sample)"]
["PhotoVideoFiles","Associated Result","Individual - towed gear","Frame from a video of an organism taken from a line sample (e.g., trawl) OR a photo of an organism taken from a line sample (e.g., trawl)"]
["PhotoVideoFiles","Associated Result","NA","Not applicable"]
["PhotoVideoFiles","Associated Result","Sample - point","Photo of a sample or other feature (e.g., seafloor) taken at a point location (e.g., grab)"]
["PhotoVideoFiles","Associated Result","Sample - towed gear","Video track"]
["PhotoVideoFiles","Confidential Status","Confidential","Confidential"]
["PhotoVideoFiles","Confidential Status","Public","Public"]
["ReportingTemplates","Template Type","Environmental"]
["ReportingTemplates","Template Type","Geological"]
["ReportingTemplates","Template Type","NA"]

{"sheet":"ErrorChecker","index":6,"n_rows":14,"n_cols":27,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rownum","Rownum"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Checker Report"]
[null,null,null,null,"Check Description","Ref #"]
[]
["Color codes:"]
["Green Text = Pass"]
["Red Text = Fail"]
["Yellow highlight = Pass (alert only)"]

{"sheet":"Sheet1","index":7,"n_rows":41,"n_cols":4,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
["TemplateWorksheet","TemplateField","Category","Value"]
["MT; Annual Report","Language (Report)","NA","Arabic"]
["MT; Annual Report","Language (Report)","NA","Chinese"]
["MT; Annual Report","Language (Report)","NA","English"]
["MT; Annual Report","Language (Report)","NA","French"]
["MT; Annual Report","Language (Report)","NA","NA"]
["MT; Annual Report","Language (Report)","NA","Russian"]
["MT; Annual Report","Language (Report)","NA","Spanish"]
["MT; AnnualReport; ReportingTemplates; NonTemplateData","Language (Metadata)","NA","Arabic"]
["MT; AnnualReport; ReportingTemplates; NonTemplateData","Language (Metadata)","NA","Chinese"]
["MT; AnnualReport; ReportingTemplates; NonTemplateData","Language (Metadata)","NA","English"]
["MT; AnnualReport; ReportingTemplates; NonTemplateData","Language (Metadata)","NA","French"]
["MT; AnnualReport; ReportingTemplates; NonTemplateData","Language (Metadata)","NA","Russian"]
["MT; AnnualReport; ReportingTemplates; NonTemplateData","Language (Metadata)","NA","Spanish"]
["MT; NonTemplateData","Spatial Format","NA","NA"]
["MT; NonTemplateData","Spatial Format","NA","Raster"]
["MT; NonTemplateData","Spatial Format","NA","Vector"]
["MT; NonTemplateData","Theme","NA","Annual Reports"]
["MT; NonTemplateData","Theme","NA","Bathymetry/Confidential"]
["MT; NonTemplateData","Theme","NA","Bathymetry/Public"]
["MT; NonTemplateData","Theme","NA","CTD_Water Quality"]
["MT; NonTemplateData","Theme","NA","Current Meter"]
["MT; NonTemplateData","Theme","NA","Document/Confidential"]
["MT; NonTemplateData","Theme","NA","Document/Non-Confidential"]
["MT; NonTemplateData","Theme","NA","Electric self-potential"]
["MT; NonTemplateData","Theme","NA","Electromagnetic"]
["MT; NonTemplateData","Theme","NA","Navigation"]
["MT; NonTemplateData","Theme","NA","Photo_Video"]
["MT; NonTemplateData","Theme","NA","Sidescan_Seismic"]
["MT; NonTemplateData","Theme","NA","Unprocessed Templates"]
["MT; NonTemplateData  ","Theme","NA","Noise"]
["MT; PhotoVideoFiles","Associated Result","NA","Individual - point"]
["MT; PhotoVideoFiles","Associated Result","NA","Individual - trawl"]
["MT; PhotoVideoFiles","Associated Result","NA","NA"]
["MT; PhotoVideoFiles","Associated Result","NA","Sample - point"]
["MT; PhotoVideoFiles","Associated Result","NA","Sample - trawl"]
["MT; PhotoVideoFiles","Confidential Status","NA","Confidential"]
["MT; PhotoVideoFiles","Confidential Status","NA","Public"]
["MT; ReportingTemplates","Template Type","NA","Environmental"]
["MT; ReportingTemplates","Template Type","NA","Geo/chem"]
["MT; ReportingTemplates","Template Type","NA","NA"]

{"sheet":"Hide","index":8,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[null,"Note: This is a hidden administrative worksheet. Sheet1 content is entered from a query on the MSSQL Server dicValidValues table.  "]
[]
[]
[]
[]
[]
[]
[null,null,"DM Valid Values Check Results:"]
[null,null,"Check DM Valid Values checked with DicValidValues Dictionary (Sheet1) - Passed"]