{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Start","Erfassung","Rechnung","Einstellungen"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":27,"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":"Start","index":0,"n_rows":24,"n_cols":14,"rows_kept":24,"cut":false,"hidden":false,"merged":[[17,2,18,11],[15,2,16,11],[1,5,4,11],[3,13,3,14],[4,13,4,14],[10,2,11,11],[12,2,13,11]]}
[]
[null,null,null,null,null,"QR-Code Rechnung"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Version"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1.0"]
[]
[]
[]
[]
[]
[null,null,"Basisdaten für QR-Tag Einzahlungsschein erfassen"]
[]
[null,null,"Hier werden die notwendigen Daten für den neuen QR-Einzahlungsschein erfasst."]
[]
[]
[null,null,"Rechnung anzeigen"]
[]
[null,null,"Hier können Sie sich den Einzahlungsschein mit der leeren Rechnung anzeigen lassen. D.h. den Inhalt der Rechnung erfassen Sie oberhalb des Einzahlungsscheins."]
[]
[]
[]
[]
[]
[null,"  © exact construct GmbH"]

{"sheet":"Erfassung","index":1,"n_rows":43,"n_cols":3,"rows_kept":43,"cut":false,"hidden":false,"merged":[[20,0,26,0],[30,0,35,0],[36,0,40,0],[27,0,28,0],[11,0,19,0]]}
[]
[]
[]
[]
[]
[]
[null,"Titel","Basisdaten"]
[]
[null,"QR-Typ ","SPC"]
[null,"Version ","0200"]
[null,"Code ",1]
["Rechnungssteller","Kontonummer Rechnungssteller","CH4431999123000889012"]
[null,"Kontonummer Rechnungssteller",{"$f":"SUBSTITUTE(C12,\" \",\"\")","v":"CH4431999123000889012"}]
[null,"RS – Adress-Typ","S"]
[null,"Name ","Robert Schneider AG"]
[null,"Strasse","Rue du Lac"]
[null,"Nr.","10"]
[null,"PLZ",2501]
[null,"Ort","Biel"]
[null,"Land","CH"]
["Endgültiger Zahlumgsempfänger (vorerst leer)","RE – Adress-Typ "]
[null,"RE – Name "]
[null,"RE -Adresszeile 1"]
[null,"RE – Adresszeile 2"]
[null,"RE – PLZ"]
[null,"RE – Ort"]
[null,"RE – Land"]
["Betrag","Betrag"]
[null,"Währung","CHF"]
[null,"RE– Adress-Typ ","S"]
["Rechnungsempfänger","Name "]
[null,"Strasse"]
[null,"Nr."]
[null,"PLZ"]
[null,"Ort"]
[null,"Land"]
["Rechnungsinformationen","Referenztyp","QRR"]
[null,"Rechnungs-Nr. (SCOR) /ESR-Nr. (QRR)","210000000003139471430009017"]
[null,"Zusätzliche Informationen 1","Order of 15 June 2020"]
[null,"Trailer ","EPD"]
[null,"Zusätzliche Informationen 2","//S1/10/10201409/11/200701/20/140.000-53/30/102673831/31/200615/32/7.7/33/7.7:139.40/40/0:30"]
[null,"AV1 – Parameters "]
[null,"AV2 – Parameters "]

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

{"sheet":"Einstellungen","index":3,"n_rows":52,"n_cols":29,"rows_kept":52,"cut":false,"hidden":true,"merged":[[7,19,41,19],[4,25,4,26],[4,5,4,6],[4,8,4,9],[4,19,4,23],[4,16,4,17]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[null,null,null,null,null,"Placeholders for set file paths. Do not modify.",null,null,"Used for prompts and dialog boxes. Editable.",null,null,null,"Used for selection of Language. Select from dropdown.",null,"Language Place Holder. Do not Edit.",null,"Ussed as QR Header. Do not Edit.",null,null,"Helper for Receipt. Do not Edit.",null,null,null,null,null,"Dropdown For Referenztyp. Editable.",null,null,"Serves as a placeholder to identify if Zahlbar durch is Null or not.\nAutomated."]
[]
[null,null,null,null,null,null,null,null,"Nr","Messages",null,null,"Choose Language",null,"Language",null,"English","German",null,"QR OUTPUT",null,"Header",null,"Content",null,"Referenztyp","Description",null,"is Zahlbar durch empty?"]
[null,"Core Color",null,null,null,"Default Export Path","C:\\Users\\Bryan\\Desktop\\test"," ",1,"Bitte erfassen Sie die benötigten Felder",null,null,"German",null,"German",null,"Receipt","Empfangsschein",null,{"$f":"Erfassung!C9 & CHAR(10) & Erfassung!C10  & CHAR(10) & Erfassung!C11 & CHAR(10) & Erfassung!C13 & CHAR(10) & Erfassung!C14 & CHAR(10) & Erfassung!C15 & CHAR(10) & Erfassung!C16 & CHAR(10) & Erfassung!C17 & CHAR(10) & Erfassung!C18 & CHAR(10) & Erfassung!C19 & CHAR(10) & Erfassung!C20 & CHAR(10) & Erfassung!C21 & CHAR(10) & Erfassung!C22 & CHAR(10) & Erfassung!C23 & CHAR(10) & Erfassung!C24 & CHAR(10) & Erfassung!C25 & CHAR(10) & Erfassung!C26 & CHAR(10) & Erfassung!C27 & CHAR(10) & IF(Erfassung!C28=\"\",\"\",TEXT(Erfassung!C28,\"0.00\")) & CHAR(10) & Erfassung!C29 & CHAR(10) & IF(isZahlbardurchNull,\"\",Erfassung!C30) & CHAR(10) & IF(isZahlbardurchNull,\"\",Erfassung!C31) & CHAR(10) & IF(isZahlbardurchNull,\"\",Erfassung!C32) & CHAR(10) & IF(isZahlbardurchNull,\"\",Erfassung!C33) & CHAR(10) & IF(isZahlbardurchNull,\"\",Erfassung!C34) & CHAR(10) & IF(isZahlbardurchNull,\"\",Erfassung!C35) & CHAR(10) & IF(isZahlbardurchNull,\"\",Erfassung!C36) & CHAR(10) & Erfassung!C37 & CHAR(10) & IF(Erfassung!C37=\"NON\",\"\",Erfassung!C38) & CHAR(10) & Erfassung!C39 & CHAR(10) & Erfassung!C40 & CHAR(10) & Erfassung!C41","v":"SPC\n0200\n1\nCH4431999123000889012\nS\nRobert Schneider AG\nRue du Lac\n10\n2501\nBiel\nCH\n\n\n\n\n\n\n\n\nCHF\n\n\n\n\n\n\n\nQRR\n210000000003139471430009017\nOrder of 15 June 2020\nEPD\n//S1/10/10201409/11/200701/20/140.000-53/30/102673831/31/200615/32/7.7/33/7.7:139.40/40/0:30"},null,{"$f":"IF($M$8=\"English\",Table2[[#This Row],[English]],Table2[[#This Row],[German]])","v":"Empfangsschein"},null,null,null,"QRR","QR-Reference",null,{"$f":"AND(Erfassung!C31=\"\",Erfassung!C32=\"\",Erfassung!C33=\"\",Erfassung!C34=\"\",Erfassung!C35=\"\",Erfassung!C36=\"\")","v":true}]
[null,"Tint/Shade factor",0.17,null,null,null,null,null,2,"Das Dokument konnte nicht gespeichert werden.",null,null,null,null,"English",null,"Account / Payable to","Konto / Zahlbar an",null,null,null,{"$f":"IF($M$8=\"English\",Table2[[#This Row],[English]],Table2[[#This Row],[German]])","v":"Konto / Zahlbar an"},null,{"$f":"LEFT(Erfassung!C13,4) & \" \" &  MID(Erfassung!C13,5,4) & \" \" &  MID(Erfassung!C13,9,4) & \" \" &  MID(Erfassung!C13,13,4) & \" \" &  MID(Erfassung!C13,17,4) & \" \" &  MID(Erfassung!C13,21,4) & (CHAR(10)) & Erfassung!C15 & (CHAR(10)) & Erfassung!C16 & \" \" & Erfassung!C17 & (CHAR(10)) & Erfassung!C18 & \" \" & Erfassung!C19","v":"CH44 3199 9123 0008 8901 2\nRobert Schneider AG\nRue du Lac 10\n2501 Biel"},null,"SCOR","Creditor Reference (ISO 11649)"]
[null,null,null,null,null,null,null,null,3,"Die Datei ist bereits vorhanden. Möchten Sie überschreiben?",null,null,null,null,null,null,"Refference","Referenz",null,null,null,{"$f":"IF($M$8=\"English\",Table2[[#This Row],[English]],Table2[[#This Row],[German]])","v":"Referenz"},null,{"$f":"IF(Erfassung!C37=\"NON\",\"\",TEXT(LEFT(Erfassung!C38,15),\"## ##### ##### ###\") & TEXT(MID(Erfassung!C38,16,12),\"## ##### #####\") & MID(Erfassung!C38,28,50))","v":"21 00000 00003 13947 14300 09017"},null,"NON","ohne Referenz"]
[null,null,null,null,null,null,null,null,4,"Möchten Sie die Farben wirklich wechseln?",null,null,null,null,null,null,"Payable by","Zahlbar durch",null,null,null,{"$f":"IF(isZahlbardurchNull,IF($M$8=\"English\",Q22,R22),\nIF($M$8=\"English\",Table2[[#This Row],[English]],Table2[[#This Row],[German]]))","v":"Zahlbar durch (Name/Addresse)"},null,{"$f":"Erfassung!C31 & CHAR(10) & Erfassung!C32  & \" \" & Erfassung!C33 & CHAR(10) & Erfassung!C34 & \" \" & Erfassung!C35","v":"\n \n "}]
[null,"Shade 3",null,null,null,null,null,null,5,"Möchten Sie diesen Eintrag wirklich löschen.",null,null,null,null,null,null,"Currency","Währung",null,null,null,{"$f":"IF($M$8=\"English\",Table2[[#This Row],[English]],Table2[[#This Row],[German]])","v":"Währung"},null,{"$f":"Erfassung!C29","v":"CHF"}]
[null,"Shade 2",null,null,null,null,null,null,6,"Sender E-Mail ist eingelogt.",null,null,null,null,null,null,"Amount","Betrag",null,null,null,{"$f":"IF($M$8=\"English\",Table2[[#This Row],[English]],Table2[[#This Row],[German]])","v":"Betrag"},null,{"$f":"IF(Erfassung!C28=\"\",\"\",\nTEXT(Erfassung!C28,\"# ##0.00\"))","v":""}]
[null,"Shade 1",null,null,null,null,null,null,7,"Code erfolgreich generiert.",null,null,null,null,null,null,"Acceptance point","Annahmestelle",null,null,null,{"$f":"IF($M$8=\"English\",Table2[[#This Row],[English]],Table2[[#This Row],[German]])","v":"Annahmestelle"}]
[null,"Pure",null,null,null,null,null,null,8,"Seitenansicht ist noch nicht optimiert. Möchten Sie optimieren?",null,null,null,null,null,null,"Payment part","Zahlteil",null,null,null,{"$f":"IF($M$8=\"English\",Table2[[#This Row],[English]],Table2[[#This Row],[German]])","v":"Zahlteil"}]
[null,"Tint 1",null,null,null,null,null,null,9,"Code konnte nicht generiert werden",null,null,null,null,null,null,"Account / Payable to","Konto / Zahlbar an",null,null,null,{"$f":"IF($M$8=\"English\",Table2[[#This Row],[English]],Table2[[#This Row],[German]])","v":"Konto / Zahlbar an"},null,{"$f":"LEFT(Erfassung!C13,4) & \" \" &  MID(Erfassung!C13,5,4) & \" \" &  MID(Erfassung!C13,9,4) & \" \" &  MID(Erfassung!C13,13,4) & \" \" &  MID(Erfassung!C13,17,4) & \" \" &  MID(Erfassung!C13,21,4) & (CHAR(10)) & Erfassung!C15 & (CHAR(10)) & Erfassung!C16 & \" \" & Erfassung!C17 & (CHAR(10)) & Erfassung!C18 & \" \" & Erfassung!C19","v":"CH44 3199 9123 0008 8901 2\nRobert Schneider AG\nRue du Lac 10\n2501 Biel"}]
[null,"Tint 2",null,null,null,null,null,null,10,"Message 10",null,null,null,null,null,null,"Refference","Referenz",null,null,null,{"$f":"IF($M$8=\"English\",Table2[[#This Row],[English]],Table2[[#This Row],[German]])","v":"Referenz"},null,{"$f":"IF(Erfassung!C37=\"NON\",\"\",TEXT(LEFT(Erfassung!C38,15),\"## ##### ##### ###\") & TEXT(MID(Erfassung!C38,16,12),\"## ##### #####\") & MID(Erfassung!C38,28,50))","v":"21 00000 00003 13947 14300 09017"}]
[null,"Tint 3",null,null,null,null,null,null,11,"Der Betrag muss genau zwei Kommastellen enthalten.",null,null,null,null,null,null,"Additional information","Zusätzliche Informationen",null,null,null,{"$f":"IF($M$8=\"English\",Table2[[#This Row],[English]],Table2[[#This Row],[German]])","v":"Zusätzliche Informationen"},null,{"$f":"Erfassung!C39 & CHAR(10) & Erfassung!C41","v":"Order of 15 June 2020\n//S1/10/10201409/11/200701/20/140.000-53/30/102673831/31/200615/32/7.7/33/7.7:139.40/40/0:30"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Payable by","Zahlbar durch",null,null,null,{"$f":"IF(isZahlbardurchNull,IF($M$8=\"English\",Q22,R22),\nIF($M$8=\"English\",Table2[[#This Row],[English]],Table2[[#This Row],[German]]))","v":"Zahlbar durch (Name/Addresse)"},null,{"$f":"Erfassung!C31 & CHAR(10) & Erfassung!C32  & \" \" & Erfassung!C33 & CHAR(10) & Erfassung!C34 & \" \" & Erfassung!C35","v":"\n \n "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Currency","Währung",null,null,null,{"$f":"IF($M$8=\"English\",Table2[[#This Row],[English]],Table2[[#This Row],[German]])","v":"Währung"},null,{"$f":"Erfassung!C29","v":"CHF"}]
[null,"SHEETS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Amount","Betrag",null,null,null,{"$f":"IF($M$8=\"English\",Table2[[#This Row],[English]],Table2[[#This Row],[German]])","v":"Betrag"},null,{"$f":"IF(Erfassung!C28=\"\",\"\",\nTEXT(Erfassung!C28,\"# ##0.00\"))","v":""}]
[null,"Buttons",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Payable by (name/address)","Zahlbar durch (Name/Addresse)",null,null,null,{"$f":"IFERROR(SplitText(Erfassung!C42,0,\":\") & \": \",\"\")","v":""},null,{"$f":"IFERROR(SplitText(Erfassung!C42,1,\":\"),\"\")","v":""}]
[null,"Outline",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(SplitText(Erfassung!C43,0,\":\") & \": \",\"\")","v":""},null,{"$f":"IFERROR(SplitText(Erfassung!C43,1,\":\"),\"\")","v":""}]
[null,"Fill"]
[null,"Font Color"]
[]
[null,"Table Header"]
[null,"Outline"]
[null,"Fill"]
[null,"Font Color"]
[]
[null,"Borders"]
[null,"Outline"]
[]
[null,"Others"]
[null,"Start Page Title"]
[]
[]
[null,"USERFORMS"]
[null,"Main Header"]
[null,"Background Color 1"]
[null,"Background Color 2"]
[null,"Background Color 3"]
[null,"Font Color"]
[]
[null,"List Headers"]
[null,"Background Color"]
[null,"Font Color"]
[]
[null,"Input Fields"]
[null,"Underline Color"]
[null,"Font Color"]