{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Калькулятор расходов на поездку"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Калькулятор расходов на поездку","index":0,"n_rows":31,"n_cols":9,"rows_kept":31,"merged":[[0,1,0,8],[2,1,2,2],[2,7,2,8],[8,2,8,4],[8,5,8,6]]}
[null,"Калькулятор расходов на поездку"]
[]
[null,"Введите предполагаемые расходы на километр",{"$nulls":5},"Общая стоимость поездки"]
[null,"₽ за километр",{"v":0.5,"d":"0.50 ₽"},{"$nulls":4},"Общий срок поездки",{"$f":"(F31&\"(дни)\"&\"/\"&G31&\"(ночи)\")","v":"2(дни)/2(ночи)"}]
[{"$nulls":7},"Общие затраты на километр",{"$f":"C4*E31","v":{"v":71,"d":"71.00 ₽"}}]
[{"$nulls":7},"Итого за жилье",{"$f":"H31","v":{"v":275,"d":"275.00 ₽"}}]
[{"$nulls":7},"Общие дополнительные расходы",{"$f":"I31","v":{"v":125,"d":"125.00 ₽"}}]
[]
[null,"Дата","Местоположение и расстояние",null,null,"Срок поездки",null,"Проживание"]
[null,"Дата поездки","Пункт отправления","Куда","Расстояние (в километрах)","Дни","Ночи","Жилье","Дополнительные расходы"]
[null,"2021-12-01","Москва","Тула",89,1,1,{"v":150,"d":"150.00 "},{"v":75,"d":"75.00 "}]
[null,"2021-12-02","Тула","Нижний Новгород",53,1,1,{"v":125,"d":"125.00 "},{"v":50,"d":"50.00 "}]
{"$rows_empty":18}
[null,"Итого",null,null,{"$f":"SUBTOTAL(109,tblExpense[Расстояние (в километрах)])","v":142},{"$f":"SUBTOTAL(109,tblExpense[Дни])","v":2},{"$f":"SUBTOTAL(109,tblExpense[Ночи])","v":2},{"$f":"SUBTOTAL(109,tblExpense[Жилье])","v":{"v":275,"d":"275.00 ₽"}},{"$f":"SUBTOTAL(109,tblExpense[Дополнительные расходы])","v":{"v":125,"d":"125.00 ₽"}}]