Educational institutions are dominated by committees and meetings, with FE being worse than schools and HE worse than FE. It was during one such meeting at a University that had lots of people attending that I created a simple Excel Sheet similar to the one below to estimate how much the meeting cost in terms of staff time, and was quite horrified when I saw the counter moving forwards, and how much each second cost. I remember one occasion when my meeting calculator estimated that it cost about £400 to discuss and decide not to spend £150 on a license for some software to experiment with.
I have re-created the sheet, if anyone wants to estimate the cost of their meetings – this is produced in Excel and uses a simple macro (so macros will need to be enabled for it to work) and some functions in Excel. The sheet is locked – but with no password, so feel free to see how the sheet was constructed – it does show a few things that you can do with some functions.
Link to the meeting calculator resource
Meeting Cost Calculator by Dave Foord is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.