{"text_format":"3","workbook":"xlsx","n_sheets":11,"sheets":["Buchung","Daten","Anordnung","Formular","Steuerkennzeichen","Seite 2","xRechnung","Rechtsformen","Länder","Kontierungsobjekte","Maßeinheiten"],"not_rendered":{"images":1,"external_links":1,"defined_names":79,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Buchung","index":0,"n_rows":19,"n_cols":34,"rows_kept":19,"hidden":true}
["Belegnummer","Beleg-ID der Kopfdaten","Buchungskreis","Belegart","Belegdatum","Buchungsdatum","Buchungsperiode","Referenz","Belegkopftext","Position","Hauptbuchkonto","Text","Zuordnung","Zahlweg","Steuerkennzeichen","Soll/Haben-Kennz.","Betrag Hauswähr","Steuer Hauswährung","Geschäftsbereich","Kostenstelle","Auftrag","PSP-Element","Fonds","Kreditor","Debitor","Kontoart","Name 1","Name 2","Straße","Postleitzahl","Ort","Land","IBAN","SWIFT/BIC"]
[{"$f":"IF(OR($Q2=0,$Q2=\"\"),\"nicht buchen\",\"\")","v":"nicht buchen"},1,"1000",{"$f":"IF($P$2=\"H\",\"DG\",\"DR\")","v":"DR"},{"$f":"Formular!$G$36","v":"2024-08-27"},{"$f":"E2","v":"2024-08-27"},{"$f":"MONTH(F2)","v":8},{"$f":"MID(YEAR(Formular!$G$36),3,2)&IF(LEN(Formular!$W$38)=7,\"000\",\"\")&Formular!$W$38&CHOOSE(LEN(Formular!$AF$38),\"000\",\"00\",\"0\",\"\")&Formular!$AF$38","v":"2400035005100000"},"Ausgangsrechnung","1",null,{"$f":"\"*\"&MID(Daten!$E$89,1,45)","v":"*"},{"$f":"IF(Daten!$X$65=\"\",H2,CHOOSE(Daten!$V$65,\"PSP \"&Daten!$E$65,\"KST \"&Daten!$E$65,\"IA \"&Daten!$E$65))","v":"2400035005100000"},null,null,{"$f":"IF((SUMIF(P3:P9,\"H\",Q3:S9)-SUMIF(P3:P9,\"S\",Q3:S9))<0,\"H\",\"S\")","v":"S"},{"$f":"MAX(Formular!$AE$72,-Formular!$AE$72)","v":0},{"$nulls":7},{"$f":"Formular!$F$20","v":""},"D",{"$f":"IF(AND(Daten!$V$16=2,$Y2=\"602326\"),Daten!$E$18,\"\")","v":""},{"$f":"IF(AND(Daten!$V$16=2,$Y2=\"602326\"),Daten!$E$19,\"\")","v":""},{"$f":"IF(AND(Daten!$V$16=2,$Y2=\"602326\"),Daten!$E$25&\" \"&Daten!$L$25,\"\")","v":""},{"$f":"IF(AND(Daten!$V$16=2,$Y2=\"602326\"),Daten!$E$27,\"\")","v":""},{"$f":"IF(AND(Daten!$V$16=2,$Y2=\"602326\"),Daten!$H$27,\"\")","v":""},{"$f":"IF(AND(Daten!$V$16=2,$Y2=\"602326\"),Daten!$N$29,\"\")","v":""}]
["nicht buchen",1,"1000",{"$f":"$D2","v":"DR"},{"$f":"E2","v":"2024-08-27"},{"$f":"F2","v":"2024-08-27"},{"$f":"MONTH(F3)","v":8},{"$f":"H2","v":"2400035005100000"},"Ausgangsrechnung",2,{"$f":"Formular!$F$21","v":0},{"$f":"IF(Anordnung!$C$41=\"\",\"\",Anordnung!$C$41)&VLOOKUP($J3-1,Daten!$E$95:$R$114,2,FALSE)","v":""},{"$f":"IF(Daten!$X$65=\"\",H3,CHOOSE(Daten!$V$65,\"PSP \"&Daten!$E$65,\"KST \"&Daten!$E$65,\"IA \"&Daten!$E$65))","v":"2400035005100000"},null,{"$f":"IF(ISNA(VLOOKUP($J3-1,Formular!$B$50:$AJ$69,35,FALSE)),\"\",IF(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),\"AI\",CHOOSE(VLOOKUP($J3-1,Formular!$B$50:$AJ$69,35,FALSE),Formular!$A$11,Formular!$A$12,Formular!$A$13,Formular!$A$14,Formular!$A$15,Formular!$A$16,Formular!$A$17,Formular!$A$18)))","v":""},{"$f":"IF(VLOOKUP($J3-1,Daten!$E$95:$R$114,14,FALSE)<0,\"S\",\"H\")","v":"H"},{"$f":"ROUND(MAX(VLOOKUP($J3-1,Daten!$E$95:$R$114,14,FALSE),-VLOOKUP($J3-1,Daten!$E$95:$R$114,14,FALSE))/IF(OR(Daten!$X$96=\"X\",$O3=\"\"),1,1+IF(MID($O3,2,1)=\"1\",19%,IF(MID($O3,2,1)=\"2\",7%,IF(MID($O3,2,1)=\"E\",16%,IF(MID($O3,2,1)=\"Z\",5%,0%))))),2)","v":0},{"$f":"ROUND(IF(MID($O3,2,1)=\"1\",$Q3*0.19,IF(MID($O3,2,1)=\"2\",$Q3*0.07,IF(MID($O3,2,1)=\"E\",$Q3*0.16,IF(MID($O3,2,1)=\"Z\",$Q3*0.05,0)))),2)","v":0},null,{"$f":"IF(Daten!$X$65=\"\",CHOOSE(Daten!$V$65,\"\",Daten!$E$65,\"\"),\"\")","v":""},{"$f":"IF(Daten!$X$65=\"\",CHOOSE(Daten!$V$65,\"\",\"\",Daten!$E$65),\"\")","v":""},{"$f":"IF(Daten!$X$65=\"\",CHOOSE(Daten!$V$65,Daten!$E$65,\"\",\"\"),Daten!$X$65)","v":0},{"$f":"IF(Daten!$X$65=\"\",CHOOSE(Daten!$V$65,\"\",Daten!$L$65,\"\"),\"\")","v":""},null,null,"S"]
["nicht buchen",1,"1000",{"$f":"$D2","v":"DR"},{"$f":"E2","v":"2024-08-27"},{"$f":"F2","v":"2024-08-27"},8,{"$f":"H2","v":"2400035005100000"},"Ausgangsrechnung",3,{"$f":"K3","v":0},{"$f":"IF(Anordnung!$C$41=\"\",\"\",Anordnung!$C$41)&VLOOKUP($J4-1,Daten!$E$95:$R$114,2,FALSE)","v":""},{"$f":"IF(Daten!$X$65=\"\",H4,CHOOSE(Daten!$V$65,\"PSP \"&Daten!$E$65,\"KST \"&Daten!$E$65,\"IA \"&Daten!$E$65))","v":"2400035005100000"},null,{"$f":"IF(ISNA(VLOOKUP($J4-1,Formular!$B$50:$AJ$69,35,FALSE)),\"\",IF(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),\"AI\",CHOOSE(VLOOKUP($J4-1,Formular!$B$50:$AJ$69,35,FALSE),Formular!$A$11,Formular!$A$12,Formular!$A$13,Formular!$A$14,Formular!$A$15,Formular!$A$16,Formular!$A$17,Formular!$A$18)))","v":""},{"$f":"IF(VLOOKUP($J4-1,Daten!$E$95:$R$114,14,FALSE)<0,\"S\",\"H\")","v":"H"},{"$f":"ROUND(MAX(VLOOKUP($J4-1,Daten!$E$95:$R$114,14,FALSE),-VLOOKUP($J4-1,Daten!$E$95:$R$114,14,FALSE))/IF(OR(Daten!$X$96=\"X\",$O4=\"\"),1,1+IF(MID($O4,2,1)=\"1\",19%,IF(MID($O4,2,1)=\"2\",7%,IF(MID($O4,2,1)=\"E\",16%,IF(MID($O4,2,1)=\"Z\",5%,0%))))),2)","v":0},{"$f":"ROUND(IF(MID($O4,2,1)=\"1\",$Q4*0.19,IF(MID($O4,2,1)=\"2\",$Q4*0.07,IF(MID($O4,2,1)=\"E\",$Q4*0.16,IF(MID($O4,2,1)=\"Z\",$Q4*0.05,0)))),2)","v":0},null,{"$f":"T3","v":""},{"$f":"U3","v":""},{"$f":"V3","v":0},{"$f":"W3","v":""},null,null,"S"]
["nicht buchen",1,"1000",{"$f":"$D2","v":"DR"},{"$f":"E2","v":"2024-08-27"},{"$f":"F2","v":"2024-08-27"},8,{"$f":"H2","v":"2400035005100000"},"Ausgangsrechnung",4,{"$f":"K3","v":0},{"$f":"IF(Anordnung!$C$41=\"\",\"\",Anordnung!$C$41)&VLOOKUP($J5-1,Daten!$E$95:$R$114,2,FALSE)","v":""},{"$f":"IF(Daten!$X$65=\"\",H5,CHOOSE(Daten!$V$65,\"PSP \"&Daten!$E$65,\"KST \"&Daten!$E$65,\"IA \"&Daten!$E$65))","v":"2400035005100000"},null,{"$f":"IF(ISNA(VLOOKUP($J5-1,Formular!$B$50:$AJ$69,35,FALSE)),\"\",IF(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),\"AI\",CHOOSE(VLOOKUP($J5-1,Formular!$B$50:$AJ$69,35,FALSE),Formular!$A$11,Formular!$A$12,Formular!$A$13,Formular!$A$14,Formular!$A$15,Formular!$A$16,Formular!$A$17,Formular!$A$18)))","v":""},{"$f":"IF(VLOOKUP($J5-1,Daten!$E$95:$R$114,14,FALSE)<0,\"S\",\"H\")","v":"H"},{"$f":"ROUND(MAX(VLOOKUP($J5-1,Daten!$E$95:$R$114,14,FALSE),-VLOOKUP($J5-1,Daten!$E$95:$R$114,14,FALSE))/IF(OR(Daten!$X$96=\"X\",$O5=\"\"),1,1+IF(MID($O5,2,1)=\"1\",19%,IF(MID($O5,2,1)=\"2\",7%,IF(MID($O5,2,1)=\"E\",16%,IF(MID($O5,2,1)=\"Z\",5%,0%))))),2)","v":0},0,null,{"$f":"T3","v":""},{"$f":"U3","v":""},{"$f":"V3","v":0},{"$f":"W3","v":""},null,null,"S"]
["nicht buchen",1,"1000",{"$f":"$D2","v":"DR"},{"$f":"E2","v":"2024-08-27"},{"$f":"F2","v":"2024-08-27"},8,{"$f":"H2","v":"2400035005100000"},"Ausgangsrechnung",5,{"$f":"K3","v":0},{"$f":"IF(Anordnung!$C$41=\"\",\"\",Anordnung!$C$41)&VLOOKUP($J6-1,Daten!$E$95:$R$114,2,FALSE)","v":""},{"$f":"IF(Daten!$X$65=\"\",H6,CHOOSE(Daten!$V$65,\"PSP \"&Daten!$E$65,\"KST \"&Daten!$E$65,\"IA \"&Daten!$E$65))","v":"2400035005100000"},null,{"$f":"IF(ISNA(VLOOKUP($J6-1,Formular!$B$50:$AJ$69,35,FALSE)),\"\",IF(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),\"AI\",CHOOSE(VLOOKUP($J6-1,Formular!$B$50:$AJ$69,35,FALSE),Formular!$A$11,Formular!$A$12,Formular!$A$13,Formular!$A$14,Formular!$A$15,Formular!$A$16,Formular!$A$17,Formular!$A$18)))","v":""},{"$f":"IF(VLOOKUP($J6-1,Daten!$E$95:$R$114,14,FALSE)<0,\"S\",\"H\")","v":"H"},{"$f":"ROUND(MAX(VLOOKUP($J6-1,Daten!$E$95:$R$114,14,FALSE),-VLOOKUP($J6-1,Daten!$E$95:$R$114,14,FALSE))/IF(OR(Daten!$X$96=\"X\",$O6=\"\"),1,1+IF(MID($O6,2,1)=\"1\",19%,IF(MID($O6,2,1)=\"2\",7%,IF(MID($O6,2,1)=\"E\",16%,IF(MID($O6,2,1)=\"Z\",5%,0%))))),2)","v":0},0,null,{"$f":"T3","v":""},{"$f":"U3","v":""},{"$f":"V3","v":0},{"$f":"W3","v":""},null,null,"S"]
["nicht buchen",1,"1000",{"$f":"$D2","v":"DR"},{"$f":"E2","v":"2024-08-27"},{"$f":"F2","v":"2024-08-27"},8,{"$f":"H2","v":"2400035005100000"},"Ausgangsrechnung",6,{"$f":"K3","v":0},{"$f":"IF(Anordnung!$C$41=\"\",\"\",Anordnung!$C$41)&VLOOKUP($J7-1,Daten!$E$95:$R$114,2,FALSE)","v":""},{"$f":"IF(Daten!$X$65=\"\",H7,CHOOSE(Daten!$V$65,\"PSP \"&Daten!$E$65,\"KST \"&Daten!$E$65,\"IA \"&Daten!$E$65))","v":"2400035005100000"},null,{"$f":"IF(ISNA(VLOOKUP($J7-1,Formular!$B$50:$AJ$69,35,FALSE)),\"\",IF(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),\"AI\",CHOOSE(VLOOKUP($J7-1,Formular!$B$50:$AJ$69,35,FALSE),Formular!$A$11,Formular!$A$12,Formular!$A$13,Formular!$A$14,Formular!$A$15,Formular!$A$16,Formular!$A$17,Formular!$A$18)))","v":""},{"$f":"IF(VLOOKUP($J7-1,Daten!$E$95:$R$114,14,FALSE)<0,\"S\",\"H\")","v":"H"},{"$f":"ROUND(MAX(VLOOKUP($J7-1,Daten!$E$95:$R$114,14,FALSE),-VLOOKUP($J7-1,Daten!$E$95:$R$114,14,FALSE))/IF(OR(Daten!$X$96=\"X\",$O7=\"\"),1,1+IF(MID($O7,2,1)=\"1\",19%,IF(MID($O7,2,1)=\"2\",7%,IF(MID($O7,2,1)=\"E\",16%,IF(MID($O7,2,1)=\"Z\",5%,0%))))),2)","v":0},0,null,{"$f":"T3","v":""},{"$f":"U3","v":""},{"$f":"V3","v":0},{"$f":"W3","v":""},null,null,"S"]
["nicht buchen",1,"1000",{"$f":"$D2","v":"DR"},{"$f":"E2","v":"2024-08-27"},"2024-08-27",8,{"$f":"H2","v":"2400035005100000"},"Ausgangsrechnung",7,{"$f":"K3","v":0},{"$f":"IF(Anordnung!$C$41=\"\",\"\",Anordnung!$C$41)&VLOOKUP($J8-1,Daten!$E$95:$R$114,2,FALSE)","v":""},{"$f":"IF(Daten!$X$65=\"\",H8,CHOOSE(Daten!$V$65,\"PSP \"&Daten!$E$65,\"KST \"&Daten!$E$65,\"IA \"&Daten!$E$65))","v":"2400035005100000"},null,{"$f":"IF(ISNA(VLOOKUP($J8-1,Formular!$B$50:$AJ$69,35,FALSE)),\"\",IF(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),\"AI\",CHOOSE(VLOOKUP($J8-1,Formular!$B$50:$AJ$69,35,FALSE),Formular!$A$11,Formular!$A$12,Formular!$A$13,Formular!$A$14,Formular!$A$15,Formular!$A$16,Formular!$A$17,Formular!$A$18)))","v":""},{"$f":"IF(VLOOKUP($J8-1,Daten!$E$95:$R$114,14,FALSE)<0,\"S\",\"H\")","v":"H"},{"$f":"ROUND(MAX(VLOOKUP($J8-1,Daten!$E$95:$R$114,14,FALSE),-VLOOKUP($J8-1,Daten!$E$95:$R$114,14,FALSE))/IF(OR(Daten!$X$96=\"X\",$O8=\"\"),1,1+IF(MID($O8,2,1)=\"1\",19%,IF(MID($O8,2,1)=\"2\",7%,IF(MID($O8,2,1)=\"E\",16%,IF(MID($O8,2,1)=\"Z\",5%,0%))))),2)","v":0},0,null,{"$f":"T3","v":""},"",0,"",null,null,"S"]
["nicht buchen",1,"1000",{"$f":"$D2","v":"DR"},"2024-08-27","2024-08-27",{"$f":"MONTH(F9)","v":8},{"$f":"H3","v":"2400035005100000"},"Ausgangsrechnung",8,{"$f":"K4","v":0},{"$f":"IF(Anordnung!$C$41=\"\",\"\",Anordnung!$C$41)&VLOOKUP($J9-1,Daten!$E$95:$R$114,2,FALSE)","v":""},{"$f":"IF(Daten!$X$65=\"\",H9,CHOOSE(Daten!$V$65,\"PSP \"&Daten!$E$65,\"KST \"&Daten!$E$65,\"IA \"&Daten!$E$65))","v":"2400035005100000"},null,{"$f":"IF(ISNA(VLOOKUP($J9-1,Formular!$B$50:$AJ$69,35,FALSE)),\"\",IF(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),\"AI\",CHOOSE(VLOOKUP($J9-1,Formular!$B$50:$AJ$69,35,FALSE),Formular!$A$11,Formular!$A$12,Formular!$A$13,Formular!$A$14,Formular!$A$15,Formular!$A$16,Formular!$A$17,Formular!$A$18)))","v":""},{"$f":"IF(VLOOKUP($J9-1,Daten!$E$95:$R$114,14,FALSE)<0,\"S\",\"H\")","v":"H"},{"$f":"ROUND(MAX(VLOOKUP($J9-1,Daten!$E$95:$R$114,14,FALSE),-VLOOKUP($J9-1,Daten!$E$95:$R$114,14,FALSE))/IF(OR(Daten!$X$96=\"X\",$O9=\"\"),1,1+IF(MID($O9,2,1)=\"1\",19%,IF(MID($O9,2,1)=\"2\",7%,IF(MID($O9,2,1)=\"E\",16%,IF(MID($O9,2,1)=\"Z\",5%,0%))))),2)","v":0},0,null,"","",{"$f":"V3","v":0},"",null,null,"S"]
["nicht buchen",1,"1000",{"$f":"$D3","v":"DR"},"2024-08-27","2024-08-27",{"$f":"MONTH(F10)","v":8},{"$f":"H4","v":"2400035005100000"},"Ausgangsrechnung",9,{"$f":"IF($P10=\"S\",69305500,53301500)","v":53301500},"Rundungsdifferenz",{"$f":"IF(Daten!$X$65=\"\",H10,CHOOSE(Daten!$V$65,\"PSP \"&Daten!$E$65,\"KST \"&Daten!$E$65,\"IA \"&Daten!$E$65))","v":"2400035005100000"},null,{"$f":"IF(AND($Q10<>0,OR(MID($V10,1,1)=\"1\",MID($V10,1,2)=\"26\")),\"AS\",\"AN\")","v":"AN"},{"$f":"IF((SUMIF($P$2:$P$9,\"H\",$Q$2:$Q$9)-SUMIF($P$2:$P$9,\"S\",$Q$2:$Q$9)+SUMIF($P$2:$P$9,\"H\",$R$2:$R$9)-SUMIF($P$2:$P$9,\"S\",$R$2:$R$9))>0,\"S\",\"H\")","v":"H"},{"$f":"MAX((SUMIF($P$2:$P$9,\"H\",$Q$2:$Q$9)-SUMIF($P$2:$P$9,\"S\",$Q$2:$Q$9)+SUMIF($P$2:$P$9,\"H\",$R$2:$R$9)-SUMIF($P$2:$P$9,\"S\",$R$2:$R$9)),-(SUMIF($P$2:$P$9,\"H\",$Q$2:$Q$9)-SUMIF($P$2:$P$9,\"S\",$Q$2:$Q$9)+SUMIF($P$2:$P$9,\"H\",$R$2:$R$9)-SUMIF($P$2:$P$9,\"S\",$R$2:$R$9)))","v":0},null,null,"","",{"$f":"V3","v":0},"",null,null,"S"]
["nicht buchen",2,"1000","KN",{"$f":"Formular!$G$36","v":"2024-08-27"},{"$f":"F2","v":"2024-08-27"},{"$f":"MONTH(F11)","v":8},{"$f":"MID(YEAR(Formular!$G$36),3,2)&IF(LEN(Formular!$W$38)=7,\"000\",\"\")&Formular!$W$38&CHOOSE(LEN(Formular!$AF$38),\"000\",\"00\",\"0\",\"\")&Formular!$AF$38","v":"2400035005100000"},"Eingangsrechnung","1",null,{"$f":"\"*\"&MID(Daten!$E$89,1,45)","v":"*"},{"$f":"IF(Daten!$X$65=\"\",H11,CHOOSE(Daten!$V$65,\"PSP \"&Daten!$E$65,\"KST \"&Daten!$E$65,\"IA \"&Daten!$E$65))","v":"2400035005100000"},null,null,{"$f":"IF((SUMIF(P12:P18,\"H\",Q12:S18)-SUMIF(P12:P18,\"S\",Q12:S18))<0,\"H\",\"S\")","v":"S"},{"$f":"CHOOSE(Daten!$V$16,\"\",Q2,\"\")","v":""},{"$nulls":6},{"$f":"CHOOSE(Daten!$V$16,\"\",\"114397\",\"\")","v":""},null,"K",{"$f":"IF(AND(Daten!$V$16=2,$X11=\"114397\"),Daten!$E$56,\"\")","v":""},{"$f":"IF(AND(Daten!$V$16=2,$X11=\"114397\"),Daten!$E$57,\"\")","v":""},{"$f":"IF(AND(Daten!$V$16=2,$X11=\"114397\"),Daten!$E$71&\" \"&Daten!$L$71,\"\")","v":""},{"$f":"IF(AND(Daten!$V$16=2,$X11=\"114397\"),Daten!$E$73,\"\")","v":""},{"$f":"IF(AND(Daten!$V$16=2,$X11=\"114397\"),Daten!$H$73,\"\")","v":""},{"$f":"IF(AND(Daten!$V$16=2,$X11=\"114397\"),\"DE\",\"\")","v":""}]
["nicht buchen",2,"1000",{"$f":"$D11","v":"KN"},{"$f":"E11","v":"2024-08-27"},{"$f":"F11","v":"2024-08-27"},{"$f":"MONTH(F12)","v":8},{"$f":"H11","v":"2400035005100000"},"Eingangsrechnung",2,{"$f":"Formular!$F$21","v":0},{"$f":"VLOOKUP($J12-1,Daten!$E$95:$R$114,2,FALSE)","v":0},{"$f":"IF(Daten!$X$65=\"\",H12,CHOOSE(Daten!$V$65,\"PSP \"&Daten!$E$65,\"KST \"&Daten!$E$65,\"IA \"&Daten!$E$65))","v":"2400035005100000"},null,{"$f":"CHOOSE(Daten!$V$16,\"\",IF($O3=\"\",\"\",IF(AND(MID($V$12,1,1)=\"1\"),\"V\"&IF(MID($O3,2,1)=\"N\",0,MID($O3,2,1)),\"N\"&IF(OR(MID($O3,2,1)=\"N\",$O3=\"AS\"),0,MID($O3,2,1)))),\"\")","v":""},{"$f":"IF(VLOOKUP($J12-1,Daten!$E$95:$R$114,14,FALSE)<0,\"H\",\"S\")","v":"S"},{"$f":"CHOOSE(Daten!$V$16,\"\",IF($Q3=0,\"\",IF(MID($V$12,1,1)=\"1\",$Q3,$Q3+$R3)),\"\")","v":""},{"$f":"CHOOSE(Daten!$V$16,\"\",IF($Q3=0,\"\",IF(MID($V$12,1,1)=\"1\",$R3,\"\")),\"\")","v":""},null,{"$f":"IF(AND(Daten!$E$36<>\"\",Daten!$E$38=\"\"),Daten!$E$36,\"\")","v":""},{"$f":"IF(Daten!$E$38<>\"\",IF(MID(Daten!$E$38,1,1)=\"8\",Daten!$E$38,\"\"),\"\")","v":""},{"$f":"IF(Daten!$E$38<>\"\",IF(MID(Daten!$E$38,1,1)=\"8\",\"\",Daten!$E$38),\"\")","v":""},{"$f":"IF(AND(Daten!$E$36<>\"\",Daten!$E$38=\"\"),Daten!$L$36,\"\")","v":""},null,null,"S"]
["nicht buchen",2,"1000",{"$f":"$D11","v":"KN"},{"$f":"E11","v":"2024-08-27"},{"$f":"F11","v":"2024-08-27"},8,{"$f":"H11","v":"2400035005100000"},"Eingangsrechnung",3,{"$f":"K12","v":0},{"$f":"VLOOKUP($J13-1,Daten!$E$95:$R$114,2,FALSE)","v":0},{"$f":"IF(Daten!$X$65=\"\",H13,CHOOSE(Daten!$V$65,\"PSP \"&Daten!$E$65,\"KST \"&Daten!$E$65,\"IA \"&Daten!$E$65))","v":"2400035005100000"},null,{"$f":"CHOOSE(Daten!$V$16,\"\",IF($O4=\"\",\"\",IF(AND(MID($V$12,1,1)=\"1\"),\"V\"&IF(MID($O4,2,1)=\"N\",0,MID($O4,2,1)),\"N\"&IF(OR(MID($O4,2,1)=\"N\",$O4=\"AS\"),0,MID($O4,2,1)))),\"\")","v":""},{"$f":"IF(VLOOKUP($J13-1,Daten!$E$95:$R$114,14,FALSE)<0,\"H\",\"S\")","v":"S"},{"$f":"CHOOSE(Daten!$V$16,\"\",IF($Q4=0,\"\",IF(MID($V$12,1,1)=\"1\",$Q4,$Q4+$R4)),\"\")","v":""},{"$f":"CHOOSE(Daten!$V$16,\"\",IF($Q4=0,\"\",IF(MID($V$12,1,1)=\"1\",$R4,\"\")),\"\")","v":""},null,{"$f":"T12","v":""},{"$f":"U12","v":""},{"$f":"V12","v":""},{"$f":"W12","v":""},null,null,"S"]
["nicht buchen",2,"1000",{"$f":"$D11","v":"KN"},{"$f":"E11","v":"2024-08-27"},{"$f":"F11","v":"2024-08-27"},8,{"$f":"H11","v":"2400035005100000"},"Eingangsrechnung",4,{"$f":"K12","v":0},{"$f":"VLOOKUP($J14-1,Daten!$E$95:$R$114,2,FALSE)","v":0},{"$f":"IF(Daten!$X$65=\"\",H14,CHOOSE(Daten!$V$65,\"PSP \"&Daten!$E$65,\"KST \"&Daten!$E$65,\"IA \"&Daten!$E$65))","v":"2400035005100000"},null,{"$f":"CHOOSE(Daten!$V$16,\"\",IF($O5=\"\",\"\",IF(AND(MID($V$12,1,1)=\"1\"),\"V\"&IF(MID($O5,2,1)=\"N\",0,MID($O5,2,1)),\"N\"&IF(OR(MID($O5,2,1)=\"N\",$O5=\"AS\"),0,MID($O5,2,1)))),\"\")","v":""},{"$f":"IF(VLOOKUP($J14-1,Daten!$E$95:$R$114,14,FALSE)<0,\"H\",\"S\")","v":"S"},{"$f":"CHOOSE(Daten!$V$16,\"\",IF($Q5=0,\"\",IF(MID($V$12,1,1)=\"1\",$Q5,$Q5+$R5)),\"\")","v":""},{"$f":"CHOOSE(Daten!$V$16,\"\",IF($Q5=0,\"\",IF(MID($V$12,1,1)=\"1\",$R5,\"\")),\"\")","v":""},null,{"$f":"T12","v":""},{"$f":"U12","v":""},{"$f":"V12","v":""},{"$f":"W12","v":""},null,null,"S"]
["nicht buchen",2,"1000",{"$f":"$D11","v":"KN"},{"$f":"E11","v":"2024-08-27"},{"$f":"F11","v":"2024-08-27"},8,{"$f":"H11","v":"2400035005100000"},"Eingangsrechnung",5,{"$f":"K12","v":0},{"$f":"VLOOKUP($J15-1,Daten!$E$95:$R$114,2,FALSE)","v":0},{"$f":"IF(Daten!$X$65=\"\",H15,CHOOSE(Daten!$V$65,\"PSP \"&Daten!$E$65,\"KST \"&Daten!$E$65,\"IA \"&Daten!$E$65))","v":"2400035005100000"},null,{"$f":"CHOOSE(Daten!$V$16,\"\",IF($O6=\"\",\"\",IF(AND(MID($V$12,1,1)=\"1\"),\"V\"&IF(MID($O6,2,1)=\"N\",0,MID($O6,2,1)),\"N\"&IF(OR(MID($O6,2,1)=\"N\",$O6=\"AS\"),0,MID($O6,2,1)))),\"\")","v":""},{"$f":"IF(VLOOKUP($J15-1,Daten!$E$95:$R$114,14,FALSE)<0,\"H\",\"S\")","v":"S"},{"$f":"CHOOSE(Daten!$V$16,\"\",IF($Q6=0,\"\",IF(MID($V$12,1,1)=\"1\",$Q6,$Q6+$R6)),\"\")","v":""},{"$f":"CHOOSE(Daten!$V$16,\"\",IF($Q6=0,\"\",IF(MID($V$12,1,1)=\"1\",$R6,\"\")),\"\")","v":""},null,{"$f":"T12","v":""},{"$f":"U12","v":""},{"$f":"V12","v":""},{"$f":"W12","v":""},null,null,"S"]
["nicht buchen",2,"1000",{"$f":"$D11","v":"KN"},{"$f":"E11","v":"2024-08-27"},{"$f":"F11","v":"2024-08-27"},8,{"$f":"H11","v":"2400035005100000"},"Eingangsrechnung",6,{"$f":"K12","v":0},{"$f":"VLOOKUP($J16-1,Daten!$E$95:$R$114,2,FALSE)","v":0},{"$f":"IF(Daten!$X$65=\"\",H16,CHOOSE(Daten!$V$65,\"PSP \"&Daten!$E$65,\"KST \"&Daten!$E$65,\"IA \"&Daten!$E$65))","v":"2400035005100000"},null,{"$f":"CHOOSE(Daten!$V$16,\"\",IF($O7=\"\",\"\",IF(AND(MID($V$12,1,1)=\"1\"),\"V\"&IF(MID($O7,2,1)=\"N\",0,MID($O7,2,1)),\"N\"&IF(OR(MID($O7,2,1)=\"N\",$O7=\"AS\"),0,MID($O7,2,1)))),\"\")","v":""},{"$f":"IF(VLOOKUP($J16-1,Daten!$E$95:$R$114,14,FALSE)<0,\"H\",\"S\")","v":"S"},{"$f":"CHOOSE(Daten!$V$16,\"\",IF($Q7=0,\"\",IF(MID($V$12,1,1)=\"1\",$Q7,$Q7+$R7)),\"\")","v":""},{"$f":"CHOOSE(Daten!$V$16,\"\",IF($Q7=0,\"\",IF(MID($V$12,1,1)=\"1\",$R7,\"\")),\"\")","v":""},null,{"$f":"T12","v":""},{"$f":"U12","v":""},{"$f":"V12","v":""},{"$f":"W12","v":""},null,null,"S"]
["nicht buchen",2,"1000",{"$f":"$D11","v":"KN"},{"$f":"E11","v":"2024-08-27"},"2024-08-27",8,{"$f":"H11","v":"2400035005100000"},"Eingangsrechnung",7,{"$f":"K12","v":0},{"$f":"VLOOKUP($J17-1,Daten!$E$95:$R$114,2,FALSE)","v":0},{"$f":"IF(Daten!$X$65=\"\",H17,CHOOSE(Daten!$V$65,\"PSP \"&Daten!$E$65,\"KST \"&Daten!$E$65,\"IA \"&Daten!$E$65))","v":"2400035005100000"},null,{"$f":"CHOOSE(Daten!$V$16,\"\",IF($O8=\"\",\"\",IF(AND(MID($V$12,1,1)=\"1\"),\"V\"&IF(MID($O8,2,1)=\"N\",0,MID($O8,2,1)),\"N\"&IF(OR(MID($O8,2,1)=\"N\",$O8=\"AS\"),0,MID($O8,2,1)))),\"\")","v":""},{"$f":"IF(VLOOKUP($J17-1,Daten!$E$95:$R$114,14,FALSE)<0,\"H\",\"S\")","v":"S"},{"$f":"CHOOSE(Daten!$V$16,\"\",IF($Q8=0,\"\",IF(MID($V$12,1,1)=\"1\",$Q8,$Q8+$R8)),\"\")","v":""},{"$f":"CHOOSE(Daten!$V$16,\"\",IF($Q8=0,\"\",IF(MID($V$12,1,1)=\"1\",$R8,\"\")),\"\")","v":""},null,{"$f":"T12","v":""},"",{"$f":"V12","v":""},{"$f":"W12","v":""},null,null,"S"]
["nicht buchen",2,"1000",{"$f":"$D11","v":"KN"},{"$f":"E12","v":"2024-08-27"},"2024-08-27",8,{"$f":"H12","v":"2400035005100000"},"Eingangsrechnung",8,{"$f":"K13","v":0},{"$f":"VLOOKUP($J18-1,Daten!$E$95:$R$114,2,FALSE)","v":0},{"$f":"IF(Daten!$X$65=\"\",H18,CHOOSE(Daten!$V$65,\"PSP \"&Daten!$E$65,\"KST \"&Daten!$E$65,\"IA \"&Daten!$E$65))","v":"2400035005100000"},null,{"$f":"CHOOSE(Daten!$V$16,\"\",IF($O9=\"\",\"\",IF(AND(MID($V$12,1,1)=\"1\"),\"V\"&IF(MID($O9,2,1)=\"N\",0,MID($O9,2,1)),\"N\"&IF(OR(MID($O9,2,1)=\"N\",$O9=\"AS\"),0,MID($O9,2,1)))),\"\")","v":""},{"$f":"IF(VLOOKUP($J18-1,Daten!$E$95:$R$114,14,FALSE)<0,\"H\",\"S\")","v":"S"},{"$f":"CHOOSE(Daten!$V$16,\"\",IF($Q9=0,\"\",IF(MID($V$12,1,1)=\"1\",$Q9,$Q9+$R9)),\"\")","v":""},{"$f":"CHOOSE(Daten!$V$16,\"\",IF($Q9=0,\"\",IF(MID($V$12,1,1)=\"1\",$R9,\"\")),\"\")","v":""},null,{"$f":"T13","v":""},"",{"$f":"V12","v":""},{"$f":"W13","v":""},null,null,"S"]
["nicht buchen",2,"1000",{"$f":"$D12","v":"KN"},{"$f":"E13","v":"2024-08-27"},"2024-08-27",8,{"$f":"H13","v":"2400035005100000"},"Eingangsrechnung",9,{"$f":"IF($P19=\"S\",69305500,53301500)","v":69305500},"Rundungsdifferenz",{"$f":"IF(Daten!$X$65=\"\",H19,CHOOSE(Daten!$V$65,\"PSP \"&Daten!$E$65,\"KST \"&Daten!$E$65,\"IA \"&Daten!$E$65))","v":"2400035005100000"},null,{"$f":"IF(AND($Q19<>0,MID($V19,1,1)=\"1\"),\"VS\",\"N0\")","v":"N0"},{"$f":"IF((SUMIF($P$11:$P$18,\"H\",$Q$11:$Q$18)-SUMIF($P$11:$P$18,\"S\",$Q$11:$Q$18)+SUMIF($P$11:$P$18,\"H\",$R$11:$R$18)-SUMIF($P$11:$P$18,\"S\",$R$11:$R$18))>0,\"H\",\"S\")","v":"S"},{"$f":"MAX((SUMIF($P$11:$P$18,\"H\",$Q$11:$Q$18)-SUMIF($P$11:$P$18,\"S\",$Q$11:$Q$18)+SUMIF($P$11:$P$18,\"H\",$R$11:$R$18)-SUMIF($P$11:$P$18,\"S\",$R$11:$R$18)),-(SUMIF($P$11:$P$18,\"H\",$Q$11:$Q$18)-SUMIF($P$11:$P$18,\"S\",$Q$11:$Q$18)+SUMIF($P$11:$P$18,\"H\",$R$11:$R$18)-SUMIF($P$11:$P$18,\"S\",$R$11:$R$18)))","v":0},null,null,{"$f":"T14","v":""},"",{"$f":"V12","v":""},{"$f":"W14","v":""},null,null,"S"]

{"sheet":"Daten","index":1,"n_rows":119,"n_cols":27,"rows_kept":119,"merged":[[0,5,2,19],[5,12,5,19],[17,4,17,11],[17,23,17,24],[18,4,18,11],[19,4,19,11],[20,4,20,11],[24,4,24,9],[26,4,26,5],[26,7,26,11],[28,14,28,16],[28,17,28,19],[30,4,30,11],[30,14,30,16],[30,17,30,19],[33,1,33,13],[33,14,33,16],[33,17,33,19],[35,4,35,5],[35,14,35,16],[35,17,35,19],[37,4,37,5],[37,14,37,16],[37,17,37,19],[42,4,42,7],[44,4,44,11],[45,4,45,11],[46,4,46,11],[47,4,47,11],[49,4,49,9],[51,4,51,5],[51,7,51,11],[55,4,55,9],[56,4,56,9],[58,4,58,11],[60,4,60,11],[62,4,62,11],[64,4,64,5],[64,23,64,24],[70,4,70,9],[70,13,72,19],[72,4,72,5],[72,7,72,11],[76,4,76,11],[78,9,78,11],[78,17,78,19],[80,9,80,11],[80,17,80,19],[82,4,82,11],[82,17,82,19],[86,4,86,5],[86,7,86,8],[88,4,88,19],[89,4,89,19],[90,4,90,19],[92,17,92,19],[94,5,94,15],[94,17,94,19],[95,5,95,6],[95,9,95,10],[95,14,95,15],[97,5,97,15],[97,17,97,19],[98,5,98,6],[98,9,98,10],[98,14,98,15],[100,5,100,15],[100,17,100,19],[101,5,101,6],[101,9,101,10],[101,14,101,15],[103,5,103,15],[103,17,103,19],[104,5,104,6],[104,9,104,10],[104,14,104,15],[106,5,106,15],[106,17,106,19],[107,5,107,6],[107,9,107,10],[107,14,107,15],[109,5,109,15],[109,17,109,19],[110,5,110,6],[110,9,110,10],[110,14,110,15],[112,5,112,15],[112,17,112,19],[113,5,113,6],[113,9,113,10],[113,14,113,15],[117,1,117,2],[117,4,117,19]]}
[{"$nulls":5},"Vorlage zur Erstellung von Rechnungen"]
[]
[]
[{"$nulls":7},"nur Kopie an VII 2",{"$f":"IF(AND(OR(AND(Kontierung_Art=1,OR(MID(Kontierung_Nr,1,1)=\"3\",MID(Kontierung_Nr,1,1)=\"4\")),MID($L$65,1,1)=\"2\",MID($L$65,1,1)=\"3\"),$O$4<>\"X\"),\"X\",\"\")","v":""},{"$nulls":4},"vorab zur Prüfung an VII 2",{"$f":"IF(OR(AND(Kontierung_Art=1,OR(MID(Kontierung_Nr,1,1)=\"3\",MID(Kontierung_Nr,1,1)=\"4\"),$U$4<>\"X\")),\"X\",\"\")","v":""},{"$nulls":4},"vorab zur Prüfung an VII 5",{"$f":"IF(AND(OR(AND(Kontierung_Art=1,MID(Kontierung_Nr,1,1)=\"1\",MID(Kontierung_Nr,3,2)<>\"52\"),AND(Kontierung_Art=1,MID(Kontierung_Nr,1,1)=\"2\"),AND(Kontierung_Art=1,MID(Kontierung_Nr,1,1)=\"5\"),AND(Kontierung_Art=1,MID(Kontierung_Nr,1,1)=\"3\"),AND(Kontierung_Art=1,MID(Kontierung_Nr,1,1)=\"4\"),AND(Kontierung_Art=2),$N$41<>\"DE\"),$V$16<>2),\"X\",\"\")","v":""}]
[]
[{"$nulls":11},"Bitte Kopie der Rechnung als PDF per Mail an:"]
[]
["Bitte folgende Hinweise unbedingt beachten:"]
["F","Alle gelb markierten Felder müssen vollständig ausgefüllt werden, die grün markierten Felder sind optional"]
["F","Es dürfen keine Zellen hinzugefügt oder gelöscht werden, das Tabellenblatt Daten darf nicht in eine andere Datei kopiert werden"]
["F","Zellinhalte dürfen nicht (über Strg-x) ausgeschnitten und an eine andere Stelle (über Strg-v) verschoben werden"]
["F","Die ausgefüllte Datei muss im Excel-Format (.xlsx) abgespeichert werden."]
["F","Das Tabellenblatt Anordnung bitte ausdrucken und - wenn möglich - mit Unterschriften wieder einscannen und als PDF speichern."]
["F","Beide Dateien per Mail verschicken an:",{"$nulls":3},"debitoren@zv.uni-tuebingen.de",{"$nulls":12},"Stand:","2024-08-27"]
[]
["(1)","Rechnungsempfänger",{"$nulls":11},"     ","(2)","Rechnungsversand",{"$nulls":5},1,null,"Debitor (falls bekannt):"]
[]
[null,"Name (bis zu 4 Zeilen)",{"$nulls":19},1]
[null,{"$f":"IF(AND($E19=\"\",OR($E$20<>\"\",$E$21<>\"\")),\"Bitte keine Zeile überspringen!\",\"\")","v":""}]
[null,{"$f":"IF(AND($E20=\"\",OR($E$21<>\"\")),\"Bitte keine Zeile überspringen!\",\"\")","v":""}]
[]
[]
[null,"Rechtsform",{"$f":"IF($V23=\"\",\"Bitte auswählen!\",IF(AND($V$16<>1,$V23=1),\"Auswahl unplausibel!\",\"\"))","v":""},{"$nulls":18},2,null,{"$f":"IF(AND($V$16<>1,$V23=1),\"Rechtsform => Unternehmen / Jurist. Person des Öffentl. Rechts\",\"\")","v":""}]
[]
[null,"Anschrift","Strasse + Haus-Nr."]
[]
[null,null,"PLZ + Ort"]
[]
[null,{"$f":"IF($V29=\"\",\"Bitte auswählen!\",IF(AND($V$16<>1,$N29<>\"DE\"),\"Auswahl unplausibel!\",\"\"))","v":""},"Land",{"$nulls":10},{"$f":"IF(ISNA(VLOOKUP($V$29,Länder!$A:$D,4,FALSE)),\"\",VLOOKUP($V$29,Länder!$A:$D,4,FALSE))","v":"DE"},{"$f":"IF($V$18=3,\"Leitweg-ID (BT10):\",\"\")","v":""},{"$nulls":6},50,null,{"$f":"IF(AND($V$16<>1,$N29<>\"DE\"),\"Land => Deutschland\",\"\")","v":""}]
[]
[null,null,"eMail",{"$nulls":11},{"$f":"IF($V$18=3,\"Bestell-Nr. (BT13):\",\"\")","v":""}]
[]
[]
["*\n\n\n**","Ist der Empfänger der Lieferung / Leistung das Universitätsklinikum Tübingen muss differenziert werden zwischen Lieferungen / Leistungen \nfür den Klinikbetrieb [Auswahl: extern] sowie Lieferungen / Leistungen für Forschung & Lehre [Auswahl: Med. Fak. (= UKT Forschung & Lehre)].\n\nIst der Rechnungsempfänger eine Einrichtung der Universität Tübingen ist vorab die Kontierung zu erfragen, aus der die Rechnung bezahlt werden soll."]
[]
[null,{"$f":"IF($V$16=2,\"Kontierungsobjekt\",\"\")","v":""},{"$f":"IF($V$16=2,\"Kostenstelle und Fonds\",\"\")","v":""},{"$nulls":3},{"$f":"IF($V$16=2,\"E\",\"\")","v":""},{"$f":"IF($V$16=2,\"KST\",\"\")","v":""},null,{"$f":"IF($V$16=2,\"Fonds\",\"\")","v":""},{"$f":"IF($V$16=2,\"F\",\"\")","v":""},{"$nulls":3},{"$f":"IF($V$18=3,\"Projekt-Nr. (BT11):\",\"\")","v":""}]
[]
[null,null,{"$f":"IF($V$16=2,\"ODER PSP-Element ODER Innenauftrag\",\"\")","v":""},{"$nulls":3},{"$f":"IF($V$16=2,\"E\",\"\")","v":""},{"$f":"IF($V$16=2,\"PSP / IA\",\"\")","v":""},{"$nulls":6},{"$f":"IF($V$18=3,\"Vertrags-Nr. (BT12):\",\"\")","v":""}]
[]
["(3)","Empfängerland der Lieferung / Leistung",null,null,"     ",{"$nulls":8},"     ",{"$nulls":3},"     "]
[null,"(falls vom Rechnungsempfänger abweichend)",{"$nulls":11},{"$f":"IF(ISNA(VLOOKUP($V$41,Länder!$A:$D,4,FALSE)),\"\",VLOOKUP($V$41,Länder!$A:$D,4,FALSE))","v":"DE"},null,{"$f":"IF(AND($V$16<>1,$N41<>\"DE\"),\"Auswahl unplausibel!\",\"\")","v":""},{"$nulls":5},{"$f":"$V$29","v":50},null,{"$f":"IF(AND($V$16<>1,$N41<>\"DE\"),\"Land => Deutschland\",\"\")","v":""}]
[]
[null,{"$f":"IF(OR(ISNA(VLOOKUP($V$41,Länder!$A:$A,1,FALSE)),$V$23=1),\"\",IF(VLOOKUP($V$41,Länder!$A:$E,5,FALSE)=\"X\",\"Umsatzsteuer-ID\",\"\"))","v":"Umsatzsteuer-ID"},{"$f":"IF(OR(ISNA(VLOOKUP($V$41,Länder!$A:$A,1,FALSE)),$V$23=1,$N$41=\"DE\"),\"\",IF(AND(VLOOKUP($V$41,Länder!$A:$E,5,FALSE)=\"X\",MID($E$43,1,2)<>$N$41),\"(muss mit \"&$N$41&\" beginnen)\",\"\"))","v":""},{"$nulls":6},{"$f":"IF(OR(ISNA(VLOOKUP($V$41,Länder!$A:$A,1,FALSE)),$V$23=1,$N$41=\"DE\"),\"\",IF(AND(VLOOKUP($V$41,Länder!$A:$E,5,FALSE)=\"X\",MID($E$43,1,2)<>$N$41),\"Lieferung/Leistung  innerhalb der EU: Bitte UST-ID eingeben!\",\"\"))","v":""}]
[]
[null,null,{"$f":"IF($V$45=TRUE,\"Name\",\"\")","v":""},{"$nulls":18},false]
[null,{"$f":"IF(AND($E46=\"\",OR($E$47<>\"\",$E$48<>\"\")),\"Bitte keine Zeile überspringen!\",\"\")","v":""}]
[null,{"$f":"IF(AND($E47=\"\",OR($E$48<>\"\")),\"Bitte keine Zeile überspringen!\",\"\")","v":""}]
[]
[]
[null,{"$f":"IF($V$45=TRUE,\"Anschrift\",\"\")","v":""},{"$f":"IF($V$45=TRUE,\"Strasse + Haus-Nr.\",\"\")","v":""}]
[]
[null,null,{"$f":"IF($V$45=TRUE,\"PLZ + Ort\",\"\")","v":""}]
[]
["(4)","Liefernde / Leistungserbringende Einrichtung",null,null,"     ",{"$nulls":8},"     ",{"$nulls":3},"     "]
[]
[null,"Fakultät / Zentrale Einrichtung (bis zu 2 Zeilen)"]
[]
[]
[null,"Fachbereich / Institut / Lehrstuhl / Abteilung"]
[]
[null,"Titel Vorname Name"]
[]
[null,"Funktion",{"$nulls":21},"Buchung auf Sammel-PSP:"]
[]
[null,"Kontierungsobjekt",{"$nulls":4},{"$f":"CHOOSE(Kontierung_Art,\"E\",\"E\",\"E\")","v":"E"},{"$f":"CHOOSE(Kontierung_Art,\"PSP\",\"KST\",\"IA\")","v":"PSP"},null,{"$f":"CHOOSE(Kontierung_Art,\"Fonds\",\"Fonds\",\"Fonds\")","v":"Fonds"},{"$f":"CHOOSE(Kontierung_Art,\"F\",\"F\",\"F\")","v":"F"},null,null,{"$f":"IF(Kontierung_Art=0,\"\",CHOOSE(Kontierung_Art,IF(AND($V$16=3,MID(Kontierung_Nr,1,1)=\"1\"),\"Lieferung/Leistung an UKT (MFT) von 1er-PSP nicht zulässig!\",IF(AND($V$16=3,MID(Kontierung_Nr,1,2)=\"26\"),\"Lieferung/Leistung an UKT (MFT) von 26er-PSP nicht zulässig!\",IF(OR(LEN(Kontierung_Nr)<>10,MID(Kontierung_Nr,1,1)=\"8\"),\"Bitte PSP (10-stellig, darf nicht mit 8 beginnen) eingeben!\",\"\"))),IF(OR(LEN(Kontierung_Nr)<>7,LEN($L$65)<>4),\"Bitte KST (7-stellig) und Fonds (4-stellig) eingeben!\",\"\"),IF(OR(LEN(Kontierung_Nr)<>10,MID(Kontierung_Nr,1,1)<>\"8\"),\"Bitte IA (10-stellig, muss mit 8 beginnen) eingeben!\",\"\")))","v":"Bitte PSP (10-stellig, darf nicht mit 8 beginnen) eingeben!"},{"$nulls":7},1]
[]
[{"$nulls":4},{"$f":"\"HINWEIS: Das ausgewählte Kontierungsobjekt ist \"&IF($N$65<>\"\",\"UNGÜLTIG\",CHOOSE(Kontierung_Art,IF(OR(MID(Kontierung_Nr,1,1)=\"1\",MID(Kontierung_Nr,1,2)=\"26\"),\"STEUERBAR\",\"NICHT STEUERBAR\"),\"NICHT STEUERBAR\",\"NICHT STEUERBAR\"))&\".\"","v":"HINWEIS: Das ausgewählte Kontierungsobjekt ist UNGÜLTIG."}]
[{"$nulls":4},{"$f":"IF($N$65<>\"\",\"\",CHOOSE(Kontierung_Art,IF(OR(MID(Kontierung_Nr,1,1)=\"1\",MID(Kontierung_Nr,1,1)=\"2\"),\"Es wird eine RECHNUNG erzeugt.\",\"Es wird eine RECHNUNG erzeugt.\"),\"Es wird eine RECHNUNG erzeugt.\",\"Es wird eine RECHNUNG erzeugt.\"))","v":""}]
[{"$nulls":5},{"$f":"IF($N$65<>\"\",\"\",CHOOSE(Kontierung_Art,IF(OR(MID(Kontierung_Nr,1,1)=\"1\",MID(Kontierung_Nr,1,1)=\"2\"),\"Es soll stattdessen lediglich ein KOSTENVORANSCHLAG erzeugt werden.\",\"Es soll stattdessen ein (GEBÜHREN-)BESCHEID erzeugt werden.\"),\"Es soll stattdessen ein (GEBÜHREN-)BESCHEID erzeugt werden.\",\"Es soll stattdessen ein (GEBÜHREN-)BESCHEID erzeugt werden.\"))","v":""},{"$nulls":15},false]
[]
[null,"Anschrift","Strasse + Haus-Nr.",{"$nulls":10},{"$f":"IF(Formular!$AJ$38=5,\"Bitte im Feld Bezeichnung die Grundlage für den Bescheid (z.B. Gebührenordnung) benennen!\",\"\")","v":""}]
[]
[null,null,"PLZ + Ort"]
[]
["(5)","Ansprechpartner (der Einrichtung)",null,null,"     ",{"$nulls":8},"     ",{"$nulls":3},"     "]
[]
[null,"Name"]
[]
[null,"Kontaktdaten","Telefon",null,"+","49 7071",null,29,{"$f":"IF($H79=29,\"-\",\"\")","v":"-"}]
[]
[null,null,"Fax",null,"+","49 7071",null,29,{"$f":"IF($H81=29,\"-\",\"\")","v":"-"}]
[]
[null,null,"eMail"]
[]
["(6)","Angaben zur Lieferung / Leistung",null,null,"     ",{"$nulls":8},"     ",{"$nulls":3},"     "]
[]
[null,"Zeitpunkt bzw. Zeitraum",{"$nulls":4},"-"]
[]
[null,"Umfang / Bezeichnung"]
[]
[]
[]
[null,"Währung (Bitte ändern, falls nicht Euro)",{"$nulls":15},"Euro"]
[]
[null,{"$f":"IF(AND(Kontierung_Art=1,MID(Kontierung_Nr,1,1)=\"1\",MID(Daten!$X$65,1,2)<>\"24\"),IF($X$96=\"X\",\"Positionen und NETTO-Beträge\",\"Positionen und BRUTTO-Beträge\"),\"Positionen und Beträge\")","v":"Positionen und Beträge"},null,null,1,{"$nulls":12},{"$f":"IF(AND($H96=\"\",$O96<>\"\"),$O96,IF($V95=10,$H96%*$O96,$H96*$O96))","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(AND(Kontierung_Art=1,MID(Kontierung_Nr,1,1)=\"1\",MID(Daten!$X$65,1,2)<>\"24\"),\"Beträge sind BRUTTO-Beträge?\",\"\")","v":""}]
[null,"(aussagekräftige Kurzbezeichnung)",{"$nulls":3},"Menge: ",{"$nulls":3},"Einheit:",{"$nulls":3},"E-Preis: ",{"$nulls":9},{"$f":"IF(AND(Kontierung_Art=1,MID(Kontierung_Nr,1,1)=\"1\",MID(Daten!$X$65,1,2)<>\"24\"),\"X\",\"\")","v":""},{"$f":"IF(AND(Kontierung_Art=1,MID(Kontierung_Nr,1,1)=\"1\",MID(Daten!$X$65,1,2)<>\"24\"),\"Nein\",\"\")","v":""},{"$f":"IF(AND(Kontierung_Art=1,MID(Kontierung_Nr,1,1)=\"1\",MID(Daten!$X$65,1,2)<>\"24\",$X$96<>\"X\"),\"X\",\"\")","v":""},{"$f":"IF(AND(Kontierung_Art=1,MID(Kontierung_Nr,1,1)=\"1\",MID(Daten!$X$65,1,2)<>\"24\"),\"Ja\",\"\")","v":""}]
[]
[{"$nulls":4},2,{"$nulls":12},{"$f":"IF(AND($H99=\"\",$O99<>\"\"),$O99,IF($V98=10,$H99%*$O99,$H99*$O99))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},"Menge: ",{"$nulls":3},"Einheit:",{"$nulls":3},"E-Preis: "]
[]
[{"$nulls":4},3,{"$nulls":12},{"$f":"IF(AND($H102=\"\",$O102<>\"\"),$O102,IF($V101=10,$H102%*$O102,$H102*$O102))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},"Menge: ",{"$nulls":3},"Einheit:",{"$nulls":3},"E-Preis: "]
[]
[{"$nulls":4},4,{"$nulls":12},{"$f":"IF(AND($H105=\"\",$O105<>\"\"),$O105,IF($V104=10,$H105%*$O105,$H105*$O105))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},"Menge: ",{"$nulls":3},"Einheit:",{"$nulls":3},"E-Preis: "]
[]
[{"$nulls":4},5,{"$nulls":12},{"$f":"IF(AND($H108=\"\",$O108<>\"\"),$O108,IF($V107=10,$H108%*$O108,$H108*$O108))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},"Menge: ",{"$nulls":3},"Einheit:",{"$nulls":3},"E-Preis: "]
[]
[{"$nulls":4},6,{"$nulls":12},{"$f":"IF(AND($H111=\"\",$O111<>\"\"),$O111,IF($V110=10,$H111%*$O111,$H111*$O111))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},"Menge: ",{"$nulls":3},"Einheit:",{"$nulls":3},"E-Preis: "]
[]
[{"$nulls":4},7,{"$nulls":12},{"$f":"IF(AND($H114=\"\",$O114<>\"\"),$O114,IF($V113=10,$H114%*$O114,$H114*$O114))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},"Menge: ",{"$nulls":3},"Einheit:",{"$nulls":3},"E-Preis: "]
[]
["(7)","Optional: Ausführliche Beschreibung",null,null,"     ",{"$nulls":8},"     ",{"$nulls":3},"     "]
[]
[null,"(ggf. mit Verweis auf Positionen 1-7)\n\nZeilenumbruch ð Tasten Alt + Enter"]
[{"$nulls":4}," "]

{"sheet":"Anordnung","index":2,"n_rows":53,"n_cols":39,"rows_kept":53,"merged":[[0,1,0,25],[1,2,1,8],[1,11,1,16],[2,3,2,8],[2,12,4,13],[2,15,4,16],[2,19,2,20],[2,22,2,24],[3,3,3,8],[4,3,4,8],[4,22,4,24],[5,3,5,8],[5,22,5,24],[7,2,7,8],[7,11,7,16],[7,18,7,25],[11,12,11,16],[11,18,11,25],[12,12,12,16],[15,2,15,8],[15,13,15,16],[17,2,17,8],[17,18,17,25],[19,2,19,8],[19,10,19,13],[19,14,19,16],[21,2,21,8],[21,10,21,16],[23,2,23,8],[23,10,23,16],[23,18,24,22],[23,23,24,24],[25,2,25,8],[25,11,25,16],[25,19,25,24],[26,2,26,8],[26,11,26,16],[26,19,26,24],[28,2,28,8],[28,9,28,24],[30,1,30,25],[31,2,31,8],[31,9,31,13],[32,9,32,13],[33,1,33,25],[35,2,35,4],[35,7,35,8],[35,11,35,16],[35,19,35,24],[36,2,36,4],[36,7,36,8],[36,11,36,16],[36,19,36,24],[37,2,37,4],[37,7,37,8],[37,11,37,16],[37,19,37,24],[38,2,38,25],[39,2,39,3],[40,2,40,3],[40,5,40,24],[42,2,42,25],[43,2,43,24],[44,2,44,24],[46,2,47,5],[46,6,47,15],[47,17,47,20],[47,22,47,24],[48,6,48,15],[48,17,48,20],[48,22,48,24],[49,17,49,20],[49,22,49,24],[50,17,50,20],[50,22,50,24],[51,2,51,5],[51,11,51,14],[51,17,51,20],[51,22,51,24],[52,17,52,20],[52,22,52,24]]}
[]
[null,1,"Absenderangaben",{"$nulls":7},2,"Vorgangsart (bitte ankreuzen)",{"$nulls":7},"G-Jahr",null,null,"Belegnummer"]
[null,"Bereich",null,{"$f":"IF(Daten!$E$56=0,\"\",Daten!$E$56)","v":""},{"$nulls":8},"A",null,null,"E"]
[null,"Name",null,{"$f":"IF(Daten!$E$77=0,\"\",Daten!$E$77)","v":""}]
[null,"Telefon",null,{"$f":"IF(Daten!$J$79=0,\"\",Daten!$E$79&Daten!$F$79&\" \"&IF(Daten!$H$79=0,\"\",Daten!$H$79&\"-\")&Daten!$J$79)","v":""},{"$nulls":15},"Buch.datum",{"$nulls":7},{"$f":"IF((Daten!$R$95+Daten!$R$98+Daten!$R$101+Daten!$R$104+Daten!$R$107+Daten!$R$110+Daten!$R$113)<0,TRUE,FALSE)","v":false}]
[null,"Mail",null,{"$f":"IF(Daten!$E$83=0,\"\",Daten!$E$83)","v":""},{"$nulls":8},"Ausgabe",null,null,"Einnahme",{"$nulls":3},"Buch.periode",{"$nulls":7},{"$f":"IF((Daten!$R$95+Daten!$R$98+Daten!$R$101+Daten!$R$104+Daten!$R$107+Daten!$R$110+Daten!$R$113)>=0,TRUE,FALSE)","v":true}]
[]
[null,3,"Bestellung über SRM / MM?",{"$nulls":8},"- Bitte unbedingt ankreuzen -",{"$nulls":6},"Eingangsstempel"]
[]
[{"$nulls":3}," nein",{"$nulls":23},true]
[]
[{"$nulls":3}," ja, Bezug zu einer Bestellung mit Bestellnummer:",{"$nulls":23},false]
[{"$nulls":12},"10-stellig"]
[{"$nulls":3}," ja, Bezug zu mehreren Bestellungen. Bitte Bestellnummern auf der Rechnung eintragen.",{"$nulls":23},false]
[]
[null,4,"Kreditor / Debitor\n(wenn aus Rechnung / Beleg nicht ersichtlich)",{"$nulls":7},"Nr.: (falls bekannt)",null,null,{"$f":"IF(Debitor=\"\",\"\",Debitor)","v":""}]
[{"$nulls":27},false,null,false]
[null,null,{"$f":"IF(Daten!$E$18=0,\"\",Daten!$E$18)","v":""},{"$nulls":7},"Anrede:",{"$nulls":3},"MitarbeiterIn:",{"$nulls":14},false]
[null,null,"Name, Vorname / Firma",{"$nulls":7},"m","w","d",null,"ja",null," nein",{"$nulls":10},false,null,false]
[null,null,{"$f":"IF(Daten!$E$31=0,\"\",Daten!$E$31)","v":""},{"$nulls":7},{"$f":"IF(Daten!$E$43=0,\"\",Daten!$E$43)","v":""}]
[null,null,"Mailadresse",{"$nulls":5},"¬ bei Privatpersonen ®",null,"Steuer-ID (11-stellig)",{"$nulls":3},"Geburtsdatum"]
[null,null,{"$f":"IF(Daten!$E$25=0,\"\",Daten!$E$25&\" \"&Daten!$L$25)","v":""},{"$nulls":7},{"$f":"IF(Daten!$H$27=0,\"\",Daten!$E$27&\" \"&Daten!$H$27)","v":""}]
[null,null,"Strasse, Hausnummer",{"$nulls":7},"PLZ / Ort"]
[{"$nulls":18},"Steuerkennzeichen"]
[null,null,"IBAN",{"$nulls":7},"BIC oder Bankname"]
[null,5,{"$f":"IF(AND(Daten!$V$65=1,MID(Daten!$E$65,1,1)=\"1\",Daten!$X$96=\"X\"),\"Netto\",\"Brutto\")&\"betrag lt. Rechnung\"","v":"Bruttobetrag lt. Rechnung"},{"$nulls":8},{"$f":"IF(AND(Daten!$V$65=1,MID(Daten!$E$65,1,1)=\"1\",Daten!$X$96=\"X\"),\"Netto\",\"Brutto\")&\"betrag abzgl. Skonto\"","v":"Bruttobetrag abzgl. Skonto"},{"$nulls":7},"Währung (falls nicht Euro)"]
[null,null,{"$f":"MAX((Daten!$R$95+Daten!$R$98+Daten!$R$101+Daten!$R$104+Daten!$R$107+Daten!$R$110+Daten!$R$113),-(Daten!$R$95+Daten!$R$98+Daten!$R$101+Daten!$R$104+Daten!$R$107+Daten!$R$110+Daten!$R$113))","v":{"v":0,"d":"0.00"}},{"$nulls":8},{"$f":"C27","v":{"v":0,"d":"0.00"}},{"$nulls":7},{"$f":"IF(Daten!$R$93=\"Euro\",\"\",Daten!$R$93)","v":""},{"$nulls":7},{"$f":"IF(OR(AC$27=\"0\",AC$27=\"\"),\"\",IF((IF(AE$27=\"\",0,AE$27)*10+AC$27*1)<20,CHOOSE((IF(AE$27=\"\",0,AE$27)*10+AC$27*1),\"eins\",\"zwei\",\"drei\",\"vier\",\"fünf\",\"sechs\",\"sieben\",\"acht\",\"neun\",\"zehn\",\"elf\",\"zwölf\",\"dreizehn\",\"vierzehn\",\"fünfzehn\",\"sechzehn\",\"siebzehn\",\"achtzehn\",\"neunzehn\"),CHOOSE(AC$27,\"ein\",\"zwei\",\"drei\",\"vier\",\"fünf\",\"sechs\",\"sieben\",\"acht\",\"neun\")&\"und\"))","v":""},{"$f":"IF(IF(ISERR(SEARCH(\",\",$C$27,1)),LEN($C$27),SEARCH(\",\",$C$27,1)-1)<1,\"\",MID($C$27,IF(ISERR(SEARCH(\",\",$C$27,1)),LEN($C$27),SEARCH(\",\",$C$27,1)-1),1))","v":"0"},{"$f":"IF(AND(AC$27=\"0\",AE$27=\"1\"),\"zehn\",IF(OR(AE$27=\"0\",AE$27=\"\"),\"\",CHOOSE(AE$27,\"\",\"zwanzig\",\"dreissig\",\"vierzig\",\"fünfzig\",\"sechzig\",\"siebzig\",\"achtzig\",\"neunzig\")))","v":""},{"$f":"IF(IF(ISERR(SEARCH(\",\",$C$27,1)),LEN($C$27),SEARCH(\",\",$C$27,1)-1)<2,\"\",MID($C$27,IF(ISERR(SEARCH(\",\",$C$27,1)),LEN($C$27),SEARCH(\",\",$C$27,1)-1)-1,1))","v":""},{"$f":"IF(OR(AG$27=\"0\",AG$27=\"\"),\"\",CHOOSE(AG$27,\"ein\",\"zwei\",\"drei\",\"vier\",\"fünf\",\"sechs\",\"sieben\",\"acht\",\"neun\")&\"hundert\")","v":""},{"$f":"IF(IF(ISERR(SEARCH(\",\",$C$27,1)),LEN($C$27),SEARCH(\",\",$C$27,1)-1)<3,\"\",MID($C$27,IF(ISERR(SEARCH(\",\",$C$27,1)),LEN($C$27),SEARCH(\",\",$C$27,1)-1)-2,1))","v":""},{"$f":"IF(OR(AI$27=\"0\",AI$27=\"\"),\"\",IF((IF(AK$27=\"\",0,AK$27)*10+AI$27*1)<20,CHOOSE((IF(AK$27=\"\",0,AK$27)*10+AI$27*1),\"eintausend\",\"zweitausend\",\"dreitausend\",\"viertausend\",\"fünftausend\",\"sechstausend\",\"siebentausend\",\"achttausend\",\"neuntausend\",\"zehn\",\"elf\",\"zwölf\",\"dreizehn\",\"vierzehn\",\"fünfzehn\",\"sechzehn\",\"siebzehn\",\"achtzehn\",\"neunzehn\"),CHOOSE(AI$27,\"ein\",\"zwei\",\"drei\",\"vier\",\"fünf\",\"sechs\",\"sieben\",\"acht\",\"neun\")&\"und\"))","v":""},{"$f":"IF(IF(ISERR(SEARCH(\",\",$C$27,1)),LEN($C$27),SEARCH(\",\",$C$27,1)-1)<4,\"\",MID($C$27,IF(ISERR(SEARCH(\",\",$C$27,1)),LEN($C$27),SEARCH(\",\",$C$27,1)-1)-3,1))","v":""},{"$f":"IF(AND(AI$27=\"0\",AK$27=\"1\"),\"zehntausend\",IF(OR(AK$27=\"0\",AK$27=\"\"),\"\",CHOOSE(AK$27,\"\",\"zwanzig\",\"dreissig\",\"vierzig\",\"fünfzig\",\"sechzig\",\"siebzig\",\"achtzig\",\"neunzig\")&\"tausend\"))","v":""},{"$f":"IF(IF(ISERR(SEARCH(\",\",$C$27,1)),LEN($C$27),SEARCH(\",\",$C$27,1)-1)<5,\"\",MID($C$27,IF(ISERR(SEARCH(\",\",$C$27,1)),LEN($C$27),SEARCH(\",\",$C$27,1)-1)-4,1))","v":""},{"$f":"IF(OR(AM$27=\"0\",AM$27=\"\"),\"\",CHOOSE(AM$27,\"ein\",\"zwei\",\"drei\",\"vier\",\"fünf\",\"sechs\",\"sieben\",\"acht\",\"neun\")&\"hundert\")&IF(AND(AI$27=\"0\",AK$27=\"0\"),\"tausend\",\"\")","v":""},{"$f":"IF(IF(ISERR(SEARCH(\",\",$C$27,1)),LEN($C$27),SEARCH(\",\",$C$27,1)-1)<6,\"\",MID($C$27,IF(ISERR(SEARCH(\",\",$C$27,1)),LEN($C$27),SEARCH(\",\",$C$27,1)-1)-5,1))","v":""}]
[]
[null,null,"Betrag in Worten\n(Inland ab 1.000 €, Fremdwährung ohne Ausnahme)",{"$nulls":6},{"$f":"IF($C$27>999999,\"\",IF(IF(ISERR(SEARCH(\",\",$C$27,1)),LEN($C$27),SEARCH(\",\",$C$27,1)-1)>6,\"\",$AL$27&$AH$27&$AJ$27&$AF$27&$AB$27&$AD$27))","v":""}]
[]
[null,"Sind mehrere Sachkonten betroffen, bitte auf Rechnung bei der jeweiligen Position eintragen und weiter mit 7. Ansonsten bei 6. eintragen."]
[null,6,"Sachkonto: (falls bekannt)\n(Kostenart, Finanzposition)"]
[{"$nulls":9},"8-stellig"]
[null,"Sind mehrere Kontierungsobjekte betroffen, bitte auf Rechnung eintragen oder mit 'Anlage für Splitbuchung' einreichen und weiter mit 8. \nAnsonsten bei 7. eintragen."]
[null,7,"Kontierungsobjekt (Pflichtangabe:  Kostenstelle mit Fonds  ODER  PSP-Element  ODER  Innenauftrag)"]
[null,null,"Kostenstelle\n(Finanzstelle)",{"$nulls":4},"Fonds",{"$nulls":3},"PSP-Element / Projekt\n(Haushaltsprogramm)",{"$nulls":7},"Innenauftrag\n(Haushaltsprogramm)"]
[null,null,{"$f":"IF(OR(Daten!$V$65<>2,Daten!$E$65=0),\"\",Daten!$E$65)","v":""},{"$nulls":4},{"$f":"IF(Daten!$L$65=0,\"\",Daten!$L$65)","v":""},{"$nulls":3},{"$f":"IF(OR(Daten!$V$65<>1,Daten!$E$65=0),\"\",Daten!$E$65)","v":""},{"$nulls":7},{"$f":"IF(OR(Daten!$V$65<>3,Daten!$E$65=0),\"\",Daten!$E$65)","v":""}]
[null,null,"7-stellig",{"$nulls":4},"4-stellig",{"$nulls":3},"10-stellig",{"$nulls":7},"10-stellig"]
[null,8,"Buchungstext - Vorschlag für die Buchhaltung (zur Wiedererkennung = Was für eine Zahlung?)\n(Falls Auswertungs-Kennzeichen gewünscht, dafür die ersten 5 Stellen des Buchungstextes verwenden)"]
[null,null,"A K"]
[{"$nulls":5},{"$f":"IF(Daten!$E$89=0,\"\",MID(Daten!$E$89,1,40))","v":""}]
[]
[null,9,"Begründung - falls dies nicht eindeutig aus der Rechnung hervorgeht (zur Rechtfertigung / Prüfung = Warum die Zahlung?)"]
[null,null,{"$f":"IF(Daten!$E$90=0,\"\",Daten!$E$90)","v":""}]
[null,null,{"$f":"IF(Daten!$E$91=0,\"\",Daten!$E$91)","v":""}]
[]
[null,10,"Sachlich und \nrechnerisch richtig\n(zwingend erforderlich)",{"$nulls":3},"Die Abteilung Rechnungswesen wird angewiesen, den \nBetrag (wenn möglich abzgl. Skonto) wie angegeben \nauszuzahlen / anzunehmen und zu buchen.",{"$nulls":9},11,"Intrahandelsstatistik",{"$nulls":5},"EU-Ausland",{"$nulls":3},{"$f":"IF(AND(Daten!$N$41<>\"DE\",VLOOKUP(Daten!$V$41,Länder!$A:$F,5,FALSE)=\"X\"),TRUE,FALSE)","v":false}]
[]
[null,null,"Datum / Unterschrift",{"$nulls":3},"Datum / Unterschrift der/s Anordnungsbefugten",{"$nulls":10},"Versandland",{"$nulls":4},"Ursprungsland"]
[]
[null,null,"Name in Druckbuchstaben:",{"$nulls":8},"Name in Druckbuchstaben:",{"$nulls":5},"Warennummer",{"$nulls":4},"Warenbezeichnung"]
[null,null,{"$f":"IF(Daten!$E$77=0,\"\",Daten!$E$77)","v":""},{"$nulls":8},{"$f":"IF(Daten!$E$61=0,\"\",Daten!$E$61)","v":""}]
[{"$nulls":17},"Verkehrszweig",{"$nulls":4},"Eigenmasse in kg"]

{"sheet":"Formular","index":3,"n_rows":85,"n_cols":67,"rows_kept":85,"hidden":true,"merged":[[2,6,2,8],[2,10,2,14],[2,16,2,20],[2,22,2,26],[2,28,2,32],[18,0,18,34],[18,55,18,70],[19,0,19,4],[19,5,19,9],[19,13,20,17],[19,19,19,34],[19,36,19,50],[19,55,19,70],[20,0,20,4],[20,5,20,9],[20,19,20,34],[20,36,20,50],[20,55,20,70],[21,0,21,4],[21,5,21,9],[21,13,21,17],[21,19,21,34],[21,36,21,50],[21,55,21,70],[22,0,22,4],[22,5,22,9],[22,19,22,34],[22,36,22,50],[22,55,22,70],[23,0,23,14],[23,19,23,34],[23,36,23,50],[23,55,23,70],[24,0,24,15],[24,19,24,34],[24,36,24,51],[24,55,24,70],[25,0,25,15],[25,19,25,34],[25,36,25,51],[25,55,25,70],[26,0,26,15],[26,19,26,34],[26,36,26,51],[26,55,26,70],[27,0,27,15],[27,19,27,34],[27,36,27,51],[27,55,27,70],[28,0,28,15],[28,19,28,34],[28,36,28,51],[28,55,28,70],[29,0,29,15],[29,19,29,34],[29,36,29,51],[29,55,29,70],[30,0,30,15],[30,19,30,34],[30,36,30,51],[30,55,30,70],[31,0,31,15],[31,19,31,34],[31,36,31,51],[31,55,31,70],[33,19,33,34],[33,55,33,70],[34,19,34,34],[34,55,34,70],[35,0,35,5],[35,6,35,14],[35,19,35,23],[35,25,35,32],[35,36,35,41],[35,42,35,50],[35,55,35,59],[35,61,35,68],[36,19,36,20],[36,22,36,29],[36,31,36,34],[36,55,36,70],[37,0,37,17],[37,19,37,20],[37,22,37,29],[37,31,37,34],[37,36,37,53],[37,55,37,70],[38,0,38,5],[38,19,38,20],[38,22,38,29],[38,31,38,34],[38,36,38,41],[38,55,38,70],[39,0,39,5],[39,19,39,20],[39,22,39,29],[39,31,39,34],[39,36,39,41],[39,55,39,56],[39,58,39,65],[39,67,39,70],[40,0,40,9],[40,10,40,17],[40,19,40,34],[40,46,40,53],[40,55,40,70],[41,0,41,7],[41,10,41,17],[41,36,41,43],[41,46,41,53],[42,0,43,9],[42,19,42,21],[42,22,42,25],[42,26,42,29],[42,30,42,34],[42,36,43,45],[42,55,42,57],[42,58,42,61],[42,62,42,65],[42,66,42,70],[43,19,43,21],[43,22,43,25],[43,26,43,29],[43,30,43,34],[43,55,43,57],[43,58,43,61],[43,62,43,65],[43,66,43,70],[45,1,45,33],[45,37,45,69],[46,1,46,33],[46,37,46,69],[47,1,47,33],[47,37,47,69],[49,2,49,18],[49,19,49,21],[49,22,49,25],[49,26,49,29],[49,30,49,34],[49,38,49,54],[49,55,49,57],[49,58,49,61],[49,62,49,65],[49,66,49,70],[50,2,50,5],[50,6,50,7],[50,9,50,13],[50,14,50,18],[50,22,50,25],[50,26,50,29],[50,30,50,34],[50,38,50,41],[50,42,50,43],[50,45,50,49],[50,50,50,54],[50,58,50,61],[50,62,50,65],[50,66,50,70],[52,2,52,18],[52,19,52,21],[52,22,52,25],[52,26,52,29],[52,30,52,34],[52,38,52,54],[52,55,52,57],[52,58,52,61],[52,62,52,65],[52,66,52,70],[53,2,53,5],[53,6,53,7],[53,9,53,13],[53,14,53,18],[53,30,53,34],[53,38,53,41],[53,42,53,43],[53,45,53,49],[53,50,53,54],[53,58,53,61],[53,62,53,65],[53,66,53,70],[55,2,55,18],[55,19,55,21],[55,22,55,25],[55,26,55,29],[55,30,55,34],[55,38,55,54],[55,55,55,57],[55,58,55,61],[55,62,55,65],[55,66,55,70],[56,2,56,5],[56,6,56,7],[56,9,56,13],[56,14,56,18],[56,30,56,34],[56,38,56,41],[56,42,56,43],[56,45,56,49],[56,50,56,54],[56,58,56,61],[56,62,56,65],[56,66,56,70],[58,2,58,18],[58,19,58,21],[58,22,58,25],[58,26,58,29],[58,30,58,34],[58,38,58,54],[58,55,58,57],[58,58,58,61],[58,62,58,65],[58,66,58,70],[59,2,59,5],[59,6,59,7],[59,9,59,13],[59,14,59,18],[59,30,59,34],[59,38,59,41],[59,42,59,43],[59,45,59,49],[59,50,59,54],[59,58,59,61],[59,62,59,65],[59,66,59,70],[61,2,61,18],[61,19,61,21],[61,22,61,25],[61,26,61,29],[61,30,61,34],[61,38,61,54],[61,55,61,57],[61,58,61,61],[61,62,61,65],[61,66,61,70],[62,2,62,5],[62,6,62,7],[62,9,62,13],[62,14,62,18],[62,30,62,34],[62,38,62,41],[62,42,62,43],[62,45,62,49],[62,50,62,54],[62,58,62,61],[62,62,62,65],[62,66,62,70],[64,2,64,18],[64,19,64,21],[64,22,64,25],[64,26,64,29],[64,30,64,34],[64,38,64,54],[64,55,64,57],[64,58,64,61],[64,62,64,65],[64,66,64,70],[65,2,65,5],[65,6,65,7],[65,9,65,13],[65,14,65,18],[65,30,65,34],[65,38,65,41],[65,42,65,43],[65,45,65,49],[65,50,65,54],[65,58,65,61],[65,62,65,65],[65,66,65,70],[67,2,67,18],[67,19,67,21],[67,22,67,25],[67,26,67,29],[67,30,67,34],[67,38,67,54],[67,55,67,57],[67,58,67,61],[67,62,67,65],[67,66,67,70],[68,2,68,5],[68,6,68,7],[68,9,68,13],[68,14,68,18],[68,30,68,34],[68,38,68,41],[68,42,68,43],[68,45,68,49],[68,50,68,54],[68,58,68,61],[68,62,68,65],[68,66,68,70],[71,0,71,10],[71,11,71,17],[71,30,71,34],[71,36,71,46],[71,47,71,53],[71,66,71,70],[74,0,74,2],[74,4,74,31],[74,32,74,34],[74,36,74,38],[74,40,74,67],[74,68,74,70],[75,9,76,21],[76,0,76,7],[76,23,76,34],[77,0,77,7],[77,23,77,34],[78,1,78,34],[78,37,78,70],[79,1,79,34],[79,37,79,70],[80,1,80,34],[80,37,80,70]]}
[]
[null,"Sprache",{"$nulls":4},"Fonds",{"$nulls":3},"Kostenstelle",{"$nulls":4},"/","Innenauftrag",{"$nulls":4},"/","PSP-Element",{"$nulls":5},"Rech.-Nr."]
[{"$nulls":10},{"$f":"IF(Daten!$V$16=2,3500520,IF($AJ$38=3,3500550,CHOOSE(Kontierung_Art,IF(OR(MID(Kontierung_Nr,1,1)=\"1\",MID(Kontierung_Nr,1,1)=\"2\"),IF(Daten!$V$69=TRUE,3500500,3500500),IF(Daten!$V$69=TRUE,3500510,3500510)),IF(Daten!$V$69=TRUE,3500510,3500510),IF(Daten!$V$69=TRUE,3500510,3500510))))","v":{"v":3500510,"d":"3 5 0 0 5 1 0"}},{"$nulls":24},{"$f":"IF(OR(Daten!$N$29=\"DE\",Daten!$N$29=\"AT\",Daten!$N$29=\"CH\"),1,2)","v":1}]
[]
[]
[null,"Privatperson oder Unternehmer ?",{"$nulls":14},"Lieferung oder Leistung ?",{"$nulls":11},"DE",null,"EU",null,"DL",null,null,{"$f":"IF(AC7=\"X\",AC6,IF(AE7=\"X\",AE6,IF(AG7=\"X\",AG6,\"\")))","v":"DE"}]
[{"$nulls":28},{"$f":"IF(Daten!$N$41=\"DE\",\"X\",\"\")","v":"X"},null,{"$f":"IF(OR(ISNA(VLOOKUP(Daten!$V$41,Länder!$A:$E,5,FALSE)),$AC$7=\"X\"),\"\",VLOOKUP(Daten!$V$41,Länder!$A:$E,5,FALSE))","v":""},null,{"$f":"IF(OR($AC$7=\"X\",$AE$7=\"X\"),\"\",\"X\")","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(Daten!$V$23,Rechtsformen!$A:$B,2,FALSE)),2,IF(VLOOKUP(Daten!$V$23,Rechtsformen!$A:$B,2,FALSE)=\"Privatperson\",1,2))","v":2}]
[{"$nulls":35},2]
[]
[null,"Hinweis",{"$nulls":33},{"$f":"IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),AND(Kontierung_Art=1,MID(Kontierung_Nr,1,2)=\"26\",Steuerkennzeichen!$K$1=\"A_\")),8,Steuerkennzeichen!$L$1)","v":1}]
[{"$f":"IF(AND(Kontierung_Art=1,OR(MID(Kontierung_Nr,1,1)=\"1\",MID(Kontierung_Nr,1,2)=\"26\")),\"AS\",\"AN\")","v":"AN"},{"$f":"CHOOSE(Sprache,\"nicht steuerbarer Vorgang\",\"non-fiscal performance\")","v":"nicht steuerbarer Vorgang"},{"$nulls":16},{"$f":"IF(AND(Kontierung_Art=1,OR(MID(Kontierung_Nr,1,1)=\"1\",MID(Kontierung_Nr,1,2)=\"26\")),\"AS - nicht steuerbar\",\"AN - nicht steuerbar\")","v":"AN - nicht steuerbar"},{"$nulls":4},{"$f":"CHOOSE(Sprache,\"Betrag wird überwiesen\",\"Due Date\")","v":"Betrag wird überwiesen"},{"$nulls":6},{"$f":"CHOOSE(Sprache,IF($AE$72<0,\"Gutschrift\",\"Rechnung\"),IF($AE$72<0,\"Credit\",\"Invoice\"))","v":"Rechnung"}]
["A5",{"$f":"CHOOSE(Sprache,\"steuerfreie innergemeinschaftliche Lieferung\",\"Free of VAT for export with EU\")","v":"steuerfreie innergemeinschaftliche Lieferung"},{"$nulls":16},"A5 - steuerfrei",{"$nulls":4},{"$f":"CHOOSE(Sprache,\"Zahlbar ohne Abzug bis zum\",\"Due Date\")","v":"Zahlbar ohne Abzug bis zum"},{"$nulls":6},{"$f":"CHOOSE(Sprache,\"Kostenvoranschlag\",\"Estimate\")","v":"Kostenvoranschlag"}]
["A6",{"$f":"CHOOSE(Sprache,\"steuerfreie Ausfuhrlieferung\",\"Tax free export\")","v":"steuerfreie Ausfuhrlieferung"},{"$nulls":16},"A6 - steuerfrei",{"$nulls":4},{"$f":"CHOOSE(Sprache,\"Mit Kreditkarte bezahlt am\",\"Paid on\")","v":"Mit Kreditkarte bezahlt am"},{"$nulls":6},{"$f":"CHOOSE(Sprache,\"Pro Forma Rechnung\",\"Pro Forma Invoice\")","v":"Pro Forma Rechnung"}]
["A7",{"$f":"CHOOSE(Sprache,\"Steuerschuldnerschaft des Leistungsempfängers (Reverse Charge Verfahren)\",\"Recipient is liable for VAT under the reverse charge mechanism\")","v":"Steuerschuldnerschaft des Leistungsempfängers (Reverse Charge Verfahren)"},{"$nulls":16},"A7 - nicht steuerbar",{"$nulls":4},{"$f":"CHOOSE(Sprache,\"Per Vorkasse bezahlt am\",\"Paid on\")","v":"Per Vorkasse bezahlt am"},{"$nulls":6},{"$f":"CHOOSE(Sprache,\"Zahlungsanforderung\",\"Payment Request\")","v":"Zahlungsanforderung"}]
["A8",{"$f":"CHOOSE(Sprache,\"nicht steuerbar im Inland\",\"non-fiscal performance in Germany\")","v":"nicht steuerbar im Inland"},{"$nulls":16},"A8 - nicht steuerbar",{"$nulls":4},"Betrag wird verrechnet",{"$nulls":6},{"$f":"CHOOSE(Sprache,\"Gebührenbescheid\",\"Fee Notice\")","v":"Gebührenbescheid"}]
["A1",{"$f":"CHOOSE(Sprache,\"steuerbar im Inland\",\"fiscal performance in Germany\")","v":"steuerbar im Inland"},{"$nulls":16},"A1 - steuerbar, 19%"]
["A2",{"$f":"CHOOSE(Sprache,\"steuerbar im Inland\",\"fiscal performance in Germany\")","v":"steuerbar im Inland"},{"$nulls":16},"A2 - steuerbar, 7%"]
[{"$f":"IF(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),\"AI\",\"A0\")","v":"A0"},{"$f":"IF(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),\"Innenumsatz\",CHOOSE(Sprache,\"umsatzsteuerfreier Vorgang\",\"VAT-exempt transaction\"))","v":"umsatzsteuerfreier Vorgang"},{"$nulls":16},{"$f":"IF(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),\"AI - Innenumsatz\",\"A0 - steuerbar, 0%\")","v":"A0 - steuerbar, 0%"}]
["!!! Mehrfertigung für Abteilung Rechnungswesen !!!"]
["Debitor:",{"$nulls":4},{"$f":"CHOOSE(Daten!$V$16,IF(Debitor=\"\",\"\",Debitor),\"602326\",\"\")","v":""},{"$nulls":7},"E",{"$nulls":5},{"$f":"IF(Daten!$E$56=\"\",\"\",Daten!$E$56)","v":""},{"$nulls":35},{"$f":"IF($T$20=\"\",\"\",$T$20)","v":""}]
["Sachkonto:",{"$nulls":18},{"$f":"IF(Daten!$E$57=\"\",\"\",Daten!$E$57)","v":""},{"$nulls":35},{"$f":"IF($T$21=\"\",\"\",$T$21)","v":""}]
[{"$f":"CHOOSE(Kontierung_Art,\"PSP-Element:\",\"Kostenstelle:\",\"Innenauftrag:\")","v":"PSP-Element:"},{"$nulls":4},{"$f":"Kontierung_Nr","v":{"v":0,"d":"0000000"}},{"$nulls":7},"Einnahme",{"$nulls":41},{"$f":"IF($T$22=\"\",\"\",$T$22)","v":""}]
["Fonds:",{"$nulls":4},{"$f":"IF(Daten!$L$65=\"\",IF($G$3=\"\",\"\",$G$3),Daten!$L$65)","v":""},{"$nulls":13},{"$f":"IF(Daten!$E$59=\"\",\"\",Daten!$E$59)","v":""},{"$nulls":35},{"$f":"IF($T$23=\"\",\"\",$T$23)","v":""}]
[]
["Universität Tübingen - Geschwister-Scholl-Platz - 72074 Tübingen",{"$nulls":18},{"$f":"IF(Daten!$E$61=\"\",\"\",Daten!$E$61)","v":""},{"$nulls":16},"Universität Tübingen - Geschwister-Scholl-Platz - 72074 Tübingen",{"$nulls":18},{"$f":"IF($T$25=\"\",\"\",$T$25)","v":""}]
[{"$f":"IF(Daten!$E$18=\"\",\"\",Daten!$E$18)","v":""},{"$nulls":18},{"$f":"IF(Daten!$E$63=\"\",\"\",Daten!$E$63)","v":""},{"$nulls":15},{"$f":"1+SUM($AJ$27:$AJ$29)","v":1},{"$f":"IF($A26=\"\",\"\",$A26)","v":""},{"$nulls":18},{"$f":"IF($T$26=\"\",\"\",$T$26)","v":""}]
[{"$f":"CHOOSE($AJ$26,\"\",Daten!$E$19,Daten!$E$19,Daten!$E$19)","v":""},{"$nulls":34},{"$f":"IF(Daten!$E19=\"\",0,1)","v":0},""]
[{"$f":"CHOOSE($AJ$26,Daten!$E$25&IF(Daten!$L$25=\"\",\"\",\" \"&Daten!$L$25),\"\",Daten!$E$20,Daten!$E$20)","v":""},{"$nulls":18},{"$f":"CHOOSE($AJ$3,\"Kontakt:\",\"Contact:\")&\" \"&Daten!$E$77","v":"Kontakt: "},{"$nulls":15},{"$f":"IF(Daten!$E20=\"\",0,1)","v":0},"",{"$nulls":18},{"$f":"IF($T28=\"\",\"\",$T28)","v":"Kontakt: "}]
[{"$f":"CHOOSE($AJ$26,Daten!$E$27&\" \"&Daten!$H$27,Daten!$E$25&IF(Daten!$L$25=\"\",\"\",\" \"&Daten!$L$25),Daten!$E$25&IF(Daten!$L$25=\"\",\"\",\" \"&Daten!$L$25),Daten!$E$21)","v":" "},{"$nulls":18},{"$f":"CHOOSE($AJ$3,\"Telefon\",\"Phone\")&\"  +49 7071 \"&Daten!$H$79&Daten!$I$79&Daten!$J$79","v":"Telefon  +49 7071 29-"},{"$nulls":15},{"$f":"IF(Daten!$E21=\"\",0,1)","v":0}," ",{"$nulls":18},"Telefon  +49 7071 29-"]
[{"$f":"CHOOSE($AJ$26,\"\",Daten!$E$27&\" \"&Daten!$H$27,Daten!$E$27&\" \"&Daten!$H$27,Daten!$E$25&IF(Daten!$L$25=\"\",\"\",\" \"&Daten!$L$25))","v":""},{"$nulls":18},{"$f":"IF(Daten!$J$81=\"\",\"\",CHOOSE($AJ$3,\"Telefax\",\"Fax\")&\"  +49 7071 \"&Daten!$H$81&Daten!$I$81&Daten!$J$81)","v":""},{"$nulls":16},"",{"$nulls":18},""]
[{"$f":"CHOOSE($AJ$26,\"\",\"\",\"\",Daten!$E$27&\" \"&Daten!$H$27)","v":""},{"$nulls":18},{"$f":"IF(Daten!$E$83=\"\",\"\",Daten!$E$83)","v":""},{"$nulls":16},"",{"$nulls":18},""]
[{"$f":"IF(OR(ISNA(VLOOKUP(Daten!$V$29,Länder!$A:$B,2,FALSE)),Daten!$N$29=\"DE\"),\"\",VLOOKUP(Daten!$V$29,Länder!$A:$B,2,FALSE))","v":""},{"$nulls":18},"www.uni-tuebingen.de",{"$nulls":16},"",{"$nulls":18},"www.uni-tuebingen.de"]
[]
[{"$nulls":19},{"$f":"CHOOSE(Kontierung_Art,\"PSP \",\"KST \",\"IA \")&Kontierung_Nr&IF(Daten!$L$65=\"\",\"\",\", Fonds \"&Daten!$L$65)&IF($F$20=\"\",\"\",\", Deb. \"&$F$20)&IF(OR(Buchung!$A$2=\"\",Buchung!$A$2=\"nicht buchen\"),\"\",\", Beleg \"&Buchung!$A$2)","v":"PSP "},{"$nulls":35},{"$f":"IF($T34=\"\",\"\",$T34)","v":"PSP "}]
[{"$nulls":19},{"$f":"IF(Daten!$X$65=\"\",\"\",\"Sammel-PSP \"&Daten!$X$65)","v":""},{"$nulls":35},{"$f":"IF($T35=\"\",\"\",$T35)","v":""}]
[{"$f":"CHOOSE($AJ$3,\"Tübingen, den\",\"Invoice Date:\")","v":"Tübingen, den"},{"$nulls":5},{"$f":"TODAY()","v":"2024-08-27"},{"$nulls":29},{"$f":"CHOOSE($AJ$3,\"Tübingen, den\",\"Invoice Date:\")","v":"Tübingen, den"},{"$nulls":5},{"$f":"IF($G36=\"\",\"\",$G36)","v":"2024-08-27"}]
[{"$nulls":19},{"$f":"CHOOSE(Formular!$AJ$38,CHOOSE(Sprache,\"Jahr\",\"\"),\"\",CHOOSE(Sprache,\"Jahr\",\"\"),CHOOSE(Sprache,\"Jahr\",\"\"),CHOOSE(Sprache,\"Jahr\",\"\"))","v":"Jahr"},null,{"$f":"IF(Formular!$AJ$38=2,\"\",CHOOSE(Sprache,\"/\",\"\"))","v":"/"},{"$f":"CHOOSE(Formular!$AJ$38,CHOOSE(Sprache,\"KST / Auftrag / PSP\",\"Invoice No.:\"),\"\",CHOOSE(Sprache,\"KST / Auftrag / PSP\",\"Invoice No.:\"),CHOOSE(Sprache,\"KST / Auftrag / PSP\",\"Purpose\"),CHOOSE(Sprache,\"KST / Auftrag / PSP\",\"Purpose\"))","v":"KST / Auftrag / PSP"},{"$nulls":7},{"$f":"IF(Formular!$AJ$38=2,\"\",CHOOSE(Sprache,\"/\",\"\"))","v":"/"},{"$f":"CHOOSE(Formular!$AJ$38,CHOOSE(Sprache,\"Rech.-Nr.\",\"\"),\"\",CHOOSE(Sprache,\"Rech.-Nr.\",\"\"),CHOOSE(Sprache,\"Nr.\",\"\"),CHOOSE(Sprache,\"Nr.\",\"\"))","v":"Rech.-Nr."},{"$nulls":23},{"$f":"CHOOSE(Formular!$AJ$38,CHOOSE(Sprache,\"Rechnungs-Nr.\",\"Invoice No.:\"),\"\",CHOOSE(Sprache,\"Rechnungs-Nr.\",\"Invoice No.:\"),CHOOSE(Sprache,\"Verwendungszweck\",\"Purpose\"),CHOOSE(Sprache,\"Verwendungszweck\",\"Purpose\"))","v":"Rechnungs-Nr."}]
[{"$f":"CHOOSE($AJ$38,$AE$11,$AE$12,$AE$13,$AE$14,$AE$15)","v":"Rechnung"},{"$nulls":18},{"$f":"IF(Formular!$AJ$38=2,\"\",MID(YEAR($G$36),3,1)&\" \"&MID(YEAR($G$36),4,1))","v":"2 4"},null,null,{"$f":"IF(Formular!$AJ$38=2,\"\",IF($K$3<>\"\",$K$3,IF($Q$3<>\"\",$Q$3,$W$3)))","v":{"v":3500510,"d":"0 0 0 3 5 0 0 5 1 0"}},{"$nulls":8},{"$f":"IF(Formular!$AJ$38=2,\"\",$AC$3)","v":{"v":0,"d":"0 0 0 0"}},{"$nulls":3},{"$f":"CHOOSE(Kontierung_Art,IF(OR(MID(Kontierung_Nr,1,1)=\"1\",MID(Kontierung_Nr,1,1)=\"2\"),IF(Daten!$V$69=TRUE,2,1),IF(Daten!$V$69=TRUE,5,1)),IF(Daten!$V$69=TRUE,5,1),IF(Daten!$V$69=TRUE,5,1))","v":1},{"$f":"$A$38","v":"Rechnung"},{"$nulls":18},{"$f":"IF(Formular!$AJ$38=2,\"\",$T$38&CHOOSE(LEN($W$38),\" ? KST / IA / PSP ? \",\" ? KST / IA / PSP ? \",\" ? KST / IA / PSP ? \",\" ? KST / IA / PSP ? \",\" ? KST / IA / PSP ? \",\" ? KST / IA / PSP ? \",\" 0 0 0 \"&MID($W$38,1,1)&\" \"&MID($W$38,2,1)&\" \"&MID($W$38,3,1)&\" \"&MID($W$38,4,1)&\" \"&MID($W$38,5,1)&\" \"&MID($W$38,6,1)&\" \"&MID($W$38,7,1),\" ? KST / IA / PSP? \",\" ? KST / IA / PSP? \",\" \"&MID($W$38,1,1)&\" \"&MID($W$38,2,1)&\" \"&MID($W$38,3,1)&\" \"&MID($W$38,4,1)&\" \"&MID($W$38,5,1)&\" \"&MID($W$38,6,1)&\" \"&MID($W$38,7,1)&\" \"&MID($W$38,8,1)&\" \"&MID($W$38,9,1)&\" \"&MID($W$38,10,1))&CHOOSE(LEN($AF$38),\" 0 0 0 \"&MID($AF$38,1,1),\" 0 0 \"&MID($AF$38,1,1)&\" \"&MID($AF$38,2,1),\" 0 \"&MID($AF$38,1,1)&\" \"&MID($AF$38,2,1)&\" \"&MID($AF$38,3,1),\" \"&MID($AF$38,1,1)&\" \"&MID($AF$38,2,1)&\" \"&MID($AF$38,3,1)&\" \"&MID($AF$38,4,1)))","v":"2 4 0 0 0 3 5 0 0 5 1 0 0 0 0 0"}]
[{"$nulls":19},"- -",null,null,"- - - - - - - - - -",{"$nulls":8},"- - - -",{"$nulls":23},"- - - - - - - - - - - - - - - -"]
[]
[{"$f":"CHOOSE(Formular!$AJ$38,CHOOSE(Sprache,\"Ihre Ust-ID-Nr.:\",\"EU Customer VAT registration Nr.:\"),CHOOSE(Sprache,\"Ihre Ust-ID-Nr.:\",\"EU Customer VAT registration Nr.:\"),CHOOSE(Sprache,\"Ihre Ust-ID-Nr.:\",\"EU Customer VAT registration Nr.:\"),\"\",\"\")","v":"Ihre Ust-ID-Nr.:"},{"$nulls":9},{"$f":"IF(Daten!$J$43=\"\",CHOOSE(Formular!$AJ$38,IF(Daten!$E$43=\"\",\"\",Daten!$E$43),IF(Daten!$E$43=\"\",\"\",Daten!$E$43),IF(Daten!$E$43=\"\",\"\",Daten!$E$43),\"\",\"\"),\"!!! UST-ID FEHLT !!!\")","v":""},{"$nulls":8},{"$f":"CHOOSE(Formular!$AJ$38,CHOOSE(Sprache,\"Bei Zahlung unbedingt angeben !\",\"Please quote Invoice No. on payment !\"),\"\",\"\",CHOOSE(Sprache,\"Bei Zahlung unbedingt angeben !\",\"Please quote on payment !\"),CHOOSE(Sprache,\"Bei Zahlung unbedingt angeben !\",\"Please quote on payment !\"))","v":"Bei Zahlung unbedingt angeben !"},{"$nulls":16},{"$f":"$A$41","v":"Ihre Ust-ID-Nr.:"},{"$nulls":9},{"$f":"IF($K41=\"\",\"\",$K41)","v":""},{"$nulls":8},{"$f":"$T$41","v":"Bei Zahlung unbedingt angeben !"}]
[{"$f":"CHOOSE(Formular!$AJ$38,CHOOSE(Sprache,IF(Daten!$H$87=\"\",\"Zeitpunkt\",\"Zeitraum\")&\" der Leistung:\",\"Date of performance:\"),CHOOSE(Sprache,IF(Daten!$H$87=\"\",\"Zeitpunkt\",\"Zeitraum\")&\" der Leistung:\",\"Date of performance:\"),CHOOSE(Sprache,IF(Daten!$H$87=\"\",\"Zeitpunkt\",\"Zeitraum\")&\" der Leistung:\",\"Date of performance:\"),CHOOSE(Sprache,IF(Daten!$H$87=\"\",\"Zeitpunkt\",\"Zeitraum\")&\"\",\"\"),CHOOSE(Sprache,IF(Daten!$H$87=\"\",\"Zeitpunkt\",\"Zeitraum\")&\"\",\"Date\"))","v":"Zeitpunkt der Leistung:"},{"$nulls":7},{"$f":"IF($AJ$10=4,\"1)\",\"\")","v":""},null,{"$f":"IF(DAY(Daten!$E$87)<10,\"0\",\"\")&DAY(Daten!$E$87)&\".\"&IF(MONTH(Daten!$E$87)<10,\"0\",\"\")&MONTH(Daten!$E$87)&\".\"&YEAR(Daten!$E$87)&IF(Daten!$H$87=\"\",\"\",\" - \"&IF(DAY(Daten!$H$87)<10,\"0\",\"\")&DAY(Daten!$H$87)&\".\"&IF(MONTH(Daten!$H$87)<10,\"0\",\"\")&MONTH(Daten!$H$87)&\".\"&YEAR(Daten!$H$87))","v":"00.01.1900"},{"$nulls":25},{"$f":"$A$42","v":"Zeitpunkt der Leistung:"},{"$nulls":7},{"$f":"I42","v":""},null,{"$f":"IF($K42=\"\",\"\",$K42)","v":"00.01.1900"}]
[{"$f":"CHOOSE(Formular!$AJ$38,CHOOSE(Sprache,\"Umfang und Art der Leistung:\",\"Content of performance:\"),CHOOSE(Sprache,\"Umfang und Art der Leistung:\",\"Content of performance:\"),CHOOSE(Sprache,\"Umfang und Art der Leistung:\",\"Content of performance:\"),CHOOSE(Sprache,\"\",\"\"),CHOOSE(Sprache,\"\",\"\"))","v":"Umfang und Art der Leistung:"},{"$nulls":18},{"$f":"IF(AND(Daten!$V$16=2,MID(Daten!$E$38,1,1)=\"1\",MID(Kontierung_Nr,1,1)=\"1\"),\"\",CHOOSE($AJ$10,\"\",CHOOSE(Sprache,\"MWST\",\"VAT\"),CHOOSE(Sprache,\"MWST\",\"VAT\"),CHOOSE(Sprache,\"MWST\",\"VAT\"),CHOOSE(Sprache,\"MWST\",\"VAT\"),CHOOSE(Sprache,\"MWST\",\"VAT\"),CHOOSE(Sprache,\"MWST\",\"VAT\"),CHOOSE(Sprache,\"MWST\",\"VAT\")))","v":""},null,null,{"$f":"IF(AND(Daten!$V$16=2,MID(Daten!$E$38,1,1)=\"1\",MID(Kontierung_Nr,1,1)=\"1\"),\"\",CHOOSE($AJ$10,\"\",\"\",\"\",\"\",\"\",CHOOSE(Sprache,\"Nettobetrag\",\"Net Amount\"),CHOOSE(Sprache,\"Nettobetrag\",\"Net Amount\"),CHOOSE(Sprache,\"Nettobetrag\",\"Net Amount\")))","v":""},{"$nulls":3},{"$f":"IF(AND(Daten!$V$16=2,MID(Daten!$E$38,1,1)=\"1\",MID(Kontierung_Nr,1,1)=\"1\"),\"\",CHOOSE($AJ$10,\"\",\"\",\"\",\"\",\"\",CHOOSE(Sprache,\"Steuer\",\"Tax\"),CHOOSE(Sprache,\"Steuer\",\"Tax\"),CHOOSE(Sprache,\"Steuer\",\"Tax\")))","v":""},{"$nulls":3},{"$f":"IF(AND(Daten!$V$16=2,MID(Daten!$E$38,1,1)=\"1\",MID(Kontierung_Nr,1,1)=\"1\"),\"Betrag\",CHOOSE($AJ$10,CHOOSE(Sprache,\"Betrag\",\"Amount\"),CHOOSE(Sprache,\"Betrag\",\"Amount\"),CHOOSE(Sprache,\"Betrag\",\"Amount\"),CHOOSE(Sprache,\"Betrag\",\"Amount\"),CHOOSE(Sprache,\"Betrag\",\"Amount\"),CHOOSE(Sprache,\"Bruttobetrag\",\"Gross Amount\"),CHOOSE(Sprache,\"Bruttobetrag\",\"Gross Amount\"),CHOOSE(Sprache,\"Bruttobetrag\",\"Gross Amount\")))","v":"Betrag"},{"$nulls":5},{"$f":"$A$43","v":"Umfang und Art der Leistung:"},{"$nulls":18},{"$f":"T43","v":""},null,null,{"$f":"W43","v":""},{"$nulls":3},{"$f":"AA43","v":""},{"$nulls":3},{"$f":"AE43","v":"Betrag"}]
[{"$nulls":19},{"$f":"IF(AND(Daten!$V$16=2,MID(Daten!$E$38,1,1)=\"1\",MID(Kontierung_Nr,1,1)=\"1\"),\"\",CHOOSE($AJ$10,\"\",\"%\",\"%\",\"%\",\"%\",\"%\",\"%\",\"%\"))","v":""},null,null,{"$f":"CHOOSE($AJ$10,\"\",\"\",\"\",\"\",\"\",Daten!$R$93,Daten!$R$93,\"\")","v":""},{"$nulls":3},{"$f":"IF(AND(Daten!$V$16=2,MID(Daten!$E$38,1,1)=\"1\",MID(Kontierung_Nr,1,1)=\"1\"),\"\",CHOOSE($AJ$10,\"\",\"\",\"\",\"\",\"\",Daten!$R$93,Daten!$R$93,Daten!$R$93))","v":""},{"$nulls":3},{"$f":"Daten!$R$93","v":"Euro"},{"$nulls":24},{"$f":"T44","v":""},null,null,{"$f":"W44","v":""},{"$nulls":3},{"$f":"AA44","v":""},{"$nulls":3},{"$f":"AE44","v":"Euro"}]
[]
[null,{"$f":"IF(Daten!$E$89=\"\",\"\",Daten!$E$89)","v":""},{"$nulls":35},{"$f":"IF($B46=\"\",\"\",$B46)","v":""}]
[null,{"$f":"IF(Daten!$E$90=\"\",\"\",Daten!$E$90)","v":""},{"$nulls":35},""]
[null,{"$f":"IF(Daten!$E$91=\"\",\"\",Daten!$E$91)","v":""},{"$nulls":35},""]
[{"$nulls":37},""]
[{"$f":"\"            <cbc:CompanyID>\"&\"DE812383453\"&\"</cbc:CompanyID>\"","v":"            <cbc:CompanyID>DE812383453</cbc:CompanyID>"},{"$f":"IF(Daten!$F95=\"\",\"\",Daten!$E95)","v":""},{"$f":"IF(Daten!$F$95=\"\",\"\",Daten!$F$95)","v":""},{"$nulls":16},{"$f":"IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F95=\"\"),\"\",CHOOSE($AJ50,0/100,0/100,0/100,0/100,0/100,19/100,7/100,0/100))","v":""},null,null,{"$f":"CHOOSE($AJ$10,\"\",\"\",\"\",\"\",\"\",IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F95=\"\"),\"\",IF(Daten!$X$96=\"X\",ROUND(Daten!$R95,2),ROUND($AE50-$AA50,2))),IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F95=\"\"),\"\",IF(Daten!$X$96=\"X\",ROUND(Daten!$R95,2),ROUND($AE50-$AA50,2))),IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F95=\"\"),\"\",ROUND(Daten!$R95,2)))","v":""},{"$nulls":3},{"$f":"CHOOSE($AJ$10,\"\",\"\",\"\",\"\",\"\",IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F95=\"\"),\"\",IF(Daten!$X$96=\"X\",ROUND($W50*$T50,2),ROUND($AE50/(1+$T50)*$T50,2))),IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F95=\"\"),\"\",IF(Daten!$X$96=\"X\",ROUND($W50*$T50,2),ROUND($AE50/(1+$T50)*$T50,2))),IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F95=\"\"),\"\",0))","v":""},{"$nulls":3},{"$f":"CHOOSE($AJ$10,IF(Daten!$F95=\"\",\"\",ROUND(Daten!$R95,2)),IF(Daten!$F95=\"\",\"\",ROUND(Daten!$R95,2)),IF(Daten!$F95=\"\",\"\",ROUND(Daten!$R95,2)),IF(Daten!$F95=\"\",\"\",ROUND(Daten!$R95,2)),IF(Daten!$F95=\"\",\"\",ROUND(Daten!$R95,2)),IF(Daten!$F95=\"\",\"\",IF(Daten!$X$96=\"X\",ROUND(IF($W50=\"\",0,$W50)+IF($AA50=\"\",0,$AA50),2),ROUND(Daten!$R95,2))),IF(Daten!$F95=\"\",\"\",IF(Daten!$X$96=\"X\",ROUND(IF($W50=\"\",0,$W50)+IF($AA50=\"\",0,$AA50),2),ROUND(Daten!$R95,2))),IF(Daten!$F95=\"\",\"\",ROUND(Daten!$R95,2)))","v":""},{"$nulls":4},{"$f":"IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),AND(Kontierung_Art=1,MID(Kontierung_Nr,1,2)=\"26\",Steuerkennzeichen!$K$1=\"A_\")),8,Steuerkennzeichen!$L$1)","v":1},null,{"$f":"IF(OR($B50=\"\",$B53=\"\"),\"\",$B50)","v":""},{"$f":"IF($C50=\"\",\"\",$C50)","v":""},{"$nulls":16},{"$f":"IF($AJ50=1,\"\",T50)","v":""},null,null,{"$f":"IF($AJ50=1,\"\",W50)","v":""},{"$nulls":3},{"$f":"IF($AJ50=1,\"\",AA50)","v":""},{"$nulls":3},{"$f":"IF($AE50=\"\",\"\",$AE50)","v":""}]
[null,{"$f":"CHOOSE($AJ50,$A$11,$A$12,$A$13,$A$14,$A$15,$A$16,$A$17,$A$18)","v":"AN"},{"$f":"IF(OR(Daten!$F95=\"\",Daten!$H96=\"\"),\"\",Daten!$H96)","v":""},{"$nulls":3},{"$f":"IF(OR(Daten!$F95=\"\",Daten!$H96=\"\"),\"\",VLOOKUP(Daten!$V95,Maßeinheiten!$A:$D,3,FALSE))","v":""},null,{"$f":"IF(OR(Daten!$F95=\"\",Daten!$H96=\"\"),\"\",IF($G51=\"%\",\"v.\",\" à \"))","v":""},{"$f":"IF(OR(Daten!$F95=\"\",Daten!$H96=\"\"),\"\",Daten!$O96)","v":""},{"$nulls":4},{"$f":"IF(OR(Daten!$F95=\"\",Daten!$H96=\"\"),\"\",Daten!$R$93&IF($G51=\"%\",\"\",\" / \"&Formular!$G51))","v":""},{"$nulls":23},{"$f":"IF(C51=\"\",\"\",C51)","v":""},{"$nulls":3},{"$f":"IF(G51=\"\",\"\",G51)","v":""},null,{"$f":"IF(I51=\"\",\"\",I51)","v":""},{"$f":"IF(J51=\"\",\"\",J51)","v":""},{"$nulls":4},{"$f":"IF(O51=\"\",\"\",O51)","v":""}]
[{"$nulls":37},""]
[null,{"$f":"IF(Daten!$F98=\"\",\"\",Daten!$E98)","v":""},{"$f":"IF(Daten!$F$98=\"\",\"\",Daten!$F$98)","v":""},{"$nulls":16},{"$f":"IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F98=\"\"),\"\",CHOOSE($AJ53,0/100,0/100,0/100,0/100,0/100,19/100,7/100,0/100))","v":""},null,null,{"$f":"CHOOSE($AJ$10,\"\",\"\",\"\",\"\",\"\",IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F98=\"\"),\"\",IF(Daten!$X$96=\"X\",ROUND(Daten!$R98,2),ROUND($AE53-$AA53,2))),IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F98=\"\"),\"\",IF(Daten!$X$96=\"X\",ROUND(Daten!$R98,2),ROUND($AE53-$AA53,2))),IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F98=\"\"),\"\",ROUND(Daten!$R98,2)))","v":""},{"$nulls":3},{"$f":"CHOOSE($AJ$10,\"\",\"\",\"\",\"\",\"\",IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F98=\"\"),\"\",IF(Daten!$X$96=\"X\",ROUND($W53*$T53,2),ROUND($AE53/(1+$T53)*$T53,2))),IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F98=\"\"),\"\",IF(Daten!$X$96=\"X\",ROUND($W53*$T53,2),ROUND($AE53/(1+$T53)*$T53,2))),IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F98=\"\"),\"\",0))","v":""},{"$nulls":3},{"$f":"CHOOSE($AJ$10,IF(Daten!$F98=\"\",\"\",ROUND(Daten!$R98,2)),IF(Daten!$F98=\"\",\"\",ROUND(Daten!$R98,2)),IF(Daten!$F98=\"\",\"\",ROUND(Daten!$R98,2)),IF(Daten!$F98=\"\",\"\",ROUND(Daten!$R98,2)),IF(Daten!$F98=\"\",\"\",ROUND(Daten!$R98,2)),IF(Daten!$F98=\"\",\"\",IF(Daten!$X$96=\"X\",ROUND(IF($W53=\"\",0,$W53)+IF($AA53=\"\",0,$AA53),2),ROUND(Daten!$R98,2))),IF(Daten!$F98=\"\",\"\",IF(Daten!$X$96=\"X\",ROUND(IF($W53=\"\",0,$W53)+IF($AA53=\"\",0,$AA53),2),ROUND(Daten!$R98,2))),IF(Daten!$F98=\"\",\"\",ROUND(Daten!$R98,2)))","v":""},{"$nulls":4},{"$f":"IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),AND(Kontierung_Art=1,MID(Kontierung_Nr,1,2)=\"26\",Steuerkennzeichen!$K$1=\"A_\")),8,Steuerkennzeichen!$L$1)","v":1},null,"",{"$f":"IF($C53=\"\",\"\",$C53)","v":""},{"$nulls":16},{"$f":"IF($AJ53=1,\"\",T53)","v":""},null,null,{"$f":"IF($AJ53=1,\"\",W53)","v":""},{"$nulls":3},{"$f":"IF($AJ53=1,\"\",AA53)","v":""},{"$nulls":3},{"$f":"IF($AE53=\"\",\"\",$AE53)","v":""}]
[null,{"$f":"CHOOSE($AJ53,$A$11,$A$12,$A$13,$A$14,$A$15,$A$16,$A$17,$A$18)","v":"AN"},{"$f":"IF(OR(Daten!$F98=\"\",Daten!$H99=\"\"),\"\",Daten!$H99)","v":""},{"$nulls":3},{"$f":"IF(OR(Daten!$F98=\"\",Daten!$H99=\"\"),\"\",VLOOKUP(Daten!$V98,Maßeinheiten!$A:$D,3,FALSE))","v":""},null,{"$f":"IF(OR(Daten!$F98=\"\",Daten!$H99=\"\"),\"\",IF($G54=\"%\",\"v.\",\" à \"))","v":""},{"$f":"IF(OR(Daten!$F98=\"\",Daten!$H99=\"\"),\"\",Daten!$O99)","v":""},{"$nulls":4},{"$f":"IF(OR(Daten!$F98=\"\",Daten!$H99=\"\"),\"\",Daten!$R$93&IF($G54=\"%\",\"\",\" / \"&Formular!$G54))","v":""},{"$nulls":23},{"$f":"IF(C54=\"\",\"\",C54)","v":""},{"$nulls":3},{"$f":"IF(G54=\"\",\"\",G54)","v":""},null,{"$f":"IF(I54=\"\",\"\",I54)","v":""},{"$f":"IF(J54=\"\",\"\",J54)","v":""},{"$nulls":4},{"$f":"IF(O54=\"\",\"\",O54)","v":""}]
[{"$nulls":37},""]
[null,{"$f":"IF(Daten!$F101=\"\",\"\",Daten!$E101)","v":""},{"$f":"IF(Daten!$F$101=\"\",\"\",Daten!$F$101)","v":""},{"$nulls":16},{"$f":"IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F101=\"\"),\"\",CHOOSE($AJ56,0/100,0/100,0/100,0/100,0/100,19/100,7/100,0/100))","v":""},null,null,{"$f":"CHOOSE($AJ$10,\"\",\"\",\"\",\"\",\"\",IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F101=\"\"),\"\",IF(Daten!$X$96=\"X\",ROUND(Daten!$R101,2),ROUND($AE56-$AA56,2))),IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F101=\"\"),\"\",IF(Daten!$X$96=\"X\",ROUND(Daten!$R101,2),ROUND($AE56-$AA56,2))),IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F101=\"\"),\"\",ROUND(Daten!$R101,2)))","v":""},{"$nulls":3},{"$f":"CHOOSE($AJ$10,\"\",\"\",\"\",\"\",\"\",IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F101=\"\"),\"\",IF(Daten!$X$96=\"X\",ROUND($W56*$T56,2),ROUND($AE56/(1+$T56)*$T56,2))),IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F101=\"\"),\"\",IF(Daten!$X$96=\"X\",ROUND($W56*$T56,2),ROUND($AE56/(1+$T56)*$T56,2))),IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F101=\"\"),\"\",0))","v":""},{"$nulls":3},{"$f":"CHOOSE($AJ$10,IF(Daten!$F101=\"\",\"\",ROUND(Daten!$R101,2)),IF(Daten!$F101=\"\",\"\",ROUND(Daten!$R101,2)),IF(Daten!$F101=\"\",\"\",ROUND(Daten!$R101,2)),IF(Daten!$F101=\"\",\"\",ROUND(Daten!$R101,2)),IF(Daten!$F101=\"\",\"\",ROUND(Daten!$R101,2)),IF(Daten!$F101=\"\",\"\",IF(Daten!$X$96=\"X\",ROUND(IF($W56=\"\",0,$W56)+IF($AA56=\"\",0,$AA56),2),ROUND(Daten!$R101,2))),IF(Daten!$F101=\"\",\"\",IF(Daten!$X$96=\"X\",ROUND(IF($W56=\"\",0,$W56)+IF($AA56=\"\",0,$AA56),2),ROUND(Daten!$R101,2))),IF(Daten!$F101=\"\",\"\",ROUND(Daten!$R101,2)))","v":""},{"$nulls":4},{"$f":"IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),AND(Kontierung_Art=1,MID(Kontierung_Nr,1,2)=\"26\",Steuerkennzeichen!$K$1=\"A_\")),8,Steuerkennzeichen!$L$1)","v":1},null,"",{"$f":"IF($C56=\"\",\"\",$C56)","v":""},{"$nulls":16},{"$f":"IF($AJ56=1,\"\",T56)","v":""},null,null,{"$f":"IF($AJ56=1,\"\",W56)","v":""},{"$nulls":3},{"$f":"IF($AJ56=1,\"\",AA56)","v":""},{"$nulls":3},{"$f":"IF($AE56=\"\",\"\",$AE56)","v":""}]
[null,{"$f":"CHOOSE($AJ56,$A$11,$A$12,$A$13,$A$14,$A$15,$A$16,$A$17,$A$18)","v":"AN"},{"$f":"IF(OR(Daten!$F101=\"\",Daten!$H102=\"\"),\"\",Daten!$H102)","v":""},{"$nulls":3},{"$f":"IF(OR(Daten!$F101=\"\",Daten!$H102=\"\"),\"\",VLOOKUP(Daten!$V101,Maßeinheiten!$A:$D,3,FALSE))","v":""},null,{"$f":"IF(OR(Daten!$F101=\"\",Daten!$H102=\"\"),\"\",IF($G57=\"%\",\"v.\",\" à \"))","v":""},{"$f":"IF(OR(Daten!$F101=\"\",Daten!$H102=\"\"),\"\",Daten!$O102)","v":""},{"$nulls":4},{"$f":"IF(OR(Daten!$F101=\"\",Daten!$H102=\"\"),\"\",Daten!$R$93&IF($G57=\"%\",\"\",\" / \"&Formular!$G57))","v":""},{"$nulls":23},{"$f":"IF(C57=\"\",\"\",C57)","v":""},{"$nulls":3},{"$f":"IF(G57=\"\",\"\",G57)","v":""},null,{"$f":"IF(I57=\"\",\"\",I57)","v":""},{"$f":"IF(J57=\"\",\"\",J57)","v":""},{"$nulls":4},{"$f":"IF(O57=\"\",\"\",O57)","v":""}]
[{"$nulls":37},""]
[null,{"$f":"IF(Daten!$F104=\"\",\"\",Daten!$E104)","v":""},{"$f":"IF(Daten!$F$104=\"\",\"\",Daten!$F$104)","v":""},{"$nulls":16},{"$f":"IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F104=\"\"),\"\",CHOOSE($AJ59,0/100,0/100,0/100,0/100,0/100,19/100,7/100,0/100))","v":""},null,null,{"$f":"CHOOSE($AJ$10,\"\",\"\",\"\",\"\",\"\",IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F104=\"\"),\"\",IF(Daten!$X$96=\"X\",ROUND(Daten!$R104,2),ROUND($AE59-$AA59,2))),IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F104=\"\"),\"\",IF(Daten!$X$96=\"X\",ROUND(Daten!$R104,2),ROUND($AE59-$AA59,2))),IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F104=\"\"),\"\",ROUND(Daten!$R104,2)))","v":""},{"$nulls":3},{"$f":"CHOOSE($AJ$10,\"\",\"\",\"\",\"\",\"\",IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F104=\"\"),\"\",IF(Daten!$X$96=\"X\",ROUND($W59*$T59,2),ROUND($AE59/(1+$T59)*$T59,2))),IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F104=\"\"),\"\",IF(Daten!$X$96=\"X\",ROUND($W59*$T59,2),ROUND($AE59/(1+$T59)*$T59,2))),IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F104=\"\"),\"\",0))","v":""},{"$nulls":3},{"$f":"CHOOSE($AJ$10,IF(Daten!$F104=\"\",\"\",ROUND(Daten!$R104,2)),IF(Daten!$F104=\"\",\"\",ROUND(Daten!$R104,2)),IF(Daten!$F104=\"\",\"\",ROUND(Daten!$R104,2)),IF(Daten!$F104=\"\",\"\",ROUND(Daten!$R104,2)),IF(Daten!$F104=\"\",\"\",ROUND(Daten!$R104,2)),IF(Daten!$F104=\"\",\"\",IF(Daten!$X$96=\"X\",ROUND(IF($W59=\"\",0,$W59)+IF($AA59=\"\",0,$AA59),2),ROUND(Daten!$R104,2))),IF(Daten!$F104=\"\",\"\",IF(Daten!$X$96=\"X\",ROUND(IF($W59=\"\",0,$W59)+IF($AA59=\"\",0,$AA59),2),ROUND(Daten!$R104,2))),IF(Daten!$F104=\"\",\"\",ROUND(Daten!$R104,2)))","v":""},{"$nulls":4},{"$f":"IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),AND(Kontierung_Art=1,MID(Kontierung_Nr,1,2)=\"26\",Steuerkennzeichen!$K$1=\"A_\")),8,Steuerkennzeichen!$L$1)","v":1},null,"",{"$f":"IF($C59=\"\",\"\",$C59)","v":""},{"$nulls":16},{"$f":"IF($AJ59=1,\"\",T59)","v":""},null,null,{"$f":"IF($AJ59=1,\"\",W59)","v":""},{"$nulls":3},{"$f":"IF($AJ59=1,\"\",AA59)","v":""},{"$nulls":3},{"$f":"IF($AE59=\"\",\"\",$AE59)","v":""}]
[null,{"$f":"CHOOSE($AJ59,$A$11,$A$12,$A$13,$A$14,$A$15,$A$16,$A$17,$A$18)","v":"AN"},{"$f":"IF(OR(Daten!$F104=\"\",Daten!$H105=\"\"),\"\",Daten!$H105)","v":""},{"$nulls":3},{"$f":"IF(OR(Daten!$F104=\"\",Daten!$H105=\"\"),\"\",VLOOKUP(Daten!$V104,Maßeinheiten!$A:$D,3,FALSE))","v":""},null,{"$f":"IF(OR(Daten!$F104=\"\",Daten!$H105=\"\"),\"\",IF($G60=\"%\",\"v.\",\" à \"))","v":""},{"$f":"IF(OR(Daten!$F104=\"\",Daten!$H105=\"\"),\"\",Daten!$O105)","v":""},{"$nulls":4},{"$f":"IF(OR(Daten!$F104=\"\",Daten!$H105=\"\"),\"\",Daten!$R$93&IF($G60=\"%\",\"\",\" / \"&Formular!$G60))","v":""},{"$nulls":23},{"$f":"IF(C60=\"\",\"\",C60)","v":""},{"$nulls":3},{"$f":"IF(G60=\"\",\"\",G60)","v":""},null,{"$f":"IF(I60=\"\",\"\",I60)","v":""},{"$f":"IF(J60=\"\",\"\",J60)","v":""},{"$nulls":4},{"$f":"IF(O60=\"\",\"\",O60)","v":""}]
[{"$nulls":37},""]
[null,{"$f":"IF(Daten!$F107=\"\",\"\",Daten!$E107)","v":""},{"$f":"IF(Daten!$F$107=\"\",\"\",Daten!$F$107)","v":""},{"$nulls":16},{"$f":"IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F107=\"\"),\"\",CHOOSE($AJ62,0/100,0/100,0/100,0/100,0/100,19/100,7/100,0/100))","v":""},null,null,{"$f":"CHOOSE($AJ$10,\"\",\"\",\"\",\"\",\"\",IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F107=\"\"),\"\",IF(Daten!$X$96=\"X\",ROUND(Daten!$R107,2),ROUND($AE62-$AA62,2))),IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F107=\"\"),\"\",IF(Daten!$X$96=\"X\",ROUND(Daten!$R107,2),ROUND($AE62-$AA62,2))),IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F107=\"\"),\"\",ROUND(Daten!$R107,2)))","v":""},{"$nulls":3},{"$f":"CHOOSE($AJ$10,\"\",\"\",\"\",\"\",\"\",IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F107=\"\"),\"\",IF(Daten!$X$96=\"X\",ROUND($W62*$T62,2),ROUND($AE62/(1+$T62)*$T62,2))),IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F107=\"\"),\"\",IF(Daten!$X$96=\"X\",ROUND($W62*$T62,2),ROUND($AE62/(1+$T62)*$T62,2))),IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F107=\"\"),\"\",0))","v":""},{"$nulls":3},{"$f":"CHOOSE($AJ$10,IF(Daten!$F107=\"\",\"\",ROUND(Daten!$R107,2)),IF(Daten!$F107=\"\",\"\",ROUND(Daten!$R107,2)),IF(Daten!$F107=\"\",\"\",ROUND(Daten!$R107,2)),IF(Daten!$F107=\"\",\"\",ROUND(Daten!$R107,2)),IF(Daten!$F107=\"\",\"\",ROUND(Daten!$R107,2)),IF(Daten!$F107=\"\",\"\",IF(Daten!$X$96=\"X\",ROUND(IF($W62=\"\",0,$W62)+IF($AA62=\"\",0,$AA62),2),ROUND(Daten!$R107,2))),IF(Daten!$F107=\"\",\"\",IF(Daten!$X$96=\"X\",ROUND(IF($W62=\"\",0,$W62)+IF($AA62=\"\",0,$AA62),2),ROUND(Daten!$R107,2))),IF(Daten!$F107=\"\",\"\",ROUND(Daten!$R107,2)))","v":""},{"$nulls":4},{"$f":"IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),AND(Kontierung_Art=1,MID(Kontierung_Nr,1,2)=\"26\",Steuerkennzeichen!$K$1=\"A_\")),8,Steuerkennzeichen!$L$1)","v":1},null,"",{"$f":"IF($C62=\"\",\"\",$C62)","v":""},{"$nulls":16},{"$f":"IF($AJ62=1,\"\",T62)","v":""},null,null,{"$f":"IF($AJ62=1,\"\",W62)","v":""},{"$nulls":3},{"$f":"IF($AJ62=1,\"\",AA62)","v":""},{"$nulls":3},{"$f":"IF($AE62=\"\",\"\",$AE62)","v":""}]
[null,{"$f":"CHOOSE($AJ62,$A$11,$A$12,$A$13,$A$14,$A$15,$A$16,$A$17,$A$18)","v":"AN"},{"$f":"IF(OR(Daten!$F107=\"\",Daten!$H108=\"\"),\"\",Daten!$H108)","v":""},{"$nulls":3},{"$f":"IF(OR(Daten!$F107=\"\",Daten!$H108=\"\"),\"\",VLOOKUP(Daten!$V107,Maßeinheiten!$A:$D,3,FALSE))","v":""},null,{"$f":"IF(OR(Daten!$F107=\"\",Daten!$H108=\"\"),\"\",IF($G63=\"%\",\"v.\",\" à \"))","v":""},{"$f":"IF(OR(Daten!$F107=\"\",Daten!$H108=\"\"),\"\",Daten!$O108)","v":""},{"$nulls":4},{"$f":"IF(OR(Daten!$F107=\"\",Daten!$H108=\"\"),\"\",Daten!$R$93&IF($G63=\"%\",\"\",\" / \"&Formular!$G63))","v":""},{"$nulls":23},{"$f":"IF(C63=\"\",\"\",C63)","v":""},{"$nulls":3},{"$f":"IF(G63=\"\",\"\",G63)","v":""},null,{"$f":"IF(I63=\"\",\"\",I63)","v":""},{"$f":"IF(J63=\"\",\"\",J63)","v":""},{"$nulls":4},{"$f":"IF(O63=\"\",\"\",O63)","v":""}]
[{"$nulls":37},""]
[null,{"$f":"IF(Daten!$F110=\"\",\"\",Daten!$E110)","v":""},{"$f":"IF(Daten!$F$110=\"\",\"\",Daten!$F$110)","v":""},{"$nulls":16},{"$f":"IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F110=\"\"),\"\",CHOOSE($AJ65,0/100,0/100,0/100,0/100,0/100,19/100,7/100,0/100))","v":""},null,null,{"$f":"CHOOSE($AJ$10,\"\",\"\",\"\",\"\",\"\",IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F110=\"\"),\"\",IF(Daten!$X$96=\"X\",ROUND(Daten!$R110,2),ROUND($AE65-$AA65,2))),IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F110=\"\"),\"\",IF(Daten!$X$96=\"X\",ROUND(Daten!$R110,2),ROUND($AE65-$AA65,2))),IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F110=\"\"),\"\",ROUND(Daten!$R110,2)))","v":""},{"$nulls":3},{"$f":"CHOOSE($AJ$10,\"\",\"\",\"\",\"\",\"\",IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F110=\"\"),\"\",IF(Daten!$X$96=\"X\",ROUND($W65*$T65,2),ROUND($AE65/(1+$T65)*$T65,2))),IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F110=\"\"),\"\",IF(Daten!$X$96=\"X\",ROUND($W65*$T65,2),ROUND($AE65/(1+$T65)*$T65,2))),IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F110=\"\"),\"\",0))","v":""},{"$nulls":3},{"$f":"CHOOSE($AJ$10,IF(Daten!$F110=\"\",\"\",ROUND(Daten!$R110,2)),IF(Daten!$F110=\"\",\"\",ROUND(Daten!$R110,2)),IF(Daten!$F110=\"\",\"\",ROUND(Daten!$R110,2)),IF(Daten!$F110=\"\",\"\",ROUND(Daten!$R110,2)),IF(Daten!$F110=\"\",\"\",ROUND(Daten!$R110,2)),IF(Daten!$F110=\"\",\"\",IF(Daten!$X$96=\"X\",ROUND(IF($W65=\"\",0,$W65)+IF($AA65=\"\",0,$AA65),2),ROUND(Daten!$R110,2))),IF(Daten!$F110=\"\",\"\",IF(Daten!$X$96=\"X\",ROUND(IF($W65=\"\",0,$W65)+IF($AA65=\"\",0,$AA65),2),ROUND(Daten!$R110,2))),IF(Daten!$F110=\"\",\"\",ROUND(Daten!$R110,2)))","v":""},{"$nulls":4},{"$f":"IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),AND(Kontierung_Art=1,MID(Kontierung_Nr,1,2)=\"26\",Steuerkennzeichen!$K$1=\"A_\")),8,Steuerkennzeichen!$L$1)","v":1},null,"",{"$f":"IF($C65=\"\",\"\",$C65)","v":""},{"$nulls":16},{"$f":"IF($AJ65=1,\"\",T65)","v":""},null,null,{"$f":"IF($AJ65=1,\"\",W65)","v":""},{"$nulls":3},{"$f":"IF($AJ65=1,\"\",AA65)","v":""},{"$nulls":3},{"$f":"IF($AE65=\"\",\"\",$AE65)","v":""}]
[null,{"$f":"CHOOSE($AJ65,$A$11,$A$12,$A$13,$A$14,$A$15,$A$16,$A$17,$A$18)","v":"AN"},{"$f":"IF(OR(Daten!$F110=\"\",Daten!$H111=\"\"),\"\",Daten!$H111)","v":""},{"$nulls":3},{"$f":"IF(OR(Daten!$F110=\"\",Daten!$H111=\"\"),\"\",VLOOKUP(Daten!$V110,Maßeinheiten!$A:$D,3,FALSE))","v":""},null,{"$f":"IF(OR(Daten!$F110=\"\",Daten!$H111=\"\"),\"\",IF($G66=\"%\",\"v.\",\" à \"))","v":""},{"$f":"IF(OR(Daten!$F110=\"\",Daten!$H111=\"\"),\"\",Daten!$O111)","v":""},{"$nulls":4},{"$f":"IF(OR(Daten!$F110=\"\",Daten!$H111=\"\"),\"\",Daten!$R$93&IF($G66=\"%\",\"\",\" / \"&Formular!$G66))","v":""},{"$nulls":23},{"$f":"IF(C66=\"\",\"\",C66)","v":""},{"$nulls":3},{"$f":"IF(G66=\"\",\"\",G66)","v":""},null,{"$f":"IF(I66=\"\",\"\",I66)","v":""},{"$f":"IF(J66=\"\",\"\",J66)","v":""},{"$nulls":4},{"$f":"IF(O66=\"\",\"\",O66)","v":""}]
[{"$nulls":37},""]
[null,{"$f":"IF(Daten!$F113=\"\",\"\",Daten!$E113)","v":""},{"$f":"IF(Daten!$F$113=\"\",\"\",Daten!$F$113)","v":""},{"$nulls":16},{"$f":"IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F113=\"\"),\"\",CHOOSE($AJ68,0/100,0/100,0/100,0/100,0/100,19/100,7/100,0/100))","v":""},null,null,{"$f":"CHOOSE($AJ$10,\"\",\"\",\"\",\"\",\"\",IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F113=\"\"),\"\",IF(Daten!$X$96=\"X\",ROUND(Daten!$R113,2),ROUND($AE68-$AA68,2))),IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F113=\"\"),\"\",IF(Daten!$X$96=\"X\",ROUND(Daten!$R113,2),ROUND($AE68-$AA68,2))),IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F113=\"\"),\"\",ROUND(Daten!$R113,2)))","v":""},{"$nulls":3},{"$f":"CHOOSE($AJ$10,\"\",\"\",\"\",\"\",\"\",IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F113=\"\"),\"\",IF(Daten!$X$96=\"X\",ROUND($W68*$T68,2),ROUND($AE68/(1+$T68)*$T68,2))),IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F113=\"\"),\"\",IF(Daten!$X$96=\"X\",ROUND($W68*$T68,2),ROUND($AE68/(1+$T68)*$T68,2))),IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),Daten!$F113=\"\"),\"\",0))","v":""},{"$nulls":3},{"$f":"CHOOSE($AJ$10,IF(Daten!$F113=\"\",\"\",ROUND(Daten!$R113,2)),IF(Daten!$F113=\"\",\"\",ROUND(Daten!$R113,2)),IF(Daten!$F113=\"\",\"\",ROUND(Daten!$R113,2)),IF(Daten!$F113=\"\",\"\",ROUND(Daten!$R113,2)),IF(Daten!$F113=\"\",\"\",ROUND(Daten!$R113,2)),IF(Daten!$F113=\"\",\"\",IF(Daten!$X$96=\"X\",ROUND(IF($W68=\"\",0,$W68)+IF($AA68=\"\",0,$AA68),2),ROUND(Daten!$R113,2))),IF(Daten!$F113=\"\",\"\",IF(Daten!$X$96=\"X\",ROUND(IF($W68=\"\",0,$W68)+IF($AA68=\"\",0,$AA68),2),ROUND(Daten!$R113,2))),IF(Daten!$F113=\"\",\"\",ROUND(Daten!$R113,2)))","v":""},{"$nulls":4},{"$f":"IF(OR(AND(Daten!$V$16=2,Daten!$V$65=1,MID(Daten!$E$38,1,1)=\"1\",MID(Daten!$E$65,1,1)=\"1\"),AND(Kontierung_Art=1,MID(Kontierung_Nr,1,2)=\"26\",Steuerkennzeichen!$K$1=\"A_\")),8,Steuerkennzeichen!$L$1)","v":1},null,"",{"$f":"IF($C68=\"\",\"\",$C68)","v":""},{"$nulls":16},{"$f":"IF($AJ68=1,\"\",T68)","v":""},null,null,{"$f":"IF($AJ68=1,\"\",W68)","v":""},{"$nulls":3},{"$f":"IF($AJ68=1,\"\",AA68)","v":""},{"$nulls":3},{"$f":"IF($AE68=\"\",\"\",$AE68)","v":""}]
[null,{"$f":"CHOOSE($AJ68,$A$11,$A$12,$A$13,$A$14,$A$15,$A$16,$A$17,$A$18)","v":"AN"},{"$f":"IF(OR(Daten!$F113=\"\",Daten!$H114=\"\"),\"\",Daten!$H114)","v":""},{"$nulls":3},{"$f":"IF(OR(Daten!$F113=\"\",Daten!$H114=\"\"),\"\",VLOOKUP(Daten!$V113,Maßeinheiten!$A:$D,3,FALSE))","v":""},null,{"$f":"IF(OR(Daten!$F113=\"\",Daten!$H114=\"\"),\"\",IF($G69=\"%\",\"v.\",\" à \"))","v":""},{"$f":"IF(OR(Daten!$F113=\"\",Daten!$H114=\"\"),\"\",Daten!$O114)","v":""},{"$nulls":4},{"$f":"IF(OR(Daten!$F113=\"\",Daten!$H114=\"\"),\"\",Daten!$R$93&IF($G69=\"%\",\"\",\" / \"&Formular!$G69))","v":""},{"$nulls":23},{"$f":"IF(C69=\"\",\"\",C69)","v":""},{"$nulls":3},{"$f":"IF(G69=\"\",\"\",G69)","v":""},null,{"$f":"IF(I69=\"\",\"\",I69)","v":""},{"$f":"IF(J69=\"\",\"\",J69)","v":""},{"$nulls":4},{"$f":"IF(O69=\"\",\"\",O69)","v":""}]
[]
[]
[{"$f":"CHOOSE($AJ$38,CHOOSE($AJ$72,$X$11,$X$12,$X$13,$X$14,$X$15),\"\",\"\",CHOOSE($AJ$72,$X$11,$X$12,$X$13,$X$14,$X$15),CHOOSE($AJ$72,$X$11,$X$12,$X$13,$X$14,$X$15))","v":"Zahlbar ohne Abzug bis zum"},{"$nulls":10},{"$f":"CHOOSE($AJ$38,IF($AJ$72=2,TODAY()+30,\"\"),\"\",\"\",IF($AJ$72=2,TODAY()+30,\"\"),IF($AJ$72=2,TODAY()+30,\"\"))","v":"2024-09-26"},{"$nulls":11},{"$f":"CHOOSE(Sprache,CHOOSE($AJ$38,IF($AE$72<0,\"Gutschriftsbetrag\",\"Rechnungsbetrag \"),\"Gesamtbetrag\",\"Gesamtbetrag\",\"Gesamtbetrag\",\"Gesamtbetrag\"),\"Final Amount \")","v":"Rechnungsbetrag "},{"$nulls":6},{"$f":"SUM(AE$46:AI$69)","v":{"v":0,"d":"0.00"}},{"$nulls":4},{"$f":"CHOOSE(Daten!$V$16,2,5,2)","v":2},{"$f":"A72","v":"Zahlbar ohne Abzug bis zum"},{"$nulls":10},{"$f":"L72","v":"2024-09-26"},{"$nulls":11},{"$f":"X72","v":"Rechnungsbetrag "},{"$nulls":6},{"$f":"AE72","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$f":"CHOOSE(Sprache,\"Hinweis:\",\"Notice\")","v":"Hinweis:"},null,null,{"$f":"IF($AJ$10=4,\"2)\",\"\")","v":""},{"$f":"CHOOSE(Daten!$V$16,CHOOSE(Formular!$AJ$10,Formular!$B$11,Formular!$B$12,Formular!$B$13,Formular!$B$14,Formular!$B$15,Formular!$B$16,Formular!$B$17,Formular!$B$18),\"Der Betrag wird\"&IF(Daten!$E$38<>\"\",\" dem \"&IF(MID(Daten!$E$38,1,1)=\"8\",\"Innenauftrag\",\"PSP-Element\")&\" \"&Daten!$E$38,IF(Daten!$E$36<>\"\",\" der Kostenstelle \"&Daten!$E$36,\"\"))&\" per Umbuchung belastet!\",\"\")","v":"nicht steuerbarer Vorgang"},{"$nulls":27},{"$f":"CHOOSE($AJ$10,$A$11,$A$12,$A$13,$A$14,$A$15,\"s.o.\",\"s.o.\",\"s.o.\")","v":"AN"},{"$nulls":3},{"$f":"CHOOSE(Sprache,\"Hinweis:\",\"Notice\")","v":"Hinweis:"},null,null,{"$f":"IF($AJ$10=4,\"2)\",\"\")","v":""},{"$f":"E75","v":"nicht steuerbarer Vorgang"}]
[{"$nulls":9},"Die Abteilung Rechnungswesen wird angewiesen, \nden Betrag wie angegeben anzunehmen und zu buchen.",{"$nulls":27},{"$f":"IF(Daten!$V$45=TRUE,\"Lieferung an folgende Adresse:\",\"\")","v":""}]
[{"$nulls":37},{"$f":"IF(Daten!$V$45=TRUE,Daten!$E$45&IF(Daten!$E$46=\"\",\"\",\", \"&Daten!$E$46)&IF(Daten!$E$47=\"\",\"\",\", \"&Daten!$E$47)&IF(Daten!$E$48=\"\",\"\",\", \"&Daten!$E$48),\"\")","v":""}]
["Sachlich und rechnerisch richtig",{"$nulls":22},"Datum und Unterschrift der/s Anordnungsbefugten",{"$nulls":13},{"$f":"IF(Daten!$V$45=TRUE,Daten!$E$50&\" \"&Daten!$L$50&\", \"&Daten!$E$52&\" \"&Daten!$H$52,\"\")","v":""}]
[{"$f":"IF($AJ$10=4,\"1)\",\"\")","v":""},{"$f":"CHOOSE(Formular!$AJ$38,CHOOSE(Sprache,\"Diese Rechnung wurde maschinell erstellt und ist ohne Unterschrift gültig.\",\"This invoice was created automatically and is valid without a signature.\"),\"\",\"\",\"\",CHOOSE(Sprache,\"Dieser Bescheid wurde maschinell erstellt und ist ohne Unterschrift gültig.\",\"\"))","v":"Diese Rechnung wurde maschinell erstellt und ist ohne Unterschrift gültig."},{"$nulls":34},{"$f":"A79","v":""},"Diese Rechnung wurde maschinell erstellt und ist ohne Unterschrift gültig."]
[{"$f":"IF($AJ$10=4,\"1)\",\"\")","v":""},{"$f":"CHOOSE(Formular!$AJ$38,CHOOSE(Sprache,\"Falls kein Leistungsdatum angegeben ist, ist das Rechnungsdatum zugleich das Datum der Erbringung der Leistung.\",\"In case of not explicitly stated a date of performance, invoice date means date of performance as well.\"),\"\",CHOOSE(Sprache,\"Es handelt sich hierbei um eine Pro-Forma-Rechnung zur Vorlage beim Zoll.\",\"This is a pro forma invoice for presentation to customs.\"),\"\",CHOOSE(Sprache,\"Rechtsbehelfsbelehrung: Gegen diesen Bescheid kann innerhalb eines Monats nach Bekanntgabe \",\"\"))","v":"Falls kein Leistungsdatum angegeben ist, ist das Rechnungsdatum zugleich das Datum der Erbringung der Leistung."},{"$nulls":34},"","Falls kein Leistungsdatum angegeben ist, ist das Rechnungsdatum zugleich das Datum der Erbringung der Leistung."]
[{"$f":"IF($AJ$10=4,\"2)\",\"\")","v":""},{"$f":"IF(AND(Daten!$V$16=2,MID(Daten!$E$38,1,1)=\"1\",MID(Kontierung_Nr,1,1)=\"1\"),\"Gem. 14c.2 Abs.2a UStAE handelt es sich hier um innerbetriebliche Vorgänge (sog. Innenumsätze), bei denen die Steuer nicht geschuldet wird.\",CHOOSE(Formular!$AJ$38,IF($AJ$10=4,CHOOSE(Sprache,\"Im Fall einer nicht-steuerbaren Leistung ist der Leistungsempfänger für die Besteuerung verantwortlich.\",\"In case of non-fiscal performance recipient is responsible for taxation.\"),\"\"),\"\",\"\",\"\",CHOOSE(Sprache,\"Widerspruch bei der Universität Tübingen, Geschwister-Scholl-Platz, 72074 Tübingen erhoben werden.\",\"\")))","v":""},{"$nulls":34},"",""]
[]
["Kreissparkasse Tübingen:",{"$nulls":6},"IBAN: DE13 6415 0020 0000 0130 04",{"$nulls":9},"BIC: SOLADES1TUB",{"$nulls":18},"Kreissparkasse Tübingen:",{"$nulls":6},"IBAN: DE13 6415 0020 0000 0130 04",{"$nulls":9},"BIC: SOLADES1TUB"]
["BW-Bank Tübingen:",{"$nulls":6},"IBAN: DE24 6005 0101 7477 5036 14",{"$nulls":9},"BIC: SOLADEST600",{"$nulls":18},"BW-Bank Tübingen:",{"$nulls":6},"IBAN: DE24 6005 0101 7477 5036 14",{"$nulls":9},"BIC: SOLADEST600"]
["USt-ID-Nr.: DE 812 383 453",{"$nulls":35},"USt-ID-Nr.: DE 812 383 453"]

{"sheet":"Steuerkennzeichen","index":4,"n_rows":25,"n_cols":13,"rows_kept":25,"hidden":true}
[null,"steuerbar / \nnicht steuerbar",null,"Lieferung / \nLeistung",null,"Inland / \nEU-Ausland / \nDrittland",null,"Privatperson / \nUnternehmen",null,null,{"$f":"VLOOKUP(\"X\",$J$2:$L$25,2,FALSE)","v":"AN"},{"$f":"VLOOKUP(\"X\",$J$2:$L$25,3,FALSE)","v":1}]
[1,"nicht steuerbar",{"$f":"IF(CHOOSE(Kontierung_Art,IF(OR(MID(Kontierung_Nr,1,1)=\"1\",MID(Kontierung_Nr,1,2)=\"26\"),\"steuerbar\",\"nicht steuerbar\"),\"nicht steuerbar\",\"nicht steuerbar\")=B2,\"X\",\"-\")","v":"X"},"Lieferung",{"$f":"IF(CHOOSE(LoL,\"Lieferung\",\"Leistung\")=D2,\"X\",\"-\")","v":"-"},"DE",{"$f":"IF(Ort=F2,\"X\",\"-\")","v":"X"},"Privatperson",{"$f":"IF(CHOOSE(Rechtsform,\"Privatperson\",\"Unternehmen\")=H2,\"X\",\"-\")","v":"-"},{"$f":"IF(COUNTIF(B2:I2,\"X\")=4,\"X\",\"-\")","v":"-"},"AN",1]
[2,"nicht steuerbar","X","Lieferung","-","EU","-","Privatperson","-",{"$f":"IF(COUNTIF(B3:I3,\"X\")=4,\"X\",\"-\")","v":"-"},"AN",1]
[3,"nicht steuerbar","X","Lieferung","-","DL","-","Privatperson","-","-","AN",1]
[4,"nicht steuerbar","X","Lieferung","-","DE","X","Unternehmen","X","-","AN",1]
[5,"nicht steuerbar","X","Lieferung","-","EU","-","Unternehmen","X","-","AN",1]
[6,"nicht steuerbar","X","Lieferung","-","DL","-","Unternehmen","X","-","AN",1]
[7,"nicht steuerbar","X","Leistung","X","DE","X","Privatperson","-","-","AN",1]
[8,"nicht steuerbar","X","Leistung","X","EU","-","Privatperson","-","-","AN",1]
[9,"nicht steuerbar","X","Leistung","X","DL","-","Privatperson","-","-","AN",1]
[10,"nicht steuerbar","X","Leistung","X","DE","X","Unternehmen","X","X","AN",1]
[11,"nicht steuerbar","X","Leistung","X","EU","-","Unternehmen","X","-","AN",1]
[12,"nicht steuerbar","X","Leistung","X","DL","-","Unternehmen","X","-","AN",1]
[13,"steuerbar","-","Lieferung","-","DE","X","Privatperson","-","-","A_",6]
[14,"steuerbar","-","Lieferung","-","EU","-","Privatperson","-","-","A_",6]
[15,"steuerbar","-","Lieferung","-","DL","-","Privatperson","-","-","A6",3,"!"]
[16,"steuerbar","-","Lieferung","-","DE","X","Unternehmen","X","-","A_",6]
[17,"steuerbar","-","Lieferung","-","EU","-","Unternehmen","X","-","A5",2]
[18,"steuerbar","-","Lieferung","-","DL","-","Unternehmen","X","-","A6",3]
[19,"steuerbar","-","Leistung","X","DE","X","Privatperson","-","-","A_",6]
[20,"steuerbar","-","Leistung","X","EU","-","Privatperson","-","-","A_",6]
[21,"steuerbar","-","Leistung","X","DL","-","Privatperson","-","-","A_",6,"!"]
[22,"steuerbar","-","Leistung","X","DE","X","Unternehmen","X","-","A_",6]
[23,"steuerbar","-","Leistung","X","EU","-","Unternehmen","X","-","A7",4]
[24,"steuerbar","-","Leistung","X","DL","-","Unternehmen","X","-","A8",5]

{"sheet":"Seite 2","index":5,"n_rows":5,"n_cols":38,"rows_kept":5,"hidden":true,"merged":[[0,0,0,34],[0,55,0,70],[2,1,2,33],[2,37,2,69],[4,1,4,33],[4,37,4,69]]}
["!!! Mehrfertigung für Abteilung Rechnungswesen !!!"]
[]
[null,{"$f":"\"Anlage \"&CHOOSE(Formular!$AJ$38,\"zur Rechnung \",\"zur Rechnung \",\"zur Pro Forma Rechnung \",\"zum Mittelabruf \",\"zum Bescheid \")&IF(Formular!$AJ$38=2,\"\",MID(YEAR(Formular!$G$36),3,2)&IF(LEN(Formular!$W$38)=7,\"000\",\"\")&Formular!$W$38&CHOOSE(LEN(Formular!$AF$38),\"000\",\"00\",\"0\",\"\")&Formular!$AF$38)","v":"Anlage zur Rechnung 2400035005100000"},{"$nulls":35},{"$f":"IF($B3=\"\",\"\",$B3)","v":"Anlage zur Rechnung 2400035005100000"}]
[]
[null,{"$f":"Daten!$E$118","v":0},{"$nulls":35},0]

{"sheet":"xRechnung","index":6,"n_rows":335,"n_cols":1,"rows_kept":335,"hidden":true}
["<?xml version=\"1.0\" encoding=\"UTF-8\"?>"]
["<Invoice xmlns=\"urn:oasis:names:specification:ubl:schema:xsd:Invoice-2\""]
["         xmlns:xades=\"http://uri.etsi.org/01903/v1.3.2#\""]
["         xmlns:ds=\"http://www.w3.org/2000/09/xmldsig#\""]
["         xmlns:cac=\"urn:oasis:names:specification:ubl:schema:xsd:CommonAggregateComponents-2\""]
["         xmlns:cbc=\"urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2\""]
["         xmlns:ext=\"urn:oasis:names:specification:ubl:schema:xsd:CommonExtensionComponents-2\""]
["         xmlns:n0=\"urn:oasis:names:specification:ubl:schema:xsd:CommonSignatureComponents-2\""]
["         xmlns:qdt=\"urn:oasis:names:specification:ubl:schema:xsd:QualifiedDataTypes-2\""]
["         xmlns:sac=\"urn:oasis:names:specification:ubl:schema:xsd:SignatureAggregateComponents-2\""]
["         xmlns:sbc=\"urn:oasis:names:specification:ubl:schema:xsd:SignatureBasicComponents-2\""]
["         xmlns:udt=\"urn:oasis:names:specification:ubl:schema:xsd:UnqualifiedDataTypes-2\""]
["         xmlns:cct=\"urn:un:unece:uncefact:data:specification:CoreComponentTypeSchemaModule:2\">"]
["   <cbc:CustomizationID>urn:cen.eu:en16931:2017#compliant#urn:xoev-de:kosit:standard:xrechnung_2.2</cbc:CustomizationID>"]
["   <cbc:ProfileID>XRechnung 2.2.0</cbc:ProfileID>"]
[{"$f":"\"   <cbc:ID>\"&MID(YEAR(Formular!$G$36),3,2)&IF(LEN(Formular!$W$38)=7,\"000\",\"\")&Formular!$W$38&CHOOSE(LEN(Formular!$AF$38),\"000\",\"00\",\"0\",\"\")&Formular!$AF$38&\"</cbc:ID>\"","v":"   <cbc:ID>2400035005100000</cbc:ID>"}]
[{"$f":"\"   <cbc:IssueDate>\"&YEAR(Formular!$G$36)&\"-\"&IF(MONTH(Formular!$G$36)<10,\"0\",\"\")&MONTH(Formular!$G$36)&\"-\"&IF(DAY(Formular!$G$36)<10,\"0\",\"\")&DAY(Formular!$G$36)&\"</cbc:IssueDate>\"","v":"   <cbc:IssueDate>2024-08-27</cbc:IssueDate>"}]
[{"$f":"\"   <cbc:DueDate>\"&YEAR(Formular!$L$72)&\"-\"&IF(MONTH(Formular!$L$72)<10,\"0\",\"\")&MONTH(Formular!$L$72)&\"-\"&IF(DAY(Formular!$L$72)<10,\"0\",\"\")&DAY(Formular!$L$72)&\"</cbc:DueDate>\"","v":"   <cbc:DueDate>2024-09-26</cbc:DueDate>"}]
[{"$f":"\"   <cbc:InvoiceTypeCode>380</cbc:InvoiceTypeCode>\"","v":"   <cbc:InvoiceTypeCode>380</cbc:InvoiceTypeCode>"}]
[{"$f":"\"   <cbc:Note>\"&IF(Daten!$E$118=\"\",\"\",\"#AAI#\"&Daten!$E$118)&\"</cbc:Note>\"","v":"   <cbc:Note></cbc:Note>"}]
[{"$f":"\"   <cbc:TaxPointDate>\"&YEAR(IF(Daten!$H$87=\"\",Daten!$E$87,Daten!$H$87))&\"-\"&IF(MONTH(IF(Daten!$H$87=\"\",Daten!$E$87,Daten!$H$87))<10,\"0\",\"\")&MONTH(IF(Daten!$H$87=\"\",Daten!$E$87,Daten!$H$87))&\"-\"&IF(DAY(IF(Daten!$H$87=\"\",Daten!$E$87,Daten!$H$87))<10,\"0\",\"\")&DAY(IF(Daten!$H$87=\"\",Daten!$E$87,Daten!$H$87))&\"</cbc:TaxPointDate>\"","v":"   <cbc:TaxPointDate>1900-01-00</cbc:TaxPointDate>"}]
[{"$f":"\"   <cbc:DocumentCurrencyCode>EUR</cbc:DocumentCurrencyCode>\"","v":"   <cbc:DocumentCurrencyCode>EUR</cbc:DocumentCurrencyCode>"}]
[{"$f":"\"   <cbc:TaxCurrencyCode>EUR</cbc:TaxCurrencyCode>\"","v":"   <cbc:TaxCurrencyCode>EUR</cbc:TaxCurrencyCode>"}]
[{"$f":"\"   <cbc:AccountingCost>\"&\"\"&\"</cbc:AccountingCost>\"","v":"   <cbc:AccountingCost></cbc:AccountingCost>"}]
[{"$f":"\"   <cbc:BuyerReference>\"&Daten!$R$29&\"</cbc:BuyerReference>\"","v":"   <cbc:BuyerReference></cbc:BuyerReference>"}]
["   <cac:InvoicePeriod>"]
[{"$f":"\"      <cbc:StartDate>\"&YEAR(Daten!$E$87)&\"-\"&IF(MONTH(Daten!$E$87)<10,\"0\",\"\")&MONTH(Daten!$E$87)&\"-\"&IF(DAY(Daten!$E$87)<10,\"0\",\"\")&DAY(Daten!$E$87)&\"</cbc:StartDate>\"","v":"      <cbc:StartDate>1900-01-00</cbc:StartDate>"}]
[{"$f":"\"      <cbc:EndDate>\"&IF(Daten!$H$87=\"\",YEAR(Daten!$E$87)&\"-\"&IF(MONTH(Daten!$E$87)<10,\"0\",\"\")&MONTH(Daten!$E$87)&\"-\"&IF(DAY(Daten!$E$87)<10,\"0\",\"\")&DAY(Daten!$E$87),YEAR(Daten!$H$87)&\"-\"&IF(MONTH(Daten!$H$87)<10,\"0\",\"\")&MONTH(Daten!$H$87)&\"-\"&IF(DAY(Daten!$H$87)<10,\"0\",\"\")&DAY(Daten!$H$87))&\"</cbc:EndDate>\"","v":"      <cbc:EndDate>1900-01-00</cbc:EndDate>"}]
["   </cac:InvoicePeriod>"]
[]
["   <cac:OrderReference>"]
[{"$f":"\"      <cbc:ID>\"&Daten!$R$31&\"</cbc:ID>\"","v":"      <cbc:ID></cbc:ID>"}]
["   </cac:OrderReference>"]
["   <cac:ContractDocumentReference>"]
[{"$f":"\"      <cbc:ID>\"&Daten!$R$38&\"</cbc:ID>\"","v":"      <cbc:ID></cbc:ID>"}]
["   </cac:ContractDocumentReference>"]
["   <cac:ProjectReference>"]
[{"$f":"\"      <cbc:ID>\"&Daten!$R$36&\"</cbc:ID>\"","v":"      <cbc:ID></cbc:ID>"}]
["   </cac:ProjectReference>"]
[]
["   <cac:AccountingSupplierParty>"]
["      <cac:Party>"]
[{"$f":"\"         <cbc:EndpointID schemeID=\"\"0088\"\">\"&Daten!$F$14&\"</cbc:EndpointID>\"","v":"         <cbc:EndpointID schemeID=\"0088\">debitoren@zv.uni-tuebingen.de</cbc:EndpointID>"}]
["         <cac:PostalAddress>"]
[{"$f":"\"            <cbc:StreetName>\"&Daten!$E$71&\" \"&Daten!$L$71&\"</cbc:StreetName>\"","v":"            <cbc:StreetName> </cbc:StreetName>"}]
[{"$f":"\"            <cbc:AdditionalStreetName>\"&\"\"&\"</cbc:AdditionalStreetName>\"","v":"            <cbc:AdditionalStreetName></cbc:AdditionalStreetName>"}]
[{"$f":"\"            <cbc:CityName>\"&Daten!$H$73&\"</cbc:CityName>\"","v":"            <cbc:CityName></cbc:CityName>"}]
[{"$f":"\"            <cbc:PostalZone>\"&Daten!$E$73&\"</cbc:PostalZone>\"","v":"            <cbc:PostalZone></cbc:PostalZone>"}]
["            <cac:Country>"]
[{"$f":"\"               <cbc:IdentificationCode>\"&\"DE\"&\"</cbc:IdentificationCode>\"","v":"               <cbc:IdentificationCode>DE</cbc:IdentificationCode>"}]
["            </cac:Country>"]
["         </cac:PostalAddress>"]
["         <cac:PartyTaxScheme>"]
[{"$f":"\"            <cbc:CompanyID>\"&\"DE812383453\"&\"</cbc:CompanyID>\"","v":"            <cbc:CompanyID>DE812383453</cbc:CompanyID>"}]
["            <cac:TaxScheme>"]
[{"$f":"\"               <cbc:ID>VAT</cbc:ID>\"","v":"               <cbc:ID>VAT</cbc:ID>"}]
["            </cac:TaxScheme>"]
["         </cac:PartyTaxScheme>"]
["         <cac:PartyLegalEntity>"]
[{"$f":"\"            <cbc:RegistrationName>\"&Daten!$E$56&IF(Daten!$E$57=\"\",\"\",\" \"&Daten!$E$57)&IF(Daten!$E$59=\"\",\"\",\", \"&Daten!$E$59)&\"</cbc:RegistrationName>\"","v":"            <cbc:RegistrationName></cbc:RegistrationName>"}]
[{"$f":"\"            <cbc:CompanyID>\"&\"-\"&\"</cbc:CompanyID>\"","v":"            <cbc:CompanyID>-</cbc:CompanyID>"}]
[{"$f":"\"            <cbc:CompanyLegalForm>\"&\"\"&\"</cbc:CompanyLegalForm>\"","v":"            <cbc:CompanyLegalForm></cbc:CompanyLegalForm>"}]
["         </cac:PartyLegalEntity>"]
["         <cac:Contact>"]
[{"$f":"\"            <cbc:Name>\"&Daten!$E$77&\"</cbc:Name>\"","v":"            <cbc:Name></cbc:Name>"}]
[{"$f":"\"            <cbc:Telephone>\"&\"0049 7071 \"&IF(Daten!$H$79=\"\",\"\",Daten!$H$79&\" \")&Daten!$J$79&\"</cbc:Telephone>\"","v":"            <cbc:Telephone>0049 7071 29 </cbc:Telephone>"}]
[{"$f":"\"            <cbc:ElectronicMail>\"&Daten!$E$83&\"</cbc:ElectronicMail>\"","v":"            <cbc:ElectronicMail></cbc:ElectronicMail>"}]
["         </cac:Contact>"]
["      </cac:Party>"]
["   </cac:AccountingSupplierParty>"]
[]
["   <cac:AccountingCustomerParty>"]
["      <cac:Party>"]
[{"$f":"\"         <cbc:EndpointID schemeID=\"\"0088\"\">\"&Daten!$E$31&\"</cbc:EndpointID>\"","v":"         <cbc:EndpointID schemeID=\"0088\"></cbc:EndpointID>"}]
["         <cac:PostalAddress>"]
[{"$f":"\"            <cbc:StreetName>\"&Daten!$E$25&IF(Daten!$L$25=\"\",\"\",\" \"&Daten!$L$25)&\"</cbc:StreetName>\"","v":"            <cbc:StreetName></cbc:StreetName>"}]
[{"$f":"\"            <cbc:AdditionalStreetName>\"&\"\"&\"</cbc:AdditionalStreetName>\"","v":"            <cbc:AdditionalStreetName></cbc:AdditionalStreetName>"}]
[{"$f":"\"            <cbc:CityName>\"&Daten!$H$27&\"</cbc:CityName>\"","v":"            <cbc:CityName></cbc:CityName>"}]
[{"$f":"\"            <cbc:PostalZone>\"&Daten!$E$27&\"</cbc:PostalZone>\"","v":"            <cbc:PostalZone></cbc:PostalZone>"}]
["            <cac:Country>"]
[{"$f":"\"               <cbc:IdentificationCode>\"&Daten!$N$29&\"</cbc:IdentificationCode>\"","v":"               <cbc:IdentificationCode>DE</cbc:IdentificationCode>"}]
["            </cac:Country>"]
["         </cac:PostalAddress>"]
["         <cac:PartyLegalEntity>"]
[{"$f":"\"            <cbc:RegistrationName>\"&Daten!$E$18&IF(Daten!$E$19=\"\",\"\",\", \"&Daten!$E$19)&IF(Daten!$E$20=\"\",\"\",\", \"&Daten!$E$20)&IF(Daten!$E$21=\"\",\"\",\", \"&Daten!$E$21)&\"</cbc:RegistrationName>\"","v":"            <cbc:RegistrationName></cbc:RegistrationName>"}]
[{"$f":"\"            <cbc:CompanyID>\"&\"\"&\"</cbc:CompanyID>\"","v":"            <cbc:CompanyID></cbc:CompanyID>"}]
["         </cac:PartyLegalEntity>"]
["         <cac:Contact>"]
[{"$f":"\"            <cbc:Name>\"&\"\"&\"</cbc:Name>\"","v":"            <cbc:Name></cbc:Name>"}]
[{"$f":"\"            <cbc:Telephone>\"&\"\"&\"</cbc:Telephone>\"","v":"            <cbc:Telephone></cbc:Telephone>"}]
[{"$f":"\"            <cbc:ElectronicMail>\"&\"\"&\"</cbc:ElectronicMail>\"","v":"            <cbc:ElectronicMail></cbc:ElectronicMail>"}]
["         </cac:Contact>"]
["      </cac:Party>"]
["   </cac:AccountingCustomerParty>"]
[]
[{"$f":"\"   <cac:Delivery>\"","v":"   <cac:Delivery>"}]
[{"$f":"\"      <cbc:ActualDeliveryDate>\"&YEAR(IF(Daten!$H$87=\"\",Daten!$E$87,Daten!$H$87))&\"-\"&IF(MONTH(IF(Daten!$H$87=\"\",Daten!$E$87,Daten!$H$87))<10,\"0\",\"\")&MONTH(IF(Daten!$H$87=\"\",Daten!$E$87,Daten!$H$87))&\"-\"&IF(DAY(IF(Daten!$H$87=\"\",Daten!$E$87,Daten!$H$87))<10,\"0\",\"\")&DAY(IF(Daten!$H$87=\"\",Daten!$E$87,Daten!$H$87))&\"</cbc:ActualDeliveryDate>\"","v":"      <cbc:ActualDeliveryDate>1900-01-00</cbc:ActualDeliveryDate>"}]
["      <cac:DeliveryLocation>"]
["         <cac:Address>"]
[{"$f":"\"            <cbc:StreetName>\"&Daten!$E$50&IF(Daten!$L$50=\"\",\"\",\" \"&Daten!$L$50)&\"</cbc:StreetName>\"","v":"            <cbc:StreetName></cbc:StreetName>"}]
[{"$f":"\"            <cbc:AdditionalStreetName>\"&\"\"&\"</cbc:AdditionalStreetName>\"","v":"            <cbc:AdditionalStreetName></cbc:AdditionalStreetName>"}]
[{"$f":"\"            <cbc:CityName>\"&Daten!$H$52&\"</cbc:CityName>\"","v":"            <cbc:CityName></cbc:CityName>"}]
[{"$f":"\"            <cbc:PostalZone>\"&Daten!$E$52&\"</cbc:PostalZone>\"","v":"            <cbc:PostalZone></cbc:PostalZone>"}]
["            <cac:Country>"]
[{"$f":"\"               <cbc:IdentificationCode>\"&Daten!$N$41&\"</cbc:IdentificationCode>\"","v":"               <cbc:IdentificationCode>DE</cbc:IdentificationCode>"}]
["            </cac:Country>"]
["         </cac:Address>"]
["      </cac:DeliveryLocation>"]
["      <cac:DeliveryParty>"]
["         <cac:PartyName>"]
[{"$f":"\"            <cbc:Name>\"&Daten!$E$45&IF(Daten!$E$46=\"\",\"\",\", \"&Daten!$E$46)&IF(Daten!$E$47=\"\",\"\",\", \"&Daten!$E$47)&IF(Daten!$E$48=\"\",\"\",\", \"&Daten!$E$48)&\"</cbc:Name>\"","v":"            <cbc:Name></cbc:Name>"}]
["         </cac:PartyName>"]
["      </cac:DeliveryParty>"]
[{"$f":"\"   </cac:Delivery>\"","v":"   </cac:Delivery>"}]
[]
["   <cac:PaymentMeans>"]
[{"$f":"\"      <cbc:PaymentMeansCode name=\"\"Informationen über das Bankkonto, auf das die Überweisung zu leisten ist\"\">\"&\"58\"&\"</cbc:PaymentMeansCode>\"","v":"      <cbc:PaymentMeansCode name=\"Informationen über das Bankkonto, auf das die Überweisung zu leisten ist\">58</cbc:PaymentMeansCode>"}]
[{"$f":"\"      <cbc:PaymentID>\"&MID(YEAR(Formular!$G$36),3,2)&IF(LEN(Formular!$W$38)=7,\"000\",\"\")&Formular!$W$38&CHOOSE(LEN(Formular!$AF$38),\"000\",\"00\",\"0\",\"\")&Formular!$AF$38&\"</cbc:PaymentID>\"","v":"      <cbc:PaymentID>2400035005100000</cbc:PaymentID>"}]
["      <cac:PayeeFinancialAccount>"]
[{"$f":"\"         <cbc:ID>\"&\"DE24600501017477503614\"&\"</cbc:ID>\"","v":"         <cbc:ID>DE24600501017477503614</cbc:ID>"}]
[{"$f":"\"         <cbc:Name>\"&\"Universität Tübingen\"&\"</cbc:Name>\"","v":"         <cbc:Name>Universität Tübingen</cbc:Name>"}]
["         <cac:FinancialInstitutionBranch>"]
[{"$f":"\"            <cbc:ID>\"&\"SOLADEST600\"&\"</cbc:ID>\"","v":"            <cbc:ID>SOLADEST600</cbc:ID>"}]
["         </cac:FinancialInstitutionBranch>"]
["      </cac:PayeeFinancialAccount>"]
["   </cac:PaymentMeans>"]
[]
["   <cac:PaymentTerms>"]
[{"$f":"\"      <cbc:Note>\"&\"30 Tage netto\"&\"</cbc:Note>\"","v":"      <cbc:Note>30 Tage netto</cbc:Note>"}]
["   </cac:PaymentTerms>"]
[]
["   <cac:TaxTotal>"]
[{"$f":"\"      <cbc:TaxAmount currencyID=\"\"EUR\"\">\"&IF(ISERR(SEARCH(\",\",IF(Formular!$AA$50=\"\",0,Formular!$AA$50)+IF(Formular!$AA$53=\"\",0,Formular!$AA$53)+IF(Formular!$AA$56=\"\",0,Formular!$AA$56)+IF(Formular!$AA$59=\"\",0,Formular!$AA$59)+IF(Formular!$AA$62=\"\",0,Formular!$AA$62)+IF(Formular!$AA$65=\"\",0,Formular!$AA$65)+IF(Formular!$AA$68=\"\",0,Formular!$AA$68),1)),IF(Formular!$AA$50=\"\",0,Formular!$AA$50)+IF(Formular!$AA$53=\"\",0,Formular!$AA$53)+IF(Formular!$AA$56=\"\",0,Formular!$AA$56)+IF(Formular!$AA$59=\"\",0,Formular!$AA$59)+IF(Formular!$AA$62=\"\",0,Formular!$AA$62)+IF(Formular!$AA$65=\"\",0,Formular!$AA$65)+IF(Formular!$AA$68=\"\",0,Formular!$AA$68),MID(IF(Formular!$AA$50=\"\",0,Formular!$AA$50)+IF(Formular!$AA$53=\"\",0,Formular!$AA$53)+IF(Formular!$AA$56=\"\",0,Formular!$AA$56)+IF(Formular!$AA$59=\"\",0,Formular!$AA$59)+IF(Formular!$AA$62=\"\",0,Formular!$AA$62)+IF(Formular!$AA$65=\"\",0,Formular!$AA$65)+IF(Formular!$AA$68=\"\",0,Formular!$AA$68),1,SEARCH(\",\",IF(Formular!$AA$50=\"\",0,Formular!$AA$50)+IF(Formular!$AA$53=\"\",0,Formular!$AA$53)+IF(Formular!$AA$56=\"\",0,Formular!$AA$56)+IF(Formular!$AA$59=\"\",0,Formular!$AA$59)+IF(Formular!$AA$62=\"\",0,Formular!$AA$62)+IF(Formular!$AA$65=\"\",0,Formular!$AA$65)+IF(Formular!$AA$68=\"\",0,Formular!$AA$68),1)-1)&\".\"&MID(IF(Formular!$AA$50=\"\",0,Formular!$AA$50)+IF(Formular!$AA$53=\"\",0,Formular!$AA$53)+IF(Formular!$AA$56=\"\",0,Formular!$AA$56)+IF(Formular!$AA$59=\"\",0,Formular!$AA$59)+IF(Formular!$AA$62=\"\",0,Formular!$AA$62)+IF(Formular!$AA$65=\"\",0,Formular!$AA$65)+IF(Formular!$AA$68=\"\",0,Formular!$AA$68),SEARCH(\",\",IF(Formular!$AA$50=\"\",0,Formular!$AA$50)+IF(Formular!$AA$53=\"\",0,Formular!$AA$53)+IF(Formular!$AA$56=\"\",0,Formular!$AA$56)+IF(Formular!$AA$59=\"\",0,Formular!$AA$59)+IF(Formular!$AA$62=\"\",0,Formular!$AA$62)+IF(Formular!$AA$65=\"\",0,Formular!$AA$65)+IF(Formular!$AA$68=\"\",0,Formular!$AA$68),1)+1,2))&\"</cbc:TaxAmount>\"","v":"      <cbc:TaxAmount currencyID=\"EUR\">0</cbc:TaxAmount>"}]
[]
["      <cac:TaxSubtotal>"]
[{"$f":"\"         <cbc:TaxableAmount currencyID=\"\"EUR\"\">\"&IF(ISERR(SEARCH(\",\",IF(OR(Formular!$W$50=\"\",Formular!$AJ$50<>6),0,Formular!$W$50)+IF(OR(Formular!$W$53=\"\",Formular!$AJ$53<>6),0,Formular!$W$53)+IF(OR(Formular!$W$56=\"\",Formular!$AJ$56<>6),0,Formular!$W$56)+IF(OR(Formular!$W$59=\"\",Formular!$AJ$59<>6),0,Formular!$W$59)+IF(OR(Formular!$W$62=\"\",Formular!$AJ$62<>6),0,Formular!$W$62)+IF(OR(Formular!$W$65=\"\",Formular!$AJ$65<>6),0,Formular!$W$65)+IF(OR(Formular!$W$68=\"\",Formular!$AJ$68<>6),0,Formular!$W$68),1)),IF(OR(Formular!$W$50=\"\",Formular!$AJ$50<>6),0,Formular!$W$50)+IF(OR(Formular!$W$53=\"\",Formular!$AJ$53<>6),0,Formular!$W$53)+IF(OR(Formular!$W$56=\"\",Formular!$AJ$56<>6),0,Formular!$W$56)+IF(OR(Formular!$W$59=\"\",Formular!$AJ$59<>6),0,Formular!$W$59)+IF(OR(Formular!$W$62=\"\",Formular!$AJ$62<>6),0,Formular!$W$62)+IF(OR(Formular!$W$65=\"\",Formular!$AJ$65<>6),0,Formular!$W$65)+IF(OR(Formular!$W$68=\"\",Formular!$AJ$68<>6),0,Formular!$W$68),MID(IF(OR(Formular!$W$50=\"\",Formular!$AJ$50<>6),0,Formular!$W$50)+IF(OR(Formular!$W$53=\"\",Formular!$AJ$53<>6),0,Formular!$W$53)+IF(OR(Formular!$W$56=\"\",Formular!$AJ$56<>6),0,Formular!$W$56)+IF(OR(Formular!$W$59=\"\",Formular!$AJ$59<>6),0,Formular!$W$59)+IF(OR(Formular!$W$62=\"\",Formular!$AJ$62<>6),0,Formular!$W$62)+IF(OR(Formular!$W$65=\"\",Formular!$AJ$65<>6),0,Formular!$W$65)+IF(OR(Formular!$W$68=\"\",Formular!$AJ$68<>6),0,Formular!$W$68),1,SEARCH(\",\",IF(OR(Formular!$W$50=\"\",Formular!$AJ$50<>6),0,Formular!$W$50)+IF(OR(Formular!$W$53=\"\",Formular!$AJ$53<>6),0,Formular!$W$53)+IF(OR(Formular!$W$56=\"\",Formular!$AJ$56<>6),0,Formular!$W$56)+IF(OR(Formular!$W$59=\"\",Formular!$AJ$59<>6),0,Formular!$W$59)+IF(OR(Formular!$W$62=\"\",Formular!$AJ$62<>6),0,Formular!$W$62)+IF(OR(Formular!$W$65=\"\",Formular!$AJ$65<>6),0,Formular!$W$65)+IF(OR(Formular!$W$68=\"\",Formular!$AJ$68<>6),0,Formular!$W$68),1)-1)&\".\"&MID(IF(OR(Formular!$W$50=\"\",Formular!$AJ$50<>6),0,Formular!$W$50)+IF(OR(Formular!$W$53=\"\",Formular!$AJ$53<>6),0,Formular!$W$53)+IF(OR(Formular!$W$56=\"\",Formular!$AJ$56<>6),0,Formular!$W$56)+IF(OR(Formular!$W$59=\"\",Formular!$AJ$59<>6),0,Formular!$W$59)+IF(OR(Formular!$W$62=\"\",Formular!$AJ$62<>6),0,Formular!$W$62)+IF(OR(Formular!$W$65=\"\",Formular!$AJ$65<>6),0,Formular!$W$65)+IF(OR(Formular!$W$68=\"\",Formular!$AJ$68<>6),0,Formular!$W$68),SEARCH(\",\",IF(OR(Formular!$W$50=\"\",Formular!$AJ$50<>6),0,Formular!$W$50)+IF(OR(Formular!$W$53=\"\",Formular!$AJ$53<>6),0,Formular!$W$53)+IF(OR(Formular!$W$56=\"\",Formular!$AJ$56<>6),0,Formular!$W$56)+IF(OR(Formular!$W$59=\"\",Formular!$AJ$59<>6),0,Formular!$W$59)+IF(OR(Formular!$W$62=\"\",Formular!$AJ$62<>6),0,Formular!$W$62)+IF(OR(Formular!$W$65=\"\",Formular!$AJ$65<>6),0,Formular!$W$65)+IF(OR(Formular!$W$68=\"\",Formular!$AJ$68<>6),0,Formular!$W$68),1)+1,2))&\"</cbc:TaxableAmount>\"","v":"         <cbc:TaxableAmount currencyID=\"EUR\">0</cbc:TaxableAmount>"}]
[{"$f":"\"         <cbc:TaxAmount currencyID=\"\"EUR\"\">\"&IF(ISERR(SEARCH(\",\",IF(OR(Formular!$AA$50=\"\",Formular!$AJ$50<>6),0,Formular!$AA$50)+IF(OR(Formular!$AA$53=\"\",Formular!$AJ$53<>6),0,Formular!$AA$53)+IF(OR(Formular!$AA$56=\"\",Formular!$AJ$56<>6),0,Formular!$AA$56)+IF(OR(Formular!$AA$59=\"\",Formular!$AJ$59<>6),0,Formular!$AA$59)+IF(OR(Formular!$AA$62=\"\",Formular!$AJ$62<>6),0,Formular!$AA$62)+IF(OR(Formular!$AA$65=\"\",Formular!$AJ$65<>6),0,Formular!$AA$65)+IF(OR(Formular!$AA$68=\"\",Formular!$AJ$68<>6),0,Formular!$AA$68),1)),IF(OR(Formular!$AA$50=\"\",Formular!$AJ$50<>6),0,Formular!$AA$50)+IF(OR(Formular!$AA$53=\"\",Formular!$AJ$53<>6),0,Formular!$AA$53)+IF(OR(Formular!$AA$56=\"\",Formular!$AJ$56<>6),0,Formular!$AA$56)+IF(OR(Formular!$AA$59=\"\",Formular!$AJ$59<>6),0,Formular!$AA$59)+IF(OR(Formular!$AA$62=\"\",Formular!$AJ$62<>6),0,Formular!$AA$62)+IF(OR(Formular!$AA$65=\"\",Formular!$AJ$65<>6),0,Formular!$AA$65)+IF(OR(Formular!$AA$68=\"\",Formular!$AJ$68<>6),0,Formular!$AA$68),MID(IF(OR(Formular!$AA$50=\"\",Formular!$AJ$50<>6),0,Formular!$AA$50)+IF(OR(Formular!$AA$53=\"\",Formular!$AJ$53<>6),0,Formular!$AA$53)+IF(OR(Formular!$AA$56=\"\",Formular!$AJ$56<>6),0,Formular!$AA$56)+IF(OR(Formular!$AA$59=\"\",Formular!$AJ$59<>6),0,Formular!$AA$59)+IF(OR(Formular!$AA$62=\"\",Formular!$AJ$62<>6),0,Formular!$AA$62)+IF(OR(Formular!$AA$65=\"\",Formular!$AJ$65<>6),0,Formular!$AA$65)+IF(OR(Formular!$AA$68=\"\",Formular!$AJ$68<>6),0,Formular!$AA$68),1,SEARCH(\",\",IF(OR(Formular!$AA$50=\"\",Formular!$AJ$50<>6),0,Formular!$AA$50)+IF(OR(Formular!$AA$53=\"\",Formular!$AJ$53<>6),0,Formular!$AA$53)+IF(OR(Formular!$AA$56=\"\",Formular!$AJ$56<>6),0,Formular!$AA$56)+IF(OR(Formular!$AA$59=\"\",Formular!$AJ$59<>6),0,Formular!$AA$59)+IF(OR(Formular!$AA$62=\"\",Formular!$AJ$62<>6),0,Formular!$AA$62)+IF(OR(Formular!$AA$65=\"\",Formular!$AJ$65<>6),0,Formular!$AA$65)+IF(OR(Formular!$AA$68=\"\",Formular!$AJ$68<>6),0,Formular!$AA$68),1)-1)&\".\"&MID(IF(OR(Formular!$AA$50=\"\",Formular!$AJ$50<>6),0,Formular!$AA$50)+IF(OR(Formular!$AA$53=\"\",Formular!$AJ$53<>6),0,Formular!$AA$53)+IF(OR(Formular!$AA$56=\"\",Formular!$AJ$56<>6),0,Formular!$AA$56)+IF(OR(Formular!$AA$59=\"\",Formular!$AJ$59<>6),0,Formular!$AA$59)+IF(OR(Formular!$AA$62=\"\",Formular!$AJ$62<>6),0,Formular!$AA$62)+IF(OR(Formular!$AA$65=\"\",Formular!$AJ$65<>6),0,Formular!$AA$65)+IF(OR(Formular!$AA$68=\"\",Formular!$AJ$68<>6),0,Formular!$AA$68),SEARCH(\",\",IF(OR(Formular!$AA$50=\"\",Formular!$AJ$50<>6),0,Formular!$AA$50)+IF(OR(Formular!$AA$53=\"\",Formular!$AJ$53<>6),0,Formular!$AA$53)+IF(OR(Formular!$AA$56=\"\",Formular!$AJ$56<>6),0,Formular!$AA$56)+IF(OR(Formular!$AA$59=\"\",Formular!$AJ$59<>6),0,Formular!$AA$59)+IF(OR(Formular!$AA$62=\"\",Formular!$AJ$62<>6),0,Formular!$AA$62)+IF(OR(Formular!$AA$65=\"\",Formular!$AJ$65<>6),0,Formular!$AA$65)+IF(OR(Formular!$AA$68=\"\",Formular!$AJ$68<>6),0,Formular!$AA$68),1)+1,2))&\"</cbc:TaxAmount>\"","v":"         <cbc:TaxAmount currencyID=\"EUR\">0</cbc:TaxAmount>"}]
["         <cac:TaxCategory>"]
[{"$f":"\"            <cbc:ID>\"&\"S\"&\"</cbc:ID>\"","v":"            <cbc:ID>S</cbc:ID>"}]
[{"$f":"\"            <cbc:Percent>\"&19&\"</cbc:Percent>\"","v":"            <cbc:Percent>19</cbc:Percent>"}]
["            <cac:TaxScheme>"]
[{"$f":"\"               <cbc:ID>\"&\"VAT\"&\"</cbc:ID>\"","v":"               <cbc:ID>VAT</cbc:ID>"}]
["            </cac:TaxScheme>"]
["         </cac:TaxCategory>"]
["      </cac:TaxSubtotal>"]
[]
["      <cac:TaxSubtotal>"]
[{"$f":"\"         <cbc:TaxableAmount currencyID=\"\"EUR\"\">\"&IF(ISERR(SEARCH(\",\",IF(OR(Formular!$W$50=\"\",Formular!$AJ$50<>7),0,Formular!$W$50)+IF(OR(Formular!$W$53=\"\",Formular!$AJ$53<>7),0,Formular!$W$53)+IF(OR(Formular!$W$56=\"\",Formular!$AJ$56<>7),0,Formular!$W$56)+IF(OR(Formular!$W$59=\"\",Formular!$AJ$59<>7),0,Formular!$W$59)+IF(OR(Formular!$W$62=\"\",Formular!$AJ$62<>7),0,Formular!$W$62)+IF(OR(Formular!$W$65=\"\",Formular!$AJ$65<>7),0,Formular!$W$65)+IF(OR(Formular!$W$68=\"\",Formular!$AJ$68<>7),0,Formular!$W$68),1)),IF(OR(Formular!$W$50=\"\",Formular!$AJ$50<>7),0,Formular!$W$50)+IF(OR(Formular!$W$53=\"\",Formular!$AJ$53<>7),0,Formular!$W$53)+IF(OR(Formular!$W$56=\"\",Formular!$AJ$56<>7),0,Formular!$W$56)+IF(OR(Formular!$W$59=\"\",Formular!$AJ$59<>7),0,Formular!$W$59)+IF(OR(Formular!$W$62=\"\",Formular!$AJ$62<>7),0,Formular!$W$62)+IF(OR(Formular!$W$65=\"\",Formular!$AJ$65<>7),0,Formular!$W$65)+IF(OR(Formular!$W$68=\"\",Formular!$AJ$68<>7),0,Formular!$W$68),MID(IF(OR(Formular!$W$50=\"\",Formular!$AJ$50<>7),0,Formular!$W$50)+IF(OR(Formular!$W$53=\"\",Formular!$AJ$53<>7),0,Formular!$W$53)+IF(OR(Formular!$W$56=\"\",Formular!$AJ$56<>7),0,Formular!$W$56)+IF(OR(Formular!$W$59=\"\",Formular!$AJ$59<>7),0,Formular!$W$59)+IF(OR(Formular!$W$62=\"\",Formular!$AJ$62<>7),0,Formular!$W$62)+IF(OR(Formular!$W$65=\"\",Formular!$AJ$65<>7),0,Formular!$W$65)+IF(OR(Formular!$W$68=\"\",Formular!$AJ$68<>7),0,Formular!$W$68),1,SEARCH(\",\",IF(OR(Formular!$W$50=\"\",Formular!$AJ$50<>7),0,Formular!$W$50)+IF(OR(Formular!$W$53=\"\",Formular!$AJ$53<>7),0,Formular!$W$53)+IF(OR(Formular!$W$56=\"\",Formular!$AJ$56<>7),0,Formular!$W$56)+IF(OR(Formular!$W$59=\"\",Formular!$AJ$59<>7),0,Formular!$W$59)+IF(OR(Formular!$W$62=\"\",Formular!$AJ$62<>7),0,Formular!$W$62)+IF(OR(Formular!$W$65=\"\",Formular!$AJ$65<>7),0,Formular!$W$65)+IF(OR(Formular!$W$68=\"\",Formular!$AJ$68<>7),0,Formular!$W$68),1)-1)&\".\"&MID(IF(OR(Formular!$W$50=\"\",Formular!$AJ$50<>7),0,Formular!$W$50)+IF(OR(Formular!$W$53=\"\",Formular!$AJ$53<>7),0,Formular!$W$53)+IF(OR(Formular!$W$56=\"\",Formular!$AJ$56<>7),0,Formular!$W$56)+IF(OR(Formular!$W$59=\"\",Formular!$AJ$59<>7),0,Formular!$W$59)+IF(OR(Formular!$W$62=\"\",Formular!$AJ$62<>7),0,Formular!$W$62)+IF(OR(Formular!$W$65=\"\",Formular!$AJ$65<>7),0,Formular!$W$65)+IF(OR(Formular!$W$68=\"\",Formular!$AJ$68<>7),0,Formular!$W$68),SEARCH(\",\",IF(OR(Formular!$W$50=\"\",Formular!$AJ$50<>7),0,Formular!$W$50)+IF(OR(Formular!$W$53=\"\",Formular!$AJ$53<>7),0,Formular!$W$53)+IF(OR(Formular!$W$56=\"\",Formular!$AJ$56<>7),0,Formular!$W$56)+IF(OR(Formular!$W$59=\"\",Formular!$AJ$59<>7),0,Formular!$W$59)+IF(OR(Formular!$W$62=\"\",Formular!$AJ$62<>7),0,Formular!$W$62)+IF(OR(Formular!$W$65=\"\",Formular!$AJ$65<>7),0,Formular!$W$65)+IF(OR(Formular!$W$68=\"\",Formular!$AJ$68<>7),0,Formular!$W$68),1)+1,2))&\"</cbc:TaxableAmount>\"","v":"         <cbc:TaxableAmount currencyID=\"EUR\">0</cbc:TaxableAmount>"}]
[{"$f":"\"         <cbc:TaxAmount currencyID=\"\"EUR\"\">\"&IF(ISERR(SEARCH(\",\",IF(OR(Formular!$AA$50=\"\",Formular!$AJ$50<>7),0,Formular!$AA$50)+IF(OR(Formular!$AA$53=\"\",Formular!$AJ$53<>7),0,Formular!$AA$53)+IF(OR(Formular!$AA$56=\"\",Formular!$AJ$56<>7),0,Formular!$AA$56)+IF(OR(Formular!$AA$59=\"\",Formular!$AJ$59<>7),0,Formular!$AA$59)+IF(OR(Formular!$AA$62=\"\",Formular!$AJ$62<>7),0,Formular!$AA$62)+IF(OR(Formular!$AA$65=\"\",Formular!$AJ$65<>7),0,Formular!$AA$65)+IF(OR(Formular!$AA$68=\"\",Formular!$AJ$68<>7),0,Formular!$AA$68),1)),IF(OR(Formular!$AA$50=\"\",Formular!$AJ$50<>7),0,Formular!$AA$50)+IF(OR(Formular!$AA$53=\"\",Formular!$AJ$53<>7),0,Formular!$AA$53)+IF(OR(Formular!$AA$56=\"\",Formular!$AJ$56<>7),0,Formular!$AA$56)+IF(OR(Formular!$AA$59=\"\",Formular!$AJ$59<>7),0,Formular!$AA$59)+IF(OR(Formular!$AA$62=\"\",Formular!$AJ$62<>7),0,Formular!$AA$62)+IF(OR(Formular!$AA$65=\"\",Formular!$AJ$65<>7),0,Formular!$AA$65)+IF(OR(Formular!$AA$68=\"\",Formular!$AJ$68<>7),0,Formular!$AA$68),MID(IF(OR(Formular!$AA$50=\"\",Formular!$AJ$50<>7),0,Formular!$AA$50)+IF(OR(Formular!$AA$53=\"\",Formular!$AJ$53<>7),0,Formular!$AA$53)+IF(OR(Formular!$AA$56=\"\",Formular!$AJ$56<>7),0,Formular!$AA$56)+IF(OR(Formular!$AA$59=\"\",Formular!$AJ$59<>7),0,Formular!$AA$59)+IF(OR(Formular!$AA$62=\"\",Formular!$AJ$62<>7),0,Formular!$AA$62)+IF(OR(Formular!$AA$65=\"\",Formular!$AJ$65<>7),0,Formular!$AA$65)+IF(OR(Formular!$AA$68=\"\",Formular!$AJ$68<>7),0,Formular!$AA$68),1,SEARCH(\",\",IF(OR(Formular!$AA$50=\"\",Formular!$AJ$50<>7),0,Formular!$AA$50)+IF(OR(Formular!$AA$53=\"\",Formular!$AJ$53<>7),0,Formular!$AA$53)+IF(OR(Formular!$AA$56=\"\",Formular!$AJ$56<>7),0,Formular!$AA$56)+IF(OR(Formular!$AA$59=\"\",Formular!$AJ$59<>7),0,Formular!$AA$59)+IF(OR(Formular!$AA$62=\"\",Formular!$AJ$62<>7),0,Formular!$AA$62)+IF(OR(Formular!$AA$65=\"\",Formular!$AJ$65<>7),0,Formular!$AA$65)+IF(OR(Formular!$AA$68=\"\",Formular!$AJ$68<>7),0,Formular!$AA$68),1)-1)&\".\"&MID(IF(OR(Formular!$AA$50=\"\",Formular!$AJ$50<>7),0,Formular!$AA$50)+IF(OR(Formular!$AA$53=\"\",Formular!$AJ$53<>7),0,Formular!$AA$53)+IF(OR(Formular!$AA$56=\"\",Formular!$AJ$56<>7),0,Formular!$AA$56)+IF(OR(Formular!$AA$59=\"\",Formular!$AJ$59<>7),0,Formular!$AA$59)+IF(OR(Formular!$AA$62=\"\",Formular!$AJ$62<>7),0,Formular!$AA$62)+IF(OR(Formular!$AA$65=\"\",Formular!$AJ$65<>7),0,Formular!$AA$65)+IF(OR(Formular!$AA$68=\"\",Formular!$AJ$68<>7),0,Formular!$AA$68),SEARCH(\",\",IF(OR(Formular!$AA$50=\"\",Formular!$AJ$50<>7),0,Formular!$AA$50)+IF(OR(Formular!$AA$53=\"\",Formular!$AJ$53<>7),0,Formular!$AA$53)+IF(OR(Formular!$AA$56=\"\",Formular!$AJ$56<>7),0,Formular!$AA$56)+IF(OR(Formular!$AA$59=\"\",Formular!$AJ$59<>7),0,Formular!$AA$59)+IF(OR(Formular!$AA$62=\"\",Formular!$AJ$62<>7),0,Formular!$AA$62)+IF(OR(Formular!$AA$65=\"\",Formular!$AJ$65<>7),0,Formular!$AA$65)+IF(OR(Formular!$AA$68=\"\",Formular!$AJ$68<>7),0,Formular!$AA$68),1)+1,2))&\"</cbc:TaxAmount>\"","v":"         <cbc:TaxAmount currencyID=\"EUR\">0</cbc:TaxAmount>"}]
["         <cac:TaxCategory>"]
[{"$f":"\"            <cbc:ID>\"&\"S\"&\"</cbc:ID>\"","v":"            <cbc:ID>S</cbc:ID>"}]
[{"$f":"\"            <cbc:Percent>\"&7&\"</cbc:Percent>\"","v":"            <cbc:Percent>7</cbc:Percent>"}]
["            <cac:TaxScheme>"]
[{"$f":"\"               <cbc:ID>\"&\"VAT\"&\"</cbc:ID>\"","v":"               <cbc:ID>VAT</cbc:ID>"}]
["            </cac:TaxScheme>"]
["         </cac:TaxCategory>"]
["      </cac:TaxSubtotal>"]
[]
["      <cac:TaxSubtotal>"]
[{"$f":"\"         <cbc:TaxableAmount currencyID=\"\"EUR\"\">\"&IF(ISERR(SEARCH(\",\",IF(OR(Formular!$W$50=\"\",Formular!$AJ$50<>8),0,Formular!$W$50)+IF(OR(Formular!$W$53=\"\",Formular!$AJ$53<>8),0,Formular!$W$53)+IF(OR(Formular!$W$56=\"\",Formular!$AJ$56<>8),0,Formular!$W$56)+IF(OR(Formular!$W$59=\"\",Formular!$AJ$59<>8),0,Formular!$W$59)+IF(OR(Formular!$W$62=\"\",Formular!$AJ$62<>8),0,Formular!$W$62)+IF(OR(Formular!$W$65=\"\",Formular!$AJ$65<>8),0,Formular!$W$65)+IF(OR(Formular!$W$68=\"\",Formular!$AJ$68<>8),0,Formular!$W$68),1)),IF(OR(Formular!$W$50=\"\",Formular!$AJ$50<>8),0,Formular!$W$50)+IF(OR(Formular!$W$53=\"\",Formular!$AJ$53<>8),0,Formular!$W$53)+IF(OR(Formular!$W$56=\"\",Formular!$AJ$56<>8),0,Formular!$W$56)+IF(OR(Formular!$W$59=\"\",Formular!$AJ$59<>8),0,Formular!$W$59)+IF(OR(Formular!$W$62=\"\",Formular!$AJ$62<>8),0,Formular!$W$62)+IF(OR(Formular!$W$65=\"\",Formular!$AJ$65<>8),0,Formular!$W$65)+IF(OR(Formular!$W$68=\"\",Formular!$AJ$68<>8),0,Formular!$W$68),MID(IF(OR(Formular!$W$50=\"\",Formular!$AJ$50<>8),0,Formular!$W$50)+IF(OR(Formular!$W$53=\"\",Formular!$AJ$53<>8),0,Formular!$W$53)+IF(OR(Formular!$W$56=\"\",Formular!$AJ$56<>8),0,Formular!$W$56)+IF(OR(Formular!$W$59=\"\",Formular!$AJ$59<>8),0,Formular!$W$59)+IF(OR(Formular!$W$62=\"\",Formular!$AJ$62<>8),0,Formular!$W$62)+IF(OR(Formular!$W$65=\"\",Formular!$AJ$65<>8),0,Formular!$W$65)+IF(OR(Formular!$W$68=\"\",Formular!$AJ$68<>8),0,Formular!$W$68),1,SEARCH(\",\",IF(OR(Formular!$W$50=\"\",Formular!$AJ$50<>8),0,Formular!$W$50)+IF(OR(Formular!$W$53=\"\",Formular!$AJ$53<>8),0,Formular!$W$53)+IF(OR(Formular!$W$56=\"\",Formular!$AJ$56<>8),0,Formular!$W$56)+IF(OR(Formular!$W$59=\"\",Formular!$AJ$59<>8),0,Formular!$W$59)+IF(OR(Formular!$W$62=\"\",Formular!$AJ$62<>8),0,Formular!$W$62)+IF(OR(Formular!$W$65=\"\",Formular!$AJ$65<>8),0,Formular!$W$65)+IF(OR(Formular!$W$68=\"\",Formular!$AJ$68<>8),0,Formular!$W$68),1)-1)&\".\"&MID(IF(OR(Formular!$W$50=\"\",Formular!$AJ$50<>8),0,Formular!$W$50)+IF(OR(Formular!$W$53=\"\",Formular!$AJ$53<>8),0,Formular!$W$53)+IF(OR(Formular!$W$56=\"\",Formular!$AJ$56<>8),0,Formular!$W$56)+IF(OR(Formular!$W$59=\"\",Formular!$AJ$59<>8),0,Formular!$W$59)+IF(OR(Formular!$W$62=\"\",Formular!$AJ$62<>8),0,Formular!$W$62)+IF(OR(Formular!$W$65=\"\",Formular!$AJ$65<>8),0,Formular!$W$65)+IF(OR(Formular!$W$68=\"\",Formular!$AJ$68<>8),0,Formular!$W$68),SEARCH(\",\",IF(OR(Formular!$W$50=\"\",Formular!$AJ$50<>8),0,Formular!$W$50)+IF(OR(Formular!$W$53=\"\",Formular!$AJ$53<>8),0,Formular!$W$53)+IF(OR(Formular!$W$56=\"\",Formular!$AJ$56<>8),0,Formular!$W$56)+IF(OR(Formular!$W$59=\"\",Formular!$AJ$59<>8),0,Formular!$W$59)+IF(OR(Formular!$W$62=\"\",Formular!$AJ$62<>8),0,Formular!$W$62)+IF(OR(Formular!$W$65=\"\",Formular!$AJ$65<>8),0,Formular!$W$65)+IF(OR(Formular!$W$68=\"\",Formular!$AJ$68<>8),0,Formular!$W$68),1)+1,2))&\"</cbc:TaxableAmount>\"","v":"         <cbc:TaxableAmount currencyID=\"EUR\">0</cbc:TaxableAmount>"}]
[{"$f":"\"         <cbc:TaxAmount currencyID=\"\"EUR\"\">\"&IF(ISERR(SEARCH(\",\",IF(OR(Formular!$AA$50=\"\",Formular!$AJ$50<>8),0,Formular!$AA$50)+IF(OR(Formular!$AA$53=\"\",Formular!$AJ$53<>8),0,Formular!$AA$53)+IF(OR(Formular!$AA$56=\"\",Formular!$AJ$56<>8),0,Formular!$AA$56)+IF(OR(Formular!$AA$59=\"\",Formular!$AJ$59<>8),0,Formular!$AA$59)+IF(OR(Formular!$AA$62=\"\",Formular!$AJ$62<>8),0,Formular!$AA$62)+IF(OR(Formular!$AA$65=\"\",Formular!$AJ$65<>8),0,Formular!$AA$65)+IF(OR(Formular!$AA$68=\"\",Formular!$AJ$68<>8),0,Formular!$AA$68),1)),IF(OR(Formular!$AA$50=\"\",Formular!$AJ$50<>8),0,Formular!$AA$50)+IF(OR(Formular!$AA$53=\"\",Formular!$AJ$53<>8),0,Formular!$AA$53)+IF(OR(Formular!$AA$56=\"\",Formular!$AJ$56<>8),0,Formular!$AA$56)+IF(OR(Formular!$AA$59=\"\",Formular!$AJ$59<>8),0,Formular!$AA$59)+IF(OR(Formular!$AA$62=\"\",Formular!$AJ$62<>8),0,Formular!$AA$62)+IF(OR(Formular!$AA$65=\"\",Formular!$AJ$65<>8),0,Formular!$AA$65)+IF(OR(Formular!$AA$68=\"\",Formular!$AJ$68<>8),0,Formular!$AA$68),MID(IF(OR(Formular!$AA$50=\"\",Formular!$AJ$50<>8),0,Formular!$AA$50)+IF(OR(Formular!$AA$53=\"\",Formular!$AJ$53<>8),0,Formular!$AA$53)+IF(OR(Formular!$AA$56=\"\",Formular!$AJ$56<>8),0,Formular!$AA$56)+IF(OR(Formular!$AA$59=\"\",Formular!$AJ$59<>8),0,Formular!$AA$59)+IF(OR(Formular!$AA$62=\"\",Formular!$AJ$62<>8),0,Formular!$AA$62)+IF(OR(Formular!$AA$65=\"\",Formular!$AJ$65<>8),0,Formular!$AA$65)+IF(OR(Formular!$AA$68=\"\",Formular!$AJ$68<>8),0,Formular!$AA$68),1,SEARCH(\",\",IF(OR(Formular!$AA$50=\"\",Formular!$AJ$50<>8),0,Formular!$AA$50)+IF(OR(Formular!$AA$53=\"\",Formular!$AJ$53<>8),0,Formular!$AA$53)+IF(OR(Formular!$AA$56=\"\",Formular!$AJ$56<>8),0,Formular!$AA$56)+IF(OR(Formular!$AA$59=\"\",Formular!$AJ$59<>8),0,Formular!$AA$59)+IF(OR(Formular!$AA$62=\"\",Formular!$AJ$62<>8),0,Formular!$AA$62)+IF(OR(Formular!$AA$65=\"\",Formular!$AJ$65<>8),0,Formular!$AA$65)+IF(OR(Formular!$AA$68=\"\",Formular!$AJ$68<>8),0,Formular!$AA$68),1)-1)&\".\"&MID(IF(OR(Formular!$AA$50=\"\",Formular!$AJ$50<>8),0,Formular!$AA$50)+IF(OR(Formular!$AA$53=\"\",Formular!$AJ$53<>8),0,Formular!$AA$53)+IF(OR(Formular!$AA$56=\"\",Formular!$AJ$56<>8),0,Formular!$AA$56)+IF(OR(Formular!$AA$59=\"\",Formular!$AJ$59<>8),0,Formular!$AA$59)+IF(OR(Formular!$AA$62=\"\",Formular!$AJ$62<>8),0,Formular!$AA$62)+IF(OR(Formular!$AA$65=\"\",Formular!$AJ$65<>8),0,Formular!$AA$65)+IF(OR(Formular!$AA$68=\"\",Formular!$AJ$68<>8),0,Formular!$AA$68),SEARCH(\",\",IF(OR(Formular!$AA$50=\"\",Formular!$AJ$50<>8),0,Formular!$AA$50)+IF(OR(Formular!$AA$53=\"\",Formular!$AJ$53<>8),0,Formular!$AA$53)+IF(OR(Formular!$AA$56=\"\",Formular!$AJ$56<>8),0,Formular!$AA$56)+IF(OR(Formular!$AA$59=\"\",Formular!$AJ$59<>8),0,Formular!$AA$59)+IF(OR(Formular!$AA$62=\"\",Formular!$AJ$62<>8),0,Formular!$AA$62)+IF(OR(Formular!$AA$65=\"\",Formular!$AJ$65<>8),0,Formular!$AA$65)+IF(OR(Formular!$AA$68=\"\",Formular!$AJ$68<>8),0,Formular!$AA$68),1)+1,2))&\"</cbc:TaxAmount>\"","v":"         <cbc:TaxAmount currencyID=\"EUR\">0</cbc:TaxAmount>"}]
["         <cac:TaxCategory>"]
[{"$f":"\"            <cbc:ID>\"&\"Z\"&\"</cbc:ID>\"","v":"            <cbc:ID>Z</cbc:ID>"}]
[{"$f":"\"            <cbc:Percent>\"&0&\"</cbc:Percent>\"","v":"            <cbc:Percent>0</cbc:Percent>"}]
["            <cac:TaxScheme>"]
[{"$f":"\"               <cbc:ID>\"&\"VAT\"&\"</cbc:ID>\"","v":"               <cbc:ID>VAT</cbc:ID>"}]
["            </cac:TaxScheme>"]
["         </cac:TaxCategory>"]
["      </cac:TaxSubtotal>"]
[]
["   </cac:TaxTotal>"]
[]
["   <cac:LegalMonetaryTotal>"]
[{"$f":"\"      <cbc:LineExtensionAmount currencyID=\"\"EUR\"\">\"&IF(ISERR(SEARCH(\",\",IF(Formular!$AE$50=\"\",0,IF(Formular!$W$50=\"\",Formular!$AE$50,Formular!$W$50))+IF(Formular!$AE$53=\"\",0,IF(Formular!$W$53=\"\",Formular!$AE$53,Formular!$W$53))+IF(Formular!$AE$56=\"\",0,IF(Formular!$W$56=\"\",Formular!$AE$56,Formular!$W$56))+IF(Formular!$AE$59=\"\",0,IF(Formular!$W$59=\"\",Formular!$AE$59,Formular!$W$59))+IF(Formular!$AE$62=\"\",0,IF(Formular!$W$62=\"\",Formular!$AE$62,Formular!$W$62))+IF(Formular!$AE$65=\"\",0,IF(Formular!$W$65=\"\",Formular!$AE$65,Formular!$W$65))+IF(Formular!$AE$68=\"\",0,IF(Formular!$W$68=\"\",Formular!$AE$68,Formular!$W$68)),1)),IF(Formular!$AE$50=\"\",0,IF(Formular!$W$50=\"\",Formular!$AE$50,Formular!$W$50))+IF(Formular!$AE$53=\"\",0,IF(Formular!$W$53=\"\",Formular!$AE$53,Formular!$W$53))+IF(Formular!$AE$56=\"\",0,IF(Formular!$W$56=\"\",Formular!$AE$56,Formular!$W$56))+IF(Formular!$AE$59=\"\",0,IF(Formular!$W$59=\"\",Formular!$AE$59,Formular!$W$59))+IF(Formular!$AE$62=\"\",0,IF(Formular!$W$62=\"\",Formular!$AE$62,Formular!$W$62))+IF(Formular!$AE$65=\"\",0,IF(Formular!$W$65=\"\",Formular!$AE$65,Formular!$W$65))+IF(Formular!$AE$68=\"\",0,IF(Formular!$W$68=\"\",Formular!$AE$68,Formular!$W$68)),MID(IF(Formular!$AE$50=\"\",0,IF(Formular!$W$50=\"\",Formular!$AE$50,Formular!$W$50))+IF(Formular!$AE$53=\"\",0,IF(Formular!$W$53=\"\",Formular!$AE$53,Formular!$W$53))+IF(Formular!$AE$56=\"\",0,IF(Formular!$W$56=\"\",Formular!$AE$56,Formular!$W$56))+IF(Formular!$AE$59=\"\",0,IF(Formular!$W$59=\"\",Formular!$AE$59,Formular!$W$59))+IF(Formular!$AE$62=\"\",0,IF(Formular!$W$62=\"\",Formular!$AE$62,Formular!$W$62))+IF(Formular!$AE$65=\"\",0,IF(Formular!$W$65=\"\",Formular!$AE$65,Formular!$W$65))+IF(Formular!$AE$68=\"\",0,IF(Formular!$W$68=\"\",Formular!$AE$68,Formular!$W$68)),1,SEARCH(\",\",IF(Formular!$AE$50=\"\",0,IF(Formular!$W$50=\"\",Formular!$AE$50,Formular!$W$50))+IF(Formular!$AE$53=\"\",0,IF(Formular!$W$53=\"\",Formular!$AE$53,Formular!$W$53))+IF(Formular!$AE$56=\"\",0,IF(Formular!$W$56=\"\",Formular!$AE$56,Formular!$W$56))+IF(Formular!$AE$59=\"\",0,IF(Formular!$W$59=\"\",Formular!$AE$59,Formular!$W$59))+IF(Formular!$AE$62=\"\",0,IF(Formular!$W$62=\"\",Formular!$AE$62,Formular!$W$62))+IF(Formular!$AE$65=\"\",0,IF(Formular!$W$65=\"\",Formular!$AE$65,Formular!$W$65))+IF(Formular!$AE$68=\"\",0,IF(Formular!$W$68=\"\",Formular!$AE$68,Formular!$W$68)),1)-1)&\".\"&MID(IF(Formular!$AE$50=\"\",0,IF(Formular!$W$50=\"\",Formular!$AE$50,Formular!$W$50))+IF(Formular!$AE$53=\"\",0,IF(Formular!$W$53=\"\",Formular!$AE$53,Formular!$W$53))+IF(Formular!$AE$56=\"\",0,IF(Formular!$W$56=\"\",Formular!$AE$56,Formular!$W$56))+IF(Formular!$AE$59=\"\",0,IF(Formular!$W$59=\"\",Formular!$AE$59,Formular!$W$59))+IF(Formular!$AE$62=\"\",0,IF(Formular!$W$62=\"\",Formular!$AE$62,Formular!$W$62))+IF(Formular!$AE$65=\"\",0,IF(Formular!$W$65=\"\",Formular!$AE$65,Formular!$W$65))+IF(Formular!$AE$68=\"\",0,IF(Formular!$W$68=\"\",Formular!$AE$68,Formular!$W$68)),SEARCH(\",\",IF(Formular!$AE$50=\"\",0,IF(Formular!$W$50=\"\",Formular!$AE$50,Formular!$W$50))+IF(Formular!$AE$53=\"\",0,IF(Formular!$W$53=\"\",Formular!$AE$53,Formular!$W$53))+IF(Formular!$AE$56=\"\",0,IF(Formular!$W$56=\"\",Formular!$AE$56,Formular!$W$56))+IF(Formular!$AE$59=\"\",0,IF(Formular!$W$59=\"\",Formular!$AE$59,Formular!$W$59))+IF(Formular!$AE$62=\"\",0,IF(Formular!$W$62=\"\",Formular!$AE$62,Formular!$W$62))+IF(Formular!$AE$65=\"\",0,IF(Formular!$W$65=\"\",Formular!$AE$65,Formular!$W$65))+IF(Formular!$AE$68=\"\",0,IF(Formular!$W$68=\"\",Formular!$AE$68,Formular!$W$68)),1)+1,2))&\"</cbc:LineExtensionAmount>\"","v":"      <cbc:LineExtensionAmount currencyID=\"EUR\">0</cbc:LineExtensionAmount>"}]
[{"$f":"\"      <cbc:TaxExclusiveAmount currencyID=\"\"EUR\"\">\"&IF(ISERR(SEARCH(\",\",IF(Formular!$AE$50=\"\",0,IF(Formular!$W$50=\"\",Formular!$AE$50,Formular!$W$50))+IF(Formular!$AE$53=\"\",0,IF(Formular!$W$53=\"\",Formular!$AE$53,Formular!$W$53))+IF(Formular!$AE$56=\"\",0,IF(Formular!$W$56=\"\",Formular!$AE$56,Formular!$W$56))+IF(Formular!$AE$59=\"\",0,IF(Formular!$W$59=\"\",Formular!$AE$59,Formular!$W$59))+IF(Formular!$AE$62=\"\",0,IF(Formular!$W$62=\"\",Formular!$AE$62,Formular!$W$62))+IF(Formular!$AE$65=\"\",0,IF(Formular!$W$65=\"\",Formular!$AE$65,Formular!$W$65))+IF(Formular!$AE$68=\"\",0,IF(Formular!$W$68=\"\",Formular!$AE$68,Formular!$W$68)),1)),IF(Formular!$AE$50=\"\",0,IF(Formular!$W$50=\"\",Formular!$AE$50,Formular!$W$50))+IF(Formular!$AE$53=\"\",0,IF(Formular!$W$53=\"\",Formular!$AE$53,Formular!$W$53))+IF(Formular!$AE$56=\"\",0,IF(Formular!$W$56=\"\",Formular!$AE$56,Formular!$W$56))+IF(Formular!$AE$59=\"\",0,IF(Formular!$W$59=\"\",Formular!$AE$59,Formular!$W$59))+IF(Formular!$AE$62=\"\",0,IF(Formular!$W$62=\"\",Formular!$AE$62,Formular!$W$62))+IF(Formular!$AE$65=\"\",0,IF(Formular!$W$65=\"\",Formular!$AE$65,Formular!$W$65))+IF(Formular!$AE$68=\"\",0,IF(Formular!$W$68=\"\",Formular!$AE$68,Formular!$W$68)),MID(IF(Formular!$AE$50=\"\",0,IF(Formular!$W$50=\"\",Formular!$AE$50,Formular!$W$50))+IF(Formular!$AE$53=\"\",0,IF(Formular!$W$53=\"\",Formular!$AE$53,Formular!$W$53))+IF(Formular!$AE$56=\"\",0,IF(Formular!$W$56=\"\",Formular!$AE$56,Formular!$W$56))+IF(Formular!$AE$59=\"\",0,IF(Formular!$W$59=\"\",Formular!$AE$59,Formular!$W$59))+IF(Formular!$AE$62=\"\",0,IF(Formular!$W$62=\"\",Formular!$AE$62,Formular!$W$62))+IF(Formular!$AE$65=\"\",0,IF(Formular!$W$65=\"\",Formular!$AE$65,Formular!$W$65))+IF(Formular!$AE$68=\"\",0,IF(Formular!$W$68=\"\",Formular!$AE$68,Formular!$W$68)),1,SEARCH(\",\",IF(Formular!$AE$50=\"\",0,IF(Formular!$W$50=\"\",Formular!$AE$50,Formular!$W$50))+IF(Formular!$AE$53=\"\",0,IF(Formular!$W$53=\"\",Formular!$AE$53,Formular!$W$53))+IF(Formular!$AE$56=\"\",0,IF(Formular!$W$56=\"\",Formular!$AE$56,Formular!$W$56))+IF(Formular!$AE$59=\"\",0,IF(Formular!$W$59=\"\",Formular!$AE$59,Formular!$W$59))+IF(Formular!$AE$62=\"\",0,IF(Formular!$W$62=\"\",Formular!$AE$62,Formular!$W$62))+IF(Formular!$AE$65=\"\",0,IF(Formular!$W$65=\"\",Formular!$AE$65,Formular!$W$65))+IF(Formular!$AE$68=\"\",0,IF(Formular!$W$68=\"\",Formular!$AE$68,Formular!$W$68)),1)-1)&\".\"&MID(IF(Formular!$AE$50=\"\",0,IF(Formular!$W$50=\"\",Formular!$AE$50,Formular!$W$50))+IF(Formular!$AE$53=\"\",0,IF(Formular!$W$53=\"\",Formular!$AE$53,Formular!$W$53))+IF(Formular!$AE$56=\"\",0,IF(Formular!$W$56=\"\",Formular!$AE$56,Formular!$W$56))+IF(Formular!$AE$59=\"\",0,IF(Formular!$W$59=\"\",Formular!$AE$59,Formular!$W$59))+IF(Formular!$AE$62=\"\",0,IF(Formular!$W$62=\"\",Formular!$AE$62,Formular!$W$62))+IF(Formular!$AE$65=\"\",0,IF(Formular!$W$65=\"\",Formular!$AE$65,Formular!$W$65))+IF(Formular!$AE$68=\"\",0,IF(Formular!$W$68=\"\",Formular!$AE$68,Formular!$W$68)),SEARCH(\",\",IF(Formular!$AE$50=\"\",0,IF(Formular!$W$50=\"\",Formular!$AE$50,Formular!$W$50))+IF(Formular!$AE$53=\"\",0,IF(Formular!$W$53=\"\",Formular!$AE$53,Formular!$W$53))+IF(Formular!$AE$56=\"\",0,IF(Formular!$W$56=\"\",Formular!$AE$56,Formular!$W$56))+IF(Formular!$AE$59=\"\",0,IF(Formular!$W$59=\"\",Formular!$AE$59,Formular!$W$59))+IF(Formular!$AE$62=\"\",0,IF(Formular!$W$62=\"\",Formular!$AE$62,Formular!$W$62))+IF(Formular!$AE$65=\"\",0,IF(Formular!$W$65=\"\",Formular!$AE$65,Formular!$W$65))+IF(Formular!$AE$68=\"\",0,IF(Formular!$W$68=\"\",Formular!$AE$68,Formular!$W$68)),1)+1,2))&\"</cbc:TaxExclusiveAmount>\"","v":"      <cbc:TaxExclusiveAmount currencyID=\"EUR\">0</cbc:TaxExclusiveAmount>"}]
[{"$f":"\"      <cbc:TaxInclusiveAmount currencyID=\"\"EUR\"\">\"&IF(ISERR(SEARCH(\",\",Formular!$AE$72,1)),Formular!$AE$72,MID(Formular!$AE$72,1,SEARCH(\",\",Formular!$AE$72,1)-1)&\".\"&MID(Formular!$AE$72,SEARCH(\",\",Formular!$AE$72,1)+1,2))&\"</cbc:TaxInclusiveAmount>\"","v":"      <cbc:TaxInclusiveAmount currencyID=\"EUR\">0</cbc:TaxInclusiveAmount>"}]
[{"$f":"\"      <cbc:PrepaidAmount currencyID=\"\"EUR\"\">\"&0&\"</cbc:PrepaidAmount>\"","v":"      <cbc:PrepaidAmount currencyID=\"EUR\">0</cbc:PrepaidAmount>"}]
[{"$f":"\"      <cbc:PayableAmount currencyID=\"\"EUR\"\">\"&IF(ISERR(SEARCH(\",\",Formular!$AE$72,1)),Formular!$AE$72,MID(Formular!$AE$72,1,SEARCH(\",\",Formular!$AE$72,1)-1)&\".\"&MID(Formular!$AE$72,SEARCH(\",\",Formular!$AE$72,1)+1,2))&\"</cbc:PayableAmount>\"","v":"      <cbc:PayableAmount currencyID=\"EUR\">0</cbc:PayableAmount>"}]
["   </cac:LegalMonetaryTotal>"]
[]
["   <cac:InvoiceLine>"]
[{"$f":"\"      <cbc:ID>\"&Daten!$E$95&\"</cbc:ID>\"","v":"      <cbc:ID>1</cbc:ID>"}]
[{"$f":"\"      <cbc:Note>\"&\"\"&\"</cbc:Note>\"","v":"      <cbc:Note></cbc:Note>"}]
[{"$f":"\"      <cbc:InvoicedQuantity unitCode=\"\"\"&IF(Daten!$V$95=\"\",\"\",VLOOKUP(Daten!$V$95,Maßeinheiten!$A:$D,4,FALSE))&\"\"\">\"&IF(Formular!$AE$50=0,\"\",IF(ISERR(SEARCH(\",\",Daten!$H$96,1)),Daten!$H$96,MID(Daten!$H$96,1,SEARCH(\",\",Daten!$H$96,1)-1)&\".\"&MID(Daten!$H$96,SEARCH(\",\",Daten!$H$96,1)+1,2)))&\"</cbc:InvoicedQuantity>\"","v":"      <cbc:InvoicedQuantity unitCode=\"\"></cbc:InvoicedQuantity>"}]
[{"$f":"\"      <cbc:LineExtensionAmount currencyID=\"\"EUR\"\">\"&IF(Formular!$AE$50=0,\"\",IF(Formular!$W$50=\"\",IF(ISERR(SEARCH(\",\",Formular!$AE$50,1)),Formular!$AE$50,MID(Formular!$AE$50,1,SEARCH(\",\",Formular!$AE$50,1)-1)&\".\"&MID(Formular!$AE$50,SEARCH(\",\",Formular!$AE$50,1)+1,2)),IF(ISERR(SEARCH(\",\",Formular!$W$50,1)),Formular!$W$50,MID(Formular!$W$50,1,SEARCH(\",\",Formular!$W$50,1)-1)&\".\"&MID(Formular!$W$50,SEARCH(\",\",Formular!$W$50,1)+1,2))))&\"</cbc:LineExtensionAmount>\"","v":"      <cbc:LineExtensionAmount currencyID=\"EUR\"></cbc:LineExtensionAmount>"}]
["      <cac:Item>"]
[{"$f":"\"         <cbc:Description>\"&Daten!$E$89&IF(Daten!$E$90=\"\",\"\",\" \"&Daten!$E$90)&IF(Daten!$E$91=\"\",\"\",\" \"&Daten!$E$91)&\"</cbc:Description>\"","v":"         <cbc:Description></cbc:Description>"}]
[{"$f":"\"         <cbc:Name>\"&Daten!$F$95&\"</cbc:Name>\"","v":"         <cbc:Name></cbc:Name>"}]
["         <cac:ClassifiedTaxCategory>"]
[{"$f":"\"            <cbc:ID>\"&IF(Formular!$C$50=\"\",\"\",CHOOSE(Formular!$AJ$50,\"Z\",\"Z\",\"Z\",\"Z\",\"Z\",\"S\",\"S\",\"Z\"))&\"</cbc:ID>\"","v":"            <cbc:ID></cbc:ID>"}]
[{"$f":"\"            <cbc:Percent>\"&IF(Formular!$C$50=\"\",\"\",CHOOSE(Formular!$AJ$50,0,0,0,0,0,19,7,0))&\"</cbc:Percent>\"","v":"            <cbc:Percent></cbc:Percent>"}]
["            <cac:TaxScheme>"]
[{"$f":"\"               <cbc:ID>\"&\"VAT\"&\"</cbc:ID>\"","v":"               <cbc:ID>VAT</cbc:ID>"}]
["            </cac:TaxScheme>"]
["         </cac:ClassifiedTaxCategory>"]
["      </cac:Item>"]
["      <cac:Price>"]
[{"$f":"\"         <cbc:PriceAmount currencyID=\"\"EUR\"\">\"&IF(Formular!$AE$50=0,\"\",IF(Formular!$W$50=\"\",IF(ISERR(SEARCH(\",\",Formular!$AE$50,1)),Formular!$AE$50,MID(Formular!$AE$50,1,SEARCH(\",\",Formular!$AE$50,1)-1)&\".\"&MID(Formular!$AE$50,SEARCH(\",\",Formular!$AE$50,1)+1,2)),IF(ISERR(SEARCH(\",\",Formular!$W$50,1)),Formular!$W$50,MID(Formular!$W$50,1,SEARCH(\",\",Formular!$W$50,1)-1)&\".\"&MID(Formular!$W$50,SEARCH(\",\",Formular!$W$50,1)+1,2))))&\"</cbc:PriceAmount>\"","v":"         <cbc:PriceAmount currencyID=\"EUR\"></cbc:PriceAmount>"}]
[{"$f":"\"         <cbc:BaseQuantity unitCode=\"\"\"&IF(Daten!$V$95=\"\",\"\",VLOOKUP(Daten!$V$95,Maßeinheiten!$A:$D,4,FALSE))&\"\"\">\"&IF(Formular!$AE$50=0,\"\",IF(ISERR(SEARCH(\",\",Daten!$H$96,1)),Daten!$H$96,MID(Daten!$H$96,1,SEARCH(\",\",Daten!$H$96,1)-1)&\".\"&MID(Daten!$H$96,SEARCH(\",\",Daten!$H$96,1)+1,2)))&\"</cbc:BaseQuantity>\"","v":"         <cbc:BaseQuantity unitCode=\"\"></cbc:BaseQuantity>"}]
["      </cac:Price>"]
["   </cac:InvoiceLine>"]
[]
["   <cac:InvoiceLine>"]
[{"$f":"\"      <cbc:ID>\"&Daten!$E$98&\"</cbc:ID>\"","v":"      <cbc:ID>2</cbc:ID>"}]
[{"$f":"\"      <cbc:Note>\"&\"\"&\"</cbc:Note>\"","v":"      <cbc:Note></cbc:Note>"}]
[{"$f":"\"      <cbc:InvoicedQuantity unitCode=\"\"\"&IF(Daten!$V$98=\"\",\"\",VLOOKUP(Daten!$V$98,Maßeinheiten!$A:$D,4,FALSE))&\"\"\">\"&IF(Formular!$AE$53=0,\"\",IF(ISERR(SEARCH(\",\",Daten!$H$99,1)),Daten!$H$99,MID(Daten!$H$99,1,SEARCH(\",\",Daten!$H$99,1)-1)&\".\"&MID(Daten!$H$99,SEARCH(\",\",Daten!$H$99,1)+1,2)))&\"</cbc:InvoicedQuantity>\"","v":"      <cbc:InvoicedQuantity unitCode=\"\"></cbc:InvoicedQuantity>"}]
[{"$f":"\"      <cbc:LineExtensionAmount currencyID=\"\"EUR\"\">\"&IF(Formular!$AE$53=0,\"\",IF(Formular!$W$53=\"\",IF(ISERR(SEARCH(\",\",Formular!$AE$53,1)),Formular!$AE$53,MID(Formular!$AE$53,1,SEARCH(\",\",Formular!$AE$53,1)-1)&\".\"&MID(Formular!$AE$53,SEARCH(\",\",Formular!$AE$53,1)+1,2)),IF(ISERR(SEARCH(\",\",Formular!$W$53,1)),Formular!$W$53,MID(Formular!$W$53,1,SEARCH(\",\",Formular!$W$53,1)-1)&\".\"&MID(Formular!$W$53,SEARCH(\",\",Formular!$W$53,1)+1,2))))&\"</cbc:LineExtensionAmount>\"","v":"      <cbc:LineExtensionAmount currencyID=\"EUR\"></cbc:LineExtensionAmount>"}]
["      <cac:Item>"]
[{"$f":"\"         <cbc:Description>\"&\"\"&\"</cbc:Description>\"","v":"         <cbc:Description></cbc:Description>"}]
[{"$f":"\"         <cbc:Name>\"&IF(Daten!$F$98=\"\",\"\",Daten!$F$98)&\"</cbc:Name>\"","v":"         <cbc:Name></cbc:Name>"}]
["         <cac:ClassifiedTaxCategory>"]
[{"$f":"\"            <cbc:ID>\"&IF(Formular!$C$53=\"\",\"\",CHOOSE(Formular!$AJ$53,\"Z\",\"Z\",\"Z\",\"Z\",\"Z\",\"S\",\"S\",\"Z\"))&\"</cbc:ID>\"","v":"            <cbc:ID></cbc:ID>"}]
[{"$f":"\"            <cbc:Percent>\"&IF(Formular!$C$53=\"\",\"\",CHOOSE(Formular!$AJ$53,0,0,0,0,0,19,7,0))&\"</cbc:Percent>\"","v":"            <cbc:Percent></cbc:Percent>"}]
["            <cac:TaxScheme>"]
[{"$f":"\"               <cbc:ID>\"&\"VAT\"&\"</cbc:ID>\"","v":"               <cbc:ID>VAT</cbc:ID>"}]
["            </cac:TaxScheme>"]
["         </cac:ClassifiedTaxCategory>"]
["      </cac:Item>"]
["      <cac:Price>"]
[{"$f":"\"         <cbc:PriceAmount currencyID=\"\"EUR\"\">\"&IF(Formular!$AE$53=0,\"\",IF(Formular!$W$53=\"\",IF(ISERR(SEARCH(\",\",Formular!$AE$53,1)),Formular!$AE$53,MID(Formular!$AE$53,1,SEARCH(\",\",Formular!$AE$53,1)-1)&\".\"&MID(Formular!$AE$53,SEARCH(\",\",Formular!$AE$53,1)+1,2)),IF(ISERR(SEARCH(\",\",Formular!$W$53,1)),Formular!$W$53,MID(Formular!$W$53,1,SEARCH(\",\",Formular!$W$53,1)-1)&\".\"&MID(Formular!$W$53,SEARCH(\",\",Formular!$W$53,1)+1,2))))&\"</cbc:PriceAmount>\"","v":"         <cbc:PriceAmount currencyID=\"EUR\"></cbc:PriceAmount>"}]
[{"$f":"\"         <cbc:BaseQuantity unitCode=\"\"\"&IF(Daten!$V$98=\"\",\"\",VLOOKUP(Daten!$V$98,Maßeinheiten!$A:$D,4,FALSE))&\"\"\">\"&IF(Formular!$AE$53=0,\"\",IF(ISERR(SEARCH(\",\",Daten!$H$99,1)),Daten!$H$99,MID(Daten!$H$99,1,SEARCH(\",\",Daten!$H$99,1)-1)&\".\"&MID(Daten!$H$99,SEARCH(\",\",Daten!$H$99,1)+1,2)))&\"</cbc:BaseQuantity>\"","v":"         <cbc:BaseQuantity unitCode=\"\"></cbc:BaseQuantity>"}]
["      </cac:Price>"]
["   </cac:InvoiceLine>"]
[]
["   <cac:InvoiceLine>"]
[{"$f":"\"      <cbc:ID>\"&Daten!$E$101&\"</cbc:ID>\"","v":"      <cbc:ID>3</cbc:ID>"}]
[{"$f":"\"      <cbc:Note>\"&\"\"&\"</cbc:Note>\"","v":"      <cbc:Note></cbc:Note>"}]
[{"$f":"\"      <cbc:InvoicedQuantity unitCode=\"\"\"&IF(Daten!$V$101=\"\",\"\",VLOOKUP(Daten!$V$101,Maßeinheiten!$A:$D,4,FALSE))&\"\"\">\"&IF(Formular!$AE$56=0,\"\",IF(ISERR(SEARCH(\",\",Daten!$H$102,1)),Daten!$H$102,MID(Daten!$H$102,1,SEARCH(\",\",Daten!$H$102,1)-1)&\".\"&MID(Daten!$H$102,SEARCH(\",\",Daten!$H$102,1)+1,2)))&\"</cbc:InvoicedQuantity>\"","v":"      <cbc:InvoicedQuantity unitCode=\"\"></cbc:InvoicedQuantity>"}]
[{"$f":"\"      <cbc:LineExtensionAmount currencyID=\"\"EUR\"\">\"&IF(Formular!$AE$56=0,\"\",IF(Formular!$W$56=\"\",IF(ISERR(SEARCH(\",\",Formular!$AE$56,1)),Formular!$AE$56,MID(Formular!$AE$56,1,SEARCH(\",\",Formular!$AE$56,1)-1)&\".\"&MID(Formular!$AE$56,SEARCH(\",\",Formular!$AE$56,1)+1,2)),IF(ISERR(SEARCH(\",\",Formular!$W$56,1)),Formular!$W$56,MID(Formular!$W$56,1,SEARCH(\",\",Formular!$W$56,1)-1)&\".\"&MID(Formular!$W$56,SEARCH(\",\",Formular!$W$56,1)+1,2))))&\"</cbc:LineExtensionAmount>\"","v":"      <cbc:LineExtensionAmount currencyID=\"EUR\"></cbc:LineExtensionAmount>"}]
["      <cac:Item>"]
[{"$f":"\"         <cbc:Description>\"&\"\"&\"</cbc:Description>\"","v":"         <cbc:Description></cbc:Description>"}]
[{"$f":"\"         <cbc:Name>\"&IF(Daten!$F$101=\"\",\"\",Daten!$F$101)&\"</cbc:Name>\"","v":"         <cbc:Name></cbc:Name>"}]
["         <cac:ClassifiedTaxCategory>"]
[{"$f":"\"            <cbc:ID>\"&IF(Formular!$C$56=\"\",\"\",CHOOSE(Formular!$AJ$56,\"Z\",\"Z\",\"Z\",\"Z\",\"Z\",\"S\",\"S\",\"Z\"))&\"</cbc:ID>\"","v":"            <cbc:ID></cbc:ID>"}]
[{"$f":"\"            <cbc:Percent>\"&IF(Formular!$C$56=\"\",\"\",CHOOSE(Formular!$AJ$56,0,0,0,0,0,19,7,0))&\"</cbc:Percent>\"","v":"            <cbc:Percent></cbc:Percent>"}]
["            <cac:TaxScheme>"]
[{"$f":"\"               <cbc:ID>\"&\"VAT\"&\"</cbc:ID>\"","v":"               <cbc:ID>VAT</cbc:ID>"}]
["            </cac:TaxScheme>"]
["         </cac:ClassifiedTaxCategory>"]
["      </cac:Item>"]
["      <cac:Price>"]
[{"$f":"\"         <cbc:PriceAmount currencyID=\"\"EUR\"\">\"&IF(Formular!$AE$56=0,\"\",IF(Formular!$W$56=\"\",IF(ISERR(SEARCH(\",\",Formular!$AE$56,1)),Formular!$AE$56,MID(Formular!$AE$56,1,SEARCH(\",\",Formular!$AE$56,1)-1)&\".\"&MID(Formular!$AE$56,SEARCH(\",\",Formular!$AE$56,1)+1,2)),IF(ISERR(SEARCH(\",\",Formular!$W$56,1)),Formular!$W$56,MID(Formular!$W$56,1,SEARCH(\",\",Formular!$W$56,1)-1)&\".\"&MID(Formular!$W$56,SEARCH(\",\",Formular!$W$56,1)+1,2))))&\"</cbc:PriceAmount>\"","v":"         <cbc:PriceAmount currencyID=\"EUR\"></cbc:PriceAmount>"}]
[{"$f":"\"         <cbc:BaseQuantity unitCode=\"\"\"&IF(Daten!$V$101=\"\",\"\",VLOOKUP(Daten!$V$101,Maßeinheiten!$A:$D,4,FALSE))&\"\"\">\"&IF(Formular!$AE$56=0,\"\",IF(ISERR(SEARCH(\",\",Daten!$H$102,1)),Daten!$H$102,MID(Daten!$H$102,1,SEARCH(\",\",Daten!$H$102,1)-1)&\".\"&MID(Daten!$H$102,SEARCH(\",\",Daten!$H$102,1)+1,2)))&\"</cbc:BaseQuantity>\"","v":"         <cbc:BaseQuantity unitCode=\"\"></cbc:BaseQuantity>"}]
["      </cac:Price>"]
["   </cac:InvoiceLine>"]
[]
["   <cac:InvoiceLine>"]
[{"$f":"\"      <cbc:ID>\"&Daten!$E$104&\"</cbc:ID>\"","v":"      <cbc:ID>4</cbc:ID>"}]
[{"$f":"\"      <cbc:Note>\"&\"\"&\"</cbc:Note>\"","v":"      <cbc:Note></cbc:Note>"}]
[{"$f":"\"      <cbc:InvoicedQuantity unitCode=\"\"\"&IF(Daten!$V$104=\"\",\"\",VLOOKUP(Daten!$V$104,Maßeinheiten!$A:$D,4,FALSE))&\"\"\">\"&IF(Formular!$AE$59=0,\"\",IF(ISERR(SEARCH(\",\",Daten!$H$105,1)),Daten!$H$105,MID(Daten!$H$105,1,SEARCH(\",\",Daten!$H$105,1)-1)&\".\"&MID(Daten!$H$105,SEARCH(\",\",Daten!$H$105,1)+1,2)))&\"</cbc:InvoicedQuantity>\"","v":"      <cbc:InvoicedQuantity unitCode=\"\"></cbc:InvoicedQuantity>"}]
[{"$f":"\"      <cbc:LineExtensionAmount currencyID=\"\"EUR\"\">\"&IF(Formular!$AE$59=0,\"\",IF(Formular!$W$59=\"\",IF(ISERR(SEARCH(\",\",Formular!$AE$59,1)),Formular!$AE$59,MID(Formular!$AE$59,1,SEARCH(\",\",Formular!$AE$59,1)-1)&\".\"&MID(Formular!$AE$59,SEARCH(\",\",Formular!$AE$59,1)+1,2)),IF(ISERR(SEARCH(\",\",Formular!$W$59,1)),Formular!$W$59,MID(Formular!$W$59,1,SEARCH(\",\",Formular!$W$59,1)-1)&\".\"&MID(Formular!$W$59,SEARCH(\",\",Formular!$W$59,1)+1,2))))&\"</cbc:LineExtensionAmount>\"","v":"      <cbc:LineExtensionAmount currencyID=\"EUR\"></cbc:LineExtensionAmount>"}]
["      <cac:Item>"]
[{"$f":"\"         <cbc:Description>\"&\"\"&\"</cbc:Description>\"","v":"         <cbc:Description></cbc:Description>"}]
[{"$f":"\"         <cbc:Name>\"&IF(Daten!$F$104=\"\",\"\",Daten!$F$104)&\"</cbc:Name>\"","v":"         <cbc:Name></cbc:Name>"}]
["         <cac:ClassifiedTaxCategory>"]
[{"$f":"\"            <cbc:ID>\"&IF(Formular!$C$59=\"\",\"\",CHOOSE(Formular!$AJ$59,\"Z\",\"Z\",\"Z\",\"Z\",\"Z\",\"S\",\"S\",\"Z\"))&\"</cbc:ID>\"","v":"            <cbc:ID></cbc:ID>"}]
[{"$f":"\"            <cbc:Percent>\"&IF(Formular!$C$59=\"\",\"\",CHOOSE(Formular!$AJ$59,0,0,0,0,0,19,7,0))&\"</cbc:Percent>\"","v":"            <cbc:Percent></cbc:Percent>"}]
["            <cac:TaxScheme>"]
[{"$f":"\"               <cbc:ID>\"&\"VAT\"&\"</cbc:ID>\"","v":"               <cbc:ID>VAT</cbc:ID>"}]
["            </cac:TaxScheme>"]
["         </cac:ClassifiedTaxCategory>"]
["      </cac:Item>"]
["      <cac:Price>"]
[{"$f":"\"         <cbc:PriceAmount currencyID=\"\"EUR\"\">\"&IF(Formular!$AE$59=0,\"\",IF(Formular!$W$59=\"\",IF(ISERR(SEARCH(\",\",Formular!$AE$59,1)),Formular!$AE$59,MID(Formular!$AE$59,1,SEARCH(\",\",Formular!$AE$59,1)-1)&\".\"&MID(Formular!$AE$59,SEARCH(\",\",Formular!$AE$59,1)+1,2)),IF(ISERR(SEARCH(\",\",Formular!$W$59,1)),Formular!$W$59,MID(Formular!$W$59,1,SEARCH(\",\",Formular!$W$59,1)-1)&\".\"&MID(Formular!$W$59,SEARCH(\",\",Formular!$W$59,1)+1,2))))&\"</cbc:PriceAmount>\"","v":"         <cbc:PriceAmount currencyID=\"EUR\"></cbc:PriceAmount>"}]
[{"$f":"\"         <cbc:BaseQuantity unitCode=\"\"\"&IF(Daten!$V$104=\"\",\"\",VLOOKUP(Daten!$V$104,Maßeinheiten!$A:$D,4,FALSE))&\"\"\">\"&IF(Formular!$AE$59=0,\"\",IF(ISERR(SEARCH(\",\",Daten!$H$105,1)),Daten!$H$105,MID(Daten!$H$105,1,SEARCH(\",\",Daten!$H$105,1)-1)&\".\"&MID(Daten!$H$105,SEARCH(\",\",Daten!$H$105,1)+1,2)))&\"</cbc:BaseQuantity>\"","v":"         <cbc:BaseQuantity unitCode=\"\"></cbc:BaseQuantity>"}]
["      </cac:Price>"]
["   </cac:InvoiceLine>"]
[]
["   <cac:InvoiceLine>"]
[{"$f":"\"      <cbc:ID>\"&Daten!$E$107&\"</cbc:ID>\"","v":"      <cbc:ID>5</cbc:ID>"}]
[{"$f":"\"      <cbc:Note>\"&\"\"&\"</cbc:Note>\"","v":"      <cbc:Note></cbc:Note>"}]
[{"$f":"\"      <cbc:InvoicedQuantity unitCode=\"\"\"&IF(Daten!$V$107=\"\",\"\",VLOOKUP(Daten!$V$107,Maßeinheiten!$A:$D,4,FALSE))&\"\"\">\"&IF(Formular!$AE$62=0,\"\",IF(ISERR(SEARCH(\",\",Daten!$H$108,1)),Daten!$H$108,MID(Daten!$H$108,1,SEARCH(\",\",Daten!$H$108,1)-1)&\".\"&MID(Daten!$H$108,SEARCH(\",\",Daten!$H$108,1)+1,2)))&\"</cbc:InvoicedQuantity>\"","v":"      <cbc:InvoicedQuantity unitCode=\"\"></cbc:InvoicedQuantity>"}]
[{"$f":"\"      <cbc:LineExtensionAmount currencyID=\"\"EUR\"\">\"&IF(Formular!$AE$62=0,\"\",IF(Formular!$W$62=\"\",IF(ISERR(SEARCH(\",\",Formular!$AE$62,1)),Formular!$AE$62,MID(Formular!$AE$62,1,SEARCH(\",\",Formular!$AE$62,1)-1)&\".\"&MID(Formular!$AE$62,SEARCH(\",\",Formular!$AE$62,1)+1,2)),IF(ISERR(SEARCH(\",\",Formular!$W$62,1)),Formular!$W$62,MID(Formular!$W$62,1,SEARCH(\",\",Formular!$W$62,1)-1)&\".\"&MID(Formular!$W$62,SEARCH(\",\",Formular!$W$62,1)+1,2))))&\"</cbc:LineExtensionAmount>\"","v":"      <cbc:LineExtensionAmount currencyID=\"EUR\"></cbc:LineExtensionAmount>"}]
["      <cac:Item>"]
[{"$f":"\"         <cbc:Description>\"&\"\"&\"</cbc:Description>\"","v":"         <cbc:Description></cbc:Description>"}]
[{"$f":"\"         <cbc:Name>\"&IF(Daten!$F$107=\"\",\"\",Daten!$F$107)&\"</cbc:Name>\"","v":"         <cbc:Name></cbc:Name>"}]
["         <cac:ClassifiedTaxCategory>"]
[{"$f":"\"            <cbc:ID>\"&IF(Formular!$C$62=\"\",\"\",CHOOSE(Formular!$AJ$62,\"Z\",\"Z\",\"Z\",\"Z\",\"Z\",\"S\",\"S\",\"Z\"))&\"</cbc:ID>\"","v":"            <cbc:ID></cbc:ID>"}]
[{"$f":"\"            <cbc:Percent>\"&IF(Formular!$C$62=\"\",\"\",CHOOSE(Formular!$AJ$62,0,0,0,0,0,19,7,0))&\"</cbc:Percent>\"","v":"            <cbc:Percent></cbc:Percent>"}]
["            <cac:TaxScheme>"]
[{"$f":"\"               <cbc:ID>\"&\"VAT\"&\"</cbc:ID>\"","v":"               <cbc:ID>VAT</cbc:ID>"}]
["            </cac:TaxScheme>"]
["         </cac:ClassifiedTaxCategory>"]
["      </cac:Item>"]
["      <cac:Price>"]
[{"$f":"\"         <cbc:PriceAmount currencyID=\"\"EUR\"\">\"&IF(Formular!$AE$62=0,\"\",IF(Formular!$W$62=\"\",IF(ISERR(SEARCH(\",\",Formular!$AE$62,1)),Formular!$AE$62,MID(Formular!$AE$62,1,SEARCH(\",\",Formular!$AE$62,1)-1)&\".\"&MID(Formular!$AE$62,SEARCH(\",\",Formular!$AE$62,1)+1,2)),IF(ISERR(SEARCH(\",\",Formular!$W$62,1)),Formular!$W$62,MID(Formular!$W$62,1,SEARCH(\",\",Formular!$W$62,1)-1)&\".\"&MID(Formular!$W$62,SEARCH(\",\",Formular!$W$62,1)+1,2))))&\"</cbc:PriceAmount>\"","v":"         <cbc:PriceAmount currencyID=\"EUR\"></cbc:PriceAmount>"}]
[{"$f":"\"         <cbc:BaseQuantity unitCode=\"\"\"&IF(Daten!$V$107=\"\",\"\",VLOOKUP(Daten!$V$107,Maßeinheiten!$A:$D,4,FALSE))&\"\"\">\"&IF(Formular!$AE$62=0,\"\",IF(ISERR(SEARCH(\",\",Daten!$H$108,1)),Daten!$H$108,MID(Daten!$H$108,1,SEARCH(\",\",Daten!$H$108,1)-1)&\".\"&MID(Daten!$H$108,SEARCH(\",\",Daten!$H$108,1)+1,2)))&\"</cbc:BaseQuantity>\"","v":"         <cbc:BaseQuantity unitCode=\"\"></cbc:BaseQuantity>"}]
["      </cac:Price>"]
["   </cac:InvoiceLine>"]
[]
["   <cac:InvoiceLine>"]
[{"$f":"\"      <cbc:ID>\"&Daten!$E$110&\"</cbc:ID>\"","v":"      <cbc:ID>6</cbc:ID>"}]
[{"$f":"\"      <cbc:Note>\"&\"\"&\"</cbc:Note>\"","v":"      <cbc:Note></cbc:Note>"}]
[{"$f":"\"      <cbc:InvoicedQuantity unitCode=\"\"\"&IF(Daten!$V$110=\"\",\"\",VLOOKUP(Daten!$V$110,Maßeinheiten!$A:$D,4,FALSE))&\"\"\">\"&IF(Formular!$AE$65=0,\"\",IF(ISERR(SEARCH(\",\",Daten!$H$111,1)),Daten!$H$111,MID(Daten!$H$111,1,SEARCH(\",\",Daten!$H$111,1)-1)&\".\"&MID(Daten!$H$111,SEARCH(\",\",Daten!$H$111,1)+1,2)))&\"</cbc:InvoicedQuantity>\"","v":"      <cbc:InvoicedQuantity unitCode=\"\"></cbc:InvoicedQuantity>"}]
[{"$f":"\"      <cbc:LineExtensionAmount currencyID=\"\"EUR\"\">\"&IF(Formular!$AE$65=0,\"\",IF(Formular!$W$65=\"\",IF(ISERR(SEARCH(\",\",Formular!$AE$65,1)),Formular!$AE$65,MID(Formular!$AE$65,1,SEARCH(\",\",Formular!$AE$65,1)-1)&\".\"&MID(Formular!$AE$65,SEARCH(\",\",Formular!$AE$65,1)+1,2)),IF(ISERR(SEARCH(\",\",Formular!$W$65,1)),Formular!$W$65,MID(Formular!$W$65,1,SEARCH(\",\",Formular!$W$65,1)-1)&\".\"&MID(Formular!$W$65,SEARCH(\",\",Formular!$W$65,1)+1,2))))&\"</cbc:LineExtensionAmount>\"","v":"      <cbc:LineExtensionAmount currencyID=\"EUR\"></cbc:LineExtensionAmount>"}]
["      <cac:Item>"]
[{"$f":"\"         <cbc:Description>\"&\"\"&\"</cbc:Description>\"","v":"         <cbc:Description></cbc:Description>"}]
[{"$f":"\"         <cbc:Name>\"&IF(Daten!$F$110=\"\",\"\",Daten!$F$110)&\"</cbc:Name>\"","v":"         <cbc:Name></cbc:Name>"}]
["         <cac:ClassifiedTaxCategory>"]
[{"$f":"\"            <cbc:ID>\"&IF(Formular!$C$65=\"\",\"\",CHOOSE(Formular!$AJ$65,\"Z\",\"Z\",\"Z\",\"Z\",\"Z\",\"S\",\"S\",\"Z\"))&\"</cbc:ID>\"","v":"            <cbc:ID></cbc:ID>"}]
[{"$f":"\"            <cbc:Percent>\"&IF(Formular!$C$65=\"\",\"\",CHOOSE(Formular!$AJ$65,0,0,0,0,0,19,7,0))&\"</cbc:Percent>\"","v":"            <cbc:Percent></cbc:Percent>"}]
["            <cac:TaxScheme>"]
[{"$f":"\"               <cbc:ID>\"&\"VAT\"&\"</cbc:ID>\"","v":"               <cbc:ID>VAT</cbc:ID>"}]
["            </cac:TaxScheme>"]
["         </cac:ClassifiedTaxCategory>"]
["      </cac:Item>"]
["      <cac:Price>"]
[{"$f":"\"         <cbc:PriceAmount currencyID=\"\"EUR\"\">\"&IF(Formular!$AE$65=0,\"\",IF(Formular!$W$65=\"\",IF(ISERR(SEARCH(\",\",Formular!$AE$65,1)),Formular!$AE$65,MID(Formular!$AE$65,1,SEARCH(\",\",Formular!$AE$65,1)-1)&\".\"&MID(Formular!$AE$65,SEARCH(\",\",Formular!$AE$65,1)+1,2)),IF(ISERR(SEARCH(\",\",Formular!$W$65,1)),Formular!$W$65,MID(Formular!$W$65,1,SEARCH(\",\",Formular!$W$65,1)-1)&\".\"&MID(Formular!$W$65,SEARCH(\",\",Formular!$W$65,1)+1,2))))&\"</cbc:PriceAmount>\"","v":"         <cbc:PriceAmount currencyID=\"EUR\"></cbc:PriceAmount>"}]
[{"$f":"\"         <cbc:BaseQuantity unitCode=\"\"\"&IF(Daten!$V$110=\"\",\"\",VLOOKUP(Daten!$V$110,Maßeinheiten!$A:$D,4,FALSE))&\"\"\">\"&IF(Formular!$AE$65=0,\"\",IF(ISERR(SEARCH(\",\",Daten!$H$111,1)),Daten!$H$111,MID(Daten!$H$111,1,SEARCH(\",\",Daten!$H$111,1)-1)&\".\"&MID(Daten!$H$111,SEARCH(\",\",Daten!$H$111,1)+1,2)))&\"</cbc:BaseQuantity>\"","v":"         <cbc:BaseQuantity unitCode=\"\"></cbc:BaseQuantity>"}]
["      </cac:Price>"]
["   </cac:InvoiceLine>"]
[]
["   <cac:InvoiceLine>"]
[{"$f":"\"      <cbc:ID>\"&Daten!$E$113&\"</cbc:ID>\"","v":"      <cbc:ID>7</cbc:ID>"}]
[{"$f":"\"      <cbc:Note>\"&\"\"&\"</cbc:Note>\"","v":"      <cbc:Note></cbc:Note>"}]
[{"$f":"\"      <cbc:InvoicedQuantity unitCode=\"\"\"&IF(Daten!$V$113=\"\",\"\",VLOOKUP(Daten!$V$113,Maßeinheiten!$A:$D,4,FALSE))&\"\"\">\"&IF(Formular!$AE$68=0,\"\",IF(ISERR(SEARCH(\",\",Daten!$H$114,1)),Daten!$H$114,MID(Daten!$H$114,1,SEARCH(\",\",Daten!$H$114,1)-1)&\".\"&MID(Daten!$H$114,SEARCH(\",\",Daten!$H$114,1)+1,2)))&\"</cbc:InvoicedQuantity>\"","v":"      <cbc:InvoicedQuantity unitCode=\"\"></cbc:InvoicedQuantity>"}]
[{"$f":"\"      <cbc:LineExtensionAmount currencyID=\"\"EUR\"\">\"&IF(Formular!$AE$68=0,\"\",IF(Formular!$W$68=\"\",IF(ISERR(SEARCH(\",\",Formular!$AE$68,1)),Formular!$AE$68,MID(Formular!$AE$68,1,SEARCH(\",\",Formular!$AE$68,1)-1)&\".\"&MID(Formular!$AE$68,SEARCH(\",\",Formular!$AE$68,1)+1,2)),IF(ISERR(SEARCH(\",\",Formular!$W$68,1)),Formular!$W$68,MID(Formular!$W$68,1,SEARCH(\",\",Formular!$W$68,1)-1)&\".\"&MID(Formular!$W$68,SEARCH(\",\",Formular!$W$68,1)+1,2))))&\"</cbc:LineExtensionAmount>\"","v":"      <cbc:LineExtensionAmount currencyID=\"EUR\"></cbc:LineExtensionAmount>"}]
["      <cac:Item>"]
[{"$f":"\"         <cbc:Description>\"&\"\"&\"</cbc:Description>\"","v":"         <cbc:Description></cbc:Description>"}]
[{"$f":"\"         <cbc:Name>\"&IF(Daten!$F$113=\"\",\"\",Daten!$F$113)&\"</cbc:Name>\"","v":"         <cbc:Name></cbc:Name>"}]
["         <cac:ClassifiedTaxCategory>"]
[{"$f":"\"            <cbc:ID>\"&IF(Formular!$C$68=\"\",\"\",CHOOSE(Formular!$AJ$68,\"Z\",\"Z\",\"Z\",\"Z\",\"Z\",\"S\",\"S\",\"Z\"))&\"</cbc:ID>\"","v":"            <cbc:ID></cbc:ID>"}]
[{"$f":"\"            <cbc:Percent>\"&IF(Formular!$C$68=\"\",\"\",CHOOSE(Formular!$AJ$68,0,0,0,0,0,19,7,0))&\"</cbc:Percent>\"","v":"            <cbc:Percent></cbc:Percent>"}]
["            <cac:TaxScheme>"]
[{"$f":"\"               <cbc:ID>\"&\"VAT\"&\"</cbc:ID>\"","v":"               <cbc:ID>VAT</cbc:ID>"}]
["            </cac:TaxScheme>"]
["         </cac:ClassifiedTaxCategory>"]
["      </cac:Item>"]
["      <cac:Price>"]
[{"$f":"\"         <cbc:PriceAmount currencyID=\"\"EUR\"\">\"&IF(Formular!$AE$68=0,\"\",IF(Formular!$W$68=\"\",IF(ISERR(SEARCH(\",\",Formular!$AE$68,1)),Formular!$AE$68,MID(Formular!$AE$68,1,SEARCH(\",\",Formular!$AE$68,1)-1)&\".\"&MID(Formular!$AE$68,SEARCH(\",\",Formular!$AE$68,1)+1,2)),IF(ISERR(SEARCH(\",\",Formular!$W$68,1)),Formular!$W$68,MID(Formular!$W$68,1,SEARCH(\",\",Formular!$W$68,1)-1)&\".\"&MID(Formular!$W$68,SEARCH(\",\",Formular!$W$68,1)+1,2))))&\"</cbc:PriceAmount>\"","v":"         <cbc:PriceAmount currencyID=\"EUR\"></cbc:PriceAmount>"}]
[{"$f":"\"         <cbc:BaseQuantity unitCode=\"\"\"&IF(Daten!$V$113=\"\",\"\",VLOOKUP(Daten!$V$113,Maßeinheiten!$A:$D,4,FALSE))&\"\"\">\"&IF(Formular!$AE$68=0,\"\",IF(ISERR(SEARCH(\",\",Daten!$H$114,1)),Daten!$H$114,MID(Daten!$H$114,1,SEARCH(\",\",Daten!$H$114,1)-1)&\".\"&MID(Daten!$H$114,SEARCH(\",\",Daten!$H$114,1)+1,2)))&\"</cbc:BaseQuantity>\"","v":"         <cbc:BaseQuantity unitCode=\"\"></cbc:BaseQuantity>"}]
["      </cac:Price>"]
["   </cac:InvoiceLine>"]
[]
["</Invoice>"]

{"sheet":"Rechtsformen","index":7,"n_rows":3,"n_cols":2,"rows_kept":3,"hidden":true}
[null,"Rechtsform"]
[1,"Privatperson"]
[2,"Unternehmen / Jurist. Person des Öffentl. Rechts"]

{"sheet":"Länder","index":8,"n_rows":263,"n_cols":6,"rows_kept":263,"hidden":true}
[null,"Land",null,"Länderkürzel","EU","Sprache"]
[1,"Afghanistan",null,"AF","","englisch"]
[2,"Ägypten",null,"EG","","englisch"]
[3,"Ålandinseln (FI)",null,"FI","","englisch"]
[4,"Albanien",null,"AL","","englisch"]
[5,"Algerien",null,"DZ","","englisch"]
[6,"Amerikanische Jungferninseln",null,"VI","","englisch"]
[7,"Andorra",null,"AD","","englisch"]
[8,"Angola",null,"AO","","englisch"]
[9,"Anguilla",null,"AI","","englisch"]
[10,"Antarktis",null,"AQ","","englisch"]
[11,"Antigua / Barbuda",null,"AG","","englisch"]
[12,"Äquatorialguine",null,"GQ","","englisch"]
[13,"Argentinien",null,"AR","","englisch"]
[14,"Armenien",null,"AM","","englisch"]
[15,"Aruba",null,"AW","","englisch"]
[16,"Aserbaidschan",null,"AZ","","englisch"]
[17,"Äthiopien",null,"ET","","englisch"]
[18,"Australien",null,"AU","","englisch"]
[19,"Bahamas",null,"BS","","englisch"]
[20,"Bahrain",null,"BH","","englisch"]
[21,"Bangladesch",null,"BD","","englisch"]
[22,"Barbados",null,"BB","","englisch"]
[23,"Belarus (Weißrussland)",null,"BY","","englisch"]
[24,"Belgien",null,"BE","X","englisch"]
[25,"Belize",null,"BZ","","englisch"]
[26,"Benin",null,"BJ","","englisch"]
[27,"Berg Athos (GR)",null,"GR","","englisch"]
[28,"Bermuda",null,"BM","","englisch"]
[29,"Bhutan",null,"BT","","englisch"]
[30,"Bolivien",null,"BO","","englisch"]
[31,"Bonaire, Saba",null,"BQ","","englisch"]
[32,"Bosnien-Herzegowina",null,"BA","","englisch"]
[33,"Botsuana",null,"BW","","englisch"]
[34,"Bouvet Inseln",null,"BV","","englisch"]
[35,"Brasilien",null,"BR","","englisch"]
[36,"Britische Gebiete im Indischen Ozean",null,"IO","","englisch"]
[37,"Britische Jungferninseln",null,"VG","","englisch"]
[38,"Brunei Drussal.",null,"BN","","englisch"]
[39,"Bulgarien",null,"BG","X","englisch"]
[40,"Burkina-Faso",null,"BF","","englisch"]
[41,"Burundi",null,"BI","","englisch"]
[42,"Campione d'Italia (IT)",null,"IT","","englisch"]
[43,"Ceuta (ES)",null,"ES","","englisch"]
[44,"Chile",null,"CL","","englisch"]
[45,"China",null,"CN","","englisch"]
[46,"Cookinseln",null,"CK","","englisch"]
[47,"Costa Rica",null,"CR","","englisch"]
[48,"Curaçao",null,"CW","","englisch"]
[49,"Dänemark",null,"DK","X","englisch"]
[50,"Deutschland",null,"DE","X","deutsch"]
[51,"Dominica",null,"DM","","englisch"]
[52,"Dominikanische Republik",null,"DO","","englisch"]
[53,"Dschibuti",null,"DJ","","englisch"]
[54,"Ecuador",null,"EC","","englisch"]
[55,"El Salvador",null,"SV","","englisch"]
[56,"Elfenbeinküste",null,"CI","","englisch"]
[57,"Eritrea",null,"ER","","englisch"]
[58,"Estland",null,"EE","X","englisch"]
[59,"Falklandinseln",null,"FK","","englisch"]
[60,"Färöer Inseln (DK)",null,"FO","","englisch"]
[61,"Fidschi",null,"FJ","","englisch"]
[62,"Finnland",null,"FI","X","englisch"]
[63,"Frankreich",null,"FR","X","englisch"]
[64,"Französisch Guayana",null,"GF","","englisch"]
[65,"Französisch Polynesien",null,"PF","","englisch"]
[66,"French S. Territorium",null,"TF","","englisch"]
[67,"Gabun",null,"GA","","englisch"]
[68,"Gambia",null,"GM","","englisch"]
[69,"Georgien",null,"GE","","englisch"]
[70,"Ghana",null,"GH","","englisch"]
[71,"Gibraltar (GB)",null,"GI","","englisch"]
[72,"Grenada",null,"GD","","englisch"]
[73,"Griechenland",null,"GR","X","englisch"]
[74,"Grönland (DK)",null,"GL","","englisch"]
[75,"Großbritannien",null,"GB","","englisch"]
[76,"Guadeloupe",null,"GP","","englisch"]
[77,"Guam",null,"GU","","englisch"]
[78,"Guatemala",null,"GT","","englisch"]
[79,"Guernsey (GB)",null,"GG","","englisch"]
[80,"Guinea",null,"GN","","englisch"]
[81,"Guinea-Bissau",null,"GW","","englisch"]
[82,"Guyana",null,"GY","","englisch"]
[83,"Haiti",null,"HT","","englisch"]
[84,"Heard / McDonald Inseln",null,"HM","","englisch"]
[85,"Honduras",null,"HN","","englisch"]
[86,"Hongkong",null,"HK","","englisch"]
[87,"Indien",null,"IN","","englisch"]
[88,"Indonesien",null,"ID","","englisch"]
[89,"Irak",null,"IQ","","englisch"]
[90,"Iran",null,"IR","","englisch"]
[91,"Irland",null,"IE","X","englisch"]
[92,"Island",null,"IS","","englisch"]
[93,"Israel",null,"IL","","englisch"]
[94,"Italien",null,"IT","X","englisch"]
[95,"Jamaika",null,"JM","","englisch"]
[96,"Japan",null,"JP","","englisch"]
[97,"Jemen",null,"YE","","englisch"]
[98,"Jersey (GB)",null,"JE","","englisch"]
[99,"Jordanien",null,"JO","","englisch"]
[100,"Kaimaninseln",null,"KY","","englisch"]
[101,"Kambodscha",null,"KH","","englisch"]
[102,"Kamerun",null,"CM","","englisch"]
[103,"Kanada",null,"CA","","englisch"]
[104,"Kanarische Inseln (ES)",null,"ES","","englisch"]
[105,"Kap Verde",null,"CV","","englisch"]
[106,"Kasachstan",null,"KZ","","englisch"]
[107,"Katar",null,"QA","","englisch"]
[108,"Kenia",null,"KE","","englisch"]
[109,"Kirgisistan",null,"KG","","englisch"]
[110,"Kiribati",null,"KI","","englisch"]
[111,"Kokosinseln",null,"CC","","englisch"]
[112,"Kolumbien",null,"CO","","englisch"]
[113,"Komoren",null,"KM","","englisch"]
[114,"Kongo",null,"CG","","englisch"]
[115,"Kosovo (RS)",null,"RS","","englisch"]
[116,"Kroatien",null,"HR","X","englisch"]
[117,"Kuba",null,"CU","","englisch"]
[118,"Kuwait",null,"KW","","englisch"]
[119,"Laos",null,"LA","","englisch"]
[120,"Lesotho",null,"LS","","englisch"]
[121,"Lettland",null,"LV","X","englisch"]
[122,"Libanon",null,"LB","","englisch"]
[123,"Liberia",null,"LR","","englisch"]
[124,"Libyen",null,"LY","","englisch"]
[125,"Liechtenstein",null,"LI","","englisch"]
[126,"Litauen",null,"LT","X","englisch"]
[127,"Livigno (IT)",null,"IT","","englisch"]
[128,"Luxemburg",null,"LU","X","englisch"]
[129,"Macau",null,"MO","","englisch"]
[130,"Madagaskar",null,"MG","","englisch"]
[131,"Malawi",null,"MW","","englisch"]
[132,"Malaysia",null,"MY","","englisch"]
[133,"Malediven",null,"MV","","englisch"]
[134,"Mali",null,"ML","","englisch"]
[135,"Malta",null,"MT","X","englisch"]
[136,"Man Insel",null,"IM","X","englisch"]
[137,"Marokko",null,"MA","","englisch"]
[138,"Marshall-Insel",null,"MH","","englisch"]
[139,"Martinique",null,"MQ","","englisch"]
[140,"Mauretanien",null,"MR","","englisch"]
[141,"Mauritius",null,"MU","","englisch"]
[142,"Mayotte",null,"YT","","englisch"]
[143,"Mazedonien",null,"MK","","englisch"]
[144,"Melilla (ES)",null,"ES","","englisch"]
[145,"Mexiko",null,"MX","","englisch"]
[146,"Mikronesien",null,"FM","","englisch"]
[147,"Minor Outl. Inseln",null,"UM","","englisch"]
[148,"Moldau",null,"MD","","englisch"]
[149,"Monaco",null,"MC","X","englisch"]
[150,"Mongolei",null,"MN","","englisch"]
[151,"Montenegro",null,"ME","","englisch"]
[152,"Montserrat",null,"MS","","englisch"]
[153,"Mosambik",null,"MZ","","englisch"]
[154,"Myanmar",null,"MM","","englisch"]
[155,"Namibia",null,"NA","","englisch"]
[156,"Nauru",null,"NR","","englisch"]
[157,"Nepal",null,"NP","","englisch"]
[158,"Neukaledonien",null,"NC","","englisch"]
[159,"Neuseeland",null,"NZ","","englisch"]
[160,"Nicaragua",null,"NI","","englisch"]
[161,"Niederländische Antillen",null,"AN","","englisch"]
[162,"Niederlande",null,"NL","X","englisch"]
[163,"Niger",null,"NE","","englisch"]
[164,"Nigeria",null,"NG","","englisch"]
[165,"Niue-Inseln",null,"NU","","englisch"]
[166,"Nordkorea",null,"KP","","englisch"]
[167,"Nördl. Marianen",null,"MP","","englisch"]
[168,"Norfolkinseln",null,"NF","","englisch"]
[169,"Norwegen",null,"NO","","englisch"]
[170,"Oman",null,"OM","","englisch"]
[171,"Orange",null,"OR","","englisch"]
[172,"Ost Timor",null,"TL","","englisch"]
[173,"Österreich",null,"AT","X","deutsch"]
[174,"Pakistan",null,"PK","","englisch"]
[175,"Palästina",null,"PS","","englisch"]
[176,"Palau",null,"PW","","englisch"]
[177,"Panama",null,"PA","","englisch"]
[178,"Papua-Neuguinea",null,"PG","","englisch"]
[179,"Paraguay",null,"PY","","englisch"]
[180,"Peru",null,"PE","","englisch"]
[181,"Philippinen",null,"PH","","englisch"]
[182,"Pitcairn Inseln",null,"PN","","englisch"]
[183,"Polen",null,"PL","X","englisch"]
[184,"Portugal",null,"PT","X","englisch"]
[185,"Puerto Rico",null,"PR","","englisch"]
[186,"Republik Kongo",null,"CD","","englisch"]
[187,"Reunion",null,"RE","","englisch"]
[188,"Ruanda",null,"RW","","englisch"]
[189,"Rumänien",null,"RO","X","englisch"]
[190,"Russische Föderation",null,"RU","","englisch"]
[191,"S. Sandwich Inseln",null,"GS","","englisch"]
[192,"S. Tome, Principe",null,"ST","","englisch"]
[193,"Salomonen",null,"SB","","englisch"]
[194,"Sambia",null,"ZM","","englisch"]
[195,"Samoa, Amerikan",null,"AS","","englisch"]
[196,"San Marino",null,"SM","","englisch"]
[197,"Saudi-Arabien",null,"SA","","englisch"]
[198,"Schweden",null,"SE","X","englisch"]
[199,"Schweiz",null,"CH","","deutsch"]
[200,"Senegal",null,"SN","","englisch"]
[201,"Serbien",null,"RS","","englisch"]
[202,"Serbien-Montenegro",null,"CS","","englisch"]
[203,"Seychellen",null,"SC","","englisch"]
[204,"Sierra Leone",null,"SL","","englisch"]
[205,"Simbabwe",null,"ZW","","englisch"]
[206,"Singapur",null,"SG","","englisch"]
[207,"Sint Maarten",null,"SX","","englisch"]
[208,"Slowakei",null,"SK","X","englisch"]
[209,"Slowenien",null,"SI","X","englisch"]
[210,"Somalia",null,"SO","","englisch"]
[211,"Spanien",null,"ES","X","englisch"]
[212,"Sri Lanka",null,"LK","","englisch"]
[213,"St. Barthélemy",null,"BL","","englisch"]
[214,"St. Helena",null,"SH","","englisch"]
[215,"St. Lucia",null,"LC","","englisch"]
[216,"St. Martin",null,"MF","","englisch"]
[217,"St. Vincent",null,"VC","","englisch"]
[218,"St. Kitts & Nevis",null,"KN","","englisch"]
[219,"St. Pier., Miquel.",null,"PM","","englisch"]
[220,"Südafrika",null,"ZA","","englisch"]
[221,"Sudan",null,"SD","","englisch"]
[222,"Südkorea",null,"KR","","englisch"]
[223,"Südsudan",null,"SS","","englisch"]
[224,"Suriname",null,"SR","","englisch"]
[225,"Svalbard",null,"SJ","","englisch"]
[226,"Swasiland",null,"SZ","","englisch"]
[227,"Syrien",null,"SY","","englisch"]
[228,"Tadschikistan",null,"TJ","","englisch"]
[229,"Taiwan",null,"TW","","englisch"]
[230,"Tansania",null,"TZ","","englisch"]
[231,"Thailand",null,"TH","","englisch"]
[232,"Togo",null,"TG","","englisch"]
[233,"Tokelau-Inseln",null,"TK","","englisch"]
[234,"Tonga",null,"TO","","englisch"]
[235,"Trinidad, Tobago",null,"TT","","englisch"]
[236,"Tschad",null,"TD","","englisch"]
[237,"Tschechische Republik",null,"CZ","X","englisch"]
[238,"Tunesien",null,"TN","","englisch"]
[239,"Türkei",null,"TR","","englisch"]
[240,"Turkmenistan",null,"TM","","englisch"]
[241,"Turks-, Caicosin",null,"TC","","englisch"]
[242,"Tuvalu",null,"TV","","englisch"]
[243,"Uganda",null,"UG","","englisch"]
[244,"Ukraine",null,"UA","","englisch"]
[245,"Ungarn",null,"HU","X","englisch"]
[246,"Uruguay",null,"UY","","englisch"]
[247,"USA",null,"US","","englisch"]
[248,"Usbekistan",null,"UZ","","englisch"]
[249,"Vanuatu",null,"VU","","englisch"]
[250,"Vatikanstadt",null,"VA","","englisch"]
[251,"Venezuela",null,"VE","","englisch"]
[252,"Vereinigte Arabische Emirate",null,"AE","","englisch"]
[253,"Vietnam",null,"VN","","englisch"]
[254,"Wallis, Futuna",null,"WF","","englisch"]
[255,"Weihnachtsinsel",null,"CX","","englisch"]
[256,"Weißrussland",null,"BY","","englisch"]
[257,"West Sahara",null,"EH","","englisch"]
[258,"Westsamoa",null,"WS","","englisch"]
[259,"Zentralafrikanische Republik",null,"CF","","englisch"]
[260,"Zypern",null,"CY","X","englisch"]
[261,"Zypern (Nordteil)",null,"CY","","englisch"]
[262,"Sonstige",null,null,"","englisch"]

{"sheet":"Kontierungsobjekte","index":9,"n_rows":4,"n_cols":2,"rows_kept":4,"hidden":true}
[null,"Kontierungsobjekte"]
[1,"PSP-Element"]
[2,"Kostenstelle und Fonds"]
[3,"Innenauftrag"]

{"sheet":"Maßeinheiten","index":10,"n_rows":20,"n_cols":5,"rows_kept":20,"hidden":true}
[null,"Maßeinheit","Kürzel \nSAP","Kürzel \neRechnung"]
[1,"Stück (ST)","ST","C62"]
[2,"Stunde (STD)","STD","HUR"]
[3,"Tag (TAG)","TAG","DAY"]
[4,"Monat (MON)","MON","3C"]
[5,"Jahr (JHR)","JHR","ANN"]
[6,"Kilowattstunde (KWH)","KWH","KWH"]
[7,"Gramm (G)","G","GRM"]
[8,"Kilogramm (KG)","KG","KGM"]
[9,"Tonne (TO)","TO","TNE"]
[10,"Prozent (%)","%","C62","in Formeln hinterlegt"]
[11,"Millimeter (MM)","MM","C62"]
[12,"Zentimeter (CM)","CM","CMT"]
[13,"Meter (M)","M","MTR"]
[14,"Kilometer (KM)","KM","KMT"]
[15,"Quadratmeter (M2)","M2","MTK"]
[16,"Kubikmeter (M3)","M3","MTQ"]
[17,"Liter (L)","L","LTR"]
[18,"Flasche (FL)","FL","BO"]
[19,"Sonstige (LE)","LE","XPP"]