{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Expenses Sheet","Lists","Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":7,"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":"Expenses Sheet","index":0,"n_rows":242,"n_cols":13,"rows_kept":242,"cut":false,"hidden":false,"merged":[[2,3,2,11],[9,2,9,3],[10,2,10,3],[11,2,11,3],[5,1,5,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[6,10,7,10],[8,4,11,9]]}
[]
[]
[null,null,null,"TRAVEL & EXPENSES FORM"]
[]
[]
[null,"Utopia, Inc.",null,null,null,null,null,null,null,null,"Help Tool"]
[null,"* Name:","Reid Stanek",null,null,null,null,null,null,null,"Calculate GST From Total Amount"]
[]
[null,"* Project Name","Enbridge",null,"NOTE: ALL FIELDS WITH * ARE MANDATORY FIELDS TO BE COMPLETED. \nIF THE FIELD IS LEFT BLANK, YOUR CLAIM WILL BE RETURNED UNAPPROVED"]
[null,"Total Expenses:",{"$f":"I44","v":176.52},null,null,null,null,null,null,null,{"$f":"SUM(K9-K11)","v":0}]
[null,"Client","Enrbridge",null,null,null,null,null,null,null,{"$f":"SUM(K9/11)","v":0}]
[null,"Location","Calgary"]
[]
[]
[null,"Week Day","* Date","* Merchant's Name","* Details/Purpose Of Expense","* Net Amount","* GST","* HST","* Total Amount","* Does The Charge Have GST?","* Paid By Method: \nPersonal Credit Card \nUtopia Coporate Card","* Specify Who's Corporate Card Was Charge If A Utopia Corporate Card Was Used","* Is This Expense Billable Or Un-Billable To The Client"]
[null,{"$f":"IF(C16<>0,C16,\"\")","v":"2020-10-09"},"2020-10-09","FedEx","Shipping charges",88.26,null,null,{"$f":"SUM(F16:H16)","v":88.26},"N","Personal Card/Cash",null,"Billable"]
[null,"2020-10-09","2020-10-09","FedEx","Shipping charges",88.26,null,null,{"$f":"SUM(F17:H17)","v":88.26},"N","Personal Card/Cash",null,"Billable"]
[null,null,null,null,null,{"$f":"I18-(G18+H18)","v":0},null,null,null,"Y","Personal Card/Cash",null,"Billable"]
[null,null,null,null,null,0,null,null,null,"Y","Personal Card/Cash",null,"Billable"]
[null,null,null,null,null,0,null,null,null,"Y","Personal Card/Cash",null,"Billable"]
[null,null,null,null,null,0,null,null,null,"Y","Personal Card/Cash",null,"Billable"]
[null,null,null,null,null,0,null,null,null,"Y","Personal Card/Cash",null,"Billable"]
[null,null,null,null,null,0,null,null,null,"Y","Personal Card/Cash",null,"Billable"]
[null,null,null,null,null,0,null,null,null,"Y","Personal Card/Cash",null,"Billable"]
[null,null,null,null,null,0,null,null,null,"Y","Personal Card/Cash",null,"Billable"]
[null,null,null,null,null,0,null,null,null,"Y","Personal Card/Cash",null,"Billable"]
[null,null,null,null,null,0,null,null,null,"Y","Personal Card/Cash",null,"Billable"]
[null,null,null,null,null,0,null,null,null,"Y","Personal Card/Cash",null,"Billable"]
[null,null,null,null,null,0,null,null,null,"Y","Personal Card/Cash",null,"Billable"]
[null,null,null,null,null,0,null,null,null,"Y","Personal Card/Cash",null,"Billable"]
[null,null,null,null,null,0,null,null,null,"Y","Personal Card/Cash",null,"Billable"]
[null,null,null,null,null,0,null,null,null,"Y","Personal Card/Cash",null,"Billable"]
[null,null,null,null,null,0,null,null,null,"Y","Personal Card/Cash",null,"Billable"]
[null,null,null,null,null,0,null,null,null,"Y","Personal Card/Cash",null,"Billable"]
[null,null,null,null,null,0,null,null,null,"Y","Personal Card/Cash",null,"Billable"]
[null,null,null,null,null,0,null,null,null,"Y","Personal Card/Cash",null,"Billable"]
[null,"",null,null,null,0,null,null,null,"Y","Personal Card/Cash",null,"Billable"]
[null,"",null,null,null,0,null,null,null,"Y","Personal Card/Cash",null,"Billable"]
[null,"",null,null,null,0,null,null,null,"Y","Personal Card/Cash",null,"Billable"]
[null,"",null,null,null,0,null,null,null,"Y","Personal Card/Cash",null,"Billable"]
[null,"",null,null,null,0,null,null,null,"Y","Personal Card/Cash",null,"Billable"]
[null,"",null,null,null,0,null,null,null,"Y","Personal Card/Cash",null,"Billable"]
[null,"",null,null,null,0,null,null,null,"Y","Personal Card/Cash",null,"Billable"]
[null,null,null,null,null,{"$f":"SUM(F16:F43)","v":176.52},null,null,{"$f":"SUM(I16:I43)","v":176.52}]
[]
[null,null,null,null,null,"Net Amount",null,null,"Total Amount"]
[null,null,null,null,"Billable to Client",{"$f":"SUMIF($M$16:$M$44,\"Billable\",F16:F44)","v":176.52},{"$f":"SUMIF($M$16:$M$44,\"Billable\",G16:G44)","v":0},{"$f":"SUMIF($M$16:$M$44,\"Billable\",H16:H44)","v":0},{"$f":"SUMIF($M$16:$M$44,\"Billable\",I16:I44)","v":176.52},"CAD","Amount Utopia To Charge Client"]
[]
[null,null,null,null,"Un-Billable Amount to Client",{"$f":"SUMIF($M$16:$M$44,\"Non Billable\",F16:F44)","v":0},{"$f":"SUMIF($M$16:$M$44,\"Non Billable\",G16:G44)","v":0},{"$f":"SUMIF($M$16:$M$44,\"Non Billable\",H16:H44)","v":0},{"$f":"SUMIF($M$16:$M$44,\"Non Billable\",I16:I44)","v":0},"CAD","Not To Be Billed To Client"]
[]
[null,null,null,null,"Paid By Utopia Corporate Card",{"$f":"SUMIF($K$16:$K$44,\"Utopia Corporate Card\",F16:F44)","v":0},{"$f":"SUMIF($K$16:$K$44,\"Utopia Corporate Card\",G16:G44)","v":0},{"$f":"SUMIF($K$16:$K$44,\"Utopia Corporate Card\",H16:H44)","v":0},{"$f":"SUMIF($K$16:$K$44,\"Utopia Corporate Card\",I16:I44)","v":0},"CAD"]
[]
[null,null,null,null,"Expenses Paid by Contract Employee",{"$f":"SUMIF($K$16:$K$44,\"Personal Card/Cash\",F16:F44)","v":176.52},{"$f":"SUMIF($K$16:$K$44,\"Personal Card/Cash\",G16:G44)","v":0},{"$f":"SUMIF($K$16:$K$44,\"Personal Card/Cash\",H16:H44)","v":0},{"$f":"SUMIF($K$16:$K$44,\"Personal Card/Cash\",I16:I44)","v":176.52},"CAD"]
[null,null,null,null,"Per Diem Payable",{"$f":"SUMIF($E$16:$E$44,\"Per Diem\",F16:F44)","v":0},null,null,{"$f":"SUMIF($E$16:$E$44,\"Per Diem\",I16:I44)","v":0},"CAD"]
[null,null,null,null,"Total Amount Payable to Contractor / Employee",{"$f":"SUM(F53:F54)","v":176.52},{"$f":"SUM(G53:G54)","v":0},0,{"$f":"SUM(I53:I54)","v":176.52},"CAD","Amount Payable To Contractor / Employee"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Utopia Exp"]
[null,null,null,null,null,null,null,null,"Client Exp"]

{"sheet":"Lists","index":1,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Accommodation","Personal Card/Cash","Billable","Asset Works Management","Y"]
["Flights","Utopia Corporate Card","Non Billable","Enterprise Services","N"]
["Per Diem","N/A",null,"Finance & Planning"]
["Taxi",null,null,"Health & Safety"]
["Parking",null,null,"Procurement"]
["Seat",null,null,"SuccessFactors"]
["Car Rental"]
["Fuel"]
["Cell Phone"]

{"sheet":"Sheet1","index":2,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["TYPE"]
["Accommodation","Personal Card/Cash","Billable","Asset Works Management","Y"]
["Car Rental"]
["Flights","Utopia Corporate Card","Non Billable","Enterprise Services","N"]
["Fuel"]
["Meal"]
["Mileage"]
["Parking",null,null,"Procurement"]
["Per Diem","N/A",null,"Finance & Planning"]
["Seat",null,null,"SuccessFactors"]
["Taxi",null,null,"Health & Safety"]