{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Бюджет командировки"],"not_rendered":{"charts":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Бюджет командировки","index":0,"n_rows":16,"n_cols":7,"rows_kept":16,"merged":[[0,1,0,6],[1,1,1,2],[1,3,1,4],[1,5,2,5],[2,1,2,2],[2,3,2,4],[3,1,3,2],[3,3,3,4]]}
[null,"Бюджет командировки"]
[null,"Целевой бюджет поездки",null,{"v":2500,"d":"2,500.00 ₽"},null,null,{"$f":"D3","v":{"v":2369.3599999999997,"d":"2,369.36 ₽"}}]
[null,"Общая стоимость поездки",null,{"$f":"SUBTOTAL(9,Данные[Сумма])","v":{"v":2369.3599999999997,"d":"2,369.36 ₽"}},null,null,{"$f":"D2","v":{"v":2500,"d":"2,500.00 ₽"}}]
[null,{"$f":"IF(D2>D3,\"Из бюджета доступно\",\"Вы превысили бюджет на\")","v":"Из бюджета доступно"},null,{"$f":"(D2-D3)","v":{"v":130.64000000000033,"d":"130.64 ₽"}}]
[null,"Позиция","Описание","Стоимость","Кол-во","Сумма","Заметки"]
[null,"Авиабилеты","Билеты",{"v":300,"d":"300.00 ₽"},1,{"$f":"Данные[[#This Row],[Кол-во]]*Данные[[#This Row],[Стоимость]]","v":{"v":300,"d":"300.00 ₽"}}]
[null,"Авиабилеты","Билеты",{"v":350,"d":"350.00 ₽"},1,{"$f":"Данные[[#This Row],[Кол-во]]*Данные[[#This Row],[Стоимость]]","v":{"v":350,"d":"350.00 ₽"}}]
[null,"Гостиница","Комната",{"v":125,"d":"125.00 ₽"},3,{"$f":"Данные[[#This Row],[Кол-во]]*Данные[[#This Row],[Стоимость]]","v":{"v":375,"d":"375.00 ₽"}}]
[null,"Гостиница","Комната",{"v":150,"d":"150.00 ₽"},3,{"$f":"Данные[[#This Row],[Кол-во]]*Данные[[#This Row],[Стоимость]]","v":{"v":450,"d":"450.00 ₽"}}]
[null,"Аренда автомобиля","Стоимость за день",{"v":52,"d":"52.00 ₽"},6,{"$f":"Данные[[#This Row],[Кол-во]]*Данные[[#This Row],[Стоимость]]","v":{"v":312,"d":"312.00 ₽"}}]
[null,"Бензин","Стоимость литра",{"v":1.74,"d":"1.74 ₽"},14,{"$f":"Данные[[#This Row],[Кол-во]]*Данные[[#This Row],[Стоимость]]","v":{"v":24.36,"d":"24.36 ₽"}}]
[null,"Развлечения","Сумма",{"v":130,"d":"130.00 ₽"},1,{"$f":"Данные[[#This Row],[Кол-во]]*Данные[[#This Row],[Стоимость]]","v":{"v":130,"d":"130.00 ₽"}}]
[null,"Подарки","Сумма",{"v":85,"d":"85.00 ₽"},1,{"$f":"Данные[[#This Row],[Кол-во]]*Данные[[#This Row],[Стоимость]]","v":{"v":85,"d":"85.00 ₽"}}]
[null,"Прочее","Сумма",{"v":55,"d":"55.00 ₽"},1,{"$f":"Данные[[#This Row],[Кол-во]]*Данные[[#This Row],[Стоимость]]","v":{"v":55,"d":"55.00 ₽"}}]
[null,"Еда","Стоимость за день",{"v":48,"d":"48.00 ₽"},6,{"$f":"Данные[[#This Row],[Кол-во]]*Данные[[#This Row],[Стоимость]]","v":{"v":288,"d":"288.00 ₽"}}]
[null,"Итого",{"$nulls":3},{"$f":"SUBTOTAL(109,Данные[Сумма])","v":{"v":2369.3599999999997,"d":"2,369.36 ₽"}}]