{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Terminplanung","Kunden","Parameter"],"not_rendered":{"charts":0,"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":"Terminplanung","index":0,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Outlook-Termine erstellen"]
[]
["Ansprechpartner","roman@excelblog.ch"]
["Name","Tobler"]
["Vorname","Roman"]
["Geschlecht","Herr"]
[]
["Anschrift","Du","(Du / Sie wählen)"]
["Datum","2019-11-12","(Datum eingeben)"]
["Startzeit","15:00:00","(Startzeit des Termins angeben)",null,null,{"$f":"B9+B10","v":"2019-11-12T15:00:00"}]
["Endzeit","16:00:00","(Endzeit des Termins angeben)",null,null,{"$f":"B9+B11","v":"2019-11-12T16:00:00"}]
["Ort","Zürich","(Ort angeben.)"]
["Projekt/Thema","Excelblog.ch","(Bitte angeben.)"]
[]
[]
[null,"EMAIL:"]
["Betreff:",{"$f":"\"Termin bezüglich \"&B13","v":"Termin bezüglich Excelblog.ch"}]
[]
["Anschrift:",{"$f":"IF(AND(B6=\"Frau\",B8=\"Sie\"),Parameter!B1&\" \"&B4,IF(AND(B6=\"Frau\",B8=\"Du\"),Parameter!B3&\" \"&B5,IF(AND(B6=\"Herr\",B8=\"Sie\"),Parameter!B2&\" \"&B4,IF(AND(B6=\"Herr\",B8=\"Du\"),Parameter!B4&\" \"&B5,\"\"))))","v":"Lieber Roman"}]
[]
["Email Teil A:",{"$f":"IF(B8=\"Du\",\"Hast du am \"&TEXT(B9,\"TT. MMMM JJJJ\")&\" um \"&TEXT(B10,\"hh:mm\")&\" Uhr Zeit?\",\"Haben Sie am \"&TEXT(B9,\"TT. MMMM JJJJ\")&\" um \"&TEXT(B10,\"hh:mm\")&\" Uhr Zeit?\")","v":"Hast du am 12. November 2019 um 15:00 Uhr Zeit?"}]
[]
["Email Teil B:",{"$f":"IF(B8=\"Du\",\"Gerne möchte ich mich mit dir zum Thema '\"&B13&\"' in \"&B12&\" treffen.\",\"Gerne möchte ich mich mit Ihnen zum Thema '\"&B13&\"' in \"&B12&\" treffen.\")","v":"Gerne möchte ich mich mit dir zum Thema 'Excelblog.ch' in Zürich treffen."}]
[]
["Email Teil C:",{"$f":"IF(B8=\"Du\",\"Ich freue mich auf deine Rückmeldung.\",\"Ich freue mich auf Ihre Rückmeldung.\")","v":"Ich freue mich auf deine Rückmeldung."}]
[]
["Gruss:","Freundliche Grüsse"]
[null,"Max Muster"]

{"sheet":"Kunden","index":1,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Kundennummer","Firma","Ansprechpartner","Name","Vorname","Geschlecht"]
[10001,"Muster AG","max.muster@muster.ch","Muster","Max","Herr"]
[10002,"Firma XY","xy@xyzabc.com","NACHNAME","VORNAME","Herr"]
[10003,"Roman Tobler - Excelblog.ch","roman@excelblog.ch","Tobler","Roman","Herr"]
[10004,"Test GmbH","nthalberg@testgmbh.com","Thalberg","Nicole","Frau"]

{"sheet":"Parameter","index":2,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Du","Sehr geehrte Frau","Roman"]
["Sie","Sehr geehrter Herr","Roman Tobler"]
[null,"Liebe"]
[null,"Lieber"]