Sheets
8
With automation rules
무료 다운로드
시설 작업 지시 성과 대시보드
상담
필드, 승인, 알림, 대시보드를 웹 시스템으로 옮기고 싶다면 현장의 업무 흐름에 맞춰 설계할 수 있습니다.
If you need team collaboration, mobile data entry, photo uploads, corrective action reminders, or dashboards, view the systemized version.
수리 요청을 완료율, 응답 시간, MTTR, 서비스 목표 달성률, 연체 위험, 반복 수리 지표로 전환하는 무료 Excel 대시보드 템플릿입니다. 같은 페이지에서 대응하는 웹 시스템 흐름도 확인할 수 있습니다.
work orders
service targets
MTTR
overdue risk
Metrics
11 metrics
Completion and service targets
Output
Monthly brief
Manager-ready
템플릿 미리보기
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
무료 다운로드
시설 작업 지시 성과 대시보드
수리 요청과 작업 지시 성과를 KPI로 검토합니다.
파일
시설 작업 지시 성과 대시보드.xlsx
File name: facility_management_work_order_kpi_dashboard_template_ko.xlsx
시트
8 sheets
용도
Guide, Dashboard, Work Orders, Settings, Asset Register, Automation Rules, KPI Calculation, Sources
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.
입력 영역과 수식 영역을 분리했습니다. 먼저 입력 영역부터 작성하세요.
업무 흐름
이 템플릿 사용 방법
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 필드를 시스템으로 매핑하는 방법
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.