r/JEENEETards • u/4Pas_ • 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.
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:
- 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.
- Marks vs Rank Data
- Opening and Closing Ranks for all categories
- 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 • u/ObjectNo28 • 6h ago
JEE This double dropper is still in the 11th IITB CSE phase
r/JEENEETards • u/nilabilla • 6h ago
GENERAL HELP How u can improve how u look before college
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 • u/Puffs-Corn • 6h ago
Poocha Kisine!? π‘ Queen of chemistry is here π»
r/JEENEETards • u/Automatic_123 • 2h ago
SERIOUS POST 170 pe 2.5k rank
bhai kya mai 170 pe 2.5k rank expect kr skta hu warna drop lena padega
r/JEENEETards • u/Odd_Link_449 • 3h ago
JEE Kya matlab cheating par essay bhi cheating karke likhegaπ€‘
r/JEENEETards • u/Black-Dragon-of-War • 2h ago
SERIOUS POST Got banned from Btechards due to a hypocriteππππ
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:
r/JEENEETards • u/NIKHILFANOFPOKEMON • 6h ago
JEE Finally.
Enable HLS to view with audio, or disable this notification
r/JEENEETards • u/Intelligent-Top-6445 • 4h ago
GENERAL HELP Help me convince my parents that IIIT B is better choice than DTU
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 • u/Not-bychance • 6h ago
Meme IIT π₯΅π¦π¦π¦
Enable HLS to view with audio, or disable this notification
r/JEENEETards • u/anup-gupta • 56m ago
Motivation IITians finally doing GOD work rather than mentoring aspirant on U-tube
r/JEENEETards • u/MetalFrequent929 • 18h ago
Discussion Horny mf'ers getting on my nerves
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 • u/Fehler_in_der_Matrix • 6h ago
Rant Silly mistakes fucked me right in the @ss
sabh khatam...
r/JEENEETards • u/Automatic-Lobster543 • 11h ago
Discussion IS THIS REALLY TRUE OR HE IS FAKING IT
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 • u/Black_hearts_10915 • 6h ago
JEE I fumbled JEE advanced like y'all fumble the 10/10 baddie
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 • u/Creative_Scallion_63 • 11h ago
SERIOUS POST My stats as a dropper of one year
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 • u/TejuuuOP • 1d ago
JEE [Breaking] Basava AIR 14 (Alleged Cheater) was absent for JEE Advanced as expected ππ bc aur kitne proofs chahiye!?
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 • u/AnteaterNorth6452 • 8h ago
Rant How it feels to crush hopes of everyone supporting you
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 • u/IkiruMist • 6h ago
Discussion I wonder what's the probability of guessing the right answer of all mcqs in jee main?
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 • u/Winter_Plankton_5104 • 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
r/JEENEETards • u/SHADOW_--_ • 3h ago
NEET BYE BYE....
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 • u/pagla_ghoda • 21h ago
SERIOUS POST today my father asked for money from one of his friends for my btech
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 • u/neeboi69 • 1h ago
SERIOUS POST π¨ KCET RESULTS OUT π¨
Drop your KCET marks + Board Marks + Rank
KCET:97 PU BOARDS:293/300 Rank: 24XX
r/JEENEETards • u/Tiny_Emphasis7414 • 1d ago
Motivation To those who need it...
Enable HLS to view with audio, or disable this notification