Sheets
9
Decision flow separated
Free Download
Equipment Repair or Replace Decision Analyzer
Consultation
We can help decide what should stay in Excel and what should move to a web system, based on site count, owners, dashboard needs, notification rules, and history tracking requirements. We can also adjust only the columns you actually need in your current workbook.
For team collaboration, mobile data entry, photo uploads, reminders, or shared dashboards, discuss the features your web system would need.
A free Excel template for comparing continued repair costs with replacement costs before a facility asset becomes a budget issue. The system example link is available only in supported languages.
asset register
repair history
cost comparison
budget report
Decision
Repair or replace
Cost comparison
Output
Budget-ready
Decision summary
Input example
Turn repair history into a replacement decision
The workbook compares repair cost rate, equipment age, downtime loss, and replacement cost so managers can decide with numbers.
Review date
2026-05-05
Asset
Main chiller CH-02
Indicator
Repair cost rate 34%
Recommendation
Plan replacement
Free Download
See what is inside the Excel version first
A free Excel template for comparing continued repair costs with replacement costs before a facility asset becomes a budget issue. Align parameters, owners, categories, and status rules before entering site data.
File
Equipment Repair or Replace Decision Analyzer.xlsx
File name: facility_management_equipment_repair_replace_lcc_template_en.xlsx
Sheets
9 sheets
Purpose
Equipment register, scenario assumptions, lifecycle cost comparison, decision matrix, approval and execution tracking
Includes a guide, dashboard, equipment register, repair records, LCC comparison, decision matrix, scenario analysis, approval tracking, and data dictionary.
Records and compares separately calculated repair and replacement costs using repair cost, downtime loss, energy difference, residual value, and budget limits.
Carries the final recommendation into approval status, order amount, scheduled work date, and completion verification records.
Align parameters, owners, categories, and status rules before entering site data. This file contains record tables, so costs and decision results must be calculated separately and updated manually.
How Excel is used
How repair or replace decisions work in Excel
The workbook organizes source records, assumptions, separately calculated results, dashboards, and decision notes to support a management decision.
Step 1
Register asset basics
Enter asset ID, category, start date, purchase cost, expected life, current replacement cost, and risk level.
Step 2
Record repair history
Add repair dates, cost, downtime hours, repeat failure flags, and production or service impact.
Step 3
Compare two options
Review continued repair cost, replacement cost, savings, residual value, and the decision ratio.
Step 4
Prepare the budget note
Use the decision matrix to explain why the asset should be repaired, watched, or replaced.
Excel to screen mapping
Which Excel columns become which screens?
Mapping workbook columns directly to screens makes scope and implementation order easier to understand.
Excel element
System element
Notes
Excel element
Asset register
System element
Asset master
Notes
Keep asset ID, category, location, purchase cost, replacement cost, and risk level consistent.
Excel element
Repair records
System element
Maintenance history screen
Notes
Review recent repair cost, downtime hours, repeat failures, and vendor notes.
Excel element
Lifecycle cost comparison
System element
Decision model
Notes
Compare continued repair cost with replacement cost and planned savings.
Excel element
Decision report
System element
Budget approval view
Notes
Show a concise recommendation that managers and finance can review.