Spreadsheet: 599353d1542984576-distribute-values-between-two-different-dates-copy-of-loan-calculation-work-sheet-version01-
Sheet: Dash Board

 | Sum of Loans -Summary (Branch Wise) |  |  |  |  | Month |  |  |  |  |  |  |  |  | Value of Weekly Closed Vs New Customers |  |  | Value of Monthly Closed Vs New Customers
 |  | Daily |  |  | 2018-09-20 00:00:00 | Weekly |  |  |  | Monthly
 | Branch Name | Target | Loan Amt | Interest | % Achieved | Target | Loan Amt | Interest | % Achieved | Target | Loan Amt | Interest | % Achieved |  | Closed | New |  | Closed | New
 | [NAME] | 100000 |  |  |  | 700000 |  |  |  | 3000000
 | Kundasale | 80000 |  |  |  | 320000 |  |  |  | 2400000
 | Total
 | Sum of Loans -Summary (Officer Wise) |  |  |  |  | Select Branch |  |  |  |  |  |  |  |  | Value of Weekly Closed Vs New Customers |  |  | Value of Monthly Closed Vs New Customers
 |  | Daily |  |  |  | Weekly |  |  |  | Monthly
 | Officer Name | Target | Loan Amt | Interest | % Achieved | Target | Loan Amt | Interest | % Achieved | Target | Loan Amt | Interest | % Achieved |  | Closed | New |  | Closed | New
 | [NAME] | 20000 |  |  |  | 120000 |  |  |  | 500000
 | D.M.Krishanta | 20000 |  |  |  | 120000 |  |  |  | 500000
 | Total
 | Sum of Investement & Interest Recovery - Summary (Branch Wise) |  |  |  |  |  |  |  |  |  |  | Daily Sum |  |  | Weekly Sum |  |  | Monthly Sum
 |  | Daily |  |  | Weekly |  |  | Monthly |  |  |  | Investment Vs Recovery |  |  | Investment Vs Recovery |  |  | Investment Vs Recovery
 | Branch Name | [NAME] | Interest Recovery | Total Recovery | Invstmnt Recovery | Interest Recovery | Total Recovery | [NAME] | Interest Recovery | Total Recovery |  | Invested Amt | Recovered Amt |  | Invested Amt | Recovered Amt |  | Invested Amt | Recovered Amt
 | [NAME]
 | Kundasale
 | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 | Sum of Investement & Interest Recovery - Summary (Officer Wise) |  |  |  |  |  |  | Select Branch |  |  |  | Daily Sum |  |  | Weekly Sum |  |  | Monthly Sum
 |  | Daily |  |  | Weekly |  |  | Monthly |  |  |  | Investment Vs Recovery |  |  | Investment Vs Recovery |  |  | Investment Vs Recovery
 | Officer Name | [NAME] | Interest Recovery | Total Recovery | Invstmnt Recovery | Interest Recovery | Total Recovery | [NAME] | Interest Recovery | Total Recovery |  | Invested Amt | Recovered Amt |  | Invested Amt | Recovered Amt |  | Invested Amt | Recovered Amt
 | [NAME]
 | D.M.Krishantha
 | Total
 | Bank Deposits - Summary (Branch Wise) |  |  |  |  |  |  |  |  |  |  | Today New Customeers |  | 2018-09-19 00:00:00
 |  | Daily |  |  | Weekly |  |  | Monthly |  |  |  | Branch | Name | Town | Loan Amt | % Interest | Period | Total Interest | Officer
 | Branch Name | Customer Payments | Bank Deposits | [NAME] | Customer Payments | Bank Deposits | [NAME] | Customer Payments | Bank Deposits | [NAME]
 | [NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | Kundasale | 35000 | 0.07 | 60 | 4900.000000000001 | [NAME]
 | Kundasale
 | Total
 | Bank Deposits - Summary (Officer Wise) |  |  |  | Select Branch |  |  |  |  |  |  | Today Not Paid Customers |  | 2018-09-19 00:00:00
 |  | Daily |  |  | Weekly |  |  | Monthly |  |  |  | Branch | Name | Town | Phone No | Loan Amt | Instalment | Period | Officer
 | Officer Name | Customer Payments | Bank Deposits | [NAME] | Customer Payments | Bank Deposits | [NAME] | Customer Payments | Bank Deposits | [NAME]
 | [NAME]
 | D.M.Krishantha
 | Total
 | KPI |  |  |  | Branch 01 | 2018-09-18 00:00:00 | 2018-10-18 00:00:00 | 2018-11-18 00:00:00 | 2018-12-18 00:00:00 | 2019-01-18 00:00:00
 | Bank Balance |  |  |  |  | 0 | 0 | 0 | 0 | 0
 | Total Loan Amount Invested
 | Total Expected Interest
 | Balance Investment to Recover
 | [NAME] to Recover
 | Total Investment Recovery
 | Total Interest Recovery
 | Bank Deposits
 | Number of Loans Given
 | Top-Up Customers
 | Number of Top-Up Loans
 | Top-Up Customer Loan Value
 | Number of Ordinary Loans
 | Recovery Efficiency
 | New Customers
 | New Customer Loan Value
 | Closed Customers
 | Number of Paying Customers
 | Expenses |  |  |  |  | 0 | 0 | 0 | 0 | 0
 | Profit/Loss |  |  |  |  | 0 | 0 | 0 | 0 | 0