{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["СВОДНАЯ","СВОДНАЯ (2)","без форматирования таблицы"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":2},"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":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Количество по полю Для сводной сцепка"]
["Для сводной сцепка","Итог",null,null,null,"win11 2 2 k11, k12",null,null,null,"Названия строк","n_clients","n_urls","svs_codes"]
["(пусто)",null,null,null,null,"win10 1 1 k13",null,null,null,"win11",16,2,"k11, k12"]
["win12 1 1 k13",1,null,null,null,"AntiMW 3 2 k49,k50",null,null,null,"win10",7,1,"k13"]
["win11 34 2 k11, k12",34,null,null,null,null,null,null,null,"AntiMW",24,2,"k49, k50"]
["win10 16 1 k13",16,null,null,null,null,null,null,null,"win12",1,1,"k13"]
["AntiMW 48 2 k49, k50",48]
["Общий итог",99]

{"sheet":"СВОДНАЯ (2)","index":1,"n_rows":59,"n_cols":13,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Количество по полю Для сводной сцепка"]
["Для сводной сцепка","Клиент","Итог",null,null,null,null,null,null,"Названия строк","n_clients","n_urls","svs_codes"]
["(пусто)","(пусто)",null,null,null,null,null,null,null,"win11",16,2,"k11, k12"]
["(пусто) Итог",null,null,null,null,null,null,null,null,"win10",7,1,"k13"]
["win12 1 1 k13","Иванов9",1,null,null,null,null,null,null,"AntiMW",24,2,"k49, k50"]
["win12 1 1 k13 Итог",null,1,null,null,null,null,null,null,"win12",1,1,"k13"]
["win11 34 2 k11, k12","Иванов",10]
[null,"Иванов1",1]
[null,"Иванов10",1]
[null,"Иванов11",1]
[null,"Иванов13",1]
[null,"Иванов14",1]
[null,"Иванов16",1]
[null,"Иванов17",1]
[null,"Иванов19",1]
[null,"Иванов2",1]
[null,"Иванов20",1]
[null,"Иванов4",1]
[null,"Иванов5",1]
[null,"Иванов7",1]
[null,"Иванов8",1]
[null,"Петров",10]
["win11 34 2 k11, k12 Итог",null,34]
["win10 16 1 k13","Иванов12",1,1]
[null,"Иванов15",1,2]
[null,"Иванов18",1,3]
[null,"Иванов21",1,4]
[null,"Иванов3",1,5]
[null,"Иванов6",1,6]
[null,"Петров",10,7]
["win10 16 1 k13 Итог",null,16]
["AntiMW 48 2 k49, k50","Иванов1",1]
[null,"Иванов10",1]
[null,"Иванов11",1]
[null,"Иванов12",1]
[null,"Иванов13",1]
[null,"Иванов14",1]
[null,"Иванов15",1]
[null,"Иванов16",1]
[null,"Иванов17",1]
[null,"Иванов18",1]
[null,"Иванов19",1]
[null,"Иванов2",1]
[null,"Иванов20",1]
[null,"Иванов21",1]
[null,"Иванов3",1]
[null,"Иванов4",1]
[null,"Иванов5",1]
[null,"Иванов6",1]
[null,"Иванов7",1]
[null,"Иванов8",1]
[null,"Иванов9",1]
[null,"Котов",9]
[null,"Петров",9]
[null,"Сидоров",9]
["AntiMW 48 2 k49, k50 Итог",null,48]
["Общий итог",null,99]

{"sheet":"без форматирования таблицы","index":2,"n_rows":100,"n_cols":12,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
["Клиент","Софт","Производитель","Код услуги","Урл на софт","Для сводной сцепка",null,null,null,null,null,"По примеру из вложения:"]
["Иванов1","win11","Microsoft","k11","урл1",{"$f":"CONCATENATE(B2,\" \",COUNTIF(B:B,B2),\" \",LEN(сцепитьЕсли2(B:B,B2,D:D,\", \",1))-LEN(SUBSTITUTE(сцепитьЕсли2(B:B,B2,D:D,\"; \",1),\"k\",)),\" \",сцепитьЕсли2(B:B,B2,D:D,\", \",1))","v":"win11 34 2 k11, k12"},null,null,null,null,null,"Необходимо сделать выборку для каждого уникального \"Софта\"."]
["Иванов2","win11","Microsoft","k12","урл2","win11 34 2 k11, k12",null,null,null,null,null,"Подсчитать кол-во клиентов для которых он установлен + кол-во уникальных урлов"]
["Иванов3","win10","Microsoft","k13","урл1","win10 16 1 k13",null,null,null,null,null,"и отдельно сматчить коды услуг в строчку, что бы на выходе получилось что-то типа:"]
["Иванов4","AntiMW","Kasper","k49","урл10","AntiMW 48 2 k49, k50",null,null,null,null,null,"win11 2 2 k11, k12"]
["Иванов5","AntiMW","Kasper","k50","урл10","AntiMW 48 2 k49, k50",null,null,null,null,null,"win10 1 1 k13"]
["Иванов6","AntiMW","Kasper","k49","урл50","AntiMW 48 2 k49, k50",null,null,null,null,null,"AntiMW 3 2 k49,k50"]
["Иванов7","win11","Microsoft","k11","урл1","win11 34 2 k11, k12",null,null,null,null,null,"и т.д."]
["Иванов8","win11","Microsoft","k12","урл2","win11 34 2 k11, k12"]
["Иванов9","win12","Microsoft","k13","урл1","win12 1 1 k13"]
["Иванов10","AntiMW","Kasper","k49","урл10","AntiMW 48 2 k49, k50"]
["Иванов11","AntiMW","Kasper","k50","урл10","AntiMW 48 2 k49, k50"]
["Иванов12","AntiMW","Kasper","k49","урл50","AntiMW 48 2 k49, k50"]
["Иванов13","win11","Microsoft","k11","урл1","win11 34 2 k11, k12"]
["Иванов14","win11","Microsoft","k12","урл2","win11 34 2 k11, k12"]
["Иванов15","win10","Microsoft","k13","урл1","win10 16 1 k13"]
["Иванов16","AntiMW","Kasper","k49","урл10","AntiMW 48 2 k49, k50"]
["Иванов17","AntiMW","Kasper","k50","урл10","AntiMW 48 2 k49, k50"]
["Иванов18","AntiMW","Kasper","k49","урл50","AntiMW 48 2 k49, k50"]
["Иванов19","win11","Microsoft","k11","урл1","win11 34 2 k11, k12"]
["Иванов20","win11","Microsoft","k12","урл2","win11 34 2 k11, k12"]
["Иванов21","win10","Microsoft","k13","урл1","win10 16 1 k13"]
["Иванов1","AntiMW","Kasper","k49","урл10","AntiMW 48 2 k49, k50"]
["Иванов2","AntiMW","Kasper","k50","урл10","AntiMW 48 2 k49, k50"]
["Иванов3","AntiMW","Kasper","k49","урл50","AntiMW 48 2 k49, k50"]
["Иванов4","win11","Microsoft","k11","урл1","win11 34 2 k11, k12"]
["Иванов5","win11","Microsoft","k12","урл2","win11 34 2 k11, k12"]
["Иванов6","win10","Microsoft","k13","урл1","win10 16 1 k13"]
["Иванов7","AntiMW","Kasper","k49","урл10","AntiMW 48 2 k49, k50"]
["Иванов8","AntiMW","Kasper","k50","урл10","AntiMW 48 2 k49, k50"]
["Иванов9","AntiMW","Kasper","k49","урл50","AntiMW 48 2 k49, k50"]
["Иванов10","win11","Microsoft","k11","урл1","win11 34 2 k11, k12"]
["Иванов11","win11","Microsoft","k12","урл2","win11 34 2 k11, k12"]
["Иванов12","win10","Microsoft","k13","урл1","win10 16 1 k13"]
["Иванов13","AntiMW","Kasper","k49","урл10","AntiMW 48 2 k49, k50"]
["Иванов14","AntiMW","Kasper","k50","урл10","AntiMW 48 2 k49, k50"]
["Иванов15","AntiMW","Kasper","k49","урл50","AntiMW 48 2 k49, k50"]
["Иванов16","win11","Microsoft","k11","урл1","win11 34 2 k11, k12"]
["Иванов17","win11","Microsoft","k12","урл2","win11 34 2 k11, k12"]
["Иванов18","win10","Microsoft","k13","урл1","win10 16 1 k13"]
["Иванов19","AntiMW","Kasper","k49","урл10","AntiMW 48 2 k49, k50"]
["Иванов20","AntiMW","Kasper","k50","урл10","AntiMW 48 2 k49, k50"]
["Иванов21","AntiMW","Kasper","k49","урл50","AntiMW 48 2 k49, k50"]
["Иванов","win11","Microsoft","k11","урл1","win11 34 2 k11, k12"]
["Петров","win11","Microsoft","k12","урл2","win11 34 2 k11, k12"]
["Петров","win10","Microsoft","k13","урл1","win10 16 1 k13"]
["Сидоров","AntiMW","Kasper","k49","урл10","AntiMW 48 2 k49, k50"]
["Котов","AntiMW","Kasper","k50","урл10","AntiMW 48 2 k49, k50"]
["Петров","AntiMW","Kasper","k49","урл50","AntiMW 48 2 k49, k50"]
["Иванов","win11","Microsoft","k11","урл1","win11 34 2 k11, k12"]
["Петров","win11","Microsoft","k12","урл2","win11 34 2 k11, k12"]
["Петров","win10","Microsoft","k13","урл1","win10 16 1 k13"]
["Сидоров","AntiMW","Kasper","k49","урл10","AntiMW 48 2 k49, k50"]
["Котов","AntiMW","Kasper","k50","урл10","AntiMW 48 2 k49, k50"]
["Петров","AntiMW","Kasper","k49","урл50","AntiMW 48 2 k49, k50"]
["Иванов","win11","Microsoft","k11","урл1","win11 34 2 k11, k12"]
["Петров","win11","Microsoft","k12","урл2","win11 34 2 k11, k12"]
["Петров","win10","Microsoft","k13","урл1","win10 16 1 k13"]
["Сидоров","AntiMW","Kasper","k49","урл10","AntiMW 48 2 k49, k50"]
["Котов","AntiMW","Kasper","k50","урл10","AntiMW 48 2 k49, k50"]
["Петров","AntiMW","Kasper","k49","урл50","AntiMW 48 2 k49, k50"]
["Иванов","win11","Microsoft","k11","урл1","win11 34 2 k11, k12"]
["Петров","win11","Microsoft","k12","урл2","win11 34 2 k11, k12"]
["Петров","win10","Microsoft","k13","урл1","win10 16 1 k13"]
["Сидоров","AntiMW","Kasper","k49","урл10","AntiMW 48 2 k49, k50"]
["Котов","AntiMW","Kasper","k50","урл10","AntiMW 48 2 k49, k50"]
["Петров","AntiMW","Kasper","k49","урл50","AntiMW 48 2 k49, k50"]
["Иванов","win11","Microsoft","k11","урл1","win11 34 2 k11, k12"]
["Петров","win11","Microsoft","k12","урл2","win11 34 2 k11, k12"]
["Петров","win10","Microsoft","k13","урл1","win10 16 1 k13"]
["Сидоров","AntiMW","Kasper","k49","урл10","AntiMW 48 2 k49, k50"]
["Котов","AntiMW","Kasper","k50","урл10","AntiMW 48 2 k49, k50"]
["Петров","AntiMW","Kasper","k49","урл50","AntiMW 48 2 k49, k50"]
["Иванов","win11","Microsoft","k11","урл1","win11 34 2 k11, k12"]
["Петров","win11","Microsoft","k12","урл2","win11 34 2 k11, k12"]
["Петров","win10","Microsoft","k13","урл1","win10 16 1 k13"]
["Сидоров","AntiMW","Kasper","k49","урл10","AntiMW 48 2 k49, k50"]
["Котов","AntiMW","Kasper","k50","урл10","AntiMW 48 2 k49, k50"]
["Петров","AntiMW","Kasper","k49","урл50","AntiMW 48 2 k49, k50"]
["Иванов","win11","Microsoft","k11","урл1","win11 34 2 k11, k12"]
["Петров","win11","Microsoft","k12","урл2","win11 34 2 k11, k12"]
["Петров","win10","Microsoft","k13","урл1","win10 16 1 k13"]
["Сидоров","AntiMW","Kasper","k49","урл10","AntiMW 48 2 k49, k50"]
["Котов","AntiMW","Kasper","k50","урл10","AntiMW 48 2 k49, k50"]
["Петров","AntiMW","Kasper","k49","урл50","AntiMW 48 2 k49, k50"]
["Иванов","win11","Microsoft","k11","урл1","win11 34 2 k11, k12"]
["Петров","win11","Microsoft","k12","урл2","win11 34 2 k11, k12"]
["Петров","win10","Microsoft","k13","урл1","win10 16 1 k13"]
["Сидоров","AntiMW","Kasper","k49","урл10","AntiMW 48 2 k49, k50"]
["Котов","AntiMW","Kasper","k50","урл10","AntiMW 48 2 k49, k50"]
["Петров","AntiMW","Kasper","k49","урл50","AntiMW 48 2 k49, k50"]
["Иванов","win11","Microsoft","k11","урл1","win11 34 2 k11, k12"]
["Петров","win11","Microsoft","k12","урл2","win11 34 2 k11, k12"]
["Петров","win10","Microsoft","k13","урл1","win10 16 1 k13"]
["Сидоров","AntiMW","Kasper","k49","урл10","AntiMW 48 2 k49, k50"]
["Котов","AntiMW","Kasper","k50","урл10","AntiMW 48 2 k49, k50"]
["Петров","AntiMW","Kasper","k49","урл50","AntiMW 48 2 k49, k50"]
["Иванов","win11","Microsoft","k11","урл1","win11 34 2 k11, k12"]
["Петров","win11","Microsoft","k12","урл2","win11 34 2 k11, k12"]
["Петров","win10","Microsoft","k13","урл1","win10 16 1 k13"]