{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Реестр","Шариковый штамп (24)"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"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":34,"n_cols":42,"rows_kept":34,"cut":false,"hidden":false,"merged":[[3,1,3,37],[2,1,2,37],[6,8,6,19],[5,1,7,1],[5,2,7,2],[5,3,6,4],[5,5,6,7],[5,8,5,37],[6,20,6,23],[6,24,6,31],[6,32,6,33],[6,34,6,36],[6,37,7,37]]}
[]
[]
[null,"Реестр №218"]
[null,"Объект: \"Строительство мостового перехода через р. Обь в районе г. Салехард\""]
[]
[null,"№ п.п.","Лабораторный №","Место отбора",null,"Полевое описание",null,null,"Лабораторные определения",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"сделанный образец"]
[null,null,null,null,null,null,null,null,"Водно-физические свойства",null,null,null,null,null,null,null,null,null,null,null,"Химия",null,null,null,"Мёрзлая механика",null,null,null,null,null,null,null,"Талая механика",null,"Внешние лаборатории",null,null,"Примечание, нарушенная структура (нс) / монолит (М)",null,null,"образец в работе"]
[null,null,null,"№ выработки","Глубина, м","Наименование грунта","Структура","Талые (Т) / Мерзлые (М)","Суммарная влажнотсь","Минеральная влажность","Плотность грунта","Плотность частиц грунта","Гран. Состав (ситовой)","Гран. Состав (ареометр)","Консистенция (раскатка+текучка)","Содержание органических веществ","Степень разложения торфа","Коэффициент фильтрации","Плотность предельно плотного  и рыхлого состояний","Угол естественного откоса ","Засоленность (по солемеру)","Водная вытяжка (с агрессивностью к бетону и оболочкам кабелей)","Коррозионная агрессивность к низколегированной стали","Температура начала замерзания","Шариковый штамп","Компрессия при оттаивании","Компрессия мерзлая","Сдвиг по поверхности смерзания","Одноосное сжатие ","Теплофизика","Пучение","Температура испытания, оС","Одноплоскостной Сдвиг ","Компрессионное сжатие","Название лабоатории","Дата отправления","Состояние образца"]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37]
[null,1,733,"2L-A","3,0-3,2","Торф","1 ящик","м","+","+","+",null,null,null,"+","+","+",null,null,null,"+","+","+","+",null,"+","+",null,null,null,"+",-1,null,null,null,null,null,"м",null,{"$f":"IF(Y10=\"+\",C10,)","v":0},null,{"$f":"((Z10:Z32=\"+\")*C10:C32)","v":733}]
[null,2,734,"2L-A","6,0-6,2","Суглинок","1 ящик","м","+","+","+","+",null,"+","+","+",null,null,null,null,null,null,null,null,"+",null,"+",null,null,"+","+",-1,null,null,null,null,null,"м",null,{"$f":"IF(Y11=\"+\",C11,)","v":734},null,{"$f":"((Z11:Z33=\"+\")*C11:C33)","v":0}]
[null,3,735,"2L-A","9,3-9,5","Суглинок","1 ящик","м","+","+","+",null,null,"+","+",null,null,null,null,null,"+","+","+","+",null,"+",null,null,null,"+","+",-1,null,null,null,null,null,"м",null,{"$f":"IF(Y12=\"+\",C12,)","v":0},null,{"$f":"((Z12:Z34=\"+\")*C12:C34)","v":735}]
[null,4,736,"2L-A","12,0-12,2","Супесь","2 ящик","м","+","+","+","+",null,null,"+","+",null,null,null,null,null,null,null,null,"+",null,null,null,null,null,null,-1,null,null,null,null,null,"м",null,736,null,{"$f":"((Z13:Z35=\"+\")*C13:C35)","v":0}]
[null,5,737,"2L-A","14,5-14,8","Песок","1 ящик","м","+","+","+",null,"+",null,null,null,null,"+","+","+","+","+","+","+",null,null,"+","+",null,null,null,-1,null,null,null,null,null,"м",null,0,null,{"$f":"((Z14:Z36=\"+\")*C14:C36)","v":0}]
[null,6,738,"2L-A","17,4-17,4","Песок","1 ящик","м","+","+","+","+","+",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+",null,-1,null,null,null,null,null,"м",null,0,null,{"$f":"((Z15:Z37=\"+\")*C15:C37)","v":0}]
[null,7,739,"2L-A","19,7-19,9","Песок","1 ящик","м","+","+","+",null,"+",null,null,"+",null,null,null,null,"+","+","+","+","+",null,null,"+",null,null,null,-1,null,null,null,null,null,"м",null,739,null,{"$f":"((Z16:Z38=\"+\")*C16:C38)","v":0}]
[null,8,740,"2L-A","21,4-21,6","Песок","1 ящик","м","+","+","+","+","+",null,null,null,null,"+","+","+","+","+","+","+",null,null,null,null,null,null,null,-1,null,null,null,null,null,"м",null,0,null,{"$f":"((Z17:Z39=\"+\")*C17:C39)","v":0}]
[null,9,741,"2L-A","23,1-23,3","Песок","2 ящик","м","+","+","+",null,"+",null,null,null,null,null,null,null,null,null,null,null,null,"+",null,"+",null,"+",null,-1,null,null,null,null,null,"м",null,0,null,{"$f":"((Z18:Z40=\"+\")*C18:C40)","v":741}]
[null,10,742,"2L-A","26,7-27,0","Песок","1 ящик","м","+","+","+","+","+",null,null,"+",null,null,null,null,"+","+","+","+",null,null,null,null,null,null,null,-1,null,null,null,null,null,"м",null,0,null,{"$f":"((Z19:Z41=\"+\")*C19:C41)","v":0}]
[null,11,743,"2L-A","30,2-30,5","Песок","1 ящик","м","+","+","+",null,"+",null,null,null,null,null,null,null,"+","+","+","+","+",null,"+",null,null,null,null,-1,null,null,null,null,null,"м",null,743,null,{"$f":"((Z20:Z42=\"+\")*C20:C42)","v":0}]
[null,12,744,"2L-A","31,8-32,2","Суглинок","1 ящик","м","+","+","+","+",null,"+","+",null,null,null,null,null,null,null,null,null,null,"+",null,null,null,"+",null,-1,null,null,null,null,null,"м",null,0,null,{"$f":"((Z21:Z43=\"+\")*C21:C43)","v":744}]
[null,13,745,"2L-A","33,1-33,3","Песок","2 ящик","м","+","+","+",null,"+",null,null,"+",null,"+","+","+",null,null,null,null,"+",null,null,"+",null,null,null,-1,null,null,null,null,null,"м",null,745,null,{"$f":"((Z22:Z44=\"+\")*C22:C44)","v":0}]
[null,14,746,"2L-A","35,4-35,7","Суглинок","2 ящик","м","+","+","+","+",null,"+","+",null,null,null,null,null,"+","+","+","+",null,null,null,null,null,null,null,-1,null,null,null,null,null,"м",null,0,null,{"$f":"((Z23:Z45=\"+\")*C23:C45)","v":0}]
[null,15,747,"2L-A","37,3-37,6","Суглинок","1 ящик","м","+","+","+",null,null,"+","+",null,null,null,null,null,null,null,null,null,"+",null,"+",null,null,"+",null,-1,null,null,null,null,null,"м",null,747,null,{"$f":"SUM((Z24:Z46=\"+\")*C24:C46)","v":0}]
[null,16,748,"6L-A","19,4-19,8","Песок","2 ящик","м","+","+","+","+","+",null,null,"+",null,null,null,null,"+","+","+","+",null,null,null,null,null,null,null,-1,null,null,null,null,null,"м",null,0,null,{"$f":"SUM((Z25:Z47=\"+\")*C25:C47)","v":0}]
[null,17,749,"6L-A","22,1-22,4","Песок","2 ящик","м","+","+","+",null,"+",null,null,null,null,"+","+","+","+","+","+","+",null,null,"+","+",null,"+",null,-1,null,null,null,null,null,"м",null,0,null,{"$f":"SUM((Z26:Z48=\"+\")*C26:C48)","v":0}]
[null,18,750,"6L-A","24,6-24,8","Песок","2 ящик","м","+","+","+","+","+",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-1,null,null,null,null,null,"м",null,0,null,{"$f":"SUM((Z27:Z49=\"+\")*C27:C49)","v":0}]
[null,19,751,"6L-A","26,7-27,0","Песок","2 ящик","м","+","+","+",null,"+",null,null,"+",null,null,null,null,null,null,null,null,null,"+",null,"+",null,null,null,-1,null,null,null,null,null,"м",null,0,null,{"$f":"SUM((Z28:Z50=\"+\")*C28:C50)","v":751}]
[null,20,752,"19L-A","16,6-16,9","Песок","2 ящик","м","+","+","+",null,"+",null,null,null,null,null,null,null,"+","+","+","+",null,null,null,null,null,"+",null,-1,null,null,null,null,null,"м"]
[null,21,753,"19L-A","18,0-18,4","Песок","2 ящик","м","+","+","+","+","+",null,null,null,null,"+","+","+","+","+","+","+",null,null,"+",null,null,null,null,-1,null,null,null,null,null,"м"]
[null,22,754,"20L-A","23,9-24,2","Песок","2 ящик","м","+","+","+",null,"+",null,null,"+",null,null,null,null,null,null,null,null,"+",null,null,"+",null,null,null,-1,null,null,null,null,null,"м"]
[null,23,755,"20L-A","39,5-39,8","Суглинок","2 ящик","м","+","+","+","+",null,"+","+",null,null,null,null,null,"+","+","+","+",null,null,"+","+",null,"+",null,-1,null,null,null,null,null,"м"]
[]
[null,"Итог",{"$f":"COUNTA(C10:C33)","v":23},null,null,null,null,null,{"$f":"COUNTA(I10:I33)","v":23},23,23,11,15,6,8,9,1,5,5,5,13,13,13,13,7,5,8,8,0,9,3,23,0,0,0,0,0,23]

{"sheet":"Шариковый штамп (24)","index":1,"n_rows":6,"n_cols":12,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[24]
[]
["Лабораторный №",734,736,739,743,745,747,754]
[null,{"$f":"IFERROR(INDEX(Реестр!$C:$C,SMALL(IF(INDEX(Реестр!$I10:$AK99,,MATCH(LEFTB(MID(CELL(\"имяфайла\",A1),SEARCH(\"]\",CELL(\"имяфайла\",A1))+1,99),15)&\"*\",Реестр!$I8:$AK8,))=\"+\",ROW(Реестр!$C10:$C99)),COLUMN(A4))),\"\")","v":734},{"$f":"IFERROR(INDEX(Реестр!$C:$C,SMALL(IF(INDEX(Реестр!$I10:$AK99,,MATCH(LEFTB(MID(CELL(\"имяфайла\",B1),SEARCH(\"]\",CELL(\"имяфайла\",B1))+1,99),15)&\"*\",Реестр!$I8:$AK8,))=\"+\",ROW(Реестр!$C10:$C99)),COLUMN(B4))),\"\")","v":736},{"$f":"IFERROR(INDEX(Реестр!$C:$C,SMALL(IF(INDEX(Реестр!$I10:$AK99,,MATCH(LEFTB(MID(CELL(\"имяфайла\",C1),SEARCH(\"]\",CELL(\"имяфайла\",C1))+1,99),15)&\"*\",Реестр!$I8:$AK8,))=\"+\",ROW(Реестр!$C10:$C99)),COLUMN(C4))),\"\")","v":739},{"$f":"IFERROR(INDEX(Реестр!$C:$C,SMALL(IF(INDEX(Реестр!$I10:$AK99,,MATCH(LEFTB(MID(CELL(\"имяфайла\",D1),SEARCH(\"]\",CELL(\"имяфайла\",D1))+1,99),15)&\"*\",Реестр!$I8:$AK8,))=\"+\",ROW(Реестр!$C10:$C99)),COLUMN(D4))),\"\")","v":743},{"$f":"IFERROR(INDEX(Реестр!$C:$C,SMALL(IF(INDEX(Реестр!$I10:$AK99,,MATCH(LEFTB(MID(CELL(\"имяфайла\",E1),SEARCH(\"]\",CELL(\"имяфайла\",E1))+1,99),15)&\"*\",Реестр!$I8:$AK8,))=\"+\",ROW(Реестр!$C10:$C99)),COLUMN(E4))),\"\")","v":745},{"$f":"IFERROR(INDEX(Реестр!$C:$C,SMALL(IF(INDEX(Реестр!$I10:$AK99,,MATCH(LEFTB(MID(CELL(\"имяфайла\",F1),SEARCH(\"]\",CELL(\"имяфайла\",F1))+1,99),15)&\"*\",Реестр!$I8:$AK8,))=\"+\",ROW(Реестр!$C10:$C99)),COLUMN(F4))),\"\")","v":747},{"$f":"IFERROR(INDEX(Реестр!$C:$C,SMALL(IF(INDEX(Реестр!$I10:$AK99,,MATCH(LEFTB(MID(CELL(\"имяфайла\",G1),SEARCH(\"]\",CELL(\"имяфайла\",G1))+1,99),15)&\"*\",Реестр!$I8:$AK8,))=\"+\",ROW(Реестр!$C10:$C99)),COLUMN(G4))),\"\")","v":754},{"$f":"IFERROR(INDEX(Реестр!$C:$C,SMALL(IF(INDEX(Реестр!$I10:$AK99,,MATCH(LEFTB(MID(CELL(\"имяфайла\",H1),SEARCH(\"]\",CELL(\"имяфайла\",H1))+1,99),15)&\"*\",Реестр!$I8:$AK8,))=\"+\",ROW(Реестр!$C10:$C99)),COLUMN(H4))),\"\")","v":""},{"$f":"IFERROR(INDEX(Реестр!$C:$C,SMALL(IF(INDEX(Реестр!$I10:$AK99,,MATCH(LEFTB(MID(CELL(\"имяфайла\",I1),SEARCH(\"]\",CELL(\"имяфайла\",I1))+1,99),15)&\"*\",Реестр!$I8:$AK8,))=\"+\",ROW(Реестр!$C10:$C99)),COLUMN(I4))),\"\")","v":""},{"$f":"IFERROR(INDEX(Реестр!$C:$C,SMALL(IF(INDEX(Реестр!$I10:$AK99,,MATCH(LEFTB(MID(CELL(\"имяфайла\",J1),SEARCH(\"]\",CELL(\"имяфайла\",J1))+1,99),15)&\"*\",Реестр!$I8:$AK8,))=\"+\",ROW(Реестр!$C10:$C99)),COLUMN(J4))),\"\")","v":""},{"$f":"IFERROR(INDEX(Реестр!$C:$C,SMALL(IF(INDEX(Реестр!$I10:$AK99,,MATCH(LEFTB(MID(CELL(\"имяфайла\",K1),SEARCH(\"]\",CELL(\"имяфайла\",K1))+1,99),15)&\"*\",Реестр!$I8:$AK8,))=\"+\",ROW(Реестр!$C10:$C99)),COLUMN(K4))),\"\")","v":""}]
[null,{"$f":"INDEX(Реестр!$C10:$C32,SMALL(IF((Реестр!$I9:$AE9=$A1)*(Реестр!$I10:$AE32=\"+\"),Реестр!$B10:$B32),COLUMN(A4)))","v":734},{"$f":"INDEX(Реестр!$C10:$C32,SMALL(IF((Реестр!$I9:$AE9=24)*(Реестр!$I10:$AE32=\"+\"),Реестр!$B10:$B32),COLUMN(B4)))","v":736},{"$f":"INDEX(Реестр!$C10:$C32,SMALL(IF((Реестр!$I9:$AE9=24)*(Реестр!$I10:$AE32=\"+\"),Реестр!$B10:$B32),COLUMN(C4)))","v":739},{"$f":"INDEX(Реестр!$C10:$C32,SMALL(IF((Реестр!$I9:$AE9=24)*(Реестр!$I10:$AE32=\"+\"),Реестр!$B10:$B32),COLUMN(D4)))","v":743},{"$f":"INDEX(Реестр!$C10:$C32,SMALL(IF((Реестр!$I9:$AE9=24)*(Реестр!$I10:$AE32=\"+\"),Реестр!$B10:$B32),COLUMN(E4)))","v":745},{"$f":"INDEX(Реестр!$C10:$C32,SMALL(IF((Реестр!$I9:$AE9=24)*(Реестр!$I10:$AE32=\"+\"),Реестр!$B10:$B32),COLUMN(F4)))","v":747},{"$f":"INDEX(Реестр!$C10:$C32,SMALL(IF((Реестр!$I9:$AE9=24)*(Реестр!$I10:$AE32=\"+\"),Реестр!$B10:$B32),COLUMN(G4)))","v":754},{"$f":"INDEX(Реестр!$C10:$C32,SMALL(IF((Реестр!$I9:$AE9=24)*(Реестр!$I10:$AE32=\"+\"),Реестр!$B10:$B32),COLUMN(H4)))","v":{"$error":"#NUM!"}},{"$f":"INDEX(Реестр!$C10:$C32,SMALL(IF((Реестр!$I9:$AE9=24)*(Реестр!$I10:$AE32=\"+\"),Реестр!$B10:$B32),COLUMN(I4)))","v":{"$error":"#NUM!"}},{"$f":"INDEX(Реестр!$C10:$C32,SMALL(IF((Реестр!$I9:$AE9=24)*(Реестр!$I10:$AE32=\"+\"),Реестр!$B10:$B32),COLUMN(J4)))","v":{"$error":"#NUM!"}},{"$f":"INDEX(Реестр!$C10:$C32,SMALL(IF((Реестр!$I9:$AE9=24)*(Реестр!$I10:$AE32=\"+\"),Реестр!$B10:$B32),COLUMN(K4)))","v":{"$error":"#NUM!"}}]
[null,{"$f":"SMALL(IF((Реестр!$I9:$AE9=$A1)*(Реестр!$I10:$AE32=\"+\"),Реестр!$C10:$C32),COLUMN(A6))","v":734},{"$f":"SMALL(IF((Реестр!$I9:$AE9=$A1)*(Реестр!$I10:$AE32=\"+\"),Реестр!$C10:$C32),COLUMN(B6))","v":736},{"$f":"SMALL(IF((Реестр!$I9:$AE9=$A1)*(Реестр!$I10:$AE32=\"+\"),Реестр!$C10:$C32),COLUMN(C6))","v":739},{"$f":"SMALL(IF((Реестр!$I9:$AE9=$A1)*(Реестр!$I10:$AE32=\"+\"),Реестр!$C10:$C32),COLUMN(D6))","v":743},{"$f":"SMALL(IF((Реестр!$I9:$AE9=$A1)*(Реестр!$I10:$AE32=\"+\"),Реестр!$C10:$C32),COLUMN(E6))","v":745},{"$f":"SMALL(IF((Реестр!$I9:$AE9=$A1)*(Реестр!$I10:$AE32=\"+\"),Реестр!$C10:$C32),COLUMN(F6))","v":747},{"$f":"SMALL(IF((Реестр!$I9:$AE9=$A1)*(Реестр!$I10:$AE32=\"+\"),Реестр!$C10:$C32),COLUMN(G6))","v":754},{"$f":"SMALL(IF((Реестр!$I9:$AE9=$A1)*(Реестр!$I10:$AE32=\"+\"),Реестр!$C10:$C32),COLUMN(H6))","v":{"$error":"#NUM!"}},{"$f":"SMALL(IF((Реестр!$I9:$AE9=$A1)*(Реестр!$I10:$AE32=\"+\"),Реестр!$C10:$C32),COLUMN(I6))","v":{"$error":"#NUM!"}},{"$f":"SMALL(IF((Реестр!$I9:$AE9=$A1)*(Реестр!$I10:$AE32=\"+\"),Реестр!$C10:$C32),COLUMN(J6))","v":{"$error":"#NUM!"}},{"$f":"SMALL(IF((Реестр!$I9:$AE9=$A1)*(Реестр!$I10:$AE32=\"+\"),Реестр!$C10:$C32),COLUMN(K6))","v":{"$error":"#NUM!"}}]