Checklist Kebersihan Harian Excel Portable «EXCLUSIVE ✧»
The Digital Broom: Why a Portable Excel Checklist Transforms Daily Cleaning
In the fast-paced environment of modern offices, retail stores, and healthcare facilities, maintaining consistent daily hygiene is a non-negotiable priority. For years, many organizations have relied on paper-based logbooks or memory to track cleaning tasks. However, these methods are prone to human error, forgery, and loss. The solution lies not in expensive proprietary software, but in a tool almost every computer already has: Microsoft Excel. When designed as a portable daily cleaning checklist, Excel offers a unique combination of accessibility, accountability, and analytical power that paper simply cannot match.
1. Dropdown for Shift Selection
Add a shift selector (Morning, Afternoon, Night). Use =TEXT(NOW(),"dddd") to auto-populate the day of the week. checklist kebersihan harian excel portable
Customizing for Different Industries
- For Office Buildings: Include specific metrics like "Paper towels in kitchen full?" and "Dishwasher emptied."
- For Medical Clinics: Add a column for "Biohazard waste disposed" and a confirmation checkbox for "Changed high-efficiency filters."
- For Restaurants (HACCP): Integrate temperature logs. The same portable file can track cooler temperatures AND floor sweeping status.
Lampiran B — Contoh Formula
- Lookup area dari TaskID: =XLOOKUP(B2,MasterTasks!$A:$A,MasterTasks!$B:$B,"Not found")
- TotalTasks per tanggal: =COUNTIFS(Daily_Log!$A:$A,$F$2)
- Completed: =COUNTIFS(Daily_Log!$A:$A,$F$2,Daily_Log!$G:$G,"Selesai")
- Percent: =IFERROR(Completed/TotalTasks,0)
Manfaat
- Praktis: Bisa dijalankan langsung dari flash drive atau folder lokal.
- Terstruktur: Menyediakan format yang konsisten untuk tugas, status, dan catatan.
- Terukur: Mempermudah pelacakan frekuensi dan kepatuhan.
- Fleksibel: Dapat disesuaikan untuk berbagai skala: individu, tim kebersihan, atau shift.
- Mudah dicadangkan: File dapat disalin ke storage lain sebagai arsip harian.
6. Contoh Template (deskripsi)
Sertakan baris contoh di MasterTasks:
- 001 | Dapur | Bersihkan meja dan permukaan | Daily | 10 | High
- 002 | Kamar Mandi | Isi sabun & lap lantai | Daily | 8 | High
- 003 | Lobby | Vacuum karpet | Daily | 15 | Medium
Contoh baris Daily_Log:
- 2026-04-08 | 001 | Dapur | Budi | 08:00 | 08:10 | Selesai | —