{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Tipps","% formatieren","Prozentanteil","Prozentsatz","MWST 1","MWST 2","MWST 3","Zinsen"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":4,"comments":1,"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":"Tipps","index":0,"n_rows":1,"n_cols":8,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,"Prozentrechnen",null,null,null,null,null,"EASY4ME"]

{"sheet":"% formatieren","index":1,"n_rows":27,"n_cols":16,"rows_kept":27,"cut":false,"hidden":false,"merged":[[3,0,3,2],[2,3,2,5],[0,0,0,9],[2,8,7,10]]}
["Ein Prozent ist ein Hundertstel: 1% = 0,01"]
[]
[null,null,null,"formatiere als",null,null,null,null,"Beim Formatieren von Zellen wird die Überprüfung auf Richtigkeit nicht immer  sofort durchgeführt! \nKlicke dann auf die Schaltfläche, um deine Eingaben zu überprüfen."]
["Gib die angegebenen Werte ein:",null,null,"Prozent",null,"Dezimalzahl",null,null,null,null,null,null,"1. Spalte","2. Spalte"]
[null,null,"16 Prozent",null,{"$f":"IF(AND(LEFT(CELL(\"format\",D5),1)=\"P\",$M5),CHAR(252),\"\")","v":""},null,{"$f":"IF(AND(LEFT(CELL(\"format\",F5),1)=\"S\",$N5),CHAR(252),\"\")","v":""},null,null,null,null,0.16,{"$f":"L5=D5","v":false},{"$f":"L5=F5","v":false}]
[null,null,"2 Prozent",null,{"$f":"IF(AND(LEFT(CELL(\"format\",D6),1)=\"P\",$M6),CHAR(252),\"\")","v":""},null,{"$f":"IF(AND(LEFT(CELL(\"format\",F6),1)=\"S\",$N6),CHAR(252),\"\")","v":""},null,null,null,null,0.02,{"$f":"L6=D6","v":false},{"$f":"L6=F6","v":false}]
[null,null,"50 Prozent",null,"",null,"",null,null,null,null,0.5,false,false]
[null,null,"100 Prozent",null,"",null,"",null,null,null,null,1,false,false]
[null,null,"78 Prozent",null,"",null,"",null,null,null,null,0.78,false,false]
[]
[]
[]
[null,null,null,"als Prozent"]
[null,0.05,"ist gleich viel wie",null,{"$f":"IF(AND(LEFT(CELL(\"format\",D14),1)=\"P\",$M14),CHAR(252),\"\")","v":""},"Beispiel: Schreib 0,05 in die Zelle D14 und formatiere sie als Prozent!",null,null,null,null,null,null,{"$f":"B14=D14","v":false}]
[null,7.0000000000000007E-2,"ist gleich viel wie",null,"",null,null,null,null,null,null,null,{"$f":"B15=D15","v":false}]
[null,0.12,"ist gleich viel wie",null,"",null,null,null,null,null,null,null,false]
[null,0.62,"ist gleich viel wie",null,"",null,null,null,null,null,null,null,false]
[null,1,"ist gleich viel wie",null,"",null,null,null,null,null,null,null,false]
[null,1.2,"ist gleich viel wie",null,"",null,null,null,null,null,null,null,false]
[]
[null,null,null,"als Dezimalzahl",null,null,null,null,null,null,null,null,null,"Dezimalzahl?","Standard?"]
[null,0.02,"ist gleich viel wie",0.02,{"$f":"IF(P22=TRUE(),CHAR(252),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"D22=B22","v":true},{"$f":"LEFT(CELL(\"format\",$D22),1)=\"F\"","v":false},{"$f":"LEFT(CELL(\"format\",$D22),1)=\"S\"","v":false},{"$f":"AND(OR(N22,O22),M22)","v":false}]
[null,0.1,"ist gleich viel wie",0.1,{"$f":"IF(P23=TRUE(),CHAR(252),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"D23=B23","v":true},{"$f":"LEFT(CELL(\"format\",$D23),1)=\"F\"","v":false},{"$f":"LEFT(CELL(\"format\",$D23),1)=\"S\"","v":false},{"$f":"AND(OR(N23,O23),M23)","v":false}]
[null,0.22,"ist gleich viel wie",0.22,"",null,null,null,null,null,null,null,true,false,false,false]
[null,0.5,"ist gleich viel wie",0.5,"",null,null,null,null,null,null,null,true,false,false,false]
[null,2,"ist gleich viel wie",2,"",null,null,null,null,null,null,null,true,false,false,false]
[null,0.01,"ist gleich viel wie",0.01,"",null,null,null,null,null,null,null,true,false,false,false]

{"sheet":"Prozentanteil","index":2,"n_rows":34,"n_cols":18,"rows_kept":34,"cut":false,"hidden":false,"merged":[[8,0,8,2],[10,0,10,3],[25,1,25,4],[3,0,3,2],[4,0,4,2],[5,0,5,2],[6,0,6,2],[7,0,7,2]]}
["Berechne den Prozentanteil A!"]
[]
["Prozentanteil berechnen"]
["10% von 150 Euro sind:",null,null,null,null,null,null,null,null,null,null,{"$f":"150*10%","v":15}]
["12% von 220 Euro sind:",null,null,null,null,null,null,null,null,null,null,{"$f":"220*0.12","v":26.4}]
["48% von 400 Euro sind:",null,null,null,null,null,null,null,null,null,null,{"$f":"400*0.48","v":192}]
["4% von 20 Euro sind:",null,null,null,null,null,null,null,null,null,null,{"$f":"20*0.04","v":0.8}]
["150% von 30 Euro sind:",null,null,null,null,null,null,null,null,null,null,{"$f":"30*1.5","v":45}]
["500% von 200 Euro sind:",null,null,null,null,null,null,null,null,null,null,{"$f":"200*5","v":1000}]
[]
["Eine Wohnung wird um 145.000 Euro verkauft.\nDer Makler verlangt 3,6% Provision.\nWie viel erhält er?"]
[null,null,"Die Provision beträgt:",null,null,null,null,null,null,null,null,{"$f":"145000*0.036","v":5220}]
[]
[]
["Formel: Prozentanteil A = Grundwert G * Prozentsatz p"]
[]
[]
["Prozentsatz p",null,"Grundwert G",null,"Prozentanteil A"]
[0.1,"von",150,"sind"]
[0.18,"von",22.5,"sind"]
[2.75E-2,"von",1250,"sind"]
[0.03,"von",120,"sind"]
[7.1999999999999995E-2,"von",840,"sind"]
[1.1200000000000001,"von",50,"sind"]
[]
[null,"Prozentsatz p"]
["Grundwert G",0.01,0.15,0.9,1.2]
[100,1,15,90,120,null,null,null,null,null,null,null,null,null,{"$f":"B$27*$A28","v":1},{"$f":"C$27*$A28","v":15},90,120]
[35,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B$27*$A29","v":0.35000000000000003},{"$f":"C$27*$A29","v":5.25},{"$f":"D$27*$A29","v":31.5},{"$f":"E$27*$A29","v":42}]
[45,null,null,null,null,null,null,null,null,null,null,null,null,null,0.45,6.75,40.5,54]
[23,null,null,null,null,null,null,null,null,null,null,null,null,null,0.23,3.4499999999999997,20.7,27.599999999999998]
[45,null,null,null,null,null,null,null,null,null,null,null,null,null,0.45,6.75,40.5,54]
[67,null,null,null,null,null,null,null,null,null,null,null,null,null,0.67,10.049999999999999,60.300000000000004,80.399999999999991]
[125,null,null,null,null,null,null,null,null,null,null,null,null,null,1.25,18.75,112.5,150]

{"sheet":"Prozentsatz","index":3,"n_rows":29,"n_cols":15,"rows_kept":29,"cut":false,"hidden":false,"merged":[[8,0,8,1],[2,0,2,2],[27,0,27,3],[28,0,28,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1]]}
["Berechne den Prozentsatz!"]
[]
["Prozentsatz berechnen",null,null,null,null,null,null,null,null,null,null,"Wert","Formatierung"]
["12 € von 60 € sind:",null,null,null,null,null,null,null,null,null,null,{"$f":"12/60","v":0.2},{"$f":"LEFT(CELL(\"format\",C4),1)=\"P\"","v":false},{"$f":"(L4=C4)*M4","v":0}]
["15 € von 60 € sind:",null,null,null,null,null,null,null,null,null,null,{"$f":"15/60","v":0.25},{"$f":"LEFT(CELL(\"format\",C5),1)=\"P\"","v":false},{"$f":"(L5=C5)*M5","v":0}]
["20 € von 60 € sind:",null,null,null,null,null,null,null,null,null,null,{"$f":"20/60","v":0.33333333333333331},false,0]
["30 € von 60 € sind:",null,null,null,null,null,null,null,null,null,null,{"$f":"30/60","v":0.5},false,0]
["60 € von 60 € sind:",null,null,null,null,null,null,null,null,null,null,1,false,0]
["90 € von 60 € sind:",null,null,null,null,null,null,null,null,null,null,1.5,false,0]
[]
["Prozentanteil",null,"Grundwert",null,"Prozentsatz"]
[1,"von",25,"sind",null,null,null,null,null,null,null,{"$f":"A12/C12","v":0.04},{"$f":"LEFT(CELL(\"format\",E12),1)=\"P\"","v":false},{"$f":"(L12=E12)*M12","v":0}]
[1,"von",50,"sind",null,null,null,null,null,null,null,0.02,{"$f":"LEFT(CELL(\"format\",E13),1)=\"P\"","v":false},{"$f":"(L13=E13)*M13","v":0}]
[1,"von",200,"sind",null,null,null,null,null,null,null,5.0000000000000001E-3,false,0]
[1,"von",0.4,"sind",null,null,null,null,null,null,null,2.5,false,0]
[5,"von",12,"sind",null,null,null,null,null,null,null,0.41666666666666669,false,0]
[12,"von",240,"sind",null,null,null,null,null,null,null,0.05,false,0]
[]
[]
[]
[null,"Prozentanteil","Grundwert","Anteil in % (Prozentsatz)",null,null,null,null,null,null,"A","G","p","Format P2"]
["40 von 200",40,200,0.2,null,null,null,null,null,null,40,200,{"$f":"K22/L22","v":0.2},{"$f":"CELL(\"Format\",D22)=\"P2\"","v":true},{"$f":"(M22=D22)*N22","v":1}]
["20 von 120",null,null,null,null,null,null,null,null,null,20,120,{"$f":"K23/L23","v":0.16666666666666666},{"$f":"CELL(\"Format\",D23)=\"P2\"","v":false},{"$f":"(M23=D23)*N23","v":0}]
["15 von 300",null,null,null,null,null,null,null,null,null,15,300,0.05,false,0]
["140 von 1000",null,null,null,null,null,null,null,null,null,140,1000,0.14000000000000001,false,0]
["45 von 200",null,null,null,null,null,null,null,null,null,45,200,0.22500000000000001,false,0]
["1200 von 178000",null,null,null,null,null,null,null,null,null,1200,178000,6.7415730337078653E-3,false,0]
["In einer Klasse sind 25 Kinder.\n11 davon sind Mädchen.\nWie viel Prozent sind das?"]
["Der Anteil von Mädchen ist:",null,null,null,null,null,null,null,null,null,null,{"$f":"11/25","v":0.44},{"$f":"LEFT(CELL(\"format\",C29),1)=\"P\"","v":false},{"$f":"(L29=C29)*M29","v":0}]

{"sheet":"MWST 1","index":4,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,0,1,3]]}
["Berechne die Mehrwertsteuer!"]
["Bei dieser Aufgabe ist der Mehrwertsteuersatz in Prozent angegeben:\nMultipliziere den Nettopreis mit dem Mehrwertsteuersatz!"]
["Grundwert G","Prozentsatz p","Prozentanteil A"]
["Nettopreis (ohne MWST)","Mehrwertsteuersatz in %","Mehrwertsteuer (MWST)"]
[2400,0.1,null,null,null,null,null,null,null,null,null,{"$f":"A5*B5","v":240}]
[120,0.1,null,null,null,null,null,null,null,null,null,{"$f":"A6*B6","v":12}]
[1460,0.2,null,null,null,null,null,null,null,null,null,292]
[17.899999999999999,0.2,null,null,null,null,null,null,null,null,null,3.58]
[12.3,0.2,null,null,null,null,null,null,null,null,null,2.4600000000000004]
[15.5,0.1,null,null,null,null,null,null,null,null,null,1.55]
[14.4,0.1,null,null,null,null,null,null,null,null,null,1.4400000000000002]
[1400,0.2,null,null,null,null,null,null,null,null,null,280]

{"sheet":"MWST 2","index":5,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,0,1,3]]}
["Berechne die Mehrwertsteuer!"]
["Bei dieser Aufgabe ist der Mehrwertsteuersatz als ganze Zahl angegeben.\nDaher muss das Ergebnis nach der Multiplikation durch 100 dividiert werden."]
["Grundwert G","Prozentsatz p","Prozentanteil A"]
["Nettopreis (ohne MWST)","Mehrwertsteuersatz als Zahl","Mehrwertsteuer (MWST)"]
[3500,10,null,null,null,null,null,null,null,null,null,{"$f":"A5*B5/100","v":350}]
[258.5,10,null,null,null,null,null,null,null,null,null,{"$f":"A6*B6/100","v":25.85}]
[463,20,null,null,null,null,null,null,null,null,null,92.6]
[14.5,20,null,null,null,null,null,null,null,null,null,2.9]
[6.9,20,null,null,null,null,null,null,null,null,null,1.38]
[4.99,10,null,null,null,null,null,null,null,null,null,0.49900000000000005]
[12.5,10,null,null,null,null,null,null,null,null,null,1.25]
[2560,20,null,null,null,null,null,null,null,null,null,512]

{"sheet":"MWST 3","index":6,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[13,0,13,3]]}
["Berechne die Mehrwertsteuer!"]
[]
["Grundwert G","Prozentsatz p","Prozentanteil A"]
["Nettopreis (ohne MWST)","Mehrwertsteuersatz in %","Mehrwertsteuer (MWST)","Bruttopreis (Nettopreis + Mwst)"]
[2400,0.1,null,null,null,null,null,null,null,null,null,{"$f":"A5*B5","v":240},{"$f":"A5+L5","v":2640}]
[120,0.1,null,null,null,null,null,null,null,null,null,{"$f":"A6*B6","v":12},{"$f":"A6+L6","v":132}]
[1460,0.2,null,null,null,null,null,null,null,null,null,292,1752]
[17.899999999999999,0.2,null,null,null,null,null,null,null,null,null,3.58,21.479999999999997]
[12.3,0.2,null,null,null,null,null,null,null,null,null,2.4600000000000004,14.760000000000002]
[15.5,0.1,null,null,null,null,null,null,null,null,null,1.55,17.05]
[14.4,0.1,null,null,null,null,null,null,null,null,null,1.4400000000000002,15.84]
[1400,0.2,null,null,null,null,null,null,null,null,null,280,1680]
[]
["Berechne die Mehrwertsteuer und den Bruttopreis!"]

{"sheet":"Zinsen","index":7,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,0,1,4],[11,0,11,4],[12,0,12,4],[13,0,13,4]]}
[]
["Zinsen berechnen"]
["Name","Guthaben","Zinssatz","Zinsbetrag","Guthaben neu"]
["Anhalt",12458,2.5000000000000001E-2,null,null,null,null,null,null,null,null,{"$f":"B4*C4","v":311.45000000000005},{"$f":"L4+B4","v":12769.45}]
["Berndorfer",3455,1.2500000000000001E-2,null,null,null,null,null,null,null,null,{"$f":"B5*C5","v":43.1875},{"$f":"L5+B5","v":3498.1875}]
["Kringl",18346,1.4E-2,null,null,null,null,null,null,null,null,256.84399999999999,18602.844000000001]
["Landmann",2580,1.2E-2,null,null,null,null,null,null,null,null,30.96,2610.96]
["Sterndorfer",3145,-7.4999999999999997E-3,null,null,null,null,null,null,null,null,-23.587499999999999,3121.4124999999999]
["Zingel",28356,1.0999999999999999E-2,null,null,null,null,null,null,null,null,311.916,28667.916000000001]
[]
[]
["Multipliziere das Guthaben mit den Zinsatz und du erhältst den Zinsbetrag!"]
["Zinsbetrag: Das sind die Zinsen die du pro Jahr erhältst!"]
["Guthaben neu: Das ist das Guthaben vom Vorjahr plus den Zinsbetrag!"]