{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Zinsberechnung Konkursamt SG"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Zinsberechnung Konkursamt SG","index":0,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Zinsberechnungen"]
[]
["Wichtig:","* an diesem Tag beginnt der Zinsenlauf"]
[null,"** letzter Tag des Zinsenlaufes (z.B. Datum der Konkurseröffnung, gem. Art. 209 SchKG)"]
[]
["Kapital","Zinssatz in %","*Anfangsdatum","**Enddatum","Zinstage","Zins","Kapital und Zins (gerundet)"]
[null,null,null,null,{"$f":"IF(D7=\"\",\"\",(D7-C7))","v":""},{"$f":"IF(E7=\"\",\"\",(((A7/100)*B7)*E7)/365)","v":""},{"$f":"IF(F7=\"\",\"\",INT(20*(A7+F7)+0.5)/20)","v":""}]
[null,null,null,null,{"$f":"IF(D8=\"\",\"\",(D8-C8))","v":""},{"$f":"IF(E8=\"\",\"\",(((A8/100)*B8)*E8)/365)","v":""},{"$f":"IF(F8=\"\",\"\",INT(20*(A8+F8)+0.5)/20)","v":""}]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,{"$f":"IF(D28=\"\",\"\",(D28-C28))","v":""},"",""]
[]
[null,null,null,null,"Total",{"$f":"SUM(F7:F28)","v":0},{"$f":"SUM(G7:G28)","v":0}]