Spreadsheet: 599357d1542988193-distribute-values-between-two-different-dates-copy-of-loan-calculation-work-sheet-version01-
Sheet: New Customers

Customer Profile |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | New | Ordinary
Branch Information-► |  |  |  |  |  | Customer Information-► |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Area Information-► |  |  |  | Loan Information-► |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gurantor Information-01-► |  |  |  |  |  |  |  |  |  | Gurantor Information-02-► |  |  |  |  |  |  |  |  |  | Remarks-► |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Regular | Top-Up
Loan Code | Branch Name | Branch Code | Officer Name | Officer Code | Customer Title | Customer Name | Gender | Date of Birth | NIC Number | Customer Status | [NAME] | Education | Customer Bank | Account No | [NAME] No. | Street/Road /Lane | Main City | Contact No | E-Mail | Type of Business | Job/ Profession | Distance to Center(Km) | Nearest Town | District | Province | Date of Loan | Loan Amount (Rs.) | [NAME] | Payment Method | Period (Days) | % of Interest | Effective Interest Rate | Interest/ Instalmnt | Investment/Instalmnt | Total Interest | Total with Interest | Number of Instlmnts | Loan Instalment | Document Charges | Other Charges | Curantor Name ■ | Gender ■ | Date of Birth ■ | NIC Number ■ | Apartment/ House No ■ | Street/Road /Lane ■ | Main City ■ | Town ■ | E-Mail ■ | Contact Number ■ | Curantor Name● | Gender● | Date of Birth● | NIC Number● | Apartment/ House No● | Street/Road /Lane● | Main City● | Nearest Town● | E-Mail● | Contact Number● | Payment Differed | Loan Closed | Loan Topped Up
WG0000001 | [NAME] | WGLKND001 | [NAME] | WGL001 | Mr. | [NAME] | Male | 1971-06-13 00:00:00 | 711650628V | New | Married | Graduate | Bank of Ceylon | 1884512345 | 8 | Temple Road | [NAME] | 713619063 | [EMAIL] | Small Scale Hotel | Engineer | 20 | Kundasale | [NAME] | Central Province | 2018-09-20 00:00:00 | 35000 | Top-Up | Daily | 60 | 0.07 |  |  |  |  |  |  |  | 250 | 0 | [NAME] | Male | 1965-08-23 00:00:00 | 65345678V | 54/B | Uda Road | [NAME] | Kundasale | No | 774567634 | Pushpa Rathnayake | Female | 1967-01-25 00:00:00 | 67345675V | 32A | Gravel Road | [NAME] | Kundasale | No | 76546783
WG0000002 | Kundasale | WGLKND001 | D.M.Krishanta | WGL002 | Mr. | [NAME] | Male | 1970-08-14 00:00:00 | 701650628V | New | Married | Advanced Level | Commercial Bank | 4512345 | 12 | Gravel Road | [NAME] | 715643264 | No | Large Scale Grocery | Businessman | 15 | Teldeniya | [NAME] | Central Province | 2018-09-18 00:00:00 | 35000 | Top-Up | Weekly | 90 | 0.07 |  |  |  |  |  |  |  | 250 | 0 | [NAME] | Male | 1965-08-24 00:00:00 | 65345678V | 54/B | Uda Road | [NAME] | Kundasale | No | 774567635 | Pushpa Rathnayake | Female | 1967-01-26 00:00:00 | 67345675V | 32A | Gravel Road | [NAME] | Kundasale | No | 76546784
WG0000003 | [NAME] | WGLKND002 | R.M.Sunil | WGL003 | Mr. | T.N.Pathirana | Male | 1970-08-15 00:00:00 | 701650628V | New | Married | Ordinary Level | Hatton National Bank | 24567892 | 2 | Main Road | [NAME] | 715643265 | No | Large Scale Grocery | Businessman | 16 | Kundasale | [NAME] | Central Province | 2018-09-22 00:00:00 | 50000 | Ordinary | Daily | 30 | 0.07 |  |  |  |  |  |  |  | 250 | 0 | [NAME] | Male | 1965-08-25 00:00:00 | 65345678V | 54/B | Uda Road | [NAME] | Kundasale | No | 774567636 | Pushpa Rathnayake | Female | 1967-01-27 00:00:00 | 67345675V | 32A | Gravel Road | [NAME] | Kundasale | No | 76546785
WG0000004 | Teldeniya | WGLKND003 | S.M.Shanta | WGL004 | Mr. | [NAME] | Male | 1969-05-16 00:00:00 | 696754321V | Regular | Married | Ordinary Level | Commercial Bank | 181234567 | 45B | Church Road | [NAME] | 715643265 | No | Small Grocery Shop | Businessman | 10 | Kundasale | [NAME] | Central Province | 2018-09-19 00:00:00 | 25000 | Ordinary | Weekly | 60 | 0.07 |  |  |  |  |  |  |  | 250 | 0 | [NAME] | Male | 1965-08-26 00:00:00 | 65345678V | 54/B | Uda Road | [NAME] | Kundasale | No | 774567637 | Pushpa Rathnayake | Female | 1967-01-28 00:00:00 | 67345675V | 32A | Gravel Road | [NAME] | Kundasale | No | 76546785
WG0000005 | Teldeniya | WGLKND003 | S.M.Shanta | WGL004 | Mr. | T.Gunawathi | Female | 1960-05-17 00:00:00 | 606754321V | Regular | Divorsed | Grade 10 | Bank of Ceylon | 1884512322 | 23/4/45A | Bomaluwa Road | [NAME] | 715643266 | No | Small Grocery Shop | Businesswoman | 11 | Teldeniya | [NAME] | Central Province | 2018-09-20 00:00:00 | 25000 | Ordinary | Weekly | 90 | 0.07 |  |  |  |  |  |  |  | 250 | 0 | [NAME] | Male | 1965-08-27 00:00:00 | 65345678V | 54/B | Uda Road | [NAME] | Kundasale | No | 774567638 | Pushpa Rathnayake | Female | 1967-01-29 00:00:00 | 67345675V | 32A | Gravel Road | [NAME] | Kundasale | No | 76546786
WG0000006 | Teldeniya | WGLKND004 | S.M.Shanta | WGL005 | Mr. | T.Somawathi | Female | 1960-05-18 00:00:00 | 606754321V | Regular | Divorsed | Grade 11 | Bank of Ceylon | 1884512323 | 23/4/45A | Bomaluwa Road | [NAME] | 715643267 | No | Small Grocery Shop | Businesswoman | 12 | Teldeniya | [NAME] | Central Province | 2018-09-21 00:00:00 | 25001 | Ordinary | Weekly | 90 | 0.07 |  |  |  |  |  |  |  | 250 | 0 | [NAME] | Male | 1965-08-28 00:00:00 | 65345678V | 54/B | Uda Road | [NAME] | Kundasale | No | 774567639 | Pushpa Rathnayake | Female | 1967-01-30 00:00:00 | 67345675V | 32A | Gravel Road | [NAME] | Kundasale | No | 76546787
WG0000007 | Teldeniya | WGLKND005 | S.M.Shanta | WGL006 | Mr. | M.Ramya | Female | 1960-05-19 00:00:00 | 606754321V | New | Divorsed | Grade 12 | Bank of Ceylon | 1884512324 | 23/4/45A | Bomaluwa Road | [NAME] | 715643268 | No | Small Grocery Shop | Businesswoman | 13 | Teldeniya | [NAME] | Central Province | 2018-09-22 00:00:00 | 25002 | Ordinary | Weekly | 90 | 0.07 |  |  |  |  |  |  |  | 250 | 0 | [NAME] | Male | 1965-08-29 00:00:00 | 65345678V | 54/B | Uda Road | [NAME] | Kundasale | No | 774567640 | Pushpa Rathnayake | Female | 1967-01-31 00:00:00 | 67345675V | 32A | Gravel Road | [NAME] | Kundasale | No | 76546788
WG0000008