{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Tabelle1","Tabelle2"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"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"}

{"sheet":"Tabelle1","index":0,"n_rows":48,"n_cols":17,"rows_kept":48,"cut":false,"hidden":false,"merged":[[18,6,18,7],[32,0,33,0],[12,0,14,1],[20,0,23,1],[8,2,9,4],[30,1,32,2],[28,1,29,2],[17,6,17,7],[33,1,33,5]]}
[]
[]
[null,null,"Berufhaftpflichtversicherung für Immobilientreuhänder"]
[]
[]
["    Prämienberechnungsbasis:",null,"Immobilienmakler und Immobilienverwalter: Netto-Honorarumsatz pro Jahr"]
[null,null,"Bauträger: Netto-Errichtungskosten (Herstellungsaufwand ohne Grundstückskosten) pro Jahr"]
[]
[null,null,50000,null,null,null,null,null,null,false,null,null,null,null,null,null,5]
["    Gesamtjahresumsatz",null,null,null,null,null,null,null,null,false]
[]
["    Bauproduktionswert nur Bauträger",null,null,50000]
["Gewerbebefugnis"]
[null,null,null,null,null,null,null,null,null,1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,1,0,1.2,1,100000,3]
[null,null,null,null,null,null,null,null,null,1,1000,1,2,400000]
[null,"Versicherungssumme",null,null,"Selbstbehalt",null,null,null,null,null,3000,0.85,3,1000000]
[null,null,null,null,null,null,null,null,null,null,5000,0.8,4,2000000]
["Zusatzdeckung bei Bauträgerrisiko",null,null,null,null,null,null,null,null,null,20000,0.7,5,3000000]
[null,null,null,null,null,null,null,null,null,null,50000,0.55000000000000004,6]
[null,null,null,null,null,null,null,null,null,1]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100000]
["    Prämiensatz:",{"$f":"B28*1.11","v":8.4908339999999995},"‰ inkl. VSt.",null,null,null,null,null,null,null,null,null,null,null,null,null,400000]
["   ",{"$f":"(IF(J14=1,F42,C38))*100","v":7.6493999999999991},"‰ exkl. VSt.",null,null,null,null,null,null,null,null,null,null,null,null,null,1000000]
[null,{"$f":"IF(B46<B31,B31,B46)","v":424.54169999999993},null,null,null,null,null,null,null,null,null,null,null,null,null,null,2000000]
["    Vorausprämie:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3000000]
[null,{"$f":"C47+D48","v":424.54169999999993}]
["    Mindestprämie:"]
[]
[]
["Prämie Brutto",null,{"$f":"(C36*1.11)","v":7.4481000000000006E-2},{"$f":"ROUND(B27,4)","v":8.4908000000000001},"Zu und abschläge Mindestprämie",{"$f":"IF(J18=1,L17,IF(J18=2,L18,IF(J18=3,L19,IF(J18=4,L20,IF(J18=5,L21,IF(J18=6,L22))))))","v":1.2}]
["Prämie Netto",null,{"$f":"(IF(Tabelle1!C9<Tabelle2!B9,Tabelle2!C8,IF(Tabelle1!C9<Tabelle2!B10,Tabelle2!C9,IF(Tabelle1!C9<Tabelle2!B11,Tabelle2!C10,IF(Tabelle1!C9<Tabelle2!B12,Tabelle2!C11,IF(Tabelle1!C9<Tabelle2!B13,Tabelle2!C12,IF(Tabelle1!C9<Tabelle2!B14,Tabelle2!C13,IF(Tabelle1!C9<Tabelle2!B15,Tabelle2!C14,IF(Tabelle1!C9<Tabelle2!B16,Tabelle2!C15,IF(Tabelle1!C9<Tabelle2!B17,Tabelle2!C16,IF(Tabelle1!C9<Tabelle2!B18,Tabelle2!C17,IF(Tabelle1!C9<Tabelle2!B19,Tabelle2!C18,IF(Tabelle1!C9<Tabelle2!B20,Tabelle2!C19,IF(Tabelle1!C9<Tabelle2!B21,Tabelle2!C20,IF(Tabelle1!C9<Tabelle2!B22,Tabelle2!C21,IF(Tabelle1!C9<Tabelle2!B23,Tabelle2!C22,IF(Tabelle1!C9<999999999999999000000,Tabelle2!C23)))))))))))))))))/100","v":6.7099999999999993E-2}]
["Selbstbehalt -",null,{"$f":"IF(J18=1,C36*L17,IF(J18=2,C36*L18,IF(J18=3,C36*L19,IF(J18=4,C36*L20,IF(J18=5,C36*L21,IF(J18=6,C36*L22))))))","v":8.0519999999999994E-2}]
["Verssumme",null,{"$f":"IF(O17=1,C37*1,IF(O17=2,Tabelle1!C37*Tabelle2!J2,IF(O17=3,Tabelle1!C37*Tabelle2!O3,IF(O17=4,Tabelle1!C37*Tabelle2!U3,IF(O17=5,Tabelle1!C37*Tabelle2!AA3)))))","v":0.15298799999999999}]
["Berechnung Zu abschläge","Bt"]
[{"$f":"(D12/C9)/1","v":1},{"$f":"IF(J23=1,(C38/2),IF(J23=2,(C38/2)*1.4,(C38/2)*2))","v":7.6493999999999993E-2},{"$f":"A40*B40","v":7.6493999999999993E-2}]
[{"$f":"(A40-1)*(-1)","v":0},{"$f":"C38","v":0.15298799999999999},{"$f":"A41*B41","v":0}]
["BT Prämie",null,{"$f":"SUM(C40:C41)","v":7.6493999999999993E-2},null,{"$f":"C42","v":7.6493999999999993E-2},{"$f":"E42","v":7.6493999999999993E-2}]
["BauherrnHaftpflicht",{"$f":"C37*1.4","v":0.11272799999999998}]
["Gewährleistung und BauheernHp",{"$f":"C37*2","v":0.16103999999999999}]
["Abzüge Versicherungssumme"]
["Gesamtprämie",{"$f":"(C9*D35)/1000","v":424.54}]
["Mindestprämie Basis",{"$f":"(IF(O17=1,Tabelle2!C5,IF(O17=2,Tabelle2!I4,IF(O17=3,Tabelle2!N5,IF(O17=4,Tabelle2!T5,IF(O17=5,Tabelle2!Z5,))))))*F35","v":849.08339999999987},{"$f":"A41*B47","v":0}]
["Mindestpr Bauträger",{"$f":"(IF(J14=1,B47/2,B47))","v":424.54169999999993},{"$f":"A40*B48","v":424.54169999999993},{"$f":"IF(J23=1,C48,IF(J23=2,C48*1.4,IF(J23=3,C48*2)))","v":424.54169999999993}]

{"sheet":"Tabelle2","index":1,"n_rows":38,"n_cols":27,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[1,"Immobilientreuhänder",null,null,null,null,2," Immobilienmakler und Immobilienverwalter",null,"Zuschlag in %",null,3,"Hypothekarkreditvermittler",null,null,null,4,"Hypothekarkreditvermittler","Variante für Hypothekarkreditvermittler",null,null,null,5,"Hypothekarkreditvermittler","Variante für Hypothekarkreditvermittler"]
[null,"ausschließlich Immobilienmakler",null,null,null,null,null,"Versicherungssumme:",400000,1.38,null,null,"Immobilienmakler und Immobilienverwalter",null,"Zuschlag in %",null,null,"Immobilienmakler und Immobilienverwalter","Immobilienmakler und Immobilienverwalter",null,"Zuschlag in %",null,null,"Immobilienmakler und Immobilienverwalter","Immobilienmakler und Immobilienverwalter",null,"Zuschlag in %"]
[null,"Versicherungssumme:",100000,"BASIS",null,null,null,"Selbstbehalt:","1.000,00 fix je Schadenfall",null,null,null,"Versicherungssumme:",1000000,1.9,null,null,null,"Versicherungssumme:",2000000,2.4500000000000002,null,null,null,"Versicherungssumme:",3000000,2.9]
[null,"Selbstbehalt:","1.000,00 fix je Schadenfall","BASIS",null,null,null,"Mindestprämie inkl. VSt",513.91890000000001,null,null,null,"Selbstbehalt:","1.000,00 fix je Schadenfall",null,null,null,null,"Selbstbehalt:","1.000,00 fix je Schadenfall",null,null,null,null,"Selbstbehalt:","1.000,00 fix je Schadenfall"]
[null,"Mindestprämie inkl. VSt",372.40500000000009,null,null,null,null,"Umsatz/ Baupr.W. bis","Prämiensatz (netto) in %o","Prämiensatz (brutto) in %o",null,null,"Mindestprämie inkl. VSt",707.56949999999995,null,null,null,null,"Mindestprämie inkl. VSt",912.39225000000022,null,null,null,null,"Mindestprämie inkl. VSt",1079.9745000000003]
[null,"Falls Tarifänderung ist ausschließlich der Wert C13 zu ändern!!!",null,null,null,null,null,50000,9.2598000000000003,10.278378,null,null,"Umsatz/ Baupr.W. bis","Prämiensatz (netto) in %o","Prämiensatz (brutto) in %o",null,null,null,"Umsatz/ Baupr.W. bis","Prämiensatz (netto) in %o","Prämiensatz (brutto) in %o",null,null,null,"Umsatz/ Baupr.W. bis","Prämiensatz (netto) in %o","Prämiensatz (brutto) in %o"]
["Degression in %","Umsatz/ Baupr.W. bis","Prämiensatz (netto) in %o","Prämiensatz (brutto) in %o",null,null,null,100000,8.2523337599999991,9.1600904736000004,null,null,50000,12.748999999999999,14.151389999999999,null,null,null,50000,16.439500000000002,18.247845000000005,null,null,null,50000,19.459,21.599490000000003]
[null,50000,6.71,7.4481000000000011,null,null,null,200000,6.6855755999999991,7.4209889159999998,null,null,100000,11.361908799999998,12.611718767999999,null,null,-10.88,100000,14.650882400000002,16.262479464000005,null,null,-10.88,100000,17.341860799999999,19.249465488000002]
[-10.88,100000,5.9799519999999999,6.6377467200000009,null,null,null,300000,5.7410759999999987,6.372594359999999,null,null,200000,9.2047779999999992,10.217303579999999,null,null,-27.8,200000,11.869319000000001,13.174944090000002,null,null,-27.8,200000,14.049398,15.594831780000002]
[-27.8,200000,4.8446199999999999,5.3775282000000004,null,null,null,400000,5.0928899999999997,5.6531079000000002,null,null,300000,7.9043799999999989,8.7738617999999988,null,null,-38,300000,10.192490000000001,11.313663900000002,null,null,-38,300000,12.064579999999999,13.391683800000001]
[-38,300000,4.1601999999999997,4.6178220000000003,null,null,null,500000,4.6502715599999993,5.1618014315999998,null,null,400000,7.0119499999999997,7.7832645000000005,null,null,-45,400000,9.0417250000000013,10.036314750000003,null,null,-45,400000,10.702450000000001,11.879719500000002]
[-45,400000,3.6905000000000001,4.0964550000000006,null,null,null,750000,4.0706080799999995,4.5183749687999999,null,null,500000,6.4025477999999989,7.1068280579999996,null,null,-49.78,500000,8.2559169000000008,9.1640677590000017,null,null,-49.78,500000,9.7723097999999986,10.847263878]
[-49.78,500000,3.3697619999999997,3.7404358200000001,null,null,null,1000000,3.3946426799999987,3.7680533747999987,null,null,750000,5.6044603999999998,6.2209510440000004,null,null,-56.04,750000,7.226804200000001,8.0217526620000026,null,null,-56.04,750000,8.5541763999999993,9.4951358040000002]
[-56.04,750000,2.949716,3.2741847600000002,null,null,null,1250000,2.9946193199999995,3.3240274451999996,null,null,1000000,4.6737833999999987,5.1878995739999993,null,null,-63.34,1000000,6.0267206999999994,6.6896599769999998,null,null,-63.34,1000000,7.1336693999999987,7.9183730339999991]
[-63.34,1000000,2.4598859999999996,2.7304734599999998,null,null,null,1500000,2.8010894999999993,3.1092093449999996,null,null,1250000,4.1230266000000002,4.5765595260000005,null,null,-67.66,1250000,5.3165343000000007,5.901353073000001,null,null,-67.66,1250000,6.2930406000000003,6.9852750660000007]
[-67.66,1250000,2.1700140000000001,2.4087155400000002,null,null,null,2000000,2.6084856599999999,2.8954190826000001,null,null,1500000,3.8565724999999995,4.2807954749999997,null,null,-69.75,1500000,4.9729487500000005,5.5199731125000007,null,null,-69.75,1500000,5.8863474999999994,6.5338457249999999]
[-69.75,1500000,2.0297749999999999,2.2530502500000003,null,null,null,3000000,2.2908745199999991,2.5428707171999991,null,null,2000000,3.5913933000000005,3.9864465630000008,null,null,-71.83,2000000,4.6310071500000021,5.1404179365000031,null,null,-71.83,2000000,5.4816003000000011,6.084576333000002]
[-71.83,2000000,1.8902070000000004,2.0981297700000008,null,null,null,4000000,2.1112343999999994,2.3434701839999996,null,null,3000000,3.154102599999999,3.5010538859999993,null,null,-75.260000000000005,3000000,4.0671322999999999,4.5145168529999999,null,null,-75.260000000000005,3000000,4.8141565999999987,5.3437138259999992]
[-75.260000000000005,3000000,1.6600539999999997,1.8426599399999999,null,null,null,5000000,1.8075129599999991,2.0063393855999991,null,null,4000000,2.9067719999999997,3.2265169199999999,null,null,-77.2,4000000,3.7482060000000001,4.1605086600000005,null,null,-77.2,4000000,4.4366519999999996,4.92468372]
[-77.2,4000000,1.5298799999999999,1.6981668000000001,null,null,null,7500000,1.6010194200000003,1.7771315562000005,null,null,5000000,2.4886047999999987,2.7623513279999989,null,null,-80.48,5000000,3.2089903999999994,3.5619793439999996,null,null,-80.48,5000000,3.7983967999999986,4.2162204479999987]
[-80.48,5000000,1.3097919999999996,1.4538691199999998,null,null,null,10000000,1.3528567799999998,1.5016710257999999,null,null,7500000,2.2043021000000005,2.4467753310000009,null,null,-82.71,7500000,2.8423895500000014,3.155052400500002,null,null,-82.71,7500000,3.3644611000000011,3.7345518210000015]
[-82.71,7500000,1.1601590000000004,1.2877764900000006,null,null,null,null,null,null,null,null,10000000,1.8626288999999998,2.0675180790000001,null,null,-85.39,10000000,2.4018109500000007,2.6660101545000008,null,null,-85.39,10000000,2.8429598999999999,3.1556854890000001]
[-85.39,10000000,0.98033100000000006,1.0881674100000001]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(220000*N10)/1000","v":1738.9635999999998}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,false]