{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Cover","VERWEIS","SVERWEIS","XVERWEIS","VERGLEICH","INDEX","INDEX_2","KGRÖSSTE","KKLEINSTE"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":6,"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":"Cover","index":0,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Excel + VBA "]
[null,"für Controller"]
[]
[]
[null,"Kapitel",3]
[null,"Thema","Formeln und Funktionen"]
[]
[null,"Inhalt","Suchfunktionen"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Version","1.0"]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2025-04-25"]
[]
[]
[null,"Springer Verlag"]

{"sheet":"VERWEIS","index":1,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Warengruppe","Januar","Februar","März"]
["A",13450,14560,16340]
["B",18230,17450,15980]
["C",15440,16210,15390]
["D",9870,8730,8920]
["Gesamtumsatz"]
[]
["Vektorversion"]
["Warengruppe","A"]
["Monat","Januar"]
["Umsatz",13450]
[]
["Matrixversion"]
["Warengruppe","C"]
["Umsatz",15390]

{"sheet":"SVERWEIS","index":2,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Warengruppe","Januar","Februar","März"]
["A",13450,14560,16340]
["B",18230,17450,15980]
["C",15440,16210,15390]
["D",9870,8730,8920]
["Gesamtumsatz",{"$f":"SUM(B2:B5)","v":56990},{"$f":"SUM(C2:C5)","v":56950},{"$f":"SUM(D2:D5)","v":56630}]
[]
["Suche"]
["Warengruppe","B"]
["Monatszahl",2]
["Umsatz",17450]

{"sheet":"XVERWEIS","index":3,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Januar","Februar","März","Warengruppe"]
[13450,14560,16340,"A"]
[18230,17450,15980,"B"]
[15440,16210,15390,"C"]
[9870,8730,8920,"D"]
[{"$f":"SUM(A2:A5)","v":56990},{"$f":"SUM(B2:B5)","v":56950},{"$f":"SUM(C2:C5)","v":56630},"Gesamtumsatz"]
[]
["Suche"]
["WGruppe","C"]
["Monat","Januar","Februar","März"]
["Umsatz",{"$f":"_xlfn.XLOOKUP(WGruppe,Warengruppe,Umsatz)","v":{"$error":"#NAME?"}}]

{"sheet":"VERGLEICH","index":4,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Warengruppe","Januar","Februar","März"]
["A",13450,14560,16340]
["B",18230,17450,15980]
["C",15440,16210,15390]
["D",9870,8730,8920]
["Gesamtumsatz",{"$f":"SUM(B2:B5)","v":56990},{"$f":"SUM(C2:C5)","v":56950},{"$f":"SUM(D2:D5)","v":56630}]
[]
["Suche"]
["Monat ","März"]
["Warengruppe","C"]
["Spalte Monat",{"$f":"MATCH(_xlfn.SINGLE(Monat),Monate,0)","v":{"$error":"#NAME?"}}]
["Zeile WG",{"$f":"MATCH(WGruppe,Warengruppe,0)","v":{"$error":"#NAME?"}}]
["Umsatz",{"$f":"INDEX(Matrix,ZeileW,SpalteM)","v":{"$error":"#NAME?"}}]

{"sheet":"INDEX","index":5,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Warengruppe","Januar","Februar","März"]
["A",13450,14560,16340]
["B",18230,17450,15980]
["C",15440,16210,15390]
["D",9870,8730,8920]
["Gesamtumsatz",{"$f":"SUM(B2:B5)","v":56990},{"$f":"SUM(C2:C5)","v":56950},{"$f":"SUM(D2:D5)","v":56630}]
[]
["Diagrammvorlage"]
["Monat",2]
[]
["A","B","C","D"]
[{"$f":"_xlfn.SINGLE(INDEX(Matrix,COLUMN(),_xlfn.SINGLE(Monat)+1))","v":14560},{"$f":"_xlfn.SINGLE(INDEX(Matrix,COLUMN(),_xlfn.SINGLE(Monat)+1))","v":17450},{"$f":"_xlfn.SINGLE(INDEX(Matrix,COLUMN(),_xlfn.SINGLE(Monat)+1))","v":16210},{"$f":"_xlfn.SINGLE(INDEX(Matrix,COLUMN(),_xlfn.SINGLE(Monat)+1))","v":8730}]

{"sheet":"INDEX_2","index":6,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Erlöse","Januar","Februar","März"]
["Produkt 1",24300,22800,25100]
["Produkt 2",29800,27900,26200]
["Produkt 3",15600,26300,27300]
["Gesamterlöse",{"$f":"SUM(B2:B4)","v":69700},{"$f":"SUM(C2:C4)","v":77000},{"$f":"SUM(D2:D4)","v":78600}]
[]
["Kosten","Januar","Februar","März"]
["Produkt 1",22300,19800,20100]
["Produkt 2",21000,21200,21000]
["Produkt 3",23700,23900,24500]
["Gesamtkosten",{"$f":"SUM(B8:B10)","v":67000},{"$f":"SUM(C8:C10)","v":64900},{"$f":"SUM(D8:D10)","v":65600}]
[]
["Gewinnanalyse"]
["Monatszahl",2]
["Produktnummer",2]
[]
["Erlöse",{"$f":"INDEX(ErlöseTab,Produktnummer+1,Monatszahl+1,1)","v":{"$error":"#NAME?"}}]
["Kosten",{"$f":"INDEX(KostenTab,Produktnummer+1,Monatszahl+1,1)","v":{"$error":"#NAME?"}}]
["Gewinn",{"$f":"Erlöse-Kosten","v":{"$error":"#NAME?"}}]

{"sheet":"KGRÖSSTE","index":7,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Warengruppe","Januar","Februar","März"]
["A",13450,14560,16340]
["B",18230,17450,15980]
["C",15440,16210,15390]
["D",9870,8730,8920]
["E",12700,10300,11600]
["F",16700,12500,13300]
["Gesamtumsatz",{"$f":"SUM(B2:B7)","v":86390},{"$f":"SUM(C2:C7)","v":79750},{"$f":"SUM(D2:D7)","v":81530}]
[]
["größter Umsatz",{"$f":"LARGE(Matrix,1)","v":18230}]
["2.größter Umsatz",{"$f":"LARGE(Matrix,2)","v":17450}]
["3.größter Umsatz",{"$f":"LARGE(Matrix,3)","v":16340}]
["Top3",{"$f":"SUM(B10:B12)","v":52020}]

{"sheet":"KKLEINSTE","index":8,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Warengruppe","Januar","Februar","März"]
["A",13450,14560,16340]
["B",18230,17450,15980]
["C",15440,16210,15390]
["D",9870,8730,8920]
["E",12700,10300,11600]
["F",16700,12500,13300]
["Gesamtumsatz",{"$f":"SUM(B2:B7)","v":86390},{"$f":"SUM(C2:C7)","v":79750},{"$f":"SUM(D2:D7)","v":81530}]
[]
["niedrigster Umsatz",{"$f":"SMALL(Matrix,1)","v":8730}]
["2.niedrigster Umsatz",{"$f":"SMALL(Matrix,2)","v":8920}]
["3.niedrigster Umsatz",{"$f":"SMALL(Matrix,3)","v":9870}]
["Down3",{"$f":"SUM(B10:B12)","v":27520}]