A desktop project for forecasting future engineering tuition, stress-testing savings plans, and turning personal nank statement csv's into personalized savings recommendations.
- Loads the provided Alberta engineering tuition history CSV
- Forecasts future annual tuition using a recency-weighted trend model and estimates the full cost of a four-year degree.
- Projects a savings account forward using monthly contributions and a selectable risk/return profile.
- Accepts spending CSV files, auto-detects or manually maps bank-export columns, classifies essential vs non-essential costs, flags anomalous spending, and suggests realistic monthly cuts.
- Embeds dashboards directly in the desktop app with
matplotlib. - Saves scenarios to SQLite and exports forecast results to Excel.
- Includes a built-in font-size control for a more readable desktop experience.
Planner Dashboardtab for scenario inputs, forecast charts, tuition tables, and recommendations.Spending Analysistab for CSV upload, category dashboards, anomaly detection, and cut recommendations.Scenario Historytab for previously saved runs stored in SQLite.
- Python 3.13
tkinterpandas,numpy,scikit-learnmatplotlibsqlite3openpyxl
- Install dependencies if needed:
python -m pip install -r requirements.txt- Launch the app:
python app.pyOr double-click Launch Tuition Planner.bat.
- The tuition forecaster blends a polynomial regression curve with recent compound annual growth rates to keep long-range forecasts realistic.
- Degree cost is modeled as a four-year path, not a single flat-year estimate, so each academic year can inflate separately.
- The default
TD-style basic savingsprofile is intentionally conservative and can be overridden in the GUI. - Spending analysis uses keyword-based essentiality classification plus
IsolationForestanomaly detection to surface unusual or high-impact transactions.
EngineeringTuitionData.csv: historical tuition data sourcedata/sample_spending.csv: demo spending filedata/tuition_planner.db: SQLite database created on first runexports/: generated Excel workbookstuition_planner/: forecasting, analytics, export, persistence, and GUI code
- Tuition history comes from the local CSV already in this folder, based off of historical costs for an engineering degree in Alberta.
- The conservative baseline savings profile is modeled after a basic TD-style savings setup and is intended as a starting assumption, not financial advice.