{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Первый вопрос","Второй вопрос","Лист3"],"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":"Первый вопрос","index":0,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Январь ",null,"Февраль"]
[null,"Показания ","Расход","Показания ","Расход"]
[null,58654,500,null,600]
[null,58654,500,59254]

{"sheet":"Второй вопрос","index":1,"n_rows":89,"n_cols":21,"rows_kept":89,"cut":false,"hidden":false,"merged":[[88,0,88,15],[77,0,78,0],[77,1,78,1],[77,8,78,8],[80,0,81,0],[80,1,81,1],[59,8,60,8],[61,0,62,0],[61,1,62,1],[61,8,62,8],[59,0,60,0],[59,1,60,1],[59,2,60,2],[59,5,60,5],[59,6,60,6],[64,0,65,0],[64,1,65,1],[40,0,41,0],[40,1,41,1],[59,7,60,7],[72,0,73,0],[72,1,73,1],[66,0,67,0],[66,1,67,1],[68,0,69,0],[68,1,69,1],[70,0,71,0],[70,1,71,1],[40,8,41,8],[43,0,44,0],[43,1,44,1],[31,1,32,1],[33,0,34,0],[33,1,34,1],[35,0,36,0],[35,1,36,1],[31,0,32,0],[24,8,25,8],[27,0,28,0],[27,1,28,1],[29,0,30,0],[29,1,30,1],[24,0,25,0],[24,1,25,1],[3,13,3,16],[3,9,3,12],[3,17,3,20],[22,0,23,0],[22,1,23,1],[22,2,23,2],[22,5,23,5],[22,6,23,6],[22,7,23,7],[22,8,23,8]]}
[]
["На первом листе вот такая таблица с месяцами по горизонтали."]
[]
[null,null,null,null,null,null,null,null,null,"Январь",null,null,null,"Февраль",null,null,null,"Март"]
["№п/п","Город","Договора","Статус\nАктуально/Не актуально","№БС","Название БС","Передать до","Способ получе\nния","Способ передачи","Показания ","Расход","Передал\nДа/Нет","Комментарий","Показания ","Расход","Передал\nДа/Нет","Комментарий","Показания ","Расход","Передал\nДа/Нет","Комментарий"]
[null,null,1178,"А",null,"Коммутатор пр.Красноармейский 61а"]
[1,null,null,"А",1,"Космонавтов   ",26,"Ехать","Смс",41941,750,null,null,42521,580,"Да",null,43296,775,"Да"]
[2,null,null,"А",2,"5-я Западная 85",25,"Ехать","Факс",67685,980,null,null,68647,962,"Да",null,69477,830,"Да"]
[null,null,1178,"А",3,"Калинина 57 ",27,"Телеметрия","Факс",57280,887,null,null,58042,762,"Да",null,58806,764,"Да"]
[1,null,1178,"А",4,"Шукшина 10",27,"Телеметрия","Факс",134914,6518,null,null,141013,6099,"Да",null,147235,6222,"Да"]
[1,null,null,"А",6,"ДК г.Барнаула",28,"Ехать","Эл.почта",31097,910,null,null,32122,1025,"Да",null,33106,984,"Да"]
[1,null,1178,"А",7,"С.Батора 35",27,"Ехать","Факс",68463,1150,null,null,69483,1020,"Да",null,70453,970,"Да"]
[1,null,null,"А",8,"Малахова177",31,"Ехать","Лично",35773,null,null,null,35773,null,"Да",null,35773]
[1,null,1178,"А",11,"Красноармейский 81",27,"Телеметрия","Факс",154406,2100,null,null,157577,3171,"Да",null,160078,2501,"Да"]
[]
[]
[]
["На втором листе вот такая таблица с месяцами по вертикали."]
[]
["СВЕДЕНИЯ О РАСХОДЕ ЭЛЕКТРОЭНЕРГИИ"]
["№ договора: 1178/1948                           За февраль 2015 г."]
[]
["№п/п","Место установки","№ счетчика","Предыдущие показания на","Настоящие показания на","Разница","Расчетный коэфф.","Расход \nкВт*ч","Примечание"]
[null,null,null,"2015-01-28","2015-02-25"]
[1,"пр.Красноармейский 61а от ТП-951",1,"01166","01166",0,30,0,"Пломбы сняты \n26.08.14"]
[null,null,2,null,null,0,30,0]
[2,"пр.Красноармейский 61а от ТП-945",1,"003792","003792",0,1,0]
[3,"пр.Красноармейский 81 от ТП-887\n (БС-11)","Акт",{"$f":"J14","v":154406},157577,3171,1,3171]
[null,null,"Реакт",8824,8854,30,1,30]
[4,"пр.Калинина 57 от ТП-647 \n(БС 3)\n","Акт",{"$f":"J9","v":57280},58042,762,1,762]
[null,null,"Реакт",5862,5875,13,1,13]
[5,"ул.Шукшина 10 (БС 4)","Акт",{"$f":"J10","v":134914},141013,6099,1,6099]
[null,null,"Реакт",6,8,2,1,2]
[6,"ул. Деповская 19 (БС 79)","Акт",33269,34579,1310,1,1310]
[null,null,"Реакт",3638,3638,0,1,0]
[7,"ул.Никитина,55\nстадион «Динамо» (БС 38)\n","Акт",23227,24036,809,1,809]
[null,null,"Реакт",534,534,0,1,0]
[8,"п. Южный, ул. Белинского 9 (БС 73)",null,80682,81602,920,1,920]
[9,"ул. С.Батора 35 (БС 7)",null,68463,69483,1020,1,1020]
[10,"ул. А.Петрова 212 (БС 34)",null,57725,58825,1100,1,1100]
[11,"с. Лебяжье, ул. Школьная 30\n (БС 22)\n","Акт",49433,49433,0,1,0,"Пломбы сняты \n12.02.15"]
[null,null,"Реакт",3770,3770,0,1,0]
[12,"ул. Ползунова, 50 (БС 123)",null,27214,28264,1050,1,1050]
[13,"ул. Георгиева 53 (БС 60)","Акт",23852,24602,750,1,750]
[null,null,"Реакт",284,284,0,1,0]
[14,"ул. Попова 68 (БС 119)",null,20256,21276,1020,1,1020]
[15,"ул. Кащеева 23 (БС 118)",null,20080,21817,1737,1,1737]
[null,null,null,null,null,"Итого:","Активная:",19748,"кВт*ч"]
[null,null,null,null,null,"Итого:","Реактивная:",45,"кВар*ч"]
[]
[]
[]
[]
[]
["     Почтовый адрес: 656049, г. Барнаул, пр. Красноармейский, 61а                                     meter@bges.ru для Южковой С.З."]
[]
["СВЕДЕНИЯ О РАСХОДЕ ЭЛЕКТРОЭНЕРГИИ"]
["№ договора: 1178/1948                           За март 2015 г."]
[]
["№п/п","Место установки","№ счетчика","Предыдущие показания на","Настоящие показания на","Разница","Расчетный коэфф.","Расход \nкВт*ч","Примечание"]
[null,null,null,"2015-02-25","2015-03-25"]
[1,"пр.Красноармейский 61а от ТП-951",1,"01166","01166",0,30,0,"Пломбы сняты \n26.08.14"]
[null,null,2,null,null,0,30,0]
[2,"пр.Красноармейский 61а от ТП-945",1,"003792","003792",0,1,0]
[3,"пр.Красноармейский 81 от ТП-887\n (БС-11)","Акт",157577,160078,2501,1,2501]
[null,null,"Реакт",8854,8892,38,1,38]
[4,"пр.Калинина 57 от ТП-647 \n(БС 3)\n","Акт",58042,58806,764,1,764]
[null,null,"Реакт",5875,5890,15,1,15]
[5,"ул.Шукшина 10 (БС 4)","Акт",141013,147235,6222,1,6222]
[null,null,"Реакт",8,8,0,1,0]
[6,"ул. Деповская 19 (БС 79)","Акт",34579,35729,1150,1,1150]
[null,null,"Реакт",3638,3638,0,1,0]
[7,"ул.Никитина,55\nстадион «Динамо» (БС 38)\n","Акт",24036,24899,863,1,863]
[null,null,"Реакт",534,534,0,1,0]
[8,"п. Южный, ул. Белинского 9 (БС 73)",null,81602,82412,810,1,810]
[9,"ул. С.Батора 35 (БС 7)",null,69483,70453,970,1,970]
[10,"ул. А.Петрова 212 (БС 34)",null,58825,59858,1033,1,1033]
[11,"с. Лебяжье, ул. Школьная 30\n (БС 22)\n","Акт",49433,49433,0,1,0,"Пломбы сняты \n12.02.15"]
[null,null,"Реакт",3770,3770,0,1,0]
[12,"ул. Ползунова, 50 (БС 123)",null,28264,29254,990,1,990]
[13,"ул. Георгиева 53 (БС 60)","Акт",24602,25052,450,1,450]
[null,null,"Реакт",284,284,0,1,0]
[14,"ул. Попова 68 (БС 119)",null,21276,22256,980,1,980]
[15,"ул. Кащеева 23 (БС 118)",null,21817,23298,1481,1,1481]
[null,null,null,null,null,"Итого:","Активная:",18214,"кВт*ч"]
[null,null,null,null,null,"Итого:","Реактивная:",53,"кВар*ч"]
[]
[]
["По каждому объекту показания ссылаются на первый лист. Вопрос: как размножить вот эту 15-строчную таблицу на все месяца,чтобы все формулы скопировались правильно? Сложность в том что на первом листе месяца идут по вертикали,а на втором по горизонтали."]

{"sheet":"Лист3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}