{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Travel Expense Report"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Travel Expense Report","index":0,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[7,0,7,1],[37,7,37,9],[6,0,6,4],[6,5,6,10],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[4,0,4,4],[5,0,5,4],[7,3,7,4],[32,7,32,9],[39,0,39,2],[9,0,9,10],[10,1,10,10],[7,7,7,8],[8,7,8,8],[8,0,8,1],[8,3,8,4],[39,6,39,9],[32,0,32,6],[38,6,38,10],[38,0,38,3],[33,8,33,9],[34,8,34,9],[33,0,37,6]]}
["TRAVEL EXPENSE REPORT"]
[]
["Name"]
[]
["Address"]
[]
["City / State / Zip",null,null,null,null,"Iowa District East, 1100 Blairs Ferry Road, Marion IA  52302, 319/373-2112"]
[null,null,null,null,null,null,null,{"$f":"IF(($K$38)=0, \"$\", $K$38)","v":"$"}]
["Social Security Number",null,null,"Report Date",null,null,null,"Total Amount Due"]
[]
["PURPOSE OF TRIP:"]
["DATE:",null,null,null,null,null,null,null,null,null,"TOTALS"]
["Transportation"]
["Business Miles Traveled"]
["Mileage Allowance @ $0.49",{"$f":"IF(SUM(B14*0.49)=0, \"$\", SUM(B14*0.49))","v":"$"},{"$f":"IF(SUM(C14*0.49)=0, \"$\", SUM(C14*0.49))","v":"$"},{"$f":"IF(SUM(D14*0.49)=0, \"$\", SUM(D14*0.49))","v":"$"},{"$f":"IF(SUM(E14*0.49)=0, \"$\", SUM(E14*0.49))","v":"$"},{"$f":"IF(SUM(F14*0.49)=0, \"$\", SUM(F14*0.49))","v":"$"},{"$f":"IF(SUM(G14*0.49)=0, \"$\", SUM(G14*0.49))","v":"$"},{"$f":"IF(SUM(H14*0.49)=0, \"$\", SUM(H14*0.49))","v":"$"},{"$f":"IF(SUM(I14*0.49)=0, \"$\", SUM(I14*0.49))","v":"$"},{"$f":"IF(SUM(J14*0.49)=0, \"$\", SUM(J14*0.49))","v":"$"},{"$f":"IF(SUM(B15:J15)=0,\"$\",SUM(B15:J15))","v":"$"}]
["Airfare",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(B16:J16)=0,\"$\",SUM(B16:J16))","v":"$"}]
["Auto Rental",null,null,null,null,null,null,null,null,null,"$"]
["Taxi Cab",null,null,null,null,null,null,null,null,null,"$"]
["Shuttle",null,null,null,null,null,null,null,null,null,"$"]
["Parking & Tolls",null,null,null,null,null,null,null,null,null,"$"]
[null,null,null,null,null,null,null,null,null,null,"$"]
["Business Meals"]
["Breakfast",null,null,null,null,null,null,null,null,null,"$"]
["Lunch",null,null,null,null,null,null,null,null,null,"$"]
["Dinner",null,null,null,null,null,null,null,null,null,"$"]
["Business Meals for Others",null,null,null,null,null,null,null,null,null,"$"]
["Lodging"]
["Hotel / Motel",null,null,null,null,null,null,null,null,null,"$"]
["Telephone (Business-Use)",null,null,null,null,null,null,null,null,null,"$"]
["Other (explain below)",null,null,null,null,null,null,null,null,null,"$"]
["Miscellaneous (explain below)",null,null,null,null,null,null,null,null,null,"$"]
["DAILY TOTAL:",{"$f":"IF(SUM(B15:B31)=0,\"$\",SUM(B15:B31))","v":"$"},{"$f":"IF(SUM(C15:C31)=0,\"$\",SUM(C15:C31))","v":"$"},"$","$","$","$","$","$","$"]
["Explain - Other / Miscellaneous:",null,null,null,null,null,null,"Total Expenses",null,null,{"$f":"SUM(K15:K31)","v":0}]
[null,null,null,null,null,null,null,"Less:","Prepaid Airfare"]
[null,null,null,null,null,null,null,null,"Cash Advance"]
[null,null,null,null,null,null,null,null,"Other"]
[null,null,null,null,null,null,null,null,"Other"]
[null,null,null,null,null,null,null,"TOTAL EXPENSES DUE:",null,null,{"$f":"IF(SUM(K33-K34-K35-K36-K37)=0, \"$\", SUM(K33-K34-K35-K36-K37))","v":"$"}]
[]
["Traveler's Signature",null,null,"Date",null,null,"Approved",null,null,null,"Date"]