{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Cover","WENN","UND","ODER","BEREICH.VERSCHIEBEN","MIN","MAX"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"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","Grundfunktionen"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Version","1.0"]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2025-04-25"]
[]
[]
[null,"Springer Verlag"]

{"sheet":"WENN","index":1,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Warengruppe","Januar","Februar","März"]
["A",12500,15340,12460]
["B",16790,16780,13540]
["C",10890,15460,12390]
["D",8890,9230,7430]
["Gesamtumsatz",49070,56810,45820]
[]
["Bedingung"]
[50000,"Ziel verfehlt","Ziel erreicht","Ziel verfehlt"]

{"sheet":"UND","index":2,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Gebiet1","Verkäufer1","Umsatz1","Bemerkung1"]
["Nord","Schuster",21300,{"$f":"IF(AND(Gebiet1.1=Gebiet1,Verkäufer1.1= Verkäufer1),\"gefunden\",\"\")","v":{"$error":"#NAME?"}}]
["Süd","Bäcker",11500,{"$f":"IF(AND(Gebiet1.1=Gebiet1,Verkäufer1.1= Verkäufer1),\"gefunden\",\"\")","v":{"$error":"#NAME?"}}]
["Ost","Schmied",10200,{"$f":"IF(AND(Gebiet1.1=Gebiet1,Verkäufer1.1= Verkäufer1),\"gefunden\",\"\")","v":{"$error":"#NAME?"}}]
["Ost","Schuster",9800,{"$f":"IF(AND(Gebiet1.1=Gebiet1,Verkäufer1.1= Verkäufer1),\"gefunden\",\"\")","v":{"$error":"#NAME?"}}]
["West","Bäcker",6700,{"$f":"IF(AND(Gebiet1.1=Gebiet1,Verkäufer1.1= Verkäufer1),\"gefunden\",\"\")","v":{"$error":"#NAME?"}}]
["Süd","Schmied",8300,{"$f":"IF(AND(Gebiet1.1=Gebiet1,Verkäufer1.1= Verkäufer1),\"gefunden\",\"\")","v":{"$error":"#NAME?"}}]
["Nord","Schuster",15400,{"$f":"IF(AND(Gebiet1.1=Gebiet1,Verkäufer1.1= Verkäufer1),\"gefunden\",\"\")","v":{"$error":"#NAME?"}}]
["Süd","Bäcker",15800,{"$f":"IF(AND(Gebiet1.1=Gebiet1,Verkäufer1.1= Verkäufer1),\"gefunden\",\"\")","v":{"$error":"#NAME?"}}]
["West","Schmied",9400,{"$f":"IF(AND(Gebiet1.1=Gebiet1,Verkäufer1.1= Verkäufer1),\"gefunden\",\"\")","v":{"$error":"#NAME?"}}]
[]
["Gebiet1.1","Süd"]
["Verkäufer1.1","Bäcker"]
["Umsatz",{"$f":"SUMIF(Bemerkung1,\"gefunden\",Umsatz1)","v":{"$error":"#NAME?"}}]

{"sheet":"ODER","index":3,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Gebiet2","Umsatz2","Bemerkung2"]
["Nord",15000,"gefunden"]
["Süd",9000]
["Ost",11000,"gefunden"]
["Ost",12000,"gefunden"]
["West",5500]
["Süd",8500]
["Nord",18000,"gefunden"]
["Nord",16000,"gefunden"]
["West",7000]
[]
["Gebiet2.1","Nord"]
["Gebiet2.2","Ost"]
["Umsatz",72000]

{"sheet":"BEREICH.VERSCHIEBEN","index":4,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Pos","Warengruppe","Januar","Februar","März"]
[1,3,23100,15300,19500]
[2,"B",18500,16200,17100]
[3,"C",16300,11400,15300]
[4,"D",7600,8700,9700]
[]
["Umsatzermittlung für einen Monat"]
[null,"Monat als Zahl",1]
[null,"Gesamtumsatz",61600]
[]
["Umsatzermittlung für eine Warengruppe"]
[null,"WG-Position",3]
[null,"Gesamtumsatz",43000]

{"sheet":"MIN","index":5,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Monat","Produkt1","Produkt2","Produkt3"]
["Januar",432,1120,1436]
["Februar",382,89,234]
["März",611,105,656]
["April",160,213,98]
["Mai",988,899,256]
["Juni",743,654,347]
["Juli",854,436,675]
["August",812,1098,238]
["September",102,199,217]
["Oktober",366,437,459]
["November",310,565,378]
["Dezember",744,345,645]
[]
["Stückzahlenanalyse"]
["kleinster Wert aus allen",{"$f":"MIN(Mengen)","v":89}]
["kleinster Wert aus P1 u. P3",{"$f":"MIN(Produkt1,Produkt3)","v":98}]
["kleinste Zahl > 300",{"$f":"MIN(IF(Mengen>300,Mengen))","v":310}]

{"sheet":"MAX","index":6,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Monat","Produkt1","Produkt2","Produkt3"]
["Januar",432,1120,1436]
["Februar",382,89,234]
["März",611,105,656]
["April",160,213,98]
["Mai",988,899,256]
["Juni",743,654,347]
["Juli",854,436,675]
["August",812,1098,238]
["September",102,199,217]
["Oktober",366,437,459]
["November",310,565,378]
["Dezember",744,345,645]
[]
["Stückzahlenanalyse"]
["größter Wert aus allen",{"$f":"MAX(Mengen)","v":1436}]
["größter Wert aus P1 u. P3",{"$f":"MAX(Produkt1,Produkt3)","v":1436}]
["größter Wert < 300",{"$f":"MAX(IF(Mengen<300,Mengen))","v":256},"  "]
["größter Wert zwischen 650 und 830",{"$f":"MAX(IF(Mengen>=650,IF(Mengen<=830,Mengen),))","v":812}]