{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["pivot table"],"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":"pivot table","index":0,"n_rows":14,"n_cols":22,"rows_kept":14,"cut":false,"hidden":false,"merged":[[3,20,3,21]]}
["#","Год","Компания","Номер полиса","Регион","Лимит","Площадь",null,"Год","(Все)"]
[1,2014,"ООО 111","543e327355d8a","Cccc",5263.2,0.43859999999999999,null,"Компания","(Все)"]
[2,2014,"ООО 111","543e327355d8a","Cccc",11913.6,0.99280000000000002]
[3,2015,"ООО 111","543e32738bb7c","Cccc",8112,0.67600000000000005,null,"Регион","Номер полиса","Count of Номер полиса","Sum of Лимит","Sum of Площадь",null,null,null,null,null,null,null,"Формулы"]
[4,2014,"ООО 222","545cd9377b58b","Eeee",3499.9994999999999,0.5,null,"Cccc","543e327355d8a",2,17176.8,1.4314,null,"Названия строк","Количество по полю Номер полиса","Сумма по полю Sum of Лимит","Сумма по полю Sum of Площадь",null,null,"Список уникальных значений","Уникальные"]
[5,2014,"ООО 222","545cd9377b58b","Eeee",5599.9992000000002,0.8,null,"Cccc","543e32738bb7c",1,8112,0.67600000000000005,null,"Cccc",2,25288.799999999999,2.1074000000000002,null,null,{"$f":"IFERROR(INDEX($E$2:$E$16,MATCH(0,IF(ISBLANK($E$2:E16),\"\",COUNTIF($U$5:U5,$E$2:$E$16)),0)),\"\")","v":"Cccc"},{"$f":"IF(U6=\"\",IF(U5=\"\",\"\",Уникальные_по_критер($D$2:$D$34)),Уникальные_по_критер($D$2:$D$34,$E$2:$E$34,U6))","v":2}]
[6,2014,"ООО 222","545cd9377b58b","Eeee",4899.9993000000004,0.7,null,"Eeee","545cd9377b58b",3,13999.998,2,null,"Eeee",2,20599.998,3,null,null,{"$f":"IFERROR(INDEX($E$2:$E$16,MATCH(0,IF(ISBLANK($E$2:E17),\"\",COUNTIF($U$5:U6,$E$2:$E$16)),0)),\"\")","v":"Eeee"},{"$f":"IF(U7=\"\",IF(U6=\"\",\"\",Уникальные_по_критер($D$2:$D$34)),Уникальные_по_критер($D$2:$D$34,$E$2:$E$34,U7))","v":2}]
[7,2015,"ООО 111","5460f6723b963","Eeee",1650,0.25,null,"Eeee","5460f6723b963",3,6600,1,null,"Общий итог",4,45888.797999999995,5.1074000000000002,null,null,{"$f":"IFERROR(INDEX($E$2:$E$16,MATCH(0,IF(ISBLANK($E$2:E18),\"\",COUNTIF($U$5:U7,$E$2:$E$16)),0)),\"\")","v":""},{"$f":"IF(U8=\"\",IF(U7=\"\",\"\",Уникальные_по_критер($D$2:$D$34)),Уникальные_по_критер($D$2:$D$34,$E$2:$E$34,U8))","v":4}]
[8,2015,"ООО 111","5460f6723b963","Eeee",1650,0.25,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($E$2:$E$16,MATCH(0,IF(ISBLANK($E$2:E19),\"\",COUNTIF($U$5:U8,$E$2:$E$16)),0)),\"\")","v":""},{"$f":"IF(U9=\"\",IF(U8=\"\",\"\",Уникальные_по_критер($D$2:$D$34)),Уникальные_по_критер($D$2:$D$34,$E$2:$E$34,U9))","v":""}]
[9,2015,"ООО 111","5460f6723b963","Eeee",3300,0.5,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($E$2:$E$16,MATCH(0,IF(ISBLANK($E$2:E20),\"\",COUNTIF($U$5:U9,$E$2:$E$16)),0)),\"\")","v":""},{"$f":"IF(U10=\"\",IF(U9=\"\",\"\",Уникальные_по_критер($D$2:$D$34)),Уникальные_по_критер($D$2:$D$34,$E$2:$E$34,U10))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($E$2:$E$16,MATCH(0,IF(ISBLANK($E$2:E21),\"\",COUNTIF($U$5:U10,$E$2:$E$16)),0)),\"\")","v":""},{"$f":"IF(U11=\"\",IF(U10=\"\",\"\",Уникальные_по_критер($D$2:$D$34)),Уникальные_по_критер($D$2:$D$34,$E$2:$E$34,U11))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($E$2:$E$16,MATCH(0,IF(ISBLANK($E$2:E22),\"\",COUNTIF($U$5:U11,$E$2:$E$16)),0)),\"\")","v":""},{"$f":"IF(U12=\"\",IF(U11=\"\",\"\",Уникальные_по_критер($D$2:$D$34)),Уникальные_по_критер($D$2:$D$34,$E$2:$E$34,U12))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($E$2:$E$16,MATCH(0,IF(ISBLANK($E$2:E23),\"\",COUNTIF($U$5:U12,$E$2:$E$16)),0)),\"\")","v":""},{"$f":"IF(U13=\"\",IF(U12=\"\",\"\",Уникальные_по_критер($D$2:$D$34)),Уникальные_по_критер($D$2:$D$34,$E$2:$E$34,U13))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($E$2:$E$16,MATCH(0,IF(ISBLANK($E$2:E24),\"\",COUNTIF($U$5:U13,$E$2:$E$16)),0)),\"\")","v":""},{"$f":"IF(U14=\"\",IF(U13=\"\",\"\",Уникальные_по_критер($D$2:$D$34)),Уникальные_по_критер($D$2:$D$34,$E$2:$E$34,U14))","v":""}]