{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Form1ClaimSubmission","Sheet2","Sheet4","AbbreviationList","ErrorList","Claim Summary","Validation List","DDLDetail"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Form1ClaimSubmission","index":0,"n_rows":5,"n_cols":101,"rows_kept":5,"cut":false,"hidden":false,"merged":[[2,80,2,82],[0,1,0,4],[2,63,2,79],[2,61,2,62],[1,5,1,6],[1,3,1,4],[1,1,1,2]]}
[null,"Details of the loan sanctioned and disbursed, in respect of which subsidy is being claimed under Rural Housing Interest Subsidy Scheme, Ministry of Rural Development, Government of India",null,null,null,"Validation Pending"]
["RHISS Version ",null,null,"PLI CODE - \nPLI NAME - ",null,"Processing Row-0/0",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PQRS1001","Dummy Institution"]
["I. Serial No.",null,null,"II. Borrower Details",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"III. Co-borrower Details",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"III. Household Detail","IV. Property Detail",null,null,null,null,null,null,null,null,null,null,null,null,null,"V. Loan Detail"]
["Serial Number","Loan Account Number (To be unique within a PLI)","Disbursement Installment No [Single Installment (0), Multiple Installments (Respective Number)]","Name of the  Borrower","Unique Identification Proof [Aadhaar (01), Voter’s Card (02), PAN Card (03), Passport No (04), Revenue Authority Certificate (05), Any other Govt. approved ID (06)] ","If any other Govt. approved ID (06)- Please specify(Identification proof Type)","Unique Identification Number","Sex [Male (01), Female (02), Transgender (03)]","Date of Birth [DD/MM/YYYY]","Employment Category [Farmer (01), Farm Labourer (02) Self Employed (03), Salaried (04), Others (05)]","NREGA Job Card number","SECC Tin number","Aadhaar card number","PAN Card Number","Residence Address 1 (Plot/House/Flat/Door No. & Street, Locality/Colony name, Village/Taluk)","Residence Address 2 (District)","Residence Address 3 (State)","Residence Address 4 (Pincode)","Mobile Number","Category Caste* [General(01), SC (02), ST (03), OBC (04)]","Religion* [Whether belong to Hindu (01), Muslim (02), Christian (03), Sikh (04), Jainism (05), Buddhism (06), Zorastrianism(07), Others (08)]","If a minority in the state for where claim is made  [Yes(01), No(02)]","With any disability or not able bodied [Yes(01), No(02)]","Name of Co-borrower","Unique Identification Proof [Aadhaar (01), Voter’s Card (02), PAN Card (03), Passport No (04), Revenue Authority Certificate (05), Any other Govt. approved ID (06)] ","If any other Govt. approved ID (06) - Please specify(Identification proof Type)","Unique Identification Number","Sex [Male (01), Female (02), Transgender (03)]","Date of Birth [DD/MM/YYYY]","Employment Category [Farmer (01), Farm Labourer (02) Self Employed (03), Salaried (04), Others (05)]","NREGA Job Card number","SECC Tin number","Aadhaar card number","PAN Card Number","Residence Address 1 (Plot/House/Flat/Door No. & Street, Locality/Colony name, Village/Taluk)","Residence Address 2 (District)","Residence Address 3 (State)","Residence Address 4 (Pincode)","Mobile Number","Category Caste* [General(01), SC (02), ST (03), OBC (04)]","Religion* [Whether belong to Hindu (01), Muslim (02), Christian (03), Sikh (04), Jainism (05), Buddhism (06), Zorastrianism(07), Others (08)]","If a minority in the state for where claim is made  [Yes(01), No(02)]","With any disability or not able bodied [Yes(01), No(02)]","Household Annual Income (Amount in Rs.)","Property Type [Pucca House (01)]","Number of rooms in house [01,02,03…the exact number of rooms]","Property Category [New(01), Existing & Owned (02)]","Property Address 1 (Plot/House/Flat/Door No. & Street, etc.)","Property Address 2 (Locality / Colony Name)","Property Address 3 [Name of the Place (Village/Taluk)]","Property Address 4 (Pincode)","Location Code","Village code matches with code uploaded on website                           (Yes)","Property Address  (District) (Based on  the Abbreviation List enter the district )","Property Address 5 (State) (No entry required)","Stage of Construction [ Yet to Start (00), Foundation(01), Plinth (02), Windowsill (03), Lintel (04), Roofcast (05), Completed(06)]","Loan Purpose [Construction (01), Modification (02)]","Is the loan taken over or  Balance Transferred from another PLI  [Yes(01), No(02)]","Loan Amount Sanctioned (in Rs.)","Loan Sanction Date","Loan Interest Rate (% p.a.)","Loan Tenure, including Moratorium Period (in months)","Loan Moratorium Period (in months), if any","Repayment Start Date of Principal or EMI [DD/MM/YYYY]","EMI Amount mentioned in Sanction Letter (in Rs.)","Date of First Disbursement Date [DD/MM/YYYY]","Current Loan Instalment Disbursement Date for which subsidy claimed [DD/MM/YYYY]","Loan Amount Disbursed for this Claim (in Rs.)","Cumulative Loan Disbursement (excluding the disbursement made for the current subsidy claim)  (in Rs.)","NPV of the Interest Subsidy Amount (in Rs.)","Interest Subsidy Amount Claimed (in Rs.)","Number of Dependents","Name of Dependent 1","Unique Identification Proof [Aadhaar (01), Voter’s Card (02), PAN Card (03), Passport No (04), Revenue Authority Certificate (05), Any other Govt. approved ID (06)] ","If any other Govt. approved ID (06)- Please specify(Identification proof Type)","Unique Identification Number","Name of Dependent 2","Unique Identification Proof [Aadhaar (01), Voter’s Card (02), PAN Card (03), Passport No (04), Revenue Authority Certificate (05), Any other Govt. approved ID (06)] ","If any other Govt. approved ID (06)- Please specify(Identification proof Type)","Unique Identification Number","Name of Dependent 3","Unique Identification Proof [Aadhaar (01), Voter’s Card (02), PAN Card (03), Passport No (04), Revenue Authority Certificate (05), Any other Govt. approved ID (06)] ","If any other Govt. approved ID (06)- Please specify(Identification proof Type)","Unique Identification Number","Name of Dependent 4","Unique Identification Proof [Aadhaar (01), Voter’s Card (02), PAN Card (03), Passport No (04), Revenue Authority Certificate (05), Any other Govt. approved ID (06)] ","If any other Govt. approved ID (06)- Please specify(Identification proof Type)","Unique Identification Number","Structural Safety  [Yes(01), No (02)]","Normal House Life Expectancy (in years)","Water Supply (Yes (01))","Electicity Supply (Yes (01))","Sanitation (Yes (01))","Gas Supply (Yes (01))","Remarks","Borrower DOB","Co-Borrower Dob","Loan Sanction Date","Repayment Date","First Disbursement Date","Loan Disbursement Date"]
[1,2,3,4,5,6,7,8,"1900-01-09",10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,"1900-01-29",30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,"1900-03-04",65,"1900-03-06","1900-03-07",68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95]

{"sheet":"Sheet2","index":1,"n_rows":3000,"n_cols":29,"rows_kept":3000,"cut":false,"hidden":false,"merged":[]}
["Please Enable Your Macro Setting To  work with Data Sheet.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DD Created"]
[]
[]
[]
["Invalid"]
["Invalid"]
["Invalid"]
["Invalid"]
["1.2","RHISS","RHISS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["SecondTime"]
[]
[]
[]
[]
[]
[]
[]
["SecondTime"]

{"sheet":"Sheet4","index":2,"n_rows":9,"n_cols":41,"rows_kept":9,"cut":false,"hidden":true,"merged":[[5,34,6,35],[5,36,6,37],[4,20,6,21],[6,23,6,24],[5,28,5,31],[5,33,6,33],[4,22,4,40],[5,38,6,40],[6,14,6,17],[5,25,5,27],[5,22,5,24],[5,10,5,13],[5,14,5,17],[6,10,6,11],[3,1,3,5],[4,2,4,4],[6,1,6,4],[5,2,5,4],[6,12,6,13],[4,10,4,19],[6,6,6,9],[5,6,5,9],[3,6,3,16]]}
[]
[]
[]
[null,null,null,null,null,null,"Validation Pending"]
[null,"District",null,null,null,null,null,null,null,null,"Existing Infrastructure",null,null,null,null,null,null,null,null,null,"Already sanctioned and under execution in RGGVY/State/other schemes",null,"3KVA"]
[null,"Block",null,null,null,null,"Coverage of HouseHold",null,null,null,"Existing LT Networks (in Kms)",null,null,null,"Existing Distribution Transformers (DT)",null,null,null,null,null,null,null,"New 11KV Line(From nearest Power Station)",null,null,"Capacity Augmntatiom of DTR",null,null,"Renovaton of DTS Sub Stations",null,null,null,"Renovation of DrthingTR Sub Station E","Bay","Conversion of LT Line to LT Line",null,"New LT Line",null,"Conversion of LT Line to 11KV(HVDS)"]
[null,"Village Details",null,null,null,"Habitation Details","Rural Households",null,null,null,"1-PH",null,"3-PH",null,"KVA",null,null,null,null,null,null,null,"Line","New DTR",null,"16-25KVA","25-63KVA","63-100KVA","16KVA","25KVA","63KVA","100KVA"]
[null,"SlNO","Village","Census Code","Main Habitation of Village (Yes/No)","Habitation Name","Total No.of RHhs in Habitation","No of Rhs Electrified as on date","No of RHhs proposed to be electrified ","BPL Hhs proposed to be electrified under present scheme","OverHead","AB Cable","OverHead","AB Cable","Capacity","Nos","Capacity","Nos","Existing Connected Load(in KW)","Spare DT capacity(in KVA)","Total No of Rhhs","Total no of BPL Hhs","11KV Weasel Conductor Length(Kms)","Type","Nos","Nos","Nos","Nos","Nos","Nos","Nos","Nos","Nos","Nos","Type","Length","Type","Length","11KV Weasel Conductor Length(Kms)","DTR Type","Nos"]
[null,"Total"]

{"sheet":"AbbreviationList","index":3,"n_rows":671,"n_cols":8,"rows_kept":671,"cut":false,"hidden":false,"merged":[]}
[]
["State/ UT","Abbreviation",null,null,"State Code","State Name","Dist Code","District Name"]
["Andaman and Nicobar Islands","AN",null,null,"1","JAMMU AND KASHMIR","1","ANANTNAG"]
["Andhra Pradesh","AP",null,null,"1","JAMMU AND KASHMIR","2","BADGAM"]
["Arunachal Pradesh","AR",null,null,"1","JAMMU AND KASHMIR","3","BARAMULLA"]
["Assam","AS",null,null,"1","JAMMU AND KASHMIR","4","DODA"]
["Bihar","BR",null,null,"1","JAMMU AND KASHMIR","5","JAMMU"]
["Chhattisgarh","CG",null,null,"1","JAMMU AND KASHMIR","6","KARGIL"]
["Dadra and Nagar Haveli","DN",null,null,"1","JAMMU AND KASHMIR","7","KATHUA"]
["Goa","GA",null,null,"1","JAMMU AND KASHMIR","8","KUPWARA"]
["Gujarat","GJ",null,null,"1","JAMMU AND KASHMIR","9","LEH (LADAKH)"]
["Haryana","HR",null,null,"1","JAMMU AND KASHMIR","10","POONCH"]
["Himachal Pradesh","HP",null,null,"1","JAMMU AND KASHMIR","11","PULWAMA"]
["Jammu and Kashmir","JK",null,null,"1","JAMMU AND KASHMIR","12","RAJAURI"]
["Jharkhand","JH",null,null,"1","JAMMU AND KASHMIR","13","SRINAGAR"]
["Karnataka","KA",null,null,"1","JAMMU AND KASHMIR","14","UDHAMPUR"]
["Kerala","KL",null,null,"1","JAMMU AND KASHMIR","620","KISHTWAR"]
["Lakshadweep","LD",null,null,"1","JAMMU AND KASHMIR","621","RAMBAN"]
["Madhya Pradesh","MP",null,null,"1","JAMMU AND KASHMIR","622","KULGAM"]
["Maharashtra","MH",null,null,"1","JAMMU AND KASHMIR","623","BANDIPORA"]
["Manipur","MN",null,null,"1","JAMMU AND KASHMIR","624","SAMBA"]
["Mizoram","MZ",null,null,"1","JAMMU AND KASHMIR","625","SHOPIAN"]
["Nagaland","NL",null,null,"1","JAMMU AND KASHMIR","626","GANDERBAL"]
["Odisha","OD",null,null,"1","JAMMU AND KASHMIR","627","REASI"]
["Punjab","PB",null,null,"2","HIMACHAL PRADESH","15","BILASPUR"]
["Rajasthan","RJ",null,null,"2","HIMACHAL PRADESH","16","CHAMBA"]
["Sikkim","SK",null,null,"2","HIMACHAL PRADESH","17","HAMIRPUR"]
["Tamil Nadu","TN",null,null,"2","HIMACHAL PRADESH","18","KANGRA"]
["Telangana","TS",null,null,"2","HIMACHAL PRADESH","19","KINNAUR"]
["Tripura","TR",null,null,"2","HIMACHAL PRADESH","20","KULLU"]
["Uttar Pradesh","UP",null,null,"2","HIMACHAL PRADESH","21","LAHUL AND SPITI"]
["Uttarakhand","UK",null,null,"2","HIMACHAL PRADESH","22","MANDI"]
["West Bengal","WB",null,null,"2","HIMACHAL PRADESH","23","SHIMLA"]
[null,null,null,null,"2","HIMACHAL PRADESH","24","SIRMAUR"]
[null,null,null,null,"2","HIMACHAL PRADESH","25","SOLAN"]
[null,null,null,null,"2","HIMACHAL PRADESH","26","UNA"]
[null,null,null,null,"3","PUNJAB","27","AMRITSAR"]
[null,null,null,null,"3","PUNJAB","28","BATHINDA"]
[null,null,null,null,"3","PUNJAB","29","FARIDKOT"]
[null,null,null,null,"3","PUNJAB","30","FATEHGARH SAHIB"]
[null,null,null,null,"3","PUNJAB","31","FIROZEPUR"]
[null,null,null,null,"3","PUNJAB","32","GURDASPUR"]
[null,null,null,null,"3","PUNJAB","33","HOSHIARPUR"]
[null,null,null,null,"3","PUNJAB","34","JALANDHAR"]
[null,null,null,null,"3","PUNJAB","35","KAPURTHALA"]
[null,null,null,null,"3","PUNJAB","36","LUDHIANA"]
[null,null,null,null,"3","PUNJAB","37","MANSA"]
[null,null,null,null,"3","PUNJAB","38","MOGA"]
[null,null,null,null,"3","PUNJAB","39","MUKTSAR"]
[null,null,null,null,"3","PUNJAB","40","NAWANSHAHR"]
[null,null,null,null,"3","PUNJAB","41","PATIALA"]
[null,null,null,null,"3","PUNJAB","42","RUPNAGAR"]
[null,null,null,null,"3","PUNJAB","43","SANGRUR"]
[null,null,null,null,"3","PUNJAB","605","BARNALA"]
[null,null,null,null,"3","PUNJAB","608","SAS NAGAR"]
[null,null,null,null,"3","PUNJAB","609","TARAN TARAN"]
[null,null,null,null,"3","PUNJAB","651","FAZILKA"]
[null,null,null,null,"3","PUNJAB","662","PATHANKOT"]
[null,null,null,null,"5","UTTARAKHAND","45","ALMORA"]
[null,null,null,null,"5","UTTARAKHAND","46","BAGESHWAR"]
[null,null,null,null,"5","UTTARAKHAND","47","CHAMOLI"]
[null,null,null,null,"5","UTTARAKHAND","48","CHAMPAWAT"]
[null,null,null,null,"5","UTTARAKHAND","49","DEHRADUN"]
[null,null,null,null,"5","UTTARAKHAND","50","HARIDWAR"]
[null,null,null,null,"5","UTTARAKHAND","51","NAINITAL"]
[null,null,null,null,"5","UTTARAKHAND","52","PAURI GARHWAL"]
[null,null,null,null,"5","UTTARAKHAND","53","PITHORAGARH"]
[null,null,null,null,"5","UTTARAKHAND","54","RUDRA PRAYAG"]
[null,null,null,null,"5","UTTARAKHAND","55","TEHRI GARHWAL"]
[null,null,null,null,"5","UTTARAKHAND","56","UDAM SINGH NAGAR"]
[null,null,null,null,"5","UTTARAKHAND","57","UTTAR KASHI"]
[null,null,null,null,"6","HARYANA","58","AMBALA"]
[null,null,null,null,"6","HARYANA","59","BHIWANI"]
[null,null,null,null,"6","HARYANA","60","FARIDABAD"]
[null,null,null,null,"6","HARYANA","61","FATEHABAD"]
[null,null,null,null,"6","HARYANA","62","GURGAON"]
[null,null,null,null,"6","HARYANA","63","HISAR"]
[null,null,null,null,"6","HARYANA","64","JHAJJAR"]
[null,null,null,null,"6","HARYANA","65","JIND"]
[null,null,null,null,"6","HARYANA","66","KAITHAL"]
[null,null,null,null,"6","HARYANA","67","KARNAL"]
[null,null,null,null,"6","HARYANA","68","KURUKSHETRA"]
[null,null,null,null,"6","HARYANA","69","MAHENDRAGARH"]
[null,null,null,null,"6","HARYANA","70","PANCHKULA"]
[null,null,null,null,"6","HARYANA","71","PANIPAT"]
[null,null,null,null,"6","HARYANA","72","REWARI"]
[null,null,null,null,"6","HARYANA","73","ROHTAK"]
[null,null,null,null,"6","HARYANA","74","SIRSA"]
[null,null,null,null,"6","HARYANA","75","SONIPAT"]
[null,null,null,null,"6","HARYANA","76","YAMUNANAGAR"]
[null,null,null,null,"6","HARYANA","604","MEWAT"]
[null,null,null,null,"6","HARYANA","619","PALWAL"]
[null,null,null,null,"6","HARYANA","701","CHARKI DADRI"]
[null,null,null,null,"8","RAJASTHAN","629","PRATAPGARH"]
[null,null,null,null,"8","RAJASTHAN","86","AJMER"]
[null,null,null,null,"8","RAJASTHAN","87","ALWAR"]
[null,null,null,null,"8","RAJASTHAN","88","BANSWARA"]
[null,null,null,null,"8","RAJASTHAN","89","BARAN"]
[null,null,null,null,"8","RAJASTHAN","90","BARMER"]
[null,null,null,null,"8","RAJASTHAN","91","BHARATPUR"]
[null,null,null,null,"8","RAJASTHAN","92","BHILWARA"]
[null,null,null,null,"8","RAJASTHAN","93","BIKANER"]
[null,null,null,null,"8","RAJASTHAN","94","BUNDI"]
[null,null,null,null,"8","RAJASTHAN","95","CHITTORGARH"]
[null,null,null,null,"8","RAJASTHAN","96","CHURU"]
[null,null,null,null,"8","RAJASTHAN","97","DAUSA"]
[null,null,null,null,"8","RAJASTHAN","98","DHOLPUR"]
[null,null,null,null,"8","RAJASTHAN","99","DUNGARPUR"]
[null,null,null,null,"8","RAJASTHAN","100","SRI GANGANAGAR"]
[null,null,null,null,"8","RAJASTHAN","101","HANUMANGARH"]
[null,null,null,null,"8","RAJASTHAN","102","JAIPUR"]
[null,null,null,null,"8","RAJASTHAN","103","JAISALMER"]
[null,null,null,null,"8","RAJASTHAN","104","JALORE"]
[null,null,null,null,"8","RAJASTHAN","105","JHALAWAR"]
[null,null,null,null,"8","RAJASTHAN","106","JHUNJHUNU"]
[null,null,null,null,"8","RAJASTHAN","107","JODHPUR"]
[null,null,null,null,"8","RAJASTHAN","108","KARAULI"]
[null,null,null,null,"8","RAJASTHAN","109","KOTA"]
[null,null,null,null,"8","RAJASTHAN","110","NAGAUR"]
[null,null,null,null,"8","RAJASTHAN","111","PALI"]
[null,null,null,null,"8","RAJASTHAN","112","RAJSAMAND"]
[null,null,null,null,"8","RAJASTHAN","113","SAWAI MADHOPUR"]
[null,null,null,null,"8","RAJASTHAN","114","SIKAR"]
[null,null,null,null,"8","RAJASTHAN","115","SIROHI"]
[null,null,null,null,"8","RAJASTHAN","116","TONK"]
[null,null,null,null,"8","RAJASTHAN","117","UDAIPUR"]
[null,null,null,null,"9","UTTAR PRADESH","118","AGRA"]
[null,null,null,null,"9","UTTAR PRADESH","119","ALIGARH"]
[null,null,null,null,"9","UTTAR PRADESH","120","ALLAHABAD"]
[null,null,null,null,"9","UTTAR PRADESH","121","AMBEDKAR NAGAR"]
[null,null,null,null,"9","UTTAR PRADESH","122","AURAIYA"]
[null,null,null,null,"9","UTTAR PRADESH","123","AZAMGARH"]
[null,null,null,null,"9","UTTAR PRADESH","124","BAGHPAT"]
[null,null,null,null,"9","UTTAR PRADESH","125","BAHRAICH"]
[null,null,null,null,"9","UTTAR PRADESH","126","BALLIA"]
[null,null,null,null,"9","UTTAR PRADESH","127","BALRAMPUR"]
[null,null,null,null,"9","UTTAR PRADESH","128","BANDA"]
[null,null,null,null,"9","UTTAR PRADESH","129","BARABANKI"]
[null,null,null,null,"9","UTTAR PRADESH","130","BAREILLY"]
[null,null,null,null,"9","UTTAR PRADESH","131","BASTI"]
[null,null,null,null,"9","UTTAR PRADESH","132","BIJNOR"]
[null,null,null,null,"9","UTTAR PRADESH","133","BUDAUN"]
[null,null,null,null,"9","UTTAR PRADESH","134","BULANDSHAHR"]
[null,null,null,null,"9","UTTAR PRADESH","135","CHANDAULI"]
[null,null,null,null,"9","UTTAR PRADESH","136","CHITRAKOOT"]
[null,null,null,null,"9","UTTAR PRADESH","137","DEORIA"]
[null,null,null,null,"9","UTTAR PRADESH","138","ETAH"]
[null,null,null,null,"9","UTTAR PRADESH","139","ETAWAH"]
[null,null,null,null,"9","UTTAR PRADESH","140","FAIZABAD"]
[null,null,null,null,"9","UTTAR PRADESH","141","FARRUKHABAD"]
[null,null,null,null,"9","UTTAR PRADESH","142","FATEHPUR"]
[null,null,null,null,"9","UTTAR PRADESH","143","FIROZABAD"]
[null,null,null,null,"9","UTTAR PRADESH","144","GAUTAM BUDDHA NAGAR"]
[null,null,null,null,"9","UTTAR PRADESH","145","GHAZIABAD"]
[null,null,null,null,"9","UTTAR PRADESH","146","GHAZIPUR"]
[null,null,null,null,"9","UTTAR PRADESH","147","GONDA"]
[null,null,null,null,"9","UTTAR PRADESH","148","GORAKHPUR"]
[null,null,null,null,"9","UTTAR PRADESH","149","HAMIRPUR"]
[null,null,null,null,"9","UTTAR PRADESH","150","HARDOI"]
[null,null,null,null,"9","UTTAR PRADESH","151","JALAUN"]
[null,null,null,null,"9","UTTAR PRADESH","152","JAUNPUR"]
[null,null,null,null,"9","UTTAR PRADESH","153","JHANSI"]
[null,null,null,null,"9","UTTAR PRADESH","154","JYOTIBA PHOOLE NAGAR"]
[null,null,null,null,"9","UTTAR PRADESH","155","KANNAUJ"]
[null,null,null,null,"9","UTTAR PRADESH","156","KANPUR DEHAT"]
[null,null,null,null,"9","UTTAR PRADESH","157","KANPUR NAGAR"]
[null,null,null,null,"9","UTTAR PRADESH","158","KAUSHAMBI"]
[null,null,null,null,"9","UTTAR PRADESH","159","KHERI"]
[null,null,null,null,"9","UTTAR PRADESH","160","KUSHI NAGAR"]
[null,null,null,null,"9","UTTAR PRADESH","161","LALITPUR"]
[null,null,null,null,"9","UTTAR PRADESH","162","LUCKNOW"]
[null,null,null,null,"9","UTTAR PRADESH","163","MAHAMAYA NAGAR"]
[null,null,null,null,"9","UTTAR PRADESH","164","MAHARAJGANJ"]
[null,null,null,null,"9","UTTAR PRADESH","165","MAHOBA"]
[null,null,null,null,"9","UTTAR PRADESH","166","MAINPURI"]
[null,null,null,null,"9","UTTAR PRADESH","167","MATHURA"]
[null,null,null,null,"9","UTTAR PRADESH","168","MAU"]
[null,null,null,null,"9","UTTAR PRADESH","169","MEERUT"]
[null,null,null,null,"9","UTTAR PRADESH","170","MIRZAPUR"]
[null,null,null,null,"9","UTTAR PRADESH","171","MORADABAD"]
[null,null,null,null,"9","UTTAR PRADESH","172","MUZAFFARNAGAR"]
[null,null,null,null,"9","UTTAR PRADESH","173","PILIBHIT"]
[null,null,null,null,"9","UTTAR PRADESH","174","PRATAPGARH"]
[null,null,null,null,"9","UTTAR PRADESH","175","RAE BARELI"]
[null,null,null,null,"9","UTTAR PRADESH","176","RAMPUR"]
[null,null,null,null,"9","UTTAR PRADESH","177","SAHARANPUR"]
[null,null,null,null,"9","UTTAR PRADESH","178","SANT KABEER NAGAR"]
[null,null,null,null,"9","UTTAR PRADESH","179","SANT RAVIDAS NAGAR"]
[null,null,null,null,"9","UTTAR PRADESH","180","SHAHJAHANPUR"]
[null,null,null,null,"9","UTTAR PRADESH","181","SHRAVASTI"]
[null,null,null,null,"9","UTTAR PRADESH","182","SIDDHARTH NAGAR"]
[null,null,null,null,"9","UTTAR PRADESH","183","SITAPUR"]
[null,null,null,null,"9","UTTAR PRADESH","184","SONBHADRA"]
[null,null,null,null,"9","UTTAR PRADESH","185","SULTANPUR"]
[null,null,null,null,"9","UTTAR PRADESH","186","UNNAO"]
[null,null,null,null,"9","UTTAR PRADESH","187","VARANASI"]
[null,null,null,null,"9","UTTAR PRADESH","633","KASHIRAM NAGAR"]
[null,null,null,null,"9","UTTAR PRADESH","640","CHATRAPATI SAHU JI MAHARAJ NAGAR"]
[null,null,null,null,"9","UTTAR PRADESH","659","SAMBHAL"]
[null,null,null,null,"9","UTTAR PRADESH","660","SHAMLI"]
[null,null,null,null,"9","UTTAR PRADESH","661","HAPUR"]
[null,null,null,null,"10","BIHAR","611","ARWAL"]
[null,null,null,null,"10","BIHAR","188","ARARIA"]
[null,null,null,null,"10","BIHAR","189","AURANAGABAD"]
[null,null,null,null,"10","BIHAR","190","BANKA"]
[null,null,null,null,"10","BIHAR","191","BEGUSARAI"]
[null,null,null,null,"10","BIHAR","192","BHAGALPUR"]
[null,null,null,null,"10","BIHAR","193","BHOJPUR"]
[null,null,null,null,"10","BIHAR","194","BUXAR"]
[null,null,null,null,"10","BIHAR","195","DARBHANGA"]
[null,null,null,null,"10","BIHAR","196","GAYA"]
[null,null,null,null,"10","BIHAR","197","GOPALGANJ"]
[null,null,null,null,"10","BIHAR","198","JAMUI"]
[null,null,null,null,"10","BIHAR","199","JEHANABAD"]
[null,null,null,null,"10","BIHAR","200","KAIMUR (BHABUA)"]
[null,null,null,null,"10","BIHAR","201","KATIHAR"]
[null,null,null,null,"10","BIHAR","202","KHAGARIA"]
[null,null,null,null,"10","BIHAR","203","KISHANGANJ"]
[null,null,null,null,"10","BIHAR","204","LAKHISARAI"]
[null,null,null,null,"10","BIHAR","205","MADHEPURA"]
[null,null,null,null,"10","BIHAR","206","MADHUBANI"]
[null,null,null,null,"10","BIHAR","207","MUNGER"]
[null,null,null,null,"10","BIHAR","208","MUZAFFARPUR"]
[null,null,null,null,"10","BIHAR","209","NALANDA"]
[null,null,null,null,"10","BIHAR","210","NAWADA"]
[null,null,null,null,"10","BIHAR","211","PASHCHIM CHAMPARAN"]
[null,null,null,null,"10","BIHAR","212","PATNA"]
[null,null,null,null,"10","BIHAR","213","PURBI CHAMPARAN"]
[null,null,null,null,"10","BIHAR","214","PURNIA"]
[null,null,null,null,"10","BIHAR","215","ROHTAS"]
[null,null,null,null,"10","BIHAR","216","SAHARSA"]
[null,null,null,null,"10","BIHAR","217","SAMASTIPUR"]
[null,null,null,null,"10","BIHAR","218","SARAN"]
[null,null,null,null,"10","BIHAR","219","SHEIKHPURA"]
[null,null,null,null,"10","BIHAR","220","SHEOHAR"]
[null,null,null,null,"10","BIHAR","221","SITAMARHI"]
[null,null,null,null,"10","BIHAR","222","SIWAN"]
[null,null,null,null,"10","BIHAR","223","SUPAUL"]
[null,null,null,null,"10","BIHAR","224","VAISHALI"]
[null,null,null,null,"11","SIKKIM","225","EAST DISTRICT"]
[null,null,null,null,"11","SIKKIM","226","NORTH DISTRICT"]
[null,null,null,null,"11","SIKKIM","227","SOUTH DISTRICT"]
[null,null,null,null,"11","SIKKIM","228","WEST DISTRICT"]
[null,null,null,null,"12","ARUNACHAL PRADESH","229","CHANGLANG"]
[null,null,null,null,"12","ARUNACHAL PRADESH","230","UPPER DIBANG VALLEY"]
[null,null,null,null,"12","ARUNACHAL PRADESH","231","EAST KAMENG"]
[null,null,null,null,"12","ARUNACHAL PRADESH","232","EAST SIANG"]
[null,null,null,null,"12","ARUNACHAL PRADESH","233","KURUNG KUMEY"]
[null,null,null,null,"12","ARUNACHAL PRADESH","234","LOHIT"]
[null,null,null,null,"12","ARUNACHAL PRADESH","235","LOWER DIBANG VALLEY"]
[null,null,null,null,"12","ARUNACHAL PRADESH","236","LOWER SUBANSIRI"]
[null,null,null,null,"12","ARUNACHAL PRADESH","237","PAPUM PARE"]
[null,null,null,null,"12","ARUNACHAL PRADESH","238","TAWANG"]
[null,null,null,null,"12","ARUNACHAL PRADESH","239","TIRAP"]
[null,null,null,null,"12","ARUNACHAL PRADESH","240","UPPER SIANG"]
[null,null,null,null,"12","ARUNACHAL PRADESH","241","UPPER SUBANSIRI"]
[null,null,null,null,"12","ARUNACHAL PRADESH","242","WEST KAMENG"]
[null,null,null,null,"12","ARUNACHAL PRADESH","243","WEST SIANG"]
[null,null,null,null,"12","ARUNACHAL PRADESH","628","ANJAW"]
[null,null,null,null,"12","ARUNACHAL PRADESH","666","LONGDING"]
[null,null,null,null,"12","ARUNACHAL PRADESH","677","KRA-DAADI"]
[null,null,null,null,"12","ARUNACHAL PRADESH","678","NAMSAI"]
[null,null,null,null,"12","ARUNACHAL PRADESH","679","SIANG"]
[null,null,null,null,"13","NAGALAND","613","PEREN"]
[null,null,null,null,"13","NAGALAND","614","KIPHIRE"]
[null,null,null,null,"13","NAGALAND","615","LONGLENG"]
[null,null,null,null,"13","NAGALAND","244","DIMAPUR"]
[null,null,null,null,"13","NAGALAND","245","KOHIMA"]
[null,null,null,null,"13","NAGALAND","246","MOKOKCHUNG"]
[null,null,null,null,"13","NAGALAND","247","MON"]
[null,null,null,null,"13","NAGALAND","248","PHEK"]
[null,null,null,null,"13","NAGALAND","249","TUENSANG"]
[null,null,null,null,"13","NAGALAND","250","WOKHA"]
[null,null,null,null,"13","NAGALAND","251","ZUNHEBOTO"]
[null,null,null,null,"14","MANIPUR","252","BISHNUPUR"]
[null,null,null,null,"14","MANIPUR","253","CHANDEL"]
[null,null,null,null,"14","MANIPUR","254","CHURACHANDPUR"]
[null,null,null,null,"14","MANIPUR","255","IMPHAL EAST"]
[null,null,null,null,"14","MANIPUR","256","IMPHAL WEST"]
[null,null,null,null,"14","MANIPUR","257","SENAPATI"]
[null,null,null,null,"14","MANIPUR","258","TAMENGLONG"]
[null,null,null,null,"14","MANIPUR","259","THOUBAL"]
[null,null,null,null,"14","MANIPUR","260","UKHRUL"]
[null,null,null,null,"15","MIZORAM","261","AIZAWL"]
[null,null,null,null,"15","MIZORAM","262","CHAMPHAI"]
[null,null,null,null,"15","MIZORAM","263","KOLASIB"]
[null,null,null,null,"15","MIZORAM","264","LAWNGTLAI"]
[null,null,null,null,"15","MIZORAM","265","LUNGLEI"]
[null,null,null,null,"15","MIZORAM","266","MAMIT"]
[null,null,null,null,"15","MIZORAM","267","SAIHA"]
[null,null,null,null,"15","MIZORAM","268","SERCHHIP"]
[null,null,null,null,"16","TRIPURA","269","DHALAI"]
[null,null,null,null,"16","TRIPURA","270","NORTH TRIPURA"]
[null,null,null,null,"16","TRIPURA","271","SOUTH TRIPURA"]
[null,null,null,null,"16","TRIPURA","272","WEST TRIPURA"]
[null,null,null,null,"16","TRIPURA","652","KHOWAI"]
[null,null,null,null,"16","TRIPURA","653","SEPAHIJALA"]
[null,null,null,null,"16","TRIPURA","654","GOMATI"]
[null,null,null,null,"16","TRIPURA","655","UNAKOTI"]
[null,null,null,null,"18","ASSAM","612","CHIRANG"]
[null,null,null,null,"18","ASSAM","616","BAKSA"]
[null,null,null,null,"18","ASSAM","617","UDALGURI"]
[null,null,null,null,"18","ASSAM","618","KAMRUP (METRO)"]
[null,null,null,null,"18","ASSAM","705","BISWANATH"]
[null,null,null,null,"18","ASSAM","280","BARPETA"]
[null,null,null,null,"18","ASSAM","281","BONGAIGAON"]
[null,null,null,null,"18","ASSAM","282","CACHAR"]
[null,null,null,null,"18","ASSAM","283","DARRANG"]
[null,null,null,null,"18","ASSAM","284","DHEMAJI"]
[null,null,null,null,"18","ASSAM","285","DHUBRI"]
[null,null,null,null,"18","ASSAM","286","DIBRUGARH"]
[null,null,null,null,"18","ASSAM","287","GOALPARA"]
[null,null,null,null,"18","ASSAM","288","GOLAGHAT"]
[null,null,null,null,"18","ASSAM","289","HAILAKANDI"]
[null,null,null,null,"18","ASSAM","290","JORHAT"]
[null,null,null,null,"18","ASSAM","291","KAMRUP"]
[null,null,null,null,"18","ASSAM","292","KARBI ANGLONG"]
[null,null,null,null,"18","ASSAM","293","KARIMGANJ"]
[null,null,null,null,"18","ASSAM","294","KOKRAJHAR"]
[null,null,null,null,"18","ASSAM","295","LAKHIMPUR"]
[null,null,null,null,"18","ASSAM","296","MORIGAON"]
[null,null,null,null,"18","ASSAM","297","NAGAON"]
[null,null,null,null,"18","ASSAM","298","NALBARI"]
[null,null,null,null,"18","ASSAM","299","NORTH CACHAR HILLS"]
[null,null,null,null,"18","ASSAM","300","SIVASAGAR"]
[null,null,null,null,"18","ASSAM","301","SONITPUR"]
[null,null,null,null,"18","ASSAM","302","TINSUKIA"]
[null,null,null,null,"19","WEST BENGAL","303","24 PARGANAS (NORTH)"]
[null,null,null,null,"19","WEST BENGAL","304","24 PARGANAS SOUTH"]
[null,null,null,null,"19","WEST BENGAL","305","BANKURA"]
[null,null,null,null,"19","WEST BENGAL","306","PURBA BARDHAMAN"]
[null,null,null,null,"19","WEST BENGAL","307","BIRBHUM"]
[null,null,null,null,"19","WEST BENGAL","308","COOCHBEHAR"]
[null,null,null,null,"19","WEST BENGAL","309","SILIGURI MAHAKUMA PARISAD"]
[null,null,null,null,"19","WEST BENGAL","310","DINAJPUR DAKSHIN"]
[null,null,null,null,"19","WEST BENGAL","311","DINAJPUR UTTAR"]
[null,null,null,null,"19","WEST BENGAL","312","HOOGHLY"]
[null,null,null,null,"19","WEST BENGAL","313","HOWRAH"]
[null,null,null,null,"19","WEST BENGAL","314","JALPAIGURI"]
[null,null,null,null,"19","WEST BENGAL","316","MALDAH"]
[null,null,null,null,"19","WEST BENGAL","317","PURBA MEDINIPUR"]
[null,null,null,null,"19","WEST BENGAL","318","PASCHIM MEDINIPUR"]
[null,null,null,null,"19","WEST BENGAL","319","MURSHIDABAD"]
[null,null,null,null,"19","WEST BENGAL","320","NADIA"]
[null,null,null,null,"19","WEST BENGAL","321","PURULIA"]
[null,null,null,null,"19","WEST BENGAL","702","KALIMPONG"]
[null,null,null,null,"19","WEST BENGAL","703","JHARGRAM"]
[null,null,null,null,"19","WEST BENGAL","704","BARDHAMAN"]
[null,null,null,null,"19","WEST BENGAL","664","ALIPURDUAR"]
[null,null,null,null,"20","JHARKHAND","606","KHUNTI"]
[null,null,null,null,"20","JHARKHAND","607","RAMGARH"]
[null,null,null,null,"20","JHARKHAND","322","BOKARO"]
[null,null,null,null,"20","JHARKHAND","323","CHATRA"]
[null,null,null,null,"20","JHARKHAND","324","DEOGHAR"]
[null,null,null,null,"20","JHARKHAND","325","DHANBAD"]
[null,null,null,null,"20","JHARKHAND","326","DUMKA"]
[null,null,null,null,"20","JHARKHAND","327","EAST SINGHBUM"]
[null,null,null,null,"20","JHARKHAND","328","GARHWA"]
[null,null,null,null,"20","JHARKHAND","329","GIRIDIH"]
[null,null,null,null,"20","JHARKHAND","330","GODDA"]
[null,null,null,null,"20","JHARKHAND","331","GUMLA"]
[null,null,null,null,"20","JHARKHAND","332","HAZARIBAGH"]
[null,null,null,null,"20","JHARKHAND","333","JAMTARA"]
[null,null,null,null,"20","JHARKHAND","334","KODERMA"]
[null,null,null,null,"20","JHARKHAND","335","LATEHAR"]
[null,null,null,null,"20","JHARKHAND","336","LOHARDAGA"]
[null,null,null,null,"20","JHARKHAND","337","PAKUR"]
[null,null,null,null,"20","JHARKHAND","338","PALAMU"]
[null,null,null,null,"20","JHARKHAND","339","RANCHI"]
[null,null,null,null,"20","JHARKHAND","340","SAHEBGANJ"]
[null,null,null,null,"20","JHARKHAND","341","SARAIKELA KHARSAWAN"]
[null,null,null,null,"20","JHARKHAND","342","SIMDEGA"]
[null,null,null,null,"20","JHARKHAND","343","WEST SINGHBHUM"]
[null,null,null,null,"21","ODISHA","344","ANGUL"]
[null,null,null,null,"21","ODISHA","345","BOLANGIR"]
[null,null,null,null,"21","ODISHA","346","BALESHWAR"]
[null,null,null,null,"21","ODISHA","347","BARGARH"]
[null,null,null,null,"21","ODISHA","348","BHADRAK"]
[null,null,null,null,"21","ODISHA","349","BOUDH"]
[null,null,null,null,"21","ODISHA","350","CUTTACK"]
[null,null,null,null,"21","ODISHA","351","DEOGARH"]
[null,null,null,null,"21","ODISHA","352","DHENKANAL"]
[null,null,null,null,"21","ODISHA","353","GAJAPATI"]
[null,null,null,null,"21","ODISHA","354","GANJAM"]
[null,null,null,null,"21","ODISHA","355","JAGATSINGHAPUR"]
[null,null,null,null,"21","ODISHA","356","JAJPUR"]
[null,null,null,null,"21","ODISHA","357","JHARSUGUDA"]
[null,null,null,null,"21","ODISHA","358","KALAHANDI"]
[null,null,null,null,"21","ODISHA","359","KANDHAMAL"]
[null,null,null,null,"21","ODISHA","360","KENDRAPARA"]
[null,null,null,null,"21","ODISHA","361","KENDUJHAR"]
[null,null,null,null,"21","ODISHA","362","KHORDHA"]
[null,null,null,null,"21","ODISHA","363","KORAPUT"]
[null,null,null,null,"21","ODISHA","364","MALKANGIRI"]
[null,null,null,null,"21","ODISHA","365","MAYURBHANJ"]
[null,null,null,null,"21","ODISHA","366","NABARANGAPUR"]
[null,null,null,null,"21","ODISHA","367","NAYAGARH"]
[null,null,null,null,"21","ODISHA","368","NUAPADA"]
[null,null,null,null,"21","ODISHA","369","PURI"]
[null,null,null,null,"21","ODISHA","370","RAYAGADA"]
[null,null,null,null,"21","ODISHA","371","SAMBALPUR"]
[null,null,null,null,"21","ODISHA","372","SONEPUR"]
[null,null,null,null,"21","ODISHA","373","SUNDARGARH"]
[null,null,null,null,"22","CHHATTISGARH","374","BASTAR"]
[null,null,null,null,"22","CHHATTISGARH","375","BILASPUR"]
[null,null,null,null,"22","CHHATTISGARH","376","DANTEWADA"]
[null,null,null,null,"22","CHHATTISGARH","377","DHAMTARI"]
[null,null,null,null,"22","CHHATTISGARH","378","DURG"]
[null,null,null,null,"22","CHHATTISGARH","379","JANJGIR-CHAMPA"]
[null,null,null,null,"22","CHHATTISGARH","380","JASHPUR"]
[null,null,null,null,"22","CHHATTISGARH","381","KANKER"]
[null,null,null,null,"22","CHHATTISGARH","382","KAWARDHA"]
[null,null,null,null,"22","CHHATTISGARH","383","KORBA"]
[null,null,null,null,"22","CHHATTISGARH","384","KOREA"]
[null,null,null,null,"22","CHHATTISGARH","385","MAHASAMUND"]
[null,null,null,null,"22","CHHATTISGARH","386","RAIGARH"]
[null,null,null,null,"22","CHHATTISGARH","387","RAIPUR"]
[null,null,null,null,"22","CHHATTISGARH","388","RAJNANDAGON"]
[null,null,null,null,"22","CHHATTISGARH","389","SURGUJA"]
[null,null,null,null,"22","CHHATTISGARH","642","SUKMA"]
[null,null,null,null,"22","CHHATTISGARH","643","KONDAGAON"]
[null,null,null,null,"22","CHHATTISGARH","644","BALODA BAZAR"]
[null,null,null,null,"22","CHHATTISGARH","645","GARIYABAND"]
[null,null,null,null,"22","CHHATTISGARH","646","BALOD"]
[null,null,null,null,"22","CHHATTISGARH","647","MUNGELI"]
[null,null,null,null,"22","CHHATTISGARH","648","SURAJPUR"]
[null,null,null,null,"22","CHHATTISGARH","649","BALRAMPUR"]
[null,null,null,null,"22","CHHATTISGARH","650","BEMETARA"]
[null,null,null,null,"22","CHHATTISGARH","636","BIJAPUR"]
[null,null,null,null,"22","CHHATTISGARH","637","NARAYANPUR"]
[null,null,null,null,"23","MADHYA PRADESH","638","SINGRAULI"]
[null,null,null,null,"23","MADHYA PRADESH","639","ALIRAJPUR"]
[null,null,null,null,"23","MADHYA PRADESH","667","AGAR-MALWA"]
[null,null,null,null,"23","MADHYA PRADESH","390","ANUPPUR"]
[null,null,null,null,"23","MADHYA PRADESH","391","ASHOK NAGAR"]
[null,null,null,null,"23","MADHYA PRADESH","392","BALAGHAT"]
[null,null,null,null,"23","MADHYA PRADESH","393","BARWANI"]
[null,null,null,null,"23","MADHYA PRADESH","394","BETUL"]
[null,null,null,null,"23","MADHYA PRADESH","395","BHIND"]
[null,null,null,null,"23","MADHYA PRADESH","396","BHOPAL"]
[null,null,null,null,"23","MADHYA PRADESH","397","BURHANPUR"]
[null,null,null,null,"23","MADHYA PRADESH","398","CHHATARPUR"]
[null,null,null,null,"23","MADHYA PRADESH","399","CHHINDWARA"]
[null,null,null,null,"23","MADHYA PRADESH","400","DAMOH"]
[null,null,null,null,"23","MADHYA PRADESH","401","DATIA"]
[null,null,null,null,"23","MADHYA PRADESH","402","DEWAS"]
[null,null,null,null,"23","MADHYA PRADESH","403","DHAR"]
[null,null,null,null,"23","MADHYA PRADESH","404","DINDORI"]
[null,null,null,null,"23","MADHYA PRADESH","405","KHANDWA"]
[null,null,null,null,"23","MADHYA PRADESH","406","GUNA"]
[null,null,null,null,"23","MADHYA PRADESH","407","GWALIOR"]
[null,null,null,null,"23","MADHYA PRADESH","408","HARDA"]
[null,null,null,null,"23","MADHYA PRADESH","409","HOSHANGABAD"]
[null,null,null,null,"23","MADHYA PRADESH","410","INDORE"]
[null,null,null,null,"23","MADHYA PRADESH","411","JABALPUR"]
[null,null,null,null,"23","MADHYA PRADESH","412","JHABUA"]
[null,null,null,null,"23","MADHYA PRADESH","413","KATNI"]
[null,null,null,null,"23","MADHYA PRADESH","414","KHARGONE"]
[null,null,null,null,"23","MADHYA PRADESH","415","MANDLA"]
[null,null,null,null,"23","MADHYA PRADESH","416","MANDSAUR"]
[null,null,null,null,"23","MADHYA PRADESH","417","MORENA"]
[null,null,null,null,"23","MADHYA PRADESH","418","NARSINGHPUR"]
[null,null,null,null,"23","MADHYA PRADESH","419","NEEMUCH"]
[null,null,null,null,"23","MADHYA PRADESH","420","PANNA"]
[null,null,null,null,"23","MADHYA PRADESH","421","RAISEN"]
[null,null,null,null,"23","MADHYA PRADESH","422","RAJGARH"]
[null,null,null,null,"23","MADHYA PRADESH","423","RATLAM"]
[null,null,null,null,"23","MADHYA PRADESH","424","REWA"]
[null,null,null,null,"23","MADHYA PRADESH","425","SAGAR"]
[null,null,null,null,"23","MADHYA PRADESH","426","SATNA"]
[null,null,null,null,"23","MADHYA PRADESH","427","SEHORE"]
[null,null,null,null,"23","MADHYA PRADESH","428","SEONI"]
[null,null,null,null,"23","MADHYA PRADESH","429","SHAHDOL"]
[null,null,null,null,"23","MADHYA PRADESH","430","SHAJAPUR"]
[null,null,null,null,"23","MADHYA PRADESH","431","SHEOPUR"]
[null,null,null,null,"23","MADHYA PRADESH","432","SHIVPURI"]
[null,null,null,null,"23","MADHYA PRADESH","433","SIDHI"]
[null,null,null,null,"23","MADHYA PRADESH","434","TIKAMGARH"]
[null,null,null,null,"23","MADHYA PRADESH","435","UJJAIN"]
[null,null,null,null,"23","MADHYA PRADESH","436","UMARIA"]
[null,null,null,null,"23","MADHYA PRADESH","437","VIDISHA"]
[null,null,null,null,"24","GUJARAT","438","AHMADABAD"]
[null,null,null,null,"24","GUJARAT","439","AMRELI"]
[null,null,null,null,"24","GUJARAT","440","ANAND"]
[null,null,null,null,"24","GUJARAT","441","BANAS KANTHA"]
[null,null,null,null,"24","GUJARAT","442","BHARUCH"]
[null,null,null,null,"24","GUJARAT","443","BHAVNAGAR"]
[null,null,null,null,"24","GUJARAT","444","DANG"]
[null,null,null,null,"24","GUJARAT","445","DOHAD"]
[null,null,null,null,"24","GUJARAT","446","GANDHINAGAR"]
[null,null,null,null,"24","GUJARAT","447","JAMNAGAR"]
[null,null,null,null,"24","GUJARAT","448","JUNAGADH"]
[null,null,null,null,"24","GUJARAT","449","KACHCHH"]
[null,null,null,null,"24","GUJARAT","450","KHEDA"]
[null,null,null,null,"24","GUJARAT","451","MAHESANA"]
[null,null,null,null,"24","GUJARAT","452","NARMADA"]
[null,null,null,null,"24","GUJARAT","453","NAVSARI"]
[null,null,null,null,"24","GUJARAT","454","PANCH MAHALS"]
[null,null,null,null,"24","GUJARAT","455","PATAN"]
[null,null,null,null,"24","GUJARAT","456","PORBANDAR"]
[null,null,null,null,"24","GUJARAT","457","RAJKOT"]
[null,null,null,null,"24","GUJARAT","458","SABAR KANTHA"]
[null,null,null,null,"24","GUJARAT","459","SURAT"]
[null,null,null,null,"24","GUJARAT","460","SURENDRANAGAR"]
[null,null,null,null,"24","GUJARAT","461","VADODARA"]
[null,null,null,null,"24","GUJARAT","462","VALSAD"]
[null,null,null,null,"24","GUJARAT","669","MAHISAGAR"]
[null,null,null,null,"24","GUJARAT","672","ARVALLI"]
[null,null,null,null,"24","GUJARAT","673","MORBI"]
[null,null,null,null,"24","GUJARAT","674","DEVBHUMI DWARKA"]
[null,null,null,null,"24","GUJARAT","675","GIR SOMNATH"]
[null,null,null,null,"24","GUJARAT","641","TAPI"]
[null,null,null,null,"26","DADRA AND NAGAR HAVELI","465","DADRA AND NAGAR HAVELI"]
[null,null,null,null,"27","MAHARASHTRA","466","AHMEDNAGAR"]
[null,null,null,null,"27","MAHARASHTRA","467","AKOLA"]
[null,null,null,null,"27","MAHARASHTRA","468","AMRAVATI"]
[null,null,null,null,"27","MAHARASHTRA","469","AURANGABAD"]
[null,null,null,null,"27","MAHARASHTRA","470","BEED"]
[null,null,null,null,"27","MAHARASHTRA","471","BHANDARA"]
[null,null,null,null,"27","MAHARASHTRA","472","BULDHANA"]
[null,null,null,null,"27","MAHARASHTRA","473","CHANDRAPUR"]
[null,null,null,null,"27","MAHARASHTRA","474","DHULE"]
[null,null,null,null,"27","MAHARASHTRA","475","GADCHIROLI"]
[null,null,null,null,"27","MAHARASHTRA","476","GONDIA"]
[null,null,null,null,"27","MAHARASHTRA","477","HINGOLI"]
[null,null,null,null,"27","MAHARASHTRA","478","JALGAON"]
[null,null,null,null,"27","MAHARASHTRA","479","JALNA"]
[null,null,null,null,"27","MAHARASHTRA","480","KOLHAPUR"]
[null,null,null,null,"27","MAHARASHTRA","481","LATUR"]
[null,null,null,null,"27","MAHARASHTRA","484","NAGPUR"]
[null,null,null,null,"27","MAHARASHTRA","485","NANDED"]
[null,null,null,null,"27","MAHARASHTRA","486","NANDURBAR"]
[null,null,null,null,"27","MAHARASHTRA","487","NASHIK"]
[null,null,null,null,"27","MAHARASHTRA","488","OSMANABAD"]
[null,null,null,null,"27","MAHARASHTRA","489","PARBHANI"]
[null,null,null,null,"27","MAHARASHTRA","490","PUNE"]
[null,null,null,null,"27","MAHARASHTRA","491","RAIGAD"]
[null,null,null,null,"27","MAHARASHTRA","492","RATNAGIRI"]
[null,null,null,null,"27","MAHARASHTRA","493","SANGLI"]
[null,null,null,null,"27","MAHARASHTRA","494","SATARA"]
[null,null,null,null,"27","MAHARASHTRA","495","SINDHUDURG"]
[null,null,null,null,"27","MAHARASHTRA","496","SOLAPUR"]
[null,null,null,null,"27","MAHARASHTRA","497","THANE"]
[null,null,null,null,"27","MAHARASHTRA","498","WARDHA"]
[null,null,null,null,"27","MAHARASHTRA","499","WASHIM"]
[null,null,null,null,"27","MAHARASHTRA","500","YAVATMAL"]
[null,null,null,null,"27","MAHARASHTRA","665","PALGHAR"]
[null,null,null,null,"28","ANDHRA PRADESH","502","ANANTAPUR"]
[null,null,null,null,"28","ANDHRA PRADESH","503","CHITTOOR"]
[null,null,null,null,"28","ANDHRA PRADESH","504","CUDDAPAH"]
[null,null,null,null,"28","ANDHRA PRADESH","505","EAST GODAVARI"]
[null,null,null,null,"28","ANDHRA PRADESH","506","GUNTUR"]
[null,null,null,null,"28","ANDHRA PRADESH","510","KRISHNA"]
[null,null,null,null,"28","ANDHRA PRADESH","511","KURNOOL"]
[null,null,null,null,"28","ANDHRA PRADESH","515","NELLORE"]
[null,null,null,null,"28","ANDHRA PRADESH","517","PRAKASAM"]
[null,null,null,null,"28","ANDHRA PRADESH","519","SRIKAKULAM"]
[null,null,null,null,"28","ANDHRA PRADESH","520","VISAKHAPATANAM"]
[null,null,null,null,"28","ANDHRA PRADESH","521","VIZIANAGARAM"]
[null,null,null,null,"28","ANDHRA PRADESH","523","WEST GODAVARI"]
[null,null,null,null,"29","KARNATAKA","524","BAGALKOT"]
[null,null,null,null,"29","KARNATAKA","525","BENGALURU URBAN"]
[null,null,null,null,"29","KARNATAKA","526","BENGALURU RURAL"]
[null,null,null,null,"29","KARNATAKA","527","BELAGAVI"]
[null,null,null,null,"29","KARNATAKA","528","BALLARI"]
[null,null,null,null,"29","KARNATAKA","529","BIDAR"]
[null,null,null,null,"29","KARNATAKA","530","VIJAYAPURA"]
[null,null,null,null,"29","KARNATAKA","531","CHAMARAJANAGAR"]
[null,null,null,null,"29","KARNATAKA","532","CHIKKAMAGALURU"]
[null,null,null,null,"29","KARNATAKA","533","CHITRADURGA"]
[null,null,null,null,"29","KARNATAKA","534","DAKSHINAKANNADA"]
[null,null,null,null,"29","KARNATAKA","535","DAVANAGERE"]
[null,null,null,null,"29","KARNATAKA","536","DHARWAD"]
[null,null,null,null,"29","KARNATAKA","537","GADAG"]
[null,null,null,null,"29","KARNATAKA","538","KALABURAGI"]
[null,null,null,null,"29","KARNATAKA","539","HASSAN"]
[null,null,null,null,"29","KARNATAKA","540","HAVERI"]
[null,null,null,null,"29","KARNATAKA","541","KODAGU"]
[null,null,null,null,"29","KARNATAKA","542","KOLAR"]
[null,null,null,null,"29","KARNATAKA","543","KOPPAL"]
[null,null,null,null,"29","KARNATAKA","544","MANDYA"]
[null,null,null,null,"29","KARNATAKA","545","MYSURU"]
[null,null,null,null,"29","KARNATAKA","546","RAICHUR"]
[null,null,null,null,"29","KARNATAKA","547","SHIVAMOGGA"]
[null,null,null,null,"29","KARNATAKA","548","TUMAKURU"]
[null,null,null,null,"29","KARNATAKA","549","UDUPI"]
[null,null,null,null,"29","KARNATAKA","550","UTTARAKANNADA"]
[null,null,null,null,"29","KARNATAKA","630","CHIKKABALLAPUR"]
[null,null,null,null,"29","KARNATAKA","631","RAMANAGARA"]
[null,null,null,null,"29","KARNATAKA","635","YADGIRI"]
[null,null,null,null,"30","GOA","551","NORTH GOA"]
[null,null,null,null,"30","GOA","552","SOUTH GOA"]
[null,null,null,null,"31","LAKSHADWEEP","553","LAKSHADWEEP DISTRICT"]
[null,null,null,null,"32","KERALA","554","ALAPPUZHA"]
[null,null,null,null,"32","KERALA","555","ERNAKULAM"]
[null,null,null,null,"32","KERALA","556","IDUKKI"]
[null,null,null,null,"32","KERALA","557","KANNUR"]
[null,null,null,null,"32","KERALA","558","KASARGOD"]
[null,null,null,null,"32","KERALA","559","KOLLAM"]
[null,null,null,null,"32","KERALA","560","KOTTAYAM"]
[null,null,null,null,"32","KERALA","561","KOZHIKODE"]
[null,null,null,null,"32","KERALA","562","MALAPPURAM"]
[null,null,null,null,"32","KERALA","563","PALAKKAD"]
[null,null,null,null,"32","KERALA","564","PATHANAMTHITTA"]
[null,null,null,null,"32","KERALA","565","THIRUVANANTHAPURAM"]
[null,null,null,null,"32","KERALA","566","THRISSUR"]
[null,null,null,null,"32","KERALA","567","WAYANAD"]
[null,null,null,null,"33","TAMIL NADU","569","COIMBATORE"]
[null,null,null,null,"33","TAMIL NADU","570","CUDDALORE"]
[null,null,null,null,"33","TAMIL NADU","571","DHARMAPURI"]
[null,null,null,null,"33","TAMIL NADU","572","DINDIGUL"]
[null,null,null,null,"33","TAMIL NADU","573","ERODE"]
[null,null,null,null,"33","TAMIL NADU","574","KANCHIPURAM"]
[null,null,null,null,"33","TAMIL NADU","575","KANNIYAKUMARI"]
[null,null,null,null,"33","TAMIL NADU","576","KARUR"]
[null,null,null,null,"33","TAMIL NADU","577","KRISHNAGIRI"]
[null,null,null,null,"33","TAMIL NADU","578","MADURAI"]
[null,null,null,null,"33","TAMIL NADU","579","NAGAPATTINAM"]
[null,null,null,null,"33","TAMIL NADU","580","NAMAKKAL"]
[null,null,null,null,"33","TAMIL NADU","581","PERAMBALUR"]
[null,null,null,null,"33","TAMIL NADU","582","PUDUKKOTTAI"]
[null,null,null,null,"33","TAMIL NADU","583","RAMANATHAPURAM"]
[null,null,null,null,"33","TAMIL NADU","584","SALEM"]
[null,null,null,null,"33","TAMIL NADU","585","SIVAGANGAI"]
[null,null,null,null,"33","TAMIL NADU","586","THANJAVUR"]
[null,null,null,null,"33","TAMIL NADU","587","THE NILGIRIS"]
[null,null,null,null,"33","TAMIL NADU","588","THENI"]
[null,null,null,null,"33","TAMIL NADU","589","TIRUVALLUR"]
[null,null,null,null,"33","TAMIL NADU","590","TIRUVARUR"]
[null,null,null,null,"33","TAMIL NADU","591","TIRUCHIRAPPALLI"]
[null,null,null,null,"33","TAMIL NADU","592","TIRUNELVELI"]
[null,null,null,null,"33","TAMIL NADU","593","TIRUVANNAMALAI"]
[null,null,null,null,"33","TAMIL NADU","594","THOOTHUKKUDI"]
[null,null,null,null,"33","TAMIL NADU","595","VELLORE"]
[null,null,null,null,"33","TAMIL NADU","596","VILLUPURAM"]
[null,null,null,null,"33","TAMIL NADU","597","VIRUDHUNAGAR"]
[null,null,null,null,"33","TAMIL NADU","634","TIRUPPUR"]
[null,null,null,null,"33","TAMIL NADU","610","ARIYALUR"]
[null,null,null,null,"35","ANDAMAN AND NICOBAR ISLANDS","632","NORTH AND MIDDLE ANDAMAN"]
[null,null,null,null,"35","ANDAMAN AND NICOBAR ISLANDS","602","SOUTH ANDAMAN"]
[null,null,null,null,"35","ANDAMAN AND NICOBAR ISLANDS","603","NICOBARS"]
[null,null,null,null,"36","TELANGANA","522","WARANGAL"]
[null,null,null,null,"36","TELANGANA","518","RANGAREDDY"]
[null,null,null,null,"36","TELANGANA","516","NIZAMABAD"]
[null,null,null,null,"36","TELANGANA","512","MAHBUBNAGAR"]
[null,null,null,null,"36","TELANGANA","513","MEDAK"]
[null,null,null,null,"36","TELANGANA","514","NALGONDA"]
[null,null,null,null,"36","TELANGANA","508","KARIMNAGAR"]
[null,null,null,null,"36","TELANGANA","509","KHAMMAM"]
[null,null,null,null,"36","TELANGANA","680","NIRMAL"]
[null,null,null,null,"36","TELANGANA","681","JAGTIAL"]
[null,null,null,null,"36","TELANGANA","682","PEDDAPALLI"]
[null,null,null,null,"36","TELANGANA","683","SIRSILLA"]
[null,null,null,null,"36","TELANGANA","684","MANCHERIAL"]
[null,null,null,null,"36","TELANGANA","685","KAMAREDDY"]
[null,null,null,null,"36","TELANGANA","686","WARANGAL (URBAN)"]
[null,null,null,null,"36","TELANGANA","687","JAYASHANKER"]
[null,null,null,null,"36","TELANGANA","688","MAHABUBABAD"]
[null,null,null,null,"36","TELANGANA","689","JANGAON"]
[null,null,null,null,"36","TELANGANA","690","BHADRADRI KOTHAGUDEM"]
[null,null,null,null,"36","TELANGANA","691","SANGAREDDY"]
[null,null,null,null,"36","TELANGANA","692","SIDDIPET"]
[null,null,null,null,"36","TELANGANA","693","WANAPARTHY"]
[null,null,null,null,"36","TELANGANA","694","NAGARKURNOOL"]
[null,null,null,null,"36","TELANGANA","695","JOGULAMBA GADWAL"]
[null,null,null,null,"36","TELANGANA","696","SURYAPET"]
[null,null,null,null,"36","TELANGANA","697","YADADRI"]
[null,null,null,null,"36","TELANGANA","698","RANGAREDDI"]
[null,null,null,null,"36","TELANGANA","699","KUMRAM BHEEM(ASIFABAD)"]
[null,null,null,null,"36","TELANGANA","700","MEDCHAL"]
[null,null,null,null,"36","TELANGANA","501","ADILABAD"]

{"sheet":"ErrorList","index":4,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Cell No","Message"]

{"sheet":"Claim Summary","index":5,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,0,1,1],[0,0,0,1]]}
["PLI CODE - \nPLI NAME - "]
["Claim Summary"]
["Claim Date"]
["First Time Disbursements"]
["Subsequent Disbursements"]
["Loan Disbursed"]
["Interest Subsidy Claimed"]
["Processing Fees Claimed"]
["Amount Requested"]
["Loan Sanctioned Amount"]

{"sheet":"Validation List","index":6,"n_rows":95,"n_cols":4,"rows_kept":95,"cut":false,"hidden":false,"merged":[]}
["I. SN","SlNo",1,"Autofilled"]
[null,"Loan Account Number",2,"1. Should be upto 20 Chars \n2. Should not contain spaces \n3. Can contain special charecters\n4. Should not be blank"]
[null,"Installment No [Single Installment (00), Multiple Installments (Respective Number)]",3,"1. Should not be blank \n2. Should be value between 0 to 9\n3. Should be numeric.                                                                                4. Should not be greater than 9"]
["II. Borrower Details","Name of Borrower",4,"1. Can not be blank \n2. Length should not exceed 80 Chars\n3. For Installment no greater than 1, can  contain text.                                                                              4.For installment No 0 or 1, Borrower Name can not contain spaces at starting or double space and dots.                               5. Length of Borrower can not be less than 3 character\n"]
[null,"Unique Identification Proof [Aadhaar (01), Voter’s Card (02), PAN Card (03), Passport No (04), Revenue Authority Certificate (05) Others (06)] ",5,"1.Value between 01 to 06                                                                         2. Please provide unique Identification Proof"]
[null,"If Others (06)- Please specify(Identification proof Type)",6,"1. Can be filled only 06 Selected in UIType Column\n2. Can contain only text only.\n3. Length of value should be upto 50\n4. In case Instalment No is greater than 1, column should be blank                                                                                                     5. For Installment No 0 or 1, Identification Proof other can not contain spaces at starting or double space and dots\n"]
[null,"Unique Identification No.",7,"1. Can not be blank\n2. UID Type 01: Should be ADHAR No of 12 digit\n3. UID Type 03: Should be PAN No(5 Alpha, 4 Numeric and 1 Alpha – Total 10 Chars)\n3. Max length of value can 20 chars\n4. Only numeric value allowed for UID Proof 01                                                                                      5. Length of UINo should be between 5 to 20 characters.                                                                     6. For Installment No 0 or 1, UINo can not contain spaces at starting or double space and dots"]
[null,"Sex [Male (01), Female (02), Transgender (03)]",8,"1. Instalment No > 1, should be blank\n2. Instalment No 0 or 1 – value 01 to 03\n3. Instalment No 0 or 1- cannot be blank"]
[null,"Date of Birth [DD/MM/YYYY]",9,"1. Instalment No > 1, should be blank\n2. Instalment No 0 or 1 – Date in format dd/mm/yyyy\n3. Age according to DOB should not be below 18 years and more than 100 years on first disbursement\n4. Please enter valid date                                                                         5. For Instalment 0 or 1- should not be blank"]
[null,"Employment Category [Farmer (01), Farm Labourer (02),Self Employed (03), Salaried (04), Other (05)]",10,"1. Instalment No > 1, should be blank\n2. Instalment No 0 or 1 – Should be selected from drop down list\n"]
[null,"NREGA Job card number",11,"1. Instalment No >1 should be blank. 2.Instalment No 0 or 1- should not be blank"]
[null,"SECC TIN number",12,"1. Instalment No >1 should be blank. 2.Instalment No 0 or 1- should not be blank"]
[null,"Aadhar Card",13,"1. Instalment no > 1 should be blank.                 2. Instalment No. 0 or 1- can be blank or should be valid 12 digit aadhar number"]
[null,"PAN Card No.",14,"1. Instalment No > 1, should be blank\n2. Instalment No 0 or 1 – Can be blank or valid PAN No\n3. If value is provided should be in valid 10 digit PAN No format – XXXXX12345X\n4. If UID is PAN and PAN is provided, both should be same\n"]
[null,"Residence Address 1 (Plot/House/Flat/Door No. & Street, Locality/Colony name, Village/Taluk)",15,"1. Instalment No 0 or 1 – Text value in the range of 3 Characters and maximum upto 100 chars \n2. Instalment No > 1   – should be blank\n3.For Instalment No 0 or 1- cannot be blank"]
[null,"Residence Address 2 (District)",16,"1. Instalment No 0 or 1 – Text value in the range of 3 Characters and maximum upto 100 chars \n2. Instalment No > 1,  should be blank\n\n"]
[null,"Residence Address 3 (State)",17,"1. Instalment No 0 or 1 – Text value in the range of 3 Characters and maximum upto 50 chars \n2. Instalment No > 1 , should be blank\n\n"]
[null,"Residence Address 4 (Pincode)",18,"1. Instalment No 0 or 1 – Should be numeric value of 6 length \n2. Instalment No > 1, should be blank"]
[null,"Mobile Number",19,"1. For Installment No is greater than 1, should be blank\n2. If value given, should be  numeric value of 10 length\n3. For Instalment No 0 or 1- should not be blank"]
[null,"Category Caste* [General(01), SC (02), ST (03), OBC (04)]",20,"1. Instalment No 0 or 1 – Should not be blank and selected from drop down list \n2. Instalment No > 1  - Should be blank\n"]
[null,"Religion* [Whether belong to Hindu (01), Muslim (02), Christian (03), Sikh (04), Jainism (05), Buddhism (06), Zorastrianism(07), Others (08)]",21,"1. Instalment No 0 or 1 – Should not be blank and selected from drop down list \n2. Instalment No > 1  - Should be blank\n"]
[null,"If a minority in the state for where claim is made  [Yes(01), No(02)]",22,"1. Instalment No 0 or 1 – Should not be blank and selected from drop down list \n2. Instalment No > 1  - Should be blank\n"]
[null,"With any disability or not able bodied [Yes(01), No(02)]",23,"1. Instalment No 0 or 1 – Should not be blank and selected from drop down list \n2. Instalment No > 1  - Should be blank\n"]
["III. Co-borrower Details ","Name of Co-borrower",24,"1. Optional , can be blank\n2. Instalment No 0 or 1 – Text value upto 80 Chars \n3. Instalment No > 1  - Should be blank\n4. For Installment No 0 or 1, Cannot contain spaces,double space at starting.                                                                                    5. Length of Co-borrowe can not be less than 3 chars"]
[null,"Unique Identification Proof [Aadhaar (01), Voter’s Card (02), PAN Card (03), Passport No (04), Revenue Authority Certificate (05), Any other Govt. approved ID (06)] ",25,"1.Value between 01 to 06                                                                         2. Please provide unique Identification Proof"]
[null,"If any other Govt. approved ID (06) - Please specify(Identification proof Type)",26,"1. Can be filled only 06 Selected in UIType Column\n2. Can contain only text only.\n3. Length of value should be upto 50\n4. In case Instalment No is greater than 1, column should be blank                                                                                                     5. For Installment No 0 or 1, Identification Proof other can not contain spaces at starting or double space and dots\n"]
[null,"Unique Identification Number",27,"1. Can not be blank\n2. UID Type 01: Should be ADHAR No of 12 digit\n3. UID Type 03: Should be PAN No(5 Alpha, 4 Numeric and 1 Alpha – Total 10 Chars)\n3. Max length of value can 20 chars\n4. Only numeric value allowed for UID Proof 01                                                                                      5. Length of UINo should be between 5 to 20 characters.                                                                     6. For Installment No 0 or 1, UINo can not contain spaces at starting or double space and dots"]
[null,"Sex [Male (01), Female (02), Transgender (03)]",28,"1. Instalment No > 1, should be blank\n2. Instalment No 0 or 1 – value 01 to 03\n3. Instalment No 0 or 1- cannot be blank"]
[null,"Date of Birth [DD/MM/YYYY]",29,"1. Instalment No > 1, should be blank\n2. Instalment No 0 or 1 – Date in format dd/mm/yyyy\n3. Age according to DOB should not be below 18 years and more than 100 years on first disbursement\n4. Please enter valid date                                                                         5. For Instalment 0 or 1- should not be blank"]
[null,"Employment Category [Farmer (01), Farm Labourer (02) Self Employed (03), Salaried (04), Others (05)]",30,"1. Instalment No > 1, should be blank\n2. Instalment No 0 or 1 – Should be selected from drop down list\n"]
[null,"NREGA Job Card number",31,"1. Instalment No >1 should be blank. 2.Instalment No 0 or 1- should not be blank"]
[null,"SECC Tin number",32,"1. Instalment No >1 should be blank. 2.Instalment No 0 or 1- should not be blank"]
[null,"Aadhaar card number",33,"1. Instalment no > 1 should be blank.                 2. Instalment No. 0 or 1- can be blank or should be valid 12 digit aadhar number"]
[null,"PAN Card Number",34,"1. Instalment No > 1, should be blank\n2. Instalment No 0 or 1 – Can be blank or valid PAN No\n3. If value is provided should be in valid 10 digit PAN No format – XXXXX12345X\n4. If UID is PAN and PAN is provided, both should be same\n"]
[null,"Residence Address 1 (Plot/House/Flat/Door No. & Street, Locality/Colony name, Village/Taluk)",35,"1. Instalment No 0 or 1 – Text value in the range of 3 Characters and maximum upto 100 chars \n2. Instalment No > 1   – should be blank\n3.For Instalment No 0 or 1- cannot be blank"]
[null,"Residence Address 2 (District)",36,"1. Instalment No 0 or 1 – Text value in the range of 3 Characters and maximum upto 100 chars \n2. Instalment No > 1,  should be blank\n\n"]
[null,"Residence Address 3 (State)",37,"1. Instalment No 0 or 1 – Text value in the range of 3 Characters and maximum upto 50 chars \n2. Instalment No > 1 , should be blank\n\n"]
[null,"Residence Address 4 (Pincode)",38,"1. Instalment No 0 or 1 – Should be numeric value of 6 length \n2. Instalment No > 1, should be blank"]
[null,"Mobile Number",39,"1. For Installment No is greater than 1, should be blank\n2. If value given, should be  numeric value of 10 length\n3. For Instalment No 0 or 1- should not be blank"]
[null,"Category Caste* [General(01), SC (02), ST (03), OBC (04)]",40,"1. Instalment No 0 or 1 – Should not be blank and selected from drop down list \n2. Instalment No > 1  - Should be blank\n"]
[null,"Religion* [Whether belong to Hindu (01), Muslim (02), Christian (03), Sikh (04), Jainism (05), Buddhism (06), Zorastrianism(07), Others (08)]",41,"1. Instalment No 0 or 1 – Should not be blank and selected from drop down list \n2. Instalment No > 1  - Should be blank\n"]
[null,"If a minority in the state for where claim is made  [Yes(01), No(02)]",42,"1. Instalment No 0 or 1 – Should not be blank and selected from drop down list \n2. Instalment No > 1  - Should be blank\n"]
[null,"With any disability or not able bodied [Yes(01), No(02)]",43,"1. Instalment No 0 or 1 – Should not be blank and selected from drop down list \n2. Instalment No > 1  - Should be blank\n"]
["IV. Household Details","Household Annual Income (Amount in Rs.)",44,"\n1. Instalment No > 1  - Should be blank\n2. For Instalment No 0 or 1- should not be blank                            3. Should not be decimal                                                                          4. Should be in numeric format"]
["V. Property Details","Property Type [Pucca House (01)]",45,"1. Instalment No 0 or 1 – Select from drop down list\n2. Instalment No > 1  - Should be blank\n3. For Instalment No 0 or 1- should not be blank"]
[null,"Number of rooms in house [01,02,03…the exact number of rooms]",46,"1. Instalment No > 1  - Should be blank\n2. Instalment No 0 or 1 – Should not be blank."]
[null,"Property Category [New(01), Existing & Owned (02)]",47,"1. Instalment No > 1  - Should be blank\n2. Instalment No 0 or 1 – value should be provided and should be selected from dropdown list\n"]
[null,"Property Address 1 (Plot/House/Flat/Door No. & Street, etc.)",48,"1. Instalment No 0 or 1 – Text value in the range of 3 Characters and maximum upto 100 chars \n2. Instalment No > 1  – should be blank\n3. For Instalment 0 or 1- cannot be blank"]
[null,"Property Address 2 (Locality / Colony Name)",49,"1. Instalment No 0 or 1 – Text value in the range of 3 Characters and maximum upto 100 chars \n2. Instalment No > 1  – should be blank\n3. For Instalment 0 or 1- should not be blank"]
[null,"Property Address 3 [Name of the Place (Village/Taluk)]",50,"1. Instalment No 0 or 1 – Text value in the range of 3 Characters and maximum upto 50 chars \n2. Instalment No > 1 – should be blank                                         3. For Instalment 0 or 1- should not be blank        "]
[null,"Property Address 4 (Pincode)",51,"1. Instalment No 0 or 1 – Should be numeric value of 6 length \n2. Instalment No > 1   – should be blank\n3. For Instalment No 0 or 1- cannot be blank.                              4. Should be only numeric Value."]
[null,"Location Code ",52,"1. Instalment No > 1  - should be blank      \n2. Instalment No 0 or 1 – should be numeric value of 6 length – refer list of villages for valid values                                                                                3. Location code should match with village code in abbreviation list    \n4. For Instalment No 0 or 1- should not be blank                            5. Should be greater than 0"]
[null,"Village Code matches with code uploaded on Website",53,"Select Yes from dropdown list."]
[null,"Property Address  (District) (Based on  the Abbreviation List enter the district )",54,"Based on  the Abbreviation List enter the district"]
[null,"Property Address 5 (State) (No entry required)",55,"Automatically filled based on Location Code"]
[null,"Stage of Construction [ Yet to Start (00), Foundation(01), Plinth (02), Windowsill (03), Lintel (04), Roofcast (05), Completed(06)]",56,"1. Instalment No > 1  - Should not be “00”.                                  2. If Instalment No 0 or 1 to be filled from top down menu"]
[null,"Loan Purpose [Construction (01), Modification (02)]",57,"1. Instalment No > 1  - Should be blank\n2. Instalment No 0 or 1 – value should be provided,\nfrom top down menu."]
[null,"Is the loan taken over or  Balance Transferred from another PLI  [Yes(01), No(02)]",58,"1. Instalment No > 1  - Should be blank\n2. Instalment No 0 or 1 – select from drop down list\n3. For Instalment No 0 or 1- should not be blank"]
["V. Loan Detail","Loan Amount Sanctioned (in Rs.)",59,"1. Should be non blank and numeric value > 0 , only positive.                                                                                                     2.For installment no 0 or 1, Loan amount sanctioned should be greater than 0                                                       3.Loan amount sanctioned should not be in decimal.         4. For installment no greater than 1, Loan amount sanctioned should be blank."]
[null,"Loan Sanction Date",60,"1. For installment no greater than 1, should be blank.       2. For installment no 0 or 1, Provide valid date in dd/mm/yyyy format.                                                                  3. Loan sanction date should not be greater than current date.                                                                                             4. Loan sanction date should not be less than 01/03/2017."]
[null,"Loan Interest Rate (% p.a.)",61,"1.Select from drop down list. If Installment No is greater than 1, should be blank.                                                                                       2. If Instalment No is 0 or 1- cannot be blank"]
[null,"Loan Tenure, including Moratorium Period (in months)",62,"1.Should be non blank and numeric value > 0, only positive.                                                                                                                2. Loan Tenure, including Moratorium Period (in months) should be greater than 0.                                                                         3.Loan Tenure, including Moratorium Period (in months) should be only positive.                                                         4. Loan tenure should not be greater than 600."]
[null,"Loan Moratorium Period (in months), if any",63,"1. Should be numeric value, may be 0 and maximum value upto 36\n2. Should be less than loan tenure                                                       3. If Installment No is greater than 1 then should be blank\n4. For Instalment No 0 or 1 - should not be blank.                 5.Loan Moratorium Period (in months) should not be only positive"]
[null,"Repayment Start Date of Principal or EMI [DD/MM/YYYY]",64,"1. Mandatory value in dd/mm/yyyy format. If Installment no is greater than 1, should be blank                                                             2.  For Instalment No 0 or 1 - cannot be blank                                  3.Cannot be before   01/03/2017."]
[null,"EMI Amount mentioned in Sanction Letter (in Rs.)",65,"1.Should be non blank and numeric value > 0 and below sanctioned amount. If Installment No is greater than 1 then should be blank                                                                                            2. For Instalment No 0  or 1- cannot be blank                                   3. Should not be greater than loan amount.                                     4. Should be positive.                                                                                 5.EMI Amount mentioned should not be in decimal"]
[null,"Date of First Disbursement Date [DD/MM/YYYY]",66,"1. Mandatory value in dd/mm/yyyy format\n2. Should not be before 01/03/2017\n3. Should be before current date\n4. Should not be after repayment start date\n5. Should not be blank                                                                         6.Repayment Date should not be more than first disbursement date and 5 years"]
[null,"Current Loan Instalment Disbursement Date for which subsidy claimed [DD/MM/YYYY]",67,"1. Mandatory value in dd/mm/yyyy format\n2. Instalment No 0 or 1 – First Disbursement Date and Current Disbursement Date should be same\n3. Instalment No > 1 – Current Disbursement Date should be after First Disbursement Date\n4. Should be upto current date\n5. Should not be blank"]
[null,"Loan Amount Disbursed for this Claim (in Rs.)",68,"1. Should be numeric value > 0 and less than or equal to santioned amount                                                                                       2. Should not be blank                                                                               3. Should be less than loan amount                                                     4. Should not be in decimal"]
[null,"Cumulative Loan Disbursement (excluding the disbursement made for the current subsidy claim)  (in Rs.)",69,"1. Mandatory value , cannot be blank\n2. Instalment No 0 or 1 – should be 0\n3. Instalment No > 1 – Should be cumulative disbursement before current instalment and should not be 0\n4. Total of current disbursement and cumulative disbursement should not be more than loan sanctioned.\n5. Should be numeric value > 0                                                                6. Should not be in decimal.                                                               7. Cumulative loan disbursemen should not be greater than 600000."]
[null,"NPV of the Interest Subsidy Amount (in Rs.)",70,"Automatically computed"]
[null,"Interest Subsidy Amount Claimed (in Rs.)",71,"Automatically computed, can be edited, however can not be more than system computed amount(Col 69)"]
[null,"Number of Dependents",72,"1. Optional numeric value .                                                                            2.If Installment No is greater than 1 then should be blank.        3. For Instalment No 0 or 1 then should not be blank                   4. Should be numeric value"]
[null,"Name of Dependent 1",73,"1. No of dependent > 0, value can be provided.                        2. Can contain only text, spaces and periods.                                                                           3. If Installment No is greater than 1 then should be blank.           4. Should be upto 50 characters .                                                                   5. Cannot contain spaces, double space and dots at starting.                                                                                                     6. Length of Dependent 1 can not be less than 3 Chars.      "]
[null,"Unique Identification Proof [Aadhaar (01), Voter’s Card (02), PAN Card (03), Passport No (04), Revenue Authority Certificate (05), Any other Govt. approved ID (06)] ",74,"1. No of dependent > 0,Value between 01 to 06                             2. Cannot be blank."]
[null,"If any other Govt. approved ID (06)- Please specify(Identification proof Type)",75,"No of dependent > 0 then   1. Can be filled only 06 Selected in column 05 \n2. Can contain only text, spaces and periods\n3. Length of value should be upto 50\n4. In case Instalment No is greater than 1, column should be blank\n5. Cannot be blank                                                                                       6. Cannot contain spaces, double space and dots at starting"]
[null,"Unique Identification Number",76,"No of dependent > 0 then   1. Can not be blank\n2. UID Type 01: Should be ADHAR No of 12 digit\n3. UID Type 03: Should be PAN No(5 Alpha, 4 Numeric and 1 Alpha – Total 10 Chars)\n3. Max length of value can 20 chars.                                                      4. If Installment NO is greater than 1, should be blank.               5. Only numeric value in adhar no                                                        6. Should not contain spaces , double space and dots at starting                                                                                                              7. Min length of characters can be 5 chars."]
[null,"Name of Dependent 2",77,"No of dependent > 0, value can be provided. Can contain only text, spaces and periods.                                                                           If Installment No is greater than 1 then should be blank.           Should be upto 50 characters .                                                                   Cannot contain spaces, double space and dots at starting . 6. Length of Dependent 1 can not be less than 3 Chars.       "]
[null,"Unique Identification Proof [Aadhaar (01), Voter’s Card (02), PAN Card (03), Passport No (04), Revenue Authority Certificate (05), Any other Govt. approved ID (06)] ",78,"1. No of dependent > 0,Value between 01 to 06                             2. Cannot be blank."]
[null,"If any other Govt. approved ID (06)- Please specify(Identification proof Type)",79,"No of dependent > 0 then   1. Can be filled only 06 Selected in column 05 \n2. Can contain only text, spaces and periods\n3. Length of value should be upto 50\n4. In case Instalment No is greater than 1, column should be blank\n5. Cannot be blank                                                                                       6. Cannot contain spaces, double space and dots at starting"]
[null,"Unique Identification Number",80,"No of dependent > 0 then   1. Can not be blank\n2. UID Type 01: Should be ADHAR No of 12 digit\n3. UID Type 03: Should be PAN No(5 Alpha, 4 Numeric and 1 Alpha – Total 10 Chars)\n3. Max length of value can 20 chars.                                                      4. If Installment NO is greater than 1, should be blank.               5. Only numeric value in adhar no                                                        6. Should not contain spaces , double space and dots at starting                                                                                                              7. Min length of characters can be 5 chars."]
[null,"Name of Dependent 3",81,"No of dependent > 0, value can be provided. Can contain only text, spaces and periods.                                                                           If Installment No is greater than 1 then should be blank.           Should be upto 50 characters .                                                                   Cannot contain spaces, double space and dots at starting . 6. Length of Dependent 1 can not be less than 3 Chars.       "]
[null,"Unique Identification Proof [Aadhaar (01), Voter’s Card (02), PAN Card (03), Passport No (04), Revenue Authority Certificate (05), Any other Govt. approved ID (06)] ",82,"No of dependent > 0, value can be provided. Can contain only text, spaces and periods.                                                                           If Installment No is greater than 1 then should be blank.           Should be upto 50 characters .                                                                   Cannot contain spaces, double space and dots at starting . 6. Length of Dependent 1 can not be less than 3 Chars.       "]
[null,"If any other Govt. approved ID (06)- Please specify(Identification proof Type)",83,"No of dependent > 0 then   1. Can be filled only 06 Selected in column 05 \n2. Can contain only text, spaces and periods\n3. Length of value should be upto 50\n4. In case Instalment No is greater than 1, column should be blank\n5. Cannot be blank                                                                                       6. Cannot contain spaces, double space and dots at starting"]
[null,"Unique Identification Number",84,"No of dependent > 0 then   1. Can not be blank\n2. UID Type 01: Should be ADHAR No of 12 digit\n3. UID Type 03: Should be PAN No(5 Alpha, 4 Numeric and 1 Alpha – Total 10 Chars)\n3. Max length of value can 20 chars.                                                      4. If Installment NO is greater than 1, should be blank.               5. Only numeric value in adhar no                                                        6. Should not contain spaces , double space and dots at starting                                                                                                              7. Min length of characters can be 5 chars."]
[null,"Name of Dependent 4",85,"No of dependent > 0, value can be provided. Can contain only text, spaces and periods.                                                                           If Installment No is greater than 1 then should be blank.           Should be upto 50 characters .                                                                   Cannot contain spaces, double space and dots at starting . 6. Length of Dependent 1 can not be less than 3 Chars.       "]
[null,"Unique Identification Proof [Aadhaar (01), Voter’s Card (02), PAN Card (03), Passport No (04), Revenue Authority Certificate (05), Any other Govt. approved ID (06)] ",86,"No of dependent > 0, value can be provided. Can contain only text, spaces and periods.                                                                           If Installment No is greater than 1 then should be blank.           Should be upto 50 characters .                                                                   Cannot contain spaces, double space and dots at starting . 6. Length of Dependent 1 can not be less than 3 Chars.       "]
[null,"If any other Govt. approved ID (06)- Please specify(Identification proof Type)",87,"No of dependent > 0 then   1. Can be filled only 06 Selected in column 05 \n2. Can contain only text, spaces and periods\n3. Length of value should be upto 50\n4. In case Instalment No is greater than 1, column should be blank\n5. Cannot be blank                                                                                       6. Cannot contain spaces, double space and dots at starting"]
[null,"Unique Identification Number",88,"No of dependent > 0 then   1. Can not be blank\n2. UID Type 01: Should be ADHAR No of 12 digit\n3. UID Type 03: Should be PAN No(5 Alpha, 4 Numeric and 1 Alpha – Total 10 Chars)\n3. Max length of value can 20 chars.                                                      4. If Installment NO is greater than 1, should be blank.               5. Only numeric value in adhar no                                                        6. Should not contain spaces , double space and dots at starting                                                                                                              7. Min length of characters can be 5 chars."]
[null,"Structural Safety",89,"Should not be blank. Should select yes (01) and no (02) from drop down menu."]
[null,"Normal House Life Expectancy (in years)",90,"Should be filled in numeric value. Value cannot be negative."]
[null,"Water Supply (Yes (01))",91,"1. If Instalment No is greater than 1 then should be blank                                                                                           2. For Instalment No 0 or 1- should not be blank."]
[null,"Electicity Supply (Yes (01))",92,"1. If Instalment No is greater than 1 then should be blank                                                                                           2. For Instalment No 0 or 1- should not be blank."]
[null,"Sanitation (Yes (01))",93,"1. If Instalment No is greater than 1 then should be blank                                                                                            2. For Instalment No 0 or 1- should not be blank."]
[null,"Gas Supply (Yes (01))",94,"1. If Instalment No is greater than 1 then should be blank                                                                                            2. For Instalment No 0 or 1- should not be blank."]
[null,"Remarks",95,"1. If Instalment No is greater than 1 then should be blank                                                                                           2. For Instalment No 0 or 1- Length should be upto 100 chars."]

{"sheet":"DDLDetail","index":7,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
["UIProof","Sex","Emp Category","Category Caste","Category Religion","Monority / Disability/Blance Transfer","Property Type","Property Category","Construction Stage","Loan Purpose","State","Structural Safety","Village code matches with code uploaded on website                           (Yes/No)"]
["01","01","01","01","01","01","01","01","00","01","AN","01","Yes"]
["02","02","02","02","02","02",null,"02","01","02","AP","02"]
["03","03","03","03","03",null,null,null,"02",null,"AR"]
["04",null,"04","04","04",null,null,null,"03",null,"AS"]
["05",null,"05",null,"05",null,null,null,"04",null,"BR"]
["06",null,null,null,"06",null,null,null,"05",null,"CH"]
[null,null,null,null,"07",null,null,null,"06",null,"CG"]
[null,null,null,null,"08",null,null,null,null,null,"DN"]
[null,null,null,null,null,null,null,null,null,null,"DD"]
[null,null,null,null,null,null,null,null,null,null,"DL"]
[null,null,null,null,null,null,null,null,null,null,"GA"]
[null,null,null,null,null,null,null,null,null,null,"GJ"]
[null,null,null,null,null,null,null,null,null,null,"HR"]
[null,null,null,null,null,null,null,null,null,null,"HP"]
[null,null,null,null,null,null,null,null,null,null,"JK"]
[null,null,null,null,null,null,null,null,null,null,"JH"]
[null,null,null,null,null,null,null,null,null,null,"KA"]
[null,null,null,null,null,null,null,null,null,null,"KL"]
[null,null,null,null,null,null,null,null,null,null,"LD"]
[null,null,null,null,null,null,null,null,null,null,"MP"]
[null,null,null,null,null,null,null,null,null,null,"MH"]
[null,null,null,null,null,null,null,null,null,null,"MN"]
[null,null,null,null,null,null,null,null,null,null,"ML"]
[null,null,null,null,null,null,null,null,null,null,"MZ"]
[null,null,null,null,null,null,null,null,null,null,"NL"]
[null,null,null,null,null,null,null,null,null,null,"OD"]
[null,null,null,null,null,null,null,null,null,null,"PY"]
[null,null,null,null,null,null,null,null,null,null,"PB"]
[null,null,null,null,null,null,null,null,null,null,"RJ"]
[null,null,null,null,null,null,null,null,null,null,"SK"]
[null,null,null,null,null,null,null,null,null,null,"TN"]
[null,null,null,null,null,null,null,null,null,null,"TS"]
[null,null,null,null,null,null,null,null,null,null,"TR"]
[null,null,null,null,null,null,null,null,null,null,"UP"]
[null,null,null,null,null,null,null,null,null,null,"UK"]
[null,null,null,null,null,null,null,null,null,null,"WB"]