# School Time Table — Session Reference Notes

## What happened (May 9, 2026 session)

### Problem: Empty VBA-style HTML Dashboard
- Generated `TimeTable_Dashboard.html` — looked like old Excel/VBA grid
- All data was "FREE" placeholder, no real content
- User rejected: "VBA style kyu banaya? and ye chal bhi nahi raha dhang se"
- User confirmed: dashboard didn't work properly

### Root cause
- Generated empty template grid without real data
- Assumed VBA look was acceptable
- Generated HTML without asking for school data first

### User's Tailscale setup
- Machine name: `victus`
- Tailscale hostname: `nilgiri-wyvern.ts.net`
- Tailscale URL base: `https://victus.nilgiri-wyvern.ts.net/`
- No port suffix needed in URL (default 443 assumed)

### Existing Excel files checked
1. `all_in_one_time_table.xlsx` — one sheet "All Classes Time Table", only headers, no data (empty Gujarati grid 8:00-3:10)
2. `time_table_template.xlsx` — one sheet "Time Table", empty placeholder grid with Gujarati headers

### User's explicit preferences
- "I don't think u should add port at end" → Always NO port number in Tailscale URL
- "VBA style kyu banaya?" → NEVER use VBA/Excel-like styling in HTML
- "chal bhi nahi raha dhang se" → Dashboard must actually work before sharing

## Correct workflow (embedded in skill)
1. Ask for: Class list, Teachers+Subjects mapping, School timing
2. OR offer demo with sample data first
3. Build Excel with REAL data (not empty grids)
4. Build modern HTML dashboard (card layout, no VBA look)
5. Serve via Tailscale URL — NO port number

## Data format from UDISE+/school records
- Class names: 9A, 9B, 9C, 10A, 10B, 10C, 11, 12 (observed in current HTML)
- School timing: 8:00 AM - 3:10 PM (8 periods of 45 min each)
- Days: Monday-Saturday (Mon-Fri full day, Sat half)
- Time slots in Gujarati numerals: ૮:૦૦-૮:૪૫ format