{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Page 1","Page 2 (if necessary)","Page 3 Personal Auto Mileage"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":"Page 1","index":0,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[[26,11,28,11],[12,2,12,3],[9,10,9,11],[6,0,7,12],[9,1,9,3],[9,4,9,5],[9,6,9,7],[9,8,9,9],[13,2,13,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[25,0,25,2],[22,8,22,9],[15,2,15,3],[29,6,29,7],[30,6,30,7],[19,2,19,3],[20,2,20,3],[28,1,28,2],[38,11,38,12],[37,11,37,12],[36,11,36,12],[35,11,35,12],[24,4,25,11],[38,1,38,9],[37,1,37,5],[30,1,31,2],[27,1,27,2],[24,1,24,2],[26,1,26,2],[35,1,35,5],[36,1,36,5],[36,6,36,9],[31,6,31,7],[29,1,29,2],[0,0,0,12],[2,0,2,12],[21,2,21,3],[23,1,23,2],[10,2,10,3],[11,2,11,3],[22,0,22,2],[3,6,3,7],[3,9,3,10],[4,6,4,12],[4,4,4,5],[14,2,14,3],[3,1,3,3],[4,1,4,3]]}
["Travel Expense Voucher   "]
[]
[" (Only one trip per Voucher)"]
["Last Name:",null,null,null,null,"First Name:",null,null,"PLU ID:",null,null,"Dept:"]
["Phone/ext.:",null,null,null,"Address:"]
["State Business Purpose of Travel  (Must include dates, destinations, and, if applicable, exchange rates and names of other participants.):"]
[]
[]
["Itemize all expenses and attach original receipts (List PLU Purchasing Card charges under \"P-Card\"; list all other expenses under \"Other.\"):"]
["Travel Dates xx/xx/xx→",null,null,null,{"$f":"IF($B$10<>\"\", B10+1, \"\")","v":""},null,{"$f":"IF($B$10<>\"\", E10+1, \"\")","v":""},null,{"$f":"IF($B$10<>\"\", G10+1, \"\")","v":""},null,{"$f":"IF($B$10<>\"\", I10+1, \"\")","v":""},null,"TOTAL"]
[null,"P-Card","Other",null,"P-Card","Other","P-Card","Other","P-Card","Other","P-Card","Other","Page 1"]
["Air transportation",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B12:L12)","v":0}]
["Personal Car (Use Pg 3)",null,{"$f":"'Page 3 Personal Auto Mileage'!G25","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(C13)","v":0}]
["Transportation (Rental, Univ. vehicle…)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B14:L14)","v":0}]
["Meals: Breakfast",null,null,null,null,null,null,null,null,null,null,null,0]
["           Lunch",null,null,null,null,null,null,null,null,null,null,null,0]
["           Dinner",null,null,null,null,null,null,null,null,null,null,null,0]
["Lodging",null,null,null,null,null,null,null,null,null,null,null,0]
["Registration",null,null,null,null,null,null," ",null,null,null,null,0]
["Phone/Internet Charges",null,null,null,null,null,null,null,null,null,null,null,0]
["Other Charges (List in Comments)",null,null,null,null,null,null,null,null,null,null,null,0]
["Total Expenses ",{"$f":"SUM(B12:B21)","v":0},{"$f":"SUM(C12:D21)","v":0},null,{"$f":"SUM(E12:E21)","v":0},0,0,0,0,0,0,{"$f":"SUM(L12:L21)","v":0},{"$f":"SUM(M12:M21)","v":0}]
["Expense Summary",null,null,null,null,null,{"$f":"IF(M22=SUM(B22:L22),\" \",\"Your Totals Do Not Match !\")","v":" "},null,"Total Page #2:",null,{"$f":"SUM('Page 2 (if necessary)'!L17)","v":0}]
["Total Expenses (All pages)",{"$f":"SUM(M22)+'Page 2 (if necessary)'!L17","v":0},null,null,"Comments (List all PLU P-Cards used, include last 4 digits & cardholder name):",null,null,null,null,null,null,null,"BUSO "]
["Less PLU P-Card Charges (Note 3) ",{"$f":"SUM(B22,E22,G22,I22,K22)+'Page 2 (if necessary)'!J19","v":0},null,null,null,null,null,null,null,null,null,null,"USE ONLY"]
["Complete the following as necessary:"]
["Payments through A/P (Note 1)",null,null,null,null,"Note 1:","Previously paid or reimbursed through Accounts Payable",null,null,null,null,"Reimburse to Employee"]
[" Interdepartmental charges (Note 2)",null,null,null,null,"Note 2:","PLU van rental or other interdepartmental charges",null,null,null,null,null,"Front Desk"]
["Employee Travel Advance",null,null,null,null,"Note 3:","Charges using PLU Purchasing Card"]
["Less PLU P-Card ATM withdrawals",null,null,null,null," Banner FOAP:    ",null,null,null,null,null,"$"]
["          Due To:   PLU (If Negative) /",{"$f":"SUM(B24)-B25-B27-B28-B29-B30","v":0},null,null,null,null,null,null,null,null,null,"$","P-Card"]
["Employee (If Positive)",null,null,null,null,null,"XXXXXX   -",null,"XXXX -","XXXX -","XX","Amount"]
[]
["I understand that I am required to reimburse the University for any expenses not in compliance with PLU's Travel and Business Expense Policies  ",null,null,null,null,null,null,null,null,null,null,null,"A/R"]
["and that a completed Travel Expense Voucher is due in the Business Office within 20 days of my return date along with any Balance Due PLU."]
["Employee Signature:",null,null,null,null,null,null,null,null,null,"Date:"]
["Financial Manager Signature:","1. ",null,null,null,null,"2.",null,null,null,"Date:"]
["Dean/Director/Officer Signature:",null,null,null,null,null," (If required by traveler's department)",null,null,null,"Date:"]
[]
["Delivery Options (check one):","     ACH (Required for faculty/staff payees)",null,null,null,null,"      Mail ",null,"      Campus Mail",null,null,"      Hold for Pickup"]

{"sheet":"Page 2 (if necessary)","index":1,"n_rows":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":false,"merged":[[18,7,18,8],[17,7,17,8],[23,0,23,11],[0,0,0,11],[1,0,1,11],[2,1,2,2],[5,9,5,10],[5,1,5,2],[5,3,5,4],[5,5,5,6],[5,7,5,8],[3,1,3,2],[4,0,4,11],[2,5,2,6],[2,8,2,9],[3,5,3,11],[29,0,29,11],[19,0,19,11],[21,0,21,11],[20,0,20,11],[26,0,26,11],[28,0,28,11],[27,0,27,11],[24,0,24,11],[25,0,25,11],[22,0,22,11]]}
["Travel Expense Voucher  "]
[" (Only one trip and one PLU employee per Voucher)"]
["Last Name:",{"$f":"IF('Page 1'!B4:D4<>\"\", 'Page 1'!B4:D4, \"\")","v":""},null,null,"First Name:",{"$f":"IF('Page 1'!G4<>\"\", 'Page 1'!G4,\"\")","v":""},null,"PLU ID:",{"$f":"IF('Page 1'!J4<>\"\", 'Page 1'!J4,\"\")","v":""},null,"Dept:",{"$f":"IF('Page 1'!M4<>\"\", 'Page 1'!M4,\"\")","v":""}]
["Phone/ext.:",{"$f":"IF('Page 1'!B5:D5<>\"\",'Page 1'!B5:D5,\"\")","v":""},null,null,"Address:"]
["Itemize all expenses and attach original receipts  (List PLU Purchasing Card charges under P-Card, then list all other expenses under Other column):"]
["Travel Dates xx/xx/xx→",null,null,{"$f":"IF($B$6<>\"\", B6+1, \"\")","v":""},null,{"$f":"IF($B$6<>\"\", B6+ 2, \"\")","v":""},null,{"$f":"IF($B$6<>\"\", B6+ 3, \"\")","v":""},null,{"$f":"IF($B$6<>\"\", B6+ 4, \"\")","v":""},null,"TOTAL"]
[null,"P-Card","Other","P-Card","Other","P-Card","Other","P-Card","Other","P-Card","Other","Page 2"]
["Air transportation",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B8:K8)","v":0}]
["Other Transportation",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B9:K9)","v":0}]
["Meals: Breakfast",null,null,null,null,null,null,null,null,null,null,0]
["           Lunch",null,null,null,null,null,null,null,null,null,null,0]
["           Dinner",null,null,null,null,null,null,null,null,null,null,0]
["Lodging",null,null,null,null,null,null,null,null,null,null,0]
["Registration",null,null,null,null,null,null,null,null,null,null,0]
["Phone/Internet Charges",null,null,null,null,null,null,null,null,null,null,0]
["Other Misc. Charges (Desc.below)",null,null,null,null,null,null,null,null,null,null,0]
["Total Expenses ",{"$f":"SUM(B8:B16)","v":0},{"$f":"SUM(C8:C16)","v":0},{"$f":"SUM(D8:D16)","v":0},{"$f":"SUM(E8:E16)","v":0},0,0,0,0,0,0,{"$f":"SUM(L8:L16)","v":0}]
[null,null,null,null,null,null,null,"Page 2 total Other",null,{"$f":"SUM(C17,E17,G17,I17,K17)","v":0}]
["Other Misc. Charges/ Additional Comments:",null,null,null,null,null,null,"Page 2 total P-Card",null,{"$f":"SUM(B17,D17,F17,H17,J17)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["This is a place where additional explanations can be added to help clarify issues related to the trip, and/or to describe Other Misc. Charges listed   "]
["in the top section of this form. You can also specify a second FOAP and the corresponding amount that should be charged."]

{"sheet":"Page 3 Personal Auto Mileage","index":2,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[[26,0,26,6],[21,0,21,5],[9,0,9,6],[11,0,11,6],[20,4,20,5],[10,0,10,2],[25,0,25,6],[19,2,19,3],[13,2,13,3],[14,2,14,3],[22,0,22,5],[24,0,24,5],[20,2,20,3],[13,4,13,5],[19,4,19,5],[15,4,15,5],[15,2,15,3],[6,0,6,6],[18,2,18,3],[16,4,16,5],[7,5,7,6],[8,2,8,4],[7,2,7,4],[12,4,12,5],[14,4,14,5],[12,1,12,3],[17,4,17,5],[18,4,18,5],[16,2,16,3],[17,2,17,3],[1,0,1,6],[2,0,2,6],[3,0,3,6],[4,0,4,6],[5,0,5,5]]}
[]
["PACIFIC LUTHERAN UNIVERSITY"]
["AUTO MILEAGE FORM for use with the Travel Expense Voucher"]
["(For use by PLU employees and other authorized non-employees)"]
[]
[]
["* Note: Do not include any PLU purchase card charges on this form. "]
[null,"Name (Last) "]
[null,"(First)"]
[]
["Travel:"]
[]
["* Dates","* Roundtrip/Daily Travel",null,null,"* Business Purpose for Travel"]
["(mm/dd/yy)","From:","To:",null,"(Explain reason for mileage reimbursement)",null,"←(Specify if round trip)"]
[]
[]
[]
[]
[]
[]
[]
["Total Miles Traveled",null,null,null,null,null,{"$f":"SUM(G15:G21)","v":0}]
["Current PLU Mileage Reimbursement Rate (as of January 1, 2017)",null,null,null,null,null,0.53500000000000003]
[]
["Total Mileage Reimbursement",null,null,null,null,null,{"$f":"G22*G23","v":0}]
[]
[" * Data entry required in fields marked with asterisk; enter data in electronic format or print form for manual data entry."]