| WK | Site | Section | Task / Description | Status | Remark / Note |
|---|
| Section | Total | Done | In Progress | Pending | Completion % |
|---|
| Site | Done | In Progress | Pending | Assets | Working |
|---|
| WK | Site | Section | Task / Description | Status | Remark / Note |
|---|
| Section | Total | Done | In Progress | Pending | Completion % |
|---|
| Site | Done | In Progress | Pending | Assets Added |
|---|
| Week | Site / Location | Month | Section | Task / Description | Remark / Note | Status | Incident? |
|---|
| Week | Month | Open | InProg | Pend. | MRInfo | QuotePO | P.Local | P.Imp | Resolvd | Closed | Total |
|---|
Create Your Google Sheet
Go to sheets.google.com and create a new spreadsheet. Name it MES IT Operations.
The sheet needs two tabs — one for Tasks and one for Assets.
📋 Tab 1 — Tasks — columns in row 1:
📦 Tab 2 — Assets — columns in row 1:
💡 Your team fills in this sheet from any device — phone, laptop, anywhere with Gmail.
Publish the Sheet (one-time setup)
In Google Sheets: File → Share → Publish to web
2️⃣ Click Share → Publish to web
3️⃣ In the first dropdown: pick your Tasks sheet tab
4️⃣ In the second dropdown: choose Comma-separated values (.csv)
5️⃣ Click Publish → copy the link
6️⃣ Repeat for the Assets tab
⚠️ Only makes it readable by the dashboard — your team still controls who can edit. You can also paste the normal sheet URL below and the dashboard will try to convert it automatically.
Paste Your Sheet Links Below
In Google Sheets → File → Share → Publish to web → select Tasks tab → CSV → Publish → copy URL for the Tasks field.
Then repeat for Assets tab, then for Tickets tab — each gives a different URL with a different
gid= number.❌ Do NOT paste the same URL in multiple fields — each tab has a different
gid= number.
① Tasks tab published CSV link:
② Assets tab published CSV link (must be a different URL — different gid= number):
③ Tickets tab published CSV link (optional — for live ticket numbers sync):
Share the Google Sheet with Your Team
In Google Sheets: click Share (top right) → add your team's Gmail addresses.
Give them Editor access so they can fill in their site data.
Each team member opens the Google Sheet on their phone or laptop, adds their data row by row. You open this dashboard, click 🔄 Sync Now, and all data loads instantly.
💡 You can also set up auto-sync every 5 minutes below.
Organisation Details
🏙️ Main Sites — for Tasks
These locations appear in the Task Editor site dropdown and on the main dashboard filter.
📍 Asset Sites — all locations
All physical locations where equipment exists — used in the Asset Summary site view.
KPI Targets
🔐 Admin PIN
Change the 4-digit PIN required to access Data Entry and Settings. Default PIN is 1234 — change it to keep your settings secure.
⚠️ PIN is stored in this browser only. Clearing browser data resets it to 1234.