{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Tarif","Calcul","STAEM","Feuil1","Calcul (2)"],"not_rendered":{"images":2,"macros":1,"defined_names":4,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Tarif","index":0,"n_rows":422,"n_cols":253,"rows_kept":422,"merged":[[397,248,397,251],[405,247,405,250],[406,247,406,249],[411,250,412,250],[411,251,412,251],[411,252,412,253],[413,250,415,251],[413,252,415,253],[420,250,420,251],[421,250,421,251]]}
[]
[null,null,"Tarif assurance individuelle accidents"]
{"$rows_empty":393}
[{"$nulls":247},"Tarif de base"]
[]
[{"$nulls":248},"Garanties"]
[{"$nulls":247},"Classe","Décès","I.P.P","I.T.T* (DA)","Frais médicaux** (DA)"]
[{"$nulls":247},1,{"$f":"1.4/1000","v":{"v":1.4E-3,"d":"0.140%"}},{"$f":"1.5/1000","v":{"v":1.5E-3,"d":"0.150%"}},4,45]
[{"$nulls":247},2,{"$f":"1.65/1000","v":{"v":1.65E-3,"d":"0.165%"}},{"$f":"1.75/1000","v":{"v":1.75E-3,"d":"0.175%"}},6,65]
[{"$nulls":247},3,{"$f":"2.25/1000","v":{"v":0.00225,"d":"0.225%"}},{"$f":"2.5/1000","v":{"v":0.0025,"d":"0.250%"}},9,90]
[{"$nulls":247},4,{"$f":"2.7/1000","v":{"v":0.0027,"d":"0.270%"}},{"$f":"2.85/1000","v":{"v":0.00285,"d":"0.285%"}},12,120]
[{"$nulls":247},5,{"$f":"3.5/1000","v":{"v":0.0035,"d":"0.350%"}},{"$f":"3.75/1000","v":{"v":0.00375,"d":"0.375%"}},15,150]
[]
[{"$nulls":247},"* par dinar garanti à compter du 8ème jour."]
[{"$nulls":247},"** jusqu'à concurrence de 1500 DA."]
[]
[]
[{"$nulls":247},"Surprimes"]
[]
[{"$nulls":248},"Décès","I.P.P","I.T.T","Frais médicaux","Observation"]
[{"$nulls":248},"‰ du capital","% de la prime"]
[{"$nulls":246},"(a)","Sport",{"$f":"0.6/1000","v":{"v":0.0006,"d":"0.0600%"}},{"v":0.6,"d":"60%"},"Néant",null,"Les surprimes (a) et © ne se cumulent pas. En cas de cumul prendre la surprime © seulement."]
[{"$nulls":246},"(b)","Aviation",{"$f":"0.5/1000","v":{"v":0.0005,"d":"0.0500%"}},{"v":0,"d":"0%"}]
[{"$nulls":246},"©","Moto > 50 cm³",{"$f":"0.75/1000","v":{"v":0.00075,"d":"0.0750%"}},{"v":0.75,"d":"75%"}]
[]
[]
[{"$nulls":247},"Si l'âge de l'assuré varie au jour de la souscription :"]
[]
[{"$nulls":247},"Entre 50 et 55 ans","majoration de ",{"v":0.2,"d":"20%"},"de la prime nette"]
[{"$nulls":247},"Entre 55 et 60 ans","majoration de",{"v":0.4,"d":"40%"},"de la prime nette"]

{"sheet":"Calcul","index":1,"n_rows":25,"n_cols":6,"rows_kept":25,"merged":[[1,1,1,5],[2,2,2,5],[4,1,7,1],[7,2,7,4],[8,1,11,1],[12,1,15,1],[16,1,17,1],[16,4,17,4],[16,5,17,5],[18,1,18,4],[20,1,20,3],[24,1,24,3]]}
[]
[null,"STAEM"]
[null,"Classe :","Tarification  individuelle accidents"]
[null,1,null,"Capital assuré","Taux","Prime"]
[null,"Garanties de Base","Décès",{"v":200000,"d":"200,000 "},{"$f":"IF(B4=Tarif!IN400,Tarif!IO400,IF(B4=Tarif!IN401,Tarif!IO401,IF(B4=Tarif!IN402,Tarif!IO402,IF(B4=Tarif!IN403,Tarif!IO403,Tarif!IO404))))","v":{"v":1.4E-3,"d":"0.140%"}},{"$f":"E5*D5","v":{"v":280,"d":"280 "}}]
[null,null,"IPP",{"v":10000,"d":"10,000 "},{"$f":"IF(B4=Tarif!IN400,Tarif!IP400,IF(B4=Tarif!IN401,Tarif!IP401,IF(B4=Tarif!IN402,Tarif!IP402,IF(B4=Tarif!IN403,Tarif!IP403,Tarif!IP404))))","v":{"v":1.5E-3,"d":"0.150%"}},{"$f":"E6*D5","v":{"v":300,"d":"300 "}}]
["OUI",null,"FMP",{"v":100000,"d":"100,000 "},{"$f":"IF(B4=Tarif!IN400,Tarif!IR400,IF(B4=Tarif!IN401,Tarif!IR401,IF(B4=Tarif!IN402,Tarif!IR402,IF(B4=Tarif!IN403,Tarif!IR403,Tarif!IR404))))","v":45},{"$f":"E7*D7/1500","v":{"v":3000,"d":"3,000 "}}]
["NON",null,"PRIME BASE :",null,null,{"$f":"SUM(F5:F7)","v":{"v":3580,"d":"3,580.00 "}}]
[3,"Surprime Décès\n (/ capital)","Sport",null,{"$f":"IF(A9=2,Tarif!IO414,0)","v":{"v":0,"d":"0.000%"}},{"$f":"$D$5*E9","v":0}]
[3,null,"Aviation",null,{"$f":"IF(A10=2,Tarif!IO415,0)","v":{"v":0,"d":"0.000%"}},{"$f":"$D$5*E10","v":0}]
[3,null,"Moto > 50 cm³",null,{"$f":"IF(A11=2,Tarif!IO416,0)","v":{"v":0,"d":"0.000%"}},{"$f":"$D$5*E11","v":0}]
[null,null,"Prime annuelle :",null,null,{"$f":"SUM(F8:F11)","v":{"v":3580,"d":"3,580.00 "}}]
[3,"Surprime IPP\n  (/ prime)","Sport",null,{"$f":"IF(A13=2,Tarif!IP414,0)","v":{"v":0,"d":"0%"}},{"$f":"$F$6*E13","v":0}]
[null,null,"Aviation"]
[3,null,"Moto > 50 cm³",null,{"$f":"IF(A15=2,Tarif!IP416,0)","v":{"v":0,"d":"0%"}},{"$f":"$F$6*E15","v":0}]
[null,null,"Prime annuelle :",null,null,{"$f":"SUM(F12:F15)","v":{"v":3580,"d":"3,580.00 "}}]
[null,"Surprime Âge\n (/ prime)","Entre 50 et 55 ans",{"v":0.2,"d":"20%"},{"v":0,"d":"0%"},{"$f":"F16*E17","v":0}]
[null,null,"Entre 56 et 65 ans",{"v":0.4,"d":"40%"}]
[null,"Prime Nette",{"$nulls":3},{"$f":"F16+F17","v":{"v":3580,"d":"3,580.00 "}}]
[]
[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":{"v":280,"d":"280.00 "}},{"$f":"E22*$C$23","v":{"v":280,"d":"280.00 "}}]
[null,"% de prime :",{"v":1,"d":"100%"},"IPP",{"$f":"(F6+F13+F15)*(1+$E$17)","v":{"v":300,"d":"300.00 "}},{"$f":"E23*$C$23","v":{"v":300,"d":"300.00 "}}]
[{"$nulls":3},"FMP",{"$f":"F7*(1+$E$17)","v":{"v":3000,"d":"3,000.00 "}},{"v":3000,"d":"3,000.00 "}]
[null,"PRIME NETTE",null,null,{"$f":"SUM(E22:E24)","v":{"v":3580,"d":"3,580.00 "}},{"$f":"SUM(F22:F24)","v":{"v":3580,"d":"3,580.00 "}}]

{"sheet":"STAEM","index":2,"n_rows":16,"n_cols":5,"rows_kept":16}
[]
[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: ",{"v":1000000,"d":"1,000,000 DA"}]
[null,"IPP / IPT",{"v":1000000,"d":"1,000,000 DA"}]
[null,"FMP ",{"v":0,"d":"0 DA"}]
[null,"Prime nette annuelle",{"v":4750,"d":"4,750 DA"}]

{"sheet":"Feuil1","index":3,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Calcul (2)","index":4,"n_rows":8,"n_cols":6,"rows_kept":8,"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,5,null,"Capital assuré","Taux","Prime"]
[null,"Garanties de Base","Décès",{"v":2000000,"d":"2,000,000 "},{"$f":"VLOOKUP($B$4,Classe,2,0)","v":{"v":0.0035,"d":"0.350%"}},{"$f":"E5*D5","v":{"v":7000,"d":"7,000 "}}]
[null,null,"IPP",{"v":1000000,"d":"1,000,000 "},{"$f":"VLOOKUP($B$4,Classe,3,0)","v":{"v":0.00375,"d":"0.375%"}},{"$f":"E6*D5","v":{"v":7500,"d":"7,500 "}}]
[null,null,"FMP",0,{"$f":"VLOOKUP($B$4,Classe,5,0)","v":150},{"$f":"E7*D7/1500","v":0}]
[null,null,"PRIME BASE :",null,null,{"$f":"SUM(F5:F7)","v":{"v":14500,"d":"14,500.00 "}}]