{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["1","2","Option"],"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":"1","index":0,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,0,3,0],[1,5,1,7],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4]]}
[null,null,null,2013,"Если изменить год в ячейке D1, в таблице нужно чтобы  остальсь видны строки только по этому году"]
["Ботинки"]
["обувь рабочая","дата выдачи","срок носки","след. дата выдачи","выбрать только год",{"$f":"SUBTOTAL(2,F5:F8)","v":2},{"$f":"SUBTOTAL(2,G5:G8)","v":1},{"$f":"SUBTOTAL(2,H5:H8)","v":1},{"$f":"SUM(F3:H3)","v":4}]
[null,null,null,null,null,40,41,42]
[40,"2011-12-12",24,{"$f":"DATE(YEAR(B5),MONTH(B5)+C5,DAY(B5))","v":"2013-12-12"},{"$f":"D5","v":"2013-12-12"},{"$f":"IF($A5=F$4,VLOOKUP($A5,$A5:$D5,4,FALSE),\"нет\")","v":"2013-12-12"},"нет","нет"]
[40,"2010-05-12",12,{"$f":"DATE(YEAR(B6),MONTH(B6)+C6,DAY(B6))","v":"2011-05-12"},{"$f":"D6","v":"2011-05-12"},"2011-05-12","нет","нет"]
[41,"2011-01-12",24,{"$f":"DATE(YEAR(B7),MONTH(B7)+C7,DAY(B7))","v":"2013-01-12"},{"$f":"D7","v":"2013-01-12"},"нет","2013-01-12","нет"]
[42,"2010-06-12",24,{"$f":"DATE(YEAR(B8),MONTH(B8)+C8,DAY(B8))","v":"2012-06-12"},{"$f":"D8","v":"2012-06-12"},"нет","нет","2012-06-12"]

{"sheet":"2","index":1,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,5,1,7],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4]]}
[null,null,null,2013,"Если изменить год в ячейке D1, в таблице нужно чтобы  остальсь видны строки только по этому году"]
["Туфли"]
["обувь рабочая","дата выдачи","срок носки","след. дата выдачи","выбрать только год",{"$f":"SUBTOTAL(2,F5:F8)","v":2},{"$f":"SUBTOTAL(2,G5:G8)","v":1},{"$f":"SUBTOTAL(2,H5:H8)","v":1},{"$f":"SUM(F3:H3)","v":4}]
[null,null,null,null,null,40,41,42]
[40,"2011-12-12",24,{"$f":"DATE(YEAR(B5),MONTH(B5)+C5,DAY(B5))","v":"2013-12-12"},{"$f":"D5","v":"2013-12-12"},{"$f":"IF($A5=F$4,VLOOKUP($A5,$A5:$D5,4,FALSE),\"нет\")","v":"2013-12-12"},"нет","нет"]
[40,"2010-05-12",12,{"$f":"DATE(YEAR(B6),MONTH(B6)+C6,DAY(B6))","v":"2011-05-12"},{"$f":"D6","v":"2011-05-12"},"2011-05-12","нет","нет"]
[41,"2011-01-12",24,{"$f":"DATE(YEAR(B7),MONTH(B7)+C7,DAY(B7))","v":"2013-01-12"},{"$f":"D7","v":"2013-01-12"},"нет","2013-01-12","нет"]
[42,"2010-06-12",24,{"$f":"DATE(YEAR(B8),MONTH(B8)+C8,DAY(B8))","v":"2012-06-12"},{"$f":"D8","v":"2012-06-12"},"нет","нет","2012-06-12"]

{"sheet":"Option","index":2,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[null,"Год",2013]
[]
[null,"Ботинки",{"$f":"'2'!I3","v":4}]
[null,"Туфли",{"$f":"'1'!I3","v":4}]