{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Instructions ","Form"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions ","index":0,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Instructions "]
[]
[null,null,"Please see additonal sheet below labeled \"Form\". "]
[]
[null,null,"Please do not edit on this site. "]
[]
[null,null,"Please save a copy of the form to edit. "]
[]
[null,null,"Once your copy has been completed please sign and submit to apporpriate person in your office. "]
[]
[null,null,"Please included the agenda and all other apporiate receipts/ expenses"]
[]
[null,null,"If you need assistance please contact the Auditor's office "]
[]
[null,"Phone # ","(406) 258-3230",null,"E-mail ","Lastevens@missoulacounty.us"]

{"sheet":"Form","index":1,"n_rows":49,"n_cols":10,"rows_kept":49,"cut":false,"hidden":false,"merged":[[29,5,29,8],[30,7,30,8],[31,7,31,8],[32,5,32,6],[32,7,32,8],[46,0,46,7],[47,0,47,7],[43,0,43,7],[39,0,39,2],[39,5,39,7],[40,0,40,2],[40,5,40,7],[45,0,45,7],[44,0,44,7],[41,5,41,7],[42,5,42,7],[37,0,37,8],[36,0,36,8],[8,0,8,2],[8,3,8,8],[29,0,29,3],[34,0,34,2],[32,0,32,2],[33,0,33,2],[24,0,24,1],[24,2,24,7],[25,2,25,7],[30,0,30,2],[31,0,31,2],[27,0,27,7],[33,5,34,8],[26,2,26,7],[26,0,26,1],[3,1,3,8],[4,1,4,8],[5,0,5,1],[5,2,5,6],[22,0,22,7],[9,0,9,8],[23,0,23,1],[25,0,25,1],[23,2,23,7],[11,6,11,9],[1,1,2,8],[6,0,6,1],[6,6,6,7],[7,2,7,8],[7,0,7,1],[6,3,6,4]]}
[]
[null,"MISSOULA COUNTY "]
[]
[null,"       EMPLOYEE TRAVEL ADVANCE/SETTLEMENT/REIMBURSEMENT FORM"]
[null,"      (RECEIPTS FOR ALL EXPENDITURES MUST BE ATTACHED)"]
["Employee Name:",null,null,null,null,null,null,"TA #"]
["Travel Advance:",null,null,"Travel Settlement",null,null,"Reimbursement:"]
["Destination City: ",null,"Emigrant & Livingston MT - Leadership Montana Session 1"]
["Reason for this claim:",null,null,"GSA Meal Per Diem Advance"]
[]
[]
[null,null,null,null,"Rate 1-1-24",0.67,"Use GSA per-diem rates (do not adjust for 75% F&L)"]
["Date","Depart \nTime","Return \nTime","Lodging \n($)","Miles \nDriven","Mileage \n($)","Breakfast \n($)","Lunch \n($)","Dinner\n ($)","Incidentals\n ($)"]
[null,null,null,null,null,{"$f":"E14*$F$12","v":0}]
[null,null,null,null,null,{"$f":"E15*$F$12","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
["Total",null,null,{"$f":"SUM(D14:D20)","v":0},{"$f":"SUM(E14:E20)","v":0},{"$f":"E21*$F$12","v":0},{"$f":"SUM(G14:G20)","v":0},{"$f":"SUM(H14:H20)","v":0},{"$f":"SUM(I14:I20)","v":0},{"$f":"SUM(J14:J20)","v":0}]
[]
["Other Expenses ",null,null,null,null,null,null,null,"Amount"]
["Common carrier"]
["Registration fees"]
["Other "]
["Other "]
["Total Other Expenses",null,null,null,null,null,null,null,{"$f":"SUM(I24:I27)","v":0}]
[]
["SUMMARY EXPENSES:",null,null,null,null,"Complete this section for Travel Settlement"]
["Lodging",null,null,{"$f":"$D$21","v":0},null,"Travel Advance:"]
["Mileage ",null,null,{"$f":"$F$21","v":0},null,"Less Travel settlement :"]
["Per-Diem (B, L, D,&I)",null,null,{"$f":"SUM($G$21:$J$21)","v":0},null,"Balance",null,{"$f":"$H$31-$H$32","v":0}]
["Other Expenses",null,null,{"$f":"$I$28","v":0},null,"If the travel advance is larger than the travel settlement, then the balance is owed to the county. If the travel settlement is larger than the travel advance, then the balance is owed to the employee."]
["Total",null,null,{"$f":"SUM(D31:D34)","v":0}]
[]
["EMPLOYEE CERTIFICATION - TRAVEL ADVANCE: I certify that this advance is for travel costs incurred in the conduct of my official duties of Missoula County and I agree that final settlement of all costs will be made within (15) working days of my return from the travel. If final settlement of the advance amount from Missoula County is not accomplished within the fifteen (15) days, it will be referred to the Auditor's Office, and I agree to have the entire amount of the advance deducted from my next payroll check."]
["I certify that this is a valid claim against Missoula County in accordance with all statutes and policy."]
[]
[null,null,null,"(                            )",null,null,null,null,"(                            )"]
["Employee Signature",null,null,"Date",null,"Department OR Supervisor approval",null,null,"Date"]
[null,null,null,null,null,null,null,null,"(                            )"]
[null,null,null,null,null,"Board approval",null,null,"Date"]
["Coding",null,null,null,null,null,null,null,"Amount"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Total",null,{"$f":"SUM(I45:I48)","v":0}]