{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":17,"n_cols":12,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,"% наценки","Сумма","Маржа"]
[null,null,null,null,null,"Товар",0.1,{"$f":"SUMPRODUCT(H7:H17,B7:B17)","v":22638},{"$f":"H3-E5","v":2058}]
[]
[null,"Закупка",null,null,{"$f":"SUM(E7:E17)","v":20580}]
["наименование","кол-во","ед.из","цен без ндс","сумма без НДС",null,"Наценка на товар (ручная коррекция)","Продажа","Итого продажа"]
["товар 1",9,"шт",310,{"$f":"D7*B7","v":2790},null,{"$f":"$G$3","v":0.1},{"$f":"D7+(D7*$G$7)","v":341},{"$f":"H7*B7","v":3069},null,null,"В ячейки G7:G17"]
["товар 2",8,"шт",360,2880,null,0.05,396,3168,null,null,"стоит формула \"=G3\""]
["товар 3",7,"шт",294,2058,null,{"$f":"$G$3","v":0.1},323.39999999999998,2263.7999999999997,null,null,"Нужно сделать автомформатирование ячеек G7:G17"]
["товар 4",6,"шт",1320,7920,null,0.2,1452,8712,null,null,"при внесении в них значения в ручную"]
["товар 5",5,"м2",{"$f":"137*4","v":548},2740,null,0.1,602.79999999999995,3014]
["товар 6",4,"м2",{"$f":"137*4","v":548},2192,null,0.15,602.79999999999995,2411.1999999999998]
[null,null,null,null,null,null,0.1,0,0]
[null,null,null,null,null,null,0.1,0,0]
[null,null,null,null,null,null,0.1,0,0]
[null,null,null,null,null,null,0.1,0,0]
[null,null,null,null,null,null,0.1,0,0]