{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"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":"Sheet1","index":0,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["№ заказа","дата","ФИО",null,"План"]
[1,"2013-01-01","Петров",null,23]
[2,"2013-02-03","Иванов",null,35]
[1,"2013-04-24","Иванов",null,24]
[2,"2013-05-16","Сидоров",null,26]
[1,"2013-06-18","Сидоров",null,56]
[2,"2013-05-15","Петров",null,47]

{"sheet":"Sheet2","index":1,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["№ заказа","договор","дата","ФИО","Факт"]
[1,"14-5466","2013-01-01","Петров",25]
[2,"6547-234","2013-02-03","Петров",36]
[1,"54656-767","2013-04-24","Сидоров",48]
[2,"565-56","2013-05-16","Сидоров",23]
[1,"5667-5","2013-06-18","Иванов",56]
[2,"657-578","2013-05-15","Иванов",54]
[1,"6778-56","2013-03-19","Васечкин",35]

{"sheet":"Sheet3","index":2,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["№ заказа"]
[2,"например, здесь ставлю \"1\" и нижа формируется таблица с данными из таблиц листов 1 и 2. "]
[]
["ФИО","План","Факт"]
[null,null,null,null,null,"Формировать таблицу данных по номеру заказа (который будет указываться здесь в ячейке А2)"]
[null,null,null,null,null,"Данные в листах 1 и 2 постоянно увеличиваются и ФИО могут не совпадать."]
[null,null,null,null,null," Тогда по данным или факта или плана будет \"пусто\""]