{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Свод","по_годам","Начальный"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":16,"n_cols":15,"rows_kept":16,"cut":false,"hidden":false,"merged":[[13,2,13,3],[14,2,14,3],[15,2,15,3],[2,0,2,1],[0,0,0,1],[1,0,1,1],[8,2,8,3],[9,2,9,3],[10,2,10,3]]}
[null,null,2020,{"$f":"C1+1","v":2021},{"$f":"D1+1","v":2022},2023,2024,2025,2026,2027,2028,2029,2030]
["Нач. запасы по годам средние",null,{"$f":"Middle_Year((SUBTOTAL(9,OFFSET(по_годам!$B$1,ROW(по_годам!$B$2:$B$19)-1,))),C$1,Начальный!$B2:$B19,Начальный!$C2:$C19,Начальный!$D2:$D19)","v":157.5},{"$f":"Middle_Year((SUBTOTAL(9,OFFSET(по_годам!$B$1,ROW(по_годам!$B$2:$B$19)-1,))),D$1,Начальный!$B2:$B19,Начальный!$C2:$C19,Начальный!$D2:$D19)","v":0},{"$f":"Middle_Year((SUBTOTAL(9,OFFSET(по_годам!$B$1,ROW(по_годам!$B$2:$B$19)-1,))),E$1,Начальный!$B2:$B19,Начальный!$C2:$C19,Начальный!$D2:$D19)","v":0},{"$f":"Middle_Year((SUBTOTAL(9,OFFSET(по_годам!$B$1,ROW(по_годам!$B$2:$B$19)-1,))),F$1,Начальный!$B2:$B19,Начальный!$C2:$C19,Начальный!$D2:$D19)","v":0},{"$f":"Middle_Year((SUBTOTAL(9,OFFSET(по_годам!$B$1,ROW(по_годам!$B$2:$B$19)-1,))),G$1,Начальный!$B2:$B19,Начальный!$C2:$C19,Начальный!$D2:$D19)","v":0},{"$f":"Middle_Year((SUBTOTAL(9,OFFSET(по_годам!$B$1,ROW(по_годам!$B$2:$B$19)-1,))),H$1,Начальный!$B2:$B19,Начальный!$C2:$C19,Начальный!$D2:$D19)","v":0},{"$f":"Middle_Year((SUBTOTAL(9,OFFSET(по_годам!$B$1,ROW(по_годам!$B$2:$B$19)-1,))),I$1,Начальный!$B2:$B19,Начальный!$C2:$C19,Начальный!$D2:$D19)","v":0},{"$f":"Middle_Year((SUBTOTAL(9,OFFSET(по_годам!$B$1,ROW(по_годам!$B$2:$B$19)-1,))),J$1,Начальный!$B2:$B19,Начальный!$C2:$C19,Начальный!$D2:$D19)","v":0},{"$f":"Middle_Year((SUBTOTAL(9,OFFSET(по_годам!$B$1,ROW(по_годам!$B$2:$B$19)-1,))),K$1,Начальный!$B2:$B19,Начальный!$C2:$C19,Начальный!$D2:$D19)","v":0},{"$f":"Middle_Year((SUBTOTAL(9,OFFSET(по_годам!$B$1,ROW(по_годам!$B$2:$B$19)-1,))),L$1,Начальный!$B2:$B19,Начальный!$C2:$C19,Начальный!$D2:$D19)","v":0},{"$f":"Middle_Year((SUBTOTAL(9,OFFSET(по_годам!$B$1,ROW(по_годам!$B$2:$B$19)-1,))),M$1,Начальный!$B2:$B19,Начальный!$C2:$C19,Начальный!$D2:$D19)","v":0},"<---","Нужна формула"]
["Производство:",null,{"$f":"SUMPRODUCT(SUBTOTAL(9,OFFSET(по_годам!C$1,ROW(по_годам!C$2:C$19)-1,)))","v":719},{"$f":"SUMPRODUCT(SUBTOTAL(9,OFFSET(по_годам!D$1,ROW(по_годам!D$2:D$19)-1,)))","v":911},{"$f":"SUMPRODUCT(SUBTOTAL(9,OFFSET(по_годам!E$1,ROW(по_годам!E$2:E$19)-1,)))","v":770},{"$f":"SUMPRODUCT(SUBTOTAL(9,OFFSET(по_годам!F$1,ROW(по_годам!F$2:F$19)-1,)))","v":828},{"$f":"SUMPRODUCT(SUBTOTAL(9,OFFSET(по_годам!G$1,ROW(по_годам!G$2:G$19)-1,)))","v":847},{"$f":"SUMPRODUCT(SUBTOTAL(9,OFFSET(по_годам!H$1,ROW(по_годам!H$2:H$19)-1,)))","v":748},{"$f":"SUMPRODUCT(SUBTOTAL(9,OFFSET(по_годам!I$1,ROW(по_годам!I$2:I$19)-1,)))","v":874},{"$f":"SUMPRODUCT(SUBTOTAL(9,OFFSET(по_годам!J$1,ROW(по_годам!J$2:J$19)-1,)))","v":931},{"$f":"SUMPRODUCT(SUBTOTAL(9,OFFSET(по_годам!K$1,ROW(по_годам!K$2:K$19)-1,)))","v":740},{"$f":"SUMPRODUCT(SUBTOTAL(9,OFFSET(по_годам!L$1,ROW(по_годам!L$2:L$19)-1,)))","v":802},{"$f":"SUMPRODUCT(SUBTOTAL(9,OFFSET(по_годам!M$1,ROW(по_годам!M$2:M$19)-1,)))","v":782}]
[]
[]
[]
[]
[]
["Как должно быть:",null,null,null,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
["Фильт не стоит",null,"Нач. запасы по годам средние",null,464.14285710000001,775.5,997.5,1552.5,1941]
[null,null,"Производство:",null,6870,7327,7102,7291,7346,7040,6928,7489,7343,7224,6779]
[]
[]
[null,null,null,null,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
["Как должно быть:",null,"Нач. запасы по годам средние",null,244.5,null,null,1441.5]
["Фильт на листе по годам \nпервый столбец = 5",null,"Производство:",null,2158,2665,2349,2457,2347,2539,2393,2751,2344,2416,2284]

{"sheet":"по_годам","index":1,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Пок-ть","Уник",2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[5,2111,365,469,416,403,348,306,433,477,387,495,316]
[5,2112,354,442,354,425,499,442,441,454,353,307,466]
[5,2113,326,479,416,357,394,429,338,487,444,338,412]
[5,2114,396,430,300,482,457,488,409,447,358,354,345]
[6,2115,411,376,392,354,390,405,390,484,372,489,300]
[6,2116,347,315,368,424,485,313,464,339,322,401,398]
[6,2117,419,415,491,416,437,347,474,324,342,303,381]
[7,2118,339,418,408,403,343,459,335,463,403,348,314]
[7,2119,478,324,326,474,390,311,340,489,335,307,318]
[7,2120,399,485,478,370,447,438,328,300,452,493,300]
[8,2121,455,414,369,426,485,395,415,415,472,479,401]
[9,2122,427,335,382,425,379,386,333,440,482,339,493]
[5,2123,338,384,458,366,304,417,407,388,421,493,407]
[5,2124,379,461,405,424,345,457,365,498,381,429,338]
[7,2125,311,400,378,427,373,340,378,426,396,458,301]
[7,2126,347,416,386,346,375,361,368,333,496,477,399]
[8,2127,386,378,439,377,426,369,399,322,468,333,498]
[8,2128,393,386,336,392,469,377,311,403,459,381,392]

{"sheet":"Начальный","index":2,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Пок-ть","Уник","ГОД Запуска","Кол-во, шт."]
[5,2111,2020,150]
[5,2112,2020,165]
[5,2113,2020,276]
[5,2114,2020,387]
[6,2115,2020,498]
[6,2116,2020,609]
[7,2120,2022,1053]
[5,2124,2023,1497]
[7,2125,2023,1608]
[7,2126,2023,1719]
[8,2127,2023,1830]
[8,2128,2024,1941]
[8,2121,2020,1164]
[9,2122,2023,1275]
[5,2123,2023,1386]
[6,2117,2021,720]
[7,2118,2021,831]
[7,2119,2022,942]