{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Handleiding","Input","Overview","Grafieken","120-360","Blad1"],"not_rendered":{"charts":6,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Handleiding","index":0,"n_rows":45,"n_cols":10,"rows_kept":45,"cut":false,"hidden":false,"merged":[[5,1,5,2],[15,1,15,2],[15,6,15,7]]}
[]
[null,"Naam","Template Resultaten Morphan"]
[null,"Versie",1]
[null,"Omschrijving","Deze excelsheet zet de resultaten uit Morphan om in een overzichtelijk overzicht en weergeeft deze in grafieken. "]
[]
[null,"Inladen input data voor de resultatentabel - Stap 1",null,null,"Kustvaknummer","Kustvaknaam","Toetsing","BKL/HBKL","Toetsjaar"]
[null,null,"1. Definieer het kustvaknummer, kustvaknaam, het toetsingsjaar en of het om de BKL of HBKL gaat in de tabel hiernaast (keuzemenu). Deze informatie is nodig om de juiste bestanden in te lezen. ",null,"15","Noord-Beveland","2021-01-01","BKL",2021]
[null,null,"2. Controleer of de export-bestanden uit Morphan in de juiste map staan, vb kustvak Texel voor toetsjaar 2018: "]
[null,null,"P:\\wvl\\BenO_Kust\\3 Projecten\\Kustlijnzorg\\Programmeren\\Toetsing\\2018\\06_Texel\\Export Morphan_BKL of"]
[null,null," P:\\wvl\\BenO_Kust\\3 Projecten\\Kustlijnzorg\\Programmeren\\Toetsing\\2018\\06_Texel\\Export Morphan_HBKL"]
[null,null,"3. Controleer of de export-bestanden uit Morphan met de juiste naam zijn opgeslagen (format: {kustvaknummer}_{kustvaknaam}_TKL_resultaten_{BKL/HBKL}_{Toetsing}.csv en {kustvaknummer}_{kustvaknaam}_volume_{diep/strand/duin/totaal}_{toetsing}_{BKL/HBKL}.csv, vb kustvak Texel, BKL:"]
[null,null,"Let op: Als je een resultatentabel voor de HBKL wilt maken, moeten de volume bestanden ook in de Eport Morphan_HBKL map staan, anders werkt de excel file niet."]
[null,null,"06_Texel_TKL_resultaten_BKL_1-1-2018.csv, 06_Texel_volume_diep_1-1-2018_BKL.csv, 06_Texel_volume_strand_1-1-2018.csv, 06_Texel_volume_duin_1-1-2018.csv, 06_Texel_volume_totaal_1-1-2018.csv"]
[null,null,"4. Klik op de knop hiernaast om de macro te starten en de resultaten in te laden en te sorteren. "]
[]
[null,"Grafieken gebruiken voor factsheets - Stap 2",null,null,"Beginraai","Eindraai"]
[null,null,"1. Definieer de gewenste raaien voor in de factsheet. ",null,120,360]
[null,null,"2. Zorg dat de beginraai een lagere waarde heeft dan de eindraai"]
[null,null,"3. Klik op de knop naast de invoerlocatie van de raaien. In een nieuw tabblad worden de grafieken gemaakt die je in je factsheet kan plakken. "]
[null,null,"LET OP: Deze optie kan onbeperkt vaak worden gebruikt voor combinaties van raaien. "]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"    "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"                         "]

{"sheet":"Input","index":1,"n_rows":18,"n_cols":80,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"Raai","Bovengrens [m + NAP]","Ondergrens [m + NAP]","Landwaartse grens [m + RSP]","Zeewaartse grens [m + RSP]","CalculatedXMaxSea","CalculatedXMinLand","BKL","Beginjaar (trend)","Eindjaar (trend)","Uitgesloten jaren","Beginjaar (extrapolatie)","Trend [m/jaar]","R2","Tijdstip waarop BKL wordt gepasseerd (datum)","Tijdstip waarop BKL wordt gepasseerd (dag)","Tijdstip waarop BKL wordt gepasseerd (maand)","Tijdstip waarop BKL wordt gepasseerd (jaar)","Jaar waarop BKL wordt doorsneden","XMKL","Opmerkingen","TKL [m + RSP]","TKL [m + RSP]","TKL [m + RSP]","TKL [m + RSP]","TKL [m + RSP]","TKL [m + RSP]","TKL [m + RSP]","Verschil TKL-BKL [m]","Verschil TKL-BKL [m]","Verschil TKL-BKL [m]","Verschil TKL-BKL [m]","Verschil TKL-BKL [m]","Verschil TKL-BKL [m]","Verschil TKL-BKL [m]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-01-01","2022-01-01","2023-01-01","2024-01-01","2025-01-01","2026-01-01","2027-01-01","2021-01-01","2022-01-01","2023-01-01","2024-01-01","2025-01-01","2026-01-01","2027-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
["KV",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021,2022,2023,2024,2025,2026,2027,2021,2022,2023,2024,2025,2026,2027,"KV","Nr","Bovengrens [m+NAP]","Ondergrens [m+NAP]","Landwaartse grens [m+RSP]","Zeewaartse grens [m+RSP]","Beginjaar (trend)","Eindjaar (trend)","Uitgesloten jaren","Trend [m3/m/jaar]","R2","KV","Nr","Bovengrens [m+NAP]","Ondergrens [m+NAP]","Landwaartse grens [m+RSP]","Zeewaartse grens [m+RSP]","Beginjaar (trend)","Eindjaar (trend)","Uitgesloten jaren","Trend [m3/m/jaar]","R2","KV","Nr","Bovengrens [m+NAP]","Ondergrens [m+NAP]","Landwaartse grens [m+RSP]","Zeewaartse grens [m+RSP]","Beginjaar (trend)","Eindjaar (trend)","Uitgesloten jaren","Trend [m3/m/jaar]","R2","KV","Nr","Bovengrens [m+NAP]","Ondergrens [m+NAP]","Landwaartse grens [m+RSP]","Zeewaartse grens [m+RSP]","Beginjaar (trend)","Eindjaar (trend)","Uitgesloten jaren","Trend [m3/m/jaar]","R2"]
[15,"120.00","3.00","-5.90","NaN","800.00","800.00","NaN","247.00",2011,2020,null,2020,"0.63","0.57","NaN","NaN","NaN","NaN","-","281.94",{"$f":"\"- - - - -\"","v":"- - - - -"},"284.11","284.75","285.38","286.01","286.64","287.27","287.90","37.11","37.75","38.38","39.01","39.64","40.27","40.90",15,120,-2,-50,30,800,2011,2020,null,42.24,0.75,15,120,4,-2,30,800,2011,2020,null,-2.31,0.11,15,120,50,4,30,800,2011,2020,null,6.25,0.84,15,120,50,-50,30,800,2011,2020,null,46.18,0.82]
[15,"140.00","3.00","-5.90","NaN","NaN","600.00","NaN","182.00",2011,2020,null,2020,"2.56","0.87","NaN","NaN","NaN","NaN","-","253.41",{"$f":"\"- - - - -\"","v":"- - - - -"},"255.53","258.09","260.66","263.22","265.79","268.35","270.92","73.53","76.09","78.66","81.22","83.79","86.35","88.92",15,140,-2,-50,40,400,2011,2020,null,49.09,0.84,15,140,4,-2,40,400,2011,2020,null,6.37,0.62,15,140,50,4,40,400,2011,2020,null,10.74,0.98,15,140,50,-50,40,400,2011,2020,null,66.2,0.89]
[15,"160.00","3.00","-5.90","NaN","350.00","350.00","NaN","178.00",2011,2018,null,2020,"1.18","0.37","NaN","NaN","NaN","NaN","-","230.31",{"$f":"\"- - - 4 -\"","v":"- - - 4 -"},"231.37","232.54","233.72","234.90","236.07","237.25","238.42","53.37","54.54","55.72","56.90","58.07","59.25","60.42",15,160,-2,-50,15,420,2014,2020,null,7.36,0.38,15,160,4,-2,15,420,2011,2018,null,0.09,0,15,160,50,4,15,420,2011,2020,null,15.1,0.99,15,160,50,-50,15,420,2014,2018,null,-1.03,0.01]
[15,"180.00","3.00","-5.90","NaN","340.00","340.00","NaN","154.00",2014,2018,null,2020,"-5.49","0.97","2023-09-08",8,9,2023,2023,"173.69",{"$f":"\"- - - 4 -\"","v":"- - - 4 -"},"168.75","163.26","157.77","152.28","146.79","141.29","135.80","14.75","9.26","3.77","-1.72","-7.21","-12.71","-18.20",15,180,-2,-50,-30,460,2014,2020,null,42.74,0.78,15,180,4,-2,-30,460,2014,2018,null,-50.3,0.97,15,180,50,4,-30,460,2011,2020,null,6.07,0.94,15,180,50,-50,-30,460,2014,2018,null,-17.510000000000002,0.36]
[15,"200.00","3.00","-5.90","NaN","260.00","260.00","NaN","83.00",2014,2018,null,2020,"-3.94","0.95","2025-09-08",8,9,2025,2025,"105.01",{"$f":"\"- - - 4 -\"","v":"- - - 4 -"},"101.47","97.53","93.59","89.65","85.70","81.76","77.82","18.47","14.53","10.59","6.65","2.70","-1.24","-5.18",15,200,-2,-50,-75,440,2014,2020,null,4.45,0.03,15,200,4,-2,-75,440,2014,2018,null,-33.869999999999997,0.92,15,200,50,4,-75,440,2011,2020,null,0.94,0.66,15,200,50,-50,-75,440,2014,2018,null,-49,0.56000000000000005]
[15,"220.00","3.00","-5.90","NaN","230.00","230.00","NaN","54.00",2014,2018,null,2020,"-1.86","0.70","2027-03-04",4,3,2027,2027,"67.12",{"$f":"\"- - - 4 -\"","v":"- - - 4 -"},"65.45","63.60","61.74","59.89","58.03","56.17","54.32","11.45","9.60","7.74","5.89","4.03","2.17","0.32",15,220,-2,-50,-150,380,2014,2020,null,15.06,0.35,15,220,4,-2,-150,380,2014,2018,null,-21.55,0.9,15,220,50,4,-150,380,2011,2020,null,2.91,0.31,15,220,50,-50,-150,380,2014,2018,null,-5.08,0.01]
[15,"240.00","3.00","-5.90","NaN","270.00","270.00","NaN","43.00",2014,2018,null,2020,"-3.48","0.93","2021-04-21",21,4,2021,2021,"47.19",{"$f":"\"- - - 4 -\"","v":"- - - 4 -"},"44.06","40.58","37.09","33.61","30.13","26.65","23.17","1.06","-2.42","-5.91","-9.39","-12.87","-16.35","-19.83",15,240,-2,-50,-80,340,2014,2020,null,7.21,0.15,15,240,4,-2,-80,340,2014,2018,null,-30.64,0.93,15,240,50,4,-80,340,2011,2020,null,2.61,0.98,15,240,50,-50,-80,340,2014,2018,null,-21.17,0.53]
[15,"260.00","3.00","-5.90","NaN","200.00","200.00","NaN","32.00",2014,2018,null,2020,"-4.65","0.99","Heden",20,4,2020,"-","32.93",{"$f":"\"1 - - 4 -\"","v":"1 - - 4 -"},"28.75","24.10","19.44","14.79","10.14","5.49","0.84","-3.25","-7.90","-12.56","-17.21","-21.86","-26.51","-31.16",15,260,-2,-50,-155,340,2014,2020,null,3.19,0.01,15,260,4,-2,-155,340,2014,2018,null,-37.020000000000003,0.99,15,260,50,4,-155,340,2011,2020,null,1.73,0.76,15,260,50,-50,-155,340,2014,2018,null,-56.18,0.73]
[15,"280.00","3.00","-5.90","NaN","210.00","210.00","NaN","20.00",2014,2018,null,2020,"-3.79","0.93","2022-05-23",23,5,2022,2022,"28.68",{"$f":"\"- - - 4 -\"","v":"- - - 4 -"},"25.27","21.48","17.68","13.89","10.10","6.30","2.51","5.27","1.48","-2.32","-6.11","-9.90","-13.70","-17.49",15,280,-2,-50,-145,320,2014,2020,null,-7.34,0.18,15,280,4,-2,-145,320,2014,2018,null,-28.38,0.97,15,280,50,4,-145,320,2011,2020,null,1.17,0.57999999999999996,15,280,50,-50,-145,320,2014,2018,null,-29.54,0.64]
[15,"300.00","3.00","-5.90","NaN","260.00","260.00","NaN","1.00",2014,2018,null,2020,"-4.78","0.92","2027-05-26",26,5,2027,2027,"35.86",{"$f":"\"- - - 4 -\"","v":"- - - 4 -"},"31.57","26.79","22.01","17.23","12.46","7.68","2.90","30.57","25.79","21.01","16.23","11.46","6.68","1.90",15,300,-2,-50,-400,340,2014,2020,null,-26.93,0.92,15,300,4,-2,-400,340,2014,2018,null,-33.979999999999997,0.92,15,300,50,4,-400,340,2011,2020,null,9.64,0.99,15,300,50,-50,-400,340,2014,2018,null,-58.55,0.94]
[15,"320.00","3.00","-5.90","NaN","290.00","290.00","NaN","-27.00",2014,2018,null,2020,"-2.77","0.88","2049-09-24",24,9,2049,">2031","55.01",{"$f":"\"- - - 4 -\"","v":"- - - 4 -"},"52.52","49.75","46.98","44.21","41.45","38.68","35.91","79.52","76.75","73.98","71.21","68.45","65.68","62.91",15,320,-2,-50,-345,370,2014,2020,null,-0.92,0.02,15,320,4,-2,-345,370,2014,2018,null,-37.950000000000003,0.94,15,320,50,4,-345,370,2011,2020,null,10.3,0.89,15,320,50,-50,-345,370,2014,2018,null,-29.18,0.79]
[15,"340.00","3.00","-5.90","NaN","320.00","320.00","NaN","-39.00",2014,2020,null,2020,"1.51","0.73","NaN","NaN","NaN","NaN","-","66.08",{"$f":"\"- - - - -\"","v":"- - - - -"},"69.71","71.22","72.73","74.24","75.75","77.25","78.76","108.71","110.22","111.73","113.24","114.75","116.25","117.76",15,340,-2,-50,-230,450,2014,2020,null,10.32,0.68,15,340,4,-2,-230,450,2014,2020,null,9.39,0.53,15,340,50,4,-230,450,2011,2020,null,7.16,0.98,15,340,50,-50,-230,450,2014,2020,null,27,0.94]
[15,"360.00","3.00","-5.90","NaN","400.00","400.00","NaN","-53.00",2011,2020,null,2020,"2.15","0.83","NaN","NaN","NaN","NaN","-","92.85",{"$f":"\"- - - - -\"","v":"- - - - -"},"91.59","93.73","95.88","98.02","100.17","102.32","104.46","144.59","146.73","148.88","151.02","153.17","155.32","157.46",15,360,-2,-50,-215,400,2011,2020,null,27.41,0.86,15,360,4,-2,-215,400,2011,2020,null,12.54,0.86,15,360,50,4,-215,400,2011,2020,null,4.91,0.94,15,360,50,-50,-215,400,2011,2020,null,44.86,0.91]

{"sheet":"Overview","index":2,"n_rows":16,"n_cols":45,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Kustvak","Raai","Bovengrens [m+NAP]","Ondergrens [m+NAP]","Landwaartse grens [m+RSP]","Zeewaartse grens [m+RSP]","BKL","Beginjaar(trend)","Eindjaar(trend)","Uitgesloten jaren","Trend [m/jaar]","R2","Tijdstip waarop BKL wordt gepasseerd (datum)","Jaar waarop BKL wordt doorsneden","TKL [m+RSP]","TKL [m+RSP]","TKL [m+RSP]","TKL [m+RSP]","TKL [m+RSP]","Verschil TKL-BKL [m]","Verschil TKL-BKL [m]","Verschil TKL-BKL [m]","Verschil TKL-BKL [m]","Verschil TKL-BKL [m]",null,null,"Volume Diep",null,null,null,null,"Volume Strand",null,null,null,null,"Volume Duin",null,null,null,null,"Volume Totaal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-01-01","2022-01-01","2023-01-01","2024-01-01","2025-01-01","2021-01-01","2022-01-01","2023-01-01","2024-01-01","2025-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,2021,2022,2023,2024,2025,null,null,"Beginjaar (trend)","Eindjaar (trend)","Uitgesloten jaren","Trend [m3/m/jaar]",null,"Beginjaar (trend)","Eindjaar (trend)","Uitgesloten jaren","Trend [m3/m/jaar]",null,"Beginjaar (trend)","Eindjaar (trend)","Uitgesloten jaren","Trend [m3/m/jaar]",null,"Beginjaar (trend)","Eindjaar (trend)","Uitgesloten jaren","Trend [m3/m/jaar]"]
[15,120,3,-5.9,"NaN",800,247,2011,2020,null,0.63,0.56999999999999995,"NaN","-",284.11,284.75,285.38,286.01,286.64,37.11,37.75,38.380000000000003,39.01,39.64,null,null,2011,2020,null,42.24,null,2011,2020,null,-2.31,null,2011,2020,null,6.25,null,2011,2020,null,46.18]
[15,140,3,-5.9,"NaN","NaN",182,2011,2020,null,2.56,0.87,"NaN","-",255.53,258.08999999999997,260.66000000000003,263.22000000000003,265.79000000000002,73.53,76.09,78.66,81.22,83.79,null,null,2011,2020,null,49.09,null,2011,2020,null,6.37,null,2011,2020,null,10.74,null,2011,2020,null,66.2]
[15,160,3,-5.9,"NaN",350,178,2011,2018,null,1.18,0.37,"NaN","-",231.37,232.54,233.72,234.9,236.07,53.37,54.54,55.72,56.9,58.07,null,null,2014,2020,null,7.36,null,2011,2018,null,0.09,null,2011,2020,null,15.1,null,2014,2018,null,-1.03]
[15,180,3,-5.9,"NaN",340,154,2014,2018,null,-5.49,0.97,"2023-09-08",2023,168.75,163.26,157.77000000000001,152.28,146.79,14.75,9.26,3.77,-1.72,-7.21,null,null,2014,2020,null,42.74,null,2014,2018,null,-50.3,null,2011,2020,null,6.07,null,2014,2018,null,-17.510000000000002]
[15,200,3,-5.9,"NaN",260,83,2014,2018,null,-3.94,0.95,"2025-09-08",2025,101.47,97.53,93.59,89.65,85.7,18.47,14.53,10.59,6.65,2.7,null,null,2014,2020,null,4.45,null,2014,2018,null,-33.869999999999997,null,2011,2020,null,0.94,null,2014,2018,null,-49]
[15,220,3,-5.9,"NaN",230,54,2014,2018,null,-1.86,0.7,"2027-03-04",2027,65.45,63.6,61.74,59.89,58.03,11.45,9.6,7.74,5.89,4.03,null,null,2014,2020,null,15.06,null,2014,2018,null,-21.55,null,2011,2020,null,2.91,null,2014,2018,null,-5.08]
[15,240,3,-5.9,"NaN",270,43,2014,2018,null,-3.48,0.93,"2021-04-21",2021,44.06,40.58,37.090000000000003,33.61,30.13,1.06,-2.42,-5.91,-9.39,-12.87,null,null,2014,2020,null,7.21,null,2014,2018,null,-30.64,null,2011,2020,null,2.61,null,2014,2018,null,-21.17]
[15,260,3,-5.9,"NaN",200,32,2014,2018,null,-4.6500000000000004,0.99,"Heden","-",28.75,24.1,19.440000000000001,14.79,10.14,-3.25,-7.9,-12.56,-17.21,-21.86,null,null,2014,2020,null,3.19,null,2014,2018,null,-37.020000000000003,null,2011,2020,null,1.73,null,2014,2018,null,-56.18]
[15,280,3,-5.9,"NaN",210,20,2014,2018,null,-3.79,0.93,"2022-05-23",2022,25.27,21.48,17.68,13.89,10.1,5.27,1.48,-2.3199999999999998,-6.11,-9.9,null,null,2014,2020,null,-7.34,null,2014,2018,null,-28.38,null,2011,2020,null,1.17,null,2014,2018,null,-29.54]
[15,300,3,-5.9,"NaN",260,1,2014,2018,null,-4.78,0.92,"2027-05-26",2027,31.57,26.79,22.01,17.23,12.46,30.57,25.79,21.01,16.23,11.46,null,null,2014,2020,null,-26.93,null,2014,2018,null,-33.979999999999997,null,2011,2020,null,9.64,null,2014,2018,null,-58.55]
[15,320,3,-5.9,"NaN",290,-27,2014,2018,null,-2.77,0.88,"2049-09-24",">2031",52.52,49.75,46.98,44.21,41.45,79.52,76.75,73.98,71.209999999999994,68.45,null,null,2014,2020,null,-0.92,null,2014,2018,null,-37.950000000000003,null,2011,2020,null,10.3,null,2014,2018,null,-29.18]
[15,340,3,-5.9,"NaN",320,-39,2014,2020,null,1.51,0.73,"NaN","-",69.709999999999994,71.22,72.73,74.239999999999995,75.75,108.71,110.22,111.73,113.24,114.75,null,null,2014,2020,null,10.32,null,2014,2020,null,9.39,null,2011,2020,null,7.16,null,2014,2020,null,27]
[15,360,3,-5.9,"NaN",400,-53,2011,2020,null,2.15,0.83,"NaN","-",91.59,93.73,95.88,98.02,100.17,144.59,146.72999999999999,148.88,151.02000000000001,153.16999999999999,null,null,2011,2020,null,27.41,null,2011,2020,null,12.54,null,2011,2020,null,4.91,null,2011,2020,null,44.86]

{"sheet":"Grafieken","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"120-360","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Blad1","index":5,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["02","Schiermonnikoog","2018-01-01","BKL",2018]
["03","Ameland","2019-01-01","HBKL",2019]
["04","Terschelling","2020-01-01",null,2020]
["05","Vlieland","2021-01-01",null,2021]
["06","Texel","2022-01-01",null,2022]
["07","Noord-Holland","2023-01-01",null,2023]
["08","Rijnland","2024-01-01",null,2024]
["09","Delfland","2025-01-01",null,2025]
["10",null,"2026-01-01",null,2026]
["11","Voorne","2027-01-01",null,2027]
["12","Goeree","2028-01-01",null,2028]
["13","Schouwen","2029-01-01",null,2029]
["14",null,"2030-01-01",null,2030]
["15","Noord-Beveland","2031-01-01",null,2031]
["16","Walcheren","2032-01-01",null,2032]
["17","Zeeuws-Vlaanderen","2033-01-01",null,2033]
[null,null,"2034-01-01",null,2034]