{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Solutions à doser","Préparation solutions "],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Solutions à doser","index":0,"n_rows":139,"n_cols":33,"rows_kept":139,"cut":false,"hidden":false,"merged":[]}
["Absorbance d'une solution "]
[]
[]
[]
["1- Solution à doser","Solution 1"]
[null,{"$f":"HLOOKUP($B$5,L$42:V$139,10)","v":158.0249}]
[null,null,null,null,null,null,null,"l / nm",525,null,null,"Absorbance",{"$f":"INT(1000*(VLOOKUP(I7,A52:D139,4)+(RAND()-0.5)*$G$31))/1000","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"mesurée à \"&I7&\"nm\"","v":"mesurée à 525nm"}]
["2- Dilution de la solution à doser",null,null,null,"3- Spectre de la solution fille"]
["V pipette / mL",25]
["V fiole / mL",25]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"bruit",0.01,"Ip",0.01,null,"e / L.mol‑1.cm-1",{"$f":"LOOKUP(I7,A52:A139,B52:B139)","v":2.0015716713209133}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KMnO4","Bleu patenté","Bleu patenté","Bleu patenté","Cu2+","Cu2+","Ni2+","Cu2+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.8299999999999999E-2,3.7200000000000003E-5,7.2000000000000002E-5,1.47E-4,0.48599999999999999,0.41299999999999998,0.48599999999999999,0.73229999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jaune de quinoléïne","Curcumine","Jaune de quinoléïne","Co2+","Ni2+","Co2+",null,"Ni2+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2799999999999999E-4,8.7500000000000002E-4,7.85E-4,0.32700000000000001,0.92300000000000004,0.35799999999999998,null,1.5549999999999999]
[]
["Solution étudiée"]
[null,null,null,null,null,null,null,null,null,null,null,"Bleu patenté","Jaune de quinoléïne","Nitrate de cobalt","Nitrate de cuivre trihydraté","Nitrate de nickel hexahydraté","Permanganate de potassium","Tartrazine",null,null,null,null,null,null,"Solution 1","Solution 2","Solution 3","Solution 4","Solution 5","Solution 6","Solution 7","Solution 8","Solution 9"]
["H",1,null,null,null,null,null,null,null,null,"H",0.62,{"$f":"37/255","v":0.14509803921568629},{"$f":"242/255","v":0.94901960784313721},0.62,{"$f":"125/255","v":0.49019607843137253},0.792156862745098,{"$f":"40/255","v":0.15686274509803921},null,null,null,null,null,null,0.792156862745098,{"$f":"108/255","v":0.42352941176470588},{"$f":"108/255","v":0.42352941176470588},{"$f":"108/255","v":0.42352941176470588}]
["S",1,null,null,null,null,null,null,null,null,"S",1,1,{"$f":"159/255","v":0.62352941176470589},1,{"$f":"197/255","v":0.77254901960784317},0.65098039215686276,1,null,null,null,null,null,null,0.65098039215686276,{"$f":"252/255","v":0.9882352941176471},{"$f":"252/255","v":0.9882352941176471},{"$f":"252/255","v":0.9882352941176471}]
["L",1,null,null,null,null,null,null,null,null,"L",{"$f":"1-L47","v":1},{"$f":"1-M47","v":1},{"$f":"1-N47","v":1},1,1,1,1,null,null,null,null,null,null,{"$f":"1-G47","v":1},{"$f":"1-Z47","v":1},{"$f":"1-AA47","v":1},{"$f":"1-AB47","v":{"$error":"#DIV/0!"}}]
["Concentration à 0,5 de Luminosité",1,null,null,null,null,null,null,null,null,"Concentration à 0,5 de Luminosité",1.0000000000000001E-5,6.0000000000000002E-5,0.3,0.6,0.3,6.9999999999999999E-4,6.0000000000000002E-5,null,null,null,null,null,null,9.9999999999999995E-8,6.9999999999999999E-4,6.9999999999999999E-4,6.9999999999999999E-4]
[null,1,null,null,null,null,null,null,null,null,null,{"$f":"1-EXP(-(LN(2)/L46*$E$15))","v":0},0,0,0,0,0,0,null,null,null,null,null,null,{"$f":"1-EXP(-(LN(2)/Y46*$U$31))","v":0},{"$f":"1-EXP(-(LN(2)/Z46*$U$31*B10/B11))","v":0},{"$f":"1-EXP(-(LN(2)/AA46*$U$31*B10/B11))","v":0},{"$f":"1-EXP(-(LN(2)/AB46*$U$31*C10/C11))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,84,220,1330,1380,940,64,38]
[]
[null,{"$f":"(RAND()-0.5)*$G$31","v":-2.7497024617293133E-3}]
["l / nm","Absorbance","Abs théo","Signal vrai",null,null,"coeff",1.4,null,null,null,582.66730600000005,477.375,182.94300000000001,241.6,182.703,{"$f":"39.0893+54.938+15.9994*4","v":158.0249},534.36300000000006]
[400,{"$f":"D52+$B$50","v":0.5518712803838165},{"$f":"$B$10/$B$11*HLOOKUP($B$5,Y$42:AR$139,ROW()-42+1)","v":0.56599999999999995},{"$f":"-LOG(($I$31+10^(-C52))/($I$31+1))","v":0.55462098284554584},null,null,null,null,null,null,400,10501.56191046512,22436.625,8.9999999999999993E-3,0,4.5259999999999998,20,20156.283108808289,null,null,null,null,null,null,{"$f":"Q52*$Y$37","v":0.56599999999999995},{"$f":"L52*$Z$37+M52*$Z$39","v":3.2625461030693024},{"$f":"L52*$AA$37+M52*$AA$39","v":20.388159332553489},{"$f":"L52*$AB$37+R52*$AB$39","v":17.36641184125288},{"$f":"O52*$AC$37+N52*$AC$39","v":2.9429999999999999E-3},{"$f":"O52*$AD$37+P52*$AD$39","v":4.1774979999999999},{"$f":"P52*$AE$37+N52*$AE$39","v":2.202858},{"$f":"O52*AF$37","v":0},{"$f":"P52*AG$39","v":7.0379299999999994}]
[{"$f":"A52+5","v":405},{"$f":"D53+$B$50","v":0.60633010460523129},{"$f":"$B$10/$B$11*HLOOKUP($B$5,Y$42:AR$139,ROW()-42+1)","v":0.62259999999999993},{"$f":"-LOG(($I$31+10^(-C53))/($I$31+1))","v":0.60907980706696063},null,null,{"$f":"I7","v":525},{"$f":"M7+0.08*H51","v":2.1120000000000001},null,null,{"$f":"K52+5","v":405},11788.850144651165,24584.812500000004,1.7999999999999999E-2,0,3.9940000000000002,22,21097.647979274614,null,null,null,null,null,null,{"$f":"Q53*$Y$37","v":0.62259999999999993},{"$f":"L53*$Z$37+M53*$Z$39","v":3.5854012253810241},{"$f":"L53*$AA$37+M53*$AA$39","v":22.360508147914885},{"$f":"L53*$AB$37+R53*$AB$39","v":18.294614634994293},{"$f":"O53*$AC$37+N53*$AC$39","v":5.8859999999999997E-3},{"$f":"O53*$AD$37+P53*$AD$39","v":3.6864620000000006},{"$f":"P53*$AE$37+N53*$AE$39","v":1.9475279999999999},{"$f":"O53*AF$37","v":0},{"$f":"P53*AG$39","v":6.2106700000000004}]
[410,0.66050367111116459,0.67920000000000003,0.66325337357289393,null,null,{"$f":"G53","v":525},{"$f":"M7-0.08*H51","v":1.8879999999999999},null,null,410,12263.114230930236,25406.958333333336,3.5999999999999997E-2,0,3.4289999999999998,24,21872.889637305703,null,null,null,null,null,null,0.67920000000000003,{"$f":"L54*$Z$37+M54*$Z$39","v":3.7082785160572715},23.114032766293647,18.972896157231723,1.1771999999999999E-2,3.1649669999999999,1.6793819999999999,0,5.3320949999999998]
[415,0.7678466694005569,0.79239999999999999,0.77059637186228624,null,null,null,null,null,null,415,10772.569959767445,24796.979166666672,6.9000000000000006E-2,0,2.863,28,22482.008082901553,null,null,null,null,null,null,0.79239999999999999,3.574752935836683,22.472981807936595,19.231944129163534,2.2563000000000003E-2,2.6425490000000003,1.41612,0,4.4519649999999995]
[420,0.82093155071000123,0.84899999999999998,0.82368125317173058,null,null,{"$f":"I7-10","v":515},{"$f":"M7","v":2},null,null,420,8130.2414790697694,23497.458333333336,0.128,0,2.3260000000000001,30,22869.628911917098,null,null,null,null,null,null,0.84899999999999998,3.3101196496880623,21.14565342815969,19.147804193278176,4.1856000000000004E-2,2.1468980000000002,1.1762600000000001,0,3.61693]
[425,1.0281572110317554,1.0753999999999999,1.0309069134934847,null,null,{"$f":"I7+10","v":535},{"$f":"M7","v":2},null,null,425,5352.4089737209315,22569.229166666668,0.22700000000000001,0,1.839,38,23035.752124352333,null,null,null,null,null,null,1.0753999999999999,3.0879709471557519,20.133448966941241,18.869869536753558,7.4229000000000003E-2,1.697397,0.97502,0,2.859645]
[430,1.4034964961137322,1.5282,1.4062461985754615,null,null,null,null,null,null,430,3319.8486039534891,21614.479166666668,0.38100000000000001,0,1.4179999999999999,54,22869.628911917098,null,null,null,null,null,null,1.5282,2.890151701400403,19.151698370317984,18.440676440636086,0.124587,1.3088139999999999,0.825546,0,2.20499]
[435,1.7694290128886054,2.1507999999999998,1.7721787153503348,null,null,null,null,null,null,435,2032.5603697674424,19545.854166666668,0.60399999999999998,0,1.07,76,22426.63367875648,null,null,null,null,null,null,2.1507999999999998,2.5774805790886823,17.248966742456592,17.90369381217965,0.19750799999999999,0.9876100000000001,0.73625200000000002,0,1.6638500000000001]
[440,1.9485557028013183,2.8865999999999996,1.9513054052630476,null,null,null,null,null,null,440,1355.0402465116283,15753.375,0.90400000000000003,0,0.79700000000000004,101.99999999999999,21706.766424870468,null,null,null,null,null,null,2.8865999999999996,2.0668394971702324,13.881766022748836,17.239002559760529,0.29560800000000004,0.73563100000000003,0.71097399999999999,0,1.2393350000000001]
[445,1.9968572869665511,3.9619999999999997,1.9996069894282804,null,null,null,null,null,null,445,948.52817255813966,11112.229166666668,1.28,0,0.59599999999999997,140,20599.278341968911,null,null,null,null,null,null,3.9619999999999997,1.4576505813524963,9.7914945492575196,16.309867139811644,0.41856000000000004,0.55010800000000004,0.74789599999999989,0,0.92677999999999994]
[450,2.001411677094191,5.4336000000000002,2.0041613795559203,null,null,null,null,null,null,450,813.02414790697696,6895.416666666667,1.7130000000000001,0,0.46100000000000002,192,19048.795025906737,null,null,null,null,null,null,5.4336000000000002,0.91285783163547296,6.092027321982636,15.072818645079114,0.56015100000000007,0.42550300000000002,0.83729999999999993,0,0.71685500000000002]
[455,2.0015684637024287,7.1315999999999997,2.004318166164158,null,null,null,null,null,null,455,677.52012325581416,3951.604166666667,2.173,1E-3,0.379,252,17110.690880829017,null,null,null,null,null,null,7.1315999999999997,0.53100908191844964,3.5064350947077521,13.531487799569383,0.71105700000000005,0.35023000000000004,0.96212799999999998,7.3229999999999996E-4,0.58934500000000001]
[460,2.0015713213885284,8.0937999999999981,2.0043210238502578,null,null,null,null,null,null,460,609.76811093023275,2148.1875,2.6230000000000002,1E-3,0.33300000000000002,285.99999999999994,15061.837927461138,null,null,null,null,null,null,8.0937999999999981,0.29765137372660466,1.9235673664869768,11.913178685363736,0.85820700000000005,0.30777200000000005,1.1008720000000001,7.3229999999999996E-4,0.51781500000000003]
[465,2.0015716712827203,12.0558,2.0043213737444496,null,null,null,null,null,null,465,609.76811093023264,1166.9166666666667,3.0350000000000001,2E-3,0.30399999999999999,426,13123.73378238342,null,null,null,null,null,null,12.0558,0.17204870705993799,1.0649553873203101,10.391766931477729,0.99341700000000011,0.281418,1.2342740000000001,1.4645999999999999E-3,0.47271999999999997]
[470,2.0015716713208751,15.0556,2.0043213737826044,null,null,null,null,null,null,470,677.52012325581416,663.02083333333337,3.3929999999999998,2E-3,0.27800000000000002,532,11130.255233160622,null,null,null,null,null,null,15.0556,0.11007041525178296,0.62892467804108532,8.8368458161496939,1.1104829999999999,0.25742000000000004,1.3498019999999999,1.4645999999999999E-3,0.43229000000000001]
[475,2.0015716713209133,18.3384,2.0043213737826426,null,null,null,null,null,null,475,745.27213558139545,397.8125,3.706,3.0000000000000001E-3,0.245,648,9026.0278756476673,null,null,null,null,null,null,18.3384,7.8644123443627909E-2,0.40174553126186047,7.1949868863138837,1.21332,0.22737399999999999,1.445818,2.1968999999999999E-3,0.38097499999999995]
[480,2.0015716713209133,23.092799999999997,2.0043213737826426,null,null,null,null,null,null,480,880.77616023255825,238.68750000000006,4.0010000000000003,4.0000000000000001E-3,0.20399999999999999,815.99999999999989,6811.0517098445607,null,null,null,null,null,null,23.092799999999997,6.3316873160651183E-2,0.27226744603674424,5.4761496877821658,1.3102710000000002,0.18994399999999997,1.5315019999999999,2.9291999999999999E-3,0.31721999999999995]
[485,2.0015716713209133,28.130199999999999,2.0043213737826426,null,null,null,null,null,null,485,948.52817255813966,159.12500000000003,4.3040000000000003,5.0000000000000001E-3,0.159,994,4706.8243523316069,null,null,null,null,null,null,28.130199999999999,5.5653248019162806E-2,0.20752840342418608,3.8342907579463579,1.4098380000000001,0.14882200000000001,1.618106,3.6614999999999998E-3,0.24724499999999999]
[490,2.0015716713209133,31.865799999999993,2.0043213737826426,null,null,null,null,null,null,490,1151.7842095348838,106.08333333333334,4.6269999999999998,7.0000000000000001E-3,0.11700000000000001,1125.9999999999998,2934.8434196891194,null,null,null,null,null,null,31.865799999999993,5.642503926136435E-2,0.17575137975317831,2.4731643632575864,1.5164309999999999,0.11088200000000002,1.7133279999999997,5.1260999999999998E-3,0.18193500000000001]
[495,2.0015716713209133,36.563600000000001,2.0043213737826426,null,null,null,null,null,null,495,1355.0402465116283,79.562499999999986,4.9480000000000004,8.9999999999999993E-3,8.5999999999999993E-2,1292,1661.2321243523315,null,null,null,null,null,null,36.563600000000001,6.0591497170232579E-2,0.16718008524883721,1.5032581338537896,1.6223700000000003,8.3095000000000002E-2,1.81318,6.5906999999999988E-3,0.13372999999999999]
[500,2.0015716713209133,43.808399999999999,2.0043213737826426,null,null,null,null,null,null,500,1626.0482958139539,53.041666666666671,5.2169999999999996,1.0999999999999999E-2,6.5000000000000002E-2,1548,885.99046632124362,null,null,null,null,null,null,43.808399999999999,6.7278329937612416E-2,0.163486935631938,0.93453161554682751,1.7113050000000001,6.4538000000000012E-2,1.8992759999999997,8.0552999999999996E-3,0.101075]
[505,2.0015716713209133,49.015599999999999,2.0043213737826426,null,null,null,null,null,null,505,1964.8083574418611,26.520833333333314,5.3609999999999998,1.4E-2,5.3999999999999999E-2,1732,387.62082901554413,null,null,null,null,null,null,49.015599999999999,7.6485537563503903E-2,0.16467193090248067,0.59310917932115581,1.7598510000000001,5.5624000000000007E-2,1.9454819999999997,1.02522E-2,8.3969999999999989E-2]
[510,2.0015716713209133,50.656999999999996,2.0043213737826426,null,null,null,null,null,null,510,2371.3204313953497,0,5.319,1.7999999999999999E-2,4.9000000000000002E-2,1790,110.74880829015545,null,null,null,null,null,null,50.656999999999996,8.8213120047907018E-2,0.17073507106046518,0.43552191792288847,1.7480610000000001,5.2660999999999999E-2,1.928016,1.3181399999999998E-2,7.6194999999999999E-2]
[515,2.0015716713209133,54.392599999999995,2.0043213737826426,null,null,null,null,null,null,515,2845.5845176744197,0,5.0579999999999998,2.1999999999999999E-2,4.9000000000000002E-2,1922,0,null,null,null,null,null,null,54.392599999999995,0.10585574405748842,0.20488208527255822,0.41830092409813968,1.664658,5.4313E-2,1.8345779999999998,1.6110599999999999E-2,7.6194999999999999E-2]
[520,2.0015716713209133,61.071399999999997,2.0043213737826426,null,null,null,null,null,null,520,3523.1046409302339,0,4.59,2.8000000000000001E-2,5.0999999999999997E-2,2158,0,null,null,null,null,null,null,61.071399999999997,0.13105949264260472,0.25366353414697684,0.51789638221674439,1.5145380000000002,5.8636999999999995E-2,1.6680059999999999,2.0504399999999999E-2,7.9304999999999987E-2]
[525,2.0015716713209133,63.731599999999986,2.0043213737826426,null,null,null,null,null,null,525,4403.8808011627916,0,3.9689999999999999,3.5000000000000003E-2,5.3999999999999999E-2,2251.9999999999995,0,null,null,null,null,null,null,63.731599999999986,0.16382436580325585,0.317079417683721,0.64737047777093037,1.314873,6.4297000000000007E-2,1.4471459999999998,2.5630500000000001E-2,8.3969999999999989E-2]
[530,2.0015716713209133,59.939399999999999,2.0043213737826426,null,null,null,null,null,null,530,5487.9129983720941,0,3.2759999999999998,4.2999999999999997E-2,5.6000000000000001E-2,2118,0,null,null,null,null,null,null,59.939399999999999,0.20415036353944191,0.39512973588279077,0.80672321076069775,1.09215,6.9447000000000009E-2,1.2000239999999998,3.1488899999999993E-2,8.7080000000000005E-2]
[535,2.0015716713209133,58.354599999999998,2.0043213737826426,null,null,null,null,null,null,535,6639.6972079069774,0,2.5939999999999999,5.2999999999999999E-2,5.8999999999999997E-2,2062,0,null,null,null,null,null,null,58.354599999999998,0.24699673613413958,0.47805819896930241,0.97603548956232566,0.87399599999999988,7.6345999999999997E-2,0.9573259999999999,3.8811899999999996E-2,9.1744999999999993E-2]
[540,2.0015716713209133,61.014799999999994,2.0043213737826426,null,null,null,null,null,null,540,7994.7374544186059,0,1.9910000000000001,6.5000000000000002E-2,6.2E-2,2156,0,null,null,null,null,null,null,61.014799999999994,0.29740423330437216,0.57562109671813966,1.175226405799535,0.68264700000000011,8.4071000000000007E-2,0.74291000000000007,4.7599499999999996E-2,9.6409999999999996E-2]
[545,2.0015716713209133,60.448799999999999,2.0043213737826426,null,null,null,null,null,null,545,9553.0337379069788,0,1.5029999999999999,0.08,6.5000000000000002E-2,2136,0,null,null,null,null,null,null,60.448799999999999,0.35537285505013966,0.68781842912930247,1.4042959594723259,0.53036099999999997,9.3035000000000007E-2,0.56966399999999995,5.8583999999999997E-2,0.101075]
[550,2.0015716713209133,52.071999999999996,2.0043213737826426,null,null,null,null,null,null,550,11314.586058372095,0,1.143,9.8000000000000004E-2,6.9000000000000006E-2,1840,0,null,null,null,null,null,null,52.071999999999996,0.42090260137144198,0.81465019620279089,1.6632441505806979,0.42138900000000001,0.104161,0.44272800000000001,7.1765399999999993E-2,0.107295]
[555,2.0015716713209133,42.732999999999997,2.0043213737826426,null,null,null,null,null,null,555,13414.89844046512,0,0.89600000000000002,0.11899999999999999,7.3999999999999996E-2,1510,0,null,null,null,null,null,null,42.732999999999997,0.49903422198530251,0.96587268771348866,1.9719900707483726,0.35082600000000003,0.117449,0.35673199999999999,8.7143699999999991E-2,0.11506999999999999]
[560,2.0015716713209133,37.921999999999997,2.0043213737826426,null,null,null,null,null,null,560,15989.474908837212,0,0.73899999999999999,0.14399999999999999,8.1000000000000003E-2,1340,0,null,null,null,null,null,null,37.921999999999997,0.59480846660874431,1.1512421934362793,2.3504528115990699,0.311637,0.13423499999999999,0.30392799999999998,0.10545119999999998,0.12595500000000001]
[565,2.0015716713209133,35.714599999999997,2.0043213737826426,null,null,null,null,null,null,565,19038.315463488376,0,0.64500000000000002,0.17299999999999999,9.0999999999999998E-2,1262,0,null,null,null,null,null,null,35.714599999999997,0.70822533524176767,1.3707587133711632,2.7986323731327913,0.29499300000000001,0.15544199999999997,0.27513599999999999,0.12668789999999999,0.14150499999999999]
[570,2.0015716713209133,31.4696,2.0043213737826426,null,null,null,null,null,null,570,22967.932178372095,0,0.59099999999999997,0.20699999999999999,0.106,1112,0,null,null,null,null,null,null,31.4696,0.85440707703544205,1.6536911168427908,3.3762860302206978,0.29385899999999998,0.18332900000000002,0.26309399999999999,0.15158609999999997,0.16482999999999998]
[575,2.0015716713209133,23.205999999999996,2.0043213737826426,null,null,null,null,null,null,575,27439.564991860472,0,0.55900000000000005,0.248,0.127,819.99999999999989,0,null,null,null,null,null,null,23.205999999999996,1.0207518176972097,1.9756486794139541,4.0336160538034891,0.30332100000000001,0.21964499999999998,0.26184400000000002,0.18161039999999998,0.19748499999999999]
[580,2.001571671320884,15.168799999999999,2.0043213737826133,null,null,null,null,null,null,580,32249.957866976751,0,0.53700000000000003,0.29499999999999998,0.158,536,0,null,null,null,null,null,null,15.168799999999999,1.1996984326515352,2.3219969664223261,4.7407438064455825,0.318969,0.26766899999999999,0.269034,0.21602849999999998,0.24568999999999999]
[585,2.0015716681118052,10.131399999999999,2.0043213705735345,null,null,null,null,null,null,585,36450.582631162804,0,0.51800000000000002,0.35,0.19900000000000001,358,0,null,null,null,null,null,null,10.131399999999999,1.3559616738792564,2.6244419494437219,5.3582356467809324,0.33948599999999995,0.32822699999999999,0.28215800000000002,0.25630499999999995,0.30944500000000003]
[590,2.0015706786990992,7.641,2.0043203811608286,null,null,null,null,null,null,590,40109.191296744197,0,0.499,0.41299999999999998,0.255,270,0,null,null,null,null,null,null,7.641,1.4920619162388842,2.8878617733655823,5.8960511206213964,0.36389099999999996,0.40593400000000002,0.30257200000000001,0.30243989999999998,0.39652500000000002]
[595,2.0015582196081421,6.5089999999999995,2.0043079220698714,null,null,null,null,null,null,595,43496.791913023269,0,0.47799999999999998,0.48599999999999999,0.32600000000000001,230,0,null,null,null,null,null,null,6.5089999999999995,1.6180806591644659,3.1317690177376756,6.3940284112144203,0.39250200000000002,0.50161599999999995,0.32955999999999996,0.35589779999999999,0.50692999999999999]
[600,2.0015152613200988,5.8864000000000001,2.0042649637818282,null,null,null,null,null,null,600,47019.896553953498,0,0.45400000000000001,0.56899999999999995,0.41599999999999998,208,0,null,null,null,null,null,null,5.8864000000000001,1.7491401518070704,3.385432551884652,6.9119247934311643,0.42499199999999993,0.61896499999999999,0.36470800000000003,0.41667869999999996,0.6468799999999999]
[605,2.001411677094191,5.4336000000000002,2.0041613795559203,null,null,null,null,null,null,605,51694.785404418617,0,0.42799999999999999,0.66400000000000003,0.52400000000000002,192,0,null,null,null,null,null,null,5.4336000000000002,1.9230460170443726,3.7220245491181405,7.5991334544495368,0.46265999999999996,0.757884,0.40788800000000003,0.48624719999999999,0.81481999999999999]
[610,2.0011733943846997,5.0373999999999999,2.003923096846429,null,null,null,null,null,null,610,58198.978587674435,0,0.4,0.77200000000000002,0.65,178,0,null,null,null,null,null,null,5.0373999999999999,2.1650020034614892,4.1903264583125592,8.5552498523881422,0.505992,0.9187860000000001,0.45910000000000001,0.56533559999999994,1.01075]
[615,2.0009010938177858,4.8109999999999999,2.0036507962795151,null,null,null,null,null,null,615,66938.98817767443,0,0.371,0.89400000000000002,0.79200000000000004,170,0,null,null,null,null,null,null,4.8109999999999999,2.4901303602094891,4.8196071487925591,9.8400312621181403,0.55580099999999999,1.100238,0.51773000000000002,0.65467619999999993,1.23156]
[620,2.0002859664173878,4.5279999999999996,2.0030356688791171,null,null,null,null,null,null,620,77711.558137441883,0,0.34100000000000003,1.0309999999999999,0.94599999999999995,160,0,null,null,null,null,null,null,4.5279999999999996,2.8908699627128382,5.5952321858958154,11.423599046203957,0.61257299999999992,1.2989609999999998,0.58183399999999996,0.75500129999999988,1.4710299999999998]
[625,1.9996721935029917,4.3582000000000001,2.0024218959647211,null,null,null,null,null,null,625,89093.896208139558,0,0.311,1.1839999999999999,1.1080000000000001,154,0,null,null,null,null,null,null,4.3582000000000001,3.314292938942792,6.4147605269860479,13.096802742596514,0.67712099999999997,1.511676,0.64982600000000001,0.8670431999999999,1.7229400000000001]
[630,1.9983772945143592,4.1318000000000001,2.0011269969760885,null,null,null,null,null,null,630,98511.425921395392,0,0.28100000000000003,1.355,1.2709999999999999,146,0,null,null,null,null,null,null,4.1318000000000001,3.6646250442759087,7.0928226663404681,14.481179610445123,0.750417,1.732748,0.71830399999999994,0.99226649999999994,1.9764049999999997]
[635,1.9968572869665511,3.9619999999999997,1.9996069894282804,null,null,null,null,null,null,635,102305.53861162794,0,0.252,1.5449999999999999,1.429,140,0,null,null,null,null,null,null,3.9619999999999997,3.8057660363525598,7.365998780037212,15.038914175909307,0.83327399999999996,1.957052,0.78471000000000002,1.1314034999999998,2.2220949999999999]
[640,1.9925709733247055,3.6789999999999998,1.9953206757864348,null,null,null,null,null,null,640,97969.409822790738,0,0.224,1.754,1.575,130,0,null,null,null,null,null,null,3.6789999999999998,3.6444620454078156,7.0537975072409331,14.401503243950238,0.92569199999999996,2.1781269999999999,0.845642,1.2844541999999999,2.449125]
[645,1.986518228091289,3.4525999999999999,1.9892679305530183,null,null,null,null,null,null,645,86112.807665813991,0,0.19700000000000001,1.984,1.704,122,0,null,null,null,null,null,null,3.4525999999999999,3.2033964451682806,6.2001221519386078,12.658582726874656,1.028643,2.3921839999999999,0.89866999999999997,1.4528831999999998,2.6497199999999999]
[650,1.9731343891404418,3.1696,1.9758840916021712,null,null,null,null,null,null,650,70326.588793953502,0,0.17199999999999999,2.2349999999999999,1.8140000000000001,112,0,null,null,null,null,null,null,3.1696,2.6161491031350703,5.0635143931646525,10.338008552711164,1.1424539999999999,2.5973769999999998,0.94318000000000002,1.6366904999999998,2.82077]
[655,1.9546972091700898,2.9432,1.9574469116318192,null,null,null,null,null,null,655,54066.105835813971,0,0.14899999999999999,2.508,1.903,104,0,null,null,null,null,null,null,2.9432,2.0112591370922797,3.8927596201786061,7.9477175578646531,1.267611,2.7922729999999998,0.97819999999999996,1.8366083999999998,2.959165]
[660,1.8799147525293065,2.4903999999999997,1.8826644549910359,null,null,null,null,null,null,660,36857.094705116288,0,0.128,2.8039999999999998,1.972,88,0,null,null,null,null,null,null,2.4903999999999997,1.371083923030326,2.6537108187683729,5.4179929216520941,1.4045999999999998,2.978208,1.004216,2.0533691999999997,3.0664599999999997]
[665,1.7919769212031842,2.2073999999999998,1.7947266236649135,null,null,null,null,null,null,665,25813.516696046518,0,0.109,3.121,2.0259999999999998,78,0,null,null,null,null,null,null,2.2073999999999998,0.96026282109293049,1.8585732021153494,3.794586954318838,1.552449,3.1589709999999998,1.0236579999999997,2.2855083,3.1504299999999996]
[670,1.6610987356119726,1.9243999999999999,1.663848438073702,null,null,null,null,null,null,670,17547.771192325585,0,9.0999999999999998E-2,3.4620000000000002,2.0680000000000001,68,0,null,null,null,null,null,null,1.9243999999999999,0.65277708835451176,1.2634395258474422,2.5795223652718611,1.7122890000000002,3.3385699999999998,1.0376259999999999,2.5352226,3.2157399999999998]
[675,1.4852353572315042,1.6414,1.4879850596932336,null,null,null,null,null,null,675,11788.850144651165,0,7.5999999999999998E-2,3.8250000000000002,2.105,58,0,null,null,null,null,null,null,1.6414,0.43854522538102342,0.84879721041488398,1.7329609712637213,1.8838020000000002,3.52264,1.0502379999999998,2.8010475000000001,3.2732749999999999]
[680,1.3161956264443493,1.415,1.3189453289060786,null,null,null,null,null,null,680,7723.7294051162808,0,6.3E-2,4.2089999999999996,2.1389999999999998,50,0,null,null,null,null,null,null,1.415,0.28732273387032564,0.55610851716837217,1.1353882225520933,2.0661749999999999,3.7126139999999994,1.0621079999999998,3.0822506999999995,3.3261449999999995]
[685,1.1278216787360957,1.1885999999999999,1.1305713811978251,null,null,null,null,null,null,685,4945.8968997674428,0,5.1999999999999998E-2,4.6139999999999999,2.1760000000000002,42,0,null,null,null,null,null,null,1.1885999999999999,0.18398736467134888,0.35610457678325591,0.72704684426581412,2.2594080000000001,3.9140300000000003,1.076152,3.3788321999999997,3.38368]
[690,0.92568258223719069,0.96219999999999994,0.92843228469892003,null,null,null,null,null,null,690,3184.3445793023266,0,4.2000000000000003E-2,5.0369999999999999,2.2149999999999999,34,0,null,null,null,null,null,null,0.96219999999999994,0.11845761835004656,0.22927280970976752,0.46809865315744198,2.461716,4.1247259999999999,1.091526,3.6885950999999997,3.4443249999999996]
[695,0.66050367111116459,0.67920000000000003,0.66325337357289393,null,null,null,null,null,null,695,2100.3123820930236,0,3.4000000000000002E-2,5.4790000000000001,2.2559999999999998,24,0,null,null,null,null,null,null,0.67920000000000003,7.8131620613860489E-2,0.15122249151069769,0.30874592016767449,2.6739120000000001,4.3451149999999998,1.1085879999999999,4.0122716999999994,3.5080799999999996]
[700,0.5518712803838165,0.56599999999999995,0.55462098284554584,null,null,null,null,null,null,700,1355.0402465116283,0,2.7E-2,5.9359999999999999,2.2959999999999998,20,0,null,null,null,null,null,null,0.56599999999999995,5.0407497170232581E-2,9.7562897748837238E-2,0.19919091623720936,2.8937249999999999,4.5707760000000004,1.1255219999999999,4.3469327999999994,3.5702799999999995]
[705,0.3870901623271143,0.3962,0.38983986478884358,null,null,null,null,null,null,705,880.77616023255825,0,2.1000000000000001E-2,6.4050000000000002,2.3290000000000002,14,0,null,null,null,null,null,null,0.3962,3.2764873160651173E-2,6.3415883536744197E-2,0.12947409555418607,3.1196970000000004,4.7949320000000002,1.1394119999999999,4.6903815,3.6215950000000001]
[710,0.27631792903722058,0.28299999999999997,0.27906763149894986,null,null,null,null,null,null,710,609.76811093023275,0,1.6E-2,6.8849999999999998,2.35,10,0,null,null,null,null,null,null,0.28299999999999997,2.2683373726604662E-2,4.3903303986976762E-2,8.9635912306744212E-2,3.3513419999999998,5.0125550000000008,1.1478280000000001,5.0418854999999994,3.6542499999999998]
[715,0.16499794297385306,0.16980000000000001,0.16774764543558238,null,null,null,null,null,null,715,406.51207395348843,0,1.2999999999999999E-2,7.3730000000000002,2.355,6,0,null,null,null,null,null,null,0.16980000000000001,1.512224915106977E-2,2.9268869324651167E-2,5.9757274871162794E-2,3.587529,5.2187140000000003,1.149184,5.3992478999999998,3.6620249999999999]
[720,5.3252156965579313E-2,5.6599999999999998E-2,{"$f":"-LOG(($I$31+10^(-C116))/($I$31+1))","v":5.6001859427308627E-2},null,null,null,null,null,null,720,271.00804930232562,0,0.01,7.8639999999999999,2.3370000000000002,2,0,null,null,null,null,null,null,5.6599999999999998E-2,1.0081499434046513E-2,1.9512579549767445E-2,3.9838183247441865E-2,3.8251740000000001,5.4048829999999999,1.139362,5.7588071999999997,3.6340350000000003]
[{"$f":"A116+5","v":725},{"$f":"D117+$B$50","v":-2.7497024617293133E-3},{"$f":"$B$10/$B$11*HLOOKUP($B$5,Y$42:AR$139,ROW()-42+1)","v":0},0,null,null,null,null,null,null,{"$f":"K116+5","v":725},203.25603697674424,0,7.0000000000000001E-3,8.3539999999999992,2.294,0,0,null,null,null,null,null,null,{"$f":"Q117*$Y$37","v":0},{"$f":"L117*$Z$37+M117*$Z$39","v":7.561124575534886E-3},{"$f":"L117*$AA$37+M117*$AA$39","v":1.4634434662325585E-2},{"$f":"L117*$AB$37+R117*$AB$39","v":2.9878637435581404E-2},{"$f":"O117*$AC$37+N117*$AC$39","v":4.0623329999999997},{"$f":"O117*$AD$37+P117*$AD$39","v":5.5675639999999991},{"$f":"P117*$AE$37+N117*$AE$39","v":1.1173899999999999},{"$f":"O117*AF$37","v":6.1176341999999986},{"$f":"P117*AG$39","v":3.56717}]
[730,-2.7497024617293133E-3,0,0,null,null,null,null,null,null,730,0,0,5.0000000000000001E-3,8.8409999999999993,2.226,0,0,null,null,null,null,null,null,0,0,0,0,4.2983609999999999,5.7059309999999996,1.083626,6.4742642999999989,3.46143]
[735,-2.7497024617293133E-3,0,0,null,null,null,null,null,null,735,0,0,4.0000000000000001E-3,9.32,2.133,0,0,null,null,null,null,null,null,0,0,0,0,4.5308279999999996,5.8179189999999998,1.03807,6.8250359999999999,3.3168150000000001]
[740,-2.7497024617293133E-3,0,0,null,null,null,null,null,null,740,0,0,3.0000000000000001E-3,9.7859999999999996,2.0179999999999998,0,0,null,null,null,null,null,null,0,0,0,0,4.756977,5.9042319999999995,0.98182199999999986,7.1662877999999992,3.1379899999999994]
[745,-2.7497024617293133E-3,0,0,null,null,null,null,null,null,745,0,0,2E-3,10.236000000000001,1.885,0,0,null,null,null,null,null,null,0,0,0,0,4.9753499999999997,5.9673230000000004,0.91682600000000003,7.4958228,2.9311750000000001]
[750,-2.7497024617293133E-3,0,0,null,null,null,null,null,null,750,0,0,1E-3,10.664999999999999,1.74,0,0,null,null,null,null,null,null,0,0,0,0,5.1835170000000002,6.0106649999999995,0.84599799999999992,7.809979499999999,2.7056999999999998]
[755,-2.7497024617293133E-3,0,0,null,null,null,null,null,null,755,0,0,1E-3,11.068,1.5880000000000001,0,0,null,null,null,null,null,null,0,0,0,0,5.3793750000000005,6.0368080000000006,0.77212599999999998,8.105096399999999,2.4693399999999999]
[760,-2.7497024617293133E-3,0,0,null,null,null,null,null,null,760,0,0,0,11.442,1.4330000000000001,0,0,null,null,null,null,null,null,0,0,0,0,5.5608120000000003,6.0482049999999994,0.696438,8.3789765999999997,2.2283149999999998]
[765,-2.7497024617293133E-3,0,0,null,null,null,null,null,null,765,0,0,0,11.782,1.28,0,0,null,null,null,null,null,null,0,0,0,0,5.7260520000000001,6.0474059999999996,0.62207999999999997,8.6279585999999995,1.9903999999999999]
[770,-2.7497024617293133E-3,0,0,null,null,null,null,null,null,770,0,0,0,12.085000000000001,1.1339999999999999,0,0,null,null,null,null,null,null,0,0,0,0,5.87331,6.0377869999999998,0.55112399999999995,8.8498455000000007,1.7633699999999997]
[775,-2.7497024617293133E-3,0,0,null,null,null,null,null,null,775,0,0,0,12.348000000000001,0.995,0,0,null,null,null,null,null,null,0,0,0,0,6.0011280000000005,6.0181089999999999,0.48357,9.0424404000000003,1.5472249999999999]
[780,-2.7497024617293133E-3,0,0,null,null,null,null,null,null,780,0,0,0,12.569000000000001,0.86599999999999999,0,0,null,null,null,null,null,null,0,0,0,0,6.1085340000000006,5.9903150000000007,0.42087599999999997,9.2042786999999997,1.34663]
[785,-2.7497024617293133E-3,0,0,null,null,null,null,null,null,785,0,0,0,12.744999999999999,0.749,0,0,null,null,null,null,null,null,0,0,0,0,6.1940699999999991,5.955012,0.364014,9.3331634999999995,1.164695]
[790,-2.7497024617293133E-3,0,0,null,null,null,null,null,null,790,0,0,0,12.878,0.64200000000000002,0,0,null,null,null,null,null,null,0,0,0,0,6.2587079999999995,5.9111799999999999,0.31201200000000001,9.4305593999999999,0.99831000000000003]
[795,-2.7497024617293133E-3,0,0,null,null,null,null,null,null,795,0,0,0,12.967000000000001,0.54700000000000004,0,0,null,null,null,null,null,null,0,0,0,0,6.3019620000000005,5.860252,0.26584200000000002,9.4957341,0.85058500000000004]
[800,-2.7497024617293133E-3,0,0,null,null,null,null,null,null,800,0,0,0,13.018000000000001,0.46200000000000002,0,0,null,null,null,null,null,null,0,0,0,0,6.3267480000000003,5.8028599999999999,0.22453200000000001,9.5330814000000004,0.71840999999999999]
[805,-2.7497024617293133E-3,0,0,null,null,null,null,null,null,805,0,0,0,13.035,0.38800000000000001,0,0,null,null,null,null,null,null,0,0,0,0,6.3350099999999996,5.7415789999999998,0.18856800000000001,9.5455304999999999,0.60333999999999999]
[810,-2.7497024617293133E-3,0,0,null,null,null,null,null,null,810,0,0,0,13.026,0.32300000000000001,0,0,null,null,null,null,null,null,0,0,0,0,6.3306360000000002,5.677867,0.15697800000000001,9.5389397999999996,0.50226499999999996]
[815,-2.7497024617293133E-3,0,0,null,null,null,null,null,null,815,0,0,0,12.997999999999999,0.26600000000000001,0,0,null,null,null,null,null,null,0,0,0,0,6.3170279999999996,5.6136919999999995,0.129276,9.5184353999999995,0.41363]
[820,-2.7497024617293133E-3,0,0,null,null,null,null,null,null,820,0,0,0,12.955,0.218,0,0,null,null,null,null,null,null,0,0,0,0,6.2961299999999998,5.5516290000000001,0.105948,9.4869465000000002,0.33898999999999996]
[825,-2.7497024617293133E-3,0,0,null,null,null,null,null,null,825,0,0,0,12.895,0.17699999999999999,0,0,null,null,null,null,null,null,0,0,0,0,6.2669699999999997,5.4890059999999989,8.6021999999999987E-2,9.4430084999999995,0.27523499999999995]
[830,-2.7497024617293133E-3,0,0,null,null,null,null,null,null,830,0,0,0,12.811,0.14199999999999999,0,0,null,null,null,null,null,null,0,0,0,0,6.226146,5.4220089999999992,6.901199999999999E-2,9.3814952999999992,0.22080999999999998]
[835,-2.7497024617293133E-3,0,0,null,null,null,null,null,null,835,0,0,0,12.685,0.113,0,0,null,null,null,null,null,null,0,0,0,0,6.1649099999999999,5.3432040000000001,5.4918000000000002E-2,9.2892255000000006,0.17571500000000001]

{"sheet":"Préparation solutions ","index":1,"n_rows":139,"n_cols":18,"rows_kept":139,"cut":false,"hidden":false,"merged":[]}
["Spectre d'absorption d'une solution "]
[]
[]
["1- Choix du solide"]
["Composé","Permanganate de potassium"]
["MM / g.mol-1",{"$f":"HLOOKUP($B$5,L$42:S$139,10)","v":158.0249}]
[null,null,null,null,null,null,null,null,null,null,"l / nm",525,null,null,"Absorbance",{"$f":"INT(1000*(VLOOKUP(L7,A52:D139,4)+(RAND()-0.5)*$G$31))/1000","v":1.9990000000000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"mesurée à \"&L7&\"nm\"","v":"mesurée à 525nm"}]
["2- Préparation d'une solution mère à partir du solide",null,null,"3- Préparation solution fille par dilution",null,null,null,"4- Spectre de la solution fille",null,null,"C ",{"$f":"E15","v":9.6377216501956336E-3}," mol.L-1"]
["masse / g",0.15229999999999999,null,"V pipette / mL",25]
["Volume fiole / mL",100,null,"V fiole / mL",25]
[]
[null,{"$f":"IF(B10/B11*1000>B48,\"IMPOSSIBLE A DISSOUDRE EN TOTALITE : LIMITE DE SOLUBILITE DEPASSEE\",\"\")","v":""}]
[]
[null,null,null,"C  / mol.L-1",{"$f":"IF(B10/B11*1000>B48,0,B10/B6/(B11/1000)*E10/E11)","v":9.6377216501956336E-3}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"bruit",0.01,"Ip",0.01,null,"e / L.mol‑1.cm-1",{"$f":"LOOKUP(L7,A52:A139,E52:E139)","v":2251.9999999999995}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Solution étudiée"]
[null,null,null,null,null,null,null,null,null,null,null,"Bleu patenté","Jaune de quinoléïne","Nitrate de cobalt","Nitrate de cuivre trihydraté","Nitrate de nickel hexahydraté","Permanganate de potassium","Tartrazine"]
["H",{"$f":"HLOOKUP($B$5,$L$42:$S$139,2)","v":0.792156862745098},null,null,null,null,null,null,null,null,"H",0.62,{"$f":"37/255","v":0.14509803921568629},{"$f":"242/255","v":0.94901960784313721},0.62,{"$f":"125/255","v":0.49019607843137253},0.792156862745098,{"$f":"40/255","v":0.15686274509803921}]
["S",{"$f":"HLOOKUP($B$5,$L$42:$S$139,3)","v":0.65098039215686276},null,null,null,null,null,null,null,null,"S",1,1,{"$f":"159/255","v":0.62352941176470589},1,{"$f":"197/255","v":0.77254901960784317},0.65098039215686276,1]
["L",{"$f":"HLOOKUP($B$5,$L$42:$S$139,4)","v":7.1674835504187406E-5},null,null,null,null,null,null,null,null,"L",{"$f":"1-L47","v":0},{"$f":"1-M47","v":0},{"$f":"1-N47","v":0.97797823353303448},{"$f":"1-O47","v":0.98892782018357361},{"$f":"1-P47","v":0.97797823353303448},7.1674835504187406E-5,0]
["Concentration à 0,5 de Luminosité",{"$f":"HLOOKUP($B$5,$L$42:$S$139,5)","v":6.9999999999999999E-4},null,null,null,null,null,null,null,null,"Concentration à 0,5 de Luminosité",1.0000000000000001E-5,6.0000000000000002E-5,0.3,0.6,0.3,6.9999999999999999E-4,6.0000000000000002E-5]
[null,{"$f":"HLOOKUP($B$5,$L$42:$S$139,6)","v":0.99992832516449581},null,null,null,null,null,null,null,null,null,{"$f":"1-EXP(-(LN(2)/L46*$E$15))","v":1},1,2.202176646696552E-2,1.1072179816426386E-2,2.202176646696552E-2,0.99992832516449581,1]
["solubilité g/L",{"$f":"HLOOKUP($B$5,$L$42:$S$139,7)","v":64},null,null,null,null,null,null,null,null,"solubilité g/L",84,220,1330,1380,940,64,38]
[]
[null,{"$f":"(RAND()-0.5)*$G$31","v":-3.3787344469472479E-3}]
["l / nm","Absorbance","Abs théo","Signal vrai","e / L.mol‑1.cm-1",null,"coeff",1.4,null,null,null,582.66730600000005,477.375,182.94300000000001,241.6,182.703,{"$f":"39.0893+54.938+15.9994*4","v":158.0249},534.36300000000006]
[400,{"$f":"D52+$B$50","v":0.1869800636324018},{"$f":"E52*$E$15","v":0.19275443300391268},{"$f":"-LOG(($I$31+10^(-C52))/($I$31+1))","v":0.19035879807934905},{"$f":"HLOOKUP($B$5,L$42:S$139,ROW()-42+1)","v":20},null,null,null,null,null,400,10501.56191046512,22436.625,8.9999999999999993E-3,0,4.5259999999999998,20,20156.283108808289]
[{"$f":"A52+5","v":405},{"$f":"D53+$B$50","v":0.2059531193427325},0.21202987630430395,0.20933185378967975,22,null,{"$f":"L7","v":525},{"$f":"P7+0.08*H51","v":2.1110000000000002},null,null,{"$f":"K52+5","v":405},11788.850144651165,24584.812500000004,1.7999999999999999E-2,0,3.9940000000000002,22,21097.647979274614]
[410,0.22491267672235557,0.23130531960469519,0.22829141116930282,24,null,{"$f":"G53","v":525},{"$f":"P7-0.08*H51","v":1.887},null,null,410,12263.114230930236,25406.958333333336,3.5999999999999997E-2,0,3.4289999999999998,24,21872.889637305703]
[415,0.26278890318195441,0.26985620620547773,0.26616763762890167,28,null,null,null,null,null,415,10772.569959767445,24796.979166666672,6.9000000000000006E-2,0,2.863,28,22482.008082901553]
[420,0.28170431210035835,0.289131649505869,0.2850830465473056,30,null,{"$f":"L7-10","v":515},{"$f":"P7","v":1.9990000000000001},null,null,420,8130.2414790697694,23497.458333333336,0.128,0,2.3260000000000001,30,22869.628911917098]
[425,0.35719861435783357,0.36623342270743409,0.36057734880478082,38,null,{"$f":"L7+10","v":535},{"$f":"P7","v":1.9990000000000001},null,null,425,5352.4089737209315,22569.229166666668,0.22700000000000001,0,1.839,38,23035.752124352333]
[430,0.50721772239337903,0.52043696911056425,0.51059645684032628,54,null,null,null,null,null,430,3319.8486039534891,21614.479166666668,0.38100000000000001,0,1.4179999999999999,54,22869.628911917098]
[435,0.71056512915198156,0.73246684541486817,0.71394386359892881,76,null,null,null,null,null,435,2032.5603697674424,19545.854166666668,0.60399999999999998,0,1.07,76,22426.63367875648]
[440,0.94411163434592194,0.98304760831995452,0.94749036879286919,101.99999999999999,null,null,null,null,null,440,1355.0402465116283,15753.375,0.90400000000000003,0,0.79700000000000004,101.99999999999999,21706.766424870468]
[445,1.2626190566686435,1.3492810310273886,1.2659977911155906,140,null,null,null,null,null,445,948.52817255813966,11112.229166666668,1.28,0,0.59599999999999997,140,20599.278341968911]
[450,1.6187276203648384,1.8504425568375615,1.6221063548117856,192,null,null,null,null,null,450,813.02414790697696,6895.416666666667,1.7130000000000001,0,0.46100000000000002,192,19048.795025906737]
[455,1.8633847202479747,2.4287058558492998,1.8667634546949219,252,null,null,null,null,null,455,677.52012325581416,3951.604166666667,2.173,1E-3,0.379,252,17110.690880829017]
[460,1.9308193009719463,2.7563883919559506,1.9341980354188935,285.99999999999994,null,null,null,null,null,460,609.76811093023275,2148.1875,2.6230000000000002,1E-3,0.33300000000000002,285.99999999999994,15061.837927461138]
[465,1.9975509354208534,4.1056694229833397,2.0009296698678005,426,null,null,null,null,null,465,609.76811093023264,1166.9166666666667,3.0350000000000001,2E-3,0.30399999999999999,426,13123.73378238342]
[470,2.000618781466303,5.127267917904077,2.0039975159132504,532,null,null,null,null,null,470,677.52012325581416,663.02083333333337,3.3929999999999998,2E-3,0.27800000000000002,532,11130.255233160622]
[475,2.0009179489237066,6.2452436293267706,2.0042966833706539,648,null,null,null,null,null,475,745.27213558139545,397.8125,3.706,3.0000000000000001E-3,0.245,648,9026.0278756476673]
[480,2.0009420458597127,7.8643808665596362,2.0043207803066601,815.99999999999989,null,null,null,null,null,480,880.77616023255825,238.68750000000006,4.0010000000000003,4.0000000000000001E-3,0.20399999999999999,815.99999999999989,6811.0517098445607]
[485,2.0009426279098328,9.5798953202944599,2.0043213623567802,994,null,null,null,null,null,485,948.52817255813966,159.12500000000003,4.3040000000000003,5.0000000000000001E-3,0.159,994,4706.8243523316069]
[490,2.0009426387251614,10.852074578120281,2.0043213731721088,1125.9999999999998,null,null,null,null,null,490,1151.7842095348838,106.08333333333334,4.6269999999999998,7.0000000000000001E-3,0.11700000000000001,1125.9999999999998,2934.8434196891194]
[495,2.0009426393203542,12.451936372052758,2.0043213737673016,1292,null,null,null,null,null,495,1355.0402465116283,79.562499999999986,4.9480000000000004,8.9999999999999993E-3,8.5999999999999993E-2,1292,1661.2321243523315]
[500,2.0009426393356429,14.919193114502841,2.0043213737825902,1548,null,null,null,null,null,500,1626.0482958139539,53.041666666666671,5.2169999999999996,1.0999999999999999E-2,6.5000000000000002E-2,1548,885.99046632124362]
[505,2.0009426393356944,16.692533898138837,2.0043213737826417,1732,null,null,null,null,null,505,1964.8083574418611,26.520833333333314,5.3609999999999998,1.4E-2,5.3999999999999999E-2,1732,387.62082901554413]
[510,2.0009426393356948,17.251521753850184,2.0043213737826422,1790,null,null,null,null,null,510,2371.3204313953497,0,5.319,1.7999999999999999E-2,4.9000000000000002E-2,1790,110.74880829015545]
[515,2.0009426393356953,18.523701011676007,2.0043213737826426,1922,null,null,null,null,null,515,2845.5845176744197,0,5.0579999999999998,2.1999999999999999E-2,4.9000000000000002E-2,1922,0]
[520,2.0009426393356953,20.798203321122177,2.0043213737826426,2158,null,null,null,null,null,520,3523.1046409302339,0,4.59,2.8000000000000001E-2,5.0999999999999997E-2,2158,0]
[525,2.0009426393356953,21.704149156240561,2.0043213737826426,2251.9999999999995,null,null,null,null,null,525,4403.8808011627916,0,3.9689999999999999,3.5000000000000003E-2,5.3999999999999999E-2,2251.9999999999995,0]
[530,2.0009426393356953,20.412694455114352,2.0043213737826426,2118,null,null,null,null,null,530,5487.9129983720941,0,3.2759999999999998,4.2999999999999997E-2,5.6000000000000001E-2,2118,0]
[535,2.0009426393356953,19.872982042703395,2.0043213737826426,2062,null,null,null,null,null,535,6639.6972079069774,0,2.5939999999999999,5.2999999999999999E-2,5.8999999999999997E-2,2062,0]
[540,2.0009426393356953,20.778927877821786,2.0043213737826426,2156,null,null,null,null,null,540,7994.7374544186059,0,1.9910000000000001,6.5000000000000002E-2,6.2E-2,2156,0]
[545,2.0009426393356953,20.586173444817874,2.0043213737826426,2136,null,null,null,null,null,545,9553.0337379069788,0,1.5029999999999999,0.08,6.5000000000000002E-2,2136,0]
[550,2.0009426393356953,17.733407836359966,2.0043213737826426,1840,null,null,null,null,null,550,11314.586058372095,0,1.143,9.8000000000000004E-2,6.9000000000000006E-2,1840,0]
[555,2.0009426393355736,14.552959691795406,2.004321373782521,1510,null,null,null,null,null,555,13414.89844046512,0,0.89600000000000002,0.11899999999999999,7.3999999999999996E-2,1510,0]
[560,2.0009426393304079,{"$f":"E84*$E$15","v":12.914547011262149},{"$f":"-LOG(($I$31+10^(-C84))/($I$31+1))","v":2.0043213737773553},{"$f":"HLOOKUP($B$5,L$42:S$139,ROW()-42+1)","v":1340},null,null,null,null,null,560,15989.474908837212,0,0.73899999999999999,0.14399999999999999,8.1000000000000003E-2,1340,0]
[565,2.0009426393058427,12.162804722546889,2.0043213737527901,1262,null,null,null,null,null,565,19038.315463488376,0,0.64500000000000002,0.17299999999999999,9.0999999999999998E-2,1262,0]
[570,2.0009426385027091,10.717146475017545,2.0043213729496565,1112,null,null,null,null,null,570,22967.932178372095,0,0.59099999999999997,0.20699999999999999,0.106,1112,0]
[575,2.0009420962701041,7.9029317531604182,2.0043208307170515,819.99999999999989,null,null,null,null,null,575,27439.564991860472,0,0.55900000000000005,0.248,0.127,819.99999999999989,0]
[580,2.0006462808826564,5.1658188045048599,2.0040250153296038,536,null,null,null,null,null,580,32249.957866976751,0,0.53700000000000003,0.29499999999999998,0.158,536,0]
[585,1.9858107879551896,3.4503043507700366,1.9891895224021368,358,null,null,null,null,null,585,36450.582631162804,0,0.51800000000000002,0.35,0.19900000000000001,358,0]
[590,1.9040575943012539,2.6021848455528209,1.907436328748201,270,null,null,null,null,null,590,40109.191296744197,0,0.499,0.41299999999999998,0.255,270,0]
[595,1.794875640669477,2.2166759795449957,1.7982543751164242,230,null,null,null,null,null,595,43496.791913023269,0,0.47799999999999998,0.48599999999999999,0.32600000000000001,230,0]
[600,1.7022294822922164,2.0046461032406917,1.7056082167391635,208,null,null,null,null,null,600,47019.896553953498,0,0.45400000000000001,0.56899999999999995,0.41599999999999998,208,0]
[605,1.6187276203648384,1.8504425568375615,1.6221063548117856,192,null,null,null,null,null,605,51694.785404418617,0,0.42799999999999999,0.66400000000000003,0.52400000000000002,192,0]
[610,1.5347806950077063,1.7155144537348228,1.5381594294546534,178,null,null,null,null,null,610,58198.978587674435,0,0.4,0.77200000000000002,0.65,178,0]
[615,1.4825266304343712,1.6384126805332577,1.4859053648813183,170,null,null,null,null,null,615,66938.98817767443,0,0.371,0.89400000000000002,0.79200000000000004,170,0]
[620,1.4131703873828714,1.5420354640313014,1.4165491218298185,160,null,null,null,null,null,620,77711.558137441883,0,0.34100000000000003,1.0309999999999999,0.94599999999999995,160,0]
[625,1.3695624593986933,1.4842091341301276,1.3729411938456404,154,null,null,null,null,null,625,89093.896208139558,0,0.311,1.1839999999999999,1.1080000000000001,154,0]
[630,1.3092909706235127,1.4071073609285625,1.3126697050704599,146,null,null,null,null,null,630,98511.425921395392,0,0.28100000000000003,1.355,1.2709999999999999,146,0]
[635,1.2626190566686435,1.3492810310273886,1.2659977911155906,140,null,null,null,null,null,635,102305.53861162794,0,0.252,1.5449999999999999,1.429,140,0]
[640,1.1823249382440282,1.2529038145254323,1.1857036726909753,130,null,null,null,null,null,640,97969.409822790738,0,0.224,1.754,1.575,130,0]
[645,1.1160845534369912,1.1758020413238672,1.1194632878839383,122,null,null,null,null,null,645,86112.807665813991,0,0.19700000000000001,1.984,1.704,122,0]
[650,1.0311233372261874,1.0794248248219109,1.0345020716731346,112,null,null,null,null,null,650,70326.588793953502,0,0.17199999999999999,2.2349999999999999,1.8140000000000001,112,0]
[655,0.96166130506368053,1.0023230516203459,0.96504003951062778,104,null,null,null,null,null,655,54066.105835813971,0,0.14899999999999999,2.508,1.903,104,0]
[660,0.81948005700716653,0.8481195052172158,0.82285879145411378,88,null,null,null,null,null,660,36857.094705116288,0,0.128,2.8039999999999998,1.972,88,0]
[665,0.72883179412073118,0.75174228871525939,0.73221052856767843,78,null,null,null,null,null,665,25813.516696046518,0,0.109,3.121,2.0259999999999998,78,0]
[670,0.63709850704144311,0.65536507221330309,0.64047724148839036,68,null,null,null,null,null,670,17547.771192325585,0,9.0999999999999998E-2,3.4620000000000002,2.0680000000000001,68,0]
[675,0.54447714714486228,0.55898785571134679,0.54785588159180953,58,null,null,null,null,null,675,11788.850144651165,0,7.5999999999999998E-2,3.8250000000000002,2.105,58,0]
[680,0.46985197405615869,0.48188608250978165,0.47323070850310595,50,null,null,null,null,null,680,7723.7294051162808,0,6.3E-2,4.2089999999999996,2.1389999999999998,50,0]
[685,0.39483485933132423,0.40478430930821663,0.39821359377827148,42,null,null,null,null,null,685,4945.8968997674428,0,5.1999999999999998E-2,4.6139999999999999,2.1760000000000002,42,0]
[690,0.31948636999414404,0.32768253610665155,0.32286510444109129,34,null,null,null,null,null,690,3184.3445793023266,0,4.2000000000000003E-2,5.0369999999999999,2.2149999999999999,34,0]
[695,0.22491267672235557,0.23130531960469519,0.22829141116930282,24,null,null,null,null,null,695,2100.3123820930236,0,3.4000000000000002E-2,5.4790000000000001,2.2559999999999998,24,0]
[700,0.1869800636324018,0.19275443300391268,0.19035879807934905,20,null,null,null,null,null,700,1355.0402465116283,0,2.7E-2,5.9359999999999999,2.2959999999999998,20,0]
[705,0.12998547157049947,0.13492810310273887,0.13336420601744672,14,null,null,null,null,null,705,880.77616023255825,0,2.1000000000000001E-2,6.4050000000000002,2.3290000000000002,14,0]
[710,9.1931397702177148E-2,9.6377216501956339E-2,9.5310132149124399E-2,10,null,null,null,null,null,710,609.76811093023275,0,1.6E-2,6.8849999999999998,2.35,10,0]
[715,5.3835622588005463E-2,5.7826329901173798E-2,5.7214357034952715E-2,6,null,null,null,null,null,715,406.51207395348843,0,1.2999999999999999E-2,7.3730000000000002,2.355,6,0]
[720,1.5701608159415192E-2,{"$f":"E116*$E$15","v":1.9275443300391267E-2},{"$f":"-LOG(($I$31+10^(-C116))/($I$31+1))","v":1.908034260636244E-2},{"$f":"HLOOKUP($B$5,L$42:S$139,ROW()-42+1)","v":2},null,null,null,null,null,720,271.00804930232562,0,0.01,7.8639999999999999,2.3370000000000002,2,0]
[{"$f":"A116+5","v":725},{"$f":"D117+$B$50","v":-3.3787344469472479E-3},0,0,0,null,null,null,null,null,{"$f":"K116+5","v":725},203.25603697674424,0,7.0000000000000001E-3,8.3539999999999992,2.294,0,0]
[730,-3.3787344469472479E-3,0,0,0,null,null,null,null,null,730,0,0,5.0000000000000001E-3,8.8409999999999993,2.226,0,0]
[735,-3.3787344469472479E-3,0,0,0,null,null,null,null,null,735,0,0,4.0000000000000001E-3,9.32,2.133,0,0]
[740,-3.3787344469472479E-3,0,0,0,null,null,null,null,null,740,0,0,3.0000000000000001E-3,9.7859999999999996,2.0179999999999998,0,0]
[745,-3.3787344469472479E-3,0,0,0,null,null,null,null,null,745,0,0,2E-3,10.236000000000001,1.885,0,0]
[750,-3.3787344469472479E-3,0,0,0,null,null,null,null,null,750,0,0,1E-3,10.664999999999999,1.74,0,0]
[755,-3.3787344469472479E-3,0,0,0,null,null,null,null,null,755,0,0,1E-3,11.068,1.5880000000000001,0,0]
[760,-3.3787344469472479E-3,0,0,0,null,null,null,null,null,760,0,0,0,11.442,1.4330000000000001,0,0]
[765,-3.3787344469472479E-3,0,0,0,null,null,null,null,null,765,0,0,0,11.782,1.28,0,0]
[770,-3.3787344469472479E-3,0,0,0,null,null,null,null,null,770,0,0,0,12.085000000000001,1.1339999999999999,0,0]
[775,-3.3787344469472479E-3,0,0,0,null,null,null,null,null,775,0,0,0,12.348000000000001,0.995,0,0]
[780,-3.3787344469472479E-3,0,0,0,null,null,null,null,null,780,0,0,0,12.569000000000001,0.86599999999999999,0,0]
[785,-3.3787344469472479E-3,0,0,0,null,null,null,null,null,785,0,0,0,12.744999999999999,0.749,0,0]
[790,-3.3787344469472479E-3,0,0,0,null,null,null,null,null,790,0,0,0,12.878,0.64200000000000002,0,0]
[795,-3.3787344469472479E-3,0,0,0,null,null,null,null,null,795,0,0,0,12.967000000000001,0.54700000000000004,0,0]
[800,-3.3787344469472479E-3,0,0,0,null,null,null,null,null,800,0,0,0,13.018000000000001,0.46200000000000002,0,0]
[805,-3.3787344469472479E-3,0,0,0,null,null,null,null,null,805,0,0,0,13.035,0.38800000000000001,0,0]
[810,-3.3787344469472479E-3,0,0,0,null,null,null,null,null,810,0,0,0,13.026,0.32300000000000001,0,0]
[815,-3.3787344469472479E-3,0,0,0,null,null,null,null,null,815,0,0,0,12.997999999999999,0.26600000000000001,0,0]
[820,-3.3787344469472479E-3,0,0,0,null,null,null,null,null,820,0,0,0,12.955,0.218,0,0]
[825,-3.3787344469472479E-3,0,0,0,null,null,null,null,null,825,0,0,0,12.895,0.17699999999999999,0,0]
[830,-3.3787344469472479E-3,0,0,0,null,null,null,null,null,830,0,0,0,12.811,0.14199999999999999,0,0]
[835,-3.3787344469472479E-3,0,0,0,null,null,null,null,null,835,0,0,0,12.685,0.113,0,0]