{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Travel Auth Request"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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 Auth Request","index":0,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
["None",null,"Mid Michigan College",null,null,null,null,"Clear Form"]
["College Vehicle",null,"Travel Authorization Request "]
["Personal Vehicle",null,"This form and all support may be submitted electronically to Susan Call at smcall@midmich.edu, after getting approval from your budget officer/supervisor."]
["Rental Car",null,"Name"]
["Bus/Train",null,"Business Purpose of Trip"]
["Taxi/Uber/Lyft"]
["None",null,"Destination"]
["Parking",null,null,"Enter dates in format mm/dd/yy"]
["Tolls",null,"Travel Dates                             From",null,"To"]
["Yes"]
["No",null,"Estimated Transportation Needs",null,{"$f":"IF(OR(C13=\"Personal Vehicle\",C14=\"Personal Vehicle\"),\"Multiply estimated personal vehicle miles by current rate of $.536 per mile\",\"\")","v":""}]
["I need help",null,"Ground Transportation","Amount",{"$f":"IF(OR(C13=\"College Vehicle\",C14=\"College Vehicle\"),\"Multiply estimated college vehicle miles by estimated fuel rate of $.18 per mile\",\"\")","v":""}]
["College P-Card",null,{"$f":"IF(B13,\"\",\"------select from drop down list------\")","v":"------select from drop down list------"},null,{"$f":"IF(AND(OR(C13=\"College Vehicle\",C13=\"Personal Vehicle\",C13=\"Rental Car\",C13=\"Bus\",C13=\"Taxi/Uber/Lyft\"),OR(D13=\"\",D13=0)),\"ENTER AMOUNT\",\"\")","v":""},"Attach support for amounts.  Examples include"]
["Personal Credit Card",null,{"$f":"IF(B14,\"\",\"------select from drop down list------\")","v":"------select from drop down list------"},null,{"$f":"IF(AND(OR(C14=\"College Vehicle\",C14=\"Personal Vehicle\",C14=\"Rental Car\",C14=\"Bus\",C14=\"Taxi/Uber/Lyft\"),OR(D14=\"\",D14=0)),\"ENTER AMOUNT\",\"\")","v":""},"MapQuest directions for mileage, airfare quote, "]
["Check",null,{"$f":"IF(AND(D13>0,(OR(C13=\"\",C13=\"------select from drop down list------\"))),\"YOU MUST SELECT A MODE OF TRANSPORTATION\",\"\")","v":""},{"$f":"IF(AND(D14>0,(OR(C14=\"\",C14=\"------select from drop down list------\"))),\"PLEASE SELECT MODE\",\"\")","v":""},null,"hotel reservation confirmation, conference agenda,"]
["I need help",null,"Other transportation expenses","Amount",null,"registration form, etc.  If you have been approved for"]
["Pick up",null,{"$f":"IF(B17,\"\",\"------select from drop down list------\")","v":"------select from drop down list------"},null,{"$f":"IF(AND(OR(C17=\"Parking\",C17=\"Tolls\"),OR(D17=\"\",D17=0)),\"ENTER AMOUNT\",\"\")","v":""},"PD funding, please attach a copy of your approval "]
["Mail directly to hotel",null,{"$f":"IF(B18,\"\",\"------select from drop down list------\")","v":"------select from drop down list------"},null,{"$f":"IF(AND(OR(C18=\"Parking\",C18=\"Tolls\"),OR(D18=\"\",D18=0)),\"ENTER AMOUNT\",\"\")","v":""},"email."]
["None",null,"GL Account Number (without dashes)",null,null,{"$f":"IF(AND(D20>0,D19=\"\"),\"ENTER ACCOUNT NUMBER\",\"\")","v":""}]
["Aisle",null,"Estimated Ground Transportation",{"$f":"D13+D14+D17+D18","v":0}]
["Window",null,{"$f":"IF(AND(D17>0,(OR(C17=\"\",C17=\"------select from drop down list------\"))),\"YOU MUST SELECT TYPE OF EXPENSE\",\"\")","v":""},{"$f":"IF(AND(D18>0,(OR(C18=\"\",C18=\"------select from drop down list------\"))),\"SELECT TYPE OF EXPENSE\",\"\")","v":""}]
["Other - See Notes",null,"Air Transportation (Must be purchased through Purchasing Manager)"]
["None",null,"Full Legal Name"]
["MBS - Saginaw",null,"Date of Birth"]
["DTW - Detroit",null,"Preferred Airport",{"$f":"IF(B25,\"\",\"select from drop down list\")","v":"select from drop down list"}]
["FNT - Flint",null,"Seating Preference",{"$f":"IF(B26,\"\",\"select from drop down list\")","v":"select from drop down list"}]
["LAN - Lansing",null,"GL Account Number (without dashes)",null,null,{"$f":"IF(AND(D28>0,D27=\"\"),\"ENTER ACCOUNT NUMBER\",\"\")","v":""}]
["GRR - Grand Rapids",null,"Estimated Airfare"]
["Other - See Notes",null,"Please attach an estimate based on an Internet search for tickets (use a program such as Travelocity); include baggage fees."]
[null,null,{"$f":"IF(AND(D28>0,D13=\"\"),\"If you need ground transportation to and from the airport, please estimate and enter in section above.\",\"\")","v":""}]
[null,null,"Estimated Lodging Needs"]
[null,null,"Are you making your own reservations?",{"$f":"IF(B32,\"\",\"select from drop down list\")","v":"select from drop down list"},{"$f":"IF(OR(D32=\"no\",D32=\"I need help\",D33=\"I need help\"),\"Please explain in notes section.\",\"\")","v":""}]
[null,null,"Payment Method",{"$f":"IF(B33,\"\",\"select from drop down list\")","v":"select from drop down list"},"If requesting check, you must attach hotel confirmation with amount"]
[null,null,"If requesting payment by check, date needed",null,"Hotel Name*"]
[null,null,"If requesting payment by check, delivery method",{"$f":"IF(B35,\"\",\"select from drop down list\")","v":"select from drop down list"},"Voucher Number (Business Services Use)"]
[null,null,"GL Account Number (without dashes)",null,null,{"$f":"IF(AND(D37>0,D36=\"\"),\"ENTER ACCOUNT NUMBER\",\"\")","v":""}]
[null,null,"Total Estimated Lodging"]
[null,null,"*If hotel is in Michigan, please ensure your estimate does not include state sales tax and take a copy of our"]
[null,null,"state sales tax exemption form to the hotel"]
[]
[null,null,"Estimated Meals & Entertainment"]
[null,null,"Amount",null,"Please provide support for entertainment requests"]
[null,null,"GL Account Number (without dashes)",null,null,{"$f":"IF(AND(D42>0,D43=\"\"),\"ENTER ACCOUNT NUMBER\",\"\")","v":""}]
[]
[null,null,"Registration and Conference Fees",null,"Attach conference registration form or invoice with amount"]
[null,null,"Payment Method",{"$f":"IF(B46,\"\",\"select from drop down list\")","v":"select from drop down list"},{"$f":"IF(D46=\"I need help\",\"Please explain in notes section.\",\"\")","v":""}]
[null,null,"For check, payable to"]
[null,null,"Mailing address"]
[null,null,"GL Account Number (without dashes)",null,null,{"$f":"IF(AND(D50>0,D49=\"\"),\"ENTER ACCOUNT NUMBER\",\"\")","v":""}]
[null,null,"Total Conference Fees"]
[]
[null,null,"Request Total",{"$f":"D20+D28+D37+D42+D50","v":0}]
[]
[null,null,"Requested by",null,null,null,"Date"]
[]
[null,null,"Budget Officer",null,null,null,"Date"]
[]
[null,null,"Business Services",null,null,null,"Date"]
[]
[null,null,"President (if required)",null,null,null,"Date"]
[]
[null,null,"Special Instructions or Notes:"]