{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Startseite","Berechnung","Hilfe","Parameter_Intern"],"not_rendered":{"images":2,"macros":1,"defined_names":15},"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,"Sammelposten verwalten"]
[]
[]
[]
[{"$nulls":3},"Tabellenblätter",{"$nulls":8},"Tabellenblatt",2]
[{"$nulls":6},"Info"]
[{"$nulls":6},{"$f":"INDEX(Parameter_Intern!C5:D6,Startseite!N9,2)","v":"Hier finden Sie nähere Informationen über die Anwendung."},{"$nulls":5},{"$f":"+N9/2","v":1},{"$f":"+ROUND(N9/2,0)","v":1}]
[{"$nulls":12},{"$f":"IF(M11=N11,1,2)","v":1}]
[]
[]
[]
[]
[{"$nulls":3},{"$f":"\"Bei einem Klick auf \"&H17&\" kommen Sie direkt zum entsprechenden Arbeitsblatt\"","v":"Bei einem Klick auf Hilfe 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":"Hilfe"}]
{"$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":"Berechnung","index":1,"n_rows":58,"n_cols":25,"rows_kept":58,"merged":[[1,1,1,8],[1,12,1,18],[2,1,2,8],[2,11,2,22],[2,23,3,23],[53,1,53,2]]}
[{"$nulls":23},"Berechnung"]
[null,"Sammelposten verwalten",{"$nulls":10},"GWG - Entwicklung"]
[null,"Angaben zum Sonderposten",{"$nulls":9},"Abschreibungen pro Jahr",{"$nulls":11},"Übertrag /\nRundung"]
[null,"Lfd.Nr","Bezeichnung","Anschaffungs-datum","An-zahl","Einzel-preis","Jahr","Wert","AfA-Betrag","Erstes Jahr","Letzten Jahr",{"$f":"IF(ISERROR(YEAR(D5)-1),2010,YEAR(D5)-1)","v":2019},{"$f":"+L4+1","v":2020},{"$f":"+M4+1","v":2021},2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,{"$f":"IF(I5=\"\",\"\",1)","v":1},"Notebook","2020-02-01","2",{"v":250,"d":"250.00"},{"$f":"IF(ISERROR(IF(D5=\"\",\"\",VALUE(YEAR(D5)))),\"\",IF(D5=\"\",\"\",VALUE(YEAR(D5))))","v":2020},{"$f":"+IF(ISERROR(IF(AND(E5<>\"\",F5<>\"\"),ROUND(E5*F5,2),\"\")),\"\",IF(AND(E5<>\"\",F5<>\"\"),ROUND(E5*F5,2),\"\"))","v":{"v":500,"d":"500.00"}},{"$f":"IF(ISERROR(IF(H5=\"\",\"\",ROUND(H5/5,2))),\"\",IF(H5=\"\",\"\",ROUND(H5/5,2)))","v":{"v":100,"d":"100.00"}},{"$f":"IF(ISERROR(IF(H5=\"\",\"\",VALUE(YEAR(D5)))),\"\",IF(H5=\"\",\"\",VALUE(YEAR(D5))))","v":2020},{"$f":"IF(ISERROR(IF(H5=\"\",\"\",VALUE(J5+4))),\"\",IF(H5=\"\",\"\",VALUE(J5+4)))","v":2024},{"$f":"IF(AND(L$4>=$J5,L$4<=$K5),$I5,\"\")","v":""},{"$f":"IF(AND(M$4>=$J5,M$4<=$K5),$I5,\"\")","v":{"v":100,"d":"100.00"}},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},"","","","","","",{"$f":"+IF(H5=\"\",\"\",H5-SUM(L5:W5))","v":{"v":0,"d":"0.00"}},{"$f":"+IF(D5=\"\",\"\",IF(YEAR(D5)<$L$4,\"Datum vor Jahr \"&$L$4,\"\"))","v":""}]
[null,{"$f":"IF(I6=\"\",\"\",1+MAX($B$5:B5))","v":2},"Computer","2021-06-03","3",999.33,{"$f":"IF(ISERROR(IF(D6=\"\",\"\",VALUE(YEAR(D6)))),\"\",IF(D6=\"\",\"\",VALUE(YEAR(D6))))","v":2021},{"v":2997.99,"d":"2,997.99"},{"$f":"IF(ISERROR(IF(H6=\"\",\"\",ROUND(H6/5,2))),\"\",IF(H6=\"\",\"\",ROUND(H6/5,2)))","v":{"v":599.6,"d":"599.60"}},2021,{"$f":"IF(ISERROR(IF(H6=\"\",\"\",VALUE(J6+4))),\"\",IF(H6=\"\",\"\",VALUE(J6+4)))","v":2025},"","",{"v":599.6,"d":"599.60"},{"v":599.6,"d":"599.60"},{"v":599.6,"d":"599.60"},{"v":599.6,"d":"599.60"},{"v":599.6,"d":"599.60"},"","","","","",{"$f":"+IF(H6=\"\",\"\",H6-SUM(L6:W6))","v":{"v":-0.010000000000218279,"d":"-0.01"}},{"$f":"+IF(D6=\"\",\"\",IF(YEAR(D6)<$L$4,\"Datum vor Jahr \"&$L$4,\"\"))","v":""}]
[null,{"$f":"IF(I7=\"\",\"\",1+MAX($B$5:B6))","v":3},"Drucker","2021-08-01",1,{"v":1000,"d":"1,000.00"},{"$f":"IF(ISERROR(IF(D7=\"\",\"\",VALUE(YEAR(D7)))),\"\",IF(D7=\"\",\"\",VALUE(YEAR(D7))))","v":2021},{"v":1000,"d":"1,000.00"},{"v":200,"d":"200.00"},2021,2025,"","",{"v":200,"d":"200.00"},{"v":200,"d":"200.00"},{"v":200,"d":"200.00"},{"v":200,"d":"200.00"},{"v":200,"d":"200.00"},"","","","","",{"v":0,"d":"0.00"},""]
[null,{"$f":"IF(I8=\"\",\"\",1+MAX($B$5:B7))","v":4},"Drucker","2022-10-01",3,150.01,2022,450.03,90.01,2022,2026,"","","",90.01,90.01,90.01,90.01,90.01,"","","","",{"v":-0.020000000000038654,"d":"-0.02"},""]
[null,{"$f":"IF(I9=\"\",\"\",1+MAX($B$5:B8))","v":""},{"$nulls":5},"","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(I10=\"\",\"\",1+MAX($B$5:B9))","v":""},{"$nulls":4},"","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(I11=\"\",\"\",1+MAX($B$5:B10))","v":""},{"$nulls":5},"","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(I12=\"\",\"\",1+MAX($B$5:B11))","v":""},{"$nulls":4},"","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(I13=\"\",\"\",1+MAX($B$5:B12))","v":""},{"$nulls":4},"","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(I14=\"\",\"\",1+MAX($B$5:B13))","v":""},{"$nulls":4},"","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(I15=\"\",\"\",1+MAX($B$5:B14))","v":""},{"$nulls":4},"","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(I16=\"\",\"\",1+MAX($B$5:B15))","v":""},{"$nulls":4},"","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(I17=\"\",\"\",1+MAX($B$5:B16))","v":""},{"$nulls":4},"","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(I18=\"\",\"\",1+MAX($B$5:B17))","v":""},{"$nulls":4},{"$f":"IF(ISERROR(IF(D18=\"\",\"\",VALUE(YEAR(D18)))),\"\",IF(D18=\"\",\"\",VALUE(YEAR(D18))))","v":""},"","","",{"$f":"IF(ISERROR(IF(H18=\"\",\"\",VALUE(J18+4))),\"\",IF(H18=\"\",\"\",VALUE(J18+4)))","v":""},"",{"$f":"IF(AND(M$4>=$J18,M$4<=$K18),$I18,\"\")","v":""},"","","","","","","","","","",{"$f":"+IF(H18=\"\",\"\",H18-SUM(L18:W18))","v":""},""]
[null,{"$f":"IF(I19=\"\",\"\",1+MAX($B$5:B18))","v":""},{"$nulls":4},{"$f":"IF(ISERROR(IF(D19=\"\",\"\",VALUE(YEAR(D19)))),\"\",IF(D19=\"\",\"\",VALUE(YEAR(D19))))","v":""},"","","",{"$f":"IF(ISERROR(IF(H19=\"\",\"\",VALUE(J19+4))),\"\",IF(H19=\"\",\"\",VALUE(J19+4)))","v":""},"","","","","","","","","","","","",{"$f":"+IF(H19=\"\",\"\",H19-SUM(L19:W19))","v":""},""]
[null,{"$f":"IF(I20=\"\",\"\",1+MAX($B$5:B19))","v":""},{"$nulls":4},"","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(I21=\"\",\"\",1+MAX($B$5:B20))","v":""},{"$nulls":4},"","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(I22=\"\",\"\",1+MAX($B$5:B21))","v":""},{"$nulls":4},"","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(I23=\"\",\"\",1+MAX($B$5:B22))","v":""},{"$nulls":4},"","","","","","",{"$f":"IF(AND(M$4>=$J23,M$4<=$K23),$I23,\"\")","v":""},"","","","","","","","","","","",""]
[null,{"$f":"IF(I24=\"\",\"\",1+MAX($B$5:B23))","v":""},{"$nulls":4},"","","","","",{"$f":"IF(AND(L$4>=$J24,L$4<=$K24),$I24,\"\")","v":""},"","","","","","","","","","","","",""]
[null,{"$f":"IF(I25=\"\",\"\",1+MAX($B$5:B24))","v":""},{"$nulls":4},"","","","","","","","","","","","","","","","","",{"$f":"+IF(H25=\"\",\"\",H25-SUM(L25:W25))","v":""},""]
[null,{"$f":"IF(I26=\"\",\"\",1+MAX($B$5:B25))","v":""},{"$nulls":4},"","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(I27=\"\",\"\",1+MAX($B$5:B26))","v":""},{"$nulls":4},"","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(I28=\"\",\"\",1+MAX($B$5:B27))","v":""},{"$nulls":4},"","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(I29=\"\",\"\",1+MAX($B$5:B28))","v":""},{"$nulls":4},"","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(I30=\"\",\"\",1+MAX($B$5:B29))","v":""},{"$nulls":4},"","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(I31=\"\",\"\",1+MAX($B$5:B30))","v":""},{"$nulls":4},"","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(I32=\"\",\"\",1+MAX($B$5:B31))","v":""},{"$nulls":4},"","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(I33=\"\",\"\",1+MAX($B$5:B32))","v":""},{"$nulls":4},"","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(I34=\"\",\"\",1+MAX($B$5:B33))","v":""},{"$nulls":4},"","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(I35=\"\",\"\",1+MAX($B$5:B34))","v":""},{"$nulls":4},"","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(I36=\"\",\"\",1+MAX($B$5:B35))","v":""},{"$nulls":4},"","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(I37=\"\",\"\",1+MAX($B$5:B36))","v":""},{"$nulls":4},"","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(I38=\"\",\"\",1+MAX($B$5:B37))","v":""},{"$nulls":4},"","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(I39=\"\",\"\",1+MAX($B$5:B38))","v":""},{"$nulls":4},"","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(I40=\"\",\"\",1+MAX($B$5:B39))","v":""},{"$nulls":4},"","","","","",{"$f":"IF(AND(L$4>=$J40,L$4<=$K40),$I40,\"\")","v":""},"","","","","","","","","","","","",""]
[null,{"$f":"IF(I41=\"\",\"\",1+MAX($B$5:B40))","v":""},{"$nulls":4},"","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(I42=\"\",\"\",1+MAX($B$5:B41))","v":""},{"$nulls":4},"","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(I43=\"\",\"\",1+MAX($B$5:B42))","v":""},{"$nulls":4},"","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(I44=\"\",\"\",1+MAX($B$5:B43))","v":""},{"$nulls":4},"","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(I45=\"\",\"\",1+MAX($B$5:B44))","v":""},{"$nulls":4},"","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(I46=\"\",\"\",1+MAX($B$5:B45))","v":""},{"$nulls":4},"","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(I47=\"\",\"\",1+MAX($B$5:B46))","v":""},{"$nulls":4},"","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(I48=\"\",\"\",1+MAX($B$5:B47))","v":""},{"$nulls":4},"","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(I49=\"\",\"\",1+MAX($B$5:B48))","v":""},{"$nulls":4},"","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(I50=\"\",\"\",1+MAX($B$5:B49))","v":""},{"$nulls":4},"","","","","","","","","","","","","","","","","","",""]
[null,"Abschreibungen",{"$nulls":9},{"$f":"SUM(L5:L50)","v":{"v":0,"d":"0.00"}},{"v":100,"d":"100.00"},{"v":899.6,"d":"899.60"},989.61,989.61,989.61,889.61,90.01,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":-0.030000000000256932,"d":"-0.03"}]
[null,"Anschaffungen",{"$nulls":9},{"$f":"+SUMIF($G$5:$G$50,L4,$H$5:$H$50)","v":{"v":0,"d":"0.00"}},{"v":500,"d":"500.00"},{"v":3997.99,"d":"3,997.99"},450.03,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
[null,"<< Startseite",{"$nulls":6},"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":2,"n_rows":23,"n_cols":9,"rows_kept":23,"merged":[[2,1,2,8],[18,1,18,3]]}
[]
[{"$nulls":8},"Hilfe"]
[null,"Sammelposten verwalten - Hilfe"]
[]
[null,null,"Allgemeine Hinweise"]
[]
[]
[]
[null,null,"Hinweise zum Grunderwerbsteuerrechner"]
{"$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":3,"n_rows":35,"n_cols":5,"rows_kept":35,"hidden":true}
[]
[]
[]
[null,"Nr","Tabellenblatt","Hinweise","Hyperlink"]
[null,1,"Berechnung","In diesem Arbeitsblatt wird die Abschreibung für die Sammelposten berechnet","#Berechnung!B2"]
[null,2,"Hilfe","Hier finden Sie nähere Informationen über die Anwendung.","#Hilfe!B3"]
{"$rows_empty":26}
[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."]