{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":15,"n_cols":71,"rows_kept":15,"cut":false,"hidden":false,"merged":[[3,54,3,58],[3,59,3,63],[3,64,3,68],[3,24,3,28],[3,29,3,33],[3,34,3,38],[3,39,3,43],[3,44,3,48],[3,49,3,53],[3,3,4,3],[3,4,3,8],[3,9,3,13],[3,14,3,18],[3,19,3,23]]}
[]
[null,null,null,"План-факт  20__год ",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,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(\"Bs\" & BS3+3)","v":"Май"}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[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,null,null,"Январь"]
[null,null,null,null,{"$f":"IF(E3<=$BS$5,\"ПП, тн.\",\"-\")","v":"ПП, тн."},{"$f":"IF(F3<=$BS$5,\"ПЗ, тн.\",\"-\")","v":"ПЗ, тн."},{"$f":"IF(G3<=$BS$5,\"Факт, тн.\",\"-\")","v":"Факт, тн."},{"$f":"IF(H3<=$BS$5,\"Откл. от ПП, тн.\",\"-\")","v":"Откл. от ПП, тн."},{"$f":"IF(I3<=$BS$5,\"Откл. от ПЗ, тн.\",\"-\")","v":"Откл. от ПЗ, тн."},{"$f":"IF(J3<=$BS$5,\"ПП, тн.\",\"-\")","v":"ПП, тн."},{"$f":"IF(K3<=$BS$5,\"ПЗ, тн.\",\"-\")","v":"ПЗ, тн."},{"$f":"IF(L3<=$BS$5,\"Факт, тн.\",\"-\")","v":"Факт, тн."},{"$f":"IF(M3<=$BS$5,\"Откл. от ПП, тн.\",\"-\")","v":"Откл. от ПП, тн."},{"$f":"IF(N3<=$BS$5,\"Откл. от ПЗ, тн.\",\"-\")","v":"Откл. от ПЗ, тн."},{"$f":"IF(O3<=$BS$5,\"ПП, тн.\",\"-\")","v":"ПП, тн."},{"$f":"IF(P3<=$BS$5,\"ПЗ, тн.\",\"-\")","v":"ПЗ, тн."},{"$f":"IF(Q3<=$BS$5,\"Факт, тн.\",\"-\")","v":"Факт, тн."},{"$f":"IF(R3<=$BS$5,\"Откл. от ПП, тн.\",\"-\")","v":"Откл. от ПП, тн."},{"$f":"IF(S3<=$BS$5,\"Откл. от ПЗ, тн.\",\"-\")","v":"Откл. от ПЗ, тн."},{"$f":"IF(T3<=$BS$5,\"ПП, тн.\",\"-\")","v":"ПП, тн."},{"$f":"IF(U3<=$BS$5,\"ПЗ, тн.\",\"-\")","v":"ПЗ, тн."},{"$f":"IF(V3<=$BS$5,\"Факт, тн.\",\"-\")","v":"Факт, тн."},{"$f":"IF(W3<=$BS$5,\"Откл. от ПП, тн.\",\"-\")","v":"Откл. от ПП, тн."},{"$f":"IF(X3<=$BS$5,\"Откл. от ПЗ, тн.\",\"-\")","v":"Откл. от ПЗ, тн."},{"$f":"IF(Y3<=$BS$5,\"ПП, тн.\",\"-\")","v":"ПП, тн."},{"$f":"IF(Z3<=$BS$5,\"ПЗ, тн.\",\"-\")","v":"ПЗ, тн."},{"$f":"IF(AA3<=$BS$5,\"Факт, тн.\",\"-\")","v":"Факт, тн."},{"$f":"IF(AB3<=$BS$5,\"Откл. от ПП, тн.\",\"-\")","v":"Откл. от ПП, тн."},{"$f":"IF(AC3<=$BS$5,\"Откл. от ПЗ, тн.\",\"-\")","v":"Откл. от ПЗ, тн."},{"$f":"IF(AD3<=$BS$5,\"ПП, тн.\",\"-\")","v":"ПП, тн."},{"$f":"IF(AE3<=$BS$5,\"ПЗ, тн.\",\"-\")","v":"ПЗ, тн."},{"$f":"IF(AF3<=$BS$5,\"Факт, тн.\",\"-\")","v":"Факт, тн."},{"$f":"IF(AG3<=$BS$5,\"Откл. от ПП, тн.\",\"-\")","v":"Откл. от ПП, тн."},{"$f":"IF(AH3<=$BS$5,\"Откл. от ПЗ, тн.\",\"-\")","v":"Откл. от ПЗ, тн."},{"$f":"IF(AI3<=$BS$5,\"ПП, тн.\",\"-\")","v":"ПП, тн."},{"$f":"IF(AJ3<=$BS$5,\"ПЗ, тн.\",\"-\")","v":"ПЗ, тн."},{"$f":"IF(AK3<=$BS$5,\"Факт, тн.\",\"-\")","v":"Факт, тн."},{"$f":"IF(AL3<=$BS$5,\"Откл. от ПП, тн.\",\"-\")","v":"Откл. от ПП, тн."},{"$f":"IF(AM3<=$BS$5,\"Откл. от ПЗ, тн.\",\"-\")","v":"Откл. от ПЗ, тн."},{"$f":"IF(AN3<=$BS$5,\"ПП, тн.\",\"-\")","v":"ПП, тн."},{"$f":"IF(AO3<=$BS$5,\"ПЗ, тн.\",\"-\")","v":"ПЗ, тн."},{"$f":"IF(AP3<=$BS$5,\"Факт, тн.\",\"-\")","v":"Факт, тн."},{"$f":"IF(AQ3<=$BS$5,\"Откл. от ПП, тн.\",\"-\")","v":"Откл. от ПП, тн."},{"$f":"IF(AR3<=$BS$5,\"Откл. от ПЗ, тн.\",\"-\")","v":"Откл. от ПЗ, тн."},{"$f":"IF(AS3<=$BS$5,\"ПП, тн.\",\"-\")","v":"ПП, тн."},{"$f":"IF(AT3<=$BS$5,\"ПЗ, тн.\",\"-\")","v":"ПЗ, тн."},{"$f":"IF(AU3<=$BS$5,\"Факт, тн.\",\"-\")","v":"Факт, тн."},{"$f":"IF(AV3<=$BS$5,\"Откл. от ПП, тн.\",\"-\")","v":"Откл. от ПП, тн."},{"$f":"IF(AW3<=$BS$5,\"Откл. от ПЗ, тн.\",\"-\")","v":"Откл. от ПЗ, тн."},{"$f":"IF(AX3<=$BS$5,\"ПП, тн.\",\"-\")","v":"ПП, тн."},{"$f":"IF(AY3<=$BS$5,\"ПЗ, тн.\",\"-\")","v":"ПЗ, тн."},{"$f":"IF(AZ3<=$BS$5,\"Факт, тн.\",\"-\")","v":"Факт, тн."},{"$f":"IF(BA3<=$BS$5,\"Откл. от ПП, тн.\",\"-\")","v":"Откл. от ПП, тн."},{"$f":"IF(BB3<=$BS$5,\"Откл. от ПЗ, тн.\",\"-\")","v":"Откл. от ПЗ, тн."},{"$f":"IF(BC3<=$BS$5,\"ПП, тн.\",\"-\")","v":"ПП, тн."},{"$f":"IF(BD3<=$BS$5,\"ПЗ, тн.\",\"-\")","v":"ПЗ, тн."},{"$f":"IF(BE3<=$BS$5,\"Факт, тн.\",\"-\")","v":"Факт, тн."},{"$f":"IF(BF3<=$BS$5,\"Откл. от ПП, тн.\",\"-\")","v":"Откл. от ПП, тн."},{"$f":"IF(BG3<=$BS$5,\"Откл. от ПЗ, тн.\",\"-\")","v":"Откл. от ПЗ, тн."},{"$f":"IF(BH3<=$BS$5,\"ПП, тн.\",\"-\")","v":"ПП, тн."},{"$f":"IF(BI3<=$BS$5,\"ПЗ, тн.\",\"-\")","v":"ПЗ, тн."},{"$f":"IF(BJ3<=$BS$5,\"Факт, тн.\",\"-\")","v":"Факт, тн."},{"$f":"IF(BK3<=$BS$5,\"Откл. от ПП, тн.\",\"-\")","v":"Откл. от ПП, тн."},{"$f":"IF(BL3<=$BS$5,\"Откл. от ПЗ, тн.\",\"-\")","v":"Откл. от ПЗ, тн."},"ПП, тн.","ПЗ, тн.","Факт, тн.","Откл. от ПП, тн.","Откл. от ПЗ, тн.",null,"Февраль"]
[null,null,null,null,"Столбец1","Столбец2","Столбец3","Столбец4","Столбец5","Столбец6","Столбец7","Столбец8","Столбец9","Столбец10","Столбец11","Столбец12","Столбец13","Столбец14","Столбец15","Столбец16","Столбец17","Столбец18","Столбец19","Столбец20","Столбец21","Столбец22","Столбец23","Столбец24","Столбец25","Столбец26","Столбец27","Столбец28","Столбец29","Столбец30","Столбец31","Столбец32","Столбец33","Столбец34","Столбец35","Столбец36","Столбец37","Столбец38","Столбец39","Столбец40","Столбец41","Столбец42","Столбец43","Столбец44","Столбец45","Столбец46","Столбец47","Столбец48","Столбец49","Столбец50","Столбец51","Столбец52","Столбец53","Столбец54","Столбец55","Столбец56","Столбец57","Столбец58","Столбец59","Столбец60","Столбец61","Столбец62","Столбец63","Столбец64","Столбец65",null,"Март"]
[null,null,null,"Общие показатели",200,0,null,{"$f":"G7-E7","v":-200},{"$f":"G7-F7","v":0},20770.361999999994,null,null,{"$f":"L7-J7","v":-20770.361999999994},{"$f":"L7-K7","v":0},31652.142400000012,null,null,{"$f":"Q7-O7","v":-31652.142400000012},{"$f":"Q7-P7","v":0},56124.806566406245,null,null,{"$f":"V7-T7","v":-56124.806566406245},{"$f":"V7-U7","v":0},67224,null,null,{"$f":"AA7-Y7","v":-67224},{"$f":"AA7-Z7","v":0},74725.7919921875,null,null,{"$f":"AF7-AD7","v":-74725.7919921875},{"$f":"AF7-AE7","v":0},77207.10546875,null,null,{"$f":"AK7-AI7","v":-77207.10546875},{"$f":"AK7-AJ7","v":0},1351.739990234375,null,null,{"$f":"AP7-AN7","v":-1351.739990234375},{"$f":"AP7-AO7","v":0},43467.734375,null,null,{"$f":"AU7-AS7","v":-43467.734375},{"$f":"AU7-AT7","v":0},83001.630859375,null,null,{"$f":"AZ7-AX7","v":-83001.630859375},{"$f":"AZ7-AY7","v":0},78754.8359375,null,null,{"$f":"BE7-BC7","v":-78754.8359375},{"$f":"BE7-BD7","v":0},77207.4990234375,null,null,{"$f":"BJ7-BH7","v":-77207.4990234375},{"$f":"BJ7-BI7","v":0},{"$f":"SUMIFS($E7:$BL7,$E$7:$BL$7,BM$7,$E$7:$BL$7,BM$7)","v":534480.14958945313},{"$f":"SUMIFS($E7:$BL7,$E$7:$BL$7,BN$7,$E$7:$BL$7,BN$7)","v":0},0,-534480.14958945313,0,null,"Апрель"]
[null,null,null,"показатель 1",0,0,null,{"$f":"G8-E8","v":0},{"$f":"G8-F8","v":0},20570.361999999994,null,null,{"$f":"L8-J8","v":-20570.361999999994},{"$f":"L8-K8","v":0},31652.142400000012,null,null,{"$f":"Q8-O8","v":-31652.142400000012},{"$f":"Q8-P8","v":0},56124.806566406245,null,null,{"$f":"V8-T8","v":-56124.806566406245},{"$f":"V8-U8","v":0},67224,null,null,{"$f":"AA8-Y8","v":-67224},{"$f":"AA8-Z8","v":0},61276,null,null,{"$f":"AF8-AD8","v":-61276},{"$f":"AF8-AE8","v":0},61873.44921875,null,null,{"$f":"AK8-AI8","v":-61873.44921875},{"$f":"AK8-AJ8","v":0},1351.739990234375,null,null,{"$f":"AP8-AN8","v":-1351.739990234375},{"$f":"AP8-AO8","v":0},38686.21484375,null,null,{"$f":"AU8-AS8","v":-38686.21484375},{"$f":"AU8-AT8","v":0},65199,null,null,{"$f":"AZ8-AX8","v":-65199},{"$f":"AZ8-AY8","v":0},61863,null,null,{"$f":"BE8-BC8","v":-61863},{"$f":"BE8-BD8","v":0},62261.81640625,null,null,{"$f":"BJ8-BH8","v":-62261.81640625},{"$f":"BJ8-BI8","v":0},{"$f":"SUMIFS($E8:$BL8,$E$7:$BL$7,BM$7,$E$7:$BL$7,BM$7)","v":465820.71501914063},0,0,-465820.71501914063,0,null,"Май"]
[null,null,null,"показатель 2",200,0,null,-200,0,200,null,null,-200,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,13449.7919921875,null,null,-13449.7919921875,0,15333.65625,null,null,-15333.65625,0,0,null,null,0,0,4781.51953125,null,null,-4781.51953125,0,17802.630859375,null,null,-17802.630859375,0,16891.8359375,null,null,-16891.8359375,0,14945.6826171875,null,null,-14945.6826171875,0,68659.4345703125,0,0,-68659.4345703125,0,null,"Июнь"]
[null,null,null,"показатель 3",0,0,null,0,0,15568,null,null,-15568,0,29060.9424,null,null,-29060.9424,0,53244.806566406245,null,null,-53244.806566406245,0,67224,null,null,-67224,0,74725.771574732149,null,null,-74725.771574732149,0,77207.085424261866,null,null,-77207.085424261866,0,887.86154502653153,null,null,-887.86154502653153,0,43275.39778614766,null,null,-43275.39778614766,0,83001.593663303414,null,null,-83001.593663303414,0,78754.800876355148,null,null,-78754.800876355148,0,77207.477997385431,null,null,-77207.477997385431,0,522950.25983623299,0,0,-522950.25983623299,0,null,"Июль"]
[null,null,null,"показатель 4",0,0,null,0,0,15568,null,0,-15568,0,29060.9424,null,null,-29060.9424,0,53244.806566406245,null,null,-53244.806566406245,0,67224,null,null,-67224,0,61276,null,null,-61276,0,61873.44921875,null,null,-61873.44921875,0,887.86154502653153,null,null,-887.86154502653153,0,38693.883826290956,null,null,-38693.883826290956,0,65199,null,null,-65199,0,61863,null,null,-61863,0,62261.81640625,null,null,-62261.81640625,0,454890.94355647371,0,0,-454890.94355647371,0,null,"Август"]
[null,null,null,"показатель 5",0,0,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,13449.771574732149,null,null,-13449.771574732149,0,15333.636205511866,null,null,-15333.636205511866,0,0,null,null,0,0,4581.5139598567039,null,null,-4581.5139598567039,0,17802.593663303414,null,null,-17802.593663303414,0,16891.800876355148,null,null,-16891.800876355148,0,14945.661591135431,null,null,-14945.661591135431,0,68059.316279759281,0,0,-68059.316279759281,0,null,"Сентябрь"]
[null,null,null,"показатель 6",0,0,null,0,0,0,null,null,0,0,0,null,null,0,0,12.070722472503462,null,null,-12.070722472503462,0,18.293331176398283,null,null,-18.293331176398283,0,9.7121487869169414,null,null,-9.7121487869169414,0,19.779634355386065,null,null,-19.779634355386065,0,0,null,null,0,0,7.8377454850544268,null,null,-7.8377454850544268,0,20.247536612146632,null,null,-20.247536612146632,0,19.594417734851277,null,null,-19.594417734851277,0,19.385248893340531,null,null,-19.385248893340531,0,107.53553662325709,0,0,-107.53553662325709,0,null,"Октябрь"]
[null,null,null,"Итого",0,0,null,0,0,15568,null,null,-15568,0,29060.9424,null,null,-29060.9424,0,53244.806566406245,null,null,-53244.806566406245,0,67224,null,null,-67224,0,74725.7919921875,null,null,-74725.7919921875,0,77207.10546875,null,null,-77207.10546875,0,1351.739990234375,null,null,-1351.739990234375,0,43467.734375,null,null,-43467.734375,0,83001.630859375,null,null,-83001.630859375,0,78754.8359375,null,null,-78754.8359375,0,77207.4990234375,null,null,-77207.4990234375,0,523606.58758945309,0,0,-523606.58758945309,0,null,"Ноябрь"]
[null,null,null,"* допсведения",0,0,null,0,0,28.34521146543203,null,null,-28.34521146543203,0,52.912291733860485,null,null,-52.912291733860485,0,183.70655227387925,null,null,-183.70655227387925,0,267.92963123321533,null,null,-267.92963123321533,0,282.91487693786621,null,null,-282.91487693786621,0,292.34610462188721,null,null,-292.34610462188721,0,79.211013615131378,null,null,-79.211013615131378,0,168.21480387449265,null,null,-168.21480387449265,0,283.47720909118652,null,null,-283.47720909118652,0,268.97433853149414,null,null,-268.97433853149414,0,292.34610462188721,null,null,-292.34610462188721,0,1908.0320333784452,0,0,-1908.0320333784452,0,null,"Декабрь"]