{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Данные","Таблица 2","Объект"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Объекты",null,"Вид_работ"]
["Объект",null,"Смета"]
[null,null,"Доп.работы"]

{"sheet":"Таблица 2","index":1,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"","",null,null,null,"Итого:",{"$f":"SUBTOTAL(9,M3:M8845)","v":49688.800000000003}]
["Дата ","Объект","Наименование работ","Исполнитель","Helper column","Подпроект","Цена по смете","Базовая расценка","Цена по договоренности","Кол-во по смете","Ед. учета выполнения","Выполнение в ед. учета","Выполнение в руб."]
[null,"Объект","Иньектирование кирпичной кладки ","Исполнитель 1",{"$f":"IF(D3=\"Исполнитель 1\",0,1)","v":0},{"$f":"IFERROR(VLOOKUP(C3,INDIRECT(B3&\"!B:X\"),2,0),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(C3,INDIRECT(B3&\"!B:X\"),6,0),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(C3,INDIRECT(B3&\"!B:X\"),7,0),\"\")","v":1463},{"$f":"vpr(C3,Объект!B:J,8+E3)","v":1170.4000000000001},{"$f":"IFERROR(VLOOKUP(C3,INDIRECT(B3&\"!B:X\"),5,0),\"\")","v":56},{"$f":"IFERROR(VLOOKUP(C3,INDIRECT(B3&\"!B:X\"),4,0),\"\")","v":"м2"},22,{"$f":"IFERROR(IF(I3*L3<>0,L3*I3,\"\"),\"\")","v":25748.800000000003}]
[null,"Объект","Разборка поздних заложенных кирпичом оконных проемов цокольного этажа дворового фасада 12 шт.","Исполнитель 2",{"$f":"IF(D4=\"Исполнитель 1\",0,1)","v":1},{"$f":"IFERROR(VLOOKUP(C4,INDIRECT(B4&\"!B:X\"),2,0),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(C4,INDIRECT(B4&\"!B:X\"),6,0),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(C4,INDIRECT(B4&\"!B:X\"),7,0),\"\")","v":1197},{"$f":"vpr(C4,Объект!B:J,8+E4)","v":1197},{"$f":"IFERROR(VLOOKUP(C4,INDIRECT(B4&\"!B:X\"),5,0),\"\")","v":24},{"$f":"IFERROR(VLOOKUP(C4,INDIRECT(B4&\"!B:X\"),4,0),\"\")","v":"м3"},20,{"$f":"IFERROR(IF(I4*L4<>0,L4*I4,\"\"),\"\")","v":23940}]
[null,null,null,null,1,"","","",{"$f":"vpr(C5,Объект!B:J,8+E5)","v":0},"","",null,""]
[null,null,null,null,1,"","","",{"$f":"vpr(C6,Объект!B:J,8+E6)","v":0},"","",null,""]
[null,null,null,null,1,"","","",{"$f":"vpr(C7,Объект!B:J,8+E7)","v":0},"","",null,""]
[null,null,null,null,1,"","","",{"$f":"vpr(C8,Объект!B:J,8+E8)","v":0},"","",null,""]
[null,null,null,null,1,"","","",{"$f":"vpr(C9,Объект!B:J,8+E9)","v":0},"","",null,""]
[null,null,null,null,1,"","","",{"$f":"vpr(C10,Объект!B:J,8+E10)","v":0},"","",null,""]
[null,null,null,null,1,"","","",{"$f":"vpr(C11,Объект!B:J,8+E11)","v":0},"","",null,""]
[null,null,null,null,1,"","","",{"$f":"vpr(C12,Объект!B:J,8+E12)","v":0},"","",null,""]
[null,null,null,null,1,"","","",{"$f":"vpr(C13,Объект!B:J,8+E13)","v":0},"","",null,""]
[null,null,null,null,1,"","","",{"$f":"vpr(C14,Объект!B:J,8+E14)","v":0},"","",null,""]
[null,null,null,null,1,"","","",{"$f":"vpr(C15,Объект!B:J,8+E15)","v":0},"","",null,""]
[null,null,null,null,1,"","","",{"$f":"vpr(C16,Объект!B:J,8+E16)","v":0},"","",null,""]
[null,null,null,null,1,"","","",{"$f":"vpr(C17,Объект!B:J,8+E17)","v":0},"","",null,""]
[null,null,null,null,1,"","","",{"$f":"vpr(C18,Объект!B:J,8+E18)","v":0},"","",null,""]
[null,null,null,null,1,"","","",{"$f":"vpr(C19,Объект!B:J,8+E19)","v":0},"","",null,""]
[null,null,null,null,1,"","","",{"$f":"vpr(C20,Объект!B:J,8+E20)","v":0},"","",null,""]
[null,null,null,null,1,null,null,null,{"$f":"vpr(C21,Объект!B:J,8+E21)","v":0}]

{"sheet":"Объект","index":2,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["№ п\\п","Наименование работ","Маркировка","Размер","Ед. изм.","Кол-во по смете","Цена за ед. по смете","Базовая расценка","Исполнитель","Исполнитель"]
[null,null,null,null,null,null,null,null,"Исполнитель 1","Исполнитель 2"]
[]
[null,"Реставрация фасада 1"]
[1,"Разборка поздних заложенных кирпичом оконных проемов цокольного этажа дворового фасада 12 шт.",null,null,"м3",24,null,1197,957.6]
[2,"Разборка кирпичной кладки заложенных оконных проемов",null,null,"м3",15,null,1197,957.6]
[3,"Вновь возводимая кирпичная кладка (из реставрационного кирпича)",null,null,"м3",10,null,7448,5958.4000000000005]
[4,"Промывка фасада водой",null,null,"м2",2701,null,10.64,8.5120000000000005]
[5,"Иньектирование кирпичной кладки ",null,null,"м2",56,null,1463,1170.4000000000001]
[]
[]
[null,"Реставрация  фасада 2"]
[1,"Разборка поздних заложенных кирпичом оконных проемов цокольного этажа дворового фасада 12 шт.",null,null,"м3",19.200000000000003,null,1197,null,1197]
[2,"Разборка кирпичной кладки заложенных оконных проемов",null,null,"м3",12,null,1197,null,1197]
[3,"Вновь возводимая кирпичная кладка (из реставрационного кирпича)",null,null,"м3",8,null,7448,null,7448]
[4,"Промывка фасада водой",null,null,"м2",2160.8000000000002,null,10.64,null,10.64]
[5,"Иньектирование кирпичной кладки ",null,null,"м2",44.800000000000004,null,1463,null,1463]