{"text_format":"1","workbook":"xlsx","n_sheets":44,"sheets":["Cover","WENN","UND","ODER","BEREICH.VERSCHIEBEN","MIN","MAX","SUMME","SUMMEWENN","SUMMEWENNS","DBSUMME","VERWEIS","SVERWEIS","WVERWEIS","VERGLEICH","INDEX","INDEX_2","KGRÖSSTE","KKLEINSTE","JAHR.MONAT.TAG","DATUM","KALENDERWOCHE","HEUTE","JETZT","ANZAHL","ZÄHLENWENN","ZÄHLENWENNS","ZEILE & SPALTE","ADRESSE","RMZ","BW","ZW","ZINS","ZINSZ","ZZR","NBW","LIA","DIA","GDA","GDA2","VDB","RUNDEN","AUFRUNDEN","ABRUNDEN"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":0,"defined_names":3,"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":"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","Wichtige Funktionen"]
[]
[null,"Inhalt","Funktionen für das Controlling:"]
[null,null,"Grundfunktionen"]
[null,null,"Summenfunktionen"]
[null,null,"Positionsfunktionen"]
[null,null,"Datumsfunktionen"]
[null,null,"Zählfunktionen"]
[null,null,"Barwertfunktionen"]
[null,null,"Abschreibungsfunktionen"]
[null,null,"Rundungsfunktionen"]
[]
[]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2019-01-01"]
[null,"Version","1.0"]
[]
[]
[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",{"$f":"SUM(B2:B5)","v":49070},{"$f":"SUM(C2:C5)","v":56810},{"$f":"SUM(D2:D5)","v":45820}]
[]
["Bedingung"]
[50000,{"$f":"IF(Gesamtumsatz>Bedingung,\"Ziel erreicht\",\"Ziel verfehlt\")","v":{"$error":"#NAME?"}},{"$f":"IF(Gesamtumsatz>Bedingung,\"Ziel erreicht\",\"Ziel verfehlt\")","v":{"$error":"#NAME?"}},{"$f":"IF(Gesamtumsatz>Bedingung,\"Ziel erreicht\",\"Ziel verfehlt\")","v":{"$error":"#NAME?"}}]

{"sheet":"UND","index":2,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Gebiet","Verkäufer","Umsatz","Bemerkung"]
["Nord","Schuster",21300]
["Süd","Bäcker",11500,"gefunden"]
["Ost","Schmied",10200]
["Ost","Schuster",9800]
["West","Bäcker",6700]
["Süd","Schmied",8300]
["Nord","Schuster",15400]
["Süd","Bäcker",15800,"gefunden"]
["West","Schmied",9400]
[]
[]
["Gebiet","Süd"]
["Verkäufer","Bäcker"]
["Umsatz",27300]

{"sheet":"ODER","index":3,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Gebiet","Umsatz","Bemerkung"]
["Nord",15000,{"$f":"IF(OR(Gebiet=Gebiet1,Gebiet=Gebiet2),\"gefunden\",\"\")","v":{"$error":"#NAME?"}}]
["Süd",9000,{"$f":"IF(OR(Gebiet=Gebiet1,Gebiet=Gebiet2),\"gefunden\",\"\")","v":{"$error":"#NAME?"}}]
["Ost",11000,{"$f":"IF(OR(Gebiet=Gebiet1,Gebiet=Gebiet2),\"gefunden\",\"\")","v":{"$error":"#NAME?"}}]
["Ost",12000,{"$f":"IF(OR(Gebiet=Gebiet1,Gebiet=Gebiet2),\"gefunden\",\"\")","v":{"$error":"#NAME?"}}]
["West",5500,{"$f":"IF(OR(Gebiet=Gebiet1,Gebiet=Gebiet2),\"gefunden\",\"\")","v":{"$error":"#NAME?"}}]
["Süd",8500,{"$f":"IF(OR(Gebiet=Gebiet1,Gebiet=Gebiet2),\"gefunden\",\"\")","v":{"$error":"#NAME?"}}]
["Nord",18000,{"$f":"IF(OR(Gebiet=Gebiet1,Gebiet=Gebiet2),\"gefunden\",\"\")","v":{"$error":"#NAME?"}}]
["Nord",16000,{"$f":"IF(OR(Gebiet=Gebiet1,Gebiet=Gebiet2),\"gefunden\",\"\")","v":{"$error":"#NAME?"}}]
["West",7000,{"$f":"IF(OR(Gebiet=Gebiet1,Gebiet=Gebiet2),\"gefunden\",\"\")","v":{"$error":"#NAME?"}}]
[]
[]
["Gebiet1","Nord"]
["Gebiet2","Ost"]
["Umsatz",{"$f":"SUMIF(Bemerkung,\"gefunden\",Umsatz)","v":{"$error":"#NAME?"}}]

{"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,"A",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",3]
[null,"Gesamtumsatz",{"$f":"SUM(OFFSET(Warengruppe,,Monat))","v":0}]
[]
["Umsatzermittlung für eine Warengruppe"]
[null,"WG-Position",4]
[null,"Gesamtumsatz",{"$f":"SUM(OFFSET(Quartal,Position,))","v":{"$error":"#NAME?"}}]

{"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",89]
["kleinster Wert aus P1 u. P3",98]
["kleinste Zahl > 300",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":{"$error":"#NAME?"}}]
["größter Wert aus P1 u. P3",{"$f":"MAX(Produkt1,Produkt3)","v":{"$error":"#NAME?"}}]
["größter Wert < 300",{"$f":"MAX(IF(Mengen<300,Mengen))","v":{"$error":"#NAME?"}},"  "]
["größter Wert zwischen 650 und 830",{"$f":"MAX(IF(Mengen>=650,IF(Mengen<=830,Mengen),))","v":{"$error":"#NAME?"}}]

{"sheet":"SUMME","index":7,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Warengruppe","Januar"]
["A",13200]
["B",15600]
["C",12500]
["D",7800]
["Gesamtumsatz",{"$f":"SUM(Januar)","v":{"$error":"#NAME?"}}]

{"sheet":"SUMMEWENN","index":8,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Auftraggeber","Umsatz"]
["A",10000]
["B",5000]
["C",25000]
["A",18500]
["C",3000]
[]
[]
["Kunde","A"]
["Umsatz",{"$f":"SUMIF(Auftraggeber,Kunde,Umsatz)","v":{"$error":"#NAME?"}}]
["Umsatz < 15000",{"$f":"SUMIF(Umsatz,\"<13500\")","v":{"$error":"#NAME?"}}]

{"sheet":"SUMMEWENNS","index":9,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Kunde","Land","Stadt","Jahresumsatz"]
["A","Deutschland","Berlin",750599]
["B","Österreich","Basel",298764]
["C","Schweiz","Zug",118563]
["D","Niederlande","Den Haag",55198]
["E","Deutschland","Frankfurt",861634]
["C","Frankreich","Lyon",1560678]
["D","Deutschland","Köln",46200]
["C","Schweiz","Bern",112456]
[]
[]
["Kunde","C"]
["Land","Schweiz"]
["Umsatz",231019]

{"sheet":"DBSUMME","index":10,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Kunde","Land","Stadt","Jahresumsatz","Aufträge"]
["A","Deutschland","Berlin",750599,6]
["B ","Schweiz","Zug",298764,3]
["C","Österreich","Wien",118563,2]
["D","Niederlande","Den Haag",55198,4]
["E","Deutschland","Frankfurt",861634,7]
["F","Frankreich","Lyon",1560678,9]
["G","Deutschland","Köln",46200,3]
["H","Belgien","Brüssel",643560,8]
[]
[]
["Kunde","Land","Stadt","Jahresumsatz","Aufträge"]
[null,"Deutschland",null,">500000",">5"]
[null,null,null,{"$f":"DSUM(_xlnm.Database,Suche,Kriterien)","v":{"$error":"#NAME?"}}]

{"sheet":"VERWEIS","index":11,"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",{"$f":"LOOKUP(Warengruppe1,Warengruppe,Januar)","v":{"$error":"#NAME?"}}]
[]
["Matrixversion"]
["Warengruppe","C"]
["Umsatz",{"$f":"LOOKUP(Warengruppe2,Matrix)","v":{"$error":"#NAME?"}}]

{"sheet":"SVERWEIS","index":12,"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",{"$f":"VLOOKUP(Warengruppe,Matrix,Monat+1,FALSE)","v":17450}]

{"sheet":"WVERWEIS","index":13,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Monat","A","B","C","D","Gesamtumsatz"]
["Januar",13450,18230,15440,9870,{"$f":"SUM(B2:E2)","v":56990}]
["Februar",14560,17450,16210,8730,{"$f":"SUM(B3:E3)","v":56950}]
["März",16340,15980,15390,8920,{"$f":"SUM(B4:E4)","v":56630}]
[]
[]
[]
["Suche"]
["Warengruppe","C"]
["Monatszahl",2]
["Umsatz",{"$f":"HLOOKUP(Warengruppe,Matrix,Monat+1,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"VERGLEICH","index":14,"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(Monat,Monate,0)","v":{"$error":"#NAME?"}}]
["Zeile WG",{"$f":"MATCH(Warengruppe,Warengruppen,0)","v":{"$error":"#NAME?"}}]
["Umsatz",{"$f":"INDEX(Matrix,ZeileW,SpalteM)","v":{"$error":"#NAME?"}}]

{"sheet":"INDEX","index":15,"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"]
["Monatszahl",2]
[]
["A","B","C","D"]
[{"$f":"INDEX(Matrix,COLUMN(),Monat+1)","v":14560},{"$f":"INDEX(Matrix,COLUMN(),Monat+1)","v":17450},{"$f":"INDEX(Matrix,COLUMN(),Monat+1)","v":16210},{"$f":"INDEX(Matrix,COLUMN(),Monat+1)","v":8730}]

{"sheet":"INDEX_2","index":16,"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",3]
["Produktnummer",2]
[]
["Erlöse",{"$f":"INDEX(ErlöseTabelle[],Produktnummer,Monatszahl+1,1)","v":{"$error":"#NAME?"}}]
["Kosten",{"$f":"INDEX(KostenTabelle[],Produktnummer,Monatszahl+1,1)","v":{"$error":"#NAME?"}}]
["Gewinn",{"$f":"Erlöse-Kosten","v":{"$error":"#NAME?"}}]

{"sheet":"KGRÖSSTE","index":17,"n_rows":14,"n_cols":4,"rows_kept":14,"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}]
[]
["Umsatzanalyse"]
["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(B11:B13)","v":52020}]

{"sheet":"KKLEINSTE","index":18,"n_rows":14,"n_cols":4,"rows_kept":14,"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}]
[]
["Umsatzanalyse"]
["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(B11:B13)","v":27520}]

{"sheet":"JAHR.MONAT.TAG","index":19,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Datum","Umsatz","Produkt","Jahr","Monat","Tag","Wochentag"]
["2018-02-12",21300,"P2",{"$f":"YEAR(Datum)","v":{"$error":"#NAME?"}},{"$f":"MONTH(Datum)","v":{"$error":"#NAME?"}},{"$f":"DAY(Datum)","v":{"$error":"#NAME?"}},{"$f":"Datum","v":{"$error":"#NAME?"}}]
["2018-03-16",35600,"P1",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
["2018-04-11",32700,"P3",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
["2018-05-15",28900,"P1",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
["2018-06-13",31200,"P2",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
["2018-07-17",29700,"P3",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]

{"sheet":"DATUM","index":20,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Kunde","Wert","Datum","Skonto","Dauer","Zahlungshöhe","Fälligkeit"]
["A",24300,"2018-01-21",0.02,34,{"$f":"Wert*(1-Skonto)","v":{"$error":"#NAME?"}},{"$f":"DATE(YEAR(Datum),MONTH(Datum), DAY(Datum)+Dauer)","v":{"$error":"#NAME?"}}]
["B",26700,"2018-01-12",0.03,12,{"$f":"Wert*(1-Skonto)","v":{"$error":"#NAME?"}},{"$f":"DATE(YEAR(Datum),MONTH(Datum), DAY(Datum)+Dauer)","v":{"$error":"#NAME?"}}]
["C",19800,"2018-01-19",0.02,18,{"$f":"Wert*(1-Skonto)","v":{"$error":"#NAME?"}},{"$f":"DATE(YEAR(Datum),MONTH(Datum), DAY(Datum)+Dauer)","v":{"$error":"#NAME?"}}]
["D",32100,"2018-01-28",0.04,9,{"$f":"Wert*(1-Skonto)","v":{"$error":"#NAME?"}},{"$f":"DATE(YEAR(Datum),MONTH(Datum), DAY(Datum)+Dauer)","v":{"$error":"#NAME?"}}]

{"sheet":"KALENDERWOCHE","index":21,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Datum","Umsatz","Produkt","Kalenderwoche"]
["2018-02-12",21300,"P2",{"$f":"WEEKNUM(TabelleKW[[#This Row],[Datum]],2)","v":7}]
["2018-03-16",35600,"P1",{"$f":"WEEKNUM(TabelleKW[[#This Row],[Datum]],2)","v":11}]
["2018-04-11",32700,"P3",{"$f":"WEEKNUM(TabelleKW[[#This Row],[Datum]],2)","v":15}]
["2018-05-15",28900,"P1",{"$f":"WEEKNUM(TabelleKW[[#This Row],[Datum]],2)","v":20}]
["2018-06-13",31200,"P2",{"$f":"WEEKNUM(TabelleKW[[#This Row],[Datum]],2)","v":24}]
["2018-07-17",29700,"P3",{"$f":"WEEKNUM(TabelleKW[[#This Row],[Datum]],2)","v":29}]

{"sheet":"HEUTE","index":22,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["ToDo","2018-09-17","2018-09-24","2018-10-01","2018-10-08"]
["A"]
["B"]
["C"]

{"sheet":"JETZT","index":23,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,{"$f":"NOW()","v":"2018-10-31T23:42:14.730"}]
[null,{"$f":"NOW()","v":"2018-10-31T23:42:14.730"}]

{"sheet":"ANZAHL","index":24,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Datum","Umsatz","Produkt"]
["2018-02-12",21300,"P2"]
["2018-03-16",35600,"P1"]
["2018-04-11",32700,"P3"]
["2018-04-21","storniert","P2"]
["2018-05-15",28900,"P1"]
["2018-06-13",31200,"P2"]
["2018-07-17",29700,"P3"]
[]
["Zählhilfe"]
["Anzahl Werte",{"$f":"COUNT(Umsatz)","v":0}]
["Anzahl Umsätze",{"$f":"COUNTA(Umsatz)","v":1}]
["Anzahl Produkte",{"$f":"COUNTA(Produkt)","v":1}]

{"sheet":"ZÄHLENWENN","index":25,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Datum","Umsatz","Produkt"]
["2018-02-12",21300,"P2"]
["2018-03-16",35600,"P1"]
["2018-04-11",32700,"P3"]
["2018-04-21","storniert","P2"]
["2018-05-15",28900,"P1"]
["2018-06-13",31200,"P2"]
["2018-07-17",29700,"P3"]
[]
["Zählhilfe"]
["Anzahl P2",{"$f":"COUNTIF(Produkt,\"P2\")","v":{"$error":"#NAME?"}}]
["Anzahl Umsatz>32000",{"$f":"COUNTIF(Umsatz,\">32000\")","v":{"$error":"#NAME?"}}]

{"sheet":"ZÄHLENWENNS","index":26,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Warengruppe","Januar","Februar","März"]
["A",13450,14560,19300]
["B",18230,17450,18350]
["C",15440,16210,15390]
["D",9870,8730,8920]
["E",12700,10300,17200]
["F",16700,12500,13300]
[]
["Anzahl Umsätze",{"$f":"COUNTIFS(Januar,\">=15000\",Februar,\">=16000\",März,\">=17000\")","v":{"$error":"#NAME?"}}]
["Jan=>15.000",{"$f":"COUNTIFS(Januar,\">=15000\")","v":{"$error":"#NAME?"}}]
["Feb=>16.000",{"$f":"COUNTIFS(Februar,\">=16000\")","v":{"$error":"#NAME?"}}]
["Mrz=>17.000",{"$f":"COUNTIFS(März,\">=17000\")","v":{"$error":"#NAME?"}}]

{"sheet":"ZEILE & SPALTE","index":27,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Monat","Produkt1","Produkt2","Produkt3"]
["Januar",432,1120,1436]
["Februar",382,null,234]
["März",611,105,656]
["April",160,213]
["Mai",988,899,256]
["Juni",743,654,347]
["Juli",854,436,675]
["August",812,1098,238]
["September",null,199,217]
["Oktober",366,437,459]
["November",310,565,378]
["Dezember",744,345,645]
[]
["Zeile","Spalte"]
[{"$f":"ROW($C$3)","v":3},{"$f":"COLUMN($C$3)","v":3}]
[{"$f":"ROW($D$5)","v":5},{"$f":"COLUMN($D$5)","v":4}]
[{"$f":"ROW($B$10)","v":10},{"$f":"COLUMN($B$10)","v":2}]

{"sheet":"ADRESSE","index":28,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Monat","Produkt1","Produkt2","Produkt3"]
["Januar",432,1120,1436]
["Februar",382,null,234]
["März",611,105,656]
["April",160,213]
["Mai",988,899,256]
["Juni",743,654,347]
["Juli",854,436,675]
["August",812,1098,238]
["September",null,199,217]
["Oktober",366,437,459]
["November",310,565,378]
["Dezember",744,345,645]

{"sheet":"RMZ","index":29,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Parameter","Wert"]
["Fälligkeit","1"]
["Restwert",8000]
["Zinssatz p.a.",3.5000000000000003E-2]
["Laufzeit in Monate",48]
["Kreditbetrag",50000]
["montl. Rate",{"$f":"PMT(Zinssatz/12,Laufzeit,Kreditbetrag,Restwert,Fälligkeit)","v":{"$error":"#NAME?"}}]

{"sheet":"BW","index":30,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Parameter","Wert"]
["Fälligkeit",1]
["monatliche Zahlung",600]
["Laufzeit in Monate",72]
["Zielwert",50000]
["Zins",9.0499999999999997E-2]
["Startkapital",{"$f":"PV(Zinssatz/12,Laufzeit,Zahlung*-1,Zielwert,Fälligkeit)","v":{"$error":"#NAME?"}}]

{"sheet":"ZW","index":31,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Parameter","Wert"]
["Fälligkeit",1]
["monatliche Zahlung",1200]
["Zinssatz p.a.",3.5000000000000003E-2]
["Laufzeit in Monate",48]
["Kreditbetrag",50000]
["Restwert",{"$f":"FV(Zinssatz/12,Laufzeit,Zahlung*-1,Kreditbetrag,Fälligkeit)","v":{"$error":"#NAME?"}}]

{"sheet":"ZINS","index":32,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Parameter","Wert"]
["Fälligkeit",1]
["monatl. Rate",1200]
["Restwert",4000]
["Laufzeit in Monate",48]
["Kreditbetrag",50000]
["geschätzter Zins",3.5000000000000003E-2]
["Zinssatz p.a.",{"$f":"RATE(Laufzeit,Zahlung*-1,Kreditbetrag,Restwert,Fälligkeit,Zins)*12","v":{"$error":"#NAME?"}}]

{"sheet":"ZINSZ","index":33,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Parameter","Wert"]
["Fälligkeit",1]
["monatl. Rate",1200]
["Zinssatz p.a.",3.5000000000000003E-2]
["Laufzeit in Monate",48]
["Kreditbetrag",50000]
["Restwert",4000]
[]
["Peroide",12]
["Zinsanteil  ",{"$f":"IPMT(Zinssatz/12,Periode,Laufzeit,Kreditbetrag,Restwert,Fälligkeit)","v":{"$error":"#NAME?"}}]

{"sheet":"ZZR","index":34,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Parameter","Wert"]
["Fälligkeit",1]
["monatl. Rate",600]
["Restwert",4000]
["Zins",3.5000000000000003E-2]
["Kreditbetrag",50000]
["Laufzeit in Monate",{"$f":"NPER(Zinssatz/12,Zahlung*-1,Kreditbetrag,Restwert,Fälligkeit)","v":{"$error":"#NAME?"}}]

{"sheet":"NBW","index":35,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Parameter","Wert",null,"Periode","Einzahlung","Auszahlung","Überschuss","Abzinssätze","Barwert"]
["Anschaffungskosten",50000,null,1,13500,8000,5500,0.96618357487922713,5314.0096618357493]
["kalkulatorischer Zinssatz",3.5000000000000003E-2,null,2,18200,8000,10200,0.93351070036640305,9521.8091437373114]
["Summe Barwerte",82261.375216602086,null,3,31600,8000,23600,0.90194270566802237,21285.847853765328]
["Kapitalwert",32261.375216602086,null,4,33700,8000,25700,0.87144222769857238,22396.06525185331]
[null,null,null,5,36200,8000,28200,0.84197316685852419,23743.643305410384]
[null,null,null,"Summen",{"$f":"SUM(E2:E6)","v":133200},{"$f":"SUM(F2:F6)","v":40000},{"$f":"SUM(G2:G6)","v":93200},null,82261.375216602086]
[]
[null,null,null,null,null,null,"NBW aus Tabelle:",null,32261.375216602086]
[null,null,null,null,null,null,"NBW aus Formel:",null,32261.375216602086]

{"sheet":"LIA","index":36,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Parameter","Wert"]
["Anschaffungskosten",22000]
["Restwert",1600]
["Nutzungsdauer",5]
["Abschreibungsbetrag",{"$f":"SLN(AnKosten,Restwert,Dauer)","v":{"$error":"#NAME?"}}]

{"sheet":"DIA","index":37,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Parameter","Wert"]
["Anschaffungskosten",22000]
["Restwert",1600]
["zu errechnender Zeitpunkt",3]
["Nutzungsdauer",6]
["Abschreibungsbetrag",{"$f":"SYD(AnKosten,Restwert,Dauer,Zeitpunkt)","v":{"$error":"#NAME?"}}]

{"sheet":"GDA","index":38,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Parameter","Wert"]
["Anschaffungskosten",27000]
["Restwert",2500]
["zu errechnender Zeitpunkt",3]
["Abschreibungsfaktor",1.5]
["Nutzungsdauer",6]
["Abschreibungsbetrag",3796.875]

{"sheet":"GDA2","index":39,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Parameter","Wert"]
["Anschaffungskosten",27000]
["Restwert",2500]
["zu errechnender Zeitpunkt",3]
["verbleibende Monate",8]
["Nutzungsdauer",6]
["Abschreibungsbetrag",4646.5790939999997]

{"sheet":"VDB","index":40,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Parameter","Wert"]
["Anschaffungskosten",22000]
["Restwert",2000]
["Anfangszeitpunkt",2]
["Ende",6]
["Faktor",1.5]
["Nutzungsdauer",10]
["kein Wechsel deg. zu lin.?",false]
["Abschreibungsbetrag",7685.7865000000011]

{"sheet":"RUNDEN","index":41,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Buchhaltungswerte",null,null,"gerundete Werte"]
["Parameter","Wert",null,"Parameter","Wert"]
["A",11786.34,null,"A",{"$f":"ROUND(Wert,-2)","v":{"$error":"#NAME?"}}]
["B",27456.55,null,"B",{"$f":"ROUND(Wert,-2)","v":{"$error":"#NAME?"}}]
["C",38123.56,null,"C",{"$f":"ROUND(Wert,-2)","v":{"$error":"#NAME?"}}]
["D",22598.560000000001,null,"D",{"$f":"ROUND(Wert,-2)","v":{"$error":"#NAME?"}}]
["E",19823.84,null,"E",{"$f":"ROUND(Wert,-2)","v":{"$error":"#NAME?"}}]

{"sheet":"AUFRUNDEN","index":42,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Buchhaltungswerte",null,null,"aufgerundete Werte"]
["Parameter","Wert",null,"Parameter","Wert"]
["A",11786.34,null,"A",{"$f":"ROUNDUP(Wert,-2)","v":{"$error":"#NAME?"}}]
["B",27456.55,null,"B",{"$f":"ROUNDUP(Wert,-2)","v":{"$error":"#NAME?"}}]
["C",38123.56,null,"C",{"$f":"ROUNDUP(Wert,-2)","v":{"$error":"#NAME?"}}]
["D",22598.560000000001,null,"D",{"$f":"ROUNDUP(Wert,-2)","v":{"$error":"#NAME?"}}]
["E",19823.84,null,"E",{"$f":"ROUNDUP(Wert,-2)","v":{"$error":"#NAME?"}}]

{"sheet":"ABRUNDEN","index":43,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Buchhaltungswerte",null,null,"abgerundete Werte"]
["Parameter","Wert",null,"Parameter","Wert"]
["A",11786.34,null,"A",{"$f":"ROUNDDOWN(Wert,-2)","v":{"$error":"#NAME?"}}]
["B",27456.55,null,"B",{"$f":"ROUNDDOWN(Wert,-2)","v":{"$error":"#NAME?"}}]
["C",38123.56,null,"C",{"$f":"ROUNDDOWN(Wert,-2)","v":{"$error":"#NAME?"}}]
["D",22598.560000000001,null,"D",{"$f":"ROUNDDOWN(Wert,-2)","v":{"$error":"#NAME?"}}]
["E",19823.84,null,"E",{"$f":"ROUNDDOWN(Wert,-2)","v":{"$error":"#NAME?"}}]