{"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":7,"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":157,"n_cols":21,"rows_kept":157,"cut":false,"hidden":false,"merged":[[2,14,2,15],[8,14,8,15]]}
[null,"Duits GL/TL"]
[]
[null,null,"jaar","tekst","omschrijving","indicatie moeilijkheidsgraad","P","L","N",null,"ü",null,null,null,"grenswaarden",null,null,"P","L","N","bijdrage"]
[null,null,2012,1,"Tekst 1",{"$f":"IF(G4>P$7,\"makkelijke tekst\",IF(G4<P$6,\"moeilijke tekst\",\"tekst van gemiddelde moeilijkheid\"))","v":"makkelijke tekst"},91.111111111111114,1,-1.9999999999999991,null,null,null,null,null,"gemiddelde",{"$f":"AVERAGE(G4:G982)","v":60.708131313131325},null,{"$f":"IF($K4=\"ü\",$G4,\"\")","v":""},{"$f":"IF($K4=\"ü\",$H4,\"\")","v":""},{"$f":"IF($K4=\"ü\",$I4,\"\")","v":""},{"$f":"IF($K4=\"ü\",$G4*$H4,\"\")","v":""}]
[null,null,2012,2,"Tekst 2",{"$f":"IF(G5>P$7,\"makkelijke tekst\",IF(G5<P$6,\"moeilijke tekst\",\"tekst van gemiddelde moeilijkheid\"))","v":"tekst van gemiddelde moeilijkheid"},50.111111111111114,1,1.6900000000000004,null,null,null,null,null,"standaarddeviatie",{"$f":"STDEVA(G4:G982)","v":16.846181351359242},null,"","","",""]
[null,null,2012,3,"Tekst 3","tekst van gemiddelde moeilijkheid",56.111111111111114,6,1.1500000000000004,null,null,null,null,null,"M-S",{"$f":"P4-P5","v":43.861949961772083},null,"","","",""]
[null,null,2012,4,"Tekst 4","tekst van gemiddelde moeilijkheid",70.111111111111114,7,-0.10999999999999943,null,null,null,null,null,"M+S",{"$f":"P4+P5","v":77.554312664490567},null,"","","",""]
[null,null,2012,5,"Tekst 5","tekst van gemiddelde moeilijkheid",76.111111111111114,1,-0.64999999999999947,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2012,6,"Tekst 6","makkelijke tekst",78.111111111111114,1,-0.83000000000000007,null,null,null,null,null,"gewogen P en N",null,null,"","","",""]
[null,null,2012,7,"Tekst 7","tekst van gemiddelde moeilijkheid",67.111111111111114,7,0.16000000000000014,null,null,null,null,null,"totale bijdrage",{"$f":"SUM(U4:U982)","v":0},null,"","","",""]
[null,null,2012,8,"Tekst 8","moeilijke tekst",41.111111111111114,6,2.5,null,null,null,null,null,"gem sc",{"$f":"P10/100","v":0},null,"","","",""]
[null,null,2012,9,"Tekst 9","tekst van gemiddelde moeilijkheid",54.111111111111114,3,1.33,null,null,null,null,null,"totale lengte",{"$f":"SUM(S4:S982)","v":0},null,"","","",""]
[null,null,2012,10,"Tekst 10","tekst van gemiddelde moeilijkheid",44.111111111111114,1,2.23,null,null,null,null,null,"9*P",{"$f":"IF(P12=0,0,9*P11/P12)","v":0},null,"","","",""]
[null,null,2012,11,"Tekst 11",{"$f":"IF(G14>P$7,\"makkelijke tekst\",IF(G14<P$6,\"moeilijke tekst\",\"tekst van gemiddelde moeilijkheid\"))","v":"moeilijke tekst"},33.111111111111114,6,3.22,null,null,null,null,null,"n-term",{"$f":"IF(P12=0,1,refgemcijfer-P13)","v":1},null,"","","",""]
[null,null,2012,12,"Tekst 12","tekst van gemiddelde moeilijkheid",65.111111111111114,5,0.33999999999999986,null,null,null,null,null,"afgeronde N",{"$f":"ROUND(P14,1)","v":1},null,"","","",""]
[null,null,2012,13,"Tekst 13","tekst van gemiddelde moeilijkheid",55.111111111111114,1,1.2400000000000002,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,1,"Tekst 1","tekst van gemiddelde moeilijkheid",45.111111111111114,1,2.1400000000000006,null,null,null,null,null,"Ref.gem.cijfer",6.2,null,"","","",""]
[null,null,2013,2,"Tekst 2","tekst van gemiddelde moeilijkheid",73.111111111111114,1,-0.37999999999999989,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,3,"Tekst 3","tekst van gemiddelde moeilijkheid",62.771111111111111,5,0.55059999999999931,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,4,"Tekst 4","tekst van gemiddelde moeilijkheid",76.88111111111111,6,-0.71929999999999961,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,5,"Tekst 5","makkelijke tekst",83.111111111111114,1,-1.2800000000000002,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,6,"Tekst 6","makkelijke tekst",81.111111111111114,1,-1.0999999999999996,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,7,"Tekst 7","tekst van gemiddelde moeilijkheid",57.791111111111114,5,0.99880000000000013,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,8,"Tekst 8","tekst van gemiddelde moeilijkheid",70.801111111111112,8,-0.17210000000000036,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,9,"Tekst 9","makkelijke tekst",82.111111111111114,1,-1.1899999999999995,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,10,"Tekst 10","tekst van gemiddelde moeilijkheid",76.111111111111114,1,-0.64999999999999947,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,11,"Tekst 11","tekst van gemiddelde moeilijkheid",64.291111111111121,7,0.41379999999999928,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,12,"Tekst 12","tekst van gemiddelde moeilijkheid",67.821111111111108,7,9.610000000000074E-2,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,13,"Tekst 13","moeilijke tekst",43.111111111111114,2,2.3200000000000003,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,14,"Tekst 14","tekst van gemiddelde moeilijkheid",57.111111111111114,1,1.0600000000000005,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,1,"Tekst 1","makkelijke tekst",89,1,-1.8099999999999996,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,2,"Tekst 2","makkelijke tekst",84,1,-1.3599999999999994,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,3,"Tekst 3","tekst van gemiddelde moeilijkheid",73.72,5,-0.43480000000000008,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,4,"Tekst 4","tekst van gemiddelde moeilijkheid",63.07,7,0.52369999999999983,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,5,"Tekst 5","makkelijke tekst",87,1,-1.63,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,6,"Tekst 6","makkelijke tekst",81,3,-1.0899999999999999,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,2014,7,"Tekst 7","tekst van gemiddelde moeilijkheid",62.42,5,0.58220000000000027,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,8,"Tekst 8","tekst van gemiddelde moeilijkheid",67.8,7,9.8000000000000753E-2,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,9,"Tekst 9","makkelijke tekst",92,1,-2.0799999999999992,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,10,"Tekst 10","makkelijke tekst",90,1,-1.8999999999999995,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,11,"Tekst 11","moeilijke tekst",27,1,3.77,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,12,"Tekst 12","tekst van gemiddelde moeilijkheid",59.64,5,0.83240000000000069,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,13,"Tekst 13","tekst van gemiddelde moeilijkheid",71.67,5,-0.2502999999999993,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,14,"Tekst 14","tekst van gemiddelde moeilijkheid",68,2,8.0000000000000071E-2,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,15,"Tekst 15",{"$f":"IF(G45>P$7,\"makkelijke tekst\",IF(G45<P$6,\"moeilijke tekst\",\"tekst van gemiddelde moeilijkheid\"))","v":"tekst van gemiddelde moeilijkheid"},63,1,0.53000000000000025,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,1,"Jeans",{"$f":"IF(G46>P$7,\"makkelijke tekst\",IF(G46<P$6,\"moeilijke tekst\",\"tekst van gemiddelde moeilijkheid\"))","v":"makkelijke tekst"},82.75,1,-1.2474999999999996,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,2,"Fietsen mit Leihrad","tekst van gemiddelde moeilijkheid",53.46,2,1.3886000000000003,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,3,"Ihr Tante-Emma-Laden rettet sie vor dem Ruin","tekst van gemiddelde moeilijkheid",53.6,7,1.3759999999999994,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,4,"Dort arbeiten, wo andere Urlaub machen","tekst van gemiddelde moeilijkheid",64.62,5,0.38419999999999987,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,5,"Tempelhof","tekst van gemiddelde moeilijkheid",47.09,1,1.9619,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,6,"Es ist gar nicht so schwer, die Ausgaben einzudämmen!","tekst van gemiddelde moeilijkheid",65.819999999999993,3,0.27620000000000111,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,7,"Marten hat die Lizenz zum Babysitten","tekst van gemiddelde moeilijkheid",51.25,6,1.5875000000000004,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,8,"So findet man den Beruf, der zu einem passt","tekst van gemiddelde moeilijkheid",46.46,5,2.0186000000000002,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,9,"Auf Facebook gepostet - Kündigung","moeilijke tekst",25.49,1,3.9059000000000004,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,10,"Haltestelle wird aufgegeben","tekst van gemiddelde moeilijkheid",52.74,1,1.4534000000000002,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,11,"Der Spielekönig aus Ostwestfalen","tekst van gemiddelde moeilijkheid",49.58,5,1.7378000000000009,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,12,"Dürfen die das?","tekst van gemiddelde moeilijkheid",48.12,4,1.8692000000000002,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,13,"Zwischen Mischpult und Schulbank","tekst van gemiddelde moeilijkheid",50.46,5,1.6586000000000007,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,14,"Schülerinnen täuschen Entführung vor","tekst van gemiddelde moeilijkheid",66.47,1,0.21769999999999978,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,15,"Zahnpaste in alte Löcher schmieren?","moeilijke tekst",26.69,1,3.7979000000000003,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2016,1,"Am Flughafen wohnen","moeilijke tekst",37.479999999999997,1,2.8268000000000004,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2016,2,"Kanadier bietet Tickets um die Welt an","makkelijke tekst",79.98,2,-0.99820000000000064,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2016,3,"Über-lebens-wichtig","tekst van gemiddelde moeilijkheid",69.2,5,-2.8000000000000469E-2,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2016,4,"Liebesschlösser halten oft länger als die Liebe ","tekst van gemiddelde moeilijkheid",63.73,6,0.4643000000000006,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2016,5,"Blitz-Marathon","tekst van gemiddelde moeilijkheid",57.99,1,0.98090000000000011,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2016,6,"Fürs Praktikum bezahlen","makkelijke tekst",81.8,1,-1.161999999999999,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2016,7,"Lehre in der Imbissbude: Das Döner-Diplom","tekst van gemiddelde moeilijkheid",57.55,5,1.0205000000000011,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2016,8,"Trainierte Ratten riechen Landminen","tekst van gemiddelde moeilijkheid",53.89,6,1.3498999999999999,null,null,null,null,null,null,null,null,{"$f":"IF($K68=\"ü\",$G68,\"\")","v":""},{"$f":"IF($K68=\"ü\",$H68,\"\")","v":""},{"$f":"IF($K68=\"ü\",$I68,\"\")","v":""},{"$f":"IF($K68=\"ü\",$G68*$H68,\"\")","v":""}]
[null,null,2016,9,"Rea Garvey","tekst van gemiddelde moeilijkheid",59.6,2,0.8360000000000003,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2016,10,"Spritdieb","moeilijke tekst",34.68,2,3.0788000000000002,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2016,11,"City-Wheel","moeilijke tekst",35.51,5,3.0041000000000002,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2016,12,"Tekst 12","tekst van gemiddelde moeilijkheid",59.47,1,0.84769999999999968,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2016,13,"Darf jeder Feuerwerk verkaufen?","moeilijke tekst",39.24,7,2.6684000000000001,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2016,14,"Recht auf Reisen","tekst van gemiddelde moeilijkheid",55.63,1,1.1932999999999998,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2017,1,"Liebe Eltern","tekst van gemiddelde moeilijkheid",52.223333333333329,1,1.4999000000000002,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2017,2,"Die reichsten Deutschen","makkelijke tekst",99.043333333333322,1,-2.713899999999998,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2017,3,"Lebensretter auf vier Pfoten","tekst van gemiddelde moeilijkheid",67.813333333333333,6,9.6800000000000885E-2,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2017,4,"Leonard in Brasilien","tekst van gemiddelde moeilijkheid",55.543333333333329,7,1.2011000000000003,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2017,5,"Gochs neue Parkgebühren gelten ab Montag","tekst van gemiddelde moeilijkheid",46.743333333333325,2,1.993100000000001,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2017,6,"Wundersocken","makkelijke tekst",85.373333333333335,1,-1.4836,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2017,7,"Kostenlos, nicht umsonst","tekst van gemiddelde moeilijkheid",58.203333333333326,6,0.96170000000000133,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2017,8,"So ist mein Leben als Leistungssportler","tekst van gemiddelde moeilijkheid",66.403333333333336,7,0.22370000000000001,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2017,9,"Spartipps","moeilijke tekst",21.873333333333331,3,4.2314000000000007,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2017,10,"Kinder reisen stets mit Teddy – und mit Tablet","tekst van gemiddelde moeilijkheid",62.373333333333328,6,0.58640000000000114,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2017,11,"Unser neues Programm","moeilijke tekst",24.013333333333332,1,4.0388000000000002,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2017,12,"Wie werde ich Polizist?","tekst van gemiddelde moeilijkheid",58.443333333333328,6,0.94010000000000016,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2017,13,"Ärztelatein entschlüsselt","moeilijke tekst",36.573333333333331,1,2.9084000000000003,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2018,1,"Ausgerechnet in Deutsch null Punkte","makkelijke tekst",86.333333333333329,1,-1.5699999999999994,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2018,2,"Zwölfjährige läuft einen Halbmarathon","makkelijke tekst",88.333333333333329,1,-1.75,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2018,3,"Minishetty Gijs im Showgeschäft ein „Großer“ ","tekst van gemiddelde moeilijkheid",54.193333333333328,4,1.3226000000000004,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2018,4,"Das Dorf ohne Väter","tekst van gemiddelde moeilijkheid",72.183333333333323,7,-0.29649999999999821,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2018,5,"Urlaubstipps","tekst van gemiddelde moeilijkheid",57.333333333333329,3,1.04,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2018,6,"Etwas Schokolade schadet nicht, sie kann sogar gesund sein","tekst van gemiddelde moeilijkheid",45.833333333333329,3,2.0750000000000011,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2018,7,"Wer Online-Games spielt, hat bessere Schulnoten","moeilijke tekst",41.443333333333328,4,2.4701000000000009,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2018,8,"Made in Germany: Fanta","tekst van gemiddelde moeilijkheid",55.953333333333326,6,1.164200000000001,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2018,9,"Unbekanntes Strandobjekt","makkelijke tekst",84.333333333333329,2,-1.3899999999999997,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2018,10,"Die Draisinen rollen wieder …","tekst van gemiddelde moeilijkheid",56.333333333333329,3,1.1300000000000008,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2018,11,"Ich brauche die Musik","tekst van gemiddelde moeilijkheid",58.293333333333329,5,0.95360000000000067,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2018,12,"Eine Häsin aus Hollywood","tekst van gemiddelde moeilijkheid",63.953333333333326,6,0.44420000000000126,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2018,13,"Stadt ordnet Parkverbot in Wohnstraße an","moeilijke tekst",26.333333333333332,1,3.83,null,null,null,null,null,null,null,null,{"$f":"IF($K100=\"ü\",$G100,\"\")","v":""},{"$f":"IF($K100=\"ü\",$H100,\"\")","v":""},{"$f":"IF($K100=\"ü\",$I100,\"\")","v":""},{"$f":"IF($K100=\"ü\",$G100*$H100,\"\")","v":""}]
[null,null,2018,14,"Zu Hause die Welt entdecken","makkelijke tekst",92.333333333333329,1,-2.1100000000000003,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2019,1,"Verlaufen! Polizei sorgt für Happy End","tekst van gemiddelde moeilijkheid",73.111111111111114,1,-0.37999999999999989,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2019,2,"ETV rockt die Bundesliga","makkelijke tekst",86.111111111111114,1,-1.5499999999999998,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2019,3,"In der Einsamkeit habe ich mein Glück gefunden","tekst van gemiddelde moeilijkheid",55.271111111111111,7,1.2256,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2019,4,"Die Freiheit in der Sardinenbüchse","tekst van gemiddelde moeilijkheid",54.161111111111111,8,1.3254999999999999,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2019,5,"Allianz-Studie","tekst van gemiddelde moeilijkheid",74.111111111111114,1,-0.46999999999999975,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2019,6,"6 Tipps für die heißen Tage","tekst van gemiddelde moeilijkheid",58.111111111111114,3,0.96999999999999975,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2019,7,"Lernt doch, was ihr wollt","tekst van gemiddelde moeilijkheid",45.731111111111112,6,2.0842000000000001,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2019,8,"Der Sozial-Engel von Marzahn","tekst van gemiddelde moeilijkheid",46.931111111111115,9,1.9761999999999995,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2019,9,"Spielzeugpuppe „Cayla“",{"$f":"IF(G110>P$7,\"makkelijke tekst\",IF(G110<P$6,\"moeilijke tekst\",\"tekst van gemiddelde moeilijkheid\"))","v":"makkelijke tekst"},87.771111111111111,2,-1.6994000000000007,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2019,10,"Warum ich keine Schuluniform tragen möchte",{"$f":"IF(G111>P$7,\"makkelijke tekst\",IF(G111<P$6,\"moeilijke tekst\",\"tekst van gemiddelde moeilijkheid\"))","v":"moeilijke tekst"},41.611111111111114,5,2.4550000000000001,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2019,11,"Gewinnspiel",{"$f":"IF(G112>P$7,\"makkelijke tekst\",IF(G112<P$6,\"moeilijke tekst\",\"tekst van gemiddelde moeilijkheid\"))","v":"makkelijke tekst"},79.111111111111114,2,-0.91999999999999993,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2019,12,"Kaugummiverbot",{"$f":"IF(G113>P$7,\"makkelijke tekst\",IF(G113<P$6,\"moeilijke tekst\",\"tekst van gemiddelde moeilijkheid\"))","v":"makkelijke tekst"},82.111111111111114,1,-1.1899999999999995,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2021,1,"Turteltauben aufgepasst!",{"$f":"IF(G114>P$7,\"makkelijke tekst\",IF(G114<P$6,\"moeilijke tekst\",\"tekst van gemiddelde moeilijkheid\"))","v":"tekst van gemiddelde moeilijkheid"},47.00333333333333,1,1.9697000000000005,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2021,2,"Das Ohr","moeilijke tekst",37.103333333333332,5,2.8607,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2021,3,"Es geht um die Wurst","tekst van gemiddelde moeilijkheid",51.25333333333333,6,1.5872000000000002,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2021,4,"Bieber Fever!","tekst van gemiddelde moeilijkheid",76.943333333333328,2,-0.72489999999999988,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2021,5,"Wer kennt diesen Mann?","tekst van gemiddelde moeilijkheid",43.883333333333326,6,2.2505000000000011,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2021,6,"Große Sprünge","tekst van gemiddelde moeilijkheid",58.103333333333332,6,0.97070000000000078,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2021,7,"Schlaue Lampe","makkelijke tekst",90.293333333333322,3,-1.9263999999999983,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2021,8,"Wir im Netz","moeilijke tekst",25.433333333333334,1,3.911,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2021,9,"Der Preis fürs Eis","tekst van gemiddelde moeilijkheid",52.963333333333331,7,1.4333000000000009,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2021,10,"Das Buddy-Programm an der Europaschule","moeilijke tekst",36.18333333333333,5,2.9435000000000002,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2021,11,"Schlafen auf Schienen","tekst van gemiddelde moeilijkheid",49.473333333333329,4,1.7473999999999998,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2021,12,"Großmutters Genüsse",{"$f":"IF(G125>P$7,\"makkelijke tekst\",IF(G125<P$6,\"moeilijke tekst\",\"tekst van gemiddelde moeilijkheid\"))","v":"makkelijke tekst"},78.833333333333329,1,-0.89499999999999957,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2022,1,"Den Fischern fehlen die Fische",{"$f":"IF(G126>P$7,\"makkelijke tekst\",IF(G126<P$6,\"moeilijke tekst\",\"tekst van gemiddelde moeilijkheid\"))","v":"tekst van gemiddelde moeilijkheid"},68.222222222222229,1,6.0000000000000497E-2,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2022,2,"Hier geöffnet, dort geschlossen","tekst van gemiddelde moeilijkheid",63.602222222222224,3,0.47579999999999956,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2022,3,"Soll man alles in Chatgruppen bereden?","tekst van gemiddelde moeilijkheid",74.032222222222231,5,-0.46290000000000031,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2022,4,"Kein Bahnhof ist wie der andere","tekst van gemiddelde moeilijkheid",49.462222222222223,6,1.7484000000000002,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2022,5,"Hier spielt die Musik","makkelijke tekst",88.532222222222231,3,-1.7679000000000009,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2022,6,"Eiskalte Leidenschaft","moeilijke tekst",43.022222222222219,7,2.3280000000000003,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2022,7,"Watt ’n Licht","tekst van gemiddelde moeilijkheid",56.932222222222222,5,1.0761000000000003,null,null,null,null,null,null,null,null,{"$f":"IF($K132=\"ü\",$G132,\"\")","v":""},{"$f":"IF($K132=\"ü\",$H132,\"\")","v":""},{"$f":"IF($K132=\"ü\",$I132,\"\")","v":""},{"$f":"IF($K132=\"ü\",$G132*$H132,\"\")","v":""}]
[null,null,2022,8,"Shoppen ohne Stress","tekst van gemiddelde moeilijkheid",58.932222222222222,3,0.89610000000000056,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2022,9,"Eine Nummer für kranke Menschen","makkelijke tekst",77.802222222222227,2,-0.80220000000000002,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2022,10,"Ruth ist Schäferin aus Leidenschaft","tekst van gemiddelde moeilijkheid",52.602222222222224,6,1.4657999999999998,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2022,11,"Am liebsten würde ich nichts anderes mehr machen","tekst van gemiddelde moeilijkheid",55.682222222222222,5,1.1886000000000001,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2023,1,"Die Papageien-Fahnder","tekst van gemiddelde moeilijkheid",68.222222222222229,2,6.0000000000000497E-2,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2023,2,"Neuer Geldspeicher für Dagobert Duck","tekst van gemiddelde moeilijkheid",60.222222222222214,4,0.78000000000000114,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2023,3,"Ein Auslandsjahr in Europa","tekst van gemiddelde moeilijkheid",58.222222222222229,6,0.96,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2023,4,"Retten statt wegwerfen","tekst van gemiddelde moeilijkheid",67.222222222222229,5,0.15000000000000036,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2023,5,"Kontrolle über 17 Tonnen","tekst van gemiddelde moeilijkheid",59.222222222222214,7,0.87000000000000099,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2023,6,"Keine Lust auf die Feuerwehr","moeilijke tekst",41.222222222222221,1,2.4900000000000002,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2023,7,"Herz-Rasen","makkelijke tekst",80.222222222222229,1,-1.0199999999999996,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2023,8,"Die Zeit nach den Prüfungen","tekst van gemiddelde moeilijkheid",59.222222222222214,6,0.87000000000000099,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2023,9,"Jeden Tag schwimme ich zur Arbeit","tekst van gemiddelde moeilijkheid",52.222222222222221,6,1.5,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2023,10,"Wespen-Alarm in München","tekst van gemiddelde moeilijkheid",45.222222222222221,6,2.13,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2023,11,"Dürfen Kinder bei Freunden alles essen","tekst van gemiddelde moeilijkheid",44.222222222222221,1,2.2200000000000002,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2024,1,"Öffentliche Toiletten","makkelijke tekst",93,2,-2.169999999999999,null,null,null,null,null,null,null,null,{"$f":"IF($K148=\"ü\",$G148,\"\")","v":""},{"$f":"IF($K148=\"ü\",$H148,\"\")","v":""},{"$f":"IF($K148=\"ü\",$I148,\"\")","v":""},{"$f":"IF($K148=\"ü\",$G148*$H148,\"\")","v":""}]
[null,null,2024,2,"Twenty4Tim - Das Interview","tekst van gemiddelde moeilijkheid",60,6,0.79999999999999982,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2024,3,"Happy BÄRsday! Der Goldbär wird 100","tekst van gemiddelde moeilijkheid",49,5,1.79,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2024,4,"Gutes Leben braucht keine Verpackung","tekst van gemiddelde moeilijkheid",52,8,1.5200000000000005,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2024,5,"Luigi fährt ins falsche Rom","tekst van gemiddelde moeilijkheid",48,3,1.88,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2024,6,"So setzen Sie sich in Szene","tekst van gemiddelde moeilijkheid",69,3,-9.9999999999997868E-3,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2024,7,"Genauer als ein Computer","tekst van gemiddelde moeilijkheid",60,6,0.79999999999999982,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2024,8,"Schülerjobs: Wie du dein Taschengeld aufbesserst","tekst van gemiddelde moeilijkheid",68,6,8.0000000000000071E-2,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2024,9,"Brettspiele in der Schule testen","tekst van gemiddelde moeilijkheid",66,6,0.25999999999999979,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2024,10,"Bücher lesen","moeilijke tekst",38,1,2.7800000000000002,null,null,null,null,null,null,null,null,"","","",""]

{"sheet":"geselecteerde teksten","index":1,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[11,4,11,5],[10,4,10,5],[9,4,9,5]]}
[null,"Duits GL/TL"]
[]
[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"]

{"sheet":"omzettingstabel","index":2,"n_rows":6,"n_cols":16,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Vaknaam:",null,null,null,{"$f":"'selecteer de teksten'!B1","v":"Duits GL/TL"}]
[null,"Schaallengte:",null,null,null,0]
[null,"Normeringsterm:",null,null,null,1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"####"]