""" Build dashboard2.html from dashboard_data.json + User list.xlsx Run: python build_html.py """ import json, openpyxl # ── Load data ────────────────────────────────────────────────── with open('dashboard_data.json', encoding='utf-8') as f: data = json.load(f) wb = openpyxl.load_workbook('User list.xlsx', data_only=True) ws = wb.active user_map = {} for i, row in enumerate(ws.iter_rows(values_only=True)): if i == 0: continue uid, email = row[0], row[1] if uid and email and uid not in user_map: user_map[int(uid)] = str(email).split('@')[0] DATA_JS = json.dumps(data, ensure_ascii=False, default=str) NAMES_JS = json.dumps(user_map) HTML = r""" Warehouse Efficiency Dashboard

Warehouse Efficiency Dashboard

Workload · Backlog · Thoi gian xu ly · Throughput

Tu:
Den:

Ton dong theo cong doan — Tinh theo Ma hang (tat ca ngay)

So ma da qua cong doan truoc nhung chua hoan thanh cong doan nay

1. Workload theo ngay — So Ma & Control

Cot dam = so ma (Part Number) | Cot mo = so Control (Packaging & Stock)

2. Workload theo User — tung cong doan

Moi duong = 1 user · Y = so ma xu ly moi ngay

RECEIVING

QC IN

PACKAGING IN

STOCK IN

3. Trung binh nang suat theo cong doan

Y = TB so ma xu ly moi ngay · Diem thap nhat = Bottleneck

4. Phan cong nhan su — Heatmap theo ngay

Mau cang dam = cang nhieu ma · Packaging & Stock hien thi Ma/Control

5. Thoi gian cho TB giua cong doan

Gio lam viec thuc te (tru gio nghi)

5. Thoi gian xu ly tung ma (Receive to Stock)

Moi diem = 1 control · X = ngay Receive · Y = tong gio lam viec

5. Tra cuu timeline ma hang

Nhap Part Number de xem ma do di qua cac cong doan khi nao

6. Ty le throughput — Cohort theo ngay Receive

Trong so ma nhan ngay do, bao nhieu % da hoan thanh tung cong doan (luon <= 100%)

7. Phan phoi thoi gian nhan hang (Receiving ID)

Moi cot = so chuyen giao hang trong khung gio · Xem theo ngay / thang / nam

Ty le hoan thanh cong viec nhap hang

Lu ke den ngay duoc chon · Chon Ngay / Thang / Nam + ky cu the

Hang muc Can xu ly Hoan thanh Con lai Ty le Tien do

Bang tong hop
""" HTML = HTML.replace('###DATA###', DATA_JS).replace('###NAMES###', NAMES_JS) with open('dashboard2.html', 'w', encoding='utf-8') as f: f.write(HTML) print('dashboard2.html built OK, size:', len(HTML)//1024, 'KB')