{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Индексы-дефляторы","SVOD"],"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":"Индексы-дефляторы","index":0,"n_rows":33,"n_cols":24,"rows_kept":33,"cut":false,"hidden":false,"merged":[[6,15,9,15],[6,11,9,14],[16,4,20,4],[5,6,5,9],[10,6,14,9],[15,6,20,9],[24,0,24,1],[6,4,9,4],[6,6,9,9],[11,4,14,4],[21,6,22,9]]}
[1.139,2002]
[1.103,2003]
[1.1519999999999999,2004]
[1.137,2005,null,null,2020,null,null,6918.9040259435569,2019,null,null,null,{"$f":"SUMPRODUCT($A$14*$A$18)","v":1.2275820000000002}]
[1.1220000000000001,2006,null,null,null,null,null,{"$f":"E7-G7","v":-4.6892483999999968},15746.172638198434,null,null,null,null,null,null,null,{"$f":"INDEX(A1:B23,MATCH(COUNTIFS(B1:B23,\"=>2015\",B1:B23,\"<=2019\"),B1:B23),1)","v":{"$error":"#N/A"}}]
[1.157,2007,null,null,"мой объект",null,"Объект-аналог"]
[1.194,2008,null,null,130.2569,null,134.9461484,null,null,null,null,{"$f":"G7/L12","v":4.1869732671424138E-2},null,null,null,68499.95,{"$f":"INDEX(A1:B23,SUMPRODUCT((B1:B23>=E4)*(B1:B23<=E17)),1)","v":1.139}]
[1.0496000000000001,2009,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(A14:A18)","v":1.4345399462631119}]
[1.0797000000000001,2010,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT((B1:B23>=E4)*(B1:B23<=E17),A1:A23)","v":0},null,{"$f":"IF(A1:A23>0,PRODUCT(--AND(--SUMPRODUCT((B1:B23>=E4)*(B1:B23<=E17),OFFSET(B1:B23,,-1)))))","v":0},{"$f":"PRODUCT(ROWS(SUMPRODUCT((B1:B23>=E4)*(B1:B23<=E17))))","v":1},{"$f":"SUMPRODUCT((B1:B23>=E4)*(B1:B23<=E17),A1:A23*A1:A23)","v":0},null,{"$f":"ROUND(G7,4)","v":134.9461}]
[1.0880000000000001,2011,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(B1:B23,\">=\"&$E$4,B1:B23,\"<=\"&$E$17)","v":0},null,{"$f":"PRODUCT(A1:A23)","v":6.4370899829704458},{"$f":"IF(A1:A23>0,PRODUCT(AND(COUNTIFS(B1:B23,\">=\"&$E$4,B1:B23,\"<=\"&$E$17),OFFSET(B1:B23,,-1))))","v":0}]
[1.0680000000000001,2012,null,null,"мощность",null,"мощность",null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(COUNTIFS(B1:B23,\">=\"&$E$4,B1:B23,\"<=\"&$E$17)-COLUMN())","v":-18},null,{"$f":"(A1:A23)*(A1:A23)","v":1.1406240000000001},null,{"$f":"IF(COUNTIFS(B1:B23,\">=\"&$E$4,B1:B23,\"<=\"&$E$17)>0,PRODUCT(INDEX((B1:B23>=E4)*(B1:B23<=E17),A1:A23)))","v":false}]
[1.06,2013,null,null,null,null,null,null,null,null,null,3223,null,null,null,null,null,{"$f":"CHOOSE(1,A1,A2,A3)","v":1.139},null,null,{"$f":"Ч","v":{"$error":"#NAME?"}}]
[1.05,2014]
[1.143,2015,null,null,null,null,null,null,null,null,null,1740.1,5,null,null,{"$f":"G7/1249","v":0.10804335340272217}]
[1.0629999999999999,2016,null,null,null,null,null,null,null,null,null,{"$f":"G7/L14","v":7.7550800758577093E-2},null,null,null,122.5,null,null,null,{"$f":"PRODUCT(IF(B1:B23>0,COUNTIFS(B1:B23,\">=\"&$E$4,B1:B23,\"<=\"&$E$17),A1:A23))","v":0},{"$f":"PRODUCT(COUNTIFS(B1:B23,\">=\"&$E$4,B1:B23,\"<=\"&$E$17),A1:A23)","v":0}]
[1.044,2017,null,null,"Год утверждения",null,2020,null,null,null,null,{"$f":"L15*1.073","v":8.321200921395322E-2},{"$f":"L15/1.093","v":7.0952242231086093E-2},null,null,{"$f":"G7/P15","v":1.1016012114285714},null,null,null,{"$f":"PRODUCT((B1:B23>=E4)*(B1:B23<=E17),OFFSET(B1:B23,,-1))","v":0},{"$f":"PRODUCT(1,A1:A23,(B1:B23>=E4)*(B1:B23<=E17))","v":0}]
[1.0529999999999999,2018,null,null,2019,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(A1:A23,SUMPRODUCT((B1:B23>=E4)*(B1:B23<=E17)))","v":0}]
[1.0740000000000001,2019,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(INDEX(A1:B23,COUNTIFS(B1:B23,\">=\"&$E$4,B1:B23,\"<=\"&$E$17),1))","v":6.4370899829704458}]
[1.036,2020,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(INDEX(A1:A23,(B1:B23>=E4)*(B1:B23<=E17),1))","v":6.4370899829704458}]
[1.0369999999999999,2021,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(IF((B1:B23>=E4)*(B1:B23<=E17),OFFSET($A$1,1,0,23,1),1))","v":1},null,null,null,{"$f":"PRODUCT(INDEX((B1:B23>=E4)*(B1:B23<=E17)*(A1:A23),(B1:B23>=E4)*(B1:B23<=E17),1))","v":0}]
[1.0369999999999999,2022,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(IF((B1:B23>=E4)*(B1:B23<=E17),A1:A23*OFFSET($A$1,1,0,23,1),1))","v":1},null,null,null,{"$f":"PRODUCT((B1:B23>=E4)*(B1:B23<=E17)*(A1:A23),A1:A23)","v":0}]
[1.038,2023,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(IF((B1:B23>=E4)*(B1:B23<=E17),A1:A23,OFFSET($A$1,1,0,23,1)),1)","v":0},null,null,null,{"$f":"PRODUCT(IF((B1:B23>=E4)*(B1:B23<=E17),A1:A23,1))","v":1},"УРАААА!!!!"]
[1.038,2024,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E17>E4,PRODUCT(IF((B1:B23>=E4)*(B1:B23<=E17),OFFSET(A1,1,0,23,1)),1))","v":false}]
[]
["Доведены письмом Минэкономразвития России от",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ЕСЛИ(E17>E4;M14*ПРОИЗВЕД(ЕСЛИ((B1:B23>=E4)*(B1:B23<=E17);СМЕЩ(A1;1;0;23;1));M14/ПРОИЗВЕД(ЕСЛИ((B1:B23>=E4)*(B1:B23<=E17);СМЕЩ(A23;-1;0;23;1)))))"]
[]
[null,null,null,null,null,null,null,null,null,null,"из 14 в 19",null,{"$f":"M14*A11*A12*A13","v":5.9434200000000006},null,null,{"$f":"IF(E17>E4,PRODUCT(IF((B1:B23>E4)*(B1:B23<=E17),A1:A23)),1)","v":1},null,{"$f":"IF(E17>E4,M14*PRODUCT(IF((B1:B23>E4)*(B1:B23<=E17),A1:A23)),M14/PRODUCT(IF((B1:B23<=E4)*(B1:B23>E17),A1:A23)))","v":4.8262548262548259}]
[]
[null,null,null,null,null,null,null,null,null,null,"из 19 в 14",null,{"$f":"M14/A18/A17/A16/A15/A14","v":3.4854379712636727},null,null,{"$f":"IF(E17>E4,PRODUCT(IF((B1:B23>E4)*(B1:B23<=E17),A1:A23)),PRODUCT(IF((B1:B23>=E4)*(B1:B23<E17),A1:A23)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E17>E4,M14*PRODUCT(IF((B1:B23>E4)*(B1:B23<=E17),A1:A23)),IF(E17<E4,M14/PRODUCT(IF((B1:B23<=E4)*(B1:B23>E17),A1:A23)),M14))","v":4.8262548262548259}]
[]
[null,null,null,null,12402.1,null,null,null,null,null,null,null,null,null,null,{"$f":"PRODUCT(IF((B1:B23>=E4)*(B1:B23<=E17),$A$1:$A$23),1)","v":1}]
[null,null,null,null,23824.7]

{"sheet":"SVOD","index":1,"n_rows":35,"n_cols":66,"rows_kept":35,"cut":false,"hidden":false,"merged":[[31,33,31,36],[31,37,31,40],[31,23,31,24],[31,25,31,26],[31,27,31,28],[31,29,31,30],[31,31,31,32],[31,15,31,16],[31,17,31,18],[31,19,31,20],[31,21,31,22],[31,57,31,60],[31,41,31,44],[31,45,31,48],[31,49,31,52],[31,53,31,56]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"СУММ(ИНДЕКС(BM34:DF34*($BM$32:$DF$32=$CP$23);;);ИНДЕКС(BM34:DF34;;ПОИСКПОЗ(CP23;BM32:DF32)+1))",null,null,null,null,null,null,null,null,null,null,null,"СУММ(ИНДЕКС(BM34:CD34*($BM$32:$CD$32=$CP$23);;);ИНДЕКС(BM34:CD34;;ПОИСКПОЗ(CP23;BM32:CD32)+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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ЕСЛИ(CP23<=2017;СУММ(ИНДЕКС(BM34:CD34*($BM$32:$CD$32=$CP$23);;);ИНДЕКС(BM34:CD34;;ПОИСКПОЗ(CP23;BM32:CD32)+1));СУММ(ИНДЕКС(CE34:DF34*($CE$32:$DF$32=$CP$23);;);ИНДЕКС(CE34:DF34;;ПОИСКПОЗ($CP$23;$CE$32:$DF$32)+1);ИНДЕКС(CE34:DF34;;ПОИСКПОЗ($CP$23;$CE$32:$DF$32)+2);ИНДЕКС(CE34:DF34;;ПОИСКПОЗ($CP$23;$CE$32:$DF$32)+3)))"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P34:BI34*(($P$33:$BI$33=$P$33)+($P$33:$BI$33=$Q$33))*($P$32:$BI$32=$AS$23)+($P$33:$BI$33=$Q$33)","v":0}]
[]
[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,2021,"год по выбору"]
[]
[]
[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,null,null,null,null,null,{"$f":"MATCH(1,(AH33:BI33=AK33)*(#REF!<>0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"формула вообще не работает","формула работает только пересчет в 2020 год"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(IF((P34:BI34*($AS$22>$P$32:$BI$32)*($P$33:$BI$33=$P$33))>0,ROUND((($P$33:$BI$33=$P$33)*($P$34:$BI$34))*PRODUCT(IF(('Индексы-дефляторы'!$B$1:$B$23)>INDEX($P$33:$BI$33=$P$33,,MATCH(('Индексы-дефляторы'!$B$1:$B$23)>P32:BI32,P32:BI32))*('Индексы-дефляторы'!$B$1:$B$23<=$AS$22),'Индексы-дефляторы'!$A$1:$A$23)),1)))","v":{"$error":"#N/A"}},{"$f":"(IF((P34:BI34*($AS$22>$P$32:$BI$32)*($P$33:$BI$33=$P$33))>0,ROUND((($P$33:$BI$33=$P$33)*($P$34:$BI$34))*(PRODUCT(IF(('Индексы-дефляторы'!$B$1:$B$23)>INDEX($P$32:$BI$32*($P$33:$BI$33=$P$33)*($P$34:$BI$34>0),,MATCH($P$32:$BI$32,$P$32:$BI$32))*('Индексы-дефляторы'!$B$1:$B$23<=$AS$22),'Индексы-дефляторы'!$A$1:$A$23))),1)))","v":297},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,{"$f":"IFERROR(INDEX($P34:$BI34*($P$33:$BI$33=$P$33:$Q$33),MATCH($AS$27,$M$34:$M$35),MATCH($AU$23,$P$32:$BI$32)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(ЕСЛИ((BM34:DF34*($CP$22>$BM$32:$DF$32)*($BM$33:$DF$33=$BM$33))>0;ОКРУГЛ((($BM$33:$DF$33=$BM$33)*($BM$34:$DF$34))*ПРОИЗВЕД(ЕСЛИ(('Индексы-дефляторы'!$B$1:$B$23)>ИНДЕКС($BM$33:$DF$33=$BM$33;;ПОИСКПОЗ(('Индексы-дефляторы'!$B$1:$B$23)>BM32:DF32;BM32:DF32))*('Индексы-дефляторы'!$B$1:$B$23<=$CP$22);'Индексы-дефляторы'!$A$1:$A$23));1)))","(ЕСЛИ((BM34:DF34*($CP$22>$BM$32:$DF$32)*($BM$33:$DF$33=$BM$33))>0;ОКРУГЛ((($BM$33:$DF$33=$BM$33)*($BM$34:$DF$34))*(ПРОИЗВЕД(ЕСЛИ(('Индексы-дефляторы'!$B$1:$B$23)>ИНДЕКС($BM$32:$DF$32*($BM$33:$DF$33=$BM$33)*($BM$34:$DF$34>0);;ПОИСКПОЗ($BM$32:$DF$32;$BM$32:$DF$32))*('Индексы-дефляторы'!$B$1:$B$23<=$CP$22);'Индексы-дефляторы'!$A$1:$A$23)));1)))",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(($AH$33:$BI$33=$AK$33)*(#REF!),,)","v":{"$error":"#REF!"}}]
[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,null,null,null,null,{"$f":"INDEX(#REF!,,MATCH(AK33,AH33:BI33))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"правильная сумма пересчета из 2009 в 2021",null,null,null,"правильная сумма пересчета из 2011 в 2021",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,null,null,null,2020]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(IF($AS$22>$P32,ROUND($P34*PRODUCT(IF(('Индексы-дефляторы'!$B$1:$B$23>$P32)*('Индексы-дефляторы'!$B$1:$B$23<=$AS$22),'Индексы-дефляторы'!$A$1:$A$23)),1)))","v":265.8},null,{"$f":"(IF($AS$22>$R32,ROUND($R34*PRODUCT(IF(('Индексы-дефляторы'!$B$1:$B$23>$R32)*('Индексы-дефляторы'!$B$1:$B$23<=$AS$22),'Индексы-дефляторы'!$A$1:$A$23)),1)))","v":0},null,{"$f":"(IF($AS$22>$T32,ROUND($T34*PRODUCT(IF(('Индексы-дефляторы'!$B$1:$B$23>$T32)*('Индексы-дефляторы'!$B$1:$B$23<=$AS$22),'Индексы-дефляторы'!$A$1:$A$23)),1)))","v":123108.2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2009,null,2010,null,2011,null,2012,null,2013,null,2014,null,2015,null,2016,null,2017,null,2018,null,null,null,2019,null,null,null,2020,null,null,null,2021,null,null,null,2022,null,null,null,2023,null,null,null,2024]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ПИР","СМР","ПИР","СМР","ПИР","СМР","ПИР","СМР","ПИР","СМР","ПИР","СМР","ПИР","СМР","ПИР","СМР","ПИР","СМР","ПИР","СМР","Восстановлены с 2017","Сданы\nв ФБ","ПИР","СМР","Восстановлены с 2018","Сданы\nв ФБ","ПИР","СМР","Восстановлены с 2019","Сданы\nв ФБ","ПИР","СМР","Восстановлены с 2020","Сданы\nв ФБ","ПИР","СМР","Восстановлены с 2021","Сданы\nв ФБ","ПИР","СМР","Восстановлены с 2022","Сданы\nв ФБ","ПИР","СМР","Восстановлены с 2023","Сданы\nв ФБ",null,null,{"$f":"SUMIFS(#REF!,$P$33:$BI$33,$Q$33)+SUMIFS(#REF!,$P$33:$BI$33,$P$33)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,123.5,65,null,null,67200,null,null,38400,null,100000,null,80725.7,null,655000,null,null,null,null,null,null,null,null,null,null,null,null,7740.6,null,null,null,null,138159.9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(IF($AS$22>$P32,ROUND($P34*PRODUCT(IF(('Индексы-дефляторы'!$B$1:$B$23>$P32)*('Индексы-дефляторы'!$B$1:$B$23<=$AS$22),'Индексы-дефляторы'!$A$1:$A$23)),1)))","v":265.8},null,null,{"$f":"IFERROR(SMALL(IF(($AH$33:$BI$33=$AK$33)*(AH34:BI34)<>0,OFFSET($AH$32:$BI$32,,-3)),1),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,2,2,null,12,null,null,null,null,null,null,null,null,null,null,null,16000,null,null,null,null,null,null,null,null,null,13924.1,null,null,null,null,169063.8,null,null,null,178075.39999999997,null,null,null,66697.300000000017,null,null,null,0,null,null,null,0,null,null,null,null,null,null,{"$f":"IFERROR(SMALL(IF(($AH$33:$BI$33=$AK$33)*(AH35:BI35)<>0,OFFSET($AH$32:$BI$32,,-3)),1),\"\")","v":""}]