{"text_format":"3","workbook":"xlsx","n_sheets":18,"sheets":["PROTOCOLES","REGLE DES 3","JAN","FEV","MARS","AVRIL","MAI","JUIN","JUILLET","AOUT","SEPT","OCT","NOV","DEC","HYPOTA ORTHOSTATIQUE","HYPOTA RECUEIL","HYPOTA FEUILLE VIERGE","RECAPITULATIF ANNÉE"],"not_rendered":{"charts":36,"images":1,"macros":1,"defined_names":16},"read":"whole","date_system":"1900"}

{"sheet":"PROTOCOLES","index":0,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"REGLE DES 3","index":1,"n_rows":4,"n_cols":2,"rows_kept":4}
[]
[]
[]
[null,"l"]

{"sheet":"JAN","index":2,"n_rows":83,"n_cols":10,"rows_kept":83,"merged":[[3,5,3,6],[3,8,3,9],[5,5,5,9],[7,5,7,9],[8,4,8,5],[8,7,8,8],[9,5,9,9],[11,5,11,9],[13,5,13,9],[15,5,15,9],[17,5,17,9],[19,5,19,9],[21,5,21,9],[23,5,23,9],[25,1,25,4],[25,6,25,9],[27,3,27,9],[29,1,30,3],[29,4,29,5],[29,6,29,7],[29,8,29,9],[31,1,32,2],[33,1,34,2],[35,1,36,2],[37,1,38,2],[39,1,40,2],[41,1,42,2],[43,1,44,2],[46,1,46,7],[47,1,47,8],[49,1,49,7],[50,1,50,8],[59,1,59,8],[63,1,63,9],[70,1,70,9],[77,1,77,9]]}
{"$rows_empty":25}
[null,{"$f":"CONCATENATE(F8,\" \",F6,\" \",F10,\" ans\")","v":"   ans"},{"$nulls":4},{"$f":"CONCATENATE(F12,\" kg\",\", \",F14, \" cm\",\", \",\"BMI = \",ROUND(((F12)/((F14/100)*(F14/100))),1))","v":{"$error":"#DIV/0!"}}]
[]
[null,"Traitement",null,{"$f":"CONCATENATE(F16,\"  \",F18,\"  \",F20,\"  \",F22,\"  \",F24)","v":"        "}]
[]
[null,{"$f":"CONCATENATE(\"Date\",\" : \",F4,\"/\",I4)","v":"Date : /"},null,null,"MESURE 1",null,"MESURE 2",null,"MESURE 3"]
[{"$nulls":4},"SYS","DIA","SYS","DIA","SYS","DIA"]
[null,"JOUR 1",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 2",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 3",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 4",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 5",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 6",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 7",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[]
[null,"3 mesures par série : moyenne quotidienne des 3 mesures de chaque série"]
[null,{"$f":"CONCATENATE(\"Automesure (\",F4,\"/\",I4,\") : \",\"PA = \",ROUND((AVERAGE(E32:E45,G32:G45,I32:I45)),0),\"/\",ROUND((AVERAGE(F32:F45,H32:H45,J32:J45)),0),\" mmHg, PA matin = \",ROUND((AVERAGE(E32,G32,I32,E34,G34,I34,E36,G36,I36,E38,G38,I38,E40,G40,I40,E42,G42,I42,E44,G44,I44)),0),\"/\",ROUND((AVERAGE(F32,H32,J32,F34,H34,J34,F36,H36,J36,F38,H38,J38,F40,H40,J40,F42,H42,J42,F44,H44,J44)),0),\" mmHg, PA soir = \", ROUND((AVERAGE(E33,G33,I33,E35,G35,I35,E37,G37,I37,E39,G39,I39,E41,G41,I41,E43,G43,I43,E45,G45,I45)),0),\"/\",ROUND((AVERAGE(F33,H33,J33,F35,H35,J35,F37,H37,J37,F39,H39,J39,F41,H41,J41,F43,H43,J43,F45,H45,J45)),0),\" mmHg\")","v":{"$error":"#DIV/0!"}}]
[]
[null,"2 mesures par série : exclusion de la première mesure de chaque série"]
[null,{"$f":"CONCATENATE(\"Automesure (\",F4,\"/\",I4,\") : \",\"PA = \",ROUND((AVERAGE(G32:G45,I32:I45)),0),\"/\",ROUND((AVERAGE(H32:H45,J32:J45)),0),\" mmHg, PA matin = \",ROUND((AVERAGE(G32,I32,G34,I34,G36,I36,G38,I38,G40,I40,G42,I42,G44,I44)),0),\"/\",ROUND((AVERAGE(H32,J32,H34,J34,H36,J36,H38,J38,H40,J40,H42,J42,H44,J44)),0),\" mmHg, PA soir = \", ROUND((AVERAGE(G33,I33,G35,I35,G37,I37,G39,I39,G41,I41,G43,I43,G45,I45)),0),\"/\",ROUND((AVERAGE(H33,J33,H35,J35,H37,J37,H39,J39,H41,J41,H43,J43,H45,J45)),0),\" mmHg\")","v":{"$error":"#DIV/0!"}}]
{"$rows_empty":7}
[null,"2 mesures par série sans J1 : exclusion de la première mesure de chaque série sans le 1e jour"]
[null,{"$f":"CONCATENATE(\"Automesure (\",F4,\"/\",I4,\") : \",\"PA = \",ROUND((AVERAGE(G34:G45,I34:I45)),0),\"/\",ROUND((AVERAGE(H34:H45,J34:J45)),0),\" mmHg, PA matin = \",ROUND((AVERAGE(G34,I34,G36,I36,G38,I38,G40,I40,G42,I42,G44,I44)),0),\"/\",ROUND((AVERAGE(H34,J34,H36,J36,H38,J38,H40,J40,H42,J42,H44,J44)),0),\" mmHg, PA soir = \", ROUND((AVERAGE(G35,I35,G37,I37,G39,I39,G41,I41,G43,I43,G45,I45)),0),\"/\",ROUND((AVERAGE(H35,J35,H37,J37,H39,J39,H41,J41,H43,J43,H45,J45)),0),\" mmHg\")","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,"Données 3 mesures"]
[{"$nulls":3},"J1","J2","J3","J4","J5","J6","J7"]
[null,"PAS normale",null,135,135,135,135,135,135,135]
[null,"PAD normale",null,85,85,85,85,85,85,85]
[null,"PAS",null,{"$f":"AVERAGE(E32,G32,I32,E33,G33,I33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E34,G34,I34,E35,G35,I35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E36,G36,I36,E37,G37,I37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E38,G38,I38,E39,G39,I39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E40,G40,I40,E41,G41,I41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E42,G42,I42,E43,G43,I43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E44,G44,I44,E45,G45,I45)","v":{"$error":"#DIV/0!"}}]
[null,"PAD",null,{"$f":"AVERAGE(F32,H32,J32,F33,H33,J33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F34,H34,J34,F35,H35,J35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F36,H36,J36,F37,H37,J37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F38,H38,J38,F39,H39,J39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F40,H40,J40,F41,H41,J41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F42,H42,J42,F43,H43,J43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F44,H44,J44,F45,H45,J45)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Données 2 mesures"]
[null,null,"J1","J2","J3","J4","J5","J6","J7"]
[null,"PAS normale",135,135,135,135,135,135,135]
[null,"PAD normale",85,85,85,85,85,85,85]
[null,"PAS",{"$f":"AVERAGE(G32,I32,G33,I33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G34,I34,G35,I35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G36,I36,G37,I37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G38,I38,G39,I39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G40,I40,G41,I41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G42,I42,G43,I43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G44,I44,G45,I45)","v":{"$error":"#DIV/0!"}}]
[null,"PAD",{"$f":"AVERAGE(H32,J32,H33,J33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H34,J34,H35,J35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H36,J36,H37,J37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H38,J38,H39,J39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H40,J40,H41,J41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H42,J42,H43,J43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H44,J44,H45,J45)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Données 2 mesures en excluant le 1e jour"]
[null,null,"J2","J3","J4","J5","J6","J7"]
[null,"PAS normale",135,135,135,135,135,135]
[null,"PAD normale",85,85,85,85,85,85]
[null,"PAS",{"$f":"AVERAGE(G34,I34,G35,I35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G36,I36,G37,I37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G38,I38,G39,I39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G40,I40,G41,I41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G42,I42,G43,I43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G44,I44,G45,I45)","v":{"$error":"#DIV/0!"}}]
[null,"PAD",{"$f":"AVERAGE(H34,J34,H35,J35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H36,J36,H37,J37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H38,J38,H39,J39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H40,J40,H41,J41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H42,J42,H43,J43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H44,J44,H45,J45)","v":{"$error":"#DIV/0!"}}]

{"sheet":"FEV","index":3,"n_rows":83,"n_cols":10,"rows_kept":83,"merged":[[3,5,3,6],[3,8,3,9],[5,5,5,9],[7,5,7,9],[8,4,8,5],[8,7,8,8],[9,5,9,9],[11,5,11,9],[13,5,13,9],[15,5,15,9],[17,5,17,9],[19,5,19,9],[21,5,21,9],[23,5,23,9],[25,1,25,4],[25,6,25,9],[27,3,27,9],[29,1,30,3],[29,4,29,5],[29,6,29,7],[29,8,29,9],[31,1,32,2],[33,1,34,2],[35,1,36,2],[37,1,38,2],[39,1,40,2],[41,1,42,2],[43,1,44,2],[46,1,46,7],[47,1,47,8],[49,1,49,7],[50,1,50,8],[59,1,59,8],[63,1,63,9],[70,1,70,9],[77,1,77,9]]}
{"$rows_empty":25}
[null,{"$f":"CONCATENATE(F8,\" \",F6,\" \",F10,\" ans\")","v":"   ans"},{"$nulls":4},{"$f":"CONCATENATE(F12,\" kg\",\", \",F14, \" cm\",\", \",\"BMI = \",ROUND(((F12)/((F14/100)*(F14/100))),1))","v":{"$error":"#DIV/0!"}}]
[]
[null,"Traitement",null,{"$f":"CONCATENATE(F16,\"  \",F18,\"  \",F20,\"  \",F22,\"  \",F24)","v":"        "}]
[]
[null,{"$f":"CONCATENATE(\"Date\",\" : \",F4,\"/\",I4)","v":"Date : /"},null,null,"MESURE 1",null,"MESURE 2",null,"MESURE 3"]
[{"$nulls":4},"SYS","DIA","SYS","DIA","SYS","DIA"]
[null,"JOUR 1",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 2",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 3",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 4",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 5",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 6",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 7",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[]
[null,"3 mesures par série : moyenne quotidienne des 3 mesures de chaque série"]
[null,{"$f":"CONCATENATE(\"Automesure (\",F4,\"/\",I4,\") : \",\"PA = \",ROUND((AVERAGE(E32:E45,G32:G45,I32:I45)),0),\"/\",ROUND((AVERAGE(F32:F45,H32:H45,J32:J45)),0),\" mmHg, PA matin = \",ROUND((AVERAGE(E32,G32,I32,E34,G34,I34,E36,G36,I36,E38,G38,I38,E40,G40,I40,E42,G42,I42,E44,G44,I44)),0),\"/\",ROUND((AVERAGE(F32,H32,J32,F34,H34,J34,F36,H36,J36,F38,H38,J38,F40,H40,J40,F42,H42,J42,F44,H44,J44)),0),\" mmHg, PA soir = \", ROUND((AVERAGE(E33,G33,I33,E35,G35,I35,E37,G37,I37,E39,G39,I39,E41,G41,I41,E43,G43,I43,E45,G45,I45)),0),\"/\",ROUND((AVERAGE(F33,H33,J33,F35,H35,J35,F37,H37,J37,F39,H39,J39,F41,H41,J41,F43,H43,J43,F45,H45,J45)),0),\" mmHg\")","v":{"$error":"#DIV/0!"}}]
[]
[null,"2 mesures par série : exclusion de la première mesure de chaque série"]
[null,{"$f":"CONCATENATE(\"Automesure (\",F4,\"/\",I4,\") : \",\"PA = \",ROUND((AVERAGE(G32:G45,I32:I45)),0),\"/\",ROUND((AVERAGE(H32:H45,J32:J45)),0),\" mmHg, PA matin = \",ROUND((AVERAGE(G32,I32,G34,I34,G36,I36,G38,I38,G40,I40,G42,I42,G44,I44)),0),\"/\",ROUND((AVERAGE(H32,J32,H34,J34,H36,J36,H38,J38,H40,J40,H42,J42,H44,J44)),0),\" mmHg, PA soir = \", ROUND((AVERAGE(G33,I33,G35,I35,G37,I37,G39,I39,G41,I41,G43,I43,G45,I45)),0),\"/\",ROUND((AVERAGE(H33,J33,H35,J35,H37,J37,H39,J39,H41,J41,H43,J43,H45,J45)),0),\" mmHg\")","v":{"$error":"#DIV/0!"}}]
{"$rows_empty":7}
[null,"2 mesures par série sans J1 : exclusion de la première mesure de chaque série sans le 1e jour"]
[null,{"$f":"CONCATENATE(\"Automesure (\",F4,\"/\",I4,\") : \",\"PA = \",ROUND((AVERAGE(G34:G45,I34:I45)),0),\"/\",ROUND((AVERAGE(H34:H45,J34:J45)),0),\" mmHg, PA matin = \",ROUND((AVERAGE(G34,I34,G36,I36,G38,I38,G40,I40,G42,I42,G44,I44)),0),\"/\",ROUND((AVERAGE(H34,J34,H36,J36,H38,J38,H40,J40,H42,J42,H44,J44)),0),\" mmHg, PA soir = \", ROUND((AVERAGE(G35,I35,G37,I37,G39,I39,G41,I41,G43,I43,G45,I45)),0),\"/\",ROUND((AVERAGE(H35,J35,H37,J37,H39,J39,H41,J41,H43,J43,H45,J45)),0),\" mmHg\")","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,"Données 3 mesures"]
[{"$nulls":3},"J1","J2","J3","J4","J5","J6","J7"]
[null,"PAS normale",null,135,135,135,135,135,135,135]
[null,"PAD normale",null,85,85,85,85,85,85,85]
[null,"PAS",null,{"$f":"AVERAGE(E32,G32,I32,E33,G33,I33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E34,G34,I34,E35,G35,I35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E36,G36,I36,E37,G37,I37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E38,G38,I38,E39,G39,I39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E40,G40,I40,E41,G41,I41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E42,G42,I42,E43,G43,I43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E44,G44,I44,E45,G45,I45)","v":{"$error":"#DIV/0!"}}]
[null,"PAD",null,{"$f":"AVERAGE(F32,H32,J32,F33,H33,J33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F34,H34,J34,F35,H35,J35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F36,H36,J36,F37,H37,J37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F38,H38,J38,F39,H39,J39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F40,H40,J40,F41,H41,J41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F42,H42,J42,F43,H43,J43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F44,H44,J44,F45,H45,J45)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Données 2 mesures"]
[null,null,"J1","J2","J3","J4","J5","J6","J7"]
[null,"PAS normale",135,135,135,135,135,135,135]
[null,"PAD normale",85,85,85,85,85,85,85]
[null,"PAS",{"$f":"AVERAGE(G32,I32,G33,I33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G34,I34,G35,I35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G36,I36,G37,I37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G38,I38,G39,I39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G40,I40,G41,I41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G42,I42,G43,I43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G44,I44,G45,I45)","v":{"$error":"#DIV/0!"}}]
[null,"PAD",{"$f":"AVERAGE(H32,J32,H33,J33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H34,J34,H35,J35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H36,J36,H37,J37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H38,J38,H39,J39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H40,J40,H41,J41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H42,J42,H43,J43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H44,J44,H45,J45)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Données 2 mesures en excluant le 1e jour"]
[null,null,"J2","J3","J4","J5","J6","J7"]
[null,"PAS normale",135,135,135,135,135,135]
[null,"PAD normale",85,85,85,85,85,85]
[null,"PAS",{"$f":"AVERAGE(G34,I34,G35,I35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G36,I36,G37,I37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G38,I38,G39,I39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G40,I40,G41,I41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G42,I42,G43,I43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G44,I44,G45,I45)","v":{"$error":"#DIV/0!"}}]
[null,"PAD",{"$f":"AVERAGE(H34,J34,H35,J35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H36,J36,H37,J37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H38,J38,H39,J39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H40,J40,H41,J41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H42,J42,H43,J43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H44,J44,H45,J45)","v":{"$error":"#DIV/0!"}}]

{"sheet":"MARS","index":4,"n_rows":83,"n_cols":10,"rows_kept":83,"merged":[[3,5,3,6],[3,8,3,9],[5,5,5,9],[7,5,7,9],[8,4,8,5],[8,7,8,8],[9,5,9,9],[11,5,11,9],[13,5,13,9],[15,5,15,9],[17,5,17,9],[19,5,19,9],[21,5,21,9],[23,5,23,9],[25,1,25,4],[25,6,25,9],[27,3,27,9],[29,1,30,3],[29,4,29,5],[29,6,29,7],[29,8,29,9],[31,1,32,2],[33,1,34,2],[35,1,36,2],[37,1,38,2],[39,1,40,2],[41,1,42,2],[43,1,44,2],[46,1,46,7],[47,1,47,8],[49,1,49,7],[50,1,50,8],[59,1,59,8],[63,1,63,9],[70,1,70,9],[77,1,77,9]]}
{"$rows_empty":25}
[null,{"$f":"CONCATENATE(F8,\" \",F6,\" \",F10,\" ans\")","v":"   ans"},{"$nulls":4},{"$f":"CONCATENATE(F12,\" kg\",\", \",F14, \" cm\",\", \",\"BMI = \",ROUND(((F12)/((F14/100)*(F14/100))),1))","v":{"$error":"#DIV/0!"}}]
[]
[null,"Traitement",null,{"$f":"CONCATENATE(F16,\"  \",F18,\"  \",F20,\"  \",F22,\"  \",F24)","v":"        "}]
[]
[null,{"$f":"CONCATENATE(\"Date\",\" : \",F4,\"/\",I4)","v":"Date : /"},null,null,"MESURE 1",null,"MESURE 2",null,"MESURE 3"]
[{"$nulls":4},"SYS","DIA","SYS","DIA","SYS","DIA"]
[null,"JOUR 1",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 2",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 3",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 4",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 5",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 6",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 7",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[]
[null,"3 mesures par série : moyenne quotidienne des 3 mesures de chaque série"]
[null,{"$f":"CONCATENATE(\"Automesure (\",F4,\"/\",I4,\") : \",\"PA = \",ROUND((AVERAGE(E32:E45,G32:G45,I32:I45)),0),\"/\",ROUND((AVERAGE(F32:F45,H32:H45,J32:J45)),0),\" mmHg, PA matin = \",ROUND((AVERAGE(E32,G32,I32,E34,G34,I34,E36,G36,I36,E38,G38,I38,E40,G40,I40,E42,G42,I42,E44,G44,I44)),0),\"/\",ROUND((AVERAGE(F32,H32,J32,F34,H34,J34,F36,H36,J36,F38,H38,J38,F40,H40,J40,F42,H42,J42,F44,H44,J44)),0),\" mmHg, PA soir = \", ROUND((AVERAGE(E33,G33,I33,E35,G35,I35,E37,G37,I37,E39,G39,I39,E41,G41,I41,E43,G43,I43,E45,G45,I45)),0),\"/\",ROUND((AVERAGE(F33,H33,J33,F35,H35,J35,F37,H37,J37,F39,H39,J39,F41,H41,J41,F43,H43,J43,F45,H45,J45)),0),\" mmHg\")","v":{"$error":"#DIV/0!"}}]
[]
[null,"2 mesures par série : exclusion de la première mesure de chaque série"]
[null,{"$f":"CONCATENATE(\"Automesure (\",F4,\"/\",I4,\") : \",\"PA = \",ROUND((AVERAGE(G32:G45,I32:I45)),0),\"/\",ROUND((AVERAGE(H32:H45,J32:J45)),0),\" mmHg, PA matin = \",ROUND((AVERAGE(G32,I32,G34,I34,G36,I36,G38,I38,G40,I40,G42,I42,G44,I44)),0),\"/\",ROUND((AVERAGE(H32,J32,H34,J34,H36,J36,H38,J38,H40,J40,H42,J42,H44,J44)),0),\" mmHg, PA soir = \", ROUND((AVERAGE(G33,I33,G35,I35,G37,I37,G39,I39,G41,I41,G43,I43,G45,I45)),0),\"/\",ROUND((AVERAGE(H33,J33,H35,J35,H37,J37,H39,J39,H41,J41,H43,J43,H45,J45)),0),\" mmHg\")","v":{"$error":"#DIV/0!"}}]
{"$rows_empty":7}
[null,"2 mesures par série sans J1 : exclusion de la première mesure de chaque série sans le 1e jour"]
[null,{"$f":"CONCATENATE(\"Automesure (\",F4,\"/\",I4,\") : \",\"PA = \",ROUND((AVERAGE(G34:G45,I34:I45)),0),\"/\",ROUND((AVERAGE(H34:H45,J34:J45)),0),\" mmHg, PA matin = \",ROUND((AVERAGE(G34,I34,G36,I36,G38,I38,G40,I40,G42,I42,G44,I44)),0),\"/\",ROUND((AVERAGE(H34,J34,H36,J36,H38,J38,H40,J40,H42,J42,H44,J44)),0),\" mmHg, PA soir = \", ROUND((AVERAGE(G35,I35,G37,I37,G39,I39,G41,I41,G43,I43,G45,I45)),0),\"/\",ROUND((AVERAGE(H35,J35,H37,J37,H39,J39,H41,J41,H43,J43,H45,J45)),0),\" mmHg\")","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,"Données 3 mesures"]
[{"$nulls":3},"J1","J2","J3","J4","J5","J6","J7"]
[null,"PAS normale",null,135,135,135,135,135,135,135]
[null,"PAD normale",null,85,85,85,85,85,85,85]
[null,"PAS",null,{"$f":"AVERAGE(E32,G32,I32,E33,G33,I33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E34,G34,I34,E35,G35,I35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E36,G36,I36,E37,G37,I37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E38,G38,I38,E39,G39,I39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E40,G40,I40,E41,G41,I41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E42,G42,I42,E43,G43,I43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E44,G44,I44,E45,G45,I45)","v":{"$error":"#DIV/0!"}}]
[null,"PAD",null,{"$f":"AVERAGE(F32,H32,J32,F33,H33,J33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F34,H34,J34,F35,H35,J35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F36,H36,J36,F37,H37,J37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F38,H38,J38,F39,H39,J39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F40,H40,J40,F41,H41,J41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F42,H42,J42,F43,H43,J43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F44,H44,J44,F45,H45,J45)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Données 2 mesures"]
[null,null,"J1","J2","J3","J4","J5","J6","J7"]
[null,"PAS normale",135,135,135,135,135,135,135]
[null,"PAD normale",85,85,85,85,85,85,85]
[null,"PAS",{"$f":"AVERAGE(G32,I32,G33,I33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G34,I34,G35,I35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G36,I36,G37,I37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G38,I38,G39,I39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G40,I40,G41,I41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G42,I42,G43,I43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G44,I44,G45,I45)","v":{"$error":"#DIV/0!"}}]
[null,"PAD",{"$f":"AVERAGE(H32,J32,H33,J33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H34,J34,H35,J35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H36,J36,H37,J37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H38,J38,H39,J39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H40,J40,H41,J41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H42,J42,H43,J43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H44,J44,H45,J45)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Données 2 mesures en excluant le 1e jour"]
[null,null,"J2","J3","J4","J5","J6","J7"]
[null,"PAS normale",135,135,135,135,135,135]
[null,"PAD normale",85,85,85,85,85,85]
[null,"PAS",{"$f":"AVERAGE(G34,I34,G35,I35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G36,I36,G37,I37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G38,I38,G39,I39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G40,I40,G41,I41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G42,I42,G43,I43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G44,I44,G45,I45)","v":{"$error":"#DIV/0!"}}]
[null,"PAD",{"$f":"AVERAGE(H34,J34,H35,J35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H36,J36,H37,J37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H38,J38,H39,J39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H40,J40,H41,J41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H42,J42,H43,J43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H44,J44,H45,J45)","v":{"$error":"#DIV/0!"}}]

{"sheet":"AVRIL","index":5,"n_rows":83,"n_cols":10,"rows_kept":83,"merged":[[3,5,3,6],[3,8,3,9],[5,5,5,9],[7,5,7,9],[8,4,8,5],[8,7,8,8],[9,5,9,9],[11,5,11,9],[13,5,13,9],[15,5,15,9],[17,5,17,9],[19,5,19,9],[21,5,21,9],[23,5,23,9],[25,1,25,4],[25,6,25,9],[27,3,27,9],[29,1,30,3],[29,4,29,5],[29,6,29,7],[29,8,29,9],[31,1,32,2],[33,1,34,2],[35,1,36,2],[37,1,38,2],[39,1,40,2],[41,1,42,2],[43,1,44,2],[46,1,46,7],[47,1,47,8],[49,1,49,7],[50,1,50,8],[59,1,59,8],[63,1,63,9],[70,1,70,9],[77,1,77,9]]}
{"$rows_empty":25}
[null,{"$f":"CONCATENATE(F8,\" \",F6,\" \",F10,\" ans\")","v":"   ans"},{"$nulls":4},{"$f":"CONCATENATE(F12,\" kg\",\", \",F14, \" cm\",\", \",\"BMI = \",ROUND(((F12)/((F14/100)*(F14/100))),1))","v":{"$error":"#DIV/0!"}}]
[]
[null,"Traitement",null,{"$f":"CONCATENATE(F16,\"  \",F18,\"  \",F20,\"  \",F22,\"  \",F24)","v":"        "}]
[]
[null,{"$f":"CONCATENATE(\"Date\",\" : \",F4,\"/\",I4)","v":"Date : /"},null,null,"MESURE 1",null,"MESURE 2",null,"MESURE 3"]
[{"$nulls":4},"SYS","DIA","SYS","DIA","SYS","DIA"]
[null,"JOUR 1",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 2",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 3",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 4",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 5",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 6",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 7",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[]
[null,"3 mesures par série : moyenne quotidienne des 3 mesures de chaque série"]
[null,{"$f":"CONCATENATE(\"Automesure (\",F4,\"/\",I4,\") : \",\"PA = \",ROUND((AVERAGE(E32:E45,G32:G45,I32:I45)),0),\"/\",ROUND((AVERAGE(F32:F45,H32:H45,J32:J45)),0),\" mmHg, PA matin = \",ROUND((AVERAGE(E32,G32,I32,E34,G34,I34,E36,G36,I36,E38,G38,I38,E40,G40,I40,E42,G42,I42,E44,G44,I44)),0),\"/\",ROUND((AVERAGE(F32,H32,J32,F34,H34,J34,F36,H36,J36,F38,H38,J38,F40,H40,J40,F42,H42,J42,F44,H44,J44)),0),\" mmHg, PA soir = \", ROUND((AVERAGE(E33,G33,I33,E35,G35,I35,E37,G37,I37,E39,G39,I39,E41,G41,I41,E43,G43,I43,E45,G45,I45)),0),\"/\",ROUND((AVERAGE(F33,H33,J33,F35,H35,J35,F37,H37,J37,F39,H39,J39,F41,H41,J41,F43,H43,J43,F45,H45,J45)),0),\" mmHg\")","v":{"$error":"#DIV/0!"}}]
[]
[null,"2 mesures par série : exclusion de la première mesure de chaque série"]
[null,{"$f":"CONCATENATE(\"Automesure (\",F4,\"/\",I4,\") : \",\"PA = \",ROUND((AVERAGE(G32:G45,I32:I45)),0),\"/\",ROUND((AVERAGE(H32:H45,J32:J45)),0),\" mmHg, PA matin = \",ROUND((AVERAGE(G32,I32,G34,I34,G36,I36,G38,I38,G40,I40,G42,I42,G44,I44)),0),\"/\",ROUND((AVERAGE(H32,J32,H34,J34,H36,J36,H38,J38,H40,J40,H42,J42,H44,J44)),0),\" mmHg, PA soir = \", ROUND((AVERAGE(G33,I33,G35,I35,G37,I37,G39,I39,G41,I41,G43,I43,G45,I45)),0),\"/\",ROUND((AVERAGE(H33,J33,H35,J35,H37,J37,H39,J39,H41,J41,H43,J43,H45,J45)),0),\" mmHg\")","v":{"$error":"#DIV/0!"}}]
{"$rows_empty":7}
[null,"2 mesures par série sans J1 : exclusion de la première mesure de chaque série sans le 1e jour"]
[null,{"$f":"CONCATENATE(\"Automesure (\",F4,\"/\",I4,\") : \",\"PA = \",ROUND((AVERAGE(G34:G45,I34:I45)),0),\"/\",ROUND((AVERAGE(H34:H45,J34:J45)),0),\" mmHg, PA matin = \",ROUND((AVERAGE(G34,I34,G36,I36,G38,I38,G40,I40,G42,I42,G44,I44)),0),\"/\",ROUND((AVERAGE(H34,J34,H36,J36,H38,J38,H40,J40,H42,J42,H44,J44)),0),\" mmHg, PA soir = \", ROUND((AVERAGE(G35,I35,G37,I37,G39,I39,G41,I41,G43,I43,G45,I45)),0),\"/\",ROUND((AVERAGE(H35,J35,H37,J37,H39,J39,H41,J41,H43,J43,H45,J45)),0),\" mmHg\")","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,"Données 3 mesures"]
[{"$nulls":3},"J1","J2","J3","J4","J5","J6","J7"]
[null,"PAS normale",null,135,135,135,135,135,135,135]
[null,"PAD normale",null,85,85,85,85,85,85,85]
[null,"PAS",null,{"$f":"AVERAGE(E32,G32,I32,E33,G33,I33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E34,G34,I34,E35,G35,I35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E36,G36,I36,E37,G37,I37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E38,G38,I38,E39,G39,I39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E40,G40,I40,E41,G41,I41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E42,G42,I42,E43,G43,I43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E44,G44,I44,E45,G45,I45)","v":{"$error":"#DIV/0!"}}]
[null,"PAD",null,{"$f":"AVERAGE(F32,H32,J32,F33,H33,J33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F34,H34,J34,F35,H35,J35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F36,H36,J36,F37,H37,J37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F38,H38,J38,F39,H39,J39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F40,H40,J40,F41,H41,J41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F42,H42,J42,F43,H43,J43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F44,H44,J44,F45,H45,J45)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Données 2 mesures"]
[null,null,"J1","J2","J3","J4","J5","J6","J7"]
[null,"PAS normale",135,135,135,135,135,135,135]
[null,"PAD normale",85,85,85,85,85,85,85]
[null,"PAS",{"$f":"AVERAGE(G32,I32,G33,I33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G34,I34,G35,I35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G36,I36,G37,I37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G38,I38,G39,I39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G40,I40,G41,I41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G42,I42,G43,I43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G44,I44,G45,I45)","v":{"$error":"#DIV/0!"}}]
[null,"PAD",{"$f":"AVERAGE(H32,J32,H33,J33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H34,J34,H35,J35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H36,J36,H37,J37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H38,J38,H39,J39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H40,J40,H41,J41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H42,J42,H43,J43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H44,J44,H45,J45)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Données 2 mesures en excluant le 1e jour"]
[null,null,"J2","J3","J4","J5","J6","J7"]
[null,"PAS normale",135,135,135,135,135,135]
[null,"PAD normale",85,85,85,85,85,85]
[null,"PAS",{"$f":"AVERAGE(G34,I34,G35,I35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G36,I36,G37,I37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G38,I38,G39,I39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G40,I40,G41,I41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G42,I42,G43,I43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G44,I44,G45,I45)","v":{"$error":"#DIV/0!"}}]
[null,"PAD",{"$f":"AVERAGE(H34,J34,H35,J35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H36,J36,H37,J37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H38,J38,H39,J39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H40,J40,H41,J41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H42,J42,H43,J43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H44,J44,H45,J45)","v":{"$error":"#DIV/0!"}}]

{"sheet":"MAI","index":6,"n_rows":83,"n_cols":10,"rows_kept":83,"merged":[[3,5,3,6],[3,8,3,9],[5,5,5,9],[7,5,7,9],[8,4,8,5],[8,7,8,8],[9,5,9,9],[11,5,11,9],[13,5,13,9],[15,5,15,9],[17,5,17,9],[19,5,19,9],[21,5,21,9],[23,5,23,9],[25,1,25,4],[25,6,25,9],[27,3,27,9],[29,1,30,3],[29,4,29,5],[29,6,29,7],[29,8,29,9],[31,1,32,2],[33,1,34,2],[35,1,36,2],[37,1,38,2],[39,1,40,2],[41,1,42,2],[43,1,44,2],[46,1,46,7],[47,1,47,8],[49,1,49,7],[50,1,50,8],[59,1,59,8],[63,1,63,9],[70,1,70,9],[77,1,77,9]]}
{"$rows_empty":25}
[null,{"$f":"CONCATENATE(F8,\" \",F6,\" \",F10,\" ans\")","v":"   ans"},{"$nulls":4},{"$f":"CONCATENATE(F12,\" kg\",\", \",F14, \" cm\",\", \",\"BMI = \",ROUND(((F12)/((F14/100)*(F14/100))),1))","v":{"$error":"#DIV/0!"}}]
[]
[null,"Traitement",null,{"$f":"CONCATENATE(F16,\"  \",F18,\"  \",F20,\"  \",F22,\"  \",F24)","v":"        "}]
[]
[null,{"$f":"CONCATENATE(\"Date\",\" : \",F4,\"/\",I4)","v":"Date : /"},null,null,"MESURE 1",null,"MESURE 2",null,"MESURE 3"]
[{"$nulls":4},"SYS","DIA","SYS","DIA","SYS","DIA"]
[null,"JOUR 1",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 2",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 3",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 4",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 5",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 6",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 7",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[]
[null,"3 mesures par série : moyenne quotidienne des 3 mesures de chaque série"]
[null,{"$f":"CONCATENATE(\"Automesure (\",F4,\"/\",I4,\") : \",\"PA = \",ROUND((AVERAGE(E32:E45,G32:G45,I32:I45)),0),\"/\",ROUND((AVERAGE(F32:F45,H32:H45,J32:J45)),0),\" mmHg, PA matin = \",ROUND((AVERAGE(E32,G32,I32,E34,G34,I34,E36,G36,I36,E38,G38,I38,E40,G40,I40,E42,G42,I42,E44,G44,I44)),0),\"/\",ROUND((AVERAGE(F32,H32,J32,F34,H34,J34,F36,H36,J36,F38,H38,J38,F40,H40,J40,F42,H42,J42,F44,H44,J44)),0),\" mmHg, PA soir = \", ROUND((AVERAGE(E33,G33,I33,E35,G35,I35,E37,G37,I37,E39,G39,I39,E41,G41,I41,E43,G43,I43,E45,G45,I45)),0),\"/\",ROUND((AVERAGE(F33,H33,J33,F35,H35,J35,F37,H37,J37,F39,H39,J39,F41,H41,J41,F43,H43,J43,F45,H45,J45)),0),\" mmHg\")","v":{"$error":"#DIV/0!"}}]
[]
[null,"2 mesures par série : exclusion de la première mesure de chaque série"]
[null,{"$f":"CONCATENATE(\"Automesure (\",F4,\"/\",I4,\") : \",\"PA = \",ROUND((AVERAGE(G32:G45,I32:I45)),0),\"/\",ROUND((AVERAGE(H32:H45,J32:J45)),0),\" mmHg, PA matin = \",ROUND((AVERAGE(G32,I32,G34,I34,G36,I36,G38,I38,G40,I40,G42,I42,G44,I44)),0),\"/\",ROUND((AVERAGE(H32,J32,H34,J34,H36,J36,H38,J38,H40,J40,H42,J42,H44,J44)),0),\" mmHg, PA soir = \", ROUND((AVERAGE(G33,I33,G35,I35,G37,I37,G39,I39,G41,I41,G43,I43,G45,I45)),0),\"/\",ROUND((AVERAGE(H33,J33,H35,J35,H37,J37,H39,J39,H41,J41,H43,J43,H45,J45)),0),\" mmHg\")","v":{"$error":"#DIV/0!"}}]
{"$rows_empty":7}
[null,"2 mesures par série sans J1 : exclusion de la première mesure de chaque série sans le 1e jour"]
[null,{"$f":"CONCATENATE(\"Automesure (\",F4,\"/\",I4,\") : \",\"PA = \",ROUND((AVERAGE(G34:G45,I34:I45)),0),\"/\",ROUND((AVERAGE(H34:H45,J34:J45)),0),\" mmHg, PA matin = \",ROUND((AVERAGE(G34,I34,G36,I36,G38,I38,G40,I40,G42,I42,G44,I44)),0),\"/\",ROUND((AVERAGE(H34,J34,H36,J36,H38,J38,H40,J40,H42,J42,H44,J44)),0),\" mmHg, PA soir = \", ROUND((AVERAGE(G35,I35,G37,I37,G39,I39,G41,I41,G43,I43,G45,I45)),0),\"/\",ROUND((AVERAGE(H35,J35,H37,J37,H39,J39,H41,J41,H43,J43,H45,J45)),0),\" mmHg\")","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,"Données 3 mesures"]
[{"$nulls":3},"J1","J2","J3","J4","J5","J6","J7"]
[null,"PAS normale",null,135,135,135,135,135,135,135]
[null,"PAD normale",null,85,85,85,85,85,85,85]
[null,"PAS",null,{"$f":"AVERAGE(E32,G32,I32,E33,G33,I33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E34,G34,I34,E35,G35,I35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E36,G36,I36,E37,G37,I37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E38,G38,I38,E39,G39,I39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E40,G40,I40,E41,G41,I41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E42,G42,I42,E43,G43,I43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E44,G44,I44,E45,G45,I45)","v":{"$error":"#DIV/0!"}}]
[null,"PAD",null,{"$f":"AVERAGE(F32,H32,J32,F33,H33,J33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F34,H34,J34,F35,H35,J35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F36,H36,J36,F37,H37,J37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F38,H38,J38,F39,H39,J39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F40,H40,J40,F41,H41,J41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F42,H42,J42,F43,H43,J43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F44,H44,J44,F45,H45,J45)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Données 2 mesures"]
[null,null,"J1","J2","J3","J4","J5","J6","J7"]
[null,"PAS normale",135,135,135,135,135,135,135]
[null,"PAD normale",85,85,85,85,85,85,85]
[null,"PAS",{"$f":"AVERAGE(G32,I32,G33,I33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G34,I34,G35,I35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G36,I36,G37,I37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G38,I38,G39,I39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G40,I40,G41,I41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G42,I42,G43,I43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G44,I44,G45,I45)","v":{"$error":"#DIV/0!"}}]
[null,"PAD",{"$f":"AVERAGE(H32,J32,H33,J33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H34,J34,H35,J35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H36,J36,H37,J37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H38,J38,H39,J39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H40,J40,H41,J41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H42,J42,H43,J43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H44,J44,H45,J45)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Données 2 mesures en excluant le 1e jour"]
[null,null,"J2","J3","J4","J5","J6","J7"]
[null,"PAS normale",135,135,135,135,135,135]
[null,"PAD normale",85,85,85,85,85,85]
[null,"PAS",{"$f":"AVERAGE(G34,I34,G35,I35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G36,I36,G37,I37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G38,I38,G39,I39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G40,I40,G41,I41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G42,I42,G43,I43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G44,I44,G45,I45)","v":{"$error":"#DIV/0!"}}]
[null,"PAD",{"$f":"AVERAGE(H34,J34,H35,J35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H36,J36,H37,J37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H38,J38,H39,J39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H40,J40,H41,J41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H42,J42,H43,J43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H44,J44,H45,J45)","v":{"$error":"#DIV/0!"}}]

{"sheet":"JUIN","index":7,"n_rows":83,"n_cols":10,"rows_kept":83,"merged":[[3,5,3,6],[3,8,3,9],[5,5,5,9],[7,5,7,9],[8,4,8,5],[8,7,8,8],[9,5,9,9],[11,5,11,9],[13,5,13,9],[15,5,15,9],[17,5,17,9],[19,5,19,9],[21,5,21,9],[23,5,23,9],[25,1,25,4],[25,6,25,9],[27,3,27,9],[29,1,30,3],[29,4,29,5],[29,6,29,7],[29,8,29,9],[31,1,32,2],[33,1,34,2],[35,1,36,2],[37,1,38,2],[39,1,40,2],[41,1,42,2],[43,1,44,2],[46,1,46,7],[47,1,47,8],[49,1,49,7],[50,1,50,8],[59,1,59,8],[63,1,63,9],[70,1,70,9],[77,1,77,9]]}
{"$rows_empty":25}
[null,{"$f":"CONCATENATE(F8,\" \",F6,\" \",F10,\" ans\")","v":"   ans"},{"$nulls":4},{"$f":"CONCATENATE(F12,\" kg\",\", \",F14, \" cm\",\", \",\"BMI = \",ROUND(((F12)/((F14/100)*(F14/100))),1))","v":{"$error":"#DIV/0!"}}]
[]
[null,"Traitement",null,{"$f":"CONCATENATE(F16,\"  \",F18,\"  \",F20,\"  \",F22,\"  \",F24)","v":"        "}]
[]
[null,{"$f":"CONCATENATE(\"Date\",\" : \",F4,\"/\",I4)","v":"Date : /"},null,null,"MESURE 1",null,"MESURE 2",null,"MESURE 3"]
[{"$nulls":4},"SYS","DIA","SYS","DIA","SYS","DIA"]
[null,"JOUR 1",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 2",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 3",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 4",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 5",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 6",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 7",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[]
[null,"3 mesures par série : moyenne quotidienne des 3 mesures de chaque série"]
[null,{"$f":"CONCATENATE(\"Automesure (\",F4,\"/\",I4,\") : \",\"PA = \",ROUND((AVERAGE(E32:E45,G32:G45,I32:I45)),0),\"/\",ROUND((AVERAGE(F32:F45,H32:H45,J32:J45)),0),\" mmHg, PA matin = \",ROUND((AVERAGE(E32,G32,I32,E34,G34,I34,E36,G36,I36,E38,G38,I38,E40,G40,I40,E42,G42,I42,E44,G44,I44)),0),\"/\",ROUND((AVERAGE(F32,H32,J32,F34,H34,J34,F36,H36,J36,F38,H38,J38,F40,H40,J40,F42,H42,J42,F44,H44,J44)),0),\" mmHg, PA soir = \", ROUND((AVERAGE(E33,G33,I33,E35,G35,I35,E37,G37,I37,E39,G39,I39,E41,G41,I41,E43,G43,I43,E45,G45,I45)),0),\"/\",ROUND((AVERAGE(F33,H33,J33,F35,H35,J35,F37,H37,J37,F39,H39,J39,F41,H41,J41,F43,H43,J43,F45,H45,J45)),0),\" mmHg\")","v":{"$error":"#DIV/0!"}}]
[]
[null,"2 mesures par série : exclusion de la première mesure de chaque série"]
[null,{"$f":"CONCATENATE(\"Automesure (\",F4,\"/\",I4,\") : \",\"PA = \",ROUND((AVERAGE(G32:G45,I32:I45)),0),\"/\",ROUND((AVERAGE(H32:H45,J32:J45)),0),\" mmHg, PA matin = \",ROUND((AVERAGE(G32,I32,G34,I34,G36,I36,G38,I38,G40,I40,G42,I42,G44,I44)),0),\"/\",ROUND((AVERAGE(H32,J32,H34,J34,H36,J36,H38,J38,H40,J40,H42,J42,H44,J44)),0),\" mmHg, PA soir = \", ROUND((AVERAGE(G33,I33,G35,I35,G37,I37,G39,I39,G41,I41,G43,I43,G45,I45)),0),\"/\",ROUND((AVERAGE(H33,J33,H35,J35,H37,J37,H39,J39,H41,J41,H43,J43,H45,J45)),0),\" mmHg\")","v":{"$error":"#DIV/0!"}}]
{"$rows_empty":7}
[null,"2 mesures par série sans J1 : exclusion de la première mesure de chaque série sans le 1e jour"]
[null,{"$f":"CONCATENATE(\"Automesure (\",F4,\"/\",I4,\") : \",\"PA = \",ROUND((AVERAGE(G34:G45,I34:I45)),0),\"/\",ROUND((AVERAGE(H34:H45,J34:J45)),0),\" mmHg, PA matin = \",ROUND((AVERAGE(G34,I34,G36,I36,G38,I38,G40,I40,G42,I42,G44,I44)),0),\"/\",ROUND((AVERAGE(H34,J34,H36,J36,H38,J38,H40,J40,H42,J42,H44,J44)),0),\" mmHg, PA soir = \", ROUND((AVERAGE(G35,I35,G37,I37,G39,I39,G41,I41,G43,I43,G45,I45)),0),\"/\",ROUND((AVERAGE(H35,J35,H37,J37,H39,J39,H41,J41,H43,J43,H45,J45)),0),\" mmHg\")","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,"Données 3 mesures"]
[{"$nulls":3},"J1","J2","J3","J4","J5","J6","J7"]
[null,"PAS normale",null,135,135,135,135,135,135,135]
[null,"PAD normale",null,85,85,85,85,85,85,85]
[null,"PAS",null,{"$f":"AVERAGE(E32,G32,I32,E33,G33,I33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E34,G34,I34,E35,G35,I35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E36,G36,I36,E37,G37,I37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E38,G38,I38,E39,G39,I39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E40,G40,I40,E41,G41,I41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E42,G42,I42,E43,G43,I43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E44,G44,I44,E45,G45,I45)","v":{"$error":"#DIV/0!"}}]
[null,"PAD",null,{"$f":"AVERAGE(F32,H32,J32,F33,H33,J33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F34,H34,J34,F35,H35,J35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F36,H36,J36,F37,H37,J37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F38,H38,J38,F39,H39,J39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F40,H40,J40,F41,H41,J41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F42,H42,J42,F43,H43,J43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F44,H44,J44,F45,H45,J45)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Données 2 mesures"]
[null,null,"J1","J2","J3","J4","J5","J6","J7"]
[null,"PAS normale",135,135,135,135,135,135,135]
[null,"PAD normale",85,85,85,85,85,85,85]
[null,"PAS",{"$f":"AVERAGE(G32,I32,G33,I33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G34,I34,G35,I35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G36,I36,G37,I37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G38,I38,G39,I39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G40,I40,G41,I41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G42,I42,G43,I43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G44,I44,G45,I45)","v":{"$error":"#DIV/0!"}}]
[null,"PAD",{"$f":"AVERAGE(H32,J32,H33,J33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H34,J34,H35,J35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H36,J36,H37,J37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H38,J38,H39,J39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H40,J40,H41,J41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H42,J42,H43,J43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H44,J44,H45,J45)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Données 2 mesures en excluant le 1e jour"]
[null,null,"J2","J3","J4","J5","J6","J7"]
[null,"PAS normale",135,135,135,135,135,135]
[null,"PAD normale",85,85,85,85,85,85]
[null,"PAS",{"$f":"AVERAGE(G34,I34,G35,I35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G36,I36,G37,I37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G38,I38,G39,I39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G40,I40,G41,I41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G42,I42,G43,I43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G44,I44,G45,I45)","v":{"$error":"#DIV/0!"}}]
[null,"PAD",{"$f":"AVERAGE(H34,J34,H35,J35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H36,J36,H37,J37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H38,J38,H39,J39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H40,J40,H41,J41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H42,J42,H43,J43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H44,J44,H45,J45)","v":{"$error":"#DIV/0!"}}]

{"sheet":"JUILLET","index":8,"n_rows":83,"n_cols":10,"rows_kept":83,"merged":[[3,5,3,6],[3,8,3,9],[5,5,5,9],[7,5,7,9],[8,4,8,5],[8,7,8,8],[9,5,9,9],[11,5,11,9],[13,5,13,9],[15,5,15,9],[17,5,17,9],[19,5,19,9],[21,5,21,9],[23,5,23,9],[25,1,25,4],[25,6,25,9],[27,3,27,9],[29,1,30,3],[29,4,29,5],[29,6,29,7],[29,8,29,9],[31,1,32,2],[33,1,34,2],[35,1,36,2],[37,1,38,2],[39,1,40,2],[41,1,42,2],[43,1,44,2],[46,1,46,7],[47,1,47,8],[49,1,49,7],[50,1,50,8],[59,1,59,8],[63,1,63,9],[70,1,70,9],[77,1,77,9]]}
{"$rows_empty":25}
[null,{"$f":"CONCATENATE(F8,\" \",F6,\" \",F10,\" ans\")","v":"   ans"},{"$nulls":4},{"$f":"CONCATENATE(F12,\" kg\",\", \",F14, \" cm\",\", \",\"BMI = \",ROUND(((F12)/((F14/100)*(F14/100))),1))","v":{"$error":"#DIV/0!"}}]
[]
[null,"Traitement",null,{"$f":"CONCATENATE(F16,\"  \",F18,\"  \",F20,\"  \",F22,\"  \",F24)","v":"        "}]
[]
[null,{"$f":"CONCATENATE(\"Date\",\" : \",F4,\"/\",I4)","v":"Date : /"},null,null,"MESURE 1",null,"MESURE 2",null,"MESURE 3"]
[{"$nulls":4},"SYS","DIA","SYS","DIA","SYS","DIA"]
[null,"JOUR 1",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 2",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 3",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 4",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 5",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 6",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 7",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[]
[null,"3 mesures par série : moyenne quotidienne des 3 mesures de chaque série"]
[null,{"$f":"CONCATENATE(\"Automesure (\",F4,\"/\",I4,\") : \",\"PA = \",ROUND((AVERAGE(E32:E45,G32:G45,I32:I45)),0),\"/\",ROUND((AVERAGE(F32:F45,H32:H45,J32:J45)),0),\" mmHg, PA matin = \",ROUND((AVERAGE(E32,G32,I32,E34,G34,I34,E36,G36,I36,E38,G38,I38,E40,G40,I40,E42,G42,I42,E44,G44,I44)),0),\"/\",ROUND((AVERAGE(F32,H32,J32,F34,H34,J34,F36,H36,J36,F38,H38,J38,F40,H40,J40,F42,H42,J42,F44,H44,J44)),0),\" mmHg, PA soir = \", ROUND((AVERAGE(E33,G33,I33,E35,G35,I35,E37,G37,I37,E39,G39,I39,E41,G41,I41,E43,G43,I43,E45,G45,I45)),0),\"/\",ROUND((AVERAGE(F33,H33,J33,F35,H35,J35,F37,H37,J37,F39,H39,J39,F41,H41,J41,F43,H43,J43,F45,H45,J45)),0),\" mmHg\")","v":{"$error":"#DIV/0!"}}]
[]
[null,"2 mesures par série : exclusion de la première mesure de chaque série"]
[null,{"$f":"CONCATENATE(\"Automesure (\",F4,\"/\",I4,\") : \",\"PA = \",ROUND((AVERAGE(G32:G45,I32:I45)),0),\"/\",ROUND((AVERAGE(H32:H45,J32:J45)),0),\" mmHg, PA matin = \",ROUND((AVERAGE(G32,I32,G34,I34,G36,I36,G38,I38,G40,I40,G42,I42,G44,I44)),0),\"/\",ROUND((AVERAGE(H32,J32,H34,J34,H36,J36,H38,J38,H40,J40,H42,J42,H44,J44)),0),\" mmHg, PA soir = \", ROUND((AVERAGE(G33,I33,G35,I35,G37,I37,G39,I39,G41,I41,G43,I43,G45,I45)),0),\"/\",ROUND((AVERAGE(H33,J33,H35,J35,H37,J37,H39,J39,H41,J41,H43,J43,H45,J45)),0),\" mmHg\")","v":{"$error":"#DIV/0!"}}]
{"$rows_empty":7}
[null,"2 mesures par série sans J1 : exclusion de la première mesure de chaque série sans le 1e jour"]
[null,{"$f":"CONCATENATE(\"Automesure (\",F4,\"/\",I4,\") : \",\"PA = \",ROUND((AVERAGE(G34:G45,I34:I45)),0),\"/\",ROUND((AVERAGE(H34:H45,J34:J45)),0),\" mmHg, PA matin = \",ROUND((AVERAGE(G34,I34,G36,I36,G38,I38,G40,I40,G42,I42,G44,I44)),0),\"/\",ROUND((AVERAGE(H34,J34,H36,J36,H38,J38,H40,J40,H42,J42,H44,J44)),0),\" mmHg, PA soir = \", ROUND((AVERAGE(G35,I35,G37,I37,G39,I39,G41,I41,G43,I43,G45,I45)),0),\"/\",ROUND((AVERAGE(H35,J35,H37,J37,H39,J39,H41,J41,H43,J43,H45,J45)),0),\" mmHg\")","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,"Données 3 mesures"]
[{"$nulls":3},"J1","J2","J3","J4","J5","J6","J7"]
[null,"PAS normale",null,135,135,135,135,135,135,135]
[null,"PAD normale",null,85,85,85,85,85,85,85]
[null,"PAS",null,{"$f":"AVERAGE(E32,G32,I32,E33,G33,I33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E34,G34,I34,E35,G35,I35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E36,G36,I36,E37,G37,I37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E38,G38,I38,E39,G39,I39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E40,G40,I40,E41,G41,I41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E42,G42,I42,E43,G43,I43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E44,G44,I44,E45,G45,I45)","v":{"$error":"#DIV/0!"}}]
[null,"PAD",null,{"$f":"AVERAGE(F32,H32,J32,F33,H33,J33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F34,H34,J34,F35,H35,J35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F36,H36,J36,F37,H37,J37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F38,H38,J38,F39,H39,J39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F40,H40,J40,F41,H41,J41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F42,H42,J42,F43,H43,J43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F44,H44,J44,F45,H45,J45)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Données 2 mesures"]
[null,null,"J1","J2","J3","J4","J5","J6","J7"]
[null,"PAS normale",135,135,135,135,135,135,135]
[null,"PAD normale",85,85,85,85,85,85,85]
[null,"PAS",{"$f":"AVERAGE(G32,I32,G33,I33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G34,I34,G35,I35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G36,I36,G37,I37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G38,I38,G39,I39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G40,I40,G41,I41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G42,I42,G43,I43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G44,I44,G45,I45)","v":{"$error":"#DIV/0!"}}]
[null,"PAD",{"$f":"AVERAGE(H32,J32,H33,J33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H34,J34,H35,J35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H36,J36,H37,J37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H38,J38,H39,J39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H40,J40,H41,J41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H42,J42,H43,J43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H44,J44,H45,J45)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Données 2 mesures en excluant le 1e jour"]
[null,null,"J2","J3","J4","J5","J6","J7"]
[null,"PAS normale",135,135,135,135,135,135]
[null,"PAD normale",85,85,85,85,85,85]
[null,"PAS",{"$f":"AVERAGE(G34,I34,G35,I35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G36,I36,G37,I37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G38,I38,G39,I39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G40,I40,G41,I41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G42,I42,G43,I43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G44,I44,G45,I45)","v":{"$error":"#DIV/0!"}}]
[null,"PAD",{"$f":"AVERAGE(H34,J34,H35,J35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H36,J36,H37,J37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H38,J38,H39,J39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H40,J40,H41,J41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H42,J42,H43,J43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H44,J44,H45,J45)","v":{"$error":"#DIV/0!"}}]

{"sheet":"AOUT","index":9,"n_rows":83,"n_cols":10,"rows_kept":83,"merged":[[3,5,3,6],[3,8,3,9],[5,5,5,9],[7,5,7,9],[8,4,8,5],[8,7,8,8],[9,5,9,9],[11,5,11,9],[13,5,13,9],[15,5,15,9],[17,5,17,9],[19,5,19,9],[21,5,21,9],[23,5,23,9],[25,1,25,4],[25,6,25,9],[27,3,27,9],[29,1,30,3],[29,4,29,5],[29,6,29,7],[29,8,29,9],[31,1,32,2],[33,1,34,2],[35,1,36,2],[37,1,38,2],[39,1,40,2],[41,1,42,2],[43,1,44,2],[46,1,46,7],[47,1,47,8],[49,1,49,7],[50,1,50,8],[59,1,59,8],[63,1,63,9],[70,1,70,9],[77,1,77,9]]}
{"$rows_empty":25}
[null,{"$f":"CONCATENATE(F8,\" \",F6,\" \",F10,\" ans\")","v":"   ans"},{"$nulls":4},{"$f":"CONCATENATE(F12,\" kg\",\", \",F14, \" cm\",\", \",\"BMI = \",ROUND(((F12)/((F14/100)*(F14/100))),1))","v":{"$error":"#DIV/0!"}}]
[]
[null,"Traitement",null,{"$f":"CONCATENATE(F16,\"  \",F18,\"  \",F20,\"  \",F22,\"  \",F24)","v":"        "}]
[]
[null,{"$f":"CONCATENATE(\"Date\",\" : \",F4,\"/\",I4)","v":"Date : /"},null,null,"MESURE 1",null,"MESURE 2",null,"MESURE 3"]
[{"$nulls":4},"SYS","DIA","SYS","DIA","SYS","DIA"]
[null,"JOUR 1",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 2",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 3",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 4",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 5",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 6",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 7",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[]
[null,"3 mesures par série : moyenne quotidienne des 3 mesures de chaque série"]
[null,{"$f":"CONCATENATE(\"Automesure (\",F4,\"/\",I4,\") : \",\"PA = \",ROUND((AVERAGE(E32:E45,G32:G45,I32:I45)),0),\"/\",ROUND((AVERAGE(F32:F45,H32:H45,J32:J45)),0),\" mmHg, PA matin = \",ROUND((AVERAGE(E32,G32,I32,E34,G34,I34,E36,G36,I36,E38,G38,I38,E40,G40,I40,E42,G42,I42,E44,G44,I44)),0),\"/\",ROUND((AVERAGE(F32,H32,J32,F34,H34,J34,F36,H36,J36,F38,H38,J38,F40,H40,J40,F42,H42,J42,F44,H44,J44)),0),\" mmHg, PA soir = \", ROUND((AVERAGE(E33,G33,I33,E35,G35,I35,E37,G37,I37,E39,G39,I39,E41,G41,I41,E43,G43,I43,E45,G45,I45)),0),\"/\",ROUND((AVERAGE(F33,H33,J33,F35,H35,J35,F37,H37,J37,F39,H39,J39,F41,H41,J41,F43,H43,J43,F45,H45,J45)),0),\" mmHg\")","v":{"$error":"#DIV/0!"}}]
[]
[null,"2 mesures par série : exclusion de la première mesure de chaque série"]
[null,{"$f":"CONCATENATE(\"Automesure (\",F4,\"/\",I4,\") : \",\"PA = \",ROUND((AVERAGE(G32:G45,I32:I45)),0),\"/\",ROUND((AVERAGE(H32:H45,J32:J45)),0),\" mmHg, PA matin = \",ROUND((AVERAGE(G32,I32,G34,I34,G36,I36,G38,I38,G40,I40,G42,I42,G44,I44)),0),\"/\",ROUND((AVERAGE(H32,J32,H34,J34,H36,J36,H38,J38,H40,J40,H42,J42,H44,J44)),0),\" mmHg, PA soir = \", ROUND((AVERAGE(G33,I33,G35,I35,G37,I37,G39,I39,G41,I41,G43,I43,G45,I45)),0),\"/\",ROUND((AVERAGE(H33,J33,H35,J35,H37,J37,H39,J39,H41,J41,H43,J43,H45,J45)),0),\" mmHg\")","v":{"$error":"#DIV/0!"}}]
{"$rows_empty":7}
[null,"2 mesures par série sans J1 : exclusion de la première mesure de chaque série sans le 1e jour"]
[null,{"$f":"CONCATENATE(\"Automesure (\",F4,\"/\",I4,\") : \",\"PA = \",ROUND((AVERAGE(G34:G45,I34:I45)),0),\"/\",ROUND((AVERAGE(H34:H45,J34:J45)),0),\" mmHg, PA matin = \",ROUND((AVERAGE(G34,I34,G36,I36,G38,I38,G40,I40,G42,I42,G44,I44)),0),\"/\",ROUND((AVERAGE(H34,J34,H36,J36,H38,J38,H40,J40,H42,J42,H44,J44)),0),\" mmHg, PA soir = \", ROUND((AVERAGE(G35,I35,G37,I37,G39,I39,G41,I41,G43,I43,G45,I45)),0),\"/\",ROUND((AVERAGE(H35,J35,H37,J37,H39,J39,H41,J41,H43,J43,H45,J45)),0),\" mmHg\")","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,"Données 3 mesures"]
[{"$nulls":3},"J1","J2","J3","J4","J5","J6","J7"]
[null,"PAS normale",null,135,135,135,135,135,135,135]
[null,"PAD normale",null,85,85,85,85,85,85,85]
[null,"PAS",null,{"$f":"AVERAGE(E32,G32,I32,E33,G33,I33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E34,G34,I34,E35,G35,I35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E36,G36,I36,E37,G37,I37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E38,G38,I38,E39,G39,I39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E40,G40,I40,E41,G41,I41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E42,G42,I42,E43,G43,I43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E44,G44,I44,E45,G45,I45)","v":{"$error":"#DIV/0!"}}]
[null,"PAD",null,{"$f":"AVERAGE(F32,H32,J32,F33,H33,J33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F34,H34,J34,F35,H35,J35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F36,H36,J36,F37,H37,J37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F38,H38,J38,F39,H39,J39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F40,H40,J40,F41,H41,J41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F42,H42,J42,F43,H43,J43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F44,H44,J44,F45,H45,J45)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Données 2 mesures"]
[null,null,"J1","J2","J3","J4","J5","J6","J7"]
[null,"PAS normale",135,135,135,135,135,135,135]
[null,"PAD normale",85,85,85,85,85,85,85]
[null,"PAS",{"$f":"AVERAGE(G32,I32,G33,I33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G34,I34,G35,I35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G36,I36,G37,I37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G38,I38,G39,I39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G40,I40,G41,I41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G42,I42,G43,I43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G44,I44,G45,I45)","v":{"$error":"#DIV/0!"}}]
[null,"PAD",{"$f":"AVERAGE(H32,J32,H33,J33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H34,J34,H35,J35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H36,J36,H37,J37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H38,J38,H39,J39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H40,J40,H41,J41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H42,J42,H43,J43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H44,J44,H45,J45)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Données 2 mesures en excluant le 1e jour"]
[null,null,"J2","J3","J4","J5","J6","J7"]
[null,"PAS normale",135,135,135,135,135,135]
[null,"PAD normale",85,85,85,85,85,85]
[null,"PAS",{"$f":"AVERAGE(G34,I34,G35,I35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G36,I36,G37,I37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G38,I38,G39,I39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G40,I40,G41,I41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G42,I42,G43,I43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G44,I44,G45,I45)","v":{"$error":"#DIV/0!"}}]
[null,"PAD",{"$f":"AVERAGE(H34,J34,H35,J35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H36,J36,H37,J37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H38,J38,H39,J39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H40,J40,H41,J41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H42,J42,H43,J43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H44,J44,H45,J45)","v":{"$error":"#DIV/0!"}}]

{"sheet":"SEPT","index":10,"n_rows":83,"n_cols":10,"rows_kept":83,"merged":[[3,5,3,6],[3,8,3,9],[5,5,5,9],[7,5,7,9],[8,4,8,5],[8,7,8,8],[9,5,9,9],[11,5,11,9],[13,5,13,9],[15,5,15,9],[17,5,17,9],[19,5,19,9],[21,5,21,9],[23,5,23,9],[25,1,25,4],[25,6,25,9],[27,3,27,9],[29,1,30,3],[29,4,29,5],[29,6,29,7],[29,8,29,9],[31,1,32,2],[33,1,34,2],[35,1,36,2],[37,1,38,2],[39,1,40,2],[41,1,42,2],[43,1,44,2],[46,1,46,7],[47,1,47,8],[49,1,49,7],[50,1,50,8],[59,1,59,8],[63,1,63,9],[70,1,70,9],[77,1,77,9]]}
{"$rows_empty":25}
[null,{"$f":"CONCATENATE(F8,\" \",F6,\" \",F10,\" ans\")","v":"   ans"},{"$nulls":4},{"$f":"CONCATENATE(F12,\" kg\",\", \",F14, \" cm\",\", \",\"BMI = \",ROUND(((F12)/((F14/100)*(F14/100))),1))","v":{"$error":"#DIV/0!"}}]
[]
[null,"Traitement",null,{"$f":"CONCATENATE(F16,\"  \",F18,\"  \",F20,\"  \",F22,\"  \",F24)","v":"        "}]
[]
[null,{"$f":"CONCATENATE(\"Date\",\" : \",F4,\"/\",I4)","v":"Date : /"},null,null,"MESURE 1",null,"MESURE 2",null,"MESURE 3"]
[{"$nulls":4},"SYS","DIA","SYS","DIA","SYS","DIA"]
[null,"JOUR 1",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 2",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 3",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 4",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 5",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 6",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 7",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[]
[null,"3 mesures par série : moyenne quotidienne des 3 mesures de chaque série"]
[null,{"$f":"CONCATENATE(\"Automesure (\",F4,\"/\",I4,\") : \",\"PA = \",ROUND((AVERAGE(E32:E45,G32:G45,I32:I45)),0),\"/\",ROUND((AVERAGE(F32:F45,H32:H45,J32:J45)),0),\" mmHg, PA matin = \",ROUND((AVERAGE(E32,G32,I32,E34,G34,I34,E36,G36,I36,E38,G38,I38,E40,G40,I40,E42,G42,I42,E44,G44,I44)),0),\"/\",ROUND((AVERAGE(F32,H32,J32,F34,H34,J34,F36,H36,J36,F38,H38,J38,F40,H40,J40,F42,H42,J42,F44,H44,J44)),0),\" mmHg, PA soir = \", ROUND((AVERAGE(E33,G33,I33,E35,G35,I35,E37,G37,I37,E39,G39,I39,E41,G41,I41,E43,G43,I43,E45,G45,I45)),0),\"/\",ROUND((AVERAGE(F33,H33,J33,F35,H35,J35,F37,H37,J37,F39,H39,J39,F41,H41,J41,F43,H43,J43,F45,H45,J45)),0),\" mmHg\")","v":{"$error":"#DIV/0!"}}]
[]
[null,"2 mesures par série : exclusion de la première mesure de chaque série"]
[null,{"$f":"CONCATENATE(\"Automesure (\",F4,\"/\",I4,\") : \",\"PA = \",ROUND((AVERAGE(G32:G45,I32:I45)),0),\"/\",ROUND((AVERAGE(H32:H45,J32:J45)),0),\" mmHg, PA matin = \",ROUND((AVERAGE(G32,I32,G34,I34,G36,I36,G38,I38,G40,I40,G42,I42,G44,I44)),0),\"/\",ROUND((AVERAGE(H32,J32,H34,J34,H36,J36,H38,J38,H40,J40,H42,J42,H44,J44)),0),\" mmHg, PA soir = \", ROUND((AVERAGE(G33,I33,G35,I35,G37,I37,G39,I39,G41,I41,G43,I43,G45,I45)),0),\"/\",ROUND((AVERAGE(H33,J33,H35,J35,H37,J37,H39,J39,H41,J41,H43,J43,H45,J45)),0),\" mmHg\")","v":{"$error":"#DIV/0!"}}]
{"$rows_empty":7}
[null,"2 mesures par série sans J1 : exclusion de la première mesure de chaque série sans le 1e jour"]
[null,{"$f":"CONCATENATE(\"Automesure (\",F4,\"/\",I4,\") : \",\"PA = \",ROUND((AVERAGE(G34:G45,I34:I45)),0),\"/\",ROUND((AVERAGE(H34:H45,J34:J45)),0),\" mmHg, PA matin = \",ROUND((AVERAGE(G34,I34,G36,I36,G38,I38,G40,I40,G42,I42,G44,I44)),0),\"/\",ROUND((AVERAGE(H34,J34,H36,J36,H38,J38,H40,J40,H42,J42,H44,J44)),0),\" mmHg, PA soir = \", ROUND((AVERAGE(G35,I35,G37,I37,G39,I39,G41,I41,G43,I43,G45,I45)),0),\"/\",ROUND((AVERAGE(H35,J35,H37,J37,H39,J39,H41,J41,H43,J43,H45,J45)),0),\" mmHg\")","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,"Données 3 mesures"]
[{"$nulls":3},"J1","J2","J3","J4","J5","J6","J7"]
[null,"PAS normale",null,135,135,135,135,135,135,135]
[null,"PAD normale",null,85,85,85,85,85,85,85]
[null,"PAS",null,{"$f":"AVERAGE(E32,G32,I32,E33,G33,I33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E34,G34,I34,E35,G35,I35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E36,G36,I36,E37,G37,I37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E38,G38,I38,E39,G39,I39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E40,G40,I40,E41,G41,I41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E42,G42,I42,E43,G43,I43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E44,G44,I44,E45,G45,I45)","v":{"$error":"#DIV/0!"}}]
[null,"PAD",null,{"$f":"AVERAGE(F32,H32,J32,F33,H33,J33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F34,H34,J34,F35,H35,J35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F36,H36,J36,F37,H37,J37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F38,H38,J38,F39,H39,J39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F40,H40,J40,F41,H41,J41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F42,H42,J42,F43,H43,J43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F44,H44,J44,F45,H45,J45)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Données 2 mesures"]
[null,null,"J1","J2","J3","J4","J5","J6","J7"]
[null,"PAS normale",135,135,135,135,135,135,135]
[null,"PAD normale",85,85,85,85,85,85,85]
[null,"PAS",{"$f":"AVERAGE(G32,I32,G33,I33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G34,I34,G35,I35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G36,I36,G37,I37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G38,I38,G39,I39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G40,I40,G41,I41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G42,I42,G43,I43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G44,I44,G45,I45)","v":{"$error":"#DIV/0!"}}]
[null,"PAD",{"$f":"AVERAGE(H32,J32,H33,J33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H34,J34,H35,J35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H36,J36,H37,J37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H38,J38,H39,J39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H40,J40,H41,J41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H42,J42,H43,J43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H44,J44,H45,J45)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Données 2 mesures en excluant le 1e jour"]
[null,null,"J2","J3","J4","J5","J6","J7"]
[null,"PAS normale",135,135,135,135,135,135]
[null,"PAD normale",85,85,85,85,85,85]
[null,"PAS",{"$f":"AVERAGE(G34,I34,G35,I35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G36,I36,G37,I37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G38,I38,G39,I39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G40,I40,G41,I41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G42,I42,G43,I43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G44,I44,G45,I45)","v":{"$error":"#DIV/0!"}}]
[null,"PAD",{"$f":"AVERAGE(H34,J34,H35,J35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H36,J36,H37,J37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H38,J38,H39,J39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H40,J40,H41,J41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H42,J42,H43,J43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H44,J44,H45,J45)","v":{"$error":"#DIV/0!"}}]

{"sheet":"OCT","index":11,"n_rows":83,"n_cols":10,"rows_kept":83,"merged":[[3,5,3,6],[3,8,3,9],[5,5,5,9],[7,5,7,9],[8,4,8,5],[8,7,8,8],[9,5,9,9],[11,5,11,9],[13,5,13,9],[15,5,15,9],[17,5,17,9],[19,5,19,9],[21,5,21,9],[23,5,23,9],[25,1,25,4],[25,6,25,9],[27,3,27,9],[29,1,30,3],[29,4,29,5],[29,6,29,7],[29,8,29,9],[31,1,32,2],[33,1,34,2],[35,1,36,2],[37,1,38,2],[39,1,40,2],[41,1,42,2],[43,1,44,2],[46,1,46,7],[47,1,47,8],[49,1,49,7],[50,1,50,8],[59,1,59,8],[63,1,63,9],[70,1,70,9],[77,1,77,9]]}
{"$rows_empty":25}
[null,{"$f":"CONCATENATE(F8,\" \",F6,\" \",F10,\" ans\")","v":"   ans"},{"$nulls":4},{"$f":"CONCATENATE(F12,\" kg\",\", \",F14, \" cm\",\", \",\"BMI = \",ROUND(((F12)/((F14/100)*(F14/100))),1))","v":{"$error":"#DIV/0!"}}]
[]
[null,"Traitement",null,{"$f":"CONCATENATE(F16,\"  \",F18,\"  \",F20,\"  \",F22,\"  \",F24)","v":"        "}]
[]
[null,{"$f":"CONCATENATE(\"Date\",\" : \",F4,\"/\",I4)","v":"Date : /"},null,null,"MESURE 1",null,"MESURE 2",null,"MESURE 3"]
[{"$nulls":4},"SYS","DIA","SYS","DIA","SYS","DIA"]
[null,"JOUR 1",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 2",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 3",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 4",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 5",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 6",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 7",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[]
[null,"3 mesures par série : moyenne quotidienne des 3 mesures de chaque série"]
[null,{"$f":"CONCATENATE(\"Automesure (\",F4,\"/\",I4,\") : \",\"PA = \",ROUND((AVERAGE(E32:E45,G32:G45,I32:I45)),0),\"/\",ROUND((AVERAGE(F32:F45,H32:H45,J32:J45)),0),\" mmHg, PA matin = \",ROUND((AVERAGE(E32,G32,I32,E34,G34,I34,E36,G36,I36,E38,G38,I38,E40,G40,I40,E42,G42,I42,E44,G44,I44)),0),\"/\",ROUND((AVERAGE(F32,H32,J32,F34,H34,J34,F36,H36,J36,F38,H38,J38,F40,H40,J40,F42,H42,J42,F44,H44,J44)),0),\" mmHg, PA soir = \", ROUND((AVERAGE(E33,G33,I33,E35,G35,I35,E37,G37,I37,E39,G39,I39,E41,G41,I41,E43,G43,I43,E45,G45,I45)),0),\"/\",ROUND((AVERAGE(F33,H33,J33,F35,H35,J35,F37,H37,J37,F39,H39,J39,F41,H41,J41,F43,H43,J43,F45,H45,J45)),0),\" mmHg\")","v":{"$error":"#DIV/0!"}}]
[]
[null,"2 mesures par série : exclusion de la première mesure de chaque série"]
[null,{"$f":"CONCATENATE(\"Automesure (\",F4,\"/\",I4,\") : \",\"PA = \",ROUND((AVERAGE(G32:G45,I32:I45)),0),\"/\",ROUND((AVERAGE(H32:H45,J32:J45)),0),\" mmHg, PA matin = \",ROUND((AVERAGE(G32,I32,G34,I34,G36,I36,G38,I38,G40,I40,G42,I42,G44,I44)),0),\"/\",ROUND((AVERAGE(H32,J32,H34,J34,H36,J36,H38,J38,H40,J40,H42,J42,H44,J44)),0),\" mmHg, PA soir = \", ROUND((AVERAGE(G33,I33,G35,I35,G37,I37,G39,I39,G41,I41,G43,I43,G45,I45)),0),\"/\",ROUND((AVERAGE(H33,J33,H35,J35,H37,J37,H39,J39,H41,J41,H43,J43,H45,J45)),0),\" mmHg\")","v":{"$error":"#DIV/0!"}}]
{"$rows_empty":7}
[null,"2 mesures par série sans J1 : exclusion de la première mesure de chaque série sans le 1e jour"]
[null,{"$f":"CONCATENATE(\"Automesure (\",F4,\"/\",I4,\") : \",\"PA = \",ROUND((AVERAGE(G34:G45,I34:I45)),0),\"/\",ROUND((AVERAGE(H34:H45,J34:J45)),0),\" mmHg, PA matin = \",ROUND((AVERAGE(G34,I34,G36,I36,G38,I38,G40,I40,G42,I42,G44,I44)),0),\"/\",ROUND((AVERAGE(H34,J34,H36,J36,H38,J38,H40,J40,H42,J42,H44,J44)),0),\" mmHg, PA soir = \", ROUND((AVERAGE(G35,I35,G37,I37,G39,I39,G41,I41,G43,I43,G45,I45)),0),\"/\",ROUND((AVERAGE(H35,J35,H37,J37,H39,J39,H41,J41,H43,J43,H45,J45)),0),\" mmHg\")","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,"Données 3 mesures"]
[{"$nulls":3},"J1","J2","J3","J4","J5","J6","J7"]
[null,"PAS normale",null,135,135,135,135,135,135,135]
[null,"PAD normale",null,85,85,85,85,85,85,85]
[null,"PAS",null,{"$f":"AVERAGE(E32,G32,I32,E33,G33,I33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E34,G34,I34,E35,G35,I35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E36,G36,I36,E37,G37,I37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E38,G38,I38,E39,G39,I39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E40,G40,I40,E41,G41,I41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E42,G42,I42,E43,G43,I43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E44,G44,I44,E45,G45,I45)","v":{"$error":"#DIV/0!"}}]
[null,"PAD",null,{"$f":"AVERAGE(F32,H32,J32,F33,H33,J33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F34,H34,J34,F35,H35,J35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F36,H36,J36,F37,H37,J37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F38,H38,J38,F39,H39,J39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F40,H40,J40,F41,H41,J41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F42,H42,J42,F43,H43,J43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F44,H44,J44,F45,H45,J45)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Données 2 mesures"]
[null,null,"J1","J2","J3","J4","J5","J6","J7"]
[null,"PAS normale",135,135,135,135,135,135,135]
[null,"PAD normale",85,85,85,85,85,85,85]
[null,"PAS",{"$f":"AVERAGE(G32,I32,G33,I33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G34,I34,G35,I35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G36,I36,G37,I37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G38,I38,G39,I39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G40,I40,G41,I41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G42,I42,G43,I43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G44,I44,G45,I45)","v":{"$error":"#DIV/0!"}}]
[null,"PAD",{"$f":"AVERAGE(H32,J32,H33,J33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H34,J34,H35,J35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H36,J36,H37,J37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H38,J38,H39,J39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H40,J40,H41,J41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H42,J42,H43,J43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H44,J44,H45,J45)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Données 2 mesures en excluant le 1e jour"]
[null,null,"J2","J3","J4","J5","J6","J7"]
[null,"PAS normale",135,135,135,135,135,135]
[null,"PAD normale",85,85,85,85,85,85]
[null,"PAS",{"$f":"AVERAGE(G34,I34,G35,I35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G36,I36,G37,I37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G38,I38,G39,I39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G40,I40,G41,I41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G42,I42,G43,I43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G44,I44,G45,I45)","v":{"$error":"#DIV/0!"}}]
[null,"PAD",{"$f":"AVERAGE(H34,J34,H35,J35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H36,J36,H37,J37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H38,J38,H39,J39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H40,J40,H41,J41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H42,J42,H43,J43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H44,J44,H45,J45)","v":{"$error":"#DIV/0!"}}]

{"sheet":"NOV","index":12,"n_rows":83,"n_cols":10,"rows_kept":83,"merged":[[3,5,3,6],[3,8,3,9],[5,5,5,9],[7,5,7,9],[8,4,8,5],[8,7,8,8],[9,5,9,9],[11,5,11,9],[13,5,13,9],[15,5,15,9],[17,5,17,9],[19,5,19,9],[21,5,21,9],[23,5,23,9],[25,1,25,4],[25,6,25,9],[27,3,27,9],[29,1,30,3],[29,4,29,5],[29,6,29,7],[29,8,29,9],[31,1,32,2],[33,1,34,2],[35,1,36,2],[37,1,38,2],[39,1,40,2],[41,1,42,2],[43,1,44,2],[46,1,46,7],[47,1,47,8],[49,1,49,7],[50,1,50,8],[59,1,59,8],[63,1,63,9],[70,1,70,9],[77,1,77,9]]}
{"$rows_empty":25}
[null,{"$f":"CONCATENATE(F8,\" \",F6,\" \",F10,\" ans\")","v":"   ans"},{"$nulls":4},{"$f":"CONCATENATE(F12,\" kg\",\", \",F14, \" cm\",\", \",\"BMI = \",ROUND(((F12)/((F14/100)*(F14/100))),1))","v":{"$error":"#DIV/0!"}}]
[]
[null,"Traitement",null,{"$f":"CONCATENATE(F16,\"  \",F18,\"  \",F20,\"  \",F22,\"  \",F24)","v":"        "}]
[]
[null,{"$f":"CONCATENATE(\"Date\",\" : \",F4,\"/\",I4)","v":"Date : /"},null,null,"MESURE 1",null,"MESURE 2",null,"MESURE 3"]
[{"$nulls":4},"SYS","DIA","SYS","DIA","SYS","DIA"]
[null,"JOUR 1",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 2",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 3",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 4",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 5",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 6",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 7",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[]
[null,"3 mesures par série : moyenne quotidienne des 3 mesures de chaque série"]
[null,{"$f":"CONCATENATE(\"Automesure (\",F4,\"/\",I4,\") : \",\"PA = \",ROUND((AVERAGE(E32:E45,G32:G45,I32:I45)),0),\"/\",ROUND((AVERAGE(F32:F45,H32:H45,J32:J45)),0),\" mmHg, PA matin = \",ROUND((AVERAGE(E32,G32,I32,E34,G34,I34,E36,G36,I36,E38,G38,I38,E40,G40,I40,E42,G42,I42,E44,G44,I44)),0),\"/\",ROUND((AVERAGE(F32,H32,J32,F34,H34,J34,F36,H36,J36,F38,H38,J38,F40,H40,J40,F42,H42,J42,F44,H44,J44)),0),\" mmHg, PA soir = \", ROUND((AVERAGE(E33,G33,I33,E35,G35,I35,E37,G37,I37,E39,G39,I39,E41,G41,I41,E43,G43,I43,E45,G45,I45)),0),\"/\",ROUND((AVERAGE(F33,H33,J33,F35,H35,J35,F37,H37,J37,F39,H39,J39,F41,H41,J41,F43,H43,J43,F45,H45,J45)),0),\" mmHg\")","v":{"$error":"#DIV/0!"}}]
[]
[null,"2 mesures par série : exclusion de la première mesure de chaque série"]
[null,{"$f":"CONCATENATE(\"Automesure (\",F4,\"/\",I4,\") : \",\"PA = \",ROUND((AVERAGE(G32:G45,I32:I45)),0),\"/\",ROUND((AVERAGE(H32:H45,J32:J45)),0),\" mmHg, PA matin = \",ROUND((AVERAGE(G32,I32,G34,I34,G36,I36,G38,I38,G40,I40,G42,I42,G44,I44)),0),\"/\",ROUND((AVERAGE(H32,J32,H34,J34,H36,J36,H38,J38,H40,J40,H42,J42,H44,J44)),0),\" mmHg, PA soir = \", ROUND((AVERAGE(G33,I33,G35,I35,G37,I37,G39,I39,G41,I41,G43,I43,G45,I45)),0),\"/\",ROUND((AVERAGE(H33,J33,H35,J35,H37,J37,H39,J39,H41,J41,H43,J43,H45,J45)),0),\" mmHg\")","v":{"$error":"#DIV/0!"}}]
{"$rows_empty":7}
[null,"2 mesures par série sans J1 : exclusion de la première mesure de chaque série sans le 1e jour"]
[null,{"$f":"CONCATENATE(\"Automesure (\",F4,\"/\",I4,\") : \",\"PA = \",ROUND((AVERAGE(G34:G45,I34:I45)),0),\"/\",ROUND((AVERAGE(H34:H45,J34:J45)),0),\" mmHg, PA matin = \",ROUND((AVERAGE(G34,I34,G36,I36,G38,I38,G40,I40,G42,I42,G44,I44)),0),\"/\",ROUND((AVERAGE(H34,J34,H36,J36,H38,J38,H40,J40,H42,J42,H44,J44)),0),\" mmHg, PA soir = \", ROUND((AVERAGE(G35,I35,G37,I37,G39,I39,G41,I41,G43,I43,G45,I45)),0),\"/\",ROUND((AVERAGE(H35,J35,H37,J37,H39,J39,H41,J41,H43,J43,H45,J45)),0),\" mmHg\")","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,"Données 3 mesures"]
[{"$nulls":3},"J1","J2","J3","J4","J5","J6","J7"]
[null,"PAS normale",null,135,135,135,135,135,135,135]
[null,"PAD normale",null,85,85,85,85,85,85,85]
[null,"PAS",null,{"$f":"AVERAGE(E32,G32,I32,E33,G33,I33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E34,G34,I34,E35,G35,I35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E36,G36,I36,E37,G37,I37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E38,G38,I38,E39,G39,I39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E40,G40,I40,E41,G41,I41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E42,G42,I42,E43,G43,I43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E44,G44,I44,E45,G45,I45)","v":{"$error":"#DIV/0!"}}]
[null,"PAD",null,{"$f":"AVERAGE(F32,H32,J32,F33,H33,J33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F34,H34,J34,F35,H35,J35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F36,H36,J36,F37,H37,J37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F38,H38,J38,F39,H39,J39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F40,H40,J40,F41,H41,J41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F42,H42,J42,F43,H43,J43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F44,H44,J44,F45,H45,J45)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Données 2 mesures"]
[null,null,"J1","J2","J3","J4","J5","J6","J7"]
[null,"PAS normale",135,135,135,135,135,135,135]
[null,"PAD normale",85,85,85,85,85,85,85]
[null,"PAS",{"$f":"AVERAGE(G32,I32,G33,I33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G34,I34,G35,I35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G36,I36,G37,I37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G38,I38,G39,I39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G40,I40,G41,I41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G42,I42,G43,I43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G44,I44,G45,I45)","v":{"$error":"#DIV/0!"}}]
[null,"PAD",{"$f":"AVERAGE(H32,J32,H33,J33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H34,J34,H35,J35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H36,J36,H37,J37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H38,J38,H39,J39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H40,J40,H41,J41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H42,J42,H43,J43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H44,J44,H45,J45)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Données 2 mesures en excluant le 1e jour"]
[null,null,"J2","J3","J4","J5","J6","J7"]
[null,"PAS normale",135,135,135,135,135,135]
[null,"PAD normale",85,85,85,85,85,85]
[null,"PAS",{"$f":"AVERAGE(G34,I34,G35,I35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G36,I36,G37,I37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G38,I38,G39,I39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G40,I40,G41,I41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G42,I42,G43,I43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G44,I44,G45,I45)","v":{"$error":"#DIV/0!"}}]
[null,"PAD",{"$f":"AVERAGE(H34,J34,H35,J35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H36,J36,H37,J37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H38,J38,H39,J39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H40,J40,H41,J41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H42,J42,H43,J43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H44,J44,H45,J45)","v":{"$error":"#DIV/0!"}}]

{"sheet":"DEC","index":13,"n_rows":83,"n_cols":10,"rows_kept":83,"merged":[[3,5,3,6],[3,8,3,9],[5,5,5,9],[7,5,7,9],[8,4,8,5],[8,7,8,8],[9,5,9,9],[11,5,11,9],[13,5,13,9],[15,5,15,9],[17,5,17,9],[19,5,19,9],[21,5,21,9],[23,5,23,9],[25,1,25,4],[25,6,25,9],[27,3,27,9],[29,1,30,3],[29,4,29,5],[29,6,29,7],[29,8,29,9],[31,1,32,2],[33,1,34,2],[35,1,36,2],[37,1,38,2],[39,1,40,2],[41,1,42,2],[43,1,44,2],[46,1,46,7],[47,1,47,8],[49,1,49,7],[50,1,50,8],[59,1,59,8],[63,1,63,9],[70,1,70,9],[77,1,77,9]]}
{"$rows_empty":25}
[null,{"$f":"CONCATENATE(F8,\" \",F6,\" \",F10,\" ans\")","v":"   ans"},{"$nulls":4},{"$f":"CONCATENATE(F12,\" kg\",\", \",F14, \" cm\",\", \",\"BMI = \",ROUND(((F12)/((F14/100)*(F14/100))),1))","v":{"$error":"#DIV/0!"}}]
[]
[null,"Traitement",null,{"$f":"CONCATENATE(F16,\"  \",F18,\"  \",F20,\"  \",F22,\"  \",F24)","v":"        "}]
[]
[null,{"$f":"CONCATENATE(\"Date\",\" : \",F4,\"/\",I4)","v":"Date : /"},null,null,"MESURE 1",null,"MESURE 2",null,"MESURE 3"]
[{"$nulls":4},"SYS","DIA","SYS","DIA","SYS","DIA"]
[null,"JOUR 1",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 2",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 3",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 4",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 5",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 6",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[null,"JOUR 7",null,"MATIN"]
[{"$nulls":3},"SOIR"]
[]
[null,"3 mesures par série : moyenne quotidienne des 3 mesures de chaque série"]
[null,{"$f":"CONCATENATE(\"Automesure (\",F4,\"/\",I4,\") : \",\"PA = \",ROUND((AVERAGE(E32:E45,G32:G45,I32:I45)),0),\"/\",ROUND((AVERAGE(F32:F45,H32:H45,J32:J45)),0),\" mmHg, PA matin = \",ROUND((AVERAGE(E32,G32,I32,E34,G34,I34,E36,G36,I36,E38,G38,I38,E40,G40,I40,E42,G42,I42,E44,G44,I44)),0),\"/\",ROUND((AVERAGE(F32,H32,J32,F34,H34,J34,F36,H36,J36,F38,H38,J38,F40,H40,J40,F42,H42,J42,F44,H44,J44)),0),\" mmHg, PA soir = \", ROUND((AVERAGE(E33,G33,I33,E35,G35,I35,E37,G37,I37,E39,G39,I39,E41,G41,I41,E43,G43,I43,E45,G45,I45)),0),\"/\",ROUND((AVERAGE(F33,H33,J33,F35,H35,J35,F37,H37,J37,F39,H39,J39,F41,H41,J41,F43,H43,J43,F45,H45,J45)),0),\" mmHg\")","v":{"$error":"#DIV/0!"}}]
[]
[null,"2 mesures par série : exclusion de la première mesure de chaque série"]
[null,{"$f":"CONCATENATE(\"Automesure (\",F4,\"/\",I4,\") : \",\"PA = \",ROUND((AVERAGE(G32:G45,I32:I45)),0),\"/\",ROUND((AVERAGE(H32:H45,J32:J45)),0),\" mmHg, PA matin = \",ROUND((AVERAGE(G32,I32,G34,I34,G36,I36,G38,I38,G40,I40,G42,I42,G44,I44)),0),\"/\",ROUND((AVERAGE(H32,J32,H34,J34,H36,J36,H38,J38,H40,J40,H42,J42,H44,J44)),0),\" mmHg, PA soir = \", ROUND((AVERAGE(G33,I33,G35,I35,G37,I37,G39,I39,G41,I41,G43,I43,G45,I45)),0),\"/\",ROUND((AVERAGE(H33,J33,H35,J35,H37,J37,H39,J39,H41,J41,H43,J43,H45,J45)),0),\" mmHg\")","v":{"$error":"#DIV/0!"}}]
{"$rows_empty":7}
[null,"2 mesures par série sans J1 : exclusion de la première mesure de chaque série sans le 1e jour"]
[null,{"$f":"CONCATENATE(\"Automesure (\",F4,\"/\",I4,\") : \",\"PA = \",ROUND((AVERAGE(G34:G45,I34:I45)),0),\"/\",ROUND((AVERAGE(H34:H45,J34:J45)),0),\" mmHg, PA matin = \",ROUND((AVERAGE(G34,I34,G36,I36,G38,I38,G40,I40,G42,I42,G44,I44)),0),\"/\",ROUND((AVERAGE(H34,J34,H36,J36,H38,J38,H40,J40,H42,J42,H44,J44)),0),\" mmHg, PA soir = \", ROUND((AVERAGE(G35,I35,G37,I37,G39,I39,G41,I41,G43,I43,G45,I45)),0),\"/\",ROUND((AVERAGE(H35,J35,H37,J37,H39,J39,H41,J41,H43,J43,H45,J45)),0),\" mmHg\")","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,"Données 3 mesures"]
[{"$nulls":3},"J1","J2","J3","J4","J5","J6","J7"]
[null,"PAS normale",null,135,135,135,135,135,135,135]
[null,"PAD normale",null,85,85,85,85,85,85,85]
[null,"PAS",null,{"$f":"AVERAGE(E32,G32,I32,E33,G33,I33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E34,G34,I34,E35,G35,I35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E36,G36,I36,E37,G37,I37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E38,G38,I38,E39,G39,I39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E40,G40,I40,E41,G41,I41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E42,G42,I42,E43,G43,I43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E44,G44,I44,E45,G45,I45)","v":{"$error":"#DIV/0!"}}]
[null,"PAD",null,{"$f":"AVERAGE(F32,H32,J32,F33,H33,J33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F34,H34,J34,F35,H35,J35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F36,H36,J36,F37,H37,J37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F38,H38,J38,F39,H39,J39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F40,H40,J40,F41,H41,J41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F42,H42,J42,F43,H43,J43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(F44,H44,J44,F45,H45,J45)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Données 2 mesures"]
[null,null,"J1","J2","J3","J4","J5","J6","J7"]
[null,"PAS normale",135,135,135,135,135,135,135]
[null,"PAD normale",85,85,85,85,85,85,85]
[null,"PAS",{"$f":"AVERAGE(G32,I32,G33,I33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G34,I34,G35,I35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G36,I36,G37,I37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G38,I38,G39,I39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G40,I40,G41,I41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G42,I42,G43,I43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G44,I44,G45,I45)","v":{"$error":"#DIV/0!"}}]
[null,"PAD",{"$f":"AVERAGE(H32,J32,H33,J33)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H34,J34,H35,J35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H36,J36,H37,J37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H38,J38,H39,J39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H40,J40,H41,J41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H42,J42,H43,J43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H44,J44,H45,J45)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Données 2 mesures en excluant le 1e jour"]
[null,null,"J2","J3","J4","J5","J6","J7"]
[null,"PAS normale",135,135,135,135,135,135]
[null,"PAD normale",85,85,85,85,85,85]
[null,"PAS",{"$f":"AVERAGE(G34,I34,G35,I35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G36,I36,G37,I37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G38,I38,G39,I39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G40,I40,G41,I41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G42,I42,G43,I43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G44,I44,G45,I45)","v":{"$error":"#DIV/0!"}}]
[null,"PAD",{"$f":"AVERAGE(H34,J34,H35,J35)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H36,J36,H37,J37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H38,J38,H39,J39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H40,J40,H41,J41)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H42,J42,H43,J43)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H44,J44,H45,J45)","v":{"$error":"#DIV/0!"}}]

{"sheet":"HYPOTA ORTHOSTATIQUE","index":14,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"HYPOTA RECUEIL","index":15,"n_rows":55,"n_cols":15,"rows_kept":55,"merged":[[1,1,1,15],[4,1,4,2],[4,3,4,7],[4,8,4,10],[4,11,4,14],[6,1,6,5],[6,6,6,7],[14,5,14,13],[25,5,25,13],[33,5,33,13],[41,5,41,13],[47,1,47,15]]}
[]
[null,"RECHERCHE D'HYPOTENSION ARTERIELLE ORTHOSTATIQUE"]
[]
[]
[null,"NOM :",{"$nulls":6},"PRÉNOM :"]
[]
[null,"DATE ET LIEU DU RECUEIL   :",{"$nulls":4},"LE",null,null,"/",null,"/",null,"AU","DOMICILE"]
[]
[]
[null,"1/ S’allonger pendant 10’ puis prendre sa tension artérielle et son pouls :"]
[]
[]
[null,null,"SYS      :",null,"mmHg"]
[]
[null,null,"DIA      :",null,"mmHg","Résultat allongé"]
[]
[null,null,"PULSE :",null,"/mn"]
[]
[]
[]
[null,"2/ Se lever puis reprendre sa tension artérielle et son pouls à 1, 3 et 5 minutes debout :"]
[]
[]
[null,null,"SYS      :",null,"mmHg"]
[]
[null,null,"DIA      :",null,"mmHg","Résultat après 1' debout"]
[]
[null,null,"PULSE :",null,"/mn"]
[]
[]
[]
[null,null,"SYS      :",null,"mmHg"]
[]
[null,null,"DIA      :",null,"mmHg","Résultat après 3' debout"]
[]
[null,null,"PULSE :",null,"/mn"]
[]
[]
[]
[null,null,"SYS      :",null,"mmHg"]
[]
[null,null,"DIA      :",null,"mmHg","Résultat après 5' debout"]
[]
[null,null,"PULSE :",null,"/mn"]
[]
[]
[]
[null,{"$f":"CONCATENATE(\"PA = \", D13,\"/\",D15,\" mmHg, pouls = \",D17,\"/mn en décubitus, PA = \",D24,\"/\",D26,\" mmHg, pouls = \",D28,\"/mn, PA = \",D32,\"/\",D34,\" mmHg, pouls = \",D36,\"/mn, PA = \",D40,\"/\",D42,\" mmHg, pouls = \",D44, \"/mn à 1, 3,5’ en orthostatisme.\")","v":"PA = / mmHg, pouls = /mn en décubitus, PA = / mmHg, pouls = /mn, PA = / mmHg, pouls = /mn, PA = / mmHg, pouls = /mn à 1, 3,5’ en orthostatisme."}]
[]
[]
[]
[]
[null,null,"CHOIX"]
[null,null,"CABINET"]
[null,null,"DOMICILE"]

{"sheet":"HYPOTA FEUILLE VIERGE","index":16,"n_rows":47,"n_cols":14,"rows_kept":47,"merged":[[1,1,1,15],[3,11,3,14],[7,1,7,15],[12,5,12,10],[18,1,18,15],[23,5,23,10],[31,5,31,10],[39,5,39,10],[45,1,45,15],[46,1,46,15]]}
[]
[null,"RECHERCHE D'HYPOTENSION ARTERIELLE ORTHOSTATIQUE"]
[]
[null,"NOM    :",{"$nulls":4},"PRENOM    :"]
[]
[null,"DATE ET LIEU DU RECUEIL   :",{"$nulls":5},"LE",null,"/",null,"/",null,"AU"]
[]
[null,"1/ S’allonger pendant 10’ puis prendre sa tension artérielle et son pouls :"]
[]
[]
[null,null,"SYS      :",null,"mmHg"]
[]
[null,null,"DIA      :",null,"mmHg","Résultat allongé"]
[]
[null,null,"PULSE :",null,"/mn"]
[]
[]
[]
[null,"2/ Se lever puis reprendre sa tension artérielle et son pouls à 1, 3 et 5 minutes debout :"]
[]
[]
[null,null,"SYS      :",null,"mmHg"]
[]
[null,null,"DIA      :",null,"mmHg","Résultat 1' debout"]
[]
[null,null,"PULSE :",null,"/mn"]
[]
[]
[]
[null,null,"SYS      :",null,"mmHg"]
[]
[null,null,"DIA      :",null,"mmHg","Résultat 3' debout"]
[]
[null,null,"PULSE :",null,"/mn"]
[]
[]
[]
[null,null,"SYS      :",null,"mmHg"]
[]
[null,null,"DIA      :",null,"mmHg","Résultat 5' debout"]
[]
[null,null,"PULSE :",null,"/mn"]
[]
[]
[]
[null,"Systématique : 2x par an 2 à 3 heures après la prise d'un traitement antihypertenseur"]
[null,"Si symptômes : étourdissements, perte de connaissance, vertiges, vision trouble, maux de tête, sensation de poids sur les épaules, douleurs de la nuque…)"]

{"sheet":"RECAPITULATIF ANNÉE","index":17,"n_rows":41,"n_cols":4,"rows_kept":41,"merged":[[0,3,1,3]]}
[{"$nulls":3},"RESULTATS"]
[]
[]
[null,"JANVIER","3 mesures",{"$f":"CONCATENATE(JAN!B48)","v":{"$error":"#DIV/0!"}}]
[null,"FEVRIER","3 mesures",{"$f":"CONCATENATE(FEV!B48)","v":{"$error":"#DIV/0!"}}]
[null,"MARS","3 mesures",{"$f":"CONCATENATE(MARS!B48)","v":{"$error":"#DIV/0!"}}]
[null,"AVRIL","3 mesures",{"$f":"CONCATENATE(AVRIL!B48)","v":{"$error":"#DIV/0!"}}]
[null,"MAI","3 mesures",{"$f":"CONCATENATE(MAI!B48)","v":{"$error":"#DIV/0!"}}]
[null,"JUIN","3 mesures",{"$f":"CONCATENATE(JUIN!B48)","v":{"$error":"#DIV/0!"}}]
[null,"JUILLET","3 mesures",{"$f":"CONCATENATE(JUILLET!B48)","v":{"$error":"#DIV/0!"}}]
[null,"AOÛT","3 mesures",{"$f":"CONCATENATE(AOUT!B48)","v":{"$error":"#DIV/0!"}}]
[null,"SEPTEMBRE","3 mesures",{"$f":"CONCATENATE(SEPT!B48)","v":{"$error":"#DIV/0!"}}]
[null,"OCTOBRE","3 mesures",{"$f":"CONCATENATE(OCT!B48)","v":{"$error":"#DIV/0!"}}]
[null,"NOVEMBRE","3 mesures",{"$f":"CONCATENATE(NOV!B48)","v":{"$error":"#DIV/0!"}}]
[null,"DÉCEMBRE","3 mesures",{"$f":"CONCATENATE(DEC!B48)","v":{"$error":"#DIV/0!"}}]
[]
[null,"JANVIER","2 mesures",{"$f":"CONCATENATE(JAN!B51)","v":{"$error":"#DIV/0!"}}]
[null,"FEVRIER","2 mesures",{"$f":"CONCATENATE(FEV!B51)","v":{"$error":"#DIV/0!"}}]
[null,"MARS","2 mesures",{"$f":"CONCATENATE(MARS!B51)","v":{"$error":"#DIV/0!"}}]
[null,"AVRIL","2 mesures",{"$f":"CONCATENATE(AVRIL!B51)","v":{"$error":"#DIV/0!"}}]
[null,"MAI","2 mesures",{"$f":"CONCATENATE(MAI!B51)","v":{"$error":"#DIV/0!"}}]
[null,"JUIN","2 mesures",{"$f":"CONCATENATE(JUIN!B51)","v":{"$error":"#DIV/0!"}}]
[null,"JUILLET","2 mesures",{"$f":"CONCATENATE(JUILLET!B51)","v":{"$error":"#DIV/0!"}}]
[null,"AOÛT","2 mesures",{"$f":"CONCATENATE(AOUT!B51)","v":{"$error":"#DIV/0!"}}]
[null,"SEPTEMBRE","2 mesures",{"$f":"CONCATENATE(SEPT!B51)","v":{"$error":"#DIV/0!"}}]
[null,"OCTOBRE","2 mesures",{"$f":"CONCATENATE(OCT!B51)","v":{"$error":"#DIV/0!"}}]
[null,"NOVEMBRE","2 mesures",{"$f":"CONCATENATE(NOV!B51)","v":{"$error":"#DIV/0!"}}]
[null,"DÉCEMBRE","2 mesures",{"$f":"CONCATENATE(DEC!B51)","v":{"$error":"#DIV/0!"}}]
[]
[null,"JANVIER","2 mesures sans J1",{"$f":"CONCATENATE(JAN!B60)","v":{"$error":"#DIV/0!"}}]
[null,"FEVRIER","2 mesures sans J1",{"$f":"CONCATENATE(FEV!B60)","v":{"$error":"#DIV/0!"}}]
[null,"MARS","2 mesures sans J1",{"$f":"CONCATENATE(MARS!B60)","v":{"$error":"#DIV/0!"}}]
[null,"AVRIL","2 mesures sans J1",{"$f":"CONCATENATE(AVRIL!B60)","v":{"$error":"#DIV/0!"}}]
[null,"MAI","2 mesures sans J1",{"$f":"CONCATENATE(MAI!B60)","v":{"$error":"#DIV/0!"}}]
[null,"JUIN","2 mesures sans J1",{"$f":"CONCATENATE(JUIN!B60)","v":{"$error":"#DIV/0!"}}]
[null,"JUILLET","2 mesures sans J1",{"$f":"CONCATENATE(JUILLET!B60)","v":{"$error":"#DIV/0!"}}]
[null,"AOÛT","2 mesures sans J1",{"$f":"CONCATENATE(AOUT!B60)","v":{"$error":"#DIV/0!"}}]
[null,"SEPTEMBRE","2 mesures sans J1",{"$f":"CONCATENATE(SEPT!B60)","v":{"$error":"#DIV/0!"}}]
[null,"OCTOBRE","2 mesures sans J1",{"$f":"CONCATENATE(OCT!B60)","v":{"$error":"#DIV/0!"}}]
[null,"NOVEMBRE","2 mesures sans J1",{"$f":"CONCATENATE(NOV!B60)","v":{"$error":"#DIV/0!"}}]
[null,"DÉCEMBRE","2 mesures sans J1",{"$f":"CONCATENATE(DEC!B60)","v":{"$error":"#DIV/0!"}}]