{"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":164,"n_cols":10,"rows_kept":164,"cut":false,"hidden":false,"merged":[[161,1,161,6],[162,1,162,6],[163,1,163,6]]}
[]
[]
[]
["№","Артикул","Длинный артикул","Наименование запчасти клиента","Наименование продукции","Цена за шт., Евро без НДС","Кол-во","Всего, Евро без НДС","код","наличие фото"]
[]
["I",{"$f":"IF(SUBTOTAL(2,OFFSET($B$1,ROW($B6),0,IF(ISERROR(MATCH(1,$A8:$A$32760,0)),32760,MATCH(1,$A8:$A$32760,0)-2),1))>0,\".\",\"\")","v":"."},null,"Клиент 1"]
[1,38440106001,{"$f":"CONCATENATE(\"0000000\",B7)","v":"000000038440106001"},null,null,null,1]
[]
["II",{"$f":"IF(SUBTOTAL(2,OFFSET($B$1,ROW($B9),0,IF(ISERROR(MATCH(1,$A11:$A$32760,0)),32760,MATCH(1,$A11:$A$32760,0)-2),1))>0,\".\",\"\")","v":"."},null,"Клиент 2"]
[1,43720170501,{"$f":"CONCATENATE(\"0000000\",B10)","v":"000000043720170501"},null,null,null,1]
[2,43720170501,{"$f":"CONCATENATE(\"0000000\",B11)","v":"000000043720170501"},null,null,null,2]
[3,38452174900,"000000038452174900",null,null,null,2]
[4,86270613901,"000000086270613901",null,null,null,4]
[5,57442080000,"000000057442080000",null,null,null,4]
[6,86280685400,"000000086280685400",null,null,null,1]
[7,86280685505,"000000086280685505",null,null,null,1]
[8,86280685400,"000000086280685400",null,null,null,1]
[9,43720218501,"000000043720218501",null,null,null,1]
[10,43720218601,"000000043720218601",null,null,null,1]
[11,86280157200,"000000086280157200",null,null,null,1]
[12,86280113801,"000000086280113801",null,null,null,1]
[13,50776270000,"000000050776270000",null,null,null,1]
[14,38003390000,"000000038003390000",null,null,null,1]
[15,86277101000,"000000086277101000",null,null,null,1]
[16,50777290000,"000000050777290000",null,null,null,1]
[17,43720103407,"000000043720103407",null,null,null,1]
[18,38421203601,"000000038421203601",null,null,null,1]
[19,86280113801,"000000086280113801",null,null,null,1]
[]
["III",{"$f":"IF(SUBTOTAL(2,OFFSET($B$1,ROW($B30),0,IF(ISERROR(MATCH(1,$A32:$A$32760,0)),32760,MATCH(1,$A32:$A$32760,0)-2),1))>0,\".\",\"\")","v":"."},null,"Клиент 3"]
[1,86280660000,{"$f":"CONCATENATE(\"0000000\",B31)","v":"000000086280660000"},null,null,null,2]
[]
["IV",{"$f":"IF(SUBTOTAL(2,OFFSET($B$1,ROW($B33),0,IF(ISERROR(MATCH(1,$A35:$A$32760,0)),32760,MATCH(1,$A35:$A$32760,0)-2),1))>0,\".\",\"\")","v":"."},null,"Клиент 4"]
[1,86250501200,{"$f":"CONCATENATE(\"0000000\",B34)","v":"000000086250501200"},null,null,null,1]
[]
["V",{"$f":"IF(SUBTOTAL(2,OFFSET($B$1,ROW($B36),0,IF(ISERROR(MATCH(1,$A38:$A$32760,0)),32760,MATCH(1,$A38:$A$32760,0)-2),1))>0,\".\",\"\")","v":"."},null,"Клиент 5"]
[1,86280229700,{"$f":"CONCATENATE(\"0000000\",B37)","v":"000000086280229700"},null,null,null,1]
[2,"57753610000",{"$f":"CONCATENATE(\"0000000\",B38)","v":"000000057753610000"},null,null,null,2]
[3,"65250601300",{"$f":"CONCATENATE(\"0000000\",B39)","v":"000000065250601300"},null,null,null,1]
[4,86250202300,{"$f":"CONCATENATE(\"0000000\",B40)","v":"000000086250202300"},null,null,null,18]
[]
["VI",{"$f":"IF(SUBTOTAL(2,OFFSET($B$1,ROW($B42),0,IF(ISERROR(MATCH(1,$A44:$A$32760,0)),32760,MATCH(1,$A44:$A$32760,0)-2),1))>0,\".\",\"\")","v":"."},null,"Клиент 6"]
[1,38038694000,{"$f":"CONCATENATE(\"0000000\",B43)","v":"000000038038694000"},null,null,null,6]
[]
["VII",{"$f":"IF(SUBTOTAL(2,OFFSET($B$1,ROW($B45),0,IF(ISERROR(MATCH(1,$A47:$A$32760,0)),32760,MATCH(1,$A47:$A$32760,0)-2),1))>0,\".\",\"\")","v":"."},null,"Клиент 7"]
[1,86280162201,{"$f":"CONCATENATE(\"0000000\",B46)","v":"000000086280162201"},null,null,null,3]
[2,86280162101,{"$f":"CONCATENATE(\"0000000\",B47)","v":"000000086280162101"},null,null,null,3]
[3,86280903702,{"$f":"CONCATENATE(\"0000000\",B48)","v":"000000086280903702"},null,null,null,3]
[4,38437000101,"000000038437000101",null,null,null,1]
[5,38410140006,"000000038410140006",null,null,null,2]
[6,38410150005,"000000038410150005",null,null,null,2]
[7,38440104100,"000000038440104100",null,null,null,2]
[8,38410155100,"000000038410155100",null,null,null,2]
[9,86200901000,"000000086200901000",null,null,null,2]
[]
["VIII",{"$f":"IF(SUBTOTAL(2,OFFSET($B$1,ROW($B56),0,IF(ISERROR(MATCH(1,$A58:$A$32760,0)),32760,MATCH(1,$A58:$A$32760,0)-2),1))>0,\".\",\"\")","v":"."},null,"Клиент 8"]
[1,38435410150,{"$f":"CONCATENATE(\"0000000\",B57)","v":"000000038435410150"},null,null,null,2]
[2,86286500102,"000000086286500102",null,null,null,2]
[3,"65708500252","000000065708500252",null,null,null,2]
[4,86288555054,"000000086288555054",null,null,null,2]
[5,"60540271900","000000060540271900",null,null,null,10]
[6,86277101000,"000000086277101000",null,null,null,2]
[]
["IX",{"$f":"IF(SUBTOTAL(2,OFFSET($B$1,ROW($B64),0,IF(ISERROR(MATCH(1,$A66:$A$32760,0)),32760,MATCH(1,$A66:$A$32760,0)-2),1))>0,\".\",\"\")","v":"."},null,"Клиент 9"]
[1,86280673700,{"$f":"CONCATENATE(\"0000000\",B65)","v":"000000086280673700"},null,null,null,3]
[]
["X",{"$f":"IF(SUBTOTAL(2,OFFSET($B$1,ROW($B67),0,IF(ISERROR(MATCH(1,$A69:$A$32760,0)),32760,MATCH(1,$A69:$A$32760,0)-2),1))>0,\".\",\"\")","v":"."},null,"Клиент 10"]
[1,86280903702,{"$f":"CONCATENATE(\"0000000\",B68)","v":"000000086280903702"},null,null,null,8]
[2,86270685501,{"$f":"CONCATENATE(\"0000000\",B69)","v":"000000086270685501"},null,null,null,4]
[3,86270613901,{"$f":"CONCATENATE(\"0000000\",B70)","v":"000000086270613901"},null,null,null,8]
[]
["XI",{"$f":"IF(SUBTOTAL(2,OFFSET($B$1,ROW($B72),0,IF(ISERROR(MATCH(1,$A74:$A$32760,0)),32760,MATCH(1,$A74:$A$32760,0)-2),1))>0,\".\",\"\")","v":"."},null,"Клиент 11"]
[1,43720170701,{"$f":"CONCATENATE(\"0000000\",B73)","v":"000000043720170701"},null,null,null,1]
[2,86250501800,{"$f":"CONCATENATE(\"0000000\",B74)","v":"000000086250501800"},null,null,null,2]
[3,86250501900,{"$f":"CONCATENATE(\"0000000\",B75)","v":"000000086250501900"},null,null,null,2]
[]
["XII",{"$f":"IF(SUBTOTAL(2,OFFSET($B$1,ROW($B77),0,IF(ISERROR(MATCH(1,$A79:$A$32760,0)),32760,MATCH(1,$A79:$A$32760,0)-2),1))>0,\".\",\"\")","v":"."},null,"Клиент 12"]
[1,86280660000,{"$f":"CONCATENATE(\"0000000\",B78)","v":"000000086280660000"},null,null,null,2]
[]
["XIII",{"$f":"IF(SUBTOTAL(2,OFFSET($B$1,ROW($B80),0,IF(ISERROR(MATCH(1,$A82:$A$32760,0)),32760,MATCH(1,$A82:$A$32760,0)-2),1))>0,\".\",\"\")","v":"."},null,"Клиент 13"]
[1,43720218501,{"$f":"CONCATENATE(\"0000000\",B81)","v":"000000043720218501"},null,null,null,14]
[]
["XIV",{"$f":"IF(SUBTOTAL(2,OFFSET($B$1,ROW($B83),0,IF(ISERROR(MATCH(1,$A85:$A$32760,0)),32760,MATCH(1,$A85:$A$32760,0)-2),1))>0,\".\",\"\")","v":"."},null,"Клиент 14"]
[1,43786502503,{"$f":"CONCATENATE(\"0000000\",B84)","v":"000000043786502503"},null,null,null,3]
[2,86280660200,{"$f":"CONCATENATE(\"0000000\",B85)","v":"000000086280660200"},null,null,null,1]
[3,86280660800,{"$f":"CONCATENATE(\"0000000\",B86)","v":"000000086280660800"},null,null,null,2]
[4,86280515300,{"$f":"CONCATENATE(\"0000000\",B87)","v":"000000086280515300"},null,null,null,1]
[5,29774530000,{"$f":"CONCATENATE(\"0000000\",B88)","v":"000000029774530000"},null,null,null,1]
[6,43786300150,"000000043786300150",null,null,null,3]
[7,43783713100,"000000043783713100",null,null,null,2]
[8,63200300100,"000000063200300100",null,null,null,8]
[9,71901090000,"000000071901090000",null,null,null,8]
[10,43720170701,"000000043720170701",null,null,null,10]
[]
["XV",{"$f":"IF(SUBTOTAL(2,OFFSET($B$1,ROW($B95),0,IF(ISERROR(MATCH(1,$A97:$A$32760,0)),32760,MATCH(1,$A97:$A$32760,0)-2),1))>0,\".\",\"\")","v":"."},null,"Клиент 15"]
[1,43783503450,{"$f":"CONCATENATE(\"0000000\",B96)","v":"000000043783503450"},null,null,null,1]
[2,38018364000,{"$f":"CONCATENATE(\"0000000\",B97)","v":"000000038018364000"},null,null,null,1]
[3,65718600752,{"$f":"CONCATENATE(\"0000000\",B98)","v":"000000065718600752"},null,null,null,1]
[4,38603010000,"000000038603010000",null,null,null,1]
[5,43720116603,"000000043720116603",null,null,null,1]
[6,65010000712,"000000065010000712",null,null,null,1]
[7,50777540000,"000000050777540000",null,null,null,1]
[8,50009774000,"000000050009774000",null,null,null,1]
[9,86286122001,"000000086286122001",null,null,null,1]
[10,60560622000,"000000060560622000",null,null,null,2]
[11,60560624001,"000000060560624001",null,null,null,2]
[12,50304840000,"000000050304840000",null,null,null,1]
[13,50009775000,"000000050009775000",null,null,null,1]
[14,60563202602,"000000060563202602",null,null,null,1]
[15,86280157200,"000000086280157200",null,null,null,2]
[16,86270613901,"000000086270613901",null,null,null,6]
[17,38026633000,"000000038026633000",null,null,null,1]
[18,64573000155,"000000064573000155",null,null,null,1]
[19,64576000104,"000000064576000104",null,null,null,1]
[20,38018066000,"000000038018066000",null,null,null,1]
[21,60560207402,"000000060560207402",null,null,null,1]
[22,50275110000,"000000050275110000",null,null,null,1]
[23,50275260000,"000000050275260000",null,null,null,1]
[24,60562400900,"000000060562400900",null,null,null,2]
[25,38011026000,"000000038011026000",null,null,null,1]
[26,86280126701,"000000086280126701",null,null,null,3]
[27,86286110301,"000000086286110301",null,null,null,1]
[28,38456125200,"000000038456125200",null,null,null,1]
[]
["XVI",{"$f":"IF(SUBTOTAL(2,OFFSET($B$1,ROW($B125),0,IF(ISERROR(MATCH(1,$A127:$A$32760,0)),32760,MATCH(1,$A127:$A$32760,0)-2),1))>0,\".\",\"\")","v":"."},null,"Клиент 16"]
[1,86288540056,{"$f":"CONCATENATE(\"0000000\",B126)","v":"000000086288540056"},null,null,null,1]
[2,86280286202,{"$f":"CONCATENATE(\"0000000\",B127)","v":"000000086280286202"},null,null,null,3]
[3,86256120400,{"$f":"CONCATENATE(\"0000000\",B128)","v":"000000086256120400"},null,null,null,3]
[]
["XVII",{"$f":"IF(SUBTOTAL(2,OFFSET($B$1,ROW($B130),0,IF(ISERROR(MATCH(1,$A132:$A$32760,0)),32760,MATCH(1,$A132:$A$32760,0)-2),1))>0,\".\",\"\")","v":"."},null,"Клиент 17"]
[1,38422101201,{"$f":"CONCATENATE(\"0000000\",B131)","v":"000000038422101201"},null,null,null,6]
[2,86270612101,{"$f":"CONCATENATE(\"0000000\",B132)","v":"000000086270612101"},null,null,null,2]
[3,86270613901,"000000086270613901",null,null,null,1]
[4,86280550700,"000000086280550700",null,null,null,2]
[5,86280550500,"000000086280550500",null,null,null,2]
[6,86280685205,"000000086280685205",null,null,null,2]
[7,38006721000,"000000038006721000",null,null,null,2]
[8,38038566000,"000000038038566000",null,null,null,1]
[9,38038457000,"000000038038457000",null,null,null,1]
[10,38038502000,"000000038038502000",null,null,null,1]
[11,38038501000,"000000038038501000",null,null,null,1]
[12,38017424000,"000000038017424000",null,null,null,2]
[13,38017423000,"000000038017423000",null,null,null,2]
[14,38018245000,"000000038018245000",null,null,null,1]
[15,38018246000,"000000038018246000",null,null,null,1]
[]
["XVIII",{"$f":"IF(SUBTOTAL(2,OFFSET($B$1,ROW($B147),0,IF(ISERROR(MATCH(1,$A149:$A$32760,0)),32760,MATCH(1,$A149:$A$32760,0)-2),1))>0,\".\",\"\")","v":"."},null,"Клиент 18"]
[1,38420501900,{"$f":"CONCATENATE(\"0000000\",B148)","v":"000000038420501900"},null,null,null,1]
[]
["IXX",{"$f":"IF(SUBTOTAL(2,OFFSET($B$1,ROW($B150),0,IF(ISERROR(MATCH(1,$A152:$A$32760,0)),32760,MATCH(1,$A152:$A$32760,0)-2),1))>0,\".\",\"\")","v":"."},null,"Клиент 19"]
[1,43720103407,{"$f":"CONCATENATE(\"0000000\",B151)","v":"000000043720103407"},null,null,null,2]
[]
["XX",{"$f":"IF(SUBTOTAL(2,OFFSET($B$1,ROW($B153),0,IF(ISERROR(MATCH(1,$A155:$A$32760,0)),32760,MATCH(1,$A155:$A$32760,0)-2),1))>0,\".\",\"\")","v":"."},null,"Клиент 20"]
[1,63520720300,{"$f":"CONCATENATE(\"0000000\",B154)","v":"000000063520720300"},null,null,null,11]
[]
["XXI",{"$f":"IF(SUBTOTAL(2,OFFSET($B$1,ROW($B156),0,IF(ISERROR(MATCH(1,$A158:$A$32760,0)),32760,MATCH(1,$A158:$A$32760,0)-2),1))>0,\".\",\"\")","v":"."},null,"Клиент 21"]
[1,43720126100,{"$f":"CONCATENATE(\"0000000\",B157)","v":"000000043720126100"},null,null,null,4]
[2,38422101201,{"$f":"CONCATENATE(\"0000000\",B158)","v":"000000038422101201"},null,null,null,2]
[3,43720118900,{"$f":"CONCATENATE(\"0000000\",B159)","v":"000000043720118900"},null,null,null,4]
[4,43720170501,{"$f":"CONCATENATE(\"0000000\",B160)","v":"000000043720170501"},null,null,null,1]
[5,43720170501,{"$f":"CONCATENATE(\"0000000\",B161)","v":"000000043720170501"},null,null,null,1]
[null,"Итого, Евро ",null,null,null,null,null,{"$f":"SUM(H6:H161)","v":0}]
[null,"НДС 18%, Евро",null,null,null,null,null,{"$f":"H162*0.18","v":0}]
[null,"Итого с НДС, Евро",null,null,null,null,null,{"$f":"H162*1.18","v":0}]

{"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":[]}