{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["EXPENSE REPORT"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"EXPENSE REPORT","index":0,"n_rows":22,"n_cols":12,"rows_kept":22,"merged":[[1,2,1,3],[1,5,1,6],[3,2,3,3],[3,6,3,7],[3,10,3,11],[4,2,4,3],[4,6,4,7],[4,10,4,11],[20,2,20,4],[20,6,20,8],[21,2,21,4],[21,6,21,8]]}
[null,"EXPENSE REPORT",{"$nulls":8},"For Office Use Only"]
[null,"PURPOSE:",null,null,"STATEMENT NUMBER:",null,null,"PAY PERIOD","FROM:",{"$f":"IF(COUNTA(ExpenseData[Date])=0,\"\",MIN(ExpenseData[Date]))","v":""},"TO:",{"$f":"IF(COUNTA(ExpenseData[Date])=0,\"\",MAX(ExpenseData[Date]))","v":""}]
[null,"EMPLOYEE INFORMATION:"]
[null,"NAME",{"$nulls":3},"POSITION",{"$nulls":3},"NI"]
[null,"DEPARTMENT",{"$nulls":3},"MANAGER",{"$nulls":3},"EMPLOYEE ID"]
[]
[null,"Date","Account","Description","Hotel","Transport","Fuel","Meals","Phone","Entertainment","Misc.","Total"]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[Hotel]:[Misc.]])","v":{"v":0,"d":"£0.00"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[Hotel]:[Misc.]])","v":{"v":0,"d":"£0.00"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[Hotel]:[Misc.]])","v":{"v":0,"d":"£0.00"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[Hotel]:[Misc.]])","v":{"v":0,"d":"£0.00"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[Hotel]:[Misc.]])","v":{"v":0,"d":"£0.00"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[Hotel]:[Misc.]])","v":{"v":0,"d":"£0.00"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[Hotel]:[Misc.]])","v":{"v":0,"d":"£0.00"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[Hotel]:[Misc.]])","v":{"v":0,"d":"£0.00"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[Hotel]:[Misc.]])","v":{"v":0,"d":"£0.00"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[Hotel]:[Misc.]])","v":{"v":0,"d":"£0.00"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[Hotel]:[Misc.]])","v":{"v":0,"d":"£0.00"}}]
[null,"Total",null,null,{"$f":"SUBTOTAL(109,ExpenseData[Hotel])","v":{"v":0,"d":"£0.00"}},{"$f":"SUBTOTAL(109,ExpenseData[Transport])","v":{"v":0,"d":"£0.00"}},{"$f":"SUBTOTAL(109,ExpenseData[Fuel])","v":{"v":0,"d":"£0.00"}},{"$f":"SUBTOTAL(109,ExpenseData[Meals])","v":{"v":0,"d":"£0.00"}},{"$f":"SUBTOTAL(109,ExpenseData[Phone])","v":{"v":0,"d":"£0.00"}},{"$f":"SUBTOTAL(109,ExpenseData[Entertainment])","v":{"v":0,"d":"£0.00"}},{"$f":"SUBTOTAL(109,ExpenseData[Misc.])","v":{"v":0,"d":"£0.00"}},{"$f":"SUBTOTAL(109,ExpenseData[Total])","v":{"v":0,"d":"£0.00"}}]
[{"$nulls":10},"SUBTOTAL",{"$f":"ExpenseData[[#Totals],[Total]]","v":{"v":0,"d":"£0.00"}}]
[null,"APPROVED:",{"$nulls":3},"NOTES: ",{"$nulls":4},"ADVANCES",{"v":0,"d":"£0.00"}]
[{"$nulls":10},"TOTAL",{"$f":"Subtotal-Advances","v":{"v":0,"d":"£0.00"}}]