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

{"sheet":"Instructions","index":0,"n_rows":32,"n_cols":2,"rows_kept":32,"cut":false,"hidden":false,"merged":[[20,0,20,1]]}
["When should I use this form?"]
["·         ","This form should only be used by employees when a Travel Diary has not been submitted through Concur or is non-compliant."]
[]
["How to complete this form?"]
["·         ","Save the worksheet and amend the file name with your details (TR No_your surname_Firstname) "]
["·         ","Input information into blue cells only"]
["·         ","Enter employee name and staff ID"]
["·         ","Select travelling in capacity of Staff (if appropriate)"]
["·         ","Enter Travel Request No. and summary of Trip Purpose"]
["·         ","Enter Date trip commenced (eg: departed)"]
["·         ","Enter Date trip commenced (departed)"]
["·         ","Enter Date trip ended (arrived home)"]
["·         ","A line for each day is automatically populated based on date trip commenced/ended"]
["·         ","Enter description of activity (refer to below)"]
["·         ","Enter location"]
["·         ","Enter start and finish times"]
["·         ","Select Nature of activity from dropdown (NB: If relates to a private day, enter descrition of activity as \"Personal\""]
["·         ","Once all information is populated in blue cells, red error messages should be removed"]
[]
["What information do I need to input into \"Description of activity\" on the form?"]
["This should include sufficient information to enable the activity to be connected to your employment. Stating \"Business\", \"Conference\" or \"Meeting\" is insufficient. The business activity should include relevant information, for example:"]
["·         ","If in transit or rest day, these should be describe as such under the \"Descrition of activity\" "]
["·         ","Name of conference & organiser (eg: Accounting Conference, CA ANZ or International Teachers convention etc)"]
["·         ","Meeting with Whom and venue (eg: Meeting with Science Faculty, New York University)"]
["·         ","Teaching at Tianjin Uni"]
["·         ","For any personal days, input relavant information eg: Annual Leave or Personal Day etc"]
[]
["Any tips and Tricks?"]
["·         ","If entering multiple days for the same duration, place, nature - complete first line and then copy and paste (drag down the cells) for each day."]
[]
["Why do I need to complete a Travel Diary?"]
["·         ","A Travel Diary is a daily record of each business activity undertaken during University travel and is a requirement of the Australian Taxation Office. Where a travel diary is not maintained or compliant, Fringe Benefits Tax may apply to the whole trip."]

{"sheet":"TravelDiary","index":1,"n_rows":371,"n_cols":11,"rows_kept":371,"cut":false,"hidden":false,"merged":[[28,1,29,1],[28,2,29,2],[28,3,29,3],[28,9,29,9],[28,7,29,7],[28,4,28,6],[20,4,21,9],[24,4,24,9],[1,1,1,10],[19,4,19,9],[8,2,10,9],[4,5,4,6],[4,7,4,9],[17,4,17,9],[2,1,2,9]]}
[null,"counta(G:G)"]
[null,"Travel Diary"]
[]
[]
[null,"SCU traveller's name:",null,"Staff ID:",null,"Travelling in capacity as:",null,null,null,null,{"$f":"IF(E21<>\"\",\"\",\"Ref \"&#REF!&\".00_P\"&TEXT(D22/D26,\"0.00\"))","v":""}]
[]
[null,"Summary of Travel Event"]
[]
[null,"TR No. and Trip Purpose:"]
[]
[]
[]
[null,"Date commenced:",null,{"$f":"IFERROR(IF($C$13<TODAY(),\"F\",VLOOKUP($C$13-TODAY(),Lookup!L3,2,TRUE)),0)","v":"F"}]
[]
[null,"Date ended:"]
[]
[]
[null,"Categorisation of travel days",null,null,{"$f":"IFERROR(IF(OR((E20<>\"\"),( E21<>\"\"),),\"ERROR MESSAGES\",\"\"),0)","v":"ERROR MESSAGES"}]
[null,"Category","Days","%"]
[null,"Days spent in travel",{"$f":"COUNTIF(TravelDiary,Lookup!J3)","v":0},{"$f":"IF($C$26=0,0,C20/$C$26)","v":0},{"$f":"IFERROR(IF(C15-C13<=0,\"Date ended must be later than date commenced. \",\"\"),0)","v":"Date ended must be later than date commenced. "}]
[null,"Business",{"$f":"COUNTIF(TravelDiary,Lookup!J4)","v":0},{"$f":"IF($C$26=0,0,C21/$C$26)","v":0},{"$f":"IFERROR(IF(OR(ISBLANK(C5),ISBLANK(E5),ISBLANK(H5),ISBLANK(C9),AND(D13=\"T\",ISBLANK(#REF!))),\"Ensure all blue fields above are complete. \",\"\")&IF(C15-C13+1<>C26,\"Travel diary information below is incomplete, please ensure that all days have a green tick beside them.\",\"\"),0)","v":"Ensure all blue fields above are complete. Travel diary information below is incomplete, please ensure that all days have a green tick beside them."}]
[null,"Rest Day",{"$f":"COUNTIF(TravelDiary,Lookup!J5)","v":0},{"$f":"IF($C$26=0,0,C22/$C$26)","v":0}]
[null,"Private Weekend",{"$f":"COUNTIF(TravelDiary,Lookup!J6)","v":0},{"$f":"IF($C$26=0,0,C23/$C$26)","v":0}]
[null,"Unavoidable Private day",{"$f":"COUNTIF(TravelDiary,Lookup!J7)","v":0},0]
[null,"Private/Leave day",{"$f":"COUNTIF(TravelDiary,Lookup!J8)","v":0},0,{"$f":"IFERROR(IF(OR((E20<>\"\"),(E21<>\"\"),),\"If you have any questions, please email corpfin@scu.edu.au\",\"\"),0)","v":"If you have any questions, please email corpfin@scu.edu.au"}]
[null,"Total travel days",{"$f":"SUM(C20:C25)","v":0},{"$f":"SUM(D20:D25)","v":0}]
[]
[]
[null,"Date of Activity","Description of activity(ies) for the entire day","Location","Time Taken",null,null,"Nature of Activity",null,"Deemed Category"]
[null,null,null,null,"Start","Finish","Duration"]
[null,{"$f":"IF(ISBLANK(C13),\" \",C13)","v":" "},null,null,null,null,{"$f":"IF(OR(ISBLANK(E31)),0,(F31-E31)*24)","v":0},null,null,{"$f":"IF(H31<>0,H31,\"\")","v":""},{"$f":"(IF(B31<>\"\",IF(AND(C31<>\"\",D31<>\"\",G31>0,H31<>\"\"),100,IF(AND(C31<>\"\",D31<>\"\",OR(H31=\"Private/leave day\",H31=\"Rest Day\",H31=\"Unavoidable Private Day\")),100,0)),\"\"))","v":0}]
[null,{"$f":"IF(B31=\"\",\"\",IF(B31<$C$15,B31+1,\"\"))","v":""},null,null,null,null,{"$f":"IF(OR(ISBLANK(E32)),0,(F32-E32)*24)","v":0},null,null,{"$f":"IF(H32<>0,H32,\"\")","v":""},""]
[null,{"$f":"IF(B32=\"\",\"\",IF(B32<$C$15,B32+1,\"\"))","v":""},null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",{"$f":"(IF(B45<>\"\",IF(AND(C45<>\"\",D45<>\"\",G45>0,H45<>\"\"),100,IF(AND(C45<>\"\",D45<>\"\",OR(H45=\"Private/leave day\",H45=\"Rest Day\",H45=\"Unavoidable Private Day\")),100,0)),\"\"))","v":""}]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,{"$f":"IF(OR(ISBLANK(E95)),0,(F95-E95)*24)","v":0},null,null,"",""]
[null,"",null,null,null,null,0,null,null,{"$f":"IF(H96<>0,H96,\"\")","v":""},""]
[null,{"$f":"IF(B96=\"\",\"\",IF(B96<$C$15,B96+1,\"\"))","v":""},null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",{"$f":"(IF(B98<>\"\",IF(AND(C98<>\"\",D98<>\"\",G98>0,H98<>\"\"),100,IF(AND(C98<>\"\",D98<>\"\",OR(H98=\"Private/leave day\",H98=\"Rest Day\",H98=\"Unavoidable Private Day\")),100,0)),\"\"))","v":""}]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,{"$f":"IF(OR(ISBLANK(E159)),0,(F159-E159)*24)","v":0},null,null,"",""]
[null,"",null,null,null,null,0,null,null,{"$f":"IF(H160<>0,H160,\"\")","v":""},""]
[null,{"$f":"IF(B160=\"\",\"\",IF(B160<$C$15,B160+1,\"\"))","v":""},null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",{"$f":"(IF(B162<>\"\",IF(AND(C162<>\"\",D162<>\"\",G162>0,H162<>\"\"),100,IF(AND(C162<>\"\",D162<>\"\",OR(H162=\"Private/leave day\",H162=\"Rest Day\",H162=\"Unavoidable Private Day\")),100,0)),\"\"))","v":""}]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,{"$f":"IF(OR(ISBLANK(E223)),0,(F223-E223)*24)","v":0},null,null,"",""]
[null,"",null,null,null,null,0,null,null,{"$f":"IF(H224<>0,H224,\"\")","v":""},""]
[null,{"$f":"IF(B224=\"\",\"\",IF(B224<$C$15,B224+1,\"\"))","v":""},null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",{"$f":"(IF(B226<>\"\",IF(AND(C226<>\"\",D226<>\"\",G226>0,H226<>\"\"),100,IF(AND(C226<>\"\",D226<>\"\",OR(H226=\"Private/leave day\",H226=\"Rest Day\",H226=\"Unavoidable Private Day\")),100,0)),\"\"))","v":""}]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,{"$f":"IF(OR(ISBLANK(E287)),0,(F287-E287)*24)","v":0},null,null,"",""]
[null,"",null,null,null,null,0,null,null,{"$f":"IF(H288<>0,H288,\"\")","v":""},""]
[null,{"$f":"IF(B288=\"\",\"\",IF(B288<$C$15,B288+1,\"\"))","v":""},null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",{"$f":"(IF(B290<>\"\",IF(AND(C290<>\"\",D290<>\"\",G290>0,H290<>\"\"),100,IF(AND(C290<>\"\",D290<>\"\",OR(H290=\"Private/leave day\",H290=\"Rest Day\",H290=\"Unavoidable Private Day\")),100,0)),\"\"))","v":""}]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,{"$f":"IF(OR(ISBLANK(E351)),0,(F351-E351)*24)","v":0},null,null,"",""]
[null,"",null,null,null,null,0,null,null,{"$f":"IF(H352<>0,H352,\"\")","v":""},""]
[null,{"$f":"IF(B352=\"\",\"\",IF(B352<$C$15,B352+1,\"\"))","v":""},null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",{"$f":"(IF(B354<>\"\",IF(AND(C354<>\"\",D354<>\"\",G354>0,H354<>\"\"),100,IF(AND(C354<>\"\",D354<>\"\",OR(H354=\"Private/leave day\",H354=\"Rest Day\",H354=\"Unavoidable Private Day\")),100,0)),\"\"))","v":""}]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,"",null,null,null,null,0,null,null,"",""]
[null,{"$f":"IF(B370=\"\",\"\",IF(B370<$C$15,B370+1,\"\"))","v":""},null,null,null,null,{"$f":"IF(OR(ISBLANK(E371)),0,(F371-E371)*24)","v":0},null,null,"",""]

{"sheet":"Lookup","index":2,"n_rows":50,"n_cols":12,"rows_kept":50,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Travelling_Capacity",null,"Nature_Activity",null,"Start",null,"Finish",null,"Travel_Diary_Cat",null,"Date"]
[null,"Staff",null,"Travel",null,"06:00:00",null,"06:00:00",null,"Travel",null,"{0,\"T\";21,\"F\";85,\"T\"}"]
[null,"Student",null,"Business",null,"06:30:00",null,"06:30:00",null,"Business"]
[null,"Visitor",null,"Rest Day",null,"07:00:00",null,"07:00:00",null,"Rest Day"]
[null,null,null,"Private Weekend",null,"07:30:00",null,"07:30:00",null,"Private Weekend"]
[null,null,null,"Unavoidable Private day",null,"08:00:00",null,"08:00:00",null,"Unavoidable Private day"]
[null,null,null,"Private/leave day",null,"08:30:00",null,"08:30:00",null,"Private/leave day"]
[null,null,null,null,null,"09:00:00",null,"09:00:00"]
[null,null,null,null,null,"09:30:00",null,"09:30:00"]
[null,null,null,null,null,"10:00:00",null,"10:00:00"]
[null,null,null,null,null,"10:30:00",null,"10:30:00"]
[null,null,null,null,null,"11:00:00",null,"11:00:00"]
[null,null,null,null,null,"11:30:00",null,"11:30:00"]
[null,null,null,null,null,"12:00:00",null,"12:00:00"]
[null,null,null,null,null,"12:30:00",null,"12:30:00"]
[null,null,null,null,null,"13:00:00",null,"13:00:00"]
[null,null,null,null,null,"13:30:00",null,"13:30:00"]
[null,null,null,null,null,"14:00:00",null,"14:00:00"]
[null,null,null,null,null,"14:30:00",null,"14:30:00"]
[null,null,null,null,null,"15:00:00",null,"15:00:00"]
[null,null,null,null,null,"15:30:00",null,"15:30:00"]
[null,null,null,null,null,"16:00:00",null,"16:00:00"]
[null,null,null,null,null,"16:30:00",null,"16:30:00"]
[null,null,null,null,null,"17:00:00",null,"17:00:00"]
[null,null,null,null,null,"17:30:00",null,"17:30:00"]
[null,null,null,null,null,"18:00:00",null,"18:00:00"]
[null,null,null,null,null,"18:30:00",null,"18:30:00"]
[null,null,null,null,null,"19:00:00",null,"19:00:00"]
[null,null,null,null,null,"19:30:00",null,"19:30:00"]
[null,null,null,null,null,"20:00:00",null,"20:00:00"]
[null,null,null,null,null,"20:30:00",null,"20:30:00"]
[null,null,null,null,null,"21:00:00",null,"21:00:00"]
[null,null,null,null,null,"21:30:00",null,"21:30:00"]
[null,null,null,null,null,"22:00:00",null,"22:00:00"]
[null,null,null,null,null,"22:30:00",null,"22:30:00"]
[null,null,null,null,null,"23:00:00",null,"23:00:00"]
[null,null,null,null,null,"23:30:00",null,"23:30:00"]
[null,null,null,null,null,0.999999999999999,null,0.999999999999999]
[null,null,null,null,null,1.0208333333333299,null,1.0208333333333299]
[null,null,null,null,null,1.0416666666666601,null,1.0416666666666601]
[null,null,null,null,null,1.06249999999999,null,1.06249999999999]
[null,null,null,null,null,1.0833333333333199,null,1.0833333333333199]
[null,null,null,null,null,1.1041666666666501,null,1.1041666666666501]
[null,null,null,null,null,1.12499999999998,null,1.12499999999998]
[null,null,null,null,null,1.1458333333333199,null,1.1458333333333199]
[null,null,null,null,null,1.1666666666666501,null,1.1666666666666501]
[null,null,null,null,null,1.18749999999998,null,1.18749999999998]
[null,null,null,null,null,1.2083333333333099,null,1.2083333333333099]
[null,null,null,null,null,1.2291666666666401,null,1.2291666666666401]