{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":30,"n_cols":22,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["2018-09-01","№ пр. семьи","ФИО приемного родителя","район","Дата начала","№ договор","Всего детей","ФИО Приемного ребенка","Возр. на тек.мес.","Д/Р","преобр к 01 числу","преобр Д/Р - скрыть","Начало ФУ","3 года","10 лет","18 лет","Окончание ФУ","Инвалид-ность до","20 лет","Школьник до","23 года","Студент до"]
[null,2,"В НАДЕЖДА ИВАНОВНА","ильин.","2007-09-15",null,null,"Л АНЖЕЛИКА АНДРЕЕВНА","10 г. 1 м.","2008-08-02","2008-08-01","2008-08-31",null,"2011-08-02","2018-08-02","2026-08-02",null,null,"2028-08-02",null,"2031-08-02"]
[null,354,"Е АЙМАНГУЛЬ БОРИСОВНА","кузн.","2015-06-01",null,null,"А НАДЕЖДА ИСЛОМОВНА","13 г. 0 м.","2005-09-04","2005-09-01","2005-09-30",null,"2008-09-04","2015-09-04","2023-09-04",null,null,"2025-09-04",null,"2028-09-04"]
[null,231,"У АЛИНА СЕРГЕЕВНА","кузн.","2014-05-01",null,1,"Н АЛЕКСАНДРА ИГОРЕВНА","10 г. 2 м.","2008-07-31","2008-07-01","2008-07-31",null,"2011-07-31","2018-07-31","2026-07-31",null,null,"2028-07-31",null,"2031-07-31"]
[null,231,"У АЛИНА СЕРГЕЕВНА","кузн.","2014-05-01",null,2,"Л АНАСТАСИЯ ИГОРЕВНА","3 г. 0 м.","2015-09-29","2015-09-01","2015-09-30",null,"2018-09-29","2025-09-29","2033-09-29",null,null,"2035-09-29",null,"2038-09-29"]
[null,253,"АГАПОВА ТАТЬЯНА ЕВГЕНЬЕВНА","кузн.","2014-08-01",null,null,"С ДАНИИЛ ЕВГЕНЬЕВИЧ","1 г. 2 м.","2017-07-31","2017-07-01","2017-07-31",null,"2020-07-31","2027-07-31","2035-07-31",null,null,"2037-07-31",null,"2040-07-31"]
[null,184,"А ТАМАРА АЛЕКСАНДРОВНА","куйб.","2013-08-01",null,4,"Т ЕВГЕНИЯ ВЛАДИМИРОВНА","18 г. 1 м.","2000-08-02","2000-08-01","2000-08-31",null,"2003-08-02","2010-08-02","2018-08-02",null,null,"2020-08-02",null,"2023-08-02","2023-08-02"]
[null,184,"И ТАМАРА АЛЕКСАНДРОВНА","куйб.","2013-08-01",null,3,"Ш ВИКТОР СЕРГЕЕВИЧ","12 г. 2 м.","2006-07-12","2006-07-01","2006-07-31",null,"2009-07-12","2016-07-12","2024-07-12",null,null,"2026-07-12",null,"2029-07-12"]
[null,3,"Ш ЕВГЕНИЙ ВИТАЛЬЕВИЧ","куйб.","2008-02-01",null,null,"В ИЛЬЯ ПАВЛОВИЧ","8 г. 2 м.","2010-07-27","2010-07-01","2010-07-31",null,"2013-07-27","2020-07-27","2028-07-27",null,null,"2030-07-27",null,"2033-07-27"]
[null,231,"А  АЛИНА СЕРГЕЕВНА","ордж.","2014-05-01",null,3,"Н АРТЕМ ИГОРЕВИЧ","18 г. 3 м.","2000-06-03","2000-06-01","2000-06-30",null,"2003-06-03","2010-06-03","2018-06-03",null,null,"2020-06-03","2021-04-30","2023-06-03"]
[null,1,"Ф РОЗА ИВАНОВНА","ордж.","2007-07-01",null,null,"Т ЗАРИНА АНВАРОВНА","10 г. 0 м.","2008-09-03","2008-09-01","2008-09-30",null,"2011-09-03","2018-09-03","2026-09-03",null,null,"2028-09-03",null,"2031-09-03"]
[null,184,"И ТАМАРА АЛЕКСАНДРОВНА","центр.","2013-08-01",null,2,"И ЕВГЕНИЙ МАКСИМОВИЧ","11 г. 6 м.","2007-03-01","2007-03-01","2007-03-31",null,"2010-03-01","2017-03-01","2025-03-01",null,null,"2027-03-01",null,"2030-03-01"]
[null,"Итог",{"$f":"SUMPRODUCT(1/COUNTIF([ФИО приемного родителя],[ФИО приемного родителя]))","v":9},null,null,null,null,{"$f":"COUNTA([ФИО Приемного ребенка])","v":11},null,null,null,null,null,"2","1","6",null,{"$f":"COUNTA([Инвалид-ность до])","v":0},"1",null,"1"]
[null,null,"всего родителей",null,null,null,null,"всего детей",null,null,null,null,null,"<=3",">3 и <10",">=10 и <=18",null,"инвалиды","школьники",null,"студенты"]
[]
[null,{"$f":"Таблица1[[#Totals],[3 года]]","v":"2"},"<=3 года",{"$f":"Таблица1[[#Totals],[3 года]]+Таблица1[[#Totals],[10 лет]]+Таблица1[[#Totals],[18 лет]]","v":9},null,null,null,"расчет для одной строки Ctrl+ф"]
[null,{"$f":"Таблица1[[#Totals],[10 лет]]","v":"1"},">3 лет и  <10 лет"]
[null,{"$f":"Таблица1[[#Totals],[18 лет]]","v":"6"},">=10 лет и  <=18 лет"]
[null,{"$f":"Таблица1[[#Totals],[ФИО Приемного ребенка]]","v":11},"всего детей"]
[null,{"$f":"Таблица1[[#Totals],[20 лет]]","v":"1"},"школьники    >18 лет",{"$f":"Таблица1[[#Totals],[20 лет]]+Таблица1[[#Totals],[23 года]]","v":2}]
[null,{"$f":"Таблица1[[#Totals],[23 года]]","v":"1"},"студенты    >18 лет"]
[null,{"$f":"Таблица1[[#Totals],[Инвалид-ность до]]","v":0},"инвалиды"]
[null,{"$f":"Таблица1[[#Totals],[ФИО приемного родителя]]","v":9},"всего родителей"]
[]
[null,{"$f":"COUNTIF(Таблица1[район],\"центр.\")","v":1},"центр."]
[null,{"$f":"COUNTIF(Таблица1[район],\"куйб.\")","v":3},"куйб."]
[null,{"$f":"COUNTIF(Таблица1[район],\"кузн.\")","v":4},"кузн."]
[null,{"$f":"COUNTIF(Таблица1[район],\"завод.\")","v":0},"завод."]
[null,{"$f":"COUNTIF(Таблица1[район],\"ильин.\")","v":1},"ильин."]
[null,{"$f":"COUNTIF(Таблица1[район],\"ордж.\")","v":2},"ордж."]