{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Tarif","Calcul","STAEM","Feuil1","Calcul (2)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":1,"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":"Tarif","index":0,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[[30,4,30,5],[31,4,31,5],[23,4,25,5],[23,6,25,7],[2,4,2,9],[7,2,7,5],[21,6,22,7],[15,1,15,4],[16,1,16,3],[21,4,22,4],[21,5,22,5]]}
[]
[]
[null,null,null,null,"Tarif assurance individuelle accidents"]
[]
[]
[null,"Tarif de base"]
[]
[null,null,"Garanties"]
[null,"Classe","Décès","I.P.P","I.T.T* (DA)","Frais médicaux** (DA)"]
[null,1,{"$f":"1.4/1000","v":1.4E-3},{"$f":"1.5/1000","v":1.5E-3},4,45,null,null,null,45,1500]
[null,2,{"$f":"1.65/1000","v":1.65E-3},{"$f":"1.75/1000","v":1.75E-3},6,65,null,null,null,120,{"$f":"(J11*K10)/J10","v":4000}]
[null,3,{"$f":"2.25/1000","v":2.2499999999999998E-3},{"$f":"2.5/1000","v":2.5000000000000001E-3},9,90]
[null,4,{"$f":"2.7/1000","v":2.7000000000000001E-3},{"$f":"2.85/1000","v":2.8500000000000001E-3},12,120]
[null,5,{"$f":"3.5/1000","v":3.5000000000000001E-3},{"$f":"3.75/1000","v":3.7499999999999999E-3},15,150]
[]
[null,"* par dinar garanti à compter du 8ème jour."]
[null,"** jusqu'à concurrence de 1500 DA."]
[]
[]
[null,"Surprimes"]
[]
[null,null,"Décès","I.P.P","I.T.T","Frais médicaux","Observation"]
[null,null,"‰ du capital","% de la prime"]
["(a)","Sport",{"$f":"0.6/1000","v":5.9999999999999995E-4},0.6,"Néant",null,"Les surprimes (a) et © ne se cumulent pas. En cas de cumul prendre la surprime © seulement."]
["(b)","Aviation",{"$f":"0.5/1000","v":5.0000000000000001E-4},0]
["©","Moto > 50 cm³",{"$f":"0.75/1000","v":7.5000000000000002E-4},0.75]
[]
[]
[null,"Si l'âge de l'assuré varie au jour de la souscription :"]
[]
[null,"Entre 50 et 55 ans","majoration de ",0.2,"de la prime nette"]
[null,"Entre 55 et 60 ans","majoration de",0.4,"de la prime nette"]

{"sheet":"Calcul","index":1,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,1,1,5],[16,5,17,5],[2,2,2,5],[7,2,7,4],[20,1,20,3],[24,1,24,3],[18,1,18,4],[16,4,17,4],[4,1,7,1],[8,1,11,1],[12,1,15,1],[16,1,17,1]]}
[]
[null,"STAEM"]
[null,"Classe :","Tarification  individuelle accidents"]
[null,1,null,"Capital assuré","Taux","Prime"]
[null,"Garanties de Base","Décès",2000000,{"$f":"IF(B4=Tarif!B10,Tarif!C10,IF(B4=Tarif!B11,Tarif!C11,IF(B4=Tarif!B12,Tarif!C12,IF(B4=Tarif!B13,Tarif!C13,Tarif!C14))))","v":1.4E-3},{"$f":"E5*D5","v":2800}]
[null,null,"IPP",1000000,{"$f":"IF(B4=Tarif!B10,Tarif!D10,IF(B4=Tarif!B11,Tarif!D11,IF(B4=Tarif!B12,Tarif!D12,IF(B4=Tarif!B13,Tarif!D13,Tarif!D14))))","v":1.5E-3},{"$f":"E6*D5","v":3000}]
["OUI",null,"FMP",0,{"$f":"IF(B4=Tarif!B10,Tarif!F10,IF(B4=Tarif!B11,Tarif!F11,IF(B4=Tarif!B12,Tarif!F12,IF(B4=Tarif!B13,Tarif!F13,Tarif!F14))))","v":45},{"$f":"E7*D7/1500","v":0}]
["NON",null,"PRIME BASE :",null,null,{"$f":"SUM(F5:F7)","v":5800}]
[3,"Surprime Décès\n (/ capital)","Sport",null,{"$f":"IF(A9=2,Tarif!C24,0)","v":0},{"$f":"$D$5*E9","v":0}]
[3,null,"Aviation",null,{"$f":"IF(A10=2,Tarif!C25,0)","v":0},{"$f":"$D$5*E10","v":0}]
[3,null,"Moto > 50 cm³",null,{"$f":"IF(A11=2,Tarif!C26,0)","v":0},{"$f":"$D$5*E11","v":0}]
[null,null,"Prime annuelle :",null,null,{"$f":"SUM(F8:F11)","v":5800}]
[3,"Surprime IPP\n  (/ prime)","Sport",null,{"$f":"IF(A13=2,Tarif!D24,0)","v":0},{"$f":"$F$6*E13","v":0}]
[null,null,"Aviation"]
[3,null,"Moto > 50 cm³",null,{"$f":"IF(A15=2,Tarif!D26,0)","v":0},{"$f":"$F$6*E15","v":0}]
[null,null,"Prime annuelle :",null,null,{"$f":"SUM(F12:F15)","v":5800}]
[null,"Surprime Âge\n (/ prime)","Entre 50 et 55 ans",0.2,0,{"$f":"F16*E17","v":0}]
[null,null,"Entre 56 et 65 ans",0.4]
[null,"Prime Nette",null,null,null,{"$f":"F16+F17","v":5800}]
[]
[null,"PRIME NETTE PAR GARANTIE",null,null,"PRIME ANNUELLE","PRIME TEMPORAIRE"]
[null,"Durée d'assurance","annuelle","DC",{"$f":"(F5+F9+F10+F11)*(1+$E$17)","v":2800},{"$f":"E22*$C$23","v":2800}]
[null,"% de prime :",1,"IPP",{"$f":"(F6+F13+F15)*(1+$E$17)","v":3000},{"$f":"E23*$C$23","v":3000}]
[null,null,null,"FMP",{"$f":"F7*(1+$E$17)","v":0},0]
[null,"PRIME NETTE",null,null,{"$f":"SUM(E22:E24)","v":5800},{"$f":"SUM(F22:F24)","v":5800}]

{"sheet":"STAEM","index":2,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null," Offre Assurance Individuelle Accidents",null,null,"STAEM"]
[]
[null,"Tableau des conditions de couverture et  tarifaires"]
[]
[null,"Contractante :  ","Société de Tabac Algéro-Emaratie "]
[null,"Activité :  ","Production"]
[null,"Effectif assuré :",900]
[null,"Age limite ","65 ans"]
[null,"Durée ","Annuelle"]
[]
[null,"Garanties","Capitaux garantis"]
[null,"Décès Accidentel: ",1000000]
[null,"IPP / IPT",1000000]
[null,"FMP ",0]
[null,"Prime nette annuelle",4750]

{"sheet":"Feuil1","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Calcul (2)","index":4,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,5],[2,2,2,5],[4,1,7,1],[7,2,7,4]]}
[]
[null,"STAEM"]
[null,"Classe :","Tarification  individuelle accidents"]
[null,1,null,"Capital assuré","Taux","Prime"]
[null,"Garanties de Base","Décès",2000000,{"$f":"IF(B4=Tarif!B10,Tarif!C10,IF(B4=Tarif!B11,Tarif!C11,IF(B4=Tarif!B12,Tarif!C12,IF(B4=Tarif!B13,Tarif!C13,Tarif!C14))))","v":1.4E-3},{"$f":"E5*D5","v":2800}]
[null,null,"IPP",1000000,{"$f":"IF(B4=Tarif!B10,Tarif!D10,IF(B4=Tarif!B11,Tarif!D11,IF(B4=Tarif!B12,Tarif!D12,IF(B4=Tarif!B13,Tarif!D13,Tarif!D14))))","v":1.5E-3},{"$f":"E6*D5","v":3000}]
[null,null,"FMP",0,{"$f":"IF(B4=Tarif!B10,Tarif!F10,IF(B4=Tarif!B11,Tarif!F11,IF(B4=Tarif!B12,Tarif!F12,IF(B4=Tarif!B13,Tarif!F13,Tarif!F14))))","v":45},{"$f":"E7*D7/1500","v":0}]
[null,null,"PRIME BASE :",null,null,{"$f":"SUM(F5:F7)","v":5800}]