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

{"sheet":"EXPENSE REPORT","index":0,"n_rows":29,"n_cols":12,"rows_kept":29,"merged":[[0,10,0,11],[3,2,3,3],[6,2,6,3],[6,6,6,7],[6,10,6,11],[7,2,7,3],[7,6,7,7],[7,10,7,11],[27,2,27,4],[27,6,27,8],[28,2,28,4],[28,6,28,8]]}
[{"$nulls":10},"For Office Use Only"]
[null,"EXPENSE REPORT"]
[]
[null,"PURPOSE:",{"$nulls":3},"STATEMENT NUMBER:",{"$nulls":3},"PAY PERIOD:","FROM",{"$f":"IF(COUNTA(tblData[Date])=0,\"\",MIN(tblData[Date]))","v":""}]
[{"$nulls":10},"TO",{"$f":"IF(COUNTA(tblData[Date])=0,\"\",MAX(tblData[Date]))","v":""}]
[null,"EMPLOYEE INFORMATION:"]
[null,"NAME",{"$nulls":3},"POSITION",{"$nulls":3},"SSN"]
[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(tblData[[#This Row],[Hotel]:[Misc.]])","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":11},{"$f":"SUM(tblData[[#This Row],[Hotel]:[Misc.]])","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":11},{"$f":"SUM(tblData[[#This Row],[Hotel]:[Misc.]])","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":11},{"$f":"SUM(tblData[[#This Row],[Hotel]:[Misc.]])","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":11},{"$f":"SUM(tblData[[#This Row],[Hotel]:[Misc.]])","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":11},{"$f":"SUM(tblData[[#This Row],[Hotel]:[Misc.]])","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":11},{"$f":"SUM(tblData[[#This Row],[Hotel]:[Misc.]])","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":11},{"$f":"SUM(tblData[[#This Row],[Hotel]:[Misc.]])","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":11},{"$f":"SUM(tblData[[#This Row],[Hotel]:[Misc.]])","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":11},{"$f":"SUM(tblData[[#This Row],[Hotel]:[Misc.]])","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":11},{"$f":"SUM(tblData[[#This Row],[Hotel]:[Misc.]])","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":11},{"$f":"SUM(tblData[[#This Row],[Hotel]:[Misc.]])","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":11},{"$f":"SUM(tblData[[#This Row],[Hotel]:[Misc.]])","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":11},{"$f":"SUM(tblData[[#This Row],[Hotel]:[Misc.]])","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":11},{"$f":"SUM(tblData[[#This Row],[Hotel]:[Misc.]])","v":{"v":0,"d":"$0.00"}}]
[null,"Total",null,null,{"$f":"SUBTOTAL(109,tblData[Hotel])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,tblData[Transport])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,tblData[Fuel])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,tblData[Meals])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,tblData[Phone])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,tblData[Entertainment])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,tblData[Misc.])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,tblData[Total])","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":10},"SUBTOTAL",{"$f":"tblData[[#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"}}]