excel-reporting

Type-safe Excel (.xlsx) reports for TypeScript: typed schemas, real formulas, styles, native Excel tables and streaming exports in Node.js, Bun and Deno.

AI-powered contract analysis tool for Term Sheets and LOIs. Supports Azure OpenAI and Google Gemini, extracts key terms from Word, PDF, Excel, and image files, and generates structured Excel reports. Features GUI & CLI, robust authentication, and customizable prompts for flexible legal review

VAT reconciliation control app for comparing VAT registers, return summaries, payments/refunds, and GL control movements with exception reporting and Excel export.

Interactive Excel dashboard analyzing UK road accident data for 2021–2022 (307K+ records)

This case study is designed for e-commerce teams, store operators, agencies, and freelancers who need recurring exports and reporting-ready files from Shopify-style order, product, and customer data.

Production-grade sales forecasting system using ARIMA, Holt-Winters, and ML with automated reporting.

Food-delivery market-intelligence system built on 197,430 orders across 10 fields, answering 5 strategic questions on expansion, churn, and demand. Custom 0-100 City Expansion Opportunity Index and Restaurant Health Score, RFM analysis, ARIMA forecasting, and delivery via a 9-tab Streamlit dashboard, 20-sheet Excel report, and 6 Tableau extracts

A Machine Learning-Based Decision Support System for Predicting Customer Attrition and Quantifying Revenue Risk in Subscription Businesses

Bulk Gmail credential validation using Python, Selenium, Docker, and GitHub Actions with Excel-based reporting and security auditing.

Python automation tool for Cisco switch collection, parsing, Excel reporting, dashboards, JSON snapshots, and topology crawl.

Production-style RPA pipeline built with Python, Selenium, pandas, and openpyxl for web automation, data processing, Excel reporting, and scheduler-ready execution.

School Analytics Dashboard – Flask web app to track attendance, fees, grades, and student reports with Excel export.

Process unlimited Excel files automatically: clean data by processing each, standardize columns, merge files, and generate professional reports with visual tools.

A practical SQLite portfolio project analyzing property occupancy, rent collection, tenant payments, and maintenance KPIs using SELECT, JOIN, GROUP BY, CASE WHEN, SUM, COUNT, and date filtering.

Automated GST purchase-register and GSTR-2B reconciliation with deterministic matching, review workflows, and Excel reporting.

Uncovering customer value and purchase behavior from 42K+ transactions using RFM, segmentation, and revenue analysis.

An offline-first, dual-mode (Web/Desktop) automation tool consolidating CSAT data into enterprise Excel reports with Zero-PII privacy. 企業級問卷整合系統，支援純前端與本機離線雙軌運行，實現零個資外洩，符合嚴格資安合規標準。

Portfolio risk management tool using VaR, Expected Shortfall, Risk Parity and Black-Litterman optimization.

AI-assisted job intelligence pipeline for structured JD analysis and candidate-role matching.

A/B test readout pipeline: data checks (incl. sample ratio mismatch), z-tests with Holm correction, bootstrap, power/MDE, SQL cross-check in DuckDB, and an Excel decision readout. Shown on a 90k-player public game experiment. Tested on every push.