{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":52,"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":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["СУММА 1",{"$f":"SUM(B3:B102)","v":320.10000000000002},"СУММА 2",{"$f":"SUM(D3:D102)","v":320.5},"СУММА 3",320.60000000000002,null,"СУММА",{"$f":"SUM(I3:I100)","v":480.6},"СРЕДНЕЕ ЗНАЧЕНИЕ",{"$f":"I1/3*2","v":320.40000000000003},{"$f":"SUM(ABS(B1-K1),ABS(D1-K1),ABS(F1-K1))","v":0.59999999999996589},"min - целевая ячейка"]
["КОРОБКА 1","ЧИСЛО 1","КОРОБКА 2","ЧИСЛО 2","КОРОБКА 3","ЧИСЛО 3",null,"НАИМЕНОВАНИЕ","ЧИСЛО","порядок",null,10,"сек - ограничение времени вычисления"]
[{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(1,$J$3:$J$23,0)),\"\")","v":"элемент1"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(1,$J$3:$J$23,0)),\"\")","v":34},{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(1,$J$3:$J$23,0)),\"\")","v":"элемент1"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(1,$J$3:$J$23,0)),\"\")","v":34},{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(2,$J$3:$J$23,0)),\"\")","v":"элемент12"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(2,$J$3:$J$23,0)),\"\")","v":32.1},null,"элемент1",34,1]
[{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(2,$J$3:$J$23,0)),\"\")","v":"элемент12"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(2,$J$3:$J$23,0)),\"\")","v":32.1},{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(3,$J$3:$J$23,0)),\"\")","v":"элемент20"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(3,$J$3:$J$23,0)),\"\")","v":18},{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(3,$J$3:$J$23,0)),\"\")","v":"элемент20"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(3,$J$3:$J$23,0)),\"\")","v":18},null,"элемент12",32.1,2]
[{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(4,$J$3:$J$23,0)),\"\")","v":"элемент4"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(4,$J$3:$J$23,0)),\"\")","v":32},{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(4,$J$3:$J$23,0)),\"\")","v":"элемент4"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(4,$J$3:$J$23,0)),\"\")","v":32},{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(5,$J$3:$J$23,0)),\"\")","v":"элемент17"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(5,$J$3:$J$23,0)),\"\")","v":35},null,"элемент20",18,3]
[{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(5,$J$3:$J$23,0)),\"\")","v":"элемент17"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(5,$J$3:$J$23,0)),\"\")","v":35},{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(6,$J$3:$J$23,0)),\"\")","v":"элемент10"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(6,$J$3:$J$23,0)),\"\")","v":38},{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(6,$J$3:$J$23,0)),\"\")","v":"элемент10"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(6,$J$3:$J$23,0)),\"\")","v":38},null,"элемент4",32,4]
[{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(7,$J$3:$J$23,0)),\"\")","v":"элемент s19"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(7,$J$3:$J$23,0)),\"\")","v":7},{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(7,$J$3:$J$23,0)),\"\")","v":"элемент s19"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(7,$J$3:$J$23,0)),\"\")","v":7},{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(8,$J$3:$J$23,0)),\"\")","v":"элемент15"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(8,$J$3:$J$23,0)),\"\")","v":15},null,"элемент17",35,5]
[{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(8,$J$3:$J$23,0)),\"\")","v":"элемент15"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(8,$J$3:$J$23,0)),\"\")","v":15},{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(9,$J$3:$J$23,0)),\"\")","v":"элемент2"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(9,$J$3:$J$23,0)),\"\")","v":8},{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(9,$J$3:$J$23,0)),\"\")","v":"элемент2"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(9,$J$3:$J$23,0)),\"\")","v":8},null,"элемент10",38,6]
[{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(10,$J$3:$J$23,0)),\"\")","v":"элемент13"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(10,$J$3:$J$23,0)),\"\")","v":3},{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(10,$J$3:$J$23,0)),\"\")","v":"элемент13"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(10,$J$3:$J$23,0)),\"\")","v":3},{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(11,$J$3:$J$23,0)),\"\")","v":"элемент11d"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(11,$J$3:$J$23,0)),\"\")","v":24},null,"элемент s19",7,7]
[{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(11,$J$3:$J$23,0)),\"\")","v":"элемент11d"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(11,$J$3:$J$23,0)),\"\")","v":24},{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(12,$J$3:$J$23,0)),\"\")","v":"элемент21"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(12,$J$3:$J$23,0)),\"\")","v":12},{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(12,$J$3:$J$23,0)),\"\")","v":"элемент21"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(12,$J$3:$J$23,0)),\"\")","v":12},null,"элемент15",15,8]
[{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(13,$J$3:$J$23,0)),\"\")","v":"элемент14"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(13,$J$3:$J$23,0)),\"\")","v":13},{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(13,$J$3:$J$23,0)),\"\")","v":"элемент14"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(13,$J$3:$J$23,0)),\"\")","v":13},{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(14,$J$3:$J$23,0)),\"\")","v":"элемент5"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(14,$J$3:$J$23,0)),\"\")","v":15},null,"элемент2",8,9]
[{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(14,$J$3:$J$23,0)),\"\")","v":"элемент5"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(14,$J$3:$J$23,0)),\"\")","v":15},{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(15,$J$3:$J$23,0)),\"\")","v":"элемент18"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(15,$J$3:$J$23,0)),\"\")","v":34},{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(15,$J$3:$J$23,0)),\"\")","v":"элемент18"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(15,$J$3:$J$23,0)),\"\")","v":34},null,"элемент13",3,10]
[{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(16,$J$3:$J$23,0)),\"\")","v":"элемент9"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(16,$J$3:$J$23,0)),\"\")","v":40},{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(16,$J$3:$J$23,0)),\"\")","v":"элемент9"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(16,$J$3:$J$23,0)),\"\")","v":40},{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(17,$J$3:$J$23,0)),\"\")","v":"элемент6т"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(17,$J$3:$J$23,0)),\"\")","v":12},null,"элемент11d",24,11]
[{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(17,$J$3:$J$23,0)),\"\")","v":"элемент6т"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(17,$J$3:$J$23,0)),\"\")","v":12},{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(18,$J$3:$J$23,0)),\"\")","v":"элемент16"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(18,$J$3:$J$23,0)),\"\")","v":35},{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(18,$J$3:$J$23,0)),\"\")","v":"элемент16"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(18,$J$3:$J$23,0)),\"\")","v":35},null,"элемент21",12,12]
[{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(19,$J$3:$J$23,0)),\"\")","v":"элемент3"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(19,$J$3:$J$23,0)),\"\")","v":31},{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(19,$J$3:$J$23,0)),\"\")","v":"элемент3"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(19,$J$3:$J$23,0)),\"\")","v":31},{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(20,$J$3:$J$23,0)),\"\")","v":"элемент7"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(20,$J$3:$J$23,0)),\"\")","v":27},null,"элемент14",13,13]
[{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(20,$J$3:$J$23,0)),\"\")","v":"элемент7"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(20,$J$3:$J$23,0)),\"\")","v":27},{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(21,$J$3:$J$23,0)),\"\")","v":"элемент8"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(21,$J$3:$J$23,0)),\"\")","v":15.5},{"$f":"IFERROR(INDEX($H$3:$H$23,MATCH(21,$J$3:$J$23,0)),\"\")","v":"элемент8"},{"$f":"IFERROR(INDEX($I$3:$I$23,MATCH(21,$J$3:$J$23,0)),\"\")","v":15.5},null,"элемент5",15,14]
[null,null,null,null,null,null,null,"элемент18",34,15]
[null,null,null,null,null,null,null,"элемент9",40,16]
[null,null,null,null,null,null,null,"элемент6т",12,17]
[null,null,null,null,null,null,null,"элемент16",35,18]
[null,null,null,null,null,null,null,"элемент3",31,19]
[null,null,null,null,null,null,null,"элемент7",27,20]
[null,null,null,null,null,null,null,"элемент8",15.5,21]