@Mr. Monk this is very nice , Im not a goo excel person. In old excel file not all formulas can be use . I just need a simple tracker sheet for my villa maintenance , every quarter and yearly 6 task to do. Is there any video support from you. appreciate . I tried the other video ppm tracker but seems the formula is error. Can you help me thanks
Is your consultation have charges for the tutorial and how much will it be , im having diffiiculty in record keeping . Your tutorials seems to fit in my work load that can ease my burden. appreciate your reply
You can create the format and put this formula for Daily, Quarterly and Yearly =IFERROR(IF($E7="","",IF($D7="","",IF($D7="Daily",IF(F$4>=$E7,"X",""), IF($D7="Quarterly",IF($E7
@@Office-Monk Hi , Thanks for the reply , I have tried to attached it on my sheet the formula provided , its showing false . Is there anyway you can assist me on my basic sheet. I have tried to share it as well to you in your email. 🙏🙏, if theres any consultation for it. please do let me know . really appreciate your expertise
@mamu092002 I will be back with you by Monday. Will revert on your mail. I checked the mail but was confused if it's your mail as the name was different
@yahyaabdalluh9683 I am not able to see you in my Channel Membership list. Below is the link to join the Channel Membership th-cam.com/channels/Bz4_fNn1dN4IiS3KWleoKQ.htmljoin
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
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.
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
@@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.
th-cam.com/channels/Bz4_fNn1dN4IiS3KWleoKQ.htmljoin 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 vijaymuukh@gmail.com I will share the Excel file
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 vijaymuukh@gmail.com I will share the Excel Sheet
![[MV] A leap of faith...ความเชื่อใจครั้งสุดท้าย (From "Petrichor the series")](http://i.ytimg.com/vi/U1piZH2CNXA/mqdefault.jpg)
Thank you for the video @office Monk
Thanks a lot for loving the video 😊
@Mr. Monk this is very nice , Im not a goo excel person. In old excel file not all formulas can be use . I just need a simple tracker sheet for my villa maintenance , every quarter and yearly 6 task to do. Is there any video support from you. appreciate . I tried the other video ppm tracker but seems the formula is error. Can you help me thanks
Is your consultation have charges for the tutorial and how much will it be , im having diffiiculty in record keeping . Your tutorials seems to fit in my work load that can ease my burden. appreciate your reply
You can create the format and put this formula for Daily, Quarterly and Yearly
=IFERROR(IF($E7="","",IF($D7="","",IF($D7="Daily",IF(F$4>=$E7,"X",""),
IF($D7="Quarterly",IF($E7
The other PPM Tracker on my Channel has the formula of Sequence and Sequence is available only in updated versions of Excel
@@Office-Monk Hi , Thanks for the reply , I have tried to attached it on my sheet the formula provided , its showing false . Is there anyway you can assist me on my basic sheet. I have tried to share it as well to you in your email. 🙏🙏, if theres any consultation for it. please do let me know . really appreciate your expertise
@mamu092002 I will be back with you by Monday. Will revert on your mail. I checked the mail but was confused if it's your mail as the name was different
Hi I joined your membership and i am unable to download this sheet.
Drop me a mail on vijaymuukh@gmail.com
I also joined your membership please help me to send me this sheet i send you by email. Thanks
@yahyaabdalluh9683 I am not able to see you in my Channel Membership list. Below is the link to join the Channel Membership
th-cam.com/channels/Bz4_fNn1dN4IiS3KWleoKQ.htmljoin
Hi, i already joined your membership.. please help me to send this sheet
Hi, have you downloaded the file ? if not, please drop a mail on vijaymuukh@gmail.com
Dear Sir,
Is it compatible/applicable in Google sheet?? Kindly advice since the third sheet(Filtered list) is not worked in the Google sheet. 😢
The formula is working perfectly in Google Sheets. I checked. What issue are you facing?
Hello, I want to download your sheet for work, how can I do the next step?
PayPal and GPay link is in the description box. Please do the payment and drop me a mail on vijaymuukh@gmail.com
And I will share the Excel Sheet
sir i want to download the sheet and already join the channel how can i download it
Thanks a lot for joining the Channel Membership Saleh. I have mailed you the Excel sheet of PPM Tracker
THANKS
Thank you so much for loving the video and getting connected with the Channel
Make some thing similar great content for OEE also on Google sheets
You can create the same format on Google sheets by using the same formulas. It will work
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
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 vijaymuukh@gmail.com
i have join your membership how that i open the sheet in edit version
Hi Gnanasekaran,
I have mailed you the format. Please check your mail and drop a comment if you received
@@Office-Monk thanks for sharing
@gnanasekaranp2976 thank you so much for joining the Channel Membership
How to get membership?
Can you send me sheet please help me
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.
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
@@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.
Hello , how do i purchase this please
th-cam.com/channels/Bz4_fNn1dN4IiS3KWleoKQ.htmljoin
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 vijaymuukh@gmail.com
I will share the Excel file
Are you still looking for this format ?
How do I get this file?
This is a paid format. So you do the Payment through PayPal or Gapay and drop me a mail. I will share the Excel Sheet
can you email the file please? i cant download it. Export mode is off
Please join the channel membership from the link provided in the description box to download the file. Thanks.
Sir, I downloaded the file from the link, it is not working. Plz help me
By what mail id you have requested the access?
ask.ashu10
Gmail
Sir how to convert this formula in wps spreadsheet??
I never used Wps so really don't have any idea
Oky Sir thanks for response,
Now my ms excel formula is working in WPS sheet, with help of chatgpt thank you so much sir.
That's great. You used the same formulas or Chatgpt had done some changes ?
@@Office-Monk only month format has change
Great
can you please share for excel.
You can join the Channel Membership to get the excel file
how to download i already subscribed to your channel
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 vijaymuukh@gmail.com
I will share the Excel Sheet
i already sent an email sir
Can't see you in my Channel Membership list. Below is the link to join the Channel Membership
th-cam.com/channels/Bz4_fNn1dN4IiS3KWleoKQ.htmljoin
Hello sir
Hello
How to download this Excel ❤
Link of the file is in description box. You can download it from there
@@Office-Monk I tried but can't log in the link.
Hi sir can I talk with you
Sure, tell me
i try to follow but the code in chat gpt is not working can you help me
=IFERROR(IF($E7="","",IF($D7="","",IF($D7="Daily",IF(F$4>=$E7,"X",""),
IF($D7="Weekly",IF($E7
@@Office-Monk THANKYOU BIG HELP IN MY MONITORING MORE POWER GODBLESS
I can understand. To create this format, it took me more than 12 hours.
@@Office-Monk Highly appreciate your efforts. ❤
@@Mnopqrstuvwxyz.... Thank you so much for loving the video 😊
Hello sir, thank you for the video, I sent you an email, could you help me please?
Hi Carlos,
I got your email. Will be back with you soon. Thanks for joining the Channel Membership
Hiii i joined your membership unable to download sheet .
Please send on email
Thansk
I shared the format on mail. Please check