{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["СМЕТА","Этап1"],"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":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Наименование работ","Помещения","Кол-во","Ед.изм.","Цена за ед работы","Цена за ед мат-ла","Работа","Материал","Всего, руб."]
[]
["Этап №1"]
["Снятие краски и шпатлевки с потолка","-",50,"кв.м.",100,0,{"$f":"ROUND(PRODUCT(C6:E6),0)","v":5000},{"$f":"ROUND(PRODUCT(C6,F6),0)","v":0},{"$f":"SUM(G6:H6)","v":5000}]
[]
[]
[]
[]
[]
[]
[]
["Итого (этап №1):",null,null,null,null,null,{"$f":"ROUND(SUMPRODUCT(C5:C14,E5:E14),0)","v":5000},{"$f":"ROUND(SUMPRODUCT(C5:C14,F5:F14),0)","v":0}]
[]
["Этап №2"]
[null,null,null,null,null,null,{"$f":"ROUND(PRODUCT(C17:E17),0)","v":0},{"$f":"ROUND(PRODUCT(C17,F17),0)","v":0},{"$f":"SUM(G17:H17)","v":0}]
[]
[]
[]
[]
[]
[]
[]
["Итого (этап №2):",null,null,null,null,null,{"$f":"ROUND(SUMPRODUCT(C16:C25,E16:E25),0)","v":0},{"$f":"ROUND(SUMPRODUCT(C16:C25,F16:F25),0)","v":0}]
[]
["Накладные расходы",null,1,"компл",0,1000,{"$f":"ROUND(PRODUCT(C27:E27),1)","v":0},{"$f":"PRODUCT(C27,F27)","v":1000},{"$f":"SUM(G27:H27)","v":1000}]
[]
["Итого на работу:",null,null,null,null,null,{"$f":"SUMPRODUCT(C5:C29,E5:E29)","v":5000}]
["Итого на материал:",null,null,null,null,null,null,{"$f":"ROUNDDOWN(SUMPRODUCT(C3:C29,F3:F29),0)","v":1000}]

{"sheet":"Этап1","index":1,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":false,"merged":[[4,7,9,14],[2,0,2,4]]}
[]
[]
["ЭТАП №"]
[]
["Наименование работ","Кол-во:","Ед. изм.","Цена за ед.работы","ВСЕГО",null,null,"Нужно вставить все строки этапа №, находящиеся в листе \"СМЕТА\" от значения \"Этап №\" до значения \"Итого (этап №):\". Если изменяется номер этапа, то соот-но при выполнении макроса добавляет именно те строки, которые указаны в этом этапе. Благодарю за помощь!"]
["Итого:"]