{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Valeurs éditées","Valeurs sauvegardées","Morphotype sur Age et %graisse","Tableaux Divers"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":3,"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":"Valeurs éditées","index":0,"n_rows":26,"n_cols":26,"rows_kept":26,"cut":false,"hidden":false,"merged":[[18,0,18,4],[25,0,25,4],[25,5,25,7],[11,0,13,12],[11,13,13,13],[14,10,14,13],[18,10,18,12],[21,10,21,13],[25,10,25,12],[18,5,18,7],[3,19,3,23],[7,19,7,23],[0,0,0,13],[1,0,1,13],[3,0,4,0],[4,4,4,5],[7,0,8,0],[2,3,2,5],[6,3,6,5],[4,9,4,10],[4,11,4,14],[8,11,8,14],[6,8,6,11],[2,8,2,11],[1,14,1,15],[1,16,1,17]]}
[]
["MASSE GRASSE. Contrairement à l'IMC, les mesures de l'US NAVY ci-dessous sont très fiables :",null,null,null,null,null,null,null,null,null,null,null,null,null,"HISTORIQUE",null,null,null,"Tranche d'âge","Ligne correspondante","% graisse min","% graisse max","Tranche\n% graisse","Colonne correspondante","Athlète ou Anorexique","Obèse"]
[null,"Age =",56,"Hommes",null,null,null,"Prénom =","Seb",null,null,null,null,"% de graisse",null,null,null,null,{"$f":"IF($C$3<40,\"18~39 ans\",IF($C$3<60,\"40~59 ans\",\"60~79 ans\"))","v":"40~59 ans"},{"$f":"MATCH($S$3,'Morphotype sur Age et %graisse'!$A$8:$A$11,1)+7","v":10},{"$f":"INT(N4*100)","v":14},{"$f":"U3+0.9","v":14.9},{"$f":"U3&\"%~\"&V3&\"%\"","v":"14%~14,9%"},{"$f":"_xlfn.XMATCH($W$3,INDIRECT(\"'Morphotype sur Age et %graisse'! A\" & T3 &\":V\" & T3),0)+VLOOKUP($C$3,'Morphotype sur Age et %graisse'!$A$15:$B$23,2,-1)","v":5},{"$f":"SUBSTITUTE(SUBSTITUTE(INDEX('Morphotype sur Age et %graisse'!$A$1:$U$12,T3,2),\"< \",\"\"),\"%\",\"\")*1","v":11},{"$f":"SUBSTITUTE(SUBSTITUTE(INDEX('Morphotype sur Age et %graisse'!$A$1:$V$12,T3,21),\"> \",\"\"),\"%\",\"\")*1","v":29}]
["Toutes les mesures en centimètres","Taille, hauteur",179,null,"Tour de ventre",83,null,"Tour de cou",38,null,null,null,null,{"$f":"(86.01*LOG($F$4-$I$4)-70.041*LOG($C$4)+30.3)/100","v":0.14700729166954621},"Enreg. \nHomme",null,null,null,null,{"$f":"IF($N4*100<$Y3,\"Athlète ou Ano.\",IF($N4*100>$Z3,\"Obèse\",INDEX('Morphotype sur Age et %graisse'!A1:U12,12,X3,1)))","v":"Très Mince"}]
[null,null,"en cm",null,"Au plus large possible",null,null,"Sous le larynx",null,"Morphotype=",null,{"$f":"T4","v":"Très Mince"}]
[]
[null,"Age =",33,"Femmes",null,null,null,"Prénom =","Juliette",null,null,null,null,"% de graisse",null,null,null,null,{"$f":"IF($C$7<40,\"18~39 ans\",IF($C$7<60,\"40~59 ans\",\"60~79 ans\"))","v":"18~39 ans"},{"$f":"MATCH($S$7,'Morphotype sur Age et %graisse'!$A$1:$A$5,1)","v":3},{"$f":"INT(N8*100)","v":27},{"$f":"U7+0.9","v":27.9},{"$f":"U7&\"%~\"&V7&\"%\"","v":"27%~27,9%"},{"$f":"_xlfn.XMATCH($W$7,INDIRECT(\"'Morphotype sur Age et %graisse'! A\" & T7 &\":X\" & T7),0)+VLOOKUP($C$7,'Morphotype sur Age et %graisse'!$A$15:$B$23,2,-1)","v":11},{"$f":"SUBSTITUTE(SUBSTITUTE(INDEX('Morphotype sur Age et %graisse'!$A$1:$U$12,T7,2),\"< \",\"\"),\"%\",\"\")*1","v":19},{"$f":"SUBSTITUTE(SUBSTITUTE(INDEX('Morphotype sur Age et %graisse'!$A$1:$W$12,T7,23),\"> \",\"\"),\"%\",\"\")*1","v":39}]
["Toutes les mesures en centimètres","Taille, hauteur",171,null,"Tour de Taille",74,null,"Tour de Hanche",98,null,"Tour de cou",32,null,{"$f":"(163.205*LOG($F$8+$I$8-$L$8)-97.684*LOG($C$8)-104.912)/100","v":0.27218834015319743},"Enreg. \nFemme",null,null,null,null,{"$f":"IF($N8*100<$Y7,\"Athlète ou Ano.\",IF($N8*100>$Z7,\"Obèse\",INDEX('Morphotype sur Age et %graisse'!$A$1:$W$12,6,X7,1)))","v":"Normale + +"}]
[null,null,null,null,"Au plus fin",null,null,"Au plus large",null,null,"Sous le larynx",{"$f":"T8","v":"Normale + +"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"t"]
["Le Métabolisme de Base, c'est la quantité de chaleur dégagée par un individu au repos à la température de 20 degrés (neutralité thermique).\nL’individu allongé confortablement au repos musculaire complet mais éveillé, au repos digestif et métabolique,\nc’est-à-dire à jeun depuis douze heures. \nCe « besoin de base » correspond aux dépenses d’entretien irréductibles de la « machine » : \n• Contractions cardiaques (le travail du coeur) : 4 %. \n• Mouvements respiratoires (travail des muscles respiratoires) : 10 %. \n• Réaction de synthèse et dégradation de la vie cellulaire : sans arrêt les cellules meurent et se renouvellent : 70 %. \n• Tonus musculaire inconscient : 15 %.\n Le métabolisme de base moyen est de :\n• 1 500 Kcal pour un homme. \n• 1 200 Kcal pour une femme",null,null,null,null,null,null,null,null,null,null,null,null,"Les Dépenses Energétiques Journalières (DEJ), c'est la quantité d'énergie dépensée par un individu pour assurer :\n- Son activité musculaire.\n- Son métabolisme de   \n   base.\n- Le maintien de sa \n  température interne \n  corporelle."]
[]
[]
[null,null,null,"Pour les Hommes",null,null,null,null,null,null,"Métabolisme de base (kcal) ="]
[null,"Taille, hauteur (m)",1.8,null,"Poids =",78.5,null,"Age =",54,null,null,null,null,{"$f":"259*($F$16^0.48)*($C$16^0.5)*($I$16^-0.13)+C17","v":1679.8181256506666}]
[null,null,{"$f":"IF(C16>2.5,\"en mètre\",)","v":0}]
[]
["Calcul des DEJ :",null,null,null,null,"Niveau d'Activité Physique",null,null,1.8,null,"DEJ =",null,null,{"$f":"N16*I19","v":3023.6726261712001}]
[]
[]
[null,null,null,"Pour les Femmes",null,null,null,null,null,null,"Métabolisme de base (kcal) ="]
[null,"Taille, hauteur (m)",1.7," ","Poids =",70,null,"Age =",30,null,null,null,null,{"$f":"230*($F$23^0.48)*($C$23^0.5)*($I$23^-0.13)","v":1481.0632056215093}]
[null,null,{"$f":"IF(C23>2.5,\"en mètre\",)","v":0}]
[]
["Calcul des DEJ :",null,null,null,null,"Niveau d'Activité Physique",null,null,1.82,null,"DEJ =",null,null,{"$f":"N23*I26","v":2695.5350342311472}]

{"sheet":"Valeurs sauvegardées","index":1,"n_rows":3,"n_cols":24,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Homme  Femme","Prénom","Age","Taille","Date & heure","Tour de ventre","Tour de hanche","Tour de cou","% graisse","Morphotype",null,null,"Prénom",null,"Homme  Femme","Prénom","Age","Taille","Date & heure","Tour de ventre","Tour de hanche","Tour de cou","% graisse","Morphotype"]
["Homme","Seb",56,179,"2024-08-26T18:38:00",83,null,38,14.700729166954622,"Très Mince",null,null,"Juliette",null,"Femme","Juliette",33,171,"2024-08-26T18:38:00",74,98,32,27.218834015319743,"Normale + +"]
["Femme","Juliette",33,171,"2024-08-26T18:38:00",74,98,32,27.218834015319743,"Normale + +"]

{"sheet":"Morphotype sur Age et %graisse","index":2,"n_rows":23,"n_cols":23,"rows_kept":23,"cut":false,"hidden":false,"merged":[[13,0,13,1],[1,15,1,21],[7,2,7,7],[7,8,7,13],[7,14,7,19],[1,2,1,8],[1,9,1,14]]}
[]
["Ages","Femme Ath.","Femme Mince",null,null,null,null,null,null,"Femme Normale",null,null,null,null,null,"Femme Surpoids",null,null,null,null,null,null,"Femme Obèse"]
["18~39 ans","< 19%","19%~19,9%","20%~20,9%","21%~21,9%","22%~22,9%","23%~23,9%","24%~24,9%","25%~25,9%","26%~26,9%","27%~27,9%","28%~28,9%","29%~29,9%","30%~30,9%","31%~31,9%","32%~32,9%","33%~33,9%","34%~34,9%","35%~35,9%","36%~36,9%","37%~37,9%","38%~38,9%","> 39%"]
["40~59 ans","< 21%","21%~21,9%","22%~22,9%","23%~23,9%","24%~24,9%","25%~25,9%","26%~26,9%","27%~27,9%","28%~28,9%","29%~29,9%","30%~30,9%","31%~31,9%","32%~32,9%","33%~33,9%","34%~34,9%","35%~35,9%","36%~36,9%","37%~37,9%","38%~38,9%","39%~39,9%","40%~40,9%","> 41%"]
["60~79 ans","< 22%","22%~22,9%","23%~23,9%","24%~24,9%","25%~25,9%","26%~26,9%","27%~27,9%","28%~28,9%","29%~29,9%","30%~30,9%","31%~31,9%","32%~32,9%","33%~33,9%","34%~34,9%","35%~35,9%","36%~36,9%","37%~37,9%","38%~38,9%","39%~39,9%","40%~40,9%","41%~41,9%","> 42%"]
["Morphotype","Athlète ou Ano.","Presque Athlète","Très très Mince","Très Mince","Mince","Mince -","Mince - -","Mince Risk Normale","Normale Presk Mince","Normale + +","Normale +","Normale","Normale -","Normale Risk Surpoids","Surpoids Presk Normale","Surpoids - -","Surpoids -","Surpoids","Surpoids +","Surpoids + +","Surpoids Risk Obèse","Obèse"]
[]
["Ages","Homme Ath.","Homme Mince",null,null,null,null,null,"Homme Normal",null,null,null,null,null,"Homme Surpoids",null,null,null,null,null,"Homme Obèse"]
["18~39 ans","< 9%","9%~9,9%","10%~10,9%","11%~11,9%","12%~12,9%","13%~13,9%","14%~14,9%","15%~15,9%","16%~16,9%","17%~17,9%","18%~18,9%","19%~19,9%","20%~20,9%","21%~21,9%","22%~22,9%","23%~23,9%","24%~24,9%","25%~25,9%","26%~26,9%","> 27%"]
["40~59 ans","< 11%","11%~11,9%","12%~12,9%","13%~13,9%","14%~14,9%","15%~15,9%","16%~16,9%","17%~17,9%","18%~18,9%","19%~19,9%","20%~20,9%","21%~21,9%","22%~22,9%","23%~23,9%","24%~24,9%","25%~25,9%","26%~26,9%","27%~27,9%","28%~28,9%","> 29%"]
["60~79 ans","< 13%","13%~13,9%","14%~14,9%","15%~15,9%","16%~16,9%","17%~17,9%","18%~18,9%","19%~19,9%","20%~20,9%","21%~21,9%","22%~22,9%","23%~23,9%","24%~24,9%","25%~25,9%","26%~26,9%","27%~27,9%","28%~28,9%","29%~29,9%","30%~30,9%","> 31%"]
["Morphotype","Athlète ou Ano.","Presque Athlète","Très très Mince","Très Mince","Mince","Mince -","Mince Risk Normale","Normal Presk Mince","Normal + +","Normal +","Normal","Normal -","Normal Risk Surpoids","Surpoids Presk Normal","Surpoids - -","Surpoids -","Surpoids","Surpoids +","Surpoids Risk Obèse","Obèse"]
[]
["Tranches d'Ages"]
[18,1]
[24,0]
[34,-1]
[40,1]
[46,0]
[54,-1]
[60,1]
[66,0]
[74,-1]

{"sheet":"Tableaux Divers","index":3,"n_rows":13,"n_cols":17,"rows_kept":13,"cut":false,"hidden":false,"merged":[[10,14,10,16],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[3,1,5,1],[6,1,8,1],[10,8,10,10],[10,11,10,13]]}
[]
[null,"MASSE GRASSE","Tranches d'Âges","Athlète ou Anorexique","Mince","Normal","Surpoids","Obèse"]
[]
[null,"Femme","18~39 ans","< 19%","19% à 26%","26% à 32%","32% à 39%","> 39%"]
[null,null,"40~59 ans","< 21%","21% à 28%","28% à 34%","34% à 41%","> 41%"]
[null,null,"60~79 ans","< 22%","22% à 29%","29% à 35%","35% à 42%","> 42%"]
[null,"Homme","18~39 ans","< 9%","9% à 15%","15% à 21%","21% à 27%","> 27%"]
[null,null,"40~59 ans","< 11%","11% à 17%","17% à 23%","23% à 29%","> 29%"]
[null,null,"60~79 ans","< 13%","13% à 19%","19% à 25%","25% à 31%","> 31%"]
[]
[null,null,null,null,null,null,null,null," Tranche 18~39 ans",null,null," Tranche 40~59 ans",null,null," Tranche 60~79 ans"]
[null,null,null,null,null,null,null,null,"18~23 ans","24~33 ans","34~39 ans","40~45 ans","46~53 ans","54~59 ans","40~45 ans","46~53 ans","54~59 ans"]
[null,null,null,null,null,null,null,null,"Morpho plus exigeant","Niveau normal","Morpho moins exigeant","Morpho plus exigeant","Niveau normal","Morpho moins exigeant","Morpho plus exigeant","Niveau normal","Morpho moins exigeant"]