🚀 Extension Project III: 스프레드시트 혼돈에서 웹 앱으로

Source: Dev.to

So here’s the deal: this semester I jumped into a real‑world challenge with a partner company. Their entire financial and inventory management was stuck in spreadsheets—manual entries, repetitive calculations, errors everywhere, and zero visibility for decision‑making. Basically… a nightmare. I kept thinking, “Seriously, in 2025 we’re still doing this?”

제가 만든 것

A web application that replaces the spreadsheet‑based workflow with an agile, data‑driven system.

주요 기능

• Customizable categories and payment methods → 맞춤형 카테고리 및 결제 수단
• Automatic integration: purchases → expenses, sales → income → 자동 통합: 구매 → 비용, 판매 → 수익
• Dashboards with five core visualizations → 다섯 가지 핵심 시각화를 포함한 대시보드
• Lightweight JSON persistence + client‑validated prototypes → 경량 JSON 영속성 + 클라이언트 검증 프로토타입

실제 효과

• Fewer errors, leading to greater trust in the numbers → 오류 감소로 숫자에 대한 신뢰도 향상
• Instant visibility of cash flow and spending patterns → 현금 흐름 및 지출 패턴을 즉시 파악
• Direct support for day‑to‑day decisions → 일상적인 의사결정을 직접 지원

기술 스택

• Repository:
• Live demo:

교훈

This wasn’t just about coding. It was about proving that technology can turn clunky processes into something agile and strategic. Spreadsheets are fine… until they’re not.