{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Verjaardagskalender"],"not_rendered":{"defined_names":11},"read":"whole","date_system":"1900"}

{"sheet":"Verjaardagskalender","index":0,"n_rows":10,"n_cols":13,"rows_kept":10,"merged":[[0,1,0,8],[1,3,1,4],[1,10,2,10],[1,11,2,12],[1,13,2,13],[5,12,8,12]]}
[null,"   Verjaardagskalender"]
[{"$nulls":3},"Verjaardag",{"$nulls":7},"E-mailbericht aanpassen"]
[null,"Kolom1","Naam","Maand","Dag","E-mail","Telefoon","Notities","E-mail sturen"]
[null,{"$f":"IFERROR(IF(Verjaardagstabel[[#This Row],[E-mail sturen]]<>\"\",1,0),\"\")","v":1},"Naam 1",{"$f":"TEXT(TODAY(),\"mmm\")","v":"apr"},{"$f":"TEXT(TODAY(),\"dd\")","v":"22"},"E-mail","Telefoon","30e verjaardag",{"$f":"IFERROR(IF(CVerjaardag=TODAY(),HYPERLINK(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Emailbasis,CHAR(10),\"%0A\"),\"[e]\",Verjaardagstabel[[#This Row],[E-mail]]),\"[n]\",Verjaardagstabel[[#This Row],[Naam]]),\"e-mail sturen\"),\"\"),\"\")","v":"e-mail sturen"},null,null,"Onderwerp:","Van harte gefeliciteerd!"]
[null,{"$f":"IFERROR(IF(Verjaardagstabel[[#This Row],[E-mail sturen]]<>\"\",1,0),\"\")","v":0},"Naam 2","mrt",28,"E-mail","Telefoon","Houdt van chocolade",{"$f":"IFERROR(IF(CVerjaardag=TODAY(),HYPERLINK(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Emailbasis,CHAR(10),\"%0A\"),\"[e]\",Verjaardagstabel[[#This Row],[E-mail]]),\"[n]\",Verjaardagstabel[[#This Row],[Naam]]),\"e-mail sturen\"),\"\"),\"\")","v":""},null,null,"Aanhef:","Hallo"]
[null,{"$f":"IFERROR(IF(Verjaardagstabel[[#This Row],[E-mail sturen]]<>\"\",1,0),\"\")","v":0},"Naam 3","jan",23,"E-mail","Telefoon","Verzamelt engeltjes",{"$f":"IFERROR(IF(CVerjaardag=TODAY(),HYPERLINK(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Emailbasis,CHAR(10),\"%0A\"),\"[e]\",Verjaardagstabel[[#This Row],[E-mail]]),\"[n]\",Verjaardagstabel[[#This Row],[Naam]]),\"e-mail sturen\"),\"\"),\"\")","v":""},null,null,"Bericht:","Ik hoop dat je een geweldige verjaardag hebt en zou willen dat we vandaag bij elkaar konden zijn!\n\nHartelijke groeten,"]
[]
[]
[]
[{"$nulls":11},"Uw naam:","Voer uw naam in"]