{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Перевозки","Контрагенты","Учет перевозок"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":8,"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":4,"n_cols":18,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["п.п","Отправитель","Получатель","Плательщик","Домашка","ГАН","№ входящей ТТН","№ исходящей ТТН","Вид доставки","Направление откуда","Направление куда","Характер груза","Количество мест","Вес","Объем","Дата приемки","Дата сдачи\\отправки","Дата получения\\доставки"]
[{"$f":"IF(ISBLANK(#REF!),\"\",COUNTA($B$2:B2))","v":0}]
[{"$f":"IF(ISBLANK(#REF!),\"\",COUNTA($B$2:B3))","v":1},"з","з","з","з","з","з","з","з","з","з","з",8,8,8,"20.12.2016"]
[{"$f":"IF(ISBLANK(#REF!),\"\",COUNTA($B$2:B4))","v":2},"p","p","p","p","p","p","p","p","p","pp","p",9,9,9,"21/12/2016"]

{"sheet":"Контрагенты","index":1,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Контрагенты"]
[]
["з"]
["p"]

{"sheet":"Учет перевозок","index":2,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,"Сегодняшняя дата"]
[null,{"$f":"TODAY()","v":"2016-12-26"}]
[]
[]
[]
[null,"Организация","Дата последней перевозки","Переврыв между перевозками (дней)","Общее кол-во перевозок","Перевозок за последний месяц"]
[null,null,{"$f":"MAX(--IF(Перевозки!$B$2:$B$1986=B7,Перевозки!$P$2:$P$1986))","v":"00:00:00"},{"$f":"$B$2-[Дата последней перевозки]","v":42730},{"$f":"COUNTIF(Таблица1[Отправитель],B7)","v":0},{"$f":"COUNTIFS(Перевозки!$B:$B,B7,Перевозки!$P:$P,\">=\"&EOMONTH($B$2,-1)+1)","v":0}]
[null,"з",{"$f":"MAX(--IF(Перевозки!$B$2:$B$1986=B8,Перевозки!$P$2:$P$1986))","v":"2016-12-20"},{"$f":"$B$2-[Дата последней перевозки]","v":6},{"$f":"COUNTIF(Таблица1[Отправитель],B8)","v":1},{"$f":"COUNTIFS(Перевозки!$B:$B,B8,Перевозки!$P:$P,\">=\"&EOMONTH($B$2,-1)+1)","v":0}]
[null,"p",{"$f":"MAX(--IF(Перевозки!$B$2:$B$1986=B9,Перевозки!$P$2:$P$1986))","v":"2016-12-21"},{"$f":"$B$2-[Дата последней перевозки]","v":5},{"$f":"COUNTIF(Таблица1[Отправитель],B9)","v":1},{"$f":"COUNTIFS(Перевозки!$B:$B,B9,Перевозки!$P:$P,\">=\"&EOMONTH($B$2,-1)+1)","v":0}]