怎样用excel生成 monthly expense report# Windows - 看得见风景的窗口
s*w
1 楼
找了一圈没找到,过来请问一下高手。
从银行下了1年的transaction,
有存钱的,有付账的,按日期排的excel文件。
怎样才能生成 monthly expense report and chart ?
if c code, should be like this
for (all data for this year)
if (data is for Jan.)
if deposit, then deposit += this_deposit
if bill, then bill += this_bill
so i can get the total deposit/bill for this month,
in the end it can display a chart with 2 bars for each month,
1 for income, 1 for expense.
thanks a lot !
从银行下了1年的transaction,
有存钱的,有付账的,按日期排的excel文件。
怎样才能生成 monthly expense report and chart ?
if c code, should be like this
for (all data for this year)
if (data is for Jan.)
if deposit, then deposit += this_deposit
if bill, then bill += this_bill
so i can get the total deposit/bill for this month,
in the end it can display a chart with 2 bars for each month,
1 for income, 1 for expense.
thanks a lot !