ExcelFlux
← Workbooks

Maintenance Planning and Downtime

Track calendar and meter-based intervals together. Prioritize due maintenance using the expected downtime cost.

Macro-free .xlsx · 18 sample records · Workbook labels in Turkish

Results from the sample workbook

Sonraki bakım
2026-10-05
Kalan gün
-27
Kalan sayaç saati
40

Who can use it, and for what?

Maintenance planners

Compare calendar and meter thresholds to separate upcoming maintenance from overdue work.

Fleet, facilities and production managers

Coordinate machine downtime with the production or service schedule.

A worked example from the workbook

EQ-101 has 40 meter hours remaining but its calendar service is already 27 days overdue. It is marked priority 2. Use its estimated 4,000 planned downtime cost when scheduling the stop.

Worksheet from the completed Excel sample
View from the Excel workbook. Open the image to enlarge it.
MeasureSample result
Sonraki bakım2026-10-05
Kalan gün-27
Kalan sayaç saati40
Öncelik2
Planlı duruş maliyeti4,000

How do you start with your own data?

  1. Use one asset ID and take the last-service date and meter from the same work order. Use consistent meter units and set calendar and meter warning thresholds.
  2. Make a copy of the sample workbook. Review the settings on Panel and replace the blue inputs on Veri with your own data.
  3. Compare dashboard totals with the row-level results on Veri. The written guide below shows how to test a change.
Detailed Excel guide

Initial setup

Use one asset ID and take the last-service date and meter from the same work order. Use consistent meter units and set calendar and meter warning thresholds.

  1. Open a copy and try the sample data first. Panel contains settings and totals. Veri contains editable inputs and formulas. Workbook field labels are in Turkish and appear as written in the file.
  2. Compare the settings and the first data row below with the workbook. Blue cells are inputs. Preserve the working formulas.
  3. The workbook has 18 populated examples and 98 prepared formula rows. Keep the headers and replace the input values with your own records.

Panel settings

CellFieldSample value
Panel!B7Kontrol tarihi2026-11-01
Panel!B8Takvim erken uyarı (gün)14
Panel!B9Sayaç erken uyarı (saat)80

First data row

CellFieldSample value
Veri!A7EkipmanEQ-101
Veri!B7Son bakım tarihi2026-08-06
Veri!C7Periyot (gün)60
Veri!D7Son bakım sayacı1,000
Veri!E7Güncel sayaç1,440
Veri!F7Sayaç periyodu480
Veri!G7Duruş (saat)2
Veri!H7Duruş bedeli/saat2,000

Calculated results and formulas

These values are calculated from the supplied workbook examples.

Formulas below use English Excel syntax. Function names and separators can vary with your Excel locale.

CellFieldSample value
Veri!I7Sonraki bakım
Cell formula=IF(A7="","",B7+C7)
2026-10-05
Veri!J7Kalan gün
Cell formula=IF(A7="","",I7-Panel!$B$7)
-27
Veri!K7Kalan sayaç saati
Cell formula=IF(A7="","",D7+F7-E7)
40
Veri!L7Öncelik
Cell formula=IF(A7="","",IF(OR(J7<=0,K7<=0),2,IF(OR(J7<=Panel!$B$8,K7<=Panel!$B$9),1,0)))
2
Veri!M7Planlı duruş maliyeti
Cell formula=IF(A7="","",G7*H7)
4,000

Dashboard indicators

These values are calculated from the supplied workbook examples.

CellFieldSample value
Panel!E7Bakımı gelen ekipman16
Panel!E8Yaklaşan bakım2
Panel!E9Bakımı gelenlerin duruş bütçesi183,000
Panel!E10Toplam duruş saati61

Change one input and check the result

  1. Open the Veri sheet in the sample workbook.
  2. B7 → enter 2026-10-15.
  3. L7 expected value 1.
  4. Review the affected dashboard metrics. Restore the test input or save the example as a separate copy before using your own data.

Interpretation and troubleshooting

Calendar and meter triggers are checked independently. Priority two indicates due, one indicates near due, and zero indicates no warning. Reconcile replaced or reset meters before using the result.

If the result does not change, confirm the input cell and sheet and check that automatic calculation is enabled. To reproduce the example, leave the remaining inputs at their starting values.