{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Лист1","Лист2","Лист3","Лист4","Лист5"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"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":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Общий счетчик"]
[{"$f":"Лист2!A2+Лист3!A2+Лист4!A2+Лист5!A2","v":2},{"$f":"Лист2!B2+Лист3!B2+Лист4!B2+Лист5!B2","v":0},{"$f":"Лист2!C2+Лист3!C2+Лист4!C2+Лист5!C2","v":0},{"$f":"Лист2!D2+Лист3!D2+Лист4!D2+Лист5!D2","v":0},{"$f":"Лист2!E2+Лист3!E2+Лист4!E2+Лист5!E2","v":0},{"$f":"Лист2!F2+Лист3!F2+Лист4!F2+Лист5!F2","v":0},"А"]
[{"$f":"Лист2!A3+Лист3!A3+Лист4!A3+Лист5!A3","v":2},{"$f":"Лист2!B3+Лист3!B3+Лист4!B3+Лист5!B3","v":0},{"$f":"Лист2!C3+Лист3!C3+Лист4!C3+Лист5!C3","v":0},{"$f":"Лист2!D3+Лист3!D3+Лист4!D3+Лист5!D3","v":0},{"$f":"Лист2!E3+Лист3!E3+Лист4!E3+Лист5!E3","v":0},{"$f":"Лист2!F3+Лист3!F3+Лист4!F3+Лист5!F3","v":0},"Б"]
[{"$f":"Лист2!A4+Лист3!A4+Лист4!A4+Лист5!A4","v":2},{"$f":"Лист2!B4+Лист3!B4+Лист4!B4+Лист5!B4","v":0},{"$f":"Лист2!C4+Лист3!C4+Лист4!C4+Лист5!C4","v":0},{"$f":"Лист2!D4+Лист3!D4+Лист4!D4+Лист5!D4","v":0},{"$f":"Лист2!E4+Лист3!E4+Лист4!E4+Лист5!E4","v":0},{"$f":"Лист2!F4+Лист3!F4+Лист4!F4+Лист5!F4","v":0},"В"]
[]
[1,2,3,4,5,6]
[null,null,null,null,null,null,null,"В желтые ячейки вводятся цифровые или буквенные значения! (в данном примере буквенные А,Б,В)"]
[null,null,null,null,null,null,null,"Автоматическое копирование по листам есть."]
[]
[]
[]
[null,"=СУММПРОИЗВ(--(ПРОМЕЖУТОЧНЫЕ.ИТОГИ(3;ДВССЫЛ(\"A\"&СТРОКА(11:1048576))))*(A11:A1048576=\"А\"))"]
[null,"Вместо этой формулы массива требуется макрос, т.к всё тупит со страшной силой."]

{"sheet":"Лист2","index":1,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Счетчик"]
[{"$f":"SUMPRODUCT(--(SUBTOTAL(3,INDIRECT(\"A\"&ROW(11:1048576))))*(A11:A1048576=\"А\"))","v":2},null,null,null,null,null,"А"]
[{"$f":"SUMPRODUCT(--(SUBTOTAL(3,INDIRECT(\"A\"&ROW(11:1048576))))*(A11:A1048576=\"Б\"))","v":2},null,null,null,null,null,"Б"]
[{"$f":"SUMPRODUCT(--(SUBTOTAL(3,INDIRECT(\"A\"&ROW(11:1048576))))*(A11:A1048576=\"В\"))","v":2},null,null,null,null,null,"В"]
[]
[1,2,3,4,5,6]
[]
[]
[]
[1,2,3,4,5,6]
["А","А","Б","Б","В","В"]
["А","А","В","В","Б","Б"]
["Б","Б","А","А","В","В"]
["Б","Б","А","В","А","А"]
["В","Б","А","А","Б","Б"]
["В","В","Б","Б","А","Б"]

{"sheet":"Лист3","index":2,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Счетчик"]
[null,null,null,null,null,null,"А"]
[null,null,null,null,null,null,"Б"]
[null,null,null,null,null,null,"В"]
[]
[1,2,3,4,5,6]
[]
[]
[]
[1,2,3,4,5,6]
["А","А","Б","Б","В","В"]
["А","А","В","В","Б","Б"]
["Б","Б","А","А","В","В"]
["Б","Б","А","В","А","А"]
["В","Б","А","А","Б","Б"]
["В","В","Б","Б","А","Б"]

{"sheet":"Лист4","index":3,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Счетчик"]
[null,null,null,null,null,null,"А"]
[null,null,null,null,null,null,"Б"]
[null,null,null,null,null,null,"В"]
[]
[1,2,3,4,5,6]
[]
[]
[]
[1,2,3,4,5,6]
["А","А","Б","Б","В","В"]
["А","А","В","В","Б","Б"]
["Б","Б","А","А","В","В"]
["Б","Б","А","В","А","А"]
["В","Б","А","А","Б","Б"]
["В","В","Б","Б","А","Б"]

{"sheet":"Лист5","index":4,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Счетчик"]
[null,null,null,null,null,null,"А"]
[null,null,null,null,null,null,"Б"]
[null,null,null,null,null,null,"В"]
[]
[1,2,3,4,5,6]
[]
[]
[]
[1,2,3,4,5,6]
["А","А","Б","Б","В","В"]
["А","А","В","В","Б","Б"]
["Б","Б","А","А","В","В"]
["Б","Б","А","В","А","А"]
["В","Б","А","А","Б","Б"]
["В","В","Б","Б","А","Б"]