{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист2"],"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":"Лист2","index":0,"n_rows":34,"n_cols":47,"rows_kept":34,"cut":false,"hidden":false,"merged":[[18,1,18,2],[17,1,17,20],[0,23,0,32],[0,35,0,44],[0,1,0,20],[1,1,1,2],[17,23,17,32],[17,35,17,44]]}
[null,"Таблица_Слияния",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Таблица_1",null,null,null,null,null,null,null,null,null,null,null,"Таблица_2",null,null,null,null,null,null,null,null,null,null,"ВАРИАНТ_2 ( с усложнением )"]
[null,1,null,{"$f":"B2+1","v":2},null,{"$f":"D2+1","v":3},null,{"$f":"F2+1","v":4},null,{"$f":"H2+1","v":5},null,{"$f":"J2+1","v":6},null,{"$f":"L2+1","v":7},null,{"$f":"N2+1","v":8},null,{"$f":"P2+1","v":9},null,{"$f":"R2+1","v":10},null,null,null,1,{"$f":"X2+1","v":2},{"$f":"Y2+1","v":3},{"$f":"Z2+1","v":4},{"$f":"AA2+1","v":5},{"$f":"AB2+1","v":6},{"$f":"AC2+1","v":7},{"$f":"AD2+1","v":8},{"$f":"AE2+1","v":9},{"$f":"AF2+1","v":10},null,null,1,{"$f":"AJ2+1","v":2},{"$f":"AK2+1","v":3},{"$f":"AL2+1","v":4},{"$f":"AM2+1","v":5},{"$f":"AN2+1","v":6},{"$f":"AO2+1","v":7},{"$f":"AP2+1","v":8},{"$f":"AQ2+1","v":9},{"$f":"AR2+1","v":10},null,"Усложнение: В Таб_1_2 ячейки условно форматированы цветом."]
[1,0,0,1,{"$f":"C$3","v":0},2,{"$f":"E$3","v":0},3,{"$f":"G$3","v":0},4,{"$f":"I$3","v":0},5,{"$f":"K$3","v":0},6,{"$f":"M$3","v":0},7,{"$f":"O$3","v":0},8,{"$f":"Q$3","v":0},9,{"$f":"S$3","v":0},null,1,0,{"$f":"X3+10","v":10},{"$f":"Y3+10","v":20},{"$f":"Z3+10","v":30},{"$f":"AA3+10","v":40},{"$f":"AB3+10","v":50},{"$f":"AC3+10","v":60},{"$f":"AD3+10","v":70},{"$f":"AE3+10","v":80},{"$f":"AF3+10","v":90},null,1,0,{"$f":"AJ3+10","v":10},{"$f":"AK3+10","v":20},{"$f":"AL3+10","v":30},{"$f":"AM3+10","v":40},{"$f":"AN3+10","v":50},{"$f":"AO3+10","v":60},{"$f":"AP3+10","v":70},{"$f":"AQ3+10","v":80},{"$f":"AR3+10","v":90},null,"Желтый - подсвечиются ячейки с номерами в диапазоне 10-30"]
[{"$f":"A3+1","v":2},0,{"$f":"C3+1","v":1},{"$f":"D3","v":1},{"$f":"$C4","v":1},{"$f":"F$3","v":2},{"$f":"E4","v":1},{"$f":"H$3","v":3},{"$f":"G4","v":1},{"$f":"J$3","v":4},{"$f":"I4","v":1},{"$f":"L$3","v":5},{"$f":"K4","v":1},{"$f":"N$3","v":6},{"$f":"M4","v":1},{"$f":"P$3","v":7},{"$f":"O4","v":1},{"$f":"R$3","v":8},{"$f":"Q4","v":1},{"$f":"T$3","v":9},{"$f":"S4","v":1},null,{"$f":"W3+1","v":2},{"$f":"X3+1","v":1},{"$f":"Y3+1","v":11},{"$f":"Z3+1","v":21},{"$f":"AA3+1","v":31},{"$f":"AB3+1","v":41},{"$f":"AC3+1","v":51},{"$f":"AD3+1","v":61},{"$f":"AE3+1","v":71},{"$f":"AF3+1","v":81},{"$f":"AG3+1","v":91},null,{"$f":"AI3+1","v":2},{"$f":"AJ3+1","v":1},{"$f":"AK3+1","v":11},{"$f":"AL3+1","v":21},{"$f":"AM3+1","v":31},{"$f":"AN3+1","v":41},{"$f":"AO3+1","v":51},{"$f":"AP3+1","v":61},{"$f":"AQ3+1","v":71},{"$f":"AR3+1","v":81},{"$f":"AS3+1","v":91},null,"Зеленым - диапазон 60-80Синий - диапазон 25-65 ( Таб_2 )"]
[{"$f":"A4+1","v":3},0,2,{"$f":"D4","v":1},{"$f":"$C5","v":2},{"$f":"F$3","v":2},{"$f":"E5","v":2},3,2,4,2,5,2,6,2,7,2,8,2,9,2,null,{"$f":"W4+1","v":3},2,12,22,32,42,52,62,72,82,92,null,{"$f":"AI4+1","v":3},2,12,22,32,42,52,62,72,82,92,null,"Задача та же: В Таб_слияния надо слить цвета из Баб_1_2."]
[4,0,3,1,3,2,3,3,3,4,3,5,3,6,3,7,3,8,3,9,3,null,{"$f":"W5+1","v":4},3,13,23,33,43,53,63,73,83,93,null,{"$f":"AI5+1","v":4},3,13,23,33,43,53,63,73,83,93]
[5,0,4,1,4,2,4,3,4,4,4,5,4,6,4,7,4,8,4,9,4,null,{"$f":"W6+1","v":5},4,14,24,34,44,54,64,74,84,94,null,{"$f":"AI6+1","v":5},4,14,24,34,44,54,64,74,84,94]
[6,0,5,1,5,2,5,3,5,4,5,5,5,6,5,7,5,8,5,9,5,null,{"$f":"W7+1","v":6},5,15,25,35,45,55,65,75,85,95,null,{"$f":"AI7+1","v":6},5,15,25,35,45,55,65,75,85,95]
[7,0,6,1,6,2,6,3,6,4,6,5,6,6,6,7,6,8,6,9,6,null,{"$f":"W8+1","v":7},6,16,26,36,46,56,66,76,86,96,null,{"$f":"AI8+1","v":7},6,16,26,36,46,56,66,76,86,96]
[8,0,7,1,7,2,7,3,7,4,7,5,7,6,7,7,7,8,7,9,7,null,{"$f":"W9+1","v":8},7,17,27,37,47,57,67,77,87,97,null,{"$f":"AI9+1","v":8},7,17,27,37,47,57,67,77,87,97]
[9,0,8,1,8,2,8,3,8,4,8,5,8,6,8,7,8,8,8,9,8,null,{"$f":"W10+1","v":9},8,18,28,38,48,58,68,78,88,98,null,{"$f":"AI10+1","v":9},8,18,28,38,48,58,68,78,88,98]
[10,0,9,1,9,2,9,3,9,4,9,5,9,6,9,7,9,8,9,9,9,null,{"$f":"W11+1","v":10},9,19,29,39,49,59,69,79,89,99,null,{"$f":"AI11+1","v":10},9,19,29,39,49,59,69,79,89,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ВАРИАНТ_1 ( выполненный )"]
[null,"Таблица_Слияния",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Таблица_1",null,null,null,null,null,null,null,null,null,null,null,"Таблица_2"]
[null,1,null,{"$f":"B19+1","v":2},null,{"$f":"D19+1","v":3},null,{"$f":"F19+1","v":4},null,{"$f":"H19+1","v":5},null,{"$f":"J19+1","v":6},null,{"$f":"L19+1","v":7},null,{"$f":"N19+1","v":8},null,{"$f":"P19+1","v":9},null,{"$f":"R19+1","v":10},null,null,null,1,{"$f":"X19+1","v":2},{"$f":"Y19+1","v":3},4,5,6,7,8,9,10,null,null,1,{"$f":"AJ19+1","v":2},{"$f":"AK19+1","v":3},4,5,6,7,8,9,10]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,1]
[{"$f":"A20+1","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W20+1","v":2},null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI20+1","v":2}]
[{"$f":"A21+1","v":3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W21+1","v":3},null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI21+1","v":3}]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,4]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,null,null,null,null,null,null,null,null,null,null,5]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,6]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,null,null,null,null,null,null,null,null,null,null,null,7]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,null,8]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,null,null,null,null,null,null,null,null,null,null,9]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,null,null,null,null,null,null,null,null,null,null,10]
[]
[]
[null,{"$f":"MOD(COLUMN(),2)+1","v":1},{"$f":"MOD(COLUMN(),2)+1","v":2},1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2,1,2]
[null,{"$f":"ROUND((COLUMN()-1)/2,0)","v":1},{"$f":"ROUND((COLUMN()-1)/2,0)","v":1},2,2,3,3,4,4,5,5,6,6,7,7,8,8,9,9,10,10]
[null,{"$f":"12+(MOD(COLUMN(),2)+1)*11-ROUND((COLUMN()-1)/2,0)","v":22},{"$f":"12+C32*11-C33","v":33},21,32,20,31,19,30,18,29,17,28,16,27,15,26,14,25,13,24]