{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Журнал расстояний и расходы"],"not_rendered":{"images":1,"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Журнал расстояний и расходы","index":0,"n_rows":20,"n_cols":9,"rows_kept":20}
[]
[]
[null,"Имя сотрудника",null,"Тариф за километр",{"v":0.27,"d":"0.27 ₽"}]
[null,"Код сотрудника",null,"За период",{"$f":"\"C \"&TEXT(MIN(B9:B19),\"Д.М.ГГ\")&\" до \"&TEXT(MAX(B9:B19),\"Д.М.ГГ\")","v":"C 9.5.18 до 9.5.18"}]
[null,"Описание автомобиля",null,"Общее расстояние",{"$f":"Общее_расстояние","v":10}]
[null,"Кем утверждено",null,"Общая компенсация",{"$f":"Общая_компенсация","v":{"v":2.7,"d":"2.70 ₽"}}]
[]
[null,"Дата","Пункт отправления","Пункт назначения","Описание или примечания","Начальное значение на одометре","Конечное значение на одометре","Расстояние","Компенсация"]
[null,"2018-05-09","Домашний офис","Northwind Traders","Встреча с клиентом",36098,36103,{"$f":"IFERROR(IF(OR(ISBLANK(F9),ISBLANK(G9)),0,G9-F9), \"\")","v":5},{"$f":"IFERROR(H9*$E$3, \"\")","v":{"v":1.35,"d":"1.35 ₽"}}]
[null,"2018-05-09","Northwind Traders","Домашний офис","Встреча с клиентом",36103,36108,{"$f":"IFERROR(IF(OR(ISBLANK(F10),ISBLANK(G10)),0,G10-F10), \"\")","v":5},{"$f":"IFERROR(H10*$E$3, \"\")","v":{"v":1.35,"d":"1.35 ₽"}}]
[{"$nulls":7},0,{"v":0,"d":"0.00 ₽"}]
[{"$nulls":7},0,{"v":0,"d":"0.00 ₽"}]
[{"$nulls":7},0,{"v":0,"d":"0.00 ₽"}]
[{"$nulls":7},0,{"v":0,"d":"0.00 ₽"}]
[{"$nulls":7},0,{"v":0,"d":"0.00 ₽"}]
[{"$nulls":7},0,{"v":0,"d":"0.00 ₽"}]
[{"$nulls":7},0,{"v":0,"d":"0.00 ₽"}]
[{"$nulls":7},0,{"v":0,"d":"0.00 ₽"}]
[{"$nulls":7},0,{"v":0,"d":"0.00 ₽"}]
[{"$nulls":6},"Итого",{"$f":"SUBTOTAL(109,Расходы[Расстояние])","v":10},{"$f":"SUBTOTAL(109,Расходы[Компенсация])","v":{"v":2.7,"d":"2.70 ₽"}}]