{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["UST","BEW Belege FAs"],"not_rendered":{"charts":0,"images":18,"macros":0,"external_links":0,"defined_names":12,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"UST","index":0,"n_rows":2002,"n_cols":104,"rows_kept":2002,"cut":false,"hidden":false,"merged":[[5,81,5,95],[0,19,0,21],[111,84,111,86],[112,84,112,86],[113,85,113,86],[117,81,117,84],[117,94,117,95],[117,87,117,90],[116,93,116,94],[116,86,116,88],[1,80,1,95],[110,81,110,95],[115,81,115,95],[53,91,53,93],[54,91,54,93],[56,91,56,93],[58,91,58,93],[78,94,78,95],[76,94,76,95],[71,94,71,95],[45,81,45,95],[101,91,101,93],[99,91,99,93],[96,91,96,93],[69,91,70,95],[69,90,70,90],[34,82,34,83],[40,87,40,90],[40,85,40,86],[40,91,40,93],[40,94,40,95],[29,85,29,86],[29,87,29,90],[29,91,29,93],[29,94,29,95],[41,91,41,93],[41,87,41,90],[41,85,41,86],[42,85,42,86],[30,91,30,93],[30,94,30,95],[39,91,39,93],[39,94,39,95],[93,91,93,93],[50,91,50,93],[74,94,74,95],[42,87,42,90],[42,91,42,93],[42,94,42,95],[43,85,43,86],[37,82,37,95],[24,82,24,95],[21,82,21,83],[27,85,27,86],[27,87,27,90],[27,91,27,93],[27,94,27,95],[28,85,28,86],[28,87,28,90],[28,91,28,93],[28,94,28,95],[41,94,41,95],[8,82,8,83],[11,82,11,95],[14,85,14,86],[14,87,14,90],[43,91,43,93],[43,94,43,95],[39,85,39,86],[39,87,39,90],[150,81,150,95],[120,81,120,95],[16,85,16,86],[16,87,16,90],[16,91,16,93],[16,94,16,95],[17,85,17,86],[17,87,17,90],[17,91,17,93],[17,94,17,95],[149,81,149,95],[139,87,139,90],[145,87,145,90],[133,87,133,90],[30,85,30,86],[30,87,30,90],[127,87,127,90],[121,81,121,95],[156,81,156,84],[155,81,155,84],[154,81,154,84],[152,85,152,86],[152,87,152,90],[152,91,152,93],[153,85,153,86],[153,87,153,90],[153,91,153,93],[154,85,154,86],[154,87,154,90],[154,91,154,93],[155,85,155,86],[155,87,155,90],[155,91,155,93],[156,85,156,86],[156,87,156,90],[156,91,156,93],[26,85,26,86],[26,87,26,90],[26,91,26,93],[26,94,26,95],[13,85,13,86],[13,87,13,90],[13,91,13,93],[13,94,13,95],[43,87,43,90],[14,91,14,93],[14,94,14,95],[15,85,15,86],[15,87,15,90],[15,91,15,93],[15,94,15,95],[156,3,156,6],[156,7,156,8],[156,9,156,12],[156,13,156,15],[120,3,120,17],[121,3,121,17],[154,3,154,6],[154,7,154,8],[154,9,154,12],[154,13,154,15],[155,3,155,6],[155,7,155,8],[155,9,155,12],[155,13,155,15],[152,7,152,8],[152,9,152,12],[152,13,152,15],[153,7,153,8],[153,9,153,12],[153,13,153,15],[149,3,149,17],[150,3,150,17],[133,9,133,12],[139,9,139,12],[43,7,43,8],[43,9,43,12],[112,6,112,8],[113,7,113,8],[15,7,15,8],[15,9,15,12],[15,13,15,15],[15,16,15,17],[16,7,16,8],[16,9,16,12],[16,13,16,15],[16,16,16,17],[27,16,27,17],[27,7,27,8],[27,9,27,12],[27,13,27,15],[43,13,43,15],[43,16,43,17],[78,16,78,17],[80,9,80,11],[100,8,101,8],[42,7,42,8],[42,9,42,12],[42,13,42,15],[42,16,42,17],[145,9,145,12],[127,9,127,12],[17,7,17,8],[17,9,17,12],[17,13,17,15],[17,16,17,17],[30,7,30,8],[30,9,30,12],[30,13,30,15],[30,16,30,17],[28,7,28,8],[28,9,28,12],[28,13,28,15],[28,16,28,17],[29,7,29,8],[29,9,29,12],[29,13,29,15],[29,16,29,17],[26,7,26,8],[26,9,26,12],[13,7,13,8],[13,9,13,12],[13,13,13,15],[21,4,21,5],[24,4,24,17],[41,7,41,8],[41,9,41,12],[41,13,41,15],[41,16,41,17],[26,13,26,15],[26,16,26,17],[5,3,5,17],[34,4,34,5],[37,4,37,17],[75,9,75,11],[74,9,74,11],[76,9,76,11],[77,9,77,11],[78,9,78,11],[79,9,79,11],[54,13,54,15],[56,13,56,15],[58,13,58,15],[40,9,40,12],[40,13,40,15],[40,16,40,17],[74,16,74,17],[76,16,76,17],[14,9,14,12],[14,13,14,15],[14,16,14,17],[13,16,13,17],[14,7,14,8],[8,4,8,5],[11,4,11,17],[116,8,116,10],[116,15,116,16],[117,3,117,6],[117,9,117,12],[117,16,117,17],[45,3,45,17],[1,2,1,17],[110,3,110,17],[111,6,111,8],[115,3,115,17],[69,12,70,12],[69,13,70,17],[71,16,71,17],[93,13,93,15],[96,13,96,15],[99,13,99,15],[101,13,101,15],[50,13,50,15],[53,13,53,15],[39,7,39,8],[39,9,39,12],[39,13,39,15],[39,16,39,17],[40,7,40,8]]}
[null,null,"ACHTUNG: Bearbeite die Aufgaben möglichst sorgfältig !!!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anzeigen!",null,null,null,null,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ACHTUNG: Wähle die richtigen Antworten aus oder Kreuze sie an !!!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Katalognummer:  ",null,null,null,null,{"$f":"UST!Y1","v":30}]
[null,null,"FAs & BSPs: Umsatzsteuer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FAs & BSPs: Umsatzsteuer"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G112","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CG112","v":"Nettowert"}]
[null,null,"Erweiterte Kkompetenzen (EK9)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"! ! !  ",null,"Pkte","/","Ges.",null,null,{"$f":"N112","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Erweiterte Kkompetenzen (EK9)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"! ! !  ",null,"Pkte","/","Ges.",null,null,{"$f":"CN112","v":"Preis"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P112","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CP112","v":"ohne"}]
[null,null,"1.","Berechnung der Umsatzsteuer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4.","Berechnung der Umsatzsteuer"]
[null,null,null,"a.","Mit dem ermäßigten Ssteuersatz für z.B. Lebensmittel, Bücher, Zeitschriften, Honig, Eier, Zucker, …",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"e.","Mit dem ermäßigten Ssteuersatz für z.B. Lebensmittel, Bücher, Zeitschriften, Honig, Eier, Zucker, …"]
[null,null,null,null,"Wie hoch ist der Normalsteuersatz? (1 Punkt)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wie hoch ist der Normalsteuersatz? (1 Punkt)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E9=\"\",\"\",SUM(IF(Y9=UST!CY9,1,0)))","v":""},"/",1,null,null,{"$f":"E9","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"/",1,null,null,{"$f":"CE9","v":0.1}]
[]
[null,null,null,"b.","Berechne die Umsatzsteuer (USt) und den Bruttopreis für folgende Lieferungen an Letztverbraucher:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"f.","Berechne die Umsatzsteuer (USt) und den Bruttopreis für folgende Artikel:"]
[null,null,null,null,"Achtung du musst deine Ergebnisse auf 2 Kommastellen (kaufmännisch) ruden, so wie du es in Mathematik gelernt hast! ANSONSTEN WIRDT DEIN ERGEBNIS ALS FALSCH GEWERTET!!!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Achtung du musst deine Ergebnisse auf 2 Kommastellen (kaufmännisch) ruden, so wie du es in Mathematik gelernt hast! ANSONSTEN WIRDT DEIN ERGEBNIS ALS FALSCH GEWERTET!!!"]
[]
[null,null,null,null,null,null,null,"Eier",null,"Schulmilch",null,null,null,"Weizenlieferung",null,null,"Speiseeis",null,null,null,null,null,null,null,"Ust","Brutto",null,null,null,null,null,null,null,null,null,null,null,"UST_10",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eier",null,"Schulmilch",null,null,null,"Weizenlieferung",null,null,"Speiseeis",null,null,null,null,null,null,null,"Ust","Brutto"]
[null,null,null,null,null,null,null,"↓",null,"↓",null,null,null,"↓",null,null,"↓",null,null,null,null,null,null,null,{"$f":"H17","v":0},{"$f":"H18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,1,0.64999999999999991,1.5,1.28,1.25,1.62,0.48,0.37,0.6399999999999999,0.68,1.24,1.23,1.6099999999999999,0.56999999999999995,1.21,0.65999999999999992,0.64,1.41,0.77,0.49,1.39,1.2899999999999998,0.55000000000000004,1.5100000000000002,0.45999999999999996,0.72,1.7799999999999998,1.3599999999999999,1.4,0.67999999999999994,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"↓",null,"↓",null,null,null,"↓",null,null,"↓",null,null,null,null,null,null,null,{"$f":"CH17","v":2.5},{"$f":"CH18","v":27.5}]
[null,null,null,null,"Preis excl. Ust",null,null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(H14,UST_10,$Y$1+1,0))=16),\"\",VLOOKUP(H14,UST_10,$Y$1+1,0))","v":25},null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(J14,UST_10,$Y$1+1,0))=16),\"\",VLOOKUP(J14,UST_10,$Y$1+1,0))","v":5353.3},null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(L14,UST_10,$Y$1+1,0))=16),\"\",VLOOKUP(L14,UST_10,$Y$1+1,0))","v":""},null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(N14,UST_10,$Y$1+1,0))=16),\"\",VLOOKUP(N14,UST_10,$Y$1+1,0))","v":7110.8},null,null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(Q14,UST_10,$Y$1+1,0))=16),\"\",VLOOKUP(Q14,UST_10,$Y$1+1,0))","v":6.5},null,null,null,null,null,null,null,{"$f":"J17","v":0},{"$f":"J18","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"H14","v":"Eier"},36.700000000000003,{"$f":"ROUND($AM16*AN$41,1)","v":23.9},55.1,47,45.9,59.5,17.600000000000001,13.6,23.5,25,45.5,{"$f":"ROUND($AM16*AX$41,1)","v":45.1},59.1,20.9,44.4,24.2,23.5,51.7,28.3,18,51,{"$f":"ROUND($AM16*BH$41,1)","v":47.3},20.2,55.4,16.899999999999999,26.4,65.3,49.9,51.4,25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Preis excl. Ust",null,null,{"$f":"IF(OR($CW$1=\"\",TYPE(VLOOKUP(CH14,UST_10,$CW$1+1,0))=16),\"\",VLOOKUP(CH14,UST_10,$CW$1+1,0))","v":25},null,{"$f":"IF(OR($CW$1=\"\",TYPE(VLOOKUP(CJ14,UST_10,$CW$1+1,0))=16),\"\",VLOOKUP(CJ14,UST_10,$CW$1+1,0))","v":5353.3},null,{"$f":"IF(OR($CW$1=\"\",TYPE(VLOOKUP(CL14,UST_10,$CW$1+1,0))=16),\"\",VLOOKUP(CL14,UST_10,$CW$1+1,0))","v":""},null,{"$f":"IF(OR($CW$1=\"\",TYPE(VLOOKUP(CN14,UST_10,$CW$1+1,0))=16),\"\",VLOOKUP(CN14,UST_10,$CW$1+1,0))","v":7110.8},null,null,{"$f":"IF(OR($CW$1=\"\",TYPE(VLOOKUP(CQ14,UST_10,$CW$1+1,0))=16),\"\",VLOOKUP(CQ14,UST_10,$CW$1+1,0))","v":6.5},null,null,null,null,null,null,null,{"$f":"CJ17","v":535.33000000000004},{"$f":"CJ18","v":5888.63}]
[null,null,null,null,"Ust",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(H17=\"\",J17=\"\",N17=\"\",Q17=\"\"),\"\",SUM(IF(Y15=UST!CY15,1,0),IF(Y16=UST!CY16,1,0),IF(Y17=UST!CY17,1,0),IF(Y18=UST!CY18,1,0)))","v":""},"/",4,null,null,{"$f":"N17","v":0},{"$f":"N18","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"J14","v":"Schulmilch"},7872.5,5117.1000000000004,11808.8,10076.799999999999,9840.6,12753.5,3778.8,2912.8,5038.3999999999996,5353.3,9761.9,9683.2000000000007,12674.7,4487.3,9525.7000000000007,5195.8999999999996,5038.3999999999996,11100.2,6061.8,3857.5,10942.8,10155.5,4329.8999999999996,11887.5,3621.4,5668.2,14013.1,10706.6,11021.5,5353.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ust",null,null,{"$f":"ROUND(CH16*$CE$9,2)","v":2.5},null,{"$f":"ROUND(CJ16*$CE$9,2)","v":535.33000000000004},null,{"$f":"ROUND(CL16*$CE$9,2)","v":{"$error":"#VALUE!"}},null,{"$f":"ROUND(CN16*$CE$9,2)","v":711.08},null,null,{"$f":"ROUND(CQ16*$CE$9,2)","v":0.65},null,null,4,"/",4,null,null,{"$f":"CN17","v":711.08},{"$f":"CN18","v":7821.88}]
[null,null,null,null,"Preis inkl. Ust",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(H18=\"\",J18=\"\",N18=\"\",Q18=\"\"),\"\",SUM(IF(Z15=UST!CZ15,1,0),IF(Z16=UST!CZ16,1,0),IF(Z17=UST!CZ17,1,0),IF(Z18=UST!CZ18,1,0)))","v":""},"/",4,null,null,{"$f":"Q17","v":0},{"$f":"Q18","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"N14","v":"Weizenlieferung"},10457.1,6797.1,15685.7,13385.1,13071.4,16940.5,5019.3999999999996,3869.1,6692.5,7110.8,12966.8,12862.2,16835.900000000001,5960.5,12653.1,6901.7,6692.5,14744.5,8052,5124,14535.4,13489.7,5751.4,15790.2,4810.3,7529.1,18613.599999999999,14221.7,14639.9,7110.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Preis inkl. Ust",null,null,{"$f":"ROUND(SUM(CH16:CI17),2)","v":27.5},null,{"$f":"ROUND(SUM(CJ16:CK17),2)","v":5888.63},null,{"$f":"ROUND(SUM(CL16:CM17),2)","v":{"$error":"#VALUE!"}},null,{"$f":"ROUND(SUM(CN16:CP17),2)","v":7821.88},null,null,{"$f":"ROUND(SUM(CQ16:CR17),2)","v":7.15},null,null,4,"/",4,null,null,{"$f":"CQ17","v":0.65},{"$f":"CQ18","v":7.15}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q14","v":"Speiseeis"},9.6,6.2,14.4,12.3,12,15.6,4.5999999999999996,3.6,6.1,6.5,11.9,11.8,15.5,5.5,11.6,6.3,6.1,13.5,7.4,4.7,13.3,12.4,5.3,14.5,4.4000000000000004,6.9,17.100000000000001,13.1,13.4,6.5]
[null,null,null,"c.","Mit dem ermäßigten Ssteuersatz für z.B. Kino, lebende Tier, Wein , Fertigfutter, Düngemittel, …",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c.","Mit dem ermäßigten Ssteuersatz für z.B. Kino, lebende Tier, Wein , Fertigfutter, Düngemittel, …"]
[null,null,null,null,"Wie hoch ist der Normalsteuersatz? (1 Punkt)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wie hoch ist der Normalsteuersatz? (1 Punkt)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E22=\"\",\"\",SUM(IF(Y22=UST!CY22,1,0)))","v":""},"/",1,null,null,{"$f":"E22","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"/",1,null,null,{"$f":"CE22","v":0.13}]
[]
[null,null,null,"d.","Berechne die Umsatzsteuer (USt) und den Bruttopreis für folgende Artikel:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d.","Berechne die Umsatzsteuer (USt) und den Bruttopreis für folgende Artikel:"]
[null,null,null,null,"Achtung du musst deine Ergebnisse auf 2 Kommastellen (kaufmännisch) ruden, so wie du es in Mathematik gelernt hast! ANSONSTEN WIRDT DEIN ERGEBNIS ALS FALSCH GEWERTET!!!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Achtung du musst deine Ergebnisse auf 2 Kommastellen (kaufmännisch) ruden, so wie du es in Mathematik gelernt hast! ANSONSTEN WIRDT DEIN ERGEBNIS ALS FALSCH GEWERTET!!!"]
[]
[null,null,null,null,null,null,null,"Theaterkarten",null,"Christbäume",null,null,null,"Rinder",null,null,"Siloballen",null,null,null,null,null,null,null,"Ust","Brutto",null,null,null,null,null,null,null,null,null,null,null,"UST_13",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Theaterkarten",null,"Christbäume",null,null,null,"Rinder",null,null,"Siloballen",null,null,null,null,null,null,null,"Ust","Brutto"]
[null,null,null,null,null,null,null,"↓",null,"↓",null,null,null,"↓",null,null,"↓",null,null,null,null,null,null,null,{"$f":"H30","v":0},{"$f":"H31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,1,1.25,0.98,0.95,1.1000000000000001,1.08,1.05,1.02,0.88,0.92,0.94,0.93,1.04,1.03,1.01,0.97,1.06,0.96,0.89,1.21,0.87,0.99,1.19,1.1399999999999999,0.85,1.1100000000000001,0.86,0.82,1.18,1.1599999999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"↓",null,"↓",null,null,null,"↓",null,null,"↓",null,null,null,null,null,null,null,{"$f":"CH30","v":4.41},{"$f":"CH31","v":38.31}]
[null,null,null,null,"Preis excl. Ust",null,null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(H27,UST_13,$Y$1+1,0))=16),\"\",VLOOKUP(H27,UST_13,$Y$1+1,0))","v":33.9},null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(J27,UST_13,$Y$1+1,0))=16),\"\",VLOOKUP(J27,UST_13,$Y$1+1,0))","v":2741.1},null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(L27,UST_13,$Y$1+1,0))=16),\"\",VLOOKUP(L27,UST_13,$Y$1+1,0))","v":""},null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(N27,UST_13,$Y$1+1,0))=16),\"\",VLOOKUP(N27,UST_13,$Y$1+1,0))","v":1627.2},null,null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(Q27,UST_13,$Y$1+1,0))=16),\"\",VLOOKUP(Q27,UST_13,$Y$1+1,0))","v":1020.4},null,null,null,null,null,null,null,{"$f":"J30","v":0},{"$f":"J31","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"H27","v":"Theaterkarten"},49.9,{"$f":"ROUND($AM29*AN$41,1)","v":32.4},74.900000000000006,63.9,62.4,80.8,24,18.5,31.9,33.9,61.9,{"$f":"ROUND($AM29*AX$41,1)","v":61.4},80.3,28.4,60.4,32.9,31.9,70.400000000000006,38.4,24.5,69.400000000000006,{"$f":"ROUND($AM29*BH$41,1)","v":64.400000000000006},27.4,75.3,23,35.9,88.8,67.900000000000006,69.900000000000006,33.9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Preis excl. Ust",null,null,{"$f":"IF(OR($CW$1=\"\",TYPE(VLOOKUP(CH27,UST_13,$CW$1+1,0))=16),\"\",VLOOKUP(CH27,UST_13,$CW$1+1,0))","v":33.9},null,{"$f":"IF(OR($CW$1=\"\",TYPE(VLOOKUP(CJ27,UST_13,$CW$1+1,0))=16),\"\",VLOOKUP(CJ27,UST_13,$CW$1+1,0))","v":2741.1},null,{"$f":"IF(OR($CW$1=\"\",TYPE(VLOOKUP(CL27,UST_13,$CW$1+1,0))=16),\"\",VLOOKUP(CL27,UST_13,$CW$1+1,0))","v":""},null,{"$f":"IF(OR($CW$1=\"\",TYPE(VLOOKUP(CN27,UST_13,$CW$1+1,0))=16),\"\",VLOOKUP(CN27,UST_13,$CW$1+1,0))","v":1627.2},null,null,{"$f":"IF(OR($CW$1=\"\",TYPE(VLOOKUP(CQ27,UST_13,$CW$1+1,0))=16),\"\",VLOOKUP(CQ27,UST_13,$CW$1+1,0))","v":1020.4},null,null,null,null,null,null,null,{"$f":"CJ30","v":356.34},{"$f":"CJ31","v":3097.44}]
[null,null,null,null,"Ust",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(H30=\"\",J30=\"\",N30=\"\",Q30=\"\"),\"\",SUM(IF(Y28=UST!CY28,1,0),IF(Y29=UST!CY29,1,0),IF(Y30=UST!CY30,1,0),IF(Y31=UST!CY31,1,0)))","v":""},"/",4,null,null,{"$f":"N30","v":0},{"$f":"N31","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"J27","v":"Christbäume"},4031,2620.1999999999998,6046.5,5159.7,5038.8,6530.2,1934.9,1491.5,2579.8000000000002,2741.1,4998.3999999999996,4958.1000000000004,6489.9,2297.6999999999998,4877.5,2660.5,2579.8000000000002,5683.7,3103.9,1975.2,5603.1,5200,2217.1,6086.8,1854.3,2902.3,7175.2,5482.2,5643.4,2741.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ust",null,null,{"$f":"ROUND(CH29*$CE$22,2)","v":4.41},null,{"$f":"ROUND(CJ29*$CE$22,2)","v":356.34},null,{"$f":"ROUND(CL29*$CE$22,2)","v":{"$error":"#VALUE!"}},null,{"$f":"ROUND(CN29*$CE$22,2)","v":211.54},null,null,{"$f":"ROUND(CQ29*$CE$22,2)","v":132.65},null,null,4,"/",4,null,null,{"$f":"CN30","v":211.54},{"$f":"CN31","v":1838.74}]
[null,null,null,null,"Preis inkl. Ust",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(H31=\"\",J31=\"\",N31=\"\",Q31=\"\"),\"\",SUM(IF(Z28=UST!CZ28,1,0),IF(Z29=UST!CZ29,1,0),IF(Z30=UST!CZ30,1,0),IF(Z31=UST!CZ31,1,0)))","v":""},"/",4,null,null,{"$f":"Q30","v":0},{"$f":"Q31","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"N27","v":"Rinder"},2392.9,1555.4,3589.4,3062.9,2991.1,3876.5,1148.5999999999999,885.4,1531.5,1627.2,2967.2,2943.3,3852.6,1364,2895.4,1579.3,1531.5,3374,1842.5,1172.5,3326.1,3086.8,1316.1,3613.3,1100.7,1722.9,4259.3999999999996,3254.3,3350.1,1627.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Preis inkl. Ust",null,null,{"$f":"ROUND(SUM(CH29:CI30),2)","v":38.31},null,{"$f":"ROUND(SUM(CJ29:CK30),2)","v":3097.44},null,{"$f":"ROUND(SUM(CL29:CM30),2)","v":{"$error":"#VALUE!"}},null,{"$f":"ROUND(SUM(CN29:CP30),2)","v":1838.74},null,null,{"$f":"ROUND(SUM(CQ29:CR30),2)","v":1153.05},null,null,4,"/",4,null,null,{"$f":"CQ30","v":132.65},{"$f":"CQ31","v":1153.05}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q27","v":"Siloballen"},1500.6,975.4,2250.9,1920.8,1875.8,2431,720.3,555.20000000000005,960.4,1020.4,1860.7,1845.7,2416,855.3,1815.7,990.4,960.4,2115.8000000000002,1155.5,735.3,2085.8000000000002,1935.8,825.3,2265.9,690.3,1080.4000000000001,2671.1,2040.8,2100.8000000000002,1020.4]
[null,null,null,"d.","Mit dem Normalsteuersatz",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a.","Mit dem Normalsteuersatz"]
[null,null,null,null,"Wie hoch ist der Normalsteuersatz? (1 Punkt)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wie hoch ist der Normalsteuersatz? (1 Punkt)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E35=\"\",\"\",SUM(IF(Y35=UST!CY35,1,0)))","v":""},"/",1,null,null,{"$f":"E35","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"/",1,null,null,{"$f":"CE35","v":0.2}]
[]
[null,null,null,"e.","Berechne die Umsatzsteuer (USt) und den Bruttopreis für folgende Artikel:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b.","Berechne die Umsatzsteuer (USt) und den Bruttopreis für folgende Artikel:"]
[null,null,null,null,"Achtung du musst deine Ergebnisse auf 2 Kommastellen (kaufmännisch) ruden, so wie du es in Mathematik gelernt hast! ANSONSTEN WIRDT DEIN ERGEBNIS ALS FALSCH GEWERTET!!!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Achtung du musst deine Ergebnisse auf 2 Kommastellen (kaufmännisch) ruden, so wie du es in Mathematik gelernt hast! ANSONSTEN WIRDT DEIN ERGEBNIS ALS FALSCH GEWERTET!!!"]
[]
[null,null,null,null,null,null,null,"Sonnenbrille",null,"Pullover",null,null,null,"Tennisbälle",null,null,"Baustoffe",null,null,null,null,null,null,null,"Ust","Brutto",null,null,null,null,null,null,null,null,null,null,null,"UST_20",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sonnenbrille",null,"Pullover",null,null,null,"Tennisbälle",null,null,"Baustoffe",null,null,null,null,null,null,null,"Ust","Brutto"]
[null,null,null,null,null,null,null,"↓",null,"↓",null,null,null,"↓",null,null,"↓",null,null,null,null,null,null,null,{"$f":"H43","v":0},{"$f":"H44","v":0},null,null,null,null,null,null,null,null,null,null,null,null,1,0.64999999999999991,1.5,1.28,1.25,1.62,0.48,0.37,0.6399999999999999,0.68,1.24,1.23,1.6099999999999999,0.56999999999999995,1.21,0.65999999999999992,0.64,1.41,0.77,0.49,1.39,1.2899999999999998,0.55000000000000004,1.5100000000000002,0.45999999999999996,0.72,1.7799999999999998,1.3599999999999999,1.4,0.67999999999999994,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"↓",null,"↓",null,null,null,"↓",null,null,"↓",null,null,null,null,null,null,null,{"$f":"CH43","v":22.62},{"$f":"CH44","v":135.72}]
[null,null,null,null,"Preis excl. Ust",null,null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(H40,UST_20,$Y$1+1,0))=16),\"\",VLOOKUP(H40,UST_20,$Y$1+1,0))","v":113.1},null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(J40,UST_20,$Y$1+1,0))=16),\"\",VLOOKUP(J40,UST_20,$Y$1+1,0))","v":60},null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(L40,UST_20,$Y$1+1,0))=16),\"\",VLOOKUP(L40,UST_20,$Y$1+1,0))","v":""},null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(N40,UST_20,$Y$1+1,0))=16),\"\",VLOOKUP(N40,UST_20,$Y$1+1,0))","v":19},null,null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(Q40,UST_20,$Y$1+1,0))=16),\"\",VLOOKUP(Q40,UST_20,$Y$1+1,0))","v":591.79999999999995},null,null,null,null,null,null,null,{"$f":"J43","v":0},{"$f":"J44","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"H40","v":"Sonnenbrille"},166.3,{"$f":"ROUND($AM42*AN$41,1)","v":108.1},249.5,212.9,207.9,269.39999999999998,79.8,61.5,106.4,113.1,206.2,{"$f":"ROUND($AM42*AX$41,1)","v":204.5},267.7,94.8,201.2,109.8,106.4,234.5,128.1,81.5,231.2,{"$f":"ROUND($AM42*BH$41,1)","v":214.5},91.5,251.1,76.5,119.7,296,226.2,232.8,113.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Preis excl. Ust",null,null,{"$f":"IF(OR($CW$1=\"\",TYPE(VLOOKUP(CH40,UST_20,$CW$1+1,0))=16),\"\",VLOOKUP(CH40,UST_20,$CW$1+1,0))","v":113.1},null,{"$f":"IF(OR($CW$1=\"\",TYPE(VLOOKUP(CJ40,UST_20,$CW$1+1,0))=16),\"\",VLOOKUP(CJ40,UST_20,$CW$1+1,0))","v":60},null,{"$f":"IF(OR($CW$1=\"\",TYPE(VLOOKUP(CL40,UST_20,$CW$1+1,0))=16),\"\",VLOOKUP(CL40,UST_20,$CW$1+1,0))","v":""},null,{"$f":"IF(OR($CW$1=\"\",TYPE(VLOOKUP(CN40,UST_20,$CW$1+1,0))=16),\"\",VLOOKUP(CN40,UST_20,$CW$1+1,0))","v":19},null,null,{"$f":"IF(OR($CW$1=\"\",TYPE(VLOOKUP(CQ40,UST_20,$CW$1+1,0))=16),\"\",VLOOKUP(CQ40,UST_20,$CW$1+1,0))","v":591.79999999999995},null,null,null,null,null,null,null,{"$f":"CJ43","v":12},{"$f":"CJ44","v":72}]
[null,null,null,null,"Ust",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(H43=\"\",J43=\"\",N43=\"\",Q43=\"\"),\"\",SUM(IF(Y41=UST!CY41,1,0),IF(Y42=UST!CY42,1,0),IF(Y43=UST!CY43,1,0),IF(Y44=UST!CY44,1,0)))","v":""},"/",4,null,null,{"$f":"N43","v":0},{"$f":"N44","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"J40","v":"Pullover"},88.2,57.3,132.30000000000001,112.9,110.3,142.9,42.3,32.6,56.4,60,109.4,108.5,142,50.3,106.7,58.2,56.4,124.4,67.900000000000006,43.2,122.6,113.8,48.5,133.19999999999999,40.6,63.5,157,120,123.5,60,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ust",null,null,{"$f":"ROUND(CH42*$CE$35,2)","v":22.62},null,{"$f":"ROUND(CJ42*$CE$35,2)","v":12},null,{"$f":"ROUND(CL42*$CE$35,2)","v":{"$error":"#VALUE!"}},null,{"$f":"ROUND(CN42*$CE$35,2)","v":3.8},null,null,{"$f":"ROUND(CQ42*$CE$35,2)","v":118.36},null,null,4,"/",4,null,null,{"$f":"CN43","v":3.8},{"$f":"CN44","v":22.8}]
[null,null,null,null,"Preis inkl. Ust",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(H44=\"\",J44=\"\",N44=\"\",Q44=\"\"),\"\",SUM(IF(Z41=UST!CZ41,1,0),IF(Z42=UST!CZ42,1,0),IF(Z43=UST!CZ43,1,0),IF(Z44=UST!CZ44,1,0)))","v":""},"/",4,null,null,{"$f":"Q43","v":0},{"$f":"Q44","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"N40","v":"Tennisbälle"},28,18.2,42,35.799999999999997,35,45.4,13.4,10.4,17.899999999999999,19,34.700000000000003,34.4,45.1,16,33.9,18.5,17.899999999999999,39.5,21.6,13.7,38.9,36.1,15.4,42.3,12.9,20.2,49.8,38.1,39.200000000000003,19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Preis inkl. Ust",null,null,{"$f":"ROUND(SUM(CH42:CI43),2)","v":135.72},null,{"$f":"ROUND(SUM(CJ42:CK43),2)","v":72},null,{"$f":"ROUND(SUM(CL42:CM43),2)","v":{"$error":"#VALUE!"}},null,{"$f":"ROUND(SUM(CN42:CP43),2)","v":22.8},null,null,{"$f":"ROUND(SUM(CQ42:CR43),2)","v":710.16},null,null,4,"/",4,null,null,{"$f":"CQ43","v":118.36},{"$f":"CQ44","v":710.16}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q40","v":"Baustoffe"},870.3,565.70000000000005,1305.5,1114,1087.9000000000001,1409.9,417.7,322,557,591.79999999999995,1079.2,1070.5,1401.2,496.1,1053.0999999999999,574.4,557,1227.0999999999999,670.1,426.4,1209.7,1122.7,478.7,1314.2,400.3,626.6,1549.1,1183.5999999999999,1218.4000000000001,591.79999999999995]
[null,null,"2.","Rahme auf folgenden Belegen den Nettobetrag rot, den Umsatzsteuersatz und den Umsatzsteuerbetrag grün und den Bruttobetrag blau ein … ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q118","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.","Rahme auf folgenden Belegen den Nettobetrag rot, den Umsatzsteuersatz und den Umsatzsteuerbetrag grün und den Bruttobetrag blau ein … ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CQ118","v":"Unternehmens"}]
[null,null,null,"a.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Merkur_DB",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,null,null,null,null,null,null,null,"…","und schreibe die jeweiligen Beträge aus dem Beleg auf: (5 Punkte)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1.25,0.98,0.95,1.1000000000000001,1.08,1.05,1.02,0.88,0.92,0.94,0.93,1.04,1.03,1.01,0.97,1.06,0.96,0.89,1.21,0.87,0.99,1.19,1.1399999999999999,0.85,1.1100000000000001,0.86,0.82,1.18,1.1599999999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…","und schreibe die jeweiligen Beträge aus dem Beleg auf: (5 Punkte)"]
[null,null,null,null,null,null,null,null,null,"Nettobetrag",null,null,null,null,null,null,null,null,null,{"$f":"IF(N51=\"\",\"\",SUM(IF(Y51=UST!CY51,1,0)))","v":""},"/",1,null,null,{"$f":"N51","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Fanta",{"$f":"SUM(AM55:AM56)","v":6.24},{"$f":"SUM(AN55:AN56)","v":7.8},6.1199999999999992,5.8800000000000008,6.84,6.72,6.6,6.3599999999999994,5.52,5.76,5.8800000000000008,5.76,6.48,6.48,6.3599999999999994,6,6.6,6,5.52,7.56,5.4,6.1199999999999992,7.44,7.08,5.28,6.96,5.4,5.16,7.3199999999999994,7.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nettobetrag",null,null,null,{"$f":"SUM(IF(OR($Y$1=\"\",TYPE(VLOOKUP(AL58,Merkur_DB,$Y$1+1,0))=16),22.8,VLOOKUP(AL58,Merkur_DB,$Y$1+1,0)),IF(OR($Y$1=\"\",TYPE(VLOOKUP(AL56,Merkur_DB,$Y$1+1,0))=16),22.8,VLOOKUP(AL56,Merkur_DB,$Y$1+1,0)))","v":7},null,null,null,null,null,1,"/",1,null,null,{"$f":"CN51","v":7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Handsemmeln",{"$f":"SUM(AM57:AM58)","v":0.99},{"$f":"SUM(AN57:AN58)","v":1.2100000000000002},0.99,0.99,1.1000000000000001,1.1000000000000001,0.99,0.99,0.88000000000000012,0.88000000000000012,0.88000000000000012,0.88000000000000012,0.99,0.99,0.99,0.99,1.1000000000000001,0.99,0.88000000000000012,1.2100000000000002,0.88000000000000012,0.99,1.2100000000000002,1.1000000000000001,0.88000000000000012,1.1000000000000001,0.88000000000000012,0.76999999999999991,1.2100000000000002,1.1000000000000001]
[null,null,null,null,null,null,null,null,null,"Im Beleg angewandte Umsatzsteuersätze",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summe",{"$f":"SUM(AM55:AM58)","v":7.23},{"$f":"SUM(AN55:AN58)","v":9.01},{"$f":"SUM(AO55:AO58)","v":7.1099999999999994},6.870000000000001,7.9399999999999995,7.8199999999999994,7.59,7.35,6.3999999999999995,6.64,6.7600000000000007,6.64,7.4700000000000006,7.4700000000000006,7.35,6.99,7.6999999999999993,6.99,6.3999999999999995,8.77,6.28,7.1099999999999994,8.65,8.18,6.16,8.0599999999999987,6.28,5.9300000000000006,8.5299999999999994,8.3000000000000007,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Im Beleg angewandte Umsatzsteuersätze"]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(AL51,Merkur_DB,$Y$1+1,0))=16),22.8,VLOOKUP(AL51,Merkur_DB,$Y$1+1,0))","v":7.2},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N54=\"\",\"\",IF(COUNTIF($Y$54:$Y$55,N54)>0,1/COUNTIF($N$54:$P$55,N54),0))","v":""},"/",1,null,null,{"$f":"CY54","v":0.1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,null,null,null,null,null,1,"/",1,null,null,{"$f":"CN54","v":0.1}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(AL52,Merkur_DB,$Y$1+1,0))=16),22.8,VLOOKUP(AL52,Merkur_DB,$Y$1+1,0))","v":1.1000000000000001},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N55=\"\",\"\",IF(COUNTIF($Y$54:$Y$55,N55)>0,1/COUNTIF($N$54:$P$55,N55),0))","v":""},"/",1,null,null,{"$f":"CY55","v":0.2},null,null,null,null,null,null,null,null,null,null,null,null,"Ust20",{"$f":"AM56*20%","v":1.04},1.3,1.02,0.98000000000000009,1.1400000000000001,1.1199999999999999,1.1000000000000001,1.06,0.91999999999999993,0.96,0.98000000000000009,0.96,1.08,1.08,1.06,1,1.1000000000000001,1,0.91999999999999993,1.26,0.9,1.02,1.2400000000000002,1.1800000000000002,0.88000000000000012,1.1599999999999999,0.9,0.86,1.22,1.2000000000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,null,null,null,null,null,1,"/",1,null,null,{"$f":"CN55","v":0.2}]
[null,null,null,null,null,null,null,null,null,"Umsatzsteuerbetrag",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Netto20",5.2,{"$f":"ROUND($AM56*AN$50,1)","v":6.5},5.0999999999999996,4.9000000000000004,5.7,5.6,5.5,5.3,4.5999999999999996,4.8,4.9000000000000004,4.8,5.4,5.4,5.3,5,5.5,5,4.5999999999999996,6.3,4.5,5.0999999999999996,6.2,5.9,4.4000000000000004,5.8,4.5,4.3,6.1,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Umsatzsteuerbetrag"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N57=\"\",\"\",SUM(IF(Y57=UST!CY57,1,0)))","v":""},"/",1,null,null,{"$f":"N57","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Ust10",{"$f":"AM58*10%","v":9.0000000000000011E-2},{"$f":"AN58*10%","v":0.11000000000000001},{"$f":"AO58*10%","v":9.0000000000000011E-2},9.0000000000000011E-2,0.1,0.1,9.0000000000000011E-2,9.0000000000000011E-2,8.0000000000000016E-2,8.0000000000000016E-2,8.0000000000000016E-2,8.0000000000000016E-2,9.0000000000000011E-2,9.0000000000000011E-2,9.0000000000000011E-2,9.0000000000000011E-2,0.1,9.0000000000000011E-2,8.0000000000000016E-2,0.11000000000000001,8.0000000000000016E-2,9.0000000000000011E-2,0.11000000000000001,0.1,8.0000000000000016E-2,0.1,8.0000000000000016E-2,6.9999999999999993E-2,0.11000000000000001,0.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(OR($Y$1=\"\",TYPE(VLOOKUP(AL57,Merkur_DB,$Y$1+1,0))=16),22.8,VLOOKUP(AL57,Merkur_DB,$Y$1+1,0)),IF(OR($Y$1=\"\",TYPE(VLOOKUP(AL55,Merkur_DB,$Y$1+1,0))=16),22.8,VLOOKUP(AL55,Merkur_DB,$Y$1+1,0)))","v":1.3000000000000003},null,null,null,null,null,1,"/",1,null,null,{"$f":"CN57","v":1.3000000000000003}]
[null,null,null,null,null,null,null,"EUR",{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(AL53,Merkur_DB,$Y$1+1,0))=16),22.8,VLOOKUP(AL53,Merkur_DB,$Y$1+1,0))","v":8.3000000000000007},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Netto10",0.9,{"$f":"ROUND($AM58*AN$50,1)","v":1.1000000000000001},0.9,0.9,1,1,0.9,0.9,0.8,0.8,0.8,0.8,0.9,0.9,0.9,0.9,1,0.9,0.8,1.1000000000000001,0.8,0.9,1.1000000000000001,1,0.8,1,0.8,0.7,1.1000000000000001,1]
[null,null,null,null,null,null,null,null,null,"Bruttobetrag",null,null,null,null,null,null,null,null,null,{"$f":"IF(N59=\"\",\"\",SUM(IF(Y59=UST!CY59,1,0)))","v":""},"/",1,null,null,{"$f":"N59","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bruttobetrag",null,null,null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(AL53,Merkur_DB,$Y$1+1,0))=16),22.8,VLOOKUP(AL53,Merkur_DB,$Y$1+1,0))","v":8.3000000000000007},null,null,null,null,null,1,"/",1,null,null,{"$f":"CN59","v":8.3000000000000007}]
[null,null,null,null,null,null,null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(AL57,Merkur_DB,$Y$1+1,0))=16),22.8,VLOOKUP(AL57,Merkur_DB,$Y$1+1,0))","v":0.1},{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(AL58,Merkur_DB,$Y$1+1,0))=16),22.8,VLOOKUP(AL58,Merkur_DB,$Y$1+1,0))","v":1}]
[null,null,null,null,null,null,null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(AL55,Merkur_DB,$Y$1+1,0))=16),22.8,VLOOKUP(AL55,Merkur_DB,$Y$1+1,0))","v":1.2000000000000002},{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(AL56,Merkur_DB,$Y$1+1,0))=16),22.8,VLOOKUP(AL56,Merkur_DB,$Y$1+1,0))","v":6}]
[]
[]
[]
[]
[]
[null,null,null,"b.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"…","und schreibe die jeweiligen Beträge aus dem Beleg heraus: (4 Punkte)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Radler_DB",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…","und schreibe die jeweiligen Beträge aus dem Beleg heraus: (4 Punkte)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1.25,0.98,0.95,1.1000000000000001,1.08,1.05,1.02,0.88,0.92,0.94,0.93,1.04,1.03,1.01,0.97,1.06,0.96,0.89,1.21,0.87,0.99,1.19,1.1399999999999999,0.85,1.1100000000000001,0.86,0.82,1.18,1.1599999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Nettobetrag",null,null,null,null,null,{"$f":"IF(Q72=\"\",\"\",SUM(IF(Y72=UST!CY72,1,0)))","v":""},"/",1,null,null,{"$f":"Q72","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Fleecepullover \"Trend\"",80,{"$f":"ROUND($AM72*AN$71,0)","v":100},78,76,88,86,84,82,70,74,75,{"$f":"ROUND($AM72*AX$71,0)","v":74},83,82,81,78,85,77,71,97,70,{"$f":"ROUND($AM72*BH$71,0)","v":79},95,91,68,89,69,66,94,93,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nettobetrag",null,null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(AL75,Radler_DB,$Y$1+1,0))=16),22.8,VLOOKUP(AL75,Radler_DB,$Y$1+1,0))","v":281.7},null,null,1,"/",1,null,null,{"$f":"CQ72","v":281.7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Doppeljacke \"Etremfrost\"",190,238,186,181,209,205,200,194,167,175,179,177,198,196,192,184,201,182,169,230,165,188,226,217,162,211,163,156,224,220]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Im Beleg angewandter Umsatzsteuersatz",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rabatt",{"$f":"-SUM(AM72,AM73)*10%","v":-27},{"$f":"-SUM(AN72,AN73)*10%","v":-33.800000000000004},-26.400000000000002,-25.700000000000003,-29.700000000000003,-29.1,-28.400000000000002,-27.6,-23.700000000000003,-24.900000000000002,-25.400000000000002,-25.1,-28.1,-27.8,-27.3,-26.200000000000003,-28.6,-25.900000000000002,-24,-32.700000000000003,-23.5,-26.700000000000003,-32.1,-30.8,-23,-30,-23.200000000000003,-22.200000000000003,-31.8,-31.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Im Beleg angewandter Umsatzsteuersatz"]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(AL72,Radler_DB,$Y$1+1,0))=16),22.8,VLOOKUP(AL72,Radler_DB,$Y$1+1,0))","v":93},{"$f":"I75","v":93},null,null,null,null,null,null,null,null,null,{"$f":"IF(Q75=\"\",\"\",SUM(IF(Y75=UST!CY75,1,0)))","v":""},"/",1,null,null,{"$f":"Q75","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Summe",{"$f":"SUM(AM72:AM74)","v":243},{"$f":"SUM(AN72:AN74)","v":304.2},237.6,231.3,267.3,261.89999999999998,255.6,248.4,213.3,224.1,228.6,225.9,252.9,250.2,245.7,235.8,257.39999999999998,233.1,216,294.3,211.5,240.3,288.89999999999998,277.2,207,270,208.8,199.8,286.2,281.7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,null,null,1,"/",1,null,null,{"$f":"CQ75","v":0.2}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(AL73,Radler_DB,$Y$1+1,0))=16),22.8,VLOOKUP(AL73,Radler_DB,$Y$1+1,0))","v":220},{"$f":"I76","v":220}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(AL74,Radler_DB,$Y$1+1,0))=16),22.8,VLOOKUP(AL74,Radler_DB,$Y$1+1,0))","v":-31.3},null,null,null,"Umsatzsteuerbetrag",null,null,null,null,null,{"$f":"IF(Q77=\"\",\"\",SUM(IF(Y77=UST!CY77,1,0)))","v":""},"/",1,null,null,{"$f":"Q77","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Ust",{"$f":"AM75*20%","v":48.6},{"$f":"AN75*20%","v":60.84},47.52,46.260000000000005,53.460000000000008,52.379999999999995,51.120000000000005,49.680000000000007,42.660000000000004,44.82,45.72,45.180000000000007,50.580000000000005,50.04,49.14,47.160000000000004,51.48,46.620000000000005,43.2,58.860000000000007,42.300000000000004,48.06,57.78,55.44,41.400000000000006,54,41.760000000000005,39.960000000000008,57.24,56.34,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Umsatzsteuerbetrag",null,null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(AL77,Radler_DB,$Y$1+1,0))=16),22.8,VLOOKUP(AL77,Radler_DB,$Y$1+1,0))","v":56.34},null,null,1,"/",1,null,null,{"$f":"CQ77","v":56.34}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(AL75,Radler_DB,$Y$1+1,0))=16),22.8,VLOOKUP(AL75,Radler_DB,$Y$1+1,0))","v":281.7},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bruttobetrag",{"$f":"SUM(AM75:AM77)","v":291.60000000000002},{"$f":"SUM(AN75:AN77)","v":365.03999999999996},285.12,277.56,320.76,314.27999999999997,306.72000000000003,298.08000000000004,255.96,268.92,274.32,271.08000000000004,303.48,300.24,294.83999999999997,282.96000000000004,308.88,279.72000000000003,259.2,353.16,253.8,288.36,346.67999999999995,332.64,248.4,324,250.56,239.76000000000002,343.44,338.03999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Bruttobetrag",null,null,null,null,null,{"$f":"IF(Q79=\"\",\"\",SUM(IF(Y79=UST!CY79,1,0)))","v":""},"/",1,null,null,{"$f":"Q79","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bruttobetrag",null,null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(AL78,Radler_DB,$Y$1+1,0))=16),22.8,VLOOKUP(AL78,Radler_DB,$Y$1+1,0))","v":338.03999999999996},null,null,1,"/",1,null,null,{"$f":"CQ79","v":338.03999999999996}]
[null,null,null,null,null,null,null,{"$f":"J78","v":281.7},{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(AL77,Radler_DB,$Y$1+1,0))=16),22.8,VLOOKUP(AL77,Radler_DB,$Y$1+1,0))","v":56.34},{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(AL78,Radler_DB,$Y$1+1,0))=16),22.8,VLOOKUP(AL78,Radler_DB,$Y$1+1,0))","v":338.03999999999996}]
[null,null,null,null,null,null,null,null,null,{"$f":"J80","v":338.03999999999996}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"c.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a."]
[]
[]
[null,null,null,null,null,null,null,null,"…","und schreibe die jeweiligen Beträge aus dem Beleg auf: (4 Punkte)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…","und schreibe die jeweiligen Beträge aus dem Beleg auf: (4 Punkte)"]
[null,null,null,null,null,null,null,null,null,"Nettobetrag",null,null,null,null,null,null,null,null,null,{"$f":"IF(N94=\"\",\"\",SUM(IF(Y94=UST!CY94,1,0)))","v":""},"/",1,null,null,{"$f":"N94","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nettobetrag",null,null,null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(AL104,Libro_DB,$Y$1+1,0))=16),111.6,VLOOKUP(AL104,Libro_DB,$Y$1+1,0))","v":156.1},null,null,null,null,null,1,"/",1,null,null,{"$f":"CN94","v":156.1}]
[]
[null,null,null,null,null,null,null,null,null,"Im Beleg angewandter Umsatzsteuersatz",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Im Beleg angewandter Umsatzsteuersatz"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N97=\"\",\"\",SUM(IF(Y97=UST!CY97,1,0)))","v":""},"/",1,null,null,{"$f":"N97","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Libro_DB",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,null,null,null,null,null,1,"/",1,null,null,{"$f":"CN97","v":0.2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1.25,0.98,0.95,1.1000000000000001,1.08,1.05,1.02,0.88,0.92,0.94,0.93,1.04,1.03,1.01,0.97,1.06,0.96,0.89,1.21,0.87,0.99,1.19,1.1399999999999999,0.85,1.1100000000000001,0.86,0.82,1.18,1.1599999999999999]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(AL99,Libro_DB,$Y$1+1,0))=16),22.8,VLOOKUP(AL99,Libro_DB,$Y$1+1,0))","v":47.419999999999987},"Umsatzsteuerbetrag",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Druckepatrone schwarz",{"$f":"AM101-AM100","v":40.919999999999987},51.16,40.08,38.880000000000024,45.02000000000001,44.28000000000003,42.960000000000008,41.760000000000019,35.980000000000018,37.56,38.400000000000006,38.040000000000006,42.599999999999994,42.11999999999999,41.280000000000015,39.72,43.439999999999984,39.239999999999995,36.459999999999994,49.580000000000013,35.619999999999976,40.56,48.739999999999981,46.580000000000013,34.78,45.379999999999995,35.260000000000005,33.580000000000013,48.259999999999991,47.419999999999987,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Umsatzsteuerbetrag"]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(AL100,Libro_DB,$Y$1+1,0))=16),111.6,VLOOKUP(AL100,Libro_DB,$Y$1+1,0))","v":139.9},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N100=\"\",\"\",SUM(IF(Y100=UST!CY100,1,0)))","v":""},"/",1,null,null,{"$f":"N100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Digicam Everest",120.6,{"$f":"ROUND($AM100*AN$98,1)","v":150.80000000000001},118.2,114.6,132.69999999999999,130.19999999999999,126.6,123,106.1,111,113.4,112.2,125.4,124.2,121.8,117,127.8,115.8,107.3,145.9,104.9,119.4,143.5,137.5,102.5,133.9,103.7,98.9,142.30000000000001,139.9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(AL103,Libro_DB,$Y$1+1,0))=16),111.6,VLOOKUP(AL103,Libro_DB,$Y$1+1,0))","v":31.22},null,null,null,null,null,1,"/",1,null,null,{"$f":"CN100","v":31.22}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(AL101,Libro_DB,$Y$1+1,0))=16),111.6,VLOOKUP(AL101,Libro_DB,$Y$1+1,0))","v":187.32},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summe",{"$f":"AM103+AM104","v":161.51999999999998},201.96,158.28,153.48000000000002,177.72,174.48000000000002,169.56,164.76000000000002,142.08000000000001,148.56,151.80000000000001,150.24,168,166.32,163.08000000000001,156.72,171.23999999999998,155.04,143.76,195.48000000000002,140.51999999999998,159.96,192.23999999999998,184.08,137.28,179.28,138.96,132.48000000000002,190.56,187.32]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(AL102,Libro_DB,$Y$1+1,0))=16),111.6,TEXT(VLOOKUP(AL102,Libro_DB,$Y$1+1,0),\"# ##0,00\"))","v":111.6},"Bruttobetrag",null,null,null,null,null,null,null,null,null,{"$f":"IF(N102=\"\",\"\",SUM(IF(Y102=UST!CY102,1,0)))","v":""},"/",1,null,null,{"$f":"N102","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bruttobetrag",null,null,null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(AL101,Libro_DB,$Y$1+1,0))=16),111.6,VLOOKUP(AL101,Libro_DB,$Y$1+1,0))","v":187.32},null,null,null,null,null,1,"/",1,null,null,{"$f":"CN102","v":187.32}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ust",{"$f":"AM104*20%","v":26.92},33.660000000000004,26.380000000000003,25.580000000000002,29.62,29.080000000000002,28.260000000000005,27.460000000000004,23.680000000000003,24.76,25.3,25.040000000000003,28,27.72,27.180000000000003,26.12,28.54,25.84,23.96,32.580000000000005,23.42,26.660000000000004,32.04,30.680000000000003,22.880000000000003,29.880000000000003,23.16,22.080000000000002,31.760000000000005,31.22]
[null,null,null,null,null,null,null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(AL104,Libro_DB,$Y$1+1,0))=16),111.6,VLOOKUP(AL104,Libro_DB,$Y$1+1,0))","v":156.1},{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(AL103,Libro_DB,$Y$1+1,0))=16),111.6,VLOOKUP(AL103,Libro_DB,$Y$1+1,0))","v":31.22},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Netto",134.6,{"$f":"ROUND($AM104*AN$98,1)","v":168.3},131.9,127.9,148.1,145.4,141.30000000000001,137.30000000000001,118.4,123.8,126.5,125.2,140,138.6,135.9,130.6,142.69999999999999,129.19999999999999,119.8,162.9,117.1,133.30000000000001,160.19999999999999,153.4,114.4,149.4,115.8,110.4,158.80000000000001,156.1]
[]
[]
[]
[]
[]
[]
[null,null,"3.","Umsatzsteuer: Erkläre die (fehlenden) Begriffe \"Netto\" bzw. \"Brutto\" in der folgenden Aussage zum Thema Umsatzsteuer! (7 Punkte)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G113","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.","Umsatzsteuer: Ergänze die fehlenden Begriffe in der folgenden Aussage zum Thema Umsatzsteuer!\n(7 Punkte)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CG113","v":"Bruttowert"}]
[null,null,null,"Unter dem",null,null,null,null,null," versteht man den",null,null,null,null,null,null," Umsatzsteuer.",null,null,{"$f":"IF(AND(G112=\"\",N112=\"\",P112=\"\"),\"\",SUM(IF(Y3=UST!CY3,1,0),IF(Y4=UST!CY4,1,0),IF(Y5=UST!CY5,1,0)))","v":""},"/",3,null,null,{"$f":"N113","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unter dem",null,null,"Nettowert",null,null," versteht man den",null,null,null,"Preis",null,"ohne"," Umsatzsteuer.",null,null,3,"/",3,null,null,{"$f":"CN113","v":"Preis"}]
[null,null,null,"Unter dem",null,null,null,null,null," versteht man den",null,null,null,null,null,null," Umsatzsteuer (10%,",null,null,{"$f":"IF(AND(G113=\"\",N113=\"\",P113=\"\"),\"\",SUM(IF(Y111=UST!CY111,1,0),IF(Y112=UST!CY112,1,0),IF(Y113=UST!CY113,1,0)))","v":""},"/",3,null,null,{"$f":"P113","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unter dem",null,null,"Bruttowert",null,null," versteht man den",null,null,null,"Preis",null,"mit"," Umsatzsteuer (10%,",null,null,3,"/",3,null,null,{"$f":"CP113","v":"mit"}]
[null,null,null,"13% oder 20% des",null,null,null,null,null,").",null,null,null,null,null,null,null,null,null,{"$f":"IF(H114=\"\",\"\",SUM(IF(Y114=UST!CY114,1,0)))","v":""},"/",1,null,null,{"$f":"H114","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13% oder 20% des",null,null,null,"Nettowertes",null,").",null,null,null,null,null,null,null,null,null,1,"/",1,null,null,{"$f":"CH114","v":"Nettowertes"}]
[]
[null,null,"4.","Umsatzsteuer: Ergänze die fehlenden Begriffe in der folgenden  Aussage zum Thema Umsatzsteuer!\n(5 Punkte)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.","Umsatzsteuer: Ergänze die fehlenden Begriffe in der folgenden  Aussage zum Thema Umsatzsteuer!\n(5 Punkte)"]
[null,null,null,"Grundsätzlich werden alle",null,null,null,null,null,null,null," und sonstigen",null,null,null,null,null,", die ein",null,{"$f":"IF(AND(I117=\"\",P117=\"\"),\"\",SUM(IF(Y117=UST!CY117,1,0),IF(Y118=UST!CY118,1,0)))","v":""},"/",2,null,null,{"$f":"I117","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grundsätzlich werden alle",null,null,null,null,"Lieferungen",null,null," und sonstigen",null,null,null,"Leistungen",null,", die ein",null,2,"/",2,null,null,{"$f":"CI117","v":"Lieferungen"}]
[null,null,null,null,null,null,null," in Österreich gegen",null,null,null,null,null," im Rahmen seines",null,null,null,null,null,{"$f":"IF(AND(D118=\"\",J118=\"\",Q118=\"\"),\"\",SUM(IF(Y119=UST!CY119,1,0),IF(Y120=UST!CY120,1,0),IF(Y46=UST!CY46,1,0)))","v":""},"/",3,null,null,{"$f":"P117","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unternehmer",null,null,null," in Österreich gegen",null,"Bezahlung",null,null,null," im Rahmen seines",null,null,"Unternehmens",null,null,3,"/",3,null,null,{"$f":"CP117","v":"Leistungen"}]
[null,null,null,"erbringt, besteuert.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D118","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"erbringt, besteuert.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CD118","v":"Unternehmer"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J118","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CJ118","v":"Bezahlung"}]
[null,null,"5.","Berechne für die folgenden Preise den Umsatzsteuerbetrag mit dem Normalsteuersatz von 20%.\n(4 Punkte)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6.","Berechne für die folgenden Preise den Umsatzsteuerbetrag mit dem Normalsteuersatz von 20%.\n(4 Punkte)"]
[null,null,null,"Achtung du musst deine Ergebnisse auf 2 Kommastellen (kaufmännisch) ruden, so wie du es in Mathematik gelernt hast! ANSONSTEN WIRDT DEIN ERGEBNIS ALS FALSCH GEWERTET!!!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Achtung du musst deine Ergebnisse auf 2 Kommastellen (kaufmännisch) ruden, so wie du es in Mathematik gelernt hast! ANSONSTEN WIRDT DEIN ERGEBNIS ALS FALSCH GEWERTET!!!"]
[]
[null,null,null,"a.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d."]
[]
[]
[]
[null,null,null,null,null,null,null,null,"USst =",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J128=\"\",\"\",SUM(IF(Y128=UST!CY128,1,0)))","v":""},"/",1,null,{"$f":"UST!CX128","v":46.559999999999995},{"$f":"J128","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USst =",{"$f":"ROUND($CX128*CN$153/(100%+CN$153),2)","v":7.76},null,null,null,null,null,null,null,null,null,1,"/",1,null,{"$f":"A177","v":46.559999999999995},{"$f":"CJ128","v":7.76}]
[]
[null,null,null,"b.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a."]
[]
[]
[]
[null,null,null,null,null,null,null,null,"USst =",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J134=\"\",\"\",SUM(IF(Y134=UST!CY134,1,0)))","v":""},"/",1,null,{"$f":"UST!CX134","v":24.36},{"$f":"J134","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USst =",{"$f":"ROUND($CX134*CN$153/(100%+CN$153),2)","v":4.0599999999999996},null,null,null,null,null,null,null,null,null,1,"/",1,null,{"$f":"A168","v":24.36},{"$f":"CJ134","v":4.0599999999999996}]
[]
[null,null,null,"c.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b."]
[]
[]
[]
[null,null,null,null,null,null,null,null,"USst =",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J140=\"\",\"\",SUM(IF(Y140=UST!CY140,1,0)))","v":""},"/",1,null,{"$f":"UST!CX140","v":330},{"$f":"J140","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USst =",{"$f":"ROUND($CX140*CN$153/(100%+CN$153),2)","v":55},null,null,null,null,null,null,null,null,null,1,"/",1,null,{"$f":"A171","v":330},{"$f":"CJ140","v":55}]
[]
[null,null,null,"d.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c."]
[]
[]
[]
[null,null,null,null,null,null,null,null,"USst =",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J146=\"\",\"\",SUM(IF(Y146=UST!CY146,1,0)))","v":""},"/",1,null,{"$f":"UST!CX146","v":69.599999999999994},{"$f":"J146","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USst =",{"$f":"ROUND($CX146*CN$153/(100%+CN$153),2)","v":11.6},null,null,null,null,null,null,null,null,null,1,"/",1,null,{"$f":"A174","v":69.599999999999994},{"$f":"CJ146","v":11.6}]
[]
[]
[]
[null,null,"6.","Berechne für die folgenden Nettobeträge die Umsatzstuerbeträge bei einem Steuersatz von 20%, von 13% und von 10%. (9 Punkte)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5.","Berechne für die folgenden Nettobeträge die Umsatzstuerbeträge bei einem Steuersatz von 20%, von 13% und von 10%. (9 Punkte)"]
[null,null,null,"Achtung du musst deine Ergebnisse auf 2 Kommastellen (kaufmännisch) ruden, so wie du es in Mathematik gelernt hast! ANSONSTEN WIRDT DEIN ERGEBNIS ALS FALSCH GEWERTET!!!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Achtung du musst deine Ergebnisse auf 2 Kommastellen (kaufmännisch) ruden, so wie du es in Mathematik gelernt hast! ANSONSTEN WIRDT DEIN ERGEBNIS ALS FALSCH GEWERTET!!!"]
[]
[null,null,null,null,null,null,null,0.1,null,0.13,null,null,null,0.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UST_BETR",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,null,0.13,null,null,null,0.2]
[null,null,null,null,null,null,null,"↓",null,"↓",null,null,null,"↓",null,null,null,null,null,null,null,null,null,0.2,0.13,0.1,null,null,null,null,null,null,null,null,null,null,null,null,1,1.25,0.98,0.95,1.1000000000000001,1.08,1.05,1.02,0.88,0.92,0.94,0.93,1.04,1.03,1.01,0.97,1.06,0.96,0.89,1.21,0.87,0.99,1.19,1.1399999999999999,0.85,1.1100000000000001,0.86,0.82,1.18,1.1599999999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"↓",null,"↓",null,null,null,"↓",null,null,null,null,null,null,null,null,null,0.2,0.13,0.1]
[null,null,null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(AL155,UST_BETR,$Y$1+1,0))=16),\"\",VLOOKUP(AL155,UST_BETR,$Y$1+1,0))","v":280.7},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(H155=\"\",H156=\"\",H157=\"\"),\"\",SUM(IF(X155=UST!CX155,1,0),IF(X156=UST!CX156,1,0),IF(X157=UST!CX157,1,0)))","v":""},"/",3,null,{"$f":"H155","v":0},{"$f":"J155","v":0},{"$f":"N155","v":0},null,null,null,null,null,null,null,null,null,null,null,1,412.8,{"$f":"ROUND($AM155*AN$41,1)","v":268.3},619.20000000000005,528.4,516,668.7,198.1,152.69999999999999,264.2,280.7,511.9,{"$f":"ROUND($AM155*AX$41,1)","v":507.7},664.6,235.3,499.5,272.39999999999998,264.2,582,317.89999999999998,202.3,573.79999999999995,{"$f":"ROUND($AM155*BH$41,1)","v":532.5},227,623.29999999999995,189.9,297.2,734.8,561.4,577.9,280.7,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(AL155,UST_BETR,$Y$1+1,0))=16),\"\",VLOOKUP(AL155,UST_BETR,$Y$1+1,0))","v":280.7},null,null,null,{"$f":"ROUND($CD155*CH$153,2)","v":28.07},null,{"$f":"ROUND($CD155*CJ$153,2)","v":36.49},null,{"$f":"ROUND($CD155*CL$153,2)","v":0},null,{"$f":"ROUND($CD155*CN$153,2)","v":56.14},null,null,null,null,null,3,"/",3,null,{"$f":"CH155","v":28.07},{"$f":"CJ155","v":36.49},{"$f":"CN155","v":56.14}]
[null,null,null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(AL156,UST_BETR,$Y$1+1,0))=16),\"\",VLOOKUP(AL156,UST_BETR,$Y$1+1,0))","v":1209.9000000000001},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J155=\"\",J156=\"\",J157=\"\"),\"\",SUM(IF(Y155=UST!CY155,1,0),IF(Y156=UST!CY156,1,0),IF(Y157=UST!CY157,1,0)))","v":""},"/",3,null,{"$f":"H156","v":0},{"$f":"J156","v":0},{"$f":"N156","v":0},null,null,null,null,null,null,null,null,null,null,null,2,1779.2,1156.5,2668.8,2277.4,2224,2882.3,854,658.3,1138.7,1209.9000000000001,2206.1999999999998,2188.4,2864.5,1014.1,2152.8000000000002,1174.3,1138.7,2508.6999999999998,1370,871.8,2473.1,2295.1999999999998,978.6,2686.6,818.4,1281,3167,2419.6999999999998,2490.9,1209.9000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(AL156,UST_BETR,$Y$1+1,0))=16),\"\",VLOOKUP(AL156,UST_BETR,$Y$1+1,0))","v":1209.9000000000001},null,null,null,{"$f":"ROUND($CD156*CH$153,2)","v":120.99},null,{"$f":"ROUND($CD156*CJ$153,2)","v":157.29},null,{"$f":"ROUND($CD156*CL$153,2)","v":0},null,{"$f":"ROUND($CD156*CN$153,2)","v":241.98},null,null,null,null,null,3,"/",3,null,{"$f":"CH156","v":120.99},{"$f":"CJ156","v":157.29},{"$f":"CN156","v":241.98}]
[null,null,null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(AL157,UST_BETR,$Y$1+1,0))=16),\"\",VLOOKUP(AL157,UST_BETR,$Y$1+1,0))","v":185},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(N155=\"\",N156=\"\",N157=\"\"),\"\",SUM(IF(Z155=UST!CZ155,1,0),IF(Z156=UST!CZ156,1,0),IF(Z157=UST!CZ157,1,0)))","v":""},"/",3,null,{"$f":"H157","v":0},{"$f":"J157","v":0},{"$f":"N157","v":0},null,null,null,null,null,null,null,null,null,null,null,3,272,176.8,408,348.2,340,440.6,130.6,100.6,174.1,185,337.3,334.6,437.9,155,329.1,179.5,174.1,383.5,209.4,133.30000000000001,378.1,350.9,149.6,410.7,125.1,195.8,484.2,369.9,380.8,185,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($Y$1=\"\",TYPE(VLOOKUP(AL157,UST_BETR,$Y$1+1,0))=16),\"\",VLOOKUP(AL157,UST_BETR,$Y$1+1,0))","v":185},null,null,null,{"$f":"ROUND($CD157*CH$153,2)","v":18.5},null,{"$f":"ROUND($CD157*CJ$153,2)","v":24.05},null,{"$f":"ROUND($CD157*CL$153,2)","v":0},null,{"$f":"ROUND($CD157*CN$153,2)","v":37},null,null,null,null,null,3,"/",3,null,{"$f":"CH157","v":18.5},{"$f":"CJ157","v":24.05},{"$f":"CN157","v":37}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gesamtpunkte",null,{"$f":"SUM(T5:T158)","v":0},"/",{"$f":"SUM(V5:V158)","v":65},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gesamtpunkte",null,{"$f":"SUM(CT5:CT158)","v":65},"/",{"$f":"SUM(CV5:CV158)","v":65}]
[]
[null,null,{"$f":"$A$2000","v":"ARZL Peter"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Gr \"&TEXT($Y$1,\"00\")","v":"Gr 30"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ankreuzen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C4","v":"Erweiterte Kkompetenzen (EK9)"},{"$f":"T160","v":0},{"$f":"U160","v":"/"},{"$f":"V160","v":65},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[]
[20.3]
[{"$f":"A166*20%","v":4.0600000000000005},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nummerieren"]
[{"$f":"SUM(A166:A167)","v":24.36},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[275,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[{"$f":"A169*20%","v":55},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[{"$f":"SUM(A169:A170)","v":330},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[58,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[{"$f":"A172*20%","v":11.600000000000001},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[{"$f":"SUM(A172:A173)","v":69.599999999999994}]
[38.799999999999997,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Belegkürzel"]
[{"$f":"A175*20%","v":7.76},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A"]
[{"$f":"SUM(A175:A176)","v":46.559999999999995},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(COUNTBLANK(H155:P157),COUNTBLANK(J146),COUNTBLANK(J140),COUNTBLANK(J134),COUNTBLANK(J128),COUNTBLANK(D118),COUNTBLANK(J118),COUNTBLANK(Q118),COUNTBLANK(P117),COUNTBLANK(I117),COUNTBLANK(G112),COUNTBLANK(G113),COUNTBLANK(H114),COUNTBLANK(N112),COUNTBLANK(N113),COUNTBLANK(P113),COUNTBLANK(P112),COUNTBLANK(N102),COUNTBLANK(N100),COUNTBLANK(N97),COUNTBLANK(N94),COUNTBLANK(Q79),COUNTBLANK(Q77),COUNTBLANK(Q75),COUNTBLANK(Q72),COUNTBLANK(N59),COUNTBLANK(N57),COUNTBLANK(N55),COUNTBLANK(N54),COUNTBLANK(N51),COUNTBLANK(H43:R44),COUNTBLANK(E35),COUNTBLANK(H30:R31),COUNTBLANK(E22),COUNTBLANK(H17:R18),COUNTBLANK(E9))","v":125},null,57,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"K"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SO"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Antworten1_3",null,null,null,null,null,null,null,"Antworten1_3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"RAND()*CC205","v":1.5781208266979379},{"$f":"INDEX(CC185:CC205,RANK(CD185,CD185:CD205))","v":21},{"$f":"$CG$112","v":"Nettowert"},null,null,null,null,null,null,{"$f":"UPPER(MID(CN185,1,1))","v":"L"},{"$f":"VLOOKUP(CC185,$CE$185:$CF$205,2,0)","v":"Leistungen"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"RAND()*CC205","v":2.477766245205296},{"$f":"INDEX(CC185:CC205,RANK(CD186,CD185:CD205))","v":20},{"$f":"$CN$112","v":"Preis"},null,null,null,null,null,null,"L","Lieferungen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"RAND()*CC205","v":9.731159432807253},{"$f":"INDEX(CC185:CC205,RANK(CD187,CD185:CD205))","v":14},{"$f":"$CP$112","v":"ohne"},null,null,null,null,null,null,"N","Nettowertes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"RAND()*CC205","v":19.452827551630179},{"$f":"INDEX(CC185:CC205,RANK(CD188,CD185:CD205))","v":4},{"$f":"$CG$113","v":"Bruttowert"},null,null,null,null,null,null,"B","Bruttowert"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"RAND()*CC205","v":17.384733695182753},{"$f":"INDEX(CC185:CC205,RANK(CD189,CD185:CD205))","v":10},"Betrag",null,null,null,null,null,null,"F","Firma"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"RAND()*CC205","v":7.080550861817037},{"$f":"INDEX(CC185:CC205,RANK(CD190,CD185:CD205))","v":18},{"$f":"$CP$113","v":"mit"},null,null,null,null,null,null,"B","Bezahlung"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,{"$f":"RAND()*CC205","v":19.48091217009986},{"$f":"INDEX(CC185:CC205,RANK(CD191,CD185:CD205))","v":3},{"$f":"$CH$114","v":"Nettowertes"},null,null,null,null,null,null,"Z","Zahlungsbetrag"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,{"$f":"RAND()*CC205","v":19.074798522346807},{"$f":"INDEX(CC185:CC205,RANK(CD192,CD185:CD205))","v":5},"Firma",null,null,null,null,null,null,"F","für"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,{"$f":"RAND()*CC205","v":17.815740165591933},{"$f":"INDEX(CC185:CC205,RANK(CD193,CD185:CD205))","v":9},"Auftraggebers",null,null,null,null,null,null,"A","Auftraggebers"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,{"$f":"RAND()*CC205","v":19.785721365685315},{"$f":"INDEX(CC185:CC205,RANK(CD194,CD185:CD205))","v":2},{"$f":"$CI$117","v":"Lieferungen"},null,null,null,null,null,null,"B","Betrag"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"RAND()*CC205","v":20.332359471890626},{"$f":"INDEX(CC185:CC205,RANK(CD195,CD185:CD205))","v":1},{"$f":"$CP$117","v":"Leistungen"},null,null,null,null,null,null,"S","Steuersatzes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,{"$f":"RAND()*CC205","v":8.6696514011623655},{"$f":"INDEX(CC185:CC205,RANK(CD196,CD185:CD205))","v":16},{"$f":"$CD$118","v":"Unternehmer"},null,null,null,null,null,null,"F","Finanzamt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,{"$f":"RAND()*CC205","v":18.99224440445526},{"$f":"INDEX(CC185:CC205,RANK(CD197,CD185:CD205))","v":6},{"$f":"$CJ$118","v":"Bezahlung"},null,null,null,null,null,null,"U","Umsatzsteuer"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,{"$f":"RAND()*CC205","v":8.2028584645061624},{"$f":"INDEX(CC185:CC205,RANK(CD198,CD185:CD205))","v":17},{"$f":"$CQ$118","v":"Unternehmens"},null,null,null,null,null,null,"O","ohne"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,{"$f":"RAND()*CC205","v":16.392208455582583},{"$f":"INDEX(CC185:CC205,RANK(CD199,CD185:CD205))","v":12},"Finanzamt",null,null,null,null,null,null,"B","Barwertes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,{"$f":"RAND()*CC205","v":18.811340932263352},{"$f":"INDEX(CC185:CC205,RANK(CD200,CD185:CD205))","v":7},"Zahlungsbetrag",null,null,null,null,null,null,"U","Unternehmer"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,{"$f":"RAND()*CC205","v":17.982278685223452},{"$f":"INDEX(CC185:CC205,RANK(CD201,CD185:CD205))","v":8},"für",null,null,null,null,null,null,"U","Unternehmens"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,{"$f":"RAND()*CC205","v":3.0735793460696819},{"$f":"INDEX(CC185:CC205,RANK(CD202,CD185:CD205))","v":19},"zur",null,null,null,null,null,null,"M","mit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,{"$f":"RAND()*CC205","v":8.9561630520326041},{"$f":"INDEX(CC185:CC205,RANK(CD203,CD185:CD205))","v":15},"Barwertes",null,null,null,null,null,null,"Z","zur"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,{"$f":"RAND()*CC205","v":16.911472511171365},{"$f":"INDEX(CC185:CC205,RANK(CD204,CD185:CD205))","v":11},"Steuersatzes",null,null,null,null,null,null,"P","Preis"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,{"$f":"RAND()*CC205","v":15.944917138990235},{"$f":"INDEX(CC185:CC205,RANK(CD205,CD185:CD205))","v":13},"Umsatzsteuer",null,null,null,null,null,null,"N","Nettowert"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["ARZL Peter"]
[1]
["BSP - Berechnung der Umsatzsteuer "]

{"sheet":"BEW Belege FAs","index":1,"n_rows":47,"n_cols":19,"rows_kept":47,"cut":false,"hidden":true,"merged":[[25,0,25,6],[0,0,0,18],[8,0,17,6],[19,0,19,6],[21,0,21,6],[22,0,22,6],[23,0,23,6],[24,0,24,6]]}
["Ergebnis"]
[]
["Punkterechner",null,null,{"$f":"SUM('BEW Belege FAs'!F6:F7)","v":65},"…............",100," %"]
[null,null,null,{"$f":"SUM(D6:D7)","v":0},"…............",{"$f":"D4*F3/D3","v":0}," %"]
[]
[0,": ",null,{"$f":"IF(UST!T160=\"\",\"\",UST!T160)","v":0},"/",{"$f":"UST!CV160","v":65},null,null,"Nicht erfüllte Grundkompetenzen:",null,null,null,{"$f":"IF(AND(D6=\"\",F6=\"\"),0,IF(D6<=F6*50%,1,0))","v":1}]
[null,": ",null,null,"/"]
[null,null,null,null,null,null,null,null,"Punktemaximum: ",null,{"$f":"SUM(F6:F7)","v":65}]
[{"$f":"A22&\"\n\n\"&A23&\"\n\"&A24&\"\n\n\"&A25&\"\n\"&A26&\"\n\n\"&A27&\"\n\"&A28","v":"Liebe Schülerin! / Lieber Schüler!\n\nGK0: 0/65   →   nicht erfüllt!\n\n\nDu hast ein „NICHT GENÜGEND” erreicht.\nDas ist leider zu wenig!   ☹️   Schau dir deine Ergebnisse bitte noch einmal an und versuch' es besser zu machen!!!\n\nLG\nFL Harasleben"},null,null,null,null,null,null,null,"Genügend in %: ",null,{"$f":"M20/K8","v":0.43076923076923079}]
[]
[null,null,null,null,null,null,null,null,"Abstufung in Prozent: ",null,0.1]
[null,null,null,null,null,null,null,null,"Abstufung in Punkten: ",null,{"$f":"ROUND($K$8*K11,0)","v":7}]
[]
[null,null,null,null,null,null,null,null,"Notenschlüssel:"]
[null,null,null,null,null,null,null,null,null,"❶",{"$f":"IF(M17=K17,K17&\" P\",M17&\" - \"&K17&\" P\")","v":"58 - 65 P"},"❷",{"$f":"IF(M18=K18,K18&\" P\",M18&\" - \"&K18&\" P\")","v":"48 - 57 P"},"❸",{"$f":"M19&\" - \"&K19&\" P\"","v":"38 - 47 P"},"❹",{"$f":"M20&\" - \"&K20&\" P\"","v":"28 - 37 P"},"❺",{"$f":"M21&\" - \"&K21&\" P\"","v":"0 - 27 P"}]
[]
[null,null,null,null,null,null,null,null,null,"❶",{"$f":"K8","v":65},"-",{"$f":"K17-$K$12","v":58},null,null,"Anpassungen: "]
[null,null,null,null,null,null,null,null,null,"❷",{"$f":"M17-1","v":57},"-",{"$f":"K18-($K$12+P18)","v":48},null,null,2]
[null,null,null,null,null,null,null,null,null,"❸",{"$f":"M18-1","v":47},"-",{"$f":"K19-($K$12+P19)","v":38},null,null,2]
[{"$f":"A47","v":"<p><strong>Liebe Schülerin! / Lieber Schüler!</strong></br><p><strong><span class=\"\" style=\"color: rgb(255, 102, 0);\">GK0: 0/65   →   nicht erfüllt!</span></strong><br><strong><span class=\"\" style=\"color: rgb(153, 204, 0);\"></span></strong></p><p>Du hast ein „<strong><span class=\"\" style=\"color: rgb(255, 0, 0);\">NICHT GENÜGEND</span></strong>” erreicht.<br>Das ist leider zu wenig!   ☹️   Schau dir deine Ergebnisse bitte noch einmal an und versuch' es besser zu machen!!!</p><p><span lang=\"EN-US\">LG</span><span lang=\"EN-US\"><br><em><strong>FL Harasleben</strong></em></span><br></p><strong><span class=\"\" style=\"color: rgb(153, 204, 0);\"></span></strong>"},null,null,null,null,null,null,null,null,"❹",{"$f":"M19-1","v":37},"-",{"$f":"K20-($K$12+P20)","v":28},null,null,2]
[null,null,null,null,null,null,null,null,null,"❺",{"$f":"M20-1","v":27},"-",0]
["Liebe Schülerin! / Lieber Schüler!"]
[{"$f":"IF(A6=\"\",\"\",\"GK\"&A6&\": \"&D6&E6&F6&IF(AND(D6>F6*50%,D6<=F6*75%),\"   →   überwiegend erfüllt!\",IF(D6>F6*75%,\"   →   vollständig erfüllt!\",\"   →   nicht erfüllt!\")))","v":"GK0: 0/65   →   nicht erfüllt!"},null,null,null,null,null,null,null,"Erreichte Punkte:",null,{"$f":"SUM(D6:D7)","v":0},{"$f":"\"  das entspricht: \"&TEXT(ROUND(F4,4),\"# ##0,00\")&\" %\"","v":"  das entspricht: 0,00 %"}]
[{"$f":"IF(A7=\"\",\"\",\"GK\"&A7&\": \"&D7&E7&F7&IF(AND(D7>F7*50%,D7<=F7*75%),\"   →   überwiegend erfüllt!\",IF(D7>F7*75%,\"   →   vollständig erfüllt!\",\"   →   nicht erfüllt!\")))","v":""}]
[{"$f":"\"Du hast ein \"&IF(J25=1,UPPER(\"„Sehr gut”\"),IF(J25=2,UPPER(\"„Gut”\"),IF(J25=3,UPPER(\"„Befriedigend”\"),IF(J25=4,UPPER(\"„Genügend”\"),IF(J25=5,UPPER(\"„Nicht genügend”\"),\"---\")))))&\" erreicht.\"","v":"Du hast ein „NICHT GENÜGEND” erreicht."},null,null,null,null,null,null,null,"Note:",{"$f":"IF(M6>0,5,IF(K23>=M17,1,IF(AND(K23>=M18,K23<M17),2,IF(AND(K23>=M19,K23<M18),3,IF(AND(K23>=M20,K23<M19),4,5)))))","v":5}]
[{"$f":"IF(J25=1,\"Das hast du ganz toll gemacht!!!   😀\",IF(J25=2,\"Das ist eine gute Arbeit geworden!!   🙂\",IF(J25=3,\"Das passt schon so!   😐\",IF(J25=4,\"Das geht noch besser!   🙁\",\"Das ist leider zu wenig!   ☹️   Schau dir deine Ergebnisse bitte noch einmal an und versuch' es besser zu machen!!!\"))))","v":"Das ist leider zu wenig!   ☹️   Schau dir deine Ergebnisse bitte noch einmal an und versuch' es besser zu machen!!!"}]
["LG"]
["FL Harasleben"]
[]
["<p><strong>Liebe Schülerin! / Lieber Schüler!</strong></br>"]
["<p><strong><span class=\"\" style=\"color: rgb(255, 102, 0);\">"]
[{"$f":"IF(A6=\"\",\"\",\"GK\"&A6&B6&D6&E6&F6)","v":"GK0: 0/65"}]
[{"$f":"IF(D6=\"\",\"\",IF(AND(D6>F6*50%,D6<=F6*75%),\"   →   überwiegend erfüllt!\",IF(D6>F6*75%,\"   →   vollständig erfüllt!\",\"   →   nicht erfüllt!\")))","v":"   →   nicht erfüllt!"}]
["</span></strong><br><strong><span class=\"\" style=\"color: rgb(153, 204, 0);\">"]
[{"$f":"IF(A7=\"\",\"\",\"EK\"&A7&B7&D7&E7&F7)","v":""}]
[{"$f":"IF(D7=\"\",\"\",IF(AND(D7>F7*50%,D7<=F7*75%),\"   →   überwiegend erfüllt!\",IF(D7>F7*75%,\"   →   vollständig erfüllt!\",\"   →   nicht erfüllt!\")))","v":""}]
["</span></strong></p>"]
["<p>Du hast ein „<strong><span class=\"\" style=\"color: rgb(255, 0, 0);\">"]
[{"$f":"IF(J25=1,UPPER(\"Sehr gut\"),IF(J25=2,UPPER(\"Gut\"),IF(J25=3,UPPER(\"Befriedigend\"),IF(J25=4,UPPER(\"Genügend\"),IF(J25=5,UPPER(\"Nicht genügend\"),\"---\")))))","v":"NICHT GENÜGEND"}]
["</span></strong>” erreicht.<br>"]
[{"$f":"IF(J25=1,\"Das hast du ganz toll gemacht!!!   😀\",IF(J25=2,\"Das ist eine gute Arbeit geworden!!   🙂\",IF(J25=3,\"Das passt schon so!   😐\",IF(J25=4,\"Das geht noch besser!   🙁\",\"Das ist leider zu wenig!   ☹️   Schau dir deine Ergebnisse bitte noch einmal an und versuch' es besser zu machen!!!\"))))","v":"Das ist leider zu wenig!   ☹️   Schau dir deine Ergebnisse bitte noch einmal an und versuch' es besser zu machen!!!"}]
["</p>"]
["<p><span lang=\"EN-US\">LG</span><span lang=\"EN-US\"><br><em><strong>"]
["FL Harasleben</strong></em></span><br></p><strong><span class=\"\" style=\"color: rgb(153, 204, 0);\"></span></strong>"]
[]
[]
[{"$f":"CONCATENATE(A30,A31,A32,A33,A34,A35,A36,A37,A38,A39,A40,A41,A42,A43,A44)","v":"<p><strong>Liebe Schülerin! / Lieber Schüler!</strong></br><p><strong><span class=\"\" style=\"color: rgb(255, 102, 0);\">GK0: 0/65   →   nicht erfüllt!</span></strong><br><strong><span class=\"\" style=\"color: rgb(153, 204, 0);\"></span></strong></p><p>Du hast ein „<strong><span class=\"\" style=\"color: rgb(255, 0, 0);\">NICHT GENÜGEND</span></strong>” erreicht.<br>Das ist leider zu wenig!   ☹️   Schau dir deine Ergebnisse bitte noch einmal an und versuch' es besser zu machen!!!</p><p><span lang=\"EN-US\">LG</span><span lang=\"EN-US\"><br><em><strong>FL Harasleben</strong></em></span><br></p><strong><span class=\"\" style=\"color: rgb(153, 204, 0);\"></span></strong>"}]