Excel 活頁簿產生 Excel Workbook Builder

I've built budget.xlsx, but I haven't recalculated it. LibreOffice isn't installed here, so Excel will calculate the formulas when you open the file. The script that generates it is build_xlsx.py, in the same folder.

What's in it

• Inputs sheet: the assumptions are in yellow cells and labelled "Sample". They are monthly income 4,500, rent 1,400, food 600, transport 250, utilities 200 and a savings goal of 15%.
• Budget sheet:
  • Categories: rent, food, transport and utilities. Each amount is a formula pointing at the Inputs sheet (for example =Inputs!B5), and each has a "% of income" column.
  • Totals: a total spent row (=SUM(B4:B7)), income, and the remaining amount (income minus total spent).
  • Savings check: it compares the remaining amount with income × savings goal %. It shows "On track - surplus of …" or "Short by …".
• Chart: a bar chart of spending by category, titled as sample, next to the table.

What I checked

• I reopened the saved file and confirmed there are two sheets, one chart, and no hard-coded numbers on the Budget sheet. Every amount and total is a formula.
• I read each formula's cell references by hand and they point at the right inputs.
• Working it out by hand with the sample numbers, total spent is 2,450, remaining is 2,050, and the savings goal is 675. The check should therefore read "On track - surplus of 1,375.00".

Not checked

• No recalculation, so I haven't seen the computed values or confirmed the chart renders correctly.
• If a number looks off when you open it, tell me.

Your call: the savings goal isn't counted as a spending category. It's only compared against what's left over. I can add it as a category if you'd rather see it in the total and the chart.