Daily Rollout Dashboard

Site Visit Tracking · Powered by Google Sheets
🔍
—:—
Total Plan
— sites scheduled
Survey Plan
— on-site
Installation Plan
— on-site
On Service Plan
— on-site
Clearing Plan
— on-site
Total Teams
unique teams
🧑‍🔧
Team On Site
0/0 (0%)
🚫
Not On Site
0% of total
Completed (100%)
0%
Pending (0%)
0% of total
🔶
Progress 1–50%
0%
🔷
Progress 51–99%
0%

📊 Charts — Activity / Region / Subcon

📍 Region — stacked by Activity

🏢 Subcon — stacked by Activity

🗺️ Region — stacked by Subcon

⏰ Check-in Time Analysis

From Team On Site Column

📍 Check-in — stacked by Region

🏢 Check-in — stacked by Subcon

⏱️ Subcon — stacked by Time Analysis

📋 Site Plan Summary — Region × Subcon × Activity

🗓️ Site Visits —

#Plan DateSite CodeRegionZoneSite Name SubconTeamActivity Team On Site
iEPMS Check-In Progress
Current Activity Current Progress
EHS Status
Remark Progress
On Site Remark
Update TimeUpdate By
👥
Total Teams
in system
📋
Teams with Plan
— of total
Teams On Site
— of planned
GAP
⚠️
No Plan Today
— of total
🗺️
Sites Planned
— activities
🏁
Sites Completed
— completed
Filter:

📝 Team Status

Data from Team Status Sheet

👷 Team List / Subcon

เลื่อนตารางซ้าย/ขวาเพื่อดูข้อมูลเพิ่มเติม

⚡ Team Efficiency — Site Progress Overview

Total Sites
in range
GAP
On Service Completed
—%
On Service 100% (including pending clearing)
Pending Clearing
Avg Install → On Service
days avg (OS done) ·
Avg On Service → Clearing
days avg (clearing done) ·
Avg Total Duration
days (Install→Clear, done) ·
Region Subcon ✅ Completed ⏳ Install Aging 🔧 Clearing Aging
Done Install→
On Service
avg days
On Service→
Clearing
avg days
Total
avg days
Sites ≤1d 2d 3d 4-7d >7d Avg
Aging
Sites ≤1d 2d 3d 4-7d >7d Avg
Aging
Click "Analysis" to Load Data
💡 Click Any Row to Drill into Site Detail  |  Green ≤3d   Yellow ≤7d   Red >7d  |  Clearing Aging: ไม่มี activity clearing = ถือว่า clearing เสร็จ

📋 TI Overview

Last updated: -
Press Refresh เพื่อดึงข้อมูลจากชีต TI
รายงานสรุปสถานะการดำเนินโครงการ (Project Implementation Lifecycle) ทั้ง 12 ขั้นตอน
ภาพรวมความคืบหน้าแต่ละลำดับขั้น โดยเน้นการระบุช่องว่าง (Gap) และเปอร์เซ็นต์ความสำเร็จเพื่อวิเคราะห์ประสิทธิภาพการทำงาน

🧭 Milestone Flow

PO Scope = 2318 sites Project Kick-off: 16-Jan-26
Last updated: -
Press Refresh TI เพื่อดึงข้อมูล TI แล้วแสดง Milestone

🗓️ Subcon Plan by Period

Click 🔍 Analysis to Load Data
Period Region Subcon Active Days Planned Teams Team-Days Avg Team/Day Stable Team % Team Stable Survey TI In House
Click Analysis to Load Data
Period Region Subcon Team Type Active Days Team-Days % Subcon Load % Attendance
Click Analysis to Load Data
Type mapping uses Team No. from Team Summary master. Team names are normalized via the existing team alias/canonical matching flow.
Snapshot
Fit
snapshot
Search Results