{"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":[[21,0,21,3],[5,2,5,7],[6,2,6,7],[7,2,7,7],[8,2,8,7],[6,0,6,1],[10,2,10,3],[14,3,14,7],[15,0,15,8],[14,0,14,2],[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]]}
[]
["Assurance Transport - Police no 23533.001",{"$nulls":5},"USS Police no:"]
[]
["Marchandise et valeurs",{"$nulls":5},"No de sociétés"]
[]
["Nom du preneur d'assurance"]
["Personne de contact"]
["Rue et numéro"]
["NPA et Lieu"]
[]
["Numéro de sociétés/club:"]
[]
["Durée de l'assurance",null,"du",null,"au"]
[]
["Lieu de risque / manifestation"]
["Sont considérés assurés les transports, manipulations et les séjours aux Fêtes de tir organisées à l'intérieur de la Suisse et de la Principauté de Liechtenstein."]
["Objets assurés:"]
[]
["Marchandise"]
["Tentes, conteneurs, mobilhome, mobilier d'exposition (stand, paravents, etc), drapeaux, matériel de restauration (tel que meubles, tables, chaises, bancs, vaiselle, couverts, cuisinières, frigos, machines à café, appareils ménagers divers ainsi que produits alimentaires et boissons);",{"$nulls":7},"CHF"]
["Matériel informatique, photocopieuses, appareils vidéo, projecteurs, ainsi que meubles et matériel de bureau;",{"$nulls":7},"CHF"]
["Lots de tout genre (tels que voitures, vélos, meubles, appareils de photo, radios, téléviseurs, appareils vidéo, sculptures sur bois, montres, objets en étain, coupes, armes, médailles, vitrines, vin, etc);",{"$nulls":7},"CHF"]
["Munition (seulement dans des bâtiments massifs)",{"$nulls":7},"CHF"]
["Total / Somme d'assurance marchandise:",{"$nulls":7},"CHF",{"$f":"SUM(J20:J23)","v":0}]
["Valoren (uniquement possible en complément à une assurance machandise)"]
["Argent liquide",{"$nulls":7},"CHF"]
["Lotterie",{"$nulls":7},"CHF"]
["Cartes couronne",{"$nulls":7},"CHF"]
["Distinctions",{"$nulls":7},"CHF"]
["Total / Somme d'assurance valeurs:",{"$nulls":7},"CHF",{"$f":"SUM(J26:J29)","v":0}]
["Prime"]
["Marchandise","CHF","Taux prime",null,"Somme d'assurance",null,null,null,"Prime"]
["Franchise","(choisir)",{"$f":"IF(B33=100,0.45%,IF(B33=200,0.43%,IF(B33=500,0.4%,IF(B33=2000,0.3%,\"\"))))","v":""},"pour 30 jours","CHF",{"$f":"IF(B33=\"(choisir)\",\"\",J24)","v":""},null,null,"CHF",{"$f":"IF(B33=\"(choisir)\",0,SUM(F33*C33))","v":0}]
[]
["Prolongation","(choisir)",{"$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=\"(choisir)\",\"\",J24)","v":""},null,null,"CHF",{"$f":"IF(C35=\"\",0,IF(B35=\"(choisir)\",0,SUM(F35*C35)))","v":0}]
[]
["Prolongation","(choisir)",{"$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=\"(choisir)\",\"\",J24)","v":""},null,null,"CHF",{"$f":"IF(C37=\"\",0,IF(B37=\"(choisir)\",0,SUM(F37*C37)))","v":0}]
[]
["Valeurs"]
["Franchise","(choisir)",{"$f":"IF(B40=100,0.075%,IF(B40=200,0.071%,IF(B40=500,0.065%,IF(B40=2000,0.05%,\"\"))))","v":""},"pour 30 jours","CHF",{"$f":"IF(B40=\"(choisir)\",\"\",J30)","v":""},null,null,"CHF",{"$f":"IF(B40=\"(choisir)\",0,SUM(F40*C40))","v":0}]
[]
["Prolongation","(choisir)",{"$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=\"(choisir)\",\"\",J30)","v":""},null,null,"CHF",{"$f":"IF(C42=\"\",0,IF(B42=\"(choisir)\",0,SUM(F42*C42)))","v":0}]
[]
["Prolongation","(choisir)",{"$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=\"(choisir)\",\"\",J30)","v":""},null,null,"CHF",{"$f":"IF(C44=\"\",0,IF(B44=\"(choisir)\",0,SUM(F44*C44)))","v":0}]
[{"$nulls":4},"Total intermédiaire",null,null,null,"CHF",{"$f":"SUM(J33:J44)","v":0}]
[{"$nulls":4},"Total intermédiaire arrondi",null,null,null,"CHF",{"$f":"ROUND(J45/10,2)*10","v":0}]
[{"$nulls":4},"Prime minimale",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% de timbre fédéral",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}]
["La prime minimale se monte à CHF 80.00 + timbre fédéral de 5%"]
[]
["Les conditions suivantes sont applicables:",null,null,"- Conditions de police (Police no 23533.001)\n- CGAT 2006 - 01.2006\n- CGAV 2006 - 04.2006"]
["Lieu, date",{"$nulls":4},"Signature"]

{"sheet":"Tabelle2","index":1,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["(choisir)","jusqu'à 15 jours","jusqu'à 30 jours","jusqu'à 45 jours","jusqu'à 60 jours","jusqu'à 70 jours","jusqu'à 90 jours"]
["(choisir)",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]