Service Reporting Console — EOD / EOC

A lightweight, browser-based tool for generating End of Day and End of Cycle service reports (availability, response time, incident counts) from an Excel export — no database, no backend, no manual recalculation.

Built as a prototype for an internal service-desk reporting workflow at a financial institution, replacing a manual Excel-to-report process.

Sample data only — this repo and any deployed instance use placeholder demo data, not real production or institutional data.

What it does

• Upload a daily .xlsx file -> generates an End of Day snapshot: per-system availability, response time, incident count, and threshold-based flagging.
• Upload one or more files spanning a date range -> generates an End of Cycle rollup: per-system trend (improved / declined / stable), a trend chart, total incidents, and a "systems requiring attention" summary.
• Export either report back out to Excel, or print to PDF.

All parsing happens client-side in the browser (via SheetJS) — nothing is uploaded to a server. This means the tool is safe to host publicly: it's blank and does nothing until a visitor uploads their own file into their own browser session.

Tech

• Single static HTML file — no build step, no framework
• SheetJS (xlsx) for reading .xlsx files in-browser
• Chart.js for the End of Cycle trend chart

Run locally

Just open public/index.html in a browser. No server required.

Deploy

This repo is pre-configured for one-click static deployment on Vercel:

npm install -g vercel
vercel

Vercel auto-detects the static config in vercel.json and serves everything in /public.

Try it

A sample dataset is included at public/sample_service_data.xlsx — six placeholder banking systems (Flexcube, Oracle Box, Mobile App, ePay, ATM Switch, Internet Banking) across a 10-day window, with realistic availability/response-time variation.

Project status

This is a Phase 1 prototype. See the accompanying functional specification for full scope, data structure assumptions, and Phase 2 considerations (database integration, scheduled ingestion, automated distribution).

License

Personal/educational project. Not affiliated with or endorsed by any institution referenced in the sample data.