{"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":8,"n_cols":18,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["п.п","Отправитель","Получатель","Плательщик","Домашка","ГАН","№ входящей ТТН","№ исходящей ТТН","Вид доставки","Направление откуда","Направление куда","Характер груза","Количество мест","Вес","Объем","Дата приемки","Дата сдачи\\отправки","Дата получения\\доставки"]
[{"$f":"IF(ISBLANK(#REF!),\"\",COUNTA($B$2:B2))","v":0}]
[{"$f":"IF(ISBLANK(#REF!),\"\",COUNTA($B$2:B3))","v":0}]
[{"$f":"IF(ISBLANK(#REF!),\"\",COUNTA($B$2:B4))","v":1},"щ","щ","щ","щ","щ","щ","щ","щ","щ","щ","щ",9,9,9,"15.12.16"]
[{"$f":"IF(ISBLANK(#REF!),\"\",COUNTA($B$2:B5))","v":2},"p","p","p","p","p","p","p","p","p","p","p",9,9,9,"2106-12-12"]
[{"$f":"IF(ISBLANK(#REF!),\"\",COUNTA($B$2:B6))","v":3},"o","o","o","o","o","o","o","o","o","o","o",9,9,9,"2016-12-15"]
[{"$f":"IF(ISBLANK(#REF!),\"\",COUNTA($B$2:B7))","v":4},"щ","o","o","o","o","o","щ","щ","щ","щ","ш",9,9,9,"18.12.16"]
[{"$f":"IF(ISBLANK(#REF!),\"\",COUNTA($B$2:B8))","v":5},"н","н","н","н","н","н","н","н","н","н","н",8,8,8,"15.12.16"]

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

{"sheet":"Учет перевозок","index":2,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,"Сегодняшняя дата"]
[null,{"$f":"TODAY()","v":"2016-12-19"}]
[]
[]
[]
[null,"Организация","Дата последней перевозки","Переврыв между перевозками (дней)","Общее кол-во перевозок","Кол-во перевозок за 1 месяц"]
[null,null,{"$f":"MAX(--IF(Перевозки!$B$2:$B$2000=B7,Перевозки!$P$2:$P$2000))","v":"00:00:00"},{"$f":"$B$2-Таблица2[Дата последней перевозки]","v":42723},{"$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$2000=B8,Перевозки!$P$2:$P$2000))","v":"2016-12-18"},{"$f":"$B$2-Таблица2[Дата последней перевозки]","v":1},{"$f":"COUNTIF(Таблица1[Отправитель],B8)","v":2},{"$f":"COUNTIFS(Перевозки!$B:$B,B8,Перевозки!$P:$P,\">=\"&EOMONTH($B$2,-1)+1)","v":0}]
[null,"p",{"$f":"MAX(--IF(Перевозки!$B$2:$B$2000=B9,Перевозки!$P$2:$P$2000))","v":"2106-12-12"},{"$f":"$B$2-Таблица2[Дата последней перевозки]","v":-32864},{"$f":"COUNTIF(Таблица1[Отправитель],B9)","v":1},{"$f":"COUNTIFS(Перевозки!$B:$B,B9,Перевозки!$P:$P,\">=\"&EOMONTH($B$2,-1)+1)","v":1}]
[null,"o",{"$f":"MAX(--IF(Перевозки!$B$2:$B$2000=B10,Перевозки!$P$2:$P$2000))","v":"2016-12-15"},{"$f":"$B$2-Таблица2[Дата последней перевозки]","v":4},{"$f":"COUNTIF(Таблица1[Отправитель],B10)","v":1},{"$f":"COUNTIFS(Перевозки!$B:$B,B10,Перевозки!$P:$P,\">=\"&EOMONTH($B$2,-1)+1)","v":1}]
[null,"н",{"$f":"MAX(--IF(Перевозки!$B$2:$B$2000=B11,Перевозки!$P$2:$P$2000))","v":"2016-12-15"},{"$f":"$B$2-Таблица2[Дата последней перевозки]","v":4},{"$f":"COUNTIF(Таблица1[Отправитель],B11)","v":1},{"$f":"COUNTIFS(Перевозки!$B:$B,B11,Перевозки!$P:$P,\">=\"&EOMONTH($B$2,-1)+1)","v":0}]