{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Sheet1","Sheet2","Sheet3","Лист1"],"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":12,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["№ заказа","дата","ФИО",null,"План"]
[{"$f":"CONCATENATE(K2,\"-\",L2)","v":"123-1"},"2013-01-01","Петров",null,23,null,null,null,null,null,123,1]
[{"$f":"CONCATENATE(K3,\"-\",L3)","v":"234-2"},"2013-02-03","Иванов",null,35,null,null,null,null,null,234,2]
[{"$f":"CONCATENATE(K4,\"-\",L4)","v":"123-1"},"2013-04-24","Иванов",null,24,null,null,null,null,null,123,1]
[{"$f":"CONCATENATE(K5,\"-\",L5)","v":"234-2"},"2013-05-16","Сидоров",null,26,null,null,null,null,null,234,2]
[{"$f":"CONCATENATE(K6,\"-\",L6)","v":"123-1"},"2013-06-18","Сидоров",null,56,null,null,null,null,null,123,1]
[{"$f":"CONCATENATE(K7,\"-\",L7)","v":"234-2"},"2013-05-15","Петров",null,47,null,null,null,null,null,234,2]

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

{"sheet":"Sheet3","index":2,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["№ заказа","Список заказов, сформированный с помощью \"проверки данных\", из которого выбираем заказ"]
["234-2",null,"Не работает nz = Range(\"A2\").Value"]
[]
["ФИО","План","Факт"]
["Иванов",35,54,null,null,"Формировать таблицу данных по номеру заказа (который будет указываться здесь в ячейке А2)"]
["Петров",47,36,null,null,"Данные в листах 1 и 2 постоянно увеличиваются и ФИО могут не совпадать."]
["Сидоров",26,23,null,null," Тогда по данным или факта или плана будет \"пусто\""]

{"sheet":"Лист1","index":3,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[{"$f":"CONCATENATE(B1,\"-\",C1)","v":"123-1"},123,1]
[{"$f":"CONCATENATE(B2,\"-\",C2)","v":"234-2"},234,2]