{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["intake","Travel Reimbursement","Per Diem Multiple Destinations","Mileage Log","Business Meal Details","Meals With No Overnight","RLT"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":11,"comments":3,"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":"intake","index":0,"n_rows":44,"n_cols":6,"rows_kept":44,"cut":false,"hidden":true,"merged":[[31,1,31,2],[35,4,35,5],[0,4,0,5],[0,1,0,2],[18,1,18,2],[18,4,18,5],[23,1,23,2],[23,4,23,5]]}
[null,"Duty Station DropDown",null,null,"Affiliation Dropdown"]
[null,1,"SELECT DUTY STATION",null,1,"SELECT AFFILIATION"]
[null,2,"STORRS",null,2,"Faculty"]
[null,3,"HEALTH CENTER",null,3,"Staff - UCPEA/AAUP"]
[null,4,"AVERY POINT",null,4,"Staff - MANAGERIAL"]
[null,5,"GREATER HARTFORD",null,5,"Staff - P2"]
[" ",6,"STAMFORD",null,6,"Staff - NP-5"]
[null,7,"TORRINGTON",null,7,"Staff - NP-3"]
[null,8,"WATERBURY",null,8,"Staff - NP-2"]
[null,9,"LAW",null,9,"Student"]
[null,10,"SOCIAL WORK",null,10,"Volunteer"]
[null,11,"GBLC",null,11,"Other"]
[null,12,{"$f":"'Travel Reimbursement'!L3","v":"OTHER - Type In Next Box"}]
[]
[]
[]
[]
[]
[null,"AM/PM Dropdown",null,null,"Yes/No Dropdown"]
[null,1,"AM",null,1,"Yes"]
[null,2,"PM",null,2,"No"]
[null,3,null,null,3]
[]
[null,"Meal Method",null,null,"Per Diem Amounts"]
[null,1,"Reimbursement Method",null,1,"PER DIEM RATES"]
[null,2,"Receipts",null,2,46]
[null,3,"Per Diem",null,3,51]
[null,null,null,null,4,56]
[null,null,null,null,5,61]
[null,null,null,null,6,66]
[null,null,null,null,7,71]
[null,"Transportation Expense Type",null,null,8,"FOREIGN/OTHER"]
[null,1]
[null,2,"Air"]
[null,3,"Taxi"]
[null,4,"Bus",null,"Business Expense Type"]
[null,5,"Train",null,1]
[null,6,"Shuttle",null,2,"Registration"]
[null,7,"Ferry",null,3,"Internet"]
[null,8,"Rental Car",null,4,"Copies / Fax"]
[null,9,"Fuel - Rental Car",null,5,"Postage"]
[null,10,"Tolls",null,6,"Baggage"]
[null,11,"Parking",null,7,"Other (Explain in remarks)"]
[null,12,"Other (Explain in remarks)"]

{"sheet":"Travel Reimbursement","index":1,"n_rows":57,"n_cols":24,"rows_kept":57,"cut":false,"hidden":false,"merged":[[54,0,54,11],[56,0,56,1],[55,0,55,1],[56,2,56,5],[55,2,55,6],[56,7,56,9],[1,17,1,18],[2,17,2,18],[33,1,33,2],[45,13,46,15],[28,5,28,6],[27,5,27,6],[26,5,26,6],[25,5,25,6],[25,8,25,9],[26,8,26,9],[27,8,27,9],[28,8,28,9],[29,8,29,9],[36,5,36,6],[37,5,37,6],[38,5,38,6],[39,5,39,6],[45,0,45,10],[51,0,51,1],[50,6,50,11],[0,7,0,9],[20,1,20,2],[18,1,18,2],[19,1,19,2],[4,1,4,4],[0,1,0,4],[1,1,1,4],[2,1,2,4],[3,1,3,4],[1,5,1,6],[2,5,2,6],[0,5,0,6],[3,7,3,9],[7,7,7,8],[7,1,7,2],[7,3,7,4],[7,5,7,6],[20,3,20,4],[19,8,19,9],[20,8,20,9],[19,5,19,6],[20,5,20,6],[51,3,51,4],[52,3,52,4],[53,3,53,4],[21,5,21,6],[22,5,22,6],[23,5,23,6],[24,5,24,6],[31,5,31,6],[32,5,32,6],[33,5,33,6],[34,5,34,6],[35,5,35,6],[26,3,26,4],[27,3,27,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[51,6,53,11],[22,8,22,9],[23,8,23,9],[24,8,24,9],[1,13,1,15],[1,7,1,9],[2,7,2,9],[4,7,4,9],[3,5,3,6],[1,12,19,12],[8,1,8,2],[8,3,8,4],[8,5,8,6],[8,7,8,8],[8,9,8,10],[10,3,10,4],[10,5,10,6],[10,7,10,8],[10,9,10,10],[16,5,16,7],[5,0,5,11],[1,10,1,11],[14,1,14,2],[7,9,7,10],[14,3,14,4],[11,3,11,4],[18,3,18,4],[19,3,19,4],[6,16,6,22],[16,1,16,4],[16,11,17,11],[17,8,17,9],[17,5,17,6],[17,3,17,4],[17,1,17,2],[10,1,10,2],[14,9,14,10],[13,1,13,2],[13,3,13,4],[13,5,13,6],[13,7,13,8],[13,9,13,10],[11,1,11,2],[12,7,12,8],[12,5,12,6],[12,3,12,4],[12,1,12,2],[16,8,16,10],[11,7,11,8],[14,7,14,8],[11,9,11,10],[20,13,24,15],[18,8,18,9],[18,5,18,6],[21,1,21,2],[6,3,6,4],[23,1,23,2],[24,1,24,2],[21,3,21,4],[15,1,15,2],[15,3,15,4],[15,5,15,6],[15,7,15,8],[15,9,15,10],[6,9,6,10],[9,1,9,2],[9,3,9,4],[9,5,9,6],[9,7,9,8],[9,9,9,10],[12,9,12,10],[11,5,11,6],[14,5,14,6],[22,1,22,2],[21,8,21,9],[52,0,52,1],[53,0,53,1],[37,3,37,4],[38,3,38,4],[39,3,39,4],[40,3,40,4],[47,0,47,10],[41,0,41,10],[38,1,38,2],[39,1,39,2],[43,0,43,2],[40,1,40,2],[42,3,42,4],[42,1,42,2],[42,8,42,9],[42,5,42,6],[37,1,37,2],[44,0,44,10],[40,5,40,6],[51,5,53,5],[50,0,50,1],[46,0,46,10],[49,0,49,10],[50,3,50,4],[32,13,38,15],[48,0,48,10],[48,13,48,15],[35,8,35,9],[36,8,36,9],[37,8,37,9],[38,8,38,9],[39,8,39,9],[40,13,41,15],[40,7,40,9],[32,1,32,2],[32,8,32,9],[34,8,34,9],[35,1,35,2],[36,1,36,2],[34,3,34,4],[35,3,35,4],[36,3,36,4],[34,1,34,2],[31,1,31,2],[33,8,33,9],[30,8,30,9],[25,1,25,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[25,3,25,4],[28,3,28,4],[30,5,30,6],[29,5,29,6],[29,3,29,4],[30,3,30,4],[32,3,32,4],[33,3,33,4],[31,8,31,9],[31,3,31,4],[26,1,26,2],[27,1,27,2]]}
["Traveler's Name:",null,null,null,null,"Department:",null,null,null,null,"U-Box:"]
["University Affiliation:",1,null,null,null,"Travel Approval Number:",null,null,null,null,null,null,null,false,null,null,null,"M&IE Foreign Rate",null,"Breakfast","Lunch","Dinner","IE"]
["Location of Travel:",null,null,null,null,"Official Duty Station:",null,1,null,null,"Other duty:","OTHER - Type In Next Box",null,{"$f":"intake!#REF!","v":{"$error":"#REF!"}},{"$f":"intake!#REF!","v":{"$error":"#REF!"}},{"$f":"$D$7","v":8},null,{"$f":"$H$7","v":0},null,{"$f":"IF($R$3=0, 0, VLOOKUP($R$3,RLT!$A$26:$E$294,2))","v":0},{"$f":"IF($R$3=0, 0, VLOOKUP($R$3,RLT!$A$26:$E$294,3))","v":0},{"$f":"IF($R$3=0, 0, VLOOKUP($R$3,RLT!$A$26:$E$294,4))","v":0},{"$f":"IF($R$3=0, 0, VLOOKUP($R$3,RLT!$A$26:$E$294,5))","v":0}]
["Departure Date:",null,null,null,null,"Return Date:",null,null,null,null,null,"VERSION 3.3",null,{"$f":"$D$7","v":8}]
["Departure Time:",null,null,null,null,1,"Return Time:",null,null,null,1,null,null,{"$f":"'Mileage Log'!$F$4","v":0},{"$f":"RLT!A16","v":0.57499999999999996},{"$f":"IF(B2=10,(N5*0.14),IF($N$2 = FALSE, SUM(N5*O5), N5*0.194 ))","v":0}]
["Per Diem Meals Section (Single Destination Trip)  - Select any meals PROVIDED TO the Traveler in the corresponding day"]
[null,null,"Select Rate:",8,null,null,"Foreign/Other Rate:",null,null,"Per Diem Calculated:",null,{"$f":"SUM(X18:X23,'Per Diem Multiple Destinations'!G3)","v":0},null,null,null,null,"Per Diem Formulas Below"]
[{"$f":"IF($D$7=1,\"\",$B$4)","v":"00:00:00"},{"$f":"IF(A8=\"\",\"\",(IF(A8+1<=$H$4,A8+1,\"\")))","v":""},null,{"$f":"IF(B8=\"\",\"\",(IF(B8+1<=$H$4,B8+1,\"\")))","v":""},null,{"$f":"IF(D8=\"\",\"\",(IF(D8+1<=$H$4,D8+1,\"\")))","v":""},null,{"$f":"IF(F8=\"\",\"\",(IF(F8+1<=$H$4,F8+1,\"\")))","v":""},null,{"$f":"IF(H8=\"\",\"\",(IF(H8+1<=$H$4,H8+1,\"\")))","v":""},null,{"$f":"IF(J8=\"\",\"\",(IF(J8+1<=$H$4,J8+1,\"\")))","v":""}]
[1,1,null,1,null,1,null,1,null,1,null,1,null,null,null,null,{"$f":"IF(VLOOKUP(A9,RLT!$I$3:$Q$14,$D7+1)=\"None\", 0, IF(A8=\"\",0, VLOOKUP(A9,RLT!$I$3:$Q$14,$D7+1)))","v":0},{"$f":"IF(VLOOKUP(B9,RLT!$I$3:$Q$14,$D7+1)=\"None\", 0, IF(B8=\"\",0, VLOOKUP(B9,RLT!$I$3:$Q$14,$D7+1)))","v":0},{"$f":"IF(VLOOKUP(D9,RLT!$I$3:$Q$14,$D7+1)=\"None\", 0, IF(D8=\"\",0, VLOOKUP(D9,RLT!$I$3:$Q$14,$D7+1)))","v":0},{"$f":"IF(VLOOKUP(F9,RLT!$I$3:$Q$14,$D7+1)=\"None\", 0, IF(F8=\"\",0, VLOOKUP(F9,RLT!$I$3:$Q$14,$D7+1)))","v":0},{"$f":"IF(VLOOKUP(H9,RLT!$I$3:$Q$14,$D7+1)=\"None\", 0, IF(H8=\"\",0, VLOOKUP(H9,RLT!$I$3:$Q$14,$D7+1)))","v":0},{"$f":"IF(VLOOKUP(J9,RLT!$I$3:$Q$14,$D7+1)=\"None\", 0, IF(J8=\"\",0, VLOOKUP(J9,RLT!$I$3:$Q$14,$D7+1)))","v":0},{"$f":"IF(VLOOKUP(L9,RLT!$I$3:$Q$14,$D7+1)=\"None\", 0, IF(L8=\"\",0, VLOOKUP(L9,RLT!$I$3:$Q$14,$D7+1)))","v":0}]
[{"$f":"SUM(Q18:Q19)","v":0},{"$f":"SUM(R18:R19)","v":0},null,{"$f":"SUM(S18:S19)","v":0},null,{"$f":"SUM(T18:T19)","v":0},null,{"$f":"SUM(U18:U19)","v":0},null,{"$f":"SUM(V18:V19)","v":0},null,{"$f":"SUM(W18:W19)","v":0}]
[{"$f":"IF(L8=\"\",\"\",(IF(L8+1<=$H$4,L8+1,\"\")))","v":""},{"$f":"IF(A11=\"\",\"\",(IF(A11+1<=$H$4,A11+1,\"\")))","v":""},null,{"$f":"IF(B11=\"\",\"\",(IF(B11+1<=$H$4,B11+1,\"\")))","v":""},null,{"$f":"IF(D11=\"\",\"\",(IF(D11+1<=$H$4,D11+1,\"\")))","v":""},null,{"$f":"IF(F11=\"\",\"\",(IF(F11+1<=$H$4,F11+1,\"\")))","v":""},null,{"$f":"IF(H11=\"\",\"\",(IF(H11+1<=$H$4,H11+1,\"\")))","v":""},null,{"$f":"IF(J11=\"\",\"\",(IF(J11+1<=$H$4,J11+1,\"\")))","v":""}]
[1,1,null,1,null,1,null,1,null,1,null,1,null,null,null,null,{"$f":"IF(VLOOKUP(A12,RLT!$I$3:$Q$14,$D7+1)=\"None\", 0, IF(A11=\"\",0, VLOOKUP(A12,RLT!$I$3:$Q$14,$D7+1)))","v":0},{"$f":"IF(VLOOKUP(B12,RLT!$I$3:$Q$14,$D7+1)=\"None\", 0, IF(B11=\"\",0, VLOOKUP(B12,RLT!$I$3:$Q$14,$D7+1)))","v":0},{"$f":"IF(VLOOKUP(D12,RLT!$I$3:$Q$14,$D7+1)=\"None\", 0, IF(D11=\"\",0, VLOOKUP(D12,RLT!$I$3:$Q$14,$D7+1)))","v":0},{"$f":"IF(VLOOKUP(F12,RLT!$I$3:$Q$14,$D7+1)=\"None\", 0, IF(F11=\"\",0, VLOOKUP(F12,RLT!$I$3:$Q$14,$D7+1)))","v":0},{"$f":"IF(VLOOKUP(H12,RLT!$I$3:$Q$14,$D7+1)=\"None\", 0, IF(H11=\"\",0, VLOOKUP(H12,RLT!$I$3:$Q$14,$D7+1)))","v":0},{"$f":"IF(VLOOKUP(J12,RLT!$I$3:$Q$14,$D7+1)=\"None\", 0, IF(J11=\"\",0, VLOOKUP(J12,RLT!$I$3:$Q$14,$D7+1)))","v":0},{"$f":"IF(VLOOKUP(L12,RLT!$I$3:$Q$14,$D7+1)=\"None\", 0, IF(L11=\"\",0, VLOOKUP(L12,RLT!$I$3:$Q$14,$D7+1)))","v":0}]
[{"$f":"SUM(Q20:Q21)","v":0},{"$f":"SUM(R20:R21)","v":0},null,{"$f":"SUM(S20:S21)","v":0},null,{"$f":"SUM(T20:T21)","v":0},null,{"$f":"SUM(U20:U21)","v":0},null,{"$f":"SUM(V20:V21)","v":0},null,{"$f":"SUM(W20:W21)","v":0}]
[{"$f":"IF(L11=\"\",\"\",(IF(L11+1<=$H$4,L11+1,\"\")))","v":""},{"$f":"IF(A14=\"\",\"\",(IF(A14+1<=$H$4,A14+1,\"\")))","v":""},null,{"$f":"IF(B14=\"\",\"\",(IF(B14+1<=$H$4,B14+1,\"\")))","v":""},null,{"$f":"IF(D14=\"\",\"\",(IF(D14+1<=$H$4,D14+1,\"\")))","v":""},null,{"$f":"IF(F14=\"\",\"\",(IF(F14+1<=$H$4,F14+1,\"\")))","v":""},null,{"$f":"IF(H14=\"\",\"\",(IF(H14+1<=$H$4,H14+1,\"\")))","v":""},null,{"$f":"IF(J14=\"\",\"\",(IF(J14+1<=$H$4,J14+1,\"\")))","v":""}]
[1,1,null,1,null,1,null,1,null,1,null,1,null,null,null,null,{"$f":"IF(VLOOKUP(A15,RLT!$I$3:$Q$14,$D7+1)=\"None\", 0, IF(A14=\"\",0, VLOOKUP(A15,RLT!$I$3:$Q$14,$D7+1)))","v":0},{"$f":"IF(VLOOKUP(B15,RLT!$I$3:$Q$14,$D7+1)=\"None\", 0, IF(B14=\"\",0, VLOOKUP(B15,RLT!$I$3:$Q$14,$D7+1)))","v":0},{"$f":"IF(VLOOKUP(D15,RLT!$I$3:$Q$14,$D7+1)=\"None\", 0, IF(D14=\"\",0, VLOOKUP(D15,RLT!$I$3:$Q$14,$D7+1)))","v":0},{"$f":"IF(VLOOKUP(F15,RLT!$I$3:$Q$14,$D7+1)=\"None\", 0, IF(F14=\"\",0, VLOOKUP(F15,RLT!$I$3:$Q$14,$D7+1)))","v":0},{"$f":"IF(VLOOKUP(H15,RLT!$I$3:$Q$14,$D7+1)=\"None\", 0, IF(H14=\"\",0, VLOOKUP(H15,RLT!$I$3:$Q$14,$D7+1)))","v":0},{"$f":"IF(VLOOKUP(J15,RLT!$I$3:$Q$14,$D7+1)=\"None\", 0, IF(J14=\"\",0, VLOOKUP(J15,RLT!$I$3:$Q$14,$D7+1)))","v":0},{"$f":"IF(VLOOKUP(L15,RLT!$I$3:$Q$14,$D7+1)=\"None\", 0, IF(L14=\"\",0, VLOOKUP(L15,RLT!$I$3:$Q$14,$D7+1)))","v":0}]
[{"$f":"SUM(Q22:Q23)","v":0},{"$f":"SUM(R22:R23)","v":0},null,{"$f":"SUM(S22:S23)","v":0},null,{"$f":"SUM(T22:T23)","v":0},null,{"$f":"SUM(U22:U23)","v":0},null,{"$f":"SUM(V22:V23)","v":0},null,{"$f":"SUM(W22:W23)","v":0}]
["DATES","SUBSISTENCE",null,null,null," TRANSPORTATION",null,null,"BUSINESS\nEXPENSES",null,null,"TOTALS",null,null,null,null,1,2,3,4,5,6,7]
["DATE OF EXPENSE","Receipted Meals",null,"Lodging",null,"Type",null,"Amount","Type",null,"Amount",null,null,null,null,null,{"$f":"IF(Q9=0, 0, IF($B$4=\"\",0, IF(AND($B$5<0.29166,$F$5=1),Q9,IF(AND($B$5<0.45833,$F$5=1),Q9-HLOOKUP($D$7,RLT!$J$1:$Q$10,9),IF(AND($B$5>=0.5,$B$5<=0.541,$F$5=1),Q9,IF($F$5=1,Q9-HLOOKUP($D$7,RLT!$J$1:$Q$10,6),IF(AND($B$5>=0.5,$B$5<=0.541,$F$5=2),Q9-HLOOKUP($D$7,RLT!$J$1:$Q$10,6),IF(AND($B$5<0.20833,$F$5=2),Q9-HLOOKUP($D$7,RLT!$J$1:$Q$10,6),0))))))))","v":0},{"$f":"IF(R9=0, 0,IF(D8=\"\",IF(OR(AND($H$5<=0.541,$K$5=1,$H$5>=0.5), AND($H$5<=0.375,$K$5=1)),0, IF($K$5=1,R9-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.0833,$K$5=2), R9-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.2916,$K$5=2),R9-HLOOKUP($D$7,RLT!$J$1:$Q$10,7),IF(AND($H$5<=0.541,$H$5>=0.5,$K$5=2),R9-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), R9)))) ),R9))","v":0},{"$f":"IF(S9=0, 0,IF(F8=\"\",IF(OR(AND($H$5<=0.541,$K$5=1,$H$5>=0.5), AND($H$5<=0.375,$K$5=1)),0, IF($K$5=1,S9-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.0833,$K$5=2), S9-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.2916,$K$5=2),S9-HLOOKUP($D$7,RLT!$J$1:$Q$10,7),IF(AND($H$5<=0.541,$H$5>=0.5,$K$5=2),S9-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), S9)))) ),S9))","v":0},{"$f":"IF(T9=0, 0,IF(H8=\"\",IF(OR(AND($H$5<=0.541,$K$5=1,$H$5>=0.5), AND($H$5<=0.375,$K$5=1)),0, IF($K$5=1,T9-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.0833,$K$5=2), T9-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.2916,$K$5=2),T9-HLOOKUP($D$7,RLT!$J$1:$Q$10,7),IF(AND($H$5<=0.541,$H$5>=0.5,$K$5=2),T9-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), T9)))) ),T9))","v":0},{"$f":"IF(U9=0, 0,IF(J8=\"\",IF(OR(AND($H$5<=0.541,$K$5=1,$H$5>=0.5), AND($H$5<=0.375,$K$5=1)),0, IF($K$5=1,U9-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.0833,$K$5=2), U9-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.2916,$K$5=2),U9-HLOOKUP($D$7,RLT!$J$1:$Q$10,7),IF(AND($H$5<=0.541,$H$5>=0.5,$K$5=2),U9-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), U9)))) ),U9))","v":0},{"$f":"IF(V9=0, 0,IF(L8=\"\",IF(OR(AND($H$5<=0.541,$K$5=1,$H$5>=0.5), AND($H$5<=0.375,$K$5=1)),0, IF($K$5=1,V9-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.0833,$K$5=2), V9-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.2916,$K$5=2),V9-HLOOKUP($D$7,RLT!$J$1:$Q$10,7),IF(AND($H$5<=0.541,$H$5>=0.5,$K$5=2),V9-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), V9)))) ),V9))","v":0},{"$f":"IF(W9=0, 0,IF(A11=\"\",IF(OR(AND($H$5<=0.541,$K$5=1,$H$5>=0.5), AND($H$5<=0.375,$K$5=1)),0, IF($K$5=1,W9-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.0833,$K$5=2), W9-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.2916,$K$5=2),W9-HLOOKUP($D$7,RLT!$J$1:$Q$10,7),IF(AND($H$5<=0.541,$H$5>=0.5,$K$5=2),W9-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), W9)))) ),W9))","v":0},{"$f":"SUMPRODUCT(--(Q18:W18>0),Q18:W18)","v":0}]
[null,null,null,null,null,1,null,null,null,null,null,{"$f":"B19+D19+H19+K19","v":0},null,null,null,null,{"$f":"IF(A9=9,0,IF(A8=\"\",0,IF($N$4>1,HLOOKUP($P$3,RLT!$B$1:$H$7,6),0)))","v":0},{"$f":"IF(B9=9,0,IF(B8=\"\",0,IF($N$4>1,HLOOKUP($P$3,RLT!$B$1:$H$7,6),0)))","v":0},{"$f":"IF(D9=9,0,IF(D8=\"\",0,IF($N$4>1,HLOOKUP($P$3,RLT!$B$1:$H$7,6),0)))","v":0},{"$f":"IF(F9=9,0,IF(F8=\"\",0,IF($N$4>1,HLOOKUP($P$3,RLT!$B$1:$H$7,6),0)))","v":0},{"$f":"IF(H9=9,0,IF(H8=\"\",0,IF($N$4>1,HLOOKUP($P$3,RLT!$B$1:$H$7,6),0)))","v":0},{"$f":"IF(J9=9,0,IF(J8=\"\",0,IF($N$4>1,HLOOKUP($P$3,RLT!$B$1:$H$7,6),0)))","v":0},{"$f":"IF(L9=9,0,IF(L8=\"\",0,IF($N$4>1,HLOOKUP($P$3,RLT!$B$1:$H$7,6),0)))","v":0},{"$f":"SUM(Q19:W19)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"B20+D20+H20+K20","v":0},null,null,null,null,{"$f":"IF(Q12=0, 0,IF(B11=\"\",IF(OR(AND($H$5<=0.541,$K$5=1,$H$5>=0.5), AND($H$5<=0.375,$K$5=1)),0, IF($K$5=1,Q12-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.0833,$K$5=2), Q12-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.2916,$K$5=2),Q12-HLOOKUP($D$7,RLT!$J$1:$Q$10,7),IF(AND($H$5<=0.541,$H$5>=0.5,$K$5=2),Q12-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), Q12)))) ),Q12))","v":0},{"$f":"IF(R12=0, 0,IF(D11=\"\",IF(OR(AND($H$5<=0.541,$K$5=1,$H$5>=0.5), AND($H$5<=0.375,$K$5=1)),0, IF($K$5=1,R12-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.0833,$K$5=2), R12-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.2916,$K$5=2),R12-HLOOKUP($D$7,RLT!$J$1:$Q$10,7),IF(AND($H$5<=0.541,$H$5>=0.5,$K$5=2),R12-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), R12)))) ),R12))","v":0},{"$f":"IF(S12=0, 0,IF(F11=\"\",IF(OR(AND($H$5<=0.541,$K$5=1,$H$5>=0.5), AND($H$5<=0.375,$K$5=1)),0, IF($K$5=1,S12-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.0833,$K$5=2), S12-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.2916,$K$5=2),S12-HLOOKUP($D$7,RLT!$J$1:$Q$10,7),IF(AND($H$5<=0.541,$H$5>=0.5,$K$5=2),S12-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), S12)))) ),S12))","v":0},{"$f":"IF(T12=0, 0,IF(H11=\"\",IF(OR(AND($H$5<=0.541,$K$5=1,$H$5>=0.5), AND($H$5<=0.375,$K$5=1)),0, IF($K$5=1,T12-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.0833,$K$5=2), T12-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.2916,$K$5=2),T12-HLOOKUP($D$7,RLT!$J$1:$Q$10,7),IF(AND($H$5<=0.541,$H$5>=0.5,$K$5=2),T12-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), T12)))) ),T12))","v":0},{"$f":"IF(U12=0, 0,IF(J11=\"\",IF(OR(AND($H$5<=0.541,$K$5=1,$H$5>=0.5), AND($H$5<=0.375,$K$5=1)),0, IF($K$5=1,U12-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.0833,$K$5=2), U12-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.2916,$K$5=2),U12-HLOOKUP($D$7,RLT!$J$1:$Q$10,7),IF(AND($H$5<=0.541,$H$5>=0.5,$K$5=2),U12-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), U12)))) ),U12))","v":0},{"$f":"IF(V12=0, 0,IF(L11=\"\",IF(OR(AND($H$5<=0.541,$K$5=1,$H$5>=0.5), AND($H$5<=0.375,$K$5=1)),0, IF($K$5=1,V12-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.0833,$K$5=2), V12-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.2916,$K$5=2),V12-HLOOKUP($D$7,RLT!$J$1:$Q$10,7),IF(AND($H$5<=0.541,$H$5>=0.5,$K$5=2),V12-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), V12)))) ),V12))","v":0},{"$f":"IF(W12=0, 0,IF(A14=\"\",IF(OR(AND($H$5<=0.541,$K$5=1,$H$5>=0.5), AND($H$5<=0.375,$K$5=1)),0, IF($K$5=1,W12-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.0833,$K$5=2), W12-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.2916,$K$5=2),W12-HLOOKUP($D$7,RLT!$J$1:$Q$10,7),IF(AND($H$5<=0.541,$H$5>=0.5,$K$5=2),W12-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), W12)))) ),W12))","v":0},{"$f":"SUMPRODUCT(--(Q20:W20>0),Q20:W20)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0,null,"\n",null,null,{"$f":"IF(A12=9,0,IF(A11=\"\",0,IF($N$4>1,HLOOKUP($P$3,RLT!$B$1:$H$7,6),0)))","v":0},{"$f":"IF(B12=9,0,IF(B11=\"\",0,IF($N$4>1,HLOOKUP($P$3,RLT!$B$1:$H$7,6),0)))","v":0},{"$f":"IF(D12=9,0,IF(D11=\"\",0,IF($N$4>1,HLOOKUP($P$3,RLT!$B$1:$H$7,6),0)))","v":0},{"$f":"IF(F12=9,0,IF(F11=\"\",0,IF($N$4>1,HLOOKUP($P$3,RLT!$B$1:$H$7,6),0)))","v":0},{"$f":"IF(H12=9,0,IF(H11=\"\",0,IF($N$4>1,HLOOKUP($P$3,RLT!$B$1:$H$7,6),0)))","v":0},{"$f":"IF(J12=9,0,IF(J11=\"\",0,IF($N$4>1,HLOOKUP($P$3,RLT!$B$1:$H$7,6),0)))","v":0},{"$f":"IF(L12=9,0,IF(L11=\"\",0,IF($N$4>1,HLOOKUP($P$3,RLT!$B$1:$H$7,6),0)))","v":0},{"$f":"SUM(Q21:W21)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(Q15=0, 0,IF(B14=\"\",IF(OR(AND($H$5<=0.541,$K$5=1,$H$5>=0.5), AND($H$5<=0.375,$K$5=1)),0, IF($K$5=1,Q15-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.0833,$K$5=2), Q15-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.2916,$K$5=2),Q15-HLOOKUP($D$7,RLT!$J$1:$Q$10,7),IF(AND($H$5<=0.541,$H$5>=0.5,$K$5=2),Q15-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), Q15)))) ),Q15))","v":0},{"$f":"IF(R15=0, 0,IF(D14=\"\",IF(OR(AND($H$5<=0.541,$K$5=1,$H$5>=0.5), AND($H$5<=0.375,$K$5=1)),0, IF($K$5=1,R15-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.0833,$K$5=2), R15-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.2916,$K$5=2),R15-HLOOKUP($D$7,RLT!$J$1:$Q$10,7),IF(AND($H$5<=0.541,$H$5>=0.5,$K$5=2),R15-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), R15)))) ),R15))","v":0},{"$f":"IF(S15=0, 0,IF(F14=\"\",IF(OR(AND($H$5<=0.541,$K$5=1,$H$5>=0.5), AND($H$5<=0.375,$K$5=1)),0, IF($K$5=1,S15-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.0833,$K$5=2), S15-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.2916,$K$5=2),S15-HLOOKUP($D$7,RLT!$J$1:$Q$10,7),IF(AND($H$5<=0.541,$H$5>=0.5,$K$5=2),S15-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), S15)))) ),S15))","v":0},{"$f":"IF(T15=0, 0,IF(H14=\"\",IF(OR(AND($H$5<=0.541,$K$5=1,$H$5>=0.5), AND($H$5<=0.375,$K$5=1)),0, IF($K$5=1,T15-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.0833,$K$5=2), T15-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.2916,$K$5=2),T15-HLOOKUP($D$7,RLT!$J$1:$Q$10,7),IF(AND($H$5<=0.541,$H$5>=0.5,$K$5=2),T15-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), T15)))) ),T15))","v":0},{"$f":"IF(U15=0, 0,IF(J14=\"\",IF(OR(AND($H$5<=0.541,$K$5=1,$H$5>=0.5), AND($H$5<=0.375,$K$5=1)),0, IF($K$5=1,U15-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.0833,$K$5=2), U15-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.2916,$K$5=2),U15-HLOOKUP($D$7,RLT!$J$1:$Q$10,7),IF(AND($H$5<=0.541,$H$5>=0.5,$K$5=2),U15-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), U15)))) ),U15))","v":0},{"$f":"IF(V15=0, 0,IF(L14=\"\",IF(OR(AND($H$5<=0.541,$K$5=1,$H$5>=0.5), AND($H$5<=0.375,$K$5=1)),0, IF($K$5=1,V15-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.0833,$K$5=2), V15-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), IF(AND($H$5<=0.2916,$K$5=2),V15-HLOOKUP($D$7,RLT!$J$1:$Q$10,7),IF(AND($H$5<=0.541,$H$5>=0.5,$K$5=2),V15-HLOOKUP($D$7,RLT!$J$1:$Q$10,4), V15)))) ),V15))","v":0},{"$f":"IF(W15=0,0,IF(OR(AND($H$5<=0.541,$K$5=1,$H$5>=0.5),AND($H$5<=0.375,$K$5=1)),0,IF($K$5=1,W15-HLOOKUP($D$7,RLT!$J$1:$Q$10,4),IF(AND($H$5<=0.0833,$K$5=2),W15-HLOOKUP($D$7,RLT!$J$1:$Q$10,4),IF(AND($H$5<=0.2916,$K$5=2),W15-HLOOKUP($D$7,RLT!$J$1:$Q$10,7),IF(AND($H$5<=0.541,$H$5>=0.5,$K$5=2),W15-HLOOKUP($D$7,RLT!$J$1:$Q$10,4),W15))))))","v":0},{"$f":"SUMPRODUCT(--(Q22:W22>0),Q22:W22)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(A15=9,0,IF(A14=\"\",0,IF($N$4>1,HLOOKUP($P$3,RLT!$B$1:$H$7,6),0)))","v":0},{"$f":"IF(B15=9,0,IF(B14=\"\",0,IF($N$4>1,HLOOKUP($P$3,RLT!$B$1:$H$7,6),0)))","v":0},{"$f":"IF(D15=9,0,IF(D14=\"\",0,IF($N$4>1,HLOOKUP($P$3,RLT!$B$1:$H$7,6),0)))","v":0},{"$f":"IF(F15=9,0,IF(F14=\"\",0,IF($N$4>1,HLOOKUP($P$3,RLT!$B$1:$H$7,6),0)))","v":0},{"$f":"IF(H15=9,0,IF(H14=\"\",0,IF($N$4>1,HLOOKUP($P$3,RLT!$B$1:$H$7,6),0)))","v":0},{"$f":"IF(J15=9,0,IF(J14=\"\",0,IF($N$4>1,HLOOKUP($P$3,RLT!$B$1:$H$7,6),0)))","v":0},{"$f":"IF(L15=9,0,IF(L14=\"\",0,IF($N$4>1,HLOOKUP($P$3,RLT!$B$1:$H$7,6),0)))","v":0},{"$f":"SUM(Q23:W23)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(X18:X23)+'Per Diem Multiple Destinations'!G3","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
["Per Diem Meals",{"$f":"SUM(X18:X23)+'Per Diem Multiple Destinations'!G3","v":0},null,"Business Meals",null,{"$f":"'Business Meal Details'!G34","v":0},null,"Meals with no Overnight Stay",null,null,{"$f":"'Meals With No Overnight'!H17","v":0},{"$f":"B41+F41+K41","v":0}]
[{"$f":"IF(B2=10,CONCATENATE(\"Fill Out Mileage Log worksheet to Compute Mileage Reimbursement\",\" --- Reimbursement calculated as \",'Mileage Log'!F4,\" miles @ \",\".14 permile\"),IF($N$2=FALSE, CONCATENATE(\"Fill Out Mileage Log worksheet to Compute Mileage Reimbursement\",\" --- Reimbursement calculated as \",'Mileage Log'!F4,\" miles @ \",RLT!A16,\" per mile\"), CONCATENATE(\"Fill Out Mileage Log worksheet to Compute Mileage Reimbursement\",\" --- Reimbursement calculated as \",'Mileage Log'!F4,\" miles @ \",\".194 permile\")))","v":"Fill Out Mileage Log worksheet to Compute Mileage Reimbursement --- Reimbursement calculated as 0 miles @ 0.575 per mile"},null,null,null,null,null,null,null,null,null,null,{"$f":"P5","v":0}]
["TOTALS",{"$f":"SUM(B19:B41)","v":0},null,{"$f":"SUM(D19:D41)","v":0},null,null,null,{"$f":"SUM(H19:H41)","v":0},null,null,{"$f":"SUM(K19:K41)","v":0},{"$f":"SUM(L19:L42)","v":0}]
["TOTALS from Page 2"]
["TOTAL TRIP CHARGES",null,null,null,null,null,null,null,null,null,null,{"$f":"L43+L46+L47","v":0}]
["Prepaid Transportation - Transportation paid via a Contract Agency or other non-reimburseable method",null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"<- Enter in Prepaid (Non-reimburseable expenses here)"]
["Registration Fees - Fees paid via Procard or other non-reimbursable method"]
["SUB -TOTAL (AMOUNT TO BE CHARGED TO KFS ACCOUNT(S) LISTED BELOW)**",null,null,null,null,null,null,null,null,null,null,{"$f":"L43","v":0}]
["LESS TOTAL ADVANCE (Enter in Travel Advance if taken for this trip)",null,null,null,null,null,null,null,null,null,null,null,null,"<- Enter in Travel Advance here"]
[{"$f":"IF(L50=0, \"Amount Due/Refund\", IF(L50<0, \"Amount Due to University\", \"Amount of Refund to Traveler\"))","v":"Amount Due/Refund"},null,null,null,null,null,null,null,null,null,null,{"$f":"L48-L49","v":0}]
["KFS ACCOUNTS",null,"OBJ CODE","AMOUNT",null,"Total ","REMARKS"]
[null,null,null,null,null,{"$f":"SUM(D52:D54)","v":0}]
[]
[]
["I CERTIFY THAT THE ABOVE IS A TRUE STATEMENT, THAT THE EXPENSES CLAIMED  WERE INCURRED BY ME ON OFFICIAL UNIVERSITY BUSINESS ON THE DATES SHOWN AND ALL EXPENSES CLAIMED HAVE NOT AND WILL NOT BE SUBMITTED FOR REIMBURSMENT TO THE UCONN FOUNDATION  OR ANY OTHER THIRD PARTY.   I FURTHER CERTIFY THAT I MAINTAIN AUTOMOBILE INSURANCE IN THE AMOUNT OF $50,000/$100,000 IF USING MY PERSONAL VEHICLE FOR BUSINESS RELATED PURPOSES.  THIS IS A FINAL SETTLEMENT OF ALL EXPENSES RELATED TO THE TRAVEL DATES ABOVE.                                                                                 "]
["Traveler's Signature:",null,null,null,null,null,null,"Date:"]
["Authorizing Name: ",null,null,null,null,null,"Signature",null,null,null,"Date:"]

{"sheet":"Per Diem Multiple Destinations","index":2,"n_rows":51,"n_cols":23,"rows_kept":51,"cut":false,"hidden":false,"merged":[[11,0,11,6],[48,17,48,18],[39,0,39,1],[39,3,39,4],[40,17,40,18],[41,17,41,18],[44,0,44,1],[44,3,44,4],[43,0,43,6],[36,0,36,1],[36,3,36,4],[37,3,37,4],[37,5,37,6],[38,3,38,4],[30,3,30,4],[31,0,31,1],[49,17,49,18],[45,3,45,4],[45,5,45,6],[46,3,46,4],[47,0,47,1],[47,3,47,4],[31,3,31,4],[32,17,32,18],[33,17,33,18],[35,0,35,6],[24,17,24,18],[25,17,25,18],[28,0,28,1],[28,3,28,4],[29,3,29,4],[29,5,29,6],[27,0,27,6],[21,3,21,4],[21,5,21,6],[22,3,22,4],[23,0,23,1],[23,3,23,4],[15,0,15,1],[15,3,15,4],[16,17,16,18],[17,17,17,18],[20,0,20,1],[20,3,20,4],[19,0,19,6],[12,0,12,1],[12,3,12,4],[13,3,13,4],[13,5,13,6],[14,3,14,4],[8,17,8,18],[9,17,9,18],[7,0,7,1],[6,3,6,4],[7,3,7,4],[0,0,0,6],[1,1,1,2],[2,1,2,2],[3,0,3,6],[5,5,5,6],[4,3,4,4],[4,0,4,1],[5,3,5,4]]}
["Multiple Destination - Per Diem Page"]
["Traveler:",{"$f":"IF('Travel Reimbursement'!B1=\"\",\"\",'Travel Reimbursement'!B1)","v":""},null,"Department:",{"$f":"IF('Travel Reimbursement'!H1=\"\",\"\",'Travel Reimbursement'!H1)","v":""},"U-box:",{"$f":"IF('Travel Reimbursement'!L1=\"\",\"\",'Travel Reimbursement'!L1)","v":""}]
["Affiliation:",{"$f":"VLOOKUP('Travel Reimbursement'!$B$2,intake!E2:F11,2)","v":"SELECT AFFILIATION"},null,"TA Number:",{"$f":"IF('Travel Reimbursement'!H2=\"\",\"\",'Travel Reimbursement'!H2)","v":""},"Subtotal:",{"$f":"SUM(G5,G13,G21, G29,G37,G45)","v":0}]
[]
["Per Diem #1",null,"Location:","here",null,"Location 1 Total",{"$f":"SUM(A11:G11)","v":0}]
["Select Rates:",1,null,"Date",null,"Time"]
["Foreign Rates:",null,"Depart:",{"$f":"IF('Travel Reimbursement'!B4=\"\",\"\",'Travel Reimbursement'!B4)","v":""},null,{"$f":"IF('Travel Reimbursement'!B5=\"\",\"\",'Travel Reimbursement'!B5)","v":""},{"$f":"IF('Travel Reimbursement'!F5=\"\",\"1\",'Travel Reimbursement'!F5)","v":1}]
[null,null,"Return:",null,null,null,2,null,{"$f":"IF(B6=8,2,1)","v":1},{"$f":"IF(B6=8,1,0)","v":0}]
[{"$f":"IF(D7 =\"\", \"\", D7)","v":""},{"$f":"IF(A9=\"\",\"\",(IF(A9+1<=$D$8,A9+1,\"\")))","v":""},"","","","","",null,{"$f":"IF(VLOOKUP(A10,RLT!$I$3:$X$14,$B$6+$I8)=\"None\",0,IF(A9=\"\",0,VLOOKUP(A10,RLT!$I$3:$X$14,$B$6+$I8)))","v":0},{"$f":"IF(VLOOKUP(B10,RLT!$I$3:$X$14,$B$6+$I8)=\"None\",0,IF(B9=\"\",0,VLOOKUP(B10,RLT!$I$3:$X$14,$B$6+$I8)))","v":0},{"$f":"IF(VLOOKUP(C10,RLT!$I$3:$X$14,$B$6+$I8)=\"None\",0,IF(C9=\"\",0,VLOOKUP(C10,RLT!$I$3:$X$14,$B$6+$I8)))","v":0},{"$f":"IF(VLOOKUP(D10,RLT!$I$3:$X$14,$B$6+$I8)=\"None\",0,IF(D9=\"\",0,VLOOKUP(D10,RLT!$I$3:$X$14,$B$6+$I8)))","v":0},{"$f":"IF(VLOOKUP(E10,RLT!$I$3:$X$14,$B$6+$I8)=\"None\",0,IF(E9=\"\",0,VLOOKUP(E10,RLT!$I$3:$X$14,$B$6+$I8)))","v":0},{"$f":"IF(VLOOKUP(F10,RLT!$I$3:$X$14,$B$6+$I8)=\"None\",0,IF(F9=\"\",0,VLOOKUP(F10,RLT!$I$3:$X$14,$B$6+$I8)))","v":0},{"$f":"IF(VLOOKUP(G10,RLT!$I$3:$X$14,$B$6+$I8)=\"None\",0,IF(G9=\"\",0,VLOOKUP(G10,RLT!$I$3:$X$14,$B$6+$I8)))","v":0},null,null,"M&IE Foreign Rate",null,"Breakfast","Lunch","Dinner","IE"]
[1,1,1,1,1,1,1,null,{"$f":"IF(I9=0, 0, IF($D7=\"\",0, IF(AND($F7<0.29166,$G7=1),I9,IF(AND($F7<0.45833,$G7=1),I9-HLOOKUP($B6+$J8,RLT!$J$1:$X$10,9),IF(AND($F7>=0.5,$F7<=0.541,$G7=1),I9,IF($G7=1,I9-HLOOKUP($B6+$J8,RLT!$J$1:$X$10,6),IF(AND($F7>=0.5,$F7<=0.541,$G7=2),I9-HLOOKUP($B6+$J8,RLT!$J$1:$X$10,6),IF(AND($F7<0.20833,$G7=2),I9-HLOOKUP($B6+$J8,RLT!$J$1:$X$10,6),0))))))))","v":0},{"$f":"IF(J9=0, 0,IF(C9=\"\",IF(OR(AND($F8<=0.541,$G8=1,$F8>=0.5), AND($F8<=0.375,$G8=1)),0, IF($G8=1,J9-HLOOKUP($B6+$J8,RLT!$J$1:$X$10,4), IF(AND($F8<=0.0833,$G8=2), J9-HLOOKUP($B6+$J8,RLT!$J$1:$X$10,4), IF(AND($F8<=0.2916,$G8=2),J9-HLOOKUP($B6+$J8,RLT!$J$1:$X$10,7),IF(AND($F8<=0.541,$F8>=0.5,$G8=2),J9-HLOOKUP($B6+$J8,RLT!$J$1:$X$10,4), J9)))) ),J9))","v":0},{"$f":"IF(K9=0, 0,IF(D9=\"\",IF(OR(AND($F8<=0.541,$G8=1,$F8>=0.5), AND($F8<=0.375,$G8=1)),0, IF($G8=1,K9-HLOOKUP($B6+$J8,RLT!$J$1:$X$10,4), IF(AND($F8<=0.0833,$G8=2), K9-HLOOKUP($B6+$J8,RLT!$J$1:$X$10,4), IF(AND($F8<=0.2916,$G8=2),K9-HLOOKUP($B6+$J8,RLT!$J$1:$X$10,7),IF(AND($F8<=0.541,$F8>=0.5,$G8=2),K9-HLOOKUP($B6+$J8,RLT!$J$1:$X$10,4), K9)))) ),K9))","v":0},{"$f":"IF(L9=0, 0,IF(E9=\"\",IF(OR(AND($F8<=0.541,$G8=1,$F8>=0.5), AND($F8<=0.375,$G8=1)),0, IF($G8=1,L9-HLOOKUP($B6+$J8,RLT!$J$1:$X$10,4), IF(AND($F8<=0.0833,$G8=2), L9-HLOOKUP($B6+$J8,RLT!$J$1:$X$10,4), IF(AND($F8<=0.2916,$G8=2),L9-HLOOKUP($B6+$J8,RLT!$J$1:$X$10,7),IF(AND($F8<=0.541,$F8>=0.5,$G8=2),L9-HLOOKUP($B6+$J8,RLT!$J$1:$X$10,4), L9)))) ),L9))","v":0},{"$f":"IF(M9=0, 0,IF(F9=\"\",IF(OR(AND($F8<=0.541,$G8=1,$F8>=0.5), AND($F8<=0.375,$G8=1)),0, IF($G8=1,M9-HLOOKUP($B6+$J8,RLT!$J$1:$X$10,4), IF(AND($F8<=0.0833,$G8=2), M9-HLOOKUP($B6+$J8,RLT!$J$1:$X$10,4), IF(AND($F8<=0.2916,$G8=2),M9-HLOOKUP($B6+$J8,RLT!$J$1:$X$10,7),IF(AND($F8<=0.541,$F8>=0.5,$G8=2),M9-HLOOKUP($B6+$J8,RLT!$J$1:$X$10,4), M9)))) ),M9))","v":0},{"$f":"IF(N9=0, 0,IF(G9=\"\",IF(OR(AND($F8<=0.541,$G8=1,$F8>=0.5), AND($F8<=0.375,$G8=1)),0, IF($G8=1,N9-HLOOKUP($B6+$J8,RLT!$J$1:$X$10,4), IF(AND($F8<=0.0833,$G8=2), N9-HLOOKUP($B6+$J8,RLT!$J$1:$X$10,4), IF(AND($F8<=0.2916,$G8=2),N9-HLOOKUP($B6+$J8,RLT!$J$1:$X$10,7),IF(AND($F8<=0.541,$F8>=0.5,$G8=2),N9-HLOOKUP($B6+$J8,RLT!$J$1:$X$10,4), N9)))) ),N9))","v":0},{"$f":"IF(O9=0, 0,IF(H9=\"\",IF(OR(AND($F8<=0.541,$G8=1,$F8>=0.5), AND($F8<=0.375,$G8=1)),0, IF($G8=1,O9-HLOOKUP($B6+$J8,RLT!$J$1:$X$10,4), IF(AND($F8<=0.0833,$G8=2), O9-HLOOKUP($B6+$J8,RLT!$J$1:$X$10,4), IF(AND($F8<=0.2916,$G8=2),O9-HLOOKUP($B6+$J8,RLT!$J$1:$X$10,7),IF(AND($F8<=0.541,$F8>=0.5,$G8=2),O9-HLOOKUP($B6+$J8,RLT!$J$1:$X$10,4), O9)))) ),O9))","v":0},{"$f":"SUMPRODUCT(--(I10:O10>0),I10:O10)","v":0},null,{"$f":"$B$7","v":0},null,{"$f":"IF($B$7=0, 0, VLOOKUP($B$7,RLT!$A$26:$E$294,2))","v":0},{"$f":"IF($B$7=0, 0, VLOOKUP($B$7,RLT!$A$26:$E$294,3))","v":0},{"$f":"IF($B$7=0, 0, VLOOKUP($B$7,RLT!$A$26:$E$294,4))","v":0},{"$f":"IF($B$7=0, 0, VLOOKUP($B$7,RLT!$A$26:$E$294,5))","v":0}]
[{"$f":"SUM(I10:I11)","v":0},0,0,0,0,0,0,null,{"$f":"IF(A10=9,0,IF(A9=\"\",0,IF(AND($B$6>1,$B$6<8),HLOOKUP($B$6,RLT!$B$1:$H$7,6),IF($B$6=8,$W$10,0))))","v":0},{"$f":"IF(B10=9,0,IF(B9=\"\",0,IF(AND($B$6>1,$B$6<8),HLOOKUP($B$6,RLT!$B$1:$H$7,6),IF($B$6=8,$W$10,0))))","v":0},{"$f":"IF(C10=9,0,IF(C9=\"\",0,IF(AND($B$6>1,$B$6<8),HLOOKUP($B$6,RLT!$B$1:$H$7,6),IF($B$6=8,$W$10,0))))","v":0},{"$f":"IF(D10=9,0,IF(D9=\"\",0,IF(AND($B$6>1,$B$6<8),HLOOKUP($B$6,RLT!$B$1:$H$7,6),IF($B$6=8,$W$10,0))))","v":0},{"$f":"IF(E10=9,0,IF(E9=\"\",0,IF(AND($B$6>1,$B$6<8),HLOOKUP($B$6,RLT!$B$1:$H$7,6),IF($B$6=8,$W$10,0))))","v":0},{"$f":"IF(F10=9,0,IF(F9=\"\",0,IF(AND($B$6>1,$B$6<8),HLOOKUP($B$6,RLT!$B$1:$H$7,6),IF($B$6=8,$W$10,0))))","v":0},{"$f":"IF(G10=9,0,IF(G9=\"\",0,IF(AND($B$6>1,$B$6<8),HLOOKUP($B$6,RLT!$B$1:$H$7,6),IF($B$6=8,$W$10,0))))","v":0},{"$f":"SUM(I11:O11)","v":0}]
[]
["Per Diem #2",null,"Location:",null,null,"Location 2 Total",{"$f":"SUM(A19:G19)","v":0}]
["Select Rates:",1,null,"Date",null,"Time"]
["Foreign Rates:",null,"Depart:",null,null,null,1]
[null,null,"Return:",null,null,null,2,null,{"$f":"IF(B14=8,3,1)","v":1},{"$f":"IF(B14=8,2,0)","v":0}]
[{"$f":"IF(D15 =\"\", \"\", D15)","v":""},{"$f":"IF(A17=\"\",\"\",(IF(A17+1<=$D$16,A17+1,\"\")))","v":""},"","","","","",null,{"$f":"IF(VLOOKUP(A18,RLT!$I$3:$X$14,$B14+$I16)=\"None\",0,IF(A17=\"\",0,VLOOKUP(A18,RLT!$I$3:$X$14,$B14+$I16)))","v":0},{"$f":"IF(VLOOKUP(B18,RLT!$I$3:$X$14,$B14+$I16)=\"None\",0,IF(B17=\"\",0,VLOOKUP(B18,RLT!$I$3:$X$14,$B14+$I16)))","v":0},{"$f":"IF(VLOOKUP(C18,RLT!$I$3:$X$14,$B14+$I16)=\"None\",0,IF(C17=\"\",0,VLOOKUP(C18,RLT!$I$3:$X$14,$B14+$I16)))","v":0},{"$f":"IF(VLOOKUP(D18,RLT!$I$3:$X$14,$B14+$I16)=\"None\",0,IF(D17=\"\",0,VLOOKUP(D18,RLT!$I$3:$X$14,$B14+$I16)))","v":0},{"$f":"IF(VLOOKUP(E18,RLT!$I$3:$X$14,$B14+$I16)=\"None\",0,IF(E17=\"\",0,VLOOKUP(E18,RLT!$I$3:$X$14,$B14+$I16)))","v":0},{"$f":"IF(VLOOKUP(F18,RLT!$I$3:$X$14,$B14+$I16)=\"None\",0,IF(F17=\"\",0,VLOOKUP(F18,RLT!$I$3:$X$14,$B14+$I16)))","v":0},{"$f":"IF(VLOOKUP(G18,RLT!$I$3:$X$14,$B14+$I16)=\"None\",0,IF(G17=\"\",0,VLOOKUP(G18,RLT!$I$3:$X$14,$B14+$I16)))","v":0},null,null,"M&IE Foreign Rate",null,"Breakfast","Lunch","Dinner","IE"]
[1,1,1,1,1,1,1,null,{"$f":"IF(I17=0, 0, IF($D15=\"\",0, IF(AND($F15<0.29166,$G15=1),I17,IF(AND($F15<0.45833,$G15=1),I17-HLOOKUP($B14+$J16,RLT!$J$1:$X$10,9),IF(AND($F15>=0.5,$F15<=0.541,$G15=1),I17,IF($G15=1,I17-HLOOKUP($B14+$J16,RLT!$J$1:$X$10,6),IF(AND($F15>=0.5,$F15<=0.541,$G15=2),I17-HLOOKUP($B14+$J16,RLT!$J$1:$X$10,6),IF(AND($F15<0.20833,$G15=2),I17-HLOOKUP($B14+$J16,RLT!$J$1:$X$10,6),0))))))))","v":0},{"$f":"IF(J17=0, 0,IF(C17=\"\",IF(OR(AND($F16<=0.541,$G16=1,$F16>=0.5), AND($F16<=0.375,$G16=1)),0, IF($G16=1,J17-HLOOKUP($B14+$J16,RLT!$J$1:$X$10,4), IF(AND($F16<=0.0833,$G16=2), J17-HLOOKUP($B14+$J16,RLT!$J$1:$X$10,4), IF(AND($F16<=0.2916,$G16=2),J17-HLOOKUP($B14+$J16,RLT!$J$1:$X$10,7),IF(AND($F16<=0.541,$F16>=0.5,$G16=2),J17-HLOOKUP($B14+$J16,RLT!$J$1:$X$10,4), J17)))) ),J17))","v":0},{"$f":"IF(K17=0, 0,IF(D17=\"\",IF(OR(AND($F16<=0.541,$G16=1,$F16>=0.5), AND($F16<=0.375,$G16=1)),0, IF($G16=1,K17-HLOOKUP($B14+$J16,RLT!$J$1:$X$10,4), IF(AND($F16<=0.0833,$G16=2), K17-HLOOKUP($B14+$J16,RLT!$J$1:$X$10,4), IF(AND($F16<=0.2916,$G16=2),K17-HLOOKUP($B14+$J16,RLT!$J$1:$X$10,7),IF(AND($F16<=0.541,$F16>=0.5,$G16=2),K17-HLOOKUP($B14+$J16,RLT!$J$1:$X$10,4), K17)))) ),K17))","v":0},{"$f":"IF(L17=0, 0,IF(E17=\"\",IF(OR(AND($F16<=0.541,$G16=1,$F16>=0.5), AND($F16<=0.375,$G16=1)),0, IF($G16=1,L17-HLOOKUP($B14+$J16,RLT!$J$1:$X$10,4), IF(AND($F16<=0.0833,$G16=2), L17-HLOOKUP($B14+$J16,RLT!$J$1:$X$10,4), IF(AND($F16<=0.2916,$G16=2),L17-HLOOKUP($B14+$J16,RLT!$J$1:$X$10,7),IF(AND($F16<=0.541,$F16>=0.5,$G16=2),L17-HLOOKUP($B14+$J16,RLT!$J$1:$X$10,4), L17)))) ),L17))","v":0},{"$f":"IF(M17=0, 0,IF(F17=\"\",IF(OR(AND($F16<=0.541,$G16=1,$F16>=0.5), AND($F16<=0.375,$G16=1)),0, IF($G16=1,M17-HLOOKUP($B14+$J16,RLT!$J$1:$X$10,4), IF(AND($F16<=0.0833,$G16=2), M17-HLOOKUP($B14+$J16,RLT!$J$1:$X$10,4), IF(AND($F16<=0.2916,$G16=2),M17-HLOOKUP($B14+$J16,RLT!$J$1:$X$10,7),IF(AND($F16<=0.541,$F16>=0.5,$G16=2),M17-HLOOKUP($B14+$J16,RLT!$J$1:$X$10,4), M17)))) ),M17))","v":0},{"$f":"IF(N17=0, 0,IF(G17=\"\",IF(OR(AND($F16<=0.541,$G16=1,$F16>=0.5), AND($F16<=0.375,$G16=1)),0, IF($G16=1,N17-HLOOKUP($B14+$J16,RLT!$J$1:$X$10,4), IF(AND($F16<=0.0833,$G16=2), N17-HLOOKUP($B14+$J16,RLT!$J$1:$X$10,4), IF(AND($F16<=0.2916,$G16=2),N17-HLOOKUP($B14+$J16,RLT!$J$1:$X$10,7),IF(AND($F16<=0.541,$F16>=0.5,$G16=2),N17-HLOOKUP($B14+$J16,RLT!$J$1:$X$10,4), N17)))) ),N17))","v":0},{"$f":"IF(O17=0, 0,IF(H17=\"\",IF(OR(AND($F16<=0.541,$G16=1,$F16>=0.5), AND($F16<=0.375,$G16=1)),0, IF($G16=1,O17-HLOOKUP($B14+$J16,RLT!$J$1:$X$10,4), IF(AND($F16<=0.0833,$G16=2), O17-HLOOKUP($B14+$J16,RLT!$J$1:$X$10,4), IF(AND($F16<=0.2916,$G16=2),O17-HLOOKUP($B14+$J16,RLT!$J$1:$X$10,7),IF(AND($F16<=0.541,$F16>=0.5,$G16=2),O17-HLOOKUP($B14+$J16,RLT!$J$1:$X$10,4), O17)))) ),O17))","v":0},{"$f":"SUMPRODUCT(--(I18:O18>0),I18:O18)","v":0},null,{"$f":"$B15","v":0},null,{"$f":"IF($B15=0, 0, VLOOKUP($B15,RLT!$A$26:$E$294,2))","v":0},{"$f":"IF($B15=0, 0, VLOOKUP($B15,RLT!$A$26:$E$294,3))","v":0},{"$f":"IF($B15=0, 0, VLOOKUP($B15,RLT!$A$26:$E$294,4))","v":0},{"$f":"IF($B15=0, 0, VLOOKUP($B15,RLT!$A$26:$E$294,5))","v":0}]
[{"$f":"SUM(I18:I19)","v":0},0,0,0,0,0,0,null,{"$f":"IF(A18=9,0,IF(A17=\"\",0,IF(AND($B14>1,$B14<8),HLOOKUP($B14,RLT!$B$1:$H$7,6),IF($B14=8,$W18,0))))","v":0},{"$f":"IF(B18=9,0,IF(B17=\"\",0,IF(AND($B14>1,$B14<8),HLOOKUP($B14,RLT!$B$1:$H$7,6),IF($B14=8,$W18,0))))","v":0},{"$f":"IF(C18=9,0,IF(C17=\"\",0,IF(AND($B14>1,$B14<8),HLOOKUP($B14,RLT!$B$1:$H$7,6),IF($B14=8,$W18,0))))","v":0},{"$f":"IF(D18=9,0,IF(D17=\"\",0,IF(AND($B14>1,$B14<8),HLOOKUP($B14,RLT!$B$1:$H$7,6),IF($B14=8,$W18,0))))","v":0},{"$f":"IF(E18=9,0,IF(E17=\"\",0,IF(AND($B14>1,$B14<8),HLOOKUP($B14,RLT!$B$1:$H$7,6),IF($B14=8,$W18,0))))","v":0},{"$f":"IF(F18=9,0,IF(F17=\"\",0,IF(AND($B14>1,$B14<8),HLOOKUP($B14,RLT!$B$1:$H$7,6),IF($B14=8,$W18,0))))","v":0},{"$f":"IF(G18=9,0,IF(G17=\"\",0,IF(AND($B14>1,$B14<8),HLOOKUP($B14,RLT!$B$1:$H$7,6),IF($B14=8,$W18,0))))","v":0},{"$f":"SUM(I19:O19)","v":0}]
[]
["Per Diem #3",null,"Location:",null,null,"Location 3 Total",{"$f":"SUM(A27:G27)","v":0}]
["Select Rates:",1,null,"Date",null,"Time"]
["Foreign Rates:",null,"Depart:",null,null,null,1]
[null,null,"Return:",null,null,null,2,null,{"$f":"IF(B22=8,4,1)","v":1},{"$f":"IF(B22=8,3,0)","v":0}]
[{"$f":"IF(D23 =\"\", \"\", D23)","v":""},{"$f":"IF(A25=\"\",\"\",(IF(A25+1<=$D$24,A25+1,\"\")))","v":""},"","","","","",null,{"$f":"IF(VLOOKUP(A26,RLT!$I$3:$X$14,$B22+$I24)=\"None\",0,IF(A25=\"\",0,VLOOKUP(A26,RLT!$I$3:$X$14,$B22+$I24)))","v":0},{"$f":"IF(VLOOKUP(B26,RLT!$I$3:$X$14,$B22+$I24)=\"None\",0,IF(B25=\"\",0,VLOOKUP(B26,RLT!$I$3:$X$14,$B22+$I24)))","v":0},{"$f":"IF(VLOOKUP(C26,RLT!$I$3:$X$14,$B22+$I24)=\"None\",0,IF(C25=\"\",0,VLOOKUP(C26,RLT!$I$3:$X$14,$B22+$I24)))","v":0},{"$f":"IF(VLOOKUP(D26,RLT!$I$3:$X$14,$B22+$I24)=\"None\",0,IF(D25=\"\",0,VLOOKUP(D26,RLT!$I$3:$X$14,$B22+$I24)))","v":0},{"$f":"IF(VLOOKUP(E26,RLT!$I$3:$X$14,$B22+$I24)=\"None\",0,IF(E25=\"\",0,VLOOKUP(E26,RLT!$I$3:$X$14,$B22+$I24)))","v":0},{"$f":"IF(VLOOKUP(F26,RLT!$I$3:$X$14,$B22+$I24)=\"None\",0,IF(F25=\"\",0,VLOOKUP(F26,RLT!$I$3:$X$14,$B22+$I24)))","v":0},{"$f":"IF(VLOOKUP(G26,RLT!$I$3:$X$14,$B22+$I24)=\"None\",0,IF(G25=\"\",0,VLOOKUP(G26,RLT!$I$3:$X$14,$B22+$I24)))","v":0},null,null,"M&IE Foreign Rate",null,"Breakfast","Lunch","Dinner","IE"]
[1,1,1,1,1,1,1,null,{"$f":"IF(I25=0, 0, IF($D23=\"\",0, IF(AND($F23<0.29166,$G23=1),I25,IF(AND($F23<0.45833,$G23=1),I25-HLOOKUP($B22+$J24,RLT!$J$1:$X$10,9),IF(AND($F23>=0.5,$F23<=0.541,$G23=1),I25,IF($G23=1,I25-HLOOKUP($B22+$J24,RLT!$J$1:$X$10,6),IF(AND($F23>=0.5,$F23<=0.541,$G23=2),I25-HLOOKUP($B22+$J24,RLT!$J$1:$X$10,6),IF(AND($F23<0.20833,$G23=2),I25-HLOOKUP($B22+$J24,RLT!$J$1:$X$10,6),0))))))))","v":0},{"$f":"IF(J25=0, 0,IF(C25=\"\",IF(OR(AND($F24<=0.541,$G24=1,$F24>=0.5), AND($F24<=0.375,$G24=1)),0, IF($G24=1,J25-HLOOKUP($B22+$J24,RLT!$J$1:$X$10,4), IF(AND($F24<=0.0833,$G24=2), J25-HLOOKUP($B22+$J24,RLT!$J$1:$X$10,4), IF(AND($F24<=0.2916,$G24=2),J25-HLOOKUP($B22+$J24,RLT!$J$1:$X$10,7),IF(AND($F24<=0.541,$F24>=0.5,$G24=2),J25-HLOOKUP($B22+$J24,RLT!$J$1:$X$10,4), J25)))) ),J25))","v":0},{"$f":"IF(K25=0, 0,IF(D25=\"\",IF(OR(AND($F24<=0.541,$G24=1,$F24>=0.5), AND($F24<=0.375,$G24=1)),0, IF($G24=1,K25-HLOOKUP($B22+$J24,RLT!$J$1:$X$10,4), IF(AND($F24<=0.0833,$G24=2), K25-HLOOKUP($B22+$J24,RLT!$J$1:$X$10,4), IF(AND($F24<=0.2916,$G24=2),K25-HLOOKUP($B22+$J24,RLT!$J$1:$X$10,7),IF(AND($F24<=0.541,$F24>=0.5,$G24=2),K25-HLOOKUP($B22+$J24,RLT!$J$1:$X$10,4), K25)))) ),K25))","v":0},{"$f":"IF(L25=0, 0,IF(E25=\"\",IF(OR(AND($F24<=0.541,$G24=1,$F24>=0.5), AND($F24<=0.375,$G24=1)),0, IF($G24=1,L25-HLOOKUP($B22+$J24,RLT!$J$1:$X$10,4), IF(AND($F24<=0.0833,$G24=2), L25-HLOOKUP($B22+$J24,RLT!$J$1:$X$10,4), IF(AND($F24<=0.2916,$G24=2),L25-HLOOKUP($B22+$J24,RLT!$J$1:$X$10,7),IF(AND($F24<=0.541,$F24>=0.5,$G24=2),L25-HLOOKUP($B22+$J24,RLT!$J$1:$X$10,4), L25)))) ),L25))","v":0},{"$f":"IF(M25=0, 0,IF(F25=\"\",IF(OR(AND($F24<=0.541,$G24=1,$F24>=0.5), AND($F24<=0.375,$G24=1)),0, IF($G24=1,M25-HLOOKUP($B22+$J24,RLT!$J$1:$X$10,4), IF(AND($F24<=0.0833,$G24=2), M25-HLOOKUP($B22+$J24,RLT!$J$1:$X$10,4), IF(AND($F24<=0.2916,$G24=2),M25-HLOOKUP($B22+$J24,RLT!$J$1:$X$10,7),IF(AND($F24<=0.541,$F24>=0.5,$G24=2),M25-HLOOKUP($B22+$J24,RLT!$J$1:$X$10,4), M25)))) ),M25))","v":0},{"$f":"IF(N25=0, 0,IF(G25=\"\",IF(OR(AND($F24<=0.541,$G24=1,$F24>=0.5), AND($F24<=0.375,$G24=1)),0, IF($G24=1,N25-HLOOKUP($B22+$J24,RLT!$J$1:$X$10,4), IF(AND($F24<=0.0833,$G24=2), N25-HLOOKUP($B22+$J24,RLT!$J$1:$X$10,4), IF(AND($F24<=0.2916,$G24=2),N25-HLOOKUP($B22+$J24,RLT!$J$1:$X$10,7),IF(AND($F24<=0.541,$F24>=0.5,$G24=2),N25-HLOOKUP($B22+$J24,RLT!$J$1:$X$10,4), N25)))) ),N25))","v":0},{"$f":"IF(O25=0, 0,IF(H25=\"\",IF(OR(AND($F24<=0.541,$G24=1,$F24>=0.5), AND($F24<=0.375,$G24=1)),0, IF($G24=1,O25-HLOOKUP($B22+$J24,RLT!$J$1:$X$10,4), IF(AND($F24<=0.0833,$G24=2), O25-HLOOKUP($B22+$J24,RLT!$J$1:$X$10,4), IF(AND($F24<=0.2916,$G24=2),O25-HLOOKUP($B22+$J24,RLT!$J$1:$X$10,7),IF(AND($F24<=0.541,$F24>=0.5,$G24=2),O25-HLOOKUP($B22+$J24,RLT!$J$1:$X$10,4), O25)))) ),O25))","v":0},{"$f":"SUMPRODUCT(--(I26:O26>0),I26:O26)","v":0},null,{"$f":"$B23","v":0},null,{"$f":"IF($B23=0, 0, VLOOKUP($B23,RLT!$A$26:$E$294,2))","v":0},{"$f":"IF($B23=0, 0, VLOOKUP($B23,RLT!$A$26:$E$294,3))","v":0},{"$f":"IF($B23=0, 0, VLOOKUP($B23,RLT!$A$26:$E$294,4))","v":0},{"$f":"IF($B23=0, 0, VLOOKUP($B23,RLT!$A$26:$E$294,5))","v":0}]
[{"$f":"SUM(I26:I27)","v":0},0,0,0,0,0,0,null,{"$f":"IF(A26=9,0,IF(A25=\"\",0,IF(AND($B22>1,$B22<8),HLOOKUP($B22,RLT!$B$1:$H$7,6),IF($B22=8,$W26,0))))","v":0},{"$f":"IF(B26=9,0,IF(B25=\"\",0,IF(AND($B22>1,$B22<8),HLOOKUP($B22,RLT!$B$1:$H$7,6),IF($B22=8,$W26,0))))","v":0},{"$f":"IF(C26=9,0,IF(C25=\"\",0,IF(AND($B22>1,$B22<8),HLOOKUP($B22,RLT!$B$1:$H$7,6),IF($B22=8,$W26,0))))","v":0},{"$f":"IF(D26=9,0,IF(D25=\"\",0,IF(AND($B22>1,$B22<8),HLOOKUP($B22,RLT!$B$1:$H$7,6),IF($B22=8,$W26,0))))","v":0},{"$f":"IF(E26=9,0,IF(E25=\"\",0,IF(AND($B22>1,$B22<8),HLOOKUP($B22,RLT!$B$1:$H$7,6),IF($B22=8,$W26,0))))","v":0},{"$f":"IF(F26=9,0,IF(F25=\"\",0,IF(AND($B22>1,$B22<8),HLOOKUP($B22,RLT!$B$1:$H$7,6),IF($B22=8,$W26,0))))","v":0},{"$f":"IF(G26=9,0,IF(G25=\"\",0,IF(AND($B22>1,$B22<8),HLOOKUP($B22,RLT!$B$1:$H$7,6),IF($B22=8,$W26,0))))","v":0},{"$f":"SUM(I27:O27)","v":0}]
[]
["Per Diem #4",null,"Location:",null,null,"Location 4 Total",{"$f":"SUM(A35:G35)","v":0}]
["Select Rates:",1,null,"Date",null,"Time"]
["Foreign Rates:",null,"Depart:",null,null,null,1]
[null,null,"Return:",null,null,null,1,null,{"$f":"IF(B30=8,5,1)","v":1},{"$f":"IF(B30=8,4,0)","v":0}]
[{"$f":"IF(D31 =\"\", \"\", D31)","v":""},{"$f":"IF(A33=\"\",\"\",(IF(A33+1<=$D$32,A33+1,\"\")))","v":""},"","","","","",null,{"$f":"IF(VLOOKUP(A34,RLT!$I$3:$X$14,$B30+$I32)=\"None\",0,IF(A33=\"\",0,VLOOKUP(A34,RLT!$I$3:$X$14,$B30+$I32)))","v":0},{"$f":"IF(VLOOKUP(B34,RLT!$I$3:$X$14,$B30+$I32)=\"None\",0,IF(B33=\"\",0,VLOOKUP(B34,RLT!$I$3:$X$14,$B30+$I32)))","v":0},{"$f":"IF(VLOOKUP(C34,RLT!$I$3:$X$14,$B30+$I32)=\"None\",0,IF(C33=\"\",0,VLOOKUP(C34,RLT!$I$3:$X$14,$B30+$I32)))","v":0},{"$f":"IF(VLOOKUP(D34,RLT!$I$3:$X$14,$B30+$I32)=\"None\",0,IF(D33=\"\",0,VLOOKUP(D34,RLT!$I$3:$X$14,$B30+$I32)))","v":0},{"$f":"IF(VLOOKUP(E34,RLT!$I$3:$X$14,$B30+$I32)=\"None\",0,IF(E33=\"\",0,VLOOKUP(E34,RLT!$I$3:$X$14,$B30+$I32)))","v":0},{"$f":"IF(VLOOKUP(F34,RLT!$I$3:$X$14,$B30+$I32)=\"None\",0,IF(F33=\"\",0,VLOOKUP(F34,RLT!$I$3:$X$14,$B30+$I32)))","v":0},{"$f":"IF(VLOOKUP(G34,RLT!$I$3:$X$14,$B30+$I32)=\"None\",0,IF(G33=\"\",0,VLOOKUP(G34,RLT!$I$3:$X$14,$B30+$I32)))","v":0},null,null,"M&IE Foreign Rate",null,"Breakfast","Lunch","Dinner","IE"]
[1,1,1,1,1,1,1,null,{"$f":"IF(I33=0, 0, IF($D31=\"\",0, IF(AND($F31<0.29166,$G31=1),I33,IF(AND($F31<0.45833,$G31=1),I33-HLOOKUP($B30+$J32,RLT!$J$1:$X$10,9),IF(AND($F31>=0.5,$F31<=0.541,$G31=1),I33,IF($G31=1,I33-HLOOKUP($B30+$J32,RLT!$J$1:$X$10,6),IF(AND($F31>=0.5,$F31<=0.541,$G31=2),I33-HLOOKUP($B30+$J32,RLT!$J$1:$X$10,6),IF(AND($F31<0.20833,$G31=2),I33-HLOOKUP($B30+$J32,RLT!$J$1:$X$10,6),0))))))))","v":0},{"$f":"IF(J33=0, 0,IF(C33=\"\",IF(OR(AND($F32<=0.541,$G32=1,$F32>=0.5), AND($F32<=0.375,$G32=1)),0, IF($G32=1,J33-HLOOKUP($B30+$J32,RLT!$J$1:$X$10,4), IF(AND($F32<=0.0833,$G32=2), J33-HLOOKUP($B30+$J32,RLT!$J$1:$X$10,4), IF(AND($F32<=0.2916,$G32=2),J33-HLOOKUP($B30+$J32,RLT!$J$1:$X$10,7),IF(AND($F32<=0.541,$F32>=0.5,$G32=2),J33-HLOOKUP($B30+$J32,RLT!$J$1:$X$10,4), J33)))) ),J33))","v":0},{"$f":"IF(K33=0, 0,IF(D33=\"\",IF(OR(AND($F32<=0.541,$G32=1,$F32>=0.5), AND($F32<=0.375,$G32=1)),0, IF($G32=1,K33-HLOOKUP($B30+$J32,RLT!$J$1:$X$10,4), IF(AND($F32<=0.0833,$G32=2), K33-HLOOKUP($B30+$J32,RLT!$J$1:$X$10,4), IF(AND($F32<=0.2916,$G32=2),K33-HLOOKUP($B30+$J32,RLT!$J$1:$X$10,7),IF(AND($F32<=0.541,$F32>=0.5,$G32=2),K33-HLOOKUP($B30+$J32,RLT!$J$1:$X$10,4), K33)))) ),K33))","v":0},{"$f":"IF(L33=0, 0,IF(E33=\"\",IF(OR(AND($F32<=0.541,$G32=1,$F32>=0.5), AND($F32<=0.375,$G32=1)),0, IF($G32=1,L33-HLOOKUP($B30+$J32,RLT!$J$1:$X$10,4), IF(AND($F32<=0.0833,$G32=2), L33-HLOOKUP($B30+$J32,RLT!$J$1:$X$10,4), IF(AND($F32<=0.2916,$G32=2),L33-HLOOKUP($B30+$J32,RLT!$J$1:$X$10,7),IF(AND($F32<=0.541,$F32>=0.5,$G32=2),L33-HLOOKUP($B30+$J32,RLT!$J$1:$X$10,4), L33)))) ),L33))","v":0},{"$f":"IF(M33=0, 0,IF(F33=\"\",IF(OR(AND($F32<=0.541,$G32=1,$F32>=0.5), AND($F32<=0.375,$G32=1)),0, IF($G32=1,M33-HLOOKUP($B30+$J32,RLT!$J$1:$X$10,4), IF(AND($F32<=0.0833,$G32=2), M33-HLOOKUP($B30+$J32,RLT!$J$1:$X$10,4), IF(AND($F32<=0.2916,$G32=2),M33-HLOOKUP($B30+$J32,RLT!$J$1:$X$10,7),IF(AND($F32<=0.541,$F32>=0.5,$G32=2),M33-HLOOKUP($B30+$J32,RLT!$J$1:$X$10,4), M33)))) ),M33))","v":0},{"$f":"IF(N33=0, 0,IF(G33=\"\",IF(OR(AND($F32<=0.541,$G32=1,$F32>=0.5), AND($F32<=0.375,$G32=1)),0, IF($G32=1,N33-HLOOKUP($B30+$J32,RLT!$J$1:$X$10,4), IF(AND($F32<=0.0833,$G32=2), N33-HLOOKUP($B30+$J32,RLT!$J$1:$X$10,4), IF(AND($F32<=0.2916,$G32=2),N33-HLOOKUP($B30+$J32,RLT!$J$1:$X$10,7),IF(AND($F32<=0.541,$F32>=0.5,$G32=2),N33-HLOOKUP($B30+$J32,RLT!$J$1:$X$10,4), N33)))) ),N33))","v":0},{"$f":"IF(O33=0, 0,IF(H33=\"\",IF(OR(AND($F32<=0.541,$G32=1,$F32>=0.5), AND($F32<=0.375,$G32=1)),0, IF($G32=1,O33-HLOOKUP($B30+$J32,RLT!$J$1:$X$10,4), IF(AND($F32<=0.0833,$G32=2), O33-HLOOKUP($B30+$J32,RLT!$J$1:$X$10,4), IF(AND($F32<=0.2916,$G32=2),O33-HLOOKUP($B30+$J32,RLT!$J$1:$X$10,7),IF(AND($F32<=0.541,$F32>=0.5,$G32=2),O33-HLOOKUP($B30+$J32,RLT!$J$1:$X$10,4), O33)))) ),O33))","v":0},{"$f":"SUMPRODUCT(--(I34:O34>0),I34:O34)","v":0},null,{"$f":"$B31","v":0},null,{"$f":"IF($B31=0, 0, VLOOKUP($B31,RLT!$A$26:$E$294,2))","v":0},{"$f":"IF($B31=0, 0, VLOOKUP($B31,RLT!$A$26:$E$294,3))","v":0},{"$f":"IF($B31=0, 0, VLOOKUP($B31,RLT!$A$26:$E$294,4))","v":0},{"$f":"IF($B31=0, 0, VLOOKUP($B31,RLT!$A$26:$E$294,5))","v":0}]
[{"$f":"SUM(I34:I35)","v":0},0,0,0,0,0,0,null,{"$f":"IF(A34=9,0,IF(A33=\"\",0,IF(AND($B30>1,$B30<8),HLOOKUP($B30,RLT!$B$1:$H$7,6),IF($B30=8,$W34,0))))","v":0},{"$f":"IF(B34=9,0,IF(B33=\"\",0,IF(AND($B30>1,$B30<8),HLOOKUP($B30,RLT!$B$1:$H$7,6),IF($B30=8,$W34,0))))","v":0},{"$f":"IF(C34=9,0,IF(C33=\"\",0,IF(AND($B30>1,$B30<8),HLOOKUP($B30,RLT!$B$1:$H$7,6),IF($B30=8,$W34,0))))","v":0},{"$f":"IF(D34=9,0,IF(D33=\"\",0,IF(AND($B30>1,$B30<8),HLOOKUP($B30,RLT!$B$1:$H$7,6),IF($B30=8,$W34,0))))","v":0},{"$f":"IF(E34=9,0,IF(E33=\"\",0,IF(AND($B30>1,$B30<8),HLOOKUP($B30,RLT!$B$1:$H$7,6),IF($B30=8,$W34,0))))","v":0},{"$f":"IF(F34=9,0,IF(F33=\"\",0,IF(AND($B30>1,$B30<8),HLOOKUP($B30,RLT!$B$1:$H$7,6),IF($B30=8,$W34,0))))","v":0},{"$f":"IF(G34=9,0,IF(G33=\"\",0,IF(AND($B30>1,$B30<8),HLOOKUP($B30,RLT!$B$1:$H$7,6),IF($B30=8,$W34,0))))","v":0},{"$f":"SUM(I35:O35)","v":0}]
[]
["Per Diem #5",null,"Location:",null,null,"Location 5 Total",{"$f":"SUM(A43:G43)","v":0}]
["Select Rates:",1,null,"Date",null,"Time"]
["Foreign Rates:",null,"Depart:",null,null,null,1]
[null,null,"Return:",null,null,null,1,null,{"$f":"IF(B38=8,6,1)","v":1},{"$f":"IF(B38=8,5,0)","v":0}]
[{"$f":"IF(D39 =\"\", \"\", D39)","v":""},{"$f":"IF(A41=\"\",\"\",(IF(A41+1<=$D$40,A41+1,\"\")))","v":""},"","","","","",null,{"$f":"IF(VLOOKUP(A42,RLT!$I$3:$X$14,$B38+$I40)=\"None\",0,IF(A41=\"\",0,VLOOKUP(A42,RLT!$I$3:$X$14,$B38+$I40)))","v":0},{"$f":"IF(VLOOKUP(B42,RLT!$I$3:$X$14,$B38+$I40)=\"None\",0,IF(B41=\"\",0,VLOOKUP(B42,RLT!$I$3:$X$14,$B38+$I40)))","v":0},{"$f":"IF(VLOOKUP(C42,RLT!$I$3:$X$14,$B38+$I40)=\"None\",0,IF(C41=\"\",0,VLOOKUP(C42,RLT!$I$3:$X$14,$B38+$I40)))","v":0},{"$f":"IF(VLOOKUP(D42,RLT!$I$3:$X$14,$B38+$I40)=\"None\",0,IF(D41=\"\",0,VLOOKUP(D42,RLT!$I$3:$X$14,$B38+$I40)))","v":0},{"$f":"IF(VLOOKUP(E42,RLT!$I$3:$X$14,$B38+$I40)=\"None\",0,IF(E41=\"\",0,VLOOKUP(E42,RLT!$I$3:$X$14,$B38+$I40)))","v":0},{"$f":"IF(VLOOKUP(F42,RLT!$I$3:$X$14,$B38+$I40)=\"None\",0,IF(F41=\"\",0,VLOOKUP(F42,RLT!$I$3:$X$14,$B38+$I40)))","v":0},{"$f":"IF(VLOOKUP(G42,RLT!$I$3:$X$14,$B38+$I40)=\"None\",0,IF(G41=\"\",0,VLOOKUP(G42,RLT!$I$3:$X$14,$B38+$I40)))","v":0},null,null,"M&IE Foreign Rate",null,"Breakfast","Lunch","Dinner","IE"]
[1,1,1,1,1,1,1,null,{"$f":"IF(I41=0, 0, IF($D39=\"\",0, IF(AND($F39<0.29166,$G39=1),I41,IF(AND($F39<0.45833,$G39=1),I41-HLOOKUP($B38+$J40,RLT!$J$1:$X$10,9),IF(AND($F39>=0.5,$F39<=0.541,$G39=1),I41,IF($G39=1,I41-HLOOKUP($B38+$J40,RLT!$J$1:$X$10,6),IF(AND($F39>=0.5,$F39<=0.541,$G39=2),I41-HLOOKUP($B38+$J40,RLT!$J$1:$X$10,6),IF(AND($F39<0.20833,$G39=2),I41-HLOOKUP($B38+$J40,RLT!$J$1:$X$10,6),0))))))))","v":0},{"$f":"IF(J41=0, 0,IF(C41=\"\",IF(OR(AND($F40<=0.541,$G40=1,$F40>=0.5), AND($F40<=0.375,$G40=1)),0, IF($G40=1,J41-HLOOKUP($B38+$J40,RLT!$J$1:$X$10,4), IF(AND($F40<=0.0833,$G40=2), J41-HLOOKUP($B38+$J40,RLT!$J$1:$X$10,4), IF(AND($F40<=0.2916,$G40=2),J41-HLOOKUP($B38+$J40,RLT!$J$1:$X$10,7),IF(AND($F40<=0.541,$F40>=0.5,$G40=2),J41-HLOOKUP($B38+$J40,RLT!$J$1:$X$10,4), J41)))) ),J41))","v":0},{"$f":"IF(K41=0, 0,IF(D41=\"\",IF(OR(AND($F40<=0.541,$G40=1,$F40>=0.5), AND($F40<=0.375,$G40=1)),0, IF($G40=1,K41-HLOOKUP($B38+$J40,RLT!$J$1:$X$10,4), IF(AND($F40<=0.0833,$G40=2), K41-HLOOKUP($B38+$J40,RLT!$J$1:$X$10,4), IF(AND($F40<=0.2916,$G40=2),K41-HLOOKUP($B38+$J40,RLT!$J$1:$X$10,7),IF(AND($F40<=0.541,$F40>=0.5,$G40=2),K41-HLOOKUP($B38+$J40,RLT!$J$1:$X$10,4), K41)))) ),K41))","v":0},{"$f":"IF(L41=0, 0,IF(E41=\"\",IF(OR(AND($F40<=0.541,$G40=1,$F40>=0.5), AND($F40<=0.375,$G40=1)),0, IF($G40=1,L41-HLOOKUP($B38+$J40,RLT!$J$1:$X$10,4), IF(AND($F40<=0.0833,$G40=2), L41-HLOOKUP($B38+$J40,RLT!$J$1:$X$10,4), IF(AND($F40<=0.2916,$G40=2),L41-HLOOKUP($B38+$J40,RLT!$J$1:$X$10,7),IF(AND($F40<=0.541,$F40>=0.5,$G40=2),L41-HLOOKUP($B38+$J40,RLT!$J$1:$X$10,4), L41)))) ),L41))","v":0},{"$f":"IF(M41=0, 0,IF(F41=\"\",IF(OR(AND($F40<=0.541,$G40=1,$F40>=0.5), AND($F40<=0.375,$G40=1)),0, IF($G40=1,M41-HLOOKUP($B38+$J40,RLT!$J$1:$X$10,4), IF(AND($F40<=0.0833,$G40=2), M41-HLOOKUP($B38+$J40,RLT!$J$1:$X$10,4), IF(AND($F40<=0.2916,$G40=2),M41-HLOOKUP($B38+$J40,RLT!$J$1:$X$10,7),IF(AND($F40<=0.541,$F40>=0.5,$G40=2),M41-HLOOKUP($B38+$J40,RLT!$J$1:$X$10,4), M41)))) ),M41))","v":0},{"$f":"IF(N41=0, 0,IF(G41=\"\",IF(OR(AND($F40<=0.541,$G40=1,$F40>=0.5), AND($F40<=0.375,$G40=1)),0, IF($G40=1,N41-HLOOKUP($B38+$J40,RLT!$J$1:$X$10,4), IF(AND($F40<=0.0833,$G40=2), N41-HLOOKUP($B38+$J40,RLT!$J$1:$X$10,4), IF(AND($F40<=0.2916,$G40=2),N41-HLOOKUP($B38+$J40,RLT!$J$1:$X$10,7),IF(AND($F40<=0.541,$F40>=0.5,$G40=2),N41-HLOOKUP($B38+$J40,RLT!$J$1:$X$10,4), N41)))) ),N41))","v":0},{"$f":"IF(O41=0, 0,IF(H41=\"\",IF(OR(AND($F40<=0.541,$G40=1,$F40>=0.5), AND($F40<=0.375,$G40=1)),0, IF($G40=1,O41-HLOOKUP($B38+$J40,RLT!$J$1:$X$10,4), IF(AND($F40<=0.0833,$G40=2), O41-HLOOKUP($B38+$J40,RLT!$J$1:$X$10,4), IF(AND($F40<=0.2916,$G40=2),O41-HLOOKUP($B38+$J40,RLT!$J$1:$X$10,7),IF(AND($F40<=0.541,$F40>=0.5,$G40=2),O41-HLOOKUP($B38+$J40,RLT!$J$1:$X$10,4), O41)))) ),O41))","v":0},{"$f":"SUMPRODUCT(--(I42:O42>0),I42:O42)","v":0},null,{"$f":"$B39","v":0},null,{"$f":"IF($B39=0, 0, VLOOKUP($B39,RLT!$A$26:$E$294,2))","v":0},{"$f":"IF($B39=0, 0, VLOOKUP($B39,RLT!$A$26:$E$294,3))","v":0},{"$f":"IF($B39=0, 0, VLOOKUP($B39,RLT!$A$26:$E$294,4))","v":0},{"$f":"IF($B39=0, 0, VLOOKUP($B39,RLT!$A$26:$E$294,5))","v":0}]
[{"$f":"SUM(I42:I43)","v":0},0,0,0,0,0,0,null,{"$f":"IF(A42=9,0,IF(A41=\"\",0,IF(AND($B38>1,$B38<8),HLOOKUP($B38,RLT!$B$1:$H$7,6),IF($B38=8,$W42,0))))","v":0},{"$f":"IF(B42=9,0,IF(B41=\"\",0,IF(AND($B38>1,$B38<8),HLOOKUP($B38,RLT!$B$1:$H$7,6),IF($B38=8,$W42,0))))","v":0},{"$f":"IF(C42=9,0,IF(C41=\"\",0,IF(AND($B38>1,$B38<8),HLOOKUP($B38,RLT!$B$1:$H$7,6),IF($B38=8,$W42,0))))","v":0},{"$f":"IF(D42=9,0,IF(D41=\"\",0,IF(AND($B38>1,$B38<8),HLOOKUP($B38,RLT!$B$1:$H$7,6),IF($B38=8,$W42,0))))","v":0},{"$f":"IF(E42=9,0,IF(E41=\"\",0,IF(AND($B38>1,$B38<8),HLOOKUP($B38,RLT!$B$1:$H$7,6),IF($B38=8,$W42,0))))","v":0},{"$f":"IF(F42=9,0,IF(F41=\"\",0,IF(AND($B38>1,$B38<8),HLOOKUP($B38,RLT!$B$1:$H$7,6),IF($B38=8,$W42,0))))","v":0},{"$f":"IF(G42=9,0,IF(G41=\"\",0,IF(AND($B38>1,$B38<8),HLOOKUP($B38,RLT!$B$1:$H$7,6),IF($B38=8,$W42,0))))","v":0},{"$f":"SUM(I43:O43)","v":0}]
[]
["Per Diem #6",null,"Location:",null,null,"Location 6 Total",{"$f":"SUM(A51:G51)","v":0}]
["Select Rates:",1,null,"Date",null,"Time"]
["Foreign Rates:",null,"Depart:",null,null,null,1]
[null,null,"Return:",null,null,null,1,null,{"$f":"IF(B46=8,7,1)","v":1},{"$f":"IF(B46=8,6,0)","v":0}]
[{"$f":"IF(D47 =\"\", \"\", D47)","v":""},{"$f":"IF(A49=\"\",\"\",(IF(A49+1<=$D$48,A49+1,\"\")))","v":""},"","","","","",null,{"$f":"IF(VLOOKUP(A50,RLT!$I$3:$X$14,$B46+$I48)=\"None\",0,IF(A49=\"\",0,VLOOKUP(A50,RLT!$I$3:$X$14,$B46+$I48)))","v":0},{"$f":"IF(VLOOKUP(B50,RLT!$I$3:$X$14,$B46+$I48)=\"None\",0,IF(B49=\"\",0,VLOOKUP(B50,RLT!$I$3:$X$14,$B46+$I48)))","v":0},{"$f":"IF(VLOOKUP(C50,RLT!$I$3:$X$14,$B46+$I48)=\"None\",0,IF(C49=\"\",0,VLOOKUP(C50,RLT!$I$3:$X$14,$B46+$I48)))","v":0},{"$f":"IF(VLOOKUP(D50,RLT!$I$3:$X$14,$B46+$I48)=\"None\",0,IF(D49=\"\",0,VLOOKUP(D50,RLT!$I$3:$X$14,$B46+$I48)))","v":0},{"$f":"IF(VLOOKUP(E50,RLT!$I$3:$X$14,$B46+$I48)=\"None\",0,IF(E49=\"\",0,VLOOKUP(E50,RLT!$I$3:$X$14,$B46+$I48)))","v":0},{"$f":"IF(VLOOKUP(F50,RLT!$I$3:$X$14,$B46+$I48)=\"None\",0,IF(F49=\"\",0,VLOOKUP(F50,RLT!$I$3:$X$14,$B46+$I48)))","v":0},{"$f":"IF(VLOOKUP(G50,RLT!$I$3:$X$14,$B46+$I48)=\"None\",0,IF(G49=\"\",0,VLOOKUP(G50,RLT!$I$3:$X$14,$B46+$I48)))","v":0},null,null,"M&IE Foreign Rate",null,"Breakfast","Lunch","Dinner","IE"]
[1,1,1,1,1,1,1,null,{"$f":"IF(I49=0, 0, IF($D47=\"\",0, IF(AND($F47<0.29166,$G47=1),I49,IF(AND($F47<0.45833,$G47=1),I49-HLOOKUP($B46+$J48,RLT!$J$1:$X$10,9),IF(AND($F47>=0.5,$F47<=0.541,$G47=1),I49,IF($G47=1,I49-HLOOKUP($B46+$J48,RLT!$J$1:$X$10,6),IF(AND($F47>=0.5,$F47<=0.541,$G47=2),I49-HLOOKUP($B46+$J48,RLT!$J$1:$X$10,6),IF(AND($F47<0.20833,$G47=2),I49-HLOOKUP($B46+$J48,RLT!$J$1:$X$10,6),0))))))))","v":0},{"$f":"IF(J49=0, 0,IF(C49=\"\",IF(OR(AND($F48<=0.541,$G48=1,$F48>=0.5), AND($F48<=0.375,$G48=1)),0, IF($G48=1,J49-HLOOKUP($B46+$J48,RLT!$J$1:$X$10,4), IF(AND($F48<=0.0833,$G48=2), J49-HLOOKUP($B46+$J48,RLT!$J$1:$X$10,4), IF(AND($F48<=0.2916,$G48=2),J49-HLOOKUP($B46+$J48,RLT!$J$1:$X$10,7),IF(AND($F48<=0.541,$F48>=0.5,$G48=2),J49-HLOOKUP($B46+$J48,RLT!$J$1:$X$10,4), J49)))) ),J49))","v":0},{"$f":"IF(K49=0, 0,IF(D49=\"\",IF(OR(AND($F48<=0.541,$G48=1,$F48>=0.5), AND($F48<=0.375,$G48=1)),0, IF($G48=1,K49-HLOOKUP($B46+$J48,RLT!$J$1:$X$10,4), IF(AND($F48<=0.0833,$G48=2), K49-HLOOKUP($B46+$J48,RLT!$J$1:$X$10,4), IF(AND($F48<=0.2916,$G48=2),K49-HLOOKUP($B46+$J48,RLT!$J$1:$X$10,7),IF(AND($F48<=0.541,$F48>=0.5,$G48=2),K49-HLOOKUP($B46+$J48,RLT!$J$1:$X$10,4), K49)))) ),K49))","v":0},{"$f":"IF(L49=0, 0,IF(E49=\"\",IF(OR(AND($F48<=0.541,$G48=1,$F48>=0.5), AND($F48<=0.375,$G48=1)),0, IF($G48=1,L49-HLOOKUP($B46+$J48,RLT!$J$1:$X$10,4), IF(AND($F48<=0.0833,$G48=2), L49-HLOOKUP($B46+$J48,RLT!$J$1:$X$10,4), IF(AND($F48<=0.2916,$G48=2),L49-HLOOKUP($B46+$J48,RLT!$J$1:$X$10,7),IF(AND($F48<=0.541,$F48>=0.5,$G48=2),L49-HLOOKUP($B46+$J48,RLT!$J$1:$X$10,4), L49)))) ),L49))","v":0},{"$f":"IF(M49=0, 0,IF(F49=\"\",IF(OR(AND($F48<=0.541,$G48=1,$F48>=0.5), AND($F48<=0.375,$G48=1)),0, IF($G48=1,M49-HLOOKUP($B46+$J48,RLT!$J$1:$X$10,4), IF(AND($F48<=0.0833,$G48=2), M49-HLOOKUP($B46+$J48,RLT!$J$1:$X$10,4), IF(AND($F48<=0.2916,$G48=2),M49-HLOOKUP($B46+$J48,RLT!$J$1:$X$10,7),IF(AND($F48<=0.541,$F48>=0.5,$G48=2),M49-HLOOKUP($B46+$J48,RLT!$J$1:$X$10,4), M49)))) ),M49))","v":0},{"$f":"IF(N49=0, 0,IF(G49=\"\",IF(OR(AND($F48<=0.541,$G48=1,$F48>=0.5), AND($F48<=0.375,$G48=1)),0, IF($G48=1,N49-HLOOKUP($B46+$J48,RLT!$J$1:$X$10,4), IF(AND($F48<=0.0833,$G48=2), N49-HLOOKUP($B46+$J48,RLT!$J$1:$X$10,4), IF(AND($F48<=0.2916,$G48=2),N49-HLOOKUP($B46+$J48,RLT!$J$1:$X$10,7),IF(AND($F48<=0.541,$F48>=0.5,$G48=2),N49-HLOOKUP($B46+$J48,RLT!$J$1:$X$10,4), N49)))) ),N49))","v":0},{"$f":"IF(O49=0, 0,IF(H49=\"\",IF(OR(AND($F48<=0.541,$G48=1,$F48>=0.5), AND($F48<=0.375,$G48=1)),0, IF($G48=1,O49-HLOOKUP($B46+$J48,RLT!$J$1:$X$10,4), IF(AND($F48<=0.0833,$G48=2), O49-HLOOKUP($B46+$J48,RLT!$J$1:$X$10,4), IF(AND($F48<=0.2916,$G48=2),O49-HLOOKUP($B46+$J48,RLT!$J$1:$X$10,7),IF(AND($F48<=0.541,$F48>=0.5,$G48=2),O49-HLOOKUP($B46+$J48,RLT!$J$1:$X$10,4), O49)))) ),O49))","v":0},{"$f":"SUMPRODUCT(--(I50:O50>0),I50:O50)","v":0},null,{"$f":"$B47","v":0},null,{"$f":"IF($B47=0, 0, VLOOKUP($B47,RLT!$A$26:$E$294,2))","v":0},{"$f":"IF($B47=0, 0, VLOOKUP($B47,RLT!$A$26:$E$294,3))","v":0},{"$f":"IF($B47=0, 0, VLOOKUP($B47,RLT!$A$26:$E$294,4))","v":0},{"$f":"IF($B47=0, 0, VLOOKUP($B47,RLT!$A$26:$E$294,5))","v":0}]
[{"$f":"SUM(I50:I51)","v":0},0,0,0,0,0,0,null,{"$f":"IF(A50=9,0,IF(A49=\"\",0,IF(AND($B46>1,$B46<8),HLOOKUP($B46,RLT!$B$1:$H$7,6),IF($B46=8,$W50,0))))","v":0},{"$f":"IF(B50=9,0,IF(B49=\"\",0,IF(AND($B46>1,$B46<8),HLOOKUP($B46,RLT!$B$1:$H$7,6),IF($B46=8,$W50,0))))","v":0},{"$f":"IF(C50=9,0,IF(C49=\"\",0,IF(AND($B46>1,$B46<8),HLOOKUP($B46,RLT!$B$1:$H$7,6),IF($B46=8,$W50,0))))","v":0},{"$f":"IF(D50=9,0,IF(D49=\"\",0,IF(AND($B46>1,$B46<8),HLOOKUP($B46,RLT!$B$1:$H$7,6),IF($B46=8,$W50,0))))","v":0},{"$f":"IF(E50=9,0,IF(E49=\"\",0,IF(AND($B46>1,$B46<8),HLOOKUP($B46,RLT!$B$1:$H$7,6),IF($B46=8,$W50,0))))","v":0},{"$f":"IF(F50=9,0,IF(F49=\"\",0,IF(AND($B46>1,$B46<8),HLOOKUP($B46,RLT!$B$1:$H$7,6),IF($B46=8,$W50,0))))","v":0},{"$f":"IF(G50=9,0,IF(G49=\"\",0,IF(AND($B46>1,$B46<8),HLOOKUP($B46,RLT!$B$1:$H$7,6),IF($B46=8,$W50,0))))","v":0},{"$f":"SUM(I51:O51)","v":0}]

{"sheet":"Mileage Log","index":3,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":false,"merged":[[4,1,5,1],[4,2,5,2],[4,3,5,3],[0,2,0,3],[1,2,1,3],[3,2,3,3],[2,2,2,3],[0,5,0,10],[1,5,1,10],[0,11,5,13],[4,4,5,4],[4,6,5,6],[4,5,5,5],[4,7,4,8],[4,10,5,10],[2,5,2,10],[3,5,3,10]]}
[null,"Traveler Name",{"$f":"IF('Travel Reimbursement'!$B$1 = \"\",\"\",'Travel Reimbursement'!$B$1)","v":""},null,"Travel Start Date",{"$f":"IF('Travel Reimbursement'!$B$4=\"\",\"\",'Travel Reimbursement'!$B$4)","v":""},null,null,null,null,null,"Incomplete mileage logs may result in delays, adjustments, and disapprovals. All calculations for commuting mile deduction are automatically calculated when completing the mileage log."]
[null,"One Way Commute",null,null,"Travel End Date",{"$f":"IF('Travel Reimbursement'!$H$4=\"\",\"\",'Travel Reimbursement'!$H$4)","v":""}]
[null,"Official Duty Station",{"$f":"VLOOKUP('Travel Reimbursement'!$H$3,intake!B2:C13,2)","v":"SELECT DUTY STATION"},null,"Home Address"]
[null,"Total Mileage",{"$f":"SUM(L7:L39)","v":0},null,"Reimburseable Miles",{"$f":"SUM(K7:K39)","v":0}]
[null,"Date","From (City/State)","To (City/State)","Business\nPurpose","Entered\nMileage","Did you Depart/Return from/to your Official Duty Station?","Odometer",null,null,"Calculated\nMileage"]
[null,null,null,null,null,null,null,"Start","Finish","Round Trip"]
[null,null,null,null,null,0,"No",null,null,"No",{"$f":"IF(OR($C$2=\"\",$F$3=\"\",B7=\"\",C7=\"\",D7=\"\",E7=\"\"),0,(IF(F7>0,IF(G7=\"NO\",IF(J7=\"YES\",IF((F7*2-$C$2*2)>0,F7*2-$C$2*2,0),IF((F7-$C$2)>0,F7-$C$2,0)),IF(J7=\"YES\",F7*2,F7)),0)))","v":0},{"$f":"IF(J7=\"YES\",F7*2,F7)","v":0}]
[null,null,null,null,null,0,"No",null,null,"No",{"$f":"IF(OR($C$2=\"\",$F$3=\"\",B8=\"\",C8=\"\",D8=\"\",E8=\"\"),0,(IF(F8>0,IF(G8=\"NO\",IF(J8=\"YES\",IF((F8*2-$C$2*2)>0,F8*2-$C$2*2,0),IF((F8-$C$2)>0,F8-$C$2,0)),IF(J8=\"YES\",F8*2,F8)),0)))","v":0},{"$f":"IF(J8=\"YES\",F8*2,F8)","v":0}]
[null,null,null,null,null,0,"No",null,null,"No",0,0]
[null,null,null,null,null,0,"No",null,null,"No",0,0]
[null,null,null,null,null,0,"No",null,null,"No",0,0]
[null,null,null,null,null,0,"No",null,null,"No",0,0]
[null,null,null,null,null,0,"No",null,null,"No",0,0]
[null,null,null,null,null,0,"No",null,null,"No",0,0]
[null,null,null,null,null,0,"No",null,null,"No",0,0]
[null,null,null,null,null,0,"No",null,null,"No",0,0]
[null,null,null,null,null,0,"No",null,null,"No",0,0]
[null,null,null,null,null,0,"No",null,null,"No",0,0]
[null,null,null,null,null,0,"No",null,null,"No",0,0]
[null,null,null,null,null,0,"No",null,null,"No",0,0]
[null,null,null,null,null,0,"No",null,null,"No",0,0]
[null,null,null,null,null,0,"No",null,null,"No",0,0]
[null,null,null,null,null,0,"No",null,null,"No",0,0]
[null,null,null,null,null,0,"No",null,null,"No",0,0]
[null,null,null,null,null,0,"No",null,null,"No",0,0]
[null,null,null,null,null,0,"No",null,null,"No",0,0]
[null,null,null,null,null,0,"No",null,null,"No",0,0]
[null,null,null,null,null,0,"No",null,null,"No",0,0]
[null,null,null,null,null,0,"No",null,null,"No",0,0]
[null,null,null,null,null,0,"No",null,null,"No",0,0]
[null,null,null,null,null,0,"No",null,null,"No",0,0]
[null,null,null,null,null,0,"No",null,null,"No",0,0]
[null,null,null,null,null,0,"No",null,null,"No",0,0]
[null,null,null,null,null,0,"No",null,null,"No",0,0]
[null,null,null,null,null,0,"No",null,null,"No",0,0]
[null,null,null,null,null,0,"No",null,null,"No",0,0]
[null,null,null,null,null,0,"No",null,null,"No",0,0]
[null,null,null,null,null,0,"No",null,null,"No",0,0]
[null,null,null,null,null,0,"No",null,null,"No",0,0]

{"sheet":"Business Meal Details","index":4,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[[34,0,34,1],[34,3,37,6],[37,0,37,1],[0,0,0,6],[33,0,33,5],[1,0,1,1],[1,4,1,6],[35,0,35,1],[36,0,36,1]]}
["Business Meal Form"]
["Employee Name",null,{"$f":"IF('Travel Reimbursement'!B1=\"\",\"\",'Travel Reimbursement'!B1)","v":""},"Department",{"$f":"IF('Travel Reimbursement'!H1=0,\"\",'Travel Reimbursement'!H1)","v":""}]
["Meal Date","Location Name ","Business Purpose","Attendee Last Name","Attendee First Name","Attendee Affiliation","Total Cost"]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["TOTAL",null,null,null,null,null,{"$f":"SUM(G4:G33)","v":0}]
["Field Name",null,"Description of Entry","Please list each attendee/guest on a separate line.  This form certifies every attendee/guest is invited by an employee of the University and has a legitimate business purpose for attending. This attendance must reflect actual attendees.  "]
["Business Purpose",null,"Explanation of business purpose for meal. "]
["Attendee Affiliation",null,"List affiliation of attendees to University                                                        (eg. Candidate, Speaker,  etc.)"]
["Total Cost",null,"Enter the total reimbursement requested as reflected on the itemized receipt. (Alcohol is not reimbursable)"]

{"sheet":"Meals With No Overnight","index":5,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,7],[17,0,17,1],[20,0,21,1],[20,2,21,2],[21,3,21,7],[17,3,19,7],[19,0,19,1],[1,0,1,1],[1,3,1,4],[1,5,1,6],[16,0,16,6],[18,0,18,1],[20,5,20,7],[20,3,20,4]]}
["Meal Reimbursement With No Overnight Stay"]
["Employee Name:",null,{"$f":"IF('Travel Reimbursement'!B1=\"\",\"\",'Travel Reimbursement'!B1)","v":""},"Official Duty Station:",null,{"$f":"VLOOKUP('Travel Reimbursement'!$H$3,intake!B2:C13,2)","v":"SELECT DUTY STATION"}]
["Meal Date","Location Name ","Business Purpose","Time Left Home/Duty Station","Time Returned to Home/Duty Station","Per diem Amount for Destination per Meal Claimed\nClick here to obtain Meal Rates","Select Meal For Reimbursment\nBreakfast / Lunch / Dinner ","Total Claimed - 75% of per diem amount"]
[null,null,null,null,null,null,null,{"$f":"IF(OR(F4=\"\",G4=\"\"),0,0.75*(INDEX(RLT!$B$3:$G$5,MATCH(G4,RLT!$A$3:$A$5,0),MATCH(F4,RLT!$B$2:$G$2,))))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(OR(F5=\"\",G5=\"\"),0,0.75*(INDEX(RLT!$B$3:$G$5,MATCH(G5,RLT!$A$3:$A$5,0),MATCH(F5,RLT!$B$2:$G$2,))))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(OR(F6=\"\",G6=\"\"),0,0.75*(INDEX(RLT!$B$3:$G$5,MATCH(G6,RLT!$A$3:$A$5,0),MATCH(F6,RLT!$B$2:$G$2,))))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(OR(F7=\"\",G7=\"\"),0,0.75*(INDEX(RLT!$B$3:$G$5,MATCH(G7,RLT!$A$3:$A$5,0),MATCH(F7,RLT!$B$2:$G$2,))))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(OR(F8=\"\",G8=\"\"),0,0.75*(INDEX(RLT!$B$3:$G$5,MATCH(G8,RLT!$A$3:$A$5,0),MATCH(F8,RLT!$B$2:$G$2,))))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(OR(F9=\"\",G9=\"\"),0,0.75*(INDEX(RLT!$B$3:$G$5,MATCH(G9,RLT!$A$3:$A$5,0),MATCH(F9,RLT!$B$2:$G$2,))))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(OR(F10=\"\",G10=\"\"),0,0.75*(INDEX(RLT!$B$3:$G$5,MATCH(G10,RLT!$A$3:$A$5,0),MATCH(F10,RLT!$B$2:$G$2,))))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(OR(F11=\"\",G11=\"\"),0,0.75*(INDEX(RLT!$B$3:$G$5,MATCH(G11,RLT!$A$3:$A$5,0),MATCH(F11,RLT!$B$2:$G$2,))))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(OR(F12=\"\",G12=\"\"),0,0.75*(INDEX(RLT!$B$3:$G$5,MATCH(G12,RLT!$A$3:$A$5,0),MATCH(F12,RLT!$B$2:$G$2,))))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(OR(F13=\"\",G13=\"\"),0,0.75*(INDEX(RLT!$B$3:$G$5,MATCH(G13,RLT!$A$3:$A$5,0),MATCH(F13,RLT!$B$2:$G$2,))))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(OR(F14=\"\",G14=\"\"),0,0.75*(INDEX(RLT!$B$3:$G$5,MATCH(G14,RLT!$A$3:$A$5,0),MATCH(F14,RLT!$B$2:$G$2,))))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(OR(F15=\"\",G15=\"\"),0,0.75*(INDEX(RLT!$B$3:$G$5,MATCH(G15,RLT!$A$3:$A$5,0),MATCH(F15,RLT!$B$2:$G$2,))))","v":0}]
[" ",null,null,null,null,null,null,{"$f":"IF(OR(F16=\"\",G16=\"\"),0,0.75*(INDEX(RLT!$B$3:$G$5,MATCH(G16,RLT!$A$3:$A$5,0),MATCH(F16,RLT!$B$2:$G$2,))))","v":0}]
["TOTAL CLAIMED",null,null,null,null,null,null,{"$f":"SUM(H4:H16)","v":0}]
["Field Name",null,"Description of Entry","Certification: I certify that I was away from my home and official duty station for more than ten hours and that these reimbursement requests are occasional and non-routine. I certify that the expenses claimed were incurred by me on official University business on the dates shown above.                                                                                                                                                                                                                                                                                             "]
["Business Purpose",null,"Explanation of business purpose for trip"]
["Per Diem Amount For Destination Per Meal Claimed",null,"1.) Away from home or duty station for at least (10) hours = lunch. \n2.) Away from home or duty station for at least (10) hours and departure is prior to 7:00am = lunch and breakfast. \n3.) Away from home or duty station for at least (10) hours and departure prior to 7:00am and returned after 7:00pm = lunch, breakfast and dinner."]
["Total Claimed",null,"75% of the GSA per diem meal rate in effect for each meal for destination of travel.",{"$f":"IF('Travel Reimbursement'!$B$1 = \"\",\"\",'Travel Reimbursement'!$B$1)","v":""},null,"Employee signature:____________________________________________________"]
[null,null,null,"Department Head, Director or Dean Approval (Ad Hoc Approval through KFS Preferred)\n\nSignature: ___________________________________________________________"]

{"sheet":"RLT","index":6,"n_rows":294,"n_cols":24,"rows_kept":294,"cut":false,"hidden":true,"merged":[[8,0,8,3],[17,0,17,4]]}
[1,2,3,4,5,6,7,8,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
["M&IE Total",46,51,56,61,66,71,{"$f":"SUM('Travel Reimbursement'!$T$3,'Travel Reimbursement'!$U$3,'Travel Reimbursement'!$V$3,'Travel Reimbursement'!$W$3)","v":0},null,"M&IE Total",{"$f":"B2","v":46},{"$f":"C2","v":51},56,61,66,71,0,{"$f":"R22","v":0},{"$f":"S22","v":0},0,0,0,0,0]
["Breakfast",7,8,9,10,11,12,{"$f":"'Travel Reimbursement'!$T$3","v":0},1,"None",{"$f":"K2-B6","v":41},46,51,56,61,66,0,{"$f":"R2-R26","v":0},0,0,0,0,0,0]
["Lunch",11,12,13,15,16,18,{"$f":"'Travel Reimbursement'!$U$3","v":0},2,"Breakfast only",{"$f":"K3-B3","v":34},38,42,46,50,54,0,{"$f":"R3-R23","v":0},0,0,0,0,0,0]
["Dinner",23,26,29,31,34,36,{"$f":"'Travel Reimbursement'!$V$3","v":0},3,"Lunch only",{"$f":"K3-B4","v":30},34,38,41,45,48,0,{"$f":"R3-R24","v":0},0,0,0,0,0,0]
["Incidentals",5,5,5,5,5,5,{"$f":"'Travel Reimbursement'!$W$3","v":0},4,"Dinner Only",{"$f":"K3-B5","v":18},20,22,25,27,30,0,{"$f":"R3-R25","v":0},0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,5,"Breakfast and Lunch",{"$f":"K3-B3-B4","v":23},26,29,31,34,36,0,{"$f":"R3-R23-R24","v":0},0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,6,"Breakfast and Dinner",{"$f":"K3-B3-B5","v":11},12,13,15,16,18,0,{"$f":"R3-R23-R25","v":0},0,0,0,0,0,0]
["Mileage Table",null,null,null,null,null,null,null,7,"Lunch and Dinner",{"$f":"K3-B4-B5","v":7},8,9,10,11,12,0,{"$f":"R3-R24-R25","v":0},0,0,0,0,0,0]
[null,"Prior","Previous","Current",null,null,null,null,8,"Bfast Lunch and Dinner",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,0.56499999999999995,0.56000000000000005,0.57499999999999996,null,null,null,null,9,"Personal Day",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["effective date","2013-01-29","2014-01-01","2015-01-28",null,null,null,null,10,"Did not Partake-Dietary",{"$f":"K2-B6","v":41},46,51,56,61,66,0,{"$f":"R2-R26","v":0},0,0,0,0,0,0]
[{"$f":"IF('Travel Reimbursement'!B4 = \"\", TODAY(),'Travel Reimbursement'!B4)","v":"2015-03-24"},null,null,null,null,null,null,null,11,"Did not partake-Religious",{"$f":"K2-B6","v":41},46,51,56,61,66,0,{"$f":"R2-R26","v":0},0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,12,"Did not partake-Business",{"$f":"K2-B6","v":41},46,51,56,61,66,0,{"$f":"R2-R26","v":0},0,0,0,0,0,0]
[null,null,null,false]
[{"$f":"IF(A13<C12,B11,IF(A13<D12,C11,D11))","v":0.57499999999999996},null,null,{"$f":"0.194","v":0.19400000000000001}]
[]
["CLASSIFIED EMPLOYEES TABLE"]
["BFAST","LUNCH","DINNER","MISC","TIPS"]
[7.5,9,20,0,0.15,null,null,null,null,null,null,null,null,null,null,null,null,"Multiple Per Diem - Foreign/Other - columns 9-15"]
[6,8,18,5,0.15,null,null,null,null,null,null,null,null,null,null,null,null,9,10,11,12,13,14,15]
[6,8,18,0,0.15,null,null,null,7,8,9,10,11,12,null,null,"M&IE Total",{"$f":"SUM('Per Diem Multiple Destinations'!T10:W10)","v":0},{"$f":"SUM('Per Diem Multiple Destinations'!T18:W18)","v":0},{"$f":"SUM('Per Diem Multiple Destinations'!T26:W26)","v":0},{"$f":"SUM('Per Diem Multiple Destinations'!T34:W34)","v":0},{"$f":"SUM('Per Diem Multiple Destinations'!T42:W42)","v":0},{"$f":"SUM('Per Diem Multiple Destinations'!T50:W50)","v":0},{"$f":"SUM('Per Diem Multiple Destinations'!T58:W58)","v":0}]
[5,7,16,0,0.15,null,null,null,11,12,13,15,16,18,null,null,"Breakfast",{"$f":"'Per Diem Multiple Destinations'!T10","v":0},{"$f":"'Per Diem Multiple Destinations'!T18","v":0},{"$f":"'Per Diem Multiple Destinations'!T26","v":0},{"$f":"'Per Diem Multiple Destinations'!T34","v":0},{"$f":"'Per Diem Multiple Destinations'!T42","v":0},{"$f":"'Per Diem Multiple Destinations'!T50","v":0},{"$f":"'Per Diem Multiple Destinations'!T58","v":0}]
[null,null,null,null,null,null,null,null,23,26,29,31,34,36,null,null,"Lunch",{"$f":"'Per Diem Multiple Destinations'!U10","v":0},{"$f":"'Per Diem Multiple Destinations'!U18","v":0},{"$f":"'Per Diem Multiple Destinations'!U26","v":0},{"$f":"'Per Diem Multiple Destinations'!U34","v":0},{"$f":"'Per Diem Multiple Destinations'!U42","v":0},{"$f":"'Per Diem Multiple Destinations'!U50","v":0},{"$f":"'Per Diem Multiple Destinations'!U58","v":0}]
["M &IE Rate","Breakfast","Lunch","Dinner","Incidentals",null,null,null,{"$f":"SUM(I22:I24)","v":41},46,51,56,61,66,null,null,"Dinner",{"$f":"'Per Diem Multiple Destinations'!V10","v":0},{"$f":"'Per Diem Multiple Destinations'!V18","v":0},{"$f":"'Per Diem Multiple Destinations'!V26","v":0},{"$f":"'Per Diem Multiple Destinations'!V34","v":0},{"$f":"'Per Diem Multiple Destinations'!V42","v":0},{"$f":"'Per Diem Multiple Destinations'!V50","v":0},{"$f":"'Per Diem Multiple Destinations'!V58","v":0}]
[1,0,0,0,1,null,null,null,{"$f":"I22/I23","v":0.63636363636363635},null,null,null,null,null,null,null,"Incidentals",{"$f":"'Per Diem Multiple Destinations'!W10","v":0},{"$f":"'Per Diem Multiple Destinations'!W18","v":0},{"$f":"'Per Diem Multiple Destinations'!W26","v":0},{"$f":"'Per Diem Multiple Destinations'!W34","v":0},{"$f":"'Per Diem Multiple Destinations'!W42","v":0},{"$f":"'Per Diem Multiple Destinations'!W50","v":0},{"$f":"'Per Diem Multiple Destinations'!W58","v":0}]
[2,0,0,1,1,null,null,null,{"$f":"I23/I24","v":0.47826086956521741}]
[3,0,1,1,1,null,null,null,{"$f":"I24/I25","v":0.56097560975609762}]
[4,1,1,1,1]
[5,1,1,2,1]
[6,1,2,2,1]
[7,1,2,3,1]
[8,1,2,3,2]
[9,1,2,4,2]
[10,2,2,4,2]
[11,2,3,4,2]
[12,2,3,5,2]
[13,2,3,5,3]
[14,2,4,5,3]
[15,2,4,6,3]
[16,2,4,7,3]
[17,3,4,7,3]
[18,3,5,7,3]
[19,3,5,8,3]
[20,3,5,8,4]
[21,3,5,9,4]
[22,3,6,9,4]
[23,3,6,9,5]
[24,4,6,9,5]
[25,4,6,10,5]
[26,4,7,11,5]
[27,4,7,11,5]
[28,4,7,11,6]
[29,4,7,12,6]
[30,5,7,12,6]
[31,5,8,12,6]
[32,5,8,13,6]
[33,5,8,13,7]
[34,5,9,13,7]
[35,5,9,14,7]
[36,5,9,15,7]
[37,6,9,15,7]
[38,6,10,15,7]
[39,6,10,16,7]
[40,6,10,16,8]
[41,6,10,17,8]
[42,6,11,17,8]
[43,6,11,17,9]
[44,7,11,17,9]
[45,7,11,18,9]
[46,7,12,18,9]
[47,7,12,19,9]
[48,7,12,19,10]
[49,7,12,20,10]
[50,8,12,20,10]
[51,8,13,20,10]
[52,8,13,21,10]
[53,8,13,21,11]
[54,8,14,21,11]
[55,8,14,22,11]
[56,8,14,23,11]
[57,9,14,23,11]
[58,9,15,23,11]
[59,9,15,24,11]
[60,9,15,24,12]
[61,9,15,25,12]
[62,9,16,25,12]
[63,9,16,25,13]
[64,10,16,25,13]
[65,10,16,26,13]
[66,10,17,26,13]
[67,10,17,27,13]
[68,10,17,27,14]
[69,10,17,28,14]
[70,11,17,28,14]
[71,11,18,28,14]
[72,11,18,29,14]
[73,11,18,29,15]
[74,11,19,29,15]
[75,11,19,30,15]
[76,11,19,31,15]
[77,12,19,31,15]
[78,12,20,31,15]
[79,12,20,32,15]
[80,12,20,32,16]
[81,12,20,33,16]
[82,12,21,33,16]
[83,12,21,33,17]
[84,13,21,33,17]
[85,13,21,34,17]
[86,13,22,34,17]
[87,13,22,35,17]
[88,13,22,35,18]
[89,13,22,36,18]
[90,14,22,36,18]
[91,14,23,36,18]
[92,14,23,37,18]
[93,14,23,37,19]
[94,14,24,37,19]
[95,14,24,38,19]
[96,14,24,39,19]
[97,15,24,39,19]
[98,15,25,39,19]
[99,15,25,40,19]
[100,15,25,40,20]
[101,15,25,41,20]
[102,15,26,41,20]
[103,15,26,41,21]
[104,16,26,41,21]
[105,16,26,42,21]
[106,16,27,42,21]
[107,16,27,43,21]
[108,16,27,43,22]
[109,16,27,44,22]
[110,17,27,44,22]
[111,17,28,44,22]
[112,17,28,45,22]
[113,17,28,45,23]
[114,17,29,45,23]
[115,17,29,46,23]
[116,17,29,47,23]
[117,18,29,47,23]
[118,18,30,47,23]
[119,18,30,48,23]
[120,18,30,48,24]
[121,18,30,49,24]
[122,18,31,49,24]
[123,18,31,49,25]
[124,19,31,49,25]
[125,19,31,50,25]
[126,19,32,50,25]
[127,19,32,51,25]
[128,19,32,51,26]
[129,19,32,52,26]
[130,20,32,52,26]
[131,20,33,52,26]
[132,20,33,53,26]
[133,20,33,53,27]
[134,20,34,53,27]
[135,20,34,54,27]
[136,20,34,55,27]
[137,21,34,55,27]
[138,21,35,55,27]
[139,21,35,56,27]
[140,21,35,56,28]
[141,21,35,57,28]
[142,21,36,57,28]
[143,21,36,57,29]
[144,22,36,57,29]
[145,22,36,58,29]
[146,22,37,58,29]
[147,22,37,59,29]
[148,22,37,59,30]
[149,22,37,60,30]
[150,23,37,60,30]
[151,23,38,60,30]
[152,23,38,61,30]
[153,23,38,61,31]
[154,23,39,61,31]
[155,23,39,62,31]
[156,23,39,63,31]
[157,24,39,63,31]
[158,24,40,63,31]
[159,24,40,64,31]
[160,24,40,64,32]
[161,24,40,65,32]
[162,24,41,65,32]
[163,24,41,65,33]
[164,25,41,65,33]
[165,25,41,66,33]
[166,25,42,66,33]
[167,25,42,67,33]
[168,25,42,67,34]
[169,25,42,68,34]
[170,26,42,68,34]
[171,26,43,68,34]
[172,26,43,69,34]
[173,26,43,69,35]
[174,26,44,69,35]
[175,26,44,70,35]
[176,26,44,71,35]
[177,27,44,71,35]
[178,27,45,71,35]
[179,27,45,72,35]
[180,27,45,72,36]
[181,27,45,73,36]
[182,27,46,73,36]
[183,27,46,73,37]
[184,28,46,73,37]
[185,28,46,74,37]
[186,28,47,74,37]
[187,28,47,75,37]
[188,28,47,75,38]
[189,28,47,76,38]
[190,29,47,76,38]
[191,29,48,76,38]
[192,29,48,77,38]
[193,29,48,77,39]
[194,29,49,77,39]
[195,29,49,78,39]
[196,29,49,79,39]
[197,30,49,79,39]
[198,30,50,79,39]
[199,30,50,80,39]
[200,30,50,80,40]
[201,30,50,81,40]
[202,30,51,81,40]
[203,30,51,81,41]
[204,31,51,81,41]
[205,31,51,82,41]
[206,31,52,82,42]
[207,31,52,83,41]
[208,31,52,83,42]
[209,31,52,84,42]
[210,32,52,84,42]
[211,32,53,84,42]
[212,32,53,85,42]
[213,32,53,85,43]
[214,32,54,85,43]
[215,32,54,86,43]
[216,32,54,87,43]
[217,33,54,87,43]
[218,33,55,87,43]
[219,33,55,88,43]
[220,33,55,88,44]
[221,33,55,89,44]
[222,33,56,89,44]
[223,33,56,89,45]
[224,34,56,89,45]
[225,34,56,90,45]
[226,34,57,90,45]
[227,34,57,91,45]
[228,34,57,91,46]
[229,34,57,92,46]
[230,35,57,92,46]
[231,35,58,92,46]
[232,35,58,93,46]
[233,35,58,93,47]
[234,35,59,93,47]
[235,35,59,94,47]
[236,35,59,95,47]
[237,36,59,95,47]
[238,36,60,95,47]
[239,36,60,96,47]
[240,36,60,96,48]
[241,36,60,97,48]
[242,36,61,97,48]
[243,36,61,97,49]
[244,37,61,97,49]
[245,37,61,98,49]
[246,37,62,98,49]
[247,37,62,99,49]
[248,37,62,99,50]
[249,37,62,100,50]
[250,38,62,100,50]
[251,38,63,100,50]
[252,38,63,101,50]
[253,38,63,101,51]
[254,38,64,101,51]
[255,38,64,102,51]
[256,38,64,103,51]
[257,39,64,103,51]
[258,39,65,103,51]
[259,39,65,104,51]
[260,39,65,104,52]
[261,39,65,105,52]
[262,39,66,105,52]
[263,39,66,105,53]
[264,40,66,105,53]
[265,40,66,106,53]
[266,{"$f":"A20+A20*$E$20","v":8.625},{"$f":"B20+B20*$E$20","v":10.35},{"$f":"C20+C20*$E$20","v":23},{"$f":"D20","v":0},"P2"]
[267,{"$f":"A21+A21*$E$21","v":6.9},{"$f":"B21+B21*$E$21","v":9.1999999999999993},{"$f":"C21+C21*$E$21","v":20.7},{"$f":"D21","v":5},"NP5"]
[268,{"$f":"A22+A22*$E$22","v":6.9},{"$f":"B22+B22*$E$22","v":9.1999999999999993},{"$f":"C22+C22*$E$22","v":20.7},{"$f":"D22","v":0},"NP3"]
[269,{"$f":"A23+A23*$E$23","v":5.75},{"$f":"B23+B23*$E$23","v":8.0500000000000007},{"$f":"C23+C23*$E$23","v":18.399999999999999},{"$f":"D23","v":0},"NP2"]