{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Blad1","Blad2","Blad3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Blad1","index":0,"n_rows":46,"n_cols":65,"rows_kept":46,"cut":false,"hidden":false,"merged":[[8,2,8,13],[7,2,7,25],[5,2,5,11],[5,16,5,53],[14,2,14,23],[14,24,14,26],[14,27,14,28],[14,29,14,30],[14,31,14,32],[14,34,14,35],[14,36,14,37],[14,38,14,39],[14,40,14,41],[6,16,6,53],[8,16,8,53],[7,26,7,53],[16,38,16,39],[16,40,16,41],[13,36,13,37],[15,36,15,37],[16,36,16,37],[13,24,13,26],[15,24,15,26],[16,24,16,26],[13,2,13,23],[11,2,11,23],[12,2,12,23],[13,38,13,39],[13,40,13,41],[15,38,15,39],[15,40,15,41],[15,2,15,23],[16,2,16,23],[12,40,12,41],[11,24,11,26],[12,24,12,26],[16,27,16,28],[16,29,16,30],[16,31,16,32],[13,27,13,28],[13,29,13,30],[13,31,13,32],[15,27,15,28],[15,29,15,30],[15,31,15,32],[12,38,12,39],[13,34,13,35],[15,34,15,35],[16,34,16,35],[12,27,12,28],[12,29,12,30],[12,31,12,32],[12,34,12,35],[12,36,12,37],[4,62,4,63],[4,64,4,65],[11,27,11,28],[11,29,11,30],[11,31,11,32],[4,50,4,51],[4,52,4,53],[4,54,4,55],[4,56,4,57],[4,58,4,59],[4,60,4,61],[4,38,4,39],[4,40,4,41],[4,42,4,43],[4,44,4,45],[4,46,4,47],[4,48,4,49],[4,26,4,27],[4,28,4,29],[4,30,4,31],[4,32,4,33],[4,34,4,35],[4,36,4,37],[11,34,11,35],[11,36,11,37],[11,38,11,39],[11,40,11,41],[3,48,3,49],[3,50,3,51],[3,52,3,53],[3,54,3,55],[3,56,3,57],[3,34,3,35],[3,36,3,37],[3,38,3,39],[3,40,3,41],[3,42,3,43],[3,44,3,45],[3,22,3,23],[3,24,3,25],[3,26,3,27],[3,28,3,29],[3,30,3,31],[3,32,3,33],[3,10,3,11],[3,12,3,13],[3,14,3,15],[3,16,3,17],[3,18,3,19],[3,20,3,21],[3,2,3,3],[3,4,3,5],[3,6,3,7],[3,8,3,9],[4,14,4,15],[4,16,4,17],[4,18,4,19],[4,20,4,21],[4,22,4,23],[4,24,4,25],[3,58,3,59],[3,60,3,61],[3,62,3,63],[3,64,3,65],[4,2,4,3],[4,4,4,5],[4,6,4,7],[4,8,4,9],[4,10,4,11],[4,12,4,13],[3,46,3,47]]}
[]
[null,"2024-10-15",null,null,2024]
[null,null,null,null,{"$f":"TEXT(E4,\"mmmm\")","v":"oktober"}]
[null,"Werknemer","2024-09-30",null,"2024-10-01",null,"2024-10-02",null,"2024-10-03",null,"2024-10-04",null,"2024-10-05",null,"2024-10-06",null,"2024-10-07",null,"2024-10-08",null,"2024-10-09",null,"2024-10-10",null,"2024-10-11",null,"2024-10-12",null,"2024-10-13",null,"2024-10-14",null,"2024-10-15",null,"2024-10-16",null,"2024-10-17",null,"2024-10-18",null,"2024-10-19",null,"2024-10-20",null,"2024-10-21",null,"2024-10-22",null,"2024-10-23",null,"2024-10-24",null,"2024-10-25",null,"2024-10-26",null,"2024-10-27",null,"2024-10-28",null,"2024-10-29",null,"2024-10-30",null,"2024-10-31"]
[null,null,{"$f":"TEXT(C4,\"dddd\")","v":"maandag"},null,{"$f":"TEXT(E4,\"dddd\")","v":"dinsdag"},null,{"$f":"TEXT(G4,\"dddd\")","v":"woensdag"},null,{"$f":"TEXT(I4,\"dddd\")","v":"donderdag"},null,{"$f":"TEXT(K4,\"dddd\")","v":"vrijdag"},null,"zaterdag",null,"zondag",null,"maandag",null,"dinsdag",null,"woensdag",null,"donderdag",null,"vrijdag",null,"zaterdag",null,"zondag",null,"maandag",null,"dinsdag",null,"woensdag",null,"donderdag",null,"vrijdag",null,"zaterdag",null,"zondag",null,"maandag",null,"dinsdag",null,"woensdag",null,"donderdag",null,"vrijdag",null,"zaterdag",null,"zondag",null,"maandag",null,"dinsdag",null,"woensdag",null,"donderdag"]
[null,"Jan","X-Floor",null,null,null,null,null,null,null,null,null,null,null,null,null,"Peeters"]
[null,"Paul",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Peeters"]
[null,"Frans","De Bock",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Peeters"]
[null,"Alex","Van Geit",null,null,null,null,null,null,null,null,null,null,null,null,null,"Peeters"]
[]
[]
[null,"Klant","Opdracht",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plaats",null,null,"Start",null,"Einde",null,"Dagen",null,"Man","Persoon 1",null,"Persoon 2",null,"Persoon 3",null,"Persoon 4"]
[null,"X-Floor","Badkamer in structuur",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lede",null,null,"2024-09-30",null,"2024-10-04",null,{"$f":"AD13-AB13","v":4},null,1,"Jan",null,null,null,null,null,null,null,"Ctrl+Q"]
[null,"Peeters","Appartement volledig schilderen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zottegem",null,null,"2024-10-07",null,"2024-10-25",null,{"$f":"AD14-AB14","v":18},null,4,"Jan",null,"Paul",null,"Alex",null,null,null,"Ctrl+Q"]
[null,"Peeters","Appartement volledig schilderen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zottegem",null,null,"2024-10-14",null,"2024-10-25",null,{"$f":"AD15-AB15","v":11},null,1,"Frans",null,null,null,null,null,null,null,"Ctrl+Q"]
[null,"De Bock","Gevel schilderen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"strijpen",null,null,"2024-09-30",null,"2024-10-11",null,11,null,2,"Frans",null,null,null,null,null,null,null,"Ctrl+Q"]
[null,"Van Geit","Ramen Schilderen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evergem",null,null,"2024-09-30",null,"2024-10-05",null,5,null,1,"Alex",null,null,null,null,null,null,null,"Ctrl+Q"]
[]
[]
[]
[null,null,null,null,null,"Iedere klant krijgt een verschillende kleur."]
[null,null,null,null,null,"Na het invullen van de startdatum en einddatum, en beslist is wie het werk gaat uitvoeren wil ik in de rij waar die naam staat (in B6 tot B9) dat de overeenkomstige datums 'samengevoegd en gecentreed' worden met de kleur en de naam van de specifieke klant."]
[null,null,null,null,null,"Dit na het activeren van de macro in de cellen AQ13, AQ14,AQ15,AQ16 en AQ17 met als naam van de macro ctrl+Q"]
[null,null,null,null,null,"Deze planning is handmatig ingevuld, ik had daar graag een macro voor, hopelijk is dit mogelijk."]
[]
[null,null,null,null,"Voorbeeld 1"]
[null,null,null,null,null,"In B13, X- floor = kleur geel"]
[null,null,null,null,null,"Start: 30 sept"]
[null,null,null,null,null,"Einde: 4 okt"]
[null,null,null,null,null,"Persoon (1) = Jan"]
[]
[null,null,null,null,null,null,"Bedoeling:  In de rij van 'Jan' (B6) vanaf 30/9 tot 4/10 de cellen samenvoegen en centreren met in deze samengevoegde cellen de tekst en kleur uit B13"]
[]
[null,null,null,null,"Voorbeeld 2"]
[]
[null,null,null,null,null,"In B14 en B15 staat Peeters, in twee cellen om dat één van de vier personen later begint"]
[]
[null,null,null,null,null,"In B14, Peeters = kleur blauw"]
[null,null,null,null,null,"Start :","7 okt "]
[null,null,null,null,null,"Einde: 25 okt"]
[null,null,null,null,null,"Personen (3) = Jan, Paul en Alex"]
[]
[null,null,null,null,null,null,"Bedoeling: In de rij van 'Jan' (B6) vanaf 7/10 tot 25/10 de cellen samenvoegen en centreren met in deze samengevoegde cellen de tekst en kleur uit B14"]
[null,null,null,null,null,null,"En dit ook voor de rij van 'Paul' (B7) en de rij van 'Alex' (B9)"]
[]
[null,null,null,null,null,"Peeters in B15 komt overeen met voorbeeld 1"]

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

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