What really surprised me was that it appeared that one had such a plan available online. I was staggered that there did not appear to be something already in the wild.
After a fairly intensive search, I found a few sources to help me compile a planning tool of my own. This included John Wittwer's gantt chart template, but, as his spreadsheet was locked, I didn't explore this much further. I considered some of his headings, but the sample I found online from an unknown author (see below) had also used much of the same functionality as John had.
The two sources which did work - after a fashion - were both spreadsheets, both set up as Gantt charts... but both woefully under-detailed. One was a downloadable creative commons sheet with an unknown author, containing perhaps two percent of the required amount of detail (Unknown, n.d.); the other was an online Gantt chart website with perhaps ten percent of the required detail (Toms Planner, n.d.).
What a great shortcut it would have been to have had a whole PhD research planning timeline list that I could have downloaded, then built on. But it was not to be.
So I sat down myself and planned the first cut of my whole darn project, task by task; with start dates and stop dates; scheduling in known breaks. It was quite a long list by the time that I got to 'enough' to start with.
I had a good look at both the online and downloadable spreadsheet versions, then decided to use the downloadable version, as the online version had a 100 line limitation. This was a good option, as my downloadable spreadsheet currently has 201 lines, and will, I am sure, expand.
I made quite a few modifications, such as using functions to work out min & max dates, functions to add the due dates, summing, auto filters, sub-groups and use of colour to delineate different task deadlines (I have put a key at the top). Unfortunately, I could only fit two years on one Gantt chart in Excel before the spreadsheet started crashing on me, but I think that is enough.
Because of the lack of resources, and in the spirit of the creative commons donation which I used a lot of, I have decided to share what I have created with others who are looking for such a beast (and you will find a note in the Comments box under Advanced properties, acknowledging my creative commons benefactor for the spreadsheet structure).
Sam
References:
- Unknown (n.d.). PHD research proposal gantt chart.xlsx. Retrieved 30 December 2015 from https://docs.google.com/spreadsheets/d/1cKETo0ysuSrInp0WRL90zlCdXTs32I0Ov2hJHyMpqDU/export?format=xlsx&id=1cKETo0ysuSrInp0WRL90zlCdXTs32I0Ov2hJHyMpqDU
- Toms Planner (2014). Research Project Plan. Retrieved 31 December 2015 from http://www.tomsplanner.com/template-example/research/
- Wittwer, John (n.d.). Gantt Chart Template for Excel. Retrieved 2 January 2016 from http://www.vertex42.com/Files/download2/excel.php?file=gantt-chart_L.xls
No comments :
Post a Comment
Thanks for your feedback. The elves will post it shortly.