{"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":"Лист1","index":0,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Наименование работ","Помещения","Кол-во","Ед.изм.","Цена за ед работы","Цена за ед мат-ла","Работа","Материал","Всего, руб."]
[]
["Этап №1"]
["Снятие краски и шпатлевки с потолка","-",50,"кв.м.",100,0,{"$f":"ROUND($C6*E6,0)","v":5000},{"$f":"ROUND($C6*F6,0)","v":0},{"$f":"SUM(G6:H6)","v":5000}]
["Всякое",null,51,"кв.м.",100,0,{"$f":"ROUND($C7*E7,0)","v":5100},0,5100]
["Всякое",null,0,"кв.м.",100,0,0,0,0]
["Всякое",null,0,"кв.м.",100,0,0,0,0]
["Всякое",null,0,"кв.м.",100,0,0,0,0]
["Всякое",null,55,"кв.м.",100,0,5500,0,5500]
["Всякое",null,56,"кв.м.",100,0,5600,0,5600]
["Всякое",null,57,"кв.м.",100,0,5700,0,5700]
["Вынос мусора",null,1,"компл.",0,0,0,0,0]
["Подъем",null,1,"компл.",0,0,0,0,0]
["Накладные расходы",null,0.2,"компл.",0,2000,0,400,400]
["Итого (этап №1):",null,null,null,null,null,{"$f":"ROUND(SUMPRODUCT(C5:C17,E5:E17),0)","v":26900},{"$f":"ROUND(SUMPRODUCT(C5:C17,F5:F17),0)","v":400}]
[]
["Этап №2"]
["Снятие краски и шпатлевки с потолка",null,null,null,null,null,{"$f":"ROUND($C20*E20,0)","v":0},0,{"$f":"SUM(G20:H20)","v":0}]
["Всякое"]
["Всякое"]
["Всякое"]
["Всякое"]
["Всякое"]
["Всякое"]
["Всякое"]
["Вынос мусора",null,1,"компл.",0,0,{"$f":"ROUND($C28*E28,0)","v":0},0,{"$f":"SUM(G28:H28)","v":0}]
["Подъем",null,1,"компл.",0,0,0,0,0]
["Накладные расходы",null,0.2,"компл.",0,2000,0,400,400]
["Итого (этап №2):",null,null,null,null,null,{"$f":"ROUND(SUMPRODUCT(C19:C31,E19:E31),0)","v":0},{"$f":"ROUND(SUMPRODUCT(C19:C31,F19:F31),0)","v":400}]
[]
["Накладные расходы",null,1,"компл",0,2000,{"$f":"ROUND(PRODUCT(C33:E33),1)","v":0},{"$f":"PRODUCT(C33,F33)","v":2000},{"$f":"SUM(G33:H33)","v":2000}]
[]
["Итого на работу:",null,null,null,null,null,{"$f":"SUMPRODUCT(C5:C35,E5:E35)","v":26900}]
["Итого на материал:",null,null,null,null,null,null,{"$f":"ROUNDDOWN(SUMPRODUCT(C3:C35,F3:F35),0)","v":2800}]

{"sheet":"СМЕТА","index":1,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Наименование работ","Помещения","Кол-во","Ед.изм.","Цена за ед работы","Цена за ед мат-ла","Работа","Материал","Всего, руб."]
[]
["Этап №1"]
["Снятие краски и шпатлевки с потолка","-",50,"кв.м.",100,0,{"$f":"ROUND($C6*E6,0)","v":5000},{"$f":"ROUND($C6*F6,0)","v":0},{"$f":"SUM(G6:H6)","v":5000}]
["Всякое",null,51,"кв.м.",100,0,{"$f":"ROUND($C7*E7,0)","v":5100},0,5100]
["Всякое",null,55,"кв.м.",100,0,5500,0,5500]
["Всякое",null,56,"кв.м.",100,0,5600,0,5600]
["Всякое",null,57,"кв.м.",100,0,5700,0,5700]
["Накладные расходы",null,0.2,"компл.",0,2000,0,400,400]
["Итого (этап №1):",null,null,null,null,null,{"$f":"ROUND(SUMPRODUCT(C5:C12,E5:E12),0)","v":26900},{"$f":"ROUND(SUMPRODUCT(C5:C12,F5:F12),0)","v":400}]
[]
["Всякое",null,56,"кв.м.",100,0,{"$f":"ROUND($C14*E14,0)","v":5600},{"$f":"ROUND($C14*F14,0)","v":0},{"$f":"SUM(G14:H14)","v":5600}]
["Всякое",null,57,"кв.м.",100,0,5700,0,5700]
["Накладные расходы",null,0.2,"компл.",0,2000,0,400,400]
["Накладные расходы",null,0.2,"компл.",0,2000,{"$f":"ROUND($C17*E17,0)","v":0},400,{"$f":"SUM(G17:H17)","v":400}]
["Итого (этап №2):",null,null,null,null,null,{"$f":"ROUND(SUMPRODUCT(C17:C18,E17:E18),0)","v":0},{"$f":"ROUND(SUMPRODUCT(C17:C18,F17:F18),0)","v":400}]
[]
["Накладные расходы",null,1,"компл",0,2000,{"$f":"ROUND(PRODUCT(C20:E20),1)","v":0},{"$f":"PRODUCT(C20,F20)","v":2000},{"$f":"SUM(G20:H20)","v":2000}]
[]
["Итого на работу:",null,null,null,null,null,{"$f":"SUMPRODUCT(C5:C22,E5:E22)","v":38200}]
["Итого на материал:",null,null,null,null,null,null,{"$f":"ROUNDDOWN(SUMPRODUCT(C3:C22,F3:F22),0)","v":3200}]