{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["реестр","данные","Лист1"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"реестр","index":0,"n_rows":12,"n_cols":17,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Информационная таблица на :",null,{"$f":"TODAY()","v":"2018-11-16"},null,null,"Данные по дислокации вагонов",null,null,null,null,null,"Должно быть так"]
["Номер  тр.средства","Дата  отгрузки","Дата прихода ","Дата там. оформления","Остаток ,км  движения","Статус","Индекс поезда","Операция","Дата операции","Станция операции","Расстояние до ст.назначения",null,"Индекс поезда","Операция","Дата операции","Станция операции","Расстояние до ст.назначения"]
[52680782,"2018-11-06","2018-11-12","2018-11-13",0,{"$f":"IF(B6=\"\",\"запланировано\",IF(C6=\"\",IF(E6>=200,\"в дороге\",\"на подходе\"),IF(AND(C6<>\"\",D6<>\"\")=FALSE,\"на таможне\",IF(AND(C6<>\"\",D6<>\"\")=TRUE,\"приб.\",\"\"))))","v":"приб."},{"$f":"VLOOKUP(A6,данные!$A$5:$F$9,2,FALSE)","v":"0+0+0"},{"$f":"VLOOKUP(A6,данные!$A$5:$F$9,3,FALSE)","v":"РАСФ"},{"$f":"VLOOKUP(A6,данные!$A$5:$F$9,4,FALSE)","v":"12.11.2018 17:04:00"},{"$f":"VLOOKUP(A6,данные!$A$5:$F$9,5,FALSE)","v":"Ирпень"},{"$f":"VLOOKUP(A6,данные!$A$5:$F$9,6,FALSE)","v":0},null,"0+0+0","РАСФ","12.11.2018 17:04:00","Ирпень",0]
[52647989,"2018-11-08",null,null,280,"в дороге",{"$f":"VLOOKUP(A7,данные!$A$5:$F$9,2,FALSE)","v":"0+0+1"},{"$f":"VLOOKUP(A7,данные!$A$5:$F$9,3,FALSE)","v":"ОТПР"},{"$f":"VLOOKUP(A7,данные!$A$5:$F$9,4,FALSE)","v":"11.11.2018 11:40:00"},{"$f":"VLOOKUP(A7,данные!$A$5:$F$9,5,FALSE)","v":"Брянск-Льговский"},{"$f":"VLOOKUP(A7,данные!$A$5:$F$9,6,FALSE)","v":280},null,"0+0+1","ОТПР","11.11.2018 11:40:00","Брянск-Льговский",280]
[23054968,"2018-11-04",null,null,650,"в дороге",{"$f":"VLOOKUP(A8,данные!$A$5:$F$9,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A8,данные!$A$5:$F$9,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A8,данные!$A$5:$F$9,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A8,данные!$A$5:$F$9,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A8,данные!$A$5:$F$9,6,FALSE)=0","v":{"$error":"#N/A"}}]
[26150995,null,null,null,null,"запланировано",{"$f":"VLOOKUP(A9,данные!$A$5:$F$9,2,FALSE)","v":"0+0+0"},{"$f":"VLOOKUP(A9,данные!$A$5:$F$9,3,FALSE)","v":"СВПП"},{"$f":"VLOOKUP(A9,данные!$A$5:$F$9,4,FALSE)","v":43419.354166666664},{"$f":"VLOOKUP(A9,данные!$A$5:$F$9,5,FALSE)","v":"Светогорск"},{"$f":"VLOOKUP(A9,данные!$A$5:$F$9,6,FALSE)","v":2000},null,"0+0+0","СВПП","2018-11-15T08:30:00","Светогорск",2000]
[52676947,null,null,null,null,"запланировано",{"$f":"VLOOKUP(A10,данные!$A$5:$F$9,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A10,данные!$A$5:$F$9,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A10,данные!$A$5:$F$9,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A10,данные!$A$5:$F$9,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A10,данные!$A$5:$F$9,6,FALSE)","v":{"$error":"#N/A"}}]
[52634375,"2018-11-03","2018-11-11",null,null,"на таможне",{"$f":"VLOOKUP(A11,данные!$A$5:$F$9,2,FALSE)","v":"0+0+5"},{"$f":"VLOOKUP(A11,данные!$A$5:$F$9,3,FALSE)","v":"ОТЦ"},{"$f":"VLOOKUP(A11,данные!$A$5:$F$9,4,FALSE)","v":43419.211111111108},{"$f":"VLOOKUP(A11,данные!$A$5:$F$9,5,FALSE)","v":"Ирпень"},{"$f":"VLOOKUP(A11,данные!$A$5:$F$9,6,FALSE)","v":0},null,"0+0+5","ОТЦ","2018-11-15T05:04:00","Ирпень",0]
[24373755,"2018-11-06",null,null,100,"на подходе",{"$f":"VLOOKUP(A12,данные!$A$5:$F$9,2,FALSE)","v":"0+0+6"},{"$f":"VLOOKUP(A12,данные!$A$5:$F$9,3,FALSE)","v":"ОТПР"},{"$f":"VLOOKUP(A12,данные!$A$5:$F$9,4,FALSE)","v":43418.631944444445},{"$f":"VLOOKUP(A12,данные!$A$5:$F$9,5,FALSE)","v":"Нежин"},{"$f":"VLOOKUP(A12,данные!$A$5:$F$9,6,FALSE)","v":100},null,"0+0+6","ОТПР","2018-11-14T15:10:00","Нежин",100]

{"sheet":"данные","index":1,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Номер вагона","Индекс поезда","Операция","Дата операции","Станция операции","Расстояние до ст.назначения"]
[52647989,"0+0+1","ОТПР","11.11.2018 11:40:00","Брянск-Льговский",280]
[52680782,"0+0+0","РАСФ","12.11.2018 17:04:00","Ирпень",0]
[24373755,"0+0+6","ОТПР","2018-11-14T15:10:00","Нежин",100]
[26150995,"0+0+0","СВПП","2018-11-15T08:30:00","Светогорск",2000]
[52634375,"0+0+5","ОТЦ","2018-11-15T05:04:00","Ирпень",0]

{"sheet":"Лист1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}