{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Форма 2020 ГОСТ Р57997-2017","справочные данные","2021"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Форма 2020 ГОСТ Р57997-2017","index":0,"n_rows":48,"n_cols":14,"rows_kept":48,"cut":false,"hidden":false,"merged":[[38,6,38,7],[45,1,45,6],[47,1,47,6],[2,6,2,11],[3,6,3,11],[13,0,13,11],[2,0,2,4],[3,0,3,4],[9,0,11,11],[40,4,40,11],[34,0,36,1],[34,2,34,3],[34,4,34,5],[34,6,34,7],[34,8,34,9],[34,10,34,11],[35,2,35,3],[35,4,35,5],[35,6,35,7],[35,8,35,9],[35,10,35,11],[36,2,36,3],[36,4,36,5],[36,6,36,7],[36,8,36,9],[36,10,36,11],[22,5,22,11],[0,0,0,11],[12,0,12,4],[14,0,14,11],[16,9,16,11],[18,5,18,11],[19,5,19,11],[20,5,20,11],[21,5,21,11],[4,6,4,11],[5,6,5,11],[33,2,33,3],[33,4,33,5],[33,6,33,7],[33,8,33,9],[33,10,33,11],[23,5,23,11],[24,5,24,11],[26,10,26,11],[32,0,32,1],[32,2,32,3],[32,4,32,5],[32,6,32,7],[32,8,32,9],[32,10,32,11]]}
["Протокол не может быть воспроизведен полностью или частично без письменного разрешения испытательной лаборатории",null,null,null,null,null,null,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":"U5","v":0}]
[null,null,null,null,null,null,{"$f":"U6","v":0}]
["Объект:",{"$f":"U5","v":0}]
[]
[]
[{"$f":"\"Объект строительства: \"&U4","v":"Объект строительства: "}]
[]
[]
[]
[{"$f":"\"Протокол №\"&O1","v":"Протокол №"}]
["механических испытаний сварных соединений"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"Q7","v":"00:00:00"}]
[]
["Данные о месте проведения сварочных работ",null,null,null,null,{"$f":"O2","v":0}]
["Ф.И.О. сварщика, квалификационный разряд",null,null,null,null,{"$f":"O3","v":0},null,null,null,null,null,null,null,"Вставлять \"значения\" из листа 2021"]
["Тип соединения",null,null,null,null,{"$f":"O4","v":0}]
["Объем партии, число изделий",null,null,null,null,{"$f":"O5","v":0}]
["Номер выборки",null,null,null,null,{"$f":"O6","v":0}]
["Диаметр(ы) и класс арматурной стали",null,null,null,null,{"$f":"O7&\" \"&O8","v":" "}]
["Марка сварочного материала",null,null,null,null,{"$f":"O9","v":0}]
[]
["Площадь поперечного сечения стержня, мм2, к которому прикладывают контрольную нагрузку",null,null,null,null,null,null,null,null,null,{"$f":"O10","v":0}]
["Приборы и оборудование:"]
[{"$f":"U1","v":0}]
[{"$f":"U2","v":0}]
[{"$f":"U3","v":0}]
[]
["Результаты испытаний",null,"Номер образца",null,"Разрывное усилие P, кН (кгс)",null,"Предел прочности σ, Н/мм2(кгс/мм2)",null,"Место разрушения",null,"Вид дефекта"]
[]
[null,null,1,null,{"$f":"Q2","v":0},null,{"$f":"R2","v":0},null,{"$f":"S2","v":0}]
[null,null,2,null,{"$f":"Q3","v":0},null,{"$f":"R3","v":0},null,{"$f":"S3","v":0}]
[null,null,3,null,{"$f":"Q4","v":0},null,{"$f":"R4","v":0},null,{"$f":"S4","v":0}]
[]
["ЗАКЛЮЧЕНИЕ. Испытанные сварные соединения",null,null,null,null,null,{"$f":"Q5","v":0},null,{"$f":"\"требованиям \"&Q6&\".\"","v":"требованиям ."}]
[]
["Партия сварных соединений ",null,null,null,{"$f":"IF(G39=\"соответствует\", \"подлежит приемке\", \"не подлежит приемке\")","v":"не подлежит приемке"}]
[]
[]
[]
[]
["Испытал:",{"$f":"Q9","v":0},null,null,null,null,null,null,null,{"$f":"\"/\"&R9&\"/\"","v":"//"}]
[]
[null,{"$f":"Q10","v":0},null,null,null,null,null,null,null,{"$f":"\"/\"&R10&\"/\"","v":"//"}]

{"sheet":"справочные данные","index":1,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Диаметр","Площадь"]
[6,28.3]
[8,50.3]
[10,78.5]
[12,113.1]
[14,154]
[16,201]
[18,254]
[20,314]
[22,380]
[25,491]
[28,616]
[32,804]
[36,1018]
[40,1257]
[45,1500]
[50,1963]
[55,2376]
[60,2827]
[70,3848]
[80,5027]

{"sheet":"2021","index":2,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[9,2,10,2],[0,0,0,1],[0,2,0,5],[0,6,0,7]]}
["Данные о происхождении образцов",null,"Данные по испытаниям",null,null,null,"Оборудование, Объект строительства"]
["№ протокола","1с-2021",null,"кН","МПа","Место разрушения","Р100М"]
["Данные о месте","арматурный цех","Образец 1",516.20000000000005,{"$f":"D3/B11*1000","v":642.03980099502485},"по основному металлу","Щтангенциркуль"]
["ФИО сварщика",null,"Образец 2",510.6,{"$f":"D4/B11*1000","v":635.07462686567158},"по основному металлу","Термогигрометр"]
["Тип соединения","С1-Ко","Образец 3",514.4,{"$f":"D5/B11*1000","v":639.80099502487565},"по основному металлу","Наименование объекта"]
["Объем партии",32,"Заключение","соответствует",null,null,"Аттестация"," "]
["Номер выборки","3 шт","норматив","ГОСТ Р 57997",null,null,"№"," "]
["Диаметр",32,"Дата испытания","2020-11-24"]
["Класс арматурной стали","AIII",null,null,null,null,"Скан документа"]
["Марка сварочного материала","-","Подписи","Должность","ФИО",null,"ctrl+m (англ m)","-для переноса данных в форму"]
["Площадь поперечного",{"$f":"VLOOKUP(B8,'справочные данные'!$A$1:$B$21,2,TRUE)","v":804},null,"Должность","ФИО"]