Sheets
8
With automation rules
Nemokamas atsisiuntimas
Patalpų remonto užduočių našumo suvestinė
Consultation
Galime padėti nuspręsti, kas turėtų likti Excel, o kas turėtų pereiti į žiniatinklio sistemą, atsižvelgdami į objektų skaičių, savininkus, pranešimų taisykles ir istorijos sekimo poreikius. Taip pat galime pakoreguoti tik tuos stulpelius, kurių iš tikrųjų reikia dabartinėje darbaknygėje.
Galime pritaikyti stulpelius prie dabartinės darbaknygės.
Nemokamas Excel suvestinės šablonas, kuris remonto užklausas paverčia užbaigimo rodikliu, reakcijos laiku, MTTR, paslaugos tikslo pasiekimu, vėlavimo rizika ir pakartotinio remonto rodikliais. Tame pačiame puslapyje rodomas ir atitinkamas žiniatinklio sistemos procesas.
work orders
service targets
MTTR
overdue risk
Metrics
11 metrics
Completion and service targets
Output
Monthly brief
Manager-ready
Input example
Turn repair records into management KPIs
The dashboard shows whether responses are timely, issues repeat, teams are overloaded, and service quality is slipping.
Report month
May 2026
Work orders
286
Service target
87%
Risk
18 overdue items
Free Download
Pirmiausia peržiūrėkite, kas yra Excel versijoje
Nemokamas Excel suvestinės šablonas, kuris remonto užklausas paverčia užbaigimo rodikliu, reakcijos laiku, MTTR, paslaugos tikslo pasiekimu, vėlavimo rizika ir pakartotinio remonto rodikliais. Prieš įvesdami įrašus suderinkite parametrus, savininkus, kategorijas ir būsenos taisykles.
File
Patalpų remonto užduočių našumo suvestinė.xlsx
File name: facility_management_work_order_kpi_dashboard_template_lt.xlsx
Sheets
8 sheets
Purpose
Vadovas, suvestinė, darbo užsakymai, nustatymai, turto registras, automatizavimo taisyklės, KPI skaičiavimas, šaltiniai
The new workbook includes 8 sheets: Guide, Dashboard, Work Orders, Settings, Asset Register, Automation Rules, KPI Calculation, and Sources.
The dashboard highlights overdue backlog, SLA misses, repeat repairs, high-cost work orders, and low satisfaction.
Automation Rules turns dispatch, reminders, escalation, satisfaction collection, and preventive maintenance into system-ready business rules.
Align parameters, owners, categories, and status rules before entering site data.
How Excel is used
Kaip patalpų našumo valdymas veikia Excel
The workbook is designed so source records, assumptions, analysis, dashboard, and report pages lead to a management decision.
Step 1
Record each work order
Enter request source, location, priority, assignment time, response time, completion time, owner, cost, and satisfaction.
Step 2
Set service targets
Define expected response and completion limits by emergency, high, medium, and low priority.
Step 3
Review metric movement
Check completion rate, service target attainment, average response time, MTTR, overdue rate, and repeat repair rate.
Step 4
Follow up risk lists
Use overdue, repeat, high-cost, and low-satisfaction lists to decide immediate actions.
Excel to screen mapping
Kuriuos ekranus atitinka Excel stulpeliai?
Mapping workbook columns directly to screens makes scope and implementation order easier to understand.
Excel element
System element
Notes
Excel element
Work Orders
System element
Request list
Notes
Keep company, site, department, asset, request source, failure category, dispatch, response, completion, cost, and satisfaction in one record.
Excel element
Settings and Asset Register
System element
Settings and asset screens
Notes
Align companies, sites, departments, priorities, statuses, technicians, SLAs, criticality, and asset master data.
Excel element
KPI Calculation
System element
Performance dashboard
Notes
Calculate completion rate, SLA attainment, MTTR, overdue backlog, repeat repair rate, satisfaction, and cost from the dashboard filters.
Excel element
Dashboard and Automation Rules
System element
Manager briefing page
Notes
Connect metric changes, risk prompts, dispatch reminders, escalation rules, and satisfaction collection to management actions.