{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["selecteer de teksten","geselecteerde teksten","omzettingstabel"],"not_rendered":{"charts":0,"images":2,"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":"selecteer de teksten","index":0,"n_rows":149,"n_cols":21,"rows_kept":149,"cut":false,"hidden":false,"merged":[[2,14,2,15],[8,14,8,15]]}
[null,"Duits havo"]
[]
[null,null,"jaar","tekst","omschrijving","indicatie moeilijkheidsgraad","P","L","N",null,"ü",null,null,null,"grenswaarden",null,null,"P","L","N","bijdrage"]
[null,null,2011,1,"Auf leisen Sohlen",{"$f":"IF(G4>P$7,\"makkelijke tekst\",IF(G4<P$6,\"moeilijke tekst\",\"tekst van gemiddelde moeilijkheid\"))","v":"tekst van gemiddelde moeilijkheid"},66.555555555555557,8,0.30999999999999961,null,null,null,null,null,"gemiddelde",{"$f":"AVERAGE(G4:G150)","v":63.752442922374364},null,{"$f":"IF($K4=\"ü\",$G4,\"\")","v":""},{"$f":"IF($K4=\"ü\",$H4,\"\")","v":""},{"$f":"IF($K4=\"ü\",$I4,\"\")","v":""},{"$f":"IF($K4=\"ü\",$G4*$H4,\"\")","v":""}]
[null,null,2011,2,"… und keiner hat’s gemerkt",{"$f":"IF(G5>P$7,\"makkelijke tekst\",IF(G5<P$6,\"moeilijke tekst\",\"tekst van gemiddelde moeilijkheid\"))","v":"tekst van gemiddelde moeilijkheid"},68.555555555555557,2,0.12999999999999989,null,null,null,null,null,"standaarddeviatie",{"$f":"STDEVA(G4:G150)","v":14.16484153076415},null,"","","",""]
[null,null,2011,3,"Ist Deutsch noch Deutsch?",{"$f":"IF(G6>P$7,\"makkelijke tekst\",IF(G6<P$6,\"moeilijke tekst\",\"tekst van gemiddelde moeilijkheid\"))","v":"moeilijke tekst"},32.555555555555557,1,3.3699999999999997,null,null,null,null,null,"M-S",{"$f":"P4-P5","v":49.587601391610214},null,"","","",""]
[null,null,2011,4,"Für uns war Holland ein Hype",{"$f":"IF(G7>P$7,\"makkelijke tekst\",IF(G7<P$6,\"moeilijke tekst\",\"tekst van gemiddelde moeilijkheid\"))","v":"tekst van gemiddelde moeilijkheid"},59.555555555555557,5,0.9399999999999995,null,null,null,null,null,"M+S",{"$f":"P4+P5","v":77.917284453138507},null,"","","",""]
[null,null,2011,5,"Voyeurismus an der Schule","tekst van gemiddelde moeilijkheid",55.555555555555557,8,1.2999999999999998,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2011,6,"Der Tag der Scherzkekse","tekst van gemiddelde moeilijkheid",60.555555555555557,2,0.84999999999999964,null,null,null,null,null,"gewogen P en N",null,null,"","","",""]
[null,null,2011,7,"Große Zustimmung für kinderfreies Lokal","tekst van gemiddelde moeilijkheid",73.555555555555557,2,-0.32000000000000028,null,null,null,null,null,"totale bijdrage",{"$f":"SUM(U4:U150)","v":0},null,"","","",""]
[null,null,2011,8,"Die Zuglotsin","tekst van gemiddelde moeilijkheid",71.555555555555557,7,-0.14000000000000057,null,null,null,null,null,"gem sc",{"$f":"P10/100","v":0},null,"","","",""]
[null,null,2011,9,"Macht Unterricht Spaß?","tekst van gemiddelde moeilijkheid",66.555555555555557,8,0.30999999999999961,null,null,null,null,null,"totale lengte",{"$f":"SUM(S4:S150)","v":0},null,"","","",""]
[null,null,2011,10,"Brautschau: Regeln aus der Steinzeit","tekst van gemiddelde moeilijkheid",57.555555555555557,1,1.1200000000000001,null,null,null,null,null,"9*P",{"$f":"IF(P12=0,0,9*P11/P12)","v":0},null,"","","",""]
[null,null,2011,11,"Sicherheitshinweis beim Betrieb der Wii-Konsole","tekst van gemiddelde moeilijkheid",70.555555555555557,2,-4.9999999999999822E-2,null,null,null,null,null,"n-term",{"$f":"IF(P12=0,1,6.3-P13)","v":1},null,"","","",""]
[null,null,2011,12,"eBay","tekst van gemiddelde moeilijkheid",64.555555555555557,1,0.49000000000000021,null,null,null,null,null,"afgeronde N",{"$f":"ROUND(P14,1)","v":1},null,"","","",""]
[null,null,2012,1,"„Ich hab dich so lieb, Mausebär“","makkelijke tekst",78.444444444444443,5,-0.75999999999999979,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2012,2,"Gartenzwerg sieben Monate lang auf Weltreise","makkelijke tekst",78.444444444444443,4,-0.75999999999999979,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2012,3,"Zombies im Café","tekst van gemiddelde moeilijkheid",72.444444444444443,3,-0.21999999999999975,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2012,4,"Spielen zum Beruf machen","tekst van gemiddelde moeilijkheid",73.444444444444443,10,-0.3100000000000005,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2012,5,"Der Duft der harten Arbeit","tekst van gemiddelde moeilijkheid",57.444444444444436,6,1.1300000000000008,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2012,6,"Mit Gitarrenriffs zum Erfolg","tekst van gemiddelde moeilijkheid",52.444444444444436,1,1.58,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2012,7,"Die Deutschen sind besser als ihr Ruf","tekst van gemiddelde moeilijkheid",56.444444444444436,5,1.2200000000000006,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2012,8,"Männer fragen Brigitte","tekst van gemiddelde moeilijkheid",63.444444444444436,2,0.59000000000000075,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2012,9,"Feiner pinkeln","tekst van gemiddelde moeilijkheid",75.444444444444443,4,-0.49000000000000021,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2012,10,"Filmreif!","tekst van gemiddelde moeilijkheid",51.444444444444436,2,1.6700000000000008,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2012,11,"Äußerlichkeiten sind Nebensache","tekst van gemiddelde moeilijkheid",70.444444444444443,7,-4.0000000000000036E-2,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2012,12,"Lebensmittelallergien","moeilijke tekst",35.444444444444436,1,3.1100000000000003,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,1,"Festivals: Die Wiese rockt! Oder lieber nicht?","tekst van gemiddelde moeilijkheid",67.372222222222234,7,0.2364999999999986,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,2,"Was würden Katzen kaufen, wenn sie kaufen könnten?","moeilijke tekst",33.222222222222221,1,3.3099999999999996,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,3,"Der Clip-Milliardär","makkelijke tekst",79.052222222222227,8,-0.8147000000000002,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,4,"Gummi-Geburtstag","makkelijke tekst",88.222222222222229,1,-1.6400000000000006,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,5,"Schöne haben’s leichter","tekst van gemiddelde moeilijkheid",62.812222222222225,3,0.64689999999999959,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,6,"„Die Wahrheit erfinden“","tekst van gemiddelde moeilijkheid",68.39222222222223,7,0.14469999999999938,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,7,"Eine junge Köchin mit Biss","tekst van gemiddelde moeilijkheid",72.352222222222224,8,-0.21170000000000133,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,8,"Abschied von den Kärtchen","makkelijke tekst",88.042222222222222,2,-1.6238000000000001,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,9,"Junkfood aus der Thermobox","tekst van gemiddelde moeilijkheid",54.282222222222224,7,1.4145999999999992,null,null,null,null,null,null,null,null,{"$f":"IF($K36=\"ü\",$G36,\"\")","v":""},{"$f":"IF($K36=\"ü\",$H36,\"\")","v":""},{"$f":"IF($K36=\"ü\",$I36,\"\")","v":""},{"$f":"IF($K36=\"ü\",$G36*$H36,\"\")","v":""}]
[null,null,2013,10,"Füchse kommen in die Stadt","tekst van gemiddelde moeilijkheid",61.222222222222221,3,0.79,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,11,"Kein Witz!","tekst van gemiddelde moeilijkheid",73.222222222222229,1,-0.29000000000000004,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,12,"Nürburgring","moeilijke tekst",45.222222222222221,1,2.2299999999999995,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,1,"Klamotten kaufen 2.0","makkelijke tekst",89.333333333333329,3,-1.7399999999999993,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,2,"TV-Knabbereien","tekst van gemiddelde moeilijkheid",58.583333333333329,2,1.0274999999999999,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,3,"Botox von der Braut","tekst van gemiddelde moeilijkheid",52.333333333333329,1,1.5900000000000007,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,4,"Loops am Limit","tekst van gemiddelde moeilijkheid",76.923333333333332,7,-0.62309999999999999,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,5,"Google Street View","tekst van gemiddelde moeilijkheid",54.273333333333326,8,1.4154000000000009,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,6,"Der tragische Ladendieb","tekst van gemiddelde moeilijkheid",51.803333333333327,6,1.6377000000000006,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,7,"Haustiere, aufgepasst!","makkelijke tekst",95.333333333333329,1,-2.2800000000000002,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,8,"Döner bis Schweiß","makkelijke tekst",84.333333333333329,3,-1.29,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,9,"Schokolade für die Schönheit","tekst van gemiddelde moeilijkheid",62.523333333333326,6,0.67290000000000028,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,10,"Sind wir Erben der Neandertaler?","tekst van gemiddelde moeilijkheid",61.673333333333332,4,0.74940000000000051,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,11,"Die Wahrheit über Laufschuhe","tekst van gemiddelde moeilijkheid",61.333333333333329,1,0.78000000000000025,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,12,"Abitur in Schwarz-Weiß","tekst van gemiddelde moeilijkheid",63.493333333333325,5,0.58560000000000034,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,13,"Der Kritzelcode","makkelijke tekst",83.333333333333329,1,-1.2000000000000002,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,1,"Titus - der Herr der Bretter","tekst van gemiddelde moeilijkheid",77.573333333333323,5,-0.68159999999999865,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,2,"Tekst 2","makkelijke tekst",97.313333333333333,1,-2.4581999999999988,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,3,"Produktpiraten immer frecher","moeilijke tekst",42.133333333333326,2,2.5080000000000005,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,4,"Engagierter Student sucht ... Ehrenamt","tekst van gemiddelde moeilijkheid",56.783333333333331,7,1.1895000000000007,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,5,"Hochzeit mit Folgen","tekst van gemiddelde moeilijkheid",53.593333333333327,2,1.4766000000000004,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,6,"HÄ?? Jugendsprache unplugged","tekst van gemiddelde moeilijkheid",69.853333333333325,2,1.3200000000000323E-2,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,7,"Deutschland sucht den Superkanzler","moeilijke tekst",33.103333333333332,3,3.3206999999999995,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,8,"Jeanswäsche mit Spezialpaste","tekst van gemiddelde moeilijkheid",57.283333333333331,3,1.1444999999999999,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,9," Jobsuche im Ausland","makkelijke tekst",89.233333333333334,2,-1.7310000000000008,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,10,"Die wunderbare Welt der Spickzettel","moeilijke tekst",48.073333333333331,8,1.9733999999999998,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,11,"Kandidaten müssen Preisgeld versteuern","moeilijke tekst",46.393333333333331,2,2.1246,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,12," Mein Ladegerät","tekst van gemiddelde moeilijkheid",64.593333333333334,6,0.48659999999999926,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,13,"Wenn das Handy mayday meldet","tekst van gemiddelde moeilijkheid",54.093333333333327,6,1.4316000000000004,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,14,"Rauchen: Stopp!","tekst van gemiddelde moeilijkheid",71.943333333333328,2,-0.17490000000000006,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2016,1,"Gegen die Wand","tekst van gemiddelde moeilijkheid",74.364444444444445,9,-0.39280000000000026,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2016,2,"Die Tüte muss pfiffig sein","tekst van gemiddelde moeilijkheid",70.564444444444447,4,-5.0800000000000622E-2,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2016,3,"Big Brother für Vögel","tekst van gemiddelde moeilijkheid",59.794444444444437,1,0.91849999999999987,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2016,4,"Angst vor Freitag, dem 13.","tekst van gemiddelde moeilijkheid",61.454444444444434,7,0.76910000000000078,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2016,5,"Detektor für Knockout-Drogen",{"$f":"IF(G71>P$7,\"makkelijke tekst\",IF(G71<P$6,\"moeilijke tekst\",\"tekst van gemiddelde moeilijkheid\"))","v":"tekst van gemiddelde moeilijkheid"},58.534444444444439,2,1.0319000000000003,null,null,null,null,null,null,null,null,{"$f":"IF($K71=\"ü\",$G71,\"\")","v":""},{"$f":"IF($K71=\"ü\",$H71,\"\")","v":""},{"$f":"IF($K71=\"ü\",$I71,\"\")","v":""},{"$f":"IF($K71=\"ü\",$G71*$H71,\"\")","v":""}]
[null,null,2016,6,"Meine freie deutsche Jugend","makkelijke tekst",81.604444444444439,4,-1.0443999999999996,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2016,7,"Greencard für Kotfresser","tekst van gemiddelde moeilijkheid",51.794444444444437,2,1.6385000000000005,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2016,8,"Weibliche Intuition","moeilijke tekst",47.374444444444435,3,2.0363000000000007,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2016,9,"„Abi 78 war anders als 2012“","tekst van gemiddelde moeilijkheid",66.444444444444443,6,0.3199999999999994,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2016,10,"Die Wahrheit über Kaffee","moeilijke tekst",45.644444444444439,2,2.1920000000000002,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2016,11,"Teures Ersatzhotel","tekst van gemiddelde moeilijkheid",54.694444444444436,2,1.3775000000000004,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2016,12,"Lachen, zwinkern, traurig sein","tekst van gemiddelde moeilijkheid",53.954444444444434,6,1.4441000000000006,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2016,13,"Fernseher","makkelijke tekst",96.054444444444442,2,-2.3449,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2017,1,"Schmied der eigenen Medaille","tekst van gemiddelde moeilijkheid",62.603333333333332,7,0.66570000000000018,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2017,2,"Die Illusion vom dritten Arm","tekst van gemiddelde moeilijkheid",72.783333333333331,3,-0.25049999999999972,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2017,3,"Pro und Contra: Schuluniformen","makkelijke tekst",87.333333333333329,4,-1.5600000000000005,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2017,4,"Mutter bleibt die Beste","tekst van gemiddelde moeilijkheid",74.61333333333333,5,-0.41519999999999957,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2017,5,"Genuss und Ruhe","moeilijke tekst",49.473333333333329,2,1.8473999999999995,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2017,6,"Falscher Ball","tekst van gemiddelde moeilijkheid",56.993333333333325,2,1.1706000000000003,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2017,7,"Warum ist Herr Herzog häufiger Chef als Herr Fischer?","tekst van gemiddelde moeilijkheid",68.953333333333333,7,9.4199999999999839E-2,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2017,8,"Gesamter Jahrgang fällt durchs Abi","tekst van gemiddelde moeilijkheid",56.373333333333328,5,1.2263999999999999,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2017,9,"Stärkste Frau der Wiesn-Welt","moeilijke tekst",45.61333333333333,3,2.1947999999999999,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2017,10,"Der Weg zur Toilette","tekst van gemiddelde moeilijkheid",68.793333333333322,6,0.10860000000000092,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2017,11,"Soziales Gezwitscher","tekst van gemiddelde moeilijkheid",76.333333333333329,2,-0.57000000000000028,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2017,12,"Illegal in Kreuzberg","tekst van gemiddelde moeilijkheid",76.073333333333323,2,-0.54659999999999886,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2017,13,"Durstlöscher Wasser","makkelijke tekst",87.333333333333329,2,-1.5600000000000005,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2018,1,"Wetterschutz zum Sitzen","tekst van gemiddelde moeilijkheid",76.683333333333323,7,-0.60149999999999881,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2018,2,"Love@Miriam","moeilijke tekst",49.413333333333327,2,1.8528000000000011,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2018,3,"Jo-Jo-Effekt ist gesünder als erwartet","moeilijke tekst",29.333333333333332,1,3.6599999999999997,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2018,4,"Yes, we speak Deutsch","tekst van gemiddelde moeilijkheid",67.663333333333327,7,0.21030000000000104,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2018,5,"Werbeplakat sorgt für Aufsehen","tekst van gemiddelde moeilijkheid",74.183333333333323,5,-0.37649999999999917,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2018,6,"Die Wahrheit über Mücken","tekst van gemiddelde moeilijkheid",68.963333333333324,2,9.3300000000000161E-2,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2018,7,"Burkhard Spinnen: Müller hoch drei","moeilijke tekst",44.333333333333329,4,2.3100000000000005,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2018,8,"Lebensraum Todesstreifen: 25 Jahre „Grünes Band Deutschland“","tekst van gemiddelde moeilijkheid",53.423333333333332,8,1.4919000000000002,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2018,9,"Kakerlaken sollen Menschen retten","tekst van gemiddelde moeilijkheid",70.913333333333327,4,-8.2199999999999385E-2,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2018,10,"Alles Müller, oder was?","tekst van gemiddelde moeilijkheid",56.573333333333331,2,1.2084000000000001,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2018,11,"Link ins Leere","tekst van gemiddelde moeilijkheid",57.143333333333331,6,1.1570999999999998,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2018,12,"Die wichtigsten Lebensmittel im Check","makkelijke tekst",85.333333333333329,2,-1.38,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2019,1,"„Vergebung der Sünden“","makkelijke tekst",96.544444444444437,2,-2.3890000000000002,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2019,2,"Legokunst","makkelijke tekst",81.054444444444442,7,-0.99490000000000034,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2019,3,"Vom Jungen mit Werkzeugkasten zum Möbeldesigner","tekst van gemiddelde moeilijkheid",76.064444444444447,6,-0.54580000000000073,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2019,4,"Die Wahrheit über das Gesäß des Menschen","makkelijke tekst",82.164444444444442,2,-1.0948000000000002,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2019,5,"15 000 Volt statt Sternenhimmel","tekst van gemiddelde moeilijkheid",52.804444444444435,8,1.547600000000001,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2019,6,"Rabensommer","tekst van gemiddelde moeilijkheid",74.444444444444443,4,-0.40000000000000036,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2019,7,"Mit dem Essen spielt man doch!","tekst van gemiddelde moeilijkheid",68.544444444444437,2,0.13100000000000023,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2019,8,"„Gehst du Bus?“ Kiezdeutsch gibt’s bald ohne Kiez","tekst van gemiddelde moeilijkheid",57.114444444444437,11,1.1597,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2019,9,"Sprühst du, klau ich","tekst van gemiddelde moeilijkheid",71.444444444444443,1,-0.12999999999999989,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2019,10,"Lederhosen-Donnerstag immer beliebter","tekst van gemiddelde moeilijkheid",60.444444444444436,3,0.86000000000000121,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2019,11,"Schaffen wir das Komma ab, Herr Runkehl?","tekst van gemiddelde moeilijkheid",71.394444444444446,4,-0.12549999999999972,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2019,12,"Diese Strafen drohen ignoranten Fahrradfahrern","tekst van gemiddelde moeilijkheid",68.154444444444437,2,0.16610000000000102,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2021,1,"Freiheit für die Kaulquappe","tekst van gemiddelde moeilijkheid",69.558888888888887,3,3.9699999999999847E-2,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2021,2,"Niet klagen!","makkelijke tekst",84.358888888888885,2,-1.2923,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2021,3,"Paula Schwarz lotst Flüchtlinge digital durch die EU","tekst van gemiddelde moeilijkheid",67.558888888888887,7,0.21970000000000045,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2021,4,"Die Wahrheit über Grünes Marketing","moeilijke tekst",45.948888888888888,1,2.1646000000000001,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2021,5,"Weiß ist heiß","moeilijke tekst",43.468888888888884,6,2.3877999999999999,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2021,6,"Fressen die auch Katzen?","tekst van gemiddelde moeilijkheid",53.348888888888887,8,1.4985999999999997,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2021,7,"Jäger des verlorenen Schatzes","tekst van gemiddelde moeilijkheid",56.618888888888883,9,1.2043000000000008,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2021,8,"Elektronische Nannys für Obstbäume","tekst van gemiddelde moeilijkheid",53.458888888888886,2,1.4886999999999997,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2021,9,"So lässt sich am besten lernen","tekst van gemiddelde moeilijkheid",68.698888888888888,5,0.11709999999999976,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2021,10,"Pampa Blues","tekst van gemiddelde moeilijkheid",55.378888888888888,4,1.3159000000000001,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2021,11,"Deutscher Bundestag",{"$f":"IF(G127>P$7,\"makkelijke tekst\",IF(G127<P$6,\"moeilijke tekst\",\"tekst van gemiddelde moeilijkheid\"))","v":"tekst van gemiddelde moeilijkheid"},76.938888888888883,2,-0.62449999999999939,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2022,1,"Mit Geduld, Lob und Leckerli","tekst van gemiddelde moeilijkheid",52.53,6,1.5723000000000003,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2022,2,"Wenn in Frauen die Liebe zur Kreissäge entbrennt","tekst van gemiddelde moeilijkheid",64.400000000000006,6,0.50399999999999956,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2022,3,"Der späte Wunsch eines Gitarristen, das Abi zu machen","tekst van gemiddelde moeilijkheid",60.72,4,0.8351999999999995,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2022,4,"Schneeriese","moeilijke tekst",27.56,4,3.8195999999999999,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2022,5,"Abeltshauser, der strickende Eishockey-Profi","tekst van gemiddelde moeilijkheid",57.98,3,1.0818000000000003,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2022,6,"Trinkgeld ade","tekst van gemiddelde moeilijkheid",50.62,4,1.7442000000000002,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2022,7,"„Der Traumjob jedes 16-Jährigen“","tekst van gemiddelde moeilijkheid",54.58,6,1.3878000000000004,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2022,8,"Kälteabnahme","tekst van gemiddelde moeilijkheid",57.71,3,1.1060999999999996,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2022,9,"Walfach Fremdsprache","tekst van gemiddelde moeilijkheid",50.83,4,1.7252999999999998,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2022,10,"Spiel des Lebens","tekst van gemiddelde moeilijkheid",58.07,5,1.0736999999999997,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2022,11,"Der Durchschnittsdeutsche …","makkelijke tekst",85.4,4,-1.3860000000000001,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2023,1,"Ohne Polnischkenntnisse Führerschein in Polen","tekst van gemiddelde moeilijkheid",60.888888888888886,2,0.8199999999999994,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2023,2,"Paris kämpft gegen die Unterwelt","tekst van gemiddelde moeilijkheid",59.888888888888886,4,0.91000000000000014,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2023,3,"Krieg der Sonnenschirme","tekst van gemiddelde moeilijkheid",54.888888888888886,6,1.3599999999999994,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2023,4,"Immer kommt mir das Leben dazwischen","tekst van gemiddelde moeilijkheid",66.888888888888886,4,0.28000000000000025,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2023,5,"Autonome Roboter zu Gast","tekst van gemiddelde moeilijkheid",55.888888888888886,4,1.2699999999999996,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2023,6,"Ein Leben mit 65 Hunden","tekst van gemiddelde moeilijkheid",51.888888888888886,6,1.63,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2023,7,"Frauenstimmen werden tiefer","tekst van gemiddelde moeilijkheid",64.888888888888886,8,0.45999999999999996,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2023,8,"Heizdecke Big Hug von Stoov","moeilijke tekst",47.888888888888886,4,1.9900000000000002,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2023,9,"Ein Käfer namens DiCaprio","moeilijke tekst",43.888888888888886,1,2.3499999999999996,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2023,10,"Tierisch gut","makkelijke tekst",82.888888888888886,4,-1.1600000000000001,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2023,11,"Männer mögen graue Autos - Frauen lieben es öfter","tekst van gemiddelde moeilijkheid",58.888888888888886,3,1,null,null,null,null,null,null,null,null,"","","",""]

{"sheet":"geselecteerde teksten","index":1,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[15,4,15,5],[16,4,16,5],[17,4,17,5],[18,4,18,5],[19,4,19,5],[20,4,20,5],[9,4,9,5],[21,4,21,5],[10,4,10,5],[11,4,11,5],[12,4,12,5],[13,4,13,5],[14,4,14,5]]}
[null,"Duits havo"]
[]
[null,null,"inhoud van de toets"]
[]
[null,null,"schaallengte",null,{"$f":"'selecteer de teksten'!P12","v":0}]
[null,null,"N-term",null,{"$f":"'selecteer de teksten'!P15","v":1}]
[]
[null,null,"teksten in chronologische volgorde"]
[]
[null,null,"jaar","tekst","omschrijving",null,"punten"]
[null,null,2023,1,"Ohne Polnischkenntnisse Führerschein in Polen",null,2]
[null,null,2023,2,"Paris kämpft gegen die Unterwelt",null,4]
[null,null,2023,3,"Krieg der Sonnenschirme",null,6]
[null,null,2023,4,"Immer kommt mir das Leben dazwischen",null,4]
[null,null,2023,5,"Autonome Roboter zu Gast",null,4]
[null,null,2023,6,"Ein Leben mit 65 Hunden",null,6]
[null,null,2023,7,"Frauenstimmen werden tiefer",null,8]
[null,null,2023,8,"Heizdecke Big Hug von Stoov",null,4]
[null,null,2023,9,"Ein Käfer namens DiCaprio",null,1]
[null,null,2023,10,"Tierisch gut",null,4]
[null,null,2023,11,"Männer mögen graue Autos - Frauen lieben es öfter",null,3]

{"sheet":"omzettingstabel","index":2,"n_rows":47,"n_cols":16,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Vaknaam:",null,null,null,{"$f":"'selecteer de teksten'!B1","v":"Duits havo"}]
[null,"Schaallengte:",null,null,null,46]
[null,"Normeringsterm:",null,null,null,0.9]
[]
[null,"Score","Cijfer",null,"Score","Cijfer",null,null,null,null,null,null,null,null,null,"####"]
[]
[null,0,"1,0",null,40,"8,7"]
[null,1,"1,1",null,41,"8,9"]
[null,2,"1,3",null,42,"9,1"]
[null,3,"1,5",null,43,"9,3"]
[null,4,"1,7",null,44,"9,5"]
[null,5,"1,9",null,45,"9,7"]
[null,6,"2,1",null,46,"10,0"]
[null,7,"2,3"]
[null,8,"2,5"]
[null,9,"2,7"]
[null,10,"2,9"]
[null,11,"3,1"]
[null,12,"3,2"]
[null,13,"3,4"]
[null,14,"3,6"]
[null,15,"3,8"]
[null,16,"4,0"]
[null,17,"4,2"]
[null,18,"4,4"]
[null,19,"4,6"]
[null,20,"4,8"]
[null,21,"5,0"]
[null,22,"5,2"]
[null,23,"5,4"]
[null,24,"5,6"]
[null,25,"5,8"]
[null,26,"6,0"]
[null,27,"6,2"]
[null,28,"6,4"]
[null,29,"6,6"]
[null,30,"6,8"]
[null,31,"7,0"]
[null,32,"7,2"]
[null,33,"7,4"]
[null,34,"7,6"]
[null,35,"7,7"]
[null,36,"7,9"]
[null,37,"8,1"]
[null,38,"8,3"]
[null,39,"8,5"]