Dear All,

I am Sharing a Interactive Quality Management Dashboard, Useful for Quality Managers and Engineers to keep track on their Quality Objectives.

Quality Management Dashboard will help you on;

Tracking NCR's as per Location, Activity and Person who is incharge for it.
Tracking the Quality of work
Cost of Rework
Standard Operating Procedures Record.
Inspection Report Record.
Quality Training Record.
Best Practices Implemented and Learning.
Major NCR's and much more.

Dashboard is made in excel sheet

Main page view.
View attachment 16
You can track the things easily
with month and year picker at top.

NCR
View attachment 17
NCR can be track as per location by selecting it from drop down.
View attachment 18
Further you can track it by person name and area of his work.
View attachment 19

We have a area which shows a product quality rating.
View attachment 20
By clicking on blue button you can track overall rating so far.
View attachment 21

and their are many more features. Just download it and explore.

It will help you in great ways in your day to day tracking and recording quality objectives of your work.

Its complete solution for a Quality Manager / Engineer to succeed in his work in smart way.

If you have any query related to how to use it and do customization you can post here.

All formulas are stored in sheet called data, you can change the automatic selection data from their like

Location name
Incharges Name
If you want to change name of activities you can.

and other customization you can do directly on each sheet like
changing name of company,
name of project
company logo and anything you want.

Quality Dashboard do not contain any password nor we charge for its use.
Use it for your personal works, do not copy and paste it other places without my consent.


Feel free to reply for your queries.
Thanks for sharing useful data

R.M.Chandanshive
AEE (CIDCO)
 
Dear All,

I am Sharing a Interactive Quality Management Dashboard, Useful for Quality Managers and Engineers to keep track on their Quality Objectives.

Quality Management Dashboard will help you on;

Tracking NCR's as per Location, Activity and Person who is incharge for it.
Tracking the Quality of work
Cost of Rework
Standard Operating Procedures Record.
Inspection Report Record.
Quality Training Record.
Best Practices Implemented and Learning.
Major NCR's and much more.

Dashboard is made in excel sheet

Main page view.
View attachment 16
You can track the things easily
with month and year picker at top.

NCR
View attachment 17
NCR can be track as per location by selecting it from drop down.
View attachment 18
Further you can track it by person name and area of his work.
View attachment 19

We have a area which shows a product quality rating.
View attachment 20
By clicking on blue button you can track overall rating so far.
View attachment 21

and their are many more features. Just download it and explore.

It will help you in great ways in your day to day tracking and recording quality objectives of your work.

Its complete solution for a Quality Manager / Engineer to succeed in his work in smart way.

If you have any query related to how to use it and do customization you can post here.

All formulas are stored in sheet called data, you can change the automatic selection data from their like

Location name
Incharges Name
If you want to change name of activities you can.

and other customization you can do directly on each sheet like
changing name of company,
name of project
company logo and anything you want.

Quality Dashboard do not contain any password nor we charge for its use.
Use it for your personal works, do not copy and paste it other places without my consent.


Feel free to reply for your queries.
Thank you so much!!! But how we can shift to 2020? Only 2017, 2018 and 2019
 

Dhruv z

Newbie
hello sir,
first of all thank you that you made this file and shared with us.
i understood everything except the standard procedure part.

can you explain how i can use sop part??
 

Dnyan Deshmukh

Staff member
hello sir,
first of all thank you that you made this file and shared with us.
i understood everything except the standard procedure part.

can you explain how i can use sop part??
In SOP area or sheet, below details are recorded.

SOP need to be created for each and every construction activity such as reinforcement, formwork, concrete etc.

in first column you need to list all activities which are involve in your project.

Then you need to take dates of proposed start of each activity from a planning schedule. (this helps you in doing quality planning)
Then you need to record the actual start of activity in the table.
Normally before starting the actual work the mock-up / training is done on site, for regular activity a training program is done and for specialised activities Mock up is done. it is important to record those date.

Base on the knowledge of activity and known system of companies operation, one can prepare the SOP or in absence on knowledge the done Mock up process and Standard codes will help in formulation of SOP.

Formed SOP then need to be submitted to Project Manager for review and approval, As the Project manager is most responsible person in Project, Agreement by him on the same reflects the whole team executing the work at site need to follow the same.

Once the Project Manager agrees to it, then same should be issued to all engineers at site. if you are working in contractors company, then after taking approval from Project Manager, you should also take approval from client or just submit your SOP for taking acceptance from them.

The date of approval and date of issued for execution should be recorded in this sheet.

The SOP number is a unique number give for identification of SOP and should be printed on each page in small size to keep easy identification, normally SOP number along with revision number is printed on document on each page at top right corner.

Revision number helps in keeping track of how many revisions did happen and what changed, it helps you in discarding old records from site, spreading awareness about changes in SOP during meeting and training programs.

more the revisions indicates more efforts need to be taken to ensure everything in SOP is clearly understood and followed at site.
 
  • Like
Reactions: Dhruv z
Dear All,

I am Sharing a Interactive Quality Management Dashboard, Useful for Quality Managers and Engineers to keep track on their Quality Objectives.

Quality Management Dashboard will help you on;

Tracking NCR's as per Location, Activity and Person who is incharge for it.
Tracking the Quality of work
Cost of Rework
Standard Operating Procedures Record.
Inspection Report Record.
Quality Training Record.
Best Practices Implemented and Learning.
Major NCR's and much more.

Dashboard is made in excel sheet

Main page view.
View attachment 16
You can track the things easily
with month and year picker at top.

NCR
View attachment 17
NCR can be track as per location by selecting it from drop down.
View attachment 18
Further you can track it by person name and area of his work.
View attachment 19

We have a area which shows a product quality rating.
View attachment 20
By clicking on blue button you can track overall rating so far.
View attachment 21

and their are many more features. Just download it and explore.

It will help you in great ways in your day to day tracking and recording quality objectives of your work.

Its complete solution for a Quality Manager / Engineer to succeed in his work in smart way.

If you have any query related to how to use it and do customization you can post here.

All formulas are stored in sheet called data, you can change the automatic selection data from their like

Location name
Incharges Name
If you want to change name of activities you can.

and other customization you can do directly on each sheet like
changing name of company,
name of project
company logo and anything you want.

Quality Dashboard do not contain any password nor we charge for its use.
Use it for your personal works, do not copy and paste it other places without my consent.


Feel free to reply for your queries.
Thank you very much i will try it
 
Great effort and it is ever useful and memorable one those who really make use of it.
Thanks for sharing such unique and innovative mechanism for tracking the concern and their closure.
 
  • Like
Reactions: Dnyan Deshmukh
Dear All,

I am Sharing a Interactive Quality Management Dashboard, Useful for Quality Managers and Engineers to keep track on their Quality Objectives.

Quality Management Dashboard will help you on;

Tracking NCR's as per Location, Activity and Person who is incharge for it.
Tracking the Quality of work
Cost of Rework
Standard Operating Procedures Record.
Inspection Report Record.
Quality Training Record.
Best Practices Implemented and Learning.
Major NCR's and much more.

Dashboard is made in excel sheet

Main page view.
View attachment 16
You can track the things easily
with month and year picker at top.

NCR
View attachment 17
NCR can be track as per location by selecting it from drop down.
View attachment 18
Further you can track it by person name and area of his work.
View attachment 19

We have a area which shows a product quality rating.
View attachment 20
By clicking on blue button you can track overall rating so far.
View attachment 21

and their are many more features. Just download it and explore.

It will help you in great ways in your day to day tracking and recording quality objectives of your work.

Its complete solution for a Quality Manager / Engineer to succeed in his work in smart way.

If you have any query related to how to use it and do customization you can post here.

All formulas are stored in sheet called data, you can change the automatic selection data from their like

Location name
Incharges Name
If you want to change name of activities you can.

and other customization you can do directly on each sheet like
changing name of company,
name of project
company logo and anything you want.

Quality Dashboard do not contain any password nor we charge for its use.
Use it for your personal works, do not copy and paste it other places without my consent.


Feel free to reply for your queries.
Sir gr8 file
 
Dear All,

I am Sharing a Interactive Quality Management Dashboard, Useful for Quality Managers and Engineers to keep track on their Quality Objectives.

Quality Management Dashboard will help you on;

Tracking NCR's as per Location, Activity and Person who is incharge for it.
Tracking the Quality of work
Cost of Rework
Standard Operating Procedures Record.
Inspection Report Record.
Quality Training Record.
Best Practices Implemented and Learning.
Major NCR's and much more.

Dashboard is made in excel sheet

Main page view.
View attachment 16
You can track the things easily
with month and year picker at top.

NCR
View attachment 17
NCR can be track as per location by selecting it from drop down.
View attachment 18
Further you can track it by person name and area of his work.
View attachment 19

We have a area which shows a product quality rating.
View attachment 20
By clicking on blue button you can track overall rating so far.
View attachment 21

and their are many more features. Just download it and explore.

It will help you in great ways in your day to day tracking and recording quality objectives of your work.

Its complete solution for a Quality Manager / Engineer to succeed in his work in smart way.

If you have any query related to how to use it and do customization you can post here.

All formulas are stored in sheet called data, you can change the automatic selection data from their like

Location name
Incharges Name
If you want to change name of activities you can.

and other customization you can do directly on each sheet like
changing name of company,
name of project
company logo and anything you want.

Quality Dashboard do not contain any password nor we charge for its use.
Use it for your personal works, do not copy and paste it other places without my consent.


Feel free to reply for your queries.
Dear Mr Dnyan
The aforesaid details and respective dash board format is highly helpful, besides I could make a presentation in line with this as if the requirements. I am expressing my gratitude herewith to share your knowledge and tools in order to help our community in this manner. Whereas can you help me either by sharing your ideas or any excel MIS format like what you have shared already cater to exhibit interactive comprehensive project status pertaining to cover up all schedules and financial matters / status.
 

Dnyan Deshmukh

Staff member
Dear Mr Dnyan
The aforesaid details and respective dash board format is highly helpful, besides I could make a presentation in line with this as if the requirements. I am expressing my gratitude herewith to share your knowledge and tools in order to help our community in this manner. Whereas can you help me either by sharing your ideas or any excel MIS format like what you have shared already cater to exhibit interactive comprehensive project status pertaining to cover up all schedules and financial matters / status.
Yes you can prepare presentation on how to use dashboard and share with others for better understanding of how to use it. Unfortunately i do not have any dashboard for tracking execution works but will try to prepare the same in near future.