{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Отчёт","по месяцам"],"not_rendered":{"charts":3,"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":24,"n_cols":15,"rows_kept":24,"cut":false,"hidden":false,"merged":[[22,1,22,2],[23,1,23,2],[23,3,23,5],[10,3,10,8],[7,1,9,1],[7,2,9,2],[5,1,6,1],[5,2,6,2],[5,3,6,3],[5,4,6,4],[5,5,6,5],[5,6,5,8],[0,9,0,11],[5,9,6,9],[1,3,1,9],[2,3,2,9],[3,3,3,5],[5,10,5,11]]}
[null,null,null,null,null,null,null,null,null,"                                                     Приложение 6                                     к  договору на электроснабжение и потребление электрической энергии от 19/08.  № 54365"]
[null,null,null,"ОТЧЕТ"]
[null,null,null,"о фактическом потреблении электроэнергии  Осиповичским ОАО \"Свислочь\" "]
[null,null,null,"                          за месяц",null,null,"ноябрь",2015,"год",null,null,null,null,null,{"$f":" MATCH($G$4, Месяцы, 0) + MATCH($H$4, 'по месяцам'!$A:$A, 0) - 1","v":14}]
[]
[null,"Название объекта","Адрес объекта","тип     транс-ров тока","Номер прибора учета","Место расположения","Показания счетчика",null,null,"Потребленная электроэнергия (кВт)","     Потери   в",null,null,{"$f":" MATCH($G$4, Месяцы, 0) + MATCH($H$4, 'по месяцам'!$A:$A, 0) - 1","v":14}]
[null,null,null,null,null,null,"Коэффициент     трансформации","Предыдущее","Последнее",null,"трансформа торе","сети"]
[null,"ОАО \"Свислочь\" ","Осиповичский   р-н. д.Вязье. Улица Южная, 28","ТОП-0,66 0,5 У3",679302,"ТП 2141 мехдвор",{"$f":" INDEX('по месяцам'!$E:$E, $O$4)","v":10},{"$f":" INDEX('по месяцам'!$D:$D, $O$4-1)","v":7650},{"$f":" INDEX('по месяцам'!$D:$D, $O$4)","v":7700},{"$f":" INDEX('по месяцам'!$C:$C, $O$4)","v":500},{"$f":"IF(J8<=0,\"Введите данные\",\"\")","v":""},{"$f":"K8","v":""}]
[null,null,null,"ТОП-0,66 0,5 У3",442846,"ТП 2434 насосная",{"$f":"'по месяцам'!L11","v":10},{"$f":" INDEX('по месяцам'!$R:$R, $O$4-1)","v":5300},{"$f":" INDEX('по месяцам'!$R:$R, $O$4)","v":5300},{"$f":" INDEX('по месяцам'!$Q:$Q, $O$4)","v":0},{"$f":"IF(J9<0,\"Введите данные\",\"\")","v":""},{"$f":"K9","v":""}]
[null,null,null,"ТОП-0,66 0,5 У3",119617,"ТП 2390 скважина",{"$f":"'по месяцам'!L12","v":10},{"$f":" INDEX('по месяцам'!$K:$K, $O$4-1)","v":3865},{"$f":" INDEX('по месяцам'!$K:$K, $O$4)","v":3895},{"$f":" INDEX('по месяцам'!$J:$J, $O$4)","v":300},{"$f":"IF(J10<0,\"Введите данные\",\"\")","v":""},{"$f":"K10","v":""}]
[null,null,null,"Всего потреблено электроэнергии:",null,null,null,null,null,{"$f":"SUM(J8:J10)","v":800},"кВт",{"$f":"IF(K11<0,\"Введите данные\",\"\")","v":""}]
[]
[]
[]
[]
[]
[null,null,"Руководитель предприятия (организации)",null,null,null,null,null,null,"                                         ."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J22<0,\"Введите данные\",\"\")","v":""},{"$f":"K22","v":""}]
[null,"Месяц",null,"год",null,null,null,null,null,null,{"$f":"IF(J23<0,\"Введите данные\",\"\")","v":""},{"$f":"K23","v":""}]
[null,"предыдущее",null,"последнее"]

{"sheet":"по месяцам","index":1,"n_rows":39,"n_cols":31,"rows_kept":39,"cut":false,"hidden":false,"merged":[[1,24,1,25],[3,21,14,21],[15,21,26,21],[27,21,38,21],[3,26,5,26],[6,26,8,26],[9,26,11,26],[12,26,14,26],[15,26,17,26],[18,26,20,26],[21,26,23,26],[24,26,26,26],[27,26,29,26],[30,26,32,26],[33,26,35,26],[36,26,38,26],[1,17,1,18],[3,14,14,14],[15,14,26,14],[27,14,38,14],[1,3,1,4],[3,0,14,0],[15,0,26,0],[27,0,38,0],[1,10,1,11],[3,7,14,7],[15,7,26,7],[27,7,38,7]]}
[null,null,"ТП 2141 мехдвор",null,null,null,null,null,null," ТП 2390 скважина",null,null,null,null,null,null,"ТП 2434 насосная",null,null,null,null,null,null,"Лимит на год",null,null,null,null,null,null,"Прокопчик И.Л."]
[null,null,679302," показания счетчика",null,null,null,null,null,119617," показания счетчика",null,null,null,null,null,442846," показания счетчика",null,null,null,null,null,null," показания счетчика",null,null,null,null,null,2013]
[null,null,"расход (кВт)",5860,"Коэффициент     трансформации",null,null,null,null,"расход (кВт)",3530,"Коэффициент     трансформации",null,null,null,null,"расход (кВт)",5020,"Коэффициент     трансформации",null,null,null,null,"расход (кВт)","Потреблено","Выделено"]
[2015,"январь",{"$f":" (D4-D3)*E4","v":2900},6150,10,null,null,2015,"январь",{"$f":" (K4-K3)*L4","v":900},3620,10,null,null,2015,"январь",{"$f":" (R4-R3)*S4","v":1200},5140,10,null,null,2015,"январь",{"$f":" (Y4-Y3)*Z4","v":{"$error":"#VALUE!"}},0,1,"I квартал"]
[null,"февраль",3000,6450,10,null,null,null,"февраль",700,3690,10,null,null,null,"февраль",1000,5240,10,null,null,null,"февраль",0,0,1]
[null,"март",2000,6650,10,null,null,null,"март",600,3750,10,null,null,null,"март",600,5300,10,null,null,null,"март",0,0,1]
[null,"апрель",2000,6850,10,null,null,null,"апрель",500,3800,10,null,null,null,"апрель",0,5300,10,null,null,null,"апрель",0,0,1,"II квартал"]
[null,"май",1500,7000,10,null,null,null,"май",100,3810,10,null,null,null,"май",0,5300,10,null,null,null,"май",0,0,1]
[null,"июнь",1000,7100,10,null,null,null,"июнь",100,3820,10,null,null,null,"июнь",0,5300,10,null,null,null,"июнь",0,0,1]
[null,"июль",2000,7300,10,null,null,null,"июль",100,3830,10,null,null,null,"июль",0,5300,10,null,null,null,"июль",0,0,1,"III квартал"]
[null,"август",1500,7450,10,null,null,null,"август",150,3845,10,null,null,null,"август",0,5300,10,null,null,null,"август",0,0,1]
[null,"сентябь",1800,7630,10,7630,null,null,"сентябь",60,3851,10,3851,null,null,"сентябь",0,5300,10,5300,null,null,"сентябь",0,0,1]
[null,"октябрь",200,7650,10,7630,null,null,"октябрь",140,3865,10,3851,null,null,"октябрь",0,5300,10,5300,null,null,"октябрь",0,0,1,"IV квартал"]
[null,"ноябрь",500,7700,10,7640,null,null,"ноябрь",300,3895,10,3811,null,null,"ноябрь",0,5300,10,5129,null,null,"ноябрь",0,0,1]
[null,"декабрь",-77000,null,10,null,null,null,"декабрь",-38950,0,10,null,null,null,"декабрь",-53000,null,10,null,null,null,"декабрь",0,0,1]
[2016,"январь",0,null,10,null,null,2016,"январь",0,0,10,null,null,2016,"январь",0,null,10,null,null,2016,"январь",0,0,1,"I квартал"]
[null,"февраль",0,null,10,null,null,null,"февраль",0,0,10,null,null,null,"февраль",0,null,10,null,null,null,"февраль",0,0,1]
[null,"март",0,null,10,null,null,null,"март",0,0,10,null,null,null,"март",0,null,10,null,null,null,"март",0,0,1]
[null,"апрель",0,null,10,null,null,null,"апрель",0,null,10,null,null,null,"апрель",0,null,10,null,null,null,"апрель",0,null,1,"II квартал"]
[null,"май",0,null,10,null,null,null,"май",0,null,10,null,null,null,"май",0,null,10,null,null,null,"май",0,null,1]
[null,"июнь",0,null,10,null,null,null,"июнь",0,null,10,null,null,null,"июнь",0,null,10,null,null,null,"июнь",0,null,1]
[null,"июль",0,null,10,null,null,null,"июль",0,null,10,null,null,null,"июль",0,null,10,null,null,null,"июль",0,null,1,"III квартал"]
[null,"август",0,null,10,null,null,null,"август",0,null,10,null,null,null,"август",0,null,10,null,null,null,"август",0,null,1]
[null,"сентябь",0,null,10,null,null,null,"сентябь",0,null,10,null,null,null,"сентябь",0,null,10,null,null,null,"сентябь",0,null,1]
[null,"октябрь",0,null,10,null,null,null,"октябрь",0,null,10,null,null,null,"октябрь",0,null,10,null,null,null,"октябрь",0,null,1,"IV квартал"]
[null,"ноябрь",0,null,10,null,null,null,"ноябрь",0,null,10,null,null,null,"ноябрь",0,null,10,null,null,null,"ноябрь",0,null,1]
[null,"декабрь",0,null,10,null,null,null,"декабрь",0,null,10,null,null,null,"декабрь",0,null,10,null,null,null,"декабрь",0,null,1]
[2017,"январь",0,null,10,null,null,2017,"январь",0,null,10,null,null,2017,"январь",0,null,10,null,null,2017,"январь",0,null,1,"I квартал"]
[null,"февраль",0,null,10,null,null,null,"февраль",0,null,10,null,null,null,"февраль",0,null,10,null,null,null,"февраль",0,null,1]
[null,"март",0,null,10,null,null,null,"март",0,null,10,null,null,null,"март",0,null,10,null,null,null,"март",0,null,1]
[null,"апрель",0,null,10,null,null,null,"апрель",0,null,10,null,null,null,"апрель",0,null,10,null,null,null,"апрель",0,null,1,"II квартал"]
[null,"май",0,null,10,null,null,null,"май",0,null,10,null,null,null,"май",0,null,10,null,null,null,"май",0,null,1]
[null,"июнь",0,null,10,null,null,null,"июнь",0,null,10,null,null,null,"июнь",0,null,10,null,null,null,"июнь",0,null,1]
[null,"июль",0,null,10,null,null,null,"июль",0,null,10,null,null,null,"июль",0,null,10,null,null,null,"июль",0,null,1,"III квартал"]
[null,"август",0,null,10,null,null,null,"август",0,null,10,null,null,null,"август",0,null,10,null,null,null,"август",0,null,1]
[null,"сентябь",0,null,10,null,null,null,"сентябь",0,null,10,null,null,null,"сентябь",0,null,10,null,null,null,"сентябь",0,null,1]
[null,"октябрь",0,null,10,null,null,null,"октябрь",0,null,10,null,null,null,"октябрь",0,null,10,null,null,null,"октябрь",0,null,1,"IV квартал"]
[null,"ноябрь",0,null,10,null,null,null,"ноябрь",0,null,10,null,null,null,"ноябрь",0,null,10,null,null,null,"ноябрь",0,null,1]
[null,"декабрь",0,null,10,null,null,null,"декабрь",0,null,10,null,null,null,"декабрь",0,null,10,null,null,null,"декабрь",0,null,1]