2013-2014 Admissions Spreadsheets Forum

[Kimikho]

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 :/

[lawschool22]

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

[lawschool22]

I shouldn't have looked at the spreadsheet . Just realized someone messed up the headings. Now to fix it...

[lawschool22]

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.

[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.

[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.

[neprep]

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.

[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

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

[wtrc]

The next 7 days will have lots of movement.

[Kimikho]

The next 7 days will have lots of movement.

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.

[TheMostDangerousLG]

The next 7 days will have lots of movement.

Why you say that?

[midwest17]

What's up with the colors in the Harvard spreadsheet?

[lawschool22]

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.

[midwest17]

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.

[lawschool22]

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.

[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...

[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...

Also Georgetown.

[Kimikho]

[Kimikho]

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.

[Pishee77]

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 -_-

[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.

[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 )

[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

[lawschool22]

Added to the OP. Thanks scoobs

[lawschool22]

I adjusted the Harvard colors as well. Let me know if these work better.