{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Лист1","Лист2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":2,"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":"Лист1","index":0,"n_rows":46,"n_cols":33,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Наименьшее значение для отбраковки","Наибольшее значение для отбраковки","№","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","max","min","Среднее значение по склерометру","Разделение на группы","Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН","Показания Riф (Мпа)","До отбраковки RiH","После отбраковки RiH","До отбраковки RiH-Riф/Sт","После отбраковки RiH-Riф/Sт","Примечание"]
[null,null,null,null,{"$f":"IFERROR(IF(W14>4,LARGE(H14:V14,1),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(X14>4,SMALL(H14:V14,1),\"\"),\"\")","v":""},{"$f":"ROW()-ROW(Расчет[[#Headers],[№]])","v":1},32,34,32,32,32,30,32,36,null,32,32,34,34,36,null,{"$f":"IFERROR(MAX(H14:V14)-AVERAGE(H14:V14),\"\")","v":3.0769230769230802},{"$f":"IFERROR(AVERAGE(H14:V14)-MIN(H14:V14),\"\")","v":2.9230769230769198},{"$f":"IFERROR(AVERAGE(H14:V14),\"\")","v":32.92307692307692},{"$f":"IF(Y14=\"\",\"\",IF(Y14<=$W$14,1,2))","v":2},361.9,{"$f":"IF(Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]=\"\",\"\",((Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]*10)/100)*0.95)","v":34.380499999999998},{"$f":"IFERROR($AL$16*Y14+($AK$18),\"\")","v":0},{"$f":"IF(AG14=\"Отбраковывается\",\"\",IFERROR($AU$16*Y14+($AT$18),\"\"))","v":0},45,{"$f":"IF(AD14=\"\",\"\",(AD14-AB14)/SQRT(SUM($AW$17:$AW$49)/(COUNT($AW$17:$AW$49)-2)))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,{"$f":"IFERROR(IF(W15>4,LARGE(H15:V15,1),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(X15>4,SMALL(H15:V15,1),\"\"),\"\")","v":""},{"$f":"ROW()-ROW(Расчет[[#Headers],[№]])","v":2},30,34,32,32,32,32,34,30,34,36,32,32,30,34,null,{"$f":"IFERROR(MAX(H15:V15)-AVERAGE(H15:V15),\"\")","v":3.5714285714285694},{"$f":"IFERROR(AVERAGE(H15:V15)-MIN(H15:V15),\"\")","v":2.4285714285714306},{"$f":"IFERROR(AVERAGE(H15:V15),\"\")","v":32.428571428571431},2,397.2,{"$f":"IF(Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]=\"\",\"\",((Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]*10)/100)*0.95)","v":37.733999999999995},{"$f":"IFERROR($AL$16*Y15+($AK$18),\"\")","v":0},{"$f":"IF(AG15=\"Отбраковывается\",\"\",IFERROR($AU$16*Y15+($AT$18),\"\"))","v":0},{"$f":"IF(AC15=\"\",\"\",(AC15-AB15)/SQRT(SUM($AN$17:$AN$49)/(COUNT($AN$17:$AN$49)-2)))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",{"$f":"ROW()-ROW(Расчет[[#Headers],[№]])","v":3},32,32,32,36,32,34,30,34,32,30,32,32,32,32,null,3.7142857142857153,2.2857142857142847,32.285714285714285,2,357.2,{"$f":"IF(Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]=\"\",\"\",((Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]*10)/100)*0.95)","v":33.933999999999997},0,0,15,{"$error":"#DIV/0!"}]
[null,null,null,null,"","",{"$f":"ROW()-ROW(Расчет[[#Headers],[№]])","v":4},32,30,28,28,28,34,32,32,30,32,34,34,null,30,null,2.9230769230769234,3.0769230769230766,31.076923076923077,2,398.2,{"$f":"IF(Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]=\"\",\"\",((Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]*10)/100)*0.95)","v":37.829000000000001},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",{"$f":"ROW()-ROW(Расчет[[#Headers],[№]])","v":5},30,null,null,null,30,30,34,28,30,30,32,32,30,28,null,3.6363636363636367,2.3636363636363633,30.363636363636363,2,389,{"$f":"IF(Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]=\"\",\"\",((Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]*10)/100)*0.95)","v":36.954999999999998},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",{"$f":"ROW()-ROW(Расчет[[#Headers],[№]])","v":6},34,32,32,32,32,null,36,38,32,36,36,32,34,36,null,4,2,34,2,356.1,{"$f":"IF(Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]=\"\",\"\",((Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]*10)/100)*0.95)","v":33.829499999999996},0,0,1456,{"$error":"#DIV/0!"}]
[null,null,null,null,"","",{"$f":"ROW()-ROW(Расчет[[#Headers],[№]])","v":7},38,34,null,40,38,36,38,38,36,36,38,38,38,null,null,2.6666666666666643,3.3333333333333357,37.333333333333336,2,489.7,{"$f":"IF(Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]=\"\",\"\",((Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]*10)/100)*0.95)","v":46.521499999999996},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",{"$f":"ROW()-ROW(Расчет[[#Headers],[№]])","v":8},null,38,44,null,38,null,44,42,40,null,36,null,36,42,null,4,4,40,2,421.2,{"$f":"IF(Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]=\"\",\"\",((Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]*10)/100)*0.95)","v":40.013999999999996},0,0,156,{"$error":"#DIV/0!"}]
[null,null,null,null,"","",{"$f":"ROW()-ROW(Расчет[[#Headers],[№]])","v":9},null,34,null,36,36,40,38,34,36,null,38,40,36,null,null,3.2000000000000028,2.7999999999999972,36.799999999999997,2,459.2,{"$f":"IF(Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]=\"\",\"\",((Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]*10)/100)*0.95)","v":43.624000000000002},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",{"$f":"ROW()-ROW(Расчет[[#Headers],[№]])","v":10},38,36,36,34,34,36,null,38,34,34,38,38,38,34,null,2,2,36,2,526.9,{"$f":"IF(Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]=\"\",\"\",((Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]*10)/100)*0.95)","v":50.055499999999995},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$f":"IFERROR(IF(W24>4,LARGE(H24:V24,1),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(X24>4,SMALL(H24:V24,1),\"\"),\"\")","v":""},{"$f":"ROW()-ROW(Расчет[[#Headers],[№]])","v":11},38,null,40,36,36,42,null,40,null,null,36,36,38,40,null,{"$f":"IFERROR(MAX(H24:V24)-AVERAGE(H24:V24),\"\")","v":3.7999999999999972},{"$f":"IFERROR(AVERAGE(H24:V24)-MIN(H24:V24),\"\")","v":2.2000000000000028},{"$f":"IFERROR(AVERAGE(H24:V24),\"\")","v":38.200000000000003},{"$f":"IF(Y24=\"\",\"\",IF(Y24<=$W$14,1,2))","v":2},538.9,{"$f":"IF(Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]=\"\",\"\",((Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]*10)/100)*0.95)","v":51.195499999999996},{"$f":"IFERROR($AL$16*Y24+($AK$18),\"\")","v":0},{"$f":"IF(AG24=\"Отбраковывается\",\"\",IFERROR($AU$16*Y24+($AT$18),\"\"))","v":0},{"$error":"#DIV/0!"},153]
[null,null,null,null,"","",{"$f":"ROW()-ROW(Расчет[[#Headers],[№]])","v":12},36,38,34,34,34,null,null,null,34,38,32,36,36,36,null,2.7272727272727266,3.2727272727272734,35.272727272727273,2,549.4,{"$f":"IF(Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]=\"\",\"\",((Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]*10)/100)*0.95)","v":52.192999999999998},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",{"$f":"ROW()-ROW(Расчет[[#Headers],[№]])","v":13},32,null,34,34,32,34,32,34,34,38,38,34,36,34,null,3.6923076923076934,2.3076923076923066,34.307692307692307,2,361.8,{"$f":"IF(Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]=\"\",\"\",((Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]*10)/100)*0.95)","v":34.370999999999995},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",{"$f":"ROW()-ROW(Расчет[[#Headers],[№]])","v":14},32,null,38,32,38,34,36,34,34,34,36,36,34,36,null,3.0769230769230802,2.9230769230769198,34.92307692307692,2,259.39999999999998,{"$f":"IF(Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]=\"\",\"\",((Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]*10)/100)*0.95)","v":24.643000000000001},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",{"$f":"ROW()-ROW(Расчет[[#Headers],[№]])","v":15},null,38,36,32,38,34,38,null,34,36,32,34,null,38,null,2.5454545454545467,3.4545454545454533,35.454545454545453,2,386.3,{"$f":"IF(Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]=\"\",\"\",((Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]*10)/100)*0.95)","v":36.698500000000003},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",{"$f":"ROW()-ROW(Расчет[[#Headers],[№]])","v":16},34,null,null,38,34,34,36,36,36,36,32,null,31,32,null,3.5454545454545467,3.4545454545454533,34.454545454545453,2,438.3,{"$f":"IF(Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]=\"\",\"\",((Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]*10)/100)*0.95)","v":41.638499999999993},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",{"$f":"ROW()-ROW(Расчет[[#Headers],[№]])","v":17},38,34,40,38,36,38,40,40,38,36,38,38,36,38,null,2.2857142857142847,3.7142857142857153,37.714285714285715,2,462.8,{"$f":"IF(Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]=\"\",\"\",((Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]*10)/100)*0.95)","v":43.966000000000001},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",{"$f":"ROW()-ROW(Расчет[[#Headers],[№]])","v":18},34,34,38,40,34,34,40,36,34,34,38,34,38,36,null,4,2,36,2,390.8,{"$f":"IF(Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]=\"\",\"\",((Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]*10)/100)*0.95)","v":37.125999999999998},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",{"$f":"ROW()-ROW(Расчет[[#Headers],[№]])","v":19},33,32,35,34,35,36,34,36,37,33,null,33,34,34,null,2.6923076923076934,2.3076923076923066,34.307692307692307,2,444.7,{"$f":"IF(Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]=\"\",\"\",((Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]*10)/100)*0.95)","v":42.246499999999997},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",{"$f":"ROW()-ROW(Расчет[[#Headers],[№]])","v":20},34,35,33,32,34,33,36,34,37,33,null,35,33,32,null,3.0769230769230802,1.9230769230769198,33.92307692307692,2,436.4,{"$f":"IF(Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]=\"\",\"\",((Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]*10)/100)*0.95)","v":41.457999999999998},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",{"$f":"ROW()-ROW(Расчет[[#Headers],[№]])","v":21},34,33,34,34,33,33,null,32,36,32,null,32,35,null,null,2.5454545454545467,1.4545454545454533,33.454545454545453,2,428.2,{"$f":"IF(Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]=\"\",\"\",((Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]*10)/100)*0.95)","v":40.678999999999995},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",{"$f":"ROW()-ROW(Расчет[[#Headers],[№]])","v":22},38,36,38,34,32,34,34,32,36,38,36,null,36,34,null,2.7692307692307665,3.2307692307692335,35.230769230769234,2,293.39999999999998,{"$f":"IF(Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]=\"\",\"\",((Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]*10)/100)*0.95)","v":27.872999999999998},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",{"$f":"ROW()-ROW(Расчет[[#Headers],[№]])","v":23},36,null,34,null,36,34,36,32,34,34,32,34,null,36,null,1.6363636363636331,2.3636363636363669,34.363636363636367,2,320.60000000000002,{"$f":"IF(Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]=\"\",\"\",((Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]*10)/100)*0.95)","v":30.457000000000001},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",{"$f":"ROW()-ROW(Расчет[[#Headers],[№]])","v":24},null,36,34,38,32,38,33,32,34,38,31,38,null,36,null,3,4,35,2,293.89999999999998,{"$f":"IF(Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]=\"\",\"\",((Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]*10)/100)*0.95)","v":27.920500000000001},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",{"$f":"ROW()-ROW(Расчет[[#Headers],[№]])","v":25},36,38,39,39,37,39,42,38,41,39,null,42,41,39,null,2.7692307692307665,3.2307692307692335,39.230769230769234,2,475.9,{"$f":"IF(Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]=\"\",\"\",((Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]*10)/100)*0.95)","v":45.210500000000003},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",{"$f":"ROW()-ROW(Расчет[[#Headers],[№]])","v":26},33,32,34,null,36,32,null,37,37,38,37,32,35,null,null,3.1818181818181799,2.8181818181818201,34.81818181818182,2,271.3,{"$f":"IF(Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]=\"\",\"\",((Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]*10)/100)*0.95)","v":25.773499999999999},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",{"$f":"ROW()-ROW(Расчет[[#Headers],[№]])","v":27},52,null,51,null,51,54,50,47,null,50,null,49,53,48,null,3.5,3.5,50.5,2,559.6,{"$f":"IF(Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]=\"\",\"\",((Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]*10)/100)*0.95)","v":53.161999999999999},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",{"$f":"ROW()-ROW(Расчет[[#Headers],[№]])","v":28},null,33,null,32,null,26,28,31,null,26,null,32,30,32,null,3,4,30,2,305.39999999999998,{"$f":"IF(Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]=\"\",\"\",((Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]*10)/100)*0.95)","v":29.012999999999998},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",{"$f":"ROW()-ROW(Расчет[[#Headers],[№]])","v":29},33,33,30,null,32,35,33,37,33,31,null,null,null,37,null,3.6000000000000014,3.3999999999999986,33.4,2,319.3,{"$f":"IF(Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]=\"\",\"\",((Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]*10)/100)*0.95)","v":30.333499999999997},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",{"$f":"ROW()-ROW(Расчет[[#Headers],[№]])","v":30},36,42,42,43,39,42,37,39,37,null,40,39,41,43,null,3,4,40,2,364.1,{"$f":"IF(Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]=\"\",\"\",((Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]*10)/100)*0.95)","v":34.589499999999994},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",{"$f":"ROW()-ROW(Расчет[[#Headers],[№]])","v":31},39,40,42,38,38,38,42,39,40,42,38,null,39,41,null,2.3076923076923066,1.6923076923076934,39.692307692307693,2,474.7,{"$f":"IF(Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]=\"\",\"\",((Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]*10)/100)*0.95)","v":45.096499999999999},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",{"$f":"ROW()-ROW(Расчет[[#Headers],[№]])","v":32},null,40,40,39,41,38,null,38,39,38,40,38,39,41,null,1.75,1.25,39.25,2,454.9,{"$f":"IF(Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]=\"\",\"\",((Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]*10)/100)*0.95)","v":43.215499999999999},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"","",{"$f":"ROW()-ROW(Расчет[[#Headers],[№]])","v":33},55,null,null,48,null,null,null,null,null,null,null,null,null,null,null,3.5,3.5,51.5,2,null,{"$f":"IF(Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]=\"\",\"\",((Расчет[[#This Row],[Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН]]*10)/100)*0.95)","v":""},{"$f":"IFERROR($AL$16*Y46+($AK$18),\"\")","v":0},{"$f":"IF(AG46=\"Отбраковывается\",\"\",IFERROR($AU$16*Y46+($AT$18),\"\"))","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]

{"sheet":"Лист2","index":1,"n_rows":62,"n_cols":29,"rows_kept":62,"cut":false,"hidden":false,"merged":[[24,0,24,28]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Приложение"]
["Наименьшее значение для отбраковки","Наибольшее значение для отбраковки","№","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","max","min","Среднее значение по склерометру","Разделение на группы","Разрушающая нагрузга\nПресс в КН\nЗначение ПИБ в КН","Показания Riф (Мпа)","До отбраковки RiH","После отбраковки RiH","До отбраковки RiH-Riф/Sт","После отбраковки RiH-Riф/Sт","Примечание"]
["","",1,32,34,32,32,32,30,32,36,null,32,32,34,34,36,null,3.0769230769230802,2.9230769230769198,32.92307692307692,2,361.9,34.380499999999998,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["","",2,30,34,32,32,32,32,34,30,34,36,32,32,30,34,null,3.5714285714285694,2.4285714285714306,32.428571428571431,2,397.2,37.733999999999995,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["","",3,32,32,32,36,32,34,30,34,32,30,32,32,32,32,null,3.7142857142857153,2.2857142857142847,32.285714285714285,2,357.2,33.933999999999997,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["","",4,32,30,28,28,28,34,32,32,30,32,34,34,null,30,null,2.9230769230769234,3.0769230769230766,31.076923076923077,2,398.2,37.829000000000001,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["","",5,30,null,null,null,30,30,34,28,30,30,32,32,30,28,null,3.6363636363636367,2.3636363636363633,30.363636363636363,2,389,36.954999999999998,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["","",6,34,32,32,32,32,null,36,38,32,36,36,32,34,36,null,4,2,34,2,356.1,33.829499999999996,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["","",7,38,34,null,40,38,36,38,38,36,36,38,38,38,null,null,2.6666666666666643,3.3333333333333357,37.333333333333336,2,489.7,46.521499999999996,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["","",8,null,38,44,null,38,null,44,42,40,null,36,null,36,42,null,4,4,40,2,421.2,40.013999999999996,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["","",9,null,34,null,36,36,40,38,34,36,null,38,40,36,null,null,3.2000000000000028,2.7999999999999972,36.799999999999997,2,459.2,43.624000000000002,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["","",10,38,36,36,34,34,36,null,38,34,34,38,38,38,34,null,2,2,36,2,526.9,50.055499999999995,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["","",11,38,null,40,36,36,42,null,40,null,null,36,36,38,40,null,3.7999999999999972,2.2000000000000028,38.200000000000003,2,538.9,51.195499999999996,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["","",12,36,38,34,34,34,null,null,null,34,38,32,36,36,36,null,2.7272727272727266,3.2727272727272734,35.272727272727273,2,549.4,52.192999999999998,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["","",13,32,null,34,34,32,34,32,34,34,38,38,34,36,34,null,3.6923076923076934,2.3076923076923066,34.307692307692307,2,361.8,34.370999999999995,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["","",14,32,null,38,32,38,34,36,34,34,34,36,36,34,36,null,3.0769230769230802,2.9230769230769198,34.92307692307692,2,259.39999999999998,24.643000000000001,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["","",15,null,38,36,32,38,34,38,null,34,36,32,34,null,38,null,2.5454545454545467,3.4545454545454533,35.454545454545453,2,386.3,36.698500000000003,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["","",16,34,null,null,38,34,34,36,36,36,36,32,null,31,32,null,3.5454545454545467,3.4545454545454533,34.454545454545453,2,438.3,41.638499999999993,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["","",17,38,34,40,38,36,38,40,40,38,36,38,38,36,38,null,2.2857142857142847,3.7142857142857153,37.714285714285715,2,462.8,43.966000000000001,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["","",18,34,34,38,40,34,34,40,36,34,34,38,34,38,36,null,4,2,36,2,390.8,37.125999999999998,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["","",19,33,32,35,34,35,36,34,36,37,33,null,33,34,34,null,2.6923076923076934,2.3076923076923066,34.307692307692307,2,444.7,42.246499999999997,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["","",20,34,35,33,32,34,33,36,34,37,33,null,35,33,32,null,3.0769230769230802,1.9230769230769198,33.92307692307692,2,436.4,41.457999999999998,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["","",21,34,33,34,34,33,33,null,32,36,32,null,32,35,null,null,2.5454545454545467,1.4545454545454533,33.454545454545453,2,428.2,40.678999999999995,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["","",22,38,36,38,34,32,34,34,32,36,38,36,null,36,34,null,2.7692307692307665,3.2307692307692335,35.230769230769234,2,293.39999999999998,27.872999999999998,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["","",23,36,null,34,null,36,34,36,32,34,34,32,34,null,36,null,1.6363636363636331,2.3636363636363669,34.363636363636367,2,320.60000000000002,30.457000000000001,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["","",24,null,36,34,38,32,38,33,32,34,38,31,38,null,36,null,3,4,35,2,293.89999999999998,27.920500000000001,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["","",25,36,38,39,39,37,39,42,38,41,39,null,42,41,39,null,2.7692307692307665,3.2307692307692335,39.230769230769234,2,475.9,45.210500000000003,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["","",26,33,32,34,null,36,32,null,37,37,38,37,32,35,null,null,3.1818181818181799,2.8181818181818201,34.81818181818182,2,271.3,25.773499999999999,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["","",27,52,null,51,null,51,54,50,47,null,50,null,49,53,48,null,3.5,3.5,50.5,2,559.6,53.161999999999999,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["","",28,null,33,null,32,null,26,28,31,null,26,null,32,30,32,null,3,4,30,2,305.39999999999998,29.012999999999998,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["","",29,33,33,30,null,32,35,33,37,33,31,null,null,null,37,null,3.6000000000000014,3.3999999999999986,33.4,2,319.3,30.333499999999997,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["","",30,36,42,42,43,39,42,37,39,37,null,40,39,41,43,null,3,4,40,2,364.1,34.589499999999994,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["","",31,39,40,42,38,38,38,42,39,40,42,38,null,39,41,null,2.3076923076923066,1.6923076923076934,39.692307692307693,2,474.7,45.096499999999999,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["","",32,null,40,40,39,41,38,null,38,39,38,40,38,39,41,null,1.75,1.25,39.25,2,454.9,43.215499999999999,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["","",33,55,null,null,48,null,null,null,null,null,null,null,null,null,null,null,3.5,3.5,51.5,2,null,"",0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[]
["Заключение"]