{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","In-State","Out-of-State","Out-of-Country","Travel Questionnaire"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"Instructions","index":0,"n_rows":65,"n_cols":24,"rows_kept":65,"cut":false,"hidden":false,"merged":[[43,0,43,5],[43,7,43,11],[48,0,48,1],[51,0,51,3],[38,0,38,7],[39,0,39,7],[40,0,40,10],[41,0,41,10],[42,0,42,5],[42,7,42,11],[45,0,45,5],[45,7,45,11],[46,0,46,5],[46,7,46,11],[37,0,37,7],[25,1,25,4],[26,1,26,4],[27,1,27,4],[28,1,28,4],[29,1,29,4],[30,1,30,4],[31,1,31,4],[32,1,32,4],[33,1,33,4],[34,1,34,4],[13,13,13,14],[13,15,13,17],[24,1,24,4],[15,1,15,4],[16,1,16,4],[17,1,17,4],[18,1,18,4],[19,1,19,4],[20,1,20,4],[20,13,20,17],[21,1,21,4],[21,13,22,17],[22,1,22,4],[23,1,23,4],[14,1,14,4],[8,0,8,1],[8,3,8,5],[8,7,8,8],[9,0,9,1],[9,3,9,5],[9,7,9,8],[23,13,23,17],[3,0,3,5],[3,7,3,11],[0,7,0,11],[2,0,2,5],[2,7,2,11],[0,0,0,5],[11,0,12,11],[13,1,13,4],[13,5,13,6],[4,0,4,5],[4,7,4,11],[5,0,5,5],[5,7,5,11],[6,0,6,5],[6,7,6,11],[32,13,36,17],[27,13,27,14],[28,13,28,14],[24,13,24,14],[25,16,25,17],[24,16,24,17],[25,13,25,14],[31,13,31,17]]}
["State of South Dakota",null,null,null,null,null,null,"In-State Travel Payment Detail"]
[]
["Payee",null,null,null,null,null,null,"Institution & Department"]
[]
[]
[]
[]
[]
["Banner Vendor ID",null,null,"Auto License Number",null,null,null,"Home Station"]
[]
[]
["** If travel reimbursement includes students, \"Student Travel Questionnaire\" (found on Separate tab) form must be completed and submitted with the travel reimbursement."]
[]
["Date","Description of Travel, Destination,",null,null,null,"Time",null,"Auto","Trans.",null,null,"Misc.",null,"Meal Rates",null,"Schedule for Computing Meal Allowances:"]
["(Month/Day/Yr)","Meals, Mileage, Misc. Expense",null,null,null,"Leave","Return","Miles","Costs","Meals","Lodging","Expense",null,null,null,"Leave post of duty before",null,"Return to post of duty after"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(A16),\"\",SUM(V16:X16))","v":""},null,null,null,"Breakfast",6,"05:31:00",null,"07:59:00",null,null,null,{"$f":"IF(AND(OR(ISBLANK(F16),F16<$P$16), OR(ISBLANK(G16),G16>$R$16)),6,0)","v":6},{"$f":"IF(AND(OR(ISBLANK(F16),F16<$P$17), OR(ISBLANK(G16),G16>$R$17)),14,0)","v":14},{"$f":"IF(AND(OR(ISBLANK(F16),F16<$P$18), OR(ISBLANK(G16),G16>$R$18)),20,0)","v":20}]
["2023-08-11","Meals not Overnight",null,null,null,"08:00:00","18:00:00",null,null,{"$f":"IF(ISBLANK(A17),\"\",SUM(V17:X17))","v":14},null,null,null,"Lunch",14,"11:31:00",null,"12:59:00",null,null,null,{"$f":"IF(AND(OR(ISBLANK(F17),F17<$P$16), OR(ISBLANK(G17),G17>$R$16)),6,0)","v":0},{"$f":"IF(AND(OR(ISBLANK(F17),F17<$P$17), OR(ISBLANK(G17),G17>$R$17)),14,0)","v":14},{"$f":"IF(AND(OR(ISBLANK(F17),F17<$P$18), OR(ISBLANK(G17),G17>$R$18)),20,0)","v":0}]
[null,null,null,null,null,null,null,null,null,"",null,null,null,"Dinner",20,"17:31:00",null,"19:59:00",null,null,null,6,14,20]
["2023-08-12","To Meeting",null,null,null,"14:00:00",null,null,null,20,null,null,null,"All Day",40,null,null,null,null,null,null,0,0,20]
["2023-08-13","Meeting",null,null,null,null,null,null,null,40,null,null,null,null,null,null,null,null,null,null,null,6,14,20]
["2023-08-14","Home from Meeting",null,null,null,null,"17:00:00",null,null,20,null,null,null,"Lodging",null,null,null,null,null,null,null,6,14,0]
[null,null,null,null,null,null,null,null,null,"",null,null,null,"Original Receipt Required; In State Rate of $110.00 + Taxes & Mandatory fees.",null,null,null,null,null,null,null,6,14,20]
["2023-08-15","To Conference",null,null,null,"14:00:00",null,null,null,20,null,null,null,null,null,null,null,null,null,null,null,0,0,20]
["2023-08-16","Conference (Dinner Provided)",null,null,null,null,null,null,null,20,null,null,null,"Exceptions:",null,null,null,null,null,null,null,6,14,20]
["2023-08-17","Home from Conference",null,null,null,null,"17:00:00",null,null,{"$f":"IF(ISBLANK(A25),\"\",SUM(V25:X25))","v":20},null,null,null,"Desitination",null,null,null,null,null,null,null,6,14,0]
[null,null,null,null,null,null,null,null,null,"",null,null,null,"(all cities within county)",null,"Timeframe","Rate",null,null,null,null,6,14,20]
[null,null,null,null,null,null,null,null,null,"",null,null,null,"Lawrence County",null,"May-October","$140 + Taxes & Mandatory Fees",null,null,null,null,6,14,20]
[null,null,null,null,null,null,null,null,null,"",null,null,null,"Fall River/Custer County",null,"June-September","$161 + Taxes & Mandatory Fees",null,null,null,null,6,14,20]
[null,null,null,null,null,null,null,null,null,"",null,null,null,"Pennington County",null,"June-August","$158 + Taxes & Mandatory Fees",null,null,null,null,6,14,20]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,6,14,20]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,6,14,20]
[null,null,null,null,null,null,null,null,null,"",null,null,null,"Mileage Reimbursement",null,null,null,null,null,null,null,{"$f":"IF(AND(OR(ISBLANK(F32),F32<$P$16), OR(ISBLANK(G32),G32>$R$16)),6,0)","v":6},{"$f":"IF(AND(OR(ISBLANK(F32),F32<$P$17), OR(ISBLANK(G32),G32>$R$17)),14,0)","v":14},{"$f":"IF(AND(OR(ISBLANK(F32),F32<$P$18), OR(ISBLANK(G32),G32>$R$18)),20,0)","v":20}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(A33),\"\",SUM(V33:X33))","v":""},null,null,null,"If an employee or student uses a privately owned vehicle when a Fleet vehicle is available, reimbursement is $0.302 per mile.  Reimbursement rate is $0.67 per mile in the following circumstances:\n1. Individual is a non-employee\n2. No Fleet vehicles are available (form from Fleet is required to be attached)\n3. Employee's home station is in a remote location where no Fleet vehicles are available",null,null,null,null,null,null,null,{"$f":"IF(AND(OR(ISBLANK(F33),F33<$P$16), OR(ISBLANK(G33),G33>$R$16)),6,0)","v":6},{"$f":"IF(AND(OR(ISBLANK(F33),F33<$P$17), OR(ISBLANK(G33),G33>$R$17)),14,0)","v":14},{"$f":"IF(AND(OR(ISBLANK(F33),F33<$P$18), OR(ISBLANK(G33),G33>$R$18)),20,0)","v":20}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(A34),\"\",SUM(V34:X34))","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(OR(ISBLANK(F34),F34<$P$16), OR(ISBLANK(G34),G34>$R$16)),6,0)","v":6},{"$f":"IF(AND(OR(ISBLANK(F34),F34<$P$17), OR(ISBLANK(G34),G34>$R$17)),14,0)","v":14},{"$f":"IF(AND(OR(ISBLANK(F34),F34<$P$18), OR(ISBLANK(G34),G34>$R$18)),20,0)","v":20}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(A35),\"\",SUM(V35:X35))","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(OR(ISBLANK(F35),F35<$P$16), OR(ISBLANK(G35),G35>$R$16)),6,0)","v":6},{"$f":"IF(AND(OR(ISBLANK(F35),F35<$P$17), OR(ISBLANK(G35),G35>$R$17)),14,0)","v":14},{"$f":"IF(AND(OR(ISBLANK(F35),F35<$P$18), OR(ISBLANK(G35),G35>$R$18)),20,0)","v":20}]
[null,null,null,null,null,null,null,"Subtotals",{"$f":"SUM(I16:I35)","v":0},{"$f":"SUM(J16:J35)","v":154},{"$f":"SUM(K16:K35)","v":0},{"$f":"SUM(L16:L35)","v":0}]
["Purpose of Travel:",null,null,null,null,null,null,null,null,null,"Grand Total",{"$f":"SUM(I36:L36)","v":154}]
[null,null,null,null,null,null,null,null,null,null,"Amount of Travel Advance",-50]
[null,null,null,null,null,null,null,null,null,null,"Amount Reimbursable",{"$f":"SUM(L37:L38)","v":104}]
[]
["I declare and affirm under the penalties of perjury that this claim has been examined by me, and to the best of my knowledge and belief, is in all things true and correct."]
["I further agree to comply with the provisions of the Civil Rights Act of 1964 and regulations issued thereunder relating to non-discrimination in federally assisted programs."]
[]
["Claimant Signature                          Date",null,null,null,null,null,null,"Authorizing Signature                               Date"]
[]
[]
["Claimant Printed Name                            ",null,null,null,null,null,null,"Authorizing Agent Printed Name                        "]
[]
[]
[]
[]
["Coding References Only",null,null,null,"Seq.","Index","Fund","Org","Account","Prog","Activity","Amount"]
[null,null,"Commodity","Account","01"]
["Standard Mileage",null,75500,733020,"02"]
["Mileage POV1 ",null,75500,733030,"03"]
["Commercial Airfare",null,75500,733060,"04"]
["Car Rental, Shuttle,Taxi",null,75500,733080,"05"]
["Student Travel",null,75500,733090,"06"]
["Lodging",null,75500,733100,"07"]
["Incidentals",null,75500,733120,"08"]
["Non-Employee Travel",null,75500,733130,"09"]
["Meals Not Overnight",null,75500,733140,10]
["Meals Overnight",null,75500,733150,11]
["Registration Fees",null,70000,744160,12]
["Other",null,75500,null,13]

{"sheet":"In-State","index":1,"n_rows":66,"n_cols":24,"rows_kept":66,"cut":false,"hidden":false,"merged":[[0,0,0,5],[45,0,45,5],[45,7,45,11],[46,0,46,5],[46,7,46,11],[41,0,41,10],[37,0,37,7],[3,0,3,5],[4,0,4,5],[2,0,2,5],[8,7,8,8],[8,3,8,5],[8,0,8,1],[0,7,0,11],[5,7,5,11],[2,7,2,11],[49,7,49,8],[49,9,49,11],[51,0,51,3],[49,2,49,4],[27,1,27,4],[28,1,28,4],[29,1,29,4],[30,1,30,4],[48,0,48,1],[32,1,32,4],[38,0,38,7],[39,0,39,7],[43,0,43,5],[43,7,43,11],[42,0,42,5],[42,7,42,11],[3,7,3,11],[4,7,4,11],[5,0,5,5],[6,0,6,5],[6,7,6,11],[13,13,13,14],[13,15,13,17],[11,0,12,11],[9,7,9,8],[17,1,17,4],[9,3,9,5],[9,0,9,1],[13,5,13,6],[13,1,13,4],[14,1,14,4],[15,1,15,4],[40,0,40,10],[16,1,16,4],[18,1,18,4],[19,1,19,4],[25,1,25,4],[26,1,26,4],[20,1,20,4],[21,1,21,4],[34,1,34,4],[23,1,23,4],[33,1,33,4],[24,1,24,4],[22,1,22,4],[28,13,28,14],[31,13,31,17],[32,13,36,17],[31,1,31,4],[20,13,20,17],[21,13,22,17],[27,13,27,14],[23,13,23,17],[24,13,24,14],[24,16,24,17],[25,13,25,14],[25,16,25,17]]}
["State of South Dakota",null,null,null,null,null,null,"In-State Travel Payment Detail"]
[]
["Payee",null,null,null,null,null,null,"Institution & Department"]
[]
[]
[]
[]
[]
["Banner Vendor ID",null,null,"Auto License Number",null,null,null,"Home Station"]
[]
[]
["** If travel reimbursement includes students or Graduate Assistants, \"Travel Questionnaire\" (found on Separate tab) form must be completed and submitted with the travel reimbursement."]
[]
["Date","Description of Travel, Destination,",null,null,null,"Time",null,"Auto","Trans.",null,null,"Misc.",null,"Meal Rates",null,"Schedule for Computing Meal Allowances:"]
["(Month/Day/Yr)","Meals, Mileage, Misc. Expense",null,null,null,"Leave","Return","Miles","Costs","Meals","Lodging","Expense",null,null,null,"Leave post of duty before",null,"Return to post of duty after"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(A16),\"\",SUM(V16:X16))","v":""},null,null,null,"Breakfast",6,"05:31:00",null,"07:59:00",null,null,null,{"$f":"IF(AND(OR(ISBLANK(F16),F16<$P$16), OR(ISBLANK(G16),G16>$R$16)),6,0)","v":6},{"$f":"IF(AND(OR(ISBLANK(F16),F16<$P$17), OR(ISBLANK(G16),G16>$R$17)),14,0)","v":14},{"$f":"IF(AND(OR(ISBLANK(F16),F16<$P$18), OR(ISBLANK(G16),G16>$R$18)),20,0)","v":20}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(A17),\"\",SUM(V17:X17))","v":""},null,null,null,"Lunch",14,"11:31:00",null,"12:59:00",null,null,null,{"$f":"IF(AND(OR(ISBLANK(F17),F17<$P$16), OR(ISBLANK(G17),G17>$R$16)),6,0)","v":6},{"$f":"IF(AND(OR(ISBLANK(F17),F17<$P$17), OR(ISBLANK(G17),G17>$R$17)),14,0)","v":14},{"$f":"IF(AND(OR(ISBLANK(F17),F17<$P$18), OR(ISBLANK(G17),G17>$R$18)),20,0)","v":20}]
[null,null,null,null,null,null,null,null,null,"",null,null,null,"Dinner",20,"17:31:00",null,"19:59:00",null,null,null,6,14,20]
[null,null,null,null,null,null,null,null,null,"",null,null,null,"All Day",40,null,null,null,null,null,null,6,14,20]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,6,14,20]
[null,null,null,null,null,null,null,null,null,"",null,null,null,"Lodging",null,null,null,null,null,null,null,6,14,20]
[null,null,null,null,null,null,null,null,null,"",null,null,null,"Original Receipt Required; In State Rate of $110.00 + Taxes & Mandatory fees.",null,null,null,null,null,null,null,6,14,20]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,6,14,20]
[null,null,null,null,null,null,null,null,null,"",null,null,null,"Exceptions:",null,null,null,null,null,null,null,6,14,20]
[null,null,null,null,null,null,null,null,null,"",null,null,null,"Desitination",null,null,null,null,null,null,null,6,14,20]
[null,null,null,null,null,null,null,null,null,"",null,null,null,"(all cities within county)",null,"Timeframe","Rate",null,null,null,null,6,14,20]
[null,null,null,null,null,null,null,null,null,"",null,null,null,"Lawrence County",null,"May-October","$140 + Taxes & Mandatory Fees",null,null,null,null,6,14,20]
[null,null,null,null,null,null,null,null,null,"",null,null,null,"Fall River/Custer County",null,"June-September","$161 + Taxes & Mandatory Fees",null,null,null,null,6,14,20]
[null,null,null,null,null,null,null,null,null,"",null,null,null,"Pennington County",null,"June-August","$158 + Taxes & Mandatory Fees",null,null,null,null,6,14,20]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,6,14,20]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,6,14,20]
[null,null,null,null,null,null,null,null,null,"",null,null,null,"Mileage Reimbursement",null,null,null,null,null,null,null,6,14,20]
[null,null,null,null,null,null,null,null,null,"",null,null,null,"If an employee or student uses a privately owned vehicle when a Fleet vehicle is available, reimbursement is $0.302 per mile.  Reimbursement rate is $0.67 per mile in the following circumstances:\n1. Individual is a non-employee\n2. No Fleet vehicles are available (form from Fleet is required to be attached)\n3. Employee's home station is in a remote location where no Fleet vehicles are available",null,null,null,null,null,null,null,6,14,20]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,6,14,20]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,6,14,20]
[null,null,null,null,null,null,null,"Subtotals",{"$f":"SUM(I16:I35)","v":0},{"$f":"SUM(J16:J35)","v":0},{"$f":"SUM(K16:K35)","v":0},{"$f":"SUM(L16:L35)","v":0}]
["Purpose of Travel:",null,null,null,null,null,null,null,null,null,"Grand Total",{"$f":"SUM(I36:L36)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Amount of Travel Advance",0]
[null,null,null,null,null,null,null,null,null,null,"Amount Reimbursable",{"$f":"SUM(L37:L38)","v":0}]
[]
["I declare and affirm under the penalties of perjury that this claim has been examined by me, and to the best of my knowledge and belief, is in all things true and correct."]
["I further agree to comply with the provisions of the Civil Rights Act of 1964 and regulations issued thereunder relating to non-discrimination in federally assisted programs."]
[]
["Claimant Signature                          Date",null,null,null,null,null,null,"Authorizing Signature                               Date"]
[]
[{"$f":"IF(ISBLANK(A4)=FALSE(),A4,IF(ISBLANK(A5)=FALSE(),A5,IF(ISBLANK(A6)=FALSE,A6,IF(ISBLANK(A7)=FALSE,A7,\"\"))))","v":""}]
["Claimant Printed Name                            ",null,null,null,null,null,null,"Authorizing Agent Printed Name                        "]
[]
["Office Use Only"]
["Vendor Invoice #",null,null,null,null,null,null,"Banner Invoice #"]
[]
["Coding References Only",null,null,null,"Seq.","Index","Fund","Org","Account","Prog","Activity","Amount"]
[null,null,"Commodity","Account","01"]
["Standard Mileage",null,75500,733020,"02",null,null,null,733020]
["Mileage POV1 ",null,75500,733030,"03",null,null,null,733030]
["Commercial Airfare",null,75500,733060,"04",null,null,null,733060]
["Car Rental, Shuttle,Taxi",null,75500,733080,"05",null,null,null,733080]
["Student Travel",null,75500,733090,"06",null,null,null,733090]
["Lodging",null,75500,733100,"07",null,null,null,733100]
["Incidentals",null,75500,733120,"08",null,null,null,733120]
["Non-Employee Travel",null,75500,733130,"09",null,null,null,733130]
["Meals Not Overnight",null,75500,733140,10,null,null,null,733140]
["Meals Overnight",null,75500,733150,11,null,null,null,733150]
["Registration Fees",null,70000,744160,12,null,null,null,744160]
["Other",null,75500,null,13]
[null,null,null,null,null,null,null,null,"Balance?",{"$f":"IF(L66=L37,\"Yes\",\"No\")","v":"Yes"},"Total",{"$f":"SUM(L53:L65)","v":0}]

{"sheet":"Out-of-State","index":2,"n_rows":66,"n_cols":24,"rows_kept":66,"cut":false,"hidden":false,"merged":[[0,0,0,5],[11,0,12,11],[3,0,3,5],[3,7,3,11],[0,7,0,11],[2,0,2,5],[2,7,2,11],[4,0,4,5],[4,7,4,11],[5,0,5,5],[5,7,5,11],[6,0,6,5],[6,7,6,11],[8,0,8,1],[8,3,8,5],[8,7,8,8],[9,0,9,1],[9,3,9,5],[9,7,9,8],[20,13,20,17],[13,1,13,4],[13,5,13,6],[13,13,13,14],[13,15,13,17],[14,1,14,4],[15,1,15,4],[16,1,16,4],[17,1,17,4],[18,1,18,4],[19,1,19,4],[20,1,20,4],[21,1,21,4],[21,13,22,17],[22,1,22,4],[23,1,23,4],[23,13,26,17],[24,1,24,4],[25,1,25,4],[26,1,26,4],[41,0,41,10],[27,1,27,4],[28,1,28,4],[28,13,28,17],[29,1,29,4],[29,13,33,17],[30,1,30,4],[31,1,31,4],[32,1,32,4],[33,1,33,4],[34,1,34,4],[37,0,37,7],[38,0,38,7],[39,0,39,7],[40,0,40,10],[51,0,51,3],[42,0,42,5],[42,7,42,11],[43,0,43,5],[43,7,43,11],[48,0,48,1],[49,7,49,8],[49,9,49,11],[49,2,49,4],[45,0,45,5],[45,7,45,11],[46,0,46,5],[46,7,46,11]]}
["State of South Dakota",null,null,null,null,null,null,"Out-of-State Travel Payment Detail"]
[]
["Payee",null,null,null,null,null,null,"Institution & Department"]
[]
[]
[null,null,null,null,null,null,null," "]
[]
[]
["Banner Vendor ID",null,null,"Auto License Number",null,null,null,"Home Station"]
[]
[]
["** If travel reimbursement includes students or Graduate Assistants, \"Travel Questionnaire\" (found on Separate tab) form must be completed and submitted with the travel reimbursement."]
[]
["Date","Description of Travel, Destination,",null,null,null,"Time",null,"Auto","Trans.",null,null,"Misc.",null,"Meal Rates",null,"Schedule for Computing Meal Allowances:"]
["(Month/Day/Yr)","Meals, Mileage, Misc. Expense",null,null,null,"Leave","Return","Miles","Costs","Meals","Lodging","Expense",null,null,null,"Leave post of duty before",null,"Return to post of duty after"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(A16),\"\",SUM(V16:X16))","v":""},null,null,null,"Breakfast",10,"05:31:00",null,"07:59:00",null,null,null,{"$f":"IF(AND(OR(ISBLANK(F16),F16<$P$16), OR(ISBLANK(G16),G16>$R$16)),10,0)","v":10},{"$f":"IF(AND(OR(ISBLANK(F16),F16<$P$17), OR(ISBLANK(G16),G16>$R$17)),18,0)","v":18},{"$f":"IF(AND(OR(ISBLANK(F16),F16<$P$18), OR(ISBLANK(G16),G16>$R$18)),28,0)","v":28}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(A17),\"\",SUM(V17:X17))","v":""},null,null,null,"Lunch",18,"11:31:00",null,"12:59:00",null,null,null,{"$f":"IF(AND(OR(ISBLANK(F17),F17<$P$16), OR(ISBLANK(G17),G17>$R$16)),10,0)","v":10},{"$f":"IF(AND(OR(ISBLANK(F17),F17<$P$17), OR(ISBLANK(G17),G17>$R$17)),18,0)","v":18},{"$f":"IF(AND(OR(ISBLANK(F17),F17<$P$18), OR(ISBLANK(G17),G17>$R$18)),28,0)","v":28}]
[null,null,null,null,null,null,null,null,null,"",null,null,null,"Dinner",28,"17:31:00",null,"19:59:00",null,null,null,10,18,28]
[null,null,null,null,null,null,null,null,null,"",null,null,null,"All Day",56,null,null,null,null,null,null,10,18,28]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,10,18,28]
[null,null,null,null,null,null,null,null,null,"",null,null,null,"Lodging",null,null,null,null,null,null,null,10,18,28]
[null,null,null,null,null,null,null,null,null,"",null,null,null,"5:01:02:11.  Out-of-State per diem rates. The per diem rates for official state travel outside South Dakota are as follows:",null,null,null,null,null,null,null,10,18,28]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,10,18,28]
[null,null,null,null,null,null,null,null,null,"",null,null,null,"Original Receipt Required; Out-of-State rate of $175.00 + tax per night; Excess lodging for additional $100.00 + tax may be requested. ",null,null,null,null,null,null,null,10,18,28]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,10,18,28]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,10,18,28]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,10,18,28]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,10,18,28]
[null,null,null,null,null,null,null,null,null,"",null,null,null,"Mileage Reimbursement",null,null,null,null,null,null,null,10,18,28]
[null,null,null,null,null,null,null,null,null,"",null,null,null,"If an employee or student uses a privately owned vehicle when a Fleet vehicle is available, reimbursement is $0.302 per mile.  Reimbursement rate is $0.67 per mile in the following circumstances:\n1. Individual is a non-employee\n2. No Fleet vehicles are available (form from Fleet is required to be attached)\n3. Employee's home station is in a remote location where no Fleet vehicles are available",null,null,null,null,null,null,null,10,18,28]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,10,18,28]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,10,18,28]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,10,18,28]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(A34),\"\",SUM(V34:X34))","v":""},null,null,null,null,null,null,null,null,null,null,null,10,18,28]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(A35),\"\",SUM(V35:X35))","v":""},null,null,null,null,null,null,null,null,null,null,null,10,18,28]
[null,null,null,null,null,null,null,"Subtotals",{"$f":"SUM(I16:I35)","v":0},{"$f":"SUM(J16:J35)","v":0},{"$f":"SUM(K16:K35)","v":0},{"$f":"SUM(L16:L35)","v":0}]
["Purpose of Travel:",null,null,null,null,null,null,null,null,null,"Grand Total",{"$f":"SUM(I36:L36)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Amount of Travel Advance",0]
[null,null,null,null,null,null,null,null,null,null,"Amount Reimbursable",{"$f":"SUM(L37:L38)","v":0}]
[]
["I declare and affirm under the penalties of perjury that this claim has been examined by me, and to the best of my knowledge and belief, is in all things true and correct."]
["I further agree to comply with the provisions of the Civil Rights Act of 1964 and regulations issued thereunder relating to non-discrimination in federally assisted programs."]
[]
["Claimant Signature                          Date",null,null,null,null,null,null,"Authorizing Signature                               Date"]
[]
[{"$f":"IF(ISBLANK(A4)=FALSE(),A4,IF(ISBLANK(A5)=FALSE(),A5,IF(ISBLANK(A6)=FALSE,A6,IF(ISBLANK(A7)=FALSE,A7,\"\"))))","v":""}]
["Claimant Printed Name                           ",null,null,null,null,null,null,"Authorizing Agent Printed Name                     "]
[]
["Office Use Only"]
["Vendor Invoice #",null,null,null,null,null,null,"Banner Invoice #"]
[]
["Coding References Only",null,null,null,"Seq.","Index","Fund","Org","Account","Prog","Activity","Amount"]
[null,null,"Commodity","Account"]
["Standard Mileage",null,75500,733220,"01",null,null,null,733220]
["Mileage POV1 ",null,75500,733230,"02",null,null,null,733230]
["Commercial Airfare",null,75500,733260,"03",null,null,null,733260]
["Car Rental, Shuttle,Taxi",null,75500,733280,"04",null,null,null,733280]
["Student Travel",null,75500,733290,"05",null,null,null,733290]
["Lodging",null,75500,733300,"06",null,null,null,733300]
["Incidentals",null,75500,733320,"07",null,null,null,733320]
["Non-Employee Travel",null,75500,733330,"08",null,null,null,733330]
["Meals Not Overnight",null,75500,733340,"09",null,null,null,733340]
["Meals Overnight",null,75500,733350,10,null,null,null,733350]
["Registration Fees",null,70000,744160,11,null,null,null,744160]
["Other",null,75500,null,12]
[null,null,null,null,null,null,null,null,"Balance",{"$f":"IF(L66=L37,\"Yes\",\"No\")","v":"Yes"},"Total",{"$f":"SUM(L53:L65)","v":0}]

{"sheet":"Out-of-Country","index":3,"n_rows":65,"n_cols":24,"rows_kept":65,"cut":false,"hidden":false,"merged":[[0,0,0,5],[11,0,12,11],[3,0,3,5],[3,7,3,11],[0,7,0,11],[2,0,2,5],[2,7,2,11],[4,0,4,5],[4,7,4,11],[5,0,5,5],[5,7,5,11],[6,0,6,5],[6,7,6,11],[8,0,8,1],[8,3,8,5],[8,7,8,8],[9,0,9,1],[9,3,9,5],[9,7,9,8],[20,13,20,17],[13,1,13,4],[13,5,13,6],[13,13,13,14],[13,15,13,17],[14,1,14,4],[15,1,15,4],[16,1,16,4],[17,1,17,4],[18,1,18,4],[19,1,19,4],[20,1,20,4],[21,1,21,4],[21,13,22,17],[22,1,22,4],[23,1,23,4],[23,13,26,17],[24,1,24,4],[25,1,25,4],[26,1,26,4],[41,0,41,10],[27,1,27,4],[28,1,28,4],[28,13,28,17],[29,1,29,4],[29,13,33,17],[30,1,30,4],[31,1,31,4],[32,1,32,4],[33,1,33,4],[34,1,34,4],[37,0,37,7],[38,0,38,7],[39,0,39,7],[40,0,40,10],[51,0,51,3],[42,0,42,5],[42,7,42,11],[43,0,43,5],[43,7,43,11],[48,0,48,1],[49,7,49,8],[49,9,49,11],[49,2,49,4],[45,0,45,5],[45,7,45,11],[46,0,46,5],[46,7,46,11]]}
["State of South Dakota",null,null,null,null,null,null,"Out-of-Country Travel Payment Detail"]
[]
["Payee",null,null,null,null,null,null,"Institution & Department"]
[]
[]
[null,null,null,null,null,null,null," "]
[]
[]
["Banner Vendor ID",null,null,"Auto License Number",null,null,null,"Home Station"]
[]
[]
["** If travel reimbursement includes students or Graduate Assistants, \"Travel Questionnaire\" (found on Separate tab) form must be completed and submitted with the travel reimbursement."]
[]
["Date","Description of Travel, Destination,",null,null,null,"Time",null,"Auto","Trans.",null,null,"Misc.",null,"Meal Rates",null,"Schedule for Computing Meal Allowances:"]
["(Month/Day/Yr)","Meals, Mileage, Misc. Expense",null,null,null,"Leave","Return","Miles","Costs","Meals","Lodging","Expense",null,null,null,"Leave post of duty before",null,"Return to post of duty after"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(A16),\"\",SUM(V16:X16))","v":""},null,null,null,"Breakfast",10,"05:31:00",null,"07:59:00",null,null,null,{"$f":"IF(AND(OR(ISBLANK(F16),F16<$P$16), OR(ISBLANK(G16),G16>$R$16)),10,0)","v":10},{"$f":"IF(AND(OR(ISBLANK(F16),F16<$P$17), OR(ISBLANK(G16),G16>$R$17)),21,0)","v":21},{"$f":"IF(AND(OR(ISBLANK(F16),F16<$P$18), OR(ISBLANK(G16),G16>$R$18)),29,0)","v":29}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(A17),\"\",SUM(V17:X17))","v":""},null,null,null,"Lunch",21,"11:31:00",null,"12:59:00",null,null,null,{"$f":"IF(AND(OR(ISBLANK(F17),F17<$P$16), OR(ISBLANK(G17),G17>$R$16)),10,0)","v":10},{"$f":"IF(AND(OR(ISBLANK(F17),F17<$P$17), OR(ISBLANK(G17),G17>$R$17)),21,0)","v":21},{"$f":"IF(AND(OR(ISBLANK(F17),F17<$P$18), OR(ISBLANK(G17),G17>$R$18)),29,0)","v":29}]
[null,null,null,null,null,null,null,null,null,"",null,null,null,"Dinner",29,"17:31:00",null,"19:59:00",null,null,null,10,21,29]
[null,null,null,null,null,null,null,null,null,"",null,null,null,"All Day",60,null,null,null,null,null,null,10,21,29]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,10,21,29]
[null,null,null,null,null,null,null,null,null,"",null,null,null,"Room",null,null,null,null,null,null,null,10,21,29]
[null,null,null,null,null,null,null,null,null,"",null,null,null,"5:01:02:10.01.  Out-of-Country per diem rates. The per diem rates for official state travel outside the United States are as follows:",null,null,null,null,null,null,null,10,21,29]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,10,21,29]
[null,null,null,null,null,null,null,null,null,"",null,null,null,"Original Receipt Required; Out-of-Country rate of $175.00 + tax per night; Excess lodging for additional $100.00 + tax may be requested. ",null,null,null,null,null,null,null,10,21,29]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,10,21,29]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,10,21,29]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,10,21,29]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,10,21,29]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(A29),\"\",SUM(V29:X29))","v":""},null,null,null,"Mileage Reimbursement",null,null,null,null,null,null,null,10,21,29]
[null,null,null,null,null,null,null,null,null,"",null,null,null,"If an employee or student uses a privately owned vehicle when a Fleet vehicle is available, reimbursement is $0.302 per mile.  Reimbursement rate is $0.67 per mile in the following circumstances:\n1. Individual is a non-employee\n2. No Fleet vehicles are available (form from Fleet is required to be attached)\n3. Employee's home station is in a remote location where no Fleet vehicles are available",null,null,null,null,null,null,null,10,21,29]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,10,21,29]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,10,21,29]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,10,21,29]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,10,21,29]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,10,21,29]
[null,null,null,null,null,null,null,"Subtotals",{"$f":"SUM(I16:I35)","v":0},{"$f":"SUM(J16:J35)","v":0},{"$f":"SUM(K16:K35)","v":0},{"$f":"SUM(L16:L35)","v":0}]
["Purpose of Travel:",null,null,null,null,null,null,null,null,null,"Grand Total",{"$f":"SUM(I36:L36)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Amount of Travel Advance",0]
[null,null,null,null,null,null,null,null,null,null,"Amount Reimbursable",{"$f":"SUM(L37:L38)","v":0}]
[]
["I declare and affirm under the penalties of perjury that this claim has been examined by me, and to the best of my knowledge and belief, is in all things true and correct."]
["I further agree to comply with the provisions of the Civil Rights Act of 1964 and regulations issued thereunder relating to non-discrimination in federally assisted programs."]
[]
["Claimant Signature                          Date",null,null,null,null,null,null,"Authorizing Signature                               Date"]
[]
[{"$f":"IF(ISBLANK(A4)=FALSE(),A4,IF(ISBLANK(A5)=FALSE(),A5,IF(ISBLANK(A6)=FALSE,A6,IF(ISBLANK(A7)=FALSE,A7,\"\"))))","v":""}]
["Claimant Printed Name                            ",null,null,null,null,null,null,"Authorizing Agent Printed Name                        "]
[]
["Office Use Only"]
["Vendor Invoice #",null,null,null,null,null,null,"Banner Invoice #"]
[]
["Coding References Only",null,null,null,"Seq.","Index","Fund","Org","Account","Prog","Activity","Amount"]
[null,null,"Commodity","Account"]
["Standard Mileage",null,75500,733220,"01",null,null,null,733220]
["Mileage POV1 ",null,75500,733230,"02",null,null,null,733230]
["Commercial Airfare",null,75500,733380,"03",null,null,null,733380]
["Car Rental, Shuttle,Taxi",null,75500,733280,"04",null,null,null,733280]
["Student Travel",null,75500,733290,"05",null,null,null,733290]
["Lodging",null,75500,733360,"06",null,null,null,733360]
["Incidentals",null,75500,733390,"07",null,null,null,733390]
["Non-Employee Travel",null,75500,733330,"08",null,null,null,733330]
["Meals Overnight",null,75500,733370,"09",null,null,null,733370]
["Registration Fees",null,70000,744160,"10",null,null,null,744160]
["Other",null,75500,null,"11"]
[null,null,null,null,null,null,null,null,"Balance",{"$f":"IF(L65=L37,\"Yes\",\"No\")","v":"Yes"},"Total",{"$f":"SUM(L53:L64)","v":0}]

{"sheet":"Travel Questionnaire","index":4,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,2],[2,0,6,2],[8,0,9,2]]}
["Student/Graduate Assistant Travel Questionnaire "]
[]
["These questions MUST be answered if travel includes students (Graduate Research Assistants are included) and any portion of the travel expenses will be paid with University or Foundation funds. The purpose of these questions is to determine whether the expenses are considered a taxable benefit to the student."]
[]
[]
[]
[]
[]
["If these questions are not adequately answered and included with the submitted travel request, the direct pay document will be disapproved."]
[]
[]
[null,"Student/Graduate Assistant Name:"]
[]
[null,"Question","Answer"]
[1,"Please provide a detailed explanation on how this trip is a benefit to the University. "]
[2,"Is this trip required for a course or part of the student’s degree program?  If yes, please explain."]
[3,"Could any of the expenses being reimbursed be used for personal reasons (i.e. passports, visas, unused plane tickets)? If yes, please provide justification for using University funds for these items. "]