Google Sheet PM Scheduling with Dashboard

In this video Google Sheet Preventive maintenance scheduling explained. This template is very useful for maintenance dept.as maintenance PM activity planned automatically accordingly the selection of frequency. You can also track Pending & completed task status

Key features

• Preventive Maintenance scheduling has made easy by this sheet with minimum data entry.
• Task gets Planned automatically after selection of Frequency (Daily, Weekly, Monthly, Fortnightly, Every Two Month, Quarterly, Every Six Month, Yearly & custom days set)
• You can quickly filter the task between the span of two dates within 31 days.
• You can save this filtered Task in Separate sheet.
• In saved task sheet you will have facility to mark task as done & dynamic change will be observed showing Pending & Completed Task Status.
• Weekly off & holidays dates replaced by working days automatically in saved task sheet
• Graphical data gets auto generated. On the Top of Dashboard, Overall Task Status appeared. Bar chart can be filtered by Year, Month, Date, Category, & Machine No.

Simple & Professional

• No Smart office Templates Logo.
• No Monthly Fees.
• One template with Simple data.

Other information

• Built for Google Sheet only.
• Private use only (not for distribution or resale)

Contact us

Mail : mofficetemplates@gmail.com

For any assistance chat with us on what's app link : https://wa.me/message/XR6PCMZNOF6AL1

Like Fb Page : https://www.facebook.com/sachinpawar.2022