{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["реестр"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,null,"Информационная общая таблица"]
["Номер  тр.средства","Дата  отгрузки","Дата прихода на таможню","Дата таможенного оформления","Остаток ,км  движения","Остаток ,км/суток движения","Степень выполнения",null,"приб.","на таможне","в дороге","на подходе","запланировано"]
[111111111,"2018-06-01","2018-06-03","2018-06-03",0,null,{"$f":"IF(B6=\"\",\"запланировано\",IF(C6=\"\",\"в дороге\",IF(AND(C6<>\"\",D6<>\"\")=FALSE,\"на таможне\",IF(AND(C6<>\"\",D6<>\"\")=TRUE,\"приб.\",\"\"))))","v":"приб."},null,{"$f":"COUNTIF($A$6:$G$15,I$5)","v":2},{"$f":"COUNTIF($A$6:$G$15,J$5)","v":1},2,1,2]
[12345678,"2018-06-02","2018-06-04","2018-06-07",0,null,"приб."]
[87456324,"2018-06-06","2018-06-08",null,0,null,"на таможне"]
[55566666,"2018-06-07",null,null,400,null,"в дороге"]
[111111111,"2018-06-07",null,null,800,null,"в дороге"]
[111111113,null,null,null,2000,null,"запланировано"]
[111111111,null,null,null,2000,null,"запланировано"]
[111111178,"2018-06-03",null,null,200,null,"на подходе"]
[]
["Как прописать условие  для степени выполнения \"на подходе\""]
["Если  Остаток  км,движения  < 200"]
["  , то  cтепень выполнения \"на подходе\" иначе в дороге"]