{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Hauptperson_Gruppe","Admin","Historie"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Hauptperson_Gruppe","index":0,"n_rows":9,"n_cols":18,"rows_kept":9,"cut":false,"hidden":false,"merged":[[3,1,3,15],[3,16,3,17],[2,3,2,10]]}
["hotelid","anrede","vorname","name","strasse","hausnummer","plz","ort","land","staatsang","persausweisnr","gebdatum","anreise","abreise","kategorie","email","kategorie","anzahl"]
[{"$f":"COLUMN()","v":1},{"$f":"COLUMN()","v":2},{"$f":"COLUMN()","v":3},{"$f":"COLUMN()","v":4},{"$f":"COLUMN()","v":5},{"$f":"COLUMN()","v":6},{"$f":"COLUMN()","v":7},{"$f":"COLUMN()","v":8},{"$f":"COLUMN()","v":9},{"$f":"COLUMN()","v":10},{"$f":"COLUMN()","v":11},{"$f":"COLUMN()","v":12},{"$f":"COLUMN()","v":13},{"$f":"COLUMN()","v":14},{"$f":"COLUMN()","v":15},{"$f":"COLUMN()","v":16},{"$f":"COLUMN()","v":17},{"$f":"COLUMN()","v":18}]
[null,null,"Hinweise:","Diese Excel-Datei muss von einem lokalen Laufwerk geöffnet werden (z.B. von C:).\nDie XML-Datei wird dann im gleichen Verzeichnis gespeichert, in dem auch diese Excel-Datei liegt.\nFarbig hervorgehobene Felder sind Pflichtfelder."]
["Objekt Nr.","Hauptperson",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gruppe"]
["hotelid","anrede","vorname","name","strasse","hausnummer","plz","ort","land","staatsang","persausweisnr","gebdatum","anreise","abreise","kategorie","email","kategorie_","anzahl"]
[null,"Frau","Claudia","Mustermann","Musterstr.","1","12345","Musterort","Schweiz",{"$f":"IF(ISBLANK(Tabelle1[[#This Row],[land]]),\"\",VLOOKUP(Tabelle1[[#This Row],[land]],tbl_Land[],2,FALSE))","v":"schweizerisch"},"A 3646456","1980-01-01","2024-11-20","2024-11-23",1,"maria.mustermann@musterstadt.de",3,5]
[null,"Frau","Claudia","Mustermann","Musterstr.","1","12345","Musterort","Schweiz","deutsch","A 3646456","1980-01-01","2024-11-20","2024-11-23",1,"maria.mustermann@musterstadt.de",2,3]
[null,"Frau","Claudia","Mustermann","Musterstr.","1","12345","Musterort","Schweiz",{"$f":"IF(ISBLANK(Tabelle1[[#This Row],[land]]),\"\",VLOOKUP(Tabelle1[[#This Row],[land]],tbl_Land[],2,FALSE))","v":"schweizerisch"},"A 3646456","1980-01-01","2024-11-20","2024-11-23",1,"maria.mustermann@musterstadt.de",1,4]
[null,"Frau","Claudia","Mustermann","Musterstr.","1","12345","Musterort","Schweiz",{"$f":"IF(ISBLANK(Tabelle1[[#This Row],[land]]),\"\",VLOOKUP(Tabelle1[[#This Row],[land]],tbl_Land[],2,FALSE))","v":"schweizerisch"},"A 3646456","1980-01-01","2024-11-20","2024-11-23",1,"maria.mustermann@musterstadt.de",1,4]

{"sheet":"Admin","index":1,"n_rows":277,"n_cols":4,"rows_kept":277,"cut":false,"hidden":false,"merged":[]}
[]
["Anrede",null,"Land","Staatsangehörigkeit"]
["Frau",null,"Afghanistan","afghanisch"]
["Herr",null,"Ägypten","ägyptisch"]
[null,null,"Åland","finnisch"]
[null,null,"Albanien","albanisch"]
[null,null,"Algerien","algerisch"]
[null,null,"Amerikanische Jungferninseln","amerikanisch"]
[null,null,"Amerikanisch-Samoa","amerikanisch"]
[null,null,"Andorra","andorranisch"]
[null,null,"Angola","angolanisch"]
[null,null,"Anguilla","britisch"]
[null,null,"Antarktika","sonstiges"]
[null,null,"Antigua und Barbuda","antiguanisch"]
[null,null,"Äquatorialguinea","äquatorialguineisch"]
[null,null,"Argentinien","argentinisch"]
[null,null,"Armenien","armenisch"]
[null,null,"Aruba","niederländisch"]
[null,null,"Ascension","britisch"]
[null,null,"Aserbaidschan","aserbaidschanisch"]
[null,null,"Äthiopien","äthiopisch"]
[null,null,"Australien","australisch"]
[null,null,"Bahamas","bahamaisch"]
[null,null,"Bahrain","bahrainisch"]
[null,null,"Bangladesch","bangladeschisch"]
[null,null,"Barbados","barbadisch"]
[null,null,"Belgien","belgisch"]
[null,null,"Belize","belizisch"]
[null,null,"Benin","beninisch"]
[null,null,"Bermuda","britisch"]
[null,null,"Bhutan","bhutanisch"]
[null,null,"Bolivien","bolivianisch"]
[null,null,"Bonaire, St. Eustatius und Saba","niederländisch"]
[null,null,"Bosnien und Herzegowina","bosnisch-herzegowinisch"]
[null,null,"Botswana","botsuanisch"]
[null,null,"Bouvetinsel","norwegisch"]
[null,null,"Brasilien","brasilianisch"]
[null,null,"Britische Jungferninseln","britisch"]
[null,null,"Britisches Territorium im Indischen Ozean","britisch"]
[null,null,"Brunei","bruneiisch"]
[null,null,"Bulgarien","bulgarisch"]
[null,null,"Burkina Faso","burkinisch"]
[null,null,"Burma","myanmarisch"]
[null,null,"Burundi","burundisch"]
[null,null,"Ceuta","spanisch"]
[null,null,"Chile","chilenisch"]
[null,null,"Clipperton","französisch"]
[null,null,"Cookinseln","neuseeländisch"]
[null,null,"Costa Rica","costa-ricanisch"]
[null,null,"Curaçao","niederländisch"]
[null,null,"Dänemark","dänisch"]
[null,null,"Demokratische Republik Kongo","kongolesisch"]
[null,null,"Deutschland","deutsch"]
[null,null,"Diego Garcia","britisch"]
[null,null,"Dominica","dominicanisch"]
[null,null,"Dominikanische Republik","dominikanisch"]
[null,null,"Dschibuti","dschibutisch"]
[null,null,"Ecuador","ecuadorianisch"]
[null,null,"ehemal. Jugoslawien","jugoslawisch"]
[null,null,"El Salvador","salvadorianisch"]
[null,null,"Elfenbeinküste","ivorisch"]
[null,null,"Eritrea","eritreisch"]
[null,null,"Estland","estnisch"]
[null,null,"Europäische Gemeinschaft","sonstiges"]
[null,null,"Europäische Union","sonstiges"]
[null,null,"Falklandinseln","britisch"]
[null,null,"Färöer","dänisch"]
[null,null,"Fidschi","fidschianisch"]
[null,null,"Finnland","finnisch"]
[null,null,"Frankreich","französisch"]
[null,null,"Frankreich (Übersee)","französisch"]
[null,null,"Französische Süd- und Antarktisgebiete","sonstiges"]
[null,null,"Französisch-Guayana","französisch"]
[null,null,"Französisch-Polynesien","französisch"]
[null,null,"Gabun","gabunisch"]
[null,null,"Gambia","gambisch"]
[null,null,"Georgien","georgisch"]
[null,null,"Ghana","ghanaisch"]
[null,null,"Gibraltar","britisch"]
[null,null,"Grenada","grenadisch"]
[null,null,"Griechenland","griechisch"]
[null,null,"Grönland","dänisch"]
[null,null,"Großbritannien","britisch"]
[null,null,"Guadeloupe","französisch"]
[null,null,"Guam","amerikanisch"]
[null,null,"Guatemala","guatemaltekisch"]
[null,null,"Guernsey","britisch"]
[null,null,"Guinea","guineisch"]
[null,null,"Guinea-Bissau","guinea-bissauisch"]
[null,null,"Guyana","guyanisch"]
[null,null,"Haiti","haitianisch"]
[null,null,"Heard und McDonaldinseln","australisch"]
[null,null,"Honduras","honduranisch"]
[null,null,"Hongkong","chinesisch"]
[null,null,"Indien","indisch"]
[null,null,"Indonesien","indonesisch"]
[null,null,"Insel Man","britisch"]
[null,null,"Irak","irakisch"]
[null,null,"Iran","iranisch"]
[null,null,"Irland","irisch"]
[null,null,"Island","isländisch"]
[null,null,"Israel","israelisch"]
[null,null,"Italien","italienisch"]
[null,null,"Jamaika","jamaikanisch"]
[null,null,"Japan","japanisch"]
[null,null,"Jemen","jemenitisch"]
[null,null,"Jersey","britisch"]
[null,null,"Jordanien","jordanisch"]
[null,null,"Kaimaninseln","britisch"]
[null,null,"Kambodscha","kambodschanisch"]
[null,null,"Kamerun","kamerunisch"]
[null,null,"Kanada","kanadisch"]
[null,null,"Kanarische Inseln","spanisch"]
[null,null,"Kap Verde","kapverdisch"]
[null,null,"Kasachstan","kasachisch"]
[null,null,"Katar","katarisch"]
[null,null,"Kenia","kenianisch"]
[null,null,"Kirgisistan","kirgisisch"]
[null,null,"Kiribati","kiribatisch"]
[null,null,"Kokosinseln","australisch"]
[null,null,"Kolumbien","kolumbianisch"]
[null,null,"Komoren","komorisch"]
[null,null,"Kongo","sonstiges"]
[null,null,"Kosovo","kosovarisch"]
[null,null,"Kroatien","kroatisch"]
[null,null,"Kuba","kubanisch"]
[null,null,"Kuwait","kuwaitisch"]
[null,null,"Laos","laotisch"]
[null,null,"Lesotho","lesothisch"]
[null,null,"Lettland","lettisch"]
[null,null,"Libanon","libanesisch"]
[null,null,"Liberia","liberianisch"]
[null,null,"Libyen","libysch"]
[null,null,"Liechtenstein","liechtensteinisch"]
[null,null,"Litauen","litauisch"]
[null,null,"Luxemburg","luxemburgisch"]
[null,null,"Macau","chinesisch"]
[null,null,"Madagaskar","madagassisch"]
[null,null,"Malawi","malawisch"]
[null,null,"Malaysia","malaysisch"]
[null,null,"Malediven","maledivisch"]
[null,null,"Mali","malisch"]
[null,null,"Malta","maltesisch"]
[null,null,"Marokko","marokkanisch"]
[null,null,"Marshallinseln","marshallisch"]
[null,null,"Martinique","französisch"]
[null,null,"Mauretanien","mauretanisch"]
[null,null,"Mauritius","mauritisch"]
[null,null,"Mayotte","französisch"]
[null,null,"Mazedonien","mazedonisch"]
[null,null,"Mexiko","mexikanisch"]
[null,null,"Mikronesien","mikronesisch"]
[null,null,"Mittelamerika/Karibik","mittelamerikanisch"]
[null,null,"Moldawien","moldauisch"]
[null,null,"Monaco","monegassisch"]
[null,null,"Mongolei","mongolisch"]
[null,null,"Montenegro","montenegrinisch"]
[null,null,"Montserrat","britisch"]
[null,null,"Mosambik","mosambikanisch"]
[null,null,"Myanmar","myanmarische"]
[null,null,"Namibia","namibisch"]
[null,null,"Nauru","nauruisch"]
[null,null,"Nepal","nepalesisch"]
[null,null,"Neukaledonien","französisch"]
[null,null,"Neuseeland","neuseeländisch"]
[null,null,"Neutrale Zone Saudi-Arabien/Irak","sonstiges"]
[null,null,"Nicaragua","nicaraguanisch"]
[null,null,"Niederlande","niederländisch"]
[null,null,"Niederländische Antillen","niederländisch"]
[null,null,"Niger","nigrisch"]
[null,null,"Nigeria","nigerianisch"]
[null,null,"Niue","neuseeländisch"]
[null,null,"Nordkorea","koreanisch"]
[null,null,"Nördliche Marianen","amerikanisch"]
[null,null,"Norfolkinsel","australisch"]
[null,null,"Norwegen","norwegisch"]
[null,null,"Oman","omanisch"]
[null,null,"Österreich","österreichisch"]
[null,null,"Osttimor","von Timor-Leste"]
[null,null,"Pakistan","pakistanisch"]
[null,null,"Palau","palauisch"]
[null,null,"Panama","panamaisch"]
[null,null,"Papua-Neuguinea","papua-neuguineisch"]
[null,null,"Paraguay","paraguayisch"]
[null,null,"Peru","peruanisch"]
[null,null,"Philippinen","philippinisch"]
[null,null,"Pitcairninseln","britisch"]
[null,null,"Polen","polnisch"]
[null,null,"Portugal","portugiesisch"]
[null,null,"Puerto Rico","amerikanisch"]
[null,null,"Republik Kongo","kongolesisch"]
[null,null,"Réunion","französisch"]
[null,null,"Ruanda","ruandisch"]
[null,null,"Rumänien","rumänisch"]
[null,null,"Russland","russisch"]
[null,null,"Saint-Barthélemy","französisch"]
[null,null,"Saint-Martin","französisch"]
[null,null,"Saint-Pierre und Miquelon","französisch"]
[null,null,"Salomonen","salomonisch"]
[null,null,"Sambia","sambisch"]
[null,null,"Samoa","samoanisch"]
[null,null,"San Marino","san-marinesisch"]
[null,null,"São Tomé und Príncipe","são-toméisch"]
[null,null,"Saudi-Arabien","saudi-arabisch"]
[null,null,"Schweden","schwedisch"]
[null,null,"Schweiz","schweizerisch"]
[null,null,"Senegal","senegalesisch"]
[null,null,"Serbien","serbisch"]
[null,null,"Serbien und Montenegro","serbisch-montenegrisch"]
[null,null,"Seychellen","seychellisch"]
[null,null,"Sierra Leone","sierra-leonisch"]
[null,null,"Simbabwe","simbabwisch"]
[null,null,"Singapur","singapurisch"]
[null,null,"Sint Maarten","niederländisch"]
[null,null,"Slowakei","slowakisch"]
[null,null,"Slowenien","slowenisch"]
[null,null,"Somalia","somalisch"]
[null,null,"Sonst. Nordamerika","nordamerikanisch"]
[null,null,"Sonst. Südamerika","südamerikanisch"]
[null,null,"Sonstige","sonstiges"]
[null,null,"Sonstiges Afrika","afrikanisch"]
[null,null,"Sonstiges Asien","asiatisch"]
[null,null,"Spanien","spanisch"]
[null,null,"Sri Lanka","sri-lankisch"]
[null,null,"St. Helena","britisch"]
[null,null,"St. Kitts und Nevis","von St. Kitts und Nevis"]
[null,null,"St. Lucia","lucianisch"]
[null,null,"St. Vincent und die Grenadinen","vincentisch"]
[null,null,"Staat Palästina","palästinensisch"]
[null,null,"Südafrika","südafrikanisch"]
[null,null,"Sudan","sudanesisch"]
[null,null,"Südgeorgien/ Südliche Sandwichinseln","britisch"]
[null,null,"Südkorea","koreanisch"]
[null,null,"Südostasien","asiatisch"]
[null,null,"Südsudan","südsudanesisch"]
[null,null,"Suriname","surinamisch"]
[null,null,"Svalbard und Jan Mayen","norwegisch"]
[null,null,"Swasiland","swasiländisch"]
[null,null,"Syrien","syrisch"]
[null,null,"Tadschikistan","tadschikisch"]
[null,null,"Taiwan","taiwanisch"]
[null,null,"Tansania","tansanisch"]
[null,null,"Thailand","thailändisch"]
[null,null,"Timor-Leste","von Timor-Leste"]
[null,null,"Togo","togoisch"]
[null,null,"Tokelau","neuseeländisch"]
[null,null,"Tonga","tongaisch"]
[null,null,"Trinidad und Tobago","von Trinidad und Tobago"]
[null,null,"Tristan da Cunha","britisch"]
[null,null,"Tschad","tschadisch"]
[null,null,"Tschechien","tschechisch"]
[null,null,"Tunesien","tunesisch"]
[null,null,"Türkei","türkisch"]
[null,null,"Turkmenistan","turkmenisch"]
[null,null,"Turks- und Caicosinseln","britisch"]
[null,null,"Tuvalu","tuvaluisch"]
[null,null,"übrige GUS","übrige GUS"]
[null,null,"UdSSR","russisch"]
[null,null,"Uganda","ugandisch"]
[null,null,"Ukraine","ukrainisch"]
[null,null,"Ungarn","ungarisch"]
[null,null,"United States Minor Outlying Islands","amerikanisch"]
[null,null,"Uruguay","uruguayisch"]
[null,null,"USA","amerikanisch"]
[null,null,"Usbekistan","usbekisch"]
[null,null,"Vanuatu","vanuatuisch"]
[null,null,"Vatikanstadt","vatikanisch"]
[null,null,"Venezuela","venezolanisch"]
[null,null,"Vereinigte Arabische Emirate","der Ver. Arab. Emirate"]
[null,null,"Vietnam","vietnamesisch"]
[null,null,"Volksrepublik China","chinesisch"]
[null,null,"Wallis und Futuna","französisch"]
[null,null,"Weihnachtsinsel","australisch"]
[null,null,"Weißrussland","weißrussisch"]
[null,null,"Westsahara","marokkanisch"]
[null,null,"Zentralafrikanische Republik","zentralafrikanisch"]
[null,null,"Zypern","zyprisch"]

{"sheet":"Historie","index":2,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Änderungen"]
[]
["Version","Datum","Bemerkung"]
["v1","2024-11-22","Initialversion"]
["v1.1","2024-12-03","Land als Pflichtfeld gekennzeichnet; Feld \"digit_gastkart\" entfernt"]