{"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":29,"n_cols":9,"rows_kept":29,"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}]
["аррр",null,4,"кв.м.",39,8,{"$f":"ROUND(PRODUCT(C7:E7),0)","v":156},{"$f":"ROUND(PRODUCT(C7,F7),0)","v":32},{"$f":"SUM(G7:H7)","v":188}]
["апапер",null,4,"кв.м.",40,8,160,32,192]
["апрр",null,4,"кв.м.",34,8,136,32,168]
["Итого (этап №1):",null,null,null,null,null,{"$f":"ROUND(SUMPRODUCT(C5:C10,E5:E10),0)","v":5452},{"$f":"ROUND(SUMPRODUCT(C5:C10,F5:F10),0)","v":96}]
[]
["Этап №2"]
["Снятие краски и шпатлевки с потолка",null,null,null,null,null,{"$f":"ROUND(PRODUCT(C13:E13),0)","v":0},{"$f":"ROUND(PRODUCT(C13,F13),0)","v":0},{"$f":"SUM(G13:H13)","v":0}]
["аррр",null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,0,0,0]
["Итого (этап №2):",null,null,null,null,null,{"$f":"ROUND(SUMPRODUCT(C12:C17,E12:E17),0)","v":0},{"$f":"ROUND(SUMPRODUCT(C12:C17,F12:F17),0)","v":0}]
[]
["Этап №3"]
["Снятие краски и шпатлевки с потолка",null,null,null,null,null,{"$f":"ROUND(PRODUCT(C20:E20),0)","v":0},{"$f":"ROUND(PRODUCT(C20,F20),0)","v":0},{"$f":"SUM(G20:H20)","v":0}]
[null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,0,0,0]
["Итого (этап №3):",null,null,null,null,null,{"$f":"ROUND(SUMPRODUCT(C19:C24,E19:E24),0)","v":0},{"$f":"ROUND(SUMPRODUCT(C19:C24,F19:F24),0)","v":0}]
[]
["Накладные расходы",null,1,"компл",0,1000,{"$f":"ROUND(PRODUCT(C26:E26),1)","v":0},{"$f":"PRODUCT(C26,F26)","v":1000},{"$f":"SUM(G26:H26)","v":1000}]
[]
["Итого на работу:",null,null,null,null,null,{"$f":"SUMPRODUCT(C5:C28,E5:E28)","v":5452}]
["Итого на материал:",null,null,null,null,null,null,{"$f":"ROUNDDOWN(SUMPRODUCT(C3:C28,F3:F28),0)","v":1096}]

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