Creating a maintenance plan is not a bureaucratic act, but the central instrument for ensuring plant safety, reducing downtime, and reliably documenting proof obligations. This guide provides a ready-to-use maintenance plan template, a step-by-step guide for data collection and prioritization, practical tips for integration into CAFM systems, as well as KPIs and a rollout checklist for direct implementation.
1. Define Goals, Scope, and Responsibilities
Clear goal setting is not a luxury, but a prerequisite: Without a defined goal for the maintenance plan, all planning remains tactical and reactive. Specifically determine whether the plan primarily serves operational safety, increased availability, compliance documentation, or cost control – combinations are often necessary, but priorities must be clear.
Sharpen the scope: Immediately define which buildings, technical areas, and plant groups are included. Too big at once leads to incomplete datasets in practice; too small overlooks critical interfaces. A pragmatic tactic: pilot with 1-2 critical asset classes, then successive rollout.
Practical Rule for Scope
- Prioritize by Risk: Start with safety-relevant and critical assets (i.e., defined as highly available or production-relevant).
- Select Location Granularity: Floor/Technical Room is usually sufficient; Component level only for high criticality.
- Mark Regulatory Obligations: References to relevant standards such as DIN EN 13306 attach.
Assign responsibilities practically: For each asset, name the role of the asset responsible person (owner), the executing unit (in-house or service provider), and the CAFM administrator. Ensure that responsible persons also have data responsibility – who maintains the asset ID, test result, and spare part number.
In Practice: Short and Manageable
| Role | Core Task |
|---|---|
| Asset Manager | Approve condition assessment, ensure compliance |
| Maintenance technician | Perform tasks, complete inspection report |
| External service provider | Special inspections, certificate creation |
| CAFM administrator | Maintain maintenance plan, manage appointments and documentation |
Concrete example: For the central heating system in Building A, the asset responsible person is named at the facility management level; regular annual maintenance is carried out by the internal team, while safety-relevant pressure tests are handled by a certified service provider. The CAFM administrator ensures that test reports and spare part numbers are linked to the asset ID, so that later audits are reliable.
Assessment and Limits: Many teams underestimate the effort involved in data responsibility. If you only distribute responsibilities nominally, data quality remains poor and automatic scheduling in CAFM becomes useless. Next step: systematically build up the master asset data and mandatorily define the minimum master data per asset.
2. Build Asset Master Data and Database
Record Directly: A usable asset register is the foundation; otherwise, any automatic maintenance planning remains piecemeal. Without clear Asset-ID, location reference, and basic documents, neither schedule management nor spare parts linking will function reliably.
Minimum Data Set and Data Entry Order
- Essential:
Asset-ID, Asset Name, Building Location (Technical Room/Floor), Manufacturer, Model, Serial Number. - Operational Data: Installation Date/Commissioning, Operating Hours (if available), Current Condition Label (A-B-C or numerical).
- Maintenance-Relevant Information: Basic maintenance interval, assigned inspection logs (link), required qualification for execution.
- Spare Part References: critical spare part numbers with minimum stock and estimated delivery time.
- Documents & Evidence: Linked manuals, certificates, inspection reports, photo of the nameplate.
Practical Rule for Data Collection: Start with the minimum data set for all assets and enrich only critical systems component by component. The temptation to immediately catalog every screw costs time and delays automation.
Trade-off: A complete component structure increases the accuracy of maintenance intervals but multiplies effort and maintenance requirements. In practice, component detailing is only worthwhile for highly critical or expensive assets; everything else remains at the equipment level.
Organize Data Collection Pragmatically: Combine a one-time inspection with document import (manufacturer data, test certificates) and a subsequent cleanup cycle. Appoint a small team for data ownership: who approves asset data, who uploads photos, who validates spare parts.
Case Study: For a heating circuit pump with the identifier P-123 , you record: Asset ID P-123, Location: Heating Central Ground Floor, Manufacturer/Type, Installation Date 2016, Last Test Status: Functional Test 2025-02-10 (Link to Test Protocol), Critical Spare Part: Seal 789-456, Minimum Stock 2. These entries allow automatic due date tracking and immediate creation of a work order in the CAFM.
Important technical note: Barcode or QR tagging reduces data entry errors and speeds up mobile data collection, but incurs costs for labeling and scanners. Decide based on cost-benefit: Tagging is usually economical for >200 assets; below that, structured Excel/CSV with clean Asset-ID-convention.
Important: The most common cause of faulty maintenance plans is not a lack of software, but a lack of consistent Asset-ID-rules and verifiable document links.
Consider integration: Prepare the export in CSV format so that field names match the target CAFM. Use the internal mapping first on 20 test assets before performing a mass import. For information on data quality, see our guide on data quality and asset management.
Consequence: If you approach asset master data carelessly, planned maintenance will remain reactive. Invest the necessary hours in a lean but binding master data set – after that, automated scheduling and spare parts management in CAFM will quickly pay off.
3. Choose Maintenance Strategy and Set Intervals
Key point: The choice of maintenance strategy is the lever that creates or destroys predictability. When creating a maintenance plan, choose strategies asset-specifically rather than across the board: time-based measures are quickly deployable, condition-based and predictive approaches require data maturity and change budget profiles.
Strategies: Short and Tangible
Time-based: Good for legally regulated inspections and simple, non-critical components. Advantage: Simple implementation, often without sensors. Disadvantage: Unnecessary interventions or missed failures with variable usage.
Condition-based: Makes sense when test signals are available without major infrastructure (e.g., vibration, temperature, oil level). Limitation: only works with reliable measured variables and defined limit values; without clear measurement instructions, your maintenance log will only provide noise.
Predictive: Only use this where failure costs are high and you historically have enough data or can immediately retrofit sensors. Practical verdict: Predictive maintenance reduces unplanned downtimes in the long term, but requires investment in sensor technology, connection to maintenance planning software, and data science resources.
| Strategy | Typical Triggers | Required Inputs | Practical Limitation |
|---|---|---|---|
| Time-based | Calendar date, operating hours | Standard interval, execution time, qualification | Over-monitoring with variable usage |
| Condition-based | Measurement value exceeded (e.g., vibration) | Measuring points, thresholds, inspection report | Only works with reliable measured variables |
| Forward-looking | Trend deviation, ML alarm | Historical data, sensor technology, analysis pipeline | Initial high effort; requires data maintenance |
- Decision Process: Prioritize assets by criticality and failure consequence, check existing measurement data or inspection logs, calculate investment and operating costs for sensors/software, and define a pilot for the top-critical assets.
- Regulatory Embedding: Check standards and regulations before selecting a strategy; safety-relevant inspections must meet minimum intervals, see DIN EN 13306.
- Resource Alignment: Align the strategy with personnel qualifications and spare part availability; predictive maintenance is of little use if no one on-site can process the findings.
Practical example: In a production hall, the time-based oil change schedule for transformers was supplemented by temperature trend monitoring. Within twelve months, the number of unexpected replacement orders decreased because alarms signaled cracks in the insulating oil early on. The pilot included three transformers, sensor installation, and mapping of alarm limits into the CAFM.
Evaluation and pitfalls: Many teams overestimate immediate efficiency gains from predictive maintenance. In practice, the most common source of error is a lack of data quality and unclear alarm definitions. Before extensively retrofitting sensors, test on a few critical assets and validate signals against real disruptions.
Important: Define interval logic and due date rules precisely in your maintenance plan template (e.g., 12 months or 5,000 operating hours, whichever comes first) – this prevents duplicate or conflicting orders in the CAFM.
The following course of action is recommended: Choose the strategy asset-by-asset, pilot the most technically demanding cases, and write the interval rules so they can be directly imported into the CAFM. After that, you can set maintenance intervals and systematically map them in the template.
4. Maintenance Plan Template: Fields, Structure, and Work Instructions
Core thesis: A template is only helpful if it enforces structured mandatory fields instead of free-text descriptions. Without precise field definitions, the result remains a chaotic maintenance log that cannot be reliably imported into CAFM or automated.
Structure: Mandatory Fields First, Convenience Fields Second
Focus the template on a small set of mandatory columns necessary for scheduling, qualification, and verification. Write these fields as required in the CSV/Excel schema and use dropdown codes for recurring values (e.g., qualification levels, interval types, test status). Free-text fields only for brief additional notes; long work steps belong in a linked worksheet or PDF.
| Column Name | Data Type/Format | Required | Validation / Example |
|---|---|---|---|
| Task ID | String | Yes | Unique code, e.g., K-204 |
| Asset ID | String | Yes | Must match Asset-Stamm P-123 |
| Activity description | Short text (max 200 characters) | Yes | Check burner performance; no detailed work instruction |
| Interval | ISO-8601/Rule or Operating Hours | Yes | P1: 12M or 5000h (whichever comes first) |
| Qualification Code | Dropdown (e.g., TECH1, ELEK2) | Yes | TECH1 = trained heating technician |
| Test Characteristic|Set Value | Structured Text (Measurement Point:Value:Unit) | Yes | Exhaust Temp: < 250:C |
| Spare Part Numbers | List (Comma separated) | No | 789-456 |
| Proof Template | Filename/Link | Yes | boilerK-204protocol.pdf |
Practical insight: Structured test characteristics (e.g., measurement point: target value: tolerance) are more important than a detailed work instruction. Digital checklists and mobile testing apps can only work with clear, machine-readable measurement instructions; narrative instructions often end up as unverified, irrelevant text in the test log.
Limitation/Trade-off: More fields increase data quality, but they also increase on-site data entry effort. Our recommendation: Make a minimal set mandatory, and maintain extended fields only for highly critical assets. For larger portfolios, a tiered data entry model is more efficient than a universal full data entry requirement.
Concrete example: Boiler maintenance K-204: Task ID K-204-A01, Asset ID K-204, Interval 12M, Preparation time 30 min, Execution time 90 min, Qualification TECH1, Test characteristic Exhaust temp: Target < 250 C: Tolerance 10 C, Spare part gasket 789-456, Safety measure Shutdown and de-energize, Documentation: boilerK-204log.pdf. This entry allows automatic scheduling, a mobile test list, and direct reordering of the spare part via an interface to procurement.
CSV/Excel Recommendations and Mapping Notes
Export the schema with clear column names and use ISO date formats (YYYY-MM-DD) as well as standardized interval definitions. When importing into CAFM, first check the field mapping with 10 test rows; common errors include incorrect asset IDs, different abbreviations for qualifications, and deviating units for measured values.
- Mapping Tip: Create a lookup in the CAFM for
Qualifikation-Code, instead of importing free text. - Validation: Before rollout, check that
Prüfmerkmal|Sollwertby-rule is transferred to the mobile checklist. - Fallback Rule: If no measurement is possible, mandatory
Status=Beurteiltinstead of leaving blank.
Important: Avoid narrative work instructions as the sole control instrument. Structured data enables automation, auditability, and KPI evaluation.
Next step: Save the CSV schema as a control version, import 20 test rows into the CAFM, and check if mobile inspection logs, spare part linkages, and alarm rules are triggered correctly. If unsure, consult the specifications in the standard reference list, e.g., DIN EN 13306, and refer to the data quality checklist from our guide: Data Quality and Asset Management.
5. Planning, Scheduling, and Resource Management
Core thesis: Scheduling is not just about filling a calendar, but about balancing due dates, personnel availability, and spare parts inventory. When creating a maintenance plan, plan capacity first, not tasks — otherwise, you'll shift problems to the backlog.
Scheduling Logic and Planning Modes
Rolling plan instead of a static list. Work with rolling 12-month perspectives, recalculated monthly. Define blackout periods (maintenance-free production weeks) and prioritize appointments by criticality, not just date. This reduces ad-hoc conflicts and unplanned shifts.
Batching and setup time optimization. Bundle similar activities per location on one day to reduce setup time. The trade-off: larger batches increase the likelihood that a system failure affects multiple assets simultaneously. Decide based on failure costs versus travel and setup costs.
- Automatic Repetition: Use CAFM functions for task creation and set clear due date rules (e.g., ISO interval or operating hours).
- Buffer and Failure Rate: Plan a capacity reserve of 15-25 percent for disruptions; otherwise, the backlog will quickly grow.
- Spare Part Reservation: For critical tasks, create a pre-reservation in ERP/CAFM so that parts are not only ordered when the order is opened.
- Outsourcing for Peaks: For seasonal peaks, short-term outsourcing is often more cost-effective than permanent overcapacity.
Capacity formula (practical): Use Benötigte Technikerstunden = Anzahl Tasks x Durchschnittliche Auftragsdauer and then Benötigte Techniker = Benötigte Technikerstunden / (Verfügbare Stunden pro Techniker x Nutzungsfaktor). Use a utilization factor of 0.7 to 0.8 for realistic planning (breaks, travel, administration).
Concrete example: On a campus, there are 10 air conditioning units, each service package takes 2.5 hours including travel. Annual task: 10 tasks x 2.5 h = 25 h. Available hours per technician per month ~ 120 h, with a utilization factor of 0.75, this results in an effective 90 h/month. One technician easily covers this annual task; with 100 units, you would theoretically need 250 h, meaning about 3 technicians (250 / 90 ≈ 2.8).
Interface Control: Ensure that planned orders in CAFM automatically trigger material reservations and that work orders are assigned SLA types. When importing the maintenance plan template, check if Ersatzteilnummern and Lagerort are correctly mapped, otherwise appointments will be generated but not executable.
Practical Limitation: Full automation usually fails due to missing or inaccurate data. If asset locations or spare part references are incomplete, planned orders will be released without parts or repeatedly postponed. Therefore, prioritize data maintenance for assets with high maintenance volume.
When you take the next step, integrate these planning rules into your CAFM template and test the mapping with 20 entries. For tips on mobile execution and digital checklists, see our article on digital maintenance and mobile technology.
Key Insight: Plan capacity conservatively and automate appointment generation only where asset data and spare part maintenance are reliable. Otherwise, your automatic maintenance plan will become a daily source of disruption.
6. Integration into CAFM/EAM and Use of Mobile Tools
Straight to the point: The integration of your maintenance plan into CAFM/EAM determines whether the process works in practice or ends in Excel exports. If you create maintenance plan understand it as a one-time list, you miss the leverage for automating appointments, spare parts management, and audit-proof documentation.
Practical Integration Steps
Start with a clear master data decision: which system is the source of truth for asset master data, who keeps parts lists and stock levels up to date. In many projects, a poorly chosen master system causes duplicate work and incorrect appointment releases. Determine early whether CAFM or an ERP/SAP EAM controls parts inventory and set up an API or CSV interface for bidirectionality (REST/SOAP depending on the system).
- Import Check: Test the CSV mapping with 20 assets, check asset IDs, qualification codes, and units, and document deviations as mapping fixes.
- Escalation Logic: In the CAFM, define rules for what happens when a test result is outside tolerance (automatic work order, blocking indicator, notify asset manager).
- Upgrade Resistance: Avoid heavy customization in standard fields; every adjustment increases risk and costs during system updates (Planon, IBM Maximo, SAP EAM are robust but rigid with changes).
Practical Objection: Many teams believe that additional fields solve all problems. In practice, too many mandatory fields slow down technicians on-site. Opt for a tiered validation model: minimally required for triggering an order, extended fields only for critical assets.
Mobile Use: Offline, Usability, and Proof of Performance
Key takeaway: Mobile tools are only as good as their workflow design. Ensure checklists are short, metric-oriented, and capable of offline use; poor usability leads to technicians continuing to use paper inspection logs and later transferring them incompletely into the system.
- Offline-first: Mobile app must support synchronization, conflict resolution, and retry logic, otherwise data will be missing after fieldwork.
- Quick Identification: QR/barcode scanning reduces misallocations; require scan before starting protocol, not as an option.
- Audit Trail and Signature: Digital signature and photo evidence are mandatory for test certificates and external audits.
Concrete example: During a campus rollout, the team imported the maintenance plan template into the CAFM, mapped inspection features to mobile checklists, and enabled QR tagging. Technicians scan the nameplate, the app automatically pulls the correct inspection log, and photos and a digital signature field are required. Result: Compliance rate increased by visible percentage points within a month, and reorders for spare parts were automatically triggered to the ERP.
Important trade-off: Real-time integration provides immediate transparency but requires stable wireless networks and more complex error handling. Offline synchronization is more robust in harsh environments but introduces latency in error messages and material reservations. Weigh these factors based on network quality and process criticality.
Asset-ID, inspection characteristic with target/tolerance, status (OK/NOK), photo(s), digital signature. Everything else can be optional until the pilot shows that users can reliably perform data entry.Tip: Start integration and mobile use in a pilot with 1-2 asset classes, test mapping, offline behavior, and parts workflows, then roll out in stages. Read our guide to digital maintenance and mobile technology for more information.
7. Key Figures, Audit, and Continuous Improvement
Clear key performance indicators determine whether your maintenance plan is alive or merely fulfilling reporting obligations. Don't measure everything, but rather the few key performance indicators that directly show whether planning, execution, and documentation are working—and whether the CAFM truly simplifies the work.
Which Key Figures Really Help
| KPI | Calculation | Practical Target (Guideline) |
|---|---|---|
| Planned Maintenance Percentage (PMP) | Planned Maintenance Hours / Total Maintenance Hours × 100 | 70–85% for stable asset portfolios |
| Mean Time To Repair (MTTR) | Total Repair Time / Number of Repairs | Depends on asset class; goal: continuous decrease |
| Mean Time Between Failures (MTBF) | Total Operating Hours / Number of Failures | Increase over time as a goal |
| Backlog (Hours) | Sum of open, due hours | Downward trend; target values are asset-specific |
| Compliance Rate of Inspections | Completed mandatory inspections / planned inspections × 100 | >= 95% for safety-relevant systems |
Practical Limitation: High PMP is good—but not at the expense of ignoring critical ad-hoc tasks. An excessive focus on percentage targets encourages KPI gaming (e.g., misclassifying tasks). Design KPIs so they are easily verifiable and difficult to misuse.
Audit Practice and Documentation
Auditing means more than just presenting lists. Inspection logs must be stored in an audit-proof manner, with digital signatures, photos as evidence, and a clear link to the asset ID in the CAFM. Use audit trails to uncover process weaknesses: random mobile checklist reviews often reveal operational errors or misunderstood inspection features.
- Audit Checkpoints: Spot checks of 5-10 completed orders, review of measured values against target/tolerances, proof of spare part withdrawal and release processes.
- Focus: In case of deviations, don't just sanction the employee; analyze whether the test characteristic, training, or mobile usability was the problem.
- Standard Reference: Check documentation requirements for safety-relevant inspections according to DIN EN 13306 and proof of compliance; consult for questions regarding occupational safety DGUV consult.
Trade-off in audit frequency: Frequent audits find more errors but cost time. The goal is not zero errors, but measurable process improvement—e.g., fewer recurring errors per audit cycle.
Continuous Improvement: Concrete Workflow
Establish a simple, repeatable cycle: capture baseline → analyze root cause (Pareto) → adjust maintenance measure or checklist → pilot → KPI measurement. Choose small, time-limited experiments (2-3 months) instead of large rollouts without measurement.
Concrete example: In a campus pilot, mobile checklists for chillers were improved and critical spare parts were reserved. Result: PMP increased from around 55% to 78% within four months; MTTR decreased by a good 20% because technicians no longer had to reorder parts. The change was not solely a technology effect, but a combination of data maintenance, parts inventory, and adjusted checklists.
Rating: KPIs without process anchoring are useless. Measure, but then invest in concrete corrective actions (training, precision of inspection features, parts management). Prioritize measures based on failure costs and compliance risk—not on the magnitude of the KPI deviation.
Next step: Define 3 KPIs for your pilot (e.g., PMP, MTTR, compliance rate), measure a four-week baseline, conduct a 3-month test, and then decide which measures to scale. This is more pragmatic than re-evaluating the entire portfolio immediately.
8. Implementation Roadmap, Pilot, and Rollout Checklist
Core claim: A structured pilot with clear go/no-go criteria is the only reliable method for scaling a functional maintenance plan. Without defined cancellation criteria and a data freeze for the pilot assets, the rollout will end in endless rework.
Phases of the Implementation Roadmap
Plan the rollout as a series of short, controlled phases with measurable results per phase. Each phase needs a responsible owner, a defined duration, and a clear success criterion that leads to either progression or rollback.
- Preparation (1-2 weeks): Select pilot assets, data freeze based on master data, create field mapping plan.
- Data Cleansing & Import Test (1 week): Import 20 test lines, document returns, fix top 5 errors.
- Shadow Run (2 weeks): Technicians perform work concurrently on paper and digitally, record deviations.
- Live Pilot (4-8 weeks): Mobile checklists active, partial reservation tested, daily stand-ups for troubleshooting.
- Rollout stages (staggered): 20 percent of assets, then 50 percent, then full rollout; review and approval after each stage.
- Review & Stabilization (6–12 weeks after rollout): KPI check, refine processes, training as needed.
Trade-offs to consider: Shorter pilots cover routine processes but overlook rare error cases. Longer pilots demonstrate robustness under failure conditions but delay benefit realization. Choose the duration based on asset complexity and technician availability.
Change management measures: Create a stakeholder map, appoint change ambassadors in the technical teams, and plan for competency verification via digital signature upon completion of training. Use feature flags in the CAFM to gradually activate new fields or test rules.
Concrete example: On a university campus, twelve identical ventilation units in one building wing were chosen as a pilot. During the initial import, about 30 percent of the spare part numbers were missing; the team set up a one-week data correction shift, introduced QR tagging, and then started the live pilot. After six weeks, reliable mobile logs and automatic material reservations were available, enabling a phased rollout.
- Essential Rollout Checklist (12 points): Define and approve pilot scope
- Set up data freeze for pilot assets
- Perform mapping review and 20 test imports
- Document and prioritize top 5 data errors
- Create mobile checklists and test offline
- Provide QR/barcode tagging for pilot assets
- Check spare part reservations in CAFM/ERP
- Training: short practical session + competence signature
- Conduct shadow run with paperless comparison
- Establish weekly stand-ups and ticket management
- Define criteria for Go/No-Go meeting (e.g., error rate < X, mobile feedback positive)
- Decision gate for rollout with defined scope
A common mistake is to make the pilot too broad. Instead, choose a locally concentrated asset group of medium complexity. This minimizes logistical effort, allows for control, and provides usable insights for the use of maintenance plan templates and mobile documentation. For technical details on mobile implementation, read our article on digital maintenance and mobile technology and check regulatory requirements such as DIN EN 13306 for safety-relevant inspections.
Next step: Select pilot assets this week, define the success criteria, and run the first 20 test imports before the next sprint. Based on the pilot data, decide whether to adopt the maintenance plan creation template unchanged or make targeted adjustments.
9. Templates and Practical Examples
Brief and to the point: Download packages contain two things you need immediately: an importable Excel/CSVtemplate for direct import into CAFM and tested practical examples (work orders) that serve as a reference for interval and inspection specifications.
Scope of delivery (file names) – just an example, you have to assemble the templates yourself: Maintenance planTemplateMinimalYYYYMMDD.xlsx, Maintenance PlanTemplateCompleteYYYYMMDD.xlsx, CSV import schemaCAFMYYYYMMDD.csv, Sample orderHeatingBoilerK-204.csv, Sample OrderElevatorA-01.csv, KPI DashboardTemplateExcelYYYYMMDD.xlsx, ReadmeImportMapping.pdf.
- Excel variant: flexible for adjustments, comfortable dropdown fields, good for pilot teams.
- CSV import schema: strictly formatted,
UTF-8with ISO date format (YYYY-MM-DD), mandatory for automated CAFM imports. - Example orders: actual values, check points with target/tolerances, predefined qualification codes and spare part references.
Practical insight: PDF exports are useful for audits, but they are not importable. If you want to transition to digital work, plan the work in two tracks: 1) Audit-proof PDFs/protocols; 2) structured CSV/Excel for CAFM. Many teams underestimate the effort required to convert narrative inspection steps into structured inspection features – expect manual rework here.
Mapping notes for Planon / IBM Maximo / SAP EAM: Align Qualifikation-Code with the CAFM lookup (no free text). For intervals, use ISO periods (P6M for 6 months) or a field IntervallTyp plus IntervallWert (e.g. MONTHS / 6). Spare part numbers must be linked to the ERP/parts catalog – import master parts data first, otherwise you will create unexecutable orders.
Concrete example: File Sample OrderElevatorA-01.csv contains Task ID A-01-REV, Asset ID A-01, Interval P6M, Qualification ELEK2, Test characteristic: Rope tension: Target=1100:N. During import into Planon, we mapped Intervall to the field frequency and Qualifikation to a predefined skillset. Result: automatic scheduling and mobile checklist with mandatory photo. The pilot required 2 hours of mapping adjustment and a correction pass for 12 faulty asset IDs — this is normal.
Limitation / Trade-off: Free Excel templates reduce entry barriers, but they often generate unstructured free text. If you wartungsplan erstellen with the goal of automation, invest time in standardizing codes and a small lookup repository. Without this preliminary work, the import remains error-prone.
Important: Test every import with 10-20 assets first; then perform a quality review before executing mass imports.
License and Usage: The templates are released for internal use; check the exact license information in the Readme. For standard references, see DIN EN 13306 and for practical tips on data quality, our guide to data quality and asset management.
Next Step: Download the ZIP, open ReadmeImportMapping.pdf, perform the 20-line test import and document all mapping fixes — only then scale up. This is the only guarantee that your templates will actually accelerate the path from Excel to a productive CAFM.
Answers to Real Problems
- How often to update the maintenance plan: At least once a year; immediately after safety-relevant changes or incidents. Rule of thumb: Annual review + ad-hoc updates after malfunctions.
- Import into CAFM possible? Yes — but first test with 10–20 lines and document every mapping. Pay attention to ISO date formats and consistent qualification codes, otherwise you will generate non-executable work orders.
- Time-based or condition-based? Choose hybrid: time-based for legal inspections, condition-based for rotating machinery, predictive only with clear cost-benefit data. Limitation: Predictive requires data maintenance and analysis expertise.
- Which fields are mandatory? Absolutely: Asset ID, Task ID, interval definition, inspection characteristic with target/tolerance, qualification, proof template. Without these fields, automation remains piecemeal.
- Reference legal requirements? Yes. Link relevant standards such as DIN EN 13306 in your plan; but leave legal assessments to the legal department or external experts.
- Offline mobile issues: If the connection is unstable, opt for offline-first apps with conflict resolution. Trade-off: Latency in material reservation vs. reliability of on-site data capture.
Practical Limitation: A common mistake is believing that a single master Excel will solve data quality issues. In practice, you need a small governance unit (1-2 people) for mapping fixes, lookup standardization, and version control.
Concrete example: When importing a pilot into a CAFM, 14 out of 50 asset IDs did not match the asset master data, resulting in appointments being generated without partial reservations. Solution: 1) Stop mass import, 2) Correction run for asset IDs and spare part references, 3) Re-test import. Afterwards, automatic material reservations and mobile checklists ran as planned.
Lesson learned from practice: FAQs only work if they are accessible and versioned. Teams that scatter FAQs in emails lose control. Instead, create a central FAQ page in the CAFM and link it to pilot assets.
Next steps, immediately actionable: Version your readme, perform a 20-line test import, note the top 5 mapping errors, and assign a data owner for 8 weeks.
Once these measures are in place, link the FAQ to the pilot dashboard and schedule a weekly check-in (15 minutes) to resolve emerging questions. This way, you avoid small problems stopping the rollout. And nobody wants that ;-)


