{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["входная информация","этот лист отправляем на печать","сравни"],"not_rendered":{"charts":0,"images":2,"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":100,"n_cols":8,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
["Верх право","Название","Ёмкость","Закуп. цена","% наценки","Точно","Розн. цена (на ценник)",{"$f":"COUNTIF($H$2:$H$100,1)","v":5}]
[131211,"Водка Куранты Перцовая","0,5л",77.000000000000028,{"$f":"IF(LEFT(B2,5)=\"Водка\",40%,20%)","v":0.4},{"$f":"D2*(1+E2)","v":107.80000000000004},{"$f":"ROUNDUP(F2,0)","v":108},1]
[131211,"Хлеб","400г",11,{"$f":"IF(LEFT(B3,5)=\"Водка\",40%,20%)","v":0.2},{"$f":"D3*(1+E3)","v":13.2},{"$f":"ROUNDUP(F3,0)","v":14},1]
[131211,"Водка Куранты Перцовая (особая)","1л",150,{"$f":"IF(LEFT(B4,5)=\"Водка\",40%,20%)","v":0.4},{"$f":"D4*(1+E4)","v":210},{"$f":"ROUNDUP(F4,0)","v":210}]
[131211,"Кетчуп","300г",30,0.2,36,36,1]
[131211,"Мука","2кг",60,0.2,72,72]
[131211,"Водка Кузнецкая особая (люкс)","0,5л",123,0.4,172.2,173]
[131211,"Горькая настойка \"Золотой Петушок\"","0,5л",205,0.2,246,246]
[131211,"Водка Куранты Перцовая","0,5л",77.000000000000028,{"$f":"IF(LEFT(B9,5)=\"Водка\",40%,20%)","v":0.4},{"$f":"D9*(1+E9)","v":107.80000000000004},{"$f":"ROUNDUP(F9,0)","v":108}]
[131211,"Хлеб","400г",11,{"$f":"IF(LEFT(B10,5)=\"Водка\",40%,20%)","v":0.2},{"$f":"D10*(1+E10)","v":13.2},{"$f":"ROUNDUP(F10,0)","v":14},1]
[131211,"Водка Куранты Перцовая (особая)","1л",111,{"$f":"IF(LEFT(B11,5)=\"Водка\",40%,20%)","v":0.4},{"$f":"D11*(1+E11)","v":155.39999999999998},{"$f":"ROUNDUP(F11,0)","v":156},1]
[131211,"Кетчуп","300г",30,0.2,36,36]
[131211,"Мука","2кг",60,0.2,72,72]
[131211,"Водка Кузнецкая особая (люкс)","0,5л",123,0.4,172.2,173]
[131211,"Горькая настойка \"Золотой Петушок\"","0,5л",205,0.2,246,246]
[131211,"Водка Куранты Перцовая","0,5л",77.000000000000028,0.4,107.80000000000004,108]
[131211,"Хлеб","400г",11,0.2,13.2,14]
[131211,"Водка Куранты Перцовая (особая)","1л",150,0.4,210,210]
[131211,"Кетчуп","300г",30,0.2,36,36]
[131211,"Мука","2кг",60,0.2,72,72]
[131211,"Водка Кузнецкая особая (люкс)","0,5л",123,{"$f":"IF(LEFT(B21,5)=\"Водка\",40%,20%)","v":0.4},{"$f":"D21*(1+E21)","v":172.2},173]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,{"$f":"ROUNDUP(F68,0)","v":0}]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,{"$f":"IF(LEFT(B85,5)=\"Водка\",40%,20%)","v":0.2},{"$f":"D85*(1+E85)","v":0},0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,0.2,0,0]
[null,null,null,null,{"$f":"IF(LEFT(B100,5)=\"Водка\",40%,20%)","v":0.2},{"$f":"D100*(1+E100)","v":0},{"$f":"ROUNDUP(F100,0)","v":0}]

{"sheet":"этот лист отправляем на печать","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"сравни","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}