{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["START","Auftraege","UEFA","Staaten","Europa","Mitarbeiter","Vokabelheft","ActiveX","RangeTest","Aufgaben","Projektleiter","Umsatz 2017","M-Code"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":5,"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":"START","index":0,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,"In dieser Arbeitsmappe finden Sie alle 150 Makros, die in diesem Buch vorgestellt werden."]
[]
[null,null,null,null,null,"Schalten Sie um auf den Visual Basic Editor und sehen Sie sich die Eigenschaften des Projekts an. Wie das geht, lesen Sie auf Seite 364."]
[]
[null,null,null,null,null,"Zum Bearbeiten der Makros geben Sie das Passwort ein. Verwenden Sie dazu den Namen des Makros Nummer 43 (ohne Klammern)"]
[null,null,null,null,null,"Blenden Sie dann alle Tabellenblätter über deren Eigenschaft <Visible> ein."]
[]
[null,null,null,null,null,"Viel Spaß!"]
[]
[null,null,null,null,null,"Ihr Autor"]
[null,null,null,null,null,"Ignatz Schels*"]
[]
[null,null,null,null,null,"*Bitte beachten Sie, dass Verlag und Autor keinerlei Hilfestellung zu den Makros geben können."]
[]
[]
[]
[]
[]
[null,"aktualisiert auf Office 64 Bit"]

{"sheet":"Auftraege","index":1,"n_rows":130,"n_cols":5,"rows_kept":130,"cut":false,"hidden":true,"merged":[]}
["Datum","Produktsegment","Auftragsvolumen","Status","Kunde"]
["2018-01-07","Wertpapiere",160000,"erteilt","1220-07"]
["2018-01-10","Immobilien",68000,"erteilt","1220-28"]
["2018-01-21","Versicherungen",90000,"erteilt","1220-01"]
["2018-01-25","Wertpapiere",113000,"Anfrage","1220-12"]
["2018-01-25","Versicherungen",65000,"erteilt","1220-03"]
["2018-01-27","Immobilien",32000,"erteilt","1220-25"]
["2018-01-29","Versicherungen",137000,"erteilt","1220-22"]
["2018-02-03","Wertpapiere",91000,"Anfrage","1220-09"]
["2018-02-05","Versicherungen",143000,"erteilt","1220-30"]
["2018-02-11","Wertpapiere",113000,"Anfrage","1220-02"]
["2018-02-13","Wertpapiere",55000,"erteilt","1220-13"]
["2018-02-15","Sonstiges",69000,"erteilt","1220-19"]
["2018-02-19","Immobilien",68000,"erteilt","1220-33"]
["2018-02-28","Immobilien",46000,"Angebot abgegeben","1220-34"]
["2018-02-28","Versicherungen",143000,"erteilt","1220-26"]
["2018-03-03","Versicherungen",137000,"Anfrage","1220-06"]
["2018-03-05","Sonstiges",140000,"Angebot abgegeben","1220-27"]
["2018-03-06","Immobilien",72000,"erteilt","1220-08"]
["2018-03-08","Versicherungen",137000,"Anfrage","1220-35"]
["2018-03-12","Immobilien",118000,"Angebot abgegeben","1220-05"]
["2018-03-13","Versicherungen",143000,"erteilt","1220-15"]
["2018-03-16","Wertpapiere",55000,"erteilt","1220-21"]
["2018-03-20","Versicherungen",21000,"erteilt","1220-14"]
["2018-03-31","Wertpapiere",148000,"erteilt","1220-11"]
["2018-04-03","Immobilien",32000,"erteilt","1220-31"]
["2018-04-08","Wertpapiere",148000,"erteilt","1220-32"]
["2018-04-08","Versicherungen",119000,"Anfrage","1220-17"]
["2018-04-11","Versicherungen",21000,"erteilt","1220-18"]
["2018-04-13","Versicherungen",137000,"Anfrage","1220-30"]
["2018-04-14","Versicherungen",21000,"erteilt","1220-02"]
["2018-04-15","Versicherungen",137000,"Anfrage","1220-13"]
["2018-04-21","Wertpapiere",148000,"erteilt","1220-19"]
["2018-04-25","Wertpapiere",146000,"erteilt","1220-33"]
["2018-04-26","Sonstiges",69000,"erteilt","1220-34"]
["2018-04-28","Versicherungen",137000,"Anfrage","1220-26"]
["2018-04-28","Immobilien",68000,"erteilt","1220-06"]
["2018-04-30","Versicherungen",104000,"Angebot abgegeben","1220-27"]
["2018-04-30","Versicherungen",104000,"Angebot abgegeben","1220-08"]
["2018-05-01","Versicherungen",143000,"erteilt","1220-35"]
["2018-05-02","Immobilien",72000,"erteilt","1220-05"]
["2018-05-03","Immobilien",118000,"Angebot abgegeben","1220-15"]
["2018-05-04","Versicherungen",30000,"erteilt","1220-21"]
["2018-05-04","Versicherungen",137000,"erteilt","1220-14"]
["2018-05-09","Versicherungen",65000,"erteilt","1220-11"]
["2018-05-10","Versicherungen",137000,"erteilt","1220-22"]
["2018-05-20","Wertpapiere",146000,"erteilt","1220-09"]
["2018-05-21","Wertpapiere",107000,"erteilt","1220-30"]
["2018-05-22","Wertpapiere",55000,"erteilt","1220-02"]
["2018-05-26","Wertpapiere",55000,"erteilt","1220-13"]
["2018-05-30","Wertpapiere",55000,"erteilt","1220-19"]
["2018-06-07","Versicherungen",119000,"Anfrage","1220-33"]
["2018-06-08","Wertpapiere",91000,"Anfrage","1220-34"]
["2018-06-10","Versicherungen",119000,"Anfrage","1220-26"]
["2018-06-13","Versicherungen",65000,"erteilt","1220-06"]
["2018-06-25","Versicherungen",119000,"Anfrage","1220-27"]
["2018-06-30","Immobilien",32000,"erteilt","1220-08"]
["2018-07-01","Versicherungen",104000,"Angebot abgegeben","1220-35"]
["2018-07-06","Immobilien",46000,"Angebot abgegeben","1220-05"]
["2018-07-10","Wertpapiere",146000,"erteilt","1220-15"]
["2018-07-12","Wertpapiere",107000,"erteilt","1220-21"]
["2018-07-16","Versicherungen",21000,"erteilt","1220-14"]
["2018-07-28","Versicherungen",143000,"erteilt","1220-11"]
["2018-08-12","Versicherungen",65000,"erteilt","1220-31"]
["2018-08-12","Versicherungen",104000,"Angebot abgegeben","1220-32"]
["2018-08-13","Sonstiges",140000,"Angebot abgegeben","1220-17"]
["2018-08-15","Versicherungen",119000,"Anfrage","1220-18"]
["2018-08-18","Versicherungen",137000,"erteilt","1220-30"]
["2018-08-18","Versicherungen",90000,"erteilt","1220-02"]
["2018-08-21","Immobilien",46000,"Angebot abgegeben","1220-13"]
["2018-08-23","Versicherungen",1090000,"erteilt","1220-19"]
["2018-08-23","Immobilien",118000,"Angebot abgegeben","1220-33"]
["2018-08-24","Versicherungen",90000,"erteilt","1220-34"]
["2018-08-29","Sonstiges",140000,"Angebot abgegeben","1220-26"]
["2018-09-01","Wertpapiere",146000,"erteilt","1220-06"]
["2018-09-01","Versicherungen",104000,"Angebot abgegeben","1220-07"]
["2018-09-02","Sonstiges",140000,"Angebot abgegeben","1220-28"]
["2018-09-05","Wertpapiere",107000,"erteilt","1220-01"]
["2018-09-10","Versicherungen",30000,"erteilt","1220-12"]
["2018-09-11","Immobilien",32000,"erteilt","1220-03"]
["2018-09-14","Wertpapiere",124000,"erteilt","1220-25"]
["2018-09-17","Versicherungen",90000,"erteilt","1220-22"]
["2018-09-20","Wertpapiere",113000,"Anfrage","1220-09"]
["2018-09-24","Immobilien",118000,"Angebot abgegeben","1220-30"]
["2018-09-24","Versicherungen",65000,"erteilt","1220-02"]
["2018-09-26","Versicherungen",90000,"erteilt","1220-13"]
["2018-09-27","Wertpapiere",91000,"Anfrage","1220-19"]
["2018-10-01","Versicherungen",30000,"erteilt","1220-33"]
["2018-10-05","Wertpapiere",91000,"Anfrage","1220-34"]
["2018-10-07","Wertpapiere",107000,"erteilt","1220-26"]
["2018-10-12","Versicherungen",21000,"erteilt","1220-06"]
["2018-10-13","Immobilien",72000,"erteilt","1220-27"]
["2018-10-19","Versicherungen",137000,"erteilt","1220-08"]
["2018-10-20","Wertpapiere",91000,"Anfrage","1220-35"]
["2018-10-22","Versicherungen",119000,"Anfrage","1220-05"]
["2018-10-29","Versicherungen",137000,"Anfrage","1220-15"]
["2018-11-07","Wertpapiere",148000,"erteilt","1220-21"]
["2018-11-07","Versicherungen",65000,"erteilt","1220-14"]
["2018-11-08","Versicherungen",137000,"Anfrage","1220-11"]
["2018-11-08","Versicherungen",143000,"erteilt","1220-31"]
["2018-11-10","Sonstiges",69000,"erteilt","1220-32"]
["2018-11-11","Wertpapiere",113000,"Anfrage","1220-17"]
["2018-11-11","Versicherungen",30000,"erteilt","1220-18"]
["2018-11-12","Versicherungen",119000,"Anfrage","1220-30"]
["2018-11-12","Wertpapiere",146000,"erteilt","1220-02"]
["2018-11-18","Versicherungen",30000,"erteilt","1220-13"]
["2018-11-20","Immobilien",46000,"Angebot abgegeben","1220-19"]
["2018-11-21","Versicherungen",30000,"erteilt","1220-33"]
["2018-11-22","Wertpapiere",55000,"erteilt","1220-34"]
["2018-11-30","Versicherungen",65000,"erteilt","1220-26"]
["2018-12-02","Versicherungen",137000,"erteilt","1220-06"]
["2018-12-02","Immobilien",72000,"erteilt","1220-27"]
["2018-12-03","Wertpapiere",107000,"erteilt","1220-08"]
["2018-12-05","Wertpapiere",113000,"Anfrage","1220-35"]
["2018-12-06","Immobilien",68000,"erteilt","1220-05"]
["2018-12-07","Sonstiges",69000,"erteilt","1220-15"]
["2018-12-14","Versicherungen",90000,"erteilt","1220-21"]
["2018-12-15","Immobilien",72000,"erteilt","1220-14"]
["2018-12-16","Immobilien",118000,"Angebot abgegeben","1220-11"]
["2018-12-19","Wertpapiere",55000,"erteilt","1220-22"]
["2018-12-02","Versicherungen",137000,"erteilt","1220-06"]
["2018-12-02","Immobilien",72000,"erteilt","1220-27"]
["2018-12-03","Wertpapiere",107000,"erteilt","1220-08"]
["2018-12-05","Wertpapiere",113000,"Anfrage","1220-35"]
["2018-12-06","Immobilien",68000,"erteilt","1220-05"]
["2018-12-07","Sonstiges",69000,"erteilt","1220-15"]
["2018-12-14","Versicherungen",90000,"erteilt","1220-21"]
["2018-12-15","Immobilien",72000,"erteilt","1220-14"]
["2018-12-16","Immobilien",118000,"Angebot abgegeben","1220-11"]
["2018-12-19","Wertpapiere",55000,"erteilt","1220-22"]

{"sheet":"UEFA","index":2,"n_rows":65,"n_cols":12,"rows_kept":65,"cut":false,"hidden":true,"merged":[]}
["Saison","Stadion","Stadt","Sieger","Ergebnis","Finalist",null,null,null,null,null,"Makro 85"]
[1955,"Prinzenpark","Paris","Real Madrid","4:3","Stade Reims"]
[1956,"Estadio Santiago Bernabéu","Madrid","Real Madrid","2:0","AC Florenz"]
[1957,"Heysel-Stadion","Brüssel","Real Madrid","3:2 n.V.","AC Mailand"]
[1958,"Neckarstadion","Stuttgart","Real Madrid","2:0","Stade Reims"]
[1959,"Hampden Park","Glasgow","Real Madrid","7:3","Eintracht Frankfurt"]
[1960,"Wankdorfstadion","Bern","Benfica Lissabon","3:2","FC Barcelona"]
[1961,"Olympiastadion","Amsterdam","Benfica Lissabon","5:3","Real Madrid"]
[1962,"Wembley-Stadion","London","AC Mailand","2:1","Benfica Lissabon"]
[1963,"Praterstadion","Wien","Inter Mailand","3:1","Real Madrid"]
[1964,"San Siro","Mailand","Inter Mailand","1:0","Benfica Lissabon"]
[1965,"Heysel-Stadion","Brüssel","Real Madrid","2:1","Partizan Belgrad"]
[1966,"Estádio Nacional","Lissabon","Celtic Glasgow","2:1","Inter Mailand"]
[1967,"Wembley-Stadion","London","Manchester United","4:1 n.V.","Benfica Lissabon"]
[1968,"Estadio Santiago Bernabéu","Madrid","AC Mailand","4:1","Ajax Amsterdam"]
[1969,"San Siro","Mailand","Feyenoord Rotterdam","2:1 n.V.","Celtic Glasgow"]
[1970,"Wembley-Stadion","London","Ajax Amsterdam","2:0","Panathinaikos Athen"]
[1971,"De Kuip","Rotterdam","Ajax Amsterdam","2:0","Inter Mailand"]
[1972,"Stadion Roter Stern","Belgrad","Ajax Amsterdam","1:0","Juventus Turin"]
[1973,"Heysel-Stadion","Brüssel","FC Bayern München","1:1 n.V. / 4:0","Atlético Madrid"]
[1974,"Prinzenpark","Paris","FC Bayern München","2:0","Leeds United"]
[1975,"Hampden Park","Glasgow","FC Bayern München","1:0","AS Saint-Étienne"]
[1976,"Olympiastadion","Rom","FC Liverpool","3:1","Borussia Mönchengladbach"]
[1977,"Wembley-Stadion","London","FC Liverpool","1:0","FC Brügge"]
[1978,"Olympiastadion","München","Nottingham Forest","1:0","Malmö FF"]
[1979,"Estadio Santiago Bernabéu","Madrid","Nottingham Forest","1:0","Hamburger SV"]
[1980,"Prinzenpark","Paris","FC Liverpool","1:0","Real Madrid"]
[1981,"De Kuip","Rotterdam","Aston Villa","1:0","FC Bayern München"]
[1982,"Olympiastadion","Athen","Hamburger SV","1:0","Juventus Turin"]
[1983,"Olympiastadion","Rom","FC Liverpool","1:1 n.V. / 4:2 i.E.","AS Rom"]
[1984,"Heysel-Stadion","Brüssel","Juventus Turin","1:0","FC Liverpool"]
[1985,"Estadio Ramón Sánchez Pizjuán","Sevilla","Steaua Bukarest","0:0 n.V. / 2:0 i.E.","FC Barcelona"]
[1986,"Praterstadion","Wien","FC Porto","2:1","FC Bayern München"]
[1987,"Neckarstadion","Stuttgart","PSV Eindhoven","0:0 n.V. / 6:5 i.E.","Benfica Lissabon"]
[1988,"Camp Nou","Barcelona","AC Mailand","4:0","Steaua Bukarest"]
[1989,"Praterstadion","Wien","AC Mailand","1:0","Benfica Lissabon"]
[1990,"Stadio San Nicola","Bari","Roter Stern Belgrad","0:0 n.V. / 5:3 i.E.","Olympique Marseille"]
[1991,"Wembley-Stadion","London","FC Barcelona","1:0 n.V.","Sampdoria Genua"]
[1992,"Olympiastadion","München","Olympique Marseille","1:0","AC Mailand"]
[1993,"Olympiastadion","Athen","AC Mailand","4:0","FC Barcelona"]
[1994,"Ernst-Happel-Stadion","Wien","Ajax Amsterdam","1:0","AC Mailand"]
[1995,"Olympiastadion","Rom","Juventus Turin","1:1 n.V. / 4:2 i.E.","Ajax Amsterdam"]
[1996,"Olympiastadion","München","Borussia Dortmund","3:1","Juventus Turin"]
[1997,"Amsterdam Arena","Amsterdam","Real Madrid","1:0","Juventus Turin"]
[1998,"Camp Nou","Barcelona","Manchester United","2:1","FC Bayern München"]
[1999,"Stade de France","Saint-Denis","Real Madrid","3:0","FC Valencia"]
[2000,"Giuseppe-Meazza-Stadion","Mailand","FC Bayern München","1:1 n.V. / 5:4 i.E.","FC Valencia"]
[2001,"Hampden Park","Glasgow","Real Madrid","2:1","Bayer 04 Leverkusen"]
[2002,"Old Trafford","Manchester","AC Mailand","0:0 n.V. / 3:2 i.E.","Juventus Turin"]
[2003,"Arena Auf Schalke","Gelsenkirchen","FC Porto","3:0","AS Monaco"]
[2004,"Atatürk Olimpiyat Stadı","Istanbul","FC Liverpool","3:3 n.V. / 3:2 i.E.","AC Mailand"]
[2005,"Stade de France","Saint-Denis","FC Barcelona","2:1","FC Arsenal"]
[2006,"Olympiastadion","Athen","AC Mailand","2:1","FC Liverpool"]
[2007,"Olympiastadion Luschniki","Moskau","Manchester United","1:1 n.V. / 6:5 i.E.","FC Chelsea"]
[2008,"Olympiastadion","Rom","FC Barcelona","2:0","Manchester United"]
[2009,"Estadio Santiago Bernabéu","Madrid","Inter Mailand","2:0","FC Bayern München"]
[2010,"Wembley-Stadion","London","FC Barcelona","3:1","Manchester United"]
[2011,"Fußball-Arena München","München","FC Chelsea","1:1 n.V. / 4:3 i.E.","FC Bayern München"]
[2012,"Wembley-Stadion","London","FC Bayern München","2:1","Borussia Dortmund"]
[2013,"Estádio da Luz","Lissabon","Real Madrid","4:1 n.V.","Atlético Madrid"]
[2014,"Olympiastadion","Berlin","FC Barcelona","3:1","Juventus Turin"]
[2015,"Giuseppe-Meazza-Stadion","Mailand","Real Madrid","1:1 n.V. / 5:3 i.E.","Atlético Madrid"]
[2016,"Millennium Stadium","Cardiff","Real Madrid","4:1","Juventus Turin"]
[2017,"NSK Olimpijskyj","Kiew"]
[2018,"Estadio Metropolitano","Madrid"]

{"sheet":"Staaten","index":3,"n_rows":210,"n_cols":4,"rows_kept":210,"cut":false,"hidden":true,"merged":[]}
["Staat","Hauptstadt","Einwohner","Fläche"]
["Europäische Union","Brüssel",510000000,4381324]
["Afrikanische Union","Addis Abeba",1137000000,29797500]
["Verband Südost­asiatischer Nationen","Jakarta",627000000,4480000]
["Organisation Amerikanischer Staaten","Washington, D.C.",987000000,42549000]
["Abchasien","Sochumi",240000,8600]
["Afghanistan","Kabul",32200000,652230]
["Ägypten","Kairo",89100000,1001450]
["Albanien","Tirana",2900000,28748]
["Algerien","Algier",37400000,2381741]
["Andorra","Andorra la Vella",85000,468]
["Angola","Luanda",25000000,1246700]
["Antigua und Barbuda","Saint John’s",87000,443]
["Äquatorialguinea","Malabo",800000,28051]
["Argentinien","Buenos Aires",42400000,2780400]
["Armenien","Jerewan",3000000,29743]
["Aserbaidschan","Baku",9700000,86600]
["Äthiopien","Addis Abeba",98100000,1104300]
["Australien","Canberra",23900000,7741220]
["Bahamas","Nassau",400000,13880]
["Bahrain","Manama",1400000,760]
["Bangladesch","Dhaka",160400000,143998]
["Barbados","Bridgetown",300000,430]
["Belgien","Brüssel",11200000,30528]
["Belize","Belmopan",400000,22966]
["Benin","Porto-Novo",10600000,112622]
["Bergkarabach","Stepanakert",135000,11500]
["Bhutan","Thimphu",800000,38394]
["Bolivien","Sucre",10500000,1098581]
["Bosnien und Herzegowina","Sarajevo",3700000,51197]
["Botswana","Gaborone",2100000,581730]
["Brasilien","Brasília",204500000,8514877]
["Brunei","Bandar Seri Begawan",400000,5765]
["Bulgarien","Sofia",7200000,110879]
["Burkina Faso","Ouagadougou",18500000,274200]
["Burundi","Bujumbura",10700000,27830]
["Chile","Santiago de Chile",18000000,756102]
["Republik China","Taipeh",23500000,35980]
["Volksrepublik China","Peking",1380000000,9596961]
["Cookinseln","Avarua",11500,236]
["Costa Rica","San José",4800000,51100]
["Dänemark","Kopenhagen",5659715,43094]
["Deutschland","Berlin",81100000,357121]
["Dominica","Roseau",73000,751]
["Dominikanische Republik","Santo Domingo",10500000,48670]
["Dschibuti","Dschibuti-Stadt",900000,23200]
["Ecuador","Quito",16300000,283561]
["El Salvador","San Salvador",6400000,21041]
["Elfenbeinküste","Yamoussoukro",23300000,322463]
["Eritrea","Asmara",5200000,117600]
["Estland","Tallinn",1300000,45228]
["Fidschi","Suva",900000,18274]
["Finnland","Helsinki",5500000,338145]
["Frankreich","Paris",64300000,551500]
["Gabun","Libreville",1800000,267667]
["Gambia","Banjul",2000000,11295]
["Georgien","Tiflis",3800000,69700]
["Ghana","Accra",27700000,238533]
["Grenada","St. George’s",108000,344]
["Griechenland","Athen",11500000,131957]
["Guatemala","Guatemala-Stadt",16200000,108889]
["Guinea","Conakry",11000000,245857]
["Guinea-Bissau","Bissau",1800000,36125]
["Guyana","Georgetown",700000,214969]
["Haiti","Port-au-Prince",10900000,27750]
["Honduras","Tegucigalpa",8300000,112090]
["Indien","Neu-Delhi",1314100000,3287263]
["Indonesien","Jakarta",255700000,1904569]
["Irak","Bagdad",37100000,438317]
["Iran","Teheran",78500000,1648195]
["Irland","Dublin",4600000,70273]
["Island","Reykjavík",330000,103000]
["Israel","Jerusalem",8400000,22380]
["Italien","Rom",62500000,301340]
["Jamaika","Kingston",2700000,10991]
["Japan","Tokio",126900000,377915]
["Jemen","Sanaa",26700000,527968]
["Jordanien","Amman",8100000,89342]
["Kambodscha","Phnom Penh",15400000,181035]
["Kamerun","Yaoundé",23700000,475440]
["Kanada","Ottawa",35800000,9984670]
["Kap Verde","Praia",509000,4033]
["Kasachstan","Astana",17500000,2724900]
["Katar","Doha",2400000,11586]
["Kenia","Nairobi",44300000,580367]
["Kirgisistan","Bischkek",6000000,199951]
["Kiribati","South Tarawa",100000,811]
["Kolumbien","Bogotá",48200000,1138910]
["Komoren","Moroni",800000,2235]
["Kongo, Demokratische Republik","Kinshasa",73300000,2344858]
["Kongo, Republik","Brazzaville",4800000,342000]
["Korea, Nord","Pjöngjang",25000000,120538]
["Korea, Süd","Seoul",50700000,99720]
["Kosovo","Pristina",1800000,10887]
["Kroatien","Zagreb",4200000,56594]
["Kuba","Havanna",11100000,110860]
["Kuwait","Kuwait-Stadt",3800000,17818]
["Laos","Vientiane",6900000,236800]
["Lesotho","Maseru",1900000,30355]
["Lettland","Riga",2000000,64589]
["Libanon","Beirut",6200000,10400]
["Liberia","Monrovia",4500000,111369]
["Libyen","Tripolis",6300000,1759540]
["Liechtenstein","Vaduz",37100,160]
["Litauen","Vilius",2900000,65300]
["Luxemburg","Luxemburg",600000,2586]
["Madagaskar","Antananarivo",23000000,587041]
["Malawi","Lilongwe",17200000,118484]
["Malaysia","Kuala Lumpur",30800000,329847]
["Malediven","Malé",300000,298]
["Mali","Bamako",16700000,1240192]
["Malta","Valletta",413000,316]
["Marokko","Rabat",34100000,446550]
["Marshallinseln","Majuro",60000,181]
["Mauretanien","Nouakchott",3600000,1030700]
["Mauritius","Port Louis",1300000,2040]
["Mazedonien","Skopje",2100000,25713]
["Mexiko","Mexiko-Stadt",127000000,1964375]
["Mikronesien","Palikir",107000,702]
["Moldawien","Chișinău",4100000,33851]
["Monaco","Stadtstaat",37800,2]
["Mongolei","Ulaanbaatar",3000000,1564116]
["Montenegro","Podgorica",600000,13812]
["Mosambik","Maputo",25700000,799380]
["Myanmar","Naypyidaw",52100000,676578]
["Namibia","Windhoek",2500000,824292]
["Nauru","Yaren",10000,21]
["Nepal","Kathmandu",28000000,147181]
["Neuseeland","Wellington",4600000,267710]
["Nicaragua","Managua",6300000,130730]
["Niederlande","Amsterdam",16900000,41543]
["Niger","Niamey",18900000,1267000]
["Nigeria","Abuja",181800000,923768]
["Niue","Alofi",1229,260]
["Nordzypern","Lefkoşa",295000,3355]
["Norwegen","Oslo",5200000,323802]
["Oman","Maskat",4200000,309500]
["Österreich","Wien",8600000,83871]
["Osttimor / Timor-Leste","Dili",1200000,14874]
["Pakistan","Islamabad",199000000,796095]
["Palästina","Gaza und Ramallah",4500000,6220]
["Palau","Ngerulmud",21000,459]
["Panama","Panama-Stadt",4000000,75420]
["Papua-Neuguinea","Port Moresby",7700000,462840]
["Paraguay","Asunción",7000000,406752]
["Peru","Lima",31200000,1285216]
["Philippinen","Manila",103000000,299000]
["Polen","Warschau",38500000,312685]
["Portugal","Lissabon",10300000,92090]
["Ruanda","Kigali",11300000,26338]
["Rumänien","Bukarest",19800000,238391]
["Russland","Moskau",144300000,17098242]
["Salomonen","Honiara",600000,28896]
["Sambia","Lusaka",15500000,752618]
["Samoa","Apia",200000,2831]
["San Marino","San Marino",32800,61]
["São Tomé und Príncipe","São Tomé",200000,964]
["Saudi-Arabien","Riad",31600000,2149690]
["Schweden","Stockholm",9800000,450295]
["Schweiz","Bern",8300000,41277]
["Senegal","Dakar",14700000,196722]
["Serbien","Belgrad",7100000,77474]
["Seychellen","Victoria",90000,455]
["Sierra Leone","Freetown",6500000,71740]
["Simbabwe","Harare",17400000,390757]
["Singapur","Stadtstaat",5500000,697]
["Slowakei","Bratislava",5400000,49035]
["Slowenien","Ljubljana",2100000,20273]
["Somalia","Mogadischu",11100000,637657]
["Somaliland","Hargeysa",3500000,137600]
["Spanien","Madrid",46400000,505370]
["Sri Lanka","Colombo",20900000,65610]
["St. Kitts und Nevis","Basseterre",50000,261]
["St. Lucia","Castries",200000,616]
["St. Vincent und die Grenadinen","Kingstown",104000,389]
["Südafrika","Pretoria",55000000,1219090]
["Sudan","Khartum",40900000,1886068]
["Südossetien","Zchinwali",51000,3885]
["Südsudan","Juba",12200000,619745]
["Suriname","Paramaribo",600000,163820]
["Swasiland","Mbabane",1300000,17364]
["Syrien","Damaskus",17100000,185180]
["Tadschikistan","Duschanbe",8500000,143100]
["Tansania","Dodoma",52300000,947300]
["Thailand","Bangkok",65100000,513120]
["Togo","Lomé",7200000,56785]
["Tonga","Nukuʻalofa",123000,747]
["Transnistrien","Tiraspol",555000,3567]
["Trinidad und Tobago","Port of Spain",1400000,5128]
["Tschad","N’Djamena",13700000,1284000]
["Tschechien","Prag",10600000,78867]
["Tunesien","Tunis",11000000,163610]
["Türkei","Ankara",78200000,783562]
["Turkmenistan","Aschgabad",5400000,488100]
["Tuvalu","Funafuti",10000,26]
["Uganda","Kampala",40100000,241038]
["Ukraine","Kiew",42800000,603550]
["Ungarn","Budapest",9800000,93028]
["Uruguay","Montevideo",3600000,176215]
["Usbekistan","Taschkent",31300000,447400]
["Vanuatu","Port Vila",300000,12189]
["Venezuela","Caracas",30600000,912050]
["Vereinigte Arabische Emirate","Abu Dhabi",9600000,83600]
["Vereinigte Staaten","Washington, D.C.",321200000,9826675]
["Vereinigtes Königreich","London",65100000,243610]
["Vietnam","Hanoi",91700000,331210]
["Weißrussland","Minsk",9500000,207600]
["Westsahara","El Aaiún",600000,266000]
["Zentral­afrikanische Republik","Bangui",5600000,622984]
["Zypern","Nikosia",1200000,9251]

{"sheet":"Europa","index":4,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Deutschland","Frankreich","Italien","Spanien","Österreich","Schweiz"]
["München","Paris","Rom","Madrid","Wien","Zürich"]
["Nürnberg","Nizza","Venedig","Barcelona","Salzburg","Genf"]
["Frankfurt","Marseille","Neapel","Cordoba","Klagenfurt","Basel"]
["Berlin","Lyon","Mailand","Valencia","Graz","Lausanne"]
["Hamburg",null,"Bologna"]
["Stuttgart"]
["Freiburg"]

{"sheet":"Mitarbeiter","index":5,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["PersonalNr","Vorname","Nachname","Abteilung"]
["10-100","Abrecht","Eugen","Einkauf"]
["10-101","Ament","Erwin","Entwicklung"]
["10-102","Bartsch","Alfred","Produktion"]
["10-103","Beuttenmüller","Ewald","Controlling"]
["10-104","Biedermann","Duane","Produktion"]
["10-105","Bley","Armin","Verkauf"]
["10-106","Bock","Werner","Service"]
["10-107","Cernjevic","Werner","Marketing"]
["10-108","Clauß","Wolfgang","Produktion"]
["10-109","Cotta","Wolfgang","Service"]
["10-110","Decker","Helmut","Produktion"]

{"sheet":"Vokabelheft","index":6,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Alter","Age"]
["Baum","Tree"]
["Chor","corus"]
["Deutsch","German"]
["Erde","Earth"]
["Frühling","Spring"]
["Gebühr","Fee"]
["Herbst","Autumn"]
["Irgendwo","Somewhere"]
["Jugend","Youth"]
["Kanal","Channel"]
["Lärm","Noise"]

{"sheet":"ActiveX","index":7,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,"Januar",null,null,null,null,"Makro 72"]
[null,null,null,"Februar"]
[null,null,null,"März"]
[null,null,null,"April"]
[null,null,null,"Mai"]
[null,null,null,"Juni"]
[null,null,null,"Juli"]
[null,null,null,"August"]
[null,null,null,"September"]
[null,null,null,"Oktober"]
[null,null,null,"November"]
[null,null,null,"Dezember"]

{"sheet":"RangeTest","index":8,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[]
[null,45,null,30]
[null,21,30]
[null,21,null,26]
[null,19,33,39]
[null,24,null,13]
[null,null,27]
[null,18,14,34]
[null,null,18,36]
[]
[]
[null,null,null,null,{"$f":"SUM(B2:D9)","v":448}]
[null,null,null,null,{"$f":"AVERAGE(B2:D9)","v":26.352941176470587}]

{"sheet":"Aufgaben","index":9,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["Sommerfest 2018",null,"2018-08-19"]
["Aufgabenliste"]
[]
[]
["Teilaufgabe","Aufgabe","zuständiger Mitarbeiter","Datum",null,"Mitarbeiter","eMail"]
["Brauerei","Showroom gestalten","Rudi Heinzmann","2018-08-12",null,"Rudi Heinzmann","rudi.heinzmann@uc.de"]
["Brauerei","Spezialsud \"Sommerhopfen\" brauen","Richard Braumeister","2018-05-05",null,"Richard Braumeister","richard.braumeister@uc.de"]
["Brauerei","Gerstenmalz einkaufen","Beate Kaufmann","2018-05-01",null,"Beate Kaufmann","beate.kaufmann@uc.de"]
["Brauerei","Hopfen einkaufen","Beate Kaufmann","2018-05-01",null,"Doris Fröhlich","doris.froehlich@uc.de"]
["Biergarten","Bestuhlung","Doris Fröhlich","2018-08-08",null,"Hans Bergmeister","hans.bergmeister@uc.de"]
["Biergarten","Dekoration","Hans Bergmeister","2018-08-10"]
["Biergarten","Speisekarten gestalten und drucken","Doris Fröhlich","2018-07-10"]
["Marketing","Prospekte gestalten und drucken","Doris Fröhlich","2018-07-10"]
["Marketing","Anzeigen schalten","Hans Bergmeister","2018-07-15"]
["Marketing","Werbemittel bestellen","Hans Bergmeister","2018-06-01"]

{"sheet":"Projektleiter","index":10,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Projektleiter"]
["Hausmann, Richard"]
["Fritsch, Bernhard"]
["Dietrich, Beate"]
["König, Heinz"]
["Salzmann, Sabine"]

{"sheet":"Umsatz 2017","index":11,"n_rows":4,"n_cols":17,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Artikel","Monat 1","Monat 2","Monat 3","Monat 4","Monat 5","Monat 6","Monat 7","Monat 8","Monat 9","Monat 10","Monat 11","Monat 12",null,null,null,"Makro 133"]
["Tennisschläger",10,20,23,20,25,30,20,23,20,15,25,30]
["Golfausrüstung",6,12,22,12,20,23,34,10,15,30,20,20]
["Outdoor-Bekleidung",15,13,50,16,40,15,45,45,20,20,29,25]

{"sheet":"M-Code","index":12,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Umsatz"]
["let"]
["    Quelle = Excel.CurrentWorkbook(){[Name=\"tbl_Umsatz\"]}[Content],"]
["    #\"Geänderter Typ\" = Table.TransformColumnTypes(Quelle,{{\"Artikel\", type text}, {\"Monat 1\", Int64.Type}, {\"Monat 2\", Int64.Type}, {\"Monat 3\", Int64.Type}, {\"Monat 4\", Int64.Type}, {\"Monat 5\", Int64.Type}, {\"Monat 6\", Int64.Type}, {\"Monat 7\", Int64.Type}, {\"Monat 8\", Int64.Type}, {\"Monat 9\", Int64.Type}, {\"Monat 10\", Int64.Type}, {\"Monat 11\", Int64.Type}, {\"Monat 12\", Int64.Type}}),"]
["    #\"Entpivotierte andere Spalten\" = Table.UnpivotOtherColumns(#\"Geänderter Typ\", {\"Artikel\"}, \"Attribut\", \"Wert\"),"]
["    #\"Ersetzter Wert\" = Table.ReplaceValue(#\"Entpivotierte andere Spalten\",\"Monat \",\"\",Replacer.ReplaceText,{\"Attribut\"}),"]
["    #\"Hinzugefügte benutzerdefinierte Spalte\" = Table.AddColumn(#\"Ersetzter Wert\", \"Datum\", each Date.FromText([Attribut]&\"/2017/01\")),"]
["    #\"Neu angeordnete Spalten\" = Table.ReorderColumns(#\"Hinzugefügte benutzerdefinierte Spalte\",{\"Datum\", \"Artikel\", \"Attribut\", \"Wert\"}),"]
["    #\"Geänderter Typ1\" = Table.TransformColumnTypes(#\"Neu angeordnete Spalten\",{{\"Datum\", type date}}),"]
["    #\"Entfernte Spalten\" = Table.RemoveColumns(#\"Geänderter Typ1\",{\"Attribut\"})"]
["in"]
["    #\"Entfernte Spalten\""]