Page 6 of 12

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Posted: Mon Dec 02, 2013 3:13 pm
by Kimikho
lawschool22 wrote:I have noticed some of these are getting close to the 150 line limit. I don't have time at work to update or monitor them all right now, but when they start getting close, please let me know ITT and I will update accordingly.


jeez i didn't even know there was a 150 line limit.

ifffffff you aren't to busy prepping for your JS1, could you fix the colors in the Harvard spreadsheet?

on that note, what can and can't we edit in there that will mess up everything you've so graciously done for us? like i'd fix the colors myself but i don't want to ruin it :/

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Posted: Mon Dec 02, 2013 3:40 pm
by lawschool22
scoobers wrote:
lawschool22 wrote:I have noticed some of these are getting close to the 150 line limit. I don't have time at work to update or monitor them all right now, but when they start getting close, please let me know ITT and I will update accordingly.


jeez i didn't even know there was a 150 line limit.

ifffffff you aren't to busy prepping for your JS1, could you fix the colors in the Harvard spreadsheet?

on that note, what can and can't we edit in there that will mess up everything you've so graciously done for us? like i'd fix the colors myself but i don't want to ruin it :/


I think you should be able to fix the colors - they use conditional formatting, so if you're familiar with that function, you have my blessing :D

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Posted: Mon Dec 02, 2013 3:42 pm
by lawschool22
I shouldn't have looked at the spreadsheet :). Just realized someone messed up the headings. Now to fix it...

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Posted: Mon Dec 02, 2013 3:54 pm
by lawschool22
scoobers wrote:
lawschool22 wrote:I have noticed some of these are getting close to the 150 line limit. I don't have time at work to update or monitor them all right now, but when they start getting close, please let me know ITT and I will update accordingly.


jeez i didn't even know there was a 150 line limit.


Just fixed the HLS limit, which I believe was the closest to 150.

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Posted: Tue Dec 03, 2013 7:05 am
by neprep
Someone had entered his or her interview request date incorrectly (it appeared as though the request had been made in 2012). I made the reasonable assumption that whoever it was meant 2013 and not 2012.

This error was messing up the Average Days Between Complete and Interview Request metric; after fixing the error, it went from 8 days to 79 days, which is much more in line with what we've been hearing.

Please be careful when populating the date fields, people!

ETA: I was talking about the Chicago spreadsheet, by the way.

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Posted: Tue Dec 03, 2013 7:31 am
by lawschool22
Thanks for fixing, nep! As you an imagine it is difficult for me to keep an eye on all of these, so I appreciate the help.

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Posted: Tue Dec 03, 2013 7:51 am
by neprep
lawschool22 wrote:Thanks for fixing, nep! As you an imagine it is difficult for me to keep an eye on all of these, so I appreciate the help.


No problem! You can't possibly keep checking 12 sheets over and over by yourself. :)

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Posted: Wed Dec 04, 2013 2:49 pm
by ZipWhenSheMoves
Seems like something is up with the NYU spreadsheet- it isn't displaying all the entries (skips from number 8 to 20 for example). I don't want to mess with it myself in case I accidentally screw it up :P

EDIT- Ignore me, I figured it out- someone filtered it to just show acceptances. That I can fix without messing it up.

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Posted: Wed Dec 04, 2013 8:59 pm
by wtrc
The next 7 days will have lots of movement.

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Posted: Wed Dec 04, 2013 9:03 pm
by Kimikho
wtrc wrote:The next 7 days will have lots of movement.


wtrc wrote:
scoobers wrote:
wtrc wrote:First round of JS2's for Harvard will be Monday. And it'll be a big round.

what are your predictions for people who submitted on Sunday.

asking for a friend


Will go complete Friday, JS1's the end of the week after Thanksgiving, if applicable.


:evil:

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Posted: Wed Dec 04, 2013 10:45 pm
by TheMostDangerousLG
wtrc wrote:The next 7 days will have lots of movement.


Why you say that? :shock:

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Posted: Fri Dec 06, 2013 12:23 pm
by midwest17
What's up with the colors in the Harvard spreadsheet?

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Posted: Fri Dec 06, 2013 12:28 pm
by lawschool22
midwest17 wrote:What's up with the colors in the Harvard spreadsheet?


I'm not sure - someone decided to get creative I guess. I do see what they did - they simply went down Google's color scale from top to bottom for highest to lowest. If you guys want I can change it back to whatever you prefer.

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Posted: Fri Dec 06, 2013 12:43 pm
by midwest17
lawschool22 wrote:
midwest17 wrote:What's up with the colors in the Harvard spreadsheet?


I'm not sure - someone decided to get creative I guess. I do see what they did - they simply went down Google's color scale from top to bottom for highest to lowest. If you guys want I can change it back to whatever you prefer.


Personally I find red/yellow/green the easiest to understand, but I also see how that could be difficult for people with certain kinds of color blindness.

I think the key thing is to only have 2 or 3 colors, and use shades beyond that. There's just too wide a variance right now.

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Posted: Fri Dec 06, 2013 12:44 pm
by lawschool22
midwest17 wrote:
lawschool22 wrote:
midwest17 wrote:What's up with the colors in the Harvard spreadsheet?


I'm not sure - someone decided to get creative I guess. I do see what they did - they simply went down Google's color scale from top to bottom for highest to lowest. If you guys want I can change it back to whatever you prefer.


Personally I find red/yellow/green the easiest to understand, but I also see how that could be difficult for people with certain kinds of color blindness.

I think the key thing is to only have 2 or 3 colors, and use shades beyond that. There's just too wide a variance right now.


I agree. I'll fix it.

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Posted: Sat Dec 07, 2013 6:20 pm
by midwest17
Looks like someone sorted the Duke spreadsheet a while ago and screwed up all the LSAT scores. Probably too long ago to be worth reverting, but people should fix their numbers... and people should stop trying to sort things...

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Posted: Sat Dec 07, 2013 6:25 pm
by midwest17
midwest17 wrote:Looks like someone sorted the Duke spreadsheet a while ago and screwed up all the LSAT scores. Probably too long ago to be worth reverting, but people should fix their numbers... and people should stop trying to sort things...


Also Georgetown.

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Posted: Sat Dec 07, 2013 6:28 pm
by Kimikho
Image

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Posted: Sat Dec 07, 2013 6:30 pm
by Kimikho
midwest17 wrote:
midwest17 wrote:Looks like someone sorted the Duke spreadsheet a while ago and screwed up all the LSAT scores. Probably too long ago to be worth reverting, but people should fix their numbers... and people should stop trying to sort things...


Also Georgetown.


and yeah, gtown is really messed up. the cells also aren't responding to the colors anymore.

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Posted: Sun Dec 08, 2013 4:55 pm
by Pishee77
scoobers wrote:
midwest17 wrote:
midwest17 wrote:Looks like someone sorted the Duke spreadsheet a while ago and screwed up all the LSAT scores. Probably too long ago to be worth reverting, but people should fix their numbers... and people should stop trying to sort things...


Also Georgetown.


and yeah, gtown is really messed up. the cells also aren't responding to the colors anymore.
Problem with NYU too -_-

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Posted: Sun Dec 08, 2013 5:06 pm
by lawschool22
Sorry guys I've been very busy this weekend. I'll try to get on tonight and fix them. Thanks for the message scoobs. I'm going to add to the OP.

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Posted: Mon Dec 09, 2013 11:28 am
by lawschool22
Sorry everyone, due to misuse of the GULC spreadsheet, it was restored to a version as of 12/3/13 at 5pm. Any changes made since that date will need to be re-entered. I apologize.

Let me reiterate: Please do not filter or sort, as there is a large likelihood of screwing something up if you do not know what you are doing (which recent history suggests is at least two users of this spreadsheet :D)

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Posted: Mon Dec 09, 2013 11:38 am
by lawschool22
Duke and NYU seem okay to me...what was wrong with them? I just need to know so I can try to fix it if there is still something messed up :)

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Posted: Mon Dec 09, 2013 11:39 am
by lawschool22
scoobers wrote:Image


Added to the OP. Thanks scoobs :D

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Posted: Mon Dec 09, 2013 12:29 pm
by lawschool22
I adjusted the Harvard colors as well. Let me know if these work better.