2013-2014 Admissions Spreadsheets

Share Your Experiences, Read About Other Experiences. Please keep posts organized by school and expected year of graduation.
NYC-WVU
Posts: 276
Joined: Tue Nov 19, 2013 5:38 pm

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Postby NYC-WVU » Mon Dec 09, 2013 12:41 pm

In no way do I condone people messing with the spreadsheets - if they really want to play around with the numbers, they should copy everything into a new spreadsheet where they can do whatever they want. On the other hand, if people are consistently being obnoxious about this, why don't you lock the filled pages, add new input pages and periodically transfer the data from the new input pages into the locked filled page. I'm sure there are a few people that you could give access to who would help you out in the transferring.

User avatar
lawschool22
Posts: 3875
Joined: Thu Jul 25, 2013 5:47 pm

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Postby lawschool22 » Mon Dec 09, 2013 12:48 pm

NYC-WVU wrote:In no way do I condone people messing with the spreadsheets - if they really want to play around with the numbers, they should copy everything into a new spreadsheet where they can do whatever they want. On the other hand, if people are consistently being obnoxious about this, why don't you lock the filled pages, add new input pages and periodically transfer the data from the new input pages into the locked filled page. I'm sure there are a few people that you could give access to who would help you out in the transferring.


The problem with that is when people need to add updates (interview date, acceptances, etc.) they wouldn't have access to the main data tab, so you would also have to monitor their updates and update the main data tab accordingly. I don't think it's feasible unfortunately.

NYC-WVU
Posts: 276
Joined: Tue Nov 19, 2013 5:38 pm

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Postby NYC-WVU » Mon Dec 09, 2013 1:01 pm

lawschool22 wrote:
NYC-WVU wrote:In no way do I condone people messing with the spreadsheets - if they really want to play around with the numbers, they should copy everything into a new spreadsheet where they can do whatever they want. On the other hand, if people are consistently being obnoxious about this, why don't you lock the filled pages, add new input pages and periodically transfer the data from the new input pages into the locked filled page. I'm sure there are a few people that you could give access to who would help you out in the transferring.


The problem with that is when people need to add updates (interview date, acceptances, etc.) they wouldn't have access to the main data tab, so you would also have to monitor their updates and update the main data tab accordingly. I don't think it's feasible unfortunately.

Good point, I hadn't thought of that. My bad.

Kimikho
Posts: 3971
Joined: Fri Mar 16, 2012 7:01 pm

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Postby Kimikho » Mon Dec 09, 2013 1:14 pm

:lol:

"your friendly neighborhood scoobers"

User avatar
lawschool22
Posts: 3875
Joined: Thu Jul 25, 2013 5:47 pm

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Postby lawschool22 » Mon Dec 09, 2013 1:19 pm

scoobers wrote::lol:

"your friendly neighborhood scoobers"


It seemed to fit :D. I it contrasted with your message well I thought :)

User avatar
McAvoy
Posts: 1584
Joined: Sun Oct 20, 2013 10:33 pm

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Postby McAvoy » Mon Dec 09, 2013 3:56 pm

I'm confused -- why would people be offended by sorting for LSATs, acceptances, and complete dates? It actually makes the data useful...

User avatar
midwest17
Posts: 1686
Joined: Sat Aug 31, 2013 5:27 pm

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Postby midwest17 » Mon Dec 09, 2013 4:03 pm

Will_McAvoy wrote:I'm confused -- why would people be offended by sorting for LSATs, acceptances, and complete dates? It actually makes the data useful...


Because people keep screwing it up.

User avatar
midwest17
Posts: 1686
Joined: Sat Aug 31, 2013 5:27 pm

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Postby midwest17 » Mon Dec 09, 2013 4:03 pm

double post
Last edited by midwest17 on Mon Dec 09, 2013 4:07 pm, edited 1 time in total.

User avatar
lawschool22
Posts: 3875
Joined: Thu Jul 25, 2013 5:47 pm

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Postby lawschool22 » Mon Dec 09, 2013 4:05 pm

Will_McAvoy wrote:I'm confused -- why would people be offended by sorting for LSATs, acceptances, and complete dates? It actually makes the data useful...


Some people do not know how to properly sort or filter the data. For example they only sort one column which then mis-aligns the data and makes it useless.

The data is primarily useful because of the first tab I created. As I mentioned in my initial post, if there is something people want to see or learn from the data that they can't already do from the analytics tab, I would be happy to write a new formula that displays the data in whatever format is needed :)

User avatar
McAvoy
Posts: 1584
Joined: Sun Oct 20, 2013 10:33 pm

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Postby McAvoy » Mon Dec 09, 2013 4:19 pm

Ah, that seems reasonable, then. Dummies :)

User avatar
midwest17
Posts: 1686
Joined: Sat Aug 31, 2013 5:27 pm

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Postby midwest17 » Mon Dec 09, 2013 7:26 pm

LS22: It looks like there might be a problem with the coloring of the LSATs in the Duke spreadsheet? gfm, for instance, has a 167 LSAT which is being coded as >75th, even though it's below median. I'm not sure if there are more examples of the problem other than that one, but I'm leery of messing it up so I just wanted to let you know rather than investigating further on my own.

User avatar
lawschool22
Posts: 3875
Joined: Thu Jul 25, 2013 5:47 pm

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Postby lawschool22 » Wed Dec 11, 2013 11:46 am

midwest17 wrote:LS22: It looks like there might be a problem with the coloring of the LSATs in the Duke spreadsheet? gfm, for instance, has a 167 LSAT which is being coded as >75th, even though it's below median. I'm not sure if there are more examples of the problem other than that one, but I'm leery of messing it up so I just wanted to let you know rather than investigating further on my own.


I'll look into it. Sorry for the delay.

User avatar
lawschool22
Posts: 3875
Joined: Thu Jul 25, 2013 5:47 pm

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Postby lawschool22 » Wed Dec 11, 2013 11:48 am

lawschool22 wrote:
midwest17 wrote:LS22: It looks like there might be a problem with the coloring of the LSATs in the Duke spreadsheet? gfm, for instance, has a 167 LSAT which is being coded as >75th, even though it's below median. I'm not sure if there are more examples of the problem other than that one, but I'm leery of messing it up so I just wanted to let you know rather than investigating further on my own.


I'll look into it. Sorry for the delay.


I didn't see that example...from what I can tell everything looks okay. But if there is still an issue let me know!

User avatar
midwest17
Posts: 1686
Joined: Sat Aug 31, 2013 5:27 pm

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Postby midwest17 » Wed Dec 11, 2013 12:25 pm

lawschool22 wrote:
lawschool22 wrote:
midwest17 wrote:LS22: It looks like there might be a problem with the coloring of the LSATs in the Duke spreadsheet? gfm, for instance, has a 167 LSAT which is being coded as >75th, even though it's below median. I'm not sure if there are more examples of the problem other than that one, but I'm leery of messing it up so I just wanted to let you know rather than investigating further on my own.


I'll look into it. Sorry for the delay.


I didn't see that example...from what I can tell everything looks okay. But if there is still an issue let me know!


I think I may have just been flipping the LSAT and GPA percentile cells in my head....

:oops: :oops: :oops: :oops: :oops: :oops:

User avatar
lawschool22
Posts: 3875
Joined: Thu Jul 25, 2013 5:47 pm

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Postby lawschool22 » Wed Dec 11, 2013 12:47 pm

midwest17 wrote:
lawschool22 wrote:
lawschool22 wrote:
midwest17 wrote:LS22: It looks like there might be a problem with the coloring of the LSATs in the Duke spreadsheet? gfm, for instance, has a 167 LSAT which is being coded as >75th, even though it's below median. I'm not sure if there are more examples of the problem other than that one, but I'm leery of messing it up so I just wanted to let you know rather than investigating further on my own.


I'll look into it. Sorry for the delay.


I didn't see that example...from what I can tell everything looks okay. But if there is still an issue let me know!


I think I may have just been flipping the LSAT and GPA percentile cells in my head....

:oops: :oops: :oops: :oops: :oops: :oops:


Ha no worries - I'd rather it be that than some major thing I have to fix :D

User avatar
ZipWhenSheMoves
Posts: 200
Joined: Fri Nov 08, 2013 1:46 pm

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Postby ZipWhenSheMoves » Wed Dec 11, 2013 5:11 pm

Did the URM category disappear from the GULC spreadsheet?

User avatar
scoobysnax
Posts: 208
Joined: Fri Nov 15, 2013 3:51 pm

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Postby scoobysnax » Thu Dec 12, 2013 12:40 pm

Does anyone know where we can find last year's data on how many offers schools made v. actual enrollment? I think I saw a link somewhere on this forum but I can't find it.

User avatar
TheMostDangerousLG
Posts: 1547
Joined: Thu Nov 22, 2012 4:25 am

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Postby TheMostDangerousLG » Thu Dec 12, 2013 1:36 pm

scoobysnax wrote:Does anyone know where we can find last year's data on how many offers schools made v. actual enrollment? I think I saw a link somewhere on this forum but I can't find it.


Here are some very general statistics on how many people got into schools versus how many people enrolled: http://www.lsac.org/lsacresources/data/lsac-volume-summary

Babum
Posts: 192
Joined: Tue Nov 12, 2013 5:55 pm

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Postby Babum » Fri Dec 13, 2013 8:04 am

What about adding a small display stating how many of those accepted were ED and how many weren't?

Just as a suggestion to making these great tools handier.

kris4842
Posts: 100
Joined: Mon Oct 28, 2013 12:04 pm

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Postby kris4842 » Mon Dec 16, 2013 3:07 pm

Also on another board this was extremely helpful, just google x school and standard 509 report and it tells you everything

User avatar
Trig
Posts: 219
Joined: Tue Jul 02, 2013 3:36 pm

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Postby Trig » Thu Dec 19, 2013 11:51 am

LS22,

Thanks so much for all the spreadsheets. On the Harvard spreadsheet can you include the % of applicants with a JS1 who have been accepted so far?

Thanks!

User avatar
lawschool22
Posts: 3875
Joined: Thu Jul 25, 2013 5:47 pm

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Postby lawschool22 » Thu Dec 19, 2013 11:55 am

Southbridge wrote:LS22,

Thanks so much for all the spreadsheets. On the Harvard spreadsheet can you include the % of applicants with a JS1 who have been accepted so far?

Thanks!


Added! It's in the JS1 section. Good suggestion. Thanks!

User avatar
Nonconsecutive
Posts: 2240
Joined: Thu Sep 27, 2012 4:58 pm

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Postby Nonconsecutive » Thu Dec 19, 2013 3:57 pm

lawschool22 wrote:Added! It's in the JS1 section. Good suggestion. Thanks!


Thanks for doing that, glad to see you keeping on top of your spreadsheet army. :)

User avatar
Black_Swan
Posts: 238
Joined: Mon Dec 09, 2013 12:47 pm

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Postby Black_Swan » Fri Dec 20, 2013 5:30 pm

nothingtosee wrote:THANK YOU


Nice picture! Do you work for lsac?

Kimikho
Posts: 3971
Joined: Fri Mar 16, 2012 7:01 pm

Re: 2013-2014 Admissions Results: Spreadsheet Compendium

Postby Kimikho » Sun Dec 22, 2013 5:21 pm

LS22 what did your lsat tracking spreadsheets look like?




Return to “Law School Acceptances, Denials, and Waitlists”

Who is online

Users browsing this forum: tinafeyclone and 11 guests