{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["SAMPLE"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"SAMPLE","index":0,"n_rows":76,"n_cols":23,"rows_kept":76,"cut":false,"hidden":false,"merged":[[64,2,65,12],[59,1,59,2],[59,3,59,5],[59,8,59,9],[60,8,60,9],[71,1,71,3],[55,1,55,2],[55,3,55,5],[56,1,56,2],[56,3,56,5],[47,2,47,5],[47,10,47,11],[46,2,46,5],[46,10,46,11],[61,1,61,2],[61,3,61,5],[58,1,58,2],[58,3,58,5],[42,2,42,5],[43,2,43,5],[44,2,44,5],[45,2,45,5],[42,10,42,11],[43,10,43,11],[44,10,44,11],[45,10,45,11],[52,8,52,9],[52,11,52,12],[75,7,75,8],[75,9,75,12],[74,8,74,9],[53,11,53,12],[54,1,54,2],[54,3,54,5],[54,8,54,9],[54,11,54,12],[60,10,60,12],[61,8,61,9],[59,10,59,12],[64,1,65,1],[67,1,67,12],[69,1,69,3],[69,10,69,11],[70,1,70,3],[70,10,70,11],[72,1,72,3],[73,10,73,11],[74,1,74,3],[74,10,74,11],[60,1,60,2],[60,3,60,5],[71,10,71,11],[38,10,38,11],[40,2,40,5],[40,10,40,11],[76,1,76,3],[76,4,76,5],[76,9,76,12],[72,10,72,11],[48,1,48,5],[50,1,50,5],[50,8,50,12],[56,8,57,9],[56,11,57,12],[57,1,57,2],[57,3,57,5],[53,1,53,2],[53,3,53,5],[53,8,53,9],[51,1,51,2],[51,4,51,5],[51,8,51,9],[51,11,51,12],[52,1,52,2],[52,4,52,5],[75,1,75,3],[27,10,27,11],[41,2,41,5],[41,10,41,11],[39,2,39,5],[39,10,39,11],[29,2,29,5],[29,10,29,11],[30,2,30,5],[30,10,30,11],[31,2,31,5],[31,10,31,11],[32,2,32,5],[32,10,32,11],[33,2,33,5],[33,10,33,11],[34,2,34,5],[34,10,34,11],[35,2,35,5],[35,10,35,11],[36,2,36,5],[36,10,36,11],[37,2,37,5],[37,10,37,11],[38,2,38,5],[13,11,13,12],[28,2,28,5],[28,10,28,11],[17,2,17,5],[17,10,17,11],[18,2,18,5],[18,10,18,11],[19,2,19,5],[19,10,19,11],[20,2,20,5],[20,10,20,11],[21,2,21,5],[21,10,21,11],[22,2,22,5],[22,10,22,11],[23,2,23,5],[23,10,23,11],[24,2,24,5],[24,10,24,11],[25,2,25,5],[25,10,25,11],[26,2,26,5],[26,10,26,11],[27,2,27,5],[14,1,14,12],[15,2,15,5],[15,10,15,11],[15,14,15,15],[15,18,15,19],[16,2,16,5],[16,10,16,11],[5,2,5,5],[5,7,7,7],[5,8,7,8],[5,9,7,9],[5,11,7,12],[6,2,6,5],[7,2,7,5],[5,10,7,10],[8,2,8,5],[10,1,13,1],[10,2,10,5],[10,11,10,12],[11,2,11,5],[11,11,11,12],[12,2,12,5],[12,11,12,12],[13,2,13,5],[0,9,0,11],[1,9,1,11],[2,9,2,11],[4,2,4,5],[4,11,4,12],[0,7,2,8],[2,1,2,5],[1,1,1,5],[0,1,0,5],[4,7,4,10]]}
[null,"PROCESSED TRAVEL CLAIM",null,null,null,null,null,"FY15",null,"Claim Received"]
[null,"Receipt of Disbursement",null,null,null,null,null,null,null,"Claim Processed"]
[null,"CNIC HQ",null,null,null,null,null,null,null,"Days to Process",null,null,{"$f":"M2-M1","v":0}]
[]
[null,"NAME",null,null,null,null,null,"Per Diem Rates ",null,null,null,"Airfare"]
[null,"VENDOR #",null,null,null,null,null,"Lodging","Meals","Inc.","Flat Rate M & I Rate"]
[null,"DEPARTMENT"]
[null,"TRAVEL ORDER"]
[]
[null,"TDY Location(s)"]
[null,null,null,null,null,null,null,null,null,null,null,"TDY Start Date"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"TDY End Date"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L14-L12+1","v":1}]
[]
[null,"Travel Dates","Location",null,null,null,"Days","Lodging","Meals","Inc.","Lodging Tax",null,"Daily Total",null,"Standard"]
[1,{"$f":"L12","v":"00:00:00"},{"$f":"C10","v":0},null,null,null,{"$f":"IF(C17>0,1,\"\")","v":""},null,{"$f":"I9*0.75","v":0},{"$f":"J9*0.75","v":0},0,null,{"$f":"SUM(H17:L17)","v":0},null,{"$f":"IF($C17=$C$9,$I$9,IF($C17=$C$11,$I$11,IF($C17=$C$12,$I$12,IF($C17=$C$13,$I$13,IF($C17=$C$14,$I$14,\"\")))))","v":0},{"$f":"IF($C17=$C$9,$J$9,IF($C17=$C$11,$J$11,IF($C17=$C$12,$J$12,IF($C17=$C$13,$J$13,IF($C17=$C$14,$J$14,\"\")))))","v":0},1,{"$f":"O17*0.75","v":0},{"$f":"P17*0.75","v":0},{"$f":"SUBSTITUTE(Q17,\"1\",\"1\")","v":"1"},null,{"$f":"R17","v":0},{"$f":"S17","v":0}]
[2,{"$f":"IF($N$14>=A18,B17+1,\"\")","v":""},null,null,null,null,{"$f":"IF(C18>0,1,\"\")","v":""},null,{"$f":"$I$9","v":0},{"$f":"$J$9","v":0},0,null,0,null,0,0,{"$f":"IF(A18<$N$14,\"1\",IF(A18=$N$14,\"2\",IF(A18>$N$14,3)))","v":3},{"$f":"IF(Q18=\"1\",O18,IF(Q18=\"2\",O18*0.75,IF(Q18=\"3\",0)))","v":false},{"$f":"IF(Q18=\"1\",P18,IF(Q18=\"2\",P18*0.75,IF(Q18=\"3\",P18)))","v":false},"3",null,{"$f":"IF(T18=\"1\",R18,IF(T18=\"2\",R18,IF(T18=\"3\",0)))","v":0},{"$f":"IF(T18=\"1\",S18,IF(T18=\"2\",S18,IF(T18=\"3\",0)))","v":0}]
[3,"",null,null,null,null,"",null,{"$f":"$I$9","v":0},{"$f":"$J$9","v":0},0,null,0,null,0,0,3,false,false,"3",null,0,0]
[4,"",null,null,null,null,"",null,0,0,0,null,0,null,0,0,3,false,false,"3",null,0,0]
[5,"",null,null,null,null,"",null,0,0,0,null,0,null,0,0,3,false,false,"3",null,0,0]
[6,"",null,null,null,null,"",null,0,0,0,null,0,null,0,0,3,false,false,"3",null,0,0]
[7,"",null,null,null,null,"",null,0,0,0,null,0,null,0,0,3,false,false,"3",null,0,0]
[8,"",null,null,null,null,"",null,0,0,0,null,0,null,0,0,3,false,false,"3",null,0,0]
[9,"",null,null,null,null,"",null,0,0,0,null,0,null,0,0,3,false,false,"3",null,0,0]
[10,"",null,null,null,null,"",null,0,0,0,null,0,null,0,0,3,false,false,"3",null,0,0]
[11,"",null,null,null,null,"",null,{"$f":"I9*0.75","v":0},{"$f":"J9*0.75","v":0},0,null,0,null,0,0,3,false,false,"3",null,0,0]
[12,"",null,null,null,null,{"$f":"IF(C28>0,1,\"\")","v":""},null,null,null,null,null,0,null,0,0,3,false,false,"3",null,0,0]
[13,"",null,null,null,null,"",null,null,null,null,null,0,null,0,0,3,{"$f":"IF(Q29=\"1\",O29,IF(Q29=\"2\",O29*0.75,IF(Q29=\"3\",\"\")))","v":false},false,"3",null,0,0]
[14,"",null,null,null,null,"",null,null,null,null,null,0,null,0,0,3,false,false,"3",null,0,0]
[15,"",null,null,null,null,"",null,null,null,null,null,0,null,0,0,3,false,false,"3",null,0,0]
[16,"",null,null,null,null,"",null,null,null,null,null,0,null,0,0,3,false,false,"3",null,0,0]
[17,"",null,null,null,null,"",null,null,null,null,null,0,null,0,0,3,false,false,"3",null,0,0]
[18,null,null,null,null,null,"",null,null,null,null,null,0,null,0,0,3,false,false,"3",null,0,0]
[19,null,null,null,null,null,"",null,null,null,null,null,0,null,0,0,3,{"$f":"IF(Q35=\"1\",O35,IF(Q35=\"2\",O35*0.75,IF(Q35=\"3\",O35)))","v":false},false,"3",null,0,0]
[20,null,null,null,null,null,"",null,null,null,null,null,0,null,0,0,3,false,false,"3",null,0,0]
[21,null,null,null,null,null,"",null,null,null,null,null,0,null,0,0,3,false,false,"3",null,0,0]
[22,null,null,null,null,null,"",null,null,null,null,null,0,null,0,0,3,false,false,"3",null,0,0]
[23,null,null,null,null,null,"",null,null,null,null,null,0,null,0,0,3,false,false,"3",null,0,0]
[24,null,null,null,null,null,{"$f":"IF(C40>0,1,\"\")","v":""},null,null,null,null,null,{"$f":"SUM(H40:L40)","v":0},null,0,0,{"$f":"IF(A40<$N$14,\"1\",IF(A40=$N$14,\"2\",IF(A40>$N$14,3)))","v":3},{"$f":"IF(Q40=\"1\",O40,IF(Q40=\"2\",O40*0.75,IF(Q40=\"3\",O40)))","v":false},{"$f":"IF(Q40=\"1\",P40,IF(Q40=\"2\",P40*0.75,IF(Q40=\"3\",P40)))","v":false},{"$f":"SUBSTITUTE(Q40,\"1\",\"1\")","v":"3"},null,{"$f":"IF(T40=\"1\",R40,IF(T40=\"2\",R40,IF(T40=\"3\",0)))","v":0},{"$f":"IF(T40=\"1\",S40,IF(T40=\"2\",S40,IF(T40=\"3\",0)))","v":0}]
[24,null,null,null,null,null,"",null,null,null,null,null,0,null,0,0,3,false,false,"3",null,0,0]
[25,null,null,null,null,null,"",null,null,null,null,null,0,null,0,0,3,false,false,"3",null,0,0]
[22,null,null,null,null,null,{"$f":"IF(C43>0,1,\"\")","v":""},null,null,null,null,null,{"$f":"SUM(H43:L43)","v":0},null,0,0,{"$f":"IF(A43<$N$14,\"1\",IF(A43=$N$14,\"2\",IF(A43>$N$14,3)))","v":3},{"$f":"IF(Q43=\"1\",O43,IF(Q43=\"2\",O43*0.75,IF(Q43=\"3\",O43)))","v":false},{"$f":"IF(Q43=\"1\",P43,IF(Q43=\"2\",P43*0.75,IF(Q43=\"3\",P43)))","v":false},{"$f":"SUBSTITUTE(Q43,\"1\",\"1\")","v":"3"},null,{"$f":"IF(T43=\"1\",R43,IF(T43=\"2\",R43,IF(T43=\"3\",0)))","v":0},{"$f":"IF(T43=\"1\",S43,IF(T43=\"2\",S43,IF(T43=\"3\",0)))","v":0}]
[23,null,null,null,null,null,{"$f":"IF(C44>0,1,\"\")","v":""},null,null,null,null,null,{"$f":"SUM(H44:L44)","v":0},null,0,0,{"$f":"IF(A44<$N$14,\"1\",IF(A44=$N$14,\"2\",IF(A44>$N$14,3)))","v":3},{"$f":"IF(Q44=\"1\",O44,IF(Q44=\"2\",O44*0.75,IF(Q44=\"3\",O44)))","v":false},{"$f":"IF(Q44=\"1\",P44,IF(Q44=\"2\",P44*0.75,IF(Q44=\"3\",P44)))","v":false},{"$f":"SUBSTITUTE(Q44,\"1\",\"1\")","v":"3"},null,{"$f":"IF(T44=\"1\",R44,IF(T44=\"2\",R44,IF(T44=\"3\",0)))","v":0},{"$f":"IF(T44=\"1\",S44,IF(T44=\"2\",S44,IF(T44=\"3\",0)))","v":0}]
[24,null,null,null,null,null,{"$f":"IF(C45>0,1,\"\")","v":""},null,null,null,null,null,{"$f":"SUM(H45:L45)","v":0},null,0,0,{"$f":"IF(A45<$N$14,\"1\",IF(A45=$N$14,\"2\",IF(A45>$N$14,3)))","v":3},{"$f":"IF(Q45=\"1\",O45,IF(Q45=\"2\",O45*0.75,IF(Q45=\"3\",O45)))","v":false},{"$f":"IF(Q45=\"1\",P45,IF(Q45=\"2\",P45*0.75,IF(Q45=\"3\",P45)))","v":false},{"$f":"SUBSTITUTE(Q45,\"1\",\"1\")","v":"3"},null,{"$f":"IF(T45=\"1\",R45,IF(T45=\"2\",R45,IF(T45=\"3\",0)))","v":0},{"$f":"IF(T45=\"1\",S45,IF(T45=\"2\",S45,IF(T45=\"3\",0)))","v":0}]
[24,null,null,null,null,null,{"$f":"IF(C46>0,1,\"\")","v":""},null,null,null,null,null,{"$f":"SUM(H46:L46)","v":0},null,0,0,{"$f":"IF(A46<$N$14,\"1\",IF(A46=$N$14,\"2\",IF(A46>$N$14,3)))","v":3},{"$f":"IF(Q46=\"1\",O46,IF(Q46=\"2\",O46*0.75,IF(Q46=\"3\",O46)))","v":false},{"$f":"IF(Q46=\"1\",P46,IF(Q46=\"2\",P46*0.75,IF(Q46=\"3\",P46)))","v":false},{"$f":"SUBSTITUTE(Q46,\"1\",\"1\")","v":"3"},null,{"$f":"IF(T46=\"1\",R46,IF(T46=\"2\",R46,IF(T46=\"3\",0)))","v":0},{"$f":"IF(T46=\"1\",S46,IF(T46=\"2\",S46,IF(T46=\"3\",0)))","v":0}]
[26,null,null,null,null,null,"",null,null,null,null,null,0,null,0,0,3,false,false,"3",null,0,0]
[18,null,null,null,null,null,{"$f":"IF(C48>0,1,\"\")","v":""},null,null,null,null,null,{"$f":"SUM(H48:L48)","v":0},null,0,0,{"$f":"IF(A48<$N$14,\"1\",IF(A48=$N$14,\"2\",IF(A48>$N$14,3)))","v":3},{"$f":"IF(Q48=\"1\",O48,IF(Q48=\"2\",O48*0.75,IF(Q48=\"3\",\"\")))","v":false},{"$f":"IF(Q48=\"1\",P48,IF(Q48=\"2\",P48*0.75,IF(Q48=\"3\",P48)))","v":false},{"$f":"SUBSTITUTE(Q48,\"1\",\"1\")","v":"3"},null,{"$f":"IF(T48=\"1\",R48,IF(T48=\"2\",R48,IF(T48=\"3\",0)))","v":0},{"$f":"IF(T48=\"1\",S48,IF(T48=\"2\",S48,IF(T48=\"3\",0)))","v":0}]
[null,"Totals",null,null,null,null,{"$f":"SUM(G17:G48)","v":0},{"$f":"SUM(H17:H48)","v":0},{"$f":"SUM(I17:I48)","v":0},{"$f":"SUM(J17:J48)","v":0},null,{"$f":"SUM(K17:L48)","v":0},{"$f":"SUM(M17:M48)","v":0}]
[]
[null,"Miscellaneous Expenses",null,null,null,null,null,null,"SUMMARY OF PAYMENT"]
[null,"Mileage To/From (Miles x .575)",null,0,{"$f":"D52*0.575","v":0},null,null,null,"Lodging",null,null,{"$f":"H49","v":0}]
[null,"Mileage In/Around (Miles x .575)",null,0,{"$f":"D53*0.575","v":0},null,null,null,"M+IE",null,null,{"$f":"SUM(I49,J49)","v":0}]
[null,"Rental Car",null,0,null,null,null,null,"Total Per Diem",null,null,{"$f":"SUM(L52:M53)","v":0}]
[null,"Rental Car Fuel",null,0,null,null,null,null,"Total Misc. Exp.",null,null,{"$f":"SUM(D62,L49)","v":0}]
[null,"Airport Parking",null,0]
[null,"Tolls/Taxis/Shuttle/Metro",null,0,null,null,null,null,"TOTAL",null,null,{"$f":"SUM(L54:M55)","v":0}]
[null,"Parking",null,0]
[null,"Baggage Fees",null,0]
[null,"Other",null,0,null,null,null,null,"Processed By:"]
[null,"Phone",null,0,null,null,null,null,"Email:"]
[null,"Total Miscellaneous",null,{"$f":"SUM(E52,E53,D54:F61)","v":0},null,null,null,null,"Phone:"]
[]
[]
[null,"Notes to Traveler:"]
[]
[]
[null,"Accounting Use"]
[null,null,null,null,"By","Date",null,"**Select UFM in the dropbox below, if eligible (Appropriate G/L acct will auto poplulate)"]
[null,"Verify Travel Order # / Name",null,null,null,null,null,"Non-UFM","Co. Code","GL","Cost Ctr",null,"TOTAL",null,null,"UFM","Non-UFM"]
[null,"SAP Entry",null,null,null,null,null,"Per Diem",null,{"$f":"IF(H70=\"UFM\",721489,721400)","v":721400},0,null,{"$f":"SUM(L54)","v":0},null,null,721489,721400]
[null,"Email Copy to Traveler",null,null,null,null,null,"Misc. Exp.",{"$f":"I71","v":0},{"$f":"IF(H70=\"UFM\",721689,721600)","v":721600},{"$f":"K71","v":0},null,{"$f":"L55","v":0}]
[null,"Tracking Log",null,null,null,null,null,"Airfare (chrgd to IBA card)",{"$f":"I72","v":0},{"$f":"IF(H70=\"UFM\",721589,721500)","v":721500},{"$f":"K72","v":0},null,{"$f":"L6","v":0},null,null,721589,721500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,721689,721600]
[null,null,null,null,null,null,null,null,null,null,"TOTAL",null,{"$f":"SUM(M71:M74)","v":0}]
[null,null,null,null,null,null,null,"SAP Doc Number(s)"]