{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Мониторинг"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":26,"n_cols":28,"rows_kept":26,"cut":false,"hidden":false,"merged":[[7,3,8,3],[7,4,7,5],[7,8,7,9],[7,10,8,10],[7,11,7,12],[7,7,8,7],[25,0,25,1],[6,0,8,0],[6,1,8,1],[2,3,2,6],[2,7,2,12],[6,10,6,12],[6,3,6,5],[6,6,8,6],[24,0,24,1],[21,0,21,27],[6,27,8,27],[7,24,8,24],[7,25,7,26],[6,2,8,2],[7,17,8,17],[7,18,7,19],[6,7,6,9],[2,14,2,19],[2,21,2,26],[3,3,3,6],[4,3,4,6],[4,7,4,12],[4,14,4,19],[4,21,4,26],[3,7,3,12],[3,14,3,19],[3,21,3,26],[6,13,8,13],[7,15,7,16],[7,21,8,21],[7,22,7,23],[6,24,6,26],[6,21,6,23],[6,14,6,16],[6,17,6,19],[6,20,8,20],[7,14,8,14]]}
[null,null,null,{"$f":"\"Мониторинг за \"&D7&\" \"&LEFT(E8,4)&\" года\"","v":"Мониторинг за I квартал 2018 года"},null,null,null,{"$f":"\"Мониторинг за \"&K7&\" \"&LEFT(L8,4)&\" года\"","v":"Мониторинг за 1 полугодие 2018 года"},null,null,null,null,null,null,{"$f":"\"Мониторинг карты \"&R7&\" \"&LEFT(S8,4)&\" года\"","v":"Мониторинг карты 9 месяцев 2018 года"},null,null,null,null,null,null,{"$f":"\"Мониторинг за \"&LEFT(Z8,4)&\" год\"","v":"Мониторинг за 2018 год"},null,null,null,null,null," I квартал"]
[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," I полугодие"]
[null,"ФИО работника:",null,"Фамилия И.О.",null,null,null,{"$f":"$D3","v":"Фамилия И.О."},null,null,null,null,null,null,{"$f":"$D3","v":"Фамилия И.О."},null,null,null,null,null,null,{"$f":"$D3","v":"Фамилия И.О."},null,null,null,null,null," 9 месяцев"]
[null,"Должность:",null,"Должность 1",null,null,null,{"$f":"$D4","v":"Должность 1"},null,null,null,null,null,null,{"$f":"$D4","v":"Должность 1"},null,null,null,null,null,null,{"$f":"$D4","v":"Должность 1"},null,null,null,null,null," год"]
[null,"Подразделение:",null,"Подразделение 1",null,null,null,{"$f":"$D5","v":"Подразделение 1"},null,null,null,null,null,null,{"$f":"$D5","v":"Подразделение 1"},null,null,null,null,null,null,{"$f":"$D5","v":"Подразделение 1"}]
[]
["№\nп.п.","КПЭ ","Единица измерения","I квартал",null,null,"Примечание\n(причины отклонения от плана)","II квартал",null,null,"1 полугодие",null,null,"Примечание\n(причины отклонения от плана)","III квартал",null,null,"9 месяцев",null,null,"Примечание\n(причины отклонения от плана)","IV квартал",null,null,"ГОД",null,null,"Примечание\n(причины отклонения от плана)"]
[null,null,null,"2017г.\n(факт)","2018г.",null,null,{"$f":"$D$8","v":"2017г.\n(факт)"},{"$f":"$E$8","v":"2018г."},null,{"$f":"$D$8","v":"2017г.\n(факт)"},{"$f":"$E$8","v":"2018г."},null,null,{"$f":"$D$8","v":"2017г.\n(факт)"},{"$f":"$E$8","v":"2018г."},null,{"$f":"$D$8","v":"2017г.\n(факт)"},{"$f":"$E$8","v":"2018г."},null,null,{"$f":"$D$8","v":"2017г.\n(факт)"},{"$f":"$E$8","v":"2018г."},null,{"$f":"$D$8","v":"2017г.\n(факт)"},{"$f":"$E$8","v":"2018г."}]
[null,null,null,null,"план","факт",null,null,"план","факт",null,"план","факт",null,null,"план","факт",null,"план","факт",null,null,"план","факт",null,"план","факт"]
[null,null,null,null," I квартал",null,null,null,null,null,null," I полугодие",null,null,null,null,null,null," 9 месяцев",null,null,null,null,null,null," год"]
[1,"Показатель 1",{"$f":"IFERROR(INDEX(#REF!,MATCH($A11,#REF!,0),1),\"-\")","v":"-"},51.849505676077669,51.378183496649669,69.217843599999995,null,43.668144361068755,{"$f":"52.3435308209615+500","v":552.34353082096152},null,95.517650037146424,103.72171431761112,null,null,55.470032115379368,57.5,102.4,150.98768215252579,161.16820709612989,259.60000000000002,null,62.376317847474212,56.486897223949136,null,213.364,217.7]
[2,"Показатель 2",{"$f":"IFERROR(INDEX(#REF!,MATCH($A12,#REF!,0),1),\"-\")","v":"-"},"-","-","-",null,"-","-","-",null,null,null,null,null,"-","-",null,1,0.65,null,null,null,null,"-",100]
[3,"Показатель 3",{"$f":"IFERROR(INDEX(#REF!,MATCH($A13,#REF!,0),1),\"-\")","v":"-"},"-","-","-",7,"-","-","-","-","-","-",null,null,"-","-",null,8,7.92,null,null,null,null,"-",8]
[8,{"$f":"IFERROR(INDEX(#REF!,MATCH($A14,#REF!,0),1),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(#REF!,MATCH($A14,#REF!,0),1),\"-\")","v":"-"},"-","-","-",null,"-","-","-","-","-","-",null,"-","-","-","-","-","-",null,"-","-","-","-","да"]
[{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),ROW(A5))),\"\")","v":""},{"$f":"IFERROR(INDEX(#REF!,MATCH($A15,#REF!,0),1),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(#REF!,MATCH($A15,#REF!,0),1),\"-\")","v":"-"},"-","-","-",null,"-","-","-","-",8,null,null,"-",8,8.33,"-",8,8,null,"-",8,null,"-",8]
[{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),ROW(A6))),\"\")","v":""},{"$f":"IFERROR(INDEX(#REF!,MATCH($A16,#REF!,0),1),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(#REF!,MATCH($A16,#REF!,0),1),\"-\")","v":"-"},"-","-","-",null,"-","-","-","-","-","-",null,"-","-","-","-","-","-",null,"-","-","-","-",8]
[{"$f":"IFERROR(INDEX(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),ROW(A7))),\"\")","v":""},{"$f":"IFERROR(INDEX(#REF!,MATCH($A17,#REF!,0),1),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(#REF!,MATCH($A17,#REF!,0),1),\"-\")","v":"-"},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(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),ROW(A8))),\"\")","v":""},{"$f":"IFERROR(INDEX(#REF!,MATCH($A18,#REF!,0),1),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(#REF!,MATCH($A18,#REF!,0),1),\"-\")","v":"-"},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(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),ROW(A9))),\"\")","v":""},{"$f":"IFERROR(INDEX(#REF!,MATCH($A19,#REF!,0),1),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(#REF!,MATCH($A19,#REF!,0),1),\"-\")","v":"-"},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(#REF!,SMALL(IF(#REF!<>\"\",ROW(#REF!)-ROW(#REF!)),ROW(A10))),\"\")","v":""},{"$f":"IFERROR(INDEX(#REF!,MATCH($A20,#REF!,0),1),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(#REF!,MATCH($A20,#REF!,0),1),\"-\")","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
["."]
["Примечание: при предоставлении мониторинга исполнения за 1 квартал необходимо заполнить следующие графы: факт 2017 года (за все периоды), план 2018 года (за все периоды), факт I кв 2018 года (в последующем соответствующий период, согласно дат указанных в письме). После 01.06.18 года графы: факт 2017 года за все периоды, план 2018 года за все периоды, факт за I квартал 2018 года - автоматически заблокируются. Открытие граф для заполнения будет возможно, только по письму от держателя карты.\n\nПри отправке необходимо изменять разметку страниц - скрывать периоды отчетная дата по которым еще не наступила."]
["."]
["Легенда:"]
["ячейки для ввода данных в файле"]
["ячейки для ввода данных по наступлению соответствующего периода"]