MODIL - Meeting Overview, Decision and Issue Log
attached is a MS-Excel tool (incl. VBA) to manage your (team) meetings and issues. I (and some colleagues) use it for a long time and want to give it to the world now.
It is FOSS now, but also still in a Beta state.
Testers and co-workers welcome!
Hint! Excel 97-2003. Do not work with Excel2007
You are managing a standard project as a Project Manager or Team Leader?
Then you will have to manage hundreds of team meetings, project reviews, board meetings, etc. and thousands of issues, decision and information during your project’s lifecycle. Managing this flood of information is a big problem.
And information is a basic matter of a successful project.
There are various tools to manage issues and contents. Numerous commercial issue tracking systems and content management systems are available on the market.
But what is about information collection and distribution?
In a project the information is collected and distributed via meetings and e-mail. In normal cases the:
- invitation and agenda is written in a document and distributed via e-mail
- upcoming information and is listed in a minutes of meeting and distributed via e-mail
- major issues from the meeting are brought to an issue tracking system
- invitations and minutes are stored in an version control system
All of this work is done manually! There is currently no tool on the market to manage this automatically!
The small issues, decisions and information from a meeting are hidden in various files of meeting minutes.
The base idea of the MODIL (Meeting Overview, Decision and Issue Log) tool is to collect all information of all meetings of a project in one single log, to generate selective information and to distribute the information via e-mail.
The MODIL tool is intended to make your work on meetings more efficient and to fill the gap between the meetings and the commercial issue tracking system and content management systems.
From this point of view the MODIL tool is a kind of content management and information distribution system!
The MODIL tool is not intended to replace any kind of issue tracking system. Despite this, it might be used for issue tracking on small projects or sub-projects, without the effort of a big issue tracking system.
And additionally the MODIL tool is a quality factor!
The MODIL tool leads inexperienced project managers or team leader to a consequent type of work. Setting up an agenda for every meeting, check of the status of attendees and log all information.
The MODIL tool gives an overview of all meetings and the attendees. With that, you can track the consistency of information flow in your project.
The MODIL tool logs also small issues, decisions and other information in one single file. This information can be escalated, tracked and easily reconstructed.
The MODIL tool logs and tracks the agendas of all meetings in one log. With that you have the overview, what was discussed when and how often.
The MODIL tool got positive appraisal by various process assessment models incl. SPICE, CMMi, PMBOK, OPM3, etc.
AND the MODIL tool is Project Management efficient!
Preset attendee roster multiple types of meetings, appointment by one button click.
Preset attendee roster and agenda for multiple types of meetings, invitation by one button click.
Automatic detection of issues, decision or information, meeting minutes by one button click.
Connected to MS-Outlook task planning, task delegation by one button click.
Optimized to track meetings online with connection to e-mail system, sending meeting minutes before leaving the meeting room.
And much more …
MODIL tool V0.96, two urgent bugs discovered
Sorry, as mentioned before the MODIL tool V0.96 is still in Beta phase.
Now two bugs are discovered, which lead to incapabilities of usage.
You can correct these bugs by your own, with help of the VBA Editor of MS-Excel (Alt+F11).
Issue Ref.: #0313
Issue date: 2009-07-07
Issue Description: VBA Error type mismatch in Functions_General.Fac_Number: Fac_ID=0
Corrective Action Plan: Replace
If Fac_ID = "" Or Fac_ID = 0 Then Exit Function
If Fac_ID = "" Then Exit Function '#313
Issue Ref.: #0316
Issue Description: Error message, if Minutes of Meeting for an afternoon meeting shall be sent the same day!
Module Actions, sub Action_create, var Mtg_DateTime is initialized as long and rounded up.
Corrective Action Plan: Define Module Actions.Action_create:
Dim Mtg_DateTime as Variant.
Again, sorry for the inconvenience!
Still waiting for co-authors and beta-testers!!!
Trouble Opening Compressed File
I am having difficulty opening the file in Excel 97-2003. Which version of winzip was used to compress the file? I am having trouble using winzip 8.1. Thanks.
Trouble Opening Compressed MODIL File
I used PowerArchiver 2004 with the 7-zip algorithm, but never heard about problems with that.
Winzip 8.1 seems to be a little antiquated (2002).
Please try original 7-zip: http://www.7-zip.org/download.html.
If problem persists, please send me a message at pmkb with your e-mail address, so I can sent you a different compressed one and update the download.
MODIL tool latest version
Please find attached the latest (debugged) version V0.96a.
I hope decompression will now work correctly.
Modil works with Lotus Notes
What do I have to do use Modil with Lotus Notes? Are there specific settings that I need to do?
Any plan to be able to use Modil with Microsoft Exchange?