{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["ОТЧЕТ О РАСХОДАХ"],"not_rendered":{"images":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"ОТЧЕТ О РАСХОДАХ","index":0,"n_rows":23,"n_cols":12,"rows_kept":23,"merged":[[2,2,2,3],[2,5,2,6],[4,2,4,3],[4,6,4,7],[4,10,4,11],[5,2,5,3],[5,6,5,7],[5,10,5,11],[21,2,21,4],[21,6,21,8],[22,2,22,4],[22,6,22,8]]}
[]
[]
[null,"Назначение:",null,null,"Номер выписки:",null,null,"Период оплаты","с:",{"$f":"IF(COUNTA(ExpenseData[Дата])=0,\"\",MIN(ExpenseData[Дата]))","v":""},"до:",{"$f":"IF(COUNTA(ExpenseData[Дата])=0,\"\",MAX(ExpenseData[Дата]))","v":""}]
[null,"Сведения о сотруднике:"]
[null,"Имя",{"$nulls":3},"Должность",{"$nulls":3},"Номер страховки"]
[null,"Отдел",{"$nulls":3},"Руководитель",{"$nulls":3},"Код сотрудника"]
[]
[null,"Дата","Счет","Описание","Гостиница","Транспорт","Топливо","Питание","Телефон","Развлечения","Проч.","Итог"]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[Гостиница]:[Проч.]])","v":{"v":0,"d":"0.00 ₽"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[Гостиница]:[Проч.]])","v":{"v":0,"d":"0.00 ₽"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[Гостиница]:[Проч.]])","v":{"v":0,"d":"0.00 ₽"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[Гостиница]:[Проч.]])","v":{"v":0,"d":"0.00 ₽"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[Гостиница]:[Проч.]])","v":{"v":0,"d":"0.00 ₽"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[Гостиница]:[Проч.]])","v":{"v":0,"d":"0.00 ₽"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[Гостиница]:[Проч.]])","v":{"v":0,"d":"0.00 ₽"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[Гостиница]:[Проч.]])","v":{"v":0,"d":"0.00 ₽"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[Гостиница]:[Проч.]])","v":{"v":0,"d":"0.00 ₽"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[Гостиница]:[Проч.]])","v":{"v":0,"d":"0.00 ₽"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[Гостиница]:[Проч.]])","v":{"v":0,"d":"0.00 ₽"}}]
[null,"Итог",null,null,{"$f":"SUBTOTAL(109,ExpenseData[Гостиница])","v":{"v":0,"d":"0.00 ₽"}},{"$f":"SUBTOTAL(109,ExpenseData[Транспорт])","v":{"v":0,"d":"0.00 ₽"}},{"$f":"SUBTOTAL(109,ExpenseData[Топливо])","v":{"v":0,"d":"0.00 ₽"}},{"$f":"SUBTOTAL(109,ExpenseData[Питание])","v":{"v":0,"d":"0.00 ₽"}},{"$f":"SUBTOTAL(109,ExpenseData[Телефон])","v":{"v":0,"d":"0.00 ₽"}},{"$f":"SUBTOTAL(109,ExpenseData[Развлечения])","v":{"v":0,"d":"0.00 ₽"}},{"$f":"SUBTOTAL(109,ExpenseData[Проч.])","v":{"v":0,"d":"0.00 ₽"}},{"$f":"SUBTOTAL(109,ExpenseData[Итог])","v":{"v":0,"d":"0.00 ₽"}}]
[{"$nulls":10},"ПРОМЕЖУТОЧНЫЙ ИТОГ",{"$f":"ExpenseData[[#Totals],[Итог]]","v":{"v":0,"d":"0.00 ₽"}}]
[null,"Утверждено:",{"$nulls":3},"Заметки: ",{"$nulls":4},"АВАНСЫ",{"v":0,"d":"0.00 ₽"}]
[{"$nulls":10},"ИТОГ",{"$f":"Промежуточный_итог-Авансы","v":{"v":0,"d":"0.00 ₽"}}]