{"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":0,"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":107,"n_cols":36,"rows_kept":107,"cut":false,"hidden":false,"merged":[[7,2,7,29]]}
[]
[null,"Есть ряд уникальных чисел ( ПОЛЕ ЧИСЕЛ ) 1-99. Расписаны по БЛОКАМ 10-1 ( левый крайний столбец )."]
[null,"Задача."]
[null,"В Т_2 присвоить каждому числу его номер блока. Можно расположить как столбцом ( как у меня ) , так и строкой ( как удобно для формулы )."]
[]
[]
[null,"Т_1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Т_2"]
[null,"№ БЛОКА","ПОЛЕ ЧИСЕЛ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Числа/Блоки","№ БЛОКА"]
[null,10,null,47,32,38,54,17,36,74,92,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF9=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":5},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF9=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":5}]
[null,9,null,91,12,52,30,39,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AF9+1","v":2},{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF10=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":5},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF10=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":5}]
[null,8,null,94,27,89,5,96,50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AF10+1","v":3},{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF11=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":2},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF11=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":2}]
[null,7,null,68,7,13,66,61,72,6,14,8,58,37,84,53,78,43,93,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF12=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":5},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF12=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":5}]
[null,6,null,85,95,10,83,25,42,60,87,22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF13=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":8},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF13=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":8}]
[null,5,null,77,65,41,28,57,24,18,4,2,90,86,49,67,1,33,46,26,81,64,82,15,71,20,59,null,null,null,null,6,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF14=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":7},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF14=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":7}]
[null,4,null,40,97,31,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF15=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":7},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF15=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":7}]
[null,3,null,75,98,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF16=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":7},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF16=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":7}]
[null,2,null,21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF17=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":2},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF17=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":2}]
[null,2,null,55,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF18=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":6},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF18=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":6}]
[null,2,null,62,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF19=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":2},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF19=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":2}]
[null,2,null,51,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF20=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":9},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF20=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":9}]
[null,2,null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF21=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":7},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF21=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":7}]
[null,2,null,88,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF22=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":7},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF22=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":7}]
[null,2,null,73,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF23=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":5},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF23=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":5}]
[null,2,null,44,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF24=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":2},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF24=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":2}]
[null,2,null,11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF25=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":10},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF25=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":10}]
[null,2,null,79,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF26=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":5},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF26=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":5}]
[null,2,null,35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF27=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":2},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF27=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":2}]
[null,2,null,80,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF28=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":5},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF28=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":5}]
[null,2,null,69,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF29=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":2},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF29=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":2}]
[null,2,null,48,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF30=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":6},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF30=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":6}]
[null,2,null,16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF31=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":2},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF31=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":2}]
[null,2,null,45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF32=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":5},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF32=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":5}]
[null,2,null,76,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF33=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":6},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF33=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":6}]
[null,2,null,19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF34=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":5},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF34=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":5}]
[null,2,null,63,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF35=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":8},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF35=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":8}]
[null,2,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF36=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":5},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF36=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":5}]
[null,2,null,34,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF37=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":1},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF37=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":1}]
[null,2,null,23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF38=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":9},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF38=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":9}]
[null,2,null,99,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF39=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":4},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF39=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":4}]
[null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF40=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":10},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF40=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":10}]
[null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF41=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":5},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF41=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":5}]
[null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF42=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":2},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF42=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":2}]
[null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF43=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":2},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF43=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":2}]
[null,1,null,29,56,70,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF44=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":10},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF44=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":10}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF45=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":7},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF45=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF46=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":10},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF46=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":10}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF47=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":9},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF47=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF48=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":4},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF48=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF49=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":5},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF49=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF50=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":6},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF50=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF51=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":7},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF51=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF52=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":2},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF52=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF53=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":2},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF53=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF54=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":5},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF54=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF55=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":10},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF55=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":10}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF56=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":2},null,null,{"$f":"INDEX($B$9:$B$44,SUMPRODUCT((AF56=$D$9:$AD$44)*(ROW($B$9:$B$44)-ROW($D$9)+1)))","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF57=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF58=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF59=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF60=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF61=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF62=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":10}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF63=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF64=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,57,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF65=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF66=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF67=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF68=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF69=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF70=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF71=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,64,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF72=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF73=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,66,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF74=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AF74+1","v":67},{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF75=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,68,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF76=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF77=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF78=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,71,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF79=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF80=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,73,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF81=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF82=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":10}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF83=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,76,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF84=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,77,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF85=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,78,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF86=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,79,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF87=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF88=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,81,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF89=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF90=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,83,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF91=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,84,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF92=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,85,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF93=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,86,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF94=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,87,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF95=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,88,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF96=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,89,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF97=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF98=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,91,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF99=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,92,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF100=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":10}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,93,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF101=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,94,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF102=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,95,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF103=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,96,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF104=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,97,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF105=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,98,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF106=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,99,{"$f":"INDEX($B$9:$B$44,MATCH(1,MMULT(--(AF107=$D$9:$AD$44),TRANSPOSE(COLUMN($D$9:$AD$44))^0),0))","v":2}]

{"sheet":"Лист2","index":1,"n_rows":100,"n_cols":16,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
[]
[null,"В Т_1 уникальным числам желтого поля ( в порядке возрастания 1-99 ) сопоставляются числовые значения зеленого поля."]
[null,"Желтое поле Т_2 содержит все уникальные номера желтого поля Т_1."]
[null,"Т_2 -шахматка 0-99 ( построение: пересечение строки 3 и столбца 6 дает номер ячейки \"36\". Аналогично , Строка 0 и столбец 4 , ячейка 40 … )."]
[]
[null,"Задача."]
[null,"Построить Т_3 , в которой разместить значения зеленого поля Т_1 в соответствии с номерами ячеек Т_2"]
[null,"( не-до заполненное поле Т_3 , заполняется аналогично заполненному по схеме задания ) "]
[null,"Т_1",null,null,null,"Т_2"]
[null,"Числа/Блоки","№ БЛОКА",null,null,null,0,1,{"$f":"H10+1","v":2},{"$f":"I10+1","v":3},4,5,6,7,8,9]
[null,1,5.5432098765432096,null,null,0,0,10,20,30,40,50,60,70,80,90]
[null,2,5.0123456790123457,null,null,1,{"$f":"G$11+$F12","v":1},11,21,31,41,51,61,71,81,91]
[null,3,5.0864197530864201,null,null,{"$f":"F12+1","v":2},2,12,22,32,42,52,62,72,82,92]
[null,4,5.382716049382716,null,null,{"$f":"F13+1","v":3},3,13,23,33,43,53,63,73,83,93]
[null,5,5.3703703703703702,null,null,4,4,14,24,34,44,54,64,74,84,94]
[null,6,5.1851851851851851,null,null,5,5,15,25,35,45,55,65,75,85,95]
[null,7,5.382716049382716,null,null,6,6,16,26,36,46,56,66,76,86,96]
[null,8,5.2962962962962967,null,null,7,7,17,27,37,47,57,67,77,87,97]
[null,9,5.2469135802469138,null,null,8,8,18,28,38,48,58,68,78,88,98]
[null,10,5.2098765432098766,null,null,9,9,19,29,39,49,59,69,79,89,99]
[null,11,5.7283950617283947]
[null,12,5.5802469135802468,null,null,"Т_3"]
[null,13,5.0123456790123457,null,null,null,0,1,{"$f":"H23+1","v":2},{"$f":"I23+1","v":3},4,5,6,7,8,9]
[null,14,5.4938271604938276,null,null,0,0,{"$f":"IFERROR(VLOOKUP(H$23*10+$F24,$B$11:$C$100,2,0),0)","v":5.2098765432098766},5.5555555555555554,5.5802469135802468,4.4074074074074074,5.6543209876543212,5.3086419753086416,5.617283950617284,4.9012345679012341,5.4814814814814818]
[null,15,5.3703703703703702,null,null,1,{"$f":"IFERROR(VLOOKUP(G$23*10+$F25,$B$11:$C$100,2,0),0)","v":5.5432098765432096},5.7283950617283947,4.4320987654320989,5.4567901234567904,5.0987654320987659,4.9629629629629628,5.1111111111111107,4.9259259259259256,5.0493827160493829,0]
[null,16,5.0123456790123457,null,null,{"$f":"F25+1","v":2},5.0123456790123457,5.5802469135802468,5.5802469135802468,5.1851851851851851,5.0864197530864201,5.4320987654320989,5.1604938271604937,5.4567901234567904,5.5308641975308639,0]
[null,17,5.1111111111111107,null,null,{"$f":"F26+1","v":3},5.0864197530864201,5.0123456790123457,5.0987654320987659,5.3950617283950617,5.5432098765432096,4.9259259259259256,4.7283950617283947,5.0370370370370372,4.9135802469135799,0]
[null,18,5.3209876543209873,null,null,4,5.382716049382716,5.4938271604938276,5.1851851851851851,5.1234567901234565,5.382716049382716,5.5555555555555554,5.2222222222222223,4.8395061728395063,5.5061728395061724,0]
[null,19,5.1604938271604937,null,null,5,5.3703703703703702,5.3703703703703702,5.4074074074074074,5.2222222222222223,5,5.4320987654320989,5.0246913580246915,5.3086419753086416,4.8518518518518521,0]
[null,20,5.5555555555555554,null,null,6,5.1851851851851851,5.0123456790123457,4.7407407407407405,5.3086419753086416,5.382716049382716,4.9259259259259256,5.4691358024691361,5.0864197530864201,5.0987654320987659,0]
[null,21,4.4320987654320989,null,null,7,5.382716049382716,5.1111111111111107,4.8271604938271606,5.617283950617284,5.4444444444444446,5.5432098765432096,5.6049382716049383,5.1851851851851851,5.2716049382716053,0]
[null,22,5.5802469135802468,null,null,8,5.2962962962962967,5.3209876543209873,5.382716049382716,5.7530864197530862,5.0246913580246915,5.2592592592592595,5.5432098765432096,5.1358024691358022,5.2469135802469138,0]
[null,23,5.0987654320987659,null,null,9,5.2469135802469138,5.1604938271604937,4.5679012345679011,5.283950617283951,5.3703703703703702,5.382716049382716,5.1234567901234565,5.1111111111111107,5.3209876543209873,0]
[null,24,5.1851851851851851]
[null,25,5.4074074074074074]
[null,26,4.7407407407407405]
[null,27,4.8271604938271606]
[null,28,5.382716049382716]
[null,29,4.5679012345679011]
[null,30,5.5802469135802468]
[null,31,5.4567901234567904]
[null,32,5.1851851851851851]
[null,33,5.3950617283950617]
[null,34,5.1234567901234565]
[null,35,5.2222222222222223]
[null,36,5.3086419753086416]
[null,37,5.617283950617284]
[null,38,5.7530864197530862]
[null,39,5.283950617283951]
[null,40,4.4074074074074074]
[null,41,5.0987654320987659]
[null,42,5.0864197530864201]
[null,43,5.5432098765432096]
[null,44,5.382716049382716]
[null,45,5]
[null,46,5.382716049382716]
[null,47,5.4444444444444446]
[null,48,5.0246913580246915]
[null,49,5.3703703703703702]
[null,50,5.6543209876543212]
[null,51,4.9629629629629628]
[null,52,5.4320987654320989]
[null,53,4.9259259259259256]
[null,54,5.5555555555555554]
[null,55,5.4320987654320989]
[null,56,4.9259259259259256]
[null,57,5.5432098765432096]
[null,58,5.2592592592592595]
[null,59,5.382716049382716]
[null,60,5.3086419753086416]
[null,61,5.1111111111111107]
[null,62,5.1604938271604937]
[null,63,4.7283950617283947]
[null,64,5.2222222222222223]
[null,65,5.0246913580246915]
[null,66,5.4691358024691361]
[null,67,5.6049382716049383]
[null,68,5.5432098765432096]
[null,69,5.1234567901234565]
[null,70,5.617283950617284]
[null,71,4.9259259259259256]
[null,72,5.4567901234567904]
[null,73,5.0370370370370372]
[null,74,4.8395061728395063]
[null,75,5.3086419753086416]
[null,76,5.0864197530864201]
[null,77,5.1851851851851851]
[null,78,5.1358024691358022]
[null,79,5.1111111111111107]
[null,80,4.9012345679012341]
[null,81,5.0493827160493829]
[null,82,5.5308641975308639]
[null,83,4.9135802469135799]
[null,84,5.5061728395061724]
[null,85,4.8518518518518521]
[null,86,5.0987654320987659]
[null,87,5.2716049382716053]
[null,88,5.2469135802469138]
[null,89,5.3209876543209873]
[null,90,5.4814814814814818]

{"sheet":"Лист3","index":2,"n_rows":30,"n_cols":15,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Разметки полей не изменять!!"]
[null,null,null,null,"Т_1"]
[null,null,null,null,null,0,1,2,3,4,5,6,7,8,9]
[null,null,null,null,0,5.32,5.2098765432098766,5.5555555555555554,5.5802469135802468,4.4074074074074074,5.6543209876543212,5.3086419753086416,5.617283950617284,4.9012345679012341,5.4814814814814818]
[null,null,null,null,1,5.5432098765432096,5.7283950617283947,4.4320987654320989,5.4567901234567904,5.0987654320987659,4.9629629629629628,5.1111111111111107,4.9259259259259256,5.0493827160493829,5.13]
[null,null,null,null,2,5.0123456790123457,5.5802469135802468,5.5802469135802468,5.1851851851851851,5.0864197530864201,5.4320987654320989,5.1604938271604937,5.4567901234567904,5.5308641975308639,5.55]
[null,null,null,null,3,5.0864197530864201,5.0123456790123457,5.0987654320987659,5.3950617283950617,5.5432098765432096,4.9259259259259256,4.7283950617283947,5.0370370370370372,4.9135802469135799,4.7699999999999996]
[null,null,null,null,4,5.382716049382716,5.4938271604938276,5.1851851851851851,5.1234567901234565,5.382716049382716,5.5555555555555554,5.2222222222222223,4.8395061728395063,5.5061728395061724,5.88]
[null,null,null,null,5,5.3703703703703702,5.3703703703703702,5.4074074074074074,5.2222222222222223,5,5.4320987654320989,5.0246913580246915,5.3086419753086416,4.8518518518518521,5]
[null,null,null,null,6,5.1851851851851851,5.0123456790123457,4.7407407407407405,5.3086419753086416,5.382716049382716,4.9259259259259256,5.4691358024691361,5.0864197530864201,5.0987654320987659,5.12]
[null,null,null,null,7,5.382716049382716,5.1111111111111107,4.8271604938271606,5.617283950617284,5.4444444444444446,5.5432098765432096,5.6049382716049383,5.1851851851851851,5.2716049382716053,4.66]
[null,null,null,null,8,5.2962962962962967,5.3209876543209873,5.382716049382716,5.7530864197530862,5.0246913580246915,5.2592592592592595,5.5432098765432096,5.1358024691358022,5.2469135802469138,4.25]
[null,null,null,null,9,5.2469135802469138,5.1604938271604937,4.5679012345679011,5.283950617283951,5.3703703703703702,5.382716049382716,5.1234567901234565,5.1111111111111107,5.3209876543209873,5.44]
[null,null,null,null,"Т_2"]
[null,null,null,null,null,0,1,{"$f":"G15+1","v":2},{"$f":"H15+1","v":3},{"$f":"I15+1","v":4},{"$f":"J15+1","v":5},{"$f":"K15+1","v":6},{"$f":"L15+1","v":7},{"$f":"M15+1","v":8},{"$f":"N15+1","v":9}]
[null,null,null,null,0,{"$f":"F$15*10+$E16","v":0},10,20,30,40,50,60,70,80,90]
[null,null,null,null,1,1,11,21,31,41,51,61,71,81,91]
[null,null,null,null,{"$f":"E17+1","v":2},2,12,22,32,42,52,62,72,82,92]
[null,null,null,null,{"$f":"E18+1","v":3},3,13,23,33,43,53,63,73,83,93]
[null,null,null,null,4,4,14,24,34,44,54,64,74,84,94]
[null,null,null,null,5,5,15,25,35,45,55,65,75,85,95]
[null,null,null,null,6,6,16,26,36,46,56,66,76,86,96]
[null,null,null,null,7,7,17,27,37,47,57,67,77,87,97]
[null,null,null,null,8,8,18,28,38,48,58,68,78,88,98]
[null,null,null,null,9,9,19,29,39,49,59,69,79,89,99]
[]
[null,null,null,null,"Т_2 - шахматка 10х10"]
[null,null,null,null,"Значения в ней раскрашены условным форматированием: цветовая шкала №3 из стандартного набора -от красного к зеленому ( от меньшего к большему )."]
[null,null,null,null,"Возможно ли экстропалировать эту шкалу на Т_2 , которая имеет хначения 0-99."]
[null,null,null,null,"Значения в Т_2 сохраняются , но переносится лишь цветовой рисунок с Т_1"]