Here is a tool that will help solving simple optimization problems with the ‘Evolution Algorithm’. I highly recommend to show the solution graphically to enhance the user friendliness.
Download: EvolutionSolver.xlsm
Here is a tool that will help solving simple optimization problems with the ‘Evolution Algorithm’. I highly recommend to show the solution graphically to enhance the user friendliness.
Download: EvolutionSolver.xlsm
There are many time management tricks and tools, but I did not find a unique technique suit everyone. Each Manager has to finds his own way of managing his own time to increase his performance. There are no recipes that fits all.
Here I share with you a calendar form that I am using since more than 10 years to manage my own time. I print it 3 to 5 weeks ahead and use it to note my ‘to Dos’. I also use Excel, SharePoint List and Outlook to track Task in my projects vpqkuow. But for my own time, I am still working with pen and paper.
Download: WeekPlan.xlsm
A big project has its own SharePoint site to enhance communication between stakeholders. The PMO of the project maintains it. SharePoint is a great tool; However, the maintenance of the user access is very difficult if you have more than 50 users/stakeholders.
This is the reason I have created the following tool to maintain the users on a SharePoint site. It really saves time and gives a much better oversight than the Web Interface. The file itself contains help.
Download: sharepointmaintaingrouptool_v1-8
Written commitment is a key factor to ensure the success of a project. A commitment is an agreement and should be signed by involved stakeholders. However, It only works if the process is fast and lean. This is the reason I have developed the E-Signature for Office document.
Download Link
Word: Workpackage Approval Form.xlsm
Excel: Project Charter.docm
The form can be modified to become ‘risk assessment’, ‘scope change proposal’ or any other project interface document.
Patrick Sawyer
12.11.2016
The file enclosed are very useful to generate simple Gantt chart in Excel.
Downloads:
Daily Gantt: project-gantt-excel-generator-daily.xlsm
Weekly Gantt (very nice calendar): project-gantt-excel-generator-weekly.xlsm