Preventive Maintenance Spreadsheet in Excel

M

Michela78

#1
Hi all,

In our company we do not have the access program, but I would need to create a preventive maintenance plan in excel (I do not Like paper :bonk:). Is there a model for starting, possibly free?

Thanks a lot, Michela
 
Elsmar Forum Sponsor

Coury Ferguson

Moderator here to help
Staff member
Super Moderator
#2
T

Tyler C

#3
Re: Maintanance spreadsheet excel

If you do some research, you'll find there are multiple types of maintenance programs such as, preventive maintenance, predictive maintenance, and conditions based maintenance.

I guess it depends on what type of equipment the maintenance program will be created around. You may stick to one, or you may utilize all three.

Identify your equipment, triggers, responsibilities, tasks, frequency, etc. Create a log with all of this information, and make a "results" or "completed" section to record the maintenance that was done. Use historical data you have collected if necessary to get the answers to some of these questions.

You can just use a regular spreadsheet with manual data entry, but this can pose some problems. For example, who will be using this spreadsheet? Are they competent enough with excel to use the spreadsheet efficiently? Are you going to be asked to analyze the data for someone every day? Is the data properly protected? Protected from human error in data entry, or tampering (unintentional or otherwise)?

These are some problems I have faced with some of our excel spreadsheets. I have gotten to the point that I write macros to automate data analysis so all anyone has to do is push a button, and they get the info they need, compiled nicely into a PDF, and saved for their use. I've also started creating input forms with drop down lists, references, and several other types of data validation to prevent human error in data entry. So far, it has worked very well.
 
Thread starter Similar threads Forum Replies Date
S Are there ISO9001:2015 Requirements for Preventive Maintenance? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 36
D Preventive Maintenance Implementation 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 5
M Minitab tool to evaluate PM (Preventive Maintenance) process Using Minitab Software 6
E Manufacturer Responsibility (vs. User/Customer) for Preventive Maintenance/Repair 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 4
A Assessing a Preventive Maintenance Strategy - Reliability or Maintenance Statistics Reliability Analysis - Predictions, Testing and Standards 2
S How to determine Preventive Maintenance and Calibration Grace Periods General Measurement Device and Calibration Topics 4
R A GRP model that also considers the Preventive Maintenance Efficiency Reliability Analysis - Predictions, Testing and Standards 3
M Tracking Preventive Maintenance Effectively Nonconformance and Corrective Action 5
R Preventive Maintenance Checks Advice Manufacturing and Related Processes 4
M TS 16949 Clause 7.5.1.4 Preventive and Predictive Maintenance - Requirements Scope IATF 16949 - Automotive Quality Systems Standard 3
M Preventive Maintenance & Operating Procedures for Measurement Equipment Inspection, Prints (Drawings), Testing, Sampling and Related Topics 20
S Which ISO/AS Clause directly relates to Preventive Maintenance of Equipment? AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 3
T Preventive Tool Maintenance - Preventive and Predictive Maintenance requirements Manufacturing and Related Processes 7
R Free Preventive Maintenance Software Manufacturing and Related Processes 3
S NC Lathe Preventive Maintenance Boiler Plate checklist Reliability Analysis - Predictions, Testing and Standards 3
E Meeting AS9100 Clause 6.3 Infrastructure Requirements - Preventive Maintenance AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 6
S Does overdue preventive maintenance require an evaluation on product quality? ISO 13485:2016 - Medical Device Quality Management Systems 5
C Benchmarking Preventive Maintenance Sales Benchmarking 0
Q ISO 9001 Clause 6.3 Infrastructure - Preventive Maintenance Requirements ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 24
M Preventive Maintenance Scheduling Software recommendations Lean in Manufacturing and Service Industries 8
L Any ideas for Preventive Maintenance checklist? Quality Manager and Management Related Issues 5
D How to interpret TS Clause 7.5.1.4 Preventive and Predictive Maintenance? IATF 16949 - Automotive Quality Systems Standard 8
R Who runs your Preventive Maintenance Program? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 45
G Preventive Maintenance for Assembly Line Bar-Code & General Printers - Necessary? IATF 16949 - Automotive Quality Systems Standard 4
M Definition Predictive Maintenance vs Preventive Maintenance - Definitions Definitions, Acronyms, Abbreviations and Interpretations Listed Alphabetically 3
D Definition Preventive Maintenance vs. Predictive Maintenance - Distinction between Definitions, Acronyms, Abbreviations and Interpretations Listed Alphabetically 20
Crusader Preventive Maintenance - Electronic Records Deleted/Erased OR Are Records Required? Records and Data - Quality, Legal and Other Evidence 62
I Preventive Action Examples, Excluding Preventive Maintenance, Wanted ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 10
K Calibration - Not willing to spend money in calibration/preventive maintenance ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 17
B Preventive Maintenance Program in a non-production facility Misc. Quality Assurance and Business Systems Related Topics 4
S Looking for Equipment Specific Preventive Maintenance templates/Procedures/forms Document Control Systems, Procedures, Forms and Templates 8
G Preventive Maintenance Requirements - ISO 9001 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 70
H Preventive Maintenance - Does anyone have a sample of a PM procedure? Document Control Systems, Procedures, Forms and Templates 5
Marc Definition Preventive Maintenance - Definition Definitions, Acronyms, Abbreviations and Interpretations Listed Alphabetically 0
Randy Preventive and Corrective Maintenance - Looking for a basic procedure Document Control Systems, Procedures, Forms and Templates 19
S Definition Predictive vs. Preventive Maintenance - TS 16949 Clause 7.5.1 - Definitions of Definitions, Acronyms, Abbreviations and Interpretations Listed Alphabetically 32
N 3% of the scheduled preventive maintenance (PMs) cancelled - You make the call! Preventive Action and Continuous Improvement 11
A Preventive maintenance outsourcing - What type of controls? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
R Definition Preventive vs. Predictive Maintenance - What is the difference? TS 16949 - 7.5.1.4. Definitions, Acronyms, Abbreviations and Interpretations Listed Alphabetically 11
F Preventive and Predictive Maintenance - Benchmarking Partner Benchmarking 6
V Can an Ionizer be calibrated or perform preventive maintenance when in use? General Measurement Device and Calibration Topics 6
V Does preventive maintenance have any positive effect on smart transmitters? General Measurement Device and Calibration Topics 1
Marc Preventive Maintenance - Suppliers & Delivery Vehicles ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
D Preventive Maintenance Interpretation - Clause 4.9.g.1 QS-9000 - American Automotive Manufacturers Standard 5
F QS-9000 Clause 4.9.g.1 - Preventive Maintenance - Tool Wear Predictive Maintenance QS-9000 - American Automotive Manufacturers Standard 1
Marc Preventive Maintenance & Machine Manual Control QS-9000 - American Automotive Manufacturers Standard 0
M Preventive and Predictive Maintenance - Information on procedures relating to 4.9.g.1 QS-9000 - American Automotive Manufacturers Standard 16
C If it doesn't prevent a non-conformance, is it a preventive action? IATF 16949 - Automotive Quality Systems Standard 13
R Evaluating the need for preventive action Preventive Action and Continuous Improvement 3
GURU SDI Rust preventive oil mixed with kerosene Problem Solving, Root Cause Fault and Failure Analysis 2

Similar threads

Top Bottom