{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["README","General_Info","Collection","Bundles","Tabelle2","Tabelle1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"README","index":0,"n_rows":13,"n_cols":1,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,6],[9,0,9,6],[12,0,12,6],[2,0,2,6],[4,0,4,6],[5,0,5,6],[11,0,11,6],[6,0,6,6],[7,0,7,6],[8,0,8,6]]}
["README for LAC Metadata Excelsheets & forms"]
[]
["This sheet allows you to enter metadata in a way that lets us (the Language Archive Cologne) transform it into BLAM-Metadata needed for archiving with us."]
[]
["Fill in data manually"]
["To fill in data manually, simply navigate to the respective sheet (i.e. \"General_Info\", \"Collection\" or \"Bundle\").\nIn the sheet, tip text on what to fill in is provided beneath the respective label in blue color. \nIn the sheets you will use codes to identify creators, contributors and the project itself, these have to be specified in the General_Info sheet. "]
["How to (Step by step)"]
["First: Fill out General_Info. Here you enter recurring information that can be autofilled into the other tabs as needed.  E.g. all actors will be described here and then only referenced by their code in the other tabs. Please, enter your data starting with the column \"ObjectLanguageDisplayName\" (highlighted) and then continue on with the columns to the right. You add the data for the first creator in the first row and add new rows for each creator"]
["Second: Fill out the Collection. This will provide information for the top-level-node of your archive describing the collection as a whole. Please enter information starting in the column \"CollectionDisplayTitle\"."]
["Third: Fill out the Bundles. Here you will enter all the information about bundles of files that will be archived with us. Each bundle will consist of a metadata-description and one or more files (media-files, annotation-files). Start with column \"MetadataFilename\" and continue to fill out one row per bundle. Access-Rights (open, registration required and restricted) are specified in this sheet on bundle-level."]
[]
["Fill in data via user forms"]
["To use the user forms, simply click on the button in the left upper corner of the respective sheet (labeled \"To XY form\"). The user forms support tooltips, i.e. if you need help filling in data, simply hover your mouse pointer (without clicking) over the field of interest and a short help text will be displayed. In case you have to correct the data, please refer to the sheets and correct the faulty field manually. "]

{"sheet":"General_Info","index":1,"n_rows":13,"n_cols":28,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,6,0,9],[0,1,0,5],[0,10,0,20],[0,21,0,27]]}
[null,"Language",null,null,null,null,"Locations for Bundles ",null,null,null,"People Involved",null,null,null,null,null,null,null,null,null,null,"Project: Information about the project and funding"]
["Hints and tips on filling in data manually are displayed beneath the respective label in blue","ObjectLanguageDisplayName\n\nName to be displayed","ObjectLanguageName\n\nStandardized name from Glottolog","ObjectLanguageGlottologCode\n\nCode from Glottolog.org","TranslationLanguageName\n\nName to be displayed","TranslationLanguageCode\n\nCode from Glottolog.org","BundleLocationFacet\n\nLocation to be displayed","BundleGeoLocation\n\n","BundleRegionFacet\n\nRegion to be displayed","BundleCountryFacet\n\nCountry to be displayed","CreatorCode\n\nThis is a code that is only used within this sheet to autofill. You will use it on sheet Collection and Bundles.","CreatorNameIdentifier\n\nIdeally, add ORCID Number, else ISNI or if those don't exist email.","CreatorAffiliation\n\nOrganisation that creator is affiliated with.","CreatorFamilyName\n\nAdd persons that ought to be included in citation of dataset.","CreatorGivenName\n\nIf for some reason a person only has one name, include it in the field FamilyName. Again for reasons of creating a citation for the dataset.","ContributorCode\n\nThis is a code that is only used within this sheet to autofill. You will use it on sheet Collection and Bundles.","ContributorNameIdentifier\n\nContributors are further collaborators, not treated as authors with respect to quotation, references, and metadata display.","ContributorAffiliation\n\nOrganisation that contributor is affiliated with.","ContributorRole\n\ne.g. Speaker, Signer, Translator,…","ContributorFamilyName\n\nIf for some reason a person only has one name, include it in this field (FamilyName).","ContributorGivenName","ProjectCode\n\nThis is a code that is only used within this sheet to autofill. You will use it on sheet Collection and Bundles.","ProjectDisplayName\n\nProject name to be displayed","ProjectDescription\n\nDescription of Project","FunderName\n\ni.e. Funding agency","FunderIdentifier\n\nMay not be available","GrantIdentifier\n\nE.g. BMBF Förderkennzeichen. \nMay not be available.","GrantURI\n\nMay not be available"]
[]
[]
[]
[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,"","","","","","","","","",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,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,null,null,null,null,null,null,null,null,null,"","","","","","",""]
[null,"","","","","","","","","",null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]

{"sheet":"Collection","index":2,"n_rows":2,"n_cols":24,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,1,0,17],[0,18,0,23]]}
[null,"Collection Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Additional Metadata"]
["Hints and tips on filling in data manually are displayed beneath the respective label in blue","CollectionDisplayTitle\n\nThis will be displayed on the webpage, should be human readable, e.g. \"Documentation of the XY language\"","CollectionDescription\n\nAdd a description of the collection, free text.","CollectionKeyword\n\nAdd keywords, seperate with comma","ObjectLanguageDisplayName\n\nThis language name will be displayed on the webpage.","CollectionLocationFacet\n\nThis will place a dot on the map.","CollectionPublicationYear","CollectionDataProvider","CreatorCode\n\ni.e. the code specified in sheet General Info","ContributorCode\n\ni.e. the code specified in sheet General Info","ProjectCode","CollectionIsIdenticalTo\n\nIf Collection is archived elsewhere, this can be indicated here.","CollectionIsDerivationOf\n\nIf Collection is a derivation of a dataset archived elsewhere, this can be indicated here.","Access\n\nChoose access setting for the collection. BLAM-Metadata is always visible. ","LicenseName\n\ne.g. Creative Commons Attribution 4.0 International Public License","LicenseIdentifier","RightsHolderName\n\nDefault is PI of Project, if nothing is specified LAC is entered here.","RightsHolderIdentifier","FileName\n\nFileName of additional Metadata to be archived together with the collection. E.g. an Excel-Sheet with more detailed information, other metadata formats.","FileExtension","MimeType","IsMetadataFor\n\nDocumentation of the XY language","FileDescription","CollectionTopic\n\nCollectionTopics are used by repositories to display default subsets of bundles. Bundles are assigned to a topic if one of their BundleKeyword elements is identical to a topic label of the collection."]

{"sheet":"Bundles","index":3,"n_rows":13,"n_cols":188,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,141,0,145],[0,146,0,150],[0,151,0,155],[0,116,0,120],[0,121,0,125],[0,126,0,130],[0,131,0,135],[0,136,0,140],[0,49,0,52],[0,1,0,7],[0,9,0,10],[0,12,0,16],[0,17,0,20],[0,21,0,24],[0,25,0,28],[0,29,0,32],[0,33,0,36],[0,37,0,40],[0,41,0,44],[0,45,0,48],[0,186,0,187],[0,53,0,56],[0,57,0,60],[0,61,0,64],[0,65,0,68],[0,81,0,85],[0,86,0,90],[0,91,0,95],[0,96,0,100],[0,101,0,105],[0,106,0,110],[0,182,0,185],[0,69,0,72],[0,73,0,76],[0,77,0,80],[0,111,0,115]]}
[null,"General Info",null,null,null,null,null,null,"Location","Creator & Contributor",null,"Project","Annotation Info",null,null,null,null,"Access & Rights",null,null,null,"MediaFile1",null,null,null,"MediaFile2",null,null,null,"MediaFile3",null,null,null,"MediaFile4",null,null,null,"MediaFile5",null,null,null,"MediaFile6",null,null,null,"MediaFile7",null,null,null,"MediaFile8",null,null,null,"MediaFile9",null,null,null,"MediaFile10",null,null,null,"MediaFile11",null,null,null,"MediaFile12",null,null,null,"MediaFile13",null,null,null,"MediaFile14",null,null,null,"MediaFile15",null,null,null,"AnnotationFile1",null,null,null,null,"AnnotationFile2",null,null,null,null,"AnnotationFile3",null,null,null,null,"AnnotationFile4",null,null,null,null,"AnnotationFile5",null,null,null,null,"AnnotationFile6",null,null,null,null,"AnnotationFile7",null,null,null,null,"AnnotationFile8",null,null,null,null,"AnnotationFile9",null,null,null,null,"AnnotationFile10",null,null,null,null,"AnnotationFile11",null,null,null,null,"AnnotationFile12",null,null,null,null,"AnnotationFile13",null,null,null,null,"AnnotationFile14",null,null,null,null,"AnnotationFile15",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,null,null,null,null,null,"AdditionalMetadata",null,null,null,"OtherCopies"]
["BLAM\n\nHints and tips on filling in data manually are displayed beneath the respective label in blue","MetadataFileName\n\nFilename for the Metadata file. Can be identical to BundleDisplayTitle but using only ascii-characters (no spaces, no -, no special characters, e.g. ü,ß,é,...).","BundleDisplayTitle\n\nTitle that will be displayed online","BundleDescription\n\nAdd a short description for this bundle.","BundleKeyword\n\nKeywords: e.g. songs, conversation, … List them in one field with commas.","ObjectLanguageDisplayName\n\nLanguage name that will be displayed. If there is more than one language, list them in one field with commas.","BundleRecordingDate\n\nPlease specify date as follows: YYYY-MM-DD","BundlePublicationYear","BundleLocationFacet","CreatorCode","ContributorCode","ProjectCode","SegmentationUnit\n\nUnits in which the text is segmented, e.g. sentence, turn, intonation unit, paragraph.","TranscriptionType\n\nType of transcription: orthographic, phonemic,…","TranslationLanguageName\n\nLanguage of the translation.","TranslationLanguageCode\n\nGlottocode of translation language","AnnotationType\n\nType of annotation, e.g. word-by-word, POS-Tagging.","Access\n\nOptions: \"open\", \"registration required\" or \"restricted\"\n\nChoose access setting for the collection. BLAM-Metadata is always visible. ","LicenseName","RightsHolderName\n\nSpecify rightholder(s) here, PI would be an easy default, if this is empty \"LAC\" will be filled in as default","RightsHolderIdentifier\n\ne.g. ORCID, ISNI, Email, …","FileName","Extension","MimeType","FileDescription","FileName","Extension","MimeType","FileDescription","FileName","Extension","MimeType","FileDescription","FileName","Extension","MimeType","FileDescription","FileName","Extension","MimeType","FileDescription","FileName","Extension","MimeType","FileDescription","FileName","Extension","MimeType","FileDescription","FileName","Extension","MimeType","FileDescription","FileName","Extension","MimeType","FileDescription","FileName","Extension","MimeType","FileDescription","FileName","Extension","MimeType","FileDescription","FileName","Extension","MimeType","FileDescription","FileName","Extension","MimeType","FileDescription","FileName","Extension","MimeType","FileDescription","FileName","Extension","MimeType","FileDescription","FileName","Extension","MimeType","IsAnnotationOf","FileDescription","FileName","Extension","MimeType","IsAnnotationOf","FileDescription","FileName","Extension","MimeType","IsAnnotationOf","FileDescription","FileName","Extension","MimeType","IsAnnotationOf","FileDescription","FileName","Extension","MimeType","IsAnnotationOf","FileDescription","FileName","Extension","MimeType","IsAnnotationOf","FileDescription","FileName","Extension","MimeType","IsAnnotationOf","FileDescription","FileName","Extension","MimeType","IsAnnotationOf","FileDescription","FileName","Extension","MimeType","IsAnnotationOf","FileDescription","FileName","Extension","MimeType","IsAnnotationOf","FileDescription","FileName","Extension","MimeType","IsAnnotationOf","FileDescription","FileName","Extension","MimeType","IsAnnotationOf","FileDescription","FileName","Extension","MimeType","IsAnnotationOf","FileDescription","FileName","Extension","MimeType","IsAnnotationOf","FileDescription","FileName","Extension","MimeType","IsAnnotationOf","FileDescription",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,null,"FileName","Extension","IsMetadataFor","FileDescription","BundleIsIdenticalTo","BundleIsDerivationOf"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"","","","","","","","","",null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]

{"sheet":"Tabelle2","index":4,"n_rows":27,"n_cols":24,"rows_kept":27,"cut":false,"hidden":true,"merged":[[25,0,25,6],[25,8,25,9],[25,11,25,15],[25,16,25,19],[25,20,25,23]]}
[1]
[2]
[0,null,null,null,null,null,"YYYY-MM-DD",null,null,null,null,null,null,null,null,null,null,null,null,"LAC"]
[1,null,null,null,null,null,"YYYY-MM-DD",null,null,null,null,null,null,null,null,null,null,null,null,"LAC"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["General Info",null,null,null,null,null,null,"Location","Creator & Contributor",null,"Project","Annotation Info",null,null,null,null,"Access & Rights",null,null,null,"MediaFile1"]
["MetadataFileName","BundleDisplayTitle","BundleDescription","BundleKeyword","ObjectLanguageDisplayName","BundleRecordingDate","BundlePublicationYear","BundleLocationFacet","CreatorCode","ContributorCode","ProjectCode","SegmentationUnit","TranscriptionType","TranslationLanguageName","TranslationLanguageCode","AnnotationType","Access","LicenseName","RightsHolderName","RightsHolderIdentifier","FileName","Extension","MimeType","FileDescription"]

{"sheet":"Tabelle1","index":5,"n_rows":114,"n_cols":75,"rows_kept":114,"cut":false,"hidden":true,"merged":[]}
[".txt",".html",".pdf",".tr",".cha",".eaf",".pfsx",".sht",".tbt",".bpt",".lxk",".pri",".prx",".skp",".tag",".tig",".trs",".TextGrid",".txt",".html",".pdf",".txt",".html",".shx",".tbx",".cut",".lmf",".txt",".html",".typ",".lng",".set",".conf",".xml",".xsd",".dtd",".imdi",".kml",".wav",".aifc",".aiff",".mp3",".m4a",".mp2",".ogg",".mpg",".mpeg",".mp4",".mov",".avi",".smil",".jpg",".png",".tiff",".gif",".svg",".pdf",".html",".xls",".xlsx",null,".txt",".html",".pdf",".tr",".cha",".eaf",".pfsx",".sht",".tbt",".tig",".trs",".TextGrid",".odt",".ods"]
["text/plain","text/html","application/pdf","text/x-esf","text/x-chat","text/x-eaf+xml","text/x-pfsx+xml","text/x-shoebox-text","text/x-toolbox-text","text/x-cgn-bpt+xml","text/x-cgn-lxk+xml","text/x-cgn-pri+xml","text/x-cgn-prx+xml","text/x-cgn-skp+xml","text/x-cgn-tag+xml","text/x-cgn-tig+xml","text/x-trs","text/praat-textgrid","text/plain","text/html","application/pdf","text/plain","text/html","text/x-shoebox-lexicon","text/x-toolbox-lexicon","text/x-cut","text/x-lmf+xml","text/plain","text/html","text/x-shoebox-type","text/x-shoebox-language","Text/x-shoebox-sortorder","text/x-lexus-config+xml","text/xml","text/xml","text/xml","text/x-imdi+xml","application/vnd.google-earth.kml+xml","audio/x-wav","audio/x-aifc","audio/x-aifc","audio/x-mp3","audio/mp4","audio/x-mp2","application/ogg","video/x-mpeg1","video/x-mpeg2","video/mp4","video/quicktime","video/x-msvideo","application/smil+xml","image/jpeg","image/png","image/tiff","image/gif","image/svg+xml","application/pdf","text/html","application/msexcel","application/msexcel",null,"text/plain","text/html","application/pdf","text/x-esf","text/x-chat","text/x-eaf+xml","text/x-pfsx+xml","text/x-shoebox-text","text/x-toolbox-text","text/x-cgn-tig+xml","text/x-trs","text/praat-textgrid","application/vnd.oasis.opendocument.text","application/vnd.oasis.opendocument.spreadsheet"]
[]
[]
[]
[]
[]
[]
[]
["BLAM"]
["MetadataFileName"]
["BundleDisplayTitle"]
["BundleDescription"]
["BundleKeyword"]
["ObjectLanguageDisplayName"]
["BundleRecordingDate"]
["BundlePublicationYear"]
["BundleLocationFacet"]
["CreatorCode"]
["ContributorCode"]
["ProjectCode"]
["SegmentationUnit"]
["TranscriptionType"]
["TranslationLanguageName"]
["TranslationLanguageCode"]
["AnnotationType"]
["Access"]
["LicenseName"]
["RightsHolderName"]
["RightsHolderIdentifier"]
["FileName"]
["Extension"]
["MimeType"]
["FileDescription"]
["FileName"]
["Extension"]
["MimeType"]
["FileDescription"]
["FileName"]
["Extension"]
["MimeType"]
["FileDescription"]
["FileName"]
["Extension"]
["MimeType"]
["FileDescription"]
["FileName"]
["Extension"]
["MimeType"]
["FileDescription"]
["FileName"]
["Extension"]
["MimeType"]
["FileDescription"]
["FileName"]
["Extension"]
["MimeType"]
["FileDescription"]
["FileName"]
["Extension"]
["MimeType"]
["FileDescription"]
["FileName"]
["Extension"]
["MimeType"]
["FileDescription"]
["FileName"]
["Extension"]
["MimeType"]
["FileDescription"]
["FileName"]
["Extension"]
["MimeType"]
["FileDescription"]
["FileName"]
["Extension"]
["MimeType"]
["FileDescription"]
["FileName"]
["Extension"]
["MimeType"]
["IsAnnotationOf"]
["FileDescription"]
["FileName"]
["Extension"]
["MimeType"]
["IsAnnotationOf"]
["FileDescription"]
["FileName"]
["Extension"]
["MimeType"]
["IsAnnotationOf"]
["FileDescription"]
["FileName"]
["Extension"]
["MimeType"]
["IsAnnotationOf"]
["FileDescription"]
["FileName"]
["Extension"]
["MimeType"]
["IsAnnotationOf"]
["FileDescription"]
["FileName"]
["Extension"]
["MimeType"]
["IsAnnotationOf"]
["FileDescription"]
["FileName"]
["Extension"]
["IsMetadataFor"]
["FileDescription"]
["BundleIsIdenticalTo"]
["BundleIsDerivationOf"]