{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Отчёт","по месяцам"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":4,"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":36,"n_cols":15,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,8,0,11],[15,3,15,8],[5,6,5,8],[7,2,14,2],[24,3,24,7],[28,3,35,3],[15,10,15,11],[5,9,6,9],[1,3,1,9],[3,3,3,5],[5,10,5,11],[5,5,6,5],[2,1,2,11],[5,1,6,1],[5,2,6,2],[5,3,6,3],[7,1,14,1],[5,4,6,4]]}
[null,null,null,null,null,null,null,null," Приложение 6           к                           договору на электроснабжение и потребление электрической энергии от 19/08.  № 54365"]
[null,null,null,"ОТЧЕТ"]
[null,"Учреждение образования \"Осиповичская государственная специальная общеобразовательная школа-интернат для детей с нарушением функций опорно-двигательного аппарата\""]
[null,null,null,"                          за месяц",null,null,"июнь",2017,"год",null,null,null,null,null,{"$f":" MATCH($G$4, Месяцы, 0) + MATCH($H$4, 'по месяцам'!$A:$A, 0) - 1","v":9}]
[]
[null,"Название объекта","Адрес объекта","тип     транс-ров тока","Номер прибора учета","Место расположения","Показания счетчика",null,null,"Потребленная электроэнергия (кВт)","     Потери   в",null,null,{"$f":" MATCH($G$4, Месяцы, 0) + MATCH($H$4, 'по месяцам'!$A:$A, 0) - 1","v":9}]
[null,null,null,null,null,null,"Коэффициент     трансформации","Предыдущее","Последнее",null,"трансформаторе","сети"]
[null,null,"Осиповичи","ТОП-0,66 0,5 У3",75854684,"Изолятор  ",15,{"$f":" INDEX('по месяцам'!$D:$D, $O$4-1)","v":2699},{"$f":" INDEX('по месяцам'!$D:$D, $O$4)","v":2800},{"$f":" INDEX('по месяцам'!$C:$C, $O$4)","v":1515},null,{"$f":" INDEX('по месяцам'!$F:$F, $O$4)","v":1}]
[null,null,null,"ТОП-0,66 0,5 У3",600719,"Уличное освещение",15,{"$f":" INDEX('по месяцам'!$K:$K, $O$4-1)","v":743},{"$f":" INDEX('по месяцам'!$K:$K, $O$4)","v":750},{"$f":" INDEX('по месяцам'!$J:$J, $O$4)","v":105},null,{"$f":" INDEX('по месяцам'!$M:$M, $O$4)","v":2}]
[null,null,null,"ТОП-0,66 0,5 У3",470782,"Мастерские",1,{"$f":" INDEX('по месяцам'!$R:$R, $O$4-1)","v":799},{"$f":" INDEX('по месяцам'!$R:$R, $O$4)","v":900},{"$f":" INDEX('по месяцам'!$Q:$Q, $O$4)","v":101},null,{"$f":" INDEX('по месяцам'!$T:$T, $O$4)","v":3}]
[null,null,null,"ТОП-0,66 0,5 У3",535005,"Овощехранилище",1,{"$f":" INDEX('по месяцам'!$Y:$Y, $O$4-1)","v":6199},{"$f":" INDEX('по месяцам'!$Y:$Y, $O$4)","v":6240},{"$f":" INDEX('по месяцам'!$X:$X, $O$4)","v":41},{"$f":"IF(J11<0,\"Введите данные\",\"\")","v":""},{"$f":" INDEX('по месяцам'!$AA:$AA, $O$4)","v":4}]
[null,null,null,"ТОП-0,66 0,5 У3",546500,"Освещение школы",1,{"$f":" INDEX('по месяцам'!$AF:$AF, $O$4-1)","v":12751},{"$f":" INDEX('по месяцам'!$AF:$AF, $O$4)","v":12799},{"$f":" INDEX('по месяцам'!$AE:$AE, $O$4)","v":48},null,{"$f":" INDEX('по месяцам'!$AH:$AH, $O$4)","v":5}]
[null,null,null,"ТОП-0,66 0,5 У3",46789,"новая столовая",1,{"$f":" INDEX('по месяцам'!$AM:$AM, $O$4-1)","v":60286},{"$f":" INDEX('по месяцам'!$AM:$AM, $O$4)","v":62461},{"$f":" INDEX('по месяцам'!$AL:$AL, $O$4)","v":2175},null,{"$f":" INDEX('по месяцам'!$AO:$AO, $O$4)","v":6}]
[null,null,null,"ТОП-0,66 0,5 У3",570328,"Кухня",1,{"$f":" INDEX('по месяцам'!$BA:$BA, $O$4-1)","v":40058},{"$f":" INDEX('по месяцам'!$BA:$BA, $O$4)","v":40588},{"$f":" INDEX('по месяцам'!$AZ:$AZ, $O$4)","v":530},null,{"$f":" INDEX('по месяцам'!$AV:$AV, $O$4)","v":7}]
[null,null,null,"ТОП-0,66 0,5 У4",570329,"Прачечная ",1,{"$f":" INDEX('по месяцам'!$AT:$AT, $O$4-1)","v":40058},{"$f":" INDEX('по месяцам'!$AT:$AT, $O$4)","v":50000},{"$f":" INDEX('по месяцам'!$AS:$AS, $O$4)","v":9942},null,{"$f":" INDEX('по месяцам'!$BC:$BC, $O$4)","v":8}]
[null,null,null,"Всего потреблено электроэнергии:",null,null,null,null,null,{"$f":"SUM(J8:J15)","v":14457},"кВт"]
[]
[]
[]
[]
[]
[null,null,"Руководитель предприятия (организации)"]
[]
[]
[null,null,null,"Показания за месяц"]
[]
[null,null,null,null,null,null,6]
[null,null,null,null,null,{"$f":"H4","v":2017},6,"ПОТЕРИ в сети"]
[null,null,null,"СЧЕТЧИКИ","75854684","Изолятор  ",2800,{"$f":"0.01*G29","v":28}]
[null,null,null,null,"600719","Уличное освещение",750,{"$f":"0.01*G30","v":7.5}]
[null,null,null,null,470782,"Мастерские",900,9]
[null,null,null,null,"535005","Овощехранилище",6240,62.4]
[null,null,null,null,546500,"Освещение школы",12799,127.99000000000001]
[null,null,null,null,"46789","КНС",62461,624.61]
[null,null,null,null,570328,"Кухня",40588,405.88]
[null,null,null,null,"444555","Прачечная ",50000,500]

{"sheet":"по месяцам","index":1,"n_rows":39,"n_cols":55,"rows_kept":39,"cut":false,"hidden":false,"merged":[[1,17,1,18],[3,14,14,14],[15,14,26,14],[27,14,38,14],[1,24,1,25],[3,21,14,21],[15,21,26,21],[27,21,38,21],[3,0,14,0],[15,0,26,0],[27,0,38,0],[3,28,14,28],[15,28,26,28],[27,28,38,28],[1,10,1,11],[3,7,14,7],[15,7,26,7],[27,7,38,7],[1,3,1,4],[3,42,14,42],[15,42,26,42],[27,42,38,42],[1,31,1,32],[1,38,1,39],[3,35,14,35],[15,35,26,35],[27,35,38,35],[1,52,1,53],[3,49,14,49],[15,49,26,49],[27,49,38,49],[1,45,1,46],[0,52,0,53],[0,45,0,46],[0,3,0,4],[0,16,0,18],[0,24,0,25],[0,29,0,32],[0,38,0,39],[0,9,0,12]]}
[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,75854684," показания счетчика",null,null,null,null,null,600719," показания счетчика",null,null,null,null,null,470782," показания счетчика",null,null,null,null,null,535005," показания счетчика",null,null,null,null,null,546500," показания счетчика",null,null,null,null,null,46789," показания счетчика",null,null,null,null,null,570328," показания счетчика",null,null,null,null,null,444555," показания счетчика"]
[null,null,"расход (кВт)",2573,"Коэффициент     трансформации","ПОТЕРИ в сети",null,null,null,"расход (кВт)",543,"Коэффициент     трансформации","ПОТЕРИ в сети",null,null,null,"расход (кВт)",686,"Коэффициент     трансформации","ПОТЕРИ в сети",null,null,null,"расход (кВт)",5914,"Коэффициент     трансформации","ПОТЕРИ в сети",null,null,null,"расход (кВт)",12471,"Коэффициент     трансформации","ПОТЕРИ в сети",null,null,null,"расход (кВт)",0,"Коэффициент     трансформации","ПОТЕРИ в сети",null,null,null,"расход (кВт)",36039,"Коэффициент     трансформации","ПОТЕРИ в сети",null,null,null,"расход (кВт)",36039,"Коэффициент     трансформации","ПОТЕРИ в сети"]
[2017,"январь",{"$f":"(D4-D3)*E4","v":390},2599,15,1,null,2017,"январь",{"$f":" (K4-K3)*L4","v":780},595,15,2,null,2017,"январь",{"$f":" (R4-R3)*S4","v":44},730,1,3,null,2017,"январь",{"$f":" (Y4-Y3)*Z4","v":21},5935,1,4,null,2017,"январь",{"$f":" (AF4-AF3)*AG4","v":39},12510,1,5,null,2017,"январь",{"$f":" (AM4-AM3)*AN4","v":50353},50353,1,6,null,2017,"январь",{"$f":" (AT4-AT3)*AU4","v":728},36767,1,7,null,2017,"январь",{"$f":" (BA4-BA3)*BB4","v":728},36767,1,8]
[null,"февраль",{"$f":"(D5-D4)*E5","v":375},2624,15,1,null,null,"февраль",{"$f":" (K5-K4)*L5","v":750},645,15,2,null,null,"февраль",18,748,1,3,null,null,"февраль",80,6015,1,4,null,null,"февраль",216,12726,1,5,null,null,"февраль",2780,53133,1,6,null,null,"февраль",2718,39485,1,7,null,null,"февраль",2718,39485,1,8]
[null,"март",{"$f":"(D6-D5)*E6","v":495},2657,15,1,null,null,"март",765,696,15,2,null,null,"март",6,754,1,3,null,null,"март",58,6073,1,4,null,null,"март",0,12726,1,5,null,null,"март",2001,55134,1,6,null,null,"март",2,39487,1,7,null,null,"март",2,39487,1,8]
[null,"апрель",270,2675,15,1,null,null,"апрель",255,713,15,2,null,null,"апрель",24,778,1,3,null,null,"апрель",66,6139,1,4,null,null,"апрель",0,12726,1,5,null,null,"апрель",2744,57878,1,6,null,null,"апрель",143,39630,1,7,null,null,"апрель",143,39630,1,8]
[null,"май",360,2699,15,1,null,null,"май",450,743,15,2,null,null,"май",21,799,1,3,null,null,"май",60,6199,1,4,null,null,"май",25,12751,1,5,null,null,"май",2408,60286,1,6,null,null,"май",428,40058,1,7,null,null,"май",428,40058,1,8]
[null,"июнь",1515,2800,15,1,null,null,"июнь",105,750,15,2,null,null,"июнь",101,900,1,3,null,null,"июнь",41,6240,1,4,null,null,"июнь",48,12799,1,5,null,null,"июнь",2175,62461,1,6,null,null,"июнь",9942,50000,1,7,null,null,"июнь",530,40588,1,8]
[null,"июль",-42000,null,15,1,null,null,"июль",-11250,null,15,2,null,null,"июль",-900,null,1,3,null,null,"июль",-6240,null,1,4,null,null,"июль",-12799,null,1,5,null,null,"июль",-62461,null,1,6,null,null,"июль",-50000,null,1,7,null,null,"июль",-40588,null,1,8]
[null,"август",0,null,15,1,null,null,"август",0,null,15,2,null,null,"август",0,null,1,3,null,null,"август",0,null,1,4,null,null,"август",0,null,1,5,null,null,"август",0,null,1,6,null,null,"август",0,null,1,7,null,null,"август",0,null,1,8]
[null,"сентябь",0,null,15,1,null,null,"сентябь",0,null,15,2,null,null,"сентябь",0,null,1,3,null,null,"сентябь",0,null,1,4,null,null,"сентябь",0,null,1,5,null,null,"сентябь",0,null,1,6,null,null,"сентябь",0,null,1,7,null,null,"сентябь",0,null,1,8]
[null,"октябрь",0,null,15,1,null,null,"октябрь",0,null,15,2,null,null,"октябрь",0,null,1,3,null,null,"октябрь",0,null,1,4,null,null,"октябрь",0,null,1,5,null,null,"октябрь",0,null,1,6,null,null,"октябрь",0,null,1,7,null,null,"октябрь",0,null,1,8]
[null,"ноябрь",0,null,15,1,null,null,"ноябрь",0,null,15,2,null,null,"ноябрь",0,null,1,3,null,null,"ноябрь",0,null,1,4,null,null,"ноябрь",0,null,1,5,null,null,"ноябрь",0,null,1,6,null,null,"ноябрь",0,null,1,7,null,null,"ноябрь",0,null,1,8]
[null,"декабрь",0,null,15,1,null,null,"декабрь",0,null,15,2,null,null,"декабрь",0,null,1,3,null,null,"декабрь",0,null,1,4,null,null,"декабрь",0,null,1,5,null,null,"декабрь",0,null,1,6,null,null,"декабрь",0,null,1,7,null,null,"декабрь",0,null,1,8]
[2018,"январь",0,null,15,1,null,2018,"январь",0,null,15,2,null,2018,"январь",0,null,1,3,null,2018,"январь",0,null,1,4,null,2018,"январь",0,null,1,5,null,2018,"январь",0,null,1,6,null,2018,"январь",0,null,1,7,null,2018,"январь",0,null,1,8]
[null,"февраль",0,null,15,1,null,null,"февраль",0,null,15,2,null,null,"февраль",0,null,1,3,null,null,"февраль",0,null,1,4,null,null,"февраль",0,null,1,5,null,null,"февраль",0,null,1,6,null,null,"февраль",0,null,1,7,null,null,"февраль",0,null,1,8]
[null,"март",0,null,15,1,null,null,"март",0,null,15,2,null,null,"март",0,null,1,3,null,null,"март",0,null,1,4,null,null,"март",0,null,1,5,null,null,"март",0,null,1,6,null,null,"март",0,null,1,7,null,null,"март",0,null,1,8]
[null,"апрель",0,null,15,1,null,null,"апрель",0,null,15,2,null,null,"апрель",0,null,1,3,null,null,"апрель",0,null,1,4,null,null,"апрель",0,null,1,5,null,null,"апрель",0,null,1,6,null,null,"апрель",0,null,1,7,null,null,"апрель",0,null,1,8]
[null,"май",0,null,15,1,null,null,"май",0,null,15,2,null,null,"май",0,null,1,3,null,null,"май",0,null,1,4,null,null,"май",0,null,1,5,null,null,"май",0,null,1,6,null,null,"май",0,null,1,7,null,null,"май",0,null,1,8]
[null,"июнь",0,null,15,1,null,null,"июнь",0,null,15,2,null,null,"июнь",0,null,1,3,null,null,"июнь",0,null,1,4,null,null,"июнь",0,null,1,5,null,null,"июнь",0,null,1,6,null,null,"июнь",0,null,1,7,null,null,"июнь",0,null,1,8]
[null,"июль",0,null,15,1,null,null,"июль",0,null,15,2,null,null,"июль",0,null,1,3,null,null,"июль",0,null,1,4,null,null,"июль",0,null,1,5,null,null,"июль",0,null,1,6,null,null,"июль",0,null,1,7,null,null,"июль",0,null,1,8]
[null,"август",0,null,15,1,null,null,"август",0,null,15,2,null,null,"август",0,null,1,3,null,null,"август",0,null,1,4,null,null,"август",0,null,1,5,null,null,"август",0,null,1,6,null,null,"август",0,null,1,7,null,null,"август",0,null,1,8]
[null,"сентябь",0,null,15,1,null,null,"сентябь",0,null,15,2,null,null,"сентябь",0,null,1,3,null,null,"сентябь",0,null,1,4,null,null,"сентябь",0,null,1,5,null,null,"сентябь",0,null,1,6,null,null,"сентябь",0,null,1,7,null,null,"сентябь",0,null,1,8]
[null,"октябрь",0,null,15,1,null,null,"октябрь",0,null,15,2,null,null,"октябрь",0,null,1,3,null,null,"октябрь",0,null,1,4,null,null,"октябрь",0,null,1,5,null,null,"октябрь",0,null,1,6,null,null,"октябрь",0,null,1,7,null,null,"октябрь",0,null,1,8]
[null,"ноябрь",0,null,15,1,null,null,"ноябрь",0,null,15,2,null,null,"ноябрь",0,null,1,3,null,null,"ноябрь",0,null,1,4,null,null,"ноябрь",0,null,1,5,null,null,"ноябрь",0,null,1,6,null,null,"ноябрь",0,null,1,7,null,null,"ноябрь",0,null,1,8]
[null,"декабрь",0,null,15,1,null,null,"декабрь",0,null,15,2,null,null,"декабрь",0,null,1,3,null,null,"декабрь",0,null,1,4,null,null,"декабрь",0,null,1,5,null,null,"декабрь",0,null,1,6,null,null,"декабрь",0,null,1,7,null,null,"декабрь",0,null,1,8]
[2019,"январь",0,null,15,1,null,2019,"январь",0,null,15,2,null,2019,"январь",0,null,1,3,null,2019,"январь",0,null,1,4,null,2019,"январь",0,null,1,5,null,2019,"январь",0,null,1,6,null,2019,"январь",0,null,1,7,null,2019,"январь",0,null,1,8]
[null,"февраль",0,null,15,1,null,null,"февраль",0,null,15,2,null,null,"февраль",0,null,1,3,null,null,"февраль",0,null,1,4,null,null,"февраль",0,null,1,5,null,null,"февраль",0,null,1,6,null,null,"февраль",0,null,1,7,null,null,"февраль",0,null,1,8]
[null,"март",0,null,15,1,null,null,"март",0,null,15,2,null,null,"март",0,null,1,3,null,null,"март",0,null,1,4,null,null,"март",0,null,1,5,null,null,"март",0,null,1,6,null,null,"март",0,null,1,7,null,null,"март",0,null,1,8]
[null,"апрель",0,null,15,1,null,null,"апрель",0,null,15,2,null,null,"апрель",0,null,1,3,null,null,"апрель",0,null,1,4,null,null,"апрель",0,null,1,5,null,null,"апрель",0,null,1,6,null,null,"апрель",0,null,1,7,null,null,"апрель",0,null,1,8]
[null,"май",0,null,15,1,null,null,"май",0,null,15,2,null,null,"май",0,null,1,3,null,null,"май",0,null,1,4,null,null,"май",0,null,1,5,null,null,"май",0,null,1,6,null,null,"май",0,null,1,7,null,null,"май",0,null,1,8]
[null,"июнь",0,null,15,1,null,null,"июнь",0,null,15,2,null,null,"июнь",0,null,1,3,null,null,"июнь",0,null,1,4,null,null,"июнь",0,null,1,5,null,null,"июнь",0,null,1,6,null,null,"июнь",0,null,1,7,null,null,"июнь",0,null,1,8]
[null,"июль",0,null,15,1,null,null,"июль",0,null,15,2,null,null,"июль",0,null,1,3,null,null,"июль",0,null,1,4,null,null,"июль",0,null,1,5,null,null,"июль",0,null,1,6,null,null,"июль",0,null,1,7,null,null,"июль",0,null,1,8]
[null,"август",0,null,15,1,null,null,"август",0,null,15,2,null,null,"август",0,null,1,3,null,null,"август",0,null,1,4,null,null,"август",0,null,1,5,null,null,"август",0,null,1,6,null,null,"август",0,null,1,7,null,null,"август",0,null,1,8]
[null,"сентябь",0,null,15,1,null,null,"сентябь",0,null,15,2,null,null,"сентябь",0,null,1,3,null,null,"сентябь",0,null,1,4,null,null,"сентябь",0,null,1,5,null,null,"сентябь",0,null,1,6,null,null,"сентябь",0,null,1,7,null,null,"сентябь",0,null,1,8]
[null,"октябрь",0,null,15,1,null,null,"октябрь",0,null,15,2,null,null,"октябрь",0,null,1,3,null,null,"октябрь",0,null,1,4,null,null,"октябрь",0,null,1,5,null,null,"октябрь",0,null,1,6,null,null,"октябрь",0,null,1,7,null,null,"октябрь",0,null,1,8]
[null,"ноябрь",0,null,15,1,null,null,"ноябрь",0,null,15,2,null,null,"ноябрь",0,null,1,3,null,null,"ноябрь",0,null,1,4,null,null,"ноябрь",0,null,1,5,null,null,"ноябрь",0,null,1,6,null,null,"ноябрь",0,null,1,7,null,null,"ноябрь",0,null,1,8]
[null,"декабрь",0,null,15,1,null,null,"декабрь",0,null,15,2,null,null,"декабрь",0,null,1,3,null,null,"декабрь",0,null,1,4,null,null,"декабрь",0,null,1,5,null,null,"декабрь",0,null,1,6,null,null,"декабрь",0,null,1,7,null,null,"декабрь",0,null,1,8]