{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Mode d'emploi","FEUILLE MACRO"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Mode d'emploi","index":0,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[[35,0,35,9],[36,0,36,9],[6,0,6,9],[8,0,8,9],[13,0,13,9],[25,4,31,4],[25,5,31,5],[0,0,0,9],[2,0,2,9],[15,2,19,8],[20,2,20,8],[25,0,29,0],[25,1,29,1],[7,0,7,9]]}
[" CALCUL D'UNE MATRICE DE PROBABILITÉS PAR STADES ET PAR AGES POUR UNE STRUCTURE DE POPULATION DONNÉE"]
[]
["Macro proposée par Arnaud Bringé"]
[]
[]
[]
["Sur la \"feuille macro\", activer la macro (Excel 2007 : onglet \"affichage/macros\" ; \"outils/macros\" sur Mac)"]
["Exécuter la macro 2"]
["Renseigner les champs dans l'ordre où ils apparaissent sur la macro, en sélectionnant la ou les plages des zones 1 à 7."]
[]
[]
[]
[]
["Tableau de contingence FEMMES  PONDERES"]
["Coefficient moyen de synostose (*10)","Stades","18-29","30-39","40-49","50-59","60-69","70-79","80+","Total"]
["0-2","A","Zone 1"]
["3-9","B"]
["10-18","C"]
["19-27","D"]
["28-40","E"]
["total",null,"Zone 4"]
[]
[]
[]
["Stades","Effectifs",null,null,"Classe d'Ages","Valeur centrale du groupe d'ages",null,null,null,null,"Zone 7 : 1ere cellule de la zone Résultats ","18-29","30-39","40-49","50-59","60-69"]
["Zone 2","Zone 5",null,null,"Zone 3","Zone 6",null,null,null,null,"stade A"]
[null,null,null,null,null,null,null,null,null,null,"stade B"]
[null,null,null,null,null,null,null,null,null,null,"stade C"]
[null,null,null,null,null,null,null,null,null,null,"stade D"]
[null,null,null,null,null,null,null,null,null,null,"stade E"]
[]
[]
[]
[]
[]
["NOTA : cette procédure est valable pour n'importe quelle matrice de fréquence, établie pour n'importe quel indicateur d'âge et n'importe quelle répartition par groupes d'âges. "]
["Il suffit de modifier en conséquence les paramètres de chacune des zones indiquées. "]

{"sheet":"FEUILLE MACRO","index":1,"n_rows":32,"n_cols":19,"rows_kept":32,"cut":false,"hidden":false,"merged":[[2,1,2,10],[10,3,10,9],[9,1,9,2],[4,0,8,0],[18,0,22,0],[18,3,22,3],[18,5,24,5],[18,8,24,8]]}
[null," RÉPARTITION PAR STADES ET PAR AGES OBSERVEE DANS LA POPULATION DE RÉFÉRENCE PLisbonne1890"]
[]
[null,"Tableau de contingence"]
[null,"Coefficient moyen de synostose (*10)","Stades","18-29","30-39","40-49","50-59","60-69","70-79","80+","Total"]
["zone 1","0-2","A",38.574448942869999,15.353488372093024,18.538593481989707,12.888355342136855,12.694078947368421,9.9393939393939394,2.0244444444444447,110.01280347029639]
[null,"3-9","B",8.6162843004948275,18.562790697674416,14.449399656946825,19.778711484593835,13.016447368421053,15.575757575757576,11.983333333333334,101.98272441722186]
[null,"10-18","C",4.366171839856051,3.5348837209302326,9.8147512864493986,13.156062424969988,25.549342105263158,31.484848484848484,13.566666666666666,101.47272652898397]
[null,"19-27","D",2.6360773729194777,4.4744186046511629,5.1252144082332762,15.304121648659464,29.085526315789476,28.939393939393938,15.014444444444445,100.57919673409124]
[null,"28-40","E",0.80701754385964908,5.0744186046511626,2.0720411663807887,11.872749099639854,31.654605263157897,27.060606060606059,28.411111111111111,106.95254884940653]
["zone 4","total",null,55,47,50,73,112,113,71,521]
[null,null,null,"ligne 10 = STRUCTURE DE LA POPULATION DE RÉFÉRENCE"]
[]
[]
[]
[null," RÉPARTITION PAR STADES DES SQUELETTES DU SITE ETUDIÉ  "]
[]
[]
[null,"Stades ","Effectifs",null,null,null,"Classe d'âges","Valeur centrale du groupe d'âges",null,null,null,"zone 7","18-29","30-39","40-49","50-59","60-69","70-79","80+"]
["zone 2","Stade A",3,"zone 5",null,"zone 3","18-29",23,"zone 6",null,null,"stade A",1.0519079886902023,0.41868276839900237,0.50553916173025681,0.35145969202439409,0.34616186153630307,0.27104283208483793,5.5205695535003277E-2]
[null,"Stade B",5,null,null,null,"30-39",35,null,null,null,"stade B",0.42243842522017339,0.91009486183817379,0.70842388941448753,0.96970891872220832,0.63816923124986447,0.7636468659160125,0.58751780763908013]
[null,"Stade C",9,null,null,null,"40-49",45,null,null,null,"stade C",0.38725229825652063,0.31352221012101195,0.87050742203929865,1.1668609475168643,2.2660678077048493,2.7925103232807911,1.2032789910806643]
[null,"Stade D",6,null,null,null,"50-59",55,null,null,null,"stade D",0.15725383330841303,0.26691912939892642,0.30574201671841872,0.91295946750022983,1.7350820404353633,1.7263645890453778,0.89567892359327095]
[null,"Stade E",14,null,null,null,"60-69",65,null,null,null,"stade E",0.10563792761913013,0.66423718957035849,0.271228471330555,1.5541330167736371,4.1435615929846037,3.5422109049679467,3.7189908967537684]
[null,"total",37,null,null,null,"70-79",75]
[null,null,null,null,null,null,"80+",84]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Probas estimées par âge"]
[null,null,null,null,null,null,null,null,null,null,null,null,5.741866143498485E-2,6.9552869171012791E-2,7.1930836790081526E-2,0.1339222173658739,0.24673087929489143,0.24583177068364775,0.17461276525950775]
[null,null,null,null,null,null,null,null,null,null,null,null,"Effectifs estimés par âge"]
[null,null,null,null,null,null,null,null,null,null,null,null,2.1244904730944394,2.5734561593274732,2.6614409612330165,4.9551220425373339,9.1290425339109831,9.0957755152949673,6.460672314601787]
[null,null,null,null,null,null,null,null,null,null,null,null,"Âges moyens estimés"]
[null,null,null,null,null,null,null,null,null,null,null,null,63.499951481907004,65.967062708417387,68.434162163563613,70.538323785438024,73.657333760876469,78.737746011635735,84]