{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Startseite","So bedienen Sie das Tool","Definitionen","Kredite","NeutralerBereich","Liquiditätsplan","Anwenderhilfe für Excel","Grafik","FinanzielleMobilität","Lieferung_Leistung","Vermietung_Verpachtung","Sachvermögen","SonstigeEinnahmen","Personal","Material","Investitionsplan","Ausgaben","TabVorlage"],"not_rendered":{"charts":2,"images":14,"macros":1,"external_links":0,"defined_names":19,"comments":2,"pivot_tables":0},"unopened":[{"sheet":"Grafik","index":7,"reason":"not_a_worksheet"}],"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":"Startseite","index":0,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,2,2,8],[0,9,2,10]]}
[null,null,"Liquiditätsplanung"]
[]
[]
[]
[null,null,"Susanne Kowalski",null,null,null,null,2021]
[]
[null,null," Liquiditätsplanung"]
[]
[]
[]
[]
[]
[null,null,null,"Allgemein",null,"Einnahmen",null,null,"Ausgaben",null,null,"Übersicht"]
[]
[]
[null,null,null,">>Definitionen",null,">> Lieferung und Leistung",null,null,">> Personal",null,null,">>Liquiditätsplan"]
[]
[null,null,null,">> Kredite",null,">> Vermietung und Verpachtung",null,null,">> Material",null,null,">> Finanzielle Mobilität"]
[]
[null,null,null,">> Neutraler Bereich",null,">> Veräußerung von Sachvermögen",null,null,">> Investitionen"]
[]
[null,null,null,null,null,">> Sonstiges",null,null,">> Sonstiges"]

{"sheet":"So bedienen Sie das Tool","index":1,"n_rows":55,"n_cols":14,"rows_kept":55,"cut":false,"hidden":true,"merged":[[0,0,2,8]]}
["So bedienen Sie das Tool"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Start"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"zurück zum Anfang dieser Seite"]

{"sheet":"Definitionen","index":2,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Definitionen"]
[]
["Produkte / Leistungen",null,"Ausgabenrubriken",null,"Banken",null,"Anfangsbestand"]
[]
["Produktgruppe 1",null,"Verwaltung",null,"Bank 1",null,34000]
["Produktgruppe 2",null,"Mieten / Pachten / Leasing"]
["Produktgruppe 3",null,"Fuhrpark"]
["Produktgruppe 4",null,"Versicherungen"]
["Produktgruppe 5",null,"Steuern und Abgaben"]
["Produktgruppe 6",null,"Personal"]
["Produktgruppe 7",null,"Material"]
["Produktgruppe 8",null,"Investitionen",null,"Kassenbestand"]
["Produktgruppe 9",null,"Finanzierung"]
["Produktgruppe 10",null,"Weitere Ausgaben"]
["Produktgruppe 11",null,"Ausgaben Neutraler Bereich"]
["Produktgruppe 12"]
["Produktgruppe 13"]
["Produktgruppe 14"]
["Produktgruppe 15"]
["Produktgruppe 16"]
["Produktgruppe 17"]
["Produktgruppe 18"]
["Produktgruppe 19"]
["Produktgruppe 20"]
["Produktgruppe 21"]
["Produktgruppe 22"]
["Produktgruppe 23"]
["Produktgruppe 24"]
["Produktgruppe 25"]
["Produktgruppe 26"]
["Produktgruppe 27"]
["Produktgruppe 28"]
["Produktgruppe 29"]
["Produktgruppe 30"]
[]
[]
["Start"]

{"sheet":"Kredite","index":3,"n_rows":28,"n_cols":15,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,1,1,13],[15,1,15,13]]}
["Kreditplaner",null,null,null,null,null,null,null,null,null,null,null,null,null,"Start"]
[null,"Ausgaben für Zinsen und Tilgung"]
["Aufgenommene Kredite / Darlehen","Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember",{"$f":"\"Gesamt \"&Startseite!H5","v":"Gesamt 2021"}]
["KFW",4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,{"$f":"SUM(B4:M4)","v":48000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B5:M5)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B6:M6)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B7:M7)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B8:M8)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B9:M9)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Ausgaben Kredite / Gesamt",{"$f":"SUM(B4:B13)","v":4000},{"$f":"SUM(C4:C13)","v":4000},4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,48000]
[]
[null,"Einnahmen durch Kreditaufnahme"]
["Geplante Kredite"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B18:M18)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Einnahmen Kredite Gesamt",{"$f":"SUM(B18:B27)","v":0},{"$f":"SUM(C18:C27)","v":0},0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"NeutralerBereich","index":4,"n_rows":30,"n_cols":14,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Neutraler Bereich",null,null,null,null,null,null,null,null,null,null,null,null,"Start"]
[]
["Einnahmen, gesamt",{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Ausgaben, gesamt"]
[null,"Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember"]
["Einnahmen"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Summe Einnahmen",{"$f":"SUM(B7:B16)","v":0},{"$f":"SUM(C7:C16)","v":0},0,0,0,0,0,0,0,0,0,0]
["Ausgaben"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Summe Ausgaben",{"$f":"SUM(B19:B28)","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Saldo",{"$f":"+B17-B29","v":0},{"$f":"+C17-C29","v":0},0,0,0,0,0,0,0,0,0,0]

{"sheet":"Liquiditätsplan","index":5,"n_rows":54,"n_cols":14,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Liquiditätsplan",null,null,null,null,null,null,null,null,null,null,null,null,"Start"]
[]
["Zeitintervall in Monaten","Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember"]
["Anfangsbestand ",{"$f":"B12","v":34000},{"$f":"B35","v":42000},44000,43000,45000,35000,37000,41000,43000,41000,43000,50000]
[]
["Kasse",{"$f":"Definitionen!G12","v":0}]
[{"$f":"Definitionen!E5","v":"Bank 1"},{"$f":"Definitionen!G5","v":34000}]
[{"$f":"Definitionen!E6","v":0},{"$f":"Definitionen!G6","v":0}]
[{"$f":"Definitionen!E7","v":0},{"$f":"Definitionen!G7","v":0}]
[{"$f":"Definitionen!E8","v":0},{"$f":"Definitionen!G8","v":0}]
[{"$f":"Definitionen!E9","v":0},{"$f":"Definitionen!G9","v":0}]
[null,{"$f":"SUM(B6:B11)","v":34000}]
["Einzahlungen"]
["Einnahmen aus Lieferung und Leistung",{"$f":"Lieferung_Leistung!F44","v":25000},{"$f":"Lieferung_Leistung!G44","v":19000},{"$f":"Lieferung_Leistung!H44","v":16000},{"$f":"Lieferung_Leistung!I44","v":19000},{"$f":"Lieferung_Leistung!J44","v":17000},{"$f":"Lieferung_Leistung!K44","v":19000},{"$f":"Lieferung_Leistung!L44","v":21000},{"$f":"Lieferung_Leistung!M44","v":19000},{"$f":"Lieferung_Leistung!N44","v":15000},{"$f":"Lieferung_Leistung!O44","v":19000},{"$f":"Lieferung_Leistung!P44","v":19000},{"$f":"Lieferung_Leistung!Q44","v":19000}]
["Einnahmen aus Vermietung und Verpachtung",{"$f":"Vermietung_Verpachtung!B19","v":1000},{"$f":"Vermietung_Verpachtung!C19","v":1000},{"$f":"Vermietung_Verpachtung!D19","v":1000},{"$f":"Vermietung_Verpachtung!E19","v":1000},{"$f":"Vermietung_Verpachtung!F19","v":1000},{"$f":"Vermietung_Verpachtung!G19","v":1000},{"$f":"Vermietung_Verpachtung!H19","v":1000},{"$f":"Vermietung_Verpachtung!I19","v":1000},{"$f":"Vermietung_Verpachtung!J19","v":1000},{"$f":"Vermietung_Verpachtung!K19","v":1000},{"$f":"Vermietung_Verpachtung!L19","v":1000},{"$f":"Vermietung_Verpachtung!M19","v":1000}]
["Veräußerung von Sachvermögen",{"$f":"Sachvermögen!B19","v":0},{"$f":"Sachvermögen!C19","v":0},{"$f":"Sachvermögen!D19","v":0},{"$f":"Sachvermögen!E19","v":0},{"$f":"Sachvermögen!F19","v":0},{"$f":"Sachvermögen!G19","v":0},{"$f":"Sachvermögen!H19","v":0},{"$f":"Sachvermögen!I19","v":0},{"$f":"Sachvermögen!J19","v":0},{"$f":"Sachvermögen!K19","v":0},{"$f":"Sachvermögen!L19","v":5000},{"$f":"Sachvermögen!M19","v":0}]
["Kreditaufnahme",{"$f":"Kredite!B28","v":0},{"$f":"Kredite!C28","v":0},{"$f":"Kredite!D28","v":0},{"$f":"Kredite!E28","v":0},{"$f":"Kredite!F28","v":0},{"$f":"Kredite!G28","v":0},{"$f":"Kredite!H28","v":0},{"$f":"Kredite!I28","v":0},{"$f":"Kredite!J28","v":0},{"$f":"Kredite!K28","v":0},{"$f":"Kredite!L28","v":0},{"$f":"Kredite!M28","v":0}]
["Sonstige Einnahmen",{"$f":"SonstigeEinnahmen!B40","v":0},{"$f":"SonstigeEinnahmen!C40","v":0},{"$f":"SonstigeEinnahmen!D40","v":0},{"$f":"SonstigeEinnahmen!E40","v":0},{"$f":"SonstigeEinnahmen!F40","v":0},{"$f":"SonstigeEinnahmen!G40","v":0},{"$f":"SonstigeEinnahmen!H40","v":0},{"$f":"SonstigeEinnahmen!I40","v":0},{"$f":"SonstigeEinnahmen!J40","v":0},{"$f":"SonstigeEinnahmen!K40","v":0},{"$f":"SonstigeEinnahmen!L40","v":0},{"$f":"SonstigeEinnahmen!M40","v":0}]
["Neutraler Bereich",{"$f":"NeutralerBereich!B17","v":0},{"$f":"NeutralerBereich!C17","v":0},{"$f":"NeutralerBereich!D17","v":0},{"$f":"NeutralerBereich!E17","v":0},{"$f":"NeutralerBereich!F17","v":0},{"$f":"NeutralerBereich!G17","v":0},{"$f":"NeutralerBereich!H17","v":0},{"$f":"NeutralerBereich!I17","v":0},{"$f":"NeutralerBereich!J17","v":0},{"$f":"NeutralerBereich!K17","v":0},{"$f":"NeutralerBereich!L17","v":0},{"$f":"NeutralerBereich!M17","v":0}]
["Summe Einzahlungen",{"$f":"SUM(B14:B18)","v":26000},20000,17000,20000,18000,20000,22000,20000,16000,20000,25000,20000]
["Ausgaben"]
["Personal",{"$f":"Personal!B50","v":14000},{"$f":"Personal!C50","v":14000},{"$f":"Personal!D50","v":14000},{"$f":"Personal!E50","v":14000},{"$f":"Personal!F50","v":14000},{"$f":"Personal!G50","v":14000},{"$f":"Personal!H50","v":14000},{"$f":"Personal!I50","v":14000},{"$f":"Personal!J50","v":14000},{"$f":"Personal!K50","v":14000},{"$f":"Personal!L50","v":14000},{"$f":"Personal!M50","v":14000}]
["Material",{"$f":"Material!B52","v":0},{"$f":"Material!C52","v":0},{"$f":"Material!D52","v":0},{"$f":"Material!E52","v":0},{"$f":"Material!F52","v":0},{"$f":"Material!G52","v":0},{"$f":"Material!H52","v":0},{"$f":"Material!I52","v":0},{"$f":"Material!J52","v":0},{"$f":"Material!K52","v":0},{"$f":"Material!L52","v":0},{"$f":"Material!M52","v":0}]
[{"$f":"Definitionen!C5","v":"Verwaltung"},{"$f":"Ausgaben!B9","v":0},{"$f":"Ausgaben!C9","v":0},{"$f":"Ausgaben!D9","v":0},{"$f":"Ausgaben!E9","v":0},{"$f":"Ausgaben!F9","v":0},{"$f":"Ausgaben!G9","v":0},{"$f":"Ausgaben!H9","v":0},{"$f":"Ausgaben!I9","v":0},{"$f":"Ausgaben!J9","v":0},{"$f":"Ausgaben!K9","v":0},{"$f":"Ausgaben!L9","v":0},{"$f":"Ausgaben!M9","v":0}]
[{"$f":"Definitionen!C6","v":"Mieten / Pachten / Leasing"},{"$f":"Ausgaben!B16","v":0},{"$f":"Ausgaben!C16","v":0},{"$f":"Ausgaben!D16","v":0},{"$f":"Ausgaben!E16","v":0},{"$f":"Ausgaben!F16","v":0},{"$f":"Ausgaben!G16","v":0},{"$f":"Ausgaben!H16","v":0},{"$f":"Ausgaben!I16","v":0},{"$f":"Ausgaben!J16","v":0},{"$f":"Ausgaben!K16","v":0},{"$f":"Ausgaben!L16","v":0},{"$f":"Ausgaben!M16","v":0}]
[{"$f":"Definitionen!C7","v":"Fuhrpark"},{"$f":"Ausgaben!B23","v":0},{"$f":"Ausgaben!C23","v":0},{"$f":"Ausgaben!D23","v":0},{"$f":"Ausgaben!E23","v":0},{"$f":"Ausgaben!F23","v":0},{"$f":"Ausgaben!G23","v":0},{"$f":"Ausgaben!H23","v":0},{"$f":"Ausgaben!I23","v":0},{"$f":"Ausgaben!J23","v":0},{"$f":"Ausgaben!K23","v":0},{"$f":"Ausgaben!L23","v":0},{"$f":"Ausgaben!M23","v":0}]
[{"$f":"Definitionen!C8","v":"Versicherungen"},{"$f":"Ausgaben!B30","v":0},{"$f":"Ausgaben!C30","v":0},{"$f":"Ausgaben!D30","v":0},{"$f":"Ausgaben!E30","v":0},{"$f":"Ausgaben!F30","v":0},{"$f":"Ausgaben!G30","v":0},{"$f":"Ausgaben!H30","v":0},{"$f":"Ausgaben!I30","v":0},{"$f":"Ausgaben!J30","v":0},{"$f":"Ausgaben!K30","v":0},{"$f":"Ausgaben!L30","v":0},{"$f":"Ausgaben!M30","v":0}]
[{"$f":"Definitionen!C9","v":"Steuern und Abgaben"},{"$f":"Ausgaben!B37","v":0},{"$f":"Ausgaben!C37","v":0},{"$f":"Ausgaben!D37","v":0},{"$f":"Ausgaben!E37","v":0},{"$f":"Ausgaben!F37","v":0},{"$f":"Ausgaben!G37","v":0},{"$f":"Ausgaben!H37","v":0},{"$f":"Ausgaben!I37","v":0},{"$f":"Ausgaben!J37","v":0},{"$f":"Ausgaben!K37","v":0},{"$f":"Ausgaben!L37","v":0},{"$f":"Ausgaben!M37","v":0}]
["Investitionen",{"$f":"Investitionsplan!B40","v":0},{"$f":"Investitionsplan!C40","v":0},{"$f":"Investitionsplan!D40","v":0},{"$f":"Investitionsplan!E40","v":0},{"$f":"Investitionsplan!F40","v":10000},{"$f":"Investitionsplan!G40","v":0},{"$f":"Investitionsplan!H40","v":0},{"$f":"Investitionsplan!I40","v":0},{"$f":"Investitionsplan!J40","v":0},{"$f":"Investitionsplan!K40","v":0},{"$f":"Investitionsplan!L40","v":0},{"$f":"Investitionsplan!M40","v":0}]
["Finanzierung",{"$f":"Kredite!B14","v":4000},{"$f":"Kredite!C14","v":4000},{"$f":"Kredite!D14","v":4000},{"$f":"Kredite!E14","v":4000},{"$f":"Kredite!F14","v":4000},{"$f":"Kredite!G14","v":4000},{"$f":"Kredite!H14","v":4000},{"$f":"Kredite!I14","v":4000},{"$f":"Kredite!J14","v":4000},{"$f":"Kredite!K14","v":4000},{"$f":"Kredite!L14","v":4000},{"$f":"Kredite!M14","v":4000}]
["Sonstige Ausgaben",{"$f":"Ausgaben!B49","v":0},{"$f":"Ausgaben!C49","v":0},{"$f":"Ausgaben!D49","v":0},{"$f":"Ausgaben!E49","v":0},{"$f":"Ausgaben!F49","v":0},{"$f":"Ausgaben!G49","v":0},{"$f":"Ausgaben!H49","v":0},{"$f":"Ausgaben!I49","v":0},{"$f":"Ausgaben!J49","v":0},{"$f":"Ausgaben!K49","v":0},{"$f":"Ausgaben!L49","v":0},{"$f":"Ausgaben!M49","v":0}]
["Neutraler Bereich",{"$f":"NeutralerBereich!B29","v":0},{"$f":"NeutralerBereich!C29","v":0},{"$f":"NeutralerBereich!D29","v":0},{"$f":"NeutralerBereich!E29","v":0},{"$f":"NeutralerBereich!F29","v":0},{"$f":"NeutralerBereich!G29","v":0},{"$f":"NeutralerBereich!H29","v":0},{"$f":"NeutralerBereich!I29","v":0},{"$f":"NeutralerBereich!J29","v":0},{"$f":"NeutralerBereich!K29","v":0},{"$f":"NeutralerBereich!L29","v":0},{"$f":"NeutralerBereich!M29","v":0}]
["Summe Ausgaben",{"$f":"SUM(B22:B31)","v":18000},18000,18000,18000,28000,18000,18000,18000,18000,18000,18000,18000]
[]
["Endbestand",{"$f":"+B4+B20-B33","v":42000},{"$f":"B35+C20-C33","v":44000},{"$f":"+D4+D20-D33","v":43000},45000,35000,37000,41000,43000,41000,43000,50000,52000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember"]
["Einzahlungen",{"$f":"B20","v":26000},{"$f":"C20","v":20000},17000,20000,18000,20000,22000,20000,16000,20000,25000,20000]
["Auszahlungen",{"$f":"B33","v":18000},{"$f":"C33","v":18000},18000,18000,28000,18000,18000,18000,18000,18000,18000,18000]
["Saldo unter Berücksichtigung der Anfangsbestände",{"$f":"B35","v":42000},{"$f":"C35","v":44000},43000,45000,35000,37000,41000,43000,41000,43000,50000,52000]

{"sheet":"Anwenderhilfe für Excel","index":6,"n_rows":108,"n_cols":6,"rows_kept":108,"cut":false,"hidden":true,"merged":[[0,1,2,9],[107,4,107,6],[27,5,27,6],[105,1,105,9],[26,5,26,7]]}
[null,"Anwenderhilfe für Excel"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Die Funktionen"]
[]
[null,null,null,null,null,"Navigation"]
[null,null,null,null,null,"Kopf- und Fußzeile bearbeiten"]
[null,null,null,null,null,"Vollbild"]
[null,null,null,null,null,"Normalansicht"]
[null,null,null,null,null,"Blattregister/Blätter einfügen"]
[null,null,null,null,null,"Zeilen- und Spaltenköpfe"]
[null,null,null,null,null,"Gitternetz"]
[null,null,null,null,null,"Blattschutz/Anpassen der Lösung"]
[]
[]
[null,"Navigation"]
[null,"Über den Befehl Haufe Mediengruppe ® Navigation rufen Sie eine Liste mit den verfügbaren Tabellen im Dokument auf. "]
[null,"So können Sie von jeder beliebigen Position in der Arbeitsmappe auf ein anderes Tabellenblatt wechseln."]
[null,"Alternativ dazu können Sie über diese Schaltfläche                         zurück zur Startseite springen und dort das"]
[null,"Listenfeld nutzen. Außerdem können Sie bei eingeblendetem Blattregister den Reiter der jeweiligen Tabelle anklicken."]
[]
[null,"Kopf- und Fußzeile bearbeiten"]
[null,"Über diesen Menübefehl rufen Sie einen Dialog auf, in dem Sie Ihre Kopf- und Fußzeilen einstellen können."]
[null,"Der folgende Dialog bietet Ihnen Funktionen, die Sie über die Excel-Standardfunktion Kopf-/Fußzeile im"]
[null,"Menü Datei ® Seite einrichten nicht einstellen können. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Mit einem Klick auf die Schaltfläche Dokumenteigenschaften eintragen (Abb. links oben) können Sie vorab"]
[null,"Ihre Dokumenteigenschaften füllen, die dann als Grundlage für die Kopf- und Fußzeileneinträge dienen."]
[]
[null,"Für die Festlegung der Kopf- und Fußzeileneinträge stehen Ihnen zwei Register zur Verfügung."]
[null,"Aktivieren Sie das gewünschte Positionskontrollkästchen und legen Sie über eine Optionsschaltfläche"]
[null,"fest, welchen Eintrag Sie in der Kopf- oder Fußzeile haben möchten. "]
[null,"Sie haben die Möglichkeit, die Kopf- und Fußzeilendefinitionen für die aktive Tabelle bzw. für"]
[null,"alle Tabellen der aktiven Arbeitsmappe einzufügen."]
[null,"Über das Kontrollkästchen links unten im Dialog können Sie nach dem Einrichten der Kopf- und Fußzeilen "]
[null,"direkt in die Seitenansicht wechseln, um die Ergebnisse zu kontrollieren."]
[null,"Über die Schaltfläche Initialisieren löschen Sie alle Kopf- und Fußzeileneinträge der aktiven"]
[null,"Tabelle bzw. aller Tabellen der aktiven Arbeitsmappe."]
[]
[null,"Vollbild"]
[null,"Über diesen Menübefehl stellen Sie die Vollbildansicht von Excel ein. Bei dieser Ansicht werden"]
[null,"alle Symbolleisten temporär ausgeblendet. Drücken Sie die Taste ESC, um diese Vollbildansicht"]
[null,"zu beenden."]
[]
[null,"Normalansicht"]
[null,"Über diesen Menübefehl stellen Sie die Normalansicht von Excel ein. "]
[]
[null,"Blattregister/Blätter einfügen"]
[null,"Mit Hilfe dieses Menübefehls können Sie die Anzeige der Blattregister ein- und ausschalten."]
[null,"Wenn Sie neue Blätter einfügen möchten, können Sie dies mit Hilfe der Schaltfläche Tabellen"]
[null,"einfügen auf der Startseite erledigen; Sie können mehrere Blätter gleichzeitig einfügen und"]
[null,"die gewünschte Anzahl mit Hilfe des Drehfelds vorgeben."]
[]
[null,"Zeilen- und Spaltenköpfe"]
[null,"Mit Hilfe dieses Menübefehls können Sie die Anzeige der Zeilen- und Spaltenköpfe ein- und"]
[null,"ausschalten. Dabei wird bei jedem Tabellenwechsel geprüft, wie der momentane Status der"]
[null,"Zeilen- und Spaltenköpfe ist. Dementsprechend wird das Häkchen vor dem Menübefehl"]
[null,"gesetzt oder weggenommen."]
[]
[null,"Gitternetz"]
[null,"Mit Hilfe dieses Menübefehls können Sie die Anzeige des Gitternetzes ein- und ausschalten."]
[null,"Dabei wird bei jedem Tabellenwechsel geprüft, wie der momentane Status des Gitternetzes ist."]
[null,"Dementsprechend wird das Häkchen vor dem Menübefehl gesetzt oder weggenommen."]
[]
[null,"Blattschutz/Anpassen der Lösung"]
[null,"Um Textfelder und Grafikobjekte vor dem Löschen oder Verschieben zu schützen, sind die Haufe-Businesslösungen "]
[null,"zum Teil mit einem Objektschutz versehen. Die vorgegebenen Inhalte der Zellen und Textfelder sowie die Formatierungen "]
[null,"können Sie jedoch an Ihre Erfordernisse anpassen. Heben Sie den Blattschutz über Extras ® Schutz ®  Blattschutz auf."]
[null,"Alternativ dazu können Sie im Haufe-Menü den Befehl Blattschutz Tabelle schützen/Tabelle entsperren wählen. "]
[]
[null,"Weitere Hinweise zu den Besonderheiten der jeweiligen Lösung entnehmen Sie dem Blatt So bedienen Sie das Tool. "]
[]
[null,null,null,null,"zurück zum Anfang dieser Seite"]

{"sheet":"FinanzielleMobilität","index":8,"n_rows":36,"n_cols":3,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Finanzielle Mobilität",null,"Start"]
[]
[null,"Zu Beginn des Planjahres","Am Ende des Planjahres"]
["Freie Liquiditätsreserven"]
["Zahlungskraftreserven"]
["Kasse und Bankguthaben"]
["Nicht ausgenutzte Kreditlinien"]
["Summe frei Liquiditätsreserven",{"$f":"SUM(B5:B7)","v":0},{"$f":"SUM(C5:C7)","v":0}]
["Kurzfristige Vermögensreserven"]
["Terminausleihungen"]
["Wertpapiere"]
["Summe kurzfristige Vermögensreserven",{"$f":"SUM(B10:B11)","v":0},{"$f":"SUM(C10:C11)","v":0}]
["Finanzierungsreserven"]
["Nicht ausgenutztes Verschuldungspotential"]
["Kapitalerhöhungsreserven"]
["Summe Finanzierungsreserven",{"$f":"SUM(B14:B15)","v":0},{"$f":"SUM(C14:C15)","v":0}]
["Summe frei Liquiditätsreserven",{"$f":"+B8+B12+B16","v":0},{"$f":"+C8+C12+C16","v":0}]
["Abbau des working capital"]
["Vorräte"]
["Debitoren"]
["Zunahme Kreditoren"]
["Summe Einsparung aus working capital",{"$f":"SUM(B19:B21)","v":0},{"$f":"SUM(C19:C21)","v":0}]
["Gemeinkostenreduzierung"]
["Marketing"]
["Administration"]
["Forschung und Entwicklung"]
["Summe Gemeinkostenreduzierung",{"$f":"SUM(B24:B26)","v":0},{"$f":"SUM(C24:C26)","v":0}]
["Kürzung von Analgeinvestitionene und Dividenden"]
["Anlageinvestitionen"]
["Divdienden"]
["Summe: Kürzung von Anlageinvestitionen + Dividenden",{"$f":"SUM(B29:B30)","v":0},{"$f":"SUM(C29:C30)","v":0}]
["Liquidation von Anlagevermögen"]
["Sachanlagen"]
["Finanzanlagen"]
["Summe: Liquidation von Anlagevermögen",{"$f":"SUM(B33:B34)","v":0},{"$f":"SUM(C33:C34)","v":0}]
["Gesamte Möglichkeit zur Abdeckung\npotentieller Liquiditätsengpässe",{"$f":"+B17+B22+B27+B31+B35","v":0},{"$f":"+C17+C22+C27+C31+C35","v":0}]

{"sheet":"Lieferung_Leistung","index":9,"n_rows":1264,"n_cols":18,"rows_kept":1264,"cut":false,"hidden":false,"merged":[]}
["Lieferung und Leistung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Start"]
[]
[]
["Durchschnittlicher Geldeingang nach Lieferung",null,null,null,null,null,null,null,null,1]
[]
[]
[]
["Produktgruppe / Leistung","Termine",null,null,null,"Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember"]
[null,null,null,null,null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"Definitionen!A5","v":"Produktgruppe 1"},{"$f":"IF(#REF!=\"jährlich\",1,IF(#REF!=\"halbjährlich\",2,IF(#REF!=\"vierteljährlich\",4,12)))","v":{"$error":"#REF!"}},{"$f":"IF(OR($B10=1,$B10=12),0,IF($B10=2,#REF!+6,IF($B10=4,#REF!+3)))","v":{"$error":"#REF!"}},{"$f":"IF(OR($B10=1,$B10=2,$B10=12),0,IF($B10=4,C10+3))","v":{"$error":"#REF!"}},{"$error":"#REF!"},3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000]
[{"$f":"Definitionen!A6","v":"Produktgruppe 2"},{"$f":"IF(#REF!=\"jährlich\",1,IF(#REF!=\"halbjährlich\",2,IF(#REF!=\"vierteljährlich\",4,12)))","v":{"$error":"#REF!"}},{"$f":"IF(OR($B11=1,$B11=12),0,IF($B11=2,#REF!+6,IF($B11=4,#REF!+3)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},16000,16000,13000,16000,14000,16000,18000,16000,12000,16000,16000,16000]
[{"$f":"Definitionen!A7","v":"Produktgruppe 3"},{"$f":"IF(#REF!=\"jährlich\",1,IF(#REF!=\"halbjährlich\",2,IF(#REF!=\"vierteljährlich\",4,12)))","v":{"$error":"#REF!"}},{"$f":"IF(OR($B12=1,$B12=12),0,IF($B12=2,#REF!+6,IF($B12=4,#REF!+3)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"Definitionen!A8","v":"Produktgruppe 4"},{"$f":"IF(#REF!=\"jährlich\",1,IF(#REF!=\"halbjährlich\",2,IF(#REF!=\"vierteljährlich\",4,12)))","v":{"$error":"#REF!"}},{"$f":"IF(OR($B13=1,$B13=12),0,IF($B13=2,#REF!+6,IF($B13=4,#REF!+3)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"Definitionen!A9","v":"Produktgruppe 5"},{"$f":"IF(#REF!=\"jährlich\",1,IF(#REF!=\"halbjährlich\",2,IF(#REF!=\"vierteljährlich\",4,12)))","v":{"$error":"#REF!"}},{"$f":"IF(OR($B14=1,$B14=12),0,IF($B14=2,#REF!+6,IF($B14=4,#REF!+3)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"Definitionen!A10","v":"Produktgruppe 6"},{"$f":"IF(#REF!=\"jährlich\",1,IF(#REF!=\"halbjährlich\",2,IF(#REF!=\"vierteljährlich\",4,12)))","v":{"$error":"#REF!"}},{"$f":"IF(OR($B15=1,$B15=12),0,IF($B15=2,#REF!+6,IF($B15=4,#REF!+3)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"Definitionen!A11","v":"Produktgruppe 7"},{"$f":"IF(#REF!=\"jährlich\",1,IF(#REF!=\"halbjährlich\",2,IF(#REF!=\"vierteljährlich\",4,12)))","v":{"$error":"#REF!"}},{"$f":"IF(OR($B16=1,$B16=12),0,IF($B16=2,#REF!+6,IF($B16=4,#REF!+3)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"Definitionen!A12","v":"Produktgruppe 8"},{"$f":"IF(#REF!=\"jährlich\",1,IF(#REF!=\"halbjährlich\",2,IF(#REF!=\"vierteljährlich\",4,12)))","v":{"$error":"#REF!"}},{"$f":"IF(OR($B17=1,$B17=12),0,IF($B17=2,#REF!+6,IF($B17=4,#REF!+3)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"Definitionen!A13","v":"Produktgruppe 9"},{"$f":"IF(#REF!=\"jährlich\",1,IF(#REF!=\"halbjährlich\",2,IF(#REF!=\"vierteljährlich\",4,12)))","v":{"$error":"#REF!"}},{"$f":"IF(OR($B18=1,$B18=12),0,IF($B18=2,#REF!+6,IF($B18=4,#REF!+3)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"Definitionen!A14","v":"Produktgruppe 10"},{"$f":"IF(#REF!=\"jährlich\",1,IF(#REF!=\"halbjährlich\",2,IF(#REF!=\"vierteljährlich\",4,12)))","v":{"$error":"#REF!"}},{"$f":"IF(OR($B19=1,$B19=12),0,IF($B19=2,#REF!+6,IF($B19=4,#REF!+3)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"Definitionen!A15","v":"Produktgruppe 11"},{"$f":"IF(#REF!=\"jährlich\",1,IF(#REF!=\"halbjährlich\",2,IF(#REF!=\"vierteljährlich\",4,12)))","v":{"$error":"#REF!"}},{"$f":"IF(OR($B20=1,$B20=12),0,IF($B20=2,#REF!+6,IF($B20=4,#REF!+3)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"Definitionen!A16","v":"Produktgruppe 12"},{"$f":"IF(#REF!=\"jährlich\",1,IF(#REF!=\"halbjährlich\",2,IF(#REF!=\"vierteljährlich\",4,12)))","v":{"$error":"#REF!"}},{"$f":"IF(OR($B21=1,$B21=12),0,IF($B21=2,#REF!+6,IF($B21=4,#REF!+3)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"Definitionen!A17","v":"Produktgruppe 13"},{"$f":"IF(#REF!=\"jährlich\",1,IF(#REF!=\"halbjährlich\",2,IF(#REF!=\"vierteljährlich\",4,12)))","v":{"$error":"#REF!"}},{"$f":"IF(OR($B22=1,$B22=12),0,IF($B22=2,#REF!+6,IF($B22=4,#REF!+3)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"Definitionen!A18","v":"Produktgruppe 14"},{"$f":"IF(#REF!=\"jährlich\",1,IF(#REF!=\"halbjährlich\",2,IF(#REF!=\"vierteljährlich\",4,12)))","v":{"$error":"#REF!"}},{"$f":"IF(OR($B23=1,$B23=12),0,IF($B23=2,#REF!+6,IF($B23=4,#REF!+3)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"Definitionen!A19","v":"Produktgruppe 15"},{"$f":"IF(#REF!=\"jährlich\",1,IF(#REF!=\"halbjährlich\",2,IF(#REF!=\"vierteljährlich\",4,12)))","v":{"$error":"#REF!"}},{"$f":"IF(OR($B24=1,$B24=12),0,IF($B24=2,#REF!+6,IF($B24=4,#REF!+3)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"Definitionen!A20","v":"Produktgruppe 16"},{"$f":"IF(#REF!=\"jährlich\",1,IF(#REF!=\"halbjährlich\",2,IF(#REF!=\"vierteljährlich\",4,12)))","v":{"$error":"#REF!"}},{"$f":"IF(OR($B25=1,$B25=12),0,IF($B25=2,#REF!+6,IF($B25=4,#REF!+3)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"Definitionen!A21","v":"Produktgruppe 17"},{"$f":"IF(#REF!=\"jährlich\",1,IF(#REF!=\"halbjährlich\",2,IF(#REF!=\"vierteljährlich\",4,12)))","v":{"$error":"#REF!"}},{"$f":"IF(OR($B26=1,$B26=12),0,IF($B26=2,#REF!+6,IF($B26=4,#REF!+3)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"Definitionen!A22","v":"Produktgruppe 18"},{"$f":"IF(#REF!=\"jährlich\",1,IF(#REF!=\"halbjährlich\",2,IF(#REF!=\"vierteljährlich\",4,12)))","v":{"$error":"#REF!"}},{"$f":"IF(OR($B27=1,$B27=12),0,IF($B27=2,#REF!+6,IF($B27=4,#REF!+3)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"Definitionen!A23","v":"Produktgruppe 19"},{"$f":"IF(#REF!=\"jährlich\",1,IF(#REF!=\"halbjährlich\",2,IF(#REF!=\"vierteljährlich\",4,12)))","v":{"$error":"#REF!"}},{"$f":"IF(OR($B28=1,$B28=12),0,IF($B28=2,#REF!+6,IF($B28=4,#REF!+3)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"Definitionen!A24","v":"Produktgruppe 20"},{"$f":"IF(#REF!=\"jährlich\",1,IF(#REF!=\"halbjährlich\",2,IF(#REF!=\"vierteljährlich\",4,12)))","v":{"$error":"#REF!"}},{"$f":"IF(OR($B29=1,$B29=12),0,IF($B29=2,#REF!+6,IF($B29=4,#REF!+3)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"Definitionen!A25","v":"Produktgruppe 21"},{"$f":"IF(#REF!=\"jährlich\",1,IF(#REF!=\"halbjährlich\",2,IF(#REF!=\"vierteljährlich\",4,12)))","v":{"$error":"#REF!"}},{"$f":"IF(OR($B30=1,$B30=12),0,IF($B30=2,#REF!+6,IF($B30=4,#REF!+3)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"Definitionen!A26","v":"Produktgruppe 22"},{"$f":"IF(#REF!=\"jährlich\",1,IF(#REF!=\"halbjährlich\",2,IF(#REF!=\"vierteljährlich\",4,12)))","v":{"$error":"#REF!"}},{"$f":"IF(OR($B31=1,$B31=12),0,IF($B31=2,#REF!+6,IF($B31=4,#REF!+3)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"Definitionen!A27","v":"Produktgruppe 23"},{"$f":"IF(#REF!=\"jährlich\",1,IF(#REF!=\"halbjährlich\",2,IF(#REF!=\"vierteljährlich\",4,12)))","v":{"$error":"#REF!"}},{"$f":"IF(OR($B32=1,$B32=12),0,IF($B32=2,#REF!+6,IF($B32=4,#REF!+3)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"Definitionen!A28","v":"Produktgruppe 24"},{"$f":"IF(#REF!=\"jährlich\",1,IF(#REF!=\"halbjährlich\",2,IF(#REF!=\"vierteljährlich\",4,12)))","v":{"$error":"#REF!"}},{"$f":"IF(OR($B33=1,$B33=12),0,IF($B33=2,#REF!+6,IF($B33=4,#REF!+3)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"Definitionen!A29","v":"Produktgruppe 25"},{"$f":"IF(#REF!=\"jährlich\",1,IF(#REF!=\"halbjährlich\",2,IF(#REF!=\"vierteljährlich\",4,12)))","v":{"$error":"#REF!"}},{"$f":"IF(OR($B34=1,$B34=12),0,IF($B34=2,#REF!+6,IF($B34=4,#REF!+3)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"Definitionen!A30","v":"Produktgruppe 26"},{"$f":"IF(#REF!=\"jährlich\",1,IF(#REF!=\"halbjährlich\",2,IF(#REF!=\"vierteljährlich\",4,12)))","v":{"$error":"#REF!"}},{"$f":"IF(OR($B35=1,$B35=12),0,IF($B35=2,#REF!+6,IF($B35=4,#REF!+3)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"Definitionen!A31","v":"Produktgruppe 27"},{"$f":"IF(#REF!=\"jährlich\",1,IF(#REF!=\"halbjährlich\",2,IF(#REF!=\"vierteljährlich\",4,12)))","v":{"$error":"#REF!"}},{"$f":"IF(OR($B36=1,$B36=12),0,IF($B36=2,#REF!+6,IF($B36=4,#REF!+3)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"Definitionen!A32","v":"Produktgruppe 28"},{"$f":"IF(#REF!=\"jährlich\",1,IF(#REF!=\"halbjährlich\",2,IF(#REF!=\"vierteljährlich\",4,12)))","v":{"$error":"#REF!"}},{"$f":"IF(OR($B37=1,$B37=12),0,IF($B37=2,#REF!+6,IF($B37=4,#REF!+3)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"Definitionen!A33","v":"Produktgruppe 29"},{"$f":"IF(#REF!=\"jährlich\",1,IF(#REF!=\"halbjährlich\",2,IF(#REF!=\"vierteljährlich\",4,12)))","v":{"$error":"#REF!"}},{"$f":"IF(OR($B38=1,$B38=12),0,IF($B38=2,#REF!+6,IF($B38=4,#REF!+3)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"Definitionen!A34","v":"Produktgruppe 30"},{"$f":"IF(#REF!=\"jährlich\",1,IF(#REF!=\"halbjährlich\",2,IF(#REF!=\"vierteljährlich\",4,12)))","v":{"$error":"#REF!"}},{"$f":"IF(OR($B39=1,$B39=12),0,IF($B39=2,#REF!+6,IF($B39=4,#REF!+3)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["Gesamt",null,null,null,null,{"$f":"SUM(F10:F39)","v":19000},{"$f":"SUM(G10:G39)","v":19000},16000,19000,17000,19000,21000,19000,15000,{"$f":"SUM(O10:O39)","v":19000},{"$f":"SUM(P10:P39)","v":19000},{"$f":"SUM(Q10:Q39)","v":19000}]
[]
["Geldeingang aus Planjahr",null,null,null,null,{"$f":"IF($J$4=3,0,IF($J$4=2,0,F40))","v":19000},{"$f":"IF($J$4=3,0,IF($J$4=2,F40,G40))","v":19000},{"$f":"IF($J$4=3,F40,IF($J$4=2,G40,H40))","v":16000},{"$f":"IF($J$4=3,G40,IF($J$4=2,H40,I40))","v":19000},17000,19000,21000,19000,15000,19000,19000,19000]
["Geldeingang aus Vorjahren",null,null,null,null,6000]
["Geldeingang, gesamt",null,null,null,null,{"$f":"SUM(F42:F43)","v":25000},{"$f":"SUM(G42:G43)","v":19000},16000,19000,17000,19000,21000,19000,15000,19000,19000,19000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"jährlich",1]
[null,null,null,null,null,"halbjährlich",2]
[{"$f":"Definitionen!A5","v":"Produktgruppe 1"},null,null,null,null,"vierteljährlich",3]
[{"$f":"Definitionen!A6","v":"Produktgruppe 2"},null,null,null,null,"monatlich",4]
[{"$f":"Definitionen!A7","v":"Produktgruppe 3"},null,null,null,null,null,5]
[{"$f":"Definitionen!A8","v":"Produktgruppe 4"},null,null,null,null,null,6]
[{"$f":"Definitionen!A9","v":"Produktgruppe 5"},null,null,null,null,null,7]
[{"$f":"Definitionen!A10","v":"Produktgruppe 6"},null,null,null,null,null,8]
[{"$f":"Definitionen!A11","v":"Produktgruppe 7"},null,null,null,null,null,9]
[{"$f":"Definitionen!A12","v":"Produktgruppe 8"},null,null,null,null,null,10]
[{"$f":"Definitionen!A13","v":"Produktgruppe 9"},null,null,null,null,null,11]
[{"$f":"Definitionen!A14","v":"Produktgruppe 10"},null,null,null,null,null,12]
[{"$f":"Definitionen!A31","v":"Produktgruppe 27"}]
[{"$f":"Definitionen!A32","v":"Produktgruppe 28"}]
[{"$f":"Definitionen!A33","v":"Produktgruppe 29"}]
[{"$f":"Definitionen!A34","v":"Produktgruppe 30"}]
[{"$f":"Definitionen!#REF!","v":{"$error":"#REF!"}}]

{"sheet":"Vermietung_Verpachtung","index":10,"n_rows":21,"n_cols":14,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Einnahmen aus Vermietung und Verpachtung"]
[]
["Leistung","Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember",{"$f":"\"Gesamt \"&Startseite!H5","v":"Gesamt 2021"}]
["Objekt 1",1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,{"$f":"SUM(B4:M4)","v":12000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B5:M5)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Gesamt",{"$f":"SUM(B4:B18)","v":1000},{"$f":"SUM(C4:C18)","v":1000},1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,12000]
[]
["Start"]

{"sheet":"Sachvermögen","index":11,"n_rows":21,"n_cols":14,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Veräußerung von Sachvermögen"]
[]
["Objekt","Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember",{"$f":"\"Gesamt \"&Startseite!H5","v":"Gesamt 2021"}]
["Maschine 1",null,null,null,null,null,null,null,null,null,null,5000,null,{"$f":"SUM(B4:M4)","v":5000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Gesamt",{"$f":"SUM(B4:B18)","v":0},0,0,0,0,0,0,0,0,0,5000,0,5000]
[]
["Start"]

{"sheet":"SonstigeEinnahmen","index":12,"n_rows":40,"n_cols":16,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["Weitere Einnahmen",null,null,null,null,null,null,null,null,null,null,null,null,null,"Start"]
[]
["Leistung","Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember",{"$f":"\"Gesamt \"&Startseite!H5","v":"Gesamt 2021"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B4:M4)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"Steuerrückzahlungen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"Versicherungsleistungen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Gesamt",{"$f":"SUM(B4:B39)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Personal","index":13,"n_rows":50,"n_cols":15,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["Ausgabenplaner Personal",null,null,null,null,null,null,null,null,null,null,null,null,null,"Start"]
["Ausgaben","Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember",{"$f":"\"Gesamt \"&Startseite!H5","v":"Gesamt 2021"}]
["Angestellte"]
["Gehälter",8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,{"$f":"SUM(B4:M4)","v":96000}]
["Sozialabgaben",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Sonderzahlungen",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Fort- und Weiterbildung",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Sonstiges",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Angestellte, gesamt",{"$f":"SUM(B4:B8)","v":8000},8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,8000,96000]
["Arbeiter"]
["Löhne",6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,{"$f":"SUM(B11:M11)","v":72000}]
["Sozialabgaben",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Sonderzahlungen",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Fort- und Weiterbildung",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Sonstiges",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Arbeiter, gesamt",{"$f":"SUM(B11:B15)","v":6000},6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,72000]
["Auszubildende"]
["Ausbildungsvergütung",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B18:M18)","v":0}]
["Sozialabgaben",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Sonderzahlungen",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Fort- und Weiterbildung",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Sonstiges",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Auszubildende, gesamt",{"$f":"SUM(B18:B22)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Freie Mitarbeiter "]
["Honorare",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B25:M25)","v":0}]
["Sonstiges",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Freie Mitarbeiter, gesamt",{"$f":"SUM(B25:B29)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Sonstige Personalkosten"]
["Unfallversicherung",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B32:M32)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Sonstige Personalkosten, gesamt",{"$f":"SUM(B32:B36)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Weitere Ausgaben für Pesonl"]
["Bewirtung",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B39:M39)","v":0}]
["Gebäude",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Weitere Ausgaben, gesamt",{"$f":"SUM(B39:B48)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Personalkosten, gesamt",{"$f":"+B9+B16+B23+B30+B49","v":14000},{"$f":"+C9+C16+C23+C30+C49","v":14000},14000,14000,14000,14000,14000,14000,14000,14000,14000,14000,168000]

{"sheet":"Material","index":14,"n_rows":52,"n_cols":15,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["Ausgabenplaner Material",null,null,null,null,null,null,null,null,null,null,null,null,null,"Start"]
["Ausgaben","Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember",{"$f":"\"Gesamt \"&Startseite!H5","v":"Gesamt 2021"}]
["Rohstoffe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B4:M4)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Rohstoffe,  gesamt",{"$f":"SUM(B4:B8)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Hilfsstoffe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B11:M11)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Hilfsstoffe, gesamt",{"$f":"SUM(B11:B15)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Betriebsstoffe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B18:M18)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Betriebsstoffe, gesamt",{"$f":"SUM(B18:B22)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Zukaufteile"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B25:M25)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Zukaufteile, gesamt",{"$f":"SUM(B25:B31)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Sonstige Personalkosten"]
["Unfallversicherung",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B34:M34)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Sonstige Personalkosten, gesamt",{"$f":"SUM(B34:B38)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Weitere Ausgaben für Material"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B41:M41)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Weitere Ausgaben, gesamt",{"$f":"SUM(B41:B50)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Materialkosten, gesamt",{"$f":"+B9+B16+B23+B32+B51","v":0},0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Investitionsplan","index":15,"n_rows":1264,"n_cols":14,"rows_kept":1264,"cut":false,"hidden":false,"merged":[]}
["Investitionsplan",null,null,null,null,null,null,null,null,null,null,null,null,"Start"]
[]
["Bezeichnung der Investition","Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember"]
[null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]
["Maschine",null,null,null,null,10000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Gesamt",{"$f":"SUM(B5:B39)","v":0},{"$f":"SUM(C5:C39)","v":0},0,0,10000,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"Definitionen!A5","v":"Produktgruppe 1"}]
[{"$f":"Definitionen!A6","v":"Produktgruppe 2"}]
[{"$f":"Definitionen!A7","v":"Produktgruppe 3"}]
[{"$f":"Definitionen!A8","v":"Produktgruppe 4"}]
[{"$f":"Definitionen!A9","v":"Produktgruppe 5"}]
[{"$f":"Definitionen!A10","v":"Produktgruppe 6"}]
[{"$f":"Definitionen!A11","v":"Produktgruppe 7"}]
[{"$f":"Definitionen!A12","v":"Produktgruppe 8"}]
[{"$f":"Definitionen!A13","v":"Produktgruppe 9"}]
[{"$f":"Definitionen!A14","v":"Produktgruppe 10"}]
[{"$f":"Definitionen!A31","v":"Produktgruppe 27"}]
[{"$f":"Definitionen!A32","v":"Produktgruppe 28"}]
[{"$f":"Definitionen!A33","v":"Produktgruppe 29"}]
[{"$f":"Definitionen!A34","v":"Produktgruppe 30"}]
[{"$f":"Definitionen!#REF!","v":{"$error":"#REF!"}}]

{"sheet":"Ausgaben","index":16,"n_rows":49,"n_cols":15,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["Ausgabenplaner",null,null,null,null,null,null,null,null,null,null,null,null,null,"Start"]
["Ausgaben","Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember",{"$f":"\"Gesamt \"&Startseite!H5","v":"Gesamt 2021"}]
[{"$f":"Definitionen!C5","v":"Verwaltung"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B4:M4)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"A3&\", gesamt\"","v":"Verwaltung, gesamt"},{"$f":"SUM(B4:B8)","v":0},{"$f":"SUM(C4:C8)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"Definitionen!C6","v":"Mieten / Pachten / Leasing"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"A10&\", gesamt\"","v":"Mieten / Pachten / Leasing, gesamt"},{"$f":"SUM(B11:B15)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(B16:M16)","v":0}]
[{"$f":"Definitionen!C7","v":"Fuhrpark"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B18:M18)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"A17&\", gesamt\"","v":"Fuhrpark, gesamt"},{"$f":"SUM(B18:B22)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"Definitionen!C8","v":"Versicherungen"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B25:M25)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"A24&\", gesamt\"","v":"Versicherungen, gesamt"},{"$f":"SUM(B25:B29)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"Definitionen!C9","v":"Steuern und Abgaben"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B32:M32)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"A31&\", gesamt\"","v":"Steuern und Abgaben, gesamt"},{"$f":"SUM(B32:B36)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Weitere Ausgaben"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B39:M39)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Weitere Ausgaben, gesamt",{"$f":"SUM(B39:B48)","v":0},{"$f":"SUM(C39:C48)","v":0},0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"TabVorlage","index":17,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Titel"]