{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Лист1","Лист2"],"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":"Лист1","index":0,"n_rows":29,"n_cols":23,"rows_kept":29,"cut":false,"hidden":false,"merged":[[28,13,28,17],[23,14,24,17],[25,13,26,13],[1,1,1,2],[2,1,2,2],[4,3,8,8],[3,1,3,8],[2,3,2,8],[1,3,1,8],[10,1,11,9],[10,10,13,12],[10,13,10,17],[26,18,26,35],[23,1,23,2],[12,2,13,2],[12,1,13,1],[12,9,13,9],[12,3,12,8],[23,3,23,5],[13,7,13,8],[21,7,21,8],[12,13,12,17]]}
[]
[null,"Проектный возраст",null,"Выбрать возраст конструкции"]
[null,"Схема А",null,"Выбрать схему проведения испытания"]
[null,"ВИДЫ ИСПЫТАНИЙ"]
[null,1,"Кубы","Выбрать вид испытания для контроля "]
[null,2]
[null,3]
[null,4]
[null,5]
[]
[null,"Контроль монолитных конструкций производится партиями изготовленных за определенное время (ГОСТ 18105-2010).                                                                                                                                                                                      В которые включают конструкции или бетонную смесь, изготовленные по одной технологии за определенный промежуток времени продолжительностью от одной смены до одной недели (ГОСТ 18105-2010 п.п. 5.1)                                                                                                                      Контроль прочности бетона для БСГ (кубы) проводят по схеме А, Б, в которые включают бетонную смесь одного номинального состава, изготовленная по одной технологии за определенный промежуток времени продолжительностью от одной смены (сутки).",null,null,null,null,null,null,null,null,"Промежуточные расчеты",null,null,"ЦЕНА"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,200,150,150,900,{"$f":"2500+1500","v":4000}]
[null,"№ п/п","Наименование конструкции","РАЗМЕРЫ",null,null,null,null,null,"Кол-во залитых конструкций за смену (ПАРТИЯ)",null,null,null,"Кол-во испытаний по неразрушающему контролю"]
[null,null,null,"Длина","Ширина","Высота","Площадь","Объем",null,null,null,null,null,"Кубы","Молоток Шмидта","Ультразвук","Отрыв со скалыванием","Керны"]
[null,1,"Фундамент",null,null,null,{"$f":"IF(SUM(D15:F15)=0,\"\",D15*E15)","v":""},{"$f":"IF(SUM(D15:F15)=0,\"\",D15*E15*F15)","v":""},150,null,{"$f":"_xlfn.CEILING.PRECISE(IF(H15=\"\",0,H15/100),1)","v":0},{"$f":"_xlfn.CEILING.PRECISE(IF(I15=\"\",0,I15/100),1)","v":2},{"$f":"IF(K15=0,L15,IF(L15=0,K15,\"\"))","v":2},{"$f":"IF(ISNUMBER(MATCH(N$14,$C$5:$C$9,0)),IF($M15=0,\"\",IF($B$2=$W$23,M15*3,IF($B$2=$W$22,M15*3,IF($B$2=$W$24,M15*3,\"\")))),\"\")","v":6},{"$f":"IF(ISNUMBER(MATCH(O$14,$C$5:$C$9,0)),IF($J15=\"\",\"\",IF($B$2=$W$23,3,IF($B$2=$W$22,1,IF($B$2=$W$24,3,\"\")))),\"\")","v":""},"","",""]
[null,2,"Стены",null,null,null,"",{"$f":"IF(SUM(D16:F16)=0,\"\",D16*E16*F16)","v":""},300,null,{"$f":"_xlfn.CEILING.PRECISE(IF(H16=\"\",0,H16/100),1)","v":0},{"$f":"_xlfn.CEILING.PRECISE(IF(I16=\"\",0,I16/100),1)","v":3},{"$f":"IF(K16=0,L16,IF(L16=0,K16,\"\"))","v":3},9,"","","","",null,null,"Кубы",null,"Схема А"]
[null,3,"Пилоны",null,null,null,"","",250,null,{"$f":"_xlfn.CEILING.PRECISE(IF(H17=\"\",0,H17/100),1)","v":0},3,3,9,{"$f":"IF(ISNUMBER(MATCH(O$14,$C$5:$C$9,0)),IF($J17=\"\",\"\",IF($B$2=$W$23,$J17*6,IF($B$2=$W$22,1,IF($B$2=$W$24,3,\"\")))),\"\")","v":""},{"$f":"IF(ISNUMBER(MATCH(P$14,$C$5:$C$9,0)),IF($J17=\"\",\"\",IF($B$2=$W$23,$J17*6,IF($B$2=$W$22,1,IF($B$2=$W$24,3,\"\")))),\"\")","v":""},{"$f":"IF(ISNUMBER(MATCH(Q$14,$C$5:$C$9,0)),IF($J17=\"\",\"\",IF($B$2=$W$23,3,IF($B$2=$W$22,1,IF($B$2=$W$24,3,\"\")))),\"\")","v":""},"",null,null,"Молоток Шмидта",null,"Схема Б"]
[null,4,"Колонны",null,null,null,{"$f":"IF(SUM(D18:F18)=0,\"\",D18*E18)","v":""},"",null,null,{"$f":"_xlfn.CEILING.PRECISE(IF(H18=\"\",0,H18/100),1)","v":0},0,0,"",{"$f":"IF(ISNUMBER(MATCH(O$14,$C$5:$C$9,0)),IF($J18=\"\",\"\",IF($B$2=$W$23,$J18*6,IF($B$2=$W$22,1,IF($B$2=$W$24,3,\"\")))),\"\")","v":""},{"$f":"IF(ISNUMBER(MATCH(P$14,$C$5:$C$9,0)),IF($J18=\"\",\"\",IF($B$2=$W$23,$J18*6,IF($B$2=$W$22,1,IF($B$2=$W$24,3,\"\")))),\"\")","v":""},"","",null,null,"Ультразвук",null,"Схема В"]
[null,5,"Ригель",null,null,null,"","",null,null,{"$f":"_xlfn.CEILING.PRECISE(IF(H19=\"\",0,H19/100),1)","v":0},0,0,"",{"$f":"IF(ISNUMBER(MATCH(O$14,$C$5:$C$9,0)),IF($J19=\"\",\"\",IF($B$2=$W$23,3,IF($B$2=$W$22,1,IF($B$2=$W$24,3,\"\")))),\"\")","v":""},"","","",null,null,"Отрыв со скалыванием",null,"Схема Г"]
[null,6,"Балка",null,null,null,"","",null,null,{"$f":"_xlfn.CEILING.PRECISE(IF(H20=\"\",0,H20/100),1)","v":0},0,{"$f":"IF(K20=0,L20,IF(L20=0,K20,\"\"))","v":0},"","","","","",null,null,"Керны"]
[null,7,"Плита перекрытия",null,null,null,"","",null,null,{"$f":"_xlfn.CEILING.PRECISE(IF(H21=\"\",0,H21/100),1)","v":0},0,{"$f":"IF(K21=0,L21,IF(L21=0,K21,\"\"))","v":0},"","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(SUM(H15:H21)=0,SUM(I15:I21),IF(SUM(I15:I21)=0,SUM(H15:H21),\"\"))","v":700},null,null,null,null,null,null,null,null,null,null,null,null,null,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 м³ бетона:",null,{"$f":"IF(N29=0,\"\",IF(H22=0,\"\",N29/H22))","v":6.8571428571428568},null,null,null,null,null,"Схема А",null,null,null,{"$f":"IF($B$3=$W$16,SUM(N15:N21),\"\")","v":24},"Данная схема не применима для этих схем при неразрушающем контроле",null,null,null,null,null,null,null,"Экспертная оценка"]
[null,null,null,null,null,null,null,null,null,"Схема Б",null,null,null,{"$f":"IF($B$3=$W$17,SUM(N15:N21),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,"Схема В",null,null,null,null,{"$f":"IF($B$3=$W$18,SUM(O15:O21),\"\")","v":""},{"$f":"IF($B$3=$W$18,SUM(P15:P21),\"\")","v":""},{"$f":"IF($B$3=$W$18,SUM(Q15:Q21),\"\")","v":""},{"$f":"IF($B$3=$W$18,SUM(R15:R21),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,"Схема Г",null,null,null,null,{"$f":"IF($B$3=$W$19,SUM(O16:O22),\"\")","v":""},{"$f":"IF($B$3=$W$19,SUM(P16:P22),\"\")","v":""},{"$f":"IF($B$3=$W$19,SUM(Q15:Q21),\"\")","v":""},{"$f":"IF($B$3=$W$19,SUM(R15:R21),\"\")","v":""},{"$f":"IF(B3=W19,\"Приемка бетона путем сравнения его фактической прочности с требуемой без учета характеристик однородности бетона по прочности не допускается\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,"ЦЕНА",null,null,null,{"$f":"IF(B3=W16,N24*$N$12,IF(B3=W17,N25*$N$12,\"\"))","v":4800},{"$f":"IF($B$3=$W$18,O$26*O$12,IF($B$3=$W$19,O$27*O$12,\"\"))","v":""},{"$f":"IF($B$3=$W$18,P$26*P$12,IF($B$3=$W$19,P$27*P$12,\"\"))","v":""},{"$f":"IF($B$3=$W$18,Q$26*Q$12,IF($B$3=$W$19,Q$27*Q$12,\"\"))","v":""},{"$f":"IF($B$3=$W$18,R$26*R$12,IF($B$3=$W$19,R$27*R$12,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,"Общая сумма:",null,null,null,{"$f":"IF(SUM(N28:R28)=0,\"\",SUM(N28:R28))","v":4800}]

{"sheet":"Лист2","index":1,"n_rows":12,"n_cols":16,"rows_kept":12,"cut":false,"hidden":false,"merged":[[11,3,11,15]]}
[]
[]
[]
[]
[null,null,"Нач. лаборатории",70000,70000,70000,70000,70000,70000,70000,70000,70000,70000,70000,70000,70000]
[null,null,"Вед. Инженер-технолог",65000,65000,65000,65000,65000,65000,65000,65000,65000,65000,65000,65000,65000]
[null,null,"Инженер-технолог",60000,60000,60000,60000,60000,60000,60000,60000,60000,60000,60000,60000,60000]
[null,null,"Инженер-технолог",60000,60000,60000,60000,60000,60000,60000,60000,60000,60000,60000,60000,60000]
[null,null,"Инженер",50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000]
[null,null,null,{"$f":"SUM(D5:D9)","v":305000},{"$f":"SUM(E5:E9)","v":305000},305000,305000,305000,305000,305000,305000,305000,305000,305000,305000,305000]
[null,0.17,"Налог",{"$f":"D10*$B$11+D10","v":356850},{"$f":"E10*$B$11+E10","v":356850},356850,356850,356850,356850,356850,356850,356850,356850,356850,356850,356850]
[null,null,null,{"$f":"SUM(D11:P11)","v":4639050}]