{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Aufgabe1","Aufgabe2","Aufgabe3","Aufgabe4"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Aufgabe1","index":0,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,1],[2,5,2,6]]}
["Provisionsberechnung"]
[]
["Name","Umsatz","Provisionssatz","Provision",null,"Provisionstabelle"]
["Meyer",285000,{"$f":"VLOOKUP(B4,$F$5:$G$16,2,1)","v":0.11},{"$f":"B4*C4","v":31350},null,"Umsatz","Provisionssatz"]
["Gruber",350000,{"$f":"VLOOKUP(B5,$F$5:$G$16,2,1)","v":0.15},{"$f":"B5*C5","v":52500},null,0,0]
["Tekin",300000,0.13,39000,null,50000,0.03]
["Westhausen",150000,7.0000000000000007E-2,10500.000000000002,null,100000,0.05]
["Hohmann",430000,0.17,73100,null,150000,7.0000000000000007E-2]
["Reichelt",560000,0.23,128800,null,200000,0.09]
["Wiesel",29000,0,0,null,250000,0.11]
["Bieber",470000,0.19,89300,null,300000,0.13]
["Kobener",140000,0.05,7000,null,350000,0.15]
["Willand",48000,0,0,null,400000,0.17]
["Balser",310000,0.13,40300,null,450000,0.19]
["Saripow",210000,0.09,18900,null,500000,0.21]
[null,null,null,null,null,550000,0.23]

{"sheet":"Aufgabe2","index":1,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,5,5,6]]}
[]
[null,null,"LKW-MAUT "]
[]
[null,"Schadstoffklasse","LKW bis zu ","LKW mit 4 ",null,"Die Felder F15 und F17 sollen berechnet werden."]
[null,null,"3 Achsen","und mehr Achsen"]
[null,"A",0.14099999999999999,0.155]
[null,"B",0.16900000000000001,0.183]
[null,"C",0.19,0.20399999999999999]
[null,"D",0.27400000000000002,0.28399999999999997]
[]
[]
[]
[null,"Kategorie:","C"]
[]
[null,"Achsen:",3,null,"Cent pro km:",{"$f":"IF(C13=\"\",\"\",IF(C15<=3,VLOOKUP(C13,B6:D9,2,0),VLOOKUP(C13,B6:D9,3,0)))","v":0.19}]
[]
[null,"Gefahrene km:",1000,null,"Gesamt:",{"$f":"IF(F15=\"\",\"\",C17*F15)","v":190}]

{"sheet":"Aufgabe3","index":2,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,3,0],[0,1,3,1],[6,3,16,7]]}
["Kneu =",{"$f":"Endkapital(Aufgabe4!B1,Aufgabe4!B2,Aufgabe4!B3)","v":5061.2760739840014},null,"Prozentrechnung","Zinsrechnung"]
[null,null,null,"Grundwert G","Kapital K"]
[null,null,null,"Prozentsatz p%","Zinssatz p%"]
[null,null,null,"Prozentwert W","Zinsen Z"]
[]
[]
[null,null,null,"Schreibe eine benutzerdefinierte Funktion, \nmit der man das Kapital in Abhängigkeit vom Anfangskapital, dem Zinssatz und dem Zeitraum der Anlage (hier: Jahre) berechnen kann. \nBenutze  zum Testen der Funktion in Zelle B1 die Werte aus dem Tabellenblatt: Aufgabe 4"]

{"sheet":"Aufgabe4","index":3,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":false,"merged":[[5,0,16,1],[5,3,16,7]]}
["Anfangskapital",4000,null,null,null,null,null,null,null,null,null,null,40]
["Zinssatz",{"$f":"M1/10","v":4}]
["Laufzeit in Jahren",6]
[]
[]
["Folgende Werte sollen per Schieberegler \neingegeben werden:\nZinssatz: 1 - 10 (in 0,1-Schritten)\nLaufzeit in Jahren: 1 - 30\n\nDas Anfangskapital wird direkt eingegeben.",null,null,"Wenn der Zinssatz weniger als 3%\nbeträgt, soll die Zelle B2 rot formatiert\nwerden.\nWenn der Zinssatz 3% - 5% beträgt, soll die Zelle B2 blau formatiert werden.\nWenn der Zinssatz mehr als 5% beträgt, soll die Zelle B2 grün formatiert werden."]