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

{"sheet":"EXPENSES REPORT","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,"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 number"]
[null,"Department",{"$nulls":3},"Manager",{"$nulls":3},"Employee ID"]
[]
[null,"Date","Account","Description","Hotel","Transport","Fuel","Meals","Phone number","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 number])","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"}}]