{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Datenbank","Suche","Geburtstag","Beschreibung","Hilfstabelle Dropdown"],"not_rendered":{"charts":0,"images":7,"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":"Datenbank","index":0,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
[]
["* kein Feld darf leer bleiben(beim Speichern wird im leeren Feld ein Punkt gemacht)!",null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(Datenban[Kundennr.])","v":10}]
["Kundennr.","Anrede","Vorname","Nachname","Geburtsdatum","Adresse","PLZ","Ort","Telefonnummer","E-Mail","Anmerkungen"]
[1,"Herr","Joel","Kaiser","1948-06-11","Dorfstrasse 205",8834,"Blasenwil","079 xxx xx xx","deine _mail_adresse@provider.ch","Hier gibt man seine Persönlichen Anmerkungen ein, so wie man möchte…"]
[2,"Frau","Morisa","Mayer","1952-12-18","Stadtstrasse 30",4788,"Duisburg","078 xxx xx xx","m.mayeronivo@probe.ch","Bekannte 1"]
[3,"Frau","Clarissa","Neureuther","1984-07-31","Im Gehegen 47",3656,"Belandria","079 xxx xx xx","c_neur@prov.ch","Bekannte 2"]
[4,"Herr","Marius","Maronni","1959-05-13","Schürcherweg 99",7788,"Lugano","076 xxx xx xx","blbla@huihuich","Bekannte B"]
[5,"Frau","Giselle","Blatter","1933-11-29","Schmirweg 44",2323,"Dallenwil","056 xxx xx xx","g.blatter@gmxx.ch","Bekannte 4"]
[6,"Herr","Gander","Gluwins","1935-07-03","Grubenweg C1",9632,"Tahlwil","079 xxx xx xx","iaolla@gluewins.ch","Bekannte C"]
[7,"Frau","Laurina","Gluwins","2001-02-22","Grubenweg C2",9632,"Tahlwil","098 xxx xx xx","L.aolla@gluewins.ch","Bekannte 3"]
[8,"Herr","Flavio","Dorner","1910-12-24","Kalbermattenstr. 4",5478,"Davos","099 324 45 78","f.dorner@anbieter.de","Bekannte D"]
[9,"Frau","Erika","Huber","1997-08-13","Haus 3",5522,"Tägerig","079 305 38 57","info@huber3.ch","Bekannte 5"]
[10,"Herr","Jonas","Galliker","1966-06-06","Blumenstrasse 44",2222,"Nirgendwo","022 254 44 55","nirgendwer@nixwo.ch","."]

{"sheet":"Suche","index":1,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Suchformular"]
[]
[{"$f":"TRANSPOSE(Datenban[#Headers])","v":"Kundennr."}]
["Anrede"]
["Vorname"]
["Nachname","Gluwins"]
["Geburtsdatum"]
["Adresse"]
["PLZ"]
["Ort"]
["Telefonnummer"]
["E-Mail"]
["Anmerkungen"]
[]
[]
[]
[{"$f":"Datenban[#Headers]","v":"Kundennr."},"Anrede","Vorname","Nachname","Geburtsdatum","Adresse","PLZ","Ort","Telefonnummer","E-Mail","Anmerkungen"]
[{"$f":"_xlfn._xlws.FILTER(Datenban[#Data],(B3=Datenban[Kundennr.])+(B4=Datenban[Anrede])+(B5=Datenban[Vorname])+(B6=Datenban[Nachname])+(B7=Datenban[Geburtsdatum])+(B8=Datenban[Adresse])+(B9=Datenban[PLZ])+(B10=Datenban[Ort])+(B11=Datenban[Telefonnummer])+(B12=Datenban[E-Mail])+(B13=Datenban[Anmerkungen]),\"\")","v":6},"Herr","Gander","Gluwins","1935-07-03","Grubenweg C1",9632,"Tahlwil","079 xxx xx xx","iaolla@gluewins.ch","Bekannte C"]
[7,"Frau","Laurina","Gluwins","2001-02-22","Grubenweg C2",9632,"Tahlwil","098 xxx xx xx","L.aolla@gluewins.ch","Bekannte 3"]

{"sheet":"Geburtstag","index":2,"n_rows":201,"n_cols":19,"rows_kept":201,"cut":false,"hidden":false,"merged":[[0,12,0,16],[0,0,0,8]]}
["Geburtstage",null,null,null,null,null,null,null,null,null,null,null,"Runde Geburtstage werden\nFarblich gezeichnet!"]
["*Hier bitte nichts ändern!",null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(Datenban[Kundennr.])","v":10},null,{"$f":"NOW()","v":"2024-04-28T15:10:56.090"},null,null,{"$f":"EDATE(M2,12)","v":"2025-04-28"},"folge\nJahr"]
[{"$f":"Datenbank!A3:K13","v":"Kundennr."},"Anrede","Vorname","Nachname","Geburtsdatum","Adresse","PLZ","Ort","Telefonnummer","E-Mail","Anmerkungen",null,"Alter \nAktuell","nächster\nGeburtag","Geb in \neinem Jahr","wird!","wird!",null,"Mail an:"]
[1,"Herr","Joel","Kaiser","1948-06-11","Dorfstrasse 205",8834,"Blasenwil","079 xxx xx xx","deine _mail_adresse@provider.ch","Hier gibt man seine Persönlichen Anmerkungen ein, so wie man möchte…",null,{"$f":"IF(E4>0,IFERROR(YEAR(NOW())-YEAR(E4),\"\"),\"\")","v":76},{"$f":"IFERROR(IF(DATE(YEAR(TODAY()),MONTH(E4),DAY(E4))<TODAY(),DATE(YEAR(TODAY())+1,MONTH(E4),DAY(E4)),DATE(YEAR(TODAY()),MONTH(E4),DAY(E4))),\"\")","v":"2024-06-11"},{"$f":"IF(E4>0,EDATE(E4,-12*1),\"\")","v":"1947-06-11"},{"$f":"IF(E4>0,IFERROR(YEAR(N4)-YEAR(E4),\"\"),\"\")","v":76},{"$f":"IF(E4>0,IFERROR(YEAR(NOW())-YEAR(O4),\"\"),\"\")","v":77},null,{"$f":"IF(J4>0,HYPERLINK(\"mailto:\"&J4, \"Email-senden\"),\"\")","v":"Email-senden"}]
[2,"Frau","Morisa","Mayer","1952-12-18","Stadtstrasse 30",4788,"Duisburg","078 xxx xx xx","m.mayeronivo@probe.ch","Bekannte 1",null,{"$f":"IF(E5>0,IFERROR(YEAR(NOW())-YEAR(E5),\"\"),\"\")","v":72},{"$f":"IFERROR(IF(DATE(YEAR(TODAY()),MONTH(E5),DAY(E5))<TODAY(),DATE(YEAR(TODAY())+1,MONTH(E5),DAY(E5)),DATE(YEAR(TODAY()),MONTH(E5),DAY(E5))),\"\")","v":"2024-12-18"},{"$f":"IF(E5>0,EDATE(E5,-12*1),\"\")","v":"1951-12-18"},{"$f":"IF(E5>0,IFERROR(YEAR(N5)-YEAR(E5),\"\"),\"\")","v":72},{"$f":"IF(E5>0,IFERROR(YEAR(NOW())-YEAR(O5),\"\"),\"\")","v":73},null,{"$f":"IF(J5>0,HYPERLINK(\"mailto:\"&J5, \"Email-senden\"),\"\")","v":"Email-senden"}]
[3,"Frau","Clarissa","Neureuther","1984-07-31","Im Gehegen 47",3656,"Belandria","079 xxx xx xx","c_neur@prov.ch","Bekannte 2",null,40,"2024-07-31","1983-07-31",40,41,null,"Email-senden"]
[4,"Herr","Marius","Maronni","1959-05-13","Schürcherweg 99",7788,"Lugano","076 xxx xx xx","blbla@huihuich","Bekannte B",null,65,"2024-05-13","1958-05-13",65,66,null,"Email-senden"]
[5,"Frau","Giselle","Blatter","1933-11-29","Schmirweg 44",2323,"Dallenwil","056 xxx xx xx","g.blatter@gmxx.ch","Bekannte 4",null,91,"2024-11-29","1932-11-29",91,92,null,"Email-senden"]
[6,"Herr","Gander","Gluwins","1935-07-03","Grubenweg C1",9632,"Tahlwil","079 xxx xx xx","iaolla@gluewins.ch","Bekannte C",null,89,"2024-07-03","1934-07-03",89,90,null,"Email-senden"]
[7,"Frau","Laurina","Gluwins","2001-02-22","Grubenweg C2",9632,"Tahlwil","098 xxx xx xx","L.aolla@gluewins.ch","Bekannte 3",null,23,"2025-02-22","2000-02-22",24,24,null,"Email-senden"]
[8,"Herr","Flavio","Dorner","1910-12-24","Kalbermattenstr. 4",5478,"Davos","099 324 45 78","f.dorner@anbieter.de","Bekannte D",null,114,"2024-12-24","1909-12-24",114,115,null,"Email-senden"]
[9,"Frau","Erika","Huber","1997-08-13","Haus 3",5522,"Tägerig","079 305 38 57","info@huber3.ch","Bekannte 5",null,27,"2024-08-13","1996-08-13",27,28,null,"Email-senden"]
[10,"Herr","Jonas","Galliker","1966-06-06","Blumenstrasse 44",2222,"Nirgendwo","022 254 44 55","nirgendwer@nixwo.ch",".",null,58,"2024-06-06","1965-06-06",58,59,null,"Email-senden"]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E69>0,IFERROR(YEAR(NOW())-YEAR(E69),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DATE(YEAR(TODAY()),MONTH(E69),DAY(E69))<TODAY(),DATE(YEAR(TODAY())+1,MONTH(E69),DAY(E69)),DATE(YEAR(TODAY()),MONTH(E69),DAY(E69))),\"\")","v":"2024-12-31"},{"$f":"IF(E69>0,EDATE(E69,-12*1),\"\")","v":""},{"$f":"IF(E69>0,IFERROR(YEAR(N69)-YEAR(E69),\"\"),\"\")","v":""},{"$f":"IF(E69>0,IFERROR(YEAR(NOW())-YEAR(O69),\"\"),\"\")","v":""},null,{"$f":"IF(J69>0,HYPERLINK(\"mailto:\"&J69, \"Email-senden\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E133>0,IFERROR(YEAR(NOW())-YEAR(E133),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DATE(YEAR(TODAY()),MONTH(E133),DAY(E133))<TODAY(),DATE(YEAR(TODAY())+1,MONTH(E133),DAY(E133)),DATE(YEAR(TODAY()),MONTH(E133),DAY(E133))),\"\")","v":"2024-12-31"},{"$f":"IF(E133>0,EDATE(E133,-12*1),\"\")","v":""},{"$f":"IF(E133>0,IFERROR(YEAR(N133)-YEAR(E133),\"\"),\"\")","v":""},{"$f":"IF(E133>0,IFERROR(YEAR(NOW())-YEAR(O133),\"\"),\"\")","v":""},null,{"$f":"IF(J133>0,HYPERLINK(\"mailto:\"&J133, \"Email-senden\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E167>0,IFERROR(YEAR(NOW())-YEAR(E167),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DATE(YEAR(TODAY()),MONTH(E167),DAY(E167))<TODAY(),DATE(YEAR(TODAY())+1,MONTH(E167),DAY(E167)),DATE(YEAR(TODAY()),MONTH(E167),DAY(E167))),\"\")","v":"2024-12-31"},"",{"$f":"IF(E167>0,IFERROR(YEAR(N167)-YEAR(E167),\"\"),\"\")","v":""},"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E168>0,IFERROR(YEAR(NOW())-YEAR(E168),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DATE(YEAR(TODAY()),MONTH(E168),DAY(E168))<TODAY(),DATE(YEAR(TODAY())+1,MONTH(E168),DAY(E168)),DATE(YEAR(TODAY()),MONTH(E168),DAY(E168))),\"\")","v":"2024-12-31"},"",{"$f":"IF(E168>0,IFERROR(YEAR(N168)-YEAR(E168),\"\"),\"\")","v":""},"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31",{"$f":"IF(E197>0,EDATE(E197,-12*1),\"\")","v":""},"",{"$f":"IF(E197>0,IFERROR(YEAR(NOW())-YEAR(O197),\"\"),\"\")","v":""},null,{"$f":"IF(J197>0,HYPERLINK(\"mailto:\"&J197, \"Email-senden\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","2024-12-31","","","",null,""]

{"sheet":"Beschreibung","index":3,"n_rows":88,"n_cols":16,"rows_kept":88,"cut":false,"hidden":false,"merged":[[37,0,37,16],[66,0,66,16],[84,0,84,16]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"© 2024 by mablu"]
[null,"DATENBANK",null,null,null,null,null,null,null,null,null,null,null,null,null,"www.mablu.ch"]
[null,"Das ist die Hauptseite, hier werden die Neuen Kunden eingetragen!"]
[null,"Kunden Nr. um 1 erhöhen und unterhalb eingeben, dann wird die"]
[null,"Liste Automatisch um eine Zeile erweitert! (in allen Blättern!!!"]
[null,"Alle Adressen werden nur auf dieser Seite eingetragen!"]
[null,"Bitte keine Spalten hinzufügen oder löschen!"]
[null,"Die Überschriften darf man ändern! Im Blatt Datenbank!"]
[]
[]
[]
[]
[]
[null,"Eingabe mit Maske:"]
[null,"Den Button Eingabe-Maske drücken dann erscheint das Menue"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Um einen Meuen Satz zu erzeugen muss man Neu drücken vorher bitte die Nr. merken und um 1 erhöhen oder leer lassen und später eingeben!"]
[null,"Bei allen Feldern die Leer gelassen werden wird beim Speichern ein (.) Punkt eingefügt, damit die Tabelle richtig Funktioniert!"]
[]
[]
[null,"Suche von Adressen:"]
[]
[null,"Durch diese Auswahl kann mann nach Adressen Suchen!"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Geburtstage:"]
[]
[null,"Auf dieser Seite siehr man alle Geburtstage die Runden sind Farblich gekennzeichnet"]
[null,"Runde Geburtstage:   20 | 30 | 40 | 50 | 60 | 65 | 70 | 80"]
[null,"sowie das Folgejahr hier sind ebenfalls die Runden Farblich gezeichnet!"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Jetzt viel Spass mit dieser Liste!"]

{"sheet":"Hilfstabelle Dropdown","index":4,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[{"$f":"Datenban[#Headers]","v":"Kundennr."},"Anrede","Vorname","Nachname","Geburtsdatum","Adresse","PLZ","Ort","Telefonnummer","E-Mail","Anmerkungen"]
[{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(Datenban[Kundennr.]))","v":1},{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(Datenban[Anrede]))","v":"Frau"},{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(Datenban[Vorname]))","v":"Clarissa"},{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(Datenban[Nachname]))","v":"Blatter"},{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(Datenban[Geburtsdatum]))","v":"1910-12-24"},{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(Datenban[Adresse]))","v":"Blumenstrasse 44"},{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(Datenban[PLZ]))","v":2222},{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(Datenban[Ort]))","v":"Belandria"},{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(Datenban[Telefonnummer]))","v":"022 254 44 55"},{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(Datenban[E-Mail]))","v":"blbla@huihuich"},{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(Datenban[Anmerkungen]))","v":"."}]
[2,"Herr","Erika","Dorner","1933-11-29","Dorfstrasse 205",2323,"Blasenwil","056 xxx xx xx","c_neur@prov.ch","Bekannte 1"]
[3,null,"Flavio","Galliker","1935-07-03","Grubenweg C1",3656,"Dallenwil","076 xxx xx xx","deine _mail_adresse@provider.ch","Bekannte 2"]
[4,null,"Gander","Gluwins","1948-06-11","Grubenweg C2",4788,"Davos","078 xxx xx xx","f.dorner@anbieter.de","Bekannte 3"]
[5,null,"Giselle","Huber","1952-12-18","Haus 3",5478,"Duisburg","079 305 38 57","g.blatter@gmxx.ch","Bekannte 4"]
[6,null,"Joel","Kaiser","1959-05-13","Im Gehegen 47",5522,"Lugano","079 xxx xx xx","iaolla@gluewins.ch","Bekannte 5"]
[7,null,"Jonas","Maronni","1966-06-06","Kalbermattenstr. 4",7788,"Nirgendwo","098 xxx xx xx","info@huber3.ch","Bekannte B"]
[8,null,"Laurina","Mayer","1984-07-31","Schmirweg 44",8834,"Tägerig","099 324 45 78","L.aolla@gluewins.ch","Bekannte C"]
[9,null,"Marius","Neureuther","1997-08-13","Schürcherweg 99",9632,"Tahlwil",null,"m.mayeronivo@probe.ch","Bekannte D"]
[10,null,"Morisa",null,"2001-02-22","Stadtstrasse 30",null,null,null,"nirgendwer@nixwo.ch","Hier gibt man seine Persönlichen Anmerkungen ein, so wie man möchte…"]