{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["СМЕТА","Этап"],"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":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Наименование работ","Помещения","Кол-во","Ед.изм.","Цена за ед работы","Цена за ед мат-ла","Работа","Материал","Всего, руб."]
[]
["Этап №1"]
["Снятие краски и шпатлевки с потолка","-",45,"кв.м.",100,0,{"$f":"ROUND(PRODUCT(C6:E6),0)","v":4500},{"$f":"ROUND(PRODUCT(C6,F6),0)","v":0},{"$f":"SUM(G6:H6)","v":4500}]
["Снятие краски и шпатлевки со стен",null,4,"кв.м.",39,0,{"$f":"ROUND(PRODUCT(C7:E7),0)","v":156},{"$f":"ROUND(PRODUCT(C7,F7),0)","v":0},{"$f":"SUM(G7:H7)","v":156}]
["Снятие пола",null,4,"кв.м.",40,0,160,0,160]
["Итого (этап №1):",null,null,null,null,null,{"$f":"ROUND(SUMPRODUCT(C5:C9,E5:E9),0)","v":4816},{"$f":"ROUND(SUMPRODUCT(C5:C9,F5:F9),0)","v":0}]
[]
["Этап №2"]
["Демонтаж пола",null,13,"кв.м.",150,0,{"$f":"ROUND(PRODUCT(C12:E12),0)","v":1950},{"$f":"ROUND(PRODUCT(C12,F12),0)","v":0},{"$f":"SUM(G12:H12)","v":1950}]
["Демонтаж стен",null,16,"кв.м.",45,0,720,0,720]
["Демонтаж потолка",null,29,"кв.м.",39,0,1131,0,1131]
["Итого (этап №2):",null,null,null,null,null,{"$f":"ROUND(SUMPRODUCT(C11:C15,E11:E15),0)","v":3801},{"$f":"ROUND(SUMPRODUCT(C11:C15,F11:F15),0)","v":0}]
[]
["Накладные расходы",null,1,"компл",0,1000,{"$f":"ROUND(PRODUCT(C17:E17),1)","v":0},{"$f":"PRODUCT(C17,F17)","v":1000},{"$f":"SUM(G17:H17)","v":1000}]
[]
["Итого на работу:",null,null,null,null,null,{"$f":"SUMPRODUCT(C5:C19,E5:E19)","v":8617}]
["Итого на материал:",null,null,null,null,null,null,{"$f":"ROUNDDOWN(SUMPRODUCT(C3:C19,F3:F19),0)","v":1000}]

{"sheet":"Этап","index":1,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[[16,0,17,4],[18,0,18,4],[26,0,26,4],[2,0,2,4],[0,0,1,4],[10,0,10,4]]}
["Перед началом выполнения макроса"]
[]
["Приемка работ №2"]
[]
["Наименование работ","Кол-во:","Ед. изм.","Цена за ед.работы","ВСЕГО"]
["Демонтаж пола",13,"кв.м.",150,{"$f":"B6*D6","v":1950}]
["Демонтаж стен",16,"кв.м.",45,{"$f":"B7*D7","v":720}]
["Демонтаж потолка",29,"кв.м.",39,{"$f":"B8*D8","v":1131}]
["Итого:",null,null,null,{"$f":"SUM(E6:E8)","v":3801}]
[]
["Все работы выполнены в срок."]
[]
[]
[]
[]
[]
["После выполнения макроса"]
[]
["Приемка работ №1"]
[]
["Наименование работ","Кол-во:","Ед. изм.","Цена за ед.работы","ВСЕГО"]
["Снятие краски и шпатлевки с потолка",45,"кв.м.",100,{"$f":"B22*D22","v":4500}]
["Снятие краски и шпатлевки со стен",4,"кв.м.",39,{"$f":"B23*D23","v":156}]
["Снятие пола",4,"кв.м.",40,{"$f":"B24*D24","v":160}]
["Итого:",null,null,null,{"$f":"SUMPRODUCT(B21:B25,D21:D25)","v":4816}]
[]
["Все работы выполнены в срок."]