Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 386
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
creating a list of maintenance records for my car(s) Template ? Jeff Excel Discussion (Misc queries) 4 August 29th 08 05:01 AM
What is planned to replace VBA? XP Excel Programming 8 January 29th 08 03:58 AM
The program associated with the selected template - excel 07 Kim K Excel Discussion (Misc queries) 0 March 7th 07 03:55 PM
excel template for housing maintenance records Herbgrinder Excel Discussion (Misc queries) 1 June 8th 06 08:30 AM
Template Wizard Addin Program millemj Excel Discussion (Misc queries) 7 December 11th 04 08:32 PM


All times are GMT +1. The time now is 04:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"