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

{"sheet":"Expense Report","index":0,"n_rows":45,"n_cols":10,"rows_kept":45,"merged":[[18,1,18,9],[27,1,27,9],[35,1,35,9],[40,1,43,4]]}
["COMPANY NAME"]
["EXPENSE REPORT"]
[]
[null,"EMPLOYEE:","Kim Abercrombie",{"$nulls":3},"AUTHORIZED BY:"]
[null,"DEPARTMENT:","Sales"]
[null,"WEEK ENDING:","2013-03-07",{"$nulls":3},"DATE:"]
[null,"MILEAGE RATE:",{"v":0.67,"d":"$0.67"}]
[]
[null,null,{"$f":"UPPER(TEXT(C10,\"dddd\"))","v":"FRIDAY"},{"$f":"UPPER(TEXT(D10,\"dddd\"))","v":"SATURDAY"},"SUNDAY","MONDAY","TUESDAY","WEDNESDAY","THURSDAY"]
[null,"TRANSPORTATION",{"$f":"WeekEnding-6","v":"2013-03-01"},{"$f":"WeekEnding-5","v":"2013-03-02"},{"$f":"WeekEnding-4","v":"2013-03-03"},{"$f":"WeekEnding-3","v":"2013-03-04"},{"$f":"WeekEnding-2","v":"2013-03-05"},{"$f":"WeekEnding-1","v":"2013-03-06"},{"$f":"WeekEnding","v":"2013-03-07"},"TOTAL"]
[null,"Miles Driven",{"v":145,"d":"145 "},{"$nulls":6},{"$f":"SUM(Transportation[[#This Row],[Day 1]:[Day 7]])","v":{"v":145,"d":"145 "}}]
[null,"Miles Reimbursement",{"$f":"C11*MileageRate","v":{"v":97.15,"d":"$97.15"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"SUM(Transportation[[#This Row],[Day 1]:[Day 7]])","v":{"v":97.15,"d":"$97.15"}}]
[null,"Parking And Tolls",{"$nulls":3},{"v":17,"d":"$17.00"},{"$nulls":3},{"$f":"SUM(Transportation[[#This Row],[Day 1]:[Day 7]])","v":{"v":17,"d":"$17.00"}}]
[null,"Auto Rental",{"v":79,"d":"$79.00"},null,null,{"v":79,"d":"$79.00"},{"$nulls":3},{"$f":"SUM(Transportation[[#This Row],[Day 1]:[Day 7]])","v":{"v":158,"d":"$158.00"}}]
[null,"Taxi / Limo",{"$nulls":7},{"$f":"SUM(Transportation[[#This Row],[Day 1]:[Day 7]])","v":{"v":0,"d":"$0.00"}}]
[null,"Other (Rail or Bus)",{"$nulls":7},{"$f":"SUM(Transportation[[#This Row],[Day 1]:[Day 7]])","v":{"v":0,"d":"$0.00"}}]
[null,"Airfare",{"$nulls":3},{"v":235,"d":"$235.00"},{"$nulls":3},{"$f":"SUM(Transportation[[#This Row],[Day 1]:[Day 7]])","v":{"v":235,"d":"$235.00"}}]
[null,"TOTAL",{"$f":"SUBTOTAL(109,C12:C17)","v":{"v":176.15,"d":"$176.15"}},{"$f":"SUBTOTAL(109,D12:D17)","v":{"v":0,"d":"$0.00"}},null,{"$f":"SUBTOTAL(109,F12:F17)","v":{"v":331,"d":"$331.00"}},{"$f":"SUBTOTAL(109,G12:G17)","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,H12:H17)","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,I12:I17)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(J12:J17)","v":{"v":507.15,"d":"$507.15"}}]
[]
[null,"LODGING & MEALS"]
[null,"Lodging",{"v":145,"d":"$145.00"},{"$nulls":6},{"$f":"SUM(LodgingMeals[[#This Row],[Day 1]:[Day 7]])","v":{"v":145,"d":"$145.00"}}]
[null,"Breakfast",{"v":11.49,"d":"$11.49"},{"$nulls":6},{"$f":"SUM(LodgingMeals[[#This Row],[Day 1]:[Day 7]])","v":{"v":11.49,"d":"$11.49"}}]
[null,"Lunch",{"v":12,"d":"$12.00"},{"$nulls":6},{"$f":"SUM(LodgingMeals[[#This Row],[Day 1]:[Day 7]])","v":{"v":12,"d":"$12.00"}}]
[null,"Dinner",{"v":17,"d":"$17.00"},{"$nulls":6},{"$f":"SUM(LodgingMeals[[#This Row],[Day 1]:[Day 7]])","v":{"v":17,"d":"$17.00"}}]
[null,"Snack",{"$f":"C24*MileageRate","v":{"v":11.39,"d":"$11.39"}},{"$nulls":6},{"$f":"SUM(LodgingMeals[[#This Row],[Day 1]:[Day 7]])","v":{"v":11.39,"d":"$11.39"}}]
[null,"Meals Subtotal",{"$f":"SUM(C22:C24)","v":{"v":40.49,"d":"$40.49"}},{"$f":"SUM(D22:D24)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"SUM(LodgingMeals[[#This Row],[Day 1]:[Day 7]])","v":{"v":40.49,"d":"$40.49"}}]
[null,"TOTAL",{"$f":"SUBTOTAL(109,C21,C26)","v":{"v":185.49,"d":"$185.49"}},{"$f":"SUBTOTAL(109,D21,D26)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"SUBTOTAL(109,J21,J26)","v":{"v":185.49,"d":"$185.49"}}]
[]
[null,"MISCELLANEOUS"]
[null,"Supplies",{"$nulls":7},{"$f":"SUM(Misc[[#This Row],[Day 1]:[Day 7]])","v":{"v":0,"d":"$0.00"}}]
[null,"Equipment",{"$nulls":7},{"$f":"SUM(Misc[[#This Row],[Day 1]:[Day 7]])","v":{"v":0,"d":"$0.00"}}]
[null,"Phone, Fax, Internet",{"$nulls":7},{"$f":"SUM(Misc[[#This Row],[Day 1]:[Day 7]])","v":{"v":0,"d":"$0.00"}}]
[null,"Other*",{"$nulls":7},{"$f":"SUM(Misc[[#This Row],[Day 1]:[Day 7]])","v":{"v":0,"d":"$0.00"}}]
[null,"Entertainment*",{"$nulls":3},{"v":199,"d":"$199.00"},{"$nulls":3},{"$f":"SUM(Misc[[#This Row],[Day 1]:[Day 7]])","v":{"v":199,"d":"$199.00"}}]
[null,"TOTAL",{"$f":"SUBTOTAL(109,Misc[Day 1])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,Misc[Day 2])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,Misc[Day 3])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,Misc[Day 4])","v":{"v":199,"d":"$199.00"}},{"$f":"SUBTOTAL(109,Misc[Day 5])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,Misc[Day 6])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,Misc[Day 7])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,Misc[Total])","v":{"v":199,"d":"$199.00"}}]
[]
[null,"GRAND TOTALS",{"$f":"SUM(Misc[[#Totals],[Day 1]],LodgingMeals[[#Totals],[Day 1]],Transportation[[#Totals],[Day 1]])","v":{"v":361.64,"d":"$361.64"}},{"$f":"SUM(Misc[[#Totals],[Day 2]],LodgingMeals[[#Totals],[Day 2]],Transportation[[#Totals],[Day 2]])","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(Misc[[#Totals],[Day 3]],LodgingMeals[[#Totals],[Day 3]],Transportation[[#Totals],[Day 3]])","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(Misc[[#Totals],[Day 4]],LodgingMeals[[#Totals],[Day 4]],Transportation[[#Totals],[Day 4]])","v":{"v":530,"d":"$530.00"}},{"$f":"SUM(Misc[[#Totals],[Day 5]],LodgingMeals[[#Totals],[Day 5]],Transportation[[#Totals],[Day 5]])","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(Misc[[#Totals],[Day 6]],LodgingMeals[[#Totals],[Day 6]],Transportation[[#Totals],[Day 6]])","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(Misc[[#Totals],[Day 7]],LodgingMeals[[#Totals],[Day 7]],Transportation[[#Totals],[Day 7]])","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(Misc[[#Totals],[Total]],LodgingMeals[[#Totals],[Total]],Transportation[[#Totals],[Total]])","v":{"v":891.64,"d":"$891.64"}}]
[]
[{"$nulls":9},"TOTAL EXPENSES"]
[null,"*Business Purpose for \"Entertainment\" and \"Other\" Items:",{"$nulls":7},{"$f":"SUM(J18,J27,J35)","v":{"v":891.64,"d":"$891.64"}}]
[{"$nulls":9},"ADVANCES"]
[]
[{"$nulls":9},"TOTAL REIMBURSEMENT"]
[{"$nulls":9},{"$f":"J40-J42","v":{"v":891.64,"d":"$891.64"}}]
[{"$nulls":9},"Please attach all receipts."]