{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Рабочий лист","инфо","Лист2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":11,"comments":2,"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":33,"n_cols":14,"rows_kept":33,"cut":false,"hidden":false,"merged":[[3,10,3,11],[5,10,5,11],[2,9,2,11],[4,1,4,2],[5,1,5,3],[7,1,7,3],[3,2,3,3],[3,6,3,7],[5,6,5,7],[10,1,10,2],[10,4,10,5],[10,7,10,8],[13,8,13,9],[14,8,14,9],[16,8,16,9],[17,8,17,9],[13,10,13,11],[14,10,14,11],[16,10,16,11],[17,10,17,11],[15,0,15,11],[13,4,13,5],[16,4,16,5],[14,4,14,5],[17,4,17,5],[13,6,13,7],[14,6,14,7],[16,6,16,7],[17,6,17,7],[13,0,13,1],[14,0,14,1],[16,0,16,1],[17,0,17,1],[14,13,22,15],[35,1,35,2],[36,1,36,2],[22,1,22,2],[22,3,22,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[28,3,28,4],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[30,5,30,7],[13,13,13,15],[35,3,35,4],[36,3,36,4],[29,3,29,4],[30,3,30,4],[31,3,31,4],[32,3,32,4],[33,3,33,4],[34,3,34,4],[13,2,13,3],[14,2,14,3],[16,2,16,3],[17,2,17,3],[32,5,32,7],[33,5,33,7],[26,13,36,15],[22,10,22,11],[22,5,22,7],[23,5,23,7],[24,5,24,7],[25,5,25,7],[26,5,26,7],[27,5,27,7],[31,5,31,7],[25,13,25,15],[35,10,35,11],[36,10,36,11],[20,0,20,11],[4,10,4,11],[0,0,1,11],[30,10,30,11],[31,10,31,11],[32,10,32,11],[33,10,33,11],[34,10,34,11],[34,5,34,7],[35,5,35,7],[36,5,36,7],[23,10,23,11],[24,10,24,11],[25,10,25,11],[26,10,26,11],[27,10,27,11],[28,10,28,11],[29,10,29,11],[28,5,28,7],[29,5,29,7]]}
[]
[]
[]
["№ заказа:","№…","2017-05-21",null,null,"Статус заявки:",null,null,null,"Исполнитель:","Исполнитель 1"]
[null,null,null,null,null,null,null,null,null,"Условия: ","%"]
["Исполнитель:","Исполнитель 1",null,null,null,"Договор №:",null,null,null,"Клиент:","Клиент 1"]
[]
["Клиент:","Клиент 1",null,null,null,null,null,null,null,null,"Выставлено:"]
[null,null,null,null,null,null,null,null,null,null,"Оплачено:"]
["Маршрут",null,null,null,null,null,null,null,null,null,"Долг:"]
["Откуда: ",null,null,"Перевалка:",null,null,"Куда:",null,null,null,"Прибыль:"]
[]
[]
["Заявка",null,"Груз готов",null,"Перегруз",null,"Нач. оформления",null,"Убыл на склад",null,"Принят клиентом",null,null,"Текущее состояние:"]
[]
[]
["Отгрузка",null,"Приб.на перевалку",null,"Прибыл на ТО",null,"Ок.оформления ",null,"Прибыл на склад",null,"Оплачен клиентом"]
[]
[]
[]
["Планируемые затраты: "]
[]
["№","Компания",null,"Контрагент",null,"Номенклатура",null,null,"Сумма ","Дата оплаты","Комментарии:"]
[1]
[2]
[3,null,null,null,null,null,null,null,null,null,null,null,null,"Особые отметки:"]
[4]
[5]
[6]
[7]
[8]
[9]
[10]

{"sheet":"инфо","index":1,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,5,0,7]]}
[null,null,null,null,null,"Маршрут"]
["Исполнитель","Статус заявки","Условия %","Исполнитель","контрагент","откуда","перевалка","куда"]
["Исполнитель 1","На расчете",1.4999999999999999E-2,"Исполнитель 1","контрагент 1","город 1","город 1","город 1"]
["Исполнитель 2","Согласование",0.02,"Исполнитель 2","контрагент 2","город 2","город 2","город 2"]
["Исполнитель 3","В работе",0.03,"Исполнитель 3","контрагент 3","город 3","город 3","город 3"]
["Исполнитель 4","Исполнен",3.5000000000000003E-2,"Исполнитель 4","контрагент 4","город 4","город 4","город 4"]
[null,"Проверен",0.04,null,"контрагент 5","город 5","город 5","город 5"]
[null,"Закрыт",4.4999999999999998E-2,null,"контрагент 6","город 6","город 6","город 6"]
[null,null,0.05,null,null,"город 7",null,"город 7"]
[null,null,5.5E-2,null,null,"город 8",null,"город 8"]
[null,null,0.06,null,null,"город 9",null,"город 9"]
["Клиент ",null,6.5000000000000002E-2,"Клиент ",null,"город 10",null,"город 10"]
["клиент 1",null,7.0000000000000007E-2,"клиент 1",null,"город 11",null,"город 11"]
["клиент 2",null,7.4999999999999997E-2,"клиент 2",null,"город 12",null,"город 12"]
["клиент 3",null,0.08,"клиент 3",null,"город 13",null,"город 13"]
["клиент 4",null,8.5000000000000006E-2,"клиент 4",null,"город 14",null,"город 14"]
["клиент 5",null,0.09,"клиент 5",null,"город 15",null,"город 15"]
[null,null,9.5000000000000001E-2,null,null,"город 16",null,"город 16"]
[null,null,0.1,null,null,"город 17",null,"город 17"]
[null,null,0.105]

{"sheet":"Лист2","index":2,"n_rows":33,"n_cols":14,"rows_kept":33,"cut":false,"hidden":false,"merged":[[35,1,35,2],[35,3,35,4],[35,5,35,7],[35,10,35,11],[36,1,36,2],[36,3,36,4],[36,5,36,7],[36,10,36,11],[33,1,33,2],[33,3,33,4],[33,5,33,7],[33,10,33,11],[34,1,34,2],[34,3,34,4],[34,5,34,7],[34,10,34,11],[31,1,31,2],[31,3,31,4],[31,5,31,7],[31,10,31,11],[32,1,32,2],[32,3,32,4],[32,5,32,7],[32,10,32,11],[29,1,29,2],[29,3,29,4],[29,5,29,7],[29,10,29,11],[30,1,30,2],[30,3,30,4],[30,5,30,7],[30,10,30,11],[27,1,27,2],[27,3,27,4],[27,5,27,7],[27,10,27,11],[28,1,28,2],[28,3,28,4],[28,5,28,7],[28,10,28,11],[25,1,25,2],[25,3,25,4],[25,5,25,7],[25,10,25,11],[25,13,25,15],[26,1,26,2],[26,3,26,4],[26,5,26,7],[26,10,26,11],[26,13,36,15],[23,1,23,2],[23,3,23,4],[23,5,23,7],[23,10,23,11],[24,1,24,2],[24,3,24,4],[24,5,24,7],[24,10,24,11],[17,10,17,11],[20,0,20,11],[22,1,22,2],[22,3,22,4],[22,5,22,7],[22,10,22,11],[16,2,16,3],[16,4,16,5],[16,6,16,7],[16,8,16,9],[16,10,16,11],[17,0,17,1],[17,2,17,3],[17,4,17,5],[17,6,17,7],[17,8,17,9],[13,13,13,15],[14,0,14,1],[14,2,14,3],[14,4,14,5],[14,6,14,7],[14,8,14,9],[14,10,14,11],[14,13,22,15],[15,0,15,11],[16,0,16,1],[13,0,13,1],[13,2,13,3],[13,4,13,5],[13,6,13,7],[13,8,13,9],[13,10,13,11],[5,1,5,3],[5,6,5,7],[5,10,5,11],[7,1,7,3],[10,1,10,2],[10,4,10,5],[10,7,10,8],[0,0,1,11],[2,9,2,11],[3,2,3,3],[3,6,3,7],[3,10,3,11],[4,1,4,2],[4,10,4,11]]}
[]
[]
[]
["№ заказа:","№…","2017-05-03",null,null,"Статус заявки:",null,null,null,"Исполнитель:","Исполнитель 1"]
[null,null,null,null,null,null,null,null,null,"Условия: ","%"]
["Исполнитель:","Исполнитель 1",null,null,null,"Договор №:",null,null,null,"Клиент:","Клиент 1"]
[]
["Клиент:","Клиент 1",null,null,null,null,null,null,null,null,"Выставлено:"]
[null,null,null,null,null,null,null,null,null,null,"Оплачено:"]
["Маршрут",null,null,null,null,null,null,null,null,null,"Долг:"]
["Откуда: ",null,null,"Перевалка:",null,null,"Куда:",null,null,null,"Прибыль:"]
[]
[]
["Заявка",null,"Груз готов",null,"Перегруз",null,"Нач. оформления",null,"Убыл на склад",null,"Принят клиентом",null,null,"Текущее состояние:"]
[null,null,"2017-05-08",null,"2017-08-16"]
[]
["Отгрузка",null,"Приб.на перевалку",null,"Прибыл на ТО",null,"Ок.оформления ",null,"Прибыл на склад",null,"Оплачен клиентом"]
[null,null,"2017-05-20"]
[]
[]
["Планируемые затраты: "]
[]
["№","Компания",null,"Контрагент",null,"Номенклатура",null,null,"Сумма ","Дата оплаты","Комментарии:"]
[1]
[2]
[3,null,null,null,null,null,null,null,null,null,null,null,null,"Особые отметки:"]
[4]
[5]
[6]
[7]
[8]
[9]
[10]