{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Авансовый отчет"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Авансовый отчет","index":0,"n_rows":15,"n_cols":12,"rows_kept":15,"merged":[[1,1,2,11],[3,2,3,3],[3,6,3,7],[6,2,6,3],[6,6,6,7],[6,10,6,11],[7,2,7,3],[7,6,7,7],[7,10,7,11],[14,2,14,4],[14,6,14,8],[16,2,16,4],[16,6,16,8]]}
[{"$nulls":9},"Для внутреннего пользования"]
[null,"Авансовый отчет"]
[]
[null,"Назначение:",{"$nulls":3},"Номер выписки:",{"$nulls":3},"Платежный период:","С",{"$f":"MIN(Таблица1[Дата])","v":null}]
[{"$nulls":10},"По",{"$f":"MAX(Таблица1[Дата])","v":null}]
[null,"Сведения о сотруднике:"]
[null,"Имя",{"$nulls":3},"Должность",{"$nulls":3},"ИНН"]
[null,"Отдел",{"$nulls":3},"Руководитель",{"$nulls":3},"Код сотрудника"]
[]
[null,"Дата","Счет","Описание","Гостиница","Транспорт","Бензин","Питание","Телефон","Представительские расходы","Прочие","Итого"]
[{"$nulls":11},{"$f":"SUM(Таблица1[[#This Row],[Гостиница]:[Прочие]])","v":null}]
[null,"Итого",null,null,{"$f":"SUBTOTAL(109,[Гостиница])","v":null},{"$f":"SUBTOTAL(109,[Транспорт])","v":null},{"$f":"SUBTOTAL(109,[Бензин])","v":null},{"$f":"SUBTOTAL(109,[Питание])","v":null},{"$f":"SUBTOTAL(109,[Телефон])","v":null},{"$f":"SUBTOTAL(109,[Представительские расходы])","v":null},{"$f":"SUBTOTAL(109,[Прочие])","v":null},{"$f":"SUBTOTAL(109,[Итого])","v":null}]
[{"$nulls":10},"Всего",{"$f":"SUM(Таблица1[[#Totals],[Итого]])","v":null}]
[{"$nulls":10},"Денежные авансы"]
[null,"Утверждено:",{"$nulls":3},"Примечания: ",{"$nulls":4},"Итого",{"$f":"(L13-L14)","v":null}]