Google Sheet PM Scheduling with Dashboard

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