{"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":33,"n_cols":19,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"ИТОГО",{"$f":"SUM(E4:E99)","v":15084.897000000001},{"$f":"SUM(F4:F99)","v":209338},{"$f":"SUM(G4:G99)","v":14813.9568},{"$f":"SUM(H4:H99)","v":8521},{"$f":"COUNTA(B4:B99)","v":30},null,null,null,null,"ИТОГО",{"$f":"SUM(O4:O99)","v":15084.896999999999},{"$f":"SUM(P4:P99)","v":209338},14813.9568,8521,{"$f":"COUNTA(L4:L99)","v":13}]
["№","Код ","Наименование ","Страна ","Вес","Кол-во","м2","пары","позиций",null,"№","Код ","Наименование ","Страна ","Вес","Кол-во","м2","пары","позиций"]
[1,9405409908,"Светильник ","Китай",974.4,1008,0,null,null,null,1,9405409908,"Светильник ","Китай",2801.3480000000004,9096,0,0]
[2,9405409908,"Лист ПВХ","Корея",974.4,1008,2000,null,null,null,2,9405409908,"Лист ПВХ","Корея",2235.0250000000001,2516,4800,0]
[3,9405409908,"Лист ПВХ","Корея",924,1008,1900,null,null,null,3,8544492000,"Пленка","Китай",7248,920,10013.9568,0]
[4,9405409908,"Светильник ","Китай",974.4,1008,null,null,null,null,4,9405409908,"Светильник ","Турция",40.799999999999997,1000]
[5,8544492000,"Пленка","Китай",3400,400,10000,null,null,null,5,8536619000,"Ролики","Китай",301.58,0,0,1121]
[6,8544492000,"Пленка","Китай",3848,520,13.956799999999999,null,null,null,6,8531809500,"Обувь спорт","Китай",288.83,0,0,7400]
[7,9405409908,"Светильник ","Китай",22,500,null,null,null,null,7,8531809501,"Звонок ","Китай",130.94,600,0,0]
[8,9405409908,"Светильник ","Китай",20,500,null,null,null,null,8,8531809501,"Звонок","Корея",22.2,120]
[9,9405409908,"Светильник ","Турция",40.799999999999997,1000,null,null,null,null,9,8531908500,"Кнопка","Китай",68.634,930]
[10,9405409908,"Светильник ","Китай",105.6,3000,null,null,null,null,10,9405204004,"Светильник","Китай",750,600]
[11,9405409908,"Светильник ","Китай",20,500,null,null,null,null,11,8538909909,"держатель ","Китай",8,2000]
[12,9405409908,"Светильник ","Китай",66,1500,null,null,null,null,12,8536508000,"Стартер ","Китай",996.16000000000008,190500,0,0]
[13,8536619000,"Ролики","Китай",288,null,null,1000,null,null,13,9405109808,"Светильник ","Китай",193.38,1056]
[14,8531809500,"Обувь спорт","Китай",145.38999999999999,null,null,4200]
[15,8531809501,"Звонок ","Китай",90.02,420]
[16,8531809500,"Обвуь спорт","Китай",143.44,null,null,3200]
[17,8531809501,"Звонок","Китай",40.92,180]
[18,8531809501,"Звонок","Корея",22.2,120]
[19,8531908500,"Кнопка","Китай",68.634,930]
[20,9405204004,"Светильник","Китай",750,600]
[21,9405409908,"Светильник ","Китай",343.86,600]
[22,9405409908,"Светильник ","Китай",275.08800000000002,480]
[23,9405409908,"Лист ПВХ","Корея",336.625,500,900]
[24,8538909909,"держатель ","Китай",8,2000]
[25,8536619000,"Ролики","Китай",1.05,null,null,10]
[26,8536619000,"Ролики","Китай",1.03,null,null,11]
[27,8536508000,"Стартер ","Китай",544.32000000000005,94500]
[28,8536508000,"Стартер ","Китай",451.84,96000]
[29,8536619000,"Ролики","Китай",11.5,null,null,100]
[30,9405109808,"Светильник ","Китай",193.38,1056]

{"sheet":"Лист2","index":1,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Sub ertert()",null,null,null,null,"Sub ertert()"]
["Dim x, y(), i&, j&, k&, s$, n&",null,null,null,null,"Dim x, y(), i&, j&, k&, s$, n&"]
["x = Range(\"A3\").CurrentRegion.Value",null,null,null,null,"x = Range(\"A2\").CurrentRegion.Value"]
["ReDim y(1 To UBound(x), 1 To UBound(x, 2))",null,null,null,null,"ReDim y(1 To UBound(x), 1 To UBound(x, 2))"]
[]
["On Error Resume Next",null,null,null,null,"On Error Resume Next"]
["With New Collection",null,null,null,null,"With New Collection"]
["    For i = 3 To UBound(x)",null,null,null,null,"    For i = 3 To UBound(x)"]
["        s = x(i, 2) & \"~\" & x(i, 4)",null,null,null,null,"        s = x(i, 2) & \"~\" & x(i, 4)"]
["        If IsEmpty(.Item(s)) Then",null,null,null,null,"        If IsEmpty(.Item(s)) Then"]
["            k = k + 1: y(k, 1) = k",null,null,null,null,"            k = k + 1: y(k, 1) = k"]
["            .Add k, s",null,null,null,null,"            .Add k, s"]
["            For j = 2 To UBound(x, 2) - 1",null,null,null,null,"            For j = 2 To UBound(x, 2)"]
["                y(k, j) = x(i, j)",null,null,null,null,"                y(k, j) = x(i, j)"]
["            Next j",null,null,null,null,"            Next j"]
["        Else",null,null,null,null,"        Else"]
["            n = .Item(s)",null,null,null,null,"            n = .Item(s)"]
["            For j = 5 To 8",null,null,null,null,"            y(n, 5) = y(n, 5) + x(i, 5)"]
["                y(n, j) = y(n, j) + x(i, j)",null,null,null,null,"        End If"]
["            Next",null,null,null,null,"    Next i"]
["        End If",null,null,null,null,"End With"]
["    Next i",null,null,null,null,"On Error GoTo 0"]
["End With",null,null,null,null,"Range(\"A15\").Resize(k, UBound(x, 2)).Value = y()"]
["On Error GoTo 0",null,null,null,null,"End Sub"]
["With Range(\"K4\").CurrentRegion.Offset(2)"]
["    .ClearContents"]
["    .Resize(k).Value = y()"]
["End With"]
["End Sub"]

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