{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Anmeldung","Tabelle2"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Anmeldung","index":0,"n_rows":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":false,"merged":[[54,0,54,9],[51,3,51,9],[32,5,32,6],[43,5,43,6],[12,5,12,6],[34,5,34,6],[22,0,22,3],[30,0,30,4],[36,5,36,6],[39,5,39,6],[41,5,41,6],[31,8,31,9],[20,0,20,3],[12,0,12,1],[19,0,19,3],[16,0,16,4],[21,0,21,3],[5,2,5,7],[6,2,6,7],[7,2,7,7],[8,2,8,7],[6,0,6,1],[7,0,7,1],[8,0,8,1],[10,2,10,3],[14,3,14,7],[15,0,15,8],[14,0,14,2]]}
[]
["Transportversicherung - Police Nr. 23533.001",{"$nulls":5},"USS Policen Nr."]
[]
["Waren und Valoren",{"$nulls":5},"Vereins Nr."]
[]
["Name des Versicherten"]
["Ansprechperson"]
["Strasse / Hausnummer"]
["PLZ / Ortschaft"]
[]
["Gesellschaft/Vereins-Nummer:"]
[]
["Dauer der Versicherung",null,"von",null,"bis"]
[]
["Versicherungsort / Ort des Anlasses"]
["Als versichert gelten Transporte, Manipulationen und Aufenthalte an Schützenfesten innerhalb der Schweiz und des Fürstentums Liechtenstein."]
["Versicherte Gegenstände"]
[]
["Waren"]
["Zelten, Container, Wohnwagen, Ausstellungsmobiliar (Stände, Zwischenwände etc.), Fahnen, Material für das Restaurant (wie Möbel, Tische, Bestuhlung, Geschirr, Besteck, Kochherd, Kühlschrank, Kaffeemaschinen, diverse Küchengeräte, sowie Lebensmittel und Getränke);",{"$nulls":7},"CHF"]
["EDV-Anlagen, Kopierer, Videogeräte, Projektoren sowie Büromöbel und -material;",{"$nulls":7},"CHF"]
["Gabentempel aller Art (z.B. Auto, Velos, Möbel, Fotoapparate, Radio-, TV- und Videogeräte, Schnitzereien, Uhren, Zinnwaren, Pokale, Waffen, Medaillen, Vitrinen, Weine usw.);",{"$nulls":7},"CHF"]
["Munition (nur in massiven Gebäuden);",{"$nulls":7},"CHF"]
["Total / Versicherungssumme Waren:",{"$nulls":7},"CHF",{"$f":"SUM(J20:J23)","v":0}]
["Valoren (nur als Zusatzversicherung zu Waren-Verisicherung möglich)"]
["Bargeld",{"$nulls":7},"CHF"]
["Lotterielose",{"$nulls":7},"CHF"]
["Kranzkarten",{"$nulls":7},"CHF"]
["Kranzabzeichen",{"$nulls":7},"CHF"]
["Total / Versicherungssumme Valoren:",{"$nulls":7},"CHF",{"$f":"SUM(J26:J29)","v":0}]
["Prämie"]
["Waren","CHF","Prämiensatz",null,"Versicherungssumme",null,null,null,"Prämie"]
["Selbstbehalt","(bitte wählen)",{"$f":"IF(B33=100,0.45%,IF(B33=200,0.43%,IF(B33=500,0.4%,IF(B33=2000,0.3%,\"\"))))","v":""},"für 30 Tage","CHF",{"$f":"IF(B33=\"(bitte wählen)\",\"\",J24)","v":""},null,null,"CHF",{"$f":"IF(B33=\"(bitte wählen)\",0,SUM(F33*C33))","v":0}]
[]
["Verlängerung","(bitte wählen)",{"$f":"IF(AND(B33<>Tabelle2!A2,B35<>Tabelle2!A1),VLOOKUP(B33,Tabelle2!A3:G7,HLOOKUP(Anmeldung!B35,Tabelle2!B1:G7,2,FALSE),FALSE),\"\")","v":""},null,"CHF",{"$f":"IF(B35=\"(bitte wählen)\",\"\",J24)","v":""},null,null,"CHF",{"$f":"IF(C35=\"\",0,IF(B35=\"(bitte wählen)\",0,SUM(F35*C35)))","v":0}]
[]
["Verlängerung","(bitte wählen)",{"$f":"IF(AND(B33<>Tabelle2!A2,B37<>Tabelle2!A1),VLOOKUP(B33,Tabelle2!A3:G7,HLOOKUP(Anmeldung!B37,Tabelle2!B1:G7,2,FALSE),FALSE),\"\")","v":""},null,"CHF",{"$f":"IF(B37=\"(bitte wählen)\",\"\",J24)","v":""},null,null,"CHF",{"$f":"IF(C37=\"\",0,IF(B37=\"(bitte wählen)\",0,SUM(F37*C37)))","v":0}]
[]
["Valoren"]
["Selbstbehalt","(bitte wählen)",{"$f":"IF(B40=100,0.075%,IF(B40=200,0.071%,IF(B40=500,0.065%,IF(B40=2000,0.05%,\"\"))))","v":""},"für 30 Tage","CHF",{"$f":"IF(B40=\"(bitte wählen)\",\"\",J30)","v":""},null,null,"CHF",{"$f":"IF(B40=\"(bitte wählen)\",0,SUM(F40*C40))","v":0}]
[]
["Verlängerung","(bitte wählen)",{"$f":"IF(AND(B40<>Tabelle2!A2,B42<>Tabelle2!A1),VLOOKUP(B40,Tabelle2!A8:G11,HLOOKUP(B42,Tabelle2!B1:G11,2,FALSE),FALSE),\"\")","v":""},null,"CHF",{"$f":"IF(B42=\"(bitte wählen)\",\"\",J30)","v":""},null,null,"CHF",{"$f":"IF(C42=\"\",0,IF(B42=\"(bitte wählen)\",0,SUM(F42*C42)))","v":0}]
[]
["Verlängerung","(bitte wählen)",{"$f":"IF(AND(B40<>Tabelle2!A2,B44<>Tabelle2!A1),VLOOKUP(B40,Tabelle2!A8:G11,HLOOKUP(B44,Tabelle2!B1:G11,2,FALSE),FALSE),\"\")","v":""},null,"CHF",{"$f":"IF(B44=\"(bitte wählen)\",\"\",J30)","v":""},null,null,"CHF",{"$f":"IF(C44=\"\",0,IF(B44=\"(bitte wählen)\",0,SUM(F44*C44)))","v":0}]
[{"$nulls":4},"Zwischentotal",null,null,null,"CHF",{"$f":"SUM(J33:J44)","v":0}]
[{"$nulls":4},"Zwischentotal gerundet",null,null,null,"CHF",{"$f":"ROUND(J45/10,2)*10","v":0}]
[{"$nulls":4},"Minimalprämie",null,null,null,"CHF",{"$f":"IF(J45=0,0,IF(J45<=80,80,\"\"))","v":0}]
[null,null,null,{"$f":"IF(J47=\"\",SUM(J46*0.05),SUM(J47*0.05))","v":0},"5% Eidg. Stempelabgabe ",null,null,null,"CHF",{"$f":"ROUND(D48/10,2)*10","v":0}]
[{"$nulls":4},"Total",null,null,null,"CHF",{"$f":"IF(J47=\"\",SUM(J46+J48),SUM(J47+J48))","v":0}]
["Die Minimalprämie beträgt CHF 80.00 zuzüglich Eidg. Stempelabgaben"]
[]
["Es gelten folgende Bedingungen:",null,null,"- Policenbedingungen (Policen-Nr. 23533.001)\n- ABVT 2006 - 01.2006\n- ABVV 2006 - 04.2006"]
["Ort, Datum",{"$nulls":4},"Unterschrift"]

{"sheet":"Tabelle2","index":1,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["(bitte wählen)","bis 15 Tage","bis 30 Tage","bis 45 Tage","bis 60 Tage","bis 75 Tage","bis 90 Tage"]
["(bitte wählen)",2,3,4,5,6,7]
[100,1E-3,2E-3,3.0000000000000001E-3,4.0000000000000001E-3,5.0000000000000001E-3,6.0000000000000001E-3]
[200,8.9999999999999998E-4,1.8E-3,2.7000000000000001E-3,3.5999999999999999E-3,4.4999999999999997E-3,5.4000000000000003E-3]
[500,8.0000000000000004E-4,1.6000000000000001E-3,2.3999999999999998E-3,3.2000000000000002E-3,4.0000000000000001E-3,4.7999999999999996E-3]
[2000,5.0000000000000001E-4,1E-3,1.5E-3,2E-3,2.5000000000000001E-3,3.0000000000000001E-3]
[]
[100,2.0000000000000001E-4,4.0000000000000002E-4,8.0000000000000004E-4,1E-3,1.1999999999999999E-3,1.4E-3]
[200,1.9000000000000001E-4,3.8000000000000002E-4,5.6999999999999998E-4,7.6000000000000004E-4,9.5E-4,1.14E-3]
[500,1.8000000000000001E-4,3.6000000000000002E-4,5.4000000000000001E-4,7.2000000000000005E-4,8.9999999999999998E-4,1.08E-3]
[2000,1.2E-4,2.4000000000000001E-4,3.6000000000000002E-4,4.8000000000000001E-4,5.9999999999999995E-4,7.2000000000000005E-4]