{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Комп1"],"not_rendered":{"charts":8,"images":0,"macros":1,"external_links":0,"defined_names":7,"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":29,"n_cols":34,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,13,2,33]]}
[]
[null,null,null,null,null,null,null,null,null,null,1,3,4]
[null,null,null,null,null,null,null,null,null,null,3,4,5]
["Столбец1","Количество человек прошедших оценку","Математика","Русский","Литература","Физика","География","Информатика","Физкультура","Итого средняя оценка","Столбец2","Столбец3","Столбец4","Столбец5","Столбец6","Столбец7","Столбец8","Столбец9","Столбец10","Столбец11","Столбец12","Столбец13","Столбец14","Столбец15","Столбец16","Столбец17","Столбец18","Столбец19","Столбец20","Столбец21","Столбец22","Столбец23","Столбец24","Столбец25"]
["10Д",21,2.1,4.8,2.1,4.8,3.5,2.1,3.5,{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGE(Таблица1[[#This Row],[Математика]:[Физкультура]]))","v":3.2714285714285718},{"$f":"IF(AND($J5>=K$2,$J5<K$3),$J5,\"\")","v":""},{"$f":"IF(AND($J5>=L$2,$J5<L$3),$J5,\"\")","v":3.2714285714285718},{"$f":"IF(AND($J5>=M$2,$J5<=M$3),$J5,\"\")","v":""},{"$f":"IF(AND($C5>=K$2,$C5<K$3),$C5,\"\")","v":2.1},{"$f":"IF(AND($C5>=L$2,$C5<L$3),$C5,\"\")","v":""},{"$f":"IF(AND($C5>=M$2,$C5<=M$3),$C5,\"\")","v":""},{"$f":"IF(AND($D5>=K$2,$D5<K$3),$D5,\"\")","v":""},{"$f":"IF(AND($D5>=L$2,$D5<L$3),$D5,\"\")","v":""},{"$f":"IF(AND($D5>=M$2,$D5<=M$3),$D5,\"\")","v":4.8},{"$f":"IF(AND($E5>=K$2,$E5<K$3),$E5,\"\")","v":2.1},{"$f":"IF(AND($E5>=L$2,$E5<L$3),$E5,\"\")","v":""},{"$f":"IF(AND($E5>=M$2,$E5<=M$3),$E5,\"\")","v":""},{"$f":"IF(AND($F5>=K$2,$F5<K$3),$F5,\"\")","v":""},{"$f":"IF(AND($F5>=L$2,$F5<L$3),$F5,\"\")","v":""},{"$f":"IF(AND($F5>=M$2,$F5<=M$3),$F5,\"\")","v":4.8},{"$f":"IF(AND($G5>=K$2,$G5<K$3),$G5,\"\")","v":""},{"$f":"IF(AND($G5>=L$2,$G5<L$3),$G5,\"\")","v":3.5},{"$f":"IF(AND($G5>=M$2,$G5<=M$3),$G5,\"\")","v":""},{"$f":"IF(AND($H5>=K$2,$H5<K$3),$H5,\"\")","v":2.1},{"$f":"IF(AND($H5>=L$2,$H5<L$3),$H5,\"\")","v":""},{"$f":"IF(AND($H5>=M$2,$H5<=M$3),$H5,\"\")","v":""},{"$f":"IF(AND($I5>=K$2,$I5<K$3),$I5,\"\")","v":""},{"$f":"IF(AND($I5>=L$2,$I5<L$3),$I5,\"\")","v":3.5},{"$f":"IF(AND($I5>=M$2,$I5<=M$3),$I5,\"\")","v":""}]
["9Б",22,2.2000000000000002,4,2.2000000000000002,4,5,2.2000000000000002,3,{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGE(Таблица1[[#This Row],[Математика]:[Физкультура]]))","v":3.2285714285714282},{"$f":"IF(AND($J6>=K$2,$J6<K$3),$J6,\"\")","v":""},{"$f":"IF(AND($J6>=L$2,$J6<L$3),$J6,\"\")","v":3.2285714285714282},{"$f":"IF(AND($J6>=M$2,$J6<=M$3),$J6,\"\")","v":""},{"$f":"IF(AND($C6>=K$2,$C6<K$3),$C6,\"\")","v":2.2000000000000002},{"$f":"IF(AND($C6>=L$2,$C6<L$3),$C6,\"\")","v":""},{"$f":"IF(AND($C6>=M$2,$C6<=M$3),$C6,\"\")","v":""},{"$f":"IF(AND($D6>=K$2,$D6<K$3),$D6,\"\")","v":""},{"$f":"IF(AND($D6>=L$2,$D6<L$3),$D6,\"\")","v":""},{"$f":"IF(AND($D6>=M$2,$D6<=M$3),$D6,\"\")","v":4},{"$f":"IF(AND($E6>=K$2,$E6<K$3),$E6,\"\")","v":2.2000000000000002},{"$f":"IF(AND($E6>=L$2,$E6<L$3),$E6,\"\")","v":""},{"$f":"IF(AND($E6>=M$2,$E6<=M$3),$E6,\"\")","v":""},{"$f":"IF(AND($F6>=K$2,$F6<K$3),$F6,\"\")","v":""},{"$f":"IF(AND($F6>=L$2,$F6<L$3),$F6,\"\")","v":""},{"$f":"IF(AND($F6>=M$2,$F6<=M$3),$F6,\"\")","v":4},{"$f":"IF(AND($G6>=K$2,$G6<K$3),$G6,\"\")","v":""},{"$f":"IF(AND($G6>=L$2,$G6<L$3),$G6,\"\")","v":""},{"$f":"IF(AND($G6>=M$2,$G6<=M$3),$G6,\"\")","v":5},{"$f":"IF(AND($H6>=K$2,$H6<K$3),$H6,\"\")","v":2.2000000000000002},{"$f":"IF(AND($H6>=L$2,$H6<L$3),$H6,\"\")","v":""},{"$f":"IF(AND($H6>=M$2,$H6<=M$3),$H6,\"\")","v":""},{"$f":"IF(AND($I6>=K$2,$I6<K$3),$I6,\"\")","v":""},{"$f":"IF(AND($I6>=L$2,$I6<L$3),$I6,\"\")","v":3},{"$f":"IF(AND($I6>=M$2,$I6<=M$3),$I6,\"\")","v":""}]
["9В",23,2.2999999999999998,5,2.2999999999999998,5,2.1,2.2999999999999998,5,{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGE(Таблица1[[#This Row],[Математика]:[Физкультура]]))","v":3.4285714285714284},{"$f":"IF(AND($J7>=K$2,$J7<K$3),$J7,\"\")","v":""},{"$f":"IF(AND($J7>=L$2,$J7<L$3),$J7,\"\")","v":3.4285714285714284},{"$f":"IF(AND($J7>=M$2,$J7<=M$3),$J7,\"\")","v":""},{"$f":"IF(AND($C7>=K$2,$C7<K$3),$C7,\"\")","v":2.2999999999999998},{"$f":"IF(AND($C7>=L$2,$C7<L$3),$C7,\"\")","v":""},{"$f":"IF(AND($C7>=M$2,$C7<=M$3),$C7,\"\")","v":""},{"$f":"IF(AND($D7>=K$2,$D7<K$3),$D7,\"\")","v":""},{"$f":"IF(AND($D7>=L$2,$D7<L$3),$D7,\"\")","v":""},{"$f":"IF(AND($D7>=M$2,$D7<=M$3),$D7,\"\")","v":5},{"$f":"IF(AND($E7>=K$2,$E7<K$3),$E7,\"\")","v":2.2999999999999998},{"$f":"IF(AND($E7>=L$2,$E7<L$3),$E7,\"\")","v":""},{"$f":"IF(AND($E7>=M$2,$E7<=M$3),$E7,\"\")","v":""},{"$f":"IF(AND($F7>=K$2,$F7<K$3),$F7,\"\")","v":""},{"$f":"IF(AND($F7>=L$2,$F7<L$3),$F7,\"\")","v":""},{"$f":"IF(AND($F7>=M$2,$F7<=M$3),$F7,\"\")","v":5},{"$f":"IF(AND($G7>=K$2,$G7<K$3),$G7,\"\")","v":2.1},{"$f":"IF(AND($G7>=L$2,$G7<L$3),$G7,\"\")","v":""},{"$f":"IF(AND($G7>=M$2,$G7<=M$3),$G7,\"\")","v":""},{"$f":"IF(AND($H7>=K$2,$H7<K$3),$H7,\"\")","v":2.2999999999999998},{"$f":"IF(AND($H7>=L$2,$H7<L$3),$H7,\"\")","v":""},{"$f":"IF(AND($H7>=M$2,$H7<=M$3),$H7,\"\")","v":""},{"$f":"IF(AND($I7>=K$2,$I7<K$3),$I7,\"\")","v":""},{"$f":"IF(AND($I7>=L$2,$I7<L$3),$I7,\"\")","v":""},{"$f":"IF(AND($I7>=M$2,$I7<=M$3),$I7,\"\")","v":5}]
["10Г",20,2.8,2.1,2.8,2.1,2.5,2.8,2.5,{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGE(Таблица1[[#This Row],[Математика]:[Физкультура]]))","v":2.5142857142857147},{"$f":"IF(AND($J8>=K$2,$J8<K$3),$J8,\"\")","v":2.5142857142857147},{"$f":"IF(AND($J8>=L$2,$J8<L$3),$J8,\"\")","v":""},{"$f":"IF(AND($J8>=M$2,$J8<=M$3),$J8,\"\")","v":""},{"$f":"IF(AND($C8>=K$2,$C8<K$3),$C8,\"\")","v":2.8},{"$f":"IF(AND($C8>=L$2,$C8<L$3),$C8,\"\")","v":""},{"$f":"IF(AND($C8>=M$2,$C8<=M$3),$C8,\"\")","v":""},{"$f":"IF(AND($D8>=K$2,$D8<K$3),$D8,\"\")","v":2.1},{"$f":"IF(AND($D8>=L$2,$D8<L$3),$D8,\"\")","v":""},{"$f":"IF(AND($D8>=M$2,$D8<=M$3),$D8,\"\")","v":""},{"$f":"IF(AND($E8>=K$2,$E8<K$3),$E8,\"\")","v":2.8},{"$f":"IF(AND($E8>=L$2,$E8<L$3),$E8,\"\")","v":""},{"$f":"IF(AND($E8>=M$2,$E8<=M$3),$E8,\"\")","v":""},{"$f":"IF(AND($F8>=K$2,$F8<K$3),$F8,\"\")","v":2.1},{"$f":"IF(AND($F8>=L$2,$F8<L$3),$F8,\"\")","v":""},{"$f":"IF(AND($F8>=M$2,$F8<=M$3),$F8,\"\")","v":""},{"$f":"IF(AND($G8>=K$2,$G8<K$3),$G8,\"\")","v":2.5},{"$f":"IF(AND($G8>=L$2,$G8<L$3),$G8,\"\")","v":""},{"$f":"IF(AND($G8>=M$2,$G8<=M$3),$G8,\"\")","v":""},{"$f":"IF(AND($H8>=K$2,$H8<K$3),$H8,\"\")","v":2.8},{"$f":"IF(AND($H8>=L$2,$H8<L$3),$H8,\"\")","v":""},{"$f":"IF(AND($H8>=M$2,$H8<=M$3),$H8,\"\")","v":""},{"$f":"IF(AND($I8>=K$2,$I8<K$3),$I8,\"\")","v":2.5},{"$f":"IF(AND($I8>=L$2,$I8<L$3),$I8,\"\")","v":""},{"$f":"IF(AND($I8>=M$2,$I8<=M$3),$I8,\"\")","v":""}]
["9Д",15,3,2.5,3,2.5,3,3,3,{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGE(Таблица1[[#This Row],[Математика]:[Физкультура]]))","v":2.8571428571428572},{"$f":"IF(AND($J9>=K$2,$J9<K$3),$J9,\"\")","v":2.8571428571428572},{"$f":"IF(AND($J9>=L$2,$J9<L$3),$J9,\"\")","v":""},{"$f":"IF(AND($J9>=M$2,$J9<=M$3),$J9,\"\")","v":""},{"$f":"IF(AND($C9>=K$2,$C9<K$3),$C9,\"\")","v":""},{"$f":"IF(AND($C9>=L$2,$C9<L$3),$C9,\"\")","v":3},{"$f":"IF(AND($C9>=M$2,$C9<=M$3),$C9,\"\")","v":""},{"$f":"IF(AND($D9>=K$2,$D9<K$3),$D9,\"\")","v":2.5},{"$f":"IF(AND($D9>=L$2,$D9<L$3),$D9,\"\")","v":""},{"$f":"IF(AND($D9>=M$2,$D9<=M$3),$D9,\"\")","v":""},{"$f":"IF(AND($E9>=K$2,$E9<K$3),$E9,\"\")","v":""},{"$f":"IF(AND($E9>=L$2,$E9<L$3),$E9,\"\")","v":3},{"$f":"IF(AND($E9>=M$2,$E9<=M$3),$E9,\"\")","v":""},{"$f":"IF(AND($F9>=K$2,$F9<K$3),$F9,\"\")","v":2.5},{"$f":"IF(AND($F9>=L$2,$F9<L$3),$F9,\"\")","v":""},{"$f":"IF(AND($F9>=M$2,$F9<=M$3),$F9,\"\")","v":""},{"$f":"IF(AND($G9>=K$2,$G9<K$3),$G9,\"\")","v":""},{"$f":"IF(AND($G9>=L$2,$G9<L$3),$G9,\"\")","v":3},{"$f":"IF(AND($G9>=M$2,$G9<=M$3),$G9,\"\")","v":""},{"$f":"IF(AND($H9>=K$2,$H9<K$3),$H9,\"\")","v":""},{"$f":"IF(AND($H9>=L$2,$H9<L$3),$H9,\"\")","v":3},{"$f":"IF(AND($H9>=M$2,$H9<=M$3),$H9,\"\")","v":""},{"$f":"IF(AND($I9>=K$2,$I9<K$3),$I9,\"\")","v":""},{"$f":"IF(AND($I9>=L$2,$I9<L$3),$I9,\"\")","v":3},{"$f":"IF(AND($I9>=M$2,$I9<=M$3),$I9,\"\")","v":""}]
["9А",20,3.5,3,3.5,3,4.4000000000000004,3.5,4.5,{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGE(Таблица1[[#This Row],[Математика]:[Физкультура]]))","v":3.6285714285714286},{"$f":"IF(AND($J10>=K$2,$J10<K$3),$J10,\"\")","v":""},{"$f":"IF(AND($J10>=L$2,$J10<L$3),$J10,\"\")","v":3.6285714285714286},{"$f":"IF(AND($J10>=M$2,$J10<=M$3),$J10,\"\")","v":""},{"$f":"IF(AND($C10>=K$2,$C10<K$3),$C10,\"\")","v":""},{"$f":"IF(AND($C10>=L$2,$C10<L$3),$C10,\"\")","v":3.5},{"$f":"IF(AND($C10>=M$2,$C10<=M$3),$C10,\"\")","v":""},{"$f":"IF(AND($D10>=K$2,$D10<K$3),$D10,\"\")","v":""},{"$f":"IF(AND($D10>=L$2,$D10<L$3),$D10,\"\")","v":3},{"$f":"IF(AND($D10>=M$2,$D10<=M$3),$D10,\"\")","v":""},{"$f":"IF(AND($E10>=K$2,$E10<K$3),$E10,\"\")","v":""},{"$f":"IF(AND($E10>=L$2,$E10<L$3),$E10,\"\")","v":3.5},{"$f":"IF(AND($E10>=M$2,$E10<=M$3),$E10,\"\")","v":""},{"$f":"IF(AND($F10>=K$2,$F10<K$3),$F10,\"\")","v":""},{"$f":"IF(AND($F10>=L$2,$F10<L$3),$F10,\"\")","v":3},{"$f":"IF(AND($F10>=M$2,$F10<=M$3),$F10,\"\")","v":""},{"$f":"IF(AND($G10>=K$2,$G10<K$3),$G10,\"\")","v":""},{"$f":"IF(AND($G10>=L$2,$G10<L$3),$G10,\"\")","v":""},{"$f":"IF(AND($G10>=M$2,$G10<=M$3),$G10,\"\")","v":4.4000000000000004},{"$f":"IF(AND($H10>=K$2,$H10<K$3),$H10,\"\")","v":""},{"$f":"IF(AND($H10>=L$2,$H10<L$3),$H10,\"\")","v":3.5},{"$f":"IF(AND($H10>=M$2,$H10<=M$3),$H10,\"\")","v":""},{"$f":"IF(AND($I10>=K$2,$I10<K$3),$I10,\"\")","v":""},{"$f":"IF(AND($I10>=L$2,$I10<L$3),$I10,\"\")","v":""},{"$f":"IF(AND($I10>=M$2,$I10<=M$3),$I10,\"\")","v":4.5}]
["10В",18,3.8,5,3.8,5,4,3.8,4,{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGE(Таблица1[[#This Row],[Математика]:[Физкультура]]))","v":4.2},{"$f":"IF(AND($J11>=K$2,$J11<K$3),$J11,\"\")","v":""},{"$f":"IF(AND($J11>=L$2,$J11<L$3),$J11,\"\")","v":""},{"$f":"IF(AND($J11>=M$2,$J11<=M$3),$J11,\"\")","v":4.2},{"$f":"IF(AND($C11>=K$2,$C11<K$3),$C11,\"\")","v":""},{"$f":"IF(AND($C11>=L$2,$C11<L$3),$C11,\"\")","v":3.8},{"$f":"IF(AND($C11>=M$2,$C11<=M$3),$C11,\"\")","v":""},{"$f":"IF(AND($D11>=K$2,$D11<K$3),$D11,\"\")","v":""},{"$f":"IF(AND($D11>=L$2,$D11<L$3),$D11,\"\")","v":""},{"$f":"IF(AND($D11>=M$2,$D11<=M$3),$D11,\"\")","v":5},{"$f":"IF(AND($E11>=K$2,$E11<K$3),$E11,\"\")","v":""},{"$f":"IF(AND($E11>=L$2,$E11<L$3),$E11,\"\")","v":3.8},{"$f":"IF(AND($E11>=M$2,$E11<=M$3),$E11,\"\")","v":""},{"$f":"IF(AND($F11>=K$2,$F11<K$3),$F11,\"\")","v":""},{"$f":"IF(AND($F11>=L$2,$F11<L$3),$F11,\"\")","v":""},{"$f":"IF(AND($F11>=M$2,$F11<=M$3),$F11,\"\")","v":5},{"$f":"IF(AND($G11>=K$2,$G11<K$3),$G11,\"\")","v":""},{"$f":"IF(AND($G11>=L$2,$G11<L$3),$G11,\"\")","v":""},{"$f":"IF(AND($G11>=M$2,$G11<=M$3),$G11,\"\")","v":4},{"$f":"IF(AND($H11>=K$2,$H11<K$3),$H11,\"\")","v":""},{"$f":"IF(AND($H11>=L$2,$H11<L$3),$H11,\"\")","v":3.8},{"$f":"IF(AND($H11>=M$2,$H11<=M$3),$H11,\"\")","v":""},{"$f":"IF(AND($I11>=K$2,$I11<K$3),$I11,\"\")","v":""},{"$f":"IF(AND($I11>=L$2,$I11<L$3),$I11,\"\")","v":""},{"$f":"IF(AND($I11>=M$2,$I11<=M$3),$I11,\"\")","v":4}]
["9Г",24,4.5,4,4.5,4,4.8,4.5,4.9000000000000004,{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGE(Таблица1[[#This Row],[Математика]:[Физкультура]]))","v":4.4571428571428573},{"$f":"IF(AND($J12>=K$2,$J12<K$3),$J12,\"\")","v":""},{"$f":"IF(AND($J12>=L$2,$J12<L$3),$J12,\"\")","v":""},{"$f":"IF(AND($J12>=M$2,$J12<=M$3),$J12,\"\")","v":4.4571428571428573},{"$f":"IF(AND($C12>=K$2,$C12<K$3),$C12,\"\")","v":""},{"$f":"IF(AND($C12>=L$2,$C12<L$3),$C12,\"\")","v":""},{"$f":"IF(AND($C12>=M$2,$C12<=M$3),$C12,\"\")","v":4.5},{"$f":"IF(AND($D12>=K$2,$D12<K$3),$D12,\"\")","v":""},{"$f":"IF(AND($D12>=L$2,$D12<L$3),$D12,\"\")","v":""},{"$f":"IF(AND($D12>=M$2,$D12<=M$3),$D12,\"\")","v":4},{"$f":"IF(AND($E12>=K$2,$E12<K$3),$E12,\"\")","v":""},{"$f":"IF(AND($E12>=L$2,$E12<L$3),$E12,\"\")","v":""},{"$f":"IF(AND($E12>=M$2,$E12<=M$3),$E12,\"\")","v":4.5},{"$f":"IF(AND($F12>=K$2,$F12<K$3),$F12,\"\")","v":""},{"$f":"IF(AND($F12>=L$2,$F12<L$3),$F12,\"\")","v":""},{"$f":"IF(AND($F12>=M$2,$F12<=M$3),$F12,\"\")","v":4},{"$f":"IF(AND($G12>=K$2,$G12<K$3),$G12,\"\")","v":""},{"$f":"IF(AND($G12>=L$2,$G12<L$3),$G12,\"\")","v":""},{"$f":"IF(AND($G12>=M$2,$G12<=M$3),$G12,\"\")","v":4.8},{"$f":"IF(AND($H12>=K$2,$H12<K$3),$H12,\"\")","v":""},{"$f":"IF(AND($H12>=L$2,$H12<L$3),$H12,\"\")","v":""},{"$f":"IF(AND($H12>=M$2,$H12<=M$3),$H12,\"\")","v":4.5},{"$f":"IF(AND($I12>=K$2,$I12<K$3),$I12,\"\")","v":""},{"$f":"IF(AND($I12>=L$2,$I12<L$3),$I12,\"\")","v":""},{"$f":"IF(AND($I12>=M$2,$I12<=M$3),$I12,\"\")","v":4.9000000000000004}]
["10Б",20,4.9000000000000004,4.4000000000000004,4.9000000000000004,4.4000000000000004,5,4.9000000000000004,5,{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGE(Таблица1[[#This Row],[Математика]:[Физкультура]]))","v":4.7857142857142856},{"$f":"IF(AND($J13>=K$2,$J13<K$3),$J13,\"\")","v":""},{"$f":"IF(AND($J13>=L$2,$J13<L$3),$J13,\"\")","v":""},{"$f":"IF(AND($J13>=M$2,$J13<=M$3),$J13,\"\")","v":4.7857142857142856},{"$f":"IF(AND($C13>=K$2,$C13<K$3),$C13,\"\")","v":""},{"$f":"IF(AND($C13>=L$2,$C13<L$3),$C13,\"\")","v":""},{"$f":"IF(AND($C13>=M$2,$C13<=M$3),$C13,\"\")","v":4.9000000000000004},{"$f":"IF(AND($D13>=K$2,$D13<K$3),$D13,\"\")","v":""},{"$f":"IF(AND($D13>=L$2,$D13<L$3),$D13,\"\")","v":""},{"$f":"IF(AND($D13>=M$2,$D13<=M$3),$D13,\"\")","v":4.4000000000000004},{"$f":"IF(AND($E13>=K$2,$E13<K$3),$E13,\"\")","v":""},{"$f":"IF(AND($E13>=L$2,$E13<L$3),$E13,\"\")","v":""},{"$f":"IF(AND($E13>=M$2,$E13<=M$3),$E13,\"\")","v":4.9000000000000004},{"$f":"IF(AND($F13>=K$2,$F13<K$3),$F13,\"\")","v":""},{"$f":"IF(AND($F13>=L$2,$F13<L$3),$F13,\"\")","v":""},{"$f":"IF(AND($F13>=M$2,$F13<=M$3),$F13,\"\")","v":4.4000000000000004},{"$f":"IF(AND($G13>=K$2,$G13<K$3),$G13,\"\")","v":""},{"$f":"IF(AND($G13>=L$2,$G13<L$3),$G13,\"\")","v":""},{"$f":"IF(AND($G13>=M$2,$G13<=M$3),$G13,\"\")","v":5},{"$f":"IF(AND($H13>=K$2,$H13<K$3),$H13,\"\")","v":""},{"$f":"IF(AND($H13>=L$2,$H13<L$3),$H13,\"\")","v":""},{"$f":"IF(AND($H13>=M$2,$H13<=M$3),$H13,\"\")","v":4.9000000000000004},{"$f":"IF(AND($I13>=K$2,$I13<K$3),$I13,\"\")","v":""},{"$f":"IF(AND($I13>=L$2,$I13<L$3),$I13,\"\")","v":""},{"$f":"IF(AND($I13>=M$2,$I13<=M$3),$I13,\"\")","v":5}]
["10А",19,5,3.5,5,3.5,4,5,4,{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGE(Таблица1[[#This Row],[Математика]:[Физкультура]]))","v":4.2857142857142856},{"$f":"IF(AND($J14>=K$2,$J14<K$3),$J14,\"\")","v":""},{"$f":"IF(AND($J14>=L$2,$J14<L$3),$J14,\"\")","v":""},{"$f":"IF(AND($J14>=M$2,$J14<=M$3),$J14,\"\")","v":4.2857142857142856},{"$f":"IF(AND($C14>=K$2,$C14<K$3),$C14,\"\")","v":""},{"$f":"IF(AND($C14>=L$2,$C14<L$3),$C14,\"\")","v":""},{"$f":"IF(AND($C14>=M$2,$C14<=M$3),$C14,\"\")","v":5},{"$f":"IF(AND($D14>=K$2,$D14<K$3),$D14,\"\")","v":""},{"$f":"IF(AND($D14>=L$2,$D14<L$3),$D14,\"\")","v":3.5},{"$f":"IF(AND($D14>=M$2,$D14<=M$3),$D14,\"\")","v":""},{"$f":"IF(AND($E14>=K$2,$E14<K$3),$E14,\"\")","v":""},{"$f":"IF(AND($E14>=L$2,$E14<L$3),$E14,\"\")","v":""},{"$f":"IF(AND($E14>=M$2,$E14<=M$3),$E14,\"\")","v":5},{"$f":"IF(AND($F14>=K$2,$F14<K$3),$F14,\"\")","v":""},{"$f":"IF(AND($F14>=L$2,$F14<L$3),$F14,\"\")","v":3.5},{"$f":"IF(AND($F14>=M$2,$F14<=M$3),$F14,\"\")","v":""},{"$f":"IF(AND($G14>=K$2,$G14<K$3),$G14,\"\")","v":""},{"$f":"IF(AND($G14>=L$2,$G14<L$3),$G14,\"\")","v":""},{"$f":"IF(AND($G14>=M$2,$G14<=M$3),$G14,\"\")","v":4},{"$f":"IF(AND($H14>=K$2,$H14<K$3),$H14,\"\")","v":""},{"$f":"IF(AND($H14>=L$2,$H14<L$3),$H14,\"\")","v":""},{"$f":"IF(AND($H14>=M$2,$H14<=M$3),$H14,\"\")","v":5},{"$f":"IF(AND($I14>=K$2,$I14<K$3),$I14,\"\")","v":""},{"$f":"IF(AND($I14>=L$2,$I14<L$3),$I14,\"\")","v":""},{"$f":"IF(AND($I14>=M$2,$I14<=M$3),$I14,\"\")","v":4}]
[0,null,{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGE(Таблица1[[#This Row],[Математика]:[Физкультура]]))","v":""},{"$f":"IF(AND($J15>=K$2,$J15<K$3),$J15,\"\")","v":""},{"$f":"IF(AND($J15>=L$2,$J15<L$3),$J15,\"\")","v":""},{"$f":"IF(AND($J15>=M$2,$J15<=M$3),$J15,\"\")","v":""},{"$f":"IF(AND($C15>=K$2,$C15<K$3),$C15,\"\")","v":""},{"$f":"IF(AND($C15>=L$2,$C15<L$3),$C15,\"\")","v":""},{"$f":"IF(AND($C15>=M$2,$C15<=M$3),$C15,\"\")","v":""},{"$f":"IF(AND($D15>=K$2,$D15<K$3),$D15,\"\")","v":""},{"$f":"IF(AND($D15>=L$2,$D15<L$3),$D15,\"\")","v":""},{"$f":"IF(AND($D15>=M$2,$D15<=M$3),$D15,\"\")","v":""},{"$f":"IF(AND($E15>=K$2,$E15<K$3),$E15,\"\")","v":""},{"$f":"IF(AND($E15>=L$2,$E15<L$3),$E15,\"\")","v":""},{"$f":"IF(AND($E15>=M$2,$E15<=M$3),$E15,\"\")","v":""},{"$f":"IF(AND($F15>=K$2,$F15<K$3),$F15,\"\")","v":""},{"$f":"IF(AND($F15>=L$2,$F15<L$3),$F15,\"\")","v":""},{"$f":"IF(AND($F15>=M$2,$F15<=M$3),$F15,\"\")","v":""},{"$f":"IF(AND($G15>=K$2,$G15<K$3),$G15,\"\")","v":""},{"$f":"IF(AND($G15>=L$2,$G15<L$3),$G15,\"\")","v":""},{"$f":"IF(AND($G15>=M$2,$G15<=M$3),$G15,\"\")","v":""},{"$f":"IF(AND($H15>=K$2,$H15<K$3),$H15,\"\")","v":""},{"$f":"IF(AND($H15>=L$2,$H15<L$3),$H15,\"\")","v":""},{"$f":"IF(AND($H15>=M$2,$H15<=M$3),$H15,\"\")","v":""},{"$f":"IF(AND($I15>=K$2,$I15<K$3),$I15,\"\")","v":""},{"$f":"IF(AND($I15>=L$2,$I15<L$3),$I15,\"\")","v":""},{"$f":"IF(AND($I15>=M$2,$I15<=M$3),$I15,\"\")","v":""}]
[0,null,{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGE(Таблица1[[#This Row],[Математика]:[Физкультура]]))","v":""},{"$f":"IF(AND($J16>=K$2,$J16<K$3),$J16,\"\")","v":""},{"$f":"IF(AND($J16>=L$2,$J16<L$3),$J16,\"\")","v":""},{"$f":"IF(AND($J16>=M$2,$J16<=M$3),$J16,\"\")","v":""},{"$f":"IF(AND($C16>=K$2,$C16<K$3),$C16,\"\")","v":""},{"$f":"IF(AND($C16>=L$2,$C16<L$3),$C16,\"\")","v":""},{"$f":"IF(AND($C16>=M$2,$C16<=M$3),$C16,\"\")","v":""},{"$f":"IF(AND($D16>=K$2,$D16<K$3),$D16,\"\")","v":""},{"$f":"IF(AND($D16>=L$2,$D16<L$3),$D16,\"\")","v":""},{"$f":"IF(AND($D16>=M$2,$D16<=M$3),$D16,\"\")","v":""},{"$f":"IF(AND($E16>=K$2,$E16<K$3),$E16,\"\")","v":""},{"$f":"IF(AND($E16>=L$2,$E16<L$3),$E16,\"\")","v":""},{"$f":"IF(AND($E16>=M$2,$E16<=M$3),$E16,\"\")","v":""},{"$f":"IF(AND($F16>=K$2,$F16<K$3),$F16,\"\")","v":""},{"$f":"IF(AND($F16>=L$2,$F16<L$3),$F16,\"\")","v":""},{"$f":"IF(AND($F16>=M$2,$F16<=M$3),$F16,\"\")","v":""},{"$f":"IF(AND($G16>=K$2,$G16<K$3),$G16,\"\")","v":""},{"$f":"IF(AND($G16>=L$2,$G16<L$3),$G16,\"\")","v":""},{"$f":"IF(AND($G16>=M$2,$G16<=M$3),$G16,\"\")","v":""},{"$f":"IF(AND($H16>=K$2,$H16<K$3),$H16,\"\")","v":""},{"$f":"IF(AND($H16>=L$2,$H16<L$3),$H16,\"\")","v":""},{"$f":"IF(AND($H16>=M$2,$H16<=M$3),$H16,\"\")","v":""},{"$f":"IF(AND($I16>=K$2,$I16<K$3),$I16,\"\")","v":""},{"$f":"IF(AND($I16>=L$2,$I16<L$3),$I16,\"\")","v":""},{"$f":"IF(AND($I16>=M$2,$I16<=M$3),$I16,\"\")","v":""}]
[0,null,{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGE(Таблица1[[#This Row],[Математика]:[Физкультура]]))","v":""},{"$f":"IF(AND($J17>=K$2,$J17<K$3),$J17,\"\")","v":""},{"$f":"IF(AND($J17>=L$2,$J17<L$3),$J17,\"\")","v":""},{"$f":"IF(AND($J17>=M$2,$J17<=M$3),$J17,\"\")","v":""},{"$f":"IF(AND($C17>=K$2,$C17<K$3),$C17,\"\")","v":""},{"$f":"IF(AND($C17>=L$2,$C17<L$3),$C17,\"\")","v":""},{"$f":"IF(AND($C17>=M$2,$C17<=M$3),$C17,\"\")","v":""},{"$f":"IF(AND($D17>=K$2,$D17<K$3),$D17,\"\")","v":""},{"$f":"IF(AND($D17>=L$2,$D17<L$3),$D17,\"\")","v":""},{"$f":"IF(AND($D17>=M$2,$D17<=M$3),$D17,\"\")","v":""},{"$f":"IF(AND($E17>=K$2,$E17<K$3),$E17,\"\")","v":""},{"$f":"IF(AND($E17>=L$2,$E17<L$3),$E17,\"\")","v":""},{"$f":"IF(AND($E17>=M$2,$E17<=M$3),$E17,\"\")","v":""},{"$f":"IF(AND($F17>=K$2,$F17<K$3),$F17,\"\")","v":""},{"$f":"IF(AND($F17>=L$2,$F17<L$3),$F17,\"\")","v":""},{"$f":"IF(AND($F17>=M$2,$F17<=M$3),$F17,\"\")","v":""},{"$f":"IF(AND($G17>=K$2,$G17<K$3),$G17,\"\")","v":""},{"$f":"IF(AND($G17>=L$2,$G17<L$3),$G17,\"\")","v":""},{"$f":"IF(AND($G17>=M$2,$G17<=M$3),$G17,\"\")","v":""},{"$f":"IF(AND($H17>=K$2,$H17<K$3),$H17,\"\")","v":""},{"$f":"IF(AND($H17>=L$2,$H17<L$3),$H17,\"\")","v":""},{"$f":"IF(AND($H17>=M$2,$H17<=M$3),$H17,\"\")","v":""},{"$f":"IF(AND($I17>=K$2,$I17<K$3),$I17,\"\")","v":""},{"$f":"IF(AND($I17>=L$2,$I17<L$3),$I17,\"\")","v":""},{"$f":"IF(AND($I17>=M$2,$I17<=M$3),$I17,\"\")","v":""}]
[0,null,{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGE(Таблица1[[#This Row],[Математика]:[Физкультура]]))","v":""},{"$f":"IF(AND($J18>=K$2,$J18<K$3),$J18,\"\")","v":""},{"$f":"IF(AND($J18>=L$2,$J18<L$3),$J18,\"\")","v":""},{"$f":"IF(AND($J18>=M$2,$J18<=M$3),$J18,\"\")","v":""},{"$f":"IF(AND($C18>=K$2,$C18<K$3),$C18,\"\")","v":""},{"$f":"IF(AND($C18>=L$2,$C18<L$3),$C18,\"\")","v":""},{"$f":"IF(AND($C18>=M$2,$C18<=M$3),$C18,\"\")","v":""},{"$f":"IF(AND($D18>=K$2,$D18<K$3),$D18,\"\")","v":""},{"$f":"IF(AND($D18>=L$2,$D18<L$3),$D18,\"\")","v":""},{"$f":"IF(AND($D18>=M$2,$D18<=M$3),$D18,\"\")","v":""},{"$f":"IF(AND($E18>=K$2,$E18<K$3),$E18,\"\")","v":""},{"$f":"IF(AND($E18>=L$2,$E18<L$3),$E18,\"\")","v":""},{"$f":"IF(AND($E18>=M$2,$E18<=M$3),$E18,\"\")","v":""},{"$f":"IF(AND($F18>=K$2,$F18<K$3),$F18,\"\")","v":""},{"$f":"IF(AND($F18>=L$2,$F18<L$3),$F18,\"\")","v":""},{"$f":"IF(AND($F18>=M$2,$F18<=M$3),$F18,\"\")","v":""},{"$f":"IF(AND($G18>=K$2,$G18<K$3),$G18,\"\")","v":""},{"$f":"IF(AND($G18>=L$2,$G18<L$3),$G18,\"\")","v":""},{"$f":"IF(AND($G18>=M$2,$G18<=M$3),$G18,\"\")","v":""},{"$f":"IF(AND($H18>=K$2,$H18<K$3),$H18,\"\")","v":""},{"$f":"IF(AND($H18>=L$2,$H18<L$3),$H18,\"\")","v":""},{"$f":"IF(AND($H18>=M$2,$H18<=M$3),$H18,\"\")","v":""},{"$f":"IF(AND($I18>=K$2,$I18<K$3),$I18,\"\")","v":""},{"$f":"IF(AND($I18>=L$2,$I18<L$3),$I18,\"\")","v":""},{"$f":"IF(AND($I18>=M$2,$I18<=M$3),$I18,\"\")","v":""}]
[0,null,{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGE(Таблица1[[#This Row],[Математика]:[Физкультура]]))","v":""},{"$f":"IF(AND($J19>=K$2,$J19<K$3),$J19,\"\")","v":""},{"$f":"IF(AND($J19>=L$2,$J19<L$3),$J19,\"\")","v":""},{"$f":"IF(AND($J19>=M$2,$J19<=M$3),$J19,\"\")","v":""},{"$f":"IF(AND($C19>=K$2,$C19<K$3),$C19,\"\")","v":""},{"$f":"IF(AND($C19>=L$2,$C19<L$3),$C19,\"\")","v":""},{"$f":"IF(AND($C19>=M$2,$C19<=M$3),$C19,\"\")","v":""},{"$f":"IF(AND($D19>=K$2,$D19<K$3),$D19,\"\")","v":""},{"$f":"IF(AND($D19>=L$2,$D19<L$3),$D19,\"\")","v":""},{"$f":"IF(AND($D19>=M$2,$D19<=M$3),$D19,\"\")","v":""},{"$f":"IF(AND($E19>=K$2,$E19<K$3),$E19,\"\")","v":""},{"$f":"IF(AND($E19>=L$2,$E19<L$3),$E19,\"\")","v":""},{"$f":"IF(AND($E19>=M$2,$E19<=M$3),$E19,\"\")","v":""},{"$f":"IF(AND($F19>=K$2,$F19<K$3),$F19,\"\")","v":""},{"$f":"IF(AND($F19>=L$2,$F19<L$3),$F19,\"\")","v":""},{"$f":"IF(AND($F19>=M$2,$F19<=M$3),$F19,\"\")","v":""},{"$f":"IF(AND($G19>=K$2,$G19<K$3),$G19,\"\")","v":""},{"$f":"IF(AND($G19>=L$2,$G19<L$3),$G19,\"\")","v":""},{"$f":"IF(AND($G19>=M$2,$G19<=M$3),$G19,\"\")","v":""},{"$f":"IF(AND($H19>=K$2,$H19<K$3),$H19,\"\")","v":""},{"$f":"IF(AND($H19>=L$2,$H19<L$3),$H19,\"\")","v":""},{"$f":"IF(AND($H19>=M$2,$H19<=M$3),$H19,\"\")","v":""},{"$f":"IF(AND($I19>=K$2,$I19<K$3),$I19,\"\")","v":""},{"$f":"IF(AND($I19>=L$2,$I19<L$3),$I19,\"\")","v":""},{"$f":"IF(AND($I19>=M$2,$I19<=M$3),$I19,\"\")","v":""}]
[0,null,{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGE(Таблица1[[#This Row],[Математика]:[Физкультура]]))","v":""},{"$f":"IF(AND($J20>=K$2,$J20<K$3),$J20,\"\")","v":""},{"$f":"IF(AND($J20>=L$2,$J20<L$3),$J20,\"\")","v":""},{"$f":"IF(AND($J20>=M$2,$J20<=M$3),$J20,\"\")","v":""},{"$f":"IF(AND($C20>=K$2,$C20<K$3),$C20,\"\")","v":""},{"$f":"IF(AND($C20>=L$2,$C20<L$3),$C20,\"\")","v":""},{"$f":"IF(AND($C20>=M$2,$C20<=M$3),$C20,\"\")","v":""},{"$f":"IF(AND($D20>=K$2,$D20<K$3),$D20,\"\")","v":""},{"$f":"IF(AND($D20>=L$2,$D20<L$3),$D20,\"\")","v":""},{"$f":"IF(AND($D20>=M$2,$D20<=M$3),$D20,\"\")","v":""},{"$f":"IF(AND($E20>=K$2,$E20<K$3),$E20,\"\")","v":""},{"$f":"IF(AND($E20>=L$2,$E20<L$3),$E20,\"\")","v":""},{"$f":"IF(AND($E20>=M$2,$E20<=M$3),$E20,\"\")","v":""},{"$f":"IF(AND($F20>=K$2,$F20<K$3),$F20,\"\")","v":""},{"$f":"IF(AND($F20>=L$2,$F20<L$3),$F20,\"\")","v":""},{"$f":"IF(AND($F20>=M$2,$F20<=M$3),$F20,\"\")","v":""},{"$f":"IF(AND($G20>=K$2,$G20<K$3),$G20,\"\")","v":""},{"$f":"IF(AND($G20>=L$2,$G20<L$3),$G20,\"\")","v":""},{"$f":"IF(AND($G20>=M$2,$G20<=M$3),$G20,\"\")","v":""},{"$f":"IF(AND($H20>=K$2,$H20<K$3),$H20,\"\")","v":""},{"$f":"IF(AND($H20>=L$2,$H20<L$3),$H20,\"\")","v":""},{"$f":"IF(AND($H20>=M$2,$H20<=M$3),$H20,\"\")","v":""},{"$f":"IF(AND($I20>=K$2,$I20<K$3),$I20,\"\")","v":""},{"$f":"IF(AND($I20>=L$2,$I20<L$3),$I20,\"\")","v":""},{"$f":"IF(AND($I20>=M$2,$I20<=M$3),$I20,\"\")","v":""}]
[0,null,{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGE(Таблица1[[#This Row],[Математика]:[Физкультура]]))","v":""},{"$f":"IF(AND($J21>=K$2,$J21<K$3),$J21,\"\")","v":""},{"$f":"IF(AND($J21>=L$2,$J21<L$3),$J21,\"\")","v":""},{"$f":"IF(AND($J21>=M$2,$J21<=M$3),$J21,\"\")","v":""},{"$f":"IF(AND($C21>=K$2,$C21<K$3),$C21,\"\")","v":""},{"$f":"IF(AND($C21>=L$2,$C21<L$3),$C21,\"\")","v":""},{"$f":"IF(AND($C21>=M$2,$C21<=M$3),$C21,\"\")","v":""},{"$f":"IF(AND($D21>=K$2,$D21<K$3),$D21,\"\")","v":""},{"$f":"IF(AND($D21>=L$2,$D21<L$3),$D21,\"\")","v":""},{"$f":"IF(AND($D21>=M$2,$D21<=M$3),$D21,\"\")","v":""},{"$f":"IF(AND($E21>=K$2,$E21<K$3),$E21,\"\")","v":""},{"$f":"IF(AND($E21>=L$2,$E21<L$3),$E21,\"\")","v":""},{"$f":"IF(AND($E21>=M$2,$E21<=M$3),$E21,\"\")","v":""},{"$f":"IF(AND($F21>=K$2,$F21<K$3),$F21,\"\")","v":""},{"$f":"IF(AND($F21>=L$2,$F21<L$3),$F21,\"\")","v":""},{"$f":"IF(AND($F21>=M$2,$F21<=M$3),$F21,\"\")","v":""},{"$f":"IF(AND($G21>=K$2,$G21<K$3),$G21,\"\")","v":""},{"$f":"IF(AND($G21>=L$2,$G21<L$3),$G21,\"\")","v":""},{"$f":"IF(AND($G21>=M$2,$G21<=M$3),$G21,\"\")","v":""},{"$f":"IF(AND($H21>=K$2,$H21<K$3),$H21,\"\")","v":""},{"$f":"IF(AND($H21>=L$2,$H21<L$3),$H21,\"\")","v":""},{"$f":"IF(AND($H21>=M$2,$H21<=M$3),$H21,\"\")","v":""},{"$f":"IF(AND($I21>=K$2,$I21<K$3),$I21,\"\")","v":""},{"$f":"IF(AND($I21>=L$2,$I21<L$3),$I21,\"\")","v":""},{"$f":"IF(AND($I21>=M$2,$I21<=M$3),$I21,\"\")","v":""}]
[0,null,{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGE(Таблица1[[#This Row],[Математика]:[Физкультура]]))","v":""},{"$f":"IF(AND($J22>=K$2,$J22<K$3),$J22,\"\")","v":""},{"$f":"IF(AND($J22>=L$2,$J22<L$3),$J22,\"\")","v":""},{"$f":"IF(AND($J22>=M$2,$J22<=M$3),$J22,\"\")","v":""},{"$f":"IF(AND($C22>=K$2,$C22<K$3),$C22,\"\")","v":""},{"$f":"IF(AND($C22>=L$2,$C22<L$3),$C22,\"\")","v":""},{"$f":"IF(AND($C22>=M$2,$C22<=M$3),$C22,\"\")","v":""},{"$f":"IF(AND($D22>=K$2,$D22<K$3),$D22,\"\")","v":""},{"$f":"IF(AND($D22>=L$2,$D22<L$3),$D22,\"\")","v":""},{"$f":"IF(AND($D22>=M$2,$D22<=M$3),$D22,\"\")","v":""},{"$f":"IF(AND($E22>=K$2,$E22<K$3),$E22,\"\")","v":""},{"$f":"IF(AND($E22>=L$2,$E22<L$3),$E22,\"\")","v":""},{"$f":"IF(AND($E22>=M$2,$E22<=M$3),$E22,\"\")","v":""},{"$f":"IF(AND($F22>=K$2,$F22<K$3),$F22,\"\")","v":""},{"$f":"IF(AND($F22>=L$2,$F22<L$3),$F22,\"\")","v":""},{"$f":"IF(AND($F22>=M$2,$F22<=M$3),$F22,\"\")","v":""},{"$f":"IF(AND($G22>=K$2,$G22<K$3),$G22,\"\")","v":""},{"$f":"IF(AND($G22>=L$2,$G22<L$3),$G22,\"\")","v":""},{"$f":"IF(AND($G22>=M$2,$G22<=M$3),$G22,\"\")","v":""},{"$f":"IF(AND($H22>=K$2,$H22<K$3),$H22,\"\")","v":""},{"$f":"IF(AND($H22>=L$2,$H22<L$3),$H22,\"\")","v":""},{"$f":"IF(AND($H22>=M$2,$H22<=M$3),$H22,\"\")","v":""},{"$f":"IF(AND($I22>=K$2,$I22<K$3),$I22,\"\")","v":""},{"$f":"IF(AND($I22>=L$2,$I22<L$3),$I22,\"\")","v":""},{"$f":"IF(AND($I22>=M$2,$I22<=M$3),$I22,\"\")","v":""}]
[0,null,{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGE(Таблица1[[#This Row],[Математика]:[Физкультура]]))","v":""},{"$f":"IF(AND($J23>=K$2,$J23<K$3),$J23,\"\")","v":""},{"$f":"IF(AND($J23>=L$2,$J23<L$3),$J23,\"\")","v":""},{"$f":"IF(AND($J23>=M$2,$J23<=M$3),$J23,\"\")","v":""},{"$f":"IF(AND($C23>=K$2,$C23<K$3),$C23,\"\")","v":""},{"$f":"IF(AND($C23>=L$2,$C23<L$3),$C23,\"\")","v":""},{"$f":"IF(AND($C23>=M$2,$C23<=M$3),$C23,\"\")","v":""},{"$f":"IF(AND($D23>=K$2,$D23<K$3),$D23,\"\")","v":""},{"$f":"IF(AND($D23>=L$2,$D23<L$3),$D23,\"\")","v":""},{"$f":"IF(AND($D23>=M$2,$D23<=M$3),$D23,\"\")","v":""},{"$f":"IF(AND($E23>=K$2,$E23<K$3),$E23,\"\")","v":""},{"$f":"IF(AND($E23>=L$2,$E23<L$3),$E23,\"\")","v":""},{"$f":"IF(AND($E23>=M$2,$E23<=M$3),$E23,\"\")","v":""},{"$f":"IF(AND($F23>=K$2,$F23<K$3),$F23,\"\")","v":""},{"$f":"IF(AND($F23>=L$2,$F23<L$3),$F23,\"\")","v":""},{"$f":"IF(AND($F23>=M$2,$F23<=M$3),$F23,\"\")","v":""},{"$f":"IF(AND($G23>=K$2,$G23<K$3),$G23,\"\")","v":""},{"$f":"IF(AND($G23>=L$2,$G23<L$3),$G23,\"\")","v":""},{"$f":"IF(AND($G23>=M$2,$G23<=M$3),$G23,\"\")","v":""},{"$f":"IF(AND($H23>=K$2,$H23<K$3),$H23,\"\")","v":""},{"$f":"IF(AND($H23>=L$2,$H23<L$3),$H23,\"\")","v":""},{"$f":"IF(AND($H23>=M$2,$H23<=M$3),$H23,\"\")","v":""},{"$f":"IF(AND($I23>=K$2,$I23<K$3),$I23,\"\")","v":""},{"$f":"IF(AND($I23>=L$2,$I23<L$3),$I23,\"\")","v":""},{"$f":"IF(AND($I23>=M$2,$I23<=M$3),$I23,\"\")","v":""}]
[0,null,{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGE(Таблица1[[#This Row],[Математика]:[Физкультура]]))","v":""},{"$f":"IF(AND($J24>=K$2,$J24<K$3),$J24,\"\")","v":""},{"$f":"IF(AND($J24>=L$2,$J24<L$3),$J24,\"\")","v":""},{"$f":"IF(AND($J24>=M$2,$J24<=M$3),$J24,\"\")","v":""},{"$f":"IF(AND($C24>=K$2,$C24<K$3),$C24,\"\")","v":""},{"$f":"IF(AND($C24>=L$2,$C24<L$3),$C24,\"\")","v":""},{"$f":"IF(AND($C24>=M$2,$C24<=M$3),$C24,\"\")","v":""},{"$f":"IF(AND($D24>=K$2,$D24<K$3),$D24,\"\")","v":""},{"$f":"IF(AND($D24>=L$2,$D24<L$3),$D24,\"\")","v":""},{"$f":"IF(AND($D24>=M$2,$D24<=M$3),$D24,\"\")","v":""},{"$f":"IF(AND($E24>=K$2,$E24<K$3),$E24,\"\")","v":""},{"$f":"IF(AND($E24>=L$2,$E24<L$3),$E24,\"\")","v":""},{"$f":"IF(AND($E24>=M$2,$E24<=M$3),$E24,\"\")","v":""},{"$f":"IF(AND($F24>=K$2,$F24<K$3),$F24,\"\")","v":""},{"$f":"IF(AND($F24>=L$2,$F24<L$3),$F24,\"\")","v":""},{"$f":"IF(AND($F24>=M$2,$F24<=M$3),$F24,\"\")","v":""},{"$f":"IF(AND($G24>=K$2,$G24<K$3),$G24,\"\")","v":""},{"$f":"IF(AND($G24>=L$2,$G24<L$3),$G24,\"\")","v":""},{"$f":"IF(AND($G24>=M$2,$G24<=M$3),$G24,\"\")","v":""},{"$f":"IF(AND($H24>=K$2,$H24<K$3),$H24,\"\")","v":""},{"$f":"IF(AND($H24>=L$2,$H24<L$3),$H24,\"\")","v":""},{"$f":"IF(AND($H24>=M$2,$H24<=M$3),$H24,\"\")","v":""},{"$f":"IF(AND($I24>=K$2,$I24<K$3),$I24,\"\")","v":""},{"$f":"IF(AND($I24>=L$2,$I24<L$3),$I24,\"\")","v":""},{"$f":"IF(AND($I24>=M$2,$I24<=M$3),$I24,\"\")","v":""}]
[0,null,{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGE(Таблица1[[#This Row],[Математика]:[Физкультура]]))","v":""},{"$f":"IF(AND($J25>=K$2,$J25<K$3),$J25,\"\")","v":""},{"$f":"IF(AND($J25>=L$2,$J25<L$3),$J25,\"\")","v":""},{"$f":"IF(AND($J25>=M$2,$J25<=M$3),$J25,\"\")","v":""},{"$f":"IF(AND($C25>=K$2,$C25<K$3),$C25,\"\")","v":""},{"$f":"IF(AND($C25>=L$2,$C25<L$3),$C25,\"\")","v":""},{"$f":"IF(AND($C25>=M$2,$C25<=M$3),$C25,\"\")","v":""},{"$f":"IF(AND($D25>=K$2,$D25<K$3),$D25,\"\")","v":""},{"$f":"IF(AND($D25>=L$2,$D25<L$3),$D25,\"\")","v":""},{"$f":"IF(AND($D25>=M$2,$D25<=M$3),$D25,\"\")","v":""},{"$f":"IF(AND($E25>=K$2,$E25<K$3),$E25,\"\")","v":""},{"$f":"IF(AND($E25>=L$2,$E25<L$3),$E25,\"\")","v":""},{"$f":"IF(AND($E25>=M$2,$E25<=M$3),$E25,\"\")","v":""},{"$f":"IF(AND($F25>=K$2,$F25<K$3),$F25,\"\")","v":""},{"$f":"IF(AND($F25>=L$2,$F25<L$3),$F25,\"\")","v":""},{"$f":"IF(AND($F25>=M$2,$F25<=M$3),$F25,\"\")","v":""},{"$f":"IF(AND($G25>=K$2,$G25<K$3),$G25,\"\")","v":""},{"$f":"IF(AND($G25>=L$2,$G25<L$3),$G25,\"\")","v":""},{"$f":"IF(AND($G25>=M$2,$G25<=M$3),$G25,\"\")","v":""},{"$f":"IF(AND($H25>=K$2,$H25<K$3),$H25,\"\")","v":""},{"$f":"IF(AND($H25>=L$2,$H25<L$3),$H25,\"\")","v":""},{"$f":"IF(AND($H25>=M$2,$H25<=M$3),$H25,\"\")","v":""},{"$f":"IF(AND($I25>=K$2,$I25<K$3),$I25,\"\")","v":""},{"$f":"IF(AND($I25>=L$2,$I25<L$3),$I25,\"\")","v":""},{"$f":"IF(AND($I25>=M$2,$I25<=M$3),$I25,\"\")","v":""}]
[0,null,{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGE(Таблица1[[#This Row],[Математика]:[Физкультура]]))","v":""},{"$f":"IF(AND($J26>=K$2,$J26<K$3),$J26,\"\")","v":""},{"$f":"IF(AND($J26>=L$2,$J26<L$3),$J26,\"\")","v":""},{"$f":"IF(AND($J26>=M$2,$J26<=M$3),$J26,\"\")","v":""},{"$f":"IF(AND($C26>=K$2,$C26<K$3),$C26,\"\")","v":""},{"$f":"IF(AND($C26>=L$2,$C26<L$3),$C26,\"\")","v":""},{"$f":"IF(AND($C26>=M$2,$C26<=M$3),$C26,\"\")","v":""},{"$f":"IF(AND($D26>=K$2,$D26<K$3),$D26,\"\")","v":""},{"$f":"IF(AND($D26>=L$2,$D26<L$3),$D26,\"\")","v":""},{"$f":"IF(AND($D26>=M$2,$D26<=M$3),$D26,\"\")","v":""},{"$f":"IF(AND($E26>=K$2,$E26<K$3),$E26,\"\")","v":""},{"$f":"IF(AND($E26>=L$2,$E26<L$3),$E26,\"\")","v":""},{"$f":"IF(AND($E26>=M$2,$E26<=M$3),$E26,\"\")","v":""},{"$f":"IF(AND($F26>=K$2,$F26<K$3),$F26,\"\")","v":""},{"$f":"IF(AND($F26>=L$2,$F26<L$3),$F26,\"\")","v":""},{"$f":"IF(AND($F26>=M$2,$F26<=M$3),$F26,\"\")","v":""},{"$f":"IF(AND($G26>=K$2,$G26<K$3),$G26,\"\")","v":""},{"$f":"IF(AND($G26>=L$2,$G26<L$3),$G26,\"\")","v":""},{"$f":"IF(AND($G26>=M$2,$G26<=M$3),$G26,\"\")","v":""},{"$f":"IF(AND($H26>=K$2,$H26<K$3),$H26,\"\")","v":""},{"$f":"IF(AND($H26>=L$2,$H26<L$3),$H26,\"\")","v":""},{"$f":"IF(AND($H26>=M$2,$H26<=M$3),$H26,\"\")","v":""},{"$f":"IF(AND($I26>=K$2,$I26<K$3),$I26,\"\")","v":""},{"$f":"IF(AND($I26>=L$2,$I26<L$3),$I26,\"\")","v":""},{"$f":"IF(AND($I26>=M$2,$I26<=M$3),$I26,\"\")","v":""}]
[0,null,{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGE(Таблица1[[#This Row],[Математика]:[Физкультура]]))","v":""},{"$f":"IF(AND($J27>=K$2,$J27<K$3),$J27,\"\")","v":""},{"$f":"IF(AND($J27>=L$2,$J27<L$3),$J27,\"\")","v":""},{"$f":"IF(AND($J27>=M$2,$J27<=M$3),$J27,\"\")","v":""},{"$f":"IF(AND($C27>=K$2,$C27<K$3),$C27,\"\")","v":""},{"$f":"IF(AND($C27>=L$2,$C27<L$3),$C27,\"\")","v":""},{"$f":"IF(AND($C27>=M$2,$C27<=M$3),$C27,\"\")","v":""},{"$f":"IF(AND($D27>=K$2,$D27<K$3),$D27,\"\")","v":""},{"$f":"IF(AND($D27>=L$2,$D27<L$3),$D27,\"\")","v":""},{"$f":"IF(AND($D27>=M$2,$D27<=M$3),$D27,\"\")","v":""},{"$f":"IF(AND($E27>=K$2,$E27<K$3),$E27,\"\")","v":""},{"$f":"IF(AND($E27>=L$2,$E27<L$3),$E27,\"\")","v":""},{"$f":"IF(AND($E27>=M$2,$E27<=M$3),$E27,\"\")","v":""},{"$f":"IF(AND($F27>=K$2,$F27<K$3),$F27,\"\")","v":""},{"$f":"IF(AND($F27>=L$2,$F27<L$3),$F27,\"\")","v":""},{"$f":"IF(AND($F27>=M$2,$F27<=M$3),$F27,\"\")","v":""},{"$f":"IF(AND($G27>=K$2,$G27<K$3),$G27,\"\")","v":""},{"$f":"IF(AND($G27>=L$2,$G27<L$3),$G27,\"\")","v":""},{"$f":"IF(AND($G27>=M$2,$G27<=M$3),$G27,\"\")","v":""},{"$f":"IF(AND($H27>=K$2,$H27<K$3),$H27,\"\")","v":""},{"$f":"IF(AND($H27>=L$2,$H27<L$3),$H27,\"\")","v":""},{"$f":"IF(AND($H27>=M$2,$H27<=M$3),$H27,\"\")","v":""},{"$f":"IF(AND($I27>=K$2,$I27<K$3),$I27,\"\")","v":""},{"$f":"IF(AND($I27>=L$2,$I27<L$3),$I27,\"\")","v":""},{"$f":"IF(AND($I27>=M$2,$I27<=M$3),$I27,\"\")","v":""}]
[0,null,{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGEIF(#REF!,Таблица1[Столбец1],#REF!))","v":""},{"$f":"IF(Таблица1[Количество человек прошедших оценку]=0,\"\",AVERAGE(Таблица1[[#This Row],[Математика]:[Физкультура]]))","v":""},{"$f":"IF(AND($J28>=K$2,$J28<K$3),$J28,\"\")","v":""},{"$f":"IF(AND($J28>=L$2,$J28<L$3),$J28,\"\")","v":""},{"$f":"IF(AND($J28>=M$2,$J28<=M$3),$J28,\"\")","v":""},{"$f":"IF(AND($C28>=K$2,$C28<K$3),$C28,\"\")","v":""},{"$f":"IF(AND($C28>=L$2,$C28<L$3),$C28,\"\")","v":""},{"$f":"IF(AND($C28>=M$2,$C28<=M$3),$C28,\"\")","v":""},{"$f":"IF(AND($D28>=K$2,$D28<K$3),$D28,\"\")","v":""},{"$f":"IF(AND($D28>=L$2,$D28<L$3),$D28,\"\")","v":""},{"$f":"IF(AND($D28>=M$2,$D28<=M$3),$D28,\"\")","v":""},{"$f":"IF(AND($E28>=K$2,$E28<K$3),$E28,\"\")","v":""},{"$f":"IF(AND($E28>=L$2,$E28<L$3),$E28,\"\")","v":""},{"$f":"IF(AND($E28>=M$2,$E28<=M$3),$E28,\"\")","v":""},{"$f":"IF(AND($F28>=K$2,$F28<K$3),$F28,\"\")","v":""},{"$f":"IF(AND($F28>=L$2,$F28<L$3),$F28,\"\")","v":""},{"$f":"IF(AND($F28>=M$2,$F28<=M$3),$F28,\"\")","v":""},{"$f":"IF(AND($G28>=K$2,$G28<K$3),$G28,\"\")","v":""},{"$f":"IF(AND($G28>=L$2,$G28<L$3),$G28,\"\")","v":""},{"$f":"IF(AND($G28>=M$2,$G28<=M$3),$G28,\"\")","v":""},{"$f":"IF(AND($H28>=K$2,$H28<K$3),$H28,\"\")","v":""},{"$f":"IF(AND($H28>=L$2,$H28<L$3),$H28,\"\")","v":""},{"$f":"IF(AND($H28>=M$2,$H28<=M$3),$H28,\"\")","v":""},{"$f":"IF(AND($I28>=K$2,$I28<K$3),$I28,\"\")","v":""},{"$f":"IF(AND($I28>=L$2,$I28<L$3),$I28,\"\")","v":""},{"$f":"IF(AND($I28>=M$2,$I28<=M$3),$I28,\"\")","v":""}]
[{"$f":"\"Итого по \"&B2","v":"Итого по "},{"$f":"SUBTOTAL(109,Таблица1[Количество человек прошедших оценку])","v":202},{"$f":"SUMPRODUCT(Таблица1[Количество человек прошедших оценку],Таблица1[Математика])/Таблица1[[#Totals],[Количество человек прошедших оценку]]","v":3.395049504950495},{"$f":"SUMPRODUCT(Таблица1[Количество человек прошедших оценку],Таблица1[Русский])/Таблица1[[#Totals],[Количество человек прошедших оценку]]","v":3.8801980198019801},{"$f":"SUMPRODUCT(Таблица1[Количество человек прошедших оценку],Таблица1[Литература])/Таблица1[[#Totals],[Количество человек прошедших оценку]]","v":3.395049504950495},{"$f":"SUMPRODUCT(Таблица1[Количество человек прошедших оценку],Таблица1[Физика])/Таблица1[[#Totals],[Количество человек прошедших оценку]]","v":3.8801980198019801},{"$f":"SUMPRODUCT(Таблица1[Количество человек прошедших оценку],Таблица1[География])/Таблица1[[#Totals],[Количество человек прошедших оценку]]","v":3.8514851485148514},{"$f":"SUMPRODUCT(Таблица1[Количество человек прошедших оценку],Таблица1[Информатика])/Таблица1[[#Totals],[Количество человек прошедших оценку]]","v":3.395049504950495},{"$f":"SUMPRODUCT(Таблица1[Количество человек прошедших оценку],Таблица1[Физкультура])/Таблица1[[#Totals],[Количество человек прошедших оценку]]","v":3.9856435643564359},{"$f":"SUMPRODUCT(Таблица1[Количество человек прошедших оценку],Таблица1[Итого средняя оценка])/Таблица1[[#Totals],[Количество человек прошедших оценку]]","v":3.6832390381895328}]