{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Cover","LIA","DIA","GDA","GDA2","VDB"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover","index":0,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Excel + VBA "]
[null,"für Controller"]
[]
[]
[null,"Kapitel",3]
[null,"Thema","Formeln und Funktionen"]
[]
[null,"Inhalt","Abschreibungsfunktionen"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Version","1.0"]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2025-04-25"]
[]
[]
[null,"Springer Verlag"]

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

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

{"sheet":"GDA","index":3,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Parameter","Wert"]
["Anschaffungskosten",27000]
["Restwert",2500]
["zu errechnender Zeitpunkt",3]
["Abschreibungsfaktor",1.5]
["Nutzungsdauer",6]
["Abschreibungsbetrag",{"$f":"DDB(AnKosten,Restwert,Dauer,Zeitpunkt,Faktor)","v":3796.875}]

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

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