{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Sondages","Sondage","Gy","Lane","Ressources","Variogrammes","Variance_bloc","Variance d'estimation","KS-sphérique","KS-Exponentiel","KS-Gaussien","KO-Sphérique","KO-Exponentiel","KO-Gaussien"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":90,"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":"Sondages","index":0,"n_rows":116,"n_cols":21,"rows_kept":116,"cut":false,"hidden":true,"merged":[]}
["Sondages"]
["À programmer",null,null,null,null,null,null,null,null,null,null,"Légende"]
["1- Conversion azimut-plongée vers cosinus directeurs (système main droite, composante z du cosinus directeur négative)",null,null,null,null,null,null,null,null,null,null,null,"valeurs à entrer"]
["2- Conversion cosinus directeur vers azimut-plongée (angle de plongée positif pour un vecteur qui pointe vers le bas)",null,null,null,null,null,null,null,null,null,null,null,"valeurs calculées"]
["3- Conversion épaisseur observée en forage vers épaisseur vraie selon le JO",null,null,null,null,null,null,null,null,null,null,null,"exemple de résultat que vous devriez obtenir"]
["4- Conversion épaisseur vraie vers épaisseur observée en forage selon le JO"]
["5- Conversion orientation d'un plan en convention géologique vers le pôle du plan (cosinus directeurs)"]
["6- Conversion pôle du plan (cosinus directeurs) vers orientation du plan en convention géologique"]
["7- Calcul du JO à partir des cosinus directeurs du pôle du plan et du forage"]
["8- Calcul de la distance entre le collet d'un forage et le plan étant donné les cosinus directeurs du forage et du pôle et un point connu du plan"]
["9- Calcul de l'inclinaison apparente d'un forage projeté sur une section verticale, les deux spécifiés par leurs cosinus directeurs"]
["10- Calcul de l'inclinaison apparente d'un plan intercepté par une section verticale"]
["11- Calcul de l'orientation d'un plan à partir des JO observés dans trois forages non parallèles"]
["12- Composites et coordonnées"]
[]
["1- Conversion azimut-plongée d'un vecteur vers cosinus directeurs (système main droite, composante z du cosinus directeur négative); coordonnées angles égaux et aires égales"]
[null,null,"cosinus directeur",null,null,null,"coord. aires égales",null,"coord. angles égaux",null,null,null,null,"cosinus directeur",null,null,null,"coord. aires égales",null,"coord. angles égaux"]
["azimut","plongée","a","b","c","norme","x","y","x","y",null,"azimut","plongée","a","b","c","norme","x","y","x","y"]
[325,60,null,null,null,null,null,null,null,null,null,325,60,-0.2867882181755233,0.4095760221444959,-0.8660254037844386,1,-0.20994354671663121,0.29983045777172662,-0.15368934291778419,0.21949112874553861]
[]
["2- Conversion cosinus directeur vers azimut-plongée (angle de plongée positif pour un vecteur qui pointe vers le bas)"]
["azimut","plongée","a","b","c","norme",null,null,null,null,null,"azimut","plongée","a","b","c","norme"]
[null,null,-0.36868782649461246,-0.52654078451836328,-0.76604444311897801,{"$f":"C23^2+D23^2+E23^2","v":1},null,null,null,null,null,{"$f":"IF(90-DEGREES(ATAN2(N23,O23))<0,90+360-DEGREES(ATAN2(N23,O23)),90-DEGREES(ATAN2(N23,O23)))","v":215},{"$f":"-DEGREES(ASIN(P23))","v":49.999999999999993},-0.36868782649461246,-0.52654078451836328,-0.76604444311897801,{"$f":"N23^2+O23^2+P23^2","v":1}]
[]
["3- Conversion épaisseur observée en forage vers épaisseur vraie selon le JO"]
["JO","e_obs","e_vraie",null,null,null,null,null,null,null,null,"JO","e_obs","e_vraie"]
[35,2.8,null,null,null,null,null,null,null,null,null,35,2.8,1.6060140217829288]
[]
["4- Conversion épaisseur vraie vers épaisseur observée en forage selon le JO"]
["JO","e_obs","e_vraie",null,null,null,null,null,null,null,null,"JO","e_obs","e_vraie"]
[55,null,2.2000000000000002,null,null,null,null,null,null,null,null,55,2.6857040952752036,2.2000000000000002]
[]
["5- Conversion orientation d'un plan en convention géologique vers le pôle du plan "]
["Plan",null,"Pôle",null,"Pôle",null,null,null,null,null,null,"Plan",null,"Pôle",null,"Pôle"]
["azimut","pendage","azimut","plongée","a","b","c",null,null,null,null,"azimut","pendage","azimut","plongée","a","b","c"]
[45,50,{"$f":"IF(A36-90<0,A36+270,A36-90)","v":315},{"$f":"90-B36","v":40},{"$f":"COS(RADIANS(D36))*SIN(RADIANS(C36))","v":-0.54167522041970195},{"$f":"COS(RADIANS(D36))*COS(RADIANS(C36))","v":0.54167522041970173},{"$f":"-SIN(RADIANS(D36))","v":-0.64278760968653925},null,null,null,null,45,50,315,40,-0.54167522041970195,0.54167522041970173,-0.64278760968653925]
[]
["6- Conversion pôle du plan vers orientation du plan en convention géologique"]
["Plan",null,"Pôle",null,"Pôle",null,null,null,null,null,null,"Plan",null,"Pôle",null,"Pôle"]
["azimut","pendage","azimut","plongée","a","b","c",null,null,null,null,"azimut","pendage","azimut","plongée","a","b","c"]
[{"$f":"MOD(C41+90,360)","v":45},{"$f":"90-D41","v":50},315,40,{"$f":"COS(RADIANS(D41))*SIN(RADIANS(C41))","v":-0.54167522041970195},{"$f":"COS(RADIANS(D41))*COS(RADIANS(C41))","v":0.54167522041970173},{"$f":"-SIN(RADIANS(D41))","v":-0.64278760968653925},null,null,null,null,45,50,315,40,-0.54167522041970195,0.54167522041970173,-0.64278760968653925]
[]
["7- Calcul du JO à partir des orientations du plan (convention géologique) et du forage"]
["Plan",null,"Pôle",null,"Pôle",null,null,null,null,null,null,"Plan",null,"Pôle",null,"Pôle"]
["azimut","pendage","azimut","plongée","a","b","c",null,null,null,null,"azimut","pendage","azimut","plongée","a","b","c"]
[135,50,{"$f":"IF(A46-90<0,A46+270,A46-90)","v":45},{"$f":"90-B46","v":40},{"$f":"COS(RADIANS(D46))*SIN(RADIANS(C46))","v":0.54167522041970184},{"$f":"COS(RADIANS(D46))*COS(RADIANS(C46))","v":0.54167522041970184},{"$f":"-SIN(RADIANS(D46))","v":-0.64278760968653925},null,null,null,null,135,50,45,40,0.54167522041970184,0.54167522041970184,-0.64278760968653925]
["Forage",null,null,null,null,null,null,null,null,null,null,"Forage"]
["azimut","plongée",null,null,null,null,"JO",null,null,null,null,"azimut","plongée",null,null,null,null,"JO"]
[90,80,{"$f":"COS(RADIANS(B49))*SIN(RADIANS(A49))","v":0.17364817766693041},{"$f":"COS(RADIANS(B49))*COS(RADIANS(A49))","v":1.0637239828316867E-17},{"$f":"-SIN(RADIANS(B49))","v":-0.98480775301220802},null,{"$f":"90-DEGREES(ACOS(C49*E46+D49*F46+E49*G46))","v":46.642417214027709},null,null,null,null,90,80,0.17364817766693041,1.0637239828316867E-17,-0.98480775301220802,null,46.642417214027709]
[]
["8- Calcul de la distance entre le collet d'un forage et le plan"]
[null,"x","y","z"]
["Collet",100,100,200]
["Point connu dans le plan",50,0,-100]
[null,"azimut","pendage ou plongée","pôle azimut","pôle plongée ","cosinus directeurs",null,null,null,"Distance","Coordonnées du point d'intersection"]
["plan (conv. géol.)",350,30,{"$f":"IF(B56-90<0,B56+270,B56-90)","v":260},{"$f":"90-C56","v":60},{"$f":"COS(RADIANS(E56))*SIN(RADIANS(D56))","v":-0.49240387650610412},{"$f":"COS(RADIANS(E56))*COS(RADIANS(D56))","v":-8.6824088833465179E-2},{"$f":"-SIN(RADIANS(E56))","v":-0.8660254037844386},null,null,"x","y","z",null,null,"x","y","z"]
["forage",null,null,270,80,-0.17364817766693041,-3.1911719484950597E-17,-0.98480775301220802,null,null,null,null,null,null,312.359846767867,45.759281832438269,99.999999999999986,-107.61439882670072]
[]
["9- Calcul de l'inclinaison apparente d'un forage projeté sur une section verticale"]
[null,"azimut","pendage ou plongée","cosinus directeurs"]
["section verticale (conv. géol)",90,null,null,null,null,null,"plongée apparente"]
["v. horizontal dans section",{"$f":"B61","v":90},0,{"$f":"COS(RADIANS(C62))*SIN(RADIANS(B62))","v":1},{"$f":"COS(RADIANS(C62))*COS(RADIANS(B62))","v":6.1257422745431001E-17},{"$f":"-SIN(RADIANS(C62))","v":0},null,{"$f":"ABS(DEGREES(ATAN(F63/(D62*D63+E62*E63))))","v":61.659225576666813}]
["forage",220,50,-0.41317591116653479,-0.49240387650610407,-0.76604444311897801]
[]
["10- Calcul du pendage apparent d'un plan sur une section verticale"]
[null,"azimut","pendage ou plongée","cosinus directeurs"]
["section verticale (conv. géol)",90,null,null,null,null,null,"pendage apparent"]
["v. horizontal dans section",{"$f":"B67","v":90},0,{"$f":"COS(RADIANS(C68))*SIN(RADIANS(B68))","v":1},{"$f":"COS(RADIANS(C68))*COS(RADIANS(B68))","v":6.1257422745431001E-17},{"$f":"-SIN(RADIANS(C68))","v":0},null,{"$f":"ABS(DEGREES(ATAN((D68*D70+E68*E70)/F70)))","v":22.760476274616646}]
["plan (conv.  géol.)",60,40]
["pôle du plan",{"$f":"IF(B69-90<0,B69+270,B69-90)","v":330},{"$f":"90-C69","v":50},{"$f":"COS(RADIANS(C70))*SIN(RADIANS(B70))","v":-0.32139380484326996},{"$f":"COS(RADIANS(C70))*COS(RADIANS(B70))","v":0.55667039922641925},{"$f":"-SIN(RADIANS(C70))","v":-0.76604444311897801}]
[]
[]
["11- Calcul de l'orientation d'un plan à partir des JO observés dans trois forages non parallèles"]
[null,"angle","angle complémentaire","cosinus de l'angle complémentaire"]
["JO1",54.6,{"$f":"90-B75","v":35.4},{"$f":"COS(RADIANS(C75))","v":0.81512779572855421}]
["JO2",60.92,{"$f":"90-B76","v":29.08},{"$f":"COS(RADIANS(C76))","v":0.87394193287191679}]
["JO3",62.38,27.619999999999997,0.88604180441940439,null,null,null,null,null,"azimut","pendage"]
[null,"azimut","plongée","a","b","c",null,"v. unitaire du plan","plan",{"$f":"IF(90-DEGREES(ATAN2(H79,H80))<0,90+360-DEGREES(ATAN2(H79,H80)),90-DEGREES(ATAN2(H79,H80)))","v":325.22844899643667},{"$f":"-DEGREES(ASIN(H81))","v":60.031979793817094}]
["forage1",270,45,{"$f":"COS(RADIANS(C79))*SIN(RADIANS(B79))","v":-0.70710678118654757},{"$f":"COS(RADIANS(C79))*COS(RADIANS(B79))","v":-1.2994661706391596E-16},{"$f":"-SIN(RADIANS(C79))","v":-0.70710678118654746},null,{"$f":"MMULT(MINVERSE(D79:F81),D75:D77)","v":-0.28646043856691333},"a"]
["forage2",270,55,-0.57357643635104616,-1.0540744271512149E-16,-0.8191520442889918,null,0.41259955716917318,"b"]
["forage3",260,70,-0.33682408883346526,-5.9391174613884719E-2,-0.93969262078590832,null,-0.86630434521969413,"c"]
[null,null,null,null,null,null,null,{"$f":"H79^2+H80^2+H81^2","v":1.0027811959866693},"norme"]
[]
["Note: si la norme du vecteur solution est trop éloignée de 1, c'est dû soit à des erreurs sur les JO , soit que ce n'est pas un plan."]
[]
["12- Composites et coordonnées"]
[null,"x","y","z","azimut","plongée",null,"Longueur des composites"]
["Collet",100,100,100,270,70,null,3]
[]
[null,"à","azimut","plongée","vecteurs unitaires",null,null,"Point milieu","Coordonnées du point milieu"]
[null,0,{"$f":"E88","v":270},{"$f":"F88","v":70},{"$f":"COS(RADIANS(D91))*SIN(RADIANS(C91))","v":-0.34202014332566882},{"$f":"COS(RADIANS(D91))*COS(RADIANS(C91))","v":-6.2853817521460188E-17},{"$f":"-SIN(RADIANS(D91))","v":-0.93969262078590832},"à","x","y","z"]
["Déviation",50,275,67,-0.38924427858041905,3.4054461718113202E-2,-0.92050485345244037,{"$f":"(B91+B92)/2","v":25},{"$f":"B$88+E91*($B92-$B91)","v":82.898992833716562},{"$f":"C$88+F91*($B92-$B91)","v":100},{"$f":"D$88+G91*($B92-$B91)","v":53.015368960704585}]
[null,100,280,65,-0.41619774072678345,7.338689100003809E-2,-0.90630778703664994,{"$f":"(B92+B93)/2","v":75},{"$f":"I92+($H93-$H92)*E92","v":63.436778904695615},{"$f":"J92+($H93-$H92)*F92","v":101.70272308590566},6.9901262880825641]
[null,150,282,60,-0.4890738003669029,0.10395584540887974,-0.8660254037844386,125,{"$f":"I93+($H94-$H93)*E93","v":42.626891868356438},105.37206763590757,-38.325263063749929]
[null,200,285,58,-0.51186270317095361,0.13715319795026823,-0.84804809615642596,175,18.173201850011292,110.56985990635155,-81.626533252971853]
[]
[null,"de","à","teneur(%)","l","lc1","lc2","lc3","lc4","lc5","lc6","…."]
["Analyse",120,122.3,2.72,{"$f":"MIN($C$98-$B$98,3)","v":2.2999999999999972},{"$f":"MAX(MIN($H$88,E98),0)","v":2.2999999999999972},{"$f":"MAX(MIN($H$88,$E98-SUM($F98:F98)),0)","v":0},{"$f":"MAX(MIN($H$88,$E98-SUM($F98:G98)),0)","v":0},{"$f":"MAX(MIN($H$88,$E98-SUM($F98:H98)),0)","v":0},{"$f":"MAX(MIN($H$88,$E98-SUM($F98:I98)),0)","v":0},{"$f":"MAX(MIN($H$88,$E98-SUM($F98:J98)),0)","v":0}]
[null,122.3,124.7,4.3499999999999996,{"$f":"C99-B99","v":2.4000000000000057},{"$f":"MAX(MIN($H$88-SUM(F$98:F98),E99),0)","v":0.70000000000000284},{"$f":"MAX(MIN($H$88-SUM(G$98:G98),$E99-SUM($F99:F99)),0)","v":1.7000000000000028},{"$f":"MAX(MIN($H$88-SUM(H$98:H98),$E99-SUM($F99:G99)),0)","v":0},{"$f":"MAX(MIN($H$88-SUM(I$98:I98),$E99-SUM($F99:H99)),0)","v":0},{"$f":"MAX(MIN($H$88-SUM(J$98:J98),$E99-SUM($F99:I99)),0)","v":0},{"$f":"MAX(MIN($H$88-SUM(K$98:K98),$E99-SUM($F99:J99)),0)","v":0}]
[null,124.7,128.19999999999999,5.25,3.4999999999999858,{"$f":"MAX(MIN($H$88-SUM(F$98:F99),E100),0)","v":0},{"$f":"MAX(MIN($H$88-SUM(G$98:G99),$E100-SUM($F100:F100)),0)","v":1.2999999999999972},{"$f":"MAX(MIN($H$88-SUM(H$98:H99),$E100-SUM($F100:G100)),0)","v":2.1999999999999886},{"$f":"MAX(MIN($H$88-SUM(I$98:I99),$E100-SUM($F100:H100)),0)","v":0},{"$f":"MAX(MIN($H$88-SUM(J$98:J99),$E100-SUM($F100:I100)),0)","v":0},{"$f":"MAX(MIN($H$88-SUM(K$98:K99),$E100-SUM($F100:J100)),0)","v":0}]
[null,128.19999999999999,129.1,2.2799999999999998,0.90000000000000568,{"$f":"MAX(MIN($H$88-SUM(F$98:F100),E101),0)","v":0},{"$f":"MAX(MIN($H$88-SUM(G$98:G100),$E101-SUM($F101:F101)),0)","v":0},{"$f":"MAX(MIN($H$88-SUM(H$98:H100),$E101-SUM($F101:G101)),0)","v":0.80000000000001137},{"$f":"MAX(MIN($H$88-SUM(I$98:I100),$E101-SUM($F101:H101)),0)","v":9.9999999999994316E-2},{"$f":"MAX(MIN($H$88-SUM(J$98:J100),$E101-SUM($F101:I101)),0)","v":0},{"$f":"MAX(MIN($H$88-SUM(K$98:K100),$E101-SUM($F101:J101)),0)","v":0}]
[null,129.1,132,0.83,2.9000000000000057,{"$f":"MAX(MIN($H$88-SUM(F$98:F101),E102),0)","v":0},{"$f":"MAX(MIN($H$88-SUM(G$98:G101),$E102-SUM($F102:F102)),0)","v":0},{"$f":"MAX(MIN($H$88-SUM(H$98:H101),$E102-SUM($F102:G102)),0)","v":0},{"$f":"MAX(MIN($H$88-SUM(I$98:I101),$E102-SUM($F102:H102)),0)","v":2.9000000000000057},{"$f":"MAX(MIN($H$88-SUM(J$98:J101),$E102-SUM($F102:I102)),0)","v":0},{"$f":"MAX(MIN($H$88-SUM(K$98:K101),$E102-SUM($F102:J102)),0)","v":0}]
[null,null,null,null,"teneur",{"$f":"SUM(F98:F102*$D98:$D102)/$H$88","v":3.1003333333333352},{"$f":"SUM(G98:G102*$D98:$D102)/$H$88","v":4.7399999999999993},{"$f":"SUM(H98:H102*$D98:$D102)/$H$88","v":4.4579999999999886},{"$f":"SUM(I98:I102*$D98:$D102)/$H$88","v":0.87833333333333041},{"$f":"SUM(J98:J102*$D98:$D102)/$H$88","v":0},{"$f":"SUM(K98:K102*$D98:$D102)/$H$88","v":0}]
[null,null,null,null,"longueur",{"$f":"SUM(F98:F102)","v":3},3,3,3,0,0]
[]
[]
[]
[]
[null,"Composites formés",null,null,null,"Centre du composite"]
[null,"de ","à","Centre à",null,"x","y","z","teneur","lc","distance avec le composite précédent (pour vérification)"]
[null,{"$f":"$B$98","v":120},{"$f":"B111+$H$88","v":123},{"$f":"(B111+C111)/2","v":121.5},null,{"$f":"IF($D111<$H$94,I$93+($D111-$H$93)/($H$94-$H$93)*(I$94-I$93),I$94+($D111-$H$94)/($H$95-$H$94)*(I$95-I$94))","v":44.083583960900178},{"$f":"IF($D111<$H$94,J$93+($D111-$H$93)/($H$94-$H$93)*(J$94-J$93),J$94+($D111-$H$94)/($H$95-$H$94)*(J$95-J$94))","v":105.11521351740744},-35.153185809121659,{"$f":"TRANSPOSE(F103:K103)","v":3.1003333333333352},{"$f":"TRANSPOSE(F104:K104)","v":3}]
[null,{"$f":"C111","v":123},126,{"$f":"(B112+C112)/2","v":124.5},null,{"$f":"IF($D112<$H$94,I$93+($D112-$H$93)/($H$94-$H$93)*(I$94-I$93),I$94+($D112-$H$94)/($H$95-$H$94)*(I$95-I$94))","v":42.834990738719831},105.33537419040755,-37.872109170231603,4.7399999999999993,3,{"$f":"SQRT((F112-F111)^2+(G112-G111)^2+(H112-H111)^2)","v":2.9999999999999925}]
[null,{"$f":"C112","v":126},129,127.5,null,41.404207367439177,105.63195724942977,-40.490326573211028,4.4579999999999886,3,{"$f":"SQRT((F113-F112)^2+(G113-G112)^2+(H113-H112)^2)","v":2.9983603745541565}]
[null,129,132,130.5,null,39.936985966338469,105.9438247856564,-43.088402784564337,0.87833333333333041,3,2.9999999999999929]
[null,132,135,133.5,null,38.46976456523776,106.25569232188305,-45.686478995917653,0,0,3.0000000000000004]
[null,135,138,136.5,null,37.002543164137052,106.56755985810969,-48.284555207270969,0,0,3.0000000000000004]

{"sheet":"Sondage","index":1,"n_rows":107,"n_cols":13,"rows_kept":107,"cut":false,"hidden":false,"merged":[]}
["Sondages"]
[null,"Légende"]
[null,null,"valeurs à entrer"]
[null,null,"valeurs calculées"]
[]
[]
["1- Conversion azimut-plongée d'un vecteur vers cosinus directeurs (système main droite, composante z du cosinus directeur négative)"]
[null,null,"cosinus directeur",null,null,null,"coord. aires égales",null,"coord. angles égaux"]
["azimut","plongée","a","b","c","norme","x","y","x","y"]
[122,60,{"$f":"COS(RADIANS(B10))*SIN(RADIANS(A10))","v":0.42402404807821314},{"$f":"COS(RADIANS(B10))*COS(RADIANS(A10))","v":-0.26495963211660245},{"$f":"-SIN(RADIANS(B10))","v":-0.8660254037844386},{"$f":"C10^2+D10^2+E10^2","v":1},{"$f":"C10/SQRT(1-$E10)","v":0.31040714682428039},{"$f":"D10/SQRT(1-$E10)","v":-0.19396391266411148},{"$f":"C10/(1-$E10)","v":0.22723380250786554},{"$f":"D10/(1-$E10)","v":-0.14199143890498198}]
[]
["2- Conversion cosinus directeur vers azimut-plongée (angle de plongée positif pour un vecteur qui pointe vers le bas)"]
["azimut","plongée","a","b","c","norme"]
[{"$f":"IF(90-DEGREES(ATAN2(C14,D14))<0,90+360-DEGREES(ATAN2(C14,D14)),90-DEGREES(ATAN2(C14,D14)))","v":215},{"$f":"-DEGREES(ASIN(E14))","v":49.999999999999993},-0.36868782649461246,-0.52654078451836328,-0.76604444311897801,{"$f":"C14^2+D14^2+E14^2","v":1}]
[]
["3- Conversion épaisseur observée en forage vers épaisseur vraie selon le JO"]
["JO","e_obs","e_vraie"]
[35,2.8,{"$f":"SIN(RADIANS(A18))*B18","v":1.6060140217829288}]
[]
["4- Conversion épaisseur vraie vers épaisseur observée en forage selon le JO"]
["JO","e_obs","e_vraie"]
[55,{"$f":"C22/SIN(RADIANS(A22))","v":2.6857040952752036},2.2000000000000002]
[]
["5- Conversion orientation d'un plan en convention géologique vers le pôle du plan "]
["Plan",null,"Pôle",null,"Pôle"]
["azimut","pendage","azimut","plongée","a","b","c"]
[127,59,{"$f":"IF(A27-90<0,A27+270,A27-90)","v":37},{"$f":"90-B27","v":31},{"$f":"COS(RADIANS(D27))*SIN(RADIANS(C27))","v":0.51585615891722048},{"$f":"COS(RADIANS(D27))*COS(RADIANS(C27))","v":0.68456424439209274},{"$f":"-SIN(RADIANS(D27))","v":-0.51503807491005416}]
[]
["6- Conversion pôle du plan vers orientation du plan en convention géologique"]
["Plan",null,"Pôle",null,"Pôle"]
["azimut","pendage","azimut","plongée","a","b","c"]
[{"$f":"MOD(C32+90,360)","v":45},{"$f":"90-D32","v":50},315,40,{"$f":"COS(RADIANS(D32))*SIN(RADIANS(C32))","v":-0.54167522041970195},{"$f":"COS(RADIANS(D32))*COS(RADIANS(C32))","v":0.54167522041970173},{"$f":"-SIN(RADIANS(D32))","v":-0.64278760968653925}]
[]
["7- Calcul du JO à partir des orientations du plan (convention géologique) et du forage"]
["Plan",null,"Pôle",null,"Pôle"]
["azimut","pendage","azimut","plongée","a","b","c"]
[135,50,{"$f":"IF(A37-90<0,A37+270,A37-90)","v":45},{"$f":"90-B37","v":40},{"$f":"COS(RADIANS(D37))*SIN(RADIANS(C37))","v":0.54167522041970184},{"$f":"COS(RADIANS(D37))*COS(RADIANS(C37))","v":0.54167522041970184},{"$f":"-SIN(RADIANS(D37))","v":-0.64278760968653925}]
["Forage"]
["azimut","plongée",null,null,null,null,"JO"]
[90,80,{"$f":"COS(RADIANS(B40))*SIN(RADIANS(A40))","v":0.17364817766693041},{"$f":"COS(RADIANS(B40))*COS(RADIANS(A40))","v":1.0637239828316867E-17},{"$f":"-SIN(RADIANS(B40))","v":-0.98480775301220802},null,{"$f":"DEGREES(ASIN(C40*E37+D40*F37+E40*G37))","v":46.642417214027709}]
[]
["8- Calcul de la distance entre le collet d'un forage et le plan"]
[null,"x","y","z"]
["Collet",100,100,200]
["Point connu dans le plan",50,0,-100]
[null,"azimut","pendage ou plongée","pôle azimut","pôle plongée ","cosinus directeurs",null,null,null,"Distance","Coordonnées du point d'intersection"]
["plan (conv. géol.)",350,30,{"$f":"IF(B47-90<0,B47+270,B47-90)","v":260},{"$f":"90-C47","v":60},{"$f":"COS(RADIANS(E47))*SIN(RADIANS(D47))","v":-0.49240387650610412},{"$f":"COS(RADIANS(E47))*COS(RADIANS(D47))","v":-8.6824088833465179E-2},{"$f":"-SIN(RADIANS(E47))","v":-0.8660254037844386},null,null,"x","y","z"]
["forage",null,null,270,80,-0.17364817766693041,-3.1911719484950597E-17,-0.98480775301220802,null,{"$f":"SUM((B45:D45-B44:D44)*F47:H47)/SUM(F48:H48*F47:H47)","v":312.359846767867},{"$f":"J48*F48:H48+B44:D44","v":45.759281832438269},99.999999999999986,-107.61439882670072]
[]
["9- Calcul de l'inclinaison apparente d'un forage projeté sur une section verticale"]
[null,"azimut","pendage ou plongée","cosinus directeurs"]
["section verticale (conv. géol)",90,null,null,null,null,null,"Plongée apparente"]
["v. horizontal dans section",{"$f":"B52","v":90},0,{"$f":"COS(RADIANS(C53))*SIN(RADIANS(B53))","v":1},{"$f":"COS(RADIANS(C53))*COS(RADIANS(B53))","v":6.1257422745431001E-17},{"$f":"-SIN(RADIANS(C53))","v":0},null,{"$f":"ABS(DEGREES(ATAN(F54/(D53*D54+E53*E54))))","v":61.659225576666813}]
["forage",220,50,{"$f":"COS(RADIANS(C54))*SIN(RADIANS(B54))","v":-0.41317591116653479},{"$f":"COS(RADIANS(C54))*COS(RADIANS(B54))","v":-0.49240387650610407},{"$f":"-SIN(RADIANS(C54))","v":-0.76604444311897801}]
[]
["10- Calcul du pendage apparent d'un plan sur une section verticale"]
[null,"azimut","pendage ou plongée","cosinus directeurs"]
["section verticale (conv. géol)",90,null,null,null,null,null,"pendage apparent"]
["v. horizontal dans section",{"$f":"B58","v":90},0,{"$f":"COS(RADIANS(C59))*SIN(RADIANS(B59))","v":1},{"$f":"COS(RADIANS(C59))*COS(RADIANS(B59))","v":6.1257422745431001E-17},{"$f":"-SIN(RADIANS(C59))","v":0},null,{"$f":"ABS(DEGREES(ATAN((D59*D61+E59*E61)/F61)))","v":22.760476274616646}]
["plan (conv.  géol.)",60,40]
["pôle du plan",{"$f":"IF(B60-90<0,B60+270,B60-90)","v":330},{"$f":"90-C60","v":50},{"$f":"COS(RADIANS(C61))*SIN(RADIANS(B61))","v":-0.32139380484326996},{"$f":"COS(RADIANS(C61))*COS(RADIANS(B61))","v":0.55667039922641925},{"$f":"-SIN(RADIANS(C61))","v":-0.76604444311897801}]
[]
[]
["11- Calcul de l'orientation d'un plan à partir des JO observés dans trois forages non parallèles"]
[null,"angle","angle complémentaire","cosinus de l'angle complémentaire"]
["JO1",54.6,{"$f":"90-B66","v":35.4},{"$f":"COS(RADIANS(C66))","v":0.81512779572855421}]
["JO2",60.92,{"$f":"90-B67","v":29.08},{"$f":"COS(RADIANS(C67))","v":0.87394193287191679}]
["JO3",62.38,27.619999999999997,0.88604180441940439,null,null,null,null,null,"azimut","pendage"]
[null,"azimut","plongée","a","b","c",null,"v. unitaire du plan","plan",{"$f":"IF(90-DEGREES(ATAN2(H70,H71))<0,90+360-DEGREES(ATAN2(H70,H71)),90-DEGREES(ATAN2(H70,H71)))","v":325.22844899643667},{"$f":"-DEGREES(ASIN(H72))","v":60.031979793817094}]
["forage1",270,45,{"$f":"COS(RADIANS(C70))*SIN(RADIANS(B70))","v":-0.70710678118654757},{"$f":"COS(RADIANS(C70))*COS(RADIANS(B70))","v":-1.2994661706391596E-16},{"$f":"-SIN(RADIANS(C70))","v":-0.70710678118654746},null,{"$f":"MMULT(MINVERSE(D70:F72),D66:D68)","v":-0.28646043856691333},"a"]
["forage2",270,55,-0.57357643635104616,-1.0540744271512149E-16,-0.8191520442889918,null,0.41259955716917318,"b"]
["forage3",260,70,-0.33682408883346526,-5.9391174613884719E-2,-0.93969262078590832,null,-0.86630434521969413,"c"]
[null,null,null,null,null,null,null,{"$f":"H70^2+H71^2+H72^2","v":1.0027811959866693},"norme"]
[]
["Note: si la norme du vecteur solution est trop éloignée de 1, c'est dû soit à des erreurs sur les JO , soit que ce n'est pas un plan."]
[]
[]
["12- Composites et coordonnées"]
[null,"x","y","z","azimut","plongée",null,"Longueur des composites"]
["Collet",0,100,55,90,60,null,3]
[]
[null,"à","azimut","plongée","vecteurs unitaires",null,null,"Point milieu","Coordonnées du point milieu"]
[null,0,{"$f":"E80","v":90},{"$f":"F80","v":60},{"$f":"COS(RADIANS(D83))*SIN(RADIANS(C83))","v":0.50000000000000011},{"$f":"COS(RADIANS(D83))*COS(RADIANS(C83))","v":3.0628711372715506E-17},{"$f":"-SIN(RADIANS(D83))","v":-0.8660254037844386},"à","x","y","z"]
["Déviation",80,80,55,0.56486252146362348,9.9600502925051265E-2,-0.8191520442889918,{"$f":"(B83+B84)/2","v":40},{"$f":"B$80+E83*($B84-$B83)","v":40.000000000000007},{"$f":"C$80+F83*($B84-$B83)","v":100},{"$f":"D$80+G83*($B84-$B83)","v":-14.282032302755084}]
[null,180,70,45,0.66446302438867466,0.24184476264797533,-0.70710678118654746,{"$f":"(B84+B85)/2","v":130},{"$f":"I84+($H85-$H84)*E84","v":90.83762693172612},{"$f":"J84+($H85-$H84)*F84","v":108.96404526325462},-88.005716288764347]
[null,230,70,45,{"$f":"COS(RADIANS(D86))*SIN(RADIANS(C86))","v":0.66446302438867466},{"$f":"COS(RADIANS(D86))*COS(RADIANS(C86))","v":0.24184476264797533},{"$f":"-SIN(RADIANS(D86))","v":-0.70710678118654746},205,{"$f":"I85+($H86-$H85)*E85","v":140.67235376087672},{"$f":"J85+($H86-$H85)*F85","v":127.10240246185276},{"$f":"K85+($H86-$H85)*G85","v":-141.03872487775541}]
[]
[null,"de","à","teneur(%)","l","lc1","lc2","lc3","lc4","lc5","lc6","…."]
["Analyse",180,181.5,0.5,{"$f":"MIN($C$89-$B$89,3)","v":1.5},{"$f":"MAX(MIN($H$80,E89),0)","v":1.5},{"$f":"MAX(MIN($H$80,$E89-SUM($F89:F89)),0)","v":0},{"$f":"MAX(MIN($H$80,$E89-SUM($F89:G89)),0)","v":0},{"$f":"MAX(MIN($H$80,$E89-SUM($F89:H89)),0)","v":0},{"$f":"MAX(MIN($H$80,$E89-SUM($F89:I89)),0)","v":0},{"$f":"MAX(MIN($H$80,$E89-SUM($F89:J89)),0)","v":0}]
[null,181.5,184,0.65,{"$f":"C90-B90","v":2.5},{"$f":"MAX(MIN($H$80-SUM(F$89:F89),E90),0)","v":1.5},{"$f":"MAX(MIN($H$80-SUM(G$89:G89),$E90-SUM($F90:F90)),0)","v":1},{"$f":"MAX(MIN($H$80-SUM(H$89:H89),$E90-SUM($F90:G90)),0)","v":0},{"$f":"MAX(MIN($H$80-SUM(I$89:I89),$E90-SUM($F90:H90)),0)","v":0},{"$f":"MAX(MIN($H$80-SUM(J$89:J89),$E90-SUM($F90:I90)),0)","v":0},{"$f":"MAX(MIN($H$80-SUM(K$89:K89),$E90-SUM($F90:J90)),0)","v":0}]
[null,184,184.5,0.72,0.5,{"$f":"MAX(MIN($H$80-SUM(F$89:F90),E91),0)","v":0},{"$f":"MAX(MIN($H$80-SUM(G$89:G90),$E91-SUM($F91:F91)),0)","v":0.5},{"$f":"MAX(MIN($H$80-SUM(H$89:H90),$E91-SUM($F91:G91)),0)","v":0},{"$f":"MAX(MIN($H$80-SUM(I$89:I90),$E91-SUM($F91:H91)),0)","v":0},{"$f":"MAX(MIN($H$80-SUM(J$89:J90),$E91-SUM($F91:I91)),0)","v":0},{"$f":"MAX(MIN($H$80-SUM(K$89:K90),$E91-SUM($F91:J91)),0)","v":0}]
[null,184.5,187.3,1.1000000000000001,2.8000000000000114,{"$f":"MAX(MIN($H$80-SUM(F$89:F91),E92),0)","v":0},{"$f":"MAX(MIN($H$80-SUM(G$89:G91),$E92-SUM($F92:F92)),0)","v":1.5},{"$f":"MAX(MIN($H$80-SUM(H$89:H91),$E92-SUM($F92:G92)),0)","v":1.3000000000000114},{"$f":"MAX(MIN($H$80-SUM(I$89:I91),$E92-SUM($F92:H92)),0)","v":0},{"$f":"MAX(MIN($H$80-SUM(J$89:J91),$E92-SUM($F92:I92)),0)","v":0},{"$f":"MAX(MIN($H$80-SUM(K$89:K91),$E92-SUM($F92:J92)),0)","v":0}]
[null,187.3,189,0.6,1.6999999999999886,{"$f":"MAX(MIN($H$80-SUM(F$89:F92),E93),0)","v":0},{"$f":"MAX(MIN($H$80-SUM(G$89:G92),$E93-SUM($F93:F93)),0)","v":0},{"$f":"MAX(MIN($H$80-SUM(H$89:H92),$E93-SUM($F93:G93)),0)","v":1.6999999999999886},{"$f":"MAX(MIN($H$80-SUM(I$89:I92),$E93-SUM($F93:H93)),0)","v":0},{"$f":"MAX(MIN($H$80-SUM(J$89:J92),$E93-SUM($F93:I93)),0)","v":0},{"$f":"MAX(MIN($H$80-SUM(K$89:K92),$E93-SUM($F93:J93)),0)","v":0}]
[null,null,null,null,"teneur",{"$f":"SUM(F89:F93*$D89:$D93)/$H$80","v":0.57500000000000007},{"$f":"SUM(G89:G93*$D89:$D93)/$H$80","v":0.88666666666666671},{"$f":"SUM(H89:H93*$D89:$D93)/$H$80","v":0.81666666666666854},{"$f":"SUM(I89:I93*$D89:$D93)/$H$80","v":0},{"$f":"SUM(J89:J93*$D89:$D93)/$H$80","v":0},{"$f":"SUM(K89:K93*$D89:$D93)/$H$80","v":0}]
[null,null,null,null,"longueur",{"$f":"SUM(F89:F93)","v":3},3,3,0,0,0]
[]
[]
[]
[]
[null,"Composites formés",null,null,null,"Centre du composite"]
[null,"de ","à","Centre à",null,"x","y","z","teneur","lc","distance avec le composite précédent (pour vérification)"]
[null,{"$f":"$B$89","v":180},{"$f":"B102+$H$80","v":183},{"$f":"(B102+C102)/2","v":181.5},null,{"$f":"IF($D102<$H$86,I$85+($D102-$H$85)/($H$86-$H$85)*(I$86-I$85),I$86+($D102-$H$86)/(#REF!-$H$86)*(#REF!-I$86))","v":125.05747268774286},{"$f":"IF($D102<$H$86,J$85+($D102-$H$85)/($H$86-$H$85)*(J$86-J$85),J$86+($D102-$H$86)/(#REF!-$H$86)*(#REF!-J$86))","v":121.41905053962535},{"$f":"IF($D102<$H$86,K$85+($D102-$H$85)/($H$86-$H$85)*(K$86-K$85),K$86+($D102-$H$86)/(#REF!-$H$86)*(#REF!-K$86))","v":-124.42171551987155},{"$f":"TRANSPOSE(F94:K94)","v":0.57500000000000007},{"$f":"TRANSPOSE(F95:K95)","v":3}]
[null,{"$f":"C102","v":183},186,{"$f":"(B103+C103)/2","v":184.5},null,{"$f":"IF($D103<$H$86,I$85+($D103-$H$85)/($H$86-$H$85)*(I$86-I$85),I$86+($D103-$H$86)/(#REF!-$H$86)*(#REF!-I$86))","v":127.05086176090889},{"$f":"IF($D103<$H$86,J$85+($D103-$H$85)/($H$86-$H$85)*(J$86-J$85),J$86+($D103-$H$86)/(#REF!-$H$86)*(#REF!-J$86))","v":122.14458482756928},{"$f":"IF($D103<$H$86,K$85+($D103-$H$85)/($H$86-$H$85)*(K$86-K$85),K$86+($D103-$H$86)/(#REF!-$H$86)*(#REF!-K$86))","v":-126.54303586343119},0.88666666666666671,3,{"$f":"SQRT((F103-F102)^2+(G103-G102)^2+(H103-H102)^2)","v":2.999999999999996}]
[null,{"$f":"C103","v":186},189,187.5,null,{"$f":"IF($D104<$H$86,I$85+($D104-$H$85)/($H$86-$H$85)*(I$86-I$85),I$86+($D104-$H$86)/(#REF!-$H$86)*(#REF!-I$86))","v":129.04425083407492},{"$f":"IF($D104<$H$86,J$85+($D104-$H$85)/($H$86-$H$85)*(J$86-J$85),J$86+($D104-$H$86)/(#REF!-$H$86)*(#REF!-J$86))","v":122.87011911551319},{"$f":"IF($D104<$H$86,K$85+($D104-$H$85)/($H$86-$H$85)*(K$86-K$85),K$86+($D104-$H$86)/(#REF!-$H$86)*(#REF!-K$86))","v":-128.66435620699082},0.81666666666666854,3,{"$f":"SQRT((F104-F103)^2+(G104-G103)^2+(H104-H103)^2)","v":2.9999999999999925}]
[null,189,192,190.5,null,{"$f":"IF($D105<$H$86,I$85+($D105-$H$85)/($H$86-$H$85)*(I$86-I$85),I$86+($D105-$H$86)/(#REF!-$H$86)*(#REF!-I$86))","v":131.03763990724093},{"$f":"IF($D105<$H$86,J$85+($D105-$H$85)/($H$86-$H$85)*(J$86-J$85),J$86+($D105-$H$86)/(#REF!-$H$86)*(#REF!-J$86))","v":123.59565340345712},{"$f":"IF($D105<$H$86,K$85+($D105-$H$85)/($H$86-$H$85)*(K$86-K$85),K$86+($D105-$H$86)/(#REF!-$H$86)*(#REF!-K$86))","v":-130.78567655055048},0,0,3.0000000000000067]
[null,192,195,193.5,null,{"$f":"IF($D106<$H$86,I$85+($D106-$H$85)/($H$86-$H$85)*(I$86-I$85),I$86+($D106-$H$86)/(#REF!-$H$86)*(#REF!-I$86))","v":133.03102898040697},{"$f":"IF($D106<$H$86,J$85+($D106-$H$85)/($H$86-$H$85)*(J$86-J$85),J$86+($D106-$H$86)/(#REF!-$H$86)*(#REF!-J$86))","v":124.32118769140105},{"$f":"IF($D106<$H$86,K$85+($D106-$H$85)/($H$86-$H$85)*(K$86-K$85),K$86+($D106-$H$86)/(#REF!-$H$86)*(#REF!-K$86))","v":-132.90699689411011},0,0,3.0000000000000053]
[null,195,198,196.5,null,{"$f":"IF($D107<$H$86,I$85+($D107-$H$85)/($H$86-$H$85)*(I$86-I$85),I$86+($D107-$H$86)/(#REF!-$H$86)*(#REF!-I$86))","v":135.02441805357299},{"$f":"IF($D107<$H$86,J$85+($D107-$H$85)/($H$86-$H$85)*(J$86-J$85),J$86+($D107-$H$86)/(#REF!-$H$86)*(#REF!-J$86))","v":125.04672197934497},{"$f":"IF($D107<$H$86,K$85+($D107-$H$85)/($H$86-$H$85)*(K$86-K$85),K$86+($D107-$H$86)/(#REF!-$H$86)*(#REF!-K$86))","v":-135.02831723766977},0,0,3.0000000000000031]

{"sheet":"Gy","index":2,"n_rows":48,"n_cols":8,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["Gy","Définition des variables"]
[null,"a: teneur du minéral d'intérêt (en fraction)"]
[null,"rhoa: masse volumique du minéral d'intérêt (en g/cm3)"]
[null,"rhog: masse volumique de la gangue (en g/cm3)",null,null,null,null,null,"doivent être fournis"]
[null,"Ml: masse du lot à échantillonner (en g)"]
[null,"d0: taille de libération des grains du minéral d'intérêt (en cm)"]
[]
[null,"Me: masse de l'échantillon prélevé (en g)"]
[null,"d: taille des plus gros fragments (en cm, en pratique maille du tamis retenant 5% des particules)"]
[null,"s2r: variance relative (pas d'unités)"]
[null,"sr: écart-type relatif (sr2^0.5)"]
[]
["Saisie des paramètres connus"]
[null,"Calcul de a"]
["teneur du métal dans la roche",2E-3,"fraction",null,null,"Note: cet exemple est pour de l'or natif"]
["teneur du métal dans le minéral d'intérêt",0.34622000000000003,"fraction"]
[null,null,"a: teneur du minéral d'intérêt",{"$f":"$B$15/$B$16","v":5.7766737912310091E-3},"fraction"]
["rhoa (masse spécifique du minéral d'intérêt)",4.2,"g/cm^3"]
["rhog (masse spécifique de la gangue)",3,"g/cm^3"]
["Ml (masse initiale du lot)",32000,"g",null,null,"a"]
["d0 (taille de libération)",0.05,"cm"]
["f (facteur de forme)",0.5,"paramètre de forme (sans unités)"]
["g (facteur granulométrique)",0.25,"facteur granulométrique (sans unités)"]
[]
["1, 2 et 3 Saisie des paramètres désirés. Sr Me et d correpondant aux deux autres paramètres fixés sont calculés en B32, B33 et B36 "]
[null,null,null,"Calculs intermédiaires"]
["sr",0.01,"sans unités","facteur de libération",{"$f":"IF($B29<$B21,1,SQRT($B21/$B29))","v":0.70710678118654757}]
["Me",350,"g","mu-delta",{"$f":"(1-$D17)/$D17*((1-$D17)*$B18+$D17*$B19)","v":721.66893200854952},"g/cm^3"]
["d",0.1,"cm","constante K",{"$f":"E28*B22*B23","v":90.20861650106869},"g/cm^3"]
[]
[null,"réponses"]
["sr2",{"$f":"$E$29*$E$27*$B$29^3/$B$28*(1-$B$28/$B$20)","v":1.8025557935913566E-4}]
["sr",{"$f":"SQRT(B32)","v":1.3425929366682058E-2},null,"sr calculé avec Me et d lus en B28 et B29"]
["Me",{"$f":"($B$27^2/($E$29*$E$27*B$29^3)+1/$B$20)^(-1)","v":625.40475360321409},"g","Me calculé avec sr et d lus en B27 et B29"]
["d1",{"$f":"($B$27^2/($E$29*(1/$B$28-1/$B$20)))^(1/3)","v":7.3203542029608382E-2},"cm","calcul en supposant que d<d0"]
["d2",{"$f":"($B$27^2/(SQRT($B$21)*$E$29*(1/$B$28-1/$B$20)))^(1/3)","v":0.12060642045000083},"cm","calcul en supposant que d>d0"]
["d",{"$f":"IF($B$35<=$B$21,$B35,$B$36)","v":0.12060642045000083},"cm","d calculé avec sr et Me lus en B27 et B28, valeur à retenir (un seul de d1 ou d2 respecte l'hypothèse formulée)"]
[]
[]
["4- Procédure multistage"]
["(dans une procédure multistage, la masse de l'échantillon prélevé à l'étape k devient la masse du lot à l'étape k+1)"]
[]
["On utilise les paramètres connus donnés plus haut"]
[null,"Me","d","facteur de libération","sr2","sr"]
["stage 1",22000,0.5,{"$f":"MIN(1,SQRT($B$21/C45))","v":0.31622776601683794},{"$f":"D45*$E$29*C45^3/B45*(1-B45/$B$20)","v":5.0650691178271692E-5},{"$f":"SQRT(E45)","v":7.1169298983671109E-3}]
["stage 2",1250,0.1,{"$f":"MIN(1,SQRT($B$21/C46))","v":0.70710678118654757},{"$f":"D46*$E$29*C46^3/B46*(1-B46/B45)","v":4.8130284811791618E-5},{"$f":"SQRT(E46)","v":6.9375993550933462E-3}]
["stage 3",30,8.9999999999999998E-4,1,{"$f":"D47*$E$29*C47^3/B47*(1-B47/B46)","v":2.1394597158325458E-9},4.6254294025879864E-5]
["Total",null,null,null,{"$f":"SUM(E45:E47)","v":9.8783115449779151E-5},{"$f":"SQRT(E48)","v":9.9389695366159138E-3}]

{"sheet":"Lane","index":3,"n_rows":49,"n_cols":14,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["Lane",null,null,null,null,null,null,null,null,null,null,"Légende"]
[null,null,null,null,null,null,null,null,null,null,null,"données du problème"]
["1- Calcul des teneurs limites et valeurs/t. minéralisée associées"]
["2- Calcul des teneurs d'équilibre et valeurs/t. minéralisée associées (faire rouler la macro)",null,null,null,null,null,null,null,null,null,null,"champ calculé, ne pas modifier"]
["3- Calcul de la teneur de coupure optimale et valeur/t. minéralisée associée",null,null,null,null,null,null,null,null,null,null,"calcul intermédiaire"]
[]
["Paramètres du problème à saisir"]
[null,2500,"(p-k): prix net du métal  (en $/t métal)"]
[null,0.85,"y: taux de récupération (fraction)"]
[]
[null,4,"m: coût de minage (développement) (en $/t minéralisée)"]
[null,5,"h: coût de traitement (tout ce qui est associé au minerai) (en $/t minerai)"]
[null,10,"f: frais fixes annuels (M$)"]
[]
[null,25,"M: capacité annuelle de développement (Mt matériau minéralisé)"]
[null,15,"H: capacité annuelle de traitement (Mt de minerai) (H<M)"]
[]
[null,0.7,"moy: moyenne de la distribution des teneurs dans le matériau minéralisé (loi lognormale)"]
[null,1,"s2: variance de la distribution des teneurs dans le matériau minéralisé (loi lognormale)"]
[null,100,"Unités des teneurs 100 pour des % ou 1e06 pour des ppm"]
[]
["1- Calcul des teneurs limites et valeurs/t. minéralisée associées"]
[null,"teneur",null,null,null,null,"valeur ($/t minéralisée)",null,null,null,"calcul","calcul","xc","gc"]
[null,{"$f":"$B$12/($B$9*$B$8)*$B$20","v":0.23529411764705879},"c1: t.c. limite de la mine",null,null,null,{"$f":"$B$8*$M24*$N24/$B$20*$B$9-$M24*$B$12-$B$11-$B$13/$B$15","v":6.1248734188296137},"calcul avec courbe v1",null,null,{"$f":"1/$B$38*LN($B$18/B24)-$B$38/2","v":0.50653734152832619},{"$f":"1/$B$38*LN($B$18/B24)+$B$38/2","v":1.5611111928231667},{"$f":"NORMSDIST(K24)","v":0.69376025875763436},{"$f":"NORMSDIST(L24)*$B$18/M24","v":0.949212441208929}]
[null,{"$f":"($B$12+$B$13/$B$16)/($B$9*$B$8)*$B$20","v":0.26666666666666672},"c2: t.c. limite du traitement ",null,null,null,{"$f":"$B$8*$M25*$N25/$B$20*$B$9-$M25*$B$12-$B$11-$B$13*$M$25/$B$16","v":6.0768125837525844},"calcul avec courbe v2 ",null,null,{"$f":"1/$B$38*LN($B$18/B25)-$B$38/2","v":0.38785135021503214},{"$f":"1/$B$38*LN($B$18/B25)+$B$38/2","v":1.4424252015098729},{"$f":"NORMSDIST(K25)","v":0.65093697889621827},{"$f":"NORMSDIST(L25)*$B$18/M25","v":0.99515953232297927}]
[]
[]
["2- Calcul des teneurs d'équilibre et valeurs/t. minéralisée associées"]
[null,"teneur",null,null,null,null,"valeur ($/t minéralisée)",null,null,null,"calcul","calcul","xc","gc"]
[null,{"$f":"$B$49","v":0.30730603288715419},"c12: t.c. d'équilibre mine-traitement ",null,null,null,{"$f":"$B$8*$M30*$N30/$B$20*$B$9-$M30*$B$12-$B$11-$B$13/$B$15","v":6.055180347277771},"calcul avec courbe v1 ",null,null,{"$f":"1/$B$38*LN($B$18/B30)-$B$38/2","v":0.25334710313579978},{"$f":"1/$B$38*LN($B$18/B30)+$B$38/2","v":1.3079209544306405},{"$f":"NORMSDIST(K30)","v":0.6},{"$f":"NORMSDIST(L30)*$B$18/M30","v":1.0553082625315899}]
[]
["3- Calcul de la teneur de coupure optimale et valeur/t. minéralisée associée"]
[null,"teneur",null,null,null,null,"valeur ($/t minéralisée)"]
[null,{"$f":"IF(AND($B$30<$B$25,$B30>$B$24),$B$30,IF($B$30<$B$24,$B$24,$B$25))","v":0.26666666666666672},"milieu du triplet c1, c2, c12: t.c. optimale",null,null,null,{"$f":"IF($B$34=$B$30,$G$30,IF($B$34=$B$24,$G$24,$G$25))","v":6.0768125837525844},"valeur optimale ($/t. minéralisée)"]
[]
["4- Loi lognormale (diapo 44)"]
[null,{"$f":"LN($B$19/$B$18^2+1)","v":1.1121260078348327},"beta^2: variance logarithmique"]
[null,{"$f":"SQRT($B$37)","v":1.0545738512948406},"beta: écart-type logarithmique"]
[null,{"$f":"1/$B$38*LN($B$18/$B$42)-$B$38/2","v":-0.20822701703307228},"valeur intermédiaire pour calcul de xc"]
[null,{"$f":"1/$B$38*LN($B$18/$B$42)+$B$38/2","v":0.84634683426176838},"valeur intermédiaire pour calcul de Qc"]
[]
[null,0.5,"c: teneur de coupure considérée (>c est du minerai)"]
[null,{"$f":"NORMSDIST(B39)","v":0.41752585717774165},"xc=Tc/T0 proportion du tonnage au-dessus de la teneur c (i.e. proportion de minerai)"]
[null,{"$f":"NORMSDIST($B$40)*$B$18","v":0.56092424916296413},"Qc/T0: quantité de métal par tonne minéralisée (mêmes unités que la teneur)"]
[null,{"$f":"$B$44/$B$43","v":1.343447931475481},"gc= Qx/xc: teneur du minerai"]
[null,null,null,"note: Qc, gc et c ont les mêmes unités (ex. % ou ppm)"]
[]
[null,{"$f":"$B$16/$B$15","v":0.6},"xc à l'équilibre"]
[null,{"$f":"$B$18*EXP(-(_xlfn.NORM.S.INV($B$48)+$B$38/2)*$B$38)","v":0.30730603288715419},"t.c. équilibre mine-traitement"]

{"sheet":"Ressources","index":4,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["1- Interpolation linéaire sur un triangle (2D)"]
["Point à estimer"]
["x0","y0",null,"Valeur estimée"]
[0,0,null,{"$f":"$A$4*$J$7+$B$4*$J$8+$J$9","v":6.6625000000000005}]
["Données (trois sommets du triangle qui contient le point x0)"]
["x","y","constante","valeur",null,"matrice inverse",null,null,null,"Équation du plan"]
[3,0,1,13,null,{"$f":"MINVERSE(A7:C9)","v":0.25},-0.125,-0.125,null,{"$f":"MMULT(F7:H9,D7:D9)","v":2.1125000000000003}]
[-2,3,1,3.4,null,8.3333333333333329E-2,0.125,-0.20833333333333334,null,0.3208333333333333]
[0,-3,1,5.7,null,0.25,0.375,0.375,null,6.6625000000000005]
[]
[]
["2- Inverse de la distance (2D ou 3D)"]
["Point à estimer"]
["x0","y0","z0","Valeur estimée","Exposant","dmax","ax","ay","az"]
[10,5,0,{"$f":"SUM(J19:J38*D19:D38)","v":1.2874430150337042},3,10,1,1,1,"Pour untroduire une anisotropie modifier un ou deux des facteurs ax,ay,az"]
[]
["Données"]
["x","y","z","valeur",null,"Distance^b avec x0","D. euclid.","<dmax ?","inverse distance","poids"]
[3,0,null,3,null,{"$f":"SQRT(($G$15*(A19-$A$15))^2+($H$15*(B19-$B$15))^2+($I$15*(C19-$C$15))^2)^$E$15","v":636.57206976115435},{"$f":"SQRT(($G$15*(A19-$A$15))^2+($H$15*(B19-$B$15))^2+($I$15*(C19-$C$15))^2)","v":8.6023252670426267},{"$f":"IF(G19<$F$15,1,0)","v":1},{"$f":"1/F19*H19","v":1.5709140370786391E-3},{"$f":"I19/$I$39","v":6.3140743371672726E-3}]
[-2,3,null,0.4,null,{"$f":"SQRT(($G$15*(A20-$A$15))^2+($H$15*(B20-$B$15))^2+($I$15*(C20-$C$15))^2)^$E$15","v":1800.4977089682725},{"$f":"SQRT(($G$15*(A20-$A$15))^2+($H$15*(B20-$B$15))^2+($I$15*(C20-$C$15))^2)","v":12.165525060596439},{"$f":"IF(G20<$F$15,1,0)","v":0},0,0]
[-7,10,null,1.3,null,5564.0941760541746,17.720045146669349,0,0,0]
[-7,0,null,1.5,null,5564.0941760541746,17.720045146669349,0,0,0]
[5,8,null,0.8,null,198.25236442474022,5.8309518948453007,1,5.0440760336032007E-3,2.0273974442116545E-2]
[-8,1,null,2.2000000000000002,null,6269.2902309591636,18.439088914585774,0,0,0]
[-5,-7,null,3,null,7088.2585308381631,19.209372712298546,0,0,0]
[8,10,null,0.9,null,156.1697794069006,5.3851648071345037,1,6.4032875233466166E-3,2.5737139315308254E-2]
[5,-7,null,1.7,null,2197,13,0,0,0]
[-7,-9,null,2.1,null,10681.01703958944,22.022715545545239,0,0,0]
[-4,-8,null,4.3,null,6973.3152087081207,19.104973174542799,0,0,0]
[0,-7,null,2.2000000000000002,null,3811.4018418424466,15.620499351813308,0,0,0]
[9,7,null,0.9,null,11.180339887498951,2.2360679774997898,1,8.9442719099991574E-2,0.35950278881329195]
[7,7,null,0.6,null,46.872166581031856,3.6055512754639891,1,2.1334622931739582E-2,8.5751601912571015E-2]
[1,-9,null,0.6,null,4610.198802654827,16.643316977093239,0,0,0]
[-3,-6,null,5.9,null,4938.5220461186582,17.029386365926403,0,0,0]
[-4,6,null,1.6,null,2765.026762980785,14.035668847618199,0,0,0]
[8,-8,null,3.9,null,2275.4597337681016,13.152946437965905,0,0,0]
[-8,-5,null,4.2,null,8730.6943595569774,20.591260281974002,0,0,0]
[8,5,null,1.7,null,8,2,1,0.125,0.50242042117954488]
[null,null,null,null,null,null,"Somme",{"$f":"SUM(H19:H38)","v":6},{"$f":"SUM(I19:I38)","v":0.24879561962575963},{"$f":"SUM(J19:J38)","v":1}]

{"sheet":"Variogrammes","index":5,"n_rows":48,"n_cols":11,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["1- Programme pour calculer le variogramme en 1D pour des données régulièrement espacées"]
[]
["Nonbre de données",18,null,"Variogramme expérimental"]
["x","Z(x)",null,"h","N(h)","gamma(h)"]
[1,1.2,null,1,{"$f":"$B$3-1","v":17},{"$f":"AVERAGE((B$5:INDIRECT(_xlfn.CONCAT(\"B\",$B$3-D5+4))-INDIRECT(_xlfn.CONCAT(\"B\",5+D5)):INDIRECT(_xlfn.CONCAT(\"B\",$B$3+4)))^2)*0.5","v":0.26147058823529412},null,null,"\""]
[{"$f":"A5+1","v":2},2.1,null,{"$f":"D5+1","v":2},{"$f":"$E5-1","v":16},{"$f":"AVERAGE((B$5:INDIRECT(_xlfn.CONCAT(\"B\",$B$3-D6+4))-INDIRECT(_xlfn.CONCAT(\"B\",5+D6)):INDIRECT(_xlfn.CONCAT(\"B\",$B$3+4)))^2)*0.5","v":0.40250000000000002}]
[{"$f":"A6+1","v":3},2.5,null,{"$f":"D6+1","v":3},15,{"$f":"AVERAGE((B$5:INDIRECT(_xlfn.CONCAT(\"B\",$B$3-D7+4))-INDIRECT(_xlfn.CONCAT(\"B\",5+D7)):INDIRECT(_xlfn.CONCAT(\"B\",$B$3+4)))^2)*0.5","v":0.48466666666666675}]
[4,2,null,4,14,{"$f":"AVERAGE((B$5:INDIRECT(_xlfn.CONCAT(\"B\",$B$3-D8+4))-INDIRECT(_xlfn.CONCAT(\"B\",5+D8)):INDIRECT(_xlfn.CONCAT(\"B\",$B$3+4)))^2)*0.5","v":0.565357142857143}]
[5,0.8,null,5,13,{"$f":"AVERAGE((B$5:INDIRECT(_xlfn.CONCAT(\"B\",$B$3-D9+4))-INDIRECT(_xlfn.CONCAT(\"B\",5+D9)):INDIRECT(_xlfn.CONCAT(\"B\",$B$3+4)))^2)*0.5","v":0.65346153846153865}]
[6,0.9,null,6,12,{"$f":"AVERAGE((B$5:INDIRECT(_xlfn.CONCAT(\"B\",$B$3-D10+4))-INDIRECT(_xlfn.CONCAT(\"B\",5+D10)):INDIRECT(_xlfn.CONCAT(\"B\",$B$3+4)))^2)*0.5","v":0.80958333333333365}]
[7,1.3,null,7,11,{"$f":"AVERAGE((B$5:INDIRECT(_xlfn.CONCAT(\"B\",$B$3-D11+4))-INDIRECT(_xlfn.CONCAT(\"B\",5+D11)):INDIRECT(_xlfn.CONCAT(\"B\",$B$3+4)))^2)*0.5","v":0.93136363636363662}]
[8,1.7,null,8,10,{"$f":"AVERAGE((B$5:INDIRECT(_xlfn.CONCAT(\"B\",$B$3-D12+4))-INDIRECT(_xlfn.CONCAT(\"B\",5+D12)):INDIRECT(_xlfn.CONCAT(\"B\",$B$3+4)))^2)*0.5","v":0.83200000000000007}]
[9,1.9,null,9,9,{"$f":"AVERAGE((B$5:INDIRECT(_xlfn.CONCAT(\"B\",$B$3-D13+4))-INDIRECT(_xlfn.CONCAT(\"B\",5+D13)):INDIRECT(_xlfn.CONCAT(\"B\",$B$3+4)))^2)*0.5","v":0.88611111111111107}]
[{"$f":"A13+1","v":10},1.8,null,10,8,{"$f":"AVERAGE((B$5:INDIRECT(_xlfn.CONCAT(\"B\",$B$3-D14+4))-INDIRECT(_xlfn.CONCAT(\"B\",5+D14)):INDIRECT(_xlfn.CONCAT(\"B\",$B$3+4)))^2)*0.5","v":1.1662499999999998}]
[11,3.2,null,11,7,{"$f":"AVERAGE((B$5:INDIRECT(_xlfn.CONCAT(\"B\",$B$3-D15+4))-INDIRECT(_xlfn.CONCAT(\"B\",5+D15)):INDIRECT(_xlfn.CONCAT(\"B\",$B$3+4)))^2)*0.5","v":1.175}]
[12,3.5,null,12,6,{"$f":"AVERAGE((B$5:INDIRECT(_xlfn.CONCAT(\"B\",$B$3-D16+4))-INDIRECT(_xlfn.CONCAT(\"B\",5+D16)):INDIRECT(_xlfn.CONCAT(\"B\",$B$3+4)))^2)*0.5","v":0.99249999999999983}]
[13,2.7,null,13,5,{"$f":"AVERAGE((B$5:INDIRECT(_xlfn.CONCAT(\"B\",$B$3-D17+4))-INDIRECT(_xlfn.CONCAT(\"B\",5+D17)):INDIRECT(_xlfn.CONCAT(\"B\",$B$3+4)))^2)*0.5","v":0.78099999999999992}]
[14,2.8,null,14,4,{"$f":"AVERAGE((B$5:INDIRECT(_xlfn.CONCAT(\"B\",$B$3-D18+4))-INDIRECT(_xlfn.CONCAT(\"B\",5+D18)):INDIRECT(_xlfn.CONCAT(\"B\",$B$3+4)))^2)*0.5","v":0.56874999999999998}]
[15,3.1,null,15,3,{"$f":"AVERAGE((B$5:INDIRECT(_xlfn.CONCAT(\"B\",$B$3-D19+4))-INDIRECT(_xlfn.CONCAT(\"B\",5+D19)):INDIRECT(_xlfn.CONCAT(\"B\",$B$3+4)))^2)*0.5","v":0.48999999999999994}]
[16,2.2999999999999998,null,16,2,{"$f":"AVERAGE((B$5:INDIRECT(_xlfn.CONCAT(\"B\",$B$3-D20+4))-INDIRECT(_xlfn.CONCAT(\"B\",5+D20)):INDIRECT(_xlfn.CONCAT(\"B\",$B$3+4)))^2)*0.5","v":1.2200000000000002}]
[17,3.4,null,17,1,{"$f":"AVERAGE((B$5:INDIRECT(_xlfn.CONCAT(\"B\",$B$3-D21+4))-INDIRECT(_xlfn.CONCAT(\"B\",5+D21)):INDIRECT(_xlfn.CONCAT(\"B\",$B$3+4)))^2)*0.5","v":0.60499999999999987}]
[18,2.2999999999999998]
[]
["2- Calculer valeurs de variogrammes théoriques (isotrope) et de covariance en fonction de h"]
[]
[null,"Pépite",null,"Sphérique",null,"Exponentiel",null,"Gaussien",null,"h^b "]
[null,"C0",null,"C","a","C","a","C","a","a","b"]
[null,3,null,10,56,10,100,2.2999999999999998,12,1,1.5]
["h","gamma(h)","C(h)","gamma(h)","C(h)","gamma(h)","C(h)","gamma(h)","C(h)","gamma(h_"]
[10,{"$f":"IF(A30>0,$B$28,0)","v":3},0,{"$f":"$D$28*(1.5*MIN(E$28,A30)/$E$28-0.5*(MIN(E$28,A30)/$E$28)^3)","v":2.650100218658892},{"$f":"D$28-D30","v":7.349899781341108},{"$f":"F$28*(1-EXP(-3*$A30/$G$28))","v":2.5918177931828215},{"$f":"F$28-F30","v":7.4081822068171785},{"$f":"H$28*(1-EXP(-3*($A30/$I$28)^2))","v":2.0136167156785172},{"$f":"H$28-H30","v":0.28638328432148263},{"$f":"($A30/$J$28)^$K$28","v":31.622776601683803}]
[]
["3- Cas d'un effet de pépite + 2 sphériques de portée et palier différents"]
[]
[null,"Pépite",null,"Sphérique 1",null,"Sphérique 2"]
[null,"C0",null,"C","a","C","a"]
[null,3,null,22,56,36,150,"Total"]
["h","gamma(h)","C(h)","gamma(h)","C(h)","gamma(h)","C(h)","gamma(h)","C(h)"]
[10,{"$f":"IF(A38>0,$B$36,0)","v":3},0,{"$f":"$D$36*(1.5*MIN(E$36,A38)/$E$36-0.5*(MIN(E$36,A38)/$E$36)^3)","v":5.8302204810495617},{"$f":"D$28-D38","v":4.1697795189504383},{"$f":"F$36*(1.5*MIN(G$36,A38)/G$36-0.5*(MIN(G$36,A38)/G$36)^3)","v":3.5946666666666669},{"$f":"F$36-F38","v":32.405333333333331},{"$f":"B38+D38+F38","v":12.424887147716229},36.575112852283766]
[]
[]
["4- Calculer la portée dans une direction donnée sachant les portées selon les deux directions principales (anisotropie géométrique)"]
[]
[null,null,null,"Exemples pour tester vos calculs"]
["Grande portée",null,null,1000,55]
["Petite portée",null,null,300,20,null,"Note: Lorsqu'il y a plus d'une composante anisotrope, il faut faire le calcul séparément pour chaque composante"]
["azimut selon la grande portée",null,null,87,135]
["azimut souhaité",null,null,60,80]
["portée selon l'azimut souhaité",null,null,{"$f":"D44*D45/SQRT(D45^2*COS(RADIANS(D46-D47))^2+D44^2*SIN(RADIANS(D46-D47))^2)","v":569.43558927615129},{"$f":"E44*E45/SQRT(E45^2*COS(RADIANS(E46-E47))^2+E44^2*SIN(RADIANS(E46-E47))^2)","v":23.66055715508978}]

{"sheet":"Variance_bloc","index":6,"n_rows":158,"n_cols":28,"rows_kept":158,"cut":false,"hidden":false,"merged":[]}
["Taille des blocs",null,null,null,"Variance de bloc",null,"Variance d'un point dans un bloc"]
["vx",50,null,"sphérique",{"$f":"$B$7-$B$7*AVERAGE(1.5*(B132:AB158)-0.5*((B132:AB158)^3))","v":59.134002652031995},null,{"$f":"$B$6+$B$7-E2","v":70.865997347968005},null,null,null,null,null,null,{"$f":"E2/3","v":19.711334217344}]
["vy",50,null,"exponentiel",{"$f":"$B$7*AVERAGE(EXP(-3*(B104:AB130)))","v":44.771280428875642},null,{"$f":"$B$6+$B$7-E3","v":85.228719571124358}]
["vz",5,null,"gaussien",{"$f":"$B$7*AVERAGE(EXP(-3*((B104:AB130)^2)))","v":79.689965540468151},null,{"$f":"$B$6+$B$7-E4","v":50.310034459531849}]
[]
["C0",10,null,null,"Explication de la démarche"]
["C",120,null,null,"1- une grille interne centrée de 3x3x3 points également espacés est générée en 3D pour un bloc unitaire (1x1x1) "]
["ax",80,null,null,"2- les écarts hx, hy et hz entre tous ces points sont calculés et multipliés par vx/ax, vy/ay et vz/az pour tenir compte de la taille du bloc souhaité et des portées dans chaque direction. Le carré est calculé."]
["ay",80,null,null,"3- on calcule les h entre ces points (plage B104 à AB130) pour gaussien et exponentiel où la distance jusqu'à un max de 1 pour le sphérique (plage B132:AB158)"]
["az",10,null,null,"4- on fait la moyenne des 27x27 valeurs de la covariance (variance de bloc) ou du variogramme (variance d'un point dans le bloc) "]
[]
["vx/ax",{"$f":"B2/B8","v":0.625},null,null,"Note: Il s'agit d'une approximation car la grille 3x3x3 est un peu petite pour avoir une bone précision et excel n'est pas super numériquement"]
["vy/ay",{"$f":"B3/B9","v":0.625},null,null,"Note: en divisant par ax, ay et az, les portées applicables deviennent 1 dans toutes les directions"]
["vz/az",0.5,null,null,"Note: ici on suppose que les blocs sont parallèeles aux directions d'anisotropie. Si ce n'est pas le cas, il faudrait appliquer une rotation aux points de discrétisation pour les rendre parallèles aux directions d'anisotropie."]
[]
[]
["hx^2",{"$f":"TRANSPOSE(A18:A44)","v":-0.33333333333333298},0,0.33333333333333298,-0.33333333333333298,0,0.33333333333333298,-0.33333333333333298,0,0.33333333333333298,-0.33333333333333298,0,0.33333333333333298,-0.33333333333333298,0,0.33333333333333298,-0.33333333333333298,0,0.33333333333333298,-0.33333333333333298,0,0.33333333333333298,-0.33333333333333298,0,0.33333333333333298,-0.33333333333333298,0,0.33333333333333298]
[-0.33333333333333298,{"$f":"((B$17-$A18)*$B$12)^2","v":0},4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,{"$f":"((R$17-$A18)*$B$12)^2","v":4.3402777777777686E-2},0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074]
[0,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2]
[0.33333333333333298,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0]
[-0.33333333333333298,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074]
[0,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2]
[0.33333333333333298,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0]
[-0.33333333333333298,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074]
[0,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2]
[0.33333333333333298,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0]
[-0.33333333333333298,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074]
[0,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2]
[0.33333333333333298,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0]
[-0.33333333333333298,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074]
[0,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2]
[0.33333333333333298,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0]
[-0.33333333333333298,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,{"$f":"((Q$17-$A33)*$B$12)^2","v":0},4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074]
[0,{"$f":"((B$17-$A34)*$B$12)^2","v":4.3402777777777686E-2},0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,{"$f":"((AB$17-$A34)*$B$12)^2","v":4.3402777777777686E-2}]
[0.33333333333333298,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0]
[-0.33333333333333298,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074]
[0,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2]
[0.33333333333333298,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0]
[-0.33333333333333298,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074]
[0,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2]
[0.33333333333333298,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0]
[-0.33333333333333298,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074]
[0,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2]
[0.33333333333333298,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0]
[]
["hy^2",{"$f":"TRANSPOSE(A47:A73)","v":-0.33333333333333298},-0.33333333333333298,-0.33333333333333298,0,0,0,0.33333333333333298,0.33333333333333298,0.33333333333333298,-0.33333333333333298,-0.33333333333333298,-0.33333333333333298,0,0,0,0.33333333333333298,0.33333333333333298,0.33333333333333298,-0.33333333333333298,-0.33333333333333298,-0.33333333333333298,0,0,0,0.33333333333333298,0.33333333333333298,0.33333333333333298]
[-0.33333333333333298,{"$f":"((B$17-$A47)*$B$13)^2","v":0},{"$f":"((C$17-$A47)*$B$13)^2","v":4.3402777777777686E-2},0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,{"$f":"((S$17-$A47)*$B$13)^2","v":0.17361111111111074},0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074]
[-0.33333333333333298,{"$f":"((B$17-$A48)*$B$13)^2","v":0},4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074]
[-0.33333333333333298,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074]
[0,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2]
[0,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2]
[0,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2]
[0.33333333333333298,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0]
[0.33333333333333298,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0]
[0.33333333333333298,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0]
[-0.33333333333333298,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074]
[-0.33333333333333298,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074]
[-0.33333333333333298,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074]
[0,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2]
[0,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2]
[0,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2]
[0.33333333333333298,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,{"$f":"((R$17-$A62)*$B$13)^2","v":4.3402777777777686E-2},0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0]
[0.33333333333333298,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0]
[0.33333333333333298,{"$f":"((B$17-$A64)*$B$13)^2","v":0.17361111111111074},4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0]
[-0.33333333333333298,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074]
[-0.33333333333333298,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074]
[-0.33333333333333298,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074,0,4.3402777777777686E-2,0.17361111111111074]
[0,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2]
[0,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2]
[0,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2,4.3402777777777686E-2,0,4.3402777777777686E-2]
[0.33333333333333298,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0]
[0.33333333333333298,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0]
[0.33333333333333298,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0,0.17361111111111074,4.3402777777777686E-2,0]
[]
["hz^2",{"$f":"TRANSPOSE(A76:A102)","v":-0.33333333333333298},-0.33333333333333298,-0.33333333333333298,-0.33333333333333298,-0.33333333333333298,-0.33333333333333298,-0.33333333333333298,-0.33333333333333298,-0.33333333333333298,0,0,0,0,0,0,0,0,0,0.33333333333333298,0.33333333333333298,0.33333333333333298,0.33333333333333298,0.33333333333333298,0.33333333333333298,0.33333333333333298,0.33333333333333298,0.33333333333333298]
[-0.33333333333333298,{"$f":"((B$17-$A76)*$B$14)^2","v":0},{"$f":"((C$17-$A76)*$B$14)^2","v":2.7777777777777721E-2},0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,{"$f":"((S$17-$A76)*$B$14)^2","v":0.11111111111111088},0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088]
[-0.33333333333333298,{"$f":"((B$17-$A77)*$B$14)^2","v":0},2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088]
[-0.33333333333333298,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088]
[-0.33333333333333298,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088]
[-0.33333333333333298,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088]
[-0.33333333333333298,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088]
[-0.33333333333333298,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088]
[-0.33333333333333298,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088]
[-0.33333333333333298,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088,0,2.7777777777777721E-2,0.11111111111111088]
[0,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2]
[0,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2]
[0,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2]
[0,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2]
[0,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2]
[0,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2]
[0,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,{"$f":"((R$17-$A91)*$B$14)^2","v":0},2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2]
[0,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2]
[0,{"$f":"((B$17-$A93)*$B$14)^2","v":2.7777777777777721E-2},0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2,2.7777777777777721E-2,0,2.7777777777777721E-2]
[0.33333333333333298,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0]
[0.33333333333333298,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0]
[0.33333333333333298,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0]
[0.33333333333333298,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0]
[0.33333333333333298,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0]
[0.33333333333333298,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0]
[0.33333333333333298,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0]
[0.33333333333333298,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0]
[0.33333333333333298,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0,0.11111111111111088,2.7777777777777721E-2,0]
[]
["h",{"$f":"SQRT(B18+B47+B76)","v":0},{"$f":"SQRT(C18+C47+C76)","v":0.33850160019316466},0.67700320038632933,0,0.33850160019316466,0.67700320038632933,0,0.33850160019316466,0.67700320038632933,0,0.33850160019316466,0.67700320038632933,0,0.33850160019316466,0.67700320038632933,0,0.33850160019316466,0.67700320038632933,0,0.33850160019316466,0.67700320038632933,0,0.33850160019316466,0.67700320038632933,0,0.33850160019316466,0.67700320038632933]
[null,{"$f":"SQRT(B19+B48+B77)","v":0.20833333333333312},0.26679684322636843,0.57282196186947942,0.20833333333333312,0.26679684322636843,0.57282196186947942,0.20833333333333312,0.26679684322636843,0.57282196186947942,0.20833333333333312,0.26679684322636843,0.57282196186947942,0.20833333333333312,0.26679684322636843,0.57282196186947942,0.20833333333333312,0.26679684322636843,0.57282196186947942,0.20833333333333312,0.26679684322636843,0.57282196186947942,0.20833333333333312,0.26679684322636843,0.57282196186947942,0.20833333333333312,0.26679684322636843,0.57282196186947942]
[null,0.41666666666666624,0.33850160019316466,0.53359368645273686,0.41666666666666624,0.33850160019316466,0.53359368645273686,0.41666666666666624,0.33850160019316466,0.53359368645273686,0.41666666666666624,0.33850160019316466,0.53359368645273686,0.41666666666666624,0.33850160019316466,0.53359368645273686,0.41666666666666624,0.33850160019316466,0.53359368645273686,0.41666666666666624,0.33850160019316466,0.53359368645273686,0.41666666666666624,0.33850160019316466,0.53359368645273686,0.41666666666666624,0.33850160019316466,0.53359368645273686]
[null,0.20833333333333312,0.26679684322636843,0.57282196186947942,0.20833333333333312,0.26679684322636843,0.57282196186947942,0.20833333333333312,0.26679684322636843,0.57282196186947942,0.20833333333333312,0.26679684322636843,0.57282196186947942,0.20833333333333312,0.26679684322636843,0.57282196186947942,0.20833333333333312,0.26679684322636843,0.57282196186947942,0.20833333333333312,0.26679684322636843,0.57282196186947942,0.20833333333333312,0.26679684322636843,0.57282196186947942,0.20833333333333312,0.26679684322636843,0.57282196186947942]
[null,0.29462782549439448,0.16666666666666649,0.44487826050130413,0.29462782549439448,0.16666666666666649,0.44487826050130413,0.29462782549439448,0.16666666666666649,0.44487826050130413,0.29462782549439448,0.16666666666666649,0.44487826050130413,0.29462782549439448,0.16666666666666649,0.44487826050130413,0.29462782549439448,0.16666666666666649,0.44487826050130413,0.29462782549439448,0.16666666666666649,0.44487826050130413,0.29462782549439448,0.16666666666666649,0.44487826050130413,0.29462782549439448,0.16666666666666649,0.44487826050130413]
[null,0.46584749531245567,0.26679684322636843,0.39308254716902474,0.46584749531245567,0.26679684322636843,0.39308254716902474,0.46584749531245567,0.26679684322636843,0.39308254716902474,0.46584749531245567,0.26679684322636843,0.39308254716902474,0.46584749531245567,0.26679684322636843,0.39308254716902474,0.46584749531245567,0.26679684322636843,0.39308254716902474,0.46584749531245567,0.26679684322636843,0.39308254716902474,0.46584749531245567,0.26679684322636843,0.39308254716902474,0.46584749531245567,0.26679684322636843,0.39308254716902474]
[null,0.41666666666666624,0.33850160019316466,0.53359368645273686,0.41666666666666624,0.33850160019316466,0.53359368645273686,0.41666666666666624,0.33850160019316466,0.53359368645273686,0.41666666666666624,0.33850160019316466,0.53359368645273686,0.41666666666666624,0.33850160019316466,0.53359368645273686,0.41666666666666624,0.33850160019316466,0.53359368645273686,0.41666666666666624,0.33850160019316466,0.53359368645273686,0.41666666666666624,0.33850160019316466,0.53359368645273686,0.41666666666666624,0.33850160019316466,0.53359368645273686]
[null,0.46584749531245567,0.26679684322636843,0.39308254716902474,0.46584749531245567,0.26679684322636843,0.39308254716902474,0.46584749531245567,0.26679684322636843,0.39308254716902474,0.46584749531245567,0.26679684322636843,0.39308254716902474,0.46584749531245567,0.26679684322636843,0.39308254716902474,0.46584749531245567,0.26679684322636843,0.39308254716902474,0.46584749531245567,0.26679684322636843,0.39308254716902474,0.46584749531245567,0.26679684322636843,0.39308254716902474,0.46584749531245567,0.26679684322636843,0.39308254716902474]
[null,0.58925565098878896,0.33850160019316466,0.33333333333333298,0.58925565098878896,0.33850160019316466,0.33333333333333298,0.58925565098878896,0.33850160019316466,0.33333333333333298,0.58925565098878896,0.33850160019316466,0.33333333333333298,0.58925565098878896,0.33850160019316466,0.33333333333333298,0.58925565098878896,0.33850160019316466,0.33333333333333298,0.58925565098878896,0.33850160019316466,0.33333333333333298,0.58925565098878896,0.33850160019316466,0.33333333333333298,0.58925565098878896,0.33850160019316466,0.33333333333333298]
[null,0.16666666666666649,0.29462782549439448,0.61237243569579392,0.16666666666666649,0.29462782549439448,0.61237243569579392,0.16666666666666649,0.29462782549439448,0.61237243569579392,0.16666666666666649,0.29462782549439448,0.61237243569579392,0.16666666666666649,0.29462782549439448,0.61237243569579392,0.16666666666666649,0.29462782549439448,0.61237243569579392,0.16666666666666649,0.29462782549439448,0.61237243569579392,0.16666666666666649,0.29462782549439448,0.61237243569579392,0.16666666666666649,0.29462782549439448,0.61237243569579392]
[null,0.26679684322636843,0.20833333333333312,0.49476425362657933,0.26679684322636843,0.20833333333333312,0.49476425362657933,0.26679684322636843,0.20833333333333312,0.49476425362657933,0.26679684322636843,0.20833333333333312,0.49476425362657933,{"$f":"SQRT(N28+N57+N86)","v":0.26679684322636843},0.20833333333333312,0.49476425362657933,0.26679684322636843,0.20833333333333312,0.49476425362657933,0.26679684322636843,0.20833333333333312,0.49476425362657933,0.26679684322636843,0.20833333333333312,0.49476425362657933,0.26679684322636843,0.20833333333333312,0.49476425362657933]
[null,{"$f":"SQRT(B29+B58+B87)","v":0.44876373392787483},0.29462782549439448,0.44876373392787483,0.44876373392787483,0.29462782549439448,0.44876373392787483,0.44876373392787483,0.29462782549439448,0.44876373392787483,0.44876373392787483,0.29462782549439448,0.44876373392787483,0.44876373392787483,0.29462782549439448,0.44876373392787483,0.44876373392787483,0.29462782549439448,0.44876373392787483,0.44876373392787483,0.29462782549439448,0.44876373392787483,0.44876373392787483,0.29462782549439448,0.44876373392787483,0.44876373392787483,0.29462782549439448,0.44876373392787483]
[null,0.26679684322636843,0.20833333333333312,0.49476425362657933,0.26679684322636843,0.20833333333333312,0.49476425362657933,0.26679684322636843,0.20833333333333312,0.49476425362657933,0.26679684322636843,0.20833333333333312,0.49476425362657933,0.26679684322636843,0.20833333333333312,0.49476425362657933,0.26679684322636843,0.20833333333333312,0.49476425362657933,0.26679684322636843,0.20833333333333312,0.49476425362657933,0.26679684322636843,0.20833333333333312,0.49476425362657933,0.26679684322636843,0.20833333333333312,0.49476425362657933]
[null,0.33850160019316466,0,0.33850160019316466,0.33850160019316466,0,0.33850160019316466,0.33850160019316466,0,0.33850160019316466,0.33850160019316466,0,0.33850160019316466,0.33850160019316466,0,0.33850160019316466,0.33850160019316466,0,0.33850160019316466,0.33850160019316466,0,0.33850160019316466,0.33850160019316466,0,0.33850160019316466,0.33850160019316466,0,0.33850160019316466]
[null,0.49476425362657933,0.20833333333333312,0.26679684322636843,0.49476425362657933,0.20833333333333312,0.26679684322636843,0.49476425362657933,0.20833333333333312,0.26679684322636843,0.49476425362657933,0.20833333333333312,0.26679684322636843,0.49476425362657933,0.20833333333333312,0.26679684322636843,0.49476425362657933,0.20833333333333312,0.26679684322636843,0.49476425362657933,0.20833333333333312,0.26679684322636843,0.49476425362657933,0.20833333333333312,0.26679684322636843,0.49476425362657933,0.20833333333333312,0.26679684322636843]
[null,0.44876373392787483,0.29462782549439448,0.44876373392787483,0.44876373392787483,0.29462782549439448,0.44876373392787483,0.44876373392787483,0.29462782549439448,0.44876373392787483,0.44876373392787483,0.29462782549439448,0.44876373392787483,0.44876373392787483,0.29462782549439448,0.44876373392787483,0.44876373392787483,0.29462782549439448,0.44876373392787483,0.44876373392787483,0.29462782549439448,0.44876373392787483,0.44876373392787483,0.29462782549439448,0.44876373392787483,0.44876373392787483,0.29462782549439448,0.44876373392787483]
[null,0.49476425362657933,0.20833333333333312,0.26679684322636843,0.49476425362657933,0.20833333333333312,0.26679684322636843,0.49476425362657933,0.20833333333333312,0.26679684322636843,0.49476425362657933,0.20833333333333312,0.26679684322636843,0.49476425362657933,0.20833333333333312,0.26679684322636843,0.49476425362657933,0.20833333333333312,0.26679684322636843,0.49476425362657933,0.20833333333333312,0.26679684322636843,0.49476425362657933,0.20833333333333312,0.26679684322636843,0.49476425362657933,0.20833333333333312,0.26679684322636843]
[null,0.61237243569579392,0.29462782549439448,0.16666666666666649,0.61237243569579392,0.29462782549439448,0.16666666666666649,0.61237243569579392,0.29462782549439448,0.16666666666666649,0.61237243569579392,0.29462782549439448,0.16666666666666649,0.61237243569579392,0.29462782549439448,0.16666666666666649,0.61237243569579392,0.29462782549439448,0.16666666666666649,0.61237243569579392,0.29462782549439448,0.16666666666666649,0.61237243569579392,0.29462782549439448,0.16666666666666649,0.61237243569579392,0.29462782549439448,0.16666666666666649]
[null,0.33333333333333298,0.33850160019316466,0.58925565098878896,0.33333333333333298,0.33850160019316466,0.58925565098878896,0.33333333333333298,0.33850160019316466,0.58925565098878896,0.33333333333333298,0.33850160019316466,0.58925565098878896,0.33333333333333298,0.33850160019316466,0.58925565098878896,0.33333333333333298,0.33850160019316466,0.58925565098878896,0.33333333333333298,0.33850160019316466,0.58925565098878896,0.33333333333333298,0.33850160019316466,0.58925565098878896,0.33333333333333298,0.33850160019316466,0.58925565098878896]
[null,0.39308254716902474,0.26679684322636843,0.46584749531245567,0.39308254716902474,0.26679684322636843,0.46584749531245567,0.39308254716902474,0.26679684322636843,0.46584749531245567,0.39308254716902474,0.26679684322636843,0.46584749531245567,0.39308254716902474,0.26679684322636843,0.46584749531245567,0.39308254716902474,0.26679684322636843,0.46584749531245567,0.39308254716902474,0.26679684322636843,0.46584749531245567,0.39308254716902474,0.26679684322636843,0.46584749531245567,0.39308254716902474,0.26679684322636843,0.46584749531245567]
[null,0.53359368645273686,0.33850160019316466,0.41666666666666624,0.53359368645273686,0.33850160019316466,0.41666666666666624,0.53359368645273686,0.33850160019316466,0.41666666666666624,0.53359368645273686,0.33850160019316466,0.41666666666666624,{"$f":"SQRT(N38+N67+N96)","v":0.53359368645273686},0.33850160019316466,0.41666666666666624,0.53359368645273686,0.33850160019316466,0.41666666666666624,0.53359368645273686,0.33850160019316466,0.41666666666666624,0.53359368645273686,0.33850160019316466,0.41666666666666624,0.53359368645273686,0.33850160019316466,0.41666666666666624]
[null,{"$f":"SQRT(B39+B68+B97)","v":0.39308254716902474},0.26679684322636843,0.46584749531245567,0.39308254716902474,0.26679684322636843,0.46584749531245567,0.39308254716902474,0.26679684322636843,0.46584749531245567,0.39308254716902474,0.26679684322636843,0.46584749531245567,0.39308254716902474,0.26679684322636843,0.46584749531245567,0.39308254716902474,0.26679684322636843,0.46584749531245567,0.39308254716902474,0.26679684322636843,0.46584749531245567,0.39308254716902474,0.26679684322636843,0.46584749531245567,0.39308254716902474,0.26679684322636843,0.46584749531245567]
[null,0.44487826050130413,0.16666666666666649,0.29462782549439448,0.44487826050130413,0.16666666666666649,0.29462782549439448,0.44487826050130413,0.16666666666666649,0.29462782549439448,0.44487826050130413,0.16666666666666649,0.29462782549439448,0.44487826050130413,0.16666666666666649,0.29462782549439448,0.44487826050130413,0.16666666666666649,0.29462782549439448,0.44487826050130413,0.16666666666666649,0.29462782549439448,0.44487826050130413,0.16666666666666649,0.29462782549439448,0.44487826050130413,0.16666666666666649,0.29462782549439448]
[null,0.57282196186947942,0.26679684322636843,0.20833333333333312,0.57282196186947942,0.26679684322636843,0.20833333333333312,0.57282196186947942,0.26679684322636843,0.20833333333333312,0.57282196186947942,0.26679684322636843,0.20833333333333312,0.57282196186947942,0.26679684322636843,0.20833333333333312,0.57282196186947942,0.26679684322636843,0.20833333333333312,0.57282196186947942,0.26679684322636843,0.20833333333333312,0.57282196186947942,0.26679684322636843,0.20833333333333312,0.57282196186947942,0.26679684322636843,0.20833333333333312]
[null,0.53359368645273686,0.33850160019316466,0.41666666666666624,0.53359368645273686,0.33850160019316466,0.41666666666666624,0.53359368645273686,0.33850160019316466,0.41666666666666624,0.53359368645273686,0.33850160019316466,0.41666666666666624,0.53359368645273686,0.33850160019316466,0.41666666666666624,0.53359368645273686,0.33850160019316466,0.41666666666666624,0.53359368645273686,0.33850160019316466,0.41666666666666624,0.53359368645273686,0.33850160019316466,0.41666666666666624,0.53359368645273686,0.33850160019316466,0.41666666666666624]
[null,0.57282196186947942,0.26679684322636843,0.20833333333333312,0.57282196186947942,0.26679684322636843,0.20833333333333312,0.57282196186947942,0.26679684322636843,0.20833333333333312,0.57282196186947942,0.26679684322636843,0.20833333333333312,0.57282196186947942,0.26679684322636843,0.20833333333333312,0.57282196186947942,0.26679684322636843,0.20833333333333312,0.57282196186947942,0.26679684322636843,0.20833333333333312,0.57282196186947942,0.26679684322636843,0.20833333333333312,0.57282196186947942,0.26679684322636843,0.20833333333333312]
[null,0.67700320038632933,0.33850160019316466,0,0.67700320038632933,0.33850160019316466,0,0.67700320038632933,0.33850160019316466,0,0.67700320038632933,0.33850160019316466,0,0.67700320038632933,0.33850160019316466,0,0.67700320038632933,0.33850160019316466,0,0.67700320038632933,0.33850160019316466,0,0.67700320038632933,0.33850160019316466,0,0.67700320038632933,0.33850160019316466,0]
[]
["h sphérique",{"$f":"MIN(1,B104)","v":0},{"$f":"MIN(1,C104)","v":0.33850160019316466},0.67700320038632933,0,0.33850160019316466,0.67700320038632933,0,0.33850160019316466,0.67700320038632933,0,0.33850160019316466,0.67700320038632933,0,0.33850160019316466,0.67700320038632933,0,0.33850160019316466,0.67700320038632933,0,0.33850160019316466,0.67700320038632933,0,0.33850160019316466,0.67700320038632933,0,0.33850160019316466,0.67700320038632933]
[null,{"$f":"MIN(1,B105)","v":0.20833333333333312},0.26679684322636843,0.57282196186947942,0.20833333333333312,0.26679684322636843,0.57282196186947942,0.20833333333333312,0.26679684322636843,0.57282196186947942,0.20833333333333312,0.26679684322636843,0.57282196186947942,0.20833333333333312,0.26679684322636843,0.57282196186947942,0.20833333333333312,0.26679684322636843,0.57282196186947942,0.20833333333333312,0.26679684322636843,0.57282196186947942,0.20833333333333312,0.26679684322636843,0.57282196186947942,0.20833333333333312,0.26679684322636843,0.57282196186947942]
[null,0.41666666666666624,0.33850160019316466,0.53359368645273686,0.41666666666666624,0.33850160019316466,0.53359368645273686,0.41666666666666624,0.33850160019316466,0.53359368645273686,0.41666666666666624,0.33850160019316466,0.53359368645273686,0.41666666666666624,0.33850160019316466,0.53359368645273686,0.41666666666666624,0.33850160019316466,0.53359368645273686,0.41666666666666624,0.33850160019316466,0.53359368645273686,0.41666666666666624,0.33850160019316466,0.53359368645273686,0.41666666666666624,0.33850160019316466,0.53359368645273686]
[null,0.20833333333333312,0.26679684322636843,0.57282196186947942,0.20833333333333312,0.26679684322636843,0.57282196186947942,0.20833333333333312,0.26679684322636843,0.57282196186947942,0.20833333333333312,0.26679684322636843,0.57282196186947942,0.20833333333333312,0.26679684322636843,0.57282196186947942,0.20833333333333312,0.26679684322636843,0.57282196186947942,0.20833333333333312,0.26679684322636843,0.57282196186947942,0.20833333333333312,0.26679684322636843,0.57282196186947942,0.20833333333333312,0.26679684322636843,0.57282196186947942]
[null,0.29462782549439448,0.16666666666666649,0.44487826050130413,0.29462782549439448,0.16666666666666649,0.44487826050130413,0.29462782549439448,0.16666666666666649,0.44487826050130413,0.29462782549439448,0.16666666666666649,0.44487826050130413,0.29462782549439448,0.16666666666666649,0.44487826050130413,0.29462782549439448,0.16666666666666649,0.44487826050130413,0.29462782549439448,0.16666666666666649,0.44487826050130413,0.29462782549439448,0.16666666666666649,0.44487826050130413,0.29462782549439448,0.16666666666666649,0.44487826050130413]
[null,0.46584749531245567,0.26679684322636843,0.39308254716902474,0.46584749531245567,0.26679684322636843,0.39308254716902474,0.46584749531245567,0.26679684322636843,0.39308254716902474,0.46584749531245567,0.26679684322636843,0.39308254716902474,0.46584749531245567,0.26679684322636843,0.39308254716902474,0.46584749531245567,0.26679684322636843,0.39308254716902474,0.46584749531245567,0.26679684322636843,0.39308254716902474,0.46584749531245567,0.26679684322636843,0.39308254716902474,0.46584749531245567,0.26679684322636843,0.39308254716902474]
[null,0.41666666666666624,0.33850160019316466,0.53359368645273686,0.41666666666666624,0.33850160019316466,0.53359368645273686,0.41666666666666624,0.33850160019316466,0.53359368645273686,0.41666666666666624,0.33850160019316466,0.53359368645273686,0.41666666666666624,0.33850160019316466,0.53359368645273686,0.41666666666666624,0.33850160019316466,0.53359368645273686,0.41666666666666624,0.33850160019316466,0.53359368645273686,0.41666666666666624,0.33850160019316466,0.53359368645273686,0.41666666666666624,0.33850160019316466,0.53359368645273686]
[null,0.46584749531245567,0.26679684322636843,0.39308254716902474,0.46584749531245567,0.26679684322636843,0.39308254716902474,0.46584749531245567,0.26679684322636843,0.39308254716902474,0.46584749531245567,0.26679684322636843,0.39308254716902474,0.46584749531245567,0.26679684322636843,0.39308254716902474,0.46584749531245567,0.26679684322636843,0.39308254716902474,0.46584749531245567,0.26679684322636843,0.39308254716902474,0.46584749531245567,0.26679684322636843,0.39308254716902474,0.46584749531245567,0.26679684322636843,0.39308254716902474]
[null,0.58925565098878896,0.33850160019316466,0.33333333333333298,0.58925565098878896,0.33850160019316466,0.33333333333333298,0.58925565098878896,0.33850160019316466,0.33333333333333298,0.58925565098878896,0.33850160019316466,0.33333333333333298,0.58925565098878896,0.33850160019316466,0.33333333333333298,0.58925565098878896,0.33850160019316466,0.33333333333333298,0.58925565098878896,0.33850160019316466,0.33333333333333298,0.58925565098878896,0.33850160019316466,0.33333333333333298,0.58925565098878896,0.33850160019316466,0.33333333333333298]
[null,0.16666666666666649,0.29462782549439448,0.61237243569579392,0.16666666666666649,0.29462782549439448,0.61237243569579392,0.16666666666666649,0.29462782549439448,0.61237243569579392,0.16666666666666649,0.29462782549439448,0.61237243569579392,0.16666666666666649,0.29462782549439448,0.61237243569579392,0.16666666666666649,0.29462782549439448,0.61237243569579392,0.16666666666666649,0.29462782549439448,0.61237243569579392,0.16666666666666649,0.29462782549439448,0.61237243569579392,0.16666666666666649,0.29462782549439448,0.61237243569579392]
[null,0.26679684322636843,0.20833333333333312,0.49476425362657933,0.26679684322636843,0.20833333333333312,0.49476425362657933,0.26679684322636843,0.20833333333333312,0.49476425362657933,0.26679684322636843,0.20833333333333312,0.49476425362657933,{"$f":"MIN(1,N114)","v":0.26679684322636843},0.20833333333333312,0.49476425362657933,0.26679684322636843,0.20833333333333312,0.49476425362657933,0.26679684322636843,0.20833333333333312,0.49476425362657933,0.26679684322636843,0.20833333333333312,0.49476425362657933,0.26679684322636843,0.20833333333333312,0.49476425362657933]
[null,{"$f":"MIN(1,B115)","v":0.44876373392787483},0.29462782549439448,0.44876373392787483,0.44876373392787483,0.29462782549439448,0.44876373392787483,0.44876373392787483,0.29462782549439448,0.44876373392787483,0.44876373392787483,0.29462782549439448,0.44876373392787483,0.44876373392787483,0.29462782549439448,0.44876373392787483,0.44876373392787483,0.29462782549439448,0.44876373392787483,0.44876373392787483,0.29462782549439448,0.44876373392787483,0.44876373392787483,0.29462782549439448,0.44876373392787483,0.44876373392787483,0.29462782549439448,0.44876373392787483]
[null,0.26679684322636843,0.20833333333333312,0.49476425362657933,0.26679684322636843,0.20833333333333312,0.49476425362657933,0.26679684322636843,0.20833333333333312,0.49476425362657933,0.26679684322636843,0.20833333333333312,0.49476425362657933,0.26679684322636843,0.20833333333333312,0.49476425362657933,0.26679684322636843,0.20833333333333312,0.49476425362657933,0.26679684322636843,0.20833333333333312,0.49476425362657933,0.26679684322636843,0.20833333333333312,0.49476425362657933,0.26679684322636843,0.20833333333333312,0.49476425362657933]
[null,0.33850160019316466,0,0.33850160019316466,0.33850160019316466,0,0.33850160019316466,0.33850160019316466,0,0.33850160019316466,0.33850160019316466,0,0.33850160019316466,0.33850160019316466,0,0.33850160019316466,0.33850160019316466,0,0.33850160019316466,0.33850160019316466,0,0.33850160019316466,0.33850160019316466,0,0.33850160019316466,0.33850160019316466,0,0.33850160019316466]
[null,0.49476425362657933,0.20833333333333312,0.26679684322636843,0.49476425362657933,0.20833333333333312,0.26679684322636843,0.49476425362657933,0.20833333333333312,0.26679684322636843,0.49476425362657933,0.20833333333333312,0.26679684322636843,0.49476425362657933,0.20833333333333312,0.26679684322636843,0.49476425362657933,0.20833333333333312,0.26679684322636843,0.49476425362657933,0.20833333333333312,0.26679684322636843,0.49476425362657933,0.20833333333333312,0.26679684322636843,0.49476425362657933,0.20833333333333312,0.26679684322636843]
[null,0.44876373392787483,0.29462782549439448,0.44876373392787483,0.44876373392787483,0.29462782549439448,0.44876373392787483,0.44876373392787483,0.29462782549439448,0.44876373392787483,0.44876373392787483,0.29462782549439448,0.44876373392787483,0.44876373392787483,0.29462782549439448,0.44876373392787483,0.44876373392787483,0.29462782549439448,0.44876373392787483,0.44876373392787483,0.29462782549439448,0.44876373392787483,0.44876373392787483,0.29462782549439448,0.44876373392787483,0.44876373392787483,0.29462782549439448,0.44876373392787483]
[null,0.49476425362657933,0.20833333333333312,0.26679684322636843,0.49476425362657933,0.20833333333333312,0.26679684322636843,0.49476425362657933,0.20833333333333312,0.26679684322636843,0.49476425362657933,0.20833333333333312,0.26679684322636843,0.49476425362657933,0.20833333333333312,0.26679684322636843,0.49476425362657933,0.20833333333333312,0.26679684322636843,0.49476425362657933,0.20833333333333312,0.26679684322636843,0.49476425362657933,0.20833333333333312,0.26679684322636843,0.49476425362657933,0.20833333333333312,0.26679684322636843]
[null,0.61237243569579392,0.29462782549439448,0.16666666666666649,0.61237243569579392,0.29462782549439448,0.16666666666666649,0.61237243569579392,0.29462782549439448,0.16666666666666649,0.61237243569579392,0.29462782549439448,0.16666666666666649,0.61237243569579392,0.29462782549439448,0.16666666666666649,0.61237243569579392,0.29462782549439448,0.16666666666666649,0.61237243569579392,0.29462782549439448,0.16666666666666649,0.61237243569579392,0.29462782549439448,0.16666666666666649,0.61237243569579392,0.29462782549439448,0.16666666666666649]
[null,0.33333333333333298,0.33850160019316466,0.58925565098878896,0.33333333333333298,0.33850160019316466,0.58925565098878896,0.33333333333333298,0.33850160019316466,0.58925565098878896,0.33333333333333298,0.33850160019316466,0.58925565098878896,0.33333333333333298,0.33850160019316466,0.58925565098878896,0.33333333333333298,0.33850160019316466,0.58925565098878896,0.33333333333333298,0.33850160019316466,0.58925565098878896,0.33333333333333298,0.33850160019316466,0.58925565098878896,0.33333333333333298,0.33850160019316466,0.58925565098878896]
[null,0.39308254716902474,0.26679684322636843,0.46584749531245567,0.39308254716902474,0.26679684322636843,0.46584749531245567,0.39308254716902474,0.26679684322636843,0.46584749531245567,0.39308254716902474,0.26679684322636843,0.46584749531245567,0.39308254716902474,0.26679684322636843,0.46584749531245567,0.39308254716902474,0.26679684322636843,0.46584749531245567,0.39308254716902474,0.26679684322636843,0.46584749531245567,0.39308254716902474,0.26679684322636843,0.46584749531245567,0.39308254716902474,0.26679684322636843,0.46584749531245567]
[null,0.53359368645273686,0.33850160019316466,0.41666666666666624,0.53359368645273686,0.33850160019316466,0.41666666666666624,0.53359368645273686,0.33850160019316466,0.41666666666666624,0.53359368645273686,0.33850160019316466,0.41666666666666624,{"$f":"MIN(1,N124)","v":0.53359368645273686},0.33850160019316466,0.41666666666666624,0.53359368645273686,0.33850160019316466,0.41666666666666624,0.53359368645273686,0.33850160019316466,0.41666666666666624,0.53359368645273686,0.33850160019316466,0.41666666666666624,0.53359368645273686,0.33850160019316466,0.41666666666666624]
[null,{"$f":"MIN(1,B125)","v":0.39308254716902474},0.26679684322636843,0.46584749531245567,0.39308254716902474,0.26679684322636843,0.46584749531245567,0.39308254716902474,0.26679684322636843,0.46584749531245567,0.39308254716902474,0.26679684322636843,0.46584749531245567,0.39308254716902474,0.26679684322636843,0.46584749531245567,0.39308254716902474,0.26679684322636843,0.46584749531245567,0.39308254716902474,0.26679684322636843,0.46584749531245567,0.39308254716902474,0.26679684322636843,0.46584749531245567,0.39308254716902474,0.26679684322636843,0.46584749531245567]
[null,0.44487826050130413,0.16666666666666649,0.29462782549439448,0.44487826050130413,0.16666666666666649,0.29462782549439448,0.44487826050130413,0.16666666666666649,0.29462782549439448,0.44487826050130413,0.16666666666666649,0.29462782549439448,0.44487826050130413,0.16666666666666649,0.29462782549439448,0.44487826050130413,0.16666666666666649,0.29462782549439448,0.44487826050130413,0.16666666666666649,0.29462782549439448,0.44487826050130413,0.16666666666666649,0.29462782549439448,0.44487826050130413,0.16666666666666649,0.29462782549439448]
[null,0.57282196186947942,0.26679684322636843,0.20833333333333312,0.57282196186947942,0.26679684322636843,0.20833333333333312,0.57282196186947942,0.26679684322636843,0.20833333333333312,0.57282196186947942,0.26679684322636843,0.20833333333333312,0.57282196186947942,0.26679684322636843,0.20833333333333312,0.57282196186947942,0.26679684322636843,0.20833333333333312,0.57282196186947942,0.26679684322636843,0.20833333333333312,0.57282196186947942,0.26679684322636843,0.20833333333333312,0.57282196186947942,0.26679684322636843,0.20833333333333312]
[null,0.53359368645273686,0.33850160019316466,0.41666666666666624,0.53359368645273686,0.33850160019316466,0.41666666666666624,0.53359368645273686,0.33850160019316466,0.41666666666666624,0.53359368645273686,0.33850160019316466,0.41666666666666624,0.53359368645273686,0.33850160019316466,0.41666666666666624,0.53359368645273686,0.33850160019316466,0.41666666666666624,0.53359368645273686,0.33850160019316466,0.41666666666666624,0.53359368645273686,0.33850160019316466,0.41666666666666624,0.53359368645273686,0.33850160019316466,0.41666666666666624]
[null,0.57282196186947942,0.26679684322636843,0.20833333333333312,0.57282196186947942,0.26679684322636843,0.20833333333333312,0.57282196186947942,0.26679684322636843,0.20833333333333312,0.57282196186947942,0.26679684322636843,0.20833333333333312,0.57282196186947942,0.26679684322636843,0.20833333333333312,0.57282196186947942,0.26679684322636843,0.20833333333333312,0.57282196186947942,0.26679684322636843,0.20833333333333312,0.57282196186947942,0.26679684322636843,0.20833333333333312,0.57282196186947942,0.26679684322636843,0.20833333333333312]
[null,0.67700320038632933,0.33850160019316466,0,0.67700320038632933,0.33850160019316466,0,0.67700320038632933,0.33850160019316466,0,0.67700320038632933,0.33850160019316466,0,0.67700320038632933,0.33850160019316466,0,0.67700320038632933,0.33850160019316466,0,0.67700320038632933,0.33850160019316466,0,0.67700320038632933,0.33850160019316466,0,0.67700320038632933,0.33850160019316466,0]

{"sheet":"Variance d'estimation","index":7,"n_rows":87,"n_cols":11,"rows_kept":87,"cut":false,"hidden":false,"merged":[]}
["Variance d'estimation et variance des valeurs estimées (estimation ponctuelle)"]
[]
["Variogramme exponentiel",null,null,"Variance des valeurs estimées","Variance d'estimation"]
["C0",10,null,{"$f":"MMULT(MMULT(TRANSPOSE(E16:E25),B78:K87),E16:E25)","v":96.619536434926289},{"$f":"B4+B5+D4-2*MMULT(TRANSPOSE(E16:E25),H16:H25)","v":54.500581731563813}]
["C",135]
["ax",100]
["ay",100]
["az",100]
[]
["Point à estimer"]
[null,"x","y","z"]
["x0",10,10,0]
[]
["Points connus"]
["xi","x","y","z","poids associé au point (mettre 0 pour retirer une donnée)",null,"h(xi,x0)","k0"]
[1,0,0,0,0.27600000000000002,null,{"$f":"SQRT(((B16-$B$12)/$B$6)^2+((C16-$C$12)/$B$7)^2+((D16-$D$12)/$B$8)^2)","v":0.14142135623730953},{"$f":"$B$4*(G16=0)+$B$5*EXP(-3*G16)","v":88.323897400092292}]
[2,20,0,0,0.27600000000000002,null,{"$f":"SQRT(((B17-$B$12)/$B$6)^2+((C17-$C$12)/$B$7)^2+((D17-$D$12)/$B$8)^2)","v":0.14142135623730953},{"$f":"$B$4*(G17=0)+$B$5*EXP(-3*G17)","v":88.323897400092292}]
[3,10,20,0,0.44800000000000001,null,0.1,100.01045979203191]
[4,23,-3,-5,0,null,0.19052558883257653,76.225649368600926]
[5,31,-7,8,0,null,0.28178005607210743,57.970520275575595]
[6,-11,8,21,0,null,0.29765752132274431,55.273976743564035]
[7,-22,15,43,0,null,0.53833075334779079,26.850448330011897]
[8,43,6,-51,0,null,0.60876925020897699,21.735938176110377]
[9,-33,2,-20,0,null,0.48093658625644192,31.895502732160541]
[10,-34,25,32,0,null,0.56435804238089848,24.833676397731494]
[null,null,null,null,{"$f":"SUM(E16:E25)","v":1},"Somme des poids (s'assurer que la somme donne 1)"]
[]
["hx^2",{"$f":"TRANSPOSE(B16:B25/$B$6)","v":0},0.2,0.1,0.23,0.31,-0.11,-0.22,0.43,-0.33,-0.34]
[{"$f":"(B16:B25/$B$6)","v":0},{"$f":"((B$28-$A29))^2","v":0},{"$f":"((C$28-$A29))^2","v":4.0000000000000008E-2},{"$f":"((D$28-$A29))^2","v":1.0000000000000002E-2},5.2900000000000003E-2,9.6100000000000005E-2,1.21E-2,4.8399999999999999E-2,0.18489999999999998,0.10890000000000001,0.11560000000000002]
[0.2,4.0000000000000008E-2,0,1.0000000000000002E-2,8.9999999999999998E-4,1.2099999999999998E-2,9.6100000000000005E-2,0.17640000000000003,5.2899999999999989E-2,0.28090000000000004,0.29160000000000003]
[0.1,1.0000000000000002E-2,1.0000000000000002E-2,0,1.6900000000000002E-2,4.4099999999999993E-2,4.4100000000000007E-2,0.1024,0.10889999999999997,0.18490000000000004,0.19360000000000005]
[0.23,5.2900000000000003E-2,8.9999999999999998E-4,1.6900000000000002E-2,0,6.3999999999999977E-3,0.11560000000000002,0.20250000000000001,3.9999999999999994E-2,0.31360000000000005,0.32490000000000008]
[0.31,9.6100000000000005E-2,1.2099999999999998E-2,4.4099999999999993E-2,6.3999999999999977E-3,0,0.17639999999999997,0.28090000000000004,1.44E-2,0.40960000000000002,0.42250000000000004]
[-0.11,1.21E-2,9.6100000000000005E-2,4.4100000000000007E-2,0.11560000000000002,0.17639999999999997,0,1.21E-2,0.29160000000000003,4.8400000000000012E-2,5.2900000000000016E-2]
[-0.22,4.8399999999999999E-2,0.17640000000000003,0.1024,0.20250000000000001,0.28090000000000004,1.21E-2,0,0.42250000000000004,1.2100000000000003E-2,1.4400000000000005E-2]
[0.43,0.18489999999999998,5.2899999999999989E-2,0.10889999999999997,3.9999999999999994E-2,1.44E-2,0.29160000000000003,0.42250000000000004,0,0.5776,0.59289999999999998]
[-0.33,0.10890000000000001,0.28090000000000004,0.18490000000000004,0.31360000000000005,0.40960000000000002,4.8400000000000012E-2,1.2100000000000003E-2,0.5776,0,1.0000000000000018E-4]
[-0.34,0.11560000000000002,0.29160000000000003,0.19360000000000005,0.32490000000000008,0.42250000000000004,5.2900000000000016E-2,1.4400000000000005E-2,0.59289999999999998,1.0000000000000018E-4,0]
[]
["hy^2",{"$f":"TRANSPOSE(C16:C25/$B$7)","v":0},0,0.2,-0.03,-7.0000000000000007E-2,0.08,0.15,0.06,0.02,0.25]
[{"$f":"(C16:C25/$B$7)","v":0},{"$f":"((B$40-$A41))^2","v":0},{"$f":"((C$40-$A41))^2","v":0},4.0000000000000008E-2,8.9999999999999998E-4,4.9000000000000007E-3,6.4000000000000003E-3,2.2499999999999999E-2,3.5999999999999999E-3,4.0000000000000002E-4,6.25E-2]
[0,{"$f":"((B$40-$A42))^2","v":0},0,4.0000000000000008E-2,8.9999999999999998E-4,4.9000000000000007E-3,6.4000000000000003E-3,2.2499999999999999E-2,3.5999999999999999E-3,4.0000000000000002E-4,6.25E-2]
[0.2,4.0000000000000008E-2,4.0000000000000008E-2,0,5.2900000000000003E-2,7.2900000000000006E-2,1.4400000000000003E-2,2.5000000000000018E-3,1.9600000000000003E-2,3.2400000000000005E-2,2.4999999999999988E-3]
[-0.03,8.9999999999999998E-4,8.9999999999999998E-4,5.2900000000000003E-2,0,1.6000000000000007E-3,1.21E-2,3.2399999999999998E-2,8.0999999999999996E-3,2.5000000000000005E-3,7.8400000000000011E-2]
[-7.0000000000000007E-2,4.9000000000000007E-3,4.9000000000000007E-3,7.2900000000000006E-2,1.6000000000000007E-3,0,2.2500000000000006E-2,4.8399999999999999E-2,1.6900000000000002E-2,8.1000000000000013E-3,0.1024]
[0.08,6.4000000000000003E-3,6.4000000000000003E-3,1.4400000000000003E-2,1.21E-2,2.2500000000000006E-2,0,4.899999999999999E-3,4.0000000000000018E-4,3.5999999999999999E-3,2.8899999999999995E-2]
[0.15,2.2499999999999999E-2,2.2499999999999999E-2,2.5000000000000018E-3,3.2399999999999998E-2,4.8399999999999999E-2,4.899999999999999E-3,0,8.0999999999999996E-3,1.6900000000000002E-2,1.0000000000000002E-2]
[0.06,3.5999999999999999E-3,3.5999999999999999E-3,1.9600000000000003E-2,8.0999999999999996E-3,1.6900000000000002E-2,4.0000000000000018E-4,8.0999999999999996E-3,0,1.5999999999999994E-3,3.61E-2]
[0.02,4.0000000000000002E-4,4.0000000000000002E-4,3.2400000000000005E-2,2.5000000000000005E-3,8.1000000000000013E-3,3.5999999999999999E-3,1.6900000000000002E-2,1.5999999999999994E-3,0,5.2900000000000003E-2]
[0.25,6.25E-2,6.25E-2,2.4999999999999988E-3,7.8400000000000011E-2,0.1024,2.8899999999999995E-2,1.0000000000000002E-2,3.61E-2,5.2900000000000003E-2,0]
[]
["hz^2",{"$f":"TRANSPOSE(D16:D25/$B$8)","v":0},0,0,-0.05,0.08,0.21,0.43,-0.51,-0.2,0.32]
[{"$f":"(D16:D25/$B$8)","v":0},{"$f":"((B$52-$A53))^2","v":0},{"$f":"((C$52-$A53))^2","v":0},0,2.5000000000000005E-3,6.4000000000000003E-3,4.4099999999999993E-2,0.18489999999999998,0.2601,4.0000000000000008E-2,0.1024]
[0,{"$f":"((B$52-$A54))^2","v":0},0,0,2.5000000000000005E-3,6.4000000000000003E-3,4.4099999999999993E-2,0.18489999999999998,0.2601,4.0000000000000008E-2,0.1024]
[0,0,0,0,2.5000000000000005E-3,6.4000000000000003E-3,4.4099999999999993E-2,0.18489999999999998,0.2601,4.0000000000000008E-2,0.1024]
[-0.05,2.5000000000000005E-3,2.5000000000000005E-3,2.5000000000000005E-3,0,1.6900000000000002E-2,6.7600000000000007E-2,0.23039999999999999,0.21160000000000001,2.2500000000000006E-2,0.13689999999999999]
[0.08,6.4000000000000003E-3,6.4000000000000003E-3,6.4000000000000003E-3,1.6900000000000002E-2,0,1.6900000000000002E-2,0.12249999999999998,0.34809999999999997,7.8400000000000011E-2,5.7599999999999998E-2]
[0.21,4.4099999999999993E-2,4.4099999999999993E-2,4.4099999999999993E-2,6.7600000000000007E-2,1.6900000000000002E-2,0,4.8399999999999999E-2,0.51839999999999997,0.16810000000000003,1.2100000000000003E-2]
[0.43,0.18489999999999998,0.18489999999999998,0.18489999999999998,0.23039999999999999,0.12249999999999998,4.8399999999999999E-2,0,0.88359999999999994,0.39690000000000003,1.2099999999999998E-2]
[-0.51,0.2601,0.2601,0.2601,0.21160000000000001,0.34809999999999997,0.51839999999999997,0.88359999999999994,0,9.6100000000000005E-2,0.68890000000000007]
[-0.2,4.0000000000000008E-2,4.0000000000000008E-2,4.0000000000000008E-2,2.2500000000000006E-2,7.8400000000000011E-2,0.16810000000000003,0.39690000000000003,9.6100000000000005E-2,0,0.27040000000000003]
[0.32,0.1024,0.1024,0.1024,0.13689999999999999,5.7599999999999998E-2,1.2100000000000003E-2,1.2099999999999998E-2,0.68890000000000007,0.27040000000000003,0]
[]
["h",1,2,3,4,5,6,7,8,9,10]
[1,{"$f":"SQRT(B29+B41+B53)","v":0},{"$f":"SQRT(C29+C41+C53)","v":0.2},0.22360679774997899,0.23727621035409344,0.32771939216347878,0.25019992006393604,0.50576674465607163,0.669776081985614,0.38639358172723315,0.52962250707461445]
[2,{"$f":"SQRT(B30+B42+B54)","v":0.2},0,0.22360679774997899,6.5574385243020006E-2,0.15297058540778355,0.38288379438153297,0.61951594006934163,0.56267219586540795,0.56683330883073557,0.67564783726435473]
[3,{"$f":"SQRT(B31+B43+B55)","v":0.22360679774997899},0.22360679774997899,0,0.26888659319497504,0.35128336140500593,0.32031234756093935,0.53833075334779079,0.62337789502034791,0.50724747411889604,0.5463515351859094]
[4,{"$f":"SQRT(B32+B44+B56)","v":0.23727621035409344},6.5574385243020006E-2,0.26888659319497504,0,0.15779733838059501,0.44192759587968711,0.68212902005412435,0.50960769224963631,0.58189346103904627,0.73498299300051839]
[5,{"$f":"SQRT(B33+B45+B57)","v":0.32771939216347878},0.15297058540778355,0.35128336140500593,0.15779733838059501,0,0.46454278597347731,0.67216069507224241,0.61595454377737968,0.70434366611761334,0.76321687612368738]
[6,{"$f":"SQRT(B34+B46+B58)","v":0.25019992006393604},0.38288379438153297,0.32031234756093935,0.44192759587968711,0.46454278597347731,0,0.25573423705088844,0.90022219479415189,0.46914816422959604,0.30643106892089128]
[7,{"$f":"SQRT(B35+B47+B59)","v":0.50576674465607163},0.61951594006934163,0.53833075334779079,0.68212902005412435,0.67216069507224241,0.25573423705088844,0,1.1463856244737196,0.6526101439603893,0.19104973174542803]
[8,{"$f":"SQRT(B36+B48+B60)","v":0.669776081985614},0.56267219586540795,0.62337789502034791,0.50960769224963631,0.61595454377737968,0.90022219479415189,1.1463856244737196,0,0.82176639016207031,1.1479982578383994]
[9,{"$f":"SQRT(B37+B49+B61)","v":0.38639358172723315},0.56683330883073557,0.50724747411889604,0.58189346103904627,0.70434366611761334,0.46914816422959604,0.6526101439603893,0.82176639016207031,0,0.56868268832451729]
[10,{"$f":"SQRT(B38+B50+B62)","v":0.52962250707461445},0.67564783726435473,0.5463515351859094,0.73498299300051839,0.76321687612368738,0.30643106892089128,0.19104973174542803,1.1479982578383994,0.56868268832451729,0]
[]
[]
["K",1,2,3,4,5,6,7,8,9,10]
[1,{"$f":"$B$4*(B65=0)+$B$5*EXP(-3*B65)","v":145},{"$f":"$B$4*(C65=0)+$B$5*EXP(-3*C65)","v":74.089570872693557},69.024007936500524,66.250707720055516,50.507235434449584,63.731249688750758,29.605926014074178,18.100626166028309,42.355320009041442,27.561152337155235]
[2,{"$f":"$B$4*(B66=0)+$B$5*EXP(-3*B66)","v":74.089570872693557},145,69.024007936500524,110.89143090543132,85.31608634293292,42.803650683506326,21.046345997227483,24.959591840968077,24.649949503479679,17.784570697422815]
[3,{"$f":"$B$4*(B67=0)+$B$5*EXP(-3*B67)","v":69.024007936500524},69.024007936500524,145,60.256774076370739,47.060061692133061,51.642126051057261,26.850448330011897,20.803912986756277,29.47470258867909,26.212074748957434]
[4,{"$f":"$B$4*(B68=0)+$B$5*EXP(-3*B68)","v":66.250707720055516},110.89143090543132,60.256774076370739,145,84.089588754810649,35.855321386471843,17.442115596736819,29.266739532462005,23.561037523677342,14.884580322882]
[5,{"$f":"$B$4*(B69=0)+$B$5*EXP(-3*B69)","v":50.507235434449584},85.31608634293292,47.060061692133061,84.089588754810649,145,33.503383057324264,17.971599265059616,21.272414662659575,16.317591844259415,13.675749434593712]
[6,{"$f":"$B$4*(B70=0)+$B$5*EXP(-3*B70)","v":63.731249688750758},42.803650683506326,51.642126051057261,35.855321386471843,33.503383057324264,145,62.681858476886724,9.06669848548316,33.043678782469065,53.838109513698157]
[7,{"$f":"$B$4*(B71=0)+$B$5*EXP(-3*B71)","v":29.605926014074178},21.046345997227483,26.850448330011897,17.442115596736819,17.971599265059616,62.681858476886724,145,4.3323837277000337,19.057187872664919,76.105884152729359]
[8,{"$f":"$B$4*(B72=0)+$B$5*EXP(-3*B72)","v":18.100626166028309},24.959591840968077,20.803912986756277,29.266739532462005,21.272414662659575,9.06669848548316,4.3323837277000337,145,11.472760895249877,4.3114747067154449]
[9,{"$f":"$B$4*(B73=0)+$B$5*EXP(-3*B73)","v":42.355320009041442},24.649949503479679,29.47470258867909,23.561037523677342,16.317591844259415,33.043678782469065,19.057187872664919,11.472760895249877,145,24.513566854829026]
[10,{"$f":"$B$4*(B74=0)+$B$5*EXP(-3*B74)","v":27.561152337155235},17.784570697422815,26.212074748957434,14.884580322882,13.675749434593712,53.838109513698157,76.105884152729359,4.3114747067154449,24.513566854829026,145]

{"sheet":"KS-sphérique","index":8,"n_rows":100,"n_cols":11,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
["Krigeage simple modèle sphérique"]
[]
["Variogramme sphérique",null,null,"Variance des valeurs estimées","Variance d'estimation","Somme"]
["C0",0,null,{"$f":"MMULT(MMULT(TRANSPOSE(E17:OFFSET(E16,$B$14,0)),B79:OFFSET(A78,$B$14,$B$14)),E17:OFFSET(E16,$B$14,0))","v":0.95379969356381178},{"$f":"B4+B5+D4-2*MMULT(TRANSPOSE(E17:OFFSET(E16,$B$14,0)),H17:OFFSET(H16,$B14,0))","v":1.0462003064361887},{"$f":"D4+E4","v":2.0000000000000004}]
["C",2]
["ax",30]
["ay",30]
["az",30]
[]
["Point à estimer"]
[null,"x","y","z"]
["x0",0,0,0]
[]
["Nombre de points à utiliser",10]
["Points connus"]
["xi","x","y","z","Poids calculés par KS",null,"h(xi,x0)","k0"]
[1,-5,5,3,{"$f":"MMULT(B91:OFFSET(A90,$B$14,$B$14),H17:OFFSET(H16,$B$14,0))","v":0.57492763052254436},null,{"$f":"MIN(SQRT(((B17-$B$12)/$B$6)^2+((C17-$C$12)/$B$7)^2+((D17-$D$12)/$B$8)^2),1)","v":0.2560381915956203},{"$f":"$B$4*(G17=0)+$B$5*(1-(1.5*G17-0.5*G17^3))","v":1.2486701511066296}]
[2,12,2,5,0.12935915912526461,null,{"$f":"MIN(SQRT(((B18-$B$12)/$B$6)^2+((C18-$C$12)/$B$7)^2+((D18-$D$12)/$B$8)^2),1)","v":0.43843154793219685},{"$f":"$B$4*(G18=0)+$B$5*(1-(1.5*G18-0.5*G18^3))","v":0.76898164263926527}]
[3,13,-4,3,0.2077017353074137,null,0.46427960923947065,0.70723922138431861]
[4,23,-3,-5,-4.7630836954112118E-2,null,0.79092070118031155,0.12200273508630466]
[5,31,-7,8,-3.8688638981383673E-2,null,1,0]
[6,-11,8,21,-5.9592551332683541E-2,null,0.83399973354645351,7.8093947360728055E-2]
[7,-22,15,43,1.9081269081020432E-3,null,1,0]
[8,43,6,-51,0,null,1,0]
[9,-33,2,-20,0,null,1,0]
[10,-34,25,32,-3.3179809750109044E-4,null,1,0]
[null,null,null,null,{"$f":"1-SUM(E17:E26)","v":0.23234717350235568},"Poids de la moyenne connue"]
[]
["hx^2",{"$f":"TRANSPOSE(B17:INDIRECT(_xlfn.CONCAT(\"B\",$B$14+16))/$B$6)","v":-0.16666666666666666},0.4,0.43333333333333335,0.76666666666666672,1.0333333333333334,-0.36666666666666664,-0.73333333333333328,1.4333333333333333,-1.1000000000000001,-1.1333333333333333]
[{"$f":"(B17:INDIRECT(_xlfn.CONCAT(\"B\",$B$14+16))/$B$6)","v":-0.16666666666666666},{"$f":"MIN(((B$29-$A30))^2,1)","v":0},{"$f":"MIN(((C$29-$A30))^2,1)","v":0.32111111111111107},0.36,0.87111111111111117,1,3.9999999999999994E-2,0.32111111111111107,1,0.87111111111111139,0.93444444444444441]
[0.4,{"$f":"MIN(((B$29-$A31))^2,1)","v":0.32111111111111107},0,1.1111111111111107E-3,0.13444444444444448,0.4011111111111112,0.58777777777777773,1,1,1,1]
[0.43333333333333335,0.36,1.1111111111111107E-3,0,0.11111111111111113,0.3600000000000001,0.64000000000000012,1,1,1,1]
[0.76666666666666672,0.87111111111111117,0.13444444444444448,0.11111111111111113,0,7.1111111111111139E-2,1,1,0.44444444444444442,1,1]
[1.0333333333333334,1,0.4011111111111112,0.3600000000000001,7.1111111111111139E-2,0,1,1,0.15999999999999992,1,1]
[-0.36666666666666664,3.9999999999999994E-2,0.58777777777777773,0.64000000000000012,1,1,0,0.13444444444444442,1,0.53777777777777791,0.58777777777777773]
[-0.73333333333333328,0.32111111111111107,1,1,1,1,0.13444444444444442,0,1,0.13444444444444456,0.16000000000000003]
[1.4333333333333333,1,1,1,0.44444444444444442,0.15999999999999992,1,1,0,1,1]
[-1.1000000000000001,0.87111111111111139,1,1,1,1,0.53777777777777791,0.13444444444444456,1,0,1.1111111111111033E-3]
[-1.1333333333333333,0.93444444444444441,1,1,1,1,0.58777777777777773,0.16000000000000003,1,1.1111111111111033E-3,0]
[]
["hy^2",{"$f":"TRANSPOSE(C17:INDIRECT(_xlfn.CONCAT(\"C\",$B$14+16))/$B$7)","v":0.16666666666666666},6.6666666666666666E-2,-0.13333333333333333,-0.1,-0.23333333333333334,0.26666666666666666,0.5,0.2,6.6666666666666666E-2,0.83333333333333337]
[{"$f":"(C17:INDIRECT(_xlfn.CONCAT(\"C\",$B$14+16))/$B$7)","v":0.16666666666666666},{"$f":"MIN(((B$41-$A42))^2,1)","v":0},{"$f":"MIN(((C$41-$A42))^2,1)","v":9.9999999999999985E-3},0.09,7.1111111111111111E-2,0.16000000000000003,1.0000000000000002E-2,0.11111111111111113,1.1111111111111124E-3,9.9999999999999985E-3,0.44444444444444453]
[6.6666666666666666E-2,{"$f":"MIN(((B$41-$A43))^2,1)","v":9.9999999999999985E-3},0,4.0000000000000008E-2,2.7777777777777783E-2,0.09,4.0000000000000008E-2,0.18777777777777779,1.7777777777777785E-2,0,0.58777777777777784]
[-0.13333333333333333,0.09,4.0000000000000008E-2,0,1.1111111111111107E-3,1.0000000000000002E-2,0.16000000000000003,0.40111111111111108,0.11111111111111113,4.0000000000000008E-2,0.93444444444444441]
[-0.1,7.1111111111111111E-2,2.7777777777777783E-2,1.1111111111111107E-3,0,1.7777777777777778E-2,0.13444444444444448,0.36,9.0000000000000024E-2,2.7777777777777783E-2,0.87111111111111117]
[-0.23333333333333334,0.16000000000000003,0.09,1.0000000000000002E-2,1.7777777777777778E-2,0,0.25,0.53777777777777791,0.18777777777777779,0.09,1]
[0.26666666666666666,1.0000000000000002E-2,4.0000000000000008E-2,0.16000000000000003,0.13444444444444448,0.25,0,5.4444444444444448E-2,4.4444444444444427E-3,4.0000000000000008E-2,0.32111111111111107]
[0.5,0.11111111111111113,0.18777777777777779,0.40111111111111108,0.36,0.53777777777777791,5.4444444444444448E-2,0,0.09,0.18777777777777779,0.11111111111111113]
[0.2,1.1111111111111124E-3,1.7777777777777785E-2,0.11111111111111113,9.0000000000000024E-2,0.18777777777777779,4.4444444444444427E-3,0.09,0,1.7777777777777785E-2,0.40111111111111108]
[6.6666666666666666E-2,9.9999999999999985E-3,0,4.0000000000000008E-2,2.7777777777777783E-2,0.09,4.0000000000000008E-2,0.18777777777777779,1.7777777777777785E-2,0,0.58777777777777784]
[0.83333333333333337,0.44444444444444453,0.58777777777777784,0.93444444444444441,0.87111111111111117,1,0.32111111111111107,0.11111111111111113,0.40111111111111108,0.58777777777777784,0]
[]
["hz^2",{"$f":"TRANSPOSE(D17:INDIRECT(_xlfn.CONCAT(\"D\",$B$14+16))/$B$8)","v":0.1},0.16666666666666666,0.1,-0.16666666666666666,0.26666666666666666,0.7,1.4333333333333333,-1.7,-0.66666666666666663,1.0666666666666667]
[{"$f":"(D17:INDIRECT(_xlfn.CONCAT(\"D\",$B$14+16))/$B$8)","v":0.1},{"$f":"MIN((B$53-$A54)^2,1)","v":0},{"$f":"MIN((C$53-$A54)^2,1)","v":4.4444444444444427E-3},0,7.1111111111111111E-2,2.7777777777777776E-2,0.36,1,1,0.58777777777777773,0.93444444444444441]
[0.16666666666666666,{"$f":"MIN((B$53-$A55)^2,1)","v":4.4444444444444427E-3},0,4.4444444444444427E-3,0.1111111111111111,1.0000000000000002E-2,0.28444444444444444,1,1,0.69444444444444431,0.81]
[0.1,0,4.4444444444444427E-3,0,7.1111111111111111E-2,2.7777777777777776E-2,0.36,1,1,0.58777777777777773,0.93444444444444441]
[-0.16666666666666666,7.1111111111111111E-2,0.1111111111111111,7.1111111111111111E-2,0,0.18777777777777779,0.75111111111111095,1,1,0.25,1]
[0.26666666666666666,2.7777777777777776E-2,1.0000000000000002E-2,2.7777777777777776E-2,0.18777777777777779,0,0.18777777777777774,1,1,0.87111111111111117,0.64000000000000012]
[0.7,0.36,0.28444444444444444,0.36,0.75111111111111095,0.18777777777777774,0,0.53777777777777791,1,1,0.13444444444444448]
[1.4333333333333333,1,1,1,1,1,0.53777777777777791,0,1,1,0.13444444444444448]
[-1.7,1,1,1,1,1,1,1,0,1,1]
[-0.66666666666666663,0.58777777777777773,0.69444444444444431,0.58777777777777773,0.25,0.87111111111111117,1,1,1,0,1]
[1.0666666666666667,0.93444444444444441,0.81,0.93444444444444441,1,0.64000000000000012,0.13444444444444448,0.13444444444444448,1,1,0]
[]
["h",1,2,3,4,5,6,7,8,9,10]
[1,{"$f":"MIN(SQRT(B30+B42+B54),1)","v":0},{"$f":"MIN(SQRT(C30+C42+C54),1)","v":0.5792715732327588},0.67082039324993692,1,1,0.6403124237432849,1,1,1,1]
[2,{"$f":"MIN(SQRT(B31+B43+B55),1)","v":0.5792715732327588},0,0.21343747458109497,0.52281290471193742,0.70789201938651014,0.95510325212629354,1,1,1,1]
[3,{"$f":"MIN(SQRT(B32+B44+B56),1)","v":0.67082039324993692},0.21343747458109497,0,0.42817441928883765,0.63069626428081682,1,1,1,1,1]
[4,{"$f":"MIN(SQRT(B33+B45+B57),1)","v":1},0.52281290471193742,0.42817441928883765,0,0.52599112793531677,1,1,1,1,1]
[5,{"$f":"MIN(SQRT(B34+B46+B58),1)","v":1},0.70789201938651014,0.63069626428081682,0.52599112793531677,0,1,1,1,1,1]
[6,{"$f":"MIN(SQRT(B35+B47+B59),1)","v":0.6403124237432849},0.95510325212629354,1,1,1,0,0.85244745683629486,1,1,1]
[7,{"$f":"MIN(SQRT(B36+B48+B60),1)","v":1},1,1,1,1,0.85244745683629486,0,1,1,0.63683243915142673]
[8,{"$f":"MIN(SQRT(B37+B49+B61),1)","v":1},1,1,1,1,1,1,0,1,1]
[9,{"$f":"MIN(SQRT(B38+B50+B62),1)","v":1},1,1,1,1,1,1,1,0,1]
[10,{"$f":"MIN(SQRT(B39+B51+B63),1)","v":1},1,1,1,1,1,0.63683243915142673,1,1,0]
[]
[]
["K",1,2,3,4,5,6,7,8,9,10]
[1,{"$f":"$B$4*(B66=0)+$B$5*(1-(1.5*B66-0.5*B66^3))","v":2},{"$f":"$B$4*(C66=0)+$B$5*(1-(1.5*C66-0.5*C66^3))","v":0.45656307487538283},0.28940799721266108,0,0,0.34159082250489226,0,0,0,0]
[2,{"$f":"$B$4*(B67=0)+$B$5*(1-(1.5*B67-0.5*B67^3))","v":0.45656307487538283},2,1.3694108389876316,0.57446347981878398,0.2310564982219323,5.9566547274383375E-3,0,0,0,0]
[3,{"$f":"$B$4*(B68=0)+$B$5*(1-(1.5*B68-0.5*B68^3))","v":0.28940799721266108},1.3694108389876316,2,0.79397538566977399,0.35878816561591886,0,0,0,0,0]
[4,{"$f":"$B$4*(B69=0)+$B$5*(1-(1.5*B69-0.5*B69^3))","v":0},0.57446347981878398,0.79397538566977399,2,0.56755082825615411,0,0,0,0,0]
[5,{"$f":"$B$4*(B70=0)+$B$5*(1-(1.5*B70-0.5*B70^3))","v":0},0.2310564982219323,0.35878816561591886,0.56755082825615411,2,0,0,0,0,0]
[6,{"$f":"$B$4*(B71=0)+$B$5*(1-(1.5*B71-0.5*B71^3))","v":0.34159082250489226},5.9566547274383375E-3,0,0,0,2,6.2102781458822864E-2,0,0,0]
[7,{"$f":"$B$4*(B72=0)+$B$5*(1-(1.5*B72-0.5*B72^3))","v":0},0,0,0,0,6.2102781458822864E-2,2,0,0,0.34777361620157632]
[8,{"$f":"$B$4*(B73=0)+$B$5*(1-(1.5*B73-0.5*B73^3))","v":0},0,0,0,0,0,0,2,0,0]
[9,{"$f":"$B$4*(B74=0)+$B$5*(1-(1.5*B74-0.5*B74^3))","v":0},0,0,0,0,0,0,0,2,0]
[10,{"$f":"$B$4*(B75=0)+$B$5*(1-(1.5*B75-0.5*B75^3))","v":0},0,0,0,0,0,0.34777361620157632,0,0,2]
[]
["Kinv",1,2,3,4,5,6,7,8,9,10]
[1,{"$f":"MINVERSE(B79:OFFSET(A78,$B$14,$B$14))","v":0.54695511008978304},-0.13356033144345114,-3.888029956648424E-3,3.8423902566724621E-2,5.2237219470558796E-3,-9.3112213549170111E-2,2.9814115384026538E-3,0,0,-5.1842813604769777E-4]
[2,-0.13356033144345114,0.97467599341910094,-0.63815708784863567,-2.9528466606247569E-2,1.0258447331559069E-2,1.9928401400477934E-2,-6.3809852233755713E-4,0,0,1.1095691530310729E-4]
[3,-3.8880299566484491E-3,-0.63815708784863556,1.0305799277346854,-0.21130136522005311,-5.1192637458202496E-2,2.5672508860009034E-3,-8.2202228061688563E-5,0,0,1.4293883056420061E-5]
[4,3.8423902566724642E-2,-2.9528466606247611E-2,-0.21130136522005311,0.63149388533998085,-0.13788485217602897,-6.481124669786684E-3,2.0752272055184461E-4,0,0,-3.6085463485152091E-5]
[5,5.2237219470558796E-3,1.0258447331559074E-2,-5.119263745820251E-2,-0.13788485217602897,0.5471268468127638,-9.2365910222538209E-4,2.9575152388265124E-5,0,0,-5.1427288478898226E-6]
[6,-9.3112213549170111E-2,1.9928401400477941E-2,2.5672508860008995E-3,-6.481124669786684E-3,-9.2365910222538177E-4,0.51635717448995877,-1.6533526368679875E-2,0,0,2.8749621268999576E-3]
[7,2.9814115384026534E-3,-6.3809852233755735E-4,-8.2202228061688427E-5,2.0752272055184459E-4,2.957515238826511E-5,-1.6533526368679875E-2,0.51611908673628681,0,0,-8.974630059246673E-2]
[8,0,0,0,0,0,0,0,0.5,0,0]
[9,0,0,0,0,0,0,0,0,0.5,0]
[10,-5.1842813604769788E-4,1.1095691530310733E-4,1.429388305642004E-5,-3.6085463485152091E-5,-5.1427288478898217E-6,2.874962126899958E-3,-8.9746300592466757E-2,0,0,0.51560569774887788]

{"sheet":"KS-Exponentiel","index":9,"n_rows":100,"n_cols":11,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
["Krigeage simple modèle exponentiel"]
[]
["Variogramme exponentiel",null,null,"Variance des valeurs estimées","Variance d'estimation","Somme"]
["C0",0.1,null,{"$f":"MMULT(MMULT(TRANSPOSE(E17:OFFSET(E16,$B$14,0)),B79:OFFSET(A78,$B$14,$B$14)),E17:OFFSET(E16,$B$14,0))","v":6.7667461509786655},{"$f":"B4+B5+D4-2*MMULT(TRANSPOSE(E17:OFFSET(E16,$B$14,0)),H17:OFFSET(H16,$B14,0))","v":1.3332538490213217},{"$f":"D4+E4","v":8.0999999999999872}]
["C",8]
["ax",200]
["ay",200]
["az",200]
[]
["Point à estimer"]
[null,"x","y","z"]
["x0",0,0,0]
[]
["Nombre de points à utiliser",10]
["Points connus"]
["xi","x","y","z","Poids calculés par KS",null,"h(xi,x0)","k0"]
[1,-5,5,3,{"$f":"MMULT(B91:OFFSET(A90,$B$14,$B$14),H17:OFFSET(H16,$B$14,0))","v":0.57082055474575832},null,{"$f":"SQRT(((B17-$B$12)/$B$6)^2+((C17-$C$12)/$B$7)^2+((D17-$D$12)/$B$8)^2)","v":3.8405728739343045E-2},{"$f":"$B$4*(G17=0)+$B$5*EXP(-3*G17)","v":7.1293805798915226}]
[2,12,2,5,0.14602393722753748,null,{"$f":"SQRT(((B18-$B$12)/$B$6)^2+((C18-$C$12)/$B$7)^2+((D18-$D$12)/$B$8)^2)","v":6.576473218982952E-2},{"$f":"$B$4*(G18=0)+$B$5*EXP(-3*G18)","v":6.5675926190371747}]
[3,13,-4,3,0.21687328422852467,null,6.96419413859206E-2,6.4916433904050352]
[4,23,-3,-5,4.5582648780545729E-2,null,0.11863810517704672,5.6042611394489308]
[5,31,-7,8,-3.5452106317378114E-2,null,0.16385969608173939,4.8932781315420799]
[6,-11,8,21,4.2771776402812656E-3,null,0.12509996003196802,5.4966656425307638]
[7,-22,15,43,-4.1795552150721837E-3,null,0.25288337232803582,3.7463851860463788]
[8,43,6,-51,1.0524872895542286E-2,null,0.334888040992807,2.9293408114831618]
[9,-33,2,-20,5.5797753542871115E-2,null,0.19319679086361657,4.4810221061045237]
[10,-34,25,32,-1.1186149328234141E-2,null,0.26481125353730722,3.6146960833037363]
[null,null,null,null,{"$f":"1-SUM(E17:E26)","v":9.1758179962364572E-4},"Poids de la moyenne connue"]
[]
["hx^2",{"$f":"TRANSPOSE(B17:INDIRECT(_xlfn.CONCAT(\"B\",$B$14+16))/$B$6)","v":-2.5000000000000001E-2},0.06,6.5000000000000002E-2,0.115,0.155,-5.5E-2,-0.11,0.215,-0.16500000000000001,-0.17]
[{"$f":"(B17:INDIRECT(_xlfn.CONCAT(\"B\",$B$14+16))/$B$6)","v":-2.5000000000000001E-2},{"$f":"((B$29-$A30))^2","v":0},{"$f":"((C$29-$A30))^2","v":7.2249999999999988E-3},{"$f":"((D$29-$A30))^2","v":8.0999999999999996E-3},1.9600000000000003E-2,3.2399999999999998E-2,8.9999999999999998E-4,7.2249999999999988E-3,5.7599999999999998E-2,1.9600000000000003E-2,2.1025000000000005E-2]
[0.06,7.2249999999999988E-3,0,2.5000000000000045E-5,3.0250000000000008E-3,9.025E-3,1.3224999999999997E-2,2.8899999999999995E-2,2.4025000000000001E-2,5.0625000000000003E-2,5.2900000000000003E-2]
[6.5000000000000002E-2,8.0999999999999996E-3,2.5000000000000045E-5,0,2.5000000000000005E-3,8.0999999999999996E-3,1.44E-2,3.0624999999999996E-2,2.2499999999999999E-2,5.2900000000000003E-2,5.522500000000001E-2]
[0.115,1.9600000000000003E-2,3.0250000000000008E-3,2.5000000000000005E-3,0,1.5999999999999994E-3,2.8900000000000006E-2,5.0625000000000003E-2,9.9999999999999985E-3,7.8400000000000011E-2,8.1225000000000019E-2]
[0.155,3.2399999999999998E-2,9.025E-3,8.0999999999999996E-3,1.5999999999999994E-3,0,4.4099999999999993E-2,7.022500000000001E-2,3.5999999999999999E-3,0.1024,0.10562500000000001]
[-5.5E-2,8.9999999999999998E-4,1.3224999999999997E-2,1.44E-2,2.8900000000000006E-2,4.4099999999999993E-2,0,3.0249999999999999E-3,7.2900000000000006E-2,1.2100000000000003E-2,1.3225000000000004E-2]
[-0.11,7.2249999999999988E-3,2.8899999999999995E-2,3.0624999999999996E-2,5.0625000000000003E-2,7.022500000000001E-2,3.0249999999999999E-3,0,0.10562500000000001,3.0250000000000008E-3,3.6000000000000012E-3]
[0.215,5.7599999999999998E-2,2.4025000000000001E-2,2.2499999999999999E-2,9.9999999999999985E-3,3.5999999999999999E-3,7.2900000000000006E-2,0.10562500000000001,0,0.1444,0.148225]
[-0.16500000000000001,1.9600000000000003E-2,5.0625000000000003E-2,5.2900000000000003E-2,7.8400000000000011E-2,0.1024,1.2100000000000003E-2,3.0250000000000008E-3,0.1444,0,2.5000000000000045E-5]
[-0.17,2.1025000000000005E-2,5.2900000000000003E-2,5.522500000000001E-2,8.1225000000000019E-2,0.10562500000000001,1.3225000000000004E-2,3.6000000000000012E-3,0.148225,2.5000000000000045E-5,0]
[]
["hy^2",{"$f":"TRANSPOSE(C17:INDIRECT(_xlfn.CONCAT(\"C\",$B$14+16))/$B$7)","v":2.5000000000000001E-2},0.01,-0.02,-1.4999999999999999E-2,-3.5000000000000003E-2,0.04,7.4999999999999997E-2,0.03,0.01,0.125]
[{"$f":"(C17:INDIRECT(_xlfn.CONCAT(\"C\",$B$14+16))/$B$7)","v":2.5000000000000001E-2},{"$f":"((B$41-$A42))^2","v":0},{"$f":"((C$41-$A42))^2","v":2.2500000000000005E-4},2.0249999999999999E-3,1.6000000000000001E-3,3.6000000000000008E-3,2.2499999999999999E-4,2.4999999999999996E-3,2.4999999999999974E-5,2.2500000000000005E-4,1.0000000000000002E-2]
[0.01,{"$f":"((B$41-$A43))^2","v":2.2500000000000005E-4},0,8.9999999999999998E-4,6.2500000000000012E-4,2.0250000000000003E-3,8.9999999999999998E-4,4.2250000000000005E-3,3.9999999999999986E-4,0,1.3225000000000001E-2]
[-0.02,2.0249999999999999E-3,8.9999999999999998E-4,0,2.5000000000000011E-5,2.2500000000000008E-4,3.5999999999999999E-3,9.025E-3,2.5000000000000005E-3,8.9999999999999998E-4,2.1024999999999999E-2]
[-1.4999999999999999E-2,1.6000000000000001E-3,6.2500000000000012E-4,2.5000000000000011E-5,0,4.0000000000000018E-4,3.0249999999999999E-3,8.0999999999999996E-3,2.0249999999999999E-3,6.2500000000000012E-4,1.9600000000000003E-2]
[-3.5000000000000003E-2,3.6000000000000008E-3,2.0250000000000003E-3,2.2500000000000008E-4,4.0000000000000018E-4,0,5.6250000000000015E-3,1.21E-2,4.2250000000000005E-3,2.0250000000000003E-3,2.5600000000000001E-2]
[0.04,2.2499999999999999E-4,8.9999999999999998E-4,3.5999999999999999E-3,3.0249999999999999E-3,5.6250000000000015E-3,0,1.2249999999999997E-3,1.0000000000000005E-4,8.9999999999999998E-4,7.2249999999999988E-3]
[7.4999999999999997E-2,2.4999999999999996E-3,4.2250000000000005E-3,9.025E-3,8.0999999999999996E-3,1.21E-2,1.2249999999999997E-3,0,2.0249999999999999E-3,4.2250000000000005E-3,2.5000000000000005E-3]
[0.03,2.4999999999999974E-5,3.9999999999999986E-4,2.5000000000000005E-3,2.0249999999999999E-3,4.2250000000000005E-3,1.0000000000000005E-4,2.0249999999999999E-3,0,3.9999999999999986E-4,9.025E-3]
[0.01,2.2500000000000005E-4,0,8.9999999999999998E-4,6.2500000000000012E-4,2.0250000000000003E-3,8.9999999999999998E-4,4.2250000000000005E-3,3.9999999999999986E-4,0,1.3225000000000001E-2]
[0.125,1.0000000000000002E-2,1.3225000000000001E-2,2.1024999999999999E-2,1.9600000000000003E-2,2.5600000000000001E-2,7.2249999999999988E-3,2.5000000000000005E-3,9.025E-3,1.3225000000000001E-2,0]
[]
["hz^2",{"$f":"TRANSPOSE(D17:INDIRECT(_xlfn.CONCAT(\"D\",$B$14+16))/$B$8)","v":1.4999999999999999E-2},2.5000000000000001E-2,1.4999999999999999E-2,-2.5000000000000001E-2,0.04,0.105,0.215,-0.255,-0.1,0.16]
[{"$f":"(D17:INDIRECT(_xlfn.CONCAT(\"D\",$B$14+16))/$B$8)","v":1.4999999999999999E-2},{"$f":"((B$53-$A54))^2","v":0},{"$f":"((C$53-$A54))^2","v":1.0000000000000005E-4},0,1.6000000000000001E-3,6.2500000000000012E-4,8.0999999999999996E-3,4.0000000000000008E-2,7.2900000000000006E-2,1.3225000000000001E-2,2.1025000000000005E-2]
[2.5000000000000001E-2,{"$f":"((B$53-$A55))^2","v":1.0000000000000005E-4},0,1.0000000000000005E-4,2.5000000000000005E-3,2.2499999999999999E-4,6.3999999999999977E-3,3.61E-2,7.8400000000000011E-2,1.5625E-2,1.8225000000000002E-2]
[1.4999999999999999E-2,0,1.0000000000000005E-4,0,1.6000000000000001E-3,6.2500000000000012E-4,8.0999999999999996E-3,4.0000000000000008E-2,7.2900000000000006E-2,1.3225000000000001E-2,2.1025000000000005E-2]
[-2.5000000000000001E-2,1.6000000000000001E-3,2.5000000000000005E-3,1.6000000000000001E-3,0,4.2250000000000005E-3,1.6900000000000002E-2,5.7599999999999998E-2,5.2900000000000003E-2,5.6250000000000015E-3,3.4224999999999998E-2]
[0.04,6.2500000000000012E-4,2.2499999999999999E-4,6.2500000000000012E-4,4.2250000000000005E-3,0,4.2250000000000005E-3,3.0624999999999996E-2,8.7024999999999991E-2,1.9600000000000003E-2,1.44E-2]
[0.105,8.0999999999999996E-3,6.3999999999999977E-3,8.0999999999999996E-3,1.6900000000000002E-2,4.2250000000000005E-3,0,1.21E-2,0.12959999999999999,4.2025000000000007E-2,3.0250000000000008E-3]
[0.215,4.0000000000000008E-2,3.61E-2,4.0000000000000008E-2,5.7599999999999998E-2,3.0624999999999996E-2,1.21E-2,0,0.22089999999999999,9.9225000000000008E-2,3.0249999999999995E-3]
[-0.255,7.2900000000000006E-2,7.8400000000000011E-2,7.2900000000000006E-2,5.2900000000000003E-2,8.7024999999999991E-2,0.12959999999999999,0.22089999999999999,0,2.4025000000000001E-2,0.17222500000000002]
[-0.1,1.3225000000000001E-2,1.5625E-2,1.3225000000000001E-2,5.6250000000000015E-3,1.9600000000000003E-2,4.2025000000000007E-2,9.9225000000000008E-2,2.4025000000000001E-2,0,6.7600000000000007E-2]
[0.16,2.1025000000000005E-2,1.8225000000000002E-2,2.1025000000000005E-2,3.4224999999999998E-2,1.44E-2,3.0250000000000008E-3,3.0249999999999995E-3,0.17222500000000002,6.7600000000000007E-2,0]
[]
["h",1,2,3,4,5,6,7,8,9,10]
[1,{"$f":"SQRT(B30+B42+B54)","v":0},{"$f":"SQRT(C30+C42+C54)","v":8.6890735984913828E-2},0.10062305898749054,0.15099668870541502,0.19137659209004637,9.6046863561492724E-2,0.22299103120977759,0.36128243799000248,0.18179658962697842,0.22814469093099671]
[2,{"$f":"SQRT(B31+B43+B55)","v":8.6890735984913828E-2},0,3.2015621187164243E-2,7.842193570679061E-2,0.10618380290797651,0.14326548781894402,0.26310644233845737,0.32066337489647928,0.257390753524675,0.29043071462915215]
[3,0.10062305898749054,3.2015621187164243E-2,0,6.4226162893325653E-2,9.4604439642122506E-2,0.16155494421403513,0.28222331583340171,0.31288975694324034,0.25889186931999236,0.31188940347501393]
[4,0.15099668870541502,7.842193570679061E-2,6.4226162893325653E-2,0,7.8898669190297505E-2,0.22096379793984355,0.34106451002706217,0.25480384612481816,0.29094673051952313,0.3674914965002592]
[5,0.19137659209004637,0.10618380290797651,9.4604439642122506E-2,7.8898669190297505E-2,0,0.23227139298673866,0.3360803475361212,0.30797727188868984,0.35217183305880667,0.38160843806184369]
[6,9.6046863561492724E-2,0.14326548781894402,0.16155494421403513,0.22096379793984355,0.23227139298673866,0,0.12786711852544422,0.45011109739707594,0.23457408211479802,0.15321553446044564]
[7,0.22299103120977759,0.26310644233845737,0.28222331583340171,0.34106451002706217,0.3360803475361212,0.12786711852544422,0,0.57319281223685981,0.32630507198019465,9.5524865872714013E-2]
[8,0.36128243799000248,0.32066337489647928,0.31288975694324034,0.25480384612481816,0.30797727188868984,0.45011109739707594,0.57319281223685981,0,0.41088319508103516,0.57399912891919969]
[9,0.18179658962697842,0.257390753524675,0.25889186931999236,0.29094673051952313,0.35217183305880667,0.23457408211479802,0.32630507198019465,0.41088319508103516,0,0.28434134416225865]
[10,0.22814469093099671,0.29043071462915215,0.31188940347501393,0.3674914965002592,0.38160843806184369,0.15321553446044564,9.5524865872714013E-2,0.57399912891919969,0.28434134416225865,0]
[]
[]
["K",1,2,3,4,5,6,7,8,9,10]
[1,{"$f":"$B$4*(B66=0)+$B$5*EXP(-3*B66)","v":8.1},{"$f":"$B$4*(C66=0)+$B$5*EXP(-3*C66)","v":6.1642676236807441},5.915478349343835,5.085795590462574,4.5055580885097388,5.9972495212243384,4.0978745958808958,2.706332041053058,4.6369265847666465,4.035004709513256]
[2,{"$f":"$B$4*(B67=0)+$B$5*EXP(-3*B67)","v":6.1642676236807441},8.1,7.2673715456559274,6.3228859055483255,5.8176135398685505,5.2051320845682447,3.6332305626743149,3.0570531130291525,3.6960669992055317,3.3472844252944252]
[3,{"$f":"$B$4*(B68=0)+$B$5*EXP(-3*B68)","v":5.915478349343835},7.2673715456559274,8.1,6.597976776357382,6.0232574808746655,4.9272287436295068,3.4307249487962177,3.1291840098955892,3.6794597477240654,3.1385889855178974]
[4,{"$f":"$B$4*(B69=0)+$B$5*EXP(-3*B69)","v":5.085795590462574},6.3228859055483255,6.597976776357382,8.1,6.3138493748430937,4.1228725770899084,2.8755616497331391,3.7248627417690203,3.3421066781690034,2.6563873276597798]
[5,{"$f":"$B$4*(B70=0)+$B$5*EXP(-3*B70)","v":4.5055580885097388},5.8176135398685505,6.0232574808746655,6.3138493748430937,8.1,3.9853588673104485,2.9188815120202203,3.1756417122402354,2.7813211329664802,2.546236094802298]
[6,{"$f":"$B$4*(B71=0)+$B$5*EXP(-3*B71)","v":5.9972495212243384},5.2051320845682447,4.9272287436295068,4.1228725770899084,3.9853588673104485,8.1,5.4512240844302324,2.073230978307588,3.9579226145542754,5.0520542275004381]
[7,{"$f":"$B$4*(B72=0)+$B$5*EXP(-3*B72)","v":4.0978745958808958},3.6332305626743149,3.4307249487962177,2.8755616497331391,2.9188815120202203,5.4512240844302324,8.1,1.4331332123159308,3.0057476100280436,6.0066485298620496]
[8,{"$f":"$B$4*(B73=0)+$B$5*EXP(-3*B73)","v":2.706332041053058},3.0570531130291525,3.1291840098955892,3.7248627417690203,3.1756417122402354,2.073230978307588,1.4331332123159308,8.1,2.3321531893271574,1.4296707241459183]
[9,{"$f":"$B$4*(B74=0)+$B$5*EXP(-3*B74)","v":4.6369265847666465},3.6960669992055317,3.6794597477240654,3.3421066781690034,2.7813211329664802,3.9579226145542754,3.0057476100280436,2.3321531893271574,8.1,3.4089949411748885]
[10,{"$f":"$B$4*(B75=0)+$B$5*EXP(-3*B75)","v":4.035004709513256},3.3472844252944252,3.1385889855178974,2.6563873276597798,2.546236094802298,5.0520542275004381,6.0066485298620496,1.4296707241459183,3.4089949411748885,8.1]
[]
["Kinv",1,2,3,4,5,6,7,8,9,10]
[1,{"$f":"MINVERSE(B79:OFFSET(A78,$B$14,$B$14))","v":0.4412365065313445},-0.14147927737859892,-6.5454349469993789E-2,-1.5763489794173701E-2,2.5755684906820588E-2,-0.15997753125764691,1.3261113267617338E-2,-7.6739154090738676E-3,-7.9170760840977836E-2,-1.4279951597588058E-2]
[2,-0.14147927737859883,0.76337237414912618,-0.46029936991024861,-7.250101642425795E-2,-4.9966395544151256E-2,-4.7676247755884381E-2,-6.1120679995871679E-3,-1.1117987811808156E-3,1.4130477474588956E-2,1.3762294615309375E-3]
[3,-6.5454349469993969E-2,-0.46029936991024889,0.79994350668039793,-0.18444495459223445,-8.0314828348112016E-2,-8.9921868775423869E-3,-3.2028848043814773E-3,7.671799250819341E-3,-1.33868273514614E-2,1.08593203724104E-2]
[4,-1.5763489794173767E-2,-7.2501016424257742E-2,-0.18444495459223467,0.49395007438986532,-0.17203588194878666,2.1550975427610506E-2,7.2441853190325679E-3,-5.8154266003149449E-2,-1.4943500099062057E-2,-8.8898371589608794E-4]
[5,2.5755684906820623E-2,-4.9966395544151353E-2,-8.0314828348111919E-2,-0.17203588194878658,0.35435472857474132,-1.9370846465062104E-2,-1.6036061875345998E-2,-1.4974486211662015E-2,1.1082829285049696E-2,5.9183493354048201E-3]
[6,-0.15997753125764685,-4.7676247755884159E-2,-8.9921868775426749E-3,2.1550975427610509E-2,-1.9370846465062062E-2,0.39198572224687339,-0.11576308838495723,5.7372139634446033E-3,-1.3058934134786412E-2,-5.2256244968466058E-2]
[7,1.3261113267617301E-2,-6.1120679995872885E-3,-3.2028848043813068E-3,7.2441853190325289E-3,-1.603606187534597E-2,-0.11576308838495726,0.32891113823798329,2.4950060215939637E-3,6.6689603228759246E-3,-0.17512626444087484]
[8,-7.6739154090738658E-3,-1.1117987811808279E-3,7.6717992508193583E-3,-5.8154266003149442E-2,-1.4974486211662011E-2,5.7372139634445894E-3,2.4950060215939676E-3,0.15973016798707984,-1.8928248782278126E-2,-5.6673844613263627E-4]
[9,-7.9170760840977863E-2,1.4130477474588935E-2,-1.3386827351461383E-2,-1.4943500099062064E-2,1.1082829285049698E-2,-1.3058934134786388E-2,6.6689603228759237E-3,-1.8928248782278126E-2,0.19499426937292644,-3.532213989323206E-2]
[10,-1.4279951597588094E-2,1.3762294615309578E-3,1.0859320372410376E-2,-8.8898371589605509E-4,5.9183493354047854E-3,-5.2256244968466009E-2,-0.17512626444087484,-5.6673844613263778E-4,-3.5322139893232053E-2,0.30165044633271576]

{"sheet":"KS-Gaussien","index":10,"n_rows":100,"n_cols":11,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
["Krigeage simple modèle gaussien"]
[]
["Variogramme gaussien",null,null,"Variance des valeurs estimées","Variance d'estimation","Somme"]
["C0",5,null,{"$f":"MMULT(MMULT(TRANSPOSE(E17:OFFSET(E16,$B$14,0)),B79:OFFSET(A78,$B$14,$B$14)),E17:OFFSET(E16,$B$14,0))","v":3.2320179101150242},{"$f":"B4+B5+D4-2*MMULT(TRANSPOSE(E17:OFFSET(E16,$B$14,0)),H17:OFFSET(H16,$B14,0))","v":11.767982089884978},{"$f":"D4+E4","v":15.000000000000002}]
["C",10]
["ax",10]
["ay",10]
["az",10]
[]
["Point à estimer"]
[null,"x","y","z"]
["x0",0,0,0]
[]
["Nombre de points à utiliser",2]
["Points connus"]
["xi","x","y","z","Poids calculés par KS",null,"h(xi,x0)","k0"]
[1,-6,0,0,{"$f":"MMULT(B91:OFFSET(A90,$B$14,$B$14),H17:OFFSET(H16,$B$14,0))","v":0.21293942288561485},null,{"$f":"SQRT(((B17-$B$12)/$B$6)^2+((C17-$C$12)/$B$7)^2+((D17-$D$12)/$B$8)^2)","v":0.6},{"$f":"$B$4*(G17=0)+$B$5*EXP(-3*G17^2)","v":3.3959552564493913}]
[2,4,0,0,0.40545450813381417,null,{"$f":"SQRT(((B18-$B$12)/$B$6)^2+((C18-$C$12)/$B$7)^2+((D18-$D$12)/$B$8)^2)","v":0.4},{"$f":"$B$4*(G18=0)+$B$5*EXP(-3*G18^2)","v":6.1878339180614086}]
[3,13,-4,3,null,null,1.3928388277184121,2.9676051447809416E-2]
[4,23,-3,-5,null,null,2.3727621035409343,4.6213216885454046E-7]
[5,31,-7,8,null,null,3.2771939216347881,1.0163230913656828E-13]
[6,-11,8,21,null,null,2.5019992006393608,6.9815142670330551E-8]
[7,-22,15,43,null,null,5.0576674465607168,4.7015543264404486E-33]
[8,43,6,-51,null,null,6.6977608198561409,3.5698389639920984E-58]
[9,-33,2,-20,null,null,3.8639358172723313,3.5314263690423343E-19]
[10,-34,25,32,null,null,5.2962250707461447,2.8452428971262604E-36]
[null,null,null,null,{"$f":"1-SUM(E17:E26)","v":0.38160606898057092},"Poids de la moyenne connue"]
[]
["hx^2",{"$f":"TRANSPOSE(B17:INDIRECT(_xlfn.CONCAT(\"B\",$B$14+16))/$B$6)","v":-0.6},0.4]
[{"$f":"(B17:INDIRECT(_xlfn.CONCAT(\"B\",$B$14+16))/$B$6)","v":-0.6},{"$f":"((B$29-$A30))^2","v":0},{"$f":"((C$29-$A30))^2","v":1},{"$f":"((D$29-$A30))^2","v":0.36},0.36,0.36,0.36,0.36,0.36,0.36,0.36]
[0.4,1,0,0.16000000000000003,0.16000000000000003,0.16000000000000003,0.16000000000000003,0.16000000000000003,0.16000000000000003,0.16000000000000003,0.16000000000000003]
[null,0.36,0.16000000000000003,0,0,0,0,0,0,0,0]
[null,0.36,0.16000000000000003,0,0,0,0,0,0,0,0]
[null,0.36,0.16000000000000003,0,0,0,0,0,0,0,0]
[null,0.36,0.16000000000000003,0,0,0,0,0,0,0,0]
[null,0.36,0.16000000000000003,0,0,0,0,0,0,0,0]
[null,0.36,0.16000000000000003,0,0,0,0,0,0,0,0]
[null,0.36,0.16000000000000003,0,0,0,0,0,0,0,0]
[null,0.36,0.16000000000000003,0,0,0,0,0,0,0,0]
[]
["hy^2",{"$f":"TRANSPOSE(C17:INDIRECT(_xlfn.CONCAT(\"C\",$B$14+16))/$B$7)","v":0},0]
[{"$f":"(C17:INDIRECT(_xlfn.CONCAT(\"C\",$B$14+16))/$B$7)","v":0},{"$f":"((B$41-$A42))^2","v":0},{"$f":"((C$41-$A42))^2","v":0},0,0,0,0,0,0,0,0]
[0,{"$f":"((B$41-$A43))^2","v":0},0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[]
["hz^2",{"$f":"TRANSPOSE(D17:INDIRECT(_xlfn.CONCAT(\"D\",$B$14+16))/$B$8)","v":0},0]
[{"$f":"(D17:INDIRECT(_xlfn.CONCAT(\"D\",$B$14+16))/$B$8)","v":0},{"$f":"((B$53-$A54))^2","v":0},{"$f":"((C$53-$A54))^2","v":0},0,0,0,0,0,0,0,0]
[0,{"$f":"((B$53-$A55))^2","v":0},0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[]
["h",1,2,3,4,5,6,7,8,9,10]
[1,{"$f":"SQRT(B30+B42+B54)","v":0},{"$f":"SQRT(C30+C42+C54)","v":1},0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6]
[2,{"$f":"SQRT(B31+B43+B55)","v":1},0,0.4,0.4,0.4,0.4,0.4,0.4,0.4,0.4]
[3,0.6,0.4,0,0,0,0,0,0,0,0]
[4,0.6,0.4,0,0,0,0,0,0,0,0]
[5,0.6,0.4,0,0,0,0,0,0,0,0]
[6,0.6,0.4,0,0,0,0,0,0,0,0]
[7,0.6,0.4,0,0,0,0,0,0,0,0]
[8,0.6,0.4,0,0,0,0,0,0,0,0]
[9,0.6,0.4,0,0,0,0,0,0,0,0]
[10,0.6,0.4,0,0,0,0,0,0,0,0]
[]
[]
["K",1,2,3,4,5,6,7,8,9,10]
[1,{"$f":"$B$4*(B66=0)+$B$5*EXP(-3*B66^2)","v":15},{"$f":"$B$4*(C66=0)+$B$5*EXP(-3*C66^2)","v":0.49787068367863946},3.3959552564493913,3.3959552564493913,3.3959552564493913,3.3959552564493913,3.3959552564493913,3.3959552564493913,3.3959552564493913,3.3959552564493913]
[2,{"$f":"$B$4*(B67=0)+$B$5*EXP(-3*B67^2)","v":0.49787068367863946},15,6.1878339180614086,6.1878339180614086,6.1878339180614086,6.1878339180614086,6.1878339180614086,6.1878339180614086,6.1878339180614086,6.1878339180614086]
[3,{"$f":"$B$4*(B68=0)+$B$5*EXP(-3*B68^2)","v":3.3959552564493913},6.1878339180614086,15,15,15,15,15,15,15,15]
[4,{"$f":"$B$4*(B69=0)+$B$5*EXP(-3*B69^2)","v":3.3959552564493913},6.1878339180614086,15,15,15,15,15,15,15,15]
[5,{"$f":"$B$4*(B70=0)+$B$5*EXP(-3*B70^2)","v":3.3959552564493913},6.1878339180614086,15,15,15,15,15,15,15,15]
[6,{"$f":"$B$4*(B71=0)+$B$5*EXP(-3*B71^2)","v":3.3959552564493913},6.1878339180614086,15,15,15,15,15,15,15,15]
[7,{"$f":"$B$4*(B72=0)+$B$5*EXP(-3*B72^2)","v":3.3959552564493913},6.1878339180614086,15,15,15,15,15,15,15,15]
[8,{"$f":"$B$4*(B73=0)+$B$5*EXP(-3*B73^2)","v":3.3959552564493913},6.1878339180614086,15,15,15,15,15,15,15,15]
[9,{"$f":"$B$4*(B74=0)+$B$5*EXP(-3*B74^2)","v":3.3959552564493913},6.1878339180614086,15,15,15,15,15,15,15,15]
[10,{"$f":"$B$4*(B75=0)+$B$5*EXP(-3*B75^2)","v":3.3959552564493913},6.1878339180614086,15,15,15,15,15,15,15,15]
[]
["Kinv",1,2,3,4,5,6,7,8,9,10]
[1,{"$f":"MINVERSE(B79:OFFSET(A78,$B$14,$B$14))","v":6.6740192176279148E-2},-2.2151990071765256E-3]
[2,-2.2151990071765256E-3,6.6740192176279148E-2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]

{"sheet":"KO-Sphérique","index":11,"n_rows":95,"n_cols":12,"rows_kept":95,"cut":false,"hidden":false,"merged":[]}
["Krigeage ordinaire modèle sphérique"]
[]
["Variogramme sphérique",null,null,"Variance des valeurs estimées","Variance d'estimation","Somme"]
["C0",10,null,{"$f":"MMULT(MMULT(TRANSPOSE(E17:OFFSET(E16,$B$14,0)),B79:OFFSET(A78,$B$14,$B$14)),E17:OFFSET(E16,$B$14,0))","v":110.44899096433181},{"$f":"B4+B5-MMULT(TRANSPOSE(E16:OFFSET(E16,$B$14,0)),H16:OFFSET(H16,$B14,0))","v":34.909167335385078},{"$f":"D4+E4","v":145.35815829971688}]
["C",135]
["ax",100]
["ay",100]
["az",100]
[]
["Point à estimer"]
[null,"x","y","z"]
["x0",10,10,0]
[]
["Nombre de points à utiliser",3]
["Points connus",null,null,null,"Poids calculés par KO",null,"h(xi,x0)","k0"]
["xi","x","y","z",{"$f":"MMULT(A91:OFFSET(A91,$B$14,$B$14),H16:OFFSET(H16,$B$14,0))","v":-0.17907914985845252},"Multiplicateur de Lagrange",null,1]
[1,0,0,0,0.27513098289538129,null,{"$f":"MIN(SQRT(((B17-$B$12)/$B$6)^2+((C17-$C$12)/$B$7)^2+((D17-$D$12)/$B$8)^2),1)","v":0.14142135623730953},{"$f":"$B$4*(G17=0)+$B$5*(1-(1.5*G17-0.5*G17^3))","v":106.5530941928652}]
[2,20,0,0,0.27513098289538163,null,{"$f":"MIN(SQRT(((B18-$B$12)/$B$6)^2+((C18-$C$12)/$B$7)^2+((D18-$D$12)/$B$8)^2),1)","v":0.14142135623730953},{"$f":"$B$4*(G18=0)+$B$5*(1-(1.5*G18-0.5*G18^3))","v":106.5530941928652}]
[3,10,20,0,0.44973803420923675,null,0.1,114.81750000000001]
[4,35,0,0,null,null,0.26925824035672524,81.792888841508869]
[5,31,-7,8,null,null,0.28178005607210743,79.449738855916706]
[6,-11,8,21,null,null,0.29765752132274431,76.504492738414953]
[7,-22,15,43,null,null,0.53833075334779079,36.518579478685176]
[8,43,6,-51,null,null,0.60876925020897699,26.952894011284833]
[9,-33,2,-20,null,null,0.48093658625644192,45.119083970145773]
[10,-34,25,32,null,null,0.56435804238089848,32.850488881504397]
[null,null,null,null,{"$f":"SUM(E17:E26)","v":0.99999999999999967},"Somme des poids"]
[]
["hx^2",{"$f":"TRANSPOSE(B17:INDIRECT(_xlfn.CONCAT(\"B\",$B$14+16))/$B$6)","v":0},0.2,0.1]
[{"$f":"(B17:INDIRECT(_xlfn.CONCAT(\"B\",$B$14+16))/$B$6)","v":0},{"$f":"MIN(((B$29-$A30))^2,1)","v":0},{"$f":"MIN(((C$29-$A30))^2,1)","v":4.0000000000000008E-2},1.0000000000000002E-2,0,0,0,0,0,0,0]
[0.2,{"$f":"MIN(((B$29-$A31))^2,1)","v":4.0000000000000008E-2},0,1.0000000000000002E-2,4.0000000000000008E-2,4.0000000000000008E-2,4.0000000000000008E-2,4.0000000000000008E-2,4.0000000000000008E-2,4.0000000000000008E-2,4.0000000000000008E-2]
[0.1,1.0000000000000002E-2,1.0000000000000002E-2,0,1.0000000000000002E-2,1.0000000000000002E-2,1.0000000000000002E-2,1.0000000000000002E-2,1.0000000000000002E-2,1.0000000000000002E-2,1.0000000000000002E-2]
[null,0,4.0000000000000008E-2,1.0000000000000002E-2,0,0,0,0,0,0,0]
[null,0,4.0000000000000008E-2,1.0000000000000002E-2,0,0,0,0,0,0,0]
[null,0,4.0000000000000008E-2,1.0000000000000002E-2,0,0,0,0,0,0,0]
[null,0,4.0000000000000008E-2,1.0000000000000002E-2,0,0,0,0,0,0,0]
[null,0,4.0000000000000008E-2,1.0000000000000002E-2,0,0,0,0,0,0,0]
[null,0,4.0000000000000008E-2,1.0000000000000002E-2,0,0,0,0,0,0,0]
[null,0,4.0000000000000008E-2,1.0000000000000002E-2,0,0,0,0,0,0,0]
[]
["hy^2",{"$f":"TRANSPOSE(C17:INDIRECT(_xlfn.CONCAT(\"C\",$B$14+16))/$B$7)","v":0},0,0.2]
[{"$f":"(C17:INDIRECT(_xlfn.CONCAT(\"C\",$B$14+16))/$B$7)","v":0},{"$f":"MIN(((B$41-$A42))^2,1)","v":0},{"$f":"MIN(((C$41-$A42))^2,1)","v":0},4.0000000000000008E-2,0,0,0,0,0,0,0]
[0,{"$f":"MIN(((B$41-$A43))^2,1)","v":0},0,4.0000000000000008E-2,0,0,0,0,0,0,0]
[0.2,4.0000000000000008E-2,4.0000000000000008E-2,0,4.0000000000000008E-2,4.0000000000000008E-2,4.0000000000000008E-2,4.0000000000000008E-2,4.0000000000000008E-2,4.0000000000000008E-2,4.0000000000000008E-2]
[null,0,0,4.0000000000000008E-2,0,0,0,0,0,0,0]
[null,0,0,4.0000000000000008E-2,0,0,0,0,0,0,0]
[null,0,0,4.0000000000000008E-2,0,0,0,0,0,0,0]
[null,0,0,4.0000000000000008E-2,0,0,0,0,0,0,0]
[null,0,0,4.0000000000000008E-2,0,0,0,0,0,0,0]
[null,0,0,4.0000000000000008E-2,0,0,0,0,0,0,0]
[null,0,0,4.0000000000000008E-2,0,0,0,0,0,0,0]
[]
["hz^2",{"$f":"TRANSPOSE(D17:INDIRECT(_xlfn.CONCAT(\"D\",$B$14+16))/$B$8)","v":0},0,0]
[{"$f":"(D17:INDIRECT(_xlfn.CONCAT(\"D\",$B$14+16))/$B$8)","v":0},{"$f":"MIN((B$53-$A54)^2,1)","v":0},{"$f":"MIN((C$53-$A54)^2,1)","v":0},0,0,0,0,0,0,0,0]
[0,{"$f":"MIN((B$53-$A55)^2,1)","v":0},0,0,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[]
["h",1,2,3,4,5,6,7,8,9,10]
[1,{"$f":"MIN(SQRT(B30+B42+B54),1)","v":0},{"$f":"MIN(SQRT(C30+C42+C54),1)","v":0.2},0.22360679774997899,0,0,0,0,0,0,0]
[2,{"$f":"MIN(SQRT(B31+B43+B55),1)","v":0.2},0,0.22360679774997899,0.2,0.2,0.2,0.2,0.2,0.2,0.2]
[3,0.22360679774997899,0.22360679774997899,0,0.22360679774997899,0.22360679774997899,0.22360679774997899,0.22360679774997899,0.22360679774997899,0.22360679774997899,0.22360679774997899]
[4,0,0.2,0.22360679774997899,0,0,0,0,0,0,0]
[5,0,0.2,0.22360679774997899,0,0,0,0,0,0,0]
[6,0,0.2,0.22360679774997899,0,0,0,0,0,0,0]
[7,0,0.2,0.22360679774997899,0,0,0,0,0,0,0]
[8,0,0.2,0.22360679774997899,0,0,0,0,0,0,0]
[9,0,0.2,0.22360679774997899,0,0,0,0,0,0,0]
[10,0,0.2,0.22360679774997899,0,0,0,0,0,0,0]
[]
[]
[0,1,1,1,1,1,1,1,1,1,1]
[1,{"$f":"$B$4*(B66=0)+$B$5*(1-(1.5*B66-0.5*B66^3))","v":145},{"$f":"$B$4*(C66=0)+$B$5*(1-(1.5*C66-0.5*C66^3))","v":95.039999999999992},90.474296398035435,145,145,145,145,145,145,145]
[1,{"$f":"$B$4*(B67=0)+$B$5*(1-(1.5*B67-0.5*B67^3))","v":95.039999999999992},145,90.474296398035435,95.039999999999992,95.039999999999992,95.039999999999992,95.039999999999992,95.039999999999992,95.039999999999992,95.039999999999992]
[1,90.474296398035435,90.474296398035435,145,90.474296398035435,90.474296398035435,90.474296398035435,90.474296398035435,90.474296398035435,90.474296398035435,90.474296398035435]
[1,145,95.039999999999992,90.474296398035435,145,145,145,145,145,145,145,"Matrice K augmentée"]
[1,145,95.039999999999992,90.474296398035435,145,145,145,145,145,145,145]
[1,145,95.039999999999992,90.474296398035435,145,145,145,145,145,145,145]
[1,145,95.039999999999992,90.474296398035435,145,145,145,145,145,145,145]
[1,145,95.039999999999992,90.474296398035435,145,145,145,145,145,145,145]
[1,145,95.039999999999992,90.474296398035435,145,145,145,145,145,145,145]
[1,145,95.039999999999992,90.474296398035435,145,145,145,145,145,145,145]
[]
["Kinv"]
[{"$f":"MINVERSE(A78:OFFSET(A78,$B$14,$B$14))","v":-109.63658154219235},0.32428209194657276,0.32428209194657243,0.35143581610685515]
[0.32428209194657254,1.2981669013073354E-2,-7.0343437971748385E-3,-5.9473252158985185E-3]
[0.32428209194657248,-7.0343437971748385E-3,1.2981669013073358E-2,-5.9473252158985185E-3]
[0.35143581610685498,-5.9473252158985176E-3,-5.9473252158985176E-3,1.1894650431797035E-2]
[null,null,null,null,null,null,null,null,null,null,null,"Inverse de K augmentée"]

{"sheet":"KO-Exponentiel","index":12,"n_rows":95,"n_cols":12,"rows_kept":95,"cut":false,"hidden":false,"merged":[]}
["Krigeage ordinaire modèle exponentiel"]
[]
["Variogramme sphérique",null,null,"Variance des valeurs estimées","Variance d'estimation","Somme"]
["C0",10,null,{"$f":"MMULT(MMULT(TRANSPOSE(E17:OFFSET(E16,$B$14,0)),B79:OFFSET(A78,$B$14,$B$14)),E17:OFFSET(E16,$B$14,0))","v":96.622902071737229},{"$f":"B4+B5-MMULT(TRANSPOSE(E16:OFFSET(E16,$B$14,0)),H16:OFFSET(H16,$B14,0))","v":54.500579312546989},{"$f":"D4+E4","v":151.12348138428422}]
["C",135]
["ax",100]
["ay",100]
["az",100]
[]
["Point à estimer"]
[null,"x","y","z"]
["x0",10,10,0]
[]
["Nombre de points à utiliser",3]
["Points connus",null,null,null,"Poids calculés par KO",null,"h(xi,x0)","k0"]
["xi","x","y","z",{"$f":"MMULT(A91:OFFSET(A91,$B$14,$B$14),H16:OFFSET(H16,$B$14,0))","v":-3.0617406921421235},"Multiplicateur de Lagrange",null,1]
[1,0,0,0,0.27592795024501587,null,{"$f":"SQRT(((B17-$B$12)/$B$6)^2+((C17-$C$12)/$B$7)^2+((D17-$D$12)/$B$8)^2)","v":0.14142135623730953},{"$f":"$B$4*(G17=0)+$B$5*EXP(-3*G17)","v":88.323897400092292}]
[2,20,0,0,0.27592795024501565,null,{"$f":"SQRT(((B18-$B$12)/$B$6)^2+((C18-$C$12)/$B$7)^2+((D18-$D$12)/$B$8)^2)","v":0.14142135623730953},{"$f":"$B$4*(G18=0)+$B$5*EXP(-3*G18)","v":88.323897400092292}]
[3,10,20,0,0.44814409950996847,null,0.1,100.01045979203191]
[4,23,-3,-5,null,null,0.19052558883257653,76.225649368600926]
[5,31,-7,8,null,null,0.28178005607210743,57.970520275575595]
[6,-11,8,21,null,null,0.29765752132274431,55.273976743564035]
[7,-22,15,43,null,null,0.53833075334779079,26.850448330011897]
[8,43,6,-51,null,null,0.60876925020897699,21.735938176110377]
[9,-33,2,-20,null,null,0.48093658625644192,31.895502732160541]
[10,-34,25,32,null,null,0.56435804238089848,24.833676397731494]
[null,null,null,null,{"$f":"SUM(E17:E26)","v":1},"Somme des poids"]
[]
["hx^2",{"$f":"TRANSPOSE(B17:INDIRECT(_xlfn.CONCAT(\"B\",$B$14+16))/$B$6)","v":0},0.2,0.1]
[{"$f":"(B17:INDIRECT(_xlfn.CONCAT(\"B\",$B$14+16))/$B$6)","v":0},{"$f":"((B$29-$A30))^2","v":0},{"$f":"((C$29-$A30))^2","v":4.0000000000000008E-2},1.0000000000000002E-2,0,0,0,0,0,0,0]
[0.2,{"$f":"((B$29-$A31))^2","v":4.0000000000000008E-2},0,1.0000000000000002E-2,4.0000000000000008E-2,4.0000000000000008E-2,4.0000000000000008E-2,4.0000000000000008E-2,4.0000000000000008E-2,4.0000000000000008E-2,4.0000000000000008E-2]
[0.1,1.0000000000000002E-2,1.0000000000000002E-2,0,1.0000000000000002E-2,1.0000000000000002E-2,1.0000000000000002E-2,1.0000000000000002E-2,1.0000000000000002E-2,1.0000000000000002E-2,1.0000000000000002E-2]
[null,0,4.0000000000000008E-2,1.0000000000000002E-2,0,0,0,0,0,0,0]
[null,0,4.0000000000000008E-2,1.0000000000000002E-2,0,0,0,0,0,0,0]
[null,0,4.0000000000000008E-2,1.0000000000000002E-2,0,0,0,0,0,0,0]
[null,0,4.0000000000000008E-2,1.0000000000000002E-2,0,0,0,0,0,0,0]
[null,0,4.0000000000000008E-2,1.0000000000000002E-2,0,0,0,0,0,0,0]
[null,0,4.0000000000000008E-2,1.0000000000000002E-2,0,0,0,0,0,0,0]
[null,0,4.0000000000000008E-2,1.0000000000000002E-2,0,0,0,0,0,0,0]
[]
["hy^2",{"$f":"TRANSPOSE(C17:INDIRECT(_xlfn.CONCAT(\"C\",$B$14+16))/$B$7)","v":0},0,0.2]
[{"$f":"(C17:INDIRECT(_xlfn.CONCAT(\"C\",$B$14+16))/$B$7)","v":0},{"$f":"((B$41-$A42))^2","v":0},{"$f":"((C$41-$A42))^2","v":0},4.0000000000000008E-2,0,0,0,0,0,0,0]
[0,{"$f":"((B$41-$A43))^2","v":0},0,4.0000000000000008E-2,0,0,0,0,0,0,0]
[0.2,4.0000000000000008E-2,4.0000000000000008E-2,0,4.0000000000000008E-2,4.0000000000000008E-2,4.0000000000000008E-2,4.0000000000000008E-2,4.0000000000000008E-2,4.0000000000000008E-2,4.0000000000000008E-2]
[null,0,0,4.0000000000000008E-2,0,0,0,0,0,0,0]
[null,0,0,4.0000000000000008E-2,0,0,0,0,0,0,0]
[null,0,0,4.0000000000000008E-2,0,0,0,0,0,0,0]
[null,0,0,4.0000000000000008E-2,0,0,0,0,0,0,0]
[null,0,0,4.0000000000000008E-2,0,0,0,0,0,0,0]
[null,0,0,4.0000000000000008E-2,0,0,0,0,0,0,0]
[null,0,0,4.0000000000000008E-2,0,0,0,0,0,0,0]
[]
["hz^2",{"$f":"TRANSPOSE(D17:INDIRECT(_xlfn.CONCAT(\"D\",$B$14+16))/$B$8)","v":0},0,0]
[{"$f":"(D17:INDIRECT(_xlfn.CONCAT(\"D\",$B$14+16))/$B$8)","v":0},{"$f":"(B$53-$A54)^2","v":0},{"$f":"(C$53-$A54)^2","v":0},0,0,0,0,0,0,0,0]
[0,{"$f":"(B$53-$A55)^2","v":0},0,0,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[]
["h",1,2,3,4,5,6,7,8,9,10]
[1,{"$f":"SQRT(B30+B42+B54)","v":0},{"$f":"SQRT(C30+C42+C54)","v":0.2},0.22360679774997899,0,0,0,0,0,0,0]
[2,{"$f":"SQRT(B31+B43+B55)","v":0.2},0,0.22360679774997899,0.2,0.2,0.2,0.2,0.2,0.2,0.2]
[3,{"$f":"SQRT(B32+B44+B56)","v":0.22360679774997899},0.22360679774997899,0,0.22360679774997899,0.22360679774997899,0.22360679774997899,0.22360679774997899,0.22360679774997899,0.22360679774997899,0.22360679774997899]
[4,{"$f":"SQRT(B33+B45+B57)","v":0},0.2,0.22360679774997899,0,0,0,0,0,0,0]
[5,{"$f":"SQRT(B34+B46+B58)","v":0},0.2,0.22360679774997899,0,0,0,0,0,0,0]
[6,{"$f":"SQRT(B35+B47+B59)","v":0},0.2,0.22360679774997899,0,0,0,0,0,0,0]
[7,{"$f":"SQRT(B36+B48+B60)","v":0},0.2,0.22360679774997899,0,0,0,0,0,0,0]
[8,{"$f":"SQRT(B37+B49+B61)","v":0},0.2,0.22360679774997899,0,0,0,0,0,0,0]
[9,{"$f":"SQRT(B38+B50+B62)","v":0},0.2,0.22360679774997899,0,0,0,0,0,0,0]
[10,{"$f":"SQRT(B39+B51+B63)","v":0},0.2,0.22360679774997899,0,0,0,0,0,0,0]
[]
[]
[0,1,1,1,1,1,1,1,1,1,1]
[1,{"$f":"$B$4*(B66=0)+$B$5*EXP(-3*B66)","v":145},{"$f":"$B$4*(C66=0)+$B$5*EXP(-3*C66)","v":74.089570872693557},69.024007936500524,145,145,145,145,145,145,145]
[1,{"$f":"$B$4*(B67=0)+$B$5*EXP(-3*B67)","v":74.089570872693557},145,69.024007936500524,74.089570872693557,74.089570872693557,74.089570872693557,74.089570872693557,74.089570872693557,74.089570872693557,74.089570872693557]
[1,{"$f":"$B$4*(B68=0)+$B$5*EXP(-3*B68)","v":69.024007936500524},69.024007936500524,145,69.024007936500524,69.024007936500524,69.024007936500524,69.024007936500524,69.024007936500524,69.024007936500524,69.024007936500524]
[1,{"$f":"$B$4*(B69=0)+$B$5*EXP(-3*B69)","v":145},74.089570872693557,69.024007936500524,145,145,145,145,145,145,145,"Matrice K augmentée"]
[1,{"$f":"$B$4*(B70=0)+$B$5*EXP(-3*B70)","v":145},74.089570872693557,69.024007936500524,145,145,145,145,145,145,145]
[1,{"$f":"$B$4*(B71=0)+$B$5*EXP(-3*B71)","v":145},74.089570872693557,69.024007936500524,145,145,145,145,145,145,145]
[1,{"$f":"$B$4*(B72=0)+$B$5*EXP(-3*B72)","v":145},74.089570872693557,69.024007936500524,145,145,145,145,145,145,145]
[1,{"$f":"$B$4*(B73=0)+$B$5*EXP(-3*B73)","v":145},74.089570872693557,69.024007936500524,145,145,145,145,145,145,145]
[1,{"$f":"$B$4*(B74=0)+$B$5*EXP(-3*B74)","v":145},74.089570872693557,69.024007936500524,145,145,145,145,145,145,145]
[1,{"$f":"$B$4*(B75=0)+$B$5*EXP(-3*B75)","v":145},74.089570872693557,69.024007936500524,145,145,145,145,145,145,145]
[]
["Kinv"]
[{"$f":"MINVERSE(A78:OFFSET(A78,$B$14,$B$14))","v":-95.450545610243822},0.32608626122541146,0.32608626122541168,0.34782747754917664]
[0.32608626122541162,9.1971312326987794E-3,-4.9051667269523558E-3,-4.2919645057464218E-3]
[0.32608626122541162,-4.9051667269523558E-3,9.1971312326987777E-3,-4.2919645057464218E-3]
[0.34782747754917676,-4.2919645057464218E-3,-4.2919645057464218E-3,8.5839290114928437E-3]
[null,null,null,null,null,null,null,null,null,null,null,"Inverse de K augmentée"]

{"sheet":"KO-Gaussien","index":13,"n_rows":98,"n_cols":12,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
["Krigeage ordinaire modèle gaussien"]
[]
["Variogramme gaussien",null,null,"Variance des valeurs estimées","Variance d'estimation","Somme"]
["C0",5,null,{"$f":"MMULT(MMULT(TRANSPOSE(E17:OFFSET(E16,$B$14,0)),B79:OFFSET(A78,$B$14,$B$14)),E17:OFFSET(E16,$B$14,0))","v":5.8897678849326223},{"$f":"B4+B5-MMULT(TRANSPOSE(E16:OFFSET(E16,$B$14,0)),H16:OFFSET(H16,$B14,0))","v":10.607254750598628},{"$f":"D4+E4","v":16.497022635531252}]
["C",10]
["ax",10]
["ay",30]
["az",10]
[]
["Point à estimer"]
[null,"x","y","z"]
["x0",0,0,0]
[]
["Nombre de points à utiliser",7]
["Points connus",null,null,null,"Poids calculés par KO",null,"h(xi,x0)","k0"]
["xi","x","y","z",{"$f":"MMULT(A91:OFFSET(A91,$B$14,$B$14),H16:OFFSET(H16,$B$14,0))","v":-0.74851131776562485},"Multiplicateur de Lagrange",null,1]
[1,0,10,0,0.42877707954178335,null,{"$f":"SQRT(((B17-$B$12)/$B$6)^2+((C17-$C$12)/$B$7)^2+((D17-$D$12)/$B$8)^2)","v":0.33333333333333331},{"$f":"$B$4*(G17=0)+$B$5*EXP(-3*G17^2)","v":7.1653131057378925}]
[2,4,0,0,0.33407755557817914,null,{"$f":"SQRT(((B18-$B$12)/$B$6)^2+((C18-$C$12)/$B$7)^2+((D18-$D$12)/$B$8)^2)","v":0.4},{"$f":"$B$4*(G18=0)+$B$5*EXP(-3*G18^2)","v":6.1878339180614086}]
[3,13,-4,3,3.7786236990704235E-2,null,1.3408123574079178,4.5467920741087416E-2]
[4,23,-3,-5,4.9686471429752646E-2,null,2.3558437978779492,5.8748512699252359E-7]
[5,31,-7,8,4.9871136327371328E-2,null,3.210053651334265,3.7541352606295897E-13]
[6,-11,8,21,4.9900765984871302E-2,null,2.385604978011052,3.8472069235724492E-7]
[7,-22,15,43,4.9900754147337856E-2,null,4.8559242168715935,1.8967423894564462E-30]
[8,43,6,-51,null,null,6.6738294853854327,9.3233358329469364E-58]
[9,-33,2,-20,null,null,3.8593321241433012,3.9289355098103294E-19]
[10,-34,25,32,null,null,4.7428308471254219,4.9244837977342035E-29]
[null,null,null,null,{"$f":"SUM(E17:E26)","v":0.99999999999999989},"Somme des poids"]
[]
["hx^2",{"$f":"TRANSPOSE(B17:INDIRECT(_xlfn.CONCAT(\"B\",$B$14+16))/$B$6)","v":0},0.4,1.3,2.2999999999999998,3.1,-1.1000000000000001,-2.2000000000000002]
[{"$f":"(B17:INDIRECT(_xlfn.CONCAT(\"B\",$B$14+16))/$B$6)","v":0},{"$f":"((B$29-$A30))^2","v":0},{"$f":"((C$29-$A30))^2","v":0.16000000000000003},1.6900000000000002,5.2899999999999991,9.6100000000000012,1.2100000000000002,4.8400000000000007,0,0,0]
[0.4,{"$f":"((B$29-$A31))^2","v":0.16000000000000003},0,0.81,3.61,7.2900000000000009,2.25,6.7600000000000007,0.16000000000000003,0.16000000000000003,0.16000000000000003]
[1.3,1.6900000000000002,0.81,0,0.99999999999999956,3.24,5.7600000000000016,12.25,1.6900000000000002,1.6900000000000002,1.6900000000000002]
[2.2999999999999998,5.2899999999999991,3.61,0.99999999999999956,0,0.64000000000000046,11.559999999999999,20.25,5.2899999999999991,5.2899999999999991,5.2899999999999991]
[3.1,9.6100000000000012,7.2900000000000009,3.24,0.64000000000000046,0,17.64,28.090000000000007,9.6100000000000012,9.6100000000000012,9.6100000000000012]
[-1.1000000000000001,1.2100000000000002,2.25,5.7600000000000016,11.559999999999999,17.64,0,1.2100000000000002,1.2100000000000002,1.2100000000000002,1.2100000000000002]
[-2.2000000000000002,4.8400000000000007,6.7600000000000007,12.25,20.25,28.090000000000007,1.2100000000000002,0,4.8400000000000007,4.8400000000000007,4.8400000000000007]
[null,0,0.16000000000000003,1.6900000000000002,5.2899999999999991,9.6100000000000012,1.2100000000000002,4.8400000000000007,0,0,0]
[null,0,0.16000000000000003,1.6900000000000002,5.2899999999999991,9.6100000000000012,1.2100000000000002,4.8400000000000007,0,0,0]
[null,0,0.16000000000000003,1.6900000000000002,5.2899999999999991,9.6100000000000012,1.2100000000000002,4.8400000000000007,0,0,0]
[]
["hy^2",{"$f":"TRANSPOSE(C17:INDIRECT(_xlfn.CONCAT(\"C\",$B$14+16))/$B$7)","v":0.33333333333333331},0,-0.13333333333333333,-0.1,-0.23333333333333334,0.26666666666666666,0.5]
[{"$f":"(C17:INDIRECT(_xlfn.CONCAT(\"C\",$B$14+16))/$B$7)","v":0.33333333333333331},{"$f":"((B$41-$A42))^2","v":0},{"$f":"((C$41-$A42))^2","v":0.1111111111111111},0.21777777777777779,0.18777777777777779,0.32111111111111107,4.4444444444444427E-3,2.7777777777777783E-2,0.1111111111111111,0.1111111111111111,0.1111111111111111]
[0,{"$f":"((B$41-$A43))^2","v":0.1111111111111111},0,1.7777777777777778E-2,1.0000000000000002E-2,5.4444444444444448E-2,7.1111111111111111E-2,0.25,0,0,0]
[-0.13333333333333333,0.21777777777777779,1.7777777777777778E-2,0,1.1111111111111107E-3,1.0000000000000002E-2,0.16000000000000003,0.40111111111111108,1.7777777777777778E-2,1.7777777777777778E-2,1.7777777777777778E-2]
[-0.1,0.18777777777777779,1.0000000000000002E-2,1.1111111111111107E-3,0,1.7777777777777778E-2,0.13444444444444448,0.36,1.0000000000000002E-2,1.0000000000000002E-2,1.0000000000000002E-2]
[-0.23333333333333334,0.32111111111111107,5.4444444444444448E-2,1.0000000000000002E-2,1.7777777777777778E-2,0,0.25,0.53777777777777791,5.4444444444444448E-2,5.4444444444444448E-2,5.4444444444444448E-2]
[0.26666666666666666,4.4444444444444427E-3,7.1111111111111111E-2,0.16000000000000003,0.13444444444444448,0.25,0,5.4444444444444448E-2,7.1111111111111111E-2,7.1111111111111111E-2,7.1111111111111111E-2]
[0.5,2.7777777777777783E-2,0.25,0.40111111111111108,0.36,0.53777777777777791,5.4444444444444448E-2,0,0.25,0.25,0.25]
[null,0.1111111111111111,0,1.7777777777777778E-2,1.0000000000000002E-2,5.4444444444444448E-2,7.1111111111111111E-2,0.25,0,0,0]
[null,0.1111111111111111,0,1.7777777777777778E-2,1.0000000000000002E-2,5.4444444444444448E-2,7.1111111111111111E-2,0.25,0,0,0]
[null,0.1111111111111111,0,1.7777777777777778E-2,1.0000000000000002E-2,5.4444444444444448E-2,7.1111111111111111E-2,0.25,0,0,0]
[]
["hz^2",{"$f":"TRANSPOSE(D17:INDIRECT(_xlfn.CONCAT(\"D\",$B$14+16))/$B$8)","v":0},0,0.3,-0.5,0.8,2.1,4.3]
[{"$f":"(D17:INDIRECT(_xlfn.CONCAT(\"D\",$B$14+16))/$B$8)","v":0},{"$f":"(B$53-$A54)^2","v":0},{"$f":"(C$53-$A54)^2","v":0},0.09,0.25,0.64000000000000012,4.41,18.489999999999998,0,0,0]
[0,{"$f":"(B$53-$A55)^2","v":0},0,0.09,0.25,0.64000000000000012,4.41,18.489999999999998,0,0,0]
[0.3,0.09,0.09,0,0.64000000000000012,0.25,3.24,16,0.09,0.09,0.09]
[-0.5,0.25,0.25,0.64000000000000012,0,1.6900000000000002,6.7600000000000007,23.04,0.25,0.25,0.25]
[0.8,0.64000000000000012,0.64000000000000012,0.25,1.6900000000000002,0,1.6900000000000002,12.25,0.64000000000000012,0.64000000000000012,0.64000000000000012]
[2.1,4.41,4.41,3.24,6.7600000000000007,1.6900000000000002,0,4.839999999999999,4.41,4.41,4.41]
[4.3,18.489999999999998,18.489999999999998,16,23.04,12.25,4.839999999999999,0,18.489999999999998,18.489999999999998,18.489999999999998]
[null,0,0,0.09,0.25,0.64000000000000012,4.41,18.489999999999998,0,0,0]
[null,0,0,0.09,0.25,0.64000000000000012,4.41,18.489999999999998,0,0,0]
[null,0,0,0.09,0.25,0.64000000000000012,4.41,18.489999999999998,0,0,0]
[]
["h",1,2,3,4,5,6,7,8,9,10]
[1,{"$f":"SQRT(B30+B42+B54)","v":0},{"$f":"SQRT(C30+C42+C54)","v":0.52068331172711035},1.4134276698076127,2.3932776223785188,3.2513245164257465,2.3715911208394345,4.8329884934456215,0.33333333333333331,0.33333333333333331,0.33333333333333331]
[2,{"$f":"SQRT(B31+B43+B55)","v":0.52068331172711035},0,0.95800719087999431,1.9672315572906001,2.8256759270030321,2.5944384963053397,5.0497524691810387,0.4,0.4,0.4]
[3,1.4134276698076127,0.95800719087999431,0,1.2810585900383755,1.8708286933869707,3.0265491900843116,5.3526732677337137,1.3408123574079178,1.3408123574079178,1.3408123574079178]
[4,2.3932776223785188,1.9672315572906001,1.2810585900383755,0,1.5322459912748274,4.295863643604676,6.6068146636635721,2.3558437978779492,2.3558437978779492,2.3558437978779492]
[5,3.2513245164257465,2.8256759270030321,1.8708286933869707,1.5322459912748274,0,4.4249293779675174,6.3935731619946123,3.210053651334265,3.210053651334265,3.210053651334265]
[6,2.3715911208394345,2.5944384963053397,3.0265491900843116,4.295863643604676,4.4249293779675174,0,2.4707173946941894,2.385604978011052,2.385604978011052,2.385604978011052]
[7,4.8329884934456215,5.0497524691810387,5.3526732677337137,6.6068146636635721,6.3935731619946123,2.4707173946941894,0,4.8559242168715935,4.8559242168715935,4.8559242168715935]
[8,0.33333333333333331,0.4,1.3408123574079178,2.3558437978779492,3.210053651334265,2.385604978011052,4.8559242168715935,0,0,0]
[9,0.33333333333333331,0.4,1.3408123574079178,2.3558437978779492,3.210053651334265,2.385604978011052,4.8559242168715935,0,0,0]
[10,0.33333333333333331,0.4,1.3408123574079178,2.3558437978779492,3.210053651334265,2.385604978011052,4.8559242168715935,0,0,0]
[]
[]
[0,1,1,1,1,1,1,1,1,1,1]
[1,{"$f":"$B$4*(B66=0)+$B$5*EXP(-3*B66^2)","v":15},{"$f":"$B$4*(C66=0)+$B$5*EXP(-3*C66^2)","v":4.4337767469214846},2.4953323971709691E-2,3.4464592876853555E-7,1.6868417078146224E-13,4.6989891476642879E-7,3.6943497190557232E-30,7.1653131057378925,7.1653131057378925,7.1653131057378925]
[1,{"$f":"$B$4*(B67=0)+$B$5*EXP(-3*B67^2)","v":4.4337767469214846},15,0.63715123096515225,9.0748836394022447E-5,3.9554828890260091E-10,1.6988176406959633E-8,5.9768469426774846E-33,6.1878339180614086,6.1878339180614086,6.1878339180614086]
[1,{"$f":"$B$4*(B68=0)+$B$5*EXP(-3*B68^2)","v":2.4953323971709691E-2},0.63715123096515225,15,7.2748409163407149E-2,2.7536449349747157E-4,1.1630212160954312E-11,4.6875037928633756E-37,4.5467920741087416E-2,4.5467920741087416E-2,4.5467920741087416E-2]
[1,{"$f":"$B$4*(B69=0)+$B$5*EXP(-3*B69^2)","v":3.4464592876853555E-7},9.0748836394022447E-5,7.2748409163407149E-2,15,8.732110023501518E-3,9.0366993494153925E-24,1.3462868220190729E-56,5.8748512699252359E-7,5.8748512699252359E-7,5.8748512699252359E-7,"Matrice K augmentée"]
[1,{"$f":"$B$4*(B70=0)+$B$5*EXP(-3*B70^2)","v":1.6868417078146224E-13},3.9554828890260091E-10,2.7536449349747157E-4,8.732110023501518E-3,15,3.0870391197156267E-25,5.508331081942854E-53,3.7541352606295897E-13,3.7541352606295897E-13,3.7541352606295897E-13]
[1,{"$f":"$B$4*(B71=0)+$B$5*EXP(-3*B71^2)","v":4.6989891476642879E-7},1.6988176406959633E-8,1.1630212160954312E-11,9.0366993494153925E-24,3.0870391197156267E-25,15,1.1133209668277199E-7,3.8472069235724492E-7,3.8472069235724492E-7,3.8472069235724492E-7]
[1,{"$f":"$B$4*(B72=0)+$B$5*EXP(-3*B72^2)","v":3.6943497190557232E-30},5.9768469426774846E-33,4.6875037928633756E-37,1.3462868220190729E-56,5.508331081942854E-53,1.1133209668277199E-7,15,1.8967423894564462E-30,1.8967423894564462E-30,1.8967423894564462E-30]
[1,{"$f":"$B$4*(B73=0)+$B$5*EXP(-3*B73^2)","v":7.1653131057378925},6.1878339180614086,4.5467920741087416E-2,5.8748512699252359E-7,3.7541352606295897E-13,3.8472069235724492E-7,1.8967423894564462E-30,15,15,15]
[1,{"$f":"$B$4*(B74=0)+$B$5*EXP(-3*B74^2)","v":7.1653131057378925},6.1878339180614086,4.5467920741087416E-2,5.8748512699252359E-7,3.7541352606295897E-13,3.8472069235724492E-7,1.8967423894564462E-30,15,15,15]
[1,{"$f":"$B$4*(B75=0)+$B$5*EXP(-3*B75^2)","v":7.1653131057378925},6.1878339180614086,4.5467920741087416E-2,5.8748512699252359E-7,3.7541352606295897E-13,3.8472069235724492E-7,1.8967423894564462E-30,15,15,15]
[]
["Kinv"]
[{"$f":"MINVERSE(A78:OFFSET(A78,$B$14,$B$14))","v":-2.3191134099446509},0.1211112794900817,0.11248402533482962,0.14887940433169244,0.15379487840071834,0.15451529733327499,0.15460755559394523,0.15460755951545768]
[0.12111127949008164,6.6733707218188859E-2,-2.7503135680380087E-2,-6.9777378215581057E-3,-8.0353816966468247E-3,-8.069279481394475E-3,-8.0740872987976088E-3,-8.0740852394117612E-3]
[0.11248402533482962,-2.7503135680380084E-2,6.7734553321978919E-2,-1.0294080334647286E-2,-7.4450561793182645E-3,-7.494411979180729E-3,-7.4989341817887122E-3,-7.4989349666638319E-3]
[0.14887940433169242,-6.977737821558104E-3,-1.029408033464729E-2,5.7239876749965925E-2,-1.0197063441911789E-2,-9.9204082851598128E-3,-9.9252933182430222E-3,-9.925293548445905E-3]
[0.15379487840071832,-8.0353816966468299E-3,-7.4450561793182645E-3,-1.0197063441911789E-2,5.6469162387444427E-2,-1.0285677695164291E-2,-1.0252991557121173E-2,-1.0252991817282077E-2,null,null,null,"Inverse de K augmentée"]
[0.15451529733327499,-8.0692794813944733E-3,-7.4944119791807316E-3,-9.920408285159811E-3,-1.0285677695164291E-2,5.6371816671146262E-2,-1.0301019484484229E-2,-1.0301019745762733E-2]
[0.15460755559394521,-8.0740872987976088E-3,-7.4989341817887131E-3,-9.9252933182430222E-3,-1.0252991557121172E-2,-1.030101948448423E-2,5.635949663167248E-2,-1.0307170791237736E-2]
[0.15460755951545782,-8.0740852394117716E-3,-7.4989349666638398E-3,-9.9252935484459154E-3,-1.0252991817282085E-2,-1.0301019745762727E-2,-1.0307170791237743E-2,5.6359496108804079E-2]