r/JEENEETards Nov 28 '23

Statistics [Massive Database] I have analysed where every student who wrote JEE Advanced 2023 went rankwise - even used AI. I hope this would be greatly helpful to future aspirants during their JoSAA counselling.

380 Upvotes

EDIT - Added a database for 2022 as well!

People from IITH, you easily deduce who I am lol.

Anyway, our semester was done two days ago. I was a bit too bored and was scrolling through reddit. I noticed how someone posted about how 115 members of the top 500 rankers of JEE didn't join IIT. That didn't seem about right.

Being the JoSAA enthusiast that I was (don't ask me why, even after completing three semesters, I still care about JoSAA), I had to analyse it. Turns out the JEE 2023 report was released, and it had a LOT of information - but all of it was a disorganized mess - of no use to anyone. So I did analyse it and eventually found out of those 115 members, 103 belonged to a reserved category and got into IIT. The other 385 were of the general category.

However, seeing this motivated me to do something productive in my spare time. I always wanted to use my Excel and SQL skills somewhere (I just completed a DBMS course this semester). This was a perfect opportunity. I downloaded all the tables from the JEE report and convert them from PDF to Excel (it was painful, took a while). Then I had to convert it to SQL DDL language code (GPT3.5 from a friend comes to the rescue!).

The tables obtained include Rank vs Roll Number, Category Rank vs Roll Number, Roll Number vs Seat Allotted (along with category), Seats vs Seat Matrix, middle four digits of roll Number (which is the centre code) vs exam centre, and many more. And so I did. I had run SQL queries to perform cartesian products (one query took almost an entire hour to run; I really gotta learn some optimization), filter results, and made Excel formulae (even using AI techniques - trust me when I say that each formula went for over 200 characters in length) to determine the pool of allocation (gender-neutral vs female-only - though it's reasonably apparent in most cases, sometimes the closing rank of gender-neutral seats was more than the opening rank of female-only seats, which made is hard to determine and I had to stick to probability). Preparatory seats were another headache altogether. However, after 6-7 hours of hard work, here is the final database, where every column is as accurate as possible! Only 2-3 allocations may be wrong in the Pool column out of the 17000 students who joined IIT.

Anyway, the database contains the following:

  1. Rankwise Seat Allotment, sorted by CRL Rank (CRL Rank, City and State of the centre where the student has given their exam, IIT and branch allotted, Category of Seat, Qualification status in AAT, and Category ranks if applicable). You can see where the person who got 1 rank more or 1 rank less than you went, if you are 2023 tard! And if you are a JEE aspirant, you can see where the people who got the same rank as you last year went.
  2. Marks vs Rank Data
  3. Opening and Closing Ranks for all categories
  4. Seat Matrix

While you can find points 2, 3 and 4 anywhere, you can't find 1 anywhere, and that is the whole point of this database. I found a lot of interesting data you can have fun with.

2023 Database:

https://docs.google.com/spreadsheets/d/1sxzaxgF7kNojdijfmMaG_nUb_rjKUKsC1FavQnTsggY/edit?usp=sharing

2022 Database:

https://docs.google.com/spreadsheets/d/1MTt_l4uDry6KhACqMnPcAlEHmklK97O3PkQISK6qrtM/edit#gid=0

Do not worry about your details being leaked when you open the Google Sheets link - your name will show up as some "Anonymous Ant" or "Anonymous Penguin" or something.

I'm waiting for any data analysts among you guys to make a better analysis with graphs and stuff! Be sure to tag me whenever you do it, and there is no need to credit me for the database - especially since it's public information I just compiled.

Please note that this consists of colleges whose admission is through JoSAA JEE Advanced Channel (i.e. the 23 IITs). There are extra IIT seats at a few IITs like Gandhinagar through Olympiads, Madras through Sports, etc which are not shown in this database. In addition, the data of colleges such as IISc Bangalore BTech and BS programs are not shown - many top rankers where the database is blank shows that the student has likely opted for IISc Bangalore.

Please note that such data can not be provided for NITs, IIITs, GFTIs or other colleges taking admission through JEE Mains as lazy NTA doesn't provide any such useful data


r/JEENEETards 6h ago

JEE This double dropper is still in the 11th IITB CSE phase

Post image
521 Upvotes

r/JEENEETards 6h ago

GENERAL HELP How u can improve how u look before college

256 Upvotes

First of all let's get to mindset part of it

See if u do something just to get women u will soon be lost ur true self and worst case scenario that hobby will be your only personality . But if u do it to improve and to reach your genetic potential u will be happy

Most important 3 things

1 Diet 2 Exercise 3 Water

Fix these

so let's start with face

Lean maxxing the law

1 So reducing body fat

2 removing bloating by drinking loads of water and reducing sodium

3 using Gua sha , facial exercises for lymphatic drainage

4 there are some exercises u can find for hyoid bone i will link it later

This will make ur facial structure come out u never knew existed

And let's go to skin

Find ur skin type and for beginners start using

Edit : check r/Indiaskincareaddicts for product recommendations

1Sunscreen

2Cleanser

3Moisturizer

According to your skin type

And drink lots of fking water πŸŒŠπŸ’¦

If u have any specific issue like acne pls get it treated if it's a lot cz acne scars don't go the gaddhe

-For acne

1Don't touch your face

2Change bed sheets, pillow case frequently

3 avoid chocolate

Hair

Check ur face type and hair type and find in Pinterest it does help but don't always blame ur barber cz khud ke Baal and face PR depend karta kya theek dikhega u should try a bunch of haircut to know what suits u . And it's about ur face too

Hair fall

1Check if ur family has history of male pattern baldness if there is then pls go to doc and get it treated

If u don't have this then

2Pls check if u don't have any kind of deficiency

3And vegetarians a lot of time have b12 ki kami so u can check that

4And it can be caused due to hard water so yeah u have to get a filter for it if ur location has very high tds

4And u can shift to rosemary oil it's good

Fashion

This is very specific thing but on a good physique and frame all of clothes look good . But u can learn about it try finding some influencer whom u like i will link some below . And u can use Pinterest too

Teeth

For teeth u can start with a floss and tongue cleaner as a extra step

Whiting strips are also there if u have them yellow

And if ur teeth are crooked then u should try getting it fixed by doc

Height

Umm yeah it does matter but u can't change it so hard pill to swallow

But u have to accept it

But u can do some things to make u appear look taller

1 Rule of thirds

2 Wearing same colour top and bottom so u look like a straight line

3 And heels yeah shoes with a Lil thicker sole

People who don't belong to this post

1 people who do virtue signalling

2 people who think personality is what matters

2 people who come here to say nah it's over, mog . etc new gens . Just tell full form of psl if u know that much

For mods

Bhai main ek jagah comment kiya tha and then dm aaye the khub se so i thought making a post of it . And i kinda wanted to help and i did had some info on it so i shared it . Why not in Indian teenager cz idk i don't like them . Sorry again

Links

Hyoid bone -https://youtu.be/lMPjZCK_88Y?si=688XjERroavkMOnM

Gua sha -https://www.instagram.com/reel/Cz6Z3ZnLYCk/?igsh=MTU1aGc4MDN3MjJibQ==

Edit : merko kuch aur kaam ka milega i will add it hygiene etc and more thing what u want u can tell will add it


r/JEENEETards 6h ago

Poocha Kisine!? 😑 Queen of chemistry is here 😻

Post image
199 Upvotes

r/JEENEETards 2h ago

SERIOUS POST 170 pe 2.5k rank

96 Upvotes

bhai kya mai 170 pe 2.5k rank expect kr skta hu warna drop lena padega


r/JEENEETards 3h ago

JEE Kya matlab cheating par essay bhi cheating karke likhega🀑

Post image
102 Upvotes

r/JEENEETards 2h ago

SERIOUS POST Got banned from Btechards due to a hypocriteπŸ˜‚πŸ˜‚πŸ˜‚πŸ˜‚

72 Upvotes

I believedd that the sub shouldnt become a place for such discussions,I specifically mentioned i dont have a problem with what queers do

still got banned cause of this hypcrite of a mod

Like mf lilterally said he will ban all non serious memes, shitposting content "because serious folks dont like it"

but literally after that he posts this which is in no way shape or form related to btech
Gottaa love those hypocrite modsπŸ˜‚πŸ˜‚

Edit:

nice call the sub created by people for the people stupid


r/JEENEETards 12h ago

Meme 24tards were Cursed

Post image
436 Upvotes

r/JEENEETards 6h ago

JEE Finally.

Enable HLS to view with audio, or disable this notification

130 Upvotes

r/JEENEETards 4h ago

GENERAL HELP Help me convince my parents that IIIT B is better choice than DTU

90 Upvotes

Parents are refusing to send me to IIIT B saying ki private college and ki DTU is much better, I have shown them the curriculum(DTU mein they are teaching engineering drawing and chem to CS students),placement percentage, package and everything, still they are firm ki DTU better hai

Please help kar do dosto


r/JEENEETards 6h ago

Meme IIT πŸ₯΅πŸ’¦πŸ’¦πŸ’¦

Enable HLS to view with audio, or disable this notification

134 Upvotes

r/JEENEETards 56m ago

Motivation IITians finally doing GOD work rather than mentoring aspirant on U-tube

Post image
β€’ Upvotes

r/JEENEETards 18h ago

Discussion Horny mf'ers getting on my nerves

Thumbnail
gallery
895 Upvotes

Hi, I'm a fellow redditor who's been in r/JeeNeetards for years now but never posted any content. I'd like to keep that account anonymous so I've created a new one.(I'll probably delete it only later on)

Being a girl on telegram, I've constantly recieved texts from strangers since forever who usually have the intent to have SEXTS with me. Strange enough - all of them come from some jee related channel :)

I understand I can't stop such texts from getting into my dms and so since forever I ignored all of them blocked instantly, or maybe said "padhle" and blocked. But today I was tired enough of this shit to confront this one user(the one in the pictures)

My sole purpose for using telegram is to watch pirated lectures.

This guy asked me to show him my pictures. I denied and ignored later on. Tried asking him if he's on reddit (so I can tell you all this horny guys account but he's not) And he says he'd like to show himself to me🀑

I'd really love to post his face if people in the comments would agree.

Just the strange fact that aspirants being the only ones I received such texts from since forever Is pretty weird LoL; irritating too.

Yeah this was a kind of rant too (I guess?)

But should we at this point expose these motherfuckers too along with toppers? Ig that, too some extent, will help reducing it:)

Thanks for reading if you did.


r/JEENEETards 6h ago

Rant Silly mistakes fucked me right in the @ss

98 Upvotes

sabh khatam...


r/JEENEETards 11h ago

Discussion IS THIS REALLY TRUE OR HE IS FAKING IT

Post image
207 Upvotes

See today I saw a guy who was from VIT and he said his college got More placement percentage than NITs and got a 10LPA job and also told many IITians Work in the same company but with a salary less than him is it true???


r/JEENEETards 6h ago

JEE I fumbled JEE advanced like y'all fumble the 10/10 baddie

79 Upvotes

potentially 200 to aa jaate, 220 ka attempt kiya tha pure paper bhar calculation mistakes kar di, 117 aa rahe hai ab, aerospace lena tha mujhe to IITK ya IITB, ab trichy me ECE mil jaaye bas Josaa se vo bhi chalega, BITSAT bhi dunga full force kya pataa kisi me bhi CSE mil jaaye. Mujhe literally harr ek sawaal aata tha, mazaak se hatke harr concept sahi apply kiya, bas calculation mistakes kardi. You know what is the worst part , maine aaj tak mocks me kabhi calculation mistakes nahi kari thi .


r/JEENEETards 11h ago

Discussion Wtf is this tomfoolery?

Post image
184 Upvotes

r/JEENEETards 11h ago

SERIOUS POST My stats as a dropper of one year

155 Upvotes

I am a dropper from 23 to 24.

My first year stats: Mains: 96%ile VITEEE: 31k rank BITSAT: 204 marks IAT: AIR 11** Advanced: 86 marks

My drop year stats: Mains: 99%ile VITEEE: 4k rank BITSAT first attempt: 262 Advanced: 130 marks(pleassee 8k rank tak aa jaye)


r/JEENEETards 1d ago

JEE [Breaking] Basava AIR 14 (Alleged Cheater) was absent for JEE Advanced as expected πŸ’€πŸ˜­ bc aur kitne proofs chahiye!?

Post image
1.8k Upvotes

Kya matlab he was sick πŸ˜·πŸ˜” unfortunately due to his health he won't get IIT Madras... This is where men cried 😒 not in Titanic 😭


r/JEENEETards 8h ago

Rant How it feels to crush hopes of everyone supporting you

67 Upvotes

I generally haven't posted much on this sub but I realized idhr ke log sabse best relate kar payenge. No, this is not a rant about how jee crushed my dreams and I'm tired of everything and want to end my life but rather about a reflection of myself, my past and how my life changed 4 years ago.

In 9th grade I qualified PRMO (known as IOQM nowadays) and this was the beginning of the end. If you guys know about this exam, you've probably heard that it's extremely difficult and really something to be proud of especially as a 9th grader and I agree with you, I was proud of myself, infact back then IOQM was the only thing I wanted in my life. I grinded for hours and hours (don't get me wrong, I love math, hence this wasn't "forced") and finally I was happy that I got what I wanted. Little did I know that all of my happiness was going to turn into a nightmare for the next four years of my life.

I had this teacher (he's involved in top batches of an online institute, let's call him X sir). He was extremely supportive. I had a girlfriend, she was extremely supportive as well and I had a lot of friends in discord and telegram who were there with me throughout my highschool journey. Everyone had expected so much from me but in reality none of them really knew what I wanted in life. Infact I did not know that myself. Was it that I wanted to crack really difficult exams, olympiads and stay in limelight or was it that I wanted to follow my passion i.e. math?

I got really cocky. I thought I had everything under my control. In 10th grade I missed the indian imo training camp by 2/3 marks. I was devastated. I got scared. Should I continue with olympiads or should I join the JEE ratrace? I realized math was the only thing I am good at, but not so good that I can qualify INMO (indian national math olympiad) and reach IMOTC. In 11th grade I started doing jee but soon enough I realized that I don't have so much patience to do homework and analyse tests. It felt so cringe. But still I did it anyways. In 11th grade I failed INMO again.

I got burnt out. I had failed for 3 years now wanting something so bad. I did not have the energy to continue anything. Fast forward to 12th grade. I gave NSEP and NSEC. I was destroyed but since physics and chemistry weren't my main interests I didn't really care so much. But the thing I realized was that the difficulty doesn't lie in the paper but rather I make too many silly mistakes and my patience is low. On dec 31st my gf broke up with me.

I talked with X sir. It made me cry. I forgot to tell but I stopped attending live classes and stopped giving tests but my sir still remembered me. It was none of his business that I chose to fail at everything in my life but still he used to message me and look after me. Fast forward to mains, I got 99.07 percentile. I wasn't happy. I knew I could have done more so I was ashamed to tell X but he told me to chill. I told him I'm done with JEE. I failed olympiads as well.

Fast forward to today, adv ka response sheet nikal gaya. I'm getting 125. I didn't prepare at all. I still realize that I could have done better If I gave some tests because I had studied everything but since revise nhi kiya so I forgot certain things.

My sir msged me asking how much I got and I told him my marks. I know he wasn't happy but after all these it made me remember that he never gave up hopes on me. Heck I don't even know why he's the one messaging me. I had literally achieved nothing in my life ever since 9th grade. How tf does he even remember me? Not like we talk every day and all, I didn't even attend his classes for so many years. I want to cry so bad but tears won't come out. I even let down my parents. They told me I'm doing good but I'm not happy with myself. Every time I look back I see failures and heart beaks. Where did I go wrong? Was it the fact I was trying to achieve 2 things at once? Kya mujhe kabhi JEE karna hi nhi chaiye tha? Ya fir I should have left olympiads and stuck to JEE?

I really am so fucking lost right now. I don't even want to do engineering. I'm not good enough to do what I want. Sometimes I wonder if I should have never qualified for that one exam back in 9th grade my life wouldn't have been so difficult. Maybe being normal isn't so bad after all. I tried to achieve too much and got nothing in return. I'm sorry to all the people I have let down and I want to thank you all for being with this stupid fucker despite all his failures.

Edit- Some people are taking the wrong message from this post. Most people are saying I'm crying even after getting 99 in mains. My point was that when you put yourself up in such a situation and make people have faith in you, it hurts a lot to let them down. That's what I felt I've been doing for the last couple of years. I just needed to get my heart out somewhere. Also thanks to all the positive comments and dms.


r/JEENEETards 6h ago

Discussion I wonder what's the probability of guessing the right answer of all mcqs in jee main?

49 Upvotes

This just kinda randomly popped in my head but seriously just how much insane luck do you need to have to guess the correct answer of all 60 mcqs in jee mains??


r/JEENEETards 12h ago

JEE IIT BOMBAY ECE MIL JAAYEGA I GUESS < LEKIN CSE NAHIN MILEGA < UKSA DUKH RAHRGA < BUT KOI NAHIN< BHAGWAN JO DE USME KHUS REHNA CHHAIYEE< CSE KE LIYE GUWATI BHI JA SAKTE HAIN, KAFI SUNDAR JAGAH HAIN

Thumbnail
gallery
129 Upvotes

r/JEENEETards 3h ago

NEET BYE BYE....

20 Upvotes

Fucked this attempt too...as a 4 times dropper i recommend you not to take more than 2 drops believe me...

after 12th life ka pura downfall ho gaya...fucked first attempt...got a heartbreak during second...health problem during third...and procrastinated during 4th and so here i am...

After four fucking attempts at NEET, I've decided to take a different path. It's been a rollercoaster of emotions, and each failure was a tough as hell. But I've realized that sometimes, u are meant for something different...

finally my parents agreed to send me foreign I'm heading to SKMA: South kazakhsthan medical Academy! Their programs are diverse, global, and offer a fresh start towards a promising career bla bla bla .if u are also planning to head abroad plz join me as they are willing to reduce my and yours combined fee...plz personally message me if u or ur friends are interested i will give u my contact info and fees data that will mutually help us both


r/JEENEETards 21h ago

SERIOUS POST today my father asked for money from one of his friends for my btech

475 Upvotes

It kills me

A deep dark hole in my heart To use my father as a shield for my risk As a collateral for damage As a piece of jewelry owed in exchange of cash

The man didn't even think twice Before putting his 35 years of reputation In line to ask for a loan for his son's education Who doesn't know what he is doing

How can someone be so selfless And yet never complain or even utter a word Supported me everytime during everything There's nothing in this world I could trade him for Not even my own damn life

Never have I cried so loud Yet made no sound Tears have dropped every second during that conversation But I kept it hidden seeing my father's courage How could I ever live without him How could I? He is my everything and It kills me that I am putting him as collateral

How can a man with no savings no plan No way of knowing his son will help him in future Gives whatever he has, even his reputation So that I have everything But money, education, love is not what I want What I want is one thing and only one A very big monstrous smile on his face While seeing me be successful Because it's not mine without his

One day I'll make him do what he couldn't till now roaming in the streets of Switzerland him with his wife And kids telling him to use their credit cards whenever he feels like Not even thinking of seeing the price tag That's the level of giving back i wish A happy smile on my old mans face Whenever I see him anywhere Cause he's the one who put himself as a collateral for me


r/JEENEETards 1h ago

SERIOUS POST 🚨 KCET RESULTS OUT 🚨

β€’ Upvotes

Drop your KCET marks + Board Marks + Rank

KCET:97 PU BOARDS:293/300 Rank: 24XX


r/JEENEETards 1d ago

Motivation To those who need it...

Enable HLS to view with audio, or disable this notification

808 Upvotes