{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Bankenspiegel"],"read":"whole","date_system":"1900"}

{"sheet":"Bankenspiegel","index":0,"n_rows":50,"n_cols":13,"rows_kept":50,"merged":[[1,4,1,7],[1,8,1,12],[2,4,2,7],[2,8,2,12],[3,4,3,7],[3,8,3,12],[7,3,7,5],[7,6,7,7],[7,8,7,9],[7,11,7,12],[8,3,8,5],[8,6,8,7],[8,8,8,9],[8,11,8,12],[9,3,9,5],[9,6,9,7],[9,8,9,9],[9,11,9,12],[10,3,10,5],[10,6,10,7],[10,8,10,9],[10,11,10,12],[11,3,11,5],[11,6,11,7],[11,8,11,9],[11,11,11,12],[12,3,12,5],[12,6,12,7],[12,8,12,9],[12,11,12,12],[13,3,13,5],[13,6,13,7],[13,8,13,9],[13,11,13,12],[14,3,14,5],[14,6,14,7],[14,8,14,9],[14,11,14,12],[15,3,15,5],[15,6,15,7],[15,8,15,9],[15,11,15,12],[20,1,21,1],[20,2,21,2],[20,3,21,3],[20,4,21,4],[20,5,21,5],[20,6,21,6],[20,7,21,7],[20,8,20,11],[20,12,21,12],[42,1,43,1],[42,2,43,2],[42,3,43,3],[42,4,43,4],[42,5,43,5],[42,6,43,6],[42,7,43,7],[42,8,42,11],[42,12,43,12]]}
[]
[]
[{"$nulls":4},"Kreditnehmer"]
[{"$nulls":4},"Bankenspiegel per "]
[]
[null,"1.) kurzfristige Kreditlinien bei Kreditinstituten"]
[]
[null,"Kreditgeber","Konto-Nr.\n(alternativ JA-/ BWA Konto)","Art der Linie (Kontokorrent, Wechsel, Avallinie, Geldmarktkredit, Auftragsfinanzierung)",null,null,"Höhe der Kreditlinie zum Bilanzstichtag (in T€)",null,"Zinssatz",null,"zugesagte Laufzeit der Kreditlinie","Verwendungszweck"]
{"$rows_empty":7}
[null,"Summe",{"$nulls":4},{"$f":"SUM(G9:G15)","v":{"v":0,"d":"0.0"}}]
[]
[]
[null,"2.) Darlehensverbindlichkeiten gegenüber Kreditinstituten (incl. Kreditaufnahmen nach dem Bilanzstichtag)"]
[]
[null,"Kreditgeber ","Konto-Nr.\n(alternativ JA-/ BWA Konto)","Ursprungs-\nsumme\n (in T€)","Auszahlung am","Stand zum Bilanzstichtag (in T€)","Zinssatz","Zinsbindungs-\nfrist (fest bis \noder variabel)           ","Rückzahlungsraten",{"$nulls":3},"Verwendungszweck"]
[{"$nulls":8},"erstmals ab"," mtl. Rate \n(in T€)","T= Tilgung  \nA= Annuität","Betrag p.a. \n(in T€)"]
[{"$nulls":11},{"$f":"IF(J23=0,\"\",J23*12)","v":""}]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},{"$f":"IF(J30=0,\"\",J30*12)","v":""}]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},""]
[{"$nulls":11},{"$f":"IF(J34=0,\"\",J34*12)","v":""}]
[{"$nulls":11},""]
[null,"Summe",null,{"$f":"SUM(D23:D35)","v":{"v":0,"d":"0.0"}},null,{"$f":"SUM(F23:F35)","v":{"v":0,"d":"0.0"}},{"$nulls":3},{"$f":"SUM(J23:J35)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(L23:L35)","v":{"v":0,"d":"0.0"}}]
[]
[]
[]
[]
[null,"3.) sonstige Kredite, Verbindlichkeiten, Mietkaufraten, Eventualverbindlichkeiten (incl. Kreditaufnahmen nach Bilanzstichtag)"]
[]
[null,"Kreditgeber ","Konto-Nr.\n(alternativ JA-/ BWA Konto)","Ursprungs-\nsumme\n (in T€)","Auszahlung am","Stand zum Bilanzstichtag (in T€)","Zinssatz","Zinsbindungs-\nfrist (fest bis \noder variabel)           ","Rückzahlungsraten",{"$nulls":3},"Verwendungszweck"]
[{"$nulls":8},"erstmals ab"," mtl. Rate \n(in T€)","T= Tilgung  \nA= Annuität","Betrag p.a. \n(in T€)"]
[{"$nulls":11},{"$f":"IF(J45=0,\"\",J45*12)","v":""}]
[{"$nulls":11},""]
[{"$nulls":11},{"$f":"IF(J47=0,\"\",J47*12)","v":""}]
[{"$nulls":11},{"$f":"IF(J48=0,\"\",J48*12)","v":""}]
[{"$nulls":11},{"$f":"IF(J49=0,\"\",J49*12)","v":""}]
[null,"Summe",null,{"$f":"SUM(D45:D49)","v":{"v":0,"d":"0.0"}},null,{"$f":"SUM(F45:F49)","v":{"v":0,"d":"0.0"}},{"$nulls":3},{"$f":"SUM(J45:J49)","v":{"v":0,"d":"0.0"}},null,{"$f":"SUM(L45:L49)","v":{"v":0,"d":"0.0"}}]