Project Management Knowledge Base

Go Back   Project Management Knowledge Base > Project Management Knowledge Base > Templates / Files

LinkBack Thread Tools Display Modes
Old 07-09-2009, 09:09 AM
Forum Newbie
Join Date: Dec 2007
Posts: 14
MODIL - Meeting Overview, Decision and Issue Log

Hi all,
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 …
Attached Files
File Type: zip (304.0 KB, 77 views)
File Type: zip (191.2 KB, 57 views)
Reply With Quote
Old 07-23-2009, 03:46 AM
Forum Newbie
Join Date: Dec 2007
Posts: 14
Exclamation 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 date:2009-07-22
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!!!

Reply With Quote
Old 08-10-2009, 09:45 AM
Forum Newbie
Join Date: Aug 2009
Posts: 1
Trouble Opening Compressed File

Hello izento,
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.
Reply With Quote
Old 08-11-2009, 02:13 AM
Forum Newbie
Join Date: Dec 2007
Posts: 14
Exclamation Trouble Opening Compressed MODIL File

Hi paperboy,
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:
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.

Reply With Quote
Old 06-30-2010, 02:09 PM
Forum Newbie
Join Date: Dec 2007
Posts: 14
MODIL tool latest version

Please find attached the latest (debugged) version V0.96a.
I hope decompression will now work correctly.

Attached Files
File Type: zip (257.7 KB, 45 views)
Reply With Quote
Old 01-10-2011, 08:57 AM
Forum Newbie
Join Date: Nov 2010
Posts: 1
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?

Thank you,

Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

All times are GMT -5. The time now is 11:05 AM.

Powered by: vBulletin - Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO ©2009, Crawlability, Inc.
Copyright (c) 2005 Measuring Up. All rights reserved.