{"text_format":"1","workbook":"xls","n_sheets":2,"sheets":["Daten","Pivot Renta"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":2,"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","formulas":"cached_only"}

{"sheet":"Daten","index":0,"n_rows":4,"n_cols":19,"rows_kept":4,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Kriterium",null,"Vergleich","Eingabe"]
[]
[]
["Jahr","Kunde Nr","Kunde SammelNr","Kunde Ablagename","Firmenberater","Sachbearbeiter","SpartenhauptgruppeNr","SpartenhauptgruppeBez","SpartengruppeNr","SpartengruppeBez","VR Nr","VR Ablagename","Police","Reguliert","SummePrämien","AnzSchäden","SummeSchäden","SummeReserven","SummeGesamtschäden"]

{"sheet":"Pivot Renta","index":1,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[]
[null,null,"Daten"]
["Bezeichnung","Jahr","Anzahl","Prämienzahlungen","Schadenzahlungen","Reserven","Gesamtschaden","Quote ohne Reserve","Quote mit Reserve"]
["Kraftfahrt",1999,3,6962.22,834.92,0,834.92,0.11992151928551527,0.11992151928551527]
[null,2000,4,9013.06,3188.21,0,3188.21,0.35373225075612497,0.35373225075612497]
[null,2001,1,9996.87,209.43,0,209.43,0.02094955721140717,0.02094955721140717]
[null,2002,4,6452.19,2459.55,1900,4359.55,0.3811961520042032,0.6756698113353761]
[null,2003,6,8576.39,3629.2,0,3629.2,0.42316172655394635,0.42316172655394635]
[null,2004,6,7892.5,1296.87,1200,2496.87,0.16431675641431737,0.31635983528666456]
[null,2005,5,10254.95,246.12,300,546.12,0.02400011701666025,0.05325428207841092]
["Kraftfahrt Ergebnis",null,29,59148.18,11864.3,3400,15264.3,0.200586053535375,0.2580688027932558]
["Gesamtergebnis",null,29,59148.18,11864.3,3400,15264.3,0.200586053535375,0.2580688027932558]