{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Startseite","Eingaben","Berechnung","Beispiel","Hilfe","Parameter_Intern"],"not_rendered":{"images":3,"macros":1,"defined_names":19},"read":"whole","date_system":"1900"}

{"sheet":"Startseite","index":0,"n_rows":42,"n_cols":14,"rows_kept":42,"merged":[[10,6,14,7],[11,12,11,13],[16,3,16,4]]}
[]
[]
[]
[{"$nulls":9},"Startseite"]
[null,"Abschreibungsvorteile"]
[]
[]
[]
[{"$nulls":3},"Tabellenblätter",{"$nulls":8},"Tabellenblatt",1]
[{"$nulls":6},"Info"]
[{"$nulls":6},{"$f":"INDEX(Parameter_Intern!C5:D8,Startseite!N9,2)","v":"Hier geben Sie die Daten für die Berechnung der Abschreibung ein"},{"$nulls":5},{"$f":"+N9/2","v":0.5},{"$f":"+ROUND(N9/2,0)","v":1}]
[{"$nulls":12},{"$f":"IF(M11=N11,1,2)","v":2}]
[]
[]
[]
[]
[{"$nulls":3},{"$f":"\"Bei einem Klick auf \"&H17&\" kommen Sie direkt zum entsprechenden Arbeitsblatt\"","v":"Bei einem Klick auf Eingaben kommen Sie direkt zum entsprechenden Arbeitsblatt"},{"$nulls":3},{"$f":"+HYPERLINK(VLOOKUP($N$9,Parameter_Intern!$B$5:$E$30,4,FALSE),VLOOKUP($N$9,Parameter_Intern!$B$5:$E$30,2,FALSE))","v":"Eingaben"}]
{"$rows_empty":22}
[null,"© 2023 by mediaforwork - ein Unternehmensbereich der Verlag für die Deutsche Wirtschaft AG"]
[null,"Die Vervielfältigung, Verbreitung oder Veräußerung der Daten oder Texte ist unzulässig und"]
[null,"ausdrücklich nur mit Genehmigung des Verlags gestattet."]

{"sheet":"Eingaben","index":1,"n_rows":83,"n_cols":11,"rows_kept":83,"merged":[[1,1,1,10],[3,3,3,6],[5,6,5,8],[6,6,6,8],[7,6,7,8],[12,3,12,6],[18,6,18,8],[44,3,44,6],[51,1,51,3]]}
[{"$nulls":10},"Eingaben"]
[null,"Abschreibungen - Eingaben"]
[]
[{"$nulls":3},"Stammdaten"]
[]
[{"$nulls":3},"Firma"]
[{"$nulls":3},"Straße"]
[{"$nulls":3},"PLZ, Ort"]
[]
[]
[]
[]
[{"$nulls":3},"Ermittlung der Bemessungsgrundlage"]
[]
[{"$nulls":6},{"$f":"IF(OR(ISTEXT(G31),ISTEXT(G33),ISTEXT(G30),ISTEXT(G47),ISTEXT(G48),G31<0,G31=\"\",G33<0,G33<>INT(G33),G33=\"\",G26=\"\"),\"Fehlerhafte Eingabe. Berechnung unmöglich!\",IF(OR(ISNUMBER(G21)=FALSE,G21=\"\"),\"Falsche oder fehlende Datumseingabe!\",\"\"))","v":"Fehlerhafte Eingabe. Berechnung unmöglich!"}]
[{"$nulls":3},"Allgemeine Angaben:"]
[]
[{"$nulls":3},"Inventarnummer:"]
[{"$nulls":3},"Anlage/Maschine:"]
[]
[{"$nulls":3},"Anschaffungsdatum:"]
[{"$nulls":3},"Nutzungsdauer in Jahren:"]
[]
[{"$nulls":3},"Anschaffungskosten:"]
[]
[{"$nulls":3},"Neupreis netto ohne USt.:"]
[{"$nulls":3},"+ Nebenkosten der Anschaffung:"]
[{"$nulls":3},"+ Nachträgliche Anschaffungskosten:"]
[{"$nulls":3},"- Skonti, Rabatte, andere Minderungen:"]
[{"$nulls":3},"- Schrottwert nach Nutzungsdauer:"]
[{"$nulls":3},"AfA-Bemessungsgrundlage in Euro:",null,null,{"$f":"IF(SUM(G26:G30)=0,\"\",IF(ISERROR(SUM(G26,G27,G28,-G29,-G30)),\"\",SUM(G26,G27,G28,-G29,-G30)))","v":""}]
[]
[{"$nulls":3},"Abschreibungsperioden in Jahren:",null,null,{"$f":"IF(ISERROR(IF(13-MONTH(G21)<>12,G22+1,G22)),\"\",IF(13-MONTH(G21)<>12,G22+1,G22))","v":0}]
[]
[{"$nulls":3},"Abschreibung pro Jahr in %:"]
[{"$nulls":3},"- Lineare AfA:",null,null,{"$f":"IF(ISERROR(IF(G22>0,1/G22,\"\")),\"\",IF(G22>0,1/G22,\"\"))","v":""}]
[{"$nulls":3},"- Degressive AfA:",null,null,{"$f":"IF(ISERROR(IF($G$15<>\"\",\"\",IF(G22>0,IF(G36*G47>G48,G48,G36*G47),\"\"))),\"\",IF($G$15<>\"\",\"\",IF(G22>0,IF(G36*G47>G48,G48,G36*G47),\"\")))","v":""}]
[]
[{"$nulls":3},"AfA-Perioden im ersten Jahr:",null,null,{"$f":"IF(ISERROR(IF($G$15<>\"\",\"\",13-MONTH(G21))),\"\",IF($G$15<>\"\",\"\",13-MONTH(G21)))","v":""}]
[{"$nulls":6},{"$f":"IF($G$15<>\"\",\"\",12-G39)","v":""}]
[]
[{"$nulls":3},"Jahr des AfA-Wechsels",null,null,{"$f":"+IF(ISERROR(ROUND((1+G22)-(100/(100*G37)),0)),\"\",ROUND((1+G22)-(100/(100*G37)),0))","v":""}]
[]
[]
[{"$nulls":3},"Parameter für degressive Abschreibung"]
[]
[{"$nulls":3},"Degressiver Multiplikator:",null,null,{"v":2.5,"d":"2.50-fach"},{"$f":"+IF(M21<2011,\"\",\"  DegressiveAbschreibung ab\")","v":""}]
[{"$nulls":3},"Degressiver Höchstsatz absolut:",null,null,{"v":0.25,"d":"25.00%"},{"$f":"+IF(M21<2011,\"\",\"  2011 nicht mehr möglich\")","v":""}]
[]
[]
[]
[null,"<< Startseite",null,null,"Hilfe?","Beispiel"]
[]
[null,"© 2023 by mediaforwork - ein Unternehmensbereich der Verlag für die Deutsche Wirtschaft AG"]
[null,"Die Vervielfältigung, Verbreitung oder Veräußerung der Daten oder Texte ist unzulässig und"]
[null,"ausdrücklich nur mit Genehmigung des Verlags gestattet."]
{"$rows_empty":7}
[{"$nulls":3},1]
[{"$nulls":3},2]
[{"$nulls":3},3]
[{"$nulls":3},4]
[{"$nulls":3},5]
[{"$nulls":3},6]
[{"$nulls":3},7]
[{"$nulls":3},8]
[{"$nulls":3},9]
[{"$nulls":3},10]
[{"$nulls":3},11]
[{"$nulls":3},12]
[{"$nulls":3},13]
[{"$nulls":3},14]
[{"$nulls":3},15]
[{"$nulls":3},16]
[{"$nulls":3},17]
[{"$nulls":3},18]
[{"$nulls":3},19]
[{"$nulls":3},20]

{"sheet":"Berechnung","index":2,"n_rows":41,"n_cols":18,"rows_kept":41,"merged":[[0,1,0,13],[1,1,1,14],[3,5,3,11],[4,6,4,11],[7,3,7,4],[7,6,7,8],[7,10,7,11],[7,13,7,14],[36,1,36,3]]}
[null,{"$f":"Eingaben!G15","v":"Fehlerhafte Eingabe. Berechnung unmöglich!"},{"$nulls":12},"Berechnung",null,{"$f":"+IF(B1=\"\",\"\",1)","v":1}]
[null,"Abschreibung - Berechnung"]
[]
[null,{"$f":"IF(+Eingaben!G6=\"\",\"\",Eingaben!G6)","v":""},{"$nulls":3},"Ermittlung der linearen und degressiven Abschreibungen für",{"$nulls":8},{"$f":"+\"Inventarnummer: \"&Eingaben!G18&\" \"","v":"Inventarnummer:  "}]
[{"$nulls":6},{"$f":"IF(Eingaben!G19=\"\",\"\",Eingaben!G19)","v":""}]
[]
[]
[null,"Jahr",null,"Reine Degressive AfA",null,null,"Wechsel degressive à  lineare AfA",{"$nulls":3},"Degressive Gesamttabelle",null,null,"Lineare AfA",{"$nulls":3},{"$f":"IF(AND(Q35>Eingaben!G33,Q35<22),\"????\",\"OK\")","v":"OK"}]
[]
[{"$nulls":3},"AfA in Euro","Zeitwert",null,"AfA in Euro","Zeitwert","Jetzt",null,"AfA in Euro","Zeitwert",null,"AfA in Euro","Zeitwert"]
[]
[null,0,null,null,{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",Eingaben!G31))","v":""},{"$nulls":6},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",Eingaben!G31))","v":""},null,null,{"$f":"IF($B$1<>\"\",\"\",Eingaben!G31)","v":""},null,{"$f":"+IF(Eingaben!$G$42<=0,\"\",IF(D12=\"\",\"\",IF(B12<Eingaben!$G$42,\"\",Berechnung!B12)))","v":""}]
[null,{"$f":"B12+1","v":1},null,{"$f":"IF(OR(Eingaben!G47=0,Eingaben!G48=0),\"\",IF($B$1<>\"\",\"\",IF(B13<=Eingaben!G$33,E12*Eingaben!G$37/12*Eingaben!G39,\"\")))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B13<=Eingaben!G$33,E12-D13,\"\")))","v":""},null,{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B13<=Eingaben!G$33,IF(G12=\"\",IF(H12<>\"\",H12/(Eingaben!G$33-B13+1),\"\"),G12),\"\"))","v":""},{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B13<=Eingaben!G$33,IF(H12=\"\",IF(OR(E13<=N$13,B13=Q$35),E13,\"\"),H12-G13),\"\"))","v":""},{"$f":"IF(Eingaben!G31=\"\",\"\",IF($Q$35+1=B13,\"ç\",\"\"))","v":""},null,{"$f":"IF($B$1<>\"\",\"\",IF(B13<=Eingaben!G$33,IF(G13=\"\",D13,G13),\"\"))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B13<=Eingaben!G$33,L12-K13,\"\")))","v":""},null,{"$f":"IF($B$1<>\"\",\"\",IF(B13<=Eingaben!G$33,O$12*Eingaben!G$36/12*Eingaben!G39,\"\"))","v":""},{"$f":"IF($B$1<>\"\",\"\",IF(B13<=Eingaben!G$33,O12-N13,\"\"))","v":""},null,{"$f":"+IF(Eingaben!$G$42<=0,\"\",IF(D13=\"\",\"\",IF(B13<Eingaben!$G$42,\"\",Berechnung!B13)))","v":""}]
[null,2,null,{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B14=Eingaben!$G$33,Berechnung!E13,IF(B14<=Eingaben!G$33,E13*Eingaben!G$37,\"\"))))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B14<=Eingaben!G$33,E13-D14,\"\")))","v":""},null,{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B14<=Eingaben!G$33,IF(G13=\"\",IF(H13<>\"\",H13/(Eingaben!G$33-B14+1),\"\"),G13),\"\"))","v":""},{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B14<=Eingaben!G$33,IF(H13=\"\",IF(OR(E14<=N$13,B14=Q$35),E14,\"\"),H13-G14),\"\"))","v":""},{"$f":"+IF($Q$35+1=B14,\"ç\",\"\")","v":""},null,{"$f":"IF($B$1<>\"\",\"\",IF(B14<=Eingaben!G$33,IF(G14=\"\",D14,G14),\"\"))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B14<=Eingaben!G$33,L13-K14,\"\")))","v":""},null,{"$f":"IF($B$1<>\"\",\"\",IF(B14=Eingaben!$G$33,Berechnung!O13,IF(B14<=Eingaben!G$33,O$12*Eingaben!G$36,\"\")))","v":""},{"$f":"IF($B$1<>\"\",\"\",IF(B14<=Eingaben!G$33,O13-N14,\"\"))","v":""},null,{"$f":"+IF(Eingaben!$G$42<=0,\"\",IF(D14=\"\",\"\",IF(B14<Eingaben!$G$42,\"\",Berechnung!B14)))","v":""}]
[null,3,null,{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B15=Eingaben!$G$33,Berechnung!E14,IF(B15<=Eingaben!G$33,E14*Eingaben!G$37,\"\"))))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B15<=Eingaben!G$33,E14-D15,\"\")))","v":""},null,{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B15<=Eingaben!G$33,IF(G14=\"\",IF(H14<>\"\",H14/(Eingaben!G$33-B15+1),\"\"),G14),\"\"))","v":""},{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B15<=Eingaben!G$33,IF(H14=\"\",IF(OR(E15<=N$13,B15=Q$35),E15,\"\"),H14-G15),\"\"))","v":""},"",null,{"$f":"IF($B$1<>\"\",\"\",IF(B15<=Eingaben!G$33,IF(G15=\"\",D15,G15),\"\"))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B15<=Eingaben!G$33,L14-K15,\"\")))","v":""},null,{"$f":"IF($B$1<>\"\",\"\",IF(B15=Eingaben!$G$33,Berechnung!O14,IF(B15<=Eingaben!G$33,O$12*Eingaben!G$36,\"\")))","v":""},{"$f":"IF($B$1<>\"\",\"\",IF(B15<=Eingaben!G$33,O14-N15,\"\"))","v":""},null,{"$f":"+IF(Eingaben!$G$42<=0,\"\",IF(D15=\"\",\"\",IF(B15<Eingaben!$G$42,\"\",Berechnung!B15)))","v":""}]
[null,4,null,{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B16=Eingaben!$G$33,Berechnung!E15,IF(B16<=Eingaben!G$33,E15*Eingaben!G$37,\"\"))))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B16<=Eingaben!G$33,E15-D16,\"\")))","v":""},null,{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B16<=Eingaben!G$33,IF(G15=\"\",IF(H15<>\"\",H15/(Eingaben!G$33-B16+1),\"\"),G15),\"\"))","v":""},{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B16<=Eingaben!G$33,IF(H15=\"\",IF(OR(E16<=N$13,B16=Q$35),E16,\"\"),H15-G16),\"\"))","v":""},"",null,{"$f":"IF($B$1<>\"\",\"\",IF(B16<=Eingaben!G$33,IF(G16=\"\",D16,G16),\"\"))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B16<=Eingaben!G$33,L15-K16,\"\")))","v":""},null,{"$f":"IF($B$1<>\"\",\"\",IF(B16=Eingaben!$G$33,Berechnung!O15,IF(B16<=Eingaben!G$33,O$12*Eingaben!G$36,\"\")))","v":""},{"$f":"IF($B$1<>\"\",\"\",IF(B16<=Eingaben!G$33,O15-N16,\"\"))","v":""},null,{"$f":"+IF(Eingaben!$G$42<=0,\"\",IF(D16=\"\",\"\",IF(B16<Eingaben!$G$42,\"\",Berechnung!B16)))","v":""}]
[null,5,null,{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B17=Eingaben!$G$33,Berechnung!E16,IF(B17<=Eingaben!G$33,E16*Eingaben!G$37,\"\"))))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B17<=Eingaben!G$33,E16-D17,\"\")))","v":""},null,{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B17<=Eingaben!G$33,IF(G16=\"\",IF(H16<>\"\",H16/(Eingaben!G$33-B17+1),\"\"),G16),\"\"))","v":""},{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B17<=Eingaben!G$33,IF(H16=\"\",IF(OR(E17<=N$13,B17=Q$35),E17,\"\"),H16-G17),\"\"))","v":""},"",null,{"$f":"IF($B$1<>\"\",\"\",IF(B17<=Eingaben!G$33,IF(G17=\"\",D17,G17),\"\"))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B17<=Eingaben!G$33,L16-K17,\"\")))","v":""},null,{"$f":"IF($B$1<>\"\",\"\",IF(B17=Eingaben!$G$33,Berechnung!O16,IF(B17<=Eingaben!G$33,O$12*Eingaben!G$36,\"\")))","v":""},{"$f":"IF($B$1<>\"\",\"\",IF(B17<=Eingaben!G$33,O16-N17,\"\"))","v":""},null,{"$f":"+IF(Eingaben!$G$42<=0,\"\",IF(D17=\"\",\"\",IF(B17<Eingaben!$G$42,\"\",Berechnung!B17)))","v":""}]
[null,6,null,{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B18=Eingaben!$G$33,Berechnung!E17,IF(B18<=Eingaben!G$33,E17*Eingaben!G$37,\"\"))))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B18<=Eingaben!G$33,E17-D18,\"\")))","v":""},null,{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B18<=Eingaben!G$33,IF(G17=\"\",IF(H17<>\"\",H17/(Eingaben!G$33-B18+1),\"\"),G17),\"\"))","v":""},{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B18<=Eingaben!G$33,IF(H17=\"\",IF(OR(E18<=N$13,B18=Q$35),E18,\"\"),H17-G18),\"\"))","v":""},"",null,{"$f":"IF($B$1<>\"\",\"\",IF(B18<=Eingaben!G$33,IF(G18=\"\",D18,G18),\"\"))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B18<=Eingaben!G$33,L17-K18,\"\")))","v":""},null,{"$f":"IF($B$1<>\"\",\"\",IF(B18=Eingaben!$G$33,Berechnung!O17,IF(B18<=Eingaben!G$33,O$12*Eingaben!G$36,\"\")))","v":""},{"$f":"IF($B$1<>\"\",\"\",IF(B18<=Eingaben!G$33,O17-N18,\"\"))","v":""},null,{"$f":"+IF(Eingaben!$G$42<=0,\"\",IF(D18=\"\",\"\",IF(B18<Eingaben!$G$42,\"\",Berechnung!B18)))","v":""}]
[null,7,null,{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B19=Eingaben!$G$33,Berechnung!E18,IF(B19<=Eingaben!G$33,E18*Eingaben!G$37,\"\"))))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B19<=Eingaben!G$33,E18-D19,\"\")))","v":""},null,{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B19<=Eingaben!G$33,IF(G18=\"\",IF(H18<>\"\",H18/(Eingaben!G$33-B19+1),\"\"),G18),\"\"))","v":""},{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B19<=Eingaben!G$33,IF(H18=\"\",IF(OR(E19<=N$13,B19=Q$35),E19,\"\"),H18-G19),\"\"))","v":""},"",null,{"$f":"IF($B$1<>\"\",\"\",IF(B19<=Eingaben!G$33,IF(G19=\"\",D19,G19),\"\"))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B19<=Eingaben!G$33,L18-K19,\"\")))","v":""},null,{"$f":"IF($B$1<>\"\",\"\",IF(B19=Eingaben!$G$33,Berechnung!O18,IF(B19<=Eingaben!G$33,O$12*Eingaben!G$36,\"\")))","v":""},{"$f":"IF($B$1<>\"\",\"\",IF(B19<=Eingaben!G$33,O18-N19,\"\"))","v":""},null,{"$f":"+IF(Eingaben!$G$42<=0,\"\",IF(D19=\"\",\"\",IF(B19<Eingaben!$G$42,\"\",Berechnung!B19)))","v":""}]
[null,8,null,{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B20=Eingaben!$G$33,Berechnung!E19,IF(B20<=Eingaben!G$33,E19*Eingaben!G$37,\"\"))))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B20<=Eingaben!G$33,E19-D20,\"\")))","v":""},null,{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B20<=Eingaben!G$33,IF(G19=\"\",IF(H19<>\"\",H19/(Eingaben!G$33-B20+1),\"\"),G19),\"\"))","v":""},{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B20<=Eingaben!G$33,IF(H19=\"\",IF(OR(E20<=N$13,B20=Q$35),E20,\"\"),H19-G20),\"\"))","v":""},"",null,{"$f":"IF($B$1<>\"\",\"\",IF(B20<=Eingaben!G$33,IF(G20=\"\",D20,G20),\"\"))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B20<=Eingaben!G$33,L19-K20,\"\")))","v":""},null,{"$f":"IF($B$1<>\"\",\"\",IF(B20=Eingaben!$G$33,Berechnung!O19,IF(B20<=Eingaben!G$33,O$12*Eingaben!G$36,\"\")))","v":""},{"$f":"IF($B$1<>\"\",\"\",IF(B20<=Eingaben!G$33,O19-N20,\"\"))","v":""},null,{"$f":"+IF(Eingaben!$G$42<=0,\"\",IF(D20=\"\",\"\",IF(B20<Eingaben!$G$42,\"\",Berechnung!B20)))","v":""}]
[null,9,null,{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B21=Eingaben!$G$33,Berechnung!E20,IF(B21<=Eingaben!G$33,E20*Eingaben!G$37,\"\"))))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B21<=Eingaben!G$33,E20-D21,\"\")))","v":""},null,{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B21<=Eingaben!G$33,IF(G20=\"\",IF(H20<>\"\",H20/(Eingaben!G$33-B21+1),\"\"),G20),\"\"))","v":""},{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B21<=Eingaben!G$33,IF(H20=\"\",IF(OR(E21<=N$13,B21=Q$35),E21,\"\"),H20-G21),\"\"))","v":""},"",null,{"$f":"IF($B$1<>\"\",\"\",IF(B21<=Eingaben!G$33,IF(G21=\"\",D21,G21),\"\"))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B21<=Eingaben!G$33,L20-K21,\"\")))","v":""},null,{"$f":"IF($B$1<>\"\",\"\",IF(B21=Eingaben!$G$33,Berechnung!O20,IF(B21<=Eingaben!G$33,O$12*Eingaben!G$36,\"\")))","v":""},{"$f":"IF($B$1<>\"\",\"\",IF(B21<=Eingaben!G$33,O20-N21,\"\"))","v":""},null,{"$f":"+IF(Eingaben!$G$42<=0,\"\",IF(D21=\"\",\"\",IF(B21<Eingaben!$G$42,\"\",Berechnung!B21)))","v":""}]
[null,10,null,{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B22=Eingaben!$G$33,Berechnung!E21,IF(B22<=Eingaben!G$33,E21*Eingaben!G$37,\"\"))))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B22<=Eingaben!G$33,E21-D22,\"\")))","v":""},null,{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B22<=Eingaben!G$33,IF(G21=\"\",IF(H21<>\"\",H21/(Eingaben!G$33-B22+1),\"\"),G21),\"\"))","v":""},{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B22<=Eingaben!G$33,IF(H21=\"\",IF(OR(E22<=N$13,B22=Q$35),E22,\"\"),H21-G22),\"\"))","v":""},"",null,{"$f":"IF($B$1<>\"\",\"\",IF(B22<=Eingaben!G$33,IF(G22=\"\",D22,G22),\"\"))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B22<=Eingaben!G$33,L21-K22,\"\")))","v":""},null,{"$f":"IF($B$1<>\"\",\"\",IF(B22=Eingaben!$G$33,Berechnung!O21,IF(B22<=Eingaben!G$33,O$12*Eingaben!G$36,\"\")))","v":""},{"$f":"IF($B$1<>\"\",\"\",IF(B22<=Eingaben!G$33,O21-N22,\"\"))","v":""},null,{"$f":"+IF(Eingaben!$G$42<=0,\"\",IF(D22=\"\",\"\",IF(B22<Eingaben!$G$42,\"\",Berechnung!B22)))","v":""}]
[null,11,null,{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B23=Eingaben!$G$33,Berechnung!E22,IF(B23<=Eingaben!G$33,E22*Eingaben!G$37,\"\"))))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B23<=Eingaben!G$33,E22-D23,\"\")))","v":""},null,{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B23<=Eingaben!G$33,IF(G22=\"\",IF(H22<>\"\",H22/(Eingaben!G$33-B23+1),\"\"),G22),\"\"))","v":""},{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B23<=Eingaben!G$33,IF(H22=\"\",IF(OR(E23<=N$13,B23=Q$35),E23,\"\"),H22-G23),\"\"))","v":""},"",null,{"$f":"IF($B$1<>\"\",\"\",IF(B23<=Eingaben!G$33,IF(G23=\"\",D23,G23),\"\"))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B23<=Eingaben!G$33,L22-K23,\"\")))","v":""},null,{"$f":"IF($B$1<>\"\",\"\",IF(B23=Eingaben!$G$33,Berechnung!O22,IF(B23<=Eingaben!G$33,O$12*Eingaben!G$36,\"\")))","v":""},{"$f":"IF($B$1<>\"\",\"\",IF(B23<=Eingaben!G$33,O22-N23,\"\"))","v":""},null,{"$f":"+IF(Eingaben!$G$42<=0,\"\",IF(D23=\"\",\"\",IF(B23<Eingaben!$G$42,\"\",Berechnung!B23)))","v":""}]
[null,12,null,{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B24=Eingaben!$G$33,Berechnung!E23,IF(B24<=Eingaben!G$33,E23*Eingaben!G$37,\"\"))))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B24<=Eingaben!G$33,E23-D24,\"\")))","v":""},null,{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B24<=Eingaben!G$33,IF(G23=\"\",IF(H23<>\"\",H23/(Eingaben!G$33-B24+1),\"\"),G23),\"\"))","v":""},{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B24<=Eingaben!G$33,IF(H23=\"\",IF(OR(E24<=N$13,B24=Q$35),E24,\"\"),H23-G24),\"\"))","v":""},"",null,{"$f":"IF($B$1<>\"\",\"\",IF(B24<=Eingaben!G$33,IF(G24=\"\",D24,G24),\"\"))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B24<=Eingaben!G$33,L23-K24,\"\")))","v":""},null,{"$f":"IF($B$1<>\"\",\"\",IF(B24=Eingaben!$G$33,Berechnung!O23,IF(B24<=Eingaben!G$33,O$12*Eingaben!G$36,\"\")))","v":""},{"$f":"IF($B$1<>\"\",\"\",IF(B24<=Eingaben!G$33,O23-N24,\"\"))","v":""},null,{"$f":"+IF(Eingaben!$G$42<=0,\"\",IF(D24=\"\",\"\",IF(B24<Eingaben!$G$42,\"\",Berechnung!B24)))","v":""}]
[null,13,3,{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B25=Eingaben!$G$33,Berechnung!E24,IF(B25<=Eingaben!G$33,E24*Eingaben!G$37,\"\"))))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B25<=Eingaben!G$33,E24-D25,\"\")))","v":""},null,{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B25<=Eingaben!G$33,IF(G24=\"\",IF(H24<>\"\",H24/(Eingaben!G$33-B25+1),\"\"),G24),\"\"))","v":""},{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B25<=Eingaben!G$33,IF(H24=\"\",IF(OR(E25<=N$13,B25=Q$35),E25,\"\"),H24-G25),\"\"))","v":""},"",null,{"$f":"IF($B$1<>\"\",\"\",IF(B25<=Eingaben!G$33,IF(G25=\"\",D25,G25),\"\"))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B25<=Eingaben!G$33,L24-K25,\"\")))","v":""},null,{"$f":"IF($B$1<>\"\",\"\",IF(B25=Eingaben!$G$33,Berechnung!O24,IF(B25<=Eingaben!G$33,O$12*Eingaben!G$36,\"\")))","v":""},{"$f":"IF($B$1<>\"\",\"\",IF(B25<=Eingaben!G$33,O24-N25,\"\"))","v":""},null,{"$f":"+IF(Eingaben!$G$42<=0,\"\",IF(D25=\"\",\"\",IF(B25<Eingaben!$G$42,\"\",Berechnung!B25)))","v":""}]
[null,14,null,{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B26=Eingaben!$G$33,Berechnung!E25,IF(B26<=Eingaben!G$33,E25*Eingaben!G$37,\"\"))))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B26<=Eingaben!G$33,E25-D26,\"\")))","v":""},null,{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B26<=Eingaben!G$33,IF(G25=\"\",IF(H25<>\"\",H25/(Eingaben!G$33-B26+1),\"\"),G25),\"\"))","v":""},{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B26<=Eingaben!G$33,IF(H25=\"\",IF(OR(E26<=N$13,B26=Q$35),E26,\"\"),H25-G26),\"\"))","v":""},"",null,{"$f":"IF($B$1<>\"\",\"\",IF(B26<=Eingaben!G$33,IF(G26=\"\",D26,G26),\"\"))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B26<=Eingaben!G$33,L25-K26,\"\")))","v":""},null,{"$f":"IF($B$1<>\"\",\"\",IF(B26=Eingaben!$G$33,Berechnung!O25,IF(B26<=Eingaben!G$33,O$12*Eingaben!G$36,\"\")))","v":""},{"$f":"IF($B$1<>\"\",\"\",IF(B26<=Eingaben!G$33,O25-N26,\"\"))","v":""},null,{"$f":"+IF(Eingaben!$G$42<=0,\"\",IF(D26=\"\",\"\",IF(B26<Eingaben!$G$42,\"\",Berechnung!B26)))","v":""}]
[null,15,0.3,{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B27=Eingaben!$G$33,Berechnung!E26,IF(B27<=Eingaben!G$33,E26*Eingaben!G$37,\"\"))))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B27<=Eingaben!G$33,E26-D27,\"\")))","v":""},null,{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B27<=Eingaben!G$33,IF(G26=\"\",IF(H26<>\"\",H26/(Eingaben!G$33-B27+1),\"\"),G26),\"\"))","v":""},{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B27<=Eingaben!G$33,IF(H26=\"\",IF(OR(E27<=N$13,B27=Q$35),E27,\"\"),H26-G27),\"\"))","v":""},"",null,{"$f":"IF($B$1<>\"\",\"\",IF(B27<=Eingaben!G$33,IF(G27=\"\",D27,G27),\"\"))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B27<=Eingaben!G$33,L26-K27,\"\")))","v":""},null,{"$f":"IF($B$1<>\"\",\"\",IF(B27=Eingaben!$G$33,Berechnung!O26,IF(B27<=Eingaben!G$33,O$12*Eingaben!G$36,\"\")))","v":""},{"$f":"IF($B$1<>\"\",\"\",IF(B27<=Eingaben!G$33,O26-N27,\"\"))","v":""},null,{"$f":"+IF(Eingaben!$G$42<=0,\"\",IF(D27=\"\",\"\",IF(B27<Eingaben!$G$42,\"\",Berechnung!B27)))","v":""}]
[null,16,null,{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B28=Eingaben!$G$33,Berechnung!E27,IF(B28<=Eingaben!G$33,E27*Eingaben!G$37,\"\"))))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B28<=Eingaben!G$33,E27-D28,\"\")))","v":""},null,{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B28<=Eingaben!G$33,IF(G27=\"\",IF(H27<>\"\",H27/(Eingaben!G$33-B28+1),\"\"),G27),\"\"))","v":""},{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B28<=Eingaben!G$33,IF(H27=\"\",IF(OR(E28<=N$13,B28=Q$35),E28,\"\"),H27-G28),\"\"))","v":""},"",null,{"$f":"IF($B$1<>\"\",\"\",IF(B28<=Eingaben!G$33,IF(G28=\"\",D28,G28),\"\"))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B28<=Eingaben!G$33,L27-K28,\"\")))","v":""},null,{"$f":"IF($B$1<>\"\",\"\",IF(B28=Eingaben!$G$33,Berechnung!O27,IF(B28<=Eingaben!G$33,O$12*Eingaben!G$36,\"\")))","v":""},{"$f":"IF($B$1<>\"\",\"\",IF(B28<=Eingaben!G$33,O27-N28,\"\"))","v":""},null,{"$f":"+IF(Eingaben!$G$42<=0,\"\",IF(D28=\"\",\"\",IF(B28<Eingaben!$G$42,\"\",Berechnung!B28)))","v":""}]
[null,17,null,{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B29=Eingaben!$G$33,Berechnung!E28,IF(B29<=Eingaben!G$33,E28*Eingaben!G$37,\"\"))))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B29<=Eingaben!G$33,E28-D29,\"\")))","v":""},null,{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B29<=Eingaben!G$33,IF(G28=\"\",IF(H28<>\"\",H28/(Eingaben!G$33-B29+1),\"\"),G28),\"\"))","v":""},{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B29<=Eingaben!G$33,IF(H28=\"\",IF(OR(E29<=N$13,B29=Q$35),E29,\"\"),H28-G29),\"\"))","v":""},"",null,{"$f":"IF($B$1<>\"\",\"\",IF(B29<=Eingaben!G$33,IF(G29=\"\",D29,G29),\"\"))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B29<=Eingaben!G$33,L28-K29,\"\")))","v":""},null,{"$f":"IF($B$1<>\"\",\"\",IF(B29=Eingaben!$G$33,Berechnung!O28,IF(B29<=Eingaben!G$33,O$12*Eingaben!G$36,\"\")))","v":""},{"$f":"IF($B$1<>\"\",\"\",IF(B29<=Eingaben!G$33,O28-N29,\"\"))","v":""},null,{"$f":"+IF(Eingaben!$G$42<=0,\"\",IF(D29=\"\",\"\",IF(B29<Eingaben!$G$42,\"\",Berechnung!B29)))","v":""}]
[null,18,null,{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B30=Eingaben!$G$33,Berechnung!E29,IF(B30<=Eingaben!G$33,E29*Eingaben!G$37,\"\"))))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B30<=Eingaben!G$33,E29-D30,\"\")))","v":""},null,{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B30<=Eingaben!G$33,IF(G29=\"\",IF(H29<>\"\",H29/(Eingaben!G$33-B30+1),\"\"),G29),\"\"))","v":""},{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B30<=Eingaben!G$33,IF(H29=\"\",IF(OR(E30<=N$13,B30=Q$35),E30,\"\"),H29-G30),\"\"))","v":""},"",null,{"$f":"IF($B$1<>\"\",\"\",IF(B30<=Eingaben!G$33,IF(G30=\"\",D30,G30),\"\"))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B30<=Eingaben!G$33,L29-K30,\"\")))","v":""},null,{"$f":"IF($B$1<>\"\",\"\",IF(B30=Eingaben!$G$33,Berechnung!O29,IF(B30<=Eingaben!G$33,O$12*Eingaben!G$36,\"\")))","v":""},{"$f":"IF($B$1<>\"\",\"\",IF(B30<=Eingaben!G$33,O29-N30,\"\"))","v":""},null,{"$f":"+IF(Eingaben!$G$42<=0,\"\",IF(D30=\"\",\"\",IF(B30<Eingaben!$G$42,\"\",Berechnung!B30)))","v":""}]
[null,19,null,{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B31=Eingaben!$G$33,Berechnung!E30,IF(B31<=Eingaben!G$33,E30*Eingaben!G$37,\"\"))))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B31<=Eingaben!G$33,E30-D31,\"\")))","v":""},null,{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B31<=Eingaben!G$33,IF(G30=\"\",IF(H30<>\"\",H30/(Eingaben!G$33-B31+1),\"\"),G30),\"\"))","v":""},{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B31<=Eingaben!G$33,IF(H30=\"\",IF(OR(E31<=N$13,B31=Q$35),E31,\"\"),H30-G31),\"\"))","v":""},"",null,{"$f":"IF($B$1<>\"\",\"\",IF(B31<=Eingaben!G$33,IF(G31=\"\",D31,G31),\"\"))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B31<=Eingaben!G$33,L30-K31,\"\")))","v":""},null,{"$f":"IF($B$1<>\"\",\"\",IF(B31=Eingaben!$G$33,Berechnung!O30,IF(B31<=Eingaben!G$33,O$12*Eingaben!G$36,\"\")))","v":""},{"$f":"IF($B$1<>\"\",\"\",IF(B31<=Eingaben!G$33,O30-N31,\"\"))","v":""},null,{"$f":"+IF(Eingaben!$G$42<=0,\"\",IF(D31=\"\",\"\",IF(B31<Eingaben!$G$42,\"\",Berechnung!B31)))","v":""}]
[null,{"$f":"B31+1","v":20},null,{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B32=Eingaben!$G$33,Berechnung!E31,IF(B32<=Eingaben!G$33,E31*Eingaben!G$37,\"\"))))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B32<=Eingaben!G$33,E31-D32,\"\")))","v":""},null,{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B32<=Eingaben!G$33,IF(G31=\"\",IF(H31<>\"\",H31/(Eingaben!G$33-B32+1),\"\"),G31),\"\"))","v":""},{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B32<=Eingaben!G$33,IF(H31=\"\",IF(OR(E32<=N$13,B32=Q$35),E32,\"\"),H31-G32),\"\"))","v":""},"",null,{"$f":"IF($B$1<>\"\",\"\",IF(B32<=Eingaben!G$33,IF(G32=\"\",D32,G32),\"\"))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B32<=Eingaben!G$33,L31-K32,\"\")))","v":""},null,{"$f":"IF($B$1<>\"\",\"\",IF(B32=Eingaben!$G$33,Berechnung!O31,IF(B32<=Eingaben!G$33,O$12*Eingaben!G$36,\"\")))","v":""},{"$f":"IF($B$1<>\"\",\"\",IF(B32<=Eingaben!G$33,O31-N32,\"\"))","v":""},null,{"$f":"+IF(Eingaben!$G$42<=0,\"\",IF(D32=\"\",\"\",IF(B32<Eingaben!$G$42,\"\",Berechnung!B32)))","v":""}]
[null,{"$f":"B32+1","v":21},null,{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B33=Eingaben!$G$33,Berechnung!E32,IF(B33<=Eingaben!G$33,E32*Eingaben!G$37,\"\"))))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B33<=Eingaben!G$33,E32-D33,\"\")))","v":""},null,{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B33<=Eingaben!G$33,IF(G32=\"\",IF(H32<>\"\",H32/(Eingaben!G$33-B33+1),\"\"),G32),\"\"))","v":""},{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",IF(B33<=Eingaben!G$33,IF(H32=\"\",IF(OR(E33<=N$13,B33=Q$35),E33,\"\"),H32-G33),\"\"))","v":""},"",null,{"$f":"IF($B$1<>\"\",\"\",IF(B33<=Eingaben!G$33,IF(G33=\"\",D33,G33),\"\"))","v":""},{"$f":"IF(OR(Eingaben!$G$47=0,Eingaben!$G$48=0),\"\",IF($B$1<>\"\",\"\",IF(B33<=Eingaben!G$33,L32-K33,\"\")))","v":""},null,{"$f":"IF($B$1<>\"\",\"\",IF(B33=Eingaben!$G$33,Berechnung!O32,IF(B33<=Eingaben!G$33,O$12*Eingaben!G$36,\"\")))","v":""},{"$f":"IF($B$1<>\"\",\"\",IF(B33<=Eingaben!G$33,O32-N33,\"\"))","v":""},null,{"$f":"+IF(Eingaben!$G$42<=0,\"\",IF(D33=\"\",\"\",IF(B33<Eingaben!$G$42,\"\",Berechnung!B33)))","v":""}]
[]
[null,"∑",null,{"$f":"IF($B$1<>\"\",\"\",SUM(D12:D33))","v":""},null,null,{"$f":"IF(OR($B$1<>\"\",$R$8<>\"OK\"),\"\",SUM(G12:G33))","v":""},{"$nulls":3},{"$f":"IF($B$1<>\"\",\"\",SUM(K12:K33))","v":""},null,null,{"$f":"IF($B$1<>\"\",\"\",SUM(N12:N33))","v":""},null,null,{"$f":"IF(ISERROR(MIN(Q12:Q33)),22,MIN(Q12:Q33))","v":0}]
[]
[null,"<< Startseite",null,null,"Hilfe?",null,"Beispiel"]
[]
[null,"© 2023 by mediaforwork - ein Unternehmensbereich der Verlag für die Deutsche Wirtschaft AG"]
[null,"Die Vervielfältigung, Verbreitung oder Veräußerung der Daten oder Texte ist unzulässig und"]
[null,"ausdrücklich nur mit Genehmigung des Verlags gestattet."]

{"sheet":"Beispiel","index":3,"n_rows":56,"n_cols":11,"rows_kept":56,"merged":[[1,1,1,10],[3,3,3,6],[5,6,5,8],[6,6,6,8],[7,6,7,8],[12,3,12,6],[18,6,18,8],[44,3,44,6],[51,1,51,3]]}
[{"$nulls":10},"Beispiel"]
[null,"Abschreibungen - Eingaben"]
[]
[{"$nulls":3},"Stammdaten"]
[]
[{"$nulls":3},"Firma",null,null,"Müller GmbH & CoKG"]
[{"$nulls":3},"Straße",null,null,"Müllerweg 7"]
[{"$nulls":3},"PLZ, Ort",null,null,"47123 Müllersdorf"]
[]
[]
[]
[]
[{"$nulls":3},"Ermittlung der Bemessungsgrundlage"]
[]
[{"$nulls":6},{"$f":"IF(OR(ISTEXT(G31),ISTEXT(G33),ISTEXT(G30),ISTEXT(G47),ISTEXT(G48),G31<0,G31=\"\",G33<0,G33<>INT(G33),G33=\"\",G26=\"\"),\"Fehlerhafte Eingabe. Berechnung unmöglich!\",IF(OR(ISNUMBER(G21)=FALSE,G21=\"\"),\"Falsche oder fehlende Datumseingabe!\",\"\"))","v":""}]
[{"$nulls":3},"Allgemeine Angaben:"]
[]
[{"$nulls":3},"Inventarnummer:",null,null,4711]
[{"$nulls":3},"Anlage/Maschine:",null,null,"Fräsmaschine Typ GanzSchönSchnell"]
[]
[{"$nulls":3},"Anschaffungsdatum:",null,null,"2020-01-01"]
[{"$nulls":3},"Nutzungsdauer in Jahren:",null,null,{"v":10,"d":"10 Jahre"}]
[]
[{"$nulls":3},"Anschaffungskosten:"]
[]
[{"$nulls":3},"Neupreis netto ohne USt.:",null,null,{"v":95000,"d":"95,000.00"}]
[{"$nulls":3},"+ Nebenkosten der Anschaffung:",null,null,{"v":5000,"d":"5,000.00"}]
[{"$nulls":3},"+ Nachträgliche Anschaffungskosten:",null,null,{"v":0,"d":"0.00"}]
[{"$nulls":3},"- Skonti, Rabatte, andere Minderungen:",null,null,{"v":0,"d":"0.00"}]
[{"$nulls":3},"- Schrottwert nach Nutzungsdauer:",null,null,{"v":0,"d":"0.00"}]
[{"$nulls":3},"AfA-Bemessungsgrundlage in Euro:",null,null,{"$f":"IF(ISERROR(SUM(G26,G27,G28,-G29,-G30)),\"\",SUM(G26,G27,G28,-G29,-G30))","v":{"v":100000,"d":"100,000.00"}}]
[]
[{"$nulls":3},"Abschreibungsperioden in Jahren:",null,null,{"$f":"IF(ISERROR(IF(13-MONTH(G21)<>12,G22+1,G22)),\"\",IF(13-MONTH(G21)<>12,G22+1,G22))","v":10}]
[]
[{"$nulls":3},"Abschreibung pro Jahr in %:"]
[{"$nulls":3},"- Lineare AfA:",null,null,{"$f":"IF(ISERROR(IF(G22>0,1/G22,\"\")),\"\",IF(G22>0,1/G22,\"\"))","v":{"v":0.1,"d":"10.000%"}}]
[{"$nulls":3},"- Degressive AfA:",null,null,{"$f":"IF(ISERROR(IF($G$15<>\"\",\"\",IF(G22>0,IF(G36*G47>G48,G48,G36*G47),\"\"))),\"\",IF($G$15<>\"\",\"\",IF(G22>0,IF(G36*G47>G48,G48,G36*G47),\"\")))","v":{"v":0.25,"d":"25.000%"}}]
[]
[{"$nulls":3},"AfA-Perioden im ersten Jahr:",null,null,{"$f":"IF(ISERROR(IF($G$15<>\"\",\"\",13-MONTH(G21))),\"\",IF($G$15<>\"\",\"\",13-MONTH(G21)))","v":12}]
[{"$nulls":6},{"$f":"IF($G$15<>\"\",\"\",12-G39)","v":0}]
[]
[{"$nulls":3},"Jahr des AfA-Wechsels",null,null,{"$f":"+IF(ISERROR(ROUND((1+G22)-(100/(100*G37)),0)),\"\",ROUND((1+G22)-(100/(100*G37)),0))","v":7}]
[]
[]
[{"$nulls":3},"Parameter für degressive Abschreibung"]
[]
[{"$nulls":3},"Degressiver Multiplikator:",null,null,{"v":2.5,"d":"2.50-fach"},{"$f":"+IF(M21<2011,\"\",\"  DegressiveAbschreibung ab\")","v":""}]
[{"$nulls":3},"Degressiver Höchstsatz absolut:",null,null,{"v":0.25,"d":"25.00%"},{"$f":"+IF(M21<2011,\"\",\"  2011 nicht mehr möglich\")","v":""}]
[]
[]
[]
[null,"<< Startseite",null,null,"Hilfe?"]
[]
[null,"© 2023 by mediaforwork - ein Unternehmensbereich der Verlag für die Deutsche Wirtschaft AG"]
[null,"Die Vervielfältigung, Verbreitung oder Veräußerung der Daten oder Texte ist unzulässig und"]
[null,"ausdrücklich nur mit Genehmigung des Verlags gestattet."]

{"sheet":"Hilfe","index":4,"n_rows":23,"n_cols":9,"rows_kept":23,"merged":[[2,1,2,8],[18,1,18,3]]}
[]
[{"$nulls":8},"Hilfe"]
[null,"Abschreibungsvorteile - Hilfe"]
[]
[null,null,"Allgemeine Hinweise"]
[]
[]
[]
[null,null,"Hinweise zum Tool Abschreibungsvorteile"]
{"$rows_empty":9}
[null,"<< Startseite"]
[]
[null,"© 2023 by mediaforwork - ein Unternehmensbereich der Verlag für die Deutsche Wirtschaft AG"]
[null,"Die Vervielfältigung, Verbreitung oder Veräußerung der Daten oder Texte ist unzulässig und"]
[null,"ausdrücklich nur mit Genehmigung des Verlags gestattet."]

{"sheet":"Parameter_Intern","index":5,"n_rows":35,"n_cols":5,"rows_kept":35,"hidden":true}
[]
[]
[]
[null,"Nr","Tabellenblatt","Hinweise","Hyperlink"]
[null,1,"Eingaben","Hier geben Sie die Daten für die Berechnung der Abschreibung ein","#Eingaben!B2"]
[null,2,"Berechnung","In diesem Arbeitsblatt wird die Abschreibung berechnet","#Berechnung!B2"]
[null,3,"Beispiel","Hier finden Sie ein Beispiel für die Berechnung der Abschreibung","#Beispiel!B2"]
[null,4,"Hilfe","Hier finden Sie nähere Informationen über die Anwendung.","#Hilfe!B3"]
{"$rows_empty":24}
[null,"© 2011 by BWRmed!a - ein Unternehmensbereich der Verlag für die Deutsche Wirtschaft AG"]
[null,"Die Vervielfältigung, Verbreitung oder Veräußerung der Daten oder Texte ist unzulässig und"]
[null,"ausdrücklich nur mit Genehmigung des Verlags gestattet."]