{"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.367306382849527},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.264884921119915},{"$f":"IF(SUM(O8:P8)=0,\"\",$AP$8*SUM(O8:P8)+($AO$10))","v":38.072799238416493},{"$f":"IFERROR(((T8-S8)/$AI$58),\"\")","v":0.82100317356971098},{"$f":"IFERROR(((U8-S8)/$AS$58),\"\")","v":0.97881767674523901},{"$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":420.05804238467766},{"$f":"IFERROR(AE8/AE9,\"\")","v":1.2277362009359208E-2},null,1,{"$f":"IFERROR(POWER(S8-T8,2),\"\")","v":16.272227556838665},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":1053.8892857142857},{"$f":"IFERROR(AO8/AO9,\"\")","v":3.0802839067297558E-2},null,1,{"$f":"IFERROR(POWER(S8-U8,2),\"\")","v":23.443019865130591},null,1,{"$f":"IFERROR((U8-$U$58)*(S8-$U$58),\"\")","v":1.512678925746181},{"$f":"IFERROR(POWER((U8-$U$58),2),\"\")","v":8.6734458122099845E-2},{"$f":"IFERROR(POWER((S8-$U$58),2),\"\")","v":26.381643258500851},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.257552607697662,{"$f":"IF(SUM(O9:P9)=0,\"\",$AP$8*SUM(O9:P9)+($AO$10))","v":38.054403098417964},{"$f":"IFERROR(((T9-S9)/$AI$58),\"\")","v":0.8910504774580984},{"$f":"IFERROR(((U9-S9)/$AS$58),\"\")","v":1.0461579216225005},"",{"$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":34214.030836955157},null,null,{"$f":"AH8+1","v":2},19.167344635768291,null,{"$f":"AK8+1","v":2},21.777777777777779,474.27160493827165,null,{"$f":"IF(AM58=0,\"\",AM58)","v":34214.030836955157},null,null,{"$f":"AR8+1","v":2},26.779622078015844,null,{"$f":"AU8+1","v":2},1.7171526415181131,9.7908465408059697E-2,30.116018895644011,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.325760174416324,38.225529982125174,0.34808356169859839,0.52764341467712461,"",{"$f":"Y9+1","v":3},null,{"$f":"AA9+1","v":3},8.3275634363459545,747.11111111111109,"а0=",{"$f":"IFERROR(S58-AF8*O58,\"\")","v":36.990178946160505},null,null,{"$f":"AH9+1","v":3},2.924989864194564,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.81225650759235,null,{"$f":"AU9+1","v":3},0.39014120445070838,2.0100547802352431E-2,7.5724383686914143,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.338037536425681,38.256332821192473,0.7701525668337319,0.95062315901140337,"",{"$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.318940077078519,null,{"$f":"AK10+1","v":4},28.333333333333332,802.77777777777771,null,null,null,null,{"$f":"AR10+1","v":4},22.11193396126394,null,{"$f":"AU10+1","v":4},0.53414975265144637,1.2315131386852106E-2,23.16791833517998,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.379546712743043,38.360475753277143,0.49824280055340414,0.6932014144262979,"",5,null,5,0.8066861574344002,1005.795918367347,"Уровнение градуировочной зависимости ",null,null,null,5,5.9929327077720185,null,5,31.714285714285715,1005.795918367347,"Уровнение градуировочной зависимости ",null,null,null,5,11.757874716562553,null,5,2.3468720683678852E-2,4.6657500355131457E-5,11.804765500429554,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.426025297492757,38.477086501174774,-1.8956422750858952,-1.670429812515752,"",6,null,6,32.342641871720133,1260.25,null,null,null,null,6,86.750124758944921,null,6,35.5,1260.25,null,null,null,null,6,68.275739489068158,null,6,0.91915529599182066,1.2051674379505264E-2,70.101998406672294,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":-9.9962124994585597},-9.9290837612393705,"Отбраковывается",7,null,7,null,null,{"$f":"\"Rн = \" &   FIXED( AF8,2) & \" * H + \" & FIXED(AE10,2)","v":"Rн = 0,01 * H + 36,99"},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.409363163337197},{"$f":"IF(SUM(O15:P15)=0,\"\",$AP$8*SUM(O15:P15)+($AO$10))","v":38.435282648154868},-0.66159129752314172,-0.44974864973130257,"",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.566639843869133,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.9493672956008039,null,8,{"$f":"IFERROR((U15-$U$58)*(S15-$U$58),\"\")","v":0.15584874958328032},{"$f":"IFERROR(POWER((U15-$U$58),2),\"\")","v":4.620772644861995E-3},{"$f":"IFERROR(POWER((S15-$U$58),2),\"\")","v":5.2564440221225022},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,37.369242498199469,38.334623370488522,0.63342435838028477,0.82433195545897908,"",9,null,9,3.6526816166180738,953.265625,null,null,null,null,9,9.6860533675988858,null,9,30.875,953.265625,null,null,null,null,9,16.627012351554193,null,9,0.13433719431818944,1.0681792969896139E-3,16.894618560893583,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,37.372311838701812,38.342324080255345,1.1096908837010475,1.2983364294956723,"",10,null,10,5.0170212084548114,968.765625,null,null,null,null,10,29.727704386447954,null,10,31.125,968.765625,null,null,null,null,10,41.246246591827685,null,10,0.16106855897374936,6.241154429072834E-4,41.56775959433228,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.354407352438159,38.2974032732822,0.55306487514125846,0.73998678001290286,"",11,null,11,6.5275318717201003,880.1111111111112,null,null,null,null,11,7.3843027190849613,null,11,29.666666666666668,880.1111111111112,null,null,null,null,11,13.398552123055039,null,11,0.26076001580003239,4.8864447271818219E-3,13.91518570992792,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.383054530460001,38.369276564439232,-0.31891519675426361,-0.11739899488542224,"",12,null,12,-6.7771393586007422E-2,1024,null,null,null,null,12,2.4553181045119152,null,12,32,1024,null,null,null,null,12,0.33723970860949604,null,12,1.1480122369485119E-3,3.8816154964128275E-6,0.33953185146789666,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.318598379910867,38.207561659335916,1.1470963468073527,1.3191058487793517,"",13,null,13,30.177359218658857,715.5625,null,null,null,null,13,31.765604948033889,null,13,26.75,715.5625,null,null,null,null,13,42.576429658135559,null,13,1.0678625473703234,2.5518376690440207E-2,44.686636376185767,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.329341071669056,38.234514143519803,0.77998362461176074,0.95773541181032928,"",14,null,14,17.171966820699684,763.140625,null,null,null,null,14,14.68683808960153,null,14,27.625,763.140625,null,null,null,null,14,22.444040260050173,null,14,0.64673889080043823,1.7633778826202772E-2,23.719884262824849,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.419886616488078,38.461685081641122,-1.0268151372380652,-0.80930976579465519,"",15,null,15,15.024393912536468,1225,null,null,null,null,15,25.453169052491145,null,15,35,1225,null,null,null,null,15,16.026530335554781,null,15,0.38673499163328295,8.9073387855944687E-3,16.791092980035753,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.457946438717087,38.557173882749744,-1.2704243883047139,-1.0396732421392079,"",16,null,16,38.25684554518952,1451.6100000000001,null,null,null,null,16,38.963232661924643,null,16,38.1,1451.6100000000001,null,null,null,null,16,26.4486604722713,null,16,1.0125052048222032,3.6049667518358822E-2,28.437621214397346,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.406245103144343,38.427459704899682,-1.6096425644935881,-1.3923844955504909,"",17,null,17,14.638405250404899,1148.4567901234566,null,null,null,null,17,62.548404018538299,null,17,33.888888888888886,1148.4567901234566,null,null,null,null,17,47.438211316630536,null,17,0.41792685165825932,3.6184221536696773E-3,48.270446597793388,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.393285665467801,38.394945596995314,0.39082935094533922,0.59070024591980164,"",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.6874970370011173,null,18,32.833333333333336,1078.0277777777778,null,null,null,null,18,8.5377660718003057,null,18,-7.9996353919093932E-2,7.639261585966271E-4,8.3770094378035207,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,null,null,-4.534065437375304,-4.5036172959586702,"Отбраковывается",19,null,19,null,null,null,null,null,null,19,null,null,19,null,null,null,null,null,null,19,null,null,19,null,null,null,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.444441340506799,38.523290759775719,-0.3644264451397663,-0.14387907278499118,"",20,null,20,9.1769694227405161,1369,null,null,null,null,20,3.2061003130860612,null,20,37,1369,null,null,null,null,20,0.5065300426206123,null,20,0.13534664823404882,2.4331125845052249E-2,0.75289221324365774,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.460811156519277,38.564361211865446,-1.2118362402797251,-0.98060467928137252,"",21,null,21,37.938006157434444,1469.4444444444446,null,null,null,null,21,35.452364783830298,null,21,38.333333333333336,1469.4444444444446,null,null,null,null,21,23.528696652955446,null,21,0.99467240265233015,3.8830605638492929E-2,25.479210852621613,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.4137479354834,38.446283662107476,0.59801182406978526,0.80273325010334873,"",22,null,22,-7.1443950670553837,1190.25,null,null,null,null,22,8.6333009303724815,null,22,34.5,1190.25,null,null,null,null,22,15.767122891259682,null,22,-0.3073642795161734,6.2374106389879664E-3,15.146156921588346,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.456718702516156,38.554093598843018,0.70536619390612443,0.92247457097195418,"",23,null,23,-20.208733026239027,1444,null,null,null,null,23,12.011206124970268,null,23,38,1444,null,null,null,null,23,20.821823191802128,null,23,-0.8174380855870057,3.4889464058598857E-2,19.152057556569517,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.33854909317607,38.257616272820279,1.557192559893672,1.7325338962922348,"",24,null,24,28.231284218658878,805.140625,null,null,null,null,24,58.538552226190362,null,24,28.375,805.140625,null,null,null,null,24,73.446892929658944,null,24,0.95208891716733757,1.2031920238228629E-2,75.33903884375539,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,37.317575266410081,38.20499475608031,1.5471233165766767,1.7161343781297602,"",25,null,25,41.225530919339121,711.1111111111112,null,null,null,null,25,57.783946530897481,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.063031968758992,null,25,1.4042076126792158,2.6345064184469549E-2,74.845102129932954,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.439530395703052,{"$f":"IF(SUM(O33:P33)=0,\"\",$AP$8*SUM(O33:P33)+($AO$10))","v":38.5109696241488},-1.235502476556172,-1.0106035086390406,"",26,null,26,27.916444524781365,1339.5600000000002,null,null,null,null,26,36.850601216693121,null,26,36.6,1339.5600000000002,null,null,null,null,26,{"$f":"IFERROR(POWER(S33-U33,2),\"\")","v":24.990304698682973},null,26,0.73881603404891516,2.0639126900612915E-2,26.44729763988019,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.381519860208833,38.365426209555821,-0.76393332158912564,-0.55989677589847198,"",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.088613159806703},null,27,31.875,1016.015625,null,null,null,null,27,7.6705389807153264,null,27,-5.203743624127918E-3,3.535051614366688E-6,7.6601279584154565,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.41637879877112,38.452884270479039,-1.4142297486659248,-1.1951927574988179,"",28,null,28,18.647500034985445,1205.0816326530612,null,null,null,null,28,48.283336598167509,null,28,34.714285714285715,1205.0816326530612,null,null,null,null,28,34.953112399249186,null,28,0.5132699504047441,7.3235748511293669E-3,35.972328725207547,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.354407352438159,38.2974032732822,0.30557644188580452,0.49416033486036115,"",29,null,29,3.6375879261418662,880.1111111111112,null,null,null,null,29,2.2542240379553569,null,29,29.666666666666668,880.1111111111112,null,null,null,null,29,5.9751073624327242,null,29,{"$f":"IFERROR((U36-$U$58)*(S36-$U$58),\"\")","v":0.17575783456616179},{"$f":"IFERROR(POWER((U36-$U$58),2),\"\")","v":4.8864447271818219E-3},{"$f":"IFERROR(POWER((S36-$U$58),2),\"\")","v":6.3217365868378659},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.419886616488078,38.461685081641122,0.53738910107179549,0.744390188333518,"",30,null,30,-7.6995905772594577,1225,null,null,null,null,30,6.9716414845293695,null,30,35,1225,null,null,null,null,30,13.558486975460442,null,30,-0.33861249792951481,8.9073387855944687E-3,12.872354640815818,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.387658541213511,38.380827629089467,0.77058424787967716,0.96618842210393852,"",31,null,31,-1.2546490466472264,1048.140625,null,null,null,null,31,14.334996499204067,null,31,32.375,1048.140625,null,null,null,null,31,22.841972586177999,null,31,-6.4439641634383649E-2,1.8282409988107655E-4,22.712910478809349,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.370777168450637,38.338473725371934,-1.1721554567016352,-0.96865449913389523,"",32,null,32,-5.9950346588921359,961,null,null,null,null,32,33.168647623439412,null,32,31,961,null,null,null,null,32,22.958724040451074,null,32,-0.13732111373402109,8.3132213722023822E-4,22.683250490845811,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.402698309674975},38.418561106946903,-0.56627260376853605,-0.35710311978489473,"",33,null,33,4.3610588104956305,1128.96,null,null,null,null,33,7.741202695985467,null,33,33.6,1128.96,null,null,null,null,33,3.1203063628906325,null,33,9.3165384840608573E-2,2.6270467422981328E-3,3.3040100858295514,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.388316257035441,38.382477781182359,-0.10129191595642204,0.10036790135302638,"",34,null,34,0.19358330029154922,1051.6122448979593,null,null,null,null,34,0.24768910801121552,null,34,32.428571428571431,1051.6122448979593,null,null,null,null,34,0.24649018720775601,null,34,-7.3020908543447241E-3,2.3017132737346055E-4,0.23165583417169308,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.41637879877112,38.452884270479039,-1.0468641055523593,-0.83029412797551283,"",35,null,35,13.826308198250732,1205.0816326530612,null,null,null,null,35,26.456839061731174,null,35,34.714285714285715,1205.0816326530612,null,null,null,null,35,16.868399615678452,null,35,0.35880186323347457,7.3235748511293669E-3,17.578679767294275,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.367306382849527},null,null,null,null,null,null,{"$f":"IF(SUM(AB8:AB57)=0,\"\",SUM(AB8:AB57))","v":420.05804238467766},{"$f":"IF(SUM(AC8:AC57)=0,\"\",SUM(AC8:AC57))","v":34214.030836955157},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":4.9133609357204335},null,null,{"$f":"IF(SUM(AL8:AL57)=0,\"\",SUM(AL8:AL57))","v":1053.8892857142857},{"$f":"IF(SUM(AM8:AM57)=0,\"\",SUM(AM8:AM57))","v":34214.030836955157},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":4.9465792797249355},null,null,{"$f":"IF(SUM(AV8:AV57)=0,\"\",SUM(AV8:AV57))","v":12.950126399266825},{"$f":"IF(SUM(AW8:AW57)=0,\"\",SUM(AW8:AW57))","v":0.52847238853738954},{"$f":"IF(SUM(AX8:AX57)=0,\"\",SUM(AX8:AX57))","v":783.89982409872198}]
[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.72696106397618676},{"$f":"IFERROR(SQRT(AX58),\"\")","v":27.998211087473464}]
[null,null,null,null,null,null,null,null,null,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.5340610666150587},null,null,null,null,null,null,null,null,"Sп",{"$f":"IFERROR((AS58*1.5)-(SQRT(SUM(AS8:AS57)/(COUNT(AS8:AS57)-1))),\"\")","v":2.5511933948401762},null,null,null,{"$f":"IFERROR(AW59*AX59,\"\")","v":20.353609321579579}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.63625699966328164}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":4.9465792797249355},{"$f":"IFERROR(AG63/AG64*100,\"\")","v":12.892693665709338},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.367306382849527},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.537599909622195}]
[null,null,null,null,null,null,null,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.691614104958681}]
[null,null,null,null,null,null,null,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.845628300295168}]
[null,null,null,null,null,null,null,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.999642495631662}]
[null,null,null,null,null,null,null,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.153656690968148}]
[null,null,null,null,null,null,null,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.307670886304635}]
[null,null,null,null,null,null,null,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.461685081641122}]
[null,null,null,null,null,null,null,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.615699276977608}]
[null,null,null,null,null,null,null,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.769713472314095}]
[null,null,null,null,null,null,null,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.923727667650589}]