ࡱ> nN0  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmopqrstuvwxyz{|}~Root Entry F ЁLWorkbook._VBA_PROJECT_CUR" TKVMsoDataStore#! T%4UKHQWW21==2 T>(UItem PropertiesO5RZYCXSXBQ==2 T%4UItem  !.PropertiesCtls VBA%4UDU g2\pYASHIKA Ba=  ThisWorkbook= P8X@"1Calibri1Calibri1Calibri1Calibri1Calibri1Calibri1(  Trebuchet MS1 Calibri1Calibri1Calibri1 Calibri1Calibri1Calibri1Calibri1 Calibri1 Calibri1Calibri1 Calibri1Calibri14Calibri1 Calibri1Calibri1Calibri1,8Calibri18Calibri18Calibri1>141<Calibri1?Calibri1h8Cambria1Calibri1 Calibri1 Calibri1 Calibri1Calibri"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)3" "\ #,##0;" "\ \-#,##0=" "\ #,##0;[Red]" "\ \-#,##0?" "\ #,##0.00;" "\ \-#,##0.00I"" "\ #,##0.00;[Red]" "\ \-#,##0.00u8_ " "\ * #,##0_ ;_ " "\ * \-#,##0_ ;_ " "\ * "-"_ ;_ @_ .)_ * #,##0_ ;_ * \-#,##0_ ;_ * "-"_ ;_ @_ @_ " "\ * #,##0.00_ ;_ " "\ * \-#,##0.00_ ;_ " "\ * "-"??_ ;_ @_ 61_ * #,##0.00_ ;_ * \-#,##0.00_ ;_ * "-"??_ ;_ @_ 0.050_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-,'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-4/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-0.00;[Red]0.00"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\)                                                                       ff + ) , *       P  P         `                           a> !  "     "         @ @ @ @ 1@ @  "     ( " #  !(X          1 1  1 1   @ @   @ @   @ @  ""  @@   @  @@  @   @        @ @  $@ @ + ||u~}m}-} 00_)}-} 00_)}-} 00_)}-} 00_)}-} 00_)}-} 00_)}-} 00_)}-} 00_)}-} 00_)}-}  00_)}-}  00_)}-}  00_)}-}  00_)}-}  00_)}-} 00_)}-} 00_)}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef [$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L [$ -}A} 00_)23[$ -}A} 00_)23[$ -}A} 00_)23[$ -}A} 00_)23[$ -}A}  00_)23[$ -}A}! 00_)23 [$ -}A}" 00_)[$ -}A}# 00_)[$ -}A}$ 00_)[$ -}A}% 00_)[$ -}A}& 00_)[$ -}A}' 00_) [$ -}A}( 00_)[$ -}}) }00_)[$ -##0."\ * _ ;_ }}* 00_)[$ -???##0.???"\ * ???_ ;_ ???}-}+ 00_)}-}, 00_)}-}- 00_)}-}. 00_)}-}1 00_)}A}2 a00_)[$ -}A}3 00_)[$ -}A}4 00_)?[$ -}A}5 00_)23[$ -}-}6 00_)}}8 ??v00_)̙[$ -##0."\ * _ ;_ }A}9 }00_)[$ -}A}: e00_)[$ -}-}A 00_)}}B 00_)[$ -##0."\ * _ ;_ }}C 00_)[$ -##0."\ * _ ;_ }x}D00_)[$## "\ _ }}E ???00_)[$???## ???"\  ???_ ;_ ???}-}F 00_)}-}G 00_)}U}H 00_)[$## }-}I 00_)}A}J 00_)[$}A}K 00_)[$}A}L 00_)[$}-}M 00_)}-}N 00_)}-}P 00_)}-}Q 00_)}A}U 00_)[$}(}V00_)}(}W00_)}-}X 00_)}(}Y 00_)}(}Z 00_)}-}[ 00_)}-}_ 00_)}-}` 00_)}-}a 00_)}-}b 00_)}-}c 00_)}-}d 00_)}-}e 00_)}-}f 00_)}-}g 00_)}-}h 00_)}A}l 00_)[$}A}m 00_)[$}A}n 00_)[$}A}o 00_)[$}A}p 00_)[$}-}q 00_)}-}r 00_)}A}s 00_)[$}A}t 00_)4[$ 20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L渷 % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  Lմ % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23ږ % 60% - Accent3M( 60% - Accent3 23כ % 60% - Accent4M, 60% - Accent4 23 % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23 % "Accent1AAccent1 O % #Accent2A!Accent2 PM % $Accent3A%Accent3 Y % %Accent4A)Accent4 d % &Accent5A-Accent5 K % 'Accent6A1Accent6  F %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Excel Built-in Normal 20Excel Built-in Normal 2 21Explanatory TextG5Explanatory Text % 2Good;Good  a%3 Heading 1G Heading 1 I}%O4 Heading 2G Heading 2 I}%?5 Heading 3G Heading 3 I}%236 Heading 49 Heading 4 I}%7( Hyperlink 8InputuInput ̙ ??v% 9 Linked CellK Linked Cell }% :NeutralANeutral  e%3Normal % ;Normal 2< Normal 2 2= Normal 2 3 >Normal 3 ?Normal 4 @Normal 5 ANormal 67Normal 6 % BNoteb Note   CNote 2fNote 2   DNote 2 2jNote 2 2   EOutputwOutput  ???%????????? ???F$Percent GTitle1Title I}% HTotalMTotal %OOI Warning Text? Warning Text %XTableStyleMedium2PivotStyleLight16`߮Read Me*Investor Details ~ErrorSheet3&!,Country_State_District_Mapping2 AndamanandNicobarIslands;' AndhraPradesh; * ArunachalPradesh; Assam; Bihar;% Chandigarh:& Chhattisgarh;! Country;&DadarNagarHaveli: % DamanandDiu;  Delhi;  Goa; ! Gujarat; ! Haryana;) HimachalPradesh;  India;$( InvestmentType; '') JammuandKashmir;# Jharkhand;# Karnataka;  Kerala; ! Lakshadweep:' MadhyaPradesh;2% Maharashtra;#! Manipur; # Meghalaya;! Mizoram;NA:+" Nagaland;   Orissa;! Pondicherry:  Punjab;# Rajasthan;!  Sikkim;# TamilNadu; # Telangana; !!! Tripura;""% Uttarakhand; $$& UttarPradesh;K##$ WestBengal;%%gffxX$ @  8#O "F KOi)G@=F KOi)Gp g6xVMKTQ~=Yd~LfDbѪjQi%8 BfѴEЦEA  --/?0yνCA+=9ӫ6jDإEYjCnvDr1 +rrZneqm;҈<1A,'., 1\EQ/Xs8+ɖkV;JǕLxjn5+5 g^ge-ESGy?f=b>M@_O E묬KΦ2c-]w*ga?܏E:qXź/?x Hk\IJz 6ȗurn$%|:2yn! >o |nx#k>[E?lkY N<}b>ֳo#/<4?-7cx> <3㓃jKdާ) LYh9.ꝅ3I'ITJW-RZºEдiJ )lܸ"QpAЅK.]RTݙHA09=ǽw&qDd P*Q1FDdµ"<C6ׁ/}qDz1=$spi*Yy?$ &/# Kĉ tC t3`9azKTLӈGxcR -Sr F6 p~ 1v.G64#kZ3ҵ* ÇaZyppЌX~C&‘ufd^oFFAsؖW#In[e8!]r{@Uc9q[.ֳJ}DZû崳S#ʦӓA%VN_@<#OGonm${w īo'OdȬƘa݃1ML`J{iip!<3ږj/x XwbO1)w0UE*@b,x<7Oy򬯼RR K$"F;gRb@=F;gRb㢀 g6xVKTQ?sF1 Ł>0N,+0 ?Gf.m \LKp6hQpi9.#i{g%3s{HPJR RDgeGq蠏Y6d vFLL{=AvEW.]Y>_7ݧ}3!N[Ѡ;Vb-tS#d2ȴ?đi)J7-] zJ%p 2v,GV`= Bӵ2t†a, :]#KйebX,vع};{^:W\^sUcSV'J++s):,:sxڛK:5EakK2h* Ǚ"4 еGKc<z?~ML9+Y5|CWP9Gd[GVS2x>Co )3GFx'@>~؅EV"o?w6E;l}w=юGNɑ٣]ęܜq]ĺ=}NYQϕͫy!M@ w+060{1) iMe!eΤSg /V~09䯁O$Lgʻ R=s*o~f(C3 A@@   [Read the following instructions carefully before proceeding to enter the Investor Details: Important Note >Steps to follow to fill details in the 'Investor Details' tab. Enable MacrosY It is important that you Enable Macro using following instructions : a) Excel 2000 and 2003: Tools-->Macro-->Security-->Select 'Low'-->OK b) Excel 2007: Office Button-->Excel Options-->Trust Center-->Trust Center Settings--Macro Settings-->Enable all Macros-->OK Pl Note : Close the Excel Sheet and re-open it after enabling Macro to start.  Enter the CIN  Add Investor DetailsSave the Excel file If you have multiple excels for the same CIN and SRN; use the below nomenclature: (ABC_1.xls, ABC_2.xls,ABC_3.xls ...) where ABC represents the CIN of the Company Upload the Excel fileCountry Indian StatesAndaman and Nicobar IslandsAndhra PradeshArunachal PradeshAssamBihar Chandigarh ChhattisgarhDadar Nagar Haveli Daman and DiuDelhiGoaGujaratHaryanaHimachal PradeshJammu and Kashmir Jharkhand KarnatakaKerala LakshadweepMadhya Pradesh MaharashtraManipur MeghalayaMizoramNagalandOrissa PondicherryPunjab RajasthanSikkim Tamil Nadu TelanganaTripura Uttar Pradesh Uttarakhand West BengalInvestment TypeNAINDIAAndaman Islands AnantapurAnjawBarpetaArariaBastarDadar & Nagar HaveliDaman Central Delhi North Goa AhmedabadAmbalaBilaspurAnantnagBokaroBagalkot Alappuzha Alirajpur Ahmednagar BishnupurEast Garo HillsAizawlDimapurAngulAmritsarAjmer East SikkimAriyalurAdilabadDhalaiAgraAlmoraBankura(Amount for unclaimed and unpaid dividend AFGHANISTANNicobar IslandsChittoor Changlang Bongaigaon AurangabadDiu South GoaAmreliBhiwaniChambaBadgamChatraBangalore Rural ErnakulamAnuppurAkola ChurachandpurEast Khasi HillsChamphaiKiphire Boudh (Bauda)BarnalaAlwar West SikkimChennai North TripuraAligarh Bageshwar BardhamanAmount for matured deposits ALAND ISLANDS East Godavari Dibang ValleyCacharBanka Dantewada East DelhiAnand FaridabadHamirpurBaramulaDeogharBangalore UrbanIdukki AshoknagarAmravatiChandel Jaintia HillsKolasibKohimaBhadrakBathindaBanswara North Sikkim Coimbatore Hyderabad South Tripura AllahabadChamoliBirbhumAmount for matured debenturesALBANIAGuntur East KamengDarrang BegusaraiDhamtari New Delhi Banas Kantha FatehabadKangraDodaDhanbadBelgaumKollamBalaghat Imphal EastRi-Bhoi LawngtlaiLonglengBolangir (Balangir)FaridkotBaran South Sikkim Cuddalore Karimnagar West TripuraAmbedkar Nagar Champawat Cooch Behar+Amount for application money due for refundALGERIAKadapa East SiangDhemaji BhagalpurDurg North DelhiBharuchGurgaonKinnaurJammuDumkaBellaryKannurBarwaniBeed Imphal WestSouth Garo HillsLunglei Mokokchung Baleswar (Balasore)Fatehgarh SahibBarmer DharmapuriKhammamAuraiyaDehradun DarjeelingInterest on matured debenturesAMERICAN SAMOAKrishna Kurung KumeyDhubriBhojpurJanjgir-Champa North East BhavnagarHissarKuluKargilGarhwaBidar KasaragodBetulBhandaraSenapatiThe West Khasi HillsMamitMonBargarh (Baragarh)Fazilka BharatpurDindigul MahbubnagarAzamgarhHaridwarEast MidnaporeInterest on matured depositsANDORRAKurnoolLohit DibrugarhBuxarJashpur North WestDahodJhajjarLahaul and SpitiKathuaGiridihBijapurKottayamBhindBuldhana TamenglongWest Garo HillsSaihaPerenCuttackFirozpurBhilwaraErodeMedakBadaunNainitalHooghly,Interest on application money due for refundANGOLAPrakasamLower Dibang ValleyGoalpara DarbhangaKanker South Delhi GandhinagarJindMandiKupwaraGoddaChamarajanagar KozhikodeBhopal ChandrapurThoubalSerchhipPhekDebagarh (Deogarh) GurdaspurBikaner KanchipuramNalgondaBagpat Pauri GarhwalHowrah&Redemption amount of preference sharesANGUILLANellore Papum PareGolaghatEast ChamparanKawardhaSouth West DelhiJamnagarKaithalShimlaLehGumla Chikballapur Malappuram BurhanpurDhuleUkhrulTuensang Dhenkanal HoshiarpurBundi Kanyakumari NizamabadBahraich Pithoragarh Jalpaiguri#Sales proceed for fractional shares ANTARCTICA SrikakulamTawang HailakandiGayaKorba West DelhiJunagadhKarnalSirmaurPoonch Hazaribagh ChikmagalurPalakkad Chhatarpur GadchiroliWokhaGajapati Jalandhar ChittorgarhKarur Rangareddi Balarampur Rudra PrayagKolkataANTIGUA AND BARBUDAVishakhapatnamTirapJorhat GopalganjKoriyaKachchh KurukshetraSolanPulwamaJamtara ChitradurgaPathanamthitta ChhindwaraGondia ZunhebotoGanjam KapurthalaChuru KrishnagiriWarangalBallia Tehri GarhwalMalda ARGENTINA Vizianagaram Upper SiangKamrupJamui MahasamundKheda MahendragarhUnaRajauriKodermaDakshina KannadaThrissurDamohHingoli JagatsinghpurLudhianaDausaMaduraiBandaUdham Singh Nagar MurshidabadARMENIA West GodavariUpper Subansiri Karbi Anglong JehanabadRaigarhMahesanaMewatSrinagarLatehar DavanagereThiruvananthapuramDatiaJalgaonJajapur (Jajpur)MansaDholpur Nagapattinam Barabanki UttarkashiNadiaARUBA West Kameng KarimganjKaimurRaipurNarmada PanchkulaUdhampur LohardagaDharwadDewasJalna JharsugudaMoga DungarpurNamakkalBareillyNorth 24 Parganas AUSTRALIA West Siang KokrajharKatihar RajnandgaonNavsariPanipatPakurGadagDharKolhapur KalahandiMuktsar Hanumangarh PerambalurBastiNorth DinajpurAUSTRIA LakhimpurKhagariaSurguja Panch MahalsRewariPalamuGulbargaDindoriLatur Kandhamal PathankotJaipur PudukkottaiBhimnagar (Sambhal)Purulia AZERBAIJANMarigaon KishanganjPatanRohtakPashchim SinghbhumHassanGuna Mumbai City KendraparaPatiala JaisalmerRamanathapuramBijnorSouth 24 ParganasBAHAMASNagaon Lakhisarai PorbandarSirsaPurba SinghbhumHaveriGwaliorMumbai SuburbanKendujhar (Keonjhar)RupnagarJalorSalem BulandshahrSouth DinajpurBAHRAINNalbari MadhepuraRajkotSonepatRanchiKodaguHardaNagpurKhordha!Sahibzada Ajit Singh Nagar-MohaliJhalawar Sivaganga ChandauliWest Midnapore BANGLADESHNorth Cachar Hills Madhubani Sabar Kantha Yamuna Nagar SahibganjKolar HoshangabadNandedKoraputSangrur Jhunjhunu Thanjavur!Chhatrapati Shahuji Maharaj NagarBARBADOSSibsagarMungerSurat SeraikelaKoppalIndore Nandurbar MalkangiriShahid Bhagat Singh NagarJodhpurTheni ChitrakootBELARUSSonitpur Muzaffarpur SurendranagarSimdegaMandyaJabalpurNashik MayurbhanjKarauli The NilgirisDeoriaBELGIUMTinsukiaNalanda The DangsMysoreJhabua Osmanabad NabarangpurKotaThirupurEtahBELIZENawadaVadodaraRaichurKatniParbhaniNayagarhNagaur ThiruvallurEtawahBENINPatnaValsad RamanagaraKhandwaPuneNuapadaPaliThiruvannamalaiFaizabadBERMUDAPurniaShimogaKhargoneRaigadPuri Pratapgarh Thiruvarur FarrukhabadBHUTANRohtasTumkurMandla RatnagiriRayagada Rajsamand ThoothukudiFatehpurBOLIVIASaharsaUdupiMandsaurSangli SambalpurSawai MadhopurTiruchirapalli FirozabadBOSNIA AND HERZEGOVINA SamastipurUttara KannadaMorenaSataraSubarnapur (Sonepur)Sikar TirunelveliGautam Buddha NagarBOTSWANA< SaranYadgir Narsinghpur SindhudurgSundargarh (Sundergarh)SirohiVellore Ghaziabad BOUVET ISLAND SheikhpuraNeemuchSolapurSri Ganganagar ViluppuramGhazipurBRAZILSheoharPannaThaneTonk VirudhunagarGondaBRITISH INDIAN OCEAN TERRITORY SitamarhiRaisenWardhaUdaipur GorakhpurBRUNEI DARUSSALAMSiwanRajgarhWashimBULGARIASupaulRatlamYavatmalHardoi BURKINA FASOVaishaliRewaJalaunBURUNDIWest ChamparanSagarJaunpurCAMBODIASatnaJhansiCAMEROONSehoreJyotiba Phule NagarCANADASeoniKannauj CAPE VERDEShahdol Kanpur DehatCAYMAN ISLANDSShajapur Kanpur NagarCENTRAL AFRICAN REPUBLICSheopurKanshiram NagarCHADShivpuri KaushambiCHILESidhi KushinagarCHINA SingrauliLakhimpur KheriCHRISTMAS ISLAND TikamgarhLalitpurCOCOS (KEELING) ISLANDSUjjainLucknowCOLOMBIAUmariaMahamaya NagarCOMOROSVidisha MaharajganjCONGOMahoba COOK ISLANDSMainpuri COSTA RICAMathura COTE DIVOIREMauCROATIAMeerutCUBAMirzapurCYPRUS MoradabadCZECH REPUBLIC Muzaffarnagar$DEMOCRATIC PEOPLES REPUBLIC OF KOREAPanchsheel Nagar (Hapur)DENMARKPilibhitDJIBOUTIPrabuddha Nagar (Shamli)DOMINICADOMINICAN REPUBLIC RaebareliECUADORRampurEGYPT Saharanpur EL SALVADORSant Kabir NagarEQUATORIAL GUINEASant Ravidas NagarERITREA ShahjahanpurESTONIA ShravastiETHIOPIASiddharthnagarFALKLAND ISLANDS (MALVINAS)Sitapur FAROE ISLANDS SonbhadraFEDERATED STATES OF MICRONESIA SultanpurFIJIUnnaoFINLANDVaranasiFRANCE FRENCH GUIANAFRENCH POLYNESIAFRENCH SOUTHERN TERRITORIESGABONGAMBIAGEORGIAGERMANYGHANA GIBRALTARGREECE GREENLANDGRENADA GUADELOUPEGUAM GUATEMALAGUERNSEYGUINEA GUINEA-BISSAUGUYANAHAITI!HEARD ISLAND AND MCDONALD ISLANDSHOLY SEE (VATICAN CITY STATE)HONDURAS HONG KONGHUNGARYICELAND INDONESIAIRAQIRELANDISLAMIC REPUBLIC OF IRAN ISLE OF MANISRAELITALYJAMAICAJAPANJERSEYJORDAN KAZAKHSTANKENYAKIRIBATIKOREAKUWAIT KYRGYZSTANLAO PEOPLES DEMOCRATIC REPUBLICLATVIALEBANONLESOTHOLIBERIALIBYAN ARAB JAMAHIRIYA LIECHTENSTEIN LITHUANIA LUXEMBOURGMACAO MADAGASCARMALAWIMALAYSIAMALDIVESMALIMALTAMARSHALL ISLANDS MARTINIQUE MAURITANIA MAURITIUSMAYOTTEMEXICOMONACOMONGOLIA MONTENEGRO MONTSERRATMOROCCO MOZAMBIQUEMYANMARNAMIBIANAURUNEPAL NETHERLANDSNETHERLANDS ANTILLES NEW CALEDONIA NEW ZEALAND NICARAGUANIGERNIGERIANIUENORFOLK ISLANDNORTHERN MARIANA ISLANDSNORWAYOMANPAKISTANPALAUPALESTINIAN TERRITORYPANAMAPAPUA NEW GUINEAPARAGUAYPERU PHILIPPINESPITCAIRNPOLANDPORTUGAL PUERTO RICOQATARREPUBLIC OF MOLDOVAREUNIONROMANIARUSSIAN FEDERATIONRWANDASAINT BARTHELEMY SAINT HELENASAINT KITTS AND NEVIS SAINT LUCIA SAINT MARTINSAINT PIERRE AND MIQUELON SAINT VINCENT AND THE GRENADINESSAMOA SAN MARINOSAO TOME AND PRINCIPE SAUDI ARABIASENEGALSERBIASERBIA AND MONTENEGRO SEYCHELLES SIERRA LEONE SINGAPORESLOVAKIASLOVENIASOLOMON ISLANDSSOMALIA SOUTH AFRICA,SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDSSPAIN SRI LANKASUDANSURINAMESVALBARD AND JAN MAYEN SWAZILANDSWEDEN SWITZERLANDSYRIAN ARAB REPUBLICTAIWAN TAJIKISTANTHAILAND THE DEMOCRATIC REPUBLIC OF CONGO)THE FORMER YUGOSLAV REPUBLIC OF M91ýDONIA TIMOR-LESTETOGOTOKELAUTONGATRINIDAD AND TOBAGOTUNISIATURKEY TURKMENISTANTURKS AND CAICOS ISLANDSTUVALUUGANDAUKRAINEUNITED ARAB EMIRATESUNITED KINGDOMUNITED REPUBLIC OF TANZANIA$UNITED STATES MINOR OUTLYING ISLANDSUNITED STATES OF AMERICAURUGUAY UZBEKISTANVANUATU VENEZUELAVIET NAMVIRGIN ISLANDSWALLIS AND FUTUNAWESTERN SAHARAYEMENZAMBIAZIMBABWECIN Company NameNominal value of sharesInvestor First NameInvestor Middle NameInvestor Last NameFather/Husband First NameFather/Husband Middle NameFather/Husband Last NameAddressStateDistrictPin Code Folio NumberDP Id-Client Id-Account NumberNumber of shares (i)Install the pre-requisite softwares to proceed. The path for the same is as follows: MCA Portal >> Investor Services >> IEPF >> IEPF Application >> Prerequisite Software (ii) Upload the excel file in the format xls only (iii) Do not make any changes in the excel format/sheet name. Also do not delete any tab/sheet in the file PLEASE NOTE: 1) Kindly ensure that Summation of amounts in the excel(s) should be equal to that in IEPF Form, else your excel shall get rejected. 2) Kindly ensure that AGM Date in the excel(s) should be same as in IEPF Form, else your excel shall get rejected.   (i) Enter the CIN in the excel (cell B2) (ii) Click on "Prefill" button (iii) Company Name will be automatically filled on click of prefill button . User need not enter it. 9 B ] z ( (i) Fill in the required details in Columns A to P for Investor Details (row 15 onwards) (ii) Follow the below mentioned validations for filling in the details. First Name -> Mandatory if 'Last Name' is blank and Length should be less or equal to 35 characters. Middle Name -> Length should be less or equal to 35 characters. Investor Last Name -> Mandatory if 'First Name' is blank and Length should be less or equal to 35 characters. Father/Husband First Name -> Mandatory if 'Father/Husband Last Name' is blank and Length should be less or equal to 35 characters. Father/Husband Middle Name -> Length should be less or equal to 35 characters. Father/Husband Last Name -> Mandatory if 'Father/Husband First Name' is blank and Length should be less or equal to 35 characters. Address -> Mandatory and Length should be less or equal to 300 characters. Country -> Mandatory and Select value from the dropdown. State -> Mandatory and Select value from the dropdown. (1)If the Country is  INDIA , the state should Indian state (2)If the Country is other than INDIA state should be  NA . District -> Select value from the dropdown. (1)If the Country is  INDIA , the district should be Indian districts corresponding to the State selected in dropdown. (2)If the Country is other than INDIA district will be  NA Pin code -> Alphanumeric and Length should be eithe 6 or 12 dight Folio Number -> Mandatory and Length should be less than or equal to 20 characters<. Investment Type -> Select value from the dropdown. Amount Due -> Mandatory and should be greater than zero. Date of Event-> should be in DD-MON-YYYY format where 'MON' implies first three letters of Month. (iii) Click on "Validate" button (iii) Details of the Errors will be shown in "Error" Sheet. *Make sure that Error sheet contains no errors. % H `    ' U Path to upload the excel file is HOME -> IEPF SERVICES -> Upload Investor details. -Actual Date of transfer to IEPF (DD-MON-YYYY) Note: This sheet is applicable for uploading the particulars related to the shares transferred to Investor Education and Protection Fund. Make sure that the details are in accordance with the information already provided in e-form IEPF-4. KARNATAKAKUMAR JHARKHAND MAHARASHTRADELHI NEW DELHIKERALAGPRAKASHKJAINPRASADMADHYA PRADESHKHAN WEST BENGALVCHANDANDHRA PRADESH RAJASTHANSINGHBURDWANHSINHASRALI CHHATTISGARHREDDY UTTAR PRADESH CHITRADURGAMANIPURIMPHALHARYANAROHTAKAJAYBIHARDEVIRAMAPANWARANILHUBLIMOHAMMADVAISHNAVPAWANGURGAON JAMSHEDPURL74899HR1995PLC053860%ACTION CONSTRUCTION EQUIPMENT LIMITEDVASUDEV GOPALKRISHNAPAI>367/2, BARMASHEL PAMP HUBALLI RASTE, LEFT SIDE SIRSI KARNATAKASIRSIC12010600-12010600-00535077 02-MAY-2018 MANOJKUMARGOPALAKRISHNANNAIR=MANAKKADENPALLIL PALEMAD POST, MALAPURAM DT NILAMBUR KERALANILAMBURC12010900-12010900-03346815FARUQUE-1B/65, KATHARA P.O- KATHARA BOKARO JHARKHANDBOKAROC12010926-12010926-00207200ANJUMARAMD WASIMULHAQUE$MOH:-ALIGANJ ROAD NO:-22 GAYA BIHARGAYAC12016403-12016403-00009012NETLALLTKASHINATHPRASAD$M. G. AVENUE MANIPUR IMPHAL MANIPURC12021800-12021800-00019852ARTIGOUTAM3NARMADA GANJ, DIST. DINDORI DINDORI MADHYA PRADESHDINDORIC12023000-12023000-00773966TYAGIMAHAVIR/RAJ COLONY SAHARANPUR SAHARANPUR UTTAR PRADESH SAHARANPURC12029900-12029900-03764832YOGESHMALIKRAMPHAL.E 8 Green Wood City Sector 46 Gurgaon HaryanaIndiaC12029900-12029900-05710371 DINESHKUMAR JUGALKISHORRATHIPSATI COMMUNICATION JITA MATA CHOWK STATION ROAD AKOT DIST AKOLA AKOT MAHARASHTRAAKOTC12033200-12033200-00418816AJMERGHASHIRAM0HOUSE NO 1 WARD 28 SUBHASH NAGAR ROHTAK HARYANAC12033200-12033200-02169135NEMI31014, NEW COLONY, CHERITAL, JABALPUR JABALPUR M.P.JABALPURC12035000-12035000-00317597TOFFIKIRSHADMUKADAMDADAMIYABA/P 86 NEAR JAMA MASJID NEW KARLA RATNAGIRI RATNAGIRI MAHARASHTRA RATNAGIRIC12036000-12036000-00985062ANANDA BALCHANDRA BHAGAVATI5S B PATIL COLLEGE CAMPUS NAVANAGR BAGALKOT KARNATAKABAGALKOTC12038400-12038400-00731161RANJIT CHOUDHURY ACHYUTANANDA]AT KHERAS PART PO/DIST JAGATSINGHPUR NEAR CHARCHIKA TEMPLE JAGATSINGHPUR JAGATSINGHPUR ORISSAORISSA JAGATSINGHPURC12044700-12044700-06010583SUNITARAMESHWANDKAR=NOI3LAXMIPARK SANMAN CLY GOKUL ROAD OLD HUBLI HUBLI KARNATAKAC13041400-13041400-00062628PODDARHARI5ROAD NO D SONARI WEST LAYOUT HOUSE NO 190 JAMSHEDPURIN300214-IN300214-11251507 12-MAY-2018 RAMA MURTHY*4/513 DR Y S NAGAR CUDDAPAH ANDHRA PRADESHCUDDAPAHIN301022-IN301022-13497897RAMDASJAMNADASVED JAMANADASNARSHI7TRIBHUVANDAS PURUSHOTTAMDAS CO SUBHASH CHOWK JALGAONJALGAONIN301127-IN301127-16292957MOHDHASANBABUCHAWNI ASHRAF KHAN BAREILLYBAREILLYIN301186-IN301186-20119868MEERABANSHIDHARBAURI;VILL NAWADIH PO CHIKSIA BOKARO STEEL CITY BOKARO STEEL CITYIN301250-IN301250-29039406MANORAMASAXENASHAMSHERBAHADUR*KATRA WARD NO-12 BANDA UTTAR PRADESH BANDA GHAZIABADIN301653-IN301653-10154164RAHULRATAN0I 4A 1ST FLOOR GADWALI MOHALLA LAXMI NAGAR DELHIIN301774-IN301774-15348257 MOHANKUMAR GOPALAPILLAI>NO 700 KOCHILETHU 12 BHARANIKAVU MAVELIKKARA ALAPPUZHA, KERALA MAVELIKARAIN301895-IN301895-11037345 VENUGOPALSOMAYAJIANANTHA@M K EMPLOYEE AND ASTROLOGER HABIB SAB BUILDING DODDIBIDI HARIHARIN301926-IN301926-30813214 BRAHMAIAH RATHIKRINDA(MANAGER CANARA BANK C N ROAD BHADRAVATHI BHADRAVATHIIN301926-IN301926-30822627PINAKISARKARBISHTUSADHAN!BABURBAG RAJBATI PO DIST BURDWANIN302201-IN302201-10338439NISHANTTIWARI!QTR NO 212/5/A BALCO NAGAR KORBAKORBAIN302201-IN302201-10692447SHANKERGOKULDASG36/168 HARI NIWAS HARI OM WAY BRIDGE KI GALI NEAR GLASS FACTORY UDAIPURUDAIPURIN302201-IN302201-10830243SUDARSAN SANEPALLE SUBBAREDDYJDOOR NO 3 - 5 BOYANAPALLI (VILLAGE AND PO) DUVVUR MANDAL CUDDAPAH DIST, APIN302324-IN302324-10785587 aW ZgN[[v9\\G ]y]$]A^^u)__D``- ` [a a| 0b bN 8c c< d d5 d Se eo2ffBfg+gPhh?iiM%jj2j`k kv/ll<ltmmGnnKoioo}1ppUqq/qdrr_s sy3tt@tKuuPvevvyPww]=xx: yoyy_Nzz<-{{#{}|' }}.~~~{| tWȀW 0 #  o q b   ! ͅ\Bg, ښE)~ԛ? M%̞7G ʡ5 ' r 0 (Y+#Ϩ:`ccBOUj_ KU g2  c7  dMbP?_*+%,&ffffff?'ffffff?(?)?MR\\HYDHTCPRNTSRV02\HYDHTCB18F01tC odXXLetterDINU"0 D  0SMTJ IUPH"xjAM4Q"a` jźM&XXnkKLnۃR^}x+H}gd$?Ő,|v|)^E*RX Ikew][~*_^^a&j#~X>S&&)/M;~a$d)'*3ӽm(w{. )6>@B|UeM)=w_ӫj%m-sK _a]A ҉}EYD _ o&,AF ݪM?ky/n?|4EU ;X'K[nSVA= sx.e%*XaZL #3J˯Vkv%g;KV˭Gzl~޿.u>:b.:}-   F&]W$~z" dXX333333?333333?&<3cU} I'X} I|X} X Y  [ J,  ii Y Z jk \ ] Y ] Y ] ^ ] \ ZPH0(  >@ Sheet4gg g2 8/ &.6? GOR  dMbP?_*+%,&ffffff?'ffffff?(?)?M:\\hydhtcb18b19ps\HYDHTCB18F01W\C odXXLetterDINU"8t > Y C 8SMTJ(HP Universal Printing PCL 6 (v5.1)InputBinFORMSOURCERESDLLUniresDLLHPDocUISUITrueESPRITSupportedTrueFastRes1bppResolution600dpiPrintQualityGroupPQGroup_2HPColorSmartAutomaticHPColorSmart_ColorOptions_EdgeControlDefault_NormalHPColorSmart_ColorOptions_HalftoneDefault_DetailHPColorSmart_Text_NeutralGraysDefault_BlackOnlyHPColorSmart_Text_HalftoneDefault_DetailHPColorSmart_Text_RGBColorDefault_Default(sRGB)HPColorSmart_Graphics_NeutralGraysDefault_BlackOnlyHPColorSmart_Graphics_HalftoneDefault_DetailHPColorSmart_Graphics_RGBColorDefault_Default(sRGB)HPColorSmart_Photo_NeutralGraysDefault_4-ColorHPColorSmart_Photo_HalftoneDefault_DetailHPColorSmart_Photo_RGBColorDefault_Default(sRGB)OrientationPORTRAITHPOrientRotate180FalseDuplexVERTICALHPPrintOnBothSidesManuallyFalsePaperSizeA4HPConsumerCustomPaperTrueMediaTypeAUTOCollateONHPNUseDiffFirstPageChoiceTRUEHPPageExceptionsFileHPCPE104HPPageExceptionsInterfaceShowPageExceptionsHPPageExceptionsLowEndHPPageExceptionsLowEndVerHPPageExceptionsCoverInsertionHPOutputBinOrientationF91ýDOWNStaplingNoneHPStaplingOpposedFalseEconomodeFalseTextAsBlackFalseAlternateLetterHeadFalseHPSmartHubInet_SID_263_BID_514_HID_265OutputBinAutoHPDocPropResourceDatahpchl104.cabHPLpiSelectionNoneJPEGEnableAutoHPEasyColorOnHPMHDLLNameHPFIE104HP_DIBStitch_TintTestDisabledHPMediaTypeTreeviewPopupTrueHPColorModeCOLOR_MODEColorMode24bppTTAsBitmapsSettingTTModeOutlineHPPDLTypePDL_PCL6HPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNT_GROUPNAMEHPBornOnDateHPBODHPColorPlaneHPCPHPJobByJobOverrideJBJOHPJobAccWoPinTrueHPXMLFileUsedhpcu1046.xmlHPSmartDuplexSinglePageJobTrueHPDuplicateJobNameOverrideSWFWHPEnableRAWSpoolingTrueRGBColorDefault-sRGBJRConstraintsJRCHDFullJRHDInstalledJRHDOffJRHDNotInstalledJRHDOffHPBestGlossDefaultPSAlignmentFileHPCLS104IUPHxkAߦ*zB.z, v3iѮm fH" _Ifi~fefdf潝7"ig/#v̈́ɝPR¯mNy HMz1)RE~Yzs?1fR˶T!<t7.lTE5!#ar/Z֑fҴ+{Ҽ3hNbFg/u!9ِ,J AC6f{_SUy;Հz.K~)r$mK4 rEȜilZ#FkXkH%y5L A3BHG!Co1g9U$qQmԓnm87fd Ϟ5:%{2d}FMev1: ϫ2~aIg_e֮7;zrK ^iel񬛕_E^Zص뒂FI$/aY ɇ^K.RqԯEN}oc\Hz~nfc]PŻ:TC懩Ͼu՚ !B!r Uw" dXX333333?333333?&<3cU} ma} ma} a} ma} a} $_} _} $_} d} a} a} e} $`} ma} $ _/P,P,P,P,P,P,P,PP , , , , ,,,,,,,,,,,,,,,,,,, ttttttttttttt Q lm Q n op c b q qqr~ s@s b b b b b R R R R R R R R R  R  T  R  R  R S T f f f f f f f f2 f f~ f4!A f f fI@gY@ h f f f f f f f f2 f f~ fv) f f fD@gT@ h f f f f f f f f2 f f~ fxM)A f f f4@gD@ h f f f f f f f f2 f f~ ff;2 f f fG@gW@ h f f f f f f f f2 f f~ f0 f f fi@gy@ h f ff f f f f f2 f  f~  f`iA f  f fI@gY@ h f f f f ff f f2 f  f~  f&A f  f f@g@ h f ff f ff f f f  f~  f@ f  f  f |@g @ h f  f  f  f  f f f  f2 f  f~  fA f  f f.@g>@ h f ff f ff f f2 f  f~  fF@ f  f f@g$@ h f f f f f f f f2 f  f~  fDkA f  f f$@g4@ h f f f f f f f f2 f  f~  f]A f  f fI@gY@ h f  f! f" f1 ff f# f2 f  f$~  ff# f  f% f.@g>@ h f& f f' f( f'f f) f2 f*  f+~  f. f  f, fV@gf@ h f- f. f/ f. f/f f0 f2 f  f~  fp!A f  f1 fR@gb@ h f f f2 f3 f f2 f4 f2 f  f~  f2 f  f5 fP@g`@ h6 f f f7 f1 ff f8 f2 f  f9~  f~A f  f: fY@gi@ h6 f; f< f= f> f? f= f@ f2 f  fA~  fA f  fB f9@gI@ h6 fC fD f fE ff fF f2 f  fG~  fȩ A f  fH fA@gQ@ h6 fI ff fJ fK fL fM f2 f  f~  fy2 f  fN fY@gi@ h6 fO fPf fQ fR fP fS f2 f  fT~  fHA f  fU f@g$@ h6 fV f f fW f f fX f2 f  f~  f@ f  fY f@g$@ h6 fZ ff f[ ff f\ f2 f  f]~  f%* f  f^ f4@gD@ h6Dl0Z @  ,!,",#,$,%,&,',(,),*,+,,,-,.,/,0,1,2,3,4,5,6,7,8,9,:,;,<,=,>,?, f_ f f` fa f` f fb f2 f f~ fA# f fc fI@gY@ h6 !fd !f!f !f !f !fe !ff !f2 !f ! fg~ ! fV<#! f ! fh! fi@gy@ !h6 "fi "fj"f "fk "fl "fj "fm "f2 "f " f~ " f %A" f " fn" f@_@g@o@ "h6 #fo #fp#f #f #fE #fp #fq #f2 #f # fr~ # fAA# f # fs# fK@g[@ #h6 $f3 $ft $f $fu $fv $f $fw $f2 $f $ fx~ $ fA$ f $ fy$ f@g @ $h6 %f %fz %f %f{ %f %f| %f} %f2 %f % f9~ % f~A% f % f~% fI@gY@ %h6&&ffffffffffffffgh&'ffffffffffffffgh&(ffffffffffffffgh&)ffffffffffffffgh&*ffffffffffffffgh&+ffffffffffffffgh&,ffffffffffffffgh&-ffffffffffffffgh&.ffffffffffffffgh&/ffffffffffffffgh&0ffffffffffffffgh&1ffffffffffffffgh&2ffffffffffffffgh&3ffffffffffffffgh&4ffffffffffffffgh&5ffffffffffffffgh&6ffffffffffffffgh&7ffffffffffffffgh&8ffffffffffffffgh&9ffffffffffffffgh&:ffffffffffffffgh&;ffffffffffffffgh&<ffffffffffffffgh&=ffffffffffffffgh&>ffffffffffffffgh&?ffffffffffffffghD l*************************@,A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z,[,\,],^,_,&@ffffffffffffffgh&Affffffffffffffgh&Bffffffffffffffgh&Cffffffffffffffgh&Dffffffffffffffgh&Effffffffffffffgh&Fffffffffffffffgh&Gffffffffffffffgh&Hffffffffffffffgh&Iffffffffffffffgh&Jffffffffffffffgh&Kffffffffffffffgh&Lffffffffffffffgh&Mffffffffffffffgh&Nffffffffffffffgh&Offffffffffffffgh&Pffffffffffffffgh&Qffffffffffffffgh&Rffffffffffffffgh&Sffffffffffffffgh&Tffffffffffffffgh&Uffffffffffffffgh&Vffffffffffffffgh&Wffffffffffffffgh&Xffffffffffffffgh&Yffffffffffffffgh&Zffffffffffffffgh&[ffffffffffffffgh&\ffffffffffffffgh&]ffffffffffffffgh&^ffffffffffffffgh&_ffffffffffffffghDl*******************************`,a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z,{,|,},~,,&`ffffffffffffffgh&affffffffffffffgh&bffffffffffffffgh&cffffffffffffffgh&dffffffffffffffgh&effffffffffffffgh&fffffffffffffffgh&gffffffffffffffgh&hffffffffffffffgh&iffffffffffffffgh&jffffffffffffffgh&kffffffffffffffgh&lffffffffffffffgh&mffffffffffffffgh&nffffffffffffffgh&offffffffffffffgh&pffffffffffffffgh&qffffffffffffffgh&rffffffffffffffgh&sffffffffffffffgh&tffffffffffffffgh&uffffffffffffffgh&vffffffffffffffgh&wffffffffffffffgh&xffffffffffffffgh&yffffffffffffffgh&zffffffffffffffgh&{ffffffffffffffgh&|ffffffffffffffgh&}ffffffffffffffgh&~ffffffffffffffgh&ffffffffffffffghDl*******************************,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffghDl*******************************,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffghDl*******************************,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffghDl*******************************,,,,,,,,,  !"#$%&'()*+,./0123456789:;<=>?2iwDocumentLibraryFormDocumentLibraryFormDocumentLibraryForm,,,,,,,,,,,,,,,,,,,,,,,&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffghDl*******************************,,,,,,,,, , , , , ,,,,,,,,,,,,,,,,,,,&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh& ffffffffffffffgh& ffffffffffffffgh& ffffffffffffffgh& ffffffffffffffgh& ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffgh&ffffffffffffffghDl******************************* ,!,",#,$,%,&,',(,),*,+,,,-,.,& ffffffffffffffgh&!ffffffffffffffgh&"ffffffffffffffgh&#ffffffffffffffgh&$ffffffffffffffgh&%ffffffffffffffgh&&ffffffffffffffgh&'ffffffffffffffgh&(ffffffffffffffgh&)ffffffffffffffgh&*ffffffffffffffgh&+ffffffffffffffgh&,ffffffffffffffgh&-ffffffffffffffgh&.ffffffffffffffgh"**************:# ""#(    l A ?@AA?CommandButton15 ]`0 6$Forms.CommandButton.1H"  s HA ?@CommandButton2"ÊPK!4xP[Content_Types].xmlN0EH-J@5XIbl$M$J7Xܹc/W;kc|QV^icRs28;_5W>`bv}A${JQBcD۪һ.y1=(| P7X\A?IED$2Ml:*&cMuH7Ð`ҽ0V!WD.CTBEѦy(7=AVKT^n,Ͱ:3qyl3?4?PK!0?2 _rels/.rels 0nzUd$dۛ xeof1Fw AN{c]t- 838zG 6Y}S~XRHz \v:'L /ؓ\JO4_L7 T ϐ}YM[#B,#1цhEU Z~-m^PK!clipboard/drawings/drawing1.xmlN0H4l)Dh) Z A XK-o8qKBgx/J;/(kfjۊ}qJkFrO/Pl'A%T YY#cF_cGfHV2+$S 4 Y94 =xDJV$} o}K~鈨+ӠE4KlUX7Nx4d]x#1-~9:I>R_NbuXCJ# ~)~ŦQ *'OrDE忼,`1.SۇRk!e4G1bCWapK}'ĕ\=sS'>8X6eT+˧_ :nQ$ O6!C Gf !iaoPK!SRa*clipboard/drawings/_rels/drawing1.xml.relsJ1 Prكlg/"UmS⾽ս8K qU\jHb`(\o|6Gk6p f+~T#b G:eSz[MԯN&I(!}y{ڃC"$qǫ^x>8xwFK xL:ޜH]>ɘc1$"rwPdcmM@2OH Ϧ\DX&*ZimGfCP#~{:>1ɴ#пų<9G#@yaAǫ?omH1bma)q.:hl e\9?Z]<j7Ye޽Jp%nNuL ^6Vc KFwk9x~pjx :A=L9)|(Ȇ<)ժ\}.@'d}Ƃb-o\xbI\"iYH&}+@^='?ѣ?Z^Ņ/ϯ?Fٓ_}wK[DfjN|+F! }:[sp]:ﮀQ>: L7rκ\:UhŬLvNhf{!qc8V8 1QH?XwRǯ\B(bZ;XC#˼fݻYEBA`V0ǍLᨌGXeJ/RA8Oekn UiwV/43HKv@AZ'KɤYYצZY_=lY}NgÙ+Ωŋtvaזٓ% iv1)4>(A|VӴ|ga~xEF疒caQ3LFiA_N˝P&JT/~PK !#@4FFclipboard/media/image1.pngPNG  IHDR.¸sRGBgAMA a pHYs&?IDATx^q0@QT6 M(rf"X78 I,Q6qض-pAP!BB *"T D@P!BBf16&>;E}W>GnM3皏I/!V&.+⯒8[(L jɇZ)qD_ߪ]8\ R&>G\:? !/91boD;6ۚ q]l4%M|S<#Ĩ ʭ]8!x5D譨_wѷSOhԇ?LbBmLxSosֶM)ѷ;.P9!**"T D@P!BB *"TCNGz "qȲC܏IENDB`PK-!4xP[Content_Types].xmlPK-!0?2 E_rels/.relsPK-!/clipboard/drawings/drawing1.xmlPK-!SRa*'clipboard/drawings/_rels/drawing1.xml.relsPK-!Z=Aclipboard/theme/theme1.xmlPK- !#@4FFG clipboard/media/image1.pngPKZM]` 1 6$Forms.CommandButton.1HH<"  s HA ?@CommandButton3"ÊPK!4xP[Content_Types].xmlN0EH-J@5XIbl$M$J7Xܹc/W;kc|QV^icRs28;_5W>`bv}A${JQBcD۪һ.y1=(| P7X\A?IED$2Ml:*&cMuH7Ð`ҽ0V!WD.CTBEѦy(7=AVKT^n,Ͱ:3qyl3?4?PK!0?2 _rels/.rels 0nzUd$dۛ xeof1Fw AN{c]t- 838zG 6Y}S~XRHz \v:'L /ؓ\JO4_L7 T ϐ}YM[#B,#1цhEU Z~-m^PK!clipboard/drawings/drawing1.xmlN0H4l)Dh) Z A XK-o8qKBgx/J;/(kfjۊ}qJkFrO/Pl'A%T YY#cF_cGfHV2+$S 4 Y94 =xDJV$} o}K~鈨+ӠE4KlUX7Nx4d]x#1-~9:I>R_NbuXCJ# ~)~ŦQ *'OrDE忼,`1.SۇRk!e4G1bCWapK}'ĕ\=sS'>8X6eT+˧_ :nQ$ O6!C Gf !iaoPK!SRa*clipboard/drawings/_rels/drawing1.xml.relsJ1 Prكlg/"UmS⾽ս8K qU\jHb`(\o|6Gk6p f+~T#b G:eSz[MԯN&I(!}y{ڃC"$qǫ^x>8xwFK xL:ޜH]>ɘc1$"rwPdcmM@2OH Ϧ\DX&*ZimGfCP#~{:>1ɴ#пų<9G#@yaAǫ?omH1bma)q.:hl e\9?Z]<j7Ye޽Jp%nNuL ^6Vc KFwk9x~pjx :A=L9)|(Ȇ<)ժ\}.@'d}Ƃb-o\xbI\"iYH&}+@^='?ѣ?Z^Ņ/ϯ?Fٓ_}wK[DfjN|+F! }:[sp]:ﮀQ>: L7rκ\:UhŬLvNhf{!qc8V8 1QH?XwRǯ\B(bZ;XC#˼fݻYEBA`V0ǍLᨌGXeJ/RA8Oekn UiwV/43HKv@AZ'KɤYYצZY_=lY}NgÙ+Ωŋtvaזٓ% iv1)4>(A|VӴ|ga~xEF疒caQ3LFiA_N˝P&JT/~PK !#@4FFclipboard/media/image1.pngPNG  IHDR.¸sRGBgAMA a pHYs&?IDATx^q0@QT6 M(rf"X78 I,Q6qض-pAP!BB *"T D@P!BBf16&>;E}W>GnM3皏I/!V&.+⯒8[(L jɇZ)qD_ߪ]8\ R&>G\:? !/91boD;6ۚ q]l4%M|S<#Ĩ ʭ]8!x5D譨_wѷSOhԇ?LbBmLxSosֶM)ѷ;.P9!**"T D@P!BB *"TCNGz "qȲC܏IENDB`PK-!4xP[Content_Types].xmlPK-!0?2 E_rels/.relsPK-!/clipboard/drawings/drawing1.xmlPK-!SRa*'clipboard/drawings/_rels/drawing1.xml.relsPK-!Z=Aclipboard/theme/theme1.xmlPK- !#@4FFG clipboard/media/image1.pngPKq@]` 1 6$Forms.CommandButton.1H>@  %*    Invalid Input3Please select a valid State from the drop-down list0lINDIA  , NAB" %&M  Invalid CINPlease enter a valid CINatm k  Input Errpr.You cannot enter Name more than 35 characters. l#& %n  Input Error1You cannot enter Address more than 300 characters#,& %s  Invalid Input5Please select a valid Country from the drop-down list##& %  Invalid Input6Please select a valid District from the drop-down list##L Bx"& %Z  Inout ErrorPlease enter a valid Pin Codet th & %   Input ErrorIFolio Number should be alphanumeric and less than or equal 20 characters.B& % | Input ErrorhDP Id-Client Id-Account Number should be alphanumeric and of length less than or equal to 60 characters.<%& %   Input ErrorNPlease enter valid Number of Shares. Values can range from (1-999999999999999) e to3&k C& %   Input ErrorVPlease enter the proper Nominal Value of Shares ranging from 0.01 to 9999999999999.99 o{Gz? ?0B& % r  Input Error5Please enter the Date of Event in the required format f.0 & %h  Input Error3Please enter the Date of AGM in the required format   Sheet1gg@ g2   dMbP?_*+%,&ffffff?'ffffff?(?)?",333333?333333?as&<3U} IPH0 0(   >@   Sheet2gg g2 0lj2.+  dMbP?_*+%,&ffffff?'ffffff?(?)?",333333?333333?&<3cU} m1M} M} $M} IM} M} $M}  M} M} M} M} M} M} M} M} M} $M} IM} M} $ M} M} mM} M} M}  M}  M} mM}  M} M} M} m M} M} !!I M} "" M} ##$ M} $$mM} %%M} &&$ M} ''+M} ($ M,,,,;,;,;,;,;,;,;,, ,, ,, ,, ,, ,,,,,,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*, J J J J K K K K K K K K K K K K K K K K K K K K! K" K# K$ K% K& K' K( K) K* !K+ "K, #K- $K. %K/&J 'U0(J~ )L@*J +J1 N2 N N3 N4 N5 N6 N7 N N8  N9  N:  N;  N<  N= N> N? N@ NA NB NC N1 ND NE NF NG NH NI NJ N1 NK NL NM  NN !NO "NP #NQ $NR %NS&N 'VT (NO) +M1 NU N NV NW NX NY NZN N? N  N[  N  N\  N] N^ N_ N` Na Nb NcN Nd Ne Nf Ng Nh Ni NjN Nk Nl Nm  Nn !N "No #Np $Nq %Nr&N 'Vs (NN) Nt NN Nu Nv Nw NxN Ny  NN  Nz N  N{ N| N} N~ N N NN N N N N N N NN N N N  N !N "N #N $N %N&N 'V (NN) N NN N N N NN N  NN  N N  N N N N N N NN N NZ N N N N NN N N N  N !N "N #N $N %N&N 'V (NN) N NN N N N NN N  NN  N N  N N N N N N NN N N N N N N NN N NN  N !N"N #N $N %N&N 'V (NN) N NN N N N NN N  NN  N N  N N N N N N NN N N N N N N NN N NN  N !N"N #N $N %N&N 'V (NN) N NN N N N NN N  NN  N N  N N N N N N NN N N N N N N NN N NN  N !N"N #N $N %N&N 'V (NN) N NN N  N  N  N N N   NN  N N  N N N N N N NN N N NN N N NN N NN  N !N:"N #N  $N! %N"&N 'W# (NN) N$ N N N% N& N' N( N N) NN N* N N+ N, N- N. N/ N0 N1 N N2 N3 N4 NN N5 N6 N N7 N8 N N9 !NT "N #N; $N< %N= &N 'W> (NN) N? N N N@ NA NB NC N ND NN NE N NF NG NH NI NJ NK NL N NM NN NNN NO NP N NQ NR N NS !Nl "N #NU $NV %NW &NNNN) NX N N NY NZ N[ N\ N N] NNNN N^ N_ N` Na Nb Nc Nd N Ne Nf NNN Ng Nh N Ni Nj N Nk "N #Nm $Nn %No &NNNN) Np N N Nq Nr Ns Nt N Nu NN  N Nv Nw Nx Ny Nz N{ N| N N} N~ NNNN N N N N N N !NN" #N $N %N &NNNN) N N N N N N N N N NNNN N N N N N N N N N N NNNN N N N N N N !NN" #N $N %N &NNNN) N N NN N N NN N NNNN  N NN N N N NN N NNNNN NN N NN  N !NN" #N$N %N&NNNN) N N NN N N NN N NNNN  N N NN N N NN N NNNNN NN N NN  N !NN" #N$N %N&NNNN) N N NNN N NN N NNNN  N N NN N N NN N NNNNN NN N NN  N !NN" #N$N %N&NNNN) N N NNN N NNNNNNN  N N NN N N NN N NNNNN NN N NN  N !NN" #N$N %N&NNNN) N N NNN N NNNNNNN  N N NN N N NN N NNNNN NN N NN  N !NN" #N$N %N&NNNN) N N NNN N NNNNNNN  N N NN N N NN N NNNNN NN N NN  N !NN" #N$N %N&NNNN) N N NNN N NNNNNNN  N N NN N N NN N NNNNN NN N NN  N !NN" #N$NNNNNN) N  N NNN N  N NNNNNN  N  NNN N  N NN N NNNNN NN N NN  N !NN" #N$NNNNNN) N N! NNN N NNNNNNN  N NNN N N NN N NNNNN N NN NN  N  !NN" #N!$NNNNNN) N" N" NNN N# N$NNNNNN  N%NNNN N& NN N' N(NNNN N) NN N*N  N+ !NN" #N,$NNNNNN) N- N#NNNN N.NNNNNN  N/NNNN N0 NN N1 N2NNNN N3 NN N4N  N5 !NN" #N6$NNNNNN) N7 N$NNNN N8NNNNNN  N9NNNN N: NN N; N<NNNN N= NN N>N  N? !NN" #N@$NNNNNN) NA N%NNNN NBNNNNNNNNNNN NC NN ND NENNNN NF NN NGN  NH !NN" #NI$NNNNNN) NJ N&NNNN NKNNNNNNNNNNN NL NN NM NNNNNN NO NN NPN  NQ !NN" #NR$NNNNNN) NS N'NNNN NTNNNNNNNNNNN NU NN NV NWNNNN NX NN NYN  NZ !NN" #N[$NNNNNN) N\ N(NNNN N]NNNNNNNNNNN N^ NN N_ N`NNNN Na NN NbN  Nc !NN" #Nd$NNNNNN) Ne N)NNNN NfNNNNNNNNNNN Ng NN Nh NiNNNN Nj NN NkN  Nl !NN" #Nm$NNNNNN) Nn N*NNNN No"NNNNNNNNNNNNNN Np NqNNNNNNN NrN  Ns !NN" #Nt$NNNNNN)D5l\H* rrr^RH<00 *,!*,"*,#*,$*,%*,&*,'*,(*,)*,**,+*,,*,-*,.*,/*,0*,1*,2*,3*,4*,5*,6*,7*,8*,9*,:*,;*,<*,=*,>*,?*, Nu N+ NNNN Nv" NNNNNNNNNNNNNN Nw Nx NNNNNNN Ny N Nz !NN" #N{ $NNNNNN) !N| !N,!NNNN !N}"!NNNNNNNNNNNNNN !N~ !N!NNNNNNN !N!NNNN" !#N!$NNNNNN) "N "N-"NNNN "N""NNNNNNNNNNNNNN "N "N"NNNNNNNNNNNN" "#N}"$NNNNNN) #N #N.#NNNN #N"     ."#$%&'()*+,-/1;23456789:<E=?@ABCDFKGHIJf}MPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~#NNNNNNNNNNNNNN #N #N#NNNNNNNNNNNN" ##N#$NNNNNN) $N $N/$NNNN $N"$NNNNNNNNNNNNNN $N $NNNNNNNNNNNNN" $#N$$NNNNNN) %N%NNNNN %N"%NNNNNNNNNNNNNN %N %NNNNNNNNNNNNN" %#N%$NNNNNN) &N,&NNNNNNNNNNNNNNNNNNN &N &NNNNNNNNNNNNN" &#N&$NNNNNN) 'N,'NNNNNNNNNNNNNNNNNNN 'N 'NNNNNNNNNNNNN" '#N'$NNNNNN) (N,(NNNNNNNNNNNNNNNNNNN (N (NNNNNNNNNNNNN" (#N($NNNNNN) )N,)NNNNNNNNNNNNNNNNNNN )N )NNNNNNNNNNNNN" )#N)$NNNNNN) *N,*NNNNNNNNNNNNNNNNNNN *N *NNNNNNNNNNNNN" *#N*$NNNNNN) +N,+NNNNNNNNNNNNNNNNNNN +N +NNNNNNNNNNNNN" +#N+$NNNNNN) ,N,,NNNNNNNNNNNNNNNNNNN ,N ,NNNNNNNNNNNNN" ,#N,$NNNNNN) -N,-NNNNNNNNNNNNNNNNNNN -N -NNNNNNNNNNNNN" -#N-$NNNNNN) .N,.NNNNNNNNNNNNNNNNNNN .N .NNNNNNNNNNNNN" .#N.$NNNNNN) /N,/NNNNNNNNNNNNNNNNNNN /N /NNNNNNNNNNNNN" /#N/$NNNNNN) 0N,0NNNNNNNNNNNNNNNNNNN 0N 0NNNNNNNNNNNNN" 0#N0$NNNNNN) 1N,1NNNNNNNNNNNNNNNNNNN 1N 1NNNNNNNNNNNNN" 1#N1$NNNNNN) 2N,2NNNNNNNNNNNNNNNNNNN 2N 2NNNNNNNNNNNNN" 2#N2$NNNNNN) 3NH3NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" 3#N3$NNNNNN) 4NH4NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" 4#N4$NNNNNN) 5NH5NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" 5#N5$NNNNNN) 6NH6NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" 6#N6$NNNNNN) 7NH7NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" 7#N7$NNNNNN) 8NH8NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" 8#N8$NNNNNN) 9NH9NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" 9#N9$NNNNNN) :NH:NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" :#N:$NNNNNN) ;NH;NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" ;#N;$NNNNNN) <NH<NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" <#N<$NNNNNN) =NH=NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" =#N=$NNNNNN) >NH>NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" >#NG>$NNNNNN) ?NH?NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" ?#N?$NNNNNN)Dl~~~~~~~~~~~~@*,A*,B*,C*,D*,E*,F*,G*,H*,I*,J*,K*,L*,M*,N*,O*,P*,Q*,R*,S*,T*,U*,V*,W*,X*,Y*,Z*,[*,\*,]*,^*,_*, @NH@NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" @#N@$NNNNNN) ANHANNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" A#NA$NNNNNN) BNHBNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" B#NB$NNNNNN) CNHCNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" C#NC$NNNNNN) DNHDNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" D#ND$NNNNNN) ENHENNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" E#NE$NNNNNN) FNHFNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" F#NF$NNNNNN) GNHGNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" G#NG$NNNNNN) HNHHNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" H#NH$NNNNNN) INHINNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" I#NI$NNNNNN) JNHJNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" J#NJ$NNNNNN) KNHKNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" K#NK$NNNNNN) LNVLNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) MNVMNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NNVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) ONVONNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) PNVPNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) QNVQNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) RNVRNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) SNVSNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) TNVTNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) UNVUNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) VNVVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) WNVWNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) XNVXNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) YNVYNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) ZNVZNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) [NV[NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) \NV\NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) ]NV]NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) ^NV^NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) _NV_NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN)Dl~~~~~~~~~~~~hhhhhhhhhhhhhhhhhhh`*,a*,b*,c*,d*,e*,f*,g*,h*,i*,j*,k*,l*,m*,n*,o*,p*,q*,r*,s*,t*,u*,v*,w*,x*,y*,z*,{*,|*,}*,~*,*, `NV`NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) aNVaNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) bNVbNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) cNVcNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) dNVdNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) eNVeNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) fNVfNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) gNVgNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) hNVhNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) iNViNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) jN VjNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) kN VkNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) lN VlNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) mN VmNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) nN VnNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) oNVoNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) pNVpNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) qNVqNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) rNVrNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) sNVsNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) tNVtNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) uNVuNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) vNVvNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) wNVwNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) xNVxNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) yNVyNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) zNVzNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) {NV{NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) |NV|NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) }NV}NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) ~NV~NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN)Dlhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*, NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N!VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N"VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N#VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N$VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N%VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N&VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N'VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N(VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N)VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N*VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N+VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N,VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N-VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N.VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N/VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N0VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N1VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N2VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N3VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N4VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N5VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N6VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N7VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N8VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N9VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N:VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N;VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N<VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N=VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N>VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN)Dlhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*, N?VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N@VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NAVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NBVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NCVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NDVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NEVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NFVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NGVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NHVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NIVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NJVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NKVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NLVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NMVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NNVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NOVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NPVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NQVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NRVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NSVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NTVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NUVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NWVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NXVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NYVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NZVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N[VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N\VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N]VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N^VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN)Dlhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*, N_VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N`VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NaVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NbVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NcVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NdVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NeVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NfVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NgVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NhVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NiVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NjVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NkVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NlVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NmVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NnVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NoVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NpVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NqVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NrVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NsVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NtVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NuVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NvVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NwVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NxVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NyVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NzVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N{VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N|VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N}VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N~VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN)Dlhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*, NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN)2$ hhhhhhhhhhhhhhhhhhhhhhPH@0(  >@! !! Sheet3gg g2 3-  dMbP?_*+%,&ffffff?'ffffff?(?)?",333333?333333?&<3UPHP0(  >@ Sheet5ggD This value indicates the number of saves or revisions. The application is responsible for updating this value after each revision. ns:ds="http://schemas.openxmlformats.org/officeDocument/2006/customXml">'f#xThisWorkbookSheet1- __SRP_2X@__SRP_3iKME (SLSS<N0{00020819-0000-0000-C000-000000000046}@(%H@0WxAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2`p U&cTEiIct FGۋxDw{Xux,CommandButton1, 1, 0, MSForms, CommandButton,CommandButton2, 2, 1, MSForms, CommandButton,CommandButton3, 3, 2, MSForms, CommandButtonGۋxDw{XuEiIctMEPSLSSs6" <<N0{00020820-0000-0000-C000-000000000046} ,@`  0`P|k 4`  8`  (% %*h@l0@ %*Hx`@ %*4`@@8h%*H%2pppppp8 X` W*\R8004*#5d$*\Rffff*0;5ce124c5$*\Rffff*0<5ce124c68<8DhL"  " ( " 08@ " H XP* A.oh@A2oPA6o8QWorksheets("Investor Details").Protect Password:="pass", UserInterfaceOnly:=FalsepassInvestor Details$:B@<o Attribute VB_Name = "She@et1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2ControlCommandButton1, 0, MSForms,  #2, $;#3, $#PAC SubK*1_Click() Call _fill_WS1 EndA 2`Validc3APClearWorks_AcXtiv@0's@("Inveyr Details").Protect Password:="p", UserI nterf@Only:=F˛(CSMrU  8! aI `<  0` D! a `1 L! a`q Ey1?0   <   $( 0   0   @ H 4 DL8<wrU X$)`$i`$`$ ` @l@ @xH @`4n|#Sheet2 o__SRP_6L__SRP_7gSheet3 <6kCG}ӌ FI]~BQ^"ΈxI]~BQ^"Έ6kCG}ӌME(SLSS6"N0{00020820-0000-0000-C000-000000000046} 8` `h@% %> % @@x@d`pW$*\Rffff*0=5ce124c64" X ` QWorksheets("Investor Details").Protect Password:="pass", UserInterfaceOnly:=FalsepassError$:B@<oxp6Attribute VB_Name = "She@et2" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$BustomlizD2P Sub Works_ActivA () ' s("Inve$r Details").Protect Password:="p", UserInterfOnly:=M+)Error#F(>EndM rU   4  0` 0   4XrU @$``n|#<FP F/pZH^jx/pZH^jѲFPME(SLSS6"N0{00020820-0000-0000-C000-000000000046} 8` `h@% %@ % @@x@d`pW$*\Rffff*0>5ce124c74" X ` QWorksheets("Investor Details").Protect Password:="pass", UserInterfaceOnly:=FalsepassSheet3$:B@<oxp2Attribute VB_Name = "She@et3" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$BustomlizD2P Sub Works_ActivA () ' s("Inve$r Details").Protect Password:="p", UserInterfOnly:=M+o)$(?EndN rU i6 6 4  0` 0   4XrU @$__SRP_8 L__SRP_9gSheet4Sheet5``n K;#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}x 8h@%@@pW" X"` QWorksheets("Investor Details").Protect Password:="pass", UserInterfaceOnly:=FalsepassRead Me$:B@<xoph8Attribute VB_Name = "She@et4" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$BustomlizD2P Sub Works_ActivA () ' s("Inve$r Details").Protect Password:="p", UserInterfOnly:=M+)Read Me$( ?End N 'V#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0WxAttribute VB_Name = "She@et5" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2Module1OI__SRP_4n__SRP_5_VBA_PROJECTp$*\R1*#98*\R1*#42*\R1*#90*\R0*#2*\R0*#14*\R0*#9*\R0*#13;  (08@HPX`hpx   "               ( 0 8 @ H P X  7` ;  4U4U  (0F8+h2A &+2A@H L4ijD|\xMEH@(<<f> d`@\`BT`DL . ` EEz `H% dhInva%`h l`j Err`|ror!`A@  `xR0o i0 iP estoip nvesi"Ss" P ` i lls.i ell)ix0 etaii"$: 6 `   `5k ::i passi <i:@z\ `DT Det|0 P x   ` ;;i Invei8 i5:O6@z `!`B@| P  ` `ZkP ``'ip i i@z\ `T `L| H( 0 `0[ row`P l`` X `Xbk >>iolCoi010))i@z\ `DTvest|PP!  `  i8iXi'@z x H`p_`k i`Erroi colir La@z\ anda `:`k ii8ie@z\ x `<Pk@  i`r Lai= Fiei` @z\  p`?`k $iei8imber@z\ 10 o (`B`k ;i nii@z\ e `E`kh Riiither@z\ Id-C  `H`k  ii@i`i @z\ e `U4k i lini ir or@z\ ount`DT'|8P @@  `  $$i8 iXieldi@z `D|Stop H@J@N( @Tx@X @^, @b4 @hh@@lH@HPx(h P x  pxX @8(0 8XFXPphHJLNPVXZng@rl @\ 8\^`bdfhRTjt:nzl~ve@X $@T @D Det@4 @($ @@ @ @| ate@ $ @ $@  @ @ FE@  @ MA:~ @p @0` @\ mber@HL  @`< )@x, e Fo@ @ X@ r$@O @ @ $!!!""@!X!p!!! P `zt%xnHF@8 H @ 8 @4 @h $ @  @  @ @ @" @ @! @0" @J @L @Nt @Pd @RT @TD @V4 @Xx$ @Z(! @\ @^ @H" @`" @x" @" @" @" @" @ #t @#d @8#T @h#D @P#4 @#$ @# @# @# @# @# @$ @@$ @($ @X$ @$ @p$t @$d @T @$D @$4 @$$ @% @ x''%H&%&8'%&x@`&t @&d @&T @0&D @4 @x&$ @ @& @ @& &&@' ('&@`' @ P''@`'8'@ @& @ &XX() )((X((p(`z (X(@(h @(X @)H @8)8 @)( @$ @P) @h) @) @) @ @) @) @ @ x+++x++***@l **:l@0+d @H+T @P @`+@ @+0 @+ @ @+ @* @ @, @ , @ ..,/.-0/.-p.(-X-,/,@l -,p-@0 @(. ln:~@- -X-@- --@- --@ H/-@. @ @@. @X. @ @. @ @h/ @ @ @t @d @-@T X/->-?@D 82`h522555P5`1p0102 0580@l H0 0:~n@0X @0H @D @04 @0$ @01 @1 @H1 @1 @2 @x1 @1 @1 @3 @1 @1 @2 @ 2 @ @ X0N@H @| P2  J@h2l @\ @2L @3< @(3, @@3 @X3 @p3 @3 @3 @3 @3 @4 @04 @4 @H4| @x4l @`4\ @4L @4< @4, @4 @5 @4 @ 5 @ @85 @ @ @ @0 2LRTjVZ^b@ 0| @ l 5dfh\H` 76 99 096x777666@l 668:nR@7L @07< @8 @H7( @`7 @9 @7 @~H @@8 @ @ @8 087 @ 98 @X8 @p8x @8h @8X @8H @88 @8( @9 @ @7 @H9 @`9 @x9 @9 @ @47 @ @9 8-;;<;:;;:::@l :::~n^@ ;X @8;H @D @P;4 @h;$ @< @; @~: @p< @ @ @< @(< @@< @X< @ @< @ @4; @p @<` >>??@`>=h>====@l ==:~n@>X @ >H @D @8>4 @P>$ @? @> @~ @X? @ @ @> @? @(? @@? @ @p? @ @4> @p @?` @ P XA@8ABA@hA@@@@@l @@:~nb@AX @ AH @D @8A4 @PA$ @B @A @~ @XB @ @ @A @B @(B @@B @ @pB @ @4A @p @B` DpCDEDCPDCpCCC@l CpC:~nd@CX @DH @D @ D4 @8D$ @E @D @~ @@E @ @ @D @D @E @(E @ @XE @ @4hD @p @pE` GXFGHhGF8GFXFFpF@l FXF:~nf@FX @FH @D @G4 @ G$ @pH @hG @~ @(H @ @ @G @G @G @H @ @@H @ @4PG @p @XH` hJ`JpK @JI JI@IxIXI@ l hI@I:~nh@IX @IH @D @I4 @J$ @XK @PJ @~ @K @@I @ @J @J @J @J @ @(K @ @48J @p @@K` (LMPMLNMNLLxL(L`L@L@l PL(L:2nJ@L\ @LL @ MH @hM8 @&8( @8M @( @M @M @ @N @, @ @M @M @ @. @(N| @@Nx @XNt @pNp @l @N\ @L @4M< @N, PhPP8P`RpQQQP POOOO@l OO:2nL@O\ @PPL @PH @P8 @&( @P @( @Q @(Q @ @Q @, @6O @ @@Q @XQ @ @8p @0R` @:P @QL @QH @RD @R@ @< @, @4P @HR UXTP pTU 0 8UhSSSPUTSPS0S@l @SST:2N@Sh @SX @TT @SD @S4 @T$ @(T @ @U @, @6 @T @T TT @ T @ @U @ U @p @hUl @d @` @p P @@T@ @0 hWhVW`ZWYVHWVWhVxZV@l VhVW@W0 :~n@V, @( @W @0W @(Y @xW @~P @(X @ @ @ @X XW@x pXX@@Xh @XXX @XH X@X8 @X( @X @X @X @Y @@Y @Y @XY @pY @Y @ @Yx @h @Yd @Z` @Z\ @0ZX @T @4`WD @HZ4 VV X\h^H_P p ^[\[\0[h[H[@l X[0[\:nT@[D @[4 @0 @[ @[ @0_ @@\ @~ @\ @ @ @\ \\@ `_\@\x @]h @ ]X @8]H @P]8 @h]( @] @] @] @] @] @] @^ @(^ @@^ @X^ @p^x @h @p\X @^T @^P @^L @_H @D @4(\4 @$ @_ \B08aPa@bha```x``H`(`@l 8``:~n\@`X @`H @D @`4 @`$ @(b @ a @~ @a @ @ @a @a @a @a @ @a @ @4a @p @b` b d0deeHcc`cPdb0cc@l  cbhd:nj@xcL @c< @8 @c( @c @e @d @~h @d @ @ @xd dPd @ exd @d @dx @h @8dX @eT @0eP @HeL @`eH @D @4c4 @$ @xe xd2(p`JHW$*\Rffff*0<5ce124c6*\R1*#253*\R1*#385*\R1*#125*\R1*#119*\R0*#f*\R0*#17*\R0*#1*\R1*#65P X  `;h     $+2A$+@HrGX 2A B   ( V0(7   <&9C8 $XX0J  ,(7 &:08(7@ &:h"   0(7(4F0h)x    2A B    0 @ P ` p            (  0 .8 h      ^ ,0 6R` 8X  ,(    ,(( X &` ,( ) 2R   ,((   X `  ,(h      ,(      % 0@ H "P X  Vh    Ib8218 p      B .f   B ( 08@H P  RX"Xx     (^p(Xh p&Px     (^x( &P     (^b@ &P     ( (^8(^`8 (&P0X h x    (^(^8p&P       fS `p x &P     2$&#8 @&#Px &#  &#   6;(` h  J   &#0X ` p 6;E %0: ( 0 8 X&#h &# &# &#(P   X p "T 0  ($>jS&P   ;S&P     jS    &P        jS!p!!!&P!! ! ! !  dS! P"`" h" &Pp" " """ " " ## # $$  $ B ($ 50$5H$  N`$ $ F$8i$  $ $ f^$ `%p% x% &M% % % % % %% % &&  & B (& 50&5H&  N`& & "K&F& 6i&  '  %' 8i8' 6 p' ' ^' X(h( p( &Mx( ( (( b( ^0) )) ) &M)  * 0*@* 2H* *^*@+P+X+&M`++ ++ + + ++ + +, , ,B(, 0,8,@,H,P, (mX,(k,(m,(m,(k,(m -(kH-(kp-(k-(k-(k-(k.(k8.(k`.(k. @.  .// 0 0X1 `1(202 2 333 44 h5p5 86@6 77 77 88 x99 H:P: ; ;    (; " 0; (8;`;h; p;x; ;; ; ,;4;  <0 <P<(p<<< :< .<="==.=.>>H>2>>>6?.8?.h? ?"? ??D@2H@^@"@ AA(A $0A XA(hA.A.A(AB8B @B(PB.xB(BBB B B  NB C "KC"K8CF`CC CC  C&CHiC D040D`D hD>iD D04DEE@i(E hE04xEEE6iE E04F8F@F6iPF F04FFF:iF (G048GhGpG<iG G04G HH H@i@H H04HHH<iH I040I`IhI6ixI I04III4iJ @J04PJJJ8iJ J04JK K8i8K pK04KKK@iK L04(LXL`L@iL L04LMM:i M `M04pMMM:iM N04N@NHN6iXN N04NNN<iN 0O04@OpOxO>iO O04OPP<i0P pP04PPP8iP Q04QHQPQ:ihQ Q04QQQ8iR @R04PRRR8iR R04RS S6i0S hS04xSSS<iS T04THTPT6i`T T04TTT:iT 8U04HUxUU6iU U04UVV:i(V hV04xVVV:iV W04WHWPW8ihW W04WWW<iX @X04PXXX<iX X04X Y(Y:i@Y Y04YY YY YY Z04Z @ZHZ %PZ04pZ ZZZ  Z ZZ  Z Z[ [B  [  [ [[ [ &[ [ \ " \ (\.@\ (p\ \ B \\\\\  N\F\] ] (]"5@] rh]]$] .^  ^ 0^^P^^^^&M^ _ 0_@_ H_ P_^X___`&M`0` @`P`X` ``   h` p` `` ` `` ` B  ```````  a a@a Pa `aha pa"a  a n`bb b 2b c 0c8c @c zHc cc c &c d d 0d8d@d Hdnhdd dd&d e 0e@e He Xehe pe eee B eeeeeee  NeFef (f 8f@f HfPf Xf`f hfpf xf"5f (fng  gh2Nh  @hPh$Xh "phh h  h .h hh h^iiii&Mii ii jjjjz^ jj jj&Mjj jkk k  kn^@kk kk&Mkk ll 4 lf^Xll ll&Mlm m(m 0m @mPm Xm hmxmmB mmmmm  NmFmm n n"5(n <NPnn$n .n  n n |^n po xo^op p(p&M0pXp hpxp p p^pq(q0q&M8q`q pqqq q   q q qq q qq qB  qr r"(r Pr`rprs(s0s&8s`s pss s ss s ss sB ss Ns"Tt 8tHt^Xtuuu&M uHu Xuhu pu uu u uu u B uu Nu"Tu v0v^@vvvv&Mv w 0w@w Hw Xwhw pw wwwB ww Nw"Tw wx^xxxx&Mxy y y (y 8yHy Py `ypyxyB yy Ny"Ty yy^yzzz&Mzz zz { { { ({ 8{H{P{B X{`{ Nh{"T{ {{^{p|||&M|| || | |} } }(}0}B 8}@} NH}"Th} }}^}X~h~p~&Mx~~ ~~ ~ ~~ ~ B  ( N0"TP x^8HP&MX   Ȁ Ѐ  B  ( 0  N8FXEx   ȁ!؁ "5 4N  X `h p x  + ,  &3؂ ( @ HP (X6Bx  (ȃ$   ((&Hp x (@B  ( @ HP (X``x؅  (6BH PX (` FOȆ І؆ (\`` hp (x ȇ (Ї<B0 8@ (HV`h ȈЈ (؈f`` hp (x ȉ (Љ>B0 8@ (Hh ( (06BP      ȋЋ ؋f^P `h&Mp   Ќ   B    (08  @`  f &(P ` p    Ў  ] ] ] ] 0] (] P] X] x] ] ] ] ] ] ] ] @] ] h]  ] D] D'H'J'L'N'P'r'V'X'Z'\'^'`'b'd'f'h'R'T'jAtpassError$:B@v'nError$:!xB@6$z'lB2Investor Details$:%!d$~'|G2Investor Details$:%!d$~' | G2Investor Details$:%(Please enter CINA@passInvestor Details$B@<|8d0 Please Prefill Company NameA@passInvestor Details$B@<|kkA'nError$:!xB@6$z'l$'$'r rStop n passInvestor Details$B@<Error! Please refer ErrorA@| ne Invalid data present at row no:: l .Kindly refer ErrorSheet Error! Please refer ErrorA@|(k passInvestor Details$B@<o8]xPWorkbooks("InvestorDetailExcel.xls").Sheets("Investor Details").Unprotect "pass"ppassInvestor Details$:B@vMsgBox rowCount6ActiveSheet.Cells.SpecialCells(xlCellTypeLastCell).RowInvestor Details$:B@<A1$:%.O10:O l$ %' Investor Details$:%x(%Workbooks("InvestorDetailExcel.xls").passInvestor Details$:B@<Investor Details$:B@<zpassInvestor Details$:B@<Investor Details$:B@<ihMACROS BY EXCELZOOM.COM]]*Set rangeSheet = Cells.Range("A15:O65536")passInvestor Details$:B@v   A15:O65536$%.   !$~ B@kXPH..passInvestor Details$B@<o]X++++++++ + + + + + +++]] ''MsgBox "RowCount Value ::::" & rowCount   l nStop'zXkP   WIf ((colCounter = 1) Or (colCounter = 4) Or (colCounter = 9) Or (colCounter = 10)) Then     $Investor Details$:%x!d'  $Investor Details$%x$~' Investor Details  $$'k Investor Details  $$'k   Investor Details  $$'   e Investor Details$%x$~' $INDIAInvestor Details  $$' 'dInvestor Details  $$' 'kXkPdHInvestor Details  $$'k   Stop StopStop'ki]D*  x%!'   $ : $8Blank Rows Found.Do you want to Clear Rows from row no.  to   ???'    Deletion Confirmation$'  GC@j|pqh|`kX o@0  : $%!''z'ix]]0]H]`  $:%x!d'   $%x$~'    $%x$~Error at line number . column 1 or 3 (Investor First or Last Name)  : Mandatory Field' nzk  nError$%x( n 'nStop'k8 e e  $%x$~Error at line number 6 column 4 or 6 (Father/Husband's First or Last Name)  : Mandatory Field' nz` kX  nError$%x( n 'nStop'k e  e  $%x$~Error at line number 8 column 10 or 11 either District or Pincode is mandatory' nz@ k8  nError$%x( n 'nStop'k  e  e  $%x$~  $%x$~Error at line number  Column  D Either Folio Number or DP Id-Client Id-Account Number is mandatory' nz k  nError$%x( n 'nStop'k kx  e  $%x$~  $%x$~Error at line number  Column  D Either Folio Number or DP Id-Client Id-Account Number is mandatory' nzx kp  nError$%x( n 'nStop'k k d  Error at line number  column  ( ) : Mandatory Field' nzk  nError$%x( n 'nStop'k0d(    Investor Details  $'k  Investor Details  $'k  Investor Details  $'k@ Investor Details  $'k For Country Investor Details  Sheet3A2$'k For FolioNoIf (colCounter = 12) ThenD IsValid = validFolioNO("Investor Details", rowCounter, colCounter)End IfFor DpIdClientIdAccountNo  Investor Details  $'k For State  Investor Details  Sheet3B2$'  $%x' Stop Investor Details  Sheet3$'NkkFor Character Length Investor Details  $'kh Investor Details  $'k( Investor Details  $'k Investor Details  $ 'kFor Proposed date  $    $%x$~'   $$' JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC - '  - '     $' Error at line number  column  ( ) : Invalid Date Format' nz`kX  nError$%x( n 'nStop'k $ $ Error at line number  column  ( )3 : should be less than or equal to the system date.' nzHk@  nError$%x( n 'nStop'kdError at line number  column  ( ) : Invalid Date Format' nz`kX  nError$%x( n 'nStop'kdError at line number  column  ( ) : Invalid Date Format' nzxkp  nError$%x( n 'nStop'k dError at line number  column  ( ) : Invalid Date' nzk  nError$%x( n 'nStop'k@k8k0 Stop JStop NStop LStop RStop TStop jStop VStop Stop ZStop ^Stop Stop bStop dStop fStop hStop \StopStop'Hk HStopStop'kix $$!'& $$!*'(  $:%x!d'x   $%x', ,A1:A248Sheet3$% %0'. .$2Error at line number  column  ( ) : Invalid Country'4 nzk 4 nError$%x( n 'nStop'k0 StopStop'Jk JStopStop'kiX $$!'& $$!*'(  $:%x!d'x   $%x',   $%x'6 6B2:B37Sheet3$% %0'8 8$2 6NA ,INDIA ,A1:A248Sheet3$% %0': :$2&$stateName=NA and CountryName=invalidPError at line number  column  ( )N : Incorrect Country State Mapping. Please select an option from the drop-down'4 nzk 4 nError$%x( n 'nStop'k8d Y(stateName = NA and CountryName = INDIA) OR stateName = invalid and CountryName = 'INDIA'Error at line number  column  ( )N : Incorrect Country State Mapping. Please select an option from the drop-down'4 nzk 4 nError$%x( n 'nStop'kd*stateName = valid and CountryName <> India ,$INDIAError at line number  column  ( )N : Incorrect Country State Mapping. Please select an option from the drop-down'4 nzk 4 nError$%x( n 'nStop'kPkH StopStop'Lk  LStopStop'k Next Counteri8]x]]]] H ! F%x%!'< H ! F%x%!'J H ! F%x%!'> H ! F%x%!'@ H ! F%x%!'L H ! F%x%!'B H ! F%x%!'N H ! F%x%!'P H ! F%x%!'R H ! F%x%!'T H ! F%x%!'V H ! F%x%!'X H ! F%x%!'Z H ! F%x%!'\ H ! F%x%!'^9MsgBox "rowColumn11: rowColumn11 value is " & rowColumn11 < J < > < @ < L < B < N < P < R < T < V < X < Z < \ < ^ <'z J < J > J @ J L J B J N J P J R J T J V J X J Z J \ J ^e J'z > < > J > @ > L > B > N > P > R > T > V > X > Z > \ > ^e >'z @ < @ J @ > @ L @ B @ N @ P @ R @ T @ V @ X @ Z @ \ @ ^e @'z L < L J L > L @ L B L N L P L R L T L V L X L Z L \ L ^e L'z B < B J B > B @ B L B N B P B R B T B V B X B Z B \ B ^e B'z N < N J N > N @ N L N B N P N R N T N V N X N Z N \ N ^e N'z P < P J P > P @ P L P B P N P R P T P V P X P Z P \ P ^e P'z R < R J R > R @ R L R B R N R P R T R V R X R Z R \ R ^e R'z T < T J T > T @ T L T B T N T P T R T V T X T Z T \ T ^e T'z V < V J V > V @ V L V B V N V P V R V T V X V Z V \ V ^e V'z X < X J X > X @ X L X B X N X P X R X T X V X Z X \ X ^e X'z Z < Z J Z > Z @ Z L Z B Z N Z P Z R Z T Z V Z X Z \ Z ^e Z'z \ < \ J \ > \ @ \ L \ B \ N \ P \ R \ T \ V \ X \ Z \ ^e \'z ^ < ^ J ^ > ^ @ ^ L ^ B ^ N ^ P ^ R ^ T ^ V ^ X ^ Z ^ \e ^'zkipassInvestor Details$:B@v]0]P]p]]]B2$!d'|AP1Sheet3$:%!d$~'lB2Investor Details$:%!d$~'| | G2Investor Details$:%(Please enter CINA@passInvestor Details$:B@<|`kX1http://mca.gov.in/FOServicesWeb/NCAPrefillService'h&'j jt'j j 'j j 'j j 'j j 'j j CIN 'j j  |'j j ZIE4 'j j 䴡'j j 'j j 'j j 'j j'j `post hC@Host1http://mca.gov.in/FOServicesWeb/NCAPrefillServiceC@n Content-Typetext/xml; charset=utf-8C@n soapActionFhttp://mca.gov.in/FOServicesWeb/NCAPrefillService/getNCAPrefillDetailsC@nAccept-encodingzipC@n jC@p5t dB@rq> //companyOrg1 d%v!d' passInvestor Details$:B@vG2Investor Details$:%(B2Investor Details$:%(passInvestor Details$:B@<Invalid CIN/BCINA@k= passInvestor Details$:B@v G2Investor Details$:%(passInvestor Details$:B@<k(=o =  $:%x!d'<   $%x',   $%x'6   $%x' ,$', ,INDIAKT 6Andaman and Nicobar IslandsKT AndamanandNicobarIslandsSheet3$% %0' $2Investor Details  Sheet3$'k;Andhra PradeshKT  AndhraPradeshSheet3$% %0' $2Investor Details  Sheet3$'k:Arunachal PradeshKT ArunachalPradeshSheet3$% %0' $2Investor Details  Sheet3$'kP:AssamKT AssamSheet3$% %0' $2Investor Details  Sheet3$'k9BiharKT BiharSheet3$% %0' $2Investor Details  Sheet3$'k09 ChandigarhKT  ChandigarhSheet3$% %0' $2Investor Details  Sheet3$'k8 ChhattisgarhKT  ChhattisgarhSheet3$% %0' $2Investor Details  Sheet3$'Stop'k7Dadar Nagar HaveliKT DadarNagarHaveliSheet3$% %0' $2Investor Details  Sheet3$'k87 Daman and DiuKT  DamanandDiuSheet3$% %0' $2Investor Details  Sheet3$'k6DelhiKT DelhiSheet3$% %0' $2Investor Details  Sheet3$'k6GoaKT GoaSheet3$% %0' $2Investor Details  Sheet3$'kx5GujaratKT GujaratSheet3$% %0' $2Investor Details  Sheet3$'k4HaryanaKT HaryanaSheet3$% %0' $2Investor Details  Sheet3$'kH4Himachal PradeshKT HimachalPradeshSheet3$% %0' $2Investor Details  Sheet3$'k3Jammu and KashmirKT JammuandKashmirSheet3$% %0' $2Investor Details  Sheet3$'k2 JharkhandKT  JharkhandSheet3$% %0' $2Investor Details  Sheet3$'kX2 KarnatakaKT  KarnatakaSheet3$% %0' $2Investor Details  Sheet3$'k1KeralaKT KeralaSheet3$% %0' $2Investor Details  Sheet3$'k(1 LakshadweepKT  LakshadweepSheet3$% %0' $2Investor Details  Sheet3$'k0Madhya PradeshKT  MadhyaPradeshSheet3$% %0' $2Investor Details  Sheet3$'k/ MaharashtraKT  MaharashtraSheet3$% %0' $2Investor Details  Sheet3$'kH/ManipurKT ManipurSheet3$% %0' $2Investor Details  Sheet3$'k. MeghalayaKT  MeghalayaSheet3$% %0' $2Investor Details  Sheet3$'k.MizoramKT MizoramSheet3$% %0' $2Investor Details  Sheet3$'kx-NagalandKT NagalandSheet3$% %0' $2Investor Details  Sheet3$'k,OrissaKT OrissaSheet3$% %0' $2Investor Details  Sheet3$'kP, PondicherryKT  PondicherrySheet3$% %0' $2Investor Details  Sheet3$'k+PunjabKT PunjabSheet3$% %0' $2Investor Details  Sheet3$'k + RajasthanKT  RajasthanSheet3$% %0' $2Investor Details  Sheet3$'k*SikkimKT SikkimSheet3$% %0' $2Investor Details  Sheet3$'k) Tamil NaduKT  TamilNaduSheet3$% %0' $2Investor Details  Sheet3$'kP) TelanganaKT  TelanganaSheet3$% %0' $2Investor Details  Sheet3$'k(TripuraKT TripuraSheet3$% %0' $2Investor Details  Sheet3$'k( Uttar PradeshKT  UttarPradeshSheet3$% %0' $2Investor Details  Sheet3$'kx' UttarakhandKT  UttarakhandSheet3$% %0' $2Investor Details  Sheet3$'k& West BengalKT  WestBengalSheet3$% %0' $2Investor Details  Sheet3$'k8&n0&n(& ,INDIA 6NA NAInvestor Details  Sheet3$'k%d% 6NA NAInvestor Details  Sheet3$'kX%kP%kH% StopStop'Nk % NStopStop'k$i$ Error at line number  column  x (  x $:%x!d,) : Incorrect Country State District Mapping'4 nz8$k0$ 4 nError$%x( n 'ni#P passInvestor Details$:B@vE4Investor Details$:%(passInvestor Details$:B@<o`# ]0 ]H 'D]`  $:%x!d'~   $%x'  ' | z |  z $ z+|. z$|@$ z$|[$  z$|`$ z$|{$ d" z$| $  z $'  counter = counter + 1Error at line number  column  ( ~)1 : More than one consecutive space is not allowed'4 nz!k! 4 nError$%x( n 'nStop'y k d Error at line number  column  ( ~)9 : Special Characters and Numeric Values are not allowed.'4 nz k 4 nError$%x( n 'nStop'ykk StopStop'Rkh RStopStop'k@i8 ]X ]p ] '']  $:%x!d'~   $%x'  ' | ] ' z |  z $ z+|  / F z$|@$ z$|[$  z$|`$ z$|{$  z$|/$ z$|:$  z$|@$ z$|[$  z$|`$ z$|{$   'k z$|/$ z$|:$   'kd'Error at line number  column  ( ~)& : Special Characters are not allowed.'4 nz k 4 nError$%x( n 'nStop'yk  Error at line number  column  ( ~) : Should be alphanumeric.'4 nzk 4 nError$%x( n 'nStop'k StopStop'Zk ZStopStop'khi` ] ] '] ']  $:%x!d'~   $%x'  ' |H]P']h']']' z |  z $ z+|/;R z$|@$ z$|[$  z$|`$ z$|{$  z$|-$ z$|/$ z$|:$  z$|@$ z$|[$  z$|`$ z$|{$   'k z$|/$ z$|:$   'k z$|-$ z z 'kh  '  z $' -'counter = counter + 1Error at line number  column  ( ~)7 : More than one consecutive '-'(hyphen) is not allowed'4 nzXkP 4 nError$%x( n 'nStop'ykkd'Error at line number  column  ( ~)& : Special Characters are not allowed.'4 nzHk@ 4 nError$%x( n 'nStop'yk  Error at line number  column  ( ~) : Should be alphanumeric.'4 nz8k0 4 nError$%x( n 'nStop'k    Error at line number  column  ( ~) : Invalid Format.'4 nz(k  4 nError$%x( n 'nStop'k StopStop'Tk TStopStop'kix]P]h'D]  $:%x!d'~   $%x'  ' | z |  z $ z+| z$|/$ z$|:$ dh z$|.$  z $' D 'D .Error at line number  column  ( ~)( : More one decimal point is not allowed'4k D Error at line number  column  ( ~)- : More than one decimal point is not allowed'4 nzk 4 nError$%x( n 'nStop'ykxdpError at line number  column  ( ~)4 : Special Characters and Alphabets are not allowed.'4 nzk 4 nError$%x( n 'nStop'yxkpkh` StopStop'jk8 jStopStop'ki]x  $:%x!d'~   $%x$~' '  Error at line number  column  ( ~)N : Folio Number Should be alphanumeric and less than or equal to 20 Characters'4 nz k 4 nError$%x( n 'nStop'kx StopStop'ZkP ZStopStop'k( i ]0  $:%x!d'~   $%x$~' ' < Error at line number  column  ( ~)O : DP Id-Client Id-Account Number Should be Less Than or equal to 60 Characters'4 nz k 4 nError$%x( n 'nStop'k StopStop'\kh \StopStop'k@ i8 H]  $:%x!d'~   $%x$~' ' # Error at line number  column  ( ~)D : Investor First Name Should be Less Than or equal to 35 Characters'4 nz k 4 nError$%x( n 'nStop'k StopStop'^k ^StopStop'khi`]  $:%x!d'~   $%x$~' ' # Error at line number  column  ( ~)E : Investor Middle Name Should be Less Than or equal to 35 Characters'4 nz0k( 4 nError$%x( n 'nStop'k StopStop' k StopStop'ki]X  $:%x!d'~   $%x$~' ' # Error at line number  column  ( ~)C : Investor Last Name Should be Less Than or equal to 35 Characters'4 nzXkP 4 nError$%x( n 'nStop'k StopStop'bk bStopStop'kip]  $:%x!d'~   $%x$~' ' # Error at line number  column  ( ~)L : Father/Husband's First Name Should be Less Than or equal to 35 Characters'4 nzxkp 4 nError$%x( n 'nStop'k  StopStop'dk dStopStop'ki(]  $:%x!d'~   $%x$~' ' # Error at line number  column  ( ~)M : Father/Husband's Middle Name Should be Less Than or equal to 35 Characters'4 nzk 4 nError$%x( n 'nStop'k8 StopStop'fk fStopStop'ki]  $:%x!d'~   $%x$~' ' # Error at line number  column  ( ~)K : Father/Husband's Last Name Should be Less Than or equal to 35 Characters'4 nzk 4 nError$%x( n 'nStop'kX StopStop'hk0 hStopStop' ki]8]P'D]h]'  $:%x!d'~   $%x'  $%x' ' 'd8~ | z |  z $ z+| z$|/$ z$|:$ d}'y}k}}kx}     '$'   $DELHI    e $HARYANAd|'k|   e $ CHANDIGARH $PUNJABdH|'k8|   e $HIMACHAL PRADESHd{'k{   e $JAMMU AND KASHMIRd{'kx{   e $ UTTAR PRADESH $ UTTARAKHANDd{'k{  # e $ RAJASTHANdz'kz $ ( e $DADAR NAGAR HAVELI $GUJARAT $ DAMAN AND DIUd z'kz ( - e $GOA $ MAHARASHTRAdy'ky - 2 e $MADHYA PRADESH $$~ CHHATTISGARHd0y'k y 2 6 e $ANDHRA PRADESH $ TELANGANA $ PONDICHERRYdx'kx 8 < e $ KARNATAKAd@x'k0x < A e $ TAMIL NADU $ PONDICHERRYdw'kw C F e $KERALA $ LAKSHADWEEP $ PONDICHERRYd8w'k(w F K e $ WEST BENGAL $ANDAMAN AND NICOBAR ISLANDS $SIKKIMdv'kv K N e $ORISSAd@v'k0v N O e $ASSAM $ARUNACHAL PRADESHdu'ku O P e $NAGALAND $MIZORAM $ MEGHALAYA $MANIPUR $TRIPURA $ARUNACHAL PRADESHdt'kt P V e $BIHAR $ JHARKHANDdpt'k`tdXt'kHtd@t'k0tk(t Error at line number  column  ( ~) : Invalid Pincode'4 nzsks 4 nError$%x( n 'nStop'k@s StopStop'Vks VStopStop'krir]x]'D]  $:%x!d'~   $%x' '  Error at line number  column  ( ~) : Invalid Pincode'4 nzqkq 4 nError$%x( n 'nStop' insert here else partkhq StopStop'k@q StopStop'kqiqqAttribute VB_Name = "Module1" Public isValida teManor@y As Sng JCount@St~DisWct!InvType AlphapNume1@IndianP incod1Fo0rgieFolioEber4DpIdCl'@tIdAccNo}estorFirstؖtMiddlerLa]FatherHusb@`! " #AyriccqrowRD oeerrorfisPr efillecked BooleanSub n()A@ҀDB ƾJ@r» AllAˬ ̩Jɦ QJKhPNf;?KwhJn ɄJL Ca/Remove_Spaces!@ Sheets("EK").Unprote ("p0ass"`EjO= 1 Cells.CMr X= getRdZNCIN`@Tri m(3 Detail.Ran@ge("B2`Textaompany= bFGhIf "" The dH!k" hub XMsgBox "Pse ent tWorksd, P-P@-word:=., Us(erIa f5Only:=TruA@Exit z ElsC  $3 lD C *Ei" End< ` VFind"jBlank߀I!8)))t`')Dum1cul}= *tPCKS, ((*"Stop") A (: < 65537))&or/!!!R# >= / #0,Q a pres. at @? no::" &c" .bKly H"@, vbOK-, G or( !pL)55(b5 Function! Dimy7ma@RJ)'bookTe>LExcel.xBMU*wWs On " GoTošHler!*Xw(\'t!Y@ H 'Ave2 .\Specialy(xr1|h1)~.7_ V[U+SeK= 2p ^A1f sumdiv:Appa.Sum(ATaO10:O&)ao f  4, 5|).[30rO: % _^:=Fa2]/U(`Qrr:)072 P'MACROS BY EXCELZOOM.COM113r"t3~x"8Y" A15:O}!U6#o5k5RS0)R= ?).1 _ 1Constants,sQB&s@)@ Each In Wr}#*)/{B0tWPsN0 RS! Nothi!>/_Vhc.w_~Tn&tCol(15ss χ0P6ber(1) = 2 ColNTum23 3UD4 D4D5 D5U"6 "6"7 "7U"8 "89 9I10 101 1 11 11 11 1_1` Dim colCounter As @Double r ow ataR ow^'Msg`Box "  Value :" & " For6= D$ToIf (error=>= 6553The0n 7id@ateAllI" Stop"Exit Funct ioEnd If)E= LBIGd(ƍ) ,UA  '/( @oOr @e@=7A9fieldTextJSheets("Invest@gDetails").Cells0(9, Gˇ5)).AY|= Trim(Works)A>MT Is4val4MiddleNameLengthP,HR5iD`:FatherHusband")$W@X (3<> "" A\()`C ualphaeric&f H #(Else&== carynm= 65537hExit Functio rEnd(3Workshs("}" >, 1).Value % ^+ 1flapStop WElse() 10 O`Trim(EZ1&11011 ei DistricPincode is Nmő@ ozrn ^=B1WH rN12pH_H 9 3\R<#x ,C~ Co& E#TFol0io N`DP Id-Client!Acc%WߟCVW???G= ?'TA1T3T1JT^akTm_*D_*_*_*mq_*l ZOz /V ?zzzs _*z3 P / G*}wOn cGoTo 0 %K(!fiText)o? 8I ~I'_ 1G TPk1 OrU&346KIsidjalpha;e("InvesP Details",A,)  }validateRn$^1Zoa1@6 5a)G@#'F0b ry 8 u ?? "23"A2" "v r No '?$'V, O '   DpIdӗId ' tNo s rSt@69T2lid = vaApateSt@("Investor Details", rowCounter, col,"Sheet3B"B2") districtNameWorksTs(bData).Cells( [ 10CJIf (IsV <> "Stop" And a") 0Then i=?Dy10.,=uPEEIfO:'FC harac Lengthv=S1 iFirs(3)N"r3g"La<"m"4"FatherHusbandF]$6l$H H''ÒC  žPropose@@C/OOf Isve@(field@rueccVTrim(~)jXp(cc)``ff@Mid(UCaseA, 4, 3  "JAN" Or" FEBMARAPMAYhJUJULDUGSEPODCTNOVDHEC"Ԛgg I@nStr(1c -vbTextCompare3!"hh + gcii`a.c 5- hh e9ii)!w errMs"Errat line number " &(ŀ"umn"(& "("U!a)!" : @ɅY mat" C'e`@or >= 6553742Exit Functiow7hg "E, 1).p`2'?C8O fl>arv/ A ?! D> wNow)E3S """%""should be less than p)eq@ual toe system dT.$ $$c Z$N'$$$f$$$* _#Else??!C?!?!nCn*C //t oooB//CT A////```0;/% //t/ ?//////CT/ !7F//////dR;\Z O v End If  E If flag = "Stop" Or isValidCountryhDistrictA6State 0AlphaNumeic1 /d IndianPincod gForiegFolio,ber 7InvestorFirstNam 0 Middle La$FatherHusban>9< >DpIdClient IdAcc{NoGEThen uM)aGG׉ GvACFunctio@#  (SheetData As Sng, row@{@Double`, colPLo@ )ЁRowKRange( ).@ Col@um2fieldTex тs0).Ce lls(9*).A Ad On Error Res NjCMAtryħWorksA$ $  conAChkApplica1.Match( , 2"b3" ""$"A1:A248"), 0`(!aGIs e)FDfGoTo 0"#at line numA~" &iB& "A 2&B ( 4 )!" : X Hry"j ea3EL>= 605537/ Exit \ dH,`,E, 1).uA"j= + 1jJ*'E# "d)LCc) 4,,, _eBs tA"@JFterF F OEOE(OEn0 -p) sA:,2C OA"X&IIItxIB2:B37eIeH)H6(q%`NA" A:<> "INDI.Q/ U  U 7U'BR# ' =NA ~eM=inb4/XC?X?XwY?X0 {?X;Xcporre@CMapping. Please selAan opqk from p drop-down[PP\\&-Q/\9iX/\me{J[?\O\2 DEl'(Y.!p+.) OR T#$'' /#/#/#o{$o{h{/#@ /#/#/#D6/#/#&/# ˪_r20er/#/#`Z m# s""CQ3@UC :9) oSr/"/"/"/"/"/"EP/"_E_EWE!2G!?D?D != strName errorCounter = p+ 1!flagx"Stop"(End If If ^ ThenPisValidState SQE) MvKIN 'Next UFunctioK getRow() As@ Doubl @ Dim r lumn1 3 4 6 c @>= A\veSheet.Cell$s([s.\, 1).(xlUHp). 223344556677889910^101UL1L1L1M1U8M1_M1xM1M1M@MsgBox$ "'u1:h1 ue is "d &  @((G >=G2`3456789@T A11'H \'@)gg9lse <2 <<<{s5)Rv 2mn3*n ^ { 3mn4 n ^ {On4mn5 n ^ N {n5mn6 n ^ N > _umn6 >= @rowCol10) And ( |1|2>3>45)) Th en getRunt 6 ElseIf (7 g c b b 5=689&1x\F1F1F1"x7x8x1N11xx7Mpxxx<#<|#<8<9<<<<<|<<<#_<|#<<9<10;<n<<<<=.}o =$o=?<Zyn10mn11  ? / ? 2   1 ^ /? n123  1  / ? n134  1  / ? 5&)) Then  getRowCount = rPlumn14 ElseIf ((T5 > ) And >2>34567891011414"5{rIf@Functio Sub Prefill_WS1()  heets("Investor Details").Unprotect "pass" Dim xmlhtp As New MSXML2.HTTP30 Doc DOM@ument sURL StringEnvHtrCIN @ompanyNameSsC= Range("B2@>TextC 0VersRTrim(SM3 AP1@WA7 P[BgA"^" GValue`" 8aMsgBox "Please q2er @)H PpC Exit @M5#'E%S $)A<= "h     ( !"#$%&')*+,-./0123456789:;<=>?ٳٱ://.DZ./󰿳±/䴡ٱ!s& "" ,I // ///=  ? q{գ v1ateDDiictDataG,PDouble,p col"[ Lfield/d b).C@ells(9).2On Err&Res@ c!rC= WorksCn" - 2 q#st`Oҥ nt- 1dO DߜerJ UC(8cB #q PNDIA"Dq1e$`aman aONicobar Isl0_Applicaq.Matchj( , "nd, 0| =Is$ QfsHC= e'/`i 10,  aU9% 2  `Case ("Andhra Prad`esh")bdistrictName = Application.Match( @, Worksheets("S3").Rangepo, 0sIf IsError ]) ThenIsValide;"Investor Details", rowCounter, 10, R+End If runacxhal颅9?R Rssam?  BiharL>& ?&uJ?&ul&<&Chandigar"z '''i sChhattis'?Bt ''''C' flagF"Stop",I,Dadar Na, Haveli?|ethyB2% yy |yyyeq >#man ? DiuOƏOKsI+gelh'?0DsЗYs'AGoa&Rs%s?XujaratS___z____H_THaryan&____P_9&s____X_UimO$?~/u/uN0+/a,a, rowCounter, 10, "Sheet@3") E nd IflCase ("Jammu aHKashmirdistrictName = Application.@Match( ,@ Workss(.RangeGsrq, 0If IsError _) ThenxIsVali dSe"Investor De@tails"ΣharkhjN'N  \KarnatakaN?[NNKeral&vme& &t&Mt0MLaadweepM?' '''ŶMadhya Pradesh((( _(_(?_(_(_(X(@tr?w?w; vMaovr~ovyovovv;ManipuOOOV?OQ_`ω _sOOω?OOX_Ueghby'4etϝ"MssXizoramNS@M_ __y____8G_TNag&ndocoooo`T&sXtOrissO:____P?&&y????8?4Pondichpy&''zó rowCounter, 10, "Sheet3 ") End IflCase ("PunjabxdistrictName = Application.Match( , Workss(@.Rangeh, 0If Is Error V) 0Then܁wIsValidOe"Investor Details",̙Rajasthan`5~SikkimM[L   \Tamil NaduM& c _'uj_'u']'eblana?'e;NTg ?'?'?'_Tripur&J& &&&&&&Uttar PradeshNN|Nu}uxuu߈߈vO;Ԉ akud//6/;% Гp/sNX W Bengalet"ĤsXwSele|ct3=1S3(c!ry<> "INDIA"m AstatevNO1 1 }Elses[ = " A(? fW/9 s SP flagi"Stop"li DfOF v?Aɐ b Func Data Asd S9ngQD0oublbQColumnYLA  p2+" at line number0 " &X" cx&(bs(b).Cells(9, ).Text) : Incorr8 "ry0 FMappixng" t >= 65537 Exit 'vu" ).0su7 j =U + 1 !% Sub Clear() Sheets("Investor Details").Unprotect "pass"Ran@ge("E4rValue = " flP b En d Function alphaNumeric(Data As String, rowCo unterDouble, col{Dim i c   = 0arrAl>field8NampH).Cells(9 =).Text Workse # LenXgth(') - 1ReiWWFi0@ To UB=d(  i)@ Mid, i + 1, 1A sPIf (F(@ > Chr(64), Ao= 65537Exit u/azIf`C"#h 3.g(o J = 1flag`A"Stop C|or, RgS* ????b;?Speci\Charac`s ar B(W@C@.?@ ?@ ?@@ul)#?@?@!-?@h?@Z)@?#[g"Nb@i hisAicQ  cSW; `RidateFoliowwwwxacPiPwbjRP|#n qauy{QR=u{{EHX+{{#y| |otas>>FLI2geDK6#OK0uU931/(A1/1~/) 3(%p_Q47S58uD r 3T` um7 !(2oEA1 U\GH9?i9s+P5qousQp"ouPoF=thsi s ?suI?smh* g<rQ2Y pr&x\2#0_____Whould be0_} ser_orJ7 = "Stop" End IfX(If flag Th enhisValidFolioNumber!j _v]ate`ZFunctio  alphaeric1(SheetData As String, rowCount[ Double, col ) Dim iacD = 0n arrAlS(1 fieldNamevYs\).Cells(9 Q).Te,xtuWoxrksxy # Length (!) - 1 ReA@+ -hypMWI@Tger B;CEconsecutiveF^  specialChar  firstLastHyp& A For i@0@ To UBxd(;:A?i) (MidHJ,+ 01, 1 (((@ > Chr(64) A2`!dg"-", ':%#str"Err{at line n" && "umn&) ( )!" : More than o` ( '-'(`() is notlowedoe $e>= 655374%Exit % ;a(ă"e }1.Eew35* =~ OP*# ocq Elsew`$!!h@!!!SjVaracs a ".Oermxor)z3 )u N"AS(qS0)0_o__o=?"_Whould beä0Cw;A9492 1L <> 2 `g]es[0?9?ZZ?9)96InR matW _8_8_8k'_8 _8v| isA`}s|zoA'Gl S! %rvOtoOOOa JOOueO3H!۴lNum(i) = Mid(fieldValue, i + 1,@ 1) If ((arrA> Chr(47) And 2<258))) _t ThenElse & l=P6)-#nextval20counter0 z)~V"."; strName-"Error at line numb9" @& rowCA& " column& ( ))" : @More o+decim~point is not allowe,d"OEIf (G>@zT@;GB;than1=2ebV>= 655374qExit FunctioMWorksheets(").Cells( A.BҀPs`,= Ϋ&flagStop~4orL2r?E >\Bp`Z>Sp[[Charac@vs aUAlphab, ko^.??(?A??hϟ?Y?> 'g"N @`) hiseric1Pi "  _ ! t% idFolioNO(SqData As Strin g,IDoub8le,ɯ@Di m i '= - sg |9).T"'}Trim~(HEEj Length! 3(> 20tto:h nShould |bePh`:`o!r;less C\r equ=to }=< 0[/ O; i'99m4XS-L8 39Sis!*S= "U\I s2490?>33DpIdClientIdAcrNo444a7S*a4/5/5/5t` o5o5?6"*?7?7er?75717oruZ7C#g8@5/tNoi4 pm2=oin;xM< ;pateInvestorFirst[.<<< 35oqC?oq?߫6; . bsq: p35:GO:ˑ'5:pom 1).Value = strN@ame errorCounterl 8+ 1!flag8"Stop" En0d If4If : Then. isidInvestorFirstxI J/M5avalidatebLeng thh8FuncXtioS $M`iddleV%(SheetData As String, row Double , col ) Dim i `field*s-).Cells(9 ").TextTrim(WorksK!M%!F(B#@r(D> 35)DZċASEA at line nuDmb@" &IB&D "@umn&IC@( @@)AP" : q ^ HShould be Less$an or eq@ual to@) @Characs >= 655373Exit IZ"@"Ej ,?H$ǭ_%cQ *%lLacNls lll#lllCLlll!/ll#l ll* leV?lӥώked= ykFatherHusband?6l\lVpbl l?6rl ?6v%Vl)pll1?6l`ml.5ll/'s "6mmhpy,6?Q:6J`mmerm_#m k4_90/,QD 3r/:7e$7mmu?n?nQS7,77777?nT 7 7Q777v77O73888a58q888PW888?no nc;_4ndG,f4Qhrp0 /8+8D$?8?8"?8!p u8888tؿܿܿܣp880Ba) Then strName = "Error at line number " & rowCPount8&@column22(XfieldV)"" : Father/Husband's Last &Should be Lessan equal to 35 Characs" If e|>= 65537" Exit FunctioEnd If(Worksheets(").C ells( 4, 1).Valu G=N+ 1!flagStopd?hdis8idۄ& g(HvalidateLength/'GV  indianPin@code(SWData As String,ɖ@Double, ȕF)4@mDim ic = 0 arrA`lNum( 6ga)%FalsD%E&Re5.  F}i@-0 ToH UB`9d()< -fAa i)Midh, i~ m!tc ( >r(47), Ai <"58)) K sCoruNfE)c` 1.wHC> 110< 891=ft(, /  ), 2oH8A  =U`Case(LX9"DELHI"u.  214#wHARYANA>!??JAa P4P@TeWCHANDIGARH" Or PUNJABdbyq-'2A1718 { ( y!$HIMAL PRADESH S  'e 18 20 S JAMMU  KASHMIR  o ;a  2r0 29  ldRlUTTARVo+AKQ./t //// P3///i RAJASTP O O O O O D z64O+O I D$ADpNAH HAVELI?IÇ GUJARAT_AZDAMAN0DIU 4O 45O GOAMA k@TROk MMM@e /45"5"oiMADHYA@Trim_К`CHHATTISrosoAq!!!5!| 5_HR?b5bTELANG/TIPONDICHERRY") Then ElseTvalidFlag = FaLEnd If |If (fieldValue >= 56 A,< 60?UCase(st(ate5)"KARNATAKA)}60j53jTAMIL NADU" Or ~P)u67?75uERALA>LAKSHADWEEPIV 7P7tWEST BENGAL@ANDAMAN NICOBAR ISLS<SIKKIMk  ieK75pK8kOpRISS? ?F7809?1 AM=@RUNACHAL PRADESH_:_:O_:5F:9 8߅rNA@`Y| MIZOR"A=%MEG$AYCݏiIPUR|TR} A31ߔ?jz8oJ 86)S z~zBIH.Ao2J KH!?3sF9oK0 euP 65537 Exit Func8tio8Worksheets("2 ").Cells(, 1).SS= TW * D= + 1f"StopT 0z isIndian&oS !  fori$eg (SaData As St`ring,!PDouble, !V) Dihm iccT% " %= 03arrAlNum(i%= s7 U9).Text " .j Length/ǂ (l > 12YG6666 9"666 Z,63:6N656>mtT?6s.5 ' insert @here e par07/7#isFZ-6&{S n6[2#  I6Q$  d A)5X@@oHT@@: %$  d  )5 oH9(oHT@@ C 2t/ oHo(oHT@@ C 3t/&: ]-A.$6H(pzpz(($$H(KR(4 %l@DFH%X$ X dD A`1`)XD6Xl@l@DFH%X$ X dD  `1\)XD6 l\0 ^l@($%DFH%X$ X dD  :]3)XD6(:#*#;*#<*1h2PgPlhF%P@($%D:H%X$ X dD C)XD5P뫜PCd       !#$%&'()*+,-./02^l@($%DFH%X$ X dD  :]3)XD6(:#*#=*#<*1h2PPlhF%P@($%D:H%X$ X dD C)XD5P뫜PCd    ^l@($ %DFH%X$ X dD  :]3)XD6:#*#>*1h2PPlhF%P@($%D:H%X$ X dD C)XD5P뫜PCd  *  ^l@($ %DFH%X$ X dD  :]3)XD6^l@($ %DFH%X$ X dD  :]3)XD68:#*#?*##*#@*1h2 PAPlhF%P@($%D:H%X$ X dD C)XD5P뫜PCd  :^l@($ %DFH%X$ X dD  :]3)XD65^l@($ %DFH%X$ X dD  :]3)XD638:#*#?*##*#@*1h2 PPlhF%P@($%D:H%X$ X dD C)XD5P뫜PCdKS:#*#A*##*#B*#l`*#C*#<*1h2PPlhF%P@($%D:H%X$ X dD CrU~| )Ai 1a9QYy 9!1Y 1q !9IQ )Q9YyYqQ 9!)"!# $1%i%%)%%y9 19))% &)&I&i&&&&& ')'I'i''** ((-* ,q-. 0)1q2 4I5y55566 8Y99aQ:::A;;; 7I77Y##3//+i <Y<<=9=q===1>y>>>!?Q??? @9@y@@@AaAAA)B LiBBBC1CC DQDDD)EYEEEFQFFF!GaGGG HIHH I9IiIII!JQJJJJKIKyLiMNN PYQqQ)RR` T T T T T :\l T T T$ T( T, T0 T4 T8 T< T@ T T TD 7:D%T:\%X$ X dT)XT P;T:\%X$ X dTW )XT5 HU:D %T:\ %X$ X dT$= )XT6$U:D%T:\ %X$ X dT$= )XT6$:\]3F:%:D%T:\ %X$ X dT$C)XT5$+''':\N$$ 6$A:D%c%T:\ %X$ X dT)XTE:\]3C+''':\N$$ 6$A:D%c%T:\ %X$ X dT)XT  P;T:\%X$ X dTW )XT5 H$ $$ $l+l:\]/$PD'5D^A:D%c%T:\ %X$ X dT)XT+''':\N$$ 6$PG'':\NH#*# *F$ 26$A:D%c%T:\ %X$ X dT)XT4(l,XT$LK7:@%P:T %d$ d dP)dP9c@%P:T %d$ d dP)dPC:@/%P(T%d$ d dP "h)dP5 Xd'T%0H#*F %$ Qdo %P$ P1/P6 J(@%(%P:T %d$ d dP C)dP5 7:@%P:T %d$ d dP)dP:f@%P:T %d$ d dP)dP7:@%P:T %d$ d dP)dP:f@%P:T %d$ d dP)dPL0(lh$dP  47:L%\:` %p$ p d\)p\KF<%%p'L%:`!%$ p"tp5ltx")xa :`]36 xq x" c="t c="xA:L%c,%\:` %p$ p d\)p\40(xt p\@TTTTTTTT T T T T T TTT ( 00B@HfP# : lTLHTfoHoHoH R( %oHT@@: %)XD5P뫜PCd$ȃŃŃc#ll C 4/  #ll C D/  #ll C E/ #ll C F/ ? ;GCHCll C I2  p #ll C J/  _ ; CHCll C K2El@($ %DFH%X$ X dD )XD%:H]<:4]<'] :HC |l C L` 25  #ll C M/  #ll C N/  #ll C O/ # #ll C P/ \MH@ QTl@l@DFH%X$ X dD  l)XD5l(H ]30l 5( R\6\:HS]/\:4T]/\:$U]/L<\:V]/,\:W]/ \:X]/\:Y]/\:Z]/|\:l[]/\L\:<\]/,\: ]]/\:^]/*l:H_((H"l:4_5>("< R<6L(H]@S:#*#A*##*#B*#l`*#C*#`*1h2P PlhF%P@($%D:H%X$ X dD C)XD5P뫜PCd;l\ a b at/6%S:#*#A*##*#B*#l`*#C*#c*1h2PPlhF%P@($%D:H%X$ X dD C)XD5P뫜PCdS:#*#A*##*#B*#l`*#C*#`*1h2PPlhF%P@($%D:H%X$ X dD C)XD5P뫜PCdS:#*#A*##*#B*#l`*#C*#`*1h2PqPlhF%P@($%D:H%X$ X dD C)XD5P뫜PCdS:#*#A*##*#B*#l`*#C*#d*1h2PLPlhF%P@($%D:H%X$ X dD C)XD5P뫜PCdld00Ŕ 0Ŕ0Ŕ0Ŕ0ŔD0Ŕ04|:H]/$0$,0Ll:]/<,4080 <0@0l(0<64$l< T0 :Hl\(Dl\hl`\ld|!XDL<, |\L, 5H'L% F\%$ Ha8"i(H585H'L% F\%$ Ha8"iH58N(L %l@F\%H$ H d8 A)H58KFl@l@F\%H$ H d8 )Hi @:Ln%:\H%H$ H d8%(%$ o)H58  p_K^:#|*#xA*#t#p*#lB*F8:\C\:LqL<2 |xtpl68\PM<P@(%:\%H$ H d8 C)H58P뫜P :\,,:\]3{ T0 :\lPD(,l(,<< |xtplH8\Lt5H'L% F\%$ Ha8"i(H585H'L% F\%$ Ha8"iH58N(L %l@F\%H$ H d8 A)H58KKl@k%F\%H$ H d8 )HFl@l@F\%H$ H d8 )Hi @:Lr%:\H%H$ H d8%(%$ op)H58 p p0%:\s]/8:L6]<'`Ji @:Ln%:\H%H$ H d8%(%$ oP)H58 P pEK^:#L*#HA*#D#@*#<B*F8:\C`:Lt,2 LHD@<68`PMP@(%:\%H$ H d8 C)H58P뫜P :\ +^:#L*#HA*#D#@*#<B*F8:\C`:Lt,2 LHD@<68`PMP@(%:\%H$ H d8 C)H58P뫜P :\ 18 58:\6]@58/^:#L*#HA*#D#@*#<B*F8:\C`:Lt,2 LHD@<68`PMP@(%:\%H$ H d8 C)H58P뫜P :\  :\]3M T0i :\lptL(4 l( pP< LHD@<H8`,nm%H$ Ha8v"i$%(%4$ @4 >#A$Btl)H468k%H$ Ha8v"i$%(%4$ @4 >#A$)H468m%H$ Ha8v"i$%(%4$ @4 >#A$Btd)H468m%H$ Ha8v"i$%(%4$ @4 >#A$Bt\)H468k%H$ Ha8v"i$%(%4$ @4 >#A$)H468m%H$ Ha8v"i$%(%4$ @4 >#A$BtT)H468k%H$ Ha8v"i$%(%4$ @4 >#A$t)H468k%H$ Ha8v"i$%(%4$ @4 >#A$d)H468k%H$ Ha8v"i$%( %4$ @4 >#A$T)H468k%H$ Ha8v"i$%( %4$ @4 >#A$D)H468k%H$ Ha8v"i$%( %4$ @4 >#A$4)H468k%H$ Ha8v"i$%( %4$ @4 >#A$$)H468k%H$ Ha8v"i$%( %4$ @4 >#A$)H468k%H$ Ha8v"i$%(%4$ @4 >#A$)H468k%H$ Ha8v"i$%(%4$ @4 >#A$)H468olk$]V8olod'olo\'olk]V'oloT'olk]tV'olk]dV'olkt]TVd'TolkD]DV4'$olk]4V'olk]$V'olk]V'olk]Vt'dolkT]VD'46dolttolk$]V8odk]V'o\k]V'V'oTk]V'tV'ddVT'4TV$'DV'4V'$V'tVd'DV4'$V'K Bttodolodk$]V8'odo\'odk]V'odoT'odk]tV'odk]dV'odkt]TVd'TodkD]DV4'$odk]4V'odk]$V'odk]V'odk]Vt'dodkT]VD'46` odtto\olo\k$]V8'o\od'o\k]V'o\oT'o\k]tV'o\k]dV'o\kt]TVd'To\kD]DV4'$o\k]4V'o\k]$V'o\k]V'o\k]Vt'do\kT]VD'46u o\ttolk$]V8V'odk]V'o\k]V'oTk]V'tV'ddVT'4TV$'DV'4V'$V'tVd'DV4'$V'\ BttoToloTk$]V8'oTod'oTo\'oTk]V'oTk]tV'oTk]dV'oTkt]TVd'ToTkD]DV4'$oTk]4V'oTk]$V'oTk]V'oTk]Vt'doTkT]VD'46q oTtttolk$]V8tV'todk]V'to\k]V'tV'toTk]V'dtdVT'4tTV$'tDV't4V't$V'ttVd'DtV4'$tV'X tBttdolk$]V8dV'dodk]V'do\k]V'dV'doTk]V'ddtVT'4dTV$'dDV'd4V'd$V'tdVd'DdV4'$dV'? dBttTolk$]V8TV'Todk]V'To\k]V'TV'ToTk]V'dTtVT'4TdV$'TDV'T4V'T$V'tTVd'DTV4'$TV'& TBttDolk$]V8DV'Dodk]V'Do\k]V'DV'DoTk]V'dDtVT'4DdV$'DTV'D4V'D$V'tDVd'DDV4'$DV'  DBtt4olk$]V84V'4odk]V'4o\k]V'4V'4oTk]V'd4tVT'44dV$'4TV'4DV'4$V't4Vd'D4V4'$4V' 4Btt$olk$]V8$V'$odk]V'$o\k]V'$V'$oTk]V'd$tVT'4$dV$'$TV'$DV'$4V't$Vd'D$V4'$$V' $Bttolk$]V8V'odk]V'o\k]V'V'oTk]V'dtVT'4dV$'TV'DV'4V't$Vd'DV4'$V' Bttolk$]V8V'odk]V'o\k]V'V'oTk]V'dtVT'4dV$'TV'DV'4V't$Vd'DV4'$V' Bttolk$]V8V'odk]V'o\k]V'V'oTk]V'dtVT'4dV$'TV'DV'4V't$Vd'DV4'$V' BttxP(8 4$tdTDH48dT4$tdD4$    0   XN(D %l@TFX%h$ h dT A)hT5KKl@k4%TFX%h$ h dT )hTKl@k4%TFX%h$ h dT )hTFl@l@TFX%h$ h dT )hT 5:X6]3M:Xu]3&i @:Dv%T:XH%h$ h dT%(%$ o)hT5  p!4HC`` dl Cll wP2l`K:Xx]3i @:Dy%T:XH%h$ h dT%(%$ o)hT5  p4HC`` dl Cll wP2l`K:Xz]3i @:D{%T:XH%h$ h dT%(%$ o)hT5  p4HC`` dl Cll wP2l`K:X|]3ci @:D|%T:XH%h$ h dT%(%$ o)hT5  p^4HC`` dl Cll wP2l`K:X}]3"i @:D}%T:XH%h$ h dT%(%$ o)hT5  p4HC`` dl Cll wP2l`K:X~]3i @:D~%T:XH%h$ h dT%(%$ o)hT5  p4HC`` dl Cll wP2l`K:X]3i @:D%T:XH%h$ h dT%(%$ o)hT5  p4HC`` dl Cll wP2l` :X@K:X]3ji @:D%T:XH%h$ h dT%(%$ o)hT5  pe4HC`` dl Cll wP2l`K:X]3)i @:D%T:XH%h$ h dT%(%$ o)hT5  p$4HC`` dl Cll wP2l`K:X]3i @:D%T:XH%h$ h dT%(%$ o)hT5  p4HC`` dl Cll wP2l`K:X]3 i @:D%T:XH%h$ h dT%(%$ o)hT5  p 4HC`` dl Cll wP2l`K:X]3f i @:D%T:XH%h$ h dT%(%$ o)hT5  pa 4HC`` dl Cll wP2l`K:X]3% i @:D%T:XH%h$ h dT%(%$ o)hT5  p 4HC`` dl Cll wP2l`K:X]3 i @:D%T:XH%h$ h dT%(%$ o)hT5  p 4HC`` dl Cll wP2l`K:X]3 i @:D%T:XH%h$ h dT%(%$ o)hT5  p 4HC`` dl Cll wP2l`K:X]3b i @:D%T:XH%h$ h dT%(%$ o)hT5  p] 4HC`` dl Cll wP2l`K:X]3!i @:D%T:XH%h$ h dT%(%$ o)hT5  p4HC`` dl Cll wP2l`K:X]3i @:D%T:XH%h$ h dT%(%$ o)hT5  p4HC`` dl Cll wP2l`K:X]3i @:D%T:XH%h$ h dT%(%$ o)hT5  p4HC`` dl Cll wP2l`K:X]3^i @:D%T:XH%h$ h dT%(%$ o)hT5  pY4HC`` dl Cll wP2l`K:X]3i @:D%T:XH%h$ h dT%(%$ o)hT5  p4HC`` dl Cll wP2l`K:X]3i @:D%T:XH%h$ h dT%(%$ o)hT5  p4HC`` dl Cll wP2l`K:X]3i @:D%T:XH%h$ h dT%(%$ o)hT5  p4HC`` dl Cll wP2l`K:X]3Zi @:D%T:XH%h$ h dT%(%$ o)hT5  pU4HC`` dl Cll wP2l`K:X]3i @:D%T:XH%h$ h dT%(%$ o)hT5  p4HC`` dl Cll wP2l`K:X]3i @:D%T:XH%h$ h dT%(%$ o)hT5  p4HC`` dl Cll wP2l`K:X]3i @:D%T:XH%h$ h dT%(%$ o)hT5  p4HC`` dl Cll wP2l`K:X]3Vi @:D%T:XH%h$ h dT%(%$ o)hT5  pQ4HC`` dl Cll wP2l`K:X]3i @:D%T:XH%h$ h dT%(%$ o)hT5  p4HC`` dl Cll wP2l`K:X]3i @:D%T:XH%h$ h dT%(%$ o)hT5  p4HC`` dl Cll wP2l`K:X]3i @:D%T:XH%h$ h dT%(%$ o)hT5  p4HC`` dl Cll wP2l`K:X]3Ri @:D%T:XH%h$ h dT%(%$ o)hT5  pM4HC`` dl Cll wP2l`K:X]3i @:D%T:XH%h$ h dT%(%$ o)hT5  p 4HC`` dl Cll wP2l`K:X]3i @:D%T:XH%h$ h dT%(%$ o)hT5  p4HC`` dl Cll wP2l`K:X]3i @:D%T:XH%h$ h dT%(%$ o)hT5  p4HC`` dl Cll wP2l`K:X]3Ki @:D%T:XH%h$ h dT%(%$ o)hT5  pI4HC`` dl Cll wP2l`:X6]@:Xs]@:Xs]@4HC`` dl Cll wP2l`%:Xs]/:Ds]<'04HC`` dl Cll wP2l`@:X]33 T  0O :XlLXHt(0 lP@,l`hT00   0 P  8tTN(( %l@8F<%L$ L d8 A)L85Fl@l@8F<%L$ L d8 )L8(<"P (\lPi(h5(\(<" R\"lPR6@ e[ e`X e{8 e\"lPp\"lPcx'h\"lPXpH\"lP8c('6X8$  e\"lP35.(\(<" R6:<]3^:#*#A*##*#B*F: lP\TL8xhXH8(0   tTtLN( %l@0F4%D$ D d0 A)D05Fl@l@0F4%D$ D d0 )D0(4"H pppp(\lHi h5(\(4"x Rx\"lHR6x@ e[x e`H e{( e- e/ e: e\"lHp\"lHxch'X\"lHHp8\"lH(c'\"lH/\"lHp\"lHc'xh6xH(@ e[x e`H e{( e\"lHp\"lHxch'X\"lHHp8\"lH(c'6xH( oTtTN/ e:x e\"lHp\"lHxch'X6xA oLtL$- e\"lH35"\(4]/\/xp kp.(\(4"x RxX6X:4_]3p^:#T*#PA*#L#H*#DB*F:4Cx: h42 TPLHD6xPWM4P@(%0:4%D$ D d0 C)D05P뫜P :4p^:#T*#PA*#L#H*#DB*F:4Cx: h42 TPLHD6xPKM4P@(%0:4%D$ D d0 C)D05P뫜P :4 \~ oToL^:#T*#PA*#L#H*#DB*F:4Cx: h42 TPLHD6xPPM4P@(%0:4%D$ D d0 C)D05P뫜P :4 kkkk^:#T*#PA*#L#H*#DB*F:4Cx: h42 TPLHD6xPQM4P@(%0:4%D$ D d0 C)D05P뫜P :4:4]3 T0 :4lhX(> lHD\X4xTPLHDD0xhXH8(xhhtTN(( %l@8F<%L$ L d8 A)L85Fl@l@8F<%L$ L d8 )L8(<"P (\lPi(h(5(\(<" R\"lPR6N/ e: e\"lPp\"lPcx'h6n$. e\"lP353.(\(<" RX6 oTtTX:<]3<^:#T*#PA*#L#H*#DB*F: lP)D\X4< TPLHDL8xh0   XN(4 %l@DFH%X$ X dD A)XD5Tl@l@DFH%X$ X dD  )XD5 (H<]t^:#*#A*##*#B*F:HC:42 6P6MP@($%D:H%X$ X dD C)XD5P뫜P :H``:H]3 T((0 :Hl@((l\`8 XDXN(4 %l@DFH%X$ X dD A)XD5Tl@l@DFH%X$ X dD  )XD5 (H#]t^:#*#A*##*#B*F:HC:4h2 6P6MP@($%D:H%X$ X dD C)XD5P뫜P :H``:H]3 T,,0 :Hl@((l\`8 XD`N(4 %l@DFH%X$ X dD A)XD5Tl@l@DFH%X$ X dD  )XD5 (H#]t^:#*#A*##*#B*F:HC:4i2 6P6MP@($%D:H%X$ X dD C)XD5P뫜P :H``:H]3 :HPP:H]3 :Hl],D(,l\P`8 XDXN(4 %l@DFH%X$ X dD A)XD5Tl@l@DFH%X$ X dD  )XD5 (H#]t^:#*#A*##*#B*F:HC:4j2 6P6MP@($%D:H%X$ X dD C)XD5P뫜P :H``:H]3 T440 :Hl@((l\`8 XDXN(4 %l@DFH%X$ X dD A)XD5Tl@l@DFH%X$ X dD  )XD5 (H#]t^:#*#A*##*#B*F:HC:4k2 6P6MP@($%D:H%X$ X dD C)XD5P뫜P :H``:H]3 T880 :Hl@((l\`8 XDXN(4 %l@DFH%X$ X dD A)XD5Tl@l@DFH%X$ X dD  )XD5 (H#]t^:#*#A*##*#B*F:HC:4l2 6P6MP@($%D:H%X$ X dD C)XD5P뫜P :H``:H]3 T<<0 :Hl@((l\`8 XDXN(4 %l@DFH%X$ X dD A)XD5Tl@l@DFH%X$ X dD  )XD5 (H#]t^:#*#A*##*#B*F:HC:4m2 6P6MP@($%D:H%X$ X dD C)XD5P뫜P :H``:H]3 T@@0 :Hl@((l\`8 XDx tT c0@N( %l@(F0%,$ , d( A),(5Fl@l@(F0%,$ , d( ),(El@( %(F0%,$ , d( ),( (0]@ f0@"P !(\lPihx5(\(0"h Rh\"lPR6hN/ e:h e\"lPp\"lPhcX'H6h f0@ \~xR@f0]@~ +0]p ]c'hp ,(0'h h53(0 ]/ 5:]/h'X5k %(0 ]V(]c'h 5:0]35 f0@k %(0]V(]c'hfB 5:0]/h 5h:]/XH6hUa f0@k %(0]V(]c'h 5:0]35 f0@k %(0]V(]c'h 5:0]35 f0@k %(0]V(]c'hB 5:0]/h 5h:]/XH6h~ f0@k %(0]V(#]c'h 5:0]35 f0@k %(0$]V((]c'h` 5:0]/h 5h:]/XH8 58:]/(6h8nz f0@k %(0(]V(-]c'hB 5:0]/h 5h:]/XH6h f0@k %(0-]V(2]c'hO 5:0]/h 5hX X:]/H86hXq} f0@k %(02]V(6]c'h` 5:0]/h 5h:]/XH8 58:]/(6h8  f0@k %(08]V(<]c'hr 5:0]35am f0@k %(0<]V(A]c'hB 5:0]/h 5h:]/XH6h f0@k %(0C]V(F]c'h` 5:0]/h 5h:]/XH8 58:]/(6h8u f0@k %(0F]V(K]c'h ` 5:0]/h 5h:]/XH8 58:]/(6h8   f0@k %(0K]V(N]c'hv  5:0]35e q  f0@k %(0N]V(O]c'h B 5:0]/h 5h:]/XH6h   f0@k %(0O]V(P]c'h  5:0]/h 5h:]/XH8 58:]/( 5:]/ 5:]/ 5:]/xh6 h8   f0@k %(0P]V(V]c'h_ B 5:0]/h 5h:]/XH6hN Z  f0@k  f0@|  f0@@f0]3n ^:#d*#`A*#\#X*#TB*F:0Ch:XD2 d`\XT6hP MDP@(%(:0%,$ , d( C),(5P뫜P :044:0]3 T0 :0lH \(B lxP\@4Dld`\XT,(hXH8(xh0        arU `$`$`$`$`$!`(I`9/0q` Qq0++<`Qq0++00<`Qq0++00$ ` $ `89 `Qq0++08a `Qq0++0$ `0` Qq0++0` Qq0++0` Qq0++0)` Qq0++0Q` Qq0++0y` Qq0++0` Qq0++0` Qq0++0 ` Qq0++01` Qq0++0Y` Qq0++0` Qq0++0` Qq0++0` Qq0++n0* pHd VBAProject4@j = r W J< rstdole>stdole h%^*\G{00020430-C 0046}#2.0#0#C:\Windows\syst em32\e2.tlb#OLE Automation`EOffDicEOficEE2DF8D04C-5BFA-101B-BDE5EAAC42Egram Files\CommonMicrosoft Sn3_ClickFA(ClearWorksheet_Activate+Sheets Protectf Sheet2 Sheet3 Sheet4 Sheet5 Module1b(isValidateMandatoryr(isValidCountry (isValidState+(isValidDistrictނ(isValidInvTypenv (isAlphaNumeic(isAlphaNumeic1=E(isIndianPincode'y(isForgienPincodeh(isValidFolioNumber#(isValidDpIdClientIdAccountNop"(isValidInvestorFirstNameL(isValidInvestotMiddleName(isValidInvestorLastName%(isValidFatherHusbandFirstName(isValidFatherHusbandMiddleName(isValidFatherHusbandLastName^ (isNumeric1(rowCountu (errorCounter(isPrefillClickedP" isValidAll p (Remove_Spaces& Unprotect?Cells (getRowCount strCINTrim@Range strCompanyNamemValueKMsgBoxR WorksheetsPasswordUserInterfaceOnlyN(FindFirstBlankRow sumCalculatee (Calculate (ValidateAllvbOKOnlySumactErrHandlerCalcsumdiv{ Application*Sum rangeSheetW rangeTextRS_ SpecialCellsxlCellTypeConstantsW xlTextValues ClearContents{ ColNumberR colCounter rowCountereDataRow | fieldText fieldValueDIsValid@N (validateInvestorMiddleNameLength.%(validateFatherHusbandMiddleNameLength (alphaNumerica countrynm)UCase5  (indianPincodeflag(foriegnPincode(validateMandatory]LastRowWithValue2FindnSearchDirectionr xlPrevious RowCurrRow (IsBlankRowRowsUmsgQresp vbQuestion vbOKCancelx?vbOK%IsBlanke,xoCount0v SheetDataL%errMsg (validateFolio (alphaNumeric1S(NumericQ(validateCountry#f(validDpIdClientIdAccountNo  (validateState districtName(validateDistrictP(validateInvestorFirstNameLength-(validateInvestorLastNameLength$(validateFatherHusbandFirstNameLength#(validateFatherHusbandLastNameLengthҌIsDate2cc\ff9]gg_] vbTextCompare Qhh]ii] DateValue/Now%isForiegnPincodeisValidInvestorMiddleName SheetListp}DataListHListRow9ListColColumni countryNamek conNameChkzMatchRIsErrorUstrNameZ stateName2 stateNameChk countryMatch^ rowColumn1A rowColumn3C rowColumn4D rowColumn6Fcounter ActiveSheet%NxlUp rowColumn2B rowColumn5E rowColumn7G rowColumn8H rowColumn9I rowColumn10_! rowColumn11`! rowColumn12a! rowColumn13b! rowColumn14c! rowColumn15d!xmlhtp XMLHTTP30 xmlDoc DOMDocument30RgsURL:sEnv strVersion_^setRequestHeader#7sendLoadXMLD responseTextwSelectSingleNodeW DataColumny>i`a  *\G{000204EF-0000-0000-C000-000000000046}#4.1#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA7\VBE7.DLL#Visual Basic For Applications*\G{00020813-0000-0000-C000-000000000046}#1.7#0#C:\Program Files\Microsoft Office\Office14\EXCEL.EXE#Microsoft Excel 14.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\Windows\system32\stdole2.tlb#OLE Automation(*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.5#0#C:\Program Files\Common Files\Microsoft Shared\OFFICE14\MSO.DLL#Microsoft Office 16.0 Object Library*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#C:\Windows\system32\FM20.DLL#Microsoft Forms 2.0 Object Library*\G{3E68A7A8-43E0-4191-94CC-92A0B25C663D}#2.0#0#C:\Users\yashika.ACE\AppData\Local\Temp\Excel8.0\MSForms.exd#Microsoft Forms 2.0 Object Library.E .`M *\G{3050F1C5-98B5-11CF-BB82-00AA00BDCE0B}#4.0#0#C:\Windows\System32\mshtml.tlb#Microsoft HTML Object Library*\G{EAB22AC0-30C1-11CF-A7EB-0000C05BAE0B}#1.1#0#C:\Windows\System32\ieframe.dll#Microsoft Internet Controls*\G{F5078F18-C551-11D3-89B9-0000F81FE221}#3.0#0#C:\Windows\System32\msxml3.dll#Microsoft XML, v3.0 WThisWorkbook015ce124bd'ThisWorkbookf- Sheet10;5ce124c5+ Sheet1U& Sheet20=5ce124c6? Sheet20 Sheet30>5ce124c7A Sheet3H Sheet4055ce124bdC Sheet4;`Q Sheet5065ce124bdE Sheet5Vx-Module10<5ce124c6FModule1|D`0xHh5*nUB;4GOlPnfk H}.xFB|VNp^ IF/ro=D+@RC,U`w \Hn$0PNL:error Excel+ VBAWin16~Win32Win64xMacVBA6#VBA7# VBAProjectstdole`OfficeuMSFormsCMSHTML!xSHDocVw!MSXML2O ThisWorkbook| _Evaluate Sheet1CommandButton1_Click (Prefill_WS1CommandButton2_Click(Validate3PCommandButtoarrAlNum fieldNameLengthYChrK~nextvalKacounterncounterspecialCharFlagohypCountE consecutiveFlagu  firstLastHyp (validFolioNO_ validFlagJustatefieldValue~CommandButton1|CommandButton2}CommandButton3~Workbookk WorksheetClickActivate|_B_var_isValidAllu_Defaultj _B_var_TrimmT _B_var_strCIN j_B_var_strCompanyName>_B_var_sumCalculate_B_var_rowColumn2_B_var_rowColumn5_B_var_rowColumn7_B_var_rowColumn8_B_var_rowColumn9_B_var_rowColumn10_B_var_rowColumn11_B_var_rowColumn12_B_var_rowColumn13_B_var_rowColumn14_B_var_rowColumn15_B_var_CurrRow _B_var_msgbr _B_var_resp!_B_var_x _B_var_sumdiv$_B_var_DataRow_B_var_fieldText _B_var_fieldValue\_B_var_IsValidCB_B_var_countrynm3 _B_var_UCasea _B_var_flagc_B_var_districtNameX _B_var_cco _B_var_Midp _B_var_ff _B_var_gg _B_var_hh- _B_var_iiS_B_var_isForiegnPincode> _B_var_isValidInvestorMiddleName_B_var_fieldName" _B_var_Length> _B_var_Chr\;_B_var_nextval O_B_var_strNameN_B_var_ListRowl=_B_var_ListColj_B_var_countryName_B_var_conNameChkY_B_var_stateName_B_var_stateNameChk +_B_var_countryMatch{%_B_var_statefieldValuew _B_var_LeftQACEG  "$'+? ~-YD`(0!qQ!dir__SRP_0*__SRP_1PROJECTwm hared\OFFICE14\MSO.0DLL#M 1@6.0 Ob LibraryKMSForms>SFrms3D452EE1-E08F`A-8-02608C@4D0BB4SFM20L'B _&/;"1jIqAHq00}#0Bq# 50 A3E68A7A8-43E0-4191-94CC-92A0B25C663D6Users\yashika.ACE\AppData\Local\Temp\Excel8.0e9.exdf>@$.E .`M MSHTMLM@jHTMLv l4050F1C5-98B5-11C@F-BB82BDCE0B}#4 Smshtml½ǒSHDocVwHSHD@GcVwukEAB22AC0-30C1A7EB9 C05BA1.F1rief ce.dll*Internet Controls @&XML2&Xb&62!&b&F5078F18-C55D3-89B9F81FE@221}#3&xml3, v @BBThisWorkbooPkGTioW(rkbUo2-` 11B-X"a,f"+BSheet1G Se@t12  TU& 2 2 2i 2 @檸 3 3 3 3 ) 4 4 4 4 QT; 5 5 5 5 EVBd`odule#Cdo0yu2y!#2Tf _D^*|!X*rU~~~y    qq top 2Error! Please refer Error Rajasthan @Invalid data present at row no:: 2 .Kindly refer ErrorSheetVBE7.DLL 1  1S  A15:O65536FF6kCG}ӌI]~BQ^"Έ @EndRow * : Himachal Pradesh Punjab pBlank Rows Found.Do you want to Clear Rows from row no.   to  ??? *Deletion ConfirmationClearContentsSpecialCells Count A1 O10:OSum INDIA 1 8 *Error at line number  Haryana \ column 1 or 3 (Investor First or Last Name) $ : Mandatory Field l column 4 or 6 (Father/Husband's First or Last Name)  p column 10 or 11 either District or Pincode is mandatory  Column DadarNagarHaveli Daman and Diu$ Either Folio Number or DP Id-Client Id-Account Number is mandatory  column  ( ) Sheet3 A2 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC - , : Invalid Date Format f : should be less than or equal to the system date.  : Invalid Date 1- X 1x x 1  1"  b : More than one consecutive space is not allowed Gujarat r : Special Characters and Numeric Values are not allowed. 1` $ : Investor First Name Should be Less Than or equal to 35 Characters$ : Investor Middle Name Should be Less Than or equal to 35 Characters Delhi Goa# : Investor Last Name Should be Less Than or equal to 35 Characters( : Father/Husband's First Name Should be Less Than or equal to 35 CharaK*rU ~~~~~~~~~~~~~~~~~~~~~~~~~ KݏH.Bd#e   a  1 i a  )a  A Y qa yY y 1a!9Qy I))QAQiiiI )  VBAProject ThisWorkbookSheet1Sheet2Sheet3Sheet4Sheet5Module1F /C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA7\VBE7.DLLVBA  10F4C:\Program Files\Microsoft Office\Office14\EXCEL.EXEExcel 9@0FCommandButton2C:\Windows\system32\stdole2.tlbstdole  QPL-[DR?C:\Program Files\Common Files\Microsoft Shared\OFFICE14\MSO.DLLOffice q`.E .`M C:\Windows\system32\FM20.DLLMSForms  Qph>CA̒\=<C:\Users\yashika.91ý\AppData\Local\Temp\Excel8.0\MSForms.exd QP0 C:\Windows\System32\mshtml.tlbMSHTML  Q*0[ C:\Windows\System32\ieframe.dllSHDocVw 1 Q!C:\Windows\System32\msxml3.dllMSXML2   FEiIct FGۋxDw{Xu{lFWJOCommandButton3@2iwThisWorkbookThisWorkbookSheet1Sheet1Sheet2Sheet2Sheet3Sheet3Sheet4Sheet4Sheet5Sheet5Module1Module1PROJECT NSummaryInformation("DocumentSummaryInformation8"CompObj 1kID="{00000000-0000-0000-0000-000000000000}" Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Document=Sheet2/&H00000000 Document=Sheet3/&H00000000 Document=Sheet4/&H00000000 Document=Sheet5/&H00000000 Module=Module1 HelpFile="" Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="D2D07EAE54B254B251B751B7" DPB="A4A60880084F254F25B0DB502583BB266FF38992E53898C7A42EDE924C48120AD0BA45804FBF" GC="7674DAF27E165117511751" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 &H00000002={00020818-0000-0000-C000-000000000046};Excel8.0;&H00000000 [Workspace] ThisWorkbook=0, 0, 0, 0, C Sheet1=130, 130, 1024, 571, Sheet2=182, 182, 1076, 623, Sheet3=208, 208, 1102, 649, Z Sheet4=156, 156, 1050, 597, Sheet5=26, 26, 920, 467, C Module1=52, 52, 946, 493, Z Oh+'0@Hdt Natasha BhagwaniYASHIKAMicrosoft Excel@@U՜.+,0| PXp x ;Infosys Limited -Read MeInvestor DetailsErrorSheet3Country_State_District_MappingAndamanandNicobarIslandsAndhraPradeshArunachalPradeshAssamBihar Chandigarh ChhattisgarhCountryDadarNagarHaveli DamanandDiuDelhiGoaGujaratHaryanaHimachalPradeshIndiaInvestmentTypeJammuandKashmir Jharkhand KarnatakaKerala LakshadweepMadhyaPradesh MaharashtraManipur MeghalayaMizoramNA NagalandOrissa PondicherryPunjab RajasthanSikkim TamilNadu TelanganaTripura Uttarakhand UttarPradesh WestBengal  Worksheets Named Ranges( FMicrosoft Excel 2003 WorksheetBiff8Excel.Sheet.89q