Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Template for Planned Preventive Maintenance Program? Anyone?
Preventive maintenance is a schedule of planned maintenance actions aimed at
the prevention of breakdowns and failures. The primary goal of preventive maintenance is to prevent the failure of equipment before it actually occurs. HELP ANYONE???! Many thanks, Rui Gomes |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Template for Planned Preventive Maintenance Program? Anyone?
Use autonomous maintenance for shop floor level and TPM for general machines.
If want want something in excel use a conditional format, which will read the date for an activity and then colour in a certain cell whatever colour u want. Look under format and u'll find it. Along the top put dates/months/days whatever u want, down the side your machine sub sections/activities. In the formula for your conditional format you put something like =AND(Q$2=$B8;Q$2<$B8+$D8;$C8=100). This is easy and saves you having to colour the cells yourself every time. If u need more colours then u'll need a VB code. "Rui Gomes" wrote: Preventive maintenance is a schedule of planned maintenance actions aimed at the prevention of breakdowns and failures. The primary goal of preventive maintenance is to prevent the failure of equipment before it actually occurs. HELP ANYONE???! Many thanks, Rui Gomes |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating a list of maintenance records for my car(s) Template ? | Excel Discussion (Misc queries) | |||
What is planned to replace VBA? | Excel Programming | |||
The program associated with the selected template - excel 07 | Excel Discussion (Misc queries) | |||
excel template for housing maintenance records | Excel Discussion (Misc queries) | |||
Template Wizard Addin Program | Excel Discussion (Misc queries) |