{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["КИТАЕВ склерометр"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":1,"defined_names":2,"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":55,"rows_kept":76,"cut":false,"hidden":false,"merged":[[58,43,58,44],[60,46,60,49],[61,31,61,38],[61,46,61,49],[62,33,63,36],[62,37,62,38],[63,37,63,38],[11,29,12,32],[11,39,12,42],[13,29,15,32],[13,39,15,42],[57,14,57,15],[58,14,58,15],[58,33,58,34],[5,52,6,52],[5,54,6,54],[6,26,6,28],[6,36,6,38],[6,47,6,49],[7,29,8,29],[7,31,8,31],[7,39,8,39],[7,41,8,41],[3,16,6,16],[3,17,5,18],[3,19,5,20],[3,21,5,22],[3,23,6,23],[3,51,4,54],[5,26,5,34],[5,36,5,44],[5,47,5,49],[5,51,6,51],[0,15,1,17],[0,18,1,18],[0,19,1,19],[0,20,1,20],[0,21,1,21],[3,1,6,1],[3,2,6,11],[3,12,6,12],[3,13,6,13],[3,14,6,15]]}
[null,"Кубы",null,null,null,null,null,null,null,null,null,null,null,null,null,"Кубы",null,null,{"$f":"IF(P1=\"Отрыв со скалыванием\",2.5,\"\")","v":""},{"$f":"IF(P1=\"Кубы\",10,\"\")","v":10},{"$f":"IF(P1=\"Кубы\",0.95,\"\")","v":0.95},{"$f":"IF(P1=\"Кубы\",100,\"\")","v":100}]
[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,"Показания","Показания                             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":"U58","v":38.367673455068307},null,null,null,null,null,"Показания Riф  (Мпа)"]
[null,1,22,null,24,20,21,21,22,null,25,24,{"$f":"IFERROR(MAX(C8:L8)-AVERAGE(C8:L8),\"\")","v":2.625},{"$f":"IFERROR(AVERAGE(C8:L8)-MIN(C8:L8),\"\")","v":2.375},{"$f":"IFERROR(AVERAGE(C8:L8),\"\")","v":22.375},null,{"$f":"IFERROR(IF(SUM(O8:P8)=0,\"\",IF(SUM(O8:P8)<=$O$58,1,2)),\"\")","v":1},349.8,{"$f":"IF(R8=\"\",\"\",(IF($P$1=$B$1,((R8*$T$1)/$V$1)*$U$1,IF($P$1=$B$2,R8*$S$1,\"\"))))","v":33.230999999999995},{"$f":"IF(SUM(O8:P8)=0,\"\",$AF$8*SUM(O8:P8)+($AE$10))","v":37.279010016609085},{"$f":"IF(SUM(O8:P8)=0,\"\",$AP$8*SUM(O8:P8)+($AO$10))","v":38.071432203245813},{"$f":"IFERROR(((T8-S8)/$AI$58),\"\")","v":0.73201213789136765},{"$f":"IFERROR(((U8-S8)/$AS$58),\"\")","v":0.85742517516710448},{"$f":"IF(COUNT(V8:W8)=0,\"\",IF(V8>2,\"Отбраковывается\",IF(W8>2,\"Отбраковывается\",IF(V8<-2,\"Отбраковывается\",IF(W8<-2,\"Отбраковывается\",\"\")))))","v":""},1,null,1,{"$f":"IF(SUM(O8:P8)=0,\"\",(SUM(O8:P8)-$O$58)*(S8-$S$58))","v":40.148300392128277},{"$f":"IF(SUM(O8:P8)=0,\"\",POWER((SUM(O8:P8)-$P$58),2))","v":500.640625},"а1=",{"$f":"IF(AB58=0,\"\",AB58)","v":382.946397521704},{"$f":"IFERROR(AE8/AE9,\"\")","v":1.0816386845569893E-2},null,1,{"$f":"IFERROR(POWER(S8-T8,2),\"\")","v":16.38638509456753},null,1,{"$f":"IF(SUM(O8:P8)=0,\"\",(SUM(O8:P8)-$P$58*(S8-$S$58)))","v":22.375},{"$f":"IF(SUM(O8:P8)=0,\"\",POWER((SUM(O8:P8)-$P$58),2))","v":500.640625},"а1=",{"$f":"IF(AL58=0,\"\",AL58)","v":1088.3892857142857},{"$f":"IFERROR(AO8/AO9,\"\")","v":3.0741742523356663E-2},null,1,{"$f":"IFERROR(POWER(S8-U8,2),\"\")","v":23.429783914219165},null,1,{"$f":"IFERROR((U8-$U$58)*(S8-$U$58),\"\")","v":1.5216945745328108},{"$f":"IFERROR(POWER((U8-$U$58),2),\"\")","v":8.7758879281358143E-2},{"$f":"IFERROR(POWER((S8-$U$58),2),\"\")","v":26.38541418400343},null,1,{"$f":"IF(SUM(O8:P8)=0,\"\",SUM(O8:P8))","v":22.375},{"$f":"IF(S8=0,\"\",S8)","v":33.230999999999995},{"$f":"IF(X8=\"Отбраковывается\",S8,\"\")","v":""}]
[null,{"$f":"B8+1","v":2},22,25,null,24,22,21,23,20,19,20,{"$f":"IFERROR(MAX(C9:L9)-AVERAGE(C9:L9),\"\")","v":3.2222222222222214},{"$f":"IFERROR(AVERAGE(C9:L9)-MIN(C9:L9),\"\")","v":2.7777777777777786},{"$f":"IFERROR(AVERAGE(C9:L9),\"\")","v":21.777777777777779},null,{"$f":"IFERROR(IF(SUM(O9:P9)=0,\"\",IF(SUM(O9:P9)<=$O$58,1,2)),\"\")","v":1},346.1,{"$f":"IF(R9=\"\",\"\",(IF($P$1=$B$1,((R9*$T$1)/$V$1)*$U$1,IF($P$1=$B$2,R9*$S$1,\"\"))))","v":32.8795},37.272550230020762,{"$f":"IF(SUM(O9:P9)=0,\"\",$AP$8*SUM(O9:P9)+($AO$10))","v":38.053072551461028},{"$f":"IFERROR(((T9-S9)/$AI$58),\"\")","v":0.79440665352785456},{"$f":"IFERROR(((U9-S9)/$AS$58),\"\")","v":0.9164370380400344},"",{"$f":"Y8+1","v":2},null,{"$f":"AA8+1","v":2},{"$f":"IF(SUM(O9:P9)=0,\"\",(SUM(O9:P9)-$O$58)*(S9-$S$58))","v":46.236635726595331},474.27160493827165,null,{"$f":"IF(AC58=0,\"\",AC58)","v":35404.280836955157},null,null,{"$f":"AH8+1","v":2},19.29889032348547,null,{"$f":"AK8+1","v":2},21.777777777777779,474.27160493827165,null,{"$f":"IF(AM58=0,\"\",AM58)","v":35404.280836955157},null,null,{"$f":"AR8+1","v":2},26.765852945230971,null,{"$f":"AU8+1","v":2},1.7265843281179678,9.8973728550516032E-2,30.120047872916391,null,{"$f":"AZ8+1","v":2},21.777777777777779,{"$f":"IF(S9=0,\"\",S9)","v":32.8795},""]
[null,{"$f":"B9+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,37.332641268051702,38.223860009924124,0.31051510384871805,0.46204005024765488,"",{"$f":"Y9+1","v":3},null,{"$f":"AA9+1","v":3},8.3275634363459545,747.11111111111109,"а0=",{"$f":"IFERROR(S58-AF8*O58,\"\")","v":37.036993360939462},null,null,{"$f":"AH9+1","v":3},2.9485741344462175,null,{"$f":"AK9+1","v":3},27.333333333333332,747.11111111111109,"а0=",{"$f":"IFERROR(S58-AP8*P58,\"\")","v":37.383585714285708},null,null,{"$f":"AR9+1","v":3},6.8035419413713898,null,{"$f":"AU9+1","v":3},0.39579954620774177,2.0682307004238815E-2,7.5744587267826349,null,{"$f":"AZ9+1","v":3},27.333333333333332,35.615499999999997,""]
[null,{"$f":"B10+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,37.343457654897279,38.254601752447478,0.68525744452920345,0.83265586868057473,"",{"$f":"Y10+1","v":4},null,{"$f":"AA10+1","v":4},14.207502483964992,802.77777777777771,null,null,null,null,{"$f":"AH10+1","v":4},14.359989318259567,null,{"$f":"AK10+1","v":4},28.333333333333332,802.77777777777771,null,null,null,null,{"$f":"AR10+1","v":4},22.09565683511228,null,{"$f":"AU10+1","v":4},0.54429025342526072,1.2785209933573136E-2,23.171452132029227,null,{"$f":"AZ10+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,37.380027343756105,38.358538120026445,0.44277354261336116,0.60705917095535711,"",5,null,5,0.8066861574344002,1005.795918367347,"Уровнение градуировочной зависимости ",null,null,null,5,5.9952861531213264,null,5,31.714285714285715,1005.795918367347,"Уровнение градуировочной зависимости ",null,null,null,5,11.744590276114392,null,5,3.139059577399974E-2,8.3454346327062302E-5,11.807288013316064,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,37.420975093957196,38.474917573864872,-1.6851834151955978,-1.4640613584562538,"",6,null,6,32.342641871720133,1260.25,null,null,null,null,6,86.844225199446129,null,6,35.5,1260.25,null,null,null,null,6,68.311587510807769,null,6,0.89788278258829057,1.1501301016451778E-2,70.095851774967898,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,null,null,{"$f":"IFERROR(((T14-S14)/$AI$58),\"\")","v":-8.8815926850524942},-8.7001399276067257,"Отбраковывается",7,null,7,null,null,{"$f":"\"Rн = \" &   FIXED( AF8,2) & \" * H + \" & FIXED(AE10,2)","v":"Rн = 0,01 * H + 37,04"},null,null,null,7,null,null,7,null,null,{"$f":"\"Rн = \" & FIXED(AP8,2) & \" * H + \" & FIXED(AO10,2)","v":"Rн = 0,03 * H + 37,38"},null,null,null,7,null,null,7,null,null,null,null,7,33.125,49.115000000000002,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,{"$f":"IF(SUM(O15:P15)=0,\"\",$AF$8*SUM(O15:P15)+($AE$10))","v":37.406295711809634},{"$f":"IF(SUM(O15:P15)=0,\"\",$AP$8*SUM(O15:P15)+($AO$10))","v":38.433196637583173},-0.58837577532964391,-0.39445181399351559,"",8,null,8,{"$f":"IF(SUM(O15:P15)=0,\"\",(SUM(O15:P15)-$O$58)*(S15-$S$58))","v":6.8791326880466599},{"$f":"IF(SUM(O15:P15)=0,\"\",POWER((SUM(O15:P15)-$P$58),2))","v":1165.7346938775513},null,null,null,null,8,10.586591594988358,null,8,{"$f":"IF(SUM(O15:P15)=0,\"\",(SUM(O15:P15)-$P$58*(S15-$S$58)))","v":34.142857142857146},{"$f":"IF(SUM(O15:P15)=0,\"\",POWER((SUM(O15:P15)-$P$58),2))","v":1165.7346938775513},null,null,null,null,8,4.9586532148708731,null,8,{"$f":"IFERROR((U15-$U$58)*(S15-$U$58),\"\")","v":0.15020053058723154},{"$f":"IFERROR(POWER((U15-$U$58),2),\"\")","v":4.2932874468764558E-3},{"$f":"IFERROR(POWER((S15-$U$58),2),\"\")","v":5.2547609885984601},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,{"$f":"IF(SUM(O16:P16)=0,\"\",$AF$8*SUM(O16:P16)+($AE$10))","v":37.370949304796433},{"$f":"IF(SUM(O16:P16)=0,\"\",$AP$8*SUM(O16:P16)+($AO$10))","v":38.332737014694345},0.56310351963970917,0.72196848897418164,"",9,null,9,3.6526816166180738,953.265625,null,null,null,null,9,9.696680272842201,null,9,30.875,953.265625,null,null,null,null,9,16.611632212949591,null,9,0.14361229805981976,1.2205548660033584E-3,16.897636254203224,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,{"$f":"IF(SUM(O17:P17)=0,\"\",$AF$8*SUM(O17:P17)+($AE$10))","v":37.373653401507823},{"$f":"IF(SUM(O17:P17)=0,\"\",$AP$8*SUM(O17:P17)+($AO$10))","v":38.340422450325185},0.9861982725774926,1.1373017145918105,"",10,null,10,5.0170212084548114,968.765625,null,null,null,null,10,29.742335423777874,null,10,31.125,968.765625,null,null,null,null,10,41.221824440639679,null,10,0.17570557990616276,7.4261725950961106E-4,41.572492983192497,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,37.357879504024702,38.295590742478623,0.4920236892976696,0.64807597266437134,"",11,null,11,6.5275318717201003,880.1111111111112,null,null,null,null,11,7.4031852754217038,null,11,29.666666666666668,880.1111111111112,null,null,null,null,11,13.385286220950281,null,11,0.26891706242764923,5.1959174542868785E-3,13.917924428351292,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.383117739997701,38.367321475033123,-0.28334337816909094,-0.10321459228389056,"",12,null,12,-6.7771393586007422E-2,1024,null,null,null,null,12,2.4551200167098992,null,12,32,1024,null,null,null,null,12,0.33951426345757096,null,12,-2.0496731777356635E-4,1.2388994516804916E-7,0.33910420493207866,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,37.326331709058458,38.205927326785499,1.0205887085990206,1.1555478071995788,"",13,null,13,30.177359218658857,715.5625,null,null,null,null,13,31.852836360173701,null,13,26.75,715.5625,null,null,null,null,13,42.555104087851788,null,13,1.0813009232562971,2.6161810014478398E-2,44.691544124349903,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,37.335796047548328,38.232826351493436,0.6941794338860563,0.83889548876799613,"",14,null,14,17.171966820699684,763.140625,null,null,null,null,14,14.736355094672668,null,14,27.625,763.140625,null,null,null,null,14,22.428051231499634,null,14,0.65679620787496673,1.8183741342531763E-2,23.723459905907035,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,37.415566900534408,38.459546702603191,-0.91310206820473527,-0.70951856176007377,"",15,null,15,15.024393912536468,1225,null,null,null,null,15,25.49677462597873,null,15,35,1225,null,null,null,null,15,16.043656117626995,null,15,0.3764346958937636,8.4406936126061941E-3,16.788084815801916,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,37.449097699755676,38.5548461044256,-1.1303668562522193,-0.91140301008995384,"",16,null,16,38.25684554518952,1451.6100000000001,null,null,null,null,16,39.073779567199729,null,16,38.1,1451.6100000000001,null,null,null,null,16,26.47260860914438,null,16,0.99806568665308804,3.5033600667428381E-2,28.433706381783125,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,37.403548692928219,38.425389210910573,-1.4306482348984566,-1.2204128659641043,"",17,null,17,14.638405250404899,1148.4567901234566,null,null,null,null,17,62.591061784167763,null,17,33.888888888888886,1148.4567901234566,null,null,null,null,17,47.466736825137396,null,17,0.40097020262377758,3.3311084724441725E-3,48.265346121912508,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.392131395702343,38.392939593802588,0.34704150189808652,0.51723267934931616,"",18,null,18,{"$f":"IF(SUM(O25:P25)=0,\"\",(SUM(O25:P25)-$O$58)*(S25-$S$58))","v":-1.5094926861030111},{"$f":"IF(SUM(O25:P25)=0,\"\",POWER((SUM(O25:P25)-$P$58),2))","v":1078.0277777777778},null,null,null,null,18,3.6830653139704266,null,18,32.833333333333336,1078.0277777777778,null,null,null,null,18,8.5260472314560261,null,18,-7.3137221106196915E-2,6.3837776653994402E-4,8.3791344114770929,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,37.41015870711162,38.444175831341511,2.7364778759743151,2.8637349464914776,"Отбраковывается",19,null,19,-37.111644862973733,1190.25,null,null,null,null,19,228.99735954592114,null,19,34.5,1190.25,null,null,null,null,19,261.36140743568171,null,19,-1.230936503960758,5.8526135754469197E-3,258.89368181418479,null,19,34.5,22.2775,22.2775]
[null,20,34,37,39,40,36,35,38,38,null,36,3,3,37,null,2,413,39.234999999999992,37.437199674225546,38.521030187649906,-0.32510089020835409,-0.12647128721435139,"",20,null,20,9.1769694227405161,1369,null,null,null,null,20,3.2320860113547045,null,20,37,1369,null,null,null,null,20,0.5097528929472176,null,20,0.13301036501201113,2.35182874281042E-2,0.75225533554313562,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,37.451621523352976,38.562019177681044,-1.0783731783851711,-0.8596480142556624,"",21,null,21,37.938006157434444,1469.4444444444446,null,null,null,null,21,35.561882855736968,null,21,38.333333333333336,1469.4444444444446,null,null,null,null,21,23.551422861795558,null,21,0.98092632463720331,3.7770259897867246E-2,25.475505251172098,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,37.41015870711162,38.444175831341511,0.53068193639841599,0.70300386969321227,"",22,null,22,-7.1443950670553837,1190.25,null,null,null,null,22,8.6122217272260642,null,22,34.5,1190.25,null,null,null,null,22,15.750387854274258,null,22,-0.29776051818021315,5.8526135754469197E-3,15.149014204338384,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,37.448016061071115,38.55177193017326,0.62514116990976698,0.80788667352964205,"",23,null,23,-20.208733026239027,1444,null,null,null,null,23,11.950960046503651,null,23,38,1444,null,null,null,null,23,20.800640599056326,null,23,-0.80573890911040247,3.3892248535969095E-2,19.15527053229955,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,37.343908337682507,38.25588265838595,1.3845281540412475,1.517787398579592,"",24,null,24,28.231284218658878,805.140625,null,null,null,null,24,58.620588633334208,null,24,28.375,805.140625,null,null,null,null,24,73.417181380529072,null,24,0.9703635058831297,1.2497182222875988E-2,75.345411210072456,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,{"$f":"IF(SUM(O32:P32)=0,\"\",$AF$8*SUM(O32:P32)+($AE$10))","v":37.325430343487994},{"$f":"IF(SUM(O32:P32)=0,\"\",$AP$8*SUM(O32:P32)+($AO$10))","v":38.203365514908555},1.3760330016520297,1.5034361721764902,"",25,null,25,41.225530919339121,711.1111111111112,null,null,null,null,25,57.903430152395799,null,25,{"$f":"IF(SUM(O32:P32)=0,\"\",(SUM(O32:P32)-$P$58*(S32-$S$58)))","v":26.666666666666668},{"$f":"IF(SUM(O32:P32)=0,\"\",POWER((SUM(O32:P32)-$P$58),2))","v":711.1111111111112},null,null,null,null,25,72.035373383658936,null,25,1.4215386443370763,2.6997099199540582E-2,74.851453573133554,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,37.432873119487319,{"$f":"IF(SUM(O33:P33)=0,\"\",$AP$8*SUM(O33:P33)+($AO$10))","v":38.508733490640559},-1.0989425969275637,-0.8859150655946324,"",26,null,26,27.916444524781365,1339.5600000000002,null,null,null,null,26,36.931471121849768,null,26,36.6,1339.5600000000002,null,null,null,null,26,{"$f":"IFERROR(POWER(S33-U33,2),\"\")","v":25.012666697640352},null,26,0.7253767653522013,1.989793363564506E-2,26.443522294709108,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.381765691642002,38.363478757217699,-0.67870708293597537,-0.49094212815922816,"",27,null,27,{"$f":"IF(SUM(O34:P34)=0,\"\",(SUM(O34:P34)-$O$58)*(S34-$S$58))","v":-0.63123287317784693},{"$f":"IF(SUM(O34:P34)=0,\"\",POWER((SUM(O34:P34)-$P$58),2))","v":1016.015625},null,null,null,null,27,{"$f":"IFERROR(POWER(S34-T34,2),\"\")","v":14.086767773435524},null,27,31.875,1016.015625,null,null,null,null,27,7.6813299991935393,null,27,-1.1608098709954195E-2,1.7595490057891633E-5,7.6580962062835729,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,37.412476504292819,38.450763347596521,-1.2572428346152602,-1.0476369019829108,"",28,null,28,18.647500034985445,1205.0816326530612,null,null,null,null,28,48.337582958360429,null,28,34.714285714285715,1205.0816326530612,null,null,null,null,28,34.978195180632738,null,28,0.49831721807498075,6.903930240350185E-3,35.967925686542351,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,37.357879504024702,38.295590742478623,0.27213125918418407,0.43267598993058765,"",29,null,29,3.6375879261418662,880.1111111111112,null,null,null,null,29,2.2646623216336272,null,29,29.666666666666668,880.1111111111112,null,null,null,null,29,5.9662495352422642,null,29,{"$f":"IFERROR((U36-$U$58)*(S36-$U$58),\"\")","v":0.18126448391859437},{"$f":"IFERROR(POWER((U36-$U$58),2),\"\")","v":5.1959174542868785E-3},{"$f":"IFERROR(POWER((S36-$U$58),2),\"\")","v":6.3235825856251662},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,37.415566900534408,38.459546702603191,0.47668680649690337,0.65187664161204328,"",30,null,30,-7.6995905772594577,1225,null,null,null,null,30,6.9488487040930869,null,30,35,1225,null,null,null,null,30,13.542743733340629,null,30,-0.32965714803559304,8.4406936126061941E-3,12.874988743656838,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.38717388506479,38.378849628479379,0.6845732156283364,0.84625084497344305,"",31,null,31,-1.2546490466472264,1048.140625,null,null,null,null,31,14.331326764061584,null,31,32.375,1048.140625,null,null,null,null,31,22.823069472732119,null,31,-5.3267581041095975E-2,1.2490685211437308E-4,22.716409403797812,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,37.372301353152132,38.336579732509762,-1.0411795619379136,-0.84909756813582593,"",32,null,32,-5.9950346588921359,961,null,null,null,null,32,33.151093707913724,null,32,31,961,null,null,null,null,32,22.976877860786143,null,32,-0.14807846032129923,9.6681958254775857E-4,22.679754120560997,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,{"$f":"IF(SUM(O40:P40)=0,\"\",$AF$8*SUM(O40:P40)+($AE$10))","v":37.400423958950611},38.41650826307049,-0.50354209909715242,-0.31326734342060381,"",33,null,33,4.3610588104956305,1128.96,null,null,null,null,33,7.7538637283862597,null,33,33.6,1128.96,null,null,null,null,33,3.1275630235879377,null,33,8.8748792899010789E-2,2.3848384726101401E-3,3.302675770913349,null,33,{"$f":"IF(SUM(O40:P40)=0,\"\",SUM(O40:P40))","v":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.387753334360085,38.380496507543128,-9.0099235282485868E-2,8.7594193410119661E-2,"",34,null,34,0.19358330029154922,1051.6122448979593,null,null,null,null,34,0.2482497398212965,null,34,32.428571428571431,1051.6122448979593,null,null,null,null,34,0.24452679597234844,null,34,-6.1765239900696033E-3,1.6443067477203477E-4,0.23200931731743721,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,37.412476504292819,38.450763347596521,-0.93084000866555427,-0.72790255261244974,"",35,null,35,13.826308198250732,1205.0816326530612,null,null,null,null,35,26.496998138857428,null,35,34.714285714285715,1205.0816326530612,null,null,null,null,35,16.885825865456113,null,35,0.34833996206155354,6.903930240350185E-3,17.575601859338871,null,35,34.714285714285715,42.559999999999995,""]
[null,36,null,null,null,null,null,null,null,null,null,null,"","","",{"$f":"IFERROR(AVERAGE(C43:L43),\"\")","v":""},"",null,"","","","","",{"$f":"IF(COUNT(V43:W43)=0,\"\",IF(V43>2,\"Отбраковывается\",IF(W43>2,\"Отбраковывается\",IF(V43<-2,\"Отбраковывается\",IF(W43<-2,\"Отбраковывается\",\"\")))))","v":""},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,"","","","","",{"$f":"IF(COUNT(V44:W44)=0,\"\",IF(V44>2,\"Отбраковывается\",IF(W44>2,\"Отбраковывается\",IF(V44<-2,\"Отбраковывается\",IF(W44<-2,\"Отбраковывается\",\"\")))))","v":""},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,"","","","","","",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,"","","","","","",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,"","","","","","",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,"","","","","","",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,"","","","","","",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,"","","","","","",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,"","","","","","",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,"","","","","","",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,"","","","","","",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,"","","","","","",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,"","","","","","",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,"","","","","","",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,"","","","","","",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,{"$f":"IFERROR(IFERROR(SUM(P8:P57)/COUNT(P8:P57),SUM(O8:O57)/COUNT(O8:O57)),\"\")","v":32.04326530612245},null,null,null,{"$f":"IFERROR(SUM(S8:S57)/COUNT(S8:S57),\"\")","v":37.383585714285708},null,{"$f":"IFERROR(SUM(U8:U57)/COUNT(U8:U57),\"\")","v":38.367673455068307},null,null,null,null,null,null,{"$f":"IF(SUM(AB8:AB57)=0,\"\",SUM(AB8:AB57))","v":382.946397521704},{"$f":"IF(SUM(AC8:AC57)=0,\"\",SUM(AC8:AC57))","v":35404.280836955157},null,null,null,null,"Sт",{"$f":"IF(SQRT(SUM(AI8:AI57)/(COUNT(AI8:AI57)-2))=0,\"\",SQRT(SUM(AI8:AI57)/(COUNT(AI8:AI57)-2)))","v":5.529976631630424},null,null,{"$f":"IF(SUM(AL8:AL57)=0,\"\",SUM(AL8:AL57))","v":1088.3892857142857},{"$f":"IF(SUM(AM8:AM57)=0,\"\",SUM(AM8:AM57))","v":35404.280836955157},null,null,null,null,"Sт",{"$f":"IF(SQRT(SUM(AS8:AS57)/(COUNT(AS8:AS57)-2))=0,\"\",SQRT(SUM(AS8:AS57)/(COUNT(AS8:AS57)-2)))","v":5.6453115017324533},null,null,{"$f":"IF(SUM(AV8:AV57)=0,\"\",SUM(AV8:AV57))","v":11.760965398331232},{"$f":"IF(SUM(AW8:AW57)=0,\"\",SUM(AW8:AW57))","v":0.53240801361570689},{"$f":"IF(SUM(AX8:AX57)=0,\"\",SUM(AX8:AX57))","v":1042.8148652340142}]
[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(AW58),\"\")","v":0.72966294521217601},{"$f":"IFERROR(SQRT(AX58),\"\")","v":32.292644135066027}]
[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((AI58*1.5)-(SQRT(SUM(AI8:AI57)/(COUNT(AI8:AI57)-1))),\"\")","v":2.8494203980995776},null,null,null,null,null,null,null,null,"Sп",{"$f":"IFERROR((AS58*1.5)-(SQRT(SUM(AS8:AS57)/(COUNT(AS8:AS57)-1))),\"\")","v":2.9088487742704903},null,null,null,{"$f":"IFERROR(AW59*AX59,\"\")","v":23.562745828280978}]
[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(AV58/AW60,\"\")","v":0.49913390756926285}]
[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,"Sт",{"$f":"IF(AS58=0,\"\",AS58)","v":5.6453115017324533},{"$f":"IFERROR(AG63/AG64*100,\"\")","v":14.71371859006144},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,"Rф",{"$f":"IF(U58=0,\"\",U58)","v":38.367673455068307},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,"Н","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,5,{"$f":"IFERROR($AO$10+$AP$8*$AF$67,\"\")","v":37.537294426902491}]
[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($AO$10+$AP$8*$AF$68,\"\")","v":37.691003139519275}]
[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($AO$10+$AP$8*$AF$69,\"\")","v":37.844711852136058}]
[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($AO$10+$AP$8*$AF$70,\"\")","v":37.998420564752841}]
[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($AO$10+$AP$8*$AF$71,\"\")","v":38.152129277369625}]
[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($AO$10+$AP$8*$AF$72,\"\")","v":38.305837989986408}]
[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($AO$10+$AP$8*$AF$73,\"\")","v":38.459546702603191}]
[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($AO$10+$AP$8*$AF$74,\"\")","v":38.613255415219975}]
[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($AO$10+$AP$8*$AF$75,\"\")","v":38.766964127836758}]
[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($AO$10+$AP$8*$AF$76,\"\")","v":38.920672840453541}]