G
Guest
I have to create a loan (Line of Credit) tracker application, where users can analyse their loan over a term. They can make changes to monthly entries to see how long it would take them to pay of the loan.
At present users are given an Excel spreadsheet with embedded formulas which calculates monthly entries over a period of 30 years (360 months, which is maximum term for Line of Credit) i.e. they are presented with 360 rows. The spreadsheet contains follows columns:
Date, AmountD/F,IncomeDeposited,CashExpenditure,CreditExpenditure,Withdrawals,AmountC/F
Where Date column stores date in “MMM-yyyy†(Jan-2004) format.
The way user ascertain the term of loan is, they have to find the row where AmountCF is equal to 0 or is a negative value and the Date associated with that row is the date when there loan would be paid off.
Now users make changes to IncomeDeposited, CashExpenditure, CreditExpenditure, Withdrawals for a particular month and the spreadsheet re-calculates the values.
How can I implement similar functionality in VB.Net without using Excel, as users may not have Microsoft Office installed? Is there a way of doing it using DataTable and DataGrid, so that it performs calculations when a value is changed in DataGrid. Programmatically create rows in DataTable until AmountC/F reaches 0 or a negative value… or something. I am bewildered. Please help with some ideas.
thnx
At present users are given an Excel spreadsheet with embedded formulas which calculates monthly entries over a period of 30 years (360 months, which is maximum term for Line of Credit) i.e. they are presented with 360 rows. The spreadsheet contains follows columns:
Date, AmountD/F,IncomeDeposited,CashExpenditure,CreditExpenditure,Withdrawals,AmountC/F
Where Date column stores date in “MMM-yyyy†(Jan-2004) format.
The way user ascertain the term of loan is, they have to find the row where AmountCF is equal to 0 or is a negative value and the Date associated with that row is the date when there loan would be paid off.
Now users make changes to IncomeDeposited, CashExpenditure, CreditExpenditure, Withdrawals for a particular month and the spreadsheet re-calculates the values.
How can I implement similar functionality in VB.Net without using Excel, as users may not have Microsoft Office installed? Is there a way of doing it using DataTable and DataGrid, so that it performs calculations when a value is changed in DataGrid. Programmatically create rows in DataTable until AmountC/F reaches 0 or a negative value… or something. I am bewildered. Please help with some ideas.
thnx