{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["devis","param","devis2","etatDesPrimes","tableauDeBord","jeuneConducteur"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":16,"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":"devis","index":0,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Simulation du calcul de la prime annuelle d'assurance auto d'un nouvel assuré"]
[]
["Date du jour",{"$f":"NOW()","v":"2020-02-17T09:27:01.580"}]
[]
["Le véhicule",null,null,"Le contrat"]
["Marque ","Renault",null,"Formule","Différence"]
["Modèle","Clio"]
["Puissance",3,null,"Le véhicule","Année"]
["Immatriculation","DQ-9A7-SQ",{"$f":"IF(AND(ISTEXT(LEFT(B9,2)),ISNUMBER(MID(B9,4,3)),ISTEXT(RIGHT(B9,2))),\"\",\"Erreur\")","v":"Erreur"},"Ancienneté",{"$f":"IF(DATE(YEAR(B3),MONTH(B10),DAY(B10))>B3,YEAR(B3)-YEAR(B10)-1,YEAR(B3)-YEAR(B10))","v":3}]
["Date 1ère immatriculation","2016-03-10"]
["Lieu de stationnement","Jardin clos",null,"Montant de la prime"]
["Bonus - Malus déclaré",0.5,null,"Éléments","Montant"]
["Bonus acquis depuis",9,null,"Vehicule"]
[null,null,null,"Cotisation",{"$f":"IFERROR(VLOOKUP(B8,param!$A$11:$B$22,2,FALSE),\"\")","v":400}]
[null,null,null,"Réduction\nancienneté",{"$f":"-IFERROR(VLOOKUP(E9,param!$E$11:$F$21,2,TRUE)*E14,\"\")","v":-19.600000000000001}]
["Le souscripteur",null,null,"Prime de base",{"$f":"SUM(devis!E14:E15)*VLOOKUP(E6,param!B4:C7,2,FALSE)","v":665.69999999999993}]
["Nom","XUARD"]
["Prénom","Seb "]
["Date de naissance","1965-08-15"]
["Situation","célibataire"]
["Date d'obtention du permis","1985-07-01"]
["Usage","privés et trajets travail "]

{"sheet":"param","index":1,"n_rows":142,"n_cols":31,"rows_kept":142,"cut":false,"hidden":false,"merged":[]}
["Paramètres"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11]
["Type contrat","Nom du contrat","Coefficient",null,"Taxes et frais","%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Audi","BMW","Citroen","Dacia","Fiat","Ford","Mercedes","Peugeot","Renault","Toyota","Volkswagen"]
[1,"Initiale",1,null,"Fiscale",0.33,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A1","I8","Berlingo","Duster","500","C-MAX","Classe A","107","Captur","Auris","Amarok"]
[2,"Essentiel",1.24,null,"Protection",0.02,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A3","Serie 1","C1","Logan","500c","Fiesta","Classe B","206","Clio","Avensis","Crafter"]
[3,"Différence",1.75,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A4","Serie 2","C2","Sandero","Ducato","Focus","Classe C","207","Espace","Aygo","Eos"]
[4,"Plénitude",2.2000000000000002,null,"Frais de gestion",0.13819999999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A5","Serie 3","C3",null,"Grande","Fusion","Classe clk","208","Kadjar","Corolla","Fox"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A6","Serie 4","C4",null,"Panda","Ka","Classe cls","307","Kangoo","Iq","Golf"]
["Base prime",null,null,null,"Véhicule",null,null,null,null,null,null,null,null,"Marque",null,null,null,null,null,null,"A7","Serie 5","C5",null,"Punto","Kuga","Classe E","308","Koleos","Land","Multivan"]
["CV","Prime",null,null,"Age","Réduction ",null,null,null,null,null,null,null,"num","Nom",null,"Modèle",null,null,null,"A8","Serie 7","C6",null,"Scudo","Mondeo","Classe glc","406","Laguna","Prius","Passat"]
[2,350,null,null,0,0,null,null,null,null,null,null,null,1,"Audi",null,"Marque","Modèle","Puissance fiscale",null,"Q3","X1","C8",null,null,"S-MAX","Classe gle","407","Master","Prius+","Polo"]
[3,400,null,null,1,0,null,null,null,null,null,null,null,2,"BMW",null,1,"A1",5,null,"Q5","X3","Ds3",null,null,"Transit","Classe glk","508","Megane","Rav4","Scirocco"]
[4,450,null,null,2,2.5000000000000001E-2,null,null,null,null,null,null,null,3,"Citroen",null,1,"A3",4,null,"Q7","X4","Ds4",null,null,null,"Classe m","807","Mégane","Verso","Sharan"]
[5,500,null,null,3,4.9000000000000002E-2,null,null,null,null,null,null,null,4,"Dacia",null,1,"A4",5,null,"SQ5","X5","Ds5",null,null,null,"Classe R","1007","scenic","Yaris","Tiguan"]
[6,550,null,null,4,7.2999999999999995E-2,null,null,null,null,null,null,null,5,"Fiat",null,1,"A5",8,null,null,"X6","Jumper",null,null,null,"SLK","2008","scénic",null,"Touareg"]
[7,610,null,null,5,9.6000000000000002E-2,null,null,null,null,null,null,null,6,"Ford",null,1,"A6",8,null,null,null,"Jumpy",null,null,null,"Sprinter","3008","Super",null,"Touran"]
[8,650,null,null,6,0.11899999999999999,null,null,null,null,null,null,null,7,"Mercedes",null,1,"A7",8,null,null,null,"Saxo",null,null,null,"Vito","4007","Trafic"]
[9,710,null,null,7,0.14099999999999999,null,null,null,null,null,null,null,8,"Peugeot",null,1,"A8",12,null,null,null,"Xsara",null,null,null,null,"5008","Twingo"]
[10,750,null,null,8,0.16200000000000001,null,null,null,null,null,null,null,9,"Renault",null,1,"Q3",5,null,null,null,null,null,null,null,null,"206+"]
[11,800,null,null,9,0.183,null,null,null,null,null,null,null,10,"Toyota",null,1,"Q5",5,null,null,null,null,null,null,null,null,"Boxer"]
[12,850,null,null,10,0.20399999999999999,null,null,null,null,null,null,null,11,"Volkswagen",null,1,"Q7",8,null,null,null,null,null,null,null,null,"Expert"]
[13,900,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"SQ5",8,null,null,null,null,null,null,null,null,"Partner"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"TT",5,null,null,null,null,null,null,null,null,"Rcz"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"I8",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Serie 1",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Serie 2",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Serie 3",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Serie 4",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Serie 5",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Serie 7",13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"X1",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"X3",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"X4",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"X5",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"X6",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Berlingo",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"C1",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"C2",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"C3",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"C4",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"C5",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"C6",7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"C8",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Ds3",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Ds4",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Ds5",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Jumper",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Jumpy",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Saxo",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Xsara",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Duster",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Logan",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Sandero",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"500",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"500c",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Ducato",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Grande",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Panda",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Punto",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Scudo",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"C-MAX",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Fiesta",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Focus",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Fusion",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Ka",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Kuga",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Mondeo",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"S-MAX",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Transit",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Classe A",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Classe B",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Classe C",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Classe clk",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Classe cls",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Classe E",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Classe glc",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Classe gle",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Classe glk",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Classe m",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Classe R",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"SLK",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Sprinter",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Vito",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"107",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"206",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"207",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"208",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"307",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"308",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"406",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"407",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"508",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"807",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"1007",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"2008",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"3008",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"4007",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"5008",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"206+",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Boxer",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Expert",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Partner",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Rcz",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Captur",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Clio",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Espace",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Kadjar",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Kangoo",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Koleos",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Laguna",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Master",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Megane",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Mégane",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"scenic",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"scénic",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Super",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Trafic",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Twingo",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Auris",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Avensis",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Aygo",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Corolla",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Iq",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Land",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Prius",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Prius+",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Rav4",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Verso",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Yaris",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Amarok",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Crafter",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Eos",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Fox",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Golf",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Multivan",7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Passat",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Polo",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Scirocco",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Sharan",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Tiguan",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Touareg",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Touran",4]

{"sheet":"devis2","index":2,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Simulation du calcul de la prime annuelle d'assurance auto d'un nouvel assuré"]
[]
["Date du jour",{"$f":"NOW()","v":"2020-02-17T09:27:01.580"}]
[]
["Le véhicule",null,null,"Le contrat"]
["Marque ","Renault",null,"Formule","Différence"]
["Modèle","Clio"]
["Puissance",3,null,"Montant de la prime"]
["Immatriculation","DQ-9A7-SQ",{"$f":"IF(AND(ISTEXT(LEFT(B9,2)),ISNUMBER(MID(B9,4,3)),ISTEXT(RIGHT(B9,2))),\"\",\"Erreur\")","v":"Erreur"},"Eléments","Montant"]
["Ancienneté véhicule","2016-02-10",null,"Vehicule"]
["Lieu de stationnement","Jardin clos",null,"Puissance",{"$f":"IFERROR(VLOOKUP(B8,param!$A$11:$B$22,2,TRUE),\"\")","v":400}]
["Bonus - Malus déclaré",2.5,null,"Age",{"$f":"IFERROR(VLOOKUP(B8,param!$A$11:$B$22,2,TRUE),\"\")","v":400}]
["Bonus acquis depuis",9,null,"Prime de base",{"$f":"SUM(E11:E12)*VLOOKUP(E6,param!$B$4:$C$7,2,FALSE)","v":1400}]
[]
[]
["Le souscripteur"]
["Nom","XUARD"]
["Prénom","Seb "]
["Date de naissance","1965-08-15"]
["Situation","célibataire"]
["Date d'obtention du permis","1985-07-01"]
["Usage","privés et trajets travail "]

{"sheet":"etatDesPrimes","index":3,"n_rows":377,"n_cols":11,"rows_kept":377,"cut":false,"hidden":false,"merged":[]}
["Prime annuelle des 4 dernières années"]
[]
["Année",2019]
[null,null,null,"Année en cours",null,null,null,null,"Rappel années antérieures"]
["nom","prénom","Type contrat","Prime pure","Bonus malus","Montant HT","Frais et taxes",2019,2018,2017,2016]
["Morizet","Yann","Essentiel",448,0.51,{"$f":"D6*E6","v":228.48000000000002},{"$f":"F6*0.16","v":36.556800000000003},{"$f":"ROUND(F6+G6,2)","v":265.04000000000002},332.6,302.36,314.45]
["Watier","Guillaume","Différence",1249,1.9,{"$f":"D7*E7","v":2373.1},{"$f":"F7*0.16","v":379.69599999999997},{"$f":"ROUND(F7+G7,2)","v":2752.8},724.42,696.56,724.42]
["Henry","Charline","Essentiel",1755,0.5,{"$f":"D8*E8","v":877.5},140.4,1017.9,1180.76,1227.99,1180.76]
["Cerdan","Axel","Initiale",385,1.55,596.75,95.48,692.23,334.95,290.29000000000002,279.13]
["Bouzouba","Yassine","Différence",966,0.93,898.38,143.74080000000001,1042.1199999999999,672.34,699.23,726.12]
["Amit","Hagay","Plénitude",444,0.72,319.68,51.148800000000001,370.83,293.57,293.57,305.32]
["Mourgues","Regis","Différence",611,1.93,1179.23,188.67680000000001,1367.91,439.43,351.54,0]
["Diot","Herve","Essentiel",421,0.61,256.81,41.089600000000004,297.89999999999998,263.70999999999998,273.13,235.46]
["Elliot","Mary","Initiale",643,3.41,2192.63,350.82080000000002,2543.4499999999998,477.36,377.62,391.87]
["Hasle-De-Barral","Alexandre","Initiale",387,0.52,201.24,32.198399999999999,233.44,305.27,258.7,269.05]
["Launeau","Patrick","Initiale",446,1.08,481.68,77.068799999999996,558.75,258.68,268.63,248.73]
["Mandin","Louison","Différence",1857,0.5,928.5,148.56,1077.06,1206.31,1206.31,1254.56]
["Langlais","Benoit","Essentiel",406,1.38,560.28,89.644800000000004,649.91999999999996,240.19,226.59,226.59]
["Garibaldi","Cynthia","Plénitude",407,2.06,838.42000000000007,134.14720000000003,972.57,236.06,245.5,236.06]
["Le-Deit","Laetitia","Initiale",423,0.61,258.02999999999997,41.284799999999997,299.31,264.97000000000003,264.97000000000003,264.97000000000003]
["Civet","Francois","Différence",474,0.77,364.98,58.396800000000006,423.38,274.92,264.35000000000002,264.35000000000002]
["Morcrette","Annabelle","Initiale",405,1.33,538.65,86.183999999999997,624.83000000000004,300.67,273.33999999999997,284.27]
["Viard","Sophie","Différence",739,0.5,369.5,59.120000000000005,428.62,505.77,495.85,495.85]
["Denis","Thomas","Initiale",456,0.72,328.32,52.531199999999998,380.85,280.35000000000002,291.56,302.77999999999997]
["Grasset","Olivier","Essentiel",1333,0.5,666.5,106.64,773.14,773.14,743.4,773.14]
["Vacher","Pierre","Essentiel",411,1.17,480.86999999999995,76.9392,557.80999999999995,238.38,229.21,238.38]
["Jorissen","Frans","Différence",1101,0.5,550.5,88.08,638.58000000000004,715.21,752.2,789.2]
["Remy","Cecile","Différence",762,0.5,381,60.96,441.96,654.1,565.41,554.32000000000005]
["Gaudin","Pierre","Initiale",422,0.55000000000000004,232.10000000000002,37.136000000000003,269.24,293.70999999999998,305.01,282.42]
["Geslin","Emmanuelle","Initiale",1553,0.5,776.5,124.24000000000001,900.74,900.74,935.38,970.03]
["Leroux","Alexandre","Initiale",897,0.93,834.21,133.4736,967.68,686.74,597.16999999999996,517.54999999999995]
["Bicchi","Erica","Plénitude",457,0.68,310.76000000000005,49.721600000000009,360.48,318.07,330.79,318.07]
["Metzger","Edouard","Initiale",952,0.78,742.56000000000006,118.80960000000002,861.37,684.68,710.52,0]
["Baltzer","Carla","Différence",1259,0.5,629.5,100.72,730.22,949.29,847.58,847.58]
["Happert","Solene","Initiale",876,0.5,438,70.08,508.08,751.96,644.54,673.83]
["Parent","Briz","Essentiel",1924,0.5,962,153.92000000000002,1115.92,1160.56,1206.98,1253.4000000000001]
["Blanchet","Carlito","Plénitude",1715,0.5,857.5,137.20000000000002,994.7,994.7,1032.96,956.44]
["Thebault","Erwan","Plénitude",1640,2.75,4510,721.6,5231.6000000000004,951.2,951.2,989.25]
["Beaunay","Stephanie","Plénitude",390,3.32,1294.8,207.16800000000001,1501.97,294.06,233.52,242.17]
["Bourgeais","Hugo","Différence",1429,0.5,714.5,114.32000000000001,828.82,878.55,913.69,878.55]
["Francois","Yann","Essentiel",504,0.6,302.39999999999998,48.384,350.78,368.32,385.07,334.84]
["Mercier","Eric","Essentiel",448,0.74,331.52,53.043199999999999,384.56,400.15,419.83,439.51]
["Sauvagnat","Mickael","Différence",680,0.63,428.4,68.543999999999997,496.94,591.6,621.94000000000005,652.28]
["Laffourcade","Roland","Initiale",853,0.67,571.51,91.441599999999994,662.95,494.74,514.53,494.74]
["Keita","Fanta","Différence",1894,0.5,947,151.52000000000001,1098.52,1340.19,1403.02,1214.55]
["Lenta","Laurent","Initiale",789,0.57999999999999996,457.61999999999995,73.219199999999987,530.84,658.97,685.33,720.48]
["Boucetta","Ali","Essentiel",451,0.75,338.25,54.120000000000005,392.37,313.89999999999998,325.97000000000003,338.04]
["Puig","Clemence","Initiale",428,0.61,261.08,41.772799999999997,302.85000000000002,302.85000000000002,317.05,331.25]
["Mocquet","Antoine","Différence",453,1.94,878.81999999999994,140.6112,1019.43,273.25,253.01,263.13]
["Aussenac","Raphael","Initiale",392,0.56999999999999995,223.43999999999997,35.750399999999999,259.19,227.36,218.62,227.36]
["Girardeau","Jacques","Initiale",1837,0.99,1818.6299999999999,290.98079999999999,2109.61,1555.57,1228.08,1064.3399999999999]
["Zanella","Alain","Essentiel",427,2.48,1058.96,169.43360000000001,1228.3900000000001,297.19,311.33999999999997,325.5]
["Bosse","Luzia","Initiale",410,2.76,1131.5999999999999,181.05599999999998,1312.66,256.82,256.82,256.82]
["Carpy","Sabrina","Essentiel",706,0.75,529.5,84.72,614.22,475,475,494]
["Schiebel","Ralf","Différence",782,2.59,2025.3799999999999,324.06079999999997,2349.44,571.49,594.35,617.20000000000005]
["Strzerzynski","Pierre","Essentiel",387,0.6,232.2,37.152000000000001,269.35000000000002,341.18,358.24,311.33]
["Ndjao","Mayabassim","Plénitude",755,0.71,536.04999999999995,85.768000000000001,621.82000000000005,665.61,698.89,557.45000000000005]
["Le-Menn","Erwan","Initiale",1939,2.61,5060.79,809.72640000000001,5870.52,1124.6199999999999,1124.6199999999999,1124.6199999999999]
["Masse","Marion","Plénitude",448,0.52,232.96,37.273600000000002,270.23,259.83999999999997,259.83999999999997,259.83999999999997]
["Denis","David","Initiale",747,0.61,455.67,72.907200000000003,528.58000000000004,450.59,450.59,468.61]
["Da-Silva","Lucas","Plénitude",429,0.63,270.27,43.243199999999995,313.51,318.49,275.70999999999998,237.68]
["Reiland","Damien","Initiale",865,0.5,432.5,69.2,501.7,551.87,573.94000000000005,596.02]
["Lorand","Jean-Pierre","Initiale",432,0.5,216,34.56,250.56,250.56,260.58,0]
["Reizine","Hugo","Initiale",444,0.56000000000000005,248.64000000000001,39.782400000000003,288.42,339.93,270.95999999999998,280.81]
["Chubb","Timothy","Essentiel",1353,0.5,676.5,108.24000000000001,784.74,847.52,881.42,915.32]
["Lepinay","Alexandra","Essentiel",417,0.65,271.05,43.368000000000002,314.42,241.86,251.16,232.56]
["Beneteau","Eric","Essentiel",440,1.77,778.8,124.60799999999999,903.41,377.7,324.58,295.08]
["Mojtahid","Meryem","Différence",1621,0.5,810.5,129.68,940.18,940.18,904.02,940.18]
["Chakib","Anis","Différence",394,0.51,200.94,32.150399999999998,233.09,228.52,219.73,219.73]
["Kabura-","Raphael","Essentiel",431,3.38,1456.78,233.0848,1689.86,309.98,321.67,292.43]
["Marquant","Baptiste","Plénitude",422,2.41,1017.0200000000001,{"$f":"F71*0.16","v":162.72320000000002},{"$f":"ROUND(F71+G71,2)","v":1179.74},293.70999999999998,233.1,233.1]
["Fontanier","Christophe","Plénitude",1305,0.5,{"$f":"D72*E72","v":652.5},104.4,756.9,908.28,943.21,873.35]
["Leclercq","Antonin","Initiale",422,0.55000000000000004,232.10000000000002,37.136000000000003,269.24,337.77,292.73,281.47000000000003]
["Lorans","Mathieu","Plénitude",457,2.61,1192.77,190.8432,1383.61,312.77,312.77,312.77]
["Sanchez-","Sophie","Différence",405,3.02,1223.0999999999999,195.696,1418.8,248.99,258.95,268.91000000000003]
["Sanchez-Angulo","Martin","Différence",792,0.5,396,63.36,459.36,459.36,477.73,459.36]
["Lutfalla","Suzanne","Différence",431,2.9,1249.8999999999999,199.98399999999998,1449.88,249.98,259.98,249.98]
["Ecourtemer","Tony","Différence",1281,2.67,3420.27,547.2432,3967.51,936.15,970.83,1005.5]
["Tardivo","Caroline","Plénitude",414,0.66,273.24,43.718400000000003,316.95999999999998,273.74,237.24,228.11]
["Guiffan","Sebastien","Plénitude",1530,1.9,2907,465.12,3372.12,887.4,887.4,887.4]
["Bonhomme","Camille","Initiale",424,1.9,805.59999999999991,128.89599999999999,934.5,245.92,255.76,245.92]
["Rakotomalala","Erika","Différence",447,1.1399999999999999,509.58,81.532799999999995,591.11,321.48,336.32,351.16]
["Delgove","Erwann","Initiale",1216,0.5,608,97.28,705.28,719.39,719.39,748.16]
["Pochat","Stephane","Essentiel",727,0.61,443.46999999999997,70.955199999999991,514.42999999999995,421.66,421.66,421.66]
["Quinchard","Sophie","Plénitude",395,0.52,205.4,32.864000000000004,238.26,265.76,276.39,287.02]
["Maillet","Gregoire","Différence",1820,0.63,1146.5999999999999,183.45599999999999,1330.06,1287.83,1348.2,1408.57]
["Taty","Pierre","Initiale",394,0.65,256.10000000000002,40.976000000000006,297.08,287.94,266.61,277.27]
["Dumoulin","Caroline","Initiale",1409,0.53,746.77,119.4832,866.25,931.63,978.21,1024.79]
["Lebeau","Thierry","Essentiel",410,0.71,291.09999999999997,46.575999999999993,337.68,247.31,228.99,238.15]
["Badji","Mamadou","Initiale",452,0.69,311.88,49.900800000000004,361.78,398.48,418.41,0]
["Capdeville","Yann","Initiale",1596,0.5,798,127.68,925.68,925.68,890.08,925.68]
["Lejas","Damien","Initiale",472,0.59,278.47999999999996,44.556799999999996,323.04000000000002,323.04000000000002,338.67,291.77999999999997]
["Bœuf","Eric","Essentiel",430,0.65,279.5,44.72,324.22000000000003,249.4,259.38,249.4]
["Hemeryck","Raphaele","Essentiel",388,0.62,240.56,38.489600000000003,279.05,225.04,234.04,243.04]
["Romann","Coralie","Essentiel",1402,0.5,701,112.16,813.16,927,927,964.08]
["Lepinay-","Pierre","Initiale",416,0.54,224.64000000000001,35.942400000000006,260.58,332.97,346.84,360.71]
["Humler","Eric","Initiale",742,0.5,371,59.36,430.36,662.75,522.16999999999996,502.09]
["Sotin","Christophe","Différence",416,1.8,748.80000000000007,119.80800000000001,868.61,289.54000000000002,303.32,317.11]
["Hounkpevi","Koassi-Robert","Initiale",584,0.7,408.79999999999995,65.407999999999987,474.21,426.79,443.86,426.79]
["Mandin","Leonard","Initiale",831,0.59,490.28999999999996,78.446399999999997,568.74,636.21,611.74,636.21]
["Thuillier","Brice","Initiale",667,1.65,1100.55,176.08799999999999,1276.6400000000001,495.18,450.16,468.17]
["Buissart","Fabien","Différence",435,2.23,970.05,155.208,1125.26,272.48,283.38,272.48]
["Gillard","Arthur","Différence",1098,0.5,549,87.84,636.84,955.26,1004.25,1053.24]
["Pedurthe","Sandra","Initiale",815,0.5,407.5,65.2,472.7,671.23,698.45,734.73]
["Desmas","Thibaud","Initiale",410,2.89,1184.9000000000001,189.58400000000003,1374.48,323.41000000000003,335.39,347.36]
["Mba-","Assoumou-Fidele","Initiale",1073,0.5,536.5,85.84,622.34,622.34,647.23,622.34]
["Ciminera","Marina","Initiale",1147,0.5,573.5,91.76,665.26,705.18,733.38,761.59]
["Lucas","Mael","Initiale",389,3.28,1275.9199999999998,204.14719999999997,1480.07,225.62,225.62,234.64]
["Bezos","Antoine","Différence",1617,0.5,808.5,129.36000000000001,937.86,937.86,901.79,901.79]
["Michelon","Julie","Initiale",1608,0.5,804,128.64000000000001,932.64,932.64,932.64,932.64]
["Robles","Rosemery","Plénitude",458,0.67,306.86,49.0976,355.96,334.71,334.71,334.71]
["Loyen","Herve","Initiale",895,0.99,886.05,141.768,1027.82,664.45,604.04,628.21]
["Aubert","Guillaume","Essentiel",1458,0.5,729,116.64,845.64,964.03,1012.23,867.63]
["Letoublon","Thomas","Plénitude",1498,0.5,749,119.84,868.84,1146.8699999999999,1190.98,0]
["Guivel","Christele","Essentiel",977,0.91,889.07,142.25120000000001,1031.32,804.66,718.44,718.44]
["Beucler","Eric","Différence",758,0.5,379,60.64,439.64,615.5,640.79,556.48]
["Cance","Philippe","Différence",397,0.68,269.96000000000004,43.193600000000004,313.14999999999998,322.36,333.88,351.15]
["Lambertucci","Virginie","Initiale",454,0.71,322.33999999999997,51.574399999999997,373.91,321.25,336.31,291.13]
["Verhoeven","Olivier","Initiale",624,0.96,599.04,95.846400000000003,694.89,441.54,0,482.94]
["Cariou-Lacombe","Elsa","Initiale",940,1.19,1118.5999999999999,178.976,1297.58,719.66,750.95,594.51]
["Brehier","Marie-Claire","Plénitude",819,0.5,409.5,65.52,475.02,779.03,811.95,844.87]
["Carrere","Veronique","Initiale",438,0.74,324.12,51.859200000000001,375.98,370.9,317.91000000000003,329.69]
["Le-Mouelic","Stephane","Plénitude",449,0.73,327.77,52.443199999999997,380.21,437.51,457.39,362.93]
["Morel","Gaetan","Initiale",436,2.73,1190.28,190.44479999999999,1380.72,379.32,398.77,316.10000000000002]
["Lepape","Adeline","Initiale",406,2.2400000000000002,909.44,145.5104,1054.95,480.38,502.83,435.48]
["Manga","Daniel","Plénitude",396,0.53,209.88000000000002,33.580800000000004,243.46,385.86,306.94,320.08999999999997]
["Bonnin","Mickael","Initiale",1838,2.5499999999999998,4686.8999999999996,749.904,5436.8,1343.21,1243.71,1293.46]
["Mangold","Nicolas","Plénitude",598,0.52,310.96000000000004,49.753600000000006,360.71,520.26,413.54,433.55]
["Mitri","Guiseppe","Essentiel",1503,0.5,751.5,120.24000000000001,871.74,1290.18,1355.78,1421.38]
["Parroco","Sophie","Initiale",1624,2.62,4254.88,680.7808,4935.66,1054.95,1109.52,964.01]
["Mbeme-Otsagha","Franck","Initiale",1340,2.5099999999999998,3363.3999999999996,538.14400000000001,3901.54,823.83,853.79,748.94]
["Saintagne","Guillaume","Initiale",422,1.73,730.06,116.80959999999999,846.87,318.19,276.07,0]
["Tobie","Gabriel","Initiale",454,0.56999999999999995,258.77999999999997,41.404799999999994,300.18,384.45,331.42,344.68]
["Ansan","Veronique","Plénitude",772,0.88,679.36,108.69760000000001,788.06,447.76,464.98,430.54]
["Nna-Mvondo","Delphine","Initiale",426,0.72,306.71999999999997,{"$f":"F135*0.16","v":49.075199999999995},{"$f":"ROUND(F135+G135,2)","v":355.8},247.08,256.95999999999998,247.08]
["Laigle","Idaline","Initiale",1007,0.5,{"$f":"D136*E136","v":503.5},80.56,584.05999999999995,712.55,712.55,712.55]
["Bahon","Vianney","Plénitude",1066,0.5,533,85.28,618.28,618.28,618.28,618.28]
["Cassu","Marion","Initiale",795,0.97,771.15,123.384,894.53,617.87,649.83000000000004,681.79]
["Choblet","Gael","Essentiel",1070,0.5,535,85.600000000000009,620.6,633.01,656.9,597.17999999999995]
["Jouaux","Clement","Essentiel",679,0.69,468.51,74.961600000000004,543.47,551.35,574.01,498.48]
["Combaz","David","Plénitude",810,2.5499999999999998,2065.5,330.48,2395.98,685.91,541.51,469.31]
["Douarin","Melanie","Essentiel",436,0.64,279.04000000000002,44.646400000000007,323.69,313.57,295.82,295.82]
["Huon","Alice","Initiale",437,2.63,1149.31,183.8896,1333.2,253.46,263.20999999999998,243.71]
["Chazalet","Melanie","Initiale",490,0.57999999999999996,284.2,45.472000000000001,329.67,437.67,457.56,477.46]
["Schweizer","Magali","Différence",445,0.68,302.60000000000002,48.416000000000004,351.02,392.31,313.85000000000002,250.1]
["Gianesello","Lucas","Initiale",414,0.73,302.21999999999997,48.355199999999996,350.58,485.04,507.92,530.79999999999995]
["Pecheul","Leo","Différence",1666,0.5,833,133.28,966.28,1565.37,1638.75,1712.13]
["Bourgeois","Olivier","Plénitude",431,0.73,314.63,50.340800000000002,364.97,329.97,317.27999999999997,329.97]
["Howa","Helene","Essentiel",432,0.55000000000000004,237.60000000000002,38.016000000000005,275.62,305.68,262.7,272.25]
["Barras","Christine","Essentiel",409,0.56000000000000005,229.04000000000002,36.646400000000007,265.69,403.27,321.70999999999998,335.31]
["La-","Carole","Essentiel",474,0.6,284.39999999999998,45.503999999999998,329.9,307.91000000000003,323.83999999999997,281.37]
["Baron","Frederic","Essentiel",440,0.6,264,42.24,306.24,336.86,351.51,366.16]
["Maubourguet","Sylvie","Initiale",438,0.98,429.24,68.678399999999996,497.92,274.36,284.16000000000003,298.86]
["Gaudin","Anne","Essentiel",401,0.56999999999999995,228.57,36.571199999999997,265.14,232.58,241.53,223.63]
["Khac","Emmanuelle","Initiale",703,0.8,562.4,89.983999999999995,652.38,489.29,512.59,403.86]
["Monnier","Christophe","Essentiel",1434,2.2799999999999998,3269.5199999999995,523.12319999999988,3792.64,1014.7,1062.26,840.3]
["Rondeau","Benjamin","Essentiel",419,0.66,276.54000000000002,44.246400000000001,320.79000000000002,447.16,354,279.47000000000003]
["Giraud","Manuel","Différence",921,0.5,460.5,73.680000000000007,534.17999999999995,641.02,641.02,666.66]
["Mouret","Aurelia","Initiale",987,0.5,493.5,78.960000000000008,572.46,732.75,759.39,799.36]
["Nardelli","Maria-Pia","Initiale",447,1.82,813.54000000000008,130.16640000000001,943.71,274.82,285.81,296.8]
["Drieux","Helene","Différence",771,0.65,501.15000000000003,80.184000000000012,581.33000000000004,724.43,0,0]
["Mege","Daniel","Plénitude",444,2.2599999999999998,1003.4399999999999,160.5504,1163.99,530.49,456.81,0]
["Sandrine","Cavalli","Essentiel",868,0.82,711.76,113.88160000000001,825.64,815.57,853.8,892.03]
["Wafa","Pozos-Baez","Essentiel",639,0.94,600.66,96.105599999999995,696.77,400.27,416.28,400.27]
["Adeline","Prevost","Différence",456,2.41,1098.96,175.83360000000002,1274.79,306.8,306.8,319.07]
["Céline","Augras","Initiale",457,0.57999999999999996,265.06,42.409600000000005,307.47000000000003,429.4,368.78,383.93]
["Veronique","Domine","Différence",438,1.39,608.81999999999994,97.411199999999994,706.23,304.85000000000002,261.3,241.94]
["Janine","Heath","Essentiel",653,0.98,639.93999999999994,102.3904,742.33,409.04,365.21,365.21]
["Thierry","Guerin","Plénitude",415,0.55000000000000004,228.25000000000003,36.520000000000003,264.77,250.33,231.79,241.06]
["Olivia","Garrec","Essentiel",453,0.55000000000000004,249.15000000000003,39.864000000000004,289.01,488.7,513.89,443.35]
["Isabelle","Du","Essentiel",1849,0.5,924.5,147.92000000000002,1072.42,2209.19,2316.9499999999998,2424.7199999999998]
["Federica","Mavier","Initiale",1017,0.5,508.5,81.36,589.86,872.99,913.91,954.84]
["Caroline","De-Samucewicz","Différence",419,0.72,301.68,48.268799999999999,349.95,349.95,279.95999999999998,242.63]
["Adeline","Guerin","Différence",405,0.53,214.65,34.344000000000001,248.99,371.14,294.73,272.89999999999998]
["Emilie","Louvel","Initiale",399,0.61,243.39,38.942399999999999,282.33,240.68,250.3,240.68]
["Saidat","Arrondell","Initiale",1584,1.56,2471.04,395.3664,2866.41,1028.97,1082.19,1135.4100000000001]
["Corine","Muller","Essentiel",695,0.5,347.5,55.6,403.1,403.1,419.22,403.1]
["Valentin","Marillat","Différence",438,0.51,223.38,35.7408,259.12,482.68,415.1,434.41]
["Bridget","Lamrani","Essentiel",456,3.02,1377.1200000000001,220.33920000000003,1597.46,555.41,479.67,414.03]
["Céline","Burguiere","Plénitude",403,0.99,398.96999999999997,63.835199999999993,462.81,243.09,225.08,225.08]
["Ghislaine","Mineau","Initiale",388,1.61,624.68000000000006,99.948800000000006,724.63,225.04,225.04,225.04]
["Blandine","Gnagi","Plénitude",608,0.68,413.44000000000005,66.150400000000005,479.59,514.85,443.84,461.59]
["Jean-Luc","Wiie","Plénitude",752,0.56999999999999995,428.64,68.582399999999993,497.22,436.16,453.61,471.05]
["Arnaud","Leresche","Plénitude",1862,0.5,931,148.96,1079.96,1663.14,1744.93,1826.73]
["Jean-Sébastien","Bermudes","Initiale",449,1.66,745.33999999999992,119.25439999999999,864.59,302.08999999999997,314.17,326.25]
["Jean-François","Machaux","Initiale",1982,0.74,1466.68,234.6688,1701.35,1149.56,1105.3499999999999,1105.3499999999999]
["Olivia","Gasser","Différence",942,0.67,631.14,100.9824,732.12,546.36,546.36,0]
["Sofian","Daufresne","Essentiel",799,1.04,830.96,132.95359999999999,963.91,463.42,481.24,499.07]
["Anne","Fuchs","Essentiel",417,2.4,1000.8,160.12799999999999,1160.93,251.53,261.60000000000002,251.53]
["Martine","Iacarelli","Différence",980,0.67,656.6,105.05600000000001,761.66,568.4,546.54,546.54]
["Malvina","Etchart","Plénitude",976,0.77,751.52,120.2432,871.76,566.08000000000004,566.08000000000004,566.08000000000004]
["Warwick","Abt","Initiale",442,2.59,1144.78,183.16479999999999,1327.94,266.61,277.27999999999997,266.61]
["Colombe","Cuomo","Initiale",387,0.75,290.25,46.44,336.69,233.44,242.08,216.15]
["Jean-Pierre","Joucla","Essentiel",1960,0.5,980,156.80000000000001,1136.8,1136.8,1180.52,1224.25]
["Anika","Petit","Essentiel",1981,2.69,5328.89,852.62240000000008,6181.51,1194.94,1239.2,1283.45]
["Bernard","Delpippo","Plénitude",1338,1.82,2435.1600000000003,389.62560000000008,2824.79,776.04,776.04,776.04]
["Deborah","Hannequin","Initiale",417,1.89,788.13,126.10080000000001,914.23,251.53,261.60000000000002,271.66000000000003]
["Kesh","De-Goue","Essentiel",404,3.3,1333.1999999999998,213.31199999999998,1546.51,243.69,253.44,243.69]
["Valérie","Liegeois","Initiale",884,0.5,442,{"$f":"F199*0.16","v":70.72},{"$f":"ROUND(F199+G199,2)","v":512.72},533.23,493.73,513.48]
["Valérie","Rimsky-Korsakoff","Différence",430,0.6,{"$f":"D200*E200","v":258},41.28,299.27999999999997,249.4,258.99,268.58]
["Cédric","Fontaine","Plénitude",783,0.97,759.51,121.52160000000001,881.03,472.31,437.32,454.81]
["Marie","Delaroff","Différence",1732,0.5,866,138.56,1004.56,1004.56,1044.74,1084.92]
["Sophie","Schaettel","Initiale",757,0.85,643.44999999999993,102.952,746.4,456.62,456.62,456.62]
["Stephanie","Pic","Essentiel",1898,2.2999999999999998,4365.3999999999996,698.46399999999994,5063.8599999999997,1144.8699999999999,1144.8699999999999,1190.67]
["Sophie","Graham","Essentiel",1438,0.5,719,115.04,834.04,867.4,803.15,835.28]
["Maxime","Martin","Différence",566,0.67,379.22,60.675200000000004,439.9,328.28,341.41,328.28]
["Isabelle","Rosati","Essentiel",984,0.73,718.31999999999994,114.93119999999999,833.25,593.54999999999995,593.54999999999995,617.29]
["Francoise","Auriac","Initiale",651,0.5,325.5,52.08,377.58,377.58,392.68,407.79]
["Laurence","Riikola","Plénitude",445,2.76,1228.1999999999998,196.51199999999997,1424.71,258.10000000000002,248.17,258.10000000000002]
["Florence","Alixant","Initiale",411,0.55000000000000004,226.05,36.167999999999999,262.22000000000003,238.38,238.38,247.92]
["Olivier","Radin","Essentiel",471,0.5,235.5,37.68,273.18,284.11,0,0]
["Stéphanie","Martin-Luna","Différence",712,0.52,370.24,59.238400000000006,429.48,429.48,445.39,397.67]
["Philippe","Lohmann","Initiale",1415,0.5,707.5,113.2,820.7,820.7,820.7,820.7]
["Nathalie","Pourtier","Essentiel",1503,0.5,751.5,120.24000000000001,871.74,871.74,906.61,941.48]
["Marina","Servantie","Essentiel",419,0.71,297.49,47.598400000000005,345.09,252.74,252.74,262.85000000000002]
["Michèle","Vardon","Initiale",464,0.77,357.28000000000003,57.164800000000007,414.44,269.12,279.88,269.12]
["Patricia","Orjansdotter-Johansson","Différence",688,0.81,557.28000000000009,89.164800000000014,646.44000000000005,399.04,399.04,415]
["Corinne","Madore","Initiale",446,0.74,330.04,52.806400000000004,382.85,258.68,268.63,248.73]
["Emeline","Pardou","Plénitude",688,0.67,460.96000000000004,73.753600000000006,534.71,399.04,414.39,429.74]
["Claire","Smeyers","Différence",911,0.5,455.5,72.88,528.38,549.52,569.87,508.81]
["Gérard","Thabuis","Initiale",447,0.63,281.61,45.057600000000001,326.67,259.26,259.26,259.26]
["Claire-Marie","Beck","Plénitude",1664,0.5,832,133.12,965.12,1003.72,1003.72,1043.8699999999999]
["Myriam","Soler","Plénitude",397,0.63,250.11,40.017600000000002,290.13,239.47,239.47,239.47]
["Véronique","Gessert","Initiale",946,0.97,917.62,146.8192,1064.44,548.67999999999995,548.67999999999995,548.67999999999995]
["Aila","Lenglet","Initiale",962,0.5,481,76.960000000000008,557.96,557.96,580.28,557.96]
["Aurora","Della-Rocca","Essentiel",1868,0.5,934,149.44,1083.44,1083.44,1125.1099999999999,1041.77]
["Nadine","Lys","Différence",409,0.5,204.5,32.72,237.22,246.71,246.71,246.71]
["Natacha","Reinhard","Initiale",392,0.57999999999999996,227.35999999999999,36.377600000000001,263.74,227.36,236.1,218.62]
["Véronique","Leprun","Initiale",401,0.66,264.66000000000003,42.345600000000005,307.01,232.58,241.88,232.58]
["Pierre-Marie","Jamet","Initiale",449,0.72,323.27999999999997,51.724799999999995,375,270.83999999999997,281.67,270.83999999999997]
["Marina","Regidor","Essentiel",1315,0.5,657.5,105.2,762.7,762.7,793.21,762.7]
["Christine","Niklas","Plénitude",941,0.63,592.83000000000004,94.852800000000002,687.68,567.61,590.32000000000005,0]
["Augusta","Moncomble","Initiale",781,0.5,390.5,62.480000000000004,452.98,452.98,470.4,435.56]
["Laure","Faivre-Calvinho","Initiale",436,0.63,274.68,43.948799999999999,318.63,252.88,243.15,252.88]
["Eveline","Ragueneau","Plénitude",1273,0.5,636.5,101.84,738.34,767.87,767.87,767.87]
["Florence","Boulannouar","Différence",1389,0.5,694.5,111.12,805.62,837.84,871.36,837.84]
["Corinne","Rouzies","Initiale",450,1.93,868.5,138.96,1007.46,261,250.96,261]
["Mylvia","Helwig","Initiale",390,0.57999999999999996,226.2,36.192,262.39,226.2,226.2,235.25]
["Florence","Giraud","Essentiel",673,0.87,585.51,93.681600000000003,679.19,390.34,405.35,420.37]
["Paul","Guillot","Initiale",609,0.56999999999999995,347.13,55.540799999999997,402.67,353.22,339.63,353.22]
["Corinne","Le-Fur","Différence",437,1.61,703.57,112.5712,816.14,263.60000000000002,244.07,253.84]
["Gabriela","Noltensmeier","Essentiel",427,0.61,260.46999999999997,41.675199999999997,302.14999999999998,257.57,257.57,267.87]
["Hélène","Girod","Initiale",597,0.55000000000000004,328.35,52.536000000000001,380.89,360.11,360.11,360.11]
["Henri","Petiot","Initiale",432,0.7,302.39999999999998,48.384,350.78,250.56,240.92,250.56]
["Melissa","Mercier","Plénitude",1885,0.5,942.5,150.80000000000001,1093.3,1137.03,1182.51,0]
["Yumiko","Naderer","Différence",385,2.48,954.8,152.768,1107.57,223.3,223.3,232.23]
["Evelyne","Eychenne","Différence",894,0.5,447,71.52,518.52,518.52,518.52,539.26]
["Sherry","Krieg","Initiale",402,0.51,205.02,32.803200000000004,237.82,242.49,252.19,261.89]
["Aurélie","Arjona-Rodriguez","Initiale",425,0.73,310.25,49.64,359.89,256.36,265.85000000000002,275.35000000000002]
["Nathalie","Rochard","Essentiel",674,0.81,545.94000000000005,87.350400000000008,633.29,390.92,406.56,390.92]
["Henri","Umeda","Plénitude",1254,1.97,2470.38,395.26080000000002,2865.64,727.32,756.41,727.32]
["Pierre-Olivier","Sagnet","Essentiel",433,3.19,1381.27,221.00319999999999,1602.27,251.14,251.14,261.19]
["Aude","Lentino","Initiale",408,0.98,399.84,63.974399999999996,463.81,236.64,227.54,236.64]
["Pascale","Dias","Initiale",387,1.24,479.88,76.780799999999999,556.66,224.46,215.83,215.83]
["Franck","Delage","Plénitude",1580,0.5,790,126.4,916.4,916.4,881.15,881.15]
["Fanny","Alborno","Essentiel",401,0.56000000000000005,224.56000000000003,35.929600000000008,260.49,241.88,251.56,261.23]
["Catherine","Thomine","Essentiel",1912,3.3,6309.5999999999995,1009.5359999999999,7319.14,1108.96,1066.31,1108.96]
["Caroline","Leflechelle","Essentiel",447,0.61,272.67,43.627200000000002,316.3,259.26,249.29,249.29]
["Sophie","Hamon","Différence",538,0.7,376.59999999999997,60.255999999999993,436.86,324.52,337.5,324.52]
["Laurianne","Gauchet","Initiale",453,0.73,330.69,52.910400000000003,383.6,273.25,253.01,263.13]
["Jan","Ibanez","Initiale",584,0.77,449.68,71.948800000000006,521.63,352.27,352.27,366.36]
["Inga","Hess","Plénitude",442,0.57999999999999996,256.35999999999996,41.017599999999995,297.38,256.36,266.61,276.87]
["Pascale","Besnard","Différence",439,1.42,623.38,{"$f":"F263*0.16","v":99.740800000000007},{"$f":"ROUND(F263+G263,2)","v":723.12},264.8,264.8,264.8]
["Françoise","Raimond","Plénitude",443,0.59,{"$f":"D264*E264","v":261.37},41.819200000000002,303.19,267.22000000000003,277.11,247.42]
["Pascale","Ferraiuolo","Essentiel",1782,2.66,4740.12,758.41920000000005,5498.54,1074.9000000000001,1114.71,1154.52]
["Amélie","Abaroudi","Initiale",427,0.59,251.92999999999998,40.308799999999998,292.24,257.57,238.49,248.03]
["Caroline","Meneguzzer","Initiale",1984,3.18,6309.12,1009.4592,7318.58,1150.72,1150.72,1150.72]
["Isabelle","Legoff","Essentiel",971,0.5,485.5,77.680000000000007,563.17999999999995,563.17999999999995,563.17999999999995,563.17999999999995]
["Catherine","Maze","Initiale",449,0.74,332.26,53.1616,385.42,260.42,260.42,260.42]
["Henri","Neuer","Essentiel",1501,1.7,2551.6999999999998,408.27199999999999,2959.97,1897.86,1514.96,1581.55]
["Chrystelle","Golwasser","Essentiel",458,0.55000000000000004,251.90000000000003,40.304000000000009,292.2,350.64,279.5,289.66000000000003]
["Gilles","Onillon","Plénitude",594,0.5,297,47.52,344.52,1364.3,1429.89,1239.68]
["Isabelle","Kilbrai","Initiale",1502,0.5,751,120.16,871.16,3205.87,0,0]
["Melissa","Benregreg","Différence",414,2.0099999999999998,832.13999999999987,133.14239999999998,965.28,264.13,264.13,274.7]
["Nathalie","Kynigopoulos","Plénitude",1177,0.5,588.5,94.16,682.66,3659.06,3847.51,3344.98]
["Virginie","Bonomo","Essentiel",682,1.71,1166.22,186.59520000000001,1352.82,1613.88,1402.72,1470.6]
["Muriel","Jacquenod","Initiale",1485,0.5,742.5,118.8,861.3,4237.6000000000004,4451.12,3547.75]
["Enzo","Gay","Différence",385,0.56999999999999995,219.45,35.112000000000002,254.56,1263.8800000000001,1094.33,950.48]
["Céline","Charlet","Différence",576,0.59,339.84,54.374399999999994,394.21,1550.13,1626.37,1410.37]
["Sébastien","Guespereau","Initiale",1306,0.5,653,104.48,757.48,3423.81,2739.05,2872.2]
["Adam","Ricard","Différence",425,0.51,216.75,34.68,251.43,813.45,705.3,564.24]
["François","Tremion","Plénitude",416,0.56999999999999995,237.11999999999998,37.9392,275.06,1380.12,1101.68,1156.1500000000001]
["Joanna","Traeger","Initiale",451,0.69,311.19,49.790399999999998,360.98,1402.07,1471.68,1277.77]
["Mandy","Martini","Essentiel",1118,0.5,559,89.44,648.44000000000005,868.91,913.85,958.8]
["Alice","Wolff","Initiale",433,0.72,311.76,49.881599999999999,361.64,1326.02,1393.04,1464.84]
["Alice","Alliez","Initiale",448,0.75,336,53.76,389.76,789.91,825.82,658.26]
["Chantal","Cerutti","Plénitude",389,2.68,1042.52,166.8032,1209.32,1507.14,1586.17,1377.31]
["Séverine","Iisaka","Différence",1192,0.5,596,95.36,691.36,2129.39,1840.21,1932.22]
["Sylvie","Ikeda","Différence",409,0.71,290.39,46.462399999999995,336.85,645.24,514.39,541.46]
["Antoine","Linares","Essentiel",420,0.66,277.2,44.351999999999997,321.55,1052.3499999999999,913.27,727.84]
["Paul","Laurent","Essentiel",865,1.54,1332.1000000000001,213.13600000000002,1545.24,1806.12,1567.22,0]
["Sandra","Djadli","Différence",622,3.02,1878.44,300.55040000000002,2178.9899999999998,2020.26,1614.83,1401.81]
["Ulrich","Dobrikova","Différence",404,0.5,202,32.32,234.32,759.2,607.36,638.62]
["Laurie","Picard","Différence",420,1.58,663.6,106.176,769.78,1179.02,942.29,988.71]
["Sébastien","Oudart","Plénitude",385,0.56000000000000005,215.60000000000002,34.496000000000002,250.1,419.8,440.54,378.34]
["Laurence","Le-Goff","Différence",428,1.61,689.08,110.25280000000001,799.33,471.66,495.24,518.82000000000005]
["Angélique","Blacque","Plénitude",521,1.84,958.64,153.38239999999999,1112.02,924.67,736.96,771.72]
["Louis","Brisebarre","Plénitude",465,0.5,232.5,37.200000000000003,269.7,782.13,823.29,864.46]
["Marie-Cécile","Lemaitre","Plénitude",1274,0.5,637,101.92,738.92,4684.75,4925.47,3925.56]
["Marie","De-Stefano","Initiale",1792,1.07,1917.44,306.79040000000003,2224.23,5654.12,4902.87,4250.47]
["Alain","Leigh","Différence",419,0.5,209.5,33.520000000000003,243.02,923.48,968.25,1018.62]
["Claudine","Rugel","Essentiel",443,0.57999999999999996,256.94,41.110399999999998,298.05,842.76,670.65,700.32]
["Marie-Francçoise","Birkel","Essentiel",458,0.63,288.54000000000002,46.166400000000003,334.71,1269.76,1011.76,1062.3499999999999]
["Chrystelle","Tugaut","Plénitude",1176,0.5,588,94.08,682.08,2360,1888,0]
["Carole","Ribeiro","Essentiel",512,2.19,1121.28,179.40479999999999,1300.68,1015.6,1066.3800000000001,0]
["Tiffany","Vix","Essentiel",531,0.7,371.7,59.472000000000001,431.17,1398.23,1112.4000000000001,1166.48]
["Aude","Huard","Plénitude",428,0.6,256.8,41.088000000000001,297.89,948.28,820.9,863.36]
["Béatrice","Straughan","Différence",946,0.55000000000000004,520.30000000000007,83.248000000000019,603.54999999999995,2381.27,2506.6,2631.93]
["Florence","Leguil","Initiale",817,0.73,596.41,95.425600000000003,691.84,2805.25,2234.69,0]
["Liv","Mention","Initiale",1557,3.09,4811.13,769.7808,5580.91,2655,2792.92,2930.84]
["Aurelie","Boulanger","Différence",836,0.5,418,66.88,484.88,1086.1300000000001,863.34,900.47]
["Deborah","Shefras","Initiale",646,0.5,323,51.68,374.68,591.99,513.54,534.92999999999995]
["Catherine","Martins","Plénitude",1779,0.5,889.5,142.32,1031.82,4147.92,3597.48,3774.41]
["Maud","Dumas","Différence",424,0.78,330.72,52.915200000000006,383.64,1288.6199999999999,1356.44,1424.27]
["Virginie","Dornier","Plénitude",894,0.69,616.8599999999999,98.69759999999998,715.56,1462.23,1165.83,1225.1099999999999]
["Sabrina","Cocolaras","Différence",654,0.64,418.56,66.9696,485.53,379.32,364.73,379.32]
["Kelly","Maltere","Initiale",1593,0.5,796.5,127.44,923.94,3843.59,4037.53,3226.5]
["Estelle","Brochard","Différence",865,0.94,813.09999999999991,130.09599999999998,943.2,1204.08,1041.03,1091.2]
["Sophie","Guemene","Initiale",1719,0.5,859.5,137.52000000000001,997.02,2612.19,2745.66,2383.39]
["Jean-Luc","Lucchini","Initiale",456,0.5,228,36.480000000000004,264.48,650.62,680.88,716.19]
["Stéphanie","Nigg","Différence",458,0.56999999999999995,261.06,41.769600000000004,302.83,1540.71,1621.54,1702.36]
["Jean-Claude","Champion","Initiale",507,0.6,304.2,48.671999999999997,352.87,1711.43,1800.92,1890.4]
["Stephen","Conte","Différence",873,0.55000000000000004,480.15000000000003,76.824000000000012,556.97,2065.87,1650.76,1737.65]
["Bearice","Zeitoun","Différence",1855,0.5,927.5,148.4,1075.9000000000001,4497.26,3904.44,4108.8599999999997]
["Jérôme","Garke","Initiale",704,0.65,457.6,73.216000000000008,530.82000000000005,743.14,639.66999999999996,667.89]
["Lucie","Projetti","Différence",1785,0.56000000000000005,999.60000000000014,159.93600000000004,1159.54,5217.91,5480,5765.91]
["Lucie","Priou","Plénitude",1500,2.84,4260,{"$f":"F327*0.16","v":681.6},{"$f":"ROUND(F327+G327,2)","v":4941.6000000000004},3828,4026.86,4225.71]
["Céline","Parmentier","Plénitude",386,1.31,{"$f":"D328*E328","v":505.66},80.905600000000007,586.57000000000005,465.67,487.03,388.77]
["Pascale","Brunet","Essentiel",1589,1,1589,254.24,1843.24,4810.8599999999997,0,0]
["Jennifer","Bouclaud","Initiale",429,2.77,1188.33,190.1328,1378.46,985.33,854.37,898.02]
["Michèle","Edmuads","Plénitude",717,0.94,673.98,107.83680000000001,781.82,1497.1,1196.0899999999999,1037.67]
["Aurore","Boillaut","Initiale",446,0.5,223,35.68,258.68,1107.1500000000001,959.53,831.59]
["Elisabeth","Christophe","Essentiel",583,0.52,303.16000000000003,48.505600000000008,351.67,1961.21,2064.1,2166.98]
["Véronique","Martinez","Initiale",400,0.61,244,39.04,283.04000000000002,844.48,672.05,707.42]
["Cécile","Crocker","Essentiel",437,0.68,297.16000000000003,47.545600000000007,344.71,1079.74,1132.76,1190.6099999999999]
["Céline","Dallara","Plénitude",422,0.53,223.66000000000003,35.785600000000002,259.45,655.96,521.04,414.04]
["Annie","Rodrigues","Initiale",603,0.5,301.5,48.24,349.74,2273.31,1818.65,1906.08]
["Véronique","Bouvet","Initiale",424,0.59,250.16,40.025599999999997,290.19,983.68,786.94,627.67999999999995]
["Laurence","Elard","Différence",835,0.77,642.95000000000005,102.87200000000001,745.82,2334.33,2029.85,1762.28]
["Delphine","Haberkorn","Plénitude",388,0.64,248.32,39.731200000000001,288.05,1224.22,1288.42,1117.21]
["Thierry","Wicander","Initiale",434,0.51,221.34,35.414400000000001,256.75,271.86,282.73,293.61]
["Agnès","Letessier","Initiale",1092,0.5,546,87.36,633.36,3635.49,3825.99,4016.5]
["Nicole","Thuot-Tavernier","Initiale",414,2.97,1229.5800000000002,196.73280000000003,1426.31,1704.85,1791.69,1430.61]
["Christine","Gibert","Initiale",450,2.36,1062,169.92000000000002,1231.92,715.14,749.9,595.95000000000005]
["Barbara","Voges","Initiale",447,0.7,312.89999999999998,50.064,362.96,782.97,818.83,651.47]
["Michèle","Samson","Initiale",870,0.71,617.69999999999993,98.831999999999994,716.53,2331.25,1861.16,1957.1]
["Michèle","Wilhelm","Différence",396,0.57999999999999996,229.67999999999998,36.748799999999996,266.43,289.39999999999998,302.55,315.70999999999998]
["Marie-Pierre","Bouchy","Différence",406,0.73,296.38,47.4208,343.8,1229.21,1288.3,1353.31]
["Estelle","Duparcq","Initiale",445,2.0299999999999998,903.34999999999991,144.536,1047.8900000000001,991.1,1042.93,1094.75]
["Martine","Marie-Chantal","Initiale",1310,0.5,655,104.8,759.8,1869.11,0,0]
["Anne","Hedin","Initiale",399,2.52,1005.48,160.8768,1166.3599999999999,712.77,567.58000000000004,492.78]
["Joanne","Rouillard","Différence",627,2.79,1749.33,279.89280000000002,2029.22,1527.37,1216.8599999999999,1057.4100000000001]
["Lucienne","Pennetier","Initiale",401,1.89,757.89,121.2624,879.15,1330.36,1396.65,1467.37]
["Melody","Curti","Plénitude",419,0.52,217.88,34.860799999999998,252.74,520.05999999999995,543.28,571.14]
["Laure","Orth","Initiale",398,1.58,628.84,100.6144,729.45,1094.18,1146.29,1204.18]
["Pascale","Blondeau","Différence",1346,2.72,3661.1200000000003,585.77920000000006,4246.8999999999996,1795.56,1873.63,1971.22]
["Sophie","Alexandre","Différence",407,0.71,288.96999999999997,46.235199999999999,335.21,1647.7,1729.27,1816.28]
["Geraldine","Rodriguez","Initiale",927,0.64,593.28,94.924799999999991,688.2,2516.25,2638.99,2107.1]
["Martine","Adeline","Différence",448,0.51,228.48000000000002,36.556800000000003,265.04000000000002,1439.51,1513.72,1315.84]
["Valérie","Sow","Essentiel",1249,1.9,2373.1,379.69599999999997,2752.8,1897.98,1994.96,1593.2]
["Eva","Sylvain","Différence",1755,0.5,877.5,140.4,1017.9,5333.8,4267.04,0]
["Sandrine","Passier","Différence",385,1.55,596.75,95.48,692.23,625.24,496.84,519.16999999999996]
["Sonia","De-Fontenay","Essentiel",966,0.93,898.38,143.74080000000001,1042.1199999999999,2173.89,2280.4499999999998,2397.67]
["Marie","Maurice","Plénitude",444,0.72,319.68,51.148800000000001,370.83,582,503.08,399.51]
["Evelyne","Parsons","Différence",611,1.93,1179.23,188.67680000000001,1367.91,1233.24,1290.4100000000001,1029.06]
["Michèle","Fink-Mathieu","Différence",421,0.61,256.81,41.089600000000004,297.89999999999998,849.75,891.54,937.97]
["Jeanne","Blum","Initiale",1643,3.41,5602.63,896.42079999999999,6499.05,1219.76,1195.8499999999999,1195.8499999999999]
["Valentine","Salguero","Différence",387,0.52,201.24,32.198399999999999,233.44,350.16,277.56,239.13]
["Benjamin","Parmentier","Essentiel",446,1.08,481.68,77.068799999999996,558.75,724.3,758.79,655.32000000000005]
["Elise","Baudet","Différence",1857,0.5,928.5,148.56,1077.06,2391.0700000000002,1896.37,1504.73]
["Philippe","Contet","Différence",406,1.38,560.28,89.644800000000004,649.91999999999996,1186.82,1030.07,1083.81]
["Oona","Gautier","Essentiel",1407,2.06,2898.42,463.74720000000002,3362.17,2709.32,2849.46,0]
["Christine","Germaine","Plénitude",423,0.61,258.02999999999997,41.284799999999997,299.31,706.58,743.44,780.31]
["Jane","Schmid","Différence",474,0.77,364.98,58.396800000000006,423.38,769.78,804.14,639.19000000000005]
["Jociane","Baud-Lavigne","Différence",405,1.33,538.65,86.183999999999997,624.83000000000004,436.91,459.44,481.96]
["Sophie","Mikailoff","Initiale",739,0.5,369.5,59.120000000000005,428.62,1611.61,1690.71,1463.3]
["Lee","Claude","Différence",456,0.72,328.32,52.531199999999998,380.85,327.96,343.09,358.23]

{"sheet":"tableauDeBord","index":4,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Statistiques sur la mise en place de la tarification jeune conducteur"]
[]
[]
["évolution de la répartition des primes par type de contrat"]
[null,2019,2018,2017,2016]
["Initiale",{"$f":"SUMIFS(etatDesPrimes!H$6:H$377,etatDesPrimes!$C$6:$C$377,tableauDeBord!$A6)","v":127792.18000000004},{"$f":"SUMIFS(etatDesPrimes!I$6:I$377,etatDesPrimes!$C$6:$C$377,tableauDeBord!$A6)","v":111880.83999999998},{"$f":"SUMIFS(etatDesPrimes!J$6:J$377,etatDesPrimes!$C$6:$C$377,tableauDeBord!$A6)","v":103458.59999999999},{"$f":"SUMIFS(etatDesPrimes!K$6:K$377,etatDesPrimes!$C$6:$C$377,tableauDeBord!$A6)","v":95961.39999999998}]
["Essentiel",{"$f":"SUMIFS(etatDesPrimes!H$6:H$377,etatDesPrimes!$C$6:$C$377,tableauDeBord!$A7)","v":87269.280000000013},{"$f":"SUMIFS(etatDesPrimes!I$6:I$377,etatDesPrimes!$C$6:$C$377,tableauDeBord!$A7)","v":64281.280000000006},{"$f":"SUMIFS(etatDesPrimes!J$6:J$377,etatDesPrimes!$C$6:$C$377,tableauDeBord!$A7)","v":58364.899999999987},{"$f":"SUMIFS(etatDesPrimes!K$6:K$377,etatDesPrimes!$C$6:$C$377,tableauDeBord!$A7)","v":52450.19}]
["Différence",{"$f":"SUMIFS(etatDesPrimes!H$6:H$377,etatDesPrimes!$C$6:$C$377,tableauDeBord!$A8)","v":72278.920000000013},{"$f":"SUMIFS(etatDesPrimes!I$6:I$377,etatDesPrimes!$C$6:$C$377,tableauDeBord!$A8)","v":85204.060000000027},{"$f":"SUMIFS(etatDesPrimes!J$6:J$377,etatDesPrimes!$C$6:$C$377,tableauDeBord!$A8)","v":80090.579999999987},{"$f":"SUMIFS(etatDesPrimes!K$6:K$377,etatDesPrimes!$C$6:$C$377,tableauDeBord!$A8)","v":74393.91}]
["Plénitude",{"$f":"SUMIFS(etatDesPrimes!H$6:H$377,etatDesPrimes!$C$6:$C$377,tableauDeBord!$A9)","v":58769.32999999998},{"$f":"SUMIFS(etatDesPrimes!I$6:I$377,etatDesPrimes!$C$6:$C$377,tableauDeBord!$A9)","v":58072.040000000008},{"$f":"SUMIFS(etatDesPrimes!J$6:J$377,etatDesPrimes!$C$6:$C$377,tableauDeBord!$A9)","v":56305.840000000011},{"$f":"SUMIFS(etatDesPrimes!K$6:K$377,etatDesPrimes!$C$6:$C$377,tableauDeBord!$A9)","v":48817.969999999994}]
["Total primes",{"$f":"SUM(B6:B9)","v":346109.71},{"$f":"SUM(C6:C9)","v":319438.22000000003},298219.92,271623.46999999997]

{"sheet":"jeuneConducteur","index":5,"n_rows":377,"n_cols":11,"rows_kept":377,"cut":false,"hidden":false,"merged":[]}
["Mise en place de la tarification jeune conducteur"]
[]
["Année",2019]
[null,null,null,null,null,null,null,null,"Sinistres","Surprime"]
["nom","prénom","Type contrat","Prime de \nbase","Année du \npermis","1er contrat \n(O/N)","Formation anticipée (O/N)","Année ouverture contrat",2018,2018,{"$f":"B3","v":2019}]
["Lamiaux","Karine","Essentiel",500,2016,"O","n",2018,0,{"$f":"surprime($D6,$G6,J$5,$H6)","v":1000},{"$f":"surprime(D6,G6,K$5,$H6,I6)","v":750}]
["Brossillon","Frederique","Différence",869,2016,"O","O",2018,0,{"$f":"surprime($D7,$G7,J$5,$H7)","v":1303.5},{"$f":"surprime(D7,G7,K$5,$H7,I7)","v":1086.25}]
["Barat","René","Essentiel",765,2017,"O","N",2018,1,1530,1530]
["Faure","Colette","Initiale",638,2019,"O","O",2019,0,0,957]
["Longeat","Carine","Différence",541,2017,"O","O",2019,0,0,811.5]
["Durupt","Marie Laure","Plénitude",590,2017,"N","O",2018,0,885,737.5]
["Meneroud","Yann","Différence",563,2018,"O","N",2018,0,1126,844.5]
["Emeric","Michel","Essentiel",571,2016,"O","O",2018,0,856.5,713.75]
["Fehmi","Chakib","Initiale",506,2017,"O","O",2018,1,759,759]
["Ferre","Emmanuel","Initiale",754,2019,"O","O",2019,0,0,1131]
["Miler","Gloria","Initiale",938,2016,"O","O",2018,0,1407,1172.5]
["Rigaud","Jean francois","Différence",564,2019,"O","O",2018,0,846,705]
["Gelpe","Martine","Essentiel",700.6,2018,"N","O",2018,0,1050.9000000000001,875.75]
["Perrault","Christine","Plénitude",1665.4,2016,"O","N",2018,0,3330.8,2498.1000000000004]
["Genest","Marie therese","Initiale",832,2016,"O","O",2018,0,1248,1040]
["Baba","Martine","Différence",1300.25,2016,"O","O",2018,0,1950.375,1625.3125]
["Barat","Nicole","Initiale",833,2018,"O","O",2018,0,1249.5,1041.25]
["Coste","Laurent","Différence",1389.5,2017,"O","N",2018,0,2779,2084.25]
["Meyer","Denis","Initiale",572,2019,"O","O",2019,0,0,858]
["Chanac","Sylvie","Essentiel",672.08,2016,"O","O",2018,0,1008.1200000000001,840.1]
["Marquette","Lucien","Essentiel",872.96,2018,"O","N",2018,0,1745.92,1309.44]
["Masina","Mohamed","Différence",889,2016,"O","O",2018,0,1333.5,1111.25]
["Verdier","Philippe","Différence",894.25,2016,"O","O",2018,0,1341.375,1117.8125]
["Foulon","Monique","Initiale",716,2017,"O","O",2018,0,1074,895]
["Del cuerpo","Daniele","Initiale",927,2018,"O","O",2018,0,1390.5,1158.75]
["Catala","Carole","Initiale",922,2018,"O","O",2018,0,1383,1152.5]
["Dierstein","Anna","Plénitude",2087.8000000000002,2018,"O","O",2018,1,3131.7000000000003,3131.7000000000003]
["Le morvan","Pascale","Initiale",891,2016,"O","O",2018,0,1336.5,1113.75]
["Polidori","Francoise","Différence",1557.5,2016,"O","O",2018,0,2336.25,1946.875]
["Blanc","Marie therese","Initiale",588,2018,"O","O",2018,0,882,735]
["Tardy","Jean michel","Essentiel",815.92,2016,"O","N",2018,0,1631.84,1223.8799999999999]
["Enger","Michel","Plénitude",1940.4,2018,"O","O",2018,0,2910.6000000000004,2425.5]
["Badefort","Elmostafa","Plénitude",1218.8000000000002,2016,"O","O",2018,0,1828.1999999999998,1523.5]
["Herviou","Anne","Plénitude",1326.6000000000001,2017,"O","N",2018,0,2653.2,1989.8999999999999]
["Trassoudaine","Thi thu huong","Différence",973,2016,"O","O",2018,0,1459.5,1216.25]
["Samkawi","Sylvia","Essentiel",1147,2016,"O","O",2018,0,1720.5,1433.75]
["Parazols","Raymond","Essentiel",696.88,2018,"O","O",2018,0,1045.32,871.1]
["Gaillard","Michele","Différence",1055.25,2018,"O","O",2018,0,1582.875,1319.0625]
["Martory","Christiane","Initiale",928,2016,"O","N",2018,0,1856,1392]
["Seffar","Bernadette","Différence",1352.75,2019,"O","N",2019,0,0,2705.5]
["Talbart","Stephane","Initiale",798,2018,"N","O",2018,0,1197,997.5]
["Pasquereau","Jean luc","Essentiel",620,2017,"O","O",2018,0,930,775]
["Poire","Thierry","Initiale",945,2017,"O","O",2018,1,1417.5,1417.5]
["Melloul","Pascale","Différence",955.5,2016,"O","O",2018,0,1433.25,1194.375]
["Cherubin","Anna","Initiale",776,2016,"O","O",2018,0,1164,970]
["Sardi","Robert","Initiale",915,2018,"O","O",2018,0,1372.5,1143.75]
["Departout","Francois","Essentiel",716.72,2016,"O","N",2018,0,1433.44,1075.08]
["Decourtray","Annick","Initiale",684,2016,"O","O",2018,1,1026,1026]
["Gosselet","Bernard","Essentiel",947.36,2018,"N","O",2018,0,1421.04,1184.2]
["Plegues","Nicole","Différence",1400,2019,"O","N",2019,0,0,2800]
["Thune","Sylvie","Essentiel",1050.28,2016,"O","N",2018,1,2100.56,2100.56]
["Bigarre","Nicole","Plénitude",1232,2016,"O","N",2018,1,2464,2464]
["Thoisy","Helene","Initiale",873,2019,"O","N",2019,0,0,1746]
["De simone","Micheline","Plénitude",1161.6000000000001,2016,"O","O",2018,1,1742.3999999999999,1742.3999999999999]
["Bensimon","Said","Initiale",564,2019,"O","N",2019,0,0,1128]
["Jaboin","Mahmoud","Plénitude",2090,2017,"O","O",2018,0,3135,2612.5]
["Badda","Djelil","Initiale",873,2016,"N","O",2018,0,1309.5,1091.25]
["Lenoir","Françoise","Initiale",770,2016,"O","O",2018,1,1155,1155]
["Bouland","Agnes","Initiale",608,2018,"O","N",2018,0,1216,912]
["Pico","Simon françois","Essentiel",1168.08,2017,"O","O",2018,0,1752.12,1460.1]
["Pau","Marie paule","Essentiel",974.64,2016,"O","O",2018,0,1461.96,1218.3]
["Juntas","Yves","Essentiel",835.76,2016,"O","O",2018,1,1253.6399999999999,1253.6399999999999]
["Jonon","Sophie","Différence",1279.25,2019,"N","O",2019,0,0,1918.875]
["Meneroud","Bernard ","Différence",1163.75,2017,"O","N",2018,1,2327.5,2327.5]
["Marcel","Anne marie","Essentiel",741.52,2017,"N","O",2018,1,1112.28,1112.28]
["Cron","Philippe","Plénitude",1135.2,2016,"O","N",2018,0,{"$f":"surprime($D71,$G71,J$5,$H71)","v":2270.4},{"$f":"surprime(D71,G71,K$5,$H71,I71)","v":1702.8000000000002}]
["Edme","Marie Laur","Plénitude",2013.0000000000002,2017,"O","O",2018,0,3019.5,2516.25]
["Piquerez","Michele","Initiale",848,2018,"O","N",2018,0,1696,1272]
["Le dirach","Fabienne","Plénitude",1742.4,2016,"O","O",2018,0,2613.6000000000004,2178]
["Tomeo","Daniele","Différence",1417.5,2017,"O","N",2018,0,2835,2126.25]
["Rakotoarivony","Marie pierre","Différence",936.25,2016,"O","N",2018,0,1872.5,1404.375]
["Bonati","Claire","Différence",1359.75,2017,"O","O",2018,0,2039.625,1699.6875]
["Couturier","Francoise","Différence",1295,2019,"O","O",2019,0,0,1942.5]
["Kessari","Fabienne","Plénitude",1537.8000000000002,2018,"N","O",2018,0,2306.6999999999998,1922.25]
["Draux","Veronique","Plénitude",1430.0000000000002,2016,"O","O",2018,0,2145,1787.5]
["Bory","Jean louis","Initiale",817,2017,"O","O",2018,1,1225.5,1225.5]
["Monnet","Claire lise","Différence",1566.25,2016,"O","O",2018,1,2349.375,2349.375]
["Bardin","Anne","Initiale",826,2016,"O","O",2018,0,1239,1032.5]
["MELLOUL","Bernard","Essentiel",1041.5999999999999,2017,"O","O",2018,1,1562.3999999999999,1562.3999999999999]
["Hugon","Laurence","Plénitude",1278.2,2016,"O","O",2018,0,1917.3000000000002,1597.75]
["Richard","Catherine","Différence",1085,2018,"O","O",2018,0,1627.5,1356.25]
["Benaiem","Elisabeth","Initiale",617,2017,"O","O",2018,0,925.5,771.25]
["Santos","Christophe","Initiale",606,2016,"O","O",2018,1,909,909]
["Lauer","Stephane","Essentiel",717.96,2016,"O","O",2018,0,1076.94,897.45]
["Lestrade","Daniel","Initiale",521,2016,"O","O",2018,1,781.5,781.5]
["Moreau","Brigitte","Initiale",622,2019,"O","N",2019,0,0,1244]
["Durupt","Francoise","Initiale",710,2018,"O","O",2018,1,1065,1065]
["Parmentier","Annie","Essentiel",1094.92,2016,"O","O",2018,0,1642.38,1368.65]
["Legars","Claire","Essentiel",1062.68,2018,"O","O",2018,0,1594.02,1328.3500000000001]
["Brahmi","Anne marie","Essentiel",983.31999999999994,2017,"O","O",2018,0,1474.98,1229.1500000000001]
["Hourdeaux","Jean jacques","Initiale",754,2016,"O","N",2018,0,1508,1131]
["Mao","Stephanie","Initiale",793,2019,"O","O",2019,0,0,1189.5]
["Sigalas","Musiliu","Différence",1211,2019,"N","O",2019,0,0,1816.5]
["Larive","Dominique","Initiale",646,2016,"O","O",2018,1,969,969]
["Poncelet","Natacha","Initiale",675,2018,"O","N",2018,0,1350,1012.5]
["Hiault","Jean marc","Initiale",634,2018,"O","O",2018,0,951,792.5]
["Vujisic","Christine","Différence",1354.5,2016,"N","O",2018,0,2031.75,1693.125]
["Wos","Claude","Différence",1149.75,2016,"O","O",2018,0,1724.625,1437.1875]
["Sebbar","Ouiza","Initiale",512,2016,"O","O",2018,0,768,640]
["Rosenfeld","Pascal","Initiale",901,2019,"O","O",2019,0,0,1351.5]
["Nguyen","Elisabeth","Initiale",566,2018,"O","O",2018,1,849,849]
["Lordinot","Carine","Initiale",912,2017,"O","N",2018,0,1824,1368]
["Narcy pozzoli","Marie jose","Initiale",824,2016,"O","O",2018,0,1236,1030]
["Jacob","Laurent","Différence",1400,2017,"O","N",2018,0,2800,2100]
["Tran haury","Catherine","Initiale",618,2017,"O","O",2018,0,927,772.5]
["Ziesel","Sonia","Plénitude",2054.8000000000002,2018,"O","N",2018,0,4109.6000000000004,3082.2000000000003]
["Kebci","Xavier","Initiale",715,2016,"O","O",2018,0,1072.5,893.75]
["Delamain","Guy","Essentiel",735.32,2018,"O","O",2018,0,1102.98,919.15000000000009]
["Albert","Dominique","Plénitude",1243,2018,"N","O",2018,0,1864.5,1553.75]
["Lichter","Jean marc","Essentiel",1143.28,2016,"O","O",2018,0,1714.92,1429.1]
["Rouveau","Nicole","Différence",1083.25,2017,"O","O",2018,1,1624.875,1624.875]
["Barounas","Anne","Différence",1631,2018,"O","O",2018,0,2446.5,2038.75]
["Rolle","Martine","Initiale",529,2018,"O","N",2018,0,1058,793.5]
["Ognibene","Gregori","Initiale",645,2018,"O","O",2018,0,967.5,806.25]
["Thery","Catherine","Initiale",644,2016,"N","O",2018,0,966,805]
["Lalouani","Daniel","Plénitude",2017.4,2018,"O","N",2018,0,4034.8,3026.1000000000004]
["Santacruz","Jocelyne","Initiale",592,2017,"O","N",2018,0,1184,888]
["Moyer","Frédéric","Plénitude",1194.6000000000001,2016,"N","O",2018,1,1791.8999999999999,1791.8999999999999]
["Ranchin","Jean luc","Initiale",940,2017,"N","O",2018,1,1410,1410]
["Vincent genod","Michel","Initiale",785,2017,"O","O",2018,0,1177.5,981.25]
["Sansot","Anne marie","Plénitude",2017.4,2016,"O","O",2018,0,3026.1000000000004,2521.75]
["Coille","Daniel","Initiale",903,2018,"N","O",2018,0,1354.5,1128.75]
["De march","Marie pierre","Plénitude",1894.2,2016,"O","O",2018,0,2841.3,2367.75]
["Calendini","Danielle","Essentiel",1129.6400000000001,2018,"O","O",2018,0,1694.46,1412.0500000000002]
["Durafour","Laurence","Initiale",579,2016,"O","O",2018,0,868.5,723.75]
["Bot","Jean pierre","Initiale",545,2017,"N","O",2018,0,817.5,681.25]
["Mouysset","Bernard","Initiale",511,2018,"N","O",2018,1,766.5,766.5]
["Bersillon","Eliane","Initiale",761,2018,"O","O",2018,0,1141.5,951.25]
["Robert","Jean Francois","Plénitude",1918.4,2016,"O","N",2018,0,3836.8,2877.6000000000004]
["Le gouguec","Stéphane","Initiale",900,2018,"O","O",2018,0,{"$f":"surprime($D135,$G135,J$5,$H135)","v":1350},{"$f":"surprime(D135,G135,K$5,$H135,I135)","v":1125}]
["Grosjean","Jean luc","Initiale",823,2018,"N","O",2018,0,1234.5,1028.75]
["Jarry","Marina","Plénitude",1639.0000000000002,2017,"O","O",2018,0,2458.5,2048.75]
["Brossillon","Philippe","Initiale",519,2017,"O","O",2018,0,778.5,648.75]
["Berger jacob","Janine","Essentiel",828.32,2018,"O","O",2018,0,1242.48,1035.4000000000001]
["Marty","Guylene","Essentiel",721.68,2017,"O","O",2018,0,1082.52,902.09999999999991]
["Dalle","Fabrice","Plénitude",1731.4,2018,"O","O",2018,0,2597.1000000000004,2164.25]
["Bernard","Carole","Essentiel",884.12,2016,"O","O",2018,1,1326.18,1326.18]
["Eleouet","Marc henri","Initiale",592,2016,"O","O",2018,1,888,888]
["Azan couturier","Serge","Initiale",711,2016,"O","O",2018,0,1066.5,888.75]
["Saraf","Marie therese","Différence",1211,2017,"O","O",2018,0,1816.5,1513.75]
["Jandin","Gregoire","Initiale",601,2016,"O","N",2018,0,1202,901.5]
["Liegeois","Francine","Différence",889,2019,"O","O",2019,0,0,1333.5]
["Gandouin","Gerard","Plénitude",1445.4,2016,"O","O",2018,0,2168.1000000000004,1806.75]
["Aranguren","Emmanuel","Essentiel",872.96,2019,"O","O",2019,0,0,1309.44]
["Varley","Sophia","Essentiel",899,2017,"O","O",2018,0,1348.5,1123.75]
["Dib","Georges","Essentiel",896.52,2017,"O","O",2018,0,1344.78,1120.6500000000001]
["Minialai","Gloria","Essentiel",956.04,2017,"O","O",2018,0,1434.06,1195.05]
["Mallais","Marie christine","Initiale",559,2019,"O","O",2019,0,0,838.5]
["Viel","Monique","Essentiel",1077.56,2019,"N","O",2019,0,0,1616.34]
["Lenoir","Denise","Initiale",730,2016,"O","O",2018,0,1095,912.5]
["Verre","François marie","Essentiel",951.08,2018,"O","O",2018,0,1426.6200000000001,1188.8500000000001]
["Lucas","Philippe","Essentiel",996.96,2018,"O","O",2018,0,1495.44,1246.2]
["George","Christine","Différence",1407,2016,"O","O",2018,0,2110.5,1758.75]
["Coucoureux","Olivier","Initiale",915,2019,"O","N",2019,0,0,1830]
["Kopel","Bekai","Initiale",798,2018,"O","O",2018,1,1197,1197]
["Rouillon","Bertrand","Différence",1555.75,2016,"N","O",2018,1,2333.625,2333.625]
["Mege","Mohamed","Plénitude",1766.6000000000001,2016,"O","N",2018,0,3533.2,2649.8999999999996]
["Messaoudene","Anne","Essentiel",899,2018,"O","O",2018,0,1348.5,1123.75]
["Adam","Vincent","Essentiel",655.96,2017,"N","O",2018,0,983.94,819.95]
["Kornman","Gilberte","Différence",1473.5,2018,"O","N",2018,0,2947,2210.25]
["Thurel","Monique","Initiale",508,2019,"O","O",2019,0,0,762]
["Assako","Eva","Différence",1545.25,2016,"O","O",2018,0,2317.875,1931.5625]
["Cohen","Laurent","Essentiel",809.72,2018,"O","O",2018,0,1214.58,1012.1500000000001]
["Faustin","Monique","Plénitude",1680.8000000000002,2016,"O","O",2018,0,2521.1999999999998,2101]
["Pageot","Laurent","Essentiel",1050.28,2016,"N","O",2018,0,1575.42,1312.85]
["Hidouche","Isabelle","Essentiel",1151.96,2016,"O","N",2018,0,2303.92,1727.94]
["Coulomb stiegler","Michel","Initiale",823,2016,"O","O",2018,0,1234.5,1028.75]
["Lemaire","Rémy","Différence",1239,2017,"N","O",2018,1,1858.5,1858.5]
["Allemand","Azzedine","Différence",1662.5,2017,"N","O",2018,0,2493.75,2078.125]
["Reymann","Pascale","Initiale",551,2017,"O","O",2018,0,826.5,688.75]
["Genesco","Nathalie","Initiale",810,2018,"O","O",2018,1,1215,1215]
["Kolli","Pascal","Essentiel",1075.08,2017,"O","O",2018,0,1612.62,1343.85]
["Doucet","Rachid","Différence",1342.25,2016,"O","O",2018,0,2013.375,1677.8125]
["Faussey","Colette","Essentiel",778.72,2016,"O","O",2018,0,1168.08,973.40000000000009]
["Ismail","Daniel","Plénitude",1284.8000000000002,2018,"O","O",2018,0,1927.1999999999998,1606]
["Bourassin","Jocelyne","Initiale",548,2019,"O","O",2019,0,0,822]
["Novak","David","Plénitude",1315.6000000000001,2016,"O","O",2018,0,1973.3999999999999,1644.5]
["Dubault","Christian","Plénitude",2090,2019,"N","O",2019,0,0,3135]
["Shiro","Geneviève","Plénitude",1518.0000000000002,2017,"O","O",2018,0,2277,1897.5]
["De vallois","Corinne","Initiale",536,2016,"N","O",2018,0,804,670]
["Marzougui","Valerie","Initiale",942,2017,"O","O",2018,0,1413,1177.5]
["Bride","Hélène","Différence",1359.75,2016,"O","O",2018,0,2039.625,1699.6875]
["Benaissa","Josette","Essentiel",747.72,2018,"O","O",2018,1,1121.58,1121.58]
["Le rouzic","Roland","Essentiel",1001.92,2016,"N","O",2018,0,1502.8799999999999,1252.3999999999999]
["Revault","Marie odile","Différence",1013.25,2018,"O","O",2018,0,1519.875,1266.5625]
["Maviel","Valerie","Plénitude",1122,2016,"O","O",2018,1,1683,1683]
["Blandin","Karine","Initiale",877,2016,"O","O",2018,0,1315.5,1096.25]
["Aupetit","Jean noël","Initiale",707,2019,"O","O",2019,0,0,1060.5]
["Le moigne","Marie francoise","Essentiel",717.96,2018,"O","O",2018,0,1076.94,897.45]
["Fau","Philippe","Essentiel",1116,2017,"O","O",2018,0,1674,1395]
["Naim","Frédéric","Plénitude",1848.0000000000002,2017,"O","O",2018,0,2772,2310]
["Kirchhofer","Cécile","Initiale",647,2018,"O","O",2018,0,970.5,808.75]
["Daubigney","Beatrice","Essentiel",779.96,2018,"O","O",2018,0,1169.94,974.95]
["Condette","Brigitte","Initiale",782,2018,"O","N",2018,0,{"$f":"surprime($D199,$G199,J$5,$H199)","v":1564},{"$f":"surprime(D199,G199,K$5,$H199,I199)","v":1173}]
["Meunier","Jelloul","Différence",1079.75,2018,"N","O",2018,0,1619.625,1349.6875]
["Blondel lawlor","Sylviane","Plénitude",1276,2018,"O","O",2018,0,1914,1595]
["LEGRAS","Remi","Différence",1286.25,2017,"O","O",2018,1,1929.375,1929.375]
["Topolinski","Patrick","Initiale",937,2016,"N","O",2018,0,1405.5,1171.25]
["Braun","Paul","Essentiel",1124.68,2016,"N","O",2018,0,1687.02,1405.8500000000001]
["Blocus","Jacques","Essentiel",782.43999999999994,2018,"N","O",2018,0,1173.6600000000001,978.05000000000007]
["Martin","Philippe","Différence",1134,2019,"O","O",2019,0,0,1701]
["Kalinski","Michel","Essentiel",953.56,2019,"O","O",2019,0,0,1430.34]
["Jacquart","Pierre","Initiale",503,2017,"N","O",2018,0,754.5,628.75]
["Siroen","Pierre","Plénitude",1720.4,2017,"O","N",2018,1,3440.8,3440.8]
["Nativel","Patricia","Initiale",776,2016,"O","O",2018,0,1164,970]
["Boucher","Danielle","Essentiel",1054,2016,"O","O",2018,0,1581,1317.5]
["Godard","Nathalie","Différence",1590.75,2016,"N","O",2018,1,2386.125,2386.125]
["Diagne","Herve","Initiale",653,2018,"O","O",2018,0,979.5,816.25]
["Boquerat","Martine","Essentiel",988.28,2019,"O","O",2019,0,0,1482.42]
["Veil","Joanna","Essentiel",939.92,2016,"O","O",2018,0,1409.8799999999999,1174.8999999999999]
["Bouffard","Anne","Initiale",566,2017,"N","O",2018,0,849,707.5]
["Percevault","Didier","Différence",1508.5,2017,"O","O",2018,0,2262.75,1885.625]
["Rodriguez","Henriette","Initiale",543,2016,"O","O",2018,0,814.5,678.75]
["Noupa","Eric","Plénitude",1570.8000000000002,2018,"O","O",2018,0,2356.1999999999998,1963.5]
["Arditti","Xavier","Différence",1029,2017,"O","O",2018,1,1543.5,1543.5]
["Hillaire","Zahia","Initiale",886,2017,"O","O",2018,0,1329,1107.5]
["Audebert","Brigitte","Plénitude",1564.2,2016,"O","O",2018,0,2346.3000000000002,1955.25]
["Lechat","Florence","Plénitude",1513.6000000000001,2019,"O","O",2019,0,0,2270.3999999999996]
["Boschat","Marie noelle","Initiale",579,2017,"N","O",2018,1,868.5,868.5]
["Mayrargue","Bruno","Initiale",632,2016,"O","O",2018,0,948,790]
["Bayemi","Jacques","Essentiel",830.8,2016,"O","O",2018,0,1246.1999999999998,1038.5]
["Desplanques","Antonio","Différence",1641.5,2016,"O","O",2018,1,2462.25,2462.25]
["Letellier","Sabine","Initiale",924,2018,"O","O",2018,0,1386,1155]
["Piacentini","Geraldine","Initiale",785,2017,"O","O",2018,0,1177.5,981.25]
["Delfino","Luc","Initiale",520,2018,"O","N",2018,0,1040,780]
["Vieillefosse","Nadine","Essentiel",1067.6400000000001,2017,"O","O",2018,0,1601.46,1334.5500000000002]
["Kebli","Nora","Plénitude",1685.2,2019,"O","O",2019,0,0,2527.8000000000002]
["Bizet","Emmanuelle","Initiale",567,2019,"O","N",2019,0,0,1134]
["Dauxais","Pierre","Initiale",621,2016,"O","N",2018,0,1242,931.5]
["Goarvot","Sylvain","Plénitude",1625.8000000000002,2016,"O","N",2018,0,3251.6,2438.6999999999998]
["Levy","Martine","Différence",1239,2017,"O","O",2018,0,1858.5,1548.75]
["Gerard","Sylvie","Initiale",930,2017,"O","O",2018,1,1395,1395]
["Margulies","Eric","Initiale",680,2019,"N","O",2019,0,0,1020]
["Ferre sentis","Chakib","Essentiel",946.12,2017,"N","O",2018,0,1419.18,1182.6500000000001]
["Chambaud","Marie hélène","Initiale",887,2017,"O","O",2018,0,1330.5,1108.75]
["Azzouz","Driss","Différence",985.25,2016,"O","O",2018,1,1477.875,1477.875]
["Soubeyrand","Daniel","Essentiel",655.96,2018,"O","N",2018,0,1311.92,983.94]
["Audebert","Bernard","Initiale",732,2018,"O","O",2018,0,1098,915]
["Kienlen","Gérard","Initiale",730,2016,"O","O",2018,0,1095,912.5]
["Charpentier","Mireille","Plénitude",1546.6000000000001,2018,"O","O",2018,1,2319.8999999999996,2319.8999999999996]
["Coanet","Muriel","Différence",1330,2018,"O","O",2018,0,1995,1662.5]
["Valverde","Lydie","Différence",946.75,2018,"O","O",2018,0,1420.125,1183.4375]
["Lamarre","Saïd","Initiale",669,2019,"O","O",2019,0,0,1003.5]
["Chambraud","Marie paule","Initiale",518,2016,"N","O",2018,0,777,647.5]
["Djouadi","Isabelle","Essentiel",1005.64,2016,"O","O",2018,1,1508.46,1508.46]
["Guerin","Martine","Plénitude",1907.4,2016,"O","O",2018,0,2861.1000000000004,2384.25]
["Trigano","Philippe","Essentiel",944.88,2016,"O","O",2018,0,1417.32,1181.0999999999999]
["Bedouet","Joseph","Initiale",573,2018,"O","O",2018,0,859.5,716.25]
["Saidou","Lydia","Initiale",661,2019,"O","O",2019,0,0,991.5]
["Louchet","Wilhem","Plénitude",1889.8000000000002,2016,"O","O",2018,0,2834.7,2362.25]
["Leroux","Dominique","Essentiel",921.32,2018,"O","N",2018,1,1842.64,1842.64]
["Chemla","Messaouda","Essentiel",1049.04,2016,"O","O",2018,0,1573.56,1311.3]
["Dramboit","Christiane","Essentiel",1147,2017,"O","O",2018,0,1720.5,1433.75]
["Mongin","Caroline","Différence",995.75,2017,"O","O",2018,0,1493.625,1244.6875]
["Fehmi","Claude","Initiale",847,2018,"O","O",2018,0,1270.5,1058.75]
["Dujardin","Yvette","Initiale",716,2016,"O","N",2018,0,1432,1074]
["Ayache","Isabelle","Plénitude",1940.4,2018,"O","N",2018,0,3880.8,2910.6000000000004]
["Jegou","Anne","Différence",983.5,2017,"O","O",2018,0,{"$f":"surprime($D263,$G263,J$5,$H263)","v":1475.25},{"$f":"surprime(D263,G263,K$5,$H263,I263)","v":1229.375}]
["Verdeil","Nicolas","Plénitude",1845.8000000000002,2018,"O","O",2018,0,2768.7,2307.25]
["Truchetti","Gilles","Essentiel",1138.32,2017,"O","O",2018,0,1707.48,1422.8999999999999]
["Theodose","Armelle","Initiale",650,2016,"O","N",2018,0,1300,975]
["Baumann","Haroun","Initiale",880,2018,"O","O",2018,1,1320,1320]
["Selles","Mustapha","Essentiel",763.84,2017,"N","O",2018,0,1145.76,954.80000000000007]
["Galliot","Marie christine","Initiale",813,2018,"N","O",2018,0,1219.5,1016.25]
["Marnef","Volona","Essentiel",679.52,2016,"N","O",2018,0,1019.28,849.4]
["Guibert","Ghislaine","Essentiel",895.28,2019,"N","O",2019,0,0,1342.92]
["Pelletier","Bernard","Plénitude",1595.0000000000002,2016,"O","O",2018,0,2392.5,1993.75]
["Poirier","Monique","Initiale",726,2019,"O","O",2019,0,0,1089]
["Cabiran","Patrice","Différence",1020.25,2018,"O","N",2018,0,2040.5,1530.375]
["Lavault","Carine","Plénitude",1520.2,2018,"O","O",2018,1,2280.3000000000002,2280.3000000000002]
["Sopel","Annette","Essentiel",693.16,2018,"N","O",2018,0,1039.74,866.44999999999993]
["Buchon","Frederique","Initiale",525,2016,"O","O",2018,0,787.5,656.25]
["Coinon","Jean claude","Différence",1048.25,2016,"O","N",2018,0,2096.5,1572.375]
["Miler","Francoise","Différence",1650.25,2019,"O","O",2019,0,0,2475.375]
["Emeric","Jeannine","Initiale",912,2017,"O","O",2018,0,1368,1140]
["Amiach","Claude","Différence",1632.75,2018,"N","O",2018,0,2449.125,2040.9375]
["Saliniere","Annie","Plénitude",1843.6000000000001,2017,"O","N",2018,0,3687.2,2765.3999999999996]
["Rameau","Davy","Initiale",728,2016,"O","N",2018,0,1456,1092]
["Nicolle","Odile","Essentiel",1109.8,2017,"O","O",2018,0,1664.6999999999998,1387.25]
["Deschamps","Bernard","Initiale",522,2017,"O","O",2018,0,783,652.5]
["Adjanouga","Nelly","Initiale",686,2016,"O","O",2018,1,1029,1029]
["Chamillard","Marie jose","Plénitude",1625.8000000000002,2016,"N","O",2018,0,2438.6999999999998,2032.25]
["Thillet","Sylvaine","Différence",1018.5,2017,"N","O",2018,0,1527.75,1273.125]
["Bouchery","Francoise","Différence",1223.25,2018,"N","O",2018,1,1834.875,1834.875]
["Wohrer","Milan","Essentiel",1056.48,2017,"O","O",2018,0,1584.72,1320.6]
["Mercier","Yann","Essentiel",808.48,2019,"O","N",2019,0,0,1616.96]
["Delacour","Chantal","Différence",1471.75,2017,"O","O",2018,0,2207.625,1839.6875]
["Tabin","Eric","Différence",1102.5,2019,"N","O",2019,0,0,1653.75]
["Gerval","Catherine","Différence",1501.5,2018,"O","O",2018,0,2252.25,1876.875]
["Mambrun","Philippe","Plénitude",1647.8000000000002,2016,"O","N",2018,0,3295.6,2471.6999999999998]
["Arnold venzlaff","Joachim","Différence",1356.25,2018,"O","N",2018,0,2712.5,2034.375]
["Cabirou","Nathalie","Plénitude",1152.8000000000002,2018,"O","O",2018,0,1729.1999999999998,1441]
["Saraf","Audrey","Plénitude",1427.8000000000002,2017,"O","N",2018,0,2855.6,2141.6999999999998]
["Larcher","Karine","Plénitude",1755.6000000000001,2016,"O","O",2018,0,2633.3999999999996,2194.5]
["Vignolles","Laurence","Initiale",579,2016,"O","O",2018,0,868.5,723.75]
["Feugas","Etienne","Différence",894.25,2018,"O","O",2018,0,1341.375,1117.8125]
["Reigney","Emmanuelle","Essentiel",1083.76,2016,"O","O",2018,0,1625.6399999999999,1354.7]
["Sapir","Eric","Essentiel",1075.08,2017,"N","O",2018,1,1612.62,1612.62]
["Barry gandhi","Christiane","Plénitude",1161.6000000000001,2018,"O","O",2018,0,1742.3999999999999,1452]
["Faure","Philippe","Essentiel",994.48,2018,"N","O",2018,0,1491.72,1243.0999999999999]
["Freiss","Pascal","Essentiel",937.43999999999994,2016,"N","O",2018,1,1406.16,1406.16]
["Chelli","Patricia","Plénitude",1986.6000000000001,2018,"O","N",2018,1,3973.2,3973.2]
["Raddas","Patricia","Différence",1627.5,2017,"O","O",2018,0,2441.25,2034.375]
["Rich","Sylvie","Initiale",672,2019,"O","O",2019,0,0,1008]
["Vidal","Claudine","Initiale",555,2018,"N","O",2018,0,832.5,693.75]
["Khenkine","Hocine","Différence",1277.5,2018,"O","O",2018,1,1916.25,1916.25]
["Amari","Gérard","Initiale",894,2017,"O","O",2018,0,1341,1117.5]
["Legras","Marie christine","Plénitude",1361.8000000000002,2018,"O","O",2018,1,2042.6999999999998,2042.6999999999998]
["Ageron","Delphin","Différence",1148,2018,"O","N",2018,0,2296,1722]
["Allevinah","Laurence","Plénitude",1111,2019,"O","O",2019,0,0,1666.5]
["Giraud","Jacqueline","Différence",1555.75,2016,"O","O",2018,0,2333.625,1944.6875]
["Ridoux","Sébastien","Initiale",699,2016,"O","O",2018,1,1048.5,1048.5]
["Flamen","Deborah","Différence",987,2017,"O","O",2018,0,1480.5,1233.75]
["Longeat","Joel","Initiale",927,2019,"N","O",2019,0,0,1390.5]
["Casanova","Laurence","Initiale",646,2017,"O","N",2018,1,1292,1292]
["Boutillot","Bruno","Différence",1125.25,2018,"O","O",2018,0,1687.875,1406.5625]
["Noel","Pascal","Initiale",815,2016,"O","O",2018,0,1222.5,1018.75]
["Bisson","Marc","Différence",1184.75,2018,"O","O",2018,0,1777.125,1480.9375]
["Poulet","Sylvie","Différence",1566.25,2016,"O","O",2018,0,2349.375,1957.8125]
["Kermagoret","Mohamed","Initiale",606,2017,"O","O",2018,1,909,909]
["Azouaoui","Martine","Différence",1307.25,2018,"O","O",2018,1,1960.875,1960.875]
["Geyl","Rolande","Plénitude",1229.8000000000002,2016,"N","O",2018,0,{"$f":"surprime($D327,$G327,J$5,$H327)","v":1844.6999999999998},{"$f":"surprime(D327,G327,K$5,$H327,I327)","v":1537.25}]
["Jamain","Louis","Plénitude",2002.0000000000002,2019,"N","O",2019,0,0,3003]
["Halouze","Michele","Essentiel",801.04,2019,"O","O",2019,0,0,1201.56]
["Lenud","Jean","Initiale",632,2019,"O","O",2019,0,0,948]
["Sanchez","Abdelali","Plénitude",1115.4000000000001,2017,"O","O",2018,1,1673.1000000000001,1673.1000000000001]
["Albors","Isabelle","Initiale",688,2019,"N","O",2019,0,0,1032]
["Piquet","Agnes","Essentiel",1072.5999999999999,2016,"N","O",2018,0,1608.8999999999999,1340.75]
["Roudaut","Sylvie","Initiale",813,2016,"O","O",2018,0,1219.5,1016.25]
["Hernandez","Viviane","Essentiel",932.48,2017,"O","N",2018,0,1864.96,1398.72]
["Lefevre","Yvonne","Plénitude",1185.8000000000002,2017,"O","O",2018,1,1778.6999999999998,1778.6999999999998]
["Mackensie","Stephane","Initiale",737,2017,"O","O",2018,0,1105.5,921.25]
["Viandier","Christophe","Initiale",715,2016,"O","O",2018,1,1072.5,1072.5]
["Flandrin","Jacques","Différence",1004.5,2017,"O","O",2018,1,1506.75,1506.75]
["Philippe","Annette","Plénitude",1390.4,2018,"O","O",2018,0,2085.6000000000004,1738]
["Rascol","Nathalie","Initiale",872,2016,"N","O",2018,0,1308,1090]
["Defretin","Laurence","Initiale",504,2019,"O","O",2019,0,0,756]
["Rigaud","Brigitte","Initiale",793,2017,"O","O",2018,0,1189.5,991.25]
["Eynaud","Isabelle","Initiale",708,2017,"O","O",2018,0,1062,885]
["Helary","Delphine","Initiale",680,2019,"O","O",2019,0,0,1020]
["Bautier","Denis","Initiale",826,2016,"N","O",2018,0,1239,1032.5]
["Alfaidy","Victor","Différence",915.25,2016,"O","O",2018,0,1372.875,1144.0625]
["Jaffry","Alain","Différence",1398.25,2016,"O","O",2018,0,2097.375,1747.8125]
["Fix","Francoise","Initiale",651,2016,"O","O",2018,0,976.5,813.75]
["Pageot","Fabrice","Initiale",533,2017,"N","O",2018,0,799.5,666.25]
["Frick","Daniel","Initiale",802,2018,"O","O",2018,0,1203,1002.5]
["Perrot","Catherine","Différence",1543.5,2017,"O","N",2018,0,3087,2315.25]
["Sylvain","Brigitte","Initiale",669,2017,"O","O",2018,0,1003.5,836.25]
["Cersoy","Claudine","Plénitude",2024.0000000000002,2018,"N","O",2018,0,3036,2530]
["Percevault","Patrick","Initiale",879,2017,"O","O",2018,0,1318.5,1098.75]
["Bouvier","Elisabeth","Différence",1480.5,2017,"O","N",2018,1,2961,2961]
["Lamiaux","Yves","Différence",1207.5,2017,"O","O",2018,0,1811.25,1509.375]
["Anes","Nicole","Initiale",541,2016,"O","O",2018,1,811.5,811.5]
["Lecossois","Jean Marc","Différence",1431.5,2017,"O","O",2018,0,2147.25,1789.375]
["Guerin wu","Christophe","Essentiel",740.28,2017,"O","O",2018,1,1110.42,1110.42]
["Blanc","Danielle","Différence",1618.75,2018,"O","O",2018,0,2428.125,2023.4375]
["Frottier","Danielle","Différence",1419.25,2017,"O","O",2018,0,2128.875,1774.0625]
["Barbier","René","Essentiel",741.52,2018,"O","O",2018,0,1112.28,926.9]
["Fediere","Nadine","Plénitude",1163.8000000000002,2017,"O","O",2018,1,1745.6999999999998,1745.6999999999998]
["Mazzour","Didier","Différence",962.5,2017,"O","O",2018,0,1443.75,1203.125]
["Michielan","Marie Astrid","Différence",858,2017,"O","N",2017,0,1287,"Err"]
["Rose","Jonathan","Initiale",652,2018,"N","O",2018,1,978,978]
["Benoit","Esther","Différence",969.68,2018,"N","O",2018,0,1454.52,1212.0999999999999]
["Leorier","Jean François","Essentiel",586,2018,"N","O",2018,1,879,879]
["Grac","Stig","Différence",664,2019,"O","O",2019,0,0,996]
["Pruvost","Carmine","Différence",576,2017,"O","O",2017,0,720,"Err"]
["Jemmely","André","Essentiel",614,2019,"O","O",2019,0,0,921]
["Guillon","Johan","Plénitude",871,2016,"O","O",2016,1,"Err","Err"]
["Jaquet","Peter","Différence",943,2019,"O","O",2019,0,0,1414.5]
["Burnod","Guy","Différence",657,2018,"O","O",2018,0,985.5,821.25]
["Mayer","Jean Louis","Initiale",623,2016,"O","O",2016,0,"Err","Err"]
["Lee","Claude","Différence",1144.52,2016,"O","O",2016,0,"Err","Err"]