{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Лист2","Лист3"],"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":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Наименование","Остаток","Цена","Оптим.","Поставщики","Остаток","Закупки"]
["175/65/14 BRIDGESTONE IC-7000 T шип",{"$f":"IF(LEN(F2)-LEN(SUBSTITUTE(F2,\"|\",\"\"))=1,MAX(LEFT(F2,FIND(\" \",F2)-1)),IF(LEN(F2)-LEN(SUBSTITUTE(F2,\"|\",\"\"))=2,MAX(LEFT(F2,FIND(\" \",F2)-1),TRIM(MID(F2,FIND(\"|\",F2,1)+1,3))),MAX(LEFT(F2,FIND(\" \",F2)-1),TRIM(MID(F2,FIND(\"|\",F2,1)+1,3)),TRIM(MID(F2,FIND(\"|\",F2,6)+1,3)))))","v":12},{"$f":"IF(LEN(E2)<=8,LEFT(G2,FIND(\" \",G2)-1)*1.122,IF(LEN(E2)<=15,MIN(LEFT(G2,FIND(\" \",G2)-1),TRIM(MID(G2,FIND(\" \",G2,7)+1,5)))*1.122,MIN(LEFT(G2,FIND(\" \",G2)-1),TRIM(MID(G2,FIND(\" \",G2,7)+1,5)),TRIM(MID(G2,FIND(\" \",G2,14)+1,5)))*1.122))","v":2423.5200000000004},null,"КиК | Дакар | ","3 | 12 | ","2167 | 2160 | ",{"$f":"МинПостащик(G2,E2)","v":"Дакар"}]
["185/65/15 Bridgestone Blizzak VRX S",{"$f":"IF(LEN(F3)-LEN(SUBSTITUTE(F3,\"|\",\"\"))=1,MAX(LEFT(F3,FIND(\" \",F3)-1)),IF(LEN(F3)-LEN(SUBSTITUTE(F3,\"|\",\"\"))=2,MAX(LEFT(F3,FIND(\" \",F3)-1),TRIM(MID(F3,FIND(\"|\",F3,1)+1,3))),MAX(LEFT(F3,FIND(\" \",F3)-1),TRIM(MID(F3,FIND(\"|\",F3,1)+1,3)),TRIM(MID(F3,FIND(\"|\",F3,6)+1,3)))))","v":39},{"$f":"IF(LEN(E3)<=8,LEFT(G3,FIND(\" \",G3)-1)*1.122,IF(LEN(E3)<=15,MIN(LEFT(G3,FIND(\" \",G3)-1),TRIM(MID(G3,FIND(\" \",G3,7)+1,5)))*1.122,MIN(LEFT(G3,FIND(\" \",G3)-1),TRIM(MID(G3,FIND(\" \",G3,7)+1,5)),TRIM(MID(G3,FIND(\" \",G3,14)+1,5)))*1.122))","v":3197.7000000000003},null,"Мега | ","39 | ","2850 | ",{"$f":"МинПостащик(G3,E3)","v":"Мега"}]
["185/65/15 BRIDGESTONE IC-7000 T шип",84,3107.9400000000005,null,"Мега | КиК | Дакар | ","84 | 8 | 1 | ","2770 | 2823 | 2815 | ","Мега"]
["185/65/15 BRIDGESTONE Spike-01 T шип",{"$f":"IF(LEN(F5)-LEN(SUBSTITUTE(F5,\"|\",\"\"))=1,MAX(LEFT(F5,FIND(\" \",F5)-1)),IF(LEN(F5)-LEN(SUBSTITUTE(F5,\"|\",\"\"))=2,MAX(LEFT(F5,FIND(\" \",F5)-1),TRIM(MID(F5,FIND(\"|\",F5,1)+1,3))),MAX(LEFT(F5,FIND(\" \",F5)-1),TRIM(MID(F5,FIND(\"|\",F5,1)+1,3)),TRIM(MID(F5,FIND(\"|\",F5,6)+1,3)))))","v":8},3271.7520000000004,null,"Дакар | ","8 | ","2916 | ","Дакар"]
["185/65/15 Bridgestone VRX S",2,3254.9220000000005,null,"КиК | ","2 | ","2901 | ","КиК"]
["165/70/14 Yokohama IG50 Q",40,2956.4700000000003,null,"Мега | КиК | ","40 | 4 | ","2635 | 2640 | ","Мега"]
["175/70/13 BRIDGESTONE IC-7000 T шип",36,2591.8200000000002,null,"Мега | Дакар | ","36 | 12 | ","2310 | 2324 | ","Мега"]
[null,null,null,null,"hgvhg",null,567,{"$f":"МинПостащик(G9,E9)","v":"hgvhg"}]
[null,null,null,null,null,null,null,""]

{"sheet":"Лист2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Лист3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}