{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["тп-2","Ведомость показаний "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"тп-2","index":0,"n_rows":14,"n_cols":41,"rows_kept":14,"cut":false,"hidden":false,"merged":[[3,0,4,1]]}
[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,"Не нашел"]
["дог. 12 Н/О",null,436608,{"$f":"SUM(Q2:AN2)","v":26260},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,6200,5100,6720,{"$f":"1760+6480","v":8240}]
[]
["дог. 641,4 Тяговая подстанция №103 (Сосновая 13б)",null,16808331,{"$f":"SUM(Q4:AN4)","v":518.52},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":"6.93*100/5","v":138.6},83.52,86,{"$f":"10.52*100/5","v":210.4}]
[null,null,16808342,1558.28,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":"18.17*100/5","v":363.40000000000003},398.88,418,{"$f":"18.9*100/5","v":377.99999999999994}]
["дог. 2537 Произв.база",null,645284,6373,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,1556,1618,1457,1742]
["дог. 478 Помещение (Сосновая, 17)",null,762471,64,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,0,0,4,60]
["дог. 4730 Магазин (Сосновая, 17/1)",null,1356624,6012,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,1771,1402,1758,1081]
["дог. 4730 ТОК (ост. Магнитная )",null,941587,4267.4799999999996,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,787,723.01,727.01,736.19,1294.27]
["дог. 3857 Магазин (Сосновая, 19)",null,370882,10169,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,2524,2541,2776,2328]
[]
[null,"Пробуйте."]
[null,"1. Выделить мышкой некое количество ячеек (к примеру: \"AO3:AO7\", или \"AO5:AO36\". Выбираю сам всегда в одном столбе смежные ячейки.) "]
[null,"2. Нажимаю \"Ctrl+ц\" "]

{"sheet":"Ведомость показаний ","index":1,"n_rows":10,"n_cols":19,"rows_kept":10,"cut":false,"hidden":false,"merged":[[9,1,9,3],[9,5,9,6],[9,8,9,10],[9,13,9,15],[7,1,7,3],[7,5,7,6],[7,8,7,10],[7,13,7,15],[8,1,8,3],[8,5,8,6],[8,8,8,10],[8,13,8,15],[6,1,6,3],[6,5,6,6],[6,8,6,10],[6,13,6,15],[0,6,0,13],[2,0,2,1],[2,3,2,8],[4,0,4,1],[4,3,4,9]]}
[null,null,null,null,null,null,"Ведомость показаний (общий тариф)"]
[]
["Объект :",null,null,"ТП-11 участок"]
[]
["Период : ",null,null,"с 01.10.2014 по 01.11.2014"]
[]
["№ п/п","№ счетчика",null,null,"Дата","Показания начальн. кВт*ч",null,"Дата","Показания конечные\nкВт*ч",null,null,"Ктн","Расход кВт*ч","Адрес",null,null,null,31,{"$f":"IF(ISNA(VLOOKUP($C7,'Ведомость показаний '!$B$8:$R$21,17,FALSE)),\"Не нашел\",VLOOKUP($C7,'Ведомость показаний '!$B$8:$R$21,17,FALSE))","v":"Не нашел"}]
[1,5027519,null,null,"01.10.2014","102368,28",null,"01.11.2014","105802,34",null,null,1,3434.06,"Магнитогорск, Орджоникидзевский, Магнитная, 15А ИП Зенченко А.Н., 0",null,null,null,{"$f":"IF(H8=\"\",\"Пусто\",IF(H8-E8<=3,\"пуууусто\",IF(H8-E8=$R$7,M8,M8/(H8-E8)*$R$7)))","v":3434.06}]
[2,919610,null,null,"01.10.2014","15803,07",null,"01.11.2014","16376,71",null,null,1,573.64,"Магнитогорск, Орджоникидзевский, Магнитная, 27/3 ФЛ Головачева, Шиномонтаж",null,null,null,{"$f":"IF(H9=\"\",\"Пусто\",IF(H9-E9<=3,\"пуууусто\",IF(H9-E9=$R$7,M9,M9/(H9-E9)*$R$7)))","v":573.64}]
[3,1801202,null,null,"01.10.2014","17210,59",null,"01.11.2014","17740,01",null,null,20,10588.4,"Магнитогорск, ТП, Л/Б, ТП-11 участок, нар. освещение",null,null,null,{"$f":"IF(H10=\"\",\"Пусто\",IF(H10-E10<=3,\"пуууусто\",IF(H10-E10=$R$7,M10,M10/(H10-E10)*$R$7)))","v":10588.4}]