s*****w 发帖数: 1527 | 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 ! |
|