{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":20,"n_cols":18,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["БАЗА ДАННЫХ",null,null,null,null,null,"фио","иванов",null,null,null,null,null,null,null,null,{"$f":"INDEX(B$1:B$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(A1)))","v":"красный"},{"$f":"INDEX(C$1:C$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(B1)))","v":"черный "}]
["фио","№1","№2",null,null,null,"№1","красный",null,null,null,null,null,null,null,{"$f":"LOOKUP(2,1/ISERROR(MATCH(A$3:A$99,P$1:P1,)),A$3:A$99)","v":0},{"$f":"INDEX(B$1:B$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(A2)))","v":"зеленый"},{"$f":"INDEX(C$1:C$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(B2)))","v":"оранжевый"}]
["иванов","красный","черный ",null,null,null,"№2","черный ",null,null,null,null,null,null,null,{"$f":"LOOKUP(2,1/ISERROR(MATCH(A$3:A$99,P$1:P2,)),A$3:A$99)","v":"иванов"},{"$f":"INDEX(B$1:B$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(A3)))","v":{"$error":"#NUM!"}},{"$f":"INDEX(C$1:C$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(B3)))","v":{"$error":"#NUM!"}}]
["петров","синий","белый",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(2,1/ISERROR(MATCH(A$3:A$99,P$1:P3,)),A$3:A$99)","v":"сидоров"},{"$f":"INDEX(B$1:B$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(A4)))","v":{"$error":"#NUM!"}},{"$f":"INDEX(C$1:C$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(B4)))","v":{"$error":"#NUM!"}}]
["сидоров","желтый","фиолетовый",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(2,1/ISERROR(MATCH(A$3:A$99,P$1:P4,)),A$3:A$99)","v":"петров"},{"$f":"INDEX(B$1:B$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(A5)))","v":{"$error":"#NUM!"}},{"$f":"INDEX(C$1:C$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(B5)))","v":{"$error":"#NUM!"}}]
["иванов","зеленый","оранжевый",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(2,1/ISERROR(MATCH(A$3:A$99,P$1:P5,)),A$3:A$99)","v":{"$error":"#N/A"}},{"$f":"INDEX(B$1:B$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(A6)))","v":{"$error":"#NUM!"}},{"$f":"INDEX(C$1:C$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(B6)))","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(2,1/ISERROR(MATCH(A$3:A$99,P$1:P6,)),A$3:A$99)","v":{"$error":"#N/A"}},{"$f":"INDEX(B$1:B$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(A7)))","v":{"$error":"#NUM!"}},{"$f":"INDEX(C$1:C$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(B7)))","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(2,1/ISERROR(MATCH(A$3:A$99,P$1:P7,)),A$3:A$99)","v":{"$error":"#N/A"}},{"$f":"INDEX(B$1:B$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(A8)))","v":{"$error":"#NUM!"}},{"$f":"INDEX(C$1:C$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(B8)))","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(2,1/ISERROR(MATCH(A$3:A$99,P$1:P8,)),A$3:A$99)","v":{"$error":"#N/A"}},{"$f":"INDEX(B$1:B$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(A9)))","v":{"$error":"#NUM!"}},{"$f":"INDEX(C$1:C$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(B9)))","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(2,1/ISERROR(MATCH(A$3:A$99,P$1:P9,)),A$3:A$99)","v":{"$error":"#N/A"}},{"$f":"INDEX(B$1:B$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(A10)))","v":{"$error":"#NUM!"}},{"$f":"INDEX(C$1:C$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(B10)))","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(2,1/ISERROR(MATCH(A$3:A$99,P$1:P10,)),A$3:A$99)","v":{"$error":"#N/A"}},{"$f":"INDEX(B$1:B$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(A11)))","v":{"$error":"#NUM!"}},{"$f":"INDEX(C$1:C$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(B11)))","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(2,1/ISERROR(MATCH(A$3:A$99,P$1:P11,)),A$3:A$99)","v":{"$error":"#N/A"}},{"$f":"INDEX(B$1:B$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(A12)))","v":{"$error":"#NUM!"}},{"$f":"INDEX(C$1:C$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(B12)))","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(2,1/ISERROR(MATCH(A$3:A$99,P$1:P12,)),A$3:A$99)","v":{"$error":"#N/A"}},{"$f":"INDEX(B$1:B$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(A13)))","v":{"$error":"#NUM!"}},{"$f":"INDEX(C$1:C$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(B13)))","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(2,1/ISERROR(MATCH(A$3:A$99,P$1:P13,)),A$3:A$99)","v":{"$error":"#N/A"}},{"$f":"INDEX(B$1:B$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(A14)))","v":{"$error":"#NUM!"}},{"$f":"INDEX(C$1:C$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(B14)))","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(2,1/ISERROR(MATCH(A$3:A$99,P$1:P14,)),A$3:A$99)","v":{"$error":"#N/A"}},{"$f":"INDEX(B$1:B$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(A15)))","v":{"$error":"#NUM!"}},{"$f":"INDEX(C$1:C$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(B15)))","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(2,1/ISERROR(MATCH(A$3:A$99,P$1:P15,)),A$3:A$99)","v":{"$error":"#N/A"}},{"$f":"INDEX(B$1:B$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(A16)))","v":{"$error":"#NUM!"}},{"$f":"INDEX(C$1:C$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(B16)))","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(2,1/ISERROR(MATCH(A$3:A$99,P$1:P16,)),A$3:A$99)","v":{"$error":"#N/A"}},{"$f":"INDEX(B$1:B$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(A17)))","v":{"$error":"#NUM!"}},{"$f":"INDEX(C$1:C$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(B17)))","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(2,1/ISERROR(MATCH(A$3:A$99,P$1:P17,)),A$3:A$99)","v":{"$error":"#N/A"}},{"$f":"INDEX(B$1:B$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(A18)))","v":{"$error":"#NUM!"}},{"$f":"INDEX(C$1:C$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(B18)))","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(2,1/ISERROR(MATCH(A$3:A$99,P$1:P18,)),A$3:A$99)","v":{"$error":"#N/A"}},{"$f":"INDEX(B$1:B$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(A19)))","v":{"$error":"#NUM!"}},{"$f":"INDEX(C$1:C$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(B19)))","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(2,1/ISERROR(MATCH(A$3:A$99,P$1:P19,)),A$3:A$99)","v":{"$error":"#N/A"}},{"$f":"INDEX(B$1:B$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(A20)))","v":{"$error":"#NUM!"}},{"$f":"INDEX(C$1:C$99,SMALL(IF($A$3:$A$99=$H$1,ROW($A$3:$A$99)),ROW(B20)))","v":{"$error":"#NUM!"}}]