{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Brandverz. Donatus","offerte","Polissen","Schades"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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":"Brandverz. Donatus","index":0,"n_rows":62,"n_cols":31,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
["Detailoverzicht brandpolissen Donatus  Parochiefedratie Born ",null,null,null,null,null,null,null,null,null,"Datum offerte: ","2021-03-16",null,null,null,null,null,null,null,null,null,"Optie 1: Uitgebreide dekking inclusief glas en vandalisme, contractduur xx jaar"]
[]
["Relatie-\nnummer","Naam relatie","Polis-\nnummer","Loc. nr.","Gebouwnaam","Taxatie-datum","Risico-adres","Sub","Verzekerde zaak","Dekking","Vork-percentage","Belang","Contracts-termijn (maanden)","Eigen risico","‰","Bruto premie","Indicatieve netto premie",null,null,"Opmerkingen",null,"Dekking","Belang","Basis ‰ (12 maanden)","Contract-termijn\nmnd","Vork %","Eigen risico","‰ ivm contract + trouw lid en Eigen risico, vork","Bruto premie","Indicatieve netto premie","Opmerkingen"]
[423400," H. Martinus Born ","14298/1",1," ","2010-06-25","Kerkstraat Ong. BORN","001","Het kerkgebouw, inclusief de zaken genoemd nummers 1, 13, en 14 van de lijst van Kerkelijk Kunstbezit Nederland van september 1975, en de kerkhofberging, Mgr. Buckxstraat ong. 6121 KV Born ","Brandverzekering",0.50000780993736427,19206300,120,750,0.42720000000000002,8204.93,4922.9579999999996,null,null,{"$f":"IFERROR(IF(K4>0,\"In verband met vork is het percentage \" &100*ROUND(K4,2)& \"% van het verzekerd belang. \",\"\"),\"\")","v":"In verband met vork is het percentage 50% van het verzekerd belang. "},null,null,{"$f":"L4","v":19206300},null,null,null,null,null,{"$f":"W4*AB4/1000","v":0},{"$f":"AC4*(1-restitutiepercentage)","v":0}]
[null,null,null,null,null,null,null,"002","Het orgel ","Brand-stormverzekering"," ",781900,120,750,0.4637,362.57,217.542,null,null,{"$f":"IFERROR(IF(K5>0,\"In verband met vork is het percentage \" &100*ROUND(K5,2)& \"% van het verzekerd belang. \",\"\"),\"\")","v":""},null,null,{"$f":"L5","v":781900},null,null,null,null,null,{"$f":"W5*AB5/1000","v":0},{"$f":"AC5*(1-restitutiepercentage)","v":0}]
[null,null,null,null,null,null,null,"004","De kostbare voorwerpen volgens de door dhr. P.A.A.C. Schalken en dhr. G.H.L.M. Terpelle opgemaakte lijst d.d. 25-06-2010 (op basis van de lijst van Kerkelijk Kunstbezit Nederland van september 1975)~ uitgezonderd de zaken genoemd bij nummers 1, 13 en 14 ","Brand-inbraak-stormverzekering"," ",305000,120,750,0.90529999999999999,276.12,165.672,null,null,"",null,null,305000,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,"005","De overige inventaris aanwezig in de kerk alsmede de inventaris in de kerkhofberging ","Brand-inbraak-stormverzekering"," ",468500,120,750,0.90529999999999999,424.13,254.47799999999998,null,null,"",null,null,468500,null,null,null,null,null,0,0]
[null,null,null,null,"Subtotaal  ",null,null,null,null,null,null,null,null,null,null,9267.75,5560.65,null,null,"",null,null,0,null,null,null,null,null,0,0]
[null,null,"14298/4",1," ","2009-01-20","Bronstraat 2 BORN","001","Het woonhuis ","Woonhuisverzekering"," ",307600,120,750,0.74760000000000004,229.96,137.976,null,null,"",null,null,307600,null,null,null,null,null,0,0]
[null,null,null,null,"Subtotaal  ",null,null,null,null,null,null,null,null,null,null,229.96,137.976,null,null,"",null,null,0,null,null,null,null,null,0,0]
[null,null,null,2," ","2009-01-20","Bronstraat2A BORN","001","De pastorie met parochiekantoor ","Woonhuisverzekering"," ",615100,120,750,0.74760000000000004,459.85,275.91000000000003,null,null,"",null,null,615100,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,"002","De inventaris aanwezig in het parochiekantoor ","Uitgebreide inventarisverz."," ",28100,120,750,1.0680000000000001,30.01,18.006,null,null,"",null,null,28100,null,null,null,null,null,0,0]
[null,null,null,null,"Subtotaal  ",null,null,null,null,null,null,null,null,null,null,489.86,293.916,null,null,"",null,null,0,null,null,null,null,null,0,0]
[423800," H. Catharina Buchten ","14299/1",1,"H. Catharina","2011-01-20","Kerkvonderen 7 BUCHTEN","001","Het kerkgebouw met bidkapel en kerkhofberging (inclusief de nrs: 1 t/m 9 van de lijst van Kerkelijk Kunstbezit Nederland uit 1977, opgemaakt d.d. 13-01-2011 door de heer P.A.A.C. Schalken) ","Brand-stormverzekering",9.99882013493366E-2,9323100,120,0,0.28599999999999998,2666.41,1599.8459999999998,null,null,"In verband met vork is het percentage 10% van het verzekerd belang. ",null,null,9323100,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,"002","De opruimingskosten ","Brand-stormverzekering"," ",203700,120,0,0.64,130.37,78.221999999999994,null,null,"",null,null,203700,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,"003","De toren ","Brand-stormverzekering"," ",1701500,120,0,0.52,884.78,530.86799999999994,null,null,"",null,null,1701500,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,"004","De opruimingskosten ","Brand-stormverzekering"," ",38300,120,0,0.64,24.51,14.706,null,null,"",null,null,38300,null,null,null,null,null,0,0]
[null,null,null,null,"Subtotaal H. Catharina",null,null,null,null,null,null,null,null,null,null,3706.0699999999997,2223.6419999999998,null,null,"",null,null,0,null,null,null,null,null,0,0]
[null,null,null,2,"Kapel van O.L. Vrouw","2011-01-20","Nabij Keerweg 12 BUCHTEN","001","De kapel ","Brand-stormverzekering"," ",53900,120,0,0.48,25.87,15.522,null,null,"",null,null,53900,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,"002","De opruimingskosten. ","Brand-stormverzekering"," ",7900,120,0,0.64,5.0599999999999996,3.0359999999999996,null,null,"",null,null,7900,null,null,null,null,null,0,0]
[null,null,null,null,"Subtotaal Kapel van O.L. Vrouw",null,null,null,null,null,null,null,null,null,null,30.93,18.558,null,null,"",null,null,0,null,null,null,null,null,0,0]
[null,null,"14299/3",1,"H. Catharina","2011-01-20","Kerkvonderen 7 BUCHTEN","001","Het orgel (Gebr. Vermeulen Weert) ","Brand-stormverzekering"," ",484900,120,0,0.504,244.39,146.63399999999999,null,null,"",null,null,484900,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,"002","De kostbare voorwerpen volgens de lijst Kerkelijk Kunstbezit Nederland 1977 d.d. 13-01-2011 van de heer P.A.A.C. Schalken (exclusief de nrs: 1 t/m 11, en 15) ","Brand-inbraak-stormverzekering"," ",118500,120,0,0.98399999999999999,116.6,69.959999999999994,null,null,"",null,null,118500,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,"003","De inventaris aanwezig in de kerk inclusief de voorwerpen uit de voormalige hulpkerk, pastorie en parochiecentrum ","Brand-inbraak-stormverzekering"," ",331800,120,0,0.98399999999999999,326.49,195.89400000000001,null,null,"",null,null,331800,null,null,null,null,null,0,0]
[null,null,null,null,"Subtotaal H. Catharina",null,null,null,null,null,null,null,null,null,null,687.48,412.488,null,null,"",null,null,0,null,null,null,null,null,0,0]
[null,null,null,2,"Kapel van O.L. Vrouw","2011-01-20","Nabij Keerweg 12 BUCHTEN","001","De inventaris aanwezig in de kapel ","Brand-inbraak-stormverzekering"," ",3300,120,0,0.98399999999999999,3.25,1.95,null,null,"",null,null,3300,null,null,null,null,null,0,0]
[null,null,null,null,"Subtotaal Kapel van O.L. Vrouw",null,null,null,null,null,null,null,null,null,null,3.25,1.95,null,null,"",null,null,0,null,null,null,null,null,0,0]
[null,null,"14299/5",1," ","1994-11-02","Dorpstraat 34-34A BUCHTEN","001","De verhuurde voormalige pastorie annex parochiecentrum. ","Woonhuisverzekering"," ",326000,120,0,0.84,273.83999999999997,164.30399999999997,null,null,"",null,null,326000,null,null,null,null,null,0,0]
[null,null,null,null,"Subtotaal  ",null,null,null,null,null,null,null,null,null,null,273.83999999999997,164.30399999999997,null,null,"",null,null,0,null,null,null,null,null,0,0]
[423900," H. Martinus Holtum ","14301/1",1,"H. Martinus","2010-11-02","St. Martinusstraat 3 HOLTUM","001","Het kerkgebouw met kerkhofberging ","Uitgebreide opstalverzekering",0.59999219014396177,7682600,120,750,0.47310000000000002,3634.64,2180.7839999999997,null,null,"In verband met vork is het percentage 60% van het verzekerd belang. ",null,null,7682600,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,"Glasverzekering",0.59999219014396177,7682600,120,750,7.1199999999999999E-2,547,328.2,null,null,"In verband met vork is het percentage 60% van het verzekerd belang. ",null,null,7682600,null,null,null,null,null,0,0]
[null,null,null,null,"Subtotaal H. Martinus",null,null,null,null,null,null,null,null,null,null,4181.6399999999994,2508.9839999999995,null,null,"",null,null,0,null,null,null,null,null,0,0]
[null,null,"14301/5",1,"H Martinus","2010-11-02","Martinusstraat 3 HOLTUM","001","Het orgel (Vermeulen Weert, 17 registers) ","Brand-stormverzekering"," ",644900,120,750,0.4637,299.04000000000002,179.42400000000001,null,null,"",null,null,644900,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,"002","De kostbare voorwerpen volgens de lijst d.d. 02-11-2010 van de heer P.A.A.C. Schalken ","Brand-inbraak-stormverzekering"," ",207000,120,750,0.90529999999999999,187.4,112.44,null,null,"",null,null,207000,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,"003","De inventaris aanwezig in het kerkgebouw en de kerkhofberging ","Brand-inbraak-stormverzekering"," ",357000,120,750,0.90529999999999999,323.19,193.91399999999999,null,null,"",null,null,357000,null,null,null,null,null,0,0]
[null,null,null,null,"Subtotaal H Martinus",null,null,null,null,null,null,null,null,null,null,809.63000000000011,485.77800000000002,null,null,"",null,null,0,null,null,null,null,null,0,0]
[423950," H. Willibrordus Obbicht ","14302/1",1," ","2012-11-06","St. Willibrorduslaan 4-8 OBBICHT","001","De kerk met vrijstaande klokkentoren  ","Brand-stormverzekering",0.10001678838243935,4765200,120,0,0.28839999999999999,1374.28,824.56799999999998,null,null,{"$f":"IFERROR(IF(K37>0,\"In verband met vork is het percentage \" &100*ROUND(K37,2)& \"% van het verzekerd belang. \",\"\"),\"\")","v":"In verband met vork is het percentage 10% van het verzekerd belang. "},null,null,{"$f":"L37","v":4765200},null,null,null,null,null,{"$f":"W37*AB37/1000","v":0},{"$f":"AC37*(1-restitutiepercentage)","v":0}]
[null,null,null,null,null,null,null,"002","De kerkhofberging, gelegen aan de Hitsbergerweg 5 te Obbicht ","Brand-stormverzekering"," ",24200,120,0,0.52,12.58,7.548,null,null,{"$f":"IFERROR(IF(K38>0,\"In verband met vork is het percentage \" &100*ROUND(K38,2)& \"% van het verzekerd belang. \",\"\"),\"\")","v":""},null,null,{"$f":"L38","v":24200},null,null,null,null,null,{"$f":"W38*AB38/1000","v":0},{"$f":"AC38*(1-restitutiepercentage)","v":0}]
[null,null,null,null,null,null,null,"003","De bouwkundige terreinafscheiding van het kerkhof ","Brand-stormverzekering"," ",49900,120,0,0.52,25.95,15.569999999999999,null,null,"",null,null,49900,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,"004","De opruimingskosten ","Brand-stormverzekering"," ",149000,120,0,0.64,95.36,57.216000000000001,null,null,"",null,null,149000,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,"005","Het orgel ","Brand-stormverzekering"," ",177900,120,0,0.504,89.66,53.795999999999999,null,null,"",null,null,177900,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,"006","De kostbare voorwerpen volgens de lijst d.d. 06-11-2012 van de  heer P.A.A.C. Schalken ","Brand-inbraak-stormverzekering"," ",148300,120,0,0.98399999999999999,145.93,87.558000000000007,null,null,"",null,null,148300,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,"007","De overige inventaris aanwezig in het kerkgebouw ","Brand-inbraak-stormverzekering"," ",296600,120,0,0.98399999999999999,291.85000000000002,175.11,null,null,"",null,null,296600,null,null,null,null,null,0,0]
[null,null,null,null,"Subtotaal  ",null,null,null,null,null,null,null,null,null,null,2035.6100000000001,1221.366,null,null,"",null,null,0,null,null,null,null,null,0,0]
[424000," H. Catharina Grevenbicht ","14303/1",1,"H. Catharina","2013-09-05","Aan de Greune Paol 30 GREVENBICHT","001","De kerk exclusief de kerkhofmuur en kerkhofberging ","Uitgebreide opstalverzekering",0.49999576482944968,11805900,120,750,0.42720000000000002,5043.4799999999996,3026.0879999999997,null,null,"In verband met vork is het percentage 50% van het verzekerd belang. ",null,null,11805900,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,"Glasverzekering",0.49999576482944968,11805900,120,750,5.3400000000000003E-2,630.44000000000005,378.26400000000001,null,null,"In verband met vork is het percentage 50% van het verzekerd belang. ",null,null,11805900,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,"003","Het orgel ","Brand-stormverzekering"," ",313000,120,750,0.4637,145.13999999999999,87.083999999999989,null,null,"",null,null,313000,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,"004","De kostbare voorwerpen volgens de lijst d.d. 05-09-2013 van  de heer P.A.A.C. Schalken ","Brand-inbraak-stormverzekering"," ",519300,120,750,0.90529999999999999,470.12,282.072,null,null,"",null,null,519300,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,"005","De overige inventaris aanwezig in het kerkgebouw ","Brand-inbraak-stormverzekering"," ",446600,120,750,0.90529999999999999,404.31,242.58599999999998,null,null,"",null,null,446600,null,null,null,null,null,0,0]
[null,null,null,null,"Subtotaal H. Catharina",null,null,null,null,null,null,null,null,null,null,6693.4900000000007,4016.0940000000001,null,null,"",null,null,0,null,null,null,null,null,0,0]
[null,null,null,2," ","2013-09-05","Oude Kerkstraat Ong. GREVENBICHT","001","De kerkhofkapel met berging ","Brand-stormverzekering"," ",41800,120,750,0.47839999999999999,20,12,null,null,"",null,null,41800,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,"002","De opruimingskosten ","Brand-stormverzekering"," ",6200,120,750,0.58879999999999999,3.65,2.19,null,null,"",null,null,6200,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,"003","De inventaris aanwezig in de kerkhofkapel ","Brand-inbraak-stormverzekering"," ",6200,120,750,0.90529999999999999,5.61,3.3660000000000001,null,null,"",null,null,6200,null,null,null,null,null,0,0]
[null,null,null,null,"Subtotaal  ",null,null,null,null,null,null,null,null,null,null,29.259999999999998,17.555999999999997,null,null,"",null,null,0,null,null,null,null,null,0,0]
[null,null,null,3," ","2013-09-05","Achter de Kruiskapel Ong. GREVENBICHT","001","De kruiskapel ","Brand-stormverzekering"," ",23800,120,750,0.47839999999999999,11.39,6.8340000000000005,null,null,"",null,null,23800,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,"002","De opruimingskosten ","Brand-stormverzekering"," ",3500,120,750,0.58879999999999999,2.06,1.236,null,null,"",null,null,3500,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,"003","De inventaris aanwezig in de kruiskapel ","Brand-inbraak-stormverzekering"," ",4100,120,750,0.90529999999999999,3.71,2.226,null,null,"",null,null,4100,null,null,null,null,null,0,0]
[null,null,null,null,"Subtotaal  ",null,null,null,null,null,null,null,null,null,null,17.16,10.295999999999999,null,null,"",null,null,0,null,null,null,null,null,0,0]
[null,null,"14303/2",1," ","2013-09-05","Sint Catharinaplantsoen 8 GREVENBICHT","001","De pastorie met parochiezaal ","Woonhuisverzekering"," ",416800,120,750,0.74760000000000004,311.60000000000002,186.96,null,null,"",null,null,416800,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,"002","De inventaris aanwezig in de parochiezaal ","Brand-inbraak-stormverzekering"," ",5200,120,750,0.90529999999999999,4.71,2.8260000000000001,null,null,"",null,null,5200,null,null,null,null,null,0,0]
[null,null,null,null,"Subtotaal  ",null,null,null,null,null,null,null,null,null,null,316.31,189.786,null,null,"",null,null,0,null,null,null,null,null,0,0]
["Eindtotaal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,28772.240000000002,17263.34,null,null,"",null,null,0,null,null,null,null,null,0,0]

{"sheet":"offerte","index":1,"n_rows":90,"n_cols":60,"rows_kept":90,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Brandverzekering"]
[null,null,null,null,null,null,null,null,null,"Brand-stormverzekering"]
[null,null,null,null,null,null,null,null,null,"Brand-inbraakverzekering"]
[null,null,null,null,null,null,null,null,null,"Brand-inbraak-stormverzekering"]
[null,null,null,null,null,null,null,null,null,"Uitgebreide opstalverzekering"]
[null,null,null,null,null,null,null,null,null,"Uitgebreide inventarisverz. "]
[null,null,null,null,null,null,null,null,null,"Woonhuisverzekering"]
["validatie tr leden","validatie contractduur","validatie eigen risico","korting er 1","korting er 1","korting er 1",null,null,null,"Woonhuis Excellent"]
["Ja, trouwe ledenkorting",12,0,0,0,0,null,null,null,"Glasverzekering"]
["Nee, geen trouwe ledenkorting",36,750,0.08,0.11,0.14000000000000001,null,null,null,"Vandalismeverzekering"]
[null,60,1500,0.1,0.14000000000000001,0.18,null,null,null,"Verz. aanstraalverlichting"]
[null,120,2500,0.12,0.17,0.22,null,null,null,"Uitgebreide Inventaris + Excellent"]
[null,null,5000,0.16,0.22,0.3,null,null,null,"Kostbaarheden"]
[null,null,12500,0.22,0.3,0.4,null,null,null,"Inbraak Premier Risque"]
[null,null,25000,0.3,0.4,0.5,null,null,null,"Storm Premier Risque"]
[null,null,null,null,null,null,null,null,null,"Exploitatiekosten "]
[null,null,null,null,null,null,null,null,null,"Bedrijfssschade "]
[null,null,null,"x",null,null,null,null,null,"Verzekering Leegstaande (Kerk)gebouwen"]
[null,null,null,"x",null,null,null,null,null,"Grafmonumenten"]
[null,null,null,"as",null,null,null,null,null,"Grafmonumenten Vandalisme"]
[null,null,null,"df",null,null,null,null,null,"Brand/Storm + inbraak + blote diefstal"]
[null,null,null,"asdf",null,null,null,null,null,"Brand + inbraak  + blote diefstal"]
[null,null,null,"sadf",null,null,null,null,null,"Extra geld"]
[null,null,null,"as",null,null,null,null,null,"Uitgebreide Inventaris + blote diefstal"]
[null,null,null,"df",null,null,null,null,null,"Fraude en beroving"]
[null,null,null,"sadf",null,null,null,null,null,"Inboedel "]
[null,null,null,"asdf",null,null,null,null,null,"Inboedel  + excellent "]
[null,null,null,"sadf",null,null,null,null,null,"Huurderving"]
[]
[]
[]
[null,null,null,null,74219.563599999994,42305.151252000003,null,null,null,null,null,null,null,74219.563599999994,42305.151252000003,null,null,null,null,null,null,null,74219.563599999994,42305.151252000003,null,null,null,null,null,null,null,74219.563599999994,42305.151252000003,null,null,null,null,null,null,null,74219.563599999994,42305.151252000003,null,null,null,null,null,null,null,74219.563599999994,42305.151252000003,null,null,null,null,null,null,null,10390.738904,-21523.673444]
[null,null,null,null,74219.563599999994,42305.151252000003,null,null,null,null,null,null,null,74219.563599999994,42305.151252000003,null,null,null,null,null,null,null,74219.563599999994,42305.151252000003,null,null,null,null,null,null,null,74219.563599999994,42305.151252000003,null,null,null,null,null,null,null,74219.563599999994,42305.151252000003,null,null,null,null,null,null,null,74219.563599999994,42305.151252000003,null,null,null,null,null,null,null,10390.738904,-21523.673444]
[]
[]
[null,"VZC","Offerteblok","Zoekterm","Dekking","Basispromillage één jaar","type dekking om korting mee te bepalen\na: laag\nb: midden\nc: hoog\nz: nvt/onbekend"]
["Opstal (kerk)",1,"BR01","1BR01","Brand-storm",0.65,"a"]
["Opstal (WH)",2,"BR01","2BR01","Brand-storm",0.6,"a"]
["Opstal (overig)",3,"BR01","3BR01","Brand-storm",0.6,"a"]
["Inventaris",4,"BR01","4BR01","Brand-storm",0.63,"a"]
["Kosten",5,"BR01","5BR01","Opruimingskosten",0.8,"a"]
["Onbekend",6,"BR01","6BR01","ONBEKEND",99.99,"z"]
["Opstal (kerk)",1,"BR02","1BR02","Brand-storm-glas-vandalisme",0.8,"b"]
["Opstal (WH)",2,"BR02","2BR02","Brand-storm-glas-vandalisme",0.8,"b"]
["Opstal (overig)",3,"BR02","3BR02","Brand-storm-glas-vandalisme",0.8,"b"]
["Inventaris",4,"BR02","4BR02","Brand-Storm-Inbraak",1.23,"a"]
["Kosten",5,"BR02","5BR02","Opruimingskosten",0.8,"a"]
["Onbekend",6,"BR02","6BR02","ONBEKEND",99.99,"z"]
["Opstal (kerk)",1,"BR03","1BR03","Uitgebreide Opstal",0.8,"b"]
["Opstal (WH)",2,"BR03","2BR03","Woonhuis",1.05,"b"]
["Opstal (overig)",3,"BR03","3BR03","Uitgebreide Opstal",0.75,"b"]
["Inventaris",4,"BR03","4BR03","Uitgebreide Inventarisverz.",1.5,"b"]
["Kosten",5,"BR03","5BR03","nvt",0,"z"]
["Onbekend",6,"BR03","6BR03","ONBEKEND",99.99,"z"]
["Opstal (kerk)",1,"BR04","1BR04","Uitgebreide Opstal/Glas/Vandalisme",1,"c"]
["Opstal (WH)",2,"BR04","2BR04","Woonhuis",1.05,"b"]
["Opstal (overig)",3,"BR04","3BR04","Uitgebreide Opstal/Glas/Vandalisme",0.95,"c"]
["Inventaris",4,"BR04","4BR04","Uitgebreide Inventarisverz.",1.5,"b"]
["Kosten",5,"BR04","5BR04","nvt",0,"z"]
["Onbekend",6,"BR04","6BR04","ONBEKEND",99.99,"z"]
["Opstal (kerk)",1,"CRSC","1CRSC","Monumentenverzekering Comfort",0.8,"a"]
["Opstal (WH)",2,"CRSC","2CRSC","Monumentenverzekering Comfort",0.8,"a"]
["Opstal (overig)",3,"CRSC","3CRSC","Monumentenverzekering Comfort",0.8,"a"]
["Inventaris",4,"CRSC","4CRSC","Uitgebreide Inventarisverz.",2.5,"b"]
["Kosten",5,"CRSC","5CRSC","nvt",0,"z"]
["Onbekend",6,"CRSC","6CRSC","ONBEKEND",99.99,"z"]
["Opstal (kerk)",1,"CRSR","1CRSR","Monumentenverzekering Royaal",1.1599999999999999,"b"]
["Opstal (WH)",2,"CRSR","2CRSR","Monumentenverzekering Royaal",1.1599999999999999,"b"]
["Opstal (overig)",3,"CRSR","3CRSR","Monumentenverzekering Royaal",1.1599999999999999,"b"]
["Inventaris",4,"CRSR","4CRSR","Uitgebreide Inventarisverz.",2.5,"b"]
["Kosten",5,"CRSR","5CRSR","nvt",0,"z"]
["Onbekend",6,"CRSR","6CRSR","ONBEKEND",99.99,"z"]
["Opstal (kerk)",1,"CRSS","1CRSS","Monumentenverzekering Subliem",1.6,"c"]
["Opstal (WH)",2,"CRSS","2CRSS","Monumentenverzekering Subliem",1.6,"c"]
["Opstal (overig)",3,"CRSS","3CRSS","Monumentenverzekering Subliem",1.6,"c"]
["Inventaris",4,"CRSS","4CRSS","Uitgebreide Inventarisverz.",2.5,"b"]
["Kosten",5,"CRSS","5CRSS","nvt",0,"z"]
["Onbekend",6,"CRSS","6CRSS","ONBEKEND",99.99,"z"]
[null,null,null,"BR01","ONBEKEND",99.99,"z"]
[null,null,null,"BR02","ONBEKEND",99.99,"z"]
["lege records, later ingevoegd door gebruiker",null,null,"BR03","ONBEKEND",99.99,"z"]
[null,null,null,"BR04","ONBEKEND",99.99,"z"]
[null,null,null,"CRSC","ONBEKEND",99.99,"z"]
[null,null,null,"CRSR","ONBEKEND",99.99,"z"]
[null,null,null,"CRSS","ONBEKEND",99.99,"z"]

{"sheet":"Polissen","index":2,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Polisoverzicht  Parochiefederatie Born ",null,null,null,null,null,null,null,null,"Datum gegevens:","2021-03-15"]
[null,null,null,null,null,null,null,null,null,null,"2021-03-15"]
["Relatie-nummer","Naam relatie","Polis-nummer","Risicodrager","Product ","Contracts-vervaldatum","Premie-termijn (maanden)","Verzekerd bedrag"," Bruto premie"," Instap-korting","Leden-restitutie","Bruto jaarpremie met aftrek van korting en restitutie"]
[423400," H. Martinus Born ","14298/1","Donatus Verzekeringen Brand","Uitgebreide gevarenverzekering","2026-01-01",12,11158700,9267.75,0,3432.4,5835.3500000000013]
[423400," H. Martinus Born ","14298/4","Donatus Verzekeringen Brand","Uitgebreide gevarenverzekering","2026-01-01",12,950800,719.82,0,267.44400000000002,452.37600000000003]
[423400," H. Martinus Born ","29663855","Nationale Nederlanden Zorgverz","Ziekteverzuim","2022-01-01",12,0,323.25,0,0,323.25]
[423400," H. Martinus Born ","6388921","Delta Lloyd Schadeverzekering","CAR-verzekering","2017-11-01",12,655000,0,0,0,0]
[423800," H. Catharina Buchten ","14299/1","Donatus Verzekeringen Brand","Brand-stormverzekering","2024-01-01",12,2937500,3737,0,1374.98,2362.02]
[423800," H. Catharina Buchten ","14299/3","Donatus Verzekeringen Brand","Brand-inbraak-stormverzekering","2024-01-01",12,938500,690.73,0,276.29200000000003,414.43799999999993]
[423800," H. Catharina Buchten ","14299/5","Donatus Verzekeringen Brand","Brand-stormverzekering","2026-01-01",12,326000,273.83999999999997,0,101.404,172.43600000000001]
[423900," H. Martinus Holtum ","14301/1","Donatus Verzekeringen Brand","Uitgebreide opstalverzekering","2024-01-01",12,4609500,4181.6400000000003,0,1538.5640000000001,2643.076]
[423900," H. Martinus Holtum ","14301/5","Donatus Verzekeringen Brand","Brand-inbraak-stormverzekering","2024-01-01",12,1208900,809.63,0,314.26400000000001,495.36599999999999]
[423900," H. Martinus Holtum ","95524410","Nationale Nederlanden (ZO)","Milieuschadeverzekering","2022-01-01",12,500000,125,0,0,125]
[423950," H. Willibrordus Obbicht ","14302/1","Donatus Verzekeringen Brand","Brand-inbraak-stormverzekering","2025-01-01",12,1322500,2035.61,0,766.55200000000013,1269.0579999999998]
[424000," H. Catharina Grevenbicht ","14303/1","Donatus Verzekeringen Brand","Brand-inbraak-stormverzekering","2024-01-01",12,7267400,6739.91,0,2508.2640000000001,4231.6459999999997]
[424000," H. Catharina Grevenbicht ","14303/2","Donatus Verzekeringen Brand","Uitgebreide gevarenverzekering","2024-01-01",12,422000,316.31,0,117.28399999999999,199.02599999999998]
[424000," H. Catharina Grevenbicht ","14720999","Nationale Nederlanden Zorgverz","WGA Hiaatverz. Aanv. Uitg. Ink","2022-01-01",12,5138,40.590000000000003,0,0,40.590000000000003]
[424000," H. Catharina Grevenbicht ","29670620","Nationale Nederlanden Zorgverz","Ziekteverzuim","2022-01-01",3,0,38.409999999999997,0,0,153.63999999999999]

{"sheet":"Schades","index":3,"n_rows":31,"n_cols":10,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Schadeoverzicht  Parochiefederatie Born "]
["Schades die de afgelopen tien jaar plaats vonden, zijn weergegeven mits bekend en geregistreerd bij Donatus. "]
[]
["Relatie-nummer","Naam relatie","Maatschappij","Polis-\nnummer","Locatie","Schade-nummer","Schade-\ndatum","Schade-oorzaak","Status dossier","Uitkering"]
[423400," H. Martinus Born ","Donatus Verzekeringen Brand","14298/1","Kerkstraat Ong. BORN","20183736","2018-07-30","brand","Gesloten",12165.641]
[null,null,null,null,"Totaal Kerkstraat Ong. BORN",null,null,null,null,12165.641]
[null,null,null,"Totaal 14298/1",null,null,null,null,null,12165.641]
[null,null,null,"14298/4","Bronstraat2A BORN","20122163","2012-05-01","glas","Gesloten",204.821]
[null,null,null,null,null,"20193485-o en i","2019-12-24","inbraak","Gesloten",1093.8009999999999]
[null,null,null,null,"Totaal Bronstraat2A BORN",null,null,null,null,1298.6219999999998]
[null,null,null,"Totaal 14298/4",null,null,null,null,null,1298.6219999999998]
[423800," H. Catharina Buchten ","Donatus Verzekeringen Brand","14299/1","Kerkvonderen 7 BUCHTEN","20153069","2015-07-28","vandalisme","Gesloten",0]
[null,null,null,null,"Totaal Kerkvonderen 7 BUCHTEN",null,null,null,null,0]
[null,null,null,"Totaal 14299/1",null,null,null,null,null,0]
[null,null,null,"14299/3","Kerkvonderen 7 BUCHTEN","20134109","2013-10-28","braak","Gesloten",202.541]
[null,null,null,null,"Totaal Kerkvonderen 7 BUCHTEN",null,null,null,null,202.541]
[null,null,null,"Totaal 14299/3",null,null,null,null,null,202.541]
[423950," H. Willibrordus Obbicht ","Donatus Verzekeringen Brand","14302/1","St. Willibrorduslaan 4-8 OBBICHT","20114685","2011-12-30","water","Gesloten",0]
[null,null,null,null,null,"20135102","2013-12-24","glas","Gesloten",325.49099999999999]
[null,null,null,null,null,"20182483","2018-02-26","aanrijding","Gesloten",0]
[null,null,null,null,"Totaal St. Willibrorduslaan 4-8 OBBICHT",null,null,null,null,325.49099999999999]
[null,null,null,"Totaal 14302/1",null,null,null,null,null,325.49099999999999]
[424000," H. Catharina Grevenbicht ","Donatus Verzekeringen Brand","14303/1","Aan de Greune Paol 30 GREVENBICHT","20142758","2014-07-10","inductie","Gesloten",296.45100000000002]
[null,null,null,null,"Totaal Aan de Greune Paol 30 GREVENBICHT",null,null,null,null,296.45100000000002]
[null,null,null,"Totaal 14303/1",null,null,null,null,null,296.45100000000002]
[null,null,null,"14303/2","Sint Catharinaplantsoen 8 GREVENBICHT","20122584","2012-02-07","glas","Gesloten",276.851]
[null,null,null,null,null,"20142509","2014-06-17","glas","Gesloten",677.601]
[null,null,null,null,null,"20154412","2015-11-20","zaak","Gesloten",0]
[null,null,null,null,"Totaal Sint Catharinaplantsoen 8 GREVENBICHT",null,null,null,null,954.452]
[null,null,null,"Totaal 14303/2",null,null,null,null,null,954.452]
["Eindtotaal",null,null,null,null,null,null,null,null,15243]