{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["СМЕТА","Лист1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Наименование работ","Помещения","Кол-во","Ед.изм.","Цена за ед работы","Цена за ед мат-ла","Работа","Материал","Всего, руб."]
[]
["Этап №1"]
["Устройство дверного проема 1",null,3,"компл.",800,0,{"$f":"ROUND(PRODUCT(C6:E6),0)","v":2400},{"$f":"ROUND(PRODUCT(C6,F6),0)","v":0},{"$f":"SUM(G6:H6)","v":2400}]
["Устройство дверного проема 2",null,4,"компл.",800,0,{"$f":"ROUND(PRODUCT(C7:E7),0)","v":3200},{"$f":"ROUND(PRODUCT(C7,F7),0)","v":0},{"$f":"SUM(G7:H7)","v":3200}]
["Устройство дверного проема 3",null,5,"компл.",800,0,{"$f":"ROUND(PRODUCT(C8:E8),0)","v":4000},{"$f":"ROUND(PRODUCT(C8,F8),0)","v":0},{"$f":"SUM(G8:H8)","v":4000}]
["Устройство дверного проема 4",null,6,"компл.",800,0,{"$f":"ROUND(PRODUCT(C9:E9),0)","v":4800},{"$f":"ROUND(PRODUCT(C9,F9),0)","v":0},{"$f":"SUM(G9:H9)","v":4800}]
["Устройство дверного проема 5",null,7,"компл.",800,0,{"$f":"ROUND(PRODUCT(C10:E10),0)","v":5600},{"$f":"ROUND(PRODUCT(C10,F10),0)","v":0},{"$f":"SUM(G10:H10)","v":5600}]
["Устройство дверного проема 6",null,8,"компл.",800,0,{"$f":"ROUND(PRODUCT(C11:E11),0)","v":6400},{"$f":"ROUND(PRODUCT(C11,F11),0)","v":0},{"$f":"SUM(G11:H11)","v":6400}]
["Устройство дверного проема 7",null,9,"компл.",800,0,{"$f":"ROUND(PRODUCT(C12:E12),0)","v":7200},{"$f":"ROUND(PRODUCT(C12,F12),0)","v":0},{"$f":"SUM(G12:H12)","v":7200}]
["Устройство дверного проема 8",null,10,"компл.",800,0,{"$f":"ROUND(PRODUCT(C13:E13),0)","v":8000},{"$f":"ROUND(PRODUCT(C13,F13),0)","v":0},{"$f":"SUM(G13:H13)","v":8000}]
["Итого (этап №2):",null,null,null,null,null,{"$f":"ROUND(SUMPRODUCT(C6:C14,E6:E14),0)","v":41600},{"$f":"ROUND(SUMPRODUCT(C6:C14,F6:F14),0)","v":0}]
[]
["Этап №2"]
["Снятие обоев 1",null,1,"кв.м.",40,0,{"$f":"ROUND(PRODUCT(C17:E17),0)","v":40},{"$f":"ROUND(PRODUCT(C17,F17),0)","v":0},{"$f":"SUM(G17:H17)","v":40}]
["Снятие обоев 2",null,2,"кв.м.",40,0,{"$f":"ROUND(PRODUCT(C18:E18),0)","v":80},{"$f":"ROUND(PRODUCT(C18,F18),0)","v":0},{"$f":"SUM(G18:H18)","v":80}]
["Снятие обоев 3",null,3,"кв.м.",40,0,{"$f":"ROUND(PRODUCT(C19:E19),0)","v":120},{"$f":"ROUND(PRODUCT(C19,F19),0)","v":0},{"$f":"SUM(G19:H19)","v":120}]
["Снятие обоев 4",null,4,"кв.м.",40,0,{"$f":"ROUND(PRODUCT(C20:E20),0)","v":160},{"$f":"ROUND(PRODUCT(C20,F20),0)","v":0},{"$f":"SUM(G20:H20)","v":160}]
["Снятие обоев 5",null,5,"кв.м.",40,0,{"$f":"ROUND(PRODUCT(C21:E21),0)","v":200},{"$f":"ROUND(PRODUCT(C21,F21),0)","v":0},{"$f":"SUM(G21:H21)","v":200}]
["Снятие обоев 6",null,6,"кв.м.",40,0,{"$f":"ROUND(PRODUCT(C22:E22),0)","v":240},{"$f":"ROUND(PRODUCT(C22,F22),0)","v":0},{"$f":"SUM(G22:H22)","v":240}]
["Итого (этап №1):",null,null,null,null,null,{"$f":"ROUND(SUMPRODUCT(C17:C23,E17:E23),0)","v":840},{"$f":"ROUND(SUMPRODUCT(C17:C23,F17:F23),0)","v":0}]
[]
["Этап №3"]
["Поклейка обоев",null,50,"кв.м.",250,0,{"$f":"ROUND(PRODUCT(C26:E26),0)","v":12500},{"$f":"ROUND(PRODUCT(C26,F26),0)","v":0},{"$f":"SUM(G26:H26)","v":12500}]
["Итого (этап №3):",null,null,null,null,null,{"$f":"ROUND(SUMPRODUCT(C26:C27,E26:E27),0)","v":12500},{"$f":"ROUND(SUMPRODUCT(C26:C27,F26:F27),0)","v":0}]
[]
["Этап №4"]
[null,null,null,null,null,null,{"$f":"ROUND(PRODUCT(C30:E30),0)","v":0},{"$f":"ROUND(PRODUCT(C30,F30),0)","v":0},{"$f":"SUM(G30:H30)","v":0}]
["Итого (этап №4):",null,null,null,null,null,{"$f":"ROUND(SUMPRODUCT(C30:C31,E30:E31),0)","v":0},{"$f":"ROUND(SUMPRODUCT(C30:C31,F30:F31),0)","v":0}]
[]
["Итого на работу:",null,null,null,null,null,{"$f":"IFERROR(#REF!-INDEX($A$1:$I$507,MATCH(\"Скидка:\",$A$1:$A$507,0),7),#REF!)","v":{"$error":"#REF!"}}]
["Итого на материал:",null,null,null,null,null,null,{"$f":"ROUNDDOWN(SUMPRODUCT(C3:C24,F3:F24),0)+#REF!+#REF!","v":{"$error":"#REF!"}}]

{"sheet":"Лист1","index":1,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,"Итого на работу:"]