{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["КИТАЕВ склерометр"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":2,"defined_names":35,"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":"КИТАЕВ склерометр","index":0,"n_rows":76,"n_cols":57,"rows_kept":76,"cut":false,"hidden":false,"merged":[[3,1,6,2],[3,3,6,3],[3,4,6,13],[3,14,6,14],[3,15,6,15],[0,23,1,23],[3,16,6,17],[0,17,1,19],[0,20,1,20],[0,21,1,21],[0,22,1,22],[3,18,6,18],[3,19,5,20],[3,53,4,56],[5,28,5,36],[5,38,5,46],[5,49,5,51],[5,53,6,53],[5,54,6,54],[5,56,6,56],[6,49,6,51],[6,38,6,40],[6,28,6,30],[13,31,15,34],[13,41,15,44],[11,31,12,34],[3,21,5,22],[3,23,5,24],[7,31,8,31],[7,33,8,33],[3,25,6,25],[62,35,63,38],[62,39,62,40],[63,39,63,40],[7,41,8,41],[7,43,8,43],[11,41,12,44],[58,45,58,46],[60,48,60,51],[61,33,61,40],[61,48,61,51],[58,16,58,17],[58,35,58,36]]}
[null,null,null,"Кубы",null,null,null,null,null,null,null,null,null,null,null,null,null,"Кубы",null,null,{"$f":"IF(R1=\"Отрыв со скалыванием\",2.5,\"\")","v":""},{"$f":"IF(R1=\"Кубы\",10,\"\")","v":10},{"$f":"IF(R1=\"Кубы\",0.95,\"\")","v":0.95},{"$f":"IF(R1=\"Кубы\",100,\"\")","v":100}]
[null,null,null,"Отрыв со скалыванием"]
[]
[null,"Наибольшее и наименьшее значение для отбраковки",null,"№","Значение склерометра",null,null,null,null,null,null,null,null,null,"max","min","Среднее значение по склерометру",null,"Разделение на группы","Значение                                            прочности кубов (КН), показания отрыва",null,"По градуировочной зависимости RiH",null,"Корректировка путем отбраковки                                                               RiH-Riф/Sт",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,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,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,"Коэффициент корреляции град.зависимости",null,null,null,"№","Среднее значение по склерометру","Значение ПИБ","Отбракованные показания"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Показания","Показания                             Riф                                 (Мпа)","До отбраковки","После отбраковки","До отбраковки","После отбраковки",null,null,null,"Промежуточные данные  для расчета а1",null,null,null,null,null,null,null,"Sт",null,"Промежуточные данные  для расчета а1",null,null,null,null,null,null,null,"Sт",null,null,{"$f":"W58","v":37.383585714285708},null,null,null,null,null,"Показания Riф  (Мпа)"]
[null,{"$f":"IFERROR(IF(O8>4,LARGE(E8:N8,1),\"\"),\"\")","v":45},{"$f":"IFERROR(IF(P8>4,SMALL(E8:N8,1),\"\"),\"\")","v":20},1,22,34,24,20,21,21,22,45,25,24,{"$f":"IFERROR(MAX(E8:N8)-AVERAGE(E8:N8),\"\")","v":19.2},{"$f":"IFERROR(AVERAGE(E8:N8)-MIN(E8:N8),\"\")","v":5.8000000000000007},{"$f":"IFERROR(AVERAGE(E8:N8),\"\")","v":25.8},null,{"$f":"IFERROR(IF(SUM(Q8:R8)=0,\"\",IF(SUM(Q8:R8)<=$Q$58,1,2)),\"\")","v":1},349.8,{"$f":"IF(T8=\"\",\"\",(IF($R$1=$D$1,((T8*$V$1)/$X$1)*$W$1,IF($R$1=$D$2,T8*$U$1,\"\"))))","v":33.230999999999995},{"$f":"IF(SUM(Q8:R8)=0,\"\",$AH$8*SUM(Q8:R8)+($AG$10))","v":31.922015948298217},{"$f":"IF(SUM(Q8:R8)=0,\"\",$AR$8*SUM(Q8:R8)+($AQ$10))","v":31.922015948298217},{"$f":"(V8-U8)/$AK$58","v":-0.26174870986501586},{"$f":"(W8-U8)/$AU$58","v":-0.26174870986501586},null,1,null,1,{"$f":"IF(SUM(Q8:R8)=0,\"\",(SUM(Q8:R8)-$Q$58)*(U8-$U$58))","v":26.999104770813055},{"$f":"IF(SUM(Q8:R8)=0,\"\",POWER((SUM(Q8:R8)-$Q$58),2))","v":42.272848893336537},"а1=",{"$f":"IF(AD58=0,\"\",AD58)","v":356.09109849773245},{"$f":"IFERROR(AG8/AG9,\"\")","v":0.84001439234132957},null,1,{"$f":"IFERROR(POWER(U8-V8,2),\"\")","v":1.7134392476096021},null,1,{"$f":"IF(SUM(Q8:R8)=0,\"\",(SUM(Q8:R8)-$Q$58)*(U8-$U$58))","v":26.999104770813055},{"$f":"IF(SUM(Q8:R8)=0,\"\",POWER((SUM(Q8:R8)-$Q$58),2))","v":42.272848893336537},"а1=",{"$f":"IF(AN58=0,\"\",AN58)","v":356.09109849773245},{"$f":"IFERROR(AQ8/AQ9,\"\")","v":0.84001439234132957},null,1,{"$f":"IFERROR(POWER(U8-W8,2),\"\")","v":1.7134392476096021},null,1,{"$f":"IFERROR((W8-$W$58)*(U8-$W$58),\"\")","v":22.679636587814421},{"$f":"IFERROR(POWER((W8-$W$58),2),\"\")","v":29.828744308748657},{"$f":"IFERROR(POWER((U8-$W$58),2),\"\")","v":17.243968114489789},null,1,{"$f":"IF(SUM(Q8:R8)=0,\"\",SUM(Q8:R8))","v":25.8},{"$f":"IF(U8=0,\"\",U8)","v":33.230999999999995},{"$f":"IF(Z8=\"Отбраковывается\",U8,\"\")","v":""}]
[null,{"$f":"IFERROR(IF(O9>4,LARGE(E9:N9,1),\"\"),\"\")","v":78},{"$f":"IFERROR(IF(P9>4,SMALL(E9:N9,1),\"\"),\"\")","v":19},{"$f":"D8+1","v":2},22,25,78,24,22,21,23,20,19,20,{"$f":"IFERROR(MAX(E9:N9)-AVERAGE(E9:N9),\"\")","v":50.6},{"$f":"IFERROR(AVERAGE(E9:N9)-MIN(E9:N9),\"\")","v":8.3999999999999986},{"$f":"IFERROR(AVERAGE(E9:N9),\"\")","v":27.4},null,{"$f":"IFERROR(IF(SUM(Q9:R9)=0,\"\",IF(SUM(Q9:R9)<=$Q$58,1,2)),\"\")","v":1},346.1,32.8795,{"$f":"IF(SUM(Q9:R9)=0,\"\",$AH$8*SUM(Q9:R9)+($AG$10))","v":33.266038976044342},{"$f":"IF(SUM(Q9:R9)=0,\"\",$AR$8*SUM(Q9:R9)+($AQ$10))","v":33.266038976044342},{"$f":"(V9-U9)/$AK$58","v":7.7293591286016275E-2},{"$f":"(W9-U9)/$AU$58","v":7.7293591286016275E-2},null,{"$f":"AA8+1","v":2},null,{"$f":"AC8+1","v":2},{"$f":"IF(SUM(Q9:R9)=0,\"\",(SUM(Q9:R9)-$Q$58)*(U9-$U$58))","v":22.077935343375394},{"$f":"IF(SUM(Q9:R9)=0,\"\",POWER((SUM(Q9:R9)-$Q$58),2))","v":24.027225310570138},null,{"$f":"IF(AE58=0,\"\",AE58)","v":423.91071122628955},null,null,{"$f":"AJ8+1","v":2},{"$f":"IFERROR(POWER(U9-V9,2),\"\")","v":0.14941238000140844},null,{"$f":"AM8+1","v":2},{"$f":"IF(SUM(Q9:R9)=0,\"\",(SUM(Q9:R9)-$Q$58)*(U9-$U$58))","v":22.077935343375394},{"$f":"IF(SUM(Q9:R9)=0,\"\",POWER((SUM(Q9:R9)-$Q$58),2))","v":24.027225310570138},null,{"$f":"IF(AO58=0,\"\",AO58)","v":423.91071122628955},null,null,{"$f":"AT8+1","v":2},{"$f":"IFERROR(POWER(U9-W9,2),\"\")","v":0.14941238000140844},null,{"$f":"AW8+1","v":2},{"$f":"IFERROR((W9-$W$58)*(U9-$W$58),\"\")","v":18.545783441616649},{"$f":"IFERROR(POWER((W9-$W$58),2),\"\")","v":16.954191141602109},{"$f":"IFERROR(POWER((U9-$W$58),2),\"\")","v":20.286788121632593},null,{"$f":"BB8+1","v":2},{"$f":"IF(SUM(Q9:R9)=0,\"\",SUM(Q9:R9))","v":27.4},32.8795,""]
[null,"","",{"$f":"D9+1","v":3},null,null,28,28,null,26,26,29,27,null,1.6666666666666679,1.3333333333333321,27.333333333333332,null,1,374.9,35.615499999999997,33.210038016554918,33.210038016554918,-0.48100400457708381,-0.48100400457708381,null,{"$f":"AA9+1","v":3},null,{"$f":"AC9+1","v":3},8.7845995610624943,24.685237404296515,"а0=",{"$f":"IFERROR(U58-AH8*Q58,\"\")","v":10.249644625891914},null,null,{"$f":"AJ9+1","v":3},5.7862473537995331,null,{"$f":"AM9+1","v":3},8.7845995610624943,24.685237404296515,"а0=",{"$f":"IFERROR(U58-AR8*Q58,\"\")","v":10.249644625891914},null,null,{"$f":"AT9+1","v":3},5.7862473537995331,null,{"$f":"AW9+1","v":3},7.3791900622478268,17.418500385233976,3.1261270930612119,null,{"$f":"BB9+1","v":3},27.333333333333332,35.615499999999997,""]
[null,"","",{"$f":"D10+1","v":4},null,30,null,28,null,27,26,null,27,32,3.6666666666666679,2.3333333333333321,28.333333333333332,null,1,353.2,33.554000000000002,34.050052408896249,34.050052408896249,9.9192253629998672E-2,9.9192253629998672E-2,null,{"$f":"AA10+1","v":4},null,{"$f":"AC10+1","v":4},15.197419997570405,15.748389331734167,null,null,null,null,{"$f":"AJ10+1","v":4},0.24606799237176968,null,{"$f":"AM10+1","v":4},15.197419997570405,15.748389331734167,null,null,null,null,{"$f":"AT10+1","v":4},0.24606799237176968,null,{"$f":"AW10+1","v":4},12.766051524415081,11.112444298140771,14.66572674306116,null,{"$f":"BB10+1","v":4},28.333333333333332,33.554000000000002,""]
[null,"","",5,34,null,30,29,null,30,31,34,null,34,2.2857142857142847,2.7142857142857153,31.714285714285715,null,1,367.7,34.9315,36.890101068716938,36.890101068716938,0.39164824216949129,0.39164824216949129,null,5,null,5,1.4405308535795061,0.34512294581474989,"Уровнение градуировочной зависимости ",null,null,null,5,3.8361181463791305,null,5,1.4405308535795061,0.34512294581474989,"Уровнение градуировочной зависимости ",null,null,null,5,3.8361181463791305,null,5,1.2100666496185282,0.24352709541213502,6.0127243502040519,null,5,31.714285714285715,34.9315,""]
[null,"","",6,36,null,35,38,37,33,35,35,null,35,2.5,2.5,35.5,null,2,492,46.74,40.070155554009119,40.070155554009119,-1.3337237963050457,-1.3337237963050457,null,6,null,6,29.924083036119292,10.228755922815122,null,null,null,null,6,44.486824933715425,null,6,29.924083036119292,10.228755922815122,null,null,null,null,6,44.486824933715425,null,6,25.136660427957285,7.2176575037114752,87.542488285918523,null,6,35.5,46.74,""]
[null,"","",7,31,null,35,34,37,34,31,30,33,null,3.875,3.125,33.125,null,2,517,49.115000000000002,38.075121372198453,38.075121372198453,-2.2075700495637234,-2.2075700495637234,null,7,null,7,9.6578003547133928,0.67772842848402648,{"$f":"\"Rн = \" &   FIXED( AH8,2) & \" * H + \" & FIXED(AG10,2)","v":"Rн = 0,84 * H + 10,25"},null,null,null,7,121.87892011658941,null,7,9.6578003547133928,0.67772842848402648,{"$f":"\"Rн = \" & FIXED(AR8,2) & \" * H + \" & FIXED(AQ10,2)","v":"Rн = 0,84 * H + 10,25"},null,null,null,7,121.87892011658941,null,7,8.1126912963184061,0.47822156616481271,137.62608114306141,null,7,33.125,49.115000000000002,""]
[null,"","",8,null,32,null,31,null,37,36,34,33,36,2.8571428571428541,3.1428571428571459,34.142857142857146,null,2,428,40.659999999999997,38.930136021545884,38.930136021545884,-0.34590922938569563,-0.34590922938569563,null,8,null,8,6.0322055984775211,3.3896483750340987,null,null,null,null,8,2.9924293839530898,null,8,6.0322055984775211,3.3896483750340987,null,null,null,null,8,2.9924293839530898,null,8,5.0671395202830638,2.3918178528865455,10.734890571632672,null,8,34.142857142857146,40.659999999999997,""]
[null,"","",9,31,28,28,33,29,34,32,null,null,32,3.125,2.875,30.875,null,1,360.6,34.256999999999998,36.185088989430469,36.185088989430469,0.3855469475218225,0.3855469475218225,null,9,null,9,4.4608792095885725,2.0356365917493053,null,null,null,null,9,3.7175271511630137,null,9,4.4608792095885725,2.0356365917493053,null,null,null,null,9,3.7175271511630137,null,9,3.7472027385506026,1.4363943994887354,9.7755382287754831,null,9,30.875,34.256999999999998,""]
[null,"","",10,28,null,29,32,null,29,33,29,35,34,3.875,3.125,31.125,null,1,336,31.919999999999998,36.395092587515798,36.395092587515798,0.89485407387959648,0.89485407387959648,null,10,null,10,6.4293147538062456,1.3847579069420519,null,null,null,null,10,20.026453666838854,null,10,6.4293147538062456,1.3847579069420519,null,null,null,null,10,20.026453666838854,null,10,5.4007169260896948,0.97711866167135375,29.850768857346889,null,10,31.125,31.919999999999998,""]
[null,"","",11,32,30,30,29,29,null,30,30,29,28,2.3333333333333321,1.6666666666666679,29.666666666666668,null,1,364.6,34.637,35.170071598684693,35.170071598684693,0.10659473126505951,0.10659473126505951,null,11,null,11,7.2375024805636166,6.9437030127621338,null,null,null,null,11,0.28416532932425392,null,11,7.2375024805636166,6.9437030127621338,null,null,null,null,11,0.28416532932425392,null,11,6.0796062482795099,4.8996447399649439,7.5437330859183298,null,11,29.666666666666668,34.637,""]
[null,"","",12,28,null,33,28,29,35,33,34,34,34,3,4,32,null,1,410,38.949999999999996,37.130105180814461,37.130105180814461,-0.36391208922105861,-0.36391208922105861,null,12,null,12,-0.47267705458372933,9.1057510116665824E-2,null,null,null,null,12,3.3120171528983513,null,12,-0.47267705458372933,9.1057510116665824E-2,null,null,null,null,12,3.3120171528983513,null,12,-0.39705552877984052,6.425238084886814E-2,2.4536537144898025,null,12,32,38.949999999999996,""]
[null,"","",13,30,25,23,26,null,30,28,null,24,28,3.25,3.75,26.75,null,1,333.5,31.682500000000001,32.720029621022476,32.720029621022476,0.20746779870717882,0.20746779870717882,null,13,null,13,31.651044629089657,30.822009891068983,null,null,null,null,13,1.0764677144990413,null,13,31.651044629089657,30.822009891068983,null,null,null,null,13,1.0764677144990413,null,13,26.587333021073071,21.748755435012615,32.50237832163257,null,13,26.75,31.682500000000001,""]
[null,"","",14,26,30,29,null,null,28,28,24,28,28,2.375,3.625,27.625,null,1,352.6,33.497,33.455042214321139,33.455042214321139,-8.3900153374341542E-3,-8.3900153374341542E-3,null,14,null,14,18.176618381924147,21.872059494243597,null,null,null,null,14,1.7604557790732046E-3,null,14,18.176618381924147,21.872059494243597,null,null,null,null,14,1.7604557790732046E-3,null,14,15.268621044912269,15.433454031113863,15.105548514489747,null,14,27.625,33.497,""]
[null,"","",15,null,37,34,33,33,38,38,35,32,null,3,3,35,null,2,447,42.465000000000003,39.650148357838447,39.650148357838447,-0.56286689271678636,-0.56286689271678636,null,15,null,15,13.710888648364165,7.2805132924296272,null,null,null,null,15,7.9233897673796134,null,15,13.710888648364165,7.2805132924296272,null,null,null,null,15,7.9233897673796134,null,15,11.517343796415245,5.1373062171487787,25.820771143061322,null,15,35,42.465000000000003,""]
[null,"","",16,36,37,36,41,36,37,42,38,37,41,3.8999999999999986,2.1000000000000014,38.1,null,2,460,43.699999999999996,42.254192974096568,42.254192974096568,-0.28910827695112068,-0.28910827695112068,null,16,null,16,36.624102582604529,33.619617600819701,null,null,null,null,16,2.0903579561517134,null,16,36.624102582604529,33.619617600819701,null,null,null,null,16,2.0903579561517134,null,16,30.764773275973042,23.72281507932226,39.897089428775537,null,16,38.1,43.699999999999996,""]
[null,"","",17,34,null,31,33,37,35,33,34,33,35,3.1111111111111143,2.8888888888888857,33.888888888888886,null,2,477,45.314999999999998,38.716799033014752,38.716799033014752,-1.3193977331451567,-1.3193977331451567,null,17,null,17,12.588197605280238,2.5189864594741995,null,null,null,null,17,43.536256000725032,null,17,12.588197605280238,2.5189864594741995,null,null,null,null,17,43.536256000725032,null,17,10.574267162072097,1.777457753236511,62.907332571632715,null,17,33.888888888888886,45.314999999999998,""]
[null,"","",18,36,30,30,36,30,null,null,null,35,null,3.1666666666666643,2.8333333333333357,32.833333333333336,null,2,373.4,35.472999999999999,37.830117174432239,37.830117174432239,0.47133681927308424,0.47133681927308424,null,18,null,18,-1.0156214423388537,0.28257300520360212,null,null,null,null,18,5.5560013740034266,null,18,-1.0156214423388537,0.28257300520360212,null,null,null,null,18,5.5560013740034266,null,18,-0.85313662873510032,0.1993903449005929,3.6503377716326328,null,18,32.833333333333336,35.472999999999999,""]
[null,"","",19,32,37,null,34,33,34,38,34,34,null,3.5,2.5,34.5,null,2,234.5,22.2775,39.230141161667788,39.230141161667788,3.3899052834923711,3.3899052834923711,null,19,null,19,-33.206841595400142,4.8322706620441336,null,null,null,null,19,287.39204235627295,null,19,-33.206841595400142,4.8322706620441336,null,null,null,null,19,287.39204235627295,null,19,-27.894224864334898,3.4097670202564343,228.19382560734675,null,19,34.5,22.2775,""]
[null,"","",20,34,37,39,40,36,35,38,38,null,36,3,3,37,null,2,413,39.234999999999992,41.330177142521109,41.330177142521109,0.41895843824880719,0.41895843824880719,null,20,null,20,8.6983935236475585,22.073483813971603,null,null,null,null,20,4.3897672585429497,null,20,8.6983935236475585,22.073483813971603,null,null,null,null,20,4.3897672585429497,null,20,7.3067757501125614,15.57558390142114,3.4277348573469335,null,20,37,39.234999999999992,""]
[null,"","",21,38,39,null,42,36,38,36,41,37,38,3.6666666666666643,2.3333333333333357,38.333333333333336,null,2,457,43.414999999999999,42.450196332309545,42.450196332309545,-0.19292528045906734,-0.19292528045906734,null,21,null,21,36.378933432944692,36.379908606110725,null,null,null,null,21,0.93084611718895183,null,21,36.378933432944692,36.379908606110725,null,null,null,null,21,0.93084611718895183,null,21,30.558827661700686,25.67054315467189,36.377958285918432,null,21,38.333333333333336,43.414999999999999,""]
[null,"","",22,34,37,34,null,33,null,35,34,null,null,2.5,1.5,34.5,null,2,362.9,34.475499999999997,39.230141161667788,39.230141161667788,0.95075351630119065,0.95075351630119065,null,22,null,22,-6.3926779899578987,4.8322706620441336,null,null,null,null,22,22.606612576225647,null,22,-6.3926779899578987,4.8322706620441336,null,null,null,null,22,22.606612576225647,null,22,-5.3699415171682876,3.4097670202564343,8.4569625216326347,null,22,34.5,34.475499999999997,""]
[null,"","",23,39,36,39,36,null,37,null,39,null,40,2,2,38,null,2,357.8,33.991,42.17019153486244,42.17019153486244,1.6355377509800679,1.6355377509800679,null,23,null,23,-19.331776544379643,32.469969074742586,null,null,null,null,23,66.899174163965398,null,23,-19.331776544379643,32.469969074742586,null,null,null,null,23,66.899174163965398,null,23,-16.238970526805439,22.911595281579046,11.509637828775469,null,23,38,33.991,""]
[null,"","",24,29,null,30,26,null,28,28,30,28,28,1.625,2.375,28.375,null,1,312.5,29.6875,34.085053008577141,34.085053008577141,0.87934900739365707,0.87934900739365707,null,24,null,24,30.220661295756326,15.419423439821838,null,null,null,null,24,19.338472463245864,null,24,30.220661295756326,15.419423439821838,null,null,null,null,24,19.338472463245864,null,24,25.385790434507886,10.880318010629079,59.229735321632553,null,24,28.375,29.6875,""]
[null,"","",25,28,26,30,24,26,26,null,26,29,25,3.3333333333333321,2.6666666666666679,26.666666666666668,null,1,312.8,29.716000000000001,32.650028421660707,32.650028421660707,0.58669786929684065,0.58669786929684065,null,25,null,25,43.207540972627051,31.754247230449167,null,null,null,null,25,8.608522779112814,null,25,43.207540972627051,31.754247230449167,null,null,null,null,25,8.608522779112814,null,25,36.294956274684381,22.406564642563328,58.791870685918255,null,25,26.666666666666668,29.716000000000001,""]
[null,"","",26,38,38,34,38,37,37,36,37,35,36,1.3999999999999986,2.6000000000000014,36.6,null,2,458,43.51,40.994171385584579,40.994171385584579,-0.50307327519277834,-0.50307327519277834,null,26,null,26,26.332815054259864,18.47488970966322,null,null,null,null,26,6.3293936171114069,null,26,26.332815054259864,18.47488970966322,null,null,null,null,26,6.3293936171114069,null,26,22.119943636440723,13.03632888978872,37.532952000204133,null,26,36.6,43.51,""]
[null,"","",27,33,32,30,31,32,34,null,32,null,31,2.125,1.875,31.875,null,1,433,41.134999999999998,37.0251033817718,37.0251033817718,-0.82182829966587712,-0.82182829966587712,null,27,null,27,-1.6009436929057128,0.18212185252029242,null,null,null,null,27,16.89125021252358,null,27,-1.6009436929057128,0.18212185252029242,null,null,null,null,27,16.89125021252358,null,27,-1.3448157433688561,0.12850958272461238,14.073109143061258,null,27,31.875,41.134999999999998,""]
[null,"","",28,34,null,36,32,37,36,null,null,34,34,2.2857142857142847,2.7142857142857153,34.714285714285715,null,2,467,44.365000000000002,39.410144245740923,39.410144245740923,-0.99078907765030533,-0.99078907765030533,null,28,null,28,16.842859850178236,5.8202930138420035,null,null,null,null,28,24.550595545514302,null,28,16.842859850178236,5.8202930138420035,null,null,null,null,28,24.550595545514302,null,28,14.148244682337621,4.10693948141392,48.740145428775627,null,28,34.714285714285715,44.365000000000002,""]
[null,"","",29,28,27,31,31,29,28,null,32,28,33,3.3333333333333321,2.6666666666666679,29.666666666666668,null,1,377.4,35.853000000000002,35.170071598684693,35.170071598684693,-0.13656058509044786,-0.13656058509044786,null,29,null,29,4.0332321857790419,6.9437030127621338,null,null,null,null,29,0.46639120132308309,null,29,4.0332321857790419,6.9437030127621338,null,null,null,null,29,0.46639120132308309,null,29,3.3879730837086734,4.8996447399649439,2.3426926287754863,null,29,29.666666666666668,35.853000000000002,""]
[null,"","",30,null,null,35,34,null,null,null,33,37,36,2,2,35,null,2,366.1,34.779499999999999,39.650148357838447,39.650148357838447,0.9739506926863809,0.9739506926863809,null,30,null,30,-7.0264550874635594,7.2805132924296272,null,null,null,null,30,23.723215425714368,null,30,-7.0264550874635594,7.2805132924296272,null,null,null,null,30,23.723215425714368,null,30,-5.9023234006093386,5.1373062171487787,6.7812624073469125,null,30,35,34.779499999999999,""]
[null,"","",31,null,32,34,34,30,35,null,30,32,32,2.625,2.375,32.375,null,2,353.7,33.601499999999994,37.445110577942458,37.445110577942458,0.76858087666691888,0.76858087666691888,null,31,null,31,-0.27700990605768411,5.3644829057860324E-3,null,null,null,null,31,14.773342274871199,null,31,-0.27700990605768411,5.3644829057860324E-3,null,null,null,null,31,14.773342274871199,null,31,-0.23269230790957057,3.7853088479816803E-3,14.304172350204077,null,31,32.375,33.601499999999994,""]
[null,"","",32,30,null,32,null,30,null,33,30,32,30,2,1,31,null,1,454,43.129999999999995,36.29009078847313,36.29009078847313,-1.3677305001412521,-1.3677305001412521,null,32,null,32,-7.4804371452866532,1.6945722493456785,null,null,null,null,32,46.784358021930075,null,32,-7.4804371452866532,1.6945722493456785,null,null,null,null,32,46.784358021930075,null,32,-6.2836748630454853,1.1957311527778562,33.021277143061248,null,32,31,43.129999999999995,""]
[null,"","",33,37,34,33,32,34,36,30,32,35,33,3.3999999999999986,3.6000000000000014,33.6,null,2,423,40.184999999999995,38.474128208560586,38.474128208560586,-0.34211148987760098,-0.34211148987760098,null,33,null,33,3.6369154510852191,1.685433927350249,null,null,null,null,33,2.9270822867430932,null,33,3.6369154510852191,1.685433927350249,null,null,null,null,33,2.9270822867430932,null,33,3.0550613226401344,1.1892829318192724,7.8479220002040897,null,33,33.6,40.184999999999995,""]
[null,"","",34,34,null,null,null,32,30,35,32,30,34,2.5714285714285694,2.4285714285714306,32.428571428571431,null,2,398.8,37.886000000000003,37.490111348960745,37.490111348960745,-7.916318271793224E-2,-7.916318271793224E-2,null,34,null,34,6.3713194849373544E-2,1.6081805549130249E-2,null,null,null,null,34,0.15672782402168292,null,34,6.3713194849373544E-2,1.6081805549130249E-2,null,null,null,null,34,0.15672782402168292,null,34,5.352000065552083E-2,1.134771084291953E-2,0.25242011448980506,null,34,32.428571428571431,37.886000000000003,""]
[null,"","",35,null,36,null,35,34,37,31,null,34,36,2.2857142857142847,3.7142857142857153,34.714285714285715,null,2,448,42.559999999999995,39.410144245740923,39.410144245740923,-0.62985540493509795,-0.62985540493509795,null,35,null,35,12.488246188046688,5.8202930138420035,null,null,null,null,35,9.9215912726389863,null,35,12.488246188046688,5.8202930138420035,null,null,null,null,35,9.9215912726389863,null,35,10.490306533060943,4.10693948141392,26.795264857346954,null,35,34.714285714285715,42.559999999999995,""]
[null,"","",36,null,null,null,null,null,null,null,null,null,null,"","","",null,"",null,"","","",{"$f":"IFERROR(((V43-U43)/$AK$58),\"\")","v":""},{"$f":"IFERROR(((W43-U43)/$AU$58),\"\")","v":""},null,36,null,36,"","",null,null,null,null,36,"",null,36,"","",null,null,null,null,36,"",null,36,"","","",null,36,"","",""]
[null,"","",37,null,null,null,null,null,null,null,null,null,null,"","","",null,"",null,"","","","","",null,37,null,37,"","",null,null,null,null,37,"",null,37,"","",null,null,null,null,37,"",null,37,"","","",null,37,"","",""]
[null,"","",38,null,null,null,null,null,null,null,null,null,null,"","","",null,"",null,"","","","","",null,38,null,38,"","",null,null,null,null,38,"",null,38,"","",null,null,null,null,38,"",null,38,"","","",null,38,"","",""]
[null,"","",39,null,null,null,null,null,null,null,null,null,null,"","","",null,"",null,"","","","","",null,39,null,39,"","",null,null,null,null,39,"",null,39,"","",null,null,null,null,39,"",null,39,"","","",null,39,"","",""]
[null,"","",40,null,null,null,null,null,null,null,null,null,null,"","","",null,"",null,"","","","","",null,40,null,40,"","",null,null,null,null,40,"",null,40,"","",null,null,null,null,40,"",null,40,"","","",null,40,"","",""]
[null,"","",41,null,null,null,null,null,null,null,null,null,null,"","","",null,"",null,"","","","","",null,41,null,41,"","",null,null,null,null,41,"",null,41,"","",null,null,null,null,41,"",null,41,"","","",null,41,"","",""]
[null,"","",42,null,null,null,null,null,null,null,null,null,null,"","","",null,"",null,"","","","","",null,42,null,42,"","",null,null,null,null,42,"",null,42,"","",null,null,null,null,42,"",null,42,"","","",null,42,"","",""]
[null,"","",43,null,null,null,null,null,null,null,null,null,null,"","","",null,"",null,"","","","","",null,43,null,43,"","",null,null,null,null,43,"",null,43,"","",null,null,null,null,43,"",null,43,"","","",null,43,"","",""]
[null,"","",44,null,null,null,null,null,null,null,null,null,null,"","","",null,"",null,"","","","","",null,44,null,44,"","",null,null,null,null,44,"",null,44,"","",null,null,null,null,44,"",null,44,"","","",null,44,"","",""]
[null,"","",45,null,null,null,null,null,null,null,null,null,null,"","","",null,"",null,"","","","","",null,45,null,45,"","",null,null,null,null,45,"",null,45,"","",null,null,null,null,45,"",null,45,"","","",null,45,"","",""]
[null,"","",46,null,null,null,null,null,null,null,null,null,null,"","","",null,"",null,"","","","","",null,46,null,46,"","",null,null,null,null,46,"",null,46,"","",null,null,null,null,46,"",null,46,"","","",null,46,"","",""]
[null,"","",47,null,null,null,null,null,null,null,null,null,null,"","","",null,"",null,"","","","","",null,47,null,47,"","",null,null,null,null,47,"",null,47,"","",null,null,null,null,47,"",null,47,"","","",null,47,"","",""]
[null,"","",48,null,null,null,null,null,null,null,null,null,null,"","","",null,"",null,"","","","","",null,48,null,48,"","",null,null,null,null,48,"",null,48,"","",null,null,null,null,48,"",null,48,"","","",null,48,"","",""]
[null,"","",49,null,null,null,null,null,null,null,null,null,null,"","","",null,"",null,"","","","","",null,49,null,49,"","",null,null,null,null,49,"",null,49,"","",null,null,null,null,49,"",null,49,"","","",null,49,"","",""]
[null,"","",50,null,null,null,null,null,null,null,null,null,null,"","","",null,"",null,"","","","","",null,50,null,50,"","",null,null,null,null,50,"",null,50,"","",null,null,null,null,50,"",null,50,"","","",null,50,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IFERROR(SUM(R8:R57)/COUNT(R8:R57),SUM(Q8:Q57)/COUNT(Q8:Q57)),\"\")","v":32.301757369614506},null,null,null,{"$f":"IFERROR(SUM(U8:U57)/COUNT(U8:U57),\"\")","v":37.383585714285708},null,{"$f":"IFERROR(SUM(W8:W57)/COUNT(W8:W57),\"\")","v":37.383585714285708},null,null,null,null,null,null,{"$f":"IF(SUM(AD8:AD57)=0,\"\",SUM(AD8:AD57))","v":356.09109849773245},{"$f":"IF(SUM(AE8:AE57)=0,\"\",SUM(AE8:AE57))","v":423.91071122628955},null,null,null,null,"Sт",{"$f":"IF(SQRT(SUM(AK8:AK57)/(COUNT(AK8:AK57)-2))=0,\"\",SQRT(SUM(AK8:AK57)/(COUNT(AK8:AK57)-2)))","v":5.000918829272635},null,null,{"$f":"IF(SUM(AN8:AN57)=0,\"\",SUM(AN8:AN57))","v":356.09109849773245},{"$f":"IF(SUM(AO8:AO57)=0,\"\",SUM(AO8:AO57))","v":423.91071122628955},null,null,null,null,"Sт",{"$f":"IF(SQRT(SUM(AU8:AU57)/(COUNT(AU8:AU57)-2))=0,\"\",SQRT(SUM(AU8:AU57)/(COUNT(AU8:AU57)-2)))","v":5.000918829272635},null,null,{"$f":"IF(SUM(AX8:AX57)=0,\"\",SUM(AX8:AX57))","v":299.12164772272916},{"$f":"IF(SUM(AY8:AY57)=0,\"\",SUM(AY8:AY57))","v":299.12164772272928},{"$f":"IF(SUM(AZ8:AZ57)=0,\"\",SUM(AZ8:AZ57))","v":1124.4248892428568}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ср.зн. H",null,null,null,"cр.зн Rф (Мпа)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sп < 1,5 Sт",null,null,null,null,null,null,null,null,null,"Sп < 1,5 Sт",null,null,null,null,{"$f":"IFERROR(SQRT(AY58),\"\")","v":17.295133642812051},{"$f":"IFERROR(SQRT(AZ58),\"\")","v":33.532445321551734}]
[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,null,null,null,null,null,null,null,null,null,null,"Sп",{"$f":"IFERROR((AK58*1.5)-(SQRT(SUM(AK8:AK57)/(COUNT(AK8:AK57)-1))),\"\")","v":2.5745511969555075},null,null,null,null,null,null,null,null,"Sп",{"$f":"IFERROR((AU58*1.5)-(SQRT(SUM(AU8:AU57)/(COUNT(AU8:AU57)-1))),\"\")","v":2.5745511969555075},null,null,null,{"$f":"IFERROR(AY59*AZ59,\"\")","v":579.94812320652488}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AX58/AY60,\"\")","v":0.51577311099635925}]
[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,null,null,null,null,null,null,null,null,"ПОГРЕШНОСТЬ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"r < 0,7"]
[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,null,null,null,null,null,null,null,null,"Sт",{"$f":"IF(AU58=0,\"\",AU58)","v":5.000918829272635},{"$f":"IFERROR(AI63/AI64*100,\"\")","v":13.37731181672493},null,null,null,"< 12%"]
[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,null,null,null,null,null,null,null,null,"Rф",{"$f":"IF(W58=0,\"\",W58)","v":37.383585714285708},null,null,null,null,"> 15%"]
[]
[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,null,null,null,null,null,null,null,null,"Н","RH"]
[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,null,null,null,null,null,null,null,null,5,{"$f":"IFERROR($AQ$10+$AR$8*$AH$67,\"\")","v":14.449716587598562}]
[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,null,null,null,null,null,null,null,null,10,{"$f":"IFERROR($AQ$10+$AR$8*$AH$68,\"\")","v":18.64978854930521}]
[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,null,null,null,null,null,null,null,null,15,{"$f":"IFERROR($AQ$10+$AR$8*$AH$69,\"\")","v":22.849860511011858}]
[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,null,null,null,null,null,null,null,null,20,{"$f":"IFERROR($AQ$10+$AR$8*$AH$70,\"\")","v":27.049932472718506}]
[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,null,null,null,null,null,null,null,null,25,{"$f":"IFERROR($AQ$10+$AR$8*$AH$71,\"\")","v":31.250004434425154}]
[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,null,null,null,null,null,null,null,null,30,{"$f":"IFERROR($AQ$10+$AR$8*$AH$72,\"\")","v":35.450076396131806}]
[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,null,null,null,null,null,null,null,null,35,{"$f":"IFERROR($AQ$10+$AR$8*$AH$73,\"\")","v":39.650148357838447}]
[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,null,null,null,null,null,null,null,null,40,{"$f":"IFERROR($AQ$10+$AR$8*$AH$74,\"\")","v":43.850220319545102}]
[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,null,null,null,null,null,null,null,null,45,{"$f":"IFERROR($AQ$10+$AR$8*$AH$75,\"\")","v":48.050292281251743}]
[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,null,null,null,null,null,null,null,null,50,{"$f":"IFERROR($AQ$10+$AR$8*$AH$76,\"\")","v":52.250364242958398}]