{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Candidature Budget","Payment process","Variables","Travel Plan Template","maximum approved funding","Seminar Attendance","Natural codes","Travel Diary","Claim Form"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":27,"comments":1,"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":"Candidature Budget","index":0,"n_rows":82,"n_cols":14,"rows_kept":82,"cut":false,"hidden":false,"merged":[[11,1,11,3],[13,2,13,3],[13,5,13,6],[13,8,13,9],[14,2,14,3],[14,5,14,6],[14,8,14,9]]}
["Faculty of Arts"]
["Candidature Budget",null,null,null,null,"This template to be used for:"]
["Select Degree",null,null,null,null,"Initial Confirmation of Candidature Budget, revisions of budget and processing of funding requests"]
["Maximum Support from Essential Funding Scholarship","5000 (PhD/Mphil); $1000 (MRes) via graduate research essential funding scholarship",null,null,null,"Budget Items Listed under \"Faculty Graduate Research Essential Funding Scholarsihp\" must be approved via:"]
["Copy Editing: Inclusive of a maximum of:","ESL only, Max $1,000 for PhD/Mphil; Max $300 MRes Y2",null,null,null,"Graduate Research Essential Funding Scholarship Application form"]
[]
[]
[]
["First name / Last name",null,"Student number:"]
["School/Department:",null,"Part time/Full time"]
["Email:",null,"Phone:"]
["Address:"]
["Start date:",null,"Expected completion date:"]
[null,null,"Year 1\nDates: (Note: for PT candidates, each \"year\" corresponds to 2 calendar years)",null,"Dept/School Administration Use Only","Year 2\nDates: (Note: for PT candidates, each \"year\" corresponds to 2 calendar years)",null,"Dept/School Administration Use Only","Year 3\nDates: (Note: for PT candidates, each \"year\" corresponds to 2 calendar years)",null,"Dept/School Administration Use Only",null,"Dept/School Administration Use Only"]
[null,null,"Source of Funding",null,"Year 1 Actuals ","Source of Funding",null,"Year 2 Actuals","Source of Funding",null,"Year 3 Actuals",null,"Total Actuals"]
[null,null,"Column 1:  Faculty Graduate Research Essential Funding Scholarship ONLY","Column 2: Use this column for any expenses that will be supported through other funding sources - eg: PGRF, external funding grants, personal funding.",null,"Column 1:  Faculty Graduate Research Essential Funding Scholarship ONLY","Column 2: Use this column for any expenses that will be supported through other sources of funding source - eg: PGRF, external funding grants, personal funding.",null,"Column 1:  Faculty Graduate Research Essential Funding Scholarship ONLY","Column 2: Use this column for any expenses that will be supported through other sources of funding source - eg: PGRF, external funding grants, personal funding.",null,"totals"]
["Activity","Details ie. Trip Destination, Name of Conference/s, Database Name; anticipated funding source (if not Essential Funding Scholarship)"]
["Data Collection"]
["Transcription Costs",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C19:J19)","v":0}]
["Participant Compensation",null,null,null,null,null,null,null,null,null,null,0]
["Marketing and Advertising",null,null,null,null,null,null,null,null,null,null,0]
["Translation",null,null,null,null,null,null,null,null,null,null,0]
["Statistical/Other data",null,null,null,null,null,null,null,null,null,null,0]
["Acquisition of primary sources",null,null,null,null,null,null,null,null,null,null,0]
["Interrator Reliability/Blind Coding",null,null,null,null,null,null,null,null,null,null,0]
["Critical Training",null,null,null,null,null,null,null,null,null,null,0]
["Software"]
["Equipment"]
["Library/Archive Fees"]
["Fieldwork Travel",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C30:J30)","v":0}]
["Return Airfare",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C31:J31)","v":0}]
["Accommodation",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C32:J32)","v":0}]
["Meals and incidentals",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C33:J33)","v":0}]
["Transport ",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C34:J34)","v":0}]
["SIM Card"]
["Conference and/or value-add research activity (**)",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C36:J36)","v":0}]
["Conference registration",null,null,null,null,null,null,null,null,null,null,0]
["Visa",null,null,null,null,null,null,null,null,null,null,0]
["Return Airfare",null,null,null,null,null,null,null,null,null,null,0]
["Accommodation",null,null,null,null,null,null,null,null,null,null,0]
["Meals and incidentals",null,null,null,null,null,null,null,null,null,null,0]
["Transport ",null,null,null,null,null,null,null,null,null,null,0]
["Research visit",null,null,null,null,null,null,null,null,null,null,0]
["Return Airfare",null,null,null,null,null,null,null,null,null,null,0]
["Accommodation",null,null,null,null,null,null,null,null,null,null,0]
["Meals and incidentals",null,null,null,null,null,null,null,null,null,null,0]
["Transport ",null,null,null,null,null,null,null,null,null,null,0]
["Thesis Production",null,null,null,null,null,null,null,null,null,null,0]
["Copy editing (ESL only)",null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(L49>1200, \"Exceeded $1,200\", \"\")","v":""}]
["Other",null,null,null,null,null,null,null,null,null,null,0]
["A)",null,null,null,null,null,null,null,null,null,null,0]
["B)",null,null,null,null,null,null,null,null,null,null,0]
["C)"]
[]
["Total (Copy editing is included)",null,{"$f":"SUM(C19:C54)","v":0},{"$f":"SUM(D19:D54)","v":0},{"$f":"SUM(E18:E54)","v":0},0,0,{"$f":"SUM(H18:H54)","v":0},0,0,null,0,null,{"$f":"IF(L55>10000, \"Exceeded $10,000\", \"\")","v":""}]
[]
[]
["Total Funding per Source"]
["Faculty",{"$f":"C55+F55+I55","v":0}]
["Other (*)",{"$f":"D55+G55+J55","v":0},{"$f":"IF(B60>0,\"Please provide additional details\",\"\")","v":""}]
[]
["Total Budget",{"$f":"SUM(B59:B60)","v":0}]
[]
["Funding per Year"]
["Year 1",{"$f":"SUM(C55:D55)","v":0}]
["Year 2",{"$f":"SUM(F55:G55)","v":0}]
["Year 3",{"$f":"SUM(I55:J55)","v":0}]
[]
[]
["Total Budget",{"$f":"SUM(B65:B68)","v":0}]
[]
["* Please provide details"]
["** Please provide name and location of each conferrence attanded"]
[" - conference in Year 1"]
["Name of Conference"]
["Name of Paper"]
[" - conference in Year 2"]
["Name of Conference"]
["Name of Paper"]
[" - conference in Year 3"]
["Name of Conference"]
["Name of Paper"]

{"sheet":"Payment process","index":1,"n_rows":47,"n_cols":9,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
["Version",2022.02]
["HDR Travel and project support payment process"]
[]
["Payment Procedure steps 1 - 7"]
[]
[1,"Only candidates who have successfully completed Protocol (PhD and MPhil only) and have obtained Ethics Approval (if necessary- MRes Year 2, PhD and MPhil candidates) are eligible to access faculty funding."]
[]
[2,"No less than 20 days before date of research activity submit candidature budget approved by supervisor to the AD RTP (via the Liaison Coordinator, melissa.hubbard@mq.edu.au)"]
[null,"If you have previously submitted your budget but it has changed since, provide an updated version, approved by your supervisor copy to the AD RTP (via the Liaison Coordinator)"]
[null,"To find out how much funding is left in your budget, send an email to the Liaison Coordinator"]
[null,"Candidates who are travelling should familiarise themselves with the ",null,null,null,null,null,null,"Travel Policy"]
[]
[3,"The faculty HDR office obtains the signature of the ADRTP"]
[]
[]
["Conference travel - accessible by PhD and MPhil applicants only"]
[null,"•","URL of conference website for conference home page and Registration page "]
["·         Paper acceptance or letter of acceptance from conference organiser and/or track chair (email confirmation is acceptable)","•","Email or letter of acceptance from conference organisers"]
["·         Booking Confirmation of air/land travel from STA (MQ University branch or Campus Travel)","•","Quotes from CTM Travel tool (if travel required)"]
["·         Travel plan (signed by candidate and supervisor)","•","Follow appropriate Travel approvals (if applicable)"]
[]
["Workshop/Training Funding:"]
[null,"•","Workshop home page and Registration page "]
[null,null,"email or letter of acceptance from workshop organiser if applicable"]
[null,"•","Quotes from CTM Travel tool (if travel required)"]
[null,"•","Follow appropriate Travel approvals (if applicable)"]
[]
["Fieldwork:"]
[null,"•","Formal quotes/invoices for research assistance, informant gifts, transcription services "]
[null,"•","Quotes from CTM Travel tool (if travel required)"]
[null,"•","Follow appropriate Travel approvals (if applicable)"]
[]
["Databases / Software"]
[null,"•","Email formal quote from the supplier"]
[]
[4,"Once the supporting documentation and completed forms have been received, direct payment of the following will be organised:"]
[null,"•","airfare, accomodation"]
[null,"•","conference registration, "]
[null,"•","software and databases. "]
[]
[5," Candidates may obtain a Per-Diem as per university travel policy, to do so, please make sure all relevant documents are submitted 2-3 weeks prior to the departure date."]
[null,null,"The candidate is required to keep all receipts necessary to obtain a reimbursement. MQBS policy is to fund accommodation for conference dates plus one "]
[null,null,"additional night for international travel. "]
[]
[6,"Upon return, the candidate will submit a completed Claim Form together with original receipts and the Banking Authority Form"]
[]
[7,"Reimbursement/travel claim forms are supplied"]

{"sheet":"Variables","index":2,"n_rows":38,"n_cols":3,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
[]
["Year"]
[2007,null,1]
[2008,null,2]
[2009,null,3]
[2010,null,4]
[2011,null,5]
[2012,null,6]
[2013,null,7]
[2014,null,8]
[2015,null,9]
[2016,null,10]
[2017,null,11]
[2018,null,12]
[2019,null,13]
[2020,null,14]
[2021,null,15]
[2022,null,16]
[2023,null,17]
[2024,null,18]
[2025,null,19]
[2026,null,20]
[2027,null,21]
[2028,null,22]
[2029,null,23]
[2030,null,0]
[2031]
[2032]
[2033]
[2034]
[2035]
[2036]
[2037]
[2038]
[2039]
[2040]
[2041]
[2042]

{"sheet":"Travel Plan Template","index":3,"n_rows":51,"n_cols":8,"rows_kept":51,"cut":false,"hidden":true,"merged":[]}
["√",null,null,"HDR Student Travel Plan (Template)",null,"Serial No.: "]
[]
[]
["Purpose of Travel: (Short paragraph of description; attach memo if needed.)"]
["√"," Research"]
["√"," Conference"]
["Provide details of supervisory arrangements while you are away"]
["Cotutelle student",null,"yes / no  (circle one)"]
[]
["Department:",{"$f":"Dept","v":0}]
["HDR Student Name  ",{"$f":"FirstName","v":0}]
["ID Number:",{"$f":"'Candidature Budget'!D9","v":0}]
["Ethics Approval required for the Project?",null,null,"yes / no  (circle one)"]
["If yes please provide number",null,null,"#"]
[]
[]
["Source of Funding/Account Name: ",null,null,"HDR Support"]
["Account Number(s): ",null,null,13420001]
[]
[]
["Cost estimation for the trip:"]
[null,"- Conference registration",null,0]
[null,"- Airfare",null,0]
[null,"- Accommodation",null,0]
[null,"- Meals",null,0]
[null,"- Other (Please specify.)",null,0]
["Total:",null,null,{"$f":"SUM(D22:D26)","v":0}]
[]
[]
[]
["Date","Day","Time (AM/PM)","Details of Activity (Location eg xxx Uni; Purpose eg research interview; Collaborator; etc.)"]
[]
["dd/mm/yy"]
["dd/mm/yy"]
["dd/mm/yy"]
["dd/mm/yy"]
["dd/mm/yy"]
["dd/mm/yy"]
["dd/mm/yy"]
["dd/mm/yy"]
[]
[null,"√","I confirm the following: "]
[null,null,"Funding applied for has been approved and is available. "]
[null,null,"Airline Booking Approval Form and Booking Confirmation are attached. "]
[null,null,"Information provided as above is true and correct. "]
[]
[]
[null,"x",null,null,"x",null,null,"x"]
["Applicant (print name):",null,null,"Supervisor ",null,null,null,"FBE HDR Manager"]
["Date:",null,null,"Date:"]
[null,"Applicant signature",null,null,"Supervisor Signature",null,null,"FBE HDR Administor to obtain signature"]

{"sheet":"maximum approved funding","index":4,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Candidate Approved Funding Levels"]
[null,"Maximum Funding"]
["PhD","up to $10,000 ","up to $1,200 Copy Editing","up to $200 Thesis Production"]
["MRes","up to $1,000 ","up to $800 Copy Editing","up to $200 Thesis Production"]
["MPhil","up to $5,000 ","up to $1,200 Copy Editing","up to $200 Thesis Production"]

{"sheet":"Seminar Attendance","index":5,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Seminar Attendance Log"]
["Attending seminars is an essential part of your HDR candidature and seeking approval for HDR Funding."]
["Please list your seminar attendance below.  "]
["The list should be kept up-to-date and include seminars from the start of your candidature until thesis submission (ie duration is 3 years full-time equivalent)."]
[]
["Date","Topic ","Attendance (in person or online) - include zoom link","Seminar Notes"]

{"sheet":"Natural codes","index":6,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":true,"merged":[[28,2,28,3],[29,2,29,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[21,2,21,3],[16,1,16,5],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3]]}
[]
[]
[null,"Account No.",13420001]
[]
[null,"Natural Account","Account name",null,"Natural Account","Account name"]
[null,3003,"Copy editing, transcription, survey",null,2418,"HDR Student Development, workshop or training"]
[null,4354,"Printing, Thesis printing",null,4454,"Research participants"]
[null,4400,"Library materials",null,4720,"Journal Submission fees"]
[null,4001,"Telephones / Fax / Telex",null,4352,"Binding"]
[null,4002,"Postage",null,4350,"Stationery/Newspaper"]
[null,4056,"Bank charges - credit cards",null,4718,"Minor Equipment Purchases"]
[null,4353,"Photocopy services",null,5001,"Computer software/licences"]
[null,4355,"Copy charges",null,4604,"Gifts (incl flowers)"]
[null,5027,"Purchase of books (non library)",null,4601,"Freight & courier"]
[]
[]
[null,"Student – Travel Account Codes"]
[null,"Code","Category",null,"Used For","Examples of Suppliers"]
[null,5160,"Airfare",null,"All airfare expenses, visa expenses","Qantas"]
[null,5160,"Booking Fee",null,"All CTM booking fee expenses","CTM Travel"]
[null,5161,"Accommodation",null,"All accommodation","Hilton Hotel"]
[null,5162,"Meals",null,"All food & beverage expenses","McDonalds"]
[null,null,"Transport"]
[null,5163,"Parking Fees",null,"All parking fee expenses","Wilson Parking"]
[null,5164,"Public ",null,"All public transport expenses","Trains & Buses"]
[null,5164,"Taxi",null,"All taxi expenses","Taxis Combined, Uber"]
[null,5165,"Car Rental",null,"All car rental expenses","Avis, Hertz, Budget"]
[null,5166,"Conference",null,"All conference registration","IEAA Conference Registration Fee"]
[null,5110,"International Per Diem"]
[null,5111,"Domestic Per Diem"]

{"sheet":"Travel Diary","index":7,"n_rows":72,"n_cols":11,"rows_kept":72,"cut":false,"hidden":true,"merged":[[4,2,4,10],[1,0,1,10],[2,2,2,7],[2,9,2,10],[3,2,3,4],[3,9,3,10],[10,8,10,9],[11,8,11,9],[71,0,71,10],[5,0,5,2],[5,3,5,7],[5,9,5,10],[6,1,6,10],[8,8,8,9],[9,8,9,9]]}
[]
["TRAVEL DIARY"]
["Student name :",null,{"$f":"FirstName","v":0},null,null,null,null,null,"Student ID :",{"$f":"StudentNo","v":0}]
["Cost Centre :",null,"MQBS HDR Funding",null,null,"Trip Start Date:",null,null,"Trip Finish Date:"]
["Reason for trip :"]
["Candidate's signature *",null,null,null,null,null,null,null,"Date:","    /        /    "]
[null,"*In signing this document I acknowledge that this is a legal document that will be used by the Macquarie University to calculate any Fringe Benefits Tax (FBT) liability arising from my trip AND I confirm that all the information declared by me in this document is true and correct. I have attached other relevant supporting documentation such as conference itineraries, travel reports, research summarys, etc."]
[]
[null,"Number of days spent in transit/unavoidable delays:",null,null,null,null,null,null,null,null,"(A)"]
[null,"Number of days where business activities were undertaken: ",null,null,null,null,null,null,null,null,"(B)"]
[null,"Private Component - Number of days",null,null,null,null,null,null,null,null,"(C)"]
[null,"Total number of days away: ",null,null,null,null,null,null,{"$f":"I9+I10+I11","v":0},null,"(A+B+C)"]
[]
["    Details of Business Activities undertaken:"]
[null,"Date of Activity","Location of Activity","Time \nStart","Time Finish","Duration (hours)",null,"Brief Details of Activity",null,"Expense incurred","Date of Entry"]
["Example","2012-07-01","Bourke","9am","5pm","8 hours",null,"Research / Field work for Research Sample",null,"AUD 90","2012-07-02"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[]
[]
[]
[null,"Date of Activity","Location of Activity","Time \nStart","Time Finish","Duration (hours)",null,"Brief Details of Activity",null,"Expense incurred","Date of Entry"]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[]
["If space is insufficient please add more lines."]

{"sheet":"Claim Form","index":8,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Please click on the below link and complete the form to your purpose, i.e. Reimbursement, Substantiation or Per Diem"]
[]
["Non Order Payment Form"]