{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Bilder","VCard2.1","VCard3.0","WiFi","URL","WhatsApp","SozialeMedien","Telefon","Ort","Termin","Etikett_Formular","Text","Tests","Daten"],"not_rendered":{"charts":0,"images":15,"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":"Bilder","index":0,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,0,19]]}
["Hier können beliebig viele Bilder eingfügt werden. Diese können sie dann in die QR-Codes integrieren. Die Grösse und das Format spielen dabei keine Rolle, die Anpassung erfolgt automatisch, wennd der QR-Code erzeugt wird. Die Bilder sollten aber nicht zu gross sein, damit die Dateigrösse nicht zu gross wird. Um diesen Prozess zu erleichtern, ist es sinnvoll, diesen Bildern einen eindeutigen Namen zu geben. \nDazu markeiren sie das Bild und geben den Namen in das Feld links oben (siehe Abbildungen) ein und bestätigrn mit Enter. Damit sie später ihre Auswahl auch treffen können, müssen die Namen der Bilder gespeichert werden.\nDas erfolgt mit dem Butten rechts. Dieser Butten ist natürlich auch auf allen Tabellenblättern vorhanden."]

{"sheet":"VCard2.1","index":1,"n_rows":34,"n_cols":13,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,12,30,22],[14,5,24,9]]}
["\n","BEGIN:VCARD","END:VCARD",null,{"$f":"B1&A1&B3&A1","v":"BEGIN:VCARD\nVERSION:2.1\n"}]
[null,"Es müssen nicht alle Felder ausgefüllt werden",null,null,null,null,null,null,null,null,"Logo",null,"Platz für ein Bild "]
[0,"VERSION:2.1",null,null,{"$f":"IF(LEFT(C34,7)=\"Picture\",REPLACE(C34,1,7,\"Grafik\"),C34)","v":""},null,null,null,null,null,"Kreuz"]
[null,null,null,null,null,null,null,null,null,null,"WiFi"]
[null,"Vorname:",null,null,{"$f":"IF(C5<>\"\",\"FN:\"&C5&IF(C7<>\"\",\" \"&C7&A1,\"\"))","v":false},null,null,null,null,null,"Wandern"]
[null,null,null,null,null,null,null,null,null,null,"Sektgläser"]
[null,"Nachname:",null,null,{"$f":"IF(C7<>\"\",\"N:\"&C7&IF(C5<>\"\",\";\"&C5&A1,\"\"))","v":false}]
[]
[null,"Titel:",null,null,{"$f":"IF(C9<>\"\",\"TITLE:\"&C9&A1,\"\")","v":""}]
[]
[null,"Organisation:",null,null,{"$f":"IF(C11<>\"\",\"ORG:\"&C11&A1,\"\")","v":""}]
[]
[null,"Funktion:",null,null,{"$f":"IF(C13<>\"\",\"ROLE:\"&C13&A1,\"\")","v":""}]
[]
[null,"Telefon (Arbeit):",null,null,{"$f":"IF(C15<>\"\",\"TEL;WORK;VOICE:\"&C15&A1,\"\")","v":""},{"$f":"IF(A3=1,qrcode(CONCATENATE(E1,E5,E7,E9,E11,E13,E15,E17,E19,E27,E29,E31,C1)),\"\")","v":""}]
[]
[null,"Telefon (privat):",null,null,{"$f":"IF(C17<>\"\",\"TEL;HOME;VOICE:\"&C17&A1,\"\")","v":""}]
[]
[null,"Strasse:",null,null,{"$f":"IF(C19<>\"\",\"ADR:;;\"&C19&\" \"&C21&\";\"&C23&\";;\"&C25&A1,\"\")","v":""}]
[]
[null,"Hausnr.:"]
[]
[null,"Ort:"]
[]
[null,"PLZ:"]
[]
[null,"Internet (http):",null,null,{"$f":"IF(C27<>\"\",\"EMAIL;HOME;INTERNET:http://\"&C27&A1,\"\")","v":""}]
[]
[null,"Internet (https):",null,null,{"$f":"IF(C29<>\"\",\"EMAIL;HOME;INTERNET:https://\"&C29&A1,\"\")","v":""},{"$f":"IF(AND(C27<>\"\",C29<>\"\"),\"Hier ist nur ein Eintrag möglich!\",\"\")","v":""}]
[]
[null,"E-Mail:",null,null,{"$f":"IF(C31<>\"\",\"EMAIL;HOME;INTERNET:\"&C31&A1,\"\")","v":""}]
[]
[]
[null,"Bildauswahl (wenn mit Bild ):",""]

{"sheet":"VCard3.0","index":2,"n_rows":34,"n_cols":13,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,12,30,22],[14,5,24,9]]}
["\n","BEGIN:VCARD","VERSION:3.0","END:VCARD",{"$f":"B1&A1&C1&A1","v":"BEGIN:VCARD\nVERSION:3.0\n"}]
[null,"Bis auf die Auswahl des Bildes werden alle Felder von",null,null,null,null,null,null,null,null,"Logo",null,"Platz für ein Bild "]
[0,"VCard2.1 übernommen.",null,null,{"$f":"IF(LEFT(C34,7)=\"Picture\",REPLACE(C34,1,7,\"Grafik\"),C34)","v":""},null,null,null,null,null,"Kreuz"]
[null,null,null,null,null,null,null,null,null,null,"WiFi"]
[null,"Vorname:",{"$f":"IF(VCard2.1!C5<>\"\",VCard2.1!C5,\"\")","v":""},null,{"$f":"IF(C5<>\"\",\"FN:\"&C5&IF(C7<>\"\",\" \"&C7&A1,\"\"))","v":false},null,null,null,null,null,"Wandern"]
[null,null,null,null,null,null,null,null,null,null,"Sektgläser"]
[null,"Nachname:",{"$f":"IF(VCard2.1!C7<>\"\",VCard2.1!C7,\"\")","v":""},null,{"$f":"IF(C7<>\"\",\"N:\"&C7&IF(C5<>\"\",\";\"&C5&A1,\"\"))","v":false}]
[]
[null,"Titel:",{"$f":"IF(VCard2.1!C9<>\"\",VCard2.1!C9,\"\")","v":""},null,{"$f":"IF(C9<>\"\",\"TITLE:\"&C9&A1,\"\")","v":""}]
[]
[null,"Organisation:",{"$f":"IF(VCard2.1!C11<>\"\",VCard2.1!C11,\"\")","v":""},null,{"$f":"IF(C11<>\"\",\"ORG:\"&C11&A1,\"\")","v":""}]
[]
[null,"Funktion:",{"$f":"IF(VCard2.1!C13<>\"\",VCard2.1!C13,\"\")","v":""},null,{"$f":"IF(C13<>\"\",\"ROLE:\"&C13&A1,\"\")","v":""}]
[]
[null,"Telefon (Arbeit):",{"$f":"IF(VCard2.1!C15<>\"\",VCard2.1!C15,\"\")","v":""},null,{"$f":"IF(C15<>\"\",\"TEL;TYPE=WORK,VOICE:\"&C15&A1,\"\")","v":""},{"$f":"IF(A3=1,qrcode(CONCATENATE(E1,E5,E7,E9,E11,E13,E15,E17,E19,E27,E29,E31,D1)),\"\")","v":""}]
[]
[null,"Telefon (privat):",{"$f":"IF(VCard2.1!C17<>\"\",VCard2.1!C17,\"\")","v":""},null,{"$f":"IF(C17<>\"\",\"TEL;TYPE=HOME,VOICE:\"&C17&A1,\"\")","v":""}]
[]
[null,"Strasse:",{"$f":"IF(VCard2.1!C19<>\"\",VCard2.1!C19,\"\")","v":""},null,{"$f":"IF(C19<>\"\",\"ADR;TYPE=HOME:;;\"&C19&\" \"&C21&\";\"&C23&\";;\"&C25&A1,\"\")","v":""}]
[]
[null,"Hausnr.:",{"$f":"IF(VCard2.1!C21<>\"\",VCard2.1!C21,\"\")","v":""}]
[]
[null,"Ort:",{"$f":"IF(VCard2.1!C23<>\"\",VCard2.1!C23,\"\")","v":""}]
[]
[null,"PLZ:",{"$f":"IF(VCard2.1!C25<>\"\",VCard2.1!C25,\"\")","v":""}]
[]
[null,"Internet (http):",{"$f":"IF(VCard2.1!C27<>\"\",VCard2.1!C27,\"\")","v":""},null,{"$f":"IF(C27<>\"\",\"URL:http://\"&C27&A1,\"\")","v":""}]
[]
[null,"Internet (https):",{"$f":"IF(VCard2.1!C29<>\"\",VCard2.1!C29,\"\")","v":""},null,{"$f":"IF(C29<>\"\",\"URL:https://\"&C29&A1,\"\")","v":""},{"$f":"IF(AND(C27<>\"\",C29<>\"\"),\"Hier ist nur ein Eintrag möglich!\",\"\")","v":""}]
[]
[null,"E-Mail:",{"$f":"IF(VCard2.1!C31<>\"\",VCard2.1!C31,\"\")","v":""},null,{"$f":"IF(C31<>\"\",\"EMAIL;TYPE=PREF,INTERNET:\"&C31&A1,\"\")","v":""}]
[]
[]
[null,"Bildauswahl (wenn mit Bild ):",""]

{"sheet":"WiFi","index":3,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,12,30,22],[14,5,24,9]]}
["\n","BEGIN:VCARD",null,null,{"$f":"B1&A1&B2&A1","v":"BEGIN:VCARD\nEs müssen alle Felder ausgefüllt werden:\n"}]
[null,"Es müssen alle Felder ausgefüllt werden:",null,null,null,null,null,null,null,null,null,null,"Platz für ein Bild "]
[0,"WEP",null,null,{"$f":"IF(LEFT(C16,7)=\"Picture\",REPLACE(C16,1,7,\"Grafik\"),C16)","v":"WiFi"}]
[]
[null,"Netzwerk-Name:",null,null,{"$f":"\"WIFI:T:\"&C7&\";S:\"&C5&\";P:\"&C9&\";;\"","v":"WIFI:T:WPA;S:;P:;;"}]
[]
[null,"Netzwerk-Typ:","WPA"]
[]
[null,"Passwort:"]
[]
[null,"Level:","H"]
[]
[null,"Auflösung:","2"]
[]
[null,null,null,null,null,{"$f":"IF(A3=1,qrcode(E5,C11,C13),\"\")","v":""}]
[null,"Bildauswahl (wenn mit Bild ):","WiFi"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"IF(AND(C27<>\"\",C29<>\"\"),\"Hier ist nur ein Eintrag möglich!\",\"\")","v":""}]

{"sheet":"URL","index":4,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,12,30,22],[14,5,24,9]]}
[{"$f":"CHAR(10)","v":"\n"},"BEGIN:VCARD"]
[null,{"$f":"IF(AND(C5<>\"\",C7<>\"\"),\"Es ist nur ein Eintrag möglich!\",\"\")","v":""},null,null,null,null,null,null,null,null,"Logo",null,"Platz für ein Bild "]
[0,null,null,null,{"$f":"IF(LEFT(C14,7)=\"Picture\",REPLACE(C14,1,7,\"Grafik\"),C14)","v":0},null,null,null,null,null,"Kreuz"]
[null,null,null,null,null,null,null,null,null,null,"WiFi"]
[null,"Internet (http):",null,null,{"$f":"IF(C5<>\"\",\"http://\"&C5,IF(C7<>\"\",\"https://\"&C7,\"\"))","v":""},null,null,null,null,null,"Wandern"]
[null,"oder",null,null,null,null,null,null,null,null,"Sektgläser"]
[null,"Internet (https):"]
[]
[null,"Level:","H"]
[]
[null,"Auflösung:","4"]
[]
[]
[null,"Bildauswahl (wenn mit Bild ):"]
[null,null,null,null,null,{"$f":"IF(A3=1,qrcode(E5,C9,C11),\"\")","v":""}]

{"sheet":"WhatsApp","index":5,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,12,30,22],[14,5,24,9],[6,2,13,2]]}
[{"$f":"CHAR(10)","v":"\n"},"BEGIN:VCARD"]
[null,null,null,null,null,null,null,null,null,null,"Logo",null,"Platz für ein Bild "]
[0,null,null,null,{"$f":"IF(LEFT(C21,7)=\"Picture\",REPLACE(C21,1,7,\"Grafik\"),C21)","v":0},null,null,null,null,null,"Kreuz"]
[null,null,null,null,null,null,null,null,null,null,"WiFi"]
[null,"Telefon-Nr. mit Ländervorwahl:",null,null,{"$f":"IF(C5<>\"\",\"https://wa.me/\"&C5,\"\")","v":""},null,null,null,null,null,"Wandern"]
[null,"417612345687",null,null,null,null,null,null,null,null,"Sektgläser"]
[null,"Text",null,null,{"$f":"IF(C7<>\"\",\"?text=\"&SUBSTITUTE(C7,\" \",\"+\"),\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"IF(A3=1,qrcode(E5&E7,C16,C18),\"\")","v":""}]
[null,"Level:","M"]
[]
[null,"Auflösung:","1"]
[]
[]
[null,"Bildauswahl (wenn mit Bild ):"]

{"sheet":"SozialeMedien","index":6,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,12,30,22],[14,5,24,9]]}
[{"$f":"CHAR(10)","v":"\n"},"BEGIN:VCARD"]
[null,{"$f":"IF(AND(C5<>\"\",C7<>\"\"),\"Es ist nur ein Eintrag möglich!\",\"\")","v":""},null,null,null,null,null,null,null,null,"Logo",null,"Platz für ein Bild "]
[0,null,null,null,{"$f":"IF(LEFT(C14,7)=\"Picture\",REPLACE(C14,1,7,\"Grafik\"),C14)","v":0},null,null,null,null,null,"Kreuz"]
[null,null,null,null,null,null,null,null,null,null,"WiFi"]
[null,null,null,null,{"$f":"IF(C5<>\"\",\"http://\"&C5,IF(C7<>\"\",\"https://\"&C7,\"\"))","v":""},null,null,null,null,null,"Wandern"]
[null,null,null,null,null,null,null,null,null,null,"Sektgläser"]
[null,"Username:",null,null,null,null,null,null,null,null,"Picture 4"]
[]
[null,"Level:","H",null,{"$f":"VLOOKUP(E15,D17:E35,2,0)","v":"https://www.facebook.com/"}]
[null,null,null,null,{"$f":"E9&C7&\"/\"","v":"https://www.facebook.com//"}]
[null,"Auflösung:","4"]
[]
[]
[null,"Bildauswahl (wenn mit Bild ):"]
[null,null,null,null,1,{"$f":"IF(A3=1,qrcode(E10,C9,C11),\"\")","v":""}]
[]
[null,"Facebook:",null,1,"https://www.facebook.com/"]
[]
[null,"Instagram:",null,2,"https://www.instagram.com/"]
[]
[null,"Twitter:",null,3,"https://twitter.com/"]
[]
[null,"Linkedin:",null,4,"https://ch.linkedin.com/"]
[]
[null,null,null,5]
[]
[null,null,null,6]
[]
[null,null,null,7]

{"sheet":"Telefon","index":7,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,12,30,22],[14,5,24,9]]}
[{"$f":"CHAR(10)","v":"\n"},"BEGIN:VCARD"]
[null,{"$f":"IF(AND(C5<>\"\",C7<>\"\"),\"Es ist nur ein Eintrag möglich!\",\"\")","v":""},null,null,null,null,null,null,null,null,"Logo",null,"Platz für ein Bild "]
[0,null,null,null,{"$f":"IF(LEFT(C14,7)=\"Picture\",REPLACE(C14,1,7,\"Grafik\"),C14)","v":0},null,null,null,null,null,"Kreuz"]
[null,null,null,null,null,null,null,null,null,null,"WiFi"]
[null,"Telefon:",null,null,{"$f":"IF(C5<>\"\",\"TEL:\"&C5,\"\")","v":""},null,null,null,null,null,"Wandern"]
[null,null,null,null,null,null,null,null,null,null,"Sektgläser"]
[]
[]
[null,"Level:","H"]
[]
[null,"Auflösung:","4"]
[]
[]
[null,"Bildauswahl (wenn mit Bild ):"]
[null,null,null,null,null,{"$f":"IF(A3=1,qrcode(E5,C9,C11),\"\")","v":""}]

{"sheet":"Ort","index":8,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,12,30,22],[14,5,24,9]]}
[{"$f":"CHAR(10)","v":"\n"},"Wenn sie die Angaben kennen, "]
[null,"kann eine Ortsangabe codiert werden.",null,null,null,null,null,null,null,null,"Logo",null,"Platz für ein Bild "]
[0,null,null,null,{"$f":"IF(LEFT(C14,7)=\"Picture\",REPLACE(C14,1,7,\"Grafik\"),C14)","v":0},null,null,null,null,null,"Kreuz"]
[null,null,47.123456699999998,null,null,null,null,null,null,null,"WiFi"]
[null,"Längengrad:",null,null,{"$f":"IF(AND(C5<>\"\",C7<>\"\"),\"GEO:\"&C5&\",\"&C7,\"\")","v":""},null,null,null,null,null,"Wandern"]
[null,null,7.5052113,null,null,null,null,null,null,null,"Sektgläser"]
[null,"Breitengrad:"]
[]
[null,"Level:","H"]
[]
[null,"Auflösung:","4"]
[]
[]
[null,"Bildauswahl (wenn mit Bild ):"]
[null,null,null,null,null,{"$f":"IF(A3=1,qrcode(E5,C9,C11),\"\")","v":""}]

{"sheet":"Termin","index":9,"n_rows":38,"n_cols":13,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,12,30,22],[14,5,24,9]]}
["\r\n","BEGIN:VCARD","ZEICHEN(10)"]
[null,null,null,null,null,null,null,null,null,null,"Logo",null,"Platz für ein Bild "]
[0,"WEP",null,null,{"$f":"IF(LEFT(C26,7)=\"Picture\",REPLACE(C26,1,7,\"Grafik\"),C26)","v":0},null,null,null,null,null,"Kreuz"]
[null,null,null,null,null,null,null,null,null,null,"WiFi"]
[null,"Was:",null,null,{"$f":"\"SUMMARY:\"&IF(C5<>\"\",C5,\"\")","v":"SUMMARY:"},null,null,null,null,null,"Wandern"]
[null,null,null,null,null,null,null,null,null,null,"Sektgläser"]
[null,"Wo:",null,null,{"$f":"\"LOCATION:\"&IF(C7<>\"\",C7,\"\")","v":"LOCATION:"}]
[]
[null,"Beginn (Tag):",null,null,{"$f":"\"DTSTART:\"&IF(C9<>\"\",TEXT(C9,\"JJJJMMTT\")&\"T\"&TEXT(HOUR(C11)-E21,\"0#\")&TEXT(C11,\"mmss\")&\"Z\",22)","v":"DTSTART:22"}]
[]
[null,"Beginn (Uhrzeit):",null,null,{"$f":"TEXT(HOUR(C11)-E21,\"0#\")&TEXT(C11,\"mmss\")&\"Z\"","v":"-010000Z"}]
[]
[null,"Ende (Tag):",null,null,{"$f":"\"DTEND:\"&IF(C13<>\"\",TEXT(C13,\"JJJJMMTT\")&\"T\"&TEXT(HOUR(C15)-E21,\"0#\")&TEXT(C15,\"mmss\")&\"Z\",\"\")","v":"DTEND:"}]
[]
[null,"Ende (Uhrzeit):",null,null,{"$f":"TEXT(HOUR(C15)-E21,\"0#\")&TEXT(C15,\"mmss\")&\"Z\"","v":"-010000Z"},{"$f":"IF(A3=1,qrcode(CONCATENATE(\"BEGIN:VEVENT\"&A1&E5,A1,E7,A1,E9,A1,E13&A1&\"END:VEVENT\"),C21,C23),\"\")","v":""}]
[]
[null,"Zeitzone:","GMT+1 (Bern)",null,{"$f":"VLOOKUP(C17,E37:F40,2)","v":0}]
[]
[null,"Sommerzeit:",null,null,true]
[null,null,null,null,{"$f":"IF(E19=TRUE,1,0)","v":1}]
[null,"Level:","M",null,{"$f":"E17+E20","v":1}]
[]
[null,"Auflösung:","3"]
[]
[]
[null,"Bildauswahl (wenn mit Bild ):"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"GMT+2 ()",2]
[null,null,null,null,"GMT+1 (Bern)",1]
[null,null,null,null,"GMT+0 (London)",0]

{"sheet":"Etikett_Formular","index":10,"n_rows":34,"n_cols":13,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,12,30,22],[14,5,24,9]]}
["\r\n","Es müssen nicht alle Felder ausgefüllt werden. Beim Ausfüllen sollte "]
[null,"oben begonnen werden, ausser man benötigt ein leeres Feld.",null,null,null,null,null,null,null,null,"Logo",null,"Platz für ein Bild "]
[0,"Die Bezeichnungen können geändert werden.",null,null,{"$f":"IF(LEFT(C34,7)=\"Picture\",REPLACE(C34,1,7,\"Grafik\"),C34)","v":0},null,null,null,null,null,"Kreuz"]
[null,"Sie werden nicht in den QR-Code übernommen.",null,null,null,null,null,null,null,null,"WiFi"]
[null,"Artikel-Nr.:",null,null,{"$f":"IF(C5<>\"\",C5,\"\")","v":""},null,null,null,null,null,"Wandern"]
[null,null,null,null,null,null,null,null,null,null,"Sektgläser"]
[null,"Bezeichnung:",null,null,{"$f":"IF(C7<>\"\",C7,\"\")","v":""}]
[]
[null,"Zeichnungs-Nr.:",null,null,{"$f":"IF(C9<>\"\",C9,\"\")","v":""}]
[]
[null,"Zeichnungs-Index:",null,null,{"$f":"IF(C11<>\"\",C11,\"\")","v":""}]
[]
[null,"Charge:",null,null,{"$f":"IF(C13<>\"\",C13,\"\")","v":""}]
[]
[null,"Anzahl:",null,null,{"$f":"IF(C15<>\"\",C15,\"\")","v":""},{"$f":"IF(A3=1,qrcode(CONCATENATE(E5,A1,E7,A1,E9,A1,E11,A1,E13,A1,E15,A1,E17,A1,E19,A1,E21,A1,E23),C26,C28),\"\")","v":""}]
[]
[null,"Bez.1:",null,null,{"$f":"IF(C17<>\"\",C17,\"\")","v":""}]
[]
[null,"Bez.2:",null,null,{"$f":"IF(C19<>\"\",C19,\"\")","v":""}]
[]
["\n","Bez.3:",null,null,{"$f":"IF(C21<>\"\",C21,\"\")","v":""}]
[]
[null,"Bez.4:",null,null,{"$f":"IF(C23<>\"\",C23,\"\")","v":""}]
[]
[]
[null,"Level:","Q"]
[]
[null,"Auflösung:","3"]
[]
[null,"Steuerzeichen:","CrLf"]
[null,"(tennen die Felder)"]
[]
[]
[null,"Bildauswahl (wenn mit Bild ):"]

{"sheet":"Text","index":11,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,12,30,22],[14,5,24,9],[4,2,15,2]]}
[{"$f":"CHAR(10)","v":"\n"},"BEGIN:VCARD"]
[null,{"$f":"IF(AND(C5<>\"\",C7<>\"\"),\"Es ist nur ein Eintrag möglich!\",\"\")","v":""},null,null,null,null,null,null,null,null,"Logo",null,"Platz für ein Bild "]
[0,null,null,null,{"$f":"IF(LEFT(C23,7)=\"Picture\",REPLACE(C23,1,7,\"Grafik\"),C23)","v":0},null,null,null,null,null,"Kreuz"]
[null,null,null,null,null,null,null,null,null,null,"WiFi"]
[null,"Text:",null,null,{"$f":"IF(C5<>\"\",\"http://\"&C5,IF(C7<>\"\",\"htpps://\"&C7,\"\"))","v":""},null,null,null,null,null,"Wandern"]
[null,null,null,null,null,null,null,null,null,null,"Sektgläser"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"IF(A3=1,qrcode(C5,C18,C20),\"\")","v":""}]
[]
[]
[null,"Level:.","M"]
[]
[null,"Auflösung:","-2"]
[]
[]
[null,"Bildauswahl (wenn mit Bild ):"]

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

{"sheet":"Daten","index":13,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Kontrollzahl:",0]
["Benutzer:",null,null,null,null,null,null,null,null,null,"Logo"]
["Anzahl:",0,null,null,null,null,null,null,null,null,"Kreuz"]
["Code:",{"$f":"\"QRG001-0\"&TEXT(LEN(B2),\"0000\")&IF(LEN(B2)>20,1,IF(LEN(B2)>15,2,IF(LEN(B2)>10,3,IF(LEN(B2)>5,2,1))))&\"-0\"&TEXT(CODE(MID(B2,2,1)),\"000\")&\"95-\"&UPPER(MID(B2,LEN(B2),1))&UPPER(MID(B2,2,2))&TEXT(CODE(MID(B2,LEN(B2)-2,1)),\"000\")&\"-\"&UPPER(MID(B2,LEN(B2)/2,1))&TEXT(CODE(MID(B2,LEN(B2)-1,1)),\"000\")&\"45-254\"&TEXT(CODE(MID(B2,1,1)),\"000\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,"WiFi"]
["CodeP:",{"$f":"\"QRGP01-0\"&TEXT(LEN(B2),\"0000\")&IF(LEN(B2)>20,1,IF(LEN(B2)>15,3,IF(LEN(B2)>10,3,IF(LEN(B2)>5,2,1))))&\"-0\"&TEXT(CODE(MID(B2,5,2)),\"000\")&\"17-\"&UPPER(MID(B2,LEN(B2),2))&UPPER(MID(B2,2,2))&TEXT(CODE(MID(B2,LEN(B2)-2,3)),\"000\")&\"-\"&UPPER(MID(B2,LEN(B2)/2,1))&TEXT(CODE(MID(B2,LEN(B2)-1,1)),\"000\")&\"23-976\"&TEXT(CODE(MID(B2,2,2)),\"000\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,"Wandern"]
["Datum:",{"$f":" TODAY()","v":"2021-04-12"},null,null,null,null,null,null,null,null,"Sektgläser"]
["Periode:","2021-04-12",null,null,null,null,null,null,null,null,"Facebook"]
["Tage:",{"$f":"B6-B7","v":0},null,null,null,null,null,null,null,null,"_Name1"]
["Faktor:",{"$f":"IF(AND(B8<31,B3<101),0,1)","v":0},null,null,null,null,null,null,null,null,"_name2"]
["Rest:",{"$f":"30-B8","v":30},null,null,null,null,null,null,null,null,"WhatsAPP"]