Spreadsheet: 184399d1349253370-display-as-1-if-zero-is-repeated-continiously-loan-data1
Sheet: Sheet1

CUSTOMER NAME | CONTACT NO | LOAN A/C NO | DATE OF DISBURSEMENT | LOAN AMOUNT | INST1 | INST2 | INST3 | INST4 | INST5 | INST6 | INST7 | INST8 | INST9 | INST10 | INST11 | INST12 | [NAME] | INST14 | INST15 | INST16 | INST17 | INST18 | INST19 | INST20 | INST21 | INST22 | INST23 | INST24 | INST25 | INST26 | INST27 | INST28 | INST29 | INST30 | INST31 | INST32 | INST33 | INST34 | INST35 | INST36 | INST37 | INST38 | INST39 | INST40 | INST41 | INST42 | INST43 | INST44 | INST45 | INST46 | INST47 | INST48 | INST49 | INST50 | INST51 | INST52 | INST53 | INST54 | INST55 | INST56 | INST57 | INST58 | [NAME] | INST60 | RECOVERY AMOUNT | OUTSTANDING | NPA
 |  |  |  |  | 1 | 2 | 2 | 2 | 2.5 | 2.8 | 3.1 | 3.4 | 3.7 | 4 | 4.3 | 4.6 | 4.9 | 5.2 | 5.5 | 5.8 | 6.1 | 6.4 | 6.7 | 7 | 7.3 | 7.6 | 7.9 | 8.2 | 8.5 | 8.8 | 9.1 | 9.4 | 9.7 | 10 | 10.3 | 10.6 | 10.9 | 11.2 | 11.5 | 11.8 | 12.1 | 12.4 | 12.7 | 13 | 13.3 | 13.6 | 13.9 | 14.2 | 14.5 | 14.8 | 15.1 | 15.4 | 15.7 | 16 | 16.3 | 16.6 | 16.9 | 17.2 | 17.5 | 17.8 | 18.1 | 18.4 | 18.7 | 19
 |  |  |  |  | 1 | 2 | 2 | 2 | 2.5 | 2.8 | 3.1 | 3.4 | 3.7 | 4 | 4.3 | 4.6 | 4.9 | 5.2 | 5.5 | 5.8 | 6.1 | 6.4 | 6.7 | 7 | 7.3 | 7.6 | 7.9 | 8.2 | 8.5 | 8.8 | 9.1 | 9.4 | 9.7 | 10 | 10.3 | 10.6 | 10.9 | 11.2 | 11.5 | 11.8 | 12.1 | 12.4 | 12.7 | 13 | 13.3 | 13.6 | 13.9 | 14.2 | 14.5 | 14.8 | 15.1 | 15.4 | 15.7 | 16 | 16.3 | 16.6 | 16.9 | 17.2 | 17.5 | 17.8 | 18.1 | 18.4 | 18.7 | 19
 |  |  |  |  | 1 | 2 | 2 | 2 | 2.5 | 2.8 | 3.1 | 3.4 | 3.7 | 4 | 4.3 | 4.6 | 4.9 | 5.2 | 5.5 | 5.8 | 6.1 | 6.4 | 6.7 | 7 | 7.3 | 7.6 | 7.9 | 8.2 | 8.5 | 8.8 | 9.1 | 9.4 | 9.7 | 10 | 10.3 | 10.6 | 10.9 | 11.2 | 11.5 | 11.8 | 12.1 | 12.4 | 12.7 | 13 | 13.3 | 13.6 | 13.9 | 14.2 | 14.5 | 14.8 | 15.1 | 15.4 | 15.7 | 16 | 16.3 | 16.6 | 16.9 | 17.2 | 17.5 | 17.8 | 18.1 | 18.4 | 18.7 | 19
 |  |  |  |  | 0 | 0 | 0 | 2 | 2.5 | 2.8 | 3.1 | 3.4 | 3.7 | 4 | 4.3 | 4.6 | 4.9 | 5.2 | 5.5 | 5.8 | 6.1 | 6.4 | 6.7 | 7 | 7.3 | 7.6 | 7.9 | 8.2 | 8.5 | 8.8 | 9.1 | 9.4 | 9.7 | 10 | 10.3 | 10.6 | 10.9 | 11.2 | 11.5 | 11.8 | 12.1 | 12.4 | 12.7 | 13 | 13.3 | 13.6 | 13.9 | 14.2 | 14.5 | 14.8 | 15.1 | 15.4 | 15.7 | 16 | 16.3 | 16.6 | 16.9 | 17.2 | 17.5 | 17.8 | 18.1 | 18.4 | 18.7 | 19
 |  |  |  |  | 1 | 2 | 2 | 2 | 2.5 | 2.8 | 3.1 | 3.4 | 3.7 | 4 | 4.3 | 4.6 | 4.9 | 5.2 | 5.5 | 5.8 | 6.1 | 6.4 | 6.7 | 7 | 7.3 | 7.6 | 7.9 | 8.2 | 8.5 | 8.8 | 9.1 | 9.4 | 9.7 | 10 | 10.3 | 10.6 | 10.9 | 11.2 | 11.5 | 11.8 | 12.1 | 12.4 | 12.7 | 13 | 13.3 | 13.6 | 13.9 | 14.2 | 14.5 | 14.8 | 15.1 | 15.4 | 15.7 | 16 | 16.3 | 16.6 | 16.9 | 17.2 | 17.5 | 17.8 | 18.1 | 18.4 | 18.7 | 19
 |  |  |  |  | 1 | 2 | 2 | 2 | 2.5 | 2.8 | 3.1 | 3.4 | 3.7 | 4 | 4.3 | 4.6 | 4.9 | 5.2 | 5.5 | 5.8 | 6.1 | 6.4 | 6.7 | 7 | 7.3 | 7.6 | 7.9 | 8.2 | 8.5 | 8.8 | 9.1 | 9.4 | 9.7 | 10 | 10.3 | 10.6 | 10.9 | 11.2 | 11.5 | 11.8 | 12.1 | 12.4 | 12.7 | 13 | 13.3 | 13.6 | 13.9 | 14.2 | 14.5 | 14.8 | 15.1 | 15.4 | 15.7 | 16 | 16.3 | 16.6 | 16.9 | 17.2 | 17.5 | 17.8 | 18.1 | 18.4 | 18.7 | 19
 |  |  |  |  | 1 | 2 | 2 | 2 | 2.5 | 2.8 | 3.1 | 3.4 | 3.7 | 4 | 4.3 | 4.6 | 4.9 | 5.2 | 5.5 | 5.8 | 6.1 | 6.4 | 6.7 | 7 | 7.3 | 7.6 | 7.9 | 8.2 | 8.5 | 8.8 | 9.1 | 9.4 | 9.7 | 10 | 10.3 | 10.6 | 10.9 | 11.2 | 11.5 | 11.8 | 12.1 | 12.4 | 12.7 | 13 | 13.3 | 13.6 | 13.9 | 14.2 | 14.5 | 14.8 | 15.1 | 15.4 | 15.7 | 16 | 16.3 | 16.6 | 16.9 | 17.2 | 17.5 | 17.8 | 18.1 | 18.4 | 18.7 | 19
 |  |  |  |  | 1 | 2 | 2 | 2 | 2.5 | 2.8 | 3.1 | 3.4 | 3.7 | 4 | 4.3 | 4.6 | 4.9 | 5.2 | 5.5 | 5.8 | 6.1 | 6.4 | 6.7 | 7 | 7.3 | 7.6 | 7.9 | 8.2 | 8.5 | 8.8 | 9.1 | 9.4 | 9.7 | 10 | 10.3 | 10.6 | 10.9 | 11.2 | 11.5 | 11.8 | 12.1 | 12.4 | 12.7 | 13 | 13.3 | 13.6 | 13.9 | 14.2 | 14.5 | 14.8 | 15.1 | 15.4 | 15.7 | 16 | 16.3 | 16.6 | 16.9 | 17.2 | 17.5 | 17.8 | 18.1 | 18.4 | 18.7 | 19
 |  |  |  |  | 1 | 2 | 2 | 2 | 2.5 | 2.8 | 3.1 | 3.4 | 3.7 | 4 | 4.3 | 4.6 | 4.9 | 5.2 | 5.5 | 5.8 | 6.1 | 6.4 | 6.7 | 7 | 7.3 | 7.6 | 7.9 | 8.2 | 8.5 | 8.8 | 9.1 | 9.4 | 9.7 | 10 | 10.3 | 10.6 | 10.9 | 11.2 | 11.5 | 11.8 | 12.1 | 12.4 | 12.7 | 13 | 13.3 | 13.6 | 13.9 | 14.2 | 14.5 | 14.8 | 15.1 | 15.4 | 15.7 | 16 | 16.3 | 16.6 | 16.9 | 17.2 | 17.5 | 17.8 | 18.1 | 18.4 | 18.7 | 19
 |  |  |  |  | 1 | 2 | 2 | 2 | 2.5 | 2.8 | 3.1 | 3.4 | 3.7 | 4 | 4.3 | 4.6 | 4.9 | 5.2 | 5.5 | 5.8 | 6.1 | 6.4 | 6.7 | 7 | 7.3 | 7.6 | 7.9 | 8.2 | 8.5 | 8.8 | 9.1 | 9.4 | 9.7 | 10 | 10.3 | 10.6 | 10.9 | 11.2 | 11.5 | 11.8 | 12.1 | 12.4 | 12.7 | 13 | 13.3 | 13.6 | 13.9 | 14.2 | 14.5 | 14.8 | 15.1 | 15.4 | 15.7 | 16 | 16.3 | 16.6 | 16.9 | 17.2 | 17.5 | 17.8 | 18.1 | 18.4 | 18.7 | 19
 |  |  |  |  | 1 | 2 | 2 | 2 | 2.5 | 2.8 | 3.1 | 3.4 | 3.7 | 4 | 4.3 | 4.6 | 4.9 | 5.2 | 5.5 | 5.8 | 6.1 | 6.4 | 6.7 | 7 | 7.3 | 7.6 | 7.9 | 8.2 | 8.5 | 8.8 | 9.1 | 9.4 | 9.7 | 10 | 10.3 | 10.6 | 10.9 | 11.2 | 11.5 | 11.8 | 12.1 | 12.4 | 12.7 | 13 | 13.3 | 13.6 | 13.9 | 14.2 | 14.5 | 14.8 | 15.1 | 15.4 | 15.7 | 16 | 16.3 | 16.6 | 16.9 | 17.2 | 17.5 | 17.8 | 18.1 | 18.4 | 18.7 | 19
 |  |  |  |  | 1 | 2 | 2 | 2 | 2.5 | 2.8 | 3.1 | 3.4 | 3.7 | 4 | 4.3 | 4.6 | 4.9 | 5.2 | 5.5 | 5.8 | 6.1 | 6.4 | 6.7 | 7 | 7.3 | 7.6 | 7.9 | 8.2 | 8.5 | 8.8 | 9.1 | 9.4 | 9.7 | 10 | 10.3 | 10.6 | 10.9 | 11.2 | 11.5 | 11.8 | 12.1 | 12.4 | 12.7 | 13 | 13.3 | 13.6 | 13.9 | 14.2 | 14.5 | 14.8 | 15.1 | 15.4 | 15.7 | 16 | 16.3 | 16.6 | 16.9 | 17.2 | 17.5 | 17.8 | 18.1 | 18.4 | 18.7 | 19
 |  |  |  |  | 1 | 2 | 2 | 2 | 2.5 | 2.8 | 3.1 | 3.4 | 3.7 | 4 | 4.3 | 4.6 | 4.9 | 5.2 | 5.5 | 5.8 | 6.1 | 6.4 | 6.7 | 7 | 7.3 | 7.6 | 7.9 | 8.2 | 8.5 | 8.8 | 9.1 | 9.4 | 9.7 | 10 | 10.3 | 10.6 | 10.9 | 11.2 | 11.5 | 11.8 | 12.1 | 12.4 | 12.7 | 13 | 13.3 | 13.6 | 13.9 | 14.2 | 14.5 | 14.8 | 15.1 | 15.4 | 15.7 | 16 | 16.3 | 16.6 | 16.9 | 17.2 | 17.5 | 17.8 | 18.1 | 18.4 | 18.7 | 19
 |  |  |  |  | 1 | 2 | 2 | 2 | 2.5 | 2.8 | 3.1 | 3.4 | 3.7 | 4 | 4.3 | 4.6 | 4.9 | 5.2 | 5.5 | 5.8 | 6.1 | 6.4 | 6.7 | 7 | 7.3 | 7.6 | 7.9 | 8.2 | 8.5 | 8.8 | 9.1 | 9.4 | 9.7 | 10 | 10.3 | 10.6 | 10.9 | 11.2 | 11.5 | 11.8 | 12.1 | 12.4 | 12.7 | 13 | 13.3 | 13.6 | 13.9 | 14.2 | 14.5 | 14.8 | 15.1 | 15.4 | 15.7 | 16 | 16.3 | 16.6 | 16.9 | 17.2 | 17.5 | 17.8 | 18.1 | 18.4 | 18.7 | 19
 |  |  |  |  | 1 | 2 | 2 | 0 | 0 | 0 | 3.1 | 3.4 | 3.7 | 4 | 4.3 | 4.6 | 4.9 | 5.2 | 5.5 | 5.8 | 6.1 | 6.4 | 6.7 | 7 | 7.3 | 7.6 | 7.9 | 8.2 | 8.5 | 8.8 | 9.1 | 9.4 | 9.7 | 10 | 10.3 | 10.6 | 10.9 | 11.2 | 11.5 | 11.8 | 12.1 | 12.4 | 12.7 | 13 | 13.3 | 13.6 | 13.9 | 14.2 | 14.5 | 14.8 | 15.1 | 15.4 | 15.7 | 16 | 16.3 | 16.6 | 16.9 | 17.2 | 17.5 | 17.8 | 18.1 | 18.4 | 18.7 | 19
 |  |  |  |  | 1 | 2 | 2 | 2 | 2.5 | 2.8 | 3.1 | 3.4 | 3.7 | 4 | 4.3 | 4.6 | 4.9 | 5.2 | 5.5 | 5.8 | 6.1 | 6.4 | 6.7 | 7 | 7.3 | 7.6 | 7.9 | 8.2 | 8.5 | 8.8 | 9.1 | 9.4 | 9.7 | 10 | 10.3 | 10.6 | 10.9 | 11.2 | 11.5 | 11.8 | 12.1 | 12.4 | 12.7 | 13 | 13.3 | 13.6 | 13.9 | 14.2 | 14.5 | 14.8 | 15.1 | 15.4 | 15.7 | 16 | 16.3 | 16.6 | 16.9 | 17.2 | 17.5 | 17.8 | 18.1 | 18.4 | 18.7 | 19