{"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":27,"n_cols":9,"rows_kept":27,"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:C19,E5:E19),0)","v":26900},{"$f":"ROUND(SUMPRODUCT(C5:C19,F5:F19),0)","v":400}]
[]
["Накладные расходы",null,0.2,"компл.",0,2000,{"$f":"ROUND($C21*E21,0)","v":0},400,{"$f":"SUM(G21:H21)","v":400}]
["Итого (этап №2):",null,null,null,null,null,{"$f":"ROUND(SUMPRODUCT(C21:C22,E21:E22),0)","v":0},{"$f":"ROUND(SUMPRODUCT(C21:C22,F21:F22),0)","v":400}]
[]
["Накладные расходы",null,1,"компл",0,2000,{"$f":"ROUND(PRODUCT(C24:E24),1)","v":0},{"$f":"PRODUCT(C24,F24)","v":2000},{"$f":"SUM(G24:H24)","v":2000}]
[]
["Итого на работу:",null,null,null,null,null,{"$f":"SUMPRODUCT(C5:C26,E5:E26)","v":26900}]
["Итого на материал:",null,null,null,null,null,null,{"$f":"ROUNDDOWN(SUMPRODUCT(C3:C26,F3:F26),0)","v":2800}]

{"sheet":"СМЕТА","index":1,"n_rows":21,"n_cols":9,"rows_kept":21,"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},{"$f":"ROUND($C7*F7,0)","v":0},{"$f":"SUM(G7:H7)","v":5100}]
["Всякое",null,55,"кв.м.",100,0,5500,0,5500]
[]
["Всякое",null,null,null,null,null,null,0,0]
[null,null,null,null,100,0,0,0,0]
["Накладные расходы",null,null,null,null,null,null,null,{"$f":"SUM(G12:H12)","v":0}]
["Итого (этап №1):",null,null,null,null,null,{"$f":"ROUND(SUMPRODUCT(C5:C13,E5:E13),0)","v":15600},{"$f":"ROUND(SUMPRODUCT(C5:C13,F5:F13),0)","v":0}]
[]
["Накладные расходы",null,0.2,"компл.",0,2000,{"$f":"ROUND($C15*E15,0)","v":0},400,{"$f":"SUM(G15:H15)","v":400}]
["Итого (этап №2):",null,null,null,null,null,{"$f":"ROUND(SUMPRODUCT(C15:C16,E15:E16),0)","v":0},{"$f":"ROUND(SUMPRODUCT(C15:C16,F15:F16),0)","v":400}]
[]
["Накладные расходы",null,1,"компл",0,2000,{"$f":"ROUND(PRODUCT(C18:E18),1)","v":0},{"$f":"PRODUCT(C18,F18)","v":2000},{"$f":"SUM(G18:H18)","v":2000}]
[]
["Итого на работу:",null,null,null,null,null,{"$f":"SUMPRODUCT(C5:C20,E5:E20)","v":15600}]
["Итого на материал:",null,null,null,null,null,null,{"$f":"ROUNDDOWN(SUMPRODUCT(C3:C20,F3:F20),0)","v":2400}]