{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Данные","Лист3"],"not_rendered":{"charts":0,"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":97,"n_cols":9,"rows_kept":97,"cut":false,"hidden":false,"merged":[]}
[null,"№ дома","№ кв","Фамилия Имя Отчество","задолженность","Паспорт","Телефон","Кол-во месяцев","да2"]
[null,1,1,"Иванов",{"$f":"Лист3!A5","v":1500},"40 00 810610 выдан 13.01.2009 ОУФМС России ТП в г.Рошаль Московской области",4959888888]
["x",1,2,"Петров",{"$f":"Лист3!A6","v":2100}]
[null,1,3,"Сидоров",{"$f":"Лист3!A7","v":2300}]
[null,{"$f":"B4+1","v":2},null,null,{"$f":"Лист3!A8","v":5300}]
[null,3,null,null,{"$f":"Лист3!A9","v":8000}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[null,38]
[null,39]
[null,40]
[null,41]
[null,42]
[null,43]
[null,44]
[null,45]
[null,46]
[null,47]
[null,48]
[null,49]
[null,50]
[null,51]
[null,52]
[null,53]
[null,54]
[null,55]
[null,56]
[null,57]
[null,58]
[null,59]
[null,60]
[null,61]
[null,62]
[null,63]
[null,64]
[null,{"$f":"B67+1","v":65}]
[null,66]
[null,67]
[null,68]
[null,69]
[null,70]
[null,71]
[null,72]
[null,73]
[null,76]
[null,77]
[null,78]
[null,79]
[null,80]
[null,81]
[null,82]
[null,83]
[null,84]
[null,85]
[null,86]
[null,87]
[null,88]
[null,89]
[null,90]
[null,91]
[null,92]
[null,93]
[null,94]
[null,95]
[null,96]

{"sheet":"Лист3","index":1,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,7,0,8],[2,9,2,10],[2,12,2,13],[2,3,2,4],[2,5,2,6],[2,7,2,8],[2,2,3,2],[2,1,3,1],[2,0,3,0],[0,3,0,4],[0,5,0,6]]}
[null,null,null,"вносится вручную",null,"вносится вручную",null,"вносится вручную"]
[]
["Задолженность","Лицевой счет","ФИО","2010-01-01",null,"2010-02-01",null,"2010-03-01",null,"2015-10-04",null,"………..","2016-01-01"]
[null,null,null,"нач.","оплата","нач.","оплата","нач.","оплата","нач.","оплата",null,"нач.","оплата"]
[{"$f":"SUMIF($D$4:$N$4,\"нач.\",D5:N5)-SUMIF($D$4:$N$4,\"оплата\",D5:N5)","v":1500},1002151,"…",1500,2000,1500,500,1500,1000,1500,1000,null,2000,2000]
[{"$f":"SUMIF($D$4:$N$4,\"нач.\",D6:N6)-SUMIF($D$4:$N$4,\"оплата\",D6:N6)","v":2100},100021512,"…",1500,1200,1500,1200,1500,1000,1500,1000,null,2000,1500]
[2300,45654654,"…",1500,1500,1500,1200,1500,1000,1500,1000,null,2000,1000]
[5300,12122311,"…",1500,1500,1500,0,1500,0,1500,0,null,2000,1200]
[8000,5451321,"…",1500,0,1500,0,1500,0,1500,0,null,2000,0]
[]
[]
["Ежемесячно делаю выгрузку и вставляю в эту таблицу 3 колонки:"]
["1 колонка Начисления"]
["2 колонка Оплата"]
["3 Колонка Кол-во месяцев"]
["Необходимо, чтобы эти колонки отображались в Листе \"Данные\" но только те, которые будут добавлены последними"]
["Например: В январе выгрузили три колонки,они попали в лист данные, в феврале произвели выгрузку, залили на данный лист и теперь на листе Данные должны отобразиться февральские"]
["Но при этом на данном листе должны остаться и январские выгрузки."]