{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["Lisez moi","Tarification - 20 têtes","Tarification + 20 têtes","Liste"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Lisez moi","index":0,"n_rows":52,"n_cols":14,"rows_kept":52,"cut":false,"hidden":false,"merged":[[1,3,1,8],[25,3,25,8]],"flags":["formulas_cached_only"]}
["Tarification - 20 têtes"]
[null,null,null,"Seules les cellules de couleur jaune sont à renseigner"]
[]
[null,"date d'effet du contrat ",null,null,null,"Remarques : "]
[null,"2015-01-01",null,null,null,"Seul les années de naissance des salatiés sont à renseigner"]
[{"$nulls":5},"la colonne C \"Nom du salarié / ou Matricule\" est à remplir à votre convenance"]
[null,"Effectif"]
[]
[]
[null,"Effectif à assurer",3,null,null,"Résutats à reporter dans l'OAV : l'effectif assuré et sa moyenne d'âge"]
[]
[null,"Age moyen",44]
[]
[]
[null,"Rang","Nom du salarié / ou Matricule","Année de naissance",null,"Etapes pour renseigner le fichier : à chaque ligne correspond un salarié"]
[null,1,null,1970,null,"1) Renseigner la date d'effet du contrat"]
[null,2,null,1980,null,"2) Renseigner l'année de naissance du salarié"]
[null,3,null,1963]
[null,4]
[]
[]
[]
[]
[]
["Tarification + 20 têtes"]
[null,null,null,"Seules les cellules de couleur jaune sont à renseigner"]
[]
[null,"date d'effet du contrat ",{"$nulls":11},"Remarques : "]
[null,"01/01/20XX",{"$nulls":11},"La démographie détaillée de l'entreprise est demandée"]
[{"$nulls":13},"la colonne C \"Nom du salarié / ou Matricule\" est à remplir à votre convenance"]
[]
[null,"Démographie détaillée de la population cadre",{"$nulls":5},"Démographie détaillée de la population non-cadre"]
[{"$nulls":13},"Résutats à reporter dans l'OAV : la démographie détaillée"]
[null,"Cadres Salariés",0,null,"Age moyen",0,null,"Cadres Salariés",0,null,"Age moyen",0]
[]
[null,"Salariés seuls 0",0,{"$nulls":4},"Salariés seuls 0",0]
[]
[null,"salariés seuls 1 et +",0,{"$nulls":4},"salariés seuls 1 et +",0]
[]
[null,"Salariés en couple",0,null,"Enfants à charge",0,null,"Salariés en couple",0,null,"Enfants à charge",0]
[]
[null,"Hommes",0,null,"Femmes",0,null,"Hommes",0,null,"Femmes",0]
[]
[]
[null,"Rang","Nom du salarié / ou Matricule","Année de naissance","Sexe","Catégorie","salarié seul sans enfant à charge","salarié seul avec un ou plusieurs enfants à charge","salarié en couple","Nombre d'enfants à charge","Test Cohérence","test1","Etapes pour renseigner le fichier : à chaque ligne correspond un salarié"]
[null,1,"S1",1970,"F","Cadre : art. 4 , art. 4 bis et art. 36.",null,"x",null,1,"ok","pb","1) Renseigner la date d'effet du contrat"]
[null,2,"S2",1980,"H","Non cadre : non affilié à la convention AGIRC.","x",null,null,0,"ok","pb","2) Renseigner l'année de naissance du salarié"]
[null,3,"S3",1963,"F","Non cadre : non affilié à la convention AGIRC.",null,null,"x",2,"ok","pb","3) Renseigner le sexe du salarié"]
[null,4,{"$nulls":8},"ok","pb","4) Renseigner la catégorie du salarié (cadre ou non cadre)"]
[null,5,{"$nulls":7},"vérifier la saisie de la ligne tant que le test de cohérence n'est pas \"ok\" -->","pb","ok","5) Renseigner la situation familiale du salarié : une des trois colonne G H I "]
[null,6,{"$nulls":8},"ok","pb","6) Renseigner le nombre d'enfant à charge (0 si pas d'enfant)"]
[null,7,{"$nulls":8},"ok","pb","7) Vérifier qie la colonne K est \"ok\", sinon vérifier la ligne saisie"]

{"sheet":"Tarification - 20 têtes","index":1,"n_rows":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,"date d'effet du contrat "]
[null,"2015-01-01"]
[]
[]
[null,"Effectif"]
[]
[]
[null,"Effectif à assurer",3]
[]
[null,"Age moyen",44]
[]
[]
[]
[null,"Rang","Nom du salarié / ou Matricule","Année de naissance"]
[null,1,null,1970]
[null,2,null,1980]
[null,3,null,1963]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]

{"sheet":"Tarification + 20 têtes","index":2,"n_rows":68,"n_cols":15,"rows_kept":68,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,null,"date d'effet du contrat "]
[null,null,"01/01/20XX"]
[]
[]
[null,null,"Démographie détaillée de la population cadre",{"$nulls":5},"Démographie détaillée de la population non-cadre"]
[]
[null,null,"Cadres Salariés",1,null,"Age moyen",0,null,"Cadres Salariés",2,null,"Age moyen",0]
[]
[null,null,"Salariés seuls 0",0,{"$nulls":4},"Salariés seuls 0",1]
[]
[null,null,"salariés seuls 1 et +",1,{"$nulls":4},"salariés seuls 1 et +",0]
[]
[null,null,"Salariés en couple",0,null,"Enfants à charge",1,null,"Salariés en couple",1,null,"Enfants à charge",2]
[]
[null,null,"Hommes",0,null,"Femmes",1,null,"Hommes",1,null,"Femmes",1]
[]
[]
[null,null,"Rang","Nom du salarié / ou Matricule","Année de naissance","Sexe","Catégorie","salarié seul sans enfant à charge","salarié seul avec un ou plusieurs enfants à charge","salarié en couple","Nombre d'enfants à charge","Test Cohérence","test1","test2","test3"]
[null,null,1,null,1970,"F","Cadre : art. 4 , art. 4 bis et art. 36.",null,"x",null,1,"ok","ok","ok","test"]
[null,null,2,null,1980,"H","Non cadre : non affilié à la convention AGIRC.","x",null,null,0,"ok","ok","ok","test"]
[null,null,3,null,1963,"F","Non cadre : non affilié à la convention AGIRC.",null,null,"x",2,"ok","ok","ok","test"]
[null,null,4,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,5,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,6,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,7,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,8,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,9,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,10,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,11,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,12,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,13,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,14,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,15,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,16,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,17,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,18,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,19,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,20,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,21,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,22,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,23,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,24,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,25,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,26,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,27,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,28,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,29,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,30,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,31,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,32,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,33,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,34,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,35,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,36,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,37,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,38,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,39,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,40,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,41,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,42,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,43,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,44,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,45,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,46,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,47,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,48,{"$nulls":8},"ok","pb","pb","ok"]
[null,null,49,{"$nulls":8},"ok","pb","pb","ok"]

{"sheet":"Liste","index":3,"n_rows":86,"n_cols":11,"rows_kept":86,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
{"$rows_empty":9}
[null,null,"Année de naissance",null,"Catégorie",null,"Sexe",null,"Nombre d'enfants à charge",null,"Choix"]
[null,null,1930,null,"Cadre : art. 4 , art. 4 bis et art. 36.",null,"F",null,0,null,"x"]
[null,null,1931,null,"Non cadre : non affilié à la convention AGIRC.",null,"H",null,1]
[null,null,1932,{"$nulls":5},2]
[null,null,1933,{"$nulls":5},3]
[null,null,1934,{"$nulls":5},4]
[null,null,1935,{"$nulls":5},5]
[null,null,1936,{"$nulls":5},6]
[null,null,1937,{"$nulls":5},7]
[null,null,1938,{"$nulls":5},8]
[null,null,1939,{"$nulls":5},9]
[null,null,1940,{"$nulls":5},10]
[null,null,1941,{"$nulls":5},11]
[null,null,1942,{"$nulls":5},12]
[null,null,1943,{"$nulls":5},13]
[null,null,1944,{"$nulls":5},14]
[null,null,1945,{"$nulls":5},15]
[null,null,1946,{"$nulls":5},16]
[null,null,1947,{"$nulls":5},17]
[null,null,1948,{"$nulls":5},18]
[null,null,1949,{"$nulls":5},19]
[null,null,1950,{"$nulls":5},20]
[null,null,1951]
[null,null,1952]
[null,null,1953]
[null,null,1954]
[null,null,1955]
[null,null,1956]
[null,null,1957]
[null,null,1958]
[null,null,1959]
[null,null,1960]
[null,null,1961]
[null,null,1962]
[null,null,1963]
[null,null,1964]
[null,null,1965]
[null,null,1966]
[null,null,1967]
[null,null,1968]
[null,null,1969]
[null,null,1970]
[null,null,1971]
[null,null,1972]
[null,null,1973]
[null,null,1974]
[null,null,1975]
[null,null,1976]
[null,null,1977]
[null,null,1978]
[null,null,1979]
[null,null,1980]
[null,null,1981]
[null,null,1982]
[null,null,1983]
[null,null,1984]
[null,null,1985]
[null,null,1986]
[null,null,1987]
[null,null,1988]
[null,null,1989]
[null,null,1990]
[null,null,1991]
[null,null,1992]
[null,null,1993]
[null,null,1994]
[null,null,1995]
[null,null,1996]
[null,null,1997]
[null,null,1998]
[null,null,1999]
[null,null,2000]
[null,null,2001]
[null,null,2002]
[null,null,2003]
[null,null,2004]
[null,null,2005]