𝐏𝐑𝐄𝐕𝐄𝐍𝐓𝐈𝐕𝐄 𝐌𝐀𝐈𝐍𝐓𝐄𝐍𝐀𝐍𝐂𝐄 𝐓𝐑𝐀𝐂𝐊𝐄𝐑 𝐢𝐧 𝐄𝐱𝐜𝐞𝐥 𝟐𝟎𝟐𝟒 | 𝐏𝐑𝐄𝐕𝐄𝐍𝐓𝐈𝐕𝐄 𝐌𝐀𝐈𝐍𝐓𝐄𝐍𝐀𝐍𝐂𝐄 | 𝐏𝐏𝐌 𝐓𝐫𝐚𝐜𝐤𝐞𝐫

𝐏𝐫𝐞𝐯𝐞𝐧𝐭𝐢𝐯𝐞 𝐌𝐚𝐢𝐧𝐭𝐞𝐧𝐚𝐧𝐜𝐞 𝐓𝐫𝐚𝐜𝐤𝐞𝐫 𝐢𝐧 𝐄𝐱𝐜𝐞𝐥 𝟐𝟎𝟐𝟒 | 𝐏𝐑𝐄𝐕𝐄𝐍𝐓𝐈𝐕𝐄 𝐌𝐀𝐈𝐍𝐓𝐄𝐍𝐀𝐍𝐂𝐄 | 𝐏𝐏𝐌 𝐓𝐫𝐚𝐜𝐤𝐞𝐫
A preventive maintenance tracker is a tool or system used to monitor and manage scheduled maintenance tasks and activities aimed at preventing equipment breakdowns, failures, or performance issues. It helps organisations keep track of routine maintenance activities for various assets, such as machinery, vehicles, or facilities, ensuring that maintenance is conducted on a regular basis according to predefined schedules.
In today's video we will how can we create fully dynamic PPM or Preventive Maintenance Tracker in Excel.
#excel #ppmtracker #preventivemaintenance #exceltutorial #exceltricks #exceltips #officemonk
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
📚 𝐏𝐥𝐞𝐚𝐬𝐞 𝐣𝐨𝐢𝐧 𝐭𝐡𝐞 𝐂𝐡𝐚𝐧𝐧𝐞𝐥 𝐌𝐞𝐦𝐛𝐞𝐫𝐬𝐡𝐢𝐩 𝐭𝐨 𝐃𝐨𝐰𝐧𝐥𝐨𝐚𝐝 𝐭𝐡𝐞 𝐅𝐢𝐥𝐞:
𝐉𝐨𝐢𝐧 𝐭𝐡𝐞 𝐜𝐡𝐚𝐧𝐧𝐞𝐥 𝐌𝐞𝐦𝐛𝐞𝐫𝐬𝐡𝐢𝐩 𝐟𝐫𝐨𝐦 𝐭𝐡𝐞 𝐥𝐢𝐧𝐤 𝐛𝐞𝐥𝐨𝐰:
/ @office-monk
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
📚 𝗙𝗶𝗹𝗲 𝗟𝗶𝗻𝗸: 🅾🅽🅻🆈 🅵🅾🆁 🅲🅷🅰🅽🅽🅴🅻 🅼🅴🅼🅱🅴🆁🆂
docs.google.co...
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Related Searches
ppm tracker in englis
preventive maintenance tracker
preventive maintenance
preventive maintenance schedule
preventive maintenance kya hota hai
preventive maintenance checklist
preventive maintenance of transformer
preventive maintenance of pc
preventive maintenance of motor
ppm tracker
ppm full form
ppm calculation
Intro Clip / Video Credit: Vecteezy
@Vecteezy

[@mkgeidam]

Thank you for the video @office Monk

[@Office-Monk]

Thanks a lot for loving the video 😊

[@Mnopqrstuvwxyz....]

Dear Sir, Is it compatible/applicable in Google sheet?? Kindly advice since the third sheet(Filtered list) is not worked in the Google sheet. 😢

[@Office-Monk]

The formula is working perfectly in Google Sheets. I checked. What issue are you facing?

[@thaiduongvu4074]

When I change from X to D (Done), that cell is no longer a formula cell. Therefore, if you have a device maintenance time of more than 1 year, there will be errors on the "Mark Status" and "Filtered List" sheets. For example, in January 2024, I have jobs marked D, then in January 2025, these marked cells are still D. If I edit the formula on the "Mark Status" sheet, this file will no longer have storage value. Can you edit it to make it complete? Thank you.

[@Office-Monk]

Thanks for the feedback but this format is made that way. I have clearly brifed in the video that after selecting D, formula will vanish, so it's not a mistake, it's done intentionally. Coming to second point: This format is for 1 year, means schedule will be done for 1 year. In your case you have scheduled the tasks in January 2024, so the tasks will be scheduled till December 2024. In case you are starting to Schedule in January 2025. You will have to start with new fresh sheet. So this format is Complete. In case you still think that the format is incomplete, you can suggest me some way in which formulas will not vanish after selecting D

[@thaiduongvu4074]

@@Office-Monk Thanks for answering my question. Honestly, I haven't figured out how to solve the above problem. But I have extended the maintenance job duration not to one year (365 days) but to more than two years (1000 days) in the "PM Scheduling" sheet, then the other two sheets will be used to store the maintenance jobs (provided the start time is not changed). Thanks again.

[@rajanmodi7]

THANKS

[@Office-Monk]

Thank you so much for loving the video and getting connected with the Channel

[@rajanmodi7]

Make some thing similar great content for OEE also on Google sheets

[@Office-Monk]

You can create the same format on Google sheets by using the same formulas. It will work

[@phillipojo]

Hi I joined your membership and i am unable to download this sheet.

[@Office-Monk]

Drop me a mail on [e-mail]

[@yahyaabdalluh9683]

I also joined your membership please help me to send me this sheet i send you by email. Thanks

[@Office-Monk]

@yahyaabdalluh9683 I am not able to see you in my Channel Membership list. Below is the link to join the Channel Membership kzbin.info/door/Bz4_fNn1dN4IiS3KWleoKQjoin

[@irisaoctavia5146]

Hi, i already joined your membership.. please help me to send this sheet

[@Office-Monk]

Hi, have you downloaded the file ? if not, please drop a mail on [e-mail]

[@arifhossain490]

i found an error in your function . i don’t know was that for any reason or not . while typing the function for "x" formula the "weekday" formula is showing twice in your steps. while we do it theres one command in formula is missing . i will be pleased if you clarify this

[@Office-Monk]

Will have to check your format before I say anything. Please mail me the format, will check and let you know My mail id is [e-mail]

[@imie7619]

Hello, I want to download your sheet for work, how can I do the next step?

[@Office-Monk]

PayPal and GPay link is in the description box. Please do the payment and drop me a mail on [e-mail] And I will share the Excel Sheet

[@deebanrajkrishnan4352]

can you please share for excel.

[@Office-Monk]

You can join the Channel Membership to get the excel file

[@salehkhan9142]

sir i want to download the sheet and already join the channel how can i download it

[@Office-Monk]

Thanks a lot for joining the Channel Membership Saleh. I have mailed you the Excel sheet of PPM Tracker

[@msvintage9236]

Hello , how do i purchase this please

[@Office-Monk]

kzbin.info/door/Bz4_fNn1dN4IiS3KWleoKQjoin Click on the link and you will be diverted to join the Channel Membership. In Channel Membership Levels, you will get a level of PPM Tracker Download. Join that level and drop me mail on [e-mail] I will share the Excel file

[@Office-Monk]

Are you still looking for this format ?

[@ashu4aryan]

Sir, I downloaded the file from the link, it is not working. Plz help me

[@Office-Monk]

By what mail id you have requested the access?

[@ashu4aryan]

ask.ashu10

[@ashu4aryan]

Gmail

[@gurupanchal123]

Sir how to convert this formula in wps spreadsheet??

[@Office-Monk]

I never used Wps so really don't have any idea

[@gurupanchal123]

Oky Sir thanks for response, Now my ms excel formula is working in WPS sheet, with help of chatgpt thank you so much sir.

[@Office-Monk]

That's great. You used the same formulas or Chatgpt had done some changes ?

[@gurupanchal123]

@@Office-Monk only month format has change

[@Office-Monk]

Great

[@gnanasekaranp2976]

i have join your membership how that i open the sheet in edit version

[@Office-Monk]

Hi Gnanasekaran, I have mailed you the format. Please check your mail and drop a comment if you received

[@gnanasekaranp2976]

@@Office-Monk thanks for sharing

[@Office-Monk]

@gnanasekaranp2976 thank you so much for joining the Channel Membership

[@yahyaabdalluh9683]

How to get membership?

[@yahyaabdalluh9683]

Can you send me sheet please help me

[@timvankessel3246]

can you email the file please? i cant download it. Export mode is off

[@Office-Monk]

Please join the channel membership from the link provided in the description box to download the file. Thanks.

[@mortezarezvani7171]

How to download this Excel ❤

[@Office-Monk]

Link of the file is in description box. You can download it from there

[@Mnopqrstuvwxyz....]

​@@Office-Monk I tried but can't log in the link.

[@ashu4aryan]

Hello sir

[@Office-Monk]

Hello

[@allelingtv]

how to download i already subscribed to your channel

[@Office-Monk]

Download or edit access is only for Channel Members. If you have subscribed the Channel but still haven't joined the Membership, please join the Membership and drop me a mail on [e-mail] I will share the Excel Sheet

[@allelingtv]

i already sent an email sir

[@Office-Monk]

Can't see you in my Channel Membership list. Below is the link to join the Channel Membership kzbin.info/door/Bz4_fNn1dN4IiS3KWleoKQjoin

[@EngineeringHead-zg1ux]

i try to follow but the code in chat gpt is not working can you help me

[@Office-Monk]

=IFERROR(IF($E7="","",IF($D7="","",IF($D7="Daily",IF(F$4>=$E7,"X",""), IF($D7="Weekly",IF($E7

[@EngineeringHead-zg1ux]

@@Office-Monk THANKYOU BIG HELP IN MY MONITORING MORE POWER GODBLESS

[@Office-Monk]

I can understand. To create this format, it took me more than 12 hours.

[@Mnopqrstuvwxyz....]

​@@Office-Monk Highly appreciate your efforts. ❤

[@Office-Monk]

@@Mnopqrstuvwxyz.... Thank you so much for loving the video 😊

[@electricalknowledge2649]

Hi sir can I talk with you

[@Office-Monk]

Sure, tell me

[@carlosesquivel158]

Hello sir, thank you for the video, I sent you an email, could you help me please?

[@Office-Monk]

Hi Carlos, I got your email. Will be back with you soon. Thanks for joining the Channel Membership

[@sahilchoudhary3571]

Hiii i joined your membership unable to download sheet . Please send on email Thansk

[@Office-Monk]

I shared the format on mail. Please check

[@qurankareem-009]

Hi sir can u snd me this format in my g mail

[@Office-Monk]

Please join the Channel Membership and I will share the Excel Sheet. Please check the Membership Levels before joining