{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Liste RH","Liste Client","Liste ","Consignes ","Code VBA "],"not_rendered":{"images":4,"macros":1,"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"Liste RH","index":0,"n_rows":21,"n_cols":26,"rows_kept":21,"merged":[[0,0,2,0],[2,15,2,16]]}
["femme"]
[]
[{"$nulls":13},"Critères",null,"Résultat Filtre"]
[]
["MATRICULE","NOM","PRENOM","SEXE","DATE NAISSANCE","AGE","DATE EMBAUCHE","ANCIENNETE","STATUT","SERVICE","SALAIRE",null,null,"NOM",null,"MATRICULE","NOM","PRENOM","SEXE","DATE NAISSANCE","AGE","DATE EMBAUCHE","ANCIENNETE","STATUT","SERVICE","SALAIRE"]
[34,"ABENHAÏM","Myriam","femme","1950-10-30",{"$f":"DATEDIF(E6,TODAY(),\"y\")","v":68},"1994-03-17",{"$f":"DATEDIF(G6,TODAY(),\"y\")","v":25},"Agent","Production",{"v":2900,"d":"2,900.00 €"},null,null,"amellal"]
[187,"ABSCHEN","Paul","homme","1968-11-11",50,"1996-03-29",22,"Agent","Etude laboratoire",{"v":3000,"d":"3,000.00 €"}]
[118,"ADAMO","Stéphane","homme","1957-12-16",61,"1985-05-03",33,"Agent","Design",{"v":3200,"d":"3,200.00 €"}]
[205,"AGAPOF","Brigitte","femme","1970-03-24",48,"1997-08-08",21,"Agent","Contrôle qualité",{"v":1000,"d":"1,000.00 €"}]
[171,"ALEMBERT","Jean","homme","1968-01-13",51,"1995-05-31",23,"Agent","Commercial",{"v":1800,"d":"1,800.00 €"}]
[183,"AMARA","Nicolas","homme","1968-10-21",50,"1996-03-08",23,"Agent","Production",{"v":3100,"d":"3,100.00 €"}]
[]
[160,"AMELLAL","Jean-Marc","homme","1966-10-07",52,"1994-02-22",25,"Agent","Commercial",{"v":2300,"d":"2,300.00 €"}]
[275,"AMELLAL","Jimmy","homme","1984-12-25",34,"2010-10-05",8,"Agent","Commercial",{"v":2200,"d":"2,200.00 €"}]
[52,"ANGONIN","Jean-Pierre","homme","1952-09-19",66,"1980-02-05",39,"Agent","Commercial",{"v":2300,"d":"2,300.00 €"}]
[94,"AZOURA","Marie-France","femme","1955-04-13",63,"1982-08-30",36,"Agent","Contrôle qualité",{"v":2600,"d":"2,600.00 €"}]
[74,"AZRIA","Maryse","femme","1954-01-22",65,"1981-06-09",37,"Cadre","Etude laboratoire",{"v":3200,"d":"3,200.00 €"}]
[56,"BACH","Ginette","femme","1953-01-20",66,"1980-06-05",38,"Agent","Production",{"v":1700,"d":"1,700.00 €"}]
[70,"BAH","Paule","femme","1953-11-29",65,"1981-04-16",37,"Agent","Etude laboratoire",{"v":3200,"d":"3,200.00 €"}]
[184,"BARNAUD","Janine","femme","1968-10-23",50,"1996-03-08",23,"Agent","Commercial",{"v":1800,"d":"1,800.00 €"}]
[140,"BARRACHINA","Monique","femme","1961-06-04",57,"1988-10-20",30,"Agent","Production",{"v":2900,"d":"2,900.00 €"}]

{"sheet":"Liste Client","index":1,"n_rows":40,"n_cols":14,"rows_kept":40,"hidden":true}
[]
[]
[]
[null,"Numéro client","Nom","Prénom","Adresse","Code postal","Ville","Région","Code","Source","Premier achat","Total achats","Revenus","Type ménage"]
[null,1,"Van Outin","Christiane","1611 Aux Revers ",{"v":1601,"d":"01601"},"Chateauneuf","Brabant",773,"Radio","1998-05-19",{"v":893,"d":"893 €"},90000,"Famille"]
[null,2,"Troigne","Robert","25, Rue 8 Mai 1945",71170,"Chauffailles","Bourgogne",816,"Magazine","1993-05-21",{"v":1330,"d":"1,330 €"},59000,"Célibataire"]
[null,3,"Sicard","Tabatha","Route de Samerey",21170,"Laperriere Sur Saone","Bourgogne",914,"Quotidien","1997-06-28",{"v":302,"d":"302 €"},65000,"Famille"]
[null,4,"Meunier","Maelle","29, Rue Jeanne D Arc",75016,"Paris","Ile de France",619,"Magazine","1998-06-05",{"v":1200,"d":"1,200 €"},72000,"Célibataire"]
[null,5,"Ballard","Catherine","2, Ile Loups",94170,"Le Perreux Sur Marne","Ile de France",510,"Magazine","1990-06-22",{"v":3200,"d":"3,200 €"},84000,"Couple"]
[null,6,"Montano","Nicole","251 Route Nationale 6 ",69800,"St Priest","Rhône-Alpes",312,"Magazine","1997-04-29",{"v":640,"d":"640 €"},42000,"Célibataire"]
[null,7,"Montroux","Camille","24, Avenue Jean Moulin ",74150,"Rumilly","Rhône-Alpes",281,"TV","1996-05-26",{"v":990,"d":"990 €"},65000,"Couple"]
[null,8,"Roland","Michel","108 rue Lemercier",75017,"Paris","Ile de France",773,"Magazine","1993-04-09",{"v":480,"d":"480 €"},45000,"Célibataire"]
[null,9,"Ichikawa","Ito","1, Rue Baronne Delort",39300,"Champagnole","Franche-Comté",816,"Magazine","1996-05-24",{"v":530,"d":"530 €"},62000,"Couple"]
[null,10,"Rodriguez","Virginie","Route Grange L Eveque",10180,"St Lye","Champagne-Ardenne",718,"Radio","1991-05-08",{"v":1520,"d":"1,520 €"},33000,"Célibataire"]
[null,11,"Munchen","Karl","1095, Route Paris",76520,"Franqueville St Pierre","Haute-Normandie",206,"Magazine","1996-06-16",{"v":895,"d":"895 €"},45000,"Célibataire"]
[null,12,"d'Oustreciel","Amaury","Meymac",15800,"Polminhac","Auvergne",281,"Quotidien","1997-04-27",{"v":420,"d":"420 €"},52000,"Célibataire"]
[null,13,"Guttierez","François","9, Route d'Auxerre",89380,"Appoigny","Bourgogne",206,"Quotidien","1984-05-10",{"v":440,"d":"440 €"},39000,"Célibataire"]
[null,14,"Van Gogh","Vincent","25, Rue Francois Villon",95430,"Auvers Sur Oise","Ile de France",617,"Radio","1995-05-07",{"v":1320,"d":"1,320 €"},62000,"Célibataire"]
[null,15,"Salpertois","Stéphanie","Rue A. Bordes",52400,"Serqueux","Champagne-Ardenne",617,"Radio","1996-05-12",{"v":550,"d":"550 €"},32000,"Célibataire"]
[null,16,"Boulard","Amélie","Rue des Vignes",18390,"St Germain Du Puy","Centre",816,"Magazine","1995-06-01",{"v":879,"d":"879 €"},42000,"Célibataire"]
[null,17,"Lescault","Manon","31, Rue Bonne Femme",51100,"Reims","Champagne-Ardenne",212,"Radio","1999-06-02",{"v":215,"d":"215 €"},42000,"Famille"]
[null,18,"Wong","Carole","10, Rue Henri Boulenger",76133,"Epouville","Haute-Normandie",281,"Magazine","1998-06-28",{"v":320,"d":"320 €"},33000,"Célibataire"]
[null,19,"Pachevin","Denis","18, Rue Gravignan ",69360,"Ternay","Rhône-Alpes",508,"Magazine","1997-05-25",{"v":820,"d":"820 €"},93000,"Famille"]
[null,20,"Sicolado","Erwin","Allée du Parc",{"v":4100,"d":"04100"},"Manosque","Provence",203,"Magazine","1999-06-12",{"v":150,"d":"150 €"},72000,"Couple"]
[null,21,"Chamfort","Annes","6, Rue Rougerons",28300,"Champhol","Centre",773,"Pages Jaunes","1997-04-03",{"v":779,"d":"779 €"},87000,"Couple"]
[null,22,"Gauthiers","Michel","Le Mas Sireuil",24620,"Les Eyzies Tayac Sireuil","Aquitaine",617,"Pages Jaunes","1998-04-04",{"v":420,"d":"420 €"},55000,"Couple"]
[null,23,"Gonzales","José","Le Bourg",63500,"Flat","Auvergne",619,"Pages Jaunes","1998-04-16",{"v":250,"d":"250 €"},45000,"Couple"]
[null,24,"Chazal","Anthonin","25, route de Tulle",43700,"Brives Charensac","Auvergne",619,"Pages Jaunes","1999-05-25",{"v":120,"d":"120 €"},85000,"Famille"]
[null,25,"Gabriel","Jordy","Route Nationale 102",43000,"Polignac","Auvergne",617,"Pages Jaunes","1994-06-01",{"v":1550,"d":"1,550 €"},45000,"Célibataire"]
[null,26,"Jantsizian","Stephane","06, Avenue Caupos",40600,"Biscarrosse","Aquitaine",617,"Magazine","2000-06-03",{"v":250,"d":"250 €"},30000,"Célibataire"]
[null,27,"Relman","Catherine","150, Chemin Lebrane",40300,"Cagnotte","Aquitaine",415,"Radio","1999-06-13",{"v":553,"d":"553 €"},65000,"Couple"]
[null,28,"Larquez","Thierry","69, Rue Ferte",77580,"Crecy La Chapelle","Ile de France",413,"TV","1987-04-06",{"v":420,"d":"420 €"},49000,"Couple"]
[null,29,"Roland","Michel","108 rue Lemercier",75017,"Paris","Ile de France",773,"Magazine","1993-04-09",{"v":480,"d":"480 €"},45000,"Célibataire"]
[null,30,"Lopez","Luis","15 rue Cour des Noues",75020,"Paris","Ile de France",505,"TV","1998-04-26",{"v":2530,"d":"2,530 €"},34000,"Célibataire"]
[null,31,"Frendain","Marie","12, Rue Paul Fort",75014,"Paris","Ile de France",206,"Magazine","1993-05-14",{"v":2100,"d":"2,100 €"},63000,"Célibataire"]
[null,32,"Khalsa","Patrick","2, Rue Condorcet",78800,"Houilles","Ile de France",212,"Quotidien","1999-05-19",{"v":310,"d":"310 €"},23000,"Célibataire"]
[null,33,"Chavez","Florence","16, Avenue Rosny",93360,"Neuilly Plaisance","Ile de France",771,"Magazine","1999-03-22",{"v":250,"d":"250 €"},31000,"Célibataire"]
[null,34,"Trevasec","Gaelle","4, Rue Des Hussards",66490,"St Jean Pla De Corts","Languedoc-Roussillon",508,"Magazine","1999-05-30",{"v":390,"d":"390 €"},32000,"Célibataire"]
[null,35,"Skwettlicw","Pietr","12, Rue Fleurs",66240,"St Esteve","Languedoc-Roussillon",508,"Magazine","1997-06-15",{"v":450,"d":"450 €"},53000,"Famille"]
[null,36,"Kane","Richard","21, Rue Saint Georges",27940,"Aubevoye","Haute-Normandie",415,"TV","1992-04-11",{"v":1300,"d":"1,300 €"},54000,"Célibataire"]

{"sheet":"Liste ","index":2,"n_rows":16,"n_cols":19,"rows_kept":16,"hidden":true}
[]
[]
[]
[{"$nulls":8},"Ligne",null,"Colonne"]
[null,null,"Services",{"$nulls":5},"Cellule de ",null,"Hauteur",{"$nulls":5},"Statut",null,"TOTAL"]
[null,null,"Production",{"$nulls":5},"départ",null,"Largeur",{"$nulls":5},"Technicien",null,{"$f":"COUNTA('Liste RH'!P6:P10000)","v":0}]
[null,null,"Contrôle qualité",{"$nulls":5},"=DECALER(C5;1;0;11;0)",{"$nulls":7},"Agent"]
[null,null,"Etude laboratoire",{"$nulls":13},"Cadre"]
[null,null,"Accueil",{"$nulls":13},"Président"]
[null,null,"Design",{"$nulls":13},"Dirigeant"]
[null,null,"Maintenance",null,"= NBVAL(Liste!C6:C100) donne le résultat 11"]
[null,null,"Commercial"]
[null,null,"Direction"]
[null,null,"Administratif"]
[null,null,"Ressources humaines"]
[null,null,"Infirmerie"]

{"sheet":"Consignes ","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}

{"sheet":"Code VBA ","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}