{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Tips","Monitor","Completed","Lists"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"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":"Tips","index":0,"n_rows":16,"n_cols":1,"rows_kept":16,"cut":false,"hidden":false,"merged":[[7,0,7,8],[3,0,3,8],[1,0,1,8],[6,0,6,8],[8,0,8,8],[2,0,2,8],[5,0,5,8],[4,0,4,8],[15,0,15,8],[14,0,14,8],[13,0,13,8],[11,0,11,8],[9,0,9,8],[10,0,10,8],[12,0,12,8]]}
[]
["Watch the two videos on this page for some more background: https://researchmasterminds.com/life-and-academia/postgraduate-students-progress"]
[]
["Save the original document somewhere in a safe place. Rename the document you are going to work on so that you can go back to the original in case something goes wrong. Feel free to customise it as you wish. "]
[]
["Once you open the Excel file, you may see an message at the top of the sheet that says \"SECURITY WARNING Macros have been disabled\". Click \"Enable content\" to make sure the button on the \"Monitor\" sheet will work."]
[]
["There are four sheets in this Excel file: Tips, Monitor, Completed, Lists"]
[]
["Go to the Lists sheet first. Modify the categories to fit your needs. If you want to add more categories than what is there, you'll need some knowledge on how to use the \"data validation\" function in Excel. This video can help: https://youtu.be/02SuFj-hijU"]
[]
["The Monitor sheet is where you will add your current postgraduate students' information. This template has a built-in macro, a button that you can click which moves a student from the \"Monitor\" sheet to the \"Completed\" sheet. Click on the name of the student you want to move to the \"completed\" sheet and then click the button that says \"Move to Completed\". "]
[]
["The Completed sheet will show the students who have graduated, the ones you moved to the completed sheet by clicking the \"Move to completed\" button on the Monitor sheet."]
[]
["A big thank you to Dirk Naude for helping me to take my basic excel spreadsheet to the next level. "]

{"sheet":"Monitor","index":1,"n_rows":69,"n_cols":17,"rows_kept":69,"cut":false,"hidden":false,"merged":[[4,7,4,11],[2,1,2,4],[3,1,3,4],[4,1,4,4],[2,7,2,11],[3,7,3,11],[14,1,14,11],[70,1,71,16],[6,1,6,4],[6,6,6,10],[6,12,6,15],[10,1,10,5],[10,7,10,10],[10,12,10,15]]}
[null,"Postgrad Student Progress Monitor"]
[null,"Summary"]
[null,"Total number of projects under supervision",null,null,null,{"$f":"COUNTA($B$20:$B$68)","v":0},null,"Number of papers published (completed-student output)",null,null,null,null,{"$f":"SUM(Completed!$L$15:$L$63)","v":0}]
[null,"Total number of projects supervised to completion",null,null,null,{"$f":"COUNTA(Completed!$B$15:$B$63)","v":0},null,"Number of papers published (under-supervision output)",null,null,null,null,{"$f":"SUM($L$20:$L$68)","v":0}]
[null,"Total number of projects supervised/under supervision",null,null,null,{"$f":"SUM($F$3:$F$4)","v":0},null,"Total number of papers published from student output",null,null,null,null,{"$f":"SUM($M$3:$M$4)","v":0}]
[]
[null,"Students per degree",null,null,null,null,"Input required ",null,null,null,null,null,"My supervisor role"]
[null,"Phd","MSc diss","MSc res rep","Other",null,"With student","Action required from me","With other supervisor","Awaiting processes","Not applicable",null,"Prmiary supervisor","Second supervisor","Third supervisor","Other"]
[null,{"$f":"COUNTIF($E$20:$E$68,\"=PhD\")","v":0},{"$f":"COUNTIF($E$20:$E$68,\"=MSc diss\")","v":0},{"$f":"COUNTIF($E$20:$E$68,\"=MSc res rep\")","v":0},{"$f":"COUNTIF($E$20:$E$68,\"=other\")","v":0},null,{"$f":"COUNTIF($O$20:$O$68,\"=With student\")","v":0},{"$f":"COUNTIF($O$20:$O$68,\"=Action required from me\")","v":0},{"$f":"COUNTIF($O$20:$O$68,\"=With other supervisor\")","v":0},{"$f":"COUNTIF($O$20:$O$68,\"=Awaiting processes\")","v":0},{"$f":"COUNTIF($O$20:$O$68,\"=Not applicable\")","v":0},null,{"$f":"COUNTIF($H$20:$H$68,\"primary supervisor\")","v":0},{"$f":"COUNTIF($H$20:$H$68,\"second supervisor\")","v":0},{"$f":"COUNTIF($H$20:$H$68,\"third supervisor\")","v":0},{"$f":"COUNTIF($H$20:$H$68,\"other\")","v":0}]
[]
[null,"Projects per area",null,null,null,null,null,"Study design",null,null,null,null,"Methods"]
[null,"Cricket","Sport","General NMS","Education","Other",null,"Cross-sectional","Longitudinal","Systematic review","Other",null,"Motion analysis","Systematic review","Motion an and syst rev","Other"]
[null,{"$f":"COUNTIF($I$20:$I$68,\"=Cricket\")","v":0},{"$f":"COUNTIF($I$20:$I$68,\"=Sport\")","v":0},{"$f":"COUNTIF($I$20:$I$68,\"=General NMS\")","v":0},{"$f":"COUNTIF($I$20:$I$68,\"=Education\")","v":0},{"$f":"COUNTIF($I$20:$I$68,\"=Other\")","v":0},null,{"$f":"COUNTIF($J$20:$J$68,\"=Cross-sectional\")","v":0},{"$f":"COUNTIF($J$20:$J$68,\"=Longitudinal\")","v":0},{"$f":"COUNTIF($J$20:$J$68,\"=Systematic review\")","v":0},{"$f":"COUNTIF($J$20:$J$68,\"=Other\")","v":0},null,{"$f":"COUNTIF($K$20:$K$68,\"=Motion analysis\")","v":0},{"$f":"COUNTIF($K$20:$K$68,\"=Systematic Review\")","v":0},{"$f":"COUNTIF($K$20:$K$68,\"=Motion an and syst rev\")","v":0},{"$f":"COUNTIF($K$20:$K$68,\"=Other\")","v":0}]
[]
[null,"Projects per milestone/phase"]
[null,"Dept presentation","Assessors hand-in","Ethics hand-in","Assessors meeting","Data collection","Data analysis","Write up","Submission for examination","Corrections and final submission","Awaiting graduation","Degree awarded"]
[null,{"$f":"COUNTIF($N$20:$N$68,\"=Dept presentation\")","v":0},{"$f":"COUNTIF($N$20:$N$68,\"=Assessors hand-in\")","v":0},{"$f":"COUNTIF($N$20:$N$68,\"=Ethics hand-in\")","v":0},{"$f":"COUNTIF($N$20:$N$68,\"=Assessors meeting\")","v":0},{"$f":"COUNTIF($N$20:$N$68,\"=Data collection\")","v":0},{"$f":"COUNTIF($N$20:$N$68,\"=Data analysis\")","v":0},{"$f":"COUNTIF($N$20:$N$68,\"=Write up\")","v":0},{"$f":"COUNTIF($N$20:$N$68,\"=Submission for examination\")","v":0},{"$f":"COUNTIF($N$20:$N$68,\"=Corrections and final submission\")","v":0},{"$f":"COUNTIF($N$20:$N$68,\"=Awaiting graduation\")","v":0},{"$f":"Completed!$F$3","v":0}]
[]
[null,"Name of student","Student number","Date of first registration","Degree","Project title","Names of other supervisors","My supervisor role","Area","Study design","Methods","Nr of papers published","Next deadline/ leave blank if graduated","Next milestone/ phase","Input required","Number of hours still to complete","Final submission/ degree awarded"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[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]

{"sheet":"Completed","index":2,"n_rows":25,"n_cols":19,"rows_kept":25,"cut":false,"hidden":false,"merged":[[4,1,4,4],[4,6,4,10],[4,12,4,15],[8,1,8,5],[8,7,8,10],[8,12,8,15]]}
[null,"Completed Postgrad Student Projects"]
[null,"Summary"]
[null,"Total number of students supervised to completion",null,null,null,{"$f":"COUNTIF($N$14:$N$62,\"degree awarded\")","v":0}]
[]
[null,"Students per degree",null,null,null,null,"Input required ",null,null,null,null,null,"My supervisor role"]
[null,"Phd","MSc diss","MSc res rep","Other",null,"With student","Action required from me","With other supervisor","Awaiting processes","Not applicable",null,"Prmiary supervisor","Second supervisor","Third supervisor","Other"]
[null,{"$f":"COUNTIF($E$15:$E$63,\"=PhD\")","v":0},{"$f":"COUNTIF($E$15:$E$63,\"=MSc diss\")","v":0},{"$f":"COUNTIF($E$15:$E$63,\"=MSc res rep\")","v":0},{"$f":"COUNTIF($E$15:$E$63,\"=other\")","v":0},null,{"$f":"COUNTIF($O$15:$O$63,\"=With student\")","v":0},{"$f":"COUNTIF($O$15:$O$63,\"=Action required from me\")","v":0},{"$f":"COUNTIF($O$15:$O$63,\"=With other supervisor\")","v":0},{"$f":"COUNTIF($O$15:$O$63,\"=Awaiting processes\")","v":0},{"$f":"COUNTIF($O$15:$O$63,\"=Not applicable\")","v":0},null,{"$f":"COUNTIF($H$15:$H$63,\"primary supervisor\")","v":0},{"$f":"COUNTIF($H$15:$H$63,\"second supervisor\")","v":0},{"$f":"COUNTIF($H$15:$H$63,\"third supervisor\")","v":0},{"$f":"COUNTIF($H$15:$H$63,\"other\")","v":0}]
[]
[null,"Projects per area",null,null,null,null,null,"Study design",null,null,null,null,"Methods"]
[null,"Cricket","Sport","General NMS","Education","Other",null,"Cross-sectional","Longitudinal","Systematic review","Other",null,"Motion analysis","Systematic review","Motion an and syst rev","Other"]
[null,{"$f":"COUNTIF($I$15:$I$63,\"=Cricket\")","v":0},{"$f":"COUNTIF($I$15:$I$63,\"=Sport\")","v":0},{"$f":"COUNTIF($I$15:$I$63,\"=General NMS\")","v":0},{"$f":"COUNTIF($I$15:$I$63,\"=Education\")","v":0},{"$f":"COUNTIF($I$15:$I$63,\"=Other\")","v":0},null,{"$f":"COUNTIF($J$15:$J$63,\"=Cross-sectional\")","v":0},{"$f":"COUNTIF($J$15:$J$63,\"=Longitudinal\")","v":0},{"$f":"COUNTIF($J$15:$J$63,\"=Systematic review\")","v":0},{"$f":"COUNTIF($J$15:$J$63,\"=Other\")","v":0},null,{"$f":"COUNTIF($K$15:$K$63,\"=Motion analysis\")","v":0},{"$f":"COUNTIF($K$15:$K$63,\"=Systematic Review\")","v":0},{"$f":"COUNTIF($K$15:$K$63,\"=Motion an and syst rev\")","v":0},{"$f":"COUNTIF($K$15:$K$63,\"=Other\")","v":0}]
[]
[]
[null,"Name of student","Student number","Date of first registration","Degree","Project title","Names of other supervisors","My supervisor role","Area","Study design","Methods","Nr of papers published","Next deadline/ leave blank if graduated","Next milestone/ phase","Input required","Number of hours still to complete","Final submission/degree awarded date","Outcome of examination"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,73]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"not stated"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70]

{"sheet":"Lists","index":3,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Degree","My supervisor role","Area ","Methods","Study design","Number of publications anticipated","Next milestone/phase","Input required","Outcomes "]
[null,"PhD","Primary supervisor","Cricket","Motion analysis","Cross-sectional",0,"Dept presentation","With student","Pass with minor corrections"]
[null,"MSc diss","Second supervisor","Sport","Systematic review","Longitudinal",1,"Assessors hand-in","Action required from me","Pass with major corrections"]
[null,"MSc res rep","Third supervisor","General NMS","Motion an and syst rev","Systematic review",2,"Ethics hand-in","With other supervisor","Pass with distinction"]
[null,"Other","Other","Education","Other","Other",3,"Assessors meeting","Awaiting processes","Resubmission"]
[null,null,null,"Other",null,null,4,"Data collection","Not applicable"]
[null,null,null,null,null,null,">4","Data analysis"]
[null,null,null,null,null,null,null,"Write up"]
[null,null,null,null,null,null,null,"Submission for examination"]
[null,null,null,null,null,null,null,"Corrections and final submission"]
[null,null,null,null,null,null,null,"Awaiting graduation"]
[null,null,null,null,null,null,null,"Degree awarded"]