Welcome to Techno-PM

Swapnil Wale founded Techno-PM in 2014 in Sydney, Australia. Techno-PM started as a blog but in a short while has grown into a full-fledged company. Techno-PM is now a registered Australian business entity with ABN: 6361 5935 469 with a team of expert project managers and web design team. Techno-PM offers a variety of template packages and downloads. All the templates we provide come with a detailed user guide and designed by experts.
  • Mitigate project risks

    • Manage your risks, issues, dependencies and assumptions easily using our RAID logs to keep your projects on track.

What our customers say about us

Swapnil is a lifesaver. He came in and took a project management template I had envisioned in my mind and within less than 24 hours turned it into a beautiful template.

– Amy Parvaneh - CEO & Founder of Select Advisors.

The project management templates on Techno-PM are excellent for all kinds of projects. The capacity planning and project trackers are of great help to keep projects on track.

– Prabhu Patil - CEO & President PROLIM Corporation.

Our project management templates are
used by project managers in


Coming soon test


Coming soon
Share:

PayPal Button

https://techno-pm-digital-downloads.myshopify.com/cart/6989169164336:1?channel=buy_button
Share:

Project Quality Management Plan Template

Project Quality Management

Quality management might sound like the fluffy side of project management but, trust me, it is not. In fact, with so many cases in the news of phones exploding while charging or trains which ended up being too wide to fit existing platforms, just to mention a few examples, one can easily appreciate the real importance of proper quality management in projects!

Why RE-CREATE when you can RE-USE?

Project Management Templates

$29

  • Project management with excel.
  • Manage stakeholder expectations.
  • Plan your projects with confidence.
  • Use your project resources efficiently.
  • Mitigate project risks.
  • Agile - 20 templates
  • Heat maps - 4 templates
  • Incident Management- 7 templates
  • Meetings - 12 templates
  • PMO - 10 templates
  • Project Budget - 4 templates
  • Project Closure - 4 templates
  • Project Dashboards - 9 templates
  • Project Initiation – 30 templates
  • Project Plans – 22 templates
  • Project Risk and Change Management - 10 templates
  • Project Status Report – 24 templates
  • Project Timelines and Road maps - 10 templates
  • RAAID - 20 templates
  • Resource and Capacity Planning - 21 templates
  • Task Management - 13 templates

FAQ

YES, our store is powered by Shopify which is one of the most trusted e-commerce platforms. Shopify is certified Level 1 PCI DSS compliant. All Shopify stores include an SSL certificate that uses industry standard 256-bit encryption technology. This is the same level of encryption used by large banks to keep your information secure.

All our products are ONE TIME PAYMENT. We do not offer subscriptions so whatever you pay will be be one time.

Sometimes links can be blocked by a corporate firewall so please try using the link from a different network or from home. If you still cannot access drop an email to support@techno-pm.com and use our Contact Us Page.

We accept PayPal, Apple Pay, Google Pay, Master Card , Amex and VISA.

Yes, we do when the templates don't work or you cannot download. Please check our Refund Policy.

Yes, the templates are built MS Office so will work on Excel.


We will REFUND the full amount in the following scenarios -

  1. Templates don't work as described.
  2. Templates are missing from your download and we cannot provide you the same templates shown on the site.
  3. You are not able to access the download. We will try to provide different mediums but if none of them work for you then we will refund your amount.

quality management plan template
Project Quality Management Plan Sample
The tricky aspect of quality is that, just as value, it tends to lie in the eyes of the beholder, that is, it is subjective and very often difficult to measure. However, this is not to say that it should be neglected or fast-tracked when planning and executing a project. Quite the opposite. It is because of the different interpretations of quality that it should be addressed carefully and documented as explicitly as possible by the project manager in the project’s Quality Management Plan.

What is a quality management plan QMP?

The Quality Management Plan is a comprehensive document which details how quality is going to be covered by and in the project, including the acceptance criteria for the project’s deliverables. It determines quality policies and procedures relevant to the project for both project deliverables and project processes, defines who is responsible for what, and documents compliance and tailoring required to fit the characteristics of the project. It is also in this document, that the approach for quality planning, quality assurance, and quality control are defined.

A Quality Management Plan will typically contain:

  • Quality Planning
  • Definition of Project Quality
  • Project Quality Measurement
  • Assessments, Reviews & Audits
  • Project Quality Improvement
  • Quality Monitoring and Control
  • Corrective Actions
  • Quality Schedule
  • Quality Management Roles and Responsibilities
  • Quality Management Processes
  • Quality Management Standards & Procedures
  • Quality Management Methods, Tools & Techniques

Quality Planning

This section identifies which quality standards are relevant to the project and how they will be satisfied by the project. It also lists the quality metrics that will be used, including the acceptance criteria for project deliverables and product performance.

Definition of Project Quality

To make quality a construct as objective as possible, this section identifies quality standards and expectations for customers, the project, and the organization, ensuring that the customer and project success criteria are clear to all involved.

Project Quality Measurement

Describes how quality will be determined and measured, including desired metrics and related monitoring processes to measure quality standards. Additionally, explains how data for measurements is going to be collected as well as the time frame for measurement and metrics reporting.

Assessments, Reviews & Audits

Identifies the product reviews, process audits, and other assessments that will be conducted during the project’s life cycle to ensure quality objectives and standards are met. It should be clearly defined how these reviews are triggered, to what frequency they should be performed, and who is expected to be involved.

Project Quality Improvement

Based on quality data obtained, this section documents opportunities for improvement to eliminate gaps between current and desired levels of performance regarding quality management.

Quality Monitoring and Control

as important as to plan quality, is to monitor it and identify the controlling actions that will be conducted to re mediate quality gaps throughout the project’s life.

Corrective Actions

Following from the previous point, the project management team should define the process and procedures by which anomalies and problems will be recorded, tracked, resolved, and reported. Likewise, the process for identification, communication and implementations of corrective actions should be documented here.

Quality Schedule

Provides a schedule of quality reviews and other quality activities planned for the project, which should be appropriately integrated into the overall Project Schedule.

Quality Management Roles and Responsibilities

Defines the primary roles and responsibilities of the project team regarding quality management. These activities can include mentoring or coaching, auditing work products, auditing processes, participating in project reviews, among others.

Quality Management Processes

Provides a summary of how the project quality will be managed, including changes to the baseline. This step is often presented as a workflow diagram.
quality management processes
Quality Management Processes


Quality Management Standards & Procedures

Should there be any organizational quality standards and procedures, these should be mentioned here, including any tailoring applied to suit the project.

Quality Management Methods, Tools & Techniques

Should there be any particular methods, tools and techniques that are recommended or mandatory for this project, this is the place to list them.

The Quality Management Plan is part of the planning phase of the project and should not be completed in isolation. Remember that quality is often subjective, hence, the earlier you can involve the project stakeholders in this exercise, capture their perception of quality, and translate it into quality acceptance criteria, the better chances of success you have!

As William Foster very well said “Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives.” The same applies to projects – the quality of the project depends on you.
Share:

Team Task List Template

Team Task List Template


Share:

Excel Traffic Light Using Conditional Formatting - Free Download

What is Excel Traffic Light?

The global standard for a traffic light is that red means stop, and green means go. Due to this, the inherent conditioning is that red is bad, green is good, and orange is somewhere in between. Red usually denotes that there is a problem in the information which is presented, green that it is on track, and orange that it is at risk. These colors are used in many reports, Excel allows these colors to be used in its reports, in order to help the viewers focus on the problematic (red) areas. We can do these excel traffic light using Conditional Formatting in excel, which allows the user to customize the parameters for the colors.

Download all our templates
Excel Traffic Light, Excel Traffic Light using Conditional Formatting
Excel Traffic Light using Conditional Formatting

How to Create Excel Traffic Light?

In order to use the traffic lights in an Excel table, the following steps are required – 

Step 1 : Insert Values into Excel Table

Insert the numbers into the Excel table, along with all the other relevant information. For example: the number of truck sales in 2016 by the sales people of a car dealership. Column A includes the names of the sales people, and column B the numbers of trucks they sold in 2016  – 

Excel Table for Traffic lights in Excel
Excel Table for Traffic lights in Excel


Step 2 : Conditional Formatting in Excel

Choose the numbers in column B (without the header), and click on “Home -> Conditional Formatting -> Icon Sets” and then choose the traffic lights icons – 

Conditional Formatting Excel for Traffic Light
Conditional Formatting Excel for Traffic Light

Step 3 : Traffic Lights in Excel

Once this is completed, the default traffic lights will appear next to the numbers in column B. The default parameters for the traffic lights are –
  • The top 33% of the numbers (67% and up) have the Green traffic light next to them.
  • The middle 34% of the numbers (less than 67% but more than 33) have the Yellow light next to them.
  • The bottom 33% of the numbers have the Red light next to them.
Default Traffic Lights in Excel,Default Excel Traffic Light
Default Excel Traffic Light

Customizing the Traffic Lights in Excel

Choose all the numbers in column B (without the header), and click on “Home -> Conditional Formatting -> Manage Rules”. The following menu will appear – 

Excel Conditional Formatting for Traffic Light
Conditional Formatting Excel Traffic Light 

Setting Up the Rules for Conditional Formatting

Click on the “Icon Set” so that it is colored in blue as in the picture above, and then click on the “Edit Rule” button. The following menu will appear –

Conditional Formatting Excel Traffic Light
Conditional Formatting Excel Rules 
In the top half of the menu (“Select a Rule Type”) leave the default as is (“Format all cells based on their values”). In the bottom half of the menu the following customization can be made – 
  1. The “Format Style” mustn’t change from the default “Icon Sets”, otherwise the traffic lights will disappear.
  2. Clicking on the “Reverse Icon Order” button will cause the red light to appear at the top row, and the green one at the bottom. If the rest of the parameters stay the same, then the top third numbers will be red, and the bottom third green (no change to the yellow numbers).
  3. The “Icon Style” drop-down menu allows the user to change the appearance of the lights. There are many icons to choose from.
  4. Ticking the “Show Icon Only” box will cause the numbers to disappear from column B, and only the traffic lights will appear in the column.
Project Management Templates, Project Management Templates Sale

Setting up the Parameters in Traffic Lights

Changing the parameters of the traffic lights requires in the bottom section of the menu, under “Display each icon according to these rules” – 
  1. Each Icon can be changed by choosing one from the drop down menu
    In the greater than or equal to drop down menu it is possible to choose whether either “>=” or only “>”.
  2. In the “Value” field the parameter for which the first icon will appear can be chosen.
  3. In the “Type” drop down menu there are 4 possible parameters to choose from –
    Number:
    An absolute number.
    Percent:
    The top X% of all of the numbers in the column.
    Formula:
    This requires writing a formula, and the numbers which meet the requirements of the formula will have a traffic light next to them.
    Percentile:
    Only the numbers which will be included in  the percentile chosen will have a traffic light next to them.
  4. For example: if the first icon is a green traffic light (the default) and the following parameters are chosen: “>=”, the value field is “200” and the type is “Number” then all of the numbers in column B which are 200 or above will have the green traffic light next to them.

Parameters in Excel Traffic Light
Parameters in Excel Traffic Light

Best Practices for Creating Excel Traffic Light

Best Practice to Create Excel Traffic Light,How to Create Excel Traffic light?
Best Practice to Create Excel Traffic Light
  • If only one table appears in the spreadsheet, and the parameters apply to all of it, it is recommended to choose “This Worksheet” in the drop-down menu (after clicking on “Home -> Conditional Formatting -> Manage Rules”. This will ensure that all of the values in the table will adhere to the same parameters.
  • Try and limit the number of icon sets to one per spreadsheet.
  • The lights are dynamic, so changing the numbers in the column may cause the traffic light to change automatically.


Share:

PMO Kick Off Meeting Template

Project Kick Off

You have defined the strategy and objectives of your Project Management Office (PMO). You have assembled a team to implement it. You even wrote a PMO Charter. You are ready to go and start changing the complex and dynamic universe of projects in your organization. You have plenty of work to do, would love start issuing nice monthly portfolio dashboards right away and seeing stuff happen in your PMO. You can feel the smell of change in the air. This is a serious moment, the PMO is ready to kick-off.


Project kickoff meeting template, PMO Kick Off Meeting Template
PMO Kick Off Meeting Template
Running a PMO kick-off meeting might sound like a light and fluffy thing to do, however it a powerful way to get people’s attention to the PMO and ensure that expectations are aligned regarding what the PMO is, why it is needed, and how it is going to work. It is critical not to neglect it or rush it.
In fact, several reports claim that many PMOs fail in achieving their objectives due to lack of sponsorship and there are still many cases of abandoned PMOs because of poor engagement with their user community. So, although you might be in a hurry to show your PMO-love, get it off to a good start first with a PMO kick-off meeting. It is a fantastic opportunity for the PMO management team to start building relationships with project teams and other stakeholders. After all, no one destroys what one helps to build, right?

What is for PMO kick off meeting?

Implementing a PMO is no easy-peasy work. Yet, with a quick but effective PMO kick-off meeting you can leverage a range of benefits to support the PMO implementation: 
  • Get everyone on the same page:
    present the PMO. No misunderstandings, no “I-have-no-idea-what-this-PMO-thing-is” anymore. With a kick-meeting, attendees gain a clear view on the objectives, scope, and services provided by the PMO.
  • Gain sponsorship and commitment: it’s easier to gain sponsorship for the PMO’s work and commitment from the team when roles and responsibilities are explicit and visible to all.
  • Build momentum for work to start:
    when you walk out of the kick-off meeting, visibility of the PMO is at an all-time high. Make use of it to keep the ball running.
  • Get the PMO team energised on the work ahead: by bringing the team together and sharing the PMO vision and roadmap as a team, a PMO kick-off meeting enables the creation of a cohesive, successful, high-performing PMO team.

OK, I’m convinced but When should I do it?

As early as possible. Make no mistake: your first challenge will be to find a date (and likely a meeting room available) that works for everyone, so try to schedule the kick-off meeting while you are still working on your PMO Charter, allowing yourself enough time for preparation. The PMO Kick-off meeting marks the start of the PMO implementation project hence you will want to make it right and ensure as much attendance as possible.

Right, and Who to invite for PMO Kick off meeting?

This will much depend on your organizational structure, however, it is advisable to have at least the PMO Sponsor, the PMO team who is going to carry out the work, and representatives from the different user groups, such as Change Management, Resource Management, Finance, Project Managers, and other areas of the Business deemed relevant. In summary, anyone who can fit the role of “PMO’s client”.

What to cover in the PMO Kick Off Meeting Agenda?

A PMO implementation should be taken as seriously as any other project, meaning that the kick-off meeting requires preparation and a structured agenda. A great kick-off is always the result of great preparation. An example of an agenda is:
  1. Introductions and Setting the Scene: what is the context for the PMO implementation?
  2. PMO Vision and Objectives: what do we aim to achieve?
  3. PMO Benefits: why are we doing this?
  4. PMO Scope: what are we doing?
  5. PMO Roadmap: how are we going to make this happen?
  6. PMO Team Roles and Responsibilities: who is doing what?
  7. PMO Communication Plan: how are we going to communicate our progress?
  8. PMO Ground Rules: how are we going to work together?
  9. Next Steps: how do we keep momentum?

Some final Hints and Tips

  • Make it brief but exciting: no one likes long boring meetings. Try to keep the entire kick-off meeting as brief but impactful as possible. Usually, 1 to 2 hours is enough.
  • Focus on the big picture: establishing clarity and excitement among the PMO team and stakeholders is your mission for the kick-off. Don’t worry too much about the details at this stage, you’ll have plenty of time after the meeting, when the party starts.
  • Don’t be afraid to answer questions: allow sufficient time at the end of the meeting for participants to pose questions. It is important that people feel comfortable and are clear on what was presented during the meeting.
  • Summarize key points and finish with a smile: do a quick recap focusing on the important points and close the meeting in a positive and enthusiastic way. Give people a reason to talk about the PMO implementation even after they leave the meeting room.
Big journeys start with simple steps and by investing the necessary time in preparing the best PMO kick-off meeting ever, you can set a winning course and tone for the rest of the PMO implementation project. After all, the PMO kick-off meeting is much more than a ceremony, it’s your opportunity to shine and get everyone excited about the PMO, do not waste it!



Share:

one page - test

The One Page Project Manager Excel Template helps a project manager to manage projects with a single page.  The one page project manager covers the task tracking, maintain key dates, task meter, resource load, to do for the PMs, risk and issues tracking. The template has been designed to fit into one excel sheet and easy to print. Other important KPI have also been designed to be visible easily. 


One Page Project Manager Excel Template Free Download
One Page Project Manager Template

Features and Advantages of the One Page Project Manager Excel Template

  • Covers all the key project aspects in one page.
  • Allows capturing of key milestones/dates with a status indicator.
  • Has a task meter which shows how many tasks are on track, concerned or delayed.
  • Allows tracking of individual tasks and highlights delayed tasks.
  • Captures the resource work load for each resource.
  • Captures top 5 concerns which can be risks or issues.
  • Captures top 5 action items or change requests.
  • Has a notes and to do tracker which highlights tasks which have passed the due date.
  • Can handle a list of 20 pre-defined holidays. Holidays are reduced from the task duration.

Task Tracker Section

  • The task tracker allows up to 21 tasks.
  • Each task has a owner, start date, end date, actual completion, forecast completion and status.
  • All the columns marked in blue are auto populated so should not be changed.
  • The task tracker calculates the Forecast % complete based on task start date, end date and duration.
  • Based on the Actual and Forecast the status is populated. 
  • If the task is on track or ahead then the status is green. If the task is less than 5% behind then the task is marked amber. If the task is lagging behind for more than 5% then the status is marked red.
  • Always copy the previous task to create a new task. Update only the columns marked in yellow. On a day to day basis update the Actual % completion.


Milestones, Task Meter and Resource Workload View

  • Milestones and Key dates section allows tracking of key dates and milestones. Each date has a due date and status indicator which will indicate on track, concern and delayed.
  • The Task Meter displays shows the on track, concern and delayed. The graph gets the data from the task tracker status. 
  • The Resource Work Load displays the work allocated to each resource in days. The resource work load graph also gets the data from task tracker.
One Page Project Manager
Task Meter and Resource Work Load

Concerns, Actions and Change Requests Section

  • This section allows tracking of risks and issues within the Top 5 Concerns
  • Each concern has a owner and status which can be On Track, Concern or Delayed.
  • The Open Actions and Change Requests allows tracking of action items and change requests.
  • Each action item and change request has a owner and status which can be On Track, Concern or Delayed.
Concerns, Actions and Change Requests Section
Concerns, Actions and Change Requests Section

To Do and Notes List Section

  • The notes and to do list is specially designed for project managers to keep track of their own tasks.
  • Each task will have a description and due date.
  • The task will be highlighted in red if the task is overdue.
Notes and To Do Action
Notes & To Do List

One Page Project Manager Data Section

  • The data section can be used to set the resources. Populate only resource names. 
  • The workload column is auto calculated.
  • The public holidays can be used to set public holidays.


Share:

Status Reports

Popular Posts

Welcome to Techno-PM

Swapnil Wale founded Techno-PM in 2014 in Sydney, Australia.

Techno-PM started as a blog but in a short while has grown into a full-fledged company. Techno-PM is now a registered Australian business entity with ABN: 6361 5935 469 with a team of expert project managers and web design team.

Techno-PM offers a variety of template packages and downloads. All the templates we provide come with a detailed user guide and designed by experts.

Get In Touch

Name

Email *

Message *

Excel Project Dashboard

Excel Capacity Planner

Master Excel Project Tracker

Multiple Project Tracker Excel

Template Categories

One Page Project Manager

RAID Templates

Our Best Templates

Project Planners and Trackers

Labels

Unordered List

  • Lorem ipsum dolor sit amet, consectetuer adipiscing elit.
  • Aliquam tincidunt mauris eu risus.
  • Vestibulum auctor dapibus neque.

Pages

Theme Support

Need our help to upload or customize this blogger template? Contact me with details about the theme customization you need.