{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Премьер-лига","Шахматка"],"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":"Премьер-лига","index":0,"n_rows":22,"n_cols":29,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,25,1,28]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Премьер-лига"]
[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,8,9,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,19,2,0,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,18,0,3,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,10,2,3,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,19,1,2,12]
[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,6,7,13]
[null,null,"Ливерпуль",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,0,1,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,5,1,1,14]
[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,1,2,15]
[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,3,1,17]
[null,null,"Ньюкасл Юнайтед"]
[null,null,"Сандерленд",null,"Перенести данные из массива AA3:AB12 в ячейки, соответствующие паре команд, на лист \"Шахматка\"."]
[null,null,"Саутгемптон",null,"Примечание- массив не всегда будет заполнен полностью, то есть требуется обеспечить перенос только тех ячеек массива которые будут заполнены."]
[null,null,"Сток Сити",null,null,"пример"]
[null,null,"Суонси"]
[null,null,"Тоттенхэм",null,"http://www.excelworld.ru/forum/10-12389-1"]
[null,null,"Фулхэм"]
[null,null,"Халл Сити"]
[null,null,"Челси"]
[null,null,"Эвертон"]

{"sheet":"Шахматка","index":1,"n_rows":53,"n_cols":40,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,0,4],[0,5,0,6],[0,7,0,8],[0,9,0,10],[0,21,0,22],[0,11,0,12],[0,13,0,14],[0,15,0,16],[0,17,0,18],[0,19,0,20],[0,23,0,24],[0,37,0,38],[0,39,0,40],[0,33,0,34],[0,35,0,36],[0,25,0,26],[0,27,0,28],[0,29,0,30],[0,31,0,32]]}
[{"$f":"(SUM(B34:B53)+SUM(G34:G53))/20","v":0},{"$f":"A2","v":"Арсенал"},null,{"$f":"A3","v":"Астон Вилла"},null,{"$f":"A4","v":"Вест Бромвич"},null,{"$f":"A5","v":"Вест Хэм"},null,{"$f":"A6","v":"Кардифф"},null,{"$f":"A7","v":"Кристал Пэлас"},null,{"$f":"A8","v":"Ливерпуль"},null,{"$f":"A9","v":"Манчестер Сити"},null,{"$f":"A10","v":"Манчестер Юнайтед"},null,{"$f":"A11","v":"Норвич"},null,{"$f":"A12","v":"Ньюкасл Юнайтед"},null,{"$f":"A13","v":"Сандерленд"},null,{"$f":"A14","v":"Саутгемптон"},null,{"$f":"A15","v":"Сток Сити"},null,{"$f":"A16","v":"Суонси"},null,{"$f":"A17","v":"Тоттенхэм"},null,{"$f":"A18","v":"Фулхэм"},null,{"$f":"A19","v":"Халл Сити"},null,{"$f":"A20","v":"Челси"},null,{"$f":"A21","v":"Эвертон"}]
["Арсенал"]
["Астон Вилла"]
["Вест Бромвич"]
["Вест Хэм"]
["Кардифф"]
["Кристал Пэлас"]
["Ливерпуль"]
["Манчестер Сити"]
["Манчестер Юнайтед"]
["Норвич"]
["Ньюкасл Юнайтед"]
["Сандерленд"]
["Саутгемптон"]
["Сток Сити"]
["Суонси"]
["Тоттенхэм"]
["Фулхэм"]
["Халл Сити"]
["Челси"]
["Эвертон"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"COUNTA(B2:AO2)/2","v":0},{"$f":"SUMPRODUCT(B2:AO2*ISEVEN(COLUMN(B2:AO2)))","v":0},{"$f":"SUMPRODUCT(B2:AO2*ISODD(COLUMN(B2:AO2)))","v":0},{"$f":"SUMPRODUCT(ISNUMBER(B2:AN2)*((B2:AN2>C2:AO2)*3+(B2:AN2=C2:AO2))*ISEVEN(COLUMN(B2:AN2)))","v":0},null,{"$f":"COUNTA(B2:B21)","v":0},{"$f":"SUMPRODUCT(B2:C21*ISODD(COLUMN(B2:C21)))","v":0},{"$f":"SUMPRODUCT(B2:C21*ISEVEN(COLUMN(B2:C21)))","v":0},{"$f":"SUMPRODUCT(ISNUMBER(C2:C21)*((C2:C21>B2:B21)*3+(C2:C21=B2:B21))*ISODD(COLUMN(C2:C21)))","v":0}]
[null,0,0,0,0,null,{"$f":"COUNTA(D2:D21)","v":0},{"$f":"SUMPRODUCT(D2:E21*ISODD(COLUMN(D2:E21)))","v":0},{"$f":"SUMPRODUCT(D2:E21*ISEVEN(COLUMN(D2:E21)))","v":0},{"$f":"SUMPRODUCT(ISNUMBER(E2:E21)*((E2:E21>D2:D21)*3+(E2:E21=D2:D21))*ISODD(COLUMN(E2:E21)))","v":0}]
[null,0,0,0,0,null,{"$f":"COUNTA(F2:F21)","v":0},{"$f":"SUMPRODUCT(F2:G21*ISODD(COLUMN(F2:G21)))","v":0},{"$f":"SUMPRODUCT(F2:G21*ISEVEN(COLUMN(F2:G21)))","v":0},{"$f":"SUMPRODUCT(ISNUMBER(G2:G21)*((G2:G21>F2:F21)*3+(G2:G21=F2:F21))*ISODD(COLUMN(G2:G21)))","v":0}]
[null,0,0,0,0,null,{"$f":"COUNTA(H2:H21)","v":0},{"$f":"SUMPRODUCT(H2:I21*ISODD(COLUMN(H2:I21)))","v":0},{"$f":"SUMPRODUCT(H2:I21*ISEVEN(COLUMN(H2:I21)))","v":0},{"$f":"SUMPRODUCT(ISNUMBER(I2:I21)*((I2:I21>H2:H21)*3+(I2:I21=H2:H21))*ISODD(COLUMN(I2:I21)))","v":0}]
[null,0,0,0,0,null,{"$f":"COUNTA(J2:J21)","v":0},{"$f":"SUMPRODUCT(J2:K21*ISODD(COLUMN(J2:K21)))","v":0},{"$f":"SUMPRODUCT(J2:K21*ISEVEN(COLUMN(J2:K21)))","v":0},{"$f":"SUMPRODUCT(ISNUMBER(K2:K21)*((K2:K21>J2:J21)*3+(K2:K21=J2:J21))*ISODD(COLUMN(K2:K21)))","v":0}]
[null,0,0,0,0,null,{"$f":"COUNTA(L2:L21)","v":0},{"$f":"SUMPRODUCT(L2:M21*ISODD(COLUMN(L2:M21)))","v":0},{"$f":"SUMPRODUCT(L2:M21*ISEVEN(COLUMN(L2:M21)))","v":0},{"$f":"SUMPRODUCT(ISNUMBER(M2:M21)*((M2:M21>L2:L21)*3+(M2:M21=L2:L21))*ISODD(COLUMN(M2:M21)))","v":0}]
[null,0,0,0,0,null,{"$f":"COUNTA(N2:N21)","v":0},{"$f":"SUMPRODUCT(N2:O21*ISODD(COLUMN(N2:O21)))","v":0},{"$f":"SUMPRODUCT(N2:O21*ISEVEN(COLUMN(N2:O21)))","v":0},{"$f":"SUMPRODUCT(ISNUMBER(O2:O21)*((O2:O21>N2:N21)*3+(O2:O21=N2:N21))*ISODD(COLUMN(O2:O21)))","v":0}]
[null,0,0,0,0,null,{"$f":"COUNTA(P2:P21)","v":0},{"$f":"SUMPRODUCT(P2:Q21*ISODD(COLUMN(P2:Q21)))","v":0},{"$f":"SUMPRODUCT(P2:Q21*ISEVEN(COLUMN(P2:Q21)))","v":0},{"$f":"SUMPRODUCT(ISNUMBER(Q2:Q21)*((Q2:Q21>P2:P21)*3+(Q2:Q21=P2:P21))*ISODD(COLUMN(Q2:Q21)))","v":0}]
[null,0,0,0,0,null,{"$f":"COUNTA(R2:R21)","v":0},{"$f":"SUMPRODUCT(R2:S21*ISODD(COLUMN(R2:S21)))","v":0},{"$f":"SUMPRODUCT(R2:S21*ISEVEN(COLUMN(R2:S21)))","v":0},{"$f":"SUMPRODUCT(ISNUMBER(S2:S21)*((S2:S21>R2:R21)*3+(S2:S21=R2:R21))*ISODD(COLUMN(S2:S21)))","v":0}]
[null,0,0,0,0,null,{"$f":"COUNTA(T2:T21)","v":0},{"$f":"SUMPRODUCT(T2:U21*ISODD(COLUMN(T2:U21)))","v":0},{"$f":"SUMPRODUCT(T2:U21*ISEVEN(COLUMN(T2:U21)))","v":0},{"$f":"SUMPRODUCT(ISNUMBER(U2:U21)*((U2:U21>T2:T21)*3+(U2:U21=T2:T21))*ISODD(COLUMN(U2:U21)))","v":0}]
[null,0,0,0,0,null,{"$f":"COUNTA(V2:V21)","v":0},{"$f":"SUMPRODUCT(V2:W21*ISODD(COLUMN(V2:W21)))","v":0},{"$f":"SUMPRODUCT(V2:W21*ISEVEN(COLUMN(V2:W21)))","v":0},{"$f":"SUMPRODUCT(ISNUMBER(W2:W21)*((W2:W21>V2:V21)*3+(W2:W21=V2:V21))*ISODD(COLUMN(W2:W21)))","v":0}]
[null,0,0,0,0,null,{"$f":"COUNTA(X2:X21)","v":0},{"$f":"SUMPRODUCT(X2:Y21*ISODD(COLUMN(X2:Y21)))","v":0},{"$f":"SUMPRODUCT(X2:Y21*ISEVEN(COLUMN(X2:Y21)))","v":0},{"$f":"SUMPRODUCT(ISNUMBER(Y2:Y21)*((Y2:Y21>X2:X21)*3+(Y2:Y21=X2:X21))*ISODD(COLUMN(Y2:Y21)))","v":0}]
[null,0,0,0,0,null,{"$f":"COUNTA(Z2:Z21)","v":0},{"$f":"SUMPRODUCT(Z2:AA21*ISODD(COLUMN(Z2:AA21)))","v":0},{"$f":"SUMPRODUCT(Z2:AA21*ISEVEN(COLUMN(Z2:AA21)))","v":0},{"$f":"SUMPRODUCT(ISNUMBER(AA2:AA21)*((AA2:AA21>Z2:Z21)*3+(AA2:AA21=Z2:Z21))*ISODD(COLUMN(AA2:AA21)))","v":0}]
[null,0,0,0,0,null,{"$f":"COUNTA(AB2:AB21)","v":0},{"$f":"SUMPRODUCT(AB2:AC21*ISODD(COLUMN(AB2:AC21)))","v":0},{"$f":"SUMPRODUCT(AB2:AC21*ISEVEN(COLUMN(AB2:AC21)))","v":0},{"$f":"SUMPRODUCT(ISNUMBER(AC2:AC21)*((AC2:AC21>AB2:AB21)*3+(AC2:AC21=AB2:AB21))*ISODD(COLUMN(AC2:AC21)))","v":0}]
[null,0,0,0,0,null,{"$f":"COUNTA(AD2:AD21)","v":0},{"$f":"SUMPRODUCT(AD2:AE21*ISODD(COLUMN(AD2:AE21)))","v":0},{"$f":"SUMPRODUCT(AD2:AE21*ISEVEN(COLUMN(AD2:AE21)))","v":0},{"$f":"SUMPRODUCT(ISNUMBER(AE2:AE21)*((AE2:AE21>AD2:AD21)*3+(AE2:AE21=AD2:AD21))*ISODD(COLUMN(AE2:AE21)))","v":0}]
[null,0,0,0,0,null,{"$f":"COUNTA(AF2:AF21)","v":0},{"$f":"SUMPRODUCT(AF2:AG21*ISODD(COLUMN(AF2:AG21)))","v":0},{"$f":"SUMPRODUCT(AF2:AG21*ISEVEN(COLUMN(AF2:AG21)))","v":0},{"$f":"SUMPRODUCT(ISNUMBER(AG2:AG21)*((AG2:AG21>AF2:AF21)*3+(AG2:AG21=AF2:AF21))*ISODD(COLUMN(AG2:AG21)))","v":0}]
[null,0,0,0,0,null,{"$f":"COUNTA(AH2:AH21)","v":0},{"$f":"SUMPRODUCT(AH2:AI21*ISODD(COLUMN(AH2:AI21)))","v":0},{"$f":"SUMPRODUCT(AH2:AI21*ISEVEN(COLUMN(AH2:AI21)))","v":0},{"$f":"SUMPRODUCT(ISNUMBER(AI2:AI21)*((AI2:AI21>AH2:AH21)*3+(AI2:AI21=AH2:AH21))*ISODD(COLUMN(AI2:AI21)))","v":0}]
[null,0,0,0,0,null,{"$f":"COUNTA(AJ2:AJ21)","v":0},{"$f":"SUMPRODUCT(AJ2:AK21*ISODD(COLUMN(AJ2:AK21)))","v":0},{"$f":"SUMPRODUCT(AJ2:AK21*ISEVEN(COLUMN(AJ2:AK21)))","v":0},{"$f":"SUMPRODUCT(ISNUMBER(AK2:AK21)*((AK2:AK21>AJ2:AJ21)*3+(AK2:AK21=AJ2:AJ21))*ISODD(COLUMN(AK2:AK21)))","v":0}]
[null,0,0,0,0,null,{"$f":"COUNTA(AL2:AL21)","v":0},{"$f":"SUMPRODUCT(AL2:AM21*ISODD(COLUMN(AL2:AM21)))","v":0},{"$f":"SUMPRODUCT(AL2:AM21*ISEVEN(COLUMN(AL2:AM21)))","v":0},{"$f":"SUMPRODUCT(ISNUMBER(AM2:AM21)*((AM2:AM21>AL2:AL21)*3+(AM2:AM21=AL2:AL21))*ISODD(COLUMN(AM2:AM21)))","v":0}]
[null,0,0,0,0,null,{"$f":"COUNTA(AN2:AN21)","v":0},{"$f":"SUMPRODUCT(AN2:AO21*ISODD(COLUMN(AN2:AO21)))","v":0},{"$f":"SUMPRODUCT(AN2:AO21*ISEVEN(COLUMN(AN2:AO21)))","v":0},{"$f":"SUMPRODUCT(ISNUMBER(AO2:AO21)*((AO2:AO21>AN2:AN21)*3+(AO2:AO21=AN2:AN21))*ISODD(COLUMN(AO2:AO21)))","v":0}]