—

⬇ Download JSON Backup Copy JSON ⬇ Download CSV

Data syncs automatically on every save and on page load. Update URL if you redeploy the script.

⬇ Pull from Cloud ⬆ Push to Cloud

Export your Excel as CSV first (File → Save As → CSV), then drop here.

1. Go to dash.cloudflare.com → Pages → Create application → Upload assets
2. Rename this file to index.html and upload it
3. Deploy — you get a free URL (e.g. kanchana.pages.dev)
4. Access from any device including iPad at that URL
5. To update: re-upload via Pages dashboard → Deployments → Upload

1. Open KG Routine Tracker Google Sheet
2. Extensions → Apps Script → paste kanchana-apps-script.js into Code.gs
3. Click Deploy → New deployment → Type: Web app
4. Execute as: Me · Who has access: Anyone
5. Click Deploy → Authorize access → Advanced → Go to project (unsafe) → Allow
6. Copy the Web App URL and paste it in the ☁️ Cloud Sync card above

• On page load: fetches all entries from Google Sheet, merges missing dates into localStorage
• On Save Entry: immediately pushes to Google Sheet
• Nav bar shows ✓ Synced (green) or ✗ Offline (red)
• Offline mode works — localStorage keeps everything, syncs on next connection
• Data stored as JSON in cell A1 of the "Data" sheet tab

• Each new deployment = new URL — update it in Cloud Sync card above
• Use Manage deployments → Edit (pencil) to update without changing URL

• Single-file HTML — no build step, only Chart.js (CDN)
• localStorage keys: k50v3_entries, k50v3_masters, k50_sync_url
• Cloud: Google Apps Script Web App (free, no OAuth)
• Current URL: https://script.google.com/macros/s/AKfycbwUi4KLl_6POZuyZWTDw6XZx0xdUkk3a-aHO81Je9I-PNgAEMcvrtyYlRvDkT7HHJtmQQ/exec