{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Home"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Home","index":0,"n_rows":55,"n_cols":5,"rows_kept":55,"cut":false,"hidden":false,"merged":[[53,1,53,3],[49,1,49,3],[0,1,0,4],[3,2,3,4],[4,2,4,4],[7,2,7,4],[5,2,5,4],[1,1,1,4],[31,2,31,4],[6,2,6,4]]}
[null,"Travel Budget Worksheet"]
[null,"This worksheet is not mandatory but helps you calculate the costs needed on the Travel Authorization form. Fill in the light blue cells and all other cells will auto-populate. The orange cells are the amounts you will need to fill out your Travel Authorization form found on the I drive."]
[]
[null,"Name of Club:"]
[null,"Name of Event:"]
[null,"First day of travel:"]
[null,"Last day of travel:"]
[null,"Location including state:"]
[]
[null,null,"Estimated cost of trip",{"$f":"SUM(E21,E46,E35,E15,E51,E55)","v":0}]
[]
[null,"Number of students attending:",null,"Number of advisors attending:"]
[null,"Number of total days on trip:",{"$f":"IF(C7-C6=0,1,C7-C6+1)","v":1}]
[]
[null,"Registration",null,null,{"$f":"SUM(E17:E19)","v":0}]
[]
[null,"Student reg. cost (each):",null,"Total for all students :",{"$f":"SUM(C17*C12)","v":0}]
[]
[null,"Advisor reg. cost (each):",null,"Total for all advisors:",{"$f":"SUM(C19*E12)","v":0}]
[]
[null,"Food Cost (Per diem)",null,null,{"$f":"SUM(E24,E30)","v":0}]
[null,"GSA per diem from gsa.gov:"]
[]
[null,"Students' Food Cost (at 50% of GSA)",null,"Total student meals for trip:",{"$f":"SUM(B26*C13)","v":0}]
[]
[null,{"$f":"SUM(C12*C22)/2","v":0},"Total student meals per day"]
[]
[null,"Advisors' Food Cost"]
[null,{"$f":"IF(C7-C6=0,0.75,C7-C6+0.5)","v":0.75}]
[null,null,null,"Total advisors' per diem:",{"$f":"SUM(B33*E12)","v":0}]
[null,{"$f":"SUM(B29*C22)","v":0},"Per Diem for 1 advisor"]
[null,null,"Minus meals provided for 1 advisor"]
[null,{"$f":"SUM(B31-B32)","v":0},"Subtotal per advisor"]
[]
[null,"Hotel",null,null,{"$f":"SUM(E43*(C13-1))","v":0}]
[]
[null,"Hotel room size:",null,"1st room rate:"]
[null,"Number of rooms this size:",null,"1st room per night:",{"$f":"SUM(C38*E37)","v":0}]
[]
[null,"2nd room size, if more than one room type:",null,"2nd room rate:"]
[null,"Number of rooms this size:",null,"2nd room per night:",{"$f":"SUM(E40*C41)","v":0}]
[]
[null,null,null,"Total for all rooms per night ",{"$f":"SUM(E38+E41)","v":0}]
[]
[]
[null,"Transportation",null,"Auto Rental/Taxi:",{"$f":"SUM(E48*C13)","v":0}]
[]
[null,"Vehicle type preferred:",null,"Rental amount per day:"]
[]
[null,"If gas or parking is needed, list below. List on Travel Authorization form as other and explain in notes section."]
[null,"Gas",null,null,{"$f":"SUM(C51:C52)","v":0}]
[null,"Parking"]
[]
[null,"If Airline Tickets are needed, add cost of one below. The worksheet will multiply by the number of travelers. - List on Travel Authorization form as other and explain in notes section."]
[null,"Cost for one Airline Ticket:",null,"Airline Tickets total:",{"$f":"SUM(C12+E12)*C55","v":0}]