{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Config","01","02","03","3a","04","05"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":1},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Config","index":0,"n_rows":622,"n_cols":3,"rows_kept":622,"cut":false,"hidden":false,"merged":[]}
["UserName",null,"INFO@EXCELPRINCE.COM"]
["info@excelprince.com"]
["aanchal.kapil23@gmail.com"]
["aayush.bindlish@gmail.com "]
["sharma.abhay298@gmail.com"]
["abhinav.garg579@gmail.com "]
["abhinav.garg005@gmail.com "]
["abhi_katiyar123@yahoo.co.in"]
["abhishekbagh04@gmail.com"]
["abhishek.chaturvedi430@gmail.com"]
["01abhi01@gmail.com"]
["abhishek.srivastavax@gmail.com "]
["abhi.gulati88@gmail.com "]
["adarsh.bhatnagar@gmail.com"]
["anand.aditya100@gmail.com"]
["Aditya.Bhaskar786@gmail.com"]
["adi7289@yahoo.com"]
["afzalansari.ru@gmail.com "]
["ajaycse.semwal@gmail.com"]
["ajay97tyag@gmail.com"]
["ajaythakur4841@gmail.com"]
["ajay.krpjp@gmail.com"]
["anejaa.ajay@gmail.com"]
["rathoreajay177@gmail.com "]
["akashdedha43@yahoo.in"]
["akashrana08@gmail.com"]
["akhil.40602@gmail.com"]
["akhileshkumar.vish@gmail.com"]
["alizaidi282@gmail.com "]
["alokj5@yahoo.co.in"]
["aloksharma_8484@yahoo.com"]
["alok6380@gmail.com "]
["sharmaamit139@gmail.com"]
["amitsharma04@hotmail.com"]
["karansb800@gmail.com"]
["amit.panchalccna@gmail.com"]
["amitnagar1984@gmail.com"]
["singhamy1984@gmail.com "]
["karansb800@gmail.com "]
["amitkumar12109@gmail.com "]
["amitkumar1192@gmail.com "]
["amitnagar1984@gmail.com "]
["amol.kaushik19@gmail.com"]
["lalaankur.iise04@gmail.com "]
["anandy075@gmail.com "]
["rawatani1985@gmail.com"]
["tanianurag1991@gmail.com"]
["akg00786@gmail.com"]
["sharma.anil304@gmail.com"]
["jainanjli508@gmail.com"]
["anjali.goorha@gmail.com "]
["ankitkumar22021984@gmail.com"]
["ak259369@gmail.com"]
["ankitjaindelhi2012@gmail.com "]
["ankur.khanna2184@gmail.com"]
["ank_mittal81@rediffmail.com"]
["ankur.agarwal100@gmail.com"]
["anugupta26sept1990@gmail.com"]
["anugupta26sept1990@gmail.com "]
["rustagi257anubhav@gmail.com"]
["rupeng.singh@gmail.com"]
["anujmalik642@gmail.com "]
["saxena.950@gmail.com"]
["apoorvmudgil91@gmail.com"]
["atriapoorv@gmail.com"]
["aqiqraza24@gmail.com"]
["architmehrotra07@gmail.com"]
["architmehrotra07@gmail.com "]
["kapil.arnika@yahoo.in"]
["arun_tyagi4u@yahoo.com"]
["arun33815@gmail.com"]
["marsexcel@outlook.com "]
["chauhan.arvind1985@gmail.com"]
["arvindrawat1980kv@gmail.com"]
["akdedha123@gmail.com "]
["aktiwary20@gmail.com "]
["ashimnath20@gmail.com"]
["ashishwarikoo@gmail.com"]
["ashishmehra2010@yahoo.com"]
["ashishdixitg@gmail.com"]
["ashish.rawat64@gmail.com"]
["ashishk733@gmail.com"]
["poonia.ashish@yahoo.com"]
["kheti.ashish1984@gmail.com"]
["rawat_ashish05@yahoo.com"]
["ashishtripathi2381@gmail.com"]
["ashishmehra2020@gmail.com "]
["Ashishgupta07051990@gmail.com "]
["asrivastava14oct@gmail.com"]
["atul.kuamr@gmail.com "]
["atulesh.kushwaha@gmail.com "]
["tomar.avinash@ymail.com"]
["avinash.madaeshiya@yahoo.com"]
["avinashsingh.9871@gmail.com"]
["kumaravinash1947@gmail.com"]
["avinashpratapsingh07@gmail.com "]
["avinash.madaeshiya@yahoo.com "]
["avneesh207@gmail.com"]
["Avneesh207@gmail.com "]
["mailforbyas@gmail.com"]
["shabd.niit@gmail.com "]
["bks825@gmail.com"]
["shabd.niit@gmail.com"]
["bhola.thakur1975@gmail.com "]
["bkumarsingh200@gmail.com "]
["bnegi1982@gmail.com"]
["bhupender.aswal333@gmail.com"]
["isshu1989@gmail.com"]
["binoymohanty@gmail.com"]
["binoymohanty@gmail.com "]
["aipbipin@gmail.com "]
["biresh.kumar1991@gmail.com"]
["maddy2689@gmail.com"]
["chandan.2a2@gmail.com"]
["chandan_1june@yahoo.co.in"]
["chandan.bora111@gmail.com"]
["chandankhatri1978@gmail.com"]
["chandan_negi2003@yahoo.com"]
["in.chandankumar@gmail.com"]
["chandan.kumar551@gmail.com"]
["chandan.bora111@gmail.com "]
["singh.chandra439@gmail.com "]
["chandrajeetthakur@gmail.com"]
["arvindchan86@gmail.com"]
["charankrpsprdd@gmail.com "]
["cheitali.aher@gmail.com"]
["chitra.9855@gmail.com"]
["daman.bhatia08@yahoo.com "]
["darshanrajcoolboy@gmail.com"]
["sixerking.singh@gmail.com"]
["debottamroy56@gmail.com"]
["deepak.578@gmail.com"]
["deepaksingh800@gmail.com"]
["deepaktiwari.iba@gmail.com"]
["ranadeepak1978@gmail.com"]
["deepakchandrabhatt08@gmail.com"]
["deepakkr557@gmail.com"]
["deepaksuryan.suryan@gmail.com"]
["deepakbhatt2015@gmail.com"]
["acdeepu@outlook.com "]
["dk91841@gmail.com "]
["tanward14@gmail.com"]
["deepesh.jain@outlook.com"]
["chauhandevender14@gmail.com"]
["devenderk199@gmail.com"]
["devenderk199@gmail.com "]
["arya.satya2008@gmail.com"]
["upadhyaydharmendra8@gmail.com"]
["dharmendra.singh311@gmail.com "]
["dheer4u786@gmail.com"]
["dheerajsharma1993@outlook.com "]
["negidheerendra@gmail.com"]
["chauhan.dhiraj01@gmail.com"]
["chauhan.dhiraj01@gmail.com "]
["digvijay.maurya15@gmail.com"]
["enroy.0072000@gmail.com"]
["dilip2127@gmail.com "]
["cooldskanwal@gmail.com"]
["arya.diensh2001@gmail.com "]
["arya.dinesh2001@gmail.com "]
["cooldskanwal@gmail.com "]
["sdkmdkdtk@gmail.com "]
["ditesh.agarwal@gmail.com"]
["dk@gmail.com "]
["foamshah@hotmail.com "]
["va@ggg.com "]
["gagang741@gmail.com"]
["kumgaurab@gmail.com "]
["gauravmatpal@gmail.com"]
["vatsgaurav1988@gmail.com"]
["gauravsharma1947.gs@gmail.com"]
["gauravkumar4777@gmail.com"]
["gauravakon2@gmail.com"]
["gauravsharma1947.gs@gmail.com "]
["gauravsharma1947@gmail.com "]
["gb171989@rediffmail.com "]
["gaurav.sharma91@outlook.com "]
["vatsgaurav1988@gmail.com "]
["gauravkumar159@gmail.com"]
["pgoyal315@gmail.com "]
["ghannu100@gmail.com"]
["ramayankaram@gmail.com "]
["girja668@gmail.com"]
["gladys.acpmex@gmail.com "]
["sharmag4ever1983@gmail.com"]
["gopalakrishnarao1@gmail.com "]
["mbagurjeet@gmail.com "]
["turabhaider2@gmail.com "]
["om.hari139@gmail.com"]
["dhadra.harish@gmail.com "]
["harmeet244@gmail.com"]
["harry.agr20@gmail.com"]
["himanshujoshi1489@gmail.com"]
["him83.arora@gmail.com "]
["harshharha@gmail.com "]
["hiteshiluthra1@gmail.com"]
["ik88175@gmail.com"]
["imran@khan "]
["arahan2664@gmail.com "]
["inderpalsingh.kalra@yahoo.in"]
["ishantsingh1989@gmail.com"]
["ishu_devesh47@rediffmail.com"]
["jacekkowalski80@o2.pl "]
["singhjai89@gmail.com"]
["jazpaul@yahoo.com"]
["harjeet1.kaur@yahoo.com"]
["jbisht149@gmail.com"]
["jit1983@gmail.com "]
["jitendrakmr289@gmail.com "]
["jbhoj792@gmail.com"]
["jhh@nn.com "]
["john277812002@gmail.com "]
["j.lbs@live.com.mx "]
["jyo_bagga@yahoo.co.in "]
["jyotikarnhr@gmail.com"]
["jyotsnasharma.hsr@gmail.com"]
["jyotsnasharma168@gmail.com "]
["klsh.rawat@gmail.com"]
["kamalraghav289@gmail.com"]
["kamalkumarkhurana@gmail.com"]
["rana.kamal5@gmail.com"]
["kamalnim@rediff.com"]
["kamalnim@rediff.com "]
["kamleshbhardwaj73@gmail.com"]
["kdkapildhaka58@gmail.com"]
["kapiljain1985@gmail.com"]
["iamkaran237@gmail.com"]
["kartikkumar2507@gmail.com"]
["kavya.aadya@gmail.com"]
["khairati@gmail.com"]
["Khushboo.chitra05@gmail.com"]
["jaiswalk_7@rediffmail.com"]
["kishormamgai@gmail.com"]
["kishormamgai@gmail.com "]
["krishankumars5@gmail.com"]
["kd8196@gmail.com "]
["ksr.rawats@gmail.com"]
["ksr.rawats@googlemail.com "]
["lalit.singh@denave.com"]
["lg70030@gmail.com"]
["vijaylalitkumar@gmail.com"]
["lg70030@gmail.com "]
["negi.lalita71@gmail.com"]
["lalitasan1989@gmail.com"]
["surender_s_suri@hotmail.com"]
["lin.li.9299@gmail.com "]
["lokeshkumar100@outlook.com "]
["maheshjsh9@gmail.com "]
["kummah07@gmail.com "]
["maheshswami.13@gmail.com "]
["write2mahip@gmail.com"]
["mananjay.singh1005@gmail.com "]
["manishraturi.86@gmail.com"]
["manishprimenet@gmail.com"]
["manju.rautela91@gmail.com"]
["manoj.singh528@gmail.com"]
["manojgupta.y@gmail.com"]
["manojgupta.y@gmail.com "]
["mayankchauhanmbd@gmail.com"]
["rawat.bisht27@gmail.com"]
["mehzabeenaazmi@yahoo.com"]
["tazz_ans@yahoo.co.in"]
["adnan.friend2014@gmail.com "]
["mohan.spgm@gmail.com "]
["kumar.mohan1993@yahoo.in "]
["nadeem.w2c@gmail.com"]
["khan.mohdzahid@gmail.com"]
["mohitbhalla1988@gmail.com "]
["mohitmittal9918@gmail.com"]
["mohit_m@hotmail.com "]
["mohd4ali1986@gmail.com"]
["mohnish.srivastava@yahoo.com"]
["mokshda1991@gmail.com"]
["monasingh.priya@gmail.com"]
["Monika.rajora.7@gmail.com"]
["monika.rajora.7@gmail.com "]
["Mritunjay.gkp123@gmail.com"]
["mritunjay.gkp123@gmail,com "]
["Mritunjay.gkp123@gmail.com "]
["mugdhakaul@gmail.com"]
["mukeshrana.1214@Gmail.com "]
["mpsarthi@gmail.com"]
["mm_eqbal@yahoo.co.in "]
["mushir222@gmail.com"]
["mushir222@gmail.com "]
["nagendrakarakoti@yahoo.in"]
["nakuldeep08@gmail.com "]
["nand_kishor@hcl.com"]
["n_s_bisht@yahoo.com"]
["bishtn80@gmail.com"]
["jaiswithu@gmail.com"]
["n_s_bisht@yahoo.com "]
["ng.gosain@gmail.com "]
["bishtn80@gmailcom "]
["bishtn80@gmail.com "]
["naresh_sharma2008@yahoo.com"]
["naseem786haider@gmail.com"]
["snav1983@gmail.com"]
["sharmn20@gmail.com"]
["naveenyadav1903@yahoo.co.in"]
["naveen.srivastava@bt.com "]
["naveensrv.2011@gmail.com "]
["navneet.sehrawat91@gmail.com"]
["navneet.sehrawat91@gmail.com "]
["neema9555@gmail.com"]
["neeraj.dhewal@gmail.com"]
["nkumar.saraswat1986@gmail.com"]
["neerajmarut@yahoo.com"]
["NSBHANDARI56@GMAIL.COM "]
["neeteshrajwar@yahoo.com"]
["neha.cool993@gmail.com"]
["nehamalhotrar1@gmail.com"]
["Nehakalra24@yahoo.com "]
["nidhisharma2381@gmail.com"]
["nidhisharma2381@gmail.com "]
["nikhil.npkinfosystems@gmail.com"]
["novemberboyniks89@gmail.com"]
["nimishversatile@gmail.com"]
["nir9650293661@gmail.com"]
["nisar4711@gmail.com "]
["nish7843@gmail.com "]
["nitaichand.biswal@gmail.com"]
["nitinsharma6659@gmail.com"]
["nitinanandworld@gmail.com"]
["yadav.nitin1@gamil.com "]
["nitin_234125@yahoo.com "]
["nizam.husain@gmail.com"]
["onkaripd777@gmail.com "]
["pabitrabelel1995@gmail.com"]
["padamsahoo@yahoo.com"]
["chauhanpk2@gmail.com"]
["pankajgupta89@ymail.com"]
["pchauhan944@yahoo.com"]
["pankajkmrk@gmail.com"]
["pankajnegi261988@gmail.com"]
["pchauhan944@yahoo.com "]
["1pankajsharma1@gmail.com "]
["chauhan.pankaj@indiamart.com "]
["paramdeepsingh13@gmail.com"]
["parth.hbk@gmail.com"]
["parulkumar002@gmail.com"]
["parveenk497@gmail.com"]
["parveshparihar8@gmail.com"]
["pawan092123@gmail.com"]
["pawansaini225@gmail.com "]
["mishramonu81@gmail.com"]
["peeyushduklan@gmail.com"]
["piyush9217@gmail.com"]
["arya121085@gmail.com"]
["polytamuli@gmail.com"]
["pooja.poo28@gmail.com"]
["innovation2319@yahoo.com"]
["ps.deeps0910@gmail.com"]
["singhal.pradeep2007@rediffmail.com"]
["mishra.pradeep.hcl@gmail.com"]
["pradeepconsult9@gmail.com"]
["singhal.pradeep2007@rediffmail.com "]
["pradeep.chauhan15@gmail.com "]
["mishra.pradeep.hcl@gmail.com "]
["linktoprahlad@rediffmail.com"]
["prakashkmr290@gmail.com"]
["prakashkmr290@gmail.com "]
["Guddusanwal@gmail.com "]
["pramod.raghav25@gmail.com"]
["pramod_juyal@ymail.com"]
["pramod_juyal@ymail.com "]
["prashant_jain2005@rediffmail.com"]
["prasantha0906@gmail.com"]
["prashant_jain2005@rediffmail.com "]
["ramola.praveen1@gmail.com"]
["praveenkdhiman@gmail.com"]
["PRAVEENKDHIMAN@GMAIL.COM "]
["jais.preeti@gmail.com"]
["dkbosh82@gmail.com"]
["premnegi@gmail.com"]
["chauhan.prem@gmail.com"]
["prince.sethi09@gmail.com"]
["pkm_madan@yahoo.co.in "]
["ajitabh.mishra86@gmail.com"]
["shuklapriyanka1987@gmail.com"]
["puja.bisht27@gmail.com "]
["wwpunitsharma@gmail.com"]
["pushpraj57@yahoo.com"]
["raghavdevsingh@gmail.com "]
["raghavdevsingh@gmail.com"]
["rkashyap89b@gmail.com"]
["ece08138.sbit@gmail.com"]
["rahul.80s@gmail.com"]
["rahul_grover20@yahoo.com"]
["ece08138.sbit@gmail.com "]
["sainis2012@gmail.com "]
["rajchauhanraj2003@gmail.com"]
["rjkumar335@gmail.com"]
["raushan.raushan123@gmail.com"]
["rkrana122@gmail.com "]
["raj.ilfsnoida@gmail.com "]
["rajan.aggarwal09@gmail.com"]
["rajan.bat@gmail.com"]
["pb_rajeevrana@yahoo.co.in"]
["krishna.ranjan353@gmail.com"]
["rajender_pundir@hotmail.com"]
["raj.sagi33@gmail.com"]
["rajenderk994@gmail.com"]
["raj.sagi33@gmail.com "]
["rajender_pundir@hotmail.com "]
["rajendrsingh023@gmail.com "]
["rajeshkumarkushwah1@gmail.com"]
["rajeshpoddar_2007@yahoo.co.in"]
["rajeshsharma.ggdsd@gmail.com"]
["rajeshranjan86@gmail.com"]
["Rajeshyadav252@gmail.com"]
["rajeshyadav252@gmail.com "]
["sharmaexl@gmail.com "]
["rajeshsharma.ggdsd@gmail.com "]
["raj.bhutna@gmail.com "]
["rajivr9989@yahoo.com"]
["rajiv.375@gmail.com"]
["rajni_dhingra@ymail.com"]
["rajni_dhingra@ymail.com "]
["ram.avatar22@yahoo.com"]
["aavatar22@yahoo.co.in "]
["ramjikumar22@gmail.com "]
["rpm678@gmail.com "]
["r.chandel999@gmail.com"]
["deo.veep@gmail.com "]
["ramjan0203@yahoo.com"]
["ramjan0203@yahoo.com "]
["ramjikumar22@gmail.com"]
["niwasr71@gmail.com"]
["razisartaj@gmail.com"]
["rashmi.yadav1707@gmail.com"]
["rawat.rashmi1987@gmail.com"]
["ratanbhushan.2910@gmail.com "]
["ratnakar7690@gmail.com"]
["ratnesh3132@gmail.com"]
["ratnesh3132@gmail.com "]
["ravi078152@gmail.com"]
["supercoolravi143@gmail.com"]
["Ravisharma0386@hotmail.com "]
["ravindra.kumar432@gmail.com"]
["ravindra.gusain@yahoo.com"]
["makhloga.rina@gmail.com"]
["makhloga.rina@gmail.com "]
["reetizashastri@gmail.com"]
["renubist@yahoo.com"]
["renu.sammi@gmail.com"]
["rishabhagnihotri991@gmail.com"]
["rishioimt@gmail.com"]
["ritssweet16@gmail.com"]
["rohitvishal88@gmail.com"]
["rohit_pandey4@hotmail.com"]
["rohit.citi007@gmail.com"]
["Rohit.ranjansingh1987@gmail.com"]
["rohitdutt11@gmail.com"]
["kumarrohit151094@gmail.com"]
["rohitveryani@gmail.com"]
["rohitkathpalia@yahoo.com"]
["rohit1578@gmail.com"]
["badola.rohit02@gmail.com "]
["writetorohit@hotmail.com "]
["rohithb2b@gmail.com "]
["roshan_ipgcl@rediffmail.com"]
["rupalisajwan@gmail.com"]
["rupeshkmr619@gmail.com"]
["sachine981878@gmail.com "]
["sacchirai98@gmail.com "]
["sacchirai99@outlook.com "]
["kumarsachinsingh1988@gmail.com "]
["sachinkrsharma1986@gmail.com"]
["sachingupta3636@gmail.com"]
["gsachin078@gmail.com"]
["sachin27479@gmail.com"]
["sachink467@gmail.com"]
["sachin.astral@gmail.com"]
["gsachin078@gmail.com "]
["sachin.astral@gmail.com "]
["mk.askari786@gmail.com"]
["samrat "]
["sandeep_saraf8@yahoo.com"]
["sandeepmalik198627@gmail.com "]
["sanjukash605@gmail.com"]
["sanjaybhatt945@gmail.com"]
["sanjay23rawat@gmail.com"]
["skrbokaro.roy@gmail.com"]
["naugai@yahoo.co.in"]
["sanjai.singh896988@gmail.com"]
["sanjaybhatt945@gmail.com "]
["skrbokaro.roy@gmail.com "]
["sanjeev.paliwal@ymail.com"]
["santosh.kumar338@gmail.com"]
["santosh.kumar338@gmail.com "]
["sapna.bhargav9@gmail.com "]
["sapna.bhargav9@gmail.co "]
["sarojkumar092@gmail.com"]
["satyavishwas@gmail.com"]
["kumarsatyndar@gmail.com"]
["saurabhshukla343@gmail.com "]
["saurabh.singh77926@gmail.com "]
["seema2808@yahoo.com "]
["saif.khan191@gmail.com"]
["shailendrakumar.sharma@hcl.com"]
["dubeys5@rediffmail.com"]
["ssind1990@gmail.com "]
["qumarshamsh@gmail.com "]
["shashi.ksingh2013@gmail.com"]
["shashisharma307@gmail.com "]
["mr.shatrunjay@rediffmail.com"]
["mr.shatrunjay@rediffmail.com "]
["shishir.singh@tr.com"]
["vashistha.rma@gmail.com"]
["skumar301@metlife.com "]
["shivam12priyadarshi@gmail.com"]
["shivamsadana@gmail.com"]
["shivani.nanda@yahoo.co.in"]
["shobhit.awasthi3112@gmail.com"]
["shrutijain0490@gmail.com"]
["0490shrutijain@gmail.com "]
["shruti.t.jain@gsk.com "]
["kaushik.shbhm@gmail.com "]
["shwetastar32@gmail.com"]
["sohitsharma@hotmail.com"]
["sourav.singh43@gmail.com"]
["sourabhsh84@gmail.com "]
["sourabhmaindolia@gmail.com"]
["sahusourav@yahoo.com"]
["subhash300790@gmail.com"]
["subodh.kumar999@gmail.com"]
["suchit.kumar02@gmail.com"]
["sudhir.nawani@gmail.com"]
["sudhir.nawani@gmail.com "]
["sumanbhadra40@gmail.com"]
["sumanbhadra40@gmail.com "]
["sumantanwar08@gmail.com "]
["sumittrivedi29@gmail.com"]
["sumitkujur87@gmail.com"]
["sumit.dhaliwal@rediffmail.com"]
["sumitsharmashandilya@gmail.com"]
["sunilsingh6600@gmail.com"]
["sunilbhushan1989@gmail.com"]
["sunilmishra888@gmail.com"]
["sunil.epandey@gmail.com"]
["sunilkumar04051989@gmail.com "]
["sunilbhushan1989@gmail.com "]
["surenderkusharma@gmail.com"]
["surender.bangari144@gmail.com"]
["sushilkumar.insan@yahoo.com"]
["sushil.joshi6k@gmail.com "]
["swatipai480@gamil.com"]
["swatipai480@gmail.com "]
["shusain73@yahoo.com"]
["tanseer1986@gmail.com"]
["tanya.harnal@gmail.com"]
["tapeshgupta57@gmail.com "]
["trinomoy89@gmail.com"]
["uday84dharmna@gmail.com"]
["udishatripathi@gmail.com"]
["mailz2umang@gmail.com"]
["umeshuk1089@gmail.com"]
["upanshusharma@yahoo.com"]
["upendrakumar01@gmail.com"]
["upendrakumar01@gmail.com "]
["uttamsaha9990@gmail.com"]
["satieshvsubramanian@gmail.com"]
["vaishali_gupta1991@yahoo.in"]
["vakil.2011@rediffmail.com"]
["vakil.2011@rediffmail.com "]
["varundubey35@gmail.com"]
["varun.pathak.india@gmail.com"]
["varunsharma786om@gmail.com"]
["varunsingh_786@yahoo.com"]
["taneejja4u@gmail.com"]
["j.venkat.rao2009@gmail.com"]
["j.venkat.rao2009@gmail.com "]
["vibhutibhusanbhatt@gmail.com"]
["vijaykumar1123@yahoo.com"]
["vcvikas5@gmail.com"]
["vdwivedi321@gmail.com "]
["vkmishra1@yahoo.co.in"]
["mivi.vikram@gmail.com"]
["mivi.vikram@gmail.com "]
["vnegi2016@gmail.com "]
["vimalsemwal@gmail.com"]
["Vinaaygarg.4@gmail.com"]
["vineettripathi7868@gmail.com"]
["vineetmalik007@yahoo.com"]
["vineetaverma1805@gmail.com"]
["myselfvipin@yahoo.co.in"]
["vipinchchaudhary1@gmail.com"]
["vickychoudhary578"]
["samuelvipin7@gmail.com "]
["viplab_sinha@rediffmail.com"]
["Vashishtha.idea@gmail.com"]
["viresh.gupta81@gmail.com"]
["vishaal.kohli@gmail.com"]
["vishal_theboy@yahoo.com "]
["vivekthakur419@gmail.com "]
["vivekumarhcl@gmail.com "]
["maiforvyas@gmail.com "]
["mailforvyas@gmail.com "]
["inboxshine9@gmail.com"]
["yogeshsinghnegi1986@gmail.com"]
["yogi4tini@gmail.com"]
["yogeshmehta000@gmail.com "]
["yogesh.mehta000@gmail.com "]
["yogeshsinghnegi1986@gmail.com "]
["yuvastanza@gmail.com "]
["er.zishan21@gmail.com"]
["pandey.pradeep007@gmail.com"]
["rajnesh0001@gmail.com"]
["hiatulraj@gmail.com"]
["00sbhupender7@gmail.com"]
["bisht.lakshya22@gmail.com"]
["rajputvivek64@gmail.com"]
["kuldeeprawat451@gmail.com"]
["sushildobriyal30@gmail.com"]
["shiv34465@gmail.com"]
["jitinchawla@gmail.com"]
["dk1491993@gmail.com"]
["risingstar1947@gmail.com"]
["sumeet1990ster@gmail.com"]
["gaurp.exl@gmail.com"]
["mpuri90@yahoo.com"]

{"sheet":"01","index":1,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":true,"merged":[[0,1,0,7]]}
[null,"Lets Learn Excel Function-Formulas (Prince Sethi - 9953872217)"]
[]
[]
[null,"Sales Person","No. Customers","Net Sales","Profit / Loss",null,"Questions","Formula"]
[null,"Prince",8,1592,562.77199999999993,null,"1. Sales for the person whose names starts with Pri"]
[null,"Chander",8,1088,396.9024,null,"2. How many Persons are there whose name cointain 5 Character"]
[null,"Lalita",8,1680,752.64,null,"3. Sales for the person whose name ends with t"]
[null,"Princy",9,2133,922.73579999999993,null,"4. What is the Total Sale of Lalita"]
[null,"Lalita",10,1610,579.11700000000008]
[null,"Anant",10,1540,569.79999999999995]
[null,"Vishresh",7,1316,427.56840000000005]
[null,"priya",7,1799,708.80600000000004]
[null,"Lalita",8,1624,621.3424]
[null,"Rohit",6,726,235.87740000000002]
[null,"Priti",9,2277,965.67569999999989]
[null,"Lalita",6,714,220.983]
[null,"Poly",9,2682,1023.183]

{"sheet":"02","index":2,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":true,"merged":[[0,1,0,11]]}
[null,"Lets Learn Excel Function-Formulas (Prince Sethi - 9953872217)"]
[]
[]
[null,"Write Matched When column A  employee Name \"Raj Kumar\" match with column B otherwise it should be Not Matched"]
[]
[null,"Employee Name","Employee Name2","Formulas"]
[null,"Mr. Raj Kumar Verma","Mr. Raj Kumar Verma"]
[null,"Mr. Deepak jha srivastava","Mr. Abbas khan"]
[null,"Mr. Abbas khan","Mr. Vivek Shah"]
[null,"Mr. Manjar Alam","Mr. Manjar Alam"]
[null,"Mr. Vivek Shah","Mr. Anup Kumar"]
[null,"Mr. Laxman singh Negi","Mr. Rakesh Kumar"]
[null,"Mr. Anup Kumar","Mr. Anup Kumar"]
[null,"Mr. Rakesh Kumar","Mr. Manjar Alam"]
[null,"Mr. Sohail Khan","Mr. Sohail Khan"]
[null,"Mr. Saiful Ansari","Mr. Abdul Heyat Chand"]
[null,"Mr. Abdul Heyat Chand","Mr. Saiful Ansari"]
[null,"Mr. Devendra Kumar sharma","Mr. Devendra Kumar sharma"]
[]
[]
[null,"Name","Name2","Amount",null,null,"Names","Xlri","selenium","xansa","Ibn","Lucate"]
[null,"Xlri","Depart",null,null,null,"Depart",98,53,76,61,63]
[null,"selenium","Furt",null,null,null,"Furt",648,585,606,554,547]
[null,"xansa","such",null,null,null,"such",5216,5208,7614,5991,5246]
[null,"Ibn","Sobha",null,null,null,"Sobha",22789,21167,30554,14512,32014]
[null,"Lucate","Apex",null,null,null,"Apex",186024,158163,170132,193450,189676]

{"sheet":"03","index":3,"n_rows":163,"n_cols":10,"rows_kept":163,"cut":false,"hidden":true,"merged":[[154,2,154,5],[132,2,132,8],[0,0,0,9]]}
["Lets Learn Excel Function-Formulas (Prince Sethi - 9953872217)"]
[]
["Ques. 1",null,"Using below data, provide DATE as  \"09-November-2012\" ?"]
[]
[null,null,"Date","Formula"]
[null,null,20121109]
[]
["Ques. 2",null,"Using single formula, take out the emails from below data ?"]
[]
[null,null,"Data","Email-Ids"]
[null,null,"anshika ansu@microsoft.com xyz"]
[null,null,"12 xyz john_hayden@microsoft.com 34abcd"]
[null,null,"billgates@microsoft.com 1234 abcd"]
[null,null,"abcd 1234 abcd xyz john_hayden@microsoft.com"]
[]
["Ques. 3",null,"Sales Data"]
[null,null,"Sr. No.","Name","Product","Sales Volume","Commision","Comm%","``"]
[null,null,1,"Prince","Pizza",38493,null,0.25]
[null,null,2,"Chander","Maggi",18886]
[null,null,3,"Gagan","Maggi",17635]
[null,null,4,"Salil","Maggi",33262]
[null,null,5,"Rahul","Munch",16441]
[null,null,6,"Anant","Munch",19172]
[null,null,7,"Vishresh","Burger",24435]
[null,null,8,"Rakhi","Munch",23949]
[null,null,9,"Sachin","Burger",28913]
[null,null,10,"Rohit","Pizza",10640]
[null,null,11,"Nitin","Munch",36418]
[null,null,12,"Vishal","Burger",20988]
[null,null,13,"Poly","Pizza",12663]
[null,null,14,"Durvesh","Burger",38010]
[null,null,15,"Vijay","Pizza",15339]
[null,null,16,"Ashok","Pizza",27429]
[null,null,17,"Parveen","Burger",10382]
[null,null,18,"Anajli","Maggi",12324]
[null,null,19,"Neetu","Pizza",13728]
[null,null,20,"Lalita","Maggi",29263]
[]
[null,"a. ","Using the commission % given above, calculate the commissions earned by each of the salespeople"]
[null,"b. ","Use the data given below to assign ratings to all salespeople (use the most appropriate Excel function)"]
[]
[null,null,null,"G1","G2","G3","G4","G5"]
[null,null,null,"greater than 30000","greater than 25,000 but less than or equal to 30,000","greater than 20,000 but less than or equal to 25,000","greater than 15,000 but less than or equal to 20,000","less than or equal to 15,000"]
[]
[]
[null,"c. ","Use an appropriate Excel function to rank the salespeople based on the volume of sales"]
[null,"d","Create a chart showing commission and sales by each person"]
[null,"e","Create a pie chart showing product sale"]
[]
[]
["Ques. 4",null,"Employee Name","Employee Id","Product","Area","Sale",null,"Employee Id","Employee Name"]
[null,null,null,1,"Burger","North",13811,null,71,"Prince"]
[null,null,null,2,"Burger","North",14080,null,61,"Chander"]
[null,null,null,3,"Burger","South",13536,null,51,"Gagan"]
[null,null,null,4,"Maggy","North",14730,null,41,"Salil"]
[null,null,null,5,"Maggy","East",12154,null,31,"Rahul"]
[null,null,null,6,"Munch","East",14291,null,21,"Anant"]
[null,null,null,7,"Pizza","West",12609,null,11,"Vishresh"]
[null,null,null,8,"Pizza","West",14580,null,1,"Rakhi"]
[null,null,null,9,"Subway","North",14986,null,72,"Sachin"]
[null,null,null,10,"Subway","South",12088,null,62,"Rohit"]
[null,null,null,11,"Subway","South",12418,null,52,"Nitin"]
[null,null,null,12,"Burger","North",13535,null,42,"Vishal"]
[null,null,null,13,"Munch","North",12323,null,32,"Poly"]
[null,null,null,14,"Maggy","East",13037,null,22,"Durvesh"]
[null,null,null,15,"Burger","West",14391,null,12,"Vijay"]
[null,null,null,16,"Burger","North",12873,null,2,"Ashok"]
[null,null,null,17,"Burger","South",12801,null,73,"Parveen"]
[null,null,null,18,"Maggy","South",12993,null,63,"Anajli"]
[null,null,null,19,"Maggy","North",13491,null,53,"Neetu"]
[null,null,null,20,"Munch","East",12577,null,43,"Lalita"]
[null,null,null,21,"Munch","East",13857,null,33,"Jyotsna"]
[null,null,null,22,"Pizza","West",14831,null,23,"Lalit"]
[null,null,null,23,"Pizza","West",14402,null,13,"Yesh"]
[null,null,null,24,"Subway","North",14708,null,3,"Gopal"]
[null,null,null,25,"Subway","South",12984,null,74,"Mudit"]
[null,null,null,26,"Subway","South",13113,null,64,"Arwind"]
[null,null,null,27,"Munch","North",12102,null,54,"Mamta"]
[null,null,null,28,"Munch","North",12570,null,44,"Ankit"]
[null,null,null,29,"Maggy","East",14235,null,34,"Shweta"]
[null,null,null,30,"Burger","West",14897,null,24,"Aditi"]
[null,null,null,31,"Burger","North",12451,null,14,"Roky"]
[null,null,null,32,"Burger","South",13765,null,4,"Raju"]
[null,null,null,33,"Maggy","South",13449,null,75,"Minku"]
[null,null,null,34,"Maggy","South",12030,null,65,"Tinku"]
[null,null,null,35,"Munch","East",12040,null,55,"Shinku"]
[null,null,null,36,"Munch","East",14521,null,45,"Riya"]
[null,null,null,37,"Pizza","West",14045,null,35,"Diya"]
[null,null,null,38,"Pizza","West",13400,null,25,"Piya"]
[null,null,null,39,"Subway","North",13661,null,15,"Priya"]
[null,null,null,40,"Subway","North",12449,null,5,"Rohit"]
[null,null,null,41,"Subway","South",12014,null,66,"Rajendra"]
[null,null,null,42,"Munch","South",14557,null,56,"Sunil"]
[null,null,null,43,"Munch","South",14347,null,46,"Sameer"]
[null,null,null,44,"Maggy","East",12111,null,36,"Reena"]
[null,null,null,45,"Burger","West",12898,null,26,"Tina"]
[null,null,null,46,"Burger","North",14485,null,16,"Meena"]
[null,null,null,47,"Burger","South",14068,null,6,"Pinky"]
[null,null,null,48,"Maggy","South",14295,null,67,"Tinky"]
[null,null,null,49,"Maggy","North",12200,null,57,"Anshu"]
[null,null,null,50,"Munch","East",12672,null,47,"Vanshu"]
[null,null,null,51,"Munch","East",12858,null,37,"Ganga"]
[null,null,null,52,"Pizza","West",13707,null,27,"Ram"]
[null,null,null,53,"Pizza","West",12549,null,17,"sham"]
[null,null,null,54,"Subway","North",14160,null,7,"Mohan"]
[null,null,null,55,"Subway","North",13776,null,68,"Sohan"]
[null,null,null,56,"Subway","North",13251,null,58,"Rohan"]
[null,null,null,57,"Munch","North",13131,null,48,"Tohan"]
[null,null,null,58,"Munch","North",12911,null,38,"Gurpreet"]
[null,null,null,59,"Maggy","South",14463,null,28,"Balveen"]
[null,null,null,60,"Burger","West",14995,null,18,"Jaspreet"]
[null,null,null,61,"Burger","North",12036,null,8,"Nimarta"]
[null,null,null,62,"Burger","South",13397,null,69,"Kusum"]
[null,null,null,63,"Maggy","South",14064,null,59,"Veena"]
[null,null,null,64,"Maggy","North",14403,null,49,"Devesh"]
[null,null,null,65,"Munch","East",12248,null,39,"Jamila"]
[null,null,null,66,"Munch","East",13691,null,29,"Reena"]
[null,null,null,67,"Pizza","West",12061,null,19,"Ravi"]
[null,null,null,68,"Pizza","West",13673,null,9,"Itee"]
[null,null,null,69,"Subway","North",13480,null,70,"Pradeep"]
[null,null,null,70,"Subway","North",13404,null,60,"Ishu"]
[null,null,null,71,"Subway","South",13527,null,50,"Pooja"]
[null,null,null,72,"Munch","South",14362,null,40,"Renu"]
[null,null,null,73,"Munch","South",13714,null,30,"Sunny"]
[null,null,null,74,"Maggy","East",13101,null,20,"Shivam"]
[null,null,null,75,"Burger","West",14976,null,10,"Koko"]
[]
[]
[null,"a.","Add Employee Names from the second table into the first table against the corresponding Employee ID using an appropriate Excel function"]
[null,null,"(DO NOT sort the data)"]
[null,"b.","Using Pivot Tables, place the data above in the following grid -"]
[]
[null,null,"Product"]
[null,null,"Area","Burger","Maggy","Munch","Pizza","Subway","Grand Total"]
[null,null,"East"]
[null,null,"North"]
[null,null,"South"]
[null,null,"West"]
[null,null,"Grand Total"]
[]
[]
["Ques. 5",null,"Following is a list of individuals in a Team:"]
[]
[null,null,"Name","First Name","Middle Name","Last Name","Rank"]
[null,null,"agnes mane gonzales"]
[null,null,"ahmed nawaz khedr"]
[null,null,"albrey bob james"]
[null,null,"amiphija k fajiculay"]
[null,null,"adhir rahan mane"]
[]
[null,"a.","Write a formula to separate the First and the Last names."]
[null,"b.","Rank the individuals on basis of the length of their names, the longest name being at # 1"]
[null,"c.","Write a formula to transpose the Name column into a row"]
[]
["Ques. 6",null,"Write a formula in Green Cell to show values as per filtered values in yellow cells"]
[null,null,"Country","State","District","Block"]
[null,null,"India","AA","South","A"]
[null,null,"China","BB","West","D"]
[null,null,"Germany","CC","North","E"]
[null,null,"London","DD","East","G"]
[]
[]
[null,null,"India","AA","South"]

{"sheet":"3a","index":4,"n_rows":171,"n_cols":17,"rows_kept":171,"cut":false,"hidden":true,"merged":[[0,0,0,9],[132,2,132,8],[162,2,162,5]]}
["Lets Learn Excel Function-Formulas (Prince Sethi - 9953872217)"]
[]
["Ques. 1",null,"Using below data, provide DATE as  \"09-November-2012\" ?"]
[]
[null,null,"Date","Formula"]
[null,null,20121109]
[]
["Ques. 2",null,"Using single formula, take out the emails from below data ?"]
[]
[null,null,"Data","Email-Ids"]
[null,null,"anshika ansu@microsoft.com xyz"]
[null,null,"12 xyz john_hayden@microsoft.com 34abcd"]
[null,null,"billgates@microsoft.com 1234 abcd"]
[null,null,"abcd 1234 abcd xyz john_hayden@microsoft.com"]
[]
["Ques. 3",null,"Sales Data"]
[null,null,"Sr. No.","Name","Product","Sales Volume","Commision",null,null,"Comm%"]
[null,null,1,"Prince","Pizza",38493,{"$f":"F18*25/100","v":9623.25},{"$f":"IF(F18<15000,\"G5\",IF(AND(F18>15000,F18<20000),\"G4\",IF(AND(F18>20000,F18<25000),\"G3\",IF(AND(F18>25000,F18<30000),\"G2\",\"G1\"))))","v":"G1"},{"$f":"RANK(F18,$F$18:$F$37,)","v":1},0.25]
[null,null,2,"Chander","Maggi",18886,{"$f":"F19*25/100","v":4721.5},{"$f":"IF(F19<15000,\"G5\",IF(AND(F19>15000,F19<20000),\"G4\",IF(AND(F19>20000,F19<25000),\"G3\",IF(AND(F19>25000,F19<30000),\"G2\",\"G1\"))))","v":"G4"},{"$f":"RANK(F19,$F$18:$F$37,)","v":12}]
[null,null,3,"Gagan","Maggi",17635,4408.75,"G4",13]
[null,null,4,"Salil","Maggi",33262,8315.5,"G1",4]
[null,null,5,"Rahul","Munch",16441,4110.25,"G4",14]
[null,null,6,"Anant","Munch",19172,4793,"G4",11]
[null,null,7,"Vishresh","Burger",24435,6108.75,"G3",8]
[null,null,8,"Rakhi","Munch",23949,5987.25,"G3",9]
[null,null,9,"Sachin","Burger",28913,7228.25,"G2",6]
[null,null,10,"Rohit","Pizza",10640,2660,"G5",19]
[null,null,11,"Nitin","Munch",36418,9104.5,"G1",3]
[null,null,12,"Vishal","Burger",20988,5247,"G3",10]
[null,null,13,"Poly","Pizza",12663,3165.75,"G5",17]
[null,null,14,"Durvesh","Burger",38010,9502.5,"G1",2]
[null,null,15,"Vijay","Pizza",15339,3834.75,"G4",15]
[null,null,16,"Ashok","Pizza",27429,6857.25,"G2",7]
[null,null,17,"Parveen","Burger",10382,2595.5,"G5",20]
[null,null,18,"Anajli","Maggi",12324,3081,"G5",18]
[null,null,19,"Neetu","Pizza",13728,3432,"G5",16]
[null,null,20,"Lalita","Maggi",29263,7315.75,"G2",5]
[]
[null,"a. ","Using the commission % given above, calculate the commissions earned by each of the salespeople"]
[null,"b. ","Use the data given below to assign ratings to all salespeople (use the most appropriate Excel function)"]
[]
[null,null,null,"G1","G2","G3","G4","G5"]
[null,null,null,"greater than 30000","greater than 25,000 but less than or equal to 30,000","greater than 20,000 but less than or equal to 25,000","greater than 15,000 but less than or equal to 20,000","less than or equal to 15,000"]
[]
[]
[null,"c. ","Use an appropriate Excel function to rank the salespeople based on the volume of sales"]
[null,"d","Create a chart showing commission and sales by each person"]
[null,"e","Create a pie chart showing product sale"]
[]
[]
["Ques. 4",null,"Employee Name","Employee Id","Product","Area","Sale",null,"Employee Id","Employee Name"]
[null,null,{"$f":"INDEX($J$52:$J$126,MATCH(D52,$I$52:$I$126,0))","v":"Rakhi"},1,"Burger","North",13811,null,71,"Prince"]
[null,null,{"$f":"INDEX($J$52:$J$126,MATCH(D53,$I$52:$I$126,0))","v":"Ashok"},2,"Burger","North",14080,null,61,"Chander"]
[null,null,"Gopal",3,"Burger","South",13536,null,51,"Gagan"]
[null,null,"Raju",4,"Maggy","North",14730,null,41,"Salil"]
[null,null,"Rohit",5,"Maggy","East",12154,null,31,"Rahul"]
[null,null,"Pinky",6,"Munch","East",14291,null,21,"Anant"]
[null,null,"Mohan",7,"Pizza","West",12609,null,11,"Vishresh"]
[null,null,"Nimarta",8,"Pizza","West",14580,null,1,"Rakhi"]
[null,null,"Itee",9,"Subway","North",14986,null,72,"Sachin"]
[null,null,"Koko",10,"Subway","South",12088,null,62,"Rohit"]
[null,null,"Vishresh",11,"Subway","South",12418,null,52,"Nitin"]
[null,null,"Vijay",12,"Burger","North",13535,null,42,"Vishal"]
[null,null,"Yesh",13,"Munch","North",12323,null,32,"Poly"]
[null,null,"Roky",14,"Maggy","East",13037,null,22,"Durvesh"]
[null,null,"Priya",15,"Burger","West",14391,null,12,"Vijay"]
[null,null,"Meena",16,"Burger","North",12873,null,2,"Ashok"]
[null,null,"sham",17,"Burger","South",12801,null,73,"Parveen"]
[null,null,"Jaspreet",18,"Maggy","South",12993,null,63,"Anajli"]
[null,null,"Ravi",19,"Maggy","North",13491,null,53,"Neetu"]
[null,null,"Shivam",20,"Munch","East",12577,null,43,"Lalita"]
[null,null,"Anant",21,"Munch","East",13857,null,33,"Jyotsna"]
[null,null,"Durvesh",22,"Pizza","West",14831,null,23,"Lalit"]
[null,null,"Lalit",23,"Pizza","West",14402,null,13,"Yesh"]
[null,null,"Aditi",24,"Subway","North",14708,null,3,"Gopal"]
[null,null,"Piya",25,"Subway","South",12984,null,74,"Mudit"]
[null,null,"Tina",26,"Subway","South",13113,null,64,"Arwind"]
[null,null,"Ram",27,"Munch","North",12102,null,54,"Mamta"]
[null,null,"Balveen",28,"Munch","North",12570,null,44,"Ankit"]
[null,null,"Reena",29,"Maggy","East",14235,null,34,"Shweta"]
[null,null,"Sunny",30,"Burger","West",14897,null,24,"Aditi"]
[null,null,"Rahul",31,"Burger","North",12451,null,14,"Roky"]
[null,null,"Poly",32,"Burger","South",13765,null,4,"Raju"]
[null,null,"Jyotsna",33,"Maggy","South",13449,null,75,"Minku"]
[null,null,"Shweta",34,"Maggy","South",12030,null,65,"Tinku"]
[null,null,"Diya",35,"Munch","East",12040,null,55,"Shinku"]
[null,null,"Reena",36,"Munch","East",14521,null,45,"Riya"]
[null,null,"Ganga",37,"Pizza","West",14045,null,35,"Diya"]
[null,null,"Gurpreet",38,"Pizza","West",13400,null,25,"Piya"]
[null,null,"Jamila",39,"Subway","North",13661,null,15,"Priya"]
[null,null,"Renu",40,"Subway","North",12449,null,5,"Rohit"]
[null,null,"Salil",41,"Subway","South",12014,null,66,"Rajendra"]
[null,null,"Vishal",42,"Munch","South",14557,null,56,"Sunil"]
[null,null,"Lalita",43,"Munch","South",14347,null,46,"Sameer"]
[null,null,"Ankit",44,"Maggy","East",12111,null,36,"Reena"]
[null,null,"Riya",45,"Burger","West",12898,null,26,"Tina"]
[null,null,"Sameer",46,"Burger","North",14485,null,16,"Meena"]
[null,null,"Vanshu",47,"Burger","South",14068,null,6,"Pinky"]
[null,null,"Tohan",48,"Maggy","South",14295,null,67,"Tinky"]
[null,null,"Devesh",49,"Maggy","North",12200,null,57,"Anshu"]
[null,null,"Pooja",50,"Munch","East",12672,null,47,"Vanshu"]
[null,null,"Gagan",51,"Munch","East",12858,null,37,"Ganga"]
[null,null,"Nitin",52,"Pizza","West",13707,null,27,"Ram"]
[null,null,"Neetu",53,"Pizza","West",12549,null,17,"sham"]
[null,null,"Mamta",54,"Subway","North",14160,null,7,"Mohan"]
[null,null,"Shinku",55,"Subway","North",13776,null,68,"Sohan"]
[null,null,"Sunil",56,"Subway","North",13251,null,58,"Rohan"]
[null,null,"Anshu",57,"Munch","North",13131,null,48,"Tohan"]
[null,null,"Rohan",58,"Munch","North",12911,null,38,"Gurpreet"]
[null,null,"Veena",59,"Maggy","South",14463,null,28,"Balveen"]
[null,null,"Ishu",60,"Burger","West",14995,null,18,"Jaspreet"]
[null,null,"Chander",61,"Burger","North",12036,null,8,"Nimarta"]
[null,null,"Rohit",62,"Burger","South",13397,null,69,"Kusum"]
[null,null,"Anajli",63,"Maggy","South",14064,null,59,"Veena"]
[null,null,"Arwind",64,"Maggy","North",14403,null,49,"Devesh"]
[null,null,"Tinku",65,"Munch","East",12248,null,39,"Jamila"]
[null,null,{"$f":"INDEX($J$52:$J$126,MATCH(D117,$I$52:$I$126,0))","v":"Rajendra"},66,"Munch","East",13691,null,29,"Reena"]
[null,null,"Tinky",67,"Pizza","West",12061,null,19,"Ravi"]
[null,null,"Sohan",68,"Pizza","West",13673,null,9,"Itee"]
[null,null,"Kusum",69,"Subway","North",13480,null,70,"Pradeep"]
[null,null,"Pradeep",70,"Subway","North",13404,null,60,"Ishu"]
[null,null,"Prince",71,"Subway","South",13527,null,50,"Pooja"]
[null,null,"Sachin",72,"Munch","South",14362,null,40,"Renu"]
[null,null,"Parveen",73,"Munch","South",13714,null,30,"Sunny"]
[null,null,"Mudit",74,"Maggy","East",13101,null,20,"Shivam"]
[null,null,"Minku",75,"Burger","West",14976,null,10,"Koko"]
[]
[]
[null,"a.","Add Employee Names from the second table into the first table against the corresponding Employee ID using an appropriate Excel function"]
[null,null,"(DO NOT sort the data)"]
[null,"b.","Using Pivot Tables, place the data above in the following grid -"]
[]
[null,null,"Product"]
[null,null,"Sum of Sale","Column Labels"]
[null,null,"Row Labels","Burger","Maggy","Munch","Pizza","Subway","Grand Total"]
[null,null,"East",null,64638,118755,null,null,183393]
[null,null,"North",93271,54824,63037,null,123875,335007]
[null,null,"South",67567,81294,56980,null,76144,281985]
[null,null,"West",72157,null,null,135857,null,208014]
[null,null,"Grand Total",232995,200756,238772,135857,200019,1008399]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Ques. 5",null,"Following is a list of individuals in a Team:"]
[]
[null,null,"Name","First Name","Middle Name","Last Name","Rank","find","left","add 1 to find","find2","diff","mid","mid","len","diff2","last"]
[null,null,"agnes mane gonzales",{"$f":"LEFT(C153,FIND(\" \",C153)-1)","v":"agnes"},{"$f":"MID(C153,FIND(\" \",C153)+1,FIND(\" \",C153,FIND(\" \",C153)+1)-J153)","v":"mane"},{"$f":"RIGHT(C153,LEN(C153)-FIND(\" \",C153,FIND(\" \",C153)+1))","v":"gonzales"},{"$f":"RANK(O153,$O$153:$O$157)","v":2},{"$f":"FIND(\" \",C153)","v":6},{"$f":"LEFT(C153,H153-1)","v":"agnes"},{"$f":"FIND(\" \",C153)+1","v":7},{"$f":"FIND(\" \",C153,FIND(\" \",C153)+1)","v":11},{"$f":"FIND(\" \",C153,FIND(\" \",C153)+1)-J153","v":4},{"$f":"MID(C153,J153,L153)","v":"mane"},{"$f":"MID(C153,FIND(\" \",C153)+1,FIND(\" \",C153,FIND(\" \",C153)+1)-J153)","v":"mane"},{"$f":"LEN(C153)","v":19},{"$f":"LEN(C153)-FIND(\" \",C153,FIND(\" \",C153)+1)","v":8},{"$f":"RIGHT(C153,LEN(C153)-FIND(\" \",C153,FIND(\" \",C153)+1))","v":"gonzales"}]
[null,null,"ahmed nawaz khedr",{"$f":"LEFT(C154,FIND(\" \",C154)-1)","v":"ahmed"},{"$f":"MID(C154,FIND(\" \",C154)+1,FIND(\" \",C154,FIND(\" \",C154)+1)-J154)","v":"nawaz"},{"$f":"RIGHT(C154,LEN(C154)-FIND(\" \",C154,FIND(\" \",C154)+1))","v":"khedr"},{"$f":"RANK(O154,$O$153:$O$157)","v":3},{"$f":"FIND(\" \",C154)","v":6},{"$f":"LEFT(C154,H154-1)","v":"ahmed"},{"$f":"H154+1","v":7},{"$f":"FIND(\" \",C154,J154)","v":12},{"$f":"K154-J154","v":5},{"$f":"MID(C154,J154,L154)","v":"nawaz"},null,{"$f":"LEN(C154)","v":17}]
[null,null,"albrey bob james","albrey","bob","james",4,7,"albrey",8,11,3,{"$f":"MID(C155,J155,L155)","v":"bob"},null,16]
[null,null,"amiphija k fajiculay","amiphija","k","fajiculay",1,9,"amiphija",10,11,1,"k",null,20]
[null,null,"adhir rahan mane","adhir","rahan","mane",4,6,"adhir",7,12,5,"rahan",null,16]
[]
[null,"a.","Write a formula to separate the First and the Last names."]
[null,"b.","Rank the individuals on basis of the length of their names, the longest name being at # 1"]
[null,"c.","Write a formula to transpose the Name column into a row",null,null,null,"????"]
[]
["Ques. 6",null,"Write a formula in Green Cell to show values as per filtered values in yellow cells"]
[null,null,"Country","State","District","Block"]
[null,null,"India","AA","South","A"]
[null,null,"China","BB","West","D"]
[null,null,"Germany","CC","North","E"]
[null,null,"London","DD","East","G"]
[]
[]
[null,null,"India","AA","South",null,"????"]

{"sheet":"04","index":5,"n_rows":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":true,"merged":[[0,0,0,11]]}
["Lets Learn Excel Function-Formulas (Prince Sethi - 9953872217)"]
[]
[null,null,null,null,null,null,null,102]
["Code","Name","DOB"]
[101,"Prince","1982-08-10",null,"Q1","Find the age of Person whose code is given in H3 cell code can be changeable."]
[102,"Chander","1988-09-25",null,null,"??????????????"]
[103,"Gagan","1986-08-17"]
[104,"Salil","1990-02-25"]
[105,"Rahul","1987-01-18"]
[]
[]
[]
[15,"rt89",null,null,"Q2","Count How Many Text Values are there in Range(A12:C17)"]
[20," ","dfdf"]
[null,56,23]
["fdfdf",78,45]
["55hh",55,897]
[555,"fdf23",145]
[]
[]
[null,null,"Category",null,"Q3 : Count number of instances Containing Apple Word"]
[null,null,"Red Apples"]
[null,null,"Green Apples"]
[null,null,"Gala Apples"]
[null,null,"Pineapples"]
[null,null,"Oranges"]
[]
[]
["Name","TL","Amount",null,"Calculate total amount of A whose TL Is AA"]
["a","aa",80]
["b","bb",33,null,"Name","TL","Total Amount"]
["c","aa",56,null,"A","aa"]
["d","aa",88]
["a","aa",80]
["f","bb",60]
["g","aa",55]
["a","aa",80]
["a","bb",90]
["j","aa",96]
["a","bb",80]

{"sheet":"05","index":6,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":true,"merged":[[21,4,21,6],[0,0,0,7],[5,4,5,6],[10,4,10,6],[15,4,15,6]]}
["Lets Learn Excel Function-Formulas (Prince Sethi - 9953872217)"]
[]
[]
[null,"Is Leap Year"]
[null,"Returns True if Year is a leap year. Returns False if not a leap year."]
[null,"Year",null,null,"Formula Required"]
[null,1988]
[]
[null,"Days In Month","2011-05-31",null,"Output Should be : 31"]
[null,"Returns the number of days for a month and year."]
[null,"Year","Month",null,"Formula Required"]
[null,2011,5]
[]
[null,"First Day Of Month",null,null,"Output Should be : 01/01/2011"]
[null,"Returns the date of the first day of a month and year."]
[null,"Date",null,null,"Formula Required"]
[null,"2011-01-15"]
[]
[null,"Last Day Of Month"]
[null,"Returns the date of the last day of a month and year.",null,null,"Output Should be : 31/01/2011"]
[null,"Date"]
[null,"2011-01-15",null,null,"Formula Required"]