{"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":161,"n_cols":21,"rows_kept":161,"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,2011,1,"Tekst 1",{"$f":"IF(G4>P$7,\"makkelijke tekst\",IF(G4<P$6,\"moeilijke tekst\",\"tekst van gemiddelde moeilijkheid\"))","v":"moeilijke tekst"},17,1,4.47,null,null,null,null,null,"gemiddelde",{"$f":"AVERAGE(G4:G162)","v":57.272482419127968},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,"Tekst 2","moeilijke tekst",30,2,3.3,null,null,null,null,null,"standaarddeviatie",{"$f":"STDEVA(G4:G162)","v":17.225005699393858},null,{"$f":"IF($K5=\"ü\",$G5,\"\")","v":""},{"$f":"IF($K5=\"ü\",$H5,\"\")","v":""},{"$f":"IF($K5=\"ü\",$I5,\"\")","v":""},{"$f":"IF($K5=\"ü\",$G5*$H5,\"\")","v":""}]
[null,null,2011,3,"Tekst 3","moeilijke tekst",39,6,2.4900000000000002,null,null,null,null,null,"M-S",{"$f":"P4-P5","v":40.047476719734107},null,"","","",""]
[null,null,2011,4,"Tekst 4","tekst van gemiddelde moeilijkheid",50,7,1.5,null,null,null,null,null,"M+S",{"$f":"P4+P5","v":74.497488118521829},null,"","","",""]
[null,null,2011,5,"Tekst 5","tekst van gemiddelde moeilijkheid",43,1,2.13,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2011,6,"Tekst 6","tekst van gemiddelde moeilijkheid",55,1,1.0499999999999998,null,null,null,null,null,"gewogen P en N",null,null,"","","",""]
[null,null,2011,7,"Tekst 7","tekst van gemiddelde moeilijkheid",48,7,1.6799999999999997,null,null,null,null,null,"totale bijdrage",{"$f":"SUM(U4:U162)","v":0},null,"","","",""]
[null,null,2011,8,"Tekst 8","tekst van gemiddelde moeilijkheid",52,7,1.3200000000000003,null,null,null,null,null,"gem sc",{"$f":"P10/100","v":0},null,"","","",""]
[null,null,2011,9,"Tekst 9","moeilijke tekst",34,1,2.94,null,null,null,null,null,"totale lengte",{"$f":"SUM(S4:S162)","v":0},null,"","","",""]
[null,null,2011,10,"Tekst 10","tekst van gemiddelde moeilijkheid",71,1,-0.38999999999999968,null,null,null,null,null,"9*P",{"$f":"IF(P12=0,0,9*P11/P12)","v":0},null,"","","",""]
[null,null,2011,11,"Tekst 11","moeilijke tekst",34,7,2.94,null,null,null,null,null,"n-term",{"$f":"IF(P12=0,1,6-P13)","v":1},null,"","","",""]
[null,null,2011,12,"Tekst 12","moeilijke tekst",37,4,2.67,null,null,null,null,null,"afgeronde N",{"$f":"ROUND(P14,1)","v":1},null,"","","",""]
[null,null,2011,13,"Tekst 13","tekst van gemiddelde moeilijkheid",68,2,-0.12000000000000011,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2011,14,"Tekst 14","tekst van gemiddelde moeilijkheid",45,1,1.9500000000000002,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2012,1,"Tekst 1",{"$f":"IF(G18>P$7,\"makkelijke tekst\",IF(G18<P$6,\"moeilijke tekst\",\"tekst van gemiddelde moeilijkheid\"))","v":"makkelijke tekst"},88.888888888888886,1,-2,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2012,2,"Tekst 2",{"$f":"IF(G19>P$7,\"makkelijke tekst\",IF(G19<P$6,\"moeilijke tekst\",\"tekst van gemiddelde moeilijkheid\"))","v":"tekst van gemiddelde moeilijkheid"},47.888888888888893,1,1.6899999999999995,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2012,3,"Tekst 3","tekst van gemiddelde moeilijkheid",53.888888888888893,6,1.1499999999999995,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2012,4,"Tekst 4","tekst van gemiddelde moeilijkheid",67.888888888888886,7,-0.11000000000000032,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2012,5,"Tekst 5","tekst van gemiddelde moeilijkheid",73.888888888888886,1,-0.65000000000000036,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2012,6,"Tekst 6","makkelijke tekst",75.888888888888886,1,-0.83000000000000007,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2012,7,"Tekst 7","tekst van gemiddelde moeilijkheid",64.888888888888886,7,0.16000000000000014,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2012,8,"Tekst 8","moeilijke tekst",38.888888888888893,6,2.4999999999999996,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2012,9,"Tekst 9","tekst van gemiddelde moeilijkheid",51.888888888888893,3,1.3299999999999992,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2012,10,"Tekst 10","tekst van gemiddelde moeilijkheid",41.888888888888893,1,2.2299999999999995,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2012,11,"Tekst 11",{"$f":"IF(G28>P$7,\"makkelijke tekst\",IF(G28<P$6,\"moeilijke tekst\",\"tekst van gemiddelde moeilijkheid\"))","v":"moeilijke tekst"},30.888888888888893,6,3.2199999999999993,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2012,12,"Tekst 12","tekst van gemiddelde moeilijkheid",62.888888888888893,5,0.33999999999999986,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2012,13,"Tekst 13","tekst van gemiddelde moeilijkheid",52.888888888888893,1,1.2399999999999993,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,1,"Tekst 1","tekst van gemiddelde moeilijkheid",42.888888888888893,1,2.1399999999999992,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,2,"Tekst 2","tekst van gemiddelde moeilijkheid",70.888888888888886,1,-0.37999999999999989,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,3,"Tekst 3","tekst van gemiddelde moeilijkheid",60.548888888888889,5,0.55059999999999931,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,4,"Tekst 4","makkelijke tekst",74.658888888888896,6,-0.71930000000000049,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,5,"Tekst 5","makkelijke tekst",80.888888888888886,1,-1.2800000000000002,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,6,"Tekst 6","makkelijke tekst",78.888888888888886,1,-1.0999999999999996,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,7,"Tekst 7","tekst van gemiddelde moeilijkheid",55.568888888888893,5,0.99880000000000013,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,8,"Tekst 8","tekst van gemiddelde moeilijkheid",68.578888888888883,8,-0.17209999999999948,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,9,"Tekst 9","makkelijke tekst",79.888888888888886,1,-1.1900000000000004,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,10,"Tekst 10","tekst van gemiddelde moeilijkheid",73.888888888888886,1,-0.65000000000000036,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,11,"Tekst 11","tekst van gemiddelde moeilijkheid",62.068888888888893,7,0.41380000000000017,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,12,"Tekst 12","tekst van gemiddelde moeilijkheid",65.598888888888894,7,9.6099999999998964E-2,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,13,"Tekst 13","tekst van gemiddelde moeilijkheid",40.888888888888893,2,2.3199999999999994,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2013,14,"Tekst 14","tekst van gemiddelde moeilijkheid",54.888888888888893,1,1.0599999999999996,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,1,"Tekst 1","makkelijke tekst",86.777777777777771,1,-1.8099999999999996,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,2,"Tekst 2","makkelijke tekst",81.777777777777771,1,-1.3600000000000003,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,3,"Tekst 3","tekst van gemiddelde moeilijkheid",71.49777777777777,5,-0.43479999999999919,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,4,"Tekst 4","tekst van gemiddelde moeilijkheid",60.847777777777779,7,0.52369999999999983,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,5,"Tekst 5","makkelijke tekst",84.777777777777771,1,-1.63,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,6,"Tekst 6","makkelijke tekst",78.777777777777771,3,-1.0899999999999999,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,7,"Tekst 7","tekst van gemiddelde moeilijkheid",60.19777777777778,5,0.58220000000000027,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,8,"Tekst 8","tekst van gemiddelde moeilijkheid",65.577777777777769,7,9.8000000000000753E-2,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,9,"Tekst 9","makkelijke tekst",89.777777777777771,1,-2.08,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,10,"Tekst 10","makkelijke tekst",87.777777777777771,1,-1.9000000000000004,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,11,"Tekst 11","moeilijke tekst",24.777777777777775,1,3.7700000000000005,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,12,"Tekst 12","tekst van gemiddelde moeilijkheid",57.417777777777779,5,0.83239999999999981,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,13,"Tekst 13","tekst van gemiddelde moeilijkheid",69.447777777777773,5,-0.2502999999999993,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,14,"Tekst 14","tekst van gemiddelde moeilijkheid",65.777777777777771,2,8.0000000000000071E-2,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2014,15,"Tekst 15",{"$f":"IF(G59>P$7,\"makkelijke tekst\",IF(G59<P$6,\"moeilijke tekst\",\"tekst van gemiddelde moeilijkheid\"))","v":"tekst van gemiddelde moeilijkheid"},60.777777777777779,1,0.53000000000000025,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,1,"Jeans",{"$f":"IF(G60>P$7,\"makkelijke tekst\",IF(G60<P$6,\"moeilijke tekst\",\"tekst van gemiddelde moeilijkheid\"))","v":"makkelijke tekst"},80.527777777777771,1,-1.2474999999999996,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,2,"Fietsen mit Leihrad","tekst van gemiddelde moeilijkheid",51.237777777777779,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",51.37777777777778,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",62.397777777777783,5,0.38419999999999987,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,5,"Tempelhof","tekst van gemiddelde moeilijkheid",44.867777777777782,1,1.9618999999999991,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",63.597777777777772,3,0.27620000000000022,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,7,"Marten hat die Lizenz zum Babysitten","tekst van gemiddelde moeilijkheid",49.027777777777779,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",44.237777777777779,5,2.0186000000000002,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,9,"Auf Facebook gepostet - Kündigung","moeilijke tekst",23.267777777777773,1,3.9059000000000004,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,10,"Haltestelle wird aufgegeben","tekst van gemiddelde moeilijkheid",50.517777777777781,1,1.4533999999999994,null,null,null,null,null,null,null,null,{"$f":"IF($K69=\"ü\",$G69,\"\")","v":""},{"$f":"IF($K69=\"ü\",$H69,\"\")","v":""},{"$f":"IF($K69=\"ü\",$I69,\"\")","v":""},{"$f":"IF($K69=\"ü\",$G69*$H69,\"\")","v":""}]
[null,null,2015,11,"Der Spielekönig aus Ostwestfalen","tekst van gemiddelde moeilijkheid",47.357777777777777,5,1.7378,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,12,"Dürfen die das?","tekst van gemiddelde moeilijkheid",45.897777777777776,4,1.8692000000000002,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,13,"Zwischen Mischpult und Schulbank","tekst van gemiddelde moeilijkheid",48.237777777777779,5,1.6585999999999999,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,14,"Schülerinnen täuschen Entführung vor","tekst van gemiddelde moeilijkheid",64.24777777777777,1,0.21770000000000067,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2015,15,"Zahnpaste in alte Löcher schmieren?","moeilijke tekst",24.467777777777776,1,3.7979000000000003,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2016,1,"Am Flughafen wohnen","moeilijke tekst",35.257777777777775,1,2.8268,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2016,2,"Kanadier bietet Tickets um die Welt an","makkelijke tekst",77.757777777777775,2,-0.99819999999999975,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2016,3,"Über-lebens-wichtig","tekst van gemiddelde moeilijkheid",66.977777777777774,5,-2.7999999999999581E-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",61.507777777777775,6,0.4643000000000006,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2016,5,"Blitz-Marathon","tekst van gemiddelde moeilijkheid",55.767777777777781,1,0.98090000000000011,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2016,6,"Fürs Praktikum bezahlen","makkelijke tekst",79.577777777777769,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",55.327777777777776,5,1.0205000000000002,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2016,8,"Trainierte Ratten riechen Landminen","tekst van gemiddelde moeilijkheid",51.667777777777779,6,1.3498999999999999,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2016,9,"Rea Garvey","tekst van gemiddelde moeilijkheid",57.37777777777778,2,0.8360000000000003,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2016,10,"Spritdieb","moeilijke tekst",32.457777777777778,2,3.0787999999999998,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2016,11,"City-Wheel","moeilijke tekst",33.287777777777777,5,3.0041000000000002,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2016,12,"Tekst 12","tekst van gemiddelde moeilijkheid",57.247777777777777,1,0.84769999999999968,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2016,13,"Darf jeder Feuerwerk verkaufen?","moeilijke tekst",37.017777777777781,7,2.6683999999999997,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2016,14,"Recht auf Reisen","tekst van gemiddelde moeilijkheid",53.407777777777781,1,1.1932999999999998,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2017,1,"Liebe Eltern","tekst van gemiddelde moeilijkheid",50.001111111111108,1,1.4999000000000002,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2017,2,"Die reichsten Deutschen","makkelijke tekst",96.821111111111094,1,-2.7138999999999989,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2017,3,"Lebensretter auf vier Pfoten","tekst van gemiddelde moeilijkheid",65.591111111111104,6,9.6800000000000885E-2,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2017,4,"Leonard in Brasilien","tekst van gemiddelde moeilijkheid",53.321111111111108,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",44.521111111111104,2,1.993100000000001,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2017,6,"Wundersocken","makkelijke tekst",83.151111111111106,1,-1.4835999999999991,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2017,7,"Kostenlos, nicht umsonst","tekst van gemiddelde moeilijkheid",55.981111111111105,6,0.96170000000000044,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2017,8,"So ist mein Leben als Leistungssportler","tekst van gemiddelde moeilijkheid",64.181111111111107,7,0.22370000000000001,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2017,9,"Spartipps","moeilijke tekst",19.651111111111106,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",60.151111111111106,6,0.58640000000000114,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2017,11,"Unser neues Programm","moeilijke tekst",21.791111111111107,1,4.0388000000000002,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2017,12,"Wie werde ich Polizist?","tekst van gemiddelde moeilijkheid",56.221111111111107,6,0.94010000000000016,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2017,13,"Ärztelatein entschlüsselt","moeilijke tekst",34.351111111111109,1,2.9084000000000003,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2018,1,"Ausgerechnet in Deutsch null Punkte","makkelijke tekst",84.111111111111114,1,-1.5700000000000003,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2018,2,"Zwölfjährige läuft einen Halbmarathon","makkelijke tekst",86.111111111111114,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",51.971111111111107,4,1.3226000000000004,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2018,4,"Das Dorf ohne Väter","tekst van gemiddelde moeilijkheid",69.961111111111109,7,-0.29649999999999999,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2018,5,"Urlaubstipps","tekst van gemiddelde moeilijkheid",55.111111111111107,3,1.0400000000000009,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",43.611111111111107,3,2.0750000000000006,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2018,7,"Wer Online-Games spielt, hat bessere Schulnoten","moeilijke tekst",39.221111111111107,4,2.4701000000000004,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2018,8,"Made in Germany: Fanta","tekst van gemiddelde moeilijkheid",53.731111111111105,6,1.164200000000001,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2018,9,"Unbekanntes Strandobjekt","makkelijke tekst",82.111111111111114,2,-1.3899999999999997,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2018,10,"Die Draisinen rollen wieder …","tekst van gemiddelde moeilijkheid",54.111111111111107,3,1.1300000000000008,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2018,11,"Ich brauche die Musik","tekst van gemiddelde moeilijkheid",56.071111111111108,5,0.95359999999999978,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2018,12,"Eine Häsin aus Hollywood","tekst van gemiddelde moeilijkheid",61.731111111111105,6,0.44420000000000037,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2018,13,"Stadt ordnet Parkverbot in Wohnstraße an","moeilijke tekst",24.111111111111107,1,3.83,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2018,14,"Zu Hause die Welt entdecken","makkelijke tekst",90.111111111111114,1,-2.1099999999999994,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2019,1,"Verlaufen! Polizei sorgt für Happy End","tekst van gemiddelde moeilijkheid",70.888888888888886,1,-0.37999999999999989,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2019,2,"ETV rockt die Bundesliga","makkelijke tekst",83.888888888888886,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",53.048888888888889,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",51.93888888888889,8,1.3254999999999999,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2019,5,"Allianz-Studie","tekst van gemiddelde moeilijkheid",71.888888888888886,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",55.888888888888893,3,0.96999999999999975,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2019,7,"Lernt doch, was ihr wollt","tekst van gemiddelde moeilijkheid",43.50888888888889,6,2.0841999999999996,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2019,8,"Der Sozial-Engel von Marzahn","tekst van gemiddelde moeilijkheid",44.708888888888893,9,1.9761999999999995,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2019,9,"Spielzeugpuppe „Cayla“",{"$f":"IF(G124>P$7,\"makkelijke tekst\",IF(G124<P$6,\"moeilijke tekst\",\"tekst van gemiddelde moeilijkheid\"))","v":"makkelijke tekst"},85.548888888888882,2,-1.6993999999999998,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2019,10,"Warum ich keine Schuluniform tragen möchte",{"$f":"IF(G125>P$7,\"makkelijke tekst\",IF(G125<P$6,\"moeilijke tekst\",\"tekst van gemiddelde moeilijkheid\"))","v":"moeilijke tekst"},39.388888888888893,5,2.4549999999999996,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2019,11,"Gewinnspiel",{"$f":"IF(G126>P$7,\"makkelijke tekst\",IF(G126<P$6,\"moeilijke tekst\",\"tekst van gemiddelde moeilijkheid\"))","v":"makkelijke tekst"},76.888888888888886,2,-0.91999999999999993,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2019,12,"Kaugummiverbot",{"$f":"IF(G127>P$7,\"makkelijke tekst\",IF(G127<P$6,\"moeilijke tekst\",\"tekst van gemiddelde moeilijkheid\"))","v":"makkelijke tekst"},79.888888888888886,1,-1.1900000000000004,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2021,1,"Turteltauben aufgepasst!",{"$f":"IF(G128>P$7,\"makkelijke tekst\",IF(G128<P$6,\"moeilijke tekst\",\"tekst van gemiddelde moeilijkheid\"))","v":"tekst van gemiddelde moeilijkheid"},44.781111111111109,1,1.9697000000000005,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2021,2,"Das Ohr","moeilijke tekst",34.88111111111111,5,2.8607,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2021,3,"Es geht um die Wurst","tekst van gemiddelde moeilijkheid",49.031111111111109,6,1.5872000000000002,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2021,4,"Bieber Fever!","makkelijke tekst",74.721111111111099,2,-0.72489999999999899,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2021,5,"Wer kennt diesen Mann?","tekst van gemiddelde moeilijkheid",41.661111111111104,6,2.2505000000000006,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2021,6,"Große Sprünge","tekst van gemiddelde moeilijkheid",55.88111111111111,6,0.9706999999999999,null,null,null,null,null,null,null,null,{"$f":"IF($K133=\"ü\",$G133,\"\")","v":""},{"$f":"IF($K133=\"ü\",$H133,\"\")","v":""},{"$f":"IF($K133=\"ü\",$I133,\"\")","v":""},{"$f":"IF($K133=\"ü\",$G133*$H133,\"\")","v":""}]
[null,null,2021,7,"Schlaue Lampe","makkelijke tekst",88.071111111111094,3,-1.9263999999999983,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2021,8,"Wir im Netz","moeilijke tekst",23.211111111111109,1,3.911,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2021,9,"Der Preis fürs Eis","tekst van gemiddelde moeilijkheid",50.74111111111111,7,1.4333,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2021,10,"Das Buddy-Programm an der Europaschule","moeilijke tekst",33.961111111111109,5,2.9435000000000002,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2021,11,"Schlafen auf Schienen","tekst van gemiddelde moeilijkheid",47.251111111111108,4,1.7473999999999998,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2021,12,"Großmutters Genüsse",{"$f":"IF(G139>P$7,\"makkelijke tekst\",IF(G139<P$6,\"moeilijke tekst\",\"tekst van gemiddelde moeilijkheid\"))","v":"makkelijke tekst"},76.611111111111114,1,-0.89499999999999957,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2022,1,"Den Fischern fehlen die Fische",{"$f":"IF(G140>P$7,\"makkelijke tekst\",IF(G140<P$6,\"moeilijke tekst\",\"tekst van gemiddelde moeilijkheid\"))","v":"tekst van gemiddelde moeilijkheid"},66,1,5.9999999999999609E-2,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2022,2,"Hier geöffnet, dort geschlossen","tekst van gemiddelde moeilijkheid",61.38,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",71.81,5,-0.46289999999999942,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2022,4,"Kein Bahnhof ist wie der andere","tekst van gemiddelde moeilijkheid",47.24,6,1.7484000000000002,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2022,5,"Hier spielt die Musik","makkelijke tekst",86.31,3,-1.7679,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2022,6,"Eiskalte Leidenschaft","tekst van gemiddelde moeilijkheid",40.799999999999997,7,2.3280000000000003,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2022,7,"Watt ’n Licht","tekst van gemiddelde moeilijkheid",54.71,5,1.0761000000000003,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2022,8,"Shoppen ohne Stress","tekst van gemiddelde moeilijkheid",56.71,3,0.89610000000000056,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2022,9,"Eine Nummer für kranke Menschen","makkelijke tekst",75.58,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",50.38,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",53.46,5,1.1886000000000001,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2023,1,"Die Papageien-Fahnder","tekst van gemiddelde moeilijkheid",66,2,5.9999999999999609E-2,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2023,2,"Neuer Geldspeicher für Dagobert Duck","tekst van gemiddelde moeilijkheid",57.999999999999993,4,0.78000000000000114,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2023,3,"Ein Auslandsjahr in Europa","tekst van gemiddelde moeilijkheid",56.000000000000007,6,0.95999999999999908,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2023,4,"Retten statt wegwerfen","tekst van gemiddelde moeilijkheid",65,5,0.15000000000000036,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2023,5,"Kontrolle über 17 Tonnen","tekst van gemiddelde moeilijkheid",56.999999999999993,7,0.87000000000000099,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2023,6,"Keine Lust auf die Feuerwehr","moeilijke tekst",39,1,2.4900000000000002,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2023,7,"Herz-Rasen","makkelijke tekst",78,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",56.999999999999993,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",50,6,1.5,null,null,null,null,null,null,null,null,"","","",""]
[null,null,2023,10,"Wespen-Alarm in München","tekst van gemiddelde moeilijkheid",43,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",42,1,2.2200000000000002,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,"####"]